Hi Steve, You have a copy of my Tango Debugging Tools don't you? If so, connect to your datasource, copy your select statement from the debug code and paste it in the SQL Command window. Then tweak it manually until you get the syntax just right. Maybe the column UDisabled is not a text datatype, so you wouldn't want the value quoted.
ie SELECT U1.UPWHint,U1.UEmail FROM User U1 WHERE (U1.UEmail='fog' AND U1.UDisabled=1) Dave -----Original Message----- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 5:38 PM To: Witango User Group (E-mail) Subject: Witango-Talk: Search Action I am testing Witango 5.5.003 with Oterro 3.0 I am using a simple Search Action and I have a couple questions about the following debug: 1) Why does Witango change the SQL and use '?' for the variable values and then show them in BoundVals? 2) Any ideas about the syntax error? [Query] [382] SELECT U1.UPWHint,U1.UEmail FROM User U1 WHERE (U1.UEmail=? AND U1.UDisabled=?) [BoundVals] [382] [v1='fog'; v2='1'] [Error] [396] 2367 [RBTI][Oterro ODBC Driver][Sports]-ERROR- Syntax error (2367) 42000 Thanks Steve Fogelson Internet Commerce Solutions ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
