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:

Are you an WC expert? (1997) multiple search commands (1997) unable to launch acgi in WebCat (1997) [WebDNA] Extracting contents of a div (2012) How fast is your server? (2002) Extended [ConvertChars] (1997) WCS Newbie question (1997) Re:multiple digests, please stop (1997) problems with 2 tags shakur (1997) two forms of delivery (1998) How to get shownext to just shownext once (1997) Exclamation point (1997) Safari browser and WebDNA set-cookies (2003) WebCatalog 2.0 & WebDNA docs in HTML ... (1997) WebCat2 as a chat server? (1997) FEW QUESTIONS (1997) Setting up shop (1997) Extra Text Fields (was Another question) (1997) WebCat2 several catalogs? (1997) Is there an easier way? (1998)