Mail And Update MS Access Record At Same Time
I have a form on a website for logged-in customers to update their contact details, when the customer update their contact details it should update the record in the database and at the same time the updated contact details should be sent to me by email.
I'm not an expert in ASP 3.0 and therefor I'm using dreamweaver 8 to create asp pages(ASP 3.0 VB), but dreamweaver does not have such kind of fuction(server behavior) to do this and so I have to create this by hand.
Now I already have page with the form that updates the record in the database, and I also have another page that does the mailing(CDONTS), first it updates the record in the database and in dreamweaver I have set "after insert the record go to mail_processing.asp" , but this does not work.
I can only get one to work, either only update the record or only mail the form data.
How can I make it to update and mail at the same time?
View Replies
ADVERTISEMENT
I would like to indicate in my ASP page when the Access database was last updated.
View Replies
View Related
i just wanna know how to be able to update certain fields without touching the others
for example if the form has 3 fields
description, name and age....
if i wanted to update the database from these fields, but only update the description while leaving the ohters as they are, which means blank fields in form...
now if i do that on my form, it will clear other 2 fields in the database and only update the description... how can i fix that so that when there's blank fields in form in won't clear the data in database ?
View Replies
View Related
This is probably a easy answer for you guys. Just trying to find the easiest way to do this. I want to click on a link and update a field in a recordset, but don't want
to leave the current page.
HrngID is the link. I want to change the Canceled field from a 1 to 0 when clicking on the link . I know I can use a onclick event, but not sure if these is an easier way. Can I do like a onclick and run a SQL statement on one line?
View Replies
View Related
I am using Windows XP profesional and Access 2000 but are experiencing
problems updating or adding new records to my database with asp.
I have installed IIS 5.1 on my computer but also on my internet site I am
having problems to add a new rec. or update one.
The error message is something like:
< Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query. >
I get this message on my web site as well as when I try some new tests, with
other databases, on my local PC's IIS. Does anybody know what is wrong? It
used to work okay earlier on my web site?
View Replies
View Related
What I want to do is send an email (if the user has accepted to receive one of course) once the product page in my site gets updated.
This is how I thought of it. Once a user fills my form he will have a YES/NO email field in my access database, the date he was registered on and a number indicating the total number of products the moment he got registered.
Once the product number changes, I will perform a control on all users and send an email to those who fulfill the criteria
Hope that my idea is correct and can be done. But in what language should i write this thing? It should be integrated in my website or locally?
How can I make the script understand that my products have been updated thus triggering the email action? Should the control be set on a daily basis or something?
View Replies
View Related
i can add the record in first table but cant get it to do with the second one one of the field in the first table the "mktid" which is the primary and is a forgeiner key in the second table how can i have it insert or update in the second one Code:
View Replies
View Related
add/update a record in first table and 2nd i can add the record in first table but cant get it to do with the second one
one of the field in the first table the "mktid" which is the primary and is a forgeiner key in the second table how can i have it insert or update in the second one
addnew.html
Code:
View Replies
View Related
I have a table in the db and one field in the db is an email field various records can have the same email address in. When an email address changes from x to y I want to be able to change an email address x in every record in the table to y, how would I do this?
View Replies
View Related
ASP VB. I have 1 recordset where I pull the order in.
I have another that I pull in the on-hand qty.
I used a repeat region and now I have it working to display the new on-hand qty. Now I just need to update the recordset with the qty on hand.
View Replies
View Related
ok im trying to update a record.. i have my edit form working (i think) and now im just making the code to update that record..
im gettin this error tho
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. Code:
View Replies
View Related
I have to compare 2 tables: orderA and orderB, if the record exists in both table orderB and orderA, just do a update to the quantity field in orderB (add orderA.quantity to orderB.quantity). Otherwise a new record has to be insert into orderB.
Do I have to loop through the recordset of orderB, then use select statement to see whether the record exists in orderA or not, and determine whether to update/insert record? I am using Access database. I just afraid that looping through each record in recordset (maybe >=30 record each time) would make the transaction getting slow (or even hang??). Can I do this in one SQL statement?
View Replies
View Related
THinking that the reasone why it's not UPDATING all was because the the page holds 10 records at a time right? I tried blocking all the codes which have to do with pageing but it's not working. Can you show me what I missed (if that's the reason why it cannot UPDATE all at once)? Code:
View Replies
View Related
I have a .asp page that displays an HTML page: view_msg.asp
There is a link (anchor tag) on that page that when clicked, sends the user to another page. I would like to also execute a MySQL query when that link is clicked. The DB is already open and connected to the page. The current current tag looks like this:
<a href="view_messages.asp"><IMG SRC="example.gif"></a>
and the MySql command I want to send is:
UPDATE Messages SET `fromDisplay`="N" WHERE idMessage=" & idMsg "
In english: When someone clicks on the link I want to execute a MySQL command to set the field value to N... how do I do that?
I know this is a very rookie question - but I don't know enough about asp to know how to execute the command here the way I want. Do I have to turn the image/button into a <FORM> 'submit' button</FORM> and use a redirect? Or, would I use an ONLCKICK. What would the correct syntax be?
View Replies
View Related
i'm trying to figure out why i can not update a record if in the text box there is a ' anywhere in the field..
View Replies
View Related
I'm new to ASP so I'm using DWMX as a crutch. It created the db connection and recordset code for me and all I want to do is have the page update the db with the result of a variable.
In plain English, I'm trying to update a field called Score in the table quizOne with the results of the variable score where the username field matches the session variable MM_Username. The recordset is called update_score.
Based on other tutorials and forums, I tried this: ....
View Replies
View Related
how to Update Record On Page Load. I have one feild in my database that I want to subtract 1 from each time the page is loaded.
View Replies
View Related
I have never done this before however i'd like to know if anyone knows a way that I can UPDATE records in an SQL db with the Current Date and Time???
View Replies
View Related
I want to insert the element selected by the user from the drop down box in the DB(Access).Once the user hits submit i want it to insert this in the DB + i want to update one of the fields from True to False . how can i perform both these at the same time?
View Replies
View Related
I have made several Access-based CMSs but now I am using SQL Server. I can read the records but my first attempts at writing are resulting in new records (with new ID) but all the fields are null.
I am posting the data from a form to the same page and an if /then statement catches the flag in the URL and runs the update script below. All the field names are correct. Code:
View Replies
View Related
I need to alter a dremweaver Update Record function but am a bit lost with it. I basically need to take the values from 3 drop downs that let you selct the date (day, month year). I've written a variavble that adds these together to make a date:
JJ_theDate = Request.Form(selectDay) & "-" & Request.Form(selectMonth) & "-" & Request.Form(selectYear)
but have no idea how/where to slot this in with Dreamwevers code (below) that does the SQL update.. Code:
View Replies
View Related
I want to record the date and time that a record is created. I have two fields, dateSubmitted, timeSubmitted, of type short date and short time respectively. How do I store the current date and time in these variables? I have tried using the following but it doesn't work:
objRS("DateSubmitted") = date() 'add date to database
objRS("TimeSubmitted") = time() 'add time to database
View Replies
View Related
I'm a complete beginner when it comes to ASP (CF and PHP are my regulars) and am trying to help a friend out with a very basic form on his site. It's your standard issue "fill this out for more info" HTML form, which will be processed by an ASP script, and then spit out a "thank you" page at the end. The thank you page will not have to display any information about the request.
The entire form is working great, collecting the visitor's name, e-mail address, phone number, and info from some radio buttons. But we'd like to add an automatic time/date stamp so that when the form is submitted and then received by the site's owner at the other end via e-mail, it also shows the date and time it was sent. I imagine we'd use some sort of hidden field? I'm of course open to any ideas.
The format of a sample e-mail could then be:
Date/Time Submitted: 2003/04/26, 11:03 pm
Name: bob joe
E-mail: bob@joe.com
Phone Number: 000-000-0000
View Replies
View Related
I am trying to do the following
1. I have a Severity dropdown (1, 2, 3, 4 and 5) in my script
2. Date (dateref)(varchar)
3. time (timeref) (varchar)
I want to do this, but have no clue how to write the script to do it.
It must Automatically update date and time as per severity rating
a. Severity 1. Date to be same day, Time + 1hour
b. Severity 2. Date +1 day. Time to be current time
c. Severity 3. Date + 3 days. Time to be current time
d. Severity 4. Date + 5 days. Time to be current time
e Severity 5. Date and time to default blank.
If I select any severity, it must changed the time and date that is on the same form, and save it to the table.
View Replies
View Related
I have a main window which shows all records from a table. When a user clicks on "Edit" for a record, a popup showing information of the selected record is displayed.
The user then changes the information on the popup and clicks "OK" button which calls an ASP page to update that record in the table. Everything works with no problem up to this stage.
My problem start after the update process. I need to know how to close the popup and then refresh the main window showing the updated information....
View Replies
View Related
There's an access database on an iisserver and asp makes updates to it. The
database got moved to a newer server. The users used to be able to open the
database and use the asp pages at the same time. Now when the database is
open the asp pages won't update.
View Replies
View Related
I have an asp page in which I use the �time() function but that just gives the time at the moment the page is loaded. I need to reload/refresh the page once every second so the seconds increase by one continuously.
View Replies
View Related
I like to add email checking from another POP3 email sites as seen in mail services.
Is there any Script for POP mail Access in ASP?
View Replies
View Related
Can any help me on how to use ASP to access a mail server? I need to send an email from the web but i don't want to use "mailto" as the contents sent using "mailto" is messy.
View Replies
View Related
Here is my code:
Code:
Set cnn1 = Server.CreateObject("ADODB.Connection")
openStr = "driver={Microsoft Access Driver (*.mdb)};" & _
"dbq=" & Server.MapPath("fpdb/directory.mdb")
cnn1.Open openStr,"",""
Set rs = Server.CreateObject("ADODB.Recordset")
sql = "Update shops set image = " & img & " where shop = " & session("biz")
rs.Execute(sql)
rs.Close
Set rs = Nothing
cnn1.Close
Set cnn1 = Nothing
I get this error:
Object does not support Execute method
View Replies
View Related
posted before on this problem, still having troubles.basically I'm using a Command object to run an UPDATE query on an access DSN connection.This aint working unfortunately, coming back with error : THis operation must use an updateable query.
View Replies
View Related
I am trying to update a field in access using ASP and get the following error
ADODB.Recordseterror '800a0cb3'
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype. /saba/saba.asp, line 107 .here is the code
rsSaba.CursorType = adOpenDynamic
rsSaba.LockType = adLockOptimistic
rsSaba.ActiveConnection = SabaDBConn
sabaSql = "Select * from Saba"
rsSaba.Source = sabaSql
rsSaba.Open
rsSaba("UPDATED") ="1"
rsSaba.update
View Replies
View Related
This command worked prior to "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" now it won't.
db.execute("update faq set count=count+1 where faqid=" &
request.querystring("faqid"))
Count is a field name in FAQ table in MS Access DB.
View Replies
View Related
