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.
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"
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?
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 .
how can i add item/s to a dropdown from another page. i am currently using window.opener to initial the link between the 2 different pages. i have 2 pages, main and sub page. when i clicked on a button at the main page, it will pop out the sub page. when i clicked on the add button at the sub page, it will add the item into the dropdown list at the main page on the fly.
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;"
if it is possible to narrow in on an item within a listbox of states. For example, right now if I type "W", I will immediately drop down to those states beggining with "W".
However if I type "WI", I go to the top of the list with those states beginning with "I". I would like to continue to zero in on the state by dropping down to those that begin with "WI". Is this possible and if so, how do I go about doing it?
I'm doing an e-inventory system using Dreamweaver MX, ASP. The problem is that I want the system deleted the item that user already choose to use, for example in the store they got 12 keyboard. then when user choose to take 2 keyboard, I want the system automatically state the item left in the store was 10.
I've got this listbox and this text field on an ASP page. Now I want the item I click on in the listbox to appear in the text field and I can't find the code nowhere for what seems to me such an easy thing to do.
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 am taking over a script that was created by someone else. I am trying to do a search for one card that is listed in two different categories, and I only want it to bring the card up once.
Right now it is bring up a page with the same card listed twice. Which is correct, cause it is listed in category 2 and in category 4. I want it to bring up the card from category 4 with the title DG006. And only show the card once.
Is there a way I can remove items- item2 and rearrange above cookie into Response.cookies("items")("item1") = "111111" Response.cookies("items")("item2") = "222222"
I have an array of lets say 10 items, I now want to remove an item, lets say from somewhere in the middle, based on one of the element values equalling a value I specify - is there a "clever" and "quick" way of doing this or, will I need to iterate through it looking for a match, and build another array where I dont find the match etc...
Is there a way to display a Secure / Non-secure item from a ASp web page.Does anyone have any idea what i could type in in the URl or anywhere in the page to break it.
For Each keyb In Request.Form If Left(keyb, 15)="excelFieldName_" Then 'Response.Write(Request.Form(keyb) & "<br />") ReDim Preserve arrExcel(myCounterb) arrExcel(myCounterb) = Request.Form(keyb) myCounterb = myCounterb+1 End If Next
I am able to get the values in the arrExcel array with the code below...
for each item in arrExcel if item <> "None" then
Response.Write item Response.Write("<br>") End if Next
What I would like is to get the index of the item I have found from the array. I then need to get the corresponding index from another array.
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:
This is for my admin section. I have an item called header, which I am displaying through a loop and I want to give my user the option to delete any Header if they wish so. But since i'm calling the Headers through the Loop, I am unable to figure who do i delete them. Code:
I have added a new field in my database for the news items, basically a boolean value (true or false) for the display or hide of a news article. I have simple added to my queries WHERE newsDisplay, and that does the job except now I have one query qhich is actually causing me a small problem, due to the query already having a where clause.
like below:
dbSelectQuery("SELECT * FROM tblNews WHERE newsID ORDER BY newsDate DESC")
So that leaves me a little puzzled as to going about this query which should solve the small issue, I was even thinking is there a way I can use an if operator. Something along the lines of if newsDisplay = true or checked then do something else. Someone must know. I just dont think you can actually use an if statement on a sql query? Any tips would be perfect . PS - The new field I have added is newsDisplay as a yes/no in an access database.
I need to iterate through a submitted form, inserting data on each pass. In the past, I have always used form elements that were named with numbers at the end, like this,