len() function

Report · Jul 21, 2011

Hi all,

Am new to CFM and my client asked me to make a small change in his website. So, i identified the page and did a small change. But the change is not working. I've attached the file for reference.

In that file, see the commentd line nos : 139-147

<!---<cfset new="#dato#">

</cfif>--->

and the line no - 148 is having the partial query as a string.

But whats the value am generating in the 139-147 lines is not coming in that 148th line.

For Eg:

Can anyone help me to solve this problem?

Report · Jul 21, 2011

Could that is because the lines are commented out and not executing? Your question is not very clear. You don't say what you changed, did you add the comment tags?

Report · Jul 21, 2011

Sorry, I forgot to remove the comments at the time of posting.

Originally there is no comment in the page.

Report · Jul 21, 2011

Actually you may have been on the right track, put the comments

back, you don't need any of that (ummmmm code)...

try this:

Report · Jul 21, 2011

I tried this ...

and for eg, lets take dato=240.. but in the output am getting ... "and c.IdCliente like '%000000%' "

it needs to come as 000240.

What is the mistake?

Report · Jul 21, 2011

Sorry,

try:

Report · Jul 21, 2011

Changed this.. but still getting the same 000000 only.

Report · Jul 21, 2011

Then dato must be empty or zeros...

Try:

Report · Jul 21, 2011

If i use, only #dato# in my query and put cfoutput means, the dato value is coming. but if i use the code which you've sent, the dato value is coming as 000000. I dont know whats the prboem, and cant able to attach me files too for your reference in this post.

Report · Jul 21, 2011

Am pasting the files for your reference,

vclientesbusqueda.cfm

<html>

<head>

<!--

var message="Function Disabled!";

