CF 9 running on MS-SQL 2008 breaks query
This simple query works fine on MS 2005 database but fails on an MS 2008 server:
1. First test:
select suite from house_final_drawings where suite in (100,200)
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Conversion failed when converting
the nvarchar value '' to data type int.
2. Second Test:
If single quotes are put around the 'IN' list items the query works on SQL 2008.
select suite from house_final_drawings where suite in ('100','200')
Any ideas why this behavior change in SQL 2008? The querys both work when run
directly in SQL Studio.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351918
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Report Builder on CF9 with CSS questions
1. I am unable to get the CSS export link to produce an output file. Has anyone been able to get this function working? 2. Does the CSS style override function actually work? I am trying to override the margins on a text field but this CSS function is not changing anything. 3. The importing of Image files in the report does not work. An image object will not render in the report unless I copy the image and DROP it on the report layout in CF Report builder. The image is therefore embedded in the CFR file. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343442 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Problem with Report Builder - Element bottom
After modifying the query in a label page in CF Report Builder I get this message: "Report design not valid : 1. Warning : Element bottom reaches outside band area : y=2 height=72 band-height=72" This label format worked correctly but now all attempts to alter the label report result in this error. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341954 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Decipher CFLDAP date values
SOLVED:
This code shows how to translate the LDAP dates returned by ColdFusion tag
cfldap and to determine the number of days since the password was last changed.
It is based on code found on Scott Pinkston's blog:
http://www.scottpinkston.org/blog/index.cfm/2009/1/3/Detecting-password-age-from-either-Active-Directory-or-OpenLDAPSamba
dayssinceupdate: #dayssinceupdate#
passwordlastupdated: #passwordlastupdated#
Results in:
dayssinceupdate: 32
passwordlastupdated: {ts '2009-07-02 17:33:00'}
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325198
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Decipher CFLDAP date values
That formula is still not correct: adexplorer shows this date: 7/2/2009 12:33:05 PM cfldap returns this integer8 value: 128910259851092856 The coldfusion code shown below returns this date: January 07, 1601 09:47:01 --- #dateFormat(iLogonTime," dd, ")# ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325196 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Decipher CFLDAP date values
When returning date/time values from active directory the CFLDAP tag provides an integer value which must be decoded. What is the formula for converting the integer value to a human readable date? example: LASTLOGON returns "128922162522263907" ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325155 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: using dynamic variable in cfset statement
>>>The variable application. ends with a "." character. > >This looks to me like appconfig.code_name is an empty string. It is not an empty string. Also, the [] is an invalid constrict in coldfusion. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312262 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
using dynamic variable in cfset statement
Why does this fail inside a cfoutput loop over a query: It generates this message: "A CFML variable name cannot end with a "." character. The variable application. ends with a "." character. You must supply an additional structure key or delete the "." character." ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312257 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: creating a cfc
Did you ever get this working? I have a need for just such a beast. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302980 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Limit to single user logon with same userid
How do people prevent the same user from logging into an application with the same userid from multiple machines? We have users who are sharing their IDs which is causing application failures with the concurrent sessions. ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294453 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Security and use of Index.cfm
My CFADMIN (in a government shop) has objected to the use of templates named INDEX.CFM saying that this gives hackers a handle on cracking a public website. Has anyone run into this issue and how have you delte with it? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268638 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFFORM Flash form
Is anyone out there seriously coding using the CFFORM flash forms? I am seeing no improvement in performance in this area but users are seduced by the look and feel and think this is the way to go. Can someone suggest a good discussion on CFFORM flash pros and cons? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234790 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Flash Form Performance
What is the current verdict on Flash Form performance when used with ColdFusion? Is it still unacceptably slow or has there been any improvement? Does anyone have any links with performance hints for using Flash Forms? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234510 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Favorite CF books
OK, the boss is flush this time of year! He said give me a list of manuals you NEED and I will order them! Gotta act fast: What are your favorite CF 7 books today and why? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227593 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Question of Style for XML feed
I have been asked to generate an XML feed of data from a report to be available to users who would like to import the data into their own system. After specifying search criteria for the web-based report and executing the report, a user can request an XML file of that data. The report is a complex structure requiring about 10 stored procedures to extract the multiple recurring components. I am generating the XML data and writing it to a temporary file with a unique id tied to the user session. (The temporary files are deleted periodically). On the next form I display a link which will open the XML file in a new browser window. The user may then save the XML data on their own system for further processing. I have generated SCM and DTD description files for the complex XML structure. Should these be made available along with the link to the custom-generated XML file? ie: Generated File: XXX101.XMLSCM: xml2scm.xml DTD: xml2dtd.xml How are these description files usually made available to users? Any suggestions? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227554 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Regex - Remove blank lines
Thanks guys. This code did the job: > I used this code with no change in the output. The first line in > blank prior to the XML delclaration. That causes XML validators to > reject the file: > > "[#Chr(13)##Chr(10)#]+", " ", "ALL")> > > There are also embedded blank lines in the text file which need to be > removed. > Any other suggestions? > > > >REReplace(strOutputData, "[#Chr(13)##Chr(10)#]+", " ", "ALL"); > > > >This will find one or more strings that contain a combination of 13 > >(return??) and 10 (new line?? - cant remember which is which) and > replace it > >with a space. I tend to replace with a space rather than an empty > string > >cause it feels safer to me and allows me to sleep comfortable at > night. > > > >.. > >Ben Nadel > >Web Developer > >Nylon Technology > >6 West 14th Street > >New York, NY 10011 > >212.691.1134 > >212.691.3477 fax > >www.nylontechnology.com > > > >"Vote for Pedro" > > > >-Original Message- > >From: Wally Randall [mailto:[EMAIL PROTECTED] > >Sent: Thursday, December 08, 2005 8:00 AM > >To: CF-Talk > >Subject: Regex - Remove blank lines > > > >I am generating XML output into a variable prior to writing it to a > text > >file. There are several places where blank lines are appearing in > the > >output. > > > >How can I use rereplace() to remove blank lines from the generated > XML prior > >to writing the file with cffile()? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226588 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Regex - Remove blank lines
I used this code with no change in the output. The first line in blank prior to the XML delclaration. That causes XML validators to reject the file: There are also embedded blank lines in the text file which need to be removed. Any other suggestions? >REReplace(strOutputData, "[#Chr(13)##Chr(10)#]+", " ", "ALL"); > >This will find one or more strings that contain a combination of 13 >(return??) and 10 (new line?? - cant remember which is which) and replace it >with a space. I tend to replace with a space rather than an empty string >cause it feels safer to me and allows me to sleep comfortable at night. > >.. >Ben Nadel >Web Developer >Nylon Technology >6 West 14th Street >New York, NY 10011 >212.691.1134 >212.691.3477 fax >www.nylontechnology.com > >"Vote for Pedro" > >-Original Message- >From: Wally Randall [mailto:[EMAIL PROTECTED] >Sent: Thursday, December 08, 2005 8:00 AM >To: CF-Talk >Subject: Regex - Remove blank lines > >I am generating XML output into a variable prior to writing it to a text >file. There are several places where blank lines are appearing in the >output. > >How can I use rereplace() to remove blank lines from the generated XML prior >to writing the file with cffile()? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226552 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Regex - Remove blank lines
I am generating XML output into a variable prior to writing it to a text file. There are several places where blank lines are appearing in the output. How can I use rereplace() to remove blank lines from the generated XML prior to writing the file with cffile()? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226545 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Virtual Directories under CF7 Developer
I am running on Windows XP Pro. How do I set CF up running as a user as you suggest? Where is some documentation on that? >If you have CF running as local system, it will not see your network drives. >You will need to set up cf running as a user, and make sure that that user >has the drive mapping and appropriate access. You can have it run as you, >but you will see the command prompt window when jrunsvc starts. > > > >-Original Message----- >From: Wally Randall [mailto:[EMAIL PROTECTED] >Sent: Wednesday, December 07, 2005 12:56 PM >To: CF-Talk >Subject: Re: Virtual Directories under CF7 Developer > >Marlon, > >The virtual mapping seems to work OK for mapping to my local C:\ drive but >not to a network "mapped" drive (ie: P:\PMNS\devwebsite\ ). Is the CF >Website restricted to the local machine or do I need to provide a different >mapping for network drives? > > >> > >> /* > >> C:/inetpub/wwwroot/ > >> >> > >> > >> /CFIDE/* > >> C:/CFusionMX7/wwwroot/CFIDE > >> >> > >> > >> /cfdocs/* > >> C:/CFusionMX7/wwwroot/cfdocs > >Travelling ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226535 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Virtual Directories under CF7 Developer
Marlon, The virtual mapping seems to work OK for mapping to my local C:\ drive but not to a network "mapped" drive (ie: P:\PMNS\devwebsite\ ). Is the CF Website restricted to the local machine or do I need to provide a different mapping for network drives? > On 12/7/05, Wally Randall <[EMAIL PROTECTED]> wrote: > > 1. Can I set-up virtual directories to development websites on a > server from the CF built-in webserver? I want to map to sites on a > server with CM management but cannot figure out how to do this from > the built-in server. > > > > Yes you can. You'll need to edit your jrun-web.xml file. It should > be located in #MXInstall#\wwwroot\web-inf\ directory. > > These are the entries I have set up so that I can use a different > web-root than the standard #MXInstall#\wwwroot directory. > > > /* > C:/inetpub/wwwroot/ > > > > /CFIDE/* > C:/CFusionMX7/wwwroot/CFIDE > > > > /cfdocs/* > C:/CFusionMX7/wwwroot/cfdocs > > > > Just set up other directories in the same fashion. BTW, the CFMX > server is case-sensitive on Win32 regarding virtual directories. > > > > -- > Marlon > > A spaceman came travelling on his ship from afar, > 'twas light years of time since his mission did start, > And over a village he halted his craft, > And it hung in the sky like a star, just like a star... > --Chris De Burgh, A Spaceman Came Travelling ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226460 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Virtual Directories under CF7 Developer
Thanks > On 12/7/05, Wally Randall <[EMAIL PROTECTED]> wrote: > > 1. Can I set-up virtual directories to development websites on a > server from the CF built-in webserver? I want to map to sites on a > server with CM management but cannot figure out how to do this from > the built-in server. > > > > Yes you can. You'll need to edit your jrun-web.xml file. It should > be located in #MXInstall#\wwwroot\web-inf\ directory. > > These are the entries I have set up so that I can use a different > web-root than the standard #MXInstall#\wwwroot directory. > > > /* > C:/inetpub/wwwroot/ > > > > /CFIDE/* > C:/CFusionMX7/wwwroot/CFIDE > > > > /cfdocs/* > C:/CFusionMX7/wwwroot/cfdocs > > > > Just set up other directories in the same fashion. BTW, the CFMX > server is case-sensitive on Win32 regarding virtual directories. > > > > -- > Marlon > > A spaceman came travelling on his ship from afar, > 'twas light years of time since his mission did start, > And over a village he halted his craft, > And it hung in the sky like a star, just like a star... > --Chris De Burgh, A Spaceman Came Travelling ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226458 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Virtual Directories under CF7 Developer
1. Can I set-up virtual directories to development websites on a server from the CF built-in webserver? I want to map to sites on a server with CM management but cannot figure out how to do this from the built-in server. 2. I know I can do this with IIS but we cannot get permission to install IIS on workstations. We might be able to get IIS installed if we can fix some security issues. Is there a way in IIS to lock-down access to only allow the local-host (127.0.0.1)? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226401 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Create an XML - Feed
I need to provide users with an option to create an XML version of a report. Can anyone give me some suggestions on how to do this? I will need a link on the report which will then generate the XML feed for the same query results. Does anyone have an example of how to accomplish this? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223421 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Create XML for download
I need to create an XML file version of the contents of a report which a user can choose to download. How do I provide a link for that date/file? Will a normal WEB link work? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222587 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
getdirectoryfrompath problem
We are suddenly having a problem with the getdirectoryfrompath() function on a Solaris box running CF 6.1. The following statement has not been changed but the value rendered is not correct: CGI.SCRIPT_NAME value is: /pmns/index.cfm application.Global.myDir is rendered as: /pmns/query/ which should be: /pmns/ What can cause this strange result? Is is possible for a system level alias to cause CF to incorrectly interpret this? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221814 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
ColdFusion Security Holes - Best Practices
I heard a challenge from a security consultant that "if you are using ColdFusion you do not have a secure server." He maintains that CF is full of things a hacker can access. For example he gave the following example. If you attempt to open a CF website with the following command it will generate an error message that gives you the IP address of the CF server: sitename.org/*.cfm I tried this on a wide variety of sites and found that most CF sites return the error with the IP address. Some, however appear to trap this error somehow. What should be done on a CF server to prevent that type of error exposing the IP address of a CF server? This error is occuring prior to the execution of an application.cfm file in the host root directory so you cannot programatically trap it. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220298 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Column level change logging
I need to record field/column level changes to a change log for a financial application. Does anyone have a good model of how to do this? There are two approaches that I see. Does anyone have comments on these two methods? 1.Hide copies of all modifiable form fields on the form for server side comparison of all columns which have changed. This would be used to write change log rows for all modified columns. 2.Execute a SQL retrieval of the row for column level comparison with the form's fields before writing the UPDATE query. We will be running on SQL server. Any sample code would be a big help. Wally Randall Gaithersburg Maryland FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
What maillist are Fusebox users on now?
What maillist are Fusebox users on now? FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Business Objects and Cold Fusion
My client has just acquired Business Objects for their WEB based reporting system. Does anyone have any experience with interfacing with this tool from Cold Fusion? I understand it is possible to do so? Business Objects and Cold Fusion are both running on Solaris platforms against Oracle 8i databases. Wally Randall Gaithersburg MD - USA ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Weird page timeouts with Oracle
Francisco, We had a similar problem. We were running an NT Server with Oracle 7.3. Our US based users had no trouble with timeouts but our users in Paris were experiencing a timeout like you described. This only occured on very large queries with 8-15 tables and several hundred rows returned. Our solution on that box was simple. Set your CF timeout higher - Like 5 minutes. Since that time we have moved to a new Sun box running Oracle 8.0i with no timeout issues for anyone. Your second and third queries run because Oracle is caching the query and re-using it even though Cold Fusion timed out the first time. Wally Randall Gaithersburg MD USA - Original Message - From: "Francisco Montes; Spain on Line" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, April 04, 2001 12:15 PM Subject: Weird page timeouts with Oracle | Hi, | | We have been getting a series of very weird error messages with CF lately. We have got two servers, one with CF and another with the Oracle database. | | The CF server page request timeout is set to 30 seconds. When we request a page for the first time, it always goes beyond this threshold for some reason (it should not take that long anyway) and we get the CF page timeout error message. However if we request the page again, chances are that everything will go ok. | | Another scenario: | | 1. We request a page for the first time with a browser, and it is starting to take too long to deliver... | 2. If in that time (within the 30 seconds threshold) we request that very same page with another browser (on another machine) the page in browser the first browser gets finally delivered while the one in the second one starts taking a long time to deliver. | | It looks like if Oracle is not passing control back to CF unless this is forced somehow by another request done by someone else. We are trying to work out why are we still getting this erratic behaviour. | | We are using: Solaris 5.8, Apache 1.3.9, Oracle client 8.1.6.3 | | Any ideas or comments about what could be going wrong would be greatly appreciated. | | Francisco Montes | Spain on Line | | | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Random RPC service is unavailable error
I just got this on my NT 4.0 workstation this week when I was trying to map to a network printer and it required my workstation to download the drivers for installation Two factors were related to this problem: 1. Microsoft knowledgebase revealed that there may have been a problem with some dlls from the latest service pack and recommended they be re-installed. (6 or something) This however did not solve the problem for me. 2. We believe thereal problem was that my C: drive was too full! I was out of temp space, cache space, my system log was full,and room to download the printer drivers. I am cleaning up my hard drive but have not yet attempted to download the printer drivers. Wally Randall Gaithersburg MD. .. Our LAN - Original Message - From: "Mark W. Breneman" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, April 04, 2001 1:52 PM Subject: Random RPC service is unavailable error | Has any one seen a "RPC service is unavailable" error from time to time? | This error seems to be very very infrequent. (about once every three | months) After hitting reload the error goes away. | | Mark W. Breneman | -Cold Fusion Developer | -Network Administrator | Vivid Media | [EMAIL PROTECTED] | www.vividmedia.com | 608.270.9770 | | ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Help, help, help Pleasssssse: migration from NT4 to Solaris
Our shop has just done this. It went very smoothly. We moved from NT 4.0 to a Sun Solaris.What a difference! It is much faster and it NEVER goes down. I was not directly involved with the code modifications but it took about a week to successfuly migrate our source code from NT to the UNIX. There were a few modifications with regard to the consistent use of file names (case sensitivity) and modification of slashes in directory strings. The UNIX file handling from Studio is different and there is a small learning curve in the use of UNIX if your programers are not familiar with this. I have no desire to return to NT as a server for a WEB site. Wally Randall - Original Message - From: "Capolinea" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, March 07, 2001 10:38 AM Subject: Help, help, help Pleasse: migration from NT4 to Solaris > Hello to all CF Guru, > I was asked by my boss to look for informations in order to migrate a web > site from NT4 to Solaris > We are running CF 451 US Enterprise on 2 front server and a database Oracle > 8i running on another server. > > Is it worth doing that (NT > Solaris) ? > What the pro and cons ? > > Any ideas, experience or advice would be GREATLY appreciate... > > Regards, > Rémi van der Deure > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Problems with Studio on Sun system
Our shop recently moved our development environment from an NT server to a new Sun Solaris box. Everything is working great except the connectivity from Studio running on our NT4.0 workstations. Issues: 1. Half the staff is able to access the RDS links to the Sun system with no trouble using their normal Sun unix passwords. Two of us are unable to do so. The RDS times out before connecting. 2. The two problem workstations can only access the source via an FTP site. This connection however displays only the directories at our development site but not the CFM files. If we log on using the ROOT system logon we can access those files. We have checked all our permissions and they match the other user accounts. Does anyone have any ideas that may help? Thanks, Wally Randall Gaithersburg MD ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
