The following is what I get after I do what you said
$VAR1 = bless( {
'bool' => 'AND',
'not' => 0,
'cond' => [
[
'Ad_Expiry_Date',
'<',
'2003-05-08'
]
]
}, 'GT::SQL::Condition' );
GT::SQL::Driver::MYSQL::sth (13004): Executing query:
SELECT *
FROM lsql_Links, lsql_Users
WHERE lsql_Links.LinkOwner = lsql_Users.Username AND (lsql_Links.Ad_Expiry_Date < '2003-05-08')
from Plugins::Classifieds::remove_expired at /home/paulbax2/simcoeclassifieds/cgi-bin/classifieds/admin/Plugins/Classifieds.pm line 96
Content-type: text/html
<table border="1" cellpadding="0" cellspacing="0"><tr><td>
<table bgColor="#ffffff" border="0" cellPadding="3" cellSpacing="3" width="500" valign="top">
<tr>
<td align="left" bgColor="navy"><b><font color="#ffffff" size="2" face="Tahoma,Arial,Helvetica">Expired Ads Removed</font></b></td>
</tr>
<tr>
<td>
<p align="center"><b><font color="#000000" size="2" face="Tahoma,Arial,Helvetica">Expired Ads Removed</font></b></p>
<p><font size="2" face="Tahoma,Arial,Helvetica">0 expired Ads were removed.</font>
</td>
</tr>
</table>
</td></tr>
</table>
$VAR1 = bless( {
'bool' => 'AND',
'not' => 0,
'cond' => [
[
'Ad_Expiry_Date',
'<',
'2003-05-08'
]
]
}, 'GT::SQL::Condition' );
GT::SQL::Driver::MYSQL::sth (13004): Executing query:
SELECT *
FROM lsql_Links, lsql_Users
WHERE lsql_Links.LinkOwner = lsql_Users.Username AND (lsql_Links.Ad_Expiry_Date < '2003-05-08')
from Plugins::Classifieds::remove_expired at /home/paulbax2/simcoeclassifieds/cgi-bin/classifieds/admin/Plugins/Classifieds.pm line 96
Content-type: text/html
<table border="1" cellpadding="0" cellspacing="0"><tr><td>
<table bgColor="#ffffff" border="0" cellPadding="3" cellSpacing="3" width="500" valign="top">
<tr>
<td align="left" bgColor="navy"><b><font color="#ffffff" size="2" face="Tahoma,Arial,Helvetica">Expired Ads Removed</font></b></td>
</tr>
<tr>
<td>
<p align="center"><b><font color="#000000" size="2" face="Tahoma,Arial,Helvetica">Expired Ads Removed</font></b></p>
<p><font size="2" face="Tahoma,Arial,Helvetica">0 expired Ads were removed.</font>
</td>
</tr>
</table>
</td></tr>
</table>
