if I have a list of items which I have to complete next month on different dates, how do I select all the items due for next month, or all items due for the following month. Example:
Task 1 due 15/11/2004
Task 2 due 17/11/2004
Task 3 due 18/12/2004
I want to get back:
Tasks Due for November
Task 1
Task 2
I want to allow the users to shedule a particular task (shedule the time and date of inserting thier forms and data into the table ) such that i ll provide a simple form where the user can enter his name , age , and some other details at the end of this form , there is field to enter the date and time of inserting those fields into the table in the database,so that data inside this form will be inserted into the table as per the user scheduled date and time
View Replies View Relatedi need to send e-mail notification when the date + time comes! date+time are stored in db i can compare the values with the current date+time i have written an ASP web page which does all this (comparing date+time and sending e-mail notification) but i will need a visitor every second to execute the asp web page by visiting it! Code:
View Replies View RelatedWhat is the cause of that "[Microsoft][ODBC Microsoft Access Driver] Too many client tasks" error? I'm having a trouble listing posts from my database and giving me such output. Is there a limit in number of simultaneous user who can connect in the database? Or is it the server that's why it produced an error like that.
View Replies View RelatedI am designing an module to maintain tasks for me. Is it possible to have these tasks saved as tasks in Outlook as well via ASP code ?
View Replies View RelatedMy app lists jobs for a recruiter. He wants to track members who have
replied directly to job postings. So instead of simply making the client's
email address an <a href="mailto:...> link, I need to do 2 things:
- add a record of their posting to a database table
- open the email client to the job
Howe do I do this? The first part is easy, but I don't know how to open the
email client in an ASP command (I don't really want to auto-sed email, just
open the client and let the user attach their resume and add their cover
latter). Do I have to get my Web Hosting company to install CDO, or is that
standard with all IIS? I get an error when I try to run 'Set MailObj =
CreateObject("CDONTS.NewMail")'
if i want to perform the below sql update like every 10 mins when detected the hr:min:sec sessions started. And where should i put it in global.asa ? Session_onStart ?Code:
hrs=Session("Hr")
mins=Session("Min")
secs=Session("Sec")
strSQL = "UPDATE Attempts SET Hrs=" & Hours & ",Mins=" & Mins & ",Secs=" & Secs & " WHERE studentID ='" & Session("StudID") & "' AND Paper = '" & Session("Paper") & "'"
objConn.Execute (strSQL)
The project i am working on just now requires me to provide users with a link to download articles stored on the sites FTP server.This is not a problem to do, however, i also need to keep a record of who downloads what and when. I therefore have a downloads tablein my DB for storingthis info. The problem is, when the user clicks on the download link i need the document to be downloaded, AND a query to be executed to record the info into the DB table. I effectivley need the link to action these 2 eventssimultaneously!! Not sure if this is possible.
View Replies View RelatedIs there any way that I can for example, send an email After a file has been downloaded? Currently, it is setup so when they click to download a file...it sends an email...I am trying to figure out a way to have the email sent only have the download has completed.
View Replies View RelatedIs it possible to perform functions on a recordset (rather than on the
source database), e.g. COUNT, MAX etc
The reason I would like to do this is because I have a hugely complex view
which produces results with over 60 columns of data. I would like to display
all data but also highlight individual "cells" in the table which have the
highest (i.e. MAX) data for each column. I would also like totals at the
bottom of each column.
Obviously I could get the MAX value for each column by performing it on the
SQL data but that would effectively mean running the query twice and would
take twice as long.
how can i put the error messages in HTTP 500.100 - Internal Server Error - ASP error page in a nicer way so that it suits my web design.. ?
View Replies View Relatedsuggest me a asp page which can detach and attach databases. We can use the sp_detach_db, sp_attach_db.I am mainly into administration .As im not into much asp programming im finding it difficult. I dont have much time left to finish. help me with this.If any one have ready made asp page for this purpose ,he could give me the script
View Replies View Relatedi keep getting this error:
ADODB.Recordset error '800a0e7d'
The connection cannot be used to perform this operation. It is either closed or invalid in this context.
/rces/insert-script.asp, line 108
here is the code with the highlighted problem line
Code:
I have the belwo code which i mean to do an multiple checkbox insert. I have managed to get it so i puts all the checkbox values into a string seperated by a comma, and it insert into a database, however just not how i need it to.
Curently inserst like :-
I am performing a post from one classic ASP page to another in order to get the value of a string passed between the two pages. I have a client script variable declared to take the value of the value being received in the page i.e. var x = '<%=varName%>'. Unfortunately, ASP seems to be adding a carriage return to the value of varName when it
is passed in i.e. it expands the stated line to var x = 'FieldContents';. I.e. somewhere a carriage return has been added. The string gets passed in OK if I use the Get mechanism. Don't know why this carriage return is being added when using Post mechanism. Anybody seen this before? Is it a bug in ASP ?
I have two URLs. Static.htm and dynamic.asp
Static.htm
Contains a form with two text boxes, called text_1 and text_2 and some other info that is irrelevant for my question.
Dynamic.asp
Need some code to check that the text boxes only contain values greater than 0 and only numbers. Thus if any of the textboxes for example contain -3 or the letter m I want to cancel the form submission and display some kind of error message.
How can I achieve that?
i have a website hosted with crystaltech which needs to send out reminder emails to customers on a day and time of their choosing. to do this i used the server sheduled tasks to call a page every hour which does a search checking for time and day that match and then loop thru the recordset sending out a CDONTS email to those records.
this would run fine for 12 - 15 hours and then the IIS would crash with the "Too many client tasks" error. this seemed strange as at most it would find one or 2 records matching the time. i presumed some error must be occuring (even though it was sending out emails correctly) and thus the recordset wasn't being closed correctly. Code:
I want to be able to log in a database any transactions my users perform. For example logging in, requesting a page, downloading a resource, logging out etc.
What is the most practical way to code this? I was thinking of trying to use an include file which would have a function to add a log in the database for each page on the site or when a particular action is performed.