Re: [Phpsqliteadmin-devel] edit row patch

[Yves G. <yg...@mi...>]

On Friday 05 November 2004 19:56, Steve Dibb wrote:
> Hey guys,

Hi Steve,

> I'm working on an edit row patch right now.  I've actually got it
> working, and I'll submit it once you can delete a row, too.

Thats great news!

> The only bad side effect that I noticed is that SQLite doesn't allow
> the LIMIT clause when using DELETE or UPDATE unlike MySQL.  Bummer. 
> So what happens is when you update a row there's no way to tell it to
> limit it to one instance.  The workaround I coded was to update the
> row where the old values match.  That'll work, but it will also
> update/delete if there's more than one row.  If you guys know a
> workaround to create a safety net, that'd be cool.  Of course, it's a
> rare occurence it'd be needed, but still.

well right now I don't know a real workaround for that... maybe we 
should disable row edit/delete in case a table has no primary key, or 
an other possibility would be to show an intermediary page that shows 
the user which rows are to be updated/deleted (in case more than 1 row 
would be affected)

> The other thing is that in order to access SQLite through the web on
> linux, the database AND it's directory need to be world writeable. 
> So I created a new directory named db and dumped phpsla.sqilte in
> there.

very good idea, thank you!

> What's the best way to submit patches anyway?

right now I'd say, send them to this list as an attachment. In case you 
want to contribute regurlarly, using cvs would be the best.

hope to hear from you soon,
Yves

> Steve
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by:
> Sybase ASE Linux Express Edition - download now for FREE
> LinuxWorld Reader's Choice Award Winner for best database on Linux.
> http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click
> _______________________________________________
> Phpsqliteadmin-devel mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpsqliteadmin-devel

-- 
Linux 2.6.8.1 #1 Sun Oct 31 11:27:19 CET 2004 i686
 11:04:26 up 57 min,  1 user,  load average: 2.13, 1.09, 1.22