Yes it is, but if the field is an int then you will have to remove the ' . It may pay to post the error message so that we can identify the exact problem:-) Regards, Andrew Scott -----Original Message----- From: Dusty Tinashe Shoko [mailto:[EMAIL PROTECTED]] Sent: Friday, 31 August 2001 11:06 PM To: CF-Talk Subject: SQL People help <CFQUER datasource="mydbsource"> INSERT INTO TABLENAME (Field1, Field2, Field3,....) VALUES ('Value1', 'Value2', 'Value3',...) </CFQUERY> Is that the proper syntax? Sp Field1 is a date got from the form how would I make sure it is inserted in a format I like? Can I do a dateformat within the query? I am getting a syntax error! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
