And b4 the security monkeys jump on me I will use <cfqueryparam ;->
Justin -----Original Message----- From: Justin MacCarthy [mailto:[EMAIL PROTECTED] Sent: 03 April 2003 14:41 To: Cfuk Subject: [notspam] [ cf-dev ] QoQ question I have a generic tag that will do a QoQ. <cfquery name ="SubQuery" dbtype = "query"> SELECT * FROM MyQuery WHERE fieldname1 = 'abc' [or WHERE fieldname1 = 1 ] I want to do fieldname1 = 'abc' if the fieldname is a string/varchar/char etc.. or fieldname1 = 1 if the fieldname is a INT/number How can I test if the SQL type in the Query is INT or VARCHAR??? Thanks ~J -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
