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:

Updating one table with another (1998) Help formatting search results w/ table (1997) [INCLUDE] Limitations (1998) Sorting error (1997) [WebDNA] WebDNA not parsing php files (2012) Adding To items to cart at once (1999) 2.01 upgrade problems (1997) New reserved words for [tags] (2000) Bug Report, maybe (1997) New Website with Redakto CMS (2003) shell question (2004) ODBC problems between webcat and filemaker pro (2001) [WebDNA] TCPConnect w/ user:pass (2009) select multiple (1997) WebDNA 5 gets a mention .. (2003) WC2b15 File Corruption (1997) Is everybody getting all the posts? (2002) Need help... (1997) Limiting user access to .tmpl files (1997) syntax question, not in online refernce (1997)