Hi Folks
I have a coldfusion variable
expireDate=Dec. 10, 2010
That I want to insert as a date into a mySql database
The table cell is set up as a date but I can't find the right cf date format to
get
the insert to work. I keep getting a syntax error.
Thanks
Rob
Robert J. Voyle,
Is your field in the db set up as a DATE or DATETIME?
Jim Eisenhauer
On Fri, Aug 20, 2010 at 9:26 AM, Rob Voyle r...@voyle.com wrote:
Hi Folks
I have a coldfusion variable
expireDate=Dec. 10, 2010
That I want to insert as a date into a mySql database
The table cell is set up as
Where is the date you need to insert coming from as well? A form? and/or is
it a literal string like 'Dec. 10, 2010'... or is the form field passing an
actual date variable?
Jim Eisenhauer
On Fri, Aug 20, 2010 at 9:28 AM, Jim Eisenhauer eisenha...@gmail.comwrote:
Is your field in the db set
On Fri, Aug 20, 2010 at 12:26 PM, Rob Voyle r...@voyle.com wrote:
Hi Folks
I have a coldfusion variable
expireDate=Dec. 10, 2010
That I want to insert as a date into a mySql database
The table cell is set up as a date but I can't find the right cf date format
to get
the insert
CreateODBCDate(expireDate)
or
CreateODBCDateTime(expireDate)
On Fri, Aug 20, 2010 at 12:26 PM, Rob Voyle r...@voyle.com wrote:
Hi Folks
I have a coldfusion variable
expireDate=Dec. 10, 2010
That I want to insert as a date into a mySql database
The table cell is set up as a date
Rick is right. Use cfqueryparam and your problems will go away:
INSERT INTO xTable(xDate) VALUES (cfqueryparam value=Dec. 10, 2010
cfsqltype=cf_sql_date /);
That's for a DATE column. If you are doing a DATETIME column, use
cf_sql_timestamp instead.
Rick Root wrote:
On Fri, Aug 20, 2010 at
wierd, my first reply didn't go through...
Rick is right. Use cfqueryparam and your problems will go away:
INSERT INTO xTable(xDate) VALUES (cfqueryparam value=Dec. 10,
2010 cfsqltype=cf_sql_date /);
That's for a DATE column. If you are doing a DATETIME column, use
cf_sql_timestamp
7 matches
Mail list logo