Does any of your code contain special characters? If it's runs on your machine, which is probably localized to your local language, it may not run on an a machine (the US server) that isn't setup to handle those characters.
--- Billy Cravens Web and Software Consulting www.Architechx.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Javier Flores Sent: Monday, October 07, 2002 9:28 AM To: [EMAIL PROTECTED] Subject: IIS? CF? or What? 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 ------------------------------------------------------------------------- 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
