Item cannot be found in the collection corresponding to the requested name or ordinal.
/etms/WorkFlow/ProductWF/Components.asp, line 193
**********************
The query works fine when i execute it from SQL server but when I integrate it into ASP it doesn't work. Can anyone please shed some light on this. Code:
Error Type: ADODB.Recordset (0x800A0CC1) Item cannot be found in the collection corresponding to the requested name or ordinal. /emirate/view.asp, line 175
my database is access,i checked both data base as well as the coding,both field names are correct
my sql is only this sql= "select * from MasterEntry"
have a look at this code and see if they can spot the error. I've been looking for sometime but I'm blind to it - I have a feeling it might be something to do with the ID field? The connection appears fine so this is unlikely to be the cause .
I know what this error is, all fieldnames have been verified and reverified. Not sure why it is happening. Here is the SQL statement
strSQL = "SELECT Problems.TicketNumber, Activity, ActDate FROM Problems LEFT JOIN Resolutions ON Problems.TicketNumber = Resolutions.TicketNumber WHERE Problems.TicketNumber = " & Ticket & " ORDER BY ActDate DESC;"
I'm getting this error working on a RecordSet that is filled by a LEFT JOIN query. Everything works fine, until an attempt to access data from the child table in the RecordSet when it doesn't exist.
Which results in "Item cannot be found in the collection". Is there a check that I can perform to see if a RecordSet item exists before attempting to access it?
I'm running a stored procedure that inserts a record into a table then returns the Identity field value. I've done this kind of thing plenty of times in the past, but I'm obviously doing something wrong this time..
I've tested the Stored Proc in QA and it works fine. The SQL code runs OK in ASP (iAffected = 1 which shows the record is inserted), but when I try to query the resulting recordset, I get an error:
"Item cannot be found in the collection corresponding to the requested name or ordinal. " Code:
I have an exe that is programmed to enter itself in the registry so that whenever the user logs into the machine the exe starts executing. This exe reads data from a text file. whenever the user logs in he gets "file not found" messagebox (the application is in VB) even though the file that it reads from exists.
If we kill the process from the task manager and run it again there is no such error. Its only when the user logs in that he gets this error. The process has to be killed and restarted for it to work.
There is an ASP page in my site which sometimes gives file not found error. This page which is suppossedly missing exists on the server and available most of the time. But sometimes out of the blue, we get this message. When we restart IIS, the page works fine.
The rest of the site is usually fine. This one page gives the 404 error consistently. Obviously anything after this page could not be accessed. There are some other ASP pages as well which become unavailable (giving file not found errors) from time to time.
Error Report: Microsoft VBScript runtime (0x800A004C) Path not found line 236
------------- IF objFso.FolderExists(strPath) AND Request.QueryString("delete_file") = "y" THEN objFso.DeleteFolder(strPath) ---------------> line 236 END IF ----------
But if the path is not found line 236 shouldnot execute right?
I am encountering an error HTTP 404 - File not found. It seems that when I upload a file with a symbol # in the filename, this error occurs (e.g. case#2.pdf). I cannot access the file I uploaded. But when I upload the same file with a different filename or just without the symbol # (e.g. case2.pdf) , it works I can access the file. Why is this the case?
I have a virtual directory which I can access as Directory Browing has been enabled. Now if in Internet Explorer I open any Static content like HTMLs/SWF's they work fine. But when I try to open an ASP page it gives me a 404 'File not Found' Error. ASPX pages work fine though they are in a different sub folder.
I have checked the security settings and they are not hidden. Any ideas?
I am trying to put a search by product name function on the following page, i think i have everything write but for some reason the page always says product not found as if the query is not getting past Code:
I have run into a peculiar problem and need a little shove to solve it.
I have an ASP app that tests to see if the browser allows cookies. Complains if cookies are off, otherwise proceeds to a login page.
Using MS-IE 5 or higher - works fine Using IE5 or Safari on a Macintosh (OS 9 or 10) gives a page not found error when trying to detect the cookie setting.
The ASP code use Request.Redirect. I made some htm pages to allow debugging of the redirect and get the same failure.
I could really use some suggestions for making the Mac machines work.
i got an error saying file not found 404 when redirect to html page and i ensure that the file is found in the same directory and in the database : response.redirect results("Url") where Url is the column name in the database that contain the page name
How to find the File not found error in Javascript. My problem is When click the help image button, i want to display the help popup window to the corresponding page, if it is available.
If the help page is not available for the particular page, common 'No help' page should be displayed in popup window. How can i find the file not found error in javascript.
I have moved an asp application from one IIS server to another and now having problems with the app on the second server. All I did was to move the folder as it is.
We have an application that uses WinInet and ASP to transfer files from an application server to a web server via an FTP component based on WinInet. An ASP page calls this component to transfer the requested file then opens the file and loads it into ADODB.Stream in order to download it to the user.
Things work fine up to the point where the Open|Save|Cancel dialog appears. If the user clicks Open or Save, a fair percentage of the time, they get a "File not found" error displaying the file name followed by a bracketed number, e.g. file[1].txt.
I have few asp pages, in each i connect to the DB, same con name in all of the pages. one page return error, as above, I had these pages working allright before, but i had to reinstall the IIS 5.1 because it was corrapted after installing SP2, and now rose this error, what could be the reason, do i have to change settings? of what? the wwwroot folder?
i've made a calendar that uses newsitems from an access database. Every newsitem is a record (newsID, date, title, fact). When the page is loaded for the first time a visitor looks at that page, I want to set the calendar to the newsitem that is closest to the present, but lying in the past. So, today we are the 13th of October. In the database, i've got two items with date "the 2nd of October" and "the 25th of September". The query should return me the 2nd of October. Of course, when that newsitem did not exist, then the query should return me the 25th of September.
i have a view cart page which shows remove an item and remove all item but i also wish to have add item function so i can add quantities for an item in the view cart page. i am not sure the right code for it. below is the remove item code.
if i wanna have an add item code, is there an amendment to do the code below . cos from what i see, its like u can do the opposite function for the code below to add items. Code:
but i cant find anywhere about how to get at these elements when the forms been submitted. for example, if a few of the items have been select, it returns a commar delineated line, but how can i get at, say the 3rd item selected or find out how many items were selected?
i have two dropdowns(dd1 & dd2) in the same page. dd2 items depends on the item index from dd1.when dd1 is onchange, the form will get the dd1 index value and then do a search in DB for the results to be input into dd2.How can i achieved that?
