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.

Reply via email to