Like Tree0Likes

Best place to advertise a 27' Activator

Reply
Old 09-18-2007, 11:24 AM
  #11
OSO
Super Moderator
VIP Member
 
OSO's Avatar
 
Join Date: Oct 2003
My Boats: I like them all!!
Posts: 2,730
Default

Quote:
Originally Posted by CigDaze View Post
I agree with you, it is tough to search it the way it is now. However, it's not the OSO classifieds that has the problem, it's the people who enter in the ads. I'm sorry to say, but some people just don't know how to enter data into forms in a meaningful way. For instance: misspellings, typos, unrecognizable characters, misplaced commas and apostrophes, spaces, or empty fields really screw up the way databases process information.

Searching for a price range, or year range is the worst. You see it all. Example:
$100000
100.000
100,000.00
100 000.0

or

Year:
1999
1,999
99
'99
99'

There's just no way to process and sort that.
the software only reads whole numbers, we can put more red letter warnings but my experience has been that people don't read.
OSO is offline  
Reply With Quote
Old 09-18-2007, 11:30 AM
  #12
Platinum Member
Platinum Member
 
CigDaze's Avatar
 
Join Date: Jun 2001
Location: St. Petersburg, FL
My Boats: Cigarette 35 Cafe Racer
Posts: 21,346
Default

Quote:
Originally Posted by OSO View Post
but my experience has been that people don't read.
Yep, that's precisely what I was getting at.
CigDaze is offline  
Reply With Quote
Old 09-18-2007, 12:10 PM
  #13
Registered
 
Join Date: Feb 2006
Location: Tallahassee, FL
My Boats: 1987 Donzi 22; 2008 Donzi 28 ZXO
Posts: 1,654
Default

Quote:
Originally Posted by OSO View Post
I don't know when the last time you used it was but all of those things work perfect for me.

When people input info and in red letters next to price input field it says NO DECIMALS OR COMMAS and they put 75,000.00 we can not help that.

Furthermore, you can click on the column headers to re-arrange the price, length, year, etc by ascending, descending, etc.

If you give me an example of what you want to search for I can show you how to use it properly.

I'm a web developer, so I have experience with this. If the user needs to enter things in a certain format, then you have to force them. Don't submit the bad data. Use a pop up or otherwise to alert the user. It's a necessary evil to ensure things work properly.

As far as the search goes, I can try to search for anything and all I get is the following:
Quote:
We found ##numrows## matching listings. Now displaying listings ##lower## to ##upper## Save This Search

Switch layout to list view
##rows##
##nav##
I can tell you that this is not my search criteria, because I've tried things as simple as "propeller" or "drive" or "shifter" with the same results.

When I click the column headers, because the database is not set up properly, it doesn't make any sense. It goes from 10,000 to 100,000, then back to 11,000. Stuck between 329,000 and 369,000 is a boat for 36,500. In a nutshell, the price is stored as a varchar (or similar) datatype instead of a decimal or money type.

I don't mean to sound like a jerk, etc. It just isn't really set up like other web sites are. If you need help, just let me know.
VetteLT193 is offline  
Reply With Quote
Old 09-18-2007, 01:03 PM
  #14
OSO
Super Moderator
VIP Member
 
OSO's Avatar
 
Join Date: Oct 2003
My Boats: I like them all!!
Posts: 2,730
Default

Quote:
Originally Posted by VetteLT193 View Post
I'm a web developer, so I have experience with this. If the user needs to enter things in a certain format, then you have to force them. Don't submit the bad data. Use a pop up or otherwise to alert the user. It's a necessary evil to ensure things work properly.

As far as the search goes, I can try to search for anything and all I get is the following:


I can tell you that this is not my search criteria, because I've tried things as simple as "propeller" or "drive" or "shifter" with the same results.

When I click the column headers, because the database is not set up properly, it doesn't make any sense. It goes from 10,000 to 100,000, then back to 11,000. Stuck between 329,000 and 369,000 is a boat for 36,500. In a nutshell, the price is stored as a varchar (or similar) datatype instead of a decimal or money type.

I don't mean to sound like a jerk, etc. It just isn't really set up like other web sites are. If you need help, just let me know.

the 10,000 to 100,000 is a simple fix. The other is happening in the parts section not boats so now that I see that I can fix it.
OSO is offline  
Reply With Quote
Reply

Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
ratman
General Boating Discussion
41
12-22-2007 09:13 AM
anasazi
Formula
1
11-07-2007 02:31 PM
NORTECH-ANGLER
General Boating Discussion
9
09-17-2007 06:56 PM
inbetween
Trucks, Trailers and Transportation
7
04-19-2006 04:34 PM
toolman
General Boating Discussion
6
09-11-2004 02:39 PM



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -5. The time now is 05:30 AM.


Copyright 2011 OffShoreOnly. All rights reserved.