Changing columns descriptions...

2008-12-30 Thread Carlos Savoretti
MMENT ON COLUMN 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
ql_stmt_store_result failed: %s\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

Prepared statement cursors problem.

2008-07-29 Thread Carlos Savoretti
ql_stmt_store_result failed: %s\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

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 Ma

Optimizing a big query...

2005-03-09 Thread Carlos Savoretti
lient-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 unsu

Local variables

2004-09-10 Thread Carlos Savoretti
operation is carried out, and `Total' 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]

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] ---

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

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