Sorry was in a hurry while replying to you and thought I must add this bit of info too.. The ARS automatically puts a terminating chracter ';' to an SQL statement when written in a Direct SQL or in a SQL Menu. If you put a terminating character in there, then ARS puts another, and you might get that error you are getting that the SQL statement was not properly ended.. Please do correct your statements for the NULL comparison and the name of the view too as per my instructions in my last two emails.. Cheers Joe
----- Original Message ---- From: Rick Cook <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Tuesday, September 16, 2008 12:56:47 PM Subject: Re: Help with Oracle select statement ** OK, that makes sense, thanks. I think I'm close, but would like someone with more knowledge than I to take a look at my conversion and tell me why it's not working. Here's the original in a Query menu: (Selecting Tier 1 of a Category/Type/Item) ( 'Generic Categorization Tier 2' = $1000000745$) AND ( 'Generic Categorization Tier 1' = $1000000744$) AND ( 'Generic Categorization Tier 3' != $NULL$ ) AND ( 'Category Status' = "Enabled") AND ( 'Category Type' = $1000002257$) I am attempting to add the Order by qualification and do it from a SQL menu. Here's what I have so far: SELECT Generic_Categorization_Tier_1 FROM CIS:HPD:Menu_Item_Ranking WHERE (Generic_Categorization_Tier_1 != NULL) AND (Category_Status = 'Enabled') AND (Category_Type = $1000002257$) ORDER BY Usage desc; I get an error saying ORA-00933: SQL command not properly ended. Rick On Tue, Sep 16, 2008 at 7:35 AM, Wallace, Kelvin <[EMAIL PROTECTED]> wrote: ** Rick, Try this: SELECT field1 FROM form ORDER BY field2 DESC; Kelvin ________________________________ From:Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Tuesday, September 16, 2008 10:16 AM To: arslist@ARSLIST.ORG Subject: Help with Oracle select statement ** Am looking to get some specific syntax on a SQL call ARS 7 to Oracle 9 that would do the following: Select field1 from Form order by field2 (field2 is int field. I want the sort done highest value to lowest) Thanks! Rick _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
