I'm using MySQL 5 and Transfer 1.1 on CF MX 7. I have my transfer.xml
set up correctly (I think), but whenever I try to save one of my
objects, I get an SQL error that spans several pages (Java
stacktraces).
The first apparently usable info from the errors is that the following
is labeled 'SQL':
INSERT INTO userproductphotos
(photono,path,top,left,height,width,pageno,userproductkey) VALUES
( (param 1) , (param 2) , (param 3) , (param 4) , (param 5) , (param
6) , (param 7) , (param 8) )
The "top level" error is a 1064 error in the SQL near
'...pageno,userproductkey) VALUES ('.
Is there an issue with MySQL?
Here are the relevant parts of my transfer.xml:
<object name="userPrint" table="userproduct"
decorator="Bravo.PrintDecorator">
<id name="userproductkey" type="numeric" />
<property name="name" type="string" />
<property name="productkey" type="numeric" />
<property name="stylekey" type="numeric" />
<property name="userkey" type="numeric" />
<property name="istrash" type="boolean" />
<property name="path" type="string" />
<onetomany name="texts">
<link column="userproductkey"
to="userPrints.text" />
<collection type="array">
<order property="textno" />
</collection>
</onetomany>
<onetomany name="options">
<link column="userproductkey"
to="userPrints.option" />
<collection type="struct">
<key property="name" />
</collection>
</onetomany>
</object>
<object name="photo" table="userproductphotos"
decorator="Bravo.PhotoDecorator">
<compositeid>
<manytoone name="userPrint" />
<property name="pageno" />
<property name="photono" />
</compositeid>
<manytoone name="userPrint">
<link column="userproductkey"
to="userPrints.userPrint" />
</manytoone>
<property name="photono" type="numeric" />
<property name="path" type="string" />
<property name="top" type="numeric" />
<property name="left" type="numeric" />
<property name="height" type="numeric" />
<property name="width" type="numeric" />
<property name="pageno" type="numeric" />
</object>
And my decorators:
// ----- My "core" decorator with handy save/delete functions...
<cffunction name="save" access="public" output="false"
returntype="void" hint="Calls Transfer.save().">
<cfset getTransfer().save(this) />
</cffunction>
<cffunction name="delete" access="public" output="false"
returntype="void" hint="Calls Transfer.delete().">
<cfset getTransfer().delete(this) />
</cffunction>
// ----- From PrintDecorator
<cffunction name="addPhoto" access="public" output="false"
returntype="void">
<cfargument name="photono" type="numeric" required="true" />
<cfargument name="path" type="string" required="true" />
<cfargument name="top" type="numeric" required="true" />
<cfargument name="left" type="numeric" required="true" />
<cfargument name="height" type="numeric" required="true" />
<cfargument name="width" type="numeric" required="true" />
<cfscript>
var photo = '';
save();
photo = getTransfer().new("userPrints.photo");
photo.setPhotono(arguments.photono);
photo.setPath(arguments.path);
photo.setTop(arguments.top);
photo.setLeft(arguments.left);
photo.setHeight(arguments.height);
photo.setWidth(arguments.width);
photo.setPageno(0);
photo.setParentUserPrint(this);
photo.save();
</cfscript>
</cffunction>
// ----- From PhotoDecorator
<cffunction name="setParentUserPrint" access="package" output="false"
returntype="void">
<cfargument name="parent" type="any" required="true" />
<cfscript>
getTransferObject().setUserPrint(arguments.parent);
</cfscript>
</cffunction>
--~--~---------~--~----~------------~-------~--~----~
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 [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/transfer-dev?hl=en
-~----------~----~----~----~------~----~------~--~---
