is this a valid sql statement ?

From: <javanewbie_at_my-deja.com>
Date: Wed, 03 Nov 1999 06:37:10 GMT
Message-ID: <7vol6n$9ao$1@nnrp1.deja.com>

String str1= "select d.state_name, count(*) from " +
" doctor_master d , foreign_worker_master f " +
" where f.doctor_code = d.doctor_code " +
" and (f.creation_date>TO_DATE('" + lbFromDateStart.getText()
+ "','DD/MM/YYYY') and " +
" f.creation_date<TO_DATE('"+lbFromDateStop.getText()
+"','DD/MM/YYYY') ) " +
" group by d.state_name ";

i got a program hanging when i try out the above statement.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 03 1999 - 00:37:10 CST