SELECT SecLink FROM Security WHERE SecLink=54 AND UserLink=;OUTPUT NIL
SELECT SecLink FROM Security WHERE SecLink=56 AND UserLink=;OUTPUT NIL
SELECT DISTINCT StartDate as PrevDate FROM PartyReg WHERE ParentContainer= AND StartDate < ORDER BY StartDate DESC LIMIT 1;OUTPUT NIL
SELECT DISTINCT StartDate as NextDate FROM PartyReg WHERE ParentContainer= AND StartDate > ORDER BY StartDate ASC LIMIT 1;OUTPUT NIL
SELECT PartyRegID TPRID FROM PartyReg WHERE ParentContainer= AND PartyReg.StartDate= AND PartyLink=;OUTPUT NIL
u
UPDATE PartyReg SET Amount=,F%d>,LMBy=,LastModified=Now() WHERE PartyRegID=;FINISH
i
INSERT INTO PartyReg (ParentContainer,StartDate,PartyLink,Amount,LMBy,LastModified) VALUES (,,,,F%d>,,Now());FINISH
SELECT PartyRegID OPRID FROM PartyReg WHERE ParentContainer= AND PartyLink= AND StartDate < ORDER BY StartDate DESC LIMIT 1;OUTPUT NIL
UPDATE PartyReg SET EndDate= WHERE PartyRegID=;OUTPUT NIL
SELECT StartDate NSTD FROM PartyReg WHERE ParentContainer= AND PartyLink= AND StartDate > ORDER BY StartDate LIMIT 1;OUTPUT NIL
UPDATE PartyReg SET EndDate= WHERE PartyRegID=;OUTPUT NIL
SELECT DISTINCT PartyID FROM PartyReg,Party,User WHERE ParentContainer= AND PartyReg.StartDate= AND PartyID=PartyReg.PartyLink AND UserID=PartyReg.LMBy ORDER BY Amount DESC;OUTPUT EachParty
=$in{NewPartyReg}>
Registration Saved.
SELECT StartDate FROM PartyReg WHERE LMBy= ORDER BY LastModified DESC LIMIT 1;OUTPUT NIL
SELECT * FROM PartyReg WHERE PartyRegID=;OUTPUT NIL
[Add New Party Registration]
|