MySql Query not returning any data

[Anonymous]

Hello All, I did tried to load the data from mysql using yMySqlRow component.

Query:-

"SELECT
`table`.`empID`,
`table`.`fromDate`,
`table`.`toDate`,
TIME_FORMAT(STR_TO_DATE(`table`.`fromTime`, '%H%i'), '%h:%i %p'),
`table`.`toTime`
FROM `table`"

here fromTime column values are in hh:mm am/pm(ex: 9:00 am) varchar data type.

So while loading the data i was trying to change the column data type into time(HH:MMS AM/PM)

But it is not returning any data. 

Output:-

||||
[statistics] disconnected

 i did tried the another way also of sql query.

"SELECT
`table`.`empID`,
`table`.`fromDate`,
`table`.`toDate`,
CAST(`table`.`fromTime`, '%H%i'),
`table`.`toTime`
FROM `table`"

strill returing the same output.

Any help please.

Mohan V.

[vapukov]

Hi,

tMySQLRow does not return the data unless you do not use additional components

just use tDBInput for input

[Anonymous]

@vapukov  thanks for the reply.

Yes i did used the tDBinput and connected to tMySqlRow.

then when i tried to execute this i was not able to get any output.

can you please help me.