What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

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:

This list needs a digest: rant, rave... (1997) One Hour Email (2002) Multiple Hideif peramiters (2001) Some Advise needed (1997) Bad match! (2002) search vs lookup (1998) [format xs] freeze (1997) RE: Help name our technology! (1997) [Replace] (2000) Great product and great job ! (1997) [WebDNA] writing pdfs on the fly (Avery labels #5160) (2010) Anyone here care to chime in? (2005) [OT] Domain Name Scam (2000) ooops...WebCatalog [FoundItems] Problem - LONG - (1997) Emailer file formats (1998) SSL do I need it?? (1998) Email Set-Up? (1997) OBDC Support (1997) Carts & Refering URLs (1997) inconsistent webcat calculation? (1997)