Insert Pound (like L) symbol to access database

[shanuragu]

Hi

Thanks for all ur help.
Here I have one more problem.
How to insert Pound symbol (like L a dash in the center) in to access data base so that I can display it when that table is populated. Please help It is urgent.

ShRa

[Ribeyed]

hi,
you could set your access field to currency then just instert the value and the pound sign will be there. When displaying in page pull the value out then add the pound sign before the value.

[shanuragu]

Thanks

The problem is not yet solved compeltely!!
User has to enter the pound symbol in the web page which is a seperate field in the db table. I have temporerly found a solution by make that symbol as default & displaying it on the web page using £ & fetch the value using request.form & insert it in to the db table. But some how I feel it not a feasible solution.

Any other suggestions!!!

Regards
ShaRa
:(

[bloke]

Are you collecting information on different currencies, eg £, $ etc? If so you could just add a numeric value to your database plus a bit field to indicate pound or dollar then assign the correct symbol to it using a function, eg:

<%
Function dollarpoundeuro(valIn)
If valIn = 0 Then
dollarpoundeuro = "£"
ElseIf valIn 1 Then
dollarpoundeuro = "$"
Else
dollarpoundeuro = "€"
End If
End Function


response.write dollarpoundeuro(bitvaluefromtbl) & numericvaluefromtbl
%>

Is this what you're after or am I completely wrong?!

[cmelnick]

You could just use the html character code for pound which is &amp;pound; or &amp;#163;

This would allow it to be stored just fine in your DB, and would also be displayed on your webpage as the £ symbol. If you need £ as the value from a text field input, you could simply replace £ with &amp;pound; before you submit it into your DB.


<%

valueString = "£ 100.00"
Response.Write "Storing " & valueString

valueString = Replace(valueString, "£", "&amp;pound;")

' The new valueString will be "&amp;pound; 100.00"
%>


See http://www.aardwulf.com/tutor/poundtest.asp for a working example.