Tema: Re: Mysql select'as
Autorius: cinic
Data: 2012-01-19 16:25:03
Dinamiškai generuoti SQL ne sprendimas?

int cc = rs.getMetaData().getColumnCount();
for ( i = 1 ; i <= cc  ; i++){
    if ( contains( rs.getMetaData().getColumnName(i), "A" ) ) {
        fields = fields +  rs.getMetaData().getColumnName(i);
        if (i < cc) { fields = fields + ","};
    }
   }
sql = 'select '+fields +'from lentute


"Eek"  wrote in message news:jf3lj0$sm9$1@trimpas.omnitel.net...

Sveiki,
yra lentute: Data, A1, A2.... AX, B1, B2....BX, C1, C2...CX

reikia pasiselectinti duomenis tarkim is visu A stulpeliu, arba B arba
C. Stulpeliu skaicius is anksto nera zinomas.

select %A% from lentute; ??? Google kazkaip neradau jokio pavyzdzio...

Dekui!