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:

Help--WebCat setup (2000) shipcost (1997) restart needed???? (1997) grouped fields? (1999) triggering an update of two frames (1998) Handy Browser Counter Tip (1997) Download Question (1997) Serving images from databases (1998) Need correct syntax for writing to header2 (1999) Sort Order on a page search (1997) [WebDNA] anybody notice issues with convertchars FF3.5 mac (2009) denied access (1997) Nested tags count question (1997) [searchString] (1997) WCS Newbie question (1997) Not really WebCat- (1997) international time (1997) search/showif issues (2000) Fun with dates (1997) Using Applescript to process WebCatalog functions (1998)