Re: [WebDNA] Math Date issue

This WebDNA talk-list message is from

2009

It keeps the original formatting. numero = 102031
interpreted = N
texte = --=====================_744540703==.ALTContent-Type: text/plain; charset="us-ascii"Why not just:&rnlinkexpiresdata=[math date]{[date]}+{00/07/0000}[/math] [date]?GJKAt 12:02 PM 2/19/2009, you wrote:>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 WayPortsmouthVA2370302/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--=====================_744540703==.ALTContent-Type: text/html; charset="us-ascii"Why not just:

&rnlinkexpiresdata=[math date]{[date]}+{00/07/0000}[/math][date]

?

GJK

At 12:02 PM 2/19/2009, you wrote:

Hi -

I'm using WebDNA Commerce Edition 6.0 on a G5 Xserve under10.3.9.

I have code that is supposed to search a database and show anyadvertiser's status (called linkexpires, in this example) falls betweentoday's date and a week from now. It generally seems to work, but everyonce 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]

[searchdb=TheSeniorGuide.db&linkexpirestype=date&group1field=linkexpires&group2field=linkexpires&group1fieldtype=date&group2fieldtype=date&legroup1datarq=[mathdate]{[date]}+{00/07/0000}[/math]&gegroup2datarq=[date]&ascompanynamesort=1]
<table cellspacing="10" border="1">
<tr><th>Company</th><th>Address</th><th>City</th><th>State</th><th>Zip</th><th>Expiration</th></tr>
[founditems][hideif [linkexpires]=]
<tr><td><b>[companyname]</b></td><td>[streetaddress]</td><td>[city]</td><td>[state]</td><td>[zip]</td><td>[linkexpires]</td></tr>
[/hideif][/founditems]
[/search]

Here's the output:

The following companies have LINKS whose status will expirebetween 02/19/2009 and 02/26/2009

CompanyAddressCityStateZipExpiration
Province Place of DePaul6403 GranbyStNorfolkVA2350502/25/2010
Province Place of MaryviewOne Bon SecoursWayPortsmouthVA2370302/25/2010

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

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

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

TIA
-----
Patrick Junkroski

--=====================_744540703==.ALT-- Associated Messages, from the most recent to the oldest:

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

Re: [WebDNA] math date issues? (Stuart Tremain 2013)
Re: [WebDNA] math date issues? (Donovan Brooke 2013)
Re: [WebDNA] math date issues? (Donovan Brooke 2013)
[WebDNA] math date issues? ("Brian B. Burton" 2013)
Re: [WebDNA] Math Date issue (Gary Krockover 2009)
Re: [WebDNA] Math Date issue (Terry Wilson 2009)
[WebDNA] Math Date issue (Patrick Junkroski 2009)

--=====================_744540703==.ALTContent-Type: text/plain; charset="us-ascii"Why not just:&rnlinkexpiresdata=[math date]{[date]}+{00/07/0000}[/math] [date]?GJKAt 12:02 PM 2/19/2009, you wrote:>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 WayPortsmouthVA2370302/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--=====================_744540703==.ALTContent-Type: text/html; charset="us-ascii"Why not just:

&rnlinkexpiresdata=[math date]{[date]}+{00/07/0000}[/math][date]

?

GJK

At 12:02 PM 2/19/2009, you wrote:

Hi -

I'm using WebDNA Commerce Edition 6.0 on a G5 Xserve under10.3.9.

I have code that is supposed to search a database and show anyadvertiser's status (called linkexpires, in this example) falls betweentoday's date and a week from now. It generally seems to work, but everyonce 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]

[searchdb=TheSeniorGuide.db&linkexpirestype=date&group1field=linkexpires&group2field=linkexpires&group1fieldtype=date&group2fieldtype=date&legroup1datarq=[mathdate]{[date]}+{00/07/0000}[/math]&gegroup2datarq=[date]&ascompanynamesort=1]
<table cellspacing="10" border="1">
<tr><th>Company</th><th>Address</th><th>City</th><th>State</th><th>Zip</th><th>Expiration</th></tr>
[founditems][hideif [linkexpires]=]
<tr><td><b>[companyname]</b></td><td>[streetaddress]</td><td>[city]</td><td>[state]</td><td>[zip]</td><td>[linkexpires]</td></tr>
[/hideif][/founditems]
[/search]

Here's the output:

The following companies have LINKS whose status will expirebetween 02/19/2009 and 02/26/2009

CompanyAddressCityStateZipExpiration
Province Place of DePaul6403 GranbyStNorfolkVA2350502/25/2010
Province Place of MaryviewOne Bon SecoursWayPortsmouthVA2370302/25/2010

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

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

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

TIA
-----
Patrick Junkroski

--=====================_744540703==.ALT-- Gary Krockover

DOWNLOAD WEBDNA NOW!

Re: [WebDNA] Math Date issue

2009

Top Articles:

Related Readings: