Did you try to escape the # using ##? Niels
-----Original Message----- From: Bing Qiao [mailto:[EMAIL PROTECTED] Sent: dinsdag 2 augustus 2005 11:26 To: user-java@ibatis.apache.org Subject: Temporary table causing problems? This problem seems to only exist after 2.0.9b.550 I use queryForList to retrieve dataset from a stored procedure. Everything gos well except I can't use temporary table when using the 2.1 version of ibatis. Code like the follows will cause trouble: select top 10 * into #payments from paymenttable ... select * from #payments ... drop table #payments Everything is alright for 2.0.9b.550 and 2.0.9.496.