473,508 Members | 2,412 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

datefield problem with access 2003 and coldfusion

5 New Member
I'm using a flash form to input some data into my access database. one of the fields is a type=datefield. When i output the actual data just before the sql insert that date is in the correct format; mm/dd/yyyy. So thats fine, but when i look at the actual data in access instead of being a date such as 11/1/2006 its something like 12:19:43 AM.

I have been beating my head against the wall trying to figure out what is going on. Does anyone have any ideas what is going wrong?
Nov 6 '06 #1
7 1477
PEB
1,418 Recognized Expert Top Contributor
It seems that your date isn't enterd in the database..

Behind those values is maybe the 0 value! But in fact not... The 0 also corresponds to a date and time..

Is your field has a properties to be of type Date and Time or only it's assigned for Time?
Nov 6 '06 #2
rbmako69
5 New Member
Is your field has a properties to be of type Date and Time or only it's assigned for Time?
I'm unclear what you are asking. In the app. i have a <cfinput type="datefield" ...>

The field in the database is is type date/time.
Nov 6 '06 #3
PEB
1,418 Recognized Expert Top Contributor
Yeah,

Have you tried to introduce manually a date?
How do you connect with ColdFusion?
Nov 6 '06 #4
rbmako69
5 New Member
I have tried to enter the date manually, but when i do something else breaks.

As for connecting with coldfusion, i'm not sure. i have the cfserver running with apache as the webserver, and i'm developing in dreamweaver. i don't know if that what you are asking though
Nov 6 '06 #5
MMcCarthy
14,534 Recognized Expert Moderator MVP
I'm unclear what you are asking. In the app. i have a <cfinput type="datefield" ...>

The field in the database is is type date/time.
What is the format of the date/time field?
Nov 7 '06 #6
rbmako69
5 New Member
What is the format of the date/time field?
Are you refering to the access field or the field in coldfusion
Nov 7 '06 #7
MMcCarthy
14,534 Recognized Expert Moderator MVP
Are you refering to the access field or the field in coldfusion
The Access Field
Nov 7 '06 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

2
1430
by: R Schlageter | last post by:
Several years ago I wrote a database which keeps track of our campus ministry participation ... I'm no expert but it keeps working well The database is divided front and back end. Now we need to...
2
1549
by: Priya | last post by:
Hi, How do I pass a session variable & cookies from ASP.NET page to coldfusion page? Thanks in advance Priya
3
1252
by: Bhaskar | last post by:
Folks, I have both Coldfusion and dotnet applications (written in 1.1 framework) on the same server. It's an Windows 2003 Server that has coldfusion installed first. My dotnet programs are...
5
5695
by: Nathan Given | last post by:
Hello All, I've been struggling on and off for 3 months trying to connect to an DB2 database running on an IBM iSeries machine. I FINALLY figured out how to connect with Coldfusion (see...
2
1115
by: reidarT | last post by:
I use a DateTimePicker to get a date. I want to add this date into an access table. I use a variable like Dim dteDato As Date = Format(Me.txtDato.Value, "Short date") In the sql-statement I use...
0
18674
acoder
by: acoder | last post by:
This page will link to a number of tutorials. Coldfusion Language Coldfusion Variables Using Coldfusion Variables Coldfusion Image Gallery How to upload a file in Coldfusion Watch this...
7
8201
acoder
by: acoder | last post by:
This page will link to a number of tutorials. Coldfusion Language Coldfusion Variables Using Coldfusion Variables Coldfusion Image Gallery How to upload a file in Coldfusion How to send...
1
3857
by: jjjoic | last post by:
Hi, I use Access 2003 to generate the back-end data for a ColdFusion report at work. The report is sorted by a column and based on the sorting, rankings are assigned to each row(i.e. the biggest...
1
1792
by: Morag | last post by:
I am trying to retrieve data from my xml file into a coldfusion web service, the xml is valid but when the web service attempts to search the xml it throws back an error - An error occured while...
0
7223
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7321
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
7036
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7489
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
4705
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3179
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1547
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
762
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
414
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.