You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by rajshekhar <cy...@yahoo.co.in> on 2006/08/12 13:46:41 UTC
width of id is not updating
I want to change the width of content ID from 20 to 150,I updated the value
of id in fieldtypemysql.xml which is in framework/entity/fieldtype.It is
showing correctly when i see in webtools entity data maintenance but still
storing the content id as max upto 20 chars.
Is there is any other modification is required in order to get effect of
it?
G.Rajshekhar
--
View this message in context: http://www.nabble.com/width-of-id-is-not-updating-tf2094948.html#a5774919
Sent from the OFBiz - User forum at Nabble.com.
Re: width of id is not updating
Posted by Chris Howe <cj...@yahoo.com>.
I would strongly suggest against doing it this way.
You now must also update all contentId foreign key
sizes. A much simpler way of achieving what it looks
like you're trying to do is to add a field to Content
called externalId and index it without duplicates.
--- rajshekhar <cy...@yahoo.co.in> wrote:
>
> hi
> Yes, you are correct,it has not updated content
> id in mysql,so now i
> have to explictly change size of columns of content
> id in mysql in order to
> characters more than 20.
> Thanks very much for your suggestion
>
> G.Rajshekhar
> --
> View this message in context:
>
http://www.nabble.com/width-of-id-is-not-updating-tf2094948.html#a5775953
> Sent from the OFBiz - User forum at Nabble.com.
>
>
Re: width of id is not updating
Posted by rajshekhar <cy...@yahoo.co.in>.
hi
Yes, you are correct,it has not updated content id in mysql,so now i
have to explictly change size of columns of content id in mysql in order to
characters more than 20.
Thanks very much for your suggestion
G.Rajshekhar
--
View this message in context: http://www.nabble.com/width-of-id-is-not-updating-tf2094948.html#a5775953
Sent from the OFBiz - User forum at Nabble.com.
Re: width of id is not updating
Posted by Scott Gray <le...@gmail.com>.
Like I said before try changing the column size in mysql as well as in
the fieldtype def.
rajshekhar wrote:
> hi
> The requirement is such that i have to take content-id as part of
> customised url. Therefore i need content id to be longer
>
> G.Rajshekhar
>
Re: width of id is not updating
Posted by rajshekhar <cy...@yahoo.co.in>.
hi
The requirement is such that i have to take content-id as part of
customised url. Therefore i need content id to be longer
G.Rajshekhar
--
View this message in context: http://www.nabble.com/width-of-id-is-not-updating-tf2094948.html#a5775350
Sent from the OFBiz - User forum at Nabble.com.
Re: width of id is not updating
Posted by Scott Gray <le...@gmail.com>.
What i mean is, why do you want contentId to be 150 characters long? Why
aren't you using contentName or description for something so long?
rajshekhar wrote:
> Actually i want to increase the lenght of content id to 150, default ofbiz
> provides only 20 characters. Since content id is of id variable i modified
> the property in fieldmysql.xml as
> <field-type-def type="id" sql-type="VARCHAR(150)"
> java-type="String"></field-type-def>
> But still it is taking 20 characters max.
>
> G.Rajshekhar
>
Re: width of id is not updating
Posted by rajshekhar <cy...@yahoo.co.in>.
Actually i want to increase the lenght of content id to 150, default ofbiz
provides only 20 characters. Since content id is of id variable i modified
the property in fieldmysql.xml as
<field-type-def type="id" sql-type="VARCHAR(150)"
java-type="String"></field-type-def>
But still it is taking 20 characters max.
G.Rajshekhar
--
View this message in context: http://www.nabble.com/width-of-id-is-not-updating-tf2094948.html#a5775253
Sent from the OFBiz - User forum at Nabble.com.
Re: width of id is not updating
Posted by Scott Gray <le...@gmail.com>.
what are you trying to achieve?
rajshekhar wrote:
> Actually i tested by adding new content also, But the newly added content
> also taking 20 characters, I am also not sure whether this good
> solution,just i think that this is one of the solution
>
> Is there is any other way?
>
> G.Rajshekhar
>
Re: width of id is not updating
Posted by rajshekhar <cy...@yahoo.co.in>.
Actually i tested by adding new content also, But the newly added content
also taking 20 characters, I am also not sure whether this good
solution,just i think that this is one of the solution
Is there is any other way?
G.Rajshekhar
--
View this message in context: http://www.nabble.com/width-of-id-is-not-updating-tf2094948.html#a5775139
Sent from the OFBiz - User forum at Nabble.com.
Re: width of id is not updating
Posted by Scott Gray <le...@gmail.com>.
Perhaps this will not update existing columns, have you tried just
expanding the column in the database? Also, are you sure this is a good
idea, all id fields will now be storing up to 150 characters?
Regards
Scott
rajshekhar wrote:
> I want to change the width of content ID from 20 to 150,I updated the value
> of id in fieldtypemysql.xml which is in framework/entity/fieldtype.It is
> showing correctly when i see in webtools entity data maintenance but still
> storing the content id as max upto 20 chars.
> Is there is any other modification is required in order to get effect of
> it?
>
>
> G.Rajshekhar
>
>