I've created a db field with Memo type, and I have stored some text with
carriage returns (no html) So the 3 words start on a differnt line. In
access this displays correctly ( each word starts on a new line).
However when I display these on a web page all the words appear on the same
line.
I need the words to be displayed on a seperate line.
I've got a simple template based ASP page which pulls information in one of several different languages from an Access database.
The copy I have in the database is fine. All languages - including the Japanese are displaying correctly when I look at them in Access. However, when I pull the Japanese text from the database, each character renders in the browser as '???????'.
I've tried different HTML encoding, but nothing seems to make a difference.
I am redeveloping a web site and changing the way it is setup, I have a lot of DB content, which is displaying text, as information. I have a number of words which I want to replace with links, and would prefer to do this dynamically as, going through all the text would ot only take ages but if it where updated remembering the links would be a pain.
Like they do on here, when your not logged in! and on loads of other sites. Is it feasible to do a replace statement for 50+ items, or is there a better way?
I have an invisible page counter. I have been successful in getting it to work. However, I'd like to build an administrative password protected web page that shows the count. I'm not sure how to do it. Here's my code for the file and path:
sPath = "D:inetpubwwwrootmywebsite.comdatabasecounter. txt"
Set filesys = CreateObject("Scripting.FileSystemObject")
I have some values I'm passing from one form to another. When I press
the submit button, I want the quantity I have in the text box on form
a to pass to and display in the text box on form b.
form b is on an asp page, and I'm trying to display the values in this
fashion:
myquantity=request.form("quantity")
response.write "<input type =text name=mybox value=" & myquantity &
">"
However, this is not working, and I can't figure out why.
I'm trying to write a web form that will allow users update info from a database table. Everything is working fine, except the display of the one text field from the database (nothing displays. Here's what I'm trying:Code:
<textarea name="AdditionalInformation" cols="32" rows="10" wrap="VIRTUAL"><%=(UpdateRecruiting.Fields.Item("cs_additionalinformation").Value)%></textarea>
what I'm doing wrong?
I'm creating a record display page but one of the fields I need to display is stored as a number. Each number designates a different name (i.e. text). I know this is totally easy, but I can't figure out how to make the text displayed match the number its associated with.
I can do this easily with a drop-down menu, but I need normal text that can't be edited or anything. In other words, the field is 1, 2, 3, or 4. But it's entered by a drop-down where 1=name1, 2=name2, etc. Now I need to display those numbers in the database as the text they are supposed to be.
I have a commercial database written in access and I'm trying to display some images, jpegs, stored in the DB on web page. My code is as follows:
Response.ContentType = "image/jpeg"
sql = "SELECT PartImage FROM Parts WHERE ShortID='AAPTM01'"
Set rs = AMConn.execute(sql)
If not rs.eof Then
PicSize = rs("PartImage").ActualSize
if PicSize > 0 then
Response.BinaryWrite
rs("PartImage").GetChunk(rs("PartImage").ActualSize)
end if
End If
set rs = nothing
All i get on the page is the image not found icon with the red cross in IE.
What could possibly be going on?
I need to display multi-paragraph articles from a field in my database, but every time they display, they come up as one long paragraph with no line breaks, even though there are breaks within the database field.
I am using MS Access 2000 with field "data type" set to Memo and MM Dreamweaver UltraDev. What do I have to do to get the line breaks in the appropriate spots?
i am producing a e-commerce website using ASP. My database is MS access using a database called products.But heres my problem, the database holds the images using a OLE object. But when i come to view the data on the website, i can get the data showing such as price, product id and other information but when i try and view the images from the database on the webpage it comes up all garbled like wildcards.
View Replies View RelatedI know not to store images inside a Db table using the ole method, but I don't know how to call an image to accompany text in a for loop script.I can provide the unfinished script (missing is the coding of the fields: Pic1, Pic2, Pic3, Pic4) for inspection.
View Replies View RelatedI am trying to display a vaule from access (which is set to currency in access) as a currency (2 dp) on a web page. Here is the code: code:
Dim rsDB
Dim strSQL
Set rsDB = Server.CreateObject("ADODB.Recordset" )
strSQL = "SELECT ProductName, ProductPrice FROM Products WHERE ProductID=" & Request("ProductID" )
rsDB.Open strSQL, Application("strConn" )%>
<p><b>Product:</b> <%=rsDB("ProductName" )%></p>
<p><b>£</b><%=rsDB("ProductPrice" )%></p>
<% rsDB.Close %>
Should be easy enough, but I'm just starting out.
I am trying to better a process our dept. now uses. Currently a person updates a Word document throughout the day of of actions items, basically a list of issues with due dates, responsible parties, comments, etc..At the end of the day the file is converted to a PDF and posted on the intranet.
Seems a little stale. Is ASP and a MS access database a good approach to providing real-time reporting to ther client? i.e. a person could push a button labeled "action items" and be returned a printable, decently formatted page?
I have an Access database set up with a number of text fields and a hyperlink field which references a different image per record. I am trying write ASP code to retrieve allt his data and images onto a web page. I have the data but the images are causing a problem.
The code I am using is as follows:
For the data: ....
I have a drop down list which pulls Names from a column called 'Name' from an SQL Server view.
In this view is another column called 'ref' and each person has their own unique ref no.
I have linked a drop down list to the Name column (so user can pick name from the list) but now after selecting a particular name, I want my page to also display the corresponding ref for that particular name underneath.
The ref can be displayed just as text on the page.
Using ASP, I'm fetching a currency datatype from an Access database. When displaying the results, it shows "2" instead of "$2.00"
I know about FormatCurrency, but if the datatype is currency, should it not come out looking like currency?
I am calling the values from a table and displaying them in a table, no biggie, i have not used a for loop to create the Html table, rather i have created it myself using a for loop so i can specify the table values i want.
What i am calling from the table is All of the fixtures for the football games in a season but i want to put a seperator or insert a spece of some sort just to seperate the fixtures by date otherwise it just comes out in a long list of fixtures, no nice on the eyes.
here is the code from selecting the data form the table to displaying it:
Following is a function on button click event to display the details of an user.if i include this function page is not displaying.can u tell me where the mistake is? Code:
View Replies View RelatedI have IIS 5.0 configured in win2k server. When I browse a html I have no problem. But when I browse an asp page, the browser is hanging around.
View Replies View RelatedI am trying to create an XML file but i want to create an ASP page that will eventually save the XML file to the site, but to get the formatting of the file correct first, i want the ASP page to display the XML in the browser window. as an example: Code:
Response.write "<graph caption='Feburary Track Listend To' xAxisName='Date' yAxisName='Total Tracks Listened Too' showNames='1' decimalPrecision='0' formatNumberScale='0'>"
as i have it i can see the line if i view source but its not displaying on the actual page. Once i have the format of the file correct i will need to save it to the disk on the web server but for now i just need to see what will be saved.
I have an XML file, which is a phone list of staff for the firm i work with. I need to display this in an ASP page. Is there a code which will do this? As it will be live and update as the XML file is updated.
View Replies View RelatedI recently downloaded the Baby Web Server, installed it and started it. I was trying to run a website for a printer setup page on the webserver which came from a CD (I didnt modify any thing).
When I was trying to run the website from it gave the headers of the website without the menu and the mean page. and when i was try to run the menu page independently it was showing some thing like: Code:
&eprinter=&action=pause&page=" target="main" title = "">
&eprinter=&action=resume&page=" target="main" title = "">
&eprinter=&action=purge&page=" target="main" title = "">
I dont know if this information is enough.
I have a database full of info and I have display.asp which I want to display 10 items at a time so I have display.asp?page=1, display.asp?page=2, etc.
How do I go about actually filtering the database to only produce 10 results per page? I was trying to use:
results.Move 10
and things like that, but I'm not sure of the best way around this.
I have designed asp pages where all pages have common header and footer. I have added Images to the footer page called as footer.asp.
now i have the footer.asp in another folder
and i call that footer.asp within my index.asp page as a include page.
but the images in the footer.asp are not displaying in the index.asp.
what could be the problem?
I can display information to a webpage from a database and handle the connections etc. My next task is a bit more complicated for myelf. Id like to have a page the pulls information from a record set and displays like this.
down one side
the container numbers
along the top
the products in the containers
the information in the middle would be the amount of product that came on that container.
Im just wondering how the best way to setup my database would be, and the best way to setup the asp webpage. (oh) nearly forgot, it has to repeat the information till all the records are finished but i guess that gos without saying.
I need to solve this as part of a class project. It is designed to simply read a SQL table and display the data in the browser. But it will only show one record based on ID at a time. So if I have multiple records with the same ID such as page.asp?ID=9734, it would show all records using that ID in the browser. Code:
View Replies View RelatedI am trying to display some DateTime data from a SQL Server db using the standard recordset object...objRec("PostTime").value
It displays nothing.
if I have a list of book names and prices and I just want the info to be called onto an HTML page to be displayed how would I do that?
It sounds easy...but who knows with code? :P
I havent' set up the database yet but i suspect it will just be called books.mdb and the table will be called Books.
Fields in the table will be
Name, Type, Condition, Price
I have created a quiz with 14 questions that the user can click a yes radiobutton or no radiobutton. In the code-behind I have set a varable to store the selected items.
What I have taking place is if yesRadiobutton is selected the variable is incremented by 1. then after all the radiobuttons have been added up. i check the variable using an if statement. Code:
I'm looking to display a page and then initiate the downloading of a file.
Basically trying to display a page that says the download will begin
shortly, and if it doesn't, click here. Like what you see at a number
sites.
I found code to initiate the download in a previous posting ("Force Download
fails when I select "Open" but works when I select "Save"", posted Jan 25,
2005). The code works fine in terms of initiating the download. The
problem I've encountered is that the download begins before the page itself
is displayed.
I need to display the contents of an external XML/RSS feed in an ASP page. I have found a couple of scripts that seem to do the trick at:
(URL address blocked: See forum rules)
(URL address blocked: See forum rules)/ow.asp?ASP_Based_RSS_Reader
(any good alternatives will be much welcome)
However, my problem is that the ASP page is part of an Intranet site, so it can only access the Internet (in order to fetch the RSS) via a proxy server.
Can somebody tell me how can I modify the above scripts (or any other that does the same) so the IP/port/login/password parameters can be passed along with the feed URL?
I am currently attempting to convert from PHP to ASP and I am having some difficulties.
Foremost, from my PHP page I have pages that reference HTML source code from a remote page, write it to a local page and then displays it. I haven't been able to find any way to display this HTML source anywhere.
I am doing a project that uses ASP VBScript on Dreamweaver. I try to display data based on the hyperlink on the previous page, where I click on the hyperlink("ID of the informationfile") and the following page will show the detailed information of this particular file.
However, I can't display the next page even if I add the hyperlink and the required parameter on the records that are shown on the first page. I need to ask how can I display the detailed information based on the hyperlink, or in fact the fileID from the first page ??? Code: