Attaches a value of a property in the database to a variable in ASP

on error resume next

connstr="dbq="+"")+";defaultdir=;driver=;"

set conn="")

connstr

The above is to set up a database connection.

set rs="select * from wherea=rs("userid")

a 'Display method 1, the following is 2

id%>

Try not to use specific words such as time, menu, etc. when naming variables.

It is not displayed because the id is empty, which means that the RS recordset is empty.

There are no eligible records, which means that the recordset is empty.

What is the value of the 100th digit of the data table?

dim a reads the database.

Retrieve the value and assume that it is the title field of a record.

Then b = trim(rs("title"))a = mid(b,100,1) 'Truncation string: 1 character from the 100th onwards.

I don't know if that's what you mean.

Connect to the database by executing SQL statements.

If the bianhao field is an integer.

If the bianhao field is textual.

It depends on what kind of functionality you want to implement and how you implement it.

If you want to read a user's specific settings, then use cookies, so that each user's own settings do not conflict with others, and this thing should be stored on the customer's machine.

If it is some basic settings of **, and it is more important, and you don't want the user to modify it at will, then use file storage on the server side and call it with fso objects.

Stores variables in the session object.

dim xx = the value you found out.

I think the key is that you have to ask how to check, right?

The data types should be consistent, and the types are obviously inconsistent

rs("code")=rcode&""Try it.

1.Put the specific error prompts back and forth to better help everyone answer you.

2.Replace rs ("code"The whole code field is renamed to something else, and it should be OK to test it again.

What type of code is in the database?

If it's a number, if the rcode is a string, it won't work.

Mainly look at the data type of a, a, c, the data type is different, the statement connected to a piece is not the same, if the variables a, b are all string variables, and the field c is also a character format, you can use the method upstairs, if it is not necessary to consider the data type, only the data type is unified, so that it can be connected.

rs("c")=a&b

or rs ("c")=a & "," & b

Since he wants to write like this. Of course rs ("c"It's the text. Then you can connect it.,I'll convert it into a string and store it in.。。