Re: Is running CF on J2EE server more stable?
Hi Guy. Ok, thanks for all the information, I think I understand that now. I will have a play around with the JRun J2EE configuration on a test box and see how it pans out. In the past I have only run CFMX in server configuration with Apache. Regards, Andrew. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239147 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: Is running CF on J2EE server more stable?
Not sure I understand your comment about Tomcat... It is a J2ee server isn't it? why would it be mix and match? Regards Andrew. On 4/27/06, Denny Valliant [EMAIL PROTECTED] wrote: It was for me. It is because I write poor code, but none the less, the j2ee install was much more stable than the stand alone. Before the server would crash hard when the going got rough, but with the J2EE install, it just gets sluggish 9 out of 10 times. I still manage to make it crash and burn, of course, but it does seem a little harder. Just my experience, apparently unmatched. Take it for WIW. :) Although I'd think twice about tomcat... not that it's a bad idea - I rather like mixing and matching - but if you're aiming for stable, you should probably avoid the experimental. Not that *I* would, but a prudent person... p-: On 4/26/06, Andrew Dixon [EMAIL PROTECTED] wrote: Hi. We have been having some reliability issues with CF recently and where wondering if it was more reliable/stable if it was run over a J2EE server instead in server configuration mode? We would be looking at deploying it using Tomcat. Any thoughts? Kind regards, Andrew ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239068 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
Is running CF on J2EE server more stable?
Hi. We have been having some reliability issues with CF recently and where wondering if it was more reliable/stable if it was run over a J2EE server instead in server configuration mode? We would be looking at deploying it using Tomcat. Any thoughts? Kind regards, Andrew ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238841 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
Problem with Java object calls
Hi.
I having a problem with a Java object call. It appears that the CF server
does not create the objects exclusively when more than one instance of the
same script is running. I have created a java class to do multi-threaded XML
post to a web service. The java class works fine and everything is great if
you only call the script once. If you call it more that once at the same
time it appears that a new instance is the same as the other instance. Here
is a code segment of how I'm creating the object.
cfscript
obj_PostXML = CreateObject('java', 'MultiThreadedXMLPost').init();
obj_PostXML.executePost(arr_Arguments);
while(obj_PostXML.completedCount LT 2) {}
str_output = obj_PostXML.theData;
/cfscript
cfdump var=#str_output#
Is there anyway to make it exclusive?
Kind regards,
Andrew.
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237427
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
Multithreading within a request
Hi All. Is it possible to multithread within a single request. For example, I would like to make multiple http requests to a web service, but at the moment they run one after the other, taken about 3 seconds each, but if I could run them both at the same time it would improve the performance of the script greatly, any ideas on how this could be done? Kind regards, Andrew ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237122 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: Multithreading within a request
I'm stuck using MX6.1, so the gateway is not an option. Andrew. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237127 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: Getting logged off
Hi Tim. Do the terminals allow cookies to be set? If not you will need to pass the CFID and CFTOKEN on the URLs. Andrew. On 12/30/05, Tim Do [EMAIL PROTECTED] wrote: Hi All, We have a training room that has 14 dummy terminals using different terminal services accounts to access the intranet. What I'm finding out is that users are getting logged off intermittenly. This issue only happens in that room. I'm not too sure on how these terminal service accounts work and how it may affect sessions. Could this be a possibility? Thoughts? Thanks, Tim ~| 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:227972 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: Possible Bug: XML Dot Notation
Hi. Ok, I have found the bug and know what is it. When I was doing the XMLParse I set the case sensitive attribute to true: cfset responseData = XMLParse(cfhttp.filecontent, true) However, even through the case in the cfoutput string is perfect CF throws an error from the dot notation say the object doesn't exist. Remove the case sensitive true from the XMLParse, or in the case of the example given by BSterner, don't added it to the CFXML tag and everything works fine. This is therefore a bug. Best Regards Andrew ~| 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:227501 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
Character set conversion
Hi All. I have a XML string receive from a web service and the string is UTF-16 encoded. The CF XML Parser doesn't seem to like the string and I'm assuming it is because it doesn't like the UTF-16 encoding. Is there a way in CF to convert the string to a different character set, e.g. from UTF-16 to UTF-8 or can you get the XML Parser to accept UTF-16? Kind regards, Andrew. ~| 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:227437 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
Possible Bug: XML Dot Notation
Hi All. Now, maybe I'm getting this completely wrong but I think there is a bug when using dot notation with an XML object in both CF6.1 and 7. The XML structure I have has come from a web service via http using CFHTTP and this an example: PkgRS xmlns=http://www.test.com/test; http://www.test.com/testxmlns:xsi= http://www.w3.org/2001/XMLSchema-instance;http://www.w3.org/2001/XMLSchema-instanceTarget=test xsi:type=test SyndicatorInfo SyndicatorId=test/ SessionInfo SessionId=iPQ-J9ikYq39hn89J_puDZEn CreateNewSession=true/ SearchResponse Success=true ModifiedRequest=false ViewInfo Offset=0 Length=50/ ResultSetInfo SortCode=cost SortAscending=true MaxItems=100 NumItems=1/ PackageHolidays PackageHoliday ItineraryId=si1003 Supplier=EZJ Country=GB NumberOfNights=8 LeadInPricePerPassenger=29.98 FlightOnly=true OneWayOnly=false BookableByFAB=true Currency=GBP BookingChannel=WEB Flight OriginAirport=LGW DestinationAirport=BFS DepartureDate=20060202 DepartureTime=0700 ReturnHomeDate=20060210 ReturnHomeTime=2250 ReturnHomeDepartDate=20060210 ReturnHomeDepartTime=2125 ArrivalDate=20060202 ArrivalTime=0830 OutboundFlightNumber=EZY731 ReturnFlightNumber=EZY742 OutboundFlightBasePrice=9.99 ReturnFlightBasePrice=9.99/ /PackageHoliday /PackageHolidays /SearchResponse /PkgRS If I then try to output the value of the XML Attribute LeadInPricePerPassenger which is located with the PackageHoliday element using dot notation I get an error: cfoutput#responseData.PkgRS.SearchResponse.PackageHolidays.PackageHoliday[1].XmlAttributes.LeadInPricePerPassenger#/cfoutput Error: Element PKGRS.SEARCHRESPONSE.PACKAGEHOLIDAYS.PACKAGEHOLIDAY is undefined in RESPONSEDATA. However if I output it using associative array (bracket) notation it works without issue: cfoutput#responseData[PkgRS][SearchResponse][PackageHolidays][PackageHoliday][1][XmlAttributes][LeadInPricePerPassenger]#/cfoutput 29.98 According the Developing ColdFusion MX Applications documentation from MM you can: quote Similarly, you can use either, or a combination of both, of the following notation methods: Structure (dot) notation, such as mydoc.employee Associative array (bracket) notation, such as mydoc[employee] I have tried the same code on MX6.1 and 7 and get the same error. Am I doing something completely wrong or is this a CF bug? Best Regards Andrew ~| 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:227478 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: Frycry install
Hi. I have managed to work it out... it was a permission issue on the directories. Thanks Andrew. On Sat, 5 Feb 2005 22:23:52 -0800, Barney Boisvert [EMAIL PROTECTED] wrote: You meant 'FarCry', right? I installed it a few months ago (with CFMX/Apache on Linux), and seem to recall it being amazingly painless. Extract the archive, run the installer, and follow the instructions for defining the mapping it needed. Obviously as you get farther in-depth, it'll get more complicated, but I went from download to signing in like 5 minutes. cheers, barneyb ~| 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:193222 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
Frycry install
Hi all... Anyone got any good, clear instructions on installing FryCry on a CFMX/Apache configuration. The install instruction on the site are not very clear and seem to relate to IIS. Thanks Andrew. ~| 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:193205 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
Problem with CFHTTP
Hi All. Not sure if anyone else has ever come across this, but we have a site that uses an external XML feed to provide it with data. We access this feed using CFHTTP which work fine, however sometimes the provider take a while to response, 10 - 20 seconds, and when this happens CFHTTP eats cpu time like crazy. Which then has an impact on are data parsing time, particular when there are multiple instants of CFHTTP waiting for a reply while overs are trying to process returned data. Has anyone else ever come across this problem, or any ideas how to fix it? Best Regards Andrew. ~| Logware: 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:191333 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
C++ CFX Tag
Hi All. Has anyone here every managed to write a C++ CFX tag that works on CFMX on Linux? Even the example CFX tag, cfx_directorylist doesn't appear to work. Any help would be very gratefully received. Andrew. ~| Logware: 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:190898 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
Writing a C++ CFX tag for Linux
Hi All.
I need to write a C++ CFX tag for Linux and I've not done one before,
so I thought I would start with a simply Hello World application.
Here the code in the my C++ file...
// Include Standard Librarys (not if they are needed at this point)
#include stdio.h
#include string.h
#include stdlib.h
#include cfx.h// CFX Custom Tag API
// Constants
#define TAG_ERROR_HEADERError occurred in Test tag
extern C
void ProcessTagRequest( CCFXRequest* pRequest )
{
try
{
pRequest-Write( Hello World );
}
// Catch Cold Fusion exceptions re-raise them
catch( CCFXException* e )
{
pRequest-ReThrowException( e ) ;
}
// Catch ALL other exceptions and throw them as
// Cold Fusion exceptions (DO NOT REMOVE! --
// this prevents the server from crashing in
// case of an unexpected exception)
catch( ... )
{
pRequest-ThrowException(
TAG_ERROR_HEADER,
Unexpected error occurred while processing tag. ) ;
}
}
I then compiled this using the following Makefile:
INCLUDE = -I /opt/coldfusionmx/cfx/include
CXX = g++
LD = g++
SRC = request.cc
OBJ = request.o
test.so:$(OBJ)
$(LD) -shared -o test.so $(OBJ)
request.o: request.cc
$(CXX) $(INCLUDE) -c request.cc
clean:
rm -f test.so $(OBJ)
This all compiled ok and create a test.so file. I registered this via
CF Admin as CFX_test and then create a create a script to call
CFX_test:
CFX_test
I then called this script via the browser and all I get is a blank
page. I had asssumed I would see Hello World in the browser, but
nothing. There are no error messages either when compiling,
registering or running the script. Can anyone help point me in the
right direction as I guess I'm doing something completely wrong
somewhere along the way.
Best Regards
Andrew.
~|
Logware: 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:190743
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: XML Variable Issue
Hi. If you are using it like that you need to .XmlText on the end to get the XmlText part of the XmlNode. Config.SiteConfig.SiteSections.UserManager.XmlText And as it is text and not a boolean value I think you will need to use: cfif Config.SiteConfig.SiteSections.UserManager.XmlText IS TRUE Andrew. ~| 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:190750 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
Regular Expression (searching from the end)
Hi Everyone. I need to find the last occurance of a character in a string. Is there a way I can use a regular expression to search the string from the end backwards for the character? Or is there another way I can do it using a CF function. At the moment I have a conditional loop that uses the Find() function to search until it returns 0 and then report the previous value as the last occurance. This works fine, but I feel there should be a better way. Thanks Andrew. ~| Save $10 Download ZoneAlarm Security Suite http://www.houseoffusion.com/banners/view.cfm?bannerid=66 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190067 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: Regular Expression (searching from the end)
Nope. The array thing still only gives the first occurance. Andrew. ~| 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:190071 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: Regular Expression (searching from the end)
Thank you very much Pascal. Worked like a dream. Andrew. ~| 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:190089 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
Using XML
Hi Everyone. We have a busy website that uses a third party XML feed. Basically what happens is: 1) The visitor completes a form specifying their criteria. 2) A request is sent to the third party for results matching the criteria. 3) The third party response with and XML results feed. The returned XML contains many elements with elements within them that also contain multiple sub elements and one of the sub elements also contains multiple sub elements. For example: data elements element value11/value1 value22/value2 subelements subelement value14/value1 value24/value2 /subelement subelement value14/value1 value24/value2 subelement /subelements anothersubelements anothersubelement value14/value1 value24/value2 /anothersubelement anothersubelement value14/value1 value24/value2 anothersubelement /anothersubelements element element value11/value1 value22/value2 element /elements /data Personally I think the XML format is messy, but that is out of my control. At the moment to parse the data into a query so I can create a results page from I'm doing CFLOOP's within CFLOOP's starting by looping over each 'element' inside the 'elements' structure and then working inwards to the 'subelements' and 'anothersubelements' and also the 'subsubelements' (not show above). Is this the only way to do this, or is there a better way? This way is very slow during busy times, but during quite times this is ok. Also this way is also affected but the number of returned results. The more results the more loops and therefore the longer it takes. Thanks in advanced. Andrew. ~| 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:189910 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: Using XML
Because the data is very very messy and contains lots of repeated data that needs getting rid of so I can give an accurate value of the number of results. On Tue, 11 Jan 2005 08:04:05 -0800, Ian Skinner [EMAIL PROTECTED] wrote: My first question is what is the requirement to parse the XML into a query? Why not just reference the XML object directly? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning ...-Original Message- ...From: Andrew Dixon [mailto:[EMAIL PROTECTED] ...Sent: Tuesday, January 11, 2005 7:59 AM ...To: CF-Talk ...Subject: Using XML ... ...Hi Everyone. ... ...We have a busy website that uses a third party XML feed. Basically ...what happens is: ... ...1) The visitor completes a form specifying their criteria. ...2) A request is sent to the third party for results matching the ...criteria. ...3) The third party response with and XML results feed. ... ...The returned XML contains many elements with elements within them that ...also contain multiple sub elements and one of the sub elements also ...contains multiple sub elements. For example: ... ...data ... elements ... element ... value11/value1 ... value22/value2 ... subelements ... subelement ...value14/value1 ...value24/value2 ... /subelement ... subelement ...value14/value1 ...value24/value2 ... subelement ... /subelements ... anothersubelements ... anothersubelement ...value14/value1 ...value24/value2 ... /anothersubelement ... anothersubelement ...value14/value1 ...value24/value2 ... anothersubelement ... /anothersubelements ... element ... element ... value11/value1 ... value22/value2 ... element ... /elements .../data ... ...Personally I think the XML format is messy, but that is out of my ...control. At the moment to parse the data into a query so I can create ...a results page from I'm doing CFLOOP's within CFLOOP's starting by ...looping over each 'element' inside the 'elements' structure and then ...working inwards to the 'subelements' and 'anothersubelements' and also ...the 'subsubelements' (not show above). ... ...Is this the only way to do this, or is there a better way? This way is ...very slow during busy times, but during quite times this is ok. Also ...this way is also affected but the number of returned results. The more ...results the more loops and therefore the longer it takes. ... ...Thanks in advanced. ... ...Andrew. ... ... ~| 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:189914 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: File Where DSNs are stored?
They are stored in the neo-query.xml file in the lib directory in the CF root. You can copy it over if none of the settings need changing. Andrew. On Mon, 10 Jan 2005 10:14:03 -0500, Claremont, Timothy [EMAIL PROTECTED] wrote: I am moving a CF instance from our old server to our new one. Both are 6.1. Is there a file that I can copy over that contains my DSNs, or do I need to set them up separately through administrator? TIA, Tim ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please delete it from your system. This footnote also confirms that this email message has been swept for the presence of computer viruses. Thank You, Viahealth ** ~| 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:189805 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: QofQ: SELECT DISTINCT
The query is created by converting an XML data feed from an external web-service. So there is no way to change it further up the chain as such. Anyway the work around I'm using is working very well. Andrew ~| Get the mailserver that powers this list at http://www.houseoffusion.com/banners/view.cfm?bannerid=17 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189223 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: QofQ: SELECT DISTINCT
Hi Ryan. That custom tag is no help as I need to DISTINCT on three columns. As a work around for the moment, I'm creating a table in the mySQL datasource and then populating it, doing the select and then deleting the table and it is about 100 times (really) quicker. The QofQ takes about 2 seconds and the work around takes about 0.02 seconds, which just seems silly as it is doing so much more work. Andrew. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189050 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
QofQ: SELECT DISTINCT
Hi All. I have some code that does a SELECT DISTINCT on a QofQ and it is really slow. For example, I have a dataset with about 150 records and the SELECT DISINCT is taking anything from 2 - 5 seconds to excute. Any ideas why and how to improve it? Andrew. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189023 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
QofQ Problem: Sorting on columns of type java.sql.Types.NULL is not supported.
Hi All. I have a problem with a Query of a Query. The error I'm getting is: Query Of Queries runtime error. Sorting on columns of type java.sql.Types.NULL is not supported. The code is: cfquery name=qry_accommodationData dbtype=query SELECT * FROM qry_accommodationData ORDER BY #orderBy#, AdultPrice /cfquery Most of the time this works fine, but every now and again it gets a dataset that it has this problem with. I have compared the first row of a good dataset with the first row of bad dataset and they appear to be pretty much same, apart from slightly different values. As far as I'm aware CF uses the first row of the dataset to set the data types and in both the good and bad datasets none of the columns in the first have null values. Anyone got any ideas? Andrew. ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188607 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
Using a J2EE Application Server
Hi All. I'm looking for a little bit of information. In what case would you use CFMX on a J2EE platform? We current have a server using CFMX Apache on RedHat. What does using the J2EE platform give me and do the J2EE replace Apache as the webserver or do you still need that? Thanks for any information anyone can provide. Best Regards Andrew. ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187358 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: Using a J2EE Application Server
We are on a Redhat Linux box, so the IIS Lockdown tool is not going to do much, but I have used on a Window box before and it causes lots of problems!!! Andrew. On Mon, 13 Dec 2004 15:30:12 -, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: We too are having these issues.and we are contemplating the move to J2EE...Have you ran the IIS Lockdown tool? -Original Message- From: Andrew Dixon [mailto:[EMAIL PROTECTED] Sent: 13 December 2004 15:31 To: CF-Talk Subject: Re: Using a J2EE Application Server Hi. We are basically looking for a more robust platform on which to run CF. We have a site with about 500,000 page view per day and every now and again the CF server service will die and the only way we have found to get it running again is to kill the CF server threads (using the kill command) and then start it again, trying to stop the server doesn't work. Some else suggested to a college that using CF on the J2EE platform might help make it more robust, but we have zero experience of the J2EE platform and we where using looking for a basic intro into work it is, does and whether or not it might help. I understand the Apache is not a J2EE server, but I was wondering if the J2EE server replaces the web server (like Apache) or if you still use a web server as well. The server is Dual Xeon 2Ghz with 4Gb RAM and 80Gb IDE Hard Drive. The average load on the machine never gets to high, but the CF server just appears to full over sometimes. We are using CFMX6.1 + Updater, which has improved the stability slightly. Any ideas? Andrew On Mon, 13 Dec 2004 10:17:46 -0500 (GMT-05:00), Michael Greenberg [EMAIL PROTECTED] wrote: Hi Andrew, Not sure what you're asking...Apache is not a J2EE server, however a J2EE server like Tomcat or JBoss can ride on top of Apache. Are you looking for a full blown J2EE server that does EJB or just a JSP Container? One thing a J2EE server architecture will give you is force you to separate presentation and logic, but the same can be said about Fusebox I suppose. Can you give more info? Thanks, Michael -Original Message- From: Andrew Dixon [EMAIL PROTECTED] Sent: Dec 13, 2004 9:56 AM To: CF-Talk [EMAIL PROTECTED] Subject: Using a J2EE Application Server Hi All. I'm looking for a little bit of information. In what case would you use CFMX on a J2EE platform? We current have a server using CFMX Apache on RedHat. What does using the J2EE platform give me and do the J2EE replace Apache as the webserver or do you still need that? Thanks for any information anyone can provide. Best Regards Andrew. ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187375 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: Using a J2EE Application Server
I think you are right and that they didn't really understand what they where talking about. I've been doing some digging about and I'm heading towards think that problem lays with the Apache connector. I might look into using the CF built in web server, anyone had any experience of doing it that way? Andrew. On Mon, 13 Dec 2004 10:40:41 -0500 (GMT-05:00), Michael Greenberg [EMAIL PROTECTED] wrote: Ok I gotcha now :) Technically yes J2EE server can function as a webserver, but I wouldn't recommend doing that because its really not what it's meant to do. As far as the comment that was made to you it seems like they are confusing J2EE and Apache. Yes you could have CF ride on top of Apache however I don't think you can serve it on top of that. I don't think there are connectors available to do so. (I did a quick look up for Tomcat, JBoss, Weblogic, or WebSphere and didnt see them available) I definitely think that if you wanted to do anything on J2EE server I'd recommend using JSPs and Servlets. Thanks, Michael -Original Message- From: Andrew Dixon [EMAIL PROTECTED] Sent: Dec 13, 2004 10:31 AM To: CF-Talk [EMAIL PROTECTED] Subject: Re: Using a J2EE Application Server Hi. We are basically looking for a more robust platform on which to run CF. We have a site with about 500,000 page view per day and every now and again the CF server service will die and the only way we have found to get it running again is to kill the CF server threads (using the kill command) and then start it again, trying to stop the server doesn't work. Some else suggested to a college that using CF on the J2EE platform might help make it more robust, but we have zero experience of the J2EE platform and we where using looking for a basic intro into work it is, does and whether or not it might help. I understand the Apache is not a J2EE server, but I was wondering if the J2EE server replaces the web server (like Apache) or if you still use a web server as well. The server is Dual Xeon 2Ghz with 4Gb RAM and 80Gb IDE Hard Drive. The average load on the machine never gets to high, but the CF server just appears to full over sometimes. We are using CFMX6.1 + Updater, which has improved the stability slightly. Any ideas? Andrew On Mon, 13 Dec 2004 10:17:46 -0500 (GMT-05:00), Michael Greenberg [EMAIL PROTECTED] wrote: Hi Andrew, Not sure what you're asking...Apache is not a J2EE server, however a J2EE server like Tomcat or JBoss can ride on top of Apache. Are you looking for a full blown J2EE server that does EJB or just a JSP Container? One thing a J2EE server architecture will give you is force you to separate presentation and logic, but the same can be said about Fusebox I suppose. Can you give more info? Thanks, Michael -Original Message- From: Andrew Dixon [EMAIL PROTECTED] Sent: Dec 13, 2004 9:56 AM To: CF-Talk [EMAIL PROTECTED] Subject: Using a J2EE Application Server Hi All. I'm looking for a little bit of information. In what case would you use CFMX on a J2EE platform? We current have a server using CFMX Apache on RedHat. What does using the J2EE platform give me and do the J2EE replace Apache as the webserver or do you still need that? Thanks for any information anyone can provide. Best Regards Andrew. ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187383 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: Using a J2EE Application Server
Not really. Someone else suggested moving it to PHP, which we have some experience with, so I think if it was a re-write it would go down that route. Andrew. On Mon, 13 Dec 2004 10:42:27 -0500 (GMT-05:00), Michael Greenberg [EMAIL PROTECTED] wrote: Is migrating your app to JSP/Servlets a possibility? -Original Message- From: Andrew Dixon [EMAIL PROTECTED] Sent: Dec 13, 2004 10:38 AM To: CF-Talk [EMAIL PROTECTED] Subject: Re: Using a J2EE Application Server We are on a Redhat Linux box, so the IIS Lockdown tool is not going to do much, but I have used on a Window box before and it causes lots of problems!!! Andrew. On Mon, 13 Dec 2004 15:30:12 -, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: We too are having these issues.and we are contemplating the move to J2EE...Have you ran the IIS Lockdown tool? -Original Message- From: Andrew Dixon [mailto:[EMAIL PROTECTED] Sent: 13 December 2004 15:31 To: CF-Talk Subject: Re: Using a J2EE Application Server Hi. We are basically looking for a more robust platform on which to run CF. We have a site with about 500,000 page view per day and every now and again the CF server service will die and the only way we have found to get it running again is to kill the CF server threads (using the kill command) and then start it again, trying to stop the server doesn't work. Some else suggested to a college that using CF on the J2EE platform might help make it more robust, but we have zero experience of the J2EE platform and we where using looking for a basic intro into work it is, does and whether or not it might help. I understand the Apache is not a J2EE server, but I was wondering if the J2EE server replaces the web server (like Apache) or if you still use a web server as well. The server is Dual Xeon 2Ghz with 4Gb RAM and 80Gb IDE Hard Drive. The average load on the machine never gets to high, but the CF server just appears to full over sometimes. We are using CFMX6.1 + Updater, which has improved the stability slightly. Any ideas? Andrew On Mon, 13 Dec 2004 10:17:46 -0500 (GMT-05:00), Michael Greenberg [EMAIL PROTECTED] wrote: Hi Andrew, Not sure what you're asking...Apache is not a J2EE server, however a J2EE server like Tomcat or JBoss can ride on top of Apache. Are you looking for a full blown J2EE server that does EJB or just a JSP Container? One thing a J2EE server architecture will give you is force you to separate presentation and logic, but the same can be said about Fusebox I suppose. Can you give more info? Thanks, Michael -Original Message- From: Andrew Dixon [EMAIL PROTECTED] Sent: Dec 13, 2004 9:56 AM To: CF-Talk [EMAIL PROTECTED] Subject: Using a J2EE Application Server Hi All. I'm looking for a little bit of information. In what case would you use CFMX on a J2EE platform? We current have a server using CFMX Apache on RedHat. What does using the J2EE platform give me and do the J2EE replace Apache as the webserver or do you still need that? Thanks for any information anyone can provide. Best Regards Andrew. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187384 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: Using a J2EE Application Server
Hi. We are basically looking for a more robust platform on which to run CF. We have a site with about 500,000 page view per day and every now and again the CF server service will die and the only way we have found to get it running again is to kill the CF server threads (using the kill command) and then start it again, trying to stop the server doesn't work. Some else suggested to a college that using CF on the J2EE platform might help make it more robust, but we have zero experience of the J2EE platform and we where using looking for a basic intro into work it is, does and whether or not it might help. I understand the Apache is not a J2EE server, but I was wondering if the J2EE server replaces the web server (like Apache) or if you still use a web server as well. The server is Dual Xeon 2Ghz with 4Gb RAM and 80Gb IDE Hard Drive. The average load on the machine never gets to high, but the CF server just appears to full over sometimes. We are using CFMX6.1 + Updater, which has improved the stability slightly. Any ideas? Andrew On Mon, 13 Dec 2004 10:17:46 -0500 (GMT-05:00), Michael Greenberg [EMAIL PROTECTED] wrote: Hi Andrew, Not sure what you're asking...Apache is not a J2EE server, however a J2EE server like Tomcat or JBoss can ride on top of Apache. Are you looking for a full blown J2EE server that does EJB or just a JSP Container? One thing a J2EE server architecture will give you is force you to separate presentation and logic, but the same can be said about Fusebox I suppose. Can you give more info? Thanks, Michael -Original Message- From: Andrew Dixon [EMAIL PROTECTED] Sent: Dec 13, 2004 9:56 AM To: CF-Talk [EMAIL PROTECTED] Subject: Using a J2EE Application Server Hi All. I'm looking for a little bit of information. In what case would you use CFMX on a J2EE platform? We current have a server using CFMX Apache on RedHat. What does using the J2EE platform give me and do the J2EE replace Apache as the webserver or do you still need that? Thanks for any information anyone can provide. Best Regards Andrew. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187371 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: UK Dedicated Hosting Recomendations?
Hi Dan. We are UK based, but use a US based hosting company (ev1servers.net) as all UK based hosting companies are a rip-off in comparsion, and it really doesn't matter where the servers are. EV1 has 24 hour 365 day support so it doesn't matter if you have a problem when it is 3am in the US as there is always someone there. Their prices are excellent and you get loads of bandwidth included (which no UK based provided tend to do). Also, we found the three UK providered we used in the past (Virtual Internet (the worst of the worst), Host Europe and OneAndOne) didn't provide anywhere near the level of customer service or reliability of connection that was required. Best Regards Andrew. On Fri, 19 Nov 2004 07:48:13 -0400, Daniel Lancelot [EMAIL PROTECTED] wrote: Hi I need a uk dedicated hosting provider that can provide: Web Hosting Load Balancing Fail Over solutions Rock Solid SLA This is for windows servers (for Hosting CF / .NET + MS SQL) I would appreciate hearing your recomendations both for and against, from personal experience, as our current provider has let us down a few times recently. Thanks Dan. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184855 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: What does this error mean?
This is something to do with the RDS server service I believe. The file doesn't actually exist (at least not on 6.1, even if you have RDS enabled) but it is referred to in the web.xml configuration file. Don't think it is anything to wrong about, but it could be someone probing your machine to see if the RDS service is running. Andrew. On Fri, 19 Nov 2004 11:11:11 -0400, Andy Mcshane [EMAIL PROTECTED] wrote: Hi all, I keep this error message in my exception.log, can anyone tell what Coldfusion is trying to do here? Error,jrpp-1696,11/19/04,15:02:57,,File not found: /CFIDE/main/ide.cfm The specific sequence of files included or processed is: X:\Inetpub\wwwroot\CFIDE\main\ide.cfm coldfusion.runtime.TemplateNotFoundException: File not found: /CFIDE/main/ide.cfm Why is Coldfusion looking for this file, what is used for? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184886 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: What does this error mean?
If RDS is off that you are safe. Andrew. On Fri, 19 Nov 2004 11:40:59 -0500, Douglas Knudsen [EMAIL PROTECTED] wrote: I've been getting that error on one of my boxes too, i see it only when I login to the CFAdmin tool. Oh, and this box has RDS off. I think its related to the 6.1 updater cfadmin issue maybe. Doug On Fri, 19 Nov 2004 11:31:33 -0500, Michael Dinowitz [EMAIL PROTECTED] wrote: That's an RDS call. Hi all, I keep this error message in my exception.log, can anyone tell what Coldfusion is trying to do here? Error,jrpp-1696,11/19/04,15:02:57,,File not found: /CFIDE/main/ide.cfm The specific sequence of files included or processed is: X:\Inetpub\wwwroot\CFIDE\main\ide.cfm coldfusion.runtime.TemplateNotFoundException: File not found: /CFIDE/main/ide.cfm Why is Coldfusion looking for this file, what is used for? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184895 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
QofQ Problem
Hi Everyone. I have a strange QofQ problem. The error message I'm getting is: USA must be interprettable as a valid number in the current locale. The column that contains the word USA is a column that contains both letters and numbers, for example: 10902 10909 USA HPH NO2H32 It appears to be something to do with certain data sets are other with similar data work ok. The original data comes from an XML data feed that I have transformed into a query and that wish to extract only some of the data from using a QofQ. Has anyone else come across that problem??? If so have you got a fix? BTW, using CFMX6.1 + updater. Best Regards Andrew. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184709 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: QofQ Problem
Hi Pascal Thanks for that, inserting the dummy record works. Can I extract the data directly from the XML? I need to query the data to extract only certain records, is there a CF function to do this? Andrew. On Thu, 18 Nov 2004 11:28:15 +0100, Pascal Peters [EMAIL PROTECTED] wrote: The problem is that CF is guessing the data type of the column by looking at the values in the first row. In this case CF thinks the column contains numeric data (because of the 10902 in the first row). This was discussed several times on this list and there should be solutions in the archives. Can't you extract the data directly from the XML? If you want to use QofQ, you can insert a bogus record on top with the correct data types in it. Just see that you don't extract it. Pascal -Original Message- From: Andrew Dixon [mailto:[EMAIL PROTECTED] Sent: 18 November 2004 11:16 To: CF-Talk Subject: QofQ Problem Hi Everyone. I have a strange QofQ problem. The error message I'm getting is: USA must be interprettable as a valid number in the current locale. The column that contains the word USA is a column that contains both letters and numbers, for example: 10902 10909 USA HPH NO2H32 It appears to be something to do with certain data sets are other with similar data work ok. The original data comes from an XML data feed that I have transformed into a query and that wish to extract only some of the data from using a QofQ. Has anyone else come across that problem??? If so have you got a fix? BTW, using CFMX6.1 + updater. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184713 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: QofQ Problem
Ok... I will take a look at that. Thanks. On Thu, 18 Nov 2004 11:47:18 +0100, Pascal Peters [EMAIL PROTECTED] wrote: You can use XPath with XMLSearch(). Pascal -Original Message- From: Andrew Dixon [mailto:[EMAIL PROTECTED] Sent: 18 November 2004 11:44 To: CF-Talk Subject: Re: QofQ Problem Hi Pascal Thanks for that, inserting the dummy record works. Can I extract the data directly from the XML? I need to query the data to extract only certain records, is there a CF function to do this? Andrew. On Thu, 18 Nov 2004 11:28:15 +0100, Pascal Peters [EMAIL PROTECTED] wrote: The problem is that CF is guessing the data type of the column by looking at the values in the first row. In this case CF thinks the column contains numeric data (because of the 10902 in the first row). This was discussed several times on this list and there should be solutions in the archives. Can't you extract the data directly from the XML? If you want to use QofQ, you can insert a bogus record on top with the correct data types in it. Just see that you don't extract it. Pascal -Original Message- From: Andrew Dixon [mailto:[EMAIL PROTECTED] Sent: 18 November 2004 11:16 To: CF-Talk Subject: QofQ Problem Hi Everyone. I have a strange QofQ problem. The error message I'm getting is: USA must be interprettable as a valid number in the current locale. The column that contains the word USA is a column that contains both letters and numbers, for example: 10902 10909 USA HPH NO2H32 It appears to be something to do with certain data sets are other with similar data work ok. The original data comes from an XML data feed that I have transformed into a query and that wish to extract only some of the data from using a QofQ. Has anyone else come across that problem??? If so have you got a fix? BTW, using CFMX6.1 + updater. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184716 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: writing to xml woes
Hi Dave. Ignore the error message, it is not reporting the problem correctly, it simply means that you have an illegal character somewhere in the XML. Looking at your code I would say it is the qevents.startDate and .endDate are they problem contain slashes which would not be allowed. Try replacing them with - signs like you have the events tag. Andrew. On Sat, 13 Nov 2004 02:58:23 -0500, dave [EMAIL PROTECTED] wrote: i have the following code that after getting info from a form (date fields and a text area with a text editor) then writes to db which then writes to and xml file when im outputting the xml file i get this error (or similar ones that suggest a problem with proper xml output the description field can have html formating even if i put enclose the description field with cdata tags i still get error Illegal character at end of document, #x3c;. Illegal character at end of document, . heres the relevant code CFXML variable=eventsXML events startDate=2004-11-01 endDate=2020-12-31 cfoutput query=qevents event title=#qevents.title# description=#qevents.description# startDate=#qevents.startDate# endDate=#qevents.endDate# / /cfoutput /events /CFXML cffile action=write file=#HOMEPAGE#xml/CalXml.xml output=#ToString(eventsXML)# ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184207 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
Application Variables
Hi Everyone I have an application that is storing information in applications variables. I need each of this variables to be available for about 1 hour . I have created a application.cfm file with a CFAPPLICATION tag as follows: cfapplication name=theWebSite applicationTimeout=#CreateTimeSpan(0,1,0,0)# Will this automatically remove variables after the timeout time if they are not re-wrote, or will they stay there until the whole application is not used by anyone for 1 hour? Thanks Andrew. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183746 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: Application Variables
Hi Ian. That is what I thought, but it was worth checking. Thanks. Andrew. On Tue, 9 Nov 2004 08:43:02 -0800, Ian Skinner [EMAIL PROTECTED] wrote: The latter, you will have to do something more sophisticated to remove the variables. Something along the lines of storing their creation data/time and then removing the values after the hour is up. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183806 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
CFHTTP problem
Hi All. I'm having a problem getting access to a service via HTTP. The problem I'm having is that the Post Header the service requires starts: POST /DCDS/AvailSearch.exe HTTP/1.1 and at the moment I'm using a CFHTTP with method=Post and getting: POST HTTP/1.1 Any ideas how I get the other bit into this string? Thanks. Andrew. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183595 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: CFHTTP problem
Ignore me... I was being thick... The /DCDS/AvailSearch.exe is simply the path the file I need to post the data to. Andrew. On Mon, 8 Nov 2004 11:45:39 +, Andrew Dixon [EMAIL PROTECTED] wrote: Hi All. I'm having a problem getting access to a service via HTTP. The problem I'm having is that the Post Header the service requires starts: POST /DCDS/AvailSearch.exe HTTP/1.1 and at the moment I'm using a CFHTTP with method=Post and getting: POST HTTP/1.1 Any ideas how I get the other bit into this string? Thanks. Andrew. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183598 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: Verity not installed?
This is driving me up the wall now... I have installed the hotfix for 6.1 and Verity/Linux: http://www.macromedia.com/support/coldfusion/ts/documents/hotfix_verity_linux.htm This made no difference. I then installed the 6.1 updater and this has made no difference. Any other ideas? Andrew. On Tue, 2 Nov 2004 10:34:47 -0700, Figy, Kam [EMAIL PROTECTED] wrote: http://www.houseoffusion.com/cf_lists/messages.cfm/threadid:855/forumid: 14 This was related to RedHat 7.2, but the same dependency issues might relate in Fedora. HTH Kam -Original Message- From: Andrew Dixon [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 02, 2004 3:19 AM To: CF-Talk Subject: Verity not installed? Hi Everyone. I have just installed a new system with CFMX6.1 on a Linux (done it lots of time before) and it all installed ok. I then started to do some configuration for my application in CF Admin and when I got to the bit to set up Verity collections I clicked the 'Verity Collections' click on the right and in the window on the left, instead of showing me the collections interface it says: You must configure your application server to enable Verity. For instructions, see Installing and Using ColdFusion MX. I have never had this before and I have looked the the Installing and Using ColdFusion MX document on the MM website and I can't see any mention of this. Anyone have any ideas what is going on and how I can fix the problem? Best Regards Andrew. ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=36 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183240 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
Verity not installed?
Hi Everyone. I have just installed a new system with CFMX6.1 on a Linux (done it lots of time before) and it all installed ok. I then started to do some configuration for my application in CF Admin and when I got to the bit to set up Verity collections I clicked the 'Verity Collections' click on the right and in the window on the left, instead of showing me the collections interface it says: You must configure your application server to enable Verity. For instructions, see Installing and Using ColdFusion MX. I have never had this before and I have looked the the Installing and Using ColdFusion MX document on the MM website and I can't see any mention of this. Anyone have any ideas what is going on and how I can fix the problem? Best Regards Andrew. ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=36 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183104 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: Verity not installed?
We are using Fedora Core 2 (which I know is not official supported) but we have other machine and it worked out of the box. Andrew. On Tue, 2 Nov 2004 07:53:06 -0500, JT News [EMAIL PROTECTED] wrote: What version/distro of Linux are you on? have you patched your CFMX 6.1 with the fixes for verity? -- Exciteworks, Inc Expert Hosting for less! *Ask for a free 30 day trial!* http://exciteworks.com Plans starting at -$12.95- including MS SQL Server! ~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183113 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: error Cannot create cookie: path = /
-XX:MaxPermSize=128m On Sat, 23 Oct 2004 11:54:56 -0500, Rich Tretola [EMAIL PROTECTED] wrote: What do you have your XX:MaxPermSize= set to? Rich ~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182431 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
Out of Memory
Hi Everyone. We noticed that our CF server service restarted itself twice today, and then after checking the cfserver.log file, just before the start up is logged it had the following: out of memory autorestart: Restarting process The server has 1Gb RAM and the JVM setting under CF Admin are set to: Minimum JVM Heap Size (MB): 512 Maximum JVM Heap Size (MB): 512 Does this error message mean that CF needed more than 512Mb, i.e. we need to increase the value? or is there something else wrong? Best Regards Andrew. ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182335 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: Out of Memory
Hi 15 mins prior to the restart there was a whole load of this message: 10/22 15:46:17 error Cannot create cookie: expires = Sun 10/22 15:46:17 error Cannot create cookie: path = / from 15:14 to 15:46, it happen 258 times. Apart from that nothing else apart from the startup messages. Andrew. On Fri, 22 Oct 2004 16:43:04 +0100, Andy Allan [EMAIL PROTECTED] wrote: Check your logs under cfmx/runtime/logs as well .. what are they saying? Andy On Fri, 22 Oct 2004 16:38:02 +0100, Andrew Dixon [EMAIL PROTECTED] wrote: Hi Everyone. We noticed that our CF server service restarted itself twice today, and then after checking the cfserver.log file, just before the start up is logged it had the following: out of memory autorestart: Restarting process The server has 1Gb RAM and the JVM setting under CF Admin are set to: Minimum JVM Heap Size (MB): 512 Maximum JVM Heap Size (MB): 512 Does this error message mean that CF needed more than 512Mb, i.e. we need to increase the value? or is there something else wrong? Best Regards Andrew. ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182340 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 to remove link
cfset replaceStr = REReplace(str, a href[^]*|/a, , ALL) where str is the string you wish to make the replacement in. On Fri, 22 Oct 2004 11:31:41 -0500, Greg Morphis [EMAIL PROTECTED] wrote: can someone assist me in creating a regex that would remove a link from text. The link is dynamic.. IE.. text = Upload Document Here bra href='/atc/upload/?action=edittestplan=21' target='_blank'Upload Docs/a text should equal = Upload Document Here thanks in advance ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=36 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182357 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 to remove link
Ok. If you wish to remove all the text, do this: cfset replaceStr = REReplace(str, a href[^]*.*/a, , ALL) Andrew. On Fri, 22 Oct 2004 13:43:52 -0400, Jerry Johnson [EMAIL PROTECTED] wrote: This gets rid of the tags, but not what's inside the A tags. Greg, what version of CF are you running (5.0 or less or CFMX)? Jerry Johnson [EMAIL PROTECTED] 10/22/04 01:35PM cfset replaceStr = REReplace(str, a href[^]*|/a, , ALL) where str is the string you wish to make the replacement in. On Fri, 22 Oct 2004 11:31:41 -0500, Greg Morphis [EMAIL PROTECTED] wrote: can someone assist me in creating a regex that would remove a link from text. The link is dynamic.. IE.. text = Upload Document Here bra href='/atc/upload/?action=edittestplan=21' target='_blank'Upload Docs/a text should equal = Upload Document Here thanks in advance ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=38 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182363 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: error Cannot create cookie: path = /
I have the same problem as this and already have the setting -Xms512m -Xmx512m and it doesn't help. Looking at my logs I think this problem only started with the install of CFMX6.1 Updater. Do you have the updater installed? Andrew. On Fri, 22 Oct 2004 12:52:02 -0500, Rich Tretola [EMAIL PROTECTED] wrote: Where do I edit this line: -Xms512m -Xmx512m ? Rich On Fri, 22 Oct 2004 13:12:07 -0400, Douglas Knudsen [EMAIL PROTECTED] wrote: there are numerous resources for this. Search the cf-talk archives for sure. Here are some refs http://www.macromedia.com/support/coldfusion/ts/documents/cfmx_perf_tips.htm http://www.petefreitag.com/item/89.cfm http://www.talkingtree.com/blog/index.cfm?getCategory=ColdFusionstart=130 in short you mod the jvm.config filemodify the -xms and -xmx values for example -Xms512m -Xmx512m not to be raised to arbitrarily large values though, eh? Doug On Fri, 22 Oct 2004 11:52:09 -0500, Rich Tretola [EMAIL PROTECTED] wrote: Here are my stats: Free Allocated Memory: 14mb Total Memory Allocated: 179mb Max Memory Available to JVM: 493mb % of Free Allocated Memory: 8% % of Available Memory Allocated: 36% Can I increase the memory available? Rich On Fri, 22 Oct 2004 11:39:42 -0500, Rich Tretola [EMAIL PROTECTED] wrote: How could I check the jvm memory and it there a way to increase it if I need to? Rich On Fri, 22 Oct 2004 12:16:47 -0400, Dave Watts [EMAIL PROTECTED] wrote: So what do you think? I notice that the exp day in the error is always 2 days from today which is my default timeout for application variable timeout. Actually, I think that the problem doesn't have anything to do with your code. I was at a client's site yesterday, and they had the same log errors. Their site was crashing frequently, and I think that they were having problems with the JVM running out of memory. So, you might want to look into that. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=38 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182364 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: Out of Memory
No, it is running as a stand alone using Apache Andrew. On Fri, 22 Oct 2004 14:26:06 -0400, Broner, Mark, CON, OASD(HA)/TMA [EMAIL PROTECTED] wrote: Are you running CF as stand alone or on top of J2EE app server? If you are running on top of an app server and you are getting the java.lang.outofmemory error then it is because of hung threads inside your JVM. Mark -Original Message- From: Andrew Dixon [mailto:[EMAIL PROTECTED] Sent: Friday, October 22, 2004 9:38 AM To: CF-Talk Subject: Out of Memory Hi Everyone. We noticed that our CF server service restarted itself twice today, and then after checking the cfserver.log file, just before the start up is logged it had the following: out of memory autorestart: Restarting process The server has 1Gb RAM and the JVM setting under CF Admin are set to: Minimum JVM Heap Size (MB): 512 Maximum JVM Heap Size (MB): 512 Does this error message mean that CF needed more than 512Mb, i.e. we need to increase the value? or is there something else wrong? Best Regards Andrew. ~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182386 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: error Cannot create cookie: path = /
MM recommend setting the min and max to same value as it make CF more efficient as it doesn't have to do load of 'garbage collection'. I have mine set to 512 and 512 on a 1Gb RAM machine. Andrew. On Fri, 22 Oct 2004 13:21:59 -0500, Rich Tretola [EMAIL PROTECTED] wrote: I just updated the other day and just started seeing these entries. The updater fixed many other problems through so it was worth it. Should I have a value set for my minimum heap size? Currently that field is blank and the max heap size field is at 512mb. Again. the machine has 2 gigs of ram. Rich On Fri, 22 Oct 2004 19:11:14 +0100, Andrew Dixon [EMAIL PROTECTED] wrote: I have the same problem as this and already have the setting -Xms512m -Xmx512m and it doesn't help. Looking at my logs I think this problem only started with the install of CFMX6.1 Updater. Do you have the updater installed? Andrew. On Fri, 22 Oct 2004 12:52:02 -0500, Rich Tretola [EMAIL PROTECTED] wrote: Where do I edit this line: -Xms512m -Xmx512m ? Rich On Fri, 22 Oct 2004 13:12:07 -0400, Douglas Knudsen [EMAIL PROTECTED] wrote: there are numerous resources for this. Search the cf-talk archives for sure. Here are some refs http://www.macromedia.com/support/coldfusion/ts/documents/cfmx_perf_tips.htm http://www.petefreitag.com/item/89.cfm http://www.talkingtree.com/blog/index.cfm?getCategory=ColdFusionstart=130 in short you mod the jvm.config filemodify the -xms and -xmx values for example -Xms512m -Xmx512m not to be raised to arbitrarily large values though, eh? Doug On Fri, 22 Oct 2004 11:52:09 -0500, Rich Tretola [EMAIL PROTECTED] wrote: Here are my stats: Free Allocated Memory: 14mb Total Memory Allocated: 179mb Max Memory Available to JVM: 493mb % of Free Allocated Memory: 8% % of Available Memory Allocated: 36% Can I increase the memory available? Rich On Fri, 22 Oct 2004 11:39:42 -0500, Rich Tretola [EMAIL PROTECTED] wrote: How could I check the jvm memory and it there a way to increase it if I need to? Rich On Fri, 22 Oct 2004 12:16:47 -0400, Dave Watts [EMAIL PROTECTED] wrote: So what do you think? I notice that the exp day in the error is always 2 days from today which is my default timeout for application variable timeout. Actually, I think that the problem doesn't have anything to do with your code. I was at a client's site yesterday, and they had the same log errors. Their site was crashing frequently, and I think that they were having problems with the JVM running out of memory. So, you might want to look into that. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182387 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: Out of Memory
How did you get it to log that? We have about 80 sites on this server, so it would be very difficult to go and change of the code on each. Is there a way to log it in a global way? Andrew. On Fri, 22 Oct 2004 15:25:31 -0500, Christian Watt [EMAIL PROTECTED] wrote: Andy, Check the number of records being returned by your queries. I had this problem and no matter what you turn the JVm Heap size up to, it will not fix it. There is no good way to track this down. What I ended up doing is after every query ran, I logged the number of records returned. I discovered that one query was returning over 90,000 records everytime and the more often it ran, the more outofmemory errors I was getting. Hope this helps. Christian -Original Message- From: Andy Allan [mailto:[EMAIL PROTECTED] Sent: Friday, October 22, 2004 10:43 AM To: CF-Talk Subject: Re: Out of Memory Check your logs under cfmx/runtime/logs as well .. what are they saying? Andy On Fri, 22 Oct 2004 16:38:02 +0100, Andrew Dixon [EMAIL PROTECTED] wrote: Hi Everyone. We noticed that our CF server service restarted itself twice today, and then after checking the cfserver.log file, just before the start up is logged it had the following: out of memory autorestart: Restarting process The server has 1Gb RAM and the JVM setting under CF Admin are set to: Minimum JVM Heap Size (MB): 512 Maximum JVM Heap Size (MB): 512 Does this error message mean that CF needed more than 512Mb, i.e. we need to increase the value? or is there something else wrong? Best Regards Andrew. ~| Protect your mail server with built in anti-virus protection. It's not only good for you, it's good for everybody. http://www.houseoffusion.com/banners/view.cfm?bannerid=39 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182406 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
OT: Field Naming
Hi Everyone. I'm just starting a major project for a government client and the first job is to design the database. Is there any recongnised convention on the naming of database fields. In the past I have always named them [table_name_field_name] for example: projects_id where the table is called 'projects' and the field is called 'id'. Thanks in advanced. Best Regards Andrew. ~| The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in the Washington DC Area. http://www.houseoffusion.com/banners/view.cfm?bannerid=44 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181817 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: OT: Field Naming
After a quick search on Google I found this: http://www.ss64.com/orasyntax/naming.html Which seems like a good little guide. It mentions an ISO standard (ISO11157) but I had a quick look at this and this appears to be a more general standard for data type naming. Andrew. On Tue, 19 Oct 2004 14:11:15 +0100, Keith Gaughan [EMAIL PROTECTED] wrote: Andrew Dixon wrote: Hi Everyone. I'm just starting a major project for a government client and the first job is to design the database. Is there any recongnised convention on the naming of database fields. In the past I have always named them [table_name_field_name] for example: projects_id where the table is called 'projects' and the field is called 'id'. None that I know of, but what I do is use plural in general for the table names, e.g. categories, posts. After all, we are talking about sets here, and it's natural to pluralise them. Fields I give the singular form to, so the projects would have a field called project_id. The reasoning being that whereas the set contains many projects, hence the pluralisation, each tuple refers to just one, so it's singular. K. -- Keith Gaughan, Developer Digital Crew Ltd., Pembroke House, Pembroke Street, Cork, Ireland http://www.digital-crew.com/ ~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181825 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: OT: Field Naming
Hi Jochem. No. They have no other database at the the moment. At the moment all the data is keep in a strange series of Excel sheets which has become unmanageable (I'm attempting to decipher at the moment). The reason I asked the question was because in a recent meeting with them one of them asked if there was a standard naming convention we could use, you know what government people are like, love their standards and conventions!!! Andrew. On Tue, 19 Oct 2004 16:08:54 +0200, Jochem van Dieten [EMAIL PROTECTED] wrote: Andrew Dixon wrote: I'm just starting a major project for a government client and the first job is to design the database. Is there any recongnised convention on the naming of database fields. Does the client have other databases? Which convention do they use? Jochem ~| The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in the Washington DC Area. http://www.houseoffusion.com/banners/view.cfm?bannerid=44 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181836 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: Fusebox.org downloads down? Core files mirror?
If you post a message in the Fusebox forum on the fusebox site someone will email them to you. There download server is always going offline. Andrew. On Tue, 12 Oct 2004 11:36:17 -0400, hofo [EMAIL PROTECTED] wrote: Hey, I'm having trouble downloading a new set of FB4 core files from the Fusebox site. The new window to downloads.fusebox.org displays some terse JRUN connection error.Is there a mirror somewhere? -- Howard Fore, [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Pgp signing email with cf
Hi. We use the following CFC with CFMX6.1 and PGP8.03: http://tamuri.cfdeveloper.co.uk/ Andrew. On Wed, 6 Oct 2004 13:11:55 +0100, Craig Dudley [EMAIL PROTECTED] wrote: Is anyone currently doing this succesfully? If so, which version of pgp are you using? Any recommendations for one of the available cf pgp tags? Thx Craig Dudley Senior Developer Netstep Corporate Communications Ltd Direct Line: +44(0) 1422 319712 Phone: +44(0) 1422 200308 Fax: +44(0) 1422 200306 e-mail: [EMAIL PROTECTED] MS Messenger: [EMAIL PROTECTED] www: www.netstep.co.uk [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Jrun processing running at 100%
Hi. We have a very strange problem on our Windows 2003 Serer. Since yesterday the Jrun process keeps maxing out and using 100% CPU (in task manager). Nothing on the server has been changed (no updates or code) so I do not think it is anything like that. Anyone had this problem? Any ideas? Andrew. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Jrun processing running at 100%
Ok. We are running MX6.1 with updater. There is some code there that use CFHTTP. I will try applying the hot-fix and see if that helps. Thanks. Andrew. On Wed, 6 Oct 2004 14:22:35 +0100, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Do you have any CFHTTP calls in your code? Also what version CF, what JVM and what hotifixes?I would say that if you have applied the 6.1 Updater you will be required to reapply the Client Variables Purge Hotfix which seems to have been omitted from the final 6.1 Updater build. N _ From: Hugo Ahlenius [mailto:[EMAIL PROTECTED] Sent: 06 October 2004 14:20 To: CF-Talk Subject: RE: Jrun processing running at 100% how about log files? you can also try some thread dumps (stack traces), to see what they say... http://www.macromedia.com/support/jrun/ts/documents/tn18362.htm -- Hugo Ahlenius - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: Andrew Dixon [mailto:[EMAIL PROTECTED] | Sent: Wednesday, October 06, 2004 15:12 | To: CF-Talk | Subject: Jrun processing running at 100% | | Hi. | | We have a very strange problem on our Windows 2003 Serer. | Since yesterday the Jrun process keeps maxing out and using | 100% CPU (in task manager). Nothing on the server has been | changed (no updates or | code) so I do not think it is anything like that. Anyone had | this problem? Any ideas? | | Andrew. | | _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Jrun processing running at 100%
I have installed the hotfix... Lets see if it lasts!!! Andrew. On Wed, 6 Oct 2004 14:42:05 +0100, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Yeah, he is the link http://www.macromedia.com/support/coldfusion/ts/documents/client_purge_updat er.htm http://www.macromedia.com/support/coldfusion/ts/documents/client_purge_upda ter.htm Also, ensure that your CFHTTP calls have timeouts sent lower or equal to the timeout set in the CFIDE as setting it above can cause MX to crash/100% CPU. It is always best to have a timeout= rather than no timeout as MX will wait indefinitely for the page to complete and override the CFIDE and can cause 100% CPU. N _ From: Andrew Dixon [mailto:[EMAIL PROTECTED] Sent: 06 October 2004 14:29 To: CF-Talk Subject: Re: Jrun processing running at 100% Ok. We are running MX6.1 with updater. There is some code there that use CFHTTP. I will try applying the hot-fix and see if that helps. Thanks. Andrew. On Wed, 6 Oct 2004 14:22:35 +0100, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Do you have any CFHTTP calls in your code? Also what version CF, what JVM and what hotifixes?I would say that if you have applied the 6.1 Updater you will be required to reapply the Client Variables Purge Hotfix which seems to have been omitted from the final 6.1 Updater build. N _ From: Hugo Ahlenius [mailto:[EMAIL PROTECTED] Sent: 06 October 2004 14:20 To: CF-Talk Subject: RE: Jrun processing running at 100% how about log files? you can also try some thread dumps (stack traces), to see what they say... http://www.macromedia.com/support/jrun/ts/documents/tn18362.htm -- Hugo Ahlenius - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: Andrew Dixon [mailto:[EMAIL PROTECTED] | Sent: Wednesday, October 06, 2004 15:12 | To: CF-Talk | Subject: Jrun processing running at 100% | | Hi. | | We have a very strange problem on our Windows 2003 Serer. | Since yesterday the Jrun process keeps maxing out and using | 100% CPU (in task manager). Nothing on the server has been | changed (no updates or | code) so I do not think it is anything like that. Anyone had | this problem? Any ideas? | | Andrew. | | _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Relocate but include form fields
Hi Everyone. I have been given some code by a online payment system company to show how I redirect someone to there site. The way they have done I have to include a list of form fields in a form and submit that form a CF script on my server and that then does some encrpyting of the data and then redirects to their server. However, I'm not happy with the way it does the redirect as it requires _javascript_, and as I know from experiance some people turn _javascript_ off for 'security reasons' and the like. Here is the their example code: cfoutput FORM action="" method=post id=form1 name=Test input type=hidden name=VPSProtocol value=2.20 input type=hidden name=TxType value=PAYMENT input type=hidden name=Vendor value=#VendorName# input type=hidden name=Crypt value=#Crypt# /FORM /cfoutput script language=_javascript_ type=text/_javascript_ document.Test.submit(); /script Personally I think this is terrible, so my question is how do I do the same redirect in CF? Surely I can it some how? Thanks Andrew. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Postgresql setup
Hi Everyone. Can anyone explain or point me in the direction of a web page that explains how to set-up a Postgresql database with CFMX. Thanks. Andrew. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Postgresql setup
Excellent thanks. Andrew. - Original Message - From: Jochem van Dieten [EMAIL PROTECTED] Date: Sat, 02 Oct 2004 16:13:32 +0200 Subject: Re: Postgresql setup To: CF-Talk [EMAIL PROTECTED] Andrew Dixon wrote: Can anyone explain or point me in the direction of a web page that explains how to set-up a Postgresql database with CFMX. http://www1.oli.tudelft.nl/jochemd/index.cfm?PageID=16 Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Possible Bug with Dates
Hi Paul. I fixed it by simply removing the day comma part, but that is not really the point as it is meant to accept it. I will report it to MM. Andrew. - Original Message - From: Paul Vernon [EMAIL PROTECTED] Date: Mon, 27 Sep 2004 16:36:46 +0100 Subject: RE: Possible Bug with Dates To: CF-Talk [EMAIL PROTECTED] CFMX6.1 Updater on Windows 2k. I get exactly the same as you describe using your code. Tuesday, Wednesday and Thursday all blow up... Interestingly though, if I set the day to Tues everything works... Wed breaks but Wedn works... Thur works... Interesting... I guess a Left(dayname, 4) should fix it for you :) Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Hot-fixes
As far as I understand it, the updater includes all hotfixes and security patches up-to when it was released, so I would guess so. Andrew. - Original Message - From: Plunkett, Matt [EMAIL PROTECTED] Date: Tue, 28 Sep 2004 15:47:03 -0400 Subject: RE: Hot-fixes To: CF-Talk [EMAIL PROTECTED] Does the updater include MPSB03-06, MPSB03-07, MPSB04-01, and MPSB04-02? -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, September 24, 2004 7:44 PM To: CF-Talk Subject: Re: Hot-fixes Earl, George wrote: What if you are building a new server (migrating from CF 5) - do you install CFMX 6.1 and stop there, or do you also install the recently released updater, or do you install individual hot fixes based on your knowledge and what you feel is appropriate? Everything. Jochem _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: How does CF Mail Server Work?
AOL do a reserve lookup on the server so you need to have a PTR record set up for your mail server, otherwise they will reject it. This is how we fixed our problem with sending stuff to AOL. Andrew. - Original Message - From: B G [EMAIL PROTECTED] Date: Sun, 26 Sep 2004 10:20:29 -0500 Subject: How does CF Mail Server Work? To: CF-Talk [EMAIL PROTECTED] My site sends a fairly large number of emails on a daily basis.In addition to newsletters that are sent to subscribers there are notifications of a variety of types (message board, requests for info, registrations, etc) As the newsletter subscriber list grows I am trying to manage it better by unsubscribing users that have email addresses that are no longer valid.I have written a script that reads bounced messages, finds the email address, matches it against certain tables and takes the appropriate action.This part works ok.But I am noticing that all AOL users and large groups of other domains are all rejected.The bounced message doesn't say why.Just that delivery failed. When I send an email via my personal account to an address (AOL) that was rejected when it came from the web site it appears to be received ok.The two email addresses I am sending from have the same domain so I don't think that that whole domain or IP has been blacklisted. Also, in the event viewer I see errors like Could not connect to domain xxx.com which I don't understand. System is Win2000, CFMX 6.1 Enterprise using Windows mail server. I realize this question is vague but the gist is this:What is mail server doing that needs to connect to a domain in order to delivery an email? Could this be what is causing some mails to be rejected?Could a specific address be blocked (note:messages that are bounced because of suspected spam have a different message) ? Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Hot-fixes
Hi Everyone. I have been speaking someone at Macromedia about getting a mailing list set up to alert users about Hot-fixes, and the reason that was given for not have a list was, and I quote: With hotfixes, we recommend that you install them only if you need them. Unlike security bulletins, we expect people to look for a hotfix to solve a specific problem - not to install every hotfix. Personally I think this sounds very strange as bug fix is a bug fix whether you need it or not. Ok I agree that unless you are suffering from the problem caused by the bug, you are not going to benefit from the fix straight away, but surely it is still better to have the fix installed and the bug removed than leave the bug there only to fall over it some time down the line. What does everyone else think? Andrew. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: javascript check?
Try setting a cookie using JS then reading that cookie. If you can read it JS is on, if not JS is off. But if they have a cookie switched off or a firewall that blocks them then this will not work. _javascript_ might be on but cookie off. This is what I use: In the head tag add this: script type=text/_javascript_ self.location=/index.cfm?jsenabled=1; /script meta http-equiv=refresh content=1;url=""> Then in you code check the value of the jsenabled url variable. Andrew. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Hot-fixes
Ok, but do you install them all? Because from what MM said they don't think you should. Andrew. - Original Message - From: John Beynon [EMAIL PROTECTED] Date: Fri, 24 Sep 2004 11:38:48 +0100 Subject: Re: Hot-fixes To: CF-Talk [EMAIL PROTECTED] I just have Firefox configed to watch the hotfix page (http://www.macromedia.com/support/coldfusion/ts/documents/tn17883.htm) for changesworks for me, jb. On Fri, 24 Sep 2004 11:33:38 +0100, Andrew Dixon [EMAIL PROTECTED] wrote: Hi Everyone. I have been speaking someone at Macromedia about getting a mailing list set up to alert users about Hot-fixes, and the reason that was given for not have a list was, and I quote: With hotfixes, we recommend that you install them only if you need them. Unlike security bulletins, we expect people to look for a hotfix to solve a specific problem - not to install every hotfix. Personally I think this sounds very strange as bug fix is a bug fix whether you need it or not. Ok I agree that unless you are suffering from the problem caused by the bug, you are not going to benefit from the fix straight away, but surely it is still better to have the fix installed and the bug removed than leave the bug there only to fall over it some time down the line. What does everyone else think? Andrew. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Hot-fixes
But on development systems I install everything. But then your development environment and production environment are different. So if you create something that works in the development environment it might not work in the production environment. Andrew. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Hot-fixes
Ok, but until you install it you are not going to know if the hot-fix has extra bugs in it. I agree that if a server is stable then installing hot-fixes doesn't make sense. I guess my point is more that would be nice to be informed a new fix is available and be given the chance to evaulate it. Andrew. - Original Message - From: Dave Watts [EMAIL PROTECTED] Date: Fri, 24 Sep 2004 09:27:09 -0400 Subject: RE: Hot-fixes To: CF-Talk [EMAIL PROTECTED] I have been speaking someone at Macromedia about getting a mailing list set up to alert users about Hot-fixes, and the reason that was given for not have a list was, and I quote: With hotfixes, we recommend that you install them only if you need them. Unlike security bulletins, we expect people to look for a hotfix to solve a specific problem - not to install every hotfix. Personally I think this sounds very strange as bug fix is a bug fix whether you need it or not. Ok I agree that unless you are suffering from the problem caused by the bug, you are not going to benefit from the fix straight away, but surely it is still better to have the fix installed and the bug removed than leave the bug there only to fall over it some time down the line. What makes you think the hotfix has no bugs of its own? If something works satisfactorily, you may be better off leaving it as it is. Hotfixes address specific problems, but they potentially introduce new unknown problems. The best example I can think of is with the database drivers. There were all sorts of problems with the database drivers shipped with CFMX 6.1, but there are also problems with the newer drivers. For most people I've dealt with, the new problems are less serious than the old ones, but it hasn't been that way for everyone. Granted, some of the hotfixes are very simple, and unlikely to have bugs, but this is something you'd want to evaluate on a case-by-case basis. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Hot-fixes
If it was a new box I would install everything right up-to-date. Andrew. - Original Message - From: Earl, George [EMAIL PROTECTED] Date: Fri, 24 Sep 2004 13:26:01 -0400 Subject: RE: Hot-fixes To: CF-Talk [EMAIL PROTECTED] ... snipped ... I agree that if a server is stable then installing hot-fixes doesn't make sense. ... snipped ... Andrew. What if you are building a new server (migrating from CF 5) - do you install CFMX 6.1 and stop there, or do you also install the recently released updater, or do you install individual hot fixes based on your knowledge and what you feel is appropriate? George [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Converting query to comma separated list
Why don't you just CFLOOP over the query? You don't need to convert the query to a comma list to loop over it... CFLOOP query=qry_name) ...cf code... /CFLOOP Andrew. - Original Message - From: Mark Henderson [EMAIL PROTECTED] Date: Thu, 23 Sep 2004 21:07:07 +1200 Subject: Converting query to comma separated list To: CF-Talk [EMAIL PROTECTED] My first question, though I suspect this might not be the best approach . Is it possible to turn a query (cfdirectory in this case) into a comma separated list? The reason I ask is bcos currently I have a hardcoded list of folders in my action file, and I loop through and pull all the files from each. Like so... cfloop index = thisItem list = maps,districtPlans,mgmtPlans cfdirectory name=getAllFiles action=""> directory=#serverdir##thisItem# sort=name ASC cfquery dbtype=query name=getAllFiles_#thisItem# SELECT * FROM getAllFiles /cfquery /cfloop and in the display page something like... ol cfoutput query=getAllFiles_maps #replace(listFirst(name), _, , ALL)#br / /cfoutput /ol ol cfoutput query=getAllFiles_mgmtPlans #replace(listFirst(name), _, , ALL)#br / /cfoutput /ol etc etc This is all working fine. BUT, instead of hardcoding the list, I can do another directory call like so... cfdirectory name=getAllFolders action=""> directory=#serverdir# sort=name ASC which will give me all the folders that are in the above list (ie maps,districtPlans etc). So, how to get the query to a list so I don't need to hardcode? OR, is this the wrong approach and is it possible to use the getAllFolders query directly in some fashion? TIA Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Converting query to comma separated list
That look like what I was thinking of. Just make sure that if you are using an older version of CF (CF4/5 I think) that CFDIRECTORY returned the . and .. directories, but CFMX doesn't do this. As you say it works I'm guess you are on CFMX. Andrew. - Original Message - From: Mark Henderson [EMAIL PROTECTED] Date: Thu, 23 Sep 2004 22:14:06 +1200 Subject: Re: Converting query to comma separated list To: CF-Talk [EMAIL PROTECTED] Thank you for the swift replies Andrew and Kola, and you're right Andrew. I'd already tried something similar, but was making it more complicated than necessary. Here's what works cfdirectory name=getAllFolders action=""> directory=#serverdir# sort=name ASC cfloop query = getAllFolders cfdirectory name=getAllFiles action=""> directory=#serverdir##name# sort=name ASC cfquery dbtype=query name=getAllFiles_#name# SELECT * FROM getAllFiles /cfquery /cfloop adieu Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Tiem Format problems
Hi. This works. cfset plus17h = DateAdd(h, 17, now()) cfoutput #DateFormat(plus17h, dd/mm/)# #TimeFormat(plus17h, HH:MM)# /cfoutput Andrew - Original Message - From: Seamus Campbell [EMAIL PROTECTED] Date: Wed, 22 Sep 2004 19:36:48 +1000 Subject: Tiem Format problems To: CF-Talk [EMAIL PROTECTED] hi I'm trying to pull a date/time from a database then add 17 hours to it and display in dd mmm h n format I thought I could add 17 hours to the date using DateAdd but this seems to have problems with the format and I can't work out how to get the time to be plus 17 hours Or is there a way to add 17 hours to the date in the database? Help please Seamus Seamus CampbellBoldacious WebDesign http://www.boldacious.com[EMAIL PROTECTED] ph 02 6297 4883mob 0410 609 267 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: [Reply To] RE: Tiem Format problems
Is your data and a date or a datetime? Andrew. - Original Message - From: Seamus Campbell [EMAIL PROTECTED] Date: Wed, 22 Sep 2004 20:05:10 +1000 Subject: [Reply To] RE: Tiem Format problems To: CF-Talk [EMAIL PROTECTED] Access You wrote Or is there a way to add 17 hours to the date in the database? What database are you using? -- Jay [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: [Reply To] RE: Tiem Format problems
Actually what do get if you do cfoutput of the date field without any formatting? Andrew. On Wed, 22 Sep 2004 11:46:35 +0100, Andrew Dixon [EMAIL PROTECTED] wrote: Is your data and a date or a datetime? Andrew. - Original Message - From: Seamus Campbell [EMAIL PROTECTED] Date: Wed, 22 Sep 2004 20:05:10 +1000 Subject: [Reply To] RE: Tiem Format problems To: CF-Talk [EMAIL PROTECTED] Access You wrote Or is there a way to add 17 hours to the date in the database? What database are you using? -- Jay [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ;amp in my URL's?
Are you getting the cgi.USER_AGENT variable? It could be being caused by a search engine spider, however so do set the spider to appear as if it is a standard browser, so you could get the IP address as well and then do a whois on it. Andrew. - Original Message - From: Casey C Cook [EMAIL PROTECTED] Date: Mon, 20 Sep 2004 18:40:17 -0700 Subject: ;amp in my URL's? To: CF-Talk [EMAIL PROTECTED] Im trapping a few errors per day which means probably 1-1000 users (or more) is experiencing this problem, and not sure what could be causing it. Basically if I look at the cgi.query_string it shows fuseaction=DisplayNewsamp;ContextID=MSAamp;ID=4324amp;GBT=Main vs. what it should be fuseaction=DisplayNewsContextID=MSAID=4324GBT=Main What would be placing amp; in my URL strings? I simulated the exact steps as the user but did not throw an error message. We are both clicking the link from same version of lotus notes, launching the same version internet explorer external from lotus notes. Im almost sure this is some sort of setting in the broswer or on the computer, unrelated to the application itself. Any insight would be appreciated. Thanks, Casey Cook [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: ot: jrun ?
Change the max memory variable in CFAdmin. Andrew. - Original Message - From: dave [EMAIL PROTECTED] Date: Tue, 21 Sep 2004 04:49:10 -0400 Subject: ot: jrun ? To: CF-Talk [EMAIL PROTECTED] is there anyway to setup jrun not to use so many resources on a dev machine? friggin killin my machine, and i need to run jrun so i can also run flex right now its taking up 130,152 kbs running 768mb ram, but sheesh [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFCONTENT
Hi. I believe, but I might be wrong, that it simply changes the HTTP Header to make the returned CF page appear to be an attached file instead of a HTML page and then pipes the files to the browser a binary object. I don't believe any temporary file is returned, but neither is the actually location of the file. Andrew. - Original Message - From: Steven Wojciechowski [EMAIL PROTECTED] Date: Tue, 21 Sep 2004 21:39:04 +0100 Subject: CFCONTENT To: CF-Talk [EMAIL PROTECTED] I'm looking to use CFCONTENT to provide the various files on my website as I am finding hotlinking a bit of a problem at the moment and want to stop it. I'm hosting on a Windows 2000 Server with IIS5 and CFMX (6.1) and plan on using CFCONTENT to check the referring page to make sure it came from my own site, the implementation of the code is not a problem, I know how I'm going to do that, however my questions concerns how the CFCONTENT tag actually works at a low level. The files I have on my site vary from 0.5MB to 20 or 30MB so I want to be able to estimate what kind of extra overhead I will create when I have 20 to 30 files being downloaded at any one time. Can anyone explain how the tag works? Does the tag create a temp file and tell IIS to return that file? (creating more drive access overhead and longer CF execution time) is the data to be returned piped to IIS instead? (creating memory usage overhead and longer CF execution time) or, does CF point IIS to the file that I want returned? (which should be the same resource wise as just directly linking to the file in the first place) Any help on this would be very useful. I had looked at Apache as an option for the server to use the .htaccess files to prevent hotlinking, however the server also needs to run several ASP applications which I've had difficulty getting going under Apache. Of course if anyone knows of another way to prevent hotlinking, I would be grateful to hear it :) thanks in advance, Stevie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Daily Server re-start with MX 6.1
Do you know if it is basic on a Windows 2003 Server? Andrew. - Original Message - From: Andrew Grosset [EMAIL PROTECTED] Date: Sat, 18 Sep 2004 14:00:04 -0400 Subject: Daily Server re-start with MX 6.1 To: CF-Talk [EMAIL PROTECTED] I am on a shared host running MX6.1 and I hava had no problems accept the server seems to restart on a 1 to 2 day basis. I have access to the cfschedule tag so I have just set it up to call a template that checks the exisitance of an application variable once an hour, if it is not defined it resets the variable and emails me the fact. Is it normal with MX6.1 to regularily restart the server, if I was on a dedicated server (just me) and my code was perfect..:) would I need to restart on a regular basis? Andrew. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Daily Server re-start with MX 6.1
That is probably why then. There is a problem with CFMX on Windows 2003 where the server service crashes and restarts itself at random. It happens on our 2003 server about 1 - 3 times a day and there appears to be nothing you can do about it. See the following CF Forum post. http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=2threadid=785970 Although someone marked my post as the answer, it only helps reduce the frequency of the problem and doesn't get rid of it all together. Sorry it doesn't really help. Andrew. - Original Message - From: Andrew Grosset [EMAIL PROTECTED] Date: Sat, 18 Sep 2004 17:28:54 -0400 Subject: Re: Daily Server re-start with MX 6.1 To: CF-Talk [EMAIL PROTECTED] Windows 2003 version 5.2, I'm not sure what you mean by basic? Do you know if it is basic on a Windows 2003 Server? Andrew. __ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Daily Server re-start with MX 6.1
Hi Paul. You may just simply have not noticed as the server does recover itself. Open up the 'Event Viewer' under 'Administrative Tools' and look in the application log and see if there are any entries with the 'Source' of 'Application Error'. If there is open up the details for that event and see if it says: Faulting application jrun.exe, version 4.0.3.10455, faulting module jvm.dll, version 0.0.0.0, fault address 0x00156e55. If it does then you have the problem as well. Our last entry was today at 16:38 GMT and prior to that was yesterday at 23:18 GMT. It appears to be completely random, but if you don't have the problem that I would consider yourself very lucky as I know many people with this problem. Andrew. - Original Message - From: Paul Vernon [EMAIL PROTECTED] Date: Sat, 18 Sep 2004 23:14:43 +0100 Subject: RE: Daily Server re-start with MX 6.1 To: CF-Talk [EMAIL PROTECTED] I have run CFMX 6.1 on our Win2003 server for months and have never experienced a restart of services that I didn't instantiate. Pre or post updaters/patches/hotfixes... Am I to consider myself lucky? Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CSS Editor
Topstyle that shipped with Coldfusion Studio is pretty good. The version with CF Studio was a 'Lite' version but there is a 'Pro' version which is even better. Take a look at: http://www.bradsoft.com/topstyle/index.asp Andrew. - Original Message - From: dave [EMAIL PROTECTED] Date: Fri, 17 Sep 2004 04:02:25 -0400 Subject: Re: CSS Editor To: CF-Talk [EMAIL PROTECTED] dreamweaver mx or dreamweaver mx 2004, big diff in the css between these -- Original Message -- From: Russell Patterson [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Fri, 17 Sep 2004 02:58:43 -0500 Hello, I use Dreamweaver MX but find the CSS editor lacking.Would any of you have any suggestions?I have looked at Style Master and TopStyle. Has anyone looked at Layout Master?Any suggestions are appreciated. Thanks! Russell [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cffile write question, sending but not parsing cf code
Not sure I have understood this right, but I assume the file you are trying create a CF Script, but remove the database call. In that case, you can put all your bits of script into a variable and than right that variable. The script will not be processed by CFFILE, for example: cfset pageString = this is some content cfset pageString = #pageString# cfset a = 1 cffile action="" file=/stories/2004-1234.cfm output=#pageString This will create the CF script and when called the CF parts will be processed. Andrew. - Original Message - From: mayo [EMAIL PROTECTED] Date: Wed, 15 Sep 2004 00:08:03 -0400 Subject: cffile write question, sending but not parsing cf code To: CF-Talk [EMAIL PROTECTED] I'm using cffile to allow a magazine site to publish articles and not have a db call everytime an article is selected. Is there anyway (aside from includes) that I can use send up cf code such as CGI.path_info without it being parsed when the cffile is being written? Example: For example /admin/createFile.cfm creates a file called /stories/2004-1234.cfm I would like CGI.path_info to display /stories/2004-1234.cfm not /admin/createFile.cfm I also would like to be able to have cfset etc... processed when the article is requested by the user and not when the CFFILE is executed. thx, hope this is understandable Gil [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: 2d array question
Hi. Personally I don't see anything different between your first way of doing it and the second. I would thing that the second way is simply doing the work CF would be doing behind the scenes anyway. The main problem you are going to have is that if your code tries to reference an array element that you have not defined, in this case [2][3] you will get a CF Error about it not existing. Personally I would say best practise would be to set the same number of elements in each row of the array, but leave the one's you are not using blank. So your example would end up being: cfscript my_test = arrayNew(2); my_test[1][1] = foo; my_test[1][2] = bar; my_test[1][3] = foobar; my_test[2][1] = foo1; my_test[2][2] = foo2; my_test[2][3] = ; /cfscript Then if you try and reference [2][3] you no longer get a CF error. Andrew. - Original Message - From: Charlie Griefer [EMAIL PROTECTED] Date: Wed, 15 Sep 2004 00:23:25 -0700 Subject: 2d array question To: CF-Talk [EMAIL PROTECTED] ok...in ColdFusion, a 2d array is a 1d array of 1d arrays.i think that's the first sentence in the docs under '2d arrays'.that's all well and good. i'm curious tho...is there any recommendation regarding the 2nd 'dimension' being uniform length?for example, if I have the following: cfscript my_test = arrayNew(2); my_test[1][1] = foo; my_test[1][2] = bar; my_test[1][3] = foobar; my_test[2][1] = foo1; my_test[2][2] = foo2; /cfscript ... is that 'legal'?or should my_test[2] have a 3rd element in the 2nd dimension? If i'm in a situation where i'm going to have inconsistent numbers of elements in the 2nd dimension...is it 'better form' to create 1 dimensional arrays and then manually create a new array within each, a la: cfscript my_test = arrayNew(1); my_test[1] = arrayNew(1); my_test[1][2] = foo; my_test[1][2] = bar; my_test[1][3] = foobar; my_test[2] = arrayNew(1); my_test[2][1] = foo1; my_test[2][2] = foo2; /cfscript while the 2nd example is certainly the longer way around, it seems cleaner, in that each 'nested array' is created independently of the other, and therefore shouldn't care about different lengths. maybe i'm just being anal...but i feel like if i create a 2d array, then there is a distinct 'relationship' between all of the 2nd dimension values...and they should all be of a uniform length. is there any 'rule of thumb' as far as this is concerned? thx! -- Charlie Griefer Marta was watching the football game with me when she said, You know, most of these sports are based on the idea of one group protecting its territory from invasion by another group. Yeah, I said, trying not to laugh. Girls are funny. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CF/Flash Question
Hi Everyone. I'm about to create some flash navigation within a website that I'll need to have pass out the CFID and CFTOKEN session variables, does anyone know of an easy way to get these variables from within Flash or would i have to have them passed to the flash movie to start with? Andrew. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF/Flash Question
Hi Dave. Thanks for the info, but can you give me an example of how to pass the variables in the Flash parameters and the actionscript to pick them up. Bit new to Flash. Thanks. Andrew. - Original Message - From: dave [EMAIL PROTECTED] Date: Wed, 15 Sep 2004 06:16:33 -0400 Subject: Re: CF/Flash Question To: CF-Talk [EMAIL PROTECTED] just have a cfm page set them as variables then deliver them to flash by any of the available means depends on how ur going about it one of the easiest ways is to set the variables as normal in flash the output them with an $ infront of each, the do a loadvar in your flash movie -- Original Message -- From: Andrew Dixon [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Wed, 15 Sep 2004 11:10:13 +0100 Hi Everyone. I'm about to create some flash navigation within a website that I'll need to have pass out the CFID and CFTOKEN session variables, does anyone know of an easy way to get these variables from within Flash or would i have to have them passed to the flash movie to start with? Andrew. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF/Flash Question
I will give it a try and let you know.
Thanks.
Andrew.
On Wed, 15 Sep 2004 06:57:05 -0400, dave [EMAIL PROTECTED] wrote:
try this
cfm page ex: cfmvariables.cfm
-
!--- set uuid and cftoken variables ---
//set these how ever ur getting them (cookie, session, whatever)
cfset uuid = #youruuidstring#
cfset cftoken = #cftoken#
!--- set output to flash variables ---
cfoutput
uuid=#uuid#cftoken=#cftoken#
/cfoutput
---
in flash actionscript
---
// load cfm page variables
var my_cfmVars:LoadVars = new LoadVars();
my_cfmVars. {
if (success) {
trace(this.toString());
} else {
trace(Error loading/parsing LoadVars.);
}
};
my_cfmVars.load(http://www.yoursite.com/cfmvariables.cfm);
-
at this point the variables will be in flash
4:30 am does that make sense?
dave
-- Original Message --
From: Andrew Dixon [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:Wed, 15 Sep 2004 11:25:07 +0100
Hi Dave.
Thanks for the info, but can you give me an example of how to pass the
variables in the Flash parameters and the actionscript to pick them
up. Bit new to Flash.
Thanks.
Andrew.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Re: Basics Clarification
I have no idea why, as far as I know it don't actually cause any problem, but I think it just look bad and makes the code more difficult to read. Andrew. - Original Message - From: Steve Brownlee [EMAIL PROTECTED] Date: Wed, 15 Sep 2004 05:37:44 -0700 Subject: Basics Clarification To: CF-Talk [EMAIL PROTECTED] We've all said it a million times - don't use the hashes inside a CF tag that processes on its own. !--- No no no --- cfif #check# eq 1 But one thing I've always wondered is why.I know doing this is wrong from years of seeing people scream at developers who do it, but I never heard an explanation as to what problems this causes.Anyone know the guts behind this? - Steve [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Basics Clarification
Try reading this article by the mighty Ben Forta. It is titled: To # or not to # http://www.defusion.com/articles/index.cfm?ArticleID=26 Andrew - Original Message - From: Claude Schneegans [EMAIL PROTECTED] Date: Wed, 15 Sep 2004 11:24:24 -0400 Subject: Re: Basics Clarification To: CF-Talk [EMAIL PROTECTED] But one thing I've always wondered is why. IMHO it's simply logic: the purpose of # delimiter is to specify that an _expression_ inside should be evaluated when it is not implied by context. Inside a CFIF, the content cannot be something else, then # are just useless. Furthermore, I would think that the interpreter will need a couple more steps to get to the same result. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFHTTP
That is never going to work as _javascript_ is client-side and CF is server-side. The CF script runs when the user requests the page. You will have to do something like get the _javascript_ to call a script on the server and pass the url entered as a query string on the script call URL, or do it as a form submission. Andrew. - Original Message - From: Luc Deault [EMAIL PROTECTED] Date: Tue, 14 Sep 2004 08:44:44 -0400 Subject: CFHTTP To: CF-Talk [EMAIL PROTECTED] I'm trying to get data (title of page) from a url which is passed with _javascript_. The set (gotolink) seems to work, but cfhttp doesn't seem to connect. The gotoLink output works also. What's wrong with my code? cfset goToLink = 'scriptdocument.write(window.opener.form.link_e.value);/script' cfoutputLink = #gotolink#/cfoutput cfhttp url="" resolveurl=no/cfhttp cfoutput#cfhttp.FileContent#/cfoutput [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFHTTP
Because when you output it the browser see the script tags and processes and the document.write writes the output to the browser. This however is done client-side and not server side. All the CF server is the script... part and output it to the browser. If you view the source in the browser you will see. Andrew. - Original Message - From: Luc Deault [EMAIL PROTECTED] Date: Tue, 14 Sep 2004 09:01:50 -0400 Subject: Re: CFHTTP To: CF-Talk [EMAIL PROTECTED] Don't want to be a pest but why is my first cfoutput actually outputting the right string? ___ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SMTP or Telnet tools?
We have had trouble get mail to AOL users as well. AOL told us that it was because are mail server didn't have a PTR record. We got one add and since then it doesn't appear to have been a problem. Just a suggestion. Andrew. - Original Message - From: Eric Dawson [EMAIL PROTECTED] Date: Sat, 11 Sep 2004 18:54:03 -0500 Subject: RE: SMTP or Telnet tools? To: CF-Talk [EMAIL PROTECTED] intrafoundation.com tcpclient _ From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: September 11, 2004 4:32 PM To: CF-Talk Subject: SMTP or Telnet tools? Hi, I'm looking for a way that I can execute a telnet/smtp session from my CF code and be able to review the responses from the smtp server for each command that is sent. For example, something like this: Open connection to mail.94percent.com send helo command read response send mail from: command read response send rcpt to: command read response send data command send data and . on last line to finish the send. I would obviously be adding some conditional code in there to take appropriate action based on the responses. I'm on CF MX 6.1 (updater 3) and have tried to use both IPWorks COM object and TCPCLIENT COM object to no avail.My server just freezes when I try to create the object.I'm assuming they're not compatible with mx 6.1. Any ideas? Thanks! Dave Phillips _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Verity or a classic search?
Personally I would use a verity search as you get a summary and score returned so you can create a results output similar to Google which most people are now fimilar with. Andrew. - Original Message - From: Jean Marc Bottin [EMAIL PROTECTED] Date: Fri, 10 Sep 2004 17:12:25 +0200 Subject: Verity or a classic search? To: CF-Talk [EMAIL PROTECTED] Hi guys, I looking for some advice. I have a DB with a table book which contains a field keywords. This field will be fill in with word separated by comma like (IT, Computer, Coldfusion, CFML, Web). This field can be updated and key words can be added or deleted. The user will use an UI with a search form where the search criterias could be: author, title and keywords for instance.The keywordfield will be a multiple select menu. My question is to know which one will be the faster to process for the application. A verity collection or a classic SQL query which will contain the specific keywords? Thanks, Jean-Marc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF5.0 and XML
If you just want to produce an XML file, that is simple. Create the XML code in a variable and write it to the file system using CFFILE. The functions in CFMX for XML mainly involved reading it, not writing it, so they probably wouldn't help you much anyway. Andrew. - Original Message - From: Mike Kear [EMAIL PROTECTED] Date: Thu, 9 Sep 2004 17:08:12 +1000 Subject: CF5.0 and XML To: CF-Talk [EMAIL PROTECTED] How easy is it to produce XML in CF5.0?I know that in CFMX there are a host of great XML-related tags, to make it easy, but what about turning a query into XML in CF5.0? It is straightforward?Are there any tutorials? -- Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com .com,.net,.org domains from AUD$20/Year [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Looping in CFSCRIPT
Hi Everyone. Does anyone know how to loop within CFSCRIPT over a query and/or a comma list, like you can with CFLOOP? Also, does anyone konw if there is a good guide to CFSCRIPT anywhere as the MM documentation of CFSCRIPT is pretty much none existant. Thanks Andrew. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Looping in CFSCRIPT
Thanks...
- Original Message -
From: joe velez [EMAIL PROTECTED]
Date: Thu, 09 Sep 2004 06:03:47 -0400
Subject: Re: Looping in CFSCRIPT
To: CF-Talk [EMAIL PROTECTED]
i havent actually played w/ cfscript too much, but in reading about it
briefly i believe its something like this
for a comma del. list
cfscript
var=0; /* not sure if var = 0 if you dont set it first, you can
probably exclude this, but set it to be safe */
while(VAR lte listlen(yourlist))
{
var++; // this should work or ...
var=var+1; //
// do stuff
}
/cfscript
for a query
cfscript
var=0;
while(VAR lte query.recordcoount) // might need #query.recordcount#
{
var++; // this should work or ...
var=var+1; //
// do stuff
}
/cfscript
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
