Perform Detach And Attach Db
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
View Replies
ADVERTISEMENT
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)
View Replies
View Related
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 Related
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.
View Replies
View Related
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
View Replies
View Related
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.
View Replies
View Related
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 Related
i 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:
View Replies
View Related
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 :-
View Replies
View Related
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 ?
View Replies
View Related
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?
View Replies
View Related
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>
View Replies
View Related
I have created an asp page in which i need to attach photos and have to e-mail the asp page to other. How to attach photos to the page.
View Replies
View Related
How do you send a link to a Web page within an e-mail message which was sent using a send_mail function(consisting of the object CDO.Message)?
View Replies
View Related
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:
View Replies
View Related
See the ASP code below in order to send an email. How can I attach
a file to this email please?
set objMailer = Server.CreateObject("CDONTS.Newmail")
objMailer.From = "anySender@123.com"
objMailer.To = "anyRecipient@456.com"
objMailer.Subject = "a Subject"
objMailer.Body = “I need to know ASP�
on error resume next
objMailer.Send
if err then
response.Write err.Description
else
'do nothing it went okay
end if
View Replies
View Related
I need to attach a label to each form element on an html form as I can not use the element names. For instance, my element is
<input name="DT_Ctl">
in the asp I use,
For Each FormElement in Request.Form
mail_body = mail_body & FormElement & ": " & Request.Form(FormElement) & vbCrLf
Next
However this means I would get,
DT_Ctl: 1
in my email.
I need to re-label the element without changing the element name so that I would get something like,
Daytona: 1
I am guessing I could attach some sort of variable to each form element but how do I do that.
View Replies
View Related
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.
using chilisoft 3.6.2 / Linux / apache
View Replies
View Related
Is it possible to send an HTML email through CDONTS without formatting it
into one big long string?
View Replies
View Related
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) ....
View Replies
View Related
how to i attach the following codes to the email?
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")
View Replies
View Related
I'm trying to get my users to attach a local file to the mail they sending me from my page.
My form code is: ....
View Replies
View Related
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?
View Replies
View Related
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:
View Replies
View Related
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.
Here is my form page: Code:
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
Basically, i'm finding sample ASP or VBScript for accessing emails and downloading attachments....
View Replies
View Related
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....
View Replies
View Related
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.
View Replies
View Related