Recommended: Operation must use an updateable query" error solution Microsoft OLE DB Provider for ODBC Drivers (0x80004005) appears under XP operating system. The operation must use an updateable query error. Solution 1. When operating the database asp, an updateable query error must use: 2. Folder>Properties; or, Explorer>Tool>Folder options 3. Do not hook in the view tab to select the use simple
Commonly used variable naming rules in ASP
In ASP programming, if you follow the following variable naming rules, your code will be feasible and maintainable:
General naming rules
Prefix variable type example
b or bln Boolean bSuccess
c or cur Currency cAmount
d or dbl Double dblQuantity
dt or dat Date and Time dtDate
f or flt Float fRatio
l or lng Long lMilliseconds
i or int Integer iCounter
s or str String sName
a or arr Array aUsers()
o or obj COM Object oPipeline
Variable prefix for database objects:
Prefix object type example
cnn Connection cnnPubs
rst Recordset rstAuthors
cmd Command cmdEmployee
fld Field fldLastName
Prefixes related to scope of action:
Prefix description
g_ variable created in Global.asa
m_Variables created in INCLUDE and ASP files
Non-static variables without prefixes, or variables in the process
Share: [ASP] Analysis of the usage of GetRows Everyone should know that Recordset has a GetRows property, but not many of them are actually used, and I have only used it recently! In fact, this property is very simple, which is to output the data set into an array. But it is quite practical. Here I will give you an example to illustrate how to use GetRows. You can think of more usages by learning from one example and learn from it! For example, a classification table T_C