using the ?query string appended to ASP url

[Andrew Murray]

I'm using the FP 2002 Results Wizard and html forms, for writing to access
databases.

Can I use the query string like http://www.mysite.com?Name=Andrew (not a real
site link, just an example).
to display results i.e. the above would display all records with value of
'Andrew' in the field "Name".

Or won't it work with the Frontpage search results component? If I have the
search form as well in the results wizard the above query string just "echoes" to
the matching search field (that was created with the database results wizard).

If I didn't have the search field, can I still use the query string to get
specific records displayed?
so I can just use hyperlinks such as the above, rather than letting people search
themselves. Sometimes I think the search for generated doesn't return results as
desired like either returns ALL records or NOTHING !

Also, is there a way to search ANY field with a search form field like <input
type ="text name="search">

so the SQL query would be something like

SELECT * from TABLE where (Name LIKE '%::SEARCH::%' )

(syntax a bit rough )


--
Andrew Murray
Remove NOSPAM or SPAM BUSTER to reply
to reply

Outgoing message has been scanned with Norton Antivirus..

 

[Jim Buyens]

Yes, a query string can provide input to criteria that you
specify in the Datbase Results Wizard. However, you need
to specify the criteria, and not request the form field.

I'm not sure I completely understand your second question,
but you can use the ::fieldname:: convention anywhere in
the SQL statement. The only limitation is that FrontPage
will syntax-check the SQL statement before it lets you
exit the Custom Query dialog box.

For complete flexibility, you'd need to code your own page
in ASP or ASP.NET.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------