Emaze Auction: Lot Menu SELECT userID, firstName, lastName, email FROM Member WHERE username = '#Form.username#'

No users exist with the username #Form.usernam#.

 SELECT lotID FROM Lot WHERE userID = #getSeller.userID#

The user with username #Form.username# does not have any lots.

 Seller: #Form.username#
#getSeller.firstName# #getSeller.lastName# (#getSeller.email#)

Lot Menu

SELECT Lot.categoryID, Lot.lotID, Lot.lotName, Lot.lotOpenDateTime, Lot.lotCloseDateTime, Lot.lotCloseInactivity, Lot.lotPublic, Lot.lotStatus, Lot.lotCloseQueue, Lot.lotBidCount, Lot.lotNoBidsStayOpenTimes, Lot.lotReservePrice, Lot.lotReservePriceMet, Lot.lotReserveStayOpenTimes, Lot.lotViewCount, Lot.lotQuantity, Lot.lotQuantityTaken, Lot.nextBidMinimum, Lot.lotBidIncrement, Lot.lotOpeningBid, Category.categoryName, Lot.lotName, Lot.lotType FROM Lot INNER JOIN Category ON Lot.categoryID = Category.categoryID WHERE Lot.lotID IN (#lotID#)

There is no lot with lotID #lotID#.
ID  Lot Name
#lotID#. #lotName#

#lotID#. #lotName#
#systemURL#/lot.cfm?lotID=#lotID#
 View   Edit    Private Private   Copy    BidsBids   Winners  Offline BidOffline BuyOffline Bid
Status: #lotStatus# (Preview)  Email Winners 
Open: #LSDateFormat("#lotOpenDateTime#", "mm-dd-yyyy")# / #LSTimeFormat("#lotOpenDateTime#")#  Email Losers 
Close: #LSDateFormat("#lotCloseDateTime#", "mm-dd-yyyy")# / #LSTimeFormat("#lotCloseDateTime#")# Archive
Winning Bid: #LSCurrencyFormat(nextBidMinimum - lotBidIncrement,"local")# #LSCurrencyFormat(lotOpeningBid,"local")# (no bids) Delete
Viewed: #lotViewCount# Bids: #lotBidCount# (#lotNoBidsStayOpenTimes#)
## Taken: #lotQuantityTaken#0 / #lotQuantity# Reserve: #LSCurrencyFormat(lotReservePrice,"local")# (not met)#LSCurrencyFormat(lotReservePrice,"local")# (met)(N/A) (#lotReserveStayOpenTimes#)
Category: #categoryName#