[WebDNA] Re: Digest from talk@webdna.us

This WebDNA talk-list message is from

2009

It keeps the original formatting. numero = 102056
interpreted = N
texte = --Apple-Mail-5--867436744Content-Type: text/plain;charset=US-ASCII;format=flowed;delsp=yesContent-Transfer-Encoding: 7bitTHANK YOU, TERRY!!!I only subscribe to digest mode (how do I switch to feed mode, by the way?), so I just saw your answer. It works perfectly now! Knew it had to be something stupid. I mean, not that you'd have to be stupid to figure it out -- that would be insulting the guy who helped me. Aww, crap. You know what I meant. :-)Gary, thank you, too for your simple solution. If Terry's hadn't worked, you were in the pipeline. Good, brief code.-----Patrick JunkroskiFrom: Terry Wilson Date: February 19, 2009 1:38:12 PM ESTTo: Subject: Re: [WebDNA] Math Date issueReply-To: should be this:&group1type=date&group2type=dateTerry>> Hi ->> I'm using WebDNA Commerce Edition 6.0 on a G5 Xserve under 10.3.9.>> I have code that is supposed to search a database and show any > advertiser's status (called linkexpires, in this example) falls > between today's date and a week from now. It generally seems to > work, but every once in a while I have an issue like this one.>> Here's my code (minus some HTML to make it cleaner):>> The following companies have LINKS whose status will expire between > [date] and [math date]{[date]}+{00/07/0000}[/math]>> [search > db > = > TheSeniorGuide > .db > &linkexpirestype > = > date > &group1field > = > linkexpires > &group2field > = > linkexpires > &group1fieldtype=date&group2fieldtype=date&legroup1datarq=[math date] > {[date]}+{00/07/0000}[/ > math]&gegroup2datarq=[date]&ascompanynamesort=1]> > > [founditems][hideif [linkexpires]=]> > [/hideif][/founditems]> [/search]>>> Here's the output:>> The following companies have LINKS whose status will expire between > 02/19/2009 and 02/26/2009> CompanyAddressCityStateZipExpiration> Province Place of DePaul6403 Granby StNorfolkVA2350502/25/2010> Province Place of MaryviewOne Bon Secours WayPortsmouthVA23703 > 02/25/2010>>> If the output didn't copy properly, it shows two listings who expire > 02/25/2010>> The day and month of the expiration is true, but the year is wrong. > This advertiser shouldn't show up here until one year from now.>> Where's my coding error? Anyone? Anyone? Bueller?>> TIA> -----> Patrick Junkroski--Apple-Mail-5--867436744Content-Type: text/html;charset=US-ASCIIContent-Transfer-Encoding: quoted-printableTHANK YOU, =TERRY!!!

I only subscribe to digest mode (how do I =switch to feed mode, by the way?), so I just saw your answer. It works =perfectly now! Knew it had to be something stupid. I mean, not that =you'd have to be stupid to figure it out -- that would be insulting the =guy who helped me. Aww, crap. You know what I meant. =:-)

Gary, thank you, too for your simple =solution. If Terry's hadn't worked, you were in the pipeline. Good, =brief code.

-----

Patrick =Junkroski

From: Terry Wilson =<terry@terryfic.com>

Date: February 19, 2009 =1:38:12 PM EST

To: <talk@webdna.us>

Subject: Re: [WebDNA] Math Date =issue

Reply-To: <talk@webdna.us>

should be =this:

&group1type=3Ddate&group2type=3Ddate

Terry
=

Hi -

I'm using WebDNA Commerce Edition =6.0 on a G5 Xserve under 10.3.9.

I have code =that is supposed to search a database and show any advertiser's status =(called linkexpires, in this example) falls between today's date and a =week from now. It generally seems to work, but every once in a while I =have an issue like this one.  

Here's my =code (minus some HTML to make it cleaner):

The =following companies have LINKS  whose status will expire between =[date] and [math =date]{[date]}+{00/07/0000}[/math]

[search =db=3DTheSeniorGuide.db&linkexpirestype=3Ddate&group1field=3Dlinkex=pires&group2field=3Dlinkexpires&group1fieldtype=3Ddate&group2f=ieldtype=3Ddate&legroup1datarq=3D[math =date]{[date]}+{00/07/0000}[/math]&gegroup2datarq=3D[date]&ascompan=ynamesort=3D1]

<table cellspacing=3D"10" =border=3D"1">

<tr><th>Company</th><th>Address</th=><th>City</th><th>State</th><th>Zip</th><th>Expiratio=n</th></tr>

[founditems][hideif =[linkexpires]=3D]

<tr><td><b>[companyname]</b></t=d><td>[streetaddress]</td><td>[city]</td><td>[state]</td=><td>[zip]</td><td>[linkexpires]</td></tr>

[/hide=if][/founditems]

[/search]

Here's the output:

The following companies have LINKS whose status will =expire between 02/19/2009 and 02/26/2009

Company	Address	City	State th>	Zip	Expiration
[companyname]	[streetaddress]	[city] td>	[state]	[zip]	[linkexpires]

Zip

Company	Address	City	State	Expiration
Province Place of =DePaul	6403 Granby =St	Norfolk	VA	23505	02/25/2010
Province Place of Maryview	One Bon Secours =Way	Portsmouth	VA	23703	02/25/2010 =

If the output =didn't copy properly, it shows two listings who expire =02/25/2010

The day and month of the expiration =is true, but the year is wrong. This advertiser shouldn't show up here =until one year from now.

Where's my coding =error? Anyone?  Anyone? = Bueller?

TIA

-----

Patr=ick =Junkroski