Undefined function REPALCE in expression

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Undefined function REPALCE in expression

Author

Topic

ShaunBetts
Starting Member

7 Posts

Posted - 2009-08-03 : 03:07:52

I am trying to change the hyohones in a xml statement to |, so i can input data into a text box, however i keep on getting this error Undefined function REPALCE in expression

here is the code much of it is is not relivant, so i have highlited the SQL parts

SELECT
REPALCE('URL GOES HERE <formvariables><ctrl id=|__EVENTTARGET| value=|| /><ctrl id=|__EVENTARGUMENT| value=|| /><ctrl id=|__LASTFOCUS| value=|| /><ctrl id=|__VIEWSTATE| value=|/wEPDwULLTE3ODM0NzQwOTQPZBYCAgMPZBYOAgEPDxYCHgdWaXNpYmxlaGRkAgcPDxYEHgRUZXh0BStFbnRlciBhIHZhbGlkIHBvc3Rjb2RlIHdpdGggY2
9ycmVjdCBzcGFjaW5nHwBnZGQCDQ8QZA8WH2YCAQICAgMCBkIFdhdGVycHJvb2ZlcnMFAjM3ZlbmFuY2UgJiBSZXBhaXIgRW5naW5lZXJzIAUCMjJnEAUsRHJ
pdmV3YXlzICYgUGF0aW8gQ29udHJhY3RvcnMgKGhhcmRzY2FwaW5nKSAFAjIzZxAFFEVDTyBTeXN0ZW0gRW5naW5lZXJzBQI1MGcQBQxFbGVjdHJpY2lhbnMFAjI0Zx
Vtb2xpdGlvbiBDb250cmFjdG9yczxiciAvPkRyeWxpbmluZyAvIFBPkHwBoZGQCBw8PFgQfAQUDIHwgHdCBQYWdlID4+HwBoZGRknprBInHaObRuegWJz9UisPiFn4M=| /><ctrl id=|txtPostcode| value=| '+ POSTCODES
+' | /><ctrl id=|txtName| value=|| /><ctrl id=|ddlTrade| value=|27| /><ctrl id=|btnSearch| value=|Search| /><ctrl id=|__EVENTVALIDATION| value=|/wEWJAK6hJ1rAuGVvaACAsSEhIULAqSX09QOArT4+boCAqj4hbkCAqj4gbkCAqn4ubkCAqn4sbkCAqr4nbkCAqr4ubkCAqr4tbkCAqn4nbkCAq/4tbkCAqr4sbkCAqr4jbkCAq/4ubkCAqr4ibkCAqr4hbkCAq/4sbkCAqr4gbkCAqr42boCAqj41boCAqr41boCAqn4tbkCAqj4sbkCAqj42boCAqn4jbkCAqn4ibkCAqn4hbkCAq/4jbkCAqn4gbkCAqn42boCAqn41boCAqj4nbkCAqWf8+4K8dYJBzQS0rSEzEpSOBIzrNlsU/c=| /></formvariables>','|','''')
FROM Spare

Shaun

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-08-03 : 03:41:29

REPALCE is misspelled. Try REPLACE instead.

N 56°04'39.26"
E 12°55'05.63"

ShaunBetts
Starting Member

7 Posts

Posted - 2009-08-03 : 03:56:40

Thanks I had not noticed it, however it still comes up with the same error just insted of REPALCE IT COMES UP WITH REPLACE.

Shaun

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-08-03 : 04:09:13

Works perfectly for me...

DECLARE	@Spare TABLE
	(
		POSTCODES VARCHAR(10)
	)

INSERT	@Spare
SELECT	'12345'

SELECT	REPLACE('URL GOES HERE <formvariables><ctrl id=|__EVENTTARGET| value=|| />
<ctrl id=|__EVENTARGUMENT| value=|| /><ctrl id=|__LASTFOCUS| value=|| />
<ctrl id=|__VIEWSTATE| value=|/wEPDwULLTE3ODM0NzQwOTQPZBYCAgMPZBYOAgEPDxYCHgdWaXNpY
mxlaGRkAgcPDxYEHgRUZXh0BStFbnRlciBhIHZhbGlkIHBvc3Rjb2RlIHdpdGggY29ycmVjdCBzcGFjaW5n
HwBnZGQCDQ8QZA8WH2YCAQICAgMCBkIFdhdGVycHJvb2ZlcnMFAjM3ZlbmFuY2UgJiBSZXBhaXIgRW5naW5
lZXJzIAUCMjJnEAUsRHJpdmV3YXlzICYgUGF0aW8gQ29udHJhY3RvcnMgKGhhcmRzY2FwaW5nKSAFAjIzZx
AFFEVDTyBTeXN0ZW0gRW5naW5lZXJzBQI1MGcQBQxFbGVjdHJpY2lhbnMFAjI0ZxVtb2xpdGlvbiBDb250c
mFjdG9yczxiciAvPkRyeWxpbmluZyAvIFBPkHwBoZGQCBw8PFgQfAQUDIHwgHdCBQYWdlID4+HwBoZGRknp
rBInHaObRuegWJz9UisPiFn4M=| /><ctrl id=|txtPostcode| value=| ' + POSTCODES +' | />
<ctrl id=|txtName| value=|| /><ctrl id=|ddlTrade| value=|27| />
<ctrl id=|btnSearch| value=|Search| /><ctrl id=|__EVENTVALIDATION| value=|/wEWJAK6h
J1rAuGVvaACAsSEhIULAqSX09QOArT4+boCAqj4hbkCAqj4gbkCAqn4ubkCAqn4sbkCAqr4nbkCAqr4ubkC
Aqr4tbkCAqn4nbkCAq/4tbkCAqr4sbkCAqr4jbkCAq/4ubkCAqr4ibkCAqr4hbkCAq/4sbkCAqr4gbkCAqr
42boCAqj41boCAqr41boCAqn4tbkCAqj4sbkCAqj42boCAqn4jbkCAqn4ibkCAqn4hbkCAq/4jbkCAqn4gb
kCAqn42boCAqn41boCAqj4nbkCAqWf8+4K8dYJBzQS0rSEzEpSOBIzrNlsU/c=| /></formvariables>', '|', '''')
FROM	@Spare

N 56°04'39.26"
E 12°55'05.63"

ShaunBetts
Starting Member

7 Posts

Posted - 2009-08-03 : 12:44:39

I have found the problem, i was connecting into Access and running SQL, which i dont think the connection supported, so i used SQL database

Thanks

Shaun

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources