Re: [Dbix-class] Automatic quoting

2010-06-08 Thread Ronald J Kimball
On Mon, Jun 7, 2010 at 6:04 PM, fREW Schmidt fri...@gmail.com wrote: On Mon, Jun 7, 2010 at 12:04 AM, Toby Corkindale toby.corkind...@strategicdata.com.au wrote: Only speaking on behalf of myself, but I see: 1) You shouldn't be making db tables or columns based on reserved words anyway,

Re: [Dbix-class] Automatic quoting

2010-06-08 Thread fREW Schmidt
On Tue, Jun 8, 2010 at 9:01 AM, Ronald J Kimball rkimb...@pangeamedia.comwrote: On Mon, Jun 7, 2010 at 6:04 PM, fREW Schmidt fri...@gmail.com wrote: On Mon, Jun 7, 2010 at 12:04 AM, Toby Corkindale toby.corkind...@strategicdata.com.au wrote: Only speaking on behalf of myself, but I see:

Re: [Dbix-class] Automatic quoting

2010-06-08 Thread Paul Makepeace
On Tue, Jun 8, 2010 at 08:18, fREW Schmidt fri...@gmail.com wrote: On Tue, Jun 8, 2010 at 9:01 AM, Ronald J Kimball rkimb...@pangeamedia.com wrote: On Mon, Jun 7, 2010 at 6:04 PM, fREW Schmidt fri...@gmail.com wrote: On Mon, Jun 7, 2010 at 12:04 AM, Toby Corkindale

Re: [Dbix-class] Automatic quoting

2010-06-08 Thread Darren Duncan
Will Hawes wrote: Yesterday a colleague new to DBIC ran into a problem with a column named using a reserved word in MySQL. He worked around it by using a different column name, but while discussing the issue he asked why quote_char and name_sep are not set automatically. I don't know the answer

Re: [Dbix-class] Automatic quoting

2010-06-08 Thread Darren Duncan
Toby Corkindale wrote: 1) You shouldn't be making db tables or columns based on reserved words anyway, as sooner or later someone will want to log in manually to do something in SQL, and be cursing you. A problem with reserved words is that they keep changing as you upgrade your DBMS or

Re: [Dbix-class] Automatic quoting

2010-06-07 Thread fREW Schmidt
On Mon, Jun 7, 2010 at 12:04 AM, Toby Corkindale toby.corkind...@strategicdata.com.au wrote: On 04/06/10 19:02, Will Hawes wrote: Yesterday a colleague new to DBIC ran into a problem with a column named using a reserved word in MySQL. He worked around it by using a different column name,

Re: [Dbix-class] Automatic quoting

2010-06-06 Thread Toby Corkindale
On 04/06/10 19:02, Will Hawes wrote: Yesterday a colleague new to DBIC ran into a problem with a column named using a reserved word in MySQL. He worked around it by using a different column name, but while discussing the issue he asked why quote_char and name_sep are not set automatically. I

[Dbix-class] Automatic quoting

2010-06-04 Thread Will Hawes
Yesterday a colleague new to DBIC ran into a problem with a column named using a reserved word in MySQL. He worked around it by using a different column name, but while discussing the issue he asked why quote_char and name_sep are not set automatically. I don't know the answer and Googling has