adding numbers from mysql database 1

[walkerdigest]

Hi,

I am trying to add numbers from mysql database but it is not working.

in mysql database field is decimal(5,2) . when I display in asp file numbers it shows with comma not point , and it doesn't add numbers gives error. what should I do?

the code is as below:

sql2= "select * from hakemnot where hakem_id =" & hakid(k) & " and mt_baslama_yil=" & year(date)
set rs2=bag.execute(sql2)

toplamnot(k)=0

top(k)=0
toplamnot(k)=toplamnot(k)+ rs2("hakemnot") <----- gives error

 

[xwb]

It depends on your locale. Sounds like it is a European locale. Try changing the locale to US or UK.

 

[walkerdigest]

how can I change my locale?

 

[xwb]

Control Panel/Regional and Language Options. Change the format to either English(United Kingdom) or English(United States)

 

[walkerdigest]

we have changed the decimal place separator to period in regional and language option in server and reboot it but nothing changed.

asp still uses comma instead of period for decimal separator.

what should I do?

 

[ChrisHirst]

Use

session.lcid = 2057

for UK formatting.

LCID list


Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum

 

[walkerdigest]

Thank you.
session.lcid = 2057
worked. it gives decimals with period but still I can't add the numbers

sql2= "select * from hakemnot where hakem_id =" & hakid(k) & " and mt_baslama_yil=" & year(date)
set rs2=bag.execute(sql2)

toplamnot(k)=0

toplamnot(k)= toplamnot(k) + rs2("hakemnot")<-- gives type mismatch error

(k is defined before in a for loop)

 

[xwb]

Could it be possible that there are no records?

Another alternative could be that rs2("hakemnot") returns a string. Try

 toplamnot(k)= toplamnot(k) + cdbl(rs2("hakemnot"))

 

[Kendel]

You need to check the data type of the 2 variable to see if they are the same, using VarType(rs2("hakemnot")) If the value is 8 then it is a string, you need to convert it.

Here is the link to check the data type of a variable:

http://www.w3schools.com/vbScript/func_vartype.asp