[SPT/CWIS] advanced search for date ranges?

Herr, Jeremy herrj at umich.edu
Wed May 4 17:45:44 CDT 2005


Thanks very much Ed, I didn't realize that.

 

I have a new Date-related problem that is pretty uncool.  I may have
somehow caused it indirectly myself, by editing the Date Issued field (I
renamed it to Date, then Date Occured, and tried setting the default
qualifier to W3C-DTF, but I changed everything back).

 

Anyway, now when you are editing a resource, and you set the Date Issued
and submit the changes, it first of all displays everything correctly.
But then when you browse to the resource and click Full Record, it
displays the Date Issued as 1999-11-30.  When you then edit the record,
the Date Issued has in fact been changed to 1999-11-30.

 

So I snooped in the database and found that the correct dates were still
as I had entered them in CWIS, in the CWIS.Resources table, in the
DateIssuedBegin column, but everything in the DateIssuedEnd column was
0000-00-00.  So I manually changed a couple values myself by doing:

 

mysql> update Resources set DateIssuedEnd='2005-02-21' where ResourceId
= '48';

 

And now my Resources table looks like this:

 

+------------+-----------------+---------------+

| ResourceId | DateIssuedBegin | DateIssuedEnd |

+------------+-----------------+---------------+

|         34 | 2005-02-19      | 0000-00-00    |

|         36 | 2005-03-19      | 0000-00-00    |

|         35 | 2005-03-12      | 0000-00-00    |

|         37 | 2005-04-02      | 0000-00-00    |

|         39 | 2005-02-12      | 0000-00-00    |

|         38 | 2005-02-12      | 0000-00-00    |

|         40 | 2005-04-16      | 0000-00-00    |

|         41 | 2005-02-14      | 0000-00-00    |

|         43 | 2005-04-23      | 0000-00-00    |

|         42 | 2005-02-14      | 0000-00-00    |

|         44 | 2005-02-14      | 0000-00-00    |

|         45 | 0000-00-00      | 0000-00-00    |

|         46 | 2005-02-14      | 0000-00-00    |

|         47 | 2005-02-21      | 2005-02-21    |

|         48 | 2005-02-21      | 2005-02-21    |

|         49 | 1999-11-30      | 0000-00-00    |

|         -1 | 0000-00-00      | 0000-00-00    |

+------------+-----------------+---------------+

 

Record #49 was one where I edited it again and submitted again and it
re-set the date to 1999-11-30.

 

Can anybody help me?  

 

Jeremy

 

 

-----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: Wednesday, 04 May, 2005 11:30
To: SPT / CWIS Users Discussion List
Subject: Re: [SPT/CWIS] advanced search for date ranges?

 

On Wed, May 04, at 01:44:04AM, Herr, Jeremy wrote:

>     Can I customize the advanced search feature to let users search

> for resources with Date Issued occurring within certain months, years,

> or specific ranges?  I didn't see an obvious way to do this.  You can

> search for a particular date, but not ranges that I can tell.  This is

> quite important to us, since all of our records are lectures.

 

   You can search for date ranges just by entering them into Advanced

   Search.  For example, to search for a resource issued during the
first

   half of 2003, you might enter "jan 2003 - jun 2003".  CWIS does its

   best to figure out whatever date or date range is entered, and most

   unambiguous formats are supported.

 

   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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://scout.wisc.edu/pipermail/spt-cwis-users/attachments/20050504/ef2950cd/attachment-0002.html 


More information about the SPT-CWIS-Users mailing list