Emaze Auction: Edit Bid

No bid ID was defined.

You must check the checkbox to delete this bid.

DELETE FROM Bid WHERE bidID = #Form.bidID# SELECT lotBidCount, lotReservePrice, lotReservePriceMet, nextBidMinimum, lotBidIncrement FROM Lot WHERE lotID = #Form.lotID# UPDATE Lot SET lotBidCount = lotBidCount - 1 , lotBidsExist = 0, nextBidMinimum = lotOpeningBid, nextNextBidMinimum = lotOpeningBid + lotBidIncrement , lotReservePriceMet = 0 WHERE lotID = #Form.lotID# SELECT userID FROM Member WHERE username = '#Form.username#'

The user with username #Form.username# does not exist or is not unique.

UPDATE Bid SET bidPrice = #Form.bidPrice#, bidWin = 1, bidQuantity = #Form.bidQuantity#, bidQuantityWin = #Form.bidQuantity#, bidFullQuantityOnly = 1,0, bidDateTime = #bidDateTime#, bidAuto = 1,0, bidPriceMaximum = #Form.bidPriceMaximum#, bidPriceInitial = #Form.bidPriceInitial#, bidEditDateTime = #bidEditDateTime#, bidUpdateDateTime = #dateTimeNow#, userID = #getUser.userID# WHERE bidID = #Form.bidID# SELECT nextBidMinimum, nextNextBidMinimum, lotReservePriceMet, lotBidsExist FROM Lot WHERE lotID = #lotID#

Bid deleted.

Bid updated.

SELECT Member.email, Member.firstName, Member.lastName, Member.username, Bid.lotID, Bid.bidDateTime, Bid.bidPrice, Bid.bidQuantity, Bid.bidAuto, Bid.bidPriceMaximum, Bid.bidFullQuantityOnly, Bid.bidWin, Bid.bidUpdateDateTime, Bid.bidPriceInitial, Bid.bidQuantityWin, Bid.userID, Bid.bidEditDateTime, Lot.lotName, Lot.nextBidMinimum, Lot.nextNextBidMinimum, Lot.lotBidIncrement, Lot.lotQuantity, Lot.lotQuantityMaximum FROM (Bid INNER JOIN Lot ON Bid.lotID = Lot.lotID) INNER JOIN Member ON Bid.userID = Member.userID WHERE Bid.bidID = #bidID#

This was not a valid bidID. Either the bid, lot or user does not exist.

Edit Bid

Lot #getLot.lotID#. #getLot.lotName#

Bidder - #getLot.firstName# #getLot.lastName#
(#getLot.email#)

Quantity: #getLot.lotQuantity#

Max. Quantity: #getLot.lotQuantityMaximum#

Bid Increment: #LSCurrencyFormat(getLot.lotBidIncrement,"local")#

Minimum Winning Bid: #LSCurrencyFormat(getLot.nextBidMinimum,"local")#

Check and click to delete bid

Bid date/time: / / , : (MM/DD/YYYY : HH:MM AM/PM)

Bid edit date/time: / / , : (MM/DD/YYYY : HH:MM AM/PM)

Username:

Initial Bid:
$

Current Bid: $

Quantity: (maximum: #getLot.lotQuantity##getLot.lotQuantityMaximum#)

CHECKED> Check to accept full quantity only

CHECKED> Automatically increment bid to maintain winning bid status

Maximum Bid: $ (only if choosing auto-bid feature)

Quantity:	#getLot.lotQuantity#
Max. Quantity:	#getLot.lotQuantityMaximum#
Bid Increment:	#LSCurrencyFormat(getLot.lotBidIncrement,"local")#
Minimum Winning Bid:	#LSCurrencyFormat(getLot.nextBidMinimum,"local")#

Bid date/time:		/ / , : (MM/DD/YYYY : HH:MM AM/PM)
Bid edit date/time:		/ / , : (MM/DD/YYYY : HH:MM AM/PM)
Username:
Initial Bid:	$
Current Bid:	$
Quantity:		(maximum: #getLot.lotQuantity##getLot.lotQuantityMaximum#)
		CHECKED> Check to accept full quantity only
		CHECKED> Automatically increment bid to maintain winning bid status
Maximum Bid:	$	(only if choosing auto-bid feature)