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]
