500 Internal Server Error

pigmentarts
pigmentarts used Ask the Experts™
on
getting this error which is not helpful


 500 Internal Server Error
 
The error occurred in D:wwwroot\thank-you.cfm: line 194


192 :       <cfhttpparam type="Formfield" value="#mobile#" name="mobile">
193 :       <cfhttpparam type="Formfield" value="#email#" name="email">
194 :       <cfhttpparam type="Formfield" value="#password#" name="password">
195 :       
196 :       

Message: 500 Internal Server Error

Caught an exception, type = COM.Allaire.ColdFusion.HTTPServerError



<cfquery name="customerTb" datasource="#dbSource#" username="#dbUsername#" password="#dbPassword#">
 
SELECT orders.*, customers.*
FROM orders
JOIN customers ON
 orders.customerId = customers.email
WHERE orders.VendorTxCode = '#SESSION.protx.VendorTxCode#'
</cfquery>
 

<cfoutput query="customerTb">


<cfhttp url="http://www.domain.com/import.asp" method="post" delimiter="," resolveurl="no" throwonerror="yes" timeout="20" charset="windows-1252">
      
      <cfhttpparam type="Formfield" value="#CartItems#" name="CartItems">
      
      <cfhttpparam type="Formfield" value="123456862" name="MMCustomerID">
      <cfhttpparam type="Formfield" value="#SESSION.protx.VendorTxCode#" name="order_id">
      <cfhttpparam type="Formfield" value="#ip#" name="ClientIPAddress">
      <cfhttpparam type="Formfield" value="#timedate#" name="timedate">
      <cfhttpparam type="Formfield" value="#paymenttype#" name="paymenttype">
      <cfhttpparam type="Formfield" value="#subtotal#" name="subtotal">
      <cfhttpparam type="Formfield" value="#delTotal#" name="delTotal">
      <cfhttpparam type="Formfield" value="#tax#" name="CartTax">
      <cfhttpparam type="Formfield" value="#orderTotal#" name="Amount">
      <cfhttpparam type="Formfield" value="#currency#" name="Currency">
      <cfhttpparam type="Formfield" value="#shipName#" name="shipName">
      <cfhttpparam type="Formfield" value="#shipCompany#" name="shipCompany">
      <cfhttpparam type="Formfield" value="#shipAddress1#" name="shipAddress1">
      <cfhttpparam type="Formfield" value="#shipAddress2#" name="shipAddress2">
      <cfhttpparam type="Formfield" value="#shipAddress3#" name="shipAddress3">
      <cfhttpparam type="Formfield" value="#shipPostCode#" name="shipPostCode">
      <cfhttpparam type="Formfield" value="#shipCountry#" name="shipCountry">
      
      
      <cfhttpparam type="Formfield" value="#name#" name="name">
      <cfhttpparam type="Formfield" value="#company#" name="company">
      <cfhttpparam type="Formfield" value="#address1#" name="address1">
      <cfhttpparam type="Formfield" value="#address2#" name="address2">
      <cfhttpparam type="Formfield" value="#address3#" name="address3">
      <cfhttpparam type="Formfield" value="#city#" name="city">
      <cfhttpparam type="Formfield" value="#county#" name="county">
      <cfhttpparam type="Formfield" value="#post_code#" name="post_code">
      <cfhttpparam type="Formfield" value="#county#" name="county">
      <cfhttpparam type="Formfield" value="#tel#" name="tel">
      <cfhttpparam type="Formfield" value="#fax#" name="fax">
      <cfhttpparam type="Formfield" value="#mobile#" name="mobile">
      <cfhttpparam type="Formfield" value="#email#" name="email">
      <cfhttpparam type="Formfield" value="#password#" name="password">
      <cfhttpparam type="Formfield" value="123456862" name="customerId">
      
      
      
      
      
      
      </cfhttp>

</cfoutput>
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Narrow it down by commenting out the password line, does it work then?  If not, comment out the group of them, try and get it down to the one line causing the problem.

Author

Commented:
i can take out all the cfhttpparam t tags and just  leave one and it still does it!

i outputted all the query vars and they all work, if i take out the cfquery if works but i need that to get all me values!

Author

Commented:
if this brings the same error


            <cfhttp url="http://www.orderhistorysoftware.com/orderhistory/ohy/import_newebia.asp" method="post"  resolveurl="no" throwonerror="yes" timeout="20" charset="windows-1252">
            
            <cfhttpparam type="Formfield" value="test" name="CartItems">
            
            
            </cfhttp>

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial