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.
Here's the problem....both queries are being passed the parameter
#tech# on the same page. Query 1 returns results. Query 2 gives me
the following error at the '#tech#' statement.:
"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. Further
this same query works just fine if I replace '#tech#' with
'#cookie.user_id#'. I can place an a literal value there and the
query works... so what am I missing ? 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.
