p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

asp_databases thread: Operation must use an updateable query


Message #1 by rosenzl@o... on Tue, 11 Dec 2001 18:22:43
I am familiar with the error above, but don't understand why I am getting 

it now. This is the situation:



I have an application in Front Page 2000 that has no authentication or 

logon page, but brings up an appointment schedule and allows add/update. 

It works fine. I have another application in Visual Interdev, which has 

authentication, but is a stand alone calendar with it's associated pages 

to add/enter email address and password to a logon table and to enter an 

appointment schedule once loggod on. The appointment schedule allows the 

user to add or update their own customer information. It works fine too. 



What I did was Import into Front Page 2000, the Calendar application pages 

Database and folders (from Visual Interdev). I redirected a link from one 

page where it originally went to the schedule to now go to the logon page. 

When I run in Browser from Front Page, I get from my home page to the link 

page, where I now go to the logon page and it works fine. The problem is 

when on the customer page and I attempt to update or add a customer to the 

table, I get the error above in my processingcustomer page. The code in 

both applications are identical concerning the the customer and 

processingcustomer page. All links are correct, so I don't know why I can 

update the database in the logon screen, but not in the processcustomer 

screen.



I hope this makes sense and appologize for the lenght of this. Please Help!



Thanks,



Larry

Message #2 by "danny njuguna" <danny@n...> on Thu, 27 Dec 2001 11:20:18
I get an error when i run my script on one server but on the other it 

works fine, i have set the directory to have write acess, what am i 

missing.
Message #3 by "Kim Iwan Hansen" <kimiwan@k...> on Thu, 27 Dec 2001 12:39:59 +0100
you're supplying little information, but here's a couple of links to look

into:

http://www.learnasp.com/learn/FAQdbUpdate.asp

http://support.microsoft.com/default.aspx?scid=kb;DA;q175168

http://www.google.com/search?q=operation+must+use+an+updateable+query&hl=da&

lr



try and look at that. if the first two don't answer your question, look at

the google link and click around a bit and see what you find.  if you can't

find an answer yourself, come back with some more information (i.e. what

database you're using, what you're trying to do, what you've tried already

without success, what errors you're getting, what your code looks like (and

point out where in the code the error is), and what you think might be the

problem.  that should give us a more fair chance to help you - but first try

for yourself :)



-Kim





> -----Original Message-----

> From: danny njuguna [mailto:danny@n...]

> Sent: 27. december 2001 11:20

> To: ASP Databases

> Subject: [asp_databases] Operation must use an updateable query.

>

>

> ---

> Need a present for your favorite programmer?

> E-Documents from Amazon.com at http://p2p.wrox.com/edocs.asp

> ---

> I get an error when i run my script on one server but on the other it

> works fine, i have set the directory to have write acess, what am i

> missing.




> $subst('Email.Unsub').

>



Message #4 by "Daniel Njuguna" <danny@n...> on Sat, 29 Dec 2001 14:47:38 +0300
Thanks, the permissions were set wrong, so i just modified it and everything stared working.

Thanks

Danny







---------- Original Message ----------------------------------

From: "Kim Iwan Hansen" <kimiwan@k...>

Reply-To: "ASP Databases" <asp_databases@p...>

Date:  Thu, 27 Dec 2001 12:39:59 +0100



>---

>Need a present for your favorite programmer?

>E-Documents from Amazon.com at http://p2p.wrox.com/edocs.asp

>---

>you're supplying little information, but here's a couple of links to look

>into:

>http://www.learnasp.com/learn/FAQdbUpdate.asp

>http://support.microsoft.com/default.aspx?scid=kb;DA;q175168

>http://www.google.com/search?q=operation+must+use+an+updateable+query&hl=da&

>lr

>

>try and look at that. if the first two don't answer your question, look at

>the google link and click around a bit and see what you find.  if you can't

>find an answer yourself, come back with some more information (i.e. what

>database you're using, what you're trying to do, what you've tried already

>without success, what errors you're getting, what your code looks like (and

>point out where in the code the error is), and what you think might be the

>problem.  that should give us a more fair chance to help you - but first try

>for yourself :)

>

>-Kim

>

>

>> -----Original Message-----

>> From: danny njuguna [mailto:danny@n...]

>> Sent: 27. december 2001 11:20

>> To: ASP Databases

>> Subject: [asp_databases] Operation must use an updateable query.

>>

>>

>> ---

>> Need a present for your favorite programmer?

>> E-Documents from Amazon.com at http://p2p.wrox.com/edocs.asp

>> ---

>> I get an error when i run my script on one server but on the other it

>> works fine, i have set the directory to have write acess, what am i

>> missing.




>> $subst('Email.Unsub').

>>

>

>




>



--

Danny Njuguna

--


  Return to Index