mySQL & RevEnterprise: queries not returning expected values

[Bob Sneidar]

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.