Re: [BULK] Re: [WebDNA] Can WebDNA corrupt a db?
This WebDNA talk-list message is from 2012
It keeps the original formatting.
numero = 108054
interpreted = N
texte = Ok, since the Excel subject came up today, I started looking into it for the first time in years. Turns out Excel can't open numbers over 15 characters. You can trick Excel into thinking the number is text by wrapping it in quotes or putting a non-numerical character in front of it. So now I have two options: Make sure the cart number is 15 characters or less, or I place a random letter in front of all of my cart numbers. I don't care for the quotes idea. Can the [cart] variable be altered to 15 characters or less? I assume I could do it with [getchars], but I'm not sure if it would still remain unique. Is there a downfall to having a letter in front of my cart number, like R162389472337495033? The only thing I can think of is that it may effect some [math] code. On 1/10/12 12:00 PM, "Eddie Zelhofer"
wrote: > I've tried everything, but I'm not an expert Excel user by any means. If I > open in Excel a cart number looks like this: 1.06391E+16 instead of > 10639064155219361. If I change the formatting on the cell, the closest I can > get to the actual cart number is 10639064155219300. The first 15 characters > are correct, but it goes to zeros after that. So unless there's some sort of > setting that can be done before I open the file, I don't know how this is > possible. > > This really would come in handy for me if anyone out there knows how I could > get around this issue. > > Eddie > > > On 1/10/12 11:33 AM, "Donovan Brooke" wrote: > >> Eddie Z wrote: >>> I only use a text editor (BBEdit) for my dbs. I've never figured out how to >>> keep Excel from truncating my [cart] numbers when opening a db text file for >>> the first time though. If there's a secret to that I'd like to know it. >>> >>> Eddie >> >> It's a preference setting on the column. (format cell if remember right) >> >> Donovan >> > > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us
Associated Messages, from the most recent to the oldest:
Ok, since the Excel subject came up today, I started looking into it for the first time in years. Turns out Excel can't open numbers over 15 characters. You can trick Excel into thinking the number is text by wrapping it in quotes or putting a non-numerical character in front of it. So now I have two options: Make sure the cart number is 15 characters or less, or I place a random letter in front of all of my cart numbers. I don't care for the quotes idea. Can the [cart] variable be altered to 15 characters or less? I assume I could do it with [getchars], but I'm not sure if it would still remain unique. Is there a downfall to having a letter in front of my cart number, like R162389472337495033? The only thing I can think of is that it may effect some [math] code. On 1/10/12 12:00 PM, "Eddie Zelhofer" wrote: > I've tried everything, but I'm not an expert Excel user by any means. If I > open in Excel a cart number looks like this: 1.06391E+16 instead of > 10639064155219361. If I change the formatting on the cell, the closest I can > get to the actual cart number is 10639064155219300. The first 15 characters > are correct, but it goes to zeros after that. So unless there's some sort of > setting that can be done before I open the file, I don't know how this is > possible. > > This really would come in handy for me if anyone out there knows how I could > get around this issue. > > Eddie > > > On 1/10/12 11:33 AM, "Donovan Brooke" wrote: > >> Eddie Z wrote: >>> I only use a text editor (BBEdit) for my dbs. I've never figured out how to >>> keep Excel from truncating my [cart] numbers when opening a db text file for >>> the first time though. If there's a secret to that I'd like to know it. >>> >>> Eddie >> >> It's a preference setting on the column. (format cell if remember right) >> >> Donovan >> > > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us
Eddie Z
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:
Quitting WebMerchant ? (1997)
In Digest Dijon (2000)
Problem 2 of 2 (was: Shipping Confusion) (2000)
Online reference (1997)
Hard Questions ? (1997)
Server capacity (2003)
setting taxable to true (1997)
virtual virtual hosted store.... (1998)
vs (1997)
RE: type 2 errors with ssl server (1997)
Secure Server (1997)
Gary Chaison (2003)
[WebDNA] Triggers not working (2011)
Searching for all records (1998)
Table code broken? (2004)
How is it done? (1998)
two unique banners on one page (1997)
NetSplat and WebCat2 (1997)
Search results templates (1996)
return missing item (was:WebCat Sales) (1997)