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. > 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! > >>| > >>| > >>| > >>| > >>| > 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, 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 to some like
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
#x#.#IIF(x mod 2,"'odd'","'even'")#
Improper usage which is any day going to be slower than CFIF
#x#.#IIF(x mod 2,DE("odd"),DE("even")#
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: 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: > > > > > > > SELECT * > FROMmyTable > > > > > > > > > > > > Untitled > > > > > > > > Results found. > > > > > > No results found. > > > > > > > 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=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
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: SELECT * FROMmyTable Untitled Results found. No results found. 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: 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:
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: 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. (y,m,d,h,m,s) 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 ... 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: 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. 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 Note: No Duplicate or StructCopy 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: 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 > > Note: No > Duplicate or > StructCopy > > 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? > > > Select Field1, Field2 .. from MyTable > > > > __ 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: 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 Note: No Duplicate or StructCopy 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? Select Field1, Field2 .. from MyTable __ 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 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? Select Field1, Field2 .. from MyTable 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: #request.queryname.column2# 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 ... < .5kb of code designed to display something from my query > ... 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: 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. 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 Filename 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: 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:
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 eDCookie<>"OK" 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: 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
Select *
From parts
Order by parttype
#thelist.PartType##thelist.PartName#
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
RE: Loading CFM page into new browser window
Put a function like in the head
function New_window(freshurl)
{
SmallNewWin = window.open(freshurl,
'NewWindow','scrollbars=yes,resizable=no,toolbar=no,height=450,width=400');
if (window.focus)
{ SmallNewWin.focus();}
}
and you can pass call the function with a LINK
This is my new Window
Or call the function with button
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: 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
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: 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 ?? > > DESTINATION="#REQUEST.MirrorDir#\#file#" > > > > 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 ) 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 : 70 : 71 : #Name# 72 : 73 : 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: 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 self.location='yourTemplate.cfm'; 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 When I use the updates do not take place (On MS SQL Server). When I remove the they process the update. I have heard the use of 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: DTS Import
Doug, The below code should work for you. Whatever your file is Create Table newTable (#nQuery#) 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 > > > > > 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: 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: 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
>
>
>
> -
> file2.cfm
>
>
>
> #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: 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.. insert into tablename(#ListGetAt(x, 1 ,""")#) You can also change the delimiters like 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: 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 > > > > 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
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: > > > > > select * > from #TableName# > where 1 = 0 > > > Columns for #TableName# > > > select data_type, data_length, nullable from > user_tab_columns > where table_name = '#UCase(TableName)#' > and column_name = '#UCase(ColName)#' > > > > > > #ColName# : #TempDetail# > > > 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: > > > > > > select * > > from table > > where 1 = 0 > > > > > > (Use WHERE 1 = 0 so you get no records, but the ColumnList variable will > > still be populated.) > > > > > > #Column# > > > > > > 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 > > > name of app2 > > > 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: cfml - asp
Cant you do a dynamic form post to the ASP page? Populate the form and after the do an inline JavaScript that would post the data to the Asp page. document.formname.submit(); 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: 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 > > > > > Headers for table > > > 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] - > > 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: 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: 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: 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: Login Inside Popup
Check for CGI.SCRIPT_NAME and if some like www.myweb.com/login.cfm
Do an inLine JavaScript
window.open("loginPopup.cfm");
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: 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: Tab order
You can use simple html "Tabindex" but it doesnt always work with netscape. 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: 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" > > > > > > SELECTtbl_Pages.title AS hyperlink_title, > > tbl_Categories.Name AS hyperlink_title > > FROM tbl_Pages, tbl_Categories > > > > > > 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 " " in the table def Field 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.
Insert into Table1 values('some','some')
SELECT @@Identity as NewID
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
