From: Deanna Schneider
Date: Fri, 25 Jun 2004 10:34:14 -0500
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.
ok...thanks
Oh, and you might have better luck getting technical answers on
cf-talk (and refraining from calling people "dawgs").
yo...yo
----- 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]
