Bill Henderson wrote:
> The other way to do it is to enclose all in brackets like this:
>
> <cfquery name="AddRecord" datasource="andes" dbtype="ODBC">
> INSERT INTO tunetips (title, blurb, [all])
> VALUES ('#Form.title#', '#Form.blurb#', '#Form.all#');
> </cfquery>
>
> That way, you don't have to rename your table.
Just remember that if you ever switch to a SQL compliant database you
need to change the brackets to double quotes. Which I believe is a good
reason to change the name of the field and not go for this workaround.
Jochem
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
