Thought inc.

The Dynamic O/R Mapping Company
     

CocoBase Technical Support Forums
For access to developer site with software download and doc's, please request CocoBase download and password
will be emailed to you. Response to posts will appear when answered by THOUGHT Support team.
NOTE:You must register separately with forum in order to post your questions, please click on register icon below.
Home   Frequently Asked Questions   Search   Edit your profile   Registration is free!  
Email This Page to Someone!
Show a Printable Version
CocoBase Enterprise O/R Forums > CocoBase Bug Reports
bug in multi-level where clauses
< Previous Thread     Next Thread >
Author
Thread    Post New Thread     Post A Reply
steve
Member

Registered: May 2001
Posts: 16

I have created a map with the following select definition shown in the Cocobase Admin tool... (indentation removed by forum software)

select
test.c1,
test.c2
from
test
where

test.c1 = :DATA1 AND (
test.c2 = :DATA2
OR test.c2 = :DATA3)

This is good. The problem is that when I execute this mapping at runtime, the debug information shows that the query being executed is...

query = select test.c1,test.c2 from test where test.c1 = ? ( AND test.c2 = ? OR test.c2 = ? )

Obviously, the database's SQL parser croaks on this one (notice the AND is *inside* the parentheses). It looks at thought the Admin tool is interpreting the where clauses one way and the runtime library is interpreting it differently.

05-24-2001 09:20 PM
Click Here to See the Profile for steve    Find more posts by steve        Edit/Delete Message    Reply w/Quote    IP: Logged
admin
Administrator

Registered: Apr 2001
Posts: 19

This issue was identified in SR9 and we have a patch that
resolves it available to you from the support@thoughtinc.com
account. It's an issue that has an easy fix that's immediately
available. It'll be in the SR10+ releases of CocoBase
automatically - but it's available in a hotfix for SR9.

THOUGHT Support

05-25-2001 11:25 AM
Click Here to See the Profile for admin    Find more posts by admin        Edit/Delete Message    Reply w/Quote    IP: Logged
All times are PST (US)    Post New Thread     Post A Reply
Forum Jump:
< Previous Thread     Next Thread >

Forum Rules:
Who Can Read The Forum? Any registered user or guest.
Who Can Post New Topics? Any registered user.
Who Can Post Replies? Any registered user.
Changes: Messages can be edited by their author. Messages can be deleted by their author.
Posts: HTML code is OFF. Smilies are OFF. vB code is OFF. [IMG] code is OFF.

Admin Options:
Open / Close Thread
Move Thread
Delete Thread
Edit Thread

< Contact Us - THOUGHT Inc. >

Copyright © Jelsoft Enterprises Limited 2000.
Copyright 2001 All Rights Reserved, THOUGHT Inc.