[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 GreeneWebmasterClubMac, ClubPC, ClubPDA[search db=/clubmachome/IngramTestSite/DatabaseUpdate.db&eqstatusdatarq=A][append /clubmachome/IngramTestsite/IngramDatabase.db]Status=[Status]&Sku=[Sku]&IngramReplacementSku=[IngramReplacementSku]Manufacturer=[Manufacturer]&VendorName=[VendorName]&Text1=[Text1]&Description2=[Description2]&Price=[Price]&VendorPart=[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:
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 GreeneWebmasterClubMac, ClubPC, ClubPDA[search db=/clubmachome/IngramTestSite/DatabaseUpdate.db&eqstatusdatarq=A][append /clubmachome/IngramTestsite/IngramDatabase.db]Status=[Status]&Sku=[Sku]&IngramReplacementSku=[IngramReplacementSku]Manufacturer=[Manufacturer]&VendorName=[VendorName]&Text1=[Text1]&Description2=[Description2]&Price=[Price]&VendorPart=[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)