1. <CFQUERY NAME="p_swap" DATASOURCE="ccmast">
SELECT dbo.nxsprodr.prod_desc, dbo.nxsprodr.prod_code
FROM dbo.nxsprodr, dbo.nxsregir
WHERE dbo.nxsprodr.prod_code = dbo.nxsregir.prod_id
</CFQUERY>
2. <CFQUERY NAME="software" DATASOURCE="ccmast">
SELECT *
FROM dbo.nxsregir
WHERE cust_code = #Cookie.User_Id#
</CFQUERY>
In the FIRST query above when I go to output the results of this join...
How would I reference the columns ?
Especially when I want to do a comparison up against the
second query ?
<cfif #p_swap.dbo.nxsprodr.prod_code# = #software.prod_id#>
#p_swap.dbo.nxsprodr.prod_desc#
<cfelse>
UPDATE
</cfif>
If I do the above I get an error telling me that the column
dbo.nxsprodr.prod_desc does not exist in the query p_swap.
What am I doing wrong ?
Miles.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
