On Tue, 2002-09-03 at 16:31, Matthias Trevarthan wrote: > And here is my update query: > > update vbooth_data set optionText='Not at all, I'm waiting for the other shoe > to drop' where (pollID='34' AND voteID='3'); > > When I hit Enter, it gives me this prompt: > > '>
This prompt indicates you did not close the '' signs, IMHO the ' in "I'm" is causing the problem, sql must think your command ends after the I. I think you can simply escape the ' with something like \'. HTH p.s. you will find the explanation of the different prompts in point 3.2 of the Mysql manual... -- # Mertens Bram "M8ram" <[EMAIL PROTECTED]> Linux User #249103 # # Red Hat Linux 7.3 KDE 3.0.0-10 kernel 2.4.18-3 i686 128MB RAM # --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
