How about this!
<CFSET EDate = EMonth & "/" & EDay & "-" & EYear & " " & #Timeformat(Now(),
"h:mm:ss")#>
<CFQUERY DATASOURCE="STA">
INSERT INTO Events(EDate, ETimeStart, ETimeEnd, ETitle, EDetails, Link,
MyTest)
VALUES(#CreateODBCDateTime(EDate)#, '#ETimeStart#', '#ETimeEnd#',
'#ETitle#', '#EDetails#',
'#Link#', '#MyTest#')
</cfquery>
Hope that helps
Allan Pichler
-----Original Message-----
From: Mark Smeets [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 01, 2001 11:39 PM
To: CF-Talk
Subject: Dat(ing)e Problem with Access and Forms
Hello,
Well, I'll be as brief as I can about this problem I'm having.
I have this form where I need the user to enter in a date for a press
release (for example). Now, this can't be an automatic date because the
press release may be dated for another day or even the following month.
So, the problem is, for some reason, What I had begun to do was to take 3
seperate drop down boxes with Month/Day/Year, and then insert those plus the
time (ODBC Time) into the database.
Now, the field happens to be a date/time field. It doesn't work and in fact,
it gives me screwed up results. Why did I do this? because I want to order
the reports by their dates and if I do it by a text field, well, it will
just go in alphabetical order and that's useless.
So, one thought I had was for the user to pick what they want from the text
boxes and then on my processing page, find a way to somehow match that info
to an ODBC date and then insert it. No idea how to go about doing that.
It is possible that I've screwed up the concatination but I'll let this list
be the judge of that code (which is included below). The drop down fields
are just typical drop down fields on a form so I won't post that.
Any help is appreciated and I really hope this made sense.
---------My Code Below---------
<CFSET EDate = EMonth + EDay + EYear + #CreateODBCTime(Now())#>
<CFQUERY DATASOURCE="STA">
INSERT INTO Events(EDate, ETimeStart, ETimeEnd, ETitle, EDetails, Link,
MyTest)
VALUES(#EDate#, '#ETimeStart#', '#ETimeEnd#', '#ETitle#', '#EDetails#',
'#Link#', '#MyTest#')
</cfquery>
<cflocation url = "events_post.cfm">
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
