Dabase Results Page

D

derfy

I have created form in my website to search a database. The page works
alright, however, I keep getting this error message below:

Database Results Error
Description: Syntax error (missing operator) in query expression '(StudentID
= AND LastName = '')'.
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.

Is there anything I can do so that I do not continue to get the message?
 
D

derfy

Actually I did not create the database with SQL, I created it with MS Access.
I then imported it into my website, followed the step by step instructions in
the "Add a form for seaching a database." You can get this instruction by
typing "database" in the "Ask a Question" text field in the FrontPage
application interface. This is the address to the page:
http://www.supanetghana.com/student_details.asp.

I hope this information will be enough for you to help. Thanks
 
S

Stefan B Rusynko

SQL statement is a generic term for the DBRW query statement
Starting at in code view at
fp_sQry=

The address to the page does not help because all the server side code is already processed and not visible to anyone

--

_____________________________________________
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/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Actually I did not create the database with SQL, I created it with MS Access.
| I then imported it into my website, followed the step by step instructions in
| the "Add a form for seaching a database." You can get this instruction by
| typing "database" in the "Ask a Question" text field in the FrontPage
| application interface. This is the address to the page:
| http://www.supanetghana.com/student_details.asp.
|
| I hope this information will be enough for you to help. Thanks
|
| "Kathleen Anderson [MVP - FrontPage]" wrote:
|
| > Post your SQL statement here and we'll take a look.
| >
| > --
| >
| > ~ Kathleen Anderson
| > Microsoft MVP - FrontPage
| > Spider Web Woman Designs
| > web: http://www.spiderwebwoman.com/resources/
| > FrontPage Support: http://www.frontpagemvps.com/
| >
| >
| >
| >
| > | > >I have created form in my website to search a database. The page works
| > > alright, however, I keep getting this error message below:
| > >
| > > Database Results Error
| > > Description: Syntax error (missing operator) in query expression
| > > '(StudentID
| > > = AND LastName = '')'.
| > > 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.
| > >
| > > Is there anything I can do so that I do not continue to get the message?
| >
| >
| >
 
D

derfy

Ok, ok I get that, and sorry for my ignorance. This is the SQL statement:

fp_sQry="SELECT * FROM Students WHERE (StudentID = ::StudentID:: AND
LastName = '::LastName::')"
fp_sDefault="StudentID=&LastName="
fp_sNoRecords="<tr><td colspan=7 align=left width=""100%"">Sorry, no records
returned.</td></tr>"
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=7
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID

I'm still counting on your help.

Stefan B Rusynko said:
SQL statement is a generic term for the DBRW query statement
Starting at in code view at
fp_sQry=

The address to the page does not help because all the server side code is already processed and not visible to anyone

--

_____________________________________________
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/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Actually I did not create the database with SQL, I created it with MS Access.
| I then imported it into my website, followed the step by step instructions in
| the "Add a form for seaching a database." You can get this instruction by
| typing "database" in the "Ask a Question" text field in the FrontPage
| application interface. This is the address to the page:
| http://www.supanetghana.com/student_details.asp.
|
| I hope this information will be enough for you to help. Thanks
|
| "Kathleen Anderson [MVP - FrontPage]" wrote:
|
| > Post your SQL statement here and we'll take a look.
| >
| > --
| >
| > ~ Kathleen Anderson
| > Microsoft MVP - FrontPage
| > Spider Web Woman Designs
| > web: http://www.spiderwebwoman.com/resources/
| > FrontPage Support: http://www.frontpagemvps.com/
| >
| >
| >
| >
| > | > >I have created form in my website to search a database. The page works
| > > alright, however, I keep getting this error message below:
| > >
| > > Database Results Error
| > > Description: Syntax error (missing operator) in query expression
| > > '(StudentID
| > > = AND LastName = '')'.
| > > 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.
| > >
| > > Is there anything I can do so that I do not continue to get the message?
| >
| >
| >
 
S

Stefan B Rusynko

You need to provide values for the 2 fields (StudentID and LastName) in you SQL Statement
fp_sQry="SELECT * FROM Students WHERE (StudentID = ::StudentID:: AND LastName = '::LastName::')"
- right now they are both empty
fp_sDefault="StudentID=&LastName="

For a guide on how to set up a DBRW search form to not return an error when first loaded (haven't provided values yet)
see http://spiderwebwoman.com/resources/dbrwtipsandtricks.asp#return

--

_____________________________________________
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/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Ok, ok I get that, and sorry for my ignorance. This is the SQL statement:
|
| fp_sQry="SELECT * FROM Students WHERE (StudentID = ::StudentID:: AND
| LastName = '::LastName::')"
| fp_sDefault="StudentID=&LastName="
| fp_sNoRecords="<tr><td colspan=7 align=left width=""100%"">Sorry, no records
| returned.</td></tr>"
| fp_sDataConn="Database1"
| fp_iMaxRecords=256
| fp_iCommandType=1
| fp_iPageSize=0
| fp_fTableFormat=True
| fp_fMenuFormat=False
| fp_sMenuChoice=""
| fp_sMenuValue=""
| fp_iDisplayCols=7
| fp_fCustomQuery=False
| BOTID=0
| fp_iRegion=BOTID
|
| I'm still counting on your help.
|
| "Stefan B Rusynko" wrote:
|
| > SQL statement is a generic term for the DBRW query statement
| > Starting at in code view at
| > fp_sQry=
| >
| > The address to the page does not help because all the server side code is already processed and not visible to anyone
| >
| > --
| >
| > _____________________________________________
| > 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/FrontPageNewsGroups/tabid/53/Default.aspx
| > _____________________________________________
| >
| >
| > | Actually I did not create the database with SQL, I created it with MS Access.
| > | I then imported it into my website, followed the step by step instructions in
| > | the "Add a form for seaching a database." You can get this instruction by
| > | typing "database" in the "Ask a Question" text field in the FrontPage
| > | application interface. This is the address to the page:
| > | http://www.supanetghana.com/student_details.asp.
| > |
| > | I hope this information will be enough for you to help. Thanks
| > |
| > | "Kathleen Anderson [MVP - FrontPage]" wrote:
| > |
| > | > Post your SQL statement here and we'll take a look.
| > | >
| > | > --
| > | >
| > | > ~ Kathleen Anderson
| > | > Microsoft MVP - FrontPage
| > | > Spider Web Woman Designs
| > | > web: http://www.spiderwebwoman.com/resources/
| > | > FrontPage Support: http://www.frontpagemvps.com/
| > | >
| > | >
| > | >
| > | >
| > | > | > | > >I have created form in my website to search a database. The page works
| > | > > alright, however, I keep getting this error message below:
| > | > >
| > | > > Database Results Error
| > | > > Description: Syntax error (missing operator) in query expression
| > | > > '(StudentID
| > | > > = AND LastName = '')'.
| > | > > 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.
| > | > >
| > | > > Is there anything I can do so that I do not continue to get the message?
| > | >
| > | >
| > | >
| >
| >
| >
 
