Now that I think about it, if MySql forced declaration of session
variables it
would avoid some nasty bugs in SPs.
>>> Mark Matthews 08/09/05 08:46AM >>>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Kent Roberts wrote:
> I have a simple SP that is selecting rows based on a date range using
param
Sorry, I'll try and proof reed more karefullly in the futchure. :-)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
That's it. Thanks Mark. I think I was confusinged by MS SQL Server
syntax
which prefixes both session variables and parameters with @. And you're
right
Scott, I changed the name of the SP for posting simplicity and forgot to
change the colling statement to match. Thanks a lot both of you for
gettin
"Kent Roberts" <[EMAIL PROTECTED]> wrote on 08/09/2005 10:42:24 AM:
> I have a simple SP that is selecting rows based on a date range
> using parameters. I've tried several permutations that all return 0
rows.
>
> The select statement looks like this:
>
> select * from 'mit_log'.'mitlog' where
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Kent Roberts wrote:
> I have a simple SP that is selecting rows based on a date range using
> parameters. I've tried several permutations that all return 0 rows.
>
> The select statement looks like this:
>
> select * from 'mit_log'.'mitlog' where St
