RE: [BULK] Re: [WebDNA] Can WebDNA corrupt a db?

This WebDNA talk-list message is from

2012

It keeps the original formatting. numero = 108063
interpreted = N
texte = In Excel ...Select Colum, Format Cell, Set Number and Decimal Place 0.....we use it all the time to manage WebDNA DB, cart number and all withoutissue.Cheers TDn-----Original Message-----From: Eddie Z [mailto:eddie@thinksite.com] Sent: Wednesday, January 11, 2012 02:01To: talk@webdna.usSubject: Re: [BULK] Re: [WebDNA] Can WebDNA corrupt a db?Importance: LowI've tried everything, but I'm not an expert Excel user by any means. If Iopen in Excel a cart number looks like this: 1.06391E+16 instead of10639064155219361. If I change the formatting on the cell, the closest I canget to the actual cart number is 10639064155219300. The first 15 charactersare correct, but it goes to zeros after that. So unless there's some sort ofsetting that can be done before I open the file, I don't know how this ispossible.This really would come in handy for me if anyone out there knows how I couldget around this issue.EddieOn 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 liketo 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.usBug Reporting: support@webdna.us Associated Messages, from the most recent to the oldest:

In Excel ...Select Colum, Format Cell, Set Number and Decimal Place 0.....we use it all the time to manage WebDNA DB, cart number and all withoutissue.Cheers TDn-----Original Message-----From: Eddie Z [mailto:eddie@thinksite.com] Sent: Wednesday, January 11, 2012 02:01To: talk@webdna.usSubject: Re: [BULK] Re: [WebDNA] Can WebDNA corrupt a db?Importance: LowI've tried everything, but I'm not an expert Excel user by any means. If Iopen in Excel a cart number looks like this: 1.06391E+16 instead of10639064155219361. If I change the formatting on the cell, the closest I canget to the actual cart number is 10639064155219300. The first 15 charactersare correct, but it goes to zeros after that. So unless there's some sort ofsetting that can be done before I open the file, I don't know how this ispossible.This really would come in handy for me if anyone out there knows how I couldget around this issue.EddieOn 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 liketo 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.usBug Reporting: support@webdna.us "Terry Nair"

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:

Speed questions (1998) Can't Update records (1997) Proper file locations (1997) Protecting webdelivery (1997) European dates (1998) Help name our technology! (1997) [WebDNA] TCPconnect and Bitcoin rate (2017) OT: Poll Please (2002) American Express test number (2000) presetting variables ... (2000) Search/sort in URL Was: GuestBook example (1997) Trouble with formula.db + more explanation (1997) Initiating NewCart (1997) RE: Price recalc based on quantity (1997) form crasehes server (1997) Not really WebCat (1997) I need Typhoon Pro Tonight! (1999) 2.0Beta Command Ref (can't find this instruction) (1997) auto-stripping of spaces (1997) charging? (2001)