Moçada
bom dia.
Tenho um form de update onde mostro assim:
<TR> <TD>
<INPUT type="hidden" class=fields
name="departamentoID"
value="0550EA15-795D-1267-36B0D328F38698EE"><BR>
<INPUT class=fields maxLength=30 size=50
name="departamento_0550EA15-795D-1267-36B0D328F38698EE"
value="Contabilidade"><BR>
<INPUT type="hidden" class=fields
name="departamentoID"
value="0550EA29-795D-1267-318AF5DE0E50B206"><BR>
<INPUT class=fields maxLength=30 size=50
name="departamento_0550EA29-795D-1267-318AF5DE0E50B206"
value="Financeiro"><BR>
<INPUT type="hidden" class=fields
name="departamentoID"
value="0550EA33-795D-1267-33AEDC6D486EBC2C"><BR>
<INPUT class=fields maxLength=30 size=50
name="departamento_0550EA33-795D-1267-33AEDC6D486EBC2C"
value="Gerência de Sinistros"><BR>
<INPUT type="hidden" class=fields
name="departamentoID"
value="0550EA3D-795D-1267-3551A63732E2FEFD"><BR>
<INPUT class=fields maxLength=30 size=50
name="departamento_0550EA3D-795D-1267-3551A63732E2FEFD"
value="Gerência de Projetos"><BR>
</TD></TR>
O cliente faz a sua atualização e quando vou dar o
update no SQL ele dá pau, na verdade pau no Evaluate.
Olha o SQL:
<CFIF IsDefined('form.departamentoID')>
<cfloop list = "#Form.FieldNames#" index =
"ThisField">
<cfif LEFT(ThisField,13) Is "departamento_">
<cfoutput>
ThisField= #ThisField#<BR>
Right=
#RIGHT(ThisField,(LEN(ThisField)-13))#<br>#evaluate("#thisfield#")#
</cfoutput>
</cfif>
</cfloop>
</CFIF>
O erro do CF:
"795D," on line 1, column 23, is not a valid identifer
name.
The CFML compiler was processing:
an expression beginning with "DEPARTAMENTO_0550EA15",
on line 1, column 1.This message is usually caused by
a problem in the expressions structure.
O que pode ser? Como pegar o valor do campo em
ThisField?
Obrigado
=====
Diga-me e eu esquecerei
Mostre-me e lembrarei
Ensina-me e aprenderei
______________________________________________________________________
Participe da pesquisa global sobre o Yahoo! Mail:
http://br.surveys.yahoo.com/global_mail_survey_br
--^----------------------------------------------------------------
This email was sent to: [EMAIL PROTECTED]
EASY UNSUBSCRIBE click here: http://topica.com/u/?b1dnXn.b7M5gI.YXJxdWl2
Or send an email to: [EMAIL PROTECTED]
For Topica's complete suite of email marketing solutions visit:
http://www.topica.com/?p=TEXFOOTER
--^----------------------------------------------------------------
