Thanks for the suggestion Phil. I just tried it and unfortunately ARS said "no".
I'll keep digging, but I guess for now I'll just need to use a SQL view. Thanks again, Charlie On Tue, Feb 19, 2019 at 11:00 AM Phil Murnane <[email protected]> wrote: > Hi Charlie, > > > > Don’t know if this will help, but I frequently see CTEs written with a > leading semicolon before the WITH keyword – e.g. ;WITH cte AS… > > > > IIRC this is required by the SQL engine -- maybe give that a shot? > > --Phil > > > > *From:* ARSList <[email protected]> *On Behalf Of *Charlie > Lotridge > *Sent:* Tuesday, February 19, 2019 1:37 PM > *To:* ARSList <[email protected]> > *Subject:* Common Table Expression SQL for menus > > > > Hi all, > > > > I'm trying to use a SQL query containing a Common Table Expression for a > drop-down menu. I can see that the query is submitted to the server and is > appropriately generating results. But the menu comes back as empty. > > > > For anyone not familiar, a Common Table Expression (CTE) is a construct > supported by (at least) SQL Server that allows for some extreme flexibility > in the generation of result sets, in some cases things that you just can't > do without it. In SQL Server queries containing CTEs begin with a "WITH" > keyword instead of "SELECT". I don't know if other database systems support > this construct. > > > > One workaround is to embed the query into a SQL view, then query the view. > I've used this workaround in the past but it is not entirely convenient or > elegant. > > > > Has anyone else had this problem and maybe have some insight as to why > it's failing or perhaps developed a better workaround? > > > > Incidentally, this is on an ARS system running v8.1. > > > > Thanks, > Charlie > -- > ARSList mailing list > [email protected] > https://mailman.rrr.se/cgi/listinfo/arslist >
-- ARSList mailing list [email protected] https://mailman.rrr.se/cgi/listinfo/arslist
