An Access query is treated like another table. Just create and save the
query, then refer to it as you would a table from CF. No other special code
required. You can't use reports unless there is some third party software
out there that does it. You can't use forms.
Tip of the day: Do NOT use spaces in your query names (or tables for that
matter). It's possible, but way too much hassle to deal with in the long
run.
For example, let's say you have an Access query named "qry_MyAccessQuery"
that has IDs, Names, States, etc...
You can access it just like a table using all SQL features that Access (at
least the ODBC driver) can handle:
<cfquery...>
SELECT
qry_MyAccessQuery.ID,
qry_MyAccessQuery.Name
FROM qry_MyAccessQuery
WHERE qry_MyAccessQuery.State = 'TX'
</cfquery>
Jeremy
> -----Original Message-----
> From: Billy Cravens [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 05, 2001 5:19 PM
> To: [EMAIL PROTECTED]
> Subject: Re: MC Access app and CF
>
>
> Actually, I thought an Access "query" was treated like a
> stored procedure? A
> form is just a graphical front-end, and would have no use in
> CF. A report
> can be accessed via COM, I believe. I do not believe there
> is a method for
> accessing it via Jet or SQL.
>
> --
> Billy Cravens
> HR Web Development, Sabre
> [EMAIL PROTECTED]
>
> Dave Cahall wrote:
>
> > You can use queries and views and treat them like quries.
> I will dig out
> > some syntax for you. I am not sure about the forms and reports.
> > On Mon, 5 Mar 2001 16:15:25 -0600 <[EMAIL PROTECTED]> writes:
> > > Hi,
> > >
> > > I have MS Access aplication. Can I use its objects:
> > > forms,reports,and
> > > queries in CF aplication? If yes how to do it?
> > >
> > > Thanks,
> > >
> > > henry
> > >
> > >
> > >
> > >
> > >
> >
> --------------------------------------------------------------
> -----------
> > > This email server is running an evaluation copy of the MailShield
> > > anti-
> > > spam software. Please contact your email administrator if you have
> > > any
> > > questions about this message. MailShield product info:
> > > www.mailshield.com
> > >
> > > -----------------------------------------------
> > > To post, send email to [EMAIL PROTECTED]
> > > To subscribe / unsubscribe: http://www.dfwcfug.org
> > >
> >
> >
> --------------------------------------------------------------
> -----------
> > This email server is running an evaluation copy of the
> MailShield anti-
> > spam software. Please contact your email administrator if
> you have any
> > questions about this message. MailShield product info:
> www.mailshield.com
> >
> > -----------------------------------------------
> > To post, send email to [EMAIL PROTECTED]
> > To subscribe / unsubscribe: http://www.dfwcfug.org
>
>
>
>
>
>
> --------------------------------------------------------------
> -----------
> This email server is running an evaluation copy of the
> MailShield anti-
> spam software. Please contact your email administrator if you have any
> questions about this message. MailShield product info:
> www.mailshield.com
>
> -----------------------------------------------
> To post, send email to [EMAIL PROTECTED]
> To subscribe / unsubscribe: http://www.dfwcfug.org
>
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
