Find Jobs
Hire Freelancers

display resultset into listview

$10-30 USD

完了済み
投稿日: 8年近く前

$10-30 USD

完了時にお支払い
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); }
プロジェクト ID: 10368404

プロジェクトについて

1個の提案
リモートプロジェクト
アクティブ 8年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
アワード者:
ユーザーアバター
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 0日以内
5.0 (4 レビュー)
2.9
2.9
この仕事に1人のフリーランサーが、平均$30 USDで入札しています
ユーザーアバター
I hope I can help u with ur task.
$25 USD 1日以内
0.0 (0 レビュー)
0.0
0.0

クライアントについて

UNITED STATESのフラグ
Pinetops, United States
5.0
3
メンバー登録日:4月 30, 2016

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。