Filterind Database reuslts - still in trouble

[Mick]

Sorry Group, I am still in trouble on this one, please see below, any help
would be very much appreciated.Thanks 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.

 

[Nicholas Savalas - http://savalas.tv]

Dear Mick,
Try something like:

SELECT * FROM properties WHERE villa <> ""

You might want to watch this. It is a step by step:
http://viewhow2.qarbon.com/vf/rkxxqps/6/formdata_viewlet.html
Good luck.

 

[Mick]

Thanks Nicholas, will have a go.
Cheers Mick