Filtering database results.

[Mick]

I have a table called "property" that contains a field called "Type". I have
as asp page called "property.asp" that contains a database results area. I
wish to filter the results on the field called "Type", such it filters on a
value within the "Type" field.
example
property.asp?villa=<%=FP_FieldURL(fp_rs,"type")%>. All I get is the full
list of records, with no filtering ( in this case "Villa"). Am I attempting
the impossible or is there a syntax error. Thanks for your help

 

[Stefan B Rusynko]

You parameter is backwards
You are looking for the value(s) "villa" in the field "Type" in the table Property

property.asp?Type="villa"

See http://support.microsoft.com/kb/235554
or http://home.att.net/~codelibrary/FrontPage/tweaks.htm#Passing Query Values
--

_____________________________________________
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 have a table called "property" that contains a field called "Type". I have
| as asp page called "property.asp" that contains a database results area. I
| wish to filter the results on the field called "Type", such it filters on a
| value within the "Type" field.
| example
| property.asp?villa=<%=FP_FieldURL(fp_rs,"type")%>. All I get is the full
| list of records, with no filtering ( in this case "Villa"). Am I attempting
| the impossible or is there a syntax error. Thanks for your help

 

[Mick]

Hi Stefan, thanks for the reply, Im sure its me, but same results, I get a
full listing of the records, not just those for "villa" URL is
http://www.apartments-tenerife.com/property.asp?Type="villa"
The database results wizard gets its information from the "table" not a
"query" does this make a difference please.
I looked at similar code in the "Database Results Wizard" where in the
list.asp file. The "ID" when you hover gives you "
detail.asp?ID=<%=FP_FieldURL(fp_rs,"ID")%>
and just tried to substitute my fields, but no good.
I have looked at the two references you gave in your reply, thanks, but cant
seem to mov e forward. I realise this is my venturing into the unknown here,
thanks for your patience.