You can submit the page using javascript without the user intervention. After running your subroutine, just right following javascript code:
<script langauge="javascript">
document.forms[0].action="somefile.asp";
document.forms[0].submit();
</script>
The DBQ path you are using in the connection string for DBO will be different for your server where you have hosted your site. Try using the
Request.ServerVariables ("APPL_PHYSICAL_PATH") and then concat the remaining folders to this path to access the database .mdb you are trying to...
That is because you are not trying to update a particular record. Everytime you are updating only first record. If you want to update all the records, run it in the loop or use SQL update query rather than using Recordset's update method.
Hope this helps
Thanks
Hitesh
To do it on the client-side using javascript, you can create different arrays for different values, & then based on the value selected in the drop down box, you can load a particular array in the drop down using the javascript.
Hitesh
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.