function clickIE4(){

if (event.button==2){

alert(message);

return false;

}

function clickNS4(e){

if (document.layers||document.getElementById&&!document.all){

if (e.which==2||e.which==3){

alert(message);

return false;

}

if (document.layers){

document.captureEvents(Event.MOUSEDOWN);

document.onmousedown=clickNS4;

}

else if (document.all&&!document.getElementById){

document.onmousedown=clickIE4;

}

document.oncontextmenu=new Function("alert(message);return false")

// -->

</script>

</head>

</td>

</tr>

<cfinclude template="includes/vclientesbusquedap.cfm">

</td>

</tr>

</td>

</tr>

</cfoutput>

</table>

</div>

</body>

</html>

includes/vclientesbusquedap.cfm

select descripcion,clase,secuencia

from textos

where ididioma=#session.sitea.ididioma# and template=#template#

order by clase,secuencia

</cfquery>

</cfloop>

</cfoutput>

select descripcion,clase,secuencia

from textos

where ididioma=#session.sitea.ididioma# and template=#template#

order by clase,secuencia

</cfquery>

</cfloop>

</cfoutput>

</cfif>

</cfif>

select descripcion,clase,secuencia

from textos

where ididioma=#session.sitea.ididioma# and template=#template#

order by clase,secuencia

</cfquery>

</cfloop>

</cfoutput>

function pregunta(x,y,d)

{

if (confirm("Esta seguro de borrar a este cliente"))

document.location.href = "vclientesbusqueda.cfm?parte=3&Idc=" + x + "&idcp=" + y + "&dato=" + d;

}

function MM_openBrWindow(theURL,winName,features) { //v2.0

window.open(theURL,winName,features);

}

function Cambio()

{

document.registro.parte.value=1;

document.registro.submit();

}

function Cambio2()

{

document.registro.parte.value = 2;

document.registro.submit();

}

function Cambio3()

{

if (document.registro.txtDistribuidor.value==0 && document.registro.txtVendedor.value==0)

{ alert("Seleccione a un distribuidor o vendedor");

return false;

}

document.registro.dato.value=3;

document.registro.parte.value=22;

return true;

}

function Cambio4()

{

document.registro.dato.value=4;

document.registro.parte.value=4;

}

</script>

$(document).ready(function(){

$("#ya3").jSuggest({

minchar: 3,

url: "includes/2/datacliente.cfm",

type: "GET",

data: "dato3",

autoChange: false,

loadingText: "Loading ..."

});

/*function assist()

{

//alert('hi');

//$('#assistimg').click(function(event){

$("#ya3").jSuggest({

minchar: 3,

url: "includes/2/datacliente.cfm",

type: "GET",

data: "dato3",

autoChange: false,

loadingText: "Loading ..."

});

//});

}*/

</script>

</cfif>

<tr>

</td>

</tr>

<tr>

<td colspan="5" class="subtitles"> <cfoutput>#instruccion#</cfoutput> </td>

</tr>

delete domicilio where idcliente = '#idc#'

</cfquery>

delete carritocaract where idcliente = '#idc#'

</cfquery>

delete carrito where idcliente = '#idc#'

</cfquery>

delete ClientePublicidad where Idcliente = '#idc#'

</cfquery>

delete NotaCliente where Idcliente = '#idc#'

</cfquery>

delete cliente where idcliente = '#idc#'

</cfquery>

delete from Vendedor where IdDistribuidor='#Idcp#' and IdCliente='#Idc#'

</cfquery>

<br>

La informaci�n del cliente se ha borrado

</div>

</cfif>

</td></tr>

<tr><td colspan="6" align="right"><cfoutput><a href="#session.sitea.elurlgeneral#vclientesdisa.cfm?id=#idcp#">#Altac#</a></cfoutput></td></tr>

<td align="center" colspan="4" class="txtminib"><cfoutput>#TBusquedaP#</cfoutput></td>

</tr>

<td align="left" colspan="4" class="txtb"><cfoutput>#TBusquedaDir#</cfoutput></td>

</tr>

<tr>

<cfoutput>#BDEDato#</cfoutput>

<input type="Text" id="ya3" name="dato3" size="30" maxlength="60" tabindex="1" value=""> <font size="1">(oprima enter)</font>

</td>

</tr>

</table>

</td>

</tr>

</cfif>

</cfif>

<td class="txtbuscador" align="left"><input onclick="Cambio2();" type="Radio" name="busca" value="Nombre" <cfif busca eq "Nombre">checked</cfif> tabindex="3"><cfoutput>#BDENombre#</cfoutput></td>

<td class="txtbuscador" align="left"><input onclick="Cambio2();" type="Radio" name="busca" value="Email" <cfif busca eq "Email">checked</cfif> tabindex="4"><cfoutput>#BDEEmail#</cfoutput></td>

</tr>

<td class="txtbuscador" align="left"><input onclick="Cambio2();" type="Radio" name="busca" value="No" <cfif busca eq "No">checked</cfif> tabindex="6"><cfoutput>#BDECotizacion#</cfoutput></td>

<td class="txtbuscador" align="left"><input onclick="Cambio2();" type="Radio" name="busca" value="Apellido" <cfif busca eq "Apellido">checked</cfif> tabindex="7"><cfoutput>#BDEApellido#</cfoutput></td>

<td class="txtbuscador" align="left"><input onclick="Cambio2();" type="Radio" name="busca" value="Telefono" <cfif busca eq "Telefono">checked</cfif> tabindex="8"><cfoutput>#BDETelefono#</cfoutput></td>

</tr>

<td align="left" colspan="4" class="txtb"><cfoutput>#TBusquedaGen#</cfoutput></td>

</tr>

select idpais,descripcion,CE from pais where ididioma=#session.sitea.ididioma# order by descripcion

</cfquery>

<tr>

<td class="txtbuscador" align="right"><cfoutput>#BGEPais#</cfoutput></td>

</cfif>

<option value="0" <cfif PPais eq 0>selected</cfif>><cfoutput>#BDETodos#</cfoutput></option>

<option value="#paises.idpais#" <cfif PPais neq 0><cfif PPais eq paises.idpais>selected</cfif></cfif>>#paises.descripcion#</option>

</cfoutput>

</select></td>

</tr>

select CE from pais where IdPais = #PPais# and ididioma=#session.sitea.ididioma#

</cfquery>

</cfif>

<tr>

<td class="txtbuscador" align="right"><cfoutput>#BGEEstado#</cfoutput></td>

select idestado,descripcion from estado where idpais = #PPais# order

by descripcion

</cfquery>

<option value="0" <cfif PEstado eq 0>selected</cfif>><cfoutput>#BDETodos#</cfoutput></option>

<option value="#estados.idestado#" <cfif PEstado neq 0><cfif PEstado eq estados.idestado>selected</cfif></cfif>>#estados.descripcion#</option>

</cfoutput>

</select></td>

<option value="0" <cfif PEstado eq 0>selected</cfif>><cfoutput>#BDETodos#</cfoutput></option>

</select>

</td>

</cfif>

</tr>

select IdPublicidad,Publicidad from publicidad where Tipo = 1 and ididioma=#session.sitea.ididioma# order

by IdPublicidad

</cfquery>

<tr>

<td class="txtbuscador" align="right"><cfoutput>#BGEGiro#</cfoutput></td>

</cfif>

<option value="0" <cfif PGiro eq 0>selected</cfif>><cfoutput>#BDETodos#</cfoutput></option>

<option value="#Giro.IdPublicidad#" <cfif PGiro neq 0><cfif PGiro eq Giro.IdPublicidad>selected</cfif></cfif>>#Giro.Publicidad#</option>

</cfoutput>

</select></td>

</tr>

select IdPublicidad,Publicidad from publicidad where Tipo = 3 and ididioma=#session.sitea.ididioma# order

by IdPublicidad

</cfquery>

<tr>

<td class="txtbuscador" align="right"><cfoutput>#BGETamano#</cfoutput></td>

</cfif>

<option value="0" <cfif PTamano eq 0>selected</cfif>><cfoutput>#BDETodos#</cfoutput></option>

<option value="#Tamano.IdPublicidad#" <cfif PTamano neq 0><cfif PTamano eq Tamano.IdPublicidad>selected</cfif></cfif>>#Tamano.Publicidad#</option>

</cfoutput>

</select></td>

</tr>

select IdPublicidad,Publicidad from publicidad where Tipo = 2 and ididioma=#session.sitea.ididioma# order

by IdPublicidad

</cfquery>

<tr>

<td class="txtbuscador" align="right"><cfoutput>#BGEMedio#</cfoutput></td>

</cfif>

<option value="0" <cfif PMedio eq 0>selected</cfif>><cfoutput>#BDETodos#</cfoutput></option>

<option value="#Medio.IdPublicidad#" <cfif PMedio neq 0><cfif PMedio eq Medio.IdPublicidad>selected</cfif></cfif>>#Medio.Publicidad#</option>

</cfoutput>

</select></td>

</tr>

select IdCategoriaCte,Descripcion from CategoriaCte order

by Descripcion

</cfquery>

<tr>

<td class="txtbuscador" align="right"><cfoutput>#BGECategoria#</cfoutput></td>

</cfif>

<option value="0" <cfif PCategoria eq 0>selected</cfif>><cfoutput>#BDETodos#</cfoutput></option>

<option value="#Categoria.IdCategoriaCte#" <cfif PCategoria neq 0><cfif PCategoria eq Categoria.IdCategoriaCte>selected</cfif></cfif>>#Categoria.Descripcion#</option>

</cfoutput>

</select></td>

</tr>

<tr>

<td class="txtbuscador" align="right"><cfoutput>#BGETiempo#</cfoutput></td>

<tr>

<input type="text" name="tiempo" size="30" maxlength="60" <cfif isdefined("tiempo")>value="<cfoutput>#Tiempo#</cfoutput>"</cfif>> <cfoutput>#BGEPeriodo#</cfoutput></td>

<td align="right"><input type="image" src="../vgraficos/searchicon.png" name="cmdcascada" value="<cfoutput>#btBuscar#</cfoutput>" onClick="Cambio4()"></td></tr>

</table>

</td>

</tr>

</table>

</td>

</tr>

<td align="left" colspan="4" class="txtb"><cfoutput>#TBusquedaCas#</cfoutput></td>

</tr>

<!--- <cfquery name="DM" username="#session.uid#" password="#session.pwd#" datasource="#session.dsna#">

select c.Idcliente,c.RazonSocial,c.Paterno,c.Materno,c.Contacto

from Cliente c

where c.Distribuidor = 2

order by c.RazonSocial,c.paterno,c.Materno

</cfquery> --->

<!--- <tr>

<td class="txtbuscador" align="right">Distribuidor Master</td>

<option value="0">Seleccione el Distribuidor Master</option>

<option value="#DM.IdCliente#" <cfif isdefined("DMaster")><cfif DMaster eq DM.IdCliente>selected</cfif></cfif>>#DM.RazonSocial# #DM.Paterno# #DM.Materno# <cfif DM.Contacto neq ""> (#DM.Contacto#)</cfif></option>

</cfoutput>

</select></td>

</tr>

select c.Idcliente,c.RazonSocial,c.Paterno,c.Materno,c.Contacto

from Cliente c

where c.IdDistribuidor = '#idcliente#' and c.Distribuidor = 1

order by c.RazonSocial,c.Paterno,c.Materno

</cfquery>

select c.Idcliente,c.RazonSocial,c.Paterno,c.Materno,c.Contacto

from Cliente c

where c.IdCliente = '#idcliente#'

order by c.RazonSocial,c.Paterno,c.Materno

</cfquery>

<tr>

<td class="txtbuscador" align="right"><cfoutput>#BGCDistribuidor#</cfoutput></td>

<option value="0"><cfoutput>#notadistribuidor#</cfoutput></option>

<option value="<cfoutput>#idcliente#</cfoutput>" <cfif isdefined("txtDistribuidor")><cfif txtDistribuidor eq Dimismo.IdCliente>selected</cfif></cfif>><cfoutput>#Dimismo.RazonSocial# #Dimismo.Paterno# #Dimismo.Materno#</cfoutput> <cfif Dimismo.Contacto neq ""> (<cfoutput>#Dimismo.Contacto#</cfoutput>)</cfif></option>

<option value="#DI.IdCliente#" <cfif isdefined("txtDistribuidor")><cfif txtDistribuidor eq DI.IdCliente>selected</cfif></cfif>>#Di.RazonSocial# #Di.Paterno# #Di.Materno# <cfif Di.Contacto neq ""> (#Di.Contacto#)</cfif></option>

</cfoutput>

</cfif>

</select>

</td>

</tr>

select c.Idcliente,c.RazonSocial,c.Paterno,c.Materno,c.Contacto

from Cliente c,Vendedor V

where c.IdCliente = v.IdCliente and v.IdDistribuidor = '#txtDistribuidor#'

order by c.RazonSocial,c.paterno,c.Materno

</cfquery>

</cfif>

<tr> <td class="txtbuscador" align="right"><cfoutput>#BGCVendedor#</cfoutput></td>

<option value="0"><cfoutput>#notavendedor#</cfoutput></option>

<option value="#Ve.IdCliente#" <cfif txtVendedor eq Ve.IdCliente>selected</cfif>>#Ve.RazonSocial# #Ve.Paterno# #Ve.Materno#<cfif Ve.Contacto neq ""> (#Ve.Contacto#)</cfif></option>

</cfoutput>

</cfif>

</select>

</td>

</table>

</td>

</tr>

<tr> <td class="txtbuscador" align="right"><cfoutput>#BGCVendedor#</cfoutput></td>

<input type="text" name="tiempoc" size="30" maxlength="60" <cfif isdefined("tiempoc")>value="<cfoutput>#Tiempoc#</cfoutput>"</cfif>> <cfoutput>#BGEPeriodo#</cfoutput>

</td>

<td align="right"><input type="image" src="../vgraficos/searchicon.png" name="cmdcascada" value="<cfoutput>#btBuscar#</cfoutput>" onClick="return Cambio3()"></td></tr>

</table>

</td>

</tr>

</table>

</td>

</tr>

</table>

</cfform>

</cfif>

</td>

</tr>

<tr>

<td>

<cfinclude template="vbuscasitep_mani.cfm">

<cfset session.sitea.clientsearchquery = mani_querybusca>

#replace(querybusca,"''","'","all")#

</cfquery>

</cfif>

</cfif>

</cfif>

</cfif>

</cfif>

<input type="hidden" value="<cfoutput>#querybusca#</cfoutput>" name="querybusca">

</form>

</td>

<cfoutput>#conde# - #cona# #de# #numregs# ||

<a href="#session.sitea.elurlgeneral#vclientesbusqueda.cfm?parte=#parte#&busca=#busca#&dato=#dato#&conde=#confina#&idcp=#idcp#

<CFIF parte eq 4>&pgiro=#pgiro#&ptamano=#ptamano#&pmedio=#pmedio#&pcategoria=#pcategoria#&tiempo=#tiempo#</CFIF>

<CFIF parte eq 22>&txtdistribuidor=#txtdistribuidor#&txtvendedor=#txtvendedor#</CFIF>"><< #anterior#</a>

</cfif>

<a href="#session.sitea.elurlgeneral#vclientesbusqueda.cfm?parte=#parte#&busca=#busca#&dato=#dato#&conde=#confins#&idcp=#idcp#

<CFIF parte eq 4>&pgiro=#pgiro#&ptamano=#ptamano#&pmedio=#pmedio#&pcategoria=#pcategoria#&tiempo=#tiempo#</CFIF>

<CFIF parte eq 22>&txtdistribuidor=#txtdistribuidor#&txtvendedor=#txtvendedor#</CFIF>">#siguiente# >></a>

</cfif>

</cfoutput>

</td>

</tr>

<td align="center" width="40%" class="txtminib"><cfoutput>#DEInfo1#</cfoutput></td>

<td align="center" width="40%" class="txtminib"><cfoutput>#DEInfo2#</cfoutput></td>

<td align="center" width="20%" class="txtminib"><cfoutput>#DEInfo3#</cfoutput></td>

</tr>

<tr>

<td>

<tr>

#lbcliente# <span class="err">#numberformat(IdCliente,"999999")#</span><br>

#lbempresa# #RazonSocial# #Paterno# #Materno#<br>

#lbnombre# #Contacto#<br>

#lbempresa# #RazonSocial#<br>

#lbnombre# #Contacto#<br>

</cfif>

#lbpais# #Pais#, #Estado#<br>

#lbtel# #Telefono1#<br>

#lbtel2# #Telefono2#<br>

#lbfax# #Fax#<br>

#lbemail# #Email#<br>

#lbdatofiscal# #RegFedCont#<br>

</td></tr>

</table>

</td>

<td>

#DEFecha# #mes#/#day(FechaRegistro)#/#year(FechaRegistro)#<br>

#DEFecha# #day(FechaRegistro)#/#mes#/#year(FechaRegistro)#<br>

</cfif>

<tr>

<a href="#session.sitea.elurlgeneral#vpedidosclientes.cfm?tipo=v&idc=#busqueda.IdCliente#&id=#Idcp#">#numberformat(busqueda.IdCliente,"999999")#</a>

<a href="#session.sitea.elurlgeneral#vpedidosclientes.cfm?tipo=v&idc=#busqueda.IdDistribuidor#&id=#Idcp#">#numberformat(busqueda.IdDistribuidor,"999999")#</a>

</cfif>

</td></tr>

<tr>

<a href="#session.sitea.elurlgeneral#vpedidosclientes.cfm?tipo=v&idc=#busqueda.IdDistribuidor#&id=#Idcp#">#numberformat(busqueda.IdDistribuidor,"999999")#</a>

</cfif>

</td></tr>

<tr>

<td class="txtb"><a href="#session.sitea.elurlgeneral#vpedidosclientes.cfm?tipo=v&idc=#busqueda.IdCliente#&id=#Idcp#">#numberformat(busqueda.IdCliente,"999999")#</a></td></tr>

select Idcliente from Vendedor where Idcliente = '#busqueda.IdCliente#'

</cfquery>

select IdDistribuidor,Distribuidor from Cliente where Idcliente = '#busqueda.IdDistribuidor#'

</cfquery>

<tr>

<a href="#session.sitea.elurlgeneral#vpedidosclientes.cfm?tipo=v&idc=#busqueda.IdCliente#&id=#Idcp#">#numberformat(busqueda.IdCliente,"999999")#</a>

<a href="#session.sitea.elurlgeneral#vpedidosclientes.cfm?tipo=v&idc=#busqueda.IdDistribuidor#&id=#Idcp#">#numberformat(busqueda.IdDistribuidor,"999999")#</a>

</cfif>

</td></tr>

<tr>

<a href="#session.sitea.elurlgeneral#vpedidosclientes.cfm?tipo=v&idc=#BD.IdDistribuidor#&id=#Idcp#">#numberformat(BD.IdDistribuidor,"999999")#</a>

</cfif>

</td></tr>

<tr>

<td class="txtb"><a href="#session.sitea.elurlgeneral#vpedidosclientes.cfm?tipo=v&idc=#busqueda.IdDistribuidor#&id=#Idcp#">#numberformat(busqueda.IdDistribuidor,"999999")#</a></td></tr>

</cfif>

<tr>

<td class="txtb"><a href="#session.sitea.elurlgeneral#vpedidosclientes.cfm?tipo=v&idc=#busqueda.IdCliente#&id=#Idcp#">#numberformat(busqueda.IdCliente,"999999")#</a></td></tr>

select IdDistribuidor,Distribuidor from Cliente where Idcliente = '#busqueda.IdDistribuidor#'

</cfquery>

<tr>

<a href="#session.sitea.elurlgeneral#vpedidosclientes.cfm?tipo=v&idc=#busqueda.IdDistribuidor#&id=#Idcp#">#numberformat(busqueda.IdDistribuidor,"999999")#</a>

</cfif>

</td></tr>

<tr>

<a href="#session.sitea.elurlgeneral#vpedidosclientes.cfm?tipo=v&idc=#BD.IdDistribuidor#&id=#Idcp#">#numberformat(BD.IdDistribuidor,"999999")#</a>

</cfif>

</td></tr>

<tr>

<td class="txtb"><a href="#session.sitea.elurlgeneral#vpedidosclientes.cfm?tipo=v&idc=#busqueda.IdDistribuidor#&id=#Idcp#">#numberformat(busqueda.IdDistribuidor,"999999")#</a></td></tr>

select IdDistribuidor,Distribuidor from Cliente where Idcliente = '#BD.IdDistribuidor#'

</cfquery>

<tr>

<a href="#session.sitea.elurlgeneral#vpedidosclientes.cfm?tipo=v&idc=#BD.IdDistribuidor#&id=#Idcp#">#numberformat(BD.IdDistribuidor,"999999")#</a>

</cfif>

</td></tr>

<tr>

<a href="#session.sitea.elurlgeneral#vpedidosclientes.cfm?tipo=v&idc=#BDM.IdDistribuidor#&id=#Idcp#">#numberformat(BDM.IdDistribuidor,"999999")#</a>

</cfif>

</td></tr>

<tr>

<td class="txtb"><a href="#session.sitea.elurlgeneral#vpedidosclientes.cfm?tipo=v&idc=#BD.IdDistribuidor#&id=#Idcp#">#numberformat(BD.IdDistribuidor,"999999")#</a></td></tr>

</cfif>

<tr>

<td class="txtb"><a href="#session.sitea.elurlgeneral#vpedidosclientes.cfm?tipo=v&idc=#busqueda.IdDistribuidor#&id=#Idcp#">#numberformat(busqueda.IdDistribuidor,"999999")#</a></td></tr>

</cfif>

</table>

#DECategoria# #Categoria#<br>

select Publicidad from publicidad where Tipo = 1 and IdPublicidad='#busqueda.idgiro#' and ididioma=#session.sitea.ididioma#

</cfquery>

</cfif>

#DEGiro# <cfif busqueda.idgiro neq 0>#PGiroq.Publicidad#</cfif><br>

select Publicidad from publicidad where Tipo = 2 and IdPublicidad='#busqueda.idmedio#' and ididioma=#session.sitea.ididioma#

</cfquery>

</cfif>

#DEMedio# <cfif busqueda.idmedio neq 0>#Pmedioq.Publicidad#</cfif><br>

select Publicidad from publicidad where Tipo = 3 and IdPublicidad='#busqueda.idempleados#' and ididioma=#session.sitea.ididioma#

</cfquery>

</cfif>

#DETamano# <cfif busqueda.idempleados neq 0>#PTamanoq.Publicidad#</cfif><br>

</td></tr>

</table>

</td>

<a href="#session.sitea.elurlgeneral#vpedidosclientes.cfm?tipo=v&idc=#Idcliente#&id=#idcp#&idcp=#idcp#">#btConsultar#</a><br>

<a href="#session.sitea.elurlgeneral#vclientesdism.cfm?tipo=m&idc=#Idcliente#&id=#idcp#">#btModificar#</a><br>

<a href="#session.sitea.elurlgeneral#vclientescbusqueda.cfm?idcp=#session.user.idcliente#&parte=2&dato=&busca=Todos&coti=1">#btCotizaciones#</a><br>

select Idcliente from pedidom where Idcliente = '#Idcliente#'

</cfquery>

select Idcliente from cotizacionm where Idcliente = '#Idcliente#' or iddistribuidor = '#Idcliente#'

</cfquery>

<A href="javascript:pregunta('#Idcliente#','#idcp#','#dato#')">#btBorrar#</a><br>

</cfif>

</td>

</tr>

</cfoutput>

<cfoutput>#conde# - #cona# #de# #numregs# ||

<a href="#session.sitea.elurlgeneral#vclientesbusqueda.cfm?parte=#parte#&busca=#busca#&dato=#dato#&conde=#confina#&idcp=#idcp#

<CFIF parte eq 4>&ppais=#ppais#&pestado=#pestado#&pgiro=#pgiro#&ptamano=#ptamano#&pmedio=#pmedio#&pcategoria=#pcategoria#&tiempo=#tiempo#</CFIF>

<CFIF parte eq 22>&txtdistribuidor=#txtdistribuidor#&txtvendedor=#txtvendedor#</CFIF>"><< #anterior#</a>

</cfif>

<a href="#session.sitea.elurlgeneral#vclientesbusqueda.cfm?parte=#parte#&busca=#busca#&dato=#dato#&conde=#confins#&idcp=#idcp#

<CFIF parte eq 4>&ppais=#ppais#&pestado=#pestado#&pgiro=#pgiro#&ptamano=#ptamano#&pmedio=#pmedio#&pcategoria=#pcategoria#&tiempo=#tiempo#</CFIF>

<CFIF parte eq 22>&txtdistribuidor=#txtdistribuidor#&txtvendedor=#txtvendedor#</CFIF>">#siguiente# >></a>

</cfif>

</td></tr></cfoutput>

</table>

<div align="left" class="subtitles"><cfoutput>#nohay#</cfoutput></div>

</td></tr>

</table>

</td></tr>

</cfif>

</td></tr>

</table>

vbuscasitep_mani.cfm

</cfif>

</cfif>

</cfif>

</cfif>

<cfset mani_querybucape= mani_querybucape & "and (pm.Fecha >= '#dato# 00:00:00' and pm.Fecha <= '#dato1# 23:59:59') ">

</cfif>

</cfif>

<cfset mani_querybucaco= mani_querybucaco & "and (cm.FechaCotizacion >= '#dato# 00:00:00' and cm.FechaCotizacion <= '#dato1# 23:59:59') ">

</cfif>

</cfif>

<cfset mani_querybusca2= mani_querybusca2 & "and (c.fecharegistro >= '#dato# 00:00:00' and c.fecharegistro <= '#dato1# 23:59:59') ">

</cfif>

</cfif>

</cfif>

</cfif>

<cfset mani_querybusca3 = "and (pm.Fecha >= '#dato# 00:00:00' and pm.Fecha <= '#dato1# 23:59:59') ">

<cfset mani_querybusca3 = "and (cm.FechaCotizacion >= '#dato# 00:00:00' and cm.FechaCotizacion <= '#dato1# 23:59:59') ">

<cfset mani_querybusca3 = "and (c.FechaRegistro >= '#dato# 00:00:00' and c.FechaRegistro <= '#dato1# 23:59:59') ">

</cfif>

<!---<cfset new="#dato#">

<cfset new_id="">

<cfset new_id1="">

<cfif len(new) lt 6>

<cfset new_id = '00000'&new>

<cfset new_id1 = right(new_id,6)>

<cfelse>

<cfset new_id1 = new>

</cfif>--->

<cfset mani_querybusca3 = "and c.IdCliente = '#Right("000000"&Trim(dato),6)#' ">

</cfif>

<cfset mani_querybusca3 = "and (pm.Fecha >= '#dato# 00:00:00' and pm.Fecha <= '#dato# 23:59:59') ">

<cfset mani_querybusca3 = "and (cm.FechaCotizacion >= '#dato# 00:00:00' and cm.FechaCotizacion <= '#dato# 23:59:59') ">

<cfset mani_querybusca3 = "and (c.FechaRegistro >= '#dato# 00:00:00' and c.FechaRegistro <= '#dato# 23:59:59') ">

</cfif>

</cfif>

</cfif>

</cfif>

</cfif>

<!--- <cfdump var="#form#">

</cfif>

</cfif>

</cfif>

</cfif>

</cfif>

</cfif>

</cfif>

</cfif>

</cfif>

</cfif>

<cfset mani_querybusca3 = mani_querybusca3 & "pm.Fecha >= '#dato# 00:00:00' and pm.Fecha <= '#dato1# 23:59:59' ">

<cfset mani_querybusca3 = mani_querybusca3 & "pm.Fecha >= '#dato# 00:00:00' and pm.Fecha <= '#dato# 23:59:59' ">

</cfif>

<cfset mani_querybusca3 = mani_querybusca3 & "cm.FechaCotizacion >= '#dato# 00:00:00' and cm.FechaCotizacion <= '#dato1# 23:59:59' ">

<cfset mani_querybusca3 = mani_querybusca3 & "cm.FechaCotizacion >= '#dato# 00:00:00' and cm.FechaCotizacion <= '#dato# 23:59:59' ">

</cfif>

<cfset mani_querybusca3 = mani_querybusca3 & "c.FechaRegistro >= '#dato# 00:00:00' and c.FechaRegistro <= '#dato1# 23:59:59' ">

<cfset mani_querybusca3 = mani_querybusca3 & "c.FechaRegistro >= '#dato# 00:00:00' and c.FechaRegistro <= '#dato# 23:59:59' ">

</cfif>

</cfif>

</cfif>

</cfif>

</cfif>

</cfif>

includes/2/datacliente.cfm

select descripcion,clase,secuencia

from textos

where ididioma=#session.sitea.ididioma# and template=#template#

order by clase,secuencia

</cfquery>

</cfloop>

</cfoutput>

</cfif>

</cfif>

<cfif isdefined("session.sitea.clientsearchquery")>

#replace(myquery,"''","'","all")#

</cfquery>

<cfoutput>#myquery#</cfoutput>

<ul>

<li>

<tr>

#lbcliente# <b>#Replace(numberformat(IdCliente,"999999"),"#myqueryword#","<font color='red'>#myqueryword#</font>","one")#</b>

#lbcliente# <b>#numberformat(IdCliente,"999999")#</b>

</cfif>

</td>

#lbempresa# #Replace(RazonSocial & " " & Paterno & " " & Materno,"#myqueryword#","<font color='red'>#myqueryword#</font>","one")#

#lbempresa# #RazonSocial# #Paterno# #Materno#

</cfif>

#lbempresa# #Replace(RazonSocial,"#myqueryword#","<font color='red'>#myqueryword#</font>","one")#

#lbempresa# #RazonSocial#

</cfif>

</td>

#lbpais# #Pais#, #Estado#

</td>

<tr>

<a href="#session.sitea.elurlgeneral#vpedidosclientes.cfm?tipo=v&idc=#clientsresult.IdCliente#&id=#Idcp#">#numberformat(clientsresult.IdCliente,"999999")#</a>

<a href="#session.sitea.elurlgeneral#vpedidosclientes.cfm?tipo=v&idc=#clientsresult.IdDistribuidor#&id=#Idcp#">#numberformat(clientsresult.IdDistribuidor,"999999")#</a>

</cfif>

</td>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<a href="#session.sitea.elurlgeneral#vpedidosclientes.cfm?tipo=v&idc=#clientsresult.IdDistribuidor#&id=#Idcp#">#numberformat(clientsresult.IdDistribuidor,"999999")#</a>

</cfif>

</td>

</tr>

<tr>

<a href="#session.sitea.elurlgeneral#vpedidosclientes.cfm?tipo=v&idc=#clientsresult.IdCliente#&id=#Idcp#">#numberformat(clientsresult.IdCliente,"999999")#</a>

</td>

</tr>

<tr>

</tr>

select Idcliente from Vendedor where Idcliente = '#clientsresult.IdCliente#'

</cfquery>

select IdDistribuidor,Distribuidor from Cliente where Idcliente = '#clientsresult.IdDistribuidor#'

</cfquery>

<tr>

<a href="#session.sitea.elurlgeneral#vpedidosclientes.cfm?tipo=v&idc=#clientsresult.IdCliente#&id=#Idcp#">#numberformat(clientsresult.IdCliente,"999999")#</a>

<a href="#session.sitea.elurlgeneral#vpedidosclientes.cfm?tipo=v&idc=#clientsresult.IdDistribuidor#&id=#Idcp#">#numberformat(clientsresult.IdDistribuidor,"999999")#</a>

</cfif>

</td>

</tr>

<tr>

</tr>

<tr>

<a href="#session.sitea.elurlgeneral#vpedidosclientes.cfm?tipo=v&idc=#BD.IdDistribuidor#&id=#Idcp#">#numberformat(BD.IdDistribuidor,"999999")#</a>

</cfif>

</td>

</tr>

<tr>

<a href="#session.sitea.elurlgeneral#vpedidosclientes.cfm?tipo=v&idc=#clientsresult.IdDistribuidor#&id=#Idcp#">#numberformat(clientsresult.IdDistribuidor,"999999")#</a>

</td>

</tr>

</cfif>

<tr>

<a href="#session.sitea.elurlgeneral#vpedidosclientes.cfm?tipo=v&idc=#clientsresult.IdCliente#&id=#Idcp#">#numberformat(clientsresult.IdCliente,"999999")#</a>

</td>

</tr>

select IdDistribuidor,Distribuidor from Cliente where Idcliente = '#clientsresult.IdDistribuidor#'

</cfquery>

<tr>

<a href="#session.sitea.elurlgeneral#vpedidosclientes.cfm?tipo=v&idc=#clientsresult.IdDistribuidor#&id=#Idcp#">#numberformat(clientsresult.IdDistribuidor,"999999")#</a>

</cfif>

</td>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<a href="#session.sitea.elurlgeneral#vpedidosclientes.cfm?tipo=v&idc=#BD.IdDistribuidor#&id=#Idcp#">#numberformat(BD.IdDistribuidor,"999999")#</a>

</cfif>

</td>

</tr>

<tr>

<a href="#session.sitea.elurlgeneral#vpedidosclientes.cfm?tipo=v&idc=#clientsresult.IdDistribuidor#&id=#Idcp#">#numberformat(clientsresult.IdDistribuidor,"999999")#</a>

</td>

</tr>

<tr>

</tr>

select IdDistribuidor,Distribuidor from Cliente where Idcliente = '#BD.IdDistribuidor#'

</cfquery>

<tr>

<a href="#session.sitea.elurlgeneral#vpedidosclientes.cfm?tipo=v&idc=#BD.IdDistribuidor#&id=#Idcp#">#numberformat(BD.IdDistribuidor,"999999")#</a>

</cfif>

</td>

</tr>

<tr>

</tr>

<tr>

<a href="#session.sitea.elurlgeneral#vpedidosclientes.cfm?tipo=v&idc=#BDM.IdDistribuidor#&id=#Idcp#">#numberformat(BDM.IdDistribuidor,"999999")#</a>

</cfif>

</td>

</tr>

<tr>

<a href="#session.sitea.elurlgeneral#vpedidosclientes.cfm?tipo=v&idc=#BD.IdDistribuidor#&id=#Idcp#">#numberformat(BD.IdDistribuidor,"999999")#</a>

</td>

</tr>

</cfif>

<tr>

<a href="#session.sitea.elurlgeneral#vpedidosclientes.cfm?tipo=v&idc=#clientsresult.IdDistribuidor#&id=#Idcp#">#numberformat(clientsresult.IdDistribuidor,"999999")#</a>

</td>

</tr>

</cfif>

</table>

</td>

</tr>

<tr>

#DEFecha# #mes#/#day(FechaRegistro)#/#year(FechaRegistro)#

#DEFecha# #day(FechaRegistro)#/#mes#/#year(FechaRegistro)#

</cfif>

</td>

#lbnombre# #Replace(Contacto,"#myqueryword#","<font color='red'>#myqueryword#</font>","one")#

#lbnombre# #Contacto#

</cfif>

</td>

#lbtel# #Replace(Telefono1,"#myqueryword#","<font color='red'>#myqueryword#</font>","one")#

#lbtel# #Telefono1#

</cfif>

</td>

<td>

</td>

</tr>

<tr>

#lbCategoria# #Categoria#

</td>

#lbemail# #Replace(Email,"#myqueryword#","<font color='red'>#myqueryword#</font>","one")#

#lbemail# #Email#

</cfif>

</td>

#lbtel2# #Replace(Telefono2,"#myqueryword#","<font color='red'>#myqueryword#</font>","one")#

#lbtel2# #Telefono2#

</cfif>

</td>

<td>

</td>

</tr>

<tr>

</td>

</td>

#lbfax# #Replace(Fax,"#myqueryword#","<font color='red'>#myqueryword#</font>","one")#

#lbfax# #Fax#

</cfif>

</td>

<td>

</td>

</tr>

<tr>

</td>

</tr>

</cfif>

</table>

</li>

</cfoutput>

</ul>

<ul>

<li class="last"><cfoutput>#ERRMSG#</cfoutput></li>

</ul>

</cfif>

<ul>

<li class="last"><cfoutput>#ERRMSG#</cfoutput></li>

</ul>

</cfif>

</body>

</html>

The purposr of this code is below.

To display search assist at the time of entering the search text inside the textbox and press enter.

there is a textbox named "ya3" in the page (vclientesbusquedap.cfm).. so, if you types the texts and press ENTER means, it'll call the script and call the search assist display page(datacliente.cfm) and show the search assist values at the bottom of the search textbox.

the search assist display page, calls the query from the session value. Actually the query is there in the page(vbuscasitep_mani.cfm).

I've changed the colour of the text into BLUE to identify easily the traversal of values in the pages.

Please check the pages and help me to solve this simple issue.

Many thanks.

Report · Jul 21, 2011

The only way

'#Right("000000"&Trim(dato),6)#'

can return '000000' is if dato has no value or contains only zero(s).

As I stated in previous a message, you need to output the actual value to the document, at the point the value is being used to construct your sql, to confirm this..i.e. <cfoutput>dato: #dato#</cfoutput>

If it is true that dato has no value then you need to look upstream of this point and trace where dato is being affected.

I can load your code in my CF editor tomorrow and assist further at about 0630 hrs USA central time. Now I have to make my commute...

.

Report · Jul 21, 2011

Thanks my friend.. I'll try to sort it out. If not, i'll wait for your comments in the morning tomorrow.

Report · Jul 22, 2011

You are never too new to learn how to troubleshoot. A method I use frequently is to look at my data using the cfdump tag.

For your situation, put this tag

right before the block of code you posted.

Then, as you get to your if/else logic, do this sort of thing to see what is happening.

yes

no

</cfif>

Report · Jul 22, 2011

the variable "dato" is in query page. Its not in the display page. So, how can i see the cfdump value of "dato" variable? I put cfdump in query page and tried to view that. But i cant.

Report · Jul 22, 2011

If you can do this:

You can do this:

If necessary, add an abort attribute.

Report · Jul 22, 2011

I found that the value is not coming.. and gone backward to find why the value is not passing... I found the line,

which is replacing the exact value in the generated query. so, its replacing the value which is inside % % in the query into the exact value. so that our right() function is not working and that was replaced.

I need to do the replacement only for the particular condition. so i cant able to change the line by default in the code.

This datacliente.cfm page is loading by using the jsuggest jquery. There i need to send the condition value and to check that in the datacliente page or need to send the replaced value with leading zeros.

am trying for that to send two query strings in the jsuggest function. If anyone knows about that, please help me.

thanks for the answers guys.

Report · Jul 22, 2011

Kudos for finding where the value changes and the condition that causes it to change.

If you identified this:

There i need to send the condition value and to check that in the datacliente page or need to send the replaced value with leading zeros.

I don't see why you have to do this:

am trying for that to send two query strings in the jsuggest function

Can't you simply send one of the two strings, depending on your conditional logic?

Report · Jul 22, 2011

Yes. I also thought the same and at the time of keyup in the searchbox, i converted the entered text into 6digit leading zero text and assigned that in a hidden filed. I assigned the converted value into a hidden field, because of the jsuggest function is loading at the time of page loads. I cant able to make the function to load in some other condition. Also, i mentioned in the jsuggest function to work, only if there is more than 3 chars in the searchbox and with ENTER, it'll start to work. But the ENTER and 3chars condition was written in the jsuggest plug in by default. Now the problem is, if i pass the hidden field value which is having the modified searchbox value with leading zeros, its not passing the data into the dataclient page. If it passes, the value will assign automatically for the dato, and the query will work perfectly

some hints from my page..

<input type="Text" id="ya3" name="dato3" size="30" maxlength="60" tabindex="1" value="" onkeyup="assignparam()"> <font size="1">(oprima enter)</font>

<input type="hidden" id="q" name="qryval" value=""> // my hidden field

My script,

function getUrlVars()

{

var vars = [], hash;

var hashes = window.location.href.slice(window.location.href.indexOf('?') + 1).split('&');

for(var i = 0; i < hashes.length; i++)

{

hash = hashes.split('=');

vars.push(hash[0]);

vars[hash[0]] = hash[1];

}

return vars;

}

function pad(number, length) {

var str = '' + number;

while (str.length < length) {

str = '0' + str;

}

return str;

}

//this will trigger at the time of keyup in the searchbox

function assignparam()

{

var opt = getUrlVars()["busca"];

var data = document.getElementById('ya3').value;

var q='';

if(opt == "No") // this is the condition that i need to check to add leading zeros

{

document.getElementById('q').value = pad(data,6); // assigning the searchbox value with leading zeros in a hidden field

}

else

{

document.getElementById('q').value = data; // assigning the searchbox value as it is, in a hidden field

}

//jsuggest plug in

$(document).ready(function(){

$("#ya3").jSuggest({

minchar: 3,

url: "includes/2/datacliente.cfm",

type: "GET",

data: "qryval", // passing the hidden field data into the jsuggest plug in. This will transfers the data into query string with the mentioned url.

autoChange: false,

loadingText: "Loading ..."

});

The underlined one is the problem.. the hidden value is not passing.

Report · Jul 22, 2011

put <cfabort> on the next line