>- see footer for list info -< 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 [EMAIL PROTECTED] 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 ________________________________________________________________________ _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
