Skip to main content
T
Tag2007
Inspiring
January 27, 2007
Answered

Go To detail Page error

  • January 27, 2007
  • 4 replies
  • 386 views
Hi Guys,
I have another quick question I hope someone can help me with.

I have a set of 3 pages..

Page 1 shows a category list >> Goes to page 2

Page 2 shows a list of whats in the category >> goes to page 3

Page 3 shows the item selected on page 2

Page 3 is the detail page i guess you would call it and all seems to work, but when the user gets to page 3 to view the details they want to go back to page 2 to choose another item to view so I added a Go To Detail Behavour on page 3

So On page 1 it passes a paremeter of "FolderId" to page 2 and page 2 diplays..

Page 2 passes the records ID to page 3 "id" and page 3 displays this...

So on page 3 I made a link to go back to A Related Page [page 2 ] and chose to pass URL parimeters and added this:

[code]
Main.asp?<%= Server.HTMLEncode(MM_keepURL) %> 



But its not right and I error our with: 



ADODB.Command error '800a0d5d' 



Application uses a value of the wrong type for the current
operation. 





Any help here is appreciated.

Thank You
This topic has been closed for replies.
Correct answer Newsgroup_User
Are you sure you want to retain the record ID of the record you previously
looked up when you go back to the listings page? I would think you would
want to uncheck that and lose the URL of the ID you previously used.

--
Nancy Gill
Adobe Community Expert
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner''s
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

"Tag2007" <webforumsuser@macromedia.com> wrote in message
news:epgdil$ec6$1@forums.macromedia.com...
> Hi Guys,
> I have another quick question I hope someone can help me with.
>
> I have a set of 3 pages..
>
> Page 1 shows a category list >> Goes to page 2
>
> Page 2 shows a list of whats in the category >> goes to page 3
>
> Page 3 shows the item selected on page 2
>
> Page 3 is the detail page i guess you would call it and all seems to work,
> but
> when the user gets to page 3 to view the details they want to go back to
> page 2
> to choose another item to view so I added a Go To Detail Behavour on page
> 3
>
> So On page 1 it passes a paremeter of "FolderId" to page 2 and page 2
> diplays..
>
> Page 2 passes the records ID to page 3 "id" and page 3 displays this...
>
> So on page 3 I made a link to go back to A Related Page [page 2 ] and
> chose to
> pass URL parimeters and added this:
>
> [code]
> Main.asp?<%= Server.HTMLEncode(MM_keepURL) %>
> 

>

> But its not right and I error our with:

>

> ADODB.Command error '800a0d5d'

>

> Application uses a value of the wrong type for the
current operation.

>

>

> Any help here is appreciated.

> Thank You

>

4 replies

T
Tag2007Author
Inspiring
January 28, 2007
I think I just got it!!

OK Nancy I wasnt listening to you properly, sorry..
On page 3 Ive done the same go to detail behavour, but unchecked the URL Parimeter and it seems to be working and im getting back and forth through page 2-3 no problems now..OR I seem to be ;-)Thank you..
T
Tag2007Author
Inspiring
January 28, 2007
Im just sitting having another go at this today...
On page 3 I thought I may have to pass the Parimeter back again to page 2 so it pulls the proper records so on page 3 I just tried a Go To Detail Page behavour and passed 'FolderID' back set to the same field as before and ...this didnt work.

Here is what my address bar shows after I go through the 3 pages and try to get back..

http:///www.blahblahblah.com/Main.asp?FolderId=Males&id=8&FolderID=Males

Thanks
T
Tag2007Author
Inspiring
January 28, 2007
Hi Nancy,
Im realy lost, I thought I had it..

Any assistance is welcomed,
Ive never done a set of pages quite like this although probably not overly complex its deffo the trickiest Ive tried to date..

Page 1 opens and shows a list of links- these links are fields in the database and are grouped in a query in access so when they are pulled they show a list of categorys and how many entrys per category eg: Boys(12) Girls(3)

When you click on one of those links an Url Parimeter called 'FolderId' is passed to page 2, the recordset there looks for all records that have the same 'FolderID' eqivilant and display in a repeat region.

These records can also be clicked on to view and Page 2 sends a parimeter called 'id' to page 3 to pull that specific data and display to choose a record..

This all works..

But once on page 3 I may want to go back to page 2 to pick other records that were in the same range as the parimeter 'FolderID' so i need a link back to page 2 ..

Everything I have tried has not worked.

Thanks very much for your reply.
King Regards
Tag

N
Newsgroup_UserCorrect answer
Inspiring
January 28, 2007
Are you sure you want to retain the record ID of the record you previously
looked up when you go back to the listings page? I would think you would
want to uncheck that and lose the URL of the ID you previously used.

--
Nancy Gill
Adobe Community Expert
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner''s
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

"Tag2007" <webforumsuser@macromedia.com> wrote in message
news:epgdil$ec6$1@forums.macromedia.com...
> Hi Guys,
> I have another quick question I hope someone can help me with.
>
> I have a set of 3 pages..
>
> Page 1 shows a category list >> Goes to page 2
>
> Page 2 shows a list of whats in the category >> goes to page 3
>
> Page 3 shows the item selected on page 2
>
> Page 3 is the detail page i guess you would call it and all seems to work,
> but
> when the user gets to page 3 to view the details they want to go back to
> page 2
> to choose another item to view so I added a Go To Detail Behavour on page
> 3
>
> So On page 1 it passes a paremeter of "FolderId" to page 2 and page 2
> diplays..
>
> Page 2 passes the records ID to page 3 "id" and page 3 displays this...
>
> So on page 3 I made a link to go back to A Related Page [page 2 ] and
> chose to
> pass URL parimeters and added this:
>
> [code]
> Main.asp?<%= Server.HTMLEncode(MM_keepURL) %>
> 

>

> But its not right and I error our with:

>

> ADODB.Command error '800a0d5d'

>

> Application uses a value of the wrong type for the
current operation.

>

>

> Any help here is appreciated.

> Thank You

>
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices