sdz
|
| Posted: 04/25/2002, 11:22 AM |
|
hi everybody, I'm tryng to test the forum template with sql and y got the following error:
Tipo de error:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC SQL Server Driver][SQL Server]Error de sintaxis al convertir una cadena de caracteres a datetime.
/pruebas/forum/reply.asp, line 182
Tipo de explorador:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.0.3705)
Pagina:
POST 196 bytes to /pruebas/forum/reply.asp
Datos de POST:
smiley_id=0&topic=prueba+&author=sdz&message=ESTA+ES&FormAction=insert&FormName=reply&Trn_mid=13&PK_message_id=&message_id=&smiley_id=&date_entered=4%2F25%2Faaaa+13%3A09%3A25&last_modified=&mid=13
Could anyone help?
Thanx
|
|
|
 |
bs
|
| Posted: 04/25/2002, 11:11 PM |
|
Does it work when you enter the date as MM/DD/YYYY instead of DD/MM/YYYY ?
Then it should be this date problem again.
I've seen posts about this in this forum before.
My god ! could somebody explain why some people on earth write dates like Month/Day/year !???
|
|
|
|
sdz
|
| Posted: 04/26/2002, 9:13 AM |
|
BS
It worked when i changed from dd/mm/aaaa to mm/dd/aaaa !!!!, so I have to made code for writing the record diferent from display.
Thanqs a lot.
Salvador
|
|
|
|
|
