Hi,
I need a free SQL select, that contains something like:
SELECT myid AS value, mytext AS text
FROM #__table1 AS a, #__table2 AS b
WHERE a.id=[parent]
....
Problem:
a.id is of type INT. But the field seems to set quotes automatically around parent. So my parent of type integer is converted to type string and the SQL call fails.
What can i do?
Greez
Alex