Rhino,
Sorry about that. I'm running 5.0.15. I'll explore the
prepared statement angle.
Cheers,
Tripp
--- Rhino <[EMAIL PROTECTED]> wrote:
>
> - Original Message -
> From: "Tripp Bishop" <[EMAIL PROTECTED]>
> To:
> Sent: Monday, D
- Original Message -
From: "Tripp Bishop" <[EMAIL PROTECTED]>
To:
Sent: Monday, December 19, 2005 3:45 PM
Subject: Re: Declare Cursor Question
Howdy all,
I've got a question about declaring cursors. In
particular is there a way to allow the select
statement
Howdy all,
I've got a question about declaring cursors. In
particular is there a way to allow the select
statement used to populate the cursor be variable?
I've tried a couple of the obvious approaches with no
luck. Failing that, is there a way to have a cursor be
an input parameter to a stored pr
Hello.
Surround your code inside the IF statement with BEGIN...END. For example
this works for me:
drop procedure if exists testcursor;
DELIMITER //
CREATE PROCEDURE testcursor(IN city_name varchar(255))
DETERMINISTIC
BEGIN
declare tval int;
IF (INSTR(city_name, ',') > 0) THEN
begin
