RE: PDF Conversion Tools Question
Other solution: I have scripted Word (through cfobject), to print to a postscript file, that is then converted to pdf. This solution allows me to use inputs ranging from doc, rtf, html and output doc, rtf, html, ps and pdf. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Re[6]: migrate data stored by cf 4.5 to cfmx (unicode problem?)
> ach to be honest I'm just want it to pump out the data in whatever the > default is - there's a lot of data but it's not an enormous > application, and the content is all straight english text. its not likely that its "all straight english text" if you're getting ? & [] in your text. you've probably got smart quotes & other word doc stuff, etc. mixed in there (cut & paste) or even other langauge encodings. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Struct Insert overwrite
> Using: > foo = #StructInsert(customer, "first_name", > "#Trim(form.first_name)#", allowoverwrite)# > > Error. > > Tried: > > foo = #StructInsert(customer, "first_name", > "#Trim(form.first_name)#", allowoverwrite="true")# > > Error. > > What is the correct way to do this, my book isn't > very clear on this piece. Thanks While you've figured out the correct syntax for StructInsert, I think it's worth noting that you could just ditch it altogether and get the same effect: Personally, I find StructInsert and StructUpdate to be pretty useless, especially if I want to conditionally insert or overwrite as you do in the above case. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFFILE & Firewall
> What's strange is that we can access the database, which > is also behind the firewall, just fine. Any thoughts on > why cffile would not be able to access a machine behind > the same firewall? The CF Services are also running with > admin accounts, it's just the cffile tag. It may be the case that you're accessing the database directly via TCP/IP, rather than through Windows Networking over TCP/IP. That's typically the way you connect to most database servers. Your network administrator should be able to provide more guidance for you on this topic, I think. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re[6]: migrate data stored by cf 4.5 to cfmx (unicode problem?)
ach to be honest I'm just want it to pump out the data in whatever the default is - there's a lot of data but it's not an enormous application, and the content is all straight english text. Friday, January 24, 2003, 5:29:16 PM, you wrote: >> That's what's bothering me Paul - can I no longer just output the data >> from my database reliably without forcing these directives? PH> it, as usual, depends on what specifically you're doing. what encoding do PH> you want to use? what encoding is your cf box's jvm? want i18n? PH> ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Re[4]: migrate data stored by cf 4.5 to cfmx (unicode problem?)
> That's what's bothering me Paul - can I no longer just output the data > from my database reliably without forcing these directives? it, as usual, depends on what specifically you're doing. what encoding do you want to use? what encoding is your cf box's jvm? want i18n? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Studio 5 development mappings problem
> I have W2K Pro running IIS 5 with virtual directories > as follows: > mydir mapped to c:\inetpub\wwwroot\mydir > mydir2 mapped to c:\inetpub\wwwroot\mydir2 > > I can browse the contents of both these directories with > the URLs: > http://127.0.0.1/mydir/ > http://127.0.0.1/mydir2/ > > I've set up two development mappings in Studio 5: > Studio and server path: c:\intepub\wwwroot\dir > Browser path: http://127.0.0.1/mydir/ > > Studio and server path: c:\inetpub\wwwroot\dir2 > Browser path: http://127.0.0.1/mydir2/ While you've already found a solution to your problem, I thought it might be worth noting that you can simply create one mapping to your web server's root directory, rather than creating mappings to each subdirectory. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX problem: undeleteable datasource?
Before I attempt to answer this, I'd like to state that I have very little experience with CFMX on Linux, so I'm just guessing with this. > Following the application of the CFMX Pro upgrade, we found > that the new JDBC-equivalent "goober" is listing in the CF > Administrator as having a JDBC driver type of "ODBC socket". > Rather curious, since "ODBC socket" isn't one of the JDBC > drivers that comes with CFMX-Linux Pro (you only get SQL > Server and MySQL). I suspect this is due to the CFML code within the Administrator used to migrate settings from CF 5 to CFMX - it's probably the same for all platforms, and doesn't take into consideration the fact that CFMX on Linux doesn't have the ODBC Socket stuff. > An exception occurred when invoking an external process. > The cause of this exception was that: java.io.IOException: > \opt/coldfusionmx/db\slserver52\admin\swcla.exe: not found. This code is attempting to invoke the Sequelink driver, which provides the ODBC Socket service. Not that this information is especially helpful, but it's kind of interesting I guess. You can see it's designed for Windows, based on the slashes in the file path after the "db" directory. > We also tried to delete the "goober" datasource by deleting > its XML declaration in > .../servers/default/SERVER-INF/jrun-resources.xml, but > regardless of whether we restarted the CFMX server or even > rebooted the whole machine, this change didn't seem to affect > the continued listing of "goober" in the Administrator, > Datasources page. We tried to figure out (by searching the > system and searching JRun and JDBC documentation) where else > within the Linux filesystem the JDBC datasources are defined > or listed (i.e., where does the CF Administrator, > Datasources page get its listing of datasources from?), but > it's a mystery to us. I think you'll also have to edit the file /cfusionmx/lib/neo-query.xml. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF & Database Options
> I cannot find a reference on this for SQL7. All read > only references I see refer to read-only-ing the > database with no reference to how a database could > be read-only for one login and not read-only for > another login. > > A reference please? For your read-only login, assign the db_datareader role to the login, and nothing else. For your writeable login, assign db_datareader and db_datawriter. If the read-only login also needs to run specific stored procedures, you'll need to grant permissions for those as well, I think. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: re. CFLDAP Binding
On Thursday, Jan 23, 2003, at 08:31 US/Pacific, Jonathan Lane wrote: > Thanks for your reply Sean. I'm still getting the "Inappropriate > authentication" error. Is there anything that needs to be configured > on the server for this to work? You may need to know more about the LDAP schema and change the query to match. Talk to you LDAP server administrator about it. We did nothing special to enable this for our setup... Sean A Corfield -- http://www.corfield.org/blog/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re[4]: migrate data stored by cf 4.5 to cfmx (unicode problem?)
PH> good practice for cfprocessingdirective on each page. setencoding, cfcontent PH> can just go into the application.cfm That's what's bothering me Paul - can I no longer just output the data from my database reliably without forcing these directives? Friday, January 24, 2003, 4:40:52 PM, you wrote: >>thanks for that. It's not going to be fun re-writing my scripts to >>scrape all this data off a cfhttp call though PH> well you might try cf4.5 to dump out text files & use native db tools to PH> import these. >>incidentally will I need to cfprocessingdirective, setencoding, etc PH> good practice for cfprocessingdirective on each page. setencoding, cfcontent PH> can just go into the application.cfm PH> ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Back/Next Forms
On Thursday, Jan 23, 2003, at 07:40 US/Pacific, Thane Sherrington wrote: > I'm building a multipaged form with back and next buttons. All the > form > fields are checkboxes. I want the boxes to remember what is checked > when I > go back and forth between pages. Do I create a list of hidden form > fields > carrying the values already submitted, or do I use session variables, > or is > there a better way that I'm not seeing? Depending on what you're really trying to achieve, this could be a very good candidate for a Flash UI. The Flash movie lets you easily have multi-page forms with back/next buttons and can store all the data locally until you are ready to submit it to the server. You could even have the Flash movie store partially completed forms locally so that users can fill them out page by page over time. Sean A Corfield -- http://www.corfield.org/blog/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: jrun.exe killing IIS service
I found out from Debbie today that updater 2 fixes this problem. Christian On Thursday, January 23, 2003, at 10:32 AM, Frank Mamone wrote: > I have a problem with both my production servers where jrun.exe runs > the cpu > at 100% and kills the IIS service. > > I read from the Web Forums that there are new drivers that fix this. > MM, can > I get these somewhere. It is rather urgent and apparently a known bug. > Thanks > > http://webforums.macromedia.com/coldfusion/ > messageview.cfm?catid=143&threadi > d=383059 > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Re[2]: migrate data stored by cf 4.5 to cfmx (unicode problem?)
>thanks for that. It's not going to be fun re-writing my scripts to >scrape all this data off a cfhttp call though well you might try cf4.5 to dump out text files & use native db tools to import these. >incidentally will I need to cfprocessingdirective, setencoding, etc good practice for cfprocessingdirective on each page. setencoding, cfcontent can just go into the application.cfm ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re[2]: migrate data stored by cf 4.5 to cfmx (unicode problem?)
Hi Paul, thanks for that. It's not going to be fun re-writing my scripts to scrape all this data off a cfhttp call though incidentally will I need to cfprocessingdirective, setencoding, etc on every page in my cfmx application from now on? I saw something the other day mentioning that these couldn't be called just from application.cfm or similar... At the end of the day all I want to do is get the data into PostGreSQL and have it display properly hehe. What a nightmare. cheers, Toby Friday, January 24, 2003, 4:20:15 PM, you wrote: >>Has anyone got any suggestions? PH> setup a template on the cf4.5 box that dumps out your data, that should get PH> the mangled unicode out ok. cfhttp from the mx box to that template, that PH> should get it into real unicode format. make sure the mx dsn has unicode PH> option turned on & you've added cfprocessingdirective, setencoding, etc. to PH> that cfhttp page. PH> ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: migrate data stored by cf 4.5 to cfmx (unicode problem?)
>Has anyone got any suggestions? setup a template on the cf4.5 box that dumps out your data, that should get the mangled unicode out ok. cfhttp from the mx box to that template, that should get it into real unicode format. make sure the mx dsn has unicode option turned on & you've added cfprocessingdirective, setencoding, etc. to that cfhttp page. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
migrate data stored by cf 4.5 to cfmx (unicode problem?)
Hi all, I've been searching through the online forums and docs but can't find anything that actually tells me how to do this. I have a database (msaccess) full of data stored by a cf application being run under 4.5 for most of it's life then cf 5.0 for a while. When I transport the data from the access DB to my new postgres DB on a linux server I use a CF script, as the table structure has changed - that script is run on the windows machine. All runs fine, but when I go to view the application from the new installation it's full of junk characters (square symbols and questrion marks). I'm assuming this is something to do with the fact that earlier versions of cf screwed up the unicode encoding and cfmx apparently has gotten it right - but I can't find anything on a method for fixing this! Has anyone got any suggestions? cheers, Toby --- Life is poetry - write it in your own words. --- Toby Tremayne Technical Team Lead Code Poet and Zen Master of the Heavy Sleep Toll Solutions 154 Moray St Sth Melbourne VIC 3205 +61 3 9697 2317 0416 048 090 ICQ: 13107913 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfinsert or reg sql?
that's what I was kinda figuring I know the cfform is a disaster so I figured these might be as well thanks dave - Original Message - From: "Matthew Walker" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, January 23, 2003 10:42 PM Subject: RE: cfinsert or reg sql? > Personally, I don't use cfinsert, cfupdate, or any of the cfform tags. > Sure they're quick and convenient, but they're not very flexible. As > soon as you want to do something even slightly beyond the design (like > set a DateUpdated field to now() for example) you're faced with either > rewriting the code or a nasty kludge ( > ). > > > what are your thoughts on using cfinsert over using a sql > > insert function? (access/ms sql) > > Pro's and cons ? > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Studio 5 development mappings problem-Followup
It turns out that putting slashes at the end of all three values worked. Having no slashes at the end of the values results in the problem described below. Thanks again for the suggestion. Stephen > Thanks. That sounds logical and I'll try it. > > Stephen > > > Stephen, > > > > It is a matter of consistency among each of the three values > > needed for a mapping. The URL used for "Browser Path" ends in a > > slash, yet the other two values, "Studio Path" and "Server Path", > > do not. Either add a slash to the end of these two values or > > remove the slash from the end of the "Browser Path" value. > > > > Paul Kenney > > [EMAIL PROTECTED] > > > > > > > -Original Message- > > > From: Stephen Hait [mailto:[EMAIL PROTECTED]] > > > Sent: Thursday, January 23, 2003 11:17 AM > > > To: CF-Talk > > > Subject: Studio 5 development mappings problem > > > > > > > > > Has anyone encountered this problem and, if so, did you find a > > > resolution? > > > > > > I have W2K Pro running IIS 5 with virtual directories as > > > follows: mydir mapped to c:\inetpub\wwwroot\mydir mydir2 mapped > > > to c:\inetpub\wwwroot\mydir2 > > > > > > I can browse the contents of both these directories with the > > > URLs: http://127.0.0.1/mydir/ http://127.0.0.1/mydir2/ > > > > > > I've set up two development mappings in Studio 5: > > > Studio and server path: c:\intepub\wwwroot\dir > > > Browser path: http://127.0.0.1/mydir/ > > > > > > Studio and server path: c:\inetpub\wwwroot\dir2 > > > Browser path: http://127.0.0.1/mydir2/ > > > > > > Within Studio, I can "browse" mydir no problem but when I try to > > > browse files in mydir2 the URL that is trying to be resolved > > > ends up as http://127.0.0.1/mydir/2/ > > > > > > The same thing will occur with virtual and physical directories > > > named mydir and mydirold; mydirold resolves to > > > http://127.0.0.1/mydir/old/ > > > > > > Any light appreciated. > > > > > > Stephen > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX problem: undeleteable datasource?
Howdy -- We've been preparing to upgrade our CF5-Linux production platform to CFMX-Linux, and on our test server where we've been testing the upgrade process, we've run into a curious snag: Our test CF5-Linux platform included an ODBC datasource -- call it "goober" -- which was using the Merant Text Driver. Following the application of the CFMX Pro upgrade, we found that the new JDBC-equivalent "goober" is listing in the CF Administrator as having a JDBC driver type of "ODBC socket". Rather curious, since "ODBC socket" isn't one of the JDBC drivers that comes with CFMX-Linux Pro (you only get SQL Server and MySQL). (Also, not surprisingly, an attempt to verify a connection to "goober" is failing, but we don't care about that at this point.) Furthermore, attempts to delete the "goober" datasource simply result in the following error: - An exception occurred when invoking an external process. The cause of this exception was that: java.io.IOException: \opt/coldfusionmx/db\slserver52\admin\swcla.exe: not found. The Error Occurred in /home/httpd/html/CFIDE/administrator/datasources/_sl52del.cfm: line 10 Called from /home/httpd/html/CFIDE/administrator/datasources/odbcsocket.cfm: line 16 Called from /home/httpd/html/CFIDE/administrator/datasources/odbcsocket.cfm: line 760 Called from /home/httpd/html/CFIDE/administrator/datasources/_sl52del.cfm: line 10 Called from /home/httpd/html/CFIDE/administrator/datasources/odbcsocket.cfm: line 16 Called from /home/httpd/html/CFIDE/administrator/datasources/odbcsocket.cfm: line 760 - We also tried to delete the "goober" datasource by deleting its XML declaration in .../servers/default/SERVER-INF/jrun-resources.xml, but regardless of whether we restarted the CFMX server or even rebooted the whole machine, this change didn't seem to affect the continued listing of "goober" in the Administrator, Datasources page. We tried to figure out (by searching the system and searching JRun and JDBC documentation) where else within the Linux filesystem the JDBC datasources are defined or listed (i.e., where does the CF Administrator, Datasources page get its listing of datasources from?), but it's a mystery to us. Anybody have any ideas about how we can get rid of "goober"? It'd be kinda silly to have to pay MM the $500 incident support fee to get a fix for their own upgrade-process bug. TIA... -- Larry Afrin Medical University of South Carolina [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfinsert or reg sql?
Personally, I don't use cfinsert, cfupdate, or any of the cfform tags. Sure they're quick and convenient, but they're not very flexible. As soon as you want to do something even slightly beyond the design (like set a DateUpdated field to now() for example) you're faced with either rewriting the code or a nasty kludge ( ). > what are your thoughts on using cfinsert over using a sql > insert function? (access/ms sql) > Pro's and cons ? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfinsert or reg sql?
what are your thoughts on using cfinsert over using a sql insert function? (access/ms sql) Pro's and cons ? Dave ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Studio 5 development mappings problem
Thanks. That sounds logical and I'll try it. Stephen > Stephen, > > It is a matter of consistency among each of the three values needed > for a mapping. The URL used for "Browser Path" ends in a slash, > yet the other two values, "Studio Path" and "Server Path", do not. > Either add a slash to the end of these two values or remove the > slash from the end of the "Browser Path" value. > > Paul Kenney > [EMAIL PROTECTED] > > > > -Original Message- > > From: Stephen Hait [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, January 23, 2003 11:17 AM > > To: CF-Talk > > Subject: Studio 5 development mappings problem > > > > > > Has anyone encountered this problem and, if so, did you find a > > resolution? > > > > I have W2K Pro running IIS 5 with virtual directories as follows: > > mydir mapped to c:\inetpub\wwwroot\mydir mydir2 mapped to > > c:\inetpub\wwwroot\mydir2 > > > > I can browse the contents of both these directories with the URLs: > > http://127.0.0.1/mydir/ http://127.0.0.1/mydir2/ > > > > I've set up two development mappings in Studio 5: > > Studio and server path: c:\intepub\wwwroot\dir > > Browser path: http://127.0.0.1/mydir/ > > > > Studio and server path: c:\inetpub\wwwroot\dir2 > > Browser path: http://127.0.0.1/mydir2/ > > > > Within Studio, I can "browse" mydir no problem but when I try to > > browse files in mydir2 the URL that is trying to be resolved ends > > up as http://127.0.0.1/mydir/2/ > > > > The same thing will occur with virtual and physical directories > > named mydir and mydirold; mydirold resolves to > > http://127.0.0.1/mydir/old/ > > > > Any light appreciated. > > > > Stephen > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX for JRun install assistance request
Dick, He's right. JRun SP1 does indeed have problems with J2EE CFMX...but it's the phase 1 version. (See this for more info on the different versions: http://www.macromedia.com/support/coldfusion/j2ee/) I ran into this issue about 2 weeks ago when installing on a Windows box. I was using the CFMX for Jrun4 integrated installer version which I downloaded from the MM trial page. After installing I had major issues with CFMX. I read the release notes, made the changes, and all was well again. After reading Sean Corfield's recent posts regarding the manual install of CFMX for JRun (http://www.corfield.org/blog/2003_01_01_archive.html#86809434) I decided to give that ago. I downloaded the phase 2 (archive installer) version from MM's site, unpacked as Sean described, stuck it in the server directory, fired up the JRun server instance and away it went. Not a single problem. I'm not sure if MM has updated the CFMX for JRun4 integrated installer that is available on the website or not. You may still have to make the changes outlined in the release notes to get it running. Maybe someone from MM can comment on this... I should also add, since you're on the Mac, you're using the archive installer version, thus the lack of issues. Regards, chris PS. Sean's posts are awesome for getting this up and running smoothly. Definitely read 'em if you're heading down this road... -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 6:35 PM To: CF-Talk Subject: Re: CFMX for JRun install assistance request U... that's interesting! I am running CFMX J2EE with JRun for Mac OS X. I understand that this (Mac OS X) version of JRun includes all the Service Packs. I did not do the steps discussed in the notes, and am having no problems with starting CFMX* CFMX web services work fine. I will check out JSP web services & see if they work. On checking the files, I see that some of the items mentioned (but not all) have already been performed in the default install curious i guess JRun mac OS X is different than on other platforms. * I run multiple CFMX j2EE server instances, clustering, etc., connected to Apache web server. Both JRun and CFMX J2EE startup automatically at boot Dick On Thursday, January 23, 2003, at 05:50 PM, Chris Norloff wrote: > Hi, Dale, > > JRun4 SP1 kills ColdFusion. Check the fine print at the bottom of > http://www.macromedia.com/support/jrun/releasenotes/4/ > releasenotes_4_sp1a.html > > Not positive this is it, but looks like a likely candidate. > > Chris Norloff > > > -- Original Message -- > From: "Dale Coyner" <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > date: Thu, 23 Jan 2003 17:44:42 -0500 > >> Folks, >> >> I purchased a copy of CFMX for JRun after having a successful >> experience >> with the development version on an older server. We are now creating >> a >> prototype production server. I've run into a snag during the install >> and I'm not sure what the problem is. JRun4 and the JRun4 update both >> installed fine. Restarted, confirmed operation. >> >> CMFX for JRun installation reportedly went fine. One thing I did >> different from default install was to change the context root to "ec" >> from "cfmx." (I assume that should have no impact else I would not be >> given the option to change it?) Restarted. Both Admin and Default >> servers are running as expected in the services control panel. >> >> However, now when I try to access JRun's admin page, I get an internal >> server error. Looking at JRun's logs, I see the following entries in >> admin-event.log for each failed attempt to access the admin server's >> login page: >> >> "error There is no web application configured to service your request" >> "user NoWebappServlet: init". >> >> Attempting to access CFMX Administrator following the path I set >> (http://000.000.000.000/ec/cfide/administrator/index.cfm) yields a >> "page >> not found" error. >> >> Anyone else run into that or know where I may have gone wrong? >> >> Thanks, >> >> Dale Coyner >> Communicast, Inc. >> >> >> > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Cold Fusion and Telnet
Take a look at IE's screensurfer product. Very nice emulation software that can easilly be integrated with CF (via it's CFX interface). ~Simon Simon Horwith Macromedia Certified Instructor Certified Advanced ColdFusion MX Developer Certified Flash MX Developer CFDJList - List Administrator Fig Leaf Software 1400 16th St NW, # 220 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 17:47 To: CF-Talk Subject: Cold Fusion and Telnet Here's an interesting one and conceivable not possible, but I thought I would ask all the wise ones here on the CF-Talk list before I tell my client NO!. Has anybody ever done anything connecting Cold Fusion and Telnet? Basically the client wants to create a web-based telnet session to a back end application on a HP L3000 Unix server so that every computer in the organization doesn't have to have the customized telnet client installed and maintained/upgraded on them. Is this even possible? If not, any other suggestions on how such a system may be created? Anybody know of any tools/custom tags/CFX/applications or something else that may do this already? Thanks Ian Skinner Web Developer BloodSource Sacramento CA ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX for JRun install assistance request
U... that's interesting! I am running CFMX J2EE with JRun for Mac OS X. I understand that this (Mac OS X) version of JRun includes all the Service Packs. I did not do the steps discussed in the notes, and am having no problems with starting CFMX* CFMX web services work fine. I will check out JSP web services & see if they work. On checking the files, I see that some of the items mentioned (but not all) have already been performed in the default install curious i guess JRun mac OS X is different than on other platforms. * I run multiple CFMX j2EE server instances, clustering, etc., connected to Apache web server. Both JRun and CFMX J2EE startup automatically at boot Dick On Thursday, January 23, 2003, at 05:50 PM, Chris Norloff wrote: > Hi, Dale, > > JRun4 SP1 kills ColdFusion. Check the fine print at the bottom of > http://www.macromedia.com/support/jrun/releasenotes/4/ > releasenotes_4_sp1a.html > > Not positive this is it, but looks like a likely candidate. > > Chris Norloff > > > -- Original Message -- > From: "Dale Coyner" <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > date: Thu, 23 Jan 2003 17:44:42 -0500 > >> Folks, >> >> I purchased a copy of CFMX for JRun after having a successful >> experience >> with the development version on an older server. We are now creating >> a >> prototype production server. I've run into a snag during the install >> and I'm not sure what the problem is. JRun4 and the JRun4 update both >> installed fine. Restarted, confirmed operation. >> >> CMFX for JRun installation reportedly went fine. One thing I did >> different from default install was to change the context root to "ec" >> from "cfmx." (I assume that should have no impact else I would not be >> given the option to change it?) Restarted. Both Admin and Default >> servers are running as expected in the services control panel. >> >> However, now when I try to access JRun's admin page, I get an internal >> server error. Looking at JRun's logs, I see the following entries in >> admin-event.log for each failed attempt to access the admin server's >> login page: >> >> "error There is no web application configured to service your request" >> "user NoWebappServlet: init". >> >> Attempting to access CFMX Administrator following the path I set >> (http://000.000.000.000/ec/cfide/administrator/index.cfm) yields a >> "page >> not found" error. >> >> Anyone else run into that or know where I may have gone wrong? >> >> Thanks, >> >> Dale Coyner >> Communicast, Inc. >> >> >> > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF & Database Options
At 08:11 PM 1/23/03 +0100, you wrote: > >>- you could use multiple logins to the database, a readonly login and a > normal > >>one for instance > > > > Tell me more. > >Define more as 1 login. Use the readonly login from all the public >templates, and the one with full access from an administrative interface. I cannot find a reference on this for SQL7. All read only references I see refer to read-only-ing the database with no reference to how a database could be read-only for one login and not read-only for another login. A reference please? best, paul ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Studio 5 development mappings problem
Stephen, It is a matter of consistency among each of the three values needed for a mapping. The URL used for "Browser Path" ends in a slash, yet the other two values, "Studio Path" and "Server Path", do not. Either add a slash to the end of these two values or remove the slash from the end of the "Browser Path" value. Paul Kenney [EMAIL PROTECTED] > -Original Message- > From: Stephen Hait [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 23, 2003 11:17 AM > To: CF-Talk > Subject: Studio 5 development mappings problem > > > Has anyone encountered this problem and, if so, did you find a > resolution? > > I have W2K Pro running IIS 5 with virtual directories as follows: > mydir mapped to c:\inetpub\wwwroot\mydir > mydir2 mapped to c:\inetpub\wwwroot\mydir2 > > I can browse the contents of both these directories with the URLs: > http://127.0.0.1/mydir/ > http://127.0.0.1/mydir2/ > > I've set up two development mappings in Studio 5: > Studio and server path: c:\intepub\wwwroot\dir > Browser path: http://127.0.0.1/mydir/ > > Studio and server path: c:\inetpub\wwwroot\dir2 > Browser path: http://127.0.0.1/mydir2/ > > Within Studio, I can "browse" mydir no problem but when I try to > browse files in mydir2 the URL that is trying to be resolved ends > up as http://127.0.0.1/mydir/2/ > > The same thing will occur with virtual and physical directories > named mydir and mydirold; mydirold resolves to > http://127.0.0.1/mydir/old/ > > Any light appreciated. > > Stephen > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: structkeyexists(this,"files")_is_true_and_isdefined("this.files")_is__ false
god damnit > Not relevant but BTW I had some weird things start > happening when I > moved some code that used a structure called this to CFMX, > since it's a > scope name. >> -Original Message- >> From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] >> Sent: Friday, 24 January 2003 2:52 p.m. >> To: CF-Talk >> Subject: >> structkeyexists(this,"files")_is_true_and_isdefined("this >> .files")_is_ >> false >> >> >> I have a structure (this) which contains a key (files) >> which >> is a query. If >> I dup the structure, the files query shows in the dump. >> If I reference >> this["files"] everything works fine. If I reference >> this.files I get "error >> resolving parameter THIS.FILES" i.e. "it doesn't exist" >> although it >> obviously does exist. What am I missing? >> >> I'm using this code: >> >> >> >> >> So I know there isn't anything else in the middle >> screwing it >> up, it's just >> one syntax works and the other doesn't. >> >> CF 5 IIS 5 Win2K Server >> >> s. isaac dealey954-776-0046 >> >> new epoch http://www.turnkey.to >> >> lead architect, tapestry cms http://products.turnkey.to >> >> tapestry api is opensource http://www.turnkey.to/tapi >> >> certified advanced coldfusion 5 developer >> http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 >> >> > ~~ > ~~~| > Archives: > http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 > Subscription: http://www.houseoffusion.com/cf_lists/index. > cfm?method=subscribe&forumid=4 > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > Signup for the Fusion Authority news alert and keep up > with the latest news in ColdFusion and related topics. > http://www.fusionauthority.com/signup.cfm > Unsubscribe: http://www.houseoffusion.com/cf_lists/uns > ubscribe.cfm?user=633.558.4 s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX for JRun install assistance request
Hi, Dale, JRun4 SP1 kills ColdFusion. Check the fine print at the bottom of http://www.macromedia.com/support/jrun/releasenotes/4/releasenotes_4_sp1a.html Not positive this is it, but looks like a likely candidate. Chris Norloff -- Original Message -- From: "Dale Coyner" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] date: Thu, 23 Jan 2003 17:44:42 -0500 >Folks, > >I purchased a copy of CFMX for JRun after having a successful experience >with the development version on an older server. We are now creating a >prototype production server. I've run into a snag during the install >and I'm not sure what the problem is. JRun4 and the JRun4 update both >installed fine. Restarted, confirmed operation. > >CMFX for JRun installation reportedly went fine. One thing I did >different from default install was to change the context root to "ec" >from "cfmx." (I assume that should have no impact else I would not be >given the option to change it?) Restarted. Both Admin and Default >servers are running as expected in the services control panel. > >However, now when I try to access JRun's admin page, I get an internal >server error. Looking at JRun's logs, I see the following entries in >admin-event.log for each failed attempt to access the admin server's >login page: > >"error There is no web application configured to service your request" >"user NoWebappServlet: init". > >Attempting to access CFMX Administrator following the path I set >(http://000.000.000.000/ec/cfide/administrator/index.cfm) yields a "page >not found" error. > >Anyone else run into that or know where I may have gone wrong? > >Thanks, > >Dale Coyner >Communicast, Inc. > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
structkeyexists(this,"files")_is_true_and_isdefined("this.files")_is_ false
I have a structure (this) which contains a key (files) which is a query. If I dup the structure, the files query shows in the dump. If I reference this["files"] everything works fine. If I reference this.files I get "error resolving parameter THIS.FILES" i.e. "it doesn't exist" although it obviously does exist. What am I missing? I'm using this code: So I know there isn't anything else in the middle screwing it up, it's just one syntax works and the other doesn't. CF 5 IIS 5 Win2K Server s. isaac dealey954-776-0046 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX for JRun install assistance request
Also, unless you've connected to a web server, you will need to include the port (of the ec server instance) in the URL, e.g. 127.0.0.1:8101/cfusion if you have connected the server instance to a web server then 127.0.0.1/cfusion will get you to the connected server imstance You never include the server instance name (ec, in your case) in the URL HTH Dick On Thursday, January 23, 2003, at 04:52 PM, Dick Applebaum wrote: > On Thursday, January 23, 2003, at 02:44 PM, Dale Coyner wrote: > >> Attempting to access CFMX Administrator following the path I set >> (http://000.000.000.000/ec/cfide/administrator/index.cfm) yields a >> "page >> not found" error. >> >> > > is that really the IP address (you used) in the URL -- shouldn't it be > a valid IP, localhost or 127.0.0.1? > > dick > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: SBC sues for using frames
Prior Art perhaps? This one will probably float like a lead balloon. larry ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: this javascript works in asp but not cf?
I was just testing it on my machine which usually works fine, I must have something set wrong, lol I went to your link and by god it does work! right on! while putzing around I just went to yahoo and checked out their maps and I think I actually like them better (of course) I do a lot of realtor sites so the mapping comes in handy and works fine on my asp sites. I was just in the mood to put it in the coldfusion snippets at www.dwfaq.com I have seen a few people looking for something and got a hair up my ass to do it. But hey if it works then its good to go. Thanks for your time! Dave - Original Message - From: "charlie griefer" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, January 23, 2003 7:52 PM Subject: Re: this javascript works in asp but not cf? > Dave: > > I copied your script below and it runs fine for me > (http://charlie.griefer.com/map.cfm). > > Do you by any chance have a URL you can post so i can see the actual code in > action (or inaction, as the case may be)? > > thx, > Charlie > > Dave Lyons writes: > > > right, i know it shouldnt make a difference. > > it doesnt throw an error, just doest work > > > > when the link is clicked it should open up another browser window with the > > mapquest info > > on my asp pages it works fine when i run it in coldfusion it doesnt do > > anything > > no pop up nothing > > > > was just curious > > - Original Message - > > From: "charlie griefer" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Thursday, January 23, 2003 7:19 PM > > Subject: Re: this javascript works in asp but not cf? > > > > > >> Dave Lyons writes: > >> > >> > anyone have any idea why this wont work with cfmx? > >> > im not a java guru either > >> > >> One shouldn't have anything to do with the other. By the time this > >> javascript runs...CF or ASP (or whatever server side programming is > >> involved) has already done its thing and is no longer a part of the > >> equation. > >> > >> When you say it 'wont work with cfmx', can you elaborate a little? What > >> error are you getting? > >> > >> charlie > >> > >> > > >> > > >> > > >> > Untitled Document > >> > > >> > > >> > function map_MapQuest(country, address, city, state, zip) { > >> > window.open("http://www.mapquest.com/maps/map.adp?country="+ > > escape(country) +"&address="+ > >> > > >> > escape(address) +"&city="+ escape(city) +"&state="+ escape(state) > > +"&zipcode="+ escape(zip) > >> > > >> > > > +"&homesubmit.x=0&homesubmit.y=0","map_mapquestwin","width=720,height=400,to > > olbar=1,menubar= > >> > > >> > 1,status=1,resizable=1,location=0,directories=0,scrollbars=1"); > >> > } > >> > > >> > > >> > > >> > > >> > CLICK > >> > HERE FOR A MAP > >> > > >> > > >> > > >> > > >> > Dave > >> > > >> > > >> > > >> > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMX for JRun install assistance request
On Thursday, January 23, 2003, at 02:44 PM, Dale Coyner wrote: > Attempting to access CFMX Administrator following the path I set > (http://000.000.000.000/ec/cfide/administrator/index.cfm) yields a > "page > not found" error. > > is that really the IP address (you used) in the URL -- shouldn't it be a valid IP, localhost or 127.0.0.1? dick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: this javascript works in asp but not cf?
Dave: I copied your script below and it runs fine for me (http://charlie.griefer.com/map.cfm). Do you by any chance have a URL you can post so i can see the actual code in action (or inaction, as the case may be)? thx, Charlie Dave Lyons writes: > right, i know it shouldnt make a difference. > it doesnt throw an error, just doest work > > when the link is clicked it should open up another browser window with the > mapquest info > on my asp pages it works fine when i run it in coldfusion it doesnt do > anything > no pop up nothing > > was just curious > - Original Message - > From: "charlie griefer" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, January 23, 2003 7:19 PM > Subject: Re: this javascript works in asp but not cf? > > >> Dave Lyons writes: >> >> > anyone have any idea why this wont work with cfmx? >> > im not a java guru either >> >> One shouldn't have anything to do with the other. By the time this >> javascript runs...CF or ASP (or whatever server side programming is >> involved) has already done its thing and is no longer a part of the >> equation. >> >> When you say it 'wont work with cfmx', can you elaborate a little? What >> error are you getting? >> >> charlie >> >> > >> > >> > >> > Untitled Document >> > >> > >> > function map_MapQuest(country, address, city, state, zip) { >> > window.open("http://www.mapquest.com/maps/map.adp?country="+ > escape(country) +"&address="+ >> > >> > escape(address) +"&city="+ escape(city) +"&state="+ escape(state) > +"&zipcode="+ escape(zip) >> > >> > > +"&homesubmit.x=0&homesubmit.y=0","map_mapquestwin","width=720,height=400,to > olbar=1,menubar= >> > >> > 1,status=1,resizable=1,location=0,directories=0,scrollbars=1"); >> > } >> > >> > >> > >> > >> > CLICK >> > HERE FOR A MAP >> > >> > >> > >> > >> > Dave >> > >> > >> > >> > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: this javascript works in asp but not cf?
right, i know it shouldnt make a difference. it doesnt throw an error, just doest work when the link is clicked it should open up another browser window with the mapquest info on my asp pages it works fine when i run it in coldfusion it doesnt do anything no pop up nothing was just curious - Original Message - From: "charlie griefer" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, January 23, 2003 7:19 PM Subject: Re: this javascript works in asp but not cf? > Dave Lyons writes: > > > anyone have any idea why this wont work with cfmx? > > im not a java guru either > > One shouldn't have anything to do with the other. By the time this > javascript runs...CF or ASP (or whatever server side programming is > involved) has already done its thing and is no longer a part of the > equation. > > When you say it 'wont work with cfmx', can you elaborate a little? What > error are you getting? > > charlie > > > > > > > > > Untitled Document > > > > > > function map_MapQuest(country, address, city, state, zip) { > > window.open("http://www.mapquest.com/maps/map.adp?country="+ escape(country) +"&address="+ > > > > escape(address) +"&city="+ escape(city) +"&state="+ escape(state) +"&zipcode="+ escape(zip) > > > > +"&homesubmit.x=0&homesubmit.y=0","map_mapquestwin","width=720,height=400,to olbar=1,menubar= > > > > 1,status=1,resizable=1,location=0,directories=0,scrollbars=1"); > > } > > > > > > > > > > CLICK > > HERE FOR A MAP > > > > > > > > > > Dave > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
this javascript works in asp but not cf?
anyone have any idea why this wont work with cfmx? im not a java guru either Untitled Document function map_MapQuest(country, address, city, state, zip) { window.open("http://www.mapquest.com/maps/map.adp?country="+ escape(country) +"&address="+ escape(address) +"&city="+ escape(city) +"&state="+ escape(state) +"&zipcode="+ escape(zip) +"&homesubmit.x=0&homesubmit.y=0","map_mapquestwin","width=720,height=400,toolbar=1,menubar= 1,status=1,resizable=1,location=0,directories=0,scrollbars=1"); } CLICK HERE FOR A MAP Dave ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: this javascript works in asp but not cf?
Dave Lyons writes: > anyone have any idea why this wont work with cfmx? > im not a java guru either One shouldn't have anything to do with the other. By the time this javascript runs...CF or ASP (or whatever server side programming is involved) has already done its thing and is no longer a part of the equation. When you say it 'wont work with cfmx', can you elaborate a little? What error are you getting? charlie > > > > Untitled Document > > > function map_MapQuest(country, address, city, state, zip) { > window.open("http://www.mapquest.com/maps/map.adp?country="+ escape(country) >+"&address="+ > > escape(address) +"&city="+ escape(city) +"&state="+ escape(state) +"&zipcode="+ >escape(zip) > > >+"&homesubmit.x=0&homesubmit.y=0","map_mapquestwin","width=720,height=400,toolbar=1,menubar= > > > 1,status=1,resizable=1,location=0,directories=0,scrollbars=1"); > } > > > > > CLICK > HERE FOR A MAP > > > > > Dave > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFMX -- changes not updating
Do you have Trusted Cache turned on in the Admin? If you do, it wouldn't be checking for updates to the templates and would continue to run the old version. If not, you could also delete the .class file for that template. It would be located in cf_root\wwwroot\WEB-INF\cfclasses. Debbie -Original Message- From: Owens, Howard [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 6:47 PM To: CF-Talk Subject: CFMX -- changes not updating I'm loading my first application to our new CFMX server. Because of changes to CFLog, there was an error. I've corrected that error, but the error keeps reappearing when I load the page. Any reason for this? H. ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: PDF Conversion Tools Question
Zac, We are converting in real time - but we are converting large volume, and we simply use a cf script to update the corresponding record in the database with the file name when the file is complete. We are creating these for storage and not for immediate viewing. Kirk -Original Message- From: Zac Spitzer [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 2:51 PM To: CF-Talk Subject: Re: PDF Conversion Tools Question -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 cflist wrote: | We use AdLib for converting large amounts of uploaded resumes in all | sorts of file formats to PDF. And it works great. | | We were using ActivePDF, and it worked well at converting, but the | application always seemed to hang and spit out errors, and after a | few moths of back and forth with tech support - we dumped it for | AdLib. i just downloaded adlib..looks nice but it's not ready yet for realtime conversion from what i see in the forums... are u using adlib simply in batch mode or can u generate a html document pass it to adlib and return the file reasonably quickly??? z -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+MHHA1lRHdy8ASusRAlgfAKCCi6WLY7g8NEDYGkzoZmFvw9TAtACfQoNQ tvv7vYn8PHkvv60GbP9MFaQ= =zvBz -END PGP SIGNATURE- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX -- changes not updating
I'm loading my first application to our new CFMX server. Because of changes to CFLog, there was an error. I've corrected that error, but the error keeps reappearing when I load the page. Any reason for this? H. ~~ Howard Owens Internet Operations Coordinator InsideVC.com/Ventura County Star [EMAIL PROTECTED] AIM: GoCatGo1956 ~~ ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: MS Access - Replace a specific string value - SOLVED
I could not get your suggestion below to work in a "New Query Window" so here is the solution I used. This will get rid of the first instance of a comma in a field. Tmg is the table name and last_name is the field name. Update Query: First column: Left([last_name],InStr(1,[tmg].[last_name],",",1)-1) & Mid ([last_name],InStr(1,[tmg].[last_name],",",1)+1,999) Second column: expr: InStr(1,[tmg].[last_name],",",1) Second column criteria: <>0 Thanks, CC "charlie griefer" To: CF-Talk <[EMAIL PROTECTED]> Subject: Re: OT: MS Access - Replace a specific string value 01/23/03 02:29 PM Please respond to cf-talk Casey C Cook writes: > Hi all - > > I've run into something I cant quite put my finger on yet. Does anyone > know a function to find the first instance of a specific character in a > string and replace it with another string value. In my case I want to find > the first instance of a comma " , " and replace it with a blank " ". Im > doing this so when I export a file without a text delimiter it will not > break the field into two separate columns. replace(myString, ",", " ", "one") should do it. charlie ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Multiple Select Box (missing < in the code)
DOH! I had a typo in the code that's standard procedure for me. 10% of my time is spent hunting typographical errors anyway, here ya go selected#fname# #lname# - Original Message - From: "Ewok" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, January 23, 2003 5:46 PM Subject: Re: Multiple Select Box > > > > > select user_id > from tbl_projects > where proj_id = #val(form.project_id)# > > > > > > > > select fname, lname, user_id > from tbl_proj_users > order by lname > > > > > > > > > user_id, ",")> selected#fname# #lname# > > > > > Hope it helps, goodluck > > - Original Message - > From: "Michael Ross" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, January 23, 2003 1:59 PM > Subject: Multiple Select Box > > > > You know if you have a form that someone is editing data, and you can make > a select box have a record selected. How do you do it where you want a > multiple select box to have a lot of them selected? This is really killing > me. Any idea's would be great > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Cold Fusion and Telnet
> -Original Message- > From: Ian Skinner [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 23, 2003 5:47 PM > To: CF-Talk > Subject: Cold Fusion and Telnet > > > Here's an interesting one and conceivable not possible, but I > thought I would ask all the wise ones here on the CF-Talk > list before I tell my client NO!. Has anybody ever done > anything connecting Cold Fusion and Telnet? Basically the > client wants to create a web-based telnet session to a back > end application on a HP L3000 Unix server so that every > computer in the organization doesn't have to have the > customized telnet client installed and maintained/upgraded on them. > > Is this even possible? If not, any other suggestions on how > such a system may be created? Anybody know of any > tools/custom tags/CFX/applications or something else that may > do this already? There are several options... You could use something like ASPSock in conjunction with a lot of JavaScript (perhaps even code from my article on using a GIF as a data-pipe) to do a decent version. ASPSock gives you (via a COM object) simple access to the winsock API (this is a server-side, not a client-side component). The GIF as a datapipe would let you create the dialog (back and forth conversation) without constantly refreshing the page. ASPSock: http://www.serverobjects.com/products.htm#aspsock GIF as a Data Pipe: http://www.depressedpress.com/DepressedPress/Content/ColdFusion/Essays/G IFAsPipe/Index.cfm If you're on CFMX (or 4.5 or 5 for that matter, but MX makes it easier) you could do this same thing but use the native Java classes instead of the ActiveX control. However there are tools specfically to do this kind of thing that you might want to take a look at. The most popular, I think, is "Rumba": http://www.netmanage.com/products/rumba/rumbaw2h.asp In the answer (as always) is "nothing's impossible with ColdFusion". ;^) Jim Davis ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Create DSNless connection to mySQL
I don't believe you can create DSNless connections in CFMX. You could in CF5 but not in MX. If I'm wrong, someone please let me know. -Novak - Original Message - From: "Peter Mayer" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, January 23, 2003 1:35 PM Subject: Create DSNless connection to mySQL > Hello! > > Can anyone show me a short example of how to create a DSNless connection > to > a mysql server (I only know the hostname, username and password but cannot > > create a datasource in the coldfusion mx administrator). > > Best regards, > > Peter > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: SQL Help
The problem is that you're using cursors. Cursors in SQL Server are very, very slow. Come up with an alternate way of doing your import. - Original Message - From: Duane Boudreau <[EMAIL PROTECTED]> Date: Thursday, January 23, 2003 9:02 am Subject: OT: SQL Help > Hi All, > > I need the help of an SQL expert here. I am importing some rather > large text > files (250MB +) into a database. The structure I am working with > looks like: > > tmp_vehix (~600,000 recs) > Col001 - Col0067 (Col031 - Col065 contain option FK data) > > tmp_opts (~2900 recs) > Col001, Col002 > > vehix > vin (PK) > > vehix_options > vin (PK) > option_id (PK) > > options > option_id (PK) > ga_options_id (case sensitive, matches the values in > tmp_vehix.Col031 - > tmp_vehix.Col065) > > Everything is going pretty smooth save the last part where I copy > the data > in option fields Col031 - Col065 in tmp_vehix to their options > equivalentsin the vehix_options table. The query I have written > writes the 8.5 million > records out to the table it is incredibly slow, estimated time is > 24 hours. > Would anyone mind taking a peak at the query to see if there are > any glaring > pain points that I could optimize and speed this beast up? Or possibly > suggest improvements to the structure of vehix, vehix_options and > options?Thanks in advance! > > Duane > > The query looks like this (some of the repetitious sections have been > shortened). > > DECLARE @vin varchar(20), @Col031 varchar(255), @Col032 varchar(255), > @Col033 varchar(255), @Col034 varchar(255), @Col035 > varchar(255), @Col036 varchar(255), @Col037 varchar(255), > @Col038 varchar(255), > @Col039 varchar(255), @Col040 varchar(255), @Col041 > varchar(255), @Col042 varchar(255), @Col043 varchar(255), > @Col044 varchar(255), > @Col045 varchar(255), @Col046 varchar(255), @Col047 > varchar(255), @Col048 varchar(255), @Col049 varchar(255), > @Col050 varchar(255), > @Col051 varchar(255), @Col052 varchar(255), @Col053 > varchar(255), @Col054 varchar(255), @Col055 varchar(255), > @Col056 varchar(255), > @Col057 varchar(255), @Col058 varchar(255), @Col059 > varchar(255), @Col060 varchar(255), @Col061 varchar(255), > @Col062 varchar(255), > @Col063 varchar(255), @Col064 varchar(255), @Col065 > varchar(255), @opt_id int, @counter as int > > DECLARE options_cursor CURSOR FOR > SELECT Col002, Col031, Col032, Col033, Col034, Col035, Col036, > Col037, Col038, Col039, Col040, Col041, Col042, > Col043, Col044, Col045, > Col046, Col047, Col048, Col049, Col050, Col051, > Col052, Col053, > Col054, Col055, Col056, Col057, Col058, Col059, > Col060, Col061, > Col062, Col063, Col064, Col065 > FROMtmp_vehix > > OPEN options_cursor > > FETCH NEXT FROM options_cursor > INTO @vin, @Col031, @Col032, @Col033, @Col034, @Col035, @Col036, > @Col037,@Col038, > @Col039, @Col040, @Col041, @Col042, @Col043, @Col044, @Col045, > @Col046,@Col047, > @Col048, @Col049, @Col050, @Col051, @Col052, @Col053, @Col054, > @Col055,@Col056, > @Col057, @Col058, @Col059, @Col060, @Col061, @Col062, @Col063, > @Col064,@Col065 > > WHILE @@FETCH_STATUS = 0 > BEGIN > > SET @counter = @counter + 1 > IF LEN(@Col031) > 0 > BEGIN > SET @opt_id = (SELECT option_id FROM options WHERE > CAST(ga_option_id as > varbinary(255)) = CAST(@Col031 as varbinary(255))) > IF @opt_id IS NOT NULL > BEGIN > INSERT INTO vehix_options (vin, option_id) > VALUES (@vin, @opt_id) > END > > IF LEN(@Col032) > 0 > BEGIN > SET @opt_id = (SELECT option_id FROM options > WHERE CAST(ga_option_id as > varbinary(255)) = CAST(@Col032 as varbinary(255))) > IF @opt_id IS NOT NULL > BEGIN > INSERT INTO vehix_options (vin, option_id) > VALUES (@vin, @opt_id) > END > > IF LEN(@Col033) > 0 > BEGIN > SET @opt_id = (SELECT option_id FROM > options WHERE CAST(ga_option_id as > varbinary(255)) = CAST(@Col033 as varbinary(255))) > IF @opt_id IS NOT NULL > BEGIN > INSERT INTO vehix_options (vin, > option_id)VALUES (@vin, @opt_id) > END > END > END > END > > FETCH NEXT FROM options_cursor > INTO@vin, @Col031, @Col032, @Col033,
RE: Cold Fusion and Telnet
Have a look here... http://www.intrafoundation.com/ They have a tcp and udp client that you could use to connect to whichever ports you were after HTH -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 22:47 To: CF-Talk Subject: Cold Fusion and Telnet Here's an interesting one and conceivable not possible, but I thought I would ask all the wise ones here on the CF-Talk list before I tell my client NO!. Has anybody ever done anything connecting Cold Fusion and Telnet? Basically the client wants to create a web-based telnet session to a back end application on a HP L3000 Unix server so that every computer in the organization doesn't have to have the customized telnet client installed and maintained/upgraded on them. Is this even possible? If not, any other suggestions on how such a system may be created? Anybody know of any tools/custom tags/CFX/applications or something else that may do this already? Thanks Ian Skinner Web Developer BloodSource Sacramento CA ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MS Access - Replace a specific string value
or leaving scope blank (default is one) - Original Message - From: "Casey C Cook" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, January 23, 2003 3:15 PM Subject: OT: MS Access - Replace a specific string value > Hi all - > > I've run into something I cant quite put my finger on yet. Does anyone > know a function to find the first instance of a specific character in a > string and replace it with another string value. In my case I want to find > the first instance of a comma " , " and replace it with a blank " ". Im > doing this so when I export a file without a text delimiter it will not > break the field into two separate columns. > > Thanks everyone! > Casey Cook > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Cold Fusion and Telnet
We use a com object called cfx_tcpclient to speak to our mail servers CLI via telnet. Works great. Justin > -Original Message- > From: Ian Skinner [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 23, 2003 5:47 PM > To: CF-Talk > Subject: Cold Fusion and Telnet > > Here's an interesting one and conceivable not possible, but I > thought I > would ask all the wise ones here on the CF-Talk list before I > tell my client > NO!. Has anybody ever done anything connecting Cold Fusion > and Telnet? > Basically the client wants to create a web-based telnet > session to a back > end application on a HP L3000 Unix server so that every > computer in the > organization doesn't have to have the customized telnet > client installed and > maintained/upgraded on them. > > Is this even possible? If not, any other suggestions on how > such a system > may be created? Anybody know of any tools/custom > tags/CFX/applications or > something else that may do this already? > > Thanks > > Ian Skinner > Web Developer > BloodSource > Sacramento CA > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: PDF Conversion Tools Question
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 cflist wrote: | We use AdLib for converting large amounts of uploaded resumes in all | sorts of file formats to PDF. And it works great. | | We were using ActivePDF, and it worked well at converting, but the | application always seemed to hang and spit out errors, and after a | few moths of back and forth with tech support - we dumped it for | AdLib. i just downloaded adlib..looks nice but it's not ready yet for realtime conversion from what i see in the forums... are u using adlib simply in batch mode or can u generate a html document pass it to adlib and return the file reasonably quickly??? z -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+MHHA1lRHdy8ASusRAlgfAKCCi6WLY7g8NEDYGkzoZmFvw9TAtACfQoNQ tvv7vYn8PHkvv60GbP9MFaQ= =zvBz -END PGP SIGNATURE- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Cold Fusion and Telnet
Here's an interesting one and conceivable not possible, but I thought I would ask all the wise ones here on the CF-Talk list before I tell my client NO!. Has anybody ever done anything connecting Cold Fusion and Telnet? Basically the client wants to create a web-based telnet session to a back end application on a HP L3000 Unix server so that every computer in the organization doesn't have to have the customized telnet client installed and maintained/upgraded on them. Is this even possible? If not, any other suggestions on how such a system may be created? Anybody know of any tools/custom tags/CFX/applications or something else that may do this already? Thanks Ian Skinner Web Developer BloodSource Sacramento CA ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Multiple Select Box
select user_id from tbl_projects where proj_id = #val(form.project_id)# select fname, lname, user_id from tbl_proj_users order by lname selected#fname# #lname# Hope it helps, goodluck - Original Message - From: "Michael Ross" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, January 23, 2003 1:59 PM Subject: Multiple Select Box > You know if you have a form that someone is editing data, and you can make a select box have a record selected. How do you do it where you want a multiple select box to have a lot of them selected? This is really killing me. Any idea's would be great > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFMX for JRun install assistance request
Folks, I purchased a copy of CFMX for JRun after having a successful experience with the development version on an older server. We are now creating a prototype production server. I've run into a snag during the install and I'm not sure what the problem is. JRun4 and the JRun4 update both installed fine. Restarted, confirmed operation. CMFX for JRun installation reportedly went fine. One thing I did different from default install was to change the context root to "ec" from "cfmx." (I assume that should have no impact else I would not be given the option to change it?) Restarted. Both Admin and Default servers are running as expected in the services control panel. However, now when I try to access JRun's admin page, I get an internal server error. Looking at JRun's logs, I see the following entries in admin-event.log for each failed attempt to access the admin server's login page: "error There is no web application configured to service your request" "user NoWebappServlet: init". Attempting to access CFMX Administrator following the path I set (http://000.000.000.000/ec/cfide/administrator/index.cfm) yields a "page not found" error. Anyone else run into that or know where I may have gone wrong? Thanks, Dale Coyner Communicast, Inc. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MX Database Issues
This was my fault, I wasn't actually selecting the empty recordset out of my table variable on an invalid login. I've used that sp for quite a while and I never even noticed, since CF5 always returned recordcount 0 even when there wasn't a recordset. -Rich > Having an issue referencing the recordcount attribute of a result set in MX. > This same code works perfectly in CF5. > > I'm calling a stored procedure, on a SQL2000 server, using CFSTOREDPROC that > takes a Username and Password, and returns three bit output variables, two > result sets and a returncode. > > For some reason I now get... > > Element RECORDCOUNT is undefined in USERCREDENTIALS > > ...when there are no matching records, rather than having > usercredentials.recordcount equal to 0. > > Any ideas? > > Thanks. > > -Rich > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sorting Numbers
Then your field must not be numeric...its the only answer. ordering a query by a numeric field will do just that...order them numerically i ran a loop to poulate a database with random numbers between 1-1000 it mixed them up rather nicely when i use the query below. it sorts them just right but changin the field to text does what ur explaing because they arent really numbers anymore, they are text and all entries with 1 in front of them are gonna come before entries with 2 at the beginning select * from tbl_numbers order by number if you dont want to change the field to numeric then use ORDER BY VAL(Field) (dunno if this works in anything other than msaccess) hope it helps. goodluck... - Original Message - From: "Jillian Carroll" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, January 23, 2003 10:53 AM Subject: RE: Sorting Numbers > It's not working that way... it does: 1, 10, 100, etc. instead of 1, 2, > 3, 4, and so on. > > > -Original Message- > > From: Ewok [mailto:[EMAIL PROTECTED]] > > Sent: January 23, 2003 8:24 AM > > To: CF-Talk > > Subject: Re: Sorting Numbers > > > > > > if the field's data type in the table is numeric then you can > > just order your query by that field? > > > > - Original Message - > > From: "Jillian Carroll" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Wednesday, January 22, 2003 6:24 PM > > Subject: RE: Sorting Numbers > > > > > > > Sorry, I mis-spoke (hazard of using a word with double meanings). > > > > > > I need to sort the results of a query in this way. > > > > > > > -Original Message- > > > > From: Everett, Al [mailto:[EMAIL PROTECTED]] > > > > Sent: January 22, 2003 5:04 PM > > > > To: CF-Talk > > > > Subject: RE: Sorting Numbers > > > > > > > > > > > > What you've got there is an ASCII sort. > > > > > > > > You want a numeric sort. > > > > > > > > ListSort(myList,"numeric") > > > > > > > > > -Original Message- > > > > > From: Jillian Carroll [mailto:[EMAIL PROTECTED]] > > > > > Sent: Wednesday, January 22, 2003 5:51 PM > > > > > To: CF-Talk > > > > > Subject: Sorting Numbers > > > > > > > > > > > > > > > How do I sort a list so that it doesn't do this: > > > > > > > > > > 1 > > > > > 2 > > > > > 3 > > > > > 4 > > > > > 5 > > > > > 6 > > > > > 7 > > > > > 8 > > > > > 9 > > > > > 10 > > > > > 100 > > > > > 101 > > > > > 102 > > > > > 103 > > > > > 104... > > > > > > > > > > I want 11 to come after 10. > > > > > > > > > > Thanks! > > > > > > > > > > -- > > > > > Jillian > > > > > > > > > > > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Create DSNless connection to mySQL
cfhub.com has some CF examples > -Original Message- > From: Mike Townend [mailto:[EMAIL PROTECTED]] > Sent: Friday, 24 January 2003 11:01 a.m. > To: CF-Talk > Subject: RE: Create DSNless connection to mySQL > > > Afaik DSNless connections arnt available in CFMX, the only > option would be > to look at some asp examples and use ADO to connect... > > HTH > > > > -Original Message- > From: Peter Mayer [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 23, 2003 21:35 > To: CF-Talk > Subject: Create DSNless connection to mySQL > > > Hello! > > Can anyone show me a short example of how to create a DSNless > connection > to > a mysql server (I only know the hostname, username and > password but cannot > > create a datasource in the coldfusion mx administrator). > > Best regards, > > Peter > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Automated Test Tools for Flash UIs?
I remember in VB6 you could script keyboard/mouse commands pretty easily. I'm sure a program could be created that would script this sort of thing. It would just need a Macro Record type function to collect the user interaction and save it for automation later. Craig - Original Message - From: "Stacy Young" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, January 23, 2003 3:29 PM Subject: Automated Test Tools for Flash UIs? > Now that we've got Rich Apps being rolled out for Enterprise apps...how > the heck can we load test via scripted browsing agents. (like Silk Test > etc..) > > Appreciate any thoughts... > > Stace > > AVIS IMPORTANT: > --- > Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. > > WARNING: > --- > The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
MX Database Issues
Having an issue referencing the recordcount attribute of a result set in MX. This same code works perfectly in CF5. I'm calling a stored procedure, on a SQL2000 server, using CFSTOREDPROC that takes a Username and Password, and returns three bit output variables, two result sets and a returncode. For some reason I now get... Element RECORDCOUNT is undefined in USERCREDENTIALS ...when there are no matching records, rather than having usercredentials.recordcount equal to 0. Any ideas? Thanks. -Rich ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Create DSNless connection to mySQL
Afaik DSNless connections arnt available in CFMX, the only option would be to look at some asp examples and use ADO to connect... HTH -Original Message- From: Peter Mayer [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 21:35 To: CF-Talk Subject: Create DSNless connection to mySQL Hello! Can anyone show me a short example of how to create a DSNless connection to a mysql server (I only know the hostname, username and password but cannot create a datasource in the coldfusion mx administrator). Best regards, Peter ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Help Please: Find/Replace
To take a page from Raymond Camden: -- Ben Doom Regular Expression Jedi Apprentice Moonbow Software, Inc :-) Come, Padwans from across the globe, go on a pilgramage to the source of all things CF-RegEx: http://www.houseoffusion.com/cf_lists/index.cfm?method=threads&forumid=21 There, we have faced the Dark Side and have always been victorious. Bring us your frustrations, and we shall defeat them, for frustration leads to hate, hate leads to pain, pain leads to using ASP, and that way lies the Dark Side. :-) : -Original Message- : From: charlie griefer [mailto:[EMAIL PROTECTED]] : Sent: Thursday, January 23, 2003 3:27 PM : To: CF-Talk : Subject: Re: Help Please: Find/Replace : : : Kelly Matthews writes: : : > YOU RULE! :) that worked just wonderfully :-) : : He is an elite RegExp Ninja :) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Automated Test Tools for Flash UIs?
Now that we've got Rich Apps being rolled out for Enterprise apps...how the heck can we load test via scripted browsing agents. (like Silk Test etc..) Appreciate any thoughts... Stace AVIS IMPORTANT: --- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: --- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Verity - why won't it work?
I think I have, but this is my first experience with Verity so I don't know for sure. All I did was follow what little instructions were available in the CFIDE Help. Cutter Ben Doom wrote: >Here's a silly question (but one that got me after a long day): >did you index the collection after you created it? I was re-indexing an >empty index and it wasn't working until I went into the admin and indexed >it. Then it worked properly. > >I figure you already thought of this, but I always like to start with the >obvious and work my way to the esoteric. :-) > > >-- Ben Doom >Programmer & General Lackey >Moonbow Software, Inc > >: -Original Message- >: From: Cutter (CF_Talk) [mailto:[EMAIL PROTECTED]] >: Sent: Thursday, January 23, 2003 1:17 PM >: To: CF-Talk >: Subject: Re: Verity - why won't it work? >: >: >: Different search pages are used to access each collection. It is a >: shared environment, though currently these are the only two collections >: on this server. Approximately 100 pages and 30+ documents (word and >: .pdf). Both collections worked fine when the site was on the 4.5.2 >: server (but we can't go back). >: >: Cutter >: >: Mark Leder wrote: >: >: >If you have multiple collections, separate these in the COLLECTION value >: >with commas. >: >Also, are you running CF in a dedicated or shared environment? Also, how >: >many pages would you guess are being indexed? Did the two prior >: unworking >: >collections work at any time in the past? >: > >: >Thanks, Mark >: > >: >-Original Message- >: >From: Cutter (CF_Talk) [mailto:[EMAIL PROTECTED]] >: >Sent: Thursday, January 23, 2003 10:26 AM >: >To: CF-Talk >: >Subject: Verity - why won't it work? >: > >: > >: >I have a site for a local school board set up on a Linux server running >: >CFMX. I have set up two separate Verity collections, one to index the >: >entire site and one to only index a "documents" directory. Having never >: >done this before (and our lead developer not having any idea why it >: >wasn't working) I killed the two prior, unworking, collections and >: >recreated them from scratch. I just followed the ambiguous directions >: >included in the "Help" of the CFIDE administrator. Although I have these >: >two collections setup, and supposedly correctly, I am still unable to >: >get any results. The worked fine when this was all set up on >: >a CF 4.5.2 machine, but we migrated the site when they asked for a >: >redesign. Are there changes to CFSEARCH that I am unaware of? Any >: >suggestions? Below is some of the code... >: > >: >: > criteria="#form.terms#" >: > name="qryData" >: > type="SIMPLE"> >: > >: > >: > >: >#qryData.recordcount# records found >: >matching "#form.terms#" out of >: >#qryData.recordsSearched#. >: > >: > >: >. >: > >: > >: >And the output of any query is... >: > >: >0 records found matching "[term]" out of . >: > >: > >: > >: > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Create DSNless connection to mySQL
Hello! Can anyone show me a short example of how to create a DSNless connection to a mysql server (I only know the hostname, username and password but cannot create a datasource in the coldfusion mx administrator). Best regards, Peter ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: PDF Conversion Tools Question
We use AdLib for converting large amounts of uploaded resumes in all sorts of file formats to PDF. And it works great. We were using ActivePDF, and it worked well at converting, but the application always seemed to hang and spit out errors, and after a few moths of back and forth with tech support - we dumped it for AdLib. Kirk -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 10:55 AM To: CF-Talk Subject: PDF Conversion Tools Question Anybody with opinions on any of the following: DocConverter ActivePDF AdLib eXpress ...or other solutions to convert from HTML/CFM to PDF? Just considering the possibilities... Thanks Les ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: JDBC Driver Versions
Thanks Dave. - Original Message - From: "Dave Watts" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, January 23, 2003 3:29 PM Subject: RE: JDBC Driver Versions > > Where can I check what versions of Datadirect > > Drivers I have installed on CFMX? Trying to > > determine if they are the newest ones. > > I don't know if there's anything you can check within the jar file itself > (\cfusionmx\lib\macromedia_drivers.jar), but if you install Updater 2, you > get the latest (current) version of Datadirect Connect for JDBC, which is > 3.1, I think. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > fax: (202) 797-5444 > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: invalid precision value
>OK Field 1, 2, "3 - This is, perhaps reasonable so, OK", "4-This tends to >""Blow Up"", many times". > >Field 4 tends to end up as 2 or more fields, and if your tag doesn't fix >this bombs out the insert/update. Further research shows that previous csv uploads had commas in that field and they were processed out properly in the tag loop... so there's some sort of bad data apparently in the csv I'm trying to post. I just can't find it. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: PDF Conversion Tools Question
The combination below seemed to work, except we use CSS and the of course it didn't render right...grr But once we made the page "old fashioned" it rendered it no problem. Just be careful of bad calls to the executable because it didn't seem to clean itself up well (HTML2PDF3 & HTMLDoc.exe) Regards, Eric J Hoffman DataStream Connexion www.datastreamconnexion.com Delivering Creative Data Solutions -Original Message- From: Andrea Galmacci - awd* [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 2:01 PM To: CF-Talk Subject: Re: PDF Conversion Tools Question http://cfug.cshore.com/presentations/2002Nov/README2.txt CF_HTML2pdf3 + HTMLdoc ? SIx months ago the only missing features was CSS support - don't know now. HTH, Andrea - Original Message - From: "Les Mizzell" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, January 23, 2003 7:54 PM Subject: PDF Conversion Tools Question > Anybody with opinions on any of the following: > > DocConverter > ActivePDF > AdLib eXpress > > > ...or other solutions to convert from HTML/CFM to PDF? > > > Just considering the possibilities... > > Thanks > > Les > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: & and WDDX
> But WDDX should handle _everything_ for you. > What version are you seeing this in? This has certainly not been the case in the past. If you want to use XML metacharacters as literal characters in your WDDX data, you have to escape it with the XMLFormat function. The exception to this in the past has been when you convert a query to WDDX. For any other data, you're responsible for escaping it yourself. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MS Access - Replace a specific string value
http://livedocs.macromedia.com/cfmxdocs/CFML_Reference/functions-pt266.jsp#342 -Original Message- From: Casey C Cook [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 3:16 PM To: CF-Talk Subject: OT: MS Access - Replace a specific string value Hi all - I've run into something I cant quite put my finger on yet. Does anyone know a function to find the first instance of a specific character in a string and replace it with another string value. In my case I want to find the first instance of a comma " , " and replace it with a blank " ". Im doing this so when I export a file without a text delimiter it will not break the field into two separate columns. Thanks everyone! Casey Cook ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: JDBC Driver Versions
> Where can I check what versions of Datadirect > Drivers I have installed on CFMX? Trying to > determine if they are the newest ones. I don't know if there's anything you can check within the jar file itself (\cfusionmx\lib\macromedia_drivers.jar), but if you install Updater 2, you get the latest (current) version of Datadirect Connect for JDBC, which is 3.1, I think. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT: MS Access - Replace a specific string value
Casey C Cook writes: > Hi all - > > I've run into something I cant quite put my finger on yet. Does anyone > know a function to find the first instance of a specific character in a > string and replace it with another string value. In my case I want to find > the first instance of a comma " , " and replace it with a blank " ". Im > doing this so when I export a file without a text delimiter it will not > break the field into two separate columns. replace(myString, ",", " ", "one") should do it. charlie ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help Please: Find/Replace
Kelly Matthews writes: > YOU RULE! :) that worked just wonderfully :-) He is an elite RegExp Ninja :) > >>From: "Ben Doom" <[EMAIL PROTECTED]> >>Reply-To: [EMAIL PROTECTED] >>To: CF-Talk <[EMAIL PROTECTED]> >>Subject: RE: Help Please: Find/Replace >>Date: Thu, 23 Jan 2003 14:54:43 -0500 >> >>This sounds like a job for (da da da-dh) RegEx! >> >>You want something along the lines of >>string = rereplace(string, '\[([^]]+)\]', '\1', 'all'); >> >>I /think/ this will work. I've not tested it and whatnot. Working with >>brackets and other special characters always adds a bit of adventure to it. >>:-) >> >>HTH. >> >>And, of course, if you need more help or more in-depth commentary, jump on >>over to CF-RegEx (available via the [http://www.houseoffusion.com] >>website). >> >>Good luck. >> >> >>-- Ben Doom >> Programmer & General Lackey >> Moonbow Software, Inc >> >>: -Original Message- >>: From: Kelly Matthews [mailto:[EMAIL PROTECTED]] >>: Sent: Thursday, January 23, 2003 2:43 PM >>: To: CF-Talk >>: Subject: Help Please: Find/Replace >>: >>: >>: OK I am sure there is an ez way to do this my brain just doesn't >>: seem to be >>: working today... >>: >>: We have an application where some people may enter URLs they are >>: requested >>: to enter them like so >>: >>: [http://www.whatever.com] >>: [http://www.whatever2.com] >>: [http://www.whatever3.com] >>: >>: What i want to be able to do is find each [ ] and take what's in >>: the middle >>: of it and wrap it in a >: href="http://www.whatever.com";>http://www.whatever.com and >>: remove the [ >>: ] there may be multiple URLS in the text. I have been messin around with >>: the find/replace etc. for a bit now and running into some problems. I am >>: sure i am just doing it wrong. Any suggestions on how to do this right? >>: >>: Kelly >>: >>: >>: >> > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT: MS Access - Replace a specific string value
Hi all - I've run into something I cant quite put my finger on yet. Does anyone know a function to find the first instance of a specific character in a string and replace it with another string value. In my case I want to find the first instance of a comma " , " and replace it with a blank " ". Im doing this so when I export a file without a text delimiter it will not break the field into two separate columns. Thanks everyone! Casey Cook ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Help Please: Find/Replace
YOU RULE! :) that worked just wonderfully :-) >From: "Ben Doom" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: RE: Help Please: Find/Replace >Date: Thu, 23 Jan 2003 14:54:43 -0500 > >This sounds like a job for (da da da-dh) RegEx! > >You want something along the lines of >string = rereplace(string, '\[([^]]+)\]', '\1', 'all'); > >I /think/ this will work. I've not tested it and whatnot. Working with >brackets and other special characters always adds a bit of adventure to it. >:-) > >HTH. > >And, of course, if you need more help or more in-depth commentary, jump on >over to CF-RegEx (available via the [http://www.houseoffusion.com] >website). > >Good luck. > > >-- Ben Doom > Programmer & General Lackey > Moonbow Software, Inc > >: -Original Message- >: From: Kelly Matthews [mailto:[EMAIL PROTECTED]] >: Sent: Thursday, January 23, 2003 2:43 PM >: To: CF-Talk >: Subject: Help Please: Find/Replace >: >: >: OK I am sure there is an ez way to do this my brain just doesn't >: seem to be >: working today... >: >: We have an application where some people may enter URLs they are >: requested >: to enter them like so >: >: [http://www.whatever.com] >: [http://www.whatever2.com] >: [http://www.whatever3.com] >: >: What i want to be able to do is find each [ ] and take what's in >: the middle >: of it and wrap it in a : href="http://www.whatever.com";>http://www.whatever.com and >: remove the [ >: ] there may be multiple URLS in the text. I have been messin around with >: the find/replace etc. for a bit now and running into some problems. I am >: sure i am just doing it wrong. Any suggestions on how to do this right? >: >: Kelly >: >: >: > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: PDF Conversion Tools Question
http://cfug.cshore.com/presentations/2002Nov/README2.txt CF_HTML2pdf3 + HTMLdoc ? SIx months ago the only missing features was CSS support - don't know now. HTH, Andrea - Original Message - From: "Les Mizzell" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, January 23, 2003 7:54 PM Subject: PDF Conversion Tools Question > Anybody with opinions on any of the following: > > DocConverter > ActivePDF > AdLib eXpress > > > ...or other solutions to convert from HTML/CFM to PDF? > > > Just considering the possibilities... > > Thanks > > Les > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Multiple Select Box
great thanks!! I will run with it >>> [EMAIL PROTECTED] 01/23/03 02:27PM >>> Michael: You could do this in JavaScript. See the source code: http://charlie.griefer.com/js_selectMultiple.html hth, Charlie Michael Ross writes: > You know if you have a form that someone is editing data, and you can make a select >box have a record selected. How do you do it where you want a multiple select box to >have a lot of them selected? This is really killing me. Any idea's would be >great > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Help Please: Find/Replace
This sounds like a job for (da da da-dh) RegEx! You want something along the lines of string = rereplace(string, '\[([^]]+)\]', '\1', 'all'); I /think/ this will work. I've not tested it and whatnot. Working with brackets and other special characters always adds a bit of adventure to it. :-) HTH. And, of course, if you need more help or more in-depth commentary, jump on over to CF-RegEx (available via the [http://www.houseoffusion.com] website). Good luck. -- Ben Doom Programmer & General Lackey Moonbow Software, Inc : -Original Message- : From: Kelly Matthews [mailto:[EMAIL PROTECTED]] : Sent: Thursday, January 23, 2003 2:43 PM : To: CF-Talk : Subject: Help Please: Find/Replace : : : OK I am sure there is an ez way to do this my brain just doesn't : seem to be : working today... : : We have an application where some people may enter URLs they are : requested : to enter them like so : : [http://www.whatever.com] : [http://www.whatever2.com] : [http://www.whatever3.com] : : What i want to be able to do is find each [ ] and take what's in : the middle : of it and wrap it in a http://www.whatever.com";>http://www.whatever.com and : remove the [ : ] there may be multiple URLS in the text. I have been messin around with : the find/replace etc. for a bit now and running into some problems. I am : sure i am just doing it wrong. Any suggestions on how to do this right? : : Kelly : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Help Please: Find/Replace
OK I am sure there is an ez way to do this my brain just doesn't seem to be working today... We have an application where some people may enter URLs they are requested to enter them like so [http://www.whatever.com] [http://www.whatever2.com] [http://www.whatever3.com] What i want to be able to do is find each [ ] and take what's in the middle of it and wrap it in a http://www.whatever.com";>http://www.whatever.com and remove the [ ] there may be multiple URLS in the text. I have been messin around with the find/replace etc. for a bit now and running into some problems. I am sure i am just doing it wrong. Any suggestions on how to do this right? Kelly ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: tobase64
The process works with a jpeg for me, but when I try to use it on a pdf it fails when converting back to a binary. Seems there's a discrepency between tobase64 that leaves + and / characters, tobinary fails with those characters. I guess I'll keep playing with it. -Original Message- From: Sicular, Alexander [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 2:22 PM To: CF-Talk Subject: RE: tobase64 That article should work. My system works more or less the same. The sql datatype needs to be 'text', not 'image'. Cf won't send a binary through an sql statement. That's why you need to tobase64 it. The result is an ascii safe string of text. The downside is that the base64 version of the binary file is ~33% larger. Gl, Alexander Sicular Chief Technology Architect Neurological Institute of New York Columbia University as867 [at] columbia {dot} edu |-Original Message- |From: Turetsky, Seth [mailto:[EMAIL PROTECTED]] |Sent: Thursday, January 23, 2003 1:00 PM |To: CF-Talk |Subject: tobase64 | | |I posted this on another list but didn't get a reply: | |I was following this tutorial for storing binary files in a |database: |http://is.curtin.edu.au/ics/web/resources/binary_files_with_oracle.htm | |I'm using sql server for this which shouldn't matter, but it |seems my problem is with the toBase64 function, when i run |that for example on a pdf, I see a lot of +'s and /'s left, so |when I try to convert back, tobinary fails saying my string |should be a base64-encoded string. If I manually remove those |characters, then the tobinary works since it's a valid base64 |string then. | |Anyone know why the tobase64 function leaves those characters in? | |thanks, |seth | |This message is for the named person's use only. It may |contain sensitive and private proprietary or legally |privileged information. No confidentiality or privilege is |waived or lost by any mistransmission. If you are not the |intended recipient, please immediately delete it and all |copies of it from your system, destroy any hard copies of it |and notify the sender. You must not, directly or indirectly, |use, disclose, distribute, print, or copy any part of this |message if you are not the intended recipient. CREDIT SUISSE |GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON |or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT |SUISSE FIRST BOSTON reserve the right to monitor all e-mail |communications through its networks. Any views expressed in |this message are those of the individual sender, except where |the message states otherwise and the sender is authorized to |state them to be the views of any such entity. Unless |otherwise stated, any pricing information given in this |message is indicative only, is subject to change and does not |constitute an offer to deal at any price quoted. Any reference |to the terms of executed transactions should be treated as |preliminary only and subject to our formal written confirmation. | | | ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Multiple Select Box
Michael: You could do this in JavaScript. See the source code: http://charlie.griefer.com/js_selectMultiple.html hth, Charlie Michael Ross writes: > You know if you have a form that someone is editing data, and you can make a select >box have a record selected. How do you do it where you want a multiple select box to >have a lot of them selected? This is really killing me. Any idea's would be >great > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: tobase64
That article should work. My system works more or less the same. The sql datatype needs to be 'text', not 'image'. Cf won't send a binary through an sql statement. That's why you need to tobase64 it. The result is an ascii safe string of text. The downside is that the base64 version of the binary file is ~33% larger. Gl, Alexander Sicular Chief Technology Architect Neurological Institute of New York Columbia University as867 [at] columbia {dot} edu |-Original Message- |From: Turetsky, Seth [mailto:[EMAIL PROTECTED]] |Sent: Thursday, January 23, 2003 1:00 PM |To: CF-Talk |Subject: tobase64 | | |I posted this on another list but didn't get a reply: | |I was following this tutorial for storing binary files in a |database: |http://is.curtin.edu.au/ics/web/resources/binary_files_with_oracle.htm | |I'm using sql server for this which shouldn't matter, but it |seems my problem is with the toBase64 function, when i run |that for example on a pdf, I see a lot of +'s and /'s left, so |when I try to convert back, tobinary fails saying my string |should be a base64-encoded string. If I manually remove those |characters, then the tobinary works since it's a valid base64 |string then. | |Anyone know why the tobase64 function leaves those characters in? | |thanks, |seth | |This message is for the named person's use only. It may |contain sensitive and private proprietary or legally |privileged information. No confidentiality or privilege is |waived or lost by any mistransmission. If you are not the |intended recipient, please immediately delete it and all |copies of it from your system, destroy any hard copies of it |and notify the sender. You must not, directly or indirectly, |use, disclose, distribute, print, or copy any part of this |message if you are not the intended recipient. CREDIT SUISSE |GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON |or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT |SUISSE FIRST BOSTON reserve the right to monitor all e-mail |communications through its networks. Any views expressed in |this message are those of the individual sender, except where |the message states otherwise and the sender is authorized to |state them to be the views of any such entity. Unless |otherwise stated, any pricing information given in this |message is indicative only, is subject to change and does not |constitute an offer to deal at any price quoted. Any reference |to the terms of executed transactions should be treated as |preliminary only and subject to our formal written confirmation. | | | ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Studio 5 development mappings problem
Has anyone encountered this problem and, if so, did you find a resolution? I have W2K Pro running IIS 5 with virtual directories as follows: mydir mapped to c:\inetpub\wwwroot\mydir mydir2 mapped to c:\inetpub\wwwroot\mydir2 I can browse the contents of both these directories with the URLs: http://127.0.0.1/mydir/ http://127.0.0.1/mydir2/ I've set up two development mappings in Studio 5: Studio and server path: c:\intepub\wwwroot\dir Browser path: http://127.0.0.1/mydir/ Studio and server path: c:\inetpub\wwwroot\dir2 Browser path: http://127.0.0.1/mydir2/ Within Studio, I can "browse" mydir no problem but when I try to browse files in mydir2 the URL that is trying to be resolved ends up as http://127.0.0.1/mydir/2/ The same thing will occur with virtual and physical directories named mydir and mydirold; mydirold resolves to http://127.0.0.1/mydir/old/ Any light appreciated. Stephen ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF & Database Options
paul smith wrote: > At 12:21 PM 1/23/03 +0100, you wrote: > >>Just some thoughts: >>- query caching does not necessarily have to happen through the cfquery tag > > Are you referring to normal DB caching? No. Just do a query and store the query in the application or session scope. >>- you could use multiple logins to the database, a readonly login and a normal >>one for instance > > Tell me more. Define more as 1 login. Use the readonly login from all the public templates, and the one with full access from an administrative interface. >>- use something not CF to update the database > > Such as? Anything that talks ODBC, JDBC or the native protocol of your rdbms. It could even be Access running from your computer at home. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Verity - why won't it work?
Here's a silly question (but one that got me after a long day): did you index the collection after you created it? I was re-indexing an empty index and it wasn't working until I went into the admin and indexed it. Then it worked properly. I figure you already thought of this, but I always like to start with the obvious and work my way to the esoteric. :-) -- Ben Doom Programmer & General Lackey Moonbow Software, Inc : -Original Message- : From: Cutter (CF_Talk) [mailto:[EMAIL PROTECTED]] : Sent: Thursday, January 23, 2003 1:17 PM : To: CF-Talk : Subject: Re: Verity - why won't it work? : : : Different search pages are used to access each collection. It is a : shared environment, though currently these are the only two collections : on this server. Approximately 100 pages and 30+ documents (word and : .pdf). Both collections worked fine when the site was on the 4.5.2 : server (but we can't go back). : : Cutter : : Mark Leder wrote: : : >If you have multiple collections, separate these in the COLLECTION value : >with commas. : >Also, are you running CF in a dedicated or shared environment? Also, how : >many pages would you guess are being indexed? Did the two prior : unworking : >collections work at any time in the past? : > : >Thanks, Mark : > : >-Original Message- : >From: Cutter (CF_Talk) [mailto:[EMAIL PROTECTED]] : >Sent: Thursday, January 23, 2003 10:26 AM : >To: CF-Talk : >Subject: Verity - why won't it work? : > : > : >I have a site for a local school board set up on a Linux server running : >CFMX. I have set up two separate Verity collections, one to index the : >entire site and one to only index a "documents" directory. Having never : >done this before (and our lead developer not having any idea why it : >wasn't working) I killed the two prior, unworking, collections and : >recreated them from scratch. I just followed the ambiguous directions : >included in the "Help" of the CFIDE administrator. Although I have these : >two collections setup, and supposedly correctly, I am still unable to : >get any results. The worked fine when this was all set up on : >a CF 4.5.2 machine, but we migrated the site when they asked for a : >redesign. Are there changes to CFSEARCH that I am unaware of? Any : >suggestions? Below is some of the code... : > : > criteria="#form.terms#" : > name="qryData" : > type="SIMPLE"> : > : > : > : >#qryData.recordcount# records found : >matching "#form.terms#" out of : >#qryData.recordsSearched#. : > : > : >. : > : > : >And the output of any query is... : > : >0 records found matching "[term]" out of . : > : > : > : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: invalid precision value
Which record is causing it to bomb? I've found that the following sort of record causes the most problems with CSV tags: OK Field 1, 2, "3 - This is, perhaps reasonable so, OK", "4-This tends to ""Blow Up"", many times". Field 4 tends to end up as 2 or more fields, and if your tag doesn't fix this bombs out the insert/update. Andy -Original Message- From: Rafael Alan Bleiweiss [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 12:47 PM To: CF-Talk Subject: invalid precision value I'm uploading a csv file into Access in a loop using the CSV2Data custom tag- adding new records and I get the following error: ODBC Error Code = S1104 (Invalid precision value) I've uploaded ten csv files that all worked well but this one blows up... What can cause this error message? One of my fields contains a lot of text (importing it into a Memo field, and there's commas inside the contents of the field but I was under the impression that this is acceptable in such a tag. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Multiple Select Box
You know if you have a form that someone is editing data, and you can make a select box have a record selected. How do you do it where you want a multiple select box to have a lot of them selected? This is really killing me. Any idea's would be great ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
PDF Conversion Tools Question
Anybody with opinions on any of the following: DocConverter ActivePDF AdLib eXpress ...or other solutions to convert from HTML/CFM to PDF? Just considering the possibilities... Thanks Les ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
invalid precision value
I'm uploading a csv file into Access in a loop using the CSV2Data custom tag- adding new records and I get the following error: ODBC Error Code = S1104 (Invalid precision value) I've uploaded ten csv files that all worked well but this one blows up... What can cause this error message? One of my fields contains a lot of text (importing it into a Memo field, and there's commas inside the contents of the field but I was under the impression that this is acceptable in such a tag. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Working with a PDF file
Client has finally decided to use straight .cfm pages with SQL Server to maintain their price list and apply updates, (some 200 pages of products), and then purchase several licenses of ActivePDF to get it back into the "official" company format for printing when a rep pulls it from the web (or intranet) Saves me from having to trouble shoot all those variable handler pages to pull CF variables into a PDF document, which in early test I had working fine. Problem was, the client then asked, "What if I want to add 50 new products or another category". Jezz, I figured I'd have to rewrite half the app each time they made a global change like that. Maybe good for my pocketbook, but very bad for theirs... Thanks to all that replied! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Uploading Error
Okay, how about this-- I've done some searching, and I can't even find out what this error means. Is there a place that I can at least find that out? Thanks, Russ > -Original Message- > From: Russ [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 23, 2003 9:58 AM > To: CF-Talk > Subject: Uploading Error > > > String index out of range: -1 > > > The Error Occurred in > /home/domainname/httpdocs/admin/music/uploadAction.cfm: line 41 > > 39 : > 40 : > 41 : > > > This is a fun-filled error I'm getting when I'm attempting to upload a > file to a directory on my server (RedHat). I've not had any problems > using this type of upload anywhere else, and I'm wondering if > anyone can > offer any advice as to just what that means? > > Thanks! > > Russ > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Pet Market Benchmarks?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 does anyone know of some benchmarks of pet market against the java or .NET versions z -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+MDU31lRHdy8ASusRAiNeAJ9eEiyqEoWqt3CuQvB3zWUMw7QsnwCeME26 +ZVOfHQcmrk3L/jqBhvCiTM= =z5pa -END PGP SIGNATURE- ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
JDBC Driver Versions
Where can I check what versions of Datadirect Drivers I have installed on CFMX? Trying to determine if they are the newest ones. Thanks! ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Back/Next Forms
> Thane Sherrington wrote: > >>I'm building a multipaged form with back and next buttons. All the form >>fields are checkboxes. I want the boxes to remember what is checked when I >>go back and forth between pages. Do I create a list of hidden form fields >>carrying the values already submitted, or do I use session variables, or is >>there a better way that I'm not seeing? I'd go with the session variables. In your Application.cfm, cfparam all of your form fields, with default values of "". Then in your form pages, just give each field a value of session.thisFormField (or in the case of checkboxes, only do 'checked' if the value is ""). charlie ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Back/Next Forms
I believe if you use history.replace('mypage.cfm'); to navigate back it will keep the form values (I think...) Cutter Thane Sherrington wrote: >I'm building a multipaged form with back and next buttons. All the form >fields are checkboxes. I want the boxes to remember what is checked when I >go back and forth between pages. Do I create a list of hidden form fields >carrying the values already submitted, or do I use session variables, or is >there a better way that I'm not seeing? > >T > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: & and WDDX
Is this WDDX produced by ColdFusion or by another WDDX engine? Please post some code, it should automatically encode it as & Sam At 11:35 AM 1/23/2003, you wrote: >It seems that everytime the "&" is used in a WDDX packet we get an XML >parsing error: not well-formed. > >Has anyone else ran into this and come up with a solution?? > >Thanks >Paul Giesenhagen >QuillDesign ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Verity - why won't it work?
Different search pages are used to access each collection. It is a shared environment, though currently these are the only two collections on this server. Approximately 100 pages and 30+ documents (word and .pdf). Both collections worked fine when the site was on the 4.5.2 server (but we can't go back). Cutter Mark Leder wrote: >If you have multiple collections, separate these in the COLLECTION value >with commas. >Also, are you running CF in a dedicated or shared environment? Also, how >many pages would you guess are being indexed? Did the two prior unworking >collections work at any time in the past? > >Thanks, Mark > >-Original Message- >From: Cutter (CF_Talk) [mailto:[EMAIL PROTECTED]] >Sent: Thursday, January 23, 2003 10:26 AM >To: CF-Talk >Subject: Verity - why won't it work? > > >I have a site for a local school board set up on a Linux server running >CFMX. I have set up two separate Verity collections, one to index the >entire site and one to only index a "documents" directory. Having never >done this before (and our lead developer not having any idea why it >wasn't working) I killed the two prior, unworking, collections and >recreated them from scratch. I just followed the ambiguous directions >included in the "Help" of the CFIDE administrator. Although I have these >two collections setup, and supposedly correctly, I am still unable to >get any results. The worked fine when this was all set up on >a CF 4.5.2 machine, but we migrated the site when they asked for a >redesign. Are there changes to CFSEARCH that I am unaware of? Any >suggestions? Below is some of the code... > > criteria="#form.terms#" > name="qryData" > type="SIMPLE"> > > > >#qryData.recordcount# records found >matching "#form.terms#" out of >#qryData.recordsSearched#. > > >. > > >And the output of any query is... > >0 records found matching "[term]" out of . > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: & and WDDX
But WDDX should handle _everything_ for you. What version are you seeing this in? === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Email: [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Owens, Howard [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 23, 2003 11:50 AM > To: CF-Talk > Subject: RE: & and WDDX > > > In XML the ampersand is always interrupted as the start of a > character entity. You need to escape it -- convert all to & > > H. > > > > -Original Message- > > From: Paul Giesenhagen [SMTP:[EMAIL PROTECTED]] > > Sent: Thursday, January 23, 2003 9:35 AM > > To: CF-Talk > > Subject:& and WDDX > > > > It seems that everytime the "&" is used in a WDDX packet we > get an XML > > parsing error: not well-formed. > > > > Has anyone else ran into this and come up with a solution?? > > > > Thanks > > Paul Giesenhagen > > QuillDesign > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Back/Next Forms
I'm building a multipaged form with back and next buttons. All the form fields are checkboxes. I want the boxes to remember what is checked when I go back and forth between pages. Do I create a list of hidden form fields carrying the values already submitted, or do I use session variables, or is there a better way that I'm not seeing? T ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT: MM Suprises Wall Street
I've just got to add ... I've been a part of a lot of different discussion lists for various kinds of developers and nothing comes close to matching this list for friendliness and helpfulness. I've become totally spoiled over the years in my expectations and when I sign on to other development community lists or sites, I get very frustrated some times. CF-Talk and the entire House of Fusion suite of lists rock. While each of the individual contributors deserve credit, how about a big round of applause for Michael Dinowitz and Judith Dinowitz. > -Original Message- > From: Jason Miller [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, January 23, 2003 2:55 AM > To: CF-Talk > Subject: Re: OT: MM Suprises Wall Street > > This is comforting. A strong community and positive messages like this > are important to be aware of and vital to the developers that are > constantly selling the CF way of life ! :) So I personally don't think > it is off topic since it does exactly tie into our livelihoods. > > It also made me loging to my ameritrade account for the first time in 7 > months :) ha ha- now that was off topic - but a little humor never hurt > anyone. > > Glad Macromedia has some positive light shed on it... Bravo. > jay miller > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4