View Single Post

Re: How to Insert Blank Record in Array?
Old 08-28-2008, 03:39 PM #3
Dan Bracuk
Guest
 
Status:
Posts: n/a
Default 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

  Reply With Quote