Re: Arbitrary limits on length of data in cart header fields?
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 26220
interpreted = N
texte = On 1/18/00 8:03 am, jpeacock@univpress.com so noted...>Just for your further edification, because of the way that WebCat displays IP >addresses, _all_ IP addresses are exactly 15 characters long >(999.999.999.999).Yes. That's what I meant by saying that if I was trying to store an IP address under CartIPAddress that was longer than 15 characters, I obviously must have some fairly serious bug in my code that the field limitation may mask (it certainly wouldn't *help* : )>As for your question about field lengths, PCS will need to document any >fields >that are not explicitly listed in the on-line docs (under the Purchase >command).Since the only limit mentioned in the docs is the 255 character limit for the Header fields, I had assumed all fields had the same limitation -- my mistake. I'd dearly like SM to outline the limits of the other fields.> I can tell you that it is always faster to use fixed length fields. I >suspect >if you have already used up 40 * 255 bytes in the Header fields that you >need to >revisit your database design. If you had a secondary database, tied by Cart >number to the Order File, you would still have RAM speed access to your >data. >What are you trying to store in the Header fields, if I may be so bold?I haven't used up all the available bytes in the Header fields, but I do have them set aside for 40 separate items of data. Short of doubling up the data on each (ok, one *does* hold 5 items that later get split apart with [listwords]) I thought I could make do with some of my unused named fields.I'm using the header fields within the site for a few saved state values, and during the final ordering process to store customer data over several pages of forms (without including a few dozen hidden form fields to bucket-brigade them along each page). I *could* modify the site to use a cart number-linked secondary database to hold this info, but why, when I have the primary database of the Order File right there already? I just need to know how much junk I can put into its various nooks and crannies ; )P.S. I had made a suggestion on the beta list a couple months back along the lines of doing for the Order File what WebCat 2.0 did for databases, giving user-control over the number and name of header fields. Sure would like to see *that* one come to be : ) Rob Marquardt Designer/Resident Wirehead Toast Design800 Washington Avenue North Minneapolis MN 55401 612.330.9863 v 612.321.9424 f www.toastdesign.com ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to
.This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Associated Messages, from the most recent to the oldest:
On 1/18/00 8:03 am, jpeacock@univpress.com so noted...>Just for your further edification, because of the way that WebCat displays IP >addresses, _all_ IP addresses are exactly 15 characters long >(999.999.999.999).Yes. That's what I meant by saying that if I was trying to store an IP address under CartIPAddress that was longer than 15 characters, I obviously must have some fairly serious bug in my code that the field limitation may mask (it certainly wouldn't *help* : )>As for your question about field lengths, PCS will need to document any >fields >that are not explicitly listed in the on-line docs (under the Purchase >command).Since the only limit mentioned in the docs is the 255 character limit for the Header fields, I had assumed all fields had the same limitation -- my mistake. I'd dearly like SM to outline the limits of the other fields.> I can tell you that it is always faster to use fixed length fields. I >suspect >if you have already used up 40 * 255 bytes in the Header fields that you >need to >revisit your database design. If you had a secondary database, tied by Cart >number to the order file, you would still have RAM speed access to your >data. >What are you trying to store in the Header fields, if I may be so bold?I haven't used up all the available bytes in the Header fields, but I do have them set aside for 40 separate items of data. Short of doubling up the data on each (ok, one *does* hold 5 items that later get split apart with [listwords]) I thought I could make do with some of my unused named fields.I'm using the header fields within the site for a few saved state values, and during the final ordering process to store customer data over several pages of forms (without including a few dozen hidden form fields to bucket-brigade them along each page). I *could* modify the site to use a cart number-linked secondary database to hold this info, but why, when I have the primary database of the order file right there already? I just need to know how much junk I can put into its various nooks and crannies ; )P.S. I had made a suggestion on the beta list a couple months back along the lines of doing for the order file what WebCat 2.0 did for databases, giving user-control over the number and name of header fields. Sure would like to see *that* one come to be : ) Rob Marquardt Designer/Resident Wirehead Toast Design800 Washington Avenue North Minneapolis MN 55401 612.330.9863 v 612.321.9424 f www.toastdesign.com ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Rob Marquardt
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
user/password validation (1998)
RE: too many nested [xxx] (1997)
[WebDNA] Internal [ipaddress] ? (2009)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
math on date? (1997)
include bug????? (1997)
Running _every_ page through WebCat ? (1997)
WebCat2: Found Items syntax, etc. (1997)
Dummy Credit Card Number for debug? (1997)
WebCat editing, SiteGuard & SiteEdit (1997)
[cart][date][time] (2003)
Hiding the URL(was Cart ID Duplication) (2001)
[WriteFile] problems (1997)
if then logic (2005)
Help! WebCat2 bug (1997)
FileMaker and WebCat - .hdr OK Merge not OK (1999)
Including a php script (2003)
Sort Order on a page search (1997)
Re:listfiles-looking for slick solution (1997)
Looking for a special Image Upload Script (2004)