texte = --Apple-Mail-130--938688097 Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit 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]
| Company | Address | City | State | Zip | Expiration |
|---|
[founditems][hideif [linkexpires]=] | [companyname] | [streetaddress] | [city] | [state] | [zip] | [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 Company Address City State Zip 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 ----- Patrick Junkroski --Apple-Mail-130--938688097 Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable 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:
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
= --Apple-Mail-130--938688097--
Associated Messages, from the most recent to the oldest:
--Apple-Mail-130--938688097 Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit 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]