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:

Include Files (1998) European Convention (2004) PC Auth Hub+Merchant (1998) Order not created error (1997) Writefile problem (1999) HELP WITH DATES (1997) Stumpted Again (1997) Return records from another (1997) Netscape 3.01 can't see db in form (1997) Nested tags count question (1997) Math variable size-dumb question (1999) updating with ProductEditor (1998) Share cost of training videos! (1998) Custom WebCat Prefs ... (1997) Online reference (1997) strange math (2004) RE: [WebDNA] Basic Search (2008) [append] (1997) WebCatalog can't find database (1997) filemaker - orderfile (1997)