D

derfy

I thank you so far for your help. Right now I'm trying to correct the
problem, I have opened the page live in FrontPage and I've tried to provide
the missing values but I keep getting this message:

"The contents of a FrontPage component have been modified.
These contents will be overwritten when you save this page."

The long and short of this is that I've not been able to provide the missing
values. What should I do now?

Stefan B Rusynko said:
You need to provide values for the 2 fields (StudentID and LastName) in you SQL Statement
fp_sQry="SELECT * FROM Students WHERE (StudentID = ::StudentID:: AND LastName = '::LastName::')"
- right now they are both empty
fp_sDefault="StudentID=&LastName="

For a guide on how to set up a DBRW search form to not return an error when first loaded (haven't provided values yet)
see http://spiderwebwoman.com/resources/dbrwtipsandtricks.asp#return

--

_____________________________________________
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/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Ok, ok I get that, and sorry for my ignorance. This is the SQL statement:
|
| fp_sQry="SELECT * FROM Students WHERE (StudentID = ::StudentID:: AND
| LastName = '::LastName::')"
| fp_sDefault="StudentID=&LastName="
| fp_sNoRecords="<tr><td colspan=7 align=left width=""100%"">Sorry, no records
| returned.</td></tr>"
| fp_sDataConn="Database1"
| fp_iMaxRecords=256
| fp_iCommandType=1
| fp_iPageSize=0
| fp_fTableFormat=True
| fp_fMenuFormat=False
| fp_sMenuChoice=""
| fp_sMenuValue=""
| fp_iDisplayCols=7
| fp_fCustomQuery=False
| BOTID=0
| fp_iRegion=BOTID
|
| I'm still counting on your help.
|
| "Stefan B Rusynko" wrote:
|
| > SQL statement is a generic term for the DBRW query statement
| > Starting at in code view at
| > fp_sQry=
| >
| > The address to the page does not help because all the server side code is already processed and not visible to anyone
| >
| > --
| >
| > _____________________________________________
| > 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/FrontPageNewsGroups/tabid/53/Default.aspx
| > _____________________________________________
| >
| >
| > | Actually I did not create the database with SQL, I created it with MS Access.
| > | I then imported it into my website, followed the step by step instructions in
| > | the "Add a form for seaching a database." You can get this instruction by
| > | typing "database" in the "Ask a Question" text field in the FrontPage
| > | application interface. This is the address to the page:
| > | http://www.supanetghana.com/student_details.asp.
| > |
| > | I hope this information will be enough for you to help. Thanks
| > |
| > | "Kathleen Anderson [MVP - FrontPage]" wrote:
| > |
| > | > Post your SQL statement here and we'll take a look.
| > | >
| > | > --
| > | >
| > | > ~ Kathleen Anderson
| > | > Microsoft MVP - FrontPage
| > | > Spider Web Woman Designs
| > | > web: http://www.spiderwebwoman.com/resources/
| > | > FrontPage Support: http://www.frontpagemvps.com/
| > | >
| > | >
| > | >
| > | >
| > | > | > | > >I have created form in my website to search a database. The page works
| > | > > alright, however, I keep getting this error message below:
| > | > >
| > | > > Database Results Error
| > | > > Description: Syntax error (missing operator) in query expression
| > | > > '(StudentID
| > | > > = AND LastName = '')'.
| > | > > 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.
| > | > >
| > | > > Is there anything I can do so that I do not continue to get the message?
| > | >
| > | >
| > | >
| >
| >
| >
 
K

Kathleen Anderson [MVP - FrontPage]

Make the change in the gray colored code and save the change while you're
still in Code View - FrontPage will leave it alone.
--

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




derfy said:
I thank you so far for your help. Right now I'm trying to correct the
problem, I have opened the page live in FrontPage and I've tried to
provide
the missing values but I keep getting this message:

"The contents of a FrontPage component have been modified.
These contents will be overwritten when you save this page."

The long and short of this is that I've not been able to provide the
missing
values. What should I do now?

Stefan B Rusynko said:
You need to provide values for the 2 fields (StudentID and LastName) in
you SQL Statement
fp_sQry="SELECT * FROM Students WHERE (StudentID = ::StudentID:: AND
LastName = '::LastName::')"
- right now they are both empty
fp_sDefault="StudentID=&LastName="

