Emaze Auction: View Bids SELECT email, firstName, lastName, username FROM Member WHERE userID = #userID#

#getUser.lastName#, #getUser.firstName# (#getUser.username#)

SELECT Bid.bidDateTime, Bid.bidPrice, Bid.bidQuantity, Bid.bidAuto, Bid.bidPriceMaximum, Bid.bidFullQuantityOnly, Bid.bidWin, Bid.bidID, Bid.bidPriceInitial, Bid.bidQuantityWin, Lot.lotName, Bid.bidUpdateDateTime, Lot.lotStatus, Lot.lotOpenDateTime, Lot.lotCloseDateTime, Lot.lotReservePriceMet, Lot.lotID FROM Bid INNER JOIN Lot ON Bid.lotID = Lot.lotID WHERE Bid.userID = #userID# ORDER BY #order# Bids (total: #getBids.RecordCount#)

There are no bids for this user.

Edit Bid	Lot ID / Name	Opens / Closes	Bid Date/time	Update Date/time	Current Bid	Quantity	Win?	Initial Bid	Maximum Bid
	/	/
#bidID#	#lotID# - #lotName#	#LSDateFormat(lotOpenDateTime, "mm-dd-yy")# #LSTimeFormat(lotOpenDateTime)# #LSDateFormat(lotCloseDateTime, "mm-dd-yy")# #LSTimeFormat(lotCloseDateTime)#	#LSDateFormat(lotOpenDateTime, "mm-dd-yy")# #LSTimeFormat(lotOpenDateTime)# #LSDateFormat(lotCloseDateTime, "mm-dd-yy")# #LSTimeFormat(lotCloseDateTime)#	#LSDateFormat(bidDateTime, "mm-dd-yy")# #LSTimeFormat(bidDateTime)#	#LSDateFormat(bidUpdateDateTime, "mm-dd-yy")# #LSTimeFormat(bidUpdateDateTime)#	#LSCurrencyFormat(bidPrice,"local")#	#bidQuantity# (full)	#bidQuantityWin#	0	#LSCurrencyFormat(bidPriceInitial,"local")#	#LSCurrencyFormat(bidPriceMaximum,"local")#	-	-

Bid Totals
Summary of all bids Winning Bids Summary - Open Lots

Current Bid * Quantity: #LSCurrencyFormat(bidPriceTotal,"local")# Current Bid * Quantity Won: #LSCurrencyFormat(bidPriceWinOpenTotal,"local")#

Initial Bid * Quantity: #LSCurrencyFormat(bidPriceInitialTotal,"local")# Initial Bid * Quantity Won: #LSCurrencyFormat(bidPriceInitialWinOpenTotal,"local")#

Maximum Bid * Quantity: #LSCurrencyFormat(bidPriceMaximumTotal,"local")# Maximum Bid * Quantity Won: #LSCurrencyFormat(bidPriceMaximumWinOpenTotal,"local")#

Winning Bid Summary Winning Bids Summary - Closed Lots

Current Bid * Quantity Won: #LSCurrencyFormat(bidPriceWinTotal,"local")# Current Bid * Quantity Won: #LSCurrencyFormat(bidPriceWinClosedTotal,"local")#

Initial Bid * Quantity Won: #LSCurrencyFormat(bidPriceInitialWinTotal,"local")# Initial Bid * Quantity Won: #LSCurrencyFormat(bidPriceInitialWinClosedTotal,"local")#

Maximum Bid * Quantity Won: #LSCurrencyFormat(bidPriceMaximumWinTotal,"local")# Maximum Bid * Quantity Won: #LSCurrencyFormat(bidPriceMaximumWinClosedTotal,"local")#

Bid Totals
Summary of all bids		Winning Bids Summary - Open Lots
Current Bid * Quantity:	#LSCurrencyFormat(bidPriceTotal,"local")#	Current Bid * Quantity Won:	#LSCurrencyFormat(bidPriceWinOpenTotal,"local")#
Initial Bid * Quantity:	#LSCurrencyFormat(bidPriceInitialTotal,"local")#	Initial Bid * Quantity Won:	#LSCurrencyFormat(bidPriceInitialWinOpenTotal,"local")#
Maximum Bid * Quantity:	#LSCurrencyFormat(bidPriceMaximumTotal,"local")#	Maximum Bid * Quantity Won:	#LSCurrencyFormat(bidPriceMaximumWinOpenTotal,"local")#
Winning Bid Summary		Winning Bids Summary - Closed Lots
Current Bid * Quantity Won:	#LSCurrencyFormat(bidPriceWinTotal,"local")#	Current Bid * Quantity Won:	#LSCurrencyFormat(bidPriceWinClosedTotal,"local")#
Initial Bid * Quantity Won:	#LSCurrencyFormat(bidPriceInitialWinTotal,"local")#	Initial Bid * Quantity Won:	#LSCurrencyFormat(bidPriceInitialWinClosedTotal,"local")#
Maximum Bid * Quantity Won:	#LSCurrencyFormat(bidPriceMaximumWinTotal,"local")#	Maximum Bid * Quantity Won:	#LSCurrencyFormat(bidPriceMaximumWinClosedTotal,"local")#