Skip to main content
O
One_Life
Known Participant
March 4, 2011
Question

CFC generation off of stored procedures

  • March 4, 2011
  • 1 reply
  • 800 views

Hi,

Does anyone know how to generate a CFC off of stored procedures ... if this is even possible?  I'm using MySQL in case that makes a difference.

Thanks

This topic has been closed for replies.

1 reply

S
SidianConsulting
Known Participant
March 5, 2011

Hi One Life,

I created an app called SQLGen that generates CRUD stored procedures and CFCs, but for SQL Server only.  It doesn't look at existing store procs and generate CFCs from them, though.  If you're interested in the code, let me know.  It might be something you can tweak.  It actually reads a table structure and generates the CFCs and procs from that.  I updated it a while back to use the CFDBINFO tag that was introduced in CF8.  Before that I was relying on reading the system tables for layout information.

Andy

O
One_LifeAuthor
Known Participant
March 8, 2011

Thanks Andy, that sounds interesting and is very thoughtful.

I would like to study it as I gain further competency in using CFB / CFB 2 this month, and hopefully adapt it.

My email is my firstname Reto, followed by an underscore, followed by my last name, Kurz.   I use cox.net as a service provider.

Thanks again,

Reto

S
SidianConsulting
Known Participant
March 8, 2011

Okay, I sent you the zip file with the code earlier today.

Andy

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices