Senin, 28 Oktober 2013

PHP Indonesia - Facebook: ada yang pernah nyoba jeasyUI untuk sql server, ka...

PHP Indonesia - Facebook
PHP Indonesia is a community for everyone that loves PHP. Our focus is in the PHP world but our topics encompass the entire LAMP stack. Topics include PHP coding, to memcached handling, db optimizations, server stack, web server tuning, code deploying, hosting options and much much more. Youtube Channel : http://www.youtube.com/user/OurPHPIndonesia Twitter : @php_indonesia NOTE: Rules for Wall posting: https://www.facebook.com/groups/35688476100/doc/10151597056316101/ Daftar Keanggotaan : http://www.facebook.com/groups/35688476100/doc/10150671770741101/ 
Book your hotel early for a discount!

You can reap the rewards with great discounts at participating Pullman, M Gallery, Grand Mercure, Novotel, Mercure, ibis and Formule 1 hotels.
From our sponsors
ada yang pernah nyoba jeasyUI untuk sql server, ka...
Oct 28th 2013, 08:24, by Ferdi Pong Pong

Ferdi Pong Pong 8:24am Oct 28
ada yang pernah nyoba jeasyUI untuk sql server,
karena begitu di retrive, kan perlu limit..

nah limitnya jadi saya beginiin:

SET ROWCOUNT $offset SELECT TOP $rows *
FROM tampunguser
where active ='0' ORDER BY USERID DESC

namun ketika ke page selanjutnya,
datanya akan berulang sama seperti data yang di page 1

Ferdi Pong Pong 8:30am Oct 28
SOLVED

queryny jadi begini:
SELECT TOP $rows * FROM tampunguser WHERE USERID NOT IN (SELECT TOP $offset USERID FROM tampunguser where active='0') and active='0'

You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions

Tidak ada komentar:

Posting Komentar