RE: Help, fresh eyes needed! (Solved)

2002-03-22 Thread Scott Van Vliet
The word "all" is a reserved word, thus the error. Just rename your table column and everything should work. I am off to get faded at the Block. Have a good night all! -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: Friday, March 22, 2002 6:04 PM To: CF-Talk Su

RE: Help, fresh eyes needed! (Solved)

2002-03-22 Thread Kwang Suh
Well, someone's brain is working on Friday! -Original Message- From: Scott Van Vliet [mailto:[EMAIL PROTECTED]] Sent: Friday, March 22, 2002 7:56 PM To: CF-Talk Subject: RE: Help, fresh eyes needed! (Solved) The word "all" is a reserved word, thus the error. Just re

RE: Help, fresh eyes needed! (Solved)

2002-03-22 Thread Bill Henderson
- From: Scott Van Vliet [mailto:[EMAIL PROTECTED]] Sent: Friday, March 22, 2002 6:56 PM To: CF-Talk Subject: RE: Help, fresh eyes needed! (Solved) The word "all" is a reserved word, thus the error. Just rename your table column and everything should work. I am off to get faded at the

Re: Help, fresh eyes needed! (Solved)

2002-03-23 Thread Jochem van Dieten
Bill Henderson wrote: > The other way to do it is to enclose all in brackets like this: > > > INSERT INTO tunetips (title, blurb, [all]) > VALUES ('#Form.title#', '#Form.blurb#', '#Form.all#'); > > > That way, you don't have to rename your table. Just remember that if you ever switch to a SQL