Can not divide in ASP!

[Rick H]

This is driving me up the wall! I have been trying to get this ever so 'simple' code to work for the last hour!

All I want to do is divide a number by 2

this is what I have

<%
...
if rstFound.bof = false then found_rows = rstFound.Fields("foundrows").value
rstFound.Close
 
page_count = found_rows / 2
 
%>Found <%=page_count%>

this does not work!! found_rows is 44 so page count should be 22. If I remove the /2 it works fine, else I get a 500 error.

I've also tried * 0.5 and this does not work either
Help!

[si_the_geek]

Do you set a default value for found_rows?

Presumably you want to set it to 0 before the If.

[Rick H]

Yup, the default for found_rows is zero.

What is interesting is this works:

if rstFound.bof = false then found_rows = rstFound.Fields("foundrows").value
rstFound.Close
 
found_rows=44
page_count = found_rows / 2
 
%>Found <%=page_count%>

and prints Found 22 on the page

however this

if rstFound.bof = false then found_rows = rstFound.Fields("foundrows").value
rstFound.Close
 
page_count = found_rows 
 
%>Found <%=page_count%>

prints Found 44 inidicating that found_rows is 44? but does not work with the divide by 2, but if I manually set it to 44 (top example) then this works????

[Rick H]

Fixed it! What a load of rubbish, only took me two hours

<%
...
if rstFound.bof = false then found_rows = cint(rstFound.Fields("foundrows").value)
rstFound.Close
 
page_count = found_rows / 2
 
%>Found <%=page_count%>

cint was the secret - god knows why

[si_the_geek]

Presumably because the field foundrows is a String (or Text/Char) data type, rather than a numeric type.


As you have the answer, could you please do us a little favour, and mark this thread as Resolved?
(this saves time reading for those of us who like to answer questions, and also helps those who search to find answers)

You can do this by clicking on "Thread tools" just above the first post in this thread, then "Mark thread resolved".

[Rick H]

Thats what I thought - originally I was trying to use Val() but this is not supported in ASP.

However Cint does not do string to integer conversions, it converts a numeric expression to an integer.

(see http://psacake.com/web/functions.asp?id=5)

[si_the_geek]

However Cint does not do string to integer conversions, it converts a numeric expression to an integer.

A string is a type of expression. A string such as "234" is a numeric one

The following is perfectly valid in VB, and according to Microsoft should be exactly the same for VBScript (which is what ASP uses):

my_var = CInt("234")

Have you checked what data type the "foundrows" field is?

[l12ngo]

If you're ever unsure about what type of variable you're pulling back from things then you can try using typename to help you out, so:

msgbox Typename(found_rows)

in this case.

[Rick H]

I'm not sure of the type as its returned by

Set rstFound = objConn.Execute("SELECT FOUND_ROWS() as foundrows")

after doing a "SELECT SQL_CALC_FOUND_ROWS ...." MYSQL query

[Rick H]

Thanks l12ngo, I'll try that