Re: need to add a sku field to an existing db

This WebDNA talk-list message is from

2005

It keeps the original formatting. numero = 63698
interpreted = N
texte = Hi Bill,devaulw@onebox.com wrote:>I think what you are doing will put the same cart value in for every record.> >With the max=1 it only found 1 record and gave me a unique value for each field.>What I did was make a new database with the same field names plus SKU. Then findall in the original database, and then append with autonumber to the new database. Then I did an exclusive lock and closed both databases while I switched the old database to an archive folder and renamed the new database to the old one's name. > >That sounds like a valid way of doing it as well. In this case, the database is only being used by a few people at the moment so this would work as well.>Inelegant, sure. But it worked.> >working is the key :)>Bill> >Thanks for the suggestion!Dale>-----Original Message----->From: Brian Wachter >Sent: Tue, 27 Dec 2005 23:13:06 -0500>To: "WebDNA Talk" >Subject: Re: need to add a sku field to an existing db>>Looks like you have an extra right-side parenthesis [blank]]>Also, verify that your db file has the field name "sku" in it.>>>On 12/27/05 11:02 PM, "Dale Lists" wrote:>> >>>WebDNA v6.0a on Linux>>>>Hello,>>>>Trying add a unique number field (aka sku) to an existing database. I>>can't seem to get replace to work by searching for a blank field with>>max=1 and replace the sku field with a [cart] value.>>>>Any suggestions?>>>>What I tried is:>>>>[Replace >>db=/databases/bookmarks.db&eqskudata=[blank]]&max=1]sku=[cart][/Replace]>>>> >>-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

Re: need to add a sku field to an existing db ( Dale Lists 2005)
Re: need to add a sku field to an existing db ( devaulw@onebox.com 2005)
Re: need to add a sku field to an existing db ( Dale Lists 2005)
Re: need to add a sku field to an existing db ( Brian Wachter 2005)
need to add a sku field to an existing db ( Dale Lists 2005)

Hi Bill,devaulw@onebox.com wrote:>I think what you are doing will put the same cart value in for every record.> >With the max=1 it only found 1 record and gave me a unique value for each field.>What I did was make a new database with the same field names plus SKU. Then findall in the original database, and then append with autonumber to the new database. Then I did an exclusive lock and closed both databases while I switched the old database to an archive folder and renamed the new database to the old one's name. > >That sounds like a valid way of doing it as well. In this case, the database is only being used by a few people at the moment so this would work as well.>Inelegant, sure. But it worked.> >working is the key :)>Bill> >Thanks for the suggestion!Dale>-----Original Message----->From: Brian Wachter >Sent: Tue, 27 Dec 2005 23:13:06 -0500>To: "WebDNA Talk" >Subject: Re: need to add a sku field to an existing db>>Looks like you have an extra right-side parenthesis [blank]]>Also, verify that your db file has the field name "sku" in it.>>>On 12/27/05 11:02 PM, "Dale Lists" wrote:>> >>>WebDNA v6.0a on Linux>>>>Hello,>>>>Trying add a unique number field (aka sku) to an existing database. I>>can't seem to get replace to work by searching for a blank field with>>max=1 and replace the sku field with a [cart] value.>>>>Any suggestions?>>>>What I tried is:>>>>[Replace >>db=/databases/bookmarks.db&eqskudata=[blank]]&max=1]sku=[cart][/Replace]>>>> >>-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Dale Lists

DOWNLOAD WEBDNA NOW!

Re: need to add a sku field to an existing db

2005

Top Articles:

Related Readings: