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?
| > | >
| > | >
| > | >
| >
| >
| >
AND (LastName = '::LastName::')" You