User Guide Cancel

cfselect

  1. CFML Reference User Guide
  2. ColdFusion functions
    1. ColdFusion functions by category
    2. Functions a-b
      1. Abs
      2. ACos
      3. AddSOAPRequestHeader
      4. AddSOAPResponseHeader
      5. AjaxLink
      6. AjaxOnLoad
      7. ApplicationStop
      8. ArrayAppend
      9. ArrayAvg
      10. ArrayClear
      11. ArrayContains
      12. ArrayContainsNoCase
      13. ArrayDelete
      14. ArrayDeleteAt
      15. ArrayDeleteNoCase
      16. ArrayEach
      17. ArrayFilter
      18. ArrayFind
      19. ArrayFindAll
      20. ArrayFindAllNoCase
      21. ArrayFindNoCase
      22. ArrayInsertAt
      23. ArrayIsDefined
      24. ArrayIsEmpty
      25. ArrayLen
      26. ArrayMap
      27. ArrayMax
      28. ArrayMin
      29. ArrayNew
      30. ArrayPrepend
      31. ArrayReduce
      32. ArrayResize
      33. ArraySet
      34. ArraySetMetadata
      35. ArraySlice
      36. ArraySort
      37. ArraySum
      38. ArraySwap
      39. ArrayToList
      40. Asc
      41. ASin
      42. Atn
      43. AuthenticatedContext
      44. AuthenticatedUser
      45. BinaryDecode
      46. BinaryEncode
      47. BitAnd
      48. BitMaskClear
      49. BitMaskRead
      50. BitMaskSet
      51. BitNot
      52. BitOr
      53. BitSHLN
      54. BitSHRN
      55. BitXor
      56. BooleanFormat
    3. Functions-c-d
      1. CacheGet
      2. CacheGetAllIds
      3. CacheGetMetadata
      4. CacheGetProperties
      5. CacheGetSession
      6. CacheIdExists
      7. CachePut
      8. CacheRegionExists
      9. CacheRegionNew
      10. CacheRegionRemove
      11. CacheRemove
      12. CacheRemoveAll
      13. CacheSetProperties
      14. CallStackDump
      15. CallStackGet
      16. CanDeSerialize
      17. Canonicalize
      18. CanSerialize
      19. Ceiling
      20. CharsetDecode
      21. CharsetEncode
      22. Chr
      23. CJustify
      24. Compare
      25. CompareNoCase
      26. Cos
      27. CreateDate
      28. CreateDateTime
      29. CreateObject
      30. CreateObject: .NET object
      31. CreateObject: COM object
      32. CreateObject: component object
      33. CreateObject: CORBA object
      34. CreateObject: Java or EJB object
      35. CreateObject: web service object
      36. CreateODBCDate
      37. CreateODBCDateTime
      38. CreateODBCTime
      39. CreateSignedJWT
      40. CreateEncryptedJWT
      41. CreateTime
      42. CreateTimeSpan
      43. CreateUUID
      44. CSRFGenerateToken
      45. CSRFVerifyToken
      46. CSVRead
      47. CSVWrite
      48. CSVProcess
      49. DateAdd
      50. DateCompare
      51. DateConvert
      52. DateDiff
      53. DateFormat
      54. DatePart
      55. DateTimeFormat
      56. Day
      57. DayOfWeek
      58. DayOfWeekAsString
      59. DayOfYear
      60. DaysInMonth
      61. DaysInYear
      62. DE
      63. DecimalFormat
      64. DecodeForHTML
      65. DecodeFromURL
      66. DecrementValue
      67. Decrypt
      68. DecryptBinary
      69. DeleteClientVariable
      70. Deserialize
      71. DeserializeJSON
      72. DeserializeXML
      73. DirectoryCopy
      74. DirectoryCreate
      75. DirectoryDelete
      76. DirectoryExists
      77. DirectoryList
      78. DirectoryRename
      79. DollarFormat
      80. DotNetToCFType
      81. Duplicate
    4. Functions-e-g
      1. EncodeForCSS
      2. EncodeForDN
      3. EncodeForHTML
      4. EncodeForHTMLAttribute
      5. EncodeForJavaScript
      6. EncodeForLDAP
      7. EncodeForURL
      8. EncodeForXML
      9. EncodeForXMLAttribute
      10. EncodeForXpath
      11. Encrypt
      12. EncryptBinary
      13. EntityDelete
      14. EntityLoad
      15. EntityLoadByExample
      16. EntityLoadByPK
      17. EntityMerge
      18. EntityNew
      19. EntityReload
      20. EntitySave
      21. EntityToQuery
      22. Evaluate
      23. Exp
      24. ExpandPath
      25. FileClose
      26. FileCopy
      27. FileDelete
      28. FileExists
      29. FileGetMimeType
      30. FileIsEOF
      31. FileMove
      32. FileOpen
      33. FileRead
      34. FileReadBinary
      35. FileReadLine
      36. FileSeek
      37. FileSetAccessMode
      38. FileSetAttribute
      39. FileSetLastModified
      40. FileSkipBytes
      41. FileUpload
      42. FileUploadAll
      43. FileWrite
      44. FileWriteLine
      45. Find
      46. FindNoCase
      47. FindOneOf
      48. FirstDayOfMonth
      49. Fix
      50. Floor
      51. FormatBaseN
      52. GeneratePBKDFKey
      53. GenerateSecretKey
      54.  GetApplicationMetadata
      55. GetAuthUser
      56. GetBaseTagData
      57. GetBaseTagList
      58. GetBaseTemplatePath
      59. GetClientVariablesList
      60. GetComponentMetaData
      61. GetContextRoot
      62. GetCPUUsage
      63. GetCurrentTemplatePath
      64. GetCSPNonce
      65. GetDirectoryFromPath
      66. GetEncoding
      67. GetException
      68. GetFileFromPath
      69. GetFileInfo
      70. GetFreeSpace
      71. GetFunctionCalledName
      72. GetFunctionList
      73. GetGatewayHelper
      74. GetHttpRequestData
      75. GetHttpTimeString
      76. GetK2ServerDocCount
      77. GetK2ServerDocCountLimit
      78. GetLocale
      79. GetLocaleDisplayName
      80. GetLocalHostIP
      81. GetMetaData
      82. GetMetricData
      83. GetPageContext
      84. GetPropertyString
      85. GetPropertyFile
      86. GetPrinterInfo
      87. GetPrinterList
      88. GetProfileSections
      89. GetProfileString
      90. GetReadableImageFormats
      91. GetSafeHTML
      92. GetSAMLAuthRequest
      93. GetSAMLLogoutRequest
      94. Generate3DesKey
      95. GenerateSAMLSPMetadata
      96. GetSOAPRequest
      97. GetSOAPRequestHeader
      98. GetSOAPResponse
      99. GetSOAPResponseHeader
      100. GetSystemFreeMemory
      101. GetSystemTotalMemory
      102. GetTempDirectory
      103. GetTempFile
      104. GetTemplatePath
      105. GetTickCount
      106. GetTimeZoneInfo
      107. GetToken
      108. GetTotalSpace
      109. GetUserRoles
      110. GetVFSMetaData
      111. GetWriteableImageFormats
    5. Functions-h-im
      1. Hash
      2. HMac
      3. Hour
      4. HQLMethods
      5. HTMLCodeFormat
      6. HTMLEditFormat
      7. IIf
      8. ImageAddBorder
      9. ImageBlur
      10. ImageClearRect
      11. ImageCopy
      12. ImageCreateCaptcha
      13. ImageCrop
      14. ImageDrawArc
      15. ImageDrawBeveledRect
      16. ImageDrawCubicCurve
      17. ImageDrawLine
      18. ImageDrawLines
      19. ImageDrawOval
      20. ImageDrawPoint
      21. ImageDrawQuadraticCurve
      22. ImageDrawRect
      23. ImageDrawRoundRect
      24. ImageDrawText
      25. ImageFlip
      26. ImageGetBlob
      27. ImageGetBufferedImage
      28. ImageGetEXIFMetadata
      29. ImageGetEXIFTag
      30. ImageGetHeight
      31. ImageGetIPTCMetadata
      32. ImageGetIPTCTag
      33. ImageGetMetadata
      34. ImageGetWidth
      35. ImageGrayscale
      36. ImageInfo
      37. ImageMakeColorTransparent
      38. ImageMakeTranslucent
      39. ImageNegative
      40. ImageNew
      41. ImageOverlay
      42. ImagePaste
      43. ImageRead
      44. ImageReadBase64
      45. ImageResize
      46. ImageRotate
      47. ImageRotateDrawingAxis
      48. ImageScaleToFit
      49. ImageSetAntialiasing
      50. ImageSetBackgroundColor
      51. ImageSetDrawingColor
      52. ImageSetDrawingStroke
      53. ImageSetDrawingTransparency
      54. ImageSharpen
      55. ImageShear
      56. ImageShearDrawingAxis
      57. ImageTranslate
      58. ImageTranslateDrawingAxis
      59. ImageWrite
      60. ImageWriteBase64
      61. ImageXORDrawingMode
    6. Functions-in-k
      1. IncrementValue
      2. InputBaseN
      3. Insert
      4. Int
      5. InterruptThread
      6. InvalidateOauthAccesstoken
      7. Invoke
      8. InitSAMLAuthRequest
      9. InitSAMLLogoutRequest
      10. InvokeCFClientFunction
      11. IsArray
      12. IsAuthenticated
      13. IsAuthorized
      14. IsBinary
      15. IsBoolean
      16. IsClosure
      17. IsCustomFunction
      18. IsDate
      19. IsDateObject
      20. IsDDX
      21. IsDebugMode
      22. IsDefined
      23. IsImage
      24. IsImageFile
      25. IsInstanceOf
      26. IsIPv6
      27. IsJSON
      28. IsK2ServerABroker
      29. IsK2ServerDocCountExceeded
      30. IsK2ServerOnline
      31. IsLeapYear
      32. IsLocalHost
      33. IsNull
      34. IsNumeric
      35. IsNumericDate
      36. IsObject
      37. isOnline
      38. IsPDFArchive
      39. IsPDFFile
      40. IsPDFObject
      41. IsProtected
      42. IsQuery
      43. isSamlLogoutResponse
      44. isSafeHTML
      45. IsSimpleValue
      46. IsSOAPRequest
      47. IsSpreadsheetFile
      48. IsSpreadsheetObject
      49. IsStruct
      50. isThreadInterrupted
      51. IsUserInAnyRole
      52. IsUserInRole
      53. IsUserLoggedIn
      54. IsValid
      55. IsValidOauthAccesstoken
      56. IsWDDX
      57. IsXML
      58. IsXmlAttribute
      59. IsXmlDoc
      60. IsXmlElem
      61. IsXmlNode
      62. IsXmlRoot
      63. JavaCast
      64. JSStringFormat
    7. Functions-l
      1. LCase
      2. Left
      3. Len
      4. ListAppend
      5. ListChangeDelims
      6. ListContains
      7. ListContainsNoCase
      8. ListDeleteAt
      9. ListEach
      10. ListFilter
      11. ListFind
      12. ListFindNoCase
      13. ListFirst
      14. ListGetAt
      15. ListGetDuplicates
      16. ListInsertAt
      17. ListLast
      18. ListLen
      19. ListMap
      20. ListPrepend
      21. ListQualify
      22. ListReduce
      23. ListRemoveDuplicates
      24. ListRest
      25. ListSetAt
      26. ListSort
      27. ListToArray
      28. ListValueCount
      29. ListValueCountNoCase
      30. LJustify
      31. Location
      32. Log
      33. Log10
      34. LSCurrencyFormat
      35. LSDateFormat
      36. LSDateTimeFormat
      37. LSEuroCurrencyFormat
      38. LSIsCurrency
      39. LSIsDate
      40. LSIsNumeric
      41. LSNumberFormat
      42. LSParseCurrency
      43. LSParseDateTime
      44. LSParseEuroCurrency
      45. LSParseNumber
      46. LSTimeFormat
      47. LTrim
    8. Functions-m-r
      1. Max
      2. Mid
      3. Min
      4. Minute
      5. Month
      6. MonthAsString
      7. Now
      8. NumberFormat
      9. ObjectEquals
      10. ObjectLoad
      11. ObjectSave
      12. OnWSAuthenticate
      13. ORMClearSession
      14. ORMCloseAllSessions
      15. ORMCloseSession
      16. ORMEvictCollection
      17. ORMEvictEntity
      18. ORMEvictQueries
      19. ORMExecuteQuery
      20. ORMFlush
      21. ORMFlushall
      22. ORMGetSession
      23. ORMGetSessionFactory
      24. ORMIndex
      25. ORMIndexPurge
      26. ORMReload
      27. ORMSearch
      28. ORMSearchOffline
      29. ParagraphFormat
      30. ParameterExists
      31. ParseDateTime
      32. Pi
      33. PrecisionEvaluate
      34. ProcessSAMLResponse
      35. ProcessSAMLLogoutRequest
      36. Quarter
      37. PreserveSingleQuotes
      38. QueryAddColumn
      39. QueryAddRow
      40. QueryConvertForGrid
      41. QueryExecute
      42. QueryFilter
      43. QueryGetResult
      44. QueryGetRow
      45. QueryKeyExists
      46. QueryMap
      47. QueryNew
      48. QueryReduce
      49. QuerySetCell
      50. QuotedValueList
      51. QueryEach
      52. Rand
      53. Randomize
      54. RandRange
      55. ReEscape
      56. REFind
      57. REFindNoCase
      58. ReleaseComObject
      59. REMatch
      60. REMatchNoCase
      61. RemoveCachedQuery
      62. RemoveChars
      63. RepeatString
      64. Replace
      65. ReplaceList
      66. ReplaceNoCase
      67. REReplace
      68. REReplaceNoCase
      69. RestDeleteApplication
      70. RestSetResponse
      71. RestInitApplication
      72. Reverse
      73. Right
      74. RJustify
      75. Round
      76. RTrim
    9. Functions-s
      1. Second
      2. SendGatewayMessage
      3. SendSAMLLogoutResponse
      4. Serialize
      5. SerializeJSON
      6. SerializeXML
      7. SessionInvalidate
      8. SessionRotate
      9. SessionGetMetaData
      10. SessionInvalidate
      11. SessionRotate
      12. SetDay
      13. SetEncoding
      14. SetHour
      15. SetLocale
      16. SetMonth
      17. SetProfileString
      18. SetPropertyString
      19. SetVariable
      20. SetYear
      21. Sgn
      22. Sin
      23. Sleep
      24. SpanExcluding
      25. SpanIncluding
      26. SpreadsheetAddAutoFilter
      27. SpreadsheetAddColumn
      28. SpreadsheetAddFreezePane
      29. SpreadsheetAddImage
      30. SpreadsheetAddInfo
      31. SpreadsheetAddPageBreaks
      32. SpreadsheetAddRow
      33. SpreadsheetAddRows
      34. SpreadsheetAddSplitPane
      35. SpreadsheetCreateSheet
      36. SpreadsheetDeleteColumn
      37. SpreadsheetDeleteColumns
      38. SpreadsheetDeleteRow
      39. SpreadsheetDeleteRows
      40. SpreadsheetFormatCell
      41. SpreadsheetFormatColumn
      42. SpreadsheetFormatCellRange
      43. SpreadsheetFormatColumn
      44. SpreadsheetFormatColumns
      45. SpreadsheetFormatRow
      46. SpreadsheetFormatRows
      47. SpreadsheetGetCellComment
      48. SpreadsheetGetCellFormula
      49. SpreadsheetGetCellValue
      50. SpreadsheetGetColumnCount
      51. SpreadsheetInfo
      52. SpreadsheetMergeCells
      53. SpreadsheetNew
      54. SpreadsheetRead
      55. SpreadsheetReadBinary
      56. SpreadsheetRemoveSheet
      57. SpreadsheetSetActiveSheet
      58. SpreadsheetSetActiveSheetNumber
      59. SpreadsheetSetCellComment
      60. SpreadsheetSetCellFormula
      61. SpreadsheetSetCellValue
      62. SpreadsheetSetColumnWidth
      63. SpreadsheetSetFooter
      64. SpreadsheetSetHeader
      65. SpreadsheetSetRowHeight
      66. SpreadsheetShiftColumns
      67. SpreadsheetShiftRows
      68. SpreadsheetWrite
      69. StreamingSpreadsheetNew
      70. StreamingSpreadsheetCleanup
      71. StreamingSpreadsheetRead
      72. StreamingSpreadsheetProcess
      73. SpreadsheetSetFooterImage
      74. SpreadsheetSetHeaderImage
      75. SpreadsheetSetFittoPage
      76. SpreadsheetUngroupColumns
      77. SpreadsheetGroupColumns
      78. SpreadsheetUngroupRows
      79. SpreadsheetGroupRows
      80. SpreadsheetRemoveColumnBreak
      81. SpreadsheetSetColumnBreak
      82. SpreadsheetRemoveRowBreak
      83. SpreadsheetSetRowBreak
      84. SpreadsheetRemovePrintGridlines
      85. SpreadsheetAddPrintGridlines
      86. SpreadsheetGetColumnWidth
      87. SpreadsheetSetColumnHidden
      88. SpreadsheetSetRowHidden
      89. SpreadsheetisColumnHidden
      90. SpreadsheetisRowHidden
      91. SpreadsheetisStreamingXmlFormat
      92. SpreadsheetisXmlFormat
      93. SpreadsheetisBinaryFormat
      94. SpreadsheetRenameSheet
      95. SpreadsheetRemoveSheetNumber
      96. SpreadsheetGetLastRowNumber
      97. SpreadsheetGetPrintOrientation
      98. Sqr
      99. StripCR
      100. StructAppend
      101. StructClear
      102. StructCopy
      103. StructCount
      104. StructDelete
      105. StructEach
      106. StructFilter
      107. StructFind
      108. StructFindKey
      109. StructFindValue
      110. StructGet
      111. StructGetMetadata
      112. StructInsert
      113. StructIsEmpty
      114. StructKeyArray
      115. StructKeyExists
      116. StructKeyList
      117. StructMap
      118. StructNew
      119. StructReduce
      120. StructSetMetadata
      121. StructSort
      122. StructToSorted
      123. StructUpdate
      124. StructValueArray
      125. StoreSetMetadata
      126. StoreGetACL
      127. StoreGetMetadata
      128. StoreAddACL
      129. StoreSetACL
    10. Functions-t-z
      1. Tan
      2. ThreadJoin
      3. ThreadTerminate
      4. Throw
      5. TimeFormat
      6. ToBase64
      7. ToBinary
      8. ToScript
      9. ToString
      10. Trace
      11. Transactionandconcurrency
      12. TransactionCommit
      13. TransactionRollback
      14. TransactionSetSavePoint
      15. Trim
      16. UCase
      17. URLDecode
      18. URLEncodedFormat
      19. URLSessionFormat
      20. Val
      21. ValueList
      22. VerifyClient
      23. Week
      24. Wrap
      25. WriteDump
      26. WriteLog
      27. WriteOutput
      28. WSGetAllChannels
      29. WSGetSubscribers
      30. WSPublish
      31. WSSendMessage
      32. XmlChildPos
      33. XmlElemNew
      34. XmlFormat
      35. XmlGetNodeType
      36. XmlNew
      37. XmlParse
      38. XmlSearch
      39. XmlTransform
      40. XmlValidate
      41. Year
      42. YesNoFormat
  3. ColdFusion tags
    1. ColdFusion tag summary
    2. ColdFusion tags by category
      1. Application framework tags
        1. cfapplication
        2. cfassociate
        3. cferror
        4. cfimport
        5. cfinterface
        6. cflock
        7. cfscript
        8. cfthread
      2. Communications tags
        1. cfexchangecalendar
        2. cfexchangeconnection
        3. cfexchangecontact
        4. cfexchangefilter
        5. cfexchangemail
        6. cfexchangetask
        7. cfexchangefolder
        8. cfexchangeconversation
        9. cffeed
        10. cfmail
        11. cfmailparam
        12. cfmailpart
        13. cfpopcfimap
      3. Database manipulation tags
        1. cfdbinfo
        2. cfinsert
        3. cfobjectcache
        4. cfprocparam
        5. cfprocresult
        6. cfquery
        7. cfqueryparam
        8. cfstoredproc
        9. cftransaction
        10. cfupdate
      4. Data output tags
        1. cfchart
        1. cfchartdata
        2. cfchartseries
        3. cfchartset
        4. cfcol
        5. cfcontent
        6. cfdocument
        7. cfdocumentitem
        8. cfdocumentsection
        9. cfflush
        10. cfheader
        11. cflog
        12. cfoutput
        13. cfpresentation
        14. cfpresentationslide
        15. cfpresenter
        16. cfprocessingdirective
        17. cfprint
        18. cfreport
        19. cfreportparam
        20. cfsilent
        21. cftable
      5. Debugging tags
        1. cfdump
        2. cftimer
        3. cftrace
      6. Exception handling tags
        1. cfcatch
        2. cferror
        3. cffinally
        4. cfrethrow
        5. cfthrow
        6. cftry
      7. Extensibility tags
        1. cfchart
        2. cfchartdata
        3. cfchartseries
        4. cfcollection
        5. cfcomponent
        6. cfexecute
        7. cfftp
        8. function
        9. cfindex
        10. cfinterface
        11. cfinvoke
        12. cfinvokeargument
        13. cfobject
        14. cfproperty
        15. cfreport
        16. cfreportparam
        17. cfreturn
        18. cfsearch
        19. cfsharepoint
        20. cfspreadsheet
        21. cfwddx
        22. cfxml
      8. File management tags
        1. cfdirectory
        2. cffile
        3. cffileupload
        4. cfftp
        5. cfzip
        6. cfzipparam
      9. Flow-control tags
        1. cfabort
        2. cfbreak
        3. cfcase
        4. cfcontinue
        5. cfdefaultcase
        6. cfelse
        7. cfelseif
        8. cfexecute
        9. cfexit
        10. cfif
        11. cfinclude
        12. cflocation
        13. cfloop
        14. cfrethrow
        15. cfswitch
        16. cfthrow
        17. cftry
      10. Forms tags
        1. cfapplet
        2. cfcalendar
        3. cffileupload
        4. cfform
        5. cfformgroup
        6. cfformitem
        7. cfgrid
        8. cfgridcolumn
        9. cfgridrow
        10. cfgridupdate
        11. cfinput
        12. cfpdf
        13. cfpdfform
        14. cfpdfformparam
        15. cfpdfparam
        16. cfpdfsubform
        17. cfselect
        18. cfslider
        19. cftextarea
        20. cftree
        21. cftreeitem
      11. Internet Protocol tags
        1. cfajaximport
        2. cfajaxproxy
        3. cfftp
        4. cffeed
        5. cfimap
        6. cfhttp
        7. cfhttpparam
        8. cfldap
        9. cfmail
        10. cfmailparam
        11. cfmailpart
        12. cfpop
        13. cfsprydataset
      12. Page processing tags
        1. cfcache
        2. cfcontent
        3. cfflush
        4. cfheader
        5. cfhtmlhead
        6. cfinclude
        7. cfprocessingdirective
        8. cfsetting
        9. cfsilent
      13. Security tags
        1. cflogin
        2. cfloginuser
        3. cflogout
        4. cfNTauthenticate
      14. Variable manipulation tags
        1. cfcookie
        2. cfdump
        3. cfparam
        4. cfregistry
        5. cfsavecontent
        6. cfschedule
        7. cfset
        8. cfsetting
      15. Other tags
        1. cfimage
        2. cflog
        3. cfregistry
    3. Tags a-b
      1. cfabort
      2. cfajaximport
      3. cfajaxproxy
      4. cfapplet
      5. cfapplication
      6. cfargument
      7. cfassociate
      8. cfauthenticate
      9. cfbreak
    4. Tags c
      1. cfcache
      2. cfcalendar
      3. cfcase
      4. cfcatch
      5. cfchart
        1. cfchart tag in ColdFusion
        2. Get started with cfchart
        3. Customize a chart using cfchart
        4. Advanced cfchart customization options
        5. Create an area chart in ColdFusion
        6. Create line charts in ColdFusion
        7. Create bar charts in ColdFusion
        8. Create floating bar charts in ColdFusion
        9. Create histograms in ColdFusion
        10. Create pie charts in ColdFusion
        11. Create funnel charts in ColdFusion
        12. Create pyramid charts in ColdFusion
        13. Create curve charts in ColdFusion
        14. Create boxplots in ColdFusion
        15. Create donut charts in ColdFusion
        16. Create bubble charts in ColdFusion
        17. Create scatterplots in ColdFusion
        18. Create radar charts in ColdFusion
        19. Other chart types in ColdFusion (Cone, Cylinder, Piano, and Bullet)
        20. Advanced customization options in cfchart
          1. Add markers to ColdFusion charts
          2. Add rules to ColdFusion charts
          3. Format numbers in ColdFusion charts
          4. Add animation to ColdFusion charts
          5. Create and apply themes to ColdFusion charts
      6. cfchartdata
      7. cfchartseries
      8. cfchartset
      9. cfclient
      10. cfclientsettings
      11. cfcol
      12. cfcollection
      13. cfcomponent
      14. cfcontent
      15. cfcontinue
      16. cfcookie
    5. Tags f
      1. cffeed
      2. cffile
      3. cffile action = "append"
      4. cffile action = "copy"
      5. cffile action = "delete"
      6. cffile action = "move"
      7. cffile action = "read"
      8. cffile action = "readBinary"
      9. cffile action = "rename"
      10. cffile action = "upload"
      11. cffile action = "uploadAll"
      12. cffile action = "write"
      13. cffileupload
      14. cffinally
      15. cfflush
      16. cfform
      17. cfformgroup
      18. cfformitem
      19. cfftp
      20. cfftp: Connection: file and directory operations
      21. cfftp: Opening and closing FTP server connections
      22. cfftp : Opening and closing secure FTP server connections
      23. cfftp action = "listDir"
      24. cffunction
    6. Tags g-h
      1. cfgraph
      2. cfgraphdata
      3. cfgrid
      4. cfgridcolumn
      5. cfgridrow
      6. cfgridupdate
      7. cfheader
      8. cfhtmlhead
      9. cfhtmltopdf
      10. cfhtmltopdfitem
      11. cfhttp
      12. cfhttpparam
    7. Tags i
      1. cfif
      2. cfimage
      3. cfimap
      4. cfimapfilter
      5. cfimpersonate
      6. cfimport
      7. cfinclude
      8. cfindex
      9. cfinput
      10. cfinsert
      11. cfinterface
      12. cfinvoke
      13. cfinvokeargument
    8. Tags j-l
      1. cfjava
      2. cflayout
      3. cflayoutarea
      4. cfldap
      5. cflocation
      6. cflock
      7. cflog
      8. cflogin
      9. cfloginuser
      10. cflogout
      11. cfloop
      12. cfloop : conditional loop
      13. cfloop : index loop
      14. cfloop : looping over a COM collection or structure
      15. cfloop : looping over a date or time range
      16. cfloop : looping over a list, a file, or an array
      17. cfloop : looping over a query
    9. Tags m-o
      1. cfmail
      2. cfmailparam
      3. cfmailpart
      4. cfmap
      5. cfmapitem
      6. cfmediaplayer
      7. cfmenu
      8. cfmenuitem
      9. cfmessagebox
      10. cfmodule
      11. cfNTauthenticate
      12. cfoauth
      13. cfobject
      14. cfobject: .NET object
      15. cfobject: COM object
      16. cfobject: component object
      17. cfobject: CORBA object
      18. cfobject: Java or EJB object
      19. cfobject: web service object
      20. cfobjectcache
      21. cfoutput
    10. Tags p-q
      1. cfparam
      2. cfpdf
      3. cfpdfform
      4. cfpdfformparam
      5. cfpdfparam
      6. cfpdfsubform
      7. cfpod
      8. cfpop
      9. cfpresentation
      10. cfpresentationslide
      11. cfpresenter
      12. cfprint
      13. cfprocessingdirective
      14. cfprocparam
      15. cfprocresult
      16. cfprogressbar
      17. cfproperty
      18. cfquery
      19. cfqueryparam
    11. Tags r-s
      1. cfregistry
      2. cfreport
      3. cfreportparam
      4. cfrethrow
      5. cfreturn
      6. cfsavecontent
      7. cfschedule
      8. cfscript
      9. cfsearch
      10. cfselect
      11. cfservlet
      12. cfservletparam
      13. cfset
      14. cfsetting
      15. cfsharepoint
      16. cfsilent
      17. cfslider
      18. cfspreadsheet
      19. cfsprydataset
      20. cfstoredproc
      21. cfswitch
    12. Tags t
      1. cftable
      2. cftextarea
      3. cftextinput
      4. cfthread
      5. cfthrow
      6. cftimer
      7. cftooltip
      8. cftrace
      9. cftransaction
      10. cftree
      11. cftreeitem
      12. cftry
    13. Tags u-z
      1. cfupdate
      2. cfwddx
      3. cfwebsocket
      4. cfwindow
      5. cfxml
      6. cfzip
      7. cfzipparam
  4. CFML Reference
    1. Reserved words and variables
      1. Reserved words and variables
      2. Reserved words
      3. Scope-specific built-in variables
      4. Custom tag variables
      5. ColdFusion tag-specific variables
      6. CGI environment (CGI Scope) variables
    2. Ajax JavaScript functions
      1. Ajax JavaScript functions
      2. Function summary Ajax
      3. ColdFusion.Ajax.submitForm
      4. ColdFusion.Autosuggest.getAutosuggestObject
      5. ColdFusion.Layout.enableSourceBind
      6. ColdFusion.MessageBox.getMessageBoxObject
      7. ColdFusion.ProgressBar.getProgressBarObject
      8. ColdFusion.MessageBox.isMessageBoxDefined
      9. JavaScriptFunctionsinColdFusion9Update1
    3. ColdFusion ActionScript functions
      1. ColdFusion ActionScript functions
      2. CF.http
      3. CF.query
    4. ColdFusion mobile functions
      1. ColdFusion Mobile Functions
      2. Accelerometer Functions
      3. Camera Functions
      4. Connection Functions
      5. Contact Functions
      6. Event Functions
      7. File System Functions
      8. Geolocation Functions
      9. Media and Capture Functions
      10. Notification Functions
      11. Splash Screen Functions
      12. Storage Functions
    5. Application.cfc reference
      1. Application.CFC reference
      2. Application variables
      3. Method summary
      4. onAbort
      5. onApplicationEnd
      6. onApplicationStart
      7. onMissingTemplate
      8. onCFCRequest
      9. onError
      10. onRequestEnd
      11. onRequest
      12. onRequestStart
      13. onServerStart
      14. onSessionEnd
      15. onSessionStart
    6. Script functions implemented as CFCs
      1. Script Functions Implemented as CFCs
      2. Accessing the functions
      3. Function summary
      4. ftp
      5. http
      6. mail
      7. pdf
      8. query
      9. Script functions implemented as CFCs in ColdFusion 9 Update 1
      10. storedproc
    7. ColdFusion Flash Form style reference
      1. Styles valid for all controls
      2. Styles for cfform
      3. Styles for cfformgroup with horizontal or vertical type attributes
      4. Styles for box-style cfformgroup elements
      5. Styles for cfformgroup with accordion type attribute
      6. Styles for cfformgroup with tabnavigator type attribute
      7. Styles for cfformitem with hrule or vrule type attributes
      8. Styles for cfinput with radio, checkbox, button, image, or submit type attributes
      9. Styles for cftextarea tag and cfinput with text, password, or hidden type attributes
      10. Styles for cfselect with size attribute value of 1
      11. Styles for cfselect with size attribute value greater than 1
      12. Styles for cfcalendar tag and cfinput with dateField type attribute
      13. Styles for the cfgrid tag
      14. Styles for the cftree tag
      15. ColdFusion Flash Form Style Reference
    8. ColdFusion event gateway reference
      1. ColdFusion Event Gateway reference
      2. addEvent
      3. CFEvent
      4. CFEventclass
      5. Constructor
      6. Gateway development interfaces and classes
      7. getStatus
      8. setCFCPath
      9. setCFCMethod
      10. getOriginatorID
      11. getLogger
      12. getBuddyList
      13. getBuddyInfo
      14. IM gateway message sending commands
      15. IM Gateway GatewayHelper class methods
      16. onIncomingMessage
      17. onIMServerMessage
      18. onBuddyStatus
      19. onAddBuddyResponse
      20. onAddBuddyRequest
      21. IM Gateway CFC incoming message methods
      22. IM gateway methods and commands
      23. CFML CFEvent structure
      24. warn
      25. info
      26. setOriginatorID
      27. data command
      28. submit Multi command
      29. submit command
      30. setGatewayType
      31. setGatewayID
      32. setData
      33. setCFCListeners
      34. outgoingMessage
      35. getStatusTimeStamp
      36. numberOfMessagesReceived
      37. numberOfMessagesSent
      38. removeBuddy
      39. removeDeny
      40. removePermit
      41. setNickName
      42. setPermitMode
      43. setStatus
      44. SMS Gateway CFEvent structure and commands
      45. SMS Gateway incoming message CFEvent structure
      46. getStatusAsString
      47. getProtocolName
      48. getPermitMode
      49. getPermitList
      50. getNickName
      51. getName
      52. getDenyList
      53. getCustomAwayMessage
      54. getQueueSize
      55. getMaxQueueSize
      56. getHelper
      57. getGatewayType
      58. getGatewayServices
      59. getGatewayID_1
      60. getGatewayID
      61. getData
      62. getCFCTimeout
      63. setCFCTimeout
      64. getCFCPath
      65. getCFCMethod
      66. GatewayServices class
      67. Gateway interface
      68. GatewayHelper interface
      69. addPermit
      70. addDeny
      71. addBuddy
      72. error
      73. debug
      74. Logger class
      75. stop
      76. start
      77. CFML event gateway SendGatewayMessage data parameter
      78. restart
      79. fatal
      80. SMS gateway message sending commands
    9. ColdFusion C++ CFX Reference
      1. C++ class overview
      2. Deprecated class methods
      3. CCFXException class
      4. CCFXQuery class
      5. CCFXRequest class
      6. CCFXStringSet class
      7. ColdFusion C++ CFX Reference
    10. ColdFusion Java CFX reference
      1. ColdFusion Java CFX reference
      2. Class libraries overview
      3. Custom tag interface
      4. Query interface
      5. Request interface
      6. Response interface
      7. Debugging classes reference
    11. WDDX JavaScript Objects
      1. WDDX JavaScript objects
      2. JavaScript object overview
      3. WddxRecordset object
      4. WddxSerializer object
  5. Cloud services
    1. ColdFusion and GCP Storage
    2. ColdFusion and GCP Firestore
    3. ColdFusion and GCP PubSub
    4. ColdFusion and Amazon S3
    5. ColdFusion and DynamoDB
    6. ColdFusion and Amazon SQS
    7. ColdFusion and Amazon SNS
    8. ColdFusion and MongoDB
    9. ColdFusion and Azure Blob
    10. ColdFusion and Azure Service Bus
    11. Multi-cloud storage services
    12. Multi-cloud RDS databases
    13. ColdFusion and Azure Cosmos DB

 

