FAQ  •  Search  •  Memberlist  •  Usergroups   •  Register  •  Profile  •  Log in to check your private messages  •  Log in

won't display data when running several blocks

 
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Advenio Support Forum Index -> SQLGrinder Discussion
View previous topic :: View next topic  
Author Message
jsalazar



Joined: 28 Jun 2007
Posts: 1

PostPosted: Thu Jun 28, 2007 6:17 pm    Post subject: won't display data when running several blocks Reply with quote

Hello, I am running two queries in a single editor window. When i do this is Aquastudio i get both results in the same page, but when i try to do in SQLGrinder i get an error message. For example;

select * from cdr where duration = 0 limit 2

select * from cdr where duration = 60 limit 3

gives an error that says "ERROR: syntax error at or near 'select'

when i add the seperator ";" it runs both queries but displays them in different windows.

select * from cdr where duration = 0 limit 2;

select * from cdr where duration = 60 limit 3

I would like to see them in the same window is there any way to do this?

I appreciate any help anyone can give me on this issue.

Thanks!
Back to top
View user's profile Send private message
michaeldupuis
Site Admin


Joined: 15 May 2003
Posts: 1427
Location: Lewiston, ME

PostPosted: Tue Jul 03, 2007 12:51 pm    Post subject: Reply with quote

Sorry for the delay in responding. Putting a ";" at the end of each statement would be my suggestion, which I guess you've done, but I don't understand how you are getting the results in more than window. More than one result set should be displayed in the result set drawer, which you can open from the "View" menu.
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Advenio Support Forum Index -> SQLGrinder Discussion All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2002 phpBB Group