add sqlquery_set theQueryObject, “limit”, “1” if you only want the first occurrence.
Bob On Mar 12, 2014, at 16:10 , Bob Sneidar <[email protected]> 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 > <[email protected]<mailto:[email protected]>> 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 > [email protected] > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
