apex

How does one show multiple validation errors near matching multiple field locations instead of the default one at a time?

Let's say you have an apex:form with ten apex:inputFields. All these fields are required and there are validation rules for all these fields that don't permit empty fields. Given the error condition state of 10 empty fields, the default behavior of visualforce is that after you click on the submit button, it shows only one of the 10 err...

Oracle APEX: Tooltip on cell of the report

I have an APEX tabular form, all columns of which are standard report columns. Is it possible to display a tooltip on mouse over of a particular cell of the report? ...

Oracle Apex - Optional List of Values (LOV)

Hi, Is there a way in Oracle APEX to use a list of values or select list but do not force the user to select an item and allow them to enter different items? The basic functionality which I require is similar to a combo box where you can optionally select an item from the list or enter a completely new. Thanks Mark ...

How do I get the browser to update before my next Javascript function is called?

Hey all, I'm having a bit of trouble getting the desired functionality from my function... Basically, I'm making two calls to AJAX functions (as provided by Oracle APEX, so I can't change these) but they're taking a while. I'd like to show the standard AJAXy spinning gif while the action was going on, but I'm not having much luck. He...

Translating JSP VisualForce

Hello, I'm new to VisualForce, as you will obviously recognize by the following. How would one convert a jsp page into an apex page? I've included some of the most common code that I will have to deal with and need the apex equivalent. I cannot find a decent tutorial or howto and I'm not having too much luck from the VisualForce devel...

How to obtain Local IP Address of PC within Oracel ApEx

Hoping this is possible and someone can assist but I need a means of obtaining the local IP Address (Windows box listed in ipconfig command info) from within Oracle ApEx. Is this possible as I have tried both owa_util.get_cgi_env('REMOTE_ADDR') as well as sys_context( 'userenv', 'ip_address' ) Just can't seem to get my local pc ip addr...

What options do I have to change WSDL location for a web service used within Apex?

Friends, Hope you can help with a problem I am encountering with Apex and Web Services. I have used the wizard within Apex to to create a web service reference. The webservice works as expected however... One of the wizard steps requires the location of the wsdl file, which for development is at location a. However when application...

How to avoid MIXED_DML_OPERATION error in Salesforce tests that create Users

Sometimes in Salesforce tests you need to create User objects to run part of the test as a speciifc type of user. However since the Salesforce Summer 08 update, attempts to create both User objects and normal objects (such as Accounts) in the same test lead to the following error: MIXED_DML_OPERATION, DML operation on setup object ...

Disabled Checkboxes

Hi, Hoping someone can assist or point me in the right direction to another thread/url with regards to disabled checkboxes. I basically have a couple of checkboxes in my form, that are not database items but am retrieving the source value based on a database column. As I do not want the user to be able to change these checboxes, I hav...

How to find if an Oracle APEX session is expired

Short version: If the function wwv_flow_custom_auth_std.is_session_valid (or apex_custom_auth_std.is_session_valid) returns TRUE, is it possible that the session is expired but still alive? If so, how can you check if a session is expired? Long version: I have created a single-sign-on system for our Oracle APEX applications, roughly b...

Visualforce and VPN

I'm looking to integrate my Salesforce implementation with an external database. I know that in most circumstances I would use Visualforce with an Apex controller/extension to access the data, however the external database will require a VPN connection. Since Visualforce and any controllers or extensions are processed server-side, is the...

Transferring data from Salesforce using Apex Data Loader to Oracle

While attempting to transfer data from Salesforce using Apex Data Loader to Oracle Keep getting the following error: 26937 [databaseAccountExtract] FATAL com.salesforce.dataloader.dao.database.Data baseContext - Error getting value for SQL parameter: nkey__c. Please make sure that the value exists in the configuration file or is ...

Attaching a List of Value [LOV] to an existing page item in APEX

I'm pretty new to APEX ( well, just started using it ~an hour ago), and I'm stuck at a rather basic level. I've created a simple form with all the required fields. I've created a simple LOV. I can't seem to figure out how to Attach the LOV to the existing item. I tried to attach the LOV by heading over to the item's property and sele...

Prevent assignment email when assigning a lead with Apex

I have some code that automatically assigns a Lead to a Queue via a before Update trigger when certain conditions are met. When leads are assigned though the UI, the 'Send Assignment Notification' checkbox is available to specify whether or not to send a notification to the receiving user(Queue in this case). l.OwnerId = groups.get('Lea...

Oracle Apex:Why is this dynamic action not getting triggered/fired ?

I'm using Application Express 4.0.0.00.25 ( Apex 4.0 EA2 ). I've created a simple form, with few fields. Each of the field are not direct entry, but rather a LOV picker is attached to these, and on selecting the LOV value, the id gets stored in the field. I have a dynamic action associated to the field, ( event - change in item, conditi...

how to create a custom login page in salesforce.com?

is it possible to create a custom login page in salesforce.com? if so can anyone provide help to create the page and the validations part? ...

Filling a LOV in Oracle Apex based on data in another text box

I am fairly new to Oracle Apex, and have a problem. Our application currently has a method of entering data, with several text boxes and Optional List of Values. I would like to have an LOV based on information in another text box like so: select APPOINTMENT_ID PATIENT_ID from APPOINTMENT where PATIENT_ID = :P9_PAT_NUM where P9_PAT_NU...

Visualforce dataTable: is there a way to stop it from rendering cellpadding attribute?

In Visualforce, I'm using an <apex:dataTable> component as follows: <apex:dataTable value="{!Qualifications}" var="qual" styleClass="cv_table" > <!-- etc... --> ... and then I'm using CSS to style the table, via the class name. Trouble is, VisualForce renders HTML like this: <table class="cv_table" id="j_id0:j_id26" border="0" c...

Examples for Apex Programming [ salesforce.com platform ]

HI all, i m new to salesforce.com platform, also to Apex code development. I m creating an application in which i need to use Apex programming, and i have java development background. So what i need is, as many examples as possible in Apex programming [ salesforce.com ], so if anybody can provide me the websites which i can look into...

I have a field in APEX set with a default of SYSDATE but it does not update.

I have a field defined in my table as DATE and want it to automatically populate with the current system date when someone access the update form in my APEX application. But the date doesn't update. It was working when I first added it, but now when you pull up the update page it only shows the date that's in the table. ...