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:...
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?
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.
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.
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.
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:
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:
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:
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.
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?
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:
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.
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?
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?
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.
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..
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?
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?
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...
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?
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.
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?
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.
