Lee wrote:
Are you escaping the data you insert? If you have apostrophies eg.
"Sheryl's Website", you could have problem if you do not escape special
chars. See if it happens with just "aaaaaa" (without the quotes) in all
the fields in the record...then try unescaped words with apostrophies.
I'm not, and I should be. It not the cause of my data disappearing problem
because my test data was safe, but I shouldn't assume that customer-entered
data will be safe. Thanks for the reminder.
A nasty is case sensitivity. Some MYSQl vers. (esp. unix vers.) install
with case sensivity turned on - so make sure all your table names and
stuff match case.
I'm used to that with Unix - everything is case-matched.
Par down the PHP or what ever script you're using to the minimum ie.
make the test case as blatently simple SQL as possible.
I can't reproduce it with a simple case. It's an intermittant problem, and
it seems to be related to some complexity buried in my program.
- Sheryl
10 messages in com.mysql.lists.mysqlRE: disappearing data - please help!