Hi all,

After a record delete, I want a redirect to an URL stored in the database.
I have my recordset working fine and thus point the redirect to Data Source instead of the File System.
This seems not to work for the redirect.
I'm always getting "Object required" error :

Runtimefout Microsoft VBScript error '800a01a8'
Object vereist: ''
/image-belle/asp/guestbook/delete.asp, line 50

line 50 : MM_editRedirectUrl = "" + (Recordset1.Fields.Item("Subdomain_URL".Value) + ""

Anyone know what's wrong ?

Thanks,

Wim

Wim Conix
www.image-belle.com

Recordset1 is probably not available, check where the recordset is created and that this code is above line 50.

--------------------------------------------------
Patrick Woldberg
Web Developer at Dynamic Zones
Administrator at DMXzone.com, FLzone.net, FWzone.net and DNzone.com
--------------------------------------------------

Hi again Patrick,

Recordset was indeed after line 50.
That's corrected.
However, now getting other error :

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Wimley'.
/image-belle/asp/account/author_details.asp, line 31

I'm nowhere sending parameters to a colomn 'Wimley', which does not exist.
I'm redirecting to the URL (field value "Subdomain_URL" directly, thus pointing to wimley.image-belle.com. URL works normal.

Dim MM_editRedirectUrl
MM_editRedirectUrl = "" + (Recordset1.Fields.Item("Subdomain_URL".Value) + ""
If (Request.QueryString <> "" Then
If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0) Then
MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString
Else
MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString
End If
End If
Response.Redirect(MM_editRedirectUrl)
End If

Strange...

I'll send you the page if that helps.

Greetz,

Wim

Wim Conix
www.image-belle.com

Send me the page to

--------------------------------------------------
Patrick Woldberg
Web Developer at Dynamic Zones
Administrator at DMXzone.com, FLzone.net, FWzone.net and DNzone.com
--------------------------------------------------