 |
| 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
|
|
|
|

September 9th, 2003, 09:03 AM
|
|
Authorized User
|
|
Join Date: Sep 2003
Posts: 40
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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>" & _
|
|

September 9th, 2003, 09:14 AM
|
 |
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
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.
|
|

September 9th, 2003, 09:23 AM
|
|
Authorized User
|
|
Join Date: Sep 2003
Posts: 40
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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??
|
|

September 9th, 2003, 09:26 AM
|
 |
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
Well, the Beginning Dreamweaver MX Imar Spaanjaars ;)
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
|
|

September 9th, 2003, 09:41 AM
|
|
Authorized User
|
|
Join Date: Sep 2003
Posts: 40
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|
|

September 9th, 2003, 09:56 AM
|
 |
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
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.
|
|

September 9th, 2003, 10:34 AM
|
|
Authorized User
|
|
Join Date: Sep 2003
Posts: 40
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Well... I'm back to programming... thanks again and see you next error!!
Tandy Osborn
|
|
 |