javascript and document questions
To all, I imagine this is simple but my brain quit after a 14 hr saturday and I had two problems to resolve. The first question is: I have a dynamic table filled by a query that includes a check box. The check box value is keyed to a database entry. using the 'onclick' attribute I need to call an update query in a cf template. The quetion is how to write the javascript function to call 'qryBoxUpdate.cfm'? The second question is: On an intranet, no outside connection, using a dynamic link to a document or spreadsheet brings up the document in a browser or view window. I want the original application to open the file for editing. Where or how can that be specified? Thanks in advance for the comments. Richard ~~ 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: CyberCash Bankruptcy
you might try http://www.verza.com They have no sign up fee or monthly fee, they accept a wide range of plastic, and checks. you can change/add products as desired. possible negatives. they direct deposit to your bank account only twice a month and transactions fees may be slightly higher. Richard Kern -Original Message- From: Shawnea Carter [mailto:[EMAIL PROTECTED]] Sent: Monday, March 05, 2001 12:58 PM To: CF-Talk Subject: CyberCash Bankruptcy http://finance.individual.com/display_news.asp?doc_id=PR20010302DCF008&page= news Needless to say we have some new clients who are less than eager to pay the $500 to a company that may not be around - and we also need to have some backup plans in place for our existing CyberCash dependant clients. Does anyone have any 'Real-world' experience with any of the other cc transaction vendors? TIA Shawnea Carter VP Client Services Internet4Associations Certified Allaire Developer ~~ 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 syntax for contol characters
Thanks, works beautifully. Richard -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Friday, February 09, 2001 5:47 AM To: CF-Talk Subject: RE: SQL syntax for contol characters > I have inherited an access db upsized to SQL7 that has some nasty column > names, obviously won't ouput in CF without an alias. However is formating > the SQL statement using a single quote returns the literal string > within the > quote and using a backtick to set it off generates an error in CF. So how > does one specify the target column name for an alias? > > ex > > SELECT `home phone` AS PHONE > FROM EMPLOYEE > or > SELECT `TBR@40` AS TBR > FROM EMPLOYEE > produce a syntax error and > > SELECT 'home phone' AS PHONE > FROM EMPLOYEE > > produces 'home phone' in the field instead of the number Use square brackets, otherwise it's a string... SELECT [home phone] as Phone 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 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL syntax for contol characters
A question for you. I have inherited an access db upsized to SQL7 that has some nasty column names, obviously won't ouput in CF without an alias. However is formating the SQL statement using a single quote returns the literal string within the quote and using a backtick to set it off generates an error in CF. So how does one specify the target column name for an alias? ex SELECT `home phone` AS PHONE FROM EMPLOYEE or SELECT `TBR@40` AS TBR FROM EMPLOYEE produce a syntax error and SELECT 'home phone' AS PHONE FROM EMPLOYEE produces 'home phone' in the field instead of the number Thanks Richard kern ~~ 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: hal's wireframe
correct. It is meant to define what the client wants in terms of functionality and movement. done in conjuction with HTML and DevNotes you have a package you can freeze as a prototype deliverable. Richard -Original Message- From: Jason Egan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 2:00 PM To: CF-Talk Subject: hal's wireframe I've just been looking at Hal's wireframe - this is for development correct? This isn't intended for use in the actual application right? je ~~ 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: book review request
Have it but after a quick perusal it seems to be a description dairy from a program managers view of how the project went and what was implemented. Not much on the how or the coding. Doesn't rate high enough to read at this time. Richard -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 8:05 PM To: CF-Talk Subject: book review request Anyone got a personal review of the baok Business Intelligence with Coldfusion Is it worth buying? Thanks, Sebastian ~~ 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: The BETA IS OUT!!!
where? all I find on the beta page is a note saying the cycle begins 2/2/2001 Richard Kern -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 01, 2001 12:05 PM To: CF-Talk Subject: RE: The BETA IS OUT!!! > The Beta for 5.0 is available!!! You'll want to be careful with it - it is significantly different in many ways from prior releases, and you may have installation problems. Don't put in on a machine you're using for any development work. Also, there's no Advanced Security in it, so you can't run Spectra on it, for those who care. Also, when I installed it, I had an odd problem with RDS failing to find a file, and I had to mark the service as disabled, shut down, and restart. There's some interesting stuff in there, though, such as a bundled install of JRun, significant changes to ClusterCATS, and some facilities for backing up server configurations. Also, you can pass arbitrary ODBC connection strings directly to the database now. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ 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
CF_embedfields interesting problem
To all, overthe weekend I stumbled onto a problem created by using CF_embedfields to pass information to an update query. Previously all variables were passed via hidden input fields and the database was updated correctly. Rewrote to spread the input form over 4 pages using CF_embed fields. Worked fine except that it would not pick up CFID (which was assigned to a hidden input tag) and a generated password (lastname plus a random number, also a hidden input tag). Appears that those two variables would be passed by reference only, I ended up generating them on the last page and then passing to the update query. Do you have an explanation or comment on this behavior? Thanks Richard Kern ~~ 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: Where's the output?
A couple of ideas a. Browser choice, use IE over NN during the testing process. NN is less forgiving of html structure errors for output. The blank screen is the clue for me here. b. use the validation tool in studio to check for any gross error c. drop back to a known working model d. Take a walk and let it roll around in your head for a while :) Cheers Richard Kern -Original Message- From: Todd Ashworth [mailto:[EMAIL PROTECTED]] Sent: Friday, January 05, 2001 10:08 AM To: CF-Talk Subject: Where's the output? OK .. this one has me completely baffled. I was working on a custom tag. I had been loading it up in a browser every so often to take a look at it. A few minutes ago, I added a tag and a bunch of for some new comments. Now, the page won't load. Well, it loads, but there is absolutely 0 output. I commented out the new , I wrapped the whole page in s, and I commented out the tags. It's like the file is empty, but I know it's not because I've opened and closed it several times. Does anyone have any ideas? Todd Ashworth ~~ 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
Access DB Locking - Flushing
This may have been answered by now but here my 2c worth. The bad query route has never worked for me. Comments last year on this board lead to recognition that the .ldb file is the culprit and the only way to get rid of that is to flush the DB connection. This works both locally and remotely, be aware that ALL connections to the DB are flushed so any users will be inconvenienced. Then rename the old DB and upload the new one before a new connection is made. Working Code follows, I put this page on my sites specifically for this purpose Richard Kern -- DB Connection Flush #cfusion_dbconnections_flush()# DB flushed!! this also works ~~ 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: LOCKING revisited...Test Results
Gentlemen, I have completed a series of tests on locking in CF and share with you my findings. You may find the results surprising and I make several conclusions as a result of the test. If you would like a copy of the CF page, database, or summary spreadsheet mail me off list and I'll send them to you. i know the experiment can be improved on. I only ran 3 iterations for each test but the number of variations cost the better part of a day. Thanks to my company for the slack time. If nothing else this will be the starting point for additional work. Richard Kern --- Summary of lock testing on CF Server A. Conclusions The overall results of the test are instructive on four counts. First the method of locking whether on the server or actual page does not significantly affect the application performance. Second the scope of the locking does not significantly affect the application performance Third, the only approach to catching all shared variables that need to be locked is either by manual coding or specifically applying ALL THREE OPTIONS in CFAS at the FULL CHECK OR AUTO READ level. LESS THAN THIS ALLOWS SOME SHARED VARS TO RUN UNLOCKED. Fourth, the locking approach makes no difference statistically. Therefore it should be accepted that the approach is a matter of individual preference. The concern should be for complete coverage either through page coding or server settings if you have access to them. B. Results Graphing the mean values of the results shows that there is some discernable difference between the methods of locking. However, the std deviation between the tests shows a low variability, lending credence to the server performance despite the small sample size. An F-Test confirms this, none of the approaches are statistically significantly different. Using a test of DF 2,2, .10 = 9.00 , none of the F values come anywhere near this, the highest calculated value is .95 and that is the exception. The graphs show that the CFSA individual scope settings are slightly faster than the baseline of no locks at all on the production server. Applying all CFSA scope settings produces times equivalent to the baseline on the production server and longer on the local machine. C. Setup Run date: 21 Dec 00. CF Server is 4.5.1 on NT server 4.0 SP5. Two servers involved - local machine and production server on LAN (light traffic). Single page submitted to server with 1000 iteration loop on database query. CF page has three session variables and one database query. Three runs for each approach were done and recorded. CF Lock applied to page using 4.5 syntax to specify scope, no name Time reported in milliseconds as reported through CF debugging. Time includes server overhead for parsing, startup and shutdown. Server useage approaches 80% during the processing of the page, no other traffic as shown on CF Perf Mon. D. Data See excel 2000 spreadsheet file. - CFLocktest.xls ~~ 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
CF 5.0/studio wish list
Damon, addional items for CF 5.0. specifically Studio - dock/undock of file pages. Allows multiple pages open on the same screen, resizable and able to grab the tab at the botom to move file to a new position in the lineup. Thanks Richard Kern ~~ 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: LOCKING revisited...
OK gentlemen, I've done some research and modifiy my earlier post as follows: You can expect that a user's browser is hitting you with 4 simultaneous threads, AOL uses 2, and the CFSserver is handling these concurrently because it is mult-threaded. It is very possible that requests to shared memory variables can and will collide. The result is a hang or corruption of the variable. Using the CFLock tag will make sure that access to all variables is single threaded, this does enable the que as mentioned. This was the approach befor CF4.5. In 4.5 you have changes both to the use of the lock tag and CF administrator. If using CFA, setting single threaded sessions applies only to session variables, you still have to address server and application variables separately. This also incurs a perfomance hit if your session variables are not secured with the CFLOCK tag. In CFA, automatic read locking CHECKS whether shared variable scope writes are locked and AUTOMATICALLY locks shared variabel scope reads. If variable scope writes are not locked, an error is thrown. This option does incur a performance hit but saves writing CFLOCKS around the variables. The important change that we seem to be missing is that the syntax is changed in 4.5. The scope setting can take the value of either application, server or session and will automatically lock the shared variables at the correct level. There is also a migration wizard that will scan your files and convert them to the new syntax. Conclusion. all locking efforts (tag or CFA) will manage those simultaneous requests so they are single threaded for the duration of that call. You do incur a performance hit with any form of locking, the automatic locking through CFA requires more processing to check the variables whereas the explicit declaration is immediately processed. Without locking you will suffer greater grief than any performance hit incurred by locking. Peter's approach is valid for him and the approach as first addressed in the initial msg of this thread also appears valid, mostly dependent on your coding style. With the changes in 4.5 I suspect that Allaire is opening the door to streamling the code writing, which causes some rethinking of the established ways of coding. I infer this from the lack of emphasis in speed in the Allaire documentation but 100% agreement that locking is necessary for shared variables and database access. BTW the basis for most of the above came from KB article 14165. Richard Kern No offense, but that is nonsense. My Cold Fusion server is still multi-threaded and multi-processed. It is still handling every incoming request at the same time. The only time it will act "single threaded" is when two requests attempt to read an Application scope variable at the same time. And guess what? That is exactly the same thing that will happen if you DONT use automatic read locking, but properly use around your Application variables. Automatic read locking doesn't lock the entire page request, (which would be single threading the entire server). It locks read access around those variables that need it. This is not just an academic issue for me. I have a site running with 10-100 reads from an Application structure on every page. To make the code more readable, I am using automatic read locking for Application scope variables instead of #Application.myvar# tens or hundreds of times on each page. On a related note, if I have automatic read locking enabled for Application scope and I assign a local Variable to an Application variable, it will essentially make a copy to the pointer. Is CF smart enough then to automatically lock accesses to this local Variables, which is pointing into Application space? < !--- automatic read locking is ON for Application variables ---> < cfset myvar = Application.bigvar> < cfoutput> #myvar# < !--- <<<=== IS THIS AUTOMATICALLY LOCKED?? ---> At 02:13 PM 12/19/00 -0700, Richard Kern wrote: >It was expressed before that turning this on via the server will essentially >drop your application to single thread mode, slowing down all responses from >the system. Remember that CF is server side so doing this is like knocking >on the door and opening it for each request and then closing it before >anyone else enters, no matter how many people are queued at the door. > >- > >Ok, given that we all agree: > >** Access to shared variables should *ALWAYS* be locked ** > >Then why on Earth shouldn't I just turn on Automatic Read Locking for >Application (and Session et al if I use them) scope and only worry about >write locking in my code? > >Why doesn't everyone do that, with the rare exception of some code that has >unusual locking needs. > >I've heard the argument that automatic read l
RE: LOCKING revisited...
It was expressed before that turning this on via the server will essentially drop your application to single thread mode, slowing down all responses from the system. Remember that CF is server side so doing this is like knocking on the door and opening it for each request and then closing it before anyone else enters, no matter how many people are queued at the door. Richard Kern -Original Message- From: Peter Theobald [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 19, 2000 1:16 PM To: CF-Talk Subject: LOCKING revisited... Ok, given that we all agree: ** Access to shared variables should *ALWAYS* be locked ** Then why on Earth shouldn't I just turn on Automatic Read Locking for Application (and Session et al if I use them) scope and only worry about write locking in my code? Why doesn't everyone do that, with the rare exception of some code that has unusual locking needs. I've heard the argument that automatic read locking is a slight performance hit. It couldn't be more of a hit than parsing around every access and still doing the read lock anyway! --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 x204 Fax 1.212.545.0938 To put this contact information into your Palm device, click here: http://www.coola.com/cgi-bin/addinfo.cgi?pid=15803&rid=972879910&type=A ~~ 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/JRun Studio
yes, it caused me to do a complete reinstall of CFStudio and stop using JRUN Studio. Very frustrating since I need CFS on a daily basis, that effectively means no JRUN on my daily work machine. Richard Kern -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Friday, December 08, 2000 9:47 PM To: CF-Talk Subject: CF/JRun Studio Has a JRun Studio install hosed anyone else's CF Studio? ~~ 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 4.5.1 - Setup Question
options,settings, html gets you a switch to turn lower case on for tags. Otherwise it's as you type. Richard -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 07, 2000 6:51 AM To: CF-Talk Subject: Studio 4.5.1 - Setup Question Hello, I just installed Studio 4.5.1 (finally upgraded from 3.1). In 3.1 there was an option to upper case the tags when you inserted them. I have searched for two days now, and have been unable to locate this switch in 4.5.1. Does it offer that option? And if so, can someone tell me where it is? Thanks, Dave = "What we need is a list of specific unknown problems we will encounter" David Hannum Web Analyst/Programmer Ohio University [EMAIL PROTECTED] (740) 597-2524 ~~ 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 Random?
suggest using the tag CF_queryrandomize in the allaire gallery Richard Kern -Original Message- From: Craig M. Rosenblum [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 07, 2000 1:24 PM To: CF-Talk Subject: Order By Random? Is there any way to have a query give the results in random order? This is for Oracle... ~~ 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: variables passed en masse - what is the tag? ANSWER
Thanks to all who replied, the tag I was looking for is CF_embedfields Richard ~~ 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
FW: variables passed en masse - what is the tag?
I remember several replies to a previous question where a tag was referenced that gathered all the variables on a form and passed them to subsequent pages what was that tag - I hope I'm not dreaming but it would help to replace hidden fields. Thanks Richard Kern ~~ 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
variables passed en masse - what is the tag?
I remember several replies to a previous question where a tag was referenced that gathered all the variables on a form and passed them to subsequent pages what was that tag - I hope I'm not dreaming but it would help to replace hidden fields. Thanks Richard Kern ~~ 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: Big companies using CF
Don't forget www.ebags.com first large fusebox application Richard Kern ~~ 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_Calendar
I've used and bought the tag code for CF_bucalendar. Mark Bureau was very pleasant and willing to work with us. He has recently changed the interface and we got a version that allows for multiple users on one database Richard Kern RSA Companies -Original Message- From: Jeanne Sarfaty Glazer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 29, 2000 1:47 PM To: CF-Talk Subject: CF_Calendar Has anyone on the list used the CF_Calendar tag created by this company? http://www.iautomated.com/products.cfm If so, I would greatly appreciate your feedback - esp. with regard to its administrative ability. On the front end, it looks like a nifty app - (one minor bug I've seen is that, sometimes you have to double click a month for it to display properly) and I'm interested to know how (and how well) the back end works before I plunk down the $ to purchase it. Thanks a bunch, - - - Jeanne ~~ 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 ~~ 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
cfGRID VARIABLE BEING LOST
To the group, Strange behavior on the server has just occured. The cfgrid was working and now is not. It works in studio but when transferred to the server the action page can't find the variable for the cfgrid name. Debug info follows. Any idea as to what might be happening? Note that the form variables are filled in when running locally in studio Thanks Richard Form Fields: server variable result: __CFGRID__CFFORM_1__LOGINADMIN2= FIELDNAMES=SUBMIT,__CFGRID__CFFORM_1__LOGINADMIN2 LOGINADMIN2= SUBMIT=Submit This Change local variable result: __CFGRID__CFFORM_1__LOGINADMIN2=__CFGRID__EDIT__=5IDYNAMEYPASSYCOMPAN YNAMEYUSERNAMEY1U1010bbbbcc FIELDNAMES=SUBMIT,__CFGRID__CFFORM_1__LOGINADMIN2 LOGINADMIN2.COMPANYNAME[1]=cc LOGINADMIN2.ID[1]=10 LOGINADMIN2.NAME[1]=bb LOGINADMIN2.ORIGINAL.COMPANYNAME[1]= LOGINADMIN2.ORIGINAL.ID[1]=10 LOGINADMIN2.ORIGINAL.NAME[1]=bb LOGINADMIN2.ORIGINAL.PASS[1]= LOGINADMIN2.ORIGINAL.USERNAME[1]= LOGINADMIN2.PASS[1]= LOGINADMIN2.ROWSTATUS.ACTION[1]=U LOGINADMIN2.USERNAME[1]= SUBMIT=Submit This Change 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: Certified ColdFusion Developers
FWTW, CCD also means Charge Coupled Device we could go on from there but I think I like the full def better Richard Kern -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 15, 2000 8:09 AM To: CF-Talk Subject: Certified ColdFusion Developers Just out of curiosity... since I notice that most of us who passed the Certification have adjusted their Sigs to say "Certified ColdFusion Developer", wouldn't it be easier to use an abbreviation? I know that most of my customers wouldn't know what that meant if it came up and bit them, also they ignore most things after the name (such as PhD) Philip Arnold (CCD, maybe?) 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. ** 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: Certified ColdFusion Developers
FWTW, CCD also means Charge Coupled Device we could go on from there but I think I like the full def better Richard Kern -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 15, 2000 9:40 AM To: CF-Talk Subject: Re: Certified ColdFusion Developers CERF ;-) At 03:09 PM 11/15/00 +, you wrote: >Just out of curiosity... since I notice that most of us who passed the >Certification have adjusted their Sigs to say "Certified ColdFusion >Developer", wouldn't it be easier to use an abbreviation? > >I know that most of my customers wouldn't know what that meant if it came up >and bit them, also they ignore most things after the name (such as PhD) > >Philip Arnold (CCD, maybe?) >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. >** > > > >--- - >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]
RE: CF editing software - vote
look here and use the email link to register, no charge but times out in Jan 2001 http://beta.allaire.com -Original Message- From: Auction Hard Drive [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 09, 2000 9:09 AM To: CF-Talk Subject: RE: CF editing software - vote Where can I get the 4.5.2 beta? Is it a free upgrade to those with CF4.5? Rich -Original Message- From: Richard Kern [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 09, 2000 10:40 AM To: CF-Talk Subject: RE: CF editing software - vote CF studio 4.5.2 beta here. I like the virtual and physical directories, project organization, codesweeper works if you validate first still working with the RDS functions to get them to work The color coding is invaluable to help spot errors once you start depending on it Like it better than First page but first page does have a lot of built in javascript functions that make it worthwhile. I highly recommend it to anyone who is starting out without the $ for studio. -Original Message- From: Eron Cohen [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 09, 2000 7:48 AM To: CF-Talk Subject: RE: CF editing software - vote Hi Will, I use CF Studio, and its features are terrific. They have a new patch version coming out soon which will improve quite a few areas of that software. >From a ColdFusion user's standpoint, I'd have to say the next most likely software I'd use would be Eversoft's 1st Page. It is remarkably similar to ColdFusion Studio, but it is F R E E. (I still haven't figured out what their business model is supposed to be--comments about this anyone?) Its got quite a few ColdFusion centric features. It is aware of ColdFusion tags, and actually has a few features I wish they'd get into studio. One thing it doesn't have that I would miss if I switched is RDS. As flakey as RDS has been in the past, I couldn't do without it. If you wish to try 1st Page, you can download it from their website. To get to the download, follow the link below: http://www.evrsoft.com/download Its about a 5meg download. -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 09, 2000 7:57 AM To: CF-Talk Subject: CF editing software - vote Hi, I thought it would be interesting to see who's using what to develop their CF apps. I'm using HomeSite 4.5 happily here. Anyone? Cheers Will 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] __ Do You Yahoo!? Thousands of Stores. Millions of Products. All in one Place. http://shopping.yahoo.com/ 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] 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: CF editing software - vote
CF studio 4.5.2 beta here. I like the virtual and physical directories, project organization, codesweeper works if you validate first still working with the RDS functions to get them to work The color coding is invaluable to help spot errors once you start depending on it Like it better than First page but first page does have a lot of built in javascript functions that make it worthwhile. I highly recommend it to anyone who is starting out without the $ for studio. -Original Message- From: Eron Cohen [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 09, 2000 7:48 AM To: CF-Talk Subject: RE: CF editing software - vote Hi Will, I use CF Studio, and its features are terrific. They have a new patch version coming out soon which will improve quite a few areas of that software. >From a ColdFusion user's standpoint, I'd have to say the next most likely software I'd use would be Eversoft's 1st Page. It is remarkably similar to ColdFusion Studio, but it is F R E E. (I still haven't figured out what their business model is supposed to be--comments about this anyone?) Its got quite a few ColdFusion centric features. It is aware of ColdFusion tags, and actually has a few features I wish they'd get into studio. One thing it doesn't have that I would miss if I switched is RDS. As flakey as RDS has been in the past, I couldn't do without it. If you wish to try 1st Page, you can download it from their website. To get to the download, follow the link below: http://www.evrsoft.com/download Its about a 5meg download. -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 09, 2000 7:57 AM To: CF-Talk Subject: CF editing software - vote Hi, I thought it would be interesting to see who's using what to develop their CF apps. I'm using HomeSite 4.5 happily here. Anyone? Cheers Will 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] __ Do You Yahoo!? Thousands of Stores. Millions of Products. All in one Place. http://shopping.yahoo.com/ 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: CFHEADER
This may be what you are looking for button to logout -- --logout action form You are logged out -- response with humor after the logout process-- SELECT elapsedtime,userID FROM uservariables WHERE (pass = '#session.pass#') You are no longer logged into the site. You must log on to do any more study. Thanks, CDWMVTSHPUSA Colorado Division of Web Management for Virtual Traffic School, High Plains of United States of America The result is that the user cannot go back into the site because the application.cfm and index.cfm pages are checking for the logged in value. I also clear the cache through meta entries so that the user has no access that way. Richard Kern -Original Message- From: Dylan Bromby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 01, 2000 2:00 PM To: CF-Talk Subject: Re: CFHEADER This didn't work. Has anyone done this? Again - I want to allow users to logout. If they then use the BACK feature in their browser, I don't want them to be able to see the page they logged out from. --Dylan 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: Multiple file filters for CFDIRECTORY
I am interested in the tag but more in your thought process and approach (as a matter of learning how you approach this for a java solution. Defining classes, etc). Thanks, Richard -Original Message- From: JustinMacCarthy [mailto:[EMAIL PROTECTED]] Sent: Friday, October 13, 2000 3:58 AM To: CF-Talk Subject: Re: Multiple file filters for CFDIRECTORY No but I'm in the middle of writting a Java CFX to do this.. send me a mail if you want to test it... Justin MacCarthy - Original Message - From: "Aidan Whitehall" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, October 13, 2000 10:59 AM Subject: Multiple file filters for CFDIRECTORY > Is there any way doing this... > > ACTION="LIST" >DIRECTORY="C:\somedir\" >FILTER="*.rsp,*.req" >NAME="DirectoryListing" >SORT="DATELASTMODIFIED DESC"> > > so you can get a listing of all .rsp and .req files in a directory? > > This returns no results, BTW. > > > -- > Aidan Whitehall <[EMAIL PROTECTED]> > Netshopper UK Ltd > Advanced Web Solutions & Services > > http://www.netshopperuk.com/ > Telephone +44 (01744) 648650 > Fax +44 (01744) 648651 > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > > -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Multiple file filters for CFDIRECTORY
Wanted to do the same thing, final workaround was to use a new cfdirectory for each desired file type, then the display shows each group. Not elegant but it does get the info. Richard -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: Friday, October 13, 2000 3:59 AM To: CF-Talk Subject: Multiple file filters for CFDIRECTORY Is there any way doing this... so you can get a listing of all .rsp and .req files in a directory? This returns no results, BTW. -- Aidan Whitehall <[EMAIL PROTECTED]> Netshopper UK Ltd Advanced Web Solutions & Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Using MS Access with Cold Fusion (no no)
Ryan, This is exactly the scenario oft quoted to emphasize locking the DB during a read or write query. Was that part of the code in this instance? Thanks Richard -Original Message- From: Ryan [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 12, 2000 4:05 PM To: CF-Talk Subject: Re: Using MS Access with Cold Fusion (no no) At 17:14 10/12/00 -0400, you wrote: > >Are you speaking from experience or just from what Allaire officially recommends? I have done load testing with a banner app that uses an Access database. It runs fine until you hit it with more than one request at the exact same time. Then it blows up. I've also had problems adding more banners to this banner ap when we had more than a hundred or so banners in it. Problem is the source is encrypted so I could not even see what the author was doing. What makes access work ok on your sites is that even if you have 3 requests per second, as long as each of those requests only take a fraction of a second, they probably will never collide. But when two requests hit the DB at the same time, it blows up. Its not a multiuser database! This banner app used an Access97 db, too. 2000 may work better. I'm glad you have all had such success with it. RPS -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Wheel reinvention?
David, regarding the reports. Those will have to be duplicated via html and queries. Having done that, it can be quite time consuming to get the report(s)to work like they do in access and look the same way.Usually the client isn't too happy with other solutions (I like what I've got). So be prepared to explain that a fair amount of time will be involved to duplicate what he now has. This may me a springboard to justify some other reporting solutions that could be acceptable. Richard -Original Message- From: David [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 10, 2000 11:41 PM To: CF-Talk Subject: Re: Wheel reinvention? Thanks so much for the advise. Any recommedation on reporting software though? Anyone has experience on such? Thank you and regards David - Original Message - From: "pan" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, October 11, 2000 12:15 PM Subject: Re: Wheel reinvention? > From: "Dave Watts" <[EMAIL PROTECTED]> > > > > > I have a customer who likes to web-enable his Access > > > database. The database has over 50+ queries and 100+ > > > reports. He doesnt want anything extra, just web-enable > > > it. Could anyone advise what is the best way to do it > > > and maintain it in Access? > > > > > > Do I have to recode the queries in CF? ... > > > > You can call Access queries, including Access parameter queries, from CF > > using the CFSTOREDPROC tag. There's a writeup of this from the DC CFUG: > > > > http://www.figleaf.com/figleafhome/cfug/CFUGfeb99.zip > > > > You don't need to use cfstoredproc to call a pass through query. > Just call the query name as though it were a table. > > What that article listed above is more about is using cfstoredproc to call > parameter queries against Access. The author doesn't mention pass through > with just > select > from query > > > > Pan > > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Problem with CFFTP
ANDY, This is now a current question for me. How were you able to resolve it? Thanks, Richard -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 22, 2000 4:56 AM To: CFTalk (E-mail) Subject: Problem with CFFTP I have a problem with CFFTP. I am trying to use CFFTP to download a file onto a user hard drive. When the user clicks a button the web site creates a file using CFFILE and then tries to download it to C:\temp using CFFTP. However all it is doing is saving it to C:\Temp on the web server! Here is my code Open Error Code: #cfftp.errorcode# Open Error Text: #cfftp.errortext# Download Error Code: #cfftp.errorcode# Download Error Text: #cfftp.errortext# Both FTP operations succeed. Anyone have any ideas? -- Andrew Ewings Project Manager Thoughtbubble Ltd -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Undeliverable: RE: [RE: CGI Referrer variable]
yes, but not on a regular basis RK -Original Message- From: Chapman, Katrina [mailto:[EMAIL PROTECTED]] Sent: Monday, October 09, 2000 5:07 PM To: CF-Talk Subject: FW: Undeliverable: RE: [RE: CGI Referrer variable] Is anyone else getting these messages about 30 seconds before the message shows up on the list? --K > -Original Message- > From: System Administrator [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 09, 2000 4:01 PM > To: [EMAIL PROTECTED] > Subject: Undeliverable: RE: [RE: CGI Referrer variable] > > > Your message > > To: CF-Talk > Subject: RE: [RE: CGI Referrer variable] > Sent:Mon, 9 Oct 2000 18:59:48 -0400 > > did not reach the following recipient(s): > > CF-Talk on Mon, 9 Oct 2000 19:00:57 -0400 > The recipient name is not recognized > The MTS-ID of the original message is: c=US;a= > ;p=TAMPA;l=MOJO00100923004SNJTYCH > MSEXCH:IMS:TAMPA:MOJO:MOJO 0 (000C05A6) Unknown Recipient > > > - Message-ID: <[EMAIL PROTECTED]> From: "Chapman, Katrina" <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Subject: RE: [RE: CGI Referrer variable] Date: Mon, 9 Oct 2000 15:59:48 -0700 X-Mailer: Internet Mail Service (5.5.2650.21) Yes. --K > -Original Message- > From: Jared Clinton [mailto:[EMAIL PROTECTED]] > Sent: Monday, October 09, 2000 4:58 PM > To: CF-Talk > Subject: RE: [RE: CGI Referrer variable] > > > Does anybody know if it is possible for > > CGI.REMOTE_ADDR > > or > > CGI.REMOTE_HOST > > to be supplied with fake values? > > Thanks in advance, Jared Clinton. > > > -Original Message- > > From: JL [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, October 10, 2000 8:52 AM > > To: CF-Talk > > Subject: Re: [RE: CGI Referrer variable] > > > > > > do you guys check this cgi.http_referer to see whether it's > > the correct ip? > > > > J > > > > [EMAIL PROTECTED] wrote: > > > > > > I was wondering how long someone would take to bring it up. > > > > > > Yep, it's mis-spelled. The person writing the standard > > mis-spelled it and > > > it became a standard before it was caught... or so the > > story goes. So > > we're > > > stuck with it. > > > > > > --Doug > > > > > > -Original Message- > > > From: Warrick, Mark [mailto:[EMAIL PROTECTED]] > > > Sent: Monday, October 09, 2000 2:41 PM > > > To: CF-Talk > > > Subject: RE: CGI Referrer variable > > > > > > > > > Interestingly enough, that variable name is spelled incorrectly. > > > > > > It is HTTP_REFERER. > > > > > > More variables like it can be found in the docs: > > > > > > > > cfdocs/Developing_Web_Applications_with_ColdFusion/03_Creating > > _and_Manipulat > > > ing_Variables/dwa03_12.htm > > > > > > ---mark > > > > > > -- > > > Mark Warrick > > > Phone: (714) 547-5386 > > > Efax.com Fax: (801) 730-7289 > > > Personal Email: [EMAIL PROTECTED] > > > Personal URL: http://www.warrick.net > > > Business Email: [EMAIL PROTECTED] > > > Business URL: http://www.fusioneers.com > > > ICQ: 346566 > > > -- > > > > > > > > > > -Original Message- > > > > From: Brian bouldernet [mailto:[EMAIL PROTECTED]] > > > > Sent: Monday, October 09, 2000 12:47 PM > > > > To: CF-Talk > > > > Subject: CGI Referrer variable > > > > > > > > > > > > Does anyone know the variable name for refferer? I forgot > > ofhand... > > > > > > > > Thnaks, > > > > Brian > > > > > > > > > -- > > > > > > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > > > To Unsubscribe visit > > > > > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf > > > > _talk or send a message to > [EMAIL PROTECTED] with > > > > 'unsubscribe' in the body. > > > > > > > > -- > > -- > > > -- > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > > To Unsubscribe visit > > > > > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list > s/cf_talk or > > send a message to [EMAIL PROTECTED] with > 'unsubscribe' in > > the body. > > > -- > -- > -- > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list s/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Get free email and a permanent address at http://www.netaddress.com/?N=1 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EM
RE: Between???
Rich,
That's half the answer. The other half is to use the CreatODBCDate()
function on your form. Then when it is passed to the action form it will be
posted to the access db is the correct format. Any existing entries (passed
in without going through this function) will have to be redone so they are
in the ODBC format before your query will work. That's a pain to do but I'm
not aware of other solutions for existing entries.
But you might consider that a change in the DB structure to a text field
would then give an opportunity to compare strings and select on them.
Richard
-Original Message-
From: HappyToad.com [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 9:01 AM
To: CF-Talk
Subject: RE: Between???
The order_date field in my database is already set to: Date()
Is this what you mean??
Rich
-Original Message-
From: Bob Silverberg [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 10:31 AM
To: CF-Talk
Subject: RE: Between???
The problem is that the format you are using (MM,DD,) is not valid for
the database. CF might like that syntax to describe a date, but the SQL
engine won't recognize it. Check out the CreateODBCDate() function - use it
to convert your date into SQL friendly format.
Bob
-Original Message-
From: HappyToad.com [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 10:28 AM
To: CF-Talk
Subject: Between???
I have set up a form to enter the dates which has the following query on the
form action page:
SELECT order_id FROM orders
WHERE order_date BETWEEN ('#from_month#','#from_day#','#from_year#')
AND ('#to_month#','#to_day#','#to_year#')
Why doesn't this work?
Rich
-Original Message-
From: John Allred [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 10:10 AM
To: CF-Talk
Subject: Displaying CF code
I have some CF templates on an intranet for which I'd like to display the
code in the user's browser. I find myself without my printed manuals, and I
can't seem to find what I'm looking for in the online help.
Can someone recommend a method I can use to include and transform the code
from a CF template in another template and have it display but not execute?
I fear I'm not making this very clear. What I want to do is have my main
template, that is including a file based on a CFSWITCH on a variable,
either include a file and execute it or pull that same file in and display
the code only by replacing the left brackets with < .
TIA,
--John
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: cfdirectory listing,
Thanks David, Number 2 worked well combined with several 'or's in an if stmt. Richard -Original Message- From: Hayes, David [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 03, 2000 7:51 AM To: CF-Talk Subject: RE: cfdirectory listing, A few ideas: 1) Make a list of the filenames to exclude, then check for listContains(,getFile.name) EQ 0; 2) See if RIGHT(getFile.name,4) EQ ".cfm"; 3) Use Regular expressions to validate the filenames. -Original Message- From: Richard Kern [mailto:[EMAIL PROTECTED]] Sent: Monday, October 02, 2000 4:10 PM To: CF-Talk Subject: cfdirectory listing, I am looking for some direction, here is the problem The page allows the user to select the directory and a specific file to delete. I want to exclude specific groups of file like *.cfm from the listing ( not using the filter on cfdirectory). The approach so far is to use cfif but it is limited to specific files and I have a lot of file with similiar extensions. So how do I restrict the cfdirectory or cfif or do I need to use another approach? #Name# Thanks, Richard -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Code Sweeper Disaster!
Before running code sweeper, always run the validator. That way the code is at least compliant with the settings you choose in setup. If you have broken tags, codesweeper is a disaster but it works well if your code is first run with the validator. Cheers Richard Kern -Original Message- From: Claremont, Timothy S [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 03, 2000 7:26 AM To: CF-Talk Subject: Code Sweeper Disaster! On a whim, I ran code sweeper on a 200 line cfm file. I think there is a reason they call it code sweeper. It swept most of my code right into the dumpster. The biggest problem was the way it rearranged my code. Code Sweeper rearranged most of my variable assignments into illegal statements. I admit, Code Sweeper warned me that changes were irreversible. Is Code Sweeper really just a test for those programmers that LOVE exterminating bugs??? Tim Claremont Xerox Corporation -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CFGRID - How to block the editing of 1 column
yes, just set the cfgridcolumn select property to 'no', see the previous posting yesterday to the subject editing data with CFGRID Cheers Richard Kern -Original Message- From: Michael Gagnon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 03, 2000 8:15 AM To: CF-Talk Subject: CFGRID - How to block the editing of 1 column Hi! Is there a way to block the editing of only 1 column (ID)? I want the others to be editable. TIA! __ Michael Gagnon -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
FW: dynamic form
-Original Message- From: Richard Kern Sent: Monday, October 02, 2000 3:35 PM To: '[EMAIL PROTECTED]' Subject: RE: dynamic form Your action page will have access to the form variables, as last populated. However the reference should be #form.emp_name# not as you stated Richard -Original Message- From: Gavin Myers [mailto:[EMAIL PROTECTED]] Sent: Monday, October 02, 2000 1:31 PM To: CF-Talk Subject: dynamic form this is buggin' me okay, lets say the database consists of: emp_name roy joe billy gus cf_code (simplified) select * from names Who woule you like to fire? #emp_name# NoYes In order for this to work i have to specify a name so my radio buttons will work. In order to give my radio buttons a name i have to give them a dynamic name (like #emp_name#) so when i go to my next page, how do i call those dynamic set feild names? like #form.#emp_name##? know what i mean? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
FW: Editing data with CFGRID
-Original Message- From: Richard Kern Sent: Monday, October 02, 2000 3:16 PM To: '[EMAIL PROTECTED]' Subject: RE: Editing data with CFGRID you are missing several items, look at this example attached from a working site note the select mode, grid colum for each column and action page --- that's the input form, now for the action form --- SELECT * FROM user_login Good luck Richard Kern -Original Message- From: Michael Gagnon [mailto:[EMAIL PROTECTED]] Sent: Monday, October 02, 2000 11:59 AM To: CF-Talk Subject: Editing data with CFGRID Hi! I created a spreadsheet style grid with CFGRID (my first time) and I don't seem to be able to edit the information in the table. What am I doing wrong? Thanks! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
FW: cfdirectory listing,
> -Original Message- > From: Richard Kern > Sent: Monday, October 02, 2000 3:10 PM > To: '[EMAIL PROTECTED]' > Subject: cfdirectory listing, > > > I am looking for some direction, here is the problem > > The page allows the user to select the directory and a specific file to > delete. I want to exclude specific groups of file like *.cfm from the > listing ( not using the filter on cfdirectory). The approach so far is to > use cfif but it is limited to specific files and I have a lot of file with > similiar extensions. > > So how do I restrict the cfdirectory or cfif or do I need to use another > approach? > > > DIRECTORY="#walkdir#" > NAME="getFile"> > > > >(Name NEQ 'index.cfm') and (Name NEQ '*.cfm')> >HREF="#CGI.SCRIPT_NAME#?Path=#WalkPath#\#Name#">#Name# > > > Thanks, > Richard -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: dynamic form
Your action page will have access to the form variables, as last populated. However the reference should be #form.emp_name# not as you stated Richard -Original Message- From: Gavin Myers [mailto:[EMAIL PROTECTED]] Sent: Monday, October 02, 2000 1:31 PM To: CF-Talk Subject: dynamic form this is buggin' me okay, lets say the database consists of: emp_name roy joe billy gus cf_code (simplified) select * from names Who woule you like to fire? #emp_name# NoYes In order for this to work i have to specify a name so my radio buttons will work. In order to give my radio buttons a name i have to give them a dynamic name (like #emp_name#) so when i go to my next page, how do i call those dynamic set feild names? like #form.#emp_name##? know what i mean? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Editing data with CFGRID
you are missing several items, look at this example attached from a working site note the select mode, grid colum for each column and action page --- that's the input form, now for the action form --- SELECT * FROM user_login Good luck Richard Kern -Original Message- From: Michael Gagnon [mailto:[EMAIL PROTECTED]] Sent: Monday, October 02, 2000 11:59 AM To: CF-Talk Subject: Editing data with CFGRID Hi! I created a spreadsheet style grid with CFGRID (my first time) and I don't seem to be able to edit the information in the table. What am I doing wrong? Thanks! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
cfdirectory listing,
I am looking for some direction, here is the problem The page allows the user to select the directory and a specific file to delete. I want to exclude specific groups of file like *.cfm from the listing ( not using the filter on cfdirectory). The approach so far is to use cfif but it is limited to specific files and I have a lot of file with similiar extensions. So how do I restrict the cfdirectory or cfif or do I need to use another approach? #Name# Thanks, Richard -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
SQL help
I'm sending this attempt w/o attachements. The CF code is inline after
signature. No DB.
Here is one possible solution. It uses a noncorrelated inner query and a
union.
I built a simple access db like you diagrammed (attached)
query and output are contained in .cfm page (attached)
output is as desired returning 2 rows. Those of active status plus the news
for the year 2000 active status (news replaces the 'other' field when
available).
Does this resolve the question?
Richard
_ begin cf code
SELECT area,status,other
FROM Table1 T
WHERE '2000' IN
(SELECTyear
FROM Table2
WHERE T.ID = ID)
UNION
SELECT area,year,news
FROM Table2
WHERE Table2.year = '2000'
DB Trial
Area
Status/year
Other/NEWS for the active
#news.Area#
#news.Status#
#news.Other#
end cf code
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 25, 2000 11:57 AM
To: CF-Talk
Subject: Re: SQL Help
Richard,
Thank you for your help. Maybe if I give a much simpler example, you'll
get an idea of what I'm after.
TABLE1 (Areas) TABLE2(AreaNews)
==
Area Status(OtherStuff) Area Year News
-
co01 ACTIVExx co01 1998 x
co01 1999 xxx
co01 2000 xx
co02 INACTIVE xx co02 1997 xx
co02 1998 x
co03 ACTIVE co03 1998 xxx
co03 1999
So, in the above example, TABLE1 has 3 records, TABLE2 has 8 records, I
want (in english): "All the active areas, along with any news for the
year 2000". The query should return 2 rows, only the first of which
would have news for 2000. Note that I'm selecting some other fields
from TABLE1, but just News from TABLE2.
Thanks,
Jim
-Original Message-
From: Richard Kern <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Date: Monday, September 25, 2000 11:12 AM
Subject: RE: SQL Help
>The post is not entirely clear, You imply wanting 682 records (all A
'along
>with "news"')
>but specify only 593. Selecting only 'actives' in A will get 593 as
you
>desire. But, I will
>consider that you want records from A and B that meet your criteria.
In
>that case 89 records
>meet 'active' and 'year = 2000'. So the query apparently works.
However if
>you want 682 (
>all A and those in B that meet the criteria) look at a 'union'.
>
>select_statement
>WHERE
>UNION
>select_statement
>WHERE
>ORDER BY (only one order clause allowed)
>
>
>(quick review of some SQL)
>1. an outer join shows the join plus all the records that did not
>qualify from the first named table in your join specification.
>
>
>2. A right join will do the same for the records in the second table.
>
>3. non matching rows in either table can also be specified from either
>table (left or right join)
>
>4. a union combines data from multiple queries into one display and by
>default
>removes duplicates (but check your documentation) UNION ALL will will
>include
>the duplicates
>
>5. depending on your SQl implementation the join may be specified in
the
>WHERE (rather than the FROM) clause using
>*= (include all rows from first table) or =* (include all rows in
second
>table)
>
>
>-Original Message-
>From: Jim McAtee [mailto:[EMAIL PROTECTED]]
>Sent: Sunday, September 24, 2000 4:10 PM
>To: CF-Talk
>Subject: SQL Help
>
>
>Try it again, with a subject this time...
>
>Can't figure out why the following query behaves like it does, but
>I'm guessing there must be something fundamental about how SQL
>operates that I'm not comprehending.
>
>I've got a one:many relationship between table A and table B. Table
>B records represent "new for year" for a given record in
>table A. For example, there can be 0 or 1 "new for 2000" record in
>table B for one record in table A. I've got about 650 records in
>table A, with 593 of them with a status of 'ACTIVE'. In table B,
>there are about 1000 records, and exactly 89 are for the year 2000.
>
>Table A:
>areacode varchar(5)
>status varchar(10)
>...
>
>Table B:
>areacode varchar(5)
>year smallint
>new varchar(255)
>
>I want to return all of the records in A, along with the "news" for
>the year 2000, from table B. I shou
Re: SQL Help - 3rd attempt to post
I'm sending this attempt w/o attachements. The CF code is inline after
signature. No DB.
Here is one possible solution. It uses a noncorrelated inner query and a
union.
I built a simple access db like you diagrammed (attached)
query and output are contained in .cfm page (attached)
output is as desired returning 2 rows. Those of active status plus the news
for the year 2000 active status (news replaces the 'other' field when
available).
Does this resolve the question?
Richard
_ begin cf code
SELECT area,status,other
FROM Table1 T
WHERE '2000' IN
(SELECTyear
FROM Table2
WHERE T.ID = ID)
UNION
SELECT area,year,news
FROM Table2
WHERE Table2.year = '2000'
DB Trial
Area
Status/year
Other/NEWS for the active
#news.Area#
#news.Status#
#news.Other#
end cf code
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 25, 2000 11:57 AM
To: CF-Talk
Subject: Re: SQL Help
Richard,
Thank you for your help. Maybe if I give a much simpler example, you'll
get an idea of what I'm after.
TABLE1 (Areas) TABLE2(AreaNews)
==
Area Status(OtherStuff) Area Year News
-
co01 ACTIVExx co01 1998 x
co01 1999 xxx
co01 2000 xx
co02 INACTIVE xx co02 1997 xx
co02 1998 x
co03 ACTIVE co03 1998 xxx
co03 1999
So, in the above example, TABLE1 has 3 records, TABLE2 has 8 records, I
want (in english): "All the active areas, along with any news for the
year 2000". The query should return 2 rows, only the first of which
would have news for 2000. Note that I'm selecting some other fields
from TABLE1, but just News from TABLE2.
Thanks,
Jim
-Original Message-
From: Richard Kern <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Date: Monday, September 25, 2000 11:12 AM
Subject: RE: SQL Help
>The post is not entirely clear, You imply wanting 682 records (all A
'along
>with "news"')
>but specify only 593. Selecting only 'actives' in A will get 593 as
you
>desire. But, I will
>consider that you want records from A and B that meet your criteria.
In
>that case 89 records
>meet 'active' and 'year = 2000'. So the query apparently works.
However if
>you want 682 (
>all A and those in B that meet the criteria) look at a 'union'.
>
>select_statement
>WHERE
>UNION
>select_statement
>WHERE
>ORDER BY (only one order clause allowed)
>
>
>(quick review of some SQL)
>1. an outer join shows the join plus all the records that did not
>qualify from the first named table in your join specification.
>
>
>2. A right join will do the same for the records in the second table.
>
>3. non matching rows in either table can also be specified from either
>table (left or right join)
>
>4. a union combines data from multiple queries into one display and by
>default
>removes duplicates (but check your documentation) UNION ALL will will
>include
>the duplicates
>
>5. depending on your SQl implementation the join may be specified in
the
>WHERE (rather than the FROM) clause using
>*= (include all rows from first table) or =* (include all rows in
second
>table)
>
>
>-Original Message-
>From: Jim McAtee [mailto:[EMAIL PROTECTED]]
>Sent: Sunday, September 24, 2000 4:10 PM
>To: CF-Talk
>Subject: SQL Help
>
>
>Try it again, with a subject this time...
>
>Can't figure out why the following query behaves like it does, but
>I'm guessing there must be something fundamental about how SQL
>operates that I'm not comprehending.
>
>I've got a one:many relationship between table A and table B. Table
>B records represent "new for year" for a given record in
>table A. For example, there can be 0 or 1 "new for 2000" record in
>table B for one record in table A. I've got about 650 records in
>table A, with 593 of them with a status of 'ACTIVE'. In table B,
>there are about 1000 records, and exactly 89 are for the year 2000.
>
>Table A:
>areacode varchar(5)
>status varchar(10)
>...
>
>Table B:
>areacode varchar(5)
>year smallint
>new varchar(255)
>
>I want to return all of the records in A, along with the "news" for
>the year 2000, from table B. I shou
RE: another hosting question
don't use cheaphosting.com. They're only supporting CF2.0 Richard -Original Message- From: Simon Horwith [mailto:[EMAIL PROTECTED]] Sent: Monday, September 25, 2000 10:55 AM To: CF-Talk Subject: RE: another hosting question I recommend halfpricehosting for cheap hosting with CF support. Tell them simon sent you :) ~Simon -Original Message- From: Juan Andres Alvarez Valenzuela [mailto:[EMAIL PROTECTED]] Sent: Monday, September 25, 2000 12:50 PM To: CF-Talk Subject: another hosting question can Anyone recommend me a cheap CF hosting (for personal use :) ? I was looking in Dantor.com the basic plan (U$ 5) but I dont know if its a good hosting... (they request my credit card without secure connection) thanks in advance, Juandres -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL Help
The post is not entirely clear, You imply wanting 682 records (all A 'along with "news"') but specify only 593. Selecting only 'actives' in A will get 593 as you desire. But, I will consider that you want records from A and B that meet your criteria. In that case 89 records meet 'active' and 'year = 2000'. So the query apparently works. However if you want 682 ( all A and those in B that meet the criteria) look at a 'union'. select_statement WHERE UNION select_statement WHERE ORDER BY (only one order clause allowed) (quick review of some SQL) 1. an outer join shows the join plus all the records that did not qualify from the first named table in your join specification. 2. A right join will do the same for the records in the second table. 3. non matching rows in either table can also be specified from either table (left or right join) 4. a union combines data from multiple queries into one display and by default removes duplicates (but check your documentation) UNION ALL will will include the duplicates 5. depending on your SQl implementation the join may be specified in the WHERE (rather than the FROM) clause using *= (include all rows from first table) or =* (include all rows in second table) -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 24, 2000 4:10 PM To: CF-Talk Subject: SQL Help Try it again, with a subject this time... Can't figure out why the following query behaves like it does, but I'm guessing there must be something fundamental about how SQL operates that I'm not comprehending. I've got a one:many relationship between table A and table B. Table B records represent "new for year" for a given record in table A. For example, there can be 0 or 1 "new for 2000" record in table B for one record in table A. I've got about 650 records in table A, with 593 of them with a status of 'ACTIVE'. In table B, there are about 1000 records, and exactly 89 are for the year 2000. Table A: areacode varchar(5) status varchar(10) ... Table B: areacode varchar(5) year smallint new varchar(255) I want to return all of the records in A, along with the "news" for the year 2000, from table B. I should get 593 records. Since table B only has year 2000 records for 89 of the records in table A, I think I need to do a left outer join. SELECT A.*, B.new FROM A LEFT JOIN B ON A.areacode = B.areacode WHERE A.status = 'ACTIVE' AND B.year = 2000 I get only 89 records returned, and the query appears to behave exactly like an an inner join. I suspect it has something to do with my WHERE clause that defines conditions on both of the tables, but I can't see another way to do this. Thanks for any assistance, Jim -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Money for Nothing & Chicks for Free?
Hear, Hear, good comments and rationale. Oh, and we mustn't forget good 'feelings' to for those who place more value there. It sounds like you have the background to do the coding and it would be a challenge to set up an infrastructure to support it. Yea, I'm interested. That would be competition comming in from the far reaches of the galaxy (ie totally unexpected). Let's talk offline if you want to pursue it further. Richard -Original Message- From: Rick Osborne (Mojo) [mailto:[EMAIL PROTECTED]] Sent: Monday, September 25, 2000 6:52 AM To: CF-Talk Cc: [EMAIL PROTECTED]; 'Peter Theobald'; 'Hoffman, Joe (CIT)' Subject: RE: Money for Nothing & Chicks for Free? Someone going by the nym "Hydra" said: >I continue to be mystified by these kinds of discussions. Would >someone take a moment to explain this phenomenon? Kindly. >If someone really writes a "FreeCF" and the Allaire Corp. goes >down the tubes, then will we really all be better off? What what? Who said anything about Allaire going down the tubes? Who said anything about trying to put Allaire out of business? Certainly not me. I happen to *like* CF. While I'm glad that my employer has to pay for it (and Studio) and not me, I certainly don't want Allaire to go away any time soon. >When all software is OpenSource, free, etc. then how do >developers make a living? You know, it's funny you asked this. I was just having this discussion with a friend of mine last night down at IHOP. (Mmmm, blueberry blintzes. Num.) We came to the conclusion that our society is trained to think that things that you don't pay for have no value. Sad. Very sad. Let me educate you a bit on how the majority of the free software (note the lack of capitalization) industry works. When someone writes a chunk of code and gives it away (for free), it normally goes with an understanding that it is actually *unsupported*. You can have it for free, and use it for free, but don't come whining to me if it breaks. Let's take the most prominant example: Linux. Most versions of Linux are available for download at no cost. The Red Hat distribution is probably the most popular (last time I checked) and you can download it from their web site. However, and this is the catch, if you don't pay for it then it is unsupported. Where does Red Hat make their money? Support contracts. I, as a single user, have no problem with running an unsupported copy of Red Hat Linux at home. My employer, like most other companies, is a bit hazy on the whole unsupported thing. So, they are willing to shell out the cash just for the peace of mind in knowing that if they are needed, somewhere operators are standing by. Have you ever seen how much Microsoft charges for support? It's obscene. The $1K for the OS is trvial by comparison. Support is where the money is. Even with a FreeCF, Allaire would still be around. Why? Companies like having people they can point the finger at when something goes wrong. Getting back on topic ... Peter Teobald said: >If the original poster is really serious about writing a FreeCF, >why doesn't he make better use of his valuable time and join the >PHP project? I can think of a couple of my personal motivations: 1. Because it's there. (read: because I'm a coder geek and it sounds like fun to me) 2. Because if I want to run CF at my house so I can mess around with it off-hours, I don't want to have to shell out $5K of my own money. 3. Because it'd be nice to point out a bug in CF to Allaire and then say "the FreeCF folks had it fixed in a week, what's your deal?". (read: competition is highly motivating) 4. Because it would then open the door for companies who could make a living at supporting FreeCF. (By giving away software you'd be creating jobs? Yep. Cool, huh?) 5. Because maybe, just maybe, it'd get to the point where FreeCF was actually more useful to me than CF. 6. Really cool bragging rights. Why not PHP or Mozilla or something? I did Mozilla. (Look at the list of names of people who've submitted code. I'm in there.) PHP just doesn't interest me. It's a rhetorical question, but what makes PHP a more valuable project than a FreeCF? Joe Hoffman writes: >>Allaire gets how many thousand dollars per copy of CF? >You say that as if maybe there is something wrong with that. Didn't mean to sound like I think that there is anything *inherently* wrong with it. I do think $5K is a bit outrageous, but there are more than enough arguments about that one. Definitely don't want to start one here. :) >It's the basis of a capitalist, free market economy. You >work, you make the money ... not the motherland. Oh, definitely. I'm a capitalist-pig-dog like any other red-blooded American. :) However ... >From what I understand from your post ... you want an independent solution Precisely. I want competition. Remember that money is only half of capitalism - competition is the other half. ;) (By the way, I'm quite amused to see
RE: missing files from book
Try installing the CD and you will find that at least the book database is misisng. Other forums indicated files in plural, that's the issue. So far I have not been able to track the author's current location. Another CFer (joe Hoffman) on this list supplied the book database in a reply here and said he didn't know of any other missing files. That'a the current status. Richard -Original Message- From: Chris Montgomery [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 24, 2000 12:01 AM To: CF-Talk Subject: RE: missing files from book Richard, I have the book and still unsealed CD in the back of it. But what do you mean by missing files? Maybe if you came up with a list of files you need I can help. Chris Montgomery [EMAIL PROTECTED] Web Development & Consulting http://www.astutia.com Allaire Consulting Partner & NetObjects Reseller 210-490-3249/888-745-7603Fax 210-490-4692 >-----Original Message- >From: Richard Kern [mailto:[EMAIL PROTECTED]] >Sent: Friday, September 22, 2000 11:24 AM >To: CF-Talk >Subject: missing files from book > > >Does anyone have the files missing from the book >CF3.0 Intranet Application Development Toolkit by JR Desborough? > >If so, would you share them with me? > >Thanks, > >RIchard Kern > -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
missing files from book
Does anyone have the files missing from the book CF3.0 Intranet Application Development Toolkit by JR Desborough? If so, would you share them with me? Thanks, RIchard Kern -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: AOL and interactive sites [CF-Talk]
Thanks for the input. I've added the previous 'paranoid' section to my pages and it didn't seem to make a whole lot of difference. I'll try this one in the application.cfm file. But it does raise a new question im my mind. Given that the CFserver will process the application.cfm file - this solution uses CFHEADER, is the response given back to the requester an html response or an http response. In otherwords will the requestor see the header and resppond to it, does CF send something else back? Enlightenment? Thanks RIchard -Original Message- From: Nick McClure [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 20, 2000 4:45 PM To: CF-Talk Subject: RE: AOL and interactive sites [CF-Talk] That one never would work correctly. I found what I was talking about: > >HTH >Ben > > > -Original Message- > > From: Nick McClure [SMTP:[EMAIL PROTECTED]] > > Sent: Wednesday, September 20, 2000 3:29 PM > > To: [EMAIL PROTECTED] > > Subject: Re: AOL and interactive sites [CF-Talk] > > > > sometime the problem with AOL is the way it caches everything it finds. > > > > using the cfheader tag you can manually expire the cache. > > > > I cannot remember the exact syntax but it can be done. > > > > At 03:59 PM 9/20/2000 -0600, you wrote: > > >All, > > > > > >I have an paid interactive site, all CF with database queries and tests, > > it > > >seems that people using AOL keep getting bumped off, and other glitches > > seem > > >to happen. Enough that it causes extreme frustration. Even then the > > >customer won't move to a regular ISP. The question is what is that AOL > > does > > >in their world that causes so much grief in mine? Any insight? Is this > > >resolveable? Are AOL and CF incompatible? > > > > > >Thanks, > > > > > >Richard > > >- > > - > > >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > >To Unsubscribe visit > > >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk > > or > > >send a message to [EMAIL PROTECTED] with 'unsubscribe' in > > > > >the body. > > > > -- > > Nick McClure [EMAIL PROTECTED] > > Technical Director859.245.9656 > > squareFish Media www.squareFish.com > > > > -- > > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > To Unsubscribe visit > > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > > the body. >--- --- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. -- Nick McClure[EMAIL PROTECTED] Technical Director 859.245.9656 squareFish Mediawww.squareFish.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
AOL and CF sites [CF-Talk]
All, I have an paid interactive site, all CF with database queries and tests, it seems that people using AOL keep getting bumped off, and other glitches seem to happen. Enough that it causes extreme frustration. Even then the customer won't move to a regular ISP. The question is what is that AOL does in their world that causes so much grief in mine? Any insight? Is this resolveable? Are AOL and CF incompatible? Thanks, Richard -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
AOL and interactive sites [CF-Talk]
All, I have an paid interactive site, all CF with database queries and tests, it seems that people using AOL keep getting bumped off, and other glitches seem to happen. Enough that it causes extreme frustration. Even then the customer won't move to a regular ISP. The question is what is that AOL does in their world that causes so much grief in mine? Any insight? Is this resolveable? Are AOL and CF incompatible? Thanks, Richard -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
FW: [CF-Talk] Re: NAMED.BOOT
-Original Message- From: Richard Kern Sent: Tuesday, September 19, 2000 3:42 PM To: '[EMAIL PROTECTED]' Subject: RE: [CF-Talk] Re: NAMED.BOOT This may or maynot be applicablae but I'm including a section of code that is dynamically structured as you mentioned. In order for it to work you have to have an index.cfm in the lowest directory for it to return a listing and the server must default to index.cfm in its pages. __ Contact Us Click on a directory for contents #Name# ___ -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 19, 2000 11:39 AM To: [EMAIL PROTECTED] Subject: Re: [CF-Talk] Re: NAMED.BOOT That's exactly what I wanted to do, but I may not be able to (it's not up to me..) hence why I was looking for another solution. Out of interest, I wonder how you would go about to solve that previous problem. I spent a good hour on it but couldn't see how it'd work - anyone else bored enough to join in my fun? Will - Original Message - From: "lsellers" <[EMAIL PROTECTED]> Newsgroups: cf-talk Sent: Tuesday, September 19, 2000 5:59 PM Subject: RE: [CF-Talk] Re: NAMED.BOOT > > OK - I have a table of domain names, which I've populated a Select with. > > Fine. But I would like to run a check as follows: > > > > > > > > ...which would exclude those domains in the Select. Any ideas? > > Well, generally I just keep a field in the database table that lets me know > which ones have been updated. AFTER I'd (re)create thier dns files I'd > unflag it. This simply lets me do a select on those fields. > > Ie, select * from mumble where needsupdate=true. > > And simply just overwrite everything. :) > > This allows you to cfschedule it to run as a batch process (or to manual > force the operation if you want). > > --min > > > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: [CF-Talk] Re: NAMED.BOOT
This may or maynot be applicablae but I'm including a section of code that is dynamically structured as you mentioned. In order for it to work you have to have an index.cfm in the lowest directory for it to return a listing and the server must default to index.cfm in its pages. __ Contact Us Click on a directory for contents #Name# ___ -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 19, 2000 11:39 AM To: [EMAIL PROTECTED] Subject: Re: [CF-Talk] Re: NAMED.BOOT That's exactly what I wanted to do, but I may not be able to (it's not up to me..) hence why I was looking for another solution. Out of interest, I wonder how you would go about to solve that previous problem. I spent a good hour on it but couldn't see how it'd work - anyone else bored enough to join in my fun? Will - Original Message - From: "lsellers" <[EMAIL PROTECTED]> Newsgroups: cf-talk Sent: Tuesday, September 19, 2000 5:59 PM Subject: RE: [CF-Talk] Re: NAMED.BOOT > > OK - I have a table of domain names, which I've populated a Select with. > > Fine. But I would like to run a check as follows: > > > > > > > > ...which would exclude those domains in the Select. Any ideas? > > Well, generally I just keep a field in the database table that lets me know > which ones have been updated. AFTER I'd (re)create thier dns files I'd > unflag it. This simply lets me do a select on those fields. > > Ie, select * from mumble where needsupdate=true. > > And simply just overwrite everything. :) > > This allows you to cfschedule it to run as a batch process (or to manual > force the operation if you want). > > --min > > > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: JS to CF variable
The solution to passing the variable was to enclosed the input type tag in a set of output tags. Thanks to Shane Pitts for the insight. Richard -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: JS to CF variable
The CFSCRIPT approach almost works -
Script output is
dir = #walkdir#;
WriteOutput(dir);
This writes the current value to the current screen - good
This does not pass the value to the input field as #dir# - bad
Therefore no passing to the next page. The problem is probably due to
CFSCRIPT being executed on the server just like CF vs JS on the client.
Other suggestions?
RIchard
-Original Message-
From: Mike Connolly [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 15, 2000 8:17 AM
To: '[EMAIL PROTECTED]'
Subject: RE: JS to CF variable
Try using instead of
This will allow you to access CF variables in your script.
> -Original Message-
> From: Richard Kern [SMTP:[EMAIL PROTECTED]]
> Sent: 15 September 2000 15:11
> To: [EMAIL PROTECTED]
> Subject: JS to CF variable
>
>
> I have a #url.path# variable that is dynamically populated. At the end
> of
> the users selection I need to pass that value to a CFFILE tag as a
> destination directory. Given that this occurs on the page before being
> passed to the server, JS makes sense here to collect it on the first page
> and convert it to a form variable.
>
> I have tried the following to no avail and would appreciate some insight
> as
> to how to do it.
>
> Thanks
>
> Richard Kern
>
> --
> <SCRIPT LANGUAGE="JavaScript"
> TYPE="text/javascript">
> <!--
>function set_path()
> {document.forms[0].dir.value = "#url.path#"}
>
> //-->
>
>
> called at
>NAME="Submit"
> VALUE="Press to upload"
> onsubmit="set_path();">
>
> 2nd page - this produces no output
>
>
> #FORM.DIR#
> --
>
>
>
>
> --
> --
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
>
> --
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
---
Any opinions expressed in this message are those of the individual and not
necessarily the company. This message and any files transmitted with it are
confidential and solely for the use of the intended recipient. If you are
not the intended recipient or the person responsible for delivering to the
intended recipient, be advised that you have received this message in error
and that any use is strictly prohibited.
Sapphire Technologies Ltd
http://www.sapphire.net
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
JS to CF variable
I have a #url.path# variable that is dynamically populated. At the end of
the users selection I need to pass that value to a CFFILE tag as a
destination directory. Given that this occurs on the page before being
passed to the server, JS makes sense here to collect it on the first page
and convert it to a form variable.
I have tried the following to no avail and would appreciate some insight as
to how to do it.
Thanks
Richard Kern
--
<!--
function set_path()
{document.forms[0].dir.value = "#url.path#"}
//-->
called at
2nd page - this produces no output
#FORM.DIR#
--
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
passing a dynamic variable
I have a #url.path# variable that is dynamically populated. At the end of
the users selection I need to pass that value to a CFFILE tag as a
destination directory. Given that this occurs on the page before being
passed to the server, JS makes sense here to collect it on the first page
and convert it to a form variable.
I have tried the following to no avail and would appreciate some insight as
to how to do it.
Thanks
Richard Kern
--
<!--
function set_path()
{document.forms[0].dir.value = "#url.path#"}
//-->
called at
2nd page - this produces no output
#FORM.DIR#
--
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Populating more than one Select
Jumping into the pool, I hope this is relevant Type mismatches mean that the structure of the DB is different for the two tables. One may be text and the other a number, or with different properties that don't allow one of the fields to be matched upward in the hierarchy of precision. Go back to the table definitions and check each field against the other field Richard -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 14, 2000 10:16 AM To: [EMAIL PROTECTED] Subject: Re: Populating more than one Select Found solution to previous problem WHERE c.cat_id = s.cat_id It should be c.ID as there is no such field as cat_id in categories. However; this too produces an error: [Microsoft][ODBC Microsoft Access Driver] Type mismatch in expression. What on earth does that mean? Will - Original Message - From: "Bud" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 14, 2000 4:12 PM Subject: Re: Populating more than one Select > On 9/14/00, W Luke penned: > > > > SELECT ID, cat_id, cat_name, sub_name FROM categories, sub_categories > > ORDER by cat_name > > > > Try: > > SELECT ID, cat_id, cat_name, sub_name > FROM categories c, sub_categories s > WHERE c.cat_id = s.cat_id > ORDER by cat_name > > > > > >> QUERY="findcats" > > NAME1="Cat" > > NAME2="Selected" > > DISPLAY1="cat_name" > > DISPLAY2="sub_name" > > VALUE1="cat_id" > > VALUE2="sub_name" > > Just curious. Wouldn't you want value2 to be sub_id. It should work > if you change the query though. And I presume you remembered to put > name="MyOtherForm" in the form header. > -- > > Bud Schneehagen - Tropical Web Creations > > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ > ColdFusion Solutions / eCommerce Development > [EMAIL PROTECTED] > http://www.twcreations.com/ > 954.721.3452 > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
cfselect and variable passing
I thought this was simple but I keep running into a brick wall and my eyes are getting bruised I need to pass the result from a select box to other input fields on the same page and then to a subsequent form. DTS VTS Your hours are #hours# current action page: the selected value is --- prolem: not reading the value corresponding to the select choice to the cfset doesn't execute and no value is passed to the action page. Comments would be appreciated - I know I'm missing something obvious, thanks Richard -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
cfselect and variable passing
I thought this was simple but I keep running into a brick wall and my eyes are getting bruised I need to pass the result from a select box to other input fields on the same page and then to a subsequent form. DTS VTS Your hours are #hours# current action page: the selected value is --- prolem: not reading the value corresponding to the select choice to the cfset doesn't execute and no value is passed to the action page. Comments would be appreciated - I know I'm missing something obvious, thanks Richard -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Hah! I'm an idiot!
I used a verity search but moved out the directories I didn't want searched, replaced them later and now that collection forms the basis of my search page Ricahrd Kern Web Developer, RSAcompanies -Original Message- From: Olive, Christopher M Mr NMR [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 12, 2000 10:20 AM To: '[EMAIL PROTECTED]' Subject: RE: Hah! I'm an idiot! why not use a verity collection? Chris Olive, DOEHRS Website Administrator -Original Message- From: Gavin Myers [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 12, 2000 9:25 AM To: '[EMAIL PROTECTED]' Subject: Hah! I'm an idiot! So i'm the only cold fusion programmer here at work. And I'm designing the new site look, well one of the features they wanted was to be able to have a search box wich will search the site and return results. So, being the big dummy I am, I was like "hey no problem!" Now that I think about it, I have no idea on where to even begin. This is what they want: The website is about 60 pages, all of them CFM pages (even though some of them don't have any cold fusion code in them, I made them cfm on the sheer chance that i'd have to put something in them). The search box would search through those 60 pages and return the results that closest match what you were looking for in the manner of hyperlinks. Gah! Any suggestions would be greatly appreciated Gavin -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
