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:

    
  1. Re: need to add a sku field to an existing db ( Dale Lists 2005)
  2. Re: need to add a sku field to an existing db ( devaulw@onebox.com 2005)
  3. Re: need to add a sku field to an existing db ( Dale Lists 2005)
  4. Re: need to add a sku field to an existing db ( Brian Wachter 2005)
  5. 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!

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 (1997) Show shoppingcart after remove last item (1997) IE Cache Problems... (1999) Updating emailer (server) (2000) [sendmail] questions... (1997) webcat pro (1998) Question... (2002) [format] (1998) [format 40s]text[/format] doesn't work (1997) [WebDNA] Cron vs. trigger syntax (2014) Ampersand (1997) [WebDNA] convert time stamp back (2010) Re2: AAgghh!! Help, please. SSL strikes again. (1997) [Sum] function? (1997) [showif] not working (2003) RE: Explorer oddities (1997) Redirect frame targets (1998) Different Email recipients? (1998) Database files & W2000 (2001) shownext problems (1998)