Adobe Community : All Content - All Communities

compare values

forums_noreply@adobe.com — Tue, 21 Oct 2014 16:35:50 GMT

Hi,

I have the query with out put below for one field as an example

Status

------

yes

i want to be able to do the compare for ALL status in one field but don't know how to do it, Can anyone plz help? Thanks

<cfif all status = "yes" ---> display Yes

<cfelseif all status = No -- display No

<cfelse> Other

</cfif>

cfgrid insert

forums_noreply@adobe.com — Thu, 12 Jun 2014 16:05:08 GMT

I am using CF9 and having the cfgrid to display all name from the table. I want to be able to insert/update/delete name from the cfgrid but not sure how to do it. Can anyone please help? - Thanks

<cfgrid

name="idGrid"

title="Failure Reasons"

width="500" rowheaderalign="left"

query="variables.qFailedReasons"

autowidth="false" griddataalign="left" gridlines="yes" colheaderalign="left"

selectmode="edit"

insert="yes" insertbutton="Insert New Failure Reason"

delete="yes" deletebutton="Delete Selected row"

enabled="yes" visible="yes"

format="html">

</cfgrid>

</cfform>

barcode scan

forums_noreply@adobe.com — Tue, 10 Jun 2014 13:48:42 GMT

Hi,

The form I have with several fields on it such as ProductID, Description, Price, ect. The back-end database is storing the information of these fields. I have the sheet list of all productID and scanner to scan the productid barcode. The productID is can into the productID field from the form. My question is how can I populate the Description and Price of each productID when it’s scan?

Thanks

read csv

forums_noreply@adobe.com — Tue, 18 Feb 2014 20:50:36 GMT

Hi all,

I have the csv file with the format below.It has about 15 fields. I want to read this CSV file and inserts the records into my table but got an error below.

43;Test;;TEST PASS;Time Completed;22.13202;21.55828;;119.95;3 - WATER SEAT P;315.0;120;5.0;16/07/2012;22:17:36;

======ERROR ===========

Invalid list index 14.

In function ListGetAt(list, index [, delimiters]), the value of index, 14, is not a valid as the first argument (this list has 13 elements). Valid indexes are in the range 1 through the number of elements in the list.

===========

Can anyone can help me plz?

INSERT INTO csv ([one]

,[two]

,[three]

,[four]

,[five]

,[six]

,[seven]

,[eight]

,[nine]

,[ten]

,[elveven]

,[twelve]

,[thirteen]

,[fourteen]

,[fifteen])

VALUES

('#listgetAt('#index#',1, ';')#',

'#listgetAt('#index#',2, ';')#',

'#listgetAt('#index#',3, ';')#',

'#listgetAt('#index#',4, ';')#',

'#listgetAt('#index#',5, ';')#',

'#listgetAt('#index#',6, ';')#',

'#listgetAt('#index#',7, ';')#',

'#listgetAt('#index#',8, ';')#',

'#listgetAt('#index#',9, ';')#',

'#listgetAt('#index#',10, ';')#',

'#listgetAt('#index#',11, ';')#',

'#listgetAt('#index#',12, ';')#',

'#listgetAt('#index#',13, ';')#',

'#listgetAt('#index#',14, ';')#',

'#listgetAt('#index#',15)#'

)

</cfquery>

</cfloop>

</cfoutput>

cfsearch

forums_noreply@adobe.com — Wed, 12 Feb 2014 16:44:51 GMT

Hellow everyone,

I want to be able to search the whole keyword not just the part of this. For example, if user enters a keyword "material", i want the results return the list of document that contain the whole word "material" not matter, match, matchup, etc.

I've tried with type="explicit" but got an error message ""error executing query:unknown_handler_explicit". It doesn't matter what type i specify, i always got this message. Can anyone plz help?

Thanks

Lisa

<cfsearch

name = "myDoc"

collection = "customer"

criteria = "#url.search#"

