search

loiclacombe / mybatisnet

Automatically exported from code.google.com/p/mybatisnet
0 stars 0 forks source link

How to get Table Columns using ibatis #48

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
     SELECT COLUMN_NAME  AS AttributeName
              FROM INFORMATION_SCHEMA.COLUMNS    
             WHERE TABLE_NAME= 'DataTable' AND COLUMN_NAME IN ('Slot' +'1')

Please help me..

Original issue reported on code.google.com by msekhar...@gmail.com on 5 Jun 2013 at 11:39

GoogleCodeExporter commented 9 years ago 
plz help

Original comment by msekhar...@gmail.com on 5 Jun 2013 at 11:39

GoogleCodeExporter commented 9 years ago 
Its solved by me..  
SELECT COLUMN_NAME  AS AttributeName
      FROM INFORMATION_SCHEMA.COLUMNS
      WHERE TABLE_NAME ='DataTable' and COLUMN_NAME IN
      <iterate open="(" close=")" conjunction=",">
        #[].FieldPosition#
      </iterate>

Original comment by msekhar...@gmail.com on 6 Jun 2013 at 1:54