Get this error when I click List Affiliate Results:

Microsoft VBScript runtime error '800a005e'
Invalid use of Null
/vsadmin/inc/incaffil.asp, line 648

Uploaded fresh copy still get the error.

Line 648

<% if date()-datevalue(alldata(6,index))<7 then print " <span style=""color:#FF0000"">" & "**"&yyNew&"**" & "</span>"%>
</td>
<td><% print htmlspecials(alldata(1,index))
%></td>

Responsive Design Deals Ecomm Plus - ASP 6.8
www.paradiseclothingco.com

Hi Mark

I'm not seeing that on my test store running 6.8 - are you running an Access or MS SQL database?

Andy

Please feel free to review / rate our software

MS SQL

Responsive Design Deals Ecomm Plus - ASP 6.8
www.paradiseclothingco.com

That's the line that indicates a new affiliate in the list and probably hasn't changed for a long time so I'm wondering is it's a database issue, particularly the "Invalid use of Null".

If you sign up as a dummy affiliate, do you get the same message?

Andy

Please feel free to review / rate our software

It looks like it's the date field, the ones with no date are giving me the error ... not sure why theres no date entered on some of these. Entering a date corrects the error.

Responsive Design Deals Ecomm Plus - ASP 6.8
www.paradiseclothingco.com