Description

Constructs a drop-down list box form control. Used in a cfform tag. You can populate the list from a query, or by using the HTML option tag.

Category

Syntax

<cfselect 
name="name" bind="bind expression" 
bindAttribute="attribute name" 
bindOnLoad="yes|no" 
display="text" editable="yes|no" 
enabled="yes|no" 
group="query column name" height="number of pixels" 
id="HTML id" 
label="label" message="text" multiple="yes|no" 
onBindError="JavaScript function name" 
onChange="JavaScript or ActionScript" 
onClick="JavaScript function name" 
onError="JavaScript" 
onKeyDown="JavaScript or ActionScript" 
onKeyUp="JavaScript or ActionScript" 
onMouseDown="JavaScript or ActionScript" 
onMouseUp="JavaScript or ActionScript" 
query="query name" queryPosition="above|below" 
required="yes|no" 
selected="value or list" size="integer" sourceForTooltip="URL" 
style="style specification" tooltip="text" 
value="text" visible="yes|no" 
width="number of pixels"> 
zero or more HTML option tags 
</cfselect>

Some attributes apply to only specific display formats. For details see the Attributes table.

Note:

You can specify this tag's attributes in an attributeCollection attribute whose value is a structure. Specify the structure name in the attributeCollection attribute and use the tag's attribute names as structure keys.

See also

History

ColdFusion 11:

  • Removed the attribute passthrough.

ColdFusion 8:

  • Added support for binding in HTML format forms, including the bind, bindAttribute, and bindOnLoad, and onBindError attributes.
  • Added support for tool tips in HTML format forms, including the sourceForTooltip attribute.

ColdFusion MX 7:

  • When populating a cfselect tag with a query when the database field has spaces instead of a value, the error processing of the cfform tag required field is not triggered as it was in ColdFusion MX 6.1.
  • Added support for specifying multiple values to the selected attribute.
  • Deprecated the passthrough attribute. The tag now supports all HTML select tag attributes directly.
  • Added on-prefixed attributes.
  • Added enabled, group, height, label, queryPosition, tooltip, visible, and width attributes.

Attributes

The following table lists attributes that ColdFusion uses directly. The tag also supports all HTML select tag attributes that are not on this list, and passes them directly to the browser.

Note:

Attributes that are marked as Flash only are not handled by the skins provided with ColdFusion. They are, however, included in the generated XML.

Attribute

Req/Opt;Format

Default

Description

name

Required;All

 

Name of the select form element.

bind

Optional; HTML

 

A bind expression that dynamically sets an attribute of the control. For details, see Usage.

bindAttribute

Optional;HTML

Populate the options

