RE: [OT] Email heaaders and threading (was Re: update MySQL)
> -Original Message- > From: Michael Stassen [mailto:[EMAIL PROTECTED] > This tells the recipient's email client that your message is > a reply, not a new message, despite your efforts to change the subject and > recipients. Many email clients use that header to decide which thread a message > belongs to. That's actually the point of the header. I get it now. I wasn't aware of that, since every email client I've ever seen seems to thread strictly by subject. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: update MySQL
On Wednesday 06 October 2004 02:10 pm, Scott Hamm wrote: > Like I said before it "seems" to group by "threads". Therefore, it is > close enough. Right! thats why Microsoft thrives. Because as long as it appears to work, its all good.. :) Jeff pgpAXe4d5h6QD.pgp Description: PGP signature
Re: update MySQL
Hey folks. Apparently I need to say it again: this discussion is off-topic for this mailing list. Please either let it die or take the discussion off-list. Thanks. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: update MySQL
Like I said before it "seems" to group by "threads". Therefore, it is close enough. -Original Message- From: Michael Satterwhite [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 06, 2004 3:05 PM To: [EMAIL PROTECTED] Subject: Re: update MySQL -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 05 October 2004 14:39, Scott Hamm wrote: > Jeff, > > If you sort it by conversation topic, then it will seem to group by > "threads". > I'm running Outlook 2000. Not the same thing. Threading uses the "In-reply-to" header. Messages will stay in the correct thread even if the subject changes - which is why it makes a difference. -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFBZEH2jeziQOokQnARAmKiAJ4ww4xc4BOGxnOoXaXlNPxOYvM18gCfVQy1 E+90ewHDuSc7AKQGkjBzIEc= =1mEs -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: update MySQL
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 05 October 2004 14:39, Scott Hamm wrote: > Jeff, > > If you sort it by conversation topic, then it will seem to group by > "threads". > I'm running Outlook 2000. Not the same thing. Threading uses the "In-reply-to" header. Messages will stay in the correct thread even if the subject changes - which is why it makes a difference. -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFBZEH2jeziQOokQnARAmKiAJ4ww4xc4BOGxnOoXaXlNPxOYvM18gCfVQy1 E+90ewHDuSc7AKQGkjBzIEc= =1mEs -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: update MySQL
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 05 October 2004 14:23, David Brodbeck wrote: > Well, that's nice... > > I just don't see what difference it makes. As far as I can see, the > outcome is identical either way... If the recipients email program threads messages, it makes a big difference. -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFBZEG6jeziQOokQnARAq2qAJ9dHUqz+mmTGTNp7xRiu4hZipIBcwCgpfxX lnNkjyvux/GUi/pZCgNzmJ8= =f0bF -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: update MySQL
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 05 October 2004 15:18, Ed Lazor wrote: > Also, back to my original question, what are you seeing that denotes the > difference between whether I reply or create a new message when starting a > new topic? After all, I took care of changing the recipient list and the > subject field. Is header information different? Does your email client > sort or group messages differently? I haven't been following this, but I can make a good guess. Some email clients can thread messages - my client (KMail) is one of them. If you hit reply, your message gets placed in the thread that you replied to. It is *NOT* based on the subject, it uses the "In-Reply-To" header. If you enter a new message, it begins a new thread. If it is really a new message, it is out of context to put it into an existing thread. If it is really a reply, it may be lost in a new thread. Because of threaded emails, it is considered bad practice to start new threads by a reply - or use "New" to reply to a thread. I won't claim I've never done it, but it is bad practice. -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFBZC6mjeziQOokQnARAp5wAJ9QehvPkNRVwKGgUkAjAm7jkQfRowCgrWaH BwWO1G8aButW0ejjh3P2O4w= =EkBR -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: [OT] Email heaaders and threading (was Re: update MySQL)
> Ed, > > When you *reply* to a message, most mail clients (including yours) add a > header > like this: > >In-Reply-To: <[EMAIL PROTECTED]> > > That stuff in between the < and > is the message-id of the replied-to > message. > > This tells the recipient's email client that your message is a reply, not > a new > message, despite your efforts to change the subject and recipients. Many > email > clients use that header to decide which thread a message belongs to. > That's > actually the point of the header. > > I'm not interested in a debate over the relative merits of different mail > clients and view modes. The point is simply this: Many people choose to > view > their mail in threaded mode. When you start a new topic by replying to an > old > topic, you disrupt that organization. > > Ultimately, etiquette is about choosing to accomodate the needs of other > people, > not about rules. You didn't know the effect you were having before, but > now you > do. What you do with that information is up to you, but I would suggest > that > starting a new message is no more work than changing the subject and > recipients > list of a reply. > > Michael Thanks Michael. I think you've done an excellent presentation on the merits of starting a new topic with a new message. I'm definitely convinced and will be happy to do my part to help out. -Ed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[OT] Email heaaders and threading (was Re: update MySQL)
Ed Lazor wrote: -Original Message- Actually its proper email etticate.. look it up if you don't believe me.. That sounds like a copout. Could present formal references to back this up? I'm trying to substantiate your claims, but a Google search failed to bring up anything relevant when searching with the keywords of etiqette, email, and replying. Here are some of the references that did come up: http://coco.essortment.com/emailetiquette_rtqh.htm http://www.dynamoo.com/technical/etiquette.htm http://www.cdtl.nus.edu.sg/success/sl6.htm Also, back to my original question, what are you seeing that denotes the difference between whether I reply or create a new message when starting a new topic? After all, I took care of changing the recipient list and the subject field. Is header information different? Does your email client sort or group messages differently? -Ed Ed, When you *reply* to a message, most mail clients (including yours) add a header like this: In-Reply-To: <[EMAIL PROTECTED]> That stuff in between the < and > is the message-id of the replied-to message. This tells the recipient's email client that your message is a reply, not a new message, despite your efforts to change the subject and recipients. Many email clients use that header to decide which thread a message belongs to. That's actually the point of the header. I'm not interested in a debate over the relative merits of different mail clients and view modes. The point is simply this: Many people choose to view their mail in threaded mode. When you start a new topic by replying to an old topic, you disrupt that organization. Ultimately, etiquette is about choosing to accomodate the needs of other people, not about rules. You didn't know the effect you were having before, but now you do. What you do with that information is up to you, but I would suggest that starting a new message is no more work than changing the subject and recipients list of a reply. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: update MySQL
Outlook 2003 here and its working just like Scott's (Converation, Subject, etc.). > -Original Message- > If you sort it by conversation topic, then it will seem to group by > "threads". > I'm running Outlook 2000. > > Cause your doesnt support threads.. Outlook was the only one I knew off > that > > did not. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: update MySQL
> -Original Message- > Actually its proper email etticate.. look it up if you don't believe me.. That sounds like a copout. Could present formal references to back this up? I'm trying to substantiate your claims, but a Google search failed to bring up anything relevant when searching with the keywords of etiqette, email, and replying. Here are some of the references that did come up: http://coco.essortment.com/emailetiquette_rtqh.htm http://www.dynamoo.com/technical/etiquette.htm http://www.cdtl.nus.edu.sg/success/sl6.htm Also, back to my original question, what are you seeing that denotes the difference between whether I reply or create a new message when starting a new topic? After all, I took care of changing the recipient list and the subject field. Is header information different? Does your email client sort or group messages differently? -Ed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: update MySQL
Hi. This discussion is very off-topic for this list. Please take the discussion of how to use your email client off-list. Thanks. Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: update MySQL
On Tuesday 05 October 2004 02:39 pm, Scott Hamm wrote: > If you sort it by conversation topic, then it will seem to group by > "threads". > I'm running Outlook 2000. Seem.. Thats the key word.. Its not true threading support.. These are not there for looks.. References: <[EMAIL PROTECTED]> In-Reply-To: <[EMAIL PROTECTED]> Jeff. pgpgRjZu4Ewfs.pgp Description: PGP signature
RE: update MySQL
Jeff, If you sort it by conversation topic, then it will seem to group by "threads". I'm running Outlook 2000. Scott -Original Message- From: Jeff Smelser [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 05, 2004 3:36 PM To: [EMAIL PROTECTED] Subject: Re: update MySQL On Tuesday 05 October 2004 02:23 pm, David Brodbeck wrote: > > Well, that's nice... Hmm > I just don't see what difference it makes. As far as I can see, the > outcome is identical either way... Cause your doesnt support threads.. Outlook was the only one I knew off that did not. Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: update MySQL
On Tuesday 05 October 2004 02:23 pm, David Brodbeck wrote: > > Well, that's nice... Hmm > I just don't see what difference it makes. As far as I can see, the > outcome is identical either way... Cause your doesnt support threads.. Outlook was the only one I knew off that did not. Jeff pgp1rxawLcFkW.pgp Description: PGP signature
RE: update MySQL
> -Original Message- > From: Jeff Smelser [mailto:[EMAIL PROTECTED] > On Tuesday 05 October 2004 01:56 pm, David Brodbeck wrote: > > > Saves having to retype the list address, or look it up. I > don't see what > > difference it makes... > > Click on the email, on mine, it brings up a nice to empty > message with the > email address.. Well, that's nice... I just don't see what difference it makes. As far as I can see, the outcome is identical either way... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: update MySQL
On Tuesday 05 October 2004 01:56 pm, David Brodbeck wrote: > Saves having to retype the list address, or look it up. I don't see what > difference it makes... Click on the email, on mine, it brings up a nice to empty message with the email address.. Jeff pgp50O9uZVT4t.pgp Description: PGP signature
Re: update MySQL
On Tuesday 05 October 2004 01:55 pm, you wrote: > We're not perfectionist like you. :) Actually its proper email etticate.. look it up if you don't believe me.. Jeff pgpjB48FEXyL0.pgp Description: PGP signature
RE: update MySQL
> -Original Message- > From: Jeff Smelser [mailto:[EMAIL PROTECTED] > Whats the deal and this list? No one can ever just hit new > message, they > always hit reply and put a new subject in.. Saves having to retype the list address, or look it up. I don't see what difference it makes... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: update MySQL
We're not perfectionist like you. :) > -Original Message- > From: Jeff Smelser [SMTP:[EMAIL PROTECTED] > Sent: Tuesday, October 05, 2004 2:23 PM > To: [EMAIL PROTECTED] > Subject: Re: update MySQL > > On Tuesday 05 October 2004 01:14 pm, Ed Lazor wrote: > > Does anything need to be done to my data while upgrading the server from > > 3.23 to 4.0.21? > > Whats the deal and this list? No one can ever just hit new message, they > always hit reply and put a new subject in.. > > Geez.. This list is horrible with it.. > > Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: update MySQL
You're close. I hit reply to all, typed in a new subject, and then modified the To field by removing all but the [EMAIL PROTECTED] address. Come to think of it, I'm hitting reply on this message as well. What difference are you seeing that makes this significant? -Ed > -Original Message- > On Tuesday 05 October 2004 01:14 pm, Ed Lazor wrote: > > Does anything need to be done to my data while upgrading the server from > > 3.23 to 4.0.21? > > Whats the deal and this list? No one can ever just hit new message, they > always hit reply and put a new subject in.. > > Geez.. This list is horrible with it.. > > Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: update MySQL
On Tuesday 05 October 2004 01:14 pm, Ed Lazor wrote: > Does anything need to be done to my data while upgrading the server from > 3.23 to 4.0.21? Whats the deal and this list? No one can ever just hit new message, they always hit reply and put a new subject in.. Geez.. This list is horrible with it.. Jeff pgpZ3q0X0WvJ5.pgp Description: PGP signature
re: update mysql
On Friday 20 December 2002 22:08, John Chang wrote: > I e-mailed the list but haven't received a response. I have win2k w/ > 3.23.53 and need to update it to 54. Is there a patch or do I have to do a > reinstall or install on top of it? You can just install 3.23.54 over 3.23.53, but backup of the databases is recommended. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: update mysql database via php form
Hi, didn't really understand what you are asking.. Can you please be more specific? What exactly you are asking? Gurhan -Original Message- From: Valerie Brooks [mailto:[EMAIL PROTECTED]] Sent: Friday, March 15, 2002 5:28 PM To: [EMAIL PROTECTED] Subject: update mysql database via php form Hi, I'm using php form to update mysql database, the form has several drop down menus to choose from. What would the best way of updating information in the database, update, as a function? Any help will be greatly appericated. Thanks. - Valerie Brooks Fujitsu Software Voice: (408)456-7222 Email: [EMAIL PROTECTED] "There's no limit to what can be accomplished if it doesn't matter who gets the credit" - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Update MYSQL command with PHP
> Question is there something wrong with this syntax when using the MYSQL > Update command in PHP , where I change the record by users editing the > fields on a web form then those are extracted to update a record in a > table. > Here's what I have tried I don't get any syntax errors with either of > these attempts > > $query1 = "UPDATE Qusers SET $field_str WHERE UserName='$username'"; > $result2 = mysql_query($query1); > > > Second Example > > $query1 = "UPDATE Qusers SET BillAmt='$billamt' WHERE > UserName='".$username."' AND Qusers.RID ='".$keyid."'"; > $result2 = mysql_query($query1); Kory, The PHP-db list (and archive) is full of answers to this question. The first example looks a bit suspect unless $field_str holds a set clause in the form: column_name=expression, and further that "expression" does NOT contain double quotes, eg a string value's delimiters. You should precede these with several function calls to 'open' the db, and should follow every mysql_...() call with an error check. Prevailing wisdom suggests putting an echo between the two lines, so that you can see exactly what will be passed as the query to MySQL. Finally, if there is any question, that output can be copied-and-pasted into a command line query or a MySQL administration tool to verify/confirm the SQL syntax. Regards, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Update MYSQL command with PHP
> $query1 = "UPDATE Qusers SET $field_str WHERE UserName='$username'"; > $result2 = mysql_query($query1); It should be: update Qusers set field_name='$field_str' where username='$username'"; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php