|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Generate data entry and reporting .NET Web apps in minutes, straight from your database. Read our FREE whitepaper “Build Web 2.0 Applications Without Hand-Coding” Download now! |
|
#1
|
|||
|
|||
|
search alphabetically
i have search page page which displays database and give me results based on the criteria i have chosen.I want the results in alphabetic order what should i do
![]() |
|
#2
|
|||
|
|||
|
You want to use the ORDER BY clause in your SQL:
select lastName from employees order by lastName I have to say that this is about as basic as SQL gets, so if you are unfamiliar with this sort of thing I would strongly urge you to buy a good SQL book if you plan on doing any further SQL programming. Ben Forta's "SQL in 10 Minutes" is very good and very concise: http://www.amazon.com/exec/obidos/t...il/-/0672325675
__________________
Ask if you have a question, but also help answer questions that you have knowledge of! Thanks, Brian. How to Post a Question in the Forums |
|
#3
|
|||
|
|||
|
search database
on the search page i have search option
1. search by criteria 2. search by a specific keyword in the criteria selected eg: keyword Fl under criteria state. <cfquery name="Recordset1" datasource="fdbi"> SELECT id, claimDate, prodItemNo, lastName, firstName , orderNo ,status ,shipToState ,repID FROM tbf where #criteria#='#keyword#' order by id desc </cfquery> |
|
#4
|
|||
|
|||
|
ok...but do you have a question?
|
![]() |
| Viewing: Dev Shed Forums > Programming Languages - More > ColdFusion Development > search alphabetically |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|