On 17 April 2012 07:35, Troy Harris <[email protected]> wrote: > Fixed this by replacing the linefeeds. Other suggestions on who this could > have been done? >
http://jmeter.apache.org/usermanual/functions.html#__char can be used to insert CRLF into a string. > > 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. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
