hi Guys this is what i got by removing the single quote
--------------
DB2 Error Code = -134
[IBM][CLI Driver][DB2/6000] SQL0134N Improper use of a string column, host variable,
constant, or function "KEY_ISSUES". SQLSTATE=42907
SQL = "select * from UHC.PCA_SPECIAL where team_idx=1 and quarter_idx=5 ORDER BY
key_issues DESC"
Data Source = "QRTREPORTS"
----------------------------------------------------
-paul
--
On Tue, 17 Apr 2001 08:26:18
Dylan Bromby wrote:
>take the single quotes out.
>
>-----Original Message-----
>From: paul . [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, April 17, 2001 7:34 AM
>To: CF-Talk
>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
