turkoglu98 Posted February 11, 2012 Share Posted February 11, 2012 arkadaşlar ben sqlite3 deki veriyi listbox'a yazdırdım ama alfabe sırasına göre yazdırmıyor nasıl yapabilirim? Quote Link to comment Share on other sites More sharing options...
KintaRo Posted February 11, 2012 Share Posted February 11, 2012 [code]db, err = SQLite3Connection:execute:("SELECT * FROM tablo_ismi WHERE id='3' ORDER BY ASC")[/code] derseniz alfabetic sıraya yani A-Z şeklinde alır veriyi. [code]db, err = SQLite3Connection:execute:("SELECT * FROM tablo_ismi WHERE id='3' ORDER BY DESC")[/code] şeklinde alırsanız, Z-A sıralamasında alır. Quote Link to comment Share on other sites More sharing options...
turkoglu98 Posted February 11, 2012 Author Share Posted February 11, 2012 yanlız benim kodlar şöyle: SQLite3Cursor, err = SQLite3Connection:execute("SELECT * FROM user"); satir, err = SQLite3Cursor:fetch({}, "a"); while satir do cKullanici = Crypto.BlowfishDecryptString(satir.user, anahtar) result = ListBox.AddItem("ListBox1", cKullanici,""); satir, err = SQLite3Cursor:fetch({}, "a"); end ben kodu şöylemi değiştiricem SQLite3Cursor, err = SQLite3Connection:execute("SELECT * FROM user ORDER BY ASC"); Quote Link to comment Share on other sites More sharing options...
KintaRo Posted February 11, 2012 Share Posted February 11, 2012 [quote]SQLite3Cursor, err = SQLite3Connection:execute("SELECT * FROM user");[/quote] bu satiri [quote]SQLite3Cursor, err = SQLite3Connection:execute("SELECT * FROM user ORDER BY ASC");[/quote] şeklinde düzenlesen yeterli. Edit: evet aynı şeyden bahsediyormuşuz Quote Link to comment Share on other sites More sharing options...
turkoglu98 Posted February 11, 2012 Author Share Posted February 11, 2012 e hata veriyor Quote Link to comment Share on other sites More sharing options...
KintaRo Posted February 11, 2012 Share Posted February 11, 2012 hata verir çünkü eksik yazmışım, galetis uyardı sağolsun. [code]SQLite3Cursor, err = SQLite3Connection:execute("SELECT * FROM user ORDER BY sutun_ismi ASC");[/code] olmasi gerekiyor. Sutün ismine göre veriyi çekmek lazım bu durumda Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.