Ali, could you post the complete code and the returning error please? We then would be able to help. I'm sure...
Gert Ali schrieb: >> Great, you duessed completely correct. I am a newbie so I didn't get the >> code eompletely. >> >> I edited the code this way >> > > > UPDATE Tbl_DogBreeds > SET > DogBreedImageS2= > <cfif structKeyExists(FORM,"DogBreedImageS2") AND #FORM.DogBreedImageS2# > NEQ ""> > <cfqueryparam value="#FORM.DogBreedImageS2#" cfsqltype="cf_sql_clob"> > > </cfif> > > but it returned an error! Please please tell me what did I wrong in this > code. > thanks > Ali > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298982 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4