Specifies the HTML tag attribute whose value is set by the bind attribute. You can only specify attributes in the browser's HTML DOM tree, not ColdFusion-specific attributes.
Ignored if there is no bind attribute.

bindOnLoad

Optional;HTML

no

A Boolean value that specifies whether to execute the bind attribute expression when first loading the form. Ignored if there is no bind attribute.

display

Optional;All

Value of value attribute

Query column to use for the display label of each list element. Used with the query attribute.

editable

Optional; Flash

no

Boolean value specifying whether you can edit the contents of the control.

enabled

Optional; Flash

yes

Boolean value specifying whether the control is enabled. A disabled control appears in light gray. The inverse of the disabled attribute.

group

Optional; HTML and XML

 

Query column to use to group the items in the drop-down list into a two-level hierarchical list.

height

Optional; Flash

 

The height of the control, in pixels.

id

Optional;HTML

Value of name attribute

The HTML ID of the control.

label

Optional;Flash and XML

 

Label to put next to the control on a Flash or XML-format form.

message

Optional;All

 

Message to display if required = "yes" and no selection is made.

multiple

Optional;All

no

  • yes: allows selecting multiple elements in drop-down list.
  • no

onBindError

Optional;HTML

See Description

The name of a JavaScript function to execute if evaluating a bind expression results in an error. The function must take two attributes: an HTTP status code and a message. (The status code is1 if the error is not an HTTP error.)If you omit this attribute, and specified a global error handler (by using the ColdFusion.setGlobalErrorHandler function), it displays the error message; otherwise a default error pop-up appears.

onChange

Optional;All

 

JavaScript (HTML/XML) or ActionScript (Flash) to run when the control changes due to user action.

onClick

Optional; HTML and XML

 

JavaScript to run when the user clicks the control.

onError

Optional;HTML and XML

 

Custom JavaScript function to execute if validation fails.

onKeyDown

Optional;All

 

JavaScript (HTML/XML) or ActionScript (Flash) to run when the user presses a keyboard key in the control.

onKeyUp

Optional;All

 

JavaScript (HTML/XML) or ActionScript (Flash) to run when the user releases a keyboard key in the control.

onMouseDown

Optional;All

 

JavaScript (HTML/XML) or ActionScript (Flash) to run when the user releases a mouse button in the control.

onMouseUp

Optional;All

 

JavaScript (HTML/XML) or ActionScript (Flash) to run when the user presses a mouse button in the control.

query

Optional;All

 

Name of query to populate drop-down list.

queryPosition

Optional;All

above

If you populate the options list with a query and use HTML option child tags to specify additional entries, this attribute determines the location of the items from the query relative to the items from the option tags:

  • above: puts the query items above the options items.
  • below: puts the query items below the options items.

required

Optional;All

no

Note: This attribute has no effect if you omit the size attribute or set it to 1, because the browser always submits the displayed item. You can work around this issue: format forms by having an initial option tag with value=" " (notice the space character between the quotation marks). This workaround applies only for Flash forms and not for HTML forms or XML forms.

  • yes: a list element must be selected when the form is submitted.
  • no

selected

Optional;All

 

One or more option values to preselect in the selection list. To specify multiple values, use a comma-delimited list. This attribute applies only if selection list items are generated from a query. The cfform tag preserveData attribute can override this value.

size

Optional;All

1

Number of entries to display at one time. The default value displays a drop-down list. Any other value displays a list box with size number of entries visible at one time.

sourceForTooltip

Optional; HTML

 

The URL of a page to display as a tool tip. The page can include CFML and HTML markup to control the tip contents and format, and the tip can include images.
If you specify this attribute, an animated icon appears with the text "Loading..." while the tip is being loaded.

style

Optional;All

 

In HTML or XML format forms, ColdFusion passes the style attribute to the browser or XML.
In Flash format, must be a style specification in CSS format, with the same syntax and contents as used in Flex for the corresponding Flash element.

tooltip

Optional; Flash, HTML

 

Text to display when the mouse pointer hovers over the control. The text can include HTML markup.
Ignored if you specify a sourceForTooltip attribute.

value

Optional;All

 

Query column to use for the value of each list element. Used with the query attribute.

visible

Optional; Flash

yes

Boolean value that specifies whether to show the control. The display reserves empty space for an invisible control.

width

Optional; Flash

 

The width of the control, in pixels.

Usage

For this tag to work properly. the browser must have JavaScript enabled. This tag requires an end tag and can include HTML option and optgroup child tags. To ensure that a selected list box item persists across postbacks, use the cfform tag preserveData attribute with a list generated from a query. (This strategy works only with data that is populated from a query.)If the cfform preserveData attribute is yes and the form posts back to the same page, and if the control is populated by a query, the posted selections for the cfselect control are used instead of the Selected attribute. For controls that are populated with regular HTML option tags, the developer must dynamically add the Selected attribute to the appropriate option tags.
The group option generates a query by using SQL GROUP BY syntax and places the value column entries from each group in an indented list under the group column's field value. This option generates an HTML optgroup tag for each entry in the group column.Close each HTML option tag in the cfselect tag body with a </option> end tag. If you do not do so, and you specify queryPosition="below", the first item from the query might not appear in the list.
The bind attribute lets you set cfselect attributes dynamically. Often, it is used to dynamically create the options list based on values that the user enters in the form. For example, you can use the bind attribute to create a Cities option list based on the user's selection from a States cfselect control. When you use a bind attribute to populate the selection list, the function or URL that returns the selection values must return one of the following:

  • A two-dimensional array, where the first element in each array row is the option value and the second element in the row is the text to display in the option list.
  • If the bind specifies a CFC function, a query, or, if the bind specifies a URL, a JSON representation of a query. The query must include columns whose names are the values of the cfselect tag value and display attributes. Although you can return additional columns, you cannot use them in your client-side code. When you call a CFC function, you do not have to convert the query to JSON format yourself; ColdFusion automatically does the conversion.
    To use this format, specify a value attribute. If you omit the display attribute, you must have only a single column in the query that contains the values; the values are also used as the displayed text.
    For detailed information on binding, see Binding data to form fields in the Developing ColdFusion Applications. For more information, see the cfform tag entry.

