In the error report, near the bottom, you should see the SQL code that has been sent to the SQL server it will have looked like this:
UPDATE Tbl_DogBreeds SET DogBreedImageS2 = That should give you a clue as to why the error is being thrown. You need to put the cfif in a different place. If that really is your entire query - then there is no need to run the query at all unless DogBreedImageS2 exists. So: <cfif structKeyExists(FORM,"DogBreedImageS2") AND FORM.DogBreedImageS2 NEQ ""> <cfquery name="foo" datasource="#ds#"> SQL STATEMENT </cfquery> </cfif> HTH Dominic On 14/02/2008, Gert Franz <[EMAIL PROTECTED]> wrote: > > 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:298989 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
