Code Bank
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free ForumsProgrammingCode Bank

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old November 8th, 2004, 03:22 AM
katsuragi84 katsuragi84 is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Jul 2004
Location: Yggdrasil
Posts: 20 katsuragi84 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Exclamation Uploading and Viewing Images from Access DB

Hello,

I am currently working on tutes so I can upload and display images from an Access database. I am getting
errors to no end again. Can someone please pin point the error in these places:


insert.asp - ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.

In this chunk of code:

' Recordset object
Dim rs
Set rs = Server.CreateObject("ADODB.Recordset")

rs.Open "Files", connStr, 2, 2

' Adding data
rs.AddNew
rs("File Name") = fileName
rs("File Size") = fileSize
rs("File Data").AppendChunk fileData
rs("Content Type") = contentType
rs("First Name") = fnameInput <<< This line is specified.
rs("Last Name") = lnameInput
rs("Profession") = profession
rs.Update

rs.Close
Set rs = Nothing


Show.asp - Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.

on this line ' opening connection
rs.Open "select [ID],[File Name],[File Size],[Content Type]," & _
"[First Name],[Last Name],[Profession] from Files " & _
"order by [ID] desc", connStr, 3, 4

Where on earth am I going wrong on tutorial code? I just want to be able to update, view and delete images from
a database, how hard can that be??

Regards,
Nicole

Reply With Quote
Reply

Viewing: ASP Free ForumsProgrammingCode Bank > Uploading and Viewing Images from Access DB


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway
Stay green...Green IT