re: using the ?query string appended to ASP url

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jim Buyens (news_at_interlacken.com)
Date: 05/11/04 

Date: Tue, 11 May 2004 10:09:11 -0700

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)
|/---------------------------------------------------
*----------------------------------------------------

>-----Original Message-----
>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..
>
>
>.
>

Relevant Pages

  • Re: Combo box wizard "Find & GoTo Record" missing in Access 2007 b
    ... "Brendan Reynolds" wrote: ... name, a query name, or a SQL statement in the Record Source property, ... The wizard no ...
    (microsoft.public.access.forms)
  • Re: Could not determine which columns uniquely identify the rows for (a table)
    ... The query I used in the wizard was; ... the only common link I could find was that the column ... It can however create the selects no matter what. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Access-check box - checked, if checked it opens another form?
    ... If you then use the Query Builder Wizard, you'll end up with a query which will "join" the two tables together so you can view related values from both tables. ... If you then use the Forms Wizard to build a form based on that Query, the Wizard will ask you if you want to use a subform or a linked form with this data. ... Either way, your users could use the standard record controls to add related records, with no programming. ...
    (microsoft.public.access.gettingstarted)
  • Re: Access combo box-show name, not ID, in table?
    ... But I tried started with the Control Wizard, ... > what table to open etc...but provide a nice menu that opens up a nice form. ... but display the suppler name. ... > a good idea for end users), then you have to use the query builder, and join ...
    (microsoft.public.access.gettingstarted)
  • Re: Have a Query use a Form?
    ... the reason your form should be based on a query and how to get ... designed table and then click the Autoform wizard on the toolbar. ... Then with the form in design view, tweak it more to your liking. ... Name the combobox something meaningful. ...
    (microsoft.public.access.gettingstarted)