cfide/administrator

kt03 · ‎Mar 19, 2020

Hi, I logged in to CF admin with my username and was able to create the DSN using admin account and password. However, I need to login as admin to grant access for other user and can't use that same admin account. What should I do? Thanks

kt03 · ‎Oct 24, 2018

Hi, I have the instances server such as api\com,12368 I can create the DSN with server and port # 12368, but with the instances: api/com didn't work. I guess it didn't take the back splash from the server. What can I do? Thanks

kt03 · ‎Oct 10, 2018

Thank you very much .

kt03 · ‎Oct 10, 2018

Thank you , can you please show me to get to the location where I can see the thing below? I changed IIS (for a test folder in a test site) to not support "anonymous" authentication and selected another,

kt03 · ‎Oct 10, 2018

no, I don't know how to test it

kt03 · ‎Oct 10, 2018

I was try on my workstation. Not sure which credentials I will try on the server?, mine credentials?, or the one I used to create the datasource? IIf I use mine, got error below. I think i should try with the datasource credentials? HTTP Error 401.1 - Unauthorized You do not have permission to view this directory or page using the credentials that you supplied.

kt03 · ‎Oct 10, 2018

the log file shows below. I reboot the server but still doesn't work. HTTP Error 401.2 - Unauthorized You are not authorized to view this page due to invalid authentication headers.

kt03 · ‎Oct 10, 2018

I am testing to send email to me <cfmail to="hmyemail@.com" from="no-reply@test.com" subject="***TEST TEST" type="html"> </cfmail> I save the file into log to find out if permission related it. The log show No authentication........ I wonder why, because some other tasks were actually ran successful with the data.

kt03 · ‎Oct 10, 2018

Hi, I created the schedule runs every 30 minutes. It shows the last run in Oct-10-2018 08:20:00AM, but I didn't get anything. I then click on the green icon to manually run the schedule task and it was was completed successfully, but again, I didn't receive anything. I then try to manually copy the url and run it in the browser and it worked. Can anyone please help?

kt03 · ‎Sep 12, 2018

Hi I have the variables set <cfif orderID = 5> <cfset stype = "'ABC124','DEF567'"> <cfese> <cfset stype = "'VACD123','KHOL567'"> </cfif> <cfquery name="qQuery" datasource="#ds#"> select ..... from...... ...... where ...... and serie in in ('#stype#') </cfquery> when out put the query, I got below (1) which is not right because nothing returned. When i run the query and hard code like 2 I got records. What did I have wrong here? Thanks 1) serie in ('''ABC124'',''DEF567''') 2) serie in ('ABC124','DEF567')

kt03 · ‎Jun 26, 2017

