Search results for query: *

Adding a field is possible with SQL's ALTER TABLE statement. E.g. ALTER TABLE table_name ADD column_name TEXT(20) (Execute as a query.)

To be more accurate: the FETCH_STATUS will reflect the last cursor that executed a FETCH statement state.

2 to 3 yrs later... Microsoft's documentation states that the @@FETCH_STATUS is a global variable, and therefore will be 0 (still records) in an inner cursor, even if only the outer one has more records, and vice-versa.

Myabe the problem is because on default the Session_onEnd runs as the Anonymous user. Refer to: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/iisref/htm/ref_scrpt_glsesevntonend.asp

Are you trying to call a procedure in your asp code from the browser, or to call a client procedure (in JavaScript, for an example)? The ASP code is running on the server before sending the results to the browser client, and it's basically not possible to call it from the client.

You can call the javascript to submit from body's unload event. For information about the unload event see: http://msdn.microsoft.com/workshop/author/dhtml/reference/events/onunload.asp

The javascript to submit is: window.document.FormName.submit();

try to use response.write("here write client vbscript that will run your function"). Just an idea, haven't test it.

I don't know much about JDBC but I'm just guessing, without testing, that the problem might be because you omitted a terminator (semicolon or another character) after the SQL statement, which most RDB's require.