[transfer-dev] Oracle timestamp field

2009-05-08 Thread pedrobl
Hi! I'm using the last version of transfer (today), with coldbox (2.6.3), and with an Oracle 10g database. I use several tables that have a Modified TIMESTAMP field. This field gets updated with the current timestamp everytime a record is modified using a trigger in the database. The problem

[transfer-dev] Re: Oracle timestamp field

2009-05-08 Thread pedrobl
here:http://docs.transfer-orm.com/wiki/Transfer_Configuration_File.cfm#pro... Mark On Sat, May 9, 2009 at 2:45 AM, pedrobl pe...@bezunartea.net wrote: Hi! I'm using the last version of transfer (today), with coldbox (2.6.3), and with an Oracle 10g database. I use several tables that have

[transfer-dev] Re: manytoone relationships in lists

2009-05-29 Thread pedrobl
PM, pedrobl pe...@bezunartea.net wrote: This surely has been asked before but, unfortunately I can't find it... I'm developing an application with coldbox, spring and transfer. All in their current latest versions. The data model is: table of Users, and a table of Orders. A user can

[transfer-dev] Re: manytoone relationships in lists

2009-05-29 Thread pedrobl
the Decorator: http://docs.transfer-orm.com/wiki/Writing_Decorators.cfm#Access_to_Tr... Mark On Fri, May 29, 2009 at 8:28 PM, pedrobl pe...@bezunartea.net wrote: Could you please give me a few samples? How can I use TQL in the model classes? I checked the examples in coldbox and transfer

[transfer-dev] SOLVED: manytoone relationships in lists

2009-05-29 Thread pedrobl
Thanks again to everyone. I leave my last questions opened, but I solved the issue, and learnt a little more about transfer :P I solved it by using the transfer.listByQuery method instead of the default transfer.list. Taking the objects described before, this is the code: ... cfset var myQuery

[transfer-dev] Filter null values

2009-07-28 Thread pedrobl
Hi! I'm using transfer current version and colbox, and I'd like to use the listByPropertyMap method to filter by null values. Can this be done not using TQL? TIA, Pedro. --~--~-~--~~~---~--~~ Before posting questions to the group please read:

[transfer-dev] Order case sensitivity

2009-08-12 Thread pedrobl
Hi! I'm using transfer with Oracle as the data backend, and I've come across an annoying problem when sorting. I have a few text fields defined in a table, and I'd like to sort by those fields but with case in-sensitivity. An example: Current order: MARS ATTACKS MORE DATA Mars attacks man on

[transfer-dev] Re: Order case sensitivity

2009-08-13 Thread pedrobl
to use some regular SQL for that one. Mark On Thu, Aug 13, 2009 at 12:20 AM, pedrobl pe...@bezunartea.net wrote: Hi! I'm using transfer with Oracle as the data backend, and I've come across an annoying problem when sorting. I have a few text fields defined in a table, and I'd like

[transfer-dev] Re: manytomany... not quite

2009-09-03 Thread pedrobl
Hi Matt! Thanks for the response... On Sep 3, 3:07 am, Matt Quackenbush quackfu...@gmail.com wrote: Can you post the relevant transfer.xml configs?  I could be mistaken, but I think the issue is that you have an o2m on one side and an m2o on the other.  AFAIK, that will not do the trick.

[transfer-dev] Re: manytomany... not quite

2009-09-03 Thread pedrobl
I already had all I needed... and a little more. I was actually making the mistake described on this page: http://docs.transfer-orm.com/wiki/Same_foreign_key_for_a_manytoone_and_a_onetomany.cfm So I removed the m2o relation from my relations' objects, the PersonOrg mentioned in previous

[transfer-dev] Re: manytomany... not quite

2009-09-04 Thread pedrobl
Hi Matt! Actually, trying to save the object PersonOrg still throws a duplicate column name error :( I thought that it was fixed because I configured a copy of the original object PersonOrgPlain in transfer.xml with no relation to Person or Org, and was saving this kind of object. What works

[transfer-dev] removemanytoone and cascadeDelete

2009-10-14 Thread pedrobl
Hi! I'm using transfer 1.1 with an application on Coldbox. Mi model: - Person (name, countryId): many2one with Country, one2Many with PersonOrg. - Org (name, countryId): many2one with Country, one2Many with PersonOrg. - PersonOrg (personId, orgId, role): role can be 'staff', 'contact',

[transfer-dev] Re: removemanytoone and cascadeDelete

2009-10-15 Thread pedrobl
Hi again Matt! Thanks for your response, On Oct 15, 3:32 am, Matt Quackenbush quackfu...@gmail.com wrote: Transfer does not allow you to have two different objects with an o2m like you are describing.  Can you please show us the relevant XML from your transfer.xml file? Here's the

[transfer-dev] Re: removemanytoone and cascadeDelete

2009-10-18 Thread pedrobl
On Oct 15, 5:25 pm, Matt Quackenbush quackfu...@gmail.com wrote: Ok, first of all, just to reiterate, you cannot use an o2m on two objects like that. You will need to use m2o and then add decorator methods to fill in the missing methods that you need. Sorry but I guess this onetomany

[transfer-dev] Modify (move) relationships

2009-11-28 Thread pedrobl
Hi! I have an organisation object with two o2m relations person and projects. In order to eliminate duplicates, I need to move the related persons and projects from one organisation to another. Is there an easy way to do this with transfer? I use two linking tables org_person, and org_project

[transfer-dev] Re: Modify (move) relationships

2009-11-30 Thread pedrobl
.  Note that this will only work if you have specified a one to many in the organization configuration and that you called organizations Organization in your transfer config. Sean On Nov 28, 10:14 pm, pedrobl pe...@bezunartea.net wrote: Hi! I have an organisation object with two o2m relations

[transfer-dev] Re: empty string is persisted in field where nullable=false

2010-08-17 Thread pedrobl
Hi Dennis, thanks for your help. On Aug 17, 11:17 pm, Dennis Clark wrote: Null values in Transfer are covered in the wiki: seehttp://docs.transfer-orm.com/wiki/Handling_Null_Values.cfm I had read the docs, but obviously didn't fully understand the consequences. If you have nullable=true

[transfer-dev] Dirty read problem

2010-08-17 Thread pedrobl
I'm having an issue where a user edits an object that does not get validated, and then another user, in another computer, requests that object's data and receives the invalid data, with the isDirty flag set. It probably has to do with the cache, so just in case this is transfer cache

[transfer-dev] Re: Dirty read problem SOLVED

2010-08-17 Thread pedrobl
OK, after reading again the documentation on caching, I thought it'd smart to discard the invalid object from the cache. Simple. It's probably in the documentation... but I'm fond of learning by making mistakes... very fond of, apparently, :) Pedro. -- Before posting questions to the group

[transfer-dev] Re: Dirty read problem SOLVED

2010-08-17 Thread pedrobl
Hi! On Aug 18, 2:11 am, Bob Silverberg wrote: An easier solution is to clone() your Transfer object before you populate it. Then the dirty data never gets into the cache. Yeap. More elegant, too. Thanks for the quick response, Pedro. -- Before posting questions to the group please read:

[transfer-dev] Date precision Postgresql vs. Oracle

2010-08-26 Thread pedrobl
Hi there! I have 2 systems for development. Some of the software is the same in both (transfer 1.1, coldbox 2.6.4), but the database server is Oracle 10g in one, and postgresql 8.4 in the other. I'd like the dates to be shown with the time also. I have a transfer.list that shows a date and

[transfer-dev] Re: Date precision Postgresql vs. Oracle

2010-08-27 Thread pedrobl
Hi Mark! On Aug 27, 1:29 am, Mark Mandel wrote: So this is just on retrieval, and just on list operations? On both. I've just tested it. I'm trying to display what comes from the list (myTimeStamp), or from the get() entry using: DateFormat(myTimeStamp,/MM/DD) TimeFormat(TimeStamp,

[transfer-dev] Re: Date precision Postgresql vs. Oracle

2010-08-27 Thread pedrobl
Oops! I meant: DateFormat(myTimeStamp,/MM/DD) TimeFormat(myTimeStamp, HH:mm:ss) Pedro. -- Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer Try out the new Transfer ORM Custom Google Search:

[transfer-dev] Re: Date precision Postgresql vs. Oracle

2010-08-27 Thread pedrobl
And also, the version for the coldfusion/drivers/ojdbc14.jar, from its MANIFEST file: Specification-Title:Oracle JDBC driver classes for use with JDK14 Created-By: 1.4.2_08 (Sun Microsystems Inc.) Implementation-Title: ojdbc14.jar Specification-Vendor: Oracle Corporation

[transfer-dev] Re: Date precision Postgresql vs. Oracle

2010-08-27 Thread pedrobl
Your question on jdbc Driver version was on the right track. I found a known problem with the jdbc drivers provided by adobe. Interesting discussion: http://www.justskins.com/forums/cfmx-and-oracle-10g-128214.html I'll see if I can convince IT to modify Coldfusion's bootup options. Another

[transfer-dev] Re: Date precision Postgresql vs. Oracle

2010-08-27 Thread pedrobl
I installed CF7 on the machine I have postgres, and it works just fine, it shows the date and time correctly. The problem is then with the oracle jdbc driver in coldfusion. I have also tried to change the field to timestamp in oracle. This provokes a JAVACast exception that I'll try to check on

[transfer-dev] No records returned: CF7 and oracle

2011-01-03 Thread pedrobl
Happy new year everyone! I left last year with a strange problem that probably has an easy solution which I fail to see. I'm using Coldbox, Coldspring, Transfer and Oracle 10g. I have stumbled upon a few driver issues, and this probably has something to do with it. First, the table: sessions,

[transfer-dev] Re: No records returned: CF7 and oracle

2011-01-04 Thread pedrobl
as expected, both return 1 row, on the other hand if transfer runs them, they return no rows... WTF? I am at a loss here, I don't know what else to try. This doesn't make any sense!! Pedro. On Jan 4, 12:30 pm, pedrobl pe...@bezunartea.net wrote: On Jan 4, 12:18 pm, Mark Mandel mark.man...@gmail.com

[transfer-dev] Re: No records returned: CF7 and oracle SOLVED

2011-01-04 Thread pedrobl
I found it!!! The problem was that the token field was defined as CHAR 36, and the token generated was 35 characters long. The token was being stored with an space at the end. What I still don't understand is why when transfer runs the query select PERSON_ID from NW_SESSIONS where SESSION_TOKEN

[transfer-dev] Re: Non case sensitive searches

2011-04-20 Thread pedrobl
Oops! I should've checked previous posts carefully. I saw that you have a feature request in that sense... Can I help? I'd really like to see this implemented. Pedro. On Apr 21, 2:03 am, pedrobl pe...@lopezredondo.net wrote: Hi all, First thing, the system: Coldfusion MX7, Oracle 10g

[transfer-dev] Re: Transfer/MySQL saving 0 as NULL in int field

2011-08-17 Thread pedrobl
Hi Brian, What you need to do is to set an integer value that represents the null value in coldfusion. You can do this by setting the nullvalue attribute in your property. In your case: property name=milliseconds type=numeric nullable=true nullvalue=- / This tells transfer that it should

[transfer-dev] Non case sensitive searches, revisited

2011-08-28 Thread pedrobl
Last April I offered my time to solve this issue but, unfortunately didn't receive any responses. The time has come for me to solve this issue once and for all. I'd really appreciate any feedback. The problem: Transfer does not support functions, so it's not possible to do non case sensitive