For a guide on how to set up a DBRW search form to not return an error
when first loaded (haven't provided values yet)
see http://spiderwebwoman.com/resources/dbrwtipsandtricks.asp#return

--

_____________________________________________
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/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Ok, ok I get that, and sorry for my ignorance. This is the SQL
statement:
|
| fp_sQry="SELECT * FROM Students WHERE (StudentID = ::StudentID:: AND
| LastName = '::LastName::')"
| fp_sDefault="StudentID=&LastName="
| fp_sNoRecords="<tr><td colspan=7 align=left width=""100%"">Sorry, no
records
| returned.</td></tr>"
| fp_sDataConn="Database1"
| fp_iMaxRecords=256
| fp_iCommandType=1
| fp_iPageSize=0
| fp_fTableFormat=True
| fp_fMenuFormat=False
| fp_sMenuChoice=""
| fp_sMenuValue=""
| fp_iDisplayCols=7
| fp_fCustomQuery=False
| BOTID=0
| fp_iRegion=BOTID
|
| I'm still counting on your help.
|
| "Stefan B Rusynko" wrote:
|
| > SQL statement is a generic term for the DBRW query statement
| > Starting at in code view at
| > fp_sQry=
| >
| > The address to the page does not help because all the server side
code is already processed and not visible to anyone
| >
| > --
| >
| > _____________________________________________
| > 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/FrontPageNewsGroups/tabid/53/Default.aspx
| > _____________________________________________
| >
| >
| > | Actually I did not create the database with SQL, I created it with
MS Access.
| > | I then imported it into my website, followed the step by step
instructions in
| > | the "Add a form for seaching a database." You can get this
instruction by
| > | typing "database" in the "Ask a Question" text field in the
FrontPage
| > | application interface. This is the address to the page:
| > | http://www.supanetghana.com/student_details.asp.
| > |
| > | I hope this information will be enough for you to help. Thanks
| > |
| > | "Kathleen Anderson [MVP - FrontPage]" wrote:
| > |
| > | > Post your SQL statement here and we'll take a look.
| > | >
| > | > --
| > | >
| > | > ~ Kathleen Anderson
| > | > Microsoft MVP - FrontPage
| > | > Spider Web Woman Designs
| > | > web: http://www.spiderwebwoman.com/resources/
| > | > FrontPage Support: http://www.frontpagemvps.com/
| > | >
| > | >
| > | >
| > | >
| > | > | > | > >I have created form in my website to search a database. The page
works
| > | > > alright, however, I keep getting this error message below:
| > | > >
| > | > > Database Results Error
| > | > > Description: Syntax error (missing operator) in query
expression
| > | > > '(StudentID
| > | > > = AND LastName = '')'.
| > | > > 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.
| > | > >
| > | > > Is there anything I can do so that I do not continue to get the
message?
| > | >
| > | >
| > | >
| >
| >
| >
 
D

derfy

I can now modify the code without getting any message that the content can
not be changed. My problem now is how the statement should be like. I have
tried the following but it will still not work:
"SELECT * FROM Students WHERE (StudentID = +" StudentID ::StudentID:: AND
LastName = +" LastName '::LastName::')".
Can any one help me with how the statement should be like?

derfy said:
I have tried making the changes in the gray colored code as you suggested,
but I'm still getting the same massage. Please don't give up on as I'm still
counting on your help.

Kathleen Anderson said:
Make the change in the gray colored code and save the change while you're
still in Code View - FrontPage will leave it alone.
--

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




derfy said:
I thank you so far for your help. Right now I'm trying to correct the
problem, I have opened the page live in FrontPage and I've tried to
provide
the missing values but I keep getting this message:

"The contents of a FrontPage component have been modified.
These contents will be overwritten when you save this page."

The long and short of this is that I've not been able to provide the
missing
values. What should I do now?

:

You need to provide values for the 2 fields (StudentID and LastName) in
you SQL Statement
fp_sQry="SELECT * FROM Students WHERE (StudentID = ::StudentID:: AND
LastName = '::LastName::')"
- right now they are both empty
fp_sDefault="StudentID=&LastName="

For a guide on how to set up a DBRW search form to not return an error
when first loaded (haven't provided values yet)
see http://spiderwebwoman.com/resources/dbrwtipsandtricks.asp#return

--

_____________________________________________
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/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Ok, ok I get that, and sorry for my ignorance. This is the SQL
statement:
|
| fp_sQry="SELECT * FROM Students WHERE (StudentID = ::StudentID:: AND
| LastName = '::LastName::')"
| fp_sDefault="StudentID=&LastName="
| fp_sNoRecords="<tr><td colspan=7 align=left width=""100%"">Sorry, no
records
| returned.</td></tr>"
| fp_sDataConn="Database1"
| fp_iMaxRecords=256
| fp_iCommandType=1
| fp_iPageSize=0
| fp_fTableFormat=True
| fp_fMenuFormat=False
| fp_sMenuChoice=""
| fp_sMenuValue=""
| fp_iDisplayCols=7
| fp_fCustomQuery=False
| BOTID=0
| fp_iRegion=BOTID
|
| I'm still counting on your help.
|
| "Stefan B Rusynko" wrote:
|
| > SQL statement is a generic term for the DBRW query statement
| > Starting at in code view at
| > fp_sQry=
| >
| > The address to the page does not help because all the server side
code is already processed and not visible to anyone
| >
| > --
| >
| > _____________________________________________
| > 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/FrontPageNewsGroups/tabid/53/Default.aspx
| > _____________________________________________
| >
| >
| > | Actually I did not create the database with SQL, I created it with
MS Access.
| > | I then imported it into my website, followed the step by step
instructions in
| > | the "Add a form for seaching a database." You can get this
instruction by
| > | typing "database" in the "Ask a Question" text field in the
FrontPage
| > | application interface. This is the address to the page:
| > | http://www.supanetghana.com/student_details.asp.
| > |
| > | I hope this information will be enough for you to help. Thanks
| > |
| > | "Kathleen Anderson [MVP - FrontPage]" wrote:
| > |
| > | > Post your SQL statement here and we'll take a look.
| > | >
| > | > --
| > | >
| > | > ~ Kathleen Anderson
| > | > Microsoft MVP - FrontPage
| > | > Spider Web Woman Designs
| > | > web: http://www.spiderwebwoman.com/resources/
| > | > FrontPage Support: http://www.frontpagemvps.com/
| > | >
| > | >
| > | >
| > | >
| > | > | > | > >I have created form in my website to search a database. The page
works
| > | > > alright, however, I keep getting this error message below:
| > | > >
| > | > > Database Results Error
| > | > > Description: Syntax error (missing operator) in query
expression
| > | > > '(StudentID
| > | > > = AND LastName = '')'.
| > | > > 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.
| > | > >
| > | > > Is there anything I can do so that I do not continue to get the
message?
| > | >
| > | >
| > | >
| >
| >
| >
 
