I haven't tried calling queries in Access 97 with CFSTOREDPROC, however I
started development of a recent site using CFSTOREDPROC to call queries in
Access 2000, this worked really well, and changing to SQL Server 7 later
was pretty straightforward... the only trouble I had was that there wasn't
any way of converting the Access queries to stored procedures (at least I
couldn't find the way!!!! :^)
At 10:12 22/06/00 -0500, you wrote:
>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.
