RE: Randomizing a Query Result or List
Once you've used your cfquery - in a loop run some code that will select 2 randaom rows and swap the values... just a quick thought... never tested it out... you should be able to swap the rows like this: query_name.column_01[row number], you'd have to swap every column individually though... Which brings a question to mind. Does anyone know the syntax for swaping an entire row? is there any such syntax? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 22 May 2001 14:46 To: CF-Talk Subject: Randomizing a Query Result or List I do a complex query and currently the results are returned based on the order they appear in the db. What I need to do is have the order they are returned as random. Is there a ORDER BY RANDOM type of syntax that will work with my Access database? Alternatively, the results are stored in a list (ex: 5,8,3,7,89,100,305,306) Anyone know how to take an existing List and mix it all up? Thanks, Brian ~~ 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: How do I open an IE window into fullscreen channel mode?
create a shortcut with the following command iexplore -k somepage.com regards, Javier -Original Message- From: Spadea Ho [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 12:04 PM To: CF-Talk Subject: How do I open an IE window into fullscreen channel mode? Hi guys, new to the list here. Sorry to ask this question here, but I really need to find out a way to launch an IE window into full screen channel mode (the mode when u manually hit F11 to make the browser fullscreen) from a desktop shortcut. I have to do this for some net kiosk at a cafe. Does anyone know of any javascript that does this? I have been searching thru' the major developer sites with no results. Can anyone give me a hand in this? Thanks a million, Spadea ho. ~~ 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: Code Snippet:Random Password Generator(repost)
Just as a side note, from experience... Omit the Letter O, the number 0, the
letter I and the number 1 from any passwords you create... This causes no
end of problems when users get their password's and they still cant login
becase the mentioned letters are hard to distinguish, espicially on fonts
such as verdana, arial etc...
I would probably use alphabet =
ABCDEFGHJKLMNPQRSTUVWXYZ23456789abcdefghjkmnpqrstuvwxyz to get harder to
guess passwords... This depends though on how secure you wish to make your
site...
Anyone else have any input on this issue?
Regards,
Javier
-Original Message-
From: Angél Stewart [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 04, 2001 10:10 PM
To: CF-Talk
Subject: Code Snippet:Random Password Generator(repost)
From: kermit
Subject: Code snippet - random password generator
Date: Thu, 29 Mar 2001 16:53:21 -0800
--
--
This script generates a random word 7 letters long plus 4 digits long.
Example code:
cfset random_word =
cfloop index=ii from=1 to=7
cfset random_number = #RandRange(1,26)#
cfset alphabet = ABCDEFGHIJKLMNOPQRSTUVWXYZ
cfset random_letter = #Mid(alphabet,random_number,1)#
cfset random_word = #ListAppend(random_word,random_letter)#
/cfloop
cfset random_word = #Replace(random_word, ,, , ALL)#
cfset random_number = #RandRange(1000,)#
cfset password = #random_word##random_number#
cfoutputPASSWORD: b#password#/b/cfoutput
--
--
From: Raymond B.
Subject: RE: Code snippet - random password generator
Date: Thu, 29 Mar 2001 18:37:14 -0800
--
--
Why define the alphabet? Just use decimal values for the asci
char set.
pass = ;
for (c=1; c le 7; c=c+1) {
pass = pass chr(randRange(65,90)) ;
}
pass = pass randRange(1000,) ;
That will do the exact same thing as below much more
efficiently, if you
want case sensitive or nums mixed w/ chars it's just a couple extra
rangRanges()s (you can get creative and generate one of each
class then
randRange(1,3) to choose which per digit).
--
--
-
From: Jay Jennings
Subject: RE: Code snippet - random password generator
Date: Thu, 29 Mar 2001 18:55:39 -0800
--
--
Why define the alphabet? Just use decimal values for the
asci char set.
So, just because I'm bored, in the unrolled loop I created I
change the
alphabet to Raymond's chr:
cfset random_word = random_word chr(randRange(65,90))
The speed increase was fairly slight:
Original code (executed 1000 times): 9994 ms (average)
Unrolled code (executed 1000 times): 1993 ms (average)
Unrolled w/chr (executed 1000 times): 1932 ms (average)
But it looks much nicer than repeating the alphabet in each line.
I was going to mention that when I generate passwords I tend
to NOT use the
letters O, I and L and the numbers 1 and 0. Those create too many my
password doesn't work! tech support calls.
..jj..
--
--
--
Hope this helps :)
-Gel
~~
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
What is WDDX?
I've heard a lot of talk about WDDX but i'am unclear as to what it is, what is it used for? Can anyone explain? Or recomend a site with tutorials and information? Regards, Javier Woodhouse ~~ 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: Show status of process - Please Help
I would have a simple color image somewhere on the page, for instance, called 'ProgressBar' and in the loop have something like Just a quick snippet... cfloop . . . . . . . . . . . . . . . . . . . . script ProgressBar.width = #PercentComplete# /script cfflush /cfloop I'am not sure about CFFLUSH, it was in a thread a while back, hope this helps... -Original Message- From: Chiraporn [mailto:[EMAIL PROTECTED]] Sent: Monday, April 23, 2001 2:01 PM To: CF-Talk Subject: Show status of process - Please Help How to show status of process ? I've process which take a while for runing and I would like to show user how many percent are progress. I've quite long loop , so process will take a while and because of ( i am not sure ) CFLOOP , it not show my percent in loop until it finishing process then user will not know what going on in the process. Any suggestion ? Thank you Phim ~~ 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: Protecting a directory w/non CF files on Win2k
Create a protected directory on the server that is only accessible to users logged in to a particular group that you create on the NT box, say 'AccessGroup', using coldfusion you can dynamically create users on the NT system using the following example: http://support.microsoft.com/support/serviceware/iis/iis40/e9zui3abh.asp You can log in people using the cf NT authentication process (see the manual) and viola.. all the resources are protected via NT security, which is about the best you can do using an NT box... This is the proper way to do it, but personally your recomendation to use cffile would probably be what i would do for a low budget project. Regards, Javier -Original Message- From: Peter Janett [mailto:[EMAIL PROTECTED]] Sent: Monday, April 23, 2001 2:56 PM To: CF-Talk Subject: Protecting a directory w/non CF files on Win2k I need to duplicate a password protected directory, from an account that used to use UNIX with .htaccess. I was planning to do a check of cookies, sessions, etc in application.cfm, but that won't work to protect file formats such as Excel an PowerPoint. I had the idea to store the Excel and Power Point files in a no web accessible folder, and have CF output them with CFFILE, which would give me password protection, but I'm concerned that may be very inefficient, and wonder if there is a better way. I should note, I need to automate the username and password creating process with CF, so doing it by hand through the IIS admin is not a good solution. Any help, resources, etc. appreciated, Peter Janett New Media One Web Services WEB HOSTING FOR WEB DEVELOPERS Sun, IRIX, Windows 2000, Linux; PHP, MySQL, Perl, Cold Fusion, MS SQL, ASP, SSI, SSL http://www.newmediaone.net [EMAIL PROTECTED] (303)828-9882 ~~ 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] Stats pkg for Win2K IIS
try analog http://www.analog.cx/ It's not automated, but if you have win2k you can manage it pretty easily by using the scheduler -Original Message- From: Peter Janett [mailto:[EMAIL PROTECTED]] Sent: Monday, April 23, 2001 3:05 PM To: CF-Talk Subject: [OT] Stats pkg for Win2K IIS I'm looking for a low cost of free stats package to run on Win2K, that will do automatic nightly reporting. I know that's a general question, but I'm looking for opinions as much as a list of software that does that. Thanks, Peter Janett New Media One Web Services WEB HOSTING FOR WEB DEVELOPERS Sun, IRIX, Windows 2000, Linux; PHP, MySQL, Perl, Cold Fusion, MS SQL, ASP, SSI, SSL http://www.newmediaone.net [EMAIL PROTECTED] (303)828-9882 ~~ 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: Virus Software
Charlie, You could probably use VET (download.com) which is pretty easy to use from the command line... But i think your better of buying a proper server anti-virus program that will monitor all data comming in to hard drive. Regards, Javier -Original Message- From: Charlie McCormack [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 19, 2001 2:00 PM To: CF-Talk Subject: Virus Software Hi anyone recommend any Anti Virus software that I can run to check uploaded files as they come in. I would like to have a command-line util if possible, something like back in the old days when BBSs were around. Cheers, Charlie McCormack [EMAIL PROTECTED] -- -- --- Ventaro Designs Sydney, Australia http://www.ventaro.net (Where it all begins) http://www.kwiklink.com.au (Need Something?) -- -- --- ~~ 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: Note passing system?
I'd like to add to that... I also have no problem comming up with the code i need, but code that is available publicaly is likely to have undergone serveral bug fixes, performance enhancements and it might even be better then what i could come up with. Code reuse has it's benefits Regards, Javier -Original Message- From: Rey Bango [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 4:37 PM To: CF-Talk Subject: Re: Note passing system? :o) Hi Peter. I certainly understand where you're coming from. After 3 years of doing some solid CF work, I'm very capable of building most of the stuff that I need. I'm just an advocate of code reuse. If there's something out there that helps me reduce my coding time, I'd like to take advantage of it. I really hate reinventing the wheel. Thanks for the feedback... Rey... Certified Allaire Instructor Member of Team Allaire "A browser's beauty, at its heart, is its usefulness as a *TOOL*." - Original Message - From: "Peter Tilbrook" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 1:59 AM Subject: RE: Note passing system? As a side note - if you have an idea for your application - do it! Do not expect someone else to have already written the code for you. CF makes coding easy. If you are worried about the code have trusted people try and break it. Spend at least 3 weeks with beta testers on trusted code. You would be amazed at how the feedback either picks up problems or points out, even unobtrusively, better ways to accomplish a task. -Original Message- From: Peter Tilbrook [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 17 April 2001 15:33 To: CF-Talk Subject: RE: Note passing system? I implemented the same thing for the new Friends Plus site. The beauty of the system is that nobpdys email address is released. We could be draconian and introduce full auditing but it has not been necessary yet. The user remain anonymous and their email address is never released unless they give it out. -Original Message- From: Rey Bango [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 17 April 2001 14:57 To: CF-Talk Subject: Re: Note passing system? Not really, Paul. Its more like an internal messaging system. One where I can write a message to another user or perhaps a group of users and have them correspnd back. Again, its not a true email system but one that would allow me to be able to communicate within the scope of my own application. Rey... Certified Allaire Instructor Member of Team Allaire "A browser's beauty, at its heart, is its usefulness as a *TOOL*." - Original Message - From: "Paul Begovich" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, April 16, 2001 7:35 PM Subject: Re: Note passing system? Sounds like you want a project management tool. We have an internal system here we use to parse out work. Basically the client/project manager submits an item to a form and it appears on the necessary persons desktop based on who they select. They see the item, do the work, mark their time, and reply via the form. It's a great project management tool and it keeps track of correspondence. Building a system like your describing isn't too difficult, it's just time consuming. We have looked into outside utilities to do this, but we've found them lacking. As a development shop we have found that when we need some additional functionality we build it on. The current system we have now has grown out of several developers efforts in the past two years to incompass project managment, billing, contacts, work requests, logging, and a host of other things. A third party too may save you time in the short run, but in the long run, it'll probably lacks the additional functionality you want. I recommend buiding your own system, keeping in mind you want to be able to add additionally functionality in the future. - Paul - Original Message - From: "Rey Bango" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, April 16, 2001 1:07 PM Subject: Note passing system? Anyone know of a good CF-based note/messaging system? I'm not talking about an email server but more of a db driven messaging software that will allow me to post a message to a specific suer. When that user comes in, they can check for their own messages and reply accordingly. Again, its not an email system per se. Thanks, Rey Bango... Certified Allaire Instructor Member of Team Allaire "A browser's beauty, at its heart, is its usefulness as a *TOOL*." ~~ Structure your ColdFusion code with Fusebox. Get
RE: Drop Down Combo Boxes Disappearing in IE
I've only ever seen this happen when using javascript to populate combo boxes - also have you checked the style sheet property for combo boxes... you might have a style set up for select or input that is hiding your drop downs... -Original Message- From: Ricq Pattay [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 17, 2001 11:41 PM To: CF-Talk Subject: Drop Down Combo Boxes Disappearing in IE I have a CF page with approximately 40-50 drop down select/combo boxes (query driven dynamically named). On some computers in IE 5.5 the drop downs don't appear when the page loads -- there's only a white space where the drop down should be. Other form elements (text boxes, submit buttons) appear normally. Netscape seems fine but with only limited testing from me. Any ideas? Ricq Pattay ~ [EMAIL PROTECTED] Senior Analyst/Programmer College of Veterinary Medicine University of Minnesota - Twin Cities ~~ 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: Query string disappear
To hide 'ugly' URL's i usually put the page in a frame so the url will always read http://someplace.com/ as the user clicks through the one frame -Original Message- From: Todd Ashworth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 12:32 PM To: CF-Talk Subject: Re: Query string disappear Yes, but these can be easily seen and manipulated by viewing the source. Encrypt() is a much better option for URL passed data. Todd - Original Message - From: "Garza, Jeff" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 10:18 PM Subject: RE: Query string disappear Really you can't. You'll have to look into using an onClick event to fire off some javascript that submits a form with hidden fields. That's what I do when I don't want clutter my urls with bunches of variables. ~~ 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: CF Website
Just a quick question on spectra - how hard is it to pick up if you have farily strong CF skills? -Original Message- From: David Hannum [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 12, 2001 11:18 AM To: CF-Talk Subject: Re: CF Website Spectra (but it ain't FREE) Dave - Original Message - From: Parker, Kevin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, April 11, 2001 8:55 PM Subject: CF Website Does anyone now of any CF based systems/products that create a website purely and entirely from a backend e.g. www.phpnuke.org Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: +61 8 82332548 f: +61 8 82332000 m: 0418 800 287 ** ** This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. ** ** ~~ 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: Procedure and Function (Rambling thought)
I agree! I dont know what the big fuss is about... CF Tags are functions as far as anyone should be concerned - just because they're not implemented in exactly the same way VB, Java, etc implements functions means didley squat... I'll be the first to admit that I'am sometimes frustrated by how CF Tags are carried out but more often then not i thank god that they work as they do, it makes life so much easier when your output is HTML. As for objects - Anyone thinking of using a scripting language to create a program that requires objects should be taken out and given a good talking to. CF is great as the glue that holds together all the objects that we need to create effective websites (DB connections, Email, Files, Forms, etc) but by no means would i use CF to create something as complicated as a credit card transaction gateway - Java is much more nicely designed to do this. In short, i think CF has been brilliantly written to create websites quickly, effectively and under budget - an equivilent website could take as long as 3 times longer if written in C++ or Java... The right tool for the right job - you dont complain when your drill doesnt perform well as a hammer. Regards, Javier -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 12, 2001 2:29 PM To: CF-Talk Subject: RE: Procedure and Function (Rambling thought) Sorry, but my wandering mind's gotten the better of me and I've got a concept to throw out for those who might want to chew on an idea (no spitting, please... we just washed the floors). From what I remember from my CS classes (my degree is in Electronics, not CS) functions and procedures are devices that use either an individual or multiple attributes to perform some computation. In the case of a function, at least one value is returned to the calling process. Forgive me if I'm reaching a bit here, but doesn't that remind anyone else of a custom tag or CFX tag? A procedure doesn't return a value, but simply performs an action or actions on attributes passed to it. Taking a bigger stretch, doesn't that sound a bit like an include? Now I know, this is getting abstract, but it seems to my thought process that Allair actually did provide us with a mechanism for performing external functions that can be used repetively across a wide array of applications and scopes. So to throw a kink into the wheel, yes, Cold Fusion does have functions. We simply call them something different: Custom Tags. As for implementing Object Oriented programming concepts, that may be a bit outside the bounds of what can be done. In all honesty, that's okay. I personally hated OOP... especially when I had a PhD that was more interested in researching multiprocessor programming concepts than teaching, but I digress. Sorry for the rant and the ramble... 19 days nicotine free, living with in-laws and looking at buying my first house. All this and I haven't had a drop of alcohol (yet)! Enjoy! C. Hatton Humphrey Cold Fusion Developer Fisher, Towne Associates http://www.fishertowne.com [EMAIL PROTECTED] -Original Message- Hi Haryono, if you refer to your previous posts on this issue, and other peoples subsequent replies ... I'm sure you will notice that CF isn't OOP and we do not make any Your post : http://www.mail-archive.com/cf-talk@houseoffusion.com/msg49020.html My reply : http://www.mail-archive.com/cf-talk@houseoffusion.com/msg49023.html Please take notice of answers when you post a question. Hallo, How can i use procedure and function in ColdFusion? Is this possible to use OOP in ColdFusion? ~~ 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: Registry size.
Use a username/password if it's a shared box... -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 10, 2001 12:01 PM To: CF-Talk Subject: Re: Registry size. Jon, If there is ever an error in the dsn won't the server throw the DSN name. This would become a security issue since user X can query user Y's client info? Thanks, Neil - Original Message - From: "Jon Hall" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, April 09, 2001 6:27 PM Subject: Re: Registry size. Changing the client variables to be stored in a database is one of the first things I do on a new server. Using an Access database is much better than the registry. SQL Server or any other real rdbms is even better. jon - Original Message - From: "Neil H." [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, April 09, 2001 5:58 PM Subject: Re: Registry size. I host several sites with people and some really sloppy code. Does using a MDB have any ramifications. Also won't people be able to manipulate this database?! They can't manipulate the registry since it is locked there is no CFregistry. Thanks, Neil - Original Message - From: "Arden Weiss" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, March 27, 2001 9:59 PM Subject: RE: Registry size. Time to move your client variables to ODBC source, etc... to avoid CrAsHiTiSe. ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 -Original Message- From: Neil H. [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 7:47 PM To: CF-Talk Subject: Registry size. I noticed my registry is getting huge (128 megs) and that I increased it to 160 megs for space sakes but are the entries in there that I can remove from CF not collecting garbage? Thanks, Neil ~~ 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: Session Timeout Override
Yes, i use a simple trick, a web site i worked on users had to stay logged in all day, what i did was create a hidden frame wich contained a colfusion page (small and simple) that would refresh every 10 minutes (where my session timout was 20 minutes) and hence keep the session alive as long as the browser was open Hope this helps.. Regards, Harvey -Original Message- From: Terra Durrant [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 12:41 AM To: CF-Talk Subject: Session Timeout Override Hello, We use a sessiontimeout for the logins to our Web site. For one particular web application we are developing, the user is going to need to be able to stay logged in to the Web site for a much longer amount of time than we currently are allowing. Is there a way to override the sessiontimeout for a particular section or even just a few pages of the Web site? Thanks! Terra ~~ 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: session variable storage
database definately, the registry should not be relied on to store session variables - it will only bloat it in size which will then affect the whole operating system - in the case where it get's to large it will end up crashing the system altogether which has happened to me only recently.. -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 1:46 AM To: CF-Talk Subject: session variable storage registry or database? which is better and why? ~~ 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: Escaping apostrophes
To insert an apostrophes you have to double it up hence INSERT INTO tblUserComments (userid, usercomment) VALUES (12345, 'I don''t know what to think') Will work as you want it to.. use the replace function.. -Original Message- From: andrew kopelman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 12:39 AM To: CF-Talk Subject: Escaping apostrophes Hello, This must be a basic question, but I found no real answer on the allaire forums. I want to allow users to enter apostrophes in text, which I then save to the database. However, the sql insert will fail as it interprets this apostrophe within the text as one of the apostrophes surrounding the text. Example: INSERT INTO tblUserComments (userid, usercomment) VALUES (12345, 'I don't know what to think') This fails on the ' in don't There must be a better solution than HTMLEditFormat. Thanks in advance. ~~ 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: Autopopulating text fields
I;ve done this before, when there is to much data to even think about using javascript array's i usually do an onchange="form.submit()" or onblur="form.submit()" and refresh the page with the required data -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 4:50 AM To: CF-Talk Subject: Autopopulating text fields How can I, or is it even possible to, automatically populate text fields in a form after one field is entered? In the past, I've done something similar using a drop-down list for the first value and populating the other fields based on the selection, but in this case my client needs to be able to enter text to trigger the event rather than selecting from a list. (Even if the drop-down list method was acceptable, there would be over 10,000 items to choose from, and my system hangs just trying to run the query.) This should be doable -- the idea is much like applications I've seen where entering a zipcode populates city and state fields on the fly, but I can't figure out any way to do it. Can anyone point me in the right direction? Thanks! MC ~~ 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: site modeling
Buy a good UML (Unified Modeling Language) book... UML is usefull to know as well as to put into practice - -Original Message- From: Jason Lotz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 8:53 AM To: CF-Talk Subject: Re: site modeling That's not what I meant...sorry for the confusion. I want a source that will explain the shapes, lines, etc. used to draw consistent models - not a software package used to make the models themselves. Jason - Original Message - From: "Dylan Bromby" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, March 26, 2001 3:26 PM Subject: RE: site modeling visio. -Original Message- From: Jason Lotz [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 2:12 PM To: CF-Talk Subject: site modeling Can anyone point me to a good resource for drawing site models on paper using consistent shapes, lines, etc? Everytime I sit down to do it, I make up different meaning for each shape and I'm looking for a consitent approach. 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: site modeling
"Sams Teach Yourself UML in 24 Hours" is a good one to start on... -Original Message- From: Braver, Ben [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 9:54 AM To: CF-Talk Subject: RE: site modeling So can you recommend a good UML book?? -Original Message----- From: Javier Woodhouse [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 3:53 PM To: CF-Talk Subject: RE: site modeling Buy a good UML (Unified Modeling Language) book... UML is usefull to know as well as to put into practice - -Original Message- From: Jason Lotz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 8:53 AM To: CF-Talk Subject: Re: site modeling That's not what I meant...sorry for the confusion. I want a source that will explain the shapes, lines, etc. used to draw consistent models - not a software package used to make the models themselves. Jason - Original Message - From: "Dylan Bromby" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, March 26, 2001 3:26 PM Subject: RE: site modeling visio. -Original Message- From: Jason Lotz [mailto:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 2:12 PM To: CF-Talk Subject: site modeling Can anyone point me to a good resource for drawing site models on paper using consistent shapes, lines, etc? Everytime I sit down to do it, I make up different meaning for each shape and I'm looking for a consitent approach. 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: Studio on Linux??
hating windows does not mean hating good UI... What most people dont like about windows is Microsofts bussiness tactics... Followed by the operating systems instability and security holes.. -Original Message- From: zac [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 10:44 AM To: CF-Talk Subject: Re: Studio on Linux?? Michael Rosario wrote: You may want to check out http://quanta.sourceforge.net/ Which begs the question: If Linux users hate Windows so much why do they clone windows apps and use the same UI conventions as Windows? -- Don't blame me. I voted for Kodos. email: [EMAIL PROTECTED] WWW: http://www.pixelgeek.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: Newbie question - query by month
I've used this before
WHERE dep_date BETWEEN #startDate# AND #endDate#
your start date should be the 1st (1-#month#-#year(now())#) of the month and
end date being the last of the month (31-#month#-#year(now())#)
-Original Message-
From: Francis, Jennifer [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 8:12 AM
To: CF-Talk
Subject: Newbie question - query by month
I have a date field (completedate) stored in my database. I
want to be able
to pull out all of the records by a selected month for a
month-end report.
Is there an easy way of doing this? I've tried
where datepart('m', completedate)='#month#'
but I keep getting an "invalid column name" error.
Any help would be MUCH appreciated...
Jennifer Francis
ATT Wireless
Training Development Design
[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: Textbox validation
Javascript handling of textarea inputs is shakey at best... i'd stick to CF -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 11:39 AM To: CF-Talk Subject: Textbox validation Hi, On one textbox I need to prohibit users entering more than one word - I don't want them to enter a space. What's the best way of doing this - Javascript, or Cold Fusion after the form has been posted? Thanks. Will -- [EMAIL PROTECTED] -=- www.lukrative.com Local-Advertising -=- www.localbounty.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: font viewers/printers
try thumbsplus (download.com) -Original Message- From: Terry Bader [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 10:15 AM To: CF-Talk Subject: OT: font viewers/printers I'm looking for a good font reviewer and printer shareware/freeware everything I have found isn't all that basically I want to create I library of my fonts and I always forget which fonts have the extra symbols I'm looking for so, I'm looking for one that can print the alpha/num char and the associated symbol in that font library... Terry Bader IT/Web Specialist EDO Corp - Combat Systems (757) 424-1004 ext 361 - Work [EMAIL PROTECTED] (757)581-5981 - Mobile [EMAIL PROTECTED] icq: 5202487 aim: lv2bounce http://www.cs.odu.edu/~bader ~~ 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: Setting up Dev Mapping w/ RDS
Set up your development mappings; Check your help files on how to do this If you think logically about this it makes sense, studio opens up the file via RDS. For browsing it uses MS-Internet Explorer modules to process the page, these modules dont understand RDS and so the mappings tell studio to use a particular URL for a particular RDS directory. Regards, Javier Woodhouse -Original Message- From: Gil Barden [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 15, 2001 4:38 PM To: CF-Talk Subject: Setting up Dev Mapping w/ RDS Hi everyone, I have created a RDS mapping several times before to use with the data resource window. The problem is that I open up a file in RDS then choose to browse it. I get prompted to set up a RDS mapping. So I do so, but then it doesn't like it? Am I wrong in thinking that you can't use the internal browser to view .cfm pages that are opened up via RDS. I could have sworn I have used this before and had it work? Thanks, Gil Barden ~~ 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
