Thanks for the advice,. Ali On Thu, Feb 14, 2008 at 4:47 PM, Dominic Watson < [EMAIL PROTECTED]> wrote:
> 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:299014 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
