Hi

I am using the following code to try and convert the result of a split to an integer in order to add the values together to give a running balance.

The split code

details=Request.Cookies("cart_contents")
Response.Write("details:<br>"&details&"<p>")
detail_split=Split(details,"<br>")

detail_count=Ubound(detail_split)
Response.Write("detail_count="&detail_count&"<br>" )
detail_lbound=Lbound(detail_split)
Response.Write("detail_lbound="&detail_lbound&"<br >")

FOR count=1 TO detail_count-1
product_name=Split(detail_split(count),"£")
product_tmp=product_name(1)
product_pricetmp=Split(product_tmp,"Q")
product_price=product_pricetmp(0)
product_qty=product_pricetmp(1)

Response.Write("<p>count="&count&"<br>")
Response.Write("product_name="&product_name(0)&"<b r>")
Response.Write("product_tmp="&product_tmp&"<br>")
Response.Write("product_pricetmp="&product_pricetm p(0)&"<br>")
Response.Write("product_price="&product_price&"<br >")
Response.Write("product_qty=QTY&nbsp;"&product_qty &"<p>")

The for the display

Response.Write(product_price&"<br>")
price=product_price
IF IsNumeric(price) THEN
price_temp=CInt(price)
Response.Write("price_temp"&price_temp&"<br>")
ELSE
Response.Write("xnumeric<br>")
END IF
IF IsNumeric(product_qty) THEN
price_qty=CInt(product_qty)
Response.Write("price_qty"&price_qty&"<br>")
ELSE
Response.Write("xnumeric")
END IF
price=price_tmp*price_qty
Response.Write("£"&price&"<br>")

The output shown that price is a non numeric value and as a result will not convert it to an integer but there is no problem with price_qty.

The values returned are

count=1
product_name=(L200-030 HFEF) 3.00 kW 7.80 AMP 3ph
product_tmp=484 Q1
product_pricetmp=484
product_price=484
product_qty=QTY 1



This has been driving me nuts.

Thanks in advance

Alun

cint(string_value)

and of course there is;

Clng() for Long Integer type
CDbl() for Double type
cCur() for Currency type


http://www.w3schools.com/vbscript/vb...asp#conversion

IF IsNumeric(price) THEN
I've tried that here

price=product_price
price_temp=CInt(price)
Response.Write("price_temp"&price_temp&"<br>")
ELSE
Response.Write("xnumeric<br>")
END IF

but it tells me that price_temp isn't a numeric value the value is derived from tis line further up the code

product_pricetmp=Split(product_tmp,"Q")
product_price=product_pricetmp(0)


Cheers Al

I'd guess you have some spaces in the array value. use trim() to remove them.

What I don't see the reason for is having "<br>"s in the cookie.

I've precompiled functions for this specific purpose:

http://www.walkonmypath.com/integer-...version-in-asp

If you don't have a numeric value, either function will output 0. If you do, it will be converted to a number.

I have placed the function at the start of the file.

And then called it in the following

Response.Write("p_p="&product_price&"<br>")
price=IntConverter(product_price)
response.Write("p="&price&"<br>")


The results are

p_p=115
p=0

So it still doesn't appear to be picking up the price variable as a numerical field.

Alun

115 & 0 look like numerics to me

what exactly are you trying to do???

because I suspect the answer will be

response.write FormatCurrency(price)

Iam in the process of building a shopping cart using a flat file database - hence the reason for the <br> in the cookie - on the request of a customer.

The integration of the database into the pages for product selection has worked OK as has adding the item to the cart with the exception of the product_price has decided it is not going to be a numeric.

I want to split the string into product_code product_price and product_qty

I then wan't to multiply product_price by product_qty and display the result in the price column on the output.

I also want to have a running balance column next to this that will take the price of the second item in the list and add it it to the first and so on add the user adds items.

Al

take a look at http://www.lowestoft-business.co.uk/projects/scs

(and before you ask i'm re-writing someone elses Frontpage code!!)

No, it's definitely not picking up the price variable as a numeric field.

The question I have is twofold: 1) why a flat-file database and 2) why not an Access database? The server supports ASP, so it should support Access; the only reason it wouldn't is if it's an NT server.

Also, if that function returns a 0 when a non-0 numeric value is passed to it, it's usually a sign that your server needs to be restarted since it can't pick up numeric values.

Personally I would use an access database - but the customer would not know where to start when editing etc - the general idea is I set it up and they maintain - and also don't want the expenditure af me writing a backend for them.

And seeing as they are paying the bill......

I guess that means you can't build forms for them, eh? Ah well. Such is life.