Changing columns descriptions...

2008-12-30 Thread Carlos Savoretti
products.product_id IS 'Foo'; Thanks in advance Carlos Savoretti. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Prepared statement cursors problem.

2008-07-29 Thread Carlos Savoretti
\n, mysql_stmt_error (cdata-mysql_stmt)); } --- fails giving: The statement (1) has no open cursor. ??? Why could be this ? , provided the cursor was set up before successfully What I missed up ? Thanks in advance. Carlos Savoretti. -- MySQL General Mailing List For list

Prepared statement cursors problem.

2008-07-29 Thread Carlos Savoretti
\n, mysql_stmt_error (cdata-mysql_stmt)); } --- fails giving: The statement (1) has no open cursor. ??? Why could be this ? , provided the cursor was set up before successfully What I missed up ? Thanks in advance. Carlos Savoretti. -- MySQL General Mailing List For list

Information schema question.

2008-03-18 Thread Carlos Savoretti
=usesysid AND typrelid = 0 AND typname !~ '^_' -- Is there some way to obtain equivalent columns from INFORMATION_SCHEMA, as similar as possible ? Thanks in advance... Carlos Savoretti. -- MySQL General Mailing List

Optimizing a big query...

2005-03-09 Thread Carlos Savoretti
-3.23.58) and what is the the recommended value to clamp the `page' for a gui app. (For 1000 rows it uses about 12 seconds). Thanks a lot... -- Carlos Savoretti [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Local variables

2004-09-10 Thread Carlos Savoretti
' is NULL. What am I doing bad ? Please, help me Thanks all Carlos Savoretti [EMAIL PROTECTED] ... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Alternative for storing results...

2001-06-01 Thread Carlos Savoretti
Hi. I'm using the C API to access mySQL database (trying to reuse a lot of existing software, mixing an old database mySQL, but it's not the point). Due the way the old database (named Ideafix) run the keys sometimes the translated query produce too many rows (running out ot memory) although

Help me with mysql_store_result()

2001-06-01 Thread Carlos Savoretti
Hello, mysql: Can anyone say if exist some function in the C API that do not store all the requested rows before returning but it returns inmediatly for each one and the storing be in the remote server. Thanks a lot ! [EMAIL PROTECTED]

Can I do this ?

2001-05-24 Thread Carlos Savoretti
I'm using C API to access MySQL from another database in order to re-use a lot of existing software. Due the way the old database works I need a query be done like this: SELECT * FROM some_table WHERE field1 = 1 AND field2 0 ORDER BY CONCAT(field1,field2) LIMIT 1 This is for not to create