[jira] Created: (OFBIZ-1044) Could not complete the Create Download as Content error

2007-05-30 Thread Malcolm Robinson (JIRA)
Could not complete the Create Download as Content error --- Key: OFBIZ-1044 URL: https://issues.apache.org/jira/browse/OFBIZ-1044 Project: OFBiz (The Open for Business Project) Issue Type:

[jira] Updated: (OFBIZ-1044) Could not complete the Create Download as Content error

2007-05-30 Thread Jacopo Cappellato (JIRA)
[ https://issues.apache.org/jira/browse/OFBIZ-1044?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jacopo Cappellato updated OFBIZ-1044: - Component/s: (was: ecommerce) product Priority: Major (was:

How to expire or delete Party?

2007-05-30 Thread kent
Now I want to expire or delete a party, but don't know how to do it. if expert know how to do it? -- View this message in context: http://www.nabble.com/How-to-expire-or-delete-Party--tf3840906.html#a10875461 Sent from the OFBiz - Dev mailing list archive at Nabble.com.

RE: Errors: findByAnd with Oracle DB

2007-05-30 Thread Michael Irving
Does anyone have a fix or work around for this problem? _ From: Michael Irving [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 29, 2007 12:28 PM To: 'dev@ofbiz.apache.org' Subject: Errors: findByAnd with Oracle DB When using findByAnd against an entity-view with an Oracle backend,

Re: Errors: findByAnd with Oracle DB

2007-05-30 Thread David E Jones
Did you see my reply to this? Did that not work? -David Michael Irving wrote: Does anyone have a fix or work around for this problem? _ From: Michael Irving [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 29, 2007 12:28 PM To: 'dev@ofbiz.apache.org' Subject: Errors: findByAnd

Re: reorder shopping list and credit card storage

2007-05-30 Thread David E Jones
The CVV/CVV2 code, which I think you are asking about, can not be persisted outside the scope of a transaction. For recurring orders this means you just can't use them. You just have to deal with the slightly higher transaction fee for transactions without the code. -David Baudia

RE: Errors: findByAnd with Oracle DB

2007-05-30 Thread Michael Irving
David, Sorry, I did see a reply from you. -Original Message- From: David E Jones [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 30, 2007 11:24 AM To: dev@ofbiz.apache.org Subject: Re: Errors: findByAnd with Oracle DB Did you see my reply to this? Did that not work? -David Michael

RE: Errors: findByAnd with Oracle DB

2007-05-30 Thread Michael Irving
David, You were right. The default settings for Oracle did not have a alias-view-columns setting at all. Using alias-view-columns=false did the trick. Since I'm not a committer, can you or someone else add alias-view-columns=false to both: localoracle and localoracledd? Thanks for your help.

Re: Errors: findByAnd with Oracle DB

2007-05-30 Thread David E Jones
Here it is again... -David David E Jones wrote: What does your datasource element look like in the entityengine.xml file? It sounds like your alias-view-columns may be incorrect, just try true instead of false or vice-versa. -David Michael Irving wrote: When using findByAnd against

Oracle outer joins

2007-05-30 Thread Michael Irving
Just an FYI for anyone using Oracle. If you set join-style=theta-oracle in the entityengine.xml, this causes outer joins to be created incorrectly. The outer join operator is in front of the column instead of behind it. If you use, join-style=ansi OFBiz works fine. For example: OFBiz

viewIndex issue: page vs component

2007-05-30 Thread Nick Rosser
Here is some background: * we are using the common visual components to manage pagination * this uses an viewIndex parameter to control which page to display (viewIndex = 2 will display the second page) Here is our problem: * we have a custom UI * on a

XML Export

2007-05-30 Thread Brady GEARRING
All, Is there a service in OFBIZ that exports a database query into XML? I am simply looking to query a table and return the results in XML so I can use it for further transformation in an application I am developing. Thanks in advance, Brady

Re: XML Export

2007-05-30 Thread Chris Howe
Hi Brady, There are several options that you can use to accomplish this depending on what you're wanting to do with it (simple, automation, reuse/flexible, etc) 1. Simple Make a controller view with encoding=none and a screen(s) that write(s) the xml structure template using freemarker. This

Re: XML Export

2007-05-30 Thread Brady GEARRING
Thank you for all the options, I have decided #2 makes the most sense for the application I am working on. I am able to run the service then factor into our code source and get back all the xml files. I would like to know how to run the query below, verses using what is in place, which reads

[jira] Created: (OFBIZ-1045) EntityOperator does not correctly construct SQL for BETWEEN clause

2007-05-30 Thread Luke Prentice (JIRA)
EntityOperator does not correctly construct SQL for BETWEEN clause -- Key: OFBIZ-1045 URL: https://issues.apache.org/jira/browse/OFBIZ-1045 Project: OFBiz (The Open for Business Project)

[jira] Commented: (OFBIZ-1045) EntityOperator does not correctly construct SQL for BETWEEN clause

2007-05-30 Thread Luke Prentice (JIRA)
[ https://issues.apache.org/jira/browse/OFBIZ-1045?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12500247 ] Luke Prentice commented on OFBIZ-1045: -- as i am working with an old SVN release (4955) i will not commit to the

[jira] Updated: (OFBIZ-1045) EntityOperator does not correctly construct SQL for BETWEEN clause

2007-05-30 Thread Luke Prentice (JIRA)
[ https://issues.apache.org/jira/browse/OFBIZ-1045?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Luke Prentice updated OFBIZ-1045: - Attachment: all-app-framework-EntityOperator.java.diff patch for 4955 this adds a new

[jira] Updated: (OFBIZ-1045) EntityOperator does not correctly construct SQL for BETWEEN clause

2007-05-30 Thread Luke Prentice (JIRA)
[ https://issues.apache.org/jira/browse/OFBIZ-1045?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Luke Prentice updated OFBIZ-1045: - Attachment: all-app-framework-EntityOperator.java.diff the same patch works for 7941 (offset)

[jira] Updated: (OFBIZ-1045) EntityOperator does not correctly construct SQL for BETWEEN clause

2007-05-30 Thread Luke Prentice (JIRA)
[ https://issues.apache.org/jira/browse/OFBIZ-1045?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Luke Prentice updated OFBIZ-1045: - Attachment: all-app-framework-EntityOperator.java.diff i meant to allow ASF on previous

Does the Forum feature work?

2007-05-30 Thread Adrian Crum
I can't seem to get forums to work. The following link: https://demo.hotwaxmedia.com/ecommerce/control/showforum produces the following error message: org.ofbiz.base.util.GeneralException: Error rendering screen [component://ecommerce/widget/ForumScreens.xml#Showforum]:

Re: Does the Forum feature work?

2007-05-30 Thread Tim Ruppert
As far as I know, Al is looking into this at the moment. Cheers, Tim -- Tim Ruppert HotWax Media http://www.hotwaxmedia.com o:801.649.6594 f:801.649.6595 On May 30, 2007, at 5:20 PM, Adrian Crum wrote: I can't seem to get forums to work. The following link:

[RFC]Redundant Order Entities

2007-05-30 Thread Chris Howe
Since OrderRole can be represented as an OrderItemRole with an empty OrderItemSeqId and OrderContact can likewise be represented as OrderItemContact with an empty OrderItemSeqId, can we deprecate (or work to deprecate) these redundant entities? ,Chris

Re: viewIndex issue: page vs component

2007-05-30 Thread David E Jones
With something like this you'll probably just have to use different parameters for the two different list elements. We done stuff like this before, but I don't know if there are any examples in the current code base. In general your data prep code and templates just need to look at different