What is the exact error from mySQL? I'm going to guess that 'TOP' is a reserved word, but without the error I'm not sure.
Mark On Sat, Dec 13, 2008 at 9:17 AM, Ken Cummins <[email protected]> wrote: > > 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> > > > > -- E: [email protected] W: www.compoundtheory.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 [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 -~----------~----~----~----~------~----~------~--~---
