RE: cfopen.org
looks exactly like sourceforge.com - which is opensource _ From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: July 7, 2004 1:10 PM To: CF-Talk Subject: Re: cfopen.org No really hard to believe, just that there are more community based tools with php, and more intranet/extranet based projects with CF Not sure if it is SourceForge... I thought Sourceforge was perl ? MD On Wed, 7 Jul 2004 14:47:33 -0300, Marco Antonio C. Santos [EMAIL PROTECTED] wrote: hehehe. CFOpen.org is a collaborative software development environment designed to facilitate the development of open source software for ColdFusion site build with PHP tools it's hard to believe On Wed, 7 Jul 2004 13:35:39 -0400, Joe Rinehart [EMAIL PROTECTED] wrote: I think it's sourceforge: http://sourceforge.net/projects/alexandria/ -joe - Original Message - From: Mark Drew [EMAIL PROTECTED] Date: Wed, 7 Jul 2004 18:46:42 +0200 Subject: cfopen.org To: CF-Talk [EMAIL PROTECTED] Does anybody know the name of the software that runs cfopen.org I am aware that it is PHP but I was looking to recomend this as a way to run internal projects. Thanks in advance -- Mark Drew mailto:[EMAIL PROTECTED] blog:http://cybersonic.blogspot.com/ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Coldfusion mx server trial version
Hello Something strange, I install a trial version. Codlfusion Administrator page says me You have 0 days remaining in your trial period. At the end of the trial, the software will automatically turn off Trial Mode. But I can always go under mx administration page and run my coldfusion pages. Can you explain me? Thanks Cordially Steff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Coldfusion mx server trial version
it automatically reverts to a single IP address developers edition after 30 days hence, coldfusion is free to dev on -- Original Message -- From: Steff [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Thu, 8 Jul 2004 09:49:45 +0200 Hello Something strange, I install a trial version. Codlfusion Administrator page says me You have 0 days remaining in your trial period. At the end of the trial, the software will automatically turn off Trial Mode. But I can always go under mx administration page and run my coldfusion pages. Can you explain me? Thanks Cordially Steff [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
XML CF5
Hi Can anyone point me to some articles or tutorials on using XML feeds with CF5? Thanks in advance! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Project Management System in CF
On Wednesday 07 Jul 2004 17:17 pm, Ciliotta, Mario wrote: Does anyone know of good project management system written in CF or maybe JSP. I could write my own but I just do not have the time as usually. Jira rocks. -- Tom Chiverton Advanced ColdFusion Programmer [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Coldfusion mx server trial version
I believe its single IP (localhost) and one or two other IP's allowed.It is full featured for development purposes. _ From: dave [mailto:[EMAIL PROTECTED] Sent: 08 July 2004 08:53 To: CF-Talk Subject: Re: Coldfusion mx server trial version it automatically reverts to a single IP address developers edition after 30 days hence, coldfusion is free to dev on -- Original Message -- From: Steff [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Thu, 8 Jul 2004 09:49:45 +0200 Hello Something strange, I install a trial version. Codlfusion Administrator page says me You have 0 days remaining in your trial period. At the end of the trial, the software will automatically turn off Trial Mode. But I can always go under mx administration page and run my coldfusion pages. Can you explain me? Thanks Cordially Steff _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Client variable in CFMX
Hi all, I am getting a weird problem with CFMX. I am trying to initialise a client variable called client.iamid in application.cfm however when I try to open the website in browser, the wesbite doesn't respond and goes to timeout. If I take the initialisation out, ir is ok. The weird thing is that if use any other client variable name, for example client.anotherVariable, it works fine. The reason I want to keep client.iamid is that it is used in quite a lot of places in the application and a big pain to change the name. Just a bit of background that I am using IIS/CFMX6.1 on Win2K. There is another website running on same machine and it is working fine (also uses it's own client.iamid and works perfect) Any thoughts?? please let me know if you need any more details here ... Many Thanks and appreciate your help, Cheers! Hassan. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFEclipse version 1.1.13 released
Why was the icon changed!?! Its 'orrible!!! _ From: Stephen Milligan [mailto:[EMAIL PROTECTED] Sent: 07 July 2004 21:34 To: CF-Talk Subject: RE: CFEclipse version 1.1.13 released *snip* All bug reports, support requests, etc. to this list. That should read: All bug reports, support requests etc. to the cfeclipse users list. You need to be a tigris.org member to submit bug reports. Membership is free and you won't get spammed (I haven't had any at least). Spike Stephen Milligan Code poet for hire http://www.spike.org.uk Do you cfeclipse? http://cfeclipse.tigris.org _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Blackstone Strong Typing? was Re: CFX_FileReadLn
I like strong typing, but I think ColdFusion isn't the place for it. ColdFusion has a history of trying to maintain backward compatibility. Also, one of the tenants of CF is that it is typeless language (validation portion of cffunction and cfargument aside)so I doubt we'd ever see it. Yeah, it'd allow neat stuff like method overloading, etc., but if you want to move to a strongly typed world, and truly take advantage of what that gives you, shouldn't you be using Java to begin with? IsNull() would be pretty handy, though!Ben Fanyone else from MACR readingcan get this on the list? :) -Joe [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Blackstone Strong Typing? was Re: CFX_FileReadLn
Joe Rinehart wrote: IsNull() would be pretty handy, though!Ben Fanyone else from MACR readingcan get this on the list? http://www.macromedia.com/go/wish Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cf-based discussion board
dave wrote: http://www.cfboards.com Interesting family site, seems to have nothing to do with message boards in cold fusion. www.stickshitsolutions.com/openForums DNS error for me. Maybe you should visit links before posting them to the list. - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cf-based discussion board
He meant to say http://www.stickshiftsolutions.com/ Stick Shift Solutions Hatton On Thu, 08 Jul 2004 07:39:19 -0400, Rick Root [EMAIL PROTECTED] wrote: dave wrote: http://www.cfboards.com Interesting family site, seems to have nothing to do with message boards in cold fusion. www.stickshitsolutions.com/openForums DNS error for me. Maybe you should visit links before posting them to the list. - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Screen and Print question.
I could be wrong but I thought I read somewhere awhile ago that IE makes another call.I know that one of my pages which uses the cfchart tag if I don't print the page within about 30 seconds all of the charts will change from what they are to a label saying that the chart expired refresh the page. __ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com/ http://www.euservices.com __ -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 07, 2004 8:27 PM To: CF-Talk Subject: Re: Screen and Print question. Totally within the browser -- no page request to the server. Some pages havea button to format for printing -- this usually is a request to the server for another page with the data formatted in plain text, with no (or limited) html tags. You could also do this client side with _javascript_. hth Dick On Jul 7, 2004, at 2:14 PM, Ian Skinner wrote: I have a bit of an off the wall question?If you are looking at a webpage, then print it from the browser, does this create to new call to the page from the server or does it print the current screen in the browser? -- Ian Skinner Web Programmer BloodSource file:///C: \Documents%20and%20Settings\iskinner\Application%20Data\Microsoft\Signa tures\www.BloodSource.org www.BloodSource.org http://www.BloodSource.orgSacramento Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice:This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cf-based discussion board
LOL, that's http://www.stickshiftsolutions.com/ - but, umm, it's kind of sh*t anyhow.I wrote this about 4 years ago as one of my first CF projects, and it's really, really weak. Full Disclosure:I used to own a stake in stickshiftSolutions, but currently have no relationship to the company. -joe [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cf-based discussion board
Though I have to say, as a spelling error goes, that almost made me ROFL. :-) Thanks for the suggestions so far, everyone. Rick, Keep up with the good work. Let's see if I can fit some of that work in. George On Thu, 8 Jul 2004 07:54:16 -0400, C. Hatton Humphrey [EMAIL PROTECTED] wrote: He meant to say http://www.stickshiftsolutions.com/ Stick Shift Solutions Hatton On Thu, 08 Jul 2004 07:39:19 -0400, Rick Root [EMAIL PROTECTED] wrote: dave wrote: http://www.cfboards.com Interesting family site, seems to have nothing to do with message boards in cold fusion. www.stickshitsolutions.com/openForums DNS error for me. Maybe you should visit links before posting them to the list. - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Screen and Print question.
Easy enough to check: Just brought up the CFMX graphing examplewith IE (Mac) Printing resulted in no new page requests! And the browser display of the chart does not expire after 5 minutes. You must have something else going on! Dick On Jul 8, 2004, at 4:53 AM, Bill Grover wrote: I could be wrong but I thought I read somewhere awhile ago that IE makes another call. I know that one of my pages which uses the cfchart tag if I don't print the page within about 30 seconds all of the charts will change from what they are to a label saying that the chart expired refresh the page. __ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com/ http://www.euservices.com __ -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 07, 2004 8:27 PM To: CF-Talk Subject: Re: Screen and Print question. Totally within the browser -- no page request to the server. Some pages have a button to format for printing -- this usually is a request to the server for another page with the data formatted in plain text, with no (or limited) html tags. You could also do this client side with _javascript_. hth Dick On Jul 7, 2004, at 2:14 PM, Ian Skinner wrote: I have a bit of an off the wall question? If you are looking at a webpage, then print it from the browser, does this create to new call to the page from the server or does it print the current screen in the browser? -- Ian Skinner Web Programmer BloodSource file:///C: \Documents%20and%20Settings\iskinner\Application%20Data\Microsoft\Signa tures\www.BloodSource.org www.BloodSource.org http://www.BloodSource.orgSacramento Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cf-based discussion board
I'd agree with Michael here, forums are not hard to build unless you want some pretty advanced features. Even I wrote my own, it's running at http://www.gameslave.co.uk/forum/index.cfm if you want a look. It runs on SQL server right now, but shouldn't be hard to port. I may be willing to hand out the code for free, dependant on interest. ( It would need tidying up a bit before I'd give it to you lot ;-) ) -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: 08 July 2004 02:01 To: CF-Talk Subject: Re: cf-based discussion board What features are you looking for? Honestly, a forums app is rather simple to build. CFPOP to read mail in, CFQUERY to store it, CFQUERY to get subscribers, CFMAIL to send it all out (I use something else, but the above it a pure CF solution). Everything else is commentary. Hi all, I know people are going to hate the repeat of this question. However a search of the lists did not get me any results. Are there any good open-source cf-based forum apps out there? Else I have to use phpBB which, other than the fact that it runs on PHP, is pretty nice. TIA, George _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Screen and Print question.
Thanks for the feedback!I'll look for some other possibilities. __ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com/ http://www.euservices.com __ -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED] Sent: Thursday, July 08, 2004 8:10 AM To: CF-Talk Subject: Re: Screen and Print question. Easy enough to check: Just brought up the CFMX graphing examplewith IE (Mac) Printing resulted in no new page requests! And the browser display of the chart does not expire after 5 minutes. You must have something else going on! Dick On Jul 8, 2004, at 4:53 AM, Bill Grover wrote: I could be wrong but I thought I read somewhere awhile ago that IE makes another call.I know that one of my pages which uses the cfchart tag if I don't print the page within about 30 seconds all of the charts will change from what they are to a label saying that the chart expired refresh the page. __ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail:mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW:http://www.euservices.com/ http://www.euservices.com __ -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 07, 2004 8:27 PM To: CF-Talk Subject: Re: Screen and Print question. Totally within the browser -- no page request to the server. Some pages havea button to format for printing -- this usually is a request to the server for another page with the data formatted in plain text, with no (or limited) html tags. You could also do this client side with _javascript_. hth Dick On Jul 7, 2004, at 2:14 PM, Ian Skinner wrote: I have a bit of an off the wall question?If you are looking at a webpage, then print it from the browser, does this create to new call to the page from the server or does it print the current screen in the browser? -- Ian Skinner Web Programmer BloodSource file:///C: \Documents%20and%20Settings\iskinner\Application%20Data\Microsoft\Signa tures\www.BloodSource.org www.BloodSource.org http://www.BloodSource.orgSacramento Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice:This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfmodule and mappings
On Thursday 08 Jul 2004 01:42 am, M. Casey wrote: cfmodule template=/CFIDE/Administrator/cffile_upload.cfm filefield=#thisField# destination=#UploadPath# nameconflict=makeunique I'm not sure user-space code should be calling templates in the CFIDE directory ... Could not find the included template /CFIDE/Administrator/cffile_upload.cfm. Note: If you wish to use an Does the case matter ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Find out table names and fields?
If you have an ODBC connection, or can make one, according to Microsoft's website there are catalog functions built into ODBC that returns database information.Here is the link to the info in MSDN: http://msdn.microsoft.com/library/default.asp?url=""> Might or might not help! __ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com/ http://www.euservices.com __ -Original Message- From: Stephen Milligan [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 07, 2004 5:25 PM To: CF-Talk Subject: RE: Find out table names and fields? You can also dig down to the java level and do this in a database independent way through the macromedia.jdbc.MacromediaDriver class if you need to support more than just MSSQL and MySQL. I have written a CFC that does this, but I haven't tested it on many systems. I'll try to get it tidied up and make it available once it's been tested a bit more thoroughly. Spike Stephen Milligan Code poet for hire http://www.spike.org.uk Do you cfeclipse? http://cfeclipse.tigris.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of S.Isaac Dealey Sent: Wednesday, July 07, 2004 1:13 PM To: CF-Talk Subject: Re: Find out table names and fields? Those are specific to MySQL - MS SQL uses standard tables, views and sql queries to expose its meta data. i.e. select * from information_schema.columns where table_name = 'mytablename' and the like s. isaac dealey214.823.9345 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 how do i dump the results to display on the page?Will this only work for mySQL, or for MS SQL as well? thanks! - Original Message - From: Barney Boisvert To: CF-Talk Sent: Wednesday, July 07, 2004 3:42 PM Subject: RE: Find out table names and fields? Sure, run these queries, and dump the result. `show databases` will list all databases you have access to via the DSN. `show tables` will list all tables in the database the DSN is connected to. `show tables in dbname` will list all tables in the named database. `explain tablename` will list the columns of the named table.You can use cross-database tables by saying dbname.tablename Cheers, barneyb -Original Message- From: brobborb [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 07, 2004 1:26 PM To: CF-Talk Subject: Find out table names and fields? Hey guys, I have a host that has no web admin support for mySQL.I mean, they have MySQL running, but no admin. At least thats what I'm told by my client. I was wondering if there was a way to extract the table names and fields using coldfusion instead.Would that be possible? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: question select web server when install coldfusionmx
On Wednesday 07 Jul 2004 15:26 pm, John Ho wrote: during the process of select web server then the page http://localhost/CFIDE/administrator/index.cfm can not found. But if I replace localhost by a machine name Can you 'ping localhost' ? What happens if you ping your machine name ? Sounds like a DNS problem, you can fix this by putting an entry in your hosts file, if all else fails. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cf-based discussion board
www.quilldesign.com qdforum GOOD STUFF! great to set up, easy to use! tony... On Thu, 8 Jul 2004 13:12:54 +0100, Craig Dudley [EMAIL PROTECTED] wrote: I'd agree with Michael here, forums are not hard to build unless you want some pretty advanced features. Even I wrote my own, it's running at http://www.gameslave.co.uk/forum/index.cfm if you want a look. It runs on SQL server right now, but shouldn't be hard to port. I may be willing to hand out the code for free, dependant on interest. ( It would need tidying up a bit before I'd give it to you lot ;-) ) -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: 08 July 2004 02:01 To: CF-Talk Subject: Re: cf-based discussion board What features are you looking for? Honestly, a forums app is rather simple to build. CFPOP to read mail in, CFQUERY to store it, CFQUERY to get subscribers, CFMAIL to send it all out (I use something else, but the above it a pure CF solution). Everything else is commentary. Hi all, I know people are going to hate the repeat of this question. However a search of the lists did not get me any results. Are there any good open-source cf-based forum apps out there? Else I have to use phpBB which, other than the fact that it runs on PHP, is pretty nice. TIA, George _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Find out table names and fields?
You should always query the sys tables with caution as there is no guarantee that the schema for these tables will stay the same in future releases of SQL Server. _ From: Bill Grover [mailto:[EMAIL PROTECTED] Sent: 08 July 2004 13:25 To: CF-Talk Subject: RE: Find out table names and fields? If you have an ODBC connection, or can make one, according to Microsoft's website there are catalog functions built into ODBC that returns database information.Here is the link to the info in MSDN: http://msdn.microsoft.com/library/default.asp?url=""> bccatalog_functions_in_odbc.asp Might or might not help! __ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail:mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW:http://www.euservices.com/ http://www.euservices.com __ -Original Message- From: Stephen Milligan [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 07, 2004 5:25 PM To: CF-Talk Subject: RE: Find out table names and fields? You can also dig down to the java level and do this in a database independent way through the macromedia.jdbc.MacromediaDriver class if you need to support more than just MSSQL and MySQL. I have written a CFC that does this, but I haven't tested it on many systems. I'll try to get it tidied up and make it available once it's been tested a bit more thoroughly. Spike Stephen Milligan Code poet for hire http://www.spike.org.uk Do you cfeclipse? http://cfeclipse.tigris.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of S.Isaac Dealey Sent: Wednesday, July 07, 2004 1:13 PM To: CF-Talk Subject: Re: Find out table names and fields? Those are specific to MySQL - MS SQL uses standard tables, views and sql queries to expose its meta data. i.e. select * from information_schema.columns where table_name = 'mytablename' and the like s. isaac dealey214.823.9345 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 how do i dump the results to display on the page?Will this only work for mySQL, or for MS SQL as well? thanks! - Original Message - From: Barney Boisvert To: CF-Talk Sent: Wednesday, July 07, 2004 3:42 PM Subject: RE: Find out table names and fields? Sure, run these queries, and dump the result. `show databases` will list all databases you have access to via the DSN. `show tables` will list all tables in the database the DSN is connected to. `show tables in dbname` will list all tables in the named database. `explain tablename` will list the columns of the named table.You can use cross-database tables by saying dbname.tablename Cheers, barneyb -Original Message- From: brobborb [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 07, 2004 1:26 PM To: CF-Talk Subject: Find out table names and fields? Hey guys, I have a host that has no web admin support for mySQL.I mean, they have MySQL running, but no admin. At least thats what I'm told by my client. I was wondering if there was a way to extract the table names and fields using coldfusion instead.Would that be possible? _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Find out table names and fields?
There's a cfx tag Claude Schneegans wrote for accessing that info with ODBC also. I'm guessing it uses COM. http://www.contentbox.com/claude/customtags/ODBCInfo/E/TestODBCInfo.cf m?p= Personally I'd love to know enough C to be able to write something in a CF5 compatible UDF that would get that info -- it'd fill in some gaps with CF5 and MS Access in the meta-data features in the onTap framework. But as of yet it remains a mystery - info on MS site is cryptic and I haven't had time to find or read any books that would explain it. If you have an ODBC connection, or can make one, according to Microsoft's website there are catalog functions built into ODBC that returns database information.Here is the link to the info in MSDN: http://msdn.microsoft.com/library/default.asp?url=""> /en-us/odbc/htm/odbccatalog_functions_in_odbc.asp Might or might not help! __ file:///E:/EUColor.gif Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com/ http://www.euservices.com __ -Original Message- From: Stephen Milligan [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 07, 2004 5:25 PM To: CF-Talk Subject: RE: Find out table names and fields? You can also dig down to the java level and do this in a database independent way through the macromedia.jdbc.MacromediaDriver class if you need to support more than just MSSQL and MySQL. I have written a CFC that does this, but I haven't tested it on many systems. I'll try to get it tidied up and make it available once it's been tested a bit more thoroughly. Spike Stephen Milligan Code poet for hire http://www.spike.org.uk Do you cfeclipse? http://cfeclipse.tigris.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of S.Isaac Dealey Sent: Wednesday, July 07, 2004 1:13 PM To: CF-Talk Subject: Re: Find out table names and fields? Those are specific to MySQL - MS SQL uses standard tables, views and sql queries to expose its meta data. i.e. select * from information_schema.columns where table_name = 'mytablename' and the like s. isaac dealey214.823.9345 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 how do i dump the results to display on the page?Will this only work for mySQL, or for MS SQL as well? thanks! - Original Message - From: Barney Boisvert To: CF-Talk Sent: Wednesday, July 07, 2004 3:42 PM Subject: RE: Find out table names and fields? Sure, run these queries, and dump the result. `show databases` will list all databases you have access to via the DSN. `show tables` will list all tables in the database the DSN is connected to. `show tables in dbname` will list all tables in the named database. `explain tablename` will list the columns of the named table.You can use cross-database tables by saying dbname.tablename Cheers, barneyb -Original Message- From: brobborb [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 07, 2004 1:26 PM To: CF-Talk Subject: Find out table names and fields? Hey guys, I have a host that has no web admin support for mySQL.I mean, they have MySQL running, but no admin. At least thats what I'm told by my client. I was wondering if there was a way to extract the table names and fields using coldfusion instead.Would that be possible? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Blackstone Strong Typing? was Re: CFX_FileReadLn
I second Joe's comments. -Adam - Original Message - From: Joe Rinehart [EMAIL PROTECTED] Date: Thu, 8 Jul 2004 06:48:25 -0400 Subject: Re: Blackstone Strong Typing? was Re: CFX_FileReadLn To: CF-Talk [EMAIL PROTECTED] I like strong typing, but I think ColdFusion isn't the place for it. ColdFusion has a history of trying to maintain backward compatibility. Also, one of the tenants of CF is that it is typeless language (validation portion of cffunction and cfargument aside)so I doubt we'd ever see it. Yeah, it'd allow neat stuff like method overloading, etc., but if you want to move to a strongly typed world, and truly take advantage of what that gives you, shouldn't you be using Java to begin with? IsNull() would be pretty handy, though!Ben Fanyone else from MACR readingcan get this on the list? :) -Joe [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
java objects and cfmx
cfset createObject('java', 'java.lang.Thread').sleep(1000) this code above, and various other snippets ive seen throughout time, have some cool things that happen, but where would one *LEARN* all of these cool little java things that we can do with cfmx? where would one start? thanks! -- tony Tony Weeg human. email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ Check out http://www.antiwrap.com to send websites to your friends. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfmodule and mappings
I'm not sure user-space code should be calling templates in the CFIDE directory ... Thanks for the reply, Tom. Ultimately, what we're trying to do, per this article from ColdFusion Developer's Journal http://www.sys-con.com/coldfusion/article.cfm?id=404, is put in place a work-around to allow limited access to CFFILE and other restricted tags on a server where they are disabled.By default, CFIDE\Administrator is the Unrestricted Tags Directory and the idea is that placing a carefully written tag there, one that only allows file uploads to be saved to the user's own directory, for example, would allow developers limited access to CFFILE while minimizing the security risks associated with the tag.It works great locally, but as soon as we try running it on the server, it can't even find the template, even though it's been properly mapped. Cases match in all places, so even if it is case-sensitive, that's not what's causing the problem. ~M [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: java objects and cfmx
I dunno... I started by learning Java. Not that I'm an expert on it or anything, but I can work with it. As of yet mostly for file-system manipulation. Though the book I started with (iirc the Java 2 Bible) wasn't a real great book. How are things with rolist btw? Tiff and I just moved back to Ft Lauderdale a few weeks ago. s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 cfset createObject('java', 'java.lang.Thread').sleep(1000) this code above, and various other snippets ive seen throughout time, have some cool things that happen, but where would one *LEARN* all of these cool little java things that we can do with cfmx? where would one start? thanks! -- tony Tony Weeg human. email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ Check out http://www.antiwrap.com to send websites to your friends. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Charting exponential numbers
George, Have you tried using a Log-Log chart? By using this type of chart each Y value changes exponentialy instead of linerarly-- the net effect forces the chart to be seen properly, instead of all of the values being close to 0. I'm not sure how to make this cart using CFCHART -- however, in Excel there is an option to create this type of chart. I am trying to chart (bar) some exponential values (minimum of 9. 156E-13, max of .00461935). The chart graphs out ok as far as the bars go; however, the values all appear as zero (0). Is it possible to chart values this low? Any ideas? Thanks, George - Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: java objects and cfmx
rolist? tiff? im guessing this was for someone else? :) tony On Thu, 8 Jul 2004 09:38:40 -0400, S. Isaac Dealey [EMAIL PROTECTED] wrote: I dunno... I started by learning Java. Not that I'm an expert on it or anything, but I can work with it. As of yet mostly for file-system manipulation. Though the book I started with (iirc the Java 2 Bible) wasn't a real great book. How are things with rolist btw? Tiff and I just moved back to Ft Lauderdale a few weeks ago. s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 cfset createObject('java', 'java.lang.Thread').sleep(1000) this code above, and various other snippets ive seen throughout time, have some cool things that happen, but where would one *LEARN* all of these cool little java things that we can do with cfmx? where would one start? thanks! -- tony Tony Weeg human. email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ Check out http://www.antiwrap.com to send websites to your friends. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfmodule and mappings
There might be a better way of handling that... On CFMX I'd just say use sandboxes. If you're still running CF5 this might work: http://www.intrafoundation.com/ihtk/secFile/ Granted that's for Windows and I'm coming into the middle of the conversation and don't know what os you're using. You can also google search for cfx_file and cfx_directory. hth s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 I'm not sure user-space code should be calling templates in the CFIDE directory ... Thanks for the reply, Tom. Ultimately, what we're trying to do, per this article from ColdFusion Developer's Journal http://www.sys-con.com/coldfusion/article.cfm?id=404, is put in place a work-around to allow limited access to CFFILE and other restricted tags on a server where they are disabled.By default, CFIDE\Administrator is the Unrestricted Tags Directory and the idea is that placing a carefully written tag there, one that only allows file uploads to be saved to the user's own directory, for example, would allow developers limited access to CFFILE while minimizing the security risks associated with the tag.It works great locally, but as soon as we try running it on the server, it can't even find the template, even though it's been properly mapped. Cases match in all places, so even if it is case-sensitive, that's not what's causing the problem. ~M [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: java objects and cfmx
You know what, you're right... sorry... I was thinking you were somebody I knew in Ft Lauderdale, but in retrospect, his name was Petruzzi. Doh! rolist? tiff? im guessing this was for someone else? :) tony On Thu, 8 Jul 2004 09:38:40 -0400, S. Isaac Dealey [EMAIL PROTECTED] wrote: I dunno... I started by learning Java. Not that I'm an expert on it or anything, but I can work with it. As of yet mostly for file-system manipulation. Though the book I started with (iirc the Java 2 Bible) wasn't a real great book. How are things with rolist btw? Tiff and I just moved back to Ft Lauderdale a few weeks ago. s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 cfset createObject('java', 'java.lang.Thread').sleep(1000) this code above, and various other snippets ive seen throughout time, have some cool things that happen, but where would one *LEARN* all of these cool little java things that we can do with cfmx? where would one start? thanks! -- tony Tony Weeg human. email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ Check out http://www.antiwrap.com to send websites to your friends. s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT - DHTML tab folder
Anyone know where I can get some snippet(s) of a DHTML tabbed document/text viewer? I found two on dynamic drive but not quite what I wanted Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: java objects and cfmx
Hey Tony, there was a thread yesterday that mentioned a book that I am ordering 'cause it sounded really good.It is a java for Cf developers book. The thread was named Learning Java for a CF Developer - a possible solution? I am in the same boat as you... Ray At 09:18 AM 7/8/2004, you wrote: cfset createObject('java', 'java.lang.Thread').sleep(1000) this code above, and various other snippets ive seen throughout time, have some cool things that happen, but where would one *LEARN* all of these cool little java things that we can do with cfmx? where would one start? thanks! -- tony Tony Weeg human. email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ Check out http://www.antiwrap.com to send websites to your friends. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT - DHTML tab folder
I'll be releasing a whole set of things like this as custom tags in the next week or two, want to do some testing :)? -joe [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: OT - DHTML tab folder
Yes please. Let me know. Robert O. -Original Message- From: Joe Rinehart [mailto:[EMAIL PROTECTED] Sent: Thursday, July 08, 2004 10:00 AM To: CF-Talk Subject: Re: OT - DHTML tab folder I'll be releasing a whole set of things like this as custom tags in the next week or two, want to do some testing :)? -joe _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT - DHTML tab folder
Ok - I'll hopefully email you a zip of all the components being built by monday.Includes a tab (horizontal or vertical), accordian pane, tree, and a multi-purpose container / window thing. - Original Message - From: Robert Orlini [EMAIL PROTECTED] Date: Thu, 8 Jul 2004 10:06:02 -0400 Subject: RE: OT - DHTML tab folder To: CF-Talk [EMAIL PROTECTED] Yes please. Let me know. Robert O. -Original Message- From: Joe Rinehart [mailto:[EMAIL PROTECTED] Sent: Thursday, July 08, 2004 10:00 AM To: CF-Talk Subject: Re: OT - DHTML tab folder I'll be releasing a whole set of things like this as custom tags in the next week or two, want to do some testing :)? -joe _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: question select web server when install coldfusionmx
Also try http://127.0.0.1 If that works I think it should be safe to add that IP address (localhost loopback) to the hosts file. On windows xp/2k that would be under %windir%\system32\drivers\etc\hosts -- Hugo Ahlenius - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: Thomas Chiverton [mailto:[EMAIL PROTECTED] | Sent: Thursday, July 08, 2004 14:29 | To: CF-Talk | Subject: Re: question select web server when install coldfusionmx | | On Wednesday 07 Jul 2004 15:26 pm, John Ho wrote: | during the process of select web server then the page | http://localhost/CFIDE/administrator/index.cfm can not | found. But if I | replace localhost by a machine name | | Can you 'ping localhost' ? | What happens if you ping your machine name ? | | Sounds like a DNS problem, you can fix this by putting an | entry in your hosts file, if all else fails. | | -- | Tom Chiverton | Advanced ColdFusion Programmer | | Tel: +44(0)1749 834997 | email: [EMAIL PROTECTED] | BlueFinger Limited | Underwood Business Park | Wookey Hole Road, WELLS. BA5 1AF | Tel: +44 (0)1749 834900 | Fax: +44 (0)1749 834901 | web: www.bluefinger.com | Company Reg No: 4209395 Registered Office: 2 Temple Back | East, Temple Quay, BRISTOL. BS1 6EG. | *** This E-mail contains confidential information for the | addressee only. If you are not the intended recipient, please | notify us immediately. You should not use, disclose, | distribute or copy this communication if received in error. | No binding contract will result from this e-mail until such | time as a written document is signed on behalf of the | company. BlueFinger Limited cannot accept responsibility for | the completeness or accuracy of this message as it has been | transmitted over public networks.*** | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT - DHTML tab folder
http://www.turnkey.to/ontap/docs/?doc=advanced/htlib admittedly, probably also not what you're looking for, but there it is. Anyone know where I can get some snippet(s) of a DHTML tabbed document/text viewer? I found two on dynamic drive but not quite what I wanted Robert O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT - DHTML tab folder
On Thursday 08 Jul 2004 14:59 pm, Joe Rinehart wrote: I'll be releasing a whole set of things like this as custom tags in the next week or two, want to do some testing :)? I'd like to too, if that is a general invite. I've just built something fairly basic in _javascript_, but it is quite hacky. It works by you creating a div for each pane called 'div0' 'div1' etc., and then internal copying them into a data structure, then using the nam attribute of those div's to draw tab buttons. When a tab button is clicked, it copies the content of the pane into the datastructure, and copies the new pane from the structure to the pane. It works, and is vaguly expandable, but yours may well be better :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Query of a query inconsistancies
Logically, they're different. You shouldn't get any results by moving the orderdate condition to the bottom query, because qryGetRepeatSales doesn't have a date column --- Todd [EMAIL PROTECTED] wrote: I have these 2 queries: cfquery datasource=#Application.Read# name=qryGetRepeatSales SELECT *, COUNT(*) AS totalcount, SUM(Cost) AS totalcost FROM orders, orderitems WHERE orders.OrderID = orderitems.OrderID AND OrderDate = '#DateFormat(StartTime, -mm-dd)#' GROUP BY UserID HAVING totalcount 1 /cfquery cfquery dbtype=query name=qrySubGetRepeatSales SELECT SUM(totalcost) AS totalcost, COUNT(totalcount) AS totalcount FROM qryGetRepeatSales /cfquery The problem I'm having is when the OrderDate line is in the top query, I get the correct results.If I move it to the bottom query, the totalcost and totalcount end up being 1 or 2 less.The date filter really needs to be in the bottom query.What am I missing? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT - DHTML tab folder
On Thursday 08 Jul 2004 15:22 pm, S. Isaac Dealey wrote: admittedly, probably also not what you're looking for, but there it Not for us at any rate - generating the tabs server side means we can't add tabs client side. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfmodule and mappings
There might be a better way of handling that... On CFMX I'd just say use sandboxes. According to my SysAdmin, sandboxes aren't an option since we're running CFMX but not the Enterprise version.Is that correct? Thanks! ~M [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: Crystal Reports (WAS: Absolute positioning in word)
Ok, now trying Crystal Reports but this project seems to be destined to drive me insane, I can't believe no one before me has had these problems! Now, the question: How does crystal reports want me to call tables from mysql?If I just use tablename then I get an error saying that test.tablename does not exist. I then assumed that is wanted a user name so I tried root.tablename but this doesn't exist either, as root is the only user on this dev box the table can't belong to any one else.In desperation I have also tried mylsam.tablename and sam.tablename and dbo.tablename but I could sit here trying random strings for ever and not hit the right one. Does anyone know how to do this? -- Jay -Original Message- From: Samuel Neff [mailto:[EMAIL PROTECTED] Sent: 01 July 2004 14:10 To: CF-Talk Subject: RE: Absolute positioning in word (WAS: CSS layer positioning) As I say in my presentation, not everything that can be done in Word can be recreated through HTML-Word.This appears to be one of those cases. When I create a Word doc with an absolutely positioned table and try to save it as HTML I get this error message from Word Tables with text wrapping and framed objects will become aligned with the beginning of the paragraph. Sam -- Blog:http://www.rewindlife.com Chart: http://www.blinex.com/products/charting -- -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 5:15 AM To: CF-Talk Subject: RE: Absolute positioning in word (WAS: CSS layer positioning) Hi Samuel, Firstly I have to say your original documents on serving word were most helpful. Now back to my problem, if I position a table in an absolute position on the page in word then save it as a doc file it works fine, however it is a binary file and therefore useless as a source of information. If I save it as an HTML document as you suggest it immediately moves the table into a relative position and looses its absolute position, this is also no good :-( A text box does seem to keep it's position ok, but generates so much html code it is hard to tell which bits I need and which I don't, is there any good documentation anywhere on this? -- Jay [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
initializing an array
Currently, I only know one way of initializing an array, but it seems kinda silly and inefficient. cfset deptArray=arrayNew(1) cfset deptArray[1]=Family Studies cfset deptArray[2]=Kinesiology cfset deptArray[3]=Public and Community Health In Actionscript, I can do myArray=newArray(Family Studies, Kinesiology, Public and Community Health), which is alot more efficient (in number of lines). I now have to do an array which more than 100 entries and I don't want 100 lines to initialize it.Is there a better way to do this in Cold Fusion?I'm creating this to loop through it's entries. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Screen and Print question.
To test this, create a CFM page that sends an email message.When browsing the page, it should send a single email message. Then, print the page to see if you get another email message or not. _ From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 07, 2004 4:29 PM To: CF-Talk Subject: Re: Screen and Print question. I think it might depend on which browser and what your browser cache settings are. I don't know what the rules are, though. Not any help, Jerry Johnson [EMAIL PROTECTED] 07/07/04 05:19PM Nope, no new request (afaik). The html is in memory and to the best of my knowledge from there it goes straight to the print spool/buffer. Or should if the browser developers did their job correctly. I have a bit of an off the wall question?If you are looking at a webpage, then print it from the browser, does this create to new call to the page from the server or does it print the current screen in the browser? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
WOT: MetaBase change in IIS 6.0
Hi all, Has anyone here tried to change the metaBase.xml file in IIS 6.0 (Win server 2003) and lived to tell about it? I am trying to change the website unique identifiers in the metabase to much lower numbers than they are presently. A distributed authentication ISAPI filter that runs on the server is having problems with the abnormally high values of these identifiers. I don't have access to the code on the filter, so I will have to fool around with the metabase and see if that works. Any pointers to resources would be much appreciated also. TIA, George [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT - DHTML tab folder
On Thursday 08 Jul 2004 14:59 pm, Joe Rinehart wrote: I'll be releasing a whole set of things like this as custom tags in the next week or two, want to do some testing :)? I'd like to too, if that is a general invite. I've just built something fairly basic in _javascript_, but it is quite hacky. It works by you creating a div for each pane called 'div0' 'div1' etc., and then internal copying them into a data structure, then using the nam attribute of those div's to draw tab buttons. When a tab button is clicked, it copies the content of the pane into the datastructure, and copies the new pane from the structure to the pane. It works, and is vaguly expandable, but yours may well be better :-) I'd be interested to know what your thoughts are on the tabset utilities in the onTap framework then. :) http://www.turnkey.to/ontap/docs/?doc=advanced/htlib Imo it would be difficult to make anything much more flexible or expandable. s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: dynamically generate page content without refresh a page
I think that is such a bad idea... why not just use the web like its meant to be used? That stuff over complicates life for little reward. Just my opinion. I wish web browsers supported some type of templating that hooked into XML files natively. That would be neat... but then again the web would become a big FileMaker Pro database. :0) Jon _ From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Sunday, October 21, 2001 4:04 PM To: CF-Talk Subject: RE: dynamically generate page content without refresh a page juat a question here, not so much on CF, but will like to do it on a CF page, how I can make a page dynamically generate its content without refresh a page as i have see this on some web site. for example, if i click on a button then the page will display a table with some data on it (of course without refresing the whole page again). is it possible? if yes, how technical is it? You can use _javascript_ to do this. You can't use CF, by itself. You can rewrite parts of a page using DHTML, or all of a page using document.write. If you need to exchange data with the server, you can use frames or pipes: http://www.depressedpress.com/DepressedPress/Content/ColdFusion/Essays/GIFAs Pipe/ (originally pointed out to the list by Dick Applebaum, if I recall correctly) Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[EMAIL PROTECTED]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFEclipse version 1.1.13 released
On Thu, 8 Jul 2004 11:27:59 +0100, Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] wrote: Why was the icon changed!?! Its 'orrible!!! Yes it is :-D, but someone brought it to our attention that using the little blue cf is ... well ... probably against the law. We never really thought about it but it's probably a trademark infringment so we are removing it as not to irriate others. We had to throw something out really quick and thats what happened, we'll most definally fix it in the next version. Any graphic artist wana create a cfml file, and dreamweaver icon (one that wont upset anyone)? If so please send it on over to us Cheers, Rob [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: initializing an array
cfset myArray = listtoarray(item1,item2,item3) You can of course use | or some other character to delimit the list if you need a comma in an item in your array. s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 Currently, I only know one way of initializing an array, but it seems kinda silly and inefficient. cfset deptArray=arrayNew(1) cfset deptArray[1]=Family Studies cfset deptArray[2]=Kinesiology cfset deptArray[3]=Public and Community Health In Actionscript, I can do myArray=newArray(Family Studies, Kinesiology, Public and Community Health), which is alot more efficient (in number of lines). I now have to do an array which more than 100 entries and I don't want 100 lines to initialize it.Is there a better way to do this in Cold Fusion?I'm creating this to loop through it's entries. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: XML CF5
On Thu, 8 Jul 2004 18:21:28 +1000, Paul Wilson [EMAIL PROTECTED] wrote: Can anyone point me to some articles or tutorials on using XML feeds with CF5? If you just want to use RSS in CF5 not really dig into it, there is a library on cflib.org that changes a RSS XML file into a query, and I am 90% sure ti works on CF5... it says it does http://www.cflib.org/udf.cfm?ID=813 if you want to learn about feeds, I'd just google it, they are not that hard and there should be tutorials a plenty Cheers, Rob -- ~The cfml plug-in for eclipse~ http://cfeclipse.tigris.org ~open source xslt IDE~ http://treebeard.sourceforge.net ~open source XML database~ http://ashpool.sourceforge.net [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Is there an example/tutorial on CFCs with CFLogin?
I had tried digging into this before I went on vacation, and now that I'm back, I'm finding that I'm back at square one and still a little confused on how exactly to use CFCs to create a nice, clean, CFC based basic CFlogin to protect a directory. I have an application that I wrote upon returning from figleaf last year that wasn't CFC based, but worked, and I've been wanting to turn it into a CFC based system for a while now, but parts of it just seem like I'm just not getting it. Is there a url someone can point to that gives a nice example of logging in a user using cfloginuser that's also CFC based? Specifically, I have questions about how to build the functions that perform the actual login once the user has passed the initial query and is deemed to be a valid login. I've looked on Macromedia and Ben's site, and I see CFC tutorials, but I don't see anything dealing with CFLogin and CFLoginuser that's CFC based. I wanna do this *right* and not half-assed. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Is there an example/tutorial on CFCs with CFLogin?
My question is - why do you want to do the cflogin _within_ the CFC? I typically use cflogin within my application.cfm files. My CFCs will handle stuff like, authentication, getUserRoles, etc, but the actual mechanics of prompt for login use cflogin if authenticated are handled by the Application.cfm file. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: dynamically generate page content without refresh a page
Google's GMail has some funky things going on with it.It looks like they use some JS functions to basically write the entire page on each click/request- Tyler _ From: Jon Block [mailto:[EMAIL PROTECTED] Sent: Thursday, July 08, 2004 10:49 AM To: CF-Talk Subject: RE: dynamically generate page content without refresh a page I think that is such a bad idea... why not just use the web like its meant to be used? That stuff over complicates life for little reward. Just my opinion. I wish web browsers supported some type of templating that hooked into XML files natively. That would be neat... but then again the web would become a big FileMaker Pro database. :0) Jon _ From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Sunday, October 21, 2001 4:04 PM To: CF-Talk Subject: RE: dynamically generate page content without refresh a page juat a question here, not so much on CF, but will like to do it on a CF page, how I can make a page dynamically generate its content without refresh a page as i have see this on some web site. for example, if i click on a button then the page will display a table with some data on it (of course without refresing the whole page again). is it possible? if yes, how technical is it? You can use _javascript_ to do this. You can't use CF, by itself. You can rewrite parts of a page using DHTML, or all of a page using document.write. If you need to exchange data with the server, you can use frames or pipes: http://www.depressedpress.com/DepressedPress/Content/ColdFusion/Essays/GIFAs Pipe/ (originally pointed out to the list by Dick Applebaum, if I recall correctly) Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[EMAIL PROTECTED]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists _ _ [HYPERLINK http://www.houseoffusion.com/lists.cfm/link=t:4Todays Threads] [HYPERLINK http://www.houseoffusion.com/lists.cfm/link=i:4:169729This Message] [HYPERLINK http://www.houseoffusion.com/lists.cfm/link=s:4Subscription] [HYPERLINK http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=3902.3642.4Fast Unsubscribe] [HYPERLINK http://www.houseoffusion.com/signin/User Settings] [HYPERLINK https://www.paypal.com/cgi-bin/webscr?amount=item_name=House+of+Fusionbus iness=donations%40houseoffusion.comundefined_quantity=cmd=_xclickDonation s and Support] _ HYPERLINK http://www.houseoffusion.com/banners/view.cfm?bannerid=34 \n --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.711 / Virus Database: 467 - Release Date: 6/25/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.711 / Virus Database: 467 - Release Date: 6/25/2004 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Blackstone Strong Typing? was Re: CFX_FileReadLn
On Jul 8, 2004, at 3:48 AM, Joe Rinehart wrote: I like strong typing, but I think ColdFusion isn't the place for it. I would like to se it as optional, maybe within a block of code or a CFC.In fact, a CFC is a very logical place for strong typing (and a lot of other things that would make CF more Java friendly). ColdFusion has a history of trying to maintain backward compatibility. Yes and no -- each major release of CF has had compelling and valuable new features -- not to use these when needed, is a failure to exploit the tool.If a user wants to code an app that runs on CFMX 6.1 as well as 4.5, he can do what he does today -- not use the features that are not backward compatible. But, as Apple learned, sooner or later you must break the chains of the past and use the features available -- else we'd all be coding Octal Absolute. Also, one of the tenants of CF is that it is typeless language (validation portion of cffunction and cfargument aside)so I doubt we'd ever see it. So, where necessary in CF, it is a good thing -- I just would like to see it optional for other parts of the language Yeah, it'd allow neat stuff like method overloading, etc., but if you want to move to a strongly typed world, and truly take advantage of what that gives you, shouldn't you be using Java to begin with? 1) Don't you get overloading capability with the JavaCast() function -- at least when you drop into Java. 2) When coding with cfscript, say some CFCs and using some CFObjects -- the code begins to strongly resemble Java source without the definitions/terms of class, public, static, void, etc.(Of course, you need to drop into cfmlwith (/cfscript) to get the full advantages of CF's query class, loop class and output class) Aside:When can we expect CF language support for ="" !=, =, = ? 3) My gut tells me that there is a need for a middle ground between a procedural language like CFML and an OOP language like Java. 4) A recent article suggested that CF was a way to rapidly get a (web) application running, until it could be programmed Right in Java. IMO, this is folly -- there will always be more pressure to implement new apps, than to expend the resource to recode existing apps). 5) Aren't the people developing/using machii, in reality, trying reforge the use of CF (and other languages) into something more like Java 6) Wouldn't it be beneficial to everyone, MACR NA included, If the CF Language were extended to bemore Java-like?This is rhetorical, because, in fact, this has already occurred with the aforementioned CFCs. 7) I am in the process of learning Java, as a means to an end.I doubt that I will ever become a Java programmer, nor take full advantage of the language (similar to my abilities with ASP, PHP, etc.).But here's an interesting question:Would I be better served, trying to bend my CF code to be more Java-like; or to write procedural code in Java and (mostly) ignore its OOP capabilities? Dick IsNull() would be pretty handy, though! Ben Fanyone else from MACR readingcan get this on the list? :) You also need:cfset x = NULLl / -Joe [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: java objects and cfmx
aight cool...let me know what you think...im VERY interested in this, very. i wonder, does mm have any sessions like this planned for MAX2004? tw On Thu, 08 Jul 2004 09:57:08 -0400, Ray Champagne [EMAIL PROTECTED] wrote: Hey Tony, there was a thread yesterday that mentioned a book that I am ordering 'cause it sounded really good.It is a java for Cf developers book. The thread was named Learning Java for a CF Developer - a possible solution? I am in the same boat as you... Ray At 09:18 AM 7/8/2004, you wrote: cfset createObject('java', 'java.lang.Thread').sleep(1000) this code above, and various other snippets ive seen throughout time, have some cool things that happen, but where would one *LEARN* all of these cool little java things that we can do with cfmx? where would one start? thanks! -- tony Tony Weeg human. email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ Check out http://www.antiwrap.com to send websites to your friends. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: initializing an array
cfset myArray = listtoarray(item1,item2,item3) You can of course use | or some other character to delimit the list if you need a comma in an item in your array. Thanks Isaac.This worked great. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Export to MS Word and keep formatting
I am exporting a query to Word. Is it possible to keep my style sheet settings that I have selected and send them to Word to save time from reformatting text font and size in Word? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Find out table names and fields?
There's a cfx tag Claude Schneegans wrote for accessing that info with ODBC also. I'm guessing it uses COM. Exact! ;-) The tag is CFX_ODBCInfo, it does not use COM, it is pure C and it uses the ODBC API. Personally I'd love to know enough C to be able to write something in a CF5 compatible UDF that would get that info This is exactly the purpose od CFX_ODBCInfo, it is CF 5 and CFMX compatible. By the the way, I'm presently working on version 2 which has a couple of new features like primary and foreign keys (although these are not available for Access), Procedures and procedure columns, compact database (Access only), I know that some of these informations are more or less available directly by SQL for some type of datasources, or with some Java programming in CFMX, but CFX_ODBCInfo has the advantage of presenting everything in one convenient and compatible package for any type of ODBC datasource. It should be released soon. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Is there an example/tutorial on CFCs with CFLogin?
My question is - why do you want to do the cflogin _within_ the CFC? I typically use cflogin within my application.cfm files. My CFCs will handle stuff like, authentication, getUserRoles, etc, but the actual mechanics of prompt for login use cflogin if authenticated are handled by the Application.cfm file. Do you mind if we discuss this for a little while? I have a lot of conceptual questions that maybe you could answer. I'll even paste my current application.cfm file that I've been using for a while, which I seem to recall you kinda helped me with last year. For instance: I'm not *sure* why I want to do cflogin inside the CFC. For one, I was wanting to create something that, with minimal effort, could be used with Flash Remoting. I'm creating an application that's going to require some basic security (IE, you gotta be logged in to use it) and eventually I was wanting to springboard into creating it as a Flash Remoting Application down the road. In fact, I was hoping to learn Flash Remoting using this as a starting point, but first wanted to get it up and running as a CF solution. Right now, I'm concentrating on the logging in...and I'm not worried about the actual functionality of the application. That can come later. I just want to make sure I can CFC-ify what I've currently been using in a best practices manner. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: java objects and cfmx
will do At 11:10 AM 7/8/2004, you wrote: aight cool...let me know what you think...im VERY interested in this, very. i wonder, does mm have any sessions like this planned for MAX2004? tw On Thu, 08 Jul 2004 09:57:08 -0400, Ray Champagne [EMAIL PROTECTED] wrote: Hey Tony, there was a thread yesterday that mentioned a book that I am ordering 'cause it sounded really good.It is a java for Cf developers book. The thread was named Learning Java for a CF Developer - a possible solution? I am in the same boat as you... Ray At 09:18 AM 7/8/2004, you wrote: cfset createObject('java', 'java.lang.Thread').sleep(1000) this code above, and various other snippets ive seen throughout time, have some cool things that happen, but where would one *LEARN* all of these cool little java things that we can do with cfmx? where would one start? thanks! -- tony Tony Weeg human. email: tonyweeg [at] gmail [dot] com blog: http://www.revolutionwebdesign.com/blog/ Check out http://www.antiwrap.com to send websites to your friends. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CF and MS Word docs
Is there an easy way from Cold Fusion to get the meta data about a word DOC or RTF file? As in, is there a custom tag that could take a filename (or filelist) and get back a query of the metadata in a word DOC file? If not, are there Java libs that handle this? (PS What happened to cfcomet.com?) Thanks, Jerry Johnson [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
cfcontent - what am I missing?
I have searched the archives here, books, and forums at MM.My client says that the download I gave her works for maybe half of her customers. Others are getting .cfm files, or possibly something else that they can't use.That is just not acceptable, you know?Here's the relevant code: cfoutputCFHEADER NAME=Content-Disposition VALUE=attachment; #variables.attach# CFCONTENT TYPE=application/x-zip-compressed FILE=#form.userfile# deletefile=no/cfoutput Am I missing an important clue, or is CF just the wrong thing to use for downloads?My client is selling downloadable products, so this is crucial. Thanks, Carol Chandler [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: WOT: MetaBase change in IIS 6.0
Never mind, found the solution to this problem. For those who want to know how to solve it, here are some links (really long urls coming up): 1. http://tinyurl.com/2kbjb (MS knowledge base) 2. http://tinyurl.com/3bwxh (other) 3. http://tinyurl.com/2szd2 (MS knowledge base, for upgrading servers, I think) Regards, George Hi all, Has anyone here tried to change the metaBase.xml file in IIS 6.0 (Win server 2003) and lived to tell about it? I am trying to change the website unique identifiers in the metabase to much lower numbers than they are presently. A distributed authentication ISAPI filter that runs on the server is having problems with the abnormally high values of these identifiers. I don't have access to the code on the filter, so I will have to fool around with the metabase and see if that works. Any pointers to resources would be much appreciated also. TIA, George [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Is there an example/tutorial on CFCs with CFLogin?
I'm not *sure* why I want to do cflogin inside the CFC. For one, I was wanting to create something that, with minimal effort, could be used with Flash Remoting. I'm creating an application that's going to require some basic security (IE, you gotta be logged in to use it) and eventually I was wanting to springboard into creating it as a Flash Remoting Application down the road. In fact, I was hoping to learn Flash Remoting using this as a starting point, but first wanted to get it up and running as a CF solution. [deletia] I believe - and someone could correct me - that you could still count on Application.cfm when using Flash Remoting. I haven't done any FR in a while though. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Coldfusion Java Integration
Hello I was just wondering if anyone out there has ever integrated cold fusion with the paymentech orbital gateway either with their Java SDK or XML API? I could really use some help with this Here is the link to SDK and XML api http://www.paymentech.net/download/index_page.jsp Any help would be appriciated Dave [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
NEQ
I have a DB where I insert text from a form.If the text is blank, I still go through and insert it.I thought I could check on it in the display area with: CFOutput query=people_search cfset the_image = 'img src=""> cfif imagePath NEQ cfset the_image = 'img src=""> /cfif The NEQ doesn't seem to work in this situation.It doesn't like cfif imagePath NEQ NULL.So what should I do to see if this field is empty or not? thanks. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: undocumented Functions etc
Another good source for undocumented functionality is: http://www.cfdev.com/mx/undocumentation/ Adam H Eric Jones wrote: Does anyone have any links etc that talk more about the undocumented CF functions etc. stuff like cfusion_encrypt / cfusion_decrypt? thanks in advance. ERJ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Export to MS Word and keep formatting
If style sheets do not render correctly when exporting to word format, have you tried plain old html formatting? Just an idea... -Jordan James Taavon wrote: I am exporting a query to Word. Is it possible to keep my style sheet settings that I have selected and send them to Word to save time from reformatting text font and size in Word? -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: NEQ
Try... cfset the_image = 'img src=""> cfif Len(Trim(imagePath)) NEQ cfset the_image = 'img src=""> /cfif HTH, Mike I have a DB where I insert text from a form.If the text is blank, I still go through and insert it.I thought I could check on it in the display area with: CFOutput query=people_search cfset the_image = 'img src=""> cfif imagePath NEQ cfset the_image = 'img src=""> /cfif The NEQ doesn't seem to work in this situation.It doesn't like cfif imagePath NEQ NULL.So what should I do to see if this field is empty or not? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: NEQ
I generally use len(trim(variable)) to test it it's empty (or is blank space). --Ben Daniel Kessler wrote: I have a DB where I insert text from a form.If the text is blank, I still go through and insert it.I thought I could check on it in the display area with: CFOutput query=people_search cfset the_image = 'img src=""> cfif imagePath NEQ cfset the_image = 'img src=""> /cfif The NEQ doesn't seem to work in this situation.It doesn't like cfif imagePath NEQ NULL.So what should I do to see if this field is empty or not? thanks. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: NEQ
You could try something like cfif Len(imagePath) GT 0 This is a multi-part message in MIME format. I have a DB where I insert text from a form.If the text is blank, I still go through and insert it.I thought I could check on it in the display area with: CFOutput query=people_search cfset the_image = 'img src=""> cfif imagePath NEQ cfset the_image = 'img src=""> /cfif The NEQ doesn't seem to work in this situation.It doesn't like cfif imagePath NEQ NULL.So what should I do to see if this field is empty or not? thanks. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: cfcontent - what am I missing?
Carol: A few things... 1) You don't need the CFOUTPUT tags around your CFHEADER and CFCONTENT tags.Attribute values within CF tags always parse variables without the need for a CFOUTPUT tag. 2) In your CFHEADER tag, change the VALUE attribute from attachment; #variables.attach# to attachment; filename=#variables.attach#.Note the addition of the filename= portion.And, you didn't say it in your email, but I'm assuming that the variables.attach variable contains the filename that you would like the user to see. HTH -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Carol Chandler [mailto:[EMAIL PROTECTED] Sent: Thursday, July 08, 2004 11:45 AM To: CF-Talk Subject: cfcontent - what am I missing? I have searched the archives here, books, and forums at MM.My client says that the download I gave her works for maybe half of her customers. Others are getting .cfm files, or possibly something else that they can't use. That is just not acceptable, you know?Here's the relevant code: cfoutputCFHEADER NAME=Content-Disposition VALUE=attachment; #variables.attach# CFCONTENT TYPE=application/x-zip-compressed FILE=#form.userfile# deletefile=no/cfoutput Am I missing an important clue, or is CF just the wrong thing to use for downloads?My client is selling downloadable products, so this is crucial. Thanks, Carol Chandler [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: cfcontent - what am I missing?
Any particular reason there are CFOUTPUT tags around those? It's possible that those tags are adding unecessary white space to the output, and confusing some browsers as to if they're getting a web page or a file. Has your client been able to ask her customers what browsers they're using, etc? Version numbers? OS's? Knowing that information would be exctremely helpful in figuring out what the problem is. HTH, Jordan Carol Chandler wrote: I have searched the archives here, books, and forums at MM.My client says that the download I gave her works for maybe half of her customers. Others are getting .cfm files, or possibly something else that they can't use.That is just not acceptable, you know?Here's the relevant code: cfoutputCFHEADER NAME=Content-Disposition VALUE=attachment; #variables.attach# CFCONTENT TYPE=application/x-zip-compressed FILE=#form.userfile# deletefile=no/cfoutput Am I missing an important clue, or is CF just the wrong thing to use for downloads?My client is selling downloadable products, so this is crucial. Thanks, Carol Chandler -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CF 5.0 CFMail Random Email Failures
I can't figure out where I need to look for this problem.I have several pages within our internet that send notification to 3 or 4 people.Most of the time, these work, but occasionally they don't. I created a very simple CFMail page: cfmail from=[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] to=[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] subject=Test Mail Server This is some test mail on the production box. /cfmail I open this page in a browser and refresh my screen 4 or 5 times.Three or so of the emails will come through, but the rest drop into the undelivered folder.The mail log shows these different error messages, very arbitrarilyit will switch between them but the first one comes up the most often. Failed to send the spooled mail file, C:\CFusion\Mail\spool\135.cfmail. SMTP server replied Need MAIL before RCPT Failed to send the spooled mail file, C:\CFusion\Mail\spool\132.cfmail. SMTP server replied Need MAIL command Failed to send the spooled mail file, C:\CFusion\Mail\spool\13B.cfmail. SMTP server replied Command unrecognized: Content-type: text/plain Anyone have any ideas where to start looking to correct this problem? _ Kim Mayhall Senior Developer The Garrigan Lyman Group http://www.glg.com/ www.glg.com office: 206.223.5548 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: NEQ
If you are positive it is blank within the DB then I would check to make sure it does not have any blank spaces in it.Something like: cfif Len(Trim(imagePath)) cfset the_image = 'img src=""> /cfif --aaron On Thu, 8 Jul 2004 11:56:46 -0400, Daniel Kessler [EMAIL PROTECTED] wrote: I have a DB where I insert text from a form.If the text is blank, I still go through and insert it.I thought I could check on it in the display area with: CFOutput query=people_search cfset the_image = 'img src=""> cfif imagePath NEQ cfset the_image = 'img src=""> /cfif The NEQ doesn't seem to work in this situation.It doesn't like cfif imagePath NEQ NULL.So what should I do to see if this field is empty or not? thanks. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: NEQ
0 not here... Len(Trim(imagePath)) NEQ Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Is there an example/tutorial on CFCs with CFLogin?
I'm not *sure* why I want to do cflogin inside the CFC. For one, I was wanting to create something that, with minimal effort, could be used with Flash Remoting. I'm creating an application that's going to require some basic security (IE, you gotta be logged in to use it) and eventually I was wanting to springboard into creating it as a Flash Remoting Application down the road. In fact, I was hoping to learn Flash Remoting using this as a starting point, but first wanted to get it up and running as a CF solution. [deletia] I believe - and someone could correct me - that you could still count on Application.cfm when using Flash Remoting. I haven't done any FR in a while though. Really? Okay then. So what you're saying is, in the following example: cflogin !--- Then, you're not logged in, so we check for the cookie --- cfif NOT isDefined(COOKIE.LoginUN) !--- If the cookie isn't defined, then check for the form variables --- cfif IsDefined(FORM.LoginPassWord) AND IsDefined(FORM.LoginUserName) !--- If form variables are found, step into here and start looking for the logging in user --- cfquery name=FormLogin datasource=#Application.Dsn# SELECT * FROM tblLogin WHERE (tblLogin.UserName = '#FORM.LoginUserName#') AND (tblLogin.PassWord = #FORM.LoginPassWord#) /cfquery !--- If the RecordCount is 1, log in the user --- cfif FormLogin.RecordCount EQ 1 !--- Log Them In --- cfloginuser name=#FormLogin.OwnerFirstName# #FormLogin.OwnerLastName# password=#FormLogin.PassWord# roles=#FormLogin.Role# !--- Check to see if they checked the SaveInfo checkbox and if so, set it to their Primary UserID ID --- cfif isDefined(FORM.SaveInfo) cfcookie name=LoginUN value=#FormLogin.UserName# expires=never cfcookie name=LogInPW value=#FormLogin.PassWord# expires=never /cfif !--- Setting that Redirect Flag since I stepped in here and got logged in --- cfset RedirectFlag = 1 !--- Then redirect to protected index page --- cfelseif FormLogin.RecordCount EQ 0 cfset ErrorMessage = 1 /cfif /cfif !--- The form variables weren't found nor was a cookie found, so you're not logged in and nothing happens --- cfelseif isDefined(COOKIE.LoginUN) !--- Else the cookie WAS found, so we'll step in here and take the cookie's CPRLogInID value to log in --- cfquery name=CookieLogin datasource=#Application.dsn# SELECT * FROM tblLogin WHERE (tblLogin.UserName = '#COOKIE.LoginUN#') AND (tblLogin.PassWord = #COOKIE.LogInPW#) /cfquery !--- If the RecordCount is 1, log in the user --- cfif CookieLogin.RecordCount EQ 1 cfloginuser name=#CookieLogin.OwnerFirstName# #CookieLogin.OwnerLastName# password=#CookieLogin.PassWord# roles=#CookieLogin.Role# !--- Setting that Redirect Flag since I stepped in here and got logged in --- cfset RedirectFlag = 1 cfelseif CookieLogin.RecordCount EQ 0 cfset ErrorMessage = 1 /cfif /cfif /cflogin Which portions would I want to use CFCs for? This is what I'm most fuzzy on. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Is there an example/tutorial on CFCs with CFLogin?
So what you're saying is, in the following example: cflogin !--- Then, you're not logged in, so we check for the cookie --- cfif NOT isDefined(COOKIE.LoginUN) [deletia] /cfif /cfif /cflogin Which portions would I want to use CFCs for? This is what I'm most fuzzy on. I'd probably just use it for the authentication query. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Is there an example/tutorial on CFCs with CFLogin?
So what you're saying is, in the following example: cflogin !--- Then, you're not logged in, so we check for the cookie --- cfif NOT isDefined(COOKIE.LoginUN) [deletia] /cfif /cfif /cflogin Which portions would I want to use CFCs for? This is what I'm most fuzzy on. I'd probably just use it for the authentication query. That's it? That's easy! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: java objects and cfmx
On Jul 8, 2004, at 8:10 AM, Tony Weeg wrote: Hey Tony, there was a thread yesterday that mentioned a book that I am ordering 'cause it sounded really good. It is a java for Cf developers book. The thread was named Learning Java for a CF Developer - a possible solution? I am in the same boat as you... It is available on O'Reilly Safari, so you can read it online -- I just put it on my bookshelf. But you can check it out for yourself -- Safari has 14 day free trial. http://safari.oreilly.com/ HTH Dick You can't wait for inspiration. You have to go after it with a club. - Jack London - [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Is there an example/tutorial on CFCs with CFLogin?
cflogin !--- Then, you're not logged in, so we check for the cookie --- cfif NOT isDefined(COOKIE.LoginUN) [deletia] /cfif /cfif /cflogin Which portions would I want to use CFCs for? This is what I'm most fuzzy on. I'd probably just use it for the authentication query. That's it? That's easy! Mind you that was just a quick check. There could be other areas that would be appropriate for a CFC. In general, the mechanics of security (check for a certain folder, apply to all, check form fields coming in), make more sense to me in the Application.cfm file, whereas the handling of these checks (he passed in admin/admin, does that authenticate) make more sense in a CFC. I'm sure folks could come up with good examples of where I would be wrong about the above. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT: Crystal Reports (WAS: Absolute positioning in word)
What version of Crystal Reports Developer are you using, 8, 8.5, 9 or 10? What driver are you using in Crystal Reports, a standard ODBC, or a MySQL specific? Jason [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: NEQ
NEQ is working as it should.The problem is that imagepath might have some spaces in it.So you must trim it. use this instead CFIF trim(imagepath) NEQ - Original Message - From: Daniel Kessler To: CF-Talk Sent: Thursday, July 08, 2004 10:56 AM Subject: NEQ I have a DB where I insert text from a form.If the text is blank, I still go through and insert it.I thought I could check on it in the display area with: CFOutput query=people_search cfset the_image = 'img src=""> cfif imagePath NEQ cfset the_image = 'img src=""> /cfif The NEQ doesn't seem to work in this situation.It doesn't like cfif imagePath NEQ NULL.So what should I do to see if this field is empty or not? thanks. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Blackstone Strong Typing? was Re: CFX_FileReadLn
One of the avowed tenets of Blackstone is to go back to CF's roots -- a simple RAD tool that allows fast everyman productivity out of the box.Seems like strong typing goes in the other direction. Just an observation. -- --Matt Robertson-- MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: java objects and cfmx
you know, i tried to register for that site, back when you first mentioned it like 2 weeks ago, and i couldnt register... anyone else with the same issue? tony On Thu, 8 Jul 2004 09:35:44 -0700, Dick Applebaum [EMAIL PROTECTED] wrote: On Jul 8, 2004, at 8:10 AM, Tony Weeg wrote: Hey Tony, there was a thread yesterday that mentioned a book that I am ordering 'cause it sounded really good.It is a java for Cf developers book. The thread was named Learning Java for a CF Developer - a possible solution? I am in the same boat as you... It is available on O'Reilly Safari, so you can read it online -- I just put it on my bookshelf. But you can check it out for yourself -- Safari has 14 day free trial. http://safari.oreilly.com/ HTH Dick You can't wait for inspiration. You have to go after it with a club. - Jack London - [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: JRUN Error
Dave, Yes it is a very generic error indeed! I have both examined the logs, AND sent them to (paid) MM support. They were stumped. The logs say nothing. The only other symptom we notice is that we cannot start and stop the MM/JRUN windows services, instead we restart the server. I'd say this is a specific server error, but we get it on another web server also (our site is load balanced). It doesn't appear on both sites at the same time, unless the DB server (separate machine) shuts down. Thanks for the follow up. David Hello, if anyone can lend some assistance, I am at my wits That's a very generic error. Have you examined your JRun and CFMX log files? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: initializing an array
is it a list, you could loop through the list, populating the [1] with [i] as the index? tony On Thu, 8 Jul 2004 10:39:18 -0400, Daniel Kessler [EMAIL PROTECTED] wrote: Currently, I only know one way of initializing an array, but it seems kinda silly and inefficient. cfset deptArray=arrayNew(1) cfset deptArray[1]=Family Studies cfset deptArray[2]=Kinesiology cfset deptArray[3]=Public and Community Health In Actionscript, I can do myArray=newArray(Family Studies, Kinesiology, Public and Community Health), which is alot more efficient (in number of lines). I now have to do an array which more than 100 entries and I don't want 100 lines to initialize it.Is there a better way to do this in Cold Fusion?I'm creating this to loop through it's entries. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: JRUN Error
The only other symptom we notice is that we cannot start and stop the MM/JRUN windows services, instead we restart the server. Can you successfully run CFMX/JRun from the command line as an application? It doesn't appear on both sites at the same time, unless the DB server (separate machine) shuts down. Have you upgraded the database drivers to the latest version? Have you tried vendor-specific database drivers? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: NEQ
it's marginal, but boolean comparison (cfif len(trim(variable))) is generally faster than string (cfif trim(variable) neq ) and is (in some places) considered a best practice. -joe [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT - DHTML tab folder
Hmmm... you know, that raises a good point... Not one I have time to work on right now, but there probably is a way to allow that same tab system to accept modifications to the tab-set on the client after the tabs have been generated. It would require a significant amount of work to accomplish tho, so I'll have to back-burner it for now. Right now it disables the active tab by setting style.display='none' on a predesignated set of div's, so I'd have to create some js objects and arrays on the page to support dynamic changes... On Thursday 08 Jul 2004 15:22 pm, S. Isaac Dealey wrote: admittedly, probably also not what you're looking for, but there it Not for us at any rate - generating the tabs server side means we can't add tabs client side. s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: initializing an array
cfset myArray = listtoarray(item1,item2,item3) You can of course use | or some other character to delimit the list if you need a comma in an item in your array. Thanks Isaac.This worked great. Glad I could help. :) s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: JRUN Error
David, We, too, are experiencing this error. After many, many hours with paid tech support at MM we basically ended up nowhere (which is why i've beem learning asp.net lately) The problem with the logs is they show a typical http 503 (client disconnect) error when the jrun error occurs, but that's not what's happening. We have a very fast app, no com objects, no special external applications other than cfexecute calls to imagemagick, no client variables, using MS Sql DB, just nothing special really, other than a lot of traffic. We did actually have limited success cutting down the size of each user's session, and of course better database drivers help everything, but we still have this problem. One thing you can do is edit the connector config file, jrun.ini. The commented line #errorurl can point to an html page (relative to the web root). Now where you would normally see could not connect to jrun, you can have your own message. It's a hack, and doesn't actually fix any problems, but will look friendlier. -nathan strutz David O Malley wrote: Dave, Yes it is a very generic error indeed! I have both examined the logs, AND sent them to (paid) MM support. They were stumped. The logs say nothing. The only other symptom we notice is that we cannot start and stop the MM/JRUN windows services, instead we restart the server. I'd say this is a specific server error, but we get it on another web server also (our site is load balanced). It doesn't appear on both sites at the same time, unless the DB server (separate machine) shuts down. Thanks for the follow up. David Hello, if anyone can lend some assistance, I am at my wits That's a very generic error. Have you examined your JRun and CFMX log files? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: java objects and cfmx
We have a subscription and it doesn't show up at all, oddly enough. I can see the preview online if I don't go through our login. Are you actually see the whole book (what I see says: This is a Preview... and cuts off half the text on each section). It is available on O'Reilly Safari, so you can read it online -- I just put it on my bookshelf. But you can check it out for yourself -- Safari has 14 day free trial. http://safari.oreilly.com/ HTH [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: NEQ
hey everyone, thanks.I appreciate the help. it's marginal, but boolean comparison (cfif len(trim(variable))) is generally faster than string (cfif trim(variable) neq ) and is (in some places) considered a best practice. -joe [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: search engine safe URLs
Just finished my article. Enjoy http://www.fusionauthority.com/Article1.cfm/ArticleID=4226 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: java objects and cfmx
Hmmm. Don't know about that, but I am reviewing the book now -- looks good, so far. Now, with this book, and the online tutorial I am taking, I am beginning to understand things such as: public, main, static, void, Applet, Servlet, etc. and I have learned that, in Java: 1 == 1.0 1 == 1.1 2 == 1.2 2 == 1.3 2 == 1.4 All of the above are true -- what could be more clear?:) Dick On Jul 8, 2004, at 10:11 AM, Tony Weeg wrote: you know, i tried to register for that site, back when you first mentioned it like 2 weeks ago, and i couldnt register... anyone else with the same issue? tony On Thu, 8 Jul 2004 09:35:44 -0700, Dick Applebaum [EMAIL PROTECTED] wrote: On Jul 8, 2004, at 8:10 AM, Tony Weeg wrote: Hey Tony, there was a thread yesterday that mentioned a book that I am ordering 'cause it sounded really good. It is a java for Cf developers book. The thread was named Learning Java for a CF Developer - a possible solution? I am in the same boat as you... It is available on O'Reilly Safari, so you can read it online -- I just put it on my bookshelf. But you can check it out for yourself -- Safari has 14 day free trial. http://safari.oreilly.com/ HTH Dick You can't wait for inspiration. You have to go after it with a club. - Jack London - [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: java objects and cfmx
You can access a book in 2 ways: preview mode: toc selected chapters put it on your bookshelf:full access The way Safari works is this: 1) for $n per month you get a bookshelf with a fixed number of slots 2) each book in the library can be put on your bookshelf 3) a book can take 1 or more slots on your bookshelf. 4) once put on your bookshelf, you must keep it there for 1-3 weeks 5) If your bookshelf is full you can remove old books or upgrade your subscription You can search and preview any books in the library You have full access to any books on your bookshelf. HTH Dick On Jul 8, 2004, at 10:45 AM, Deanna Schneider wrote: We have a subscription and it doesn't show up at all, oddly enough. I can see the preview online if I don't go through our login. Are you actually see the whole book (what I see says: This is a Preview... and cuts off half the text on each section). It is available on O'Reilly Safari, so you can read it online -- I just put it on my bookshelf. But you can check it out for yourself -- Safari has 14 day free trial. http://safari.oreilly.com/ HTH [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: java objects and cfmx
and I have learned that, in Java: 1 == 1.0 1 == 1.1 2 == 1.2 2 == 1.3 2 == 1.4 All of the above are true -- what could be more clear?:) I don't know what the heck you're learning from, but that's all kinds of wrong.Here's a sample class: public class test { public static void main(String[] args) { runTest(1, 1.0); runTest(1, 1.1); runTest(2, 1.2); runTest(2, 1.3); runTest(2, 1.4); runTest(2, 1.5); runTest(2, 2.0); } private static void runTest(int i, double f) { System.out.println( + i + == + f + = + (i == f)); } } And the output it generates: 1 == 1.0 = true 1 == 1.1 = false 2 == 1.2 = false 2 == 1.3 = false 2 == 1.4 = false 2 == 1.5 = false 2 == 2.0 = true Which is exactly as you'd expect. Cheers, barneyb [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]