<?xml version="1.0" encoding="iso-8859-1"?>

<rdf:RDF 
	xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
	xmlns="http://purl.org/rss/1.0/"
>

	<channel rdf:about="http://forums.forta.com/">
	<title>Forta Forums : Conference : Book Support</title>
	<description>Conference : Book Support : Support forums for my books</description>
	<link>http://forums.forta.com/</link>
	
	<items>
		<rdf:Seq>
			
				<rdf:li rdf:resource="http://forums.forta.com/messages.cfm?threadid=2D7CD4B5-CEFF-FB0B-926E56BE724C8E27&amp;r=1" />
				
				<rdf:li rdf:resource="http://forums.forta.com/messages.cfm?threadid=2D7CD4B5-CEFF-FB0B-926E56BE724C8E27&amp;r=2" />
				
				<rdf:li rdf:resource="http://forums.forta.com/messages.cfm?threadid=2D7CD4B5-CEFF-FB0B-926E56BE724C8E27&amp;r=3" />
				
				<rdf:li rdf:resource="http://forums.forta.com/messages.cfm?threadid=2D7CD4B5-CEFF-FB0B-926E56BE724C8E27&amp;r=4" />
				
				<rdf:li rdf:resource="http://forums.forta.com/messages.cfm?threadid=2D7CD4B5-CEFF-FB0B-926E56BE724C8E27&amp;r=5" />
				
				<rdf:li rdf:resource="http://forums.forta.com/messages.cfm?threadid=2FDA2439-9ED6-2278-E9B82AF5BC0E9C2F&amp;r=6" />
				
				<rdf:li rdf:resource="http://forums.forta.com/messages.cfm?threadid=2FDA2439-9ED6-2278-E9B82AF5BC0E9C2F&amp;r=7" />
				
				<rdf:li rdf:resource="http://forums.forta.com/messages.cfm?threadid=2FDA2439-9ED6-2278-E9B82AF5BC0E9C2F&amp;r=8" />
				
				<rdf:li rdf:resource="http://forums.forta.com/messages.cfm?threadid=2D7CD4B5-CEFF-FB0B-926E56BE724C8E27&amp;r=9" />
				
				<rdf:li rdf:resource="http://forums.forta.com/messages.cfm?threadid=2FDA2439-9ED6-2278-E9B82AF5BC0E9C2F&amp;r=10" />
				
				<rdf:li rdf:resource="http://forums.forta.com/messages.cfm?threadid=2FDA2439-9ED6-2278-E9B82AF5BC0E9C2F&amp;r=11" />
				
				<rdf:li rdf:resource="http://forums.forta.com/messages.cfm?threadid=2D7CD4B5-CEFF-FB0B-926E56BE724C8E27&amp;r=12" />
				
				<rdf:li rdf:resource="http://forums.forta.com/messages.cfm?threadid=296DA93E-B77B-8BB5-6498EC39B99049AE&amp;r=13" />
				
				<rdf:li rdf:resource="http://forums.forta.com/messages.cfm?threadid=BDD8977A-0D23-2AD8-904D037EB3207A12&amp;r=14" />
				
				<rdf:li rdf:resource="http://forums.forta.com/messages.cfm?threadid=F20D5E22-9B39-AC3F-FCE9DBAC0B436365&amp;r=15" />
				
				<rdf:li rdf:resource="http://forums.forta.com/messages.cfm?threadid=F20D5E22-9B39-AC3F-FCE9DBAC0B436365&amp;r=16" />
				
				<rdf:li rdf:resource="http://forums.forta.com/messages.cfm?threadid=F20D5E22-9B39-AC3F-FCE9DBAC0B436365&amp;r=17" />
				
				<rdf:li rdf:resource="http://forums.forta.com/messages.cfm?threadid=F20D5E22-9B39-AC3F-FCE9DBAC0B436365&amp;r=18" />
				
				<rdf:li rdf:resource="http://forums.forta.com/messages.cfm?threadid=F20D5E22-9B39-AC3F-FCE9DBAC0B436365&amp;r=19" />
				
				<rdf:li rdf:resource="http://forums.forta.com/messages.cfm?threadid=F20D5E22-9B39-AC3F-FCE9DBAC0B436365&amp;r=20" />
				
		</rdf:Seq>
	</items>
	
	</channel>

	
		
			<item rdf:about="http://forums.forta.com/messages.cfm?threadid=2D7CD4B5-CEFF-FB0B-926E56BE724C8E27&amp;r=1">
			<title>RE: System Configuration Problem</title>
			<description>I&apos;ve done all that -- relocated to something else.  And, TstLoops is initiated correctly if I change the name of application.cfm to AnnApp.cfm and invoke that directly, instead of indirectly through CF, as I mentioned above.  And, if application.cfm is not there or is blank, TstLoops works fine on it&apos;s own.

