cancel
Showing results for 
Search instead for 
Did you mean: 

0 down vote favorite I have a problem which I don't quite seem to get and therefore not sure about

SOLVED
Highlighted
Occasional Contributor

0 down vote favorite I have a problem which I don't quite seem to get and therefore not sure about

Hi everyone,
 

I have a problem which I don't quite seem to get and therefore not sure about any solutions. I have in Soap UI a Data source that gets it's values from an excel sheet, now I try to check some of the data that has been manipulated via a CRM software and query the database with the DS values that looks like:

select * from payment where customer = :cid and payment_source = :bank

that select stays empty, but when I hardcode the last value select * from payment where customer = :cid and payment_source = 'FIRSTNAT' the data gets returned, so I assume that the JDBC doesn't know that the last value is a string. Is there any (easy) way to like tell jdbc or soap that that last thing is a string? I've read across forums and there's some toString()functions and some mentions of groovy scripts, but I'm totally blank in these corners of soap.

 

best wishes

Pat

4 REPLIES
Community Leader

Re: 0 down vote favorite I have a problem which I don't quite seem to get and therefore not sure abo

Use Property Expansions

 

select *
from payment 
where customer = '${#DataSource#cid}'
and payment_source = '${#DataSource#bank}'
Community Hero

Re: 0 down vote favorite I have a problem which I don't quite seem to get and therefore not sure abo

Would you like to show a screen shot of the same?
Are you using JDBC test step?
Do you get any errors?
Occasional Contributor

Re: 0 down vote favorite I have a problem which I don't quite seem to get and therefore not sure abo

hi,
It's a teststep yes I have a lot of other DB queries in other parts only this one makes troubles somehow.
Here's the two windows one with the property hardcoded, and transferred .


Clipboard02.jpgClipboard01.jpg

Occasional Contributor

Re: 0 down vote favorite I have a problem which I don't quite seem to get and therefore not sure abo

thnx, the property expansion worked, not quite what I planned but at least a "workaround"

Share Your Stories
Read Latest News
Top Kudoed Authors