GH wrote:
I am trying to insert data in the ProgressNotes Table using the
following query but it does not work. Can someone please assist? Thank
You.
[snip]
'Understandably, the consumers were upset. The Dean (SR) was kind
enough to try and help explain to our members that there was a
communications problem that caused the paperwork not to be completely
in place before we started the program. LL and I got the members'
phone numbers so that we can advise them if we are canceled next week.
[snip]
You've got a single apostrophe after "members" in the text above. If
you want it to insert the apostrophe, it needs to be escaped or doubled up.
...and I got the members'' phone numbers so....
There may be others, but that was the only one I could find. You'll probably
find that the other error relating to the select count(*)... may well disappear
when you fix this.
Hope this helps
Stephen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
