Adobe Community : All Content - All Communities

Setting/changing a date in application.cfm

forums_noreply@adobe.com — Tue, 14 Oct 2014 18:39:15 GMT

I need to be able to set a date in the application.cfm file

for example

Then in my site on other pages I have code that says

The problem is sometimes I need to change the APPLICATION.stopdate to another date during the middle of the day.

For example I need to change the APPLICATION.stopdate from 10/15/2014 to 10/25/2014

However I notice when I change the APPLICATION.stopdate in the application.cfm to another date during the middle of the day that the APPLICATION.stopdate stays the old date.

How do I make sure that the APPLICATION.stopdate changes sitewide when I change it in the application.cfm?

Do I use another variable scope?

How to convert minutes to decimal

forums_noreply@adobe.com — Mon, 30 Jun 2014 16:16:50 GMT

I need to convert my minutes in my HH:MM record to decimal.

For example if I have 43 hours and 15 minutes (43:15) I need to return the result 43.25 hours

and if i have 10 hours and 30 minutes I need to return 10.50 hours.

How do I do this?

CFIF today is between dates do this?

forums_noreply@adobe.com — Thu, 05 Jun 2014 10:08:25 GMT

So here is the logic I have I just can t figure how to code

If the date is between 5/31/2014 after 3:00 PM and 6/7/2014 up to 3:00PM

If the date is between 6/7/2014 after 3:00 PM and 6/14/2014 up to 3:00PM

If the date is between 6/14/2014 after 3:00 PM and 6/21/2014 up to 3:00PM

I know I could code all of the weeks but isn't there a way to do this with a loop when you have know starting date 5/31/2014 and time and set length 7 days?

Get all records updated in last 15 minutes

forums_noreply@adobe.com — Fri, 23 May 2014 12:58:02 GMT

I need to query and get all records that have been updated in the past 15 minutes.

Ive tried in CF and MS SQL

Here is what I have that doesn't work

SELECT * FROM job_clock WHERE Job_Time_Out > dateadd(minute,-15,CURRENT_TIMESTAMP)

How to extract last name from a string

forums_noreply@adobe.com — Thu, 03 Apr 2014 18:42:33 GMT

I have SQL query that returns last name of a person and I need to extract the last part of any hyphenated or last names with a space in them

In cases where the person has one last name everything is OK

Like Smith. That OK. . I am looking for just Smith

The problem I have is when I have hyphenated last names like Scott-Thomas

In that case I want to extract the last last name or Thomas.

Or if I have a last name like Rodham Clinton.
In that case I only want to extract the last last name Clinton.

How do I do this?

Concatenate date time and update SQL datetime field

forums_noreply@adobe.com — Tue, 11 Mar 2014 17:19:04 GMT

I have a form that captures date and time in 2 separate fields data and time.

I need to combine these fileds and UPDATE a SQL database (datetime field)

The date field is passed like this DSDATE={ts '2013-11-18 00:00:00'}

The time field is passed like this TIME_IN1=14:05

How do I concatenate DSDATE AND TIME_IN1 so that I can insert like this 2013-11-18 14:05:00.000 ?

CFLOCATION question

forums_noreply@adobe.com — Thu, 06 Mar 2014 20:21:51 GMT

I have urls that have been changed and I need to relocate users to the new url.

I have been using this code.

</cfif>

This code works but anytime I add a new page to newsite I also need to add a copy of the page to the old site or a get a 404 error.

Is there a way I can say if a user comes to my site to this url http://www.mysite.com/abc/thispage.cfm that they can be automatically redirected to

http://www.mysite.com/newsite/abc/thispage.cfm?

Basically redirect to the pagename in the new directory without having the page at the old location also.

How to handle NULL or blank XML fields

forums_noreply@adobe.com — Tue, 04 Feb 2014 17:50:33 GMT

I am parsing an xml file and turning it into a query object. Everything good until I get a NULL or misssing value in my XML file and then I start getting error messages like

The value '' cannot be converted to a number.

So how can I check for these missing or NULL values in the XML and then set them to a value want so they dont keep appearing as ''?

Here is my code: It runs great until i hit a missing value

