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.
| Author |
Topic |
|
ShaunBetts
Starting Member
7 Posts |
 Posted - 2009-06-22 : 07:26:23
|
| I am new to SQL, and Dev Shed, and i am doing some simple sql, with xml. The SQL only uses a SELECT REPLACE and FROM.The Code is quite long, what it is doing is submitting a page, the sql, is filling a field. As it is xml the the | need to be repalced using sql with ' i have been told.The error i am getting isSyntax error in query expression REPLACE( (URL address)<formvariables><ctrl id=|__EVENTTARGET| value=|| /><ctrl id=|__EVENTARGUMENT| value=|| /><ctrl id=|__LASTFOCUS| value=|| /><ctrl id=|__VIEWSTATE| value=|/wEPDwULLTE3ODM0NzQwOTQPZBYCAgMPZBYOAgEPDxY.|the code is below, it is long, and to me a load of letters, however i belive the error is in the text which is boldSELECTREPLACE('(URL address )<formvariables><ctrl id=|__EVENTTARGET| value=|| /><ctrl id=|__EVENTARGUMENT| value=|| /><ctrl id=|__LASTFOCUS| value=|| /><ctrl id=|__VIEWSTATE| value=|/wEPDwULLTE3ODM0NzQwOTQPZBYCAgMPZBYOAgEPDxYCHgdWaXNpYmxlaGRkAgcPDxYEHgRUZXh0BStFbnRlciBhIHZhbGlkIHBvc3Rjb2RlIHdpdGggY29ycmVjdCBzcGFjaW5nHwBnZGQ CDQ8QZA8WH2YCAQICAgMCBAIFAgYCBwIIAgkCCgILAgwCDQIOAg8CEAIRAhICEwIUAhUCFgIXAhgCGQIaAhsCHAIdAh4WHxAFEy0 tIFBsZWFzZSBzZWxlY3QgLS0FATBnEAUdQWVyaWFsICYgU2F0ZWxsaXRlIEluc3RhbGxlcnMFAjQ1ZxAFHEFwcGxpYW5jZSBSZXB haXIgVGVjaG5pY2lhbnMFAjQ2ZxAFFEJhdGhyb29tIFNwZWNpYWxpc3RzBQIzMGcQBRNCZWRyb29tIFNwZWNpYWxpc3RzBQIzMmc QBRRCdWlsZGVycyDigJMgR2VuZXJhbAUCMjdnEAUUQ2FycGVudGVycyAmIEpvaW5lcnMFAjIwZxAFFkNvbnNlcnZhdG9yeSBFcmV jdG9ycyAFAjIxZxAFKERhbXAsIFRpbWJlciAmIFVuZGVyZ3JvdW5kIFdhdGVycHJvb2ZlcnMFAjM3ZxAFJERpc2FiaWxpdHkgQ2F yZSBFcXVpcG1lbnQgSW5zdGFsbGVycwUCNTFnEAUlRHJhaW4gTWFpbnRlbmFuY2UgJiBSZXBhaXIgRW5naW5lZXJzIAUCMjJnEAU sRHJpdmV3YXlzICYgUGF0aW8gQ29udHJhY3RvcnMgKGhhcmRzY2FwaW5nKSAFAjIzZxAFFEVDTyBTeXN0ZW0gRW5naW5lZXJzBQI 1MGcQBQxFbGVjdHJpY2lhbnMFAjI0ZxAFEEZlbmNlIEluc3RhbGxlcnMFAjI1ZxAFGUZsb29yIENvdmVyaW5nIEluc3RhbGxlcnM FAjUyZxAFEkdhcmRlbiBMYW5kc2NhcGVycwUCMjZnEAUIR2xhemllcnMFAjI4ZxAFCEhhbmR5bWVuBQI0OWcQBRFIZWF0aW5nIEV uZ2luZWVycwUCMjlnEAUTS2l0Y2hlbiBTcGVjaWFsaXN0cwUCMzFnEAUVTGVhZHdvcmsgU3BlY2lhbGlzdHMgBQI0MmcQBQpMb2N rc21pdGhzBQI0OGcQBRVQYWludGVycyAmIERlY29yYXRvcnMFAjMzZxAFFlBsYXN0ZXJlcnMgJiBSZW5kZXJlcnMFAjM0ZxAFCFB sdW1iZXJzBQIzNWcQBR5Qcm9wZXJ0eSBNYWludGVuYW5jZSAtIEdlbmVyYWwFAjUzZxAFB1Jvb2ZlcnMFAjM2ZxAFE1NlY3VyaXR 5IEVuZ2luZWVycyAFAjM4ZxAFBlRpbGVycwUCMzlnEAUNVHJlZSBTdXJnZW9ucwUCNDdnFgECBWQCEQ9kFgQCAQ8PFgIfAGhkFgI CAQ8WAh4Fc3R5bGUFYmJhY2tncm91bmQtaW1hZ2U6dXJsKGltYWdlcy9ob21lX2JhY2tfMy5qcGcpO2hlaWdodDo1MDBweDt3aWR 0aDo1MDBweDtiYWNrZ3JvdW5kLXJlcGVhdDpuby1yZXBlYXQ7ZAIDDw8WAh8AaGQWAgIBDw8WBB8BBa0FPGJyIC8+VGhpcyB0cmF kZSBzZWxlY3RlZCBpbmNsdWRlcyB0aGUgZm9sbG93aW5nOiA8YnIgLz48YnIgLz5BbHRlcmF0aW9ucyAvIEdlbmVyYWwgTWFpbnR lbmFuY2UgLyBSZXBhaXJzPGJyIC8+RXh0ZW5zaW9ucyAvIExvZnQgQ29udmVyc2lvbnM8YnIgLz5Ccmlja3dvcmsgQ29udHJhY3R vcnM8YnIgLz5CdWlsZGluZyBDb250cmFjdG9ycyA8YnIgLz5DYXZpdHkgV2FsbCBJbnN1bGF0aW9uIEluc3RhbGxlcnM8YnIgLz5 DaGltbmV5IFNwZWNpYWxpc3RzPGJyIC8+RGVtb2xpdGlvbiBDb250cmFjdG9yczxiciAvPkRyeWxpbmluZyAvIFBsYXN0ZXJpbmc 8YnIgLz5GbG9vcmluZyAmIFRpbGluZyBDb250cmFjdG9yczxiciAvPkdyb3VuZHdvcmtlcnM8YnIgLz5HdXR0ZXJpbmc8YnIgLz5 TY2FmZm9sZGluZyBDb250cmFjdG9yczxiciAvPlNvdW5kcHJvb2ZpbmcgSW5zdGFsbGVyczxiciAvPlNwZWNpYWxpc3QgUG9pbnR pbmc8YnIgLz5TdG9uZSBDbGVhbmluZy9SZXN0b3JlcnM8YnIgLz5TdG9uZSBUaWxpbmc8YnIgLz5TdG9uZXdvcmtlcnMvU3RvbmU gQ2xhZGRpbmc8YnIgLz5TdHJ1Y3R1cmFsIFN0ZWVsd29yazxiciAvPlVuZGVyZmxvb3IgSGVhdGluZzxiciAvPlVuZGVycGlubml uZzxiciAvPlVQVkMgQ2xhZGRpbmc8YnIgLz5XYWxsIFRpZSBSZXBsYWNlbWVudCBDb250cmFjdG9yIDxiciAvPjxiciAvPh8AZ2R kAhMPDxYEHwEFVDxicj5UaGUgcmVzdWx0cyBzaG93biBhcmUgdGhvc2UgZm91bmQgaW4gdGhlIGxvY2FsaXR5PGJyIC8+IG9mIHR oZSBwb3N0Y29kZSBlbnRlcmVkOh8AaGRkAhUPFgIfAGhkAhcPDxYCHwBoZBYKAgEPDxYCHwFlZGQCAw8PFgQfAWUfAGhkZAIFDw8 WBB8BBQRQcmV2HwBoZGQCBw8PFgQfAQUDIHwgHwBoZGQCCQ8PFgQfAQUMTmV4dCBQYWdlID4+HwBoZGRknprBInHaObRuegWJz9U isPiFn4M=| /><ctrl id=|txtPostcode| value=|'+_POSTCODE+'| /><ctrl id=|txtName| value=|| /><ctrl id=|ddlTrade| value=|27| /><ctrl id=|btnSearch| value=|Search| /><ctrl id=|__EVENTVALIDATION| value=|/wEWJAK6hJ1rAuGVvaACAsSEhIULAqSX09QOArT4+boCAqj4hbkCAqj4gbkCAqn4ubkCAqn4sbkCAqr4nbkCAqr4ubkCAqr4tbkCA qn4nbkCAq/4tbkCAqr4sbkCAqr4jbkCAq/4ubkCAqr4ibkCAqr4hbkCAq/4sbkCAqr4gbkCAqr42boCAqj41boCAqr41boCAqn4tbkCAqj4sbkCAqj42boCAqn4jbkCAqn4ibkCAqn4hbkCAq/4jbkCAqn4gbkCAqn42boCAqn41boCAqj4nbkCAqWf8+4K8dYJBzQS0rSEzEpSOBIzrNlsU/c=| /></formvariables>','|','''')FROM_POSTCODESwhen i look at the end of the error message i see a bold .| however if i look at the actual code i dont see the .|i have tried putting in a .| but the same error comes upSorry for it being, so longThanksShaun |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-06-22 : 07:43:24
|
Nah -- the error is something elseLook at the last line. FROM_POSTCODE It should be this (with a space after the FROM)FROM _POSTCODE This code as exampleDECLARE @Foo TABLE ( [_postcode] NVARCHAR(50) )INSERT @foo ([_postCode]) SELECT 'SC6 ABC'UNION SELECT 'EEEf FWA'SELECTREPLACE('(URL address )<formvariables><ctrl id=|__EVENTTARGET| value=|| /><ctrl id=|__EVENTARGUMENT| value=|| /><ctrl id=|__LASTFOCUS| value=|| /><ctrl id=|__VIEWSTATE| value=|/wEPDwULLTE3ODM0NzQwOTQPZBYCAgMPZBYOAgEPDxYCHgdWaXNpYmxlaGRkAgcPDxYEHgRUZXh0BStFbnRlciBhIHZhbGlkIHBvc3Rjb2RlIHdpdGggY29ycmVjdCBzcGFjaW5nHwBnZGQ CDQ8QZA8WH2YCAQICAgMCBAIFAgYCBwIIAgkCCgILAgwCDQIOAg8CEAIRAhICEwIUAhUCFgIXAhgCGQIaAhsCHAIdAh4WHxAFEy0 tIFBsZWFzZSBzZWxlY3QgLS0FATBnEAUdQWVyaWFsICYgU2F0ZWxsaXRlIEluc3RhbGxlcnMFAjQ1ZxAFHEFwcGxpYW5jZSBSZXB haXIgVGVjaG5pY2lhbnMFAjQ2ZxAFFEJhdGhyb29tIFNwZWNpYWxpc3RzBQIzMGcQBRNCZWRyb29tIFNwZWNpYWxpc3RzBQIzMmc QBRRCdWlsZGVycyDigJMgR2VuZXJhbAUCMjdnEAUUQ2FycGVudGVycyAmIEpvaW5lcnMFAjIwZxAFFkNvbnNlcnZhdG9yeSBFcmV jdG9ycyAFAjIxZxAFKERhbXAsIFRpbWJlciAmIFVuZGVyZ3JvdW5kIFdhdGVycHJvb2ZlcnMFAjM3ZxAFJERpc2FiaWxpdHkgQ2F yZSBFcXVpcG1lbnQgSW5zdGFsbGVycwUCNTFnEAUlRHJhaW4gTWFpbnRlbmFuY2UgJiBSZXBhaXIgRW5naW5lZXJzIAUCMjJnEAU sRHJpdmV3YXlzICYgUGF0aW8gQ29udHJhY3RvcnMgKGhhcmRzY2FwaW5nKSAFAjIzZxAFFEVDTyBTeXN0ZW0gRW5naW5lZXJzBQI 1MGcQBQxFbGVjdHJpY2lhbnMFAjI0ZxAFEEZlbmNlIEluc3RhbGxlcnMFAjI1ZxAFGUZsb29yIENvdmVyaW5nIEluc3RhbGxlcnM FAjUyZxAFEkdhcmRlbiBMYW5kc2NhcGVycwUCMjZnEAUIR2xhemllcnMFAjI4ZxAFCEhhbmR5bWVuBQI0OWcQBRFIZWF0aW5nIEV uZ2luZWVycwUCMjlnEAUTS2l0Y2hlbiBTcGVjaWFsaXN0cwUCMzFnEAUVTGVhZHdvcmsgU3BlY2lhbGlzdHMgBQI0MmcQBQpMb2N rc21pdGhzBQI0OGcQBRVQYWludGVycyAmIERlY29yYXRvcnMFAjMzZxAFFlBsYXN0ZXJlcnMgJiBSZW5kZXJlcnMFAjM0ZxAFCFB sdW1iZXJzBQIzNWcQBR5Qcm9wZXJ0eSBNYWludGVuYW5jZSAtIEdlbmVyYWwFAjUzZxAFB1Jvb2ZlcnMFAjM2ZxAFE1NlY3VyaXR 5IEVuZ2luZWVycyAFAjM4ZxAFBlRpbGVycwUCMzlnEAUNVHJlZSBTdXJnZW9ucwUCNDdnFgECBWQCEQ9kFgQCAQ8PFgIfAGhkFgI CAQ8WAh4Fc3R5bGUFYmJhY2tncm91bmQtaW1hZ2U6dXJsKGltYWdlcy9ob21lX2JhY2tfMy5qcGcpO2hlaWdodDo1MDBweDt3aWR 0aDo1MDBweDtiYWNrZ3JvdW5kLXJlcGVhdDpuby1yZXBlYXQ7ZAIDDw8WAh8AaGQWAgIBDw8WBB8BBa0FPGJyIC8+VGhpcyB0cmF kZSBzZWxlY3RlZCBpbmNsdWRlcyB0aGUgZm9sbG93aW5nOiA8YnIgLz48YnIgLz5BbHRlcmF0aW9ucyAvIEdlbmVyYWwgTWFpbnR lbmFuY2UgLyBSZXBhaXJzPGJyIC8+RXh0ZW5zaW9ucyAvIExvZnQgQ29udmVyc2lvbnM8YnIgLz5Ccmlja3dvcmsgQ29udHJhY3R vcnM8YnIgLz5CdWlsZGluZyBDb250cmFjdG9ycyA8YnIgLz5DYXZpdHkgV2FsbCBJbnN1bGF0aW9uIEluc3RhbGxlcnM8YnIgLz5 DaGltbmV5IFNwZWNpYWxpc3RzPGJyIC8+RGVtb2xpdGlvbiBDb250cmFjdG9yczxiciAvPkRyeWxpbmluZyAvIFBsYXN0ZXJpbmc 8YnIgLz5GbG9vcmluZyAmIFRpbGluZyBDb250cmFjdG9yczxiciAvPkdyb3VuZHdvcmtlcnM8YnIgLz5HdXR0ZXJpbmc8YnIgLz5 TY2FmZm9sZGluZyBDb250cmFjdG9yczxiciAvPlNvdW5kcHJvb2ZpbmcgSW5zdGFsbGVyczxiciAvPlNwZWNpYWxpc3QgUG9pbnR pbmc8YnIgLz5TdG9uZSBDbGVhbmluZy9SZXN0b3JlcnM8YnIgLz5TdG9uZSBUaWxpbmc8YnIgLz5TdG9uZXdvcmtlcnMvU3RvbmU gQ2xhZGRpbmc8YnIgLz5TdHJ1Y3R1cmFsIFN0ZWVsd29yazxiciAvPlVuZGVyZmxvb3IgSGVhdGluZzxiciAvPlVuZGVycGlubml uZzxiciAvPlVQVkMgQ2xhZGRpbmc8YnIgLz5XYWxsIFRpZSBSZXBsYWNlbWVudCBDb250cmFjdG9yIDxiciAvPjxiciAvPh8AZ2R kAhMPDxYEHwEFVDxicj5UaGUgcmVzdWx0cyBzaG93biBhcmUgdGhvc2UgZm91bmQgaW4gdGhlIGxvY2FsaXR5PGJyIC8+IG9mIHR oZSBwb3N0Y29kZSBlbnRlcmVkOh8AaGRkAhUPFgIfAGhkAhcPDxYCHwBoZBYKAgEPDxYCHwFlZGQCAw8PFgQfAWUfAGhkZAIFDw8 WBB8BBQRQcmV2HwBoZGQCBw8PFgQfAQUDIHwgHwBoZGQCCQ8PFgQfAQUMTmV4dCBQYWdlID4+HwBoZGRknprBInHaObRuegWJz9U isPiFn4M=| /><ctrl id=|txtPostcode| value=|'+_POSTCODE+'| /><ctrl id=|txtName| value=|| /><ctrl id=|ddlTrade| value=|27| /><ctrl id=|btnSearch| value=|Search| /><ctrl id=|__EVENTVALIDATION| value=|/wEWJAK6hJ1rAuGVvaACAsSEhIULAqSX09QOArT4+boCAqj4hbkCAqj4gbkCAqn4ubkCAqn4sbkCAqr4nbkCAqr4ubkCAqr4tbkCA qn4nbkCAq/4tbkCAqr4sbkCAqr4jbkCAq/4ubkCAqr4ibkCAqr4hbkCAq/4sbkCAqr4gbkCAqr42boCAqj41boCAqr41boCAqn4tbkCAqj4sbkCAqj42boCAqn4jbkCAqn4ibkCAqn4hbkCAq/4jbkCAqn4gbkCAqn42boCAqn41boCAqj4nbkCAqWf8+4K8dYJBzQS0rSEzEpSOBIzrNlsU/c=| /></formvariables>','|','''')FROM @fooCharlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
 |
