Yeah, looks like TOP is a reserved word. Mark
On Sat, Dec 13, 2008 at 9:53 AM, <[email protected]> wrote: > Feel free to see for yourself: > > http://ken.dev8.leepfrog.com/Bravo/ > > On Dec 12, 2008 4:39pm, Mark Mandel <[email protected]> wrote: >> >> >> 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: >> >> > >> >> > >> > decorator="Bravo.PrintDecorator"> >> >> > >> >> > >> >> > >> >> > >> >> > >> >> > >> >> > >> >> > >> >> > >> >> > >> > to="userPrints.text" /> >> >> > >> >> > >> >> > >> >> > >> >> > >> >> > >> > to="userPrints.option" /> >> >> > >> >> > >> >> > >> >> > >> >> > >> >> > >> >> > >> > decorator="Bravo.PhotoDecorator"> >> >> > >> >> > >> >> > >> >> > >> >> > >> >> > >> >> > >> > to="userPrints.userPrint" /> >> >> > >> >> > >> >> > >> >> > >> >> > >> >> > >> >> > >> >> > >> >> > >> >> > >> >> > >> >> > And my decorators: >> >> > // ----- My "core" decorator with handy save/delete functions... >> >> > >> > returntype="void" hint="Calls Transfer.save()."> >> >> > >> >> > >> >> > >> >> > >> > returntype="void" hint="Calls Transfer.delete()."> >> >> > >> >> > >> >> > >> >> > >> >> > // ----- From PrintDecorator >> >> > >> > returntype="void"> >> >> > >> >> > >> >> > >> >> > >> >> > >> >> > >> >> > >> >> > 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(); >> >> > >> >> > >> >> > >> >> > // ----- From PhotoDecorator >> >> > >> > returntype="void"> >> >> > >> >> > >> >> > getTransferObject().setUserPrint(arguments.parent); >> >> > >> >> > >> >> > >> >> > > >> >> > >> >> >> >> >> >> >> >> -- >> >> E: [email protected] >> >> W: www.compoundtheory.com >> >> >> >> >> >> >> -- 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 -~----------~----~----~----~------~----~------~--~---
