|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
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
October 6th, 2004, 09:41 PM
|
|||
|
|||
|
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
October 6th, 2004, 11:06 PM
|
|||
|
|||
|
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
October 7th, 2004, 09:28 AM
|
|||
|
|||
|
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>
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > ColdFusion Development > search alphabetically |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
