| View previous topic :: View next topic |
| Author |
Message |
jsalazar
Joined: 28 Jun 2007 Posts: 1
|
Posted: Thu Jun 28, 2007 6:17 pm Post subject: won't display data when running several blocks |
|
|
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 |
|
 |
michaeldupuis Site Admin
Joined: 15 May 2003 Posts: 1427 Location: Lewiston, ME
|
Posted: Tue Jul 03, 2007 12:51 pm Post subject: |
|
|
| 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 |
|
 |
|