Some SQL help please

Results 1 to 3 of 3

Thread: Some SQL help please

  1. #1
    adrian Guest

    Default Some SQL help please

    the top line of code works fine but the second is almost the same except it is calling an Autonumber and doesn&#039;t work. Is there a difference when using numbers and letters? Could someone tell me how to fix this.<BR><BR>SQL_query="SELECT * FROM " & tblname & " WHERE Brand=&#039;"&brand&"&#039;"<BR><BR><BR>SQL_query= "SELECT * FROM " & tblname & " WHERE id=&#039;"&id&"&#039;"

  2. #2
    Join Date
    Dec 1969

    Default RE: Some SQL help please

    remove quotes:<BR><BR>..WHERE id="&id<BR>

  3. #3
    Join Date
    Dec 1969

    Default ASPFAQs, category Databases, Errors

    The link to the ASPFAQs is at the top right corner of this page and of most every page on this site.<BR><BR>What book are *you* working from that doesn&#039;t tell you about how text and numeric (and date, in access) fields differ in SQL statements???<BR><BR>You will learn a lot if you can understand all of this page:<BR><BR><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