SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Can insert but not update
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

acornkit
Starting Member

1 Posts

Posted - 09/05/2013 :  18:54:28  Show Profile  Reply with Quote
I am creating a new website ( http://www.pumpitupman.com/index.php ) which is almost identical to my existing website (www.SchoolShows.com). To create this new site, I simply copied the entire structure of the old site, SchoolShows.com. The SQL databases of each site have the exact same tables and fields. My problem is this: on the new site, I can successfully create and insert a new record, but after that I cannot update any records.

On both websites, I have compared the forms through which records are updated. The forms are identical. Since one form works and the other one does not, it leads me to conclude that the problem is not erroneous code in newly created form. If Form 1 works, and Form 2 is identical to Form 1, then form 2 must be correct as well.

Both forms use the exact same query.

This leaves me to conclude that there must be some difference in the structure of the two databases, and that perhaps, when I created the second database (manually) I might have entered something that was different from the original database for SchoolShows.com. I have double–checked, and I cannot find any difference, but maybe I am missing something. What do you think? Do you have any advice or possible solution for my problem?

Many thanks.

LoztInSpace
Aged Yak Warrior

939 Posts

Posted - 09/06/2013 :  01:15:43  Show Profile  Reply with Quote
What error messages are you getting? At a guess I'd say your permissions or service accounts are wrong (you should probably have different accounts for the different sites)
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000