FP2003 Database Result custom query setup

[MJ Smith]

I am trying to look up a record in an access database
through the database results wizard. I have not been able
to find out how to set up the custom query. Perhaps I have
the syntax incorrect. I have tried to 'insert
parameter ...' in the custom sql dialog box. This adds the
parameter name with double colons in front and behind the
field a form field like SELECT * FROM quotes WHERE
(quote_id = ::random_quote_id:. quote_id is the access
field name and random_quote_id is generated with vbscript
in asp.

Any ideas?

 

[Jon]

Hi,
FP won't accept a variable in the DRW - only form and querystring
parameters. There's a couple of ways to get FP to accept parameters, none of
them very pretty, but before we go that route as you know VB Script why not
code up the whole thing yourself and lose the FP wizard, this would be the
best solution all round?

Jon
Microsoft MVP - FP

 

[MJ Smith]

Unfortunately I don't know vbscript, at lease for the
database connections. I know php but am moving to asp to
use frontpage 2003. I have set up a connection to the
msaccess database in the site settings. I have been able
to set up a database result page so I know the conneciton
works. From there I haven't had much success to code the
database query manually yet.