I really think this is a configuration issue or a permissions issue.  I just don&apos;t know what.</description>
			<link>http://forums.forta.com/messages.cfm?threadid=2D7CD4B5-CEFF-FB0B-926E56BE724C8E27&amp;r=1</link>
			<dc:date>2012-05-15T19:33:20-04:00</dc:date>
			<dc:subject>System Configuration Problem</dc:subject>
			</item>
		
		
		
			<item rdf:about="http://forums.forta.com/messages.cfm?threadid=2D7CD4B5-CEFF-FB0B-926E56BE724C8E27&amp;r=2">
			<title>RE: System Configuration Problem</title>
			<description>Then next step is to have it relocate to something else, see if is the relocation that is failing, or what is begin relocated to that is failing. Unfortunately, without code to run we&apos;re limited in the help we can provide here.</description>
			<link>http://forums.forta.com/messages.cfm?threadid=2D7CD4B5-CEFF-FB0B-926E56BE724C8E27&amp;r=2</link>
			<dc:date>2012-05-15T18:46:16-04:00</dc:date>
			<dc:subject>System Configuration Problem</dc:subject>
			</item>
		
		
		
			<item rdf:about="http://forums.forta.com/messages.cfm?threadid=2D7CD4B5-CEFF-FB0B-926E56BE724C8E27&amp;r=3">
			<title>RE: System Configuration Problem</title>
			<description>I can run TestLoops.cfm directly with no problem.  I can run it through AnnApp.cfm if I call AnnApp.cfm directly.

No, this is not the only line of code, I only said I commented that line out.  It sets several session variables and then has the below if statement.  For testing purposes, I had changed the login.cfm to my TestLoops.cfm, because I knew TestLoops.cfm works.  :-)  So, it&apos;s checking to see if the user login has expired and if so AND if the script that was actually invoked is NOT login.cfm, then go to login.cfm to force the user to login.


&lt;cfif Not Session.LoggedIn&gt;
	&lt;cfif (CGI.SCRIPT_NAME IS NOT &quot;/login.cfm&quot;) AND (CGI.SCRIPT_NAME IS NOT &quot;/login_result.cfm&quot;)&gt;
		&lt;cflocation url=&quot;login.cfm&quot; addtoken=&quot;no&quot;&gt; 
	&lt;/cfif&gt;
&lt;/cfif&gt;</description>
			<link>http://forums.forta.com/messages.cfm?threadid=2D7CD4B5-CEFF-FB0B-926E56BE724C8E27&amp;r=3</link>
			<dc:date>2012-05-15T17:58:35-04:00</dc:date>
			<dc:subject>System Configuration Problem</dc:subject>
			</item>
		
		
		
			<item rdf:about="http://forums.forta.com/messages.cfm?threadid=2D7CD4B5-CEFF-FB0B-926E56BE724C8E27&amp;r=4">
			<title>RE: System Configuration Problem</title>
			<description>Great. So now you need to remove that line from Application.cfm, and run TstLoops.cfm directly to see what happens.

And, do you really want a &lt;cflocation&gt; in there? If that is the only code in Application.cfm, you are basically sending every request, no matter what it is, to that one redirected page.</description>
			<link>http://forums.forta.com/messages.cfm?threadid=2D7CD4B5-CEFF-FB0B-926E56BE724C8E27&amp;r=4</link>
			<dc:date>2012-05-15T17:27:24-04:00</dc:date>
			<dc:subject>System Configuration Problem</dc:subject>
			</item>
		
		
		
			<item rdf:about="http://forums.forta.com/messages.cfm?threadid=2D7CD4B5-CEFF-FB0B-926E56BE724C8E27&amp;r=5">
			<title>RE: System Configuration Problem</title>
			<description>Yes, I am calling it with an http:// url.  I have determined that this line of ocde is the suspect:

		&lt;cflocation url=&quot;TstLoops.cfm&quot; addtoken=&quot;no&quot;&gt; 

