Visual Basic Discussion Lists?
Can someone refer me to a really good discussion list like this one, on Visual Basic Programming? Thanks, Kevin ~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: date massaging
you could parse it with LEFT and RIGHT functions, or use an Insert Function and insert at the 3rd and 6th spots for your slash. ~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 27, 2002 2:22 PM To: CF-Talk Subject: date massaging Anyone care to help out a brain-fried guy? I need to know how to convert strings, like the following: 03172002, into a valid date ( 03/17/2002). Thanks in advance. Nick __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF & JS Menus
I just wanted to say that I am extremely impressed with QuillDesign's menu program. Well done! -Kev ~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Michael Tangorre [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 4:52 PM To: CF-Talk Subject: Re: CF & JS Menus Thanks Shawn. This is for a school project I am putting together..so free is what I am looking for. I'd like to get into DHTML, Javascript, and DOM more, but with graduation coming up, I just dont have time right now... so anyone reading this..any free menus would be great. I am looking for something that I can use with CF. I have a query that grabs the main categories and then loops around another query passing in the main catid to get the sub cats and thus I get the info needed to give the javascript to generate the menus.. I have on working in some versions of NS and all IE but need it to work in IE4+, NS4.08+. Thanks for any links.. advice, help.. much appreciated. Mike - Original Message - From: "Shawn Grover" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, March 21, 2002 7:48 PM Subject: RE: CF & JS Menus > Hiermenus is now charging for licensed use. And their prices are pretty > extreme. > I checked into this in January sometime - it was something like $500 if your > site had less than 20 pages, $900 if it was between 20 and 40 pages, and > $1500 if you had more than 40 pages. > > After doing some checking around, there are some very good systems out there > that are much less (free even), and meet or exceed Hiermenus' capabilities. > Unfortunately, I don't have the links with me I'll see if I can dig them > out tonight... > > Shawn Grover > > -Original Message- > From: Chuck McElwee [mailto:[EMAIL PROTECTED]] > Sent: Thursday, March 21, 2002 4:23 PM > To: CF-Talk > Subject: RE: CF & JS Menus > > > You might also want to check out > http://www.webreference.com/dhtml/hiermenus/ > > > Chuck McElwee > etech solutions inc > www.etechsolutions.com > > > -Original Message- > From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] > Sent: Thursday, March 21, 2002 4:37 PM > To: CF-Talk > Subject: Re: CF & JS Menus > > > We have a very solid script that is very compatible with many browsers. > > http://www.quilldesign.com/popupmenupro/index.cfm > > Drop in and check it out... > > Paul Giesenhagen > QuillDesign > http://www.quilldesign.com > SiteDirector v2.0 - Commerce Builder > > > > Hello Everyone. > > > > I have been playing with the IE DOM and NS DOM for the past two weeks, and > > decided to ask if anyone knows of any good JS menu scripts that looks nice > > and work in IE4+, NS4.08+? > > I would appreciate any links or advice. > > > > Mike > > > > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Expriing a session
Use a struct delete. where session is the name of the entire session group. or you can do it with an induvidual variable like this HTH Kevin ~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Monday, December 03, 2001 10:03 AM To: CF-Talk Subject: Expriing a session Hi everyone. I am having no luck expiring a users session. Here is what I am attemnpting: User logs in.. All is fine, a session variable is set to "loggedin". When the user clicks "log out" I call a template that sets the value of the session var to "loggedout" and then redirect them to a new page. The problem is that if they hit the browsers back button they can still get to the page they were viewing when they logged on. I have tried using cflocation to send them to the enw page and I even check for the value of the sesison var before displaying the page that is protected via the login... Any ideas? Michael T. Tangorre Resident Assistant - Brick Web Applications Developer A.U. Webteam Slave :-) AIM: CrazyFlash4 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Server Installation Question
When setting up cf 4.5, do you have to stop the IIS service?Or does it stop the IIS service? And do you have to reboot after the installation is complete? Just wondering if anyone knows this stuff off the top of their head. Thanks, Kev ~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ok, OT JS question
is there a way to decorate the text within the confirm function, like bold it or color it? thanks, kev ~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
ArrayInsertAt Question
How would i Insert like 4 values into 2-dimensional array? Anyone had success with this? Like i have an array that contains 3 records with 4 items each. I want to insert a record in spot 2 with the 4 attributes. How can i do this? I'm stumped... ~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Small JS Question
Ok, I have a form, I submit the form, the values are passed. And then I do some inserting into my DB. Now, if a user clicks back, I want the form to be reset. I've tried appending myForm.reset(); to my validation scripts, but when I submit it, no values are passed through, obviously because of the form reset method i'm invoking at the end. However when I do the form reset method, when the user clicks back, the form is at the default state, so i'm getting the results, but not the way i need them, i need them to work together, anyone have any insight on this one? Thanks, kev ~~~~~~~~~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Printing Question
Is there any way to remove the standard headers and footers from printing off an html document? ~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Alternating BG colors on a
-kev ~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 21, 2001 11:39 AM To: CF-Talk Subject: Alternating BG colors on a I have done this in the past, but cant remember how i did it. When using a tag on a table how do i get every other to have a background color? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Character Code....
Thanks everyone :o) ~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Mark W. Breneman [mailto:[EMAIL PROTECTED]] Sent: Monday, August 20, 2001 1:02 PM To: CF-Talk Subject: RE: Character Code Bookmark this page. I use it all most weekly. http://www.physics.udel.edu/wwwusers/watson/scen167/ascii.html Try chr(39) Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: Kevin Mansel [mailto:[EMAIL PROTECTED]] Sent: Monday, August 20, 2001 2:40 PM To: CF-Talk Subject: Character Code does anyone know the chr() code for the apostrophe? ~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Character Code....
does anyone know the chr() code for the apostrophe? ~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Any Sites Showing Use of CF 5 Graphics Capability?
UDF's are enough to upgrade in my opinion... ~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Jocelyn Isidro [mailto:[EMAIL PROTECTED]] Sent: Monday, August 20, 2001 10:54 AM To: CF-Talk Subject: Any Sites Showing Use of CF 5 Graphics Capability? Does anyone know of any sites that showcase the use of CF 5.0's new graphics/charting functions? I need to justify the purchase of CF 5.0. Thanks, Jocelyn Isidro Sr. Software Engineer Pharmaceutical Care Network "PCN with MedIntelligence" Phone : 916.414.4753 Fax: 916.414.4647 E-mail : [EMAIL PROTECTED] www.pharmcarenet.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFLocation and Passing Complex Data
You could use structs, maybe use a session var? You could put it in a temp table and then assign a number to it so you can retrieve it on a different page? ~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Yvette Ingram [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 4:05 PM To: CF-Talk Subject: Re: CFLocation and Passing Complex Data Keven: It doesn't have to do with the addtoken. It's the problem with passing a structure that basically ends up being in the URL and it's large. I need a way to get around that. All suggestions are welcome. TIA Yvette Ingram Brainbench Certified ColdFusion 4.5 Programmer Email: [EMAIL PROTECTED] or [EMAIL PROTECTED], or [EMAIL PROTECTED] ICQ: 21200397 Website: http://www.tkisolutions.com - Original Message ----- From: "Kevin Mansel" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, August 17, 2001 6:48 PM Subject: RE: CFLocation and Passing Complex Data > I'm not sure why you are getting that error. It could be to a few things, > that I can maybe rattle off my head... > > 1) what is the value of "#stMemberInfo#" That could be a potential > problem > 2) this could have nothing to do with it, but adding the addtoken="no" > might help the situation > > hth > > -kevin > > ~ > Kevin Mansel > Senior Web Developer > Fox Communications > [EMAIL PROTECTED] > DL : 425-649-1321 > C : 425-346-7221 > > > > -Original Message- > From: Yvette Ingram [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 17, 2001 3:44 PM > To: CF-Talk > Subject: CFLocation and Passing Complex Data > > > Hi: > > I'm trying to pass complex data (structure in particular), using cflocation, > but I'm not able to. The example is like this: > > > > The error I'm getting is saying that I can only pass simple data with > cflocation. I need to pass complex data. Is this possible to do? > > Thanks in advance. > Yvette Ingram > Brainbench Certified ColdFusion 4.5 Programmer > Email: [EMAIL PROTECTED] or > [EMAIL PROTECTED], or > [EMAIL PROTECTED] > ICQ: 21200397 > Website: http://www.tkisolutions.com > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFLocation and Passing Complex Data
I'm not sure why you are getting that error. It could be to a few things, that I can maybe rattle off my head... 1) what is the value of "#stMemberInfo#" That could be a potential problem 2) this could have nothing to do with it, but adding the addtoken="no" might help the situation hth -kevin ~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Yvette Ingram [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 3:44 PM To: CF-Talk Subject: CFLocation and Passing Complex Data Hi: I'm trying to pass complex data (structure in particular), using cflocation, but I'm not able to. The example is like this: The error I'm getting is saying that I can only pass simple data with cflocation. I need to pass complex data. Is this possible to do? Thanks in advance. Yvette Ingram Brainbench Certified ColdFusion 4.5 Programmer Email: [EMAIL PROTECTED] or [EMAIL PROTECTED], or [EMAIL PROTECTED] ICQ: 21200397 Website: http://www.tkisolutions.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Newbie - URL redirect?
There ya go :o) or you can use the cfelseif's of course... -kevin ~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Jon Dunn [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 2:36 PM To: CF-Talk Subject: Newbie - URL redirect? How do I redirect an incoming url request to a specific directory on the server? I have multiple domain names routing to the same root directory - I'd like to have each separate domain name be directed to the appropriate directory to keep the different sites separated. I've tried the following cf code provided by my hosting company: I've put this at the top of the default page in the root directory, but it doesn't work. What am I missing? TIA, jon FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=sts ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Checking for a files existence?
well, there was a script i tried to run on a webserver of ours that would compare to web folders already there, using the DirectoryExists function, there was about 15000+ folders, and well...i couldn't even find the correct time to set as the timeout, so i've had to resort by cleaning up in blocks, which of course is a better method anyways, considering load on the server just my .02 -kev ~~~~~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Friday, August 17, 2001 1:49 PM To: CF-Talk Subject: Checking for a files existence? Does checking for a files existence use up alot of system resources? Does it take a long time? Brook ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cold Fusion Developer - beginner
Would it be ??? ~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: coldfusiongirl [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 1:20 PM To: CF-Talk Subject: Re: Cold Fusion Developer - beginner some do! babe! :) CF girl - Original Message - From: "Fuon See Tu" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, August 07, 2001 2:59 PM Subject: RE: Cold Fusion Developer - beginner > Chicks don't mind that :) hehehehe > > > >From: "Christian Abad" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: CF-Talk <[EMAIL PROTECTED]> > >Subject: RE: Cold Fusion Developer - beginner > >Date: Tue, 07 Aug 2001 14:27:32 -0400 > > > >Uh, Fuon: > > > >To the best of my knowledge, female professionals don't like to be referred > >to as "chicks", which, by the way is shorthand for baby chickens. > > > >I am sure that Amanda Stern would prefer to be referred to as a female or > >even a lady! > > > >My advice to you - try again! > > > >Christian N. Abad > >ColdFusion Web Developer > >Bank of America - eCommerce Technology > > > >-Original Message- > >From: Fuon See Tu [mailto:[EMAIL PROTECTED]] > >Sent: Tuesday, August 07, 2001 2:04 PM > >To: CF-Talk > >Subject: Re: Cold Fusion Developer - beginner > > > > > >hey Amanda, we have a coldfusion project coing up soon later near the end > >of > >this year (and lasting till next year). It would be nice to work with a > >chick! > > > > > > >From: Amanda Stern <[EMAIL PROTECTED]> > > >Reply-To: [EMAIL PROTECTED] > > >To: CF-Talk <[EMAIL PROTECTED]> > > >Subject: Cold Fusion Developer - beginner > > >Date: Mon, 06 Aug 2001 15:47:52 -0700 (PDT) > > > > > > > > >Hello, > > > > > >Does anyone know of any open Cold Fusion positions > > >available in the Austin TX or Houston TX area > > >requiring about 1 year of experience? > > > > > >Thanks! > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Cold Fusion Developer - beginner
LOL ~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Fuon See Tu [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 11:04 AM To: CF-Talk Subject: Re: Cold Fusion Developer - beginner hey Amanda, we have a coldfusion project coing up soon later near the end of this year (and lasting till next year). It would be nice to work with a chick! >From: Amanda Stern <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: Cold Fusion Developer - beginner >Date: Mon, 06 Aug 2001 15:47:52 -0700 (PDT) > > >Hello, > >Does anyone know of any open Cold Fusion positions >available in the Austin TX or Houston TX area >requiring about 1 year of experience? > >Thanks! > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Kill all cookies
Set the Expire="NOW" on all of the cookie variables that you've set. -kev ~~~~~~~~~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Steve Reich [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 02, 2001 11:22 AM To: CF-Talk Subject: Kill all cookies How do I kill all cookies at once? Thanks, Steve ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: selecting top n records
Try this... SELECT COUNT(ProductID) AS TopN, ProductID FROM Products GROUP BY ProductID ORDER BY TopN DESC remember to put something of numerical value in the maxrows attribute. hth kev ~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Mark Warrick [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 1:07 PM To: CF-Talk Subject: selecting top n records I need to select the top selling products from a table of lineitems. Top selling products would be those whose ID_PRODUCT shows up the most in the ORDERS_LINEITEMS table. Any clues from the SQL gurus out there? ---mark = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL SERVER 7
The code wouldn't be that complicated considering you have both ODBC sources set up on the box that the cold fusion queries are running from. Just submit to both DataSources through your ODBC setup through cf. Or am i missing a "HUGE" step? ~~~~~~~~~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 9:32 AM To: CF-Talk Subject: RE: SQL SERVER 7 > Could anyone give me any feedback on the following: > > We have a SQL Server say for example "SQL1" based in Belfast, and > another SQL Server "SQL2" Based in London. > > What i need to do is write a stored procedure from a database in "SQL1" > "Table1" to insert data into "SQL2" "Table2",i have a few ideas but any > tips and feedback would be most apreciated. As long as the 2 servers can "see" each other, then there shouldn't be too much of a problem If either is invisible to the others, then this will obviously be impossible Never done it with a SP, but I've done it in queries quite happily - in fact, one in New York and one in London It was quite a while ago, but I'm sure I still have the code somewhere Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** 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 notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfmail
Yes, you can put any type of HTML formatting inside of a cfmail tag. Make sure you set your Type="html" up in the cfmail tag. kev ~~~~~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Jones, Becky [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 8:47 AM To: CF-Talk Subject: cfmail is there a way to put tags in the tag to make the formatting "prettier"? * This e-mail, including any attachments, is intended for the receipt and use by the intended addressee(s), and may contain confidential and privileged information. If you are not an intended recipient of this e-mail, you are hereby notified that any unauthorized use or distribution of this e-mail is strictly prohibited. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Country - States Database
Awesome, Thanks Joseph!!! ::CLAP:: ::CLAP:: ::CLAP:: kev ~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Joseph Thompson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 3:12 PM To: CF-Talk Subject: Re: Country - States Database In the spirit here is what I have gathered on State/county/City data ...(North America only) http://u8ntcn0.com/yahoocities.mdb ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Country - States Database
Wow, what a contribution to our CF Community::CLAP:: ::CLAP:: ::CLAP:: Thanks Bud! kevin ~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 1:16 PM To: CF-Talk Subject: Re: Country - States Database On 7/25/01, Kirk Boecker penned: >Does anyone know where I might find a global database of Countries and their >States? You bet. Made it myself. What a pain THAT was! LOL http://www.twcreations.com/ftp/country_state.zip I can't vouch for 100% accuracy but it should be pretty_darned_close. 256 countries (name and 2 letter code) related to 3,915 states (and 2 letter code for US and code for Canada), territories, provinces and whatever else they may call them. I've even got the currency and currency code for each country and whether or not UPS ships there. :) -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Delete session when browser is closed.
check this one out. http://www.teratech.com/coldcuts/cutdetail.cfm?cutid=229 ~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 25, 2001 7:11 AM To: CF-Talk Subject: Delete session when browser is closed. How can I delete all session variables(user/pass) when a user closes their browser? I have a logout option that works but if they don't use it, they are still logged into the system. Thanks, Dave ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: last modified
Ray, I know you can view a folder's listings with CFDIRECTORY which will show a date as an attribute that is returned. You can just filter for this file and get the name, date, size, etc... HTH Kevin ~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Ray Bujarski [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 17, 2001 2:34 PM To: CF-Talk Subject: last modified >Is there any way to access the attributes of a file, such as when it was >last modified? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE:
what is your question Craig? ~ Kevin Mansel Senior Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Craig Kiessling [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12, 2001 1:20 PM To: CF-Talk Subject: RE: Why is it that no one will even attempt to answer my question? It is way lower level than that of the other questions being posted - c'mon folks. some help me out. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFDecrypt URL
I remember the discussion so so well ;o) - Original Message - From: "Semrau, Steven L Mr SRA" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, June 28, 2001 1:38 PM Subject: RE: CFDecrypt URL > Let's not get started on this again... > > Steven Semrau > SRA International, Inc. > Senior Member, Professional Staff > [EMAIL PROTECTED] > [EMAIL PROTECTED] > Com: (703) 805-1095 > DSN: (703) 655-1095 > > > -Original Message- > From: Larry Juncker [mailto:[EMAIL PROTECTED]] > Sent: Thursday, June 28, 2001 4:19 PM > To: CF-Talk > Subject: CFDecrypt URL > > > Guys; > > I have lost my decrypted file. Can someone give me the URL again for > CFDecrypt? > You can send it offline even if someone has it. > > Thanks inadvance > > Larry Juncker > Senior Cold Fusion Developer > Heartland Communications Group, Inc. > [EMAIL PROTECTED] > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Does this work???
Testing. - Original Message - From: "Michael Dinowitz" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, June 28, 2001 8:10 AM Subject: Re: Does this work??? > Due to an impending drive failure I had to build a new box for the lists. > Problem is, the DNS for it is taking a lng time to go through to some > people (about 15% of the entire list at last count). This is slowly > changing, but its a bit out of my hands at the moment. Once the DNS is ok by > you, then you'll get your mail. > As a side note, your able to post. It's just the receipt that's the problem. > > > > Does this work? I have not seen messages > > for over 5 days now. > > > > I have subscribed, unsubscribed, resubscribed. > > > > I am subscribed out... > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Need decryptor tag for CFUG presentation
Well i'm not talking about plagerism, i'm talking about studying the code, how they made it work, etc, etcthen developing your own application, that is how a lot of us learned from bookes that we've bought, starting out with cold fusion, I am sure most of us put in a few bits of code mentioned in forta's books, and tried it out, then took off with it right? That is what my majority point is. kev ~~~~~~~~~ Kevin Mansel Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Top-Link Tech (John Ceci) [mailto:[EMAIL PROTECTED]] Sent: Friday, June 08, 2001 12:40 PM To: CF-Talk Subject: RE: Need decryptor tag for CFUG presentation But Kevin that book has been published and the author has made the decision to give that code away with the COST of the book...or the Teacher has been PAID by the school to develop the program as a learning tool...See the general thread there...MONEY changing hands... If you just pluck a tag off the tag gallery, decrypt it and then use the code, in whole or part, you are breaking the law... John -Original Message- From: Kevin Mansel [mailto:[EMAIL PROTECTED]] Sent: Friday, June 08, 2001 11:54 AM To: CF-Talk Subject: RE: Need decryptor tag for CFUG presentation Anyone with any knowledge of using a search engine can find that site. I don't think it was that big of deal personally. A popular way to learn how to code is to see other people's code. That is how you learn in school, the teacher shows you code, you get a book, then you take it to the next level to create something with the tools you learn from studying that code. just my .02 -kev ~ Kevin Mansel Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Robert Long [mailto:[EMAIL PROTECTED]] Sent: Friday, June 08, 2001 8:55 AM To: CF-Talk Subject: RE: Need decryptor tag for CFUG presentation I think it was VERY unprofessional of those individuals that posted a link directly to the utility. I have no idea how many people are on this list, but now all of them have knowledge of that site. Why don't you just upload a copy of your CFAS cd and post a link to that too. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, June 08, 2001 8:50 AM To: CF-Talk Subject: Re: Need decryptor tag for CFUG presentation Saying this as Michael Dinowitz, yes. The decrypt utility is illegal according to the MM licensing contract. > Correct me if I'm wrong, and I'm saying this as Ray Camden, not Ray Camden > of Macromedia, but isn't use of this decryptor illegal? Should we so > casually discuss a piece of a software that is probably illegal to use? > > Also, in general, unless you encrypt your OWN files, you should not be > decrypting other people's templates. If you _do_ encrypt your files, you can > contact Tech support for help. Therefore, there is no need for this > software. > > Am I wrong here? And let's not discuss wether it's "right" or "wrong", I'm > talking about legality. > > === > Raymond Camden, Principal Spectra Compliance Engineer for Macromedia > > Email : [EMAIL PROTECTED] > ICQ UIN : 3679482 > > "My ally is the Force, and a powerful ally it is." - Yoda > > > -Original Message- > > From: Jones, Matt [mailto:[EMAIL PROTECTED]] > > Sent: Friday, June 08, 2001 9:37 AM > > To: CF-Talk > > Subject: RE: Need decryptor tag for CFUG presentation > > > > > > http://shrewm.net/cfd/ > > > > -Original Message- > > From: Alii Design [mailto:[EMAIL PROTECTED]] > > Sent: Friday, June 08, 2001 8:30 AM > > To: CF-Talk > > Subject: RE: Need decryptor tag for CFUG presentation > > > > > > That website is gone http://shroom.dv8.org/cfd/ I was looking for it > > recently and it has been down. > > Is there another? > > Rich > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Need decryptor tag for CFUG presentation
Raymond, I didn't take it as a personal attack :) Maybe i was a little vague on the book, code thing, I am just talking about examples they give in books, and taking those examples, studying how the code was written, and then taking it to a high level. I'm not talking about stealing code or anything like that, i mean maybe thats the way i made it sound, now that i read it back to myself out loud... (doh!) But my true intentions were to just emphasize the fact that even when people look at source code online, or .js scripts, that is a lot of what learning is. -kev ~~~~~ Kevin Mansel Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Friday, June 08, 2001 11:42 AM To: CF-Talk Subject: RE: Need decryptor tag for CFUG presentation > Anyone with any knowledge of using a search engine can find that site. I > don't think it was that big of deal personally. A popular way to > learn how > to code is to see other people's code. That is how you learn in > school, the > teacher shows you code, you get a book, then you take it to the next level > to create something with the tools you learn from studying that code. Oh yea, I remember learning to code in school by stealing other's people code. Yea, I did it all the time. I assume you actually paid for that book, right? Or borrowed it from the library? There is a difference. I strongly encourage people to learn by looking at other people's code... but don't you think it's fair to ASK that person beforehand? (Unless they posted it to the web to share with the world.) And if that person has encrypted their code, maybe, just maybe, and I know I'm stepping out on a limb here, but maybe they don't want you to read their code? What really bugs me is this attitude of "If I want to learn, it's ok for me to read your code, even if you don't want me to". I'm not attacking you personally Kevin, but I just think that's wrong. Raymond Camden ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Need decryptor tag for CFUG presentation
Anyone with any knowledge of using a search engine can find that site. I don't think it was that big of deal personally. A popular way to learn how to code is to see other people's code. That is how you learn in school, the teacher shows you code, you get a book, then you take it to the next level to create something with the tools you learn from studying that code. just my .02 -kev ~~~~~ Kevin Mansel Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Robert Long [mailto:[EMAIL PROTECTED]] Sent: Friday, June 08, 2001 8:55 AM To: CF-Talk Subject: RE: Need decryptor tag for CFUG presentation I think it was VERY unprofessional of those individuals that posted a link directly to the utility. I have no idea how many people are on this list, but now all of them have knowledge of that site. Why don't you just upload a copy of your CFAS cd and post a link to that too. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, June 08, 2001 8:50 AM To: CF-Talk Subject: Re: Need decryptor tag for CFUG presentation Saying this as Michael Dinowitz, yes. The decrypt utility is illegal according to the MM licensing contract. > Correct me if I'm wrong, and I'm saying this as Ray Camden, not Ray Camden > of Macromedia, but isn't use of this decryptor illegal? Should we so > casually discuss a piece of a software that is probably illegal to use? > > Also, in general, unless you encrypt your OWN files, you should not be > decrypting other people's templates. If you _do_ encrypt your files, you can > contact Tech support for help. Therefore, there is no need for this > software. > > Am I wrong here? And let's not discuss wether it's "right" or "wrong", I'm > talking about legality. > > === > Raymond Camden, Principal Spectra Compliance Engineer for Macromedia > > Email : [EMAIL PROTECTED] > ICQ UIN : 3679482 > > "My ally is the Force, and a powerful ally it is." - Yoda > > > -Original Message- > > From: Jones, Matt [mailto:[EMAIL PROTECTED]] > > Sent: Friday, June 08, 2001 9:37 AM > > To: CF-Talk > > Subject: RE: Need decryptor tag for CFUG presentation > > > > > > http://shrewm.net/cfd/ > > > > -Original Message- > > From: Alii Design [mailto:[EMAIL PROTECTED]] > > Sent: Friday, June 08, 2001 8:30 AM > > To: CF-Talk > > Subject: RE: Need decryptor tag for CFUG presentation > > > > > > That website is gone http://shroom.dv8.org/cfd/ I was looking for it > > recently and it has been down. > > Is there another? > > Rich > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Missing Line Numbers
Haven't seen that one yet, but have you seen the one where your folder explorer to the left displays each file two times? That happens from time to time for me... ~ Kevin Mansel Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Jay Jennings [mailto:[EMAIL PROTECTED]] Sent: Monday, May 21, 2001 9:35 AM To: CF-Talk Subject: Missing Line Numbers The line numbers in my copy of CFStudio 4.5.2 (under Win2K) have disappeared sometime recently. Toggling them in the control bar doesn't do anything. I figured I'd check here before I reinstall or whatever. Is this familiar to anyone? Thanks. ..jj.. - - - - - Get your free email account: [EMAIL PROTECTED] Sign up at http://www.alakazam.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: Re: Weather Icons: I need some
if you are looking for like gif or jpgs to put up on websites, nbci.com has some good ones. kev ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Verify Address
USPS Validator in the DEV Exchange kev ~ Kevin Mansel Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Nick McClure [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 7:53 AM To: CF-Talk Subject: Verify Address Does anybody have a good block of code in CF, SQL, or even ASP that will verify an address against the post office data? I have the Post Office Data. Any help would be greatly appreciated. I am open to commercial products as well ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Order By
Depends on what you want to order it by a table of 10 values numbered 1 - 10. SELECT * FROM Numbers ORDER BY NumberID DESC(descending) ASC(ascending) #getlast.numberid# Use only DESC or ASC in your Order By statement hth kevin ~ Kevin Mansel Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: ibtoad [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 10:33 AM To: CF-Talk Subject: Order By How can I display an output in reverse order by? I want only the last record to be displayed. Thansk for your help, Rich ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFSELECT Question
Ok, I know this tag pretty well, but what I am trying to do is combine two columns and do a little formatting to them, but have that come up in the display of the CFSELECT Tag, now i just get errors when i try to directly apply the formatting within the "display" value of the tag, can someone guide me in the right direction on wether this is even possible??? thanks kev ~~~~~ Kevin Mansel Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfm-resources?
sorry, 6.95 :) ~ Kevin Mansel Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 7:39 AM To: CF-Talk Subject: cfm-resources? Hi all, I was wondering if anyone else was having problems with free accounts at cfm-resources.com? First my password stopped working, and when I got no response to repeated emails, I gave up and signed up for another account. (Incidently, after a number of errors were thrown in the registration scripts, I ended up with three accounts but that's a different story.) Attempts to FTP in are successful after on average three or four timeouts. Everytime I do actually manage to connect, it timeouts before I can upload any files. The site itself takes ages to load and then I get server errors. The cfm-resources control panel is not even up. Now, before you tell me that you get what you pay for, I totally agree. I'm developing a site for a non-profit organisation with next to zero funding, which promotes science and technology career paths for high school students, girls in particular. The aim is to create a site that they can update and maintain themselves, thereby requiring no more funding for web work. My plan being, if I can get the site running on the free hosting service, and they see how great and easy it is and maybe interest some benefactors, I will get them to move to one of the low cost hosting services. Hell, I was even planning to pay for some of it myself. I'm not expecting great reliability or speed out of a free service. But at the moment *I* can't even view the site, and it's been like that all week. What I would like to know is, what is the reliability like on their paid accounts? I'd be reluctant to risk them after my experiences with the free service. What are the other low cost hosting services out there like? Sorry to bitch but this is driving me insane! Kay. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfm-resources?
www.atswebnet.com 4.95 a month kev ~ Kevin Mansel Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Kay Smoljak [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 7:39 AM To: CF-Talk Subject: cfm-resources? Hi all, I was wondering if anyone else was having problems with free accounts at cfm-resources.com? First my password stopped working, and when I got no response to repeated emails, I gave up and signed up for another account. (Incidently, after a number of errors were thrown in the registration scripts, I ended up with three accounts but that's a different story.) Attempts to FTP in are successful after on average three or four timeouts. Everytime I do actually manage to connect, it timeouts before I can upload any files. The site itself takes ages to load and then I get server errors. The cfm-resources control panel is not even up. Now, before you tell me that you get what you pay for, I totally agree. I'm developing a site for a non-profit organisation with next to zero funding, which promotes science and technology career paths for high school students, girls in particular. The aim is to create a site that they can update and maintain themselves, thereby requiring no more funding for web work. My plan being, if I can get the site running on the free hosting service, and they see how great and easy it is and maybe interest some benefactors, I will get them to move to one of the low cost hosting services. Hell, I was even planning to pay for some of it myself. I'm not expecting great reliability or speed out of a free service. But at the moment *I* can't even view the site, and it's been like that all week. What I would like to know is, what is the reliability like on their paid accounts? I'd be reluctant to risk them after my experiences with the free service. What are the other low cost hosting services out there like? Sorry to bitch but this is driving me insane! Kay. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL query help
do a group by query SELECT * FROM Bars GROUP BY BarColor hth kevin ~ Kevin Mansel Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 08, 2001 1:16 PM To: CF-Talk Subject: SQL query help I have a database similar to this: SKU NAMECOLOR STYLE 1 bar blue12" 2 bar blue6" 3 bar blue5" 4 bar red 12" 5 bar red 6" 6 bar red 5" I want to find all the colors that 'bar' comes in. If i do a query on this to find all the colors for the NAME 'bar'. I get: blue blue blue red red red How do i get results like this? blue red Thanks in advanced Chad ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Inexpensive Hosting
www.atswebnet.com -kev ~ Kevin Mansel Web Developer Fox Communications [EMAIL PROTECTED] DL : 425-649-1321 C : 425-346-7221 -Original Message- From: Guy McDowell [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 03, 2001 6:52 AM To: CF-Talk Subject: Inexpensive Hosting G'day eh? I'm trying to find very inexpensive CF hosting to no avail. Something under $20 CDN is preferred. I need to host my personal/resume site along with some CF examples I have done. Thought I saw someone post something about hosting for $5.95 a month If there is nothing like that, then is it possible for me to institute CF Server Express within my own account/directory on a regular hosting package of the WinNT variety? Guy www.guymcdowell.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Hey Check This Out?!?!
Anyone ever seen this An error has occurred while processing the expression: !airheadjb_test=CFTempOnlyForSetVariableNeverUseThisNameInYourCFMLCode1223335654321 Invalid token found on line 1 at position 1. ColdFusion was looking at the following text: ! Invalid expression element. The usual cause of this error is a misspelling in the expression text. The error occurred while processing an element with a general identifier of (CFFTP), occupying document position (49:1) to (49:208). ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Last row inserted
SELECT MAX(Row) AS MaxRecord WHERE MaxRecord = @@IDENTITY i believe that is the correct syntax beat me over the head if i'm wrong :P kev ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Screen Shot on Win 2K
i thought it was just alt+print screen>?>?>? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Grouping Problem
Thank you very much, this worked just fine. Kevin -- Original Message -- From: "Chris Stoner" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Fri, 06 Apr 2001 15:52:01 -0400 >You might be better served by doing something like this > > > > SELECT DATEPART(day, DateColumn) AS 'GroupDate', >DateColumn, > OtherColumns > ORDER BY DateColumn > > > > > #GroupDate# > > #OtherColumns# > > > > >-- Chris Stoner > >-Original Message- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] >Sent: Friday, April 06, 2001 3:07 PM >To: CF-Talk >Subject: Grouping Problem > > >I'm sure at least one of you people have had this problem, and i'm pulling >my hair out of here > >I have a field which has a date/time value. > >ie : 4/3/2001 12:00:00 PM > >now there are tons of records for each day, but with different times. > >I am trying to output a list of the past 10 days. Grouped by the Day only, >not the time. > >I've tried to actually format the date field in my [group] functions in the >cfoutput like this... > >"m/d/")#"> > >but this gives me an error saying that the information in the query does not >match within the loop > >Can someone help me on this one? I feel as though there is a really simple >answer, though i am clearly not seeing it > >Thanks. > >Kevin > >~ >Kevin Mansel >Web Developer >Fox Communications >[EMAIL PROTECTED] >DL : 425-649-1321 >C : 425-346-7221 > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Allaire Developers Conference?
Is there going to be a third annual developers conference now? If anyone has any links on it, could you please send those to me? Thanks Kevin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: DB structure advice
Personally i would make a series of tables to deal with this type of information that ties back to each user via Primary Key identifier like this Table Name : People Primary Key : PersonID Table Name : Education Primary Key : EducationID Tied with People Table via PersonID Field Table Name : JobStatus Primary Key : JobStatusID Tied with People Table via PersonID Field etc, etc, etc it will make it a lot eaiser in the long run for scalability when adding even more fields to databases as well as multiple records over time, what if the person has 2 degrees from different institutions? Or what if you want to keep track of that persons Job history? Multiple records in a seperate table will be much eaiser to track and query than running into comma delimited fields in one column of a table just my .02 kevin -- Original Message -- From: "Jason Lotz" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Tue, 20 Mar 2001 09:52:01 -0700 >This is more of a theory question than an actualy request for help. Let's >say you are building a database of members with lots of information that >applies to every member (name, address, phone, etc.) This could be about 40 >seperate fields. Then, on top of that, each member can have lots of >optional information that can easily be grouped together. For example, if >they graduated from college, you want to store their degree information or >if they own a company, you want to store their company info. Each of these >"optional groups" are one-to-one (each member can only have one chunk of >this data but doesn't have to have it at all.) Now here's the question - > >When you are building this database, you could easily put it into one huge >table because all the information is one-to-one. However, it's a pain when >you only want to get the "degree" information or the "company" information. >>From a programming standpoint, is it best to break these into smaller tables >for ease of use or to keep it into one table? > >Thanks, >Jason > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Zombo.Com
personally, this is nice to get during a day of stress, really brings out a chuckle... ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Arrays....
How would i display the entire contents of an array? I keep getting this error Expression result cannot be converted to a string Expressions used inside tags like CFOUTPUT, CFQUERY, CFMAIL, etc. must evaluate to a value that can be converted to a string for output or dynamic text accumulation purposes. Complex objects, such as queries, arrays, and COM/DCOM objects, cannot be represented as strings. Any help would be much appreciated... TIA Kevin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Parsing Text with CFHTTP
Anyone have any tutorials or explainations on how to do this effectively??? Thanks Kevin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Earthquake in Seattle
I must say it was pretty scary. Have to go now, evacuating the building... God Bless Kevin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT : Forms Question...
Is there a way that once someone enters the maximum number of elements in a form, that it automatically tabs to the next field In this example, entering a phone number by areacode, prefix and suffix only. so once the user enters the 3 digit area code, i want it to hop to the next fieldis this possible, if so can someone direct me to the solution Thanks Kevin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Information on Stripping Information
Ok, i've seen it done many many times, can someone direct me to a website maybe, or a whitepaper that explains how to parse stuff out? Like for example, grabbing the headlines off another website, but stripping out the stuff that you don't want? Thanks, Kevin ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Check value of form check box for CFMAIL
Jeff, If you want to test if it has been checked you can do it this way... I want banner ads Kevin Mansel ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT : Java, JavaScript Forums??
I would like to ask you fellow programmers if you have any preferences on some good JavaScript and Java communities and mailing lists like this one for CF. Thank You, Kevin Mansel ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Testing
Please disregard, just testing. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: New To Sql From Access
I think it is : CREATE TABLE yourtable ( TableID INTEGER NOT NULL PRIMARY KEY ) -Kev ~~~ Kevin Mansel Web Developer / Cold Fusion Programming http://www.kevinmansel.com [EMAIL PROTECTED] Phone : 206-286-6310 Cell : 425-346-7221 - Original Message - From: "AustralianAccommodation.com Pty. Ltd." <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, October 28, 2000 8:50 PM Subject: New To Sql From Access > How do I set up sql field names to be equivalent to autonumber field names > in access > > > Kind Regards > > Claude Raiola (Director) > AustralianAccommodation.com Pty. Ltd. > Website: www.AustralianAccommodation.com > Email: [EMAIL PROTECTED] > > -- -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
Re: OT Dreamweaver CF Objects
For some odd reason when I write this little cfif statement in dreamweaver, it turns our fine, but if i were to open the file in Ultra Dev, it really messes it up badtry it Kevin ~~~ Kevin Mansel Web Developer / Cold Fusion Programming http://www.kevinmansel.com [EMAIL PROTECTED] Phone : 206-286-6310 Cell : 425-346-7221 - Original Message - From: "Jon Hall" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, October 28, 2000 8:35 PM Subject: Re: OT Dreamweaver CF Objects > If you are a Dreamweaver guy like me, Ultradev is wonderful. It is not any > good for developing templates, but it's great for getting a visual on what > your code looks like, and it wont mangle your code. > > jon > - Original Message - > From: "Matt Fuller" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, October 27, 2000 8:18 PM > Subject: OT Dreamweaver CF Objects > > > > I searched all around www.allaire.com and www.macromedia.com to find CF > > objects for Dreamweaver. I saw the announcement of these objects on the > > allaire site anyway, this pages just sent me to the macro. site and I > could > > not find them. Does anyone know where I could find them? A link would be > > nice if macro. does have them somewhere. > > > > Thanks, > > Matt > > > > -- > -- > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send > a message with 'unsubscribe' in the body to > [EMAIL PROTECTED] > > -- -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
