On Thu, 12 Aug 2004, ICINZ wrote:
we are following the DDC scheme for classification,i set the following MARC tags for classification no, but the Classification No. is not exactly display in the results of MARC search .It skip the zeros for ex. if the no. is 004.22 it shows only 4.22.
I think we really should change the dewey column to character data instead of number data. (The other wrong thing that happens right now is the extra zeros at the end -- 004.22 shows as 4.220000.) Would this cause problems for HLT? I know there would have to be some script clean-up, too. -- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges@skemotah.com
On 2004-08-12 11:06:11 +0100 Stephen Hedges <shedges@skemotah.com> wrote:
I think we really should change the dewey column to character data instead of number data.
Can we set it to a fixed x.y number and trim trailing 0s, or have I misunderstood Dewey Decimal again? I have my financial database set to a *.2 number, to avoid floating point errors entering my accounting systems. -- MJR/slef My Opinion Only and not of any group I know http://www.ttllp.co.uk/ for creative copyleft computing Please email about: BT alternative for line rental+DSL; Education on SMEs+EU FP6; office filing that works fast
On Thu, Aug 12, 2004 at 12:49:20PM +0100, MJ Ray said:
On 2004-08-12 11:06:11 +0100 Stephen Hedges <shedges@skemotah.com> wrote:
I think we really should change the dewey column to character data instead of number data.
Can we set it to a fixed x.y number and trim trailing 0s, or have I misunderstood Dewey Decimal again? I have my financial database set to a *.2 number, to avoid floating point errors entering my accounting systems.
The problem is that mysql helpfully trims leading 0's. Which are perfectly valid in Dewey. So we would have to write code to add 0's to the front if we did that. CHris -- Chris Cormack Programmer 027 4500 789 Katipo Communications Ltd chris@katipo.co.nz www.katipo.co.nz
Well the back end is a problem, too. There's no standard number of digits after the decimal, it can vary from book to book. Seems like character is the only logical choice. Stephen Chris Cormack said:
On Thu, Aug 12, 2004 at 12:49:20PM +0100, MJ Ray said:
On 2004-08-12 11:06:11 +0100 Stephen Hedges <shedges@skemotah.com> wrote:
I think we really should change the dewey column to character data instead of number data.
Can we set it to a fixed x.y number and trim trailing 0s, or have I misunderstood Dewey Decimal again? I have my financial database set to a *.2 number, to avoid floating point errors entering my accounting systems.
The problem is that mysql helpfully trims leading 0's. Which are perfectly valid in Dewey. So we would have to write code to add 0's to the front if we did that.
CHris
-- Chris Cormack Programmer 027 4500 789 Katipo Communications Ltd chris@katipo.co.nz www.katipo.co.nz
------------------------------------------------------- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 _______________________________________________ Koha-devel mailing list Koha-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/koha-devel
-- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges@skemotah.com
On 2004-08-12 20:25:11 +0100 Chris Cormack <chris@katipo.co.nz> wrote:
The problem is that mysql helpfully trims leading 0's. Which are perfectly valid in Dewey. So we would have to write code to add 0's to the front if we did that.
Stupid mysql. Is sprintf("%06.2f\n",$dewey) simple enough, or is it a problem with how many places Dewey is displayed? (Inspired by man perlfaq4) Maybe making it character would help LC support, though. Maybe even the same search range theory could work with both, but I forget the specifics of SQL character fields and range operators. -- MJR/slef My Opinion Only and not of any group I know http://www.ttllp.co.uk/ for creative copyleft computing Please email about: BT alternative for line rental+DSL; Education on SMEs+EU FP6; office filing that works fast
Well, before we get too carried away with trying to make the Dewey number a number, let's ask ourselves if there is really any good reason to keep it a number! It's not used in any sort of calculation, for example. Stephen MJ Ray said:
On 2004-08-12 20:25:11 +0100 Chris Cormack <chris@katipo.co.nz> wrote:
The problem is that mysql helpfully trims leading 0's. Which are perfectly valid in Dewey. So we would have to write code to add 0's to the front if we did that.
Stupid mysql. Is sprintf("%06.2f\n",$dewey) simple enough, or is it a problem with how many places Dewey is displayed? (Inspired by man perlfaq4)
Maybe making it character would help LC support, though. Maybe even the same search range theory could work with both, but I forget the specifics of SQL character fields and range operators.
-- MJR/slef My Opinion Only and not of any group I know http://www.ttllp.co.uk/ for creative copyleft computing Please email about: BT alternative for line rental+DSL; Education on SMEs+EU FP6; office filing that works fast
------------------------------------------------------- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 _______________________________________________ Koha-devel mailing list Koha-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/koha-devel
-- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges@skemotah.com
On Thu, Aug 12, 2004 at 06:06:11AM -0400, Stephen Hedges said:
On Thu, 12 Aug 2004, ICINZ wrote:
we are following the DDC scheme for classification,i set the following MARC tags for classification no, but the Classification No. is not exactly display in the results of MARC search .It skip the zeros for ex. if the no. is 004.22 it shows only 4.22.
I think we really should change the dewey column to character data instead of number data. (The other wrong thing that happens right now is the extra zeros at the end -- 004.22 shows as 4.220000.) Would this cause problems for HLT? I know there would have to be some script clean-up, too.
Yes it should be changed. In fact im pretty sure I did it for UNIDO, but as 2.0 was frozen at the time I didnt commit the changes. A change the schema, and I think only 2 subroutines. Ill go look Chris -- Chris Cormack Programmer 027 4500 789 Katipo Communications Ltd chris@katipo.co.nz www.katipo.co.nz
participants (3)
-
Chris Cormack -
MJ Ray -
Stephen Hedges