Re: question... no field names?
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 42828
interpreted = N
texte = Yes, you're right - it's a while since I've done it. (Don't forget the return at the end though). -- Tim Robinson IDFK Web Developments tim@idfk.com.au 114a/40 Yeo Street Neutral Bay 2089 Australia Phone +612 9908 2134 Fax +612 9908 4837> From: Gary Krockover
> Reply-To: (WebCatalog Talk) > Date: Wed, 21 Aug 2002 22:37:51 > To: (WebCatalog Talk) > Subject: Re: question... no field names? > > I've posted this before, but I found that when you import a db into Excel, > do your work, then just highlight the entire sheet, copy and paste it back > into your text editor (BBEdit for example). This will bypass the M$ > smartquotes crap and any formatting that Excel would want to put into it. > It also retains your tabs of course as well. > > GK > > > >> It doesn't work like Excel. If you want it to work like Excel, you'll have >> to import the whole thing into Excel, delete the column, then export as >> tab-delimited text, make sure there's a carriage return at the end, upload >> it to the same place (saved as the same db name), and Flush databases. But >> there's plenty of things that can go wrong with this.... >> -- >> Tim Robinson >> IDFK Web Developments >> tim@idfk.com.au >> 114a/40 Yeo Street >> Neutral Bay 2089 >> Australia >> Phone +612 9908 2134 >> Fax +612 9908 4837 >> >>> From: Kenneth Grome >>> Reply-To: (WebCatalog Talk) >>> Date: Thu, 22 Aug 2002 11:23:54 >>> To: (WebCatalog Talk) >>> Subject: Re: question... no field names? >>> >>>> If you >>>> delete a column from the .hdr file, the column in the table is deleted >>>> (please verify this!!!!!). >>> >>> No, the column is not deleted in the .db file when you delete a field >>> name (and the tab character next to it) from the .hdr file. Instead, >>> you'll just end up having some of your field names in the wrong >>> columns. >>> >>> The rule to remember when messing with .hdr files is that you can add >>> a tab then a new field name to the end of the list of field names in >>> the .hdr file, but you cannot remove any field names (and associated >>> tab characters) and expect that the corresponding field data will be >>> removed from the .db file -- because it will not be removed. >>> >>> In other words, never delete a field name from a .hdr file unless you >>> *also* delete that field manually from every record in the .db file. >>> That's the rule I use to insure that I do not screw up my db formats >>> .... >>> >>> >>> Sincerely, >>> Kenneth Grome >>> >>> --------------------------------------------------- >>> WebDNA Professional Training and Development Center >>> 175 J. Llorente Street +63 (32) 255-6921 >>> Cebu City, Cebu 6000 kengrome@webdna.net >>> Philippines http://www.webdna.net >>> --------------------------------------------------- >>> >>> ------------------------------------------------------------- >>> 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 >>> >>> Web Archive of this list is at: http://search.smithmicro.com/ >>> >> >> >> >> ------------------------------------------------------------- >> 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 > >> Web Archive of this list is at: http://search.smithmicro.com/ > > > ------------------------------------------------------------- > 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 > > Web Archive of this list is at: http://search.smithmicro.com/ > ------------------------------------------------------------- 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 Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Yes, you're right - it's a while since I've done it. (Don't forget the return at the end though). -- Tim Robinson IDFK Web Developments tim@idfk.com.au 114a/40 Yeo Street Neutral Bay 2089 Australia Phone +612 9908 2134 Fax +612 9908 4837> From: Gary Krockover > Reply-To: (WebCatalog Talk) > Date: Wed, 21 Aug 2002 22:37:51 > To: (WebCatalog Talk) > Subject: Re: question... no field names? > > I've posted this before, but I found that when you import a db into Excel, > do your work, then just highlight the entire sheet, copy and paste it back > into your text editor (BBEdit for example). This will bypass the M$ > smartquotes crap and any formatting that Excel would want to put into it. > It also retains your tabs of course as well. > > GK > > > >> It doesn't work like Excel. If you want it to work like Excel, you'll have >> to import the whole thing into Excel, delete the column, then export as >> tab-delimited text, make sure there's a carriage return at the end, upload >> it to the same place (saved as the same db name), and Flush databases. But >> there's plenty of things that can go wrong with this.... >> -- >> Tim Robinson >> IDFK Web Developments >> tim@idfk.com.au >> 114a/40 Yeo Street >> Neutral Bay 2089 >> Australia >> Phone +612 9908 2134 >> Fax +612 9908 4837 >> >>> From: Kenneth Grome >>> Reply-To: (WebCatalog Talk) >>> Date: Thu, 22 Aug 2002 11:23:54 >>> To: (WebCatalog Talk) >>> Subject: Re: question... no field names? >>> >>>> If you >>>> delete a column from the .hdr file, the column in the table is deleted >>>> (please verify this!!!!!). >>> >>> No, the column is not deleted in the .db file when you delete a field >>> name (and the tab character next to it) from the .hdr file. Instead, >>> you'll just end up having some of your field names in the wrong >>> columns. >>> >>> The rule to remember when messing with .hdr files is that you can add >>> a tab then a new field name to the end of the list of field names in >>> the .hdr file, but you cannot remove any field names (and associated >>> tab characters) and expect that the corresponding field data will be >>> removed from the .db file -- because it will not be removed. >>> >>> In other words, never delete a field name from a .hdr file unless you >>> *also* delete that field manually from every record in the .db file. >>> That's the rule I use to insure that I do not screw up my db formats >>> .... >>> >>> >>> Sincerely, >>> Kenneth Grome >>> >>> --------------------------------------------------- >>> WebDNA Professional Training and Development Center >>> 175 J. Llorente Street +63 (32) 255-6921 >>> Cebu City, Cebu 6000 kengrome@webdna.net >>> Philippines http://www.webdna.net >>> --------------------------------------------------- >>> >>> ------------------------------------------------------------- >>> 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 >>> >>> Web Archive of this list is at: http://search.smithmicro.com/ >>> >> >> >> >> ------------------------------------------------------------- >> 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 > >> Web Archive of this list is at: http://search.smithmicro.com/ > > > ------------------------------------------------------------- > 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 > > Web Archive of this list is at: http://search.smithmicro.com/ > ------------------------------------------------------------- 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 Web Archive of this list is at: http://search.smithmicro.com/
Tim Robinson
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:
Not really WebCat- (1997)
using showpage and showcart commands (1996)
WebCat2b15MacPlugin - showing [math] (1997)
[WebDNA] [redirect] include a value to pass along? (2010)
RE: AccountAuthorizer doesn't seem to work (1997)
object tag examples (2004)
WebCatalog for Dummies part 2 (2000)
Extended [ConvertChars] (1997)
Only charge card when product shipped ? (1997)
Revisit: speed test (2002)
WebCat2 beta 11 - new prefs ... (1997)
[taxRate] [TaxTotal] ? (1997)
Smith Micro SUPPORT? (2000)
Country & Ship-to address & other fields ? (1997)
[WebDNA] jQuery validation and webdna (2015)
check out page (SSL) not loading on Netscape 4.0+ - fixed? (1999)
WebCat2b13MacPlugIn - More limits on [include] (1997)
Fun with Dates - revisited (1997)
WebDNA monitor not working (2002)
Authenticate Questions (2003)