D

derfy

I have tried making the changes in the gray colored code as you suggested,
but I'm still getting the same massage. Please don't give up on as I'm still
counting on your help.

Kathleen Anderson said:
Make the change in the gray colored code and save the change while you're
still in Code View - FrontPage will leave it alone.
--

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




derfy said:
I thank you so far for your help. Right now I'm trying to correct the
problem, I have opened the page live in FrontPage and I've tried to
provide
the missing values but I keep getting this message:

"The contents of a FrontPage component have been modified.
These contents will be overwritten when you save this page."

The long and short of this is that I've not been able to provide the
missing
values. What should I do now?

Stefan B Rusynko said:
You need to provide values for the 2 fields (StudentID and LastName) in
you SQL Statement
fp_sQry="SELECT * FROM Students WHERE (StudentID = ::StudentID:: AND
LastName = '::LastName::')"
- right now they are both empty
fp_sDefault="StudentID=&LastName="

For a guide on how to set up a DBRW search form to not return an error
when first loaded (haven't provided values yet)
see http://spiderwebwoman.com/resources/dbrwtipsandtricks.asp#return

--

_____________________________________________
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/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Ok, ok I get that, and sorry for my ignorance. This is the SQL
statement:
|
| fp_sQry="SELECT * FROM Students WHERE (StudentID = ::StudentID:: AND
| LastName = '::LastName::')"
| fp_sDefault="StudentID=&LastName="
| fp_sNoRecords="<tr><td colspan=7 align=left width=""100%"">Sorry, no
records
| returned.</td></tr>"
| fp_sDataConn="Database1"
| fp_iMaxRecords=256
| fp_iCommandType=1
| fp_iPageSize=0
| fp_fTableFormat=True
| fp_fMenuFormat=False
| fp_sMenuChoice=""
| fp_sMenuValue=""
| fp_iDisplayCols=7
| fp_fCustomQuery=False
| BOTID=0
| fp_iRegion=BOTID
|
| I'm still counting on your help.
|
| "Stefan B Rusynko" wrote:
|
| > SQL statement is a generic term for the DBRW query statement
| > Starting at in code view at
| > fp_sQry=
| >
| > The address to the page does not help because all the server side
code is already processed and not visible to anyone
| >
| > --
| >
| > _____________________________________________
| > 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/FrontPageNewsGroups/tabid/53/Default.aspx
| > _____________________________________________
| >
| >
| > | Actually I did not create the database with SQL, I created it with
MS Access.
| > | I then imported it into my website, followed the step by step
instructions in
| > | the "Add a form for seaching a database." You can get this
instruction by
| > | typing "database" in the "Ask a Question" text field in the
FrontPage
| > | application interface. This is the address to the page:
| > | http://www.supanetghana.com/student_details.asp.
| > |
| > | I hope this information will be enough for you to help. Thanks
| > |
| > | "Kathleen Anderson [MVP - FrontPage]" wrote:
| > |
| > | > Post your SQL statement here and we'll take a look.
| > | >
| > | > --
| > | >
| > | > ~ Kathleen Anderson
| > | > Microsoft MVP - FrontPage
| > | > Spider Web Woman Designs
| > | > web: http://www.spiderwebwoman.com/resources/
| > | > FrontPage Support: http://www.frontpagemvps.com/
| > | >
| > | >
| > | >
| > | >
| > | > | > | > >I have created form in my website to search a database. The page
works
| > | > > alright, however, I keep getting this error message below:
| > | > >
| > | > > Database Results Error
| > | > > Description: Syntax error (missing operator) in query
expression
| > | > > '(StudentID
| > | > > = AND LastName = '')'.
| > | > > 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.
| > | > >
| > | > > Is there anything I can do so that I do not continue to get the
message?
| > | >
| > | >
| > | >
| >
| >
| >
 
K

Kathleen Anderson [MVP - FrontPage]

"SELECT * FROM Students WHERE (StudentID = '::StudentID::') AND (LastName =
'::LastName::')"


--

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


derfy said:
I can now modify the code without getting any message that the content can
not be changed. My problem now is how the statement should be like. I have
tried the following but it will still not work:
"SELECT * FROM Students WHERE (StudentID = +" StudentID ::StudentID:: AND
LastName = +" LastName '::LastName::')".
Can any one help me with how the statement should be like?

derfy said:
I have tried making the changes in the gray colored code as you
suggested,
but I'm still getting the same massage. Please don't give up on as I'm
still
counting on your help.

Kathleen Anderson said:
Make the change in the gray colored code and save the change while
you're
still in Code View - FrontPage will leave it alone.
--

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




I thank you so far for your help. Right now I'm trying to correct the
problem, I have opened the page live in FrontPage and I've tried to
provide
the missing values but I keep getting this message:

"The contents of a FrontPage component have been modified.
These contents will be overwritten when you save this page."

The long and short of this is that I've not been able to provide the
missing
values. What should I do now?

:

You need to provide values for the 2 fields (StudentID and LastName)
in
you SQL Statement
fp_sQry="SELECT * FROM Students WHERE (StudentID = ::StudentID::
AND
LastName = '::LastName::')"
- right now they are both empty
fp_sDefault="StudentID=&LastName="

