|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
May 3rd, 2004, 02:35 AM
|
|||
|
|||
|
sql stmt - urgent
hi everybody,
as i need to display a list of departments, i want the word 'OTHERS' to b listed either top or bottom of the drop down list? isit possible?? as now my list is in alphabet order. I m using asp for my programming pls give me some advice thanks in advance
|
|
#2
May 4th, 2004, 09:23 AM
|
||||
|
||||
|
i think this would fit better in the .NET development (or if normal asp in the ASP) Forum
however there is an sql solution: create a view on your department table and union it with the static record you want in example: CREATE VIEW dbo.DepartmentsOther AS SELECT ID, Department FROM Departments UNION SELECT null AS ID,'OTHERS' AS Department There are also several solutions to this problem outside of SQL server, but for those you better post in the respective programming forums
|
|
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > sql stmt - urgent |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
