Automating A Daily Function
using classic asp and COMless scripting, is there a way for the asp on a server to automatically perform a function on a scheduled time, im thinking of things like database replication, clearing old data etc.
View Replies
ADVERTISEMENT
I am using asp for preparing mail merge sort of application. I have copied this code from my vb application. But it gives me the below error
Error Type:
Microsoft Word (0x800A239E)
Parameter value was out of acceptable range
/welcome/generatedocbak.asp, line 172
View Replies
View Related
I have an ASP application which includes an asp page which
processes a user submitted file. I would like to
automate the process so the server scans the directory
every 5 minutes and processes any files in the directory.
I would like to 'reuse' the existing logic in the asp
page.
How can I create a server process to do this?
The closest I can figure out is to hook the logic into a
application/session start logic in global.asa where it
would run everytime a new session was started, but I would
like it to run like a cron job every 5 minutes. Code:
View Replies
View Related
I am hosting a website on Windows 2003 server, IS6, MS SQL Server. I
have one ASP file I would like to run daily. How can I do it if I do
not have acces to OS's management (to use, for example, task scheduler)
and I do not want to include this page within other pages of the
website to be run (because that may slow down the page loading for
users)?
View Replies
View Related
I need to come with some ASP code that can select a new record out of the database as a sort of "tip of the day". However I want it to do this randomly and daily, I do not wish to have to set a display date or whatever. I am going to use it on my website as a "tip of the day" section however I want to be able to input 100 records at one time and just let it randomly choose one everyday.
View Replies
View Related
I have an ASP page which checks some condition from database and based on that it sends mails to respective persons. All mail details is in SQL server. The page works perfectly fine.
What i need is this page has to be executed daily without the interaction of any user/administrator. Is it possible?
View Replies
View Related
I need no send birthday emails every day. I need something to check everyday on my database for birthdays, but I don't have any components to do that and I dont have rights to install it on my webserver.
Is there a way to do it without installing anything? Only through asp?
View Replies
View Related
What's the difference between private and public functions in ASP? When should I use either?
View Replies
View Related
I am using a simple guestbook /portal and i want script to send mail to the thread owner when someone reply his message.
this is the send message code ....
View Replies
View Related
Can I define a function inside a function. e.g;
function abc()
function xyz()
....some code.....
End Function
End Function
I googled this but can't find any related topic.
View Replies
View Related
I want to use the instr function, but return results from it depending on surtain functions, I can't realy explain so I'll show my example:
I have a string in wich some word I want to find might be in diffrent Capital Letters order, I want the Instr function to return all the values of the place of that word (avcourse I'll run a for and increase the starting point of the Instr func until it returns 0). The instinct thought is to use the Lcase or the Ucase functions, but in this case I don't know how to use them. In the same Idea I wanted to use the Instr Func with the trim Func, But Its realy the same principle if I just understood how to do so.
View Replies
View Related
I am trying to call a function in asp to check to see if a varibale has a value stored in it if there is nothing wite the value NA into it. My code is
<%
Function NullValues(userField)
if userField = "" then userField = "NA"
end function
AccountNo = ""
Name = "sam clowes"
email = ""
AccountNo = (NullValues(AccountNo))
Name = (NullValues(Name))
email = (NullValues(email))
response.Write AccountNo & "<br>"
response.Write Name & "<br>"
response.Write email & "<br>"
%>
When I run this code ALL the variables are blank and nothing is output
View Replies
View Related
the function
<%
Dim objXML, objXSL
Function ShowXML(strXML,strStyleSheet)
Set objXML = CreateObject("MSXML.DOMDocument")
Set objXSL = CreateObject("MSXML.DOMDocument")
objXML.load(Server.MapPath(strXML))
objXSL.load(Server.MapPath(strStyleSheet))
Response.Write objXML.transformNode(objXSL)
Set objXML = Nothing
Set objXSL = Nothing
End Function
%>
calling the function in an asp file
<%Call ShowXML("http://msn.foxsports.com/feedout/syndicatedContent?categoryId=142","nhl/xsl/news/teamNews.xsl")%>
the errors
1. the http:// part
2. and the ? mark
the error message says that the path has been typed wrong.
View Replies
View Related
the user can key in variable A and B
then C is auto generated by C = A / B
so how and where should i write the C function??
View Replies
View Related
Possibly a very simple question but how do I get a value out of an XML document so I can play with it in ASP
E.G: <Name>Tom</Name
How do I pull the work tom into asp
View Replies
View Related
I am using the now() function to be displayed on an email after a form submission has been sent. The problem is that the server is not in the same timezone as I am for the result. How do I adjust the hours on the now() to allow for this please ?
View Replies
View Related
I know the basic difference between a subroutine and a function is a
subroutine performs a task and a function performs a task and returns a
value. The Call keyword is required when using parens with subs with more
than 1 parameters. Parens around values passed are ByVal vs ByRef and is a
waste of processing if passed ByRef for no reason.
I am told there is no reason to ever use a subroutine as a function can be
used even if it doesn't return a value. While this appears to be true, is
there any reason why it's ever a bad idea to use a function, instead of a
subroutine, that doesn't return a value? Are there memory, performance,
etc. issues?
View Replies
View Related
I am trying to locate information on how to call a sub within VBScript on an
ASP page but I can't locate generic information. What I want to do is
generate a page that will stay up but the information on it will change
based on a series of drop down boxes. I need the first drop down box to call
a second dropped down box based on the state that is chosen then city and so
on.
View Replies
View Related
I have a column in the table which contains 2 full names seperated by "&" (e.g: Joe Smith & Jeff Scott) I want to display only the first names of the whole record in an asp page. Is there an asp function using which i can do this?
View Replies
View Related
im using the mod function to create a calendar for me, which everything works perfectly, all is totally well with that!
but...when i use the mod function it churns out this loooooooooong string which is the whole table...
if there is some way that i can insert hard breaks IN THE CODE ITSELF.
View Replies
View Related
I used to be quite an experienced ASP programmer but I haven't used it for a while
I’m trying to do something that I remember as very simple I'm trying to check that the value of a form text box is numerical using the isNaN function. The code I am using is:
<%
quantity = Request.Form("number1")
if isNaN(quantity) = true then
Response.Write "Your input was not a number"
else
Response.Write "Your input was a number"
end if
%>
All I get is a NaN type mismatch error.
View Replies
View Related
Is there a function to check to see if a string contains a space
Thanks
View Replies
View Related
I was just wondering when using the mid function how does the assigment work when the length is longer then string itself? For example
test = mid(12345, 1, 10)
What would be the end result of test?Would it be 0000012345 or 1234500000 or 12345?
View Replies
View Related
When I create a single character string
var str = "A"
'convert to ascii
num = asc(str)
Response.Write num ' 65 shows up
'when I have a whole string
str = "hello"
str = mid(str, 1, 1) ' return 'h'
num = asc(str)
'I get an error:
Invalid procedure call or argument:'asc'What can be done to fix this?
View Replies
View Related
I've an array to store alphabets, in my code...in a random order. How can i use the Asc() function to get the equivalent Ascii of each alaphabaet of that array....
whenever i use ,
for i = 0 to NoOfElements
Response.write Asc("ArrayName(i)")
next
it displays 65, "NOOfElements" times (ascii of A)...on the other hand..i can't write
Response.write Asc(ArrayName(i))
since this shows some error...How can i solve this?
View Replies
View Related
Depending on some situations, I or the user, need to execute a function (e.g., login, sending email, etc...) and then continue from the original place. How can I make one function to be available from any page from my site?
View Replies
View Related
I have a problem with max() function. The SQL is as follow SELECT max(group_no) as group_no FROM doc_groups. if I run the sql in MS SQL server, it will return correct result. However when I run in ASP file, there is no record return. I check with RecordCount property and it return -1.
View Replies
View Related
Does anyone know how to use the Excel PV Function in an asp page? Is it possible at all? I know how to use it in .Net but not in ASP.
View Replies
View Related
i need to write sql statment to compeare the first three letters btween input user and a field in a database, i used the Mid function but it seems there is something wrong ..
dim str1
str1= Mid((Form1.SiteName.value), 0, 2)
<% strSQL = "SELECT EQUIPMENT_ID FROM ne.equipment_view WHERE Mid([EQUIPMENT_ID], 0, 2) = '&str1&'" %>
by the way i use dropdown list for user input ....
View Replies
View Related
I need function that will recognize URL in some string. For ex. somebody in forum sends some text which is in variable TEXT. I want a function to look at it and if it finds www... , http://... or https:// - he has to change it into url link.
View Replies
View Related
in vbscript:
Int(11.4)=11
What function in JScript like this function?
View Replies
View Related
I'm getting error in Dir$ after run this code using IIS. Can anyone help me to solve this matter? Code:
If (Mobile1.MSGType = 2) And (Dir$(Mobile1.MSGPictureName) <> "") Then
Image1.Picture = LoadPicture(Mobile1.MSGPictureName)
Else
Image1.Picture = LoadPicture()
End If ..
View Replies
View Related
is there a vb function that I can use to copy chars 1, 3, 5, and 7 from a string of 7 chars?
View Replies
View Related