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 |
|
vraya
Starting Member
5 Posts |
 Posted - 2008-08-14 : 04:23:16
|
| I got 2 modules1st Admin module where i have multiple checkboxes which i check them and save their corresponding Name with Id into Table. Am saving some Images name with path information into it.2nd module where same check box pattern is provided and search for those images which matches the same checkbox names. I require some select queries which matches these checkbox names.I want to avoid Multiple select queries because i got around 60 checkboxs and those names are saved..Am using C# And Sql Server 2005 as backend.Please helpmeVijayaraya |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-14 : 05:48:11
|
| for 1st module just add the checkboxes to form and get the values using form request object in your application. then pass the values as a comma seperated values and save them in db. For searching just pass them as comma seperated values and parse them using some parsing udfs (you can find couple of them inside this forums). |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-08-14 : 06:24:46
|
| http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htmMadhivananFailing to plan is Planning to fail |
|
|
|
vraya
Starting Member
5 Posts |
Posted - 2008-08-14 : 08:02:12
|
quote:
Originally posted by visakh16
for 1st module just add the checkboxes to form and get the values using form request object in your application. then pass the values as a comma seperated values and save them in db. For searching just pass them as comma seperated values and parse them using some parsing udfs (you can find couple of them inside this forums).
I want to perform this operation using OR-Mapping Tool LLBLGEN Version 1.00.2005Vijayaraya |
|
|
|
|
|
|
Select Query for Multiple Checkboxes