> -----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]
