Different Decimal Symbol

I have ASP code displaying currency datatype data from Access database. I have copies of this asp code and tha database on two w2k/IIS5 computers, bothg having the decimal symbol set to "." in the Regional setting both for numbers and for currency. However on one PC it shows dots, while on the other - commas. What is actually controlling which decimal shows up?

View Replies


ADVERTISEMENT

Regular Expression :: Eginning Symbol ^ Or The End Symbol $

would this work if i only wanted the user to enter any number of letters?[a-zA-Z]*

would i need to add the beginning symbol ^ or the end symbol $ ?

View Replies View Related

The ' Symbol..

I have a database query where it looks like this

strQuery = "UPDATE resource SET TITLE = ' "&request.form("TITLE")&" ' WHERE
ID = '"&request.form("ID")&"';"

the problem is that if the field called title has a ' in the text then the
UPDATE fails, because I have closed the TITLE field early. If I reverse the
" & ' marks then I will have the same problem but the opposite way
I thought about doing something with ASP, replace but I still cant get round
the fact that I will have a ' in the UPDATE statement
Can I do something like REPLACE ' with the CHAR code value and add the code
in the SQL record, and will this display the ' or the code.

View Replies View Related

<> Symbol ?

anyone know what does the symbol <> means?
Example: Remove_Id <> ""

View Replies View Related

Avoid Symbol ' In The URL

how to elaborate this problem that i m facing. ok, let say ..i have a URL wit id number such as www.abc.com/memberpage.asp?memberid=12.

when i add the symbol ' at the end of the url (like that:www.abc.com/memberpage.asp?memberid=12'), and enter, it will display error for my page.

But when i try to put a ' at this web page here, it will not display any error, how can i do this with ASP languagE?how can i avoid it using ASP language ?

View Replies View Related

Amp; Symbol In Code

I ran my page through the W3C markup validator, and all's well except one thing. If I have the "&" symbol in my URLs, it says: Quote:

Line 143, column 66: cannot generate system identifier for general entity "cat"
Line 143, column 69: reference not terminated by REFC delimiter
Line 143, column 69: reference to external entity in attribute value

I tried doing "&-amp;" (without the -) and "%26" but even though %26 works for the validator, my ASP script doesn't know it's an amp.

View Replies View Related

Currency Symbol

Wondering if anyone can help me with this annoying problem. I want to display a (£) on an ASP page, but it keeps putting a J instead. I've tried formatcurrency on the variable that it displays, but still comes up as a J and I've tried changing session.LCID to 2057. Still shows a J.

If you check View Source it shows the £ but it shows as a J on the page. If you check on IE under View... Encoding it comes up as Cyrillic (Windows) and if you change this to Western European (Windows) the page refreshes and shows fine; £ signs come up. But, as soon as you click on a link, it reverts back to Cyrillic.

View Replies View Related

Pass And & Symbol In A Query String

Is it possible to pass an -- & symbol --- in a query string.

ie: varialbe = Purple & Pink

page.asp?var=varialbe

-->> With this I get: Purple%20&%20Pink Passed through and the query string only picks up on the Purple.

View Replies View Related

' Symbol In Uploaded Filename - Not Working

I have a form which enters a URL into a file field in my database: E.G.

R:ConfidentialControlledWork.txt goes into field file_path_complete

However if the file name contains a ' character E.G.
r:confidentialjon's work.doc

Then it will not work correctly on my display page, as any text after
the ' will be ignored leaving it as r:confidentialjon

Here is how I create a link to this document on my display page ...

Response.write "<a href='"&rsNOTES("File Path Complete")&"'>"
Response.write (rsNOTES("File Name"))

With rsNotes(File Path Complete) being the full path and filename.

View Replies View Related

Decimal

if there is an easy way to convert hex to decimal with asp, the hex() function is there to get the decimal to hex, but i haven't been able to find a way to go back.

View Replies View Related

Decimal Value

I want to convert a number to percentage or decimal,is there any built-in function for this?

View Replies View Related

Decimal Value

i want to do the calculation like

value=int(basic) * int(excise) / 100

the both value come from the form. so when the data of excise field is like decimal 16.32 then i get the error data type mismatch.because the excise is 16.32 it is a decimal value. i have used CDbl(excise) but still it gives error.

View Replies View Related

Decimal Value

My ASP driven site has always used MySQL as the DB backbone, mainly as the hosting costs of MySQL are far cheaper than SQL Server at the mo, and it has worked fine until my ISP thought that they were doing everybody a favour by upgrading to v5 from v4.

What happens now is that any ASP query that I do that involves any of my MySQL Decimal data type fields goes belly up. It will not work. Looks to be an issue with ASP, MyODBC and MySQL, but I just wanted to check if there was a better/more reliable data type than Decimal (which obviously performs the same numerical functions) and if there was a quick way to convert all of my Decimal fields to this new type.

View Replies View Related

Decimal Value

Testing a ASP page using an Access db and I have a field in the DB defined as a 'number' with a precision of 3. Upon submitting the test data, I get this error message.


Microsoft JET Database Engineerror '80040e21'Scaling of decimal value resulted in data truncation. Can anyone tell me what's going on? The test value I used was "2.5".

View Replies View Related

Hex To Decimal

