Improving My Current Work
i have an ads website which i have developed for my coursework but want to make it that bit better. Code:
View Replies
ADVERTISEMENT
Improving Waiting Time For Script Execution
I'm writing an application which allow user to manage several mobile/fixed line accounts. The situation that I have now is this:
1) User choose the accounts that he want to manage (it is unlimited number of accounts, could be only 1, could be 1000, could be 10000)
2) He choose from a variety of actions to perform, in my scenario, I'l say he wanted to make changes in the Value Added Service (VAS) section (this is the part that takes the longest time to process the script, there are 27 options in this section)
3) The user will then choose whether he wanted to ADD or CANCEL the VAS that will affect all the previously selected accounts and click on submit.
4) My script will then check whether this user did any transaction before on the same day, and whether if he did the exact same action (says this morning he had perform VAS - ADD to an account, he can't do it again on the same day)
5) If no error detected, my script will then insert all the records into tables.
Now, my biggest problem is in task 4 and 5. These 2 part take the script a very long time to execute. For a transaction that have 50 accounts, it will take me about 72 seconds to have it complete and a staggering 602 seconds when I tested with 500 accounts.
I tried to use MSSQL indexing features but it doesn't seems to work the charm for me or maybe I did it the wrong way. What happens in my script during Task 4 was checking throught VAS Transation table for each selected accounts. This means my loop look something like this: Code:
Recordset To Only Contain Current Items (i.e. If Date Of Item Is Past Current Date)
I have a noticeboard that the user inputs items into. One of those is the date of an event. Once that event has passed I want it to disappear from the page.
So I need to do a comparison with current date to the date in the "datestarted" field. My table is called "notices." Using Access and ASP VBscript.
Asp Does Not Work
i use a IIS 5.1 with win XP with the newest updates etc.
its possible to start aspx and html files but not asp files
what could it be ? what can i check ?
Can It Work Like A CGI?
Can a ASP work like a CGI.(Email Scripts) ? Can a ASP script for email will work, if a Script is on 1 server and form(html.form) is on another server and a thank you page is on 3rd server. Like if u don't know about a CGI there are many websites who give you permission to use their script by editing little bit in yours form and place them on yours server website, there are number of site.
And 1 more thing I want to ask is if some one use a windows server he have a form html on that server, can he run asp script which is on Linux server to get form result on his desired email id.
Get Current Url
Im trying to get the current url where the user is at and store it into a variable. I want this to be done automatically, not when a user clicks a button. Any ideas?
View Replies View RelatedGetting Current URL
a way to get the current URL AND the variables in it, all in one command? There probably isn't, seems to simple, right?
View Replies View RelatedOnAfterPrint Cannot Work
cannot using onAfterPrint in IE 6.0, the page can print but cannot close.
Why??
my code like as below
<body
:
<script language="javascript" type="text/javascript">
<!--
window.print();
//-->
</script>
</body>
I Cannot Get This Inner Join To Work In Asp
<!--#Include Virtual="/bug/adovbs.inc"-->
<title>Bug Status Board</title>
<%
Dim conn
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=SQLOLEDB; Data Source = (local); Initial Catalog =
techsupportBT; User Id = sa; Password="
Set rs = server.CreateObject("ADODB.Recordset")
sSQL="SELECT T.BugIndex, T.[Date Entered], T.DESCRIPTION,"
sSQL= ssql &" T.Company, T.Technician, T.Developer, T.PROGRAM, "
sSQL= ssql &" T.Status, T.PRIORITY, T.[Version Fix], n.noc"
sSQL= ssql &"FROM TSHIGHISSUES INNER JOIN noc ON T.BugIndex =
n.bugindex "
set rs=conn.Execute(ssql)
and this is the error message that I get Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
Incorrect syntax near the keyword 'INNER'
I cannot find an example anywhere that helps with this situation. This works fine in SQL, but for some reason asp is being a pain.
Can't Get CDO Mail To Work
I copied ASP/VBScript code from several sources and adapted it to my page and variables. Here is my current code for implementing CDO:
View Replies View RelatedWhy Sub Procedure Does Not Work
I am trying to construct a sub procedure that concects to db , executes a stored procedure and returns a recordset. Connection to db and executing the stored procedure works fine.
The problem is that when I call the sub in the asp page to be executed the recordset is refused to be returned from the sub and the recordset itself does not appear to be constructed. or in another words the error displayed is: 'object required' --> refering to my recordset --> 'rs'
I do not know why, can any one tell me the reason, I tried much but with no result.
NOTE: For testing puropses I looped through the recordset isnide the sub itself and it worked fine Code:
Global.asa How Does It Work?
Is there somebody who can explain to me how I can use a Global.asa to store Functions and Variables in it? I understand that there are 4 events that can be used in a global.asa : Application_OnStart, Application_OnEnd, Session_OnStart, Session_OnEnd
But still i don't get how i can CALL functions of variables. Because with those 4 things they start all in the beginning or in the end of a session or application.
For example i use an encrypt function in different pages, can i just put it in de global.asa and call it when i need it?
ASP Not Work In W2003
I've just moved all asp file from IIS4/5 to IIS6(2003), but they don't work.It there any trick?
View Replies View RelatedWork Week
I need to provide a pulldown with work weeks displayed.Is there any easy way to do this?
I would like to go 6 months from the current date and show a week as Oct. 11- 15.Which is Monday to Friday.
Validation Does Not Work
I have an asp page. In this there is a form when submit it have to chech if the fields are not emtpy.When it not empty it wil insert into a database an a mail.If a field is empty it send it anyway, it doens't do the validation. Here is a part of my code:Code:
<% if request("action") = "Verzenden" then
datum = request("dtmmeldinghelp")
if datum <>"" then
'I have tried also: if len(datum) <0 then
response.Write("<html>" & "<body>" & "Fout" & "</body>" & "</html>")
else
' here come my sql insert to code and the code for email
' this works fine
%>
Aspfunction Does Not Work
i built this test program:
<HTML>
<HEAD><TITLE>Test</TITLE></HEAD>
<BODY>
the time is <% = Time %>
</BODY>
</HTML>
It does not show the time! very basic probably but not for me.
Button Won't Work
I am trying to add a button to a menu which it's action is conditioned by a session variable. The button shows up fine but I get no action from the button being clicked . The variable does have a valid value. If anyone can help me out with this it would be greatly appreciated. The code follows:
<input TYPE="submit" NAME="Button1" VALUE="Quote Generator">
<SCRIPT LANGUAGE="VBScript" FOR="Button1" EVENT="onClick">
If Session("RVQuoteAuthority") = "Y" then
Response.Redirect(Quote.asp)
else
MsgBox "No Authority"
End If
</SCRIPT>
How CDONTS Work ??
Talking about the cdonts objects.. i want to send the email in windows xp..
i downloaded cdonts.dll and registered it.. but still i am not able to send
the mail.. is it so that i need to set the settings in the Virtual SMTP server
in IIS ?
Does GetObject Work With ASP?
I have not been working with ASP for too long at this time and am not real familiar with a lot of things about ASP. I have searched for articles on the following question but
not come up with any definite answers. Code:
Setting Up IIs To Work With Asp
I am trying to get ASP to work with IIS and i keep getting page cannot be displayed when i try to open asp pages? Do i have some settings wrong somewhere?
View Replies View RelatedDisplay The Current URL
I'd like to know how to display the current URL on the web page as a footer. This seems to be a fairly simple task, but everything i've found on the internet either doesn't work for some reason, or is asp.net specific....
View Replies View RelatedRead Current Url
Is there a way that I can read the current url.
I have an asp page currently such as default.asp?x=1&y=2&z=3
Now I want to keep the existing parameters and attach another parameter
to it and resend to default.asp
As the original parameters are dynamic, and may or may not be
generated, the only way is to read the current url and to simply add my
new parameter such as h=5 to the url.
I don't know how to read the current url.
I tried Request.ServerVariables("SCRIPT_NAME") but that didn't include
the parameters. i.e. it just returned the default.asp
Current Connection
Does anyone know where I can find information about Reading current
connection value from performance counters into ASP page. I wanted to
know how I can call the current connection value in my ASP page
Current Page
how to print or get the name of current page using ASP
View Replies View RelatedUsing ASP To Get Current Page
I'm not sure if someone has requested in the past (I know I've looked for a solution for a while) but I've just developed a very neat way of getting the current page name in ASP:
url = request.ServerVariables("URL")
page = right(url, len(url) - instrrev(url, "/"))
I've finally found a use for the instrrev function
Current Record ID
I've created a form whereby the user fills in there details into a datbase.Once there details have been entered into the database I want to show the Primary Key(there generated ID number).This is the code I have right now
<%
SQLQuery = "Select * from StudentReg"
Set GetDetails=MM_dbconnect_STRING.Execute(SQLQuery)
%>
<%=GetDetails("ID")%>
This however will only show the frist ID number in the database, not the one the user just entered. How do I get the current ID within the new record?
Current Grade
To cut down on maintenance,I'm tracking 500 or so students via their graduation year, rather than their current grade,so I don't have to go in every summer and ratchet up all the grades.
I need to allow the teachers to search for them based on grade(9, 10, 11, or 12).So what I need is to be able to compare the grade chosen on any given day of the year,and have the code figure out what grad year that person is in, assuming a constant of the 4 year plan, and do a SELECT * WHERE gradYear = 2009
The problem is that I could take the nowYear or something, but that changes half-way through the school year (stupid northern hemisphere) and I'm stumped on how to compare more complicated dates.
Get Current Date
i need a button or a link, that when clicked on, grabs the current date. It then puts this date inside a textbox.
View Replies View RelatedGetting Current User In ASP
How can I query the current user logged on to the local machine and store the username, the first name of the person, and the last name of the person in variables?
View Replies View RelatedShow Most Current PDF
I have a ASP page that when a user clicks a link it uses a DLL to stamp a .pdf with a watermark and then display the .pdf in there web browser using the Adobe Reader. This all works fine.
if a user views a pdf and then modifes it if they click the link again it still shows the old version of the file. They have to hit there refresh button to show the changes. How can I make it so my page always displays the lastest version of the PDF and not what is in the cache?
Current Page Url
How can I retrieve the current page url(and parameters/arguments) using ASP code? The current page is an asp search results page so the url includes the page name and the criterion(sorry I don't know what they're called) I had the 'post' method tag on the end.
I need to get it and store it so I have an easy way of getting back to this page at a click of a button a few pages down the track. I've tried using location and history but I'd like to manage it myself.
Current Recordset
ADODB.Recordset error '800a0cb3'
Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype. I am moving my webserver from NT4 using SQL to win2003 using SQL 2003. I get the above error when my asp page does teh line:
Rs.absolutepage = intCurrentPage
I tested teh value of intCurrent page and teh value is 1. Any ideas? The .asp Page works perfectly fine on teh old machine.
What's The Current File
Thingy to call to figure out what the current file is (ie: index.asp)? I thought it was request.servervariables("something") but just can't find it .
View Replies View Related