|
|
ShaunBetts
Starting Member
7 Posts |
Posted - 2009-06-22 : 13:11:41
|
quote:
Originally posted by Transact Charlie
Nah -- the error is something elseLook at the last line. FROM_POSTCODE It should be this (with a space after the FROM)FROM _POSTCODE This code as exampleDECLARE @Foo TABLE ( [_postcode] NVARCHAR(50) )INSERT @foo ([_postCode]) SELECT 'SC6 ABC'UNION SELECT 'EEEf FWA'SELECTREPLACE('(URL address )<formvariables><ctrl id=|__EVENTTARGET| value=|| /><ctrl id=|__EVENTARGUMENT| value=|| /><ctrl id=|__LASTFOCUS| value=|| /><ctrl id=|__VIEWSTATE| value=|/wEPDwULLTE3ODM0NzQwOTQPZBYCAgMPZBYOAgEPDxYCHgdWaXNpYmxlaGRkAgcPDxYEHgRUZXh0BStFbnRlciBhIHZhbGlkIHBvc3Rjb2RlIHdpdGggY29ycmVjdCBzcGFjaW5nHwBnZGQ CDQ8QZA8WH2YCAQICAgMCBAIFAgYCBwIIAgkCCgILAgwCDQIOAg8CEAIRAhICEwIUAhUCFgIXAhgCGQIaAhsCHAIdAh4WHxAFEy0 tIFBsZWFzZSBzZWxlY3QgLS0FATBnEAUdQWVyaWFsICYgU2F0ZWxsaXRlIEluc3RhbGxlcnMFAjQ1ZxAFHEFwcGxpYW5jZSBSZXB haXIgVGVjaG5pY2lhbnMFAjQ2ZxAFFEJhdGhyb29tIFNwZWNpYWxpc3RzBQIzMGcQBRNCZWRyb29tIFNwZWNpYWxpc3RzBQIzMmc QBRRCdWlsZGVycyDigJMgR2VuZXJhbAUCMjdnEAUUQ2FycGVudGVycyAmIEpvaW5lcnMFAjIwZxAFFkNvbnNlcnZhdG9yeSBFcmV jdG9ycyAFAjIxZxAFKERhbXAsIFRpbWJlciAmIFVuZGVyZ3JvdW5kIFdhdGVycHJvb2ZlcnMFAjM3ZxAFJERpc2FiaWxpdHkgQ2F yZSBFcXVpcG1lbnQgSW5zdGFsbGVycwUCNTFnEAUlRHJhaW4gTWFpbnRlbmFuY2UgJiBSZXBhaXIgRW5naW5lZXJzIAUCMjJnEAU sRHJpdmV3YXlzICYgUGF0aW8gQ29udHJhY3RvcnMgKGhhcmRzY2FwaW5nKSAFAjIzZxAFFEVDTyBTeXN0ZW0gRW5naW5lZXJzBQI 1MGcQBQxFbGVjdHJpY2lhbnMFAjI0ZxAFEEZlbmNlIEluc3RhbGxlcnMFAjI1ZxAFGUZsb29yIENvdmVyaW5nIEluc3RhbGxlcnM FAjUyZxAFEkdhcmRlbiBMYW5kc2NhcGVycwUCMjZnEAUIR2xhemllcnMFAjI4ZxAFCEhhbmR5bWVuBQI0OWcQBRFIZWF0aW5nIEV uZ2luZWVycwUCMjlnEAUTS2l0Y2hlbiBTcGVjaWFsaXN0cwUCMzFnEAUVTGVhZHdvcmsgU3BlY2lhbGlzdHMgBQI0MmcQBQpMb2N rc21pdGhzBQI0OGcQBRVQYWludGVycyAmIERlY29yYXRvcnMFAjMzZxAFFlBsYXN0ZXJlcnMgJiBSZW5kZXJlcnMFAjM0ZxAFCFB sdW1iZXJzBQIzNWcQBR5Qcm9wZXJ0eSBNYWludGVuYW5jZSAtIEdlbmVyYWwFAjUzZxAFB1Jvb2ZlcnMFAjM2ZxAFE1NlY3VyaXR 5IEVuZ2luZWVycyAFAjM4ZxAFBlRpbGVycwUCMzlnEAUNVHJlZSBTdXJnZW9ucwUCNDdnFgECBWQCEQ9kFgQCAQ8PFgIfAGhkFgI CAQ8WAh4Fc3R5bGUFYmJhY2tncm91bmQtaW1hZ2U6dXJsKGltYWdlcy9ob21lX2JhY2tfMy5qcGcpO2hlaWdodDo1MDBweDt3aWR 0aDo1MDBweDtiYWNrZ3JvdW5kLXJlcGVhdDpuby1yZXBlYXQ7ZAIDDw8WAh8AaGQWAgIBDw8WBB8BBa0FPGJyIC8+VGhpcyB0cmF kZSBzZWxlY3RlZCBpbmNsdWRlcyB0aGUgZm9sbG93aW5nOiA8YnIgLz48YnIgLz5BbHRlcmF0aW9ucyAvIEdlbmVyYWwgTWFpbnR lbmFuY2UgLyBSZXBhaXJzPGJyIC8+RXh0ZW5zaW9ucyAvIExvZnQgQ29udmVyc2lvbnM8YnIgLz5Ccmlja3dvcmsgQ29udHJhY3R vcnM8YnIgLz5CdWlsZGluZyBDb250cmFjdG9ycyA8YnIgLz5DYXZpdHkgV2FsbCBJbnN1bGF0aW9uIEluc3RhbGxlcnM8YnIgLz5 DaGltbmV5IFNwZWNpYWxpc3RzPGJyIC8+RGVtb2xpdGlvbiBDb250cmFjdG9yczxiciAvPkRyeWxpbmluZyAvIFBsYXN0ZXJpbmc 8YnIgLz5GbG9vcmluZyAmIFRpbGluZyBDb250cmFjdG9yczxiciAvPkdyb3VuZHdvcmtlcnM8YnIgLz5HdXR0ZXJpbmc8YnIgLz5 TY2FmZm9sZGluZyBDb250cmFjdG9yczxiciAvPlNvdW5kcHJvb2ZpbmcgSW5zdGFsbGVyczxiciAvPlNwZWNpYWxpc3QgUG9pbnR pbmc8YnIgLz5TdG9uZSBDbGVhbmluZy9SZXN0b3JlcnM8YnIgLz5TdG9uZSBUaWxpbmc8YnIgLz5TdG9uZXdvcmtlcnMvU3RvbmU gQ2xhZGRpbmc8YnIgLz5TdHJ1Y3R1cmFsIFN0ZWVsd29yazxiciAvPlVuZGVyZmxvb3IgSGVhdGluZzxiciAvPlVuZGVycGlubml uZzxiciAvPlVQVkMgQ2xhZGRpbmc8YnIgLz5XYWxsIFRpZSBSZXBsYWNlbWVudCBDb250cmFjdG9yIDxiciAvPjxiciAvPh8AZ2R kAhMPDxYEHwEFVDxicj5UaGUgcmVzdWx0cyBzaG93biBhcmUgdGhvc2UgZm91bmQgaW4gdGhlIGxvY2FsaXR5PGJyIC8+IG9mIHR oZSBwb3N0Y29kZSBlbnRlcmVkOh8AaGRkAhUPFgIfAGhkAhcPDxYCHwBoZBYKAgEPDxYCHwFlZGQCAw8PFgQfAWUfAGhkZAIFDw8 WBB8BBQRQcmV2HwBoZGQCBw8PFgQfAQUDIHwgHwBoZGQCCQ8PFgQfAQUMTmV4dCBQYWdlID4+HwBoZGRknprBInHaObRuegWJz9U isPiFn4M=| /><ctrl id=|txtPostcode| value=|'+_POSTCODE+'| /><ctrl id=|txtName| value=|| /><ctrl id=|ddlTrade| value=|27| /><ctrl id=|btnSearch| value=|Search| /><ctrl id=|__EVENTVALIDATION| value=|/wEWJAK6hJ1rAuGVvaACAsSEhIULAqSX09QOArT4+boCAqj4hbkCAqj4gbkCAqn4ubkCAqn4sbkCAqr4nbkCAqr4ubkCAqr4tbkCA qn4nbkCAq/4tbkCAqr4sbkCAqr4jbkCAq/4ubkCAqr4ibkCAqr4hbkCAq/4sbkCAqr4gbkCAqr42boCAqj41boCAqr41boCAqn4tbkCAqj4sbkCAqj42boCAqn4jbkCAqn4ibkCAqn4hbkCAq/4jbkCAqn4gbkCAqn42boCAqn41boCAqj4nbkCAqWf8+4K8dYJBzQS0rSEzEpSOBIzrNlsU/c=| /></formvariables>','|','''')FROM @fooHi Charlie I made the changes, you suggested DECLARE @foo TABLE( [_postcode] NVARCHAR(50) )INSERT @foo ([_postCODE]) SELECT'AB10 1GY'UNION SELECT 'EEE f FWA'SELECTFROM _POSTCODEShowever i get this error messageInvalid SQL statement; expected DELETE , INSERT , PROCEDURE , SELECT , or UPDATE .|I noticed the .| came up againso what i did was to delete all the letters and stuff in between so it looked like SELECTREPLACE('http://trustmark.boroughit.com/frames/default.aspx<formvariables><ctrl id=|__EVENTTARGET| value=|| /><ctrl id=|__EVENTARGUMENT| value=|| /><ctrl id=|__LASTFOCUS| value=|| /><ctrl id=|__VIEWSTATE| value=|/=| /><ctrl id=|txtPostcode| value=|'+_POSTCODE+'| /><ctrl id=|txtName| value=|| /><ctrl id=|ddlTrade| value=|27| /><ctrl id=|btnSearch| value=|Search| /><ctrl id=|__EVENTVALIDATION| value=|/c=| /></formvariables>','|','''')FROM _POSTCODESwith this error Syntax error in query expression REPLACE( http://trustmark.boroughit.com/frames/default.aspx<formvariables><ctrl id=|__EVENTTARGET| value=|| /><ctrl id=|__EVENTARGUMENT| value=|| ||which suggests to me that the pippes may not be replaced with ' which is the aim ?Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION
Shaun |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-06-22 : 14:23:21
|
| Can you confirm if the code I posted works on it's own? Don't do anything to it just try to run it in management studio.It runs OK on my 2005 box.Can you also tell us what version of SQL server you are running?Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-06-22 : 14:25:36
|
quote:
Dev Shed
Are you running MySql by any chance? This is a Microsoft SQL server forum. The syntax will be different.I don't know if the syntax for table variables is the same in mysql.If you are using mySql I'd advise posting on http://www.dbforums.com/They've got a really good mysql section.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
ShaunBetts
Starting Member
7 Posts |
Posted - 2009-06-22 : 15:34:39
|
| I am using Microsoft Server 2005, however it is built in to another program called web scrapperShaun |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-06-23 : 03:58:46
|
| maybe it's truncating your string?Do you access to management studio for your database server?If so you can try running your sql directly just to see if it works.If it does (which it should because the one I posted does direct on my 2005 box) then the problem is in whatever dev environment you are using.You could also try taking maybe 10 characters from your string and doing the logic just on those 10 characters to see if you are running into some crazy character limit.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
|
|
|
|
|
Syntax Error