mySQL & RevEnterprise: queries not returning expected values

Bob Sneidar bobs at twft.com
Sun May 23 22:37:37 EDT 2010


Make sure you enclose values in real quotes. Mysql seems to handle  
numerical values without quotes but when a value is text it will  
interpret the text as a column name if it's not in quotes.

Bob Sneidar
IT Manager
Calvary Chapel CM
Sent from iPhone

On May 23, 2010, at 6:12, Ian McKnight <iangmcknight at googlemail.com>  
wrote:

> However replacing 12 with U (or PG 12A etc) does not - it gives a
> revDBerr, Unknown column 'U' in 'where clause' - and a similar
> response when searching the GENRE field.



More information about the use-livecode mailing list