Re: Create Temporary Table problem
> > Further to this, I should point out everything works fine in mysql-front > > or at the mysql console. > > > > The problem shows up when using mysql++, a BadQuery exception is thrown. > > > > query.reset(); > > query << "CREATE TEMPORARY TABLE " << sTemporary << " TYPE=HEAP > > MAX_ROWS=1 " << subselect; > > > > try > > { > > query.parse(); > > query.execute(); > > } > > > > This is simple to solve. > > As recommended in MySQL++ manual, use stream only for queries returning result set. For the queries like above use exec() method. Point taken, changed it to just use exec() and the same problem occurs. It was working previously with the code above though (mysql 3), and it works fine entered at the mysql console. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Create Temporary Table problem
Further to this, I should point out everything works fine in mysql-front or at the mysql console. The problem shows up when using mysql++, a BadQuery exception is thrown. query.reset(); query << "CREATE TEMPORARY TABLE " << sTemporary << " TYPE=HEAP MAX_ROWS=1 " << subselect; try { query.parse(); query.execute(); } - Original Message - From: "Phil Bitis" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 09, 2003 12:41 PM Subject: Create Temporary Table problem > As a way of getting around the lack of subselect (I'm aware this is coming > soon) we're parsing sql queries, running subselects and storing their > results in a temporary table and replacing the subselect in the sql with the > temporary table name. > > This has been working fine, but on upgrading to v4.0.13 the "CREATE > TEMPORARY TABLE " part is failing with this error: > > Access denied for user: '@localhost' to database 'uclan_database' > > Any ideas? > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Create Temporary Table problem
As a way of getting around the lack of subselect (I'm aware this is coming soon) we're parsing sql queries, running subselects and storing their results in a temporary table and replacing the subselect in the sql with the temporary table name. This has been working fine, but on upgrading to v4.0.13 the "CREATE TEMPORARY TABLE " part is failing with this error: Access denied for user: '@localhost' to database 'uclan_database' Any ideas? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]