Thailand
Siam City Cement \r\nPublic Company Limited
ADORecordset_mssqlnative Object
(
[dataProvider] => native
[fields] =>
[blobSize] => 100
[canSeek] =>
[sql] => SELECT md_tgp_id as id,md_tgp_credate as credate,md_tgp_crebyid as crebyid,md_tgp_masterkey as masterkey,md_tgp_status as status,md_tgp_detail_sdate as sdate,md_tgp_detail_edate as edate,md_tgp_detail_pic as pic,md_tgp_detail_picmobile as picmobile,md_tgp_detail_url as url,md_tgp_detail_target as target,md_tgp_detail_subject as subject,md_tgp_detail_title as title,md_tgp_detail_groupname as groupname,md_tgp_detail_metatitle as metatitle,md_tgp_detail_description as description,md_tgp_detail_keywords as keywords,md_tgp_detail_id as contantid FROM md_tgp LEFT JOIN md_tgp_detail ON md_tgp_detail_contantid = md_tgp_id WHERE md_tgp_masterkey='tgp' AND md_tgp_detail_language ='en' AND md_tgp.md_tgp_status = 'Enable' AND md_tgp_site ='1' AND
(DATEDIFF(day,md_tgp_detail.md_tgp_detail_sdate,GETDATE())<=0 AND
DATEDIFF(day,GETDATE(),md_tgp_detail.md_tgp_detail_edate)>=0 )
ORDER BY md_tgp.md_tgp_order DESC
[EOF] => 1
[emptyTimeStamp] =>
[emptyDate] =>
[debug] =>
[timeCreated] => 0
[bind] =>
[fetchMode] => 3
[connection] => ADODB_mssqlnative Object
(
[dataProvider] => mssqlnative
[databaseType] => mssqlnative
[database] => corperatewebsitedb
[dsnType] =>
[host] => corperatewebsiteserver.database.windows.net
[port] =>
[user] => CorperateAdmin
[password] => not stored
[debug] =>
[maxblobsize] => 262144
[concat_operator] => +
[substr] => substring
[length] => len
[random] => rand()
[upperCase] => upper
[fmtDate] => 'Y-m-d'
[fmtTimeStamp] => 'Y-m-d\TH:i:s'
[true] => 1
[false] => 0
[replaceQuote] => ''
[nameQuote] => "
[leftBracket] => [
[rightBracket] => ]
[charSet] => SET NAMES utf8
[metaDatabasesSQL] => select name from sys.sysdatabases where name <> 'master'
[metaTablesSQL] => select name,case when type='U' then 'T' else 'V' end from sysobjects where (type='U' or type='V') and (name not in ('sysallocations','syscolumns','syscomments','sysdepends','sysfilegroups','sysfiles','sysfiles1','sysforeignkeys','sysfulltextcatalogs','sysindexes','sysindexkeys','sysmembers','sysobjects','syspermissions','sysprotects','sysreferences','systypes','sysusers','sysalternates','sysconstraints','syssegments','REFERENTIAL_CONSTRAINTS','CHECK_CONSTRAINTS','CONSTRAINT_TABLE_USAGE','CONSTRAINT_COLUMN_USAGE','VIEWS','VIEW_TABLE_USAGE','VIEW_COLUMN_USAGE','SCHEMATA','TABLES','TABLE_CONSTRAINTS','TABLE_PRIVILEGES','COLUMNS','COLUMN_DOMAIN_USAGE','COLUMN_PRIVILEGES','DOMAINS','DOMAIN_CONSTRAINTS','KEY_COLUMN_USAGE','dtproperties'))
[uniqueOrderBy] => 1
[emptyDate] =>
[emptyTimeStamp] =>
[lastInsID] =>
[hasInsertID] => 1
[hasAffectedRows] => 1
[hasTop] => top
[hasLimit] =>
[readOnly] =>
[hasMoveFirst] =>
[hasGenID] => 1
[hasTransactions] => 1
[genID] => 0
[raiseErrorFn] =>
[isoDates] =>
[cacheSecs] => 43200
[memCache] =>
[memCacheHost] =>
[memCachePort] => 11211
[memCacheCompress] =>
[memCacheOptions] => Array
(
)
[sysDate] => convert(datetime,convert(char,GetDate(),102),102)
[sysTimeStamp] => GetDate()
[sysUTimeStamp] =>
[arrayClass] => ADORecordSet_array_mssqlnative
[noNullStrings] =>
[numCacheHits] => 0
[numCacheMisses] => 0
[pageExecuteCountRows] => 1
[uniqueSort] => 1
[leftOuter] => *=
[rightOuter] => =*
[ansiOuter] => 1
[autoRollback] =>
[poorAffectedRows] =>
[fnExecute] =>
[fnCacheExecute] =>
[blobEncodeType] =>
[rsPrefix] => ADORecordSet_
[autoCommit] => 1
[transOff] => 0
[transCnt] => 0
[fetchMode] =>
[null2null] => null
[bulkBind] =>
[_oldRaiseFn] =>
[_transOK] =>
[_connectionID] => Resource id #1
[_errorMsg] =>
[_errorCode] =>
[_queryID] => Resource id #28
[_isPersistentConnection] =>
[_bindInputArray] => 1
[_evalAll] =>
[_affected] =>
[_logsql] =>
[_transmode] =>
[connectionParameters:protected] => Array
(
)
[customActualTypes] => Array
(
)
[customMetaTypes] => Array
(
)
[metaColumnsSQL] => select c.name,
t.name as type,
c.length,
c.xprec as precision,
c.xscale as scale,
c.isnullable as nullable,
c.cdefault as default_value,
c.xtype,
t.length as type_length,
sc.is_identity
from syscolumns c
join systypes t on t.xusertype=c.xusertype
join sysobjects o on o.id=c.id
join sys.tables st on st.name=o.name
join sys.columns sc on sc.object_id = st.object_id and sc.name=c.name
where o.name='%s'
[maxParameterLen] => 4000
[identitySQL] => select SCOPE_IDENTITY()
[_dropSeqSQL] => drop table %s
[connectionInfo] => Array
(
[ReturnDatesAsStrings] => 1
)
[cachedSchemaFlush] =>
[sequences] =>
[mssql_version] => 12
)
[_numOfRows] => 0
[_numOfFields] => 18
[_queryID] => Resource id #28
[_currentRow] => 0
[_closed] =>
[_inited] => 1
[_obj] =>
[_names] =>
[_currentPage] => -1
[_atFirstPage] =>
[_atLastPage] =>
[_lastPageNo] => -1
[_maxRecordCount] => 0
[datetime] =>
[customActualTypes] =>
[customMetaTypes] =>
[fieldObjectsCache:protected] => Array
(
[0] => ADOFieldObject Object
(
[name] => id
[max_length] =>
[type] => int
[column_source] => id
)
[1] => ADOFieldObject Object
(
[name] => credate
[max_length] =>
[type] => datetime
[column_source] => credate
)
[2] => ADOFieldObject Object
(
[name] => crebyid
[max_length] =>
[type] => int
[column_source] => crebyid
)
[3] => ADOFieldObject Object
(
[name] => masterkey
[max_length] => 20
[type] => varchar
[column_source] => masterkey
)
[4] => ADOFieldObject Object
(
[name] => status
[max_length] => 50
[type] => varchar
[column_source] => status
)
[5] => ADOFieldObject Object
(
[name] => sdate
[max_length] =>
[type] => datetime
[column_source] => sdate
)
[6] => ADOFieldObject Object
(
[name] => edate
[max_length] =>
[type] => datetime
[column_source] => edate
)
[7] => ADOFieldObject Object
(
[name] => pic
[max_length] => 255
[type] => varchar
[column_source] => pic
)
[8] => ADOFieldObject Object
(
[name] => picmobile
[max_length] => 255
[type] => varchar
[column_source] => picmobile
)
[9] => ADOFieldObject Object
(
[name] => url
[max_length] => 2147483647
[type] => text
[column_source] => url
)
[10] => ADOFieldObject Object
(
[name] => target
[max_length] => 50
[type] => varchar
[column_source] => target
)
[11] => ADOFieldObject Object
(
[name] => subject
[max_length] => 2147483647
[type] => text
[column_source] => subject
)
[12] => ADOFieldObject Object
(
[name] => title
[max_length] => 2147483647
[type] => text
[column_source] => title
)
[13] => ADOFieldObject Object
(
[name] => groupname
[max_length] => 2147483647
[type] => text
[column_source] => groupname
)
[14] => ADOFieldObject Object
(
[name] => metatitle
[max_length] => 2147483647
[type] => text
[column_source] => metatitle
)
[15] => ADOFieldObject Object
(
[name] => description
[max_length] => 2147483647
[type] => text
[column_source] => description
)
[16] => ADOFieldObject Object
(
[name] => keywords
[max_length] => 2147483647
[type] => text
[column_source] => keywords
)
[17] => ADOFieldObject Object
(
[name] => contantid
[max_length] =>
[type] => int
[column_source] => contantid
)
)
[databaseType] => mssqlnative
[fieldOffset] => 0
[fieldObjectsRetrieved:ADORecordset_mssqlnative:private] => 1
[fieldObjectsIndex:ADORecordset_mssqlnative:private] => Array
(
[id] => 0
[credate] => 1
[crebyid] => 2
[masterkey] => 3
[status] => 4
[sdate] => 5
[edate] => 6
[pic] => 7
[picmobile] => 8
[url] => 9
[target] => 10
[subject] => 11
[title] => 12
[groupname] => 13
[metatitle] => 14
[description] => 15
[keywords] => 16
[contantid] => 17
)
[dateTimeObjects:ADORecordset_mssqlnative:private] => Array
(
)
[hasDateTimeObjects:ADORecordset_mssqlnative:private] =>
[_typeConversion:ADORecordset_mssqlnative:private] => Array
(
[-155] => datetimeoffset
[-154] => char
[-152] => xml
[-151] => udt
[-11] => uniqueidentifier
[-10] => ntext
[-9] => nvarchar
[-8] => nchar
[-7] => bit
[-6] => tinyint
[-5] => bigint
[-4] => image
[-3] => varbinary
[-2] => timestamp
[-1] => text
[1] => char
[2] => numeric
[3] => decimal
[4] => int
[5] => smallint
[6] => float
[7] => real
[12] => varchar
[91] => date
[93] => datetime
)
)