well Howie !.
key_issues field is a charecter field.. it throws erroer
-paul
--
On Tue, 17 Apr 2001 10:43:42
Howie Hamlin wrote:
>remove the quotes around key_issues like:
>
>select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY
>key_issues DESC
>
>HTH,
>
>Howie Hamlin - inFusion Project Manager
>On-Line Data Solutions, Inc.
>www.CoolFusion.com
>631-737-4668 x101
>inFusion Mail Server (iMS) - the World's most configurable mail server
>
>
>----- Original Message -----
>From: "paul ." <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Tuesday, April 17, 2001 10:34 AM
>Subject: check this please
>
>
>> Hi Guys !
>> this is the SQl
>> ----------------
>> select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY
>'key_issues' DESC
>>
>> ----------
>> "key_issues" field has characters and i want the table to be sorted by
>the key_issues alpahebeticaly .
>> kindly sugest
>> -paul
>>
>> --
>>
>> On Tue, 17 Apr 2001 09:16:27
>> Hayes, David wrote:
>> >If you're trying to sort by the 4th item in the columns list, omit the
>> >single quotes around 4.
>> >
>> >Given that you are using the * to select all the columns, I suggest
>> >specifying the column name in your order by clause. The next programmer
>> >(maybe you) who looks at the code will be glad you did; also, if the
>column
>> >order in the table is changed, you'll get unexpected results.
>> >
>> >-----Original Message-----
>> >From: paul . [mailto:[EMAIL PROTECTED]]
>> >Sent: Tuesday, April 17, 2001 8:53 AM
>> >To: CF-Talk
>> >Subject: order by not working
>> >
>> >
>> >Hi guys am using orderby to sort the fields to get the sort order
>> >alphabetically am finding taht is not working please suggest
>> >-----------------------
>> >select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY
>> >'4' ASC
>> >----------------
>> >the above is the SQL whats wrong>>
>> >-paul
>> >
>> >
>> >Get 250 color business cards for FREE!
>> >http://businesscards.lycos.com/vp/fastpath/
>>
>> >
>>
>>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
