Page 5 of 12 FirstFirst ... 34567 ... LastLast
Results 41 to 50 of 118
  1. #41
    Join Date
    May 2006
    Location
    Gardiner, Maine
    Posts
    2,289
    Plugin Contributions
    22

    Default Re: Product Delivery by Postcode (PDP) - [Support]

    There's always limits on a database field, no matter what type. In this case we are talking the configuration table - mysql text fields. I'm sorry, D, you obviously hit a ceiling there!
    The full-time Zen Cart Guru. WizTech4ZC.com

  2. #42
    Join Date
    Nov 2007
    Location
    Sunny Coast, Australia
    Posts
    3,379
    Plugin Contributions
    9

    Default Re: Product Delivery by Postcode (PDP) - [Support]

    Quote Originally Posted by delia View Post
    There's always limits on a database field, no matter what type. In this case we are talking the configuration table - mysql text fields. I'm sorry, D, you obviously hit a ceiling there!
    Yep, that's all I can think of too.

    Would be a matter of finding out what safe character limit may be set to any given DB field and then amend the params for that field in the DB.

  3. #43
    Join Date
    May 2006
    Location
    Gardiner, Maine
    Posts
    2,289
    Plugin Contributions
    22

    Default Re: Product Delivery by Postcode (PDP) - [Support]

    I wouldn't alter it for this one thing. This affects the entire cart - it's the heart of the database and could affect performance.
    The full-time Zen Cart Guru. WizTech4ZC.com

  4. #44
    Join Date
    Sep 2008
    Location
    Essex
    Posts
    41
    Plugin Contributions
    0

    Default Re: Product Delivery by Postcode (PDP) - [Support]

    Sorry, have only just seen these replies. Can't believe after all that time and trouble I'm stuffed for it working as I need it too (deep sigh). Are you able to tell just how many postcodes the max limit is please?

    Thanks.

  5. #45
    Join Date
    Nov 2007
    Location
    Sunny Coast, Australia
    Posts
    3,379
    Plugin Contributions
    9

    Default Re: Product Delivery by Postcode (PDP) - [Support]

    Quote Originally Posted by denise006 View Post
    Sorry, have only just seen these replies. Can't believe after all that time and trouble I'm stuffed for it working as I need it too (deep sigh). Are you able to tell just how many postcodes the max limit is please?

    Thanks.
    From memory that DB field allows for max 256 characters (could be wrong though...).

    For 5 digit US postcodes that would mean about 42 postcodes (5 digits for every postcode plus one separating comma for each postcode minus one comma at the end of the array).

    Try that and let me know how many codes you are able to fit.

    As an aside, how did Delia get your copy of PDP to work? I am interested what caused the problem and what her solution was.

    Cheers / Frank

  6. #46
    Join Date
    Sep 2008
    Location
    Essex
    Posts
    41
    Plugin Contributions
    0

    Default Re: Product Delivery by Postcode (PDP) - [Support]

    Hi Frank,

    Ok thanks I'll have a play and see how many I can get in there and let you know.

    Re Delia, I think she herself didn't really know as she changed a bunch of stuff and it sprung into life. I am about to use it on another site and so far do not having it working so when I get chance to play I'll see if I have more success with that one and let you know what I come up with.

    Thanks again for coming back to me.

    D.

  7. #47
    Join Date
    Nov 2007
    Location
    Sunny Coast, Australia
    Posts
    3,379
    Plugin Contributions
    9

    Default Re: Product Delivery by Postcode (PDP) - [Support]

    Quote Originally Posted by denise006 View Post
    Hi Frank,

    Ok thanks I'll have a play and see how many I can get in there and let you know.

    Re Delia, I think she herself didn't really know as she changed a bunch of stuff and it sprung into life. I am about to use it on another site and so far do not having it working so when I get chance to play I'll see if I have more success with that one and let you know what I come up with.

    Thanks again for coming back to me.

    D.
    Thanks D - I just PM'd Delia for some clarifications.

    Cheers / Frank

  8. #48
    Join Date
    Sep 2008
    Location
    Essex
    Posts
    41
    Plugin Contributions
    0

    Default Re: Product Delivery by Postcode (PDP) - [Support]

    Hi Frank,

    I have been playing around with this and I can add 65,500 odd characters.

    Today I have been trying to mind an add-on which will achieve the same result but am struggling to find anything. Are you able to get this to work just using the first portion of a UK postcode i.e SS0 up to SS99 say as even that would work for me?

    Look forward to hearing from you.

    Thanks.

    Denise.

  9. #49
    Join Date
    Nov 2007
    Location
    Sunny Coast, Australia
    Posts
    3,379
    Plugin Contributions
    9

    Default Re: Product Delivery by Postcode (PDP) - [Support]

    Quote Originally Posted by denise006 View Post
    Hi Frank,

    I have been playing around with this and I can add 65,500 odd characters.
    Yep, 65536 chrs to be precise

    Quote Originally Posted by denise006 View Post
    Today I have been trying to mind an add-on which will achieve the same result but am struggling to find anything. Are you able to get this to work just using the first portion of a UK postcode i.e SS0 up to SS99 say as even that would work for me?
    As I mentioned earlier in this thread, UK postcodes are somewhat unique - being a numerical minded person, I am struggling to come to grips with that logic .... no offense intended, they are just the way they are.

    I need some time to learn about the UK postcodes and then try and incorporate a suitable code into my pending PDP v2.2

    I am thinking about the 'LIKE' operand when testing for allowed postcodes - that is instead of the current '=' operand

    Pls leave it with me - I have a little think about this.

    Cheers / Frank

  10. #50
    Join Date
    Sep 2008
    Location
    Essex
    Posts
    41
    Plugin Contributions
    0

    Default Re: Product Delivery by Postcode (PDP) - [Support]

    Indeed Frank, 65536 it is!

    I have a list of the postcodes I need to allow which I can send over to you if it helps, but basically all UK postcodes start with two letters re;evant to their location i.e SS (Southend-On-Sea) followed by either 1 number (if you live close to the center of that place) or up to two numbers i.e. SS1 or SS99 if you live further away from the center. These are then followed by a space and then 1 further number and then a further two letters. In short a postcode will either have a LETTERLETTERNUMBER NUMBERLETTERLETTER or LETTERLETTERNUMBERNUMBER NUMBERLETTERLETTER format depending on location. Hope that helps but if you could modify to use just the first portion of UK postcodes that would be enough to control location and then take away the character issue within a database.

    Make sense??!!

 

 
Page 5 of 12 FirstFirst ... 34567 ... LastLast

Similar Threads

  1. Order Delivery Date Support Thread
    By mrmeech in forum Managing Customers and Orders
    Replies: 534
    Last Post: 16 Jul 2021, 12:36 AM
  2. v151 Store Pickup by Delivery Postcode
    By frank18 in forum Addon Shipping Modules
    Replies: 5
    Last Post: 24 Jun 2013, 10:27 AM
  3. v150 Delivery Charge by Australian Postcode
    By melbflor in forum Built-in Shipping and Payment Modules
    Replies: 5
    Last Post: 7 Apr 2012, 07:43 AM
  4. Delivery postcode
    By evil turinp in forum Built-in Shipping and Payment Modules
    Replies: 1
    Last Post: 8 Nov 2010, 08:26 PM
  5. Wanted - Local Delivery by Postcode
    By Ryk in forum Addon Shipping Modules
    Replies: 18
    Last Post: 19 May 2010, 01:59 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR