Custom Fields - Unlimited Characters

[AmperorDirect.com]

Simple question... using Miva5 SQL... can I create custom product fields that handle more than x number of characters -- similar to the prod_desc field?

Marco

____________________________________
Marco A. Zubieta
AmperorDirect.com
Internet Sales & Marketing Manager

Skype ID: marco_zubieta
http://www.AmperorDirect.com
____________________________________

[sebenza]

MivaSQl or MySQL?

If MySQL, you could log into phpMyAdmin and change the "type" for the "value" field to mediumtext.

table: s01_CFM_ProdValues

[latu]

Or you could use the:

Super Search with Extra Product Fields v5 module
http://store.latu.net/miva-modules-5/LATU-SUPERSEARCH.html

Searchable Extra Product Fields

Extra Fields can be Character, Number, Boolean/Logical, or Memo field

Field lengths can be specified for Character & Number fields; memo fields have unlimited length

Extra Fields can be included in the Product List Layouts of the PLST Product List, CTGY Category Display, or PROD Product Display pages

No limit on number of Extra Fields

[romowest]

Why can't MIVA release the source to the Custom fields module?

Even as flexible as Latu's module is, I need to customize the fields, and create primary key (product field) to a foreign table for some special queries.

As a new Miva 5 developer I find it frustrating that we don't have more Module source code examples. I am sure it is much easier for Miva 4 and earlier partners to create Miva 5 modules than it is for us new partners.

Any comment Miva?

Thanks!
Respectfully,
MRod

[wcw]

There was an old dbase trick when people wanted to avoid memo field bloat. They would use character fields and name them so they would display in order, eg M01, M02, M03, M04