Re: SQL_CALC_FOUND_ROWS using ODBC driver

2007-02-16 Thread Nuno Vaz Oliveira
Nils Meyer wrote: SELECT SQL_CALC_FOUND_ROWS doesn't make much sense without a where clause by the way. LIMIT, not where. Thanks for the reply... That seems to make sense. I'm talking about the part of one record being returned containing a field with the number of records. About the LIMI

Re: Visual Basic 6 + MySQL

2007-01-21 Thread Nuno Vaz Oliveira
Just FYI: you can get the "Express" version of the VB.Net portion of Visual Studio for free: http://msdn.microsoft.com/vstudio/express/default.aspx That way, you're much more likely to have a fully supported app. I've not tried running VB6 apps on Vista. :) I wasn't able to find the EULA for t

Re: Visual Basic 6 + MySQL

2007-01-21 Thread Nuno Vaz Oliveira
Hello John, All the links visible on the site are workink. I should have explained myself better... There are other articles that used to be there that are missing like the sshtunnel tutorial which used to be at: http://www.vbmysql.com/articles/sshtunnel.html and other links that teached to co

Re: Visual Basic 6 + MySQL

2007-01-21 Thread Nuno Vaz Oliveira
Hello John, Anybody in here think of http://www.vbmysql.com? The site is not working correctly :( I've found a lot of references to that site but the articles are all missing. Thanks anyway ;) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Visual Basic 6 + MySQL

2007-01-21 Thread Nuno Vaz Oliveira
Hello Miles, At 04:39 PM 1/19/2007, Nuno Vaz Oliveira wrote: Why VB6? This isn't an anti-Microsoft position, but that language has been left to die on the vine. So I'd think about .NET, or RealBASIC, or ... or You will have to decide. Why VB6? That is an easy one. First, it&#x

Visual Basic 6 + MySQL

2007-01-19 Thread Nuno Vaz Oliveira
Hello! I'm thinking to develop a database interface for our company and I thought "great" when I discovered that Visual Basic 6 was able to interact with MySQL. That's because VB6 is very easy and PHP (even being fast, but its hard for me) gets slower because the source code for HTML pages ne

Re: Connecting from a remote computer

2007-01-18 Thread Nuno Vaz Oliveira
Hi All, This is a dump and simple question but I can't seem to get it to work. How do I enable a user to be able to connect from a remost host using MySQL Administrator? I added "%" but once signed in, I still can't access the user panel in the administrator. Thanks. Kay I don't know if I can

RE: SELECT from 3 tables - Need help

2007-01-18 Thread Nuno Vaz Oliveira
From Chris, Do you mean that I should replace SELECT * FROM with SELECT field1, [field2],[...] FROM? Yes. If so, I need to specify the table name like SELECT Clients.Name correct? You only need to do that when 2 tables have the same column name. In general, though, it's good practice to al

Re: SELECT from 3 tables - Need help

2007-01-18 Thread Nuno Vaz Oliveira
From Davor: Try this: SELECT * FROM `Quotes` LEFT OUTER JOIN `Products` ON (`Products`.`QuoteID`=`Quotes`.`QuoteID`) LEFT OUTER JOIN `Clientes` ON (`Clientes`.`ClientID`=`Quotes`.`ClientID`) WHERE `Quotes`.`QuoteID`=6936 Dundo Still the same... :( When a QuoteID from Quotes is not available