I am getting the attached error message when trying to use Query Database smart

erickp over 9 years ago

I am getting the attached error message when trying to use Query Database smart service. I am doing a simple select statement: "select univ_name from University where univ_id = 1. (It is my first time using Query Database smart service and I am just trying to execute a simple scenario so ignore how simple the query is and the fact I am using univ_id = 1) I have a CDT called University with both fields univ_id and univ_name. What does the attached error message means? Also, how would I go ahead if I wanted to store the returned univ_name in a process variable? Would I create an output? If yes, how do I tell that output that I want to store the SQL response in my process variable?

Discussion posts and replies are publicly visible

Parents

0 erickp over 9 years ago

That is not the problem. I am using MySQL. The type Text is of the CDT. At this point in time, don't have access to MySQL database. As soon as I get access, I will let you know. (The link you posted above I have seeing already and have the data types in mind)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 erickp over 9 years ago

That is not the problem. I am using MySQL. The type Text is of the CDT. At this point in time, don't have access to MySQL database. As soon as I get access, I will let you know. (The link you posted above I have seeing already and have the data types in mind)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data