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]
