Re: FINALLY!!! It Arrived!
I browsed through Ben's or Jerremy's Web application Contruction book. I didnt really find anything exciting. Perhaps the good stuff is comming in the Advanced Web Contruction Book. Joe - Original Message - From: Erika L. Walker-Arnold [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 7:20 AM Subject: RE: FINALLY!!! It Arrived! Well, Ben should get Amazon to include his name in the Author's list on the book description. wink Thanks Anthony! Erika | -Original Message- | From: Anthony Wong [mailto:[EMAIL PROTECTED]] | | Yes, it's one of the books written by Ben Forta et al. ! I | have one on my desk right now. Pretty easy to read. The | font size is somewhat bigger than Ben Forta's Web App. | Construction Kit book. Lots of Action Scripts. Recommended! | | anthony | | | Are you talking about this book? | | http://www.amazon.co.uk/exec/obidos/ASIN/0321125150/ref=sr_a | ps_books_1 | _1 | /026-8152064-3643606 | | Because it's not a *Ben* book ... | | Just asking because I'd like to order it but I want to | make sure I | order the correct one. Thanks. | | Erika | | | | -Original Message- | | From: jt [mailto:[EMAIL PROTECTED]] | | Sent: Thursday, September 12, 2002 12:33 AM | | To: CF-Talk | | Subject: SOT: FINALLY!!! It Arrived! | | | | | | It finally arrived today!!! I ordered one of Ben's | new books, | | Reality ColdFusion MX: Flash MX Integration, from | Amazon on Aug | | 28th, and it just arrived today!!! | | | | I haven't had a chance to read much yet, but I skimmed the | | chapters and it looks great. I especially love the | fact that the | | book is not aimed at beginners. I am sometimes tired | of reading | | about how to use access DBs and web dev basics for | 95% of a book | | to get a little bit of the good stuff. This book looks much | | better. It goes through the development methodolgy of the | | projects and shows memos, specs, flow charts and the | like...good | | material. | | | | Anyways, I look forward to going through the | projects! Good work | | on the new series. | | | | | | Josh Trefethen | | Certified CF Developer | | http://exciteworks.com | | __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Client Vars again
Susan, Cflocation is a client side redirect .. in effect it changes the header info of the clients browser to the new url page.. so NO variables will be set by the caller. change the CFLOCATION to some like script language=JavaScript self.location=thePagetoRedirect.cfm; /script I dont think your problem has anything to with client/session/cookie vars... Yes the origination of the problem... can be usage of CFLOCATION This should make a difference.. Joe - Original Message - From: Andre Turrettini [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, September 06, 2002 3:50 PM Subject: RE: Client Vars again Hi Susan, Can you give full details. Db, os, whats the applciation, intranet/extranet/web,cfserver details,cluster/singleserver? Have you tried session vars or homegrown client vars? Can you consistently set a cookie and across page requests read it properly? DRE -Original Message- From: Susan Hamilton-Allen [mailto:[EMAIL PROTECTED]] Sent: Friday, September 06, 2002 12:50 PM To: CF-Talk Subject: RE: Client Vars again Adrian: I posted to CF-Talk several times yesterday (with no useful results) with a similar problem regarding client vars. We are now re-engineering to write cookies instead. I had posted a notice from MM about cflocation addtoken=yes incrementing CFID. Look at your CFID table; we had new rows being written for each write to the client state, with incremented CFIDs. We changed to addtoken=no and all of a sudden only one user could write to the database at all. We tried, as you have, to find a common denominator to explain the inconsistent behavior among 5 machines; browser versions, os versions, etc. After much trial and error, I uninstalled CFMX, reinstalled, and are now using cookies instead. Hope you have better luck than us; like I said, take a look at your db and you may see the same symptoms. Susan Hamilton Allen Web Programmer Pfingsten Publishing, L.L.C. Seven Hills, OH 44131 -Original Message- On Fri, 6 Sep 2002, Adrian Lynch wrote: I've posted this to CF-Talk, sorry for any who get both and don't like cross posts... Is there anyone out there that's built reliable login/logout functionality into their site? Something that works on ALL browser combinations? This is what we're doing... Client vars stored in a DB Using the usual code to kill a session on close of the browser CFMX, SQL Server 7 Testing on most combinations of browser. Trying to figure out what's going wrong wouldn't be so bad if we could just have some consistency in the way it's going wrong. We have... Logging in on 2nd, 3rd, 4th, 5th try instead of the 1st Not able to log out, trying both reseting the client vars back to their original state and deleting them altogether Having to change a cflocation to a window.location to get it to log in on IE5 (don't ask) I've just said to the guy I'm building it with, shall we pass cfid and cftoken in all the links and redirects, see if that cures it. What does everyone else think. It's not the easiest thing to debug something that you can't reliably replicate :O( Adrian Lynch Thoughtbubble Ltd -- United Kingdom http://www.thoughtbubble.net Ph: +44 (0) 20 7387 8890 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s) . Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0) 20 7387 8890 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Writing efficient CFIF statements
The LEAST no of CFIF is the route to best code/speed etc.. This is my theory though Using CFSCRIPT blocks, short-cut evaluation, Switch statements wherever possible than CFIF, arranging likely executable CFIF's/Switch first etc Would be cleaner code to seperate Application Logic from Presentation layer. eg qry_studentStatus.cfm (Query) dsp_studentStatus.cfm(Display) Use of CFoutput's only where necessary is faster than wraping it around entire HTML etc. Joe Certified Advanced ColdFusion Developer [EMAIL PROTECTED] -Original Message- From: Adams, Stephen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 5:09 AM To: CF-Talk Subject: Writing efficient CFIF statements ** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hi, I am trying to put more structure into my CF code. My idea is to separate the ColdFusion processing from the HTML structure and use CSS for the look of the site. I am trying to get an idea of what is the best way to separate the CF. I know that I could use custom tags, user defined function and if I was using MX, then components. But these are for code that can across used in multiple pages. What I am talking about is the CF for an individual page. What has all this to do with CFIF statements, well. I was thinking of setting a series of flags that are checked against in my HTML. The CFIF statements are there to check the value of these flags and amend the page depending on these flags. So I want to be able to write good efficient CFIF statements so that my code is up to speed. Here's an example of what I am talking about: !--- Default ColdFusion Parameters --- cfparam name=QueryResults default= type=string !--- ColdFusion Processing --- cfquery name=myQuery datasource=myDSN SELECT * FROMmyTable /cfquery !--- Sets flags --- cfif myQuery.RecordCount EQ 0 cfset QueryResults = 1 /cfif !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN html head titleUntitled/title /head body cfif QueryResults EQ 1 table cellspacing=2 cellpadding=2 tr td class=mainFontResults found./td /tr /table cfelse table cellspacing=2 cellpadding=2 tr td class=mainFontNo results found./td /tr /table /cfif /body /html This is a simple example, but it shows how I want to keep the processing separate at the top of the page. My question, finally, is how are CFIF statements best written if I want to code this way and or is there a better way of writing my CF code. Thanks. ** Westminster City Council switchboard: +44 20 7641 6000 ** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ** __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Protecting non CF files with CF
AuthentiX... used it before.. How do you go about tracking who downloaded what and how many times etc? AuthentiX is built with an ISAPI filter that overrides Windows NT security model..(Challenge/Response) and creates an Authenticated user, (CGI.Auth_User) gets populated. The other disadvantage... is the session doesnt time out until the use closes his browser. I would still advice CFCONTENT and possibly secure the files somewhere other than wwwroot.. without public access and use CFContent to deliver the files. I am not sure... about the overhead...havent seen anybody mention it. Joe Certified Advanced ColdFusion Developer [EMAIL PROTECTED] -Original Message- From: JLH All Turbo [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 9:50 AM To: CF-Talk Subject: Protecting non CF files with CF We have to protect an entire directory and it's subdirectories with CF. We'd like to use CF to process our logins.. but can't have people directly linking to JPGs and MPGs etc under neath.. since CF can't really protect these individual files unless called through a CFM page, we've run into a problem. How can we accomplish this? We DO own a copy of AuthentiX and unfortunately CFContent is not a viable solution. This site will have upwards of 12,000 simultaneous users and CFContent has too much overheard. Thank you! JLH __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Writing efficient CFIF statements
If you looking at application architecture design.. Fusebox does a good job www.fusebox.org. this has helped me a lot. all sorts of changes can be done much faster... and gets code organized. Joe Certified Advanced ColdFusion Developer [EMAIL PROTECTED] -Original Message- From: Adams, Stephen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 11:13 AM To: CF-Talk Subject: RE: Writing efficient CFIF statements ** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Thanks Joe, That was what I was kind of looking for. I am also thinking about the way I design application. I find that a lot of my app's are not very flexable. If someone wants to have a new field in a form or a new page added in between two existing pages. I find it causes me a lot of re-writing to make these simple changes. Does anyone have any tips that could help me design better code. Stephen -- From: Joe Bastian[SMTP:[EMAIL PROTECTED]] Sent: 16 July 2002 16:06 To: CF-Talk Subject: RE: Writing efficient CFIF statements The LEAST no of CFIF is the route to best code/speed etc.. This is my theory though Using CFSCRIPT blocks, short-cut evaluation, Switch statements wherever possible than CFIF, arranging likely executable CFIF's/Switch first etc Would be cleaner code to seperate Application Logic from Presentation layer. eg qry_studentStatus.cfm (Query) dsp_studentStatus.cfm(Display) Use of CFoutput's only where necessary is faster than wraping it around entire HTML etc. Joe Certified Advanced ColdFusion Developer [EMAIL PROTECTED] -Original Message- From: Adams, Stephen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 5:09 AM To: CF-Talk Subject: Writing efficient CFIF statements ** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hi, I am trying to put more structure into my CF code. My idea is to separate the ColdFusion processing from the HTML structure and use CSS for the look of the site. I am trying to get an idea of what is the best way to separate the CF. I know that I could use custom tags, user defined function and if I was using MX, then components. But these are for code that can across used in multiple pages. What I am talking about is the CF for an individual page. What has all this to do with CFIF statements, well. I was thinking of setting a series of flags that are checked against in my HTML. The CFIF statements are there to check the value of these flags and amend the page depending on these flags. So I want to be able to write good efficient CFIF statements so that my code is up to speed. Here's an example of what I am talking about: !--- Default ColdFusion Parameters --- cfparam name=QueryResults default= type=string !--- ColdFusion Processing --- cfquery name=myQuery datasource=myDSN SELECT * FROMmyTable /cfquery !--- Sets flags --- cfif myQuery.RecordCount EQ 0 cfset QueryResults = 1 /cfif !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN html head titleUntitled/title /head body cfif QueryResults EQ 1 table cellspacing=2 cellpadding=2 tr td class=mainFontResults found./td /tr /table cfelse table cellspacing=2 cellpadding=2 tr td class=mainFontNo results found./td /tr /table /cfif /body /html This is a simple example, but it shows how I want to keep the processing separate at the top of the page. My question, finally, is how are CFIF statements best written if I want to code this way and or is there a better way of writing my CF code. Thanks. ** Westminster City Council switchboard: +44 20 7641 6000 ** This E-Mail may contain information which is privileged, confidential and protected from disclosure. If you are not the intended recipient of this E-mail or any part of it, please telephone Westminster City Council immediately on receipt. You should not disclose the contents to any other person or take copies. ** __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar
RE: Writing efficient CFIF statements
I do strongly belive using the IIF right wouldnt be any slower than CFIF as well Eg.. The right usage cfloop index=x from=1 to=10 #x#.#IIF(x mod 2,'odd','even')#br /cfloop Improper usage which is any day going to be slower than CFIF cfloop index=x from=1 to=10 #x#.#IIF(x mod 2,DE(odd),DE(even)#br /cfloop Joe Certified Advanced ColdFusion Developer [EMAIL PROTECTED] -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 1:28 PM To: CF-Talk Subject: Re: Writing efficient CFIF statements Actually, the main problem with using IIF() now is that few people know how to use it right. The double evaluation issue, using DE vs. double quoting, etc. I'm going to have to revise my paper on it and get it out there again. :) http://www.fusionauthority.com/iif.cfm I wouldn't declare it dead for the sake of readability. That above anything is a good reason not to use it. ~Todd On Tue, 16 Jul 2002, Michael Dinowitz wrote: I really wish that people using my documents (originally posted in issues of FA) put down where they got the information from. I see chunks of information on that page taken directly from me. Now as for IIS() under MX. I've tested it heavily and there is literally no difference speed wise between IIF and CFIF. Counting on the run, you can see the numbers change in the .001 millisecond range which is nothing at all, especially as the numbers change for both and there is no clear pattern. That being said, I declare that the best practice of not using IIF() is dead as of MX. -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Server Date Error
Easy way.. if insert just use SQL Server GetDate() time stamp. To your question.. CreateODBCDateTime doesnt always work well.. read it in some docs.. Do some like this if you still want to use it. cfset CFdateTime=CreateDateTime(2002,05,05,10,15,15) (y,m,d,h,m,s) cfset ODBCDT=CreateODBCDateTime(DateTime) Joe Certified Advanced ColdFusion Developer [EMAIL PROTECTED] -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Monday, July 15, 2002 4:25 PM To: CF-Talk Subject: Re: SQL Server Date Error Al Everett wrote: I'm getting this when writing a date to a datetime len 8 in SQL Server 2000 in a hosted environment: [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting datetime from character string. It returns the error on any valid dates in mm/dd/yy format. I have several date fields in other places but they're OK. I've tried with and without quotes. This may be a silly question, but did you put your string inside a CreateODBCDate() function? I tried CreateODBCDateTime(). I'll try CreateODBCDate()(what the hell). I have CF code to validate the date. And it works on our development server. FYI, No quotes around the CreateODBCWhatever() functions ... You might also try using cfqeuryparam ... Isaac Dealey www.turnkey.to 954-776-0046 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cfscript for in vs cfloop collection...
Yea i didnt see the Syntax for For-In until like around 6 months ago.
for (key in MyStruct)
{
writeoutput(Key = MyStruct[key]);
}
Joe
-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 4:00 PM
To: CF-Talk
Subject: RE: cfscript for in vs cfloop collection...
Yep... the for loop expects a counter (for (i = 1; i le Len(somevar); i = i
+ 1) ) There is no in key word for it. sorry. You will have to determine
the number of childnodes in /trackresponse/activity and use that as your
counter.
mark
-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 2:56 PM
To: CF-Talk
Subject: cfscript for in vs cfloop collection...
Perhaps someone else can see what I am doing wrong here (cf5). I've had this
problem in the past, and just included the code inline with a cfloop around
my cfscript, but now I want to convert the code to a UDF...
Here is the code.
This works fine:
cfloop collection=#transDOM.selectNodes(/TrackResponse/Activity)#
item=i
This throws an invalid parser construct error at the second parentheses (yes
I have tried both single and double quotes):
for ( i in objXMLDOM.selectNodes('/TrackResponse/Activity')) {
Am I wrong in assuming that cfloop-collection and cfscript for-in loops are
the same?
jon
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: RE: RE: Storing Queries in Application Scope
Hi Issac, I wasnt aware you need to lock everything with poniter scoping method to the application. I will test this anyways. Thanks Joe -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 6:56 PM To: CF-Talk Subject: RE: RE: RE: Storing Queries in Application Scope Hi Joe, The reason for using the duplicate() function to copy data between the request and application scopes is that creating a pointer to an application scope query in the request scope, i.e. cflock scope=application ... cset request.myquery = application.myquery /cflock defeats the purpose of locking the application scope, since using the pointer created in this example is still using the application scope directly and thus creates the potential for server instability as a result of application scope race conditions. You can test this in CF 5 : in the CF Administrator turn on require locking for the application scope, then use the above example and reference the query outside the lock -- CF Server responds with an error message indicating that the query contains variables in the application scope and therefore cannot be referenced without an active lock. In some cases it's better to simply reference individual variables in a cflock since you can't manipulate the pointer to a simple value directly in ColdFusion. If you need the entire contents of a query however, it's often more efficient to go ahead and use the extra memory in the request scope and let the CF Server's garbage collection handle freeing that memory up after it finishes parsing the page. Admittedly, I tend to err on the side of using more memory rather than going to the db more often, etc... The reason I do this is because memory is generally less expensive and easier to install than more processor speed, etc. Especially lately -- anyone else notice the fire-sales on RAM this year? :) Isaac www.turnkey.to 954-776-0046 Original Message --- Hi Issac, Your are right as well..Right tool for the right Job. I wonder if it would be a better solution to NOT Duplicate the Structure like cflock type=readonly timeout=20 cfset Request.MyReqQuery=Application.MyQuery Note: No Duplicate or StructCopy /cflock There by only making referrence to Application scope like a POINTER since the data doesnt need to manipulated and only stored/displayed. Wouldnt this save memory space.. since u are not really creating a DEEP Copy into the 2nd structure(Request)? Joe Certified Advanced ColdFusion Developer [EMAIL PROTECTED] __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Storing Queries in Application Scope
Using the duplicate() arent you actually creating a DEEP DUPLICATE of the structure. So you have the query in APPLICATION scope and then in REQUEST scope... taking up MEMORY? Why cant this just be done in the Request Scope and avoid LOCKING and Structure duplicates? cfquery=Request.MyNewQuery datasource=MyDB Select Field1, Field2 .. from MyTable /cfquery Joe Certified Advanced ColdFusion Developer [EMAIL PROTECTED] -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Friday, July 12, 2002 11:34 AM To: CF-Talk Subject: Re: Storing Queries in Application Scope No reason at all. Depending on your ColdFusion version: 1) You may want to investigate the use of ColdFusions built in query cacheing as well 2) Remember to lock all access to application scope variables. I'm told that locking isn't necessary in CFMX although I expect it will be a while yet before we can consider CF 5 the acception rather than the rule. Speaking of which, if you're using application variables to store queries ( which I assume won't change often ), then you may really want to use a construct like this: cflock scope=application type=readonly timeout=10 cfset request.queryname = duplicate(application.queryname) /cflock select name=yadda cfoutput query=request.queryname option value=#request.queryname.column# #request.queryname.column2#/option /cfoutput /select The reason for this is that you generally want to limit the amount of code within the cflock whether it's exclusive or read-only, because an exclusive lock will still have to wait for all read-only locks to complete before it can begin to process its code, and if your app is chock full of cflock scope=application cfoutput query=application.myreallylargequeryicachedintheapplicationscope ... .5kb of code designed to display something from my query ... /cfoutput/cflock Then your application is going to have a tough time creating exclusive locks to set those application variables... Also, when you set a query into the application scope in an exclusive lock, don't lock around the cfquery or cfstoredproc tags ... draw the query locally, then use duplicate() to copy it to the application scope, similar to or rather inverse of the example above. You may already know a lot of this, but I think the refresher is always good. And hopefully this information may be helpful to some of the other less experienced list members as well. :) hth Isaac Dealey www.turnkey.to 954-776-0046 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: RE: Storing Queries in Application Scope
Hi Issac, Your are right as well..Right tool for the right Job. I wonder if it would be a better solution to NOT Duplicate the Structure like cflock type=readonly timeout=20 cfset Request.MyReqQuery=Application.MyQuery Note: No Duplicate or StructCopy /cflock There by only making referrence to Application scope like a POINTER since the data doesnt need to manipulated and only stored/displayed. Wouldnt this save memory space.. since u are not really creating a DEEP Copy into the 2nd structure(Request)? Joe Certified Advanced ColdFusion Developer [EMAIL PROTECTED] -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 4:30 PM To: CF-Talk Subject: RE: RE: Storing Queries in Application Scope Hi Joe, Yes, your assertion is absolutely correct: using duplicate to copy data between the application and request scopes does mean having 2 ( or more ) coppies of the same data taking up space in different places in memory ( though my understanding is that the request scope variable memory is freed up when the page finished processing ). It typically can be done in the request scope if you only need it on a given page, if you don't have any problems going to the database on every page that needs the data, or if you can use cached queries. The advantage to storing this information in the application scope is that it's persistent across multiple users, so you may only have to go to the database once for several dozen or hundred or so page views (even in a cflock, retreiving a query from the application scope is almost invariably faster than retreiving the data from a database), and it provides more control over the data and when it's refreshed or otherwise modified than cached queries. All that being said, it's not always the solution of choice. :) Right tool for the right job, ya know. :) Isaac www.turnkey.to 954-776-0046 Original Message --- Using the duplicate() arent you actually creating a DEEP DUPLICATE of the structure. So you have the query in APPLICATION scope and then in REQUEST scope... taking up MEMORY? Why cant this just be done in the Request Scope and avoid LOCKING and Structure duplicates? cfquery=Request.MyNewQuery datasource=MyDB Select Field1, Field2 .. from MyTable /cfquery __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: RE: Storing Queries in Application Scope
Yes... the point is to avoid locking every where else.. -Original Message- From: Kwang Suh [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 6:16 PM To: CF-Talk Subject: RE: RE: Storing Queries in Application Scope This wouldn't work. If you're just doing a declarative, then you're only making a reference to the application query. Which means that you're still accessing the application query even if you're using the request scope. -Original Message- From: Joe Bastian [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 3:09 PM To: CF-Talk Subject: RE: RE: Storing Queries in Application Scope Hi Issac, Your are right as well..Right tool for the right Job. I wonder if it would be a better solution to NOT Duplicate the Structure like cflock type=readonly timeout=20 cfset Request.MyReqQuery=Application.MyQuery Note: No Duplicate or StructCopy /cflock There by only making referrence to Application scope like a POINTER since the data doesnt need to manipulated and only stored/displayed. Wouldnt this save memory space.. since u are not really creating a DEEP Copy into the 2nd structure(Request)? Joe Certified Advanced ColdFusion Developer [EMAIL PROTECTED] -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Saturday, July 13, 2002 4:30 PM To: CF-Talk Subject: RE: RE: Storing Queries in Application Scope Hi Joe, Yes, your assertion is absolutely correct: using duplicate to copy data between the application and request scopes does mean having 2 ( or more ) coppies of the same data taking up space in different places in memory ( though my understanding is that the request scope variable memory is freed up when the page finished processing ). It typically can be done in the request scope if you only need it on a given page, if you don't have any problems going to the database on every page that needs the data, or if you can use cached queries. The advantage to storing this information in the application scope is that it's persistent across multiple users, so you may only have to go to the database once for several dozen or hundred or so page views (even in a cflock, retreiving a query from the application scope is almost invariably faster than retreiving the data from a database), and it provides more control over the data and when it's refreshed or otherwise modified than cached queries. All that being said, it's not always the solution of choice. :) Right tool for the right job, ya know. :) Isaac www.turnkey.to 954-776-0046 Original Message --- Using the duplicate() arent you actually creating a DEEP DUPLICATE of the structure. So you have the query in APPLICATION scope and then in REQUEST scope... taking up MEMORY? Why cant this just be done in the Request Scope and avoid LOCKING and Structure duplicates? cfquery=Request.MyNewQuery datasource=MyDB Select Field1, Field2 .. from MyTable /cfquery __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFCookie?
Greg, I am not 100% sure if this can be done.. Its also worth trying to post the cookie for the ASP site.. using CFHTTP and CFHTTPPARAM before the transition is made to the ASP site Joe Certified Advanced ColdFusion Developer [EMAIL PROTECTED] -Original Message- From: Greg Luce [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 3:13 PM To: CF-Talk Subject: CFCookie? I need a cookie to be read by another site. Can someone explain how this works? What's the difference between CFCookie and cfset cookie.blah = .? Of course my site is CF, but the other site is ASP. They just want verification that the user is logged in. I tried this: cfset cookie.eD = OK And I can't see it in my C:\Documents and Settings\Greg\Local Settings\Temporary Internet Files directory. Here's the code I need to see the cookie on the other end: % 'this is the code that prevents unauthorized users from viewing these pages. thebrowser=trim(request.servervariables(HTTP_USER_AGENT)) if not instr(thebrowser,Robot) allrec) 0 then eDCookie=Trim(Request.Cookies(eD)) if eDCookieOK then response.Redirect(/NotAuthorized.asp) end if % Greg Luce eDiets.com 3801 W. Hillsboro Blvd Deerfield Beach, FL 33442 [EMAIL PROTECTED] 954.360.9022 x116 __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Capturing an e-mail address
Are you using ColdFusion to populate these mass emails or is this some type email software? If you are using CF/ASP/JSP.. there are multiple ways to accomplish what you are trying to do. loop the mails ... dynamic's ID's populated in the email... for security... you can populate a Table with User_ID and createUUID passed into the email associated with User rather than passing Userid...once you have UUID.. u can associate that to a user or email. These only work... if you are using a Web Application Server dynamic emails. flat HTML file in the original post didnt make sence. Joe Certified Advanced ColdFusion Developer [EMAIL PROTECTED] -Original Message- From: Chris White [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 5:00 PM To: CF-Talk Subject: RE: Capturing an e-mail address Take what Dave has suggested and also have an id for link and have all of the links in your newsletter go the same ColdFusion page and you will know the user and the article/link they were after. In that same page write a record transaction table along with the article that they want to see then redirect the user to the correct page on your site. Chris -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 4:48 PM To: CF-Talk Subject: Re: Capturing an e-mail address Each email that you send out goes to a person in a DB, right? So each person has an ID, right? So if you put a link of http://www.site.com/index.cfm?userid=2577 then the index.cfm can take the userid and translate it into the person, right? Is that what you want? Well, yes and no. I see what you're saying, but it's not that simple for me. As I said, the e-mail is one HTML template that is sent through our mass e-mailer provider to the list of subscribed addresses. It's essentially the same thing as writing only one e-mail, but CC'ing a boatload of people. Using your approach, we'd have to generate a unique HTML file for each user we send the e-mail to in order to append the proper userID to the links. Remember, I don't have access to CF or any other scripting languages to loop over a record set of userIDs. So what I send has to be generic. For example, to blindly log usage without regard to who it is, a simple a href=filename.cfm?logMe=1Filename/a will do the trick. Then, on my site, I just look for the logMe flag and increment the usage. That's not hard. But now the trick to is say, log this person's e-mail address(assuming they've clicked the link via their e-mail), somehow figuring out how to identify a user through one static HTML file. That's what I don't quite know how to do. Generating a separate HTML file for each user in the database is too much and unreasonable. That's why I was hoping there might be a smarter way of doing this. Thanks, Dave. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Loading CFM page into new browser window
Put a function like in the head
script language=JavaScript
function New_window(freshurl)
{
SmallNewWin = window.open(freshurl,
'NewWindow','scrollbars=yes,resizable=no,toolbar=no,height=450,width=400');
if (window.focus)
{ SmallNewWin.focus();}
}
/script
and you can pass call the function with a LINK
a
href=JavaScript:New_window('YourPath/index.cfm?fieldName=#Query.EMPLOYEE_hi
re_date#') OnMouseOver=return window.status='New Window'; return false;
OnMouseOut=window.status='My Home'
This is my new Window
/a
Or call the function with button
input type=button Name=submit value=Open window
onclick=JavaScript:New_window('YourPath/index.cfm?fieldName=#Query.EMPLOYEE
_hire_date#')
Joe Eugene
Certified Advanced ColdFusion Developer
[EMAIL PROTECTED]
-Original Message-
From: Svee, Eric [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 10, 2002 5:38 PM
To: CF-Talk
Subject: Loading CFM page into new browser window
I have a button that is intended to launch a pop-up window
(instruction.cfm). This window will display different information, depending
on which button is clicked. How can I feed Cold Fusion the correct
string(ie. ?fieldName=EMPLOYEE_hire_date) from each specific button while
still being able to control my window.open options (ie. no scroll bars, 300
x 300, etc).
Thanks
E
__
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL question...
Brian,
You can get this to work with left joins and using sum() Data format you
want would appear
like
Options 1
Prt_typePrt Stock Total
planeparts wingZ 9 14
planeparts rudderQ 3 14
planeparts engineRR 2 14
You dont want to repeat totals so its better to do this in 2 queries.
Get Parts in one query and Totals in the second.
2nd query.. Select sum(Stock) from where Prt_id=1
Option 2
You can write a stored procedure and switch between 2 queries(Parts and
Total)
to build a result set.. This is cleaner and faster. (BEST)
Option 3
You can do this is ColdFusion using QUERY Functions and Structure
notations.
Joe
Certified Advanced ColdFusion Developer
[EMAIL PROTECTED]
-Original Message-
From: Brian Scandale [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 10, 2002 10:35 PM
To: CF-Talk
Subject: SQL question...
I now this is quite simple... however I need clues to get me started...
How does one go about breaking out the various subtotals from a dataset?
Example:
In this example table there are multiples of the same parttype.
parttype partnameinstock
---
carparts mufflerX 25
carparts mufflerY 15
carparts engineSA 12
carparts wheel12 27
planeparts wingZ 9
planeparts rudderQ3
planeparts engineRR 2
Would typically do something like this in CF
query=thelist
Select *
From parts
Order by parttype
/query
cfoutput query=thelist
trtd#thelist.PartType#/tdtd#thelist.PartName#/td/tr
/cfoutput
Would like to be able to generate subtotals...like this:
parttype partname instock
---
carparts mufflerX 25
carparts mufflerY 15
carparts engineSA 12
carparts wheel1227
SUBTOTAL - -
79
planeparts wingZ 9
planeparts rudderQ 3
planeparts engineRR 2
SUBTOTAL --- --
14
Thanks for any and all hints. ;-)
Brian
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Internal CF Structures?
There is mis-leading documentation on CF internal structures. Some docs say Server variables are CF structures if you try to dump server it goes into an error.. Some other docs mention you cannot use server structure prefixes.. Anybody know which is correct... what is Server.Os.Name stored as? Appreciate any help. Joe __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: com question in cfmx
Use CF Custom tags/includes instead of COM objects Joe -Original Message- From: Brian J. LeRoux [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 09, 2002 12:41 AM To: CF-Talk Subject: com question in cfmx I've been hearing rhetoric tossed around about cfmx having poor support for com and one of our clients is about to migrate hosts, who to my surprise are running cfmx. We use cfobject quite a bit to drive the credit card transaction processing and I wanted to hear everyones experiences. Thanks in advance, Brian __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Update with cflocation
Paul, CFLocation redirects header info to wherever you are pointing it to.. After all the query updates are done on the template.. at the end of code execution.. you can code some Inline JavaScript script language=JavaScript self.location='yourTemplate.cfm'; /script The other of doing this can be.. Switch statements to include templates on your conditional processing. Joe -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 04, 2002 1:34 AM To: CF-Talk Subject: Update with cflocation I am doing some query updates and then following the processing with a cflocation When I use cflocation the updates do not take place (On MS SQL Server). When I remove the cflocation they process the update. I have heard the use of cfhtmlhead for redirection, does anyone have any example code to redirect to a different url? Or any other serverside type solutions would be even better. Thanks Paul Giesenhagen QuillDesign __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX bug ??
Hmm... Does that say that File is a keyword and you cant use it as
a variable in CFMX Java Architecture... Most likely so.
Joe
-Original Message-
From: James Sleeman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 04, 2002 2:59 AM
To: CF-Talk
Subject: Re: CFMX bug ??
- Original Message -
From: James Sleeman [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, July 04, 2002 6:34 PM
Subject: CFMX bug ??
CFLOOP LIST=#ValueList(Q_Changers.Name)# INDEX=file
CFFILE ACTION=COPY SOURCE=#REQUEST.RootPath##file#
DESTINATION=#REQUEST.MirrorDir#\#file#
/CFLOOP
fails with...
Complex object types cannot be converted to simple values.
Replying to myself...
I have narrowed it down somewhat, it seems that there is something funky
about calling a variable file (not case sensitive), no matter what I set
file to (either there as the loop index, or manually as CFSET File =
heyNonnyNonny) it always remains an empty struct (at least thats what
CFDUMP tells me it is). So i renamed the variable file to xfile and this
section of code works now.
But after waiting around for aages while it compiled code, lo and behold
a very similar error occurs here...
Complex object types cannot be converted to simple values.
The Error Occurred in J:\InnovativeMedia\StaffAdmin\qry_husk.cfm: line
71
Called from J:\InnovativeMedia\StaffAdmin\dsp_husk.cfm: line 6
Called from J:\InnovativeMedia\StaffAdmin\index.cfm: line 126
69 :CFOUTPUT
70 :tr
71 : td nowrap ID=#menuName##menuX#
STYLE=#Insert#a
href=#URL# class=OLmenuLink
onMouseOver=highlightMenuItem('#menuName##menuX#')
onMouseOut=unhighlightMenuItem('#menuName##menuX#')#Name#/a/td
72 :CFSET Insert=
73 :/tr
here I'm guessing it's either #Insert#, #URL# or #Name# that is the problem.
How many of these am I going to find around the place ?!?!?!?!?!
---
James Sleeman
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.373 / Virus Database: 208 - Release Date: 7/2/2002
__
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DTS Import
Doug, The below code should work for you. Whatever your file is cffile action = read file = F:\inetpub\wwwroot\\column.txt variable = txtColumns cfset LColumns=ListChangeDelims(txtColumns,,,chr(13)) cfset nQuery= cfloop index=x from=1 to=#listlen(LColumns,,)# cfset nQuery=ListAppend(nQuery,listgetat(LColumns,x,,) varchar(300),,) /cfloop cfquery name=QName datasource= Create Table newTable (#nQuery#) /cfquery Hope the above is what you wanted. Joe -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 6:42 PM To: CF-Talk Subject: DTS Import I have a text file with about 200 lines in it, and I want the value of each line to be a column in the database. How do I go about this? I tried first row has colum name, but it just gives me the first row as a column name and the other 299 rows as values. Example: I want all these to be column names client_first_name co_client_first_name client_last_name co_client_last_name client_middle_initial co_client_middle_initial client_email co_client_email client_home_phone Douglas Brown Email: [EMAIL PROTECTED] __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMAIL problem with server!
You have to EDIT/UPDATE all the emails in the undeliverable directory to the right MAIL SERVER details and once you move them to email SPOOL directory, CF will try to resend them. All emails will be send successfully.. if you have the right parameters. Joe -Original Message- From: Neil H. [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 23, 2002 12:38 AM To: CF-Talk Subject: CFMAIL problem with server! CF Mail problem. If you have a ton of emails in the undeliverable directory and you move them over which Mail Server will they use? In the message it will show the old mail server, but I updated it in the CFADMIN so which applies? Thanks, Neil __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Comparing two lists
You can loop through one list and do ListFindNoCase on the other List Joe -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 20, 2002 11:36 PM To: CF-Talk Subject: RE: Comparing two lists I'm not trying to determine if the two lists are the same, but only if they have one or more matching elements... As far as I know you should be able to do cfif variables.firstList EQ variables.secondList /cfif A list isn't a complex data type. It's just a simple variable. List functions just offer an exciting way to manipulate variables. Hope this helps. Derrick -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 20, 2002 3:28 PM To: CF-Talk Subject: Comparing two lists Is there an easy way to see if any items in two lists match? For now, I'm looping over one list and doing listfind on the other for each value from the first. But I didn't know if there was an easier way. Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: DB Table Naming Conventions
I Usually do some like Eg USERS TABLE TABLE USR_USERS or for Company Users can be CMP_USERS or Application Abbrv+Usage FIELDS USR_ID Or CMP_USERID USR_LOGON_ID USR_FNAME USR_MNAME USR_LNAME USR_EMAIL ... and name stored procedures after app name eg CFApplication name=xyz_secure xyx_ProcName or xyz_chkUserLogin Joe - Original Message - From: Smith, Matthew P -CONT(DYN) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, June 12, 2002 11:51 AM Subject: RE: DB Table Naming Conventions Lol, same answer, same time. Matt -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 10:44 AM To: CF-Talk Subject: RE: DB Table Naming Conventions proc_ -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 11:32 AM To: CF-Talk Subject: RE: DB Table Naming Conventions Really? Wow ... I didn't know that. How do you prefix or designate Stored Proceedures? Joshua Miller Web Development :: Programming Eagle Web Development LLC www.eaglewd.com [EMAIL PROTECTED] (304) 622-5676 (Clarksburg Office) (304) 456-4942 (Home Office) -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 11:23 AM To: CF-Talk Subject: RE: DB Table Naming Conventions MS says that only system stored procedures should start with sp becasue when sql recieves a stored proc with sp_ it looks in the master system stored procedures first then looks in the current database. I doubt the speed difference is that much but just a tidbit of my two cents. Josh !--- Cut out of Books Online --- Many of your administrative activities in MicrosoftR SQL ServerT are performed through a special kind of procedure known as a system stored procedure. System stored procedures are created and stored in the master database and have the sp_ prefix. System stored procedures can be executed from any database without having to qualify the stored procedure name fully using the database name master. It is strongly recommended that you do not create any stored procedures using sp_ as a prefix. SQL Server always looks for stored procedures beginning with sp_ in this order: Look for the stored procedure in the master database first. Look for the stored procedure based on any qualifiers provided (database name or owner). Look for the stored procedure using dbo as the owner, if one is not specified. Therefore, although the user-created stored procedure prefixed with sp_ may exist in the current database, the master database is always checked first, even if the stored procedure is qualified with the database name. -Original Message- From: Joshua Miller [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 11:10 AM To: CF-Talk Subject: RE: DB Table Naming Conventions We usually do something like so: Stored Proc: sp_whatever Views: vw_whatever Tablename: tblUsers, tblPermissions, etc. Fields: Always prefixed with table-related text as such: userID (PK/ID) ufirstname ulastname uaddress1 uaddress2 ucity ustate uzip etc. That just makes it easier for me to see what field is related to what table - especially when you have similar data in multiple fields (which we try to avoid by abstracting the database as much as possible - but sometimes is necessary). There may be a better way or a more suitable way for your programming style. Joshua Miller Web Development :: Programming Eagle Web Development LLC www.eaglewd.com [EMAIL PROTECTED] (304) 622-5676 (Clarksburg Office) (304) 456-4942 (Home Office) -Original Message- From: Zac Spitzer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 10:20 AM To: CF-Talk Subject: Re: DB Table Naming Conventions -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [EMAIL PROTECTED] wrote: | I'm just curious, What naming conventions for DB tables do you use? this is a biggy :-) a lot of php developers that work with mysql, a non relational db use pk names of ID I always name the pk of table (table_name)_id... I also tend to prefix ~ column names with an abbreviation of the table name, it makes life easier as there is more information there and when you start joining tables, there is less conflict if u use common naming conventions z -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6-2 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAj0HWKMACgkQm98oI6K7h0gxUQCgjUvOt0+YVHgz/Qyh8RlAawAp CrwAoOwShhA1t7xZpiKsaYQ3Cdz8Supo =YXc3 -END PGP SIGNATURE- __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: list delimiter problem
First of all ... How are you trying to insert/update using the below data? I mean the code? You can do this.. cfset x=SUS,DECORA,1903141001,Garden Elements, a source book of decorative ideas to transform the garden,CLIFTON JOAN,45.00,0,HB,2000 insert into tablename(#ListGetAt(x, 1 ,)#) You can also change the delimiters like cfset newList=ListChangeDelims(x,:,) I can think of about 4 or 5 ways of manipulating your LIST.. but the best way depends on what you are trying to do. Your end use code is not clear Joe - Original Message - From: Seamus Campbell [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, June 12, 2002 2:28 AM Subject: list delimiter problem Hi I have a list - the format of which I cannot change. One line as an example below SUS,DECORA,1903141001,Garden Elements, a source book of decorative ideas to transform the garden,CLIFTON JOAN,45.00,0,HB,2000, Sometimes there is a comma in the title as above so when I am inserting/updating the contents into a database Garden Elementsis taken as one field and a source book of decorative ideas to transform the gardenas another I am trying to change the delimiters but I can't work out how to not to change the comma, for instance, inside the title field Garden Elements, a source book of decorative ideas to transform the garden Does anyone have any clues please Seamus __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Does cfcookie depend on cfapplication
I am not sure.. why you are doing all the below.. Cant you just create roles in a database based on LDAP and have one CFAPPLICATION? Another one.. Create Session Structures depending on how many applications you might wanna have. eg.. Session.AppOne, Session.AppTwo in one Application. Joe - Original Message - From: Brian Eckerman [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, June 12, 2002 4:04 PM Subject: Does cfcookie depend on cfapplication Hello, this is my millionth question this week. I am trying to validate a user with a root application (CFAPPLICATION NAME=MAIN...) then I want to store the permissions I got from the LDAP table and switch contexts depending on which departmental link the user clicked on, (CFAPPLICATION NAME=ASSET RECOVERY...) I want to be able to access the variables I stored earlier. So far I tried Client Variables- ( Do not span across CFAPPLICATIONs) Copying Session from one CFAPP. to anouther with REQUEST Scope ( no way to get them from one department to anougther) I though CFCOOKIE would be my Holy Grail because (I thought) they would be specific to one user, and span CFAPPLICATIONS. Even better they expire when the Browser closes. (beats head against wall) Unfortunatly when I do the following (pseudocode) - file1.cfm CFAPP. NAME=MAIN CFCOOKIE NAME=permissions VALUE=x,y,z - file2.cfm CFAPP. NAME=ASSET_RECOVERY CFOUTPUT #IsDefined(Cookie.permissions)# - It outputs NO ARHHH Is there anything specific to a user but spans CFAPPLICATION? HELP! -Original Message- From: Thane Sherrington [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 2:23 PM To: CF-Talk Subject: Session vs URL variables I've been encrypting my URL variables before passing them but I was wondering if I'd be better off simply using a Session variable to handle most of my variables and only hand off one or two URL variables. That way I could avoid the encryption. Which is the better approach? T __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Shopping Carts
I saw this one go on all day... Why dont you build a generic Not so flashy eCommerce model and use it for all your cheap clients... so atleast u dont have spend time customizing it... and u know the code Joe - Original Message - From: Parker, Kevin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, June 12, 2002 7:06 PM Subject: RE: Shopping Carts Not sure what your budget is but try Unity from Chimo at www.chimo.com.au ** Kevin Parker Web Services Manager WorkCover Corporation [EMAIL PROTECTED] www.workcover.com p: 08 82332548 f: 08 82332000 m: 0418 806 166 ** -Original Message- From: James Smith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 12 June 2002 8:50 PM To: CF-Talk Subject: Shopping Carts What shopping carts do people use at the moment? Please don't all say Able Commerce as it is WAY to expensive for what my client wants. -- James Smith - [EMAIL PROTECTED] http://www.xsite.ltd.uk - Xsite Limited -- As a computer, I find your faith in technology amusing. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Web and CD
For you second option(CD) The only option to create a stand alone CD is Macromedia Director Or now referred to as Macromedia Director 8.5 Shockwave Studio. You can use their proprietery code language to develop this and you can tie it to a database on the CD etc. However the above solution takes a long time to develop. You can almost write a CF app to write html pages with links to the PDF and burn all the HTML files, images onto a CD which can be accessed using a basic browser. This CD will work standalone except that the user needs a browser. Joe - Original Message - From: Chris Montgomery [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, June 07, 2002 3:31 PM Subject: OT: Web and CD Howdy cf-talk, I have a how can I do this question, but before I ask, some background. Potential client is a general contractor who needs to distribute lots of PDF files to subcontractors. Currently, they are using Dreamweaver to create HTML pages with links to the PDF files and then burning everything to a CD rom to distribute. What they want to do is create two options for distibuting the PDF files: 1) create a web-based file distribution system where subcontractors can log in and get the PDF files, and 2) be able to port the web/HTML interface, with links to all the files, to a CD so that it can be distributed to subcontractors. Option 1 shouldn't be a problem. The way it will work is the contractor creates a new project using a minor content management system to set up things like project names, descriptions, etc. and then build links to the PDF files. Subcontractors would then log in and get their files by downloading or reading online. Option 2 is where I am unsure. The HTML project screens need to be saved to a CD with links to the files. Having read threads on here in the past, I don't believe it's possible to use CF to run as a standalone application on a CD. So the question is, how could this be built to be run on a CD? After doing a little poking around on Macromedia's site, it looks like Director Shockwave *might* be a possible solution. What we want to avoid is creating two environments, if possible. For example, building the web part in CF and then using some other multimedia application, possibly Directory, to do the CD stuff. With the release of MX, it looks like doing the web side with Flash MX and then getting it to work with Director might be possible. Any thoughts on how to proceed? Recommended solutions, etc? I should mention that I know nothing about Flash or Director. Thanks! -- Chris Montgomery[EMAIL PROTECTED] Airtight Web Services http://www.airtightweb.com Web Development, Web Project Management, Software Sales 210-490-3249/888-745-7603 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: DB Compatibility Sybase SQL Anywhere
What drivers are u using to connect to Sybase and what platform? Cant you link tables from Access using ODBC? Create DSN on NT/2000 to Sybase and use access to link the tables? Or doesnt Sysbase have an Export DB/Tables Utility.. Almost all DB's(SQL,ORACLE etc) have this feature.. i would be surprised.. if Sybase lacks this. Joe - Original Message - From: Allen Hudson [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, June 06, 2002 1:16 PM Subject: DB Compatibility Sybase SQL Anywhere A colleague has a situation that I am sure has crossed the brow of someone else before. She has a Coldfusion development Web Application tied to a Sybase SQL Anywhere database (reason being that is what our government webhosting department supports). This is the first time that she or I have worked with this type of database. This database comes with a utility (I am told) that will convert most other db formats to Sybase format to be able to be used. She cannot find anything as yet that would allow the data in the Sybase db to be exported or transported to an alternative format like Access 2000. Just so you know, the majority of clients that we deal with, use Access since their data requirements are not extensive. The question: how would one go about getting the data in the Sybase db into an alternative format (specifically Access 2000) or any other for that matter? I am also posing this question in the general sense as well to be prepared for future web app requirements. Thank you for your help Al Hudson __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Querying a table for its columns
In MS-Sql Server, the below is the SQL Select column_name From information_schema.columns Where table_name='YourTableName' Joe - Original Message - From: Chris Lofback [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 4:19 PM Subject: RE: Querying a table for its columns I've done this in Oracle 8i and I would assume it can be done in SQLServer and mySQL. Here's what I did with Oracle: CFSET TableName = foo CFQUERY Name=GetData ... select * from #TableName# where 1 = 0 /CFQUERY Columns for CFOUTPUT#TableName#/CFOUTPUT CFLOOP LIST=#GetData.ColumnList# INDEX=ColName CFQUERY NAME=GetType ... select data_type, data_length, nullable from user_tab_columns where table_name = '#UCase(TableName)#' and column_name = '#UCase(ColName)#' /CFQUERY CFSET TempDetail = #GetType.data_type#(#GetType.data_length#) CFIF GetType.nullable IS Y CFSET TempDetail = TempDetail Null /CFIF CFOUTPUTBR#ColName# : #TempDetail#/CFOUTPUT /CFLOOP There may be more efficient ways to do this rather than loop through the columns and querying on each loop, but this was my quick hack! Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com -Original Message- From: Jason Miller [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 3:54 PM To: CF-Talk Subject: Re: Querying a table for its columns This came at a perfect time. - I am building a flash application with coldfusion that queries a database, creates forms on the fly in flash so I can have 1 mini app that can be used as a database updater (to merely update data in existing columns) to any database - specifically for now access. Anyone now of a good tutorial or someone who has done this in just cf and html so I can check it out? I am looking for similair variables that may be availabel along with ColumnList - like - can I see what type of information it is? Or if it is a drop down list in Access? If i can sniff that out - so I can create a drop down so it matches etc etc. Hope this is clear - any good resources would be a great help. thanks, jason miller Chris Lofback wrote: Here's one way: CFQUERY Name=GetData ... select * from table where 1 = 0 /CFQUERY (Use WHERE 1 = 0 so you get no records, but the ColumnList variable will still be populated.) CFLOOP LIST=#GetData.ColumnList# INDEX=Column #Column# /CFLOOP Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com -Original Message- From: Eric Dawson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 3:15 PM To: CF-Talk Subject: Querying a table for its columns Querying a table for its columns I can't remember the syntax for querying a table for its columns. I think it is a mySQL table on CF 4.0x box. Eric __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: storing session variables in DB
You have 1 or 2 solutions here... 1. Use Big IP to do the load balancing which will randomly distribute the session between the servers. OR 2. Use CF Enterprise and use Cluster Cats do the load balancing. Joe - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 10:18 AM Subject: RE: storing session variables in DB But I need the user to have the same session if he gets bumped to the other server. I'm not worried about them sharring sessions, I'm worried about a person losing his session if he suddenly switches machines. BJ = = = Original message = = = dude all you have to do is make sure that each app has it's own application name in the cfapplication tag. name of app1 cfapplication name=test name of app2 cfapplication name=test2 now the user's can't share session variables. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 10:06 AM To: CF-Talk Subject: storing session variables in DB I have a set of mirrored servers that are running off 1 SQL_server. I have to recode the apps that use session variables because a user could jump to a different server during a session. Is there a simple way to fix this? Can 2 different servers be aware of the same session? Can I store the session variables in the SQL-server DB? I am running Win2k, SQL-Server 2000, and (I know) CF%.0 Professional. There is no need to tell me that the Enterprise version will allow me to isolate a user to one server during a session. Thanks in advance, BJ ___ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL2000 JDBC Driver and CFMX
CFMX Uses Type IV JDBC drivers, refer to the migration docs. We havent had any problems creating the DSN connection. Try this. Create the ODBC connection on the Server and try creating the same connection with CF admin.. it should work. Joe - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, June 01, 2002 4:25 PM Subject: RE: SQL2000 JDBC Driver and CFMX Has anyone gotten the SQLServer 2000 JDBC driver to work in CFMX? I haven't tried yet, but it's on my list of things to do. I think you'll have to edit the \CFusionMX\lib\neo-query.xml file to get it registered, but I also suspect you'll have to edit (or write) some other files as well. Keep in mind that I've just poked around a little, so I have no idea what you actually have to do to get this working. I'm less than impressed with the SQLServer JDBC driver that's supplied with ColdFusion and using the ODBC:JDBC bridge isn't the option I'm looking for (but will use if there is no other alternative...). I need to be able to use trusted connections via JDBC. I don't think that the MS SQL Server 2000 JDBC driver supports trusted connections. In the connection string you have to specify a username and password, according to its documentation. Besides that, what issues are you having with the CF MX-supplied driver, out of curiosity? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Coldfusion and COM Limitations (Test Results)
From Macromedia documention (ColdFusion MX - Migrating ColdFusion 5 Applications) Marcomedia has admitted calling COM Objects to be slower in CFMX cause they use JNI. Macromedia tests results for calling COM Objects were ColdFusion 5 completed = 50 Milliseconds ColdFusion MX completed = 2-3 seconds. Joe - Original Message - From: Philip Arnold - ASP [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 31, 2002 9:22 AM Subject: RE: Coldfusion and COM Limitations I'd dispute that. I've run several COM apps that worked with CF 4 and 5 (and even CF 3!) on CF MX, and some work while others don't. CF MX uses a third-party COM interface for Java, JIntegra. I suspect that it has some limitations. True, I should have put As good as they've got - it's better than previous versions, but FAR from perfect... I don't think this is an accurate representation; I think you can call methods that take parameters in CF 3 and newer versions, as long as those parameters can be represented as strings or Variants. That hasn't changed much in newer versions, either. In CF4.x I couldn't get methods with parameters to work at all, they work better in CF5, but still not perfect, I never tried in CF3, so I can't comment on that Simple things like .replace() just wouldn't work in CF4.5 for me Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ** 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. ** __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: OT: scrolling tables
How does this really work? is there an example online? Joe - Original Message - From: Joshua Tipton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 31, 2002 11:16 AM Subject: RE: OT: scrolling tables This should work. Joshua Tipton Table tr tdHeaders for table/td /tr tr td style=OVERFLOW-Y: auto; table tr tdYourStuff/td /tr /table /td /tr /table -Original Message- From: Critz [mailto:[EMAIL PROTECTED]] Sent: Friday, May 31, 2002 11:04 AM To: CF-Talk Subject: Re: OT: scrolling tables oi Critz!! ok..using the example with the overflow...any idea how to line up the table?? the scrollbar throws off the alignment -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - CF_ChannelOP Network=Efnet Channel=ColdFusion Thursday, May 30, 2002, 10:53:07 PM, you wrote: C oi CF-Talk,!! C somewherepossibly on the msdn site I've seen an example where table C headers are stationary, but the cells are scrollable. C anybody else seen this.or know where some Xamples are? C thanks __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: cfml - asp
Cant you do a dynamic form post to the ASP page? Populate the form and after the /body/html do an inline JavaScript that would post the data to the Asp page. script language=Javascript document.formname.submit(); /script Joe - Original Message - From: Simon Whittaker [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 31, 2002 10:44 AM Subject: Fw: cfml - asp - Original Message - From: Simon Whittaker [EMAIL PROTECTED] Sent: Friday, May 31, 2002 3:41 PM Subject: cfml - asp I am trying to get pass dynamic CFML data from a cfm page to a ASP page? Any ideas - custom tags etc? __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CF MX in production?
Wow.. going into production with CFMX next week... hmm Have you tested your code in Dev environment..with CFMX, apparently there is a lot of code.. Code validator doesnt catch.. you might want to test for a week or 2 before going to production with it. Joe - Original Message - From: chad [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 10:06 AM Subject: CF MX in production? Just wondering if anyone is using MX in a production environment under real loads? Any problems so far? We are getting ready to upgrade two of our production servers next week. Thanks NTMail K12 - the Mail Server for Education __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL Upper Function Replacement?
Select Upper(fieldName) as UField from TableName should work.. there is no replacement that i know of. Curious.. what is the Sql DataType? ColdFusion its UCase(String) Joe - Original Message - From: Brian Scandale [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 31, 2002 12:01 AM Subject: SQL Upper Function Replacement? What replaces the SQL UPPER() function ins SQL Server? It's used to return the upper case of it's argument... It's complaining that Argument data type text is invalid for argument 1 of upper function thanks again! ~Brian __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Tab order
You can use simple html Tabindex but it doesnt always work with netscape. input type=text name=mfield value= tabindex=1 Joe - Original Message - From: Kris Pilles [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 29, 2002 10:30 AM Subject: Tab order Anyone know of any good references on setting tab order within some of my complex forms??? I'm sure it's a javascript tutorial I need but I can't find one anywhere. Thanks... I'd also love a PHP to Coldfusion tag conversion chart. Thanks KP __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: installing PHP with CF on Win2K server
I have never used PHP.. am curious if there are any advantages in PHP Scripting? Or is this just popular cause its free? Joe - Original Message - From: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 29, 2002 1:57 PM Subject: Re: installing PHP with CF on Win2K server I've had PHP/CF running happily together on Apache / Win2k / WinXP with no problems. Same on a linux box. ~Todd On Wed, 29 May 2002, Gyrus wrote: I've been developing quite happily with CF for a while now, using Access and SQL Server on our Win2K Server development box. Thinking of branching out into PHP, with mySQL, and just wondering about the server setup as it gets more complex: Can PHP4, CF5 (developer edition), mySQL, SQL Server 2000 (developer edition), all coexist happily with IIS 5 on a Win2K Server box? Can't see a reason why not, but this is going beyond my knowledge, so thought I'd check to see if there are any pitfalls to watch out for! cheers, - Gyrus - [EMAIL PROTECTED] work: http://www.tengai.co.uk play: http://www.norlonto.net - PGP key available __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Login Inside Popup
Check for CGI.SCRIPT_NAME and if some like www.myweb.com/login.cfm Do an inLine JavaScript script language=JavaScript window.open(loginPopup.cfm); /script Post the form details back to Login.cfm after checking for data and do window.close() and log the user from Login.cfm. Problems.. what happens if the user login data is invalid? where do u want to check for User Authorization? loginPopup.cfm? or Login.cfm , depending on those parameters.. choose the app flow. Joe - Original Message - From: Charlie [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, May 29, 2002 4:52 PM Subject: Login Inside Popup Has anyone created a login app within a pop-up window that upon authentication, the pop-up closes and redirects the parent window to a new page..much appreciated if anyone can get me on the right track __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Query question
You can also do SELECT 'hyperlink_title'=tbl_Pages.title+' '+tbl_Categories.Name from tbl_Pages,tbl_Categories Joe - Original Message - From: Dave Watts [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 28, 2002 4:02 PM Subject: RE: Query question Is there a way to refer to 2 fields in one query with the same name? I have a field called title in table tbl_Pages and a field called Name in table tbl_Categories cfquery name=getHyperlinks datasource=#ds# SELECTtbl_Pages.title AS hyperlink_title, tbl_Categories.Name AS hyperlink_title FROM tbl_Pages, tbl_Categories /cfquery Obviously the above gives me the error: Duplicate output alias 'hyperlink_title' Is there a way around this? This is for cf 4.5. There's no way around this; that's just the way SQL works! Even if it did work - that is, if it didn't produce an error - what would you want this to do? If you're trying to build one field that contains both of the other fields, you can do that by simple concatenation: SELECT tbl_Pages.title + ' ' + tbl_Categories.Name AS hyperlink_title ... Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Bytes to MB/GB conversion tag?
This is what i have learned... unless this question is sneaky! 1024k=1mb 1024mb=1Gb so the conversion from bytes to MB should be bytes/1024=#mb - Original Message - From: Lewis Sellers [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Sunday, May 26, 2002 5:27 PM Subject: Re: Bytes to MB/GB conversion tag? On Sun, 26 May 2002 13:04:57 -0700, in cf-talk you wrote: Is this a trick question?? MB = bytes/1,000,000 Only on the packaging of Hard Drives. They *sneakily* use actual standard SI units. In all other instances a MegaByte is 2^20 or 1048576 bytes. A KiloByte is, btw, 2^10 or 1024 bytes. A GigaByte is 2^30 or... where's my calc? ... 1073741824 bytes. This has pretty much been the standard for decades now. --min __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: cf_HTML2Excel Question
Hatton, You can do this straight without using cf_html2Excel For the specific problem with '00' just use nbsp; in the table def tdnbsp;Field/td cfcontent type=application/vnd.ms-excel !-- Start your table here-- Joe -Original Message- From: Hatton Humphrey [mailto:[EMAIL PROTECTED]] Sent: Friday, May 17, 2002 10:25 AM To: CF-Talk Subject: cf_HTML2Excel Question Does anyone have any expeirence with this tag? I have it working almost to where I need it but I'm running into an odd problem. I have a field that is coming in from a SQL Server VarChar with '00' as the value in the field. It is being output to the HTML as 00 in the table but for some reason the excel file is translating it as a numeric value and saving a single 0 in the file. The problem is that it's *supposed* to be a numeric value, so now I guess the question is how to I force the tag (or more to the point, Excel) to save the numbers as characters? TIA! Hatton __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Inserting into 2 tables with a relationship
Steven,
You can use the below query. This only works if TableA has an IDENTITY
field.
cfquery
Insert into Table1 values('some','some')
SELECT @@Identity as NewID
/cfquery
JOe
-Original Message-
From: Brian Scandale [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 16, 2002 3:16 PM
To: CF-Talk
Subject: Re: Inserting into 2 tables with a relationship
I suggest using the custom tag... Max_ID from the Macromedia Custom Tag
library. It is well documented. Then search the archives for discussions on
use of the tag.
I use this exclusively now and avoid AutoIncrementing primary key fields
like the plague.
hth
Brian
At 10:49 AM 5/16/02 -0500, you wrote:
I have a database with 2 tables one has a relationship with the other and
when I do an insert I need to insert into table 1 and insert into table 2
with an var_id field that has not been generated until table 1 has been
inserted into.. I am not sure what to do or how to do it.. I am using CF 5
and Access..
Steven Lancaster
Barrios Technology
NASA/JSC
281-244-2444 (voice)
[EMAIL PROTECTED]
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