If I comment that out, it all works fine.  If I rename the application.cfm to Annapplication.cfm and call that directly with http://localhost/ows/Annapplication.cfm it works fine with that line of code uncommented. That line of code is only a problem when ColdFusion automatically invokes application.cfm

And, this is part of a very large application that has been working and is working on other servers.  I&apos;m just trying to get it functioning on my desktop so that I can make modifications to it.  I suspect it&apos;s something to do with permissions but I&apos;m not sure what and how to resolve it.  Any help or pointing me in the right direction to get some help is greatly appreciated.

Ann</description>
			<link>http://forums.forta.com/messages.cfm?threadid=2D7CD4B5-CEFF-FB0B-926E56BE724C8E27&amp;r=5</link>
			<dc:date>2012-05-15T17:08:50-04:00</dc:date>
			<dc:subject>System Configuration Problem</dc:subject>
			</item>
		
		
		
			<item rdf:about="http://forums.forta.com/messages.cfm?threadid=2FDA2439-9ED6-2278-E9B82AF5BC0E9C2F&amp;r=6">
			<title>RE: Coldfusion 10</title>
			<description>Don&apos;t forget you can get the main docs online right now. While obviously I think the WACK is worth your purchase, Adobe also puts out nearly 5000 pages of docs as well. :)

http://blogs.coldfusion.com/post.cfm/coldfusion-10-docs-link</description>
			<link>http://forums.forta.com/messages.cfm?threadid=2FDA2439-9ED6-2278-E9B82AF5BC0E9C2F&amp;r=6</link>
			<dc:date>2012-05-15T16:08:29-04:00</dc:date>
			<dc:subject>Coldfusion 10</dc:subject>
			</item>
		
		
		
			<item rdf:about="http://forums.forta.com/messages.cfm?threadid=2FDA2439-9ED6-2278-E9B82AF5BC0E9C2F&amp;r=7">
			<title>RE: Coldfusion 10</title>
			<description>perhaps i am thinking that there will be a lot of changes in coldfusion 9 book 1 with the release of coldfusion 10, plz need ur help.</description>
			<link>http://forums.forta.com/messages.cfm?threadid=2FDA2439-9ED6-2278-E9B82AF5BC0E9C2F&amp;r=7</link>
			<dc:date>2012-05-15T16:05:45-04:00</dc:date>
			<dc:subject>Coldfusion 10</dc:subject>
			</item>
		
		
		
			<item rdf:about="http://forums.forta.com/messages.cfm?threadid=2FDA2439-9ED6-2278-E9B82AF5BC0E9C2F&amp;r=8">
			<title>RE: Coldfusion 10</title>
			<description>Thank u very much, i really appreciate that u told me abt ur plans, in past i finished book 1, just started again, so when ur book will launch and how this is gonna effect on coldfusion 9 1st book, should i wait for ur book or should i finish book 1 of coldfusion 9.</description>
			<link>http://forums.forta.com/messages.cfm?threadid=2FDA2439-9ED6-2278-E9B82AF5BC0E9C2F&amp;r=8</link>
			<dc:date>2012-05-15T16:03:50-04:00</dc:date>
			<dc:subject>Coldfusion 10</dc:subject>
			</item>
		
		
		
			<item rdf:about="http://forums.forta.com/messages.cfm?threadid=2D7CD4B5-CEFF-FB0B-926E56BE724C8E27&amp;r=9">
			<title>RE: System Configuration Problem</title>
			<description>Make sure you are calling the pages using an http:// URL, not using the browser File Open option.

