It seems that field "nxstar_e.assigned_to" is numeric type (like '#cookie.user_id#'), and '#tech' is char. Miguel Gonzalez www.ibcmass.com mailto:[EMAIL PROTECTED] > -----Mensaje original----- > De: miles [mailto:[EMAIL PROTECTED]] > Enviado el: jueves 10 de agosto de 2000 13:36 > Para: [EMAIL PROTECTED] > Asunto: round 3: HELP with Query. > > > 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=list s/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ------------------------------------------------------------------------------ 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.
