---------- Original Message ----------------------------------
From: "Pascal Peters" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Fri, 15 Oct 2004 10:02:59 +0200
>You are missing the FROM clause
>
>> -----Original Message-----
>> From: dave [mailto:[EMAIL PROTECTED]
>> Sent: 15 October 2004 08:35
>> To: CF-Talk
>> Subject: Re: late night query ?
>>
>> i love it when i make it more complicated then it really iz lol
>>
>> using mysql, its close but i get this error
>>
>> Error Executing Database Query.
>> Syntax error or access violation: You have an error in your SQL
>syntax.
>> Check the manual that corresponds to your MySQL server version for the
>> right syntax to use near 'WHERE usercards.usersID = 1 AND
>usercards.cardID
>> = tblcards.Ca
>>
>> The error occurred in
>> C:\Websites\mtgotradingpos\users\myCards\mycards.cfm: line 24
>>
>> 22 : <cfquery name="qCards" datasource="#dsn#" username="#un#"
>> password="#pw#">
>> 23 : SELECT usercards.cardID, tblcards.CardID
>> 24 : WHERE usercards.usersID = <cfqueryparam value="#guserID#"
>> cfsqltype="cf_sql_integer">
>> 25 : AND usercards.cardID = tblcards.CardID
>> 26 : </cfquery>
>>
>>
>>
>> ---------- Original Message ----------------------------------
>> From: Ricardo Russon <[EMAIL PROTECTED]>
>> Reply-To: [EMAIL PROTECTED]
>> Date: Fri, 15 Oct 2004 16:24:55 +1000
>>
>> >dave.
>> >
>> >What database are you using?
>> >
>> >try..
>> >
>> >SELECT usercards.cardID, tblcards.cardID
>> >WHERE usercards.cardID = <cfqueryparam value="#guserID#"
>> >cfsqltype="cf_sql_integer">
>> >AND usercards.cardID = tblcards.cardID
>> >
>> >Ricardo.
>> >
>>
>>
>>
>>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
