Pascal
PS Of course, here it's only 10am ;)
> -----Original Message-----
> From: dave [mailto:[EMAIL PROTECTED]
> Sent: 15 October 2004 09:10
> To: CF-Talk
> Subject: RE: late night query ?
>
> i been working since 9am (now 1am) so my train of thought is on the
booty
> call i shoulda went and got, lol dammit!
>
> 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]
