That last error seems that perhaps your recordset is in the default firehose forward-only style.
Try using a client side cursor and if that doesn't work post your connection string.
If you only want the last record and are not using thte other records elsewhere on the page then the best idea...
I bet if you look in the server activity logs that the browser is actually sending two HTTP Requests in quick succession so it is causing the page to run twice.
I’d also wonder if it is the browser’s fault or some plug-in… does it happen on a fresh empty install of firefox?
Finally if you are...
Doing this opens you up to the same kinds of security problems associated with SQL Injection except, with this technique it is your web server that could execute a bad command instead of your database server... even the dumbest of script-kiddies will try del c:\*.* which could be a problem...
Well technically you can do it but it leads to so many potential security problems that its best to pretend that you can't and find a different technique.
If you have access to the IIS Admin tool then just change your app to disable anonymous access... then use the file system to set permissions on the folder and files where your web app lives.
Maybe yuour example code was truncated or something because I dont see anywhere you actually execute the nice SQL statement to do the update.
Anyway, see if you can get it working to update with a simple hard-coded SQL statement. This will make it easier to track downt he problem.
If you have all the values to be able to know that the submit button should not be displayed, then dont even write the HTML for the button to the Response.
<%
If ShowButton = True Then
%>
<input type="submit" name="btnSubmit" value="Click Me!">
<%
End If
%>
First thing to do is determine what the plain HTML would be to create the required result. Once you have this it will be easier to construct some ASP for building the HTML.
If the character string contains \n and the output of the ASP looks like this:
outputstr = "abcd
efgh
Then the ASP must be written in JavaScript and the \n is being evaluated rather than being sent to the browser... If this is indeed the problem then it should be fixed by replacing "\" with...
When damber wrote "If it only includes html, js, css, etc, (i.e. client side stuff) then just write out the raw content, as this is rendered by the browser, not the ASP server." he meant to use the FSO's OpenTextFile function to get a TextStream object and us its ReadAll function to grab the...
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.