MS SQL

Pierre Sahores sc at sahores-conseil.com
Fri Apr 25 03:45:57 CEST 2014


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.rodney at 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.rodney at 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.rodney at 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 <pete at 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.rodney at 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 <pete at 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" <jacque at 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         |     jacque at hyperactivesw.com
>>>>>>>> HyperActive Software           |     http://www.hyperactivesw.com
>>>>>>>> 
>>>>>>>> _______________________________________________
>>>>>>>> use-livecode mailing list
>>>>>>>> use-livecode at 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 at 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 at 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 at 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 at 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




More information about the use-livecode mailing list