1.) <CFQUERY Name="Tech" DataSource="#DSNCCare#">
select *
from nxsteche
where tech_code = '#tech#'
</CFQUERY>
2.) <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>
Hi...
I sent the above queries to the list...but I haven't recieved anything from
the list, no mail at all from the list all day long...so Im assuming
that the list
is down AGAIN. In the hopes that its just a portion of the list that's down...
the portion that Im in....Im resending this.
In a previous msg I asked what was wrong with query #2...well I
figured out that
I was missing a closing ")" in the HAVING statement. All fine and good...but
didn't solve my problem of why one parameter is getting passed to the first
query (#1) and yet query #2 gives me an error of :
"expression result cannot be converted into a string"
Im figuring this is a simple syntax error...right ? wrong. In CF Studio's
SQL builder...this query returns results with no errors.
Ok...so whats wrong ?
Please respond to me privately at [EMAIL PROTECTED]
Miles.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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.