I store default information for a particular web site. Everytime a user accesses the page, the table is queried to display the correct links, graphics, etc. What I would like to do is when the web starts (or the first time a user comes to the site) query the database for this information and store it in some session. Then when any other user comes, it pulls from the session rather than quering the database every time.
View RepliesI have an ASP file that eastablishes two connections to a SQL Server and produces two Record Set objects. I am using IIS to develop and the SQL Server database is on the same computer.What I am developing is a message board, so there is a form on which information is submitted. The first connection and recordset puts information from the form into the database table, and the second connection and recordset pulls out 10 records from that same table and should write out some information from the recordset.
The problem is when the form is submitted, it takes forever for the next page to load. I am not even sure how long it takes, because the longest I waited was about 5-10 minutes for it to load, and it still would not load so I closed the browser.
Are the two connections or two recordsets too much for the server to handle, or am I doing something else wrong?
I have a web page with users selecting start and end date/time. This is being done with DTPicker controls. However, I am having trouble setting initial default values for the date and time. When the page loads, it should show yesterdays date in the control along with 00:00:00 for start time and 23:59:59 for end time.
ie. Since today is 4/5, the controls should be set to 4/4/2005 00:00:00 and 4/4/2005 23:59:59. However, Anything I have tried seems to set the default value to the current date and time. Any Ideas?
Do you know any way to load a page, wait for 5 seconds IN SERVER PROCESS, and then redirect in the server side, - not using javascript?
What I pretend is to show a page that loads a .GIF file that appears to be loading something, and after 5 seconds redirect to results page, so users apparently think that a backend proccess has occoured.
How to calculate web page loading time on client and send back result
to server side ?
I would like to display the difference between the logging time
[Session("start"] and the current time [now]. In hours minutes and seconds,
I have tried a couple of things but all I see is gobbledy gook.
I have a website that I subscribe to that allows me to track tasks. I have an extra computer with a big monitor that i want to always display the task list. the problem is after so many hours I get logged out.
I need to need to reload that sign in url every few hours Code:
there i was just windering how do i compare a date/time vlaue in sql server agaisnt the computers' date/time.
for example, if computer date/time is two months or 2 weeks before the database date/time do something
Currently working on a ASP for a friend, which requires the date and
time on it. It pulls in entries from an Access Database with dates and
times in the format of:
"Fri Oct 17 18:02:46 2003"
However my date and time on the ASP page is displayed as:
"Friday, October 17, 2003 18:02:46"
using the script:
"<%Session.LCID = 1033%>
<%=FormatDateTime(Date(), vbLongDate)%>
<%Session.LCID = 2057%>
<%=time()%>"
Anyone know how to change this script, fully or partly to produce the
date and time on the format that's in the access database i.e. "Fri Oct 17
18:02:46 2003" Code:
I am working on a database that collects information about incidents. One of the fields that people enter is the time of the incident. I am trying to convert that string that people enter into a OdbcType.Time and I am at a lost.
View Replies View RelatedHow will we convert the system date & time to other timezone for eg: Eastern Time zone using ASP?
View Replies View RelatedWhen the Form is submitted I use the Date() and Time() functions to put the date and time into the Body part of the e-mail. The time reported is three hours earlier than the time at which the Form is actually submitted.
I understand these functions are evaluated on the server so the server must be in a time zone three hours earlier than where I am . Is there any way I can get the local time at the location where the user is actually located. ?
Any some tools or sample codes drop down asp script execute time and
database connection time ?
I'm trying to do a very simple code that converts the server time into a time zone of your choice.
<%
dim h 'Current Hour
dim i ' Time Zone Increase - add or subtract hours
dim r 'Result Here
h = Hour(Now)
i = + 2
r = h + i
%>
but obvisouly i'm having trouble with the time zone convert.
We have a web server running IIS 5.0 that will not load
any file with an .asp file extension. The server
loads .html just fine, but all links to an .asp file end
up timing out.
Is it possible to create a loading bar with ASP? I am thinking of displaying the loading bar while my customers' requests are being processed (databse update).
View Replies View Relatedif for list box, check box or radio button. in asp. how can i write to make it a default value??
View Replies View RelatedI have a an ASP page on which i wish to load dynamic text by way of a dot text file.
It would be great if something like.-
<txt scr = "MyTextFile.txt">
existed but life aint that simple, or is it?
I'm using a binary stream to send down a file from the web server. I've been having trouble with IE and getting it to recognize my file. I've added the filename as a paramater(?filename=file.jpgw) to handle IE's mime type mangling, but I'm still having trouble with IE's default Save As Type being HTML. When we send down a jpgw (geo-jpeg) file IE wants to save it as an HTML file. I've got the correct filename showing in the Filename box, and if I choose the All Files option from the Save As Type drop down then the file is saved with the correct extension. I'd like to have the All Files option choosen by default. I know it's just a couple of clicks but we have some noivce users that can't seem to get that
View Replies View RelatedI wrote an application that generates reports.It then presents a page where
I click a button [javascript:print()] to open the print page. However, I
have a fixed printer and would like to know how to print to the default
printer without me clicking anything. So the page will just load up and
print. Or when I click a button. I just don't want the select printer screen
to pop up. Much similar to clicking the print button on top of the address
bar in Internet Explorer.
my new site uses default.asp, instead of using index.asp. this is how my old site was done. now i get error 500. is this because it is trying to find index.asp or because my database isn;t workjing properly? i'm tired and being stupid i think. it's reall probably the database, but i just want to make sure in my sleep deprived state.
View Replies View Relatedi want to load an id from a table in the db how do i do that?I am scripting in asp?
i tried this but it wont work.
SQL = "SELECT * FROM users WHERE id=Request("id")"
before displaying any page i want to show message pls wait page is loading. its written on browser. i think meta tag will do this?
View Replies View RelatedI want to make it so that when the user is looking at a rendered ASP page
and they hit the ENTER key, one of the buttons on the form gets "clicked".
In other words I want for the user to not have to click on the button, and
just hit ENTER instead. How do I specify the button?
I have an asp page which takes approx 1 min to load over the network due to how much data it has to deal with.
If someone was to press stop on the browser i assume it doesnt close the connection to the database is there anyway to ensure it does?
This is the code for a combo box, and I would like to make certain value the default value, so that appears unless users select somthing else.
call rs.Open("SELECT * FROM Trim.dbo.luDecisionMaker ORDER BY DecisionMakerName" _
, myCon)
do while not rs.EOF
Response.Write("<OPTION value=" & rs("DecisionMakerID"))
if rs("DecisionMakerID") = nDecisionMaker then
Response.Write(" selected")
end if
Response.Write(">" & _
rs("DecisionMakerName") & "</OPTION>" & Chr(10))
rs.MoveNext
loop
rs.Close
It comes from a table and has PropertyDetailsID(1,2,3,4) and PropertyDetailsname(Fee, 5,10,Other) and for example "Fee" needs to be the dafault value.
I've got an asp page that is set up in with two frames. The problem in question pertains to the main frame which contains a simple 'response.redirect' line that redirects the visitor to a different location. Other than this line, everything else are tags and no asp-oriented code.
I've tested this on a couple of computers, and it works fine. However, there are a few other computers in my office where the redirect just hangs and doesn't load the redirected page (i.e. the status bar states 'Open http://someurl.com' and stays like that)
Is this a problem with using the asp line, or is it a computer setting/browser setting I'm overlooking?
is there a way of loading pages into a div i have created a review server where people can upload folders of work the create a start file, ie an index page on a microsite..
i then want to show this page within my page.,,, i dont want to use frames or i frames, can this be done by loading the page into a div?
im not sure if this is possible, but how do you load a file in asp? Basically i want the user to choose a .mdb file from their file system and then set that file as the "master databse" to be used in the website!
View Replies View RelatedIs there a way of while the ASP script runs some text is in its place saying Script Loading
e.g.
user click
Script Loading
Message Shown
Script done
Message Dissappear
Script Appear
If a new user is added to the database through a webform, and they would usually have immediate access to member only services, is there a way to make them nonactive in a MS access db until an admin activates them?
View Replies View RelatedWhy would the following code execute in VB6 but hang indefinately when
exectuted in an ASP 3.0 page?
Set VLReceive = CreateObject("VLCTI.VLReceive")
This line is invoked in the following context:
<%
Dim VLReceive
Set VLReceive = CreateObject("VLCTI.VLReceive")
Set VLReceive = Nothing
%>
Is it the setup of the virtual directory or something?
I am wanting to compress/zip a file up on the server and email it. Is there a default component that should be installed on the server that will compress/zip files? If not is there FREE ones that anyone would suggest?
View Replies View Related