Logic Error

[J P Singh]

Hi There

I am developing a small Purchase Order application and have run into a small
issue

I have a two tables called PODetails and POHeader which has fields like

POHeader
==========
PONumber
DatePlaced etc etc

PODetails
=========
PONumber
UnitQuantity
UnitPrice

I want to display all POHeader records with the total order value

SQL = " SELECT Sum(PODetails.Amount) AS Expr1 FROM PODetails where PONumber=
" & rstDBEdit.Fields("PONumber").Value

Set RS = Server.CreateObject("ADODB.Recordset")
RS.Open SQL, CONN_STRING

if RS.EOF or RS.BOF then
else
strTt = FormatNumber( RS("Expr1") , 2)
end if
response.write "Total order value = " & RS("Expr1") & "<br>"

The above code generates an error whenever there is a purchase order which
has no records in the PODetail table.

I would like to display 0 whenever there are no rows for a particular
purchase order at present it gives me an error as the SQL above returns
nothing.

Can you please help

Thanks

Jas

[Steve G]

Try this:

if RS.EOF or RS.BOF then
response.write "Total order value = 0"
else
strTt = FormatNumber( RS("Expr1") , 2)
end if
response.write "Total order value = " & RS("Expr1") & "<br>"

Steve G

"J P Singh" <noemail@asIhatespam> wrote in message
news:uIWcfW42DHA.2528@TK2MSFTNGP09.phx.gbl...

> Hi There
>
> I am developing a small Purchase Order application and have run into a

small

> issue
>
> I have a two tables called PODetails and POHeader which has fields like
>
> POHeader
> ==========
> PONumber
> DatePlaced etc etc
>
> PODetails
> =========
> PONumber
> UnitQuantity
> UnitPrice
>
> I want to display all POHeader records with the total order value
>
> SQL = " SELECT Sum(PODetails.Amount) AS Expr1 FROM PODetails where

PONumber=

> " & rstDBEdit.Fields("PONumber").Value
>
> Set RS = Server.CreateObject("ADODB.Recordset")
> RS.Open SQL, CONN_STRING
>
> if RS.EOF or RS.BOF then
> else
> strTt = FormatNumber( RS("Expr1") , 2)
> end if
> response.write "Total order value = " & RS("Expr1") & "<br>"
>
> The above code generates an error whenever there is a purchase order which
> has no records in the PODetail table.
>
> I would like to display 0 whenever there are no rows for a particular
> purchase order at present it gives me an error as the SQL above returns
> nothing.
>
> Can you please help
>
> Thanks
>
> Jas
>
>