Re: [phpesp-dev] true or false: phpESP *requires* MySQL?

[Bishop B. <ph...@id...>]

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