tag:blogger.com,1999:blog-9941798075259201012024-08-29T12:15:46.844-07:00Desenvolvendo SitesEste blog foi criado para eu deixar algumas dicas de desenvolvimento e postar algumas novidades no mercado, mas está se tornando um banco de ajuda para coisas que não são fáceis de serem encontradas na rede.Robson Cabralhttp://www.blogger.com/profile/14716259356085316643noreply@blogger.comBlogger98125tag:blogger.com,1999:blog-994179807525920101.post-54935014462310165292015-12-06T17:55:00.001-08:002015-12-06T17:55:58.927-08:00Carreira - Softplan : Softplan<a href="https://www.softplan.com.br/carreira/">Carreira - Softplan : Softplan</a>Robson Cabralhttp://www.blogger.com/profile/14716259356085316643noreply@blogger.com0tag:blogger.com,1999:blog-994179807525920101.post-16399432825114538922014-07-31T07:21:00.002-07:002014-07-31T07:21:59.925-07:00Montando um MAC ou HMAC (Hash)Neste post eu vou montar de uma maneira bem simples como criar um MAC (<span style="background-color: white; color: #545454; font-family: arial, sans-serif; font-size: x-small; line-height: 18.200000762939453px;">Message Authentication Code</span>).<br /> No ColdFusion existe a função&nbsp;Hash que gera uma chave de segurança e é super simples de usar.<br /> <br /> Ele converte o tamanho de uma variável do tipo string em uma string de tamanho fixo que pode ser usada como "<span style="background-color: white; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; line-height: 16.079999923706055px;">fingerprint</span>" ou identificação unica para a string original.<br /> <br /> Sintax:&nbsp;<span style="background-color: #f0f7fe; color: #333333; font-family: 'Courier New', Courier, monospace; font-size: 11px;">Hash(string [, </span><i style="color: #333333; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px;">algorithm</i><span style="background-color: #f0f7fe; color: #333333; font-family: 'Courier New', Courier, monospace; font-size: 11px;"> [, </span><i style="color: #333333; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px;">encoding</i><span style="background-color: #f0f7fe; color: #333333; font-family: 'Courier New', Courier, monospace; font-size: 11px;"> ]])</span><br /> <br /> Apenas o primeiro parâmetro é necessário, por padrão o parâmetro "algoritnm" é o MD5 e no terceiro parâmetro você pode usar por exemplo o "UTF-8", mas apenas se for necessário porque na maioria das vezes esse parâmetro não é usado.<br /> <br /> Então vamos lá... Vou montar abaixo as linhas que vão gerar o hash.<br /> <br /> &lt;cfset variables.timestamp = "<span style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 13px;">1406572727952</span>" /&gt;<br /> &lt;cfset variables.usuario_ID = "<span style="color: #222222; font-family: arial, sans-serif; font-size: x-small;"><span style="background-color: white;">12345678910</span></span>" /&gt;<br /> &lt;cfset variables.values = "#variables.timestamp##variables.usuario_ID#" /&gt;<br /> <br /> Nas variáveis acima estou usando o timestamp em milisegundos, o id do usuário e estou juntando os dois numa variável que será usada para gerar o hash.<br /> <br /> &lt;cfset variables.secret = "teste_123" /&gt;<br /> <br /> Agora na variável acima eu estou criando uma senha secreta que será adicionada a minha variável values na hora da montagem do hash.<br /> <br /> &lt;cfset variables.mac = Lcase(Hash("#variables.values##variables.secret#", "MD5")) /&gt;<br /> <br /> Finalmente nosso Hash foi criado sem problema algum.<br /> <br /> No código abaixo eu montei um exemplo usando um formulário para testes. Estou comparando um MAC recebido com um gerado para comparar se eles são válidos.<br /> <br /> <span style="background-color: yellow; color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&lt;!--- Fontes de consulta:&nbsp;</span><br /> <span style="background-color: yellow; color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;"><br /></span> <span style="background-color: yellow; color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">http://httpd.apache.org/docs/2.2/misc/password_encryptions.html</span><br /> <span style="background-color: yellow; color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;"><br /></span> <span style="background-color: yellow; color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">https://groups.google.com/forum/#!topic/railo/xKZaNOiymOw</span><br /> <span style="background-color: yellow; color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;"><br /></span> <span style="background-color: yellow; color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">http://www.bennadel.com/blog/2428-change-in-coldfusion-date-gettime-method-in-coldfusion-10.htm</span><br /> <span style="background-color: yellow; color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;"><br /></span> <span style="background-color: yellow; color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">http://stackoverflow.com/questions/1614196/how-can-i-get-an-md5-hash-in-coldfusion</span><br /> <span style="background-color: yellow; color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;"><br /></span> <span style="background-color: yellow; color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">http://wiki.its.iastate.edu/plugins/viewsource/viewpagesrc.action?pageId=1914</span><br /> <span style="background-color: yellow; color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;"><br /></span> <span style="background-color: yellow; color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">Converte milisegundos em data</span><br /> <span style="background-color: yellow; color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">http://www.cflib.org/index.cfm?event=page.udfbyid&amp;udfid=1211</span><br /> <span style="background-color: yellow; color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;"><br /></span> <span style="background-color: yellow; color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">---&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&lt;cfparam name="form.timestamp" type="any" default="" /&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&lt;cfparam name="form.usuario" type="any" default="" /&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&lt;cfparam name="form.MACRec" type="any" default="" /&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;"><br /></span> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&lt;html xmlns="http://www.w3.org/1999/xhtml"&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &lt;head&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &lt;meta http-equiv="Content-Type" content="text/html; charset=utf-8"&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &lt;title&gt;Untitled Document&lt;/title&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &lt;style&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;"><span class="Apple-tab-span" style="white-space: pre;"> </span>.cor {background-color:#FC9;}</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;/style&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &lt;/head&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp;&nbsp;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &lt;body&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; <span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;cfoutput&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &lt;div id="divFrm" style="width:100%;"&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &lt;form name="frmMAC" id="frmMAC" action="teste_MD5.cfm" method="post"&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; <span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;table align="left" border="0" celspace="0" celpadding="2"&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;tr&gt;&lt;td&gt;TimeStamp:&lt;/td&gt;&lt;td&gt;&lt;input type="text" name="timestamp" id="timestamp" value="#form.timestamp#" /&gt;&lt;/td&gt;&lt;/tr&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt;&lt;td&gt;Usuário:&lt;/td&gt;&lt;td&gt;&lt;input type="text" name="usuario" id="usuario" value="#form.usuario#" /&gt;&lt;/td&gt;&lt;/tr&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt;&lt;td&gt;MAC:&lt;/td&gt;&lt;td&gt;&lt;input type="text" name="MACRec" id="MACRec" value="#form.MACRec#" /&gt;&lt;/td&gt;&lt;/tr&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt;&lt;td colspan="2" align="center"&gt;&lt;input type="submit" name="enviar" id="enviar" value="Enviar" /&gt;&lt;/td&gt;&lt;/tr&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/table&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &lt;/form&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &lt;/cfoutput&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &lt;cfif IsDefined("form.MACRec") AND form.MACRec NEQ ""&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; <span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;div id="resultado" style="width:100%;"&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;cfif form.timestamp EQ ""&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="Apple-tab-span" style="white-space: pre;"> </span>Você deve informar o valor do timestamp.</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;cfexit /&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;cfelseif form.usuario EQ ""&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="Apple-tab-span" style="white-space: pre;"> </span>Você deve informar o usuário.</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;cfexit /&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;cfelse&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;cfset variables.values = "#form.timestamp##form.usuario#" /&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;cfset variables.secret = "teste_123" /&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;cfset variables.mac = Lcase(Hash("#variables.values##variables.secret#", "MD5")) /&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;cfset variables.Datetimestamp = dateAdd("s", form.timestamp/1000, "january 1 1970 00:00:00") /&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;cfset variables.Diferenca = DateDiff("s",variables.Datetimestamp,GetHTTPTimeString(Now())) /&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;cfoutput&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;table align="left" border="1" celspace="0" celpadding="2"&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr class="cor"&gt;&lt;td&gt;TimeStamp:&lt;/td&gt;&lt;td&gt;#form.timestamp#&lt;/td&gt;&lt;/tr&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt;&lt;td&gt;Usuário:&lt;/td&gt;&lt;td&gt;#form.usuario#&lt;/td&gt;&lt;/tr&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr class="cor"&gt;&lt;td&gt;&lt;b&gt;MAC Recebido:&lt;/b&gt;&lt;/td&gt;&lt;td&gt;&lt;b&gt;#LCase(form.MACRec)#&lt;/b&gt;&lt;/td&gt;&lt;/tr&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt;&lt;td&gt;&lt;b&gt;MAC Gerado:&lt;/b&gt;&lt;/td&gt;&lt;td&gt;&lt;b&gt;#variables.mac#&lt;/b&gt;&lt;/td&gt;&lt;/tr&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt;&lt;td&gt;Data do TimeStamp Informado:&lt;/td&gt;&lt;td&gt;#DateFormat(variables.Datetimestamp,"dd/mm/yyyy")# #TimeFormat(variables.Datetimestamp,"HH:mm:ss.lll")#&lt;/td&gt;&lt;/tr&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt;&lt;td&gt;Diferença entre as datas em segundos:&lt;/td&gt;&lt;td&gt;#variables.Diferenca#&lt;/td&gt;&lt;/tr&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/table&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/cfoutput&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;"><span class="Apple-tab-span" style="white-space: pre;"> </span>&lt;/cfif&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &nbsp; &nbsp; &lt;/cfif&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&nbsp; &nbsp; &lt;/body&gt;</span><br /> <span style="color: #666666; font-family: Courier New, Courier, monospace; font-size: x-small;">&lt;/html&gt;</span><br /> <br />Robson Cabralhttp://www.blogger.com/profile/14716259356085316643noreply@blogger.com0tag:blogger.com,1999:blog-994179807525920101.post-23769846082339050672014-06-25T11:26:00.001-07:002014-06-25T11:27:22.205-07:00Efeito usando animate do jquery com o easing<p><b>Fala galera...!!!</b></p> <p>Eu precisei replicar um efeito aprovado num layout da empresa esses dias e tive dificuldades por não ter feito algo parecido antes e os exemplos que encontrei não me davam uma ideia clara.</p> <p>Então eu fui mexendo daqui e dali e consegui o efeito usando a biblioteca easing do jquery.</p> <p>Vamos então iniciar baixando o <a href="http://jquery.com/download/">jquery</a> e a biblioteca <a href="http://gsgd.co.uk/sandbox/jquery/easing/">Easing</a>.</p> <p>Agora vamos ao código:</p> <p>Cria um arquivo chamado teste.htm e copia o código abaixo para ele.<br/>Depois cria uma pasta js dentro da pasta onde você criou o arquivo e dentro dela coloque o jquery e a biblioteca.</p> <textarea rows="43" cols="100"> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="pt-br" lang="pt-br"> <head> <title>Teste de efeito</title> <script type="text/javascript" src="js/jquery.js"></script> <script type="text/javascript" src="js/jquery.easing.1.3.js"></script> <script type="text/javascript"> $(function() { var theSquare1 = $('#obj1'); var theSquare2 = $('#obj2'); theSquare2.click( theSquare2.animate( { width:"0px"} ,1000 ,'easeOutCirc',function() { alert('Clicou no obj 2');}); ); theSquare1.click( theSquare2.animate( { width:"100px"} ,1000 ,'easeOutCirc',function() { alert('Clicou no obj 1');}); ); }); </script> <body> <div id='principal' style='width:100px;height:100px;overflow:hidden;'> <div id='obj1' style='width:100px;height:100px;overflow:hidden;background-color:#b5d650;'></div> <div id='obj2' style='width:100px;height:100px;overflow:hidden;background-color:#15386d;top:-100px;left:0px;position:relative;'></div> </div> </body> </html> </textarea> <p>É simples realizar o efeito, você pode trocar os efeitos, colocar por exemplo theSquare2.toggle(function(){theSquare2.show();});</p> <p>Enfim...!!! É isso aí, eu não encontrei exemplos legais na net para realizar o efeito que eu queria mas fui juntando o que fui entendendo e montei esse. Espero conseguir ajudar muita gente.</p> <p>um grande abraço, comentem e deixem as suas opiniões que elas são super importantes e até o próximo post.</p>Robson Cabralhttp://www.blogger.com/profile/14716259356085316643noreply@blogger.com0tag:blogger.com,1999:blog-994179807525920101.post-40278629837483852792014-06-11T18:11:00.000-07:002014-06-11T18:11:59.776-07:00Upload Múltiplo com Jquery - PlUpload<div style="margin-botton: 10px;"><p><b>Olá galera.</b></p></div> <div style="margin-botton: 10px;"> <p>Neste post vou mostrar para vocês uma forma simples de realizar uploads múltiplos usando o jquery e o plug-in plupload.</p> <p>Primeiro vamos baixar o plugin <a href="http://www.plupload.com/download/">clicando aqui</a></p> </div> <div style="margin-botton: 10px;"> <p>Agora vamos baixar o <a href="http://blog.jquery.com/2011/11/21/jquery-1-7-1-released/">JQuery</a></p> <p>Eu vou realizar o exemplo no ColdFusion porque é mais prático mas a lógica é a mesma para todos.</p> <p>Vamos começar então.</p> </div> <div style="margin-botton: 10px;"> <ul><li>Crie uma pasta chamada teste na raíz do seu site</li> <li>Agora crie uma pasta chamada JS e uma pasta chamada Upload</li> <li>Dentro da pasta JS você vai colocar seu arquivo jquery e a pasta do PlUpload</li> </ul> </div> <div style="margin-botton: 10px;"> <p>Vamos criar dentro da pasta teste nosso arquivo index.cfm com o código abaixo:</p> </div> <textarea cols="50" rows="10"><html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <style type="text/css"> @import url(js/plupload/jquery.plupload.queue/css/jquery.plupload.queue.css); </style> <script type="text/javascript" src="js/jquery-1.7.1.min.js"></script> <script type="text/javascript" src="js/plupload/plupload.full.js"></script> <script type="text/javascript" src="js/plupload/jquery.plupload.queue/jquery.plupload.queue.js"></script> <script type="text/javascript" src="js/plupload/i18n/pt-br.js"></script> </head> <script type="text/javascript"> /*********************************************************************************** * Para exemplos, documentação e detales o link é: http://www.plupload.com/examples * ***********************************************************************************/ //Configurando o plupload $(function() { $("#uploader").pluploadQueue({ runtimes : 'html5,flash,silverlight,html4', //Aqui faz a chamada do componente para realizar o upload url : 'upload.cfc?method=upload', //Tamanho máximo do arquivo max_file_size : '1024mb', //Quebra o arquivo em partes para realizar o upload mas rápido multipart: true, multipart_params: { 'rdn': Math.random(), }, //Nome do arquivo file_data_name: 'file', multiple_queues: true, //Filtro de extenções que você deseja permissão para upload filters : [ {title : "Image files", extensions : "jpg,gif,png"}, {title : "PDF files", extensions : "pdf"}, {title : "ZIP files", extensions : "zip"} ], // Sort files sortable: true, // Enable ability to drag'n'drop files onto the widget (currently only HTML5 supports that) dragdrop: true, // Views to activate views: { list: true, thumbs: true, // Show thumbs active: 'thumbs' }, // Flash settings flash_swf_url : '/plupload/js/Moxie.swf', // Silverlight settings silverlight_xap_url : '/plupload/js/Moxie.xap' }); }); </script> <body> <div id="uploader"> <p> Aguarde, carregando.</p> </div> </body> </html> </textarea> <div style="margin-botton: 10px;"> <p>Agora vamos criar o componente que vai realizar a parte de upload. Vamos criar um componente dentro da pasta teste junto com o index.cfm chamado de upload.cfc e copiar o código abaixo.</p> </div> <textarea cols="50" rows="10"><cfcomponent> <cffunction name="upload" access="remote" returntype="struct" returnformat="json" output="false"> <cfscript> var uploadDir = expandPath('.') & '/uploads/'; // should be a temp directory that you clear periodically to flush orphaned files var uploadFile = uploadDir & arguments.NAME; var response = {'result' = arguments.NAME, 'id' = 0}; var result = {}; // if chunked append chunk number to filename for reassembly if (structKeyExists(arguments, 'CHUNKS')){ uploadFile = uploadFile & '.' & arguments.CHUNK; response.id = arguments.CHUNK; } </cfscript> <!--- save file data from multi-part form.FILE ---> <cffile action="upload" result="result" filefield="FILE" destination="#uploadFile#" nameconflict="overwrite"/> <!---cfftp action="putFile" server="HOST" username="USER" password="PASS" localfile=#uploadFile# remotefile=#arguments.NAME# ---> <cfscript> // Example: you can return uploaded file data to client response['size'] = result.fileSize; response['type'] = result.contentType; response['saved'] = result.fileWasSaved; // reassemble chunked file if (structKeyExists(arguments, 'CHUNKS') && arguments.CHUNK + 1 == arguments.CHUNKS){ try { var uploadFile = uploadDir & arguments.NAME; // file name for reassembled file - if using a temp directory then this should be the final output path/file if (fileExists(uploadFile)){ fileDelete(uploadFile); // delete otherwise append will add chunks to an existing file } var tempFile = fileOpen(uploadFile,'append'); for (var i = 0; i < arguments.CHUNKS; i++) { var chunk = fileReadBinary('#uploadDir#/#arguments.NAME#.#i#'); fileDelete('#uploadDir#/#arguments.NAME#.#i#'); fileWrite(tempFile, chunk); } fileClose(tempFile); } catch(any err){ // clean up chunks for incomplete upload var d = directoryList(uploadDir,false,'name'); if (arrayLen(d) != 0){ for (var i = 1; i <= arrayLen(d); i++){ if (listFirst(d[i]) == arguments.NAME && val(listLast(d[i])) != 0){ fileDelete('#uploadDir##d[i]#'); } } } // you could add more error handling and return info from err response = {'error' = {'code' = 500, 'message' = 'Internal Server Error'}, 'id' = 0}; } } return response; </cfscript> </cffunction> </cfcomponent> </textarea> <div style="margin-botton: 10px;"> <p>Pronto. Agora é só testar e ser feliz. Obs.: Não se esqueça de dar permissão de 777 na pasta upload que é onde vão ficar os arquivos.</p> </div> <p>Seu diretório de teste deve ficar assim:</p> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhIUl9em6_D5HXpFNI4a7lkem7G0MMcouGyxVIuhSJA1DxlG-mosDfnb5AM6uTWnAE6-wFOCObBI6z0vUbSDSrBWK380KmDcm1myjQB1NYkZsVrE_7zqw3FSD-oiE_M3ZhVRSjJwL66Bc7S/s1600/tela_teste.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhIUl9em6_D5HXpFNI4a7lkem7G0MMcouGyxVIuhSJA1DxlG-mosDfnb5AM6uTWnAE6-wFOCObBI6z0vUbSDSrBWK380KmDcm1myjQB1NYkZsVrE_7zqw3FSD-oiE_M3ZhVRSjJwL66Bc7S/s320/tela_teste.jpg" /></a></div>Robson Cabralhttp://www.blogger.com/profile/14716259356085316643noreply@blogger.com0tag:blogger.com,1999:blog-994179807525920101.post-89629112227506055072014-05-27T08:19:00.000-07:002014-05-27T08:19:25.410-07:00Imprimindo direto na impressora do cliente em CF<p>Olá pessoal, um amigo (Cicero Vieira) compartilhou uma experiência num grupo de estudos que eu tenho certeza de que vai ajudar muita gente e que simplesmente você não encontra tão fácil numa pesquisa, então resolvi postar aqui a solução compartilhada por ele.</p> <p><blockquote> "<i>Eu coloquei uma dúvida aqui sobre como mandar direto informação para lpt1: e achei uma solução, pena que só funcione no internet explorer e tem que mexer em algumas configurações de segurança para permitir o controle activex <br /><br /><br /> Vou compartilhar ela aqui para quem sabe se algém precisar, para usar uma matricial, para imprimir, contra-cheque, nota fiscal , impressora de cheque etc etc, no meu caso resolveu para um cliente que estou desenvolvendo um sistema de locadora online que comprou uma impressora Térmica Wind não fiscal da Elgin. O lance é criar um txt na máquina cliente com os comandos que se deseja e depois rodar um arquivo bat para mandar ele para a porta desejada lpt1: com1: etc etc <br /><br /><br /> 1 - Colocar esse Javascript na página que deseja que faça a impressão <br /><br /> ... <br /><br /> <SCRIPT LANGUAGE="JavaScript"> <br /> function WriteToFile() <br /> { <br /> var fso = new ActiveXObject("Scripting.FileSystemObject"); <br /> var s = fso.CreateTextFile("C:\\ticket.txt", true); <br /> s.WriteLine(' bla bla bla '); <br /> s.WriteLine("________________________________________________"); <br /> <cfset texto="Ticket "&id&" Data "&dateformat(dettck.datamov,"dd/mm/yyyy")> <br /> <cfoutput>s.WriteLine('#texto#');</cfoutput> <br /> s.Close(); <br /> var WshShell = new ActiveXObject("WScript.Shell"); <br /> var oExec = WshShell.Exec("c:\\print.bat"); <br /> } <br /> </SCRIPT> <br /> </head> <br /> <body> <br /><br /> ... <br /><br /><br /> 2-Arquivo print.bat <br /> type c:\\ticket.txt > lpt1: <br /><br /><br /> 3-Botao para realizar a impressão <br /> <form onSubmit="WriteToFile(this)"> <br /> <input name="botao" type="button" onClick="WriteToFile()" value="Imprimir ticket" /> <br /> </form> <br /><br /><br /> Espero que a contribuição fique ai para ajudar quem necessite resolver um problema tipo o que tive. <br /><br /><br /> Abraços a todos ae (Mas abraços a distancia pros carinhas ai que tão até querendo usar saia para pegar as vagas das programadoras Cold,como eu disse é um CF Wars hehehe tem gente até querendo usar saia para pegar emprego) <br /><br /><br /> <b><u>Não funcionou no coldfusion 10</u></b></i>" </blockquote></p> <p>Interessante a solução. Mas como meu amigo citou, com ActiveX só funciona no IE. <br /> Uma saída "multiplataforma" seria criando um Applet assinado. Pode fazer isso utilizando leitor de impressão digital que funciona bem. </p> <p>Meu amigo Rafael Bandeiras deu a seguinte dica:<br /> Da para fazer uma adaptação a esse script BAT e vincular ele ao cfexecute. Se o CF estiver na mesma rede e tiver um servidor de impressão funcionará. Uma outra solução é trabalhar com ActionScript para acessar a porta LPT1 e disparar a a ação direto no cliente. </p>Robson Cabralhttp://www.blogger.com/profile/14716259356085316643noreply@blogger.com0tag:blogger.com,1999:blog-994179807525920101.post-70389743595218352522014-05-15T07:42:00.002-07:002014-05-15T07:45:29.174-07:00Sobre a instalação do ColdFusion<p><b>Sobre a instalação do ColdFusion <i>(Aqui eu falo direto da versão 8)</i></b></p> <p>O ColdFusion tem uma poderosa e flexível instalação e atualização de processos. O processo de instalação do ColdFusion inclui as seguintes fases:</p> <ol><li>Plano de instalação para determinar suas opções de instalação, configuração e atualização.</li> <li>Rodar o ColdFusion installer.</li> <li>Implantar e configurar o ColdFusion em seu servidor de aplicações J2EE (Apenas configuração J2EE)</li> </ol> <p>O processo de instalação do ColdFusion suporta os seguintes cenários:</p> <p><b>New Installation</b> Instala o ColdFusion em uma máquina que não tenha ainda o ColdFusion instalado.</p> <p><b>Upgrade installation</b> Você pode atualizar de uma instalação anterior do ColdFusion sem conflitos. O instalador preserva as configurações existentes e instala em um novo diretório, automaticamente acessando portas que não vão entrar em conflito com a instalação existente.</p> <p>Você pode instalar o ColdFusion em qualquer uma das seguintes configurações:</p> <p><b>Server configuration</b> Permite que você instale uma instância do ColdFusion com um servidor J2EE incorporado. Esta configuração mais se assemelha a versão base do ColdFusion MX e outras versões anteriores do ColdFusion MX, como ColdFusion 5 e ColdFusion 4.5. Isto era conhecido anteriormente como a configuração autônoma. Para obter informações sobre como instalar a configuração de servidor, consulte <a href="http://livedocs.adobe.com/coldfusion/8/htmldocs/installserver_01.html#1112861">instalando a configuração do servidor</a>.</p> <p><b>Multiserver configuration (Enterprise Edition only)</b> Instala o JRun e automaticamente implanta o ColdFusion em uma instância separada do servidor JRun. Essa configuração oferece suporte a criação de instância de servidor e implantação do ColdFusion no ColdFusion Administrator e permite que você gerencie as implantações de ColdFusion em vários servidores JRun. Para obter informações sobre como instalar a configuração multiservidor, consulte <a href="http://livedocs.adobe.com/coldfusion/8/htmldocs/installmultiserver_1.html#109411">instalando a configuração multiservidor</a>.</p> <p><b>J2EE configuration (Enterprise Edition only)</b> Permite a você implantar o ColdFusion como um aplicativo Java em execução em um servidor de aplicativo Java 2 Enterprise Edition (J2EE), usando a licença combinada do JRun ou um servidor J2EE de terceiros, como o WebSphere da IBM ou BEA WebLogic. Quando você usar a configuração de J2EE, você pode implantar ColdFusion várias vezes em um único computador. Para obter informações sobre como instalar a configuração do J2EE, consulte <a href="http://livedocs.adobe.com/coldfusion/8/htmldocs/installj2ee_01.html#109411">instalando a configuração de J2EE</a>.</p>Robson Cabralhttp://www.blogger.com/profile/14716259356085316643noreply@blogger.com0tag:blogger.com,1999:blog-994179807525920101.post-61953427353945531732014-05-01T11:17:00.001-07:002014-05-01T11:17:22.208-07:00Criando Componentes em CF<div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">Para criar componentes em CF é muito simples. Vamos levar em conta que estamos na pasta raiz do sistema. Então para não misturar os arquivos vamos criar uma pasta chamada de controle dentro da pasta raiz e criar nosso componente dentro dela.</span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">Um arquivo de componente em CF é identificado pela extensão </span><span style="font-family: Times New Roman, serif;"><b>.cfc</b></span><span style="font-family: Times New Roman, serif;"> e vou dar o nome do componente que vamos criar de </span><span style="font-family: Times New Roman, serif;"><b>Documentos.cfc</b></span></div> <br /> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">No </span><span style="font-family: Times New Roman, serif;"><b>DreamWeaver</b></span><span style="font-family: Times New Roman, serif;"> você pode criar um novo componente da mesma forma que faz para criar uma nova página em ASP, como mostra a figura abaixo:</span></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiltJY3_kaWTuROtBCeeFPz-6ZAzZ6-gldueCtdy25_D-_FQv4hR0-SaLJhLLcomu39MqBWuNRSKF7zqWwa21Or6RKxmnLQapDdaq831GhppFDnhpT6fWjBYFThwQAiAFHLQeLVtimdyfD7/s1600/DW_NovoCFC.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiltJY3_kaWTuROtBCeeFPz-6ZAzZ6-gldueCtdy25_D-_FQv4hR0-SaLJhLLcomu39MqBWuNRSKF7zqWwa21Or6RKxmnLQapDdaq831GhppFDnhpT6fWjBYFThwQAiAFHLQeLVtimdyfD7/s1600/DW_NovoCFC.jpg" height="241" width="320" /></a></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">Para criar nosso componente temos que começar nosso arquivo com a tag </span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">&lt;cfcomponent&gt;&lt;/cfcomponent&gt;</span></span></span><span style="font-family: Times New Roman, serif;"> No código abaixo eu chamo um serviço </span><span style="font-family: Times New Roman, serif;"><b>COBOL</b></span><span style="font-family: Times New Roman, serif;"> nas funções criadas dentro do componente.</span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;cfcomponent&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;!--- Trás a quantidade e lista de documentos ---&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cffunction name="listarDocsRecebidosPorUsuario" access="public" returntype="any"&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;!--- Argumentos passados para a função. Deve seguir a mesma ordem ---&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1.25cm; margin-top: 0.21cm; text-indent: 1.25cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;cfargument name="codusuario" type="string" required="yes"&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfargument name="data_1" type="string" required="yes"&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfargument name="data_2" type="string" required="yes"&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfargument name="tipo" type="string" required="yes" default="QTD"&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfargument name="flaglido" type="string" required="yes" default=""&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;!--- Monta a estrutura de parâmetros ---&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfset parametros_serv = StructNew()&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> </span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfset StructInsert(parametros_serv,"usupesquisa",arguments.codusuario)&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfset StructInsert(parametros_serv,"databusca",'')&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfset StructInsert(parametros_serv,"dataini",LSDateFormat(arguments.data_1,'yyyy-mm-dd'))&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfset StructInsert(parametros_serv,"datafim",LSDateFormat(arguments.data_2,'yyyy-mm-dd'))&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfset StructInsert(parametros_serv,"flaglido",arguments.flaglido)&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> </span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfif arguments.tipo EQ "QTD"&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfset StructInsert(parametros_serv,"tiposolic","07")&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfelse&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfset StructInsert(parametros_serv,"tiposolic","08")&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;/cfif&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> </span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfset StructInsert(parametros_serv,"paginaqtd",0)&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfset StructInsert(parametros_serv,"paginaatual",1)&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> </span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfset srvDocumentos = CreateObject("component","controle.leitorServicos")&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> </span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfset retornoServico = srvDocumentos.chamarServico(application.srv_regControladocumento, variables.parametros_serv)&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> </span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfreturn retornoServico&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;/cffunction&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;!--- Marca o documento como lido ---&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cffunction name="marcarLidoDoc" access="public" returntype="any"&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfargument name="id" type="string" required="yes"&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> </span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfset parametros_serv = StructNew()&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> </span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfset StructInsert(parametros_serv,"id",arguments.id)&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfset StructInsert(parametros_serv,"tiposolic",9)&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfset StructInsert(parametros_serv,"paginaqtd",0)&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfset StructInsert(parametros_serv,"paginaatual",1)&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> </span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfset srvDocumentos = CreateObject("component","controle.Documentos")&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> </span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfset retornoServico = srvDocumentos.chamarServico(application.srv_regControladocumento, variables.parametros_serv)&gt; </span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> </span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfreturn retornoServico&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;/cffunction&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;!--- Pega o Resultado do serviço COBOL informado em XML ---&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;cffunction access="public" name="chamarServico" returntype="any"&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfargument name="nomeservico" type="string" required="yes"&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfargument name="parametros" type="struct" required="yes"&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfargument name="tiposerv" type="string" required="no" default="XML"&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cftry&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;!--- Buscando retorno do Serviço (XML) ---&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfhttp url="#application.host_cobol##Trim(arguments.nomeservico)#.exe" method="post" charset="iso-8859-1"&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfloop list="#StructKeyList(arguments.parametros,',')#" delimiters="," index="i"&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfhttpparam name="#LCase(i)#" value="#StructFind(arguments.parametros,i)#" type="formfield"&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;/cfloop&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;/cfhttp&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> </span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;!---&lt;cfdump var="#cfhttp.FileContent#"&gt;---&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> </span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfif isXmlDoc(cfhttp.FileContent)&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfset oXml = cfhttp.FileContent&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfelse&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfset oXml = xmlParse(cfhttp.FileContent)&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;/cfif&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> </span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfcatch type="any"&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> Erro na chamada de requisição ao servidor de dados &lt;br/&gt;&lt;br/&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfoutput&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> Erro CB: #cfhttp.FileContent# &lt;br/&gt;&lt;br/&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> Erro CF: (#arguments.nomeservico#). #cfcatch.Detail# - #cfcatch.Message# &lt;br/&gt;&lt;br/&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;/cfoutput&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfabort&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;/cfcatch&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;/cftry&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> </span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cftry&gt; </span></span> </div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;!--- Conversao ---&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfif arguments.tiposerv EQ "XML"&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfreturn xmlParaQuery(oXml)&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfelse&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfreturn xmlParaQuerySite(oXml)&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;/cfif&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> </span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfcatch type="any"&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> Erro na _CORE na conversão dos dados vindos do servidor . &lt;cfoutput&gt;#cfcatch.Detail# - #cfcatch.Message#&lt;/cfoutput&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfabort&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;/cfcatch&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;/cftry&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1.25cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;/cffunction&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;/cfcomponent&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> </div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">Na linha: </span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">&lt;cfset StructInsert(parametros_serv,"id",arguments.id)&gt;</span></span></span><span style="font-family: Times New Roman, serif;"> o parâmetro “</span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;"><i><u><b>id</b></u></i></span></span></span><span style="font-family: Times New Roman, serif;">” é o nome do campo que o serviço </span><span style="font-family: Times New Roman, serif;"><b>COBOL</b></span><span style="font-family: Times New Roman, serif;"> espera receber, este campo não precisa ter o mesmo nome do campo na tabela do banco. O parâmetro “</span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;"><i><u><b>arguments.id</b></u></i></span></span></span><span style="font-family: Times New Roman, serif;">” é o valor que estou jogando para este campo e inserindo na estrutura chamada “</span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;"><i><u><b>parametros_serv</b></u></i></span></span></span><span style="font-family: Times New Roman, serif;">”</span></div> Robson Cabralhttp://www.blogger.com/profile/14716259356085316643noreply@blogger.com0tag:blogger.com,1999:blog-994179807525920101.post-29746319372073776582014-05-01T11:07:00.001-07:002014-05-01T11:07:13.878-07:00Manipulando Solicitações de HTTP em CF<div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;"><span lang="pt-PT">A</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">tag</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;"><span lang="pt-PT">&lt;</span></span></span></span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;"><span lang="pt-PT">CFHTTP&gt;</span></span></span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">é uma ferramenta</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">de uso geral</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">para a criação</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">e manipulação de</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">solicitações</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">dos resultados HTTP retornados. Ele permite você</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">gerar</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">tipos de solicitação</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">padrão</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">HTTP.</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">Você pode usar</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">as tags</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;"><span lang="pt-PT">&lt;</span></span></span></span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;"><span lang="pt-PT">cfhttpparam&gt;</span></span></span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">incorporadas para</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">especificar</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">cabeçalhos de solicitação e</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">conteúdo do corpo</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">.</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;"><span lang="pt-PT">Quando</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">ColdFusion</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">recebe uma resposta</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">a um pedido</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">CFHTTP</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">, pode </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">colocar o</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">corpo da resposta</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">(se houver)</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">em um arquivo ou</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">a variável de cadeia</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">cfhttp.FileContent</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">.</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;"><span lang="pt-PT">Se</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">o corpo do texto</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">está estruturado</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">como um</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">conjunto de resultados,</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> o </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">ColdFusion</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">pode colocar o</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">texto do corpo</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">em</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> um </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">objeto de consulta</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">. </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">Você também pode</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">acessar os valores</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">de todos os cabeçalhos</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">retornados e</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">especificar como lidar com</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">status de erro e</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">redirecionamentos</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">, </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">e especificar</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">um tempo limite</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">para evitar</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">pedidos de</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">enforcamento.</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;"><span lang="pt-PT">O protocolo</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">HTTP</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">é</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">a espinha dorsal da</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">World Wide Web e</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">é usado</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">para cada transação</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">web.</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">Porque a</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">tag</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;"><span lang="pt-PT">&lt;</span></span></span></span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;"><span lang="pt-PT">CFHTTP&gt;</span></span></span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">pode gerar</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">a maioria dos tipos</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">de solicitações,</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">que</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">proporciona uma flexibilidade significativa</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">. </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">Possíveis usos</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">incluem:</span></span></div> <ul> <li><div class="western" style="margin-bottom: 0cm;"> <span style="font-family: Times New Roman, serif;"><span lang="pt-PT">Interação com</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">web sites dinâmicos</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">e serviços que</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">não estão disponíveis como</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">serviços</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">web.</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">(Use</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">a tag</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;"><span lang="pt-PT">&lt;</span></span></span></span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;"><span lang="pt-PT">cfinvoke&gt;</span></span></span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">para acessar serviços</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">web</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">SOAP.</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">)</span></span></div> </li> <li><div class="western" style="margin-bottom: 0cm;"> <span style="font-family: Times New Roman, serif;"><span lang="pt-PT">Obter o conteúdo</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">de uma página</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">HTML</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">ou outro arquivo</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">como uma imagem</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">em um</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">servidor</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">web</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">para uso em</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">sua página</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">CFML</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">ou armazenamento</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">em um arquivo.</span></span></div> </li> <li><div class="western" style="margin-bottom: 0cm;"> <span style="font-family: Times New Roman, serif;"><span lang="pt-PT">Enviar um pedido de</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">seguro para um</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">servidor especificando</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">o protocolo</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">https</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">no atributo</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">url.</span></span></div> </li> <li><div class="western" style="margin-bottom: 0cm;"> <span style="font-family: Times New Roman, serif;"><span lang="pt-PT">Utilizando o método</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">POST</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">para enviar</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">um post</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">estilo</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">multipart /</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">form-data</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">a qualquer</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">URL</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">que pode lidar com</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">esses dados</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">e retornar resultados</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">, inclusive os executáveis </span></span><span style="font-family: Arial Unicode MS, sans-serif;"><span lang="pt-PT">​​</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">CGI</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">ou mesmo páginas</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">outros</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">ColdFusion.</span></span></div> </li> <li><div class="western" style="margin-bottom: 0cm;"> <span style="font-family: Times New Roman, serif;"><span lang="pt-PT">Usando o método</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">PUT</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">para</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">upload de arquivos para</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">um servidor que</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">não aceita solicitações</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">FTP.</span></span></div> </li> </ul> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;"><span lang="pt-PT">Esta</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">tag</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">pode, e</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">para pedidos</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">POST</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">e</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">PUT</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">deve,</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">ter um corpo</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">que contém marcas</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">cfhttpparam</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">. </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">Se essa marca</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">tem tags</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;"><span lang="pt-PT">&lt;</span></span></span></span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;"><span lang="pt-PT">cfhttpparam&gt;</span></span></span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">, </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">ele deve ter uma tag</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;"><span lang="pt-PT">&lt;/</span></span></span></span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;"><span lang="pt-PT"> </span></span></span></span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;"><span lang="pt-PT">CFHTTP</span></span></span></span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;"><span lang="pt-PT">&gt;</span></span></span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> no </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">final.</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;"><span lang="pt-PT">Para usar</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">HTTPS</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">com a tag</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;"><span lang="pt-PT">&lt;</span></span></span></span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;"><span lang="pt-PT">CFHTTP&gt;</span></span></span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">, </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">talvez você precise</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">importar manualmente</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">o certificado</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">para cada servidor</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">web</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">para o keystore</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">do</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">JRE</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">que o</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">ColdFusion usa</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">. </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">Este procedimento não deve</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">ser necessária se o</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">certificado é assinado</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">(emitida</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">) </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">por uma autoridade</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">que o</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">JSSE</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">(</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">Java Secure </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">Sockets</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">Extension</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">) reconhece </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">(por exemplo,</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">Verisign</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">), isto é, se a autoridade </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">de assinatura é</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">no</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">cacerts</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">já. No entanto, você</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">pode precisar usar</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">o procedimento</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">se você estiver</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">emitindo</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">SSL</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">(secure sockets layer</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">) </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">certificados de</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">si mesmo.</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;"><span lang="pt-PT">Importar manualmente</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">um certificado:</span></span></div> <ol> <li><div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm;"> <span style="font-family: Times New Roman, serif;"><span lang="pt-PT">Ir para uma página</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">no servidor</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">SSL</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">em questão.</span></span></div> </li> <li><div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm;"> <span style="font-family: Times New Roman, serif;"><span lang="pt-PT">Dê um duplo</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">clique no</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">ícone de cadeado.</span></span></div> </li> <li><div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm;"> <span style="font-family: Times New Roman, serif;">Clique na guia Detalhes.</span></div> </li> <li><div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm;"> <span style="font-family: Times New Roman, serif;"><span lang="pt-PT">Clique em Copiar para</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">Arquivo.</span></span></div> </li> <li><div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm;"> <span style="font-family: Times New Roman, serif;">Selecione a opção base64 e salve o arquivo.</span></div> </li> <li><div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm;"> <span style="font-family: Times New Roman, serif;">Copie o arquivo CER em C: \ ColdFusion8 \ runtime \ jre \ lib \ security (ou qualquer JRE ColdFusion está usando).</span></div> </li> <li><div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm;"> <span style="font-family: Times New Roman, serif;"><span lang="pt-PT">Execute o seguinte comando</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">no mesmo diretório</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">(</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">keytool.exe </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">está localizada em</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">C: \</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">CFusionMX7</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">\ runtime</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">\ jre \</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"> </span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT">bin):</span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"><br /></span></span><span style="font-family: Times New Roman, serif;"><span lang="pt-PT"><i>keytool -import -keystore cacerts -alias giveUniqueName -file filename.cer</i></span></span></div> </li> </ol> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;"><span lang="pt-PT">Exemplo:</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">&lt;!--- Este exemplo exibe</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT"> </span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">as informações fornecidas</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT"> </span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">pelo</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT"> </span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">Designer</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT"> </span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">&amp;</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT"> </span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">Developer Center</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT"> </span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">XML feed, </span></span></span><span style="color: #1f86ff;"><u><a href="http://www.adobe.com/desdev/resources/_resources.xml"><span style="font-size: x-small;"><span lang="pt-PT">http://www.adobe.com/desdev/resources/_resources.xml</span></span></a></u></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">Ver http://www.adobe.com/desdev/articles/xml_resource_feed.html para mais informações sobre</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT"> </span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">este assunto. ---&gt;</span></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">&lt;!--- Definir o endereço de</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT"> </span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">URL. ---&gt;</span></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">&lt;cfset urlAddress="http://www..com/de</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">sdev/resources/_resources.xml"&gt;</span></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">&lt;!--- Use</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT"> </span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">a tag</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT"> &lt;</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">CFHTTP&gt;</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT"> </span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">para obter</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT"> </span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">o conteúdo do arquivo</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT"> </span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">representado por</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT"> </span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">urladdress</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">. </span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">Note que</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT"> </span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">/</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">&gt;, não é fim da tag, ele </span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">finaliza</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT"> </span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">esta tag. ---&gt;</span></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">&lt;cfhttp url="#urladdress#" method="GET" resolv</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">eurl="Yes" throwOnError="Yes"/&gt;</span></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">&lt;!--- </span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">Analisar o XML</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT"> </span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">e saída de</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT"> </span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">uma lista de recursos</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">.</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT"> ---&gt;</span></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">&lt;cfset xmlDoc </span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">= XmlParse(CFHTTP.FileContent)&gt;</span></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">&lt;!--- </span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">Obter a matriz</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT"> </span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">de elementos</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT"> </span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">de recursos, o</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT"> </span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">xmlChildren</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT"> </span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">do</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT"> </span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">XmlRoot</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">.</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT"> ---&gt;</span></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">&lt;cfset resour</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">ces=xmlDoc.xmlroot.xmlChildren&gt;</span></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">&lt;cfset nu</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">mresources=ArrayLen(resources)&gt;</span></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">&lt;cfloop index="i</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">" from="1" to="#numresources#"&gt;</span></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">&lt;cfset </span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">item=resources[i]&gt;</span></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">&lt;cfoutput&gt;</span></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1.5cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">&lt;strong&gt;&lt;a href=#item.url.xmltext#&gt;#item.title.xmltext#&lt;/a&gt;</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">&lt;/strong&gt;&lt;br&gt;</span></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1.5cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">&lt;strong&gt;</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">Autor&lt;/strong&gt;&amp;nbsp;&amp;nbsp;#item.author.xmltext#&lt;br&gt;</span></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1.5cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">&lt;strong&gt;</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">Aplica-se a</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT"> </span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">estes produtos&lt;/strong&gt;&lt;br&gt;</span></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1.5cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">&lt;cfloop index="i" from="4" to="#arraylen(item</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">.xmlChildren)#"&gt;</span></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1.5cm; margin-top: 0.21cm; text-indent: 1.25cm;"> <span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">#item.xmlChil</span></span></span><span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">dren[i].xmlAttributes.Name#&lt;br&gt;</span></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1.5cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">&lt;/cfloop&gt;&lt;br&gt;</span></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">&lt;/cfoutput&gt;</span></span></span></div> <br /> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"><span lang="pt-PT">&lt;/cfloop&gt;</span></span></span></div> Robson Cabralhttp://www.blogger.com/profile/14716259356085316643noreply@blogger.com0tag:blogger.com,1999:blog-994179807525920101.post-25397875822397335702014-04-30T08:09:00.000-07:002014-04-30T08:09:03.178-07:00Vetores e Arrays em CF e em ASP<div class="western" style="margin-bottom: 0cm; text-indent: 1.25cm;"> <span style="font-family: Times New Roman, serif;">No CF um vetor é uma variável normal.</span></div> <div class="western" style="margin-bottom: 0cm; text-indent: 1.25cm;"> <br /> </div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;h1&gt;List Loops&lt;/h1&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <br /> </div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;h2&gt;List Loop 1&lt;/h2&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;cfset numlist="1,2,3,4,5"&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;cfloop index="num" list="#numlist#"&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"> <span style="font-size: x-small;">&lt;cfoutput&gt;#num#&lt;/cfoutput&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;/cfloop&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <br /> </div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;h2&gt;List Loop 2&lt;/h2&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;cfset beatles="paul john ringo george"&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;ul&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;cfloop index="beatle" list="#beatles#" delimiters=" "&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"> <span style="font-size: x-small;">&lt;li&gt;&lt;cfoutput&gt;#beatle#&lt;/cfoutput&gt;&lt;/li&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;/cfloop&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;/ul&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <br /> </div> <div class="western" style="margin-bottom: 0cm; text-indent: 1.25cm;"> <span style="font-family: Times New Roman, serif;">Abaixo a lista de funções CF específicar para vetores e arrays</span></div> <div class="western" style="margin-bottom: 0cm; text-indent: 1.25cm;"> <br /> </div> <dl> <dd> <table border="1" bordercolor="#ffffff" cellpadding="7" cellspacing="0" style="width: 539px;"> <colgroup><col width="234"></col> <col width="275"></col> </colgroup><tbody> <tr valign="TOP"> <td width="234"> <div align="CENTER"> <span style="color: black;"><span style="font-family: Times New Roman, serif;"><b>Função</b></span></span></div> </td> <td width="275"> <div align="CENTER"> <span style="color: black;"><span style="font-family: Times New Roman, serif;"><b>descrição</b></span></span></div> </td> </tr> <tr valign="TOP"> <td width="234"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">ListLen()</span></span><br /> </td> <td width="275"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">Determines the number of elements in a list.</span></span><br /> </td> </tr> <tr valign="TOP"> <td width="234"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">ListFind()</span></span><br /> </td> <td width="275"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">Returns the index of the first list element in which a specified value occurs. Case-sensitive.</span></span><br /> </td> </tr> <tr valign="TOP"> <td width="234"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">ListFindNoCase()</span></span><br /> </td> <td width="275"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">Determines the index of the first list element in which a specified value occurs. Case-insensitive.</span></span><br /> </td> </tr> <tr valign="TOP"> <td width="234"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">ListContains()</span></span><br /> </td> <td width="275"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">Returns the index of the first list element that contains a specified substring. Case-sensitive.</span></span><br /> </td> </tr> <tr valign="TOP"> <td width="234"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">ListContainsNoCase()</span></span><br /> </td> <td width="275"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">Returns the index of the first list element that contains a specified substring. Case-insensitive.</span></span><br /> </td> </tr> <tr valign="TOP"> <td width="234"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">ListValueCount()</span></span><br /> </td> <td width="275"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">Counts instances of a specified value in a list. The search is case-sensitive.</span></span><br /> </td> </tr> <tr valign="TOP"> <td width="234"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">ListValueCountNoCase()</span></span><br /> </td> <td width="275"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">Counts instances of a specified value in a list. The search is case-insensitive.</span></span><br /> </td> </tr> <tr valign="TOP"> <td width="234"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">ListDeleteAt()</span></span><br /> </td> <td width="275"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">Returns a copy of the list without the specified element.</span></span><br /> </td> </tr> <tr valign="TOP"> <td width="234"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">ListGetAt()</span></span><br /> </td> <td width="275"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">Gets a list element at a specified position.</span></span><br /> </td> </tr> <tr valign="TOP"> <td width="234"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">ListSetAt()</span></span><br /> </td> <td width="275"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">Replaces the contents of a list element.</span></span><br /> </td> </tr> <tr valign="TOP"> <td width="234"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">ListSort()</span></span><br /> </td> <td width="275"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">Sorts list elements according to a sort type and sort order.</span></span><br /> </td> </tr> <tr valign="TOP"> <td width="234"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">ListAppend()</span></span><br /> </td> <td width="275"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">Appends a list or element to a list.</span></span><br /> </td> </tr> <tr valign="TOP"> <td width="234"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">ListPrepend()</span></span><br /> </td> <td width="275"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">Inserts an element at the beginning of a list.</span></span><br /> </td> </tr> <tr valign="TOP"> <td width="234"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">ListInsertAt()</span></span><br /> </td> <td width="275"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">Inserts an element in a list.</span></span><br /> </td> </tr> <tr valign="TOP"> <td width="234"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">ListFirst()</span></span><br /> </td> <td width="275"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">Gets the first element of a list.</span></span><br /> </td> </tr> <tr valign="TOP"> <td width="234"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">ListRest()</span></span><br /> </td> <td width="275"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">Gets a list, without its first element.</span></span><br /> </td> </tr> <tr valign="TOP"> <td width="234"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">ListLast()</span></span><br /> </td> <td width="275"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">Gets the last element of a list.</span></span><br /> </td> </tr> <tr valign="TOP"> <td width="234"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">ArrayToList()</span></span><br /> </td> <td width="275"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">Converts a one-dimensional array to a list.</span></span><br /> </td> </tr> <tr valign="TOP"> <td width="234"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">ListToArray()</span></span><br /> </td> <td width="275"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">Converts a list to a one-dimensional array.</span></span><br /> </td> </tr> <tr valign="TOP"> <td width="234"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">ReplaceList()</span></span><br /> </td> <td width="275"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">Replaces occurrences of the elements from a delimited list in a string with corresponding elements from another delimited list. The search is case-sensitive.</span></span><br /> </td> </tr> <tr valign="TOP"> <td width="234"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">ListChangeDelims()</span></span><br /> </td> <td width="275"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">Changes a list delimiter.</span></span><br /> </td> </tr> <tr valign="TOP"> <td width="234"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">ListQualify()</span></span><br /> </td> <td width="275"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">Inserts a string at the beginning and end of list elements.</span></span><br /> </td> </tr> </tbody></table> </dd></dl> <div class="western" style="margin-bottom: 0cm; text-indent: 1.25cm;"> </div> <div class="western" style="margin-bottom: 0cm; text-indent: 1.25cm;"> <span style="font-family: Times New Roman, serif;">No </span><span style="font-family: Times New Roman, serif;"><b>ASP</b></span><span style="font-family: Times New Roman, serif;"> para montar vetor podemos fazer da seguinte maneira:</span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <br /> </div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;%</span></span><span style="color: blue;"><span style="font-size: x-small;"> </span></span><span style="color: blue;"><span style="font-size: x-small;">Dim</span></span><span style="color: blue;"><span style="font-size: x-small;"> </span></span><span style="color: blue;"><span style="font-size: x-small;">MeuArray</span></span><span style="color: blue;"><span style="font-size: x-small;">(</span></span><span style="color: blue;"><span style="font-size: x-small;">3</span></span><span style="color: blue;"><span style="font-size: x-small;">)</span></span><span style="color: blue;"><span style="font-size: x-small;"><br /></span></span><span style="color: blue;"><span style="font-size: x-small;">MeuArray</span></span><span style="color: blue;"><span style="font-size: x-small;">(</span></span><span style="color: blue;"><span style="font-size: x-small;">0</span></span><span style="color: blue;"><span style="font-size: x-small;">)=</span></span><span style="color: blue;"><span style="font-size: x-small;">Date</span></span><span style="color: blue;"><span style="font-size: x-small;"><br /></span></span><span style="color: blue;"><span style="font-size: x-small;">MeuArray</span></span><span style="color: blue;"><span style="font-size: x-small;">(</span></span><span style="color: blue;"><span style="font-size: x-small;">1</span></span><span style="color: blue;"><span style="font-size: x-small;">)=</span></span><span style="color: blue;"><span style="font-size: x-small;">"Lineu Antonio de Lima Santos"</span></span><span style="color: blue;"><span style="font-size: x-small;"><br /></span></span><span style="color: blue;"><span style="font-size: x-small;">MeuArray</span></span><span style="color: blue;"><span style="font-size: x-small;">(</span></span><span style="color: blue;"><span style="font-size: x-small;">2</span></span><span style="color: blue;"><span style="font-size: x-small;">)=</span></span><span style="color: blue;"><span style="font-size: x-small;">12.45</span></span><span style="color: blue;"><span style="font-size: x-small;"><br /></span></span><span style="color: blue;"><span style="font-size: x-small;">MeuArray</span></span><span style="color: blue;"><span style="font-size: x-small;">(</span></span><span style="color: blue;"><span style="font-size: x-small;">3</span></span><span style="color: blue;"><span style="font-size: x-small;">)=</span></span><span style="color: blue;"><span style="font-size: x-small;">Now</span></span><span style="color: blue;"><span style="font-size: x-small;"><br /></span></span><span style="color: blue;"><span style="font-size: x-small;">%&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <br /> </div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> Observe que o valor armazenado em cada elemento de um array pode ser de um subtipo diferente dos demais. Outra observação importante: arrays têm que ser declarados explicitamente.</div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <br />Arrays não são limitados para uma única dimensão. Em VBScript pode-se declarar Arrays de até 60 dimensões.</div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <br /> </div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> Construindo uma matriz:</div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <br /> </div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;% Dim MeuArray(1,1)</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"> <span style="font-size: x-small;">MeuArray(0,0)= "Lineu Antonio de Lima Santos"</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"> <span style="font-size: x-small;">MeuArray(0,1)=2225240</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"> <span style="font-size: x-small;">MeuArray(1,0)= "Universidade Federal do Piauí"</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"> <span style="font-size: x-small;">MeuArray(1,1)=2172000</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">%&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <br /> </div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> Pode-se declarar um array cujo tamanho é alterado durante a interpretação do script. Para tal, basta declarar o array com Dim sem informar a quantidade de elementos. Depois deve-se utilizar a declaração ReDim para determinar o número de elementos. Caso seja necessário redimensionar o array, utiliza-se novamente a declaração ReDim. Se houver a necessidade de preservar o conteúdo do array a ser redimensionado, utiliza-se a declaração ReDim Preserve.</div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <br /> </div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">Sem Preserve &lt;BR&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"> <span style="font-size: x-small;">&lt;% Dim MeuArray()</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"> <span style="font-size: x-small;">ReDim MeuArray(1) </span></span> </div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"> <span style="font-size: x-small;">MeuArray(0)= "Lineu Antonio de Lima Santos"</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"> <span style="font-size: x-small;">MeuArray(1)=12.95 </span></span> </div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"> <span style="font-size: x-small;">ReDim MeuArray(2)</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"> <span style="font-size: x-small;">MeuArray(2)=9090 </span></span> </div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"> <span style="font-size: x-small;">%&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <br /> </div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;B&gt;Posição 0&lt;/B&gt; = &lt;%=MeuArray(0)%&gt;&lt;BR&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;B&gt;Posição 1&lt;/B&gt; = &lt;%=MeuArray(1)%&gt;&lt;BR&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;B&gt;Posição 2&lt;/B&gt; = &lt;%=MeuArray(2)%&gt;&lt;BR&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;HR&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">Com Preserve &lt;BR&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"> <span style="font-size: x-small;">&lt;% ReDim MeuArray(1) </span></span> </div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"> <span style="font-size: x-small;">MeuArray(0)= "Lineu Antonio de Lima Santos"</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"> <span style="font-size: x-small;">MeuArray(1)=12.95 </span></span> </div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"> <span style="font-size: x-small;">ReDim Preserve MeuArray(2)</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"> <span style="font-size: x-small;">MeuArray(2)=0909 </span></span> </div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"> <span style="font-size: x-small;">%&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;B&gt;Posição 0&lt;/B&gt; = &lt;%=MeuArray(0)%&gt;&lt;BR&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;B&gt;Posição 1&lt;/B&gt; = &lt;%=MeuArray(1)%&gt;&lt;BR&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;B&gt;Posição 2&lt;/B&gt; = &lt;%=MeuArray(2)%&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <br /> </div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="font-family: Times New Roman, serif;">Para correr um vetor em ASP usamos as funções LBound() e UBound().</span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <br /> </div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;script type="text/vbscript"&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">Dim food(2,3)</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">food(0,0)="Apple"</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">food(0,1)="Banana"</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">food(0,2)="Orange"</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">food(0,3)="Lemon"</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">food(1,0)="Pizza"</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">food(1,1)="Hamburger"</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">food(1,2)="Spaghetti"</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">food(1,3)="Meatloaf"</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">food(2,0)="Cake"</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">food(2,1)="Cookie"</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">food(2,2)="Icecream"</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">food(2,3)="Chocolate"</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">document.write(LBound(food,1) &amp; "&lt;br /&gt;")</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">document.write(UBound(food,1) &amp; "&lt;br /&gt;")</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">document.write(LBound(food,2) &amp; "&lt;br /&gt;")</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">document.write(UBound(food,2) &amp; "&lt;br /&gt;")</span></span></div> <br /> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;/script&gt;</span></span></div> Robson Cabralhttp://www.blogger.com/profile/14716259356085316643noreply@blogger.com0tag:blogger.com,1999:blog-994179807525920101.post-63479571644901490432014-04-30T08:03:00.001-07:002014-04-30T08:03:10.341-07:00Criando Estrutura de Dados no CF<div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">No CF para criarmos uma estrutura de dados que pode conter </span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">arrays</span></span></span><span style="font-family: Times New Roman, serif;"> e </span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">vetores</span></span></span><span style="font-family: Times New Roman, serif;">, nós usamos a função </span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">StructNew()</span></span></span><span style="font-family: Times New Roman, serif;">.</span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">Dessa forma: </span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">&lt;cfset parametros_serv = StructNew()&gt;</span></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">&lt;cfset parametros_serv.nome = #url.nome#&gt;</span></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue; font-family: 'Times New Roman', serif; font-size: x-small;">&lt;cfset parametros_serv.endereco = #variables.endereco#&gt;</span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: 'Times New Roman', serif;">Usando a tag cfdump podemos ver os detalhes:&nbsp;</span><span style="color: blue; font-family: 'Times New Roman', serif; font-size: x-small;">&lt;cfdump var="#</span><span style="color: blue; font-family: 'Times New Roman', serif; font-size: x-small;">parametros_serv</span><span style="color: blue; font-family: 'Times New Roman', serif; font-size: x-small; text-indent: 1cm;">#"&gt;</span></div> Robson Cabralhttp://www.blogger.com/profile/14716259356085316643noreply@blogger.com0tag:blogger.com,1999:blog-994179807525920101.post-18789625311656765732014-04-30T07:55:00.001-07:002014-04-30T07:55:23.654-07:00Criando Funções em CF e em ASP<div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">Em ColdFusion para criar uma função usamos a tag </span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">&lt;cffunction&gt;&lt;/cffunction&gt;</span></span></span><span style="font-family: Times New Roman, serif;">, é bastante simples de usar. Com a base de dados já pronta, e devidamente </span><span style="color: #1f86ff;"><u><a href="http://www.mxstudio.com.br/views.tutorial.php?act=view&amp;cid=11&amp;aid=522" target="_blank"><span style="font-family: Times New Roman, serif;">registrada no Administrador do ColdFusion </span></a></u></span><span style="font-family: Times New Roman, serif;">vamos construir nossas funções.</span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">O código abaixo é basicamente uma função para retornar os dados da tabela noticia e uma função para inserir dados nessa mesma tabela recebendo alguns parâmetros passados.</span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;!— Função para retorno de dados da tabela Noticia. —&gt;<br />&lt;cffunction name=”RetornaNoticia” access=”remote” returntype=”query”&gt;<br />&lt;cfquery name=”q_noticia” datasource=”lucasmarcal”&gt;<br />SELECT *<br />FROM noticia<br />ORDER BY id_noticia<br />&lt;/cfquery&gt;<br />&lt;cfreturn q_noticia&gt;<br />&lt;/cffunction&gt;<br />&lt;!— Fim da Função —&gt;</span></span></div> <div class="western" style="margin-bottom: 0.49cm; margin-left: 1cm; margin-top: 0.49cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;!— Função para Inserir dados na tabela Noticia —&gt;<br />&lt;cffunction name=”InserirNoticia” access=”remote” returntype=”boolean”&gt;<br />&lt;cfargument name=”dia” required=”yes” type=”string”&gt;<br />&lt;cfargument name=”autor” required=”yes” type=”string”&gt;<br />&lt;cfargument name=”assunto” required=”yes” type=”string”&gt;<br />&lt;cfargument name=”mensagem” required=”yes” type=”string”&gt;<br />&lt;cfquery name=”q_inserir” datasource=”lucasmarcal”&gt;<br />INSERT<br />INTO noticia<br />(<br />data,<br />autor,<br />assunto,<br />mensagem<br />)<br />VALUES<br />(<br />‘#Arguments.dia#’,<br />‘#Arguments.autor#’,<br />‘#Arguments.assunto#’,<br />‘#Arguments.mensagem#’<br />)<br />&lt;/cfquery&gt;<br />&lt;cfreturn true&gt;<br />&lt;/cffunction&gt;<br />&lt;!— Fim da Função —&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">Em </span><span style="font-family: Times New Roman, serif;"><b>ASP</b></span><span style="font-family: Times New Roman, serif;"> uma função é montada como no exemplo abaixo:</span></div> <br /> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;% @ LANGUAGE="VBSCRIPT" %&gt;<br />&lt;</span></span><span style="color: blue;"><span style="font-size: x-small;">HTML</span></span><span style="color: blue;"><span style="font-size: x-small;">&gt;<br />&lt;</span></span><span style="color: blue;"><span style="font-size: x-small;">HEAD</span></span><span style="color: blue;"><span style="font-size: x-small;">&gt;<br />&lt;TITLE&gt;Função imposto&lt;/TITLE&gt;<br />&lt;/</span></span><span style="color: blue;"><span style="font-size: x-small;">HEAD</span></span><span style="color: blue;"><span style="font-size: x-small;">&gt;<br />&lt;</span></span><span style="color: blue;"><span style="font-size: x-small;">BODY</span></span><span style="color: blue;"><span style="font-size: x-small;">&gt;<br />&lt;%Function imposto(preço_artigo)<br />preço_final=preço_artigo+preço_artigo*20/100<br />Response.Write preço_final<br />End Function%&gt;<br />Um livro de $35,00 ficará em um preço de &lt;% imposto(35) %&gt; <br />&lt;br&gt;<br />Um sapato de $60,00 terá um preço final de &lt;% imposto(60) %&gt;<br />&lt;br&gt;<br />Um </span></span><span style="color: blue;"><span style="font-size: x-small;">CD</span></span><span style="color: blue;"><span style="font-size: x-small;"> de música de $20,00 custaria &lt;% imposto(20) %&gt; <br />&lt;/</span></span><span style="color: blue;"><span style="font-size: x-small;">BODY</span></span><span style="color: blue;"><span style="font-size: x-small;">&gt;<br />&lt;/</span></span><span style="color: blue;"><span style="font-size: x-small;">HTML</span></span><span style="color: blue;"><span style="font-size: x-small;">&gt;</span></span></div> Robson Cabralhttp://www.blogger.com/profile/14716259356085316643noreply@blogger.com0tag:blogger.com,1999:blog-994179807525920101.post-34092402011051398282014-04-30T07:45:00.001-07:002014-04-30T07:45:38.716-07:00Fazendo loops em ColdFusion e em ASP<div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">Em </span><span style="font-family: Times New Roman, serif;"><b>CF</b></span><span style="font-family: Times New Roman, serif;"> para realizar um loop podemos fazer usando a tag </span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">&lt;cfoutput&gt;&lt;/cfoutput&gt;</span></span></span><span style="font-family: Times New Roman, serif;"> ou a tag </span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">&lt;cfloop&gt;&lt;/cfloop&gt;</span></span></span><span style="font-family: Times New Roman, serif;">.</span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">A tag </span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">&lt;cfoutput&gt;</span></span></span><span style="font-family: Times New Roman, serif;"> pode ser usada para apresentar dados de uma consulta, itens de uma lista, etc. Lembrando que é sempre para apresentar dados na tela.</span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">Ex.:</span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;cfquery name=”q_noticia” datasource=”lucasmarcal”&gt;<br />SELECT *<br />FROM noticia<br />ORDER BY id_noticia<br />&lt;/cfquery&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;cfoutput query=”#q_noticia#”&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="color: blue;"><span style="font-size: x-small;"> Código da notícia = #id_noticia#&lt;br /&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="color: blue;"><span style="font-size: x-small;"> Notícia &lt;textarea rows=”5” cols=”10”&gt;#descricao#&lt;/textarea&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;br /&gt;&lt;hr /&gt;&lt;br /&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;/cfoutput&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">Com a tag </span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">&lt;cfloop&gt;</span></span></span><span style="font-family: Times New Roman, serif;"> é possível fazer loops que não serão apresentados na tela mas ele pode ser usado dentro de uma tag </span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">&lt;cfoutput&gt;</span></span></span><span style="font-family: Times New Roman, serif;"> normalmente de acordo com a necessidade, o exemplo acima fica assim:</span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;cfquery name=”q_noticia” datasource=”lucasmarcal”&gt;<br />SELECT *<br />FROM noticia<br />ORDER BY id_noticia<br />&lt;/cfquery&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;cfoutput&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfloop query=”#q_noticia#”&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 2.25cm; margin-top: 0.21cm; text-indent: 0.25cm;"> <span style="color: blue;"><span style="font-size: x-small;">Código da notícia = #id_noticia#&lt;br /&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="color: blue;"><span style="font-size: x-small;"> Notícia &lt;textarea rows=”5” cols=”10”&gt;#descricao#&lt;/textarea&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;br /&gt;&lt;hr /&gt;&lt;br /&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;/cfloop&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;/cfoutput&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">Outro exemplo é:</span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;cfset lista = “1,a,2,b,3,c,4,d,5”&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;cfoutput&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;cfloop list=”#lista#” delimiters=”,” index=”i” step=”2”&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="color: blue;"><span style="font-size: x-small;"> Número #i#&lt;br /&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;/cfloop&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;/cfoutput&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">No loop acima só os números serão apresentados.</span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> As tags podem ser usadas separadas, a tag cfoutput apresenta o conteúdo de todas as variáveis que estiverem dentro dela na tela e a tag cfloop não.</div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">Em </span><span style="font-family: Times New Roman, serif;"><b>ASP</b></span><span style="font-family: Times New Roman, serif;"> usamos as funções&nbsp;</span><span style="font-family: Times New Roman, serif;"><b>FOR ou Do While ou While ou Do Until</b></span><span style="font-family: Times New Roman, serif;"> e para apresentar os dados continua da mesma forma, vou apresentar alguns exemplos abaixo.</span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">Dim Inicio, Fim</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">Inicio = 0</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">Fim = 10</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">For i = Inicio to Fim</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">call EnviaEmail("&amp;rs(i)&amp;")</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">Next</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">---------------------------------------------</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">Dim Inicio, Fim</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">Inicio = 0</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">Fim = 10</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">Do until Inicio = Fim</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">call EnviaEmail("&amp;rs("email")&amp;")</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">rs.MoveNext</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">Inicio = Inicio + 1</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">Loop</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">--------------------------------------------</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">Dim Inicio, Fim</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">Inicio = 0</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">Fim = 10</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">While not Inicio = Fim</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">call EnviaEmail("&amp;rs("email")&amp;")</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">rs.MoveNext</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">Wend</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">-------------------------------------------</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">Dim i</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">response.write "&lt;b&gt;Contando numeros de 1 a 50:&lt;/b&gt; &lt;br&gt;&lt;br&gt;"</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">For i = 1 to 50</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">response.write i &amp; "&lt;br&gt;"</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">Next</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">------------------------------------------</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">Dim x</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">x = 1</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">Do until x = 50</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">response.write x &amp; "&lt;br&gt;"</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">x = x + 1</span></span></div> <br /> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">Loop</span></span></div> Robson Cabralhttp://www.blogger.com/profile/14716259356085316643noreply@blogger.com0tag:blogger.com,1999:blog-994179807525920101.post-36666668828895999802014-04-30T07:32:00.001-07:002014-04-30T07:32:41.661-07:00Acessando Banco de Dados em CF e em ASP<div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">Para acessar o banco de dados no </span><span style="font-family: Times New Roman, serif;"><b>coldfusion</b></span><span style="font-family: Times New Roman, serif;"> é muito simples. Uma vez que no Administrador ele esteja devidamente configurado então apenas usamos a tag </span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">&lt;cfquery&gt;&lt;/cfquery&gt;</span></span></span><span style="font-family: Times New Roman, serif;"> para fazer a conexão e dentro dela usamos SQL normalmente para fazer oque desejamos. Essa tag hoje em dia não é mais usada para acessar o banco direto no código, normalmente quando há essa necessidade ela fica dentro de uma função, ou um componente fora da página.</span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;cfquery name=”q_noticia” datasource=”lucasmarcal”&gt;<br />SELECT *<br />FROM noticia<br />ORDER BY id_noticia<br />&lt;/cfquery&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">Em</span><span style="font-family: Times New Roman, serif;"><b> ASP</b></span><span style="font-family: Times New Roman, serif;"> não tem Administrador para configurar, as configurações são feitas no arquivo </span><span style="font-family: Times New Roman, serif;"><b>global.asa</b></span><span style="font-family: Times New Roman, serif;"> que eu quase não vejo em aplicações ASPs por aí pelas empresas da vida... Grandes empresas principalmente, mas a string de conexão eu sempre vejo que ela normalmente é feita num arquivo abrir.asp que fica como include no início dos arquivos e um arquivo fechar.asp fecha a conexão no fim dos arquivos.</span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"><b>1.Iniciando a conexão</b></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">Primeiro nós temos que criar o objeto de conexão para que possamos manipular o banco de dados. O nome dele é ADODB.Connection e devemos declará-lo assim no ASP:</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"><b>Set conexao = Server.CreateObject("ADODB.Connection")</b></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"><b>2.Abrindo a conexão</b></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">Agora que já temos o objeto, podemos abrir a conexão de fato e deixá-la pronta para abrir o objeto Recordset:</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"><b>conexao.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&amp;Server.MapPath("test_db.mdb")&amp;";"</b></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <strong><span style="color: blue;"><span style="font-size: x-small;">3.Iniciando a consulta</span></span></strong><span style="color: blue;"><span style="font-size: x-small;"><b><br /></b></span></span><span style="color: blue;"><span style="font-size: x-small;">Agora vamos iniciar a consulta, o objeto é ADODB.Recordset:</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <strong><span style="color: blue;"><span style="font-size: x-small;">Set add_action = Server.CreateObject ("ADODB.Recordset")</span></span></strong></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <strong><span style="color: blue;"><span style="font-size: x-small;">4.Montando a string com o SQL que vai fazer a consulta</span></span></strong></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <strong><span style="color: blue;"><span style="font-size: x-small;"><span style="font-weight: normal;">strSQL = “select * from tabela”</span></span></span></strong></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <strong><span style="color: blue;"><span style="font-size: x-small;">5.Abrindo a consulta</span></span></strong></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <strong><span style="color: blue;"><span style="font-size: x-small;"><span style="font-weight: normal;">add_action.Open(“strSQL”,</span></span></span></strong><span style="color: blue;"><span style="font-size: x-small;"><b> </b></span></span><span style="color: blue;"><span style="font-size: x-small;">conexao,3,3</span></span><strong><span style="color: blue;"><span style="font-size: x-small;"><span style="font-weight: normal;">)</span></span></span></strong></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="color: blue;"><span style="font-size: x-small;"><b>6.Fechando o RecordSet e a conexão</b></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <strong><span style="color: blue;"><span style="font-size: x-small;"><span style="font-weight: normal;">add_action.Close</span></span></span></strong></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <strong><span style="color: blue;"><span style="font-size: x-small;"><span style="font-weight: normal;">conexao.Close</span></span></span></strong></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <strong><span style="color: blue;"><span style="font-size: x-small;">7.Eliminando os Objetos criados</span></span></strong></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <strong><span style="color: blue;"><span style="font-size: x-small;"><span style="font-weight: normal;">Set add_action = Nothing</span></span></span></strong><span style="color: blue;"><span style="font-size: x-small;"><b><br /></b></span></span><strong><span style="color: blue;"><span style="font-size: x-small;"><span style="font-weight: normal;">Set conexao = Nothing</span></span></span></strong></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <br /> </div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <strong><span style="color: blue;"><span style="font-size: x-small;"><span style="font-weight: normal;">&lt;%</span></span></span></strong></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"><b>Set conexao = Server.CreateObject("ADODB.Connection")</b></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"><b>conexao.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&amp;Server.MapPath("test_db.mdb")&amp;";"</b></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <br /> </div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <strong><span style="color: blue;"><span style="font-size: x-small;">Set add_action = Server.CreateObject ("ADODB.Recordset")</span></span></strong></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <br /> </div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <strong><span style="color: blue;"><span style="font-size: x-small;">strSQL = “select * from tabela”</span></span></strong></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <br /> </div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <strong><span style="color: blue;"><span style="font-size: x-small;">add_action.Open(“strSQL”,</span></span></strong><span style="color: blue;"><span style="font-size: x-small;"> </span></span><span style="color: blue;"><span style="font-size: x-small;"><b>conexao,3,3</b></span></span><strong><span style="color: blue;"><span style="font-size: x-small;">)</span></span></strong></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <br /> </div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <strong><span style="color: blue;"><span style="font-size: x-small;">Total = add_action.RecordCount</span></span></strong></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <br /> </div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <strong><span style="color: blue;"><span style="font-size: x-small;">Response.Write(Total)</span></span></strong></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <br /> </div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <strong><span style="color: blue;"><span style="font-size: x-small;">add_action.Close</span></span></strong></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <strong><span style="color: blue;"><span style="font-size: x-small;">conexao.Close</span></span></strong></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <br /> </div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <strong><span style="color: blue;"><span style="font-size: x-small;">Set add_action = Nothing</span></span></strong><span style="color: blue;"><span style="font-size: x-small;"><br /></span></span><strong><span style="color: blue;"><span style="font-size: x-small;">Set conexao = Nothing</span></span></strong></div> <br /> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <strong><span style="color: blue;"><span style="font-size: x-small;"><span style="font-weight: normal;">%&gt;</span></span></span></strong></div> Robson Cabralhttp://www.blogger.com/profile/14716259356085316643noreply@blogger.com0tag:blogger.com,1999:blog-994179807525920101.post-79304703095783219592014-04-30T07:27:00.000-07:002014-04-30T07:27:01.822-07:00Configurando o Bando de Dados no ADM Cold Fusion<div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">Quando você instala o CF ele cria uma parte de administração onde são configurados, acessos, permissões, banco de dados, portas, etc. Para mais informações acesse: http://www.mxstudio.com.br/</span></div> <br /> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> </div> <br /> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="font-family: Times New Roman, serif;">Abra o administrador do coldfusion e indique o banco de dados que você criou.</span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="font-family: Times New Roman, serif;"><br /></span></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgEg3P3j1teXbicOJLKNtDRit0D5_-9aop-AQioAVuBD0uIZZuDZoqTJdQs59UPQRxIzKkHXOzX1KjzJWdTNZH_Dv6YLZObfOQuRJpasuReWvJUOkh7BZFEvsMFeCePStkfwiKofRYusUEq/s1600/ADM_BD.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgEg3P3j1teXbicOJLKNtDRit0D5_-9aop-AQioAVuBD0uIZZuDZoqTJdQs59UPQRxIzKkHXOzX1KjzJWdTNZH_Dv6YLZObfOQuRJpasuReWvJUOkh7BZFEvsMFeCePStkfwiKofRYusUEq/s1600/ADM_BD.jpg" height="163" width="320" /></a></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm;"> <span style="font-family: Times New Roman, serif;"><br /></span></div> Robson Cabralhttp://www.blogger.com/profile/14716259356085316643noreply@blogger.com0tag:blogger.com,1999:blog-994179807525920101.post-32137962229008473702014-04-30T07:19:00.002-07:002014-04-30T07:19:46.715-07:00Apresentando Informações na Tela em CF e em ASP<div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">Em </span><span style="font-family: Times New Roman, serif;"><b>Coldfusion</b></span><span style="font-family: Times New Roman, serif;"> para apresentarmos uma informação ou um bloco de dados na tela usamos a tag </span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">&lt;cfoutput&gt;&lt;/cfoutput&gt;</span></span></span><span style="font-family: Times New Roman, serif;">, ela é usada quando queremos apresentar algo do CF na tela.</span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;"><b>Exemplo:</b></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">&lt;cfoutput&gt;#variables.teste#&lt;/cfoutput&gt;</span></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">A linha acima vai apresentar na tela o conteúdo da variável local teste.</span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;"><b>Exemplo:</b></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;cfoutput&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;form name="frmRelatorio" id="frmRelatorio" method="post"&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;input type="hidden" name="quantidade_registros" id="quantidade_registros" value="#form.quantidade_registros#" /&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;input type="hidden" name="pagina" id="pagina" value="#form.pagina#" /&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;table cellpadding="0" cellspacing="0" class="tabela_form" width="100%"&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;tr&gt;&lt;td colspan="4" class="titulo_form"&gt;Relatório&lt;/td&gt;&lt;/tr&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;tr&gt;&lt;td colspan="4"&gt;&lt;br /&gt;&lt;/td&gt;&lt;/tr&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;tr&gt; &lt;td class="form_label"&gt;Período:&lt;/td&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;td class="" colspan="3"&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 5cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;input type="text" name="data_ini" id="data_ini" value="#form.data_ini#" size="10" maxlength="10" readonly=” readonly”&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 5cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&amp;nbsp; a &amp;nbsp;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;input type="text" name="data_fim" id="data_fim" value="#form.data_fim#" size="10" maxlength="10" readonly=” readonly”&gt; &amp;nbsp;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 5cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;input type="submit" id="btnPesq" value="Relatório" class="input_button" /&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;/td&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;/tr&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;/table&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;/form&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;/cfoutput&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">No código acima todas as variáveis do CF serão apresentadas na tela.</span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">Em ASP para apresentar informação na tela usamos </span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">Response.Write</span></span></span><span style="font-family: Times New Roman, serif;">. Diferente do Coldfusion o </span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">Response.Write</span></span></span><span style="font-family: Times New Roman, serif;"> é usado entre </span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">&lt;% e %&gt;</span></span></span><span style="font-family: Times New Roman, serif;">. Podemos escrever uma variável na tela também assim: </span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">&lt;%= variável %&gt;</span></span></span><span style="font-family: Times New Roman, serif;">.</span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;"><b>Exemplos:</b></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">Apresentando uma informação qualquer na tela.</span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">&lt;%Response.Write(“Meu primeiro acesso”)%&gt;</span></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">Apresentando o conteúdo de uma variável na tela.</span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">&lt;% teste = “Meu primeiro acesso”</span></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">Response.Write(teste)%&gt;</span></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">Ou </span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">&lt;%=teste%&gt;</span></span></span><span style="font-family: Times New Roman, serif;">, neste caso se a variável existe.</span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">O mesmo exemplo de formulário de cima.</span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;form name="frmRelatorio" id="frmRelatorio" method="post"&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;input type="hidden" name="quantidade_registros" id="quantidade_registros" value="&lt;%Response.Write(form.quantidade_registros)%&gt;" /&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;input type="hidden" name="pagina" id="pagina" value="&lt;%Response.Write(form.pagina)%&gt;" /&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;table cellpadding="0" cellspacing="0" class="tabela_form" width="100%"&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;tr&gt;&lt;td colspan="4" class="titulo_form"&gt;Relatório&lt;/td&gt;&lt;/tr&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;tr&gt;&lt;td colspan="4"&gt;&lt;br /&gt;&lt;/td&gt;&lt;/tr&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;tr&gt;&lt;td class="form_label"&gt;Período:&lt;/td&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;td class="" colspan="3"&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 3.75cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;input type="text" name="data_ini" id="data_ini" value="&lt;%Response.Write(form.data_ini)%&gt;" size="10" maxlength="10" readonly=” readonly”&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 3.75cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&amp;nbsp; a &amp;nbsp;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;input type="text" name="data_fim" id="data_fim" value="&lt;%Response.Write(form.data_fim)%&gt;" size="10" maxlength="10" readonly=” readonly”&gt; &amp;nbsp;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 3.75cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;input type="button" id="btnPesq" value="Relatório" class="input_button" onClick="relatorio(1);" /&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;/td&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;/tr&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> &lt;/table&gt;</span></span></div> <br /> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;/form&gt;</span></span></div> Robson Cabralhttp://www.blogger.com/profile/14716259356085316643noreply@blogger.com0tag:blogger.com,1999:blog-994179807525920101.post-86463208967479676652014-04-30T07:12:00.001-07:002014-04-30T07:12:35.642-07:00Definindo Valores Padrões para Variáveis<div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">Muitas vezes precisamos ficar passando as variáveis de um lado para o outro e é chato ficar tendo que verificar se uma variável existe ou não a todo o tempo.</span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">No </span><span style="font-family: Times New Roman, serif;"><b>CF</b></span><span style="font-family: Times New Roman, serif;"> a tag </span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">&lt;cfparam&gt;</span></span></span><span style="font-family: Times New Roman, serif;"> é usada para definir um valor padrão para uma variável, assim não precisamos ficar usando o </span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">IsDefined()</span></span></span><span style="font-family: Times New Roman, serif;"> toda hora para verificar se uma variável existe para usá-la.</span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">Seu uso é muito simples: </span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">&lt;cfparam name=”escopo.nome da variável” default=”Valor padrão”&gt;</span></span></span><span style="font-family: Times New Roman, serif;"> O default pode ser vazio, ou seja, default=””.</span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">Fica assim: </span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">&lt;cfparam name=”url.nome” default=””&gt;</span></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">Em </span><span style="font-family: Times New Roman, serif;"><b>ASP</b></span><span style="font-family: Times New Roman, serif;"> você pode verificar se a variável existe, mas para deixar um valor padrão basta nas primeiras linhas você informar este valor.</span></div> <br /> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;"><b>Ex.:</b></span><span style="font-family: Times New Roman, serif;"> </span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">&lt;%teste = “”%&gt;</span></span></span><span style="font-family: Times New Roman, serif;"> Estou criando a variável teste e o valor dela será vazio. Se ela não for usada desse ponto para a frente então o valor dela continuará vazio.</span></div> Robson Cabralhttp://www.blogger.com/profile/14716259356085316643noreply@blogger.com0tag:blogger.com,1999:blog-994179807525920101.post-1813548267888841222014-04-30T07:04:00.001-07:002014-04-30T07:07:57.514-07:00Verificando a existência de uma Variável em CF e em ASP<div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">Para saber se uma variável existe usamos a função </span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">IsDefined(“variável”)</span></span></span><span style="font-family: Times New Roman, serif;"> em </span><span style="font-family: Times New Roman, serif;"><b>ColdFusion</b></span><span style="font-family: Times New Roman, serif;">.</span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">Em muitos casos as aplicações passam variáveis de um lado para o outro e se essas não forem identificadas o ColdFusion gera um erro padrão. Para evitar isso usamos a função </span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">IsDefined(“variável”)</span></span></span><span style="font-family: Times New Roman, serif;"> que retorna </span><span style="font-family: Times New Roman, serif;"><i><b>Verdadeiro</b></i></span><span style="font-family: Times New Roman, serif;"> ou </span><span style="font-family: Times New Roman, serif;"><i><b>Falso</b></i></span><span style="font-family: Times New Roman, serif;">.</span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">Se você tem uma variável local chamada variables.nome e outra passada pela url com o mesmo nome (</span><span style="font-family: Times New Roman, serif;"><i>url.nome</i></span><span style="font-family: Times New Roman, serif;">) e a variável url.nome não for informada na URL, na hora de você usar esta variável o CF não vai identificá-la e não vai chegar nem perto de usar a variável local. Vai gerar um erro informando que a variável não existe. Para isso não acontecer verificamos então se a variável url.nome existe da seguinte forma:</span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;cfif IsDefined(“url.nome”)&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1.25cm;"> <span style="color: blue;"><span style="font-size: x-small;">#url.nome#</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;/cfif&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">Em </span><span style="font-family: Times New Roman, serif;"><b>ASP</b></span><span style="font-family: Times New Roman, serif;"> se a variável não for informada não será feito nada, só vai apresentar erro se você estiver usando ela, por exemplo, fazer uma comparação numa consulta ao banco de dados.</span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;%=#url.nome#%&gt;</span></span> <span style="font-family: Wingdings;"></span><span style="font-family: Times New Roman, serif;">Se a variável não existir não vai aparecer nada</span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;%SQL = “select * from tabela where campo = ” &amp; #url.nome#%&gt;</span></span> <span style="font-family: Wingdings;"></span><span style="font-family: Times New Roman, serif;">Se a variável não existir ou estiver vazia vai gerar um erro.</span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">Para evitar o erro acima a variável precisa ser tratada e não é muito diferente do ColdFusion.</span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;%If Trim(url.nome) = “” then</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> MsgErro = “O nome está vazio.”</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">else</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1.25cm;"> <span style="color: blue;"><span style="font-size: x-small;">SQL = “select * from tabela where campo = ” &amp; #url.nome#</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">End if</span></span></div> <br /> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">%&gt;</span></span></div> Robson Cabralhttp://www.blogger.com/profile/14716259356085316643noreply@blogger.com0tag:blogger.com,1999:blog-994179807525920101.post-12008546604999029252014-04-30T06:52:00.001-07:002014-04-30T06:52:48.109-07:00Criando uma Variável em ColdFusion e em ASP<div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;"><b>Em ColdFusion</b></span><span style="font-family: Times New Roman, serif;"> para criarmos uma variável usamos a tag </span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">&lt;cfset&gt;</span></span></span><span style="font-family: Times New Roman, serif;">, com ela podemos criar variáveis estáticas e dinâmicas. Em coldFusion podemos usar os escopos de variáveis na criação para nos ajudar com a identificação delas.</span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;"><b>Ex.:</b></span><span style="font-family: Times New Roman, serif;"> </span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">&lt;cfset variables.teste = “teste”&gt;</span></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">A variável que acabamos de criar recebe uma string mas pode receber o conteúdo de outra variável, por exemplo.</span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">&lt;cfset variables.teste1 = teste&gt;</span></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">A variável acima recebe o conteúdo da variável teste, podemos também formatar o conteúdo de uma variável, por exemplo, se a variável for uma data, então temos.</span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">&lt;cfset variables.data = LsDateFormat(now(),'dd/mm/yyyy') &gt;</span></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">A variável acima está recebendo a data local formatada em Dia/Mês/Ano</span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">&lt;cfset variables.Dia = NumberFormat(DatePart(“d”,variables.data),”00”)&gt;</span></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">&lt;cfset variables.Mes = NumberFormat(DatePart(“m”,variables.data),”00”)&gt;</span></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;">&lt;cfset variables.Ano = DatePart(“y”,variables.data)&gt;</span></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">Os Escopos de variáveis são:</span></div> <ul> <li><div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm;"> <span style="font-family: Times New Roman, serif;"><b>Variables</b></span><span style="font-family: Times New Roman, serif;">: Usado para identificar variáveis locais</span></div> </li> <li><div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm;"> <span style="font-family: Times New Roman, serif;"><b>URL</b></span><span style="font-family: Times New Roman, serif;">: Usado para identificar variáveis passadas pela URL ou QueryString ou quando é usado o método GET no formulário.</span></div> </li> <li><div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm;"> <span style="font-family: Times New Roman, serif;"><b>Form</b></span><span style="font-family: Times New Roman, serif;">: Usado para identificar variáveis passadas pelo formulário usando o método POST.</span></div> </li> <li><div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm;"> <span style="font-family: Times New Roman, serif;"><b>Cookie</b></span><span style="font-family: Times New Roman, serif;">: Usado para guardar informações temporárias no computador do usuário. Não é seguro para controle de login.</span></div> </li> <li><div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm;"> <span style="font-family: Times New Roman, serif;"><b>Session</b></span><span style="font-family: Times New Roman, serif;">: Usado para indentificar as variáveis da sessão do usuário durante o período de navegação.</span></div> </li> <li><div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm;"> <span style="font-family: Times New Roman, serif;"><b>Application</b></span><span style="font-family: Times New Roman, serif;">: Usado para identificar as variáveis usadas pela aplicação.</span></div> </li> </ul> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">Em</span><span style="font-family: Times New Roman, serif;"><b> ASP </b></span><span style="font-family: Times New Roman, serif;">os escopos de variáveis são vistos como 5 objetos básicos (Application, Session, Request, Response, Server)</span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: navy;"><span style="font-family: Times New Roman, serif;"><span style="font-size: 13pt;"><b>1-) O Objeto Application</b></span></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">O objeto </span></span><span style="color: black;"><span style="font-family: Times New Roman, serif;"><i>Application</i></span></span><span style="color: black;"><span style="font-family: Times New Roman, serif;"> pode ser usado para compartilhar informações entre todos os usuários de<br />uma determinado aplicativo. O aplicativo é definido como todos os arquivos .asp dentro do<br />diretório virtual e seus subdiretórios.<br /></span></span><span style="color: black;"><span style="font-family: Times New Roman, serif;"><span style="font-size: 13pt;">Sintaxe: Application.method</span></span></span><span style="color: black;"><span style="font-family: Times New Roman, serif;"><br />O objeto </span></span><span style="color: black;"><span style="font-family: Times New Roman, serif;"><i>Application</i></span></span><span style="color: black;"><span style="font-family: Times New Roman, serif;"> tem dois métodos, chamados </span></span><span style="color: black;"><span style="font-family: Times New Roman, serif;"><b>Lock e Unlock</b></span></span><span style="color: black;"><span style="font-family: Times New Roman, serif;">. Como os dados são compartilhados<br />entre os usuários, esses métodos permitem que você bloqueie e desbloqueie efetivamente o acesso<br />ao objeto aplicativo, enquanto aplica alterações em suas variáveis.<br /></span></span><span style="color: black;"><span style="font-family: Times New Roman, serif;"><b>Lock</b></span></span><span style="color: black;"><span style="font-family: Times New Roman, serif;"> não permite que outros clientes modifiquem as propriedades do objeto Application.</span></span><span style="color: black;"><span style="font-family: Times New Roman, serif;"><b>Unlock</b></span></span><span style="color: black;"><span style="font-family: Times New Roman, serif;"> permite que outros usuários modifiquem as propriedades do objeto Application.</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">Ele também permite que sejam criadas variáveis que estarão disponíveis para todos os usuários ao acessarem sua aplicação.Exemplo:</span></span></div> <dl> <dd> <table border="1" cellpadding="1" cellspacing="3" style="width: 536px;"> <colgroup><col width="171"></col> <col width="350"></col> </colgroup><tbody> <tr> <td width="171"> <div class="western" style="margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">Application.Lock<br />Application("nome")= "Jose"<br />Application.Unlock</span></span></div> </td> <td width="350"> <div class="western" style="margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: black;"><span style="font-family: Times New Roman, serif;"><b>Lock</b></span></span><span style="color: black;"><span style="font-family: Times New Roman, serif;"> bloqueia a aplicação e </span></span><span style="color: black;"><span style="font-family: Times New Roman, serif;"><b>Unlock </b></span></span><span style="color: black;"><span style="font-family: Times New Roman, serif;">desbloqueia a aplicação durante uma atualização.</span></span></div> </td> </tr> </tbody></table> </dd></dl> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: navy;"><span style="font-family: Times New Roman, serif;"><span style="font-size: 13pt;">Eventos</span></span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: black;"><span style="font-family: Times New Roman, serif;">O objeto Application possui os eventos :</span></span><span style="color: navy;"><span style="font-family: Times New Roman, serif;"><b> OnStart e OnEnd </b></span></span><span style="color: black;"><span style="font-family: Times New Roman, serif;">e são utilizados no arquivo Global.asa e são chamados apenas uma única vez.</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: navy;"><span style="font-family: Times New Roman, serif;"><b>OnStart </b></span></span><span style="color: black;"><span style="font-family: Times New Roman, serif;">- entra em funcionamento quando a solicitação do primeiro cliente é atendida.</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: navy;"><span style="font-family: Times New Roman, serif;"><b>OnEnd </b></span></span><span style="color: black;"><span style="font-family: Times New Roman, serif;">- É ativada quando a aplicação ASP é descarregada do servidor ou quando a aplicação é interrompida.</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;"><b>Em ASP</b></span><span style="font-family: Times New Roman, serif;"> a montagem de variáveis é feita sem a necessidade de informar o escopo e se ela não existir ou estiver vazia será ignorada a princípio.</span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;"><b>Ex.:</b></span> <span style="color: blue;"><span style="font-size: x-small;">&lt;%teste = “teste” %&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;%teste1 = #teste# %&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;%strData = FormatDateTime(Now())</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">strDia = Day(strData)</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">If Len(strDia) = 1 Then</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> strDia = “0” &amp; strDia</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">End If</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">strMes = Month(strData)</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">If Len(strMes) = 1 Then</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;"> strMes = “0” &amp; strMes</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">End If</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">strAno = Year(strData)</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-top: 0.21cm; text-indent: 1cm;"> <span style="color: blue;"><span style="font-size: x-small;">%&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="font-family: Times New Roman, serif;"><b>Mas em ASP</b></span><span style="font-family: Times New Roman, serif;"> existe uma maneira de obrigar a declaração das variáveis antes de usá-las com o comando “Option Explicit”. Ele força a declaração (com Dim, Private, Public ou ReDim) de todas as variáveis usadas no script, antes de serem utilizadas. Deve ser colocado no script antes de qualquer outra instrução. Qualquer tentativa de usar uma variável não declarada ocasionará um erro. A declaração de variáveis antes de usá-las faz com que o script seja executado mais rapidamente.</span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="font-family: Times New Roman, serif;">Utilizando Option Explicit, além de melhorar a performance das páginas você detectará erros de digitação imediatamente, evitando horas de depuração de código para descobrir que o problema era uma variável com alguma letra trocada.</span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;%option explicit</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="color: blue;"><span style="font-size: x-small;">Dim variavel1, variavel2</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="color: blue;"><span style="font-size: x-small;">%&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="font-family: Times New Roman, serif;"><b>Em ASP</b></span><span style="color: blue;"><span style="font-family: Times New Roman, serif;"><span style="font-size: x-small;"> </span></span></span><span style="font-family: Times New Roman, serif;">para verificar um tipo de variável usamos a função </span><span style="font-family: Times New Roman, serif;"><b>VarType()</b></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="color: blue;"><span style="font-size: x-small;">&lt;%</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="color: blue;"><span style="font-size: x-small;">Dim x</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="color: blue;"><span style="font-size: x-small;">response.write "Tipo: " &amp; VarType(x) &amp; "&lt;br /&gt;"</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="color: blue;"><span style="font-size: x-small;">x = 1</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="color: blue;"><span style="font-size: x-small;">response.write "x=" &amp; x &amp; "Tipo: " &amp; VarType(x) &amp; "&lt;br /&gt;"</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="color: blue;"><span style="font-size: x-small;">x = "texto"</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="color: blue;"><span style="font-size: x-small;">response.write "x=" &amp; x &amp; "Tipo: " &amp; VarType(x) &amp; "&lt;br /&gt;&lt;br /&gt;"</span></span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="color: blue;"><span style="font-size: x-small;">%&gt;</span></span></div> <div class="western" style="margin-bottom: 0cm; text-indent: 1cm;"> <span style="font-family: Times New Roman, serif;">Resultado:</span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="font-family: Times New Roman, serif;">Tipo: 0<br />x=1Tipo: 2<br />x=textoTipo: 8</span></div> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="font-family: Times New Roman, serif;"><b>Explicando:</b></span></div> <br /> <div class="western" style="margin-bottom: 0cm; margin-left: 1cm; margin-top: 0.21cm;"> <span style="font-family: Times New Roman, serif;">0 = vbEmpty - Indicates Empty (uninitialized) <br />1 = vbNull - Indicates Null (no valid data) <br />2 = vbInteger - Indicates an integer <br />3 = vbLong - Indicates a long integer <br />4 = vbSingle - Indicates a single-precision floating-point number <br />5 = vbDouble - Indicates a double-precision floating-point number <br />6 = vbCurrency - Indicates a currency <br />7 = vbDate - Indicates a date <br />8 = vbString - Indicates a string <br />9 = vbObject - Indicates an automation object <br />10 = vbError - Indicates an error <br />11 = vbBoolean - Indicates a boolean <br />12 = vbVariant - Indicates a variant (used only with arrays of Variants) <br />13 = vbDataObject - Indicates a data-access object <br />17 = vbByte - Indicates a byte <br />8192 = vbArray - Indicates an array</span></div> Robson Cabralhttp://www.blogger.com/profile/14716259356085316643noreply@blogger.com0tag:blogger.com,1999:blog-994179807525920101.post-32341476943726655742014-01-23T03:19:00.002-08:002014-01-23T03:19:24.132-08:00Google no topo.<div class="separator" style="clear: both; text-align: center;"> <a href="http://info.abril.com.br/images/materias/2014/01/thumbs/thumb-110114-google-resized.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://info.abril.com.br/images/materias/2014/01/thumbs/thumb-110114-google-resized.jpg" height="240" width="320" /></a></div> <br /> <br /> Google Posição no ranking: 1º lugar Número de funcionários nos EUA: 42,162 Funcionários fora dos EUA: não informado Novas contratações em um ano: 4,236 Crescimento na oferta de emprego em um ano: 20.1% Receita anual: 50,175 milhões de dólares.Robson Cabralhttp://www.blogger.com/profile/14716259356085316643noreply@blogger.com0tag:blogger.com,1999:blog-994179807525920101.post-38844308922985131422014-01-16T03:43:00.001-08:002014-01-16T03:43:51.660-08:00 LinkedIn cria página para busca por trabalhos voluntários<div class="separator" style="clear: both; text-align: center;"> <a href="http://info.abril.com.br/images/materias/2014/01/thumbs/160139-linkedin.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://info.abril.com.br/images/materias/2014/01/thumbs/160139-linkedin.jpg" height="154" width="320" /></a></div> <br /> <br /> <br /> <br /> O LinkedIn anunciou uma nova página em seu serviço que permite aos usuários buscar por oportunidades de trabalho voluntário e filantrópico.<br /> <br /> Por meio do novo canal <a href="http://blog.linkedin.com/2014/01/15/the-linkedin-volunteer-marketplace-connecting-professionals-to-nonprofit-volunteer-opportunities/" target="_blank">Volunteer Marketplace</a>, os membros do LinkedIn poderão encontrar oportunidades para trabalhar com organizações de caridade.<br /> <br /> Os usuários poderão também indicar em seus perfis que gostariam de participar do conselho de uma organização sem fins lucrativos ou mesmo realizar algum trabalho voluntário.<br /> <br /> Quando um membro do LinkedIn realizar alguma atividade voluntária a partir da Volunteer Marketplace, a organização dará um feedback no perfil do usuário.<br /> <br /> Inicialmente a busca por trabalhos voluntários contará com 500 vagas, mas o LinkedIn pretende incluir mais oportunidades ao longo das próximas semanas.<br /> <br /> As organizações podem registrar uma vaga normalmente no serviço, mas seu custo será de apenas 10% dos valores dos trabalhos remunerados, que custam entre 20 e 40 dólares.<br /> <br /> Fonte: http://info.abril.com.br/noticias/mercado/2014/01/linkedin-cria-pagina-para-busca-por-trabalhos-voluntarios.shtml <br /> Robson Cabralhttp://www.blogger.com/profile/14716259356085316643noreply@blogger.com0tag:blogger.com,1999:blog-994179807525920101.post-53441816068032560342014-01-13T12:39:00.002-08:002014-01-13T12:41:49.446-08:00 Google trabalha em serviço para compra de passagens aéreas<div class="separator" style="clear: both; text-align: center;"> <a href="http://media.contadd.com/Images/sp.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://media.contadd.com/Images/sp.gif" /></a></div> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="http://media.contadd.com/Images/sp.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://media.contadd.com/Images/sp.gif" /></a></div> <br /> O <a href="http://info.abril.com.br/topicos/google/" target="_blank"><b>Google</b></a> está trabalhando em uma nova ferramenta de comparação de preços e compra de passagens aéreas que “irá surpreender a todos no mercado”, segundo o presidente da companhia aérea Ryanair.<br /> Em entrevista ao jornal irlandês <a href="http://www.independent.ie/business/irish/oleary-reveals-ryanairgoogle-plan-to-change-how-we-buy-tickets-forever-29907730.html" target="_blank">Sunday Independent</a>, Michael O’Leary, presidente da Ryanair, disse que a empresa está ajudando o Google a desenvolver uma nova ferramenta para compra de passagens.<br /> <br /> A Ryanair vem compartilhando seus preços com o Google, que desenvolve um serviço que irá exibir tarifas com valores atualizados e direcionar os consumidores aos canais de compra das companhias aéreas.<br /> <br /> “O Google, sendo quem é, quer mostrar todos os preços de todas as companhias aéreas disponíveis. Eles não querem nos cobrar também, já que fazem seu capital por meio de publicidade”, disse O’Leary.<br /> <br /> Segundo o executivo, o Google pretende criar um banco de dados sem limitações e que traga todas as rotas e companhias aéreas do mercado. A ideia é facilitar a busca pela tarifa mais baixa.<br /> <br /> Além da parceria com o Google, a Ryanair também trabalha para incorporar mais tecnologia em seus serviços. Conhecida como uma das companhias aéreas mais baratas da Europa, a empresa pretende implementar pagamentos móveis dentro de cinco anos para a compra de produtos durante os voos.<br /> <br /> fonte:&nbsp;<a href="http://info.abril.com.br/noticias/mercado/2014/01/google-trabalha-em-servico-para-compra-de-passagens-aereas.shtml" rel="nofollow" target="_blank">info</a> Robson Cabralhttp://www.blogger.com/profile/14716259356085316643noreply@blogger.com0tag:blogger.com,1999:blog-994179807525920101.post-20686096550408469192014-01-13T12:31:00.002-08:002014-01-13T12:32:24.224-08:00 Bug em update de banco de dados causou instabilidade no Dropbox<div class="separator" style="clear: both; text-align: center;"> <a href="http://info.abril.com.br/images/materias/2014/01/thumbs/thumb-34432130159-dropbox-resized.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://info.abril.com.br/images/materias/2014/01/thumbs/thumb-34432130159-dropbox-resized.jpg" height="214" width="320" /></a></div> <br /> <br /> O serviço de armazenamento na nuvem <a href="http://info.abril.com.br/tags/dropbox" target="_blank"><b>Dropbox</b></a> ficou instável para muitos usuários neste último fim de semana. E os problemas não tiveram nada a ver com invasões de crackers ou<a href="http://info.abril.com.br/noticias/seguranca/2014/01/dropbox-fica-fora-do-ar-e-hackers-se-dizer-responsaveis-por-ataque.shtml" target="_blank"> ataques DDoS</a>, mas sim com um bug na atualização do SO dos servidores, como explica <a href="https://tech.dropbox.com/2014/01/outage-post-mortem/" target="_blank">um post do engenheiro</a> e chefe de infraestrutura Akhil Gupta no Dropbox Tech Blog.<br /> <br /> De acordo com o texto, tudo começou com uma manutenção agendada feita pela equipe do serviço na tarde de sexta-feira. Nela, seria atualizado o sistema operacional de algumas das máquinas que funcionam como bancos de dados. Tudo seria auxiliado por um script de upgrade, que confere se não há dados ativos em cada computador antes de iniciar a atualização.<br /> <br /> O problema é que, como explica o texto, “um bug súbito no script fez com que o processo fosse feito em um pequeno número de máquinas ativas”. Na teoria, isso não seria o suficiente para derrubar o serviço – o Dropbox conta com milhares de bancos de dados, e cada um possui três máquinas, sendo uma “mestra” (Master) e outras duas “escravas” (Slaves), para redundância. Só que a falha acabou por afetar grupos inteiros, “matando” o serviço.<br /> <br /> De acordo com Gupta, a equipe tentou restaurar o funcionamento recuperando os dados por backups. O sucesso foi relativo, já que a maior parte das funcionalidades voltou ao ar em cerca de três horas. No entanto, “a extensão de alguns bancos de dados atrasou a recuperação”, o que fez com que o processo só fosse concluído de fato na tarde de domingo.<br /> <br /> Apesar de a falha ter atingido servidores, o Dropbox garante que os documentos, fotos e vídeos dos usuários nunca estiveram em risco. “Esses bancos de dados não contêm informações de arquivos”, segundo o post do engenheiro. Eles são usados para fornecer recursos, “como o compartilhamento de álbuns, uploads da câmera e funcionalidades da API”.<br /> <br /> Gupta ainda usou o post para dizer que a falha não deverá se repetir. Uma camada extra de checagem foi adicionada ao processo de atualização, de forma que a situação das máquinas passará a ser verificado também localmente – assim, computadores com processos em execução por “recusar operações potencialmente destrutivas”.<br /> <br /> Mas caso isso não resolva e um acidente do tipo volte a acontecer, a equipe diz ter desenvolvido uma ferramenta que acelera a recuperação de backups MySQL. O código fonte dela&nbsp;será liberada&nbsp;para outras pessoas&nbsp;em breve, segundo o engenheiro. Aliás, o&nbsp;<a href="https://blog.dropbox.com/2014/01/back-up-and-running/" target="_blank">Dropbox deve voltar a funcionar</a> normalmente&nbsp;ainda nesta segunda-feira, com exceção de alguns recursos de fotos, segundo a VP de engenharia do serviço&nbsp;Aditya Agarwal.Robson Cabralhttp://www.blogger.com/profile/14716259356085316643noreply@blogger.com0tag:blogger.com,1999:blog-994179807525920101.post-41088578187334349612014-01-10T03:03:00.001-08:002014-01-10T03:04:15.035-08:00 Galaxy S5 será lançado em abril e terá leitor de íris, diz siteA Samsung deve lançar o smartphone Galaxy S5 em abril e o dispositivo poderá incluir uma tecnologia para leitura da íris, segundo informações do site da Bloomberg.<br /> <br /> “Muitas pessoas são fanáticas pela tecnologia de reconhecimento da íris. Nós estamos estudando esta possibilidade”, disse Lee Young Hee, vice-presidente executivo da Samsung em <a href="http://www.bloomberg.com/news/2014-01-09/samsung-plans-galaxy-s5-by-april-with-possible-eye-scan-security.html" target="_blank">entrevista</a> a Bloomberg durante a feira CES. <br /> <br /> A executiva não revelou detalhes sobre o aparelho, mas mencionou os planos da empresa de “voltar ao básico”, com foco na tela do dispositivo e na qualidade de seu case.<br /> <br /> A Samsung costuma anunciar seus modelos topo de linha alguns dias antes da feira Mobile World Congress, que ocorre anualmente em meados de fevereiro na cidade de Barcelona.<br /> Segundo a executiva, as vendas do Galaxy S5 podem ocorrer então entre os meses de março e abril.<br /> <br /> Além do Galaxy S5, a executiva confirmou que o lançamento do smartphone será acompanhado do anúncio da nova geração do relógio inteligente Galaxy Gear.<br /> <br /> “Quando lançarmos nosso Galaxy S5, vocês também poderão esperar pelo sucessor do Gear com funções mais avançadas e um novo e melhorado design”, disse.Robson Cabralhttp://www.blogger.com/profile/14716259356085316643noreply@blogger.com0tag:blogger.com,1999:blog-994179807525920101.post-53365987478388247792014-01-06T12:14:00.002-08:002014-01-06T12:14:07.595-08:00 Samsung confirma apresentação do Galaxy S5 em fevereiro, diz siteUm executivo da Samsung confirmou nesta segunda-feira (6) a apresentação oficial do smartphone topo de linha Galaxy S5 para fevereiro, durante o Mobile World Congress, que acontece em Barcelona, Espanha, entre os dias 24 e 27.<br /> <br /> Dong-hoon Chang,&nbsp;vice-presidente executivo da Samsung, informou ao site sul-coreano <a href="http://news.inews24.com/php/news_view.php?g_serial=794997&amp;g_menu=020800&amp;mains=News"><i>iNews24</i></a>. Entretanto,&nbsp;a publicação americana&nbsp;<a href="http://crave.cnet.co.uk/mobiles/samsung-confirms-galaxy-s5-will-launch-at-mwc-in-february-50013157/"><i>CNET</i></a>&nbsp;entrou em contato com a empresa que não quis comentar o caso. Chang diz que ainda está "sob análise" se o novo aparelho terá tela curva, como o Galaxy Round, e carcaça de metal.<br /> <br /> <br /> O Galaxy S5 será o novo smartphone topo de linha da companhia, substituindo o <a href="http://info.abril.com.br/reviews/smartphones/samsung-galaxy-s4.shtml">Galaxy S4</a>, que vendeu mais de 40 milhões de unidades no ano passado, em todo o mundo.<br /> <br /> Não foram reveladas informações sobre processador, tamanho da tela ou demais especificações técnicas do dispositivo.<br /> <br /> Fonte: http://info.abril.com.br/noticias/tecnologia-pessoal/2014/01/samsung-confirma-apresentacao-do-galaxy-s5-em-fevereiro-diz-site.shtml Robson Cabralhttp://www.blogger.com/profile/14716259356085316643noreply@blogger.com0tag:blogger.com,1999:blog-994179807525920101.post-57889308303159086192011-06-01T12:53:00.000-07:002011-06-01T12:53:22.089-07:00Paginação em ColdFusion<span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;">&lt;cfquery datasource="mysql" name="aaa"&gt;</span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;"><br /> </span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;">select id, produto, preco from loja</span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;"><br /> </span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;">&lt;/cfquery&gt;</span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;"><br /> </span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;"><br /> </span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;">&lt;cfparam name="final" default=4&gt;</span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;"><br /> </span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;">&lt;cfparam name="url.pgatual" default=1&gt;</span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;"><br /> </span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;"><br /> </span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;">&lt;cfoutput query="aaa" startrow="#url.pgatual#" maxrows="#final#"&gt;</span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;"><br /> </span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;">&lt;p&gt;ID: #aaa.id#&lt;br&gt;</span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;"><br /> </span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;">Produto: #aaa.produto#&lt;br&gt;</span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;"><br /> </span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;">Preço: #aaa.preco#&lt;/p&gt;</span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;"><br /> </span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;"><br /> </span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;">&lt;cfset final=final+4&gt;</span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;"><br /> </span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;">&lt;/cfoutput&gt;</span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;"><br /> </span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;"><br /> </span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;">&lt;cfset z=1&gt;</span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;"><br /> </span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;">&lt;cfloop index="controle" from="1" to="#aaa.recordcount#" step="5"&gt;</span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;"><br /> </span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;">&lt;cfoutput&gt;</span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;"><br /> </span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;">&lt;a href="teste.cfm?pgatual=#controle#"&gt;#z#&lt;/a&gt;</span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;"><br /> </span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;">&lt;cfset z = IncrementValue(z)&gt;</span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;"><br /> </span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;">&lt;/cfoutput&gt;</span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;"><br /> </span><span class="Apple-style-span" style="border-collapse: collapse; color: #1c2837; font-family: arial, verdana, tahoma, sans-serif; font-size: 13px; line-height: 13px;">&lt;/cfloop&gt;</span>Robson Cabralhttp://www.blogger.com/profile/14716259356085316643noreply@blogger.com5