Emaze Auction: Private Lot
INSERT INTO PrivateLotUser (lotID, userID)
VALUES (#Form.lotID#, #privateCount#)
Users added to this private lot.
DELETE FROM PrivateLotUser
WHERE lotID = #Form.lotID#
AND (userID = #ListGetAt(Form.userID,1)#
OR userID = #privateCount#
)
Users removed from this private lot.
SELECT categoryID, lotName FROM Lot WHERE lotID = #lotID#
#lotID# - #getLotName.lotName#
(Return to category page)
Private Bidders
SELECT PrivateLotUser.userID, Member.username, Member.organization,
Member.firstName, Member.lastName
FROM PrivateLotUser INNER JOIN Member ON PrivateLotUser.userID = Member.userID
WHERE PrivateLotUser.lotID = #lotID#
No users currently have permission for this private lot.
Below is a list of users who currently have access to this private lot. To remove a user from the group, check the checkbox next to that user and click on the "Remove User" button below. You must check the checkbox below the button to verify your request.