I have created a script with displays results based on date range. It all works fine.
Can anyone point me in the right direct with adding a further statement to the code below, so that I can filter the results by 'LeadState' etc aswell as the date range.
I have tried to add line 2 ( commented out now) but this does not work.
MYSQL="select * from DEBT "
'MYSQL=MYSQL & " WHERE LeadState='RECONTACT' "
MYSQL=MYSQL & " WHERE EntryDate BETWEEN "
MYSQL=MYSQL & "#" & varValue1
MYSQL=MYSQL & "# AND #" & varValue2 & "#;"
'Response.Write "<HR>" & MYSQL & "<HR>"