J
Jim Flaherty
Hello I get No value given for one or more required parameters.
on a page that updates a access 2000 db
code
set oASP = Server.CreateObject("ADODB.Connection")
oASP.Open _
"Provider=Microsoft.Jet.OLEDB.4.0;"&_
"Persist Security Info=TRUE;" &_
"Data Source=d:\inetpub\wwwroot\ttfkbnt\db1.mdb","Admin",""
'######################################################
' get survey info from DB
' #####################################################
sql2 = "UPDATE contacts set password1 = 'password' where num = " & num1
'response.write(sql2)
set rsPC = oASP.Execute(sql2)
the error line listed is the execute sql
any Ideas
Thanks
Jim
on a page that updates a access 2000 db
code
set oASP = Server.CreateObject("ADODB.Connection")
oASP.Open _
"Provider=Microsoft.Jet.OLEDB.4.0;"&_
"Persist Security Info=TRUE;" &_
"Data Source=d:\inetpub\wwwroot\ttfkbnt\db1.mdb","Admin",""
'######################################################
' get survey info from DB
' #####################################################
sql2 = "UPDATE contacts set password1 = 'password' where num = " & num1
'response.write(sql2)
set rsPC = oASP.Execute(sql2)
the error line listed is the execute sql
any Ideas
Thanks
Jim