08-28-2008, 03:39 PM
|
#3
|
|
Guest
|
Re: How to Insert Blank Record in Array?
Change this:
SELECT ID, NAME, ACCOUNTID__C
FROM DATA1
WHERE ACCOUNTID__C = '#arguments.accountID#'
to this
select distinct '' id, '' name, '' accountid_c
from some_small_table
union
SELECT ID, NAME, ACCOUNTID__C
FROM DATA1
WHERE ACCOUNTID__C = '#arguments.accountID#'
order by id
if any of those fields are not text, use whatever db function is appropriate
to convert to string in the bottom half of the query
|
|
|
|