Brain cramp -- Need advice.
I have a CFQUERY from an Access table that puts a set of USER_IDs into a
result set that then gets put into a CFSELECT list. How do I add an item
to the result set (the CFSELECT list) after the CFQUERY has been made?
I want to add an item "None of Above" to the list of USER_IDs without
including it in my original Access table.
<CFQUERY NAME="GET_USERS" DATASOURCE="COLAB2">
SELECT USERS.USER_NAME ,
USERS.F_NAME ,
USERS.L_NAME ,
USERS.USER_ID ,
USERS.PASSWORD ,
USERS.USER_LEVEL ,
USERS.REPT_MENU ,
USERS.CAN_APRV ,
USERS.CAN_RECALL ,
USERS.CAN_FTP ,
USERS.CAN_EXPORT ,
USERS.CAN_ADMIN ,
USERS.ONLY_SHIP
FROM USERS
WHERE USERS.USER_ID <> "SYSADMIN"
ORDER BY USER_ID
</CFQUERY>
Suggestions on how to add "None of Above" to Query result set so it appears
in the following CFSELECT list.
<CFSELECT Name="mUSER_ID" Size=1
QUERY="GET_USERS"
VALUE="USER_ID"
DISPLAY="USER_ID">
</CFSELECT>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
