ASP

I want to get a recordset value ( whose query is dependent on one client side textbox value) in combo box without refreshing or posting my page, Is that possible, if yes, how?

Ash

[Lothar Haensler]

in IE 5 you can use RDS (=remote data services).
if ou don't want that use a hidden IFRAME.

Could you give a small example illustrating this features, it would be of great help.

Ash

[Lothar Haensler]

here is an RDS sample from MSDN:

<OBJECT CLASSID="clsid:BD96C556-65A3-11D0-983A-00C04FC29E33" ID="DC1">
<PARAM NAME="SQL" VALUE="SELECT * FROM Authors">
<PARAM NAME="Connect" VALUE="DSN=Pubs;">
<PARAM NAME="Server" VALUE="http://YourServer/"&gt
</OBJECT>
...
<SCRIPT LANGUAGE="VBScript">

Sub RDSTutorial2A()
Dim RS
DC1.Refresh
Set RS = DC1.Recordset
...

I am giving you my problem as example, suppose i have a table where country and state are mapped, i want that when my user specifies the country name in one combo than the corresponding combo of state is filled with states in that country after referring to database table, i.e if user fills U.S. in one combo than that value be taken to server to query for states in U.S. and recorset returned so that next combo is filled with that recordset without refreshing the page.

Ash