Hi, I have the form with default it shows below. When i click on Group, the company is hiding. When I click on Compay, i want the group is hiding and Company is shown, but my code didn't do it. Not sure what I have wrong here, please help. Code: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>test</title> <linkrel="stylesheet" href="css/demos.css">  <script type="text/javascript" src="js/jquery.tablesorter.js"></script> <cfparam name="_update" default="off"> <cfparam name="_updatebritm" default="off"> <cfparam name="_groupOption" default=""> <cfparam name="_groupOption2" default="" /> <cfparam name="reporttype" default="company"> <cfparam name="companyOption" default="" /> <cfparam name="com" default="1" /> <script type="text/javascript"> $(function() { $( "#reportTypeGroup" ).buttonset(); }); $(document).ready(function() { // sort on the first column and third column, order asc $("#userLog").tablesorter({ widgets: ['zebra'], sortList: [[4,1]], headers: { //1: { sorter: false}, 2: { sorter: false}, 3: { sorter: false} //5: { sorter: false} } }); } ); // hide and show drop box when select company or group $(document).ready(function() { $("input[name$='reporttype']").click(function() { var type = $(this).val(); $("tr.desc").hide(); $("#Reporttype" + type).show(); }); }); </script> </head> <cfifisDefined("form.save")> <cfifreporttypeeq "company"> <cfset variables.comp = form.companyOption /> <cfset variables.group = form._groupoption /> <cfelse> <cfset variables.comp = "" /> <cfset variables.group = form._groupoption2 /> </cfif> </cfif> <body> <cfoutput> <div class="demo"> <form name="test" method="post" action="#CGI.SCRIPT_NAME#" id="test"> <table width="200" cellpadding="0" cellspacing="0" border="0"> <tr> <tdcolspan="3"> <div id="reportTypeGroup" class="ui-widget"> <input type="radio" size="10" id="companyType" name="reporttype" value="company" <cfifreporttype EQ "company">checked="checked"</cfif> /><label for="companyType">Company</label> <input type="radio" size="10" id="groupType" name="reporttype" value="group" <cfifreporttype EQ "group">checked="checked"</cfif>/><label for="groupType">Group</label> </div> </td> </tr> <tr><td colspan="4"> </td></tr> <tr id="Reporttypecompany" class="desc"> <td class="label">group:</td> <td> <select name="_groupOption" id="_groupCode" onchange='surfto(this.form);'> <option value="1" <cfif _groupOption EQ "1">selected="selected"</cfif>>1</option> <option value="2" <cfif _groupOption EQ "2">selected="selected"</cfif>>2</option> <option value="3" <cfif _groupOption EQ "3">selected="selected"</cfif>>3</option> <option value="4" <cfif _groupOption EQ "4">selected="selected"</cfif>>4</option> <option value="5" <cfif _groupOption EQ "5">selected="selected"</cfif>>5</option> </select> </td> </tr> <tr><td colspan="4"> </td></tr> <tr id="Reporttypecompany" class="desc"> <td class="label">company: </td> <td> select name="companyOption" id="companyCode"> <option value="0" selected="selected">Choose a company</option> </select> </td> </tr> <trid="Reporttypegroup" class="desc" style="display: none;"> <td class="label">group:</td> <td> <select name="_groupOption2" id="_groupCode2"> <option value="1" <cfif _groupOption2 EQ "1">selected="selected"</cfif>>1</option> <option value="2" <cfif _groupOption2 EQ "2">selected="selected"</cfif>>2</option> <option value="3" <cfif _groupOption2 EQ "3">selected="selected"</cfif>>3</option> <option value="4" <cfif _groupOption2 EQ "4">selected="selected"</cfif>>4</option> <option value="5" <cfif _groupOption2 EQ "5">selected="selected"</cfif>>5</option> </select> </td> </tr> </table> </form> </div> </cfoutput> </body> </htm>

kt03 · ‎May 30, 2017

Hi, I have access to CF admin, but my co-worker doesn't. I want to give her an access, but don't know how? Thanks

kt03 · ‎Oct 08, 2013

this code is worked fine with onchange event. Instead of onchange, i want to have the link below(<a id="myLink" href="##" onclick="whatsUp();">link text</a>) and work the same as onchange, meaning when i click on the link text , i need to get the url.t_item? <script type="text/javascript"> function whatsUp() { document.medform.t_item.value) } function show() { alert(document.medform.t_item.value) } </script> <cfif isDefined("form.t_item")> <cfdump var="#form#"><br /> </cfif> <cfform name="medform" action="#cgi.SCRIPT_NAME#"> Item name: <cfinput autosuggest="cfc:cfc.gg.lookupArt({cfautosuggestvalue})" type="text" name="t_item" size="50" typeahead="yes" onChange="whatsUp()"> <a id="myLink" href="##" onclick="whatsUp();">link text</a> </cfform>

kt03 · ‎Oct 02, 2013

Hi, Why it's not working with checkbox? If I change the type ="checkbox" to type="text" the it worked, meaning the radio button is enabled. Thanks <script type="text/javascript"> function EnableTextBox(sender, target, maxcar) { if ( sender.value.length >= maxcar ) document.getElementById(target).disabled = false; else { document.getElementById(target).disabled = true; document.getElementById(target).value = ''; } } //onchange from dropbox diffrent status function gotourl(url){ window.location= url; } </script> <cfinput type="checkbox" name="prize" id="prize" value="1" disabled="disabled" onkeyup="EnableTextBox(this, 'completed', 1);"> <cfinput type="radio" name="completed" disabled="disabled" value="1" />

