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

2014-03-12 Thread 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 wrote: > Okay so the syntax for sqlYoga would be: > > put sqlquery_createObject(“words”), theQueryObject > sqlquery_set theQueryObject, “select clause”, "wordID,

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

2014-03-12 Thread Bob Sneidar
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 theQuer