Date Interval Functions
On a form I have
Date_Start Date_End
I have a new
Date_Start1 Date_End1 which the use
inputs.
I need to validate that Date_Start1 and Date_End1 are a date range entirely separate from Date_Start and Date_End i.e. no overlapping whatsoever. In effect checking a date interval.Are there any functions out there already written that can do this? It seems to basic to start comparing and contracting dates! Would like to do it in Javascript, but happy in vbscript also.
View Replies
ADVERTISEMENT
i am wondering how to actually get the month in letters..... i have used a
strMonth = Month(Date)
but it is returning a number of the month... i would like to make this the actual month such as January, August, etc.... how would i go abt doing this in ASP.....
View Replies
View Related
So i am inserting Now() or Date() (Either one will work for what i want), into one of my fields.
But it is returning the Server time, which is about 17 Hours behind of what i want. Is there anyway to insert Australian time, as in where i am situated?
View Replies
View Related
if there was a function in ASP that checks a date to see if it is valid or not. I am aware of the IsDate function, but I think its not what I'm looking for. I want to run the following date through a function and have the function tell me that it is
invalid: 31-Feb-2003 (cos there is not 31 days in Feb).
Or a good way to make my own function?
View Replies
View Related
I have a column in my SQL server database table by name request_generated_date of datetime datattype and the default value set to it the server date by using the function getdate().
I am querying this table wherein I want to check that when a user submits a form then it should check the following: the submit date (column:request_generated_date in the tabel)should be less than the server date + 24 hours (or one day). When I am writing the query as
where request_generated_date ='"&dateadd('d',1,date())&"'"
but the result set is empty.Can I use the date() function in ASP or not. or should I try to remove the time factor from the server date and then query the column.
View Replies
View Related
The interval that a driver is available from 5:00:00 AM to 8:00:00 PM.... And I dont want to pick this route that runs from 10:15:00 to PM 4:00:00 AM ... because the driver is not available btw those times..However my query picks that tooo..Why?
rs3.Open "SELECT * FROM Routes " &_
"WHERE instr(Day_Runs,'"&trim(rs("sch_day"))&"') " &_
"And ( (start_time = #"&FormatDateTime(rs("sch_time_start"))&"# AND end_time = #"&FormatDateTime(rs("sch_time_end"))&"#) " &_
"OR (start_time > #"&FormatDateTime(rs("sch_time_start"))&"# AND end_time = #"&FormatDateTime(rs("sch_time_end"))&"#) " &_
"OR (start_time = #"&FormatDateTime(rs("sch_time_start"))&"# AND end_time < #"&FormatDateTime(rs("sch_time_end"))&"#) " &_
"OR (start_time > #"&FormatDateTime(rs("sch_time_start"))&"# AND end_time < #"&FormatDateTime(rs("sch_time_end"))&"#) )" ,conn
View Replies
View Related
I am developing site in asp where I need to call a url at every interval. Is there a way to automate this. I want to call the url every 15 or 30 mins.
Cureently I have written a asp script tp call it using
Set objWinHttp = Server.CreateObject("WinHttp.WinHttpRequest.5.1")
objWinHttp.Open "GET",URL
objWinHttp.Send ' Send it.
strResponse3 = objWinHttp.ResponseText ' Get the response string from the object.
But it is not schedule..I can call it only when I rum the asp script. So is there any way I can schedule this url call for every 15/30 minutes.
Also forgot to mention : the site does not have that much traffic that I can add it in index page...there may be a user visiting the site in 5 hours time or within next 5 mins or for next 2 days there may be no visitor.
View Replies
View Related
The interval that a driver is available from 5:00:00 AM to 8:00:00 PM....
And I dont want to pick this route that runs from 10:15:00 to PM 4:00:00 AM...because the driver is not available btw those times..However my query picks that tooo..Why? Code:
View Replies
View Related
I want to send automatic emails from my website after a definite interval of time.
I need a way to execute my ASP script repeatedly without any external triggering....
View Replies
View Related
I am developing a simple booking system where I had a booking date. The problem is I want to make sure that the user must book 3 days in advanced for certain room.
I have tried to use DateDiff but it seems doesn't work. Actually i just 1 to make sure that the user must book 3 days in advanced from the current date. I am wondering whether there is anything goes wrong in my datediff function. Code:
View Replies
View Related
I have a file i created
it contains several functions, and some other code to build a string based on diffrent vars.If i run this file standalone, it works absolutly fine. However the problem comes when i include it half way in another script.
I get the following..
VBScript Error 800a03ea
test4.asp, line 2 function encr..
This is line 2
Function Encrypt(Message, EncryptionKey)
View Replies
View Related
I am searching for a function that can separate a string var to some string vars and devide the string by "," marks, os this possible?
example:
str1 = "2,34,1,54"
and I want "2","34","1" and "54" be devided and inserted into new vars, or an array var, is their a VBscript function for this?
I have made a function myself that does this using ths Instr and the Mid functions, but its quit messy and I don't wan't to have to insert it in every page I make, Any Ideas?
Another small thing, I want to learn how to use Classes in ASP, I don't know what to look for exactly, (vlince, I could use a link now...)
View Replies
View Related
<%= functionName(value1, value2) %>
Trying to call a function which returns the modulo of two numbers, can l simply whack the function name in and the value will be returned ?
View Replies
View Related
I've written the following function but somehow the output is not what I want it to be. Can someone explain to me what i'm doing wrong?
function fn_piping(inputWaarde)
outputwaarde = inputwaarde
Response.Write outputwaarde & "<BR>"
if i = 1 then
i = 2
call fn_piping("thisshouldbethefinaloutput")
else
fn_piping = outputwaarde
end if
end function
i = 1
figure = fn_piping("bla")
Response.Write "<BR>" & figure
So 'thisshouldbethefinaloutput' should be the final output, but it doesn't output anything?!
View Replies
View Related
I need a current record in the database for it to work but I have another page that uses this same code and it works fine on that and the only thing different in the coding is where the information is being pulled from in the database and when i first copied & edited the page it worked fine but now it doesn't and i've worked on it .....
View Replies
View Related
I would like to call a asp function when i click a button in a form. I'm using VB. I know in Javascript it the onclick event is there a similar handler in VB????
View Replies
View Related
Where's the best place for me to include all my functions that I want to call throughout different pages? Should I just put them all in one ASP file and include that page on every page? Or use global.asa somehow (how??)?
Anyways, I was just wondering because I didn't want to slow things down if I could help it (I didn't know if having another big file attached to every page when I'm just using a small portion of it was very effective or not)
View Replies
View Related
Over my years developing ASP applications and writing asp code in general I have created a library of nice little apps and functions that I use over and over again.
I was "thinking" about maybey setting up a site with all my useful functions, subroutines, and possibly applications for people to download and hopefully donate some money if they use them. Perhaps even have some apps for sale only.
The apps will mainly be my useful plugin developments such as guestbook, gallery, login system etc. My question however is do you think it would be worth the time and effort? Do you find yourself using plugins a lot?
I defo think the functions could be handy but again how many of you search for functions to help you out or indeed how many of you currently use functions you have gotten from other people? Would you donate something if you used them?
Mayby some of you have already done something like this and can let me know how you got on?
View Replies
View Related
Didn't remember if anybody had started started like this, but I decided it would be cool to start it again. If you have a math function request ask it below, or if you have made one then add it:
I have a few cretegean plane (think thats how you spell it), calculations. One request I have is, does anybody have a short function for square root?
View Replies
View Related
I have some code I am working on. One function reads a file using fso, then
I have multiple functions using the string read from the file. Each
function splits the lines up and will return one value.
Is there a better way? Is handling this many array which are basically the
same going to cause some server distress
View Replies
View Related
I know there is the function IsNumeric() in ASP and we have a SUM function in SQL, but why don't we have the following functions in ASP:
Code:
Sum()
IsAlphabetic()
View Replies
View Related
I have been developping a webpage in ASP for about 4 weeks now and I have noticed that I am rewriting similar functions in pretty much every page i make. So I was wondering if there is a way to make some particular functions global so that you can use them in any page. The functions will depend on the session id, but I don't know if i can declare session functions or not.
View Replies
View Related
In this function i pass variables to it to find out if a record exists, what i want to do next is call this function and if a record does not exist pass a variable out like Statement = False and then pick up that value on the page that i call the function.
Can this be done? I was thinking perhaps using a Session? Code:
View Replies
View Related
I'm a PHP programmer. That said, I recently began a job where a good third to half of the applications are written in ASP.NET. VBScript, to be precise. As I've done programming for years (C/C++, PHP, JavaScript, BASIC... the list goes on and on), picking this up hasn't been too difficult, but I now find myself facing a question that I simply cannot find an answer to anywhere:
Can one define a function that has optional parameters in VBScipt?
If not, can it be done in C#, and can C# code be easily integrated into pages written in VBScript?
View Replies
View Related
I have written a very complex web app for intranet use. It allows users to search a large database and then returns formatted results. I am currently employing a method as below: Code:
View Replies
View Related
I have a function called GetRS which takes in a SQL string and returns a recordset object. Does this mean that a copy of the recordset is returned or is it passed by reference?Obviously this could have a large impact on performance for large recordsets.
View Replies
View Related
There is a chapter on SUBROUTINES, FUNCTIONS AND INCLUDES.what is the difference between SUBROUTINES and FUNCTIONS. If not mistaken, in VB, the SUBROUTINES return no value, but FUNCTIONS do have return value.Variable in ASP: global versus local.variable not in betweeb function is Global (what about subrountine, is it the same) and variable in between function is local, am I right?
View Replies
View Related
I've got a page displayin a CV and want to have two buttons, one to display the page in printable format and show the print dialog box and the other as a Save As button to show the save as dialog box. does anyone know the two javascript functions.
View Replies
View Related
I have a form that collects the following article information:
title (input type TEXT)
publication date (input type TEXT)
source (input type TEXT)
article text (TEXTAREA)
When I put something like the following sentence into the text area, it's screwy):
The dog's were the perfect "matched" perfectly. I'm using SQL Server 2000. how I would use replace functions to:
1. insert that into the db without errors
2. extract the information with single quotes and double quotes like it should be read.
View Replies
View Related
I am getting into using functions and am trying to design generic functions which i can use throughout my site. Is is possible to store a + or - inside a variable so that i can make my function cope with subtraction and addition?
View Replies
View Related
I have a page that has 5 different functions, each function has it's own recordset and database connection object variable like this: Code:
for function 1
objRs1
objCn1
for function 2
objRs2
objCn2
etc...
is this even necessary? Do I need separate variables like this inside the function?
View Replies
View Related
i'm starting at ASP now and I'm searching some information about it. For example, I need to know all about Application object. Some oficial documentation where I can find it?
View Replies
View Related
Does AnyBody know how to run windows functions in ASP? I want to run the function GetSystemMetrics From ASP and i don't know how i can do it. in VB i know to how to declare windows functions and how to use them, but in asp the script didn't work.
View Replies
View Related