Example

Example 1: Without data bindingThe following example lets you select one or more employee names from a list of all employees, grouped by departments, and displays the selected names and the employee's e-mail addresses. It includes an option to get data for all employees.

<!--- Get the employee names from the database. ---> 
<!--- Use SQL to create a Name field with first and last names. ---> 
<cfquery name = "GetAllEmployees" dataSource = "cfdocexamples"
        cachedwithin="#createTimeSpan(0,1,0,0)#"> 
    SELECT Emp_ID, EMail, Phone, Department, FirstName, LastName,  
        FirstName ||' '
 
||lastName as Name 
    FROM Employees  
    GROUP BY Department, Emp_ID, EMail, Phone, FirstName, LastName, FirstName 
</cfquery> 
  
<h2>cfselect Example</h2> 
<!-- The cfif statement is true if the form was submitted. 
    Show the selected names. ---> 
<cfif IsDefined("form.employeeid")> 
    <!--- The form was submitted. ---> 
    <h3>You Selected the following employees</h3> 
    <cfif form.employeeid IS ""> 
        <!--- Select All option was selected. Show all employees. ---> 
        <cfoutput query="GetAllEmployees"> 
            #name#<br> 
            Email: #email#<br><br> 
        </cfoutput> 
    <cfelse> 
        <!---  
            Use a query of queries to get the data for the selected users.  
            Form.employeeid is a comma-delimited list of selected employee IDs.  
        ---> 
        <cfquery name = "GetSelectedEmployees" dbtype="query"> 
            SELECT Emp_ID, EMail, Phone, Department, FirstName, LastName, 
                FirstName 
 
