M Silvester New Member Posts:24  
| 07/04/2006 1:32 AM |
|
|
We seem ot have run into a limit to how many categories a document may belong to, it seems to be 75? Is this limitation resolvable? Can I assign more than 75 categories?
|
|
|
|
Peter Donker Veteran Member Posts:4536
| 07/05/2006 2:44 PM |
|
|
If you adjust the necessary SQL you could. Categories are stored in a semicolon separated list in DMX_Entries. All you'd need to do is to enlarge the field length and make sure this is also reflected in the INSERT and UPDATE sprocs.
|
|
|
|
M SilvesterNew Member Posts:24
| 07/07/2006 9:32 PM |
|
|
I've changed the categories column length to 2000 in DMX_Entries, but I'm not sure what sproc's to change and where. I just changed the @categories parameters in the sql for DMX_AddEntries and DMX_UpdateEntries sproc's and I still have the limitation, Seems I've missed something but not sure what.
|
|
|
|
M SilvesterNew Member Posts:24
| 07/07/2006 11:36 PM |
|
|
Please disregard the above, the changes i listed above work now, I must have been to impatient and neglected to clear the cache or something.
|
|
|
|
Peter DonkerVeteran Member Posts:4536
| 07/08/2006 5:08 PM |
|
|
Yes, make sure the cache is cleared ...
|
|
|
|