Why, Are you worried that someone may try to drop a table from your temporary in-memory recordset?
;-) > -----Original Message----- > From: Justin MacCarthy [mailto:[EMAIL PROTECTED] > Sent: 03 April 2003 14:47 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] QoQ question > > > > 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] > > -- ** 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]
