I have this query (SQL 2000)... <cfquery name="findtitle_dvd"> select a.stock, a.title, a.company, a.price, b.mom_price from dvd a, stock b where a.stock = b.number and a.price <> b.mom_price group by a.stock, a.title, a.company, a.price, b.mom_price </cfquery>
This select 469 records with out any problem. Then I have this query (Fox Pro 6.0): <cfquery name="newprice_dvd"> update stock set price1 = #findtitle_dvd.price# where number = '#findtitle_dvd.stock#' </cfquery> When it goes to update, I get this error: ODBC Error Code = S1000 Cannot update the cursor. Any idea what "cannot update the cursor" means? Jacob ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists