Actually... I think you'll find cmpy_code is also a string, so possibly '' are required:
WHERE cmpy_code = '#arguments.cmpy_code#' -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gareth Edwards Sent: Friday, 27 February 2004 9:05 AM To: CFAussie Mailing List Subject: [cfaussie] Re: QofQ? cmpy_code is a number, and surname is a string Gareth. -----Original Message----- From: Kevin Faulkner [mailto:[EMAIL PROTECTED] Sent: Thursday, 26 February 2004 11:41 AM To: CFAussie Mailing List Subject: [cfaussie] Re: QofQ? what do cmpy_code and i resolve to? ----- Original Message ----- From: "Gareth Edwards" <[EMAIL PROTECTED]> To: "CFAussie Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, February 26, 2004 12:34 PM Subject: [cfaussie] QofQ? <cfquery name="countDonors" dbtype="query"> SELECT surname FROM donorQuery WHERE cmpy_code = #arguments.cmpy_code# AND surname LIKE '#i#%' </cfquery> why does this show this error? Query Of Queries runtime error. Unsupported type comparison. Thanks Gareth. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
