Hi, I am running a SQL query in my process but its not working. I am

nitas811 over 12 years ago

Hi,

I am running a SQL query in my process but its not working. I am doing a simple query, select <columnnames> from tablename where fieldname = "", however its even returning records that do not have the column set to blank. In mysql the same query is working. Seems like a bug in appian what is the workaround for this? ...

Discussion posts and replies are publicly visible

Parents

0 akhilan over 12 years ago

I tested out a similar query on Appian 7.1 which uses MySQL as the DB from a Query DB node and it worked perfectly fine. The column I used in my where clause was a varchar field in the DB. What type of field are you checking for?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 akhilan over 12 years ago

I tested out a similar query on Appian 7.1 which uses MySQL as the DB from a Query DB node and it worked perfectly fine. The column I used in my where clause was a varchar field in the DB. What type of field are you checking for?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data