ARCserver Development Summary (1)

 

1. query attributes

As we need to query attributes, we have played the select by attribute In ArcMap again. There are many things that we did not know when we played ArcMap for many years.

1. Field name

(1) file Geodatabase, shapefile, DBASE table, coverage, info table -- "area" (2) Personal Geodatabase -- [area] (3) ArcSDE Geodatabase -- area (4) excel file (.xls file) or a text file (.txt file) -- 'area'

2, string

Strings must always be enclosed within single quotes -- "city_name"> = 'M'

3. wildcard characters (this is cool)

(1) file-based data -- '%' means that anything is acceptable in its place; if you want to search with a wildcard that represents one character, use '_'. (2) Personal geodatabases -- '*' for any number of characters and '? 'For one character.

4. Null Value

"Population96" is null "population96" is not null

5, numeric value

You can query numbers using the EQUAL (=), not equal (<>), greater than (>), less than (<), greater than or equal (> = ), and less than or equal (<=) operators.

It seems that the SHP file value cannot use like, which is different from the traditional relational database.

However, it seems that the personal gdb I use can be used to query numeric fields with the like keyword. I don't know what ESRI is based on.

6. Operators

Calculations can be encoded in queries using these arithmetic operators: + -*/

 

Ii. JS Code

This is abnormal. Try not to make mistakes. Because a system is down and you have to write a lot of JS Code. It is best to make comments.

I was scared to death because the JS Code in one place was wrong and the whole system was not running properly.

 

Iii. Cache

To determine where to use and where no cache is needed, cache is not required for clearing highlighted areas. At that time, I set

As a result, the cache is always cleared and then run back, causing me to be overwhelmed...

 

4. Data sources

It seems that after each data source change (I use personal Geodatabase), do I have to restart my computer? Other data sources are not required. Do not know why?

 

V. Select

Microsoft is abnormal, and does not fully support the standard W3C. It is not a big bug that select does not support innerhtml. Firefox supports it. In the end, there is no way to put select in a div tag pair, changing innerhtml of div is a solution. In fact, there are still many solutions on the Internet, but I prefer to use Div

 

6. About CSS

Webpage layout I use CSS + Div and use simple float, clear, text-align, width, height, however, it seems that the web pages generated by Asp.net can be displayed according to their original ideas under IE6, but they cannot be displayed after moving to IE7! Doctype HTML public "-// W3C // dtd xhtml 1.0 transitional // en" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> This sentence deleted, the effect came out, so far do not know why

 

That's all. make persistent efforts.