Robert Petersen <[EMAIL PROTECTED]> wrote:
> So finally to the question, how do others go about parsing the
> results of a QUER?
You can customize the output format to help delimit records/PR's. Take
a look at gnatsweb.pl for an example on how to customize the query
format:
2341 my $format="\"%s";
2342
2343 my @columns = $q->param('columns');
2344 # We are using ASCII octal 037 (unit separator) to separate the
2345 # fields in the query output. Note that the format strings are
2346 # interpolated (quoted with ""'s), so make sure to escape any $ or @
2347 # signs.
2348 foreach (@columns) {
2349 if (fieldinfo ($_, 'fieldtype') eq 'date') {
2350 $format .= "\037%{%Y-%m-%d %H:%M:%S %Z}D";
2351 } elsif (fieldinfo ($_, 'fieldtype') eq 'enum') {
2352 $format .= "\037%d";
2353 } else {
2354 $format .= "\037%s";
2355 }
2356 }
2357
2358 $format .= "\" ".${NUMBER_FIELD}." ".join (" ", @columns);
_______________________________________________
Help-gnats mailing list
[email protected]
http://lists.gnu.org/mailman/listinfo/help-gnats