<cfset temp = QuerySetCell(orderquery, "FIRST_NAME",

#mydoc.rowset.ROW[i].FIRST_NAME.XmlText#, #i#)>

<cfset temp = QuerySetCell(orderquery, "LAST_NAME",

#mydoc.rowset.ROW[i].LAST_NAME.XmlText#, #i#)>

<cfset temp = QuerySetCell(orderquery, "FILE_NUMBER",

#mydoc.rowset.ROW[i].FILE_NUMBER.XmlText#, #i#)>

<cfset temp = QuerySetCell(orderquery, "JOB_TITLE_DESCRIPTION",

#mydoc.rowset.ROW[i].JOB_TITLE_DESCRIPTION.XmlText#, #i#)>

</cfloop>

Query problem when switching from Access to MS SQL

forums_noreply@adobe.com — Fri, 15 Nov 2013 17:37:27 GMT

I have this query which worked great in Access

SELECT e.wall +l.wall As wall2yr, e.lall +l.lall As lall2yr, l.TEAMID, l.TEAMNAME, l.GY AS LaterGY, l.finalrating AS LaterFinalRating, e.finalrating AS EarlyFinalRating, e.GY AS EarlyGY, LaterFinalRating+EarlyFinalRating AS twoyear FROM TEAMSEASONRATINGINFO AS e INNER JOIN TEAMSEASONRATINGINFO AS l ON l.teamID = e.TeamID AND l.GY = e.GY+1 WHERE l.GY =#url.GY# AND e.finalrating > 0

AND l.DIVISION = #url.DIVISION#

ORDER BY e.finalrating+ l.finalrating DESC

Now I have switched to MS SQL and I am geting this error

[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'LaterFinalRating'.

Is there something different the way MSSQL handles INNER JOINS or aliases?

Hyphen in XML row name causing problems

forums_noreply@adobe.com — Fri, 10 Jan 2014 20:41:47 GMT

I have an xml file that I am trying to turn into a qury object so I can have the query interact with my SQL database

The XML file has 15 rows and I have successfully got 13 of them into a query.

The problem is that the remaining 2 fields have hyphens or dashes - in the row names. Like (WORK_E-MAIL)..See the - between E-Mail

So when I go to set the value in the query with this code

<cfset temp = QuerySetCell(orderquery,"WORK_E_MAIL",

#mydoc.rowset.ROW[i].WORK_E-MAIL.XmlText#, #i#)>

I get this error message

Error Occurred While Processing Request

Invalid construct: Either argument or name is missing.

Is there some way to alias the row name with the hypen, maybe like this {WORK_E-MAIL} or like this [WORK_E-MAIL]

I need to ge these 2 hypenated named rows into my query.

Any ideas?

3rd Party Software for Charting

forums_noreply@adobe.com — Thu, 24 Feb 2011 03:07:31 GMT

Can anyone recommend 3rd Party Software for Charting (pie chart, bar chart etc)

I have tried to use the Cold Fusion charts <CFCHART> etc..... but they just dont create professional looking charts.

I bought Fusion Charts.

It worked great for a while.

But the charts dont render on IPADS and now they have printing issues.

So now I have decided to start anew.

I want charting software that outputs to professional looking JPG, GIF or PNG images (NO FLASH!!)

Does anyone have any suggestions for 3rd Party Software for Charting that integrates well with my existing cold fusion pages?

Secure CFIDE directory & functionality to use cfdocument, cfpdf

forums_noreply@adobe.com — Mon, 16 Dec 2013 16:04:25 GMT

Looking for your advice on the best way to create a secure CFIDE directory that will allow me to have full functionality to use cfdocument, cfpdf etc...

My understanding is that certain folders within that need to web accessible for cfchart,cfform,cfdocument to work, is that correct?

We have had security issues and my hosting company has denied users access to the cfide directory and now I am getting erros when I try and merge PDF docs ...I am sure there are others I havent found yet too.

An error occurred during MERGE operation in the cfpdf tag.
Error: Access is denied

java.io.IOException: Access is denied

at java.io.WinNTFileSystem.createFileExclusively(Native Method)

at java.io.File.checkAndCreate(File.java:1704)

at java.io.File.createTempFile(File.java:1792)

at coldfusion.pdf.PDFDocHandler.writeDocument(PDFDocHandler.java:900)

at coldfusion.pdf.PDFDocHandler.writeDocument(PDFDocHandler.java:866)

at coldfusion.pdf.PDFDocHandler.writeDocument(PDFDocHandler.java:847)

at coldfusion.pdf.PDFDocOperation.merge(PDFDocOperation.java:524)

at coldfusion.tagext.lang.PDFTag.doEndTag(PDFTag.java:1534)

Etc...............

Anyway what is Adobe's official solution to this issue?

Either I leave the CFIDE unsecured and the cfdocument, cfpdf ...work

I lock down the CFIDE directory and lose the functionality for creating PDFS and other things.

Any ideas?

UNION Query

forums_noreply@adobe.com — Fri, 15 Nov 2013 17:54:44 GMT

I have a union query like this that gets info from 2 different tables

Like this

SELECT ID,CityName, SUM(people) AS sump FROM table 1

GROUP by ID,CityName

UNION

SELECT ID,CityName, SUM(people) AS sump FROM table 2

GROUP by ID,CityName

ORDER BY SUM(people)

</cfquery>

So what I want is the sums from both tables but what I get is the sums of each table.

For example I get

ID-CityName-sump

1- New York -3

1-New York- 4

2-Chicago -5

2-Chicago -6

What I want is
ID-CityName-sump

1-New York- 7

2-Chicago -11

Do I need to do another query after the union query?

Improve Poor Performace with SQL 8 database

forums_noreply@adobe.com — Wed, 10 Jul 2013 01:48:04 GMT

I just migrated my last MS Access database over to SQL Server 8 database.

I have tables with 100-20,000 rows in them.

My question is what can I do to improve performance (page load time)?

I have pages that are taking 10 seconds to load that took 2 seconds with Access...I expected improvement with MSSQL.

I have indexed tables etc...

Is there something in the CF code I need to modify also.

I am using CF9

Clear All Session Variables at end of day

forums_noreply@adobe.com — Tue, 25 Jun 2013 20:52:41 GMT

I have an application that at the end of the day 12:00 midnight I need all session.variables to expire and thus force my users to relogin.

WIll this code end all of my user sessions?

</cflock>

Migrated to CF9 and now have CFCACHE problems

forums_noreply@adobe.com — Tue, 25 Jun 2013 03:25:31 GMT

I have been page caching on my site for years using this code:

<cfcache timespan="#CreateTimespan(10, 0, 0, 0)#" directory="D:/websites/mysite/cache/" stripWhiteSpace="true">

This worked great - it would keep a cached copy in the cache directory and would stay cached for 10 days.
Good stuff!!

Now I've had to switch servers and up to CF9. I still want to cache my pages but I just cant seem to get it right.

I am now using this code

<cfcache timespan="#CreateTimespan(10, 0, 0, 0)#" useQueryString ="true" stripWhiteSpace="true">

But the pages dont cache in the cache directory and they dont seem to load faster as if they were cached.

Am I doing his right?

Am I even caching the pages?

I'd like to keep a copy in my cache directory is that possible?

CFSET time to today at 9:00PM

forums_noreply@adobe.com — Fri, 21 Jun 2013 23:02:24 GMT

I need to update my SQL database at the end of each day for certain records.

The time needs to be 9:00 PM each day (dont worry about time differences)

So for today I need to insert '2013-06-21 21:00:00' into the db.

So I wantd to set the time before I inserted it.

How do I do that?

How do I get 9:00 PM each day?

Alias a field name in a join query

forums_noreply@adobe.com — Mon, 17 Jun 2013 19:17:59 GMT

I have a database with spaces in the field names (not my fault).

I am having a problem with the query because one of the fileds I am joining on has a space in its name. See bolded text.

SELECT *

FROM employee_passwords

INNER JOIN employee_general_info

ON employee_passwords.Employee_ID=employees.[Employee ID]

WHERE username = '#username#' AND password = '#password#'

So I get this error message

Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'employees.Employee ID'.

Is there a way to alias the employees.[Employee ID] field?

CFMail server options

forums_noreply@adobe.com — Thu, 30 May 2013 13:13:10 GMT

I have a CF form that when posted sends an email with an attachment from our website to an email specified in the form.

The email is sent using the CFMAIL tag.

Pretty straight forward.

Now for compliance reasons I need to keep records of what was sent to whom and when.

Ideally I'd like to run the emails though our mail server and not the CF server.

Is something like that possible?

String Functions to extract first name initial and first 5 letters of last name

forums_noreply@adobe.com — Wed, 24 Apr 2013 17:18:42 GMT

I am trying to extract the first letter of a firstname and the first 5 letters off a last name and concatate the two values

For example I have a data field with "John Smith" in the field.

I want to get the first letter of the first name - "John" = J

I want to get the first 5 letters of the last name- "Smith" = smith

and then concatate the 2 values = jsmith

another example

For example I have a data field with "Reese Witherspoon" in the field.

I want to get the first letter of the first name - "Reese" = R

I want to get the first 5 letters of the last name- "Witherspoon" = withe

and then concatate the 2 values = rwithe

How would I do that ?

I think I know how to do each step individually but is there a better way to get the value?

Disallow access to certain directories

forums_noreply@adobe.com — Sat, 20 Apr 2013 11:58:02 GMT

I have a directory on my server named "documents" that I need to make sure users are authenticated (logged in) before they can access this directory.

The directory contains PDF documents.

Whats happening is that users are bypassing the log in process and directly accessing documents in this documents directory.

When my users log in a SESSION variable "allowin" gets set.

Normally I have an application.cfc or application.cfm file that will redirect the user to the login page if they dont have the session created.

For example if a user tried to access the site directly with a link and not log in they would not be allowed in and be redirected to the log in page.

Thats because the application runs each time a cfm page runs.

But when a user accesses the site at http://www.mysite.com/documents/test.pdf they get in because the application.cfm doesnt run and enforce the SESSION rule.

Because there is not an application.cfm file in the documents directory.

Any ideas on how to use CF to boot users to a login page that try to access a directory that does not contain an application.cfm or .cfc file?

Alias URLS based on directory - Redirect

forums_noreply@adobe.com — Wed, 17 Apr 2013 16:46:37 GMT

I have 5 directories in my site that for organizational purposed I copied into one directory named usersites so they all would be in one place.

So I had these 5 directories before the change

website1

website2

website3

website4

website5

So before the change when my users accessed my site they would access these directories like this

www.mysite.com/website1/mypage.cfm or www.mysite.com/website2/mypage.cfm etc

So now after the change the directories are in the usersites directory at

www.mysite.com/usersites/website1/

I dont want to tell all of my users that they need to change their existing urls from

www.mysite.com/website1/pagename.cfm to www.mysite.com/usersites/website1/pagename.cfm

Is there a way that when one of my users accessess the old directory that they will automatically be redirected to the new directory?

Maybe something in the application.cfm?

Just to make sure when a user comes in here www.mysite.com/website1/test.cfm I want them to gets redirected to www.mysite.com/usersites/website1/test.cfm

Thank you!

Set up FileMaker DSN is Cold Fusion administrator

forums_noreply@adobe.com — Thu, 11 Apr 2013 15:49:38 GMT

I am trying to set up a dsn to filemaker pro 11 database in the cf administrator.

I am at the Datasources > Other screen

and there are questions there that I know I dont have answered correctly.

Here is the error message I get.

"No suitable driver available for xxxx, please check the driver setting in resources file, error"

I am using CF9.

I have already successsfully setup the dsn in the 32bit ODBC Data Source administrator and successsfully connected to the Filemaker Server.

But to use it in CF pages I need to set it up inthe CF administrator, Right?

Reset Identity Column Value in SQL Server depending on whats being inserted

forums_noreply@adobe.com — Mon, 08 Apr 2013 15:52:32 GMT

I have a SQL Server 2008 database with a table that has an ID field that has an identity increment and seed of 1.

This work great as each new record created automatically gets a new and distinct number.

Now when I insert certain new records I need to be able to make that value start at 10001 and then the next would be 10002 etc.

But this is only for certain inserts.

Is there a way to control the identity seed & increment on the fly via a query maybe?

So some inserts would follow 1,2,3,4,5,6,7 depending on whats being inserted

and others would follow 10001,10002,10003 depending on whats being inserted.

is this possible?

How to access a certain date in SQL Server date/time field

forums_noreply@adobe.com — Tue, 12 Mar 2013 15:16:06 GMT

I have a field named job_date in a table in my SQL server 8 database.

The data type is datetime.

So the values for the fields look like this 2013-03-11 15:55:52.000.

How do I query this field to include only values from a certain date?

For example

SELECT job_name FROM job_info WHERE job_date= '03/12/2013'

</cfquery>

When I query the field now I get NO RECORDS.

Thats because the fields look like this 2013-03-11 15:55:52.000. instead of this '03/12/2013'

How do I access a certain date in SQL Server date/time field when its formatted like this 2013-03-11 15:55:52.000. ?

Concatate Date &Time values from a form & Do Insert

forums_noreply@adobe.com — Thu, 07 Mar 2013 01:35:21 GMT

I am trying to combine a date value and a time value from a form submission into one datetime value and then insert it into a SQL server 8 data table.

Here are the formats

Date : 03/07/2013

Time : 08:07 PM

So somehow I need to concatate these 2 items and then insert the combined value into a SQL server 8 data table. (datetime Data Type).

The inserted value should look like this

2013-03-07 20:07:00.000

Any help my dear cold fusion brothers?

Remove item from numeric list

forums_noreply@adobe.com — Thu, 28 Feb 2013 20:31:43 GMT

Lets say I have a numeric list like this.

mylist ="1,5,11,17,19"

Now I need to remove just 11 from the mylist. (delete_value = 11)

How do I remove the delete_value from mylist

Its like the opposite of ListAppend?

So I need the new list to be ("1,5,17,19")

Previous /Next Day

forums_noreply@adobe.com — Thu, 07 Feb 2013 15:53:38 GMT

I have a page where the day and date is displayed like this.

< Previous Day - Wednesday January 23, 2013 > Next Day

How do I make it so when the userclicks on < Previous Day link that they go to Tuesday January 22, 2013 and when they lick on > Next Day they go to Thursday January 24, 2013 etc?

Using multiple images as submit buttons

forums_noreply@adobe.com — Wed, 06 Feb 2013 20:09:13 GMT

I have this form with 2 images as submit buttons

<INPUT TYPE="image" SRC="assets/images/lgstart_b.png" ALT="Submit Form" name="time_in">
<INPUT TYPE="image" SRC="assets/images/lgstop_bo.png" ALT="Submit Form" name="time_out">

The problem is I can tget the next page to acknowldge either button. I am using CF9

Here is the form2.cfm page

TIME IN

TIME OUT

Nothing

</cfif>

I get an 'undefined' message only

I know I have done this before what am I missing?

Here is the form with the 2 images as submit buttons

<tr>

<td align="center" class="crewlist_time"><strong>Status</strong></td>

</tr>

<tr>

<td class="crewlist_cell"> #EMPLOYEE_NAME# </td>

<div class="clockin">Clock In</div>

</div>

<div class="clockin">Clock Out</div>

</div>

</div></cfoutput>

<br>

</form>

CFCACHE IN CF9 - Cant find cached pages!

forums_noreply@adobe.com — Fri, 01 Feb 2013 17:43:35 GMT

I have used CFCACHE in prior versions of CF and the cached page would be kept in the directory I specified.
Now when I use the tag in CF9 the page appears to be cached but I can find any cached pages in the directory I specified????

Here is my code:

The page appears to be cached as it loads quickly but I cant find where CF puts the cached version.

This is a problem because when I need to flush the cache I dont know which directory to flush.

Any idea where my cached pages are?

Error message when saving a file in DW -CS6

forums_noreply@adobe.com — Sun, 06 Jan 2013 02:33:14 GMT

When I go to save a file in Dreamweaver CS6, using Windows 7 -

I get this error message.

"While Executing onLoad in bc_afterSave.htm, the follwing javascript errors occured"

In File "bc_aftersave.htm";

onload is not defined

Everything was fine for years now I get this annoying error message. The file saves but the error message always pops up.

I am using the Adobe Application Manager and getting my software through the Adobe Cloud.

I tried deleting the configuration file with th expectation that DW would automatically create a new one but that did not work.

I'd hate to have to unintsall and reinstall DW because I have dozens of sites that I would need to resetup

Any help on this??

CFCACHE in CF8

forums_noreply@adobe.com — Wed, 15 Aug 2012 20:48:23 GMT

I just started using cfcache on my site and its really helped my site's performance.

But now I have a cache directory with 8000+ .tmp (cached pages) files and using 1 GB of server space.

I would like to manually delete some of these files from the cache directory but I don't want to delete pages that might be popular.

I'd like to delete rarely accessed pages from the cache directory to reduce the size of the cache directory.

I thought there was mapping file ....maybe ...cfcache.map that listed the page name being cached and the corresponding tmp file.

Where could I find the mapping file that lists the page name being cached and the corresponding tmp file?

I am using CF8.

thanks

CGI variables -

forums_noreply@adobe.com — Wed, 15 Aug 2012 21:18:40 GMT

I need to find code that if a user is using Internet explorer 5, Internet explorer 6, Internet explorer 7 or Internet explorer 8 they get redirected to one page and if the are using any other browser including IE9 they go to another.

Something like this

</cfif>

Any help ?

Notice when user enters domain

forums_noreply@adobe.com — Sun, 15 Jul 2012 13:46:30 GMT

Is there CF code that I could put in a page, maybe the application.cfm that would show the user a message instead of the actual page?

I had a site www.abc.com that I closed down but I need to leave the pages on the server.

I want it so that when a user enters the www.abc.com domain that they get a message that the site is closed instead of the actual page.

I want the user to get the message if they go to the homepage of www.abc.com or if they go to any page in the site.

For example www.abc.com/folder/index.cfm.

Any suggestions?

Can anyone tell me where the mailsent.log is archived?

forums_noreply@adobe.com — Mon, 16 Apr 2012 21:06:30 GMT

I archived my mailsent.log and I cant find where the archived file is located.

Can anyone tell me where the mailsent.log is archived?

","","ALL")>

forums_noreply@adobe.com — Fri, 13 Jan 2012 22:33:57 GMT

I am trting to replace the words </div></div> with "" from a string that I have.

I am using the code <CFSET mystring2 =Replace(mystring1,"</div></div>","","ALL")> and the tag does not replace </div></div> from my string.

Ive been a CF proogrammer for 15 years and used this tag hundreds of times but I cant figure out why the Replace tag wont Replace </div></div>.

I dont even need to replace them I could just remove them.

Any help on removing the </div></div> from my string or replacing it with ""?

Contibute absolute/relative links -Broken links and page wont render

forums_noreply@adobe.com — Mon, 19 Dec 2011 19:18:14 GMT

When I edit a page from the root level of my site for review in Contribute the page is created in a temporary folder within my site and so by placing the file from the root directory in a folder all of the include links break.

for example in the good file the link would be <img src="images/....>

when the new file is created for review the new file is created inside a folder named something like default_cfm_MMtmp50a31b4a.

So when the file is sent for review none of the links show up because the <img src="images/....> is pointing to the wrong place

2 Questions .

1.Why does Contribute need to create the file in a directory?....

Couldn't the temporary file just be created in the same level as orginial file. Thus the links wouldnt break.

2.When the temporary file is created in the temporary folder ...use absolute links instead of relative.

Anybody know?

Slow down cfloop query -Is there a way to slow down the cfloop query?

forums_noreply@adobe.com — Mon, 12 Sep 2011 15:49:41 GMT

I have a query

   <cfquery name="score" datasource="cdb" cachedwithin="#createTimespan(0,0,0,0)#">
      SELECT * FROM cds_master WHERE gw =3
      </cfquery>

I want to loop through and output the results, but when I do it loops so quickly you cant even see the output.

Is there a way to slow down the cfloop query?

Here is the current code

</cfloop>

Proposed

<cfoutput>#data#</cfoutput>....hesitate 10 seconds

</cfloop>

CFPDF populate existing PDF

forums_noreply@adobe.com — Mon, 22 Aug 2011 17:45:02 GMT

I have an existing pdf that I did not create.

The pdf has 2 form fields

"myname" and "yourname".

I need to capture "myname" and "yourname" in a form and then output those values to the existing pdf and then output the pdf.

Is there a way to write those variables to the pdf and then output the pdf.

Step 1

Form page

User enters "myname" and "yourname" and clicks submit

Step 2

User clicks link to get the pdf that will contain "myname" and "yourname"in the appropriate places.

I can use <cfpdf action="merge" to get the pdf to output, but I cannot get my form variables to output.

They just show up blank.

When I try to use this code below to populate the PDF. I get an error

This error:

The requested template has been denied access to /C:/ColdFusion8/runtime/../lib/cf-acrobat.jar.

The following is the internal exception message: access denied (java.io.FilePermission /C:/ColdFusion8/runtime/../lib/cf-acrobat.jar read)

Any ideas?

Custom 404 Page Problem -CF 8

forums_noreply@adobe.com — Wed, 17 Aug 2011 20:12:59 GMT

I'm having problems with a custom 404 page. CF8

I have create a page 404.cfm that I want users to see if they get a 404 error.

I changed the custom 404 page in the CF admin and this custom page works well when the page is an htm page.

But does not work when the page is a cfm page.

of course all of my pages are cfm pages.

How do I make sure my users get the 404.cfm page when there is a 404 error but

any kind of error ...like bad cfml, etc......?

Do I need to add something to the application .cfc??

Keep Session Alive

forums_noreply@adobe.com — Fri, 05 Aug 2011 20:21:46 GMT

Step1: A partner firm passes xml values to me via url and thi has a session variable from his server.

Step2: I need to take that xml data and run a query on it to get additional values.

Step3: After the query I need to send back xml to my partner firm, AND I NEED TO KEEP THE SESSION VARIABLE ALIVE FROM WHEN HE SENT IT TO ME in Step 1 and pass back my xml in the same SESSION!!!

Here is the code I have now in Step 3

</cfhttp>

According to my partner firm my xml is getting back to their server but since I dont have the same SESSION from Step 1 it gets rejected.

I guess the <cfhttp> that I send back in Step 3 starts a new Session...so the original session that oartner sent in Step 1 is gone.

Is there a way to keep the session from Session 1 and use that same session in step 3?

Do I need to use a different tag a different technolgy a different coding language??

I have spent all week on this..this is something that should have taken a few hours.

My Partner firm tells me that other firms/programmers have had no issue implementing this and I must be doing somethin wrong.

I have read the BEN NADEL stuff about this about trying to somehow capture the Session variable in Step 1..then do Step 2....then pass the Session variable back with the xml data....it made sense to me.

But partner firm says that wont work...so I stopped pursuing .

Am I just stupid...Am I missing something..Do I need to buy custom tag???

Any Help???

XML Problem

forums_noreply@adobe.com — Mon, 01 Aug 2011 19:29:07 GMT

A partner firm needs to pass me some xml information and I need to get that info and run queries with the UserID in the passed info.

They pass me this xml

<UserId>phutch</UserId>

</Header>

</Request>

I am trying to retrieve the UserId from the xml file using <cfdump var="#GetHttpRequestData()#">

I was hoping that I could get the xml info from the GetHttpRequestData() tag but I get an error message

"The markup in the document following the root element must be well-formed.

Nested exception: The markup in the document following the root element must be well-formed."

I think the error might be because this line of code is not at the beginning of the xml passed to me.

<?xml version="1.0" encoding="iso-8859-1"?> or

<?xml version="1.0" encoding="utf-8"?>

Anyway. Does anyone have any ideas on how I could extract the UserId from the above xml?

Extract And SET Values from XML File

forums_noreply@adobe.com — Wed, 03 Aug 2011 16:23:00 GMT

I have XML string like this

How can I extract the <UserId> and <Token> values only?

So for the above string --I want the values

pgh

05032015T1105144

I want to set these 2 values to variables like this...everything else in the string goes away

So you START with this

<Request><Header><UserId>pgh</UserId><Token>05032015T1105144</Token></Header></Request>

And END with this

<CFSET userid =pgh>

<CFSET token = 05032015T1105144>

cf extract substring after url

forums_noreply@adobe.com — Tue, 26 Jul 2011 14:36:04 GMT

While loopong through query results I am trying to extract the page name from a url.

From this sample url ------- http://www.cnn.com/sports.cfm

I want to extract the name sports.cfm only

From this sample url ------- http://www.msnbc.com/shows.asp

I want to extract the name shows.asp only

New to .cfc files : Do I have to register application.cfc with CFadministrator?

forums_noreply@adobe.com — Wed, 23 Mar 2011 19:30:45 GMT

I am using an application.cfc file for the first time ands I cant seem to get it to work.

Do I need to register the application.cfc in the CF administrator in order for it to work?

I actually have 2 cfc files application.cfc and mylist.cfc

Do I need to register both of these in the CF administrator?

Using Spry Assets form validation tools to exclude certain email addresses

forums_noreply@adobe.com — Thu, 17 Mar 2011 23:20:59 GMT

Is there a way for spry assets to check an emaill address and if it contains either a yahoo.com or gmail.com email address ....return an error message?

I am trying to exclude yahoo.com or gmail.com email addresses

But I am having to this email validation server side instead of client side with spry assets like I validate all of the other form fields.

Code

<span class="textfieldRequiredMsg">Please enter your email address.</span>

<span class="textfieldInvalidFormatMsg">Please enter a valid email address.</span> </span>

Id like to think I could add another something like this

<span class="textfieldInvalidFormatMsg">We do not support email addresses ( @yahoo.com, @gmail.com, @comcast.com, @hotmail.com).
Please enter a valid email address.</span>

Is there any way I can use spryassets validation tools to do client side validation to check for email extensions?

Keep Form Values in Mozilla Browsers after server side validation

forums_noreply@adobe.com — Thu, 17 Mar 2011 23:05:28 GMT

I have a 10 field form that wont keep the form values if the user has an error and has to go back to correct the form.

This appears to be a Mozilla issue only as IE apparently keeps the values.

I tried using <CFHEADER NAME="cache-control" value=7200> but that does not work.

I also tried <cfform name="form2.cfm" method="post" preservedata="yes"> and that didnt work either.

Example:

Step 1 User completes form1.cfm

Step 2 User submits form1.cfm to form2.cfm and gets this validation error for example

"Your email cannot include yahoo.com. Please go back and choose a different email address"

I use <a href="javascript:history.go(-1)">go back</a> to go back

Step 3 User clicks "Go back"

Step 4 Users returns to form and finds that his form data is gone and now needs to start the form all over.

Step 5 User is mad that they need to complete form again.

Is there anything I can do keep the form values?

Forms :

forums_noreply@adobe.com — Tue, 08 Mar 2011 20:22:26 GMT

I have a form that I need to post the info to 2 different places like this

STEP 1

<form action="enroll1.cfm" method="POST" id="1">
10 Form Fields
</form>

>>>>> Do Database insert

STEP 2

Now I need to take that same form info and post it to another url so that it can be inserted in another database at another company.

Like this

<form action="enroll2.cfm" method="POST" id="1">
10 Form Fields
</form>

>>>>> Do Database insert

I get the first form posted and the data gets inserted into the database but now how do I pass the 10 form fields to the other url (Step 2)?

Anyone recommend a Content Management System software that will work well with my existing site

forums_noreply@adobe.com — Thu, 24 Feb 2011 03:12:33 GMT

Can anyone recommend a Content Management System software that will work well with my existing cold fusion web site?

I have looked at coldbricks, getmura

My client has mentioned Joomla, EZPublish and Drupal.

Can anyone offer any suggestions for a Content Management System software that will work well with my existing cold fusion web site?

CFCONTENT Excel - Firefox errors

forums_noreply@adobe.com — Wed, 16 Feb 2011 16:02:15 GMT

When I use <cfcontent type="application/vnd.ms-excel"> tag it works great on Internet Explorer.

But when I use Firefox it doesnt

It does NOT name the file correctly (It doesnt have the xls extension) therefore it doesnt make the file association with the excel program.

and my users dont know to rename and add the extension.

Is there anything I can do about this?