[RESOLVED] variables in query in dataset

[phpman]

I added queries to my dataset via the designer. is there a way to use variables in those queries?

[phpman]

Nevermind, I found my answer.

It appears you have to edit the property of said query and insert the parameters there, then have place holders. For OLEDB I had to use the question mark

SELECT     Item
FROM         Table
WHERE     (Itemname LIKE '%' + ? + '%')
ORDER BY ?, ?

In case anybody else cares.