ASPPOP3 & Database Receive
Does any one know if asppop3 allows you to insert mail directly into a database table? I think i know of a way but before I do, I would like to know if any one else knows?
View RepliesDoes any one know if asppop3 allows you to insert mail directly into a database table? I think i know of a way but before I do, I would like to know if any one else knows?
View RepliesI have tried a script, can someone have a look at see why its not taking the message info and creating a log?
It is creating a new records with information that is not supplied with the e-mails, all information has been supplied from users account.
Heres the script: .....
I have application form in ASP and I�m using a code
which I have use many times before and when I fill out
the forms it doesn't return any errors so it works perfect I guess.
Anyway... when I download the database (Access mdb)
back to my C: and open it a new line of record has been
created but all the fields are empty and no data.
Does anyone know what can be wrong or what are the
possibilities?
I need some help with using ServerObjects ASPPOP3 Component.
At first I could not get the headers of the Message to show in the Inbox, ie. Name of Sender, Address of Sender, Subject, Message Status, etc etc
The standard information you usually get with most e-mail clients.
Now Some how I was able to show these headers in the inbox but when it has more then one message is has the same e-mail address, same subject, same everything as
the one before, so I have 5 e-mails on my server, it will show 5 e-mails, but they will all be the same. Code:
Can anyone tell me why this code doesn't work? The original came from
an example in this group, but was modified slightly when the original
failed to return message details.
I am able to connect to the server and see the number of messages on
the server, but message details (sender, subject, body, etc.) are not
returned....
I am looking to incorporate SMS messages into a web page, so if people send a message to me, it shows up immediately on-screen. how to do this?
View Replies View RelatedI was just wondering what the requirements are on my computer system if I want to be able to receive e-mails (to my own mail server and not through the mail server of my ISP). I already have a functioning SMTP-server, but I guess that only works for outgoing mails, or is there maybe a way I can send mails to this SMTP-server?
Do I need a fixed IP-address? Do I need so kind of special software like Win 2003 server or maybe Exchange Server? Do I need my own domain name? Anything else I need to bear in mind if I want to have my own incoming mail server?
Is 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 for a way to read & download my e-mails from my pop3 account from another server by using ASP(vb)
If you know anything about this subject please feel free to let me know. I learn how send but not receive.
After I run my cdon't.asp file, I saw a successful message saying "mail sent". Then, I went to open my inbox but find no mail. So, I went back to c:inetpubmailroot, I saw a folder called queue and saw that mail there. How do I solve this problem?
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 have a html form. When it is submitted, an asp page retrives all the data and sends the data to my email id. It is working well when the form data is in English. When user fill in the form using Thai language and submit, as sends some junk. How can i fix it?
View Replies View RelatedI have been writing a photoalbum in ASP and I am trying to receive an undetermined amount of files.
A more detailed explanation:
The client side (Javascript) generates a new file upload box as soon as the file in the first box is selected...the name of the file upload boxes is bestand[] so that the input is received in an array.
Now I am trying to receive all the files with ASP and store them on the server....
I'm looking for a simple e-mail form processing for my website. I want users to be able to add their e-mail in a simple text field with a submit button so I can receive it by e-mail. I've looked on the Internet and it seems so complicated.
View Replies View RelatedReceive xml as input stream through asp and parse it. I would be getting a xml file and i need to recive it through asp and parse it thus extracting its childnodes.
View Replies View RelatedI have the following code in my my form:
Sub frmSubButton1_onclick
Dim ObjMail
'Create Mail Object
Set objMail = Server.CreateObject("CDONTS.NewMail")
'Populate variables from form value
strAuthorEmail = document.getElementById("OpenBy").value
strRecipientEmail = "tech@lsamedicaidspecialists.com"
strCC = document.getElementById("OpenBy").value
strBody = document.getElementById("IssueDescription").value
With ObjMail
.From = strAuthorEmail
.To = strRecipientEmail
.CC = strCC
.Subject = document.getElementById("IssueCategory").value
.Body = strBody
End With
ObjMail.Send
I am erroring out on this line -
Set objMail = Server.CreateObject("CDONTS.NewMail")
The error I receive is Object 'Server' Required. I am running IIS 5.x and that is why I am using CDONTS.
I''ve got a problem with "dim". I want to receive a variable send from a formular with method GET Why it doesn't work??
<body>
<%
dim name
dim vorname
....
name = request.QueryString("name")
vorname = request.QueryString("vorname")
....
response.write ("name" )
response.write ("vorname" )
....
response.end
%>
</body>
I have just started using ASP, I am normaly using PHP but I thought ASP might be a good road to go down. I am having a few problems, I am trying to limit the number of records I take out the database but I keep getting errors.
<%
'connection string
datapath=Server.Mappath("guest.mdb")
strconn="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & datapath & ";"
Set CONN = Server.CreateObject("ADODB.Connection")
CONN.Open strconn
'select all records row by row
DBquery="SELECT * FROM Guests LIMIT 10"
set query=Conn.execute(DBquery)
do while not query.eof
'get a variable from the table
guest_id = query("ID")
guest_name = query("Name")
guest_msg = query("Mesg")
guest_date = query("DateTime")
'print the variable to the screen
response.write guest_id & "<br />"
response.write guest_name & "<br />"
response.write guest_msg & "<br />"
response.write guest_date & "<br />"
response.write "<br />"
'move to the next record
set conn = nothing
query.movenext
loop
%>
I am getting this error;
Microsoft JET Database Engine error '80040e14'
Syntax error in FROM clause.
/guestbook/guest.asp, line 11
can anyone help me?
I had made a form name 'dform.html' which asks idno, name and phone from the user and after the user clicks on button "save data" sdata.asp is executed. sdata.asp is written to save the values entered for idno,name and phone in dform.html into table "myfriends" in the mydata.mdb (access database). but when i am clicking on save data button i am getting error saying
"Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
/SDATA.ASP, line 9"
can please anyone tell me why i am getting this error.
I work with ASP for several weeks now and i really like it! But until now i have just used it in connection with my localhost. I made connections to a SQL Database and to an ACESS Database with using the ODBC Tool from WIndows!!
Now i want to publish my website but i don't know how to handle the connection string kind of thing. My MySQL-Database is on a different server than the website and i need a connection string where i can type in the server, a password and a username and it should then connect.
I'm current working on a project which need to upload local data to
live server database.
Meanings that, i'm current having a server in my local mechine. I need
upload data from local database to live database which host at oversea
company. But i really have no idea how to do this in asp.
Error Type:
Microsoft JET Database Engine (0x80040E21)
Cannot update. Database or object is read-only.
/q_maker/aero_admin/delete.asp, line 12
what is wrong! i checked the db and its not readonly.
i wrote a shopping cart using cookies found out thatIE 7 won't let me add more cookies after a certian number. decided to use DB along with cookies and now i have very weired problem never encountered before Code:
View Replies View RelatedProducts ---> Products|Customer <--Customer
With regardst the above many-to-many relationship:
Is there any advantage in creating seperate access databases for:
- Customer
- Products
....Rather than keeping them as three tables in one database.
The reason I ask is that I have found that if I am using a ftp approach to
overwriting or updating the remote database there are sometimes problems
with synchronizing data .....This seems to be a better solution?
Am I off base?
does any one know a simple free database driven website tutorial that i could learn? i need it for when someone searches a name ionformation on that name comes up along with photographs realating to them.
I have built several websites before but none are database driven so is there any dummy proof versions?
How do I do a Do While loop to display rows of information out of a database. Here's my code, and it seems like its in an infinite loop. Code:
View Replies View RelatedI have a Access DB with two tables (Users and tblpersons). Users are stored in table Users and their records in tblpersons. They are able to login, Enter, Search, Update their data.
I want users to be able to Enter and update only their data not other users data.
Example:User_Id 1 when logged in, is able to enter data for any user(1,2,3......) and able to modify their data.
I can make a simple database file and name it database.mdb, all I need to do is name a single field email and save it. But I dont know how to make it so that my page will become active and the emails submitted will be saved either to the mdb file or a text file, im not sure what goes on there.
i have 2 tables and i only want the records where which arent in the one database eg.
table 1
idnum
1
2
3
4
table two
idnum
1
2
3
4
5
6
out of these two tables i only want from table two idnum 5 and 6 cause they arnt in the 1st table.
They are on Windows 2000 IIS 5.0 and currently have an older version
of their job database using Access hosted on a Brinkster server.
The new server that they are on, when I contacted the host, they advised me
against creating any new applications using Access, as the server is not meant
for multi-users.
So, I am thinking that they need to get their host to upgrade to a SQL database
and have the job database developed using that.
My question to this forum is: What do you think is the best combination for
improvement here, SQL or MySQL or what, considering that their site is using asp
and hosted on Win2000 IIS 5.0?
Also, any recommendations on scripts that might be already available that could
be customised to their site?
What we have is our own (in house) Windows 2000 Server which runs MS SQL for our data storage and we have writen our own VB6.0 Application which runs of the SQL DB to manange our stock, ordering, price's etc etc. Also we have our own Website with a Web Hosting Company which is also a Windows 2000 Server but can only Run access databases.
What we what to do is somehow have the Access database and the SQL database sync together to have some of the same data in both database's. But I don't know where to start.
I have the following code to execute a SQL query.Code:
SQL = "INSERT INTO teams (`teama`, `teamb`, `pot`, `winner`, `finished`, `start`) VALUES ('" & teama & "', '" & teamb & "', 0, '', False, '" & gdate & "')"
teamrs.Open SQL, conn
all works fine.
I just want to know what result it gives.because once i add it, the form submits, and its a blank page. I want it so it does this Code:
if sql = worked
redirect
else
error
end if
so how can i make sure the query was executed successfully.
This is probably a stupid question (I'm good at those)...
I would like to enable a user to be able to browse to a picture on their local machine and upload that picture to a remote directory where it can then be displayed along with it's other pertinent data.
I thought it might be a good idea to use Front Page's "file upload" feature which includes a "browse" button and prompts me for a storing location - but I can't get it to work and am not even sure if that's its intended purpose.
So my question is two-part, what should my insert or update page look like regarding an upload process, and then how would I link to or display that picture?