Display select results

Results 1 to 3 of 3

Thread: Display select results

  1. #1
    Rick B Guest

    Default Display select results

    How can I display the results of my select statement? I have tried many versions of the following code.<BR><BR>sql = "SELECT * FROM ftpaccess Where ([supervisor fname] = &#039;rick&#039;)"<BR> rik = objConn.execute(sql)<BR> <BR> response.write rik<BR><BR><BR><BR>Thanx

  2. #2
    Join Date
    Dec 1969

    Default Get yourself a good book

    set rik = objConn.execute(sql). Then in a loop you have to display the results and when I say loop I mean you have to loop through the recordset.<BR><BR>Brain Power.

  3. #3
    Join Date
    Dec 1969

    Default RE: Display select results

    hey dude, your code would look something like this<BR><BR>set sql = "blah blah"<BR>set rik = objConn.Execute(sql)<BR>rik.movefirst<BR>while not rik.eof do<BR>Response.write(rik("value"))<BR><BR>rik.move next;<BR>loop

Posting Permissions

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