is there anybody know to code the time difference in asp? i used timediff, it returned a date, it should return a time actually. i tried the command in mysql n it's fine. but it's error when i switched to ASP. i hv refered to alot references such as sql time manual n other sites. but stil fail to find ans.
View RepliesI would like to display the difference between the logging time
[Session("start"] and the current time [now]. In hours minutes and seconds,
I have tried a couple of things but all I see is gobbledy gook.
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?
I'd like to find the time difference in seconds in my ASP-code, but can't find how to do this. In php you have the time() that give the seconds from 1.1.1970 (?) until now. Is there something like this in ASP too? I have found the DateDiff that one just gives days, right? I basicly want to have two variables, time1 and time2, and show the seconds between them.
View Replies View RelatedI have been looking around at various design solutions for uploading a file using ASP and have found that many sources have devised a much simpler plan using ASP.NET.
My question is this, I have a box running Win2k Advanced Server, with the .NET framework installed. WIll that enable me to run some of the new functions etc. decribed in ASP.net ??
What's the difference between ASP and ASP.Net? Which one should I learn in order to start making dynamic web pages for the internet?
View Replies View RelatedSo I need to write the difference between the biggest and the smallest number in database table. I know that I need to take MAX and MIN from table, but I just can't get it work.
Example:
Let's say max = 5 and min = 1, I need to have it like this:
5-1=4 (max-min=total)
Maybe my books are just sorry, but I can't find a description of what <%# is supposed to mean. I find Dreamweaver inserting it often.
View Replies View RelatedIs there any technique available that my asp code will convert into asp.net
View Replies View RelatedWhat is the difference between
Code:
<meta http-equiv="refresh" content="5;url=menu.asp">
and
Code:
Responce.Redirect("")
Which one would you chose?
What is the difference, and when to use one over the other?
View Replies View Relatedi have a problem with differentiating these
response.redirect()
server.transfer()
server.execute()
do they all perform same?
I'm writing an ASP app that administers an ISA server remotely. The fact that it's an ISA server isn't my problem I believe. My question? What is the security difference between disabling anonymous access and using account X from the web client, versusallowing anonymous access but using account X as the account that runs the application?
When I configure my web application to allow anonymous access, but set the anonymous process to use account X, my ASP code works (the ASP code can administer my ISA Server). When I disable anonymous access, and I log into the web application using the same account X I mention above, I get an error 80070005 when my ASP code tries to connect to my ISA server to administer it. I would think the above two options would be equivalent, but they're not. What is the difference?
I have a problem to calculate the day different. I use
datediff(currentdate, quoteDate) > 20
The error message is : Wrong number of arguments or invalid property
assignment: 'datediff'
I use datediff("D", Date, quoteDate) > 20, but still could get the correct one. Maybe I need to change string to the digit. How to do it?
I understand how asp scripting works and how you put <% %> around your server script. However this is .asp . what is .aspx? is this the new version ASP.nET? I dont understand how it works when i create a new aspx project in vstudio.net and i create a aspx page in design view.
I add a button and then double click it to add code to that button. I dont see any html code around it? In an asp page the server side code is surrounded by html code. An aspx page almost looks like a normal vb application, why is there no html
code around?
Can someone shed light on this: -
When I search for 'ô', the url encode shows a "%F4", whereas should I show a "%C3%B4"
A few weeks ago I was told in this forum that ASP would be a great solution to a large web site. I purchased a book about ASP.Net but have also seen info on ASP. Can you please tell me what is the difference between the two?
I don't know computer programming at all. Dreamweaver MX is the program I use. Can ASP be done with a WYSIWYG program? I have set up databases in Access & built web sites with DW MX I am not sure how to tie the two together.
I have an arrayA and arrayB. How do I get the difference into arrayC.
View Replies View RelatedI have 2 fields in a MySQL database. The fields contains calendaristic data. I want to generate a HTML report and make difference between theose date fields. Is there a function in ASP to accomplish this task (like : "=dateDiff(date1,date2)" where date1 and date2 are calendaristic dates)?
View Replies View RelatedI've been messing around with some way on how to insert into access. One page use the sql insert, the other uses
RS.Fields("Column_Name").Value = request.Form("Column_Name")
Both insert, but when i query them from a drop down box in an asp page the sql returns the values, the other one won't query, is there any logical reasoning behind this?
Basically I have 2 times:
timea = (date here) 12:00:00 PM
timeb = now()
and what i want to do is compare the difference in seconds between the two.
But I'm struggling and the thought has crossed my mind that DateDiff only works with dates not times...
Code:
<%
Dim DateToCompareTo
DateToCompareTo = 4/10/2005 1:00:00 PM
%>
There are <%= DateDiff("s", Now(), DateToCompareTo) %> seconds left %>!
I have an arrayA and arrayB. How do I get the difference into arrayC.
View Replies View Relatedanyone know the difference between these 3 include
statements?
<!--#include file="folderA/file1.asp"-->
<!--#include virtual="/folderA/file2.asp"-->
<!--#include virtual="../folderA/file3.asp"-->
I'm a user of ADO 2.8
Difference between declaring a RecordSet
Dim rs
Set rs = Server.CreateObject("ADODB.Recordset")
and
Using the Set keyword when expecting a RecordSet to be returned during a Command.Execute
Dim rs
Set rs = cmd.Execute 'cmd is a ADODB.Command object
Why is there a need for this?
I have an ASP app that grabs the logon user, and then I use GetObject to query the user's security groups. On a Windows 2000 server running IIS5, this works excellent. I then copied it to a different networks, Windows 2003 server running IIS6, and now I get permission denied on GetObject. How can get around this?
View Replies View RelatedWhat is the difference between radiobuttons in html vs. asp? What kind of reasons would I use to choose one over the other?
View Replies View RelatedDue to using a combo of OLEDB/ADO/ASP and JavaScript I was having trouble
reading in CSV data so I converted my client's web site to use tab-delimited
instead. Better for me, but client is adamant that their site's recent
timeout problems are since I converted to this tab format?? Code:
whats the difference between PostgreSQL and MySql. does my NT server have to have any thing special running to allow me to set up one of these (like MsAccess?) whats the best learning resource for xSQL and NT?
View Replies View RelatedI am new in asp. I have two html files. I like to write
code to compare those two files. I like to show the
difference as highlighted area.
Example: File 1 contains:
<html><body> Compare Test</body></html>
File 2 contains:
<html><body> Compare Test modyfied</body></html>
I like to make either the word "modyfied" highlighted or
the whole line highlighted on File2.
What's the difference between a private function and a public function?
What's the difference between a function and a sub-routine?
I was just wondering: is it possible to put something in ASP code that would be able to tell the difference when my site gets visited by a live user or a bot?
My website is setup to email me every time there's a visit, but it notifies me when it is visited by web crawlers as well, which I don't care about, I only want to know about real people. How do I teach my script to tell the difference? Any suggestions?
I have an order processing system in which I have an OrderDate and a
Completion Date
I want to print the difference in Weeks and Days between the two dates,
i.e. if the completion date is 3 weeks and 2 days after the order date,
I want to print : 3 Weeks and 2 Days, on the page.
Is this possible ?
I have two sites on my computer. If I display the header information from
site 1, it displays PATH_TRANSLATED as below.
D:kbapplicationprogramuihttpClientPortalkba rticleindex.asp
If I display the header information from site 2, it display PATH_TRANSLATED
as below.
D:kbapplicationprogramuihttpCustomerPortaldi splay2search.asp, except
the here is W with a line going across it. For some reason, when I paste
it here, it changes to , but in IE, it's W with a horizontal line.