For a guide on how to set up a DBRW search form to not return an
error
when first loaded (haven't provided values yet)
see http://spiderwebwoman.com/resources/dbrwtipsandtricks.asp#return

--

_____________________________________________
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/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Ok, ok I get that, and sorry for my ignorance. This is the SQL
statement:
|
| fp_sQry="SELECT * FROM Students WHERE (StudentID = ::StudentID::
AND
| LastName = '::LastName::')"
| fp_sDefault="StudentID=&LastName="
| fp_sNoRecords="<tr><td colspan=7 align=left width=""100%"">Sorry,
no
records
| returned.</td></tr>"
| fp_sDataConn="Database1"
| fp_iMaxRecords=256
| fp_iCommandType=1
| fp_iPageSize=0
| fp_fTableFormat=True
| fp_fMenuFormat=False
| fp_sMenuChoice=""
| fp_sMenuValue=""
| fp_iDisplayCols=7
| fp_fCustomQuery=False
| BOTID=0
| fp_iRegion=BOTID
|
| I'm still counting on your help.
|
| "Stefan B Rusynko" wrote:
|
| > SQL statement is a generic term for the DBRW query statement
| > Starting at in code view at
| > fp_sQry=
| >
| > The address to the page does not help because all the server
side
code is already processed and not visible to anyone
| >
| > --
| >
| > _____________________________________________
| > 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/FrontPageNewsGroups/tabid/53/Default.aspx
| > _____________________________________________
| >
| >
| > | Actually I did not create the database with SQL, I created it
with
MS Access.
| > | I then imported it into my website, followed the step by step
instructions in
| > | the "Add a form for seaching a database." You can get this
instruction by
| > | typing "database" in the "Ask a Question" text field in the
FrontPage
| > | application interface. This is the address to the page:
| > | http://www.supanetghana.com/student_details.asp.
| > |
| > | I hope this information will be enough for you to help. Thanks
| > |
| > | "Kathleen Anderson [MVP - FrontPage]" wrote:
| > |
| > | > Post your SQL statement here and we'll take a look.
| > | >
| > | > --
| > | >
| > | > ~ Kathleen Anderson
| > | > Microsoft MVP - FrontPage
| > | > Spider Web Woman Designs
| > | > web: http://www.spiderwebwoman.com/resources/
| > | > FrontPage Support: http://www.frontpagemvps.com/
| > | >
| > | >
| > | >
| > | >
| > | > | > | > >I have created form in my website to search a database. The
page
works
| > | > > alright, however, I keep getting this error message below:
| > | > >
| > | > > Database Results Error
| > | > > Description: Syntax error (missing operator) in query
expression
| > | > > '(StudentID
| > | > > = AND LastName = '')'.
| > | > > 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.
| > | > >
| > | > > Is there anything I can do so that I do not continue to
get the
message?
| > | >
| > | >
| > | >
| >
| >
| >
 
D

derfy

I can't help feeling bad about this whole thing, because this thread has drag
on for days, but with no success. I now feel like I am bothering you. I have
made the changes and this is the message I got:

"Database Results Error
Description: Data type mismatch in criteria expression.
Number: -2147217913 (0x80040E07)
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 how the code look like after I made the changes:
"SELECT * FROM Students WHERE (StudentID = '::StudentID::') AND (LastName =
'::LastName::')"

Please help me out since I don't want to give for the sake of myself and of
those who might be facing this same problem. Thank you.


Kathleen Anderson said:
"SELECT * FROM Students WHERE (StudentID = '::StudentID::') AND (LastName =
'::LastName::')"


--

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


derfy said:
I can now modify the code without getting any message that the content can
not be changed. My problem now is how the statement should be like. I have
tried the following but it will still not work:
"SELECT * FROM Students WHERE (StudentID = +" StudentID ::StudentID:: AND
LastName = +" LastName '::LastName::')".
Can any one help me with how the statement should be like?

derfy said:
I have tried making the changes in the gray colored code as you
suggested,
but I'm still getting the same massage. Please don't give up on as I'm
still
counting on your help.

:

Make the change in the gray colored code and save the change while
you're
still in Code View - FrontPage will leave it alone.
--

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




I thank you so far for your help. Right now I'm trying to correct the
problem, I have opened the page live in FrontPage and I've tried to
provide
the missing values but I keep getting this message:

"The contents of a FrontPage component have been modified.
These contents will be overwritten when you save this page."

The long and short of this is that I've not been able to provide the
missing
values. What should I do now?

:

You need to provide values for the 2 fields (StudentID and LastName)
in
you SQL Statement
fp_sQry="SELECT * FROM Students WHERE (StudentID = ::StudentID::
AND
LastName = '::LastName::')"
- right now they are both empty
fp_sDefault="StudentID=&LastName="

For a guide on how to set up a DBRW search form to not return an
error
when first loaded (haven't provided values yet)
see http://spiderwebwoman.com/resources/dbrwtipsandtricks.asp#return

--

_____________________________________________
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/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Ok, ok I get that, and sorry for my ignorance. This is the SQL
statement:
|
| fp_sQry="SELECT * FROM Students WHERE (StudentID = ::StudentID::
AND
| LastName = '::LastName::')"
| fp_sDefault="StudentID=&LastName="
| fp_sNoRecords="<tr><td colspan=7 align=left width=""100%"">Sorry,
no
records
| returned.</td></tr>"
| fp_sDataConn="Database1"
| fp_iMaxRecords=256
| fp_iCommandType=1
| fp_iPageSize=0
| fp_fTableFormat=True
| fp_fMenuFormat=False
| fp_sMenuChoice=""
| fp_sMenuValue=""
| fp_iDisplayCols=7
| fp_fCustomQuery=False
| BOTID=0
| fp_iRegion=BOTID
|
| I'm still counting on your help.
|
| "Stefan B Rusynko" wrote:
|
| > SQL statement is a generic term for the DBRW query statement
| > Starting at in code view at
| > fp_sQry=
| >
| > The address to the page does not help because all the server
side
code is already processed and not visible to anyone
| >
| > --
| >
| > _____________________________________________
| > 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/FrontPageNewsGroups/tabid/53/Default.aspx
| > _____________________________________________
| >
| >
| > | Actually I did not create the database with SQL, I created it
with
MS Access.
| > | I then imported it into my website, followed the step by step
instructions in
| > | the "Add a form for seaching a database." You can get this
instruction by
| > | typing "database" in the "Ask a Question" text field in the
FrontPage
| > | application interface. This is the address to the page:
| > | http://www.supanetghana.com/student_details.asp.
| > |
| > | I hope this information will be enough for you to help. Thanks
| > |
| > | "Kathleen Anderson [MVP - FrontPage]" wrote:
| > |
| > | > Post your SQL statement here and we'll take a look.
| > | >
| > | > --
| > | >
| > | > ~ Kathleen Anderson
| > | > Microsoft MVP - FrontPage
| > | > Spider Web Woman Designs
| > | > web: http://www.spiderwebwoman.com/resources/
| > | > FrontPage Support: http://www.frontpagemvps.com/
| > | >
| > | >
| > | >
| > | >
| > | > | > | > >I have created form in my website to search a database. The
page
works
| > | > > alright, however, I keep getting this error message below:
| > | > >
| > | > > Database Results Error
| > | > > Description: Syntax error (missing operator) in query
expression
| > | > > '(StudentID
| > | > > = AND LastName = '')'.
| > | > > 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.
| > | > >
| > | > > Is there anything I can do so that I do not continue to
get the
message?
| > | >
| > | >
| > | >
| >
| >
| >
 
