whats wrong here...

Results 1 to 2 of 2

Thread: whats wrong here...

  1. #1
    ASPTOOLS Guest

    Default whats wrong here...

    I&#039m trying to open a table in the database and then only grab the recordsets with certain username in them. This is the SQL statment I used<BR>----------<BR>SQLSelect = "select * from users where username = " & user<BR>----------<BR>When I execute the script it says: <BR>Too few parameters. Expected 1. <BR><BR><BR>So anyone who has some idea of what is wrong please help.<BR><BR>Thanks in advance,<BR>ASPTOOLS

  2. #2
    Join Date
    Dec 1969

    Default RE: whats wrong here...

    Assuming that username is a string field, you need to quote the value.<BR><BR>SQLSelect = "select * from users where username = &#039" & user & "&#039"<BR>

Posting Permissions

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