[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:

Help name our technology! (1997) SQL db type (2006) [WebDNA] Script choking on POP download (2010) WebDNA CAPTCHA (2008) Grep and Special Characters (2002) Internal server error (2004) [WebDNA] Crashing Database (2011) find with exceptions (1997) $Replace with [founditems] (1997) WebDNA Book? (2003) WebCatalog for guestbook ? (1997) SV: Mass Mail (2000) More on the email templates (1997) Emailer.Out (1998) WC2f3 (1997) problems with 2 tags (1997) [WebDNA] User sessions - cookies only or cookies and a sessions.db? (2016) PCS Frames (1997) Encrypting the seed (2001) WebCatalog Technical Reference (1997)