autoexecute and NULL values
| From: | Kevin McCarthy | Date: | Tue, 22 May 2007 00:42:01 +0000 |
| Subject: | autoexecute and NULL values | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-27345@lists.php.net to get a copy of this message | ||
In learning to PEAR DB, I am stumped on how to use autoExecute() for INSERT
or UPDATE when some fields should be set as NULL in the database record. If
I leave the field empty, this does not translate to NULL in the actual query
generated yielding an error when a value is expected.
I could simply check each field set in the autoExecute() fields array before
including it but I'd expect that there is a more elegant solution.
Any help appreciated. TIA
--
Kevin McCarthy
kemccarthy1@gmail.com