hta:html applications
An HTA is an executable program for HTML, making it simple, and changing the file *.htm to *.hta.
However, the HTA has its own unique label An HTA is the perfect choice for making small programs.
Here is an example that was
Problem:
In development, you often use Navicat to query the database and modify the values in the database. Today found that the query result is read-only and cannot be modified. General can not change the table to amend I know, but the single
Table or total_sales add an item
Table:
SQL statement:
Copy Code code as follows:
SELECT * FROM
(
SELECT A1. Name, A1. Sales, COUNT (a2.sales) Sales_rank
From Total_sales A1, Total_sales A2
WHERE A1. Sales GROUP by A1. Name, A1.
Before the full text search, the personal homepage can only be fs_title (like '%*% ') field, if the content of fuzzy query, speed is very slow, sometimes also may be an error, today finally have free, the query done, after the test
Try to retrieve 10
1, @ @ROWCOUNT can determine the last line of query operations to get the number of columns;
2. Assign value to variable with set @Pr_id = 13;
3. See if there is a qualifying record if EXISTS (Select name from sysobjects Where name = ' Reminder '
Note: An index needs to be established
Copy Code code as follows:
/*
After testing, in 14,483,461 records to query the 100,000th page, each page 10 records in ascending and descending order the first time is 0.47 seconds, the second
Create proc Sp_publicturnpagewebsite (
@TBName nvarchar (100) = ',--table name, such as pinyin
@PageSize int=10,--Number of records per page, defaults to 10
@CurPage Int=1,--Represents the current page 1
@KeyField nvarchar = ' id '--key field name,
We often use fuzzy queries when we're doing a search.
(Note: Where Name1,name2,name3,name4 is a database field)
1. Methods
Copy Code code as follows:
Sql= "SELECT * from table where"
If name<> "" Then
Sql=sql & "Name1= '" &
Reading the Thought in Java section tonight, it feels good, and I knock it down and post the code for a later review:
It is recommended that you read the idea in Java annotations in advance.
Description Create annotations I am under the first note,
The first kind of regread through the WshShell object
Copy Code code as follows:
Regvalue = CreateObject ("Wscript.Shell"). RegRead ("\xxxx_xxxxxxxx_xxx\xxx\xxxx")
Msgbox (Regvalue)
More action can refer to this article
Copy Code code as follows:
Set ODOM = Wscript.getobject ("http://ipseeker.cn//")
Flag=0
For I=1 to 10
If odom.readystate = "complete" Then
Flag=1
Exit For
End If
Wscript.Sleep 500
Next
If Flag=0 Then
WScript.Echo "Timeout ..."
Can VBScript pass parameters by reference?
For example
function DDD (str)
Str=str & "12345"
End Function
Abc= "54321"
Want to turn ABC into "5432112345" by DDD (ABC)
How to change it?
Answer:
[Ctrl + A All SELECT Note:
It's fun to know how to use VBScript to control the form submission. I tried to write a program that was out of control and angry at me. So he moved out of the search engine, searched and found the answer.
vbscript Control form
How do I deny multiple submissions to the same form?
Formtest.asp
' form Files .
Randomize
' Initializes a random number of seeds .
Num1=rnd ()
' produces random numbers .
Num1=int (26*NUM1) +65
' Modify the range of Num1 so that it
How do I spot ads on the website?
First, we're going to write a adrot.txt to call:
Adrot.txt
redirect
Width 550
Height 60
Border 0
*
Images/chunfengad.gif
Http://www.shenzhaoyang.com
Welcome to the wonderful spring breeze of the shining
Forget.asp
' application .
Bright Days of user password verification
Shining Day
User Password Verification
please fill in your email address correctly , we
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service