20 lines
664 B
Plaintext
20 lines
664 B
Plaintext
<cfquery name="qEq" datasource="cmdb">
|
|
select svc_id,svc,descr,dt_created,creator_id,DT_UPDATED, UPDATER_ID, IS_PRODUCTION_READY, CODE, MAN SVC_SHORT, RESOURCE_REALM_TYPE_ID, VERSION ,ORCHESTRATOR_NAME, SORT, SVC_GROUP_ID, ICON_SRC, SYNONYMS from svc limit 100;
|
|
</cfquery>
|
|
<!--- <cfdump var=#qEq#/> --->
|
|
|
|
<!--- <cfquery name="qt" datasource="inmem">
|
|
SELECT CURRENT_DATE FROM (VALUES(0));
|
|
</cfquery>
|
|
<cfdump var=#qt#/>--->
|
|
|
|
<cfset db = new MemoryDbHelper()/>
|
|
<!--- <cfset db.drop("eq")/> --->
|
|
<cfset db.register("eq", qEq, "inmem")/>
|
|
|
|
<cfquery name="qTest" datasource="inmem">
|
|
select * from eq
|
|
</cfquery>
|
|
<!---
|
|
<cfset db.drop("eq")/> --->
|
|
<cfdump var=#qTest#/> |