Plays
| Script: | /theatre/Plays.asp |
| Description: | The connection cannot be used to perform this operation. It is either closed or invalid in this context. |
| SQL Statement: | SELECT DISTINCT UPPER(left(case when left(PlayName,2)='A ' THEN right(PlayName,len(PlayName)-2) when left(PlayName,3)='An ' THEN right(PlayName,len(PlayName)-3) when left(PlayName,1)='''' THEN right(PlayName,len(PlayName)-1) when left(PlayName,4)='The ' THEN right(PlayName,len(PlayName)-4) else PlayName END ,1)) AS PlayStrip FROM tbl_nt_Play WHERE left(PlayName,1)>='A' and left(PlayName,1)<='Z' order by PlayStrip |
| Source: | ADODB.Recordset |
| Error Number: | 3709 |