Live Chat Software by Kayako |
Knowledgebase: Customizing
|
When I add a new field in Admin Area -> Manage Fieldsets there is a drop-down menu 'Database Field' - what should I select ?
Posted by - NA - on 28 July 2005 11:23 AM
|
|
|
In Admin Area -> Manage Fieldsets when you create a new Single Line Textbox (text) field you should select correct database field according to planned format of data stored. Here are some possible options : v_255_XX - textual data (255 characters max); int_XX - integer data (numeric). Use this field type to ensure correct sorting and range searches of numeric data (integer numbers); dec_XX - decimal data (numeric). Use this field type to ensure correct sorting and range searches of numeric data (decimal numbers); v_price - price. Please select this field for price storing if you use such a field. If you use several fieldsets and use v_price across them all, it will ensure compatibility of your table data with Shopping Cart module and will help in some other cases, including custom programming; v_zip - zip/postal code. Please select this field for zip/postal code storing if you use such a field. If you use several fieldsets and use v_zip across them all, it will ensure compatibility of your table data with Zip Code Radius Search module. | |
|
|
|
Comments (0)