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