apex

how to install new oracle apex theme?

I'm trying to install new apex theme but the problem is that I don't know where to put theme images folder in apache webserver? I tried to put it on the apache/images but this doesn't work So does anybody know where to put the images folder Note: I have successfuly imported the .sql file and already switched the theme to the new one. ...

Why is this jquery in visualforce not working?

This code is in visualforce (salesforce's page editor language). Basically the apex:repeat tags function as a sort of loop, generating a set of urls from outputlink. All these urls have a class of "name". What the jquery is to do is find all the urls with the class name, and click them so they open in new windows. Its not working. <ape...

How many records can be loaded into Salesforce using Apex Data Loader in one go?

We have to insert thousands of record into Salesforce using Apex Data Loader. We use csv files to load data. ...

Oracle database not opening files with '#' character in them

For some reason, the files in the database won't open if they have the # character in them... One thing i noticed was in the file name, the link doesn't have %20 for the space characters after the # sign, but even when i replace the rest of the number characters with the %20 character, the link still doesn't work.. Any ideas why it cou...

Integrating java and apex (salesforce)

Hi there, I'm a salesforce newbie and I need to integrate java business logic with apex pages. Is it possibile to do it without using vwmforce? Note that I have to include my own and third party libraries as well. Is there any tutorial/resource about that? Thanks in advance ...

Superfish Menu Hovering

Hi, Hoping someone can point me in the right direction with regards to Superfish jQuery Menu Plugin at Superfish Site My question is, I am using this menu system inside Oracle Application Express (ApEx) and using IE6 browser. What I find and not sure if this is specifically relevant to Oracle ApEx but when I hover over a menu item, I ...

SOQL query to traverse several levels on Task

I'm trying to write some apex code using this query and not getting anywhere: List<Task> tasks = [SELECT id, whatid, who.account.parent.name FROM task WHERE who.account.parent.name LIKE 'Procter%']; I'm not surprised this doesn't work, but can't seem to find documentation anywhere that explains how I would go about this. Does anyone ...

Integrating PL/JSON with Oracle APEX 4.0

I am trying to use PL/JSON in my Oracle APEX application but get the following errors when I attempt to run a Hello, world example (which works fine when I run the example from SQL*PLUS as sys): ORA-06550: line 2, column 20: PLS-00905: object MY_SCHEMA.JSON is invalid ORA-06550: line 2, column 20: PL/SQL: Item ignored ORA-06550: line 5,...

Security context in a trigger

I'll start of by saying that I'm a .net guy having to play in a salesforce.com world right now. My question is this; Within the context of an pre-update/insert trigger can I set the value of a field that the user (the user that is updating the object when the trigger fires) does NOT have on their page layout? ...

APEX 2.0 Report with dynamic column headings

I have a SQL query that outputs data in a normalised style... Column1 = Row Heading Column2 = Column Heading Column3 = Cell Value Is there a straight forward way to output data in this format? Once output as a grid, I also would like to chart the values, with each Column Heading representing a Data Series in the chart. And on a side...

Salesforce (VisualForce): How to test for no records returned in 'apex:repeat' statement?

I am trying to figure out how to test fields (included within a apex:repeat) to see if they are blank, or null, and if so display some alternate text (Ex: No records to display) in the table instead of a blank table. Existing code snippet below: <apex:repeat var="auditList" value="{!relatedTo.Site_Audit__r}"> <tr> <td> <apex...

How to add a new lead and update an existing lead in Salesforce

I am new to Apex development and I'm starting to work on my project in Apex. I would like to do following: using an email service //I figured this part get emailAddress from an email //know how to do this if there is already exisiting lead or contact with the same emailAddress update his information else create new lead I would...

Invalid foreign key relationship when I try to add a new custom object to an exsting lead

Hi there, I have a Lead and a custom object called Social Account (API Name = Social_Account__c). I have set a relationship as follows: Lead is a parent of Social Accounts. so a lead has many social accounts. In the Social Account, I made a custom field named Lead (Data Type: Lookup) to make the relationship. and here is a lookup deta...

CANNOT_UPDATE_CONVERTED_LEAD, cannot reference converted lead: [Lead__c]

Hi there, I am getting an error message when I try to instert a custom object into an exisiting lead object. List<Lead> leads =[select Id from Lead where Email =:lead.Email ]; if(leads.size()>0) { Lead existing_lead = new Lead(Id = leads[0].id); social_account.Lead__c = existing_lead.Id; //social_account is a custom object that ...

Making an Oracle Apex report table element read-only

Greetings: Is there anyway to make an apex report table cell (or even the entire report itself) conditionally read-only in Apex 3.2? I don't see the "read-only" box anywhere in the options; tried searching everywhere. Thanks in advance! ...

Visualforce load apex components via ajax on page load

Hi, Can someone tell me how to use ajax to load an apex pageBlockTable via ajax on page load? I've seen examples showing how to use an apex actionFunction, but the samples are usually simple (e.g. - returning a string from the controller and putting it on the page. My controller returns a list of sObjects and i'm just not quite sure ho...

how to do i select multiple record from a report

I would want to know the coding for the following: I would like select multiple records from a report which satisfies certain conditions. I need the code in APEX ...

SQL Plus and www.apex.oracle.com

Does the SQL syntax differ in any way for SQL Plus and apex.oracle.com From this article I can assume that it doesn't, but I want to be sure. Is SQL Plus only an environment that is able to connect to an Oracle server ? I'm asking this because I just started learning Oracle's SQL syntax and I don't have access to my faculty's server fro...

How does one deploy after building on force.com

I've been directed to force.com as an alternative to creating an application using PHP and MySQL. My question is about deployment. What happens after I build the application on force.com. If the application is based on their API, will I be able to serve this application from my own domain if I wanted? ...

Update Apex Tabular form with PLSQL

Hi All: How can I update an Apex Tabular Form with pl/sql instead of using a multi-row update(MRU), is it even possible? Thanks in advance. ...