Also, put an empty Application.cfm there, see if that works. It may be that you have some code in the Application.cfm that is causing problems.</description>
			<link>http://forums.forta.com/messages.cfm?threadid=2D7CD4B5-CEFF-FB0B-926E56BE724C8E27&amp;r=9</link>
			<dc:date>2012-05-15T15:17:39-04:00</dc:date>
			<dc:subject>System Configuration Problem</dc:subject>
			</item>
		
		
		
			<item rdf:about="http://forums.forta.com/messages.cfm?threadid=2FDA2439-9ED6-2278-E9B82AF5BC0E9C2F&amp;r=10">
			<title>RE: Coldfusion 10</title>
			<description>We will not be updating all three volumes for ColdFusion 10. Instead, we are working on a single volume highlighting what is new and changed in this release. As such, the CF9 books are still the ones you want to get started.</description>
			<link>http://forums.forta.com/messages.cfm?threadid=2FDA2439-9ED6-2278-E9B82AF5BC0E9C2F&amp;r=10</link>
			<dc:date>2012-05-15T15:15:02-04:00</dc:date>
			<dc:subject>Coldfusion 10</dc:subject>
			</item>
		
		
		
			<item rdf:about="http://forums.forta.com/messages.cfm?threadid=2FDA2439-9ED6-2278-E9B82AF5BC0E9C2F&amp;r=11">
			<title>Coldfusion 10</title>
			<description>Dear Ben,
