Re: [carts] and databases

This WebDNA talk-list message is from

1997

It keeps the original formatting. numero = 11891
interpreted = N
texte = >>When we tried to delete these>>records both with the same name it hung webcat.>>This bothers me, because obviously there should be nothing that hangs>WebCatalog. Are you sure that it was just the fact that 2 records had the>same id? You're supposed to be able to delete hundreds of records at once>by creating a search criteria in the [delete] that blows away any matching>records, so I fully expect your situation to work correctly no matter how>many identical records were found.>>>So can I just make the field where the [cart] value will go and just fill>>each recored like 1,2,3,4,5,6 and so forth for these 225 some odd records>>and then any new records will get the [cart] value?>We didn't use a search on another field other then the sku number we putin. See the second snip where it talks about BOTH records on the screen atonce. I never expected this problem and the person doing the work neverbother to ask, Hey there are 2 records on the delete search function and Iwant to delete them before Gary finds out I screwed up.Record 1 sku=10-30 name=Jones addr=12345 Main st anywhere usaRecord 2 sku=10-30 name=Jones addr=12345 Main st anywhere usaperson put in I want to delete Jonesin the following snipthey got a search that they use to verify this is who they want to deleteand BOTH records appearedFound [numFound] items matching your search <--The numfound was 2>[foundItems]

[sku][firm][contact][addr1][addr2][phnum][em][hmpage][rtype]

Rep Code:
Firm Name:
Contact:
Address1:
Address2:
Phone:
Fax:	[faxnum]
E-Mail:
Home Page:
Type:

Click here if this is the Record you want to Deletethen they entered clicked on the hyperlinkand got[delete db=/webcatalog/rep.db&eqskudata=[sku]]and she hung-up.Now the sku in this example was a 4 digit number we created, but theycreated two identical records with the same sku value and the sku value hasnothing to do with [carts], it was put in by them. So I had 2 recordsnamed 01-30. But if I would have created this data base like I createdmost since then using the [cart] value to control the record the problem ismute. In my opinion it is not a problem of webcat. I is a problem here ofsome sloppy coding in the learning curve. I just want to avoid ithappening again. That is why I wanted to rework the database tomarrow andforce in somevalue into a field name uniqueID and just number the records 1to 225 and then let [cart] take over. Or have I confused everybody more?===============================================Gary Richter PanaVise Products, Inc. 7540 Colbert Dr. Reno, Nevada 89511 Ph: 702.850.2900 Fx: 702.850.2929 Email: grichter@panavise.com http://www.panavise.com=============================================== Associated Messages, from the most recent to the oldest:

Re: [carts] and databases (grichter@panavise.com (Gary Richter) 1997)
Re: [carts] and databases (Grant Hulbert 1997)
[carts] and databases (grichter@panavise.com (Gary Richter) 1997)

>>When we tried to delete these>>records both with the same name it hung webcat.>>This bothers me, because obviously there should be nothing that hangs>WebCatalog. Are you sure that it was just the fact that 2 records had the>same id? You're supposed to be able to delete hundreds of records at once>by creating a search criteria in the [delete] that blows away any matching>records, so I fully expect your situation to work correctly no matter how>many identical records were found.>>>So can I just make the field where the [cart] value will go and just fill>>each recored like 1,2,3,4,5,6 and so forth for these 225 some odd records>>and then any new records will get the [cart] value?>We didn't use a search on another field other then the sku number we putin. See the second snip where it talks about BOTH records on the screen atonce. I never expected this problem and the person doing the work neverbother to ask, Hey there are 2 records on the delete search function and Iwant to delete them before Gary finds out I screwed up.Record 1 sku=10-30 name=Jones addr=12345 Main st anywhere usaRecord 2 sku=10-30 name=Jones addr=12345 Main st anywhere usaperson put in I want to delete Jonesin the following snipthey got a search that they use to verify this is who they want to deleteand BOTH records appearedFound [numFound] items matching your search <--The numfound was 2>[founditems]

[sku][firm][contact][addr1][addr2][phnum][em][hmpage][rtype]

Rep Code:
Firm Name:
Contact:
Address1:
Address2:
Phone:
Fax:	[faxnum]
E-Mail:
Home Page:
Type:

DOWNLOAD WEBDNA NOW!

Re: [carts] and databases

1997

Top Articles:

Related Readings: