Using variabels in an SQL statement

[Hylsan]

Hi
Im using ADO and the Exchange oledb-driver to access exchange public folders, but I have a little problem. I want the program to use a variabel to store the full path to the server and then use it in the SELECT statement, as follows;

dim srvPath as string = "[URL unfurl="true"]http://server/public"[/URL]

sel = "SELECT ""DAV:contentclass"",""DAV:displayname"" FROM scope('shallow traversal of "srvPath"') WHERE ""DAV:contentclass"" = 'urn:content-classes:folder' and ""DAV:displayname"" = 'Folder'"

Does anyone have a idea how to make this work??

Regards
Tomas

 

[bduke]

dim srvPath as string = "

http://server/public"

sel = "SELECT " " & DAV:contentclass & " '" & , & "' " & DAV:displayname & " " & FROM scope('shallow traversal of "srvPath"') WHERE & " " & DAV:contentclass & " " & = 'urn:content-classes:folder' and & " " & DAV:displayname & " " & = 'Folder'" & "

I think I got all my syntax right...

 

[Hylsan]

ok, my misstake...what I ment was;

What I ment was, I want the code to look like the one in the code-snippet(if you run that, it complains about table not exists). Everything works except when inserting the variabel "srvPath" into the "shallow traversal", i.e changing srvPath to "

http://server/public"

works perfectly.

Hope I made myself clearer

/Hylsan

 

[Dimandja]

Try:

scope('shallow traversal of " & srvPath & "')