How do I show a double with 2 decimal places in vbscript? Also is there a way to show a string that is holding a number with two decimal places or does it need to be converted to doulbe first and then converted back to string after manipulating the double?
View RepliesI'm as the topic notes, having some problems with recieveing decimal values from my database(MySQL). I'm pretty sure its a simple misstake, but since im pretty new to asp-syntaxes, I dont get it.
What I have is a table with a float(30,30) (yes, 30 decimals, its an experiment so I wanto "be safe"). I can take a variable, fill it with a jibberish numeric value say 1.111111111111 and write it in, works like a charm if I check the database manualy, however, I cant get it out!
Whenever I read from that database and into a value, I only get the first 5 decimals and the rest is left out, even if I display the database-value directly I cant get it to work!
If I do response.write MyResult("value") it still displays 1.11111 even if the actual value in the database is 1.1111111111->etc.
What could be wrong here?
If I do a little .....
I created a "calculator" but it spits the results with too many decimals.Is there any way to write only the first two decimals as suppoused of all the ones the operation creates?
View Replies View RelatedRight now I round my number to 2 decimal places... and since I am dealing with money values I need to show $100.70...but my calculations show $100.7. Is there a way to fix this? How can I tack on a "0" if it only shows 1 decimal place?
View Replies View RelatedI have almost completed a small japanese shopping cart in asp. The shopping cart was freecode in english and I converted it to japanese. The problem is japanese Yen does not use decimals and the prices are displaying decimals.
The cart uses a access db, I went into the db and specified the price to have no decimals but the decimals are still being displayed . Is there a easy way to get rid of the decimals Code:
I am programming a page that displays scientific data retrieved from a
data source to an asp-web page and i would like to force all number to
be formatted/displayed in scientific notation no matter what the value
is. (i.e. x = 123 would be displayed as x = 1.23e+02). The standard
function "formatnumeric(x[,n])" does not seem to be able to do this for
me or at least I don't know how to use it that way.
I am a C#-Coder and now I have the duty to rewrite a ASP-Website and add some functionality. The problem is that I have never seen ASP before and I don't have the time to learn everything necessary to complete my work.
It's a very simple problem and would be really great if someone could tell me what to do or show me a small code-example. I think "learning by reading code" is the best way to get new information
I have an ASP-Website with a very long list (out of a SQL-Query). If I scroll down the page I can't see the list-header any more <- THATs my problem. What I need is an ASP-Website with a fixed section that can't be moved and below a common, scrollable website.
The header of my SQL-Query should be in this fixed section and the datasets should be in the scrollable section.
I have variable, say "total". It can be an integer or floating number.
No matter what value it stores (5 or 5.1 or 5.24), when I display it, is
there a way I can make it display it with fixed 2 decimal digits, like 5.00?
I posted a similar problem a while ago but never found a solution. I am passing an integer value (called NoElements)from a html form (which gets created using javascript) to an asp page. The value of NoElements is used to create an asp array of that size. At first I was confronted with the following error:
Expected integer constant
I then was advised to initialise the array (to say 100) and then do a ReDim Preserve. I now get this error message:
This array is fixed or temporarily locked? What should (or at least I thought) be a simple porcedure is making my life a nightmare.
i'm getting an instance of a form field value being cut off when input into a MS SQL db. i can't figure out where it's doing it. the field datatype is set to VARCHAR with a size of 100. the data is being cut at 30 characters. here is the form field: Code:
View Replies View RelatedI have an articles_tbl . How do i create a select statement which only brings back the latest 3 records added to this table (the database has a field called 'date_added') so the information of when they were added is present.
I was just wondering how to bring back only THREE records and showing them, instead of bringing back the entire table content and then showing three out of them..
i got this error when trying to looping through an array
Quote: Microsoft VBScript runtime error '800a000a'
This array is fixed or temporarily locked
Here are my code:
i know how to create text files using ASP, but is there any way to create fixed width text file using ASP? i need to have the data lined up in the same location at each row.
View Replies View Relatedi am designing a search engine, you select the search options from five choices in a drop down box, each option reveals a table, but the tables have fixed positions on the html page.
i need it so that if only one option is picked to search and it is the last option on the drop down list, that it will appear at the top of the page? i dont have a clue what type of function to write to do this or what techniques will be involved!
How would one extract the number of (days) from (today) and a (future fixed
date)- eg: February 12, 2003. ....where today will always be Date().
Thus:
02/12/04 - Date(now) = 27 days.
Can anyone help me here?
is there a tutorial around anywhere that tells you how to change images on the page when a user selects from a select box
View Replies View RelatedI have a database of songs listed as Title, Artist,Description, DiscNo and TrackNo with a seperate record in that format for each song.What I would like to do is search through them for the Description, show only the disc numbers in the results.
This I can do easily. Where I am lost is that I only want each individual disc number to show once. If I moveNext through the recordset, it shows the disc number 15 times per disc. Is there a filter I can add to limit this display?
Is there any way to input .asp code so that a specific element isn't show on a page? example: I don't want a menu on a specific product page, but I want it on all the others. Is there any code to input into a site wide includes file to implement this?
View Replies View RelatedI have a ASP application which let user to download their reports in pdf format. I would like to show a progress bar, or change the mouse cursor to a hourglass while the user is waiting for the file. How to acomplish this? In the asp code, I use response.BinaryWrite to create the pdf file directly to the browser. How to detect when the file is ready?
View Replies View RelatedI create a page which will show me all the Regions from the table "RegionTable" where I have no information (empty fields) in on of the fields RegionDescription or RegionRank.
It is to make my content managing easier. I do not want to see those records which contain all the necessary info (region description and rank).
I tried the following code, but it does not work
qry = "SELECT * FROM RegionTable WHERE RegionDescription="" AND RegionRank="" "
error message is:
([Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1)
I have a query that displays values from a db.
The problem is that the value displays like this:
R 6.5
instead of like this:
R 6.50
How would I get it to show the full value?
ok, well what I have been having some trouble with is to show the person character name like this:
Welcome, 'Username' <-- Here I want it to show the persons username from the database.
I am using a Cdonts e-mail script that e-mails the results of a form to my address. It currently displays the data like:
Amount: 12.00
Percent: 2.00
I need it to say:
Amount: $12.00
Percent: 2.00%
How can I get the $ and % symbols to be included in the e-mail template without getting a 500 error?
Here is what I have:
Body = Body & vbcrlf & "Amount: " & request.form("amount")
Body = Body & vbcrlf & "Percent: " & request.form("percent")
I've tried a few diffrent ways but here is one example:
Body = Body & vbcrlf & "Amount: $" & request.form("amount")
Body = Body & vbcrlf & "Percent: " & request.form("percent")%
I've tried using / before the symbols and "" but everything I've tried keeps coming up with a 500 error. How can I add these symbols to my template so they will show up in the e-mail?
I know we have this thread somewhere, but I can't seem
to find it now
I want to show the first 100 chars of a string, but
I don't want a word to be cut in half at the end, it must
show the whole word then and go a bit beyond 100 chars.
How do you print out all of the contents of an array if all you know is the array name?
FOr example, I am looking at pre existing code that looks like this:Code:
scartItem2 = session("cartItem")
arrCart2 = session("MyCart")
For Z = 0 to scartItem2
cartfields2="&Email=YES" & "&processed" & z & "=" & arrCart2(cProductid,z) & "&quantity=" & arrCart2(cQuantity,z)
What I need to find out is if there are ANY other elements other than cProductid AND cQuantity in this array and what their names would be so I can add them to the code.
I know that I could print out the values of the above by simply doing this:
response.write(cartfields2)
But how do I find out if there's a cFeature or any other element?
i have very strange error.i can not see some of the asp pages on my browser. when i
look from view source, all the source is there but browser does not show anything, just an empty page.
im looking to find out how can i make, when the pointer is over a link or picture without clickin on the link an small textbox(something like that) open and show the content of that link. for example in this forum when you go over a thread you can see the content.
View Replies View RelatedI have a ASP page that when a user clicks a link it uses a DLL to stamp a .pdf with a watermark and then display the .pdf in there web browser using the Adobe Reader. This all works fine.
if a user views a pdf and then modifes it if they click the link again it still shows the old version of the file. They have to hit there refresh button to show the changes. How can I make it so my page always displays the lastest version of the PDF and not what is in the cache?
i have a website that users log on to. On one of the pages is a form. What I want to do is only show a certain part of the form for specific users. The way i want to do this is by using their username as a 'show if' command in dreamweaver. What I currently have is this
<% If Session("MM_Username") = "union" %>
all data to be hidden shown is here
<% End If %>
But this doesnt work for me! Any suggestions on how to show this properly?
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..
View Replies View RelatedIn one of my ASP page, I want to show the visitor's IP. Who can I do that?
View Replies View Relatedhow to show popup windows (html format) and the size is depending on the size of image?
View Replies View Relatedi m displaying only 4 lines of my main news..and after that there is one link more...if user click on this link then the detail of this news will display....but problem is i want to show the rest of content of this news at same place..i maen to say after clicking more it will display my main news content in place of 4 line and more link Code:
View Replies View Related