Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MySQL++ - Programming with the C++ API to MySQL
MaxDB - Everything about MaxDB, formerly known as SAP DB
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
• mysql openssl Question
• mysql:it 's a db not a dbms how it 's possible?!
• Does the binary log enabling affect the MySQL performances?
• Strange behavior, Table Level Permission
• FULLTEXT query format question
• Preventing Duplicate Entries
• Comparing and writing out BLOBS
• Executing MySQL Commands From Within C Program
• Can 't access mysql after kernel upgrade
• Mysql 4 0 Oracle Stored Procedure Trigger Conversion
• Downgrade Mysql from 4 to 3 23
• MySQL Cluster Software
• mysql test 4 1 fails with the gis test
• ERROR 2002: Can 't connect to local MySQL server through socket
• Getting Identity after INSERT
• Update one field with more fields from another table
• ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
• mysql have same function mthod as Oracle decode()
 
help needed

help needed

2006-09-12       - By dhfinamore@(protected)

 Back
Reply:     1     2     3  

Hi, I are working with visualfox 6.0 and mysql server 4.1 and odbc driver 3.51
.11.00 11 feb 2005

I have a table with a colum with an "F" or an "f"

this does not work, because ignore the where and bring to me all the records

SELECT status, no_documen FROM FACTHEAD where status="f"

I also try this and works fine in the mysql query browser but in fox bring to
me again all the records ignoring the lowercase

SELECT status, no_documen FROM FACTHEAD where hex(status)=hex("f")


what can I do?

Saludos



Daniel Hernandez Finamore
Director Ejecutivo
ISP, S.A. de C.V.
Telefono Conmutador 0155-5243-5222
http://www.bestcommerce.com.mx

Este mensaje y cualquier documento que se adjunte, son para el uso exclusivo de
la persona o entidad a la cual se encuentra dirigido y podr?a contener
informaci?n legalmente considerada como confidencial y privilegiada, exenta de
ser revelada a terceros. Si usted no es el leg?timo destinatario de esta
comunicaci?n, consid?rese notificado que est? estrictamente prohibido cualquier
tipo de reproducci?n y distribuci?n de este mensaje y cualquier documento
adjunto. Si usted ha recibido este mensaje por error, por favor notifique
inmediatamente esta situaci?n por correo electr?nico al remitente original y
borre completamente de su computadora el mensaje y cualquier documento adjunto.
Para establecer o formalizar alg?n tipo de acuerdo entre ISP, S.A. de C.V. y su
compa??a, es necesario que se firme por los representantes legales de ambas
compa??as un acuerdo por escrito que incluya todos los t?rminos y condiciones
de la transacci?n respectiva.

This message, together with any attachments, is intended only for the use of
the individual or entity to which it is addressed and may contain information
that is legally privileged, confidential and exempt from disclosure. If you are
not the intended recipient, you are hereby notified that any dissemination,
distribution, or copying of this message, or any attachment, is strictly
prohibited. If you have received this message in error, please notify the
original sender immediately by return E-mail and delete the message, along with
any attachments, from your computer. In order to establish a formal agreement
between ISP, S.A. de C.V. and your company, it is necessary to execute a
written document signed by the proper representatives of each company,
including all the terms and conditions of the relevant transaction.