You want to convert a query column containing numeric data into a comma-delimited list. Which function should you use?

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

You want to convert a query column containing numeric data into a comma-delimited list. Which function should you use?

Post by answerhappygod »

You want to convert a query column containing numeric data into a comma-delimited list.
Which function should you use?
A. ValueList()
B. ArrayToList()
C. ColumnList()
D. ListAppend()


Answer : A



You want to load a single entity of type ART from your ORM, using the primary key value 5 as a filter.
Which two function signatures can you use to accomplish this task? (Choose two.)
A. EntityLoadByPK("ART", 5)
B. EntityLoadSingleValue("ART", 5)
C. EntityLoad("ART", 5)
D. EntityLoadByExample("ART", 5)
E. EntityLoad("ART", 5, true)


Answer : A,E



A page in your application is accessed at http://localhost/scope.cfm?init=false.
In which variable scope is the init variable available?
A. Attributes
B. Application
C. URL
D. Form


Answer : C



Which code segment can be used to store an array of structures as a client variable?
A. <cfset client.myarray = "#adata#">
B. <cfset client.myarray = valuelist(adata)>
C. <cfset client.myarray = serializeJSON(adata)>
D. <cfset client.myarray = adata>


Answer : C



Your application has the following query which is invalid:
<cftry>
<cfquery datasource="goodphoto" name="test">
SELECT * FROM ...
</cfquery>
<cfcatch type="any">
</cfcatch>
</cftry>
Which variable contains a string that describes the cause of the error?
A. cfcatch.message
B. cfcatch.type
C. cfcatch.detail
D. cfcatch.errorCode


Answer : C
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply