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:
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..
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 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 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'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.
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 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.
Our graphic designer has just finished redeveloping our website. On the site, we use SSL to secure the area where a user enters their personal information to order items from us. (we do not do many transactions - maybe 1 per day...) We are a log home mfg company so they would only order plan books, maybe a video etc...
When the user clicks "Submit Order", we want to encrypt each data item (because of new legislation governing customer personal info etc...) and write a record to an access db. From here it will be imported into our Customer DB leads database...
I do not use ASP but program in VB 6 and Access 2000. ASP looks similiar in many ways...
Does someone have a good ASP script for encrypting data? And, if so, is it fairly strong encryption?
Also, is there any trick to writing an "insert" SQL script in ASP or is it exactly the same as I would do in VB or Access? Maybe someone has an "insert" script handy they could pass along including the command to actually execute it?
that's shortly the way i'm inserting new records. using mysql and asp functions.
The prob is that inserting only one record every time. if i got data for 3 records how can i make it at once to add 3 new records in some given order into the db
What is the best way to see if a record has inserted correctly into the datase in ASP? Also, how to tell the user what the error is. I am inserting like this with the ADO command object: Dim sInsert, objCmd set objCmd = Server.CreateObject("ADODB.Command") sInsert = "sp_ADS_Insert_Driver_General_Data " on error resume next With objCmd .ActiveConnection = oConnEnergy .CommandText = sInsert .CommandType = adCmdStoredProc .Execute , , adExecuteNoRecords
Application X has three screens. The user captures information on screen one and then clicks a navigation button to go onto screen two.He does the same on screen three. At the bottom of screen three is a submit button. When this button is clicked the system does some calculations with the information that is supplied and then uploads all the info that was captured on the screens to the database.
Should the data be uploaded to the database all on one go when the user clicks the submit button or should it be uploaded after each screen - ie when the user clicks the button on Screen 1 the data is uploaded to the database and then screen two is displayed.
I have a column call UserDate and it's properties are this : varchar(50) . I have a function which updates the column with todays date. for some reason, if I manualy give the value to be inserted a value of '10/10/2006' or use date() it inserts a value of 0 if I give a value of 4 to be inserted it works?
I have been working on a project for 2 days and this is the last piece to get it to work, can anyone point out where I'm going wrong. P.S I have tried giving the colum a date format but unfotunately the format is american and I need it in english to compare with something else I'm working on.
I'm getting a syntax error when I try to run this SQL Insert statement, can anyone tell me what might be wrong? Before I was getting a data type mismatch error then I removed the ' quotes around the intPhone variable. The error occurs on the line after the SQL statement.
I have a 2 asp pages for a registration form. The first one is where the user types the data, and the second one has a form that requests the data from the 1st one and then sends it to the database. Both are sending the data correctly (I've seen it on the error page) but it's not feeding the DB.
I have a website I am working on that I did not create. It is ASP and SQL based. There is a content management system created using ASP and saving in the SQL server database. A user can enter a news article into a big text box/area, and choose to add an image. The text and image are stored in the database via ASP and pulled out to the website via ASP.
The image shows up in the website to the top left of the article. I need to make it so the user can enter an image where their cursor is in the paragraph (like a word document) and have it also show up there on the website. Any ideas?