Any help would be great on this.
SQL = "SELECT COUNT(*) FROM [SDADMIN].[SRFILE] WHERE SRSITE = 'Our Lady's R C Sports College - Hbev' AND SRCOMPLETE=0 AND SRINCOMP=1 AND SR_Group=38;"
The function is called via the below:
<td style="width: 114px" class="style65"><a href="/suppdesk/customercalls.asp?customer=BSFMAN&site=Our+Lady's+R+C+Sports+College"><%=SDsitecalls1("Our Lady's R C Sports College - Hbev")%></a></td>
When this is ran I do not receive any errors but the SELECT command doesn't return any results (Just a 0). I've tried a few different methods such as using the Parameter SiteName and Single/Double Apostrophes however I either receive an error or blank results.
The function works with all other names however the apostrophe seems to cause issues here. Is there a way to extract the data without editing the SQL?
Thanks very much for the help,
View Complete Post