Hi everyone I wrote some CF code and I was hoping I could get your opinions on it and maybe some suggestions as how it can be better. I use this quite a bit and it has some issues to which I will try and point them out little later in this email. Ok here is the story behind my code, I had to write a ton of cfforms that process through a process page to a CFC and each cfform was a reusable form, I also have my code write the sql for my DBA to create the table outputting it as a txt file at the root. So instead of writing all this code over and over or copy and pasting and renaming code I decided to write some code that will generate the code for me.
Here are some of the Key features, 1, Generates Form Processing page to submit to the CFC, and will look for this page and append the form code if formProcess.cfm already exists 2, Generates the CFC to view, insert and update to the table in the database ( have not added delete but its simple enough to do) 3, Appends code back to the form to make it a reusable form 4, Generates an SQL.TXT file so that you can had to your DBA to have the tables created or execute the sql yourself; It will also append additional sql if the sql.txt file exists. Issues / limitations, 1, The code requires that a table name have an underscore in it (Tbl_name) 2, I have noticed that when generating the SQL code in the CFC the last value in the sql insert and update code will have a comma at the end when it should not. I'm sure there are more issues but please try it out and please let me know how I can improve it DISCLAMER!!! I am not the greatest speller so if by chance I have miss spelled something in the notes let me know and please don't make it a lesson okay :) Ernest Pena Jr. Application Systems Analyst M.D. Anderson Cancer Center Division of Cancer Medicine IT Application Development FC10.2005 [email protected] O: 713 563 8933 C: 832 452 5547 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the "Houston ColdFusion Users' Group" discussion list. To unsubscribe, send email to [email protected] For more options, visit http://groups.google.com/group/houcfug?hl=en -~----------~----~----~----~------~----~------~--~---
snipet.txt
Description: snipet.txt
