SQL location

I am working on somthing were I have 3 files.

config.asp

check_user.asp

skin.asp

They are all located withing the same folder, and are included into the sites default page in the order I gave them.

The thing is, I would like to have the following statment in my config.asp...

SQL_set_skin="SELECT table_skin.* FROM table_skin WHERE skin_name='" & user_skin & "';"

The problem is, user_skin is not set untill check_user.asp, so I need to have it in skin.asp.

Is there anyway I can do this?

I don't understand what you mean...

I already knew this... This has nothing to do with my question.

What I want to do is place all my SQL's in the config.asp.

I was only using the skin as a example of a problem... That problem being a value of the SQL being set after the config.asp.

A default skin has nothing to do with my question.

Ok, I found a even better way...

<%

function call_SQL(text)

select case text
 case "skin" call_SQL="SELECT table_skin.* FROM table_skin WHERE skin_name='" & user_skin & "';"end select

end function

%>

<% record.open call_SQL("skin"), data %>

This makes thing a bit cleaner.

Again, if anyone can help me improve this code... I would love the help.

Thanks.