Calculating Text Pixels
if there is a way in ASP, to calculate with of a string of text in pixels. The result is to be used to set table width so that texts don't get wrapped to second line.
View Replies
ADVERTISEMENT
VBasic Text Field (phone Number) Calculating Data Before Inserting Into Access
I have a text field in a web page I am working on that seems to be calculating phone numbers before inserting them into an Access database. i.e., 867-5309 will result as -4442 in the Access text field. My guess is that the webserver or client is processing it before inserting it. Is there any way to stop this other than using a validation script?
View Replies View RelatedCm To Pixels
Can i ask u 1 cm equal how much pixels?1 inches equal how much pixels?
View Replies View RelatedString Length In Pixels
Categories are beïng used out of a database to make a menu, example given:
menuitem 1 | menuitem 2 | menuitem 3 | menuitem 4 | ...
This all works, but the table width can only be 770 pixels.
If the menu structure is going to be wider than 770 pixels it has got to be devided into 2 or more lines.Is it possible to determine the pixels word by word?Or is there another possibility?On Google I read it would be possible in java, php,Only I didn't find anything that refers to ASP.
How To Show A Full Width Of A Picture But Only When It's Smaller Than 150 Pixels ?
I need to show two pictures in a table with two TDs
The pictures R dynamic and I don't want to enlarge the table...
How can I load the picture with IMG tag so that it's width will remain smaller than 150 pixels (or set it to 150 pixels if it's longer than 150...)
Must I check the picture file width or is there a faster workaround ?
Calculating Age
I have a form setup to search for people between CageT1 and CageT2 but am unable to get it to work. Peoples birthdates are stored in Access in m_date_of_birth; age is not stored in the database. The code below is a test.asp page I created so that I could debug the problem; thats why all this page requests is a Response.Write(sql). Code:
View Replies View RelatedCalculating Vat Tax
I'm having difficulty calculating vat 917.5%). I've written some basic asp to do this, but the result is far from correct. Can anyone spot what I've done wrong ?
<%
Session("price") = (Session("variable1"))+(Session("variable2"))+(Session("variable3"))
%>
<%
vat = Session("price") / 100 * 17.5
Session("total") = Session("pprice") + vat
Session("total") = FormatNumber(Session("total"), 2)
%>
For example, if my variables are:
variable1 = 165
variable2 = 50
variable3 = 25
When I write the session variable 'total' it comes out at: 1,944,654.38
If I run the vat calculation on just on variable, without adding them, the result is correct. So I guess I'm adding sesison variables incorrectly?
Calculating Time
Ok so I have 5 variables:
start = "8:00:00 AM"
lunchstart = "12:00:00 PM"
lunchend = "1:00:00 PM"
end = "5:00:00 PM"
totalhours = X
What I want to do Is calculate the total hours between start and end and subtract the total time spent on lunch. For example, using the variables above I have been trying for weeks to figure out how to make total hours = 8
Calculating The Score
I have set up a variable that if the answer is correct score =1 however im not sure how to total all the scores and i would also like to have it as a percentage. Code:
View Replies View RelatedCalculating Median
I have a microsoft access database with one table. I am trying to extract a filtered list of records from the database using ASP. So far i am able to do this. My next step is to somehow calculate the median from this filtered list within ASP. Maybe using some VBscript or something?
View Replies View RelatedCalculating Fields From DB In ASP
Let's say I have an Access DB with a table named proCount. In the table proCount, I have two fields named numOne and numTwo. In my ASP page I'd like to have a repeating region that lists all the records in the proCount table. Is there a way to have ASP calculate the sum of all the returned records for the field numOne and the field numTwo?
View Replies View RelatedCalculating Probs
I need to get the sum of all fields where clientID = 'woteva'
so far i'm only doing this by bringing them up with the 'move nxt' but this then displays all the fields, where i just want to display the result without all the fields showing aswell? Code:
Calculating Percentages
I know this is more of a maths problem. But I'm not having a good day with it today. what I need to do is work out the percentage of closed job against the total jobs made? So
StrTotalJobs
StrClosedJobs
are the varables. What is the code I need to work it out?
Digits Calculating
when I calculate a Digits for example: 101.12 * 1.21 the resilt is 122.3552 This one should be 122.36 and if it is 122.3549 to be 122.35 How can I make this thing works?
View Replies View RelatedCalculating Birthdates
I have birthdates in a field called CustomFieldDOB in a table called Vendor. The birthdays were entered with mixed formats, m/d/yy, mm/d/yy, m/dd/yy, m/d/yyyy, mm/d/yyyy, m/dd/yyyy, and with separators of / and -.
Total number of entries is 5600+ so manually changing each of these to one format would be VERY time consuming. In the end, I am trying to have our Intranet page show "Today's Birthdays". I am familiar with setting up a loop to display the Vendor names , I just don't know how to calculate variable formatted birthdates.
Calculating Minutes Between Dates
I need to calculate the number of elapsed minutes between two datetime variables. BUT, it needs to only include times between 8am and 5pm on weekdays.
So if the starting datetime is at 5:01pm, it doesn't start counting until 8am the next weekday morning.
Or, if the ending datetime is at 6:30am, the counting would stop at 5pm the previous weekday.
Calculating Time Difference
I am logging a time that people log in, stored as a short time. I want to be able to run a script which runs through my users database and checks all the users who are logged in, it checks the users last action time time against the current time and automatically logs any out any users who haven't had any activity in more than 30 minutes.
pseudo code as follows:
dim currentTime = now()
dim lastActionTime = rs("lastAction")
if(lastActionTime < currentTime - 30 minutes)
log the user out
Can anyone tell me how I code the time calculation to deduct 30 minutes from the current time?
Calculating Database Fields
At the moment in time I have a product database being displayed. I could do with including another column to the database which allows me to enter a specific quantity for that product line. All the quantitys fields need to be calculated to their specific product cost value.
Finally all the sub totals need to be calculated together to give a grand total, which will be displayed on another page.
Calculating Page Breaks
I am trying to modify an existing ASP application that produces forms with several 'blocks' of text that are contained within table cells and which have their own HTML id's.
These blocks must not be split over two pages. Is there a straightforward way of calculating the size of each block/table cell so that the blocks are not split and the form prints on the minimum number of pages? This is an intranet application, so we have a certain amount of control over browser settings, so margin settings etc are not a problem.
Calculating Average From An Array
I have an array like
array = "1,2,3|,2,4,6| ...)
There will be an unknown number a values between the | and an uknown total number of values. I need to get the average of the number between each of the |'s. Any ideas how to handle that?
Calculating Totals With Data From Access
I have done a fair amount of coding but very little in the way of maths type stuff
<code>
While Not objRSC.EOF
Response.Write "<tr><td>"
Response.Write objRSc("Item_Quantity") & "</td><td>"
Response.Write objRSc("Stock_item") & "</td><td>"
Response.Write objRSc("Stock_description") & "</td><td>"
Response.Write objRSc("Item_Price") & "</td></tr>"
objRSc.MoveNext
Wend
</code>
What I now want to do is to add all the Item_Prices together, .
Calculating, Calling & Printing Return Values
I have a problem with returning a value from an external function.....
My asp page is basically a list taken from a database. A date record is written from the DB, then all the recordslinked to that date are listed, then the next date, then the next series of records, i.e. Code:
I Am Having Problems With Calculating The Total Seconds From Two Date/times.
I need to get the number of seconds when subtracting two date/times.
With the code I am using below I subtract the two date/times and end
up with a total of days like "1.56".
Then when I multiply it to get
the number of seconds I am not getting an accurate number. I should
only have whole numbers of seconds with nothing past the decimal
point. I would like to be able to subtract the two date/times and get
the number of seconds without multiplying to get it. Is this possible?
Does anyone have a better more accurate way to do this? Code:
Controlling Text In A Text Area Or Text
I have this problem in controlling a the text in a Text Area. How can I do
that for example the field size is 200, when it reaches 50 it automatically
goes to the next line. Bcoz im having problem when viewing it in my report,
it continuesly views in a strieght line and im having problem in printing.
International Text And FSO Created Text Files
When using ASP's FileSystemObject to create text files, I am unable to get user submitted text (in Hebrew) to save as anything other than "?????". The text file is being saved in Unicode and setting the CodePage in ASP proved unsuccessful. Strangely, hard coded Hebrew text in an ASP variable does add to the text file correctly.
Any ideas of why this happens and how to get it to work correctly?
Text Area Limited Text
I have a text area which I want to limit the number of words or number of text entered into it. Is this possible?
<textarea name="textarea" cols="35" rows="5"></textarea>
In the text area above, can I say limit the person filling in the text area to say 100 characters?
Text Box In Form Cutting Text
I have a form on asp page that pulls info from a DB when the page loads.
It them puts the info into text boxes on the page that are editable by the
user.
The only problem I have is say in the description text box it should
read "HP Laserjet 5Si" , it always cuts the text off where it just says "HP"
.. It does this on all the text boxes? I can't seem to figure out why it
is doing it. Here is the sample code:
With quotes around <%= vdesc%>
<td><input name="desc" type="text" id="desc" size="45" value="<%=
vdesc%>"></td>
And I tried it without.
Regular Expression Of Text OR Text OR Etc...
I have text in a field coming from a database. The text has various
forms such as:
text1
text1 or text2
text1 or text2 or text3
text1; or text2
text1; or text2; or text3
etc...
how can I parse this with a reg ex? I tried this:
(.+);? or
but it only captures 1 submatch (text1) and only if theres an "or"
after it
I'd like to get 1 submatch for each piece of text separated by the
"or", just the text itself if there is no or.
Anyone know how to do it?
Controlling Text In A Text Area
I have this problem in controlling a text in a Text Area. How can I do that, for example the field size is 200, when it reaches 50 it automatically goes to the next line. Because im having problem when viewing text in my report, it continuesly views in a straight line. Can you give me ASP code for that.
View Replies View RelatedHover Over Text To Bring Up Text
I have text - ARI Promise, when I hover over the text I would like a box to appear with the Promise information. It would be several paragraphs that need to be formatted with paragraph and bullets. Is this possible to do? If so how would I go about it?
View Replies View RelatedDisplay Text In Text Box
I have a search page, after search returns value I want to display fields in text box instead of table.
View Replies View RelatedError In Asp Text: Command Text Not Set For The Command
I am getting the above error in an asp page. Not sure why? The error details is given below. Code:
View Replies View RelatedText Box
I'm trying to make a text box for comments. I know how to put one value into a text box like name, but i'm not sure how to pull multi-values. I want to be able to display the time,user and comment in a text box. I don't know how to go about this. The comments are stored in a different table and there can be many comments for one policy.
What i did was i have asp code the displays all the comments and puts it into a table, but i want to put this into a text box not sure how to go about it. Here is the code i'm using. the reason why i need it to be in a text box is so the user can update it, does anybody have any ideas. Code: