Re: Display a resultset in an .ftl file

2007-08-06 Thread David E Jones
Have you tried the performance of the ProductSearch stuff, or more specifically the keyword search part of it, to see if it is adequate? This does sound like a special case where direct JDBC is the way to go. That just means you'll have some development to do as you can't use the tricks in th

Re: Debugging new component in eclipse

2007-08-06 Thread Rizwan Sharif
I am debugging ofbiz from within eclipse and I also added .classpath entry related to components source but now I am getting error that javac is missing just for my component, rest of the ofbiz is compiling without any issue. On 8/7/07, Brett Palmer <[EMAIL PROTECTED]> wrote: > > Rizwan, > > You n

Re: Display a resultset in an .ftl file

2007-08-06 Thread Richard Fleming
David - Maybe you can help me... I need to query the products table and return 20 or so possible product ids from the following customer input - "I need a maytag belt set for my maytag washer" The columns involved in the query are productid, internal_name, brand_name, description, long_des

Re: Display a resultset in an .ftl file

2007-08-06 Thread Jonathon -- Improov
Rick, Doesn't sound too hard to put @@ into EntityOperator. Would you like to try it? I can at most help by pointing out all the lines of codes that you need to fiddle with. Jonathon Richard Fleming wrote: David, Thanks for the reply. I'd love to use the entity engine. But because the @@ o

Re: Display a resultset in an .ftl file

2007-08-06 Thread David E Jones
The point would be to step back and define what sort of data you'd like to get from the database and find another way for form the query. -David Richard Fleming wrote: David, Thanks for the reply. I'd love to use the entity engine. But because the @@ operator for tsearch's isn't part of th

Re: Display a resultset in an .ftl file

2007-08-06 Thread Richard Fleming
David, Thanks for the reply. I'd love to use the entity engine. But because the @@ operator for tsearch's isn't part of the jdbc driver for postgres, I think I'm stuck. Is there a way within the entity engine to create a custom sql statement and then add it as an entity-condition tag or whate

Re: Display a resultset in an .ftl file

2007-08-06 Thread Jonathon -- Improov
Hi Rick, > If you can't find anything there I'd recommend creating an implementation of > the Iterator or List interfaces to wrap the ResultSet object, like we have > with the EntityListIterator in OFBiz. David's suggestion is the way to go if you absolutely must use your own "SQL processor". Th

Re: Conditions in table joiners

2007-08-06 Thread Jonathon -- Improov
David, Yeah, I would've thought that too, definitions should model only static structure. Given my first example, I would like to do a query like "find a Group that has all 3 kinds of members (LEADER, VICE, MEMBER)". Or even more complex: "find a Group where a/the leader's name is like Blah,

Re: Display a resultset in an .ftl file

2007-08-06 Thread David E Jones
This is more of a question about JDBC and FTL, ie somewhat independent of OFBiz. The freemarker.org site or searching on google might have some helpful tips on using a ResultSet object with FTL. I'm not aware of anything, but haven't looked. If you can't find anything there I'd recommend creat

Re: Display a resultset in an .ftl file

2007-08-06 Thread Richard Fleming
Johathon, I used a sqlprocessor object to grab a connection to the default delegator. I could then type in my own sql and add the @@ operator that I need to use. I tried to just <#list resultset as parts> but got a strange error. Maybe I should just convert the resultset to a collection? Rick

Re: Display a resultset in an .ftl file

2007-08-06 Thread Jonathon -- Improov
Rick, Consider using BeansWrapper? As I said, I've tested <#list> to work with Collection(s), not sure about ResultSet(s). See freemarker manual on BeansWrapper. Jonathon Richard Fleming wrote: Rodrigo, Thanks for the reply.. but I can't use the delegator object. I have to use a jdbc connec

Re: Conditions in table joiners

2007-08-06 Thread David E Jones
In general entity and view entity definitions are meant to model structure, not query constraints. Just add your desired constraints to the EntityCondition passed into the findByCondition call (or Map for findByAnd or whatever). -David Jonathon -- Improov wrote: Hi Rodrigo, Are you absolut

Re: Display a resultset in an .ftl file

2007-08-06 Thread Richard Fleming
Rodrigo, Thanks for the reply.. but I can't use the delegator object. I have to use a jdbc connection so that I can query the database with a non standard operator (@@). The delegator doesn't support calling this operator. My life would be much easier if it did. So I create a database connection

Re: Display a resultset in an .ftl file

