Show Only One Instance Of Multiple Identical Items?
If I have 30 of the same cmpycd in the column, it brings it all up. I think this is one of those IF/THEN things, but not sure how to impliment it in the code.
All I want to do is show one instance of each unique item that exists in the cmpycd column. If it exists 300 times, I just want to show it once. Then also show the compFN that is also in the same row.
I can make it count and show how many are of each, but I cannot seem to get it to display just one of each. Code:
View Replies
ADVERTISEMENT
how do you do this. 2 tables. one called "Bookings" one called "Rooms"
what kinda query would i use to make it LIST the contents of the ROOM column in the BOOKINGS table, then get remove identical matches in the ROOM column in the ROOMS table?
View Replies
View Related
I think it has to be in this script that I have an error. I am new to ASP so Please help! If I need to include more script .....
View Replies
View Related
How can I get this to work?
<% if objRS2("System") <> "Scholastic" OR "Rolling Readers" OR "Reading Recovery" Then Response.Write "selected" End If%>
View Replies
View Related
I am trying to display records in the following way but i cant get it to work:
Table structure i am trying to achieve
User 1 User2 User3 User4
Car Model Carmodel Carmodel Carmodel
Car Spec Car Spec Car Spec Car spec
Once it has displayed 4 complete records with the data i want it to go to the next table row down and display the rest of the users ie... User 5 User6 User7
And eventuall i will display so many records per page but i will get to that later
View Replies
View Related
I want to submit items from <select multiple> list into database.Should I use arrays?
View Replies
View Related
I want an ASP page with a dropdown and a simple button. Every time the user
chooses an item from the dropdown and clicks on the button i want that value
written below in list and allow user to select more.
Also how can these choices be saved somehow so tha when the user goes to the
next page the choices he made can be written to the database. For example
The choices in the dropdown may be:
London
Dublin
Paris
New York
When the user chooses Dublin I want ti written below the dropdown. Then when
he chooses New York. I want it added to london. so that it displays
Dublin
London
Then when he click next button these two choices are taken over to the next
page where an insert query can be used to insert them into the db.
View Replies
View Related
I was wondering if anyone knows if there is a way to replace multiple items in ASP in a single execution of the function?
Consider this issue:
mytext = "this is not it"
mytext = Replace(mytext, "s", "<strong>s</strong>)
mytext = Replace(mytext, "n", "<strong>n</strong>)
This would produce:
thi<stro<strong>n<s/trong>g>s</stro<strong>n</strong>g> i<stro<strong>n</strong>g>s</stro<strong>n</strong>g> <strong>n</strong>ot it
While it would ideally produce: Code:
View Replies
View Related
I have a form with two multiple select control (I named the first as cbo_source and the second as cbo_target). Once the form is loaded, the cbo_source loads all items from an MS Access database. Once i click the button >>, all the selected fields from the cbo_source should be transferred on the cbo_target control.
Well, I'm done with that using javascript, my problem is how am i going to get all the items from the cbo_target control once i submitted the form to an asp page(add_new_sched.asp)? I can only get items that are selected on the cbo_target, but what i need is to get all items from the cbo_target regardless if it's selected or not. Code:
View Replies
View Related
I have a client that wants all his products on one screen, where people can enter the quantities of every item they want and only have to hit one "Add to Cart" button.
So I have an array of results for each products ID number, and quantity amount for each product. How do I loop through those results and add multiple rows to the database?
View Replies
View Related
How, using asp.net (vb.net), can I remove multiple selected items from a listbox.
View Replies
View Related
I am struggling with how to allow users to modify the quantity of items in their cart. Right now they can only add 1 of each item. To add 2 of the same item they have to add it again which then just makes it so there are 2 seperate instances of that item in the cookie/cart. My hope is to show a text box with the value for each ID so they can modify that qty ID that way......
View Replies
View Related
I have a query on a page that displays the results of a recordset. Each row has a check box that has the table ID associated with the row of data.
I am trying to figure out how do I send every row checked to another page and have that page know the ID's that were checked so the next page can query the table for those ID's and fill out a submission form. I know the form fields I can write so it dynamically names the value based on the script, that part is easy, but trying to figure out how to have the script accept multiple ID's so it can go through each and display the results is not.
Now this is simple if I am just sending one ID to the next page, I can just use a "Post" and append a ?id=xxx to the URL and then do a request.querystring for the ID. Where I am confused is trying to send multiple ID = 's to the next page so it reads more then one ID if more then one was checked on the previous page which 99% of the time it will be.
HERE IS MY MAIN QUESTION:
What should I look up to point me in the right direction to create a classic VBScript/ASP code to parse through the ID's that were checked on the previous page and have the next page query each ID for the data?
I can pretty much figure out how if I know what I am looking to do. I was just looking for some sort of direction that I can pursue to understand how do do this task. What is it I am trying to do? IS there a term or set of terms I need to consider looking up to get examples so I can tweak and write it from there?
View Replies
View Related
I have a funtion that is supposed to add items in my shopping basket.
It's an array, and each time the user is adding an item, it adds the item to the array with its quantity and size.
I've never used arrays before, read about it, etc...
The only problem is that when it adds the new product, it's not keeping the ones which were there before :-(.
I have used REDIM PRESERVE. So can't find out what is wrong.
Below are the funtions that i use for testing and the coding where I implement them. Code:
View Replies
View Related
i am new to asp and web designing, and was wondering how to reload a page so that a different set of images appear, depending on which submit button is pressed. Code:
View Replies
View Related
I have a page that uploads an xml file and reads it into a SQL database. The
page is transactional and aborts if there are any anomalies in the xml.
My problem is that the if I repeat an identical import the transaction
succeeds the first time and then fails the next time. This pattern continues
with subsequent repeats. I have removed all of the ObjectContext.setAbort()
calls but still the onTransactionAbort() sub is called.
View Replies
View Related
I have a script that looks for a phone number. I use an instr to see if
it finds a - for the phone number. I them grab the 3 characters before
and 4 after for the phone number. Works well, except when someone uses
the - in the text.How can look for the second instance of the - if the right 4 characters
past the - are not numeric?
View Replies
View Related
I have a Class and i want to be able to use its instance
example
public class Enrolltest : System.Web.UI.Page
{
MyClass mc = new MyClass();
mc.mymethod();
}
when i do this i get an error telling me there is no name space what should i do .,,.
i dont want to create a dll and add it to assembly and all that stuff.
View Replies
View Related
How to create an instance of Internet Explorer from classic ASP? I want
to create an instance of IE and then subsequently load a webpage through
this object.I am aware of creating web pages through scripting.
Long way to go before I sleep .
View Replies
View Related
How do i lanch a new instance of explorer from withing a current web page.I want to click on a link that take me to a new page in another "window" so that when i close it i see the old window.
View Replies
View Related
.asp, vbscript, ms Access
I want to display a list of records on my page, like this:
California - Los Angeles - Sheraton
- Los Angeles - Meridian
- San Diego - Mercury
Colorado - Denver - ..................
ie. only display first instance of California..
Can this be done..
View Replies
View Related
A three-tier user authentication system was running without a problem for almost a year and now is suddenly dysfunctional. We don't know of any changes to any of the servers. It's quite maddening. The details:
1) We know the COM+ app is instanced on the COM+ server (Win 2000). The component graphic spins when CreateObject is called.
2) The proxy is installed on an IIS server (Win 2000) with delivers the interface, written in ASP, to the client PC.
3) These are the error messages displayed when a method of DAMS is called:
View Replies
View Related
when i try to open an excel spreadsheet using the
following code, the process just hangs IF the spreadsheet
contains macros:
Set objXls = CreateObject("Excel.Application")
objXls.DisplayAlerts = False
objXls.Visible = False
objXls.Workbooks.Open my_excel_path '<-- hangs here
this worked on iis4, but since moving this to iis5 it
fails under the aformentioned circumstances. my guess is
that the macro security has something to do with it as a
dialog box will pop up if macro security is set to medium,
but i'm not sure this is really the problem. if it was,
what profile should change the macro security on the
server? when task manager is opened on the server to see
the hanging task, it shows SYSTEM as the process owner...
any ideas?
View Replies
View Related
My server chokes when i try to use the filesystemobject. I'm running IIS v5.1 on XP Pro and it stalls when i try to create a text file or open one. Here's an example script that fails on the 3rd line.
dim filesys, filetxt
Set filesys = CreateObject("Scripting.FileSystemObject")
Set filetxt = filesys.CreateTextFile("C:InetpubwwwrootAIS estfile.txt", True)
filetxt.WriteLine("Here's the text...")
filetxt.Close
set filetxt = nothing
set filesys = nothing
Am not sure where to start troubleshooting .
View Replies
View Related
How to set timeout for COM+ object instance? If any instance is running more than 15 minutes, I want COM+ application to kill the instance automatically. Is there any way to set this?
View Replies
View Related
need inserting the radio buttons that are checked. Ok I'm trying to insert the user picks but i need help on first renaming each set of radio buttons so they can select one from each group then i need help on inserting the ones selected. Code:
View Replies
View Related
My code retrieves a username and a password from a form. Then this information is compared to some usernames and passwords that are stored in a database. The important thing here is that the comparison must be case sensitive meaning that "passWord" is not the same thing as "password"
I have this code, working fine in access 2003
SQL = "SELECT * FROM users WHERE StrComp(username_column,'" & entered_username_in_form & "',0) = 0 AND StrComp(password_column,'" & entered_password_in_form & "',0) = 0"
but get the following error when I run it against my sql 2005 database.
[Microsoft][SQL Native Client][SQL Server]'StrComp' is not a recognized built-in function name.
I don't know the corresponding t-sql for the query.
View Replies
View Related
I have set up a page specifically for printing, however, I would like to be able to choose certain items on the page that are to be ignored by the printer. For example, the web version of the page may have instructions on how to print, although the version that is printed off does not.
View Replies
View Related
I have multiple list box added to the asp page using <select> tag
I have added items in the list box using recrdset from Education table
Education table={educationid, educationname}
User can choose more than items from the list box. These items gets
added in the user table in field
"edu" seprated by commas.
When User wants to edit his information ...i want that the items in the
list box should be automatically selected which are present in "edu"
field.
View Replies
View Related
does anyone knows how i can layout items retrieved from db such as example from this online shop site . most items retrieeved from db such as Accesss are always in vertical layout.
View Replies
View Related
I have this login that i created. On the sign in process i need to make sure
that no one has already signed up using that certain email or that unique
cnumber.
Ive tried this line:
Set objRS = verify.execute("SELECT id FROM logmein WHERE email='" & email &
"'") or ("', cnumber= '" & cnumber & "';")
than this:
Set objRS = verify.execute("SELECT id FROM logmein WHERE email='" & email &
"'", "' & or & '", "' cnumber= '" & cnumber & "';")
View Replies
View Related
I am doing a wed site online shopping system for my school project, which requires some asp coding using vb script. I am new to asp and have no knowledge whatsoever on how to code what i need.
Could someone please provide me with help, or coding on how to add item details into a basket record, once the user clicks the add to basket link.
View Replies
View Related
I am doing a wed site online shopping system for my school project, which requires some asp coding using vb script. I am new to asp and have no knowledge whatsoever on how to code what i need.provide me with help, or coding on how to add item details into a basket record, once the user clicks the add to basket link.
View Replies
View Related
