Hi. I am testing a component using a custom SQL query in PostgreSQL. When viewing the query in Working Preview I can see the data just fine. It is repeatable and works every time I click working preview. However, when I click on Live Preview nothing happens. I then uploaded the component embeded in a blank web page to my localhost to test it in a web page and I get:
***
<%a5 'The componentAlias MUST be UNIQUE for each component on the page. It must not have spaces in the name. Keep name as short as possible dim componentAlias as c componentAlias = "TEST" Delete tmpl_TEST DIM tmpl_TEST as P tmpl_TEST = a5w_load_component("test") 'SYSTEM GENERATED COMMENT - PLEASE DO NOT REMOVE (LOAD:test) 'Following code allows you to override settings in the saved component. DO NOT REMOVE SYSTEM GENERATED OVERRIDE_SETTINGS tmpl_TEST.override_settings = <<%override_settings% componentName = componentAlias _gridFilename = "test" %override_settings% 'TIP: To refer to local or page variables in the override_settings string, you must first define a local 'dot variable called 'pageVar' with properties for all of the variables you want to reference. For example: ' dim pageVar as p ' pageVar.gridRowCount = 10 'Then, in the override_settings string, you can reference pageVar.gridRowCount. For example: ' rows = pageVar.gridRowCount 'Resolve session and page variables in the override_settings string. a5w_resolveVariablesInOverrideSettings(tmpl_TEST,session,local_variables()) delete x_TEST dim x_TEST as p x_TEST = a5w_run_Component(tmpl_TEST) 'SYSTEM GENERATED COMMENT - PLEASE DO NOT REMOVE (RUN:tmpl_TEST) (EDIT:test) if x_TEST.RedirectURL <> "" then response.redirect(x_TEST.redirectURL) end end if ?x_TEST.Output.Head.JavaScript ?x_TEST.Output.Head.CSS_Link %> <%a5 ?x_TEST.Output.Body.Body_Tag %>
<%A5 ?x_TEST.Output.Body.Search_HTML %> <%A5 ?x_TEST.Output.Body.Grid_HTML %> <%A5 ?x_TEST.Output.Body.DetailView_HTML %>
***
The component name is test.
Database is PostgreSQL
Browser tested is Firefox 13 and Chrome 19 both with same results. Internet Explorer 9 doesn't show anything but a white page. Again, it works fine in Working Preview.
Any help on a setting adjustment or something I am doing wrong would be great!
***
<%a5 'The componentAlias MUST be UNIQUE for each component on the page. It must not have spaces in the name. Keep name as short as possible dim componentAlias as c componentAlias = "TEST" Delete tmpl_TEST DIM tmpl_TEST as P tmpl_TEST = a5w_load_component("test") 'SYSTEM GENERATED COMMENT - PLEASE DO NOT REMOVE (LOAD:test) 'Following code allows you to override settings in the saved component. DO NOT REMOVE SYSTEM GENERATED OVERRIDE_SETTINGS tmpl_TEST.override_settings = <<%override_settings% componentName = componentAlias _gridFilename = "test" %override_settings% 'TIP: To refer to local or page variables in the override_settings string, you must first define a local 'dot variable called 'pageVar' with properties for all of the variables you want to reference. For example: ' dim pageVar as p ' pageVar.gridRowCount = 10 'Then, in the override_settings string, you can reference pageVar.gridRowCount. For example: ' rows = pageVar.gridRowCount 'Resolve session and page variables in the override_settings string. a5w_resolveVariablesInOverrideSettings(tmpl_TEST,session,local_variables()) delete x_TEST dim x_TEST as p x_TEST = a5w_run_Component(tmpl_TEST) 'SYSTEM GENERATED COMMENT - PLEASE DO NOT REMOVE (RUN:tmpl_TEST) (EDIT:test) if x_TEST.RedirectURL <> "" then response.redirect(x_TEST.redirectURL) end end if ?x_TEST.Output.Head.JavaScript ?x_TEST.Output.Head.CSS_Link %> <%a5 ?x_TEST.Output.Body.Body_Tag %>
<%A5 ?x_TEST.Output.Body.Search_HTML %> <%A5 ?x_TEST.Output.Body.Grid_HTML %> <%A5 ?x_TEST.Output.Body.DetailView_HTML %>
***
The component name is test.
Database is PostgreSQL
Browser tested is Firefox 13 and Chrome 19 both with same results. Internet Explorer 9 doesn't show anything but a white page. Again, it works fine in Working Preview.
Any help on a setting adjustment or something I am doing wrong would be great!
Comment