|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
September 28th, 2006, 05:53 AM
|
|||
|
|||
|
Order by alias name
i have two database
first name is deneme1.fdb second name is deneme2.fdb when i tray the "select web_pin as CN from cariykli where cariykli.yetkili_no=7 order by cn" sql i fetch the row with first database.. same sql syntax does not work second database.. how can i fix this problem thank
|
|
#2
September 29th, 2006, 01:27 AM
|
|||
|
|||
|
Do you have a column "cn" in the first database?
As far as I know, order by <alias> would never work. Use order by 1 (or 2, or whatever the column index is in the result). Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle & MS SQL Server Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com
|
|
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Order by alias name |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
