I could sure use some conceptualization and query help with a Page Watch
System I am building in Access 2000 and Asp.
I need to cycle through databae and generate a compiliation query email that
notifies a person of yacht(s) that have changed on our website:
Key database tables.....
I have a form where public can fill in information and submitted into an access database, like the following:
Set adocon = Server.CreateObject("ADODB.Connection")
adocon.Open "dbcmpda"
Set rsaddcomments = server.CreateObject("ADODB.recordset")
str = "SELECT * FROM plaint; "
rsaddcomments.cursortype = 2
rsaddcomments.locktype = 3
rsaddcomments.open str, adocon
if request.form("comment") <> "" then
rsaddcomments.addnew
rsaddcomments.fields("comment") = request.form("comment")
rsaddcomments.fields("fname") = request.form("fname")
rsaddcomments.fields("lname") = request.form("lname")
rsaddcomments.fields("add") = request.form("add")
rsaddcomments.fields("email") = request.form("email")
rsaddcomments.fields("home") = request.form("home")
rsaddcomments.fields("mobile") = request.form("mobile")
rsaddcomments.fields("date_c") = date()
rsaddcomments.fields("time_c") = time()
rsaddcomments.fields("lawenf") = request.form("law")
rsaddcomments.fields("ptype") = request.form("ptype")
rsaddcomments.fields("fee") = request.form("fee")
rsaddcomments.fields("occur") = request.form("occur")
rsaddcomments.fields("site") = request.form("site")
rsaddcomments.fields("city") = request.form("city")
rsaddcomments.fields("province") = request.form("province")
rsaddcomments.fields("stadr") = request.form("stadr")
rsaddcomments.fields("countryoc") = request.form("countryoc")
rsaddcomments.update
rsaddcomments.close
set rsaddcomments = nothing
set adocon = nothing
comm = ("Thank you for reporting piracy.")
My question is instead of putting these fields into an online database, can we send them as an e-mail in a text format delimited by semicolon and then import them into a local databse for security purposes ??? and if i can could give me an example how?
how can i add on email notification when an ASP form is submitted.
View Replies View RelatedIs it possible for one to program one's pages as such that when a database table is updated over the web, via a form, that an e-mail confirmation is sent to a specified address, notifying the update has taken place? If so is there a tutorial out there that is easy to understand and implement?
View Replies View RelatedI have a form (it's a .asp page) that people fill out to receive a free brochure. The form results are sent to a database (mdb).This is what I want to do. I want to be notified by email everytime someone fills out the form. I also want to be able to use an auto-responder and send an automatic message to the person that filled out the form.
In the future, I would like to be able to have the people be automatically signed up for the newsletter (with the option of not be added to the newsletter).
I am using ASP/MS ACCESS to see how I can query the same database, via 2 formfields.
{name: - search}Textfield 1: - Search by Category
AND/OR By
{name: - searchT}Textfield 2: - Location
Currently,
strSearchwords = Trim(Request.QueryString("search")); where "search" is the name of Textfield1
Which is fine, but how can I set it so that on Submit, the string from search, and searchT are somehow joined together into one string?
I have created a database request page (wahooo - new to asp and it works)
and everything is great. Now I'm creating a second page and want to know if
I'm able to make two different queries on one page. I want to be able to
create one query that uses a Request.QueryString from a URL and then use one
of the returned values from that query to create another query on the same
page. I hope that make sense. Here is the database connection code:
What I have is multiple tables that I want to pull information from and display it on a html page. I want to select a name from a dropdown menu and then it will display the persons results. There are no foreign keys and I don't have access to modify the database so hopefully I can work out a way without needing to.
So I have a various tables say for example Monday, Tuesday, Wednesday etc then they all have fields for example Monday will have mon1, mon2, monUsername and Tuesday will have tue1, tue2, tueUsername. (hope that makes sense!) The MonUsername and TueUsername will always have the same name. Code:
I'm trying to get results from a number of areas via one command string.for example ?location=devon retrieves everything in devon but I've only got a link for the whole south west so I need to send ?location=devon or cornwall or dorset etc. altogether.Is there a way I can do this without changing the asp page or do I have to only search one field at a time.
View Replies View RelatedI have an ASP page where I want to display the 3 most recent records within a database using a SQL query. The problem is that my page which output the results is only showing the first most recent record and not the two past ones aswell.
Am I right in thinking that might be related to the 'loop' function? I know that my SQL code is fine as I have previewed the results from the code and they are correct. Code:
I am wondering if it's possible to simulate the Multiple Document Interface
in ASP/ASP.NET webpages? Maybe using DIV layers? I am trying to create the
little document windows in an application, but in a webpage. I need
dragging, overlap, focusing, resizing capabilites. Also must be able to
encapsulate another DIV layer within this DIV layer. Is this possible?
Does anyone know a library (already-made) div/layer MDI windows for
webpages?
I have taken over a website that was done in Frontpage and I am trying to move away from it. I am having problems with page 1 where I have a link that passes a single value to page 2 in the query string.
On page 2 I want to use that value in the query string to produce mulitple record sets. This actually works when using the fpblib.inc. Is there a way of doing this without having to use Frontpage coding.
I have a page.asp?ID=xyz which redirects to releavant page and works if page exists but gives an error if not a valid page. How do I get it to redirect to an error message page being more user friendly?
View Replies View RelatedIs it possible for IIS to send some sort of notification when an ASP
error occurs on a page?
I can see them in the web logs, but I was wondering if there was a way
to receive an email or some other alert
I thought about using CDO Send Mail, but this object is often what
cause the error in the first place.
I am looking to build a desktop based notification tool which can be placed at tray bar. Well I have an asp script which checks my emails now I want to build a notification tool so that whenever I receive any new email the notification tool pop up a message at tray bar and show me that New email received.
View Replies View Relatedthe script works but i wanna have this email to be sent to more than one recipient (see below code in red). I did add another ObjMail1.To tag for another email recipient but doesnt work.
<%Response.Buffer=True%>
<html>
<head>
<title>Thanks</title><%
Dim salutationname,salutation,t1name,t1,t2name,t2,t3na me,t3,t4name,t4,highqualificationname,highqualific ation,checkname,check,MyNewRandomNum
Randomize
MyNewRandomNum = Round(Rnd * 100000000000)+1
salutationname = "Salutation"
salutation = Request.Form("salutation")
t1name = "Name"
t1 = Request.Form("t1")
t2name = "Telephone number"
t2 = Request.Form("t2")
t3name = "Email"
t3 = Request.Form("t3")
t4name = "Age"
t4 = Request.Form("t4")
highqualificationname = "Qualifications"
highqualification = Request.Form("highqualification")
checkname = "Options"
check = Request.Form("check")
Dim stname,st
stname = "Comments"
st = Request.Form("s1")
Dim ObjMail1,ObjMail2
Set ObjMail1 = Server.CreateObject("CDONTS.NewMail")
'CHANGE THE EMAIL ADDRESS IN QUOTES BELOW TO THE ADDRESS YOU WANT THIS MAIL SENT
ObjMail1.To = "info@abc.com "
ObjMail1.From = t3
ObjMail1.Subject = "Enquiry"& "" & "QUEUE NO: " &Trim(MyNewRandomNum)& ""
ObjMail1.Body = t1name & vbcrlf&_
t1 & vbcrlf&_
t2name & vbcrlf&_
t2 & vbcrlf&_
t3name & vbcrlf&_
t3 & vbcrlf&_
t4name & vbcrlf&_
t4 & vbcrlf&_
highqualificationname & vbcrlf&_
highqualification & vbcrlf&_
checkname & vbcrlf&_
check
ObjMail1.Send
Set ObjMail1 = Nothing
Set ObjMail2 = Server.CreateObject("CDONTS.NewMail")
ObjMail2.To = t3
ObjMail2.From = "info@abc.com"
ObjMail2.Subject = "Thanks for your enquiry."& "" & "Your QUEUE NO: " &Trim(MyNewRandomNum)& ""
ObjMail2.Body = " Hello " &"" & t1 & ".You have submitted your enquiry to us. You will hear from us shortly. " & "" & ":" & st &""
ObjMail2.Send
Set ObjMail2 = Nothing
Response.Write"<center />Thank You.You will hear from us soon. "
%>
</head>
</html>
I'm sending mail using below code. It works fine. How can I send email to more than one address. I wanna add one more address in .to feld or in .cc
Set cdoMessage = Server.CreateObject("CDO.Message")
With cdoMessage
Set .Configuration = cdoConfig
.From = "abc@abc.com"
.To = "xyz@xyz.com"
.Subject = "abc"
.HtmLBody = body
.Send
End With
Is it possible to notify your website when you log in to messenger?The idea is to show on the website which site opperators are available on the messenger services for a IM question and answer session.We has a rudementary chat option as an idea but many of the site opperators are on mobile devices.
View Replies View RelatedUsing ASP and/or JavaScript, how do you create that little
notification message (usually in red below the submit button) when the
Submit button is pushed. Something that says "Your information is
being sent ..."
I have an html page with standard contact us type form. This when posted goes to an asp page which stores the data and then sends an email to me. It then redirects back to the original email form with a message thanking the user for the contact.
The problem is I am getting multiple spoof emails which are being generated form the asp page. Some one is accessing and then just refershing the page so it generates numerous emails.
Is there a way of either hiding the asp page in the original HTML form or checking that the page has been called by the html form rather than just refreshed.
i've finally integrated a way to send multiple attachemts from within an asp page and it works!!!!!
View Replies View RelatedJust want to confirm if you can add multiple attachments like this? Code:
Mail.Host="test@yahoo.com
Mail.FromName="test@yahoo.co.uk"
Mail.AddAttachment "C: est.doc"
Mail.AddAttachment "C: est2.doc"
I'm trying to send an email (jmail) to everyone in a recordset but I'm getting no joy,I keep getting a "not all servers received message" error or something similar, can someone please take a look at this code and see if they can spot my glaring errors ?
<%
set rsetReminder = Server.CreateObject("ADODB.Recordset")
rsetReminder.ActiveConnection = MM_connmessages2_STRING
rsetReminder.Source = "SELECT * FROM accessgroups WHERE ((accessgroups.fldjoined<Date()-14)) AND fldGroup = 'Guest' ORDER BY fldjoined DESC"
rsetReminder.CursorType = 0
rsetReminder.CursorLocation = 2
rsetReminder.LockType = 3
rsetReminder.Open()
rsetReminder_numRows = 0
%>
<%
While NOT rsetReminder.EOF
firstname = rsetReminder.Fields.Item("fldFirstname").Value
lastname = rsetReminder.Fields.Item("fldLastname").Value
emailadd = rsetReminder.Fields.Item("fldEmailAddress").Value
username = rsetReminder.Fields.Item("fldusername").Value
password = rsetReminder.Fields.Item("fldPassword").Value
usrid = rsetReminder.Fields.Item("fldnewuserid").Value
crlf=chr(13)+chr(10) .....
Here's the script I'm using now to send me a picture selected in a form (from a browse button type thing), sent to me in the attachments.
Right now it will only send the one picture (field name="Attachment"), how can I change this script to send multiple (for example; ten) pictures in the attachments from the form??
Here's the script...
I'm a PHP programmer who for some reason was tasked with fixing some code on an asp page. I have what I feel should work, but I am getting this error:
CDO.Message.1 error '8004020c'
At least one recipient is required, but none were found.
/admin/mass_email_monthly.asp, line 47
Line 47 being this line: objMessage.Send
Now I want to have multiple recipients pulled from the database as illustrated in the code, but it isn't working. I have no idea why, and I have no idea what that error message means? Can anyone point me in the proper direction of a tutorial that can help? OR possibly show me where my syntax is wrong?
I am using this script to submit my form fields into the body of my email:
***********************************************
Dim strBody
dim ix, formElementName, formElementValue
strBody = "Results of form submitted at " & Now() & vbCrLf & CrLf
For ix = 1 to Request.Form.Count
formElementName = Request.Form.Key(ix)
formElementValue = Request.Form.Item(ix)
strBody = strBody & (formElementName & ": " & formElementValue & vbCrLf)
Next
***********************************************
I'm completely new to vbscript and have been searching all over the net for an example of this script being used with mutliple fields with absolutely no luck.
The closest I've come to getting something back from this thing is when I tested the script with these elements:
FormElementName = Request.Form.Key("Name")
formElementValue = Request.Form.Item("Name")
formElementName = Request.Form.Key("Telephone")
formElementValue = Request.Form.Item("Telephone")
formElementName = Request.Form.Key("Email")
formElementValue = Request.Form.Item("Email")
Which produced this result:
Email: Email
Email: Email
Email: Email
Its seems the answer to my problem lies in defining the 'Key' and possibly the 'Item' parameters but I haven't been able to find any documentation on these terms. Can someone out there please save me from what probably is a very simple solution?
I am attempting to send an HTML email which a hyperlink that will change based on the user's session ID. I need the hyperlink to display as:
http://www.synergeticsusa.net/admin/shop_cart/detail.asp?id=
WHERE the id = Session("MM_UserID")
However I cannot seem to code this into the html string in the correct syntax, to where id=1 or id=2, etc. Does anyone know the anwser to this problem?The basic code I am using can be found below.
html = html & "<a href=""http://www.synergeticsusa.net/admin/shop_cart/detail.asp?id="">"
html = html & Session("MM_UserID")
html = html & "<IMG SRC=""myImage2.gif""></A><BR><BR>"
html = html & "</br>"
My code retrieves a username and a password from a form. Then this information is compared to some usernames and passwords that are stored in a database. The important thing here is that the comparison must be case sensitive meaning that "passWord" is not the same thing as "password"
I have this code, working fine in access 2003
SQL = "SELECT * FROM users WHERE StrComp(username_column,'" & entered_username_in_form & "',0) = 0 AND StrComp(password_column,'" & entered_password_in_form & "',0) = 0"
but get the following error when I run it against my sql 2005 database.
[Microsoft][SQL Native Client][SQL Server]'StrComp' is not a recognized built-in function name.
I don't know the corresponding t-sql for the query.
Just as the title says I am trying to do something impossible with a single SQL statement. I am doing an ASP webpage for internal use at the company I work for.
I want to know if there is a way to insert/update data into multiple tables in 1 SQL statement.
If it requires functions | views or anything else that is fine but I don't want to have 3-4 different SQL statements to update 2-3 different columns in different tables.
I have a search option on my website, which should perform a search on 4 fields, as follows:
tblNews
headline
content
tblDatabank
filename
description
It only needs to return matches which are an exact match of their search criteria. For instance, searching for "I am here" would return a record which contained "I am here", but not just "I" or "I am" etc.
I need to return all these records as part of one recordset preferably, as I want to be able to order them etc., though I imagine you may suggest I use an array somehow to merge two recordets etc., then reorder them?
I am running a querry on an access database and have set the number of records/page displayed at 20. if there are more than 20 records returned, then 1st page will show the first 20, the next page will show next 20 and so on....
The trouble:
the count of total records displayed is correct and the first page is displayed correctly. But when i click on *Next* to go to the next page, all the records of the database get displayed (not the 2nd page of records from the query).
i hav problem with updating the data. In the asp page i hav displayed records based on search criteria. in display mode im displaying the to be updated field in combo box for each similar contract_no. each contract_no will hav different no of rows and to be updated combo box.
based on the selected value in the combo boxes of different contract_nos i hav to update the combo value with old value. user select multiple combo values at a time I need anybody's help with detailed programming logic.
Im running a simple mail system program which emails newsletters to a database list of 3000+ users.
The program loops through a database containing the emails and sends them out using ASPEmail.
My question is, is there some way i can validate each email address so that if there are invalid characters e.g. the space in "blah @blah.com"
it will skip the record and continue the loop.
At the moment i have a working program however, whenever the program comes across an invalid email address it stops at that record and prevents the program from emailing any further.