PaulR
Thu Oct 26 15:49:02 CDT 2006
With debug and # in place of' i get
Database Results Wizard Error
Unable to find operator in query string. Query string currently is SELECT *
FROM meetings WHERE (Meetingdate = #::Meetingdate::#) ORDER BY LNo ASC
with the ' I get no error.
Paul
"Kathleen Anderson [MVP - FrontPage]" wrote:
> One thing I see is that you have a field in your table called 'month', which
> is a Microsoft Jet 4.0 reserved word
>
http://support.microsoft.com/?id=321266 Even though you're not using it in
> your SQL, that may still be a problem.
>
> Here's something else you can try: open the hidden folder /_fpclass/ and
> edit the fpdbrgn1.inc file
>
> At about line 19, change :
>
> fp_DEBUG = False
>
> to :
>
> fp_DEBUG = True
>
> and then preview the page in your browser.
>
>
> --
>
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> web:
http://www.spiderwebwoman.com/resources/
>
>
> "PaulR" <PaulR@discussions.microsoft.com> wrote in message
> news:D7FC4827-C0A4-46A6-A1C5-F3E361A78F8A@microsoft.com...
> > Kathleen,
> > I get an error if I do this.
> > both in developer time:
> > "This is the start of a Database Results region. The page must be fetched
> > from a web server with a web browser to display correctly; the current web
> > is
> > stored on your local disk or network. The custom query contains errors."
> > and in run time
> > "Database Results Wizard Error
> > The operation failed. If this continues, please contact your server
> > administrator."
> > Paul
> >
> >
> > "Kathleen Anderson [MVP - FrontPage]" wrote:
> >
> >> In Code View, make the change to the gray code and save the change while
> >> still in code view. The change will propagate to the maroon code.
> >>
> >> --
> >>
> >> ~ Kathleen Anderson
> >> Microsoft MVP - FrontPage
> >> Spider Web Woman Designs
> >> web:
http://www.spiderwebwoman.com/resources/
> >>
> >>
> >> "PaulR" <PaulR@discussions.microsoft.com> wrote in message
> >> news:DFBEAB98-BCE0-4B09-89BD-952C0A8966DD@microsoft.com...
> >> > Kathleen, thanks for the suggestion.
> >> > FrontPage just changes the code back again!!
> >> > Is there an update to the webbot that cures the issue?
> >> >
> >> > Regards
> >> > Paul
> >> >
> >> > "Kathleen Anderson [MVP - FrontPage]" wrote:
> >> >
> >> >> Try WHERE (Meetingdate = #::Meetingdate::#)
> >> >>
> >> >> see:
> >> >>
http://support.microsoft.com/default.aspx?scid=kb;en-us;284843&Product=fp2002
> >> >>
> >> >> --
> >> >>
> >> >> ~ Kathleen Anderson
> >> >> Microsoft MVP - FrontPage
> >> >> Spider Web Woman Designs
> >> >> web:
http://www.spiderwebwoman.com/resources/
> >> >>
> >> >>
> >> >> "PaulR" <PaulR@discussions.microsoft.com> wrote in message
> >> >> news:014904F8-B276-4127-AA3E-821DBC6900B5@microsoft.com...
> >> >> >I thought it was a locale issue at first, but if you translate
> >> >> >American
> >> >> >dates
> >> >> > they do not always work.
> >> >> > for example 1/9/07 and 9/1/07 should return info.
> >> >> >
> >> >> > In answer to Davids Question, the scripts are below.
> >> >> > I should point out that the fault is there even is you use just the
> >> >> > FP
> >> >> > webbots. (i.e. I have eliminated my VBscript code)
> >> >> >
> >> >> > Paul
> >> >> >
> >> >> > The VBscript is
> >> >> > <!--
> >> >> > Sub Calendar1_Click()
> >> >> > 'set the locale to UK english
> >> >> > Dim meetingdate
> >> >> > Dim original
> >> >> > original = setlocale("en-gb")
> >> >> > meetingdate=calendar1.value
> >> >> > window.navigate("calendar.asp?meetingdate="&meetingdate)End Sub
> >> >> > -->
> >> >> > FP then uses this webbot
> >> >> > <!--webbot bot="DatabaseRegionStart"
> >> >> > s-columnnames="LodgeName,LNo,lodgetype,meetingtype,Expr1,Meetingdate,month,Expr2,Expr3,LodgeID,hallid,Expr4,Expr5,Expr6"
> >> >> > s-columntypes="202,3,202,202,135,135,3,2,2,3,3,135,135,135"
> >> >> > s-dataconnection="masonic" b-tableformat="TRUE" b-menuformat="FALSE"
> >> >> > s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE"
> >> >> > b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
> >> >> > i-listformat="0" b-makeform="FALSE" s-recordsource="meetings"
> >> >> > s-displaycolumns="LodgeName,LNo,Meetingdate,meetingtype,lodgetype"
> >> >> > s-criteria="[Meetingdate] EQ {Meetingdate} +" s-order="[LNo] +"
> >> >> > s-sql="SELECT
> >> >> > * FROM meetings WHERE (Meetingdate = '::Meetingdate::') ORDER BY
> >> >> > LNo
> >> >> > ASC"
> >> >> > b-procedure="FALSE" clientside suggestedext="asp"
> >> >> > s-defaultfields="Meetingdate=10/10/07" s-norecordsfound="Choose
> >> >> > meeting
> >> >> > date
> >> >> > from calendar" i-maxrecords="256" i-groupsize="0" botid="0"
> >> >> > u-dblib="../_fpclass/fpdblib.inc"
> >> >> > u-dbrgn1="../_fpclass/fpdbrgn1.inc"
> >> >> > u-dbrgn2="../_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td
> >> >> > colspan=64
> >> >> > bgcolor="#FFFF00" width="100%"><font color="#000000">This is the
> >> >> > start
> >> >> > of
> >> >> > a
> >> >> > Database Results region. The page must be fetched from a web server
> >> >> > with a
> >> >> > web browser to display correctly; the current web is stored on your
> >> >> > local
> >> >> > disk or network.</font></td></tr>" startspan --><!--#include
> >> >> > file="../_fpclass/fpdblib.inc"-->
> >> >> >
> >> >> > With thes parameters.
> >> >> > <%
> >> >> > fp_sQry="SELECT * FROM meetings WHERE (Meetingdate =
> >> >> > '::Meetingdate::')
> >> >> > ORDER BY LNo ASC"
> >> >> > fp_sDefault="Meetingdate=10/10/07"
> >> >> > fp_sNoRecords="<tr><td colspan=5 align=""LEFT""
> >> >> > width=""100%"">Choose
> >> >> > meeting date from calendar</td></tr>"
> >> >> > fp_sDataConn="masonic"
> >> >> > fp_iMaxRecords=256
> >> >> > fp_iCommandType=1
> >> >> > fp_iPageSize=0
> >> >> > fp_fTableFormat=True
> >> >> > fp_fMenuFormat=False
> >> >> > fp_sMenuChoice=""
> >> >> > fp_sMenuValue=""
> >> >> > fp_sColTypes="&LodgeName=202&LNo=3&lodgetype=202&meetingtype=202&Expr1=135&Meetingdate=135&month=3&Expr2=2&Expr3=2&LodgeID=3&hallid=3&Expr4=135&Expr5=135&Expr6=135&"
> >> >> > fp_iDisplayCols=5
> >> >> > fp_fCustomQuery=False
> >> >> > BOTID=0
> >> >> > fp_iRegion=BOTID
> >> >> > %>
> >> >> >
> >> >> > </SCRIPT>
> >> >> >
> >> >> >
> >> >> >
> >> >> > "David Berry" wrote:
> >> >> >
> >> >> >> When I choose 1/9/07 the querystring in the browser shows 9/1/07
> >> >> >>
http://www.derbyshiremason.org/newpglroot/masonicConcepts/calendar.asp?meetingdate=09/01/2007
> >> >> >>
> >> >> >> All the choices I make are flipping the month and the day in the
> >> >> >> querystring.
> >> >> >>
> >> >> >> Either there's a problem in the code or the regional settings on
> >> >> >> the
> >> >> >> server
> >> >> >> (which your ISP has to change - you can't change them).
> >> >> >>
> >> >> >> What is the code you're using when a visitor chooses a date on the
> >> >> >> calendar?
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >> "PaulR" <PaulR@discussions.microsoft.com> wrote in message
> >> >> >> news:251DAAEF-0885-4881-B6A0-1526D9221713@microsoft.com...
> >> >> >> > Hi there,
> >> >> >> > I have an Access database embeded in a site. It uses ASP pages to
> >> >> >> > return
> >> >> >> > data.
> >> >> >> > Recently my ISP provider moved from an older versin to IIS6 /
> >> >> >> > Windows2003
> >> >> >> > server.
> >> >> >> >
> >> >> >> > Most pages still work, but any with a date function do not.
> >> >> >> >
> >> >> >> > The database now only returns certain dates, for example
> >> >> >> > 10/10/2007
> >> >> >> > works,
> >> >> >> > but 01/09/2007 does not, even thougth this date has valid
> >> >> >> > database
> >> >> >> > entries.
> >> >> >> > The fault is reproduceable at:
> >> >> >> >
http://www.derbyshiremason.org/newpglroot/masonicConcepts/calendar.asp
> >> >> >> >
> >> >> >> > I have tried changing the locale to both US and GB, but this does
> >> >> >> > not
> >> >> >> > affect
> >> >> >> > the problem.
> >> >> >> >
> >> >> >> > I have heard that date formats in IIS6 /SQL2003 have changed so
> >> >> >> > that
> >> >> >> > they
> >> >> >> > now have date and time.
> >> >> >> >
> >> >> >> > Any ideas?
> >> >> >> >
> >> >> >> > Regards
> >> >> >> > Paul
> >> >> >> >
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>