473,569 Members | 2,438 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 1480
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
1434
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 add a small front end for the web. The university uses cold fusion.. And I've taught myself how to do simple queries etc. The problem is when the...
2
1550
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
1256
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 not working on that Server. First page comes up, lets you log in, second page loses the session variable (becomes null) that has user id in it. I get...
5
5707
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 instructions below). So, now I am trying to connect to the same database with MS Access. I want to link the tables within Access so I can quickly...
2
1118
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 INSERT INTO tblToDo ( Dato, Bruker, Utfort, Melding, MeldingFra ) " & _ "SELECT " & dteDato & ", '" & strSaksbehandler & "', -1, '" & strMelding &...
0
18684
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 space...
7
8216
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 mail using Coldfusion Coldfusion Tips and Tricks
1
3865
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 value gets No. 1, and then the row of the second biggest value is ranked as No. 2). Each task owners will then have to attack their owning issues...
1
1797
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 Parsing an XML document - not the most useful of errors so I am a bit stumped, here is my web service: <cfcomponent> <cffunction name="getDetails" ...
0
7703
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
8138
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
7983
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5514
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5223
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 then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3657
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3647
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2117
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 we have to send another system
0
946
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 can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

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.