I wrote a program about two years ago that could analyse a database, and create a functional web site consisting of pages for each table that allowed selecting a record to edit, editing a record, as well as adding a new record or deleting one.  It did so by creating all the SQL statements that were necessary, gave you the option of using CFQUERY or CFSTOREDPROC (and creating the scripts for the stored proc).  The program was never intended to create a commercial level application, but to create a starting point from where the detailed business rules could be applied while minimizing the time to develop the lower level data access.


In answer to Emmet's questions, the program did handle foriegn keys properly (i.e. if a field was a foreign key, then a select box was used instead of a text box, and the select box was populated from the related table).  So, yes, it's possible to handle this type of situation.


Shawn


(PS.  The next generation of the above mentioned program is being developed and has started beta testing.  If you're curious, you can get more inforamation from http://www.open2space.com/code_mystic. This site is being expanded on almost daily, and should include documentation fairly soon.)

-----Original Message-----
From: Emmet McGovern [mailto:[EMAIL PROTECTED]
Sent: Friday, June 04, 2004 1:06 PM
To: CF-Talk
Subject: RE: TRIMMED: whats your opinion on this cfm program?

I'm too lazy check the app out right now.  I'm curious to know if it
handled the relations in the database the way it was supposed to?

-emmet

  _____  

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, June 04, 2004 2:56 PM
To: CF-Talk
Subject: TRIMMED: whats your opinion on this cfm program?

ok, i just had a client ask me why they shouldnt just buy this program
http://www.hkvstore.com/cfmmaker/
so i downloaded it, ran it against their db & in about 10 seconds had a
fairly complete site, couldnt believe it. Of course it needed a few
tweaks
and a face lift but the code seemed fairly decent, complete with user
logins, file uploads, form validations, htmlarea integrated, pop up
calanders.
Maybe im in a rush to get outta here right now but was fairly impressed.
was curious bout what you all think

i had the code but i guess it was to long
so i uploaded everything it made (in 10 seconds)
www.yockeys.com/testcfm.rar

  _____
  _____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to