RE: transparent png for ie hack
Just cleaning out OOOD emails I use this for background image pngs. You can either use a transparent gif 1px by 1px in an tag with the same width and height as the png you want to disaply, or set the width: and height: styles along with it. function pngbgstyle(img) { if (findnocase("msie", cgi.user_agent)) { return "filter: progid:DXImageTransform.Microsoft.AlphaImageLoader(src='#img#', sizingMethod=scale)"; } else { return "background-image:url(#img#)"; } } You' -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Saturday, May 14, 2005 4:54 PM To: CF-Talk Subject: ot: transparent png for ie hack anyone know of one that actually works? ~Dave the disruptor~ ~| 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:226586 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: cfopenbb
and now the post initial buzz... I guess its dead all together now huh? -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 1:40 PM To: CF-Talk Subject: 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:221686 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
> if you'd like to see things move faster, feel free to volunteer to help! The main page of the website may detour others from offering their assistance. Maybe you should change it if you need more help. -Original Message- From: Matt Woodward [mailto:[EMAIL PROTECTED] Sent: Friday, August 26, 2005 2:08 PM To: CF-Talk Subject: Re: cfopenbb >Any updates on this effort? The initial buzz seems to have died down. We're working--if you'd like to see things move faster, feel free to volunteer to help! ~| 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:216602 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: QoQ Trouble for Column Names with Spaces
And I assume changing the storedproc would affect other pages? If so would it be too many to adjust? (if you can get at the storedproc and the rest of the app) -Original Message- From: Brendan Baldwin [mailto:[EMAIL PROTECTED] Sent: Thursday, August 25, 2005 4:11 PM To: CF-Talk Subject: Re: QoQ Trouble for Column Names with Spaces I would love to do that, but the problem is I don't have an "original query" -- I retrieving the results from a CFSTOREDPROC and not CFQUERY. :-/ On 8/25/05, Ewok <[EMAIL PROTECTED]> wrote: > > Give it an alias in your original query that doesn't have spaces. > > > -Original Message- > From: Brendan Baldwin [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 25, 2005 11:15 AM > To: CF-Talk > Subject: QoQ Trouble for Column Names with Spaces > > Hi everyone -- > > I'm working for a client who has given me some Oracle stored procedures > which return some fields that have SPACES in the columns returned. > > I want to apply sorting to the results, so I was going to use a CFQUERY > DBTYPE="query" and just ORDER BY selectively-- > > The problem is that I can't seem to reference column names that have > spaces > in them when doing a QoQ ! > > Anyone know how to reference column names with spaces in a QoQ? > > I've tried: > SELECT * FROM thetable ORDER BY 'my column' > SELECT * FROM thetable ORDER BY "my column" > SELECT * FROM thetable ORDER BY [my column] > SELECT * FROM thetable ORDER BY ['my column'] > > Any other Ideas? > > --Brendan > > > > ~| 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:216439 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: QoQ Trouble for Column Names with Spaces
Give it an alias in your original query that doesnt have spaces. mailto:[EMAIL PROTECTED] Sent: Thursday, August 25, 2005 11:15 AM To: CF-Talk Subject: QoQ Trouble for Column Names with Spaces Hi everyone -- I'm working for a client who has given me some Oracle stored procedures which return some fields that have SPACES in the columns returned. I want to apply sorting to the results, so I was going to use a CFQUERY DBTYPE="query" and just ORDER BY selectively-- The problem is that I can't seem to reference column names that have spaces in them when doing a QoQ ! Anyone know how to reference column names with spaces in a QoQ? I've tried: SELECT * FROM thetable ORDER BY 'my column' SELECT * FROM thetable ORDER BY "my column" SELECT * FROM thetable ORDER BY [my column] SELECT * FROM thetable ORDER BY ['my column'] Any other Ideas? --Brendan ~| 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:216380 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: subversion
> What I can't find is any mention of people actually making their repositories available to other people. or how that happens. Do you mean you actually want someone else (who has subversion installed) to have a mirror of your repo or are just simply trying to give others the ability to checkout projects? If that latter... just use svn://ipaddress in a repo browser to checkout projects ( I cant recommend TortoiseSVN highly enough.) As for the stdout, you can avoid all the beeping and weird characters (and probably get something that makes much more sense) if you pipe it to a file when you run it -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Thursday, August 25, 2005 1:05 AM To: CF-Talk Subject: OT: subversion okay... it's late... I'm tired and frustrated... and we're in the midst of a major rollout at my day job... Someone on cf-talk or cf-community recently commented about Subversion, saying that it seemed to be a growing trend for OS projects to distribute their subversion repository info so that people who download the code can get all the revisions in a nice package with lots of controls. So I've finally got Subversion working, and I've finally got all my projects set up with batch files to export and archive the latest version... What I can't find is any mention of people actually making their repositories available to other people. or how that happens. The svnadmin dump command suggested in the documentation writes to "stdout" but doesn't say anything about how to make that useful in any way... If I execute that from a dos prompt, I get several minutes of scrolling text and beeping, rather than a file. What am I missing? How are people making this info available? Do I just zip up the repository? I had hoped there might be a way I could actually isolate an individual project within the repository and export the information for just that project to be packaged and distributed in addition to the source, so that someone downloading the SVN data could download just the data for the projects their interested in, but that doesn't look possible either... This is _REALLY_ frustrating. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| 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:216311 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: bandwidth question
Yes... -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, August 25, 2005 12:46 AM To: CF-Talk Subject: bandwidth question so...if you're using cfftp to retrieve file(s) from external sites daily, does this count as bandwidth in a host's eyes? i would assume so, but i'm not sure. Ray ~| 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:216307 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: Get fields in an Access table
I cant remember exactly step by step but there are hidden system tables in access that you'll need to uncover and give read access to in the actual ..mdb file. I did post the full how-to some time back so just check the archives for my name and access maybe. Id just tell you if I remembered :) Ewok -Original Message- From: Steve Bryant [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 24, 2005 11:40 AM To: CF-Talk Subject: Get fields in an Access table Does anyone know a way to get the all fields (and datatypes) from a table in MS Access using ColdFusion? Thanks! Steve Bryant Bryant Web Consulting LLC http://www.BryantWebConsulting.com/ http://steve.coldfusionjournal.com/ ~| 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:216186 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: (Security) Nigerian Scam Artist CAUGHT!
>Serving suggestion: http://www.sendaturd.com/ Ha! That would be unbelievably funny! > I caught my Nigerian Scam friend! Good going!! -Original Message- From: Clark Slater [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 23, 2005 9:32 PM To: CF-Talk Subject: RE: (Security) Nigerian Scam Artist CAUGHT! >>Stil haven't figured out exactly how to handle giving him a USPS tracking number. >>hm... >>Will Serving suggestion: http://www.sendaturd.com/ ~| 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:216178 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: frickin ie!!!!!!! quick new eyes on css
Seems fine in frickin ie to me :) And yes, thats an ugly green lol -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Saturday, August 20, 2005 2:32 AM To: CF-Talk Subject: frickin ie!!! quick new eyes on css in ie the links in the right side link boxes dont work, supposed to high light ugly green. yet on ie it doesnt, go figure but could me developer error this time lol anyone see anything? http://www.elkhornflyrods.com/store/index.cfm tia ~Dave the disruptor~ "Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time." ~| 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:215868 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: CFLib Warning...
No problem. I hardly think it's worth unsubscribing for. Thanks for the update. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Friday, August 19, 2005 2:18 PM To: CF-Talk Subject: CFLib Warning... Folks, I'm fighting an issue with my mail server now, and some people are getting duplicate copies of the weekly CFLIB email. I apologize for this. More copies may still come as I fight the mail queue. There is no need to email me to let me know about it. If you want ot unsubscribe, as some folks have asked, I do ask that you reconsider since this is just a one time glitch, but if you still want to unsubscribe, please email me at [EMAIL PROTECTED] Again - please forgive the dupes. -- === Raymond Camden, Director of Development for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email: [EMAIL PROTECTED] Blog : ray.camdenfamily.com Yahoo IM : cfjedimaster "My ally is the Force, and a powerful ally it is." - Yoda ~| 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:215853 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: Javascript form question - SOLVED
That was the idea :) I figured you would figure out to put it in your own function. Cheers -Original Message- From: Creese, Eric [mailto:[EMAIL PROTECTED] Sent: Friday, August 19, 2005 1:46 PM To: CF-Talk Subject: RE: Javascript form question - SOLVED Actually I need to do this from a function call not a reset button, however using the onclick format you provided I simply stuck that bit in and it works. Thanks -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: Friday, August 19, 2005 12:12 PM To: CF-Talk Subject: RE: Javascript form question Default One Two Three Four Five -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == ~| 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:215854 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: Javascript form question
Default One Two Three Four Five -Original Message- From: Creese, Eric [mailto:[EMAIL PROTECTED] Sent: Friday, August 19, 2005 12:05 PM To: CF-Talk Subject: Javascript form question Okay I have a form with a series of selection boxes which fill the next selection box. Then I have a radio button choice and depending which radio button is selected a selection box will appear next to the label of the radio button. When I decided to change say the first selection box it at the top fires of a JavaScript on event change and I can get all the selection boxes to hide but I can not get the radio button to reset to the default choice automatically. I am not doing any page refreshes. I can not figure out the JavaScript setting I need to reset the radio button. Can anyone help? -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == ~| 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:215804 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: Site Wide find/replace in cfeclipse
Nevermind... Control+ H -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: Thursday, August 18, 2005 12:33 AM To: CF-Talk Subject: Site Wide find/replace in cfeclipse Anyone know how to do a site wide find and replace in cfeclipse? Please tell me its there! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.12/75 - Release Date: 8/17/2005 ~| 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:215546 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
Site Wide find/replace in cfeclipse
Anyone know how to do a site wide find and replace in cfeclipse? Please tell me its there! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.12/75 - Release Date: 8/17/2005 ~| 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:215544 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: Number of weekdays between dates?
Seems like one of the later CFLib updates had something to get the number of "business days" in a week (I just assume that that means mon-fri). That would make it very easy to get the rest. You might want to check it out. -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 17, 2005 6:11 PM To: CF-Talk Subject: Number of weekdays between dates? Hi All, Is there any pre-packaged function to return the number of week days between two dates. It seems they merged the w and ww attributes for the datediff function in CFMX. TIA, Julian ~| 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:215507 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: N-Selects Related
Duh... good point -Original Message- From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 16, 2005 5:41 PM To: CF-Talk Subject: RE: N-Selects Related Jason, Don't set the multiple attribute--just set the "size" attribute to something like 10. The "multiple" attribute allows multiple items to be selected, the size attribute controls how big the box is. The code is designed w/the expectation that the selectedIndex will have a non-negative value (which a single select element always does.) A multiple select box defaults to having a negative selectedIndex. -Dan >-Original Message- >From: Jason Brown [mailto:[EMAIL PROTECTED] >Sent: Tuesday, August 16, 2005 8:47 AM >To: CF-Talk >Subject: N-Selects Related > >I went out to PengoWorks.com > >http://www.pengoworks.com/workshop/js/gateway/index.cfm#downloads > >and downloaded their N-Selects Related code. The code works great and >my page is functioning perfectly. However, rather than having drop-down >lists I would like Menu lists (display all objects without needing to >click a drop-down button). The problem is that when I convert the >drop-down lists to Menu lists they no longer work. There are four files >that make this code work: > >gateway.js >nRelatedSelect.htm >nRelatedSelect_gw.cfm >zipcodes.mdb > >Can anyone tell me how to correct this issue so I can convert the >drop-down lists to menu lists? > >Thanks. > > >** >Electronic Mail is not secure, may not be read every day, and should not be >used for urgent or sensitive issues. > > ~| 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:215331 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: uploading an image
Put a at the top of the action to make sure the field is even there. Then recheck your form tags, enctype, fieldnames etc... I usually just use -Original Message- From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 16, 2005 8:56 AM To: CF-Talk Subject: uploading an image I'm trying to upload an image to a particular directory to use later. I grabbed this code from a working form I made when I was new to CF and I cleaned it up. Funny enough, now that it's cleaned up, it's not working and I can't see why. It appears that it's saying that the form field (form.image_file) never exists, whether I have selected an image/file or not. Here's the form field: Image: which when submitted then goes to an INSERT page which has the following image code: Please select another from the spotlight form. <--- do an insert here ---> -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu ~| 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:215238 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: N-Selects Related
What would the difference in functionality be if you just added "multiple" to the tags? -Original Message- From: Jason Brown [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 16, 2005 8:47 AM To: CF-Talk Subject: N-Selects Related I went out to PengoWorks.com http://www.pengoworks.com/workshop/js/gateway/index.cfm#downloads and downloaded their N-Selects Related code. The code works great and my page is functioning perfectly. However, rather than having drop-down lists I would like Menu lists (display all objects without needing to click a drop-down button). The problem is that when I convert the drop-down lists to Menu lists they no longer work. There are four files that make this code work: gateway.js nRelatedSelect.htm nRelatedSelect_gw.cfm zipcodes.mdb Can anyone tell me how to correct this issue so I can convert the drop-down lists to menu lists? Thanks. ** Electronic Mail is not secure, may not be read every day, and should not be used for urgent or sensitive issues. ~| 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:215237 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: bitching
Well take one already and get back to CF! -Original Message- From: Connie DeCinko [mailto:[EMAIL PROTECTED] Sent: Saturday, August 13, 2005 5:45 PM To: CF-Talk Subject: RE: bitching Dave, I have only gotten one complaint to take this off list. Interesting how you claim they are telling you. Seems they would be telling me. But all I ever seem to get are more and more job offers. Hmm -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Saturday, August 13, 2005 2:36 PM To: CF-Talk Subject: RE: bitching connie ppl on this list were already emailing me telling me how rude it was of you. and then that other email, there was no need for that, coulda just said you didnt like them, damn like i said, take this off list and I will be more than happy to go at with you but as usual everytime someone askes you to take it off list you dont. I got work to do, which included promoting cfm not bitching about it.. ~| 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:214904 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: raw XML text of a node??
Wrap it with Eg.
RE: NOTHING ABOUT Studio 8 announced IN THIS THREAD
I for one commend Will for trying the shirts out. Personally it's not my "bummish" style so I doubt I'll buy any but I certainly won't come in here and complain that I think they are poor quality when I haven't even held one in my hand and I definitely won't bitch because I think he's taking time to do something that is not directly beneficial to me or this community. I mean damn... he's not my slave... Personally, I like corn flaks but I don't write to the people who make Cocoa Puffs and tell them they suck because they aren't contributing to my idea of a descent breakfast cereal. That would be as retarded as half the posts in this useless thread... A thread that is titled "Studio 8 announced" I might add. What did I learn about Studio 8 in this thread... not a damn thing. And neither will anyone searching the archives that may run into this thread. Besides... if they were poor quality, you guys would have crashed his server downloading the pictures where the shirt was wet because you'd be able to see through it. p.s Dave doesn't piss off... he disrupts :) -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Friday, August 12, 2005 6:11 PM To: CF-Talk Subject: Re: Studio 8 announced Charlie, I off list mailed you and the rest, ya know i am not trying to piss you guys off just make you think about what you are doing and maybe just maybe you'll see what it is and maybe help contribute to instead of degrading what it is that makes you a decent living. TG, I am done with this thead, if you want to go, mail me off list ~Dave the disruptor~ "Some people just don't appreciate how difficult it is to dispense wisdom and abuse at the same time." ~| 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:214864 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: Add additional rows
Actually... if you already have the authors in a database (which I'm just assuming you do since you want a drop down for each), just dump them all into a multi select to begin with. The user can select/deselect multiple items in the list by dragging the mouse down the list or holding control when clicking them Author 1 Author 2 Author 3 Author 4 Author 5 Author 6 Author 7 Author 8 -Original Message- From: Jillian Koskie [mailto:[EMAIL PROTECTED] Sent: Friday, August 12, 2005 10:19 AM To: CF-Talk Subject: Add additional rows Good morning, I have a bit of an unusual problem, that I am hoping has a very easy solution. 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. Has somebody done this that they can either show me / help me through the logic on this one? -- Jillian ~| 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:214789 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
How about one single field for the authors with a button that adds the value to a multi select. Then when you are adding the form values to the database, you just loop over the value of the multi select -Original Message- From: Jillian Koskie [mailto:[EMAIL PROTECTED] Sent: Friday, August 12, 2005 10:39 AM To: CF-Talk Subject: RE: Add additional rows John, I don't think this will work... I would really like to just be able to add as many dropdown lists as required. -- Jillian -Original Message- From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: Friday, August 12, 2005 8:26 AM To: CF-Talk Subject: RE: Add additional rows You could do a pop-up window that handles adding a row to the database and then uses javascript to update a multiple select list with the new option that was added. It's a bit cumbersome, but if you don't know the limits of how many you want to add at a time, that's probably easiest. John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -Original Message- From: Jillian Koskie [mailto:[EMAIL PROTECTED] Sent: Friday, August 12, 2005 10:19 AM To: CF-Talk Subject: Add additional rows Good morning, I have a bit of an unusual problem, that I am hoping has a very easy solution. 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. Has somebody done this that they can either show me / help me through the logic on this one? -- Jillian ~| 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:214780 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: subversion and mapped drive
Why are you using mapped drives? I take it you don't have TortoiseSVN or the SubClipse plugin for Eclipse on your workstations? Or is your repository on a different server than your web server? Here's what I have locally. Subversion is running on the dev server here on my network. All of my workstations have TortoiseSVN (I couldnt live without it). When I set up a new project, I add it to my repo and check it out to a directory on the server that is in the webroot. Then I check out another copy to my work station remotely with TortoiseSVN or SubClipse by browsing to "svn://myserver". (and anyone else that is working on it checks out their own copy) I make all of my changes to the copy on my workstation and commit them back to the repo then "Update" the working dir on the webserver. It sounds like a lot but it's not, especially with TortoieSVN and/or Subclipse. The commits only go to the repository though so you still need to "Update" the working copy on the webserver. You can go to the server and do it or you can write a cfm page to do it for you. I have a svn.cfm template in the root of all my sites so I can hit the page and have the servers working copy updated. Here is an example of one... Svn.cfm --- My svnupdate.bat file is on the root of C and has only two lines... Svnupdate.bat -- @echo off svn update %1 svn.cfm will print the current revision your project is at as well as a list of files it updated. As for moving a project to production, you "Export" a copy from the repo. Using the export command will strip out a clean copy of the project (no .svn directories) A company I do a ton of work for has basically the same setup. I can also browse their repository from home and checkout projects from there. I was a little reluctant at first to give up the old reliable FTP but this setup is great. Hope that gives some ideas. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.5/67 - Release Date: 8/9/2005 ~| 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:214364 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: DatePart and QoQ ?
Thanks, but I didn't find anything there about valid SQL functions for QoQ's that's why I asked here. And they're not too friendly to me either :) Thanks again -Original Message- From: Douglas Knudsen [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 09, 2005 9:18 PM To: CF-Talk Subject: Re: DatePart and QoQ ? http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/using_re.htm gd luck...QofQ is not so friendly to me with this sort of thing. DK On 8/9/05, Ewok <[EMAIL PROTECTED]> wrote: > Does anyone know of a list of valid SQL functions for use in a QoQ. > Primarily, I need to compare the day part of a date with a number inside a > QoQ but a good list of valid QoQ SQL functions would be nice to have for > future reference. > > > > Thanks > > > -- > No virus found in this outgoing message. > Checked by AVG Anti-Virus. > Version: 7.0.338 / Virus Database: 267.10.4/66 - Release Date: 8/9/2005 > > > > ~| 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:214286 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: Deploying site using Subversion and FTP
Use the "Export" command to strip out a clean, server worthy copy of your project. This will exclude all of the .svn directories. -Original Message- From: Stan Winchester [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 09, 2005 8:17 PM To: CF-Talk Subject: Deploying site using Subversion and FTP We are starting to use subversion with TortoiseSVN and we were wondering how others deploy sites using FTP. We noticed in our local working copies there are ".svn" sub-directories in every directory. How do we make sure the ".svn" sub-directories don't get deployed to a live server? Thank you, Aftershock Web Design, Inc. by: Stan Winchester President/Developer [EMAIL PROTECTED] http://www.aftershockweb.com/ Phone 503-244-3440 Fax 503-244-3454 ~| 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:214282 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
DatePart and QoQ ?
Does anyone know of a list of valid SQL functions for use in a QoQ. Primarily, I need to compare the day part of a date with a number inside a QoQ but a good list of valid QoQ SQL functions would be nice to have for future reference. Thanks -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.4/66 - Release Date: 8/9/2005 ~| 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:214273 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: URL question
Not exactly sure what it is but all of these work fine on my dev server: www.mysite.com?var=1 www.mysite.com/?var=1 www.mysite.com/index.cfm?var=1 but only the last one works in production. We are running the same versions of windows/IIS/CF on both so it is a setting somewhere. So... yes. There's a potential pitfall -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 09, 2005 8:42 AM To: CF-Talk Subject: URL question I gave my affiliate a URL to link to my site, which I grab the variable and do my thing with it. His link SHOULD BE: www.mysite.com?AFFID=101 But he did this instead: www.mysite.com/?AFFID=101 Everything still works fine when testing but I didn't know if there could be a potential pitfall with the extra slash in there. Thanks, Will ~| 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:214164 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: Deployment of Multiple Websites with almost identical Info
How about just sharing a datasource? You could have the main tables that are shared across the sites then you could have individual news tables or whatever else needs to be specific to certain sites. One update to the main shared tables would reflect across all the sites and individual table updates would only show on the sites that query those tables. Tbl_main_bulk_info Tbl_US_News Tbl_UK_News Tbl_US_Events Tbl_UK_Events Etc... Depending on your table naming conventions, you could even make it that much easier by setting a variable on the individual sites like... Then when you query say the news for the site you query "tbl_#countrycode#_news" The code would be the same on all sites Just some thoughts -Original Message- From: Butch Zaccheo [mailto:[EMAIL PROTECTED] Sent: Monday, August 08, 2005 12:47 PM To: CF-Talk Subject: Deployment of Multiple Websites with almost identical Info Hi Everyone, My company has asked me to deploy multiple websites for multiple countries each with it¹s own domain. Each country will have info slightly modified to reflect their own information (events, news, special promos), but the bulk of the information will be the same. Here¹s my question: 1. What are other web developers doing in this circumstance? 2. Is there cf content management software that would allow me to use multiple domains and maintain only one whole site, sharing pages that would be the same for every site? 3. Or should I deploy a site for each domain and update each manually even though most of the info is the same? Hopefully this isn¹t to broad a question for this list. I¹m very interested to find out if others in the CF community already have working solutions. Any help would be much appreciated. Butch Zaccheo Web Development Edirol Corporation ~| 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:214051 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: String replace
Whoa whoa.. slow down there with the send button :) The process would go like so... Select * from table UPDATE table Set querycolumn = '#newvalue#' Where TheRecordsID = #TheRecordsID# Thats it... Querycolumn of course is the field name in your database that holds the values you are trying to edit. TheRecordID is the primary key for the table So if the table with those records looks like so... FieldID MyValue 1 Adi5RT-Flo12Roy-3(Lg) 2 Adi5RT-FSU2Red-2(Md) 3 Adi5RT-FSU2Red-3(Lg) 4 Adi5RT-FSU2Red-4(XL) 5 Adi5RT-FSU2Red-5(2X) 6 Adi5RT-FSU3Wht-2(Md) 7 Adi5RT-FSU3Wht-3(Lg) The querycolumn would be 'MyValue' and the TheRecordID would be 'FieldID'. -Original Message- From: Ken [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 03, 2005 9:16 PM To: CF-Talk Subject: Re: String replace Hi. This may be a stupid question, but which of this loops can I use to run a update SQL statement to replace the original values with the new ones? Thanks again. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.9.8/61 - Release Date: 8/1/2005 ~| 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:213698 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: String replace
Sorry. I was going with your sample data. They all only had 2 dashes. This will work as well. I'm sure there's a cleaner regex for it but like I said... I suck at those. I was surprised to get the last one to work at all to be honest with you. As for updating all the records... can't you just select them, loop them, and update them? This isnt something you are going to do redundantly is it? Seems to be more of a one-time clean up script? So instead of the array, it would be your query results. -Original Message- From: Ken [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 03, 2005 8:41 PM To: CF-Talk Subject: Re: String replace Also, in your code, you are presuming there will always be 2 dashes in the string. The code won't work if there are 3 dashes, Like this: Adi5RT-Flo12-Roy-3(Lg). Can this code be made flexible? On 8/3/05, Ewok <[EMAIL PROTECTED]> wrote: > This seems to work as well ( to my surprise since I suck at regex's) > > > > > > > > > > > > > > > > > > > > > -Original Message- > From: Ken [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 03, 2005 8:05 PM > To: CF-Talk > Subject: String replace > > Hi I have a db column as displayed below. I want to replace the last > "-" with a underscore "_". Note: I don't want to replace all the > dashes. Just the last one. It should look like this: > Adi5RT-Flo12Roy_3(Lg). Any ideas? > > Adi5RT-Flo12Roy-3(Lg) > Adi5RT-FSU2Red-2(Md) > Adi5RT-FSU2Red-3(Lg) > Adi5RT-FSU2Red-4(XL) > Adi5RT-FSU2Red-5(2X) > Adi5RT-FSU3Wht-2(Md) > Adi5RT-FSU3Wht-3(Lg) > > Thanks, > Kenny > > > > > > ~| 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:213683 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: String replace
This seems to work as well ( to my surprise since I suck at regex's) -Original Message- From: Ken [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 03, 2005 8:05 PM To: CF-Talk Subject: String replace Hi I have a db column as displayed below. I want to replace the last "-" with a underscore "_". Note: I don't want to replace all the dashes. Just the last one. It should look like this: Adi5RT-Flo12Roy_3(Lg). Any ideas? Adi5RT-Flo12Roy-3(Lg) Adi5RT-FSU2Red-2(Md) Adi5RT-FSU2Red-3(Lg) Adi5RT-FSU2Red-4(XL) Adi5RT-FSU2Red-5(2X) Adi5RT-FSU3Wht-2(Md) Adi5RT-FSU3Wht-3(Lg) Thanks, Kenny ~| 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:213678 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: String replace
Here's a quick and dirty one... -Original Message- From: Ken [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 03, 2005 8:05 PM To: CF-Talk Subject: String replace Hi I have a db column as displayed below. I want to replace the last "-" with a underscore "_". Note: I don't want to replace all the dashes. Just the last one. It should look like this: Adi5RT-Flo12Roy_3(Lg). Any ideas? Adi5RT-Flo12Roy-3(Lg) Adi5RT-FSU2Red-2(Md) Adi5RT-FSU2Red-3(Lg) Adi5RT-FSU2Red-4(XL) Adi5RT-FSU2Red-5(2X) Adi5RT-FSU3Wht-2(Md) Adi5RT-FSU3Wht-3(Lg) Thanks, Kenny ~| 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:213677 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: random password generator
http://tutorial176.easycfm.com/ -Original Message- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 27, 2005 9:57 AM To: CF-Talk Subject: Re: random password generator >>Many of the ones on the macromedia exchange are for much older versions of ColdFusion. Is it eally a reason they are not good anymore?. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| 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:213005 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: Subversion
Well it's not a great solution but you could hit File > Open or just Control + O (just to get the windows file browser up) and do all your updates, checkouts or commits there. -Original Message- From: Douglas Knudsen [mailto:[EMAIL PROTECTED] Sent: Friday, July 22, 2005 11:16 AM To: CF-Talk Subject: Re: Subversion On 7/22/05, Ken Ferguson <[EMAIL PROTECTED]> wrote: > This is true, I've had it working with CVS this way using Tortoise in > Studio/Homesite+ > yes, except it only works in the folder area of the file dialog in Homesite, not the files area. So, you can update, commit, etc at the folder level, not at teh file level DK > > --Ferg > > > Barney Boisvert wrote: > > >>Barney, I don't think you can access TortoiseSVN commands in the file panel > >>of Dream Weaver > >> > >> > > > >I know you can't do it in DW, but I'm pretty sure Studio (and > >HomeSite) use the native windows explorer for rendering their file > >lists, so the shell extensions will work. I seem to recall this > >coming up as suggested usage in previous discussions on this list > >about integrating CVS into Studio. But again, I've never tried it. > > > >cheers, > >barneyb > > > >On 7/21/05, Ewok <[EMAIL PROTECTED]> wrote: > > > > > >>Subversion is great! Eclipse is great! The two together are awesome. I'd > >>highly recommend using them in conjunction. You'll love it. > >> > >>Barney, I don't think you can access TortoiseSVN commands in the file panel > >>of Dream Weaver but you probably could map a network drive if the files > >>weren't local. It would be nice if you could get at them in DW though since > >>I can't get eclipse running right on anything other than my laptop. Oh well, > >>that's a good excuse to build a new machine :) > >> > >> > >> > > > > > > > > > ~| 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:212554 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: Subversion
Cool, ill have to put homesite on this machine and try it. thanks -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Friday, July 22, 2005 1:12 AM To: CF-Talk Subject: Re: Subversion > Barney, I don't think you can access TortoiseSVN commands in the file panel > of Dream Weaver I know you can't do it in DW, but I'm pretty sure Studio (and HomeSite) use the native windows explorer for rendering their file lists, so the shell extensions will work. I seem to recall this coming up as suggested usage in previous discussions on this list about integrating CVS into Studio. But again, I've never tried it. cheers, barneyb On 7/21/05, Ewok <[EMAIL PROTECTED]> wrote: > Subversion is great! Eclipse is great! The two together are awesome. I'd > highly recommend using them in conjunction. You'll love it. > > Barney, I don't think you can access TortoiseSVN commands in the file panel > of Dream Weaver but you probably could map a network drive if the files > weren't local. It would be nice if you could get at them in DW though since > I can't get eclipse running right on anything other than my laptop. Oh well, > that's a good excuse to build a new machine :) > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~| 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:212552 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: Subversion
[if I have Eclipse open and I double-click on a cfm file on my desktop, I wish it would just open the damn file instead of going through all the business about "workspace already in use...".] INDEED!! lol -Original Message- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: Friday, July 22, 2005 9:14 AM To: CF-Talk Subject: Re: Subversion This is true, I've had it working with CVS this way using Tortoise in Studio/Homesite+ On Eclipse, I've been using it now for a few months with CVS and I love it except for one thing. I may just be missing something, but it seems as if you can't just open a file without saving it... I like the way Homesite+ works where things don't need to be in projects or anything like that, ctrl+n and you got a new file - no fuss. I think working in Eclipse is great, but this does bother me. Also, if I have Eclipse open and I double-click on a cfm file on my desktop, I wish it would just open the damn file instead of going through all the business about "workspace already in use...". These are the types of things I hate about DW; why can't the IDEs just stay out of the way, but still provide great utility? --Ferg Barney Boisvert wrote: >>Barney, I don't think you can access TortoiseSVN commands in the file panel >>of Dream Weaver >> >> > >I know you can't do it in DW, but I'm pretty sure Studio (and >HomeSite) use the native windows explorer for rendering their file >lists, so the shell extensions will work. I seem to recall this >coming up as suggested usage in previous discussions on this list >about integrating CVS into Studio. But again, I've never tried it. > >cheers, >barneyb > >On 7/21/05, Ewok <[EMAIL PROTECTED]> wrote: > > >>Subversion is great! Eclipse is great! The two together are awesome. I'd >>highly recommend using them in conjunction. You'll love it. >> >>Barney, I don't think you can access TortoiseSVN commands in the file panel >>of Dream Weaver but you probably could map a network drive if the files >>weren't local. It would be nice if you could get at them in DW though since >>I can't get eclipse running right on anything other than my laptop. Oh well, >>that's a good excuse to build a new machine :) >> >> >> > > > ~| 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:212553 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: Subversion
Subversion is great! Eclipse is great! The two together are awesome. I'd highly recommend using them in conjunction. You'll love it. Barney, I dont think you can access TortoiseSVN commands in the file panel of Dream Weaver but you probably could map a network drive if the files weren't local. It would be nice if you could get at them in DW though since I can't get eclipse running right on anything other than my laptop. Oh well, that's a good excuse to build a new machine :) -Original Message- From: loathe [mailto:[EMAIL PROTECTED] Sent: Thursday, July 21, 2005 11:30 PM To: CF-Talk Subject: RE: Subversion Yeah, I have eclipse here at the house. Just didn't want to take the time to DL it and set it all up. Oh well I'll do it tomorrow. Tim > -Original Message- > From: Barney Boisvert [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 21, 2005 10:29 PM > To: CF-Talk > Subject: Re: Subversion > > > Nope, but I believe (having never done it) that if you install Tortise > SVN, you can use the explorer extensions from within Studio's file > panel. > > However, if you're really looking for an integrated dev environment, > I'd highly recommend checking out Eclipse, and the CFEclipse plugin. > Eclipse comes with very good CVS and Subversion support, and the > CFEclipse plugin provides a very solid CFML coding environment. Best > of all, they're 100% integrated, so you can seamlessly use the two > together. Worth it's weight in gold, if you ask me, and definitely > worth sacrificing some of the bells and whistles DW and Studio have. > > cheers, > barneyb > > On 7/21/05, Loathe <[EMAIL PROTECTED]> wrote: > > Hey, > > > > I am starting a new project and it's in subversion. Does CF Studio 5 or > > Dreamweaver tie in directly? > > > > Tim > > > > -- > Barney Boisvert > [EMAIL PROTECTED] > 360.319.6145 > http://www.barneyb.com/ > > Got Gmail? I have 50 invites. > > ~| 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:212489 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Query Question
You seem to be going out of the way and way off the topic of the question to prove that it's okay to use your methods Jochem. No one said it wasn't okay. My point was that if he's having trouble with something that shouldnt be hard, then break it down to its simplest form and give every column its own purpose. > Not at all, you can link tables in many ways: No, I'm pretty sure that relating columns is the only way to link tables to one another. > I always get annoyed if people write something I don't > understand. Especially if there is little explanation when asked. I'm sorry, but I dont know how else to explain it. The phrase, "Easier that it already is", is hardly 'street language' and can't be easier to understand than it already is. :) Unless its a solution to the original question, which I've seen no one else offer yet, I say we drop this topic all together. Especially since Jeff hasn't bothered to give us more input. This thread is becoming more and more useless with every rebuttal and we are just adding more keywords to the archives that point to a pointless debate. -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Sunday, May 22, 2005 3:10 AM To: CF-Talk Subject: Re: SQL Query Question Ewok wrote: >> >> this is by far the easiest way to link tables. > > No... Its the only way to "link" tables that's why we do it. Not at all, you can link tables in many ways: you just have to do it all by hand instead of using the features that are provided by the database. > It seems that you are becoming a little uptight about this I always get annoyed if people write something I don't understand. Especially if there is little explanation when asked. It is important to write proper English if you want people that learned English as a second language to understand what you are writing. We learned English from newspaper articles and books and that is the language we understand, not street language. Jochem ~| 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:207392 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: Dynamic Struct/Query Path
Yup.. forgot to take them out when I was looking to see if it was building it right...blah blah. thanks -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Sunday, May 22, 2005 12:05 AM To: CF-Talk Subject: RE: Dynamic Struct/Query Path got some extra quotes and pounds in there... #myStruct[listfirst(str,'.')][listlast(str,'.')]# > And without evaluate > > #myStruct['#listfirst(str, '.')#']['#listlast(str, > '.')#']# > -Original Message- > From: Ewok [mailto:[EMAIL PROTECTED] > Sent: Saturday, May 21, 2005 7:37 PM > To: CF-Talk > Subject: RE: Dynamic Struct/Query Path > > #evaluate('myStruct.#str#')# > -Original Message- > From: Kevin Aebig [mailto:[EMAIL PROTECTED] > Sent: Saturday, May 21, 2005 6:41 PM > To: CF-Talk > Subject: Dynamic Struct/Query Path > Hey all, > I'm trying to build the path to a value stored in struct / > query. > > > > > > > if I have "betterhalf.firstname" as a string variable and > a reference to > myStruct, how do I get the value. I can't seem to get it > to go using > Evaluate... s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| 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:207375 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: Dynamic Struct/Query Path
And without evaluate #myStruct['#listfirst(str, '.')#']['#listlast(str, '.')#']# -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: Saturday, May 21, 2005 7:37 PM To: CF-Talk Subject: RE: Dynamic Struct/Query Path #evaluate('myStruct.#str#')# -Original Message- From: Kevin Aebig [mailto:[EMAIL PROTECTED] Sent: Saturday, May 21, 2005 6:41 PM To: CF-Talk Subject: Dynamic Struct/Query Path Hey all, I'm trying to build the path to a value stored in struct / query. if I have "betterhalf.firstname" as a string variable and a reference to myStruct, how do I get the value. I can't seem to get it to go using Evaluate... Any ideas? Cheers, Kevin ~| 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:207366 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Query Question
True, more would be helpful. But a unique identifier would serve the purpose of deciding which was entered last which I believed he asked... but only he could clarify that and since he's not responding with any input... :) you calling Jochem a wookie? hehe -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Saturday, May 21, 2005 8:04 PM To: CF-Talk Subject: RE: SQL Query Question > After all, what hes having trouble with would be "less > trouble than it' already not" if they existed here. I would expect in this case that having a primary key on the table he described wouldn't change the sql syntax much (if at all). I still like to have a primary key on these sorts of tables, but that's more of a preference at that point. Though I might have also designed the schema with two tables instead of one -- one table to contain the last entry and a separate table to contain all historical entries. It's hard to say without knowing more about the specifics of the app. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~| 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:207365 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: Dynamic Struct/Query Path
#evaluate('myStruct.#str#')# -Original Message- From: Kevin Aebig [mailto:[EMAIL PROTECTED] Sent: Saturday, May 21, 2005 6:41 PM To: CF-Talk Subject: Dynamic Struct/Query Path Hey all, I'm trying to build the path to a value stored in struct / query. if I have "betterhalf.firstname" as a string variable and a reference to myStruct, how do I get the value. I can't seem to get it to go using Evaluate... Any ideas? Cheers, Kevin ~| 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:207362 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Query Question
> In English please. My sentiments exactly :) But... "easier than it already is" Anyway, you have your way and everyone else has theirs. If the way you are using is making it more difficult for you than it needs to be and can be simplified, then by all means simplify it. And I will most definitely have to disagree that adding a unique identifier to allow the table to stand on its own without the relations is hardly more complicated. > this is by far the easiest way to link tables. No... Its the only way to "link" tables that's why we do it. But he didnt ask for data from multiple tables or how to link them, he asked for data from one table... the one without unique identifiers. It seems that you are becoming a little uptight about this (of course I could be wrong, it's hard to read tone) but please dont take any of this as an attack on your methods or a defense of my own. I've read a lot of your posts and solutions and have nothing but respect for you... I just respectfully disagree here. Nothing more. If your not getting uptight... I'll drop it here anyway because... well... pro-longed exposure to me tends to make people that way :) -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Saturday, May 21, 2005 6:27 PM To: CF-Talk Subject: Re: SQL Query Question Ewok wrote: > I guess that痴 one way of looking at it... I think creating the need to > combine them is more work than its worth or would ever need to be. Valid or > invalid, I still recommend something a little more easier to differentiate > records with such as a single unique key per record. I think adding an extra field solely for a unique identifier only complicates the matter. Especially in many to many relations this is by far the easiest way to link tables. Though I suppose that if you really needed to you could always define a composite type. > After all, what hes having trouble with would be "less trouble than it' > already not" if they existed here. In English please. Jochem ~| 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:207360 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: SQL Query Question
I guess thats one way of looking at it... I think creating the need to combine them is more work than its worth or would ever need to be. Valid or invalid, I still recommend something a little more easier to differentiate records with such as a single unique key per record. After all, what hes having trouble with would be "less trouble than it' already not" if they existed here. -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Saturday, May 21, 2005 2:41 PM To: CF-Talk Subject: Re: SQL Query Question Ewok wrote: > How so with duplicates of both? Because combined they are a unique identifier. Jochem ~| 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:207356 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: SQL Query Question
I meant order descending by actid too, sorry. But maybe im misunderstanding your data structure since others see it a different way. Another... way group your cfouput... select * from q order by crid, actid desc crIDactID description owner #crid##actID# #description# #owner# -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: Friday, May 20, 2005 10:40 PM To: CF-Talk Subject: RE: SQL Query Question Use distinct and order descending by crid. In the future, I highly recommend a unique key (PK) or at least a date/time field to decide which are the latest records -Original Message- From: Jeff Chastain [mailto:[EMAIL PROTECTED] Sent: Friday, May 20, 2005 9:59 AM To: CF-Talk Subject: OT: SQL Query Question Sorry for the off-topic, but I have been beating on this one for a while and the only answer I can find is really, really ugly. So, hopefully somebody knows more about queries that I do and can show me the error of my ways I have a table that looks something like this crIDactIDdescriptionowner 1 1Test 444 1 2Test Update124 2 1Test 578 Now, what I need is a listing of all distinct crID records, where the actID is the greatest. Basically, this is a history setup. There are a series of change requests (crID) that each have 1 or more actions (actID). I need a snapshot of the most recent status of each change request ( max(actID) ). The problem I am having is with the aggregate functions and getting all of the rest of the fields at the same time. The following query returns the correct crID / actID combination, but how do I get the other fields? SELECT crID, MAX(actID) AS actID FROM test GROUP BY crID The only thing I have come up with thus far is having to run another query for each record returned in the above query in order to get the additional details and a query per row just can't be a good thing. The resulting data set that I am looking for would be as follows crIDactIDdescriptionowner 1 2Test Update124 2 1Test 578 Any pointers would be greatly appreciated and would save the few brain cells I have left. Thanks -- Jeff ~| 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:207348 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: SQL Query Question
How so with duplicates of both? -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Saturday, May 21, 2005 10:13 AM To: CF-Talk Subject: Re: SQL Query Question Ewok wrote: > Use distinct and order descending by crid. In the future, I highly recommend > a unique key (PK) or at least a date/time field to decide which are the > latest records The datamodel is fine, crID and actID function nicely as composite primary key. Jochem ~| 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:207346 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: adding subtotals
I didnt mean to send that just yet :) I assumed you meant adding it in a query versus CF... This will get distinct purchaserIDs and their total dollars spent on any all together SELECT purchaserid, sum(itemPrice) as TheTotal FROM itemsPurchased group by purchaserid This will break the previous results down by items and the total amounts purchaserID spent on them. SELECT purchaserid, itemid, sum(itemPrice) as TheTotal FROM itemsPurchased group by purchaserid, itemid just add your 'where purchaserid = #purchaserid#' to get a specific one. -Original Message----- From: Ewok [mailto:[EMAIL PROTECTED] Sent: Friday, May 20, 2005 10:47 PM To: CF-Talk Subject: RE: adding subtotals SELECT sum(itemPrice) as TheTotal FROM itemsPurchased WHERE purchaserID = '#purchaserID#' -Original Message- From: mayo [mailto:[EMAIL PROTECTED] Sent: Friday, May 20, 2005 9:15 PM To: CF-Talk Subject: adding subtotals I'm completely blanking on how to add subtotals. I'll explain clearer below: I have a table of itemsPurchased that includes itemID itemQty and itemPrice. SELECT itemID, itemQty, itemPrice FROM itemsPurchased WHERE purchaserID = '#purchaserID#' Say person A bought 3 items at $10 and 2 items at $20 I have no trouble arriving at the subtotals (30 and 40 in this example) but now I want to add these for 70. I can't get this . getting . tired . not thinking straight . Thx, gil ~| 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:207330 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: adding subtotals
SELECT sum(itemPrice) as TheTotal FROM itemsPurchased WHERE purchaserID = '#purchaserID#' -Original Message- From: mayo [mailto:[EMAIL PROTECTED] Sent: Friday, May 20, 2005 9:15 PM To: CF-Talk Subject: adding subtotals I'm completely blanking on how to add subtotals. I'll explain clearer below: I have a table of itemsPurchased that includes itemID itemQty and itemPrice. SELECT itemID, itemQty, itemPrice FROM itemsPurchased WHERE purchaserID = '#purchaserID#' Say person A bought 3 items at $10 and 2 items at $20 I have no trouble arriving at the subtotals (30 and 40 in this example) but now I want to add these for 70. I can't get this . getting . tired . not thinking straight . Thx, gil ~| 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:207329 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: SQL Query Question
Use distinct and order descending by crid. In the future, I highly recommend a unique key (PK) or at least a date/time field to decide which are the latest records -Original Message- From: Jeff Chastain [mailto:[EMAIL PROTECTED] Sent: Friday, May 20, 2005 9:59 AM To: CF-Talk Subject: OT: SQL Query Question Sorry for the off-topic, but I have been beating on this one for a while and the only answer I can find is really, really ugly. So, hopefully somebody knows more about queries that I do and can show me the error of my ways I have a table that looks something like this crIDactIDdescriptionowner 1 1Test 444 1 2Test Update124 2 1Test 578 Now, what I need is a listing of all distinct crID records, where the actID is the greatest. Basically, this is a history setup. There are a series of change requests (crID) that each have 1 or more actions (actID). I need a snapshot of the most recent status of each change request ( max(actID) ). The problem I am having is with the aggregate functions and getting all of the rest of the fields at the same time. The following query returns the correct crID / actID combination, but how do I get the other fields? SELECT crID, MAX(actID) AS actID FROM test GROUP BY crID The only thing I have come up with thus far is having to run another query for each record returned in the above query in order to get the additional details and a query per row just can't be a good thing. The resulting data set that I am looking for would be as follows crIDactIDdescriptionowner 1 2Test Update124 2 1Test 578 Any pointers would be greatly appreciated and would save the few brain cells I have left. Thanks -- Jeff ~| 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:207328 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: Anyone know of a more elegant way to do this?
No problem (and good luck) Let us know if you shut the doors when you hit 99ZZ :^O -Original Message- From: SStewart [mailto:[EMAIL PROTECTED] Sent: Thursday, May 19, 2005 9:11 AM To: CF-Talk Subject: RE: Anyone know of a more elegant way to do this? Ewok... This works, Thanks sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 18, 2005 06:03 pm To: CF-Talk Subject: RE: Anyone know of a more elegant way to do this? Importance: Low Sorry, first one didnt come through I guess... here it is again This doesnt take into account that you may reach ZZ will you actually have that many on one project? It seems like it would throw your whole numbering out of whack if so anyway. I definitely agree with Claude (Im sure you do too) but if you can manage to start with a new schema it would save a lot of future headache... like actually having 01000AA - 01000ZZ and needing another since the number seems to be more of a main project indicator and the letters revisions or changes/updates... anyway... This will increment the letters AA - AZ and roll AZ to BA. It's by no means perfect either but it's not 1000 lines of code :) select * from q order by jobid desc #NumberPrefix##NewFirstLetter##newLastLetter# -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.12 - Release Date: 5/17/2005 ~| 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:207202 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: Anyone know of a more elegant way to do this?
Ok, so I'm bored today... This one DOES take into account the "ZZ" scenario and increment the number portion as well... #incProjNum("001000ZZ")# Will spit out 001001AA I dont know what Outlook or HoF is going to do to the formatting of this but just paste it into a template and it should come out fine. function incProjNum(LastjobNumber) { alpha = "A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z"; FirstLetter = ucase(left(right(LastJobNumber, 2), 1)); LastLetter = ucase(right(ucase(LastJobNumber), 1)); NumberPrefix = rereplace(LastJobNumber, "[^0-9]", "", "ALL"); NewNumberPrefix = NumberPrefix; if (FirstLetter & LastLetter is "ZZ") { IncrementLetters = false; NewFirstLetter = "A"; NewLastLetter = "A"; } else { IncrementLetters = true; } if (IncrementLetters) { if (LastLetter is "Z") { NewLastLetter = "A"; IncrementFirst = true; } else { LastLetterPosition = ListFind(alpha, LastLetter); NewFirstLetter = FirstLetter; NewLastLetter = ListGetAt(alpha, LastLetterPosition+1); IncrementFirst = false; } if (IncrementFirst) { FirstLetterPosition = ListFind(alpha, FirstLetter); NewFirstLetter = ListGetAt(alpha, FirstLetterPosition+1); } } else { NewNumberPrefix = numberformat(NumberPrefix + 1, "00"); } return NewNumberPrefix & NewFirstLetter & NewLastLetter; } -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.12 - Release Date: 5/17/2005 ~| 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:207099 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: but funny just the same.
Let me try that again... http://ned.bounceme.net/Tattoo2.jpg -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 18, 2005 6:07 PM To: CF-Talk Subject: RE: but funny just the same. What the heck does your email client/server do to hyperlinks!?! :Oo -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: 18 May 2005 22:59 To: CF-Talk Subject: WOT: but funny just the same. Im not trying to start a discussion on this. I just thought you guys might get a kick out of it. HYPERLINK "http://ned.bounceme.net/Tattoo2.jpg"http://ned.bounceme.net/Tattoo2.jpg -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.12 - Release Date: 5/17/2005 ~| 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:207098 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: Anyone know of a more elegant way to do this?
Sorry, first one didnt come through I guess... here it is again This doesnt take into account that you may reach ZZ will you actually have that many on one project? It seems like it would throw your whole numbering out of whack if so anyway. I definitely agree with Claude (Im sure you do too) but if you can manage to start with a new schema it would save a lot of future headache... like actually having 01000AA - 01000ZZ and needing another since the number seems to be more of a main project indicator and the letters revisions or changes/updates... anyway... This will increment the letters AA - AZ and roll AZ to BA. It's by no means perfect either but it's not 1000 lines of code :) select * from q order by jobid desc #NumberPrefix##NewFirstLetter##newLastLetter# -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.12 - Release Date: 5/17/2005 ~| 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:207095 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
WOT: but funny just the same.
Im not trying to start a discussion on this. I just thought you guys might get a kick out of it. HYPERLINK "http://ned.bounceme.net/Tattoo2.jpg"http://ned.bounceme.net/Tattoo2.jpg -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.12 - Release Date: 5/17/2005 ~| 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:207094 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: Anyone know of a more elegant way to do this?
This doesnt take into account that you may reach ZZ will you actually have that many on one project? It seems like it would throw your whole numbering out of whack if so anyway. I definitely agree with Claude (Im sure you do too) but if you can manage to start with a new schema it would save a lot of future headache... like actually having 01000AA - 01000ZZ and needing another since the number seems to be more of a main project indicator and the letters revisions or changes/updates... anyway... This will increment the letters AA - AZ and roll AZ to BA. It's by no means perfect either but it's not 1000 lines of code :) select * from q order by jobid desc #NumberPrefix##NewFirstLetter##newLastLetter# -Original Message- From: SStewart [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 18, 2005 2:34 PM To: CF-Talk Subject: Anyone know of a more elegant way to do this? I'm incrementing a project number, it's an alpha-numeric "number" (001000A or 001000AA) if it's a new project I just grab the first six numbers and increment, if it's an extended project I have to increment the letter with the next one. My code works but it's kind of a battering ram approach, is there a more elegant way to do this? Thanks sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -Original Message- From: Adkins, Randy [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 18, 2005 11:08 am To: CF-Talk Subject: RE: Good Site Stats Tag Recommendation Importance: Low I like the look of Statistex however, I was going to obtain The full version but the wellmanweb site does not exist any Longer. I know awstats is off of sourceforge and is free, just never Was able to get mine to work. Sorry.. My 2 cents -Original Message- From: Steve Kahn [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 18, 2005 11:05 AM To: CF-Talk Subject: Good Site Stats Tag Recommendation Anyone have a good site stats tag recommendation? Thanks Steve ~| 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:207093 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: text formatting
Fckeditor would probably get you closest to the original formatting. But if you dont want to use that, this should get 90% of your line breaks. As for line breaks, I usually just use #replace(str, "#chr(13)##chr(10)#", "", "ALL")# You could do the same thing for tabs (just replace them with spaces or whatever) -Original Message- From: Doug Strickland [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 17, 2005 5:10 PM To: CF-Talk Subject: text formatting I am building a form that allows a user to 'cut and paste' their resume into a textarea. I then take this data, and insert it into the database. When re-displayed, it looks horrible; there is no formatting at all. I tried using the paragraphFormat() function, but this didn't really help too much. I don't want anything fancy, I just need it to at least recognize line breaks, tabs etc. If anyone knows of a solution for this, or can point me in the right direction, I would greatly appreciate it...thanks! -Doug ~| 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:206946 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: transparent png for ie hack
I didn't. I tried it out in a php page -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Saturday, May 14, 2005 8:34 PM To: CF-Talk Subject: RE: transparent png for ie hack the php one? how did you call that in the cfm template? ~Dave the disruptor~ From: "Ewok" <[EMAIL PROTECTED]> Sent: Saturday, May 14, 2005 8:28 PM To: CF-Talk Subject: RE: transparent png for ie hack That thing works great Dave! If I didn't suck so bad at regex's I'd give it a go in CF :/ Has the RegEx Ninja wrote a book yet? hint hint (Where is Ben anyway?) Okay, okay, gotta go... just hope they have more beer wherever it is that I'm dragged to... -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Saturday, May 14, 2005 6:06 PM To: CF-Talk Subject: RE: transparent png for ie hack I have a few i am gunna try, this one looks interesting, written in php, if it works maybe we could rewrite it in cfm. http://koivi.com/ie-png-transparency/ ~Dave the disruptor~ ---- From: "Ewok" Sent: Saturday, May 14, 2005 5:38 PM To: CF-Talk Subject: RE: transparent png for ie hack Simply put... HAH! Do let me know if you find one! I am so tired of hacking up alternate styles and images to get a site looking the same in IE as it does in FF! A lot of the time, I've been able to use style filters to get what I'm looking for maybe you could try some of those? Opacity maybe? Just a thought. -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Saturday, May 14, 2005 4:54 PM To: CF-Talk Subject: ot: transparent png for ie hack anyone know of one that actually works? ~Dave the disruptor~ ~| 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:206724 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: transparent png for ie hack
That thing works great Dave! If I didnt suck so bad at regex's I'd give it a go in CF :/ Has the RegEx Ninja wrote a book yet? hint hint (Where is Ben anyway?) Okay, okay, gotta go... just hope they have more beer wherever it is that I'm dragged to... -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Saturday, May 14, 2005 6:06 PM To: CF-Talk Subject: RE: transparent png for ie hack I have a few i am gunna try, this one looks interesting, written in php, if it works maybe we could rewrite it in cfm. http://koivi.com/ie-png-transparency/ ~Dave the disruptor~ ---- From: "Ewok" <[EMAIL PROTECTED]> Sent: Saturday, May 14, 2005 5:38 PM To: CF-Talk Subject: RE: transparent png for ie hack Simply put... HAH! Do let me know if you find one! I am so tired of hacking up alternate styles and images to get a site looking the same in IE as it does in FF! A lot of the time, I've been able to use style filters to get what I'm looking for maybe you could try some of those? Opacity maybe? Just a thought. -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Saturday, May 14, 2005 4:54 PM To: CF-Talk Subject: ot: transparent png for ie hack anyone know of one that actually works? ~Dave the disruptor~ ~| 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:206721 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: transparent png for ie hack
Shouldnt be too hard to turn this... Into this... I'll have to play later. I'm being harassed to do the 'outside of the house' thing :) -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Saturday, May 14, 2005 6:06 PM To: CF-Talk Subject: RE: transparent png for ie hack I have a few i am gunna try, this one looks interesting, written in php, if it works maybe we could rewrite it in cfm. http://koivi.com/ie-png-transparency/ ~Dave the disruptor~ From: "Ewok" <[EMAIL PROTECTED]> Sent: Saturday, May 14, 2005 5:38 PM To: CF-Talk Subject: RE: transparent png for ie hack Simply put... HAH! Do let me know if you find one! I am so tired of hacking up alternate styles and images to get a site looking the same in IE as it does in FF! A lot of the time, I've been able to use style filters to get what I'm looking for maybe you could try some of those? Opacity maybe? Just a thought. -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Saturday, May 14, 2005 4:54 PM To: CF-Talk Subject: ot: transparent png for ie hack anyone know of one that actually works? ~Dave the disruptor~ ~| 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:206720 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: transparent png for ie hack
Simply put... HAH! Do let me know if you find one! I am so tired of hacking up alternate styles and images to get a site looking the same in IE as it does in FF! A lot of the time, I've been able to use style filters to get what I'm looking for maybe you could try some of those? Opacity maybe? Just a thought. -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Saturday, May 14, 2005 4:54 PM To: CF-Talk Subject: ot: transparent png for ie hack anyone know of one that actually works? ~Dave the disruptor~ ~| 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:206718 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: JS Question
Use the title attribute for the tool tip If you are wanting the actual text on the button changed.. use Onmouseover="this.value='Mouse On Danielson';" OnMouseout="this.value='Mouse Off Danielson';" -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED] Sent: Saturday, May 14, 2005 11:27 AM To: CF-Talk Subject: JS Question I would like to be able to display alternate text when a User Mouse Over's a submit button and have the text displayed similar to how Alt Text works with links. Now could I do this? Andy ~| 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:206712 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- Escaping a single quote
Been a while since I've had the 'pleasure' of writing asp but here is what I did on an old project. You need to just escape the ' with '' JobDescription = replace(Trim(request.form("JobDescription")), "'", "''") It just escapes the single quote with double single quotes. JobDescription goes into the database with no problems after that -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, May 12, 2005 4:25 PM To: CF-Talk Subject: OT- Escaping a single quote I have a text field that contains that could pass single quote. Well it is bombing the insert logic into the database. This is in asp.net which I am new too though I primarily use CF exclusively. I have been looking around searching for this and I am not searching correctly cause I am not finding anything. Can some one point me in the right direction. ~| 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:206577 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 - JS] onsubmit state
Ahh I misunderstood. I was thinking after it was submitted and in the form scope of CF. (although it was very plain that it's not what you said... dont ask) write a function to use in the onclick of each button maybe? function whatwasclicked(btn) { alert(btn); //some if statements for different buttons here? if (btn=='Button1') { //Do something for button1 } else if (btn=='Button2') { //Do something for button2 } } Again... dont know what you're doing with it but that will put the VALUE of the button in the var 'btn' inside the function to do whatever you want with. -Original Message- From: Dave Merrill [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 11, 2005 5:32 PM To: CF-Talk Subject: RE: [OT - JS] onsubmit state The point is that regardless of what btn was clicked, its value hasn't "taken effect" yet during onclick or onsubmit. How does giving them different names help? Dave Merrill > Without knowing what exactly you're using it for, I'd say give the submit > buttons different names rather than values > > -Original Message- > From: Dave Merrill > > Say you've got a form with multiple submit btns, each given the name > "form_action", but with different values. When the form is submitted, the > clicked submit btn's value shows up as form.form_action, as expected. > > However, from within an onclick handler for any of those btns, or an > onsubmit handler for the form, form.form_action.value is undefined. This > means that validation or other code that needs to know which > submit btn was > clicked can't tell. > > What I've done in the past is to include a hidden form field > whose value is > what we pay attention to, and set its value in the onclick > handler for each > submit btn. > > Anyone have any other strategies? > > Dave Merrill ~| 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:206493 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: Using arrow buttons to sort data
Quick and dirty... Give the db table a numeric 'sortid' to sort the query by then use this Update tbl_records Set sortid = sortid + 1 Where recorded = #val(url.recordid)# Update tbl_records Set sortid = sortid - 1 Where recorded = #val(url.recordid)# Select * from tbl order by sortid #recordname# Up Down -Original Message- From: Don R Seibert [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 11, 2005 7:31 PM To: CF-Talk Subject: Using arrow buttons to sort data I'm sure it has been done a million times. I would like to sort data presented in a table (alphanumeric) by pushing small arrow buttons ascending or descending order. Can some point to a place or provide a snippet of code to accomplish this? Thank you, Don ~| 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:206492 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 - JS] onsubmit state
Without knowing what exactly you're using it for, I'd say give the submit buttons different names rather than values -Original Message- From: Dave Merrill [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 11, 2005 4:58 PM To: CF-Talk Subject: [OT - JS] onsubmit state Say you've got a form with multiple submit btns, each given the name "form_action", but with different values. When the form is submitted, the clicked submit btn's value shows up as form.form_action, as expected. However, from within an onclick handler for any of those btns, or an onsubmit handler for the form, form.form_action.value is undefined. This means that validation or other code that needs to know which submit btn was clicked can't tell. What I've done in the past is to include a hidden form field whose value is what we pay attention to, and set its value in the onclick handler for each submit btn. Anyone have any other strategies? Dave Merrill PECULIAR ASIDE: Interestingly, to set the value of that hidden field, you use: form.form_action.value = "whatever", .even though there's a hidden field plus multiple submit btns, all with that name. Typically you'd need to access that hidden field as: form.form_action.value[0] .but that generates an error. It's like the named submit btns don't exist on this level. Odd. ~| 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:206475 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: I truly hate Ben Forta
L-O-L! -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 11, 2005 2:01 PM To: CF-Talk Subject: Re: I truly hate Ben Forta i used to cfwhack mine, but now its wireless so i just do it off the hook :) tw ~| 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:206441 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: XMLish question
You're right. It was kind of lazy. But I've been working with flash a lot lately and found it easier to use attributes.ID at first than the traditional firstchildnode[0].childnodes[0].childnodes[0] etc... Once I figured all that out I was able to do away with most of my 'attribute' entries though -Original Message- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 11, 2005 1:58 PM To: CF-Talk Subject: RE: XMLish question There are those who believe you should not use attributes in XML. That just about everything can be described using element tags. I am, sort of, one of those people. I would prefer to work with elements rather than attributes, even if it meant a few more levels of nesting. That's just the way I am. I like Ewok's structure, but I would change the attributes to elements such as: Link 1 http://www.com/ Link 2 http://www.com/ 1 2 -----Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 11, 2005 10:48 AM To: CF-Talk Subject: RE: XMLish question Of course its going to vary depending on the page and who's writing it. And even then, the original idea is most likely going to be modified even more as you get further into the project. Rather its for easier use or expansion. You'll just have to sit down and itemize your site into sections. Then itemize those sections into pieces. Here's a basic starter that I'm SURE outlook is going to make a huge mess of. Just copy and past it into DW or something else that will put the formatting back. ~| 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:206440 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: XMLish question
Personally, if it couldnt be broken up into specific sections like simply Title, Date, Author, Summary, Body, Image(s), etc.. or if you just didnt want to do it that way... I'd use one 'Body' node for that section like... Then all you would need to do is dump that nodes value out for the entire news block. My News Title May 11, 2005 E. Wok Some big long news article with tables, image tags etc... would go here. There are pros and cons for both and im sure one's will outweigh the other in different scenarios but with the latter you have more control over the display of the item than you would if you specifically set 'placeholders' for each individual node. -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 11, 2005 12:02 PM To: CF-Talk Subject: RE: XMLish question Ewok Thanks, that's pretty similar to what I was starting with, but different enough to give me some nice ideas. So for the content nodes, would you just use established HTML markup for paragraphs, lists, quotes, things like that? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.8 - Release Date: 5/10/2005 ~| 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:206410 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: XMLish question
Of course its going to vary depending on the page and who's writing it. And even then, the original idea is most likely going to be modified even more as you get further into the project. Rather its for easier use or expansion. You'll just have to sit down and itemize your site into sections. Then itemize those sections into pieces. Here's a basic starter that I'm SURE outlook is going to make a huge mess of. Just copy and past it into DW or something else that will put the formatting back. -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 11, 2005 11:11 AM To: CF-Talk Subject: XMLish question I am experimenting with a concept of an idea. So if one where to look at a fairly standard web page from a data descriptive point of view how would on actually describe the elements along the lines of XML. For example how might one describe the standard page that had a header, main navigation, secondary navigation in a left column, main content in a center column and secondary content in a third column and some kind of footer? Practically I'm looking for details of the content, such as paragraphs, lists, images and other elements that might comprise these sections. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~| 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:206396 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: cfhttp/xml: The root element is missing
I was recently having the same problem. It turned out to be a network issue. Just to make sure, go to the server (if you can) and try to view the same page. -Original Message- From: Shannon Carr [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 10, 2005 11:17 PM To: CF-Talk Subject: cfhttp/xml: The root element is missing The following code structure works with CFMX 6 and IIS but is returning the error "The root element is missing" on a server with CF5 and Apache 2. Any help would be appreciated as I've spent many hours trying to figure out why it is breaking on the other server. Thanks 490002 http://blah.com"; method="POST"> ~| 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:206387 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: formatting with commas
Not quite sure I know what you mean but if the checkboxes are all named the same with different values, then the form scope already holds a comma delimited list of selected items Eg... If that were submitted then form.chk would be '1,2,3' -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 11, 2005 9:55 AM To: CF-Talk Subject: formatting with commas On an input page the user has a group of related check boxes that they can mark. (ie: type of eqp needs: dvd/projector/smartboard/etc). The user can check as many as needed. On the report this info will be dumped into one column titled EqpNeeds. I set it so that if there's a 1 in the field it'll write out the type of eqp. (dvd smartboard) What I now want to do is add commas. However because there are 6 choices and 0 to 6 may be marked I can't think how to add a comma without it possibly looking funny (ie: the last item-or the only item- lists with a comma behind it.) tia. j ~| 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:206386 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: I truly hate Ben Forta
Wireless on the bowl? Are you that dedicated? Don't worry Ben, I'll still feed you. :p -Original Message- From: Jeff Garza [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 11, 2005 10:04 AM To: CF-Talk Subject: RE: I truly hate Ben Forta Man... doesn't anyone have wireless here??? ;-) I'm never "offline"... Jeff -Original Message- From: Rey Bango [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 11, 2005 6:58 AM To: CF-Talk Subject: Re: I truly hate Ben Forta Subtle way of saying "in the bathroom"? ;o) Rey... - Original Message - From: "Clint Tredway" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Wednesday, May 11, 2005 9:35 AM Subject: Re: I truly hate Ben Forta > the main reason I buy books is for when I am not online and need a > reference... > > On 5/11/05, Ray Champagne <[EMAIL PROTECTED]> wrote: >> Yea, those books just don't stand up to the pressure. All three of my >> copies (4.0, 5.0, MX) are in quite horrible condition. :) >> >> Micha Schopman wrote: >> > I was astonished; he did not deliver a Ben Forta look-alike fake beard >> > along with the book. Without kidding, his books are THE standard for >> > learning ColdFusion. The only negative thing I have, after I opened the >> > book two pages directly fell out of it. No problem though, fixed it >> > with >> > some construction kit I just used for fixing a vase (thank you cats). >> > >> > Micha Schopman >> > Project Manager >> > >> > Modern Media, Databankweg 12 M, 3821 AL Amersfoort >> > Tel 033-4535377, Fax 033-4535388 >> > KvK Amersfoort 39081679, Rabo 39.48.05.380 >> > >> > >> > >> > - >> > Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren >> > de interactie met uw doelgroep. >> > Wilt u meer omzet, lagere kosten of een beter service niveau? Voor meer >> > informatie zie www.modernmedia.nl >> > >> > >> > - >> > -Original Message- >> > From: Calvin Ward [mailto:[EMAIL PROTECTED] >> > Sent: woensdag 11 mei 2005 14:19 >> > To: CF-Talk >> > Subject: RE: I truly hate Ben Forta >> > >> > Not always, and also there's often some neat gems of capabilities >> > hidden >> > there. >> > >> > For example the one for CFMX 6 had a nifty regular expression tester >> > for >> > CFMX in it... >> > >> > -Original Message- >> > From: Robertson-Ravo, Neil (RX) >> > [mailto:[EMAIL PROTECTED] >> > Sent: Wednesday, May 11, 2005 9:04 AM >> > To: CF-Talk >> > Subject: RE: I truly hate Ben Forta >> > >> > Q. Why on earth do you need these books now? The CF Docs are more than >> > enoughif not better. >> > >> > >> > >> > -Original Message- >> > From: Rey Bango [mailto:[EMAIL PROTECTED] >> > Sent: 11 May 2005 14:00 >> > To: CF-Talk >> > Subject: I truly hate Ben Forta >> > >> > Thats right! I said it!! I hate the man! I hate him because everytime a >> > new >> > version of CF comes out, I find myself TOTALLY plunking down $55 for >> > his >> > new >> > >> > revised version of CFWACK!! He is sucking my bank account dry! Dryer >> > than >> > the Sahara I tell you. >> > >> > I hate you, Ben. >> > >> > Rey... >> > >> > PS: Of course, this message is all in jest and I don't actually hate >> > Ben; >> > well, maybe a little. Great books Ben. Keep up the great work bud. >> > >> > >> > >> > >> > >> > >> > >> > >> > >> >> > > ~| 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:206368 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: HE3?
There is a rather hefty discussion on just that on the cfeclipse mailing list. "He3 dead?" http://cfeclipse.tigris.org [EMAIL PROTECTED] -Original Message- From: Adam Haskell [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 10, 2005 9:07 AM To: CF-Talk Subject: HE3? A question was posted in Cf-OT a while back with no response...not sure how much traffic OT gets so I figured I'd repost here...what happened with He3? seems to of kinda disappeared... Adam 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:206269 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: More than one datasource in
Heh, I was just wondering the same thing. I believe to connect straight to an mdb file (dns;ess connection) you needed the connectionstring attribute of cfquery right? Believe that one is gone. select * fram table Or there abouts... -Original Message- From: Michael Traher [mailto:[EMAIL PROTECTED] Sent: Monday, May 09, 2005 3:45 PM To: CF-Talk Subject: Re: More than one datasource in It would be great to hear if any of this helps 'simmyana' :-) On 5/9/05, simmyana a <[EMAIL PROTECTED]> wrote: > Hi, > > How to use more than one datasource in tag? > > Thanks > > ~| 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:206145 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: More than one datasource in
> NO!! There are awful table aliases which mean nothing. It is just > plain ugly to abbreaviate them like this... at the very least you should > qualify the name in some waytable a, b,c and d is just lazy. Woah, lean back, take a deep breathe then pop a pill. It's too early in the week to criticize coding methods from an EXAMPLE It's easier to understand in an example that says a.something b.something than it is in one that says... somedatasourceoverhere.something andthisone.something If it was your datasource and tables, then the latter may make a little more sense to you. agreed? -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.6 - Release Date: 5/6/2005 ~| 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:206077 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: More than one datasource in
Nice. So it's only possible with MySQL and MS SQL Server data sources? I dont know what DB Simmyana is using but the one I mentioned was SQL server. -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Monday, May 09, 2005 9:59 AM To: CF-Talk Subject: RE: More than one datasource in For example - if you have 3 different installations of an ap with three different user databases and you wanted to build a single interface for all three (like a master administrators db) - you could create a user on the MS SQL server with permissions to all three. Then, using a DSN with that USER You could then run a query like this: SELECT A.username, A.password, 'DB_A' as Datasource FROMDbnameA.dbo.Users UNION SELECT B.username, B.password, 'DB_B' as Datasource FROMDbnameB.dbo.Users UNION SELECT C.username, C.password, 'DBC' as Datasource FROMDbnameC.dbo.Users order by Datasource This would give you all the users from all three databases It is also possible to do similar things in Access by specifying the file path to the second datasource I had a sample of that once but its fallen by the wayside. Obviously there is a security issue here - 1 username with permissions on 3 databases... so make sure you have thought it all through. --- -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, May 09, 2005 8:25 AM To: CF-Talk Subject: RE: More than one datasource in Yep basically the format is database.owner.table.column So you could do SELLECT * FROM EmployeeDirectory.dbo.Employee -Original Message- From: Adam Haskell [mailto:[EMAIL PROTECTED] Sent: 09 May 2005 14:27 To: CF-Talk Subject: Re: More than one datasource in If you use MS SQL you can use Linked Servers to query across different servers. it would be something like: Select * >From myLink.database.owner.table Adam 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:206065 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: More than one datasource in
Yes, one 'true datasource' in a cfquery but you can use 2 different record sets in a QoQ and combine them just as if they were 2 tables in one database. What's Cross Database Query? 'Sounds' promising. I've had to use the method in my previous example quite a bit in my latest nightmare... oh I mean 'project'. I thought it was my only (worthwhile) option -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, May 09, 2005 8:05 AM To: CF-Talk Subject: RE: More than one datasource in Erm, well you can only use one DSN in a single CFQUERY but you should be able to use a Cross Database Query allowing you to search across two databases. -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: 09 May 2005 13:06 To: CF-Talk Subject: RE: More than one datasource in You can't with one shot. You'll have to query each then combine them with a QoQ (assuming you are running CF5.0 or up) Select * from tbl_in_db1 Select * from tbl_in_db2 Select a.*, b.* >From a, b Where a.something = b.something -Original Message- From: simmyana a [mailto:[EMAIL PROTECTED] Sent: Monday, May 09, 2005 2:05 AM To: CF-Talk Subject: More than one datasource in Hi, How to use more than one datasource in tag? 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:206047 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: More than one datasource in
You can't with one shot. You'll have to query each then combine them with a QoQ (assuming you are running CF5.0 or up) Select * from tbl_in_db1 Select * from tbl_in_db2 Select a.*, b.* >From a, b Where a.something = b.something -Original Message- From: simmyana a [mailto:[EMAIL PROTECTED] Sent: Monday, May 09, 2005 2:05 AM To: CF-Talk Subject: More than one datasource in Hi, How to use more than one datasource in tag? Thanks ~| 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:206042 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: Good flash list
Jeez... how simple was that to fix... Added a new MC symbol, drug it out to the position that I wanted the top left corner of movie 2 to be... then just added... instanceName.loadMovie("movie2.swf"); to the actions and voila... I dont know what's worse... that it was something so simple and I spent so much time on it... Or the fact that it was one of the very first things I tried and didnt get to work :/ Well thanks for the help. I appreciate it very much. And be careful... I hear that there is a case of the cooties floating around here in one of these threads. ;) -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Saturday, May 07, 2005 7:45 PM To: CF-Talk Subject: RE: OT: Good flash list there could be a few things it could be but unfortunately without seeing it, its too hard to tell :( ~Dave the disruptor~ ~| 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:205982 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: Good flash list
I tried that once already, but like I said... I'm not the best with flash. I'll try that again while I still have a little hair left. -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Saturday, May 07, 2005 7:34 PM To: CF-Talk Subject: RE: OT: Good flash list try it a different way, choose the scene you want then go into the "behavior" panel, click on the + go down to movieclip and choose "load from exterenal movie clip" If you actually make a blank movieclip where u want it and too size then do the above you get more options as well. ~Dave the disruptor~ ---- From: "Ewok" <[EMAIL PROTECTED]> Sent: Saturday, May 07, 2005 7:22 PM To: CF-Talk Subject: RE: OT: Good flash list I published it and uploaded it to a development server. So it's on the web. As I said, I used the full URL to movie 2 and it popped up in the stage so I know it knows where it's at. I do get a sandbox violation warning when I set the content path to the url since it is trying to access a web file form a local file (or vise versa) maybe that's it? But if I just use a relative path (just the name of the swf since they are in the same directories on the server) it doesn't show up in the stage OR in the final published movie... sigh The loader component is definitely on TOP of all other frames and levels. The loader is also a big, white box with a thin black boarder around it. Believe me, I wish I could send it to you! But 'They' would probably not like that very much and 'They' are on this list :) Hi They -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Saturday, May 07, 2005 7:08 PM To: CF-Talk Subject: RE: OT: Good flash list " mr disruptor" hehe thats even better! First thing to check would be what layer the loader is on, is it on top of the other items? When you published it was it on web or your local machine? firewall blockage maybe? There shouldnt be any border around the loader at all. If you wanna send it to me I will take a look, i am no expert either though but might be able to see the problem. ~Dave the disruptor~ From: "Ewok" Sent: Saturday, May 07, 2005 7:01 PM To: CF-Talk Subject: RE: OT: Good flash list Hi mr disruptor :p Thanks for the response. I am by no means a flash expert so forgive my ignorance on the subject. More weirdness... I love it! I managed to find the 'Loader' component and got it into the stage on movie 1. I set its content path to the full url of movie 2 and like magic it showed right up in the stage! I published it and... Nothing shows up in the loader window... sigh Also, if I do ever get it to show up, is it possible to hide the thin border around the loader? -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Saturday, May 07, 2005 4:20 PM To: CF-Talk Subject: re: OT: Good flash list I would use the loader component to position it, I would also be sure either export the cb on the first frame or change the settings to export componts on the second frame, yeah that sounds confusing but there are issues with v2 components and how they are brought into movies, especially with preloading. ~Dave the disruptor~ From: "Ewok" Sent: Saturday, May 07, 2005 4:06 PM To: CF-Talk Subject: OT: Good flash list CF-Flash seems pretty dead. Does anyone know of a good flash list with even half the activity as cf-talk? If you are a flash guru, please, by all means, go read my post on CF-Flash :-) -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.6 - Release Date: 5/6/2005 ~| 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:205980 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: Good flash list
I published it and uploaded it to a development server. So it's on the web. As I said, I used the full URL to movie 2 and it popped up in the stage so I know it knows where it's at. I do get a sandbox violation warning when I set the content path to the url since it is trying to access a web file form a local file (or vise versa) maybe that's it? But if I just use a relative path (just the name of the swf since they are in the same directories on the server) it doesnt show up in the stage OR in the final published movie... sigh The loader component is definitely on TOP of all other frames and levels. The loader is also a big, white box with a thin black boarder around it. Believe me, I wish I could send it to you! But 'They' would probably not like that very much and 'They' are on this list :) Hi They -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Saturday, May 07, 2005 7:08 PM To: CF-Talk Subject: RE: OT: Good flash list " mr disruptor" hehe thats even better! First thing to check would be what layer the loader is on, is it on top of the other items? When you published it was it on web or your local machine? firewall blockage maybe? There shouldnt be any border around the loader at all. If you wanna send it to me I will take a look, i am no expert either though but might be able to see the problem. ~Dave the disruptor~ ---- From: "Ewok" <[EMAIL PROTECTED]> Sent: Saturday, May 07, 2005 7:01 PM To: CF-Talk Subject: RE: OT: Good flash list Hi mr disruptor :p Thanks for the response. I am by no means a flash expert so forgive my ignorance on the subject. More weirdness... I love it! I managed to find the 'Loader' component and got it into the stage on movie 1. I set its content path to the full url of movie 2 and like magic it showed right up in the stage! I published it and... Nothing shows up in the loader window... sigh Also, if I do ever get it to show up, is it possible to hide the thin border around the loader? -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Saturday, May 07, 2005 4:20 PM To: CF-Talk Subject: re: OT: Good flash list I would use the loader component to position it, I would also be sure either export the cb on the first frame or change the settings to export componts on the second frame, yeah that sounds confusing but there are issues with v2 components and how they are brought into movies, especially with preloading. ~Dave the disruptor~ From: "Ewok" Sent: Saturday, May 07, 2005 4:06 PM To: CF-Talk Subject: OT: Good flash list CF-Flash seems pretty dead. Does anyone know of a good flash list with even half the activity as cf-talk? If you are a flash guru, please, by all means, go read my post on CF-Flash :-) -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.6 - Release Date: 5/6/2005 ~| 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:205978 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: Good flash list
Hi mr disruptor :p Thanks for the response. I am by no means a flash expert so forgive my ignorance on the subject. More weirdness... I love it! I managed to find the 'Loader' component and got it into the stage on movie 1. I set its content path to the full url of movie 2 and like magic it showed right up in the stage! I published it and... Nothing shows up in the loader window... sigh Also, if I do ever get it to show up, is it possible to hide the thin border around the loader? -Original Message- From: dave [mailto:[EMAIL PROTECTED] Sent: Saturday, May 07, 2005 4:20 PM To: CF-Talk Subject: re: OT: Good flash list I would use the loader component to position it, I would also be sure either export the cb on the first frame or change the settings to export componts on the second frame, yeah that sounds confusing but there are issues with v2 components and how they are brought into movies, especially with preloading. ~Dave the disruptor~ ---- From: "Ewok" <[EMAIL PROTECTED]> Sent: Saturday, May 07, 2005 4:06 PM To: CF-Talk Subject: OT: Good flash list CF-Flash seems pretty dead. Does anyone know of a good flash list with even half the activity as cf-talk? If you are a flash guru, please, by all means, go read my post on CF-Flash :-) -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.6 - Release Date: 5/6/2005 ~| 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:205976 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: Good flash list
CF-Flash seems pretty dead. Does anyone know of a good flash list with even half the activity as cf-talk? If you are a flash guru, please, by all means, go read my post on CF-Flash :-) -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.6 - Release Date: 5/6/2005 ~| 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:205974 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: How to get the full url requested in cf?
Gotcha... thats basically what I've used for a while ... In a page called app_globals.cfm that is ALWAYS included in every page via application.cfm App_globals.cfm then has a few vars set in it to be used through out the site request.webroot = 'http://#cgi.server_name#'; request.imageroot = '#request.webroot#/images'; etc.. so anywhere and everywhere in the site, links, images and cookies are all referenced or created with #request.webroot# So if you come into the site as www.shop.com you will always be at www.shope.com Same goes for http://shop.com. If thats what you came in on, you'll stay there If you want everyone to be on a non www site at all times: request.webroot = http://#replace(cgi.server_name, 'www.', '')#'; request.imageroot = '#request.webroot#/images'; all links and cookies that are created using request.webroot now will not have www. In them If you DO want www... just change request.webroot to.. request.webroot = http://www.#replace(cgi.server_name, 'www.', '')#'; so it will always have 'www.' That takes care of linking everything up in the site and pulling images from the same place (www or not www) You then need to make sure no matter where the user comes in, that they either have or dont have www (whichever you want) Try this in your application.cfm url has www in it... Stay or redirect? url does NOT have www in it... Stay or redirect? To redirect them, just use... http://myshop.com/? But that wont hurt anything But if they come into your site at the url http://shop.com/somedir/index.cfm?var1=1 And you want them at www.shop... The cflocate would take them to exactly where they are, plus the www http://www.shop.com/somedir/index.cfm?var1=1 -Original Message- From: stylo stylo [mailto:[EMAIL PROTECTED] Sent: Friday, May 06, 2005 10:22 PM To: CF-Talk Subject: Re: How to get the full url requested in cf? >I don?t know why you need to know if www is there or not but if you had access to IIS, you could have http://www.shop.com point to a different place than http://shop.com all together There is a stored shop url in the code. Problem is that cookies are being lost between www.shop.com and shop.com when code refers to the shop url variable and cflocates in a few places, or a linkbase variable is set based upon it to use on menus used on various directory levels. I asked my host and they said I would need something like IISrewrite to redirect, or metatags. So I thought to rewrite the request.shopurl variable that is being set, based on their being "www" or not. Then the cflocate and linkbase will be in line with how people come to the site, with "www" or not. (Or I can simply relocate all "www" requests to non "www". Maybe better, but wondering about links to the site and search engines.) If you have a better idea, I'm all ears. ~| 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:205964 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: CFMX: Dissed by Breeze and FlashLite?
I think what you are saying is wrong and is a blatant attempt to demean or upset me! :p Hey! Let's play a game... Next person who posts to this thread has cooties!! -Original Message- From: Micha Schopman [mailto:[EMAIL PROTECTED] Sent: Friday, May 06, 2005 10:52 AM To: CF-Talk Subject: RE: CFMX: Dissed by Breeze and FlashLite? Nofi, but could we end this useless discussion? Some people keep whining / overreacting about the smallest things on and on. People sometimes say things that are wrong, it happens, move on, smile and continue the discussion. And for those who think "mwuahaha, obvious reply coming ... " yes me too ;) Micha Schopman Project Manager Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 - Modern Media, Making You Interact Smarter. Onze oplossingen verbeteren de interactie met uw doelgroep. Wilt u meer omzet, lagere kosten of een beter service niveau? Voor meer informatie zie www.modernmedia.nl - -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: vrijdag 6 mei 2005 15:32 To: CF-Talk Subject: Re: CFMX: Dissed by Breeze and FlashLite? It's not big deal. I didn't mind his comments at all. I was definitely asking for it with my smart-ass 'this in not your blog' post. So yeah, no harm, no foul. -Adam On 5/5/05, Sean Corfield <[EMAIL PROTECTED]> wrote: > On 5/5/05, Alex Sherwood <[EMAIL PROTECTED]> wrote: > > it was not a baseless ad- hoymnum attack. > > Sure it was. It was crude, insulting and completely inappropriate to > this list (or indeed any list that is supposed to be a professional > technical list). > > Your continued "rants" and unpleasantness merely show most of us that > you belong on a DNH list... > -- > Sean A Corfield -- http://corfield.org/ > Team Fusebox -- http://fusebox.org/ > Got Gmail? -- I have 50, yes 50, invites to give away! > > "If you're not annoying somebody, you're not really alive." > -- Margaret Atwood > > ~| 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:205858 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: How to get the full url requested in cf?
For 'http://www.shop.com/index.cfm?var1=1&var2=2' Cgi.server_name would give you the 'www.shop.com' Cgi.script_name would give you the 'index.cfm' Cgi.query_string would give you 'var1=1&var2=2' Find() would not ensure that www was the first thing in the name so... Then www was in the url. Or Then www was in the url. I dont know why you need to know if www is there or not but if you had access to IIS, you could have http://www.shop.com point to a different place than http://shop.com all together -Original Message- From: stylo stylo [mailto:[EMAIL PROTECTED] Sent: Friday, May 06, 2005 6:59 AM To: CF-Talk Subject: How to get the full url requested in cf? I don't want the file system path, I want the full url of the page requested, e.g., http://www.shop.com/index.cfm . (Actually I just need the first part, not even the page, as I only want to know if "www" was used or not.) How can I get that in a CF variable when the page is requested? ~| 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:205845 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: CFHTTP problem
Simply put... You'll need to put something in the empty fields one way or another. If not before it's pulled in as a query structure, then you'll have to bring it in as a string and fix the empty values. Replace 'tab tab' with 'tab null tab' Replace 'chr(13)chr(10) tab' with 'chr(13)chr(10) null tab' Replace 'tab chr(13)chr(10)' with 'tab nullchr(13)chr(10)' (I think that would cover all the possible empties.) (no spaces of course) Then put it in a query structure And you could treat it as a nested tab delimited list inside a chr(13)chr(10) delimited list and replace empty list items with whatever you wanted Then put it in a query structure Messy? Yes. Huge lists usually are. The best thing to do would be to fix it before it is read in. -Original Message- From: David Critchley [mailto:[EMAIL PROTECTED] Sent: Thursday, May 05, 2005 4:42 PM To: CF-Talk Subject: CFHTTP problem No suggestions on this one? > I am trying to extract data from a textfile database, using . > The problem I am running into is that there are null fields in the > textfile database and CFHTTP is then counting two fields as one (tab > seperated). For example, in my textfile there will be something like > this: > > field1 field2 field3 > data data data > data data > data data data > > I am getting an Incorrect number of columns error, because coldfusion > is missing the null field and counting only 2 fields for the second > row of data. Has anyone else come accross this, or have any > suggestions? I have considered using the replace function on the > variable and replacing all double tabs with a tabtab. But this > to me seems like a poor work around. > > I am using firstrowasheaders="yes" delimiter="tab"> > > David Critchley ~| 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:205817 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: Interface for Net Send
IP: MSG: -Original Message- From: Claremont, Timothy [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 04, 2005 11:16 AM To: CF-Talk Subject: Interface for Net Send I am trying to build a simple interface so that I can use the dos Net Send command to immediately send a message to an end user. Has anyone on the list done this already so I am not reinventing the whee? CF 6.1, W2K3 Thanks Tim ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please delete it from your system. This footnote also confirms that this email message has been swept for the presence of computer viruses. Thank You, Viahealth ** ~| 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:205621 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-Unix grep
Heh I thought I was the only one who ever found humor in that. -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 04, 2005 10:54 AM To: CF-Talk Subject: Re: OT-Unix grep [EMAIL PROTECTED] wrote: > Okay kind of an odd thing here. I am trying to use grep to search through files for a string. I and hen just wnat the file name that there was a match for, then I am writing the reuslts to CF web page. Now I can eaisly grep the string but I am simpky want the file name not the actual line for the string found. so Right now I am doing the following: > > grep foo *.* You can use grep to grep the grep manpage for the right syntax: man grep | grep ' -' :) Jochem ~| 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:205620 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 cfchart into an existing swf?
Duh... name="chartname" in the cfchart tag Then output="#chartname#" in a cffile tag Sorry. -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: Monday, May 02, 2005 4:38 PM To: CF-Talk Subject: load cfchart into an existing swf? Has anyone done this? Since the generated cfchart is stored in memory (I think).. is it possible to save it as a real file so it can be loaded into an existing swf file with loadMovie() ? Id really like to get the swf from cfchart but id settle for the jpg or png. Either could be loaded into the existing swf if I could get an actual copy saved on the server somewhere Im probably just dreaming, but it would be nice -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.0 - Release Date: 4/29/2005 ~| 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:205350 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: load cfchart into an existing swf?
Thanks, apparently my last post never came through. I finally found that the name attributes value holds the content of the actual swf/jpg and was able to dump that into a cffile output Thanks again for responding. -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Monday, May 02, 2005 10:23 PM To: CF-Talk Subject: RE: load cfchart into an existing swf? For cf7: http://livedocs.macromedia.com/coldfusion/7/htmldocs/1436.htm For cf6.1 http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/graphi11.htm -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: Tuesday, 3 May 2005 4:38 To: CF-Talk Subject: load cfchart into an existing swf? Has anyone done this? Since the generated cfchart is stored in memory (I think).. is it possible to save it as a 'real' file so it can be loaded into an existing swf file with loadMovie() ? I'd really like to get the swf from cfchart but id settle for the jpg or png. Either could be loaded into the existing swf if I could get an actual copy saved on the server somewhere I'm probably just dreaming, but it would be nice ~| 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:205348 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
load cfchart into an existing swf?
Has anyone done this? Since the generated cfchart is stored in memory (I think).. is it possible to save it as a real file so it can be loaded into an existing swf file with loadMovie() ? Id really like to get the swf from cfchart but id settle for the jpg or png. Either could be loaded into the existing swf if I could get an actual copy saved on the server somewhere Im probably just dreaming, but it would be nice -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.0 - Release Date: 4/29/2005 ~| 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:205317 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: HOw to Access error info
Sorry I didnt get back to you but it looks like you got plenty of help. A site wide error template will pretty much catch every error that falls after the cferror tag in application.cfm -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 26, 2005 10:44 AM To: CF-Talk Subject: Re: HOw to Access error info > When an error occurs on any page that uses that application.cfm, the user > would be redirected to cferror.cfm. Thanks Ewokthat's exactly what I was after (well I haven't tested...but it sounds good) ;-) I'm wondering about your statement above (and wish I paid more attention to the error thread a week or so ago)will an error IN Application.cfm be caught and handled as well? Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| 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:204595 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: HOw to Access error info
Save yourself a lot of time and headache by not wrapping everything in cfcatch and instead use the tag to redirect all errors to a custom error page. Just put it in your application.cfm. Something like... When an error occurs on any page that uses that application.cfm, the user would be redirected to cferror.cfm. Display an apology to them and cfmail yourself the error structure. Particularly the variable 'error.diagnostics' which holds the error message you are looking for -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Monday, April 25, 2005 6:46 PM To: CF-Talk Subject: HOw to Access error info Hey All, Currently when an error occurs, an e-mail with a dump of CFCATCH is e-mailed to developers (using a cftry/catch of course). That info is close to useless (no line numbers for starters...and lost of Java that is meaningless).it's even worse when your app is served up through a reverse proxy. What I'd love to get my hands on is the stuff that shows in the classic view of CF debugging output...especially the error text and line number (you know...just under the files run with processing times..."Error Executing Query xyz"...or MyVar undefined at line:20" kinda stuff). So how can I reference that? TIA Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~| 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:204386 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 woes
Glad you got it going. Just out of curiosity, what OS is your server on? -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: Monday, April 25, 2005 9:21 AM To: CF-Talk Subject: Re: Form woes Thanks for your help on that one guys. I didn't get it to work with both chr13 and chr10 but it worked fine with chr13 (unlucky for some!). Thanks, Saturday On 25/4/05 2:07 pm, "Ewok" <[EMAIL PROTECTED]> wrote: > Okay, so they are most likely still there :) > > #replace(string, "#chr(13)##chr(10)#", "", "ALL")# > > > -Original Message- > From: Dave Watts [mailto:[EMAIL PROTECTED] > Sent: Monday, April 25, 2005 9:11 AM > To: CF-Talk > Subject: RE: Form woes > >> I¹ve got a cfform (flash) whereby a user enters data into a >> text area. I have noticed that when I check in the database >> (SQL) there are no carriage returns or anything. >> >> Do I need to do this before I insert it into the DB? > > When a user types text into a textarea, it's not HTML, just text. Within > ASCII text, carriage returns and line feeds are represented by the ASCII > characters 13 and 10, respectively, and those don't show up as visible > characters when you look at the text. If you later want to display that text > within an HTML page, it will be up to you to reformat it appropriately. This > doesn't have anything to do with CFFORM or Flash, I don't think. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! > > > > > ~| 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:204252 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: Form woes
Okay, so they are most likely still there :) #replace(string, "#chr(13)##chr(10)#", "", "ALL")# -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, April 25, 2005 9:11 AM To: CF-Talk Subject: RE: Form woes > I¹ve got a cfform (flash) whereby a user enters data into a > text area. I have noticed that when I check in the database > (SQL) there are no carriage returns or anything. > > Do I need to do this before I insert it into the DB? When a user types text into a textarea, it's not HTML, just text. Within ASCII text, carriage returns and line feeds are represented by the ASCII characters 13 and 10, respectively, and those don't show up as visible characters when you look at the text. If you later want to display that text within an HTML page, it will be up to you to reformat it appropriately. This doesn't have anything to do with CFFORM or Flash, I don't think. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:204248 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 woes
Maybe it's an issue with flash forms? I dont know, I haven't had the chance to play around with them much yet but... does it keep formatting when you pull it from the database and display it wrapped in tags? -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: Monday, April 25, 2005 8:30 AM To: CF-Talk Subject: Form woes Hi guys, I¹ve got a cfform (flash) whereby a user enters data into a text area. I have noticed that when I check in the database (SQL) there are no carriage returns or anything. Do I need to do this before I insert it into the DB? Thanks, Saturday ~| 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:204246 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: Structures (probably a stupid question)
If its a query structure your after you can just use... a query structure Eg. You can add rows to that all day long. keeping with the sort of 'class object' your describing you can also scope the queries and make them subs of a higher structure. Eg. -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED] Sent: Sunday, April 24, 2005 11:21 AM To: CF-Talk Subject: Structures (probably a stupid question) I'm trying to understand structures - I understand that they are like the form scope in that I can access them as myStruct.myVar, but is there a way to create an array of structures? I'm thinking it would be nice to create a structure like: myStruct.FName myStruct.LName myStruct.EMail And then add people to that sort of like a virtual table that I could later loop through and add to a real table. It appears from the reading I've done that one can, but I can't find a clear example of it. I'm looking for something will work in CF5 and up. Thanks, T --- [This E-mail scanned for viruses by Declude Anti-Virus] ~| 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:204171 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