Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.
-
wtodd #1
Insert Date headache
I'm having a darn time trying to accomplish a task that I thought was simple -
maybe it is - I'm just new at it I guess. All I want to do is to have a
customer insert a date into an Access 2000 DB. I'm getting an
"[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Syntax error in INSERT INTO statement." This is what I have:
INSERT INTO jwst (instrument, request_date, part_number)
VALUES ('#instrument#', "#CreateODBCDate(form.request_date)#", '#part_number#')
Can someone please lead me to the right path. Thanks.
wtodd Guest
-
How to insert date into db?
I've been fighting with this simple (?) issue all weekend long and have gotten nowhere. I want to have the current date and time inserted into the... -
ASP SQL Insert NULL Date Value
Hello, I've been pulling my hair out trying to figure this out. Thank you in advance for taking the time to look at this. I'm trying to... -
Date Insert puzzle :: 05/23/76 becomes 12: 12:13
I'm tearing out my hair here: ACCESS 2000: When I attempt to overwrite a date in my date field with a new user selected valid date eg: 05/23/99... -
[Headache] "INSERT INTO" error I can't work out.
In article <230720031756451382%uce_from_usenet@chatomatic.net>, Peter <uce_from_usenet@chatomatic.net> wrote: Ignore the question about the... -
Insert date
Leave the Control Source set to the field in the table that you want to store the date in. In the Form's BeforeUpdate event, set the value of this... -
Mountain Lover #2 Re: Insert Date headache
loose the quotes...#CreateODBCDate(form.request_date)# is all you need
HTH
--
Tim Carley
[url]www.recfusion.com[/url]
[email]info@NOSPAMINGrecfusion.com[/email]
Mountain Lover Guest
-
mxstu #3 Re: Insert Date headache
Get rid of the quotes around #CreateODBCDate(form.request_date)#
mxstu Guest
-
jorgepino #4 Re: Insert Date headache
did you try using single quotes instead?
"#CreateODBCDate(form.request_date)#",
jorgepino Guest
-
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
