Adding Different Fields

[Mangler]

Say I have to different recordsets that have the fields:
rsA.Fields.Item("A").Value ,rsB.Fields.Item("B").Value

How would I add those to fields? It may be my inexperience but when I
tried something like

rsA.Fields.Item("A").Value + rsB.Fields.Item("B").Value

didnt work because one of the fields was a empty value. I have about
6 fields i need to add together if a value exists in any of them.

Suggestions?

Respectfully,

Danny

 

[Mangler]

test them first :

If Not IsNull(fielda) and Not IsNull(fieldb) then ....

Tried this, maybe i am wrong here:

<% If Not IsNull(rsR.Fields.Item("price").Value) and Not
IsNull(rsRef.Fields.Item("price").Value) Then Response.Write
rsR.Fields.Item("price").Value + rsRef.Fields.Item("price").Value End
If %>

Keep getting a mismatch error...

 

[Bob Barrows [MVP]]

Say I have to different recordsets that have the fields:
rsA.Fields.Item("A").Value ,rsB.Fields.Item("B").Value

How would I add those to fields? It may be my inexperience but when I
tried something like

rsA.Fields.Item("A").Value + rsB.Fields.Item("B").Value

didnt work because one of the fields was a empty value. I have about
6 fields i need to add together if a value exists in any of them.

1. Modify the sql statements that produce the recordset to ensure the
fields do not contain Nulls. The details depend on the database you are
using. For example, SQL Server has the COALESCE function that can be
used to return either the value, or 0 if the value is Null.
2. Assign the values to variables (GPB*), check to see if they have
values and, if not, set them to 0 (zero) before adding them


*Good Programming Practice

 

[Dave Anderson]

Say I have to different recordsets that have the fields:
rsA.Fields.Item("A").Value ,rsB.Fields.Item("B").Value

How would I add those to fields? It may be my inexperience but when I
tried something like

rsA.Fields.Item("A").Value + rsB.Fields.Item("B").Value

didnt work because one of the fields was a empty value. I have about
6 fields i need to add together if a value exists in any of them.

Suggestions?

SQL ISNULL is a good choice to ensure you always have a value in your field:
http://msdn2.microsoft.com/en-us/library/aa933210(SQL.80).aspx

It is also worth pointing out that JScript conditional assignment makes this
quite trivial:

(rsA.Fields("A").Value || DEFAULT_VALUE) + ...

You have to set your default value according to type, of course. For
example:

rs.Fields("Quantity").Value || 0
rs.Fields("Address2").Value || ""
rs.Fields("Validated").Value || false

 

[Mangler]

rs.Fields("Quantity").Value || 0

I tried assigning the defult value like the above example and kept
getting an error saying invalid character. I did however get what I
need done to work. Just put some hidden fields with the recordset as
the value and called a javascript function to add the fields.