Insert SQL don't work within a VFP/ODBC datasource

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Insert SQL don't work within a VFP/ODBC datasource

Message

From

18/09/2000 14:22:00

Pedro Giraudi
Pragmatec Sistemas de Información
Los Hornillos, Argentina

18/09/2000 11:29:18

Chad Hurd
Webifyit.ca
Winnipeg, Manitoba, Canada

General information

Forum:

Internet

Category:

Active Server Page

Title:

Re: Insert SQL don't work within a VFP/ODBC datasource

Miscellaneous

Thread ID:

00417168

Message ID:

00417744

Views:

Thanks, It is my code:

<%tfirma=request.form("T1")
tmensaje=request.form("S1")%>
<%tsql1="insert into oatp(fecha,atenc,detalle) values("
tsql2="'" & now & "'" & "," & "'" & request.form("T1") & "'" & "," & "'" & request.form("S1") & "'" & ")"
tsql=tsql1 & tsql2%>
<%Set OBJdbConnection = Server.CreateObject("ADODB.Connection")%>
<%
OBJdbConnection.Open "oatdb"
OBJdbConnection.Execute(tsql)
OBJdbConnection.close
%>

Map

View

Click here to load this message in the networking platform