Hi everyone!
I have this simple query that is suppose to process a form... I have been testing at
my PC (IIS5, CF4.5 + SP2) at home and it work properly, but it does not run in my
virtual web server in a provider in US(*)... any suggestion? Any Idea? Do you see
anything wrong in this code?
(*)NOTE: It does not run either over CF5.0
Thankx!
JJ
CODE CODE CODE CODE CODE CODE CODE CODE CODE CODE
<CFQUERY datasource="xxxxxxx" NAME="GenerarOrden">
INSERT INTO orden
(contacto,
GeneradaPor,
tipo_entrega,
peso_paquete,
<cfif #form.direccion_origen# IS 1>
ContactoRemT,
EmpresaRemT,
DirRemT,
Pto_RefRemT,
UrbRemT,
TelfRemT,
EmailRemT,
direccion_origen,
<cfelse>
direccion_origen,
</cfif>
<cfif #form.direccion_destino# IS 1>
ContactoDesT,
EmpresaDesT,
DirDesT,
Pto_RefDesT,
UrbDesT,
TelfDesT,
EmailDesT,
direccion_destino,
<cfelse>
direccion_destino,
</cfif>
descripcion,
observaciones,
retorno,
fecha_orden,
hora_orden,
fecha_recolecta,
hora_recolecta,
fecha_destino,
hora_destino,
cantidad)
VALUES
('#Form.contacto#',
'#Form.GeneradaPor#',
'#Form.tipo_entrega#',
'#Form.peso_paquete#',
<cfif #form.direccion_origen# IS 1>
'#Form.ContactoRemT#',
'#Form.EmpresaRemT#',
'#Form.DirRemT#',
'#Form.Pto_RefRemT#',
'#Form.UrbRemT#',
'#Form.TelfRemT#',
'#Form.EmailRemT#',
'#Form.direccion_origen#',
<cfelse>
'#Form.direccion_origen#',
</cfif>
<cfif #form.direccion_destino# IS 1>
'#Form.ContactoDesT#',
'#Form.EmpresaDesT#',
'#Form.DirDesT#',
'#Form.Pto_RefDesT#',
'#Form.UrbDesT#',
'#Form.TelfDesT#',
'#Form.EmailDesT#',
'#Form.direccion_destino#',
<cfelse>
'#Form.direccion_destino#',
</cfif>
'#Form.descripcion#',
'#Form.observaciones#',
'#Form.retorno#',
'#Form.fecha_orden#',
'#Form.hora_orden#',
'#Form.fecha_recolecta#',
'#Form.hora_recolecta#',
'#Form.fecha_destino#',
'#Form.hora_destino#',
'#Form.cantidad#')
</CFQUERY>
<!--- }toma el Nro de la Orden Generada --->
<CFQUERY datasource="entre571" NAME="NuevoRegistro">
select max(orden) as nueva_orden from orden
</CFQUERY>
<cfoutput query="NuevoRegistro">
<cfset new_orden = #nueva_orden#>
</cfoutput>
<!--- }envia el email --->
<cfmail from="[EMAIL PROTECTED]" subject="Nueva Orden:
<cfoutput>#new_orden#</cfoutput>" to="[EMAIL PROTECTED]" server="mail.entregahoy.com">
La Orden Nro #new_orden#<br>
Se ha Generado con Exito!<br>
</cfmail>
<!--- Go back to the Template page --->
<CFLOCATION URL="gracias.cfm?new_orden=#new_orden#">
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
