D
David Lozzi
Howdy,
I have a frontpage web site that reads, edits and deletes records from a
database. Adding and deleting data works great. However, when I go to edit
data, the edit form appears and I can change values but when I click OK to
save changes I get the following error:
Database Results Wizard Error
Description: Syntax error in UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine
One or more form fields were empty. You should provide default values for
all form fields that are used in the query.
This is occuring on the results.asp page, data being sent from edit.asp.
This is my first time using FP for database access, I usually develop it
myself using ASP.Net however a customer came to me with this issue, I did
not develop this. Oh yeah, it was working fine on their old hosting server
but then we moved them to a new hosting server and now this is happening.
Where do I start? How do I resolve this? I tried rerunning the Database
results wizard on the Update page, and confirmed the custom query.
UPDATE Results SET Name = '::Name::' , Category = '::Category::' ,
Description = ':escription::' , Available = '::Available::' , City =
'::City::' , State = '::State::' , Day = :ay:: , Month = ::Month:: , Year
= ::Year:: , Extra1 = '::Extra1::' , Extra2 = '::Extra2::' , Extra3 =
'::Extra3::' , Extra4 = '::Extra4::' , Extra5 = '::Extra5::' WHERE (Key =
::Key:
Thanks!!
--
D a v i d L o z z i
Data & Web Technology Specialist
Delphi Technology Solutions, Inc.
Wilmington, MA
dlozzi@(remove this)delphi-ts.com - www.delphi-ts.com
I have a frontpage web site that reads, edits and deletes records from a
database. Adding and deleting data works great. However, when I go to edit
data, the edit form appears and I can change values but when I click OK to
save changes I get the following error:
Database Results Wizard Error
Description: Syntax error in UPDATE statement.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine
One or more form fields were empty. You should provide default values for
all form fields that are used in the query.
This is occuring on the results.asp page, data being sent from edit.asp.
This is my first time using FP for database access, I usually develop it
myself using ASP.Net however a customer came to me with this issue, I did
not develop this. Oh yeah, it was working fine on their old hosting server
but then we moved them to a new hosting server and now this is happening.
Where do I start? How do I resolve this? I tried rerunning the Database
results wizard on the Update page, and confirmed the custom query.
UPDATE Results SET Name = '::Name::' , Category = '::Category::' ,
Description = ':escription::' , Available = '::Available::' , City =
'::City::' , State = '::State::' , Day = :ay:: , Month = ::Month:: , Year
= ::Year:: , Extra1 = '::Extra1::' , Extra2 = '::Extra2::' , Extra3 =
'::Extra3::' , Extra4 = '::Extra4::' , Extra5 = '::Extra5::' WHERE (Key =
::Key:
Thanks!!
--
D a v i d L o z z i
Data & Web Technology Specialist
Delphi Technology Solutions, Inc.
Wilmington, MA
dlozzi@(remove this)delphi-ts.com - www.delphi-ts.com