>From my experience ACCESS likes the inner joins not the where statement
s
which join the two tables.
Update categoryset tutorial=
(Select max(section.tutorial) from section inner join category on
(category.code = section.catalogid))
CC
Tony
Schreiber To: CF-Talk <cf-talk@house
offusion.com>
<dune cc:
@technocraft. Subject: RE: SQL GURUS?
com>
01/03/02
11:41 AM
Please
respond to
cf-talk
JOINED update queries use a very odd syntax in Access. Best thing to do
is
use Access' Design Query mode to get the query you want, then look at t
he
SQL version.
> > <cfquery name="addtypes" datasource="kriskart">
> > Update category
> > set tutorial = (Select max(section.tutorial)
> > from section, category
> > where category.code = section.catalogid)
> > </cfquery>
> >
> >
> > Anyidea why Access tells me this is an "[Microsoft][ODBC
> > Microsoft Access Driver] Operation must use an updateable
> > query."
>
> I don't use Access enough to know whether you can use a subquery in a
n
> UPDATE statement, but I've seen that error message before when the Ac
cess
> database file was marked as read-only on the filesystem.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
>
______________________________________________________________________
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
