Re: model-glue on shared servers
thanks! I will definately check it out ~Dave the disruptor~ From: "Nick Tong - TalkWebSolutions.co.uk" <[EMAIL PROTECTED]> Sent: Monday, May 22, 2006 4:53 AM To: CF-Talk Subject: Re: model-glue on shared servers I have a 'MGR' quick start on my site: http://wapurl.co.uk/?YORN902 -- Nick Tong web: http://talkwebsolutions.co.uk blog: http://succor.co.uk shorturls: http://wapurl.co.uk ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241274 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: CFMX Java server recommendation
IIS is a webserver. JRun is a J2EE server to which the webserver connects - the J2EE server is responsible for running CF. You have done a standalone install of CF, which is actually using JRun in a hidden fashion. To move up to the full-blown JRun, you need to reinstall. However, you can already run JSP and servlets in the standalone config if you need to. On 5/24/06, Martin Thorpe <[EMAIL PROTECTED]> wrote: > Ok cool, sounds good. Alrhough I was trying to boost my CV with knowledge of > a well known server, here in Belgium, it is Weblogic/Jboss.. but I guess > going with what is there is the best bet. > > Although I now have another question. Looking at the server install there is > no JRun service running or installed in services, I think it might have been > installed to use IIS. Is there a way I can change this configuration to run > with JRun without having to re-install? > > I am definitely on Enterprise as checked in the CF admin. > > Cheers for the replys any how, thanks. -- CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241273 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: Functions: Len & Left Right
I'm not sure all the syntax is perfect, but something like... #Left(pressrel_story.pre_mainpress, NextParagraph) ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241272 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: Google Analytics?
Google A. Breakdown: Yeah it's great if your looking for savings against going the route of Omniture or Webtrends but it's not as intuitive, well it is in some sence, it can tell me the version of flash someon it running, Nice!!!. More setup work on your campaigns ahead of time is the worst part about it. I'm going to give one example because outside of this Google Analysis is great and a good fit for most websites. I can't even guarantee this is a good example because I don't sell anything anymore. Just my experience from having access to Omiture for a multi-mil account and what Google is providing. I'll bypass the setup of commerce applications because it's a pain in the ass either way. Slightly easier in Omniture but it's a one time deal when you add it to your e-cart nun-the-less I'd be more interested in the time it takes to setup a campaign. I might be wrong here. I'm just going off what I see... No true testing going on! Example: You have a product your selling: You send out your email campaign with a tracking link to your product page. Omniture: >>Add a unique tracking link as part of the url. - Meaning your just write it out at the end of your URL?campaignid=BlaBla-Sale >>Track your sales - Full Funnel Google: >>LOGIN TO GOOGLE!!! Bigest step here! >>Modify your Goal Settings: >>Goal Settings: G1 >>Add the details of the tracking stuff. >> Define Funnel (optional) - Umm, not in this case because you would like to track from an email campaign so you will have to set an entry point so this works correctly. >>Track your sales - Full Funnel If this if off base, let me know. I'd like to maybe blog about this on my new google/notebook hahaha... Casey Dougall ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241271 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: Functions: Len & Left Right
Do a Find() or REFind() for the next occurrence of after character 1900 (or whatever length) and go from there. On 5/24/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > All, > > I've got a Web based admin tool that publishes articles. Regardless > of the length of the story, I'm trying to cut the story off the text at a > certain length and display the "next page" hyperlink. The code below does > this ok. > > However, I want to detect the end of the paragraph so the reader completes > the paragraph before having to click on the "next page" link. Each paragraph > is always separated by a single tag. Right now, with the code below, I'm > gettiing words cut into peices and incomplete paragraphs. > > Any advice or gauidance would be much appreciated. > > > > > > > > > #left(pressrel_story.pre_mainpress, first_length)# > > > > > Next > Page -- CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241270 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
Functions: Len & Left Right
All, I've got a Web based admin tool that publishes articles. Regardless of the length of the story, I'm trying to cut the story off the text at a certain length and display the "next page" hyperlink. The code below does this ok. However, I want to detect the end of the paragraph so the reader completes the paragraph before having to click on the "next page" link. Each paragraph is always separated by a single tag. Right now, with the code below, I'm gettiing words cut into peices and incomplete paragraphs. Any advice or gauidance would be much appreciated. #left(pressrel_story.pre_mainpress, first_length)# Next Page D ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241269 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: cfloginuser
aha - cflogout was what i was missing. thanks dave. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241268 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: cfloginuser
> i can't get it to work. i have amended my function as follows... > > ... > > >password="#arguments.password#" roles="#variables.roles#"> > The CFLOGIN tag will only run for users that haven't already logged in. If you want to rerun CFLOGIN, you'd have to do something like this: ... I was thinking that maybe you could just run CFLOGINUSER. Normally, you only run that within the context of CFLOGIN, but this seems like an exceptional case. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241267 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: cfloginuser
i can't get it to work. i have amended my function as follows... UPDATE tblSecurity SET username = , password = WHERE profileID = // store authenticate method of security object as roles variable. variables.roles=authenticate(arguments.username,arguments.password); ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241266 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: cfloginuser
> Is it possible to update the cfloginuser name="#variable#", > while still logged in? No, I don't believe that this is possible. Running the CFLOGINUSER tag is the action that logs someone in, and there is no direct way to access the values created by CFLOGINUSER. However, you should be able to rerun CFLOGINUSER with the new values, if you know what they should be. This should seamlessly log the user in with the new set of credentials. I haven't tried to do this, however, so this is purely speculation on my part. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241265 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
cfloginuser
Hi guys, Is it possible to update the cfloginuser name="#variable#", while still logged in? Eg. I permit the user to update their username/password, but when they proceed to the forum (ray's forum) an error is generated because of a wrong username. Basically the username required for the forum is contained in the cflogin scope. Ultimately I do not wish to logout the user after they update their details. mike ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241264 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: cfinput flash form mask h:mm aa
With flash cfgrids, the mask stuff didn't work right if you didn't have the coldfusion 7.01 updater installed. I don't know if it affected cfinputs. ~Brad -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 3:38 PM To: CF-Talk Subject: Re: cfinput flash form mask h:mm aa cf 7 On 5/23/06, Brad Wood <[EMAIL PROTECTED]> wrote: > What version of CF are you running? > > I was thinking I remembered there being some buginess in the older > versions of flash form masks... but that may have only applied to > cfgrids in flash forms. > > ~Brad > > -Original Message- > From: Paul Ihrig [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 23, 2006 3:29 PM > To: CF-Talk > Subject: cfinput flash form mask h:mm aa > > i cant get my mask to work right > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241263 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: cfinput flash form mask h:mm aa
cf 7 On 5/23/06, Brad Wood <[EMAIL PROTECTED]> wrote: > What version of CF are you running? > > I was thinking I remembered there being some buginess in the older > versions of flash form masks... but that may have only applied to > cfgrids in flash forms. > > ~Brad > > -Original Message- > From: Paul Ihrig [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 23, 2006 3:29 PM > To: CF-Talk > Subject: cfinput flash form mask h:mm aa > > i cant get my mask to work right > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241262 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: cfinput flash form mask h:mm aa
What version of CF are you running? I was thinking I remembered there being some buginess in the older versions of flash form masks... but that may have only applied to cfgrids in flash forms. ~Brad -Original Message- From: Paul Ihrig [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 3:29 PM To: CF-Talk Subject: cfinput flash form mask h:mm aa i cant get my mask to work right ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241261 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: Access Connectivity Issue
Ian, One possibility is name resolution. The server is "nasserver-01". The question is, how does the web server "find" this server? Are you using AD or Wins or host, or DNS or what? A lengthy but predictable delay probably means that it is "trying" one method of finding the server (like checking wins) then trying the next method (probably broadcast) which is successful. Make sure resolution is the same on both servers. Then make sure that networking is the same as well - for example, sitching, duplexing and bandwidth levels. -mark Ok, I'll have to forward that to our network/operations folks, because I don't think I understood every tenth word in your message. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - "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. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241260 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
cfinput flash form mask h:mm aa
i cant get my mask to work right the value i pull in is say 5:00 PM but it flags it as an error, though i want it to be ok... i have tried mask="h:mm aa" mask="h:mm AA" mask="h:mm tt" with this if i delete the PM/AM in the results it clears it. but i want the user to add AM/PM my books & searches are not showing me the format i need. any help would be swell! thanks -paul ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241259 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: Upload txt file
Mime types are totally not standard. I would avoid using mime types for validation. Some could be correct, some could be octet streams. It's just not standardized. Instead, do not use a mime type during upload. Upload the file and then check the server extension of the uploaded file. Might not "seem" as secure as denying a mime type, but it fairly safe in my experience. Remember that the computer attempts to execute a file based on its extension. You can't change an EXE file to a JPG and still "launch" it. It will try to run as a JPG and break. ... Ben Nadel www.bennadel.com -Original Message- From: Tim Do [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 3:33 PM To: CF-Talk Subject: Upload txt file Hello All, I'm trying to do a simple upload of a text file but I'm getting: The MIME type of the uploaded file "message/rfc822" was not accepted by the server. Only files of type "*.txt" can be uploaded. Verify that you are uploading a file of the appropriate type. plz help :) here is what I have: thx! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241258 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: Upload txt file
how about accept=".txt" no * tw On 5/23/06, Tim Do <[EMAIL PROTECTED]> wrote: > I've tried both..same result > > accept = "text/plain,text/richtext" > > And I have > > enctype="multipart/form-data" > > -Original Message- > From: Andy Matthews [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 23, 2006 12:45 PM > To: CF-Talk > Subject: RE: Upload txt file > > Looks like you've got your "accept" attribute's value set incorrectly. > http://www.techfeed.net/cfQuickDocs/?cffileh > > Instead of "*.txt", it should be "text/plain". > > andy matthews > web developer > certified advanced coldfusion programmer ICGLink, Inc. > [EMAIL PROTECTED] > 615.370.1530 x737 > --//-> > > -Original Message- > From: Tim Do [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 23, 2006 2:33 PM > To: CF-Talk > Subject: Upload txt file > > > Hello All, > > I'm trying to do a simple upload of a text file but I'm getting: > > > The MIME type of the uploaded file "message/rfc822" was not accepted by > the server. > > > Only files of type "*.txt" can be uploaded. > Verify that you are uploading a file of the appropriate type. > > plz help :) > > here is what I have: > > fileField = "abaFile" >destination = "\\devone\insite\eft" >accept = "*.txt" >nameconflict="makeunique"> > > thx! > > > > > > > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241257 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: Upload txt file
Well, you could add the MIME type that the server is telling you that it sees: accept = "message/rfc822" Steve "The Boss" Brownlee http://www.orbwave.com/cfjboss -Original Message- From: Tim Do [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 4:02 PM To: CF-Talk Subject: RE: Upload txt file I've tried both..same result accept = "text/plain,text/richtext" And I have enctype="multipart/form-data" -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 12:45 PM To: CF-Talk Subject: RE: Upload txt file Looks like you've got your "accept" attribute's value set incorrectly. http://www.techfeed.net/cfQuickDocs/?cffileh Instead of "*.txt", it should be "text/plain". -Original Message- From: Tim Do [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 2:33 PM To: CF-Talk Subject: Upload txt file Hello All, I'm trying to do a simple upload of a text file but I'm getting: The MIME type of the uploaded file "message/rfc822" was not accepted by the server. Only files of type "*.txt" can be uploaded. Verify that you are uploading a file of the appropriate type. plz help :) here is what I have: thx! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241256 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: Access Connectivity Issue
Ian, One possibility is name resolution. The server is "nasserver-01". The question is, how does the web server "find" this server? Are you using AD or Wins or host, or DNS or what? A lengthy but predictable delay probably means that it is "trying" one method of finding the server (like checking wins) then trying the next method (probably broadcast) which is successful. Make sure resolution is the same on both servers. Then make sure that networking is the same as well - for example, sitching, duplexing and bandwidth levels. -mark -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 2:23 PM To: CF-Talk Subject: Access Connectivity Issue Can anybody point out avenues of investigation on why a simple query to an access database located on a network fileserver takes 1/10 of a second to run on one CF server and ~20 seconds to run on a second? Query: SELECT * FROM Equipment WHERE smfid = 102619 UNC Path in Access DSN definition: \\Nasserver-01\PC Applications\IS Inventory\dev\is inventory.mdb When I run this from my workstation machine it takes about 1/10 of a second. When I run it from the development box it takes about 20 seconds. I've tried to verify that every thing is the same between the two systems and I can not figure out why the difference times. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - "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. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241255 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: Upload txt file
I've tried both..same result accept = "text/plain,text/richtext" And I have enctype="multipart/form-data" -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 12:45 PM To: CF-Talk Subject: RE: Upload txt file Looks like you've got your "accept" attribute's value set incorrectly. http://www.techfeed.net/cfQuickDocs/?cffileh Instead of "*.txt", it should be "text/plain". -Original Message- From: Tim Do [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 2:33 PM To: CF-Talk Subject: Upload txt file Hello All, I'm trying to do a simple upload of a text file but I'm getting: The MIME type of the uploaded file "message/rfc822" was not accepted by the server. Only files of type "*.txt" can be uploaded. Verify that you are uploading a file of the appropriate type. plz help :) here is what I have: thx! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241254 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: Upload txt file
Looks like you've got your "accept" attribute's value set incorrectly. http://www.techfeed.net/cfQuickDocs/?cffileh Instead of "*.txt", it should be "text/plain". -Original Message- From: Tim Do [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 2:33 PM To: CF-Talk Subject: Upload txt file Hello All, I'm trying to do a simple upload of a text file but I'm getting: The MIME type of the uploaded file "message/rfc822" was not accepted by the server. Only files of type "*.txt" can be uploaded. Verify that you are uploading a file of the appropriate type. plz help :) here is what I have: thx! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241253 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: Upload txt file
Make sure you have: enctype="multipart/form-data" in your HTML form. M!ke -Original Message- From: Tim Do [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 2:33 PM To: CF-Talk Subject: Upload txt file Hello All, I'm trying to do a simple upload of a text file but I'm getting: The MIME type of the uploaded file "message/rfc822" was not accepted by the server. Only files of type "*.txt" can be uploaded. Verify that you are uploading a file of the appropriate type. plz help :) here is what I have: thx! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241252 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: Access Connectivity Issue
Try changing the DSN definition to use the IP address of the database machine instead of the UNC name. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241251 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
Upload txt file
Hello All, I'm trying to do a simple upload of a text file but I'm getting: The MIME type of the uploaded file "message/rfc822" was not accepted by the server. Only files of type "*.txt" can be uploaded. Verify that you are uploading a file of the appropriate type. plz help :) here is what I have: thx! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241250 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: Series of CFIF's as array: less code
Possibly. With my limited interpretation of what you're doing #ListGetAt(FriendlyFormFieldNames, fieldCount, ",")#"> Steve "The Boss" Brownlee http://www.orbwave.com/cfjboss -Original Message- From: Jeff Sabarese [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 2:30 PM To: CF-Talk Subject: Series of CFIF's as array: less code hello. from what i can figure, i think that this bit of code i've posted below, excluding the extended part about invalid email, could be entirely duplicated by looping through an array... right? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241249 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
cfdocument
I have used the cfdocument tag to produce a "print friendly" document. I am using an image link to call the document. The issue is the pdf is not only out of alignment, but the text an images are all over the place. What do I need to do to correct the output. The CF Code: #cfhttp.FileContent# Link Code: Print Page: http://localhost/esu/aboutesu/index.cfm?print"; class="printemail" align="absmiddle"> Steve LaBadie Raven Technology http://www.ravenpcs.com [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241248 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
Access Connectivity Issue
Can anybody point out avenues of investigation on why a simple query to an access database located on a network fileserver takes 1/10 of a second to run on one CF server and ~20 seconds to run on a second? Query: SELECT * FROM Equipment WHERE smfid = 102619 UNC Path in Access DSN definition: \\Nasserver-01\PC Applications\IS Inventory\dev\is inventory.mdb When I run this from my workstation machine it takes about 1/10 of a second. When I run it from the development box it takes about 20 seconds. I've tried to verify that every thing is the same between the two systems and I can not figure out why the difference times. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - "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. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241247 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: Series of CFIF's as array: less code
Possibly. With my limited interpretation of what you're doing #ListGetAt(FriendlyFormFieldNames, fieldCount, ",")#"> -Original Message- From: Jeff Sabarese [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 2:30 PM To: CF-Talk Subject: Series of CFIF's as array: less code hello. from what i can figure, i think that this bit of code i've posted below, excluding the extended part about invalid email, could be entirely duplicated by looping through an array... right? #VARIABLES.qone#"> #VARIABLES.qtwo#"> #VARIABLES.qthree#"> #VARIABLES.qfour#"> #VARIABLES.qfive#"> #VARIABLES.qsix#"> #VARIABLES.qseven#"> #VARIABLES.qeight#"> #VARIABLES.qnine#"> #VARIABLES.qten#"> #VARIABLES.qeleven#"> #VARIABLES.qtwelve#"> #VARIABLES.qthirteen#"> #VARIABLES.qfourteen#"> #VARIABLES.qfifteen#"> "> i realize that we probably can't easily duplicate it ExactlY like it is here, including my UL's and all... if this can be done w/ an array, what would be the proper syntax for this scenario? i'm mostly looking for tag-names, or function names specific to cold-fusion which i'm far from having them memorized. ;) thank you! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241246 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
Series of CFIF's as array: less code
hello. from what i can figure, i think that this bit of code i've posted below, excluding the extended part about invalid email, could be entirely duplicated by looping through an array... right? #VARIABLES.qone#"> #VARIABLES.qtwo#"> #VARIABLES.qthree#"> #VARIABLES.qfour#"> #VARIABLES.qfive#"> #VARIABLES.qsix#"> #VARIABLES.qseven#"> #VARIABLES.qeight#"> #VARIABLES.qnine#"> #VARIABLES.qten#"> #VARIABLES.qeleven#"> #VARIABLES.qtwelve#"> #VARIABLES.qthirteen#"> #VARIABLES.qfourteen#"> #VARIABLES.qfifteen#"> "> i realize that we probably can't easily duplicate it ExactlY like it is here, including my UL's and all... if this can be done w/ an array, what would be the proper syntax for this scenario? i'm mostly looking for tag-names, or function names specific to cold-fusion which i'm far from having them memorized. ;) thank you! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241245 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: Query Multiple Datasources...
> I was wondering if and how I could query multiple > datasources, essentially a simple join on two different > datasources? I have tables in Oracle and MySQL databases and > I want to query info from both for a return set. The easiest way to do this is to use CF's query-of-query functionality, which allows you to treat existing recordsets as if they were tables within a database: SELECT field1, field2 FROM table1 SELECT field3, field4 FROM table2 SELECT qOracle.field2, qMySQL.field3 FROM qOracle, qMySQL WHERE qOracle.field1 = qMySQL.field3 You may also be able to connect to one database from within the other, although this will depend on the specifics of your databases and your network configuration. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241244 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: Query Multiple Datasources...
Thanks, I was afraid that I was going to have to do a QofQ. I guess I'll start work on that solution. Thanks again, - Charles On May 23, 2006, at 10:47 AM, Ken Ferguson wrote: > But, Charles wants to query multiple DATASOURCES, not just multiple > databases. I think the best way for you to get this done Charles is > with > a QofQ, as Charlie G. suggested. You'll need to make each of your > queries and then use a query to join the recordsets. > > --Ferg > > Andy Matthews wrote: >> You can query multiple databases as long as you have permissions >> on both. In >> mySQL you prepend the table name with the database name like so: >> >> SELECT d1_t1.listing_id, d1_t1.listing_mlsnumber,d1_t1.listing_type, >> d2_t4.pLisPric >> FROM databasename_01.table_01 d1_t1 >> INNER JOIN databasename_02.table_04 d2_t4 >> ON d2_t4.pMlsNum = d1_t1.listing_mlsnumber >> >> > andy matthews >> web developer >> certified advanced coldfusion programmer >> ICGLink, Inc. >> [EMAIL PROTECTED] >> 615.370.1530 x737 >> --//-> >> >> -Original Message- >> From: Charles E. Heizer [mailto:[EMAIL PROTECTED] >> Sent: Tuesday, May 23, 2006 12:13 PM >> To: CF-Talk >> Subject: Query Multiple Datasources... >> >> >> Hello, >> I was wondering if and how I could query multiple datasources, >> essentially a simple join on two different datasources? I have tables >> in Oracle and MySQL databases and I want to query info from both for >> a return set. >> >> >> Thanks, >> - Charles >> >> >> >> >> >> > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241243 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: Query Multiple Datasources...
It is just a matter of setting up a dblink in Oracle or if it is just schemas in the same database then it can be as simple as just user permissions. I seem to recall reading once a way to select data out of another type of database from within MySQL but I might be remembering something completely wrong with that. On 5/23/06, Ian Skinner <[EMAIL PROTECTED]> wrote: > > > In Oracle, you can also create "link" tables to other databases. I'm not > sure how this is done, but I have used the results once our DBA's have set > it up. > > I would also imagine that your joining could be done in a query of a query > after the two tables where queried from. > > > > > -- > Ian Skinner > Web Programmer > BloodSource > www.BloodSource.org > Sacramento, CA > > - > | 1 | | > - Binary Soduko > | | | > - > > "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. > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241242 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: Query Multiple Datasources...
But, Charles wants to query multiple DATASOURCES, not just multiple databases. I think the best way for you to get this done Charles is with a QofQ, as Charlie G. suggested. You'll need to make each of your queries and then use a query to join the recordsets. --Ferg Andy Matthews wrote: > You can query multiple databases as long as you have permissions on both. In > mySQL you prepend the table name with the database name like so: > > SELECT d1_t1.listing_id, d1_t1.listing_mlsnumber,d1_t1.listing_type, > d2_t4.pLisPric > FROM databasename_01.table_01 d1_t1 > INNER JOIN databasename_02.table_04 d2_t4 > ON d2_t4.pMlsNum = d1_t1.listing_mlsnumber > > andy matthews > web developer > certified advanced coldfusion programmer > ICGLink, Inc. > [EMAIL PROTECTED] > 615.370.1530 x737 > --//-> > > -Original Message- > From: Charles E. Heizer [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 23, 2006 12:13 PM > To: CF-Talk > Subject: Query Multiple Datasources... > > > Hello, > I was wondering if and how I could query multiple datasources, > essentially a simple join on two different datasources? I have tables > in Oracle and MySQL databases and I want to query info from both for > a return set. > > > Thanks, > - Charles > > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241241 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: Query Multiple Datasources...
You can query multiple databases as long as you have permissions on both. In mySQL you prepend the table name with the database name like so: SELECT d1_t1.listing_id, d1_t1.listing_mlsnumber,d1_t1.listing_type, d2_t4.pLisPric FROM databasename_01.table_01 d1_t1 INNER JOIN databasename_02.table_04 d2_t4 ON d2_t4.pMlsNum = d1_t1.listing_mlsnumber In Oracle, you can also create "link" tables to other databases. I'm not sure how this is done, but I have used the results once our DBA's have set it up. I would also imagine that your joining could be done in a query of a query after the two tables where queried from. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA - | 1 | | - Binary Soduko | | | - "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. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241240 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: Application.cfc racing
ill try tonight, and let you know. the code is on a template at home... ill eff with it tonight, and hit ya'up if it still is making me crazy :) tw On 5/23/06, Raymond Camden <[EMAIL PROTECTED]> wrote: > Can you show us the code? Also, why not use onRequestStart? onRequest > has "side effects" that can come back to haunt you. If you are just > setting request vars, I'd recommend onRequestStart. > > On 5/23/06, Tony <[EMAIL PROTECTED]> wrote: > > ray, et al. > > > > im having a STRANGE Application.cfc issue. > > > > im setting a request var in the onRequest() method > > and the value isnt available a page on the first load after > > restarting the cfmx server. 2nd, 3rd, 4th load of page > > works fine. > > > > but the first one out of the gate, isnt working. > > > > any ideas? > > > > tw > > > > On 5/23/06, Raymond Camden <[EMAIL PROTECTED]> wrote: > > > About 99% of the code I've seen out there just set a bunch of > > > Application constansts and components, so this is fine. Don't forget > > > it, of course, but most folks won't be impacted by it. I typically add > > > this to onRequestStart: > > > > > > > > > > > > > > > > > > On 5/23/06, Brian Kotek <[EMAIL PROTECTED]> wrote: > > > > Yep, exactly. However, note that CF only single-threads > > > > onApplicationStart() > > > > automatically when IT runs it. If YOU manually re-run > > > > onApplicationStart(), > > > > you must lock that method call if you want to prevent race conditions. > > > > > > > > On 5/23/06, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > > > > > > > > > > Snake said: > > > > > > As OnApplicationstart only executes once at the start of an > > > > > > application this does means you couldn't use it to reset your > > > > > > application variables, which is a pain IMHO. > > > > > > > > > > Just call OnApplicationstart from somewhere else in application.cfc. > > > > > > > > > > Jochem > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241239 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: Query Multiple Datasources...
You can query multiple databases as long as you have permissions on both. In mySQL you prepend the table name with the database name like so: SELECT d1_t1.listing_id, d1_t1.listing_mlsnumber,d1_t1.listing_type, d2_t4.pLisPric FROM databasename_01.table_01 d1_t1 INNER JOIN databasename_02.table_04 d2_t4 ON d2_t4.pMlsNum = d1_t1.listing_mlsnumber -Original Message- From: Charles E. Heizer [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 12:13 PM To: CF-Talk Subject: Query Multiple Datasources... Hello, I was wondering if and how I could query multiple datasources, essentially a simple join on two different datasources? I have tables in Oracle and MySQL databases and I want to query info from both for a return set. Thanks, - Charles ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241238 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: I think I've discovered a bug in CFMX
Jon Block wrote: > > SYMPTOM > - > Web browser seems to lose connection with the web server when making CFM > requests that take a long time (over 10 seconds) to process. > > FIREFOX SIDE EFFECT > > When the apparent connection with the web server breaks, Firefox prompts > me to download my "index.cfm" file. > > INTERNET EXPLORER SIDE EFFECT > -- > When the apparent connection with the web server breaks, Internet > Explorer makes a second request passing all of the same data a second > time. > - I did an HTTP trace with "HttpLook" and I'm able to verify IE is > making a second POST at the server action page 15-20 seconds after I've > pushed the submit button. I'm talking about forms that have no special > javascript submit functionality. Can you make a trace with a packetsniffer like Ethereal? Jochem ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241237 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: Query Multiple Datasources...
probably not the sort of solution you're looking for, but i think you're going to have to use a Query of Queries to accomplish that. On 5/23/06, Charles E. Heizer <[EMAIL PROTECTED]> wrote: > Hello, > I was wondering if and how I could query multiple datasources, > essentially a simple join on two different datasources? I have tables > in Oracle and MySQL databases and I want to query info from both for > a return set. > > > Thanks, > - Charles > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241236 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
Query Multiple Datasources...
Hello, I was wondering if and how I could query multiple datasources, essentially a simple join on two different datasources? I have tables in Oracle and MySQL databases and I want to query info from both for a return set. Thanks, - Charles ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241235 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.cfc racing
Can you show us the code? Also, why not use onRequestStart? onRequest has "side effects" that can come back to haunt you. If you are just setting request vars, I'd recommend onRequestStart. On 5/23/06, Tony <[EMAIL PROTECTED]> wrote: > ray, et al. > > im having a STRANGE Application.cfc issue. > > im setting a request var in the onRequest() method > and the value isnt available a page on the first load after > restarting the cfmx server. 2nd, 3rd, 4th load of page > works fine. > > but the first one out of the gate, isnt working. > > any ideas? > > tw > > On 5/23/06, Raymond Camden <[EMAIL PROTECTED]> wrote: > > About 99% of the code I've seen out there just set a bunch of > > Application constansts and components, so this is fine. Don't forget > > it, of course, but most folks won't be impacted by it. I typically add > > this to onRequestStart: > > > > > > > > > > > > On 5/23/06, Brian Kotek <[EMAIL PROTECTED]> wrote: > > > Yep, exactly. However, note that CF only single-threads > > > onApplicationStart() > > > automatically when IT runs it. If YOU manually re-run > > > onApplicationStart(), > > > you must lock that method call if you want to prevent race conditions. > > > > > > On 5/23/06, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > > > > > > > > Snake said: > > > > > As OnApplicationstart only executes once at the start of an > > > > > application this does means you couldn't use it to reset your > > > > > application variables, which is a pain IMHO. > > > > > > > > Just call OnApplicationstart from somewhere else in application.cfc. > > > > > > > > Jochem > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241234 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: CFMX Java server recommendation
Ok cool, sounds good. Alrhough I was trying to boost my CV with knowledge of a well known server, here in Belgium, it is Weblogic/Jboss.. but I guess going with what is there is the best bet. Although I now have another question. Looking at the server install there is no JRun service running or installed in services, I think it might have been installed to use IIS. Is there a way I can change this configuration to run with JRun without having to re-install? I am definitely on Enterprise as checked in the CF admin. Cheers for the replys any how, thanks. cheers Martin >Mart, > >You can execute your Java/JSP right where you are now. I wouldn't really >bother mucking about with anything else for what you need right now. > >N > >On 5/23/06, Douglas Knudsen <[EMAIL PROTECTED]> wrote: >> ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241233 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.cfc racing
ray, et al. im having a STRANGE Application.cfc issue. im setting a request var in the onRequest() method and the value isnt available a page on the first load after restarting the cfmx server. 2nd, 3rd, 4th load of page works fine. but the first one out of the gate, isnt working. any ideas? tw On 5/23/06, Raymond Camden <[EMAIL PROTECTED]> wrote: > About 99% of the code I've seen out there just set a bunch of > Application constansts and components, so this is fine. Don't forget > it, of course, but most folks won't be impacted by it. I typically add > this to onRequestStart: > > > > > > On 5/23/06, Brian Kotek <[EMAIL PROTECTED]> wrote: > > Yep, exactly. However, note that CF only single-threads onApplicationStart() > > automatically when IT runs it. If YOU manually re-run onApplicationStart(), > > you must lock that method call if you want to prevent race conditions. > > > > On 5/23/06, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > > > > > > Snake said: > > > > As OnApplicationstart only executes once at the start of an > > > > application this does means you couldn't use it to reset your > > > > application variables, which is a pain IMHO. > > > > > > Just call OnApplicationstart from somewhere else in application.cfc. > > > > > > Jochem > > > > > > > > > > > > > > > > > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241232 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: cfqueryparam BIND list limit
Dave, thanks for the clarification. Cutter Dave Watts wrote: >>I realize that the list is a list of integers, but, being a >>list, wouldn't the datatype be something akin to a string? >>How is that handled within cfqueryparam? > > > The CFQUERYPARAM tag tells the database that it's a series of integers, and > that's all that matters. Each integer value is replaced within the SQL > statement using a placeholder, and the database is told that the placeholder > corresponds to an integer value. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241231 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: CFMX Java server recommendation
Right. While Tomcat should run CFMX Enterprise (i've not tested it), it's not a J2EE server, it's a servlet container, which is one of the key components to J2EE, but if you're planning on deploying other J2EE apps, you'll want a real J2EE server. As pretty much everyone has said on this thread already, use JRun. It's a great server. Getting a bit outdated (betas for the next version are in testing), but still really good. It comes with your purchase of CFMX Enterprise, and is under the hood and mostly unaccessable with CFMX standard. -nathan strutz http://www.dopefly.com/ On 5/23/06, Douglas Knudsen <[EMAIL PROTECTED]> wrote: > > ugh, you have JRun already available and paid for. Sure, you could > use JBoss, not Tomact. > > DK > > On 5/23/06, Martin Thorpe <[EMAIL PROTECTED]> wrote: > > Hello. > > > > > > > > Our company has CFMX 71 Enterprise and I want to move it to sit on a > > Java server so that we can take advantages of multiple instances and at > > the same time allow for development of J2EE applications. > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241230 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: cfqueryparam BIND list limit
> I realize that the list is a list of integers, but, being a > list, wouldn't the datatype be something akin to a string? > How is that handled within cfqueryparam? The CFQUERYPARAM tag tells the database that it's a series of integers, and that's all that matters. Each integer value is replaced within the SQL statement using a placeholder, and the database is told that the placeholder corresponds to an integer value. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241229 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: Reinit Re: Application.cfc racing
> Ray, Have you given any thought of moving the reinit out of > the application.cfc and into an admin section or the like? > I'm never happy about allowing 'just anybody' who visits my > site the ability to reinitialize it. I don't think you can move the reinitialization itself out of Application.cfc. However, there's no reason why you can't require the existence of a session variable that is set during a login, or require that the reinitialization code in onRequestStart only run from specific pages that presumably require a logon, etc. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241228 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: Reinit Re: Application.cfc racing
See both Tony and Tom's response. In the past, where I have cared, I'd done Tom's thing of just using a unique value. Like, reinit=letmedoitorelse. On 5/23/06, Michael Dinowitz <[EMAIL PROTECTED]> wrote: > Ray, Have you given any thought of moving the reinit out of the > application.cfc and into an admin section or the like? I'm never happy about > allowing 'just anybody' who visits my site the ability to reinitialize it. > > > About 99% of the code I've seen out there just set a bunch of > > Application constansts and components, so this is fine. Don't forget > > it, of course, but most folks won't be impacted by it. I typically add > > this to onRequestStart: > > > > > > > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241227 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: Reinit Re: Application.cfc racing
i usually limit the reinit to the small list of dedicated ip's that i have available to me (office, home, parents house, in-laws house, etc) then no matter where i am, i can do it. tw On 5/23/06, Tom Chiverton <[EMAIL PROTECTED]> wrote: > On Tuesday 23 May 2006 16:05, Michael Dinowitz wrote: > > about allowing 'just anybody' who visits my site the ability to > > reinitialize it. > > > > > > > > > > > I tend to use > url.reinit="somereallylongstringthatshardtoguessevenifyouareR2D2"> > to prevent exactly that. > -- > Tom Chiverton > > > > This email is sent for and on behalf of Halliwells LLP. > > Halliwells LLP is a limited liability partnership registered in England and > Wales under registered number OC307980 whose registered office address is at > St James's Court Brown Street Manchester M2 2JF. A list of members is > available for inspection at the registered office. Any reference to a partner > in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by > the Law Society. > > CONFIDENTIALITY > > This email is intended only for the use of the addressee named above and may > be confidential or legally privileged. If you are not the addressee you must > not read it and must not use any information contained in nor copy it nor > inform any person other than Halliwells LLP or the addressee of its existence > or contents. If you have received this email in error please delete it and > notify Halliwells LLP IT Department on 0870 365 8008. > > For more information about Halliwells LLP visit www.halliwells.com. > > We are pleased to announce that Halliwells LLP has been voted AIM Lawyer of > the Year at the 2005 Growth Company Awards > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241226 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: Reinit Re: Application.cfc racing
On Tuesday 23 May 2006 16:05, Michael Dinowitz wrote: > about allowing 'just anybody' who visits my site the ability to > reinitialize it. > > > > > > I tend to use to prevent exactly that. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. We are pleased to announce that Halliwells LLP has been voted AIM Lawyer of the Year at the 2005 Growth Company Awards ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241225 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
Reinit Re: Application.cfc racing
Ray, Have you given any thought of moving the reinit out of the application.cfc and into an admin section or the like? I'm never happy about allowing 'just anybody' who visits my site the ability to reinitialize it. > About 99% of the code I've seen out there just set a bunch of > Application constansts and components, so this is fine. Don't forget > it, of course, but most folks won't be impacted by it. I typically add > this to onRequestStart: > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241224 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: Application.cfc racing
About 99% of the code I've seen out there just set a bunch of Application constansts and components, so this is fine. Don't forget it, of course, but most folks won't be impacted by it. I typically add this to onRequestStart: On 5/23/06, Brian Kotek <[EMAIL PROTECTED]> wrote: > Yep, exactly. However, note that CF only single-threads onApplicationStart() > automatically when IT runs it. If YOU manually re-run onApplicationStart(), > you must lock that method call if you want to prevent race conditions. > > On 5/23/06, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > > > > Snake said: > > > As OnApplicationstart only executes once at the start of an > > > application this does means you couldn't use it to reset your > > > application variables, which is a pain IMHO. > > > > Just call OnApplicationstart from somewhere else in application.cfc. > > > > Jochem > > > > > > > > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241222 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: CFMX Java server recommendation
Mart, You can execute your Java/JSP right where you are now. I wouldn't really bother mucking about with anything else for what you need right now. N On 5/23/06, Douglas Knudsen <[EMAIL PROTECTED]> wrote: > > ugh, you have JRun already available and paid for. Sure, you could > use JBoss, not Tomact. > > DK > > On 5/23/06, Martin Thorpe <[EMAIL PROTECTED]> wrote: > > Hello. > > > > > > > > Our company has CFMX 71 Enterprise and I want to move it to sit on a > > Java server so that we can take advantages of multiple instances and at > > the same time allow for development of J2EE applications. > > > > > > > > I am looking for an open source (read free) server what I have looked at > > is Jboss and Tomcat. We are running Windows environment 2000 at the > > moment though I think it will all be upgraded to 2003 in the near > > future. > > > > > > > > My question is what are your recommendations and experiences of Jboss > > and Tomcat (or any other) for use with CFMX and as serving J2EE apps. > > Would there be any problems with running J2EE apps and CFMX at the same > > time? > > > > > > > > Any suggestions/info would be appreciated. > > > > > > > > Thanks for reading. > > > > > > > > Cheers > > > > Martin > > > > > > > > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241223 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: best design for a store nav which will change regularly
Gilbert, You can always use a manual caching system. If your application controls all aspects of the site (both user interface and administration) then you programmatically know when the cache needs to be modified. How you implement really depends on the size of data you're dealing with and the servers you're running. I've known people in the past that will basically cache the entire product database as a query in memory and then use Query-of-Queries (QoQ) to retrieve records straight from the memory cache. You can store the cached query as an application variable and maintain the data pretty easily. You can also manually create a structure in your application scope that stores all product/designer information. Just manage this cached data the same time when writes to the database occur. That way the information in the database and the cache stay in sync. -Dan ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241221 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
jrun-iis6-wildcard.dll really is required?
Hi, I'm trying to understand the functional difference between the two extensions that are mapped from IIS to CFMX7 (on Windows 2003 Server). By default, these two are mapped (in this order): \runtime\lib\wsconfig\1\jrun_iis6_wildcard.dll \runtime\lib\wsconfig\jrun_iis6.dll My understanding from reading previous posts here is that the "jrun_iis6.dll" extension is used for standard .cfm page execution, and the wildcard extension is used by flash remoting, RDS, and anything else that may invoke CFMX without a .cfm page extensions. Given this understanding, it sounds like I should be able to remove the wildcard dll if all I want is standard .cfm pages to execute in a browser. However, that is not my experience. If I remove the wildcard mapping, then load a .cfm page in a browser, the page will "load", but no data is returned--the page is blank, as is the source. So, that would suggest one of two things: 1) the wildcard extension *is* required for standard page execution; 2) something on our environment is not configured properly. Does anybody know which of those two possibilities is the right one? Thanks, Ben Mueller ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241220 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: CFMX Java server recommendation
ugh, you have JRun already available and paid for. Sure, you could use JBoss, not Tomact. DK On 5/23/06, Martin Thorpe <[EMAIL PROTECTED]> wrote: > Hello. > > > > Our company has CFMX 71 Enterprise and I want to move it to sit on a > Java server so that we can take advantages of multiple instances and at > the same time allow for development of J2EE applications. > > > > I am looking for an open source (read free) server what I have looked at > is Jboss and Tomcat. We are running Windows environment 2000 at the > moment though I think it will all be upgraded to 2003 in the near > future. > > > > My question is what are your recommendations and experiences of Jboss > and Tomcat (or any other) for use with CFMX and as serving J2EE apps. > Would there be any problems with running J2EE apps and CFMX at the same > time? > > > > Any suggestions/info would be appreciated. > > > > Thanks for reading. > > > > Cheers > > Martin > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241219 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: CFMX Java server recommendation
Why not use Jrun? You paid for it when you bought CFMX7 Enterprise. -Original Message- From: Martin Thorpe [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 9:59 AM To: CF-Talk Subject: CFMX Java server recommendation Hello. Our company has CFMX 71 Enterprise and I want to move it to sit on a Java server so that we can take advantages of multiple instances and at the same time allow for development of J2EE applications. I am looking for an open source (read free) server what I have looked at is Jboss and Tomcat. We are running Windows environment 2000 at the moment though I think it will all be upgraded to 2003 in the near future. My question is what are your recommendations and experiences of Jboss and Tomcat (or any other) for use with CFMX and as serving J2EE apps. Would there be any problems with running J2EE apps and CFMX at the same time? Any suggestions/info would be appreciated. Thanks for reading. Cheers Martin ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241218 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: cfqueryparam BIND list limit
I realize that the list is a list of integers, but, being a list, wouldn't the datatype be something akin to a string? How is that handled within cfqueryparam? Cutter Jochem van Dieten wrote: > Billy Jamme said: > >>The problem occurs when I attempt to use cfqueryparam to fetch a >>2100+ item list of records. >> >> >> SELECT id >> FROM tempTable >> WHERE id IN (>cfsqltype="cf_sql_integer">) >> > > >>To further troubleshoot I installed the jTBS 1.2 drivers and I ran >>all 3 queries again. The result this time around was: >> >>Query 1: "Prepared or callable statement has more than 2000 >>parameter markers." > > >>Now the question. Is there a way to get around this limit? > > > The limit it probably somewhere in a .properties file where you can up > it and recompile the driver. > > Jochem > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241217 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: Stubborn code in CF
Sounds like this bug: http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_18361 but I thought that was only a 6.1 issue??? --Ferg Ken wrote: > Hi. I have some really persistent and stubborn code in CF that just won't > budge. > > I am using CFSchedule action="delete" to delete a certain scheduled > task. But it keeps running even after being deleted. I checked > scheduler.log file, and it was still running. Click on Scheduled Tasks > List (in CF Administrator), and the task is not showing. But it is > still running. > > Then I manually created the same task name in CF Admin, and deleted it > manually, and that's how it stopped. > > Anybody faced a similar issue? Is this a known bug in CF MX 7.0.1? Any > way to fix it? Please help. > > Thanks, > Ken > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241216 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: Application.cfc racing
Like I said, logical but just doesn't 'feel' right. :) >It does make sense - if the cookies aren't set in the browser, you get >a new session with new cookies. > >It occurs to me the same is true regardless of which method you are >using - Application.cfc or a CFAPPLICATION tag. Is that right Jochem? > >On 5/23/06, Michael Dinowitz <[EMAIL PROTECTED]> wrote: >> ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241215 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
Stubborn code in CF
Hi. I have some really persistent and stubborn code in CF that just won't budge. I am using CFSchedule action="delete" to delete a certain scheduled task. But it keeps running even after being deleted. I checked scheduler.log file, and it was still running. Click on Scheduled Tasks List (in CF Administrator), and the task is not showing. But it is still running. Then I manually created the same task name in CF Admin, and deleted it manually, and that's how it stopped. Anybody faced a similar issue? Is this a known bug in CF MX 7.0.1? Any way to fix it? Please help. Thanks, Ken ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241214 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
CFMX Java server recommendation
Hello. Our company has CFMX 71 Enterprise and I want to move it to sit on a Java server so that we can take advantages of multiple instances and at the same time allow for development of J2EE applications. I am looking for an open source (read free) server what I have looked at is Jboss and Tomcat. We are running Windows environment 2000 at the moment though I think it will all be upgraded to 2003 in the near future. My question is what are your recommendations and experiences of Jboss and Tomcat (or any other) for use with CFMX and as serving J2EE apps. Would there be any problems with running J2EE apps and CFMX at the same time? Any suggestions/info would be appreciated. Thanks for reading. Cheers Martin ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241213 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: Application.cfc racing
Yep, exactly. However, note that CF only single-threads onApplicationStart() automatically when IT runs it. If YOU manually re-run onApplicationStart(), you must lock that method call if you want to prevent race conditions. On 5/23/06, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > > Snake said: > > As OnApplicationstart only executes once at the start of an > > application this does means you couldn't use it to reset your > > application variables, which is a pain IMHO. > > Just call OnApplicationstart from somewhere else in application.cfc. > > Jochem > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241212 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
best design for a store nav which will change regularly
I'm building a store which constantly adds and removes designers as product availability dictates. My navigation page contains two dB calls - one for designers and one for product categories. (If there are no items in a particular product category then the category does not appear.) I'm trying to determine best way to reduce excess dB calls and have the best usability. Can't use a CFCACHE based on time as there is no way to predict when the store runs out of an item or adds a new designer. The two directions I thought of was 1. set the time frame to something huge (100 days) and every time the dB is updated run queries to see if there are any new designers, categories or if the number of items listed for a designer equals zero. If there are any changes flush the cache and update the table with number of designers and categories. There may be usability issues here. Example: a designer that is usually represented is not displayed for a while - customers may fear that the store is no longer carrying that designer. It may be better to display a "no items" notice. 2. Assuming the client chooses to display "no items" it may be better to bring in human judgment into decision making. Let the customer and his staff flag which designers are "active" and then click a "publish" button which will use CFFILE action="write" to create a static nav page. I'm leaning towards the second choice. Realistically it can be assumed that there would be 5-10 changes per month, which is not too much for an actively involved staff (3 people) to cover. As much as I hate the idea of "Sorry we're temporarily out" it may be better than confusing the customer by removing designer X from the list. Gilbert Midonnet ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241211 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: cfdocument
My main content is controlled by CSS ..bodytext { color: #333; font-size: 11px; font-family: Verdana, Helvetica, Arial, san-serif; line-height: 16px; font-weight: normal; padding-left: 11px; padding-right: 5px; text-align:justify; } Steve LaBadie Raven Technology http://www.ravenpcs.com [EMAIL PROTECTED] - Original Message - From: "Andy Matthews" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Tuesday, May 23, 2006 9:32 AM Subject: RE: cfdocument > Is there anything outside of that code that might be affecting the print? > Such as margins or padding on your body tag? Or a parent container > element? > > andy matthews > web developer > certified advanced coldfusion programmer > ICGLink, Inc. > [EMAIL PROTECTED] > 615.370.1530 x737 > --//-> > > -Original Message- > From: Raven Technology [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 23, 2006 8:29 AM > To: CF-Talk > Subject: cfdocument > > > I have use the cfdocument tag to produce a "print friendly" document. I > am > using an image link to call the document. The issue is the pdf is out of > alignment. What do I need to do to correct the output. > > The CF Code: > > > > format="pdf">#cfhttp.FileContent# > > > Link Code: > > Print Page: > http://localhost/esu/aboutesu/index.cfm?print"; class="printemail" > align="absmiddle"> border="0" hspace="0" align="absmiddle" alt="Print Page" /> src="images/clearpixel.gif" height="30" border="0" /> > > Steve LaBadie > Raven Technology > http://www.ravenpcs.com > [EMAIL PROTECTED] > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241210 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: cfdocument
Is there anything outside of that code that might be affecting the print? Such as margins or padding on your body tag? Or a parent container element? -Original Message- From: Raven Technology [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 23, 2006 8:29 AM To: CF-Talk Subject: cfdocument I have use the cfdocument tag to produce a "print friendly" document. I am using an image link to call the document. The issue is the pdf is out of alignment. What do I need to do to correct the output. The CF Code: #cfhttp.FileContent# Link Code: Print Page: http://localhost/esu/aboutesu/index.cfm?print"; class="printemail" align="absmiddle"> Steve LaBadie Raven Technology http://www.ravenpcs.com [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241209 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
cfdocument
I have use the cfdocument tag to produce a "print friendly" document. I am using an image link to call the document. The issue is the pdf is out of alignment. What do I need to do to correct the output. The CF Code: #cfhttp.FileContent# Link Code: Print Page: http://localhost/esu/aboutesu/index.cfm?print"; class="printemail" align="absmiddle"> Steve LaBadie Raven Technology http://www.ravenpcs.com [EMAIL PROTECTED] ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241208 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: I think I've discovered a bug in CFMX
On Monday 22 May 2006 19:40, Jon Block wrote: > When the apparent connection with the web server breaks, Firefox prompts > me to download my "index.cfm" file. What's in it ? > Apache 1.3.33 Can you try a more recent apache and/or mod_rewrite rather than the MacroMedia connectors ? -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at St James's Court Brown Street Manchester M2 2JF. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by the Law Society. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 8008. For more information about Halliwells LLP visit www.halliwells.com. We are pleased to announce that Halliwells LLP has been voted AIM Lawyer of the Year at the 2005 Growth Company Awards ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241207 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: Google Analytics?
hmm, it's almost as if you are looking over my shoulder, blogging about what I'm doing incorrectly! Thanks a lot. Mike -Original Message- From: Nick Tong - TalkWebSolutions.co.uk [mailto:[EMAIL PROTECTED] Sent: Monday, May 22, 2006 8:37 AM To: CF-Talk Subject: Re: Google Analytics? Hi Mike - check this post out: http://succor.co.uk/index.cfm/2006/2/13/Google-analytics---urchin On 22/05/06, Mike Klostermeyer <[EMAIL PROTECTED]> wrote: > Since it appears many here use Google Analytics, I have a question. Does > anyone use it over an SSL connection (during the checkout process of a cart, > for example)? I can't figure out how to use it without throwing browser > security warnings (domain name does not match, etc.). Any way around this? > > Mike > > -Original Message- > From: Jeff Small [mailto:[EMAIL PROTECTED] > Sent: Sunday, May 21, 2006 12:29 PM > To: CF-Talk > Subject: Google Analytics? > > > What is this? I got an invitation, but I'm not sure what it is. > > > > Is it more than just google's version of "web trends"? Anyone using it? > > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241206 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: Google Analytics?
Thanks Nick! Al -Original Message- From: Nick Tong - TalkWebSolutions.co.uk [mailto:[EMAIL PROTECTED] Sent: Monday, May 22, 2006 4:36 PM To: CF-Talk Subject: Re: Google Analytics? Mike, Did you check out my post? Aldon, . it can be slower but be sure to put the script at the end of you page - just before the tag. HTH On 22/05/06, Aldon <[EMAIL PROTECTED]> wrote: > I have found Google Analytics to increase load time making my pages slower. > Has anyone found a solution to this? > > Al > > > -Original Message- > From: Paul [mailto:[EMAIL PROTECTED] > Sent: Monday, May 22, 2006 12:10 PM > To: CF-Talk > Subject: RE: Google Analytics? > > This must no longer be true; I just set up Analytics last month on our SSL > site and after searching their online help for "SSL" and following the > instructions, all is working well. > > -Original Message- > From: Dave Watts [mailto:[EMAIL PROTECTED] > Sent: Monday, May 22, 2006 7:37 AM > To: CF-Talk > Subject: RE: Google Analytics? > > > Since it appears many here use Google Analytics, I have a > > question. Does anyone use it over an SSL connection (during > > the checkout process of a cart, for example)? I can't figure > > out how to use it without throwing browser security warnings > > (domain name does not match, etc.). Any way around this? > > Unfortunately, the SSL portion of Google Analytics is slightly broken. They > have SSL set up so that you can fetch their files, but their certificate > doesn't match the URL used to fetch the files. > > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241205 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: Application.cfc racing
This is why I never use frames. On 5/23/06, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > James Holmes said: > > It does make sense - if the cookies aren't set in the browser, you > > get a new session with new cookies. > > > > It occurs to me the same is true regardless of which method you are > > using - Application.cfc or a CFAPPLICATION tag. Is that right > > Jochem? > > Yes. > > Jochem -- CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241204 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.cfc racing
James Holmes said: > It does make sense - if the cookies aren't set in the browser, you > get a new session with new cookies. > > It occurs to me the same is true regardless of which method you are > using - Application.cfc or a CFAPPLICATION tag. Is that right > Jochem? Yes. Jochem ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241203 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: Application.cfc racing
Snake said: > As OnApplicationstart only executes once at the start of an > application this does means you couldn't use it to reset your > application variables, which is a pain IMHO. Just call OnApplicationstart from somewhere else in application.cfc. Jochem ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241202 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: Application.cfc racing
It does make sense - if the cookies aren't set in the browser, you get a new session with new cookies. It occurs to me the same is true regardless of which method you are using - Application.cfc or a CFAPPLICATION tag. Is that right Jochem? On 5/23/06, Michael Dinowitz <[EMAIL PROTECTED]> wrote: > I'll have to test that as it sounds logical but doesn't 'feel' right. Your > probably totally correct, but > > > Sessions and applications are entirely different beasts here. For both > > the starting point is the part of the manual James referred to. But > > for sessions there is an additional consideration. If the user-agent > > has not made any previous requests for resources on the server, it > > does not have a cookie or URL variable yet. So if the user-agent is > > directed to load 2 resources from the server simultaneously, those 2 > > request will actually be in different sessions. So within a session > > all single-threading is taken care off, but that does not stop a > > user-agent from simultaneously opening multiple sessions. > > > > Jochem > > > > > > > > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241201 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: Application.cfc racing
As OnApplicationstart only executes once at the start of an application this does means you couldn't use it to reset your application variables, which is a pain IMHO. russ -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: 23 May 2006 08:25 To: CF-Talk Subject: Re: Application.cfc racing Always a good idea to test the docs, especially when you have an article on it in the upcoming print edition of the Fusion Authority Quarterly Update. > From the LiveDocs > (http://livedocs.macromedia.com/coldfusion/7/htmldocs/0696.htm) > > Use this method for application initialization code; for example, use > it to set Application scope variables, to determine whether a required > data source or other resource is available, or to log the application > start. You do not have to lock the Application scope if you set > Application variables in this method, and you can reference > Application scope variables as you normally do; for example, as > Application.myVariable. > > Same goes for the session according to the docs. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241200 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: Google Analytics?
Hi Mike - check this post out: http://succor.co.uk/index.cfm/2006/2/13/Google-analytics---urchin On 22/05/06, Mike Klostermeyer <[EMAIL PROTECTED]> wrote: > Since it appears many here use Google Analytics, I have a question. Does > anyone use it over an SSL connection (during the checkout process of a cart, > for example)? I can't figure out how to use it without throwing browser > security warnings (domain name does not match, etc.). Any way around this? > > Mike > > -Original Message- > From: Jeff Small [mailto:[EMAIL PROTECTED] > Sent: Sunday, May 21, 2006 12:29 PM > To: CF-Talk > Subject: Google Analytics? > > > What is this? I got an invitation, but I'm not sure what it is. > > > > Is it more than just google's version of "web trends"? Anyone using it? > > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241199 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: Application.cfc racing
I'll have to test that as it sounds logical but doesn't 'feel' right. Your probably totally correct, but > Sessions and applications are entirely different beasts here. For both > the starting point is the part of the manual James referred to. But > for sessions there is an additional consideration. If the user-agent > has not made any previous requests for resources on the server, it > does not have a cookie or URL variable yet. So if the user-agent is > directed to load 2 resources from the server simultaneously, those 2 > request will actually be in different sessions. So within a session > all single-threading is taken care off, but that does not stop a > user-agent from simultaneously opening multiple sessions. > > Jochem > > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241198 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.cfc racing
Always a good idea to test the docs, especially when you have an article on it in the upcoming print edition of the Fusion Authority Quarterly Update. > From the LiveDocs > (http://livedocs.macromedia.com/coldfusion/7/htmldocs/0696.htm) > > Use this method for application initialization code; for example, use > it to set Application scope variables, to determine whether a required > data source or other resource is available, or to log the application > start. You do not have to lock the Application scope if you set > Application variables in this method, and you can reference > Application scope variables as you normally do; for example, as > Application.myVariable. > > Same goes for the session according to the docs. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241197 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: Application.cfc racing
And the answer is that the onApplicationStart method singlethreads the application until it's done. My test was to have 2 different directories with application.cfc of the same name in them. The first had a wait function set to a minute. The second had nothing. I ran the first and then the second. The second hung until the first was done and then processed. This says single threading of the onApplicationStart and onSessionStart. > I'm about to do some tests on application.cfc as it deals with the > onApplicationStart and onSessionStart. The question is, if the > application/session does not exist, does the method 'lock' and single > thread the request to it or can multiple requests cause the start methods > to run if they happen at the same time. In an application.cfm this is > handled by doing a check to see if an application variable exists, if not > lock the application and then check again. > If no one has solid data on this then I'll be testing it out and posting > the results here and on Blog of Fusion. > > Michael Dinowitz > Host: House of Fusion >http://www.houseoffusion.com > Publisher: Fusion Authority >http://www.fusionauthority.com > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241196 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: Application.cfc racing
Michael Dinowitz said: > I'm about to do some tests on application.cfc as it deals with the > onApplicationStart and onSessionStart. The question is, if the > application/session does not exist, does the method 'lock' and > single thread the request to it or can multiple requests cause the > start methods to run if they happen at the same time. In an > application.cfm this is handled by doing a check to see if an > application variable exists, if not lock the application and then > check again. Sessions and applications are entirely different beasts here. For both the starting point is the part of the manual James referred to. But for sessions there is an additional consideration. If the user-agent has not made any previous requests for resources on the server, it does not have a cookie or URL variable yet. So if the user-agent is directed to load 2 resources from the server simultaneously, those 2 request will actually be in different sessions. So within a session all single-threading is taken care off, but that does not stop a user-agent from simultaneously opening multiple sessions. Jochem ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241195 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: cfqueryparam BIND list limit
Billy Jamme said: > > The problem occurs when I attempt to use cfqueryparam to fetch a > 2100+ item list of records. > > > SELECT id > FROM tempTable > WHERE id IN ( cfsqltype="cf_sql_integer">) > > To further troubleshoot I installed the jTBS 1.2 drivers and I ran > all 3 queries again. The result this time around was: > > Query 1: "Prepared or callable statement has more than 2000 > parameter markers." > Now the question. Is there a way to get around this limit? The limit it probably somewhere in a .properties file where you can up it and recompile the driver. Jochem ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241194 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