RE: Using BYTEFX to connect to MySql , closing connection do not release the connection.

2004-04-07 Thread tweewan.wong
/mysqlclient/MySqlPoolManager. cs?rev=1.4 it has been great help! :-)TweeWan -Original Message- From: Reggie Burnett [mailto:[EMAIL PROTECTED] Sent: 08 April 2004 22:23 To: 'tweewan.wong'; [EMAIL PROTECTED] Subject: RE: Using BYTEFX to connect to MySql , closing connection do n

RE: Using BYTEFX to connect to MySql , closing connection do not release the connection.

2004-04-07 Thread tweewan.wong
les Button1.Click Dim frm As frm_single frm = New frm_single frm.Show() End Sub I press button1 in frmA, when frmB shows up, I close frmB, I press button1 again in frmA and I get the following error: Pooling exception: Unable to find original pool for connection Regards Twee

Using BYTEFX to connect to MySql , closing connection do not release the connection.

2004-04-07 Thread tweewan.wong
Hi, Encounter an interesting here using VB.NET with ByteFx.mysql.mysqlclient to connect to Mysql Database. I have a sub-form (called from another main form) with 4 mysqlconnections declared and new. X1= new mysqlconnection X1.connectionstring = X1.open() X2= new mysqlconnection X2.connections

RE: Selecting a Column

2004-03-23 Thread tweewan.wong
Not sure why you don't get "Tuesday". At my place ( I am using 5.1 beta version). It did return "Tuesday" for this statement SELECT DAYNAME('2004-03-23'). Anyway, I can get similar output by using select date_format('2004-3-23','%W'). -Original Message- From: Ligaya Turmelle [mailto:[

RE: Strings and variables in select statements

2004-03-23 Thread tweewan.wong
To date, my understanding is that mysql do not support sub-query. My suggestion will be by using 2 sql statement. The first statement will select value from the reference table. The value retrieve from first statement can be used to construct the second statement. Your first sql will be like :