Re: [transfer-dev] Transfer EmptyQueryException

2010-01-31 Thread Tom McNeer
Hi,

On Fri, Jan 29, 2010 at 7:49 PM, Dorioo dor...@gmail.com wrote:

 Are you using the SVN version?


I was not. But I was using the slightly earlier version (e, I think, I
opposed to g) which I had been using on my development server. So I was
using a version that had been working with CF9 with no issues.

And of course, this shouldn't have been an issue, since my test with a .cfm
page used the same versions of Transfer and Coldspring as the Flex calls
(not just the same versions, but the same running instances). Yet the .cfm
calls worked, and the Flex calls failed

I updated to the SVN version on the new server anyway, and the
EmptyQueryExceptions seemed to go away. But I'm now seeing unexpected and
inconsistent Java errors, mostly NullPointerExcpetions.

I'm going to continue testing; but if anyone has any insight, I'd love to
hear it. The only real difference I can find right now between this new
server and my dev environment is that the server is 64-bit

-- 
Thanks,

Tom

Tom McNeer
MediumCool
http://www.mediumcool.com
1735 Johnson Road NE
Atlanta, GA 30306
404.589.0560

-- 
Before posting questions to the group please read:
http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer

You received this message because you are subscribed to the Google Groups 
transfer-dev group.
To post to this group, send email to transfer-dev@googlegroups.com
To unsubscribe from this group, send email to 
transfer-dev+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/transfer-dev?hl=en


[transfer-dev] onetomany and column specified twice error

2010-01-31 Thread Scott Brady
I understand when doing a manytoone relationship that you can't have this:

object name=Order
   id name=id type=numeric /
   property name=fkiduser type=numeric /
   onetomany name=User
  link column=fkiduser to=user.User /
   /onetomany
/object

because you need to remove the fkiduser property.

However, I'm having the issue in a onetomany relationship and can't
figure out a way around it.  The doc state you need to remove the
property, but given how onetomany relationships are set up in the XML,
I don't know how to accomplish that.

So, if the configuration was like the following, how would you get rid
of that error when doing an insert?
object name=owners table=owners
id name=ownerID column=ownerID type=numeric generate=false /
onetomany name=dogs
link to=dogs column=ownerID /
collection type=array
order property=dogID order=asc /
/collection
/onetomany
/object

object name=dogs table=dogs
id name=dogID column=dogID type=numeric generate=false /
property name=ownerID type=numeric column=ownerID 
nullable=false /
/object

[The error occurs when trying to insert a new dog]

I can't remove the ownerID property from the dogs object, because
then it tries to insert a null, and I don't know how to set it (since
there's no setter or getter for that property).

Maybe I'm just not understanding how this is supposed to work (updates
work, but that's probably because the update statement has the column
listed twice, but that doesn't throw an error)

Scott
-- 
-
Scott Brady
http://www.scottbrady.net/

-- 
Before posting questions to the group please read:
http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer

You received this message because you are subscribed to the Google Groups 
transfer-dev group.
To post to this group, send email to transfer-dev@googlegroups.com
To unsubscribe from this group, send email to 
transfer-dev+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/transfer-dev?hl=en


Re: [transfer-dev] onetomany and column specified twice error

2010-01-31 Thread Mark Mandel
On Mon, Feb 1, 2010 at 10:34 AM, Scott Brady dsbr...@gmail.com wrote:

 I understand when doing a manytoone relationship that you can't have
 this:

 object name=Order
   id name=id type=numeric /
   property name=fkiduser type=numeric /
   onetomany name=User
  link column=fkiduser to=user.User /
   /onetomany
 /object

 because you need to remove the fkiduser property.

 However, I'm having the issue in a onetomany relationship and can't
 figure out a way around it.  The doc state you need to remove the
 property, but given how onetomany relationships are set up in the XML,
 I don't know how to accomplish that.

 So, if the configuration was like the following, how would you get rid
 of that error when doing an insert?
 object name=owners table=owners
id name=ownerID column=ownerID type=numeric generate=false
 /
onetomany name=dogs
link to=dogs column=ownerID /
collection type=array
order property=dogID order=asc /
/collection
/onetomany
 /object

 object name=dogs table=dogs
id name=dogID column=dogID type=numeric generate=false /


 This property shouldn't be here, this is your problem.

property name=ownerID type=numeric column=ownerID
 nullable=false /
 /object

 [The error occurs when trying to insert a new dog]

 I can't remove the ownerID property from the dogs object, because
 then it tries to insert a null, and I don't know how to set it (since
 there's no setter or getter for that property).


Check out the documentation for manageing o2m relationships:
http://docs.transfer-orm.com/wiki/Managing_Relationships_and_Compositions.cfm#OneToMany

You need to set a the parent on the child.



 Maybe I'm just not understanding how this is supposed to work (updates
 work, but that's probably because the update statement has the column
 listed twice, but that doesn't throw an error)


-- 
E: mark.man...@gmail.com
T: http://www.twitter.com/neurotic
W: www.compoundtheory.com

Hands-on ColdFusion ORM Training @ cf.Objective() 2010
www.ColdFusionOrmTraining.com/

-- 
Before posting questions to the group please read:
http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer

You received this message because you are subscribed to the Google Groups 
transfer-dev group.
To post to this group, send email to transfer-dev@googlegroups.com
To unsubscribe from this group, send email to 
transfer-dev+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/transfer-dev?hl=en


Re: [transfer-dev] onetomany and column specified twice error

2010-01-31 Thread Scott Brady
Thanks!  It was the setParent method that I was missing.

I'd even read that part of the docs before, but I guess I hadn't quite
understood it.

Scott


-- 
-
Scott Brady
http://www.scottbrady.net/

-- 
Before posting questions to the group please read:
http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer

You received this message because you are subscribed to the Google Groups 
transfer-dev group.
To post to this group, send email to transfer-dev@googlegroups.com
To unsubscribe from this group, send email to 
transfer-dev+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/transfer-dev?hl=en