CF Expersts...Help!

  • Started
  • Last post
  • 0 Responses
  • kinetic

    im formulating a dynamic query with coldfusion and then placing the var in the query tags like so:

    #query3#

    the firest query3 will work fine...no problems at all there (its pretty simple), but the second one screws up everytime. it gives me a database error:

    "Error Executing Database Query.
    You have an error in your SQL syntax near 'C2VLUKY139'' AND u.user_id = l.user_id AND l.user_id != ''1171'' AND l.user_id !' at line 1 "

    anyone know how i can get that query to run ok in cf
    db is mysql by the way

    thanks in advance!!

    kinetic
    Flag