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 Repliesif 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 Relatedif 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
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.
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'm trying to connect to a sql server to write a record , but am getting no results.
See the attched file
I have a form with 3 combobox whitin a asp page called data.asp, whose
action form is itself; the first combobox drives the behaviour of the other
two.The onchange event of the first combobox is related to a javascript function
in which I call the submit method for the form, whose action form is itself.
This works fine.
The problem is that if I want to save the changes done by the user (clicking
the OK button) I need to set the action of the form to another page, for
example save.asp.
The question is: how to do this?
I had written a function inside the onclick method of the OK button that is
similar to the following one
document.MyForm.action = "save.asp";
document.MyForm.submit();
im trying to get used to asp, as im abit of a php users really. anyway my problem is ive made a database connection and made an update work. only thing is im wondering how one would test if the update was successful so can display to user that it was.
my query ends as
Code:
adoConn.Execute strQuery
so is there away to test if it was successful?.. so i can do if it was var = success else car = error
I have an ASP page with some form elements on it, as well as an inline frame
called 'body'.
Depending on element is selected when the form is submitted different ASP
pages appear in the inline frame.
<form Name=aSelect method=Get action=Test.asp target=body>
<Input type="radio" name="Radio" value=0)
Using this the line passed to the inline frame = Test.asp?Radio=0
I want to add a second inline frame to the page and have a different
page displayed in this. The page to be displayed needs to reference the
selection made in the form. Something like Otherpage.asp?Radio=0
is it possiable in run some automatic checkups on the server every X time or every time (with no reaction with the user). I need to run all the time checkups on the sql database and check values of some column.
View Replies View RelatedI have a system that i designed a while ago that is an online diary system. The way it works is that the users are given the option to click on any day of the month on the main diary screen. This then opens a second browser window using javscript to show the user all of the appointments in this day. All action are then done in this new window.
The proplem that i have is that once the action has been done, it is not highlighted on the main diary screen untill the page is refreshed. Is there any way that i can send a refresh comand back to the original brower screen from within the new javascript opened brower? I have a close window button on the js window so i didn't know if there was some way of adding a command to do it.
I have a form with dropdown boxes and a "Submit" button.These dropdown boxes get populated dynamically with user interaction, like this:
<form method="POST" name="form1" action="MyPage.asp">
<p><select size="1" name="Dropdown1" onchange=form1.submit()>
The "Submit" button is included within the same form.Is there a way to find out which item made the POST action.If it's the Submit button.i want to do this.If it's the dropdown boxes.then i want to do a different thing.
I have this form that updates a database when the submit button is pressed like this
Code:
If Request("submit")="Submit Hotline Form" Then
and I noticed that it works fine when I have the form itself as the action, but when I make another form the action for the form it doesnt update the database. Is there something wrong with my if? or is there a different way to do this? I wanted the second page to display info from the database as values in the input type=text boxes.
Having a problem with a page being skipped in the cart. Intermitting problem here. Action code 38 then 47 when this occurs.
View Replies View Relatedhow I can create two different form actions.I'm currently creating a On-Line Order System for our company. I've created a page that displays what they have ordered and the option to update the number of item that would like on there order. so I need to create two different for actions.
What I looking to have is one button that would submit, one button that would update any changes? Two different action.the update button will call proorderbyline.asp the submit will call submitbyline.asp .
Anyone can help me to create a Text Formating. AS I want that there is a object. I want to write some text in a textbox on Run time. and it displays on the object and if i want to change his font,size or color.
so tell me how its possible. can i get tha code from anybody or from anysite or anyone plz me to do this in Flash with Action Scripting.
I have a form that appears in a popupwindow. I found a javascript code that allows me to return to the opener window onClick and it closes the popwindow. The problem is I tried to implement the code into my Form Action and I can't get it to work.
This is the original code:
onClick="return targetopener(this, true)
This is what I'm trying to do:
<form action='return targetopener(<%Response.Write("checkboxtrial2.asp?Model=" & Recordset("model") & "")%>, true)' name="formOptions" method="post">
Is there a way with ASP or Java to hide the form action part of a form? I have someone that has found the location of a script by looking at the source of one of my forms.
They run some type of script that trys to post bogus info from 6:00 in the morning till 12:00 in the afternoon. Although it gets denied due to wrong input by the user, it sends administrative emails that are annoying (hundreds). If the user only saw the client side (below), they could not do it. Is there a way? Code:
I have an asp page that outputs a word document. Wnen the user attempts to
open this page from a hyberlink in an email document the word document opens
fine but if they save then an action cancelled message appears in a browser
window. If you cut and paste this same link into IE and attempt to saves
there is no browser window opened.
If the user attempts to open instead of save the document it opens in a word
out side the browser. I am told this used to open up in word insdie the
browser.If you cut and paste the link into explorer and acess it from there
the word document is displayed in word inside the browser.
If I omit the content disposition header the word document opens inside a
browser no matter how it is opened however the save problem remains.
I do not want the browser window to remain open. Or if it must then I dont
want the ACTION Cacelled message. How can I control that
Is there any way to post two actions at different in a same form data with a single button click? I would like to use the following actions in the same form. But I can successfully use any of one below.
<form name="DeliveryDetails" method="post" onsubmit="return check(this);" action="ShowDeliveryDetails">
<form name="process" method="post" action="mail.pl">
Is it possible to have a form with TWO submit buttons that calls TWO DIFFERENT ACTIONS?
For example, at the end of the form, when SUBMIT1 is pressed, it goes to PAGE1.asp. if SUBMIT2 is pressed, it goes to PAGE2.asp. and whichever one it goes to, all form field values are sent to it?
i have a an access query on my db, and i want when i open the asp code .the action query run , but when i try to so it , by select *from actioguery ,it doesnt work, how to do this move?
View Replies View RelatedI want a form to submit to a different page depending on what selection has been made in a dropdown option box. However something is going wrong my code looks as follows: Code:
View Replies View RelatedCurrently i did 2 pages
form and action pages, where form will have 2 inputs, and action page will insert the data into database.
but the i have tested once i keep refresh the action page, the data will be inserted again and again, anyone know how can i control this matter and avoid sql injection?
What I want is for an action to be triggered when a user selects something on a dropdown box.
The something would actually be two variables. One 'static' in that the drop down would be 1, 2, 3, 4 the other being a variable in the true sense e.g. if selection A is 2 and selection B was 3 then the variable is 5 and this variable is the one I want to use to trigger events.
Using themes I could maybe do it but I am hoping there is a easier, more dynamic way to do it.
I have a dynamic dropdown list that has info brought in from my SQL database. Based on the user's selection, I want to create a message box that informs a user that an additional step must be taken first before the form can be submitted. For instance:
Drop down list contents -
Estimate
Repair
Maintenance
Renovation
New Build
If a user selects "New Build" from the dynamic drop down, a messgae box would appear to let the user know that they need to have a permission form filled out before they can submit the work order. Something to that affect. Can this be done based on a selection in the list or do I need to use check boxes instead.
I have a form with several submit buttons. Each one is different. For instance, one may require the next action window to be a pop up requesting more data. Another may require it to be normal. And of course I need the request data from the form. I tried not specifying the action on the form and put it on the the submit button via the OnClick but the request data was always behind and isn't current until after the submit.
I guess an easy way to think about it is say you have a tool bar and depending on which button you click it fires a different asp file but the current form data.