<CFQUERY Name="Tech" DataSource="#DSNCCare#">
select *
from nxsteche
where tech_code = '#tech#'
</CFQUERY>
<CFQUERY Name="CASES" DataSource="#DSNCCare#">
SELECT DISTINCT nxstar_e.tar_num, nxstar_e.bus_name, nxstar_e.cust_code,
nxstar_e.tar_status, Max(nxsprodr.prod_desc) AS prod_desc,
nxstar_e.assigned_to,
nxstar_e.synopsis, nxstar_e.phone, nxstar_e.entered_date,
nxstar_e.symptom_code,
Count(nxsnotes.id) AS activities, nxstar_e.contact
FROM nxsnotes
INNER JOIN (
(nxstar_e INNER JOIN nxsregir ON nxstar_e.cust_code =
nxsregir.cust_code)
INNER JOIN nxsprodr ON nxsregir.prod_id = nxsprodr.prod_code)
ON nxsnotes.note_id = nxstar_e.tar_num
GROUP BY nxstar_e.tar_num, nxstar_e.bus_name, nxstar_e.tar_status,
nxstar_e.cust_code, nxstar_e.assigned_to,
nxstar_e.synopsis,
nxstar_e.phone, nxstar_e.contact, nxstar_e.symptom_code,
nxstar_e.entered_date
HAVING ((nxstar_e.tar_status <>'CLOSED') AND
(nxstar_e.assigned_to = '#tech#')
ORDER BY nxstar_e.tar_num
</CFQUERY>
Above are two queries that drive a response page...where on this page
the queries (as you can see) are being driven by the passed parameter
#tech# from the previous page.
In the top query...the query works...
In the bottom query I get an error from coldfusion telling me that
dynamic text can not be represented as strings...
Ok if that's true...then why did the first query work that's right above it
on the same page ?
Any hope here...?
Miles.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.
