Hey,
Adam Churvis wrote:
I have used the stored procedure generator this morning to generate SPs
for my app. All of the components were generated and are in place, as
well as the sql procedure scripts and invocations.
Everything went okay, I take it?
Swimmingly :)
How's that help file coming <g>?
Swimmingly (as in, "I'm swimming in it"). The next drop is on schedule for
Monday, with the completed Help and tutorials in place (completed as in
there's something there for every topic, but I'll probably flesh things out
more and more as time goes on).
Can you give me some simple steps of how to tie all this into an
existing module. I want to start small with one table and see how it
goes.
The generated stored procedures, the components that contain the methods
that call them, and their invocations are there for you to cut-and-paste
into your own code. Plum IDE is a tool for quickly generating this
"brick-laying work" so you can concentrate on things like business logic.
I get this.
The stored procedures are ready to run, unless you want to modify them
before you create them in your database using SQL Query Analyzer.
I get this. I have the SPs in the database already using Query Analyzer.
The component methods are also ready to either run as is or copy portions to
your own components.
You are talking about the generated cfc in the components subdirectly
along with the defaults. I have a module 'Aircraft', and now there is
an Aircraft.cfc component in there (as I expected) with all the
component methods for doing inserts, updates, etc.
The invocations are generated in two forms: tag-based and script-based.
Just copy the one you want to the place where you want to call the component
method and pass in the arguments as shown.
I have an Aircraft_Invocations.cfm in my test directory, that is script
based. Where are the tag based?
Is that what you're looking for, Jeff? It may sound kinda general, but
that's about all there is to it.
1. I have a Plum project done using the standard Plum generated pages
for each module. In some cases they have been modified, but are all
using the Plum custom tags for maintenance.
2. I have converted them to cfmodule calls using the cf2cfmodule
utility. Everything is working great, so I decide to move from using
the cfquery calls in DatabaseBlocks.cfc (default mode) to SPs as a test
and to play around..
3. I generate the stored procedures from Plum, and create components.
They are all there. Just not sure how to 'invoke' the calls to the
component methods from the Plum tags/objects (DisplayList, etc).
This is the part I don't get. I see where everyting is, how do I plug
it into the forms I have? I must be doing some bass akwards here.
Jeff
Respectfully,
Adam Phillip Churvis
Member of Team Macromedia
Advanced Intensive Training:
* C# & ASP.NET for ColdFusion Developers
* ColdFusion MX Master Class
* Advanced Development with CFMX and SQL Server 2000
http://www.ColdFusionTraining.com
Download CommerceBlocks V2.1 and LoRCAT from
http://www.ProductivityEnhancement.com
The ColdFusion MX Bible is in bookstores now!
--
_______________________________
Jeff Fleitz
Tekquest, Ltd
Integrated Digital Solutions
http://www.tekquest.com
866.472.5868
_______________________________