||' ' ||lastName as Name 
            FROM GetAllEmployees 
            WHERE Emp_ID in (#form.employeeid#) 
        </cfquery>     
        <!--- Display the names and e-mail addresses from the query. ---> 
        <cfoutput query="GetSelectedEmployees"> 
            #firstName# #lastName#<br> 
            Email: #email#<br> 
            <br> 
        </cfoutput> 
    </cfif>  
</cfif> 
  
<!--- The cfform tag posts back to the current page. ---> 
<h3>Select one or more employees</h3> 
<cfform action = "#CGI.SCRIPT_NAME#"> 
    <!---  
            Use cfselect to present the query's LastName column,  
            grouped by department.  
            Allow Multiple selections. 
        ---> 
    <cfselect  
        name = "employeeid" 
        size = "15" 
        multiple="yes" 
        required = "Yes"
        message = "Select one or more employee names" 
        query = "GetAllEmployees" 
        group="Department"
        display ="name" 
        value ="emp_id" 
        queryPosition="Below"> 
        <!--- Add an option to select all employees. ---> 
        <option value = "">Select All</option> 
    </cfselect><br><br> 
    <input type="Submit"> 
</cfform> 

Example 2: With data bindingThe following example uses binding to fill in the options list of the Cities control only after the user selects a state. (In this example, only two states, California and New Jersey, have city entries.)The CFML page is the simplest part of the example. It consists of the following lines:

<html> 
<head> 
</head> 
<body> 
<cfform name="mycfform"> 
    <!---  
        The States selector.  
        The bindonload attribute is required to fill the selector.  
    ---> 
    <cfselect name="state" bind="cfc:bindFcns.getstates()" bindonload="true"> 
        <option name="0">--state--</option> 
    </cfselect> 
    <cfselect name="city" bind="cfc:bindFcns.getcities({state})"> 
        <option name="0">--city--</option> 
    </cfselect> 
</cfform> 
</body> 
</html>

The BindFcns CFC has three functions: getstates, to get the states; getcities, to get the cities; and an internal getXmlData function that parses an XML file to get the state and city information. The following examples shows the CFC:

<cfcomponent> 
    <cffunction name="getXmlData" output="true"> 
        <cfset var xmlData = "">  
        <cffile action="read" file="#expandpath('.')#\states.xml"
            variable="xmlData"> 
        <cfset xmlData = XmlParse(xmlData)> 
        <cfreturn xmlData> 
    </cffunction>  
  
    <cffunction name="getstates" access="remote"> 
        <cfset state = arraynew(2)> 
        <cfset xmlData = getXmlData()> 
        <cfset numStates = 0> 
        <cfset state[1][1] = "0"> 
        <cfset state[1][2] = "--state--"> 
        <cfset numStates = ArrayLen(xmlData.states.XmlChildren)> 
        <cfloop from="1" to="#numStates#" index="j"> 
            <cfset state[j+1][1] =  
                ltrim(xmlData.states.state[j].XmlAttributes.abr)> 
            <cfset state[j+1][2] = ltrim(xmlData.states.state[j].name.xmlText)> 
        </cfloop> 
        <cfreturn state> 
    </cffunction> 
  
    <cffunction name="getcities" access="remote"> 
        <cfargument name="state" required="yes"> 
        <cfset var city = arraynew(2)> 
        <cfset var xmlData = getXmlData()> 
        <cfset var numStates = 0> 
        <cfset var numCities = 0> 
<cflog text="In getcities"> 
        <cfset city[1][1] = "0"> 
        <cfset city[1][2] = "--city--"> 
        <cftry> 
            <cfset numStates = ArrayLen(xmlData.states.XmlChildren)> 
            <cfloop from="1" to="#numStates#" index="j"> 
                <cfif xmlData.states.state[j].XmlAttributes.abr eq state> 
                    <cfset numCities = 
                        ArrayLen(xmlData.states.state[j].cities.XmlChildren)> 
                    <cfloop from="1" to="#numCities#" index="k"> 
                        <cfset city[k+1][1] =    ltrim(xmlData.states.state[j].cities.city[k].XmlAttributes.name)> 
                        <cfset city[k+1][2] = ltrim(xmlData.states.state[j].cities.city[k].XmlAttributes.name)> 
                    </cfloop> 
                    <cfbreak> 
                </cfif> 
            </cfloop> 
        <cfcatch type="any"> 
            <!--- Do nothing. ---> 
        </cfcatch> 
        </cftry>  
        <cfreturn city> 
    </cffunction> 
      
</cfcomponent>

The states.xml file has the following code. To keep the code short, only two states have cities, and only four states are listed.

<states> 
    <state abr="NJ"> 
        <name>New Jersey</name> 
        <cities> 
            <city name="Edison" /> 
            <city name="Rahway" /> 
            <city name="Atlantic City" /> 
            <city name="Hoboken" /> 
            <city name="Jersey City" /> 
            <city name="Newark" /> 
            <city name="Trenton" /> 
            <city name="Union City" /> 
        </cities> 
    </state> 
    <state abr="CA"> 
        <name>California</name> 
        <cities> 
            <city name="Anaheim" /> 
            <city name="Beverly Hills" /> 
            <city name="Elk Grove" /> 
            <city name="Fairfield" /> 
            <city name="Fremont" /> 
            <city name="Indian Wells" /> 
            <city name="Long Beach" /> 
        </cities> 
    </state> 
    <state abr="ME"> 
        <name>Maine</name> 
    </state> 
    <state abr="MA"> 
        <name>Massachusetts</name> 
    </state> 
</states> 

Get help faster and easier

New user?