#categoryName#
#systemURL#/category.cfm?categoryID=#categoryID#
SELECT lotID, lotName, lotOpenDateTime, lotCloseDateTime, lotCloseInactivity,
lotPublic, lotStatus, lotCloseQueue, lotBidsExist, lotNoBidsStayOpenTimes,
lotReservePrice, lotReservePriceMet, lotReserveStayOpenTimes, lotViewCount,
lotQuantity, lotQuantityTaken, lotContactName, lotContactEmail, userID, lotType
FROM Lot
WHERE categoryID = #categoryID#
AND lotType = #lotType#
ORDER BY #order#
Order by:
name (+)
name (-)
open time (+)
open time (-)
close time (+)
close time (-)
time created (+)
time created (-)
last edited (+)
last edited (-)
lot views (+)
lot views (-)
|
Name |
Opens |
Closes |
Created (ID) |
Last edited |
Lot Views |
Seller |
 |
 |
 |
 |
 |
 |
 |
- #lotID#. #lotName#
Seller: #lotContactName# (#lotContactEmail#)
#systemURL#/lot.cfm?lotID=#lotID#
| View |
Edit |
PrivatePrivate |
Copy |
BidsBids |
BuyersWinners |
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
|
| Viewed: | #lotViewCount# |
Bids: |
yesno
(#lotNoBidsStayOpenTimes#) |
Delete |
| ## Taken: |
#lotQuantityTaken#0 / #lotQuantity# |
Reserve: |
not metmetN/A
(#lotReserveStayOpenTimes#) |