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 <iangmckni...@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.
_______________________________________________
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Reply via email to