K

Kathleen Anderson [MVP - FrontPage]

Is StudentID a numeric field? If so, try this: "SELECT * FROM Students
WHERE (StudentID = ::StudentID::) AND (LastName = '::LastName::')" You
should add this page to your favorites:
http://support.microsoft.com/kb/306430

Stefan already gave you the answer on how to eliminate the "default values"
error message.


--

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


derfy said:
I can't help feeling bad about this whole thing, because this thread has
drag
on for days, but with no success. I now feel like I am bothering you. I
have
made the changes and this is the message I got:

"Database Results Error
Description: Data type mismatch in criteria expression.
Number: -2147217913 (0x80040E07)
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 how the code look like after I made the changes:
"SELECT * FROM Students WHERE (StudentID = '::StudentID::') AND (LastName
=
'::LastName::')"

Please help me out since I don't want to give for the sake of myself and
of
those who might be facing this same problem. Thank you.


Kathleen Anderson said:
"SELECT * FROM Students WHERE (StudentID = '::StudentID::') AND (LastName
=
'::LastName::')"


--

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


derfy said:
I can now modify the code without getting any message that the content
can
not be changed. My problem now is how the statement should be like. I
have
tried the following but it will still not work:
"SELECT * FROM Students WHERE (StudentID = +" StudentID ::StudentID::
AND
LastName = +" LastName '::LastName::')".
Can any one help me with how the statement should be like?

:

I have tried making the changes in the gray colored code as you
suggested,
but I'm still getting the same massage. Please don't give up on as I'm
still
counting on your help.

:

Make the change in the gray colored code and save the change while
you're
still in Code View - FrontPage will leave it alone.
--

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




I thank you so far for your help. Right now I'm trying to correct
the
problem, I have opened the page live in FrontPage and I've tried
to
provide
the missing values but I keep getting this message:

"The contents of a FrontPage component have been modified.
These contents will be overwritten when you save this page."

The long and short of this is that I've not been able to provide
the
missing
values. What should I do now?

:

You need to provide values for the 2 fields (StudentID and
LastName)
in
you SQL Statement
fp_sQry="SELECT * FROM Students WHERE (StudentID = ::StudentID::
AND
LastName = '::LastName::')"
- right now they are both empty
fp_sDefault="StudentID=&LastName="

For a guide on how to set up a DBRW search form to not return an
error
when first loaded (haven't provided values yet)
see
http://spiderwebwoman.com/resources/dbrwtipsandtricks.asp#return

--

_____________________________________________
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/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Ok, ok I get that, and sorry for my ignorance. This is the SQL
statement:
|
| fp_sQry="SELECT * FROM Students WHERE (StudentID =
::StudentID::
AND
| LastName = '::LastName::')"
| fp_sDefault="StudentID=&LastName="
| fp_sNoRecords="<tr><td colspan=7 align=left
width=""100%"">Sorry,
no
records
| returned.</td></tr>"
| fp_sDataConn="Database1"
| fp_iMaxRecords=256
| fp_iCommandType=1
| fp_iPageSize=0
| fp_fTableFormat=True
| fp_fMenuFormat=False
| fp_sMenuChoice=""
| fp_sMenuValue=""
| fp_iDisplayCols=7
| fp_fCustomQuery=False
| BOTID=0
| fp_iRegion=BOTID
|
| I'm still counting on your help.
|
| "Stefan B Rusynko" wrote:
|
| > SQL statement is a generic term for the DBRW query statement
| > Starting at in code view at
| > fp_sQry=
| >
| > The address to the page does not help because all the server
side
code is already processed and not visible to anyone
| >
| > --
| >
| > _____________________________________________
| > 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/FrontPageNewsGroups/tabid/53/Default.aspx
| > _____________________________________________
| >
| >
| > | Actually I did not create the database with SQL, I created
it
with
MS Access.
| > | I then imported it into my website, followed the step by
step
instructions in
| > | the "Add a form for seaching a database." You can get this
instruction by
| > | typing "database" in the "Ask a Question" text field in the
FrontPage
| > | application interface. This is the address to the page:
| > | http://www.supanetghana.com/student_details.asp.
| > |
| > | I hope this information will be enough for you to help.
Thanks
| > |
| > | "Kathleen Anderson [MVP - FrontPage]" wrote:
| > |
| > | > Post your SQL statement here and we'll take a look.
| > | >
| > | > --
| > | >
| > | > ~ Kathleen Anderson
| > | > Microsoft MVP - FrontPage
| > | > Spider Web Woman Designs
| > | > web: http://www.spiderwebwoman.com/resources/
| > | > FrontPage Support: http://www.frontpagemvps.com/
| > | >
| > | >
| > | >
| > | >
message
| > | >
| > | > >I have created form in my website to search a database.
The
page
works
| > | > > alright, however, I keep getting this error message
below:
| > | > >
| > | > > Database Results Error
| > | > > Description: Syntax error (missing operator) in query
expression
| > | > > '(StudentID
| > | > > = AND LastName = '')'.
| > | > > 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.
| > | > >
| > | > > Is there anything I can do so that I do not continue to
get the
message?
| > | >
| > | >
| > | >
| >
| >
| >
 
