Operation must use an updateable query

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Operation must use an updateable query

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> Operation must use an updateable query

Page: [1]


yaronbb Posts: 44 Joined: 10/5/2006 Status: offline	Operation must use an updateable query - 10/5/2006 5:49:39 hi to all i am trying to run this code in frontpage2002 "update table_insert set total = (select total from table_total where userid = ::userid:: and event = ::event::) where per is null and userid = ::userid:: and event = '::event::'" and when i try to run it i get this error "Operation must use an updateable query" when i try to run it like that "update table_insert set total = 10 where per is null and userid = ::userid:: and event = '::event::'" its working good thanks


Spooky Posts: 26599 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Operation must use an updateable query - 10/5/2006 14:40:58 For a start, "total" is a reserved word. Use this select [total] from _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to yaronbb)