unknown column??

Results 1 to 2 of 2

Thread: unknown column??

  1. #1
    Join Date
    Dec 1969

    Default unknown column??

    This is my error...<BR><BR>Error Type:<BR>Microsoft OLE DB Provider for ODBC Drivers (0x80004005)<BR>[TCX][MyODBC]Unknown column &#039;ter&#039; in &#039;where clause&#039;<BR>/Mypages/Bugs/checkbug.asp, line 12<BR><BR>This is my syntax....<BR><BR>&#039;database/recordset varibles<BR>dim dbconn, check_user, display_bugs<BR><BR>&#039;open the database connection to the database<BR>set dbconn = server.CreateObject("adodb.connection")<BR>dbconn. Open "Nanogen_Forms"<BR><BR>set check_user = dbconn.execute ("select * from users where user_id = ter")<BR><BR>I know that the sql is correct because i can select it from the database. this asp is wrong, but i don&#039;t see it. have been staring forever. help please.<BR>

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default RE: unknown column??

    ("select * from users where user_id = &#039;ter&#039;")

Posting Permissions

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