Been having an issue with updating clobs. Solaris 4.5.latest, Oracle 8i.latest, native datasource Inserting a record with a CLOB works fine, but when you go to update it, it throws a "Missing Expression Error". There is no missing expression. If you change the cfsqltype to CF_SQL_LONGVARCHAR the update will work, however I think that's what's causing our Oracle replication to fail. Anybody run into this? (code below) Jeff Britts Senior Software Engineer e-Dialog [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> <CFQUERY NAME= "article_event_update" DATASOURCE= "ds" > UPDATE article_event SET title='#form.title#', event_date='#dateformat(form.event_date,"DD-MMM-YYYY")#', update_date=sysdate, update_by='#user_id#', content=<cfqueryparam value="#form.content#" cfsqltype="CF_SQL_CLOB"> WHERE article_id=#form.article_id# AND article_event_id=#form.article_event_id# </cfquery> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
