[Osage-users] Re: InstantDB: sql syntax problem

[george s. <geo...@ya...>]

Hi,

Please see Peter Hearty's comments below.

Because of this, osage doesn't generate correct syntax
for the "LIKE" condition with InstantDB when the
ignore case attribute is specified for an sql element.

Thanks to Tom Copeland for reporting this problem

Regard, george

--- Peter Hearty <pet...@lu...> wrote:
> George
> 
> InstantDB only allows constants in the right hand
> side of LIKE clauses. So
> 
> ...WHERE UPPER(prod.name) LIKE "MY_PRODUCT"
> 
> would be OK, but general expressions, such as "UPPER
> (?)", are,
> unfortunately, not currently allowed. You can do a
> case insensitive match
> using:
> 
> ...WHERE UPPER(prod.name) LIKE "?" IGNORE CASE
> 
> though.
> 
> On a related note, functions, such as UPPER, don't
> generally appear in
> InstantDB's syntax definition. Functions can be
> added or removed by users as
> needed and are loaded by InstantDB at runtime. See
>
http://instantdb.enhydra.org/software/documentation/user.html
> for more
> details.
> 
> Regards
> 
> Pete
> 


__________________________________________________
Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere!
http://mail.yahoo.com/