CORRECTION... Re: Exporting a blank record

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 26654
interpreted = N
texte = First you want a variable which contains the value of the previous tech ID. I set it to empty initially.Then everytime through the founditems loop -- except the first time -- see id the current techid is equal to the previous techid. If not, append a blank record.Then append the real record and set the prevtechid to the current one and loop.You may need one final append of a blank record after the founditems loop... I don't know. The reason you skip the first time around is that there is no previous to compare the first time.Make sense?At 5:21 PM 1/27/00, Michael Rosen wrote: >> I'm trying to think...but nothing happens! >> >> I have to export records to a text file for import into MYOB. >> >> [!] Find All marked records [/!][text]prevtechid=[/text]>> [search db=^slips.db&eqPurchaseddata=M&TechIDsort=1] >> [!] Write out text entry [/!][showif [index]>1] [showif [prevtechid]![techid]] [Appendfile secure=F&file=Purch.txt][founditems][blank][blank]..etc [/showif] [/showif][text]prevtechid=[techid] >> [Appendfile secure=F&file=Purch.txt][founditems][field1][field2]..etc >> [/founditems] >> [/Appendfile] >> [/search] >> >> This works fine except I have to append a blank line (record) every >> time the TechID changes. Does anyone know how to do that? >> >> Michael Rosen >> Linq Designs >> miker@linqdesigns.com >> Michael A Rosen >> miker@linqdesigns.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 >> _________________________________________________ Joseph D'Andrea JoeDan@West21.com WEST21.com Internet services for the 21st Century http://www.west21.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:

    
First you want a variable which contains the value of the previous tech ID. I set it to empty initially.Then everytime through the founditems loop -- except the first time -- see id the current techid is equal to the previous techid. If not, append a blank record.Then append the real record and set the prevtechid to the current one and loop.You may need one final append of a blank record after the founditems loop... I don't know. The reason you skip the first time around is that there is no previous to compare the first time.Make sense?At 5:21 PM 1/27/00, Michael Rosen wrote: >> I'm trying to think...but nothing happens! >> >> I have to export records to a text file for import into MYOB. >> >> [!] Find All marked records [/!][text]prevtechid=[/text]>> [search db=^slips.db&eqPurchaseddata=M&TechIDsort=1] >> [!] Write out text entry [/!][showif [index]>1] [showif [prevtechid]![techid]] [Appendfile secure=F&file=Purch.txt][founditems][blank][blank]..etc [/showif] [/showif][text]prevtechid=[techid] >> [Appendfile secure=F&file=Purch.txt][founditems][field1][field2]..etc >> [/founditems] >> [/Appendfile] >> [/search] >> >> This works fine except I have to append a blank line (record) every >> time the TechID changes. Does anyone know how to do that? >> >> Michael Rosen >> Linq Designs >> miker@linqdesigns.com >> Michael A Rosen >> miker@linqdesigns.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 >> _________________________________________________ Joseph D'Andrea JoeDan@West21.com WEST21.com Internet services for the 21st Century http://www.west21.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 Joseph D'Andrea

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:

docs for WebCatalog2 (1997) test (2006) Searching a field and returning the highest value (1997) Tea Room trouble (1997) Formulas.db not working (2006) Searching Groups for multiple matches (1998) NetSplat and WebCat2 (1997) Searching multiple Databases (1997) Trouble with formula.db + more explanation (1997) [Shell]ps -A[/Shell] Linux Webcat Q (2000) Bug Report, maybe (1997) Graphing Modules (2004) Emailer (1997) A multi-processor savvy WebCatalog? (1997) WebDNA monitor not working (2002) emailer (1997) [WebDNA] Sendmail on a one page website..... (2013) Remove me from your list immeadiately (1999) [WebDNA] rules for naming [math] and [text] vars (2008) E-Mailer (WebCatb15acgiMac) (1997)