D

derfy

I love ya all!!! Everything is now working perfectly. It needn't have gotten
this far, I only directed the first page's form to post to the second page's
form, as it has cleary been instructed at
http://support.microsoft.com/kb/306430.

Many thanks to you all for the troubles I have caused you. Hope you'll be
willing to help me the next time round. I thank you so much.


Kathleen Anderson said:
Is StudentID a numeric field? If so, try this: "SELECT * FROM Students
WHERE (StudentID = ::StudentID::) AND (LastName = '::LastName::')" You
should add this page to your favorites:
http://support.microsoft.com/kb/306430

Stefan already gave you the answer on how to eliminate the "default values"
error message.


--

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


derfy said:
I can't help feeling bad about this whole thing, because this thread has
drag
on for days, but with no success. I now feel like I am bothering you. I
have
made the changes and this is the message I got:

"Database Results Error
Description: Data type mismatch in criteria expression.
Number: -2147217913 (0x80040E07)
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 how the code look like after I made the changes:
"SELECT * FROM Students WHERE (StudentID = '::StudentID::') AND (LastName
=
'::LastName::')"

Please help me out since I don't want to give for the sake of myself and
of
those who might be facing this same problem. Thank you.


Kathleen Anderson said:
"SELECT * FROM Students WHERE (StudentID = '::StudentID::') AND (LastName
=
'::LastName::')"


--

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


I can now modify the code without getting any message that the content
can
not be changed. My problem now is how the statement should be like. I
have
tried the following but it will still not work:
"SELECT * FROM Students WHERE (StudentID = +" StudentID ::StudentID::
AND
LastName = +" LastName '::LastName::')".
Can any one help me with how the statement should be like?

:

I have tried making the changes in the gray colored code as you
suggested,
but I'm still getting the same massage. Please don't give up on as I'm
still
counting on your help.

:

Make the change in the gray colored code and save the change while
you're
still in Code View - FrontPage will leave it alone.
--

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




I thank you so far for your help. Right now I'm trying to correct
the
problem, I have opened the page live in FrontPage and I've tried
to
provide
the missing values but I keep getting this message:

"The contents of a FrontPage component have been modified.
These contents will be overwritten when you save this page."

The long and short of this is that I've not been able to provide
the
missing
values. What should I do now?

:

You need to provide values for the 2 fields (StudentID and
LastName)
in
you SQL Statement
fp_sQry="SELECT * FROM Students WHERE (StudentID = ::StudentID::
AND
LastName = '::LastName::')"
- right now they are both empty
fp_sDefault="StudentID=&LastName="

For a guide on how to set up a DBRW search form to not return an
error
when first loaded (haven't provided values yet)
see
http://spiderwebwoman.com/resources/dbrwtipsandtricks.asp#return

--

_____________________________________________
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/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Ok, ok I get that, and sorry for my ignorance. This is the SQL
statement:
|
| fp_sQry="SELECT * FROM Students WHERE (StudentID =
::StudentID::
AND
| LastName = '::LastName::')"
| fp_sDefault="StudentID=&LastName="
| fp_sNoRecords="<tr><td colspan=7 align=left
width=""100%"">Sorry,
no
records
| returned.</td></tr>"
| fp_sDataConn="Database1"
| fp_iMaxRecords=256
| fp_iCommandType=1
| fp_iPageSize=0
| fp_fTableFormat=True
| fp_fMenuFormat=False
| fp_sMenuChoice=""
| fp_sMenuValue=""
| fp_iDisplayCols=7
| fp_fCustomQuery=False
| BOTID=0
| fp_iRegion=BOTID
|
| I'm still counting on your help.
|
| "Stefan B Rusynko" wrote:
|
| > SQL statement is a generic term for the DBRW query statement
| > Starting at in code view at
| > fp_sQry=
| >
| > The address to the page does not help because all the server
side
code is already processed and not visible to anyone
| >
| > --
| >
| > _____________________________________________
| > 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/FrontPageNewsGroups/tabid/53/Default.aspx
| > _____________________________________________
| >
| >
| > | Actually I did not create the database with SQL, I created
it
with
MS Access.
| > | I then imported it into my website, followed the step by
step
instructions in
| > | the "Add a form for seaching a database." You can get this
instruction by
| > | typing "database" in the "Ask a Question" text field in the
FrontPage
| > | application interface. This is the address to the page:
| > | http://www.supanetghana.com/student_details.asp.
| > |
| > | I hope this information will be enough for you to help.
Thanks
| > |
| > | "Kathleen Anderson [MVP - FrontPage]" wrote:
| > |
| > | > Post your SQL statement here and we'll take a look.
| > | >
| > | > --
| > | >
| > | > ~ Kathleen Anderson
| > | > Microsoft MVP - FrontPage
| > | > Spider Web Woman Designs
| > | > web: http://www.spiderwebwoman.com/resources/
| > | > FrontPage Support: http://www.frontpagemvps.com/
| > | >
| > | >
| > | >
| > | >
message
| > | >
| > | > >I have created form in my website to search a database.
The
page
works
| > | > > alright, however, I keep getting this error message
below:
| > | > >
| > | > > Database Results Error
| > | > > Description: Syntax error (missing operator) in query
expression
| > | > > '(StudentID
| > | > > = AND LastName = '')'.
| > | > > 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.
| > | > >
| > | > > Is there anything I can do so that I do not continue to
get the
message?
| > | >
| > | >
| > | >
| >
| >
| >
 
