[oxid-dev-general] Adding accessing a column created in oxid database

2012-06-28 Thread Sai Chandra Sekhar Madala
Hi All, I have a requirement where I need to add an extra input for categories in admin.So, I have created a column in oxcategories table using sql script in admin-service-tools alter table oxcategories add column test varchar(128); and updated the DB views. I have also added the row in

Re: [oxid-dev-general] Adding accessing a column created in oxid database

2012-06-28 Thread Daniel Schlichtholz
Hi, did you delete the *.sql files in the public/tmp folder? Adding the field and creating the views is not enough for Oxid because sql-Statements are cached as temp files. So you need to also remove them to force Oxid to regenerate them. Best regards, -- Daniel Schlichtholz

Re: [oxid-dev-general] Adding accessing a column created in oxid database

2012-06-28 Thread Nicolas Hodin
Hello, You're using [{$ocont-oxcontents__test-value}] which gathers the test field in oxcontents table. I think you must use [{$ocont-oxcategories__test-value}] if you want to print the test field of oxcategories. Best Regards, Nicolas Hodin www.takeitweb.fr 2012/6/28 Sai Chandra Sekhar

Re: [oxid-dev-general] Adding accessing a column created in oxid database

2012-06-28 Thread Sai Chandra Sekhar Madala
Hi Mr.Daniel, Thank you.I have deleted all the files in tmp and also updated the DB views in admin and I can see the values saved in the database.I forgot to mention in my mail is that I am able to retrieve the value in category list page. Thanks Regards, Sai Chandra Sekhar.M On Thu, Jun 28,

Re: [oxid-dev-general] Adding accessing a column created in oxid database

2012-06-28 Thread Nicolas Hodin
Sai, I just checked in Azure template files and in topcategories.tpl, $ocont is an oxcontent object, you should use $ocat instead : [{$ocat-oxcategories__test-value}] . Best regards, Nicolas Hodin www.takeitweb.fr 2012/6/28 Sai Chandra Sekhar Madala saichandrashek...@devblaze.in Hi

Re: [oxid-dev-general] Adding accessing a column created in oxid database

2012-06-28 Thread Sai Chandra Sekhar Madala
Hi Nicolas, Yeah ..Thank you for the correction.I just saw where I need the requirement.I need it for the subcategory and just as we get the title of subcategory in www/out/admin/category_main.tpl (Line No 59) with [{$osubcat-oxcategories__oxtitle-value}] , I want to get the value of the test

Re: [oxid-dev-general] Adding accessing a column created in oxid database

2012-06-28 Thread Sai Chandra Sekhar Madala
Hi Nicolas, Apologies again :),the path is www/out/azure/tpl/widget/header/topcategories.tpl(Line No59). Thanks Regards, Sai Chandra Sekhar.M, DevBlaze Inc. On Thu, Jun 28, 2012 at 6:45 PM, Sai Chandra Sekhar Madala saichandrashek...@devblaze.in wrote: Hi Nicolas, Yeah ..Thank you for the