[Database.asp] =?iso-8859-1?Q?AW:_=5BDatabase.asp=5D_RE:_=5BDatabase.asp=5D_Reihenfolge_?= =?iso-8859-1?Q?=E4ndern?=

[Reinhold Becker]

SO:

CREATE PROCEDURE GP_Bilderreihung2 @Tour as int, @Nummer as int, @Reihung as
int as

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

Klappt mal soweit. Mu� es nur noch intensiver Testen.

Danke,
Reinhold


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