[SPT/CWIS] Advanced Search limits don't work

Herr, Jeremy herrj at umich.edu
Thu May 5 18:06:09 CDT 2005


Cool!  That did in fact fix it.

-----Original Message-----
From: spt-cwis-users-bounces at scout.wisc.edu
[mailto:spt-cwis-users-bounces at scout.wisc.edu] On Behalf Of Edward
Almasy
Sent: Thursday, 05 May, 2005 12:56
To: SPT / CWIS Users Discussion List
Subject: Re: [SPT/CWIS] Advanced Search limits don't work

On Thu, May 05, at 11:04:37AM, Herr, Jeremy wrote:
> 	This may have been noted already, but in the Advanced Search
> page, setting limits always yields 0 results.  For example, all 14 of
> our resources are in English, and I checked to see that they were all
> correctly labeled.  But searching under Date Issued 1999 - 2005 (which
> otherwise yields every single resource) AND limiting to language =
> English yields 0 results.

   This is a problem with some versions of MySQL.  If you add at least
   one controlled name variant (doesn't matter what value or where --
you
   just need to have at least one in the system so it's not querying off
   of an empty table) it should fix the above.

   Ed


-- 
   Edward Almasy
ealmasy at scout.wisc.edu
   Co-Director                                         1210 W Dayton
Street
   Internet Scout Project                                  Madison WI
53706
   Computer Sciences Department                        608-262-6606
(voice)
   University of Wisconsin - Madison                     608-265-9296
(fax)
_______________________________________________
SPT-CWIS-Users mailing list
SPT-CWIS-Users at scout.wisc.edu
http://scout.wisc.edu/mailman/listinfo/spt-cwis-users




More information about the SPT-CWIS-Users mailing list