graham262

Yes, have thought about doing that. I will still end up storing a lot of email content though as this facility on our system is used quite a lot. Any preferred method for storing? Is a DB efficient as it's only storing chunk text. Graham.

I have a situation where I need to record emails send from a data management system we have. At the moment I just store the sender, receiver and title of the email, but my there is a request to also store the email it's self in case they need to look it up. I initially said that storing the email content would kind take up lots of space on the server over time. Anyone know of a economical way of storing email content. Users will very rarely need to look up the content it's self, only in vary rare circumstances. What ways are best? Files, Database? ??? Thanks, Graham

Hi, I've got a table "students" with the following fields {student_name, home_university, host_university}, both home and host universities are ID that refer to a "university" table containing {id, name, city} for example What I want to do is pull out from one query the student ID and the name of their home and host university. To do this I need to link both home and host uni id to the university table but am not sure how to code this in MySQL. If it was just the home uni name I was after I would do this: SELECT students.name, universities.name FROM students, universities WHERE students.home_university=university.id What if I want to display a list of results listing both home AND host uni names and then perhaps list by either name alphabetically? ???

Ok, here is my situation. I have a database program that uses MySQL on the users local computer (for offline work), but the online version (situated on a server elsewhere) maybe MySQL, Access, Oracle, or something else. When the user makes changes to the db, it stores the SQL query in a log file. Here's the question, if the user wants to then import the changes (data) in to the online db, can I just load the SQL query in using something like adodb and all is well?? I am try to work with 2 different databases see, and am not sure if this is possible. From what I can see from adodb it takes care of all the communication with the difference databases, you just need to feed it the SQL queries and it does the rest.... I am I too naive Thanks, Graham.