type="explicit"

startrow=1

maxrows = "100">

validate check box

forums_noreply@adobe.com — Wed, 05 Feb 2014 17:14:57 GMT

I have the type file for users to upload file. If they browse the file, they have to select the document type from the check box and versus. This code didn't do what I want. Can onyone pls help?

Thanks

function validateForm(oForm) {

var numChecked = 0;

for (var idx=0; idx<oForm.doc_type.length; idx++) {

if (oForm.doc_type[idx].checked == true) {

numChecked++;

break;

}

if (document.getElementById ("cpc").value.length ! == 0)

if (numChecked == 0){

alert('Please check at least one checkbox');

return false;

}

return false;

}

//all checked, then return true for submit

return true;

} </script>

<input type="radio" id="doc_type" name="doc_type" size="20" tabindex="3" value="#id_int#" <cfif id_int eq form.doc_type>checked="checked" </cfif> />#type_var#

</cfloop>

</form>

break line

forums_noreply@adobe.com — Mon, 27 Jan 2014 20:21:32 GMT

why the results shows Jonh<br>Doe instead of

John

Can anyone pls help?

Thanks

how replace comma with break line

forums_noreply@adobe.com — Tue, 07 Jan 2014 16:43:46 GMT

Hi,

Instead of John,Dee, i want it to show

John

Dee.

my code isn't do what i want, can anyone help pls?

thanks

#TheText#

</cfoutput>

auto refresh the cfgrid

forums_noreply@adobe.com — Fri, 03 Jan 2014 17:58:16 GMT

Hi,

I am displaying the search results into the cfgrid. The date field is using the datepicker calendar and I have to click on the fresh button below to refresh the search results. It worked fine with onkeyup below, if I manual enter the date into the textbox instead to pick from the calendar. How can I have it autofresh when i pick the date from the calendar?

thanks

pass query id into pop up window

forums_noreply@adobe.com — Mon, 30 Dec 2013 22:11:52 GMT

Hi,

i want to be able to pass the id from the query into the popup window but not sure how to do it, would you please help me with this? - thanks

code below (A) working fine with open the pop up detail page but din't know how to passs an id into detail page.

function openWin()

{

window.open("detail.cfm","_blank","toolbar=yes, scrollbars=yes, resizable=yes, top=500, left=500, width=400, height=400");

}

</script>

</cfloop>

I try to call the page directly such as below but got an error for "invalid character"

<cfset querysetcell(foo,'Renew','<a href="javascript: void(0);" onclick="window.open("detail.cfm?id=#id#","_blank");>renew</a>')>

</cfloop>

query to query

forums_noreply@adobe.com — Thu, 19 Dec 2013 21:59:52 GMT

it is more complicate to describe why i have to do this but it's the only way just an example below.

My query to give me anthing from the table when i do the query to query to get what i want but when i use the left string function then i got an error below.

Query Of Queries syntax error.

Encountered "left. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition,

thanks

select * from [dbo].[requestType]

</cfquery>

results look like

type:

=====

ADD

REMYU

RECD

I want to do the query to query to get the REMYU

select * from type

where left(type,3) = 'rem'

</cfquery>

CFGRID - Uing Javascript

forums_noreply@adobe.com — Thu, 12 Dec 2013 21:06:57 GMT

From the grid below, if i click on ID fiel, i got the alert pop up with id number. In stead of this ID, i want it open the pop up with details.cfm which i already comment out from the js function. I did not know much about the javascript but when uncomment the code to open for the detail page then i still have it open but not in the pop up, it's open in a seperate page. Can you help please.

addLinksforaTasks = function() {

gTask = ColdFusion.Grid.getGridObject('SchedulesGrid');

gTask.on('cellclick',function(grid,rowIndex,columnIndex,e){

var assetID =

ColdFusion.getElementValue('SchedulesGrid','SchedulesForm','id_int');

alert(assetID);

//newwindow=window.open('details.cfm','height=200,width=150');

})

}

