SQLYoga and LC 6.6 - Found word(s) list error in the Text body - Found word(s) list error in the Text body

[Bob Sneidar]

add sqlquery_set theQueryObject, “limit”, “1” if you only want the first occurrence. 

Bob


On Mar 12, 2014, at 16:10 , Bob Sneidar <bobsneidar at iotecdigital.com> wrote:

> Okay so the syntax for sqlYoga would be:
> 
> put sqlquery_createObject(“words”), theQueryObject
> sqlquery_set theQueryObject, “select clause”, "wordID, targetWord, questionStem, answer, distractor1, distractor2”
> put "wordID LIKE :1“ into theConditions
> put “5-C%” into aBindings [1]
> sqlquery_set theQueryObject, “conditions”, theConditions
> sqlquery_set theQueryObject, “condition bindings”, aBindings
> sqlquery_retrieveAsData theQueryObject, theQueryData
> 
> You can do something similar with sqlrecord, but it will always return record objects, not text data.
> 
> Also, make SURE you run sqlyoga_reloadSchema() if you have made any alterations to your database schema and save the database object you are using (if you are using one).
> 
> Bob
> 
> On Mar 12, 2014, at 11:16 , Chris Sheffield <cmsheffield at icloud.com<mailto:cmsheffield at icloud.com>> wrote:
> 
> Pete,
> 
> I don’t get any kind of error message. In fact, the query sort of returns successfully. It just doesn’t return all the results. When running the query I showed earlier, I only get back the value of the wordID field. No other field values are returned.
> 
> _______________________________________________
> 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