Sounds to me like you are looking at the DAO pattern
(http://java.sun.com/blueprints/corej2eepatterns/Patterns/DataAccessObject.html).
Without starting an OO/mach-ii debate or anything like that, you may
want to have a quick look at the Phil Cruz's mach-ii.info site to see
how he implemented the DAO so that the application could use
Access/MySQL, etc databases.
Just a pointer!
Cheers
G
On Mon, 18 Oct 2004 11:33:00 -0400, Dan O'Keefe <[EMAIL PROTECTED]> wrote:
> Thanks, that is what it is starting to look like, but defats the
> intended purpose which was being able to use this component from any
> database comonent and generate the syntax.
>
> Dan
>
> > If you are building up the query using cf logic (and not pulling the bits
> > of the query from a db or elsewhere) then you should consider putting all of
> > that logic in between the cfquery tags and not try building a query string
> > first. That is probably you best approach.
> >
> >
> > Mark
>
>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
- Execute Query string w CFQUERYPARAM Dan O'Keefe
- Re: Execute Query string w CFQUERYPARAM Thomas Chiverton
- Re: Execute Query string w CFQUERYPARAM Dan O'Keefe
- Re: Execute Query string w CFQUERYPARAM Dina Hess
- Re: Execute Query string w CFQUERYPARAM Dan O'Keefe
- Re: Execute Query string w CFQUERYPARAM Joseph Flanigan
- RE: Execute Query string w CFQUERYPARAM Pascal Peters
- RE: Execute Query string w CFQUERYPARAM Gaulin, Mark
- Re: Execute Query string w CFQUERYPARAM Dan O'Keefe
- Re: Execute Query string w CFQUERYPARAM Greg Stewart
- Re: Execute Query string w CFQUERYPARAM Dan O'Keefe
- RE: Execute Query string w CFQUERYPARAM d.a.collie
- Re: Execute Query string w CFQUERYPARAM Joseph Flanigan
- RE: Execute Query string w CFQUERYPARAM Mark A Kruger
- Re: Execute Query string w CFQUERYPARAM Aaron Rouse
- RE: Execute Query string w CFQUERYPARAM Andy Ousterhout
- RE: Execute Query string w CFQUERYPARAM Mark A Kruger
- RE: Execute Query string w CFQUERYPARAM Joseph Flanigan
- Re: Execute Query string w CFQUERYPARAM Joseph Flanigan
- Re: Execute Query string w CFQUERYPARAM Joseph Flanigan