Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

get particular column data from result set #592

Closed
calvinrajat opened this issue Jan 18, 2017 · 1 comment
Closed

get particular column data from result set #592

calvinrajat opened this issue Jan 18, 2017 · 1 comment
Labels

Comments

@calvinrajat
Copy link

calvinrajat commented Jan 18, 2017

I am getting a the following dbResponse with resultSet as "true" :

dBResponse { rows: undefined,
resultSet:
{ metaData:
[ [Object],
[Object],
[Object],
[Object],
[Object] ] },
outBinds: undefined,
rowsAffected: undefined,
metaData:
[ { name: 'ID' },
{ name: 'CD1' },
{ name: 'CD2' },
{ name: 'CD3' },
{ name: 'CD4' } ] }

is there a way to get data of CD1 column only from the resultSet ?
I dont want the complete data from the resultSet using fetchRowsFromRS method.

@cjbj
Copy link
Member

cjbj commented Jan 18, 2017

In the SELECT statement, include only the columns you want. And use a WHERE clause. Then choose whether to use execute() with or without a ResultSet, or use queryStream(). Note #158 is still open.

@cjbj cjbj added the question label Jan 18, 2017
@cjbj cjbj closed this as completed Feb 4, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants