Diff Between CSng And CDbl
I understand that all asp classic vars are variants and to always make sure that you are working with the type that you want it is best to use these built-in Cxx() functions, but I'm confused about whether I should use CSng or CDbl for my calcs.
I don't think they will ever be more than say 6 decimal places (at the very most usually 2 or 3) and the value the other way won't be in the millions (chance would be a fine thing!!) so should I be using CSng or CDbl? Is there any kind of performance degradation in using one over the other? Is there any kind of accuracy degradation in using one over the other?
View Replies
ADVERTISEMENT
I've been away from ASP so long that i don't remember the basics anymore but I'll do anything you want in Lisp.
I have a string "15.00" that I'm converting to a doube using CDbl("15.00") so it spits out 15 instead of 15.00. How do I ensure 2 decimal places for any number
View Replies
View Related
Can I convert a string to a double instead of an integer? I have a value of 5.5 and when I use the cInt it rounds it off to 6.
View Replies
View Related
I have a money datatype field in a SQL Server database.
I use the following method to take a value passed in the Request.Form collection and convert it to the double datatype:
cmd_AlloUpdateM2__incrdecr = Request("incrdecrA" & a)
cmd_AlloUpdateM2__incrdecr = replace(cmd_AlloUpdateM2__incrdecr,"$","")
cmd_AlloUpdateM2__incrdecr = replace(cmd_AlloUpdateM2__incrdecr,",","")
cmd_AlloUpdateM2__incrdecr = cdbl(cmd_AlloUpdateM2__incrdecr)
I keep getting a type mismatch 'cdbl' error on the line:
cmd_AlloUpdateM2__incrdecr = cdbl(cmd_AlloUpdateM2__incrdecr)
What's weird is I use this in other sections of my code and it works fine...no error. I've checked and re-checked the code and can't find the why this is happening?
View Replies
View Related
I'm grabbing data from an XML web service and storing the values in ASP variables. I'm trying to apply the cDbl function to values returned and I'm getting the following error:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'cDbl'
The data prints to the screen just fine
View Replies
View Related
I have login page that fails the login on the validate page and gives me the Type mismatch: 'CDbl' error.What I find funny is that I didn't notice that was happening until I assigned one User a longer password (xxxxxxxxx2004) but if I login in with password for another user and they have been using this (xxxxxx2004) then everything is fine.
I can't see the code to be the problem or can it. Password field is a varchar (200).
Would somebody have a suggestion,because earlier in the day I was able to create a smaller lenght wise password for this case and it worked if I do that now it fails as if I have incorrect userName or password.
View Replies
View Related
If I want to compare time, what is the best approach to go ? Any good
example ? DateDiff ( ) ?
Pseudocode
========
submitdate = rs.fields("submissiondate") -submissiondate is a date field
in a table.
if time for submitdate < = 8:15am then
do something A
elseif time for submitdate <= 10:15am then
do something B
elseif time for submitdate <= 12:15pm then
do something C
else
do something D
View Replies
View Related
anyone know of ways to show the dif btw two tables? if using left join . The LEFT JOIN returns all the rows from the first table even if there are no matches in the second table If there are rows in first table that do not have matches in second table , those rows also will be listed . this is not i want. i WANT to show ONLY the dif btw the two table. or can the sql statement be modified to suit my request ?
View Replies
View Related
Well i have txt file with abt 1000 Sentence i want that each sentence
appear on my website each time diff sentence on each visit on website
! i have done this:
<%
set Testfile=Server.CreateObject("Scripting.FileSystemObject")
set TfileStream=Testfile.OpenTextFile("C:InetpubwwwrootQuates.txt")
TextFormat=TfileStream.ReadLine
%>
<p align="center"><b>
<font face="Arial" size="2" Color="006699">
<i><align="center">
<%=TextFormat%></i></b>
</font>
But it happends for 1 sentense . i have 196 sentence in my txt file .
i want each diff sentence appear on each visit.
View Replies
View Related
I'm able to pull the image from the database but I'm not able to pull the text from the record using this script. What am I doing wrong? Code:
View Replies
View Related
to download a file from same server we use
Response.AddHeader "content-disposition", "attachment; filename=text.mp3"
but what if i want to download a file from diff server. How can i do that? i have tried using virtual directory which is pointing to diff folder in different server but doesnot work. First is it possible use to download files from virtual directory pointing to diff server altogether?
View Replies
View Related
I have one ASP page that has two separate FORMS, each that will update a separate SQL table. These tables are in the same DB with the same connection string for both.
The SQL statement seems to be writing correctly (when I test them) but neither of the tables updates when I try to update both of them. IF I try to update just ONE of the tables it does work correctly. Code:
View Replies
View Related
i have a page that i need to load in an iframe that is on a diff domain (sub domain), i need to get the doc height of the page so that i can adjust the iframes height (so there will be no scroll bars).the problem with that is even though its on the same sever, because it is on a subdomain the browser sees it as different and restricts access to it (makes sense).
so, what we can do is have php read in the page with curl and parse it out in the iframe. that looks like <iframe src="reader.php?page=subdomain.pagename.html">but, we cannot use php on this server so i was wondering if there is an asp solution that can do the same thing (vb script). basically, i just need that asp page to grab the page on the sub domain, read it in and then output it.
View Replies
View Related
I'm trying to grab a variable from a dropdown list and pass it to a paypal form, the problem is it's in two different forms.. Code:
View Replies
View Related
Is it possible to have, first n number of charectors in a text area in one
colour and the remaining in a different colour? If so how can it be done?
View Replies
View Related
I need to execute different asp programs based on different values of a parameter. For example, if the user inputs ID of 1, program1 needs to be executed automatically, if user inputs ID=2, program2 needs to be executed in the background automatically. How do we do this in asp?
View Replies
View Related
I was trying to integrate a forum software to an existing site. The site is having a different database file already. What i want to do is, copy the forum tables from forum database file to the existing site database. How can I copy the tables from FileA to FileB using ASP?
View Replies
View Related
I want to send email with attachment. I have no problem if the file is located on the same server but i got error when attach file from different server. This is the code,
set mail=server.CreateObject("persits.mailsender")
mail.host="smtp.mydomain.com"
.....
'mail.addattachment "c:attach est.txt" ' no problem with this
mail.addattachment "websvrattach est.txt"
.......
mail.send
I got this error,
"Persits.MailSender.4 error '800a0007'
Logon failure: unknown user name or bad password."
when i changed the servername to static ip address also got the same error.
any idea? fyi, this user has an administrator rights to the server.
View Replies
View Related
