Will this work ?
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the
keyword 'WHERE'.
The error occurred in
C:\Inetpub\REIAColumbus\admin\members\searchFunction\searchOneOfTwo.cfm:
line 198
Called from C:\Inetpub\REIAColumbus\admin\members\main.cfm: line 29
Called from
C:\Inetpub\REIAColumbus\admin\members\searchFunction\searchOneOfTwo.cfm:
line 198
Called from C:\Inetpub\REIAColumbus\admin\members\main.cfm: line 29
196 : AND T.transactionDate <=
#CreateODBCDate(SESSION.memberList.DateThru)#
197 : </cfif>
198 : </cfif>
199 :
200 : GROUP BY M.memberID, M.firstName, M.middleName, M.lastName, M.email,
M.company, M.city, M.zip, M.memberLevelID, T.paidThru, T.transactionDate,
T.memberID
SQL SELECT M.firstName, M.middleName, M.lastName, M.email, M.company,
M.city, M.zip, M.memberID, M.memberLevelID FROM reiacolumbus_Members_List M
WHERE M.memberID = (SELECT TOP 1 T.transactionID, T.paidThru,
T.transactionDate, T.memberID FROM reiacolumbus_Members_TransactionLog T)
AND WHERE (M.firstName LIKE '%%' OR M.lastName LIKE '%%' OR M.email LIKE
'%%' OR M.company LIKE '%%' OR M.city LIKE '%%' OR M.zip LIKE '%%' ) GROUP
BY M.memberID, M.firstName, M.middleName, M.lastName, M.email, M.company,
M.city, M.zip, M.memberLevelID, T.paidThru, T.transactionDate, T.memberID
DATASOURCE dedb49
VENDORERRORCODE 156
SQLSTATE HY000
_____
From: Alexander Sherwood [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 18, 2004 12:15 PM
To: CF-Talk
Subject: RE: SQL Query problem
At 12:05 PM 8/18/2004, you wrote:
>OK, a couple of things:
>1) Below is the complete code for the query page.
Sorry....I meant the actual SQL code that gets passed to the DB. CF will
display the actual, parsed SQL code in the debugging output.
Could you post this?
Thanks!
--
Alex
_____
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
- Re: Best practices storing CC Jim McAtee
- Re: Best practices storing CC BILLY CRAVENS
- SQL Query problem Mark Leder
- Re: SQL Query problem Alexander Sherwood
- RE: SQL Query problem Mark Leder
- RE: SQL Query problem Alexander Sherwood
- RE: SQL Query problem Mark Leder
- RE: SQL Query problem Alexander Sherwood
- RE: SQL Query problem Mark Leder
- RE: SQL Query problem Alexander Sherwood
- Re: SQL Query problem Mark Leder
- Re: SQL Query problem Marc Lowe
- RE: SQL Query problem Mark Leder
- RE: SQL Query problem Mark Leder
- RE: SQL Query problem Tangorre, Michael
- RE: SQL Query problem Mark Leder
- RE: SQL Query problem Tangorre, Michael
- Re: SQL Query problem Marc Lowe
- Re: SQL Query problem Marc Lowe
- RE: SQL Query problem - SOLVED Mark Leder
- RE: SQL Query problem - SOLVED Mark Leder