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?
i wan to delete 1 of the item from my cart. is there any code to show me on how to delete 1 of the item from the whole list from the cart? cos how they kw which item i m refering to delete.
View Replies View RelatedIs 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"
I have a shopping cart script that I am trying to add a "delete" function to. The code below is taken from this project: Code:
View Replies View RelatedI was able to alternately change the rows colors, but this time lets say I have 10 records in a table taken from my database. How do i put colors on rows where value(certain value from a field) is lets say greater than 10?
Like for example I want to highlight only those student number greater than 10.
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.
I have a program that needs to rely on the date for Sundays on a given month. Here's an example:
Today is 3/18/2005 (Friday). When a user logs into my page, I need to grab the date that the past Sunday fell on (3/13/2005)
If the user logged in on 3/24/2005 (a thursday), I would need to grab 3/20/2005 (that sunday)
Any ideas in vbscript?
Ok let me explain what I am trying to do as easily as I can. I have a table in my access database that I am connecting to. I select a specific id number using my SQL statement. Now what I am trying to do is scroll through that records row and get the column name of that column along with the value of that cell. I hope that isn't to confusing. Now I'm not sure whether this would be done using ASP or done in my SQL statement. Code:
View Replies View RelatedI am working on a college project which has a user area and a page where only a user can access their information and no one elses.I am trying to do a select statment to read specific information from a field without reading any other users info.
The code below is for a drop down menu for payment months i have stored in a database...
Here is what i have got so far...
Code:
Set oRs = Conn.Execute("SELECT [Payment_Period] FROM wages WHERE [Staff_ID]=" & staffid" ORDER BY [fullname]")
I am looking to find out how to grab a specific content on a particular Website and put it on my Website. Of course, I will get permissions before doing so. Any ideas? I have found a sample ASP script that shows how to grab the entire page, but certain sections of the page.
View Replies View RelatedI need to execute different asp programs based on different values of a parameter. For example, if the user inputs ID of 1, program1 needs to be executed automatically, if user inputs ID=2, program2 needs to be executed in the background automatically. How do we do this in asp?
View Replies View RelatedI'm then going to use the answers in my select statement to pull data from the database.
Heres what i have now:
sql= "select * from assistancerequest where datein >= Date() - 7"
heres the problem with it:
it gives no errors but when it shows my output it shows wrong data.
Example:
27/08/04
28/09/04
28/09/04
29/09/04
this is some of what i get. as you can see it counts back 7 days, but its not working because this is from two different months! so it looks like its only checking for the days and not the month. does any of this make sense?
i want to check item before insert new item. let say resID = 1052. before that, i have inserted item which is prodNumber = 100 for resID = 1052. then, still at resID = 1052, i insert another item, prodNumber = 100.
then an error message will come out. but if i insert item, prodNumber = 100 but for resID = 1047, suppose there is no an error message.
that means the sql conditions are at current resID and prodNumber.
i need to connect to sql with different roles. is there any way for do that without passing users or passwords in the connection string?
View Replies View RelatedDoes anyone know a way to find out the numeric value of a day of the week for a specific week, I am trying to display week periods from Mon-Sun. Ive toyed around with is but can seem to come up with anything.
View Replies View Relatedi'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.
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"
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.
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:
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?
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 RelatedIs 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 RelatedI 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?
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 Relatedhow 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;"
<td><% = rs("Problems.TicketNumber") %></td>
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.
View Replies View RelatedI'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 RelatedHow 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?
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?
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 View RelatedHow 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.