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&origq=chicken+
coupe&nosp=0&spoff=on&FORM=SMCRT&v=1&cfg=SMCINITIAL',
'/bookpage.cfm?booknumber=11&source=Goto&keyword=chicken%20coop%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]
