Re: Trying to Generate Dynamic Sequence IDs as Stored Function or Stored Procedure.

2011-01-05 Thread James Dekker
, James On Jan 5, 2011, at 10:01 AM, Shawn Green (MySQL) wrote: > On 1/4/2011 23:23, James Dekker wrote: >> Peter, >> >> Thanks for the response! >> >> Unfortunately, that worked but a new error arose: >> >> check the manual that corresponds to your

Re: Trying to Generate Dynamic Sequence IDs as Stored Function or Stored Procedure.

2011-01-04 Thread James Dekker
Should be: > > CALL generate_dynamic_id('my_sequence_id_s', 'my_table_t', 'table_id', > @dynamicId); > > PB > > > > On 1/4/2011 9:28 PM, James Dekker wrote: >> Hello there, >> >> I am using MySQL 5 on OS X - Snow Leopard... >

Trying to Generate Dynamic Sequence IDs as Stored Function or Stored Procedure.

2011-01-04 Thread James Dekker
Hello there, I am using MySQL 5 on OS X - Snow Leopard... Have working code in place which obtains the highest sequence number ID from a sequence table and then increments and assigns it to its corresponding table: The original code's purpose is to dynamically increments a specific table's las

Re: Unable to Login to MySQL 5

2009-10-14 Thread James Dekker
you just set the password for r...@localhost. you don't need to grant anything to root, usually. cheers Claudio On Oct 14, 2009 9:07 PM, "James Dekker" wrote: Hello there, I have been using MySQL 5 on my OS X Leopard based laptop for quite some time now... Didn't h

Re: Unable to Login to MySQL 5

2009-10-14 Thread James Dekker
you don't need to grant anything to root, usually. cheers Claudio On Oct 14, 2009 9:07 PM, "James Dekker" wrote: Hello there, I have been using MySQL 5 on my OS X Leopard based laptop for quite some time now... Didn't have a password set and my login was "root&q

Unable to Login to MySQL 5

2009-10-14 Thread James Dekker
Hello there, I have been using MySQL 5 on my OS X Leopard based laptop for quite some time now... Didn't have a password set and my login was "root" on localhost. Downloaded just now the Spring distribution was following the steps to run the petclinic sample application. Ran the followin