if I use
 
<%
da_data=request.form("da_data")
nome=request.form("nome")
password=request.form("password")
 

Set Con = Server.CreateObject( "ADODB.Connection" )
      Con.Open "DSN=serverdb", "test", "test"
 
sqlString = "update  utentiall set da_data='20003-01-01' where nome='"&nome&"' and pw='"&password&"'"
Con.Execute( sqlString )
 
%>
sql work properly
 
if I use sintax
 
<%
da_data=request.form("da_data")
nome=request.form("nome")
password=request.form("password")
 

Set Con = Server.CreateObject( "ADODB.Connection" )
      Con.Open "DSN=serverdb", "test", "test"
 
sqlString = "update  utentiall set da_data='20'||substr('"&da_data&"',5,2)||'-'||substr('"&da_data&"',3,2)||'-'||substr('"&da_data&"',1,2) where nome='"&nome&"' and pw='"&password&"'"
Con.Execute( sqlString )
%>
 
where
 
da_date value is '010103'
and datatype of da_date field on table utentiall is date
 
I have
error message
 
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[SAP AG][SQLOD32 DLL][SAP DB]Datetime field overflow;-3048 POS(1) Invalid date format:ISO.
/GEST_SAP/DB/contabilita/altusrdate.asp, line 18
 
what is the problem ???
tank's
Fabio

Reply via email to