[API]

Thanks for getting back to me..

Read in and populated tables meant that I used the import CSV to put data into my table..

There is no letter case mismatch..

my table looks like:

Col. Contents

UserName “[email protected]”

Password “password”

I can get a one query to work with a WHERE

Just found it… my Tables entries have double quotes around them..

Thanks

peterlaursen wrote on Jul 25 2006, 01:10 PM:

“I get noting returned” not even an error message?

HOW do you I attempt to use the query:

SELECT UserName FROM tUser WHERE (Password =”password”)

try:

SELECT UserName FROM dbname.tUser WHERE Password = 'password';

(standard quotes in MySQL are ” ' ” – paranthesis'es are not needed – and this adds the database name

– but yours hould work as well!)

It is not a LETTERCASE mismatch?

I really cannot figure out here what 'you are missing'

… is there a RESULT tab showing up in the DATA area ?

Of course such query would work!!

Also what do you mean by “Read in and populated tables” ?

Are you sure that there any data in the table at all?

Expand the database in the Object Borwser (left) – click the table and select DATA tab in the DATA area.

[Author]

Posts