OT: Gvt Agency/Bureau data
I know there are a couple people on the list who have done government work so I thought I would see if anyone has ever run across a list of all US Government Agencies and Bureaus. I am looking for a list of names along with the gvt ID number that goes along with it. I am trying to update our Agency table in a DB and the original source of information no longer provides the listing. Ideally CSV format would be great. Thanks, Mike ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221501 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Homesite+ Text on Tabs
Does anyone know if it is possible to increase the font size of the tabs on the file-tabs in Homesite? I am on a new laptop with a 15.4 wide screen and can't see the filenames when I have a couple files open! Thanks! Mike T. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220177 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: restricting cfoutput character length
From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED] I'm trying to do something which i can imagine is very simple but can't find the function. When i display a title cfoutput#myTitle#/cfoutput i'd like to just display the first 15 characters and if more then put three dots (periods). I know the LEN function but i can't work out how to replace the text with dots after the 15th character. Let's see how many people I can piss off this morning with a nice example using IIF and DE. :-) Replace str with your string. #IIF(Len(str) gt 15,DE(Left(str,15) '...'),DE(str))# HTH, Mike ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219403 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: query problem
From: Daniel Kessler [mailto:[EMAIL PROTECTED] CFQUERY NAME=the_type DATASOURCE=dpch select publication_type from publications where publication_type !='' group by publication_type /CFQuery If the field is NOT NULL try, where LEN(TRIM(publication_type)) == 0 *note... those are SQL Functions NOT CF ones. If the field is NULL try, where publication_type IS NULL HTH, Mike ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219494 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Weird Encrypt/Decrypt problem!
From: Andy Mcshane [mailto:[EMAIL PROTECTED] This is on Coldfusion 7, using a SQL database. I have tried URLEncodedFormat before saving to the database and then using URLDecode after retrieveing. As this text is defined by the user then I cannot simply say that there can be no 10 character strings so has anyone ever come across this? Does anyone have any better encryption ideas I could use? This is a really annoying little quirk as to why it only seems to affect 10 character strings, weird huh? Check to ensure that the length of the column in your database is large enough to hold the encrypted string since the length of the encrypted string does not always equal the length of the original string. HTH, Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219226 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Looking for PHP/CF hosting
From: Rick Root [mailto:[EMAIL PROTECTED] I'm looking for a hosting solution for a client - preferably linux based - with support for CFML and PHP on the same server. I need a MySQL Database and shared SSL. It's not a big site and doesn't use a huge amount of bandwidth, probably no more than a few gig a month. www.smarterlinux.com sister site to HostMySite ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218681 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfFile - uploading safely
From: daniel kessler [mailto:[EMAIL PROTECTED] So, how would I structure an accept so that it does this? Also, which other types of files should I exclude? If it's an include-only list then I don't have to exclude but I don't know which file types to enter ahead of time because I may know a few of the file types ahead of time, but probably not all of them. So I'd rather exclude, I think. I'd specify as many as you WANT to allow and let the users who have issues with the other documents let you know. !--- in Application.cfm --- //Allowable file MIME types application.globalVars.acceptableMIMETypes = ; ListAppend(application.acceptableMIMETypes,application/excel,,); ListAppend(application.acceptableMIMETypes,application/vnd.ms-excel,, ); ListAppend(application.acceptableMIMETypes,application/x-excel,,); ListAppend(application.acceptableMIMETypes,application/x-msexcel,,); ListAppend(application.acceptableMIMETypes,application/x-mspowerpoint, ,); ListAppend(application.acceptableMIMETypes,application/vnd.ms-powerpoin t,,); ListAppend(application.acceptableMIMETypes,application/powerpoint,,) ; ListAppend(application.acceptableMIMETypes,application/mspowerpoint,, ); ListAppend(application.acceptableMIMETypes,application/msword,,); ListAppend(application.acceptableMIMETypes,application/x-visio,,); ListAppend(application.acceptableMIMETypes,application/wordperfect,, ); ListAppend(application.acceptableMIMETypes,application/x-compressed,, ); ListAppend(application.acceptableMIMETypes,application/x-zip-compressed ,,); ListAppend(application.acceptableMIMETypes,application/pdf,,); ListAppend(application.acceptableMIMETypes,application/zip,,); ListAppend(application.acceptableMIMETypes,multipart/x-zip,,); ListAppend(application.acceptableMIMETypes,text/plain,,); ListAppend(application.acceptableMIMETypes,text/html,,); ListAppend(application.acceptableMIMETypes,image/png,,); ListAppend(application.acceptableMIMETypes,image/pjpeg,,); ListAppend(application.acceptableMIMETypes,image/jpeg,,); ListAppend(application.acceptableMIMETypes,image/gif,,); ListAppend(application.acceptableMIMETypes,image/bmp,,); ListAppend(application.acceptableMIMETypes,image/x-windows-bmp,,); !--- on page where upload takes place --- cffile accept=#application.acceptableMIMETypes# ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217820 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: numbers with decimal places to the right
From: Tim Laureska [mailto:[EMAIL PROTECTED] Insert attempt: cfqueryparam cfsqltype=CF_SQL_numeric value=#form.current_price# cfqueryparam cfsqltype=CF_SQL_DECIMAL value=#form.current_price# ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217242 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: numbers with decimal places to the right
From: Tim Laureska [mailto:[EMAIL PROTECTED] Insert attempt: cfqueryparam cfsqltype=CF_SQL_numeric value=#form.current_price# Actually, I spoke too soon. Is the data type MONEY? If so, use MONEY in the queryparam. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217243 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Full server/database/schema/table name syntax for Oracle.
From: Ian Skinner [mailto:[EMAIL PROTECTED] I am in an position where I have to join data from tables in different databases on different servers. I seem to recall that this maybe possible (if highly undesirable) by expanding the syntax of the table name. How does that look? How about QoQ? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217109 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cfopenbb
Any updates on this effort? The initial buzz seems to have died down. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216512 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfopenbb
From: Matt Woodward [mailto:[EMAIL PROTECTED] We're working--if you'd like to see things move faster, feel free to volunteer to help! I wasn't criticizing, rather inquiring. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216524 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cheap [reliable] cf hosting?
From: Ray Champagne [mailto:[EMAIL PROTECTED] So, I searched the archives, but came up with no definitive answer. plus, this question hasn't been asked in like 6 months! this will be real estate site where data is pulled in from an IDX daily, so (I think) I'll need to have decent bandwidth. please no way OT subtopics. don't want MT after me. he's scary. OT Ray... way OT. Just kidding :-) Check out www.smarterlinux.com it is the Linux sister site to HostMySite. How am I scary? Did you mean Herbie? :-) ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216340 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: [SOT] OOP book
From: wolf2k5 [mailto:[EMAIL PROTECTED] Wolf, Give these books a read (watch the URL wrap): http://www.amazon.com/exec/obidos/tg/detail/-/0672326116/qid=1117715221/ sr=8-1/ref=pd_csp_1/102-3208513-4990552?v=glances=booksn=507846 http://www.amazon.com/exec/obidos/tg/detail/-/020161622X/qid=1117715779/ sr=8-1/ref=pd_csp_1/102-3208513-4990552?v=glances=booksn=507846 Then, head over here (watch the URL wrap) for a great walkthrough of Java/OOP for the beginner.: http://java.sun.com/docs/books/tutorial/java/TOC.html HTH, Mike T. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215509 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CSS Help
From: Rick Root [mailto:[EMAIL PROTECTED] where is that space coming from? Try something out... Make this your first style declaration. Then refresh. *{ padding: 0px; margin: 0px; } Looks like a padding issue... ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215293 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFEclipse 1.2
From: Ray Champagne [mailto:[EMAIL PROTECTED] MT, you have links for more pics? send 'em offline to me! Ray Sorry Ray, meant to send this to ya over the weekend! http://www.cfreloaded.com/herbie/new%20baby/index.html Now, if I could get some sleep :-) Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215296 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFEclipse 1.2
sorry guys.. meant to send that offlist. Ugh. -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 16, 2005 2:46 PM To: CF-Talk Subject: RE: CFEclipse 1.2 From: Ray Champagne [mailto:[EMAIL PROTECTED] MT, you have links for more pics? send 'em offline to me! Ray Sorry Ray, meant to send this to ya over the weekend! http://www.cfreloaded.com/herbie/new%20baby/index.html Now, if I could get some sleep :-) Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215300 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Studio 8 announced
I'll be the ass today and say that this is definitely cf-community now. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214745 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Decimal to Decimal Error
JRUN 4, Updater 5 CFMX 6.1 w/ updater SQL DB. Column is Decimal(3,1) I have a query in which I am trying to update a field of type Deciaml. cfqueryparam cfsqltype=CF_SQL_DECIMAL value=#attributes.contractDuration# scale=1 null=no / Values with 1 digit to the left of the decimal point work fine. Examples: 0.5 1.0 1.5 2.0 2.5 etc... However, values with 2 digits to the left of the decimal point throw an error. Examples: 10.0 10.5 11.0 11.5 12.0 etc The error is: [Macromedia][SQLServer JDBC Driver][SQLServer]Error converting data type decimal to decimal. Any ideas? Mike ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214754 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Add additional rows
From: Jillian Koskie [mailto:[EMAIL PROTECTED] I have a form that adds content to a database --but I need to be able to allow my user to dynamically add rows (for additional authors) to the form... because he never knows how many authors there will be. So I need a way to add the lines without reloading the page/losing the form data (or do I have to just populate the form with 'form variables'?). I also need a way to loop through the results and insert them into the database. What I have done in the past is first come up with a naming convention for that group of form fields. In your case, let's say it is called Author. Using some JS you can dynamically add rows to the table/form and name them Author1, Author2, Author3, etc. Each of these new form elements goes in a new row which is contained within a TBODY. Using another little bit of JS, set a hidden form field AuthorCount equal to the row count (use JS to get this also). Submit the form. On the processing page you can use AuthorCount to help you loop over all the Author fields. Let me know if you need some specific code help... I have done this a couple times. Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214759 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Decimal to Decimal Error
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] It's your column spec. Decimal(3,1) means 3 digits are allowed, and 1 digit to the right of the decimal is allowed. You need to change it to Decimal(4,1) if you want those other values. That is not correct. From BOL: 'p' Specifies the precision, or the number of digits the object can hold. 's' Specifies the scale, or the number of digits that can be placed to the right of the decimal point. p and s must observe the rule: 0 = s = p = 38. Decimal(3,1) is the correct spec. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214790 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Decimal to Decimal Error
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] By the way, what is 'BOL' ? Books On-Line from Microsoft. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214796 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CF/JRUN Path Issues
I have JRUN set up and working on Windows XP Pro (my development workstation). I have CFMX6 and CFMX7 both deployed and seem(ed) to be working fine. The specific information for each deployment is as follows: CFMX6: http://localhost:8101/ context path: / document root: C:\Inetpub\wwwroot CFMX6: http://localhost:8102/ context path: / document root: C:\Inetpub\wwwroot I ran the IIS connector on both and all went fine. I could log into the MX6 admin and MX 7 admin no problems. I configured the servers and off I went. I dropped a site into the document root (C:\Inetpub\wwwroot) and tried to access it via the CFMX 6 URL: http://localhost:8101/site/ http://localhost:8101/site/ . The site pulls fine except none of the CSS, JS, and Image paths appear to be working. When viewing the source, they all look correct in that they appear as: http://localhost:8101/site/images/... http://localhost:8101/site/js/... http://localhost:8101/site/css/... Ok, here is where it gets interesting. In the application.cfm file I have this: if(CGI.server_port neq 80){ application.thisServer = LCase(ListFirst(CGI.server_protocol,/)) :// CGI.server_name : CGI.server_port /site/; } else{ application.thisServer = LCase(ListFirst(CGI.server_protocol,/)) :// CGI.server_name /site/; } application.thisServer.js = application.thisServer js/; application.thisServer.css = application.thisServer css/; application.thisServer.image = application.thisServer Image/; If I leave the above alone, the page does not render with the images, js, or css working. If I hard code the path in such that it looks like the following, all works fine... everything renders and works!: application.thisServer.js = http://127.0.0.1:8101/site/js/; application.thisServer.css = http://127.0.0.1:8101/site/css/;; application.thisServer.image = http://127.0.0.1:8101/site/mage/; Any ideas? Is this a JRUN/Site/IIS config issue? TIA, Mike ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214558 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF/JRUN Path Issues
From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Why are you bothering to prepend the protocol, host etc. ? application.thisServer.js = '/site/js/'; will work just as well. Im not really concerned with that right now. What I am concerned with is why a site worked ok on standard install of CFMX but when It gets deployed onto JRUN it works differently. The application code will be cleaned up by the original developers once I get the sites moved into our new dev environment. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214569 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF/JRUN Path Issues
From: Douglas Knudsen [mailto:[EMAIL PROTECTED] are these doc roots set in IIS or the JRun instances? If you have IIS connectors setup, why are you using the port number of the JRun instance? To be honest, I have not set this stuff up before. Usually I setup CF and work right from wwwroot. I am only going through JRUN to explore some of the options/features that setup provides. using http://localhost:8102/ uses the internal webserver for the JRun instance, no IIS at all this way. This is I did not know... come to think of it, I don't know what the hell I am doing. :-) My intention was to have two instances of CF running: 6 and 7; both pointing to the same webroot. I could then toggle between instances using the port number in the URL. Thanks for the info Doug I will see if I can grasp the JRUN--IIS connection a little better. Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214577 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF/JRUN Path Issues
From: Douglas Knudsen [mailto:[EMAIL PROTECTED] yeah, I run several JRun instances on my PC, one for CF, Flex, JRun cluster testing, etc. I never hook IIS into any of them as its just a dev PC. All doc roots are under jrun4\servers\servername\app-war\ and I access everything via the port for the internal JRun webserver, in your case the 8101 and 8102 ports. You can modify the doc root in the web.xml file IIRC, I never do this though. Looks like my config in JRUN is all set then. They are both pointing to the same doc root. The thing I didn't realize is that I don't even need IIS! Now, you can easily add these to IIS by creating a seperate IIS website for each, each on a different port, these ports differing from the JRun ones. Use jrun4\bin\wsconfing to setup the connector between the IIS site and the JRun instance. Then you use the IIS port after that, not the JRun port, in your URL. Now that everything is beginning to make sense, I don't care about IIS on my local dev box as it is just for me! XP doesn't allow multiple websites anyway on XP Pro so that's a moot point... assuming I don't want to run each site in a virtual directory which can't be tied to a port anyway, blah blah, bye bye IIS. In the development lab however, we are running Windows 2003 Server and I can set things up a bit different. HTH...have fun! Having a blast! Seriously though, thanks for the info/explanations. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214580 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
mx 6.1 7
I have 7 installed on a dev box already but we also need 6.1. What would the best approach be to getting them both up and running on the same box. Right now MX 7 is installed using the J2EE Configuration option. I can reinstall if need be... just looking for the best way to run both until we can get all the production servers squared away. TIA, Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214135 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: mx 6.1 7
From: [EMAIL PROTECTED] [EMAIL PROTECTED] We designed CFMX7 to coexist peacefully with all previous versions (one of my requirements actually, since I figured you'd want to do this). Should be able to just install and go. What is the best config options though? Install CF 7 using the J2EE configuration option and tie into IIS then install 6 using the included web server? I want both app servers to tie into the same webroot also. :-) Sorry to sound so newbie-ish when it comes to installs and configs, I am used to just installing and running with it. Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214148 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfform file upload
From: Damien McKenna [mailto:[EMAIL PROTECTED] Very nice indeed. FYI it requires the Flash Player 8. I got installed yet I get IO Error. H ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214158 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
EAR Problems
I download the JRE, install it, and add the following to the class path: C:\Program Files\Java\j2re1.4.2_08 I installed JRUN. Ran the updater. The default and admin servers are running fine. I ran the cfmx 6.1 installer and had the EAR file placed into c:\cfmx61\ I ran the cfmx 7.0 installer and had the EAR file placed into c:\cfmx70\ By the way, I am following directions from here: http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/instal16.htm#wp11 4171 Anyway, I open a command window and create a directory in c:\cfmx61\ called cfusion-ear When I try to cd to that directory I get Invalid Directory. I go into Windows explorer and the directory is there! Any ideas? I tried rebooting, tried starting over... nothing works. Am I missing something here. Once I can navigate to that directory I will expand the file out and continue on this just seems very odd. And yes, I tried using quotes around the directory name, etc. Mike ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214197 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: EAR Problems
From: Russ [mailto:[EMAIL PROTECTED] This is very strange... how did you create the directory? Through the command prompt? I'm not sure how good you are at using the command prompt, but make sure you're in the right place before cding to the directory. For example open up a command prompt: I created the directory from within the initial directory (c:\cfmx61 and c:\cfmx70) using the following (minus quotes): md cfusion-ear It is very odd! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214201 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: EAR Problems
From: Russ [mailto:[EMAIL PROTECTED] Have you tried following my examples and seeing if you can cd to the directory? Sometimes not being able to access a file or directory can mean that there is some sort of corruption on the hard drive (possibly some bad sectors...). I tried it. No luck. It's very odd. Anyway, I cranked open WinRAR and expanded the archives. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214212 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: EAR Problems (Solved)
From: Tangorre, Michael [mailto:[EMAIL PROTECTED] I dunno what the changing directory problem was all about. It still doesn't work. In fact it doesn't work for any directory anywhere! Anyway, I used winRAR to expand the directories out. One for CFMX 6.1 and one for CFMX 7.0. I copied the folders into the C:\JRun4\servers\ directory. I created two new servers in the JRUN management console. Ran the website configurator. Made a couple changes and bam... CFMX6.1 runs on localhost:8101 and CFMX7 runs on localhost:8102. Geeez, that took half a day to setup! LOL ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214223 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: EAR Problems
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] I recommend hydrogen peroxide and a cotton swab. :-) ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214226 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Studio 8 announced
From: Ken Ferguson [mailto:[EMAIL PROTECTED] If you mean that opening it is something very different than what you usually do with it, then yeah maybe so. I don't understand how any of you guys can use DW. I've got another CF developer in the office who uses it and we have this conversation about once a week as he struggles with it hanging up, slowing to a crawl... I'm glad to hear that MM has added even more stuff to DW. I'm sure it's likely now to fight for the title, biggest software pig with even more success than previously. I don't understand why anyone cares what IDE other developers use? Does it ruin your day knowing some people like DW over HS+ and some like Eclipse over Studio 4.5, etc? Who cares. Use what you like. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214063 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Studio 8 announced
From: Mark A Kruger [mailto:[EMAIL PROTECTED] G/F? Grandfather. :-) ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214080 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Flash forms - Date validation
What is the easiest way to do the following validation within flash forms? I have a form with 6 dates. The dates need to be completed whereby they are in chronological order. Date 1 has to be less than Date 2 which has to be less than Date 3, etc. They also need to be valid dates (format wise... -MM-DD). Thanks! Mike ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213767 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: fyi : Nice MXNA app built with CFForms
From: Micha Schopman [mailto:[EMAIL PROTECTED] Expanding and collapsing brings my dual core system on its knees, not to mention resizing the window resulting in the exact same effect. Scrolling the grid with the handle on a 3Ghz CPU has the exact same effect. That's odd. I have Homesite+, IE 7, FF, Outlook, AIM, iTunes, Eclipse, Sql Server Management Console (2005), and Adalon all open and it runs fine. If you go below the 1024x768 res the app gives you some scroll bars but other than that, no problems. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213380 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: fyi : Nice MXNA app built with CFForms
From: Adrocknaphobia [mailto:[EMAIL PROTECTED] If resizing was the only problem they would be in good shape. It won't even render on my pc. -Adam Specs? ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213391 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ANNOUNCE: CFFM 1.1 Released
From: Robertson-Ravo, Neil (RX) My favourite is the way I could upload and .exe and a .bat file.. Nice tact. How about you email the original poster off-list with your feeback/concerns/questions. Everytime someone posts a tool on this list people seem to go out of their way to act like complete asses. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213075 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: CSS / Fieldset / IE
Does anyone know of a way to remove the extra area above a fieldset/legend that shows up in IE when the fieldset has a different background color than the page background color? It looks perfect in FF but in IE the background color of the fieldset bleeds above the border of the fieldset... any CSS hacks or tricks? Thanks! Mike ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213186 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Does a CFC know....
From: Russ Michaels [mailto:[EMAIL PROTECTED] That's fusebox for you. Cheap shot at Fusebox? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213187 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CSS / Fieldset / IE
Subject: RE: CSS / Fieldset / IE Here is an example of what I am talking about... www.cfcoder.com/test.html ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213192 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: IsObject() What Type?
From: Joe Rinehart [mailto:[EMAIL PROTECTED] Try cfdump getMetaData(oPatron) / I think Joe forgot his pounds and var. :-) cfdump var=#getMetaData(oPatron)# / ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213207 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CSS / Fieldset / IE
From: Jim Davis [mailto:[EMAIL PROTECTED] That feels like something that's probably not in the CSS spec (and thus left to agent developer's to decide)... if so then both implementations can be right. But if you want to force it you might try setting a background graphic on the fieldset that's pinned to the top, tiles horizontally, matches the page's background color and is only as tall as the space you want to mask. Seems like it is a known issue with no nice x-browser solution. IE is coloring the bounding box of the whole fieldset including the legend; FF is coloring the bounding box of the fieldset without the legend. It doesn't have to do with the contents of the fieldset text, it has to do with where the background bounding box is when a fieldset has a legend. You could make a case for either way being correct. snipped from a website. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213204 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: The Parable of the OOP and Breakfast
From: Mike Kear [mailto:[EMAIL PROTECTED] Subject: The Parable of the OOP and Breakfast Once upon a time, in a kingdom not far from here, a king summoned two of his advisors for a test. He showed them both a shiny metal box with two slots in the top, a control knob, and a lever. What do you think this is? Once upon a time lived a cf-community list that needed more posts. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212953 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion Exam
From: Robertson-Ravo, Neil (RX) I personally don't like or rate these exams - they mean nothing in the shadow of say a good MS qualification. By all means go for it if you want to but it doesn't make you any better than a geezer off the street without one. In the shadow of say a good MS qualification? Seriosuly? Like what... an MCSE? I think all certifications CAN hold weight assuming the person holding the certification really learned and retained the concepts and material associated with the cert. Candidates interviewing for jobs should be given tests to demonstrate that they really know the material that goes along with their so called certification. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212521 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion Exam
From: Robertson-Ravo, Neil (RX) Well, say an MSDBA, MSCE, even Cisco or alike. A CF qualification doesn't really hold any weight. First off, the Microsoft certification tracks are a lot more involved than one test. The MSDBA for instance is comprised of a many exams before the certification is obtained. That puts it on a different level that the CF exam but does not diminish the CF exam in any way. I don't think the Cisco exams hold that much weight unless your have one of the higher ones. The CCNA is about as common as the MCSE. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212527 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ColdFusion Exam
From: Andy Jarrett [mailto:[EMAIL PROTECTED] How long did everyone else give themselves to study?? weeks, months, days??? Depends. Do you want to retain the information short term to just pass the exam? I hope not. I would say that study and practice until you feel confident in the concepts and can apply them comfortably. Everyone is different thus the time to prepare is different. Also has anyone used CF exam buster to study (it was there spam this morning which prompted a look around) Yes, it is a great study aid. Mike ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212436 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Fusebox Oddity: FORM scope not moving to ATTRIBUTE scope
From: Robert Nichols [mailto:[EMAIL PROTECTED] As you can see, the values of the variables in scope form are *not* being copied to attributes. So the code winds up updating the table tblPeople with the values in attributes instead of the values the user enters on the form. What version of Fusebox? What form method are you using (post|get)? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212185 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
CFLDAP
I am trying to figure out if we need to reorder our Active Directory architecture or if I can get around what appears to be a problem at the current time. Lets say I have a DN as follows: CN=Tangorre\, Michael, ou=developers, ou=users, ou=building, dc=xxx, dc=yy Is there a way to specify to do a wildcard in the ou portion that contains the building? Right now I can only get the users by building name but what I really want is ALL users. The following gives me the Silver Spring users but I want to disregard the building. If I omit it that part of the OU, no records come back, if I use * I get an error. cfldap action=QUERY name=selectUsers attributes=cn,dn,ou start=ou=users,ou=Silver Spring,dc=xxx,dc=yy Any idea? Thanks, Mike T. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212107 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT/SOT: ColdFusion Word Doc Sharing
From: E C list [mailto:[EMAIL PROTECTED] Thanks everyone who responded. I am going to follow up on your suggestions and see if these ideas will match our needs. Michael, I am not sure what Microsoft means, but their sharepoint website home page and the download area both state that sharepoint is free if you have 2003 Server (which I do)...but on another page it actually gives pricing. I guess I only see what I want to see...but it does say more than once things like There is no additional charge for Windows SharePoint Services. But I guess maybe there are extra charges for CALs...I am not sure I wish they'd make their pricing schemes easier to digest. I wish I could give you more information on Sharepoint pricing. I could ask the network engineers here for a quick run down on pricing as based on our relationship with MS (gold partners). Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212110 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Catching errors and emailing
From: Michael Dinowitz [mailto:[EMAIL PROTECTED] CFTRY/CFCATCH is very efficient and has close to no overhead on a standard CF page. It's an issue of approach, not execution speed. The overhead comes into play when an an exception is thrown and the cfcatch portio executes... especially if you have multiple cfcatch tags that are not in the best order, e.g. the most specific being first then so on down to the most general. Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211984 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Coldfusion7, cfprocparam blank date fields!
From: Andy Mcshane [mailto:[EMAIL PROTECTED] passed to procedure. Anybody have any ideas? Post the code. In particular, the cfprocparam code within the CFC. ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211987 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Catching errors and emailing
From: Dave Watts [mailto:[EMAIL PROTECTED] At that point, though, overhead is probably not your primary concern (or even an important concern at all). After all, exceptions are, well, exceptional, by their very nature, so you shouldn't have to deal with too many of them at once. I was merely commenting on what Mikey D was saying I haven't seen nor used a lot of cfcatch blocks on MX6 or 7 but back on CF 4-5, it seemed that whenever cfcatch was involved, performance took a hit. It could have been the crappy application I was stuck working on in general but it performance always improved when we corrected the overuse of the cfcatch tag. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211995 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query error
From: Merrill, Jason [mailto:[EMAIL PROTECTED] Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] The table 'Lessons' is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically. Do you have the Access DB open on your workstation? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211999 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Coldfusion7, cfprocparam blank date fields!
From: Andy Mcshane [mailto:[EMAIL PROTECTED] Have you checked the values that are passed into the CFC before you use them.? Just output them within the CFC to ensure that the expected values are at least within the CFC. You can avoid the use of cfif/cfelse tags and duplicate cfprocparam tags by evaluating an expression within the null attribute of the cfprocparam/cfqueryparam tags to determine whether or not NULL is sent or the actual value of the variable. If the expression evaluates to Yes, the value attribute of the tag is ignored. If the expression evaluates to No then the value attribute is passed in. The attribute dbvarname is no longer used in CFMX7, in fact it is ignored. I guess if you are using it to keep the stored procedure parameter names in check it can't hurt but I'd say if an attribute is no longer supported, don't use it. cfprocparam type=IN null=#YesNoFormat(Len(Trim(arguments.FIXDATE) EQ 0)# value=#Trim(arguments.FIXDATE)# cfsqltype=CF_SQL_DATE Not sure if any of that helps, but it cleans things up a little. :-) ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212005 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cfform / cfgrid / pagination
Has anyone come up with a nice way to use cfgrid and have previous/next buttons to traverse large record sets? ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211774 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Not to start a flame war.....
From: Jacob [mailto:[EMAIL PROTECTED] http://www.promoteware.com/Module/Article/ArticleView.aspx?id=10 Seems a little MS Heavy. Also, look at the test notes... Test Notes: Each application was executed on identical Compaq Proliant servers; J2EE was tested on two Application Servers, one of which crashed midway and did not complete the test; J2EE used an Oracle 9i database while .Net used a SQL Server 2000 database; J2EE ran on Windows 2000 because it outperformed RedHat Linux 7.2 in a trial test. For the complete study, visit... How can you run a test comparing A and B when the environment is not even the same? Oh well. ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211778 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
SQL 2005 CFMX 7
Has anyone successfully setup an ODBC connection with CFMX 7 and SQL 2005? I am playing around with SQL 2005 on my workstation and am having trouble getting the ODBC configured Keep getting an error for login even though the name and password specified are legal logins with appropriate access (sa). TIA, Mike ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211632 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
cfheader/ cfcontent to server files
I have a link to a CF template that serces up a document for download. When the user clicks on it they are asked to save/open/cancel the file... which is fine. However the web page that opens up beneath the dialogue box is blank (Action Cancelled). I assum this happens since cfheader affects the page... what is a better approach to this to keep the download prmpt while getting the underlying page to not bomb. IIS 6 CFMX 6.1 IE 6 !--- serveDocument.cfm --- cfheader name=Content-Disposition value=attachment; filename=#variables.doc#.#variables.ext# cfcontent file=#variables.docPath# type=application/x-unknown deletefile=No / Thanks, Mike ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192622 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: wussy-wig editor
From: Thomas Chiverton [mailto:[EMAIL PROTECTED] On Thursday 13 Jan 2005 11:57 am, Adam Haskell wrote: I highly doubt that this program is going to lock a person into It requires your customer to have a Windows O/S to use your web site. windows...and could you show some perfectly good alternatives? http://www.dynarch.com/projects/htmlarea/ is what I'd use in this case. That still uses font tags! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190916 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Combined version of Eclipse + plugins for Windows?
From: Damien McKenna [mailto:[EMAIL PROTECTED] - fusebox4cfe Damien, where did you see the above plugin? I can't seem to locate any plugins for Fusebox4. Mike ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190685 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFmail and receiving 1 copy
From: James Watkins [mailto:[EMAIL PROTECTED] When sending email to a list of several hundred students using CFmail I would like to receive just 1 copy of what I send. How can I modify below to do that? cfmail query=mail_roster to = #student# from = #mailfrom# subject = Greetings blah, blah /cfmail How about: !--- Send to recipients using query results --- cfmail query=mail_roster to = #student# from = #mailfrom# subject = Greetings blah, blah /cfmail !--- Send yourself a copy --- cfmail to = you from = you subject = Greetings blah, blah /cfmail Mike ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190437 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: John Dowdell Wants to Know What's Wrong with Macromedia
From: Micha Schopman [mailto:[EMAIL PROTECTED] Sean, .. that latest is not true. DWMX engineers even confirmed not being aware of the bugs on conferences. It is not an issue of the engineers, it is an issue of the engineers not being informed. Honestly, don't you think Sean would have more insight into the issue than us, especially since he works at MM? I know he does not work on the tools team but let's face it, he doesn't toss a recommendation to submit items to the wish list for nothing... It servers a purpose, so we should use it, not just for DWMX but for any MM product. And honestly, .. I payed big bucks for the product, I don't really care about emotional thoughts behind it. I just want a working product for the money. We have about 30 licenses here for DWMX. Working product is very subjective. What's broken? What additional features would you like to see in later releases? What might be broken in your opinion might not be in someone else's. The engineer's won't know what to enhance or add unless we, the users, send them feedback through the wish list. Mike ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190460 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFmail and receiving 1 copy
From: Calvin Ward [mailto:[EMAIL PROTECTED] The other solutions aren't as ideal for various reasons, in my opinion. What si wrong with the two cfmail tag calls? 1 call passing in the query and 1 call to the 1 recipient? ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190479 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: John Dowdell Wants to Know What's Wrong with Macromedia
From: Micha Schopman [mailto:[EMAIL PROTECTED] Oh ofcourse he has. I have no insight whatsoever, but I can imagine you don't know about everything within a club of 1000+ employees. Nor could assume that all the engineers see every bug report! I have submitted several extensive reports through the MM website bug submission form. Bugs, described in detail with complete steps to reproduce. So I have in fact done my own part, notify something is wrong, and I cannot do more than submitting reports. I am sure there is some kind of formula that dictates what number of occurrences prompts further investigation. Just because you have the issue does not mean everyone does. The more people that report the problem the greater the possibility it gets looked into further. The part of engineers not being aware, has been confirmed by an engineer himself. Asking the engineer when do you plan to fix bug A, bug B and bug C were replied with what bugs? ... Again, one engineer not being in_the_know as to every bug is not uncommon. I would imagine they get discussed in some kind of fashion, evaluated and the appropriate people are informed of the action being taken, if any at all. As a customer this makes me think excuse me?. It is not that I am angry, I am just dissapointed and astonished. I cannot imagine no one ever had problems with the treeview part, the welcoming screen staying on top of the coding canvas, crashes when searching through folders, not being able to cut/copy/past files without the message file already exists and the targetfolder had just been created. Again YMMV. I have not run into all the things you mentioned; that is not to say they don't exist but if only a people report it how can MM make the case to investigate it ahead of other things being reported. I can imagine, when you have bugs that occur on very odd actions, or occur on such a low scale, you say as a company this bug involves too much time and money to be fixed .. but the bugs I submitted were of the type occuring very often. The amount of feedback probably triggers further response Which makes sense. You are doing your part in reporting to MM in detail the issues you encounter. When enough people report to MM or the higher priority issues are resolved I bet they do look into yours. Mike ~| Flash for programmers - Flash MX Pro http://www.houseoffusion.com/banners/view.cfm?bannerid=56 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190492 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: John Dowdell Wants to Know What's Wrong with Macromedia
From: Sean Corfield [mailto:[EMAIL PROTECTED] At least, that's how I see it. If you think there really is a good business case for major work to be done on HS+, let's hear it. Or perhaps some other approach? Your response is logical. I for one am not as passiontate about my IDE choice as many others seem to be. Nevertheless I want an IDE that supports my daily tasks (on average). Since no IDE will ever be able to meet all my requirements, and DW has way too many features that I would ever use, I go with Homesite+ and CFE. CFE will be the main IDE of choice once I get used to it. Getting used to it is where a lot of developers give in; they think since once plugin doesn't work how they would like they are out of luck. How very wrong... While hunting down all the plugins for CFE that I was interested in I had some good and bad results with them, eventually weeding out the ones that were of no use or little use to me and my daily tasks. The point is this, CFE is the editor that has the potential to support what developers want since it is open source. Everyone should stop bitching about Homesite and DW and download eclipse and start making requests (or even contributing yourself) to its' future growth. Through plugins, community support/development the potential for CFE to become the #1 editor of choice is definitely there, it will just take some time. Download it... Give it a shot. It takes a little while to get used to but you should be able to get what you need out of it sooner or later, unlike DW which will never be less bloated since it supports mor ethan just the CF community nor with Homesite+ which is going downhill. Mike ~| Get help! RoboHelp http://www.houseoffusion.com/banners/view.cfm?bannerid=58 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:190284 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: List all Available Queries
From: Dawson, Michael [mailto:[EMAIL PROTECTED] cfset keys = struckKeyList(variables) cfloop list=#keys# index=thisOne cfif isQuery(thisOne) Query foundbr cfelse Query not foundbr /cfif /cfloop Obviously, you'd want to improve this code and make it work for multiple scopes. I think this beats hitting the factory. I think the above would take a long time, especially if you had a good sized application that used many scopes and a decent amount of variables in them. My guess is that the factory would be much better. ~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189638 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cfqueryparam and Unique Identifiers
VARCHAR Michael T. Tangorre -Original Message- From: Duncan I Loxton [mailto:[EMAIL PROTECTED] Sent: Thursday, January 06, 2005 7:52 PM To: CF-Talk Subject: cfqueryparam and Unique Identifiers We use UUId for our users primary key - what cfsqltype should I use to get the correct match? e.g. cfquery name=getStaffDetail dataSource=#Application.DataSource# userName=#Application.DBUserName# password=#Application.DBUserPwd# SELECT * FROM Users usr_id = cfqueryparam value=#attributes.usr_id# cfsqltype=CF_SQL_UUID /cfquery There doesnt seem to be a match in the documentation - should I be using a different type that copes with UUID's? Thanks! ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189603 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Charting Software
From: Kristen Winsor [mailto:[EMAIL PROTECTED] Has anyone used the charting/mapping software Temtec?..Basically, I have narrowed down choices to Temtec Corda, and was just trying to get feedback if anyone has worked w/ Temtec Never used Temtec, but I give a thumbs up to Corda... A few years ago we used PopChart/Server for a lot of reporting tasks and it was excellent. Mike ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189417 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Form Data Tracking
From: Joe Eugene [mailto:[EMAIL PROTECTED] We have a need to track Form Updates by users i.e. history of updates to Forms. Once the user submits a from after validation, we want to track the updates done. e.g. User A can change their Credit card info several times on a Form, we need to Track those changes and any other agreements they might have agreed to on the Form. Options. 1. Save the entire contents of the Form as *.htm/*.pdf files or populate them in the DB. 2. Implement a complex DB Relational Structure to store the content and data. Any other Ideas? Anybody else implemented something like this before? Joe, I would recommend setting up a DB structure to take care of the historical change data. I would first identify how many fields you need to track. If it is just a couple then create a couple tables and use triggers (depending upon DB platform and application load) to capture when columns are updated or inserted. For example: I want to keep track of what credit cards users use with their accounts. Assuming I did not structure the DB to accommodate multiple accounts (CC) I would implement something like this: USER --USER_ID (PK) --USERNAME --CC_NUMBER HIST_CC_NUMBER --CHANGE_ID (PK) --USER_ID (FK) --FROM_CC_NUMBER --TO_CC_NUMBER --DATE_CHANGED Add a trigger to the CC_NUMBER column in the USER table for 'insert' and 'update' and store the appropriate values. If your needs go beyond a couple columns, you might consider a complete set of historical tables that mimic your transactional tables. If you go this route, I would evaluate application load to determine whether or not triggers are you best bet or if programming the routines in code would yield better results... I have done it both ways. HTH, Mike ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188851 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Mach-II client variables
From: Matthew Small [mailto:[EMAIL PROTECTED] Before client variables can be used, the client state management system must be enabled using the CFAPPLICATION tag. You need to set the location for storing the client vars.. http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-pa3.htm#wp10 97308 You need to set the clientStorage attribute in the cfapplication tag. HTH, Mike ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188854 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Query Timeouts
From: Ron G [mailto:[EMAIL PROTECTED] Why would the timeout value of the cfquery tag be ingnored? Ron, The query timeout is for that query not the template as a whole. Use cfsetting to override the administrator setting if you need to timeout a template with different settings than that which is in the cf admin. http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-pc6.htm#wp11 03514 HTH, Mike ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188812 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: DB design (Directory / Cateloging System)
From: Dwayne Cole [mailto:[EMAIL PROTECTED] I have been trying to design relational model to manage a flexible directory / classification system. I want to design that completely seperates the directory classifaction relationships from the items that are being classified. That way I can use the same classification model to support classifying people, orgranizations, pictures, products and any other noun Read up on nested sets. Joe Celko did a TON of work in this area and I have implemented his strategy and techniques in a roles/permission based security model which kind of mimics your parent/category/class idea. Mike ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188367 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFStoredProc bug?
From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Yep. cfprocparam type=In cfsqltype=CF_SQL_INTEGER dbvarname=Order_ID value=#Arguments.Order_ID# null=no This binds to the Order_ID inside the SP which is defined (inside) as @Order_ID. The reason for the @ inside is to show it's a SQL variable. The dbvarname attribute is no longer used in CFMX: it is now ignored for all drivers ColdFusion MX does not support named parameters. Mike ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188410 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFStoredProc bug?
From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Thank you for pointing that out. It looks like I missed that. So basically, the order of cfprocparams being passed is all that matters and no parameter can be missed when writing cfprocparam tags. Is there any performance (i.e. binding) savings to using the CFSTOREDPROC tag vs. a CFQUERY with CFQUERYPARAMs? Is the CFSTOREDPROC call as efficient? Better? What's the advantage? Anyone from MM want to comment? Thanks One major advantage of using the cfquery tag to call the stored procedure is the fact that you can use the cachediwthin and cachedafter attributes whereas cfstoredproc does not have them. Michael T. Tangorre ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188418 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFStoredProc bug?
From: Michael Dinowitz [mailto:[EMAIL PROTECTED] But not at the same time as using CFQUERYPARAM. :( I thought that if you used cfqueryparam for constants the results were cache-able. ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188422 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFStoredProc bug?
From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] Why does this strike me as MM saying It's not a bug, it's a feature! ??? I wonder what convinced MM to do away with that little tidbit... did they think that people would always pass all of the parameters to all of their stored procedures? What is forcing you to pass all of the parameters to your procedures? I am not following you here... Are you reusing procedures for different operations in your application whereby one operation might need to deal with a subset of what the procedure was intended for? Named parameters in your procparam tag just means you have to maintain code between the DB and the calling code... Seems a little tedious to me. ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188451 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFStoredProc bug?
From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] It's a preference of mine... I don't like to write three stored procedures that do the same thing... I want one up_get procedure that will return either the entire recordset, those that match a text lookup or a single record based on PK reference. Here's a very basic up_get stored procedure: Make sense? I know what you are saying but I prefer the opposite. I like to have nice concise sotred procedures that do one thing and do it well. I don't have a problem with having a couple hundred stored procedures for my application; when they all do something specific and very efficiently that is easier to maintain than 50 stored procedures that are full of conditionals and span 20 vertical pages. To each his own. All I wanted to point out was that the attribute is no longer used and that, in my opinion, adding one more location to couple your DB to your calling code should (in my opinion) be avoided. Mike ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188463 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: binary question
From: Richard Meredith-Hardy [mailto:[EMAIL PROTECTED] ldp returns an object's objectSid as S-1-5-21-85748401-1263151954-712603620-2180 wheras CFLDAP returns it as something like Ò'.6d'ÁJ[EMAIL PROTECTED] anyone know how to decode this? ToString() doesn't. (I assume objectSid is an Active Directory entry's UUID?) This is on CF 5.1 The object ID that is being returned always looks like S-1-5-21-85748401-1263151954-712603620-2180 (format wise)... The string Ò'.6d'ÁJ[EMAIL PROTECTED] looks like the hashed password that is stored for the object (most likely a domain account password). If in fact it is the password field and it needs to be changed I believe you have to do that through AD. Mike ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187865 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF vs ASP.NET! GET YOUR FRESH POPCORRRRN!!
From: Mark Drew [mailto:[EMAIL PROTECTED] Cant we all learn to love each other for our differences? What fun is that! :-) ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187586 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
variables... to prefix or not to prefix
Just out of curiosity, who prefixes their variables with a data type abbreviation... integer - intVariableName numeric - numVariableName string - strVariableName structure - stcVariableName array - arrVariableName object - objVariableName query - qryVariableName etc... We are ever expanding our best practices and guideline documents and this is an agenda point up for discussion soon... I want to some in with some pros and cons. At first glance, the code becomes more descriptive but I do see and have run into, many problems such as passing around URL params.. do you really want to give anymore information than necessary into the type of data within a variable? What about if you encrypt variables?... The number 1 could be viewed as URL.intSomeId but once encrypted it is no longer an interger it is a string URL.strSomeId, this only touches the tip here. Anyone have anything to offer on this topic? Thanks. Mike ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187360 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CF vs ASP.NET! GET YOUR FRESH POPCORRRRN!!
From: Kwang Suh [mailto:[EMAIL PROTECTED] Feel free to challenge them. And feel free to move this conversation elsewhere... ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187446 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MSSQL Data Types
From: Emmet McGovern [mailto:[EMAIL PROTECTED] What is the next step up from varchar? I need to be able to enter up to 20,000 characters and be able to edit. The other question is... Can I convert the a varchar datatype to it without losing data? Text. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186905 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Enforce Strict Attribute Validation
One of the biggest differences between previous versions of ColdFusion and ColdFusion MX is that ColdFusion MX has strict validation for CFML syntax. Invalid tag attributes will result in errors. ColdFusion 5 and earlier versions have a switch in the ColdFusion Administrator Settings page called Enforce Strict Attribute Validation that allows you to enforce syntax checking, improve page execution time, and enforce proper code syntax. In ColdFusion MX, you have no choice but to write code to this standard. As a suggestion, it may be worthwhile to test your application on your existing version of ColdFusion Server with this option enabled before attempting to migrate to ColdFusion MX. Michael T. Tangorre -Original Message- From: Kazmierczak, Kevin [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 07, 2004 2:02 PM To: CF-Talk Subject: Enforce Strict Attribute Validation Did this server option disappear in when CFMX came out? Just curious. Kevin. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186518 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: Eclipse Quantum DB Plug-in
Thanks Dave. Looks like I better pay attention to my Bs and Ds. jdbc not jbdc. :-) Right syntax, wrong spelling! DOPH! Mike From: Dave Epler [mailto:[EMAIL PROTECTED] Sent: Sat 12/4/2004 6:57 PM To: CF-Talk Subject: Re: OT: Eclipse Quantum DB Plug-in Mike, I have the Quantum DB plugin working with the MS-SQL JDBC driver. When you create the bookmark you need to have the driver added with all three of the .jar files (msbase, mssqlserver, msutil). Driver class name to use is com.microsoft.jdbc.sqlserver.SQLServerDriver. And finally the connection URL is in this form: jdbc:microsoft:sqlserver://servername:port;databaseName=db_name Replace servername, port, and db_name with approriate information. ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186239 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Hosting for Coldfusion
From: Steven Wojciechowski [mailto:[EMAIL PROTECTED] If anyone has any other suggestions of good value CF hosting with good bandwidth packages, then please let me know. If not, then I may have to think about redeveloping in PHP ;) This topic comes up all the time. The archives will be the best bet for research on this topic. I would highly recommend www.hostmysite.com as their service and up time are awesome. Depending upon your needs, they have some excellent plans. Mike ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185933 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Malicious Code Characters
Anyone know of a comprehensive list that outlines what to look for in form input and URLs in terms of malicious code and characters? Thanks, Mike ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185986 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Malicious Code Characters
Thanks! Michael T. Tangorre -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Thursday, December 02, 2004 3:00 PM To: CF-Talk Subject: Re: Malicious Code Characters Tangorre, Michael wrote: Anyone know of a comprehensive list that outlines what to look for in form input and URLs in terms of malicious code and characters? The big mistake: Looking for incorrect input http://www-106.ibm.com/developerworks/linux/library/l-sp2.html#N10062 Jochem ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185999 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Load pages from 2 different domains...
From: Alex Ninan [mailto:[EMAIL PROTECTED] I have a page a.htm on www.a.com and b.htm on www.b.com Is there a way to create a new page (c.htm) on www.a.com to show the a.htm followed by b.htm I trying this without using frames. Look into: cfhhtp Michael T. Tangorre ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184797 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: MX Methodologies (Mach2?? Fusebox??)
From: Ali Awan [mailto:[EMAIL PROTECTED] Thanks Mike and Doug, for pointing me in the right direction. I'm still pretty fuzzy on the whole thing. I still can't figure out how to define listeners and events, in a way that makes sense for the applications I write and work on. For now I'll probably stick to Fusebox 4, and troll the lists you mentioned to see if I get struck by lightning and it all makes sense to me :) I mean I understand the MVC concepts and OO programming in theory, just not the practical uses of it, vis a vis mach-ii and CF. Thanks anyway, Ali Keep at it and ask lots of questions. I haven't met anyone on any of the lists who isn't more than happy to explain concepts, share some insight into best practices, or even share some example code. Start out small with a basic application Model it out. Ask questions about your model and architecture and go from there. When jumping into CFCs, I started out with a simple application which I called Contact Manager which was nothing more than a big rolodex. It will click sooner or later for you... Just keep at it. Are you on the CFCDev list? Listen in there for insight as well as the forums previously mentioned. Good luck! Mike ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184822 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Output by Fiscal Quarter
I have a recordset that I would like to output by Fiscal Qaurter. The query has a condition to pull only records where the year part of the DATE_CREATED value equals the passed in year (@filterYear). Id like to output the records by Fiscal Qtr: FY04 ---QTR1 [Jan-Mar] -record 1 -record 2 -record 3 -record 4 -record 5 ---QTR2 [Apr-Jun] -record 1 -record 2 -record 3 -record 4 -record 5 ---QTR3 [Jul-Sep] -record 1 -record 2 -record 3 -record 4 -record 5 ---QTR4 [Oct-Dec] -record 1 -record 2 -record 3 -record 4 -record 5 How would I go about this in the SQL? I am using SQL Server 2K. Thanks, Mike ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184584 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Output by Fiscal Quarter (SOLVED)
From: Tangorre, Michael [mailto:[EMAIL PROTECTED] I have a recordset that I would like to output by Fiscal Qaurter. The query has a condition to pull only records where the year part of the DATE_CREATED value equals the passed in year (@filterYear). Nevermind. Used to UDFs. All set. Michael T. Tangorre ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184586 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: easy query help
From: Ray Champagne [mailto:[EMAIL PROTECTED] Hey all, I have three tables for an office mgmt app that I am running: I need to get a query that, provided the company_ID, will capture all the domains associated with the company, as well as those domains that have SSL info. SELECT C.*, D.*, S.* FROM Companies C INNER JOIN domains D ON (C.company_ID = D.domain_company_FK) LEFT JOIN SSL_Info S ON (D.domain_ID = S.SSL_domain_FL) WHERE C.company_ID = #companyId# Change C.*, D.*, and S.* to the columns you specifically want. Mike ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184660 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: cflogin
From: Chris Doughty [mailto:[EMAIL PROTECTED] I am using the cflogin tag to control user authentication and session timeout but I am finding that the cflogin structure always exists. What is the loginstorage attribute set to in your cfapplication tag? Michael T. Tangorre ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184259 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: When two tables go to war (JOIN)
From: Micha Schopman [mailto:[EMAIL PROTECTED] cfquery name=showArticle datasource=user020 SELECT A.*, Au.authorID, Au.authorFirstName, A,authorSurname FROM Articles A JOIN Authors Au ON (Au.AuthorID = A.AuthorID) WHERE A. articleID = '#url.updateID# /cfquery Now you get authors * articles on records back. No problem with that. cfset stArticles = structNew() cfloop query=showArticle !--- create first time structure for this specific article --- cfif NOT structKeyExists(stArticles,art_articleID) cfset stArticles[art_articleID] = arrayNew(1) /cfif !--- add this author to the structure for this article --- cfset arrayAppend(stArticles[art_articleID],authorID) /cfloop something like that .. now you can output all data with cfloop collection for example :) You make the calls. As Pascal stated, there is NO need for an INNER JOIN or any type of join for that matter. Stuart wants to populate a list with authors and when an author is selected grab the articles for that author. IMO, the best solution would be to cache the results of a query that got a listing of the authors and another query to get the specific articles for the author. Why would you get all the data at once only to make CF parse through what is desired. Also, two queries keep the purpose of the queries confined whereby allowing better reuse in other areas... Should Stuart need to get a list of authors again, etc. Mike ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183847 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: ADMIN: Editing Account Info?
From: David Collie [mailto:[EMAIL PROTECTED] As I said, I did try and email Mike directly but I've not heard back and was wondering what's up with that section, it hasn't worked for me for about a year... is it something to do with my account, the way I am using it? Hasn't worked for me in a very long time either. I have about 5 rogue accounts floating out there ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183850 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Primary Key Justification
From: Gavin Brook [mailto:[EMAIL PROTECTED] Personally I use an individual primary key myself. In the past I have seen oracle databases with two fields as the primary key, but never a whole record. The only justification I can see for having the whole record as the primary key is to save space. Adding an extra column to store a primary key requires the space to store it and the storage for the sequence. On modern servers storage is not usually a problem, particularly with such a small field. On older mainframes, it was. I can not speak to AS400 as that was the technology in text books 10 years prior my college experience (yes I'm a youngin'). Anyway, any space you might save will be lost when you do updates or selects in which you want a specific record assuming there is a comparable stored procedure concept on AS400. Consider the extra lines needed to determine which record to update or select: UPDATE SET WHERE a=1, b=2, c=3, e=4, f=5 etc etc etc. SELECT FROM .. WHERE a=1, b=2, c=3, e=4, f=5 etc etc etc. Compared to UPDATE SET WHERE a=1 SELECT FROM .. WHERE a=1 That's not to say that there is never a need for compound keys comprised of 2 or 3 columns such as those found in join tables, etc... ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183715 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Mach II
to a booming defense of the FuseDoc process. No more Fusbox vs. Mach-II baitingI promise. Alex What do you have against the FuseDoc process? ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183532 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54