RE: [WebDNA] Reformatting database headers
This WebDNA talk-list message is from 2009
It keeps the original formatting.
numero = 102515
interpreted = N
texte = Here is what I came up with....and it works! [!]***Takes downloaded database and writes a separate header file while removing any spaces in header names[/!] [writefile sasjcmls_res.hdr][ListFields sasjcmls_res.db][grep search=[url] [/url]&replace=][FieldName][/grep] [/ListFields][/writefile] [!]***Waits for new header file to be created and then deletes old header row in database using old unique field name[/!] [WaitForFile file=sasjcmls_res.hdr] [delete db=sasjcmls_res.db&eqMLSNumberdata=MLS Number] [/WaitForFile] I still have headers with odd characters in them. Does anyone know if there are illegal characters we should not be using in our header names? Thanks for your help Donovan and Dan. Michael -----Original Message----- From: Donovan Brooke [mailto:dbrooke@webdna.us] Sent: Saturday, May 02, 2009 2:18 PM To: talk@webdna.us Subject: Re: [WebDNA] Reformatting database headers Michael A. DeLorenzo wrote: > My text editor does not allow me to find the ASCII table of a carriage > return. When I [URL] a return I get %1A but that did not work in the code > either. My text editor is saving the files in unix format if that helps. > > Michael %0D should work.. (that is %
D).. however, you may have to try with and without urling. However, I probably should have refrained from posting.. because I replied with answer that really isn't correct (out of not having enough time to really think about your issue).. sorry. I still don't have enough time.. however, my code that I posted, when the syntax is corrected, is still not going to work! :-/ This may be closer.. but again, I'm typing fast and this is untested: -- [writefile file=newdb.hdr][grep search=[url] [/url]&replace=|][middle startafter=&endbefore=[/unurl]%0D[/unurl]][include file=olddb.db&raw=T][/middle][/grep][/writefile] [writefile file=newdb.db][middle startafter=[/unurl]%0D[/unurl]&endbefore=][include file=olddb.db&raw=T][/middle][/writefile] [movefile from=olddb.db&to=archives/olddb.db.bu] -- The old code would, when working, would spit out just the header.. the later code, creates a .hdr file and matching .db file (when working). Hope that helps. Donovan -- Donovan Brooke WebDNA Software Corporation http://www.webdna.us **[Square Bracket Utopia]** --------------------------------------------------------- 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 old archives: http://dev.webdna.us/TalkListArchive/
Associated Messages, from the most recent to the oldest:
Here is what I came up with....and it works! [!]***Takes downloaded database and writes a separate header file while removing any spaces in header names[/!] [writefile sasjcmls_res.hdr][ListFields sasjcmls_res.db][grep search=[url] [/url]&replace=][FieldName][/grep] [/ListFields][/writefile] [!]***Waits for new header file to be created and then deletes old header row in database using old unique field name[/!] [WaitForFile file=sasjcmls_res.hdr] [delete db=sasjcmls_res.db&eqMLSNumberdata=MLS Number] [/WaitForFile] I still have headers with odd characters in them. Does anyone know if there are illegal characters we should not be using in our header names? Thanks for your help Donovan and Dan. Michael -----Original Message----- From: Donovan Brooke [mailto:dbrooke@webdna.us] Sent: Saturday, May 02, 2009 2:18 PM To: talk@webdna.us Subject: Re: [WebDNA] Reformatting database headers Michael A. DeLorenzo wrote: > My text editor does not allow me to find the ASCII table of a carriage > return. When I [url] a return I get %1A but that did not work in the code > either. My text editor is saving the files in unix format if that helps. > > Michael %0D should work.. (that is %D).. however, you may have to try with and without urling. However, I probably should have refrained from posting.. because I replied with answer that really isn't correct (out of not having enough time to really think about your issue).. sorry. I still don't have enough time.. however, my code that I posted, when the syntax is corrected, is still not going to work! :-/ This may be closer.. but again, I'm typing fast and this is untested: -- [writefile file=newdb.hdr][grep search=[url] [/url]&replace=|][middle startafter=&endbefore=[/unurl]%0D[/unurl]][include file=olddb.db&raw=T][/middle][/grep][/writefile] [writefile file=newdb.db][middle startafter=[/unurl]%0D[/unurl]&endbefore=][include file=olddb.db&raw=T][/middle][/writefile] [movefile from=olddb.db&to=archives/olddb.db.bu] -- The old code would, when working, would spit out just the header.. the later code, creates a .hdr file and matching .db file (when working). Hope that helps. Donovan -- Donovan Brooke WebDNA Software Corporation http://www.webdna.us **[Square Bracket Utopia]** --------------------------------------------------------- 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 old archives: http://dev.webdna.us/TalkListArchive/
"Michael A. DeLorenzo"
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:
EMailer - WebSTAR V - OSX - WebDNA (2003)
PCS Frames (1997)
[Sum] function? (1997)
Bit off subject -- Faxing orders (1997)
stumped on simple sort (1999)
Help formatting search results w/ table (1997)
[searchString] (1997)
is [math] busted somehow in 3.05b10? (1999)
WebCat2 - Getting to the browser's username/password data (1997)
[ModDate] & [ModTime] ? (1997)
Summing fields (1997)
WebCatalog Technical Reference (1997)
WebCat2b12 CGI Mac - [shownext] problem (1997)
Type 2 errors with WebCatalog.acgi (1997)
RE: [WebDNA] Yet another call for hosts... NJ WebDNA Host (2009)
[WebDNA] IIS 7.5 (2015)
Trouble with Category search (2000)
WebCatalog [FoundItems] Problem - AGAIN - (1997)
Signal Raised (1997)
problems with 2 tags (1997)