Mass Update Records
I just had a problem where I needed to update a bunch of records from a single form submission. I am sure there are lots of better ways to solve this, but I offer the code I came up with. Also I’m asking if there are any better ways.
The form page had a form in it with a table. Each row in the table had a database record in it. In each row, sat the input field titled “myOrder” and a hidden field called “myID”. The table was a repeat region, so that each field was populated dynamically from each record in the database. The number of records was dynamic in that they increased or decreased by the category the user was in.
The page submitted to my mass_update page.
Here is the relevant part of the code that took each “myID” and “myOrder” data and then updated the database record:...
View Replies
ADVERTISEMENT
I have a form with mutiple records. Each record has got 2 fields to update. How to update mutiple records at the same time??
View Replies
View Related
I want to make modifications to the first 10 records in my database. I know that I can do it quite easily with the RecordSet object, but for speed, I was wondering if I could use pure SLQ?
View Replies
View Related
how to update multiple records on one submit. Say for example i have number of records on a html table, user performs changes on some of the records, and hits the submit button at the end and all these value have to be updated into the sql query.
View Replies
View Related
How do I update multiple records in a table in ASP using loops ? For example.
I have a table with the following colums
ID | Col1 | Col2
-------------------------
1 | 50 | 100
2 | 25 | 130
3 | 55 | 70
I want to add *66* and *77* into the ID # *1* and ID # *3*
respectively. So the result should be
ID | Col1 | Col2
-------------------------
1 | 116 | 177
2 | 25 | 130
3 | 121 | 147
Note: All datatype of the colums are integer.
View Replies
View Related
how can update the multiple records at a time ? what loop will use to update the multiple records ? Code:
View Replies
View Related
How can I go about updating multiple records or deleting multiple records
from a DB at a time?
View Replies
View Related
I display work request records from a db table into a .html table dynamically by cycling through the db table until RS.EOF.
To the right of each record displayed I have two checkboxes, "chk_dev_accept", "chk_dev_sendnotif". These are the only editable items on the page.
"chk_dev_accept" is clicked by the developer to assign the work request to his/herself.
"chk_dev_sendnotif" is clicked if the developer wants to notify the customer that the status of the job has changed (optional and automatic - I don't have a problem with this part).
Upon clicking the "Update Record" button, I want the records with the checkboxes clicked to update.
The db record fields that would be updated are: "dev_developer" (The developer that will do the job, read from a cookie) and "dev_proj_status" (changed to 'Assigned'). These two fields should update when the "chk_dev_accept" is clicked and form submitted. I want the developer to check as many records as he/she wishes.
My problem is I'm not sure how to code that <input checkbox....> tag, and then, how to take that checked value to select the appropriate records to update.
View Replies
View Related
My products table has a weight field that I need to populate. A bunch of them have it and a bunch of them don't, but I need them all to have one. The weight is the same, 3, for all the records. I also have an Include field in that table. I want to make the weight field 3 for all records where the include field is true (it's a yes/no checkbox in access.)
I'm using Dreamweaver and I can build the SQL statement just fine but I'm not sure of how to loop through this to set the field for each of these records.
View Replies
View Related
I have a shoppingcart which is saved in an array. When the user goes to the checkout and and presses the order button the contents of the array gets saved in a databasetable. This all works fine.
The problem that I have is that I want the articles that the user ordered get subtracted from the Quantity I have got in my database. But I don't know how to tell the database which records have to be updated. Code:
View Replies
View Related
I have a list of registrants and I want to use a check box after each record
to show those who attend and then post all with one submit button.
View Replies
View Related
I got a test asp page which connects to Northwind.mdb database. This page
pulls all the rows from the Customers table. One column i.e. GoodStatus has
been added to the customers table. The following is the code to display all
records of the customers table with some customization. Code:
View Replies
View Related
I wish to update certain records in a access database where the placeID is a certain number and the coststypeID can be other numbers. I am using the following code:
View Replies
View Related
how to update a database from a dynamic table with checkbox. Their is only one field I would like to change and that is the one with the checkbox.
I am using Dreamweaver and I create a dynamic table, add the update record and I get BOF EOF error. The database does have data in it. Code:
View Replies
View Related
I already have this piece of code that inserts multiple rows of data into a single table at once. Code:
View Replies
View Related
I just took over maintaining an ASP codebase for sending out
newsletters by mail, as well as basic subscriber maintenance.
Thing is working ok today, with ~200 subscribers, but there are plans
on selling this 'solution' to clients with substantially higher
demands; at least in the low 1000's..
Would you consider asp suitable for this purpose? Would be a
definitive plus not having to use other technology, but i'm concerned
about timeouts and whatnot while sending out such a batch of mail.
Guess it could be made workable with tons and tons of logging, and
maybe generating a client redirect every X mails, to restart/keep the
script going?
Or is it perhaps possible to fork off a new thread and do this as a
real background task? I'm not too knowledgeable on ASP, and neither
was the guy who wrote this system in the first place, unfortunately.
View Replies
View Related
I have a test and production environment. The code works fine on test
but behaves erractically in production. The script needs to email people
who are subscribed to a particular service. On test it is a small list
but the list on production is fairly large. Does the CDO object have a
maximum number of people that can be BCCed? I also have email addresses
with hyphens in them, are there special characters, (other than @), that
have to be respected? I have seen some other posting with people having
issues with the CDO object and one of the suggestions is to:
# Try using a SendUsing value of 1 (pickup) instead of 2 (port). E.g.
the following line:
cdoConfig.Fields.Item(sch & "sendusing") = 2
Becomes
cdoConfig.Fields.Item(sch & "sendusing") = 1
What is the difference between these two? The webserver is juts using
the default SMTP server, is it going to work with a setting of
cdoConfig.Fields.Item(sch & "sendusing") = 1? Where are they picking it
up from?
View Replies
View Related
I have a table in SQL server, that has three columns:
ID, Asset, Keywords.
i.e.
ID Asset Keywords
1 Car Mercedes
2 Car Toyota
3 Color Blue
Ok, what I'm trying to do through my asp page (since I cannot do it through SQL, seeing as how it appears that what I want to achieve would be outside the scope of why it was created)... is I'm trying to run a query that will get a list of the assets available and then string the keywords for that asset to a variable. Code:
View Replies
View Related
I tried using the one listed here http://www.aspfree.com/c/a/ASPCode/...rom-a-database/ but I keep getting an error which I've posted but haven't found an answer for yet. Does anyone know of any other one that I can use. I basically want to be able to pull a list of the emails out of my db and send an email to those addresses.
View Replies
View Related
I'm given a DB with everyone's particulars including emails which
I'm supposed to retrieve all their emails and do a mass reminder email.
Can someone give me some ideas as how am I supposed to go about doing it
using asp and vb as I'm quite new with the languages.
View Replies
View Related
I currently developing a Email marketing application using asp and aspemail for a client. They requested the application to be able to mass email to their client that is store in an access database. So how can i initiate the application email to all the email store in the database?
View Replies
View Related
My problem is, when I send e-mail to our members, not all of them are getting them and there is no rhyme or reason. I was thinking of re-writting the program to go through MS Outlook so our Exchange Server will take care of sending it. Then again, probably there is someone who can help me figure out why some e-mail are not getting delivered even though they have valid e-mail addresses. There must just be about 25-35 out of probably close to 2000 members in our mailing list. I am using SMTP do you think it is getting overloaded with delivery? Sometimes they would come back with a delivery delayed notification.
I posted my code because there might be something in my program that does not work for mass e-mail sending and somebody might want to give me a suggestion on handling this matter.
What if I send the e-mail one by one instead of doing a bcc?
View Replies
View Related
Any body guide me about how to sent 1 lakh email at a time by using cdonts.newmail
View Replies
View Related
I'm going to have a need to send out about 30,000 e-mail messages regularly to addresses that reside in a list/database. (not spam :)
Because of insitutional infrastructure issues on the +receiving+ side, I need to space out the sends: say, send 500 messages, pause ten minutes, send another 500, until the full list of 30,000 is complete.
I'm either going to code this myself, or buy a component that does this for me. Can anyone advise me of a component that can deliberately slow down the processing/sending of an e-mail job? The SMTP stuff will reside on our end.
View Replies
View Related
my page(searchresults.asp) will show all the results that you searched for.. These results are from the sql server. All the datas are different. On the right of every record, there is a checkbox.
Now is the scenario..
After all records are shown, I will check a few checkboxes. Then i will click the button. All the data that is checked will be inserted in the sql server. But the thing is that all data records is different..
Its actually kinda off like the hotmail, where you checked a few boxes and put them into a different folder..
View Replies
View Related
What would be the best approach to sending a mass email out without clogging the server or running the risk that emails maybe lost (possibly due to a timeout).
Currently, I've been given the task with sending out a monthly newsletter to our customers (upon request of course). It is an easy task from what I can tell, simply bcc all the emails, set HTMLBody and TextBody and send it off. But, I will be sending this to 5000 clients and dont want any dropped emails.
Plus, is there a way to determine failed email address (due to bad domain names, bad email address, etc) and report it to the web application?
View Replies
View Related
I am trying to send out a mass email newsletter. I have 600+ subscribers in our SQL Server Database. Well, is ASPMail (Server Object's product) good for this? If so I have some concerns about the error handling and assuring people don't continue to recieve the same email. Does anyone have expierence with this? If so, what is your advice?
View Replies
View Related
I am web admin for a school's website and now and again I have to send
emails to those who have signed the guestbook and have consented to this.
Now I have a distribution list within outlook but whenever I try to send
these emails I receive different errors e.g. 'too many recipients' Does
using CDONTs to dynamically send emails eliminate this problem? Are you
aware of any cheap programs out there that will meet my needs? I would also
like to be able to easily track and delete the emails that are no longer in
use...
View Replies
View Related
My client does not want to use a listserv. He wants to send 5000+ emails,
once everyday to our members. Our hosting company has agreed to this.
What are my options here?
I know I can write a basic looping SQL script, but that would take
forever....
What about an "email queue" through SQL? But I cannot install any components
on the web server, so what options are there?
View Replies
View Related
I'm given a DB with everyone's particulars including emails which I'm supposed to retrieve all their emails and do a mass reminder email to the individual email addresses.
I don't want to send a email whereby all the email addresses is shown in the email. Can someone give me some ideas as how am I supposed to go about doing it using asp and vb. Is there any working codes I can refer to?
View Replies
View Related
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.
View Replies
View Related
I am testing a mass emailer that I will be sending out this week. I use ASP to read email addresses from a db table which is contains a list of email addresses of those who will receive the email blast. I have included myself to see the results of the test. I noticed when I received the email, the body or content of the email was repeated as many times as there are people in the email list the code was reading from.
Can someone tell me what I did wrong in the code below?
Code: ....
View Replies
View Related
I want to use a simple CDONT mail script to allow the administrator of a site to send an email blast to their users. there are approx 1600 emails in the MS SQL db table. I would like to parse the entire email address column and get a variable that is all the email addresses separated by a comma so that the form picks it up as all the emails in the 'bcc' field as in the eg. below..I know there has to be an easier way but I want to get these guys up and running.
<%
objCDO.To = "Recipient@oursite.org"
objCDO.From = "mailer@oursite.org"
objCDO.bcc = "$variable_of_all_email_addresses"
Dim txtSubject
txtSubject = "Insert comments and case info here"
objCDO.Subject = ""***ATTENTION*** NEW CASE - MISSING CHILD"
objCDO.Body = txtSubject
objCDO.Send
%>
View Replies
View Related
