|=-peep2ee-=| wrote:

> For any of those know about SQL and MS SQL Server I need your help... below
> is some code out of an ASP script I have:
>
> <%
> If Request("cmd") = "rec_history" then
> strSQL = "SELECT orders.ordID, orders.ordName, payprovider.payProvName,
> orders.ordAuthNumber, orders.ordDate, orders.ordEmail, Last(status.Status)
> AS Status, Last(orderStatus.statPublic) AS statPublic FROM orderStatus INNER
> JOIN ((orders INNER JOIN status ON orders.ordID = status.ordID) INNER JOIN
> payprovider ON orders.ordPayProvider = payprovider.payProvID) ON
> orderStatus.statID = status.Status GROUP BY orders.ordID, orders.ordName,
> payprovider.payProvName, orders.ordAuthNumber, orders.ordDate,
> orders.ordEmail HAVING (((orders.ordEmail)='" & Session("Email") & "'))
> ORDER BY orders.ordID DESC;"
> %>
>
> <%
> Else
> strSQL = "SELECT orders.ordID, orders.ordName, payprovider.payProvName,
> orders.ordAuthNumber, orders.ordDate, orders.ordEmail, Last(status.Status)
> AS Status, Last(orderStatus.statPublic) AS statPublic FROM orderStatus INNER
> JOIN ((orders INNER JOIN status ON orders.ordID = status.ordID) INNER JOIN
> payprovider ON orders.ordPayProvider = payprovider.payProvID) ON
> orderStatus.statID = status.Status GROUP BY orders.ordID, orders.ordName,
> payprovider.payProvName, orders.ordAuthNumber, orders.ordDate,
> orders.ordEmail HAVING ((ordDate>Date()-7) AND ((ordEmail)='" &
> Session("Email") & "')) ORDER BY orders.ordID DESC"
> %>
>
> Last, Date and other functions dont seem 2 work :-( Any help on this would
> be great!
>
>