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.
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.
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 ?
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.
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?
i have a little problem that i can't fix, in the Regional option of the Win2k server control panel i have set the Euro currency and the date format with dd/mm/yyyy but all the peoples that use a simple asp script like asp ASP date(), get the $ currency and the Usa date as mm/dd/yyyy, do you know where can i change this on the server?
I have a ASP shopping cart system and sell expensive products that can push the total purchase price over $1000. If the invoice total is more than $999.99... say $1010.00, it passes a value of $1.00 instead of $1010.00. Anything under $999.00 get processed just fine. Of course, Authorize.net say's it's my code and not their system. Is there a limit to FormatCurrency that would cause it to trim the value? I'm not quite sure where to begin looking but my "hidden x_amount" value thats passed along to the gateway is using FormatCurrency.
Code: <input type="HIDDEN" name="x_amount" value='<% = FormatCurrency(Request("GrandTotal"))%>'> Looking at it just know I noticed that the x_amount value is enclosed in ' ' instead of " "... could the comma in the currency value $1,010.00 be ending the code? It happened to some of my product drescriptions that had a comma. Changed it to " " and all was well.
im looking for some code that will convert an inputted amount in sterling to a number of different currencies.i presume i will have a text box and a series of radio buttons that a user will choose for another currency then a button to initiate the code to convert. Could it do the currency symbol also? ie £ > $
I have a problem with an ASP page pulling data from a SQL2000 server. Expected behaviour is that when prices are displayed they are displayed in pounds as this is the default locale of the server. However they are displayed in dollars.
I've checked the default locale and the user locale of the (windows 2000) server and these are both British english. The language for the SQL user is also British english. Are there any other setting that could affect this?
when I read a float number from my sql database and use format currency to to display it it always puts a question mark before it. why it does this? I've checked the value in the database. response.write on the value itself.
I want to show the currency like that xxx.00. In my database, i already set the type of column which i want to show to currency. However, the currency can no be shown as my expect. It only show like that XXX..
I am writing a script than connects to my database and pulls prices in pounds, does anyone know how I can get the current exchange rate so I can have a dual currency on my site. I would like to have prices in say pounds & euros.
Is there a site that my website can connect to, to retrieve the current daily exchange rate.
i am a web designer, and very new to programming. I have a project to create a website for a Bank and i have to include a currency converter in it. I just dont know how to make it.
However it shows the £ sign when I want it to be a Dollar, i know that it is because they are my computer settings, but how do I get it so that no matter what your computer settings are it always shows dollars. Code:
I am trying to store currency symbols in my ms-sql database using an ASP script. But it just wouldnt save them or even submit the form. Has anyone done this before?
My database value for the format field is 1250. I would like to format that value as $12.50. Below is my code. Can someone please help, I am not able to get this straight.
field spec: field name = prate field datatype = number decimal places = 0
<%response.write(formatcurrency(rs("prate"),2,-1)
I know my database setting and code is wrong, can someone please help.
Why am I only able to create 60 currency type fields in Access 2002 (Build 10.4302.6735) SP3? If I try to create more than 60 Currency type fields, I will get an error that says, "Too Many Fields Defined. Errors were encountered during the save operation. Data types were not changed." What if I need more currency type fields - like about 32 more? Do I need to create two separate related tables?
In my response.write line, I need to format a field to be a currency value. Is there a quick and dirty way to do it or is it an involved edit? Here is my code:
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.
Some colleague of mine noticed at some point that the document he let the website at server generate returned a document with Guilder as currency. Meanwhile another colleague retrieved a document as well using the same script and he received it correctly in Euro, the way it _always_ returns normally.It's an ASP website with an Access Database.
Can this be related to Access and the config of a colleague's PC eventhough the website AND Access run on the webserver?In my opinion it's a rather odd occurence what happened, but anyway... it worked before and at the end of the day (on which it went wrong for one colleague) it was "fixed" again. So it's an exceptional occurence.I'm just wondering if this "phenomenon" can be explained somehow?
I cannot get the FormatCurrency function to work properly on my site, which is hosted on a server 2k3 box w/iis installed.It works just fine on my local iis machine, however w/out a glitch.
Here are the two side by side:
LOCAL MACHINE IIS over WINXP, Access Db, datatype=NUMBER, Format=CURRENCY HOST SERVER IIS over 2k3, Access Db, datatype=NUMBER, Format=CURRENCY Error Message that appears on host server... INTERNAL SERVER ERROR, error 500 Datatype mismatch....
I am trying to store the currency symbol used for a trasaction in a database field but rather than store £ it stores £ (see the wierd character at the beginning of the symbol) instead.
The strange thing in even after storing this when I display the currency on one page it shoes it as £ but on two of the pages it still shows £ I have looked at the database the value stored is £ where as the user is only entering £ .
