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 = "" Yeah. Thought so. Cheers Clint. --- 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. --- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: netscape taking a long time to render page
> hey guys,i've got a page here that is taking a very very long time to > render in NS (after it has downloaded) i know its because of some tag > formating, but i cant seem to find it. all my tables check out as far as i > can tell.. can i get a few more sets of eyes to take a look at the html & > possibly show me what i've done wrong? > > heres the url for the html output of the page thats giving me a problem: > > http://www.yarooze.com/kitehigh/testNSproblem.cfm > HTTP/1.0 404 Object Not Found -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Grab image size with CFFile object attributes
http://devex.allaire.com/developer/gallery/info.cfm?ID=CA34726E-2830-11D4-AA 9700508B94F380&method=Full CFX_GifGD is what you need. Very very cool tag. Does mountains of stuff. A godsend. There are others though. --- 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: Mark Smeets [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 25, 2000 5:45 AM > To: [EMAIL PROTECTED] > Subject: Grab image size with CFFile object attributes > > > Question, you can grab a file size in a CFFile tag when you upload a > file/image but can you also grab the image height and width? > > I could guess but I'm not entirely sure. It makes sense to > have something > like this. > > Mark Smeets/stranger0/ICQ #1062196 > > "Mr. West, not every situation requires your patented > approach of shoot > first, shoot later, shoot some more and then when everybody's > dead try to > ask a question or two" - Wild Wild West > > Other Press Webslinger *New and Improved* > http://otherpress.douglas.bc.ca/ > > Official Splitting Adam Homepage > http://www.splittingadam.com/ > > Over the Wall Productions and Web Designs > http://www.solarcourt.com/ > > __ > ___ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Please hack me, others are....
> Help, > > Last week we launch a new on line game, people seem to want the > free trip... > they have successfully hacked it. > > It's a ColdFusion/SQL7 driven site with the game in Flash. CF and > Flash send > security and score information back and forth. > > Somehow, despite not being able to play more than once, and if they do the > players score doesn't increase until the next day. People are running up > really high scores, like a million points when the highest > possible cum for > the contest until today is 500. > > Please take a moment and see if you can run up a score and if so, how. > > I'm on a few hours sleep this week on another deadline, so if this email > isn't clear please let me know. Otherwise have fun. > > http://www.lossimpson.com Click on the Bart Bowl game. Don't have time right now, but, as example, a few years ago I hacked the tv show The Profiler's special online game about jack the serial killer. You were supposed to fine 9(?) items scattered about the site. Of course they kept score client site via cookies. I simply went into netscape's cookie.txt file, and found the variable's their site was creating. It was _instantly_ obvious to me they were bit encoding the items, so changed the number's boolean flags to give me everything and saved the cookie.txt. Started the browser up. I won. Think I was second there. (Made me feel... like a predatory serial killer, oddly enough. ;-) Point is, are you saving _ANY_ info client side? If it's anything beyond a simple unqiue session id, you're going to be hacked. --min > > Thanks much, > > Rick > > > _ 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Checkboxes....
Hello, This has almost certainly been asked before... so here we go again: I have a form that displays a set of items each with its own checkbox. The number of choices will vary from day to day. The user selects any number of the items displayed and these choices are to be entered into a database. The items come from the database so result from a query e.g. SELECT Item_Name, Item_ID FROM Items WHERE Active=1 then I do something like this to create a set of checkboxes - I don't know how many checkboxes there are so I have to create the names dynamically: #Item_Name# so the next template receives a set of FORM.Choice_1, FORM.Choice_2 and so on which contain the Item_ID values that I need to insert into the database. This where I am stumped - how do I step through those vales in order to insert them? OR perhaps there is a BETTER WAY. I guess I can't do this: INSERT INTO Choices(Items) Values('Choice_#Count#') I could write the Choice_N values to an array Choices[N] then loop over that but there must be a better way Graham -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Checkboxes....
> This has almost certainly been asked before... Yesterday in fact :-) The thread is called "picking up form variables on the action page??" 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
MDCFUG news
You are invited to the Maryland ColdFusion User Group Meeting, on Tuesday 9/12/00 at 6:30pm * What: ColdFusion Users sharing programming tips and code * Cost: FREE (and free pizza too!) * Website: http://www.cfug-md.org/ * Meetings: Second Tuesday of every month. * Where:Rockville MD, near I-270 * Signup: mailto:[EMAIL PROTECTED]?subject=MDCFUG signup Or call us at 301-424-3903 - Michael Smith, TeraTech, TeraTech http://www.teratech.com/ MDCFUG http://www.cfug-md.org/ -- Agenda Here's what's coming up at the MDCFUG meeting this Tuesday, at 6:30 pm: * Tom Folkes of TFolkes.com will speak on "Knowledge Management Tool Using ColdFusion". CyberHiveMind.com is a third generation holographic search tool. It is designed to both provide the user with support in expanding their search and database drill down. * Janaki Naga of Differential Technologies "Firsttime Fusebox project" * MDCFUG Group session "Ideas for CF coding style guide" * Q&A session - bring a floppy with problem or neat code or email it to mailto:[EMAIL PROTECTED]?subject=CF problem for MDCFUG There will be a free MDCFUG coffee mugs for you if you bring some CF code or techniques to the meeting! The meeting is located at: Best Western (Washington Gateway) 1251 W Montgomery Ave Rockville, MD 20850-3198 (301-424-4940 ) For a map or directions go here: http://www.cfug-md.org/directions.cfm To get to the User Group: * Take I-270 to Route 28 (Exit 6B) towards Darnestown. * Turn right at second light (Hurley Ave) and go up "S" bend hill. * Park in the main lot and go in the main hotel entrance. * Once inside the building go past the bar and front desk and vier left - the room is in one of the Salons on the left about 20 meters on. -- *** CF News *** Fusebox FUN 2000 At CFUN-2k this weekend, Steve Nelson of SecretAgents.com and Michael Smith of TeraTech, Inc., announced the first ever Fusebox conference, set for Saturday, September 16, 2000. The conference, sponsored by SecretAgents.com and TeraTech, will be a 9 to 5 FuseFest full of lectures and information about the methodology, and includes a free copy of the forthcoming Fusebox book. Speakers include: Hal Helms, Steve Nelson, Nat Papovich, Gabe Roffman, Fred T. Sanders, Cameron Childress and Michael Smith. Location: Charlottesville, VA, at the Best Western Cavalier Inn, 105 Emmet, Charlottesville, VA 22904-0201. Price of admission is $99, which includes lunch (but not hotel accomodations). For more information http://www.fusebox.org/conference A signup form is in URL above. Also you can sign up by email through [EMAIL PROTECTED] or by calling TeraTech at 1-800-447-9120. CF101 - Back to Basics -- Either learn basic CF or if you are a CF smartie then help other's learn it at this Saturday morning event 9/9/00. http://www.cfconf.org/cf101/ 10 security threats --- Avi Pawar, a CJCFUG member, told us about the SANS Institute's article entitled "How To Eliminate The Ten Most Critical Internet Security Threats". You can read the article, updated August 18, 2000, at: http://www.sans.org/topten.htm Hien Nguyen Central Jersey ColdFusion User Group (CJCFUG) Nullsoft NSCopy --- For website binary file copies that don't zap all your bandwidth... Copy files across network, tweak your own transfer rate, multiple source directories, progress indicators, can auto skip or overwrite existing fields. http://firehose.net/free/nscopy/ The idea came from Tag who needed a means to synchronize his stream machine without overloading the network traffic in order to avoid skipping. The solution was this little copy utility that he and lone coded over a night while drinking coffee, redbulls, and smoking cigarettes at the fire exit every 20 minutes. It allows you to select a list of source directories and a target, and to specify a maximum throughput. Because all great (hmm) things should be free, this should be too. Not only that, we're pretty much giving away all rights to it, giving you the source, and letting you do what you want with it (see the license below). features Multiple source directories Max speed range from 512cps to unlimited (spaceballs mode) Detailed progress indicators (current file, overall) Save/Load directory sets Automatically skips or overwrites existing files Disabled notifications mode Incredible default design window with minimize, close buttons and titlebar. Submitted by David Schroeder. Adam Churvis Seminar *** REGISTRATION CLOSES TOMORROW! *** Advance Registration Only -- No On-Site Registration *** CFUG Members Get In For Less Than Half-Price! (see below) *** All Attendees Get Free CommerceBlocks Softw
RE: Yet another filesize question
> i feel so unloved. :) Chris, we love you. (do they say things like that in the US army?) ** 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Slightly OT - Detecting that a page has completed. - Many Thanks
Don, Here's how it works. We need two tables. One to record the DateTime that a request began. And another table which records when requests complete. For each record in tRequestStart, there may or may not be a record in tRequestComplete depnding on whether the whole page was received at the Client. I'm using MsSQL7, stored procedures and ISS. You may need to use SQL statements in your code if using Access. You'll need MDAC installed to use ADO. Table structure (tRequestStart) iUniqueID int (AutoIncrement) PK iCrewID int DTRequestStart DateTime Table structure (tRequestComplete) iRequestID int PK (NOTE: Not AutoIncrement) iCrewID int DTRequestEnd DateTime I my case, I pick users for a CFTree, so the CFTREEITEMKEY contains the UserID. At the start of the page the user has requested, use the following CF code to call a stored procedure. Change the Datasource name to match yours. You may need to use a CFQUERY depending on DB The SQL for the SP is simple CREATE PROCEDURE sp_InsertReqStartRecord @SUCCESS int OUTPUT, @iCrewID int AS INSERT INTO tRequestStart ( [iCrewID], [DTRequestStart] ) VALUES ( @iCrewID, GETDATE() ) SELECT @SUCCESS = @@IDENTITY This creates the time-stamped record and returns the RecordID, which we use at the end of the page. If you don't have Remote Scripting,it's a small download from Microsoft's Web site from http://www.msdn.microsoft.com/scripting/remotescripting/rsdown.htm You may also need the latest Windows Scripting engine which you can install from any IE5 installation. Now the fairly complex bit. Remote scripting lets you call a function on the server from the client. You create a Active Server Page with the function you will to call from the Client and declare them in a special way. Getting the Server side working was the hardest part for me. Here's the final piece of code that runs on the Client. There a two pieces of JavaScript required. One to enable Remote Scripting and the other to call the Server Side function. 1) Enable Remote Scripting. This should be place immediately after the tag. Note: NOT in the RSEnableRemoteScripting("../_ScriptLibrary/RScripting") I had a lot of problems with paths. The installation of Remote Scripting put stuff into C:\Inetpub\WWWRoot\_ScriptLibrary which is normally in the root level of your Web Server. Try to get samples working with this path before you go copying stuff to other directories, otherwise you'll never figure what's causing errors (coding or path errors). 2) Call the Exported Server Function. This should be the last line of code in your page. You know the user recieved th rest of the page if this script runs. co = RSExecute("LogRosterRequest.asp","logreq",#CFTREEITEMKEY#,#Result#); if (co.return_value ==1) { window.alert("Your Roster Request has been logged."); } Here I'm calling an Exported function called logreq (Javascript is case sensitive) from an Active Server Page called LogRosterRequest.asp. Again be careful with paths. I'm passing in The UserID (#CFTREEITEMKEY#) and the RecordID (#Result#) we got when CF called the stored procedure and created a record in tRequestStart. On the server. Make sure RS.htm, RS.Asp and RSProxy.class exist in c:\inetpub\wwwroot\_scriptlibrary. Finally here is the code for LogRosterRequest.asp which exist in the same directory and the CFM page that get's sent to the Client. <%@ LANGUAGE=VBSCRIPT %> <% Option Explicit %> <% RSDispatch %> var public_description = new MyServerMethods(); function MyServerMethods() { this.logreq = Function( 'n1','n2','return addRecord(n1,n2)' ); } Function addRecord(crewstr,recstr) Dim objCmd Dim objConn ' Data types are converted because they are passed as strings addRosterRecord = 0 Set objConn = Server.CreateObject("ADODB.Connection") Set objCmd = Server.CreateObject("ADODB.Command") objConn.ConnectionString = "PROVIDER=SQLOLEDB" & _ ";SERVER=ServerName;UID=UserName;PWD=Password;DATABASE=DatabaseName" objConn.Open If (objConn.State = adStateOpen) Then Set objCmd.activeconnection=objconn objCmd.CommandText = "sp_InsertReqRecEnd" objCmd.Parameters.Append objCmd.CreateParameter("@SUCCESS", adInteger, adParamOutput, 0, 0) objCmd.Parameters.Append objCmd.CreateParameter("@iCrewID", adInteger, adParamInput, , CInt(crewstr)) objCmd.Parameters.Append objCmd.CreateParameter("@iRecID", adInteger, adParamInput, , CInt(recstr)) objCmd.CommandType = adCmdStoredProc objCmd.Execute addRosterRecord = ObjCmd("@SUCCESS") End if Set ObjCmd.ActiveConnection = Nothing Set ObjCmd = Nothing Set objConn=Nothing End Function You'll to change the ADO connection string to use your Server, Database and log in with a valid Username and Password. This code calls a store procedure which inserts the matching time-stamped record. Here's the Stored procedure. CREATE PROCEDURE sp_Inse
RE: Checkboxes....
Nick, > Yesterday in fact :-) > The thread is called "picking up form variables on the action page??" Thing is I only rejoined the list today. I can see one tail end of that thread but it is only talking about checking the existance of FORM varaiables. Perhaps the start oif the thread refered to my question but I cannot access those messages (they do not seem to be in the archives yet) My question is to do with passing checkbox FORM variables whose names are dynamically generated in the form. I can't send them as as an array (I guess a form variable cannot be an array ... I experimented and it didn't work) without resorting to WDDX or somesuch so I am sending them as Item_1Item_n My problem is is looping through those in the next template and inserting their values into the database. I am trying to write the ones that get passed to an array and then looping through that to do the inserts but it is clunky and anyway doesn't work at the moment. Graham -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Checkboxes....
> Thing is I only rejoined the list today. Sorry Graham, will forward you the thread off list. 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL Trigger / Stored Proc question
> CREATE TRIGGER GetMax_ID ON mytable > FOR INSERT > AS > SELECT mytable_ID FROM INSERTED > > How would I reference the result within a stored procedure to insert > the "mytable_id" in the next query? Neil I don't think you can pass a value out from a trigger - once the trigger is created it exists independently of the rest of your code. But you could put all the logic inside the trigger, or have the trigger call a procedure with all the logic inside it. 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Checkboxes....
Nick, Many many thanks for digging out the thread messages and sending them to me. You are right this is the same question. I don't entirely understand the answer though: I would have a loop within the cfform as I guess is implied above How do the values of the selected checkboxes get added to the list before the submit button is pressed and how is that list passed to the next template - as an ? or are we ignoring the normal checkbox FORM values and using the list instead? Graham > > This has almost certainly been asked before... > Yesterday in fact :-) > The thread is called "picking up form variables on the action page??" -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: SQL Trigger / Stored Proc question
> I don't think you can pass a value out from a trigger - once the trigger sure you can. you can reference its value in queryName.mytable_ID -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: How do I get my Current URL
Hmm. Only partly works for me. Only the the #CGI.SERVER_NAME# part returns anything Same problem with #CGI.SCRIPT_NAME# amd #CGI.QUERY_STRING# suggested by somebody else > The following works within a CF page: > > Current URL is http://#CGI.SERVER_NAME##CGI.PATH_INFO# > > Hope this helps > H Larry Juncker > L Senior Cold Fusion Programmer > I Heartland Communications Group > Internet Division > > ] > -Original Message- > From: Mark Armendariz [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 24, 2000 10:58 AM > To: Cf-Talk > Subject: How do I get my Current URL > > > I've done this 100's of times, and I've drawn a blank. How do I get the > current URL of the page I'm working on (full URL with parameters) within a > variable? I'm trying to do a "Print This Page" button which will, with an > additional parameter of &Print=1, kill the menus and titles and print the > page. I have all the javascript and other functionality in place, I just > need the link that refers to the currentpage with the added parameter. > > Thanks... > > > > Mark Armendariz > Righteous Design > > www.sorighteous.com > > > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > > > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or s end a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: How do I get my Current URL
I take it back: http://#CGI.SERVER_NAME##CGI.PATH_INFO##CGI.SCRIPT_NA ME#?#CGI.QUERY_STRING# does work perfectly On 24 Aug 00, at 15:05, Chapman, Katrina wrote: > Don't know of one off the top of my head but you could build it using three > CGI variables. Server_name, Script_name, and query_string > > Just concatenate those in that order and you'll have it. > > --K > > -Original Message- > From: Mark Armendariz [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 24, 2000 8:58 AM > To: Cf-Talk > Subject: How do I get my Current URL > > > I've done this 100's of times, and I've drawn a blank. How do I get the > current URL of the page I'm working on (full URL with parameters) within a > variable? I'm trying to do a "Print This Page" button which will, with an > additional parameter of &Print=1, kill the menus and titles and print the > page. I have all the javascript and other functionality in place, I just > need the link that refers to the currentpage with the added parameter. > > Thanks... > > > > Mark Armendariz > Righteous Design > > www.sorighteous.com > > > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or s end a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL Trigger / Stored Proc question
> > I don't think you can pass a value out from a trigger - once the trigger > > sure you can. you can reference its value in queryName.mytable_ID But what is the query that queryName refers to? If you say CREATE TRIGGER...AS SELECT mytable_ID... then what is executed is the CREATE TRIGGER statement, i.e. it stores the trigger in the database. The trigger only *fires* when a row is inserted. Are you saying that CF is clever enough to pick up the fact that the trigger has fired & grab the value from somewhere? The SQL Server documentation says: Triggers can include any number and kind of Transact-SQL statements except SELECT. A trigger is designed to check or change data based on a data modification statement; it should not return data to the user. ... To eliminate having results returned to an application due to a trigger firing, do not include either SELECT statements that return results, or statements that perform variable assignment in a trigger. A trigger that includes either SELECT statements that return results to the user or statements that perform variable assignment requires special handling; these returned results would have to be written into every application in which modifications to the trigger table are allowed. I think encapsulating it all in a stored proc would be the best thing. 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: SQL Trigger / Stored Proc question
lets nip this myth in the bud > But what is the query that queryName refers to? the cfquery for the original insert. > Are you saying that CF is clever enough to pick up the fact that the > trigger has fired & grab the value from somewhere? no, but ODBC & sql server are... > The SQL Server documentation says: since we're quoting (BoL): "When a trigger fires, results are returned to the calling application, just as with stored procedures." > > Triggers can include any number and kind of Transact-SQL statements except > SELECT. A trigger is designed to check or change data based on a data > modification statement; it should not return data to the user. > where does this bit come from? BoL only *suggests* you refrain from returning results w/triggers because it would require all applications accessing that table be able to handle the returned results. > > To eliminate having results returned to an application due to a trigger > firing, do not include either SELECT statements that return results, or > statements that perform variable assignment in a trigger. A trigger that you've taken this out of context. see the 1st line for this "quote" above. triggers do have their place in development toolboxes. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Passing Variable values over more than 1 page
Store the values of the variables as Session Variables. i.e. Session.variableName Create the variable via CFPARAM either in your CFAPPLICATION or just prior to it's usage. Then you can clear the value when you send the email with a CFSET. Study up on session and application variables. 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: "AustralianAccommodation.com Pty. Ltd." <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 24, 2000 5:45 PM Subject: Passing Variable values over more than 1 page I am wanting to pass some variables over 2 or three pages and I am wondering how to achieve this I have a search results page and then the user can click on an email link that takes them to a cf email form page on the site once the user sends the email I want the page to go back to the search results page so the user can keep looking at the other search results my thought was that if I could pass the variables that were went sent from the form to the search results page and then pass those same variable values to the email form page then when the email is sent the search criteria values can be sent back to the search results action page and hence display the search results again I tried the function of going back to pages in browser history however I was getting an expired error message and so I felt the idea above would be a more secure way of achieving what I want any ideas comments and suggestions would be appreciated Kind Regards Claude Raiola (Director) AustralianAccommodation.com Pty. Ltd. Website: www.AustralianAccommodation.com Email: [EMAIL PROTECTED] -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL Trigger / Stored Proc question
Paul, > triggers do have their place in development toolboxes. Sure, I never said otherwise. Triggers are great. I've built systems that rely completely on them. > > But what is the query that queryName refers to? > > the cfquery for the original insert. > > > Are you saying that CF is clever enough to pick up the fact > > that the trigger has fired & grab the value from somewhere? > > no, but ODBC & sql server are... So let me get this straight, if you have a trigger in your database like this: CREATE TRIGGER table1_insert ON table1 FOR INSERT AS SELECT table1_ID FROM INSERTED and have a .CFM containing this: INSERT into table1 (col2) VALUES (#value2#) then you can refer to #insertRow.table1_ID# and it will contain the ID that was inserted for you by SQL Server, despite no such variable/column being mentioned in the , because the SQL Server ODBC driver returns the trigger variable in response to the INSERT statement and CF puts that in the results accordingly? If so... cool! 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
SQL UNION across 2 Differnt DSN's
I would like to do a simple select statement, but need to mingle the results together for display purposes. I am trying to merge the select from each of two identical tables located on two different Oracle DB Servers. A simple UNION statement can only live under a single CFQuery statement (which of course points to a single DSN) any suggestions on an efficient way to do this in CF? ___ Joseph J. Sanger, M.D.| Phone: (212) 263-7410 Associate Professor of Clinical Radiology | Fax: (212) 263-2039 Director, Division of Radiology Informatics | Co-Director, Division of Nuclear Medicine | Co-Director, Nuclear Cardiology | New York University School of Medicine| [EMAIL PROTECTED] ___ -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Why Netscape's serious lag time?
Hey all, Might anyone be able to offer a plausible solution to Netscape's lag time at the following URL? It appears to be loading the tables and *all* of their images before displaying the page at all. This problem exists in other sites I have worked on and I've yet to find a solution outside of not using tables within tables. I can't imagine it being caused by the CF code, but I can't really see what's causing it to happen. http://www.awgear.com/products/index.cfm?fuseaction=dsp_products&Department _name=Sleeping%20Bags&Department_img=sleepingbag_tn_title.gif or just: http://www.awgear.com and click sleeping bags or most all of the links. Any ideas/suggestions would be appreciated. -Andy G. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CFIF Questions
Laura, What I do is place a blank option tag in my query-driven select field, like so, making sure that it is selected by default: Then in your action page: Error! You must select a state! Terri Original Message Follows From: LH Rothman <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF Talk <[EMAIL PROTECTED]> Subject: CFIF Questions Date: Thu, 24 Aug 2000 21:34:57 -0700 Hello! I want to force folks to select a state but I'm using CFSELECT and the required tag doesn't work with it. Consequently I'm attempting to modify the CFIF statement on my action page with little success. I've tried this: Error! You must select a state! but it doesn't work. The ultimate goal is to require folks to select at MINIMUM a state in this search and give them an error if they select nothing. I know I'm making a stupid mistake and and any help would be very appreciated!!! Thank you, -Laura An Apparent Newbie! -- My Action page in progress-- SELECT Zip, City, County, State, Business, Phone, Fax, Website, Email, Street1, Legal, Comments FROM Contacts WHERE Legal LIKE '1' AND Business LIKE '#Business#%' AND City LIKE '#City#%' AND County LIKE '#County#%' AND Zip LIKE '#Zip#%' AND State LIKE '#State#%' ORDER BY Business Search Results Found #Contacts.RecordCount# Matches #Business# #Street1#N/A #City#, #State# #Zip# PH: #Phone#N/A FX: #Fax#N/A Web: #Website#N/A Email: mailto:#Email#">#Email#N/A #Comments# -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Anyone using Crystal Reports 8 successfully?!
I have small problem, Crystal Reports, version 8. What gives? I am new to cold fusion and the CFREPORT tag does not seem to work and I can't seem to find any online resources to figure this one out. Thank you. /mdeane -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL Trigger / Stored Proc question
quite righta trigger cannot contain a select and therefore cannot return a resultset or return a parameter -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: 25 August 2000 11:38 To: '[EMAIL PROTECTED]' Subject: RE: SQL Trigger / Stored Proc question > > I don't think you can pass a value out from a trigger - once the trigger > > sure you can. you can reference its value in queryName.mytable_ID But what is the query that queryName refers to? If you say CREATE TRIGGER...AS SELECT mytable_ID... then what is executed is the CREATE TRIGGER statement, i.e. it stores the trigger in the database. The trigger only *fires* when a row is inserted. Are you saying that CF is clever enough to pick up the fact that the trigger has fired & grab the value from somewhere? The SQL Server documentation says: Triggers can include any number and kind of Transact-SQL statements except SELECT. A trigger is designed to check or change data based on a data modification statement; it should not return data to the user. ... To eliminate having results returned to an application due to a trigger firing, do not include either SELECT statements that return results, or statements that perform variable assignment in a trigger. A trigger that includes either SELECT statements that return results to the user or statements that perform variable assignment requires special handling; these returned results would have to be written into every application in which modifications to the trigger table are allowed. I think encapsulating it all in a stored proc would be the best thing. 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: OT- Program to compare two pages of code for differences
I've been using FCOMPARE and I've been pretty happy with it. http://www.oneysoft.com/fcompare.htm -Greg Witte -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 22, 2000 5:52 PM To: [EMAIL PROTECTED] Subject: OT- Program to compare two pages of code for differences Does anyone know where I can find a program for comparing two pages of code for differences? I have two copies of a page and want to be able to compare to see how they differ. TYIA H Larry Juncker L Senior Cold Fusion Programmer I Heartland Communications Group Internet Division -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
IsNotDefined()
Is there a way to do this? I've tried things like !IsDefined() with no success... Thanks, Pete -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: IsNotDefined()
try: -Original Message- From: Peter Benoit [mailto:[EMAIL PROTECTED]] Sent: 25 August 2000 13:51 To: '[EMAIL PROTECTED]' Subject: IsNotDefined() Is there a way to do this? I've tried things like !IsDefined() with no success... Thanks, Pete -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: IsNotDefined()
Try NOT IsDefined(). -- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Peter Benoit <[EMAIL PROTECTED]> To: '[EMAIL PROTECTED]' <[EMAIL PROTECTED]> Date: Friday, August 25, 2000 8:49 AM Subject: IsNotDefined() >Is there a way to do this? > >I've tried things like !IsDefined() with no success... > >Thanks, >Pete > >--- --- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Concatenate Strings
-- Jamie Keane Programmer SolutionMasters, Inc. 9111 Monroe Rd., Suite 100 Charlotte, NC 28270 www.solutionmasters.com 704.563.5559 x 228 Voice 704.849.9291 Fax -Original Message- From: Peter Benoit <[EMAIL PROTECTED]> To: '[EMAIL PROTECTED]' <[EMAIL PROTECTED]> Date: Thursday, August 24, 2000 7:18 PM Subject: Concatenate Strings >How can I concatenate 2 strings in CF? > > >--- --- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re:
Et bien j'en connais 2 ! Mon collège de travail ansi que moi. à part ça je sais pas ! Vous connaissez le coin ? Yanik Lupien - Original Message - From: "Milks, Jim" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 24, 2000 2:53 PM Subject: RE: > Beaucoup de CF a Brossard? > > JM > > -Original Message- > From: Yanik Lupien > To: [EMAIL PROTECTED] > Sent: 24/08/00 11:34 AM > Subject: > > Hi, I'm working on a project called GOgraph, it's a search engine where > you > can search images (over 20 000)! > I have also write a custom tag to help Cold Fusion partners to embed our > search engin on there site (Using WDDX)! > > I need help to test it!, I need comment on the custom tag and the doc > file! > > Before you can test it be sure to add you IP Address in the "Setup your > servers IP" you can use wildcard like "207.253.24.*" if you use a DHCP > server. > > Anyone can help me? > > The GOgraph search engin URL > http://www.gograph.com > > Register here it's the free trial system! (Not finish but work) > http://www.gograph.com/fusion/en/cf_gograph/index.cfm > > Thank you > > Yanik Lupien > > Visicom Media > http://www.visic.com > > > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk > or send a message to [EMAIL PROTECTED] with > 'unsubscribe' in the body. > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Page Refresh
Ok here's my problem then. I have users that can change information that they see on the screen. They click edit and a small window opens and they change whatever. Then when they click close window I need the parent page to reload? I am thinking JS is needed?? Any ideas Thanks Mike >>> [EMAIL PROTECTED] 08/24/00 09:34PM >>> If you are refreshing a .cfm pager (onload or metatag) it will keep the session active. HTH Dick At 4:09 PM -0400 8/24/00, Michael Ross wrote: >I think that I read somewhere that you can have a page refresh every >20 seconds or what ever time limit I want. Assuming that thisis >correct will sesson variables still die after the time limit. Or >will the refreshing keep them alive? > >Thanks -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Page Refresh
I use function closeme() { this.window.opener.location.reload(); opener.focus(); this.window.close(); HTH Katie -Original Message- From: Michael Ross [mailto:[EMAIL PROTECTED]] Sent: Friday, August 25, 2000 9:02 AM To: [EMAIL PROTECTED] Subject: Re: Page Refresh Ok here's my problem then. I have users that can change information that they see on the screen. They click edit and a small window opens and they change whatever. Then when they click close window I need the parent page to reload? I am thinking JS is needed?? Any ideas Thanks Mike >>> [EMAIL PROTECTED] 08/24/00 09:34PM >>> If you are refreshing a .cfm pager (onload or metatag) it will keep the session active. HTH Dick At 4:09 PM -0400 8/24/00, Michael Ross wrote: >I think that I read somewhere that you can have a page refresh every >20 seconds or what ever time limit I want. Assuming that thisis >correct will sesson variables still die after the time limit. Or >will the refreshing keep them alive? > >Thanks -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Cookies
In a message dated 08/24/2000 8:46:54 PM Eastern Daylight Time, [EMAIL PROTECTED] writes: << This surely can't be a *total* can it? Does this mean that there can only be 20 cookies set at any one time? >> My understanding is that once you reach the browser's limit, the browser writes over the earliest cookies with the latest. So if you want to use 30 you will only have your last 20 available to you. :-) Oriole -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE:
Pas plus que ca, mais ton nom m'a dit que tu etait probablement québecois ou francais, alors j'ai visité ton site et j'ai vu l'addresse. J'était curieux si CF commencait a etre populaire au Quebec, ca ca commence dans notre coin a Hull/Ottawa. JM PS: Pardonne mon francais...je fait mon possible -Original Message- From: Yanik Lupien To: [EMAIL PROTECTED] Sent: 25/08/00 8:59 AM Subject: Re: Et bien j'en connais 2 ! Mon collège de travail ansi que moi. à part ça je sais pas ! Vous connaissez le coin ? Yanik Lupien - Original Message - From: "Milks, Jim" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 24, 2000 2:53 PM Subject: RE: > Beaucoup de CF a Brossard? > > JM > > -Original Message- > From: Yanik Lupien > To: [EMAIL PROTECTED] > Sent: 24/08/00 11:34 AM > Subject: > > Hi, I'm working on a project called GOgraph, it's a search engine where > you > can search images (over 20 000)! > I have also write a custom tag to help Cold Fusion partners to embed our > search engin on there site (Using WDDX)! > > I need help to test it!, I need comment on the custom tag and the doc > file! > > Before you can test it be sure to add you IP Address in the "Setup your > servers IP" you can use wildcard like "207.253.24.*" if you use a DHCP > server. > > Anyone can help me? > > The GOgraph search engin URL > http://www.gograph.com > > Register here it's the free trial system! (Not finish but work) > http://www.gograph.com/fusion/en/cf_gograph/index.cfm > > Thank you > > Yanik Lupien > > Visicom Media > http://www.visic.com > > > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk > or send a message to [EMAIL PROTECTED] with > 'unsubscribe' in the body. > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Dates
> If I use this? > > > > > Will months with 2 digits appear with 2 digits? IE 10/10/00? I know this sounds a bit odd, but wouldn't 2 minutes of checking have saved you hours of waiting for a reply from this list? #DateFormat(CreateDate(2000,1,10),"m/dd/")# #DateFormat(CreateDate(2000,10,10),"m/dd/")# This would have answered your question, took less than a minute to type and less than a second to generate the result Or, check the documentation; "m -- Month as digits with no leading zero for single-digit months." It would also be a completely useless function if it chopped the month off, wouldn't it? One of our developers has taken to asking questions like this (instead of reading the manuals, on-line docs or testing) and we've taken to ignoring her questions until she realises that it's a LOT better to learn for herself than to ask for help from others around - it means that she'll be a lot more self-reliant when a bigger job is handed over for her to complete. 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Join vs Union Perference(sp)
> Which is better an apple or a bicycle? Erm, a bicycle as you can use it to ride to an apple tree and pick as many apples as you want, while one apple can only be eaten once 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=lists&body=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. OK, here's why it's not stupid to have quotes... isDefined() replaces ParameterExists(), which required the variable name to be put in without quotes, in fact, you couldn't (naturally) check for the existance of a dynamic variable name isDefined() uses the quotes because it can take dynamic variable names, take this example; #i# not completed Without using an Evaluate() on the first CFIF, you couldn't do this... why use 2 functions when one will do? Hope this explains a bit 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: ColdFusion Server-side Source Control
Yes I have some experience, and my conclusion is STAY AWAY! Vss and CF just don't seem to integrate well. We thought we had it solved, until we lost a day's worth of development. Our final conclusion was to simply run CF and VSS seperately and use Alt + Tab a lot. I would agree that the multiple projects appear to be the issue, but we never had enough time to invest in trying to solve it... Good luck.. JM -Original Message- From: Truman Esmond III To: [EMAIL PROTECTED] Sent: 24/08/00 7:43 PM Subject: ColdFusion Server-side Source Control Okay, I've spent enough time spinning my wheels on this by myself - any help is appreciated :) Anyone successfully implemented server-side source control through CF? Found better docs somewhere on this feature within CF? We've got source control set up through studio, but we're trying to have an internal development server connect to a client's VSS db, and have all of our local developers use RDS locally on that machine for this effort - the problem seemingly lies in that there are multiple projects and multiple working directories. The form in the CFAdmin only allows a single DB to be connected (and is kinda vague about exactly which .ini file to connect to) and only a single working directory. Any experiences, configurations and references to other documentation would be greatly appreciated! Secondly and similarly, has anyone tried using the CF server-side source control or even studio integrated source control using SourceGear's SourceOffSite? Looks like it *should* work the same (only faster) since their based on the same API... Truman -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Yet another filesize question
that makes me feel better. it's gonna be a good weekend. :) (actually, its a DOD project. but i'm a contractor, so who cares about *my* sexual orientation? sides, they didn't ask) :) Chris Olive, DOEHRS Website Administrator -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: Friday, August 25, 2000 4:54 AM To: '[EMAIL PROTECTED]' Subject: RE: Yet another filesize question > i feel so unloved. :) Chris, we love you. (do they say things like that in the US army?) ** 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Why Netscape's serious lag time?
Hi, Netscape is a little freaky about tables. You have to make sure that all of your width / height calculations are defined, and are accurate. On first glance, I found that you have a table with a width of 600 contained within a table with a width of 585. Netscape is probably trying to recalc all the tables, which causes the lag. I didn't dig any deeper than that though... Thanks, Geoffrey Vail Brown __ Director of Online Operations Deerfield.com 231.935.4640 [EMAIL PROTECTED] Check out our complete line of Internet leveraging software at: http://www.deerfield.com > -Original Message- > From: Harold Goodson [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 25, 2000 8:04 AM > To: [EMAIL PROTECTED] > Subject: Why Netscape's serious lag time? > > > Hey all, > > Might anyone be able to offer a plausible solution to Netscape's lag time > at the following URL? > > It appears to be loading the tables and *all* of their images before > displaying the page at all. This problem exists in other sites I have > worked on and I've yet to find a solution outside of not using tables > within tables. I can't imagine it being caused by the CF code, > but I can't > really see what's causing it to happen. > > > http://www.awgear.com/products/index.cfm?fuseaction=dsp_products&D > epartment > _name=Sleeping%20Bags&Department_img=sleepingbag_tn_title.gif > > or just: http://www.awgear.com and click sleeping bags or most all of the > links. > > Any ideas/suggestions would be appreciated. > > -Andy G. > > -- > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf _talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CSS
The O'Reilly book "Cascading Style Sheets" is the best reference I've found. It has a table which covers what you're asking for. hth Mike Hales -Original Message- From: Reilly, Jim [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 24, 2000 5:30 PM To: [EMAIL PROTECTED] (E-mail) Subject: OT: CSS Anyone have a document/list/URL's of things that "work/don't work" on NS4+ and IE4+ browsers? (looking for many as I can get...) Example: TABLE { vertical-align : middle; text-align : center; background-color : green; } Option NetscapeIE == === text-align : center;no yes ... .. . . Tkx, Jim -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: [RE: OT- Program to compare two pages of code for differences]
use the diff command. if this is windows and you do not have diff download cygnus unix tools. "Scott, Andrew" <[EMAIL PROTECTED]> wrote: try MS Source Safe, not only is it good for backing up code, but it makes great sense to be able to go back revisions if need be:-) regards Andrew Scott ANZ eCommerce Centre * Ph 9273 0693 * [EMAIL PROTECTED] -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: 23 August 2000 07:52 To: [EMAIL PROTECTED] Subject: OT- Program to compare two pages of code for differences Does anyone know where I can find a program for comparing two pages of code for differences? I have two copies of a page and want to be able to compare to see how they differ. TYIA H Larry Juncker L Senior Cold Fusion Programmer I Heartland Communications Group Internet Division -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Get free email and a permanent address at http://www.netaddress.com/?N=1 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL Trigger / Stored Proc question
Sorry, my friend, but you are wrong here. Triggers can contain hundreds of lines of complicated code to enforce complex user-defined business rules, and they can contain SELECT statements and also return result sets (in T/SQL)-- which can be configured to look like parameters if the result set is a single row. I lectured on this at CFUN2K last month, and our upcoming high-end ecommerce product uses these techniques extensively to create a very robust and scalable app. The meat of the issue is this: inserting a table row from a stored procedure, then gaining access to the Indentity column value just inserted. The trigger Neil shows will indeed produce a result that can be accessed in CFML after CFQUERY is run by using QueryName.ColumnName. The problem is: how do you access this from a stored procedure that inserts the row? The answer is this: reference @@IDENTITY in the stored procedure IMMEDIATELY after the statement that inserts the table row. This won't make use of the trigger's SELECT result, but it will give you the value of the Identity column most recently inserted into a table. BTW, David and I will be teaching this and many other techniques during next week's Ecommerce Development with ColdFusion seminar in Memphis. If you want a half-price pass, then just email a request to [EMAIL PROTECTED], but hurry because today is the final day of registration. Hope this helps. Cheers! :) At 01:42 PM 8/25/00 +0100, you wrote: >quite righta trigger cannot contain a select and therefore cannot return >a resultset or return a parameter > >-Original Message- >From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] >Sent: 25 August 2000 11:38 >To: '[EMAIL PROTECTED]' >Subject: RE: SQL Trigger / Stored Proc question > > >> > I don't think you can pass a value out from a trigger - once the trigger >> >> sure you can. you can reference its value in queryName.mytable_ID > >But what is the query that queryName refers to? > >If you say CREATE TRIGGER...AS SELECT mytable_ID... > >then what is executed is the CREATE TRIGGER statement, i.e. it stores the >trigger in the database. The trigger only *fires* when a row is inserted. >Are you saying that CF is clever enough to pick up the fact that the >trigger has fired & grab the value from somewhere? > >The SQL Server documentation says: > > >Triggers can include any number and kind of Transact-SQL statements except >SELECT. A trigger is designed to check or change data based on a data >modification statement; it should not return data to the user. > >... > >To eliminate having results returned to an application due to a trigger >firing, do not include either SELECT statements that return results, or >statements that perform variable assignment in a trigger. A trigger that >includes either SELECT statements that return results to the user or >statements that perform variable assignment requires special handling; these >returned results would have to be written into every application in which >modifications to the trigger table are allowed. > > >I think encapsulating it all in a stored proc would be the best thing. > >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=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. Respectfully, Adam Phillip Churvis President Productivity Enhancement, Inc. * PRODUCTIVITY ENHANCEMENT, INC. * * * *Publishers of the CommerceBlocks line of modular development tools* * for ColdFusion * * * * Website: http://www.commerceblocks.com E-mail: [EMAIL PROTECTED] * * Phone: 770-446-8866Fax:770-242-0410* *
Re: netscape taking a long time to render page
i'm getting a 404 file not found on that url i've noticed that netscape doesn't render very quickly with lots of embedded tables (to me, 5 or greater is a lot) and a large amount of text in the page (about 3 or more 'pages' worth). perry on 8/24/00 7:19 PM, Chris at [EMAIL PROTECTED] wrote: > hey guys,i've got a page here that is taking a very very long time to > render in NS (after it has downloaded) i know its because of some tag > formating, but i cant seem to find it. all my tables check out as far as i > can tell.. can i get a few more sets of eyes to take a look at the html & > possibly show me what i've done wrong? > > heres the url for the html output of the page thats giving me a problem: > > http://www.yarooze.com/kitehigh/testNSproblem.cfm > > its actually all cold fusion code, so dont be fooled by the .cfm ext. > > thanx for any help you can give. > -chris > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in the > body. > -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL Trigger / Stored Proc question
I stand corrected!...thanks. Out of curiosity - When faced with this sort of thing I always reference the INSERTED table to get the ID rather than @@IDENTITY. I know it will be marginal if anything but will @@IDENTITY be quicker? are there any other advantages or is it essentially the same thing? -Original Message- From: Adam Phillip Churvis [mailto:[EMAIL PROTECTED]] Sent: 25 August 2000 14:33 To: [EMAIL PROTECTED] Subject: RE: SQL Trigger / Stored Proc question Sorry, my friend, but you are wrong here. Triggers can contain hundreds of lines of complicated code to enforce complex user-defined business rules, and they can contain SELECT statements and also return result sets (in T/SQL)-- which can be configured to look like parameters if the result set is a single row. I lectured on this at CFUN2K last month, and our upcoming high-end ecommerce product uses these techniques extensively to create a very robust and scalable app. The meat of the issue is this: inserting a table row from a stored procedure, then gaining access to the Indentity column value just inserted. The trigger Neil shows will indeed produce a result that can be accessed in CFML after CFQUERY is run by using QueryName.ColumnName. The problem is: how do you access this from a stored procedure that inserts the row? The answer is this: reference @@IDENTITY in the stored procedure IMMEDIATELY after the statement that inserts the table row. This won't make use of the trigger's SELECT result, but it will give you the value of the Identity column most recently inserted into a table. BTW, David and I will be teaching this and many other techniques during next week's Ecommerce Development with ColdFusion seminar in Memphis. If you want a half-price pass, then just email a request to [EMAIL PROTECTED], but hurry because today is the final day of registration. Hope this helps. Cheers! :) At 01:42 PM 8/25/00 +0100, you wrote: >quite righta trigger cannot contain a select and therefore cannot return >a resultset or return a parameter > >-Original Message- >From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] >Sent: 25 August 2000 11:38 >To: '[EMAIL PROTECTED]' >Subject: RE: SQL Trigger / Stored Proc question > > >> > I don't think you can pass a value out from a trigger - once the trigger >> >> sure you can. you can reference its value in queryName.mytable_ID > >But what is the query that queryName refers to? > >If you say CREATE TRIGGER...AS SELECT mytable_ID... > >then what is executed is the CREATE TRIGGER statement, i.e. it stores the >trigger in the database. The trigger only *fires* when a row is inserted. >Are you saying that CF is clever enough to pick up the fact that the >trigger has fired & grab the value from somewhere? > >The SQL Server documentation says: > > >Triggers can include any number and kind of Transact-SQL statements except >SELECT. A trigger is designed to check or change data based on a data >modification statement; it should not return data to the user. > >... > >To eliminate having results returned to an application due to a trigger >firing, do not include either SELECT statements that return results, or >statements that perform variable assignment in a trigger. A trigger that >includes either SELECT statements that return results to the user or >statements that perform variable assignment requires special handling; these >returned results would have to be written into every application in which >modifications to the trigger table are allowed. > > >I think encapsulating it all in a stored proc would be the best thing. > >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=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. >--- --- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. Respectfully, Adam Phillip Churvis President Productivity Enhancement, Inc. * PRODUCTIVITY ENHANCEMENT, INC. * *
RE: Rich Text Files (RTF) Creation and Manipulation
I'll second Dave's suggestion below to use WordPerfect. I too struggled and eventually succeeded. I had to produce several 100+ page reports with complex tables, headers, page numbering, and page breaks. The code produced by Word was very hard to edit, and Word threw in a lot of "trash" code that wasn't necessary. WordPerfect was much easier to modify. I also had trouble producing code that would look identical in both Word and WordPerfect when viewed by the user. Because the WordPerfect code was so much cleaner, it made this task much easier. - Good Luck > > I have a need to manipulate RTF files with ColdFusion. While > > I have been successful in working with RTF files in Word, and > > then saving out for manipulation with CF, I need to be able to > > do some things that are a bit more complicated. > > I've done this successfully many times in the past, building documents > that even have grouped output across multiple pages. The secret to my > success: Use WordPerfect instead of Word to generate the template. > WordPerfect's RTF is much cleaner and simpler than Word's, and each > major RTF control word is on a separate line. I ended up buying a copy > of WordPerfect just for this purpose. > 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
cffile and text qualifier
Hi. I've got to create a little cffile for importing a csv file that uses "" as the text qualifier. I'm presuming the quotes will just tell the database on a manual import to ignore any commas between the quotes. But, how will this work with cffile if I loop through each row? There may be some commas in the fields as some are descriptions, Company names (Company, Inc.), etc. I'll use chr(10) as the outside loop delimiter. On the inside, would you just use something like: delimiter="#chr(34)#,#chr(34)#" then replace the first and last quote from each row? Or does someone have a cleaner way? Thanks. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Urgent help required....
I have seen this when another process on an NT box has the file open or the file has been corrupted in some manner. I would suggest re-creating the file. John - Original Message - From: "kailash" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 24, 2000 1:21 PM Subject: Urgent help required Hi! friends... I am getting this error... has anyone faced this errorif so please help Error Occurred While Processing Request Error Diagnostic Information Cannot load template file The template file exists, however, it either cannot be opened for reading, or it is encrypted and its data has been corrupted -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Anyone using Crystal Reports 8 successfully?!
I just recently worked through this one (with some help from this list!) You'll want to install the CR Web Component Server. Once you have that up on your web server, you can just use a URL to display the report in the browser. From there the user can print it. I'm still having a problem with the refresh though. I've used a datasource in the report. And this works fine as long as I save the data in the report. But if the user clicks on the CR refresh button in the browser, they are prompted for an ID and password. No matter what ID and password I use there, I can't get the report to redisplay. I called Seagate about a week ago to try to figure out how to get around it. After being on hold for over 1/2 hour I accidentally disconnected the line. I haven't had the time to call back and wait again. But I don't think this should be hard to fix. Athelene Gieseman [EMAIL PROTECTED] -Original Message- From: Mike Deane [mailto:[EMAIL PROTECTED]] Sent: Friday, August 25, 2000 7:34 AM To: '[EMAIL PROTECTED]' Subject: Anyone using Crystal Reports 8 successfully?! I have small problem, Crystal Reports, version 8. What gives? I am new to cold fusion and the CFREPORT tag does not seem to work and I can't seem to find any online resources to figure this one out. Thank you. /mdeane -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: [RE: RE: Session timeout?]
then do you ever get timeout? if you compare the client.lastvisit with now(), it will never GTE 30 because client.LastVisit is always updated before you excute this piece of code. I use client management too... Andy Ewings <[EMAIL PROTECTED]> wrote: > Yup...this is what I do in mine.. > > > > > DELETE FROM CDATA WHERE CFID = > '#Cookie.CFID#:#Cookie.CFToken#' AND APP = 'CVBuilder' > > > > 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: > > > > > > > -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 > > > > > 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=lists&body=lists/cf_talk > or > send a message to [EMAIL PROTECTED] with 'unsubscribe' > in > the body. > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk > or send a message to [EMAIL PROTECTED] with 'unsubscribe' > in the body. > > > > - > 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=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Get free email and a permanent address at http://www.netaddress.com/?N=1 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Urgent help required....
you'll also get that error if the file does not have the correct permissions set. -Original Message- From: John Wright [mailto:[EMAIL PROTECTED]] Sent: Friday, August 25, 2000 8:51 AM To: [EMAIL PROTECTED] Subject: Re: Urgent help required I have seen this when another process on an NT box has the file open or the file has been corrupted in some manner. I would suggest re-creating the file. John - Original Message - From: "kailash" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 24, 2000 1:21 PM Subject: Urgent help required Hi! friends... I am getting this error... has anyone faced this errorif so please help Error Occurred While Processing Request Error Diagnostic Information Cannot load template file The template file exists, however, it either cannot be opened for reading, or it is encrypted and its data has been corrupted -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: [RE: RE: Session timeout?]
Ummm...ok.but if that's the case how can you ever interrogate the Client.LastVisit variable and get a value other than the current time? -Original Message- From: JL [mailto:[EMAIL PROTECTED]] Sent: 25 August 2000 14:57 To: [EMAIL PROTECTED] Subject: Re: [RE: RE: Session timeout?] then do you ever get timeout? if you compare the client.lastvisit with now(), it will never GTE 30 because client.LastVisit is always updated before you excute this piece of code. I use client management too... Andy Ewings <[EMAIL PROTECTED]> wrote: > Yup...this is what I do in mine.. > > > > > DELETE FROM CDATA WHERE CFID = > '#Cookie.CFID#:#Cookie.CFToken#' AND APP = 'CVBuilder' > > > > 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: > > > > > > > -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 > > > > > 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=lists&body=lists/cf_talk > or > send a message to [EMAIL PROTECTED] with 'unsubscribe' > in > the body. > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk > or send a message to [EMAIL PROTECTED] with 'unsubscribe' > in the body. > > > > - > 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=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Get free email and a permanent address at http://www.netaddress.com/?N=1 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Anyone using Crystal Reports 8 successfully?!
I am at the exact same point as you. I cannot get the Web Component Server to force scheduled refreshes. I cannot include the file into a .cfm file. This is not a pretty sight right now. Any one get past this point? Thanks. /mdeane -Original Message- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Friday, August 25, 2000 9:51 AM To: '[EMAIL PROTECTED]' Subject: RE: Anyone using Crystal Reports 8 successfully?! I just recently worked through this one (with some help from this list!) You'll want to install the CR Web Component Server. Once you have that up on your web server, you can just use a URL to display the report in the browser. From there the user can print it. I'm still having a problem with the refresh though. I've used a datasource in the report. And this works fine as long as I save the data in the report. But if the user clicks on the CR refresh button in the browser, they are prompted for an ID and password. No matter what ID and password I use there, I can't get the report to redisplay. I called Seagate about a week ago to try to figure out how to get around it. After being on hold for over 1/2 hour I accidentally disconnected the line. I haven't had the time to call back and wait again. But I don't think this should be hard to fix. Athelene Gieseman [EMAIL PROTECTED] -Original Message- From: Mike Deane [mailto:[EMAIL PROTECTED]] Sent: Friday, August 25, 2000 7:34 AM To: '[EMAIL PROTECTED]' Subject: Anyone using Crystal Reports 8 successfully?! I have small problem, Crystal Reports, version 8. What gives? I am new to cold fusion and the CFREPORT tag does not seem to work and I can't seem to find any online resources to figure this one out. Thank you. /mdeane -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL Trigger / Stored Proc question
I always like to use explicit references if possible-- @@IDENTITY is used here because it is the only way to do this. "Faster" in terms of time difference between these two techniques should not even be a consideration because, for all intents and purposes, it is negligible, and there are countless other better opportunities in any app to pick up speed. Hope this helps. Well, it's time for me to feed my trusty horse, Gefilte, so I simply must go... At 02:39 PM 8/25/00 +0100, you wrote: >I stand corrected!...thanks. > >Out of curiosity - When faced with this sort of thing I always reference the >INSERTED table to get the ID rather than @@IDENTITY. I know it will be >marginal if anything but will @@IDENTITY be quicker? are there any other >advantages or is it essentially the same thing? Respectfully, Adam Phillip Churvis President Productivity Enhancement, Inc. * PRODUCTIVITY ENHANCEMENT, INC. * * * *Publishers of the CommerceBlocks line of modular development tools* * for ColdFusion * * * * Website: http://www.commerceblocks.com E-mail: [EMAIL PROTECTED] * * Phone: 770-446-8866Fax:770-242-0410* * * -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Why Netscape's serious lag time?
Netscape will not render tables until it finishes calculating the whole table (whereas Microsoft makes educated guesses as it goes). If you have picture widths playing into the calc time it can get ugly. The first thing I would try is explicitly defining all the cell widths, and see if that speeds it up. -Original Message- From: Harold Goodson [mailto:[EMAIL PROTECTED]] Sent: Friday, August 25, 2000 7:04 AM To: [EMAIL PROTECTED] Subject: Why Netscape's serious lag time? Hey all, Might anyone be able to offer a plausible solution to Netscape's lag time at the following URL? It appears to be loading the tables and *all* of their images before displaying the page at all. This problem exists in other sites I have worked on and I've yet to find a solution outside of not using tables within tables. I can't imagine it being caused by the CF code, but I can't really see what's causing it to happen. http://www.awgear.com/products/index.cfm?fuseaction=dsp_products&Department _name=Sleeping%20Bags&Department_img=sleepingbag_tn_title.gif or just: http://www.awgear.com and click sleeping bags or most all of the links. Any ideas/suggestions would be appreciated. -Andy G. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: [RE: [RE: RE: Session timeout?]]
I set another variable client.LastVisit2 = client.LastVisit at the end of application.cfm then I compare the lastvisit2 with now() at the top of application.cfm =) Andy Ewings <[EMAIL PROTECTED]> wrote: > Ummm...ok.but if that's the case how can you ever interrogate the > Client.LastVisit variable and get a value other than the current time? > > -Original Message- > From: JL [mailto:[EMAIL PROTECTED]] > Sent: 25 August 2000 14:57 > To: [EMAIL PROTECTED] > Subject: Re: [RE: RE: Session timeout?] > > > then do you ever get timeout? > if you compare the client.lastvisit with now(), it will never GTE 30 because > client.LastVisit is always updated before you excute this piece of code. > > I use client management too... > > Andy Ewings <[EMAIL PROTECTED]> wrote: > > Yup...this is what I do in mine.. > > > > > > > > > > DELETE FROM CDATA WHERE CFID = > > '#Cookie.CFID#:#Cookie.CFToken#' AND APP = 'CVBuilder' > > > > > > > > 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: > > > > > > > > > > > > > > -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 > > > > > > > > > > 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=lists&body=lists/cf_talk > > or > > send a message to [EMAIL PROTECTED] with 'unsubscribe' > > in > > the body. > > > > > -- > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > To Unsubscribe visit > > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk > > or send a message to [EMAIL PROTECTED] with 'unsubscribe' > > in the body. > > > > > > > > - > > 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=lists&body=lists/cf_talk or > > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > > the body. > > > > -- > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the > body. > > > > Get free email and a permanent address at http://www.netaddress.com/?N=1 > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. Get f
RE: Yet another filesize question
Sorry I did not acknowledge you yesterday, but I do love you also. The reason I didn't, is that I was receiving serious lag times in the posting/delivery of messages. I actually saw responses to things I posted BEFORE my posting. Anyway, hugs and kisses to you and your Army buddies... JM -Original Message- From: Olive, Christopher M Mr NMR To: '[EMAIL PROTECTED]' Sent: 25/08/00 9:20 AM Subject: RE: Yet another filesize question that makes me feel better. it's gonna be a good weekend. :) (actually, its a DOD project. but i'm a contractor, so who cares about *my* sexual orientation? sides, they didn't ask) :) Chris Olive, DOEHRS Website Administrator -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: Friday, August 25, 2000 4:54 AM To: '[EMAIL PROTECTED]' Subject: RE: Yet another filesize question > i feel so unloved. :) Chris, we love you. (do they say things like that in the US army?) ** 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Table Row Background colors not showing in Nutscrape
I found my problem - appreciate the replies I had an image defined for the background in the table, apparently if you have a background image in Netscape, you can not define also colors. Thanks again -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 24, 2000 7:26 PM To: [EMAIL PROTECTED] Subject: Re: Table Row Background colors not showing in Nutscrape You need to ensure you write a non-breaking space - " " without the quotes - if you are not displaying content in a cell. This is a Netscape "feature". Rob Keniger -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: [RE: [RE: RE: Session timeout?]]
ok...thanks. But to me, that makes Client.Lastvisit pretty useless. You may as well just use now() in both cases i.e. set lasvisit2 = now() at the end of application.cfm and then test it against now() at the beggining -Original Message- From: JL [mailto:[EMAIL PROTECTED]] Sent: 25 August 2000 15:14 To: [EMAIL PROTECTED] Subject: Re: [RE: [RE: RE: Session timeout?]] I set another variable client.LastVisit2 = client.LastVisit at the end of application.cfm then I compare the lastvisit2 with now() at the top of application.cfm =) Andy Ewings <[EMAIL PROTECTED]> wrote: > Ummm...ok.but if that's the case how can you ever interrogate the > Client.LastVisit variable and get a value other than the current time? > > -Original Message- > From: JL [mailto:[EMAIL PROTECTED]] > Sent: 25 August 2000 14:57 > To: [EMAIL PROTECTED] > Subject: Re: [RE: RE: Session timeout?] > > > then do you ever get timeout? > if you compare the client.lastvisit with now(), it will never GTE 30 because > client.LastVisit is always updated before you excute this piece of code. > > I use client management too... > > Andy Ewings <[EMAIL PROTECTED]> wrote: > > Yup...this is what I do in mine.. > > > > > > > > > > DELETE FROM CDATA WHERE CFID = > > '#Cookie.CFID#:#Cookie.CFToken#' AND APP = 'CVBuilder' > > > > > > > > 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: > > > > > > > > > > > > > > -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 > > > > > > > > > > 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=lists&body=lists/cf_talk > > or > > send a message to [EMAIL PROTECTED] with 'unsubscribe' > > in > > the body. > > > > > -- > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > To Unsubscribe visit > > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk > > or send a message to [EMAIL PROTECTED] with 'unsubscribe' > > in the body. > > > > > > > > - > > 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=lists&body=lists/cf_talk or > > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > > the body. > > > > -- > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the > body. > > > > Get free email and a permanent address at http://www.netaddress.com/?N=1 > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > ---
RE: Yet another filesize question
warm fuzzies all around. before the Net.Cops show up, i appreciate that. and my confidence is restored in the world, etc etc. (i'm a bit shaken because i'm leaving the cushy DOD job and going independent. the silent treatment at work is a bit unbearable. but soon i shall rise from the ashes as...) christopher olive, cio cresc technologies http://www.crescotech.com -Original Message- From: Milks, Jim [mailto:[EMAIL PROTECTED]] Sent: Friday, August 25, 2000 10:15 AM To: '[EMAIL PROTECTED]' Subject: RE: Yet another filesize question Sorry I did not acknowledge you yesterday, but I do love you also. The reason I didn't, is that I was receiving serious lag times in the posting/delivery of messages. I actually saw responses to things I posted BEFORE my posting. Anyway, hugs and kisses to you and your Army buddies... JM -Original Message- From: Olive, Christopher M Mr NMR To: '[EMAIL PROTECTED]' Sent: 25/08/00 9:20 AM Subject: RE: Yet another filesize question that makes me feel better. it's gonna be a good weekend. :) (actually, its a DOD project. but i'm a contractor, so who cares about *my* sexual orientation? sides, they didn't ask) :) Chris Olive, DOEHRS Website Administrator -Original Message- From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] Sent: Friday, August 25, 2000 4:54 AM To: '[EMAIL PROTECTED]' Subject: RE: Yet another filesize question > i feel so unloved. :) Chris, we love you. (do they say things like that in the US army?) ** 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
white space problems
Has anybody else experienced problems with the CF admin setting "supress white space by default" not working? We're running CF 4.5.1 on NT 4 with Service Pack 6a, and even after a re-start of the server with that option turned on, our pages are still output to the browser with a ton of white space. We have experimented with using in places, and it has worked, but because of the way our code is set up, there are many places where we can't use it, so the admin setting is our only real option. We have two side by side servers running the same configuration and code (development and testing machines), and we get the same result from both machines. any help/suggestions would be appreciated. Thanks. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re:
Aucun problem pour le français ! Cold Fusion commence à être populaire ici mais il n'y a quand même pas beaucoup de conaisseur de cette technologie, il y a quand même quelque compagnie qui l'utilise mais pas plus que ça, si la compagnie ou je travaille l'utilise c'est que je leur ai recommendé tout simplement! Tu n'as pas essayé test la c'est très simple, il y a même un example inclus dans le fichier .zip ? Ps. il est très beau votre site ! Yanik Lupien - Original Message - From: "Milks, Jim" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, August 25, 2000 9:16 AM Subject: RE: Pas plus que ca, mais ton nom m'a dit que tu etait probablement québecois ou francais, alors j'ai visité ton site et j'ai vu l'addresse. J'était curieux si CF commencait a etre populaire au Quebec, ca ca commence dans notre coin a Hull/Ottawa. JM PS: Pardonne mon francais...je fait mon possible -Original Message- From: Yanik Lupien To: [EMAIL PROTECTED] Sent: 25/08/00 8:59 AM Subject: Re: Et bien j'en connais 2 ! Mon collège de travail ansi que moi. à part ça je sais pas ! Vous connaissez le coin ? Yanik Lupien - Original Message - From: "Milks, Jim" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 24, 2000 2:53 PM Subject: RE: > Beaucoup de CF a Brossard? > > JM > > -Original Message- > From: Yanik Lupien > To: [EMAIL PROTECTED] > Sent: 24/08/00 11:34 AM > Subject: > > Hi, I'm working on a project called GOgraph, it's a search engine where > you > can search images (over 20 000)! > I have also write a custom tag to help Cold Fusion partners to embed our > search engin on there site (Using WDDX)! > > I need help to test it!, I need comment on the custom tag and the doc > file! > > Before you can test it be sure to add you IP Address in the "Setup your > servers IP" you can use wildcard like "207.253.24.*" if you use a DHCP > server. > > Anyone can help me? > > The GOgraph search engin URL > http://www.gograph.com > > Register here it's the free trial system! (Not finish but work) > http://www.gograph.com/fusion/en/cf_gograph/index.cfm > > Thank you > > Yanik Lupien > > Visicom Media > http://www.visic.com > > > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk > or send a message to [EMAIL PROTECTED] with > 'unsubscribe' in the body. > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=sts&body=sts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Why Netscape's serious lag time?
Yup, I've seen a perfect example of this with Geo Calendar. It has so many nested tables that even on a local server it renders too slowly in Netscape. I will say though that as clunky as Mozilla is, it rendered the same page more quickly than IE5. The best thing to do is take a look at your table structure and find places to streamline it. Philip -Original Message- From: Harold Goodson [mailto:[EMAIL PROTECTED]] Sent: Friday, August 25, 2000 7:04 AM To: [EMAIL PROTECTED] Subject: Why Netscape's serious lag time? Hey all, Might anyone be able to offer a plausible solution to Netscape's lag time at the following URL? It appears to be loading the tables and *all* of their images before displaying the page at all. This problem exists in other sites I have worked on and I've yet to find a solution outside of not using tables within tables. I can't imagine it being caused by the CF code, but I can't really see what's causing it to happen. http://www.awgear.com/products/index.cfm?fuseaction=dsp_products&Department _name=Sleeping%20Bags&Department_img=sleepingbag_tn_title.gif or just: http://www.awgear.com and click sleeping bags or most all of the links. Any ideas/suggestions would be appreciated. -Andy G. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Unknown Error
Anybody come across an odd error. Unknown exception condition Error occured for unknown cause. I have no idea why this is happening when I attempt to bring up the administrator screens. This is happening on a NT4 Workstation Portable, running Personal web server, and Coldfusion Enterprise (was personal edition), Service Pack 6a. This is a demo machine. Is it the Personal Web Server??? Adam Reynolds ColdFusion Consultant H.J. Heinz Tel.: +44 (0) 20 8756 5170 Mob.: +44 (0) 7973 386620 ** 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
REGISTRATION CLOSES TODAY!
*** REGISTRATION CLOSES TODAY! *** Advance Registration Only -- No On-Site Registration *** CFUG Members Get In For Less Than Half-Price! (see below) *** All Attendees Get Free CommerceBlocks Software *** Memphis AirTran Flights and Hotel Rooms Are Cheap *** You Know You Really Want To Attend... ECOMMERCE DEVELOPMENT WITH COLDFUSION SEMINAR Okay... You all know how great this thing is going to be next week, and how much you really want it and need it. If your boss won't pay for it then fund it yourself, quit when you get back, and find a job for more money with a company that "gets it." Three full days of exactly what you need to know to not only build killer ecommerce apps, but killer ColdFusion apps in general. There's a database design course built right in, too. When you're done, you get all the example code and free CommerceBlocks software. Remember: -- $195.00* for a three day, chef catered, materials heavy seminar with free software you can really use is incredibly cheap (it's below our cost). -- AirTran and other airlines' ticket prices are dirt cheap, as are hotel rooms in Memphis (see the Memphis travel and lodging links on www.coldfusionseminar.com) -- This seminar series is already booked through June 2001, so don't wait for it to come to your area. -- As of this writing we have only 20 seats left. For complete details and to register, go to www.ColdFusionSeminar.com. Be there! * Email [EMAIL PROTECTED] with your request for a $195.00 Special Price Seminar Pass, and we'll send you one right away. Respectfully, Adam Phillip Churvis President Productivity Enhancement, Inc. * PRODUCTIVITY ENHANCEMENT, INC. * * * *Publishers of the CommerceBlocks line of modular development tools* * for ColdFusion * * * * Website: http://www.commerceblocks.com E-mail: [EMAIL PROTECTED] * * Phone: 770-446-8866Fax:770-242-0410* * * -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
SQL JOIN
Hello. I am evaluating two columns under the same name in two different tables. The error I got, "A reference to column "ID" is ambiguous" was expected. My code is below. Can I do and INNER JOIN two resolve this error and retrieve the correct value? If so , how? I don't have much practice with using JOIN. Thanks in advance! SELECT Max(id) AS MaxOfID FROM db2admin.tb_assigned,db2admin.tb_complete where db2admin.tb_assigned.id = db2admin.tb_complete.id #NextPONum# -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
preventing simultaneous updates
Hi, I am trying to implement a check in my pages so that if user A is editing record 1 from edit form A at the same time that user B is editing record 1 from edit form B, the user who submits it second will get an error that someone has just updated this record. I have a field in my table called "status_date", which is populated with the sysdate every time a record is updated. This is what I've attempted: In each form page itself, I've immediately queried the current status date for the record. When I display this on the page for testing purposes, it displays in the format 2000-08-25 10:22:39. I then assign this value to a variable called "last_status_date". Then I pass last_status_date as a hidden field to my action page (the page that does the updates. Immediately in my action form (before any updates are made, I have the following: SELECT STATUS_DATE FROM SUG_SUGGESTIONS WHERE SUGGESTION_ID=#URL.SUGGESTION_ID# I have displayed the output of datedifference to see what is going on... On my action page, this is what I get for output: form last status date: 2000-08-25 status check from this page: 2000-08-25 10:40:59 difference: 0.445127314815 What is happening is that for some reason, the time portion of form.last_status_date is not passing with the hidden field, even though form.last_status_date fully displays on the form page as desired. Why would this be? Also, I believe that my reasoning is flawed for what I am trying to do, because of the actual dates. Should I be using different logic for determining if the record has been updated by user A just before user B submitted? Does this make sense? 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: REGISTRATION CLOSES TODAY!
I can't make it to this, if I weren't under unbearable deadline pressures I would be there in a heart beat. Adam, any chance that DBblocks,v2 will be available for download soon? Thanks. /mdeane -Original Message- From: Adam Phillip Churvis [mailto:[EMAIL PROTECTED]] Sent: Friday, August 25, 2000 10:40 AM To: [EMAIL PROTECTED] Subject: REGISTRATION CLOSES TODAY! *** REGISTRATION CLOSES TODAY! *** Advance Registration Only -- No On-Site Registration *** CFUG Members Get In For Less Than Half-Price! (see below) *** All Attendees Get Free CommerceBlocks Software *** Memphis AirTran Flights and Hotel Rooms Are Cheap *** You Know You Really Want To Attend... ECOMMERCE DEVELOPMENT WITH COLDFUSION SEMINAR Okay... You all know how great this thing is going to be next week, and how much you really want it and need it. If your boss won't pay for it then fund it yourself, quit when you get back, and find a job for more money with a company that "gets it." Three full days of exactly what you need to know to not only build killer ecommerce apps, but killer ColdFusion apps in general. There's a database design course built right in, too. When you're done, you get all the example code and free CommerceBlocks software. Remember: -- $195.00* for a three day, chef catered, materials heavy seminar with free software you can really use is incredibly cheap (it's below our cost). -- AirTran and other airlines' ticket prices are dirt cheap, as are hotel rooms in Memphis (see the Memphis travel and lodging links on www.coldfusionseminar.com) -- This seminar series is already booked through June 2001, so don't wait for it to come to your area. -- As of this writing we have only 20 seats left. For complete details and to register, go to www.ColdFusionSeminar.com. Be there! * Email [EMAIL PROTECTED] with your request for a $195.00 Special Price Seminar Pass, and we'll send you one right away. Respectfully, Adam Phillip Churvis President Productivity Enhancement, Inc. * PRODUCTIVITY ENHANCEMENT, INC. * * * *Publishers of the CommerceBlocks line of modular development tools * * for ColdFusion * * * * Website: http://www.commerceblocks.com E-mail: [EMAIL PROTECTED] * * Phone: 770-446-8866Fax:770-242-0410 * * * -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: SQL JOIN
You need to qualify which table you are pulling the id from, since you are using two different tables in your query... SELECT Max(tablename.id) AS MaxOfID FROM db2admin.tb_assigned,db2admin.tb_complete where db2admin.tb_assigned.id = db2admin.tb_complete.id Original Message Follows From: "James Taavon" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> Subject: SQL JOIN Date: Fri, 25 Aug 2000 10:44:41 -0400 Hello. I am evaluating two columns under the same name in two different tables. The error I got, "A reference to column "ID" is ambiguous" was expected. My code is below. Can I do and INNER JOIN two resolve this error and retrieve the correct value? If so , how? I don't have much practice with using JOIN. Thanks in advance! SELECT Max(id) AS MaxOfID FROM db2admin.tb_assigned,db2admin.tb_complete where db2admin.tb_assigned.id = db2admin.tb_complete.id #NextPONum# -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Results Query to Oracle
I want to take the results of a query and insert the results into an Oracle table. Looking into the books, it really doesn't cover anything like that. Here are some of the basic elements I have so far. This code works except for the fact it will only insert on 1 record. Do I use CFLOOP or what. Thanks for the guidance. SELECT B.ENDITEMPN, B.ENDITEMSN, B.LOCATION, C.PRESSURENAME, A.END_ITEM_NAME FROMDSTS.END_ITEM A, DSTS.PRESSURE_REQTS C, DSTS.ENDITEMSTORAGE B WHERE (A.ENDITEMPN = B.ENDITEMPN) AND (B.ENDITEMPN = C.ENDITEMPN) INSERT INTO DSTS.EXCELEXPORT (ENDITEMNAME,ENDITEMPN,ENDITEMSN,LOCATION) VALUES('#ENDITEMNAME#','#ENDITEMPN#', '#ENDITEMSN#','#LOCATION#') Jim Ray -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: IsDefined() Problem
> I would imagine that if you don't put quotes around the > variable in your IsDefined(), ColdFusion will evaluate > the variable and check to see if that is defined rather > than the variable itself. If that's the case, I would > assume it would always evaluate to true. No, actually, it's more likely to evaluate to false in that case. true false true false 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: SQL JOIN
The thing is I need am pulling the ID field from both tables. So should I just rename one column a differnet name? Terri Stocke wrote: > > You need to qualify which table you are pulling the id from, since you are > using two different tables in your query... > > > SELECT Max(tablename.id) AS MaxOfID > FROM db2admin.tb_assigned,db2admin.tb_complete > where db2admin.tb_assigned.id = db2admin.tb_complete.id > > > > > Original Message Follows > From: "James Taavon" <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> > Subject: SQL JOIN > Date: Fri, 25 Aug 2000 10:44:41 -0400 > > Hello. > > I am evaluating two columns under the same name in two different tables. > The error I got, "A reference to column "ID" is ambiguous" was expected. > My code is below. Can I do and INNER JOIN two resolve this error and > retrieve the correct value? If so , how? I don't have much practice with > using JOIN. > > Thanks in advance! > > > SELECT Max(id) AS MaxOfID > FROM db2admin.tb_assigned,db2admin.tb_complete > where db2admin.tb_assigned.id = db2admin.tb_complete.id > > > > > > #NextPONum# > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > > > 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=lists&body=lists/cf_talk or send a >message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: OT: CSS
> Anyone have a document/list/URL's of things that "work/don't work" > on NS4+ and IE4+ browsers? http://www.webreview.com/wr/pub/guides/style/mastergrid.html "The Master List is the mother of all CSS (Cascading Style Sheet) charts, listing every aspect of the CSS spec and identifying how well it is supported by Netscape 4.x and Internet Explorer 3.x, 4.x, and 5.x for both Macintosh and Windows 95, and Opera 3.6 for Windows. " Eva -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Password Protecting a DB/DSN
> In a shared hosting environment with critical data ... If it's "critical data", you won't be able to store it in a shared hosting environment, unless you trust all of the other people with access to that server. It's as simple as that. It would be really difficult for the ISP to build sandboxes that a moderately skilled developer couldn't step out of, even using Advanced Security and turning off CFFILE, CFDIRECTORY, etc. 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL JOIN
> I am evaluating two columns under the same name in two > different tables. The error I got, "A reference to column > "ID" is ambiguous" was expected. My code is below. Can I do > an INNER JOIN two resolve this error and retrieve the correct > value? If so, how? I don't have much practice with using JOIN. > > > SELECT Max(id) AS MaxOfID > FROM db2admin.tb_assigned,db2admin.tb_complete > where db2admin.tb_assigned.id = db2admin.tb_complete.id > You'd have the same problem whether you used an ANSI SQL-92 INNER JOIN or the WHERE clause join you're using now. The problem is that you have two ID fields, one in each table, and you have to specify which one you want to retrieve (even though they'll have the same values because of your join): SELECT MAX(db2admin.db_assigned.id) ... 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Yet another filesize question
> > i feel so unloved. :) > > Chris, we love you. > > (do they say things like that in the US army?) No, of course not. In the Army, you'd say "we love you, SIR!" (former SP4, 3/35 Armor Btn) 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: SQL JOIN
You could pull the max ID from each table like this: > SELECT Max(db2admin.tb_assigned.id) AS MaxOfID1, Max(db2admin.tb_complete.id) AS MaxOfID2 > FROM db2admin.tb_assigned,db2admin.tb_complete > where db2admin.tb_assigned.id = db2admin.tb_complete.id > > > or whatever... But, I'm unclear as to the relationship between the tables. Will both tables necessarily always have the same number of ID's? If so, you can query on just one of ID fields instead of both...what exactly are you looking to do? T Original Message Follows From: "James Taavon" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: SQL JOIN Date: Fri, 25 Aug 2000 10:59:12 -0400 The thing is I need am pulling the ID field from both tables. So should I just rename one column a differnet name? Terri Stocke wrote: > > You need to qualify which table you are pulling the id from, since you are > using two different tables in your query... > > > SELECT Max(tablename.id) AS MaxOfID > FROM db2admin.tb_assigned,db2admin.tb_complete > where db2admin.tb_assigned.id = db2admin.tb_complete.id > > > > > Original Message Follows > From: "James Taavon" <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> > Subject: SQL JOIN > Date: Fri, 25 Aug 2000 10:44:41 -0400 > > Hello. > > I am evaluating two columns under the same name in two different tables. > The error I got, "A reference to column "ID" is ambiguous" was expected. > My code is below. Can I do and INNER JOIN two resolve this error and > retrieve the correct value? If so , how? I don't have much practice with > using JOIN. > > Thanks in advance! > > > SELECT Max(id) AS MaxOfID > FROM db2admin.tb_assigned,db2admin.tb_complete > where db2admin.tb_assigned.id = db2admin.tb_complete.id > > > > > > #NextPONum# > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > > > 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: OT- Program to compare two pages of code for differences
Larry, Check out Component Software Diff (CSDiff). It can compare two files as well as all the files in two folders. Available from download.com HTH Sean G -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 22, 2000 5:52 PM To: [EMAIL PROTECTED] Subject: OT- Program to compare two pages of code for differences Does anyone know where I can find a program for comparing two pages of code for differences? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: SQL JOIN
What exactly do you want. Do you want: a. the maximum id in tb_assigned b. the maximum id in tb_complete c. the maximum id that occurs in either table d. the maximum id that occurs in both tables For a or b you wouldn't need a join for c you would need to run two separate queries and compare maxvalues for d you query would work if you prefix the id in max(id) with either table name - Original Message - From: "James Taavon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, August 25, 2000 8:44 AM Subject: SQL JOIN > Hello. > > I am evaluating two columns under the same name in two different tables. > The error I got, "A reference to column "ID" is ambiguous" was expected. > My code is below. Can I do and INNER JOIN two resolve this error and > retrieve the correct value? If so , how? I don't have much practice with > using JOIN. > > Thanks in advance! > > > > SELECT Max(id) AS MaxOfID > FROM db2admin.tb_assigned,db2admin.tb_complete > where db2admin.tb_assigned.id = db2admin.tb_complete.id > > > > > > > #NextPONum# > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Cookies
> Hey all, I have a cookie question ... > > I was reading an article on Allaire's site, Cookie Considerations and > Limitations, article 165, and it mentions that there is a maximum of 20 > cookies per domain. > This surely can't be a *total* can it? Does this mean that there can only > be 20 cookies set at any one time? It's not just number of cookies, but size of cookies... NS has a smaller limit than IE, but it's still a limit If you need to use that many cookies, then you're using them for the wrong reasons Why not just store one reference in a cookie, and then use that reference in a database and store the information - this makes it easier for them to return and re-pick-up if they lose their cookies as well 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: arraysort
> Dana, I know nothing about arrays. > How could I use this? > Say I have a DB with 5000 mail address. > Any pointers would be great. > > Is there any thing in the wack book about it? If you can, always sort in SQL - it's a LOT faster and lighter on the server 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Yet another filesize question
An I believe the theme song in the army is "Kiss Me Good Night Sergent Major !!!" Sorry I could not resist that one - Original Message - From: "Dave Watts" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, August 26, 2000 1:00 AM Subject: RE: Yet another filesize question | > > i feel so unloved. :) | > | > Chris, we love you. | > | > (do they say things like that in the US army?) | | No, of course not. In the Army, you'd say "we love you, SIR!" | | (former SP4, 3/35 Armor Btn) | 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: arraysort
> Dana, I know nothing about arrays. > How could I use this? > Say I have a DB with 5000 mail address. > Any pointers would be great. Well, it depends what you want to go with the email addresses. If you just want them ordered, you can probably just use an ORDER BY clause in your query. In my experience, CF looping is a little slow, so it's probably best to let your database do most of the hard work. What are you trying to do? > > Is there any thing in the wack book about it? Don't think I've heard of the wack book. Dana Larose ColdFusion Monkey Canadian Web Design & Consulting Inc. A: 701-281 McDermot Avenue (McDermot & King) P: 204.946.5155 C: 204.228.0477 F: 204.946.5156 E: [EMAIL PROTECTED] W: http://www.cdnwebdesign.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: OT- Program to compare two pages of code for differences
I sent this last night ill forward it here. http://www.meurrens.org/ip-Links/Tools/windiff/windif12.zip Windiff, based on the GNU utility diff.. works like a charm. Also Visual Source Safe has a file comparison utility.. Jeremy Allen [EMAIL PROTECTED] [Insert quarter] -Original Message- From: Sean German [mailto:[EMAIL PROTECTED]] Sent: Friday, August 25, 2000 11:10 AM To: '[EMAIL PROTECTED]' Subject: RE: OT- Program to compare two pages of code for differences Larry, Check out Component Software Diff (CSDiff). It can compare two files as well as all the files in two folders. Available from download.com HTH Sean G -Original Message- From: Larry Juncker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 22, 2000 5:52 PM To: [EMAIL PROTECTED] Subject: OT- Program to compare two pages of code for differences Does anyone know where I can find a program for comparing two pages of code for differences? -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: cloop and multiple select box
> I find this simple, but only get one item to highlight. > > I am building a multiple select box from one query. From another query I > pull a user account. I want to highlight those options that the user has > previously selected while displaying the general list. > > It highlights one option, but not for the multiple selections previously > made by the user: > > > > > trim(#C#)>selected>#cat_title# > > You to select the code is the problem - you're using IS which implies one answer Remember than returns a comma separates list (as long as you POST the form), so you should treat it as a list selected>#Cat_Title# Should do the trick, although, not knowing your queries, I can't guarantee it... 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL UNION across 2 Differnt DSN's
> I would like to do a simple select statement, but need to mingle the > results together for display purposes. I am trying to merge the > select from each of two identical tables located on two different > Oracle DB Servers. A simple UNION statement can only live under a > single CFQuery statement (which of course points to a single DSN) > any suggestions on an efficient way to do this in CF? As mentioned in many previous threads, you cannot combine 2 DSNs in one query You could try talking to the other databse, but I don't know the Oracle syntax - it may be the same as SQL Server's one... this is referring to the table as "database.dbo.table" 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: netscape taking a long time to render page
> hey guys,i've got a page here that is taking a very very long time to > render in NS (after it has downloaded) i know its because of some tag > formating, but i cant seem to find it. all my tables check out as > far as i > can tell.. can i get a few more sets of eyes to take a look at the html & > possibly show me what i've done wrong? > > heres the url for the html output of the page thats giving me a problem: > > http://www.yarooze.com/kitehigh/testNSproblem.cfm > > its actually all cold fusion code, so dont be fooled by the .cfm ext. Since it gives a CF 404 error, here are some comments about NS rendering pages All images without Height or Width will have to start loading before the page can render the text - unlike IE, it cannot dynamically re-align the page All tables with Align= will have to have all information around them loaded before they can be rendered All tables within tables have to be rendered before anything below them can be rendered Overall, NS is HORRIBLE for layout work, but enforces your HTML to be strict 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OLE DB vs. ODBC
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_001_01C00EAA.342889B8 Content-Type: text/plain; charset="iso-8859-1" Has anyone done any benchmarks between the two different Database connections layers? I know some things don't work through OLE DB but is there a list or any documentation listing the advantages and disadvantages? Thank you for any information you can provide. Rich --_=_NextPart_001_01C00EAA.342889B8 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable OLE DB vs. ODBC Has anyone done any benchmarks between the two = different Database connections layers? I know some things don't = work through OLE DB but is there a list or any documentation listing = the advantages and disadvantages? Thank you for any information you can provide. Rich --_=_NextPart_001_01C00EAA.342889B8-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: ColdFusion and Cobalt RAQ
I was doing some research on this a while back I went to the Cobalt site and looked in the KnowledgeBase and here is what I found. Question Is the RaQ 3i binary compatible with Redhat 6.0, and if so does it support Allaire Cold Fusion 4.5 for Linux? Response NOTE: UNSUPPORTED. Cobalt Networks currently does not offer support for third party software or modified systems. Please contact the appropriate software vendor for further assistance. Modifications through root shell access could potentially void your warranty. A fee will be assessed by Cobalt for fixes or rebuilds on systems with unsupported modifications. Yes, the RaQ3i is binary compatible with RedHat 6. Although Cobalt has not tested Cold Fusion with the RaQ3i, we have received reports from customers that it does work. At 12:15 AM 8/21/2000 -0400, you wrote: >Anyone had any experience with Cold Fusion and a Cobalt RAQ 3 or 4 server? >I'm interested to find out what people have come up with trying to get these >two beasts working together. > >Jake > >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. -- Nick McClure[EMAIL PROTECTED] Technical Director 859.245.9656 squareFish Mediawww.squareFish.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: SQL JOIN
The ID field is the number assigned to a certain project. This value will exist in both tables, but not at the same time. To assign a new number to a project I need to check the "Current Assignment" table ID and the "Complete Assignment" ID to make sure that I dont re-assign a number already used. If the number already exists in the complete table without my knowledge, then when the "current assignment" table ID gets passed into the "complete assignment" table ID will result in the standard SQL error referring to duplicate row values. The goal is to have this number generated automatically and inserted into the form so I or anybody else does have to figure out what the last number used was for a project. Does that make sense? Terri Stocke wrote: > > You could pull the max ID from each table like this: > > > > SELECT Max(db2admin.tb_assigned.id) AS MaxOfID1, > Max(db2admin.tb_complete.id) AS MaxOfID2 > > FROM db2admin.tb_assigned,db2admin.tb_complete > > where db2admin.tb_assigned.id = db2admin.tb_complete.id > > > > > > or whatever... > > But, I'm unclear as to the relationship between the tables. Will both tables > necessarily always have the same number of ID's? If so, you can query on > just one of ID fields instead of both...what exactly are you looking to do? > > T > > Original Message Follows > From: "James Taavon" <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > Subject: Re: SQL JOIN > Date: Fri, 25 Aug 2000 10:59:12 -0400 > > The thing is I need am pulling the ID field from both tables. So should > I just rename one column a differnet name? > > Terri Stocke wrote: > > > > You need to qualify which table you are pulling the id from, since you > are > > using two different tables in your query... > > > > > > SELECT Max(tablename.id) AS MaxOfID > > FROM db2admin.tb_assigned,db2admin.tb_complete > > where db2admin.tb_assigned.id = db2admin.tb_complete.id > > > > > > > > > > Original Message Follows > > From: "James Taavon" <[EMAIL PROTECTED]> > > Reply-To: [EMAIL PROTECTED] > > To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> > > Subject: SQL JOIN > > Date: Fri, 25 Aug 2000 10:44:41 -0400 > > > > Hello. > > > > I am evaluating two columns under the same name in two different tables. > > The error I got, "A reference to column "ID" is ambiguous" was expected. > > My code is below. Can I do and INNER JOIN two resolve this error and > > retrieve the correct value? If so , how? I don't have much practice with > > using JOIN. > > > > Thanks in advance! > > > > > > SELECT Max(id) AS MaxOfID > > FROM db2admin.tb_assigned,db2admin.tb_complete > > where db2admin.tb_assigned.id = db2admin.tb_complete.id > > > > > > > > > > > > #NextPONum# > > > > > -- > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > To Unsubscribe visit > > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk > or > > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > > the body. > > > > > > 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=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > > > 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=lists&body=lists/cf_talk or send a >message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Grab image size with CFFile object attributes
> > Question, you can grab a file size in a CFFile tag when you upload a > file/image but can you also grab the image height and width? > > I could guess but I'm not entirely sure. It makes sense to have something > like this. Personally I use CFX_ImageInfo, http://www.intrafoundation.com/freeware.html. But then I wrote it, so you'd expect that, eh? :) --min -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: SQL JOIN
Hey guys, Can anyone help me with this problem? I need to send an email in text format. I also next to attach an HTML file. The HML file needs to be created when I am sending the email and contain a link that I generate on the fly. Any ideas? Thanks in advance, Brandon Brandon Behrens The Internet Design Firm 512.451.5225 [EMAIL PROTECTED] http://www.theidf.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: ColdFusion Server-side Source Control
Hmmm... That's where I seem to be heading as well. :( Good idea, not so good implementation. I'm going to poke around a bit more - I'll let everyone know if I get it to work. Thanks for the feedback Truman -Original Message- From: Milks, Jim [mailto:[EMAIL PROTECTED]] Sent: Friday, August 25, 2000 7:21 AM To: '[EMAIL PROTECTED]' Subject: RE: ColdFusion Server-side Source Control Yes I have some experience, and my conclusion is STAY AWAY! Vss and CF just don't seem to integrate well. We thought we had it solved, until we lost a day's worth of development. Our final conclusion was to simply run CF and VSS seperately and use Alt + Tab a lot. I would agree that the multiple projects appear to be the issue, but we never had enough time to invest in trying to solve it... Good luck.. JM -Original Message- From: Truman Esmond III To: [EMAIL PROTECTED] Sent: 24/08/00 7:43 PM Subject: ColdFusion Server-side Source Control Okay, I've spent enough time spinning my wheels on this by myself - any help is appreciated :) Anyone successfully implemented server-side source control through CF? Found better docs somewhere on this feature within CF? We've got source control set up through studio, but we're trying to have an internal development server connect to a client's VSS db, and have all of our local developers use RDS locally on that machine for this effort - the problem seemingly lies in that there are multiple projects and multiple working directories. The form in the CFAdmin only allows a single DB to be connected (and is kinda vague about exactly which .ini file to connect to) and only a single working directory. Any experiences, configurations and references to other documentation would be greatly appreciated! Secondly and similarly, has anyone tried using the CF server-side source control or even studio integrated source control using SourceGear's SourceOffSite? Looks like it *should* work the same (only faster) since their based on the same API... Truman -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: SQL JOIN
Okay, what I would say first is that you probably have some referential integrity problems, as the two tables are dependent on each other, and the completed table shouldn't have any id's in it that haven't already been used in the current table. But, if you must do this...here's one solution. It's not the most elegant, and depending on your db, you could probably do this easier with triggers or something. SELECT max(c.id) AS maxid FROMcurrentassingmenttable c Selectp.id fromcompletetable p WHERE p.id = #newid# Oops, that id was already used! You have to decide what you want to do if the id was already used...incrementwhat? Does that get you started? -d Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg 432 N. Lake Street Madison, WI 53706 (608) 265-7923 -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: REGISTRATION CLOSES TODAY!
Will session notes (or even a videotape?) be made available after the seminar? (Even if we have to purchase them) At 10:47 AM 8/25/00 -0400, Mike Deane wrote: >I can't make it to this, if I weren't under unbearable deadline >pressures I would be there in a heart beat. Adam, any chance that >DBblocks,v2 will be available for download soon? > >Thanks. >/mdeane > >-Original Message- >From: Adam Phillip Churvis [mailto:[EMAIL PROTECTED]] >Sent: Friday, August 25, 2000 10:40 AM >To: [EMAIL PROTECTED] >Subject: REGISTRATION CLOSES TODAY! > > >*** REGISTRATION CLOSES TODAY! > >*** Advance Registration Only -- No On-Site Registration >*** CFUG Members Get In For Less Than Half-Price! (see below) >*** All Attendees Get Free CommerceBlocks Software >*** Memphis AirTran Flights and Hotel Rooms Are Cheap >*** You Know You Really Want To Attend... > >ECOMMERCE DEVELOPMENT WITH COLDFUSION SEMINAR > >Okay... > >You all know how great this thing is going to be next week, and how much >you really want it and need it. If your boss won't pay for it then fund >it >yourself, quit when you get back, and find a job for more money with a >company that "gets it." > >Three full days of exactly what you need to know to not only build >killer >ecommerce apps, but killer ColdFusion apps in general. There's a >database >design course built right in, too. When you're done, you get all the >example code and free CommerceBlocks software. > >Remember: > >-- $195.00* for a three day, chef catered, materials heavy seminar with >free software you can really use is incredibly cheap (it's below our >cost). > >-- AirTran and other airlines' ticket prices are dirt cheap, as are >hotel >rooms in Memphis (see the Memphis travel and lodging links on >www.coldfusionseminar.com) > >-- This seminar series is already booked through June 2001, so don't >wait >for it to come to your area. > >-- As of this writing we have only 20 seats left. > >For complete details and to register, go to www.ColdFusionSeminar.com. > >Be there! > >* Email [EMAIL PROTECTED] with your request for a >$195.00 >Special Price Seminar Pass, and we'll send you one right away. > > >Respectfully, > >Adam Phillip Churvis >President >Productivity Enhancement, Inc. > > > >* PRODUCTIVITY ENHANCEMENT, INC. >* >* >* >*Publishers of the CommerceBlocks line of modular development tools >* >* for ColdFusion >* >* >* >* Website: http://www.commerceblocks.com E-mail: >[EMAIL PROTECTED] * >* Phone: 770-446-8866Fax:770-242-0410 >* >* >* > > > > >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk >or send a message to [EMAIL PROTECTED] with >'unsubscribe' in the body. >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a >message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --- 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=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: REGISTRATION CLOSES TODAY!
Will session notes (or even a videotape?) be made available after the seminar? (Even if we have to purchase them) At 10:47 AM 8/25/00 -0400, Mike Deane wrote: I can't make it to this, if I weren't under unbearable deadline pressures I would be there in a heart beat. Adam, any chance that DBblocks,v2 will be available for download soon? Thanks. /mdeane -Original Message- From: Adam Phillip Churvis [mailto:[EMAIL PROTECTED]" eudora="autourl">mailto:[EMAIL PROTECTED]] Sent: Friday, August 25, 2000 10:40 AM To: [EMAIL PROTECTED] Subject: REGISTRATION CLOSES TODAY! *** REGISTRATION CLOSES TODAY! *** Advance Registration Only -- No On-Site Registration *** CFUG Members Get In For Less Than Half-Price! (see below) *** All Attendees Get Free CommerceBlocks Software *** Memphis AirTran Flights and Hotel Rooms Are Cheap *** You Know You Really Want To Attend... ECOMMERCE DEVELOPMENT WITH COLDFUSION SEMINAR Okay... You all know how great this thing is going to be next week, and how much you really want it and need it. If your boss won't pay for it then fund it yourself, quit when you get back, and find a job for more money with a company that "gets it." Three full days of exactly what you need to know to not only build killer ecommerce apps, but killer ColdFusion apps in general. There's a database design course built right in, too. When you're done, you get all the example code and free CommerceBlocks software. Remember: -- $195.00* for a three day, chef catered, materials heavy seminar with free software you can really use is incredibly cheap (it's below our cost). -- AirTran and other airlines' ticket prices are dirt cheap, as are hotel rooms in Memphis (see the Memphis travel and lodging links on http://www.coldfusionseminar.com/" eudora="autourl">www.coldfusionseminar.com) -- This seminar series is already booked through June 2001, so don't wait for it to come to your area. -- As of this writing we have only 20 seats left. For complete details and to register, go to http://www.coldfusionseminar.com/" eudora="autourl">www.ColdFusionSeminar.com. Be there! * Email [EMAIL PROTECTED] with your request for a $195.00 Special Price Seminar Pass, and we'll send you one right away. Respectfully, Adam Phillip Churvis President Productivity Enhancement, Inc. * PRODUCTIVITY ENHANCEMENT, INC. * * * * Publishers of the CommerceBlocks line of modular development tools * * for ColdFusion * * * * Website: http://www.commerceblocks.com /" eudora="autourl">http://www.commerceblocks.com ; E-mail: [EMAIL PROTECTED] * * Phone: 770-446-8866 Fax: 770-242-0410 * * * -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/" eudora="autourl">http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk" eudora="autourl">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/" eudora="autourl">http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk" eudora="autourl">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=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/" eudora="autourl">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?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Session timeout?
This is a multi-part message in MIME format. --=_NextPart_000_0021_01C00E93.8B251AE0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Thanks guys, Here is my scenario, i have a custom server = application that protects my directory.So, the first time the user hits the page.. = will be asked for userid and password.This gets written in CGI.Auth_user(winnt = log files). I grab the userid and set all the application or session variables. So in this particular case, when a session expires, = a new session is=20 automatically created.What i really need is to, some how verify whether = this particular session has expired. Some like I cant verify for session variables cause a new = session is dynamically created and new session variables get instanciated. Appretiate any help.. Thanks Joe --=_NextPart_000_0021_01C00E93.8B251AE0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Thanks=20 guys, &nbs= p;=20 Here is my scenario, i have a custom server applicationthat protects = my=20 directory.So, the first time the user hits the page.. will beasked = for=20 userid and password.This gets written in CGI.Auth_user(winnt log=20 files). I grab the userid and set all the application = or=20 session=20 variables. = ; =20 So in this particular case, when a session expires, a new session is=20 automatically created.What i really need is = to, some=20 how verify whether thisparticular session has=20 expired. &= nbsp;=20 Some=20 like = ;=20&nbs= p;= ; =20 &nbs= p; =20 I cant verify for session variables cause a new sessionis = dynamically=20 created and new session variables get=20 instanciated.&nbs= p; =20 Appretiate any=20 help.. = ; =20 Thanks &nb= sp;=20 Joe --=_NextPart_000_0021_01C00E93.8B251AE0-- -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.&n= bsp; =20
questions about "cachedwithin"
To paraphrase the CFWACK: 'The ColdFusion caching logic takes , , and other dynamic structures in queries into account, ensuring that caching is safe to use within a dynamic environment.' OK .. Say I have SELECT field1 FROM table WHERE field2 = '#Variables.index#' I'm assuming in this scenario I will end up with 10 different cached queries ... or would all of the queries overwrite each other because they all have the same name? Also, does anyone know how much overhead is associated with removing the oldest cached query from memory and replacing it with the newest when the limit is reached? I'm guessing even if it has to be done a lot, it's still faster than than hitting the database for 15 rows of data, every single time. Todd Ashworth -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Fw: Please hack me, others are....
John, > > I knew I forgot something :-) > > The English site has the game, but we had to reverse program it, so they > aren't really the same. If it helps http://www.thesimpsons.com > > Otherwise I've included some translations for you to get to the code part, > that I'm sure you can read. > > Start At: > http://www.lossimpson.com/SIM/spanish/MUNDIAL/BARTBOWL/index.cfm?fa=registra > tion > > You can register as many times as you need to help me find the hole. You can > even but in bogus registration information. > > Nombre = Name > Apellidos = Last Name > Fecha de Nacimiento: = 00/00/2000 > Pais: = country > email = email (can be bogus) > contrasena: = password > pregunta: = answer to question you can put in a word. > > Then it will send you back to the log in page. > http://www.lossimpson.com/SIM/spanish/MUNDIAL/BARTBOWL/index.cfm > Put in your email and password. > > Now you'll see a launch page: If you want to see top scores click on the > link that reads tablero de ganadores. > > If you have flash 4 click on the flash movie that says Bart Bowl. A pop up > window will appear. Click on the big blue button "jugar" = "play game". > > The question will come up, and you can guess at the correct ones, after each > of the five question you'll be taken to a flash screen telling you if your > answer is right, then click on the blue button "continuar". > > PS I'm not using cookies. > > TIA > > Rick > > __ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.