Home | Products | Consulting | Forums | Support | Order | 1-800-752-0455
  Main
Index
Search
Posts
Who's
Online
Log
In

Home: Products: Listings Manager (Realty Manager & Auto Manager):
excluding fields in a search?

 

 


dedbob
User

Apr 25, 2003, 8:01 PM

Post #1 of 8 (2155 views)
Shortcut
excluding fields in a search? Can't Post

Sorry if this has been asked before... but I couldn't find any info on it.

I run http://www.corvettetraderonline.com and I need to be able to exclude sold Corvettes from my normal searches, specifically the link searches in the menubar. My current links look like this:

http://www.corvettetraderonline.com/cgi-bin/am/exec/search.cgi?search=1&perpage=7&sort_order=10,123,forward&marknew=30&lfield4_keyword=C3

How would I construct this to exclude sold Corvettes ( $lfield16$ )?

Any help would be appreciated Smile

Thanks,
Scott Edwards
http://www.corvettetraderonline.com

Need ImageMagick? GD.pm? You need to GetStacked!
Listings Manager friendly Cheap Web Hosting only $5.95 a month!


Mike R
Staff


Apr 26, 2003, 2:01 PM

Post #2 of 8 (2138 views)
Shortcut
Re: [dedbob] excluding fields in a search? [In reply to] Can't Post

Hi Shane,

Here is how I would recommend that you go about setting this up (you may already have your $lfield16$ setup this way)...

Go into Setup Options for Auto Manager, and then "Setup Listing Fields". Create a custom field called "Status" and give it two options - "Available" and "Sold". Make the field type a dropdown menu, and type the options like so:

Status (Available, Sold)

Don't bother adding a comma before the word "Available", that way all listings you add will be available by default, and you would only have to change it if you want to change a vehicle's status to "Sold".

Then, you will need to add the following line of code into the form in the /templates/_search_query.html file:

<input type="hidden" name="lfield16_keyword" value="Available">

(Assuming you've used field #16 when you added the "Status" options)

Then, any listings that have been change to a status of "Sold" will not be shown in the search results, while all listings that are "Available" will show up.

I hope this helps, and please let me know if you want any additional details. :)
Mike Roulston
interactivetools.com


dedbob
User

Apr 30, 2003, 1:46 AM

Post #3 of 8 (2106 views)
Shortcut
Re: [Mike R] excluding fields in a search? [In reply to] Can't Post

Well I hadn't thought of doing it that way, but I did and it werked :-]. I was hoping for something like exclude_lfield16_keyword=SOLD... but it's not really necessary I guess. Your suggestion did of course, add the extra word "Available" in all of my pages, but what they heck... I get the same result and that all that matters.

Anyway... this will save me mucho bandwidth. Not to mention, I can keep my listings uncluttered AND still have all of my pages crawlable by googlebot via the listings index page.

Thanks for the help!

Scott
http://www.corvettetraderonline.com

Need ImageMagick? GD.pm? You need to GetStacked!
Listings Manager friendly Cheap Web Hosting only $5.95 a month!


Donna
Staff / Moderator


Apr 30, 2003, 8:57 AM

Post #4 of 8 (2098 views)
Shortcut
Re: [dedbob] excluding fields in a search? [In reply to] Can't Post

Hi Scott!

Glad to hear that's working for you. :)

You don't HAVE to have the word "available" on all of your searches. Since the search engine is querying the database, and the field is in the database anyway, there's no reason that you have to display it on the listings page... unless, of course, you want to. :)

Let me know if you have any other questions. :)

Cheers!
Donna

Donna


Hire me!
Save time by getting our experts to help with your project. Template changes, advanced features, full integration, whatever you need. Whether you need one hour or fifty, get it done fast with Priority Consulting.


dedbob
User

Apr 30, 2003, 10:11 AM

Post #5 of 8 (2094 views)
Shortcut
Re: [Donna] excluding fields in a search? [In reply to] Can't Post

hmmm.... I understand that it's in the database and searchable even if it's not on the page, but if $lfield16$ contains both Available and SOLD, there's no way to remove one and not the other (I think), being that I have to mark sold cars as sold on the individual page.

Are you saying that I can display "SOLD" on some pages and not display "Available" on others, when they are both $lfield16$ and being that I'm forcing them to select one of them? Crazy

If so... I obviously missed something. Let me know Smile

Thanks,
Scott Edwards
http://www.corvettetraderonline.com

Need ImageMagick? GD.pm? You need to GetStacked!
Listings Manager friendly Cheap Web Hosting only $5.95 a month!


Donna
Staff / Moderator


Apr 30, 2003, 2:58 PM

Post #6 of 8 (2088 views)
Shortcut
Re: [dedbob] excluding fields in a search? [In reply to] Can't Post

Hi Scott!

Ah, I see what you're getting at. You're right, it's generally not built in to display one but not the other.

You could setup a conditional statement, such as the one Ben describes in this post:

http://www.interactivetools.com/forum/forum.cgi?post=10309

You'd have to muck around with it a bit to recognize the difference between sold and not sold.

The other option would be to setup a listing field that only has two choices -- "Sold" or nothing at all. (So, it would be a dropdown like this: Status (,Sold)

Then it would only display the Sold status, since the "Available" status would be blank.

Would be a little difficult to search on "Available" vehicles, though.

In any event, I hope that bumps you in the right direction. :)

Let me know if you have any further questions.

Donna


Hire me!
Save time by getting our experts to help with your project. Template changes, advanced features, full integration, whatever you need. Whether you need one hour or fifty, get it done fast with Priority Consulting.


(This post was edited by Donna on Jun 30, 2003, 11:44 AM)


leeshields
User

Jul 1, 2003, 12:43 AM

Post #7 of 8 (2012 views)
Shortcut
Re: [dedbob] excluding fields in a search? [In reply to] Can't Post

Hi

If you want to display SOLD on your listings, or Available for that matter, you could use the field status to display an image

setup 2 (or more) gifs named, available.gif and sold.gif, offer.gif etc etc

then setup the sold field to select the image, you can still use this for a search etc, if you dont want to display anything just create a blank gif

you can see this in action on http://www.villassist.com/varm/exec/search.cgi

the direct sale/promoter sale/sold icon under the image is done this way

heres the code

<img src="../../media/$lfield4$.gif" width="150" height="25">

simple!

hope this helps
__

Lee Shields
Apogee Technology
John R Hornsby
Adelante Properties
Villassist
Paul Withey Estate Agents


Donna
Staff / Moderator


Jul 1, 2003, 10:51 AM

Post #8 of 8 (2004 views)
Shortcut
Re: [leeshields] excluding fields in a search? [In reply to] Can't Post

Thanks, Lee! That's another good way of doing it. :)

Donna


Hire me!
Save time by getting our experts to help with your project. Template changes, advanced features, full integration, whatever you need. Whether you need one hour or fifty, get it done fast with Priority Consulting.

 
 
 


Search for (options)
Products
CMS Builder
Article Manager
Realty Manager
Listings Manager
Order Now
Services
Priority Consulting
Support
Online Documentation
Support Forums
Support Homepage
Company Info
12 reasons to choose us!
Meet the team
Monthly newsletter
Contact Us
Toll Free: 1-800-752-0455
Phone: (604) 689-3347
Sales | Support
Conditions of Use | Privacy Policy | Copyright © interactivetools.com 2008
#201 - 2730 Commercial Drive, Vancouver BC Canada V5N 5P4