Find Jobs
Hire Freelancers

display resultset into listview

$10-30 USD

Completed
Posted about 8 years ago

$10-30 USD

Paid on delivery
Hello, i have a small amount of coding skills in android development but most of the time i can look at tutorials online and work around it too make it work my boss wants it too work. basically i have been trying for weeks to be able to get data from our oracle server to a list view and i have not had any success. i am able to retrieve the data fine as it just displays into a text field but it would look nicer if it was inside of a list view which i hope you can help me with. there is one problem i am not able to test to see if the code would work unless i am at work as it only works when you are on the local network. so to sum it all i got the data i need from the oracle server but i want too display it into a list view and not a text field. i know this may sound stupid too ask for probably something really simple here is a sample code i have. try { Statement stmt = null; String sql = null; stmt = [login to view URL](); sql = "Select c.client_name, c.client_code, p.product_id, p.scan_id, p.case_bar_code, p.prod_title, p.ean_upc_id" + "l.loc_code, l.product_qty, l.request_from_qty, l.request_in_qty" + " from clients c, products p, prod_locations l" + " where c.client_code=l.client_code" + " and p.client_code=l.client_code" + " and p.product_id=l.product_id" + " and (p.product_id = '" + [login to view URL]().toString() + "'" + " or p.scan_id = '" + [login to view URL]().toString() + "'" + " or p.case_bar_code = '" + [login to view URL]().toString() + "'" + " or p.prod_title like '%" + [login to view URL]().toString() + "%'" + " or p.ean_upc_id = '" + [login to view URL]().toString() + "')"; ResultSet rs = [login to view URL](sql); while ([login to view URL]()) { String client_name = [login to view URL](1); String client_code = [login to view URL](2); String product_id = [login to view URL](3); String scan_id = [login to view URL](4); String case_bar_code = [login to view URL](5); String prod_title = [login to view URL](6); String ean_upc_id = [login to view URL](7); String loc_code = [login to view URL](8); String product_qty = [login to view URL](9); String request_from_qty = [login to view URL](10); String request_in_qty = [login to view URL](11); [login to view URL]("Client: " + client_name + " | " + "Product ID: " + product_id + " | " + "Desc: " + prod_title + " | " + "LOC: " + loc_code + " | " + "QTY: " + product_qty + " | " + "Req In: " + request_in_qty + " | " + "Req Out: " + request_from_qty + "\n\n"); } [login to view URL](); } catch(Exception e) { Log.e("onCreate", "Error ", e); [login to view URL]("Error " + e); }
Project ID: 10368404

About the project

1 proposal
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hii, i can help you with your error, and this can take less than 1 hour, send me a msg to know more about it, have a good day!
$30 USD in 0 day
5.0 (4 reviews)
2.9
2.9
1 freelancer is bidding on average $30 USD for this job
User Avatar
I hope I can help u with ur task.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Pinetops, United States
5.0
3
Member since Apr 30, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.