ok, here i'll try and explain better
1st i invoke a cfc (heres the meat of it) this gets the logged in usersname and gives me their userid.
<cfquery name="qgetUser" datasource="#dsn#" username="#un#" password="#pw#">
SELECT userID
FROM users
WHERE username = <cfqueryparam value="#getAuthUser()#" cfsqltype="cf_sql_varchar">
</cfquery>
<cfreturn qgetUser>
from there i query a table called "userscards", what this does is basically run the userID through and gets all the matches, which gives me an output of card#'s like 4434, 2234, 5567.
then i need to run those through another table called "tblcards" and in the output match all the numbers i got from the above query, so that i can get the rest of the details out of that table
ok now i am lost lol
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
