<cfif IsNumeric(fieldname1)>
WHERE fieldname1 = 1
<cfelse>
WHERE fieldname1 = 'abc'
</cfif>
Duncan Cumming
IT Manager
http://www.alienationdesign.co.uk
mailto:[EMAIL PROTECTED]
Tel: 0141 575 9700
Fax: 0141 575 9600
Creative solutions in a technical world
----------------------------------------------------------------------
Get your domain names online from:
http://www.alienationdomains.co.uk
Reseller options available!
----------------------------------------------------------------------
----------------------------------------------------------------------
"Justin
MacCarthy" To: "Cfuk" <[EMAIL PROTECTED]>
<[EMAIL PROTECTED] cc:
.ie> Subject: [ cf-dev ] QoQ question
03/04/2003
14:40
Please
respond to
dev
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]
