[AT] Classified advertising

[Spencer Yost]

The title would be a problem because the ad numbers were reset.   There is no easy way to tie the data in the old file to the records in the new database since the adnumbers don't agree.   However I noticed you 12 records in the classifieds and only 6-8 appeared truncated.  If you renew each record you also have the opportunity to modify the title in the process.  That process shouldn't take more than 10-15 minutes.

I apologize for the truncation but I did a length test when setting up the database at the time I started this project last fall and I created the database fields with lengths set to the maximum values found then.   At any rate, I bumped it up from 30 characters to 40 characters today so going forward you have more characters to work with.

The extra asterisks in the URL were reformatting thing I forgot to clean up.  That has been fixed.

Take care,

Spencer

*********** REPLY SEPARATOR  ***********

On 3/19/2004 at 6:18 PM John Boehm wrote:

>Spencer- I've check the ads that I have running and
>noticed that the titles for the ads are truncated to a
>small portion of the previous length. Also my website
>URL's have had the "/" converted to  "**", rendering
>them unusable. Is there any way these two items can be
>corrected? Thanks,
>
>John Boehm
>Woodland, CA
>Visit my web site at http://vintagetractors.com
>
>
>--- Spencer Yost <Spencer.Yost at piedmontsystems.com>
>wrote:
>> The classified advertising system now supports
>> narrowing results geographically.   You can specify
>> which state you want and the software will return
>> the items that meet your other search criteria and
>> are in the state you choose and any states bordering
>> it.    For example, a search on Florida return items
>> in Florida, Georgia and Alabama.
>> 
>> I also rewrote a good chuck of the code to convert
>> it to different database technology and programming
>> approaches.  It should be a bit faster not to
>> mention easier for me to maintain and improve upon
>> later.
>> 
>> 
>> Hope you enjoy,
>> 
>> Spencer
>> 
>> 
>> _______________________________________________
>> AT mailing list
>> http://www.antique-tractor.com/mailman/listinfo/at
>
>
>__________________________________
>Do you Yahoo!?
>Yahoo! Mail - More reliable, more storage, less spam
>http://mail.yahoo.com
>_______________________________________________
>AT mailing list
>http://www.antique-tractor.com/mailman/listinfo/at