Fixed this by replacing the linefeeds. Other suggestions on who this could have been done?
SELECT REPLACE(REPLACE( column_name , CHAR(13), ''), CHAR(10), '')from table_name ; Troy On 7 October 2011 05:38, Troy Harris <[email protected]> wrote: > Hi, > > I'm attempting to test a DB with the JDBC request sampler and Im having an > issue with the Response Assertion. My SQL query returns multiple lines and > I want to use a Response Assertion (pattern equals) to validate. > If I run the query and copy paste the response into a Response Assertion > everything works as expected though when I attempt to use a variable from a > CSV dataset I can't work out how to get a new line. > > > Example > > Response Assertion variable from CSV (doesnt match) > -- > > Assertion error: false > Assertion failure: true > Assertion failure message: Test failed: text expected to equal / > > ****** received : Column1[[[ > 4 > 2 > 4 ]]] > > > > ****** comparison: Column1[[[ 4 2 4 ]]] > > > > Response Assertion with static values (Matches,set to fail. Received 4 > should have been 3) > -- > > Assertion error: false > Assertion failure: true > Assertion failure message: Test failed: text expected to equal / > > ****** received : Column1 > [[[4]]] > 2 > 4 > > > ****** comparison: Column1 > [[[3]]] > 2 > 4 > > > / > > > Thanks for your help > > Troy > > -- > NOTICE: > This e-mail message is intended only for the addressee(s) and contains > information which may be confidential. If you are not the intended > recipient please advise the sender by return email, do not use or disclose > the contents, and delete the message and any attachments from your system. > -- NOTICE: This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system.
