
July 13th, 2009, 02:33 PM
|
|
Registered User
|
|
Join Date: Jul 2009
Posts: 1
Time spent in forums: 35 m 35 sec
Reputation Power: 0
|
|
UPDATE Query Yielding Database Results Wizard Error
I am having an issue getting a form to update a database. Form is stored on asp page, server running Windows 2003 server. Database is on an SQL server, running MS SQL Server 2005. Everything worked fine until last Thursday; however, no changes had been made to either server or the form up until that point.
When I open my page in either FrontPage 2003 or SharePoint Designer 2007, I get the following message:
"This is the start of a Database Results region. The custom query contains errors."
This is my query:
UPDATE Fines
SET FineType = '::FineType::' , FineNumber = '::FineNumber::' , FineDate = '::FineDate::' , LastName = '::LastName::' , FirstName = '::FirstName::' , HomeStreet = '::HomeStreet::' , HomeCity = '::HomeCity::' , HomeState = '::HomeState::' , HomeZip = '::HomeZip::' , Ordinance = '::Ordinance::' , OfficerNumber = '::OfficerNumber::' , OfficerName = '::OfficerName::' , Offense = '::Offense::' , PlateNumber = '::PlateNumber::' , PlateState = '::PlateState::' , PlateYear = '::PlateYear::' , PlateTemporary = '::PlateTemporary::' , Vin = '::Vin::' , TrashSticker = '::TrashSticker::' , MinimumFine = '::MinimumFine::' , LateTotal = '::LateTotal::' , DueDate = '::DueDate::' , FinalDue = '::FinalDue::' , PaidDate = '::PaidDate::' , AmountPaid = '::AmountPaid::' , PaymentType = '::PaymentType::' , Payee = '::Payee::' , PostDate = '::PostDate::' , ReturnQpd = '::ReturnQpd::' , DateVoid = '::DateVoid::' , VoidBy = '::VoidBy::' , LetterSent = '::LetterSent::' , FinalReturn = '::FinalReturn::' , Notes = '::Notes::' , CourtDate = '::CourtDate::' , ServedBy = '::ServedBy::' , ServedDate = '::ServedDate::'
WHERE (ID = ::ID::)
However, when I verify the query, the Database Results Wizard returns that the query was verified against the connection string. When I then save the page and test in IE7, I get the following error:
Database Results Wizard Error
The operation failed. If this continues, please contact your server administrator.
I have verified that the field names specified in the query are the same names that are used on both the form and the database. The query, form and database were created 4 years ago by a user who is no longer employed with our City.
This database is scheduled to be re-created later this year using AlphaFive. However, until I can get started on the new database, I need this one up and running for our Treasurer and Police Department.
Any help is greatly appreciated. Please let me know if you need additional information.
Thanks!
Megan
|