Retrieving ADODB.Recordset Asynchronously

[Lammers]

I know from VB (and via the MSDN library) that you can retrieve ADODB.Recordset asynchronously via the properties and using adUseClient and adAsynchFetch.
Having done various test .asp files, I can only assume that it's not possible in ASP? Is this right?

If so, has anyone come up with a nice solution to users who keep pressing the SUBMIT button on a web page whilst a query is occurring?

The best it seems is to use response.isClientConnected, but this is after the fact. That is, only after the query is completed. Is there a way to stop a query, once it has started in ASP?



Peter.

 

[link9]

Well, if you're just worried about someone clicking the button twice, you could disable the button once it's been clicked.

<script language=javascript>
var clicked = false;

function submitMe(){
if (!(clicked)){
clicked = false;
return true;
}
return false;
}
</script>

<form name=theForm method=post action=somePage.asp onSubmit=&quot;return submitMe();&quot;>


paul