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:
View Replies
ADVERTISEMENT
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 Related
I'm writing an intranet and I need to put something like a non-editable
scrolling text box on the home page where daily announcements can be placed.
I've tried adding a scrolling text box, but I am not sure how to make it
non-editable.
Is there any way I can fill the textbox using something like
textstream? I would imagine one person in the organisation would be in
charge of adding this text somehow. I'm a bit lost in trying to find the
best method.
View Replies
View Related
I've got a page on a website I'm developing that contains a textarea.
The textarea will allow users of the site to enter a description of an
item.
When they submit the form that contains the textarea, the textarea and
other form elements data are stored in a database. So far so good.
My problem concerns carriage returns, new lines, line feeds or whatever
else you want to call them :-)
I want them preserved, so when the user wants to edit the description of
the item, the format of the description is displayed exaclty as it was
entered.
The problem is that HTML renders the carriage returns as white space, so
when the database is read and the textarea populated with the
description field, the carriage returns are lost.
I have tried the ASP REPLACE function to replace carriage returns with
<br>, but the code below actually displays all the <br>'s.
<%=Replace(myRecordset.Fields.Item("myField").Value,Chr(13),"<br>")%>
I played around with different combinations of chr(13) and vbcrlf and I
managed to get the textarea to display the description as it was entered
with carriage returns, but upon further testing and editing of the
description, because of the REPLACE function, the number of carriage
returns was doubling each time!
View Replies
View Related
I really would like to create a web page containing text and images that I can edit from within the browser environment i.e. once the page has been uploaded I can request it and then edit the text or change the image or add a new image etc. if this is possible and if it is, how can I achieve it?
View Replies
View Related
What is the most simple way to make an editable combobox bounded to the database.
View Replies
View Related
i would like to ask how can i set a field of recordset to be editable?
View Replies
View Related
I have a drop down box(Yes, no) if users select Yes that is suppose to bring up another drop down list with a list of choices.
I was told by someone that the best way to go about is to create the second drop down list and make it read only, but make it editable when Yes from the previous drop down list is selected.
View Replies
View Related
I have a page that has a form on it which has a dropdown list on it. It connect to an sql database and populate the list. What I would like to do is make the list editable so that if the data returned doesnt contain what I want, I can type in the data I require which will then be updated to the database when the form is posted. Hope I've made sense, you may be able to tell.
View Replies
View Related
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>
View Replies
View Related
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 ?
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 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.
View Replies
View Related
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.
View Replies
View Related
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"--> ...
View Replies
View Related
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:
View Replies
View Related
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?
View Replies
View Related
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:" ....
View Replies
View Related
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 Related
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:
View Replies
View Related
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:
View Replies
View Related
The problem concerns 2 tables, cart_products and cart_shoppingcart.
Cart_products contains all the product data (eg, prices, product's key name, etc), but most importantly, it contains the quantity of stock (prod_quantity) for each item.
cart_shoppingcart contains all of the user's items in their shoppingcart, including those that are part of an (customer) order; these have the order_number to differentiate from those that aren't in any order (their Order_number is 'no_order', the others have the order number).
Now, what I want to do is this:
For every item in the order (ie, every entry in cart_shoppingcart that matches the username and order number), take the quantity (x) the customer is ordering, then take the quantity of stock remaining (y), then subtract x from y to create the new stock level (z) and update the appropriate record in cart_products with z (all this with SQl preferably).
I was thinking of using a Do while loop, but realised that it wouldn't work as I'd have to use several SQL statements and then I'd run into a problem the minute ASP reads "objrec.movenext".
View Replies
View Related
I'm trying to pull the last 5 records from my database.
<% j=5
rs.MoveLast
While ((j>0) AND (NOT rs_article.BOF))%>
''Execute HTML and data insertion here
<%rs_article.MovePrevious
j=j-1
Wend%>
Everytime I attempt to run this code, I recieve an HTTP 500- Internal Server Error. It tells me no more than that. I know that my connection settings are OK because when I move forward through the database (first five records), the code executes without error. And yes, my Cursor type is Dynamic.
Alternatively, I would also like to know how to add new recordset to the beginning of a database rather than the end.
View Replies
View Related
I have an Access database with two fields that I would like to group by. The two fields are location and department. Field names are "Location" and "DeptName".
I have the code correct for grouping by location. That code looks like this: Code:
View Replies
View Related
How can I make a ASP-file to a .DLL? The idea is to protect the source from others who use the same IIS. Can I make a ASP-file that calls a .DLL - file with all functionality, or how does it work?
View Replies
View Related
Hi does anybody know if you can make a form
have two actions and how?
View Replies
View Related
how to format the table in order to show 23,567,987 instead of 23567987 , I mean it's very hard to read when there are more than 4 digits.
View Replies
View Related
when you click on it to go to the off site the user name and password will be automaticly inserted to where the offsite is asking for the name and password.
My company deals with insurance companies and we would like to make it to where when our employees go to our intranet and click on a link to one of our carriers it will have the name and password in place for them. i heard its possible and old company did it but I am having so much trouble trying to figure this out.
View Replies
View Related
Its the first time I use ocx on my asp pages. Say I have an ocx which is a dropdown with multiple columns. Before its displayed, I call a method to populate the pulldown, so how do I make the script block talk to the html?
'script block
<%
dim myObject
set myObject=server.createObject("myObject.pulldown")
myObject.Populate(.....)
%>
'HTML block
<Html>
<OBJECT ID="MyObject1" CLASSID="CLSID:12345678-8AB4-4230-A65E-DA15A40F9900"></OBJECT>
View Replies
View Related
I want to know how to make a match for a text , for I'm wan't to search for this in the db . the search i made search only for the exact text user inserted so if the user misspelled the word the search will give him zero result. So i want to seach for any part of the word or if it is aword in aphrase.
View Replies
View Related
When you hover over one of the topic in this forum a box appear with the first few lines of the message in it. How is this created. What events area used to creat something similar and does anyone know of any good website where i can look at a tutorial for it.
I dont even know what they are called so dont know what to search for even on the web as if i write pop up i get something else which i dont think is what i really want to use, or maybe it is.
View Replies
View Related
how to make the session timeout. and where should i put the session timeout.
View Replies
View Related
I have Windows 2000 Server. Running IIS 5. I created a ASP file that connects to a database and when i go to view it, It either says that there is a error in the code on like 106.
Which is only an "End If" command, Or it will say that this page needs to be posted on a web server that supports ASP. Well.. I have indexing service running, And I know for a fact that the code in the page is correct because it works on other 2000 server.
View Replies
View Related
