Re: late night query ?

[dave]

i think the killer here is that this usercards.cardID = tblcards.cardID could be 1 record or 7000, so maybe have to loop it or maybe qoq

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

---