[CF-Dev] Cfqueryparam, clobs and nulls

["Aidan Whitehall" <AidanWhitehall@Fairbanks.co.uk>]

With table 'test' (Oracle 9i) with nullable numeric column 'test', this:

 <cfquery datasource="dsn">
   insert into test
   values (<cfqueryparam value="1" cfsqltype="cf_sql_numeric"
null="yes">)
 </cfquery>

works luverly. With nullable clob column 'test', this:

 <cfquery datasource="dsn">
   insert into test
   values (<cfqueryparam value="abc" cfsqltype="cf_sql_clob"
null="yes">)
 </cfquery>

throws a paddy:

 [DataDirect][SequeLink JDBC Driver]Value can not be converted to
requested type.

I was programmatically determining the value of the null attribute, but
it looks like for clobs you have to cfif around it.

Anyone know if there are any other sql types that will throw the same
error (just to save me going through the list)? Thanks.


-- 
Aidan Whitehall   aidanwhitehall@fairbanks.co.uk
Macromedia ColdFusion Developer
Fairbanks Environmental   +44 (0)1695 51775

________________________________________________________________________
This e-mail has been scanned for all viruses by Star. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________