asp+txt universal query system mobile version v2019

The asp+txt score query system is the simplest and most practical query system. It is widely used for performance inquiry, salary inquiry, property fee inquiry, certificate inquiry, etc. The page is suitable for mobile phone, WeChat, tablet and computer access.

Operating Instructions

Front desk access: http://website/directory/ (no installation, no configuration, upload and use directly)

It can be used directly by uploading it. It is recommended to directly upload the code for query and testing after receiving it.

1. Open the file in Notepad and edit the content of conn.asp. For details, please open the file in Notepad and see the Chinese character description inside.

2. Open the excel or wps table, select the data range, note that the column header is the first column, and then copy.

3. Create a new blank text file, paste, save, rename (option name), and change the suffix (.dat).

4. Upload new files to the website database directory using your usual upload method, and the options will be automatically added.

5. To add a new query category, please repeat the previous steps 2-3. Note that the two query conditions must be consistent with those set in conn.asp.

6. To reduce the query category, please delete the corresponding file name in the database directory. To replace the data, repeat steps 1-3 and replace it with the file with the same name.

experience skills

1. It is recommended to use name/student number/admission ticket/ID card/employee number, etc. for query condition setting. It is not recommended to use class, etc., which may have multiple input contents.

2. There may be a URL that is not yours in the program. Just open the corresponding file in Notepad and replace it with your own URL. If you are not sure, don't modify it.

3. Reminder: You can set a password, but it cannot be modified online; you can use your ID card, but please pay attention to the capitalization (for example, if the data is in uppercase, please follow the instructions on the input page).

4. The program itself does not limit the number of records, but more records will affect the speed; it is recommended to keep each database file within a few thousand records. If more records are added, they can be divided into several databases based on classification.

5. You can almost customize Excel (as long as it is a two-dimensional table). You can also right-click -> Excel to open and view the Excel template (remember that direct saving cannot be used, and you need to follow the method I provided)

Exception troubleshooting

If an error occurs, please first check whether the set query conditions are consistent, and check whether the cells contain carriage returns, line feeds, and tab characters;

1. There are many replacement methods. You can use Baidu by yourself: Excel replaces carriage return and line feed, Excel replaces tab character. See more experience.

2. Direct replacement method 1: Excel press Enter to replace Ctrl+H--->Input where to find the content--->Hold down Alt+Numpad 1+Numpad 0--->Replace all--->Save.

3. Directly replace tab characters: Excel press Enter to replace tab characters--->Copy the column containing tab characters--->Paste into Notepad--->Replace tab characters--->Copy the contents of Notepad and paste Return to EXCEL column.

4. After the Excel replacement is completed, follow steps 4-6 to convert Excel again and then upload the replacement. It is to edit excel and re-transmit it, rather than modifying it based on TXT.

3. There may be many ways to replace carriage returns and tab characters, some are direct replacements, some use formulas, WPS to replace "^p", etc. For details, you can download other methods from Baidu.

asp+txt universal query system mobile game update log

2019.07.18 Improvement

1. Use the new 2019 version interface.

2. Pull down and select to display in order of upload. And optimize file suffix recognition.

2016.11.11 Improvement

1. Add custom verification code function (modify a number to control whether to use verification code)

2. Instructions for use. Also: Attached are video tutorial download links and data conversion tool URLs for use.