RE: Join Suddenly Failing

2010-01-22 Thread Jerry Schwartz
>-Original Message- >From: Albert Padley [mailto:ap3des...@gmail.com] >Sent: Friday, January 22, 2010 12:37 PM >To: mysql@lists.mysql.com >Subject: Join Suddenly Failing > >I have a website that gets used once a year for a soccer tournament. It has >been working fi

Re: Join Suddenly Failing

2010-01-22 Thread Johan De Meersman
r copying of this message is > prohibited. If you have received this communication in error, please notify > the sender immediately by e-mail, and delete the original message > -Original Message- > From: Albert Padley [mailto:ap3des...@gmail.com] > Sent: Friday, January 22, 2010

RE: Join Suddenly Failing

2010-01-22 Thread Wm Mussatto
If you have received this communication in error, please > notify > the sender immediately by e-mail, and delete the original message > -Original Message- > From: Albert Padley [mailto:ap3des...@gmail.com] > Sent: Friday, January 22, 2010 11:37 AM > To: mysql@lists.mysql.com &g

Re: Join Suddenly Failing

2010-01-22 Thread Albert Padley
lete the original message > -Original Message- > From: Albert Padley [mailto:ap3des...@gmail.com] > Sent: Friday, January 22, 2010 11:37 AM > To: mysql@lists.mysql.com > Subject: Join Suddenly Failing > > I have a website that gets used once a year for a soccer tournament.

RE: Join Suddenly Failing

2010-01-22 Thread Scott Swaim
communication in error, please notify the sender immediately by e-mail, and delete the original message -Original Message- From: Albert Padley [mailto:ap3des...@gmail.com] Sent: Friday, January 22, 2010 11:37 AM To: mysql@lists.mysql.com Subject: Join Suddenly Failing I have a website that

Join Suddenly Failing

2010-01-22 Thread Albert Padley
I have a website that gets used once a year for a soccer tournament. It has been working fine since 2006. No script changes since it was last used in 2009. All of a sudden the following script started throwing an error. SELECT contactinfo.contactdata, contactinfo.ContactID FROM team, person, teamp