> [quote] > Query Of Queries syntax error.</b><br> Encountered "update" at line 0, column > 0. > [/quote]
QoQ only supports SELECT queries. However, you can emulate an UPDATE query quiet easily: Consider this: update someRecordset set someColumn = 'pangolin' where someOtherColumn = 'marmoset' It's the same as this: select [restOfColumns], 'pangolin' as someColumn from someRecordset where someOtherColumn = 'marmoset' union select [allColumns] from someRecordset where someOtherColumn <> 'marmoset' That said, I'm not sure if this is better or worse than looping over the query, finding matches and updating relevant cells directly. It's interesting for curiousity value, anyhow. -- Adam --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
