Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
globemast
Starting Member
32 Posts |
 Posted - 2003-03-21 : 07:40:15
|
| Hello i want to create a search page for my Intranet..Basically what i want is to create a search field that it will allow me to search within an SQL database Table called "People".What i have done so far is to create a listbox to populate the options for searching like (username,Name,Tel,Address) and a textbox for the user to type in what he wants to search.When the user press the Search button i want all that has matched the search to be populated to a dynmic table.Can you help me with the SQL command that will search in the table? |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2003-03-21 : 07:49:43
|
| Are you refering to SELECT Statement?. Do you want to create a dynamic table in frontend or in SQL ?Sekar~~~~Success is not a destination that you ever reach. Success is the quality of your journey. |
 |
|
|
globemast
Starting Member
32 Posts |
Posted - 2003-03-21 : 08:02:06
|
| yes i am refering to the select statment....i will create the dynamic table in Dreamweaver..Is this SQL command correct?"select * from People where '"listbox.value"' = '"textbox.value"'" |
|
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2003-03-21 : 08:18:06
|
| SQL = "select * from People where " & listbox.value & "='" & textbox.value & "'" Sekar~~~~Success is not a destination that you ever reach. Success is the quality of your journey. |
|
|
|
globemast
Starting Member
32 Posts |
Posted - 2003-03-21 : 08:23:21
|
| are you familiar on how to create the Dynamic table using ASP in VBScript? |
|
|
|
|
|
|
Help for Creating a Search field