Adobe Community : All Content - All Communities

Tempered encryption causing Decrypt to crash

forums_noreply@adobe.com — Fri, 24 Oct 2014 23:20:56 GMT

I have made an encryption of "auth" using AES as follows:

		<cfset skey = generateSecretKey("AES")>
		<cfset regkey = encrypt("auth", skey, "AES", "hex")>

I attached the result for example to an URL

http://www.mydomain.com/authorization.htm?auth=34D3795AA3696B7F81AEFE414DCA7392FDCC50AFE9D 0312B2B2530A985386B83

(auth is assign regkey i.e. ,,,,,,htm?auth=#regkey#)

This works perfectly under perfect condition. However, if I go ahead and try to "hack" the code and make it shorter and change some characters like this:

http://www.mydomain.com/authorization.htm?auth=453424AEFE414DCA7392FDCC50AFE9D0312B2B2530A 985386B83

The Decrypt function:

just crash! It throws an exception. Isn't it supposed to just return bad string rather than crashing? This is pretty bad.

Is there way to check for the URL.auth before passing to Decrypt? Thanks in advance.

CFwindow not working with secure URL

forums_noreply@adobe.com — Tue, 30 Sep 2014 00:37:24 GMT

I use the code

	<cfajaximport tags="cfform, cfmessagebox, cfwindow">
	<cfwindow bodystyle="background:white;font:12px/normal arial, Helvetica, sans-serif;" initShow="true" width="350" height="255" name="signin" center="true" resizable="false" draggable="false" source="login.htm"/>

and it is working fine. The sign in window appears. However, I want to change it to a secured URL by entering the full URL

	<cfajaximport tags="cfform, cfmessagebox, cfwindow">
	<cfwindow bodystyle="background:white;font:12px/normal arial, Helvetica, sans-serif;" initShow="true" width="350" height="255" name="signin" enter="true" resizable="false" draggable="false" source="https://mydomain/login.htm"/>

The pop up cfwindows shows blank. Why is that? Any help is appreciated.

Problem with cfinput autosuggest and cfcomponent

forums_noreply@adobe.com — Mon, 29 Sep 2014 04:37:16 GMT

I am new to using cfcomponent and autosuggest. I followed the sample given in the Adobe Help Adobe ColdFusion 9 * Using Ajax User Interface Components and Features

However, I am not getting the autosuggest to work at all. This is what I did:

1. I created a Suggestcfc.cfc under a subdirectory called "components"

The Suggestcfc.cfc is as follows:

SELECT DISTINCT productname FROM products

WHERE productname LIKE <cfqueryparam value="#suggestvalue#%" cfsqltype="cf_sql_varchar">

</cfquery>

</cfloop>

</cffunction>

</cffunction>

</cfcomponent>

2. I have a test.cfm as:

<head>

</head>

<body>

</cfform>

</body>

</html>

So when I run the test.cfm it only showed a box and when I started typing, nothing is being suggested (retrieve from the products table). What am I doing wrong here? Any help is appreciated. Thanks in advance.

CFINPUT VALIDATE INTEGER NOT WORKING PROPERLY

forums_noreply@adobe.com — Thu, 24 Jul 2014 05:45:55 GMT

The CFINPUT with the VALIDATE="integer" is not working properly at all. The user can enter 23,950 as the number. We would think this is OK but it won't work properly without stripping the ","

The field:

Then, when the value is passed to the SQL INSERT

<CFQUERY....>

INSERT INTO mytable

(name, mynumber)

VALUES

(#'form.name#',#form.mynumber#)

</CFQUERY>

Coldfusion will take the value 23,950 and think that 23 is one field and 950 is another because of the "," Therefore it is trying to put 3 values into 2 fields and throw an error. Am I doing something wrong here or is this Coldfusion bug?

p.s. in the MySql database, the "mynumber" field is defined as integer.

CFINCLUDE inside CFMAIL

forums_noreply@adobe.com — Mon, 14 Jul 2014 04:35:47 GMT

I have a done a CFQUERY and retrieve user's email and name. Then I try to do a CFMAIL something like:

Dear #receiver_name#

</td></tr>

#form.message#

</td></tr>

</table>

</cfmail>

This seems to work with CFMAIL and the variables are being populated properly. However, when I placed the content into a template content.cfm because I want to use it somewhere else as well. So content.cfm has:

Dear #receiver_name#

</td></tr>

#form.message#

</td></tr>

</table>

and the program became:

</cfmail>

Now the problem is, I am NOT getting the variables (#receiver_name# and#form.message#) populated by Coldfusion when I use the cfinclue template. Why? This is driving me crazy. I don't know why it doesn't work. Thanks in advance.

Passing associated values with selected item in CFFORM?

forums_noreply@adobe.com — Tue, 30 Oct 2012 16:55:33 GMT

I query a database for names and different grades for subjects. For example, I requested for "Mary" and the database returns more than one "Mary". So I displayed the different "Mary" with a cfform and list all the "Mary" with a radio button and let user choose the right "Mary".

e.g.

cfquery...

if more than one student with same name then

<cfinput type=radio name=studentname value=#studentname#>#studentname#, #studentlastname#

....

</cfoutput>

</cfform>

Of course, I realize this will not work because if there are 10 "Mary" and I select the first "Mary", the application will not know which math, physic grades etc. belong to the first "Mary". Since I have already done the database query with all the information retrieved, I don't want to do a database query again. How do I pass the all the information belong to the chosen "Mary" to the "nextprogram"? This is probably very easy to do with different CF tag, but I haven't used Coldfusion for a while, so any help is appreciated. Thank you.

Jack

Some images not displayed on localhost

forums_noreply@adobe.com — Sat, 12 Nov 2011 19:27:27 GMT

I just recently installed CF on my own computer as localhost with Apache. When I call a Coldfusion page in http://localhost/main.cfm it will show the text and some images. However, it will not show all the images. All the images are stored under the local htdoc/images, which should be http://localhost/images/myimage.jpg. The weirdest thing is that some small images are being displayed while the larger images are not being display in the main.cfm They are all being called the same way e.g. <IMG SRC="images/myimage.jpg"> or <IMG SRC="images/myimage2.jpg"> etc. Does anyone know why this is happening?

Also if I reference it directly http://localhost/images/myimage.jpg etc on the browser, it will display an error message that says "The image http://localhost/images/myimage.jpg" cannot be displayed because it contains errors". This happens to most images. The images will display on live site when I uploaded. So I am totally puzzled.

MYSQL SELECT WHERE IN issue

forums_noreply@adobe.com — Sun, 13 Mar 2011 00:09:43 GMT

I am trying to use the WHERE fieldname IN ("#form.names#") but it won't work.

I know for example:

SELECT *
FROM tablename
WHERE
fieldname IN ('US,UK,GB,CN');

will NOT work, but

SELECT *
FROM tablename
WHERE
fieldname IN ('US','UK','GB','CN');

will work.

But here is my problem. I get the list from a form with checkboxes, so they are stored in a form variable call form.names. The form.names value is US.UK,GB,CN etc. So if I put

SELECT *
FROM tablename
WHERE
fieldname IN (#form.names#);

nothing will work, because there is no quotes around it but if I put the quotes

SELECT *
FROM tablename
WHERE
fieldname IN ("#form.names#");

will work ONLY if the list has one item. When there is more than one like the above, it won't work at all.

How can I manipulate the #form.names# so that each item will have quotes around it? Any help is appreciated.

Find a string within a field

forums_noreply@adobe.com — Wed, 17 Nov 2010 01:37:31 GMT

This may be easy but I am new to this so here it goes. I am trying to find if a string can be found in a mysql database field.

The following will only find exactly match

    <CFQUERY DATASOURCE="databasename">
    SELECT mycontact, userid
    FROM mytable
    WHERE email = #form.email#'

</CFQUERY>

The following will return result if the field email is contain in the form.email

    <CFQUERY DATASOURCE="databasename">
     SELECT mycontact, userid
     FROM mytable
     WHERE email like '%#form.email#%'

</CFQUERY>

But these will not give what I want. I want the reverse of the above. The email fied can contain MORE than one email addresses. I want to be able to enter a value i.e. form.email and search the table and find any record in the "email" field that contain form.emal. Help is appreciated. I am using MYSQL database. Thanks.

TO not working as described

forums_noreply@adobe.com — Tue, 26 Oct 2010 22:27:12 GMT

I have been using <CFMAIL> tag for a while, as follows:

<CFMAIL TO="#toemail#" FROM="#form.email#" SUBJECT="Inquiry"> etc.

The #toemail# can be a single email or more than one email. The problem is with multiple emails. In old CF version 5 when the database value for #toemail# is "me@domain.com, you@domain.com", it will send it successfully. However in CF8 the space between the two emails are removed automatically. Even though these 2 email addresses are seperated by a comma, CF8 will NOT sent out the emails to the two email addresses. It throws in an "Invalid Addresses" in the error log and will not send the email. What to do? It seems like a bug in CF8 to me.

Your help is appreciated.

with Required="Yes" not working

forums_noreply@adobe.com — Tue, 26 Oct 2010 01:41:39 GMT

I have this cfselect:

<CFSELECT name="country" SIZE="1" REQUIRED="Yes" message = "Please select a country">
                  <OPTION value=" ">Choose a Country</OPTION>
                  <OPTION VALUE="AF">Afghanistan [AF]</OPTION>
                 <OPTION VALUE="AL">Albania [AL]</OPTION>
                 <OPTION VALUE="DZ">Algeria [DZ]</OPTION>
               etc.

</CFSELECT>

However, according to CF8 manual on the Required parameter:

Note: This attribute has no effect if you omit the size attribute or set it to 1, because the browser always submits the displayed item. You can work around this issue: format forms by having an initial option tag with value=" " (notice the space character between the quotation marks).

yes: a list element must be selected when the form is submitted.
no

I tried to "work around" with and without the SIZE but CF still will NOT detect that the user did not select a country. What is wrong? The screen displays Choose a Country and it will pass.

Error Executing Database Query - Help!

forums_noreply@adobe.com — Fri, 22 Oct 2010 21:27:07 GMT

I have a cfquery code that looks like this:

    <CFQUERY DATASOURCE="mydatabase" USERNAME="myuser" PASSWORD="mypassword" NAME="codelist" CACHEDWITHIN="#CreateTimeSpan(0,1,0,0)#">
    SELECT *
    FROM systemcode
    WHERE (LEN(TRIM(systemcode)) = 2 OR LEN(TRIM(systemcode)) = 4)
    <CFSWITCH EXPRESSION="#CAT#">
    <CFCASE VALUE="1">AND (MID(systemcode,1,2) BETWEEN '01' AND '05')</CFCASE>
    <CFCASE VALUE="2">AND (MID(systemcode,1,2) BETWEEN '06' AND '15')</CFCASE>
    <CFCASE VALUE="3">AND (MID(systemcode,1,2) BETWEEN '16' AND '24')</CFCASE>
    <CFCASE VALUE="4">AND (MID(systemcode,1,2) BETWEEN '25' AND '27')</CFCASE>
    <CFCASE VALUE="5">AND (MID(systemcode,1,2) BETWEEN '28' AND '38')</CFCASE>
    <CFCASE VALUE="6">AND (MID(systemcode,1,2) BETWEEN '39' AND '40')</CFCASE>
    <CFCASE VALUE="7">AND (MID(systemcode,1,2) BETWEEN '41' AND '43')</CFCASE>
    <CFCASE VALUE="8">AND (MID(systemcode,1,2) BETWEEN '44' AND '49')</CFCASE>
    <CFCASE VALUE="9">AND (MID(systemcode,1,2) BETWEEN '50' AND '63')</CFCASE>
    <CFCASE VALUE="10">AND (MID(systemcode,1,2) BETWEEN '64' AND '67')</CFCASE>
    <CFCASE VALUE="11">AND (MID(systemcode,1,2) BETWEEN '68' AND '71')</CFCASE>
    <CFCASE VALUE="12">AND (MID(systemcode,1,2) BETWEEN '72' AND '83')</CFCASE>
    <CFCASE VALUE="13">AND (MID(systemcode,1,2) BETWEEN '84' AND '85')</CFCASE>
    <CFCASE VALUE="14">AND (MID(systemcode,1,2) BETWEEN '86' AND '89')</CFCASE>
    <CFCASE VALUE="15">AND (MID(systemcode,1,2) BETWEEN '90' AND '97')</CFCASE>
    <CFCASE VALUE="16">AND (MID(systemcode,1,2) BETWEEN '98' AND '99')</CFCASE>
    <CFDEFAULTCASE><CFLOCATION URL="somewhere.htm"></CFDEFAULTCASE>
    </CFSWITCH>
    ORDER BY systemcode
    </CFQUERY>

This works perfectly in CF 5. However, when running in CF 8 I am getting the error message:

Error Executing Database Query.FUNCTION mydatabase.LEN does not exist The specific sequence of files included or processed is: /home/httpd/vhosts/somedomain.com/httpdocs/reference/systemcode.cfm, line: 24

(that refers to the above cfquery)

"mydatabase" is the name of the database and LEN is a function. It's checking for the length of systemcode to be 2 or 4, if they are then check if the value of #CAT# is 1 and that the first 2 characters is between 01 and 05 then select the row. I don't know why it works with CF5 but not CF8? It's driving me nuts. Any help is appreciated.