View Single Post

How to Insert Blank Record in Array?
Old 08-28-2008, 01:55 PM #1
Art of Zen
Guest
 
Status:
Posts: n/a
Default How to Insert Blank Record in Array?

I have a function shown below that is part of a two selects related Component.
My first problem is if no data is passed to the argument, the select field
bound to the function is very tiny (I would like it to have a default width).
Adding a "width" does not work.

SECONDLY, if there is data passed to the argument (in Arguments.accountID, i
would like to have a blank record inserted at the top of the select list
results. So in summary, if no data is passed to the argument, the select field
is very small. If data is passed to the argument, the select list is
populated, but I need to have a blank record (option) at the top of the select
list.

The code for the function shown below:

<cffunction name="getUsers" access="remote" returnType="array">
<cfargument name="accountID" type="string" required="yes">
<!--- Define variables --->
<cfset var data="">
<cfset var result=ArrayNew(2)>
<cfset var i=0>
<cfset data1= oSF.QueryObject("select ID , name, Email, ACCOUNTID__C from
User").results>

<cfquery dbtype="query" name="data">
SELECT ID, NAME, ACCOUNTID__C
FROM DATA1
WHERE ACCOUNTID__C = '#arguments.accountID#'
</cfquery>


<!--- Convert results to array --->
<cfloop index="i" from="1" to="#data.recordcount#">
<cfset result[i][1]=data.id[i]>
<cfset result[i][2]=data.name[i]>
</cfloop>
<!--- And return it --->
<cfreturn result >
</cffunction>

Code for select list:


<cfselect name="Contacts"
bind="cfc:getPartners.getUsers({mediaid})"
tooltip="Select Partner Rep" onError=""
width="50"/>


  Reply With Quote