<%
Dim strPath 'Path of directory to show
Dim objFSO
Dim objFolder
Dim objItem
strPath="./files"
Set objFSO = Server.CreateObject("Scripting.FileSystemObject")
Set objFolder = objFSO.GetFolder(Server.MapPath(strPath))
response.write "<TABLE>" &_...
[I'm not a XML expert] To me the structure of your XML is the source of trouble. I've made some changes; see if that's better...
<?xml version="1.0"?>
<BOOK>
<PAGE id="1">
<LANGUAGE id="17" name="Eng">
<NAME>name 1 Eng</NAME>
</LANGUAGE>...
This will show all combinations of names and photo's:
[that is basically your SQL-statement]
Select *
FROM link l
JOIN photos p on l.id = p.id
JOIN names n on l.name_id = n.name_id
This will show all photo's for 1 name (with name_id = 1):
Select *
FROM link l
JOIN photos p on l.id = p.id...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.