RE: disappearing data - please help!

2005-01-31 Thread Sheryl \(Permutations Software\)
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 aa (without the quotes) in all the fields in the record...then try unescaped words with apostrophies. I'm

RE: disappearing data - please help!

2005-01-31 Thread Mark
-Original Message- From: Sheryl (Permutations Software) [mailto:[EMAIL PROTECTED] Sent: maandag 31 januari 2005 14:44 To: 'leegold'; mysql@lists.mysql.com Subject: RE: disappearing data - please help! Par down the PHP or what ever script you're using to the minimum ie. make

Re: disappearing data - please help!

2005-01-30 Thread Jason Martin
On Sun, Jan 30, 2005 at 03:28:56PM -0500, Sheryl (Permutations Software) wrote: but I'm having the most frustrating problem. Data I've inserted simply VANISHES. What is the setting for AutoCommit? If it is 0, are you sure that commit is being called before the session ends? -Jason Martin --

RE: disappearing data - please help!

2005-01-30 Thread Sheryl \(Permutations Software\)
- From: Jason Martin [mailto:[EMAIL PROTECTED] Sent: Sunday, January 30, 2005 3:38 PM To: mysql@lists.mysql.com Subject: Re: disappearing data - please help! On Sun, Jan 30, 2005 at 03:28:56PM -0500, Sheryl (Permutations Software) wrote: but I'm having the most frustrating problem. Data I've

Re: disappearing data - please help!

2005-01-30 Thread Jason Martin
On Sun, Jan 30, 2005 at 04:03:37PM -0500, Sheryl (Permutations Software) wrote: transactions. It's just the default. I don't know where I'd check AutoCommit settings (or it they even apply to the default database type). It doesn't refer to this in phpinfo.php. Try doing this immediately after

RE: disappearing data - please help!

2005-01-30 Thread Mark
-Original Message- From: Sheryl (Permutations Software) [mailto:[EMAIL PROTECTED] Sent: zondag 30 januari 2005 21:31 To: mysql@lists.mysql.com Subject: disappearing data - please help! What makes this all the more mysterious is that it happens intermittently. Sometimes when the

RE: disappearing data - please help!

2005-01-30 Thread leegold
From: Sheryl (Permutations Software) [mailto:[EMAIL PROTECTED] Sent: zondag 30 januari 2005 21:31 To: mysql@lists.mysql.com Subject: disappearing data - please help! What makes this all the more mysterious is that it happens intermittently. Sometimes when the script completes