have a 'money' field in the SQL 2000 table that users enter 200 (for example
which represents �2.00) without the decimal point, what I need is to have a
command or something that adds the decimal point before the last 2 digits,
so user enters 200 and the value stored in the table is 2.00 bearing in mind
that this value could be anything from 1.00 to 50.00.
ok i have a number lets say its 36 and i want to divid it by 150.... 0.24 returns... i want to change 0.24 and make it a percent to it would be 24% how would i do that...
View Replies View Relatedi am trying to upadate a column in Access using Asp.net and VB, the code although gives no errors, it does not seem to update the table column data. Code:
Dim queryString As String = "UPDATE [Member] SET [UserName]=@UserName WHERE ([Member].[UserIdNumber] = @UserId"& _
"Number)"
it is done via a function:
updateTest(userId,lblTest.text)
There are 2 columns in 1 database for Id and name but the serial number is random.
I want to update those serial number in serial order, how to? Code:
trying to use CDO object not working, have tried to set up default mail account which works ok, but CDO not piping through it. any know of any way to point CDO to box's mail account or something like that?! annoying coz CDO works ok on myother box, box not working on running SBS 2003.
View Replies View RelatedI'm wondering something about global.asa. We have a stats package that has been written for us. It tracks sessions by tracking session IDs rather than IP addresses, because this is much more accurate (tracking by IP can only give you an average guess at numbers of sessions).
The problem we have is that static HTML pages do not create a session ID. It remains as "-" in the log. I'm wondering if we can use a global.asa file to force IIS to open a session? The thing is, this will still be useless if global.asa only runs when the ASP file is requested, rather than when the first site file is requested.
So, now you have the background, the question is quite simple:
Does global.asa run when you first hit a site (ie: when default.htm is called) or does it run when you first hit an ASP page (like search.asp)?
Obviously, in the latter case that can mean that it's perfectly feasible for someone to spend half an hour on a site and never actually fire the global.asa or trigger a session, which is a rather fundamental problem.
I am just starting to think about adding a db to my Webs. I want to use a db
to change pages within various Webs and subwebs by scheduling these pages
ahead of time so the pages will already be loaded (visible) when a visitor
arrives. Sometimes I will need to replace one exisitng page with one or more
pages for the scheduled time period.
After the time period has passed, I want the Web or subweb changed back to
what is was before the original change took place automatically. None of the
Webs or subwebs will require any ecommerce or tranactional capability.
I have the following code in a script:
' Pecentage Interest on Loan
YearlyInterestPercent = 6.5
' Get Annual Interst Rate from Interest Percentage
YearlyInterestRate = YearlyInterestPercent / 100
' Divide Yearly Interest Rate by 12
' to Get Monthly Interst Rate
MonthlyInterestRate = YearlyInterestRate / 12
These values are supplied by the user using a form but I made them static for this example. For some reason, when dividing the Yearly Interst rate by twelve, MonthlyInterestRate equals 5.41666666666667E-03. The result should be 0.005416667. Does anyone know what I can do to correct this?
anyone have a quick example of using insertion point of data with MSWC.Tools ?
e.g. how can I send data to "div" tag ?
Set oTools = Server.CreateObject("MSWC.Tools" )
oTools.processForm "output.asp", "template.asp", "<div>"
if a page always have some picture that totally have near 250k does this a main point of affect the loading speed?
View Replies View RelatedHow can change the mouse point to Sandglass?
View Replies View RelatedI have a asp page which is pretty long. This consitst of various recordsets. My intention is to stop execution of a code at a cetain point and test one value prior to this point. Is there any way to do this?
View Replies View RelatedI have created a web application using ASP with VB.I would like to export some of my web pages (.asp page) to Power Point slides and view it as power point presentation.
will it be possible ?
anyone have an example of using insertion point of data with MSWC.Tools ?
e.g. how can I send data to a "div" tag ?
Set oTools = Server.CreateObject("MSWC.Tools" )
oTools.processForm "output.asp", "template.asp", "<div>"
I am trying to solve the following exception. The exception occurs when my
ASP.NET code behind code attemtps to access a remore site using SSL. Please
note that all certificates are valid and the remote site is trusted. Also, my
web site uses a custom HTTPModule implemented in a DLL named Security.dll.
Unable to find an entry point named EnumerateSecurityPackagesW in DLL
security.dll.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.EntryPointNotFoundException: Unable to find an
entry point named EnumerateSecurityPackagesW in DLL security.dll.
I am curious to know that if given two strings such as
http://www.domain.com & http://www.domain.com/somepage.asp how could I compare those strings to see if they are from the same domain? I am setting up a link exchange that requires a person provide their url and a verification url where my link is located. What I am trying to avoid is having someone do this:
www.theirdomain.com & www.someotherdomain.com/links.html whereas the second domain may have a link to my site but it is not related to the entrants domain.
I want MS Access 2000 database column of table 1 = column of table 2. This is what I was doing: Code:
View Replies View Relatedif there is an easy way to convert hex to decimal with asp, the hex() function is there to get the decimal to hex, but i haven't been able to find a way to go back.
View Replies View RelatedI want to convert a number to percentage or decimal,is there any built-in function for this?
View Replies View Relatedi want to do the calculation like
value=int(basic) * int(excise) / 100
the both value come from the form. so when the data of excise field is like decimal 16.32 then i get the error data type mismatch.because the excise is 16.32 it is a decimal value. i have used CDbl(excise) but still it gives error.
My ASP driven site has always used MySQL as the DB backbone, mainly as the hosting costs of MySQL are far cheaper than SQL Server at the mo, and it has worked fine until my ISP thought that they were doing everybody a favour by upgrading to v5 from v4.
What happens now is that any ASP query that I do that involves any of my MySQL Decimal data type fields goes belly up. It will not work. Looks to be an issue with ASP, MyODBC and MySQL, but I just wanted to check if there was a better/more reliable data type than Decimal (which obviously performs the same numerical functions) and if there was a quick way to convert all of my Decimal fields to this new type.
Testing a ASP page using an Access db and I have a field in the DB defined as a 'number' with a precision of 3. Upon submitting the test data, I get this error message.
Microsoft JET Database Engineerror '80040e21'Scaling of decimal value resulted in data truncation. Can anyone tell me what's going on? The test value I used was "2.5".
Is there a quick function to check if a passed value is a valid Hex Color? ie, if FD4323 was passed, it would return TRUE, and if FD94LR was returned it would return FALSE.
I'm finding conversion functions, but nothing that tests off hand.
I have searched the forum and found the answer to my problem but unfortunitly it didn't tell me how to implement the solution!
The code I have thanks to previous forums:
Code:
<%=(rs("Seconds")/60=FormatNumber(2.5,2))%>
Basiclly I want to convert the seconds to minutes and round to two decimal places.
Anyone have any code handy to convert a binary number to decimal and a decimal to binary? I need server-side code to perform these calculations. For example, I'd like to be able to pass 129 to a function and it will return 10000001. Likewise, I'd like to pass 10000001 to a function and get 129.
I can do this on paper, just not sure where to start on how to pass these numbers into a function to perform the calculation.
i have a script that calculates a value but when the value is for example 5.40 the textbox displays it as 5.4 because this is a money value it has to have the "0" at the end
how can i make the script so that it always has 2 decimals behind the comma or point. Code:
I have a form in an ASP page that the user enters a price for. When I send the parameter to my SQL stored Proc and refresh the data, it gets rounded up to the nearest integer. I can change the data just fine in SQL but not by using my asp page. Can anyone point me in the correct direction?
View Replies View Relatedi have the following equation:
<%
avg_score = total / count_match
%>
what can i do to restrict the result of avg_score to be of 2 decimal places?
I need to truncate a number to two decimal places without rounding. All the functions i;ve tried tend to round up the numbers. Also i cant use any string functions to limit the size because the size can vary. example, 34.56998 must be set to 34.56 .
View Replies View RelatedHow do I write? Code:
Dim johnson, jordan
decnum = Request.Form("decnum")
decnum = Cdbl(decnum)
If decnum is "a decimal number" between 4 AND 8 Then
jordan = 23.90
End If
I have some calculations in my query string. Is it possible somehow to get a results of those calculations not in decimals but in integer in the query itself.
View Replies View RelatedI 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?
View Replies View RelatedTrying to find a built in function or a neat custom for decimal validation, I assume there is no IsDecimal for ASP so somthing along the lines of the following function that wont round the number entered. Code:
Function validateInt (thisInt)
If IsNumeric(thisInt) Then
validateInt = Clng(thisInt)
Else
validateInt = 0
End If
End Function ...