-
Anonymous users2024-02-10Simple: ids="id")
connstring
set ind = "")
indstring,conn,1,1
Add the following sentence:
if not then
if len(request("page")) = 0 thenipage=1
else ipage=request("page")end if
ipagefor i = 1 to
if not then%>
target="_blank" title="<%=ind("txt_name")%>"><%
if len(ind("txt_name"))<11 then"txt_name"))
else left(ind("txt_name"),11)&".."
end if
end if
if not then
next%>
-
Anonymous users2024-02-09Agree with shijia172. Because you have pagination, that's how it works.
-
Anonymous users2024-02-08" target="_blank"> the information is wrong, I want to change the information, I will copy it.
target="_blank"> the information is incorrect, and I want to change the information to look like there is no error.
800a000d type mismatch...
What is the format of the id value in the database?
What are the specifics.
There should be no error here.
-
Anonymous users2024-02-07'10 records are randomly retrieved from the table.
access database:
select top 10 * from table order by rnd(id)
-
Anonymous users2024-02-06ID is your dynamic part.
Query.
set rs1=
here"id") is the id of the return, e.g. what is the return page of yours? id=22, then here"id") = 22 Note that this is the number type.
Display is used. %=rs1("azs")%>
Clear the button.
if request("hid1")="ok" thenend if
-
Anonymous users2024-02-05Changed the code to Bu. = Chi Min Sui Nachang? id="+id;
-
Anonymous users2024-02-04** Below:
'Import the database connection file, omitted here.
dim pid,url
pid=cint(request("id"))%
-
Anonymous users2024-02-03First, connect to the database, read the database, and set global variables, such as id to sid and url to surl
-
Anonymous users2024-02-02Wouldn't the cursor go backwards and restore it?
When the conditions are met, the loop is stopped and the cursor goes backwards one more time.
-
Anonymous users2024-02-01Is it numbered? If you have one, you can be in where.
The first one is PID
The second one can be numbered.
-
Anonymous users2024-01-31select
fromclass]
whereorder>0
andorder<4
If you want to display the page, use the above SQL statement directly.
Then add the loop to show it and sprinkle it...
-
Anonymous users2024-01-30I won't write it to the idea.
First find out the largest auto-numbered value t, and then generate several random numbers no greater than t.
When the database adds data, it will automatically put the last OID+1, that is to say, you have ten pieces of data, and then after you add a piece of data, the OID will automatically turn back to 11, don't worry about this, if you are talking about reading the last piece of information in the database, there are 2 methods, one is to read the database with SQL statements, and then arrange them in descending order according to the OID, and then the output data is the last record, and the other is to read the database, in ascending order, and then move the pointer to the endto read the last record: >>>More
select * from table name where lab='101'and name='Sulfuric acid', don't know your table structure, so to give you the simplest select, you can talk about your table structure.
The prospect of learning UI is good, and there are many training institutions, so the local people may choose to visit and understand the real teachers and educational strength of the school before making a choice. Share the general development of the UI, I hope it will be useful to you. >>>More
The database is generally composed of many tables, for example, the school builds a database, which can build a student table (including the student's name, age, student number, class, date of birth), a teacher table (including the teacher's name, age, teaching class, teaching category), a report sheet (including the student's student number, and the grades of each subject), etc. These are the ways in which the files are stored in the database, and try to make sure that the items in a table are closely related and have the same attributes, if this condition cannot be met, a table must be built (the redundancy of the built table has 4 levels). In order to meet the user's query needs, we also need to make a number of views, for example, you can make a view of his items have the name of the student, age, grades of each subject, and the teacher of each subject, etc., we can also export new items according to the existing items, for the purpose of simplicity, for example, the view can add an average grade, we add different permissions and roles to each view, and provide it to different people to query to protect the security of the database. >>>More