Professional Web Applications Themes

i need to get a field from a record - Microsoft SQL / MS SQL Server

The following code finds an image from a record: sqlCmd.CommandText = "SELECT ImageID FROM TBL_Seller WHERE SellerID = '" & Session("SellerID") & "'" dreader = sqlCmd.ExecuteReader While dreader.Read() ImageID = dreader("ImageID") ImageID2 = String.Copy(Trim(ImageID)) [/ref][/ref] | sw.WriteLine(ClientID2, ",", ImageID2) | End While | how can i also grab the ClientID2 field from that record and put it in a string? thanks, Trint Net programmer com *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...

  1. #1

    Default i need to get a field from a record

    The following code finds an image from a record:

    sqlCmd.CommandText = "SELECT ImageID FROM TBL_Seller WHERE SellerID = '"
    & Session("SellerID") & "'"
    dreader = sqlCmd.ExecuteReader

    While dreader.Read()
    ImageID = dreader("ImageID")
    ImageID2 = String.Copy(Trim(ImageID)) [/ref][/ref]
    | sw.WriteLine(ClientID2, ",", ImageID2)
    | End While
    |
    how can i also grab the ClientID2 field from that record and put it in a
    string?
    thanks,
    Trint

    Net programmer
    com

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Trint Guest

  2. #2

    Default Re: i need to get a field from a record

    sqlCmd.CommandText = "SELECT ImageID, ClientID2 FROM TBL_Seller WHERE
    SellerID = '"& Session("SellerID") & "'"
    dreader = sqlCmd.ExecuteReader

    While dreader.Read()
    ImageID = dreader("ImageID")
    ClientID2 = dreader("ClientID2")
    ....

    --
    David Portas
    ------------
    Please reply only to the newsgroup
    --


    David Guest

  3. #3

    Default Re: i need to get a field from a record

    thanks i'll try that right now
    trint

    .Net programmer
    com

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Trint Guest

Similar Threads

  1. Compare record field with another record field of samerecordset
    By WolfShade_2k in forum Coldfusion - Advanced Techniques
    Replies: 3
    Last Post: May 12th, 02:42 PM
  2. searching field by field one record at a time
    By eric in forum Microsoft Access
    Replies: 16
    Last Post: September 1st, 04:54 PM
  3. Replies: 4
    Last Post: August 13th, 11:03 PM
  4. field position when going to the next record
    By Asha in forum Microsoft Access
    Replies: 2
    Last Post: August 9th, 11:59 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139