</script>

args = {};

args.bind = "cfc:CFC.schedule.cust({cfgridpage},{cfgridpagesize},

{cfgridsortcolumn},{cfgridsortdirection})";

args.delete = TRUE;

args.format = "html";

args.insert = false;

args.name = "SchedulesGrid";

args.pagesize = "5";

args.selectmode = "browse";

args.striperows = TRUE;

args.autowidth = true;

args.height = "205";

</cfscript>

</cfgrid>

</cfform>

bind: Bind failed, element not found

forums_noreply@adobe.com — Tue, 10 Dec 2013 16:09:38 GMT

Hi,

i've test a simple search with cfgrid but don't know why when i dump the arguments from my cfc and it shows null instead of empty string.

To testing, i added cfdebug at the end and see some error:

Element not found: ANo

'gridRender' is undefined.

Please look at my code below and let me know what did i have wrong. -Thanks

<cfset ajaxOnLoad("gridRender")>


    
    <cfcomponent displayname="search" output="no" hint="search a number">
     <cffunction name="SearchA" returntype="struct" access="remote">
        <cfargument name="page" required="true" />
        <cfargument name="pageSize" required="true" />
        <cfargument name="gridsortcolumn" required="true" />
        <cfargument name="gridsortdirection" required="true" />

       <cfargument name="ANo" required="yes" type="any" />
        <cfdump var="#arguments#"><cfabort>

        <cfquery name="qSearchA" datasource="#dsn#">
          select * from mytblb
          where 0=0
        <cfif arguments.ANo neq "">
          ANo_var = <cfqueryparam value="#arguments.ANo#" cfsqltype="cf_sql_varchar" />
        </cfif>
    </cfquery>

        <cfreturn queryconvertforgrid(qSearchA, page, pagesize)>
        </cfquery>

    </cfcomponent>

i don't see html from cfgrid format, all i see is xml, applet, flash. I mannulay entery HTML in, do you know why is HTML is not on the list?

cfgridcolumn with hyperlink

forums_noreply@adobe.com — Wed, 11 Dec 2013 21:10:42 GMT

Hi,

this code works fine, the link from A Number field opens the new page. Instead of open the new page in a new window, I want it to open in the pop up window, is there the way to do it? thx

cfgrid

forums_noreply@adobe.com — Tue, 10 Dec 2013 18:01:21 GMT

Hi,

i have the search page and want to display the results on the the cfgrid. Both form and cfgrid are on the same page. When i first open the form.cfm page, i see all the results already display on the page. This is not right, i only want the results to display when i search something and hit on the submit button. Can you please help?

</cfform>

<cfquery name="myQuery" datasource="#dsn#">
select * from mytbl

     where 1=1
       <cfif arguments.aNo_var neq "">
        aNo_var = <cfqueryparam value="#arguments.aNo_var#" cfsqltype="cf_sql_varchar" maxlength="50" />
</cfif>
        </cfquery>
<cfreturn queryconvertforgrid(myQuery, page, pagesize) />
</cffunction>
</cfcomponent>

complete example of using the jquery autocomplete with ColdFusion

forums_noreply@adobe.com — Tue, 22 Oct 2013 14:16:50 GMT

Hi,

have any one tried the code from this link: http://www.jensbits.com/2010/03/18/jquery-ui-autocomplete-with-coldfusion/?

i created table with 2 columns:

Colnumn # 1: abbrev : TX, CA

Column # 2: state: Texas, California

and try the code from the link above but it did do anything for me, i am not sure if didn't have it right, can you please help?

Thanks

Lisa

============

<form action="index.cfm" method="post">
<fieldset>
<legend>jQuery UI Autocomplete Example - ColdFusion Backend</legend>
<p>Start typing the name of a state or territory of the United States</p>
<p class="ui-widget"><label for="state">State (abbreviation in separate field): </label>
<input type="text" id="state" name="state" /> <input readonly="readonly" type="text" id="abbrev" name="abbrev" maxlength="2" size="2"/></p>
<input type="hidden" id="state_id" name="state_id" />
<p class="ui-widget"><label for="state_abbrev">State (replaced with abbreviation): </label>
<input type="text" id="state_abbrev" name="state_abbrev" /></p>
<p><input type="submit" name="submit" value="Submit" /></p>
</fieldset>
</form>

<cfset returnArray = ArrayNew(1) />

<cfquery name="qryStates" dataSource="remoteNetwork">
Select * from states where state like <cfqueryparam value="%#URL.term#%" cfsqltype="cf_sql_varchar">
</cfquery>

<cfoutput>
#serializeJSON(returnArray)#
</cfoutput>
</cfif>

tag in cfmail subject

forums_noreply@adobe.com — Mon, 11 Nov 2013 16:54:49 GMT

Hi,

is <b> tag work win subject?

<cfset variables.subject = "Access for <b>#form.name#</b> has been removed. " />

<cfmail from="#variables.mailFrom#" to="#variables.mailto#" subject="#variables.subject#" type="html">
.......
</cfmail>

Email sent with subject:
Access for <b>#John Smith#</b> has been removed. How can bold the name John Smith?

Thanks

auto-completed

forums_noreply@adobe.com — Thu, 10 Oct 2013 14:56:13 GMT

    I am not sure how to do it. I have the augosugess working fine from the first input field. When i start enter the name into this box, i want other information automatic to populate into other text boxses as well like company , descp for this name. Can some some pleae help?

<cffunction name="lookupItem" access="remote" returntype="array">
    <cfargument name="search" type="any" required="false" default="">

        
        <cfset var qArt="">
        <cfset var result=ArrayNew(1)>

        
      <cfquery name="qArt" datasource="art">
          select * from [dbo].[arts]
         WHERE Artname LIKE '#ARGUMENTS.search#%'
        </cfquery>

        
        <cfloop query="qArt">
       <cfset ArrayAppend(result, Artname)>

        </cfloop>

                
        <cfreturn result>
    </cffunction>


    <cfform action="" method="post" name="medform">
    <cfinput autosuggest="cfc:cfc.Art.lookupItem({cfautosuggestvalue})" type="text" name="Artname" size="30" typeahead="yes">


    Name<cfinput type="text" name="desc" label="desc" bind="{Artname}" ><br>

    Comp:<cfinput type="text" id="comp" name="comp" label="conp" bind="cfc:cfc.Art.lookupItem({Artname})" >

    Desc:<cfinput type="text" id="desc" name="desc" label="desc" bind="cfc:cfc.Art.lookupItem({Artname})" >
    </cfform>

Cfdiv and bind

forums_noreply@adobe.com — Thu, 10 Oct 2013 01:29:34 GMT

    Hi,

    What i am try to do is when i start enter the name into text box, i want the result is auto refresh or filter into the cfdiv tag. My code did not work, can some one please give me a hand?

Thanks

    <cffunction name="getArtDescription" access="remote" returnType="query">
      <cfargument name="name" type="any" required="false">

        <cfset var data="">
        <cfset var result="">

        
        <cfquery name="data" datasource="#dsn#">
          select * from [dbo].[Arts]
        WHERE nam LIKE '#ARGUMENTS.name#%'
        </cfquery>

      <cfif data.RecordCount IS 1>
        <cfsavecontent variable="result">
                <cfoutput>
                    #data.name#
                     #data.desc#
                </cfoutput>
            </cfsavecontent>
        </cfif>

                                <cfreturn result>

    </cffunction>

<cfform action="" method="post" name="artForm">
                <cfinput type="text" name="name">
</cfform>

<cfdiv id="name" name="name" bind="cfc:cfc.Art.getArtDescription({name@KeyUp})" bindOnLoad="false"/>