2007-08-06 Thread Jonathon -- Improov
Hi Rick, Just FYI, a ResultSet is ALREADY a... well... result set generated by a delegator. So, I'm sure you did use a delegator before hitting the .ftl. The freemarker list tag takes in sequences. I've tested this to work with Collection(s). Not sure about ListIterator or Iterator or even Re

Re: Conditions in table joiners

2007-08-06 Thread Jonathon -- Improov
Hi Rodrigo, Are you absolutely sure that works? First, your suggestion throws an exception. Note that there is no such field as Member.leaderId. Second, do take a look at SqlJdbcUtil.java method makeFromClause(). That's where you'll see the joins being made. You'll also see that this isn't po

Re: Display a resultset in an .ftl file

2007-08-06 Thread Rodrigo Souza
User delegator to data layer. Not use in .ftl files. 2007/8/6, Richard Fleming <[EMAIL PROTECTED]>: > Hello all- > > I've put together a bsh script that puts a java.sql.resultset into the > context. How do I create a list tag in my freemarker file to display the > resultset? > > Thanks > Rick >

Display a resultset in an .ftl file

2007-08-06 Thread Richard Fleming
Hello all- I've put together a bsh script that puts a java.sql.resultset into the context. How do I create a list tag in my freemarker file to display the resultset? Thanks Rick

Re: Debugging new component in eclipse

2007-08-06 Thread Brett Palmer
Rizwan, You need to make sure your remote connection is setup in the same eclipse project as the component you are debugging or it can miss it. If you set it up this way you can also debug the default ofbiz code as well because your project likely depends on it. This problem occurs if you have mu

Re: Cancel shipment

2007-08-06 Thread Iain Fogg
David, You're absolutely right. As I was digesting your reply it dawned on me that a critical point I didn't make was that the shipments I'm talking about aren't even in the PACKED state yet. Cheers, Iain David E Jones wrote: iain wrote: As you can see, this highlights the fact that our w

Re: GIS anyone?

2007-08-06 Thread David E Jones
That's really cool stuff Al. I'm not aware of any other efforts based on this, so yeah, if anyone is working on this kind of stuff please do share! -David Al Byers wrote: I have gotten quite involved with GIS lately and just wanted to ping the lists to see if there was any interest out there

Re: Quality of bug reports on Apache.org

2007-08-06 Thread BJ Freeman
I got this email. not sure it is legit. don't remember posting bugs since moved to apache any input Sascha (Sascha Just <[EMAIL PROTECTED]>)Just sent the following on 8/6/2007 9:33 AM: > Dear BJ Freeman, > > We are writing to you because you reported a substantial number of bugs to > the Apache

GIS anyone?

2007-08-06 Thread Al Byers
I have gotten quite involved with GIS lately and just wanted to ping the lists to see if there was any interest out there. I have been writing an WFS server interface for OFBiz and a GeoRSS service. The WFS server will allow you to use open source software, such as MapBuilder, to overlay points of

Re: Debugging new component in eclipse

2007-08-06 Thread Jacques Le Roux
Check, the file .classpath Jacques De : "Rizwan Sharif" <[EMAIL PROTECTED]> > Hi, > I am able to debug the ofbiz + components that comes with it but unable to > debug the component that I have added. When I call one of the services in > new component it runs successfully but does not break into t

Re: Cancel shipment

2007-08-06 Thread David E Jones
iain wrote: As you can see, this highlights the fact that our workflows and practices _in this scenario_ are somewhat different to those assumed in your reply. Yeah, very different. On a side note not totally relevant to this thread: that would have been helpful information in getting your

Re: Conditions in table joiners

2007-08-06 Thread Rodrigo Souza
Add to your code: i.e > > > 2007/8/6, Jonathon -- Improov <[EMAIL PROTECTED]>: > In view-entity(s), is it possible to have conditionals in ? > > For eg, an entity Group can have 3 types of members: "LEADER", "VICE" and > "MEMBER". > > I've included my thoughts in the c

Debugging new component in eclipse

2007-08-06 Thread Rizwan Sharif
Hi, I am able to debug the ofbiz + components that comes with it but unable to debug the component that I have added. When I call one of the services in new component it runs successfully but does not break into the debugger. Is there something I forgot to configure? Rizwan

Conditions in table joiners

2007-08-06 Thread Jonathon -- Improov
In view-entity(s), is it possible to have conditionals in ? For eg, an entity Group can have 3 types of members: "LEADER", "VICE" and "MEMBER". I've included my thoughts in the crude example below (please ignore syntax errors).

Re: Multiple Companies

