Re: [append] problem

This WebDNA talk-list message is from

1997

It keeps the original formatting. numero = 11778
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.If it works fine with manually-entered numbers and not the numbers WebCatis putting into the [sku] tag, then WebCat's not getting the right [sku].This means your code is right except for the [sku] part ...If you're only going to do this once and not all the time, why don't youjust duplicate both databases and copy the data from the small one andpaste it into the big one, then take your site off line for just longenough to replace the current database with the newly-merged one?Of course, if this is something you have to do all the time, then you'llhave to diagnose the problem in your WebDNA ...>[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]This is not all of your WebDNA code from that page, is it?Where's the [founditems] context?Yyou have to put the append context inside a [founditems] context or WebCatwon't know what you mean by [sku].Also, where's the [/search] tag?I 'assume' there's a [/search] tag somewhere on down the page that youforgot to include in this example ... :)Sincerely, Ken Grome ..... ken@iav.comhttp://usarea.net/home.html Associated Messages, from the most recent to the oldest:

Re: [append] problems v2 ( "Scott Anderson" 2003)
[append] problems v2 ( Tim Robinson 2003)
Re: [append] problems ( Tim Robinson 2003)
Re: [append] problems ( "Scott Anderson" 2003)
Re: [append] problems ( Tim Robinson 2003)
Re: [append] problems ( Tim Robinson 2003)
Re: [append] problems ( Alain Russell 2003)
Re: [append] problems ( Tim Robinson 2003)
Re: [append] problems ( Alain Russell 2003)
[append] problems ( Tim Robinson 2003)
Re: [append] problem (Kenneth Grome 1997)
[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.If it works fine with manually-entered numbers and not the numbers WebCatis putting into the [sku] tag, then WebCat's not getting the right [sku].This means your code is right except for the [sku] part ...If you're only going to do this once and not all the time, why don't youjust duplicate both databases and copy the data from the small one andpaste it into the big one, then take your site off line for just longenough to replace the current database with the newly-merged one?Of course, if this is something you have to do all the time, then you'llhave to diagnose the problem in your WebDNA ...>[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]This is not all of your WebDNA code from that page, is it?Where's the [founditems] context?Yyou have to put the append context inside a [founditems] context or WebCatwon't know what you mean by [sku].Also, where's the [/search] tag?I 'assume' there's a [/search] tag somewhere on down the page that youforgot to include in this example ... :)Sincerely, Ken Grome ..... ken@iav.comhttp://usarea.net/home.html Kenneth Grome

DOWNLOAD WEBDNA NOW!

Re: [append] problem

1997

Top Articles:

Related Readings: