jonkemm

I'm sure I've got the name of this wrong - i'm looking for some SQL code that will return records from a table ONLY when they are linked to records in another table.To put it in real terms, I want to only show the gallery icons for nights that have pictures in them. If you hover your mouse over the folder icons it says how many pics are in each gallery.Here's the current SQL: set galleryRS=conn.execute("SELECT * FROM events WHERE events_archive IS NOT NULL ORDER BY events_date_year DESC, events_date_month DESC, events_date_day DESC") Here's the page:Nightclub Gallery PageIf I do an INNER JOIN I get far too many results.Please help!Jk

Thank you (genius!) - With a little googling I found that using this...<%@LANGUAGE="VBSCRIPT"%><% Response.ContentType = "application/xml" %><?xml version="1.0" encoding="ISO-8859-1"?>...as the first line sorted it.<% Response.ContentType = "application/xml" %> was the line that solved it.I then had an error because there was a space in front of the <?xml version="1.0" encoding="ISO-8859-1"?> tag (hence the reason it's all on the same line!)Hopefully this should help others in the future?Jk

Hiya,I'm trying to learn how to make a dynamic XML document in ASP but can't get it to work. Am I fighting a loosing battle or is there a trick to it?Here's the xml example (borrowed from a site just to try and get it to work):http://www.atlantisnightclub.co.uk/rss/rss.xmlThis clearly worksBut when I do the same thing in asp: (Literally the same code but in an ASP file)http://www.atlantisnightclub.co.uk/rss/rss.aspIt doesn't work...I'm sure i'm being an idiot even trying this but i've seen it work:http://www.aspmessageboard.com/scripts/rss.aspPlease help?Jk