make paging at form and convert nvarchar to integer data

Explorer ,
Dec 03, 2020 Dec 03, 2020

Copy link to clipboard

Copied

ı want to make ;

1-make a paging at form

2-Show the EVENT_TO_POS the personel name not show integer number.(at sgl its nvachar but at employees id is integer)

and search with dropdown list and show the data for departman.(for example at technical departmans notes)

thats the code ;

<cfparam name="attributes.keyword" default="">
<cfparam name="attributes.start_date" default="">
<cfparam name="attributes.finish_date" default="">
<cfparam name="attributes.form_varmi" default="">

<cfif len(attributes.start_date)>
<cf_date tarih="attributes.start_date">
</cfif>
<cfif len(attributes.finish_date)>
<cf_date tarih="attributes.finish_date">
</cfif>
<cfquery name="deneme" datasource="workcube_teknotel" >

SELECT
ER.EVENT_RESULT,
E.STARTDATE,
E.FINISHDATE,
E.EVENT_HEAD,
E.EVENT_TO_POS


FROM
workcube_teknotel.EVENT E
INNER JOIN workcube_teknotel.workcube_teknotel.EVENT_CAT EC ON EC.EVENTCAT_ID = E.EVENTCAT_ID
INNER JOIN workcube_teknotel.workcube_teknotel.EVENT_RESULT AS ER ON ER.EVENT_ID=E.EVENT_ID


where EC.EVENTCAT_ID='1'

<cfif len(attributes.keyword)>
AND EVENT_HEAD LIKE '%#attributes.keyword#%'
</cfif>
<cfif len(attributes.start_date)>
AND STARTDATE >= <cfqueryparam cfsqltype="cf_sql_timestamp" value="#attributes.start_date#">
</cfif>
<cfif len(attributes.finish_date)>
AND FINISHDATE <= <cfqueryparam cfsqltype="cf_sql_timestamp" value="#attributes.finish_date#">
</cfif>

ORDER BY STARTDATE ASC

</cfquery>
<cfform method="post">
<input name="form_varmi" id="form_varmi" value="1" type="hidden">
<cf_big_list_search_area>
<cfoutput>
<div class="row">
<div class="col col-12 form-inline ">
<div class="form-group x-10">
<input type="text" name="keyword" id="keyword" placeholder="KONU" value="#attributes.keyword#" maxlength="50">
</div>
<div class="form-group">
<div class="input-group x-11">
<cfsavecontent variable="message"><cf_get_lang_main no='65.hatalı veri'>:<cf_get_lang_main no='330.Tarih'>!</cfsavecontent>
<cfinput type="text" name="start_date" value="#dateformat(attributes.start_date,'dd/mm/yyyy')#" validate="#validate_style#" maxlength="50" message="#alert#">
<span class="input-group-addon"><cf_wrk_date_image date_field="start_date"></span>

</div>
<div class="input-group x-11">
<cfsavecontent variable="message"><cf_get_lang_main no='65.hatalı veri'>:<cf_get_lang_main no='330.Tarih'>!</cfsavecontent>
<cfinput type="text" name="finish_date" value="#dateformat(attributes.finish_date,'dd/mm/yyyy')#" validate="#validate_style#" maxlength="50" message="#alert#">
<span class="input-group-addon"><cf_wrk_date_image date_field="finish_date"></span>
</div>
</div>

</div>
</div>
</cfoutput>
</cf_big_list_search_area>

<cf_wrk_search_button>

</cfform>

<cf_big_list>
<tr>


<TH>BAŞLAMA TARIHI</TH>
<th>BİTİŞ TARIHI</th>
<th>KONU</TH>
<TH>KATILIMCILAR</TH>
<th>NOTLAR</th>


</tr>
<cfif attributes.form_varmi eq 1>
<cfoutput query="deneme">
<tr>


<td colspan="1">#STARTDATE#</td>
<td colspan="1">#FINISHDATE#</td>
<td colspan="1">#EVENT_HEAD#</td>
<td colspan="1">#EVENT_TO_POS#</td>
<td colspan="1">#EVENT_RESULT#</td>


</li>

</tr>
</cfoutput>
</cfif>

</cf_big_list>

Views

60

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Dec 13, 2020 Dec 13, 2020

Copy link to clipboard

Copied

LATEST

What is your question? That is unclear to me.

 

There is a lot of code. Could you please split it up into separate sections. Then, ask the relevant question in each sction.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines