Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
ASP and UPDATE QUERY
- Thread starter kjoost001
- Start date
with your active connection to your Access db and recordset(objrs) the code goes something like
objcommand.commandtext ="qryYourQuery"
objcommand.commandtype = adCmdStoredProc
set objrs = objcommand.execute
where "qryYourQuery" is the name of the stored query
Hope this is helpful
Andy
objcommand.commandtext ="qryYourQuery"
objcommand.commandtype = adCmdStoredProc
set objrs = objcommand.execute
where "qryYourQuery" is the name of the stored query
Hope this is helpful
Andy
- Thread starter
- #3
thanks for the response awithers, however, i have attached my code with your response, and i stillreceive internal server error. here is my code ( can you use the execute method with an update query type?)
thanks again.
<%
Option Explicit
%>
<%
Dim dcnDB
Dim sDatabaseLocation
Dim objrs
Set dcnDB = Server.CreateObject("ADODB.Connection"
sDatabaseLocation = Server.MapPath("FFLDB1.mdb"
dcnDB.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + sDatabaseLocation)
dcnDB.commandtext ="qry_test1"
dcnDB.commandtype = adCmdStoredProc
set objrs = objcommand.execute
%>
<html>
<body>
Test complete.
</html>
thanks again.
<%
Option Explicit
%>
<%
Dim dcnDB
Dim sDatabaseLocation
Dim objrs
Set dcnDB = Server.CreateObject("ADODB.Connection"
sDatabaseLocation = Server.MapPath("FFLDB1.mdb"
dcnDB.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + sDatabaseLocation)
dcnDB.commandtext ="qry_test1"
dcnDB.commandtype = adCmdStoredProc
set objrs = objcommand.execute
%>
<html>
<body>
Test complete.
</html>
There is a easier way to do it, that will allow you to skip the adCmdStoredProc section.
myconnection.execute(syntax of the SQL statement you want to run)
With this you could just declare whatever SQL is in the udpate query, create it as a variable in the code, and run it directly.
SQL = "update mytablename set myfield = myvalue"
myconnection.execute(SQL)
But the catch is that MS Access might not recognize that the update query is a stored procedure. This is evident if you have ever tried to upsize from Access to SQL. It works fine for select based queries, but try to upsize a append/delete/update query, and it freaks out.
You might try putting the call to the update query in a Macro, and then calling the macro through the code that was submitted above. I would think that would have a little bit better result for you. The money's gone, the brain is shot.....but the liquor we still got.
myconnection.execute(syntax of the SQL statement you want to run)
With this you could just declare whatever SQL is in the udpate query, create it as a variable in the code, and run it directly.
SQL = "update mytablename set myfield = myvalue"
myconnection.execute(SQL)
But the catch is that MS Access might not recognize that the update query is a stored procedure. This is evident if you have ever tried to upsize from Access to SQL. It works fine for select based queries, but try to upsize a append/delete/update query, and it freaks out.
You might try putting the call to the update query in a Macro, and then calling the macro through the code that was submitted above. I would think that would have a little bit better result for you. The money's gone, the brain is shot.....but the liquor we still got.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question