FAST :: SQL Select Syntax Tip
This is about SQL syntax use FAST connector to index DB
<description><![CDATA[SQL query to crawl against. Note, any valid SQL is valid here. <br>Use %TIMESTAMP% where last crawl time gets inserted as a datetime value. <br>Use %TIMESTAMPSEC% where last crawl time gets inserted as number of seconds since epoch <br> Examples: <br> Oracle: SELECT * FROM tableName WHERE dateField > TO_TIMESTAMP('%TIMESTAMP%','yyyy-MM-DD"T"hh24:mi:ss') <br>Note that the time stamp format used must be as indicated here. <br>MS SQL Server: SELECT * from tableName WHERE dateField > convert(datetime,'%TIMESTAMP%',126)<br>select * from employees <br>Default: (none)]]></description>
<value>SELECT SampleData2.ID as id, 'UTF-8' as charset, 'zh-traditional' as language, 'zh-traditional;en' as languages, SampleData2.ENG_NAME as engname, SampleData2.CHI_NAME as chiname, SampleData2.CHI_NAME as chiphonetic,SampleData2.ENG_ADDRESS as engaddress, SampleData2.CHI_ADDRESS as chiaddress, SampleData2.DISTRICT as district, SampleData2.FLAG as flag, SampleData2.TEL as tel, SampleData2.LINE_TYPE as linetype, SampleData2.SOURCE as source FROM SampleData2</value>
</parameter>
