The fact that the code generation bits can be called as a web service allows a pretty high degree of flexibility. Sure it's easy to come back to my site and use what I've built, but surely, someone could build a better interface to my code generation methods, or integrate their own code generation apps. The interface I've built is not exactly where I want it right now (hence the Alpha label). It's poor on explanation on a lot of levels. With your modification, it's failing because of a couple of things: Foreign keys must be named exactly the same is the primary key in the foreign table. So, the foreign key cat_id in the "localTable" must have a matching primary key in "foreignTable". Also, the FK/PK columns must be something_id (with emphasis on the underscore). Again, this is not ideal, and the only place where it's an issue is when joins are concerned. Currently the interface fails if the join query can't be created. Not ideal. Aaron Johnson made some good suggestions of where this app can go, and it's actually not hard at all because I've created each "snippet" generator in it's own method (that can also be access via a webservice call). http://cephas.net/blog/archives/000297.html#000297 Now, when I can actually find time to do it is another question. -----Original Message----- From: rudy [mailto:r937 at interlog.com] Sent: Saturday, March 01, 2003 5:03 AM To: thelist at lists.evolt.org Subject: Re: [thelist] ColdFusion code generator one of these days i simply must read up on web services why would i want a code generator as a web service? can't i just bookmark your page and come back to it, michael? anyhow, here's my a small modification of your sample code -- "COLUMNNAME","DATATYPE","ISFK","ISPK","LENGTH","TABLENAME", "id","int","false","true","","localTable", "fname","varchar","false","false","100","localTable", "lname","varchar","false","false","100","localTable", "catid","int","true","false","","localTable", "id","int","false","true","","foreignTable", "descr","varchar","false","false","20","foreignTable", the part that is not clear to visitors is whether that first line needs to be in there or not, and whether the trailing comma isn't really a typo but your sample code runs, and my slight modification won't thought i'd let you know contact me offlist if you want me to do additional testing nice job rudy -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt !