----- Original Message ----- From: "Christian Haul" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, April 06, 2002 6:47 PM Subject: Re: Logicsheet Woes with Esql and XSP Logic
> On 05.Apr.2002 -- 10:59 PM, Sharat Koya wrote: > > Hi help on this problem would be much appreciated since I have been stuck > > with it for a few days of coding. > > I have a logicsheet that runs mysql statments and returns values from the > > database. > > > > In my logic (in the file using the logic sheet) I have the statment that > > trys to assign a value from the database. I have tested my logicsheet on its > > own and it works fine, however Cocoon returns the error below when I try to > > assign the value to a java variable. can anyone help? > > > > thanks > > > > Sharat Koya > > > > Calling code > > mercurySun = <eclipse-data:get-planet-data data="sundist" name="Mercury"/>; > > -------------- > > Error: > > org.apache.cocoon.ProcessingException: Language Exception: > > org.apache.cocoon.components.language.LanguageException: Error compiling > > register_xsp: > > Line 1652, column 4: illegal start of expression > > Line 0, column 0: > > 1 error > > -------------- > > This is the segment of code where the error occurs: > > > > line 1652: > > mercurySun = > > if (_esql_connection != null) > > {_esql_connections.push(_esql_connection); > > > > } > > _esql_connection = new EsqlConnectionCocoon2(); > > try { > > try { > > _esql_connection.datasource = (DataSourceComponent) > > _esql_selector.select(String.valueOf( "" + (database) )); > > _esql_connection.connection = > > _esql_connection.datasource.getConnection(); > > } catch (Exception _esql_exception_N10170) { > > getLogger().error("Could not get the > > datasource",_esql_exception_N10170); > > throw new RuntimeException("Could not get the datasource > > "+_esql_exception_N10170); > > } > > > > Sharat, > your logicsheet seems to expand <eclipse-data:get-planet-data/> to more that > a simple <esql:get-XXX/>. You should create a tag that does all the connection > setup and nest the <eclips-data:get-planet-data/> inside. > > Chris. > > -- > C h r i s t i a n H a u l > [EMAIL PROTECTED] > fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08 > > --------------------------------------------------------------------- > Please check that your question has not already been answered in the > FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> > > To unsubscribe, e-mail: <[EMAIL PROTECTED]> > For additional commands, e-mail: <[EMAIL PROTECTED]> > > The function <eclipse-data:get-planet-data data="sundist" name="Mercury"/> expands as follows: connect to the database using esql and return the value as a double. All the function does is return the value from the database without any surronding tags. Since I first posted this message I changed the function so that instead of assigning mercurySun (java double variable) as follows: mercurySun = <eclipse-data:get-planet-data data="sundist" name="Mercury"/>; I now have: <eclipse-data:get-planet-data data="sundist" name="Mercury" variable="mercurySun"/> where the function in the logicsheet assigns assigns the value. This works fine, I'm still not that advanced in using Cocoon and so cannot workout why I can't assign the value in the calling XSP file rather than the logicsheet. If you can it would be aprreciated. It is a bit annoying to do the above but it has shortend my code by quite a considerable amount compared to entering a multitude of esql commands and logic. Thanks Sharat Koya --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>