: SQL_CALC_FOUND_ROWS using ODBC driver
Hi,
I've used PHP with MySQL and I was able to count the rows of a table by
using the following code:
SELECT SQL_CALC_FOUND_ROWS * FROM MyTableName; SELECT FOUND_ROWS();
However, I would like to do the same thing using Visual Basic 6...
When I set the RS.Source t
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
On Thu, Feb 15, 2007 at 01:04:26AM +, Nuno Oliveira wrote:
> Hi,
>
> I've used PHP with MySQL and I was able to count the rows of a table by
> using the following code:
>
> SELECT SQL_CALC_FOUND_ROWS * FROM MyTableName;
> SELECT FOUND_ROWS();
>
> However, I would like to do the same thing u
Nils Meyer wrote:
> SELECT
SQL_CALC_FOUND_ROWS doesn't make much sense without a where clause by
the way.
LIMIT, not where.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
Nuno Oliveira wrote:
When I set the RS.Source to the first SELECT statement and open it, it
run OK but I need to close the RS and open it again using the second
SELECT statement.
After any of this operations I get a Recordset->RecordsCount = 1
That is actually a correct figure, SELECT F
Hi,
I've used PHP with MySQL and I was able to count the rows of a table by
using the following code:
SELECT SQL_CALC_FOUND_ROWS * FROM MyTableName;
SELECT FOUND_ROWS();
However, I would like to do the same thing using Visual Basic 6...
When I set the RS.Source to the first SELECT statement
it was reopened, max
OSX and other applications are not effected etc. etc."
its version : 3.51.11-1
so this ODBC driver will not work on the 10.4 machine? as right next to the
download it states OSX v10.3
(installing on 10.3 works no problem)
Sorry, I can't help here, but noted t
OSX and other applications are not effected etc. etc."
its version : 3.51.11-1
so this ODBC driver will not work on the 10.4 machine? as right next to the
download it states OSX v10.3
(installing on 10.3 works no problem)
many thanks
Andrew
Pako,
That blows my theory.
Regards,
Adam
-Original Message-
From: Pakó Géza [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 2:32 PM
To: Fortuno, Adam
Subject: Re: Error: "unable to execute query" - Problems using Win32 MySQL
ODBC driver
i dont use odbc. i
).
You're getting the same issue going from Win32 to Linux via ODBC. I wonder
if its a bug with the ODBC driver? What version are you using?
Anyone else have this problem?
Regards,
Adam
-Original Message-
From: Pakó Géza [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 2:22
Gustavo,
At this moment this is the only way I know how to remove the old ODBC
driver. Run regedit go to "My
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI".
Find the folder with the old MySQL driver name (most likely just MySQL).
Open up that folder and you should see a co
I want to remove the old 2.50 myodbc driver. I installed a new version
of myodbc, and the old driver is still being diplayed in the list...
I know this is not really a mysql problem, but I'm not much of a windows
user and google didn't return good results this time... maybe someone
here could gi
On Friday 24 January 2003 01:29, Jeffrey Powell wrote:
> I am preparing to migrate a client from using a large MS-ACCESS database to
> using a linux hosted MySql as the datasource. Or at least I'd like to be
> able to export tables as a backup.
>
> Please tell me where I can get a driver.
Take a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I am preparing to migrate a client from using a large MS-ACCESS database to
using a linux hosted MySql as the datasource. Or at least I'd like to be able
to export tables as a backup.
Please tell me where I can get a driver.
Thanks,
- --
Jeff Powe
SQL
ASP
I can't seem to find any examples of saving text area form inputs to TEXT
type fields.
They all seem to be text inputs or strings being saved to varchar fields...
Can someone point me to an example of saving large text quantities to a TEXT
Type field in ASP?
Thanks
Alan McDonald
http://www
Hello,
I m using WinXP / Office XP and need odbc support to create a circular
letter.
I have installed mysql, etc. all works fine.
But I cant get Word to work with odbc drivers. They seem to work, they
get connection
To my database but word says something like this :
"couldn't obtain table lists
Well, not really a problem, I guess... but when I
run a python program that makes use of it I get the
following "message" per row I process...
Freeing pointer out of range at line 663, 'C:\49\libmysql\libmysql.c'
Should I worry? Can I stop this from happening?
Mike
+++-+++---
Well, not really a problem, I guess... but when I
run a python program that makes use of it I get the
following "message" per row I process...
Freeing pointer out of range at line 663, 'C:\49\libmysql\libmysql.c'
Should I worry? Can I stop this from happening?
Mike
+++-+++---
Hi !!
> -Original Message-
> From: Ralph Walther [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 09, 2002 12:43 PM
> To: [EMAIL PROTECTED]
> Subject: download latest odbc-driver
>
>
> hi,
> if i try to download the latest odbc driver i get a file with
hi,
if i try to download the latest odbc driver i get a file with 43k. what
is wrong ? the original file on
http://www.mysql.com/downloads/api-myodbc-3.51.html is over 602K...
what have i to do?
-
Before posting, please
Hi,
> -Original Message-
> From: avital raz [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 04, 2001 12:56 PM
> To: [EMAIL PROTECTED]
> Subject: odbc driver
>
>
> hello
> i need help
> i have a database in mysql.
> i use an outside program that co
hello
i need help
i have a database in mysql.
i use an outside program that connect to the databas through odbc (dsn) and make
graphs.
the program worked very good for months but at the last week something disrupted.
when i tried to make graph from one specific table, i receive an error message.
Hi All,
Does any one know where I can find one?
Thanks.
Yours cheerfully,
Andrew bush
http://www.bushpro.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.c
Try this.
http://www.microsoft.com/data/odbc/
- Original Message -
From: satish <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 12, 2001 8:02 AM
Subject: ODBC driver doumentation !!!
> Hello ,
>
> I am developing front end applications with ba
Hello ,
I am developing front end applications with backend mysql server in
vc++. Can anyone tell how to connect to mysql server using odbc. Where is
that specific api documentation is found. I badly need it for my project.
satish.
Hello Fernando,
Tuesday, March 06, 2001, 7:13:50 PM, you wrote:
FRS> Where can I find the ODBC API Documentation to create a new ODBC
FRS> driver? and the JDBC API?
msdn.microsoft.com
see in platform SDK->DB and msgng services->MDAC SDK->ODBC
--
Best regards,
Alexey
JDBC
specifications.
Good luck...
Pat...
[EMAIL PROTECTED]
- Original Message -
From: "Fernando Rodríguez Sela" <[EMAIL PROTECTED]>
To: "MySQL Mailing List" <[EMAIL PROTECTED]>
Sent: Thursday, March 08, 2001 2:53 AM
Subject: ODBC Driver documentation request (aga
t protocol, so I decided to make an
ODBC driver that operate as an spy, saving all the SQL sentences send by
the client application, and then send it to the real ODBC
Driver. This idea is very usefull, because, it could be used to work
with all database engines that uses ODBC drivers ...
to make an ODBC
driver that operate as an spy, saving all the SQL sentences send by the
client application, and then send it to the real ODBC Driver. This idea
is very usefull, because, it could be used to work with all database engines
that uses ODBC drivers ...
MS ODBC -> Spy
Hi,
I had not answer at my first mail...
Sorry for posting it again but this is really important for us.
-Message d'origine-
De : Patrick FICHE [mailto:[EMAIL PROTECTED]]
Envoyé : lundi 12 février 2001 18:09
À : Mysql
Objet : Use of mysql_use_result in ODBC driver ?
Hi all,
I
Hi all,
I would like to change the do_query function in execute.c module in the ODBC
driver to use mysql_use_result function instead of mysql_store_result
function.
There is currently some comments with an eventual problem in case of
SQLRowCount function.
To my mind, the only thing would be
31 matches
Mail list logo
