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:
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.
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.
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!
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?
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.
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.
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
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 ?
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 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 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.
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:
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?
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.
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:
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:
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".
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.
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:
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?
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.
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(.....)
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.
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.
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.
