Follow up to this email. when I checked to see what the actual sql was
doing it was:
INSERT INTO tmpRptDLGDailyCallsQXYPDXSORG values (8/5/2005,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO tmpRptDLGDailyCallsQXYPDXSORG values (8/6/2005,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO tmpRptDLGDailyCallsQXYPDXSORG values (8/7/2005,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO tmpRptDLGDailyCallsQXYPDXSORG values (8/8/2005,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO tmpRptDLGDailyCallsQXYPDXSORG values (8/9/2005,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO tmpRptDLGDailyCallsQXYPDXSORG values (8/10/2005,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO tmpRptDLGDailyCallsQXYPDXSORG values (8/11/2005,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO tmpRptDLGDailyCallsQXYPDXSORG values (8/12/2005,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO tmpRptDLGDailyCallsQXYPDXSORG values (8/13/2005,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO tmpRptDLGDailyCallsQXYPDXSORG values (8/14/2005,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO tmpRptDLGDailyCallsQXYPDXSORG values (8/15/2005,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO tmpRptDLGDailyCallsQXYPDXSORG values (8/16/2005,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO tmpRptDLGDailyCallsQXYPDXSORG values (8/17/2005,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO tmpRptDLGDailyCallsQXYPDXSORG values (8/18/2005,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO tmpRptDLGDailyCallsQXYPDXSORG values (8/19/2005,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO tmpRptDLGDailyCallsQXYPDXSORG values (8/20/2005,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO tmpRptDLGDailyCallsQXYPDXSORG values (8/21/2005,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO tmpRptDLGDailyCallsQXYPDXSORG values (8/22/2005,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO tmpRptDLGDailyCallsQXYPDXSORG values (8/23/2005,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO tmpRptDLGDailyCallsQXYPDXSORG values (8/24/2005,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO tmpRptDLGDailyCallsQXYPDXSORG values (8/25/2005,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO tmpRptDLGDailyCallsQXYPDXSORG values (8/26/2005,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO tmpRptDLGDailyCallsQXYPDXSORG values (8/27/2005,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO tmpRptDLGDailyCallsQXYPDXSORG values (8/28/2005,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO tmpRptDLGDailyCallsQXYPDXSORG values (8/29/2005,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO tmpRptDLGDailyCallsQXYPDXSORG values (8/30/2005,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO tmpRptDLGDailyCallsQXYPDXSORG values (8/31/2005,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO tmpRptDLGDailyCallsQXYPDXSORG values (9/1/2005,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO tmpRptDLGDailyCallsQXYPDXSORG values (9/2/2005,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO tmpRptDLGDailyCallsQXYPDXSORG values (9/3/2005,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO tmpRptDLGDailyCallsQXYPDXSORG values (9/4/2005,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
INSERT INTO tmpRptDLGDailyCallsQXYPDXSORG values (9/5/2005,
0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
-----Original Message-----
From: [email protected]
[mailto:[EMAIL PROTECTED] On Behalf Of Ali Husain
Sent: Monday, September 05, 2005 11:41 PM
To: [email protected]
Subject: [AspNetAnyQuestionIsOk] Weird Date Issue with MS Access
Hi guys,
I am trying to store a series of dates in to an Access Database
The same code works fine if its printing it on screen or even using it
in a SQL Statement but when it adds it to the access table
It gives me a float # which is crazy. I tried to put it in as a date but
that would give me some date in 1899, so I tried to put it in as a
varchar and its giving me the weird float #'s
Dim datecount As Integer
For datecount = 0 To DateDiff(DateInterval.Day, CDate(Request("sd")),
CDate(Request("ed")))
Dim newdate As Date = DateAdd(DateInterval.Day,
datecount, startdate)
mySql = "INSERT INTO tmpRptDLG" & randomfilename & "
values (" & _
newdate.ToShortDateString & _
", 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)"
myComm = New OleDb.OleDbCommand(mySql, myConn)
myComm.ExecuteNonQuery()
Next
myreader.Close()
myConn.Close()
This is what the db fills:
tmpRptDLGDailyCallsZKVWQTFSHN
CallDate
7.98004987531172E-04
6.65004156275977E-04
5.70003562522266E-04
4.98753117206983E-04
4.43336104183984E-04
3.99002493765586E-04
3.62729539786896E-04
3.32502078137988E-04
3.06924995204297E-04
2.85001781261133E-04
2.66001662510391E-04
2.49376558603491E-04
2.34707349273874E-04
2.21668052091992E-04
2.10001312508203E-04
1.99501246882793E-04
1.90001187507422E-04
1.81364769893448E-04
1.73479345115472E-04
1.66251039068994E-04
1.59600997506234E-04
1.53462497602148E-04
1.47778701394661E-04
1.42500890630566E-04
1.37587066815719E-04
1.33000831255195E-04
1.28710481859866E-04
4.48877805486284E-03
2.24438902743142E-03
1.49625935162095E-03
1.12219451371571E-03
8.97755610972569E-04
THanks
[Non-text portions of this message have been removed]
SPONSORED LINKS
Basic
<http://groups.yahoo.com/gads?t=ms&k=Basic+programming+language&w1=Basic
+programming+language&w2=Computer+programming+languages&w3=Programming+l
anguages&w4=Java+programming+language&w5=The+history+of+computer+program
ming+language&c=5&s=176&.sig=clJRDppRYABhs6xUhzokKw> programming
language
Computer
<http://groups.yahoo.com/gads?t=ms&k=Computer+programming+languages&w1=B
asic+programming+language&w2=Computer+programming+languages&w3=Programmi
ng+languages&w4=Java+programming+language&w5=The+history+of+computer+pro
gramming+language&c=5&s=176&.sig=RiWZhYTiihJ1rWfeFgB2sg> programming
languages
Programming
<http://groups.yahoo.com/gads?t=ms&k=Programming+languages&w1=Basic+prog
ramming+language&w2=Computer+programming+languages&w3=Programming+langua
ges&w4=Java+programming+language&w5=The+history+of+computer+programming+
language&c=5&s=176&.sig=2BgLsjKfGvxPndstKBMU9g> languages
Java
<http://groups.yahoo.com/gads?t=ms&k=Java+programming+language&w1=Basic+
programming+language&w2=Computer+programming+languages&w3=Programming+la
nguages&w4=Java+programming+language&w5=The+history+of+computer+programm
ing+language&c=5&s=176&.sig=4wWSX5WKx7BCK9SrMVdrxQ> programming
language
The
<http://groups.yahoo.com/gads?t=ms&k=The+history+of+computer+programming
+language&w1=Basic+programming+language&w2=Computer+programming+language
s&w3=Programming+languages&w4=Java+programming+language&w5=The+history+o
f+computer+programming+language&c=5&s=176&.sig=iNvYp6cfd9HwtDhK1iV-rg>
history of computer programming language
_____
YAHOO! GROUPS LINKS
* Visit your group "AspNetAnyQuestionIsOk
<http://groups.yahoo.com/group/AspNetAnyQuestionIsOk> " on the web.
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]
cribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
_____
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Most low income households are not online. Help bridge the digital divide today!
http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/saFolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
