Search:

Thank you for your answers.

This is what I did. If I am printing I do nothing. If I am not printing I retrieve a (default) printer DC and then I attach its attrib DC to the attrib DC of the...

Hi all, after so many years.

I must take an old MFC project in VC++ 6.0 and make changes.

The problem is text size in screen is different from size in print preview.

for example with this...

The problem with that is the dialog won't be visible at that time.

The standard method is that proposed by Cilu.

You can also try a dirty trick doing it in OnPaint() with the aid of a flag. ...

Hi

does excel automation deppends on the Excel version?

In other words, If I create an application with excel automation and Access 2007. Will it work on a computer with Access 2003 installed?...

Enhorabuena.

:wave:

Thank you.

Hello

Which is the conversion function to convert TCHAR based strings into floating point numbers? In other words, which is equivalent for atof?

For atoi is _ttoi (or _wtoi)
for atof is?
...

with LIKE?

Yes but it is giving me results like "espantapájaros" I would like to obtain only full words...

I would like to work with REGEXP brecuse the work is done, although maybe processing...

Queries for matching exact values are working now.

Now I find another problem, REGEXP is not working as I expected.

I have something like this:

$sql="select * from aves where nombre REGEXP...

Regular expresions don't work.

I've checked everything, collations, caracter sets...

I've seen pájaro is stored in the DB as: 70 C3 A1 6A 61 72 6F which is 7 bytes long. This is the utf8 code....

Yes, still having problems.

The problem must be on the data itself.

For me too, (saving them as utf-8 in my case)

The problem is doing the same with 'pajaro' instead of 'pájaro' I don't obtain any result.

Tried you suggestion.

The á character is seen on the form.

The query for 'pájaro' is successful and gives the same result with both $_POST and hardcoded text.

The query for 'pajaro' doesn't...

I have 5.0.54

I attacha an image of the simplest query I've done: SELECT 'pajaro'='pájaro'

Doing the query using phpMyAdmin 2.9.0.2 returns TRUE. (collation working)

But when doing with...

do you mean that collation is only useful for sorting and not works for comparisons?

If that's true the only solution I see is to duplicate the entries in DB since I must have the correct...

Thank you.

I can not do that. I have to keep the words in database with its special characters.

The problem is in spanish collation 'á' is equivalente to 'a' but MySQL is ignoring it. Why?

I have a mysql database with one table 'data' and one field in that table 'news'. This field 'news' contains a record 'pájaro'

The database collation is utf8_spanish_ci
The field collation is...

you mean low-life words? can you share those words with me? :D

The only way I have found to solve the problem is to dynamically create and destroy the CRecordSet object. Then If I found it is timeout I destroy and create it again before calling Open().

This...

I will try that way.



I am sure the timeout happens because I have the recordset open without doing anything more time than the connection timeout of the server.

I wonder why after closing...

Thanky you.

I think is a connection timeout matter since I already was connected and there is no query involved.

I connect to a remote database with CRecordSet derived class and ODBC. (MyODBC)

The timeout of the remote DB is 5 minutes and I can not change it.

Supposing the timeout time has passed.

-...

sorry then let's change it to:

laud

Thank you John.

I have to investigate about null fields. I think I don't fully understand what is a null field. I just thought empty=null but now I see this is not true.

Unfortunately the final...

B.E.U.D.