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]

Reply via email to