Its always been a pleasure to reading ur books on Coldfusion, although i am never able to finish first book due to personal issues and less time :(
But i was waiting for for Coldfusion 10, this time i will do it. plz can you inform me when your books on Coldfusion 10 will be released.
Regards
Sarfraz Rasool</description>
			<link>http://forums.forta.com/messages.cfm?threadid=2FDA2439-9ED6-2278-E9B82AF5BC0E9C2F&amp;r=11</link>
			<dc:date>2012-05-15T13:30:06-04:00</dc:date>
			<dc:subject>Coldfusion 10</dc:subject>
			</item>
		
		
		
			<item rdf:about="http://forums.forta.com/messages.cfm?threadid=2D7CD4B5-CEFF-FB0B-926E56BE724C8E27&amp;r=12">
			<title>System Configuration Problem</title>
			<description>I am having trouble with getting some ColdFusion applications to work on my system.  I have the ows directory created and .cfm files function correctly from there.  However, if I add an application.cfm or application.cfc file, it fails.  If I change the name of the application.cfm and invoke it directly, it works fine.  Change the name back to application.cfm and it fails when I invoke my test app, the error is the generic Internet Explorer Cannot Open the Web page, nothing specific. I suspect this has to be something with permissions in Active Directory or something.  Permissions of

Any ideas?  Or any ideas of where to go for assistance?

Thanks!

Ann</description>
			<link>http://forums.forta.com/messages.cfm?threadid=2D7CD4B5-CEFF-FB0B-926E56BE724C8E27&amp;r=12</link>
			<dc:date>2012-05-15T12:24:00-04:00</dc:date>
			<dc:subject>System Configuration Problem</dc:subject>
			</item>
		
		
		
			<item rdf:about="http://forums.forta.com/messages.cfm?threadid=296DA93E-B77B-8BB5-6498EC39B99049AE&amp;r=13">
			<title>Coldfusion 10</title>
			<description>Dear Ben,
          Its always been a pleasure to reading ur books on Coldfusion, although i am  never able to finish first book due to personal issues and less time :(
But i was waiting for for Coldfusion 10, this time i will do it. plz can you inform me when your books on Coldfusion 10 will be released.
Regards
Sarfraz Rasool</description>
			<link>http://forums.forta.com/messages.cfm?threadid=296DA93E-B77B-8BB5-6498EC39B99049AE&amp;r=13</link>
			<dc:date>2012-05-15T10:30:31-04:00</dc:date>
			<dc:subject>Coldfusion 10</dc:subject>
			</item>
		
		
		
			<item rdf:about="http://forums.forta.com/messages.cfm?threadid=BDD8977A-0D23-2AD8-904D037EB3207A12&amp;r=14">
			<title>MySQL specifics - 2nd Edition book</title>
			<description>While it doesn&apos;t seem to make a difference according to the documentation, I&apos;m now using the following with the 2nd edition of the book:
MySQL: 5.5.22
OS: Ubuntu 12.04 LTS
Apache: 2.2.22 (Ubuntu)
phpMyAdmin: 3.4.10.1-1
-----------------------------------------------------

Everything from my last post to the section below worked fine.

On page 142 (Lesson 17), specifying a default value for a column of the DATETIME type doesn&apos;t work, unless you put in a static value (which will never change and doesn&apos;t meet our needs for the purpose of this table).  You can see the section &quot;[link=http://dev.mysql.com/doc/refman/5.5/en/data-type-defaults.html]11.1.4. Data Type Default Values[/link]&quot; in the MySQL documentation for an explanation of this.  If you want to enter the current date and time, you&apos;ll have to do it in your INSERT statement, as you&apos;re adding data to the table.

On page 153 (Lesson 18), your code for MySQL needs to look like this:

[code]
     SELECT cust_name, cust_address AS cust_address1, CONCAT(RTRIM(cust_city), &apos;, &apos;, RTRIM(cust_state), &apos; &apos;, RTRIM(cust_zip)) AS cust_address2, cust_country AS cust_address3 FROM Customers;
[/code]
and because of this, the view is constructed like this:

[code]
     CREATE VIEW CustomerMailingLabels AS SELECT cust_name, cust_address AS cust_address1, CONCAT(RTRIM(cust_city), &apos;, &apos;, RTRIM(cust_state), &apos; &apos;, RTRIM(cust_zip)) AS cust_address2, cust_country AS cust_address3 FROM Customers;
[/code]

The text at the bottom of page 154 (Lesson 18) tells us to drop the previously created view.  While the book doesn&apos;t give syntax for this, I can only assume that Ben wanted us to figure this out on our own.  If we can&apos;t do that, we&apos;ll have lots of trouble when working with SQL in the real world.  For those in a hurry or the very lazy, here&apos;s the code:
[code]
     DROP VIEW CustomerMailingLabels;
[/code]

Here are the adjustments for MySQL for the code on the top of page 155 (Lesson 18):
[code]
     CREATE VIEW CustomerMailingLabels AS SELECT cust_name, cust_address AS cust_address1, CONCAT(RTRIM(cust_city), &apos;, &apos;, RTRIM(cust_state), &apos; &apos;, RTRIM(cust_zip)) AS cust_address2, cust_country AS cust_address3 FROM Customers WHERE NOT cust_address IS NULL AND NOT cust_city IS NULL AND NOT cust_state IS NULL AND NOT cust_zip IS NULL AND NOT cust_country IS NULL;
[/code]
[i]* Last updated by: bruuuuuu on 5/14/2012 @ 4:56 PM *[/i]</description>
			<link>http://forums.forta.com/messages.cfm?threadid=BDD8977A-0D23-2AD8-904D037EB3207A12&amp;r=14</link>
			<dc:date>2012-05-14T16:53:32-04:00</dc:date>
			<dc:subject>MySQL concatenation - 2nd Edition book</dc:subject>
			</item>
		
		
		
			<item rdf:about="http://forums.forta.com/messages.cfm?threadid=F20D5E22-9B39-AC3F-FCE9DBAC0B436365&amp;r=15">
			<title>RE: How create in cf a file with Application vars including passwords</title>
			<description>Your reply is a bit confusing and covers multiple different things. I&apos;ll try my best to respond. 

First, &quot;you mean this is legal...&quot; - no, I didn&apos;t say that. If you want to set Applicaition vars in Application.cfc, you want to make use of onApplicationStart. Please see the WACK or relevant CF docs for examples.

You then asked about case sensitivity. Yes, Linux/OSX is case sensitive. But it only applies to file names. Your code should be fine.</description>
			<link>http://forums.forta.com/messages.cfm?threadid=F20D5E22-9B39-AC3F-FCE9DBAC0B436365&amp;r=15</link>
			<dc:date>2012-05-14T07:48:22-04:00</dc:date>
			<dc:subject>How create in cf a file with Application vars including passwords</dc:subject>
			</item>
		
		
		
			<item rdf:about="http://forums.forta.com/messages.cfm?threadid=F20D5E22-9B39-AC3F-FCE9DBAC0B436365&amp;r=16">
			<title>RE: How create in cf a file with Application vars including passwords</title>
			<description>[code]
1 &lt;!--- you mean this is legal as Application.cfc or Application.cfm? ---&gt;
2 
3 &lt;!--- application database vars  ---&gt;
4 &lt;cfset APPLICATION.myDSN = &quot;mysqlcf_&quot;&gt;
5 &lt;cfset APPLICATION.un = &quot;&quot;&gt;
6 &lt;cfset APPLICATION.pw = &quot;A!&quot;&gt;
7 &lt;cfset APPLICATION.db = &quot;&quot;&gt;
8 [/code]

also cfml linux hostings are case sensitive in contrary with windows cfml hostings where are NOY CASE SENSITIVE?
SO IN LINUX THIS SHOULD GIVE ERROR?
[code]&lt;cfquery datasource=&quot;#APPLICATION.myDSN#&quot; name=&quot;getData11&quot; username=&quot;#application.un#&quot;...[/code] BETTER USE ALL LOWER CASE AS OF &quot;application&quot;????</description>
			<link>http://forums.forta.com/messages.cfm?threadid=F20D5E22-9B39-AC3F-FCE9DBAC0B436365&amp;r=16</link>
			<dc:date>2012-05-14T03:43:42-04:00</dc:date>
			<dc:subject>How create in cf a file with Application vars including passwords</dc:subject>
			</item>
		
		
		
			<item rdf:about="http://forums.forta.com/messages.cfm?threadid=F20D5E22-9B39-AC3F-FCE9DBAC0B436365&amp;r=17">
			<title>RE: How create in cf a file with Application vars including passwords</title>
			<description>Actually - and sorry to disagree with you Ben - but you can do an Application.cfc without any methods at all. For example, you could just give it a name and that&apos;s it. It makes your App.cfc kinda worthless, but it is valid. Later on when you decide you need to do something more, like run so and so on Application startup, you can add the method.</description>
			<link>http://forums.forta.com/messages.cfm?threadid=F20D5E22-9B39-AC3F-FCE9DBAC0B436365&amp;r=17</link>
			<dc:date>2012-05-07T09:53:38-04:00</dc:date>
			<dc:subject>How create in cf a file with Application vars including passwords</dc:subject>
			</item>
		
		
		
			<item rdf:about="http://forums.forta.com/messages.cfm?threadid=F20D5E22-9B39-AC3F-FCE9DBAC0B436365&amp;r=18">
			<title>RE: How create in cf a file with Application vars including passwords</title>
			<description>Application.cfc has a very specific format, and needs methods defined. Application.cfm is free-form, basically whatever you can use in an included file, so you can just use &lt;cfset&gt; tags to set a couple of variables if you&apos;d like.</description>
			<link>http://forums.forta.com/messages.cfm?threadid=F20D5E22-9B39-AC3F-FCE9DBAC0B436365&amp;r=18</link>
			<dc:date>2012-05-07T08:17:54-04:00</dc:date>
			<dc:subject>How create in cf a file with Application vars including passwords</dc:subject>
			</item>
		
		
		
			<item rdf:about="http://forums.forta.com/messages.cfm?threadid=F20D5E22-9B39-AC3F-FCE9DBAC0B436365&amp;r=19">
			<title>RE: How create in cf a file with Application vars including passwords</title>
			<description>02/20/12 1:55 PM
02/19/12 3:53 PM

may do an Application.cfc or Application.cfm with just cfset tags of Application Vars but no functions inside?</description>
			<link>http://forums.forta.com/messages.cfm?threadid=F20D5E22-9B39-AC3F-FCE9DBAC0B436365&amp;r=19</link>
			<dc:date>2012-05-07T04:11:41-04:00</dc:date>
			<dc:subject>How create in cf a file with Application vars including passwords</dc:subject>
			</item>
		
		
		
			<item rdf:about="http://forums.forta.com/messages.cfm?threadid=F20D5E22-9B39-AC3F-FCE9DBAC0B436365&amp;r=20">
			<title>RE: How create in cf a file with Application vars including passwords</title>
			<description>You are referring to an Application variable that does not exist. You need to make sure that you are indeed setting ti, and that your code is actually using the same Application.cfc or Application.cfm.</description>
			<link>http://forums.forta.com/messages.cfm?threadid=F20D5E22-9B39-AC3F-FCE9DBAC0B436365&amp;r=20</link>
			<dc:date>2012-05-02T07:11:23-04:00</dc:date>
			<dc:subject>How create in cf a file with Application vars including passwords</dc:subject>
			</item>
		
		

</rdf:RDF>