kt03 · ‎Sep 27, 2013

Hi, Both of 1 and 2 are basically the same and should be working, but # 1 is not working. Can someone please tell me why # is not working? <cfset variables.objq = createObject("component","cfc.query").init(compID=request.compID)> 1. NOT WORKED. <cfselect name="custName" id="custName" multiple="false" bind="cfc:variables.objq.getCustName()" bindonload="true" value="t_bpid"display="name"/> 2. WOKRED <cfselect name="custName" id="custName" multiple="false" bind="cfc:cfc.getCustName(compID=request.compID)" bindonload="true" value="t_bpid"display="name"/> Thanks

kt03 · ‎Sep 20, 2013

Hi, i want to find the if the record from the list is matched with the record from the query but my code is not working. Can you please help? <cfset variables.subListItems = valuelist(variables.FindNocost.cost ,',') /> <cfset variables.FindSubNoCost = report_Nocost.getSubNoCost() /> <cfloop query="variables.FindSubNoCost"> #listFindNoCase(variables.subListItems ,item, ",")# </cfloop> Thanks

kt03 · ‎Sep 18, 2013

Hi, When i try to dump the Ram from cfm, i got error :Variable Ram is undefined. However, when dump the rfalg inside the cfc, it got all the results. Can anyone please tell why? Thanks  <cfcomponent name="costingReport" access="public" description="generating report">  <cffunction name="init" access="remote" output="false" returntype="Any" hint="constructor"> <cfreturn this /> </cffunction> <cffunction name="FindR" access="public" returntype="any"> <cfargument name="parentID" type="string" required="yes" /> <cfset var rflag = 'No'> <cfquery name="findChildren_1" datasource="#dsn#"> select * from mytbl where mint = '#ltrim(arguments.parentid)#' </cfquery> <cfif findChildren_1.recordcount eq 0> <cfset rflag = 'No'> <cfbreak> <cfelse> <cfloop query="findChildren_1"> <cfquery name="findChildren_2" datasource="#dsn#"> select * from and mint ='#ltrim(findChildren_1.sam)#' </cfquery> <cfif findChildren_2.RecordCount GT 0> <cfset rflag = 'Yes'> <cfelse> <cfset rflag = 'No'> <cfbreak> </cfif> </cfloop> </cfif> <cfdump var="#rflag#"><br> <cfreturn rflag /> </cffunction> </cfcomponent>  <cfinvoke component="components.FindR" method="init" returnVariable="report_R" /> <cfset Ram = report_R.FindR(parentID) /> <cfdump var="#Ram#">

kt03 · ‎Aug 30, 2013

Hi All, Is it possible to set the multiple datasources on a Application.cfc using this.datasouce attribute? CF 9, from application.cfc, you can set <cfset this datasouce ="myDSN1" > and no need to specify the DSN in the query. My question is if I have multiples Datasouces, how can i set them up in application.cfc? < cfquery name="qDoctype"> select * from type </cfquery> Thanks

kt03 · ‎May 28, 2013

thank you very much. i dont know much about the javascript, but unfortunately my form needs javascript validation. i have another quuestion. i have the form with several fields, but i only need to validate if radio is selected w/o enter name into name field. I want to display message both coditions are meet. - thanks <script type="text/javascript"> function checkRadios(form) { var btns = form.r0; for (var i=0; el=btns; i++) { if (el.checked) return true; { if (document.getElementById ("name").value.length == 0){ } } alert('name must be entered'); return false; } return true; } </script> <form id="f0" action="test.cfm" onsubmit="return checkRadios(this);"> one<input type="radio" name="r0" value="1"><br> <input type="text" name="t" class="required"> <input type="submit" name="submit" value="Save" class="button"> </form>

kt03 · ‎May 28, 2013

