Hey, question about Dreamweaver, Fireworks, checking out files, etc...
Is there a way that anyone knows of, for you to somehow "link" your site with fireworks? If I keep a PNG file in a library folder in my site, I check the source PNG file in, so that if anyone needs to change the PNG file, they have to check it out, just like pages within the site, etc. But that only works if you're checking out the file from within Dreamweaver. If, say, you open the PNG by simply launching Fireworks and opening the PNG file, you've "bypassed" the check in/check out process Dreamweaver uses, and what's worse, when you go to save the file, you're told you can't, because the file's locked. Typical solution is to make your changes to the PNG file, export the working graphic, then close the PNG without saving your file, pretty much making the whole reason for checking it out pointless... So what I was wondering was, is anyone using Fireworks/Dreamweaver in their workflow and have a way to "check out" a file in Fireworks before working on it? I really dig the application linking between the two, but if you mess up and go outside of the dreamweaver workflow, it basically stops working...or is that just the way it's designed? ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188265 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
Today's CF vs The World thread...
...great stuff. I know some people tire of it quickly, and that's all cool and all, but I for one enjoyed the heck out of it. It's a great way for intelligent programmers who are actually using the product and writing books on the subject to discuss, yell, debate, and post examples, statistics, and compelling arguments for both sides. Obviously some baiting on both sides, and some "nyah nyah nyah" replies as well, but hey, wheat...chaff...and all that...I'm glad I'm one of those fortunate ones born with a "bullshit detector" and a keen sense of pragmatism that somehow merges to form a pretty good filter that enables me to read or not read, reply or not reply to everything that passes in front of me...color me gifted I guess...lol... But seriously, there are naturally some people that get rubbed the wrong way in these exchanges, and sure, you'll tire of it quickly, but I just thought I'd pipe up and at least add my voice, to the minority of people apparently, who thought it was a pretty awesome way to kill a few minutes of precious life over the last couple of days...so not everyone hates the trolling...lol... Lots of asbestos keyboards out there...good thing...Keep up the good work fellow geeks, there's hope for the world yet... ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187477 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: select next/previous *record*?
>I have an application where the user selects a record via a key > lookup, and then that record is displayed individually. From there I > want to be able to click a '<' button to go to the previous record in > the sequence, or a '>' to go to the next record, and continue to > select records via this method as an alternative to the key lookup. > > I did this in an entirely different environment where I was able to > use native controls that allowed straight up SELECT NEXT and SELECT > PREVIOUS commands, where I was also able to throw those commands into > a loop for fast forward and rewind as well. Don't expect to get that > in the web world, but I need the next/previous. > > I think I can come up with something, but the convolutions necessary > to make it work are making my head hurt. Is there something simple > and obvious I have missed on this (for me) Sunday morning?. Quick question...are ya using DreamweaverMX? ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187284 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: News extension WAS (Re: Blackstone Beta)
>> I don't really want to be notified about all the news from Macromedia >> bloggers, > > Well, seeing as that is all the extension does, I can see why you > un-installed it. Yeah, I can see that too...I do more than CF (Flash and Dreamweaver) so the extension is butter for me. I love it. I sometimes forget that people here are a little more CF-centric and not so much Macromedia-centric. My bad, Mike. > Yeah. I was explicitly trying not to make it a general purpose > aggregator. One thing I am considering is releasing a version that is > just for ColdFusion, and one just for Flash (in addition to the > Macromedia one). Haha, I'd probably still just use the Macromedia one...That John Dowdell is one prolific blogger...lol... ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187204 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: Blackstone Beta
Okay, this is a PERFECT time to jump in here and pimp this thing... http://www.markme.com/macromedianews/ Dude, if you're using Firefox, you HAVE to load this extension. It's frickin unbelievable. It's single-handedly the coolest extension I've ever used. It blinks when there's updated content, it loads in a tab in the background, and it's just the most ubiquitous little way to keep up with the macromedia blog universe. I'm hooked like crack...er...not that I've ever tried crack...er...the drug, I mean...anyway, try that extension. It rules. > Get yourself an RSS feed reader and get the feed from www.fullasagoog.com. > > Good collection of MACR-centric blogs there. MACR's MXNA aggregator > should be out in RSS format (according to Mike Chambers) soon, so this > would be a good one to add, too. > > I've had my ass saved a number of times from reading blogs. I've also > gotten a ton of good tips, hints and tricks that I've filed mentally and > come back to when I needed them. > > At least cruise http://www.markme.com/mxna/index.cfm?category=ColdFusion > once a day, man! ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187120 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
Compuserve and session variables...
Has anyone run into problems with session variable retention or odd site issues regarding CompuServe? Are they running a Caching type server there?? We are having an issue where some session variables are getting messed up when someone is using dialup through CompuServe. Anyone with any experiences? Jeff ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187100 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 Errors
Pounds go around variables, not dates. #12/1/2004# is asking coldfusion to resolve a variable named variables, and 12/1/2004 and that is an illegal variable name. To use a standard, regional, date use single quotes. I'm going to declare your date variable elsewhere just to make it readable: WHERE tblItemPurchase.itemPurchaseDate >= '#queryPurchaseDate#' OR WHERE tblItemPurchase.itemPurchaseDate >= #createODBCDate(queryPurchaseDate)# Good luck -Jeff Jason Smith wrote: >While I have been rebuilding a cold fusion application that was using a >access database and was running dog slow now I have converted all the >databases over to SQL. Now since I'm not 100% sure on what the actual query >calls are if someone can direct me to a site that might list the difference >between access / SQL query calls I can get this working correctly. > >Since converting the databases over and not making any code changes this is >the first of what I assume will be many errors If anyone can point me in >the right direction I would greatly appreciate it. > > >Error Executing Database Query. > >[Macromedia][SQLServer JDBC Driver][SQLServer]Line 3: Incorrect syntax near >'#'. > >The error occurred in C:\Inetpub\voremarketing\admin\adminMain.cfm: line 344 > >342 : SELECT >Sum(tblItemPurchase.itemPurchasePrice) AS totalMonthlyPurchase >343 : FROM tblItemPurchase >344 : WHERE >tblItemPurchase.itemPurchaseDate >= ###theMonth#/1/#theYear### >345 : >346 : > >SQLSELECT Sum(tblItemPurchase.itemPurchasePrice) AS >totalMonthlyPurchase FROM tblItemPurchase WHERE >tblItemPurchase.itemPurchaseDate >= #12/1/2004# >DATASOURCE vodb_remarketing >VENDORERRORCODE 170 >SQLSTATE HY000 > > > ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186913 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: In line Spell Checkers
google for CFX_JSpellCheck -Jeff [EMAIL PROTECTED] wrote: >I have an application where I need to spell check the contents of a text >box any cheap (or free) widgets out there? > >sas > >Scott A. Stewart, >Web Application Developer > >Engineering Consulting Services, Ltd. (ECS) >14026 Thunderbolt Place, Suite 100 >Chantilly, VA 20151 >Phone: (703) 471-8400 >Fax: (703) 834-5527 > > > > > > ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186896 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
OT: Interactive Dynamic Query Report Writer.
Has anyone seen anything like this??? Not for coding purposes and not for any type of modification of the table or results. Just for simple display type queries (Select statements). Basically a user would be allowed to pick a table, then they can interactively set "where" and "sort by" parts based on the columns available in each table. It would then "run" the query and display the results. I don't want to reinvent the wheel if one already exists. Thanks! Jeff ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186692 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: Fixed Width variable question.
That did the trick... Thanks! Jeff > -Original Message- > From: Marlon Moyer [mailto:[EMAIL PROTECTED] > Sent: Monday, December 06, 2004 2:26 PM > To: CF-Talk > Subject: RE: Fixed Width variable question. > > > RJustify(string, length) > > > > -Original Message- > > From: Jeff Waris [mailto:[EMAIL PROTECTED] > > Sent: Monday, December 06, 2004 1:06 PM > > To: CF-Talk > > Subject: RE: Fixed Width variable question. > > > > Maybe I didn't explain this good enough... LOL Its Monday > > > > I know that I can format a number with numberformat... I'd like to > > apply this to text variables as well... > > > > Lets say I am interested in doing this... > > > > 123 > > 1234 > > 12345 > > 123456 > > > > Setting them so they would be > > 123 > > 1234 > > 12345 > >123456 > > > > Or maybe a better example > > Cat > > Apple > > Orange > > > > (Instead of 0's, using spaces...) > > > > > > Basically I am trying to output fields in a query to a text > file in a > fixed > > width fasion, Field 1 allow only 5 chars, field 2 allow only 11 > > chars, etc... That way each field would have a certain column start > > and finsh in the text file... > > > > Hope I was more clear this time.. :) > > > > Jeff > > > > > > > > > > > -Original Message- > > > From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED] > > > Sent: Monday, December 06, 2004 1:54 PM > > > To: CF-Talk > > > Subject: RE: Fixed Width variable question. > > > > > > > > > I think #numberFormat(num,"0")# should do the trick. -dbk > > > > > > -Original Message- > > > From: Jeff Waris [mailto:[EMAIL PROTECTED] > > > Sent: Monday, December 06, 2004 1:50 PM > > > To: CF-Talk > > > Subject: Fixed Width variable question. > > > > > > Does anyone have a good technique they use to make a > "fixed width" > > > variable to insert into a text file? > > > > > > For example I have an order number, it can be 3,4,5 or 6 > characters > > > long > > > > > > Lets say: > > > 123 > > > 1234 > > > 12345 > > > 123456 > > > > > > ...and I need to format them at 9 characters long by > inserting 0's > > > in the > > > beginning: > > > 00123 > > > 01234 > > > 12345 > > > 000123456 > > > > > > > > > Thanks, > > > Jeff > > > > > > > > > > > > > > > > > > > > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186340 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: Fixed Width variable question.
Maybe I didn't explain this good enough... LOL Its Monday I know that I can format a number with numberformat... I'd like to apply this to text variables as well... Lets say I am interested in doing this... 123 1234 12345 123456 Setting them so they would be 123 1234 12345 123456 Or maybe a better example Cat Apple Orange (Instead of 0's, using spaces...) Basically I am trying to output fields in a query to a text file in a fixed width fasion, Field 1 allow only 5 chars, field 2 allow only 11 chars, etc... That way each field would have a certain column start and finsh in the text file... Hope I was more clear this time.. :) Jeff > -Original Message- > From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED] > Sent: Monday, December 06, 2004 1:54 PM > To: CF-Talk > Subject: RE: Fixed Width variable question. > > > I think #numberFormat(num,"0")# should do the trick. -dbk > > -Original Message- > From: Jeff Waris [mailto:[EMAIL PROTECTED] > Sent: Monday, December 06, 2004 1:50 PM > To: CF-Talk > Subject: Fixed Width variable question. > > Does anyone have a good technique they use to make a "fixed > width" variable to insert into a text file? > > For example I have an order number, it can be 3,4,5 or 6 > characters long > > Lets say: > 123 > 1234 > 12345 > 123456 > > ...and I need to format them at 9 characters long by > inserting 0's in the > beginning: > 00123 > 01234 > 12345 > 000123456 > > > Thanks, > Jeff > > > > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186335 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
Fixed Width variable question.
Does anyone have a good technique they use to make a "fixed width" variable to insert into a text file? For example I have an order number, it can be 3,4,5 or 6 characters long Lets say: 123 1234 12345 123456 ...and I need to format them at 9 characters long by inserting 0's in the beginning: 00123 01234 12345 000123456 Thanks, Jeff ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186332 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: Installing CFMX on Mac OS X (root user?)
> Looks like you deployed your WAR to the wrong directory. > > The directory tree should be: > > /Applications >/JRun4 >/servers >/default >/SERVER-INF >/cfusion <-- expand cfusion.war into here >/META-INF >/WEB-INF >/cfdocs >/CFIDE >/administrator >... >/CFIDE <-- expand rds.war into here >/META-INF >/WEB-INF >rds.properties > > You'll probably be better off deleting the whole JRun install and > starting over now since you've got a bunch of directories to clean > up... That's exactly what I'm going to do tonight. I'm keeping this most excellent directory structure above and taping it beside my monitor while I'm working. I think I'm getting the hang of it. I got a couple of O'Reilly Unix/MaxOSx books on the way home, and I'm pouring over them this weekend. While it kinda sucks to do, and seems really tedious, the cool part about it is that it's fairly addictive because you're learning cool stuff...or so it seems. I'm really getting into it, from a "this is a cool learning experience" standpoint. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186197 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: Preserve Leading 0's question in cfoutput.
The numbers are not fixed length. > -Original Message- > From: Martin Parry [mailto:[EMAIL PROTECTED] > Sent: Friday, December 03, 2004 5:09 PM > To: CF-Talk > Subject: RE: Preserve Leading 0's question in cfoutput. > > > You could always use #numberformat(qdfResult.numberfield, "000")# > > Martin Parry > http://www.beetrootstreet.co.uk > > -Original Message- > From: Jeff Waris [mailto:[EMAIL PROTECTED] > Sent: 03 December 2004 21:50 > To: CF-Talk > Subject: Preserve Leading 0's question in cfoutput. > > Here's an interesting one... > > I have a text field in a database that contains numbers > because of a need to PRESERVE leading 0's i.e. 0001234 0123 12300 > > Using a regular query, pulling the numbers OUT of the > database DROPS the leading 0's in the cfoutput. Almost like > cold fusion is treating it as a number not a text field. Is > there any way to preserve those leading 0's inside a CFoutput?? > > Thanks.. > > Jeff > > > > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186188 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: Preserve Leading 0's question in cfoutput.
I tried varchar, nvarchar and char in MS SQL. The DB all shows the 0's. The cfoutput removes the 0's. I even tried the SET like below as well. Still trims the 0's... I'm pulling my hair out... Jeff > -Original Message- > From: Barney Boisvert [mailto:[EMAIL PROTECTED] > Sent: Friday, December 03, 2004 5:10 PM > To: CF-Talk > Subject: Re: Preserve Leading 0's question in cfoutput. > > > maybe. Did you try this: > > > > > On Fri, 3 Dec 2004 16:58:42 -0500, Jeff Waris > <[EMAIL PROTECTED]> wrote: > > Would a cfset giving the variable a more friendly name be > considered > > arithmatic and trim the 0's? > > > > i.e. > > > > > > Jeff > > > -- > Barney Boisvert > [EMAIL PROTECTED] > 360.319.6145 > http://www.barneyb.com/blog/ > > ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186186 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: Preserve Leading 0's question in cfoutput.
Would a cfset giving the variable a more friendly name be considered arithmatic and trim the 0's? i.e. Jeff > -Original Message- > From: Barney Boisvert [mailto:[EMAIL PROTECTED] > Sent: Friday, December 03, 2004 4:54 PM > To: CF-Talk > Subject: Re: Preserve Leading 0's question in cfoutput. > > > You running them through a QofQ, by chance? Or doing any > arithmetic with them? Because CF shouldn't strip the zeros > unless it's converting them to numbers, and it shouldn't do > that unless it actually needs to. > > cheers, > barneyb > > On Fri, 3 Dec 2004 16:49:36 -0500, Jeff Waris > <[EMAIL PROTECTED]> wrote: > > Here's an interesting one... > > > > I have a text field in a database that contains numbers > because of a > > need to PRESERVE leading 0's i.e. > > 0001234 > > 0123 > > 12300 > > > > Using a regular query, pulling the numbers OUT of the > database DROPS > > the leading 0's in the cfoutput. Almost like cold fusion is > treating > > it as a number not a text field. Is there any way to preserve those > > leading 0's inside a CFoutput?? > > > > Thanks.. > > > > Jeff > > -- > Barney Boisvert > [EMAIL PROTECTED] > 360.319.6145 > http://www.barneyb.com/blog/ > > ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186182 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
Preserve Leading 0's question in cfoutput.
Here's an interesting one... I have a text field in a database that contains numbers because of a need to PRESERVE leading 0's i.e. 0001234 0123 12300 Using a regular query, pulling the numbers OUT of the database DROPS the leading 0's in the cfoutput. Almost like cold fusion is treating it as a number not a text field. Is there any way to preserve those leading 0's inside a CFoutput?? Thanks.. Jeff ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186180 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: Installing CFMX on Mac OS X (root user?)
On Dec 2, 2004, at 7:01 PM, Sean Corfield wrote: > On Thu, 2 Dec 2004 14:58:41 -0800, Sean Corfield > <[EMAIL PROTECTED]> wrote: >> It's easy enough to create a Mac application using Apple Script that >> will start CFMX for you and then you could add that to your Startup >> Items if you wanted... > > See my blog - I just posted some example scripts and instructions. Hey Sean, any idea why I'm getting this in my terminal window when I try to start up my default server? I was able to successfully follow each step. everything installed in the right places (it worked as soon as I used the leading '/') but when I went to the next step to verify the coldfusion install and started my default server, I got the following message and my administration page wouldn't load... 12/02 21:16:36 warning Deployer Service failed to deploy file:/Applications/JRun4/servers/default/cfusion/ * Unrecognized deployment: file:/Applications/JRun4/servers/default/cfusion/ 12/02 21:16:36 info Deploying enterprise application "default-ear" from: file:/Applications/JRun4/servers/default/default-ear/ 12/02 21:16:36 info Deploying web application "JRun Default Web Application" from: file:/Applications/JRun4/servers/default/default-ear/ 12/02 21:16:38 info Web Services in default-ear#default-war: 12/02 21:16:38 info AdminService 12/02 21:16:38 user JSPServlet: init 12/02 21:16:38 warning Deployer Service failed to deploy file:/Applications/JRun4/servers/default/META-INF/ * Unrecognized deployment: file:/Applications/JRun4/servers/default/META-INF/ 12/02 21:16:38 warning Deployer Service failed to deploy file:/Applications/JRun4/servers/default/WEB-INF/ * Unrecognized deployment: file:/Applications/JRun4/servers/default/WEB-INF/ That's just a snippet...the unsuccessful portion. Everything else (the server instance) started fine... ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186048 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: Installing CFMX on Mac OS X (root user?)
On Dec 2, 2004, at 6:40 PM, Dave Watts wrote: > All you have to do is start the JRun server instance within which > you've > installed CFMX. CFMX isn't run as a separate process. Awesome. Thanks Dave and Sean. I'm going thru that CFMX install process right now and re-reading that install page on Macromedia with a fine toothed comb. I'm hoping I can get it all installed tonight while I'm playing around here at home. ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186040 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: Installing CFMX on Mac OS X (root user?)
On Dec 2, 2004, at 5:58 PM, Sean Corfield wrote: > By default you would have to manually start it, yes. > > It's easy enough to create a Mac application using Apple Script that > will start CFMX for you and then you could add that to your Startup > Items if you wanted... Links? Examples? I *totally* want to learn how to at least start my default server under jrun. If I install CFMX under my default server under jrun, will it start that instance of CFMX as well? Or are those two manual operations? Start jrun, THEN start cfmx? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186025 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: Hosting for Coldfusion
> From what people on here say about CrystalTech, at least recently, they > don't seem to be all that great. Although, that argument may be more > against SQL server and some other services they offer, but regardless, > I've seen a lot of complaints on here lately about crystaltech. > > John Well, I'll ad my voice to the "pro" Crystal Tech side. We host about 20 sites with them, ranging from tiny little www's to full blown hospital sites with HR backends and online bill payments, and we haven't had a *single* problem in almost two years. We moved from another widely regarded CF host because of endless problems, and since switching over to crystal tech, not a single mishap. My two cents. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186013 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: Installing CFMX on Mac OS X (root user?)
> Just remember that to start at the root you have to have a / at the > beginning of your path, otherwise it'll start drilling down from your > current directory. So if your war file is in /Powerbook/Applications > (remember Unix is case-sensitive as well, so /PowerBook/Applications and > /Powerbook/Applications are NOT the same thing ...), then you would just > have to point to that directory with your jar command. *sigh* I haven't had time to try it since I'm at work, but I've got my powerbook with me, and I honest-to-god think that was the only problem I had. I was telling the jar command to look in "Powerbook/Applications/" while I was in the cfusion directory and not "/Powerbook/Applications/" so I'm almost 100% certain that was the problem ...and no, I didn't remember that to start at the room you have to have a / at the beginning... ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185957 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: Installing CFMX on Mac OS X (root user?)
> If you can't successfully run the jar command chances are you're probably > not in the right directory, and if you aren't giving it path information > to the file the jar command probably just can't find the file you're > trying to unjar. Okay, so if I'm in, say, "Applications/Jrun4/servers/default/CFIDE" and the war file is in "Powerbook/Applications" (remember, I expanded the war files to this directory that the jar file created because I typed the path in wrong) I need to give the path in the jar command that points to the rds.war file in that "applications" folder? > I think since it sounds like you may have stuff in the wrong place, etc. > you might just want to delete the files you've expanded and start over, > following the directions very, very carefully. They really do work. I'll > post again if I get a chance to do some annotated WAR instructions because > this really is a much simpler procedure than the EAR deployment. I can do that? I can just delete the folders that the jar file created and just start over? How do I correctly tell the jar file where to install the war files? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185917 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: Installing CFMX on Mac OS X (root user?)
On Dec 1, 2004, at 10:02 PM, Sean Corfield wrote: > First off, don't use the double-click approach - you really need to > use the command-line install. Boy was I hoping I'd see you jump in here...I think this all boils down to me not really understanding how the whole .jar/unix/command line/paths thing actually works on a mac. I think I need to read something about this first before even trying to go any further. Any recommendations? I think it's not so much that I don't understand the command line unix portion, upon further reflection. It seems to be more of "I just don't really understand how jrun and the whole java install process works." Does that make sense? I'm reading as carefully as I can, but I'm really stuck right on number 8. I've done 1-7 perfectly (well, maybe not perfectly, I wanted to install cfmx...okay, lemme take that back...I double clicked the jar file and wanted to install it to my applications folder, which I *thought* was "Powerbook/Applications" but when I double clicked "Powerbook" I saw that it had actually created a folder on my root called "Powerbook" and installed the war files into an "applications" folder it had created there. So rather than going into "Applications" it's now in "Powerbook/Applications"...make sense? That was my first screwup.) and as a result, I don't know exactly what I'm supposed to do once I navigate to my "Applications/Jrun4/servers/default/CFIDE" directory in the terminal. So that was where I just didn't know what to do... I'm here: -- If you haven't done so already, open a Terminal window (Applications/Utilities/Terminal), navigate to the cfusion directory, and use the jar utility to uncompress the cfusion.war file: cd jrun_root/jrun4/servers/servername/cfusion jar -xvf cfmx_install_directory/cfusion.war Note: In these instructions, replace jrun_root with the directory in which you installed JRun 4; for example, /Applications/jrun4. Replace servername with the name of the server to which you are deploying ColdFusion MX; for example, if you installed ColdFusion MX in the default JRun server, specify default. -- and I can't successfully run the 'jar -xvf' command. > No, you don't 'run' these files. The cfusion.war and rds.war files > need to be manually deployed to a new server instance creating on > JRun I created the directories (cfusion and CFIDE) under the default directory in my "servers" directory under jrun, which is in my applications folder. Did I screw that up? > Read the install notes carefully - they look daunting and complex but > as long as you follow every step carefully, it should all just work: > > http://www.macromedia.com/support/coldfusion/j2ee/ > cfmxj2ee_mac_onjrunandtom.html > > Note that it absolutely requires you become familiar with the > command-line interface of the Unix subsystem that underlies Mac OS X. That's what page I'm reading, but it seems like it leaves out a step or two right at that 8th step...*sigh*. Do I just delete the "Powerbook/Applications" folder the jar file created on my root and just try again? How do I tell it to install into a CFMXJ2EE directory in my applications folder? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185902 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: Installing CFMX on Mac OS X (root user?)
Well, this is what I'm reading: http://www.macromedia.com/support/coldfusion/j2ee/cfmx-mac- onjrunandtomcat.html I'm on step 8, which is: --- If you haven't done so already, open a Terminal window (Applications/Utilities/Terminal), navigate to the cfusion directory, and use the jar utility to uncompress the cfusion.war file: cd jrun_root/jrun4/servers/server_name/cfusion jar -xvf cfmx_install_directory/cfusion.war Note: In these instructions, replace jrun_root with the directory in which you installed JRun 4; for example, /Applications/jrun4. Replace server_name with the name of the server to which you are deploying ColdFusion MX; for example, if you installed ColdFusion MX in the default JRun server, specify default. --- ...and it all fell apart there. I navigated to the right places, installed under the default server, and did *everything exactly* like the instructions said. I'm just at a total loss... ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185897 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: Installing CFMX on Mac OS X (root user?)
On Dec 1, 2004, at 7:14 PM, Matt Woodward wrote: >> I've got Jrun up and running, and I've got the CFMX jar file, and I >> can >> double click the jar file fine, it starts up the installer perfectly, >> but I step thru three steps or so, and it says I can't install it >> because I'm not root user. > > As long as you're an admin user you can just ignore that error and > continue the installation. I'm not sure why that error occurs but > I've installed CF numerous times on various Macs and if you ignore > that and continue the install works without a hitch. > > Matt Well, I gave it a try. What a disaster. I can't run the rds.war file. It's not installing, it's throwing errors like mad. This is such crap. This is the FIRST thing besides jrun4 that I've even installed on this computer and I've already screwed it completely up. java.io.FileNotFoundException: rds.war (No such file or directory) at java.io.FileInputStream.open(Native Method) at java.io.FileInputStream.(FileInputStream.java:106) at java.io.FileInputStream.(FileInputStream.java:66) at sun.tools.jar.Main.run(Main.java:185) at sun.tools.jar.Main.main(Main.java:904) ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185895 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
Installing CFMX on Mac OS X (root user?)
I've got Jrun up and running, and I've got the CFMX jar file, and I can double click the jar file fine, it starts up the installer perfectly, but I step thru three steps or so, and it says I can't install it because I'm not root user. Now, I'm an admin on this machine (my new powerbook) but I'm not a root user, and so far, everything I've read (The Mac OS X Missing Manual, mainly) have warned me about promoting myself to root user, and it makes sense. As a newbie unix "user" on the Powerbook I don't wanna destroy stuff in the process of fiddling around. So I guess my question is...how do I get it installed? Is it cool to go into netinfo manager and just temporarily promote myself to root, run the install, then just "de-promote" myself the same way? Or can I run the command line install using sudo and install it? I'll admit up front, that using sudo in the command line kinda makes me nervous because I wanna install it under "Powerbook/Applications/CMFX" where my Jrun is installed and I'm not sure exactly how to do that from the command line. Any advice? ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185887 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: CF MX developer edition with no network connection.
Yeah, that one threw me too...2k server on a laptop? That's pretty awesome. >I have to say I'm running XP, not server. > > -Original Message- > From: Jacob [mailto:[EMAIL PROTECTED] > Windows 2003 server under IIS 6.0. Running it as a service. ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185876 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: CF MX developer edition with no network connection.
>I am running CF MX developer edition on my laptop. The problem I have is > that when I try to start CF without a network connection, CF will not > start. > > Not a problem at home, but when I am on a plane, or a hotel, hard to do > some work... ;-) > > Any way I can get CF MX to run without a network connection? Well, all I can add is, "that sure is weird". I'm running it on my laptop, along with blackstone, and both work fine. You're on a PC? Or a Mac? Are you running CF as a service under XP Pro or something? Or do you have it installed under j2ee? Shoot us a little more info, let's see if we can't get you up and running. Should be easy. ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185852 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: SOT: Outsourcing
We've outsourced oversees and domestically. I think everyone involved in my company agreed that the oversees work was a disaster. The code that came back sometimes worked, sometimes didn't. Managing the project was a huge time sink. And the time difference it made everything an order of magnitude more difficult. Domestically has been only slightly better. I think there were a few problems - on both sides. We have an incredibly complex business model. Therefore, anything we do ends up very complex. I think the person managing the project could have done a better job at identifying and communicating our needs. And, I don't think the consultants did a very good job of asking questions. The end result, is something that works, but the code is written with poor coding standards, is poorly documented (no commenting), and is so brittle that indications are that it will take twice as much work to implement customizations. My best suggestion if you are going to outsource is to require that you get example code from whomever is actually going to be coding the project. Then have one of your developers pick it apart to get an idea of whether it meets your standards. --Jeff On 11/18/2004 8:55 AM, Ryan Emerle wrote: > Has anyone had any success outsourcing large projects, or portions of > large projects, overseas or to temporary/freelance employees? Any > pros/cons to either? Any resources you can offer to someone exploring > his options? > > Basically, we're looking to supplement our current resources while the > company grows. Unfortunately our timeline does not allow much > flexibility to train new full/part time employees. > > Any help would be appreciated. Personal experiences would be extremely > helpful. > > Thanks! > -- > Ryan Emerle > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184745 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
Mapping?
Okay, so in my root, I want to set up the navigation include so the path is and on lower pages, the path can be identical. Then, IN the navigation I'd like to be able to use and have it work on pages both in the root and a single directory down. I feel like I'm sniffing around for mappings, but I've never actually done it. I have a localhost that I'm testing here on my machine (F12) and when I'm done and check it in, I'd like the paths to work over on our development server as well. So do I need to create two sets of mappings? In each of my CFAdmins (the one locally and the one on dev)? So the mapping to http://localhost/foo is to C:\Inetpub\wwwroot\foo, right? Am I heading in the roght direction? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184656 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: Oddball Query question...
Thanks Ben... Quick and dirty did the trick Jeff > -Original Message- > From: Ben Forta [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 16, 2004 4:23 PM > To: CF-Talk > Subject: RE: Oddball Query question... > > > Quick and dirty could be: > > SELECT zip > FROM table1 > WHERE NOT zip IN (SELECT zip FROM table2) > > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184485 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
Oddball Query question...
Odd query question MY brain is lagging at 4:00pm... I need some help Table one has a list of zip codes. Table two has a list of zip codes. I want to compare table one to table two. The results would list ONLY the zip codes that appear in table one that do not appear in table two. Any help is greatly appreciated... Thanks, Jeff ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184471 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: Yellow fields
Do you have the Google toolbar installed? Or have you enabled the automagic form fill-in for IE? These are two typical culprits. Jeff Garza [EMAIL PROTECTED] Certified Macromedia ColdFusion Developer -Original Message- From: Gabriel Robichaud [mailto:[EMAIL PROTECTED] Sent: Monday, November 15, 2004 9:18 PM To: CF-Talk Subject: Yellow fields Hello yall! Can anyone explain why certain input text fields appear with a yellow background in Internet Explorer even if i have an alternate color defined in my stylesheet? Is there anyway to overide this yellow? TIA! Gabriel ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184353 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: A Quick cry for help, figured you guys have probably seen this...
> This should help I think. > > http://www.winnetmag.com/SQLServer/Article/ArticleID/42854/SQLServer_42854.html > > Stephen Boy howdythanks ever so much. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184316 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
A Quick cry for help, figured you guys have probably seen this...
We have a development database running on a little windowsXP Pro machine that's hummed along quite nicely. Then today, we ran SP2 because we did a monthly reboot and it reminded us. We didn't change any settings and when it came back up we just cut off the Windows Firewall, the Virus checker, etc thinking, "well, we'll just cut it all off". We really didn't fear it because this little machine does *one* thing...run SQL server in-house for testing and development. Now the server running CF is throwing errors and all the SQL server datasources that are normally pointing at the IG-SQL (Interactive Group SQL...clever, eh?) and working are all being refused with the following error: Connection verification failed for data source: TestSQL []java.sql.SQLException: SQLException while attempting to connect: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect The root cause was that: java.sql.SQLException: SQLException while attempting to connect: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket. Connection refused: connect This is when we simply go in and submit the datasource with all the correct info...'cause nothing's changed...well...*technically*... For what it's worth, I can look at "IG-SQL" on my machine with my Enterprise Manager and all is well. I can see my instance of it, it expands, I see all the tables, etc...so I know the machine's up and working just dandy. I can use Enterprise Manager locally on the Machine...and on my machine and see the server hunky dorey... Anyway, I just thought one of you guys might have seen it, and could go, "oh yeah, this happened to us and we #solution#". Thank ye ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184313 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: Re: Blackstone to provide built-in
> as far as I know, you can discuss anything you saw at MAX if you didn't > have to > sign an NDA to see it. That said: > > 1. you might want to ask Macromedia for clarification > > 2. either way you should exercise good judgement and common sense before > discussing anything that you feel may be under NDA > > ~Simon That's what I figured. Talk generally, not in specifics. Gotcha. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183967 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: Blackstone to provide built-in "Flash Remoting" type capabilities?
> Am I understanding MM's description of Blackstone correctly, > especially the new, "Rich Forms"? > > Will Blackstone provide built-in "Flash-Remoting" type capability > without having to actually use Flash / Flash Remoting / ActionScript? > > I'm still still using CF 4.5.2, because I haven't found any compelling > features I require to update to current versions...however, inherent > "Flash-Remoting" type capability for connectivity to a database would > be worth some money... > > Rick Are we allowed to discuss what we saw at Max? I mean, we could answer this question, but I'm not sure how much we're allowed to say. I mean, I guess the short answer is, "no, not *exactly*". But can we mention stuff that's been discussed in *public* but hasn't been elaborated on anywhere else? How much of the General Session from Day One has NDA attached to it? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183952 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: output listing problem
Heh, except the ON in the subquery should be a WHERE, as pointed out by DRE SELECT A.item, A.date, (select MIN(date) FROM yourTable B WHERE b.itemID = A.itemID) AS orderDate FROM yourTable A ORDER BY orderDate, A.item, A.date -Jeff DRE wrote: >Thanks to Jeff, the issue is resolved. For the curious, here is the solution. > >SELECT A.item, A.date, (select MIN(date) FROM yourTable B ON b.itemID >= A.itemID) AS orderDate > FROM yourTable A > ORDER BY orderDate, A.item, A.date > >DRE > >On Mon, 8 Nov 2004 10:45:39 -0800, DRE <[EMAIL PROTECTED]> wrote: > > >>Hi Jeff, >>I see what you're trying to get at it but it seems not to work for me. >>The query works but its not grouping properly in the output >>statement. Heres why I think that is. >> >>In the group by, you have to have all of the non aggregate fields >>which include date. Now date is the one that I need outside the >>group. That is, each item can have multiple dates. So, if date is in >>the group, then it will create groups of every item/date combination. >>Then the order by operates on the order date which is the same as >>date. So, effectively, there is no group. >> >>Does this make sense? What have I missed? >> >>Thanks in advance. >>DRE >> >> >> >>On Thu, 04 Nov 2004 13:07:43 -0800, Jeff Congdon <[EMAIL PROTECTED]> wrote: >> >> >>>sorry that should probably be ASC, not DESC, if you want it to go low-high >>> >>>-jc >>> >>> >>> >>>Jeff Congdon wrote: >>> >>> >>> >>>>make your query like this: >>>> >>>>SELECT item, date, MIN(date) AS orderDate >>>> >>>> >>>>FROM yourtable >>> >>> >>>>WHERE itemID = date_itemID >>>>GROUP BY item, date >>>>ORDER BY orderDate DESC, item, date >>>> >>>>-jc >>>> >>>>DRE wrote: >>>> >>>> >>>> >>>> >>>> >>>>>Nobody has any thoughts? >>>>> >>>>> >>>>>On Thu, 4 Nov 2004 08:14:30 -0800, DRE <[EMAIL PROTECTED]> wrote: >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>>>Hi, >>>>>>I have a tricky little issue. Maybe someone can help me. >>>>>> >>>>>>I have a query that returns a grouped output. There are items that >>>>>>have mutiple dates and those dates have to be in order. >>>>>> >>>>>>Kinda like this. >>>>>> >>>>>>item z datea dateb datec >>>>>>item r datee datef dateg >>>>>> >>>>>>so my query is like >>>>>>select item, date >>>>>>where itemid = date_itemid >>>>>>order by itemid, date >>>>>> >>>>>>And the output looks like this >>>>>> >>>>>>#item# >>>>>> >>>>>> #date# >>>>>> >>>>>> >>>>>> >>>>>>So, in order to keep the dates outputing right, I have to order them >>>>>>after the item in the sql order by. >>>>>> >>>>>>Now my problem is this: I have to have the item with the earliest date >>>>>>first. However, to keep the cfoutput group working, I have to have >>>>>>the date by as secondary to the item. >>>>>> >>>>>>I'm thinking I can do it by dumping it into an array of structures and >>>>>>then sorting the array of structures or something like that or perhaps >>>>>>writing a sp. This page will be hit a lot so I'm trying to keep it >>>>>>simple and fast. >>>>>> >>>>>>cfmx and sql2000. >>>>>> >>>>>>Any ideas??? >>>>>> >>>>>>Thanks in advance. >>>>>>DRE >>>>>> >>>>>>-- >>>>>>DRE >>>>>>www.webmachineinc.com >>>>>>www.theanticool.com >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>>> >>>>> >>>> >>>> >>>> >>>> >>> >>> > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183813 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
Java to CFMX Question
I am working with some Java code that I am trying to convert to CFMX again. This time, I am running into issues with a Java enumeration. How do you declare an enumeration in CFMX? CreateObject only works with classes (as far as I can tell). The Java code I am attempting to duplicate is IProject iProject = projectManager.GetProject(126); IRole leaderRole = iProject.GetRole(Plumtree.Remote.PRC.Collaboration.Security.RoleTypes.Leader); ... where Plumtree.Remote.PRC.Collaboration.Security.RoleTypes.Leader is an enumeration with 3 members (Guest, Leader, Member). Can anybody offer any pointers? Thanks -- Jeff Chastain ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183764 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: Report Generation
If you can wait until "early 2005", then ColdFusion will be able to do this natively... http://www.macromedia.com/software/coldfusion/blackstone/features/reporting/ Jeff Garza -Original Message- From: Duncan Loxton [mailto:[EMAIL PROTECTED] Sent: Monday, November 08, 2004 6:33 PM To: CF-Talk Subject: Report Generation I am looking into a nicer way of generating reports with CF. Currently we generate Property lists with 10 on a page grouped by region. http://www.mcgrath.com.au/renting/printsummary/complete.cfm?requesttimeout=1 200 We want to make these reports neater, and define a standard header and footer for each page. Currently there is a lot of counting of rows and other messy things going on to try and make sure we get the pagination right. these reports and variants that are required for printing can take half a day to code in CF. THERE MUST BE A BETTER WAY!!! We are wondering if there may be something available, like Crystal Reports, that we can shove out a data template, header and footer, and section headers and then it will handle all the pagination for printing?? Thanks in advance. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183679 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: SQL question
>Use CFQUERYPARAM with the 'list' attribute and it should work: > >... >dealer_zip IN (value="#returnedzips#" list="true" />) > >Just make sure that the zips in 'returnedzips' don't have truncated >leading zeros. > >cheers, >barneyb That worked! > >On Fri, 05 Nov 2004 19:51:24 -0400, Jeff Fongemie ><[EMAIL PROTECTED]> wrote: >> ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183557 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
SQL question
Hey everyone, I have a table of zipcodes. I have the fieldtype as "interger" and my query works fine: Select * from dealers Where dealer_zip in ( #ReturnedZIPs#) Except that as an interger field type, the leading zeros from the zipcodes are removed. 01234 becomes 1234. My query works, but my display is off since the zipcodes are truncated. If I change my fieldtype to a text field, the zipcodes are left intact, however the above query gets no returns. By the way, #returnedzips# is a variable length list like 39485, 39485, 69685, 03295 etc. Can my query be modified to allow me to change my fieldtype to text? Any suggestions would be most welcome! -Jeff ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183555 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: CFFile Issue
Tom, The lock didn't work. Still gave me the append error. Mosh, Your way worked well doing smaller queries but when doing a real large query where the output file would be like 30+ megs it hung, what I may do is write the file out in smaller more manageable chunks... Jeff > -Original Message- > From: Thomas Chiverton [mailto:[EMAIL PROTECTED] > Sent: Friday, November 05, 2004 6:10 AM > To: CF-Talk > Subject: Re: CFFile Issue > > > On Thursday 04 Nov 2004 16:27 pm, Mosh Teitelbaum wrote: > > I've never run across that problem but it may well be as you > > suggest... some sort of locking error. > > Solution, cflock it exclusivly and see what happens. > > -- > Tom Chiverton ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183486 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: CFLOGOUT
have they fixed the problem where if you write a cookie, and then cflocate, the cookie never gets written? If not, that's probably your problem. Try using a meta-refresh instead of a cflocation. -jc Phillip Perry wrote: >Hi, > >I'm using the cflogout tag but I don't think the session was logged out. I >managed to delete the cookie but the user can still get into the protected >area after logout. This is the code for logout i'm using... > > > > > > >http://localhost/applewood/mycommunity/index2.cfm";> > > >I thought that the cflogout was supposed to get rid of the session. Can >someone shed some light on this please? > >Thanks > >Phil > > > > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183439 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
cftransaction and the request scope
MX 6.1 environment. For some applications, I do some datasource setup in the app.cfm to separate development and production environments, amongst other things. So my app.cfm has some code like this then in a page in the application, i have some transaction processing update foo set foo = bar where bar = foo update bar set bar = foo where foo = bar sometimes, but not always, i will get this error: -- Data source devDS verification failed. The root cause was that: java.sql.SQLException: Datasource names for all the database tags within CFTRANSACTION must be the same. The error occurred on line 232. -- I was under the impression that REQUEST is a superset of the VARIABLES scope, and will always be thread safe and limited to the CURRENT REQUEST only. While the error would imply that I am getting different results for the REQUEST variable within the transaction, I have seen no evidence to back this up. Specifically, whenever it does fail, it always gives the proper datasource in the error message, NEVER giving the "other", "improper" datasource... in this case it would be "productionDS". I can work around this problem by setting variables.thisDSN = REQUEST.thisDSN at the top of the transaction, then just calling #thisDSN# in the datasource field...but what's the point? I thought REQUEST was exactly the same as the VARIABLES scope, excpet REQUEST could be read by all parts of the thread (including custom tags). Why then would it not, within the request, always define request.thisDSN exactly the same way? Any ideas? & TIA, -Jeff ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183438 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: output listing problem
sorry that should probably be ASC, not DESC, if you want it to go low-high -jc Jeff Congdon wrote: >make your query like this: > >SELECT item, date, MIN(date) AS orderDate >FROM yourtable >WHERE itemID = date_itemID >GROUP BY item, date >ORDER BY orderDate DESC, item, date > >-jc > >DRE wrote: > > > >>Nobody has any thoughts? >> >> >>On Thu, 4 Nov 2004 08:14:30 -0800, DRE <[EMAIL PROTECTED]> wrote: >> >> >> >> >>>Hi, >>>I have a tricky little issue. Maybe someone can help me. >>> >>>I have a query that returns a grouped output. There are items that >>>have mutiple dates and those dates have to be in order. >>> >>>Kinda like this. >>> >>>item z datea dateb datec >>>item r datee datef dateg >>> >>>so my query is like >>>select item, date >>>where itemid = date_itemid >>>order by itemid, date >>> >>>And the output looks like this >>> >>> #item# >>> >>>#date# >>> >>> >>> >>>So, in order to keep the dates outputing right, I have to order them >>>after the item in the sql order by. >>> >>>Now my problem is this: I have to have the item with the earliest date >>>first. However, to keep the cfoutput group working, I have to have >>>the date by as secondary to the item. >>> >>>I'm thinking I can do it by dumping it into an array of structures and >>>then sorting the array of structures or something like that or perhaps >>>writing a sp. This page will be hit a lot so I'm trying to keep it >>>simple and fast. >>> >>>cfmx and sql2000. >>> >>>Any ideas??? >>> >>>Thanks in advance. >>>DRE >>> >>>-- >>>DRE >>>www.webmachineinc.com >>>www.theanticool.com >>> >>> >>> >>> >>> >> >> >> >> > > > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183413 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: output listing problem
make your query like this: SELECT item, date, MIN(date) AS orderDate FROM yourtable WHERE itemID = date_itemID GROUP BY item, date ORDER BY orderDate DESC, item, date -jc DRE wrote: >Nobody has any thoughts? > > >On Thu, 4 Nov 2004 08:14:30 -0800, DRE <[EMAIL PROTECTED]> wrote: > > >>Hi, >>I have a tricky little issue. Maybe someone can help me. >> >>I have a query that returns a grouped output. There are items that >>have mutiple dates and those dates have to be in order. >> >>Kinda like this. >> >>item z datea dateb datec >>item r datee datef dateg >> >>so my query is like >>select item, date >>where itemid = date_itemid >>order by itemid, date >> >>And the output looks like this >> >> #item# >> >> #date# >> >> >> >>So, in order to keep the dates outputing right, I have to order them >>after the item in the sql order by. >> >>Now my problem is this: I have to have the item with the earliest date >>first. However, to keep the cfoutput group working, I have to have >>the date by as secondary to the item. >> >>I'm thinking I can do it by dumping it into an array of structures and >>then sorting the array of structures or something like that or perhaps >>writing a sp. This page will be hit a lot so I'm trying to keep it >>simple and fast. >> >>cfmx and sql2000. >> >>Any ideas??? >> >>Thanks in advance. >>DRE >> >>-- >>DRE >>www.webmachineinc.com >>www.theanticool.com >> >> >> > > > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183412 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
CFFile Issue
Something is not right... Has anyone else run across this... I have a query that I write the results to a file using CFFILE. Very simple, albeit its a large result set though. I loop that query to write each record out to a line in a text file. I use the code CFFILE ACTION="Append" After about 70k it errors out. I get this off the cfcatch variables. "An error occurred when performing a file operation Append on file C:\Archive\X.txt." "The cause of this exception was: java.io.IOException: Cannot create a file when that file already exists." My feeling is that there is something locking the file not allowing to be appended to. Has anyone else run across this. Is there a timeout setting anywhere that I might be able to set... This is frustrating because this code worked just fine on CF5? Anyone with any ideas? Thanks... Jeff ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183366 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 Security Best Practices
Sorry if this is a duplicate, it did not appear that my first message went through. I am moving froma shared hosting environment to my own dedicated server, so all the sudden I have to start worrying about how to best setup and secure CFMX on a Windows 2003 box. Does anybody have any resources they could direct me to? I have been browsing Macromedia's site, but any specifics would be appreciated. Thanks -- Jeff Chastain ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182967 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
cfqueryparam question (errors)
Sadly, I'm just learning to use cfqueryparam in my querys. However, I get an error
every time!
"[DataDirect][SequeLink JDBC Driver]Invalid parameter binding(s). "
For the life of me I can't understand why I get this. Query works great without.
ColdFusion MX.
SELECT *
FROM mytable
WHERE '(zip <
) '
Anyone see a problem??
Jeff
~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182740
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: Local MS SQL Server
You can also just download MSDE, which is SQL Server 2000 minus the analysis services and Natural Language search facilities. You can connect to it using EM and/or Query Analyzer as well. http://www.microsoft.com/downloads/details.aspx?familyid=413744d1-a0bc-479f- bafa-e4b278eb9147&displaylang=en Jeff Garza -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 26, 2004 5:34 AM To: CF-Talk Subject: RE: OT: Local MS SQL Server > From: Rodger [mailto:[EMAIL PROTECTED] > This brings up another question: > Is there a way to install my copy of MS SQL Server onto my XP > machine to be used for dev? > When I try, it only allows me to install the client stuff > (Enterprise Manager and Query Analyzer). You need to get a copy of the desktop edition of sql server... That is the only one that will run on XP... Or any non server OS for that matter. It is included in the MSDN library if you have that.. If not, I think someone previosuly mentioned it is pretty cheap to buy... $49 or something.. Mike ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=36 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182592 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 -looping through a list
Further, It's the "or" in my loop. It always ends up at the end of my SQL statement with nothing after it so I get an error. ? ~| The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in the Washington DC Area. http://www.houseoffusion.com/banners/view.cfm?bannerid=44 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182565 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 -looping through a list
What's wrong with this code? Select * from Dealers Where dealer_zip ='#zip#' or I get a list of zipcodes. I need to get all the dealers that have match any one of zipcodes from my list. I must be missing something simple! -Jeff ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=34 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182558 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: strange error (help!)
>Verify that the query works without using CFQUERYPARAM > It does work without the CFQUERYPARAM. Why is that??? -Jeff ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=36 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182557 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
strange error (help!)
I'm getting an error that I've not seen, and I can't seem to see what the cause is. This is the error: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented 125 : SELECT zipcodes.zipcode AS ZipCode, zipcodes.Latitude AS Lat, zipcodes.Longitude AS Lon FROM zipcodes WHERE ( Latitude > (param 1) AND Latitude < (param 2) ) AND ( Longitude > (param 3) AND Longitude < (param 4) ) VENDORERRORCODE 106 SQLSTATE HYC00 Cold Fusion has the line "value="#variables.LonS#"> " in bold, but that variable has been set above. Anyone recognise the problem? My searching for this error & error code has not turned up anything that leads me to the problem? -Thanks Jeff ~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182555 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: Cffile issue...
No one with any ideas?? I'm still pretty much stumped over this one. > -Original Message- > From: Jeff Waris [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 20, 2004 2:17 PM > To: CF-Talk > Subject: Cffile issue... > > > "An error occurred when performing a file operation Append on file." > > Using CFMX 6.1, all I am doing is taking a query and writing > it out to a file, line by line for each record. It writes > about 70K and it errors out with that message at the top. > Once errored, Coldfusion still has the file. The only way for > Coldfusion to release it is to restart services. > > Anyone have anything similar happen to them? Ideas? > > Thanks, > Jeff ~| Get the mailserver that powers this list at http://www.houseoffusion.com/banners/view.cfm?bannerid=17 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182489 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: Has anyone done this?
It's actually a compliance issue for an audit. Annoying for users I would wholeheartedly agree. I've actually seen something like what I am asking working on another website, although whatever the technique being used ONLY works with IE. I can easily go back using firefox.. Jeff > -Original Message- > From: Dave Watts [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 21, 2004 11:56 AM > To: CF-Talk > Subject: RE: Has anyone done this? > > > > Now for my issue. If a user leaves my site and goes somewhere > > else, and then attempts to use his back button to come back > > to the site, I would like to return them to the login prompt. > > Technically, since they didn't log off and moved to another > > url via a favorite or manually typed, when hitting the back > > button, they have sessions still active. So they are let back > > in. Has anyone done this before? I was thinking of checking > > the referrer, but am unsure if I can get that to work > > correctly when the user hits the back button. Am I on the > > right track looking at the CGI referrer variable... > > Unfortunately, you will find it very difficult to do this in > a reliable way, I suspect. I'm not sure why you'd want to do > it at all - it seems like a significant annoyance for your users. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > phone: 202-797-5496 > fax: 202-797-5444 ~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182488 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
Has anyone done this?
I have an application that uses sessions and cookies to log people in. Simple enough. Now for my issue. If a user leaves my site and goes somewhere else, and then attempts to use his back button to come back to the site, I would like to return them to the login prompt. Technically, since they didn't log off and moved to another url via a favorite or manually typed, when hitting the back button, they have sessions still active. So they are let back in. Has anyone done this before? I was thinking of checking the referrer, but am unsure if I can get that to work correctly when the user hits the back button. Am I on the right track looking at the CGI referrer variable... Thanks. Jeff ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182166 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
Cffile issue...
"An error occurred when performing a file operation Append on file." Using CFMX 6.1, all I am doing is taking a query and writing it out to a file, line by line for each record. It writes about 70K and it errors out with that message at the top. Once errored, Coldfusion still has the file. The only way for Coldfusion to release it is to restart services. Anyone have anything similar happen to them? Ideas? Thanks, Jeff ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182053 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: cflock
You don't need one in the current directory, you just need to make sure the one in the previous directory has that cfapplication tag. If there's no app.cfm in the current diretory, CF will automatically look in ../, ../.../, etc until it finds one. Generally you want 1 app.cfm, and it should be in the root directory of the application. Obviously there are cases where you'd want more than 1, but that's for another day. -jc Phillip Perry wrote: >Great thanks. I made a new folder in the main directory so I hadn't thought >about making an app.cfm inside it. I guess that shows how important a >app.cfm file really is > >-Original Message- >From: Barney Boisvert [mailto:[EMAIL PROTECTED] >Sent: Tuesday, October 19, 2004 12:52 PM >To: CF-Talk >Subject: Re: cflock > > >You just need to add a CFAPPLICATION tag to you app, and you'll be set. > >cheers, >barneyb > >On Tue, 19 Oct 2004 12:42:47 -0400, Phillip Perry ><[EMAIL PROTECTED]> wrote: > > >>Hi, >> >>First, thanks to James and everyone else for the solutions to the custom >>tag. Now I'm into CFLOCK. I'm trying to make a custom tag for a banner >>rotation and I am using cflock. But when I execute my code it gives this >>error... >> >>Cannot lock APPLICATION scope. >>CFLock cannot be used to lock the application or session shared scopes >>without these scopes being established through the use of the >> >> >CFApplication > > >>tag. If you want to use the session scope you need to enable session >>management. Application and/or Session variables must also be enabled in >> >> >the > > >>ColdFusion Administrator. >> >>I'm assuming I have to fiddle with the admin settings, but what exactly am >> >> >I > > >>looking for..or is it even an admin problem in the first place? >> >>Thanks >> >>Phil >> >> >> >> > > > > ~| Get the mailserver that powers this list at http://www.houseoffusion.com/banners/view.cfm?bannerid=17 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181892 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: HTTP_REFERER
I use something like this in my application.cfm to check to see if the user is logged in and if not, capture the original URL that they requested and display the login page. cgi.query_string> Substitute localhost for your webroot. Then in your login template, you'll have access to the initialURL variable that you can then use to redirect the user to the originally requested page. HTH, Jeff Garza Manager, Phoenix ColdFusion User Group [EMAIL PROTECTED] _ From: Phillip Perry [mailto:[EMAIL PROTECTED] Sent: Sunday, October 17, 2004 3:11 PM To: CF-Talk Subject: HTTP_REFERER Thanks for answering my last question. Too many issues kept coming up so I abandoned using application.cfm for headers and went back to just including templates into each page. Now I have another problem. When I have people log in I want them to go to the page that they wanted to go to right after the login info is confirmed. Doing this with the HTTP_REFERER variable gives me an error stating that http://www.blah.com/blah/blah.cfm is syntactically incorrect. I'm assuming its becuase of all the /'s and :'s and the like. How do I go about doing this? Thanks Phil _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT: Javascript Date/Time help!
Worked like a charm. The only issue was leading 0's for dates/times like 01/09/2004 and I was able to get around that.. Oh, I did comment that the code was only viable til the year and that some other means of checking will be needed for Y10K.. :) Jeff -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 13, 2004 2:56 PM To: CF-Talk Subject: Re: OT: _javascript_ Date/Time help! Change this to separate fields for , MM and DD. Concatenate them all together, then concatenate that with the server time and you have MMDDHHMMSS. You can now do a simple string comparison (just be sure to document that the code needs to be revised before Y10K). Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: Javascript Date/Time help!
I can handle this with CF no problem, but I have an instance where I need to make a DATE and TIME comparison with the server time BEFORE a form gets submitted. I figure the best way to handle this is in the form of some _javascript_ validation. I know _javascript_ but I am no expert by any means. Here is what I got: -I can pull the current form date entry with document.myForm.dueDate.value. -Everyone enters the date in MM/DD/ on the form. -I can make a _javascript_ variable of the current server DATE using createdate() CF function. -I can make a _javascript_ variable of the current server TIME as well using the CF function createtime(). -I can pull from my database a CUTOFF time in HH:MM:SS from my database. Now for the tuff part. Using _javascript_, I need to combine the FORM DATE and CURRENT SERVER TIME into a single _javascript_ variable, lets call it FORMDATE_TIME. I then need to take the CURRENT SERVER DATE and compine it with the DATABASE's CUTOFF TIME into another _javascript_ variable as CUTOFFDATE_TIME. Once I have those variables, I want to return true if the FORMDATE_TIME is less than the CUTOFFDATE_TIME and return false if not. Any help or point in the right direction from any _javascript_ gurus would be appreciated... Thanks. Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: IS this an MX issue??? Form Validation...
Must have stumped everyone today... Anyone with any clues??? I've spent most of the morning looking through macromedia and and the talk archives with really no luck... How do other people do form validation when they want to check form fields manually and also use CFform validation as well? Both use the onsubmit() _javascript_ function... Thanks, Jeff -Original Message- From: Jeff Waris [mailto:[EMAIL PROTECTED] Sent: Monday, October 11, 2004 10:36 AM To: CF-Talk Subject: IS this an MX issue??? I just started having this problem, and I am not sure why. Normally we do a onsubmit() for manually checking some form variables. This has always worked nicely along with cfform checking. Now it seems that my manual onsubmit is REPLACED with the CF generated onsubmit. Is there some new way to do this or am I missing something? Is there some technique that allows me to use both CFform error checking and my own, or is this just a Monday brain lag while most people have off?? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
IS this an MX issue???
I just started having this problem, and I am not sure why. Normally we do a onsubmit() for manually checking some form variables. This has always worked nicely along with cfform checking. Now it seems that my manual onsubmit is REPLACED with the CF generated onsubmit. Is there some new way to do this or am I missing something? Is there some technique that allows me to use both CFform error checking and my own, or is this just a Monday brain lag while most people have off?? Thanks, Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
SQL stored procedure question
OK, after hearing everybody say don't use Access and an converting my Check Request System to MS SQL Server. And I am trying to use Stored Procedures. However, I am finding it more difficult then I anticipated. For instance, I used to have a query like this: blockfactor="100"> select crID, SOffUser, SOffNote from qrySignoffRequest where SOffDecision = 'Open' and SOffUser = '#theUser#' order by #sort5# My stored procedure attempt was this: CREATE PROCEDURE SignOffCheckRequest_Getx_byDecision_SoffUser @SoffUser varchar(10), @Decision varchar(10), @Sort varchar(10) AS select crID, SOffUser, SOffNote from viewSignoffCheckRequest where SOffDecision = @Decision and SOffUser = @SoffUser Order by CASE WHEN @Sort = 'crID' THEN crID WHEN @Sort = 'crDate' THEN crDate WHEN @Sort = 'crVendor' THEN crVendor WHEN @Sort = 'crChkAmt' THEN crChkAmt WHEN @Sort = 'SOffUser' THEN SOffUser END GO It worked for every type of sort except one (crVendor) where it said that it was trying to convert an nvarchar to a float. What's that all about? Then we come to this query: username="abc" password="xyz"> select * from WEBMASTER.AP_COA where 1=1 "">and ldr_entity_id like '#searchCO#%' gt "">and ull_prime like '#searchPRIME#%' "">and ull_center like '#searchCTR#%' "">and ull_sbu like '#searchSBU#%' "">and ull_product like '#searchPROD#%' "">and ull_minor like '#searchMIN#%' searchCUSTOMER gt "">and ull_customer like '#searchCUSTOMER#%' gt "">and ull_misc1 like '#searchMISC1#%' gt "">and ull_misc2 like '#searchMISC2#%' How do I convert that to a stored procedure? I am about to give up! Thanks for you help, Jeff Notice. This message is intended only for use by the person or entity to which it is addressed. Because it may contain confidential information intended solely for the addressee, you are notified that any disclosing, copying, downloading, distributing or retaining of this message, and any attached files, is prohibited and may be a violation of state or federal law. If you received this message in error, please notify the sender by reply email, and delete the message and all attached files. Thank you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Resources for CFC
> CFMX 6.0 did not have "variables" scope in CFCs so all CFCs tended to > use "this" scope to store data. Which is bad because that's a public > scope (so all your data is exposed). > > CFMX 6.1 introduced "variables" scope - which behaves much like > protected data in Java - and the best practice these days is to avoid > "this" scope (for all the same reasons that OO programmers everywhere > are taught to avoid public instance data). > > So the book has a lot of code examples that use "this" scope instead > of the more correct (in 6.1 onward) "variables" scope. > > Does that explain it? Oh absolutely. You know, I didn't know that. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: request to add a new forum - cfc
There already is a listserv for components called cfcdev and can be found at www.cfczone.org. Jeff Garza _ From: Chunshen (Don) Li [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 06, 2004 8:32 PM To: CF-Talk Subject: OT: request to add a new forum - cfc Chief, Strangly, I got the cfc "fever" in the last few days, would it potentially benefit the community quite a bit if you add a separate forum, cf-cfc? I'm just thinking loud here. Thanks. DL _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Resources for CFC
> "Discovering CFCs" by Hal Helms (bear in mind it was written for CFMX > 6.0 so it uses "this" scope) Okay, you got me. I gotta ask. What's with the "this" scope and CFMX 6.0? Can you explain further this caveat you added? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Coldfusion and C++
> I do not think a bunch of students is competent to judge if something can > be good or not. Haha, well we'll certainly have to disagree one that point. I'm of the opinion that people *learning* the language from the ground up in college are *especially* competent to judge if something can be good or not. Your mileage may vary. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Coldfusion and C++
> Pointers were the single most problematic aspect of C and C++ for many > developers and were the primary source of application unreliability > (memory leaks, reusing freed memory etc). Implementing a safe virtual > machine that supports unmanaged pointers is extremely hard - they're > just not worth the hassle to be honest. Hear Hear...Glad someone else said it before I got a chance. Whoever thinks pointers were a good thing needs to have their head examined. I remember when Java first came aboutpeople LOVED "no pointers". I remember my first java class in college back in like, 97 or so, and when they were talking about how Java didn't have pointers, the whole class broke out into applause...lol... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Upgraded to CFMX6.1 -spell check broke
JSpellCheck works on MX, i've used it on 6 and 6.1. It looks like all my files are in c:\CFX_JSpellCheck, and then the cfx is pointed to that. -Jeff Mike Kear wrote: > We updgraded one of our dev servers this week, and everything seems to > have gone smoothly, nary an issue. Nice. > > Except one CFX tag broke. It is apparently registered correctly as a > java tag in the CFAdministrator, yet when it's called we get the > message: > [quote] > Error processing CFX custom tag "CFX_JSpellCheck". > The CFX custom tag "CFX_JSpellCheck" was not found in the custom tag > database. > [/quote] > > I'm assuming it's either because we haven't put the JSpellCheck files > in the right place or that the CFX tag that worked in CF5.0 doesnt > work in CFX and we have to get another version from CFDEV.com. > > Does anyone know? Am I right in that the CFX tag and its associated > files have to go under the CFX directory not the CustomTags directory? > -- > Cheers > Mike Kear > Windsor, NSW, Australia > AFP Webworks > http://afpwebworks.com > .com,.net,.org domains from AUD$20/Year > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cfstored proc returning value
I've had no problems using the return variables instead of a full result set with SQL 2000. It appears that you aren't using the DBVARNAME attribute. I know that CFSTOREDPROC will execute in the order that they are declared, but I don't know if the same holds true for output params. Try using the the varname as well. Also, I got the same error you did initially. but it ended up being that my procparam for teamdesc was set to CF_SQL_INTEGER when it was a VARCHAR in the proc itself. (cut and paste error). Here is a query that works for me. value="#form.newTeamNum#"> value="#form.currentDistrict#"> value="#form.teamDesc#"> variable="newID"> And here is the stored proc script. CREATE PROC rgis_TeamAdd2 @TeamNumber int, @DistrictID int, @TeamDesc varchar(100), @newTeamID int OUT AS SET NOCOUNT ON INSERT INTO trefTeams(TeamNumber, DistrictID, TeamDesc) VALUES (@TeamNumber, @DistrictID, @TeamDesc) SET @newTeamID = (SELECT Scope_Identity()) SET NOCOUNT OFF HTH, Jeff Garza _ From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Saturday, October 02, 2004 5:23 PM To: CF-Talk Subject: cfstored proc returning value Anyone see whats wrong with the following stored procedure call, I keep getting the following error when trying to return an integer (last ID)... "Invalid data for CFSQLTYPE CF_SQL_INTEGER." CF Stored Proc Call procedure="INSERT_COMMUNITY_BUSINESS" datasource="#application['stcGlobalVars']['dsn_insert']#"> cfsqltype="CF_SQL_INTEGER" value="#Trim(attributes['businessType'])#" null="#YesNoFormat(Trim(attributes['businessType']) EQ 0)#" /> cfsqltype="CF_SQL_VARCHAR" value="#Trim(attributes['businessName'])#" null="no" /> cfsqltype="CF_SQL_VARCHAR" value="#Trim(attributes['division'])#" null="#YesNoFormat(Len(Trim(attributes['division'])) EQ 0)#" /> cfsqltype="CF_SQL_INTEGER" type="Out" variable="newId" /> And the T-SQL stored proc... CREATE PROCEDURE INSERT_COMMUNITY_BUSINESS @VAR_BUSINESS_TYPE_ID INT, @VAR_BUSINESS_NAME VARCHAR(50), @VAR_BUSINESS_DIVISION VARCHAR(50), @VAR_NEW_ID INT OUTPUT AS INSERT INTO COMMUNITY_BUSINESS ( BUSINESS_TYPE_ID, BUSINESS_NAME, BUSINESS_DIVISION ) VALUES ( @VAR_BUSINESS_TYPE_ID, @VAR_BUSINESS_NAME, @VAR_BUSINESS_DIVISION ) SELECT @VAR_NEW_ID = SCOPE_IDENTITY() GO Thanks! Mike _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
National Weather Service XML Web Service Issues
Has anyone successfully retrieved the data from this Web Service using ColdFusion? I've tried every permuation of data types for weatherParameters but nothing seems to work. The documentation online calls it an array of booleans. It looks like a custom datatype to me by looking at the WSDL... Anyone have any luck with this? WSDL URL: http://www.nws.noaa.gov/forecasts/xml/DWMLgen/wsdl/ndfdXML.wsdl NWS Information Page: http://nws.noaa.gov/forecasts/xml/ Thanks, Jeff Garza [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF Express
I definately agree with Jim here... take a look at Blue Dragon. I've used it with several smaller clients that were hosting some internal sites and didn't want to pay for a full version of CF. Works very well. Cheers, Jeff Garza - Original Message - From: Jim Davis To: CF-Talk Sent: Friday, September 24, 2004 1:27 PM Subject: RE: CF Express Is there any particular reason that you're looking for Express? As I remember the it's actually based on CF 4.5 and lacks quire a bit of the functionality is missing. On the other hand BlueDragon is (I'm almost sure) free for such a purpose, has much more functionality and is (damn near) feature compatible with CF MX. Check out NewAtlanta.com for more information - I think you'll be pleasantly surprised. Jim Davis _ From: Donna French [mailto:[EMAIL PROTECTED] Sent: Friday, September 24, 2004 4:10 PM To: CF-Talk Subject: CF Express Does anyone have a copy of this? I have a client that I need to build a small app for but it's a non-profit organization and they can't afford the full version. I have an FTP I can setup if anyone has it and willing to upload. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Windows 2003 Error
Some of the software installed on this box has to run in IIS 5 compatibility mode. I have talked with that vendor and they have never seen this issue before either. I just don't know what this error is telling me and I cannot find anybody with any suggestions on why one box works and another doesn't ... each running the same software and versions. Thanks for the help. -- Jeff _ From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 3:46 PM To: CF-Talk Subject: RE: Windows 2003 Error > Sorry, this is a really off topic .NET box, no CFMX. The > ISAPI filters installed are Netegrity's SiteMinder Web Agent > and ASP.NET_1.1.4322.947. > > I was just hoping somebody familiar with server support might > have some clue. Well, I'm sure there's no problem with the ASP.NET stuff on Windows Server 2003, so my guess is that it's with Netegrity's ISAPI filter. Perhaps there's a newer version, or you're running the newer version in IIS 5 compatibility mode? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Windows 2003 Error
Sorry, this is a really off topic .NET box, no CFMX. The ISAPI filters installed are Netegrity's SiteMinder Web Agent and ASP.NET_1.1.4322.947. I was just hoping somebody familiar with server support might have some clue. Thanks -- Jeff _ From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, September 23, 2004 3:26 PM To: CF-Talk Subject: RE: Windows 2003 Error > Interesting ... the list cut off the last half of the post. > Lets try this again. > > Event Viewer Info: > > Event Type: Error > Event Source: W3SVC-WP > Event Category: None > Event ID: 2267 > Date: 9/23/2004 > Time: 9:42:56 AM > User: N/A > Computer: PT-WS1 > Description: > Raw ISAPI Filter could not be loaded due to configuration problem. > HTTPFilter Service has to be hosted in inetinfo.exe for Raw > ISAPI filters to work correctly. The most likely reason is > that IIS5IsolationModeEnabled setting was changed and > HTTPFilter service was not restarted. Restart the HTTPFilter > for configuration changes to be taken into effect. What ISAPI filters are you loading into IIS? CFMX doesn't use an ISAPI filter with IIS 6, it uses ISAPI extensions only. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Windows 2003 Error
Interesting ... the list cut off the last half of the post. Lets try this again. Event Viewer Info: Event Type: Error Event Source: W3SVC-WP Event Category: None Event ID: 2267 Date: 9/23/2004 Time: 9:42:56 AM User: N/A Computer: PT-WS1 Description: Raw ISAPI Filter could not be loaded due to configuration problem. HTTPFilter Service has to be hosted in inetinfo.exe for Raw ISAPI filters to work correctly. The most likely reason is that IIS5IsolationModeEnabled setting was changed and HTTPFilter service was not restarted. Restart the HTTPFilter for configuration changes to be taken into effect. Thanks, -- Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: Windows 2003 Error
I am getting the following error in Windows 2003 and it shuts down the IIS web services until I manually go restart them. I have searched everywhere I can think of and cannot find a resolution to this. Has anybody seen this error or have any idea how I could fix it? This error has been happening randomly for quite some time now. The box has been restarted several times and nothing appears to effect this error. I have several other Windows 2003 boxes, loaded and configured exactly the same that are not having this issue. Any suggestions? -- Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Doug White - clickdoug.com
If you went this route, Paypal can then place a negative mark on your credit report. They can also send it to collections which will further negatively impact your credit. So if you're looking to buy a home or car or get life insurance (worse credit = worse rates) or approval for any other line of credit I highly suggest that you not go this route. --Jeff On 9/23/2004 11:31 AM, Kristopher Pilles wrote: > Call up and get a new CC # then Paypal can't charge you. > > > KP > > -Original Message- > From: Charlie Griefer [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 23, 2004 11:28 AM > To: CF-Talk > Subject: Re: Doug White - clickdoug.com > > > I'm actually right in the middle of trying to get the > 'situation' > resolved myself. I lost a little data...but it's personal > stuff, not > business related...so there's no money loss there (or customers > to > deal with). > > But on Aug 5, I paid for 1 year of hosting. Doug and his > servers > disappeared about 1 month later. So I'd love to at least make > an > attempt to get my $ back. I had paid with paypal, and they > don't even > talk to you about disputing a charge after 30 days. Wouldn't > have > mattered, as they told me today that they don't "support" > intangible > services such as web hosting (as far as disputing a charge). > Had > called the bank a few days ago to see if they could do something > about > the charge...they did. They overturned the PayPal payment. So > now > the $ is back in my bank account, but my PayPal balance is > negative. > Which essentially means that PayPal will charge my secondary > source > (credit card), which puts me right back at square 1. > > I'm wondering if anybody who was involved has made any attempts > to get > their money back? Who would I go to to make an attempt? If > there are > others, maybe forming a group would help (strength in numbers)? > > Charlie > > On Thu, 23 Sep 2004 11:17:24 -0400, Burns, John D > <[EMAIL PROTECTED]> wrote: > > I noticed there was a thread in CF-Community from a few weeks > ago of > > people who were hosting with Doug White (www.clickdoug.com) > who had > > experienced his "outage" that never came back up and are > having trouble > > contacting him. Has anyone had any luck with this? We were > hosting > > with him and moved all of our sites to rackspace.com but are > in serious > > need of some files and stuff off of the server that Doug White > has. > > Calling and emailing has resulted in nothing. We've filed a > report with > > the San Antonio Police Department and are in the process of > filing a law > > suit. I'd like to avoid all of that by getting in touch with > him, but > > it appears that he's trying to skip out of the business with > everyone's > > money and files. Anyone have any information that could help? > Thanks. > > > > John Burns > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Create Windows Folder / Share?
Thanks guys. I was trying to make this a lot more complicated. Thanks again, -- Jeff Quoting Jochem van Dieten <[EMAIL PROTECTED]>: > Jeff Chastain wrote: > > I have a case where I need to be able to programmatically create a new > Windows > > folder (cfdirectory), but then be able to alter the permissions and setup > that > > folder as a NT share. > > Use cfexecute. cacls to set permissions and "net share ..." to > create the share. > > Jochem > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Create Windows Folder / Share?
I have a case where I need to be able to programmatically create a new Windows folder (cfdirectory), but then be able to alter the permissions and setup that folder as a NT share. Can anybody give me some direction on how to go about the last 2 in a Windows 2003 environment using ColdFusion? Thanks -- Jeff - This mail sent through IMP: http://horde.org/imp/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
zip code based dealer locator
Hi Everyone, I need a dealer locator based on zip codes. I guess there are two parts, the database and the code. Anyone know of a good zip code database for sale or free? With a google search I find a large difference in pricing. Can anyone recommend a good one? Is this thing difficult to build? I've found some free code and a few cheap or free custom tags out there. Looks like none work with Access database. Can anyone recommend from experience one of the available custom tags available? Thanks for any info on this. -Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Okay, here's EXACTLY what's going on...Re: Completely baffled ...
> Well, I would strongly recommend that you put roles into a separate table. > However, within your code, you might want to use the role name rather than > some surrogate key value solely for documentation purposes. For example, > it's clear to the reader of the code what this does: > > ... > > This, on the other hand, isn't so clear: > > ... Makes total sense. It's how I ultimately went, and agree, it does read a lot easier and make more sense when going thru the code. > That implies a hierarchy of roles, which isn't really how people generally > use roles I think. I think that a good model is how Windows handles > permissions. You have groups, and any user can be a member of any group. > Being a member of one group doesn't provide implicit membership in any > other > group, although there are "contextual groups" in Windows like > "Authenticated > Users" and "Everyone", which really aren't groups at all. > > But in any case, IsUserInRole returns a boolean value, so you can't really > "roll up" things the way you describe in your example. Aha...this also makes a lot of sense too. I thought that you could somehow return the role a user was in, but I had it mixed up. I'm sure I would've discovered that in about two or three minutes...lol... But in looking at how you described users and groups makes sense, I guess I had just never applied that kind of thinking to my applications. So you have groups in a table, and keep track of who's in what group with a lookup table then, no? That's really cool. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Okay, here's EXACTLY what's going on...Re: Completely baffled ...
> That's odd. What is the datatype of the field within the database? It's an int. regular ol' foreign key, nothing fancy. > Honestly, I've never used anything but strings for the ROLES attribute, > although I can see why you might want to do that. Oh, I know! I know! I mean, I figured it would just be good practice to pull the roles into another table, because they want to keep additional information, not just the string with the role type, so naturally I just pulled it out into another table. Not to mention, wouldn't you want to do this to "roll up" your user roles? Couldn't I say, use that rule to say something like: Right? Oh, and to add to this. I went ahead and re-wrote the query so it's a join and actually returns the string of the type. So instead of ToString(Login.OwnerType_fk) I just actually pass in the string with the guy's role. Oh well. I got it to work, and found something that stumped people in the process. All in all a good day, I'd say. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Okay, here's EXACTLY what's going on...Re: Completely baffled ...
- Original Message - From: "Jeff Small" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, September 17, 2004 3:22 PM Subject: Re: Okay, here's EXACTLY what's going on...Re: Completely baffled ... >> I suspect that you may have some name mismatch, and that the value of >> Login.OwnerTypeID_fk is not one, because of the mismatch. In the first >> paragraph, you say that the fields are named fname, lname, id, email, and >> Type_ID_fk. > > Sorry, I was trimming the names for email. They're named the EXACT same. I > was just typing from memory, then went and pasted my cflogin. > > I got the value, by *dragging* the name from the bindings tab in > Dreamweaver. Then even *verified* that it was named the same. I even > dumped > it again to make sure. It's the same. Not only that, as soon as I wrapped that output in a tostring(), it worked. Example: password="#OwnerEmail#" roles="#Login.OwnerTypeID_fk#"> Throws an error. password="#OwnerEmail#" roles="#ToString(Login.OwnerTypeID_fk)#"> Works like a charm. Now, is that weird? Or did I overlook something in CF Class? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Okay, here's EXACTLY what's going on...Re: Completely baffled ...
> I suspect that you may have some name mismatch, and that the value of > Login.OwnerTypeID_fk is not one, because of the mismatch. In the first > paragraph, you say that the fields are named fname, lname, id, email, and > Type_ID_fk. Sorry, I was trimming the names for email. They're named the EXACT same. I was just typing from memory, then went and pasted my cflogin. I got the value, by *dragging* the name from the bindings tab in Dreamweaver. Then even *verified* that it was named the same. I even dumped it again to make sure. It's the same. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Okay, here's EXACTLY what's going on...Re: Completely baffled...
I've narrowed it down to a cfloginuser tag. I'm querying a table to return * (fname, lname, ID, email, Type_ID_fk) after passing in form variables. This is working. I can dump the query and see it all. (Jeff, Small, 1, [EMAIL PROTECTED], 1) Type_ID_fk is a foreign key to a table. I only really have two types of users, but the types are stored in another table with information about the type, etc. I store the ID to the type in the login table. Now...here's where it gets interesting. password="#OwnerEmail#" roles="#Login.OwnerTypeID_fk#"> throws the error. *however* password="#OwnerEmail#" roles="1"> does NOT throw an error. Even though the *VALUE* of #Login.OwnerTypeID_fk# IS '1'. Why does it throw an error if I dynamically put a '1' in there, and not throw one if I explicitly put in '1'? - Original Message - From: "Pete Freitag" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, September 17, 2004 1:17 PM Subject: Re: Completely baffled... > Sounds like your looking at the wrong file. Make sure that the error > isn't thrown from one of your included templates, custom tags, > Application.cfm, etc. > > Also if your using client variables could be this one: > http://www.petefreitag.com/item/163.cfm > > __ > Pete Freitag > http://www.cfdev.com/ > Author of the CFMX Developers Cookbook > http://www.petefreitag.com/bookshelf/ > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Java Import -> CF
That is what I was afraid of, but it was worth asking. Thanks for your help. -- Jeff Quoting Kola Oyedeji <[EMAIL PROTECTED]>: > Jeff AFAIK there is no way to do this in CF, you're stuck with using > create object. > > KOla > > -Original Message- > From: Jeff Chastain [mailto:[EMAIL PROTECTED] > Sent: 17 September 2004 17:19 > To: CF-Talk > Subject: RE: Java Import -> CF > > Okay, a better reply is that it appears that the following JSP package > import ... > > <% page language="java" import="com.plumtree.remote.portlet.*" %> > > ... is actually comparable to ... > > > class="com.plumtree.remote.portlet.AggregationMode" > name="AggregationMode"> > > class="com.plumtree.remote.portlet.CommunityAccessLevel" > name="CommunityAccessLevel"> > > class="com.plumtree.remote.portlet.HostedDisplayMode" > name="HostedDisplayMode"> > > ... etc. for all 15 classes in this package. > > So, is there a simpler way to do this? It would be ideal, as it is in > JSP, to > have all of the objects already created and ready to use without having > to > perform N cfobject calls at the top of a template. > > Thanks > - Jeff > > Quoting Kola Oyedeji <[EMAIL PROTECTED]>: > > > If you have the package available as a jar you should be able to > > reference it in the administrator under the classpath settings. > > > > Kola > > > > - > This mail sent through IMP: http://horde.org/imp/ > _ > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Java Import -> CF
Okay, a better reply is that it appears that the following JSP package import ... <% page language="java" import="com.plumtree.remote.portlet.*" %> ... is actually comparable to ... class="com.plumtree.remote.portlet.AggregationMode" name="AggregationMode"> class="com.plumtree.remote.portlet.CommunityAccessLevel" name="CommunityAccessLevel"> class="com.plumtree.remote.portlet.HostedDisplayMode" name="HostedDisplayMode"> ... etc. for all 15 classes in this package. So, is there a simpler way to do this? It would be ideal, as it is in JSP, to have all of the objects already created and ready to use without having to perform N cfobject calls at the top of a template. Thanks - Jeff Quoting Kola Oyedeji <[EMAIL PROTECTED]>: > If you have the package available as a jar you should be able to > reference it in the administrator under the classpath settings. > > Kola > - This mail sent through IMP: http://horde.org/imp/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Completely baffled...
I'm getting the following error: Error Occurred While Processing Request The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code. Null Pointers are another name for undefined values. And I have NO IDEA where it's coming from...it's isolating a line of code that's a comment, and just after the comment is a value that I've checked, double checked and triple checked. It's spelled correctly, etc... I comment out the offending line of code, and anothe line below it gives the same error. What's going on? WindowsXPPro, CFMX 6.1, DWMX2004...what am I missing? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Java Import -> CF
Well, the com.plumtree.remote.portlet.* namespace is part of a jar that is
already referenced in the CF administrator. I have all of that setup.
However, it appears that when the package is being imported in JSP, that some
constructor or something is being called that instantiates the
'CommunityAccessLevel.Edit' class and static variable automatically. This is
what I am trying to duplicate.
If I just add the path to the jar file in the Administrator classpath, it is not
giving me the same result as the JSP import. So, I need to figure out what
the missing piece is between the two.
Thanks
-- Jeff
Quoting Kola Oyedeji <[EMAIL PROTECTED]>:
> If you have the package available as a jar you should be able to
> reference it in the administrator under the classpath settings.
>
> Kola
>
> -Original Message-
> From: Jeff Chastain [mailto:[EMAIL PROTECTED]
> Sent: 17 September 2004 16:07
> To: CF-Talk
> Subject: RE: Java Import -> CF
>
> Okay, I have the terminology figured out a little better now, so lets
> see if
> this helps.
>
> The JSP page is including a package which apparently instantiates the
> CommunityAccessLevel class on import. So, in ColdFusion, how can you
> import a
> Java package?
>
> I could just create a new object based upon this class, I am just not
> sure that
> is the best answer.
>
> Thanks
> -- Jeff
>
> Quoting Jeff Chastain <[EMAIL PROTECTED]>:
>
> > Okay, maybe with some more context, you can help me out with this
> then. I
> > have the following JSP code that I am attempting to convert to CF.
> >
> > <% page language="java" import="com.plumtree.remote.portlet.*" %>
> > <%
> > IPortletContext context =
> > PortletContextFactory.createPortletContext(request, response);
> > IPortletUser portletUser = context.getUser();
> >
> > if ( CommunityAccessLevel.Edit ==
> > portletUser.getCurrentCommunityAccessLevel() ) {
> >
> >
> > I have the CF code that handles the first two object declarations (via
> > cfobject). Where I am running into problems is in the IF statement
> with the
> > 'CommunityAccessLevel.Edit'. There is nothing in the page before this
> that
> > declares a CommunityAccessLevel object. In reading the documentation
> for
> > this API, CommunityAccessLevel is a class in the
> plumtree.remote.portlet
> > namespace that has a static field called Edit.
> >
> > So, how would I translate this into CF?
> >
> > Thanks for your help.
> > -- Jeff
> >
> > _
> >
> > From: Samuel Neff [mailto:[EMAIL PROTECTED]
> > Sent: Friday, September 17, 2004 8:13 AM
> > To: CF-Talk
> > Subject: RE: Java Import -> CF
> >
> >
> > Import in Java doesn't instatiate anything, all it does is make a
> reference
> > used by the compiler to use shorthand access to packages so you don't
> have
> > to write out the whole package name every time you reference a class
> in that
> > package.
> >
> > The closest equivalent in CF would be:
> >
> >
> >
> >
> > Sam
> >
> > --
> > Blog: http://www.rewindlife.com
> > Chart: http://www.blinex.com/products/charting
> > --
> >
> > -Original Message-
> > From: Jeff Chastain [mailto:[EMAIL PROTECTED]
> > Sent: Friday, September 17, 2004 8:45 AM
> > To: CF-Talk
> > Subject: Java Import -> CF
> >
> > When you see the following line in a JSP file ...
> > <% page language="java" import="com.plumtree.remote.portlet.*" %>
> > ... is there a way to duplicate this functionality in CFMX? Is it
> possible
> > it import an entire library like this rather than instantiating every
> class
> > individually with cfobject?
> >
> > Thanks
> > -- Jeff
> > _
> >
> >
> >
> >
> _
>
>
>
>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: Java Import -> CF
Okay, I have the terminology figured out a little better now, so lets see if
this helps.
The JSP page is including a package which apparently instantiates the
CommunityAccessLevel class on import. So, in ColdFusion, how can you import a
Java package?
I could just create a new object based upon this class, I am just not sure that
is the best answer.
Thanks
-- Jeff
Quoting Jeff Chastain <[EMAIL PROTECTED]>:
> Okay, maybe with some more context, you can help me out with this then. I
> have the following JSP code that I am attempting to convert to CF.
>
> <% page language="java" import="com.plumtree.remote.portlet.*" %>
> <%
> IPortletContext context =
> PortletContextFactory.createPortletContext(request, response);
> IPortletUser portletUser = context.getUser();
>
> if ( CommunityAccessLevel.Edit ==
> portletUser.getCurrentCommunityAccessLevel() ) {
>
>
> I have the CF code that handles the first two object declarations (via
> cfobject). Where I am running into problems is in the IF statement with the
> 'CommunityAccessLevel.Edit'. There is nothing in the page before this that
> declares a CommunityAccessLevel object. In reading the documentation for
> this API, CommunityAccessLevel is a class in the plumtree.remote.portlet
> namespace that has a static field called Edit.
>
> So, how would I translate this into CF?
>
> Thanks for your help.
> -- Jeff
>
> _
>
> From: Samuel Neff [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 17, 2004 8:13 AM
> To: CF-Talk
> Subject: RE: Java Import -> CF
>
>
> Import in Java doesn't instatiate anything, all it does is make a reference
> used by the compiler to use shorthand access to packages so you don't have
> to write out the whole package name every time you reference a class in that
> package.
>
> The closest equivalent in CF would be:
>
>
>
>
> Sam
>
> --
> Blog: http://www.rewindlife.com
> Chart: http://www.blinex.com/products/charting
> --
>
> -Original Message-
> From: Jeff Chastain [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 17, 2004 8:45 AM
> To: CF-Talk
> Subject: Java Import -> CF
>
> When you see the following line in a JSP file ...
> <% page language="java" import="com.plumtree.remote.portlet.*" %>
> ... is there a way to duplicate this functionality in CFMX? Is it possible
> it import an entire library like this rather than instantiating every class
> individually with cfobject?
>
> Thanks
> -- Jeff
> _
>
>
>
>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
RE: Java Import -> CF
Okay, maybe with some more context, you can help me out with this then. I
have the following JSP code that I am attempting to convert to CF.
<% page language="java" import="com.plumtree.remote.portlet.*" %>
<%
IPortletContext context =
PortletContextFactory.createPortletContext(request, response);
IPortletUser portletUser = context.getUser();
if ( CommunityAccessLevel.Edit ==
portletUser.getCurrentCommunityAccessLevel() ) {
I have the CF code that handles the first two object declarations (via
cfobject). Where I am running into problems is in the IF statement with the
'CommunityAccessLevel.Edit'. There is nothing in the page before this that
declares a CommunityAccessLevel object. In reading the documentation for
this API, CommunityAccessLevel is a class in the plumtree.remote.portlet
namespace that has a static field called Edit.
So, how would I translate this into CF?
Thanks for your help.
-- Jeff
_
From: Samuel Neff [mailto:[EMAIL PROTECTED]
Sent: Friday, September 17, 2004 8:13 AM
To: CF-Talk
Subject: RE: Java Import -> CF
Import in Java doesn't instatiate anything, all it does is make a reference
used by the compiler to use shorthand access to packages so you don't have
to write out the whole package name every time you reference a class in that
package.
The closest equivalent in CF would be:
Sam
--
Blog: http://www.rewindlife.com
Chart: http://www.blinex.com/products/charting
--
-Original Message-
From: Jeff Chastain [mailto:[EMAIL PROTECTED]
Sent: Friday, September 17, 2004 8:45 AM
To: CF-Talk
Subject: Java Import -> CF
When you see the following line in a JSP file ...
<% page language="java" import="com.plumtree.remote.portlet.*" %>
... is there a way to duplicate this functionality in CFMX? Is it possible
it import an entire library like this rather than instantiating every class
individually with cfobject?
Thanks
-- Jeff
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Java Import -> CF
When you see the following line in a JSP file ... <% page language="java" import="com.plumtree.remote.portlet.*" %> ... is there a way to duplicate this functionality in CFMX? Is it possible it import an entire library like this rather than instantiating every class individually with cfobject? Thanks -- Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX & Java API
Okay, ignore this whole thread ... I have it figured out. Thanks -- Jeff _ From: Jeff Chastain [mailto:[EMAIL PROTECTED] Sent: Thursday, September 16, 2004 7:54 PM To: CF-Talk Subject: RE: CFMX & Java API Okay, I have answered my first question. The first error message was being generated because I needed a second jar library included in the classpath. Once that was in place, the first line passed. Now, the second error that I was afraid would appear. ColdFusion does not know what the 'response' variable is, which is not all that unexpected. So, are there any Java types out there that could help with this aspect of translation? Thanks -- Jeff _ From: Jeff Chastain [mailto:[EMAIL PROTECTED] Sent: Thursday, September 16, 2004 7:20 PM To: CF-Talk Subject: OT: CFMX & Java API I have a Java based API from Plumtree Software. I know ColdFusion, but have very little Java knowledge. I have to utilize this piece of software and its API. So, I am still trying to make this API work with ColdFusion. Plumtree won't offer any support as they don't support ColdFusion. So, here I am as a last resort for help. I have some JSP examples that are provided by Plumtree that I am trying to duplicate to just get started. In these JSP examples, after all of the library import calls is the following line of code ... IPortletContext context = PortletContextFactory.createPortletContext(request,response); So, I assume I need to create a new object based upon the PortletContextFactory class (it is a class in a jar which I have put in the CFMX admin class path and then restarted) and then execute the createPortletContext method of that object as follows? class="com.plumtree.remote.portlet.PortletContextFactory" name="oPortletContextFactory"> oPortletContextFactory.createPortletContext(request,response)> First off, this throws an exception on the Instantiation Exception: An exception occurred when instantiating a java object. The cause of this exception was that: com/plumtree/openfoundation/web/IXPRequest." I have checked the class path to the PortletContextFactory class and that is correct. So, what else could I be missing? Second, in the second line, what is the request and response parameters being passed? Is this a Java thing and if so, how is this handled within CF? I am really lost here and my Java knowledge is so limited that I may really be missing something very simple here. Anybody have any suggestions? Thanks -- Jeff _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX & Java API
Okay, I have answered my first question. The first error message was being generated because I needed a second jar library included in the classpath. Once that was in place, the first line passed. Now, the second error that I was afraid would appear. ColdFusion does not know what the 'response' variable is, which is not all that unexpected. So, are there any Java types out there that could help with this aspect of translation? Thanks -- Jeff _ From: Jeff Chastain [mailto:[EMAIL PROTECTED] Sent: Thursday, September 16, 2004 7:20 PM To: CF-Talk Subject: OT: CFMX & Java API I have a Java based API from Plumtree Software. I know ColdFusion, but have very little Java knowledge. I have to utilize this piece of software and its API. So, I am still trying to make this API work with ColdFusion. Plumtree won't offer any support as they don't support ColdFusion. So, here I am as a last resort for help. I have some JSP examples that are provided by Plumtree that I am trying to duplicate to just get started. In these JSP examples, after all of the library import calls is the following line of code ... IPortletContext context = PortletContextFactory.createPortletContext(request,response); So, I assume I need to create a new object based upon the PortletContextFactory class (it is a class in a jar which I have put in the CFMX admin class path and then restarted) and then execute the createPortletContext method of that object as follows? class="com.plumtree.remote.portlet.PortletContextFactory" name="oPortletContextFactory"> oPortletContextFactory.createPortletContext(request,response)> First off, this throws an exception on the Instantiation Exception: An exception occurred when instantiating a java object. The cause of this exception was that: com/plumtree/openfoundation/web/IXPRequest." I have checked the class path to the PortletContextFactory class and that is correct. So, what else could I be missing? Second, in the second line, what is the request and response parameters being passed? Is this a Java thing and if so, how is this handled within CF? I am really lost here and my Java knowledge is so limited that I may really be missing something very simple here. Anybody have any suggestions? Thanks -- Jeff _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: CFMX & Java API
I have a Java based API from Plumtree Software. I know ColdFusion, but have very little Java knowledge. I have to utilize this piece of software and its API. So, I am still trying to make this API work with ColdFusion. Plumtree won't offer any support as they don't support ColdFusion. So, here I am as a last resort for help. I have some JSP examples that are provided by Plumtree that I am trying to duplicate to just get started. In these JSP examples, after all of the library import calls is the following line of code ... IPortletContext context = PortletContextFactory.createPortletContext(request,response); So, I assume I need to create a new object based upon the PortletContextFactory class (it is a class in a jar which I have put in the CFMX admin class path and then restarted) and then execute the createPortletContext method of that object as follows? class="com.plumtree.remote.portlet.PortletContextFactory" name="oPortletContextFactory"> oPortletContextFactory.createPortletContext(request,response)> First off, this throws an exception on the Instantiation Exception: An exception occurred when instantiating a java object. The cause of this exception was that: com/plumtree/openfoundation/web/IXPRequest." I have checked the class path to the PortletContextFactory class and that is correct. So, what else could I be missing? Second, in the second line, what is the request and response parameters being passed? Is this a Java thing and if so, how is this handled within CF? I am really lost here and my Java knowledge is so limited that I may really be missing something very simple here. Anybody have any suggestions? Thanks -- Jeff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SQL, count
Ack, id1 and id2 was screwing me up. This works. SELECT a.id2, a.name, ( SELECT COUNT(b.id1) FROM tablename b WHERE a.id2 = b.id1 ) as idCount FROM tablename a ORDER BY a.id2 On 9/16/2004 4:44 PM, Jeff Langevin wrote: > Woops... I had a typo I think. The where clause should have been... > > WHERE b.id1 = a.id1 > > On 9/16/2004 4:40 PM, Jeff Langevin wrote: > > > I think this would do it, though I didn't test it. > > > > SELECT a.id2, > > a.name, > > ( > > SELECT COUNT(b.id) > > FROM tablename b > > WHERE b.id1 = a.id2 > > ) as idCount > > FROM tablename a > > ORDER BY a.id2 > > > > HTH. > > > > --Jeff > > > > On 9/16/2004 12:47 PM, Andy J wrote: > > > > > I've got a SQL query which for love or money i cant seem to get my > head > > > around. > > > The table: > > > > > > id2 name id1 > > > -- > > > 1 andy 181 > > > 2 bob 1 > > > 3 Jim 2 > > > 4 helen 1 > > > > > > To explain what you are looking at a user with the ID 181 invited > "Andy" > > > Andy with the ID 1 invited bob and helen > > > And Bob with the ID 2 invited jim. > > > > > > Hopefully you can see the setup. > > > > > > What i basically need to do is get a list of ID2 and a count of the > > > people ID1 invited. > > > > > > Cheers > > > > > > Andy > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
