Frontpage database query syntax weirdness

[DeltaGamma]

Have a page with a query produced using dbwiz connecting to a query in an
mdb. When the ISPs server is using FP2K all works well. However when the
ISPs server is using FP2002 there is syntax error. In particular, my FP
produces a line that looks like:

fp_sQry="SELECT * FROM ""TG2Customer Purchases Query"" WHERE (Us....

however the ""'s fail on 2002, and when replaced with ['s as per:

fp_sQry="SELECT * FROM [TG2Customer Purchases Query] WHERE (Us

all is well.

Unfortunately, the only way to produce the "acceptable" syntax is to ask the
ISP to edit the file on the server side, since editing the syntax at my end
simply results with FP's script interpreter (or whatever) automatically and
unilaterally changing it back as soon as the file is saved.

Is there some way to either have the server accept the ""'s, or to force the
FP client at my end to take the required syntax (... and how is it possible
to have such gross syntax conflicts anyway ???)

 

[Kathleen Anderson [MVP - FrontPage]]

I'm not sure what's cauing the problem with FrontPage, but a way to fix the
problem would be to rename the database table so there are no spaces in it.

 

[DeltaGamma]

Thanks for that, though surely it is quite "doubly weird" that it works with
one syntax and not the other and simultanesouly that the working syntax is
not accepted by the client's interpreter. Perhaps that aspect of this is
might go in a bug report somewhere.