A 1
B 2
C 3
D 4

Also nochmal... 3=>1

> > update tbl_tourenbilder set Reihung=1000 where 
> [EMAIL PROTECTED]

A 1
B 2
C 1000
D 4

> > update tbl_tourenbilder set Reihung=(Reihung-1) where [EMAIL PROTECTED] and
> Reihung>@Reihungalt

A 1
B 2
C 999
D 3

> > update tbl_tourenbilder set Reihung=(Reihung+1) where [EMAIL PROTECTED] and
> Reihung>[EMAIL PROTECTED]

A 2
B 3
C 1000
D 4

> > update tbl_tourenbilder set [EMAIL PROTECTED] where [EMAIL PROTECTED] and
> > [EMAIL PROTECTED]
> 
A 2
B 3
C 1
D 4


Geht auch....


Claudius

_______________________________________________
Database.asp Mailingliste, Postings senden an:
[EMAIL PROTECTED]
An-/Abmeldung und Suchfunktion unter:
http://www.glengamoi.com/mailman/listinfo/database.asp

Antwort per Email an