Items Retrieved
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
ADVERTISEMENT
Adding Items To An Array - And Keeping Items Previously Added
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:
Emailaddress Retrieved
In retrieve among other data an emailaddress from an SQL table and put it in a tabel (see code below)
How can I make the email address an active mailtolink
greetz
edwin
<ItemTemplate>
<table border="0" width="100%">
<tr>
<td valign="top" width="115px">
<%# DataBinder.Eval(Container.DataItem, "User_name") %></td>
<td valign="top" width="180px">
<%# DataBinder.Eval(Container.DataItem, "User_Email") %></td>
Retrieved Hyperlinks
I added a column to my Access database and defined it as hyperlink.
I added some URL in the fields and i was able to see the underline under each address.
In my code i added the following line :
Response.Write("<td align=right>" & oRS("info").Value & "</td></tr>")
(The hyperlinks defined in my database as info).
I'm able to see the hyperlink when i retrieve all other data but it appears as
#http://www...asp# and with no underline what is the reason and how can i change this ?
Execute Code Retrieved
I haven't started to mess with this yet, but is it possible to store
.ASP source script in a Database field, then use ADO to get the string
from the field and then force the scripting host to interpret that
string from the database and flush it into the buffer for output to
the browser? I was thinking you'd have to use EVAL() on the string or
something...Anyone done this yet?
I was working with Vignette story Server a couple of years ago, and
all of the TCL source script and html is stored completely in the
database, only cached pages are in virtual directories.
The Layout Of Retrieved Data
The link for the photos are requested from the server and so the photo
appears on screen. I can produce a long list by using the response.write ***
& "<br>" or whatever. but is it possible to have it start on the next line
after say 5 photos in a line. i.e. where each - is a photo
- - - - -
- - - - -
- - - - -
rather then
- - - - - - - - - - - - - -
or
-
-
-
-
etc.
Binary Output Retrieved From Db
I'm attempting to read data written to a MySQL database and view it in the browser. I've searched the net for over 3 days and I've seen many posts that say it works great, but it's not working for me. The only thing that displays properly is a text file. Everything else is garbled. I desire to store & read PDF files though. Here's my code:
<%@ Language = VBSCRIPT %>
<% Option Explicit %>
<!-- #include file="dbConn.asp" -->
<!--#include file="adovbs.inc"--> ...
Retrieved Password Display
Im doing a password retrieval page that is working fine, but it wont appear in the html page i want it to.
1)When i dont try and put it on any page the text appears no problemo on a white background.
2)When i attempt to put it on my designed page all that appears is my designed HTML page with none of this text. Code:
How To Allow User To Edit Details Retrieved
I have a feedback form which asks someone to enter their personal details and then submits them to db. There are input, checkboxes and selection boxes on form.
Now I want to allow user to edit this form. When user clicks 'edit', I retrieve all the values from db and populate the text boxes.
What happens with the options and checkboxes. How can I get these to reflect what their values in db? Also I have some drop downs allowing user to select date of birth ie. day drop down, month drop down and year drop down. How do I show user the details we have for them if I'm using drop downs?
Problem W/ Certain Images Being Retrieved From Web Server
I'm having problems retrieving certain images from my web server, such as, Dozier SrB9057.
The problem I'm having is w/, Jr., Sr., II, and III get the drift. How can I get rid of the space in between the last name and Sr?
Now, the Sr is included in the field along with last name.
Here's my code:
strSQL = "Select * from vw_licenseholder_PrimAddr where L_ID = 5940"
Set rs1 = objConn.Execute(strSQL)
ImagePath = "w:" ....
Zooming Images Retrieved From A Database
Am storing images on a database and users query the database to retrieve the images. I want to add a zoom in and zoom out button that will enlarge and reduce the images depending on which button the user clicks.
View Replies View RelatedHo Show A Progress Bar While Records Are Being Retrieved.
While trying to retrieve a large number of records, I would like to show a progress bar to indicate that the user are to wait. How can I do so?
View Replies View RelatedUsing OnClick On A Retrieved Database Data
The user basically queries the database for some data, and I initially retrieve just part of the data matching the query...
I display the Primary Key as a hyperlink..and when the user clicks on a particular retrieved data..i want to display all the contents about that element alone on another new page...
The problem i am facing is that i do not know the syntax to use the onClick event within an ASP code:
How To Make Retrieved Records Editable
I managed to retrieve a table from a database and displays records on the browser using the ASP code below.
but I also want some of the retrieved record be clickable and editable so if a user decides to upadate a record it can be clicked and updated. there are two options either redirect to another page and the selected records will be displayed again to be edited or edit them on the same page,I m not sure how to make the selected records editable using the code below. Code:
Matching Array Index To Values Retrieved From Database
I have this dynamic array(shown below) that I need to match to values (1 - 10) that I am returning from the database via DSN connection object.
The values I need to match are on the same page (in their own table) but I am not sure how to match up the array indexes to these values. I want to be able to display the array result as part of or nested in another table. Code:
Removing Certain Items
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 RelatedNot Multiple Items
How can I get this to work?
<% if objRS2("System") <> "Scholastic" OR "Rolling Readers" OR "Reading Recovery" Then Response.Write "selected" End If%>
Retrive The Items
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.
Compare Two Items
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 & "';")
How To Add Items To A Basket
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.
Add Items To Basket
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 RelatedRelated Items
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 .
View Replies View RelatedRemove Items
Response.Write "<TD>" & "<a href= objRS.Delete>Remove</a>" & "</TD></TR>"
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.
Delete Items
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.
Add Items To A Basket
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.
News Items
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.
Collection Items!
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.
Fetch Only Particular Items
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?
PostbackUrl And Context.Items
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.
How Do I Filling Items In A Drop Down Box In Asp?
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.
Looping Through Forms Items
I have a from with four elements a checkbox and a textfield and two which are hidden. Jobid and userid.
The jobid is written once and the userid is These are dynamic items from the database.
What i want to do is loop through the items and then insert the new values back into the database via an update statement. Code:
Ordering Items Script
Does anyone know of a good script that already exists to do the following? Allow a user to enter a sort orderIf the order exists replace the existing one with the new and bump the old up or down accordinglyIf it doesn't exist add as newMake sure there are no gaps in numbering.
View Replies View RelatedDisplaying Multiple Items
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