The syntax looks correct but, correct me if I'm wrong here, I don't think Access will allow that type of query. You shouldn't have a problem with SQL Server though.
Mark -----Original Message----- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 03, 2002 9:31 AM To: CF-Talk Subject: SQL GURUS? I am having trouble with a query: Works fine in Oracle... <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." ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc 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
