You can modify the SQL that comes out of MS access. It's quite easy to
build statements in that.
Crystal Reports also has a SQL builder that is a stand alone utility.
At 10:23 AM 11/15/00 +0100, you wrote:
>What I'm looking for is a SQL generator that will handle table joins and
>multiple criteria. The same kind of functionality as the query builder in
>Studio, but with a more intuitive, CF-based interface. Does anyone know of
>such a thing? Or - if I wrote one, would anyone be interested in it?
>
>Tom
>
> >
> > There is no username and password for the demo.
> >
> > The demo is just hard coded html to give a view of how the generator works
> > and the files that it will produce. To follow the demo just click the
> > submit buttons as if you were using the actual product ie
> >
> > choose a database and click connect (the demo is using the Coffee
> database).
> >
> > choose a table and click the link "generate SQL" (the demo is hard
> coded for
> > the beans table).
> >
> > You can see the sql that is produced. (note all sql in the trial and full
> > version uses
> > #val(form.variable)# to eliminate malicious sql in fields that arent char
> > etc.
> >
> > In addition you can view the files that will be produced.
> >
> > Another option would be to download the trial version and try the product
> > with your own datasources.
> >
> > Here is the url again
> > http://www.aloha-webdesign.com/sqlgen/
>
>------------------------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/[email protected]/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
>a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
>
>-=-=-
>SBG-Priority: 4 (Low) http://www.internz.com/SpamBeGone/
--
Michael She
I m a g i n e C o m m u n i c a t i o n s
Company E-mail: [EMAIL PROTECTED]
Personal E-mail: [EMAIL PROTECTED]
ICQ UIN: #243466
Personal Homepage: http://www.michaelshe.com (Under Construction)
Imagine Communications: http://www.imagineer.net
PGP Fingerprint: 9A24 1DA9 39B8 0A0C C5ED 6E5D 45E9 075A 51CD 66A1
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
