Posts by arrgh

Is that a double quote or two single quotes? What syntax are you using to insert the encrypted string into the database?

Side notes:

Since I don't work with cc's I am curious... is it a good idea to actually display the full credit card number on the web page?

<cfset key = #application.key#>
<cfset Cardnum = '#Get_Orders.Credit_Card_Number#'>
<cfset CardDec = decrypt(Cardnum, key)>

This has nothing to do with the problem, but there is no need for those # signs. Just use:

<cfset Cardnum = Get_Orders.Credit_Card_Number>
<cfset CardDec = decrypt(Cardnum, application.key)>

Good. I am glad you were able to solve the problem.

It is rare that there is not a better error message. The only thing that comes close, in my experience is a plain "500" error. But again, that is unusual.

- Did you enable debugging in the ColdFusion Administrator?
- What does is the error in the stack trace?
- Check the log files, what is the error message there?

what happen is after the execution half of the data transfer successfully but during the process i face this problem
Error Occurred While Processing Request
50

That is just the error header. What is the rest of the error message?

I doubt cfimage can generate image maps. But if you know the coordinates when the images are rendered, just save them in variables (array, structure, etc..). Then use those values to generate the image map coordinates.

Did you verify the "selected" values actually exist in the query?

Other than that the code looks okay except for the onChange. OnChange accepts javascript/actionscript. But it looks like you are passing in the selected value instead, which probably wouldn't work.

Since the table Program and History are from 2 different Database, we cannot union these tables.

Possibly. But that all depends on the database and permissions.

UNION ALL should work either within a regular database query (assuming the correct permissions), or using a ColdFusion QoQ
http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=using_recordsets_7.html

Try a UNION ALL. It will include every record from both selects. Just make sure both selects have the same number of columns.

SELECT Posted FROM program WHERE cust_no = '125'
UNION ALL
SELECT Posted FROM history WHERE cust_no = '125'
ORDER BY (Your_Date_Field_Name)