Complex ASP Problem

Results 1 to 2 of 2

Thread: Complex ASP Problem

  1. #1
    Join Date
    Dec 1969
    Posts
    1,013

    Default Complex ASP Problem

    I need someone&#039s help here... ok... I have a database... and in it.. it has a different row for each page on the site.. and... it has a variable for each site... so... we&#039ll say.. Welcome.. and it would = welcome.asp... well.. what I want is that it will do a database lookup and find out the page for Welcome... well.. it&#039s welcome.asp.. but.. how do I get it to load that page... I found out one way by reading the file line by line then outputting it.. but... that actually shows the code of the ASP page<BR><BR>here is the code I use now:<BR><BR>sql = "Select * FROM Pages where t = &#039"& Request("t") &"&#039"<BR>set PageRS = conn.execute(sql)<BR>Set fs = CreateObject("Scripting.FileSystemObject")<BR>NewF ile = Server.MapPath ("/")&"\" & PageRS("URL")<BR>Set f = fs.OpenTextFile(NewFile, 1)<BR>Response.Write f.ReadAll<BR>f.Close<BR><BR>using this code it actually shows the code of the ASP page.. I don&#039t want that.. I want it to actually load the ASP page!.. anybody know?

  2. #2
    Join Date
    Dec 1969
    Posts
    69

    Default RE: Complex ASP Problem

    Use:<BR><BR>Response.Redirect strURL<BR><BR>where strURL is URL of the welcome page (like "welcome.asp").

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •