How do you change the DateDiff function to give only 2 digits?
[CODE]
ltOffHours = Abs(DateDiff("h", CDate(rsRecs("EndTime")), CDate(rsRecs("StartTime"))))
ltOffMinutes = Abs(DateDiff("n", CDate(rsRecs("EndTime")), CDate(rsRecs("StartTime"))))
ltOffTime = ltOffHours & ":" & ltOffMinutes
It gives me I.E. 4:345, I need have it read only 4:34 minutes. anyone know how to do this?
I currently am using a script which submits full state names to a payment processor. However, the payment processor only accepts 2 digit state names. Does anyone have a premade code for asp that converts state names into 2 digit ones.
example:
If statename = "New York" Then
statename = "NY"
End If
for each state.
How can I create a loop that goes from 01 to 12, to show months of the year as two digits, or how do I change "1" to "01"
View Replies View RelatedThis is probably an easy answer, however my mind seems to have gone blank about scanning a barcode in, and taking the 1st 4 digits of the number and storing it into a session variable to be referenced later in this application.
This session variable will then be checked against an ACCESS database to see if the product exists. I assume I use the LEN function? LEN(VariableName, 4)?
I saw in SPF an ASP code that was usable to hide the first digits of a credit card number and replace them by a "*". I'm really sorry to post such a thread, but I can't find it back. Does anyone have the link? I've tried to check it in the funky functions and sections like that. Maybe just missed it but well. tried to see many times.
View Replies View Relatedwhen 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 RelatedI have an access database with a table called jobs with a field called 'jobnumber'. I have this set up with a format mask of "0000" so that "1" becomes "0001" etc.
However when pulling this data out in Dreamweaver the formatting is lost.
Does anyone know how I can set this in Dreamweaver?
converting a single
digit (ie: 1, 2, 3, etc) to double digits (ie: 01, 02, 03, etc).
I am trying to convert the date in DD/MM/YYYY format so it is always displayed as 01/01/2004 instead of 1/1/2004.The script I am trying to embed this into has similar attributes to the Calendar on this site located at http://www.asp101.com/samples/calendar.asp.and the objects that require to be double digits are iCurrent and Month(dDate).
I am using Ms Access database and I have set 3 digits (e.g. 000) for an autonumber field of my table.Its working fine in Access and incrementing automatically like this (001, 002, 003 ...), but when I call the data on a web page using ASP its displaying these numbers like this (1, 2, 3, 4 ...) I dont understand why is it not displaying the numbers as it is in the table.
View Replies View RelatedI am storing a datetime into SQL Server 2000 field in datetime format. For single-digit months and dates, it is leaving the 0 off, like this:
11/6/2003
1/5/2003
For reasons having to do with technical requirements, I need to have it put the 0 in when needed, and not do it when it already has 2 digits:
11/06/2003
01/05/2003
How can this be done? When I get the value of the date in the first place, it is using the Now() function. For some fields, I only need the date, not time, so I do a DateValue around the result of the Now. Is this solved with ASP? Or do I need to do something in SQL Server?
in my asp form i would like to have a field which can ONLY accept
digits BUT can accept special characters as well such as: &,$$,##.
i.e: if the user enters :
147hhh, or P44556HH or QSSPE$% ---> this will be invalid
##123,45SS---> this is invalid
125&125#10$---> this is valid
12456--> this is valid too
is there any way to do this????
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 have a 5 digit account number, but I need only the first 2 digits of the number.
This shows the account number <%=rsSelSpecials("olaid")%>.
i have a form for users to enter their name password and e-mail,i am currently using javascript to check that all details have been filled,
if(myForm.fname.value=='')
{
alert("Plz enter a first name")
return false
}
This works if the field is left blank however if the user enters numbers(1,2) or spaces i.e.(" ") how do i deal with these,i also need to check that the e-mail contains "@" and "."
I need a function for blocking or converting letters inserted into a Form to digits, since the Data will be used in mathematical functions.
Is there a specific seach-function for letters, or:
If Input1(not a digit) then...
Else... Input1 * 5...
?
is it possible to convert asp.net coding into asp coding?i know out there, theres a software to convert asp code to asp.net.is there a software to convert asp.net code into asp code?
View Replies View RelatedI have a client that wants to send an invoice when a user submits a certain form on their site. From this form it goes to an asp page that calculates amounts, and check for a voucher. It then enters data in database and emails invoice.
But they want it send as a pdf attachment. How do i go about doing something like that. Do i convert the htm / asp to pdf. and send it?
<%
mysql="SELECT * from data"
Set con = SERVER.CREATEOBJECT("ADODB.Connection")
Set rs = SERVER.CREATeOBJECT("ADODB.recordset")
con.open "DSN=database4atc"
rs.open mysql, con
'recordset.open sqlcommand, activeconnection
%>
how to convert to dns less?
Not having luck in converting my DNS to a DNS less piece of code. This is what I have:
Sub Application_OnStart
Application("ConnectionString") = "DSN=DevDivision"
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.open Application("ConnectionString")
SQL = " SELECT AdminEmail, title, footer, p_id from tblSiteOptions "
set rs = Conn.Execute(SQL)
I'm looking for the best way to convert asp to jsp, ideally free software.
View Replies View RelatedI want to convert one .xls file to .csv file using ASP Is there any way to do this?
View Replies View RelatedI have inherited an ASP application that used MS SQL 7 for a backend DB.The original developer did an excellent job of commenting his work and the applications works fine as is. However, due to licnsing costs,the company is considering moving the application backend to MySQL.
I have looked at the DB structure and it has nothing extreneous other than FOREIGN KEYS. I have heard that MySQL does not support FOREIGN KEYS or Stored procedures.How do I get around the FOREIGN KEY support issue in MySQL?Other than changing my connection strings, if and when I do get the DB end working,do I need to redo the codes?I would like to keep the codes as is and simply redo the interface.In general what should I expect?
The Application was at the initial stages when the company changed course,so they don't mind losing what little data they have in the existing MS SQL 7 db,BUT the table structure must be kept as designed in MS SQL.
is there any way to do a cart blanch dump of a csv file into an MDB file? i.e. specify file, submit, done! that easy?
View Replies View RelatedI have this one short section of code that I need to convert to ASP. Currently it's in PHP and our server does not support that. this code would be used to get someone's email address for a newsletter. Here is the code: PHP Code:
<?php
$var = ', '.$_GET['var'];
$fp = @fopen("file.txt", "a") or die("Couldn't open file.txt for writing! ". $var );
$numBytes = @fwrite($fp, $var) or die("Couldn't write values to file! " .$var );
@fclose($fp);
?>
what is the best way to convert an access .mdb into a mysql .sql file? I found a program but it costs 60$ and thats gay so is there a better way?
View Replies View RelatedI have this code that I need to convert to php. I tried using the client-side online conversion but it didn't work to well. This is an easy script and I can mostly do it myself except the date functions. Code:
View Replies View RelatedI'm in charge of setting up and tracking advertising for my company. Since Google can be set up to automatically mail out a report every day (I also use Overture) I would like to write a program that would automatically grab the .csv file from a specified location, grab the data and convert it to an Access .mdb file.
The idea is I'd like to automate the process of downloading reports from these two sources, transfering them to a database, and mailing the new db file out. I'm not really sure if this is possible or not, since I don't know how to grab a column from a .csv file and convert it into a field in a table.
i did a application here it works off line and for online also
when i sold it for offline there is a problem with ASP code
any idea for changing asp files to dll file
i need to convert a string to hexadecimal prior to posting it onto the next page...how do i pass the field value to the function prior to posting ? Code:
<%
Function StringToHex(str)
' conversion here
End Function
%>
<html>
<head></head>
<body>
i hope my doubt is clear. i tried looking in the posted forums couldn't find anything . Anyone know how ?
Is there a way to convert a page of html to rtf ?
View Replies View Relatedim trying to input some data into a database from a text box to a field with a text data type the problen is when i try to input "44/22" it goes into the database "2"
so it makes the math process
so how can i fix this to insert the 44/22 into the database ?
i had select the data from the database. The null value are returned.
How can i convert the null value to integer so that i can add some value for it??
Actually i try to use both of this statement but there's nothing come out...when i try to selecte the data in the database, the null value are returned
if rs("max_id") = "NULL" then
id_no = 1
response.write "id_no = " &id_no& "<br>"
end if
and
if rs("max_id") = "" then
id_no = 1
response.write "id_no = " &id_no& "<br>"
end if
I am setting up a website similar to http://www.4mobilefun.com/mobile-gam...ware/index.asp.
For search engine reasons I need the website to html format. The website will be given to me in ASP format. For example:
I want http://www.4mobilefun.com/mobile-gam...ware/index.asp to be http://www.4mobilefun.com/mobile-gam...are/index.html
and
http://www.4mobilefun.com/mobile-gam...ake=nokia+7250
to be
http://www.4mobilefun.com/mobile-gam...nokia7250.html
and
http://www.4mobilefun.com/mmsend.asp...es&object=game
to be
http://www.4mobilefun.com/mobile-gam...cksnbabes.html
Is there an easy way of doing this?