-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 03, 2004 11:16 AM
To: CF-Talk
Subject: RE: recordcount in loop
Here is the query I made, but I get this error:
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax
near '='.
<cfquery name="getclaims" datasource="">
select claimdetails.claimid, claimdsheader.claimid,
claimsheader.participantid, claimdetails.modelid from claimsheader,
claimdetails
where claimsheader.participantid = '#cookie.theviewuser#' AND
claimsheader.claimid = claimdetails.claimid
</cfquery>
Any ideas what is wrong?
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
