creating a custom valuelist

Questions, tips and tricks and techniques for scripting in Servoy

creating a custom valuelist

Postby Harjo » Sat Jan 24, 2004 12:27 am

Let say I have a table: boekingen
with a field: datumvan (DATETIME)

let say I have 5 records

1-1-2003 18:23
1-2-2003 20:45
1-8-2003 21:56
1-3-2004 00:00
4-5-2005 12:00

Now, with this data, I want to create a valuelist (by doing a query) which is automatic filled with:
2003
2004
2005

Can someone help me with this?
Harjo
 
Posts: 4321
Joined: Fri Apr 25, 2003 11:42 pm
Location: DEN HAM OV, The Netherlands

Postby IT2Be » Sat Jan 24, 2004 11:07 am

"SELECT DISTINCT datumvan FROM boekingen" is the query. I presume you know the rest :D
Marcel J.G. Trapman (IT2BE)
SAN partner - Freelance Java and Servoy
Servoy Components - IT2BE Plug-ins and Beans for Servoy
ServoyForge - Open Source Components for Servoy
User avatar
IT2Be
Servoy Expert
 
Posts: 4766
Joined: Tue Oct 14, 2003 7:09 pm
Location: Germany


Return to Methods

Who is online

Users browsing this forum: No registered users and 1 guest