What Is Request.item??
if i have four option buttons all named r1, what will request.item("r1") give me??.. the "value" of the selected option button or what??..
View Replies
ADVERTISEMENT
For Each Item In Request.Form
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,
name1 relationship1
name2 relationship2
name3 relationship3
With the above formatting, I could write a For... Next loop to insert all
the data into my database: Code:
Writing SQL Using Request.form.item(i)
I am using the following to create an SQL statement
using the names and values from request.form.
The loop goes through each item in request.form
The issue comes in having an additional "and" at the end
of the loop and the value of x3 as not all options may be selected
from the form yet the loop goes through the entire request.form list
I have to add addtional code to strip off the last "and"
and was wondering if there is a way to eliminate the additional
code needed for stripping the "and".
Is there a way to determine which is the very last request.form.item(i)
that has a .key value and use that as x3? I would imagine I would not
need the additional code if there is a way to determine this. Code:
Request.BinaryRead :: Request Object Error 'ASP 0104 : 80004005'
Why does the error below occur whenever the statement Request.BinaryRead Request.TotalBytes) is executed for uploads larger than 100K? I thought the 100K limit applied only to Request.Form. This does not occur with smaller uploads. This is running on an IIS 6 server with full FP2002 extensions.
ERROR:
Request object error 'ASP 0104 : 80004005'
Operation not Allowed
Consecutive Request.Form And Request.BinaryRead
Request.Form and Request.BinaryRead cannot be called after each other as it causes errors.
I need the BinaryRead and I also need to access other form values, but I cannot call them after one another. What do I do?
What Is The Difference Between REQUEST And REQUEST.QUERYSTRING?
What is the difference between these two statements? They seem to do the
same thing...
response.write(request("variable"))
response.write(request.querystring("variable"))
Get Many Item By Using LIKE
how to get many item in LIKE funtion?
Dim count integer
Dim part() as string
For i = o to i =count step 1
Sql = "SELECT TOP 5 T1.A,T1.B " & _
"FROM Table1 " & _
"WHERE T1.A LIKE '" & item[1]& "%' " & _
But the array [1] got error. How to get the array?Please advise me for the above problem.
Get Closest Item
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.
Item Cannot Be Found
in my asp file i get the following error
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"
Item Number
I want to reverse a folder listing, can I referre to a collection with a
item number like in arrays?
ex:
set fs=Server.CreateObject("Scripting.FileSystemObject")
set fo=fs.GetFolder(smp)
for each subfld in fo.subfolders
..
..
next
can I do the FOR statement reverse without putting all folder names into an
array.
Add Quantity For Item
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:
Select Item Tag
i have a list form object on my page:
<select name="item" size="5" multiple="multiple" id="item">
<option>something here</option>
<option>something here</option>
<option>something here</option>
<option>something here</option>
<option>something here</option>
<option>something here</option>
<option>something here</option>
<option>something here</option>
<option>something here</option>
</select>
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?
DropDown Item
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?
View Replies View RelatedCreating A Sent Item
Is there a way of creating a sent record in a outlook users account. I am sending the mail through our exchange SMTP server.If this cann't be done.
View Replies View RelatedSkip Item
I want to skip an item in a loop, and go to the next item, e.g
[vbs]
For Each bla In ble
If bla = "skip" Then
'Skip to next item
End If
Next
[/vbs]
Is this possible, and if so, could you show me how?
Item Cannot Be Found
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 .
View Replies View RelatedAdd Item To Select
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.
Item Cannot Be Found
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;"
<td><% = rs("Problems.TicketNumber") %></td>
Listbox Item
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?
Deleted The Item
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.
View Replies View RelatedPut Value Of A Selected Item
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.
View Replies View RelatedSelect An Item
How do I make an item the selected one based of the info I get from a querystring.
ie:
1 - I pass in a query string containing the color "blue"
2 - I have a drop box that has 30 colors in it (inserted manually)
3 - How do I code to have blue the selected one?
Item Cannot Be Found
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?
Every Second Item Within Loop
How can I in a loop do something to every second item? my code is (extracted from within a loop) :
Code:
dblTotalPrice = cDbl(dblTotalPrice) + cDbl(qtyprice)
itemsincart=itemsincart+qtyselected
shipping= itemsincart*shippingrate
Discount='need to figure out discount
TotalPrice=dbltotalprice+shipping
What I need to change is that for every 2 itemsincart the discount will be half of the second item.
Seach For One Item
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.
<input name="Order card" type="button" id="Order card" onClick="MM_goToURL('top','http://home.amm.org/cards
/search.asp?title=DG006');return document.MM_returnValue" value="Order card">
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.
Remove Item From Cookies..
Is there a way to remove item from cookie collection that has a key to it...
--
Response.cookies("items")("item1") = "111111"
Response.cookies("items")("item2") = "222222"
Response.cookies("items")("item3") = "333333"
Is there a way I can remove items- item2 and rearrange above cookie into
Response.cookies("items")("item1") = "111111"
Response.cookies("items")("item2") = "222222"
[ASP] Arrays - Removing An Item?
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...
Remove A Specific Item
I have a script which creates an array by doing this:Code:
strInputValue = "this will be split into an array"
arrMyArray = split(strInputValue)
This produces an array of 6 (UBound(arrMyArray) = 6).
Is it possible to remove part of the array, so that "into" for example will be removed, such that UBound(arrMyArray) = 5?
Display A Secure Item
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.
View Replies View RelatedGetting Index Of Item From Array
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.
I tried item.getIndex, but that does not work ..
Error: Item Cannot Be Found...
I am receiving the following error when I try calling a variable back from SQL Server 2005.
**********************
ADODB.Recordset error '800a0cc1'
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:
Deleting Item Within A Loop
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:
View Replies View RelatedItem Number Is Already Exists
this is my code. i want to add a new record but if the Item Number is exists, set the Session("item_exists") = True. how to that? Code:
If Request.Form("Submit") = "Save" Then
p_no = Request.Form("prod_no")
p_name = Request.Form("prod_name")
sql = "insert into Products (prodNumber, prodName)"
sql = sql & "values("&p_no&", '"&p_name&"')"
db1con.execute(sql)
Response.Redirect("supplies.asp")
End If