How do I view a query from MS Access using ASP 1

[StephenGriff]

Hi im trying to write a Select * from ..... statement to view a query. I need users to select their number from a drop down menu and then vioew only the data for that user.

The combo box is called "number" (for example) and the query is called "data" , any ideas how i would go about this?

thanks in advance

Steve

 

[SHARKY99]

Here's an example

vSql="SELECT TabHoraire.NoLocal, TabHoraire.* FROM TabHoraire WHERE (((TabHoraire.NoLocal)='B1203'));"
rsHor.open vSql,dbReserv,1,2,1

TabHoraire is your table
NoLocal is your field
B1203 is your search criteria


I'm not an SQL programmer so i just open Access make my query and then hit the SQL(top left) button copy the SQL and voila...

Sharky99 >:O>

 

[StephenGriff]

How would i use response.write with the above?

thanks in advance

 

[SHARKY99]

ie. response.write(rsHor("NoLocal&quot)

That's it Have fun...

Sharky99 >:O>