Database problems

  • Thread starter Edward A. Owens
  • Start date
E

Edward A. Owens

Hello,
I've now had several web sites that have suffered from the following
problem.
If I either open a web, or recalculate the web on the server,
all of the queries I've set-up in the Access databases throw
type mismatch errors. If I open the Database Results Wizard on the page
itself and
look at the SQL statement dengerated by FrontPage, I find quotation marks,
where no existed previously.
In other words This:
SELECT * FROM Graduation WHERE (Count_Of_Classmates >=
::Count_Of_Classmates::) ORDER BY Count_Of_Classmates DESC
becomes this:
SELECT * FROM Graduation WHERE ("Count Of Classmates" >= ::Count Of
Classmates::) ORDER BY "Count Of Classmates" DESC

When I change the Sql statement it displays incorrect results on the page
I thought I was the only person having this problem, until I found this
page - http://forums.devshed.com/t69300/s.html
with somebody having
the very same problem. Is this something people are running into a lot?
How can it be avoided.

Thanks,
e.a.o.
 
K

Kathleen Anderson [MVP - FP]

What version of FrontPage waas used to create the Database Results and what
version of FrontPage are you using now?
 
E

Edward A. Owens

Hello Kathleen,
I'm using FrontPage 2003 now.
I developed the Database Results Wizards Using Front Page 2000 (I believe. I
do know it was an earlier version)
These problems have only recently cropped up.
In fact, the first time it happened my client contacted me because suddenly
they were unable
to add entries to the database through their browser.
When I looked at the queries for that particular routine and all of the
values developed quotation marks - on their own!
It took HOURS to figure out what the problem was!
By the way, glad to see you're still here - and I love your web site!
Edward A. Owens
 
K

Kathleen Anderson [MVP - FrontPage]

Hi Edward:
Do you know if your site was recently migrated to Windows Server 2003 and if
this problem started after the move? If you don't know for sure, could you
please check with your host and let us know?

Thanks,

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