Insert giving message on server but not locally

[hs4u]

I am getting the following error when I try to insert a record into my database
on the server:

Error Executing Database Query.
Syntax error in INSERT INTO statement.

The error occurred in
C:\Inetpub\vhosts\ibfonline.com\httpdocs\admin\add speaker.cfm: line 83

81 : <cfelse>
82 : NULL
83 : </cfif>
84 : )</cfquery>
85 : <cflocation url="mainadmin.cfm">




--------------------------------------------------------------------------------

SQL INSERT INTO tblspeakers (speaker1, eventdate, day, details1, speaker2,
details2, speaker3, sponsor) VALUES ( 'Claims Legal Management for Black Ink
E&O Insurance' , '03/13/2006' , 'Tuesday' , 'From how to fill out the
application to how to stay out of court. Black Ink writes policies for 13 out
of the 14 E&O companies in California. ' , NULL , 'Broker Duty to Issue 1099''s
for Co-operating Commissions Real estate brokers must generally file 1099-MISC
forms for commission payments of $600 or more. However, according to
California''s Franchise Tax Board (FTB), that 1099 reporting requirement for a
listing broker includes not only the commission paid to the salesperson in the
office, but also the commission paid to the cooperating broker. Come find out
the details.' , 'John Buffington, Countrywide Home Loans' , 'Deal Making Skills
- Using No Coast Loans to Put the Deal Together' )


--------------------------------------------------------------------------------
-------------------
It works fine when I test it on my local machine. I have CFMX 7 and so does
the server. Anyone know what is up with this? I am using Dreamweaver to
generate the code.

Thanks for any help.

Terry

[Dan Bracuk]

It looks fine. Are your development and production cold fusion pages
connecting to the same database? If not, can you either connect to your
production db from your development or copy it to your development machine?
That will make troubleshooting easier.

One thing that could look better though, is your date value. Using the
createodbcdate function instead of formatted date strings results in more
robust applications. That might not be what is causing your problems though.

[hs4u]

It is connecting to a copy of the same database on server. It worked on my old
hosting company but I had to change since they went out of business. Now, the
update for the membership works fine, just the speaker info insert is giving me
trouble. I can't see a problem either. I am using the date to sort by so need
it to be alphabetical. It's the only way I know how to do it.

Guess I will have to do the page over and see if the glitch goes away.

Thanks.

[MikerRoo]

day is a reserved word and should not be used as a table column name.

The ANSI compliance options must be different between the two machines. You
can try using as a stopgap but the best thing to do is to rename DB columns
and tables so that they do not use
[url]http://livedocs.macromedia.com/coldfusion/7/htmldocs/00000189.htm[/url].

[hs4u]

Well, I renamed the day to dayfield and updated all. The whole site works great
on my computer and worked fine on the old hosting company. Most things do not
work on the new hosts server so far. My search is broken, my insert is broken.

On my local cf server it ALL works without a hitch. I have remade the pages to
no avail. The hosting co is looking into it as well. If anyone knows why it
would have trouble, please let me know.

Thanks, Terry