Hi all,
I am building a Treeview control and trying to use HExecuteSQLQuery-commands in it, but with poor results. Sample:
iGroup is int (... and has been given some value...)
FolderQuery is Data Source
IF NOT HExecuteSQLQuery(FolderQuery,...
"SELECT SPFOLDER.FOLDERNAME AS NAME FROM SPFOLDER WHERE SPFOLDER.SPGROUPID = iGroup") THEN
...gives an error, complaining that the iGroup-variable is not a file item. Now the question: Is it possible to use non-fileitem variables in a HExecuteSQLQuery-command? How?
Thanks in advance for any hints and tips
Ola Pedersen
[
www.pienoismalli.com]