Re: Execute Error

2001-12-31 Thread Brent Cowgill
try $sdb-execute() Clinton Hesse wrote: It's funny, i can call method prepare on the database object but not execute, error on line 3. 1. my $query = SELECT UserID,Name FROM test; 2. my $sdb = $dbobj-prepare($query); 3. $dbobj-execute; where $dbobj is a reference to the database object I get

Re: Detecting OS through MySQL

2001-12-20 Thread Brent Cowgill
Thanks, I'll look for it in the future. Michael Widenius wrote: Hi! Brent == Brent Cowgill [EMAIL PROTECTED] writes: Brent Is there any way to detect the Operating System that a MySQL server is Brent running on Brent using SQL or DBI function calls only? Sorry no. But this is would

Detecting OS through MySQL

2001-12-18 Thread Brent Cowgill
Is there any way to detect the Operating System that a MySQL server is running on using SQL or DBI function calls only? -- Regards, Brent interactivetools.com, inc. Tel: (604)689-3347 - Fax: (604)689-3342 - Toll Free: 1(800)752-0455 Software for your Website - http://www.interactivetools.com/

Re: Circular replication

2001-12-12 Thread Brent Cowgill
even/odd is a little limiting, what happens down the road when another site needs to be added. A better method might be to use a unique session ID for each client site in combination with a generated sequence ID see the white paper at:http://www.ambysoft.com/persistenceLayer.html in particular