Ed Leafe wrote:
> On Feb 13, 2007, at 11:16 PM, Paul McNett wrote:
>
>> Oh I see, so someone could just do:
>>
>> biz.addField(biz.addQuotes("customers.order as customer_order"))
>>
>> Is that what you are saying?
>
> No. If they're too clueless to use intelligent naming, they're too
> clueless to realize that they need to quote things.
>
> Right now if you issue the command: biz.addField("customers.field
> with spaces"), the backend class will automatically convert that to
> (using MySQL as the example): biz.addField("customers.`field with
> spaces`".
>
> What I'm saying is that *every* field, table name, etc., get
> 'quoted' whether it has spaces or not.
I agree: quote everything. It makes the code simpler, and eliminates the risk
of missing something, like using a \ in a table name.
I will agree it makes the resulting SQL 'ugly' and harder to read (although I
get used to it pretty quick), but I think that is a reasonable price to pay for
making the dabo code both easier to debug and also more robust.
Carl K
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
