Re: cfinsert works with mySQl 5 but NOT with ms sql server 2005

[GArlington <garlington@xxxxxxxxxxxxx>]

On Jan 20, 9:08 pm, "masticwarrior" <webforumsu...@xxxxxxxxxxxxxx>
wrote:
> First i would consider myself an "advanced" beginner at coldfusion.
>
>  I had a setup of coldfusion 8 with mySQL5 w/GUI interface. I do my 
> development
> in eclipse.
>
>  I wrote a VERY simple code,  with a simple database table, and it submitted
> the data fine no problems. (i verified the data and it was indeed submitted)
>
>  <cfif IsDefined ("form.posted")>
>     <cfinsert datasource="cfsales" tablename="test">
>  </cfif>
>
<snip>

If you read CF docs you will find that it is ALWAYS advised to use
<cfquery ...> instead of <cfinsert ...> <cfupdate ...>