D

derfy

Sorry, I gave you wrong address to where I got the instruction from as I was
directed by Stefan and later reminded by Kathleen. This is the address:
http://spiderwebwoman.com/resources/dbrwtipsandtricks.asp#return.

derfy said:
I love ya all!!! Everything is now working perfectly. It needn't have gotten
this far, I only directed the first page's form to post to the second page's
form, as it has cleary been instructed at
http://support.microsoft.com/kb/306430.

Many thanks to you all for the troubles I have caused you. Hope you'll be
willing to help me the next time round. I thank you so much.


Kathleen Anderson said:
Is StudentID a numeric field? If so, try this: "SELECT * FROM Students
WHERE (StudentID = ::StudentID::) AND (LastName = '::LastName::')" You
should add this page to your favorites:
http://support.microsoft.com/kb/306430

Stefan already gave you the answer on how to eliminate the "default values"
error message.


--

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


derfy said:
I can't help feeling bad about this whole thing, because this thread has
drag
on for days, but with no success. I now feel like I am bothering you. I
have
made the changes and this is the message I got:

"Database Results Error
Description: Data type mismatch in criteria expression.
Number: -2147217913 (0x80040E07)
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 how the code look like after I made the changes:
"SELECT * FROM Students WHERE (StudentID = '::StudentID::') AND (LastName
=
'::LastName::')"

Please help me out since I don't want to give for the sake of myself and
of
those who might be facing this same problem. Thank you.


:

"SELECT * FROM Students WHERE (StudentID = '::StudentID::') AND (LastName
=
'::LastName::')"


--

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


I can now modify the code without getting any message that the content
can
not be changed. My problem now is how the statement should be like. I
have
tried the following but it will still not work:
"SELECT * FROM Students WHERE (StudentID = +" StudentID ::StudentID::
AND
LastName = +" LastName '::LastName::')".
Can any one help me with how the statement should be like?

:

I have tried making the changes in the gray colored code as you
suggested,
but I'm still getting the same massage. Please don't give up on as I'm
still
counting on your help.

:

Make the change in the gray colored code and save the change while
you're
still in Code View - FrontPage will leave it alone.
--

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




I thank you so far for your help. Right now I'm trying to correct
the
problem, I have opened the page live in FrontPage and I've tried
to
provide
the missing values but I keep getting this message:

"The contents of a FrontPage component have been modified.
These contents will be overwritten when you save this page."

The long and short of this is that I've not been able to provide
the
missing
values. What should I do now?

:

You need to provide values for the 2 fields (StudentID and
LastName)
in
you SQL Statement
fp_sQry="SELECT * FROM Students WHERE (StudentID = ::StudentID::
AND
LastName = '::LastName::')"
- right now they are both empty
fp_sDefault="StudentID=&LastName="

For a guide on how to set up a DBRW search form to not return an
error
when first loaded (haven't provided values yet)
see
http://spiderwebwoman.com/resources/dbrwtipsandtricks.asp#return

--

_____________________________________________
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/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Ok, ok I get that, and sorry for my ignorance. This is the SQL
statement:
|
| fp_sQry="SELECT * FROM Students WHERE (StudentID =
::StudentID::
AND
| LastName = '::LastName::')"
| fp_sDefault="StudentID=&LastName="
| fp_sNoRecords="<tr><td colspan=7 align=left
width=""100%"">Sorry,
no
records
| returned.</td></tr>"
| fp_sDataConn="Database1"
| fp_iMaxRecords=256
| fp_iCommandType=1
| fp_iPageSize=0
| fp_fTableFormat=True
| fp_fMenuFormat=False
| fp_sMenuChoice=""
| fp_sMenuValue=""
| fp_iDisplayCols=7
| fp_fCustomQuery=False
| BOTID=0
| fp_iRegion=BOTID
|
| I'm still counting on your help.
|
| "Stefan B Rusynko" wrote:
|
| > SQL statement is a generic term for the DBRW query statement
| > Starting at in code view at
| > fp_sQry=
| >
| > The address to the page does not help because all the server
side
code is already processed and not visible to anyone
| >
| > --
| >
| > _____________________________________________
| > 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/FrontPageNewsGroups/tabid/53/Default.aspx
| > _____________________________________________
| >
| >
| > | Actually I did not create the database with SQL, I created
it
with
MS Access.
| > | I then imported it into my website, followed the step by
step
instructions in
| > | the "Add a form for seaching a database." You can get this
instruction by
| > | typing "database" in the "Ask a Question" text field in the
FrontPage
| > | application interface. This is the address to the page:
| > | http://www.supanetghana.com/student_details.asp.
| > |
| > | I hope this information will be enough for you to help.
Thanks
| > |
| > | "Kathleen Anderson [MVP - FrontPage]" wrote:
| > |
| > | > Post your SQL statement here and we'll take a look.
| > | >
| > | > --
| > | >
| > | > ~ Kathleen Anderson
| > | > Microsoft MVP - FrontPage
| > | > Spider Web Woman Designs
| > | > web: http://www.spiderwebwoman.com/resources/
| > | > FrontPage Support: http://www.frontpagemvps.com/
| > | >
| > | >
| > | >
| > | >
message
| > | >
| > | > >I have created form in my website to search a database.
The
page
works
| > | > > alright, however, I keep getting this error message
below:
| > | > >
| > | > > Database Results Error
| > | > > Description: Syntax error (missing operator) in query
expression
| > | > > '(StudentID
| > | > > = AND LastName = '')'.
| > | > > 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.
| > | > >
| > | > > Is there anything I can do so that I do not continue to
get the
message?
| > | >
| > | >
| > | >
| >
| >
| >
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Database Interface Wizard 3
DBI update failure 8
DRW Error 7
DBRW Issue - Syntax Error 11
Database Update 16
Error help 3
Database Interface Wizard 6
DIW - Cant Update records 2

Top