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 <cmsheffi...@icloud.com<mailto:cmsheffi...@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
