API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 18th, 2017
170
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 61.80 KB | None | 0 0
raw download clone embed print report
  1. The web site you are accessing has experienced an unexpected error.
  2. Please contact the website administrator.
  3.  
  4. The following information is meant for the website developer for debugging purposes.
  5. Error Occurred While Processing Request
  6. Invalid data '' for CFSQLTYPE CF_SQL_DOUBLE.
  7.  
  8. The error occurred in C:/inetpub/wwwroot/TMI/Trizetto/fusebox/circuits/Admin/Events/Action/act_edit.cfm: line 508
  9. Called from C:/inetpub/wwwroot/TMI/Trizetto/fusebox/circuits/Admin/Events/Action/act_edit.cfm: line 472
  10. Called from C:/inetpub/wwwroot/TMI/Trizetto/fusebox/circuits/Admin/Events/Action/act_edit.cfm: line 471
  11. Called from C:/inetpub/wwwroot/TMI/Trizetto/fusebox/circuits/Admin/Events/Action/act_edit.cfm: line 46
  12. Called from C:/inetpub/wwwroot/TMI/Trizetto/fusebox/circuits/Admin/Events/Action/act_edit.cfm: line 7
  13. Called from C:/inetpub/wwwroot/TMI/Trizetto/fusebox/circuits/Admin/Events/Action/act_edit.cfm: line 1
  14. Called from C:/inetpub/wwwroot/TMI/Trizetto/fusebox/switches/switch.events.cfm: line 18
  15. Called from C:/inetpub/wwwroot/TMI/Trizetto/fusebox/switches/switch.events.cfm: line 1
  16. Called from C:/inetpub/wwwroot/TMI/Trizetto/fusebox/fbx_fusebox40_MX.cfm: line 106
  17. Called from C:/inetpub/wwwroot/TMI/Trizetto/index.cfm: line 2
  18.  
  19. 506 : <cfqueryparam value="#val(getAttCats.max_seats)#" cfsqltype="CF_SQL_INTEGER">,
  20. 507 : <cfqueryparam value="#val(getAttCats.Reg_Code_maxUses)#" cfsqltype="CF_SQL_INTEGER">,
  21. 508 : <cfqueryparam value="#getAttCats.is_Comp_Exhib#" cfsqltype="CF_SQL_VARCHAR">)
  22. 509 : <!--- <cfqueryparam value="#yesNoFormat(getAttCats.is_Comp_Exhib)#" cfsqltype="CF_SQL_VARCHAR">) --->
  23. 510 : </cfquery>
  24.  
  25. Resources:
  26.  
  27. Check the ColdFusion documentation to verify that you are using the correct syntax.
  28. Search the Knowledge Base to find a solution to your problem.
  29.  
  30. Browser Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.9) Gecko/20100101 Goanna/3.0 Firefox/45.9 PaleMoon/27.0.3
  31. Remote Address 127.0.0.1
  32. Referrer http://trizetto.luceconsulting.net/index.cfm?do=events.edit&event_id=0
  33. Date/Time 18-Jan-17 01:31 PM
  34. Stack Trace
  35. at cfact_edit2ecfm60942838._factor48(C:/inetpub/wwwroot/TMI/Trizetto/fusebox/circuits/Admin/Events/Action/act_edit.cfm:508) at cfact_edit2ecfm60942838._factor49(C:/inetpub/wwwroot/TMI/Trizetto/fusebox/circuits/Admin/Events/Action/act_edit.cfm:472) at cfact_edit2ecfm60942838._factor101(C:/inetpub/wwwroot/TMI/Trizetto/fusebox/circuits/Admin/Events/Action/act_edit.cfm:471) at cfact_edit2ecfm60942838._factor108(C:/inetpub/wwwroot/TMI/Trizetto/fusebox/circuits/Admin/Events/Action/act_edit.cfm:46) at cfact_edit2ecfm60942838._factor111(C:/inetpub/wwwroot/TMI/Trizetto/fusebox/circuits/Admin/Events/Action/act_edit.cfm:7) at cfact_edit2ecfm60942838.runPage(C:/inetpub/wwwroot/TMI/Trizetto/fusebox/circuits/Admin/Events/Action/act_edit.cfm:1) at cfswitch2eevents2ecfm1360302893._factor0(C:/inetpub/wwwroot/TMI/Trizetto/fusebox/switches/switch.events.cfm:18) at cfswitch2eevents2ecfm1360302893.runPage(C:/inetpub/wwwroot/TMI/Trizetto/fusebox/switches/switch.events.cfm:1) at cffbx_fusebox40_MX2ecfm1560926336.runPage(C:/inetpub/wwwroot/TMI/Trizetto/fusebox/fbx_fusebox40_MX.cfm:106) at cfindex2ecfm1920518883.runPage(C:/inetpub/wwwroot/TMI/Trizetto/index.cfm:2)
  36.  
  37. coldfusion.sql.Parameter$DataTypeMismatchException: Invalid data '' for CFSQLTYPE CF_SQL_DOUBLE.
  38.  
  39. at coldfusion.sql.Parameter.getMappingValue(Parameter.java:158)
  40.  
  41. at coldfusion.sql.Parameter.getMappingValue(Parameter.java:70)
  42.  
  43. at coldfusion.sql.Parameter.getMappingValues(Parameter.java:63)
  44.  
  45. at coldfusion.sql.InParameter.setStatement(InParameter.java:72)
  46.  
  47. at coldfusion.sql.ParameterList.setStatement(ParameterList.java:109)
  48.  
  49. at coldfusion.sql.Executive.executeQuery(Executive.java:1500)
  50.  
  51. at coldfusion.sql.Executive.executeQuery(Executive.java:1235)
  52.  
  53. at coldfusion.sql.Executive.executeQuery(Executive.java:1165)
  54.  
  55. at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
  56.  
  57. at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187)
  58.  
  59. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816)
  60.  
  61. at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769)
  62.  
  63. at cfact_edit2ecfm60942838._factor48(C:\inetpub\wwwroot\TMI\Trizetto\fusebox\circuits\Admin\Events\Action\act_edit.cfm:508)
  64.  
  65. at cfact_edit2ecfm60942838._factor49(C:\inetpub\wwwroot\TMI\Trizetto\fusebox\circuits\Admin\Events\Action\act_edit.cfm:472)
  66.  
  67. at cfact_edit2ecfm60942838._factor101(C:\inetpub\wwwroot\TMI\Trizetto\fusebox\circuits\Admin\Events\Action\act_edit.cfm:471)
  68.  
  69. at cfact_edit2ecfm60942838._factor108(C:\inetpub\wwwroot\TMI\Trizetto\fusebox\circuits\Admin\Events\Action\act_edit.cfm:46)
  70.  
  71. at cfact_edit2ecfm60942838._factor111(C:\inetpub\wwwroot\TMI\Trizetto\fusebox\circuits\Admin\Events\Action\act_edit.cfm:7)
  72.  
  73. at cfact_edit2ecfm60942838.runPage(C:\inetpub\wwwroot\TMI\Trizetto\fusebox\circuits\Admin\Events\Action\act_edit.cfm:1)
  74.  
  75. at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246)
  76.  
  77. at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
  78.  
  79. at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
  80.  
  81. at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3000)
  82.  
  83. at cfswitch2eevents2ecfm1360302893._factor0(C:\inetpub\wwwroot\TMI\Trizetto\fusebox\switches\switch.events.cfm:18)
  84.  
  85. at cfswitch2eevents2ecfm1360302893.runPage(C:\inetpub\wwwroot\TMI\Trizetto\fusebox\switches\switch.events.cfm:1)
  86.  
  87. at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246)
  88.  
  89. at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
  90.  
  91. at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
  92.  
  93. at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3000)
  94.  
  95. at cffbx_fusebox40_MX2ecfm1560926336.runPage(C:\inetpub\wwwroot\TMI\Trizetto\fusebox\fbx_fusebox40_MX.cfm:106)
  96.  
  97. at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246)
  98.  
  99. at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
  100.  
  101. at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
  102.  
  103. at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3000)
  104.  
  105. at cfindex2ecfm1920518883.runPage(C:\inetpub\wwwroot\TMI\Trizetto\index.cfm:2)
  106.  
  107. at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246)
  108.  
  109. at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
  110.  
  111. at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
  112.  
  113. at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
  114.  
  115. at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
  116.  
  117. at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:495)
  118.  
  119. at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42)
  120.  
  121. at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
  122.  
  123. at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
  124.  
  125. at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
  126.  
  127. at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78)
  128.  
  129. at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
  130.  
  131. at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
  132.  
  133. at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58)
  134.  
  135. at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
  136.  
  137. at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
  138.  
  139. at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
  140.  
  141. at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:151)
  142.  
  143. at coldfusion.CfmServlet.service(CfmServlet.java:219)
  144.  
  145. at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
  146.  
  147. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
  148.  
  149. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  150.  
  151. at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
  152.  
  153. at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
  154.  
  155. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  156.  
  157. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  158.  
  159. at coldfusion.inspect.weinre.MobileDeviceDomInspectionFilter.doFilter(MobileDeviceDomInspectionFilter.java:121)
  160.  
  161. at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
  162.  
  163. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  164.  
  165. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  166.  
  167. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
  168.  
  169. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
  170.  
  171. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
  172.  
  173. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
  174.  
  175. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
  176.  
  177. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
  178.  
  179. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:450)
  180.  
  181. at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197)
  182.  
  183. at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
  184.  
  185. at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
  186.  
  187. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  188.  
  189. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  190.  
  191. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  192.  
  193. at java.lang.Thread.run(Thread.java:745)
  194.  
  195. Debugging Information
  196. ColdFusion Server Evaluation 11,0,11,301867
  197. Template /index.cfm
  198. Time Stamp 18-Jan-17 01:31 PM
  199. Locale English (US)
  200. User Agent Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.9) Gecko/20100101 Goanna/3.0 Firefox/45.9 PaleMoon/27.0.3
  201. Remote IP 127.0.0.1
  202. Host Name 127.0.0.1
  203.  
  204. Execution Time
  205.  
  206. Total Time Avg Time Count Template
  207. 681 ms 681 ms 1 C:/inetpub/wwwroot/TMI/Trizetto/index.cfm
  208. 678 ms 678 ms 1 C:/inetpub/wwwroot/TMI/Trizetto/fusebox/fbx_fusebox40_MX.cfm
  209. 674 ms 674 ms 1 C:/inetpub/wwwroot/TMI/Trizetto/fusebox/switches/switch.events.cfm
  210. 381 ms 381 ms 1 C:/inetpub/wwwroot/TMI/Trizetto/fusebox/circuits/Admin/Events/Action/act_edit.cfm
  211. 164 ms 164 ms 1 CFC[ C:/inetpub/wwwroot/TMI/Common/Components/7/operations.cfc | mceFileGen(Trizetto) ] from C:/inetpub/wwwroot/TMI/Common/Components/7/operations.cfc
  212. 140 ms 140 ms 1 CFC[ C:/inetpub/wwwroot/TMI/Common/Components/7/Dev/esFiles.cfc | getFloderQuery(FolderPath = C:/inetpub/wwwroot/TMI/Trizetto/files/userfiles/Images, recurse = Yes, doExpand = No) ] from C:/inetpub/wwwroot/TMI/Common/Components/7/Dev/esFiles.cfc
  213. 14 ms 14 ms 1 CFC[ C:/inetpub/wwwroot/TMI/Common/Components/7/Dev/esFiles.cfc | getFloderQuery(FolderPath = C:/inetpub/wwwroot/TMI/Trizetto/files/userfiles/Files, recurse = Yes, doExpand = No) ] from C:/inetpub/wwwroot/TMI/Common/Components/7/Dev/esFiles.cfc
  214. 6 ms 6 ms 1 CFC[ C:/inetpub/wwwroot/TMI/Common/Components/7/operations.cfc | mceJSON([complex value], Images) ] from C:/inetpub/wwwroot/TMI/Common/Components/7/operations.cfc
  215. 4 ms 4 ms 1 C:/inetpub/wwwroot/TMI/Trizetto/Application.cfm
  216. 3 ms 3 ms 1 CFC[ C:/inetpub/wwwroot/TMI/Common/Components/7/operations.cfc | insert_new(Events, event_id, Event_Name, GREGTEST) ] from C:/inetpub/wwwroot/TMI/Common/Components/7/operations.cfc
  217. 2 ms 2 ms 1 CFC[ C:/inetpub/wwwroot/TMI/Common/Components/7/events.cfc | initEventFolders(94) ] from C:/inetpub/wwwroot/TMI/Common/Components/7/events.cfc
  218. 1 ms 1 ms 1 C:/inetpub/wwwroot/TMI/Trizetto/fusebox/fbx_settings.cfm
  219. 1 ms 1 ms 1 CFC[ C:/inetpub/wwwroot/TMI/Common/Components/7/Dev/esFiles.cfc | getFloderQuery(FolderPath = C:/inetpub/wwwroot/TMI/Trizetto/files/userfiles/Media, recurse = Yes, doExpand = No) ] from C:/inetpub/wwwroot/TMI/Common/Components/7/Dev/esFiles.cfc
  220. 1 ms 1 ms 1 CFC[ C:/inetpub/wwwroot/TMI/Common/Components/7/fields_new.cfc | translatePrompt(There are errors with your submission, 93, 0) ] from C:/inetpub/wwwroot/TMI/Common/Components/7/fields_new.cfc
  221. 1 ms 1 ms 1 CFC[ C:/inetpub/wwwroot/TMI/Common/Components/7/operations.cfc | mceJSON([complex value], Files) ] from C:/inetpub/wwwroot/TMI/Common/Components/7/operations.cfc
  222. 1 ms 1 ms 2 CFC[ C:/inetpub/wwwroot/TMI/Common/Components/7/user.cfc | isLoggedIn() ] from C:/inetpub/wwwroot/TMI/Common/Components/7/user.cfc
  223. 0 ms 0 ms 3 C:/inetpub/wwwroot/TMI/Common/resources/functions.cfm
  224. 0 ms 0 ms 1 C:/inetpub/wwwroot/TMI/Trizetto/fusebox/circuits/Admin/Events/Action/act_url.cfm
  225. 0 ms 0 ms 1 C:/inetpub/wwwroot/TMI/Trizetto/fusebox/settings/settings.admin.cfm
  226. 0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/TMI/Common/Components/7/Dev/esFiles.cfc | init(Trizetto) ] from C:/inetpub/wwwroot/TMI/Common/Components/7/Dev/esFiles.cfc
  227. 0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/TMI/Common/Components/7/app_new.cfc | encrypt_init(EIS023, 360ENC) ] from C:/inetpub/wwwroot/TMI/Common/Components/7/app_new.cfc
  228. 0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/TMI/Common/Components/7/events.cfc | getEvent(94) ] from C:/inetpub/wwwroot/TMI/Common/Components/7/events.cfc
  229. 0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/TMI/Common/Components/7/fields_new.cfc | translatePrompt(Please correct and submit again., 93, 0) ] from C:/inetpub/wwwroot/TMI/Common/Components/7/fields_new.cfc
  230. 0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/TMI/Common/Components/7/user.cfc | IsloggedIn() ] from C:/inetpub/wwwroot/TMI/Common/Components/7/user.cfc
  231. 0 ms 0 ms 3 CFC[ C:/inetpub/wwwroot/TMI/Common/Components/7/user.cfc | get(bIsLoggedIn) ] from C:/inetpub/wwwroot/TMI/Common/Components/7/user.cfc
  232. 0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/TMI/Common/Components/7/user.cfc | get(user_name) ] from C:/inetpub/wwwroot/TMI/Common/Components/7/user.cfc
  233. 0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/TMI/Common/Components/fbx_fusebox_eis.cfc | getAttributes() ] from C:/inetpub/wwwroot/TMI/Common/Components/fbx_fusebox_eis.cfc
  234. 0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/TMI/Common/Components/fbx_fusebox_eis.cfc | getCircuitRequest() ] from C:/inetpub/wwwroot/TMI/Common/Components/fbx_fusebox_eis.cfc
  235. 0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/TMI/Common/Components/fbx_fusebox_eis.cfc | getFilePath(//fusebox/settings/settings.admin.cfm) ] from C:/inetpub/wwwroot/TMI/Common/Components/fbx_fusebox_eis.cfc
  236. 0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/TMI/Common/Components/fbx_fusebox_eis.cfc | getFilePath(//fusebox/settings/settings.events.cfm) ] from C:/inetpub/wwwroot/TMI/Common/Components/fbx_fusebox_eis.cfc
  237. 0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/TMI/Common/Components/fbx_fusebox_eis.cfc | getFilePath(//fusebox/switches/switch.events.cfm) ] from C:/inetpub/wwwroot/TMI/Common/Components/fbx_fusebox_eis.cfc
  238. 0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/TMI/Common/Components/fbx_fusebox_eis.cfc | getSwitchPath() ] from C:/inetpub/wwwroot/TMI/Common/Components/fbx_fusebox_eis.cfc
  239. 0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/TMI/Common/Components/fbx_fusebox_eis.cfc | setFuseaction(events.editAction) ] from C:/inetpub/wwwroot/TMI/Common/Components/fbx_fusebox_eis.cfc
  240. 0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/TMI/Common/Components/fbx_fusebox_eis.cfc | setNestedSettings(admin) ] from C:/inetpub/wwwroot/TMI/Common/Components/fbx_fusebox_eis.cfc
  241. 0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/TMI/Common/Components/fbx_fusebox_eis.cfc | setNestedSettings(events) ] from C:/inetpub/wwwroot/TMI/Common/Components/fbx_fusebox_eis.cfc
  242. 9 ms STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
  243. 694 ms TOTAL EXECUTION TIME
  244. red = over 250 ms average execution time
  245.  
  246. Exceptions
  247.  
  248. 13:31:45.045 - Database Exception - in C:/inetpub/wwwroot/TMI/Trizetto/fusebox/circuits/Admin/Events/Action/act_edit.cfm : line 508
  249.  
  250. Invalid data '' for CFSQLTYPE CF_SQL_DOUBLE.
  251.  
  252.  
  253. 13:31:45.045 - Database Exception - in C:/inetpub/wwwroot/TMI/Trizetto/fusebox/circuits/Admin/Events/Action/act_edit.cfm : line 508
  254.  
  255. Invalid data '' for CFSQLTYPE CF_SQL_DOUBLE.
  256.  
  257.  
  258. SQL Queries
  259.  
  260. qryEvent (Datasource=Trizetto, Time=1ms, Records=1) in C:\inetpub\wwwroot\TMI\Common\Components\7\fields_new.cfc @ 13:31:45.045
  261.  
  262. SELECT has_Languages, has_Admin_Translate FROM Events WHERE Event_ID = 93
  263.  
  264. qryEvent (Datasource=Trizetto, Time=0ms, Records=1, Cached Query) in C:\inetpub\wwwroot\TMI\Common\Components\7\fields_new.cfc @ 13:31:45.045
  265.  
  266. SELECT has_Languages, has_Admin_Translate FROM Events WHERE Event_ID = 93
  267.  
  268. getID (Datasource=Trizetto, Time=3ms, Records=1) in C:\inetpub\wwwroot\TMI\Common\Components\7\operations.cfc @ 13:31:45.045
  269.  
  270. SET NOCOUNT ON;
  271. INSERT INTO Events (Event_Name)
  272. VALUES (?);
  273. SELECT @@IDENTITY AS Field_ID;
  274. SET NOCOUNT OFF;
  275.  
  276.  
  277. Query Parameter Value(s) -
  278. Parameter #1(CF_SQL_VARCHAR) = GREGTEST
  279.  
  280. chkUrl (Datasource=Trizetto, Time=0ms, Records=1) in C:\inetpub\wwwroot\TMI\Trizetto\fusebox\circuits\Admin\Events\Action\act_url.cfm @ 13:31:45.045
  281.  
  282. SELECT URL FROM Events WHERE Event_ID = ?
  283.  
  284. Query Parameter Value(s) -
  285. Parameter #1(CF_SQL_INTEGER) = 94
  286.  
  287. chkNewURL (Datasource=Trizetto, Time=0ms, Records=1) in C:\inetpub\wwwroot\TMI\Trizetto\fusebox\circuits\Admin\Events\Action\act_url.cfm @ 13:31:45.045
  288.  
  289. SELECT Event_ID
  290. FROM Events
  291. WHERE URL = ?
  292. AND Event_ID <> ?
  293.  
  294. Query Parameter Value(s) -
  295. Parameter #1(CF_SQL_VARCHAR) = GT
  296. Parameter #2(CF_SQL_INTEGER) = 94
  297.  
  298. qryEvent (Datasource=Trizetto, Time=0ms, Records=0) in C:\inetpub\wwwroot\TMI\Common\Components\7\events.cfc @ 13:31:45.045
  299.  
  300. SELECT E.*, V.Venue_Name, V.Address, V.Address_2, V.City, V.State, V.Zip, V.Country, V.Phone, V.FAX,
  301. V.Contact_Name, V.Email AS V_Email, V.URL AS V_URL, U.First_Name, U.Last_Name, U.Email
  302. FROM Events E
  303. INNER JOIN Users U ON E.Owner_ID = U.User_ID
  304. LEFT OUTER JOIN Venues V ON E.Venue_ID = V.Venue_ID
  305. WHERE E.Event_ID = ?
  306.  
  307. Query Parameter Value(s) -
  308. Parameter #1(CF_SQL_INTEGER) = 94
  309.  
  310. update (Datasource=Trizetto, Time=5ms, Records=1) in C:\inetpub\wwwroot\TMI\Trizetto\fusebox\circuits\Admin\Events\Action\act_edit.cfm @ 13:31:45.045
  311.  
  312. UPDATE Events
  313. SET Event_Name = ?,
  314. Start_Date = ?,
  315. End_Date = ?,
  316. Event_Email = ?,
  317. Event_Nickname = ?,
  318. Event_Phone = ?,
  319.  
  320.  
  321. portlets = ?,
  322.  
  323.  
  324.  
  325. Venue_ID = ?,
  326. Owner_ID = ?,
  327. Proj_Attend = ?,
  328. Price_Model = ?
  329.  
  330.  
  331. Where event_ID = ?
  332.  
  333. Query Parameter Value(s) -
  334. Parameter #1(CF_SQL_VARCHAR) = GREGTEST
  335. Parameter #2(CF_SQL_TIMESTAMP) = 2017-01-19 00:00:00.0
  336. Parameter #3(CF_SQL_TIMESTAMP) = 2017-01-21 00:00:00.0
  337. Parameter #4(CF_SQL_VARCHAR) = greg@tmiexpos.com
  338. Parameter #5(CF_SQL_VARCHAR) = GT
  339. Parameter #6(CF_SQL_VARCHAR) = 888-888-8888
  340. Parameter #7(CF_SQL_VARCHAR) =
  341. Parameter #8(CF_SQL_INTEGER) = 0
  342. Parameter #9(CF_SQL_INTEGER) = 1001
  343. Parameter #10(CF_SQL_INTEGER) = 3
  344. Parameter #11(CF_SQL_VARCHAR) =
  345. Parameter #12(CF_SQL_INTEGER) = 94
  346.  
  347. getOldEvent (Datasource=Trizetto, Time=0ms, Records=1) in C:\inetpub\wwwroot\TMI\Trizetto\fusebox\circuits\Admin\Events\Action\act_edit.cfm @ 13:31:45.045
  348.  
  349. SELECT *
  350. FROM Events
  351. WHERE Event_ID = ?
  352.  
  353. Query Parameter Value(s) -
  354. Parameter #1(CF_SQL_INTEGER) = 60
  355.  
  356. update (Datasource=Trizetto, Time=1ms, Records=1) in C:\inetpub\wwwroot\TMI\Trizetto\fusebox\circuits\Admin\Events\Action\act_edit.cfm @ 13:31:45.045
  357.  
  358. UPDATE Events
  359. SET
  360. is_Private = ?,
  361.  
  362. has_Sessions = ?,
  363.  
  364. has_Activities = ?,
  365.  
  366. has_Hotels = ?,
  367.  
  368. has_Financial = ?,
  369.  
  370. has_Tax = ?,
  371.  
  372. has_Exhib = ?,
  373.  
  374. is_Reg_Open = ?,
  375.  
  376. can_Access = ?,
  377.  
  378. has_Group = ?,
  379.  
  380. has_Group_Full = ?,
  381.  
  382. has_Inventory = ?,
  383.  
  384. has_Coupons = ?,
  385.  
  386. has_Combine = ?,
  387.  
  388. has_Member_Chk = ?,
  389.  
  390. has_CFP = ?,
  391.  
  392. Cancel_Fee = ?,
  393.  
  394. Proj_Attend = ?,
  395.  
  396. FB_Tax = ?,
  397.  
  398. reg_Flow_Date = ?,
  399.  
  400. has_Member_ID = ?,
  401.  
  402. has_Member_Select = ?,
  403.  
  404. is_CFP_Files = ?,
  405.  
  406. has_Members = ?,
  407.  
  408. has_items = ?,
  409.  
  410. has_Conflict = ?,
  411.  
  412. has_Content = ?,
  413.  
  414. is_CFP_Spec = ?,
  415.  
  416. CFP_Approve = ?,
  417.  
  418. has_Track_Mgr = ?,
  419.  
  420. has_Track_Mgr_Self = ?,
  421.  
  422. CFP_Approve_On = ?,
  423.  
  424. has_CFP_Auto_Mail = ?,
  425.  
  426. has_Languages = ?,
  427.  
  428. has_Admin_Translate = ?,
  429.  
  430. is_Client_Edit = ?,
  431.  
  432. has_Itin = ?,
  433.  
  434. has_Onsite = ?,
  435.  
  436. has_Guest = ?,
  437.  
  438. has_Floorplan = ?,
  439.  
  440. has_Exhib_Badge = ?,
  441.  
  442. has_Exhib_Full_Reg = ?,
  443.  
  444. has_Exhib_Invites = ?,
  445.  
  446. has_Exhib_Files = ?,
  447.  
  448. has_Sponsorships = ?,
  449.  
  450. has_Exhib_Cats = ?,
  451.  
  452. Event_Look = ?,
  453.  
  454. has_Marketing = ?,
  455.  
  456. has_Match_Regs = ?,
  457.  
  458. has_Match_Exhib = ?,
  459.  
  460. has_Match_Schedule = ?,
  461.  
  462. has_Match_Exhib_Center = ?,
  463.  
  464. has_Match_Create = ?,
  465.  
  466. Merchant_Account_ID = ?,
  467.  
  468. has_Print_Pending = ?,
  469.  
  470. Badge_Def = ?,
  471.  
  472. Alpha_Split_Counters = ?,
  473.  
  474. has_Print_By_Cat = ?,
  475.  
  476. has_Onsite_Mode = ?,
  477.  
  478. Currency_Codes = ?,
  479.  
  480. has_Currency_DEV = ?,
  481.  
  482. has_Checks = ?,
  483.  
  484. has_Cash = ?,
  485.  
  486. Exhib_Merchant_Account_ID = ?,
  487.  
  488. has_Resume_Req = ?,
  489.  
  490. has_CFP_Files_Req = ?,
  491.  
  492. has_CFP_Full_Form = ?,
  493.  
  494. has_CC_Scan = ?,
  495.  
  496. has_Cfp_Events = ?,
  497.  
  498. has_CFP_Actuals = ?,
  499.  
  500. has_handouts = ?,
  501.  
  502. has_Reg_UEmail = ?,
  503.  
  504. has_RM_Mod_Log = ?,
  505.  
  506. has_Insurance_Upload = ?,
  507.  
  508. has_Booth_Purchase = ?,
  509.  
  510. has_Contact_Email = ?,
  511.  
  512. has_Company_Contact = ?,
  513.  
  514. has_Logo_Upload = ?,
  515.  
  516. has_Company_Profile_Short = ?,
  517.  
  518. has_Company_Profile = ?,
  519.  
  520. has_ProgramAd_Upload = ?,
  521.  
  522. has_Comp_Attendees = ?,
  523.  
  524. has_Additional_Reg_Items = ?,
  525.  
  526. has_Additional_Booth = ?,
  527.  
  528. has_Booth_Staff = ?,
  529.  
  530. has_Payment_Option = ?,
  531.  
  532. has_Pay_Later = ?,
  533.  
  534.  
  535.  
  536.  
  537.  
  538. Owner_ID = Owner_ID
  539. Where event_ID = ?
  540.  
  541. Query Parameter Value(s) -
  542. Parameter #1(CF_SQL_VARCHAR) = No
  543. Parameter #2(CF_SQL_VARCHAR) = No
  544. Parameter #3(CF_SQL_VARCHAR) = No
  545. Parameter #4(CF_SQL_VARCHAR) = No
  546. Parameter #5(CF_SQL_VARCHAR) = No
  547. Parameter #6(CF_SQL_VARCHAR) = No
  548. Parameter #7(CF_SQL_VARCHAR) = No
  549. Parameter #8(CF_SQL_VARCHAR) = Yes
  550. Parameter #9(CF_SQL_VARCHAR) = Yes
  551. Parameter #10(CF_SQL_VARCHAR) = No
  552. Parameter #11(CF_SQL_VARCHAR) = No
  553. Parameter #12(CF_SQL_VARCHAR) = No
  554. Parameter #13(CF_SQL_VARCHAR) = No
  555. Parameter #14(CF_SQL_VARCHAR) = No
  556. Parameter #15(CF_SQL_VARCHAR) = No
  557. Parameter #16(CF_SQL_VARCHAR) = No
  558. Parameter #17(CF_SQL_MONEY) = 0
  559. Parameter #18(CF_SQL_INTEGER) = 25
  560. Parameter #19(CF_SQL_MONEY) = 0
  561. Parameter #20(CF_SQL_TIMESTAMP) = 2017-01-12 16:22:43.0
  562. Parameter #21(CF_SQL_VARCHAR) = No
  563. Parameter #22(CF_SQL_VARCHAR) = No
  564. Parameter #23(CF_SQL_VARCHAR) = No
  565. Parameter #24(CF_SQL_VARCHAR) = No
  566. Parameter #25(CF_SQL_VARCHAR) = Yes
  567. Parameter #26(CF_SQL_VARCHAR) = No
  568. Parameter #27(CF_SQL_VARCHAR) = Yes
  569. Parameter #28(CF_SQL_VARCHAR) = No
  570. Parameter #29(CF_SQL_VARCHAR) = Single
  571. Parameter #30(CF_SQL_VARCHAR) = No
  572. Parameter #31(CF_SQL_VARCHAR) = No
  573. Parameter #32(CF_SQL_VARCHAR) = No
  574. Parameter #33(CF_SQL_VARCHAR) = No
  575. Parameter #34(CF_SQL_VARCHAR) = No
  576. Parameter #35(CF_SQL_VARCHAR) = No
  577. Parameter #36(CF_SQL_BIT) = YES
  578. Parameter #37(CF_SQL_VARCHAR) = No
  579. Parameter #38(CF_SQL_VARCHAR) = No
  580. Parameter #39(CF_SQL_VARCHAR) = No
  581. Parameter #40(CF_SQL_VARCHAR) = No
  582. Parameter #41(CF_SQL_VARCHAR) = No
  583. Parameter #42(CF_SQL_VARCHAR) = No
  584. Parameter #43(CF_SQL_VARCHAR) = No
  585. Parameter #44(CF_SQL_VARCHAR) = No
  586. Parameter #45(CF_SQL_VARCHAR) = No
  587. Parameter #46(CF_SQL_VARCHAR) = No
  588. Parameter #47(CF_SQL_VARCHAR) = Custom
  589. Parameter #48(CF_SQL_VARCHAR) = No
  590. Parameter #49(CF_SQL_VARCHAR) = No
  591. Parameter #50(CF_SQL_VARCHAR) = No
  592. Parameter #51(CF_SQL_VARCHAR) = Yes
  593. Parameter #52(CF_SQL_VARCHAR) = No
  594. Parameter #53(CF_SQL_VARCHAR) = No
  595. Parameter #54(CF_SQL_INTEGER) = 2
  596. Parameter #55(CF_SQL_VARCHAR) = No
  597. Parameter #56(CF_SQL_VARCHAR) = 5390
  598. Parameter #57(CF_SQL_INTEGER) = 4
  599. Parameter #58(CF_SQL_VARCHAR) = No
  600. Parameter #59(CF_SQL_VARCHAR) = No
  601. Parameter #60(CF_SQL_VARCHAR) = USD
  602. Parameter #61(CF_SQL_VARCHAR) = No
  603. Parameter #62(CF_SQL_VARCHAR) = No
  604. Parameter #63(CF_SQL_VARCHAR) = No
  605. Parameter #64(CF_SQL_INTEGER) = 2
  606. Parameter #65(CF_SQL_VARCHAR) = No
  607. Parameter #66(CF_SQL_VARCHAR) = No
  608. Parameter #67(CF_SQL_VARCHAR) = Yes
  609. Parameter #68(CF_SQL_VARCHAR) = No
  610. Parameter #69(CF_SQL_VARCHAR) = Yes
  611. Parameter #70(CF_SQL_VARCHAR) = No
  612. Parameter #71(CF_SQL_VARCHAR) = No
  613. Parameter #72(CF_SQL_VARCHAR) = No
  614. Parameter #73(CF_SQL_VARCHAR) = No
  615. Parameter #74(CF_SQL_VARCHAR) = No
  616. Parameter #75(CF_SQL_VARCHAR) = No
  617. Parameter #76(CF_SQL_VARCHAR) = No
  618. Parameter #77(CF_SQL_VARCHAR) = No
  619. Parameter #78(CF_SQL_VARCHAR) = No
  620. Parameter #79(CF_SQL_VARCHAR) = No
  621. Parameter #80(CF_SQL_VARCHAR) = No
  622. Parameter #81(CF_SQL_VARCHAR) = No
  623. Parameter #82(CF_SQL_VARCHAR) = No
  624. Parameter #83(CF_SQL_VARCHAR) = No
  625. Parameter #84(CF_SQL_VARCHAR) = No
  626. Parameter #85(CF_SQL_VARCHAR) = No
  627. Parameter #86(CF_SQL_VARCHAR) = No
  628. Parameter #87(CF_SQL_VARCHAR) = No
  629. Parameter #88(CF_SQL_INTEGER) = 94
  630.  
  631. getOldActivities (Datasource=Trizetto, Time=0ms, Records=0) in C:\inetpub\wwwroot\TMI\Trizetto\fusebox\circuits\Admin\Events\Action\act_edit.cfm @ 13:31:45.045
  632.  
  633. SELECT *
  634. FROM Activities
  635. WHERE Event_ID = ?
  636.  
  637. Query Parameter Value(s) -
  638. Parameter #1(CF_SQL_INTEGER) = 60
  639.  
  640. delExhibPages (Datasource=Trizetto, Time=1ms, Records=0) in C:\inetpub\wwwroot\TMI\Trizetto\fusebox\circuits\Admin\Events\Action\act_edit.cfm @ 13:31:45.045
  641.  
  642. DELETE FROM Event_Content
  643. WHERE Event_ID = ?
  644.  
  645. Query Parameter Value(s) -
  646. Parameter #1(CF_SQL_INTEGER) = 94
  647.  
  648. getOldContent (Datasource=Trizetto, Time=1ms, Records=11) in C:\inetpub\wwwroot\TMI\Trizetto\fusebox\circuits\Admin\Events\Action\act_edit.cfm @ 13:31:45.045
  649.  
  650. SELECT *
  651. FROM Event_Content
  652. WHERE Event_ID = ?
  653.  
  654. Query Parameter Value(s) -
  655. Parameter #1(CF_SQL_INTEGER) = 60
  656.  
  657. addCnt (Datasource=Trizetto, Time=187ms, Records=1) in C:\inetpub\wwwroot\TMI\Trizetto\fusebox\circuits\Admin\Events\Action\act_edit.cfm @ 13:31:45.045
  658.  
  659. INSERT INTO Event_Content (Event_ID, Content_Title, Content_Body, is_Active, User_ID, Create_Date, Sort, Parent_ID, Content_Type, Summary, Page_Name, Page_Key, PK_ID)
  660. VALUES (?,
  661. ?,
  662. ?,
  663. ?,
  664. ?,
  665. ?,
  666. ?,
  667. ?,
  668. ?,
  669. ?,
  670. ?,
  671. ?,
  672. ?)
  673.  
  674.  
  675. Query Parameter Value(s) -
  676. Parameter #1(CF_SQL_INTEGER) = 94
  677. Parameter #2(CF_SQL_VARCHAR) = Welcome Page
  678. Parameter #3(CF_SQL_VARCHAR) = <p style="text-align:center"><span style="font-family:arial,helvetica,sans-serif"><span style="font-size:36px"><strong><span style="color:rgb(51, 153, 204)">Welcome </span></strong></span></span></p> <hr /> <p>&nbsp;</p> <p><span style="font-size:18px">We look forward to seeing you at the first <strong>Cognizant TriZetto Medicare Solutions (TMS) User Forum </strong>at our Union, New Jersey headquarters.&nbsp;</span></p> <p><span style="font-size:18px">This is an opportunity for our clients to come together with the TriZetto Medicare Solutions product team to talk product roadmap, feature design, how-to&rsquo;s, and more!&nbsp;</span></p> <p><span style="font-size:18px">We look forward to seeing and collaborating with our TMS users!</span></p> <p>&nbsp;</p> <p><a href="https://trizetto.expoplanner.com/index.cfm?do=reg.flow&amp;event_id=60"><img alt="" src="https://trizetto.expoplanner.com/files/userfiles/images/registerbutton.jpg" style="height:92px; width:300px" /></a></p>
  679. Parameter #4(CF_SQL_VARCHAR) = Yes
  680. Parameter #5(CF_SQL_INTEGER) = 1002
  681. Parameter #6(CF_SQL_TIMESTAMP) = 2017-01-13 08:47:38.017
  682. Parameter #7(CF_SQL_INTEGER) = 0
  683. Parameter #8(CF_SQL_INTEGER) = 0
  684. Parameter #9(CF_SQL_VARCHAR) = html
  685. Parameter #10(CF_SQL_VARCHAR) =
  686. Parameter #11(CF_SQL_VARCHAR) =
  687. Parameter #12(CF_SQL_VARCHAR) =
  688. Parameter #13(CF_SQL_INTEGER) = 0
  689.  
  690. addCnt (Datasource=Trizetto, Time=0ms, Records=1) in C:\inetpub\wwwroot\TMI\Trizetto\fusebox\circuits\Admin\Events\Action\act_edit.cfm @ 13:31:45.045
  691.  
  692. INSERT INTO Event_Content (Event_ID, Content_Title, Content_Body, is_Active, User_ID, Create_Date, Sort, Parent_ID, Content_Type, Summary, Page_Name, Page_Key, PK_ID)
  693. VALUES (?,
  694. ?,
  695. ?,
  696. ?,
  697. ?,
  698. ?,
  699. ?,
  700. ?,
  701. ?,
  702. ?,
  703. ?,
  704. ?,
  705. ?)
  706.  
  707.  
  708. Query Parameter Value(s) -
  709. Parameter #1(CF_SQL_INTEGER) = 94
  710. Parameter #2(CF_SQL_VARCHAR) = Conf Email
  711. Parameter #3(CF_SQL_VARCHAR) = <table border="0" cellpadding="1" cellspacing="1" style="height:253px; width:722px"> <tbody> <tr> <td> <p style="text-align:left"><span style="font-size:14px"><span style="font-family:arial,helvetica,sans-serif">Dear [Regs.First_Name] [Regs.Last_Name],<br /> <br /> Thank you for registering for the TMS Client Forum.</span></span><br /> &nbsp;</p> <p style="text-align:left"><span style="font-size:14px"><span style="font-family:arial,helvetica,sans-serif"><a href="https://trizetto.expoplanner.com/index.cfm?do=reg.flow&amp;event_id=60">To access your registration record click here</a></span></span></p> <p style="text-align:left"><span style="font-size:14px"><span style="font-family:arial,helvetica,sans-serif">Email: [Regs.Email]<br /> Password:[Regs.Password]</span></span></p> <p style="text-align:left"><span style="font-size:14px"><span style="font-family:arial,helvetica,sans-serif">If you have any questions, please contact Maria Luis-Brown at (908) 994.3314 or<a href="mailto:Tadia.shipley@trizetto.com"> </a><a href="mailto:marcy.levine@trizetto.com?subject=TriZetto%20Customer%20Group%20">maria.luis-brown@trizetto.com</a>.</span></span></p> </td> </tr> </tbody> </table>
  712. Parameter #4(CF_SQL_VARCHAR) = Yes
  713. Parameter #5(CF_SQL_INTEGER) = 1002
  714. Parameter #6(CF_SQL_TIMESTAMP) = 2017-01-13 08:47:38.03
  715. Parameter #7(CF_SQL_INTEGER) = 0
  716. Parameter #8(CF_SQL_INTEGER) = 0
  717. Parameter #9(CF_SQL_VARCHAR) = Reg
  718. Parameter #10(CF_SQL_VARCHAR) =
  719. Parameter #11(CF_SQL_VARCHAR) =
  720. Parameter #12(CF_SQL_VARCHAR) =
  721. Parameter #13(CF_SQL_INTEGER) = 0
  722.  
  723. addCnt (Datasource=Trizetto, Time=1ms, Records=1) in C:\inetpub\wwwroot\TMI\Trizetto\fusebox\circuits\Admin\Events\Action\act_edit.cfm @ 13:31:45.045
  724.  
  725. INSERT INTO Event_Content (Event_ID, Content_Title, Content_Body, is_Active, User_ID, Create_Date, Sort, Parent_ID, Content_Type, Summary, Page_Name, Page_Key, PK_ID)
  726. VALUES (?,
  727. ?,
  728. ?,
  729. ?,
  730. ?,
  731. ?,
  732. ?,
  733. ?,
  734. ?,
  735. ?,
  736. ?,
  737. ?,
  738. ?)
  739.  
  740.  
  741. Query Parameter Value(s) -
  742. Parameter #1(CF_SQL_INTEGER) = 94
  743. Parameter #2(CF_SQL_VARCHAR) = Conf Email Pending
  744. Parameter #3(CF_SQL_VARCHAR) =
  745. Parameter #4(CF_SQL_VARCHAR) = Yes
  746. Parameter #5(CF_SQL_INTEGER) = 1002
  747. Parameter #6(CF_SQL_TIMESTAMP) = 2017-01-13 08:47:38.03
  748. Parameter #7(CF_SQL_INTEGER) = 0
  749. Parameter #8(CF_SQL_INTEGER) = 0
  750. Parameter #9(CF_SQL_VARCHAR) = Reg
  751. Parameter #10(CF_SQL_VARCHAR) =
  752. Parameter #11(CF_SQL_VARCHAR) =
  753. Parameter #12(CF_SQL_VARCHAR) =
  754. Parameter #13(CF_SQL_INTEGER) = 0
  755.  
  756. addCnt (Datasource=Trizetto, Time=1ms, Records=1) in C:\inetpub\wwwroot\TMI\Trizetto\fusebox\circuits\Admin\Events\Action\act_edit.cfm @ 13:31:45.045
  757.  
  758. INSERT INTO Event_Content (Event_ID, Content_Title, Content_Body, is_Active, User_ID, Create_Date, Sort, Parent_ID, Content_Type, Summary, Page_Name, Page_Key, PK_ID)
  759. VALUES (?,
  760. ?,
  761. ?,
  762. ?,
  763. ?,
  764. ?,
  765. ?,
  766. ?,
  767. ?,
  768. ?,
  769. ?,
  770. ?,
  771. ?)
  772.  
  773.  
  774. Query Parameter Value(s) -
  775. Parameter #1(CF_SQL_INTEGER) = 94
  776. Parameter #2(CF_SQL_VARCHAR) = Conf Page
  777. Parameter #3(CF_SQL_VARCHAR) = <p style="text-align:left"><span style="font-size:14px"><span style="font-family:arial,helvetica,sans-serif">Dear [Regs.First_Name] [Regs.Last_Name],<br /> <br /> Thank you for registering for the TMS Client Forum.</span></span></p> <p style="text-align:left"><span style="font-size:14px"><span style="font-family:arial,helvetica,sans-serif"><a href="https://trizetto.expoplanner.com/index.cfm?do=reg.flow&amp;event_id=60">To access your registration record click here</a></span></span></p> <p style="text-align:left"><span style="font-size:14px"><span style="font-family:arial,helvetica,sans-serif">Email: [Regs.Email]<br /> Password:[Regs.Password]</span></span></p> <p style="text-align:left"><span style="font-size:14px"><span style="font-family:arial,helvetica,sans-serif">If you have any questions, please contact Maria Luis-Brown at (908) 994.3314 or<a href="mailto:Tadia.shipley@trizetto.com"> </a><a href="mailto:marcy.levine@trizetto.com?subject=TriZetto%20Customer%20Group%20">maria.luis-brown@trizetto.com</a>.</span></span></p>
  778. Parameter #4(CF_SQL_VARCHAR) = Yes
  779. Parameter #5(CF_SQL_INTEGER) = 1002
  780. Parameter #6(CF_SQL_TIMESTAMP) = 2017-01-13 08:47:38.033
  781. Parameter #7(CF_SQL_INTEGER) = 0
  782. Parameter #8(CF_SQL_INTEGER) = 0
  783. Parameter #9(CF_SQL_VARCHAR) = Reg
  784. Parameter #10(CF_SQL_VARCHAR) =
  785. Parameter #11(CF_SQL_VARCHAR) =
  786. Parameter #12(CF_SQL_VARCHAR) =
  787. Parameter #13(CF_SQL_INTEGER) = 0
  788.  
  789. addCnt (Datasource=Trizetto, Time=0ms, Records=1) in C:\inetpub\wwwroot\TMI\Trizetto\fusebox\circuits\Admin\Events\Action\act_edit.cfm @ 13:31:45.045
  790.  
  791. INSERT INTO Event_Content (Event_ID, Content_Title, Content_Body, is_Active, User_ID, Create_Date, Sort, Parent_ID, Content_Type, Summary, Page_Name, Page_Key, PK_ID)
  792. VALUES (?,
  793. ?,
  794. ?,
  795. ?,
  796. ?,
  797. ?,
  798. ?,
  799. ?,
  800. ?,
  801. ?,
  802. ?,
  803. ?,
  804. ?)
  805.  
  806.  
  807. Query Parameter Value(s) -
  808. Parameter #1(CF_SQL_INTEGER) = 94
  809. Parameter #2(CF_SQL_VARCHAR) = Conf Page Pending
  810. Parameter #3(CF_SQL_VARCHAR) =
  811. Parameter #4(CF_SQL_VARCHAR) = Yes
  812. Parameter #5(CF_SQL_INTEGER) = 1002
  813. Parameter #6(CF_SQL_TIMESTAMP) = 2017-01-13 08:47:38.037
  814. Parameter #7(CF_SQL_INTEGER) = 0
  815. Parameter #8(CF_SQL_INTEGER) = 0
  816. Parameter #9(CF_SQL_VARCHAR) = Reg
  817. Parameter #10(CF_SQL_VARCHAR) =
  818. Parameter #11(CF_SQL_VARCHAR) =
  819. Parameter #12(CF_SQL_VARCHAR) =
  820. Parameter #13(CF_SQL_INTEGER) = 0
  821.  
  822. addCnt (Datasource=Trizetto, Time=1ms, Records=1) in C:\inetpub\wwwroot\TMI\Trizetto\fusebox\circuits\Admin\Events\Action\act_edit.cfm @ 13:31:45.045
  823.  
  824. INSERT INTO Event_Content (Event_ID, Content_Title, Content_Body, is_Active, User_ID, Create_Date, Sort, Parent_ID, Content_Type, Summary, Page_Name, Page_Key, PK_ID)
  825. VALUES (?,
  826. ?,
  827. ?,
  828. ?,
  829. ?,
  830. ?,
  831. ?,
  832. ?,
  833. ?,
  834. ?,
  835. ?,
  836. ?,
  837. ?)
  838.  
  839.  
  840. Query Parameter Value(s) -
  841. Parameter #1(CF_SQL_INTEGER) = 94
  842. Parameter #2(CF_SQL_VARCHAR) = Reg Closed
  843. Parameter #3(CF_SQL_VARCHAR) =
  844. Parameter #4(CF_SQL_VARCHAR) = Yes
  845. Parameter #5(CF_SQL_INTEGER) = 1002
  846. Parameter #6(CF_SQL_TIMESTAMP) = 2017-01-13 08:47:38.037
  847. Parameter #7(CF_SQL_INTEGER) = 0
  848. Parameter #8(CF_SQL_INTEGER) = 0
  849. Parameter #9(CF_SQL_VARCHAR) = Reg
  850. Parameter #10(CF_SQL_VARCHAR) =
  851. Parameter #11(CF_SQL_VARCHAR) =
  852. Parameter #12(CF_SQL_VARCHAR) =
  853. Parameter #13(CF_SQL_INTEGER) = 0
  854.  
  855. addCnt (Datasource=Trizetto, Time=1ms, Records=1) in C:\inetpub\wwwroot\TMI\Trizetto\fusebox\circuits\Admin\Events\Action\act_edit.cfm @ 13:31:45.045
  856.  
  857. INSERT INTO Event_Content (Event_ID, Content_Title, Content_Body, is_Active, User_ID, Create_Date, Sort, Parent_ID, Content_Type, Summary, Page_Name, Page_Key, PK_ID)
  858. VALUES (?,
  859. ?,
  860. ?,
  861. ?,
  862. ?,
  863. ?,
  864. ?,
  865. ?,
  866. ?,
  867. ?,
  868. ?,
  869. ?,
  870. ?)
  871.  
  872.  
  873. Query Parameter Value(s) -
  874. Parameter #1(CF_SQL_INTEGER) = 94
  875. Parameter #2(CF_SQL_VARCHAR) = Invite Conf Email
  876. Parameter #3(CF_SQL_VARCHAR) =
  877. Parameter #4(CF_SQL_VARCHAR) = Yes
  878. Parameter #5(CF_SQL_INTEGER) = 1002
  879. Parameter #6(CF_SQL_TIMESTAMP) = 2017-01-13 08:47:38.04
  880. Parameter #7(CF_SQL_INTEGER) = 0
  881. Parameter #8(CF_SQL_INTEGER) = 0
  882. Parameter #9(CF_SQL_VARCHAR) = Reg
  883. Parameter #10(CF_SQL_VARCHAR) =
  884. Parameter #11(CF_SQL_VARCHAR) =
  885. Parameter #12(CF_SQL_VARCHAR) =
  886. Parameter #13(CF_SQL_INTEGER) = 0
  887.  
  888. addCnt (Datasource=Trizetto, Time=0ms, Records=1) in C:\inetpub\wwwroot\TMI\Trizetto\fusebox\circuits\Admin\Events\Action\act_edit.cfm @ 13:31:45.045
  889.  
  890. INSERT INTO Event_Content (Event_ID, Content_Title, Content_Body, is_Active, User_ID, Create_Date, Sort, Parent_ID, Content_Type, Summary, Page_Name, Page_Key, PK_ID)
  891. VALUES (?,
  892. ?,
  893. ?,
  894. ?,
  895. ?,
  896. ?,
  897. ?,
  898. ?,
  899. ?,
  900. ?,
  901. ?,
  902. ?,
  903. ?)
  904.  
  905.  
  906. Query Parameter Value(s) -
  907. Parameter #1(CF_SQL_INTEGER) = 94
  908. Parameter #2(CF_SQL_VARCHAR) = Invoice
  909. Parameter #3(CF_SQL_VARCHAR) =
  910. Parameter #4(CF_SQL_VARCHAR) = Yes
  911. Parameter #5(CF_SQL_INTEGER) = 1002
  912. Parameter #6(CF_SQL_TIMESTAMP) = 2017-01-13 08:47:38.04
  913. Parameter #7(CF_SQL_INTEGER) = 0
  914. Parameter #8(CF_SQL_INTEGER) = 0
  915. Parameter #9(CF_SQL_VARCHAR) = Reg
  916. Parameter #10(CF_SQL_VARCHAR) =
  917. Parameter #11(CF_SQL_VARCHAR) =
  918. Parameter #12(CF_SQL_VARCHAR) =
  919. Parameter #13(CF_SQL_INTEGER) = 0
  920.  
  921. addCnt (Datasource=Trizetto, Time=0ms, Records=1) in C:\inetpub\wwwroot\TMI\Trizetto\fusebox\circuits\Admin\Events\Action\act_edit.cfm @ 13:31:45.045
  922.  
  923. INSERT INTO Event_Content (Event_ID, Content_Title, Content_Body, is_Active, User_ID, Create_Date, Sort, Parent_ID, Content_Type, Summary, Page_Name, Page_Key, PK_ID)
  924. VALUES (?,
  925. ?,
  926. ?,
  927. ?,
  928. ?,
  929. ?,
  930. ?,
  931. ?,
  932. ?,
  933. ?,
  934. ?,
  935. ?,
  936. ?)
  937.  
  938.  
  939. Query Parameter Value(s) -
  940. Parameter #1(CF_SQL_INTEGER) = 94
  941. Parameter #2(CF_SQL_VARCHAR) = Agenda
  942. Parameter #3(CF_SQL_VARCHAR) = <table align="left" border="0" cellpadding="0" cellspacing="7" style="height:1117px; width:732px"> <tbody> <tr> <td colspan="2" style="height:20px; width:718px"> <p style="text-align:center"><span style="font-family:arial,helvetica,sans-serif"><span style="font-size:36px"><strong><span style="color:rgb(51, 153, 204)">Agenda </span></strong></span></span></p> <hr /> <p><span style="font-size:18px"><span style="font-family:arial,helvetica,sans-serif"><strong><span style="color:rgb(51, 153, 204)">Tuesday, February 21, 2017</span></strong></span></span></p> <hr /></td> </tr> <tr> <td style="width:154px"> <p><strong>1:00 p.m. &ndash; 1:30 p.m.</strong></p> </td> <td style="width:557px"> <p><strong>Welcome, Introductions, Agenda Review and Strategy Overview</strong></p> </td> </tr> <tr> <td style="height:10px; width:154px"> <p><strong>1:30 p.m. - 2:30 p.m.</strong></p> </td> <td style="height:10px; width:557px"> <p><strong>Roadmap Review</strong></p> </td> </tr> <tr> <td style="width:154px"> <p><strong>2:30 p.m. - 2:45 p.m.</strong></p> </td> <td style="width:557px"> <p><strong>Break</strong></p> </td> </tr> <tr> <td style="width:154px"> <p><strong>2:45 p.m. - 3:45 p.m.</strong></p> </td> <td style="width:557px"> <p><strong>Roadmap Deep Dive &ndash; Part 1</strong></p> </td> </tr> <tr> <td style="width:154px"> <p><strong>3:45 p.m. &ndash; 4:15 p.m.</strong></p> </td> <td style="width:557px"> <p><strong>Development Update</strong></p> </td> </tr> <tr> <td style="width:154px"> <p><strong>4:15 p.m. &ndash; 4:30 p.m.</strong></p> </td> <td style="width:557px"> <p><strong>Break</strong></p> </td> </tr> <tr> <td style="width:154px"> <p><strong>4:30 p.m. &ndash; 5:30 p.m.</strong></p> </td> <td style="width:557px"> <p><strong>Roadmap Deep Dive &ndash; Part 2</strong></p> </td> </tr> <tr> <td style="width:154px"> <p><strong>5:30 p.m. &ndash; 8:00 p.m.</strong></p> </td> <td style="width:557px"> <p><strong>Networking Reception</strong></p> </td> </tr> <tr> <td colspan="2" style="height:20px; width:718px"> <hr /> <p><span style="font-size:18px"><span style="font-family:arial,helvetica,sans-serif"><strong><span style="color:rgb(51, 153, 204)">Wednesday, February 22, 2017</span></strong></span></span></p> <hr /></td> </tr> <tr> <td style="width:154px"> <p><strong>7:30 a.m. &ndash; 8:00 a.m.</strong></p> </td> <td style="width:557px"> <p><strong>Breakfast </strong></p> </td> </tr> <tr> <td style="width:154px"> <p><strong>8:30 a.m. &ndash; 9:30 a.m.</strong></p> </td> <td style="width:557px"> <p><strong>Breakout Sessions</strong></p> </td> </tr> <tr> <td style="width:154px"> <p><strong>9:30 a.m. &ndash; 10:30 a.m.</strong></p> </td> <td style="width:557px"> <p><strong>How-to Roundtables</strong></p> </td> </tr> <tr> <td style="width:154px"> <p><strong>10:30 a.m. &ndash; 10:45 a.m.</strong></p> </td> <td style="width:557px"> <p><strong>Break</strong></p> </td> </tr> <tr> <td style="width:154px"> <p><strong>10:45 a.m. -12:00 p.m.</strong></p> </td> <td style="width:557px"> <p><strong>How-to Roundtables (cont&rsquo;d)</strong></p> </td> </tr> <tr> <td style="width:154px"> <p><strong>12:00 p.m. &ndash; 1:00 p.m.</strong></p> </td> <td style="width:557px"> <p><strong>Lunch</strong></p> </td> </tr> <tr> <td style="width:154px"> <p><strong>1:00 p.m. &ndash; 2:00 p.m.</strong></p> </td> <td style="width:557px"> <p><strong>Services and Support Team Panel</strong></p> </td> </tr> <tr> <td style="width:154px"> <p><strong>2:00 p.m. &ndash; 2:30 p.m.</strong></p> </td> <td style="width:557px"> <p><strong>Client Engagement and User Groups</strong></p> </td> </tr> <tr> <td style="width:154px"> <p><strong>2:30 p.m. &ndash; 3:00 p.m.</strong></p> </td> <td style="width:557px"> <p><strong>Wrap-Up and Farewell</strong></p> </td> </tr> </tbody> </table>
  943. Parameter #4(CF_SQL_VARCHAR) = Yes
  944. Parameter #5(CF_SQL_INTEGER) = 1002
  945. Parameter #6(CF_SQL_TIMESTAMP) = 2017-01-13 09:57:38.137
  946. Parameter #7(CF_SQL_INTEGER) = 0
  947. Parameter #8(CF_SQL_INTEGER) = 0
  948. Parameter #9(CF_SQL_VARCHAR) = html
  949. Parameter #10(CF_SQL_VARCHAR) =
  950. Parameter #11(CF_SQL_VARCHAR) =
  951. Parameter #12(CF_SQL_VARCHAR) =
  952. Parameter #13(CF_SQL_INTEGER) = 0
  953.  
  954. addCnt (Datasource=Trizetto, Time=0ms, Records=1) in C:\inetpub\wwwroot\TMI\Trizetto\fusebox\circuits\Admin\Events\Action\act_edit.cfm @ 13:31:45.045
  955.  
  956. INSERT INTO Event_Content (Event_ID, Content_Title, Content_Body, is_Active, User_ID, Create_Date, Sort, Parent_ID, Content_Type, Summary, Page_Name, Page_Key, PK_ID)
  957. VALUES (?,
  958. ?,
  959. ?,
  960. ?,
  961. ?,
  962. ?,
  963. ?,
  964. ?,
  965. ?,
  966. ?,
  967. ?,
  968. ?,
  969. ?)
  970.  
  971.  
  972. Query Parameter Value(s) -
  973. Parameter #1(CF_SQL_INTEGER) = 94
  974. Parameter #2(CF_SQL_VARCHAR) = General Information
  975. Parameter #3(CF_SQL_VARCHAR) = <p style="text-align:center"><span style="font-family:arial,helvetica,sans-serif"><span style="font-size:36px"><strong><span style="color:rgb(51, 153, 204)">General Information</span></strong></span></span></p> <hr /> <h1><strong>TMS User Forum Location:</strong></h1> <h2><span style="font-size:16px">1085 Morris Avenue, 3rd Floor, Union, NJ 07029</span></h2> <p>&nbsp;</p> <h1><strong>Reception</strong></h1> <p><span style="font-size:16px">TBD</span></p> <p>&nbsp;</p> <h1><strong>Shuttle Services:</strong></h1> <p><span style="font-size:16px">Shuttle services will be provided to the forum location and reception and back to the Renaissance Hotel</span>.</p> <p>&nbsp;</p> <p>&nbsp;</p>
  976. Parameter #4(CF_SQL_VARCHAR) = Yes
  977. Parameter #5(CF_SQL_INTEGER) = 1002
  978. Parameter #6(CF_SQL_TIMESTAMP) = 2017-01-13 09:58:41.353
  979. Parameter #7(CF_SQL_INTEGER) = 0
  980. Parameter #8(CF_SQL_INTEGER) = 0
  981. Parameter #9(CF_SQL_VARCHAR) = html
  982. Parameter #10(CF_SQL_VARCHAR) =
  983. Parameter #11(CF_SQL_VARCHAR) =
  984. Parameter #12(CF_SQL_VARCHAR) =
  985. Parameter #13(CF_SQL_INTEGER) = 0
  986.  
  987. addCnt (Datasource=Trizetto, Time=1ms, Records=1) in C:\inetpub\wwwroot\TMI\Trizetto\fusebox\circuits\Admin\Events\Action\act_edit.cfm @ 13:31:45.045
  988.  
  989. INSERT INTO Event_Content (Event_ID, Content_Title, Content_Body, is_Active, User_ID, Create_Date, Sort, Parent_ID, Content_Type, Summary, Page_Name, Page_Key, PK_ID)
  990. VALUES (?,
  991. ?,
  992. ?,
  993. ?,
  994. ?,
  995. ?,
  996. ?,
  997. ?,
  998. ?,
  999. ?,
  1000. ?,
  1001. ?,
  1002. ?)
  1003.  
  1004.  
  1005. Query Parameter Value(s) -
  1006. Parameter #1(CF_SQL_INTEGER) = 94
  1007. Parameter #2(CF_SQL_VARCHAR) = Hotel
  1008. Parameter #3(CF_SQL_VARCHAR) = <table align="left" border="0" cellpadding="5" cellspacing="5" style="background-color:rgb(255, 255, 255); border-style:hidden; height:93px; width:950px"> <tbody> <tr> <td style="height:20px; text-align:center; width:1000px"><span style="font-family:arial,helvetica,sans-serif"><span style="font-size:36px"><strong><span style="color:rgb(51, 153, 204)">Hotel</span></strong></span></span></td> </tr> </tbody> </table> <h2 style="text-align:center">&nbsp;</h2> <table align="left" border="0" cellpadding="1" cellspacing="7" style="background-color:rgb(230, 230, 250); border-style:hidden; width:950px"> <tbody> <tr> <td style="background-color:rgb(230, 230, 250); height:20px; width:1000px"><span style="font-family:arial,helvetica,sans-serif"><span style="color:rgb(105, 105, 105)"><strong><span style="font-size:20px">Hotel Reservations</span></strong></span></span></td> </tr> </tbody> </table> <p>&nbsp;</p> <p>&nbsp;</p> <p>&nbsp;</p> <p><a href="http://www.marriott.com/meeting-event-hotels/group-corporate-travel/groupCorp.mi?resLinkData=TriZetto%20Group%20the%20Corporation%20%5Eewrnr%60TRZTRZA%60139.00%60USD%60false%605%602/20/17%602/23/17%602/6/17&amp;app=resvlink&amp;stop_mobi=yes"><span style="font-size:24px"><strong><span style="color:rgb(0, 102, 153)"><img alt="" src="https://trizetto.expoplanner.com/files/userfiles/images/clickhere.jpg" style="height:25px; width:93px" /></span></strong></span></a></p> <p><span style="font-size:14px"><span style="font-family:arial,helvetica,sans-serif"><strong>Renaissance Newark Airport Hotel</strong><br /> 1000 Spring Street<br /> Elizabeth, New Jersey 07201 USA<br /> (908) 436-4600&nbsp;&nbsp;&nbsp;</span></span></p> <p><span style="font-size:14px"><span style="font-family:arial,helvetica,sans-serif">Reservations for the Renaissance Newark Airport Hotel&nbsp;are available from February 20-23.&nbsp; You will&nbsp;be&nbsp;responsible for making your own hotel reservations for the meeting.&nbsp; </span></span></p> <p><span style="font-size:14px"><span style="font-family:arial,helvetica,sans-serif">The group rate of $139.00 is guaranteed through February 6, 2017.&nbsp; To ensure you will receive the group rate, please make your&nbsp;reservations prior to the deadline.&nbsp; <strong>We cannot guarantee the group rate after February 6th.</strong></span></span></p> <p><span style="font-size:14px"><span style="font-family:arial,helvetica,sans-serif">Phone reservations are available by calling&nbsp;the Marriott Toll Free at 1-866-234-7535 or click on the link below to view hotel information and&nbsp;make your reservations&nbsp;online for the Renaissance Newark Airport Hotel.</span></span></p> <p><span style="font-size:14px"><span style="font-family:arial,helvetica,sans-serif">You will be responsible for making your hotel reservations.</span></span></p> <table align="left" border="0" cellpadding="1" cellspacing="7" style="background-color:rgb(230, 230, 250); border-style:hidden; width:950px"> <tbody> <tr> <td style="background-color:rgb(230, 230, 250); height:20px; width:1000px"><span style="font-family:arial,helvetica,sans-serif"><span style="color:rgb(105, 105, 105)"><strong><span style="font-size:20px">Hotel Check-in/Check-Out</span></strong></span></span></td> </tr> </tbody> </table> <p>&nbsp;</p> <p><br /> <span style="font-family:verdana,geneva,sans-serif"><span style="font-size:12px"><span style="font-size:14px"><span style="font-family:arial,helvetica,sans-serif">Check-in time is 4 p.m., and check-out time is 11 a.m. Early check-in may be requested; however, it is not guaranteed. Your luggage can be stored<br /> for your convenience until your room is available.</span></span></span></span></p> <table align="left" border="0" cellpadding="1" cellspacing="7" style="background-color:rgb(230, 230, 250); border-style:hidden; width:950px"> <tbody> <tr> <td style="height:20px; width:1000px"><span style="color:rgb(105, 105, 105)"><strong><span style="font-size:20px">Parking&nbsp;&nbsp;&nbsp;</span></strong></span><span style="color:rgb(255, 0, 0)"><span style="font-size:12px"><span style="font-family:verdana,geneva,sans-serif"><strong>&nbsp;</strong></span></span></span></td> </tr> </tbody> </table> <p><br /> &nbsp;</p> <p><span style="font-size:14px"><span style="font-family:arial,helvetica,sans-serif">On-site parking, fee: $7.00 USD daily if attending the meeting</span></span></p> <p><span style="font-size:14px"><span style="font-family:arial,helvetica,sans-serif">Self parking for overnight guests: $16 USD</span></span></p> <table align="left" border="0" cellpadding="1" cellspacing="7" style="background-color:rgb(230, 230, 250); border-style:hidden; width:950px"> <tbody> <tr> <td style="height:20px; width:1000px"><span style="color:rgb(105, 105, 105)"><strong><span style="font-size:20px">Area Airport&nbsp;</span></strong></span><span style="color:rgb(255, 0, 0)"><span style="font-size:12px"><span style="font-family:verdana,geneva,sans-serif"><strong>&nbsp;</strong></span></span></span></td> </tr> </tbody> </table> <p>&nbsp;</p> <p><br /> <span style="font-family:verdana,geneva,sans-serif"><span style="font-size:12px"><span style="font-size:14px"><span style="font-family:arial,helvetica,sans-serif">Newark Liberty International Airport - EWR<br /> Hotel direction: 3 mile(s)&nbsp;SE</span></span></span></span></p> <table align="left" border="0" cellpadding="1" cellspacing="7" style="background-color:rgb(230, 230, 250); border-style:hidden; width:950px"> <tbody> <tr> <td style="height:20px; width:1000px"><span style="color:rgb(105, 105, 105)"><strong><span style="font-size:20px">Shuttle Service - Complimentary</span></strong></span><span style="color:rgb(255, 0, 0)"><span style="font-size:12px"><span style="font-family:verdana,geneva,sans-serif"><strong>&nbsp;</strong></span></span></span></td> </tr> </tbody> </table> <p>&nbsp;</p> <hr /> <p><span style="font-size:14px"><span style="font-family:arial,helvetica,sans-serif">Shuttle pick-up from P-4 upon arrival, for departure, drop off is available from hotel back to the airport.</span></span></p> <p>&nbsp;</p>
  1009. Parameter #4(CF_SQL_VARCHAR) = Yes
  1010. Parameter #5(CF_SQL_INTEGER) = 290
  1011. Parameter #6(CF_SQL_TIMESTAMP) = 2017-01-13 10:05:18.07
  1012. Parameter #7(CF_SQL_INTEGER) = 0
  1013. Parameter #8(CF_SQL_INTEGER) = 0
  1014. Parameter #9(CF_SQL_VARCHAR) = html
  1015. Parameter #10(CF_SQL_VARCHAR) =
  1016. Parameter #11(CF_SQL_VARCHAR) =
  1017. Parameter #12(CF_SQL_VARCHAR) =
  1018. Parameter #13(CF_SQL_INTEGER) = 0
  1019.  
  1020. getAttCats (Datasource=Trizetto, Time=0ms, Records=4) in C:\inetpub\wwwroot\TMI\Trizetto\fusebox\circuits\Admin\Events\Action\act_edit.cfm @ 13:31:45.045
  1021.  
  1022. SELECT *
  1023. FROM XR_Event_Att_Cats
  1024. WHERE Event_ID = ?
  1025.  
  1026. Query Parameter Value(s) -
  1027. Parameter #1(CF_SQL_INTEGER) = 60
  1028.  
  1029. addAttCat (Datasource=Trizetto, Time=0ms, Records=1) in C:\inetpub\wwwroot\TMI\Trizetto\fusebox\circuits\Admin\Events\Action\act_edit.cfm @ 13:31:45.045
  1030.  
  1031. INSERT INTO XR_Event_Att_Cats (Event_ID, Att_Cat, Reg_Code, is_Public, Base_Price, Member_Price, Tax_Rate, Inventory, Sort, is_Exhib, Member_Check, is_Attend, is_Guest,
  1032. is_Group, Badge_Holder_Color, Badge_Text, Window_Text, Cat_Type, Header, chk_States, member_header, Sub_Cat_ID, is_Speaker, Conf_Email, Conf_Page,
  1033. is_Schol, Group_Max, Hotel_Code, Member_Valid_Date, max_seats, Reg_Code_maxUses, is_Comp_Exhib)
  1034. VALUES (?,
  1035. ?,
  1036. ?,
  1037. ?,
  1038. ?,
  1039. ?,
  1040. ?,
  1041. ?,
  1042. ?,
  1043. ?,
  1044. ?,
  1045. ?,
  1046. ?,
  1047. ?,
  1048. ?,
  1049. ?,
  1050. ?,
  1051. ?,
  1052. ?,
  1053. ?,
  1054. ?,
  1055. ?,
  1056. ?,
  1057. ?,
  1058. ?,
  1059. ?,
  1060. ?,
  1061. ?,
  1062. ?,
  1063. ?,
  1064. ?,
  1065. ?)
  1066.  
  1067.  
  1068.  
  1069. Query Parameter Value(s) -
  1070. Parameter #1(CF_SQL_INTEGER) = 94
  1071. Parameter #2(CF_SQL_VARCHAR) = Client
  1072. Parameter #3(CF_SQL_VARCHAR) =
  1073. Parameter #4(CF_SQL_VARCHAR) = Yes
  1074. Parameter #5(CF_SQL_MONEY) = 0
  1075. Parameter #6(CF_SQL_MONEY) = 0
  1076. Parameter #7(CF_SQL_MONEY) = 0
  1077. Parameter #8(CF_SQL_INTEGER) = 0
  1078. Parameter #9(CF_SQL_INTEGER) = 0
  1079. Parameter #10(CF_SQL_VARCHAR) = No
  1080. Parameter #11(CF_SQL_VARCHAR) = No
  1081. Parameter #12(CF_SQL_VARCHAR) = Yes
  1082. Parameter #13(CF_SQL_VARCHAR) = No
  1083. Parameter #14(CF_SQL_VARCHAR) = No
  1084. Parameter #15(CF_SQL_VARCHAR) =
  1085. Parameter #16(CF_SQL_VARCHAR) =
  1086. Parameter #17(CF_SQL_VARCHAR) =
  1087. Parameter #18(CF_SQL_VARCHAR) = Doctor
  1088. Parameter #19(CF_SQL_VARCHAR) =
  1089. Parameter #20(CF_SQL_VARCHAR) = No
  1090. Parameter #21(CF_SQL_VARCHAR) =
  1091. Parameter #22(CF_SQL_INTEGER) = 0
  1092. Parameter #23(CF_SQL_VARCHAR) = No
  1093. Parameter #24(CF_SQL_VARCHAR) =
  1094. Parameter #25(CF_SQL_VARCHAR) =
  1095. Parameter #26(CF_SQL_VARCHAR) = No
  1096. Parameter #27(CF_SQL_INTEGER) = 0
  1097. Parameter #28(CF_SQL_VARCHAR) =
  1098. Parameter #29(CF_SQL_TIMESTAMP) =
  1099. Parameter #30(CF_SQL_INTEGER) = 0
  1100. Parameter #31(CF_SQL_INTEGER) = 0
  1101. Parameter #32(CF_SQL_VARCHAR) = No
  1102.  
  1103. addAttCat (Datasource=Trizetto, Time=1ms, Records=1) in C:\inetpub\wwwroot\TMI\Trizetto\fusebox\circuits\Admin\Events\Action\act_edit.cfm @ 13:31:45.045
  1104.  
  1105. INSERT INTO XR_Event_Att_Cats (Event_ID, Att_Cat, Reg_Code, is_Public, Base_Price, Member_Price, Tax_Rate, Inventory, Sort, is_Exhib, Member_Check, is_Attend, is_Guest,
  1106. is_Group, Badge_Holder_Color, Badge_Text, Window_Text, Cat_Type, Header, chk_States, member_header, Sub_Cat_ID, is_Speaker, Conf_Email, Conf_Page,
  1107. is_Schol, Group_Max, Hotel_Code, Member_Valid_Date, max_seats, Reg_Code_maxUses, is_Comp_Exhib)
  1108. VALUES (?,
  1109. ?,
  1110. ?,
  1111. ?,
  1112. ?,
  1113. ?,
  1114. ?,
  1115. ?,
  1116. ?,
  1117. ?,
  1118. ?,
  1119. ?,
  1120. ?,
  1121. ?,
  1122. ?,
  1123. ?,
  1124. ?,
  1125. ?,
  1126. ?,
  1127. ?,
  1128. ?,
  1129. ?,
  1130. ?,
  1131. ?,
  1132. ?,
  1133. ?,
  1134. ?,
  1135. ?,
  1136. ?,
  1137. ?,
  1138. ?,
  1139. ?)
  1140.  
  1141.  
  1142.  
  1143. Query Parameter Value(s) -
  1144. Parameter #1(CF_SQL_INTEGER) = 94
  1145. Parameter #2(CF_SQL_VARCHAR) = Admin Only
  1146. Parameter #3(CF_SQL_VARCHAR) =
  1147. Parameter #4(CF_SQL_VARCHAR) = No
  1148. Parameter #5(CF_SQL_MONEY) = 0
  1149. Parameter #6(CF_SQL_MONEY) = 0
  1150. Parameter #7(CF_SQL_MONEY) = 0
  1151. Parameter #8(CF_SQL_INTEGER) = 0
  1152. Parameter #9(CF_SQL_INTEGER) = 0
  1153. Parameter #10(CF_SQL_VARCHAR) = No
  1154. Parameter #11(CF_SQL_VARCHAR) = No
  1155. Parameter #12(CF_SQL_VARCHAR) = Yes
  1156. Parameter #13(CF_SQL_VARCHAR) = No
  1157. Parameter #14(CF_SQL_VARCHAR) = No
  1158. Parameter #15(CF_SQL_VARCHAR) =
  1159. Parameter #16(CF_SQL_VARCHAR) =
  1160. Parameter #17(CF_SQL_VARCHAR) =
  1161. Parameter #18(CF_SQL_VARCHAR) = Doctor
  1162. Parameter #19(CF_SQL_VARCHAR) =
  1163. Parameter #20(CF_SQL_VARCHAR) = No
  1164. Parameter #21(CF_SQL_VARCHAR) =
  1165. Parameter #22(CF_SQL_INTEGER) = 0
  1166. Parameter #23(CF_SQL_VARCHAR) = No
  1167. Parameter #24(CF_SQL_VARCHAR) =
  1168. Parameter #25(CF_SQL_VARCHAR) =
  1169. Parameter #26(CF_SQL_VARCHAR) = No
  1170. Parameter #27(CF_SQL_INTEGER) = 0
  1171. Parameter #28(CF_SQL_VARCHAR) =
  1172. Parameter #29(CF_SQL_TIMESTAMP) =
  1173. Parameter #30(CF_SQL_INTEGER) = 0
  1174. Parameter #31(CF_SQL_INTEGER) = 0
  1175. Parameter #32(CF_SQL_VARCHAR) = No
  1176.  
  1177. Scope Variables
  1178.  
  1179. CGI Variables:
  1180. AUTH_PASSWORD=
  1181. AUTH_TYPE=
  1182. AUTH_USER=
  1183. CERT_COOKIE=
  1184. CERT_FLAGS=
  1185. CERT_ISSUER=
  1186. CERT_KEYSIZE=
  1187. CERT_SECRETKEYSIZE=
  1188. CERT_SERIALNUMBER=
  1189. CERT_SERVER_ISSUER=
  1190. CERT_SERVER_SUBJECT=
  1191. CERT_SUBJECT=
  1192. CF_TEMPLATE_PATH=C:\inetpub\wwwroot\TMI\Trizetto\index.cfm
  1193. CONTENT_LENGTH=351
  1194. CONTENT_TYPE=application/x-www-form-urlencoded
  1195. CONTEXT_PATH=
  1196. GATEWAY_INTERFACE=CGI/1.1
  1197. HTTPS=off
  1198. HTTPS_KEYSIZE=
  1199. HTTPS_SECRETKEYSIZE=
  1200. HTTPS_SERVER_ISSUER=
  1201. HTTPS_SERVER_SUBJECT=
  1202. HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
  1203. HTTP_ACCEPT_ENCODING=gzip, deflate
  1204. HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
  1205. HTTP_CONNECTION=keep-alive
  1206. HTTP_COOKIE=_ga=GA1.2.1159540804.1482510000; CFID=311; CFTOKEN=fb6e4d79d3b60c25-F56A534F-00FD-6B1B-5CA66C39205A49DC; JSESSIONID=81C5989231807E0953D123169F2AFC5D.cfusion
  1207. HTTP_HOST=trizetto.luceconsulting.net
  1208. HTTP_REFERER=http://trizetto.luceconsulting.net/index.cfm?do=events.edit&event_id=0
  1209. HTTP_URL=
  1210. HTTP_USER_AGENT=Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:45.9) Gecko/20100101 Goanna/3.0 Firefox/45.9 PaleMoon/27.0.3
  1211. LOCAL_ADDR=tdi.luceconsulting.net
  1212. PATH_INFO=
  1213. PATH_TRANSLATED=C:\inetpub\wwwroot\TMI\Trizetto\index.cfm
  1214. QUERY_STRING=do=events.editAction
  1215. REMOTE_ADDR=127.0.0.1
  1216. REMOTE_HOST=127.0.0.1
  1217. REMOTE_USER=
  1218. REQUEST_METHOD=POST
  1219. SCRIPT_NAME=/index.cfm
  1220. SERVER_NAME=trizetto.luceconsulting.net
  1221. SERVER_PORT=80
  1222. SERVER_PORT_SECURE=0
  1223. SERVER_PROTOCOL=HTTP/1.1
  1224. SERVER_SOFTWARE=Microsoft-IIS/7.5
  1225. WEB_SERVER_API=
  1226.  
  1227. Cookie Variables:
  1228. CFID=311
  1229. CFTOKEN=fb6e4d79d3b60c25-F56A534F-00FD-6B1B-5CA66C39205A49DC
  1230. JSESSIONID=81C5989231807E0953D123169F2AFC5D.cfusion
  1231. _ga=GA1.2.1159540804.1482510000
  1232.  
  1233. Form Fields:
  1234. ALPHA_SPLIT_COUNTERS=0
  1235. BADGE_LAYOUT=
  1236. CANCEL_DATE=01/17/2017
  1237. CANCEL_FEE=
  1238. CLONE_ID=60
  1239. DATAFORM=CONTINUE
  1240. END_DATE=01/21/2017
  1241. EVENT_EMAIL=greg@tmiexpos.com
  1242. EVENT_EXHIB_EMAIL=
  1243. EVENT_ID=0
  1244. EVENT_NAME=GREGTEST
  1245. EVENT_NICKNAME=GT
  1246. EVENT_PHONE=888-888-8888
  1247. FIELDNAMES=EVENT_ID,RETURN,EVENT_NAME,EVENT_NICKNAME,CANCEL_FEE,OWNER_ID,EVENT_EMAIL,EVENT_EXHIB_EMAIL,EVENT_PHONE,VENUE_ID,PRICE_MODEL,BADGE_LAYOUT,ALPHA_SPLIT_COUNTERS,URL,PROJ_ATTEND,CLONE_ID,DATAFORM
  1248. OWNER_ID=1001
  1249. PRICE_MODEL=
  1250. PROJ_ATTEND=3
  1251. RETURN=next
  1252. START_DATE=01/19/2017
  1253. URL=GT
  1254. VENUE_ID=0
  1255.  
  1256. Session Variables:
  1257. cfid=311
  1258. cftoken=fb6e4d79d3b60c25-F56A534F-00FD-6B1B-5CA66C39205A49DC
  1259. currency_code=USD
  1260. event_id=94
  1261. fileinit=1
  1262. language=English (US)
  1263. mobi_chk=0
  1264. module_id=1
  1265. pubuser_id=1001
  1266. sessionid=TRIZETTO_311_fb6e4d79d3b60c25-F56A534F-00FD-6B1B-5CA66C39205A49DC
  1267. urltoken=CFID=311&CFTOKEN=fb6e4d79d3b60c25-F56A534F-00FD-6B1B-5CA66C39205A49DC
  1268. user=Struct (10)
  1269.  
  1270. URL Parameters:
  1271. do=events.editAction
  1272.  
  1273. Debug Rendering Time: 7 ms
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!