Database Results Error - FrontPage 2000

[BobD]

First attempt to connect up a database and can't get over first hurdle. Tried
first with Access table and then Excel worksheet but got same result when
publishing web and displaying results page:

Database Results Error
The application is using arguments that are of the wrong type, are out of
acceptable range, or are in conflict with one another.
One or more form fields were empty. You should provide default values for
all form fields that are used in the query.

Spent ages searching for reference to this without success and cannot
believe I'm the first to have come up against it.

 

[Stefan B Rusynko]

The error message is very clear on what you problem is
(one of the fields you have as required is not being sent to the DB or is empty or is trying to create a duplicate value in a field
that is set as no duplicates allowed)

Post a list of the field names / types / values you are trying to update from your site, and a list of your DB field names/types

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| First attempt to connect up a database and can't get over first hurdle. Tried
| first with Access table and then Excel worksheet but got same result when
| publishing web and displaying results page:
|
| Database Results Error
| The application is using arguments that are of the wrong type, are out of
| acceptable range, or are in conflict with one another.
| One or more form fields were empty. You should provide default values for
| all form fields that are used in the query.
|
| Spent ages searching for reference to this without success and cannot
| believe I'm the first to have come up against it.

 

[BobD]

Thanks for this Stefan. I have simplified the table to only two fields with
no duplicates:

Subject Fileref
Tindall C:\Documents and Settings\Bob Darby\My Documents\My
Webs\Merline-Demo7/002.pdf
Thurgood C:\Documents and Settings\Bob Darby\My Documents\My
Webs\Merline-Demo7/003.pdf
Thompson C:\Documents and Settings\Bob Darby\My Documents\My
Webs\Merline-Demo7/004.pdf
Selinger C:\Documents and Settings\Bob Darby\My Documents\My
Webs\Merline-Demo7/005.pdf
ICM C:\Documents and Settings\Bob Darby\My Documents\My
Webs\Merline-Demo7/006.pdf
Hock C:\Documents and Settings\Bob Darby\My Documents\My
Webs\Merline-Demo7/007.pdf
Bagley C:\Documents and Settings\Bob Darby\My Documents\My
Webs\Merline-Demo7/008.pdf

Both fields are defined as text with:
Field Size: 255
Format: Blank
Input Mask: Blank
Caption: Blank
Default Value: Blank
Validation Rule: Blank
Validation Text: Blank
Required: No
Allow Zero Length: Yes
Indexed: No
Unicode Commression: Yes
IME Mode: No Control
IME Sentence Mode: None
Smart Tags: Blank

I am still getting the same message when I publish. Any ideas please?

 

[Kathleen Anderson]

The Fileref should refer to PDFs that are contain in your web site as
002.pdf, not a filepath to their location on your PC.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

Thanks for this Stefan. I have simplified the table to only two fields
with
no duplicates:

Subject Fileref
Tindall C:\Documents and Settings\Bob Darby\My Documents\My
Webs\Merline-Demo7/002.pdf
Thurgood C:\Documents and Settings\Bob Darby\My Documents\My
Webs\Merline-Demo7/003.pdf
Thompson C:\Documents and Settings\Bob Darby\My Documents\My
Webs\Merline-Demo7/004.pdf
Selinger C:\Documents and Settings\Bob Darby\My Documents\My
Webs\Merline-Demo7/005.pdf
ICM C:\Documents and Settings\Bob Darby\My Documents\My
Webs\Merline-Demo7/006.pdf
Hock C:\Documents and Settings\Bob Darby\My Documents\My
Webs\Merline-Demo7/007.pdf
Bagley C:\Documents and Settings\Bob Darby\My Documents\My
Webs\Merline-Demo7/008.pdf

Both fields are defined as text with:
Field Size: 255
Format: Blank
Input Mask: Blank
Caption: Blank
Default Value: Blank
Validation Rule: Blank
Validation Text: Blank
Required: No
Allow Zero Length: Yes
Indexed: No
Unicode Commression: Yes
IME Mode: No Control
IME Sentence Mode: None
Smart Tags: Blank

I am still getting the same message when I publish. Any ideas please?

--
BobD

The error message is very clear on what you problem is
(one of the fields you have as required is not being sent to the DB or is
empty or is trying to create a duplicate value in a field
that is set as no duplicates allowed)

Post a list of the field names / types / values you are trying to update
from your site, and a list of your DB field names/types

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| First attempt to connect up a database and can't get over first hurdle.
Tried
| first with Access table and then Excel worksheet but got same result
when
| publishing web and displaying results page:
|
| Database Results Error
| The application is using arguments that are of the wrong type, are out
of
| acceptable range, or are in conflict with one another.
| One or more form fields were empty. You should provide default values
for
| all form fields that are used in the query.
|
| Spent ages searching for reference to this without success and cannot
| believe I'm the first to have come up against it.