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?
I am creating a little signup script and tus far i have run into problems with this line. This line inserts the users information that they entered from the form into the SQL database. Does anyone know what is wrong with this line?
myconn.execute("INSERT regfreeup set signup = '" & Now() & "' , firstname = '" & first & "' , lastname = '" & last & "' , email = '" & email & "' , ordernum = '" & order & "', username = '" & user & "' , pass = '" & pass & "' , site = '" & site & "';")
i need to know how signing up works, the kind where you will fill in a form and then receive your password and username by email.
How do you generate the password and username, if you cant help please refer me to another site that i can check on.
In some searches on our web site the items will come back with a different dollar sign than the US $ symbol why is that?
View Replies View RelatedI am concatenating the firstname and lastname in the SQL query in the ASP page. I get the error:
Syntax error near =
This query works in Access.
<input type=hidden value="<%=strNetworkID%>" name=""networkid">
"SELECT" EmpID, FirstName + ' ' + LastName as Employee_Name, NetworkID FROM Employee WHERE networkID = " & Request.form("networkid")
I am developing a simple ASP that requires a user, after verfiying a checklist, to be able to actually sign the form using a PDA pen (The device is a PDA). My problem is that I do not have idea as to how to do this. Is there any API or any other method (say canvas?) that I can incorporate into the ASP so that the user can sign?
View Replies View RelatedI'm linking from one page to another like so: page.asp?modelName=#1 Common Ash Wood.
On the next page I store that value in a variable so I can use it however I like. The problem is that if that # is there the value doesn't pass and is left blank. If I have something like 2.25 #2 Common Birch then only the 2.25 comes through.
I had a similar problem in the past with quotes and was told to use ASCII ” and that solved the problem. Now, though, I'm doing a search for ASCII values and I'm finding a lot...but none of them seem to match up and work.
All the tables I'm finding say to use " for quotes and then says to use # for the # sign. When I try that for #, it does indeed switch and display a # in Dreamweaver, but still leaves the value blank when trying to use it in my application.
Where did you guys get the ” from and why can't I find any charts that have that to use for quotes? Whatever chart that is, is probably the chart I need for #.
Hope I haven't confused you too much. Basically, I just need to know how to be able to use the # in a querystring without it blanking out everything after it.
I am using ("Microsoft.XMLHTTP") to grab content from a site and display it
on my site, the issue I have and have had for weeks now is that on the
original page the sign "£" exists and when I get it to my site it is
displayed as a "?".
If I find the ASC code for the ? and replace on that it still does not work
:-(((
I have tryed all the usual method of fixing this with no success...
anybody had this issue or know where I might start to look to fix it ???
Anyone know how I can delete files from an asp page using filesystem and joker sign
I know how to delete one singel file, but I want to delete more than one file, only by
knowing the end of the filename, is there a joker sign I can use like "%" og "*"
I have tried something like this:
varFilename = * & "thefilename.txt"
fs.DeleteFile (server.mappath("files emp"& varFilename))
I am looking to implement a single-sign on solution for my company's website which has many partner websites scattered around the globe.
I want the members to be inconvenienced as much as possible, so if they log into one website, they are logged into all of them. As each website exists on seperate web servers in different locations, this makes my options a little tricky.
Has anyone had any experiences of single-sign on? I only know a little of XML, but I understand that this kind of thing can be achieved using XML over SOAP.
point me to resources that will tell me more about enabling a web application to tegrate with windows security for single sign on
View Replies View RelatedI had successfully programed a running Update ASP Page. While troubleshooting the pages, I discovered a error when I input something with ' For example: (john) is okay, (john') will give me error message. How can I do so the applicant can input ' in the update page?
The following is SQL code in my update page: .....
I have a sign up form where a person is signing up for several events,names and signup info goes into an access database.
I need to have it cut off when the events get full and prevent futher signups. Different events have different capacities, so some events could close and others still be open for sign up.
I'm building a few web sites that will use distinct domain names but will reside on the same server, at the same IP address, in the same application space, and will share a database. They will each provide different content depending on the domain name, but will share some core functionality behind the scenes.
What I'd like to be able to do is have one site serve as the primary site. If a visitor comes to one of the secondary sites and wishes to perform a function that requires them to be logged in, I'd like them to be able to log in only once and then be able to visit any of the sites without having to login again. Does anyone know of a pure ASP script-based single sign-on system?
I have the following:
<%=rs1("Address")%>
which would show something like:
555 Home Rd
What can I add that will put a + sign where the spaces are so that it looks like:
555+Home+Rd
I want to make sign out option in my website as like yahoo and hotmail.
View Replies View Relatedi need when a user is logged in, his or her account is locked and no other ppl can login by using these account.
View Replies View RelatedHow can i prevent double sign in with same account?
View Replies View Relatedi wanted to do a sign up page using vbsript for new pple to register as member, but therr is also error: too few parameters, expected 2. Code:
View Replies View RelatedJust a thought, the code below checks to see that an email address submitted from a form check to see if that there is an @ sign and if the length of the email address is greater than 0.
If InStr(request.form("email"), "@") > 0 then
sSender = request.form("email")
Else
...
I can assume then that the code about makes the LEN function redundant?
If len(InStr(request.form("email"), "@") > 0) then
sSender = request.form("email")
Else
...
I am passing a sql string thru my querystring for the next page to
capture.
example: www.xxxxxxxx.com/index.asp?str=select * from table where name
like '%doe%'
Passing a basic string works fine. But, when I use the LIKE statement it
does not work. I know it's because of the % sign, so how do I translate
this thru, so that the following page picks up the percent sign?
is there anyway of separating a string by either a space or + sign,I have an sms.asp page that receives a string in this format below
http://acompany.co.uk/online/intern...text=19%2Bdavid
the last part text=I need to split into 2 parts I need to read the first part 19 and match that to the db and then deal with the name David,I have tried everything, is there anyway of doing this even if the string read text=19+david if there was a way of separating the two.
I have a web page which displays various data reports. One field displays £GBP. I would like to display the conversion to $ next to it, i.e.
Charge £100 ($172)
Is there anywhere I can link to for this info, or do I have to enter the exchange rate myself in a db field and do the calc in a script?
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?
View Replies View RelatedIs there an easy way to format a number into a currency display style eg:
$100,000.
I have this set in my Access database on the field but my asp produces:
100000
Is there perhaps a formatCurrency command or something like that in ASP?
i have a textbox where a user enters a number when he submits that page i want to show the number entered as currency:
say for example he entered 12
next page i want to show $12.00
i did this:
txtprice=Cast(txtprice AS MONEY)
but its throwing an error
any idea how to work this out
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.
i have a database where the price is in pounds for my products,
on my localhost it comes up in pounds, groovy
however, on my web server it comes up in dollars (not so groovy) how can i solve this problem ( preferably not by getting a new server ;-)
I want to format a number in one of me text boxes as a currency, I tried CCur but this didn;t work.
View Replies View Relatedim 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 £ > $
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.
View Replies View RelatedI 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..
View Replies View RelatedI 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.