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 Questions
Generating CCB map with conditional inner select statement
< Previous Thread     Next Thread >
Author
Thread    Post New Thread     Post A Reply
BHLossini
Member

Registered: Jun 2005
Posts: 7

Our installation is using CocoBase 4.5.
Can you please tell me what the Cocobase XML map definition would look like for this select statement? The issue is how to bind the variable COLUMN_01 for the inner select. If I specify :COLUMN_01 within the map for the inner select where clause, I get a "ORA-01008: not all variables bound" error. I know that there may be alternatives within the Cocobase software to accomplish the same result but without stating the details, I would like to implement this within the map definition itself.
thank you

SELECT
RN,
COLUMN_01,
COLUMN_02,
COLUMN_03
FROM
(
SELECT
ROWNUM RN,
COLUMN_01,
COLUMN_02,
COLUMN_03
FROM
TABLE_NAME
WHERE
COLUMN_01 = 'ABCDEF'
ORDER BY
COLUMN_02
)
WHERE
RN BETWEEN 2 AND 4;


05-08-2006 12:37 PM
Click Here to See the Profile for BHLossini    Find more posts by BHLossini        Edit/Delete Message    Reply w/Quote    IP: Logged
admin
Administrator

Registered: Apr 2001
Posts: 19

Can you please us CocoAdmin and do a file export of this map as an xml file and email it to support@thoughtinc.com? Also, what does your java code look like that initiates the query - do you have any variables set? And can you also send us the java file of the class you're passing into your QBE or returning from it?

The use of _ and numbers in your field labels can cause some issues related to how the java naming versus label naming occurs. If we see your map definition, we can better guide you to the best choice naming convention wise.

THOUGHT Support

05-08-2006 01:01 PM
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.