Railo Administrator

admin

Railo Dumps

test
stringHallo Variables
url
Scope
test
stringHallo URL
form
Scope
test
stringHallo FORM
request
Scope
variables
Scope
TEST
stringHallo Variables
server
Scope
railo
Struct
release-date
Date Time{ts '2009-04-29 00:00:00'}
version
string3.1.0.015
versionName
stringBarry
state
stringbeta
versionNameExplanation
stringhttp://en.wikipedia.org/wiki/Barry_(dog)
java
Struct
version
string1.6.0_01
totalMemory
number59375616
maxMemory
number532742144
freeMemory
number12176312
vendor
stringSun Microsystems Inc.
49fad7ecf04102c2808eb425c14cf93f
Struct
DEBUGENTRIES
Array
1
Struct
ITOTAL
number31
RECORDED
Date Time{ts '2010-09-02 07:45:05'}
IPADDRESS
string220.181.94.220
CALLEDURL
string/index.cfm?
DEBUGINFO
Struct
pages
Query
Execution Time (ms)0
recordcount2
cachedNo
result
idcountminmaxavgapploadquerytotalsrc
343531313131310031C:\Program Files\Railo\webapps\ROOT\index.cfm
3435410000000C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\templates\debugging\debugging-2-console.cfm
traces
Query
Execution Time (ms)0
recordcount0
cachedNo
result
typecategorytexttemplatelinevarnamevarvaluetime
queries
Query
Execution Time (ms)0
recordcount0
cachedNo
result
nametimesqlsrccountdatasource
timers
Query
Execution Time (ms)0
recordcount0
cachedNo
result
labeltimetemplate
history
Query
Execution Time (ms)0
recordcount2
cachedNo
result
idlevel
343531
343541
2
Struct
ITOTAL
number0
RECORDED
Date Time{ts '2010-09-02 09:04:57'}
IPADDRESS
string78.46.84.179
CALLEDURL
string/index.cfm?
DEBUGINFO
Struct
pages
Query
Execution Time (ms)0
recordcount2
cachedNo
result
idcountminmaxavgapploadquerytotalsrc
3456610000000C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\templates\debugging\debugging-2-console.cfm
3456510000000C:\Program Files\Railo\webapps\ROOT\index.cfm
traces
Query
Execution Time (ms)0
recordcount0
cachedNo
result
typecategorytexttemplatelinevarnamevarvaluetime
queries
Query
Execution Time (ms)0
recordcount0
cachedNo
result
nametimesqlsrccountdatasource
timers
Query
Execution Time (ms)0
recordcount0
cachedNo
result
labeltimetemplate
history
Query
Execution Time (ms)0
recordcount2
cachedNo
result
idlevel
345651
345661
3
Struct
ITOTAL
number0
RECORDED
Date Time{ts '2010-09-02 09:05:06'}
IPADDRESS
string78.46.84.179
CALLEDURL
string/index.cfm?
DEBUGINFO
Struct
pages
Query
Execution Time (ms)0
recordcount2
cachedNo
result
idcountminmaxavgapploadquerytotalsrc
3456810000000C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\templates\debugging\debugging-2-console.cfm
3456710000000C:\Program Files\Railo\webapps\ROOT\index.cfm
traces
Query
Execution Time (ms)0
recordcount0
cachedNo
result
typecategorytexttemplatelinevarnamevarvaluetime
queries
Query
Execution Time (ms)0
recordcount0
cachedNo
result
nametimesqlsrccountdatasource
timers
Query
Execution Time (ms)0
recordcount0
cachedNo
result
labeltimetemplate
history
Query
Execution Time (ms)0
recordcount2
cachedNo
result
idlevel
345671
345681
4
Struct
ITOTAL
number16
RECORDED
Date Time{ts '2010-09-02 09:05:12'}
IPADDRESS
string78.46.84.179
CALLEDURL
string/index.cfm?
DEBUGINFO
Struct
pages
Query
Execution Time (ms)0
recordcount2
cachedNo
result
idcountminmaxavgapploadquerytotalsrc
345721161616160016C:\Program Files\Railo\webapps\ROOT\index.cfm
3457310000000C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\templates\debugging\debugging-2-console.cfm
traces
Query
Execution Time (ms)0
recordcount0
cachedNo
result
typecategorytexttemplatelinevarnamevarvaluetime
queries
Query
Execution Time (ms)0
recordcount0
cachedNo
result
nametimesqlsrccountdatasource
timers
Query
Execution Time (ms)0
recordcount0
cachedNo
result
labeltimetemplate
history
Query
Execution Time (ms)0
recordcount2
cachedNo
result
idlevel
345721
345731
5
Struct
ITOTAL
number46
RECORDED
Date Time{ts '2010-09-01 20:16:59'}
IPADDRESS
string220.181.94.220
CALLEDURL
string/index.cfm?
DEBUGINFO
Struct
pages
Query
Execution Time (ms)0
recordcount2
cachedNo
result
idcountminmaxavgapploadquerytotalsrc
324151464646460046C:\Program Files\Railo\webapps\ROOT\index.cfm
3241610000000C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\templates\debugging\debugging-2-console.cfm
traces
Query
Execution Time (ms)0
recordcount0
cachedNo
result
typecategorytexttemplatelinevarnamevarvaluetime
queries
Query
Execution Time (ms)0
recordcount0
cachedNo
result
nametimesqlsrccountdatasource
timers
Query
Execution Time (ms)0
recordcount0
cachedNo
result
labeltimetemplate
history
Query
Execution Time (ms)0
recordcount2
cachedNo
result
idlevel
324151
324161
6
Struct
ITOTAL
number47
RECORDED
Date Time{ts '2010-09-01 23:49:06'}
IPADDRESS
string66.249.71.204
CALLEDURL
string/index.cfm?
DEBUGINFO
Struct
pages
Query
Execution Time (ms)0
recordcount2
cachedNo
result
idcountminmaxavgapploadquerytotalsrc
327921474747470047C:\Program Files\Railo\webapps\ROOT\index.cfm
3279310000000C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\templates\debugging\debugging-2-console.cfm
traces
Query
Execution Time (ms)0
recordcount0
cachedNo
result
typecategorytexttemplatelinevarnamevarvaluetime
queries
Query
Execution Time (ms)0
recordcount0
cachedNo
result
nametimesqlsrccountdatasource
timers
Query
Execution Time (ms)0
recordcount0
cachedNo
result
labeltimetemplate
history
Query
Execution Time (ms)0
recordcount2
cachedNo
result
idlevel
327921
327931
7
Struct
ITOTAL
number47
RECORDED
Date Time{ts '2010-09-02 00:37:31'}
IPADDRESS
string220.181.94.220
CALLEDURL
string/index.cfm?
DEBUGINFO
Struct
pages
Query
Execution Time (ms)0
recordcount2
cachedNo
result
idcountminmaxavgapploadquerytotalsrc
329741474747470047C:\Program Files\Railo\webapps\ROOT\index.cfm
3297510000000C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\templates\debugging\debugging-2-console.cfm
traces
Query
Execution Time (ms)0
recordcount0
cachedNo
result
typecategorytexttemplatelinevarnamevarvaluetime
queries
Query
Execution Time (ms)0
recordcount0
cachedNo
result
nametimesqlsrccountdatasource
timers
Query
Execution Time (ms)0
recordcount0
cachedNo
result
labeltimetemplate
history
Query
Execution Time (ms)0
recordcount2
cachedNo
result
idlevel
329741
329751
8
Struct
ITOTAL
number1735
RECORDED
Date Time{ts '2010-09-02 01:00:05'}
IPADDRESS
string192.168.2.107
CALLEDURL
string/Application/Silverpop/schChUndeliverables.cfm?RequestTimeout=300
DEBUGINFO
Struct
pages
Query
Execution Time (ms)0
recordcount7
cachedNo
result
idcountminmaxavgapploadquerytotalsrc
3304111735173517351735001735C:\webRoot\Silverpop\CFC\Silverpop.cfc$processChUndeliverables
33037100000310C:\webRoot\Silverpop\CFC\Silverpop.cfc
3304210000000C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\templates\debugging\debugging-2-console.cfm
3303610000000C:\webRoot\Silverpop\schChUndeliverables.cfm
3304010000000C:\webRoot\Silverpop\CFC\Mosaic.cfc$init
3303910000000C:\webRoot\Silverpop\CFC\Mosaic.cfc
3303820000000C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\Component.cfc
traces
Query
Execution Time (ms)0
recordcount0
cachedNo
result
typecategorytexttemplatelinevarnamevarvaluetime
queries
Query
Execution Time (ms)0
recordcount3
cachedNo
result
nametimesqlsrccountdatasource
qUserId31 SELECT account_id FROM cm_silverpop_users WHERE user_id = 'gorlap@clubhotel.com' C:\webRoot\Silverpop\CFC\Silverpop.cfc1hmcclub
qUserId0 SELECT silverpop_marketer_pwd FROM cm_silverpop_users WHERE user_id = 'gorlap@clubhotel.com' C:\webRoot\Silverpop\CFC\Silverpop.cfc1hmcclub
qInsertBatch0 INSERT INTO members_stale_flg_batches (list_id, file_path,list_type) VALUES (12588342, '/download/Master Suppression List - Undeliverables - Sep 2 2010 01-00-05 AM.CSV', 'ch') C:\webRoot\Silverpop\CFC\Silverpop.cfc0hmcclub
timers
Query
Execution Time (ms)0
recordcount0
cachedNo
result
labeltimetemplate
history
Query
Execution Time (ms)0
recordcount8
cachedNo
result
idlevel
330361
330372
330383
330393
330384
330403
330412
330421
9
Struct
ITOTAL
number1921
RECORDED
Date Time{ts '2010-09-02 01:30:06'}
IPADDRESS
string192.168.2.107
CALLEDURL
string/Application/Silverpop/schTransactUndeliverables.cfm?RequestTimeout=300
DEBUGINFO
Struct
pages
Query
Execution Time (ms)0
recordcount7
cachedNo
result
idcountminmaxavgapploadquerytotalsrc
3310811921192119211921001921C:\webRoot\Silverpop\CFC\Silverpop.cfc$processChUndeliverables
33104100000310C:\webRoot\Silverpop\CFC\Silverpop.cfc
3310910000000C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\templates\debugging\debugging-2-console.cfm
3310710000000C:\webRoot\Silverpop\CFC\Mosaic.cfc$init
3310310000000C:\webRoot\Silverpop\schTransactUndeliverables.cfm
3310610000000C:\webRoot\Silverpop\CFC\Mosaic.cfc
3310520000000C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\Component.cfc
traces
Query
Execution Time (ms)0
recordcount0
cachedNo
result
typecategorytexttemplatelinevarnamevarvaluetime
queries
Query
Execution Time (ms)0
recordcount3
cachedNo
result
nametimesqlsrccountdatasource
qUserId31 SELECT account_id FROM cm_silverpop_users WHERE user_id = 'gorlap2@clubhotel.com' C:\webRoot\Silverpop\CFC\Silverpop.cfc1hmcclub
qUserId0 SELECT silverpop_marketer_pwd FROM cm_silverpop_users WHERE user_id = 'gorlap2@clubhotel.com' C:\webRoot\Silverpop\CFC\Silverpop.cfc1hmcclub
qInsertBatch0 INSERT INTO members_stale_flg_batches (list_id, file_path,list_type) VALUES (12588596, '/download/Master Suppression List - Undeliverables - Sep 2 2010 01-30-05 AM.CSV', 'tr') C:\webRoot\Silverpop\CFC\Silverpop.cfc0hmcclub
timers
Query
Execution Time (ms)0
recordcount0
cachedNo
result
labeltimetemplate
history
Query
Execution Time (ms)0
recordcount8
cachedNo
result
idlevel
331031
331042
331053
331063
331054
331073
331082
331091
10
Struct
ITOTAL
number9828
RECORDED
Date Time{ts '2010-09-02 03:00:15'}
IPADDRESS
string192.168.2.107
CALLEDURL
string/Application/Silverpop/schProcessUndeliverableBatches.cfm?RequestTimeout=50
DEBUGINFO
Struct
pages
Query
Execution Time (ms)0
recordcount8
cachedNo
result
idcountminmaxavgapploadquerytotalsrc
3335519812981298129812009812C:\webRoot\Silverpop\CFC\Silverpop.cfc$processUndeliverableBatches
333501161616160016C:\webRoot\Silverpop\schProcessUndeliverableBatches.cfm
333511000001560C:\webRoot\Silverpop\CFC\Silverpop.cfc
3335620000000C:\webRoot\Silverpop\CFC\Mosaic.cfc$postUndeliverableEmails
3335710000000C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\templates\debugging\debugging-2-console.cfm
3335410000000C:\webRoot\Silverpop\CFC\Mosaic.cfc$init
3335310000000C:\webRoot\Silverpop\CFC\Mosaic.cfc
3335220000000C:\Program Files\Railo\webapps\ROOT\WEB-INF\railo\context\Component.cfc
traces
Query
Execution Time (ms)0
recordcount0
cachedNo
result
typecategorytexttemplatelinevarnamevarvaluetime
queries
Query
Execution Time (ms)0
recordcount17
cachedNo
result
nametimesqlsrccountdatasource
qBatches62 SELECT batch_id, list_id, file_path, list_type FROM members_stale_flg_batches WHERE status = 0 C:\webRoot\Silverpop\CFC\Silverpop.cfc2hmcclub
qUserId16 SELECT account_id FROM cm_silverpop_users WHERE user_id = 'gorlap2@clubhotel.com' C:\webRoot\Silverpop\CFC\Silverpop.cfc1hmcclub
qUserId0 SELECT silverpop_marketer_pwd FROM cm_silverpop_users WHERE user_id = 'gorlap2@clubhotel.com' C:\webRoot\Silverpop\CFC\Silverpop.cfc1hmcclub
qUserId0 SELECT account_id FROM cm_silverpop_users WHERE user_id = 'gorlap2@clubhotel.com' C:\webRoot\Silverpop\CFC\Silverpop.cfc1hmcclub
qUserId16 SELECT silverpop_ftp_pwd FROM cm_silverpop_users WHERE user_id = 'gorlap2@clubhotel.com' C:\webRoot\Silverpop\CFC\Silverpop.cfc1hmcclub
qUpdateUndeliverables0 UPDATE members SET stale_flg = 1 WHERE lower(email1) IN ('x10x11@optusnet.com.au','haufa.alshehi@hotmail.com','45645612123@163.com','pockli521@163.com','suh@yahoo.com','fmalzadjali@gmail.com','osalia.megawati@yahoo.com','qiujungan@163.com','jeco198202@hotmail.com','clintonchugg@gigpond.com','betinhacorre@hotmail.com','henryd161@hotmail.com','renato.takino@elcid.com.br','huangfeng@hotmail.com','jhsueh9555@yahoo.com.tw','bdghtf@yahoo.com','glenn.ait@ybe.com.au','impresosvec@yahoo.com','zhoujun@hotmail.com.cn','terecanlas@gmail.com','paul.yeatman1@three.com','ginglai777@hotmail.com','kavconlsults@bigpond.com','marjoaaa@coqui.net','ggusi-999@yahoo.com','olzahk@petrokemya.sabic.com','jose@aguerri.com','tecno_frio@hotmail.ocm','16952526@qq.com','chindh@yahoo.com','amiee@creativenails.co.nz','rwks@yahoo.com','dr.virgilio_villacorte@yahoo.com','falshomon@sa.qatarairways.com','1546721435@163.com','cqvk@yahoo.com.cn','moreclub@yahoo.cn','henriquegalvao@yahoo.com.r','dr.mendoza1@yahoo.com','zainal.amn@acretakaful.com','51072200@qq.com','mc_bustamanteheros@yahoo.com','markinglis@zubairautomotive.com','mansourrabeaa@hotmail.com','d.afonso@dvantel.com','ajlnascimento@ig.com.br2','manueliscoa@hotmail.es','manuis@yahoo.com','mini@huweihk.com','dominiclimo@aol.com','brycepratt@xtra.co.nz','allyhedan@hotmail.com','a.hm.yehia@yahoo.com','ixbioia@hotmail.com','ljolincai@163.com','dsadler13@verizon.net','aroldoestradalopez@yahoo.es','ji_kuaw@yahoo.com.cn','baojj123@163.com.cn','zhangmaoyo@163.com','fumeco1234@yahoo.com','darrell@stelformers.co.nz','1245421222@qq.com','manueliscos@hotmail.com','wanglei@163.com.cn','wangliwen@hotmail.com','lorraine.wargren@det.nsw.edu.au','sunmjmj@yeah.net','gustavocastellan@hotmail.com','cpaz.cpaz@yahoo.com','pedrom@yahoo.com','cyswellloo@yahoo.com.hk','ffsadjlkj@163.com','pedrogon@yahoo.es','dboyle@au.helmann.net','qinliang3627@163.com','894789654648@qq.com','evelyn20mkk@yahoo.com','sumesh.nair@gwiss.ae','fsdjakl@126.com','amir.emam@cib.com.eg','miaochunchao@163.com','mariadrsotoo@gmail.com','jcarlos@eltman.com.br.4','jcarlos@eltman.com.br3','maryluzaramburo@yahoo.com.mx','rodrigo.hostt@cemig.com.br3','201252250@qq.com','searlesmech@bigpond.com','dechun@yahoo.com','manuelisso@hotmail.es','rcv@manilateacher.com','christinalay@yahoo.com','ly.zhsy-2003@163.com.cn','bernardcgo@yahoo.com','wangning1988@163.com.cn','fafasjkldj@163.com','linday0745@yahoo.com','4545610@163.com','fsjlkd@163.com','4587855@qq.com','5236598@qq.com','qingdaowq@hotmail.com','farah@lineafarh.com','saqri.1@hotmail.com','maysonetm@hotmail.com','maridavi@centalsa.com.co','regina_ang@hotmail.com1','henrik_matzel@hotmail.com','fecoiv@yahoo.com','bryant1126@hotmail.com.cn','peter.halaseh@halmed.omc.ua','namhor@bigpond.net.au','lwilroxvm@yahoo.com','maryu_00@yahoo.com','ffsdjakl@163.com','christin_ar@hotmail.com','luciano.gama@aondensiels.com','maisco@yahoo.com','llili@yahoo.com.cn','tremedo.g.trabilla@yahoo.com','miaowang@hotmail.com','wangqiong1427@163.com','carlos_cadiz@yahoo.com','caoxueqin@163.com','tamergamal-6@hotmail.com','gd.rnteriorsconst@gmail.com','elsokary.t@yahoo.com','cbstampa@globo.com.br.2','m1barrera@yahoo.com','tecno_frio1@hotmail.com','526413@qq.com','daiige@msn.com','tsengchungjen@yahoo.com.tw','1361107843@139.com','jeff.box@au.breauveritas.com','4515648978@qq.com','liangjian904@yahoo.com.cn','liwee_2009@hotmail.com.cn','amina2020@yahoo.com','pizarroesther@yahoo.com','velasquez11@yahoo.com','xiedabing@tom.com','wahlc4@yahoo.com','1301391789@139.com','26588435@163.com','vascodz@iol.pt','tareenosman@yahoo.com','rodrigo.hostt@cemig.com.br2','fabiogouveia@terra.com.br','stevenchua@yahoo.com','paojbm@hotmail.com','ncting@yahoo.com','qilixinx6408@yahoo.com','60296282@qq.com','griffinhe@126.com','eoscree@streamyx.com','liangkui@163.com','remonda_rafaat@yahoo.com','renxubiao@163.com','henriquegalvao@yahoo.com.br12','mbio@bancocapital.com.do','jjbonillap@yahoo.com','wlr661@hotmail.com','barahona11@yahoo.com','mkwan@matest.com.my','lkjhgf@yahoo.com','simongwo66@hotmail.com','ebanicek@iinet.net.au') C:\webRoot\Silverpop\CFC\Silverpop.cfc0hmcclub
qInsertStaleFlagUpdate0 INSERT INTO members_stale_flg_updates (SELECT NULL AS UPD_ID, MEMBER_ID, 1 AS STL_FLG, SYSDATE AS DT, 'C' AS type FROM members WHERE lower(email1) IN ('x10x11@optusnet.com.au','haufa.alshehi@hotmail.com','45645612123@163.com','pockli521@163.com','suh@yahoo.com','fmalzadjali@gmail.com','osalia.megawati@yahoo.com','qiujungan@163.com','jeco198202@hotmail.com','clintonchugg@gigpond.com','betinhacorre@hotmail.com','henryd161@hotmail.com','renato.takino@elcid.com.br','huangfeng@hotmail.com','jhsueh9555@yahoo.com.tw','bdghtf@yahoo.com','glenn.ait@ybe.com.au','impresosvec@yahoo.com','zhoujun@hotmail.com.cn','terecanlas@gmail.com','paul.yeatman1@three.com','ginglai777@hotmail.com','kavconlsults@bigpond.com','marjoaaa@coqui.net','ggusi-999@yahoo.com','olzahk@petrokemya.sabic.com','jose@aguerri.com','tecno_frio@hotmail.ocm','16952526@qq.com','chindh@yahoo.com','amiee@creativenails.co.nz','rwks@yahoo.com','dr.virgilio_villacorte@yahoo.com','falshomon@sa.qatarairways.com','1546721435@163.com','cqvk@yahoo.com.cn','moreclub@yahoo.cn','henriquegalvao@yahoo.com.r','dr.mendoza1@yahoo.com','zainal.amn@acretakaful.com','51072200@qq.com','mc_bustamanteheros@yahoo.com','markinglis@zubairautomotive.com','mansourrabeaa@hotmail.com','d.afonso@dvantel.com','ajlnascimento@ig.com.br2','manueliscoa@hotmail.es','manuis@yahoo.com','mini@huweihk.com','dominiclimo@aol.com','brycepratt@xtra.co.nz','allyhedan@hotmail.com','a.hm.yehia@yahoo.com','ixbioia@hotmail.com','ljolincai@163.com','dsadler13@verizon.net','aroldoestradalopez@yahoo.es','ji_kuaw@yahoo.com.cn','baojj123@163.com.cn','zhangmaoyo@163.com','fumeco1234@yahoo.com','darrell@stelformers.co.nz','1245421222@qq.com','manueliscos@hotmail.com','wanglei@163.com.cn','wangliwen@hotmail.com','lorraine.wargren@det.nsw.edu.au','sunmjmj@yeah.net','gustavocastellan@hotmail.com','cpaz.cpaz@yahoo.com','pedrom@yahoo.com','cyswellloo@yahoo.com.hk','ffsadjlkj@163.com','pedrogon@yahoo.es','dboyle@au.helmann.net','qinliang3627@163.com','894789654648@qq.com','evelyn20mkk@yahoo.com','sumesh.nair@gwiss.ae','fsdjakl@126.com','amir.emam@cib.com.eg','miaochunchao@163.com','mariadrsotoo@gmail.com','jcarlos@eltman.com.br.4','jcarlos@eltman.com.br3','maryluzaramburo@yahoo.com.mx','rodrigo.hostt@cemig.com.br3','201252250@qq.com','searlesmech@bigpond.com','dechun@yahoo.com','manuelisso@hotmail.es','rcv@manilateacher.com','christinalay@yahoo.com','ly.zhsy-2003@163.com.cn','bernardcgo@yahoo.com','wangning1988@163.com.cn','fafasjkldj@163.com','linday0745@yahoo.com','4545610@163.com','fsjlkd@163.com','4587855@qq.com','5236598@qq.com','qingdaowq@hotmail.com','farah@lineafarh.com','saqri.1@hotmail.com','maysonetm@hotmail.com','maridavi@centalsa.com.co','regina_ang@hotmail.com1','henrik_matzel@hotmail.com','fecoiv@yahoo.com','bryant1126@hotmail.com.cn','peter.halaseh@halmed.omc.ua','namhor@bigpond.net.au','lwilroxvm@yahoo.com','maryu_00@yahoo.com','ffsdjakl@163.com','christin_ar@hotmail.com','luciano.gama@aondensiels.com','maisco@yahoo.com','llili@yahoo.com.cn','tremedo.g.trabilla@yahoo.com','miaowang@hotmail.com','wangqiong1427@163.com','carlos_cadiz@yahoo.com','caoxueqin@163.com','tamergamal-6@hotmail.com','gd.rnteriorsconst@gmail.com','elsokary.t@yahoo.com','cbstampa@globo.com.br.2','m1barrera@yahoo.com','tecno_frio1@hotmail.com','526413@qq.com','daiige@msn.com','tsengchungjen@yahoo.com.tw','1361107843@139.com','jeff.box@au.breauveritas.com','4515648978@qq.com','liangjian904@yahoo.com.cn','liwee_2009@hotmail.com.cn','amina2020@yahoo.com','pizarroesther@yahoo.com','velasquez11@yahoo.com','xiedabing@tom.com','wahlc4@yahoo.com','1301391789@139.com','26588435@163.com','vascodz@iol.pt','tareenosman@yahoo.com','rodrigo.hostt@cemig.com.br2','fabiogouveia@terra.com.br','stevenchua@yahoo.com','paojbm@hotmail.com','ncting@yahoo.com','qilixinx6408@yahoo.com','60296282@qq.com','griffinhe@126.com','eoscree@streamyx.com','liangkui@163.com','remonda_rafaat@yahoo.com','renxubiao@163.com','henriquegalvao@yahoo.com.br12','mbio@bancocapital.com.do','jjbonillap@yahoo.com','wlr661@hotmail.com','barahona11@yahoo.com','mkwan@matest.com.my','lkjhgf@yahoo.com','simongwo66@hotmail.com','ebanicek@iinet.net.au')) C:\webRoot\Silverpop\CFC\Silverpop.cfc0hmcclub
qUpdateUndeliverables0 UPDATE ghr_members SET stale_flg = 1 WHERE lower(email1) IN ('x10x11@optusnet.com.au','haufa.alshehi@hotmail.com','45645612123@163.com','pockli521@163.com','suh@yahoo.com','fmalzadjali@gmail.com','osalia.megawati@yahoo.com','qiujungan@163.com','jeco198202@hotmail.com','clintonchugg@gigpond.com','betinhacorre@hotmail.com','henryd161@hotmail.com','renato.takino@elcid.com.br','huangfeng@hotmail.com','jhsueh9555@yahoo.com.tw','bdghtf@yahoo.com','glenn.ait@ybe.com.au','impresosvec@yahoo.com','zhoujun@hotmail.com.cn','terecanlas@gmail.com','paul.yeatman1@three.com','ginglai777@hotmail.com','kavconlsults@bigpond.com','marjoaaa@coqui.net','ggusi-999@yahoo.com','olzahk@petrokemya.sabic.com','jose@aguerri.com','tecno_frio@hotmail.ocm','16952526@qq.com','chindh@yahoo.com','amiee@creativenails.co.nz','rwks@yahoo.com','dr.virgilio_villacorte@yahoo.com','falshomon@sa.qatarairways.com','1546721435@163.com','cqvk@yahoo.com.cn','moreclub@yahoo.cn','henriquegalvao@yahoo.com.r','dr.mendoza1@yahoo.com','zainal.amn@acretakaful.com','51072200@qq.com','mc_bustamanteheros@yahoo.com','markinglis@zubairautomotive.com','mansourrabeaa@hotmail.com','d.afonso@dvantel.com','ajlnascimento@ig.com.br2','manueliscoa@hotmail.es','manuis@yahoo.com','mini@huweihk.com','dominiclimo@aol.com','brycepratt@xtra.co.nz','allyhedan@hotmail.com','a.hm.yehia@yahoo.com','ixbioia@hotmail.com','ljolincai@163.com','dsadler13@verizon.net','aroldoestradalopez@yahoo.es','ji_kuaw@yahoo.com.cn','baojj123@163.com.cn','zhangmaoyo@163.com','fumeco1234@yahoo.com','darrell@stelformers.co.nz','1245421222@qq.com','manueliscos@hotmail.com','wanglei@163.com.cn','wangliwen@hotmail.com','lorraine.wargren@det.nsw.edu.au','sunmjmj@yeah.net','gustavocastellan@hotmail.com','cpaz.cpaz@yahoo.com','pedrom@yahoo.com','cyswellloo@yahoo.com.hk','ffsadjlkj@163.com','pedrogon@yahoo.es','dboyle@au.helmann.net','qinliang3627@163.com','894789654648@qq.com','evelyn20mkk@yahoo.com','sumesh.nair@gwiss.ae','fsdjakl@126.com','amir.emam@cib.com.eg','miaochunchao@163.com','mariadrsotoo@gmail.com','jcarlos@eltman.com.br.4','jcarlos@eltman.com.br3','maryluzaramburo@yahoo.com.mx','rodrigo.hostt@cemig.com.br3','201252250@qq.com','searlesmech@bigpond.com','dechun@yahoo.com','manuelisso@hotmail.es','rcv@manilateacher.com','christinalay@yahoo.com','ly.zhsy-2003@163.com.cn','bernardcgo@yahoo.com','wangning1988@163.com.cn','fafasjkldj@163.com','linday0745@yahoo.com','4545610@163.com','fsjlkd@163.com','4587855@qq.com','5236598@qq.com','qingdaowq@hotmail.com','farah@lineafarh.com','saqri.1@hotmail.com','maysonetm@hotmail.com','maridavi@centalsa.com.co','regina_ang@hotmail.com1','henrik_matzel@hotmail.com','fecoiv@yahoo.com','bryant1126@hotmail.com.cn','peter.halaseh@halmed.omc.ua','namhor@bigpond.net.au','lwilroxvm@yahoo.com','maryu_00@yahoo.com','ffsdjakl@163.com','christin_ar@hotmail.com','luciano.gama@aondensiels.com','maisco@yahoo.com','llili@yahoo.com.cn','tremedo.g.trabilla@yahoo.com','miaowang@hotmail.com','wangqiong1427@163.com','carlos_cadiz@yahoo.com','caoxueqin@163.com','tamergamal-6@hotmail.com','gd.rnteriorsconst@gmail.com','elsokary.t@yahoo.com','cbstampa@globo.com.br.2','m1barrera@yahoo.com','tecno_frio1@hotmail.com','526413@qq.com','daiige@msn.com','tsengchungjen@yahoo.com.tw','1361107843@139.com','jeff.box@au.breauveritas.com','4515648978@qq.com','liangjian904@yahoo.com.cn','liwee_2009@hotmail.com.cn','amina2020@yahoo.com','pizarroesther@yahoo.com','velasquez11@yahoo.com','xiedabing@tom.com','wahlc4@yahoo.com','1301391789@139.com','26588435@163.com','vascodz@iol.pt','tareenosman@yahoo.com','rodrigo.hostt@cemig.com.br2','fabiogouveia@terra.com.br','stevenchua@yahoo.com','paojbm@hotmail.com','ncting@yahoo.com','qilixinx6408@yahoo.com','60296282@qq.com','griffinhe@126.com','eoscree@streamyx.com','liangkui@163.com','remonda_rafaat@yahoo.com','renxubiao@163.com','henriquegalvao@yahoo.com.br12','mbio@bancocapital.com.do','jjbonillap@yahoo.com','wlr661@hotmail.com','barahona11@yahoo.com','mkwan@matest.com.my','lkjhgf@yahoo.com','simongwo66@hotmail.com','ebanicek@iinet.net.au') C:\webRoot\Silverpop\CFC\Silverpop.cfc0vhr_members
qUpdateBatch0 UPDATE members_stale_flg_batches SET status = 1 WHERE list_id = 12588596 C:\webRoot\Silverpop\CFC\Silverpop.cfc0hmcclub
qUserId31 SELECT account_id FROM cm_silverpop_users WHERE user_id = 'gorlap@clubhotel.com' C:\webRoot\Silverpop\CFC\Silverpop.cfc1hmcclub
qUserId0 SELECT silverpop_marketer_pwd FROM cm_silverpop_users WHERE user_id = 'gorlap@clubhotel.com' C:\webRoot\Silverpop\CFC\Silverpop.cfc1hmcclub
qUserId0 SELECT account_id FROM cm_silverpop_users WHERE user_id = 'gorlap@clubhotel.com' C:\webRoot\Silverpop\CFC\Silverpop.cfc1hmcclub
qUserId31 SELECT silverpop_ftp_pwd FROM cm_silverpop_users WHERE user_id = 'gorlap@clubhotel.com' C:\webRoot\Silverpop\CFC\Silverpop.cfc1hmcclub
qUpdateUndeliverables0 UPDATE members SET stale_flg = 1 WHERE lower(email1) IN ('13335096333@133.com','05312450@63.com','13312906666@189.com','guanxiujuan@gmail.cn','bj_sunway@foxmail.com.cn','renshijie@sohoo.com','danbonabon@com.ph','mengminghui@sina.com','zhangjinyu@sina.com','5645@sina.com','13971275759@1426.com','13306055663@189.com','guoerdong2005@sohoo.com','hongquan@sina.com','83322@sina.com','xiaolwbl@smail.com','lidianhong@cycq.com.cn','mail2sunjian@gmail.com.cn','ftyingcat@263.com','alanzhong1989@hotmai.com','xujian@sina.com','aharwitz@atlasla.com','jcyu@iwhr.com','tding@cument.com','zxllaw@162.com','wangzj@bank.com.cn','lihu@sina.com','liu1209@sina.com','robaya@pacbell.net','hhj5851@sohoo.com','zhang@126.com.cn','qddgsb@reah.net','oct_xzy@otmail.com','susanna@hibox.hinnet.net','wfyy650@189.com','liranff@sian.com','muge@altioklartv.com','kcrawford@technip.com','jinn6269@sina.com','ouyang@sina.com','huangxuezhu@qinghua.edu.cn','sxsy517@1663.com','chen7777@263.com','wr0304@sina.com','6546546@sina.com','yangzhengyun@sina.com','bbm@sdq-lawyers.com','yolanda.delpilar@hoege.com','wuxiaolu@sina.com','13906007008@139.com','bjkhl@yahoo.com','houchenggang@sina.com','guot@sina.com','fasdjkl@sina.com','zhangliren@sina.com','jiaoshouxia@sina.com','marco.morezzi@gentespeciale.it','belladelli.cristiano@pozziconfezioni.com','fengyt@sina.com','cbuck23@eq.edu.au','jhaoph@gmail.com.ph','chark4@eq.edu.au','hbate14@eq.edu.au','windorah@bluemax.com.au','wilfredo_racelis@yahoo.com','chapmanclan77@bigpond.com','rhegil.almarinez@pmintl.com','rcjee@three.com.au','therices@versa.com.au','jeff.mahoney@raywhite.com','huchangqiao@sina.com','wangfengquan@sina.com','iyss@sina.com','mayan88@sina.com','susana.dequeiros@sdq-lawyers.com','jianxin_gao@sina.com','ropatucci@yahoo.com','fanwei@sina.com','zhangjunhui@sina.com','mustafa.kurt@sinpas.com.tr','zhoujie@sina.com','4646546@sina.com','pengwei@sina.com','wangguannan@sina.com','hanjiebing@sina.com','qitongsheng@sina.com','zhanghui@sina.com','dshan7@eq.edu.au','gilberto.costa@cartocer.pt','maricriswee@gmail.com.ph','sfiel18@eq.edu.au','drank5@eq.edu.au','eric.buchanan@tc.ind.co.uk','chenshibiao@sina.com','songchengguang@sina.com','liguona@sina.com','gheid3@eq.edu.au','dpatz2@eq.edu.au','jfitz40@eq.edu.au','kvand3@eq.edu.au','bstar9@eq.edu.au','amurr53@eq.edu.au','mgprichard@perthsleep.comau','ncamsmith@kpmg.com.au','zenzest2001@yahoo.com','shanagolden@bigpond.com','yegang@sina.com','cbrya27@eq.edu.au','rmadd16@eq.edu.au','jeremy.liston@listonlanders.com.au','13336009111@zj165.com','xiuyuns@sina.com','guoxuelin@sina.com','serhan.ercivelek@sinpas.com.tr','sunyg@chinatietong.com','7szj@yahoo.com.cn','ucarerdal@windowslive.com','ysw-qd@163.com','zxcv2009@sina.com','fernandochn@yahoo.cn','liyong2010@sina.com','zhangshubing@sina.com','caglar.yurtturk@admdlaw.com','wanghuixia@sina.com','andyandjanreeves@goglemail.com','fanshaohong@yahoo.com.cn','fosijie@yahoo.com.cn','liziyu@sina.com','lihua@sina.com','rongtong@162.com','456465@sian.com') C:\webRoot\Silverpop\CFC\Silverpop.cfc0hmcclub
qInsertStaleFlagUpdate0 INSERT INTO members_stale_flg_updates (SELECT NULL AS UPD_ID, MEMBER_ID, 1 AS STL_FLG, SYSDATE AS DT, 'C' AS type FROM members WHERE lower(email1) IN ('13335096333@133.com','05312450@63.com','13312906666@189.com','guanxiujuan@gmail.cn','bj_sunway@foxmail.com.cn','renshijie@sohoo.com','danbonabon@com.ph','mengminghui@sina.com','zhangjinyu@sina.com','5645@sina.com','13971275759@1426.com','13306055663@189.com','guoerdong2005@sohoo.com','hongquan@sina.com','83322@sina.com','xiaolwbl@smail.com','lidianhong@cycq.com.cn','mail2sunjian@gmail.com.cn','ftyingcat@263.com','alanzhong1989@hotmai.com','xujian@sina.com','aharwitz@atlasla.com','jcyu@iwhr.com','tding@cument.com','zxllaw@162.com','wangzj@bank.com.cn','lihu@sina.com','liu1209@sina.com','robaya@pacbell.net','hhj5851@sohoo.com','zhang@126.com.cn','qddgsb@reah.net','oct_xzy@otmail.com','susanna@hibox.hinnet.net','wfyy650@189.com','liranff@sian.com','muge@altioklartv.com','kcrawford@technip.com','jinn6269@sina.com','ouyang@sina.com','huangxuezhu@qinghua.edu.cn','sxsy517@1663.com','chen7777@263.com','wr0304@sina.com','6546546@sina.com','yangzhengyun@sina.com','bbm@sdq-lawyers.com','yolanda.delpilar@hoege.com','wuxiaolu@sina.com','13906007008@139.com','bjkhl@yahoo.com','houchenggang@sina.com','guot@sina.com','fasdjkl@sina.com','zhangliren@sina.com','jiaoshouxia@sina.com','marco.morezzi@gentespeciale.it','belladelli.cristiano@pozziconfezioni.com','fengyt@sina.com','cbuck23@eq.edu.au','jhaoph@gmail.com.ph','chark4@eq.edu.au','hbate14@eq.edu.au','windorah@bluemax.com.au','wilfredo_racelis@yahoo.com','chapmanclan77@bigpond.com','rhegil.almarinez@pmintl.com','rcjee@three.com.au','therices@versa.com.au','jeff.mahoney@raywhite.com','huchangqiao@sina.com','wangfengquan@sina.com','iyss@sina.com','mayan88@sina.com','susana.dequeiros@sdq-lawyers.com','jianxin_gao@sina.com','ropatucci@yahoo.com','fanwei@sina.com','zhangjunhui@sina.com','mustafa.kurt@sinpas.com.tr','zhoujie@sina.com','4646546@sina.com','pengwei@sina.com','wangguannan@sina.com','hanjiebing@sina.com','qitongsheng@sina.com','zhanghui@sina.com','dshan7@eq.edu.au','gilberto.costa@cartocer.pt','maricriswee@gmail.com.ph','sfiel18@eq.edu.au','drank5@eq.edu.au','eric.buchanan@tc.ind.co.uk','chenshibiao@sina.com','songchengguang@sina.com','liguona@sina.com','gheid3@eq.edu.au','dpatz2@eq.edu.au','jfitz40@eq.edu.au','kvand3@eq.edu.au','bstar9@eq.edu.au','amurr53@eq.edu.au','mgprichard@perthsleep.comau','ncamsmith@kpmg.com.au','zenzest2001@yahoo.com','shanagolden@bigpond.com','yegang@sina.com','cbrya27@eq.edu.au','rmadd16@eq.edu.au','jeremy.liston@listonlanders.com.au','13336009111@zj165.com','xiuyuns@sina.com','guoxuelin@sina.com','serhan.ercivelek@sinpas.com.tr','sunyg@chinatietong.com','7szj@yahoo.com.cn','ucarerdal@windowslive.com','ysw-qd@163.com','zxcv2009@sina.com','fernandochn@yahoo.cn','liyong2010@sina.com','zhangshubing@sina.com','caglar.yurtturk@admdlaw.com','wanghuixia@sina.com','andyandjanreeves@goglemail.com','fanshaohong@yahoo.com.cn','fosijie@yahoo.com.cn','liziyu@sina.com','lihua@sina.com','rongtong@162.com','456465@sian.com')) C:\webRoot\Silverpop\CFC\Silverpop.cfc0hmcclub
qUpdateUndeliverables0 UPDATE ghr_members SET stale_flg = 1 WHERE lower(email1) IN ('13335096333@133.com','05312450@63.com','13312906666@189.com','guanxiujuan@gmail.cn','bj_sunway@foxmail.com.cn','renshijie@sohoo.com','danbonabon@com.ph','mengminghui@sina.com','zhangjinyu@sina.com','5645@sina.com','13971275759@1426.com','13306055663@189.com','guoerdong2005@sohoo.com','hongquan@sina.com','83322@sina.com','xiaolwbl@smail.com','lidianhong@cycq.com.cn','mail2sunjian@gmail.com.cn','ftyingcat@263.com','alanzhong1989@hotmai.com','xujian@sina.com','aharwitz@atlasla.com','jcyu@iwhr.com','tding@cument.com','zxllaw@162.com','wangzj@bank.com.cn','lihu@sina.com','liu1209@sina.com','robaya@pacbell.net','hhj5851@sohoo.com','zhang@126.com.cn','qddgsb@reah.net','oct_xzy@otmail.com','susanna@hibox.hinnet.net','wfyy650@189.com','liranff@sian.com','muge@altioklartv.com','kcrawford@technip.com','jinn6269@sina.com','ouyang@sina.com','huangxuezhu@qinghua.edu.cn','sxsy517@1663.com','chen7777@263.com','wr0304@sina.com','6546546@sina.com','yangzhengyun@sina.com','bbm@sdq-lawyers.com','yolanda.delpilar@hoege.com','wuxiaolu@sina.com','13906007008@139.com','bjkhl@yahoo.com','houchenggang@sina.com','guot@sina.com','fasdjkl@sina.com','zhangliren@sina.com','jiaoshouxia@sina.com','marco.morezzi@gentespeciale.it','belladelli.cristiano@pozziconfezioni.com','fengyt@sina.com','cbuck23@eq.edu.au','jhaoph@gmail.com.ph','chark4@eq.edu.au','hbate14@eq.edu.au','windorah@bluemax.com.au','wilfredo_racelis@yahoo.com','chapmanclan77@bigpond.com','rhegil.almarinez@pmintl.com','rcjee@three.com.au','therices@versa.com.au','jeff.mahoney@raywhite.com','huchangqiao@sina.com','wangfengquan@sina.com','iyss@sina.com','mayan88@sina.com','susana.dequeiros@sdq-lawyers.com','jianxin_gao@sina.com','ropatucci@yahoo.com','fanwei@sina.com','zhangjunhui@sina.com','mustafa.kurt@sinpas.com.tr','zhoujie@sina.com','4646546@sina.com','pengwei@sina.com','wangguannan@sina.com','hanjiebing@sina.com','qitongsheng@sina.com','zhanghui@sina.com','dshan7@eq.edu.au','gilberto.costa@cartocer.pt','maricriswee@gmail.com.ph','sfiel18@eq.edu.au','drank5@eq.edu.au','eric.buchanan@tc.ind.co.uk','chenshibiao@sina.com','songchengguang@sina.com','liguona@sina.com','gheid3@eq.edu.au','dpatz2@eq.edu.au','jfitz40@eq.edu.au','kvand3@eq.edu.au','bstar9@eq.edu.au','amurr53@eq.edu.au','mgprichard@perthsleep.comau','ncamsmith@kpmg.com.au','zenzest2001@yahoo.com','shanagolden@bigpond.com','yegang@sina.com','cbrya27@eq.edu.au','rmadd16@eq.edu.au','jeremy.liston@listonlanders.com.au','13336009111@zj165.com','xiuyuns@sina.com','guoxuelin@sina.com','serhan.ercivelek@sinpas.com.tr','sunyg@chinatietong.com','7szj@yahoo.com.cn','ucarerdal@windowslive.com','ysw-qd@163.com','zxcv2009@sina.com','fernandochn@yahoo.cn','liyong2010@sina.com','zhangshubing@sina.com','caglar.yurtturk@admdlaw.com','wanghuixia@sina.com','andyandjanreeves@goglemail.com','fanshaohong@yahoo.com.cn','fosijie@yahoo.com.cn','liziyu@sina.com','lihua@sina.com','rongtong@162.com','456465@sian.com') C:\webRoot\Silverpop\CFC\Silverpop.cfc0vhr_members
qUpdateBatch0 UPDATE members_stale_flg_batches SET status = 1 WHERE list_id = 12588342 C:\webRoot\Silverpop\CFC\Silverpop.cfc0hmcclub
timers
Query
Execution Time (ms)0
recordcount0
cachedNo
result
labeltimetemplate
history
Query
Execution Time (ms)0
recordcount10
cachedNo
result
idlevel
333501
333512
333523
333533
333524
333543
333552
333563
333563
333571
DEBUGENTRYCOUNT
number4
os
Struct
version
string5.2
name
stringWindows 2003
buildnumber
string
arch
stringx86
additionalinformation
string
coldfusion
Struct
appserver
string
serialnumber
string0
rootdir
string
productname
stringRailo
productlevel
stringos
productcontextcount
stringinf
installkit
string
productversion
string8,0,0,1
expiration
Date Time{ts '2010-08-26 01:19:59'}
supportedlocales
stringjapanese (japan),spanish (peru),english,ja_JP_JP,spanish (panama),serbian (bosnia and herzegovina),macedonian,spanish (guatemala),arabic (united arab emirates),norwegian (norway),albanian (albania),bulgarian,arabic (iraq),arabic (yemen),hungarian,portuguese (portugal),greek (cyprus),arabic (qatar),macedonian (macedonia),swedish,german (switzerland),english (united states),finnish (finland),icelandic,czech,english (malta),slovenian (slovenia),slovak (slovakia),italian,turkish (turkey),chinese,thai,arabic (saudi arabia),norwegian,english (united kingdom),serbian (serbia and montenegro),lithuanian,romanian,english (new zealand),no_NO_NY,lithuanian (lithuania),spanish (nicaragua),dutch,irish (ireland),french (belgium),spanish (spain),arabic (lebanon),korean,french (canada),estonian (estonia),arabic (kuwait),spanish (united states),spanish (mexico),arabic (sudan),indonesian (indonesia),russian,latvian,spanish (uruguay),latvian (latvia),hebrew,portuguese (brazil),arabic (syria),croatian,estonian,spanish (dominican republic),french (switzerland),hindi (india),spanish (venezuela),arabic (bahrain),english (philippines),arabic (tunisia),finnish,german (austria),spanish,dutch (netherlands),spanish (ecuador),chinese (taiwan),arabic (jordan),belarusian,icelandic (iceland),spanish (colombia),spanish (costa rica),spanish (chile),arabic (egypt),english (south africa),thai (thailand),greek (greece),italian (italy),catalan,hungarian (hungary),french,english (ireland),ukrainian (ukraine),polish (poland),french (luxembourg),dutch (belgium),english (india),catalan (spain),arabic (morocco),spanish (bolivia),english (australia),serbian,chinese (singapore),portuguese,ukrainian,spanish (el salvador),russian (russia),korean (south korea),vietnamese,arabic (algeria),vietnamese (vietnam),albanian,arabic (libya),arabic,chinese (china),belarusian (belarus),chinese (hong kong),japanese,hebrew (israel),bulgarian (bulgaria),indonesian,maltese (malta),spanish (paraguay),slovenian,french (france),czech (czech republic),italian (switzerland),romanian (romania),spanish (puerto rico),english (canada),german (germany),irish,german (luxembourg),german,spanish (argentina),slovak,malay (malaysia),croatian (croatia),english (singapore),danish,maltese,polish,arabic (oman),turkish,th_TH_TH,greek,malay,swedish (sweden),danish (denmark),spanish (honduras)
separator
Struct
line
string
file
string\
path
string;
array
Array
1
number1
2
number2
3
number3
4
stringaaa
struct
Struct
B
number2
A
number1
D
stringaaa
C
number3
query
Query
Execution Time (ms)0
recordcount4
cachedNo
result
COL1COL2
1.12.1
1.22.2
12
33