I know I've seen a tutorial on this, but can't locate it. I have a form that I've written that submits into a SQL database. I'd like it to fire off a notification email as well when an entry is submitted. Can someone point me to a tutorial that explains how I can do this?
View RepliesIs there any way to check when a form is submitted?Sample code is welcomed.
View Replies View RelatedI added the RTE to enable text editing in a textbox. The editing box displays fine, but nothing is submited to the action url in the form object?
View Replies View RelatedI have form around a table. The form contains checkboxes for whihc elements are selected, and hidden fields listing the current value of the elements, and the line identifier for every line so I can tell precisely which subset of the table was visible to that person at that time.
I need to determine if a line that is not selected was prior to this submission. Something pseudocode-wise similar to:
If (Len(Request("DueDate-" & TheItem)) <> 0 ) AND (Request("DueDate").Contains(TheItem)) then
Where Request("DueDate-" & TheItem) contains the current value of the line (not blank since the entry has a length). The second part is what I have a problem with. Without manually looping through Request("DueDate") to do a search, I have no way to tell if Request("DueDate") (which contains a list of selected items) contains the line I am examining.
I am trying to total the value of some form fields I am referecing the form
field with an inner loop, I am having a little trouble because the amount of
fields returned is always different, how can I roll-up the total of the form
fields (request.form("subtotal_"& i)) to get one final figure? Code:
I have a form with textboxes,and a select option(country)..onchange of select
element,i reload the form because i hit database to get cities of country selected..
whatever info user has entered is being stored in session variables.
my problem..as the form gets submitted onchange event of select user is able to write in textboxes but this info does not get stored in session varibles(but info written in textboxes before select is used does get stored and i am able display again onload of the form). how can i tackle thisproblem.
I'm trying to insert mutiple records into my database when the form is submitted.. My form has 4 textfields; serial1, price1, serial2 and price2.
I would like to insert serial1 and price1 as one record, then serial2 and price2 as the second record. I know some sort of loop has to be used to achieve this but i'm new to this and I don't know what to do...
I tried to do it with dreamweaver but it does not seem possible and the dreamweaver code seems really complicated I've only been able to insert only the first row(serial1,price1).. since I only have 2 fixed rows I guess what I need to do is to get dreamweaver to do it twice in a loop. Code:
I am maintaining a list of members of my site in a database. All members have an expiry date column in a table which is in mm/dd/yyyy format. I want that every members should be emailed on the day of their expiry automatically. I dnt wanna search for members and then mail then manually or if I m out on vacation it should do the work for me.
I have heard this can be done using triggers, but not sure how to use it.
Can u help me? also is there any other way apart from using triggers?
My requirement is to trigger an exe in the client. Once I click a button it should trigger an exe in the client machine itself. Any way of achieving this?
View Replies View RelatedIs there a way I can call VB.net code from a stored procedure? I need to schedule a sql job (stored procedure) and in the logic of the stored procedure, I need to call vb.net code to generate a pdf document.
View Replies View RelatedI am having a problem formatting an email message which comes from a form.
I am currently having difficulty with the <br> tag which I am using for line spaces within my email. I am getting an expected statement error message which is pointing to the line which is underlined below. I can't think what is causing this.
The code for my processing page is below:-
i wan to do a page at the backend,when the date is end of this year(12/31/2007) then will execute the code (such as add the new total leave with the current balance leave automatically without regresh the page or login into the system.)
i heard that the MS SQL SERVER got this triggered function, but unfortunately..the MS SQL SERVER hosting that i used(third party) didnt provide this function. i jz can store data in the table and create database..no more others component that i can use.
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.
Just starting to play with scripts, and need a little guidance. I want to check to make sure that the email addresses users enter in a form are identical before it will allow them to submit. here's what i have:
the variable for the second email address is EmailFrom2
'validation
Dim validationOK
validationOK=true
If (Trim(EmailFrom)="") Then validationOK=false
If (validationOK=false) Then Response.Redirect("emailerror.htm?" & EmailFrom)
If (Trim(Name)="") Then validationOK=false
If (validationOK=false) Then Response.Redirect("nameerror.htm?")
If (Trim(CityState)="") Then validationOK=false
If (validationOK=false) Then Response.Redirect("citystateerror.htm?")
If (Trim(SchoolName)="") Then validationOK=false
If (validationOK=false) Then Response.Redirect("schoolnameerror.htm?")
here is the script i use:
Set myMail=server.CreateObject("CDO.Message")
myMail.Subject="subject"
myMail.From="me"
myMail.To=request.form("email")
myMail.TextBody="hello"
myMail.Send
set myMail=nothing
this script sends emails to some addresses but not others--and its based on the email service it's sending to. for instance, hotmail email addresses get the email, but mail.com email addresses dont get the email. i have tried sending it to other email hosts, too, and still, some work, some don't. what is going on here?
I made a Ventrilo Status script which basically when the user hits the page for the first time it initiates a batch file which triggers the creation of a text file in the wwwroot: Code:
View Replies View RelatedWe have a solution where we want to control the number of users logged
in at the same time.
So when the user log in we check number of currentusers agains
allowedusers and increment a currentusers (in the database).
On Session_onEnd or when a user logout (actually I abandon the session
on logout) we decrease currentusers.
But as we all know when the browser is closed or the user just go to
another site this decrease does not appear.
It will of course trigger when Session goes to timeout, but I imagine
a lot of angry users calling support when they are denied access.
I have an user.asp page(has html display) which displays
the controls; After client-side validations, I do a
document.form.submit() to a process asp page(no html, only
server side processing and then redirects to the user.asp).
This process asp calls some dll functions which might take
a couple of hours if number of records to process is huge.
Now, the dll opens a pop-up window which shows the status
of the results(number of records processed and failed).
After exactly 1 hour, the user.asp page says page cannot
be found. Is it due to some timeout or something? What
could be the reason?
I have a form that I need to have the information sent to a fax machine when somebody submits it. Can I do this from my website and if so, how?
Im having problems with my form, separately both forms work perfectly, but having problem sending the email once submitted, however the upload fuction is working fine. The message im getting is,
Request object error 'ASP 0207 : 80004005'
Cannot use Request.Form
/forminfo.asp, line 42
Cannot use Request.Form collection after calling BinaryRead.
Heres the script Code:
Would anyone be able to give some guideance in ASP code as to how I would repeat a section of input fields in a form based upon the number of guests that are attending an event?
Basically, what needs to happen is if 3 guests are attending, I need the Name, address, city, state fields to repeat so they can be filled in with information.
Then all of the information from the whole form is submitted which returns an email to the administrator of the event.
<%@Language=VBScript %>
<%option explicit%>
<%
MESSAGE = (Request.Form("type"))
MESSAGE=MESSAGE & vbcrlf & "Name" & (Request.Form("name"))
MESSAGE=MESSAGE & vbcrlf & (Request.Form("address"))
MESSAGE=MESSAGE & vbcrlf & (Request.Form("handphone"))
MESSAGE=MESSAGE & vbcrlf & (Request.Form("phonenumber"))
MESSAGE=MESSAGE & vbcrlf & vbcrlf & (Request.Form("comments"))
MESSAGE=MESSAGE & vbcrlf & vbcrlf
MESSAGE=MESSAGE & "____________________________________________"
Set objMail = Server.CreateObject("CDONTS.NewMail")
objMail.From =Request.Form(email)
objMail.To = "icepricessa@hotmail.com"
objMail.Subject = "Business/Career Enquiries"
objMail.Body = ""&MESSAGE&""
objMail.Send
Set objMail = Nothing
%>
but somehow i'm not able to send the mail....
Does anyone have a suggestion how I could debug this
problem:
1. Data is collected from database and displayed in a form.
2. User updates data and submits it.
3. Submitted data is compared with old data.
4. SQL is generated for changes and put into an array.
5. SQL in the array is executed line by line.
I've copied the code which does the update from a working
page that does something similar. And tested it with a
basic update to be sure. But for some reason when I
submit this sql:
update table set currency = 'USD' where currency = 'GBP'
and company = 'LQ' and supplier_id = 'BCX0926' and
invoice_no = '654664432'
IIS hangs and the browser displays a blank white page. At
this point the whole site becomes unusable until I restart
the IIS Admin service.
I've pasted the sql into Toad and tested it there and it
works fine. Could anyone suggest what the problem is, or
how I could go about debugging it. Normally when I get
errors thet are written to the screen. But in this case,
I dont get anything back at all. Code:
What I want to do is create some code in a variable, then execute the variable, sorta like this code:Code:
<%
Code:
code = "response.write ('bla')"execute(code)%>
Except I want something that works (that code is conceptual)anyone have any idea's ?
Say I retrieve and e-mail adress from a form like this, then I know how to check that it's not empty, contain numbers etc. but I don't know how to check that the e-mail complies with some kind of regular expression or the like.
Therefore I wonder if you have any good e-mail form validation code that can be used on the server side (comparable to Java Script reg.exp on the client side).
<%
Dim mail
mail = request.form("email")
IF mail = "" or mail does not complain with some kind of reg. exp THEN
some code....
End IF
I have a page where a user can submit a record for a new "applicant". After the user clicks Submit, I would like to send the user to a new page containg the "Applicant Number" which the user will need.
The applicant number is simply the autonumbering of the record in the table which is in a SQL Server db. How do I capture the record number(primary key) of the newly entered record in the table and send it to my new page?
I am looking for the best way to capture the time spent on a page and then write that to a txt file sitting on a server when the form is submitted. Right now I capture the time spent using javascript... I know i cannot write to a file using this. I am not looking to learn any in-depth ASP stuff... just looking for a simple solution if at all possible.
View Replies View Relatedi want to create an email form in ASP that can send emails to one and if possible multiple email addresses.
1. what requirements do i need. ie. web hosting .etc
Is it possible to make a form with a dropdown box for the different email addresses?
does anyone know where i can download a copy of something like this or have a copy themselves?
It can be just a simple type in your name, comments and submit form. just anything that works and how i get it to work.
Does any one have working or sample scripts that will retrieve a form information and send that information to a specified email account? eg. a data request or a user comment form.
View Replies View Related<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<%
Option Explicit
Response.Expires = 0
'you need to set up a variable (declare variables) for each filed fron your form page
' what I like to do is use the exact same name and add str for string to the beginning of it.
Dim strFirstName
Dim strLastName
Dim strAddress1
Dim strAddress2
Dim strCity
Dim strState
Dim strZip
Dim strEmail
' After you declare the variables you need to assign a value to each one.
' each variable will be assign the corresponding value being sent from the form
'If you need other form fields, declare them above and assign a value here, Just
'follow the same format......
We run a small web ministry.
Our hosting company doesn't allow PERL, only Bamboo.SMTP and JMail asp's. (myhosting.com)
Our need? Turn the prayer request forms to an email that can
1. either send a different email to the requestor OR BCC an autoresponder we can set up.
2. BCC an email exploder on our mail system
3. make the FROM the requestor (done) and the TO: a 3rd email name on our system.
I see someone asked about a BCC function on Bamboo (none found), but the JMAIL set up we put up successfully executes but no emails are sent.
I have a form when the end user hits submit it will go to email and database. What I am looking to do is if the user selects this particular checkbox it will go to both database and email. Otherwise it will just to the database. In the form below I am expecting the user to check the "sendback" checkbox if they want to send the email, if this checkbox is left blank it will simply add a new record in the database. See code below...
form.html....
I am trying to create a form where when you click on the submit button, all the information in the form will be sent to the company email. And another form which content the thank you message will be sent to the client email. While doing i have successfully sent the message to both parties email. However, for both email there is no information written inside. Below is the code.....
View Replies View Related