Wrox Programmer Forums
|
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 9th, 2003, 09:03 AM
Authorized User
 
Join Date: Sep 2003
Posts: 40
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to TnTandyO Send a message via Yahoo to TnTandyO
Default

OK we have a new error..
Item cannot be found in the collection corresponding to the requested name or ordinal.
/asp/rod/ViewIThelp.asp, line 58

line 58 strOutPutString = strOutPutString & "<TR>" & _
line 59 "<TD valign=top><a href=""Display.asp?ID=" & objRS("ID") & """><img src=images/" & objRS("sImageName") & ".gif></a>" & _
 
Old September 9th, 2003, 09:14 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Step by step, we'll get there, I promise ;)

How does your table structure look like? I think it doesn't have a column called sImageName. This was just a variable in used in my code.

objRS("sImageName") should contain the name of the column that determines the image type (closed or open), so replace sImageName with the name of the column in your database.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
 
Old September 9th, 2003, 09:23 AM
Authorized User
 
Join Date: Sep 2003
Posts: 40
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to TnTandyO Send a message via Yahoo to TnTandyO
Default

Oh... I can not believe I did that!! Thank you so much!
OK now I have a few errors on the display page, let me go debug and I'll be back to let you know how it's going :) THANK YOU THANK YOU THANK YOU!!!

By-the-way Are, personal question, are you the DreamweaverMX: Imar Spaanjaars??
 
Old September 9th, 2003, 09:26 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Well, the Beginning Dreamweaver MX Imar Spaanjaars ;)


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
 
Old September 9th, 2003, 09:41 AM
Authorized User
 
Join Date: Sep 2003
Posts: 40
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to TnTandyO Send a message via Yahoo to TnTandyO
Default

Well guess what? It all works fine. And my computer is still on top of my desk!!
Thank you so much for all your patience with my constant questions. Is there some place on the wrox site I can go to rate your help so to speak..(noticing the stars by your name)
I've had instuctors that couldn't help this much.
Tandy
 
Old September 9th, 2003, 09:56 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

You're welcome. Glad I could help.

There is no rating on this site; the number of stars is based on the post count on this forum. Check here to see how it works.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
 
Old September 9th, 2003, 10:34 AM
Authorized User
 
Join Date: Sep 2003
Posts: 40
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to TnTandyO Send a message via Yahoo to TnTandyO
Default

Well... I'm back to programming... thanks again and see you next error!!
Tandy Osborn





Similar Threads
Thread Thread Starter Forum Replies Last Post
Repeat single record in Crystal Report? jpryor Crystal Reports 1 April 11th, 2008 10:20 AM
Help in appending a single record. prashanthmcr SQL Language 0 December 14th, 2005 08:47 PM
How do I append a single record ??? prashanthmcr SQL Language 3 December 14th, 2005 05:40 PM
Editing SINGLE record in ASP.NET Koofmich ADO.NET 5 December 30th, 2004 05:42 AM
"Single-Record" Recordset Wyatt70 Classic ASP Databases 2 November 18th, 2003 01:20 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.