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
