Common Name - Search Result, ALPHABETICAL

SearchResult (Records=246, Time=140ms)
SQL = 
SELECT DISTINCT COMNAMES.ComName AS ResultField1, script, unicodetext
	FROM COMNAMES
	WHERE (COMNAMES.ComName LIKE '''X%' OR COMNAMES.ComName LIKE 'X%')
	and comnames.rank <> 5
	and comnames.script = 'Roman'

Execution Time

203 milliseconds

0 ms	D:\FISHBASEWEB\APPLICATION.CFM
203 ms	D:\FISHBASEWEB\REPORT\GENERATE_COMNAMESALPHALIST.CFM
0 ms	STARTUP, PARSING, & SHUTDOWN

Parameters

URL Parameters:

LETTERSERIES=X

CGI Variables:

AUTH_TYPE=
CF_TEMPLATE_PATH=d:/fishbaseweb/report/generate_comnamesalphalist.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
HTTP_ACCEPT=text/xml,application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_CHARSET=ISO-8859-1,utf-8;q=0.7,*;q=0.7
HTTP_ACCEPT_ENCODING=gzip,deflate
HTTP_ACCEPT_LANGUAGE=en-us,pt;q=0.8,fr;q=0.5,en;q=0.3
HTTP_CONNECTION=keep-alive
HTTP_COOKIE=PHPSESSID=e519106cf3ef6bc5e8e807711bfa2c6e; CFID=937; CFTOKEN=38651446
HTTP_HOST=localhost
HTTP_KEEP_ALIVE=300
HTTP_REFERER=
HTTP_USER_AGENT=Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.5) Gecko/20070713 Firefox/2.0.0.5
PATH_INFO=
PATH_TRANSLATED=
QUERY_STRING=letterseries=X
REMOTE_ADDR=127.0.0.1
REMOTE_HOST=
REMOTE_USER=
REQUEST_METHOD=GET
REQUEST_URI=/report/generate_comnamesalphalist.cfm?letterseries=X
SCRIPT_NAME=/report/generate_comnamesalphalist.cfm
SERVER_NAME=icl_eagbayani2.IRRI.CGIARAD.ORG
SERVER_PORT=80
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache/1.3.19 (Win32)