Re: Database Posting

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 34926
interpreted = N
texte = 1. Always strip out all of the HTML specific noise when posting to the list, please.2. Don't use [URL] where you expect to have a number (actually, why are you using startat at all?). Also, always use [url] on both sides of a test, not just one, even if it is a search parameter.3. Read the documentation about Sorting (it's under Searching). You must have all elements of the sort correct before it will do anything. Hint: always test all fields that are being sorted, even if it is a trivial test (neFIELDdata=[BLANK]).John PeacockMac Sherwood wrote: > > I have a database that I want to use to post products to page, can someone > help me with this... > > The fields within the database are: > catnum sku catname Author Product Name Size Color Price > Parent Key Words Description > > The code is: > > > > > > > > > > > [search > db=homefurn.db&eqCategorydata=[url][Category][/url]&asTitlesort=1&asSKUsort= > 2&max=5&startat=[url][startat][/url]] > > [foundItems] > > > > > > > > [/foundItems] > >
Catalog #TitlePrice size=2>Actions
size=2>[sku][Product > Name] size=2>[Price] size=2> HREF=ShoppingCart.tpl?command=add&cart=[cart]&db=TeaRoom.db&sku=[url][sku][ > /url]>Add to Cart size=2> HREF=Detail.tpl?cart=[cart]&sku=[url][sku][/url]>Detail
> > Thanks all!! > > mark > > ------------------------------------------------------------- > 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://search.smithmicro.com/------------------------------------------------------------- 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://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Database Posting (Kenneth Grome 2000)
  2. Re: Database Posting (Glenn Busbin 2000)
  3. Re: Database Posting (John Peacock 2000)
  4. Database Posting (Mac Sherwood 2000)
1. Always strip out all of the HTML specific noise when posting to the list, please.2. Don't use [url] where you expect to have a number (actually, why are you using startat at all?). Also, always use [url] on both sides of a test, not just one, even if it is a search parameter.3. Read the documentation about Sorting (it's under Searching). You must have all elements of the sort correct before it will do anything. Hint: always test all fields that are being sorted, even if it is a trivial test (neFIELDdata=[BLANK]).John PeacockMac Sherwood wrote: > > I have a database that I want to use to post products to page, can someone > help me with this... > > The fields within the database are: > catnum sku catname Author Product Name Size Color Price > Parent Key Words Description > > The code is: > > > > > > > > > > > [search > db=homefurn.db&eqCategorydata=[url][Category][/url]&asTitlesort=1&asSKUsort= > 2&max=5&startat=[url][startat][/url]] > > [founditems] > > > > > > > > [/foundItems] > >
Catalog #TitlePrice size=2>Actions
size=2>[sku][Product > Name] size=2>[Price] size=2> HREF=ShoppingCart.tpl?command=add&cart=[cart]&db=TeaRoom.db&sku=[url][sku][ > /url]>Add to Cart size=2> HREF=Detail.tpl?cart=[cart]&sku=[url][sku][/url]>Detail
> > Thanks all!! > > mark > > ------------------------------------------------------------- > 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://search.smithmicro.com/------------------------------------------------------------- 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://search.smithmicro.com/ John Peacock

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:

[WebDNA] [OT] - One Man. One Road. (2010) [searchString] (1997) Need relative path explanation (1997) sendmail and accented characters (1998) WebCat2b12 CGI Mac - [shownext] problem (1997) PSC recommends what date format yr 2000??? (1997) Searching multiple records for certain info (2000) Sort Order on a page search (1997) emailer 150 (1997) getting images' width/height (1998) Math, Multiple Equasions and Show/Hide (1998) emailer (1997) WC2.0 Memory Requirements (1997) creating a 60 fields database (1997) Setting up shop (1997) How do I get Google to crawl a WebCat site? (2003) [dos] command question (1997) Emailer help....! (1997) OT: zipcodes (2002) Search for dates greater than [date] (1997)