multiply two ASP values together

crmpicco · January 27th, 2005, 08:35 AM

how do i multiply two ASP values together.

Value 1: rs4("count(trip_id)")
Value 2: rs5("no_of_pass")

Thanks.

Picco

crmpicco · January 27th, 2005, 08:36 AM

this doesnt work...

segments = rs4("count(trip_id)")*rs5("no_of_pass")
response.write "Segments = " & segments & "<br>"

jacob · January 27th, 2005, 08:41 AM

Convert them to numbers first, would be my guess.

Jacob.

crmpicco · January 27th, 2005, 08:41 AM

the value of rs4("count(trip_id)") is 1
the value of rs5("no_of_pass") is 1

what do i do?

crmpicco · January 27th, 2005, 08:45 AM

i now have the rs4 and rs5 into variables:

segments = ("count_trip_id")*("number_of_passengers")
response.write "Segments = " & segments & "<br>"

still not working.....

crmpicco · January 27th, 2005, 08:53 AM

the fix:

segments = cdbl(count_trip_id)*cdbl(number_of_passengers)