RE: Why is the average of an int column returned as a string

2007-08-23 Thread Rhys Campbell
21 August 2007 22:52 To: mysql@lists.mysql.com Subject: Why is the average of an int column returned as a string Hello, I am working with a query that calculates the averages of survey answers. The survey answers are stored in the database as int(11) fields. When I run the query the results

RE: Why is the average of an int column returned as a string

2007-08-22 Thread Eric Lommatsch
, CO 80210 Tel 303-777-8939 Fax 303-778-0378 [EMAIL PROTECTED] -Original Message- From: Rhys Campbell [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 22, 2007 3:34 AM To: Eric Lommatsch; mysql@lists.mysql.com Subject: RE: Why is the average of an int column returned as a string You could

RE: Why is the average of an int column returned as a string

2007-08-22 Thread Rhys Campbell
: mysql@lists.mysql.com Subject: Why is the average of an int column returned as a string Hello, I am working with a query that calculates the averages of survey answers. The survey answers are stored in the database as int(11) fields. When I run the query the results that I am getting are

Re: Why is the average of an int column returned as a string

2007-08-21 Thread Paul DuBois
At 8:25 PM -0400 8/21/07, Baron Schwartz wrote: Eric Lommatsch wrote: Hello, I am working with a query that calculates the averages of survey answers. The survey answers are stored in the database as int(11) fields. When I run the query the results that I am getting are being returned as st

Re: Why is the average of an int column returned as a string

2007-08-21 Thread Dan Nelson
In the last episode (Aug 21), Eric Lommatsch said: > I am working with a query that calculates the averages of survey > answers. > > The survey answers are stored in the database as int(11) fields. When > I run the query the results that I am getting are being returned as > string data. > > The

Re: Why is the average of an int column returned as a string

2007-08-21 Thread Baron Schwartz
Eric Lommatsch wrote: Hello, I am working with a query that calculates the averages of survey answers. The survey answers are stored in the database as int(11) fields. When I run the query the results that I am getting are being returned as string data. The query that I am working with is

Why is the average of an int column returned as a string

2007-08-21 Thread Eric Lommatsch
Hello, I am working with a query that calculates the averages of survey answers. The survey answers are stored in the database as int(11) fields. When I run the query the results that I am getting are being returned as string data. The query that I am working with is a data source for a Cry