Web Development

Ask something
Discussion Locked

Different db query/dropdown result

0 helpful
1 reply

by carlhe

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I amusing frontpage 2002 and have a simple page with one dropdown box containing three entries. These entries filter a sqlserver table by returning either all records,or a subset. How do I get each dropdown result to send the query to the db to return the results?

1 reply

by salini_m_s

create a database connection such as Conn
strQry="select * from table_name where field_name='" & drop_box.text & "'"

set Rs=Conn.Execute(strQry)

Rs("field_name") contains selected data

This discussion is closed to new replies.