Basically i would like to be able to display all the dates that are saturdays and sundays from a table
was going to use day(01/01/2001) = 'saturday'
but that didn't work as the day is still coming up as a number i can't remember how you change the format of the date in the query and not the table
I have XML and XSL documents stored in SQL Server 2000 field. On the asp page i will be getting these documents from the database and then displaying the content of the XML document according to the XSL on the asp page. How can i do this?
Also after getting the documents from the database do i need to store these on the server as .XML and .XSL and then read through these or i can directly read from these document without saving these physically.
Archived XML and XSL documents are attached.
I'm pulling data into ASP from Sybase IQ. When the data is in the
database its displayed correctley: //C://.... When I pull it into an
asp page, the formating changes, and a few of my slashes disappear. Is
there a special method of pulling slahes into asp?
I have this error: [object Error] WinHTTP returned error: 12006 The URL does not use a recognized protocol Code:
View Replies View RelatedSay i have the following names displayed on a page.
ABCD
CDFG
FGHI
Now if i click on ABCD,this name should get displayed in the text boc.I dont want to have a submit button.
I just want to basically select this name and the moment i select this name ,it gets displayed in the text box and thn i hit submit and the value in the text box hits the DB.
I have an access database and users can search through it. Is it possible to display the first 20 results on one page and then display the next 20 on another page and so on and so on..
View Replies View RelatedI have a requirement to display a message and then redirect the controls to
some file, I tried with the below method but its not working, where as If I
use server.transfer or server.execute it works but I cant give relative Url
(it will dynamically genrate), If any one has an alternate way, pls respond.
ShowMessage("Hello World")
Sub ShowMessage(sMessage)
Response.Write "<script> alert("& Chr(34) & sMessage & Chr(34) &" );
</script>"
Response.redirect "xyz.asp"
End Sub
When I retrieve this data into standard text boxes (using ASP/ADO) so that
the user can update/file the following problems occur on what I would call
price fields:
10 << I want 10.00
11.6 << I want 11.60
12.89 << this is fine
My MySQL DB holds prices as decimal(10,3) so I know the decimal data isn't
chopped at this point.
Before the data is displayed in these boxes I created the below function to
parse the data before it is written to the boxes: Code:
I'm sure I'm missing something completely obvious, but I can't figure out what. I have a path to an image file stored in a database. I'm trying to align the image to the right, but nothing seems to be working:
Response.Write("<img src='" & rs("faculty_link_to_photo") &"'>")
dispays the photo without any wrapping, but when I try the following, the images go all over the page:
Response.Write("<img align=""right"" src='" & rs("faculty_link_to_photo") &"'>")
Can someone tell me what I'm doing wrong?
I have ASP (classic) code that writes out a table and sets the <img....> tag
with a virtual directory source, e.g. src='/test/imghold/xyz.png', and the
images do not appear on the IE page. The code is from a production site
that works fine.
We just duplicated the web site to one named test and now
the images do not display. The IMG item is in a TD element of a table.
Also, I looked at the "view source" of the page and it shows the <IMG
src='/test/imghold/xyz.png'...> just fine. I even tried it with different
images and none of them show up.
I have a web page that displays properties for sale. The web page links to a database.
The page shows information in the database and the path to the picture.
The code is:
<p><img border="0" src="file:///D:/HousePics/<%response.write
rsData("id")%>.jpg" width="350" height="262"></p>
the rsData("id")% gives the name of the picture file and appends .jpg to it.
When I browse the page on the local machine the page displays ok and the
graphics show up ok.
When I browse to the page at work the grpahics don't show.
Permissions on the folder 'everyone full control', web sharing is enable
for the site.
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 done Internet presentation for my client and presentation is placed on Brinkster...
Displaying movies is a part of presentation...
Those are .mov files...
As movie container I use Quicktime...
My problem is:
I have to wait to full movie loading...
Wait and wait...
When the movie is loaded then display starts...
Sometimes, it can take a long time...
I want to achieve effect with movie slider in my Quicktime container...
In other words, I want that movie begins to play before the end of full loading...
How can I achieve this?
My code is here:.....
This code displays all the pictures in a defined folder as thumbnails. That works fine. But I would like to have it roll over onto a new page after a certain number of thumbs have been displayed and a back forward message. Code:
View Replies View RelatedI have a loads of records in an Access database relating to publications. The publications come in 3 forms, pdf, Word or .htm so I have fields for each called PDFurl, Wordurl and Publink. What I want to do is, if any of those fields contain a value then display an appropriate icon (which will link to the publication).
I'm ok with the latter part but how do I determine if any of the fields have a value and if so display the relevant icon? Rather than do a load of if then statements I was wondering is there a quicker way of doing this, perhaps using a Case?
Firstly, I am not a programmer, so forgive my complete and utter ignorance of all things ASP related.I am trying to display an RSS feed on a website using some ASP which I found on this website - http://www.tele-pro.co.uk/scripts/rs...d_class_dl.htm
I have downloaded the script and running it locally it works (kind of):-
However, when I put this page on my web server I get an error message:-
http://www.ubsigroup.com/testing/
The ASP file is here:-
http://www.ubsigroup.com/testing/rss...ed_class.1.txt
I have a fairly simple (at least in PHP) request but I can not find how do do it. I've seen things that are kindof what I want but not really. Here is what I want:
I have a ton of data in a DB. I want to pull some of that data and display it in a table. In PHP I would create a SQL query called $Result "(SELCT * FROM whatever)" and produce this code:
I have an asp page in which I am performing the following:
1. Querying a database view
2. Returning rows in to a recordset.
3. Looping thru the recordset and printing the data
4. Before displaying the data I am assigning the values from the recordset
into variables
5. There are 2 entry points to this page both of which would run similar
queries and return similar results
My problem is that for a certain sequence of variable assignments, my data
is not displaying on the screen (even though when i do a response.write I
see that the variable actually has a value in it). In order to fix it I
rearranged the sequence of assignments but since I have two entry points to
the page, it didnot display the data for the other entry point.
I 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 only just noticed this on a peice of work i completed. I used JavaScript and ASP to complete the project. A line of my code -
Response.Write("<td align='right' class='results'>" + MyQuery('Date') + "</td></tr>");
was used to show the date (readign from an access database) on the page but the output which was returend in the browser was -
Thu Jul 25 00:00:00 UTC+0100 2002
instead of the date the format - 25/07/2002
is there anyway i can change this so it displays ont he page exactly how it is shown in the access database
After a user selects the 'answer' hyperlink, the answer will be pulled from the database and displayed.
Then i would like another link once selected to remove the displayed answer from the screen. It is important that the answer is not permanently deleted from the database.
I would like to do this for a series of questions.How can i do this?
I am currently working on ASP. Users will input their contents into a textarea. The problem is that when they input and I retrieve them from the database, they will use the textarea space that was allocated to them and display exactly it is.
For example the text area given is 500px and i only give the display part of 250px. Despite that, it will fill up and scrollbars will appear on my bottom of the webpage and have to scroll to the right.
how i can display all text with the break lines in between yet still confined to the space of 250px.
Is it possible to show different information on a page for different users?
For example a first year student that needs to select modules for this year compared to a second year student how would have to select different modules.
I am trying to display data pulled from a sql db in a text area. The field in the db is of type ntext. I am printing the data using the following code.....
<TEXTAREA name="HTML" COLS=100 ROWS=21>
<%Response.Write(rsCreativeElement("ElementHTML"))%>
</TEXTAREA>
But this is printing as <Long Text>, how can I print the actual data from the db.
I have a form that has a dropdown list. I would like to have a textbox be displayed after the user chooses "other". How can I do this? I would also like the field to go away when the user chances their mind. Is this possible?
View Replies View RelatedI am wondering if this is possible. I have an ASP page that calls a stored
procedure (MSSQL). I want to display the status on the ASP page as each
process is executed on the Stored Procedure and ASP page. For example, when
I connect to the database, show the user that a connection has been made or
in the stored procedure when some tables are updated to show that.
It is not displaying the image thepicture. It is in the directory. I also have a similar bits of code for a other pictures with of and they is working The response write displays the correct reference.
The alt displays instead of the image as though the image has not been found and as I said the Code:
I have a requirement to fire up a PDF brochure for visitors. This is currently done by simply linking the pdf document direct using a javascript popup and hence acrobat is invoked when the link is clicked.
I now have a requirement to trap and record in my database the fact that the brochure was viewed and I can't get my head around how I can do both without getting the user to click 2 links (one to fire up the page with the ASP database call in it and a PDF link on it, and the other to click the PDF).
I have a feeling I could do something clever with host headers, but before I go too far down that deep and murky path I wonder if there is some simpler way I'm overlooking.
Current Code :
I have two folders in inetpub/wwroot. One has all HTML code, the other has
HTML & ASP pages. The pure HTML files show up in IE6 just fine. The other
pages just say done with a blank page. I had servral files that were ASP
pages but only had HMTL code and changed the extension to HMTL and still get
blank pages. Not sure why these pages do not display but the other directory
does.
Both folders have the same rights configuration (scripts &
executables). I am using IIS 5.1 on XP SP2 machine and I Have all updates
installed. If I open these sites in FrontPage they both work fine. I guess
FrontPage handles the code itself and does not use IIS. I am tryint to
relearn my ASP & HTML and I need to get this working,
How do you display all your fields from an SQL table in a web page - BUT make them clickable to make any changes???
E.G. I have a users table with firstname and surname in, but I wish to amend the surname??
I know the code to amend the changes, but dont know how to display the records and make them clickable!!!
I am currently trying to write an internal web stats page that people can view by clicking the relevant link and then it opens a new page that diplays the corresponding record. i.e.
the initial page has a list of Companies, once the company name is clicked on, then a new page is opened, displaying all the relevant information to that company.
DSN = switch_login
table = Client_Info_Table
Any and all help is more than appreciated, am having real trouble getting it to work, I know it probably something simple.
is there a code or query that i can use to display everything but the first record?
here's my sql:
sql = "SELECT * FROM Hotstory ORDER by DateTime DESC"
what i'm using to display:
Response.Write("<a href=' " & rs("URL") & " 'target='_blank'>" &rs("Title")&"-"&rs("DateTime")& "</a>")
the script below writes the next seven dates and their weekday names. it works a treat, until it gets within seven days of the end of a month. when that happens, the number of days shrinks and shrinks until the 1st of the next month, when it goes back to normal.
my question is - what needs to be changed here in order for it continue displaying dates into the next month? Code: