donsafar
Posts: 90
|
Posted: 04/08/2004, 12:00 AM |
|
Thought I would post this, since I have spent a number of hours the last several days trying to resolve a problem. I am working on a system that uses php and access. I put some custom code in various places using the custom sql in the documentation as a model. The application was behaving very erratically. Sometimes adding records, sometimes not. After spending several hours (4.5) over 2 days I found the problem. At the end of the custom code it closes the connection with this command --- unset($db); When I changed it to this
-- $db->Close();-- the problems disappeared. BTW, usin unset doesn't present a problem with SQL Server or MySQL. Using php 4.3.3, mdac 2.8RTM, win xp sp1. Probably aren't too many of you using php with access, but I thought I would put this on the forum to save anyone else some grief.
_________________
Don Safar
|
|
|
peterr
Posts: 5971
|
Posted: 04/08/2004, 12:16 AM |
|
You're right. This was recently discussed at http://forums.codecharge.com/posts.php?post_id=44755 and the changes in the docs will be present in the next update release.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|