and i need to run another query thats uses those numbers to get descriptions outta another table
the basic query is this
<cfquery name="qCards" datasource="#dsn#" username="#un#" password="#pw#">
SELECT cardID
FROM userscards
WHERE usersID = <cfqueryparam value="#guserID#" cfsqltype="cf_sql_integer">
</cfquery>
the other tables is called "tblcards" and i need to match the list from the 1st query to get all the descriptions from this one from a field called "CardID"
brain is mush, any help?
tia
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]