M Wilson

Ranch Hand
+ Follow
since May 23, 2010
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by M Wilson

So far got something like this, not all quite working yet, still trying to figure out how to loop the list and set the constructor but I'll play around with it some more.



Thank.

8 years ago
I wrote this class with a constructor to set the 2 variables:


I have no problem figuring out how to get them:




How do you set the 2 variables that use the constructor with the 2 arguments?

Thank you very much.


8 years ago
I used ArrayList<String> arrL1 = new ArrayList<String>();
because it was piece of code I found on the internet so probably don't know any better and I don't do Java coding on a regular basis.
Because to contain only String?
Thanks for the info but I don't think I've gotten any suggestions for my question?

Thanks.
8 years ago
For example I have 2 of the following variables:
ArrayList<String> arrL1 = new ArrayList<String>();
ArrayList<String> arrL2 = new ArrayList<String>();

How do a declare a variable for multiple array lists?
The system doesn't like the following, saying 'cannot create a generic array of ArrayList<String>'
ArrayList<String>[] arrayLists = {arrL1 , arrL2 };


Thank you much for any help and suggestions.
8 years ago
I figured out the send keys but it's not implemented yet with most current of appium. For now I can get around it by executing a command prompt in the code.
Thanks all.
8 years ago
Automating mobile app test on emulator using AndroidDriver how do you code to click on the Menu button? Attached screenshot.

Thank you.
8 years ago
Ahhh!
Thank you much everybody!
8 years ago
What is Object[][] mean? That is, what is it?


public static Object[][] getExcelData(String fileName, String sheetName)
{

}

Thanks
8 years ago

B.LAST_NM LIKE A.FULL_NAME should be enough, why are you putting , B.LAST_NM in?

DB2 SQL
The full name may be a business or trust name. The person's last name may or may not be part of that full name.

For example business name is WILSON'S GARDEN which is not a match to John Smith but is a match to Jane Wilson.

It doesn't like: B.LAST_NM LIKE A.FULL_NAME

SELECT *
FROM TABLEA AS A, TABLEB AS B
WHERE
B.LAST_NM LIKE A.FULL_NAME
AND A.ID = B.ID

again gives syntax error

Thanks much!!!
SQL DB2
How do you do a like on column name of one column to another (not an actual value)
For example
last name is Smith
Full name is John Smith

LOCATE(A.FULL_NAME, B.LAST_NM) <> 0

This won't return anything, it doesn't seem to find just the last name part 'Smith' in the full name value 'John Wilson'

Searching around I've tried B.LAST_NM LIKE '%'||A.FULL_NAME||'%' which I don't think it's right syntax that is throwing syntax error.

How do you like a column name for another column name?

Thanks much!
This is what I was looking for and got it figure out a couple of weeks ago, I thought I post and share (it's not the actual SQL but structured as so and worked for what I was trying to do)
it's sql in a sql SELECT...WHERE IN (SELECT...)

SELECT *
FROM A
WHERE A.NUMBER IN (SELECT A.NUMBER FROM B INNER JOIN A ON B.NUMBER = A.NUMBER AND B.TYPECD = 'O' ) AND B.PARTY_CD = 'P'
FETCH FIRST 1 ROWS ONLY

'O' stands for the organization, 'P' stands for the person/people of the organization.
I want to retrieve data is that an organization, therefore SQL for typecd 'O'
and from result of typecd 'O' get the person's name. I want the person's name that is related to the organization.

For example SQL1 typecd 'O' returns name 'THE TRUST OF JOHN AND MARY DOE'
SQL2 typecd 'P' return 2 rows:
row1: name 'DOE, JOHN' sn='2222'
row2: name 'DOE, JANE' sn='1111'

I want the person's name with sn='2222' for the organization.

Thanks!
I have 2 sql's and want to know how to combine.
SQLS simplied:

SQL1 =
select A.number, B.sn
from A, B
where A.id = B.id
and B.typecd =' O'

SQL1 returns for example
A.number = 12345Z
B.sn = 2222

SQL2 =
select B.name, A.dob, A.sn
from A, B
where A.id = B.id
and B.typecd = 'P'
and A.number = '12345Z'
and B.sn = '2222'

How can these 2 SQLs be combined to return results for SQL2?
Currently I run SQL1 and take those results and plug into SQL2. Currently OK but could be better?
Thanks!