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
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