Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

ResultSet cannot seem to find aliased columns

 
Anthony Sykes
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In my stored procedure, I am returning a "derived" resultset similar to the following:

SELECT CASE WHEN @var1 IS NOT NULL THEN 1 ELSE 0 END columnVar1,
CASE WHEN @var2 IS NOT NULL THEN 1 ELSE 0 END columnVar2,
CASE WHEN @var3 IS NOT NULL THEN 1 ELSE 0 END columnVar3,
CASE WHEN @var4 IS NOT NULL THEN 1 ELSE 0 END columnVar4,
CASE WHEN @var5 IS NOT NULL THEN 1 ELSE 0 END columnVar5;

when I run the procedure from SqlYog I get the expected values .. however when I get the resultset after a call to the execute command, it only returns the first column, columnVar1. The rest are coming back null. It fails to work whether I use the AS keywork or not. Also, I am using the connector 5.1.6. Any help would be greatly appreciated.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic