by TonyNo on Thu Nov 15, 2007 2:40 am
Yup, updating the Globals would fire the triggers. You would, however, need some fancy SQL for that. You know, I think I already did this...
Here is part of a PSP page with SQL to loop through the Globals and just display them...
<table>
<% ph_rtne( ph_sqlselect( 1, "select id, value from global_variables order by 1")) %>
<% ph_rtne( ph_forloopwinc( "ph_concatvar( 1, 2, '<tr><td>' + ph_getdata( 1, ph_getvar_n( 1, 1),1) + '</td><td>' + ph_getdata( 1, ph_getvar_n( 1, 1), 2) + '</td></tr>~r~n')", 1, [SQLROWS1], 1, 1) + ph_sqldestroy( 1)) %>
<% ph_getvar_s(1, 2)%>
</table>
Maybe a nudge for ya?