So... false. That being the case, test.php might be a little =20
misleading, as it checks for the mysql extension.
If I'm going to implement it portably, I might as well do it the hard =20
way for all. MySQL's INSERT ... ON DUPLICATE UPDATE is a convenient =20
short cut so that I don't have to first figure out if a row exists.
MySQL and SQLite support a REPLACE construct that is similar to INSERT =20
... ON DUPLICATE UPDATE, but PostgreSQL doesn't. There's a nasty =20
little T-SQL like construct that PostgreSQL has for equivalency, but =20
I'm not up for all of that.
I'm all for portability, but REPLACE (or INSERT ... ON DUPLICATE =20
UPDATE) should be a part of the blasted SQL standard. :)
bishop
Quoting Matthew Gregg <mat...@gm...>:
> The last time I tested phpESP would work with MySQL, Postgres and sqlite
> using ADODB. That was some time ago so it may not work cleaning against
> anything but MySQL now. However, I would really like to try and keep
> it working against my/post/lite. Is there anyway you can implement what
> you need using something portable? You'd probably need to add a
> function in admin/include/lib/espdatalib.inc to handle the different
> DB's:
> switch ($cfg['adodb_database_type']) {
> case "mysql":
> case "postgres":
> case "sqlite":
>
>
> On Fri, 2008-01-11 at 18:27 -0500, Bishop Bettini wrote:
>> I want to use a MySQL extension to SQL (INSERT ... ON DUPLICATE KEY
>> UPDATE), and I want to make sure that phpESP requires MySQL (even
>> though the underlying ADODB libraries support PostgreSQL, etc.
>>
>> bishop
>>
>
>
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketpla=
ce
> _______________________________________________
> phpESP-devel mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-devel
>
--=20
Bishop Bettini
ideacode, Inc.
(main) +1 919 341 5170 / (fax) +1 919 521 4100
Visit us on the web at:
ideacode.com Professional software research and development
reviewmysoftware.com Improve sales! Review your software before you release
bytejar.com Solutions to those annoying development problems
|
