Results 1 to 3 of 3

Thread: Select Statement

  1. Apr 6th, 2003, 06:10 PM #1
    Smiler
    Smiler is offline

    Thread Starter
    New Member
    Join Date
    Apr 2003
    Posts
    5

    Cool Select Statement

    When I run this query I get an error of:

    Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

    [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'CatCode='.

    /projectli/ass1/managehomes.asp, line 79

    The query is listed below:

    objRS.open "Select * FROM Choice WHERE CatCode=" & taste

    Can you help me please
    Reply With Quote Reply With Quote
  2. Apr 6th, 2003, 06:42 PM #2
    MarkusJ_NZ
    MarkusJ_NZ is offline
    Hyperactive Member MarkusJ_NZ's Avatar
    Join Date
    Jun 2001
    Posts
    375
    You might have to enclose the CatCode variable in '

    e.g

    VB Code:
    1. objRS.open "Select * FROM Choice WHERE CatCode='" & taste & "'"

    Cheers
    Markus
    Reply With Quote Reply With Quote
  3. Apr 7th, 2003, 09:44 AM #3
    andreys
    andreys is offline
    Frenzied Member andreys's Avatar
    Join Date
    Sep 2002
    Location
    Los Angeles
    Posts
    1,615
    OR

    your "taste" variable is empty.
    check it by typing

    response.write "taste value =" & taste
    response.end

    in front of your sql statement.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width