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 |
|
h-hemdan
Starting Member
2 Posts |
 Posted - 2010-07-15 : 13:51:22
|
| hi , lets say i have Table called Voters like that ID Name VoterNumber electionplace etc ,1 nick marly 33 area 1 2 ali ibrahim 47 area 13 hesham hemdan 34 area 2 if i have list of names on piece of paper include 10 names and i want to put this names in control such listbox or richtextbox , to contain all entered names , and compare them by the Name column and bring me back the data with the same name i need opinion of expert to tell me wich is the best way to accomplish that , thank you |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2010-07-15 : 14:01:48
|
| select ID,Name,VoterrNumber,ElectionPlacefrom voterswhere name= namepassedinfromfrontendJimSoon I believe you'all ask how to pass in multiple namesEveryday I learn something that somebody else already knew |
 |
|
|
h-hemdan
Starting Member
2 Posts |
Posted - 2010-07-15 : 15:08:51
|
| i dont understand what is namepassedinfromfrontend |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-07-16 : 11:27:06
|
quote:
Originally posted by h-hemdan
i dont understand what is namepassedinfromfrontend
It is the input selected from the listboxMadhivananFailing to plan is Planning to fail |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-07-17 : 06:06:23
|
| What is the front- end app you are using?Typically , either an embedded sql statement or a stored procedure - will accept an input parameter. This will search the relavent tables and return a recordset. The app must invoke functions which grab the recorset\ and move to the presentation layerJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
search in table , more than one Name ?