Is there a quick function to check if a passed value is a valid Hex Color? ie, if FD4323 was passed, it would return TRUE, and if FD94LR was returned it would return FALSE.

I'm finding conversion functions, but nothing that tests off hand.

View Replies View Related

Two Decimal Places

I have searched the forum and found the answer to my problem but unfortunitly it didn't tell me how to implement the solution!
The code I have thanks to previous forums:
Code:

<%=(rs("Seconds")/60=FormatNumber(2.5,2))%>

Basiclly I want to convert the seconds to minutes and round to two decimal places.

View Replies View Related

Decimal Conversion

Anyone have any code handy to convert a binary number to decimal and a decimal to binary? I need server-side code to perform these calculations. For example, I'd like to be able to pass 129 to a function and it will return 10000001. Likewise, I'd like to pass 10000001 to a function and get 129.
I can do this on paper, just not sure where to start on how to pass these numbers into a function to perform the calculation.

View Replies View Related

Decimal Problems

i have a script that calculates a value but when the value is for example 5.40 the textbox displays it as 5.4 because this is a money value it has to have the "0" at the end
how can i make the script so that it always has 2 decimals behind the comma or point. Code:

View Replies View Related

My Decimal Is Being Rounded Up By SQL

I have a form in an ASP page that the user enters a price for. When I send the parameter to my SQL stored Proc and refresh the data, it gets rounded up to the nearest integer. I can change the data just fine in SQL but not by using my asp page. Can anyone point me in the correct direction?

View Replies View Related

Decimal Numbers

i have the following equation:

<%
avg_score = total / count_match
%>

what can i do to restrict the result of avg_score to be of 2 decimal places?

View Replies View Related

Set Decimal Places

I need to truncate a number to two decimal places without rounding. All the functions i;ve tried tend to round up the numbers. Also i cant use any string functions to limit the size because the size can vary. example, 34.56998 must be set to 34.56 .

View Replies View Related

Is Decimal Number Between

How do I write? Code:

Dim johnson, jordan

decnum = Request.Form("decnum")
decnum = Cdbl(decnum)

If decnum is "a decimal number" between 4 AND 8 Then
jordan = 23.90
End If

View Replies View Related

How To Limit A Decimal

I have some calculations in my query string. Is it possible somehow to get a results of those calculations not in decimals but in integer in the query itself.

View Replies View Related

Decimal Validation

Trying to find a built in function or a neat custom for decimal validation, I assume there is no IsDecimal for ASP so somthing along the lines of the following function that wont round the number entered. Code:

Function validateInt (thisInt)
If IsNumeric(thisInt) Then
validateInt = Clng(thisInt)
Else
validateInt = 0
End If
End Function ...

View Replies View Related

Decimal Places

can anyone tell me the easiest way to make sure numbers get passed with 2
decimal places?

ie:
<select name="TagCost" id="TagCost">
<option value="25.00">1 @ 25.00</option>
<option value="50.00">2 @ 25.00</option>
</select>

fprice=request("TagCost") <------- need to make sure this is 25.00 not 25

View Replies View Related

Decimal Numeric Values

Normally to declare a value as numeric I use Clng() HOWEVER I now have some Numeric values with decimal places, which I need to tell the page when they are picked up from the form that they are in fact numeric, but retaining the decimal places too, which would I use... as all the ones I have used previously Cint, Clng, Fix, etc. do not retain the decimal places.

View Replies View Related

Convert Varchar To Decimal

I need to compare two values. one from a text field 'bid' and the other
from a field in an sql server database 'maxbid'.

The problem is the column in the database has decimal as its data type
and i'm getting a type mismatch. does anyone know how to convert 'bid'
into decimal from varchar? the field datatype doesnt necessarily have
to be decimal although i need two decimal places so it cant be an int.

View Replies View Related

Decimal Places For Currency

I am trying to display a currency field from an access db on an ASP
page. The only problem i found is that if there is a 0 (zero) after
the decimal i.e. 79.60 it is not displayed.

I tried doing the whole var = CCur(TBL("Price")) thing but there is no
zero.

View Replies View Related

Truncate Till Decimal

I have files names like bcd.jpg, 1234567.mpg etc in my DB. I need only the file names. I know the truncate method but it's no good here. How do I cut away the extension part?

View Replies View Related

Decimal 160 Character In Browser

I have a input string I display. In the string, I have a character that's a part of ASCII chart 2 which doesn't display correctly. It displays as a ?. I tried different encoding to no avail.

View Replies View Related

Remove Decimal From String

I currently have a variable that is pulled from a database for currency amount. Ex: 25.99 . I need to remove the decimal place so that the variable is like 2599 instead. How can I use ASP to remove this decimal place?

View Replies View Related

Knock Off Decimal Places

I have some code that divides a number and then prints this number. It performs a cost rollup basically and then adds a percentage. The code works fine except that the number returned has many figures afert the decimal point (as you would expect really) How can I remove these ? I am not really concerned about rounding up or down, just removing to give me a whole number.

View Replies View Related

Rounding Of Number To 2 Decimal

how do i round off a number to 2 decimal places? This code taken from www.w3schools.com only round the number to a whole number.

<html>
<body>

<script type="text/vbscript">
i = 48.66776677
j = 48.999
document.write(Round(i))
document.write("<br />")
document.write(Round(j))
</script>

</body>
</html>

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved