sql update & $loop

basement_addict · Post by **basement_addict** » Thu May 23, 2002 7:57 pm

hi,
when i do an update statement and there is an error like "Update would generate non-unique row" even though the insert failed $loop still gets set to 1. i would expect $loop == affected rows. inserts seem to work fine ($loop=0)

here is a simple example which creates the table,index and sample data.

<A NAME=updateloop PUBLIC>
<sql "create table danstest(id counter,val varchar(5));"></sql>
<sql "create unique index idx_dantest on danstest(id,val)"></sql>
<$id=(counter)>
<sql "insert into danstest values($id,'dan');"></sql>
$loop 
<$id2=(counter)>
<sql "insert into danstest values($id2,'don');"></sql>
$loop 
<sql "insert into danstest values($id2,'mike');"></sql>
$loop 
<$loop=0> 
<sql "update danstest set val='don' where val='mike';"></sql>
$loop 
</A>

this is the output:




1 
1 
1 

1

Post by **mark** » Fri May 24, 2002 10:59 am

Update returns every row matching the condition, updated or not. You could check the returned value against what you're trying to change it to or capture putmsg and look for that message.