[append] problem

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 11773
interpreted = N
texte = Hello everyone.I am having an unusual problem and I'm hoping somebody has an answer to this.I am trying to merge an update database into the main database. I have the following code of an add page and it doesn't work. I also have a replace page and a delete page and none of them work. BTW, the records in the update database have A for Add, C for Replace and D for delete.Both databases have identical field names and both were exported from Filemaker pro as Merge format.However, if I get rid of the [append] and simply do a search it works fine. If I enter the information by hand (for example sku=32342 instead of sku= [sku]) it works fine also.The update file has 2000 records with 21 fields. The main database has 16,000 x 21. Does anybody know whats going on??I appreciate it.Lee Greene Webmaster ClubMac, ClubPC, ClubPDA[search db=/clubmachome/IngramTestSite/DatabaseUpdate.db&eqstatusdatarq=A][append /clubmachome/IngramTestsite/IngramDatabase.db]Status=[Status]&Sku=[Sku]& IngramReplacementSku=[IngramReplacementSku]Manufacturer=[Manufacturer]&VendorN ame=[VendorName]&Text1=[Text1]&Description2=[Description2]&Price=[Price]&Vendo rPart=[VendorPart]&Weight=[Weight]&CustomerPartNumber= [CustomerPartNumber]&UPCCode=[UPCCode]&Length=[Length]&Width=[Width]&Height= [Height]&PriceChangeFlag=[PriceChangeFlag]&CustomerPrice=[CustomerPrice]& SpecialPriceFlag=[SpecialPriceFlag]&AvailabilityFlag=[AvailabilityFlag]& AuthorizedToBuyFlag=[AuthorizedToBuyFlag]&AllianceFlag=[AllianceFlag]&Buyer= [Buyer]&MediaType=[MediaType]&Category=[Category]&NewItemReceiptFlag= [NewItemReceiptFlag]&InstantRebateFlag=[InstantRebateFlag][/append] Associated Messages, from the most recent to the oldest:

    
  1. Re: [append] problems v2 ( "Scott Anderson" 2003)
  2. [append] problems v2 ( Tim Robinson 2003)
  3. Re: [append] problems ( Tim Robinson 2003)
  4. Re: [append] problems ( "Scott Anderson" 2003)
  5. Re: [append] problems ( Tim Robinson 2003)
  6. Re: [append] problems ( Tim Robinson 2003)
  7. Re: [append] problems ( Alain Russell 2003)
  8. Re: [append] problems ( Tim Robinson 2003)
  9. Re: [append] problems ( Alain Russell 2003)
  10. [append] problems ( Tim Robinson 2003)
  11. Re: [append] problem (Kenneth Grome 1997)
  12. [append] problem (Lee Greene 1997)
Hello everyone.I am having an unusual problem and I'm hoping somebody has an answer to this.I am trying to merge an update database into the main database. I have the following code of an add page and it doesn't work. I also have a replace page and a delete page and none of them work. BTW, the records in the update database have A for Add, C for Replace and D for delete.Both databases have identical field names and both were exported from Filemaker pro as Merge format.However, if I get rid of the [append] and simply do a search it works fine. If I enter the information by hand (for example sku=32342 instead of sku= [sku]) it works fine also.The update file has 2000 records with 21 fields. The main database has 16,000 x 21. Does anybody know whats going on??I appreciate it.Lee Greene Webmaster ClubMac, ClubPC, ClubPDA[search db=/clubmachome/IngramTestSite/DatabaseUpdate.db&eqstatusdatarq=A][append /clubmachome/IngramTestsite/IngramDatabase.db]Status=[Status]&Sku=[Sku]& IngramReplacementSku=[IngramReplacementSku]Manufacturer=[Manufacturer]&VendorN ame=[VendorName]&Text1=[Text1]&Description2=[Description2]&Price=[Price]&Vendo rPart=[VendorPart]&Weight=[Weight]&CustomerPartNumber= [CustomerPartNumber]&UPCCode=[UPCCode]&Length=[Length]&Width=[Width]&Height= [Height]&PriceChangeFlag=[PriceChangeFlag]&CustomerPrice=[CustomerPrice]& SpecialPriceFlag=[SpecialPriceFlag]&AvailabilityFlag=[AvailabilityFlag]& AuthorizedToBuyFlag=[AuthorizedToBuyFlag]&AllianceFlag=[AllianceFlag]&Buyer= [Buyer]&MediaType=[MediaType]&Category=[Category]&NewItemReceiptFlag= [NewItemReceiptFlag]&InstantRebateFlag=[InstantRebateFlag][/append] Lee Greene

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:

Using [Include] Context (1999) All choices on IE different than Netscape (1997) [WebDNA] Clarifying talklist emails (2020) Using [redirect] in the middle of a page? (1999) Banners and sort of random display (1997) Duplicates (1998) Colors in cart (2002) syntax question, not in online refernce (1997) WebCat2b12 forgets serial # (1997) Re[2]: What am I doing wrong? (2000) Banners (1997) Help! (1996) RE: CloseDatabase (1997) [Sum] function? (1997) [append] vs. [appendfile] delta + question? (1997) listfiles shows invisible files ... (1999) [WebDNA] PayPal Express Checkout (2009) Quick ShowIf question (1997) & Aftermath (2000) Updating emailer (server) (2000)