Member Avatar for gsc1ugs
gsc1ugs 0 Newbie Poster

Use this code

sql = "SELECT products.endDate FROM products INNER JOIN "
   sql = sql & "		auctionevents ON products.idsupplier = auctionevents.idSupplier "
   sql = sql & "	WHERE     (products.endDate > CURRENT_TIMESTAMP) AND (auctionevents.ID = "&id&")  AND (products.ListHidden <> 1)"

but if the server is not run the endDate goes past currenttimestamp and continues forward, anyone help please?

  • 1 Contributor
  • 0 Replies
  • 52 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.