I stand corrected then. Thanks.
--
Billy Cravens
[EMAIL PROTECTED]
"Olive, Christopher M Mr USACHPPM" wrote:
> actually, that's not technically correct. while access "queries" are closer
> to views in this case, CF can treat them like SPs.
>
> Chris Olive,
> DOEHRS Website Administrator
>
> -----Original Message-----
> From: Billy Cravens [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, June 22, 2000 11:13 AM
> To: [EMAIL PROTECTED]
> Subject: Re: CFSTOREDPROC and Access97
>
> I could be incorrect here, but Access "queries" are not the same thing as
> stored procs. As best I understand it, they are just save pieces of SQL,
> which are run whenever they are
> called.. not quite the same thing as stored procedures. You will need to
> reproduce the query in CF. Alternately, I've heard that Access 2000
> supports stored procs (though I've never
> tried it.. haven't used Access for development in quite a while)
>
> --
> Billy Cravens
> [EMAIL PROTECTED]
>
> Aidan Whitehall wrote:
>
> > Are there any known problems using CFSTOREDPROC and queries in an Access97
> > database?
> >
> > I'm having a hell of a time getting a simple UPDATE query to work
> (although
> > SELECT queries work no problem).
> >
> > If you run the query from within Access, it asks for the variable values
> and
> > then updates the relevant record fine. But passing them as CFPROCPARAMs
> > doesn't seem to work at all (pretty sure all the data-types are OK).
> >
> > I'd paste the code but there's *heaps*... just wondered if anyone had any
> > general comments on this topic.
> >
> > Thanks again.
> >
> > --
> > Aidan Whitehall <[EMAIL PROTECTED]>
> > Netshopper UK Ltd
> > Advanced Web Solutions & Services
> >
> > http://www.netshopperuk.com/
> > Telephone +44 (01744) 648650
> > Fax +44 (01744) 648651
> >
> ----------------------------------------------------------------------------
> --
> > Archives: http://www.eGroups.com/list/cf-talk
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> ----------------------------------------------------------------------------
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> ------------------------------------------------------------------------------
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
