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
Access db, one table, 12 or so fields (id, item_name, category, manufacture, price, description etc.)... (ecomm site).
When displaying the details of a particular item I want to display "related items" below it. All I do now is pull info depending on the item id then display the size, dimensions, description, photo etc.
Lets say the item is a Large Blue Widget, i want to display related items... say "Large Widget Covers" or/and "Large Widget Accessories"... you get the idea... cross selling
So, I am looking for ideas on how to simplify the display of related items.
I use the following code to debug my pages and I wanted to make it conditional to only show parameters that contain a value. Is this possible? I tried several ways but I had no luck.
<% ' debugging code ****************************************************************************** FOR EACH QueryString_Parameter IN Request.QueryString Response.Write(QueryString_Parameter & " " & "=" & " ")'this are the field names Response.Write(Request.QueryString(QueryString_Parameter) & "<BR>") NEXT 'debugging code ****************************************************************************** %>
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.
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
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:
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?
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:
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......
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?
how do get ASP to display multiple calls from a database? For example, I can name a variable for a password, then query the database, then call the password variable later in the code and it should display the password from the database.
Code:
strBody = "Here is your login password: " & strPassword
If in the body of this message I want to have a username on the next line, how do you do this in code? I thought you used a &vblt command, but that throws an error.
I thought its more space efficient of displaying the data in multiple columns (let's say 2 columns for now), instead of one loooooooooong column in a table, are there a simple script of coding that can do just that? How about 3 columns?
I have an ASP page where I want to display the 3 most recent records within a database using a SQL query. The problem is that my page which output the results is only showing the first most recent record and not the two past ones aswell.
Am I right in thinking that might be related to the 'loop' function? I know that my SQL code is fine as I have previewed the results from the code and they are correct. Code:
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.
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.
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.
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 & "';")
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.
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.
currently i have an online shopping website that display 12 categories of different items of up to 12 types. well my boss wants related items to be displayed in each of the different items . i am not sure how to start this. is there any special code for it. please advise.you may visit www.mellon.com.sg/shop to view .
I have a basket which people add stuff to that they want to buy. i want a code that allows them to delete the item too. how the basket works is. thy choose a item from stock page and then it adds to a basket table.
I have a multi-dimensional array that I want to delete items from. To do this I display a form and the user clicks some tick boxes. Then on the delete page I check which tick boxes were ticked, say 2,4,7 and 8 (or whatever) and then rebuild the array minus records 2,4,7 and 8 and so on.
Sounds simple enough, but I'm having a real nightmare getting it to work. So my questions is how are others doing this, as my way is obviously very shoddy! I've been looking for examples on the internet, but I've not managed to find one.
I am doing a wed site online shopping system for my school project, which requires some asp coding using vb script. I am new toasp and have no knowledge whatsoever on how to code what i need.
how to add item details into a basket record, once the user clicks the add to basket link.
This is my scenario. On the left of the screen, I have a list of news items, which are updated by the user and inserted into a database, and then they are dynamically displayed on screen from the database. Now what I want is that if a user clicks a hyperlink from the left of the screen on a news item, the relevant text is displayed on the right. What I did up till now was that if I point on a news Item to the left of the screen, I know which item in the recordset it is since I created a counter.
I would like to tap in to all the brilliant minds out there through the means of this question. Is it possible to have a function in asp that returns a collection of items?
If so could you please direct me to some code that may provide some insight to how its done. I've tried using my limited coding capacity but no success.
I'm trying to make a sorting feature for my site which will allow the user to click a drop down menu, click the item they only want displayed, click a button, and then the results will only display that particular item.
I also would like the drop down menu to auto-fill because there are about 20 different categories available. is there and easy way to do this?
I had previously posted this in inetserver.asp.components, I don't think that was the right place... anyways, here is a repost:
We are currently using ASP.NET 2.0 to revamp one of our web applications. Let me try to briefly explain how each page is laid out...
Usually within the page, there are 3 components... The header, the body, and the footer. The header and footer are user controls created by one of our developers, and contain things that all the pages in our web app should contain. This is done to avoid inconsistencies (so you only change the header once instead of changing it 20 times - once for each page).
The developer who created the header user control used Context.Items to store some information. On my pages, I am trying to use PostbackUrl to post form information from one page to another.
The problem I am having is this: Both my pages call the header control. When I use PostbackUrl and PreviousPage, I think the header control from the previous page gets "copied" over to the page I am posting to. So in the second page, I get something like a "dictionary keys have to be unique" exception. I think this is because the Context.Items wasn't "cleared" from the PreviousPage since it was "copied" over, so when the header user control tries to add the same key to Context.Items in the second page, I get an exception.
I temporarily solved this problem by using Request.Form[...] rather than PreviousPage.FindControl(...). I'm not sure if this is the right way to do it, or if it will cause any problems.
So my question is: Can PostbackUrl and Context.Items work together? I guess I could put some try/catch statements in the header control, but unfortunately I don't have access to that file.
i want to fill a drop down box using data retrieved from access database.......
i alread know how to connect and retrieve data from the database but i am a lil unsure as to how i can populate the drop down list with the values retrieved.
