How to make WHERE statement

[jurgenv89]

Hi,

This may seem like a very noobish question. Maybe it is

Usually i use mysql databases, but i'm doing a special assignment in which i have to use odbc.

I have this query:

"SELECT * FROM `Calls_cal` WHERE calID='52' ORDER BY `calID`"

But it gives an error. I've read i should put calID in quotes, like WHERE 'calID'='52' But then it gives no results. I think quoting 'calID' means it just looks at the text 'calID', but i want it to see if the value of the column calID equals 52.

Who can help me?

Thanks in advance,

Jurgen

 

[SkipVought]

Hi,

Try this...

"SELECT * FROM `Calls_cal` WHERE `calID`='52' ORDER BY `calID`"

NOTE: This syntax is NOT identical

`calID`
'calID'

You could also use...

"SELECT * FROM [Calls_cal] WHERE [calID]='52' ORDER BY [calID]"

Skip,
[sub]
[red][/red]
[/sub]

 

[jurgenv89]

Nope that doesn't work. I think i have a weird kind of odbc installed :s

 

[k5tm]

What is the ODBC-enabled application? MS Access?

What is the ODBC driver?

What is the schema of the table, especially the relevant columns?

Tom Morrison

http://www.liant.com

 

[edpatterson]

The question was not posted by me but it answered one I just posted in PHP.

I am using Apache, PHP and through no fault of my own a remote MS Access database via odbc. I could not get the WHERE clause to work no how, no way. Both of your examples worked perfectly.

Thanks a million!

Ed

 

[edpatterson]

I spoke a bit too soon. It works until I try to use the WHERE with an ip address

This returns no rows, the address exists in 3 rows

"SELECT user_name, host_name, ip_address from [log] where [ip_address] = '192.160.12.15'";

 

[SkipVought]

...and the data is EXACTLY the same as 192.160.12.15, no trailing spaces or anything?

try

"SELECT user_name, host_name, ip_address from [log] where [b]trim([/b][ip_address][b])[/b] = '192.160.12.15'[b];[/b]"

Skip,
[sub]
[red][/red]
[/sub]

 

[edpatterson]

Well, no it was not exact. I had a O (oh) in my query instead of a 0 (zero). (head hung in shame)

Backtracking through all the messages enclosing the table and where criteria in either []'s or ``'s did the trick.

Had I not switched my editor to the andale mono (fixed pitch, zero slash) after your EXACTLY message I would still be looking.

Thanks for both your patience and assistance.

Ed