SELECT in a stored procedure must have INTO (#1282)

[Daniel Kasak]

This is a repost of sorts...

I have a simple stored procedure in MySQL-5.0 from the bk tree:

create procedure sp_BillingByID(input_BillID int)
select * from Billing where BillID=input_ID
When I use the mysql console, and type:

call sp_BillingByBillID(4000)

I get the rows I expect - those with BillID=4000.
However when I use MS Access, and set up a pass-through query with the 
exact same text:

call sp_BillingByBillID(4000)

I get an error dialog box:

[MySQL][ODBC-3.51 Driver][mysqld-5.0.0-alpha]SELECT in a stored 
procedure must have INTO (#1282)

If I'm interpreting this error correctly, it's insisting that I select 
into another table - *but* it works from the console. I would really 
like to be able to use stored procedures this way, because it makes 
porting our SQL Server database *much* easier. We have a large list of 
stored procedures that are basically select statements with 1 or 2 input 
variables. Am I going to be able to do this?

Thanks!

Dan

--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]