I use it all the time in most of my projects running in a LC-Server+PostgreSQL+RevIgniter+JQuery context (no experimented against MS SQL Server at all, sorry). See below for a daily working example witch builds on the fly an HTML5/JQuery multi-hierarchical pulldown menu :
> put revDataFromQuery(tab, return, myDatabaseID, "SELECT p.product_id, > c.category_id, d.department_id, p.name AS product_name, c.name_ascii127 AS > category_name," && \ > "d.name_ascii127 AS department_name, d.rank AS > department_rank, c.rank AS category_rank, c.name AS category_title, d.name AS > department_title" && \ > "FROM" && gData["product_dbtable"] && "p INNER JOIN" && > gData["product_category_dbtable"] && \ > "pc on p.product_id = pc.product_id INNER JOIN" && > gData["category_dbtable"] && "c on pc.category_id = c.category_id" && \ > "INNER JOIN" && gData["department_dbtable"] && "d on > c.department_id = d.department_id ORDER BY department_name, category_name, > product_name") into dbRecordSets[" menu_r1"] Best, Pierre Le 25 avr. 2014 à 00:51, Rodney Green <green.rod...@gmail.com> a écrit : > I'm curious, does anyone have a project that uses the revDataFromQuery() > command? And does anyone use the Actual Technologies ODBC driver? > > > On Thu, Apr 24, 2014 at 9:23 AM, Rodney Green <green.rod...@gmail.com>wrote: > >> I'll put in a bug report for this. Does anyone have any kind of >> work-around for this? Have there been any updates to database in the >> developer previews? Maybe I'll give a DP a try. >> >> >> On Wed, Apr 23, 2014 at 7:53 PM, Rodney Green <green.rod...@gmail.com>wrote: >> >>> I tried it in 6.6 and 6.6.1. I'm using Actual Technologies ODBC manager >>> (demo). And I can connect successfully to the SQL server with Navicat. I'm >>> on a Mac (10.9.2) and connecting via a VPN. >>> >>> >>> On Wed, Apr 23, 2014 at 7:17 PM, Peter Haworth <p...@lcsql.com> wrote: >>> >>>> That seems strange - I wouldn't expect to see field names, just the data >>>> in >>>> them. What version of LC are you using? Might be time to enter a bug >>>> report. >>>> >>>> Pete >>>> lcSQL Software <http://www.lcsql.com> >>>> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and >>>> SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html> >>>> >>>> >>>> On Wed, Apr 23, 2014 at 2:47 PM, Rodney Green <green.rod...@gmail.com >>>>> wrote: >>>> >>>>> I turned on tracing in the odbc driver and I can see field names in the >>>>> data. So I'm assuming the query is working. But still can't figure out >>>> why >>>>> LC is hanging. I have database checked in the stand alone settings, not >>>>> sure if this matters while in LC. Any ideas how I can track down why >>>> LC is >>>>> hanging? >>>>> >>>>> >>>>> On Wed, Apr 23, 2014 at 10:13 AM, Peter Haworth <p...@lcsql.com> >>>> wrote: >>>>> >>>>>> In gmail, you can fix that by using the "Paste and match style" >>>> option on >>>>>> the edit menu. >>>>>> >>>>>> Pete >>>>>> lcSQL Software >>>>>> On Apr 22, 2014 7:34 PM, "J. Landman Gay" <jac...@hyperactivesw.com> >>>>>> wrote: >>>>>> >>>>>>> On 4/22/14, 6:49 PM, Kay C Lan wrote: >>>>>>> >>>>>>>> I don't know if it's just your email client but what I'm seeing >>>> is an >>>>>>>> asterisk * around the words get, put and return which shouldn't be >>>>>> there. >>>>>>>> >>>>>>> >>>>>>> That happens to all keywords when a colorized script is copied >>>> from the >>>>>>> script editor and pasted into a text-only email list. I see it >>>> here all >>>>>> the >>>>>>> time. >>>>>>> >>>>>>> -- >>>>>>> Jacqueline Landman Gay | jac...@hyperactivesw.com >>>>>>> HyperActive Software | http://www.hyperactivesw.com >>>>>>> >>>>>>> _______________________________________________ >>>>>>> use-livecode mailing list >>>>>>> use-livecode@lists.runrev.com >>>>>>> Please visit this url to subscribe, unsubscribe and manage your >>>>>>> subscription preferences: >>>>>>> http://lists.runrev.com/mailman/listinfo/use-livecode >>>>>>> >>>>>> _______________________________________________ >>>>>> use-livecode mailing list >>>>>> use-livecode@lists.runrev.com >>>>>> Please visit this url to subscribe, unsubscribe and manage your >>>>>> subscription preferences: >>>>>> http://lists.runrev.com/mailman/listinfo/use-livecode >>>>>> >>>>> _______________________________________________ >>>>> use-livecode mailing list >>>>> use-livecode@lists.runrev.com >>>>> Please visit this url to subscribe, unsubscribe and manage your >>>>> subscription preferences: >>>>> http://lists.runrev.com/mailman/listinfo/use-livecode >>>>> >>>> _______________________________________________ >>>> use-livecode mailing list >>>> use-livecode@lists.runrev.com >>>> Please visit this url to subscribe, unsubscribe and manage your >>>> subscription preferences: >>>> http://lists.runrev.com/mailman/listinfo/use-livecode >>>> >>> >>> >> > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode -- Pierre Sahores mobile : 06 03 95 77 70 www.sahores-conseil.com _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
