record counting
Hi everyone,
I have had a very confusing issue this week.
I have a linkDirectory.When I run it on my localhost it works fine and shows me the number of links of each category for ex. Accomodations(8) but when I upload the files on the webserver and test it the number of links are not displayed and I see accomodations(0)
Does anyone have any idea?
Can the problem be from the server side or the code has issue?
The sql statement looks like this:
rsCat.Source = "SELECT *, (SELECT COUNT (*) FROM LINKS WHERE LINKS.CAT_ID = DIRCATS.CAT_ID AND LINK_APPROVED = 1 AND LINK_EXPIRED >= DATE() ) AS LINK_COUNT FROM DIRCATS ORDER BY CAT_NAME ASC"
|