Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: Problem using rs.Find


Message #1 by purrhapz@f... on Wed, 28 Jun 2000 14:41:5
Hi,

I am having a problem using rs.Find in my asp. The recordset is working, I 

am able to do rs.MoveFirst, rs.MoveLast, and rs.MoveNext.



rs_Options.MoveFirst

strSingleMutex = arrMutex(index)

strSearch = "VAC = '" & CStr(strSingleMutex)& "'"

vbNewLine & "rs_Options VAC is: " & rs_Options("VAC")

'move the rs to the mutex option

rs_Options.Find strSearch



This works on my machine (Which houses the IIS) but on my other client it 

gives me the error: "The operation required by the application is not 

supported by the provider."



I used MsgBoxes to display the strSearch, it is correct. Any tips?

Thanks!

Message #2 by Tomm Matthis <matthis@b...> on Wed, 28 Jun 2000 14:00:41 -0400
The .Find method has to be implemented by the provider. Which db and driver are

you using?



Tomm



purrhapz@f... wrote:

> 

> Hi,

> I am having a problem using rs.Find in my asp. The recordset is working, I

> am able to do rs.MoveFirst, rs.MoveLast, and rs.MoveNext.

> 

> rs_Options.MoveFirst

> strSingleMutex = arrMutex(index)

> strSearch = "VAC = '" & CStr(strSingleMutex)& "'"

> vbNewLine & "rs_Options VAC is: " & rs_Options("VAC")

> 'move the rs to the mutex option

> rs_Options.Find strSearch

> 

> This works on my machine (Which houses the IIS) but on my other client it

> gives me the error: "The operation required by the application is not

> supported by the provider."

> 

> I used MsgBoxes to display the strSearch, it is correct. Any tips?

> Thanks!


  Return to Index