problems with using GO

[PhilipJCaputo]

I have a query where I create a temp table, then I use the GO command to
execute the remainder of the query which accesses the temp table created....
then at the very end I have another GO and after that I drop my temp table.
(take a look at the example query)

when I copy and paste the query from the debug error message into SQL Query
Analyzer, the error message is repeated, however if in the query analyzer I put
a carriage return (press the enter key) before and after each GO, the query
runs without incident.

How does CFMX7 send queries to the SQL server? And or how can I force some
kind of carriage return character to be placed before and after each GO in my
query.

Example Query:

Select * from MyTable
Into #MyTempTable
Where something > 9 and Something < 20

GO

Insert Into ThisIsAnExistingTable ([FieldOne],[FieldTwo],[FieldThree])

Select FieldOne,FieldTwo,FieldThree
From #MyTempTable
Where FieldOne > 9

Union

Select FieldOne,FieldTwo,FieldThree
From #MyTempTable
Where FieldOne < 5

GO

Drop table #MyTempTable

[mxstu]

I don't think the keyword GO is in the JDBC standards. Try using a semi-colon
at the end of each statement:

Select * from MyTable
Into #MyTempTable
Where something > 9 and Something < 20; <--- semi-colon at end of sql
statement

Insert Into ThisIsAnExistingTable ([FieldOne],[FieldTwo],[FieldThree])

Select FieldOne,FieldTwo,FieldThree
From #MyTempTable
Where FieldOne > 9

Union

Select FieldOne,FieldTwo,FieldThree
From #MyTempTable
Where FieldOne < 5 ; <--- semi-colon at end of sql statement

... etc ..

[PhilipJCaputo]

Amazing what a little semi-colon can do!

thanks for the quick fix, it was spot on!

(back to the code)