JDBC like statement
Hi community, I've been struggling with this issue for some time now but I found some workarounds, but now I need it and can't really find a good answer for me. I need to use in a jDBC query the '...
Forum Discussion
I'm afraid I can't publish the project here but here's screenshot form the query
I get my data for subscriber and soc from an xml command above inside this testcase. and since it somehow (maybe because of some format problem or spaces or I don't know what it won't get anything with '=' my thing would be the "like".
**************************
EDIT: I've found a workaround for my problem.
Instead of getting the data directly from the request I built a property- transfer with concat ([my value] ,%) that way I can query it with the property value in the like statement
Hi,
yeah - so I think you use a colon ':' if the property your calling in your SQL is a property on the JDBC step (never done this before) - not sure - but that seems to be the pattern.
(If anyone is reading this and can tell me what the colon char is supposed to do in this regard - that would be helpful!)
I can't find a way around it with the colon - it's a reserved character in SQL so I thought escaping it would work - but I've given it a shot and I couldn't get it to work - escaping should work - perhaps my escaping is incorrect.
I was going to suggest what your workaround was. It looks like the colon is used to specify 'this test step' when specifying the property or something similar. If you move the property you need to do the like on outside the JDBC test step (like my example with the property in a properties step) - this means you can remove the colon and then the use of the wildcard works with normal property transfer syntax.
So - sorry I couldn't help - but it sounds like you've got it sorted more or less now anyway.
cheers,
richie
