FrontPage Programming - Database Results Wizard Error

Author

Database Results Wizard Error

David Lozzi

2006-05-26, 6:58 pm

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 = '::Description::' , Available = '::Available::' , City =
'::City::' , State = '::State::' , Day = ::Day:: , 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

Kathleen Anderson [MVP - FrontPage]

2006-05-26, 6:58 pm

Day, Month, Year and Key are Microsoft Jet 4.0 reserved words:
http://support.microsoft.com/?id=321266 Try renaming the fields in your
database to myDay, myMonth, myYear and myKey, reimport the database, and
update your SQL.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
FrontPage Support: http://www.frontpagemvps.com/

"David Lozzi" <dlozzi@nospam.nospam> wrote in message
news:%23rAmiWOgGHA.1792@TK2MSFTNGP03.phx.gbl...
> 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 = '::Description::' , Available = '::Available::' , City =
> '::City::' , State = '::State::' , Day = ::Day:: , 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
>

Stefan B Rusynko

2006-05-27, 6:47 am

So is Name
- use say FullName

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontP...53/Default.aspx
_____________________________________________

"Kathleen Anderson [MVP - FrontPage]" <spiderwebwoman@mvps.org> wrote in message news:u$iP6vOgGHA.1792@TK2MSFTNGP03.phx.gbl...
| Day, Month, Year and Key are Microsoft Jet 4.0 reserved words:
| http://support.microsoft.com/?id=321266 Try renaming the fields in your
| database to myDay, myMonth, myYear and myKey, reimport the database, and
| update your SQL.
|
|
| --
|
| ~ Kathleen Anderson
| Microsoft MVP - FrontPage
| Spider Web Woman Designs
| web: http://www.spiderwebwoman.com/resources/
| FrontPage Support: http://www.frontpagemvps.com/
|
|
|
|
| "David Lozzi" <dlozzi@nospam.nospam> wrote in message
| news:%23rAmiWOgGHA.1792@TK2MSFTNGP03.phx.gbl...
| > 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 = '::Description::' , Available = '::Available::' , City =
| > '::City::' , State = '::State::' , Day = ::Day:: , 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
| >
|
|