#categoryName#
#systemURL#/category.cfm?categoryID=#categoryID#
SELECT lotID, lotName, lotOpenDateTime, lotCloseQueue, lotBidsExist, lotNoBidsStayOpenTimes,
lotReservePrice, lotReservePriceMet, lotReserveStayOpenTimes
FROM Lot
WHERE categoryID = #categoryID# AND lotType = 1
ORDER BY lotID
| Summary of Lot Status |
| Lot Status |
# |
Lot ID(s) |
|---|
| There are no lots in this category. |
| Inactive: |
#ListLen(statusInactive)# |
#ListGetAt(statusInactive,loopCount)#,
#ListLast(statusInactive)# |
0 | (none) |
| Preview: |
#ListLen(statusPreview)# |
#ListGetAt(statusPreview,loopCount)#,
#ListLast(statusPreview)# |
0 | (none) |
| Open: |
#ListLen(statusOpen)# |
#ListGetAt(statusOpen,loopCount)#,
#ListLast(statusOpen)# |
0 | (none) |
| Closing: |
#ListLen(statusClosing)# |
#ListGetAt(statusClosing,loopCount)#,
#ListLast(statusClosing)# |
0 | (none) |
| Closed: |
#ListLen(statusClosed)# |
#ListGetAt(statusClosed,loopCount)#,
#ListLast(statusClosed)# |
0 | (none) |
| Summary of Lot Reserve Price |
| Lot Status |
# |
Lot ID(s) |
|---|
| No lots have reserve prices. No lots have been extended for not having reached the reserve price. |
| Met: |
#ListLen(reserveMet)# |
#ListGetAt(reserveMet,loopCount)#,
#ListLast(reserveMet)# |
| Not Met: |
#ListLen(reserveNotMet)# |
#ListGetAt(reserveNotMet,loopCount)#,
#ListLast(reserveNotMet)# |
| Extended 1: |
#ListLen(reserveStayOpen1)# |
#ListGetAt(reserveStayOpen1,loopCount)#,
#ListLast(reserveStayOpen1)# |
| Extended 2: |
#ListLen(reserveStayOpen2)# |
#ListGetAt(reserveStayOpen2,loopCount)#,
#ListLast(reserveStayOpen2)# |
| Extended 3: |
#ListLen(reserveStayOpen3)# |
#ListGetAt(reserveStayOpen3,loopCount)#,
#ListLast(reserveStayOpen3)# |
| Extended 4+: |
#ListLen(reserveStayOpen4plus)# |
#ListGetAt(reserveStayOpen4plus,loopCount)#,
#ListLast(reserveStayOpen4plus)# |
| Summary of Lot Bids |
| Lot Status |
# |
Lot ID(s) |
|---|
| All lots have at least one bid. No lots have been extended for having no bids. |
| No Bids: |
#ListLen(noBids)# |
#ListGetAt(noBids,loopCount)#,
#ListLast(noBids)# |
| Extended 1: |
#ListLen(noBidsStayOpen1)# |
#ListGetAt(noBidsStayOpen1,loopCount)#,
#ListLast(noBidsStayOpen1)# |
| Extended 2: |
#ListLen(noBidsStayOpen2)# |
#ListGetAt(noBidsStayOpen2,loopCount)#,
#ListLast(noBidsStayOpen2)# |
| Extended 3: |
#ListLen(noBidsStayOpen3)# |
#ListGetAt(noBidsStayOpen3,loopCount)#,
#ListLast(noBidsStayOpen3)# |
| Extended 4+: |
#ListLen(noBidsStayOpen4plus)# |
#ListGetAt(noBidsStayOpen4plus,loopCount)#,
#ListLast(noBidsStayOpen4plus)# |