Invalid column name 'NEWURL'
HejJeg klipper en del i E.URL, hvorefter den bliver til NEWURL, som skal bruges senere i sætningen. Desværre kan man ikke gøre det på den måde, idet Enterprise siger: "Invalid column name 'NEWURL'"
SELECT DISTINCT
REPLACE(REPLACE(REPLACE(LEFT(E.Url, 7 + CHARINDEX('/', SUBSTRING(E.Url + '/', 8, LEN(E.Url) - 6)) - 1), 'https://', ''), 'http://', ''), 'www.', '')
AS NEWURL
FROM KALENDER_EVENTS E LEFT OUTER JOIN
KALENDER_DATES D ON E.ID = D.EventID AND D.[Date] >= '01/08/2005' AND D.[Date] <= '01/09/2005'
WHERE (LEN(E.Url) > 5) AND
(NEWURL LIKE '%(SELECT URL FROM PLUSPROFIL_ANNONCE
WHERE (UsedPoints < OrderPoints))%')
Jeg har også prøvet at gemme E.URL tilbage i E.URL:
SELECT DISTINCT
REPLACE(REPLACE(REPLACE(LEFT(E.Url, 7 + CHARINDEX('/', SUBSTRING(E.Url + '/', 8, LEN(E.Url) - 6)) - 1), 'https://', ''), 'http://', ''), 'www.', '')
AS E.URL
FROM KALENDER_EVENTS E LEFT OUTER JOIN
KALENDER_DATES D ON E.ID = D.EventID AND D.[Date] >= '01/08/2005' AND D.[Date] <= '01/09/2005'
WHERE (LEN(E.Url) > 5) AND
(E.URL LIKE '%(SELECT URL FROM PLUSPROFIL_ANNONCE
WHERE (UsedPoints < OrderPoints))%')
Men så siger Enterprise i stedet:
Error in list of function arguments: '.' not recognized.
Missing FROM clause.
Unable to parse query text.