Re: [Phpsqliteadmin-devel] edit row patch

[Felipe L. <wi...@ig...>]

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

Hi there! 

>> 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! 
> 

Indeed! 

>> 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) 
> 

IMO, we should lok for a primary key, if not found return error. 

>> 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! 

Good idea to organize things (including the other folders u created) 

> 
>> 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 
> 
>------------------------------------------------------- 
>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 
> 
>------- 

_________________________________________________________________________________
Quer mais velocidade?
Só com o acesso Aditivado iG, a velocidade que você quer na hora que você precisa.
Clique aqui: http://www.acessoaditivado.ig.com.br