2007-08-06 Thread Rizwan Sharif
If I also create departments and divisions in it how will i differentiate? should I also create PartyRole with role type "Company"? On 8/6/07, Mike Wong @ Finepoint <[EMAIL PROTECTED]> wrote: > > Use the "Party Manager" to create a new "Party Group" and assign 'Internal > Organization' role to t

Re: Hello3 Application does not run !

2007-08-06 Thread Walter Vaughan
vijay Si wrote: > I have been trying to run my hello3 application from hot-deploy You didn't read all the instructions... Did you read this page as well? http://www.opensourcestrategies.com/ofbiz/hello_svn_fixes.php -- Walter

possible to change this into a web service call?

2007-08-06 Thread jin1212
Hello, I have a question about the following request-map element inside controller.xml: is it possible to change the event into a web service call so I can call 'createOrder' remotely from another server? I know it's possible if the event t

Re: Shipment amount override

2007-08-06 Thread iain
Jacques, I'll have to jump onto my dev system to check this out - on our production system there's no ability to mod the S&H value... Thanks for the pointer to a possible solution... Cheers, Iain Jacques Le Roux wrote: Iain, I'm not sure of your need but if it's an UI need you could use th

Re: Cancel shipment

2007-08-06 Thread iain
Scott, Yep, it's a retail BO reservation situation. Things'd be easily handled if we could UNISSUE items from a shipment - not sure why that capability isn't available since you can manipulate just about everything else on a shipment (eg, packages). Obviously, there could be some contraint on

Hello3 Application does not run !

2007-08-06 Thread vijay Si
Hi friends, I have been trying to run my hello3 application from hot-deploy but it give me error : hello3 not available error code 400 Also i downloaded the hello3 app and tried out, but still no luck Please let me know if i have to do some additional settings. Regards Vijyendra

Re: Cancel shipment

2007-08-06 Thread iain
David and Jacques, Thanks for the responses. >> Wow, that's a level of service I've never heard of a retailer offering. That is precisely a service level we do offer (on a case-by-case basis). It builds customer loyalty, and if cancelled items are easily resold to other customers - no big dea

RE: Multiple Companies

2007-08-06 Thread Mike Wong @ Finepoint
Use the "Party Manager" to create a new "Party Group" and assign 'Internal Organization' role to this Party Group. Cheers Mike -Original Message- From: Rizwan Sharif [mailto:[EMAIL PROTECTED] Sent: Monday, August 06, 2007 5:17 PM To: user@ofbiz.apache.org Subject: Multiple Companies Hi,

Re: how can i switch to oracle

2007-08-06 Thread Jacques Le Roux
Look into entityengine.xml (and please read the doc !) http://docs.ofbiz.org/display/OFBADMIN/OFBiz+Documentation+Index Jacques De : "amit charaya" <[EMAIL PROTECTED]> > > how can i use oracle database with ofbiz > > -- > View this message in context: > http://www.nabble.com/how-can-i-switch

Re: how can i switch to oracle

2007-08-06 Thread Gautam Deb
In your entityengine.xml file just create a new datasource pointing to oracle database. Then in the 'default' delegator just use the new datasource name. That way your ofbiz is now hooked up with oracle. Regards, Gautam Deb On 8/6/07, amit charaya <[EMAIL PROTECTED]> wrote: > > > how can i use or

how can i switch to oracle

2007-08-06 Thread amit charaya
how can i use oracle database with ofbiz -- View this message in context: http://www.nabble.com/how-can-i-switch-to-oracle-tf4223050.html#a12013230 Sent from the OFBiz - User mailing list archive at Nabble.com.

Multiple Companies

2007-08-06 Thread Rizwan Sharif
Hi, Does ofbiz support multiple companies? if yes how can i add multiple companies? Rizwan

Re: Cancel shipment

2007-08-06 Thread Scott Gray
Hi Ian Are the goods actually being shipped or is this more of a retail backorder reservation arrangement? If it's the latter then I would either settle for creating a return for the order or otherwise perhaps look into finding a way to use pick lists to pick the order and not pack it until the c

Re: Cancel shipment

2007-08-06 Thread Jacques Le Roux
Thanks for comment David, Pretty clear ! ;o) Jacques De : "David E Jones" <[EMAIL PROTECTED]> > > Wow, that's a level of service I've never heard of a retailer offering. It's > basically saying that we've packed and labeled your box and it's sitting on the loading dock but the carrier hasn't pi

Re: error meassage

2007-08-06 Thread Jacques Le Roux
Did you try to use CheckErrors just after the store ? But I guess it's too late and the transaction has already been rolled back. So you will need to check the Id before storing... Jacques De : "amit charaya" <[EMAIL PROTECTED]> > > I want to insert a row in table using simple method. I enter d