Frontpage hyperlink query parameter all values option

[Trevor]

I've created a web page to display selected records from an access db table
based on the value of a field on a hyperlink to the page and this works for
specified values. I haven't been able to get it to select (by default) all
records. The field I'm selecting on is a numeric (autonumber) field and I've
tried coding on the hyperlink >0, <>0, %, *, nothing all of which caused the
linked page and query to return no records. What should I code on the
hyperlink or elsewhere to get all records if no parameter supplied. The
hyperlink and asp code is pasted below.

<frame name="list" src="list.asp?WRRef=17" target="_self">

fp_sQry="SELECT * FROM ""web wr list query"" WHERE (""WR Reference"" LIKE
'::WRRef::') "
fp_sDefault="WRRef="
fp_sNoRecords="<tr><td colspan=12 align=""LEFT"" width=""100%"">No records
returned.</td></tr>"
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""

 

[Stefan B Rusynko]

Start by redoing your DB so none of the fields (or tables, or saved queries) have any spaces in their names

If WR_Reference is your autonumber field it should be

fp_sQry="SELECT * FROM yourtablenamehere WHERE WR_Reference > 0"

(above is in std handcoded ASP format - I don't use the wizards)


--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| I've created a web page to display selected records from an access db table
| based on the value of a field on a hyperlink to the page and this works for
| specified values. I haven't been able to get it to select (by default) all
| records. The field I'm selecting on is a numeric (autonumber) field and I've
| tried coding on the hyperlink >0, <>0, %, *, nothing all of which caused the
| linked page and query to return no records. What should I code on the
| hyperlink or elsewhere to get all records if no parameter supplied. The
| hyperlink and asp code is pasted below.
|
| <frame name="list" src="list.asp?WRRef=17" target="_self">
|
| fp_sQry="SELECT * FROM ""web wr list query"" WHERE (""WR Reference"" LIKE
| '::WRRef::') "
| fp_sDefault="WRRef="
| fp_sNoRecords="<tr><td colspan=12 align=""LEFT"" width=""100%"">No records
| returned.</td></tr>"
| fp_fTableFormat=True
| fp_fMenuFormat=False
| fp_sMenuChoice=""
| fp_sMenuValue=""
|
|
|
| --
| Trevor