There's nothing using cfquery dbtype="?" If there's a connection
between the two tables, you could do a join and do one query. But,
since I don't know how the tables are related, I can't help you with
actual code.
Oh, and you might have better luck getting technical answers on
cf-talk (and refraining from calling people "dawgs").
----- Original Message -----
From: Britney Spears
Dawgs,
In my application.cfm file I'm doing two queries on the same database
just different tables. Is there an easier way using, lets say, CFQUERY
DBTYPE=?
<cfquery name="setdata" datasource="#request.dsn_prefs#">
SELECT *
FROM tableData
WHERE strLogin = '#SESSION.user#'
</cfquery>
<cfset session....
<cfset session....
<cfquery name="setref" datasource="#request.dsn_prefs#">
SELECT *
FROM tableref
</cfquery>
<cfset session....
<cfset session....________________________________
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
- re: Using CFQUERY Britney Spears
- Re: Using CFQUERY Deanna Schneider
- Re: Using CFQUERY Britney Spears
- Re: Using CFQUERY Won Lee
- RE: Using CFQUERY Adkins, Randy
- RE: Using CFQUERY Won Lee
- Re: Using CFQUERY Ben Doom
- Re: Using CFQUERY Charlie Griefer
- RE: Using CFQUERY Tony Weeg
- Re: Using CFQUERY Ben Doom
- Re: Using CFQUERY William H Bowen
- RE: Using CFQUERY Tony Weeg