In PHPMaker (v2019) i have the following need: Generate a caption for an column which contains a dynamic part – the year. Currently I’m using the system-date with following code: $this->COLUMN_IN_DATABASE ->Caption .= “MyColumnName ” . (date(“Y”) + 0) This works finde but i need change this to an value in the database. There is an column which contains the
Tag: oracle
Dynamic List View with Item value in where clause
I have a List View Region that I would like to update the contents of based on a Select List, without a submit call or page refresh, but I am open to suggestions that don’t use the select list bind variable in the where clause. List View Region (P1_LIST_VIEW) Select list: The dynamic action is When: On Change -> NULL
How to specify the 5 apex items on my javascript code at oracle apex
Please see picture on the link. How do I code 5 apex page items in a javascript using if else condition. Initially, what I am doing is i am trying to hide regions which will have empty page items and that depends on the sql query results. please help. thank you. Here is my code: Answer I was able to
Oracle Apex opening a column link in interactive report?
I have column link in an interactive report. This column link should run an sql query which supposed to return an external URL so I want to open in a new tab/page. How can I do that? Somehow with a dynamic action? ..but I cannot make dynamic actions for columns furthermore I should query the data from the table-column. Thank
How to autopopulate a drodown based on the selection in another dropdown in php?
I have read a few similar questions but didn’t find the solution. I am trying to fetch a dropdown based on the selection of another dropdown. The first dropdown is school names, which upon selection should fetch the users under that particular school. There are two tables in the database. The first one has school name column named schoolname and
Connection is not defined in oracledb
I am using the oracledb cen node.js module and when making a database connection to make a select, it returns the data but this error also appears: I do the query like this: Answer If you can use await, then you’re in an async function. If you’re in an async function, why are you using promise chains? Here’s what this
Javascript date to sql date object
I’m trying to write a query that takes a Javascript date object and then puts it in an object type that is recognized by both SQL Server and Oracle database types. The issue is that I’m using webservices. So it has to be a string, not an actual passed parameter. Here’s what I mean: Except firstDayOfMonth and lastDayOfMonth are surrounded