suggest 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
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:
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.
Is 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.
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
Is 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.
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.
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 ?
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.
I just coded a page and I'm getting an error on line 3, which is the attach line. According to the references I have, this is the correct way to do it. Am I missing something? Let me know what you think. Here's the code:
<% set ObjMail = CreateObject("CDONTS.NewMail") objMail.AttachFile "c: est.txt" objMail.Send "jondoe@somewhere.nett", "janedoe@somewhere.net", "Test Message 021203c", "Test with attachment" Set ObjMail = Nothing %> <html> <title>Mail Send Page/</title> <body> This page will send mail to an email address </body> </html>
I try to grab the checked files from HTML page and then send those PDF files as attachments. It can just send email, there are no PDF files attached. Can anybody point out my error?
My idea is: When people check the check boxes in HTML page for the PDF files, it will transfer the files' name to ASP page. Then, it will attach it in the email. Code:
I am an ASP guy who is developing using chilisoft at this moment. All is going very well except for using the fileAttach method (CDONTS), I am having great difficulty finding assistance.
The chilisoft documentation seems to lack an explanation of the file attach method, would you have any suggestions where I may see an example of the CDONTS file attach method.
I need to attach files and upload that file to an Access database as a BLOB(or any other way). i have created a DSN for the db and it is better if it uses a command object to connect to the db(even if it is not a command a object it doesnt matter) ....
a genAttachment function and Call genAttachemnt("Test1","24-08-2006","13:00:00","24-08-2006","14:00:00","Title","Location",0,0,1,1,"../eleave/","-PT1D",1,"PT7D",1,"WEEKLY",2,"TH")
I'm sending an email in ASP using CDONTS and I'm trying to attach a file from the user's machine (i.e. client side) and right now it works... BUT what im doing now is having the user upload the file and it is saved on the server in the temp directory, then once the email is sent, the file is deleted.
So here's the question... Is there a way to attach a file using only the file info and data - i.e. without saving the file to the server. I have a pure asp upload include file that will let me view a file's data in binray format and I was wondering how I could use this to attach the file.
So to reiterate, can I attach a file that is not saved on the server... any takers?
I’m writing about a form which processes another form from the which i send newsletters. There are two cases, cdo (plan text) and cdohtml and everyone of them should sand mail with attach, it debends by which case has been selected in the generale settings, stored in a msaccess database.
The strange is that the mail in plain text format (case cdo) is sent, with attach too, and NO ERRORS are encountered:
the html mail des not works, even if the process says (no errors) no mails reaches the recipients. Code:
I have a web form that collects data and passes it to a mailer.asp page that arranges the form data into an nice html table and then emails it using CDONTS.
The form works fine. Here's what I am trying to accomplish:
Based on which of the checkboxes are checked, that is who the email needs to go to.
I cannot figure out how to attach an email address to the specific checkboxes.
I would prefer to keep the email addy's in the asp so that the spambots dont take them.
I'm trying to build a page that the user can attach a file/s to and email them thru a form. I see plenty of info on how to actually code it to send with a variable - but how do you build a form that allows user go out and browse for a file? Then loads the path into a form?
I'm trying to get a file attached to an email from a form.
The form is a simple name, email, attach cv. When the user hits submit it gets sent to the company. I simply used the <input type="file"> for the user to browse.
I have created an asp form which I want to use to retrieve attachment from my site users. I am using Aspupload Component on sever to upload attach file on server at specific location. Although I am able to upload attach file on server. Also I created to retrieve attachment from mail its not working.
Can any one help me out to make form or code to retrieve uploaded file as attachment through mail.
Here is file where user fill his information and attach his CV....
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.