Hello i am new in asp but i know VB
This is my pages
But i get error her :strSQLQuery = "insert into table1( Name, Date) values('" & UserName & "','" & date & "')"
and Her :rs.Open strSQLQuery, conn , 3, 3
<html>
<%
Dim UserName
Dim Conn
Dim rs
dim strSQLQuery
UserName=Request.QueryString("Name")
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:\db1.mdb")
strSQLQuery = "insert into table1( Name, Date) values('" & UserName & "','" & date & "')"
response.write strSQLQuery
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open strSQLQuery, conn , 3, 3
response.write UserName
Set rs= Nothing
%>
<html>
Featured
Writing your app was the hard part, but it’s not the last part. You still need to sell your app. Here's how to make sure your description puts your app in the best light. |
|
Reply With Quote
