Adding Different Fields

[Mangler]

Say I have to different recordsets that have the fields:
rsA.Fields.Item ("A").Value ,rsB.Fields.Ite m("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

[Jon Paal]

test them first :

If Not IsNull(fielda) and Not IsNull(fieldb) then ....
"Mangler" <dw******@aspde vil.comwrote in message news:11******** *************@p 10g2000cwp.goog legroups.com...

Say I have to different recordsets that have the fields:
rsA.Fields.Item ("A").Value ,rsB.Fields.Ite m("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]

On Jan 30, 11:49 am, "Jon Paal" <Jon nospam Paal @ everywhere dot com>
wrote:

test them first :

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

Tried this, maybe i am wrong here:

<% If Not IsNull(rsR.Fiel ds.Item("price" ).Value) and Not
IsNull(rsRef.Fi elds.Item("pric e").Value) Then Response.Write
rsR.Fields.Item ("price").Va lue + rsRef.Fields.It em("price").Val ue End
If %>

Keep getting a mismatch error...

[Bob Barrows [MVP]]

Mangler wrote:

Say I have to different recordsets that have the fields:
rsA.Fields.Item ("A").Value ,rsB.Fields.Ite m("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

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Jon Paal]

Type mismatch is a general error that happens when you try to stuff one type of value into a variable of another type.

Let's say you are working with numbers, adding and subtracting them. You're working with

LowVal
HighVal
NewVal

And then at some point you say something like

HighVal = "XYZZY"

your operations are soon going to fail with a type mismatch error.



The easiest way to figure out where you went wrong is to do a response.write of each value along the path. That way you can see
exactly what each value is set to, and figure out which one is getting in a "bad" value.
"Mangler" <dw******@aspde vil.comwrote in message news:11******** **************@ q2g2000cwa.goog legroups.com...

>

On Jan 30, 11:49 am, "Jon Paal" <Jon nospam Paal @ everywhere dot com>
wrote:

>test them first :

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

Tried this, maybe i am wrong here:

<% If Not IsNull(rsR.Fiel ds.Item("price" ).Value) and Not
IsNull(rsRef.Fi elds.Item("pric e").Value) Then Response.Write
rsR.Fields.Item ("price").Va lue + rsRef.Fields.It em("price").Val ue End
If %>

Keep getting a mismatch error...

[Dave Anderson]

Mangler wrote:

Say I have to different recordsets that have the fields:
rsA.Fields.Item ("A").Value ,rsB.Fields.Ite m("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/lib...0(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("Quan tity").Value || 0
rs.Fields("Addr ess2").Value || ""
rs.Fields("Vali dated").Value || false

--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms.

[Mangler]

On Jan 30, 12:44 pm, "Dave Anderson" <NYRUMTPEL...@s pammotel.com>
wrote:

rs.Fields("Quan tity").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.