Kamu coba loop. ...
tgl wal = ....
tgl akhir=....
for i= tgl awal to tgl akhir
koneksinya.execute "insert into tablenya values('HASAN',format(i,"yyyy-mm-dd"),'SAKIT', 8 )"
next
kurang lebih seperti itu...
Salam
Ronald Irawan
Pt. Sanghiang Perkasa
Gd. Graha Kirana Lt.5
Jl Yos Sudarso Kav.88
Jakarta
| Asral Sukma <[EMAIL PROTECTED]>
Sent by: [email protected] 20/02/2006 01:05 PM
|
|
kalo pake distinct jadi solusi ga ya..
soalnya,kalo data nya bener2 sama,kan di distinct jadi
1 row data aja..baru di insert..
mudah2han membantu
--aL--
--- extravaganza mania <[EMAIL PROTECTED]>
wrote:
> Salam kenal,
>
> Ada yang tau bagaimana query/command agar bisa
> memasukkan transaksi secara
> periode? Dalam arti tgl 20 Feb 06 s/d. tgl 24 Feb 06
> cukup di entry 1x kali
> saja bila transaksi dan jumlah jam sama? Contoh:
>
> ID TGL TRANSAKSI JAM
> KET
> HASAN 20/02/2006 SAKIT 8
> -
> HASAN 21/02/2006 SAKIT 8
> -
> HASAN 22/02/2006 SAKIT 8
> -
> HASAN 23/02/2006 SAKIT 8
> -
> HASAN 24/02/2006 SAKIT 8
> -
>
> Mohon bantuan dari teman-teman milis sekalian.
> Terima kasih.
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Programmer-VB/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
SPONSORED LINKS
| Programmer | Indonesia | Basic programming language |
| Computer programming languages | Programming languages | Java programming language |
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