Thanks for your repond. The validate seems working with displayed message, but even i checked the checkbox, enter the comments, hit submit button,but it didn't go any where. submit button seems didn't do anything. <script type="text/javascript"> function validateForm(oForm) { //checkboxes var numChecked = 0; for (var idx=0; idx<oForm.category.length; idx++) { if (oForm.category[idx].checked == true) { numChecked++; break; } } if (numChecked == 0){ alert('Please check at least one checkbox'); return false; } //comments if (document.getElementById ("comments").value.length == 0) alert ("Please enter a search field"); return false; } </script>

kt03 · ‎May 28, 2013

ok, i got the check box working, but it not checking for other fields on the page. Can you pls advice this? <script type="text/javascript"> function validateForm(oForm) { //checkboxes var numChecked = 0; for (var idx=0; idx<oForm.category.length; idx++) { if (oForm.category[idx].checked == true) { numChecked++; break; } } if (numChecked > 0) { return true; } else { alert('Please check at least one checkbox'); return false; } /'/comments if (oForm.getElementById ("comments").value.length == 0) alert ("Please enter a search field"); return false; } </script> <textarea name="comments" id="comments"></textarea>

kt03 · ‎May 28, 2013

Hi all, I have the query is displayed the check boxes. I'd to validate and make sure at least one check box needs to be checked. The code i have below is not working. Can you please help. Thanks KT <cfinclude template="userCheck.cfm"> script type="text/javascript"> function validate(oForm) { var numChecked = 0; for (var idx=0; idx<oForm.category.length; idx++) { if (oForm.category[idx].checked == true) { numChecked++; break; } } if (numChecked > 0) { return true; } else { alert('Please check at least one checkbox'); return false; } } </script> <html> <body> <form onsubmit="return validate(this);"" action="next.cfm" id="form" name="form"> <cfoutput query="variables.category"> <input type="checkbox" name="category" id="category">#cat_var# </cfoutput> <input type="submit" value="Submit" /> </form> </body> </html>

kt03 · ‎Apr 16, 2013

Hi, i am using cf mx 7. I have done some reading about this and not sure about the templae attribute. I see some examples from live document with format PDF and wonder what is myreport.cfr? <cfreport template="myreport.cfr" style="mystyle.css" format="PDF"> <cfreportParam subreport="subreport1" style="subreport1-style.css"> <cfreportParam subreport="subreport2" style="subreport2-style.css"> </cfreport> I created the Report.xlsx at the same location where i have cfm pages with the syntax below. Either one below still give me an error <CFREPORT format="Excel" template="Report.xlsx" query="#myquery#"/> OR <CFREPORT format="Excel" template="#GetDirectoryFromPath(GetTemplatePath())#/Report.xlsx" query="#myquery#"/> Error: The reportCFC file D:\Inetpub\apps\Report.xlsx does not exist, or could not be found. any one got any advice? Thanks kt

kt03 · ‎Mar 25, 2013

Hi, what is wrong with this code since the drop down box is not changing to display the correct value. It didn't highlighted the one i selected.. <cfoutput> <cfif isDefined('form.code')> <cfset page.code = form.code /> </cfif> <form action="#cgi.SCRIPT_NAME#" method="post" name="mycode"> <select name="code" required="yes" onchange="this.form.submit()"> <option value=""><b>Select Customer</b></option> <option value="AB" <cfif isDefined('form.code')><cfif form.code eq "AB">selected</cfif></cfif>>AB- None</option> <option value="CD" <cfif isDefined('form.code')><cfif form.code eq "CD">selected</cfif></cfif>>CD- Deliver</option> </select> </form> <cfif isDefined('page.code')> #code# </cfif> </cfoutput> thanks

kt03 · ‎Mar 07, 2013

Hi, i want to dump the records into excel report but wonder if i can display the header cloumns on every single page? For example, if i have 200 records and dump all into excel that have about 5 pages, how can i have the header colums to show header fields: Sale No , DeptNo, SaleDate, etct on all 5 pages? <cfheader name="Content-Disposition" value="inline; filename=report.xls.xlsx"> <cfcontent type="application/vnd.ms-excel"> <table cellpadding="0" cellspacing="0" border="1" width="80%"> <tr> <th width="7%"> Date</th> <th width="5%">Sale</th> <th width="5%">Dep.</th> </tr> <cfoutput query="variables.q_sale"> <tr> <td >#orderDate#</td> <td >#sale#</td> <td >#dept#</td> </tr> </cfoutput> </table> </cfcontent> if this option can't be done in excel, then I can used web instead. For web report, I display 200 records with the navagiation next and previous to go thru all 5 pages. I have the link for user to click on to print report in friendly format. On this page, it will displayed all 200 records on one page, but when they print, it will print 5 pages and i want the header fields displayed on all 5 pages. Thanks kt

kt03 · ‎Dec 17, 2012

Hi, i have the simple form for user to enter in PurNo. Results is displayed fine with next and previous navigation. without order by from the query, the next/previous worked fine. However, afer i added order by PurNo, NesID into my query then navigation didn't work as expected. for example, when i click next, i see it changed for message and date added column but not for Pur No. Can any one tell me what's wrong ? Thanks  <cffunction name="sale" returntype="query" access="public"> <cfargument name="PurNo" required="yes" type="numeric" /> <cfquery name="qsale" datasource="#variables.dsn#"> SELECT * FROM tblsale WHERE PurNo = <cfqueryparam value="#arguments.so#" cfsqltype="cf_sql_integer" /> order by PurNo, NesID </cfquery> <cfreturn qsale /> </cffunction>  <cfobject type="com" name="request.sale" component="cfc.query"> <cfset variables.request.sale = request.so_expected.init(variables.dbsource) /> <cfset variables.q_sale = request.sale.sale(PurNo ) /> <cfset nav = request.sale.nextXpage(variables.q_sale.recordcount,URL.page,10) /> <cfif nav.previous> <a href="next.cfm?PurNo=#PurNo#&page=#nav.previouspage#">Previous</a> </cfif> <cfif nav.next> <a href="next.cfm?PurNo=#PurNo&page=#nav.nextpage#">Next</a> </cfif> <th>Pur No.</th> <th>Message.</th> <th>Date Added</th>

kt03 · ‎Dec 12, 2012

datetime

kt03 · ‎Dec 12, 2012

Hi, I am query out and display all dates from my table but for some reason I have invalide date such as :1753-01-01 00:00:00.0 and some others invalid. I only need to display the valid date, if not valid then display empty, however, the code i have below was not working. <cfloop query="q_pur"> <cfif not isDate(chgDate)> <cfset valid_chg_date = '' /> <cfelse> <cfset valid_chg_date = chgDate /> </cfif> #valid_chg_date#<br /> :--->it still shows 1753-01-01 00:00:00.0 instead of ' ' (empty string) </cfoutput> any idea? thanks

kt03 · ‎Dec 11, 2012

Hi, I have coldufusion 7 and can't use the datafield type for input field. Instead, i want the pop up calendar for user to pick the date. I've search from the web and they talked about jquery but do'n't know about this. I did see some code but don't know how to call in cfm page. Can any one please walk me through this? thanks kt

kt03 · ‎Dec 07, 2012

how do you pass the dynamic name to next page? i've try this but it wasn't working <cfoutput> <cfset email = email#idx#> #email# </cfoutput>

kt03

kt03

Activity

cfide/administrator

Create DSN with instance server

Re: schedule task

Re: schedule task

Re: schedule task

Re: schedule task

Re: schedule task

Re: schedule task

schedule task

list

jquery hide and show

CF Administrator

onChange vs. onclick

onkeyup

bind

FindNoCase

error?

Multiples DSNs' application.cfc

Re: dynamic check boxes validation

Re: dynamic check boxes validation

Re: dynamic check boxes validation

dynamic check boxes validation

cfreport

on change

excel report/web report

nex/previous

Re: invalid date

invalid date

jquery for calendar picker

Re: dynamic field