[cf-brasil] Query

Leandro Massafera Wed, 21 Apr 2004 07:26:15 -0700

Boa dia a todos;

Estou com problemas na query abaixo, ela roda legal no SQL s� que no ColdFusion ela da erro dizendo que n�o aceita o @.

SET NOCOUNT ON

INSERT INTO nep_usuario (usu_no_usuario, usu_tx_email, usu_no_razao_social, rat_nu_idramo)
VALUES ('#form.nome#', '#form.email#', '#form.empresa#', #form.id_ramo_atividade#)

DECLARE @idusuario int

SELECT @idusuario = ident_current('nep_usuario')

        IF @idusuario <> 0
        BEGIN
            INSERT INTO nep_usuario_area (usu_nu_idusuario, ain_nu_idarea)
            VALUES ([EMAIL PROTECTED]#, #form.area_interesse#)
        END

</cfquery>

Algu�m a� poderia me ajudar. Agrade�o a aten��o de todos.

[]'s

Leandro Massafera.

--^^---------------------------------------------------------------
This email was sent to: [EMAIL PROTECTED]

EASY UNSUBSCRIBE click here: http://topica.com/u/?b1dnXn.b7DDjq.Y2ZicmFz
Or send an email to: [EMAIL PROTECTED]

For Topica's complete suite of email marketing solutions visit:
http://www.topica.com/?p=TEXFOOTER
--^^---------------------------------------------------------------

[cf-brasil] Query

Responder a