Re: (WOT) Sample code for COM object wrappers for Stored Procedures

2001-01-29 Thread Billy Cravens
Perhaps you'd want to hide the connection details for security reasons. There may even be a performance benefit. However, if you were to use a COM object, you'd have to use ADO; you probably couldn't spit the results back as a native CF query. -- Billy Cravens HR Web Development, Sabre

Re: (WOT) Sample code for COM object wrappers for Stored Procedures

2001-01-27 Thread Wjreichard
Why ... n-tier development. Typically 3 tiers: presentation, business logic and backend processing. And the COM component is the middle tier ... enforcing business rules. ASP/CF acts as the presentation tier with T-SQL as the third tier. Why n-tier development ... because of scalability,

Re: (WOT) Sample code for COM object wrappers for Stored Procedures

2001-01-27 Thread Eric Dawson
great response. I want to implement a working example to learn from. Any suggestions as to where to get a working database example? Eric From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Re: (WOT) Sample code for COM object wrappers for Stored

(WOT) Sample code for COM object wrappers for Stored Procedures

2001-01-26 Thread Eric Dawson
(WOT) Sample code for COM object wrappers for Stored Procedures not sure if I am using the right lingo, but I am interested in seeing a working example of database integration for a web site using a com object as a wrapper for a stored procedure. ASP and Cold Fusion sample ASP code

Re: (WOT) Sample code for COM object wrappers for Stored Procedures

2001-01-26 Thread Clint Tredway
Can I ask why you would want to use a COM object to access a Stored Procedure instead of just calling the procedure directly? I am just curious... -- Clint Tredway www.factorxsoftware.com -- ~~ Structure your ColdFusion code with Fusebox. Get

Re: (WOT) Sample code for COM object wrappers for Stored Procedures

2001-01-26 Thread Eric Dawson
seen the code, I may have misunderstood what he was telling me. I was going to recreate the approach so I could learn it. e From: "Clint Tredway" [EMAIL PROTECTED] Subject: Re: (WOT) Sample code for COM object wrappers for Stored Procedures Date: Fri, 26 Jan 2001 22:17:24 -0500 Can I a