| Revision:

metacat / src / edu / ucsb / nceas @ 2503

Name Size Revision Age Author Comment
  dbadapter 1749 over 17 years Jing Tao Revise the toDate method for sql server.
  metacat 2503 almost 16 years sgarg Fixed a bug in printSQL function. The bug came ...
  protocols 668 about 20 years Matt Jones Added License terms to source files, added more...

Latest revisions

# Date Author Comment
2503 04/22/2005 02:18 PM sgarg

Fixed a bug in printSQL function. The bug came into the picture for queries which involve multiple query groups and one of the query groups does a % search.

2491 04/14/2005 07:44 PM sgarg

Added code to delete all entries in xml_queryresult table when buildIndex for a docid is called.

2489 04/14/2005 01:51 PM sgarg

Adding the call to normalize function for now -- too many calls to normalize function are made and this needs to be looked into. Removing call to normalize function caused trouble in text like this "A&B"

2487 04/13/2005 06:22 PM sgarg

Fixed a bug in last commit. Doing a search like
pathquery version="1.2">
<returndoctype>eml://</returndoctype><returnfield>originator/individualName/surName</returnfield><querygroup operator="INTERSECT"><queryterm casesensitive="false" searchmode="contains"><value>%</value></queryterm><queryterm casesensitive="false" searchmode="contains"><value>National Center for Ecological Analysis and Synthesis</value><pathexpr>organizationName</pathexpr></queryterm></querygroup></pathquery>...

2486 04/13/2005 11:38 AM sgarg

Fixed a bug - when returnfield_id is not found in xml_returnfield, records are not added to xml_queryresults

2474 04/07/2005 05:04 PM sgarg

1. removed the call to QuerySpecification.printAttributeSQL() from QuerySpecification.printExtendedSQL()
2. in QuerySpecification.printExtendedSQL() if ( returnFieldList.size() == 0 ) then it returns null
3. DBQuery.addReturnfield() doesnt execute the element query if printExtendedSQL returns null

2473 04/07/2005 04:08 PM Chris Jones

A minor change from containAtrributeReturnField to

2472 04/07/2005 04:06 PM Chris Jones

I've added in a test in QuerySpecification.printExtendedSQL that checks
to see if attributes, and sometimes only attributes, are in the original
returnfield request. If so, the printAttributeQuery is called.

2467 04/07/2005 10:53 AM Chris Jones

Changed the handleReturnField() method so that it handles path expressions with
only attributes in the path.

2466 04/06/2005 07:04 PM sgarg

Added a check if printAttributeQuery() for returnPath to see that it is not null so that that this doesnt happen

xml_index.path like 'null' AND xml_nodes.nodename like 'id'

View revisions

Also available in: Atom