I have a form that has a SELECT list in which I'm trying to trick into displaying
multiple columns in the select list. I'm doing this by how I'm returning the values
from my query. I'm querying an Oracle database, and my query is:
<cfQuery
name="defaultList"
dataSource=#dataSource#>
SELECT rpad(username, 20, chr(32))||
rpad(project_folder, 20, chr(32))||
rpad(project_file, 20, chr(32))||
rpad(to_char(blk_h, 'DD-MON-YYYY'), 20, chr(32)) listItemDisplay
,username||'/'||project_folder||'/'||project_file listItemValue
FROM dids_project_file_info
WHERE project_submitted = 'SUBMITTED'
ORDER BY username, project_folder, project_file, blk_h
</cfQuery>
So I'm basically trying to concatenate four values together, with spaces concatenated
to the end of each value out to 20 characters for each value, and return it as one
value (listItemDisplay). How when I execute this query against the database with any
standard query tool, it displays the results correctly like this:
COUTURGD Stevens MMW--HRL 24-JUL-2002
COUTURGD Stevens WaveBand-MMW 18-JUL-2002
OHARAWT BLODGETT acoustic 08-APR-2002
My problem is that when I try to dynamically create the select list with the following
code:
<select id="fileList" name="fileList" size="10" class="form_field" style="width:
450px">
<cfLoop query="defaultList">
<cfOutput><option value="#listItemValue#">#listItemDisplay#</option></cfOutput>
</cfLoop>
</select>
The displayed values come out with the padded spaces stripped of, and display like
this:
COUTURGD Stevens MMW--HRL 24-JUL-2002
COUTURGD Stevens WaveBand-MMW 18-JUL-2002
OHARAWT BLODGETT acoustic 08-APR-2002
Does anyone have any ideas why these spaces are being stripped, and how I might be
able to keep them so that the values are displayed in the list correctly (as columns)?
Any ideas would be greatly appreciated. Thanks in advance.
::YEX::
/*
|| Robert D. Yexley
|| Oracle Programmer/Analyst
|| Easylink Services Corporation
|| Professional Services
|| Contractor - Wright Research Site MIS
|| Det-1 AFRL/WSI Bldg. 45 Rm. 062
|| (937) 255-1984
|| [EMAIL PROTECTED]
|| <)))><
*/
<<Robert D. Yexley (E-mail).vcf>>
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
