RE: How much can CF handle?
On a sturdy enough box, CF might handle the load, it depends on how complex the code is. MySQL *won't*. If you're really going to get that kind of traffic, don't mess around with the small-fry, go to Sybase, Oracle, or at least PostgreSQL. A dual P3 is not the most important issue, and in fact, Allaire specifically recommends NOT using an SMP Linux kernel until kernel 2.4 is released. Web serving is not processor-intensive, it's I/O intensive. With this type of load, a fast SCSI system is required, preferably 4+ high speed SCSI Ultra-Wide drives in RAID5 configuration. Michael J. Sheldon http://www.desertraven.com/ Make a fast friend, adopt a greyhound! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 23, 2000 22:52 To: [EMAIL PROTECTED] Subject: How much can CF handle? Hi, I am doing a proposal for a client ATM who has a web site that is currently getting about 6 page views per second in peak time. Do you think it will be possible to handle the load with a single CF/HTTP server running Linux and a separate DB server running MySQL? All images will be stored on an external server, so the only thing being processed by the CF box is the pages. It will probably be a fairly decent box, perhaps dual-P3, up to a gig of RAM, dual ethernet. I am writing the app to make a lot of use of cfincludes of dynamically-built static pages and liberal caching. Any suggestions are welcome. Rob Keniger -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Using COM with CF
Hi, I'm new to CF and am using version 4.5.1 of both Studio and Server. I have a COM object that returns a generated integer value. I can use this COM object in any COM enabled Windows app. However, when I try to use in a cfm page I get the following error: An error occurred while evaluating the expression: oASIWeb.SetDataPath("E:\InetPub\wwwroot\SolidData\Data"); oASIWeb.SetDatabase("sdweb"); RetVal = oASIWeb.NewID("USERS"); Error near line 4, column 4. The symbol you have provided (oASIWeb.SetDataPath) is not the name of a function. Built-in functions in ColdFusion have names with no qualifiers, i.e., no periods (.) in them. It appears that CF thinks I'm trying to run one of its functions. My CF code is as follows: CFOBJECT TYPE="COM" NAME="oASIWeb" CLASS="asiweb.asiweb" ACTION="CREATE" CFSCRIPT oASIWeb.SetDataPath("E:\InetPub\wwwroot\SolidData\Data"); oASIWeb.SetDatabase("sdweb"); RetVal = oASIWeb.NewID("USERS"); /CFSCRIPT CFOUTPUT#RetVal#/CFOUTPUT Am I missing something? Do I need to give the IUSR_MachineName account the proper security access? If yes, what? Thanks --Tom Tom Kim Advanced Systems Integration 949-261-5476 949-261-0426 Fax [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: How much can CF handle?
On Thu, 24 Aug 2000, Michael Sheldon spake thusly: On a sturdy enough box, CF might handle the load, it depends on how complex the code is. MySQL *won't*. If you're really going to get that kind of traffic, don't mess around with the small-fry, go to Sybase, Oracle, or at least PostgreSQL. A dual P3 is not the most important issue, and in fact, Allaire specifically recommends NOT using an SMP Linux kernel until kernel 2.4 is released. IMO: Unless you use a backport of the SMP code form 2.4, such as in the SuSE 6.4 and 7.0 kernel series' Works pretty much flawlessly -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Help Jon build a network! Looking for giveaway computers parts Current Need: Tape Drive PI/PII processors Email me to find out how you can help *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Mail Servers?
Interesting, I had exactly the opposite experience, I also found the user community (at the time) was very CF-like and helpful. One reason was, at the time I dl'd the demo product, their user support forums were on Allaire Forums - certainly not a good reason to endorse the product - just thought that rocked. They since switched to WebBoard -which I do not care for - but hey .. Stephen M. Aylor Aylor Insurance Agency, Inc. "Specialized insurance for Technology Risks" [EMAIL PROTECTED] 949.581.2333 voice 949.581.2814 fax I had some problems with mDaemon, and I sent an email to their support address. This would have been about 5 months ago now and I am still yet to hear anything from them. Sorry, but I thought I should share, as it soured my experience with an otherwise good candidate for a mail server. My earlier suggestion of Merak Mail from icewarp still stands, I have used support many times to suggest enhancements and fix problems, and in nearly every case have received immediate replies, and suggestions have been implemented in many cases. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Division in Cold Fusion?
I'm sure there's a nifty function that does exactly that for you - but without looking in the manual you could always do this: !--- Move the calculation over two decimal places, add .5 and truncate, then move it back --- cfset result = ( thisval / thatval * 100 + 0.5 ) \ 100 At 03:06 PM 8/23/00 -0400, Peter Benoit wrote: Thanks for all the help with this one. One final question would be, is there a way to round the results of this to say 2 decimal places? It's hard to find what you're looking for when you don't know what you're looking for! :) Thanks again, Pete * -Original Message- * From: Chapman, Katrina [mailto:[EMAIL PROTECTED]] * Sent: Wednesday, August 23, 2000 2:50 PM * To: [EMAIL PROTECTED] * Subject: RE: Division in Cold Fusion? * * * Just like you did but you're using the wrong slash it should be. * * CFSET MYVAL = thisval / thatval * * BTW you also don't need #'s in set's unless the variable * name is in ""'s. * * HTH, * --K * * -Original Message- * From: Peter Benoit [mailto:[EMAIL PROTECTED]] * Sent: Wednesday, August 23, 2000 11:33 AM * To: '[EMAIL PROTECTED]' * Subject: Division in Cold Fusion? * * * I must be looking at all the wrong stuff... but I want to * take 2 values and * divide them. * * like: * * cfset myval = #thisval# \ #thatval# * * Is there a correct way to do this? * * Thanks, * Pete * * - * --- * -- * Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ * To Unsubscribe visit * http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lis ts/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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 Fax 1.212.679.8032 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFSCRIPT question
I have the following as cfscript: if (not(structKeyExists(session.cart, attributes.name))) I would like to use it as a CFIF statement. Any ideas how to go about constructing said cfif? -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Help Jon build a network! Looking for giveaway computers parts Current Need: Tape Drive PI/PII processors Email me to find out how you can help *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Searching in results
Hi, folks I´m making a search engine for a web site and I´m having some problems, it would be great if someone could help me. I have to make searches in results of searches in the web site, and I can´t make them work. Is it posible to index the results of the searches in the web site? Here is the code: CFSEARCH name = "GetResults" collection = "portel" criteria = "#Form.Criteria#" maxRows = "#Evaluate(Form.MaxRows + 1)#" startRow = "#Form.StartRow#" cfloop query="GetResults" cfindex collection="resbusqueda" action="update" query="GetResults" type="FILE" key="#GetFileFromPath(Key)#" title="#Title#" urlpath="#urlEncodedFormat(Key)#" /cfloop I always get blank results in the next search that is bellow: CFSEARCH name = "GetResults" collection = "#Form.SearchCollection#" criteria = "#Form.Criteria#" maxRows = "#Evaluate(Form.MaxRows + 1)#" startRow = "#Form.StartRow#" and the values passed to this template are correct all of them. Please some one help. Thanks in advance. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
More on Cold Fusion vs. Java Servers: Performance
Ok. Everyone agrees Java servers kick its butt it seems! The question is though - by how much? How many Cold Fusion servers does it take to service the same number of users as one of those Java servers? 2? 3? If we're talking about numbers like that then that's not so bad considering CF costs easily half the price of say WeblogicAnd how well does JRun compare? Allaire is saying that JRun is going to be an integrated part of the next major Cold Fusion server release later this year. J - Original Message - From: "Peter Theobald" [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, August 23, 2000 10:25 AM Subject: RE: Cold Fusion vs. Java Servers: Performance html font size=3A related question: How does JRUN compare to ATG Dynamo and WebLogic?br br At 02:14 PM 8/22/00 -0700, Ed Toon wrote:br blockquote type=cite citeCold Fusion doesn't stand up to them. At all. I've watched a couple of sitesbr move from CF to ATG Dynamo and WebLogic, and the performance just can't bebr compared... they knock the socks off of CF. That isn't to say that CF can'tbr be used in high traffic sites - if you want to have a few dozen serversbr running. I personally love CF for intranets and other low trafficbr applications, betas, etc.. but it's just not in the same league as thosebr guys.br br As we move closer to JRun/CF integration it will start to compete though. ;)br br Edbr br -- br Archives: a href="http://www.mail-archive.com/cf-talk@houseoffusion.com/" eudora="autourl"http://www.mail-archive.com/cf-talk@houseoffusion.com//a br To Unsubscribe visit a href="http://www.houseoffusion.com/index.cfm?sidebar=listsamp;body=lists/cf _talk" eudora="autourl"http://www.houseoffusion.com/index.cfm?sidebar=listsamp;bo dy=lists/cf_talk/a or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. /font/blockquotebr br -font size=3- -br Peter Theobald, Chief Technology Officerbr LiquidStreaming a href="http://www.liquidstreaming.com/" eudora="autourl"http://www.liquidstreaming.com/abr [EMAIL PROTECTED]br Phone 1.212.545.1232 Fax 1.212.679.8032br /font/html -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Frames Dilemma
Now my question: should both queries be run in the mainframe.cfm file and then the results somehow passed to the frames where they are used (if this is even possible), or should the queries be run individually in the separate frames? Or since the frames share the results of the queries, do I need to run duplicate queries in each of the frames? I had a similar problem with frames where I wanted to display the column names as headers in one frame and the data in another frame. Because I didn't know in advance which columns were going to be selected, the only way I could get the table cells to line up correctly in both frames was to run the entire query in both frames. Very inefficient though. I thought maybe some time I would rewrite it to have just one .cfm run the query and pass the results to the browser using WDDX, then share the resulting arrays around the frames using Javascript. Haven't got around to it though... Is this a good idea? Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
checking for tables?
quick question: is there any way to check to see if a table exists without querying it, and throwing an error if it does not? I want to either CREATE or INSERT a table depending on whether or not it already exists -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Help Jon build a network! Looking for giveaway computers parts Current Need: Tape Drive PI/PII processors Email me to find out how you can help *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: checking for tables?
Yupif you are using SQL server the syntax is. IF EXISTS (SELECT * FROM sysobjects WHERE name = "tablename" AND type = "U") BEGIN PRINT "Table Exists!." END -Original Message- From: Jon Tillman [mailto:[EMAIL PROTECTED]] Sent: 24 August 2000 11:09 To: [EMAIL PROTECTED] Subject: checking for tables? quick question: is there any way to check to see if a table exists without querying it, and throwing an error if it does not? I want to either CREATE or INSERT a table depending on whether or not it already exists -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Help Jon build a network! Looking for giveaway computers parts Current Need: Tape Drive PI/PII processors Email me to find out how you can help *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: checking for tables?
You sir, are a hero, a true hero of the revolution On Thu, 24 Aug 2000, Andy Ewings spake thusly: Yupif you are using SQL server the syntax is. IF EXISTS (SELECT * FROM sysobjects WHERE name = "tablename" AND type = "U") BEGIN PRINT "Table Exists!." END -Original Message- From: Jon Tillman [mailto:[EMAIL PROTECTED]] Sent: 24 August 2000 11:09 To: [EMAIL PROTECTED] Subject: checking for tables? quick question: is there any way to check to see if a table exists without querying it, and throwing an error if it does not? I want to either CREATE or INSERT a table depending on whether or not it already exists -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Help Jon build a network! Looking for giveaway computers parts Current Need: Tape Drive PI/PII processors Email me to find out how you can help *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Help Jon build a network! Looking for giveaway computers parts Current Need: Tape Drive PI/PII processors Email me to find out how you can help *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: checking for tables?
Oh no, I spoke too soon: [Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'. Data Source = "health-horizons" SQL = "IF EXISTS(INSERT INTO 96961133 (productID, productQty) VALUES(54, 1);)" On Thu, 24 Aug 2000, Andy Ewings spake thusly: Yupif you are using SQL server the syntax is. IF EXISTS (SELECT * FROM sysobjects WHERE name = "tablename" AND type = "U") BEGIN PRINT "Table Exists!." END -Original Message- From: Jon Tillman [mailto:[EMAIL PROTECTED]] Sent: 24 August 2000 11:09 To: [EMAIL PROTECTED] Subject: checking for tables? quick question: is there any way to check to see if a table exists without querying it, and throwing an error if it does not? I want to either CREATE or INSERT a table depending on whether or not it already exists -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Help Jon build a network! Looking for giveaway computers parts Current Need: Tape Drive PI/PII processors Email me to find out how you can help *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Help Jon build a network! Looking for giveaway computers parts Current Need: Tape Drive PI/PII processors Email me to find out how you can help *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: checking for tables?
Oh no, I spoke too soon: No, it just looks like you're using the wrong query string from somewhere else on the page, Andy was spot-on. Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: checking for tables?
Thats because you are using Access..the suyntax I sent is for SQL Server.never done it with Access -Original Message- From: Jon Tillman [mailto:[EMAIL PROTECTED]] Sent: 24 August 2000 11:20 To: [EMAIL PROTECTED] Subject: RE: checking for tables? Oh no, I spoke too soon: [Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'. Data Source = "health-horizons" SQL = "IF EXISTS(INSERT INTO 96961133 (productID, productQty) VALUES(54, 1);)" On Thu, 24 Aug 2000, Andy Ewings spake thusly: Yupif you are using SQL server the syntax is. IF EXISTS (SELECT * FROM sysobjects WHERE name = "tablename" AND type = "U") BEGIN PRINT "Table Exists!." END -Original Message- From: Jon Tillman [mailto:[EMAIL PROTECTED]] Sent: 24 August 2000 11:09 To: [EMAIL PROTECTED] Subject: checking for tables? quick question: is there any way to check to see if a table exists without querying it, and throwing an error if it does not? I want to either CREATE or INSERT a table depending on whether or not it already exists -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Help Jon build a network! Looking for giveaway computers parts Current Need: Tape Drive PI/PII processors Email me to find out how you can help *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Help Jon build a network! Looking for giveaway computers parts Current Need: Tape Drive PI/PII processors Email me to find out how you can help *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: checking for tables?
Access! Good point! Try IF EXISTS(SELECT * FROM MSysObjects WHERE ParentID = (SELECT Id FROM MSysObjects WHERE Name = 'Tables') AND Name = 'tablename') Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Frames Dilemma
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --_=_NextPart_000_01C00DB7.5A03581E Content-Type: text/plain; charset="iso-8859-1" Hi Chris Just a thought but you may be able to use DHTML to synchronize your frames. Have a look at this URL and see if it's any use, it explains how to achieve a kinda 'excel freeze panes' effect. http://www.webreference.com/dhtml/column17/ Hope this is of use Rich -Original Message- From: Chris Montgomery [mailto:[EMAIL PROTECTED]] Sent: 24 August 2000 06:16 To: Cf-Talk Subject: Frames Dilemma Ok, I've successfully avoided using frames for five years and now it's time for me to pay the piper. I need a little help, though. Here's the situation: I'm running two queries - one retrieves a parts inventory list from info submitted in a search form and the other retrieves location data based on customer locations. What I want to do (or rather my client wants me to do) is split the screen into three horizontal frames. The top frame(frame1.cfm) will display nav buttons on the left, a page heading (e.g. "Search Results") and then a blurb saying how many records were found (from the results of the parts query). The middle frame (frame2.cfm) will just contain the table column headings: Part# (static text), Description (static text), and from one to eight additional column headings for locations depending on customer location data (these column headings will be generated from the query getting customer locations). The bottom frame (frame3.cfm) will display the results of the search in columns under the column headings in frame two. I have this all running fine right now in a single page, but don't fully understand how to break up the outputs of the queries over the three frames. To complicate matters, a search can result in thousands of retrieved records and I'm using a "Next N" implementation to limit the number of records displayed to 100 per page. Also, the number of records being displayed at the time (e.g., "Displaying records 201 through 300") needs to go in the top frame, under the page heading, and the "next 100 records" link goes at the bottom of the records being displayed in the third frame. To make things simple for illustration, let's assume the search form page calls a file "mainframe.cfm" which holds this frameset: frameset rows="33%,15%,*" frame name="topframe" src="frame1.cfm" marginwidth="10" marginheight="10" scrolling="auto" frameborder="0" frame name="midframe" src="frame2.cfm" marginwidth="10" marginheight="5" scrolling="auto" frameborder="0" frame name="botframe" src="frame3.cfm" marginwidth="10" marginheight="10" scrolling="auto" frameborder="0" /frameset Now my question: should both queries be run in the mainframe.cfm file and then the results somehow passed to the frames where they are used (if this is even possible), or should the queries be run individually in the separate frames? Or since the frames share the results of the queries, do I need to run duplicate queries in each of the frames? To review, the top (frame1) and bottom (frame3) frames will need to use the results of the query that retrieves parts info from whatever the customer enters in their search. Frame 2 uses results from the query to dynamically build the column headers for locations. But the bottom frame (frame3) will also use a list of variables created by the results of the query that gets customer location info (I loop over the location variables to retrieve quantities under each location heading). Does this make sense? Any pointers on how to approach this would be greatly appreciated. TIA! 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 Find a Job in San Antoniohttp://www.sajobnet.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --_=_NextPart_000_01C00DB7.5A03581E Content-Type: application/octet-stream; name="Richard Moger (E-mail).vcf" Content-Disposition: attachment; filename="Richard Moger (E-mail).vcf" BEGIN:VCARD VERSION:2.1 N:Moger;Richard FN:Richard Moger (E-mail) ORG:James Villa Holidays Ltd TITLE:IT Manager TEL;WORK;VOICE:+44 (01732) 840846 TEL;CELL;VOICE:+44 (0777) 953 8192 TEL;WORK;FAX:+44 (01732) 872093 ADR;WORK;ENCODING=QUOTED-PRINTABLE:;;Regents Court=0D=0ALondon Road;Addington;Kent;ME19 5PL;United Kingdom LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Regents Court=0D=0ALondon Road=0D=0AAddington, Kent ME19 5PL=0D=0AUnited Kin= gdom EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:2707T003119Z
Re: checking for tables?
All, Do any of you lot know of any custom tags that will build the [1-10][11-20] style navigation at the bottom of a long list of results, the sort of thing that appears a LOT on search engines? -- Neil Middleton Technical Director Stez Media Neil Middleton studied ancient Greek and Roman warfare with the aim of world domination. He's now a ColdFusion programmer. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: checking for tables?
On Thu, 24 Aug 2000, Andy Ewings spake thusly: Thats because you are using Access..the suyntax I sent is for SQL Server.never done it with Access I wonder if it is even possible with Access -Original Message- From: Jon Tillman [mailto:[EMAIL PROTECTED]] Sent: 24 August 2000 11:20 To: [EMAIL PROTECTED] Subject: RE: checking for tables? Oh no, I spoke too soon: [Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'. Data Source = "health-horizons" SQL = "IF EXISTS(INSERT INTO 96961133 (productID, productQty) VALUES(54, 1);)" On Thu, 24 Aug 2000, Andy Ewings spake thusly: Yupif you are using SQL server the syntax is. IF EXISTS (SELECT * FROM sysobjects WHERE name = "tablename" AND type = "U") BEGIN PRINT "Table Exists!." END -Original Message- From: Jon Tillman [mailto:[EMAIL PROTECTED]] Sent: 24 August 2000 11:09 To: [EMAIL PROTECTED] Subject: checking for tables? quick question: is there any way to check to see if a table exists without querying it, and throwing an error if it does not? I want to either CREATE or INSERT a table depending on whether or not it already exists -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Help Jon build a network! Looking for giveaway computers parts Current Need: Tape Drive PI/PII processors Email me to find out how you can help *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Help Jon build a network! Looking for giveaway computers parts Current Need: Tape Drive PI/PII processors Email me to find out how you can help *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Help Jon build a network! Looking for giveaway computers parts Current Need: Tape Drive PI/PII processors Email me to find out how you can help *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: checking for tables?
On Thu, 24 Aug 2000, DeVoil, Nick spake thusly: Access! Good point! Try IF EXISTS(SELECT * FROM MSysObjects WHERE ParentID = (SELECT Id FROM MSysObjects WHERE Name = 'Tables') AND Name = 'tablename') I hate to be a pest, but do you happen to know how thta would work with an INSERT INTO, instead of SELECT FROM? Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Help Jon build a network! Looking for giveaway computers parts Current Need: Tape Drive PI/PII processors Email me to find out how you can help *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: checking for tables?
On Thu, 24 Aug 2000, Neil Middleton spake thusly: All, Do any of you lot know of any custom tags that will build the [1-10][11-20] style navigation at the bottom of a long list of results, the sort of thing that appears a LOT on search engines? the "LAST 5" "NEXT 5" ? go here: http://www.cftutorials.com/index.cfm?mode=DisplayTutorialTuUUID=CA3C99A0-EC34-11D3-85030050DABEAE1B -- Neil Middleton Technical Director Stez Media Neil Middleton studied ancient Greek and Roman warfare with the aim of world domination. He's now a ColdFusion programmer. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Help Jon build a network! Looking for giveaway computers parts Current Need: Tape Drive PI/PII processors Email me to find out how you can help *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: checking for tables?
On Thu, 24 Aug 2000, Andy Ewings spake thusly: What you want to do is test to see if the table is there. If it is Insert data into it, if not create it first and then insert into it right? What Nick has done is to provide you with the first line of code you need. If the test succeeds then you want to only perform an Insert, if it fails (i.e. the ELSE part) then you want to do a create. Even better I'd do nothing if it does succeed and a create if the test fails and then perform an insert whatever. This make sense? Along the lines of: IF EXISTS( SELECT * FROMMSysObjects WHERE ParentID = ( SELECT Id FROM MSysObjects WHEREName = 'productID') AND Name = '#CFTOKEN#') ELSE( CREATE TABLE #CFTOKEN# ( productID number, productQty number);) Maybe? -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Help Jon build a network! Looking for giveaway computers parts Current Need: Tape Drive PI/PII processors Email me to find out how you can help *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: checking for tables?
I'm not sure of the Access syntax but I would have thought you wanted IF NOT EXISTS(SELECT * FROM MSysObjects WHERE ParentID = (SELECT Id FROM MSysObjects WHERE Name = 'productID') AND Name = '#CFTOKEN#') CREATE TABLE Here!! END IF Do INSERT here -Original Message- From: Jon Tillman [mailto:[EMAIL PROTECTED]] Sent: 24 August 2000 11:44 To: [EMAIL PROTECTED] Subject: RE: checking for tables? On Thu, 24 Aug 2000, Andy Ewings spake thusly: What you want to do is test to see if the table is there. If it is Insert data into it, if not create it first and then insert into it right? What Nick has done is to provide you with the first line of code you need. If the test succeeds then you want to only perform an Insert, if it fails (i.e. the ELSE part) then you want to do a create. Even better I'd do nothing if it does succeed and a create if the test fails and then perform an insert whatever. This make sense? Along the lines of: IF EXISTS( SELECT * FROMMSysObjects WHERE ParentID = ( SELECT Id FROM MSysObjects WHEREName = 'productID') AND Name = '#CFTOKEN#') ELSE( CREATE TABLE #CFTOKEN# ( productID number, productQty number);) Maybe? -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Help Jon build a network! Looking for giveaway computers parts Current Need: Tape Drive PI/PII processors Email me to find out how you can help *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: checking for tables?
IF EXISTS( SELECT * FROMMSysObjects WHERE ParentID = ( SELECT Id FROM MSysObjects WHEREName = 'productID') AND Name = '#CFTOKEN#') ELSE( CREATE TABLE #CFTOKEN# ( productID number, productQty number);) Jon, The IF...ELSE syntax is T-SQL, i.e. what you'd use if you did it in a stored proc. If you're doing it in CFML, you have to do the 2 SQL statements as 2 separate queries. Do a CFIF to test the rowcount on the SELECT query rather than saying IF EXISTS. Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Newbie: How to question...
1. I have a query that uses a variable passed to it from the previous page: CFQUERY NAME="List" DATASOURCE="dsn" USERNAME="usr" PASSWORD="pswd" CACHEDWITHIN="#CreateTimeSpan(0,0,0,0)#" SELECT DISTINCT Task.Task_ID AS ID,Task.Task_Description AS WORDS FROM Task INNER JOIN Service_Scope3 ON Task.Service_Scope3_ID = Service_Scope3.Service_Scope3_ID WHERE 1 = 1 AND Task.Service_Scope3_ID IN (#PreserveSingleQuotes(Form.Scope3_Selected)#); /CFQUERY 2. I have an output from this query that creates a list of check boxes: CFOUTPUT Query="List" input type="checkbox" name="Task_Selected" value="'#ID#'" #ID# #Words#br /cfoutput input type="hidden" name="username" value=" cfoutput#session.userid#/cfoutput " 3. The problem I need help with: I want to add a whole list of parameters to input into a database that is directly linked to each of these "Task_Selected" checkbox values. For instance: CFOUTPUT Query="List" input type="checkbox" name="Task_Selected" value="'#ID#'" #ID# #Words# input type="text" name="param1" value="" input type="text" name="param2" value="" input type="text" name="param3" value="" input type="text" name="param4" value="" input type="text" name="param5" value="" input type="text" name="param6" value="" br /cfoutput input type="hidden" name="username" value=" cfoutput#session.userid#/cfoutput " My NEWBIE dilemna is how do I grab this information on the next page? Each checkbox, etc. has the exact same name. If I dynamically generate a name, how do I grab a hold of it to place it in a database? I am lost on how to correctly format this and how to process it on the following page. Thank you. /mdeane -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Using COM with CF
I can't pinpoint why your code is not working. Here is what I found when I used CF to access my COM object. First, I found that I had problems trying to pass parameters to my method. Instead I created properties on the object and set those. Then I would call the method without any parameters. Second, I didn't use the CFSCRIPT tag. Third, you need to make sure you object will allow the Coldfusion service user to launch your object. In our case we created a domain user called "CFServiceUser" and had the CF services run as this user. This allows us to give that user security rights in the domain so our CF pages can access what they need. Here is a snippet of the code I used in accessing my COM object. I create the object, set 2 properties (cINIFile and uGroup) then call the rGetRatingsforGroup method. CFOBJECT TYPE="COM" NAME="CustRateTemp" CLASS="custratetempbus.custratetempbus" ACTION="CREATE" CFSET CustRateTemp.cINIFile = #APPLICATION.INIFile# !--- Get Minimum Score List --- CFSET CustRateTemp.uGroup = #APPLICATION.MinScoreCode# CFSET loMinScores = CustRateTemp.rGetRatingsforGroup I hope this helps! Bill Grover Supervisor, IS EU Services, Inc. 649 N Horners Ln Rockville MD 20850 Phone: 301-424-3300 x396 FAX:301-424-3300 x1396# E-Mail: [EMAIL PROTECTED] WWW:www.euservices.com - Original Message - Date: Wed, 23 Aug 2000 23:17:57 -0700 From: "Tom Kim" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Subject: Using COM with CF Message-ID: [EMAIL PROTECTED] Hi, I'm new to CF and am using version 4.5.1 of both Studio and Server. I have a COM object that returns a generated integer value. I can use this COM object in any COM enabled Windows app. However, when I try to use in a cfm page I get the following error: An error occurred while evaluating the expression: oASIWeb.SetDataPath("E:\InetPub\wwwroot\SolidData\Data"); oASIWeb.SetDatabase("sdweb"); RetVal = oASIWeb.NewID("USERS"); Error near line 4, column 4. The symbol you have provided (oASIWeb.SetDataPath) is not the name of a function. Built-in functions in ColdFusion have names with no qualifiers, i.e., no periods (.) in them. It appears that CF thinks I'm trying to run one of its functions. My CF code is as follows: CFOBJECT TYPE="COM" NAME="oASIWeb" CLASS="asiweb.asiweb" ACTION="CREATE" CFSCRIPT oASIWeb.SetDataPath("E:\InetPub\wwwroot\SolidData\Data"); oASIWeb.SetDatabase("sdweb"); RetVal = oASIWeb.NewID("USERS"); /CFSCRIPT CFOUTPUT#RetVal#/CFOUTPUT Am I missing something? Do I need to give the IUSR_MachineName account the proper security access? If yes, what? Thanks --Tom Tom Kim Advanced Systems Integration 949-261-5476 949-261-0426 Fax [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Linking tables across multiple datasources
It depends on your database to some extent. If you're using Access the simplest solution would be to link the emp_course table in PQR to emp_details in XYZ using the file/get external data/link tables menu. You can write SQL statements specifying XYZ as the datasource and reference the emp_course table that is linked. If you're using SQL Server or need to maintain a migration path from Access to SQL Server the SQL syntax is SELECT * FROM emp_details INNER JOIN db_name.dbo.emp_course ON whatever. I have found that to allow the same set of templates to be used for Access and SQL server in this situation I had to specify a db_prefix variable which was set to "db_name.dbo." in a SQL Server environment and to "" for Access. The SQL syntax that would execute on both platforms was: SELECT * FROM emp_details INNER JOIN #db_prefix#emp_course ON whatever Hope this helps Julian -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Multiple Language Help Needed
Hi, all! We're working with a client that wants to offer all of their web content in multiple languages. At this time, all of the languages they want are single-byte, however, they will be adding some double-byte in the future. Any recommendations or sites on how to set up the datasources to support multiple languages while providing a method of providing the translators with new or edited content on a live basis? Thanks for any help. Scott Scott Brader USAV Group 5485 South Westridge Drive PO Box 510620 New Berlin, WI 53151-0620 Phone: 262.814.2000 Fax: 262.814.2006 Amateurs Practice Until They Get It Right, Experts Practice Until They Can't Get It Wrong Any opinions expressed herein are mine and are not representative of USAV Communications Group. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Newbie trying to understand CFTRANSACTION
Hi All, I'm reading about this CFTRANSACTION tag, and I'm not really clear on what it's used for. The CF Web App Const. Kit book states that it "...implements transaction and rollback processing. Any CFQUERY tags placed between CFTRANSACTION and /CFTRANSACTION tags are automatically rolled back if an error occurs." Am I correct in interpreting this to mean that if, for example in my own application, when a user submits a form to an action page that updates my database AND also sends off various emails, that if the query pulling the emails from the email table fails, the other updates to the database will still be made? If I'm off base here, what are the practical applications of this tag? Thanks! T Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Newbie trying to understand CFTRANSACTION
I'm not sure about whether CFTRANSACTION only applies to database stuffcan someone clears this up? What I do know is that if you have say 2 CFQuery's - one which inserts a bunch of records and then the next updates them say, then, if the insert succeeds but the update fails then the insert will be 'rolled' back. This is because the command is stored in memory until all commands between the CFTRANSACTION and the /CFTRANSACTION completed successfully. However - if you are using SQL Server I would strongly suggest using TRANSACTIONS within your SQL rather than using CFTRANSACTION as all CF cares about is whether the call to the SP or whatever was successfull. SQL may have done something different to what you expected. You will get much tighter control if you let SQL take care of the transactions -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: 24 August 2000 12:48 To: [EMAIL PROTECTED] Subject: "Newbie" trying to understand CFTRANSACTION Hi All, I'm reading about this CFTRANSACTION tag, and I'm not really clear on what it's used for. The CF Web App Const. Kit book states that it "...implements transaction and rollback processing. Any CFQUERY tags placed between CFTRANSACTION and /CFTRANSACTION tags are automatically rolled back if an error occurs." Am I correct in interpreting this to mean that if, for example in my own application, when a user submits a form to an action page that updates my database AND also sends off various emails, that if the query pulling the emails from the email table fails, the other updates to the database will still be made? If I'm off base here, what are the practical applications of this tag? Thanks! T Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT: What books are available to ease the pain of moving from Oracle to Microsoft SQL Server
A co-worker is experienced in Oracle but finds himself faced with the task of working with Microsoft SQL Server. He doesn't need to learn SQL or relational databases. He just is looking for the book, or set of books, best for programming, design, and administration of a Microsoft SQL Server environment (Windows NT at least...). Any recommendations would be appreciated. -- Never apply a Star Trek solution to a Babylon 5 problem. Larry W. Virden mailto:[EMAIL PROTECTED] URL: http://www.purl.org/NET/lvirden/ Even if explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: What books are available to ease the pain of moving from Oracle to Microsoft SQL Server
The only book I've read that I thought was superb was "The Hitchikers guide to VB and SQL Server". This is only really any good if he is using VB to access SQL although it does explain the difference between methods of data access very well (ADO, ODBC, OLEDB, RDO, etc) IF he is using CF to access SQL then I wouldn't bother buying it -Original Message- From: Larry W. Virden [mailto:[EMAIL PROTECTED]] Sent: 24 August 2000 12:58 To: [EMAIL PROTECTED] Subject: OT: What books are available to ease the pain of moving from Oracle to Microsoft SQL Server A co-worker is experienced in Oracle but finds himself faced with the task of working with Microsoft SQL Server. He doesn't need to learn SQL or relational databases. He just is looking for the book, or set of books, best for programming, design, and administration of a Microsoft SQL Server environment (Windows NT at least...). Any recommendations would be appreciated. -- Never apply a Star Trek solution to a Babylon 5 problem. Larry W. Virden mailto:[EMAIL PROTECTED] URL: http://www.purl.org/NET/lvirden/ Even if explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Oracle to SQL
In the near future I am going to have to transfer a dataset produced by an Oracle database into SQL server (7). My web site (written in CF) uses this database. Has anyone had any experience in doing this and if so did they experience any problems? -- 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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Newbie trying to understand CFTRANSACTION
Interesting, in CFTRANSACTION you have to reference the same DSN. I wonder how Phil uses multiple DSN's between CFTRANSACTION Tags? Neil - Original Message - From: "Philip Arnold - ASP" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 8:21 AM Subject: RE: "Newbie" trying to understand CFTRANSACTION I'm reading about this CFTRANSACTION tag, and I'm not really clear on what it's used for. The CF Web App Const. Kit book states that it "...implements transaction and rollback processing. Any CFQUERY tags placed between CFTRANSACTION and /CFTRANSACTION tags are automatically rolled back if an error occurs." Am I correct in interpreting this to mean that if, for example in my own application, when a user submits a form to an action page that updates my database AND also sends off various emails, that if the query pulling the emails from the email table fails, the other updates to the database will still be made? If I'm off base here, what are the practical applications of this tag? OK, it's used in cases where you have to add data to several tables, and possibly across several datasources Say you was adding a new item to a shopping cart, and it had several entries into the product reference table If any of the inserts fail, then nothing would be added, so you don't get orphan records Another possible use, is to get the latest identity from a table - it's not 100% effective for this, but works on smaller applications HTH Philip Arnold 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/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
picking up form variables on the action page??
I have a form page and I am dynamically generating field names from my database like so: cfform cfinput name="Reference_#ReferenceID#" Submit /cfform in some cases there are 10 input boxes and in otheres there are 2 onput boxes, My question is how can I capture these fields in the action page if I am not aware of there name prior to submitting. Can anyone be of assistance??? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: picking up form variables on the action page??
How about a hidden field with a list of the #ReferenceID#'s ? Then you could loop that list? Thanks, Neil - Original Message - From: "Jason Glaun" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 8:32 AM Subject: picking up form variables on the action page?? I have a form page and I am dynamically generating field names from my database like so: cfform cfinput name="Reference_#ReferenceID#" Submit /cfform in some cases there are 10 input boxes and in otheres there are 2 onput boxes, My question is how can I capture these fields in the action page if I am not aware of there name prior to submitting. Can anyone be of assistance??? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFSCRIPT question
cfif not structKeyExists(session.cart, attributes.name blah /cfif - Original Message - From: "Jon Tillman" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 07:27 Subject: CFSCRIPT question I have the following as cfscript: if (not(structKeyExists(session.cart, attributes.name))) I would like to use it as a CFIF statement. Any ideas how to go about constructing said cfif? -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Help Jon build a network! Looking for giveaway computers parts Current Need: Tape Drive PI/PII processors Email me to find out how you can help *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: picking up form variables on the action page??
This is another way to do it however it seems less efficient since there could be several other fields in the form. I was assuming this is a much larger form for my suggestion. Neil - Original Message - From: "Dave Hannum" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 8:57 AM Subject: Re: picking up form variables on the action page?? This will loop through all of the submitted fields, capture the field names and display the value. CFLOOP INDEX="myFields" LIST="FORM.FieldNames" CFSET thisFieldName = myFields CFSET thisFieldValue = Evaluate(myFields) CFOUTPUT Field Name: #thisFieldName# br Field Value: #thisFieldValue# p /CFOUTPUT /CFLOOP 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 - Original Message - From: "Jason Glaun" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 8:32 AM Subject: picking up form variables on the action page?? I have a form page and I am dynamically generating field names from my database like so: cfform cfinput name="Reference_#ReferenceID#" Submit /cfform in some cases there are 10 input boxes and in otheres there are 2 onput boxes, My question is how can I capture these fields in the action page if I am not aware of there name prior to submitting. Can anyone be of assistance??? -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFSCRIPT question
Oops. Left off a ) Should be cfif not structKeyExists(session.cart, attributes.name) blah /cfif - Original Message - From: "David E. Crawford" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 12:56 Subject: Re: CFSCRIPT question cfif not structKeyExists(session.cart, attributes.name blah /cfif - Original Message - From: "Jon Tillman" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 07:27 Subject: CFSCRIPT question I have the following as cfscript: if (not(structKeyExists(session.cart, attributes.name))) I would like to use it as a CFIF statement. Any ideas how to go about constructing said cfif? -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Help Jon build a network! Looking for giveaway computers parts Current Need: Tape Drive PI/PII processors Email me to find out how you can help *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: picking up form variables on the action page??
Neil, This was simply a BASIC, FUNDAMENTAL way to showing Jason the PRINCIPAL of dynamically grabbing the values. It was not meant for a specific application. Nobody was talking about efficient code - (but if you are, why loop through a bunch of values that may or may not exist? The overhead with the associated CFIF's would be less efficient.) Dave - Original Message - From: "Neil H." [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 8:58 AM Subject: Re: picking up form variables on the action page?? This is another way to do it however it seems less efficient since there could be several other fields in the form. I was assuming this is a much larger form for my suggestion. Neil - Original Message - From: "Dave Hannum" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 8:57 AM Subject: Re: picking up form variables on the action page?? This will loop through all of the submitted fields, capture the field names and display the value. CFLOOP INDEX="myFields" LIST="FORM.FieldNames" CFSET thisFieldName = myFields CFSET thisFieldValue = Evaluate(myFields) CFOUTPUT Field Name: #thisFieldName# br Field Value: #thisFieldValue# p /CFOUTPUT /CFLOOP 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 - Original Message - From: "Jason Glaun" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 8:32 AM Subject: picking up form variables on the action page?? I have a form page and I am dynamically generating field names from my database like so: cfform cfinput name="Reference_#ReferenceID#" Submit /cfform in some cases there are 10 input boxes and in otheres there are 2 onput boxes, My question is how can I capture these fields in the action page if I am not aware of there name prior to submitting. Can anyone be of assistance??? -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: picking up form variables on the action page??
How do you figure, what I was saying is pass the values for the number appended to the end of the variable. Then loop through that list and reference the list element appended to the end of "Reference_" Neil - Original Message - From: "Dave Hannum" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 9:22 AM Subject: Re: picking up form variables on the action page?? Neil, This was simply a BASIC, FUNDAMENTAL way to showing Jason the PRINCIPAL of dynamically grabbing the values. It was not meant for a specific application. Nobody was talking about efficient code - (but if you are, why loop through a bunch of values that may or may not exist? The overhead with the associated CFIF's would be less efficient.) Dave - Original Message - From: "Neil H." [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 8:58 AM Subject: Re: picking up form variables on the action page?? This is another way to do it however it seems less efficient since there could be several other fields in the form. I was assuming this is a much larger form for my suggestion. Neil - Original Message - From: "Dave Hannum" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 8:57 AM Subject: Re: picking up form variables on the action page?? This will loop through all of the submitted fields, capture the field names and display the value. CFLOOP INDEX="myFields" LIST="FORM.FieldNames" CFSET thisFieldName = myFields CFSET thisFieldValue = Evaluate(myFields) CFOUTPUT Field Name: #thisFieldName# br Field Value: #thisFieldValue# p /CFOUTPUT /CFLOOP 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 - Original Message - From: "Jason Glaun" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 8:32 AM Subject: picking up form variables on the action page?? I have a form page and I am dynamically generating field names from my database like so: cfform cfinput name="Reference_#ReferenceID#" Submit /cfform in some cases there are 10 input boxes and in otheres there are 2 onput boxes, My question is how can I capture these fields in the action page if I am not aware of there name prior to submitting. Can anyone be of assistance??? -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=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=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Referring to variables
Okay, another "best practice" question, I guess... I have inherited an application from someone. In going through the code, I notice that this person refers to several variables by using "Variables.(whatever)". I'm assuming "Variables" is a reserverd term? I can't find any documentation on this in my reference books. Why would one choose to reference variables by preceding it this way? For example: CFDIRECTORY ACTION="List" DIRECTORY="mypath" NAME="CurrentDir" cfoutput CFIF #CurrentDir.Name# IS "" CFSET PRODUCTION="TRUE" CFELSE CFSET PRODUCTION="FALSE" /CFIF /cfoutput CFIF #Variables.PRODUCTION# IS "TRUE" ... etc. I would write the IF statement as: CFIF PRODUCTION IS "TRUE"... etc. Why did this other person refer to "Variables.PRODUCTION"? They've done this throughout the code... Thanks! Terri Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: picking up form variables on the action page??
OK - but what if no value was passed for that form field? You have to decipher what fields had input and what ones have no value. Dave - Original Message - From: "Neil H." [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 9:26 AM Subject: Re: picking up form variables on the action page?? How do you figure, what I was saying is pass the values for the number appended to the end of the variable. Then loop through that list and reference the list element appended to the end of "Reference_" Neil - Original Message - From: "Dave Hannum" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 9:22 AM Subject: Re: picking up form variables on the action page?? Neil, This was simply a BASIC, FUNDAMENTAL way to showing Jason the PRINCIPAL of dynamically grabbing the values. It was not meant for a specific application. Nobody was talking about efficient code - (but if you are, why loop through a bunch of values that may or may not exist? The overhead with the associated CFIF's would be less efficient.) Dave - Original Message - From: "Neil H." [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 8:58 AM Subject: Re: picking up form variables on the action page?? This is another way to do it however it seems less efficient since there could be several other fields in the form. I was assuming this is a much larger form for my suggestion. Neil - Original Message - From: "Dave Hannum" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 8:57 AM Subject: Re: picking up form variables on the action page?? This will loop through all of the submitted fields, capture the field names and display the value. CFLOOP INDEX="myFields" LIST="FORM.FieldNames" CFSET thisFieldName = myFields CFSET thisFieldValue = Evaluate(myFields) CFOUTPUT Field Name: #thisFieldName# br Field Value: #thisFieldValue# p /CFOUTPUT /CFLOOP 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 - Original Message - From: "Jason Glaun" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 8:32 AM Subject: picking up form variables on the action page?? I have a form page and I am dynamically generating field names from my database like so: cfform cfinput name="Reference_#ReferenceID#" Submit /cfform in some cases there are 10 input boxes and in otheres there are 2 onput boxes, My question is how can I capture these fields in the action page if I am not aware of there name prior to submitting. Can anyone be of assistance??? -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=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=listsbody=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=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: picking up form variables on the action page??
Could you show some code as an example of how to do this exactly? Thank you. /mdeane -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 24, 2000 8:59 AM To: [EMAIL PROTECTED] Subject: Re: picking up form variables on the action page?? This is another way to do it however it seems less efficient since there could be several other fields in the form. I was assuming this is a much larger form for my suggestion. Neil - Original Message - From: "Dave Hannum" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 8:57 AM Subject: Re: picking up form variables on the action page?? This will loop through all of the submitted fields, capture the field names and display the value. CFLOOP INDEX="myFields" LIST="FORM.FieldNames" CFSET thisFieldName = myFields CFSET thisFieldValue = Evaluate(myFields) CFOUTPUT Field Name: #thisFieldName# br Field Value: #thisFieldValue# p /CFOUTPUT /CFLOOP 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 - Original Message - From: "Jason Glaun" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 8:32 AM Subject: picking up form variables on the action page?? I have a form page and I am dynamically generating field names from my database like so: cfform cfinput name="Reference_#ReferenceID#" Submit /cfform in some cases there are 10 input boxes and in otheres there are 2 onput boxes, My question is how can I capture these fields in the action page if I am not aware of there name prior to submitting. Can anyone be of assistance??? -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: checking for tables?
html font size=3Here one I wrote in two parts. The first one does all the calculations to give you all the info you need to display Prev page and Next page buttons in any format you like: (note: I replaced the lt;gt; with [] because my mail program always messes up display of any HTML-like tags.br br /fontfont face="Courier New, Courier" size=2lt;!---br //nbsp; Module qpager.cfmbr //nbsp; Peter Theobald 8/10/2000br //nbsp; [EMAIL PROTECTED]br //nbsp; Calculate numbers for paged query databr //br //nbsp; Usage:br //nbsp; set qpager=StructNew()br //nbsp; set qpager.startrow (def: 1), qpager.maxrows (def: 10), qpager.numrecords (req.)br //nbsp; lt;cfinclude template=quot;qpager.cfmquot;gt;br //br //nbsp; Outputs: qpager.prevstart, qpager.nextstart,br //x-tabnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;/x-tab qpager.numpages, qpager.thispage, qpager.endrowbr ---gt;br br br nbsp; [cfscript]br nbsp; if (NOT IsDefined(quot;qpager.recordcountquot;)) qpager.recordcount=1;br nbsp; if (NOT IsDefined(quot;qpager.startrowquot;)) qpager.startrow=1;br nbsp; if (NOT IsDefined(quot;qpager.maxrowsquot;)) qpager.maxrows=10;br nbsp; // Why can't CF be zero based like any sane language?br nbsp; qpager.numpages = (qpager.recordcount-1)\qpager.maxrows +1;br nbsp; qpager.thispage = (qpager.startrow-1)\qpager.maxrows +1;br nbsp; qpager.prevstart = ((qpager.startrow-2)\qpager.maxrows)br x-tabnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;/x-tab* qpager.maxrows +1;br nbsp; if (qpager.prevstart LT 0) qpager.prevstart = 1;br nbsp; qpager.endrow = qpager.startrow+qpager.maxrows -1;br nbsp; if (qpager.endrow GT qpager.recordcount)br x-tabnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;/x-tabqpager.endrow = qpager.recordcount;br nbsp; qpager.nextstart = qpager.startrow+qpager.maxrows;br nbsp; if (qpager.nextstart GT qpager.recordcount)br x-tabnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;/x-tabqpager.nextstart = qpager.startrow;br nbsp; [/cfscript]br br br /fontfont size=3Now you can use /fontfont face="Courier New, Courier" size=2qpager.startrow, qpager.maxrows, qpager.numrecords, qpager.prevstart, qpager.nextstart, qpager.numpages, qpager.thispage, qpager.endrowbr br /fontfont size=3To do any style you like. For example: (remember to replace all [ with lt; in my example)br br /fontfont face="Courier New, Courier" size=2lt;!---br // dsp_qpager.cfmbr // Peter Theobaldbr // Display query page controls. All links point back to the same page.br // Must be preceeded by fn_qpager.cfmbr //br ---gt;br [cfoutputgt;br [form name=quot;dsp_qpager_formquot; action=quot;#CGI.SCRIPT_NAME#quot; method=postgt;br [input type=hidden name=quot;startrowquot; value=quot;#qpager.startrow#quot;gt;br [input type=hidden name=quot;sortbyquot; value=quot;#sortby#quot;gt;br [div align=rightgt;br View [select name=quot;maxrowsquot; onChange=quot;document.dsp_qpager_form.submit();quot;gt;br [option value=quot;10quot; [cfif qpager.maxrows EQ 10gt;SELECTEDlt;/CFIFgt;gt;10[/optiongt;br [option value=quot;30quot; [cfif qpager.maxrows EQ 30gt;SELECTEDlt;/CFIFgt;gt;30[/optiongt;br [option value=quot;50quot; [cfif qpager.maxrows EQ 50gt;SELECTEDlt;/CFIFgt;gt;50[/optiongt;br [option value=quot;100quot; [cfif qpager.maxrows EQ 100gt;SELECTEDlt;/CFIFgt;gt;100[/optiongt;br [option value=quot;500quot; [cfif qpager.maxrows EQ 500gt;SELECTEDlt;/CFIFgt;gt;500[/optiongt;br [/selectgt; per page[/divgt;[/formgt;br [cfif qpager.numpages GT 1gt;br [div align=rightgt;Viewing #qpager.startrow# - #qpager.endrow# of #qpager.recordcount# amp;nbsp;amp;nbsp; lt;a href=quot;#CGI.SCRIPT_NAME#?startrow=#qpager.prevstart#amp;maxrows=#qpager.maxrows#amp;sortby=#sortby#quot;gt;PREVlt;/agt; [a href=quot;#CGI.SCRIPT_NAME#?startrow=#qpager.nextstart#amp;maxrows=#qpager.maxrows#amp;sortby=#sortby#quot;gt;NEXTlt;/agt;[/divgt;br [/cfifgt;br [/cfoutputgt;br br /fontfont size=3At 11:34 AM 8/24/00 +0100, Neil Middleton wrote:br blockquote type=cite citeAll,br br Do any of you lot know of any custom tags that will build the [1-10][11-20]br style navigation at the bottom of a long list of results, the sort of thingbr that appears a LOT on search engines?br --br Neil Middletonbr Technical Directorbr Stez Mediabr br br Neil Middleton studied ancient Greek and Roman warfare with the aim of worldbr domination.br He's now a ColdFusion programmer.br br --br Archives: a href="http://www.mail-archive.com/cf-talk@houseoffusion.com/" eudora="autourl"http://www.mail-archive.com/cf-talk@houseoffusion.com//abr To Unsubscribe visit a href="http://www.houseoffusion.com/index.cfm?sidebar=listsamp;body=lists/cf_talk" eudora="autourl"http://www.houseoffusion.com/index.cfm?sidebar=listsamp;body=lists/cf_talk/a or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. /font/blockquotebr br -font size=3--br Peter Theobald, Chief Technology Officerbr LiquidStreaming a
Re: checking for tables?
Here one I wrote in two parts. The first one does all the calculations to give you all the info you need to display Prev page and Next page buttons in any format you like: (note: I replaced the with [] because my mail program always messes up display of any HTML-like tags. !--- // Module qpager.cfm // Peter Theobald 8/10/2000 // [EMAIL PROTECTED] // Calculate numbers for paged query data // // Usage: // set qpager=StructNew() // set qpager.startrow (def: 1), qpager.maxrows (def: 10), qpager.numrecords (req.) // cfinclude template="qpager.cfm" // // Outputs: qpager.prevstart, qpager.nextstart, // qpager.numpages, qpager.thispage, qpager.endrow --- [cfscript] if (NOT IsDefined("qpager.recordcount")) qpager.recordcount=1; if (NOT IsDefined("qpager.startrow")) qpager.startrow=1; if (NOT IsDefined("qpager.maxrows")) qpager.maxrows=10; // Why can't CF be zero based like any sane language? qpager.numpages = (qpager.recordcount-1)\qpager.maxrows +1; qpager.thispage = (qpager.startrow-1)\qpager.maxrows +1; qpager.prevstart = ((qpager.startrow-2)\qpager.maxrows) * qpager.maxrows +1; if (qpager.prevstart LT 0) qpager.prevstart = 1; qpager.endrow = qpager.startrow+qpager.maxrows -1; if (qpager.endrow GT qpager.recordcount) qpager.endrow = qpager.recordcount; qpager.nextstart = qpager.startrow+qpager.maxrows; if (qpager.nextstart GT qpager.recordcount) qpager.nextstart = qpager.startrow; [/cfscript] Now you can use qpager.startrow, qpager.maxrows, qpager.numrecords, qpager.prevstart, qpager.nextstart, qpager.numpages, qpager.thispage, qpager.endrow To do any style you like. For example: (remember to replace all [ with in my example) !--- // dsp_qpager.cfm // Peter Theobald // Display query page controls. All links point back to the same page. // Must be preceeded by fn_qpager.cfm // --- [cfoutput [form name="dsp_qpager_form" action="#CGI.SCRIPT_NAME#" method=post [input type=hidden name="startrow" value="#qpager.startrow#" [input type=hidden name="sortby" value="#sortby#" [div align=right View [select name="maxrows" onChange="document.dsp_qpager_form.submit();" [option value="10" [cfif qpager.maxrows EQ 10SELECTED/CFIF10[/option [option value="30" [cfif qpager.maxrows EQ 30SELECTED/CFIF30[/option [option value="50" [cfif qpager.maxrows EQ 50SELECTED/CFIF50[/option [option value="100" [cfif qpager.maxrows EQ 100SELECTED/CFIF100[/option [option value="500" [cfif qpager.maxrows EQ 500SELECTED/CFIF500[/option [/select per page[/div[/form [cfif qpager.numpages GT 1 [div align=rightViewing #qpager.startrow# - #qpager.endrow# of #qpager.recordcount# nbsp;nbsp; a href="#CGI.SCRIPT_NAME#?startrow=#qpager.prevstart#maxrows=#qpager.maxrows#sortby=#sortby#"PREV/a [a href="#CGI.SCRIPT_NAME#?startrow=#qpager.nextstart#maxrows=#qpager.maxrows#sortby=#sortby#"NEXT/a[/div [/cfif [/cfoutput At 11:34 AM 8/24/00 +0100, Neil Middleton wrote: All, Do any of you lot know of any custom tags that will build the [1-10][11-20] style navigation at the bottom of a long list of results, the sort of thing that appears a LOT on search engines? -- Neil Middleton Technical Director Stez Media Neil Middleton studied ancient Greek and Roman warfare with the aim of world domination. He's now a ColdFusion programmer. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 Fax 1.212.679.8032 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: picking up form variables on the action page??
How are you handling that in your example? Neil - Original Message - From: "Dave Hannum" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 9:46 AM Subject: Re: picking up form variables on the action page?? OK - but what if no value was passed for that form field? You have to decipher what fields had input and what ones have no value. Dave - Original Message - From: "Neil H." [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 9:26 AM Subject: Re: picking up form variables on the action page?? How do you figure, what I was saying is pass the values for the number appended to the end of the variable. Then loop through that list and reference the list element appended to the end of "Reference_" Neil - Original Message - From: "Dave Hannum" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 9:22 AM Subject: Re: picking up form variables on the action page?? Neil, This was simply a BASIC, FUNDAMENTAL way to showing Jason the PRINCIPAL of dynamically grabbing the values. It was not meant for a specific application. Nobody was talking about efficient code - (but if you are, why loop through a bunch of values that may or may not exist? The overhead with the associated CFIF's would be less efficient.) Dave - Original Message - From: "Neil H." [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 8:58 AM Subject: Re: picking up form variables on the action page?? This is another way to do it however it seems less efficient since there could be several other fields in the form. I was assuming this is a much larger form for my suggestion. Neil - Original Message - From: "Dave Hannum" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 8:57 AM Subject: Re: picking up form variables on the action page?? This will loop through all of the submitted fields, capture the field names and display the value. CFLOOP INDEX="myFields" LIST="FORM.FieldNames" CFSET thisFieldName = myFields CFSET thisFieldValue = Evaluate(myFields) CFOUTPUT Field Name: #thisFieldName# br Field Value: #thisFieldValue# p /CFOUTPUT /CFLOOP 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 - Original Message - From: "Jason Glaun" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 8:32 AM Subject: picking up form variables on the action page?? I have a form page and I am dynamically generating field names from my database like so: cfform cfinput name="Reference_#ReferenceID#" Submit /cfform in some cases there are 10 input boxes and in otheres there are 2 onput boxes, My question is how can I capture these fields in the action page if I am not aware of there name prior to submitting. Can anyone be of assistance??? -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=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=listsbody=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=listsbody=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=listsbody=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/
RE: CFSCRIPT question
How would you then check for a particular value of a key within the same cfif? In other words I am doing something similar where I am checking for the existence of a key but then how do I filter so I get only those whose value is, say, a specific date? Thanks -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 24, 2000 9:00 AM To: [EMAIL PROTECTED] Subject: Re: CFSCRIPT question Oops. Left off a ) Should be cfif not structKeyExists(session.cart, attributes.name) blah /cfif - Original Message - From: "David E. Crawford" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 12:56 Subject: Re: CFSCRIPT question cfif not structKeyExists(session.cart, attributes.name blah /cfif - Original Message - From: "Jon Tillman" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 07:27 Subject: CFSCRIPT question I have the following as cfscript: if (not(structKeyExists(session.cart, attributes.name))) I would like to use it as a CFIF statement. Any ideas how to go about constructing said cfif? -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Help Jon build a network! Looking for giveaway computers parts Current Need: Tape Drive PI/PII processors Email me to find out how you can help *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Referring to variables
They are being very specific so that there is never any ambiguity over which variable they are talking about if there are more than one with the same name in different scopes (ie variables.production and URL.production). Variables comes first in the search order so it isn't THAT necessary... EXCEPT for query variables - they come before "variables". It is said to be faster when you are explicit but since "variables" is the second scope searched it's probably not much faster. At 01:27 PM 8/24/00 +, Terri Stocke wrote: Okay, another "best practice" question, I guess... I have inherited an application from someone. In going through the code, I notice that this person refers to several variables by using "Variables.(whatever)". I'm assuming "Variables" is a reserverd term? I can't find any documentation on this in my reference books. Why would one choose to reference variables by preceding it this way? For example: CFDIRECTORY ACTION="List" DIRECTORY="mypath" NAME="CurrentDir" cfoutput CFIF #CurrentDir.Name# IS "" CFSET PRODUCTION="TRUE" CFELSE CFSET PRODUCTION="FALSE" /CFIF /cfoutput CFIF #Variables.PRODUCTION# IS "TRUE" ... etc. I would write the IF statement as: CFIF PRODUCTION IS "TRUE"... etc. Why did this other person refer to "Variables.PRODUCTION"? They've done this throughout the code... Thanks! Terri Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- Peter Theobald, Chief Technology Officer LiquidStreaming http://www.liquidstreaming.com [EMAIL PROTECTED] Phone 1.212.545.1232 Fax 1.212.679.8032 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Session timeout?
Hello all. Is there a way to find whether the session timed out.If the session timed out display the logon page. Some like cfif Not isDefined(Session) cflocation ../logon.cfm /cfif but i cant get this work. Appretiate any comments. thanks Joe - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Session timeout?
Set a param in your application.cfm called Session.Loggedin for example with a default of "no" When a user logs in set this variable to yes. Then in your application.cfm also have code that says: cfif Session.Loggedin IS "No" cflocation url="logon.cfm" /cfif -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 24 August 2000 15:01 To: [EMAIL PROTECTED] Subject: Session timeout? Hello all. Is there a way to find whether the session timed out.If the session timed out display the logon page. Some like cfif Not isDefined(Session) cflocation ../logon.cfm /cfif but i cant get this work. Appretiate any comments. thanks Joe - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Referring to variables
Thanks, Chris! You could refer to it without the scope, though, right? Ter Original Message Follows From: "Olive, Christopher M Mr NMR" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED] Subject: RE: Referring to variables Date: Thu, 24 Aug 2000 09:43:51 -0400 VARIABLES is a scope, similar to FORM and URL. it refers to variable created within the page. Chris Olive, DOEHRS Website Administrator -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 24, 2000 9:27 AM To: [EMAIL PROTECTED] Subject: Referring to variables Okay, another "best practice" question, I guess... I have inherited an application from someone. In going through the code, I notice that this person refers to several variables by using "Variables.(whatever)". I'm assuming "Variables" is a reserverd term? I can't find any documentation on this in my reference books. Why would one choose to reference variables by preceding it this way? For example: CFDIRECTORY ACTION="List" DIRECTORY="mypath" NAME="CurrentDir" cfoutput CFIF #CurrentDir.Name# IS "" CFSET PRODUCTION="TRUE" CFELSE CFSET PRODUCTION="FALSE" /CFIF /cfoutput CFIF #Variables.PRODUCTION# IS "TRUE" ... etc. I would write the IF statement as: CFIF PRODUCTION IS "TRUE"... etc. Why did this other person refer to "Variables.PRODUCTION"? They've done this throughout the code... Thanks! Terri Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: picking up form variables on the action page??
If it's a textbox, and there's no value, then the FORM.FieldName won't be passed. (Unless I have initialized it with a CFPARAM). 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 - Original Message - From: "Neil H." [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 9:52 AM Subject: Re: picking up form variables on the action page?? How are you handling that in your example? Neil - Original Message - From: "Dave Hannum" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 9:46 AM Subject: Re: picking up form variables on the action page?? OK - but what if no value was passed for that form field? You have to decipher what fields had input and what ones have no value. Dave - Original Message - From: "Neil H." [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 9:26 AM Subject: Re: picking up form variables on the action page?? How do you figure, what I was saying is pass the values for the number appended to the end of the variable. Then loop through that list and reference the list element appended to the end of "Reference_" Neil - Original Message - From: "Dave Hannum" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 9:22 AM Subject: Re: picking up form variables on the action page?? Neil, This was simply a BASIC, FUNDAMENTAL way to showing Jason the PRINCIPAL of dynamically grabbing the values. It was not meant for a specific application. Nobody was talking about efficient code - (but if you are, why loop through a bunch of values that may or may not exist? The overhead with the associated CFIF's would be less efficient.) Dave - Original Message - From: "Neil H." [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 8:58 AM Subject: Re: picking up form variables on the action page?? This is another way to do it however it seems less efficient since there could be several other fields in the form. I was assuming this is a much larger form for my suggestion. Neil - Original Message - From: "Dave Hannum" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 8:57 AM Subject: Re: picking up form variables on the action page?? This will loop through all of the submitted fields, capture the field names and display the value. CFLOOP INDEX="myFields" LIST="FORM.FieldNames" CFSET thisFieldName = myFields CFSET thisFieldValue = Evaluate(myFields) CFOUTPUT Field Name: #thisFieldName# br Field Value: #thisFieldValue# p /CFOUTPUT /CFLOOP 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 - Original Message - From: "Jason Glaun" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 8:32 AM Subject: picking up form variables on the action page?? I have a form page and I am dynamically generating field names from my database like so: cfform cfinput name="Reference_#ReferenceID#" Submit /cfform in some cases there are 10 input boxes and in otheres there are 2 onput boxes, My question is how can I capture these fields in the action page if I am not aware of there name prior to submitting. Can anyone be of assistance??? -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a message
RE: Newbie trying to understand CFTRANSACTION
Interesting, in CFTRANSACTION you have to reference the same DSN. I wonder how Phil uses multiple DSN's between CFTRANSACTION Tags? Interesting, I wonder why the documentation says; Within one transaction block, you can write queries to more than one database; however, you must commit or rollback the transaction to a particular database prior to writing a query to another database. As long as you handle the isolation properly, you can work with multiple DSNs Philip Arnold 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/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFSCRIPT question
cfscript if (NOT StructKeyExists(SESSION.car, ATTRIBUTES.name)) { do stuff here } else { do other stuff here } /cfscript The "else" is actually optional. But I figured I'd throw it in as an example. Sharon -Original Message- From: Jon Tillman [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Friday, August 25, 2000 3:28 AM Subject: CFSCRIPT question I have the following as cfscript: if (not(structKeyExists(session.cart, attributes.name))) I would like to use it as a CFIF statement. Any ideas how to go about constructing said cfif? -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Help Jon build a network! Looking for giveaway computers parts Current Need: Tape Drive PI/PII processors Email me to find out how you can help *** --- --- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Stored Procedure
I am trying to write a storedproc that does an insert and then returns a value. The problem is this, I pass in about 15 variable as Type="IN" in cfprocparam. Then I want one type="OUT" called UserID. Anyway what do I have to write in the Stored Proc itself to allow that to happen. Thanks, Neil -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Session timeout?
You almost have it, but try to see if a session variable exists. Example: cfif not isdefined("session.access") cflocation url="../login.cfm" /cfif -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 24, 2000 10:01 AM To: [EMAIL PROTECTED] Subject: Session timeout? Hello all. Is there a way to find whether the session timed out.If the session timed out display the logon page. Some like cfif Not isDefined(Session) cflocation ../logon.cfm /cfif but i cant get this work. Appretiate any comments. thanks Joe - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
cfschedule problem
I have a cf page which I schedule to execute one time at 8:00pm. It does its work and then uses CFSCHEDULE to re-schedule itself for 10 minutes in the future. This works great until it gets to midnight. If the new time is past 00:00, the job never runs. When I check in the morning through the administration page, the job is there and everything looks ok. It just never executes. Any ideas? CFSET TheStartDate = DateAdd("n", "10", #Now()#) CFSCHEDULE ACTION="Update" TASK="ProjectOne" OPERATION="HTTPRequest" STARTDATE="#DateFormat(TheStartDate, "m/d/")#" STARTTIME="#TimeFormat(TheStartDate, "HH:MM")#" URL="http://someurl/some.cfm" INTERVAL="Once" REQUESTTIMEOUT="6000" Thanks. John -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Referring to variables
that is correct. i usually do that, as the only variable i don't scope are VARIABLES variables (:)) however, there are some purists that scope everthing. i'm just lazy is all. Chris Olive, DOEHRS Website Administrator -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 24, 2000 10:05 AM To: [EMAIL PROTECTED] Subject: RE: Referring to variables Thanks, Chris! You could refer to it without the scope, though, right? Ter Original Message Follows From: "Olive, Christopher M Mr NMR" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED] Subject: RE: Referring to variables Date: Thu, 24 Aug 2000 09:43:51 -0400 VARIABLES is a scope, similar to FORM and URL. it refers to variable created within the page. Chris Olive, DOEHRS Website Administrator -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 24, 2000 9:27 AM To: [EMAIL PROTECTED] Subject: Referring to variables Okay, another "best practice" question, I guess... I have inherited an application from someone. In going through the code, I notice that this person refers to several variables by using "Variables.(whatever)". I'm assuming "Variables" is a reserverd term? I can't find any documentation on this in my reference books. Why would one choose to reference variables by preceding it this way? For example: CFDIRECTORY ACTION="List" DIRECTORY="mypath" NAME="CurrentDir" cfoutput CFIF #CurrentDir.Name# IS "" CFSET PRODUCTION="TRUE" CFELSE CFSET PRODUCTION="FALSE" /CFIF /cfoutput CFIF #Variables.PRODUCTION# IS "TRUE" ... etc. I would write the IF statement as: CFIF PRODUCTION IS "TRUE"... etc. Why did this other person refer to "Variables.PRODUCTION"? They've done this throughout the code... Thanks! Terri Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Stored Procedure
Are you inserting data into a table which automatically creates an ID (IDENTITY filed)? If so what you want to do is perform the INSERT statement in your SP and then immediately afterwards interrogate the INSERTED table. This is a table which SQL automatically creates with exactly the same structure as the table you are insering into when you are performing an Insert or an Update and it contains all of the rows that you inserted/updated. So, if you are only inserting one row you want. INSERT INTO tablename (filedlist) VALUES(valuelist) SELECT @outputparam = ID FROM INSERTED where @outputparam is your output parameter declared in the SP and in CF -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: 24 August 2000 15:15 To: [EMAIL PROTECTED] Subject: Stored Procedure I am trying to write a storedproc that does an insert and then returns a value. The problem is this, I pass in about 15 variable as Type="IN" in cfprocparam. Then I want one type="OUT" called UserID. Anyway what do I have to write in the Stored Proc itself to allow that to happen. Thanks, Neil -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFSCRIPT question
If we're still talking cfscript: cfscript if (StructKeyExists(SESSION.cart, ATTRIBUTES.name)) { myValue = SESSION.cart[ATTRIBUTES.name]; } else { myValue = "not Defined"; } /cfscript You can refer to structures either throught dot notation: SESSION.cart.item Or with array notation: SESSION.cart[item] (if item is a variable containing the name OR SESSION.cart["item"] (if item is a literal value. Sharon -Original Message- From: Andrea Wasik(CancerSource) [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Friday, August 25, 2000 10:05 AM Subject: RE: CFSCRIPT question How would you then check for a particular value of a key within the same cfif? In other words I am doing something similar where I am checking for the existence of a key but then how do I filter so I get only those whose value is, say, a specific date? Thanks -Original Message- From: David E. Crawford [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 24, 2000 9:00 AM To: [EMAIL PROTECTED] Subject: Re: CFSCRIPT question Oops. Left off a ) Should be cfif not structKeyExists(session.cart, attributes.name) blah /cfif - Original Message - From: "David E. Crawford" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 12:56 Subject: Re: CFSCRIPT question cfif not structKeyExists(session.cart, attributes.name blah /cfif - Original Message - From: "Jon Tillman" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 07:27 Subject: CFSCRIPT question I have the following as cfscript: if (not(structKeyExists(session.cart, attributes.name))) I would like to use it as a CFIF statement. Any ideas how to go about constructing said cfif? -- *** Jon Tillman LINUX USER: #141163 ICQ: 4015362 http://www.eruditum.org [EMAIL PROTECTED] *** Help Jon build a network! Looking for giveaway computers parts Current Need: Tape Drive PI/PII processors Email me to find out how you can help *** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=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=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Using COM with CF
http://www.cfm-resources.com/members/comet/ That site is devoted to making COM and CF work nicely together. It's not too detailed yet, but it has a public forum that I'm sure will get more traffic as time goes by and more people run into COM issues with CF. -Original Message- From: Tom Kim [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 24, 2000 1:18 AM To: CF-Talk Subject: Using COM with CF Hi, I'm new to CF and am using version 4.5.1 of both Studio and Server. I have a COM object that returns a generated integer value. I can use this COM object in any COM enabled Windows app. However, when I try to use in a cfm page I get the following error: An error occurred while evaluating the expression: oASIWeb.SetDataPath("E:\InetPub\wwwroot\SolidData\Data"); oASIWeb.SetDatabase("sdweb"); RetVal = oASIWeb.NewID("USERS"); Error near line 4, column 4. The symbol you have provided (oASIWeb.SetDataPath) is not the name of a function. Built-in functions in ColdFusion have names with no qualifiers, i.e., no periods (.) in them. It appears that CF thinks I'm trying to run one of its functions. My CF code is as follows: CFOBJECT TYPE="COM" NAME="oASIWeb" CLASS="asiweb.asiweb" ACTION="CREATE" CFSCRIPT oASIWeb.SetDataPath("E:\InetPub\wwwroot\SolidData\Data"); oASIWeb.SetDatabase("sdweb"); RetVal = oASIWeb.NewID("USERS"); /CFSCRIPT CFOUTPUT#RetVal#/CFOUTPUT Am I missing something? Do I need to give the IUSR_MachineName account the proper security access? If yes, what? Thanks --Tom Tom Kim Advanced Systems Integration 949-261-5476 949-261-0426 Fax [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: RE: Session timeout?
Thanks Andy, I cant do that cause i an dynamically logging the user. Is there a ways you could say. isDefined(Sessiontimeout)?? or i have to calculate the time the user spends in the app and log them off! --- Original Message --- Andy Ewings [EMAIL PROTECTED] Wrote on Thu, 24 Aug 2000 15:04:50 +0100 -- Set a param in your application.cfm called Session.Loggedin for example with a default of "no" When a user logs in set this variable to yes. Then in your application.cfm also have code that says: cfif Session.Loggedin IS "No" cflocation url="logon.cfm" /cfif -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 24 August 2000 15:01 To: [EMAIL PROTECTED] Subject: Session timeout? Hello all. Is there a way to find whether the session timed out.If the session timed out display the logon page. Some like cfif Not isDefined(Session) cflocation ../logon.cfm /cfif but i cant get this work. Appretiate any comments. thanks Joe - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Session timeout?
Sure .. you could do it with something like this: cflock scope="SESSION" timeout="30" type="READONLY" cfif not isdefined('Session.LoggedIn') cflocation url="../login.cfm" /cfif /cflock Todd Ashworth - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 10:00 AM Subject: Session timeout? | | | Hello all. |Is there a way to find whether the session timed out.If | the session timed out display the logon page. | | Some like | cfif Not isDefined(Session) | cflocation ../logon.cfm | /cfif | | but i cant get this work. | | Appretiate any comments. | | thanks | Joe -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Referring to variables
There is also the consideration that VARIABLES-scoped variables do not need to be CFLOCKED... best, paul At 09:50 AM 8/24/00 -0400, you wrote: They are being very specific so that there is never any ambiguity over which variable they are talking about if there are more than one with the same name in different scopes (ie variables.production and URL.production). Variables comes first in the search order so it isn't THAT necessary... EXCEPT for query variables - they come before "variables". It is said to be faster when you are explicit but since "variables" is the second scope searched it's probably not much faster. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: picking up form variables on the action page??
If it's a textbox, and there's no value, then the FORM.FieldName won't be passed. (Unless I have initialized it with a CFPARAM). I'm sure that's not true - aren't your mistaking it with checkboxes? If a value or string is not entered into a checkbox then the fieldname is still passed - its just passed with a value of "" - ie nothing --- Rich Wild Senior Web Designer --- e-mango.com ltd Tel: 01202 587 400 Lansdowne Place Fax: 01202 587 401 17 Holdenhurst Road Bournemouth Mailto:[EMAIL PROTECTED] BH8 8EW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 24, 2000 3:11 PM To: [EMAIL PROTECTED] Subject: Re: picking up form variables on the action page?? If it's a textbox, and there's no value, then the FORM.FieldName won't be passed. (Unless I have initialized it with a CFPARAM). 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 - Original Message - From: "Neil H." [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 9:52 AM Subject: Re: picking up form variables on the action page?? How are you handling that in your example? Neil - Original Message - From: "Dave Hannum" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 9:46 AM Subject: Re: picking up form variables on the action page?? OK - but what if no value was passed for that form field? You have to decipher what fields had input and what ones have no value. Dave - Original Message - From: "Neil H." [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 9:26 AM Subject: Re: picking up form variables on the action page?? How do you figure, what I was saying is pass the values for the number appended to the end of the variable. Then loop through that list and reference the list element appended to the end of "Reference_" Neil - Original Message - From: "Dave Hannum" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 9:22 AM Subject: Re: picking up form variables on the action page?? Neil, This was simply a BASIC, FUNDAMENTAL way to showing Jason the PRINCIPAL of dynamically grabbing the values. It was not meant for a specific application. Nobody was talking about efficient code - (but if you are, why loop through a bunch of values that may or may not exist? The overhead with the associated CFIF's would be less efficient.) Dave - Original Message - From: "Neil H." [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 8:58 AM Subject: Re: picking up form variables on the action page?? This is another way to do it however it seems less efficient since there could be several other fields in the form. I was assuming this is a much larger form for my suggestion. Neil - Original Message - From: "Dave Hannum" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 8:57 AM Subject: Re: picking up form variables on the action page?? This will loop through all of the submitted fields, capture the field names and display the value. CFLOOP INDEX="myFields" LIST="FORM.FieldNames" CFSET thisFieldName = myFields CFSET thisFieldValue = Evaluate(myFields) CFOUTPUT Field Name: #thisFieldName# br Field Value: #thisFieldValue# p /CFOUTPUT /CFLOOP 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 - Original Message - From: "Jason Glaun" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 8:32 AM Subject: picking
RE: RE: Session timeout?
Yup...this is what I do in mine.. !--- Clear client varaible if no activity in past 30 mins --- cfif DateDiff("n", Client.LastVisit, Now()) GTE 30 cfquery Name="DelClientVars" datasource="DSN" MAXROWS=1 DELETE FROM CDATA WHERE CFID = '#Cookie.CFID#:#Cookie.CFToken#' AND APP = 'CVBuilder' /cfquery /cfif OK I am using Clent management and it is being stored in a SQL database but you get the idea -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 24 August 2000 15:27 To: [EMAIL PROTECTED] Subject: RE: RE: Session timeout? Thanks Andy, I cant do that cause i an dynamically logging the user. Is there a ways you could say. isDefined(Sessiontimeout)?? or i have to calculate the time the user spends in the app and log them off! --- Original Message --- Andy Ewings [EMAIL PROTECTED] Wrote on Thu, 24 Aug 2000 15:04:50 +0100 -- Set a param in your application.cfm called Session.Loggedin for example with a default of "no" When a user logs in set this variable to yes. Then in your application.cfm also have code that says: cfif Session.Loggedin IS "No" cflocation url="logon.cfm" /cfif -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 24 August 2000 15:01 To: [EMAIL PROTECTED] Subject: Session timeout? Hello all. Is there a way to find whether the session timed out.If the session timed out display the logon page. Some like cfif Not isDefined(Session) cflocation ../logon.cfm /cfif but i cant get this work. Appretiate any comments. thanks Joe - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Stored Procedure
Right, but I think I am missing how to set the outputparam as output in the Stored Procedure? What is the syntax to set it as an out param? Thanks, Neil - Original Message - From: "Andy Ewings" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 10:22 AM Subject: RE: Stored Procedure Are you inserting data into a table which automatically creates an ID (IDENTITY filed)? If so what you want to do is perform the INSERT statement in your SP and then immediately afterwards interrogate the INSERTED table. This is a table which SQL automatically creates with exactly the same structure as the table you are insering into when you are performing an Insert or an Update and it contains all of the rows that you inserted/updated. So, if you are only inserting one row you want. INSERT INTO tablename (filedlist) VALUES(valuelist) SELECT @outputparam = ID FROM INSERTED where @outputparam is your output parameter declared in the SP and in CF -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: 24 August 2000 15:15 To: [EMAIL PROTECTED] Subject: Stored Procedure I am trying to write a storedproc that does an insert and then returns a value. The problem is this, I pass in about 15 variable as Type="IN" in cfprocparam. Then I want one type="OUT" called UserID. Anyway what do I have to write in the Stored Proc itself to allow that to happen. Thanks, Neil -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Yet another filesize question
I know there has been a lot of talk about this subject lately, but none of the threads directly answered my question. I know that I can determine a file's size AFTER it has been uploaded, but I would like to prevent someone from uploading a 100MB file, and then have to delete it after it has bogged down the server. Once I have selected a file to upload with a FILE input, can I determine the value of the path to the selected file in order to do a CFDIRECTORY on the path and determine the size, thus preventing the upload all together? Maybe with Perl or JavaScript? You can't determine the size of the file before it has been uploaded, unless you're going to install some special software on the client (ActiveX or Java components, perhaps) which would do this for you. If you're using a regular file upload form, though, there's no way to do this. CFDIRECTORY, like other CFML tags, executes on the server, allowing you to manipulate the filesystem on the server, not the client. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Stored Procedure
Create your stored proc as follws.. CREATE PROCEDURE (procedure name AS @inputparam1datatype @inputparam2datatype @inputparam3datatype .. .. @outputparamdatatype OUT BEGIN INSERT INTO tablename (filedlist) VALUES(valuelist) SELECT @outputparam = ID FROM INSERTED END GO Then in your CF you set up a CFPROCPARAM as type OUT. Remeber that you must have the parameters declare in the same order in CF as you do in the SP -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: 24 August 2000 15:48 To: [EMAIL PROTECTED] Subject: Re: Stored Procedure Right, but I think I am missing how to set the outputparam as output in the Stored Procedure? What is the syntax to set it as an out param? Thanks, Neil - Original Message - From: "Andy Ewings" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 10:22 AM Subject: RE: Stored Procedure Are you inserting data into a table which automatically creates an ID (IDENTITY filed)? If so what you want to do is perform the INSERT statement in your SP and then immediately afterwards interrogate the INSERTED table. This is a table which SQL automatically creates with exactly the same structure as the table you are insering into when you are performing an Insert or an Update and it contains all of the rows that you inserted/updated. So, if you are only inserting one row you want. INSERT INTO tablename (filedlist) VALUES(valuelist) SELECT @outputparam = ID FROM INSERTED where @outputparam is your output parameter declared in the SP and in CF -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: 24 August 2000 15:15 To: [EMAIL PROTECTED] Subject: Stored Procedure I am trying to write a storedproc that does an insert and then returns a value. The problem is this, I pass in about 15 variable as Type="IN" in cfprocparam. Then I want one type="OUT" called UserID. Anyway what do I have to write in the Stored Proc itself to allow that to happen. Thanks, Neil -- -- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
SkillBuilding with ColdFusion
Has anyone had any experience with the interactive training CD that is available from Allaire called "SkillBuilding with ColdFusion"? I am about ready to order it, but want some feedback on the product before I commit. Tim Claremont Xerox Corporation -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
IsDefined() problems
Just a quickie. I have taken to coding in this way (when I think var may be undefined): cfparam name="var" default="" cfif var eq "" ... do something ... /cfif instead of: cfif IsDefined(var) ... do something ... /cfif Does anyone else have trouble with IsDefined() or is it just me using it wrong? Paul -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Switch Statement in CFSCRIPT
This is a multi-part message in MIME format. --=_NextPart_000_0015_01C00DBB.414D3C00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am having a problem with switch statement in a cfscript block. It is = always executing the last case, no matter what happens. I have tried = several different things and none of them seem to work. I have checked = that the switch expression is one of the cases and the statement seems = to disregard the variable. Any ideas? I have done this with and without #'s around result and with and without = the { } in the cases. THANK YOU!! switch (#result#) { case 0: { a =3D "u"; f =3D "webbox"; o =3D url.webreq; if(q.accref is 'A') { page =3D "editacc"; } else { page =3D "editref"; } file =3D "editboxd.cfm"; } case 2: { a =3D "i"; f =3D "webbox"; o =3D url.webreq; page =3D "warn"; file =3D "editboxd.cfm5"; } } --=_NextPart_000_0015_01C00DBB.414D3C00 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1" META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2I am having a problem with switch = statement in a=20 cfscript block.nbsp; It is always executing the last case, no matter = what=20 happens.nbsp; I have tried several different things and none of them = seem to=20 work.nbsp; I have checked that the switch expression is one of the = cases and=20 the statement seems to disregard the variable.nbsp; Any = ideas?/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2I have done this with and without #'s = around result=20 and with and without the { } in the cases.nbsp;nbsp; THANK = YOU!!/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2switch (#result#)=20 {BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; case=20 0:BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;=20 {BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; = a =3D=20 "u";BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp= ; f =3D=20 "webbox";BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;= nbsp;=20 o =3D=20 url.webreq;BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbs= p;nbsp;=20 if(q.accref is 'A')=20 {BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;n= bsp;nbsp;nbsp;nbsp;=20 page =3D=20 "editacc";BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp= ;nbsp;=20 }BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; = else=20 {BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;n= bsp;nbsp;nbsp;nbsp;=20 page =3D=20 "editref";BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp= ;nbsp;=20 }BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; = file =3D=20 "editboxd.cfm";BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;=20 }BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; case=20 2:BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;=20 {BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; = a =3D=20 "i";BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp= ; f =3D=20 "webbox";BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;= nbsp;=20 o =3D=20 url.webreq;BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbs= p;nbsp;=20 page =3D=20 "warn";BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;n= bsp;=20 file =3D "editboxd.cfm5";BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;=20 }/FONT/DIV DIVFONT face=3DArial size=3D2}/FONT/DIV/BODY/HTML --=_NextPart_000_0015_01C00DBB.414D3C00-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT: A unit of measure known as a 'Reynolds'
We were having a discussion on how to measure the performance of web servers and was wondering if anybody had come up with a valid way to do this? For example, you can determine how good a 3D graphics card is based on number of polygons and refresh rates at different resolutions. So in theory it should be possible to get a Web Hosting company to quote what 'delivery' level over a 20 second period (here as known as a Reynolds) you are guaranteed to get. For example you could define the ability to deliver web content based on the server (which would be measured assuming a 100MB or higher connection) in k-reynolds. You would need to define a standard page (say 30k with 19 graphics). You would then have a to consider 'reynolds division factors'. Number of websites, server connection to the web (any others). You would then need to consider other 'reynolds division factors'. The type of application servers that were on the host as well (ColdFusion, PHP, ASP etc). You could then come up with a Reynolds Index for a specific machine and could possibly get a guarantee from a hosting company to indicate that the reynolds index for a hosted web site would not go above a certain 'factor'. What do you think? Would this be workable? Adam 'Reynolds' (of course!) ** This email and any attachments are confidential and solely for the use of the intended recipient. They may contain material protected by legal professional or other privilege. If you are not the intended recipient or the person responsible for delivering to the intended recipient, you are not authorised to and must not disclose, copy, distribute or retain this email or its attachments. Although this email and its attachments are believed to be free of any virus or other defect, it is the responsibility of the recipient to ensure that they are virus free and no responsibility is accepted by the company for any loss or damage arising from receipt or use thereof. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: IsDefined() Problem
Figured it out (taken me months!) I need to put quotes in, which seems a bit irish to me as all other functions (those I can think of off the top of my head) you don't put the quotes in when putting in a variable. Sorry to bother you! Paul -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Yet another filesize question
Thanks Dave. JM -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: 24/08/00 10:52 AM Subject: RE: Yet another filesize question I know there has been a lot of talk about this subject lately, but none of the threads directly answered my question. I know that I can determine a file's size AFTER it has been uploaded, but I would like to prevent someone from uploading a 100MB file, and then have to delete it after it has bogged down the server. Once I have selected a file to upload with a FILE input, can I determine the value of the path to the selected file in order to do a CFDIRECTORY on the path and determine the size, thus preventing the upload all together? Maybe with Perl or JavaScript? You can't determine the size of the file before it has been uploaded, unless you're going to install some special software on the client (ActiveX or Java components, perhaps) which would do this for you. If you're using a regular file upload form, though, there's no way to do this. CFDIRECTORY, like other CFML tags, executes on the server, allowing you to manipulate the filesystem on the server, not the client. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
JavaScript Open New Window in ColdFusion template!!
Hello All, I hope that you can give me hand with this annoying little problem that I am having, I need to open up a new window containing some HTML forms using JavaScript. I can get the script to work on a HTML page standalone, but when I embed the script in a table on my cfm template the link opens up a window with no data and the URL contains the script! My function is as follows: SCRIPT type="text/javascript" !-- function newwindow(){ window.open(url,'CC','toolbar=no,location=no,scrollbars=no,directories=no,me nubar=no,resizable=yes,width=550,height=450'); } // -- /script My JavaScript link is as follows: a href="javascript:newwindow(url='newwindow.htm')" On looking at the debug information after the blank page is opened the JavaScript link is followed by a ColdFusion link, which is the same link as the preceding page. My question is what am I doing wrong and why does the ColdFusion link appear after the JavaScript link? Any help on this would be greatly appreciated. Many Thanks in advance Anthony Caroleo -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: cfcontent uncertainty
That first example that uses the cfheader is exactly what i need to happen on my site, and it doesn't work at all. I actually copied your code (modified the query of course) to a tee and it still doesn't do anything. I get a blank page. Your example works flawlessly - I just don't get it. Thanks though. Make sure you don't have any output in your page prior to your CFCONTENT tag. If that's not the problem, try posting the code and the URL, and I'll see if I can figure out the problem. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: IsDefined() problems
I have the same issue and am using the same workaround, I am on CF4.5 NT 4 sp 6a IIS 4 Kevin -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 24, 2000 10:57 AM To: Cf-Talk Subject: IsDefined() problems Just a quickie. I have taken to coding in this way (when I think var may be undefined): cfparam name="var" default="" cfif var eq "" ... do something ... /cfif instead of: cfif IsDefined(var) ... do something ... /cfif Does anyone else have trouble with IsDefined() or is it just me using it wrong? Paul -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: IsDefined() problems
Nope I don't have a problem with it. Make sure the var is in quotes: ISDefined("var") -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: 24 August 2000 15:57 To: Cf-Talk Subject: IsDefined() problems Just a quickie. I have taken to coding in this way (when I think var may be undefined): cfparam name="var" default="" cfif var eq "" ... do something ... /cfif instead of: cfif IsDefined(var) ... do something ... /cfif Does anyone else have trouble with IsDefined() or is it just me using it wrong? Paul -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: picking up form variables on the action page??
my advise would be to create one variable containg all the references you need generate a list cfset thelist= "" cfform cfinput name="Reference_#ReferenceID#" Submit cfset thelist = thelist reference "," /cfform then use cfloop list="#thelist#" index="currentreference" It is faster and more efficiant than input types hidden -Message d'origine- De: Jason Glaun [SMTP:[EMAIL PROTECTED]] Date: Thursday, August 24, 2000 8:33 AM À:[EMAIL PROTECTED] Objet:picking up form variables on the action page?? I have a form page and I am dynamically generating field names from my database like so: cfform cfinput name="Reference_#ReferenceID#" Submit /cfform in some cases there are 10 input boxes and in otheres there are 2 onput boxes, My question is how can I capture these fields in the action page if I am not aware of there name prior to submitting. Can anyone be of assistance??? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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?sidebarRstsbodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: picking up form variables on the action page??
If no form variables are passed, then form.fieldnames will not be defined. IsDefined('form.fieldnames') = False If a checkbox exists in a form and is not checked when the form is processed, then the checkbox variable will not be defined. IsDefined('form.CheckboxVariableName') = False As for a textbox with no value entered, the variable will be defined but will have a value of "". IsDefined('form.TextboxVariableName') = True TextBoxVariableName = "" - If it's a textbox, and there's no value, then the FORM.FieldName won't be passed. (Unless I have initialized it with a CFPARAM). I'm sure that's not true - aren't your mistaking it with checkboxes? If a value or string is not entered into a checkbox then the fieldname is still passed - its just passed with a value of "" - ie nothing ubscribe' in the body. Clint R. Tillerson Meteorologist/Programmer Pacific Environmental Services, Inc. 5001 South Miami Blvd. PO Box 12077 RTP, NC 27709 (919) 941-0333 Fax: (919) 941-0234 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: JavaScript Open New Window in ColdFusion template!!
Hey Anthony I'm using this and it's working like a charm: script language="JavaScript" function showDocument(act,id) { var link; var accept = true; if (act == 'E' || act == 'A') link = 'edit.cfm?ID=' + id; { MyWin = window.open(link,"Docs","toolbar=no,scrollbars=yes,resizable=yes,location=no ,directories=no,status=no,menubar=no,width=300,height=400"); MyWin.focus(); } } /script and the link looks like: td valign="top"A href="javascript:showDocument('E',#docs_id#)"Edit/a/td Hope this helps, Katie -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Combining Application.cfm with other CFINCLUDE's
Hi again, I tried Al Musella's idea of eliminating the extra and HEAD tags. Since three files are involved in the whole process there are three sets ... then I put the Application.cfm back in place got the same error. Here is the only tag currently living in my Application.cfm file (I was just getting started with the daunting task of figuring out how to "turn on," assign, and store variables ... yikes!). But this is as far as I got: CFAPPLICATION NAME="marksport" SESSIONMANAGEMENT="Yes" SETCLIENTCOOKIES="Yes" SESSIONTIMEOUT="(52,0,0,0)" Here is the error I get... Error Diagnostic Information Attribute APPLICATIONTIMEOUT in tag CFAPPLICATION has an invalid value Cannot convert (0,0,2,0) to number. Please, check the ColdFusion manual for the allowed conversions between data types The error occurred while processing an element with a general identifier of (CFAPPLICATION), occupying document position (1:1) to (4:46). The specific sequence of files included or processed is: E:\InetPub\wwwroot\marksport.com\Application.cfm I know there's an invalid character in there, or something missing... I tried adding # around the sessiontimeout variable but then I get another error... Error Diagnostic Information Just in time compilation error Invalid parser construct found on line 4 at position 39. ColdFusion was looking at the following text: , Invalid expression format. The usual cause is an error in the expression structure. The last successfully parsed CFML construct was a CFAPPLICATION tag occupying document position (1:1) to (1:14). The specific sequence of files included or processed is: E:\InetPub\wwwroot\marksport.com\Application.cfm I am s lost...!! In a message dated 08/23/2000 4:23:21 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: I'm thinking it has less to do with what is cfincluded and more to do with whatever is in your Application.cfm. Lots of people, myself included, build sites that are nothing but pages included in other pages. Maybe if you posted the contents of your Application.cfm ... ? Todd Ashworth -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Dates
If I use this? cfset todayDate = Now() cfset ttoday = #DateFormat(todayDate, "m/dd/yy")# Will months with 2 digits appear with 2 digits? IE 10/10/00? thanks, Pete -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SkillBuilding with ColdFusion
I used it when I was FIRST starting CF development. It is REALLY basic. Even as my first true CF exposure, it was REALLY REALLY simplistic. I don't remember how much it cost, but if you have any background in CF already, there isn't much point in it. However, if you have never even written a CFQUERY and the price is right, it is a good intro. If you have any web knowledge at all, you can probably crank thru it in about 15 minutes. jake -Original Message- From: Claremont, Timothy S [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 24, 2000 9:55 AM To: '[EMAIL PROTECTED]' Subject: SkillBuilding with ColdFusion Has anyone had any experience with the interactive training CD that is available from Allaire called "SkillBuilding with ColdFusion"? I am about ready to order it, but want some feedback on the product before I commit. Tim Claremont Xerox Corporation -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: SkillBuilding with ColdFusion
In a message dated 08/24/2000 11:04:33 AM Eastern Daylight Time, [EMAIL PROTECTED] writes: Has anyone had any experience with the interactive training CD that is available from Allaire called "SkillBuilding with ColdFusion"? I am about ready to order it, but want some feedback on the product before I commit. I just finished going through it. I felt I needed to reinforce what I saw in Fast Track to Cold Fusion. There are a lot of details that are not explained in any way by the tutorial (regarding HOW or WHY they work, just "do it this way.") And there are several typos in the code that absolutely DROVE ME CRAZY. But I did troubleshoot all of them make everything work. That boosted my confidence in itself. But I didn't really have the time to spend doing it. When all was said and done, it did not come up to the skill level of the challenges I am facing (but then, neither do I LOL). I would recommend it for someone who is just starting out has a mentor handy to help with the kinks. I'd be happy to share my typo annotations if it would be of any value. :-) Oriole -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Combining Application.cfm with other CFINCLUDE's
Try... CFAPPLICATION NAME="marksport" SESSIONMANAGEMENT="Yes" SETCLIENTCOOKIES="Yes" SESSIONTIMEOUT="#CreateTimeSpan(52,0,0,0)#" -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 24 August 2000 16:21 To: [EMAIL PROTECTED] Subject: Re: Combining Application.cfm with other CFINCLUDE's Hi again, I tried Al Musella's idea of eliminating the extra and HEAD tags. Since three files are involved in the whole process there are three sets ... then I put the Application.cfm back in place got the same error. Here is the only tag currently living in my Application.cfm file (I was just getting started with the daunting task of figuring out how to "turn on," assign, and store variables ... yikes!). But this is as far as I got: CFAPPLICATION NAME="marksport" SESSIONMANAGEMENT="Yes" SETCLIENTCOOKIES="Yes" SESSIONTIMEOUT="(52,0,0,0)" Here is the error I get... Error Diagnostic Information Attribute APPLICATIONTIMEOUT in tag CFAPPLICATION has an invalid value Cannot convert (0,0,2,0) to number. Please, check the ColdFusion manual for the allowed conversions between data types The error occurred while processing an element with a general identifier of (CFAPPLICATION), occupying document position (1:1) to (4:46). The specific sequence of files included or processed is: E:\InetPub\wwwroot\marksport.com\Application.cfm I know there's an invalid character in there, or something missing... I tried adding # around the sessiontimeout variable but then I get another error... Error Diagnostic Information Just in time compilation error Invalid parser construct found on line 4 at position 39. ColdFusion was looking at the following text: , Invalid expression format. The usual cause is an error in the expression structure. The last successfully parsed CFML construct was a CFAPPLICATION tag occupying document position (1:1) to (1:14). The specific sequence of files included or processed is: E:\InetPub\wwwroot\marksport.com\Application.cfm I am s lost...!! In a message dated 08/23/2000 4:23:21 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: I'm thinking it has less to do with what is cfincluded and more to do with whatever is in your Application.cfm. Lots of people, myself included, build sites that are nothing but pages included in other pages. Maybe if you posted the contents of your Application.cfm ... ? Todd Ashworth -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Join vs Union Perference
Which is a better perference, using a Join or Union? I need to link together several tables so I can build an excel spreadsheet Thanks for the direction. Jim Ray -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Switch Statement in CFSCRIPT
You need a "break" command at the end of each case - Original Message - From: "FWA" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 9:05 AM Subject: Switch Statement in CFSCRIPT This is a multi-part message in MIME format. --=_NextPart_000_0015_01C00DBB.414D3C00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am having a problem with switch statement in a cfscript block. It is = always executing the last case, no matter what happens. I have tried = several different things and none of them seem to work. I have checked = that the switch expression is one of the cases and the statement seems = to disregard the variable. Any ideas? I have done this with and without #'s around result and with and without = the { } in the cases. THANK YOU!! switch (#result#) { case 0: { a =3D "u"; f =3D "webbox"; o =3D url.webreq; if(q.accref is 'A') { page =3D "editacc"; } else { page =3D "editref"; } file =3D "editboxd.cfm"; } case 2: { a =3D "i"; f =3D "webbox"; o =3D url.webreq; page =3D "warn"; file =3D "editboxd.cfm5"; } } --=_NextPart_000_0015_01C00DBB.414D3C00 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1" META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT face=3DArial size=3D2I am having a problem with switch = statement in a=20 cfscript block.nbsp; It is always executing the last case, no matter = what=20 happens.nbsp; I have tried several different things and none of them = seem to=20 work.nbsp; I have checked that the switch expression is one of the = cases and=20 the statement seems to disregard the variable.nbsp; Any = ideas?/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2I have done this with and without #'s = around result=20 and with and without the { } in the cases.nbsp;nbsp; THANK = YOU!!/FONT/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2/FONTnbsp;/DIV DIVFONT face=3DArial size=3D2switch (#result#)=20 {BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; case=20 0:BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;=20 {BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; = a =3D=20 "u";BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp= ; f =3D=20 "webbox";BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;= nbsp;=20 o =3D=20 url.webreq;BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbs= p;nbsp;=20 if(q.accref is 'A')=20 {BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;n= bsp;nbsp;nbsp;nbsp;=20 page =3D=20 "editacc";BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp= ;nbsp;=20 }BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; = else=20 {BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;n= bsp;nbsp;nbsp;nbsp;=20 page =3D=20 "editref";BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp= ;nbsp;=20 }BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; = file =3D=20 "editboxd.cfm";BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;=20 }BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; case=20 2:BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;=20 {BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; = a =3D=20 "i";BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp= ; f =3D=20 "webbox";BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;= nbsp;=20 o =3D=20 url.webreq;BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbs= p;nbsp;=20 page =3D=20 "warn";BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;n= bsp;=20 file =3D "editboxd.cfm5";BRnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;=20 }/FONT/DIV DIVFONT face=3DArial size=3D2}/FONT/DIV/BODY/HTML --=_NextPart_000_0015_01C00DBB.414D3C00-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SkillBuilding with ColdFusion
If you're a beginner, Skillbuilding is a GREAT way to get started. I bought it right off the bat, and went through it from beginning to end in three nights after work. By the time I was finished, I knew ColdFusion was the thing I was looking for to get me excited about leaving my job in Test Engineering to go back into development. I enrolled in the FastTrack class very soon after, and I was much better prepared for the class than some of the people who had no experience at all with CF. So if you're a newbie, Skillbuilding is well worth the cost. CFUG-SFL Manager -Kev /CFUG-SFL Manager -Original Message- From: Claremont, Timothy S [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 24, 2000 10:55 AM To: '[EMAIL PROTECTED]' Subject: SkillBuilding with ColdFusion Has anyone had any experience with the interactive training CD that is available from Allaire called "SkillBuilding with ColdFusion"? I am about ready to order it, but want some feedback on the product before I commit. Tim Claremont Xerox Corporation -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: picking up form variables on the action page??
If it's a textbox, and there's no value, then the FORM.FieldName won't be passed. (Unless I have initialized it with a CFPARAM). Checkboxes and Radio Buttons are the only ones not passed if they are empty (unclicked) An empty text/textarea will pass a blank string Then again, it's probably best to CFPARAM all form. scope variables for the form... Philip Arnold 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/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SkillBuilding with ColdFusion
SkillBuilding is a well put together training tool. However, if you have any amount of CF development experience, you may not benefit from it as it is quite basic. You may also choose to visit a local CFUG, which may have copies to lend to members. JM -Original Message- From: Claremont, Timothy S To: '[EMAIL PROTECTED]' Sent: 24/08/00 10:55 AM Subject: SkillBuilding with ColdFusion Has anyone had any experience with the interactive training CD that is available from Allaire called "SkillBuilding with ColdFusion"? I am about ready to order it, but want some feedback on the product before I commit. Tim Claremont Xerox Corporation -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: IsDefined() Problem
Glad I'm not irish, I might have been offended... JM -Original Message- From: Paul Johnston To: Cf-Talk Sent: 24/08/00 11:01 AM Subject: RE: IsDefined() Problem Figured it out (taken me months!) I need to put quotes in, which seems a bit irish to me as all other functions (those I can think of off the top of my head) you don't put the quotes in when putting in a variable. Sorry to bother you! Paul -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: SkillBuilding with ColdFusion
I have used the SkillBuilding CD. It's very basic and good for an introduction to the basic uses of SQL and CF in a web page. If you already have experience in DBs and HTML I'd suggest just doing a couple practice projects with searches and simple logic etc., which is basically what the CD does. There is absolutely no thinking involved in the CD. It holds your hand through the easiest steps and goes at a slow pace. You're best off making your own training exercises for new users or picking up a book and doing little projects, which we have begun to do. - Original Message - From: "Claremont, Timothy S" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 9:55 AM Subject: SkillBuilding with ColdFusion Has anyone had any experience with the interactive training CD that is available from Allaire called "SkillBuilding with ColdFusion"? I am about ready to order it, but want some feedback on the product before I commit. Tim Claremont Xerox Corporation -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Join vs Union Perference
Which is a better perference, using a Join or Union? Jim A Join links tables horizontally and a Union links them vertically, if you see what I mean. You can only Join tables if they have a column in common ("foreign key"). You can only Union tables if they have identical columns. Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Join vs Union Perference
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 They're used for different things. If you have a bunch of table with the exact same fields in them that you need to lump together, do a UNION. If you have different fields in the tables need to get parts of various tables all put together (most likely the case), then you need to use JOIN. Best regards, Zac Bedell -Original Message- From: Ray, James A [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 24, 2000 11:33 AM To: [EMAIL PROTECTED] Subject: Join vs Union Perference Which is a better perference, using a Join or Union? I need to link together several tables so I can build an excel spreadsheet Thanks for the direction. Jim Ray -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=list s/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.3 for non-commercial use http://www.pgp.com Comment: Please use PGP!!! iQA/AwUBOaVDFAraVoMWBwRBEQJ8DwCg2+BQMvEQZsTPkNQjXJsNvOd6gxAAnj75 4zYFo5ClpA3nisAIji6K3Mfe =OQ66 -END PGP SIGNATURE- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: IsDefined() problems
Are you remembering to enclose the variable in quotations marks? cfif IsDefined("var") ... /cfif Marianne -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 24, 2000 10:57 AM To: Cf-Talk Subject: IsDefined() problems Just a quickie. I have taken to coding in this way (when I think var may be undefined): cfparam name="var" default="" cfif var eq "" ... do something ... /cfif instead of: cfif IsDefined(var) ... do something ... /cfif Does anyone else have trouble with IsDefined() or is it just me using it wrong? Paul -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: cfcontent uncertainty
http://207.208.210.117/beta/transcriptioncenter/test2.cfm here is the code CFHEADER NAME="Content-Disposition" value="inline; filename=D:\Attachments\ACF116.doc" CFCONTENT TYPE="application/unknown"this is a test I don't know what the significance of using that cfcontent is, but I threw it in there. I also tried the page without the cfcontent, and it results in a blank page with no source. Thanks Dave. -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 24, 2000 10:00 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: cfcontent uncertainty That first example that uses the cfheader is exactly what i need to happen on my site, and it doesn't work at all. I actually copied your code (modified the query of course) to a tee and it still doesn't do anything. I get a blank page. Your example works flawlessly - I just don't get it. Thanks though. Make sure you don't have any output in your page prior to your CFCONTENT tag. If that's not the problem, try posting the code and the URL, and I'll see if I can figure out the problem. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Join vs Union Perference
I'd use join and make sure you use the correct type of join(INNER, LEFT OUTER, RIGHT OUTER) -Original Message- From: Ray, James A [mailto:[EMAIL PROTECTED]] Sent: 24 August 2000 16:33 To: [EMAIL PROTECTED] Subject: Join vs Union Perference Which is a better perference, using a Join or Union? I need to link together several tables so I can build an excel spreadsheet Thanks for the direction. Jim Ray -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.