mariovaldez.net

Hi!!

Yes, i know that i am the "length limitation" guy.

The thing is that i usually put barcodes in the "product model" field. OSCPMWIN limits that field to 12 characters (i think by default is the oscommerce value)

i modified the lenght of that field directly in the database to 16 characters (cause the barcodes have usually 13) but the OSCPMWIN doesn´t realize of that change, and the limitation continues.

Mario, how is the lenght of the product model window decided? Is fixed to 12?

It would be very interesting not to have that limitation or to read the value directly form the database.

Regards from Spain

Luis:

> Yes, i know that i am the "length limitation" guy.

He he. Don't worry, I see you more like the "no-limits guy", so keep your suggestions comming.

> The thing is that i usually put barcodes in the
> "product model" field. OSCPMWIN limits that
> field to 12 characters (i think by default is the
> oscommerce value) i modified the lenght of
> that field directly in the database to 16 characters
> (cause the barcodes have usually 13) but the
> OSCPMWIN doesn´t realize of that change, and
> the limitation continues. Mario, how is the lenght
> of the product model window decided?
> Is fixed to 12?

Yes, the size limits are fixed. I based the limits in the default osCommerce code.

Just for the record, current length limits are:
Model = 12
Name = 64
Weight = 7
Price = 17
Quantity = 16
URL = 255
Image URL = 64
Description = 32000
Special = 12
Category Name = 32
Language Name = 32
Manufacturer Name = 32

These limits are really UI limits (they are enforced only when accepting input from the user), after the user interface there is nothing limiting the length. Even memory structures don't have these limits.

So, I can:

expand the limits blindly, or
let the user set the size via the configuration window, or
ask the database once (when starting) about the limits.

I think I'll do the third option... easier for me and for the final user.

> It would be very interesting not to
> have that limitation or to read the
> value directly form the database.

I'll test some code tonight, and let you know.

Regards,

Mario A. Valdez-Ramirez.

Luis:

About the model-length limit, I have changed it (blindly) to 25 characters (to support also users of the CRE Loaded 6 version of OSC). This is true since version 0.1.0.416.

The reason to do it blindly (the application doesn't really check the database field-size) is that with the new experimental (not yet released) SQL-HTTP backend interface I cannot yet get the field sizes. To avoid rewriting everything for another backend, I'm sticking with minimal DB features. I'll fix this later.

All this means that you can now use your longer model strings without problems. Please test it.


Regards,

Mario A. Valdez-Ramirez.