Here is how you can do it
metadata = myquery.getMetaData();
metadata.getColumnType(myquery.findColumn('DOCUMENTNAME')
myquery.getColumnTypeName(metadata.getColumnType(myquery.findColumn('DOCUMEN
TNAME')))
Returns varchar or whatever.
BTW this gets the wrong type, so be careful
myquery.getColumnTypeName(myquery.findColumn('DOCUMENTNAME'))
So fully
<cfif
ListContainsNoCase("varchar,nchar,etc",myquery.getColumnTypeName(myquery.fin
dColumn(columnname)) >
and #columnname# like '#value#'
<cfelse>
and #columnname# = #value#
</cfif>
Justin
-----Original Message-----
From: Justin MacCarthy [mailto:[EMAIL PROTECTED]
Sent: 03 April 2003 15:29
To: [EMAIL PROTECTED]
Subject: [notspam] [ cf-dev ] QoQ question - solution using java
> you either need to store metadata about your table (e.g. in another table
> that defines the columns), or to query the sysobjects table, i think.
> Duncan Cumming
> IT Manager
I have a solution using java . post it in a minute or 2.
--
** 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]
