Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Content Management (Extended ECM)
API, SDK, REST and Web Services
Queries and stored procedures
JOHN_LE_(LockMarUser3_(Delete)_2316094)
I'm thinking I'd like to modify the popup.html page so that when a certain popup in question is called it runs an update statement so that the data in the popup is guaranteed fresh. I'm sure I can write the script, but I don't know how to run a sql command from an html page (if it is indeed possible). Can anyone help on that???Or maybe it would be easier to run a stored procedure? If so, how do you call one from a web page?I'm open to any and all suggestions...
Find more posts tagged with
Comments
BSandUser4_(Delete)_567006
You would look at the CAPI(Database Connection API) package first. All the database information stored in the cookie data in the debug window. Here is a simple example:// Find "External"'s id;stmt = 'select id from kuaf where name = :A1';String externalName = 'External';Dynamic external = CAPI.Exec(.PrgSession().fDbConnect.fConnection,stmt,externalName)Hope this helps. I have no idea about how to run a stored procedure from a web page. Wish it's possible.
