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:
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!
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:
Emailer setup (1997)
SSL and reg web* (1997)
Delete context run amok (2005)
can WC render sites out? (1997)
Overiding the sku (2001)
Rollovers (1999)
Re:2nd WebCatalog2 Feature Request (1996)
WebCat2b15MacPlugin - showing [math] (1997)
TeaRoom Search page (2000)
Re[2]: 2nd WebCatalog2 Feature Request (1996)
Re2: Calculating multiple shipping... (1997)
WC2b15 File Corruption (1997)
[Off] Netscape Display Problem (1998)
Help w/Multi User Admins (1997)
New WebDNA Solutions ... (1997)
[ShowIf] a either fields are blank (1998)
[WebDNA] apache 2.4 (2014)
WebCat for mass emailings (1997)
WebCatalog vs. Cold Fusion (1998)
PCS Frames (1997)