Re: Calling Stored Procedures with MS Access Pass-Through Queries

at's coming soon. I've had a lot of experience with Access and MS SQL Server, but I'm a MySql newbie. Do you have a favorite desktop front-end to MySql other than Access? I really appreciate your help and suggestions. >>> [EMAIL PROTECTED] 08/09/05 10:48AM >>> "

RE: Calling Stored Procedures with MS Access Pass-Through Queries

It might help if I mention my syntax is: call spTestingStuff(); From: Kent RobertsDate: August 9 2005 6:24pm Subject: Calling Stored Procedures with MS Access Pass-Through Queries Has anyone had experience with this yet? My attempts so far render = "ODBC--call failed". My connection is good an

Calling Stored Procedures with MS Access Pass-Through Queries

Has anyone had experience with this yet? My attempts so far render "ODBC--call failed". My connection is good and I can use select statements successfully, but no luck with calling an SP yet. I really want to call an SP with parameters, but I'm trying a simple one first. Also, anyone know of a f

Re: Stored Procedure, Dates, and Between

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

Re: Stored Procedure, Dates, and Between

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]

Re: Stored Procedure, Dates, and Between

of you for getting back to quickly! >>> 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 parameters. I've tried several permutations that all return 0 r

Stored Procedure, Dates, and Between

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 StartDateTime between '2005-04-01' and '2005-04-07' and returns over 300,000 ro

Re: Remote Connection Problem

Thanks Shawn. It seems to be just that. >>> [EMAIL PROTECTED] 08/08/05 03:02PM >>> "Kent Roberts" <[EMAIL PROTECTED]> wrote on 08/08/2005 04:50:15 PM: > I am having inconsistent behavior maintaining a remote connection > with MySql Administrator/Bro

Remote Connection Problem

and now I can't connect again. Any ideas? Thanks in advance, Kent Roberts Missoula, MT -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]