Hey All,
Im not quite sure where to post this error, as I am trying to write a stored procedure to be used in a asp.net application, but I cant seem to get the SQL right:
Thats the query I am running, and I get this error:Code:select cast('<Page><Id>' As varchar(266)) + cast(pa_pageid AS int) + '</Id><Path>' + pa_path + '</Path><Replace>' + pa_replace + '</Replace><Scrape>' + pa_scrape + '</Scrape><Select>' + pa_selectorid + '</Select> <Sel-pos>' + pa_selpos + '</Sel-pos><Sel-tag>' + pa_seltag + '</Sel-tag><Regex>' + pa_regex + '</Regex></Page>' from WST_Page
Could anyone point me in the right direction?Code:Conversion failed when converting the varchar value '<Page><Id>' to data type int.
Cheers,
Andrew




Reply With Quote
