Re: Not reading blanks

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 18106
interpreted = N
texte = I'll bet one of your video release date fields is blank (the search string looks OK). In your found items loop, try adding the [type] tag after the [releasedate] tag to see what the value is for the blank date field.John.>Can someone help me out with this? > >The database has a field named TYPE. The field contains either the word >video or CD. >If it is a video then the releasedate field has a date. If it is a CD then >the releasedate field is blank. > >I am trying to list the release dates grouped by date. It works fine but I >get a blank as if it sees the blank fiels for CD. I want to get rid of the >blank. > >[search >geSKUdata=0&db=catalog.txt&eqtypedatarq=Video&eqreleasedatesumm=t&leasedates >ort=t&max=8] >[foundItems] >
  • mmand=search&db=catalog.txt&max=8&eqreleasedatedatarq=[url][releasedate][/ur >l]&cart=[cart]&searchTitle=[url][releasedate][/url]>Released Week Of: >[releasedate] >[/foundItems] >[/search] > >This is the results I get > >Released Week Of: 05/26/98 >Released Week Of: 06/04/98 >Released Week Of: 06/01/98 >Released Week Of: John A. Hill, V.P. Marketing Pacific Coast Software eCommerce / Web Developer Tools http://www.smithmicro.com Associated Messages, from the most recent to the oldest:

        
    1. Re: Not reading blanks (John Hill 1998)
    2. Disregard Not reading blanks (greg 1998)
    3. Not reading blanks (greg 1998)
    I'll bet one of your video release date fields is blank (the search string looks OK). In your found items loop, try adding the [type] tag after the [releasedate] tag to see what the value is for the blank date field.John.>Can someone help me out with this? > >The database has a field named TYPE. The field contains either the word >video or CD. >If it is a video then the releasedate field has a date. If it is a CD then >the releasedate field is blank. > >I am trying to list the release dates grouped by date. It works fine but I >get a blank as if it sees the blank fiels for CD. I want to get rid of the >blank. > >[search >geSKUdata=0&db=catalog.txt&eqtypedatarq=Video&eqreleasedatesumm=t&leasedates >ort=t&max=8] >[founditems] >
  • [username]&password=[password]&co >mmand=search&db=catalog.txt&max=8&eqreleasedatedatarq=[url][releasedate][/ur >l]&cart=[cart]&searchTitle=[url][releasedate][/url]>Released Week Of: >[releasedate] >[/foundItems] >[/search] > >This is the results I get > >Released Week Of: 05/26/98 >Released Week Of: 06/04/98 >Released Week Of: 06/01/98 >Released Week Of: John A. Hill, V.P. Marketing Pacific Coast Software eCommerce / Web Developer Tools http://www.smithmicro.com John Hill

    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:

    Bannerad Demo (1998) [WebDNA] Server version 8.6 ? (2018) customizing the color of user's pages (1997) New Command prefs ... (1997) Hideif on IP range (2004) more trouble with [showif] in [search] = busted [shownext] (2000) [WebDNA] Limited Time Discount on WebDNA Server licenses (2013) WebCat2b15MacPlugin - [protect] (1997) FORMS: Returning a specific page (1997) Stopping bad HTML propagation ? (1997) Summary search -- speed (1997) [format 40s]text[/format] doesn't work (1997) Gems (2006) [ot] Raid Cards for RH ES (2004) WebCatalog2 Feature Feedback (1996) RE: protect tag on NT (1997) convertchars and case? (1998) newbie Q: [cart] documentation (1999) Dynamically Generated Pages & WC? (2000) OFF-TOPIC: Check www.godaddy.com for me ... (2003)