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 |
|
bubberz
Constraint Violating Yak Guru
289 Posts |
 Posted - 2006-05-30 : 15:53:56
|
| I have a ddl that I'd rather not post all the records in the table to it. It's huge.I'm trying to look for something like "type ahead" where the user types in the first or second character of the list, then the list is populated.So, if the user starts to type "C", then all the people with a last name of "C" will show, and if they then type and "o", so the value is now "Co", all users with a last name of "Co" will show.Anyone had any experience with this?thanks! |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2006-05-30 : 16:26:56
|
| Well, since I'm guessing you are trying to do this in ASP.net you may need some AJAX or Atlas to handle something like this. IE after some period of seconds after the user changes a text box, postback behind the scenes, grab the data, and populate a list.I've never done this, but that's about what you'd need to do.Michael<Yoda>Use the Search page you must. Find the answer you will. Cursors, path to the Dark Side they are. Avoid them, you must. Use Order By NewID() to get a random record you will.</Yoda>Opinions expressed in this post are not necessarily those of TeleVox Software, inc. All information is provided "AS IS" with no warranties and confers no rights. |
 |
|
|
bubberz
Constraint Violating Yak Guru
289 Posts |
Posted - 2006-05-30 : 16:48:51
|
| Thanks MichaelP!Yes, were're on 1.1, so I guess I'll need to go the AJAX route. |
|
|
|
|
|
|
|
|
dynamically build ddl from characters entered