Current location: Hot Scripts Forums » Programming Languages » ASP » Really complex redirect 301 - need help!


Really complex redirect 301 - need help!

Reply
  #1 (permalink)  
Old 07-08-06, 05:19 AM
Josie's Avatar
Josie Josie is offline
New Member
 
Join Date: Jul 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Unhappy Really complex redirect 301 - need help!

I have a blog who created pages this way: article.asp?id=222
and I'm using a sort of asp urlrewrite. It works perfectly with creating the articles etc, but now I have to put a "301 moved permanently" in the old article.asp page.

I have a function which converts the title of the article to a page name, using title and id:
Code:
	Function ConvertiTitoloInNomeScript(Titolo, IDArticolo)
		Risultato = Titolo
		Risultato = NoHTML(Risultato)
		Risultato = LCase(Risultato)
		Risultato = Replace(Risultato, " ", "-")
		Risultato = Replace(Risultato, "\", "-")
		Risultato = Replace(Risultato, "/", "-")
		Risultato = Replace(Risultato, ":", "-")
		Risultato = Replace(Risultato, "*", "-")
		Risultato = Replace(Risultato, "?", "")
		Risultato = Replace(Risultato, "<", "-")
		Risultato = Replace(Risultato, ">", "-")
		Risultato = Replace(Risultato, "|", "-")
		Risultato = Replace(Risultato, """", "")
		Risultato = Replace(Risultato, "'", "-")
		Risultato = Replace(Risultato, "!", "")
		Risultato = Replace(Risultato, ",", "-")
		Risultato = Risultato & ".asp"
		ConvertiTitoloInNomeScript = Risultato
	End Function
With my really really poor knowledge of ASP I've written this in article.asp:
Code:
<%@ Language=VBScript %>
<%
Set Conn = Server.CreateObject("ADODB.Connection")
	Conn.Open "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = "& Server.MapPath("/mdb-database/dblog.mdb") &";"
	Function ConvertiTitoloInNomeScript(Titolo, IDArticolo)
		Risultato = Titolo
		Risultato = NoHTML(Risultato)
		Risultato = LCase(Risultato)
		Risultato = Replace(Risultato, " ", "-")
		Risultato = Replace(Risultato, "\", "-")
		Risultato = Replace(Risultato, "/", "-")
		Risultato = Replace(Risultato, ":", "-")
		Risultato = Replace(Risultato, "*", "-")
		Risultato = Replace(Risultato, "?", "")
		Risultato = Replace(Risultato, "<", "-")
		Risultato = Replace(Risultato, ">", "-")
		Risultato = Replace(Risultato, "|", "-")
		Risultato = Replace(Risultato, """", "")
		Risultato = Replace(Risultato, "'", "-")
		Risultato = Replace(Risultato, "!", "")
		Risultato = Replace(Risultato, ",", "-")
		Risultato = Risultato & ".asp"
		ConvertiTitoloInNomeScript = Risultato
	End Function
IDD = request.ServerVariables("QUERY_STRING")
Dim SQLArticoli
SQLArticoli= " SELECT Articoli.Titolo FROM Articoli WHERE Articoli.ID = IDD "
Set RSArticoli = Server.CreateObject("ADODB.Connection")
RSArticoli.Open SQLArticoli, Conn, 1, 3

Response.Status = "301 moved Permanently"
Response.AddHeader "Location", ConvertiTitoloInNomeScript(RSArticoli("Titolo"), IDD)
%>
Probably this is absolutely wrong, anyway the error I get is:
Microsoft VBScript runtime (0x800A01C2)
Wrong number of arguments or invalid property assignment: 'RSArticoli'
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiShare on FacebookShare on Stumble UponShare on Twitter
Reply With Quote
  #2 (permalink)  
Old 07-08-06, 11:47 AM
Josie's Avatar
Josie Josie is offline
New Member
 
Join Date: Jul 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
OK, SOLVED.
moderators can close this topic.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiShare on FacebookShare on Stumble UponShare on Twitter
Reply With Quote
  #3 (permalink)  
Old 07-08-06, 05:22 PM
koncept
Guest
 
Posts: n/a
would you mind posting the solution incase someone else has a similar problem..
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiShare on FacebookShare on Stumble UponShare on Twitter
Reply With Quote
Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Permanent 301 Redirect to new Domain's URL giving me problems in .htaccess cebuy HTML/XHTML/XML 1 03-10-06 11:34 PM
Tempopary Redirect user to a Sponsor Ad green07 PHP 3 04-24-05 11:58 AM
Redirect Script. RossC0 JavaScript 2 02-10-05 06:02 AM
Redirect previous 2 pages after login mcrob PHP 5 01-01-05 08:35 AM
complex exponential mitkid9 C/C++ 0 07-06-04 11:59 AM


All times are GMT -5. The time now is 09:37 PM.
vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.