Help with SQL

Results 1 to 3 of 3

Thread: Help with SQL

  1. #1
    Big Al Guest

    Default Help with SQL

    I have the following SQL statment which sort of works..<BR><BR>SQL = "select * FROM "<BR>SQL = SQL & quest<BR>SQL = SQL & " WHERE id = "<BR>SQL = SQL & RadNum<BR><BR>quest a varable wbhich stores the table name and radnum is a randon number. but it only brings the first record back any one got any ideas how I make it get the right result<BR>

  2. #2
    Join Date
    Dec 1969

    Default Give us a code

    by the way do you loop through the recordset?

  3. #3
    Big Al Guest

    Default RE: Give us a code

    I t should only bring one record back so no I haven&#039t been looping though should I....

Posting Permissions

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