|
MoreToIt
Starting Member
7 Posts |
 Posted - August 22 2006 : 09:06:17
|
Moving my site from Holland to UK, and am now getting various database errors, all seemingly centred around the date, e.g. try and add a tracking report, I get
Microsoft OLE DB Provider for SQL Server error '80040e07'
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
/shopping/shopa_trackingorder.asp, line 149
I've tried the vp-asp suggestion of setting xconvereteuropeannumbers to Yes, and updated the lcid bits in the files suggested, to no avail. Wherever I get this failure, it seems to be centred arounf the call to DateDelimit. Anyone else seen this issue, and can help, thanks |
|
|
MoreToIt
Starting Member
7 Posts |
Posted - August 22 2006 : 17:33:42
|
For anyone else who has this problem it seems my SSL server didn't like the date format as '2006-08-23' as is set by the call to DateNormalize, so I just commented out this call and set newdate=indate, and it seems to work for me. i.e.
Function DateDelimit (indate)
dim datedelim, newdate
datedelim="#"
if ucase(xdatabasetype)="SQLSERVER" or getconfig("xmysql")="Yes" then
datedelim="'"
end if
'newdate=DateNormalize(indate)
newdate=indate
dateDelimit = datedelim & newdate & datedelim
end function |
 |
|
All Forums
Datedelimit
New Topic
Printer Friendly
Topic 
TrustGuard - PCI Security Scanner
