Re: [CDBI] Quoting reserved words.
Bill Moseley <[email protected]> Thu, 14 Jan 2010 05:01:53 -0800
| Newsgroups | gmane.comp.lang.perl.modules.class-dbi |
|---|---|
| Message-ID | <[email protected]> |
--===============0336067696== Content-Type: multipart/alternative; boundary=000e0cd1a8cce363b5047d1f7ebf --000e0cd1a8cce363b5047d1f7ebf Content-Type: text/plain; charset=ISO-8859-1 On Wed, Jan 13, 2010 at 9:49 PM, Edward J. Sabol <[email protected]>wrote: > > > Alternatively, you could make a view in the database that is basically > identical to the table in question but with the "window" column name > changed > to something else Except I need to be able to update from my objects, too. I guess I've just been lucky and never had a column name that was a reserved word. Kind of odd I never ran into this before. I might try that patch, but I also reviewed the code and there's only a few places where "window" is used so a column rename might be pretty fast. Thanks, -- Bill Moseley [email protected] --000e0cd1a8cce363b5047d1f7ebf Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable <br><br><div class=3D"gmail_quote">On Wed, Jan 13, 2010 at 9:49 PM, Edward = J. Sabol <span dir=3D"ltr"><<a href=3D"mailto:[email protected]">E= [email protected]</a>></span> wrote:<br><blockquote class=3D"gmail_= quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1= ex;"> <div class=3D"im"><br></div> <br> Alternatively, you could make a view in the database that is basically<br> identical to the table in question but with the "window" column n= ame changed<br> to something else</blockquote><div><br></div><div>Except I need to be able = to update from my objects, too.</div><div><br></div><div>I guess I've j= ust been lucky and never had a column name that was a reserved word. =A0Kin= d of odd I never ran into this before.</div> <div><br></div><div>I might try that patch, but I also reviewed the code an= d there's only a few places where "window" is used so a colum= n rename might be pretty fast.</div><div><br></div><div>=A0Thanks,</div> </div> <br>-- <br>Bill Moseley<br><a href=3D"mailto:[email protected]">moseley@hank= .org</a><br> --000e0cd1a8cce363b5047d1f7ebf-- --===============0336067696== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ ClassDBI mailing list ClassDBI-Ra3b/[email protected] http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi --===============0336067696==--