mariovaldez.net

MV.net forums
It is currently 14 Jul 2016, 00:34

All times are UTC - 7 hours




Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 
Author Message
PostPosted: 28 Aug 2004, 12:58 

Joined: 27 Aug 2004, 12:10
Posts: 4
Location: Cantabria, SPAIN
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


Report this post
Top
 Profile  
Reply with quote  
 Post subject: Field size limits...
PostPosted: 28 Aug 2004, 16:47 
User avatar

Joined: 06 Mar 2003, 03:21
Posts: 447
Location: Monterrey, NL, Mexico
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.


:idea: 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.


Report this post
Top
 Profile  
Reply with quote  
PostPosted: 07 Sep 2004, 23:16 
User avatar

Joined: 06 Mar 2003, 03:21
Posts: 447
Location: Monterrey, NL, Mexico
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.


Report this post
Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 

All times are UTC - 7 hours


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group