|
The Saint wrote:
If I were to compare one record against the universe, how much time would I take using SQL Server 2000.
Do you mean: How long would it take to retrieve one row from a table using SQL Server 2000?
It depends on a number of factors. The size of the rows, the index you are using in the filter (the WHERE clause of the SQL statement) or even if there is an index, disk contention (the HDD is a shared resource, other applications will be using it, along with potentially other users of the database) and so on.
If you want to gauge performance of your database then you just have to measure it. Certain things will obviously speed things up. e.g. Placing an index on the columns you are searching on will speed up SELECT statements. Removing indexes will speed up INSERT statements. You have to balance your needs.
Do you want to know more?
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums
|
|
|
|
|
How to execute an exe file without the save, open or autthentification dialog box
|
|
|
|
|
execute an exe...???
You can't on a users local machine...but you can instantiate an exe on the server using location.href
It's frustrating being a genius and living the life of a moron!!!
|
|
|
|
|
I need to know how does one prevent a user from submitting a form in classic asp twice? My page AddClient.asp has all the input fields, and when done, goes to the AddClientProcess.asp page where addition to the database is done. The data type for the id used is auto-numbering. So lets say the user presses the refresh button then the data gets added again becuase of auto numbering.
And how is this done in ASP.NET as well?
Thanks
|
|
|
|
|
Add an OnSubmit handler to your form. In that onsubmit handler, simply make the submit button disabled.
EX:
<html>
<head>
<script language="javascript>
function FormOnSubmit() {
document.forms[0].elements["SubmitBtn"].disabled = true;
}
</script>
</head>
<body>
<form method="post" action="AddClientProcess.asp" onsubmit="FormOnSubmit()">
<input.....
<input type="submit" name="SubmitBtn" value="Save">
</body>
</html>
onwards and upwards...
|
|
|
|
|
hai...
i have date data in my database... In my system i want to track back the data in database using search function between 2 date..for example i want to track data between date1 and date2 in my database...
help me to find the right code
|
|
|
|
|
What database are you using? In SQL Server
select * from table where date between '1/1/2004' and '1/1/2006'
<italic>Work hard and a bit of luck is the key to success. You don`t need to be genius, to be rich.
|
|
|
|
|
i am adding database seperately after installing database is there any way that my database can be bundled with the package ... ty all in advance i am new to dot net and programming
application is in ASP.Net using VB.Net and with SQL server as backend had similar problem with VB 6.0 and SQL Server
thanks again in advance
|
|
|
|
|
Hi. I'm new to asp.net and I wonder if I can get rid of the dropdownlist that my textboxes automatically creates containing strings from previous inputs. I use asp.net and c#
|
|
|
|
|
You can use AUTOCOMPLETE="OFF" inside the FORM tag.
It's frustrating being a genius and living the life of a moron!!!
|
|
|
|
|
|
I'm planning to use google search engine for searching content in my website created by Microsoft CMS 2002.I've tested Google free search code with my website but it doesn't work.
1. Is it possible to use Google Free site search with web sites created by CMS2002?
2. If someone has knownledge with this case,Please recommend me how to search CMS content using Google search.
|
|
|
|
|
It seems that for some reason, the JavaScript function encode() returns an ASCII encoded string regardless of the pages explicit setting to 'utf-8' (I'm testing in Exploder 6).
This means that the ASP.NET Request object will dismiss all the special characters encoded as '%XX', because it expects them to be in the form '%uXXXX'.
Does anyone know, of the correct method to use for encoding to UTF8?
"After all it's just text at the end of the day. - Colin Davies
"For example, when a VB programmer comes to my house, they may say 'does your pool need cleaning, sir ?' " - Christian Graus
|
|
|
|
|
Please help me...
In my system..I want to create function in ASP form where user can search data in between 2 date..For example : user can search data in between 1/02/2005 and 4/02/2005.
thank you..for helping me
help me to find the right code
|
|
|
|
|
but what will the user search for?? I mean, is the required date a field of a table in a database, or something else.
Clarify the question by providing some detail.
|
|
|
|
|
Hai there....
i have a problem in my system...i want to create a running in my asp form..
for example, went i open my asp form the number will count 1 and then went another user open the same asp form, the number will count 2. So the number will kept running in the system...
please help me.;)
help me to find the right code
|
|
|
|
|
Try searching for "Page counter"
<italic>Work hard and a bit of luck is the key to success. You don`t need to be genius, to be rich.
|
|
|
|
|
We are using Ensim 4.0 with MailEnable for Windows 2003. I am having an issue with these programs not automatically creating a virtual directory for the webmail when a new domain is created so I have to find another solution. We need this task to be automated so whenever a new site is setup the webmail will be available.
My options are to find a script or how to write one that will check all the websites and create a virtual directories for any sites that don't already have one for webmail... or implement somekind of redirection where if someone enters a domain name with the text /webmail in it, it will auto redirect to the proper webmail site
This task needs to be automated somehow as we have resellers who add websites and do not have access to setup the needed virtual directory for our webmail site
|
|
|
|
|
is it possible to do the folling with a href i want when they click on the link for it to do the function getfile
<A href="vbscript:getfile("<%server.MapPath(download\PN to AN Conversion Wksht.xls%>")">PRENEED TO ATNEED CONVERSION WORKSHEET</A>
<%end if%>
<script language=vbscript>
function getfile( file)
'cma getfile
Dim objgetfile
Dim bitstream
Set objgetfile = Server.CreateObject("bitstream.bitstream")
bitstream=objgetfile.getfs(file)
Response.ContentType = "application/x-download";
Response.AddHeader("Content-Type", "application/x-download");
Response.AddHeader("Content-Disposition","attachment;filename=example.xls");
Response.BinaryWrite(bitstream);
End Function
</script>
chad
|
|
|
|
|
Why not just make the file the href of the link, ala standard HTML?
<a href="download\PN%20to%20AN%20Conversion%20Wksht.xls"> PRENEED TO ATNEED CONVERSION WORKSHEET</a>
|
|
|
|
|
<A href="download\PN to AN Conversion Wksht.xls">PRENEED TO ATNEED CONVERSION WORKSHEET</A>
<A href="download\PN to AN Conversion Wksht.zip">PRENEED TO ATNEED CONVERSION WORKSHEET</A>
i have both of these links on my websit and the one with the zip file opens a save as box but the one with the .xls file opens excel in my web browser is there a way i can stop excel from opening and force them to download the file
thanks
chad
|
|
|
|
|
What you need to do is open it up on the backend with ASP, PHP, etc. and then send it to the client without showing the data type. Here is an example in Perl:
open(LOG,"<$filename");
@fileholder=<LOG>;
close(LOG);
print "Content-Type:application/x-download\n";
print "Content-Disposition:attachment;filename=$filename\n\n";
print @fileholder;
The important part here is the content type and the content disposition. Application/X-download forces a download instead of trying to open it in the browers. The content disposition keeps the filename, otherwise it is named "document" with no MIME type.
|
|
|
|
|
I know in perl, there is a library called LWP which causes your program to act like a web browser. It will go to the address you supply and gather the html which would normally be sent to the client's browers and saves it as a string. How is this done in ASP or ASP.NET?
|
|
|
|
|
I don't know anything about the extent of LWP, but to retrieve a page from the internet, look at System.Net.HttpWebRequest. I have not used it, so I don't know how well it works.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
