🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.jbuilder.database
Article #172

Re: picklist will not populate from database

#172
From: Peter Wetjens
Date: Sat, 22 Apr 2006 08:16
52 lines
3265 bytes
Sorry, see below

database1.setConnection(new ConnectionDescriptor(
                "jdbc:mysql://10.0.0.199:3306/rooster", "user", "password", 
false,
                "com.mysql.jdbc.Driver"));
        jdbTable1.setDataSet(queryDataSet1);
        jdbStatusLabel1.setText("jdbStatusLabel1");
        dBDisposeMonitor1.setDataAwareComponentContainer(this);
        queryDataSet1.setQuery(new 
com.borland.dx.sql.dataset.QueryDescriptor(
                database1, "SELECT * FROM USER", null, true, Load.ALL));
        queryDataSet2.setQuery(new QueryDescriptor(database1,
                "SELECT TEMPLATE_NAME FROM TEMPLATE", null, true, 
Load.ALL));
        column1.setColumnName("USER_TEMPLATE");
        column1.setDataType(com.borland.dx.dataset.Variant.STRING);
        column1.setPickList(new com.borland.dx.dataset.PickListDescriptor(
                queryDataSet2, new String[] {"TEMPLATE_NAME"},
                new String[] {"TEMPLATE_NAME"},
                new String[] {"USER_TEMPLATE"}, null, false));
        column1.setPrecision(30);
        column1.setTableName("USER");
        column1.setServerColumnName("USER_TEMPLATE");
        column1.setSqlType(12);
        contentPane.add(jdbStatusLabel1, java.awt.BorderLayout.SOUTH);
        contentPane.add(jdbNavToolBar1, java.awt.BorderLayout.NORTH);
        contentPane.add(jScrollPane1, java.awt.BorderLayout.CENTER);
        jScrollPane1.getViewport().add(jdbTable1, null);
        queryDataSet1.setColumns(new Column[] {column1});

"Kevin Dean [TeamB]" <NkOdSePaAnM@datadevelopment.com> schreef in bericht 
news:xn0el8ypl3m92t000-kdean@www.teamb.com...
> Peter Wetjens wrote:
>
>>Below I included my code, because I don't understand your question. My
>>guess, the answer is "yes".
>
> There's no code in your post.
>
> -- 
> Kevin Dean [TeamB]
> Dolphin Data Development Ltd.
> http://www.datadevelopment.com/
>
> NEW WHITEPAPERS
> Team Development with JBuilder and Borland Enterprise Server
> Securing Borland Enterprise Server
> http://www.datadevelopment.com/papers/index.html
>
> Please see Borland's newsgroup guidelines at
> http://info.borland.com/newsgroups/guide.html 
Technical Details
Message-ID: <4449e667$0$3655$ba620dc5@nova.planet.nl>
Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!news4.google.com!news.glorb.com!feeder.enertel.nl!nntpfeed-01.ops.asmr-01.energis-idc.net!newsfeeder.wxs.nl!divide.nova.planet.nl!posting.nova.planet.nl!not-for-mail
References: <44468e94$1@newsgroups.borland.com> <xn0el7k2whrik001-kdean@www.teamb.com> <444902b7@newsgroups.borland.com> <xn0el8ypl3m92t000-kdean@www.teamb.com>

Show Full Headers
Complete Article Headers
X-Google-Thread: 1073da,31f881c625ff6d88
X-Google-Attributes: gid1073da,public
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!news4.google.com!news.glorb.com!feeder.enertel.nl!nntpfeed-01.ops.asmr-01.energis-idc.net!newsfeeder.wxs.nl!divide.nova.planet.nl!posting.nova.planet.nl!not-for-mail
From: "Peter Wetjens" <peterwetjens@planet.nl>
Newsgroups: borland.public.jbuilder.database
References: <44468e94$1@newsgroups.borland.com> <xn0el7k2whrik001-kdean@www.teamb.com> <444902b7@newsgroups.borland.com> <xn0el8ypl3m92t000-kdean@www.teamb.com>
Subject: Re: picklist will not populate from database
Date: Sat, 22 Apr 2006 10:16:29 +0200
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Response
Lines: 54
Message-ID: <4449e667$0$3655$ba620dc5@nova.planet.nl>
NNTP-Posting-Host: 80.61.249.52
X-Trace: 1145693799 nova.planet.nl 3655 80.61.249.52:35764
X-Complaints-To: abuse@planet.nl