This may shed some light: http://www.macromedia.com/support/ultradev/ts/documents/80004005update.h tm
Kola >> -----Original Message----- >> From: Giles Roadnight [mailto:[EMAIL PROTECTED] >> Sent: 27 February 2003 10:49 >> To: [EMAIL PROTECTED] >> Subject: [ cf-dev ] Operation must use an updateable query >> >> >> Every now and then I get the error "operation must use an updateable >> query". >> >> Can anyone tell me what this means and what I can do to get >> around it. >> >> The query in question is this. >> >> insert into tracker (RefURL, PageURL, RecordDate, TrackerID, SiteID, >> cftoken, cfid, IPAddress, datestamp) >> values('http://search.msn.com/results.asp?q=chicken+coops&ori >> gq=chicken+ >> coupe&nosp=0&spoff=on&FORM=SMCRT&v=1&cfg=SMCINITIAL', >> '/bookpage.cfm?booknumber=11&source=Goto&keyword=chicken%20co >> op%20constr >> uction', '27-Feb-2003', 136506, 'GoldCockerel', '88839668', '207916', >> '68.7.176.74', {ts '2003-02-27 10:17:55'}) >> >> which works fine when I paste it into access. >> >> >> Giles Roadnight >> http://giles.roadnight.name >> >> >> -- >> ** Archive: >> http://www.mail-archive.com/dev%>> 40lists.cfdeveloper.co.uk/ >> >> >> To unsubscribe, e-mail: >> [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> For human help, e-mail: [EMAIL PROTECTED] >> -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
