Auto speller typo correction : read dbRecordSets["menu_r1"] instead of dbRecordSets[" menu_r1"]
> 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 > -- 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
