|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
July 7th, 2003, 04:27 AM
|
|||
|
|||
|
DataBase Search
Hi,
I am looking for a bit of advise. I am currently working on a database search which will eventually be deployed on the web. The search primarily searches only one table, but this table has over 50 fields and search parameters may be supplied for about thirty of these. At the moment I plan to have drop down list boxes to select the required parameters and to dynamically generate an SQL string which will then be run against the database. This obviously will become incredibly complex and I am looking for a better solution. Has anyone experience of this type of problem? Any advice on a better method or any advice on generating complex search strings would be greatly appreciated. Thanks.
|
|
#2
July 7th, 2003, 05:03 AM
|
||||
|
||||
|
it is not really all that complex
here's an article i wrote on constructing this type of dynamic sql (note free registration on that site is required): http://searchdatabase.techtarget.co...x285649,00.html
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > DataBase Search |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
