MyODBC and Windows XP
Hi, everybody I have in my office two pc machines. One of them is a Pentium III with Windows 98 second edition and MyODBC 3.51.06; the other is a Pentium 4 with Windows XP and MyODBC 2.50.39. The MySQL database is running on a linux server, and via MyODBC I connect to the MySQL server to run my Visual FoxPro desk applications. The problem is: the Pentium III machine loads faster the remote tables than the Pentium IV; or better said: the Pentium IV pc loads very very slow the remote tables. I've tried with the two version of MyODBC, and I've got the same result. What can it be? TIA __ José Angel Blanco Linares Depto Servicios de Apoyo Académico Centro de Enseñanza Técnica Industrial 3641-3250, ext: 264 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Visual Foxpro
** * En VFP mi date format siempre es dd/mm/, mysql necesita '-mm-dd' para manejar fechas (FECHA1 y FECHA1 son DATE) FUNCTION FIXDATE PARAMETER ts1 LOCAL m.sRet IF TYPE_D == TYPE( ts1 ) ts1 = DTOC( ts1 ) ENDIF m.sRet = IF NOT EMPTY( ts1 ) m.sRet = RIGHT( ts1, 4 ) + - + SUBSTR( ts1, 4, 2 ) + - + LEFT( ts1, 2 ) ENDIF RETURN m.sRet enddefine * Jose de Jesus Ruiz Gonzalez Depto. de Sistemas 5480-3886 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] __ José Angel Blanco Linares Depto Servicios de Apoyo Académico Centro de Enseñanza Técnica Industrial 3641-3250, ext: 264 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Retrieving a numeric series from a SELECT
Hi, Fellows! Sorry for my poor english. Thats why I can explain myself properly. :- ) What I really want is a calculate column with consecutive numbers from n to m, where n can be any number, and m depending on the result of the WHERE clause. I need to print pay orders for students, this pay orders use a consecutive control number, the criteria to select students use to be variable. Example: SELECT colnum, id, name FROM students WHERE status='OK' (4 rows selected) or SELECT colnum, id, name FROM students WHERE grade=1 (230 rows selected) colnum must be the same number that is printed in the pay order. The next pay order on the printer is 15000, then colnum of the first row of the SELECT must be 15100, the next row 15001, and so on. you get it? I remember that the sample i saw in this SQL list only used a SELECT statement without a table, or whitout a memory variable. it was only a SELECT something, and it returns a consecutive serie from 1 to 100. Thanks again. __ José Angel Blanco Linares Depto Servicios de Apoyo Académico Centro de Enseñanza Técnica Industrial 3641-3250, ext: 266 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Retrieving a numeric series from a SELECT
Hi, everybody How can I get a numeric column from a SQL SELECT statement? I mean, with a SELECT get something like this ColNum or ColNum 1 10 2 11 3 12 4 13 5 14 6 15 ... ... Some time ago, somebody wrote a sample that do exactly what I need. In fact, I took that sample and saved it to my HD, but i can't find it, hehehe. TIA __ José Angel Blanco Linares Depto Servicios de Apoyo Académico Centro de Enseñanza Técnica Industrial 3641-3250, ext: 266 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Retrieving a numeric series from a SELECT
Hi, everybody How can I get a numeric column from a SQL SELECT statement? I mean, with a SELECT get something like this ColNum or ColNum 1 10 2 11 3 12 4 13 5 14 6 15 ... ... Some time ago, somebody wrote a sample that do exactly what I need. In fact, I took that sample and saved it to my HD, but i can't find it, hehehe. TIA __ José Angel Blanco Linares Depto Servicios de Apoyo Académico Centro de Enseñanza Técnica Industrial 3641-3250, ext: 266 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
