RE: String to Int
Very Interesting. Maybe one of the Gurus here can enlighten us. I have used the Attribute variables in many SQL queries. Here is an example query I use: SELECT AssetName, ... FROM Asset WHERE AssetID = #ATTRIBUTES.AssetID# AssetID is a select box value in the previous form. This query has never given me a problem. Russel Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the bear; some days the bear eats you. > -Original Message- > From: Maia, Eric [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 31, 2001 13:21 > To: CF-Talk > Subject: RE: String to Int > > > I think this server is running ColdFusion 4.5.1, and it's accessing SQL > Server 7. I don't have any problem with Attributes variables within > ColdFusion, but they seem to be typed as a string when I try to > insert them > into the database or use them in a WHERE clause in a query. > > -Original Message- > From: Russel Madere [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 31, 2001 6:42 AM > To: CF-Talk > Subject: RE: String to Int > > > Strange! > > which version of Cold Fusion are you using? I have been using > FormURL2Attributes.cfm for a while without any problems. > > Russel > > > Russel Madere, Jr. Senior Web Developer > ICQ: 5446158 http://www.TurboSquid.com > > Some days you eat the bear; some days the bear eats you. > > > > > -Original Message- > > From: Maia, Eric [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, January 30, 2001 17:07 > > To: CF-Talk > > Subject: RE: String to Int > > > > > > I have had type errors related to Attributes. variables produced by > > CF_FORMURL2ATTRIBUTES custom tag. I now use > #Val(string_variable)# when I > > know I'll need an integer (e.g. inserting into a numeric DB column). > > > > -Original Message- > > From: Russel Madere [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, January 30, 2001 2:44 PM > > To: CF-Talk > > Subject: RE: String to Int > > > > > > Actually, Cold Fusion does this automatically. Or more precisely, Cold > > Fusion uses typeless variables. That way, you don't need to > cast the type > > for the variables. > > > > Russel > > > > > > Russel Madere, Jr. Senior Web Developer > > ICQ: 5446158 http://www.TurboSquid.com > > > > Some days you eat the bear; some days the bear eats you. > > > > > > > > > -Original Message- > > > From: Richard Banks [mailto:[EMAIL PROTECTED]] > > > Sent: Tuesday, January 30, 2001 15:53 > > > To: CF-Talk > > > Subject: String to Int > > > > > > > > > is there a way [ie. a cf function ]to convert a string to an > > > integer. let's > > > say a user enters the string '1976' , and i want to process > > that string as > > > the integer 1976. > > > any help would be greatly appreciated. thanks > > > > > > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: String to Int
> if you're using SQL server 7 you should _always_ use Val() in > CFQUERY tags when expecting an integer because if your CFQUERY says: > > SELECT foo > FROM bar > WHERE id=#url.id# > > and someone changes the URL from: > www.mysite.com/qwe.cfm?id=1 > to > www.mysite.com/qwe.cfm?id=1;delete%20from%20bar > then what gets thrown to the dB is: > > SELECT foo > FROM bar > WHERE id=1;delete from bar > > and sql server 7 treats this as 2 valid sql statements and runs it > > You should write: > > SELECT foo > FROM bar > WHERE id=#Val(url.id)# Actually, you should CFQueryParam SELECT foo FROM bar WHERE id= Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: excel - access - sql?
Use the SQL Manager app to import the data into a database --=@ greg @=-- - Original Message - From: "Jay Patton" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, January 30, 2001 7:08 PM Subject: excel - access - sql? > if anyone can help me on this i would appreciate it > i was wondering: > > A. i could convert an excel file to sql > > B. i could convert an excel file to access (if at all) then to sql? > > > Thanks much :) > > Jay Patton > Web Pro USA > 406.549.3337 ext. 203 > 1.888.5WEBPRO > www.webpro-usa.com > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL Question
Also this: where x IN (#valuelist(anotherquery.id)#) is simpler than this: where x = #anotherquery.id# OR - Original Message - From: "Christopher Olive, CIO" <[EMAIL PROTECTED]> > they are essentially the same statement. the optimizer of your database > will translate them the same. IN is "cleaner" operator to use if you have > multiple ORs, though. makes it easier to understand your SQL statement. > > chris olive, cio > cresco technologies > [EMAIL PROTECTED] > http://www.crescotech.com > > > > -Original Message- > From: Duane Boudreau [mailto:[EMAIL PROTECTED]] > > Which is more efficient? > > WHERE x = 1 OR x = 2 OR x = 3 > > OR > > WHERE x IN (1,2,3) ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Reading/Writing HTTP Headers
What? Me? Did I say something? Nah, couldn't be! :-) -Original Message- From: Russel Madere [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 2:54 PM To: CF-Talk Subject: RE: Reading/Writing HTTP Headers REALLY! That will make life so much easier for some of the security issues I have been addressing. Thanks for that heads up. Russel Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the bear; some days the bear eats you. > -Original Message- > From: Ben Forta [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 31, 2001 11:51 > To: CF-Talk > Subject: RE: Reading/Writing HTTP Headers > > > And for the ones you cannot get at ... ColdFusion 5 will include a new > function called GetHTTPRequestData() that returns a structure > containing ALL > headers and more. > > > > -Original Message- > From: Russel Madere [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 31, 2001 12:49 PM > To: CF-Talk > Subject: RE: Reading/Writing HTTP Headers > > > Many of the HTTP Header Variables are available as CGI variables. > > Give them a try. > > Russel > > > Russel Madere, Jr. Senior Web Developer > ICQ: 5446158 http://www.TurboSquid.com > > Some days you eat the bear; some days the bear eats you. > > > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, January 31, 2001 11:20 > > To: CF-Talk > > Subject: Reading/Writing HTTP Headers > > > > > > Is there anyway to read the HTTP header using cold fusion. I > know you can > > write to the header using CFHEADER, but what if you want to read it? > > > > TIA > > Mary > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: String to Int
if you're using SQL server 7 you should _always_ use Val() in CFQUERY tags when expecting an integer because if your CFQUERY says: SELECT foo FROM bar WHERE id=#url.id# and someone changes the URL from: www.mysite.com/qwe.cfm?id=1 to www.mysite.com/qwe.cfm?id=1;delete%20from%20bar then what gets thrown to the dB is: SELECT foo FROM bar WHERE id=1;delete from bar and sql server 7 treats this as 2 valid sql statements and runs it You should write: SELECT foo FROM bar WHERE id=#Val(url.id)# Bert > -Original Message- > From: Maia, Eric [mailto:[EMAIL PROTECTED]] > Sent: 31 January 2001 19:21 > To: CF-Talk > Subject: RE: String to Int > > > I think this server is running ColdFusion 4.5.1, and it's > accessing SQL > Server 7. > > > -Original Message- > > From: Maia, Eric [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, January 30, 2001 17:07 > > To: CF-Talk > > Subject: RE: String to Int > > > >I now use > #Val(string_variable)# when I > > know I'll need an integer (e.g. inserting into a numeric DB column). ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Reading/Writing HTTP Headers
REALLY! That will make life so much easier for some of the security issues I have been addressing. Thanks for that heads up. Russel Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the bear; some days the bear eats you. > -Original Message- > From: Ben Forta [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 31, 2001 11:51 > To: CF-Talk > Subject: RE: Reading/Writing HTTP Headers > > > And for the ones you cannot get at ... ColdFusion 5 will include a new > function called GetHTTPRequestData() that returns a structure > containing ALL > headers and more. > > > > -Original Message- > From: Russel Madere [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 31, 2001 12:49 PM > To: CF-Talk > Subject: RE: Reading/Writing HTTP Headers > > > Many of the HTTP Header Variables are available as CGI variables. > > Give them a try. > > Russel > > > Russel Madere, Jr. Senior Web Developer > ICQ: 5446158 http://www.TurboSquid.com > > Some days you eat the bear; some days the bear eats you. > > > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, January 31, 2001 11:20 > > To: CF-Talk > > Subject: Reading/Writing HTTP Headers > > > > > > Is there anyway to read the HTTP header using cold fusion. I > know you can > > write to the header using CFHEADER, but what if you want to read it? > > > > TIA > > Mary > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Weird ODBC Errors with CF - Stumped
This week we switched our client storage to db based storage and moved it out of the registry. Since then we have been receiving numerous ODBC errors that have even brought the CF server down at times. "ODBC Error Code = 01000 (General warning) [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv())." AND "ODBC Error Code = 01000 (General warning) [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite (send())." Microsofts site has been of no help and our host has never seen this error before. So I come to all the experts on this list asking for some assistance. The network connection between the Web Server and CF has been tested and is working. We have the latest ODBC drivers from MS. When we revert back to registry based storage the problems go away. I think it is just the increased load do to the session db writing that is causing these errors. Has anyone here come across this error before? Any ideas of things to try? BOX 1: NT Server 4.0 sp4 CF Server 4.5.2 BOX 2: SQL Server 7.0 sp1 Mark Johnson --- Senior Cold Fusion Developer Cardinal Communications ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Windows 2000 Professional and CF Server 4.0.1
Well, I'm not much of an win person... but doesn't the installer keep a log of all system changes made? I mean, an installer can't do anything you can't do by hand. Try exporting the applicable registry tree from the NT4 system, copying any dlls required into the system directory on the 2k system, then do a straight file copy (if you need to make any reg changes for differing drives do so). I'm not sure exactly what's changed between the NT versions that would effect CF, but the system libraries may be newer and slightly (or completely) incompatible versions that effect the functionality of certain tags. If your time and lack of newer features is worth the money you might save, might as well give it a try. -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED]] Sent: January 31, 2001 14:12 To: CF-Talk Subject: Re: Windows 2000 Professional and CF Server 4.0.1 Zac, Thanks. Afraid I'd much rather install any Windows OS clean rather than upgrading, which is another set of headaches. For a new server, of course, it's also twice as fast. I wonder what it would take to get CF 4.0.1 to install directly into Win2k. Jim - Original Message - From: "Zachary Bedell" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 31, 2001 11:45 AM Subject: RE: Windows 2000 Professional and CF Server 4.0.1 > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > 4.0.1 works great provided it was there before Win2k. If you do NT4, > CF, then upgrade to Win2k, you should be okay. > > Basically 4.0.1 works fine under 2k, but the installer is brain dead. > Rather than patch the installer, Allaire would rather you run out & > spend on their new version. Big surprise... > > I've got a machine running 4.0.1 w/ Win2k Server w/ no problems what > so ever. > > Best regards, > Zac Bedell > > > -Original Message- > > From: Jim McAtee [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, January 31, 2001 12:38 PM > > To: CF-Talk > > Subject: Re: Windows 2000 Professional and CF Server 4.0.1 > > > > > > - Original Message - > > From: "Aidan Whitehall" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Wednesday, January 31, 2001 7:09 AM > > Subject: RE: Windows 2000 Professional and CF Server 4.0.1 > > > > > > > > Allaire does not support anything less than cf4.5 on a WIN2K > > > > box. > > > > > > OK, thanks. > > > > > > I'd still be interested in whether anyone's got a stable > > workaround. In > > general, Allaire support isn't something I use. I'm warming > > up to Windows > > 2000 - Windows 2000 Pro on workstations is great - now we're > > getting ready > > to take the plunge with our servers. CF 4.5, however, is > > something I don't > > need. I've still got it in a shrink-wrapped box from when we had a > > subscription. Way too many issues for me to want to deal with it. > > > > Jim > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
removing whitespace (was RE: Statistics on Toy R Us)
I've found that the easiest way to reduce the amount of whitespace is to remove it from the actual templates once they've been deleloped, though it obviously means your file back up system needs to be pretty, er, well backed up. Here's what i do: 1. develop on one server and use visual source safe. 2. Load the templates up to the test server from VSS 3. use a little app i wrote that uses CFFILE and Lee Borkman's CF_LESSWHITESPACE tag to rip out any whitespace and empty lines from the actual CFM files 4. If it still works (and it hasn't failed yet) then thats what goes up to the live server As i say, it does mean that you need to be _sure_ that you're not messing up your original files, but other than that it seems to work a treat. Removing carriage returns too would be nice, but i haven't had time to make sure any js wasn't messed up. It also has the benefit of discouraging anyone from making changes to the templates on the test or live servers - they're kind of hard to read Bert > -Original Message- > From: Steve Martin [mailto:[EMAIL PROTECTED]] > Sent: 31 January 2001 11:48 > To: CF-Talk > Subject: RE: Statistics on Toy R Us > > > > > Apparently the removewhitespace setting only applies to > > > whitespace internal to tags > > > e.g. > > > > > > datasource="dsn" > > > dbtype="odbc"> > > > > I know this is a dumb question, but WHAT F***ING USE IS THAT? > > > The internal CRs do bleed into the generated text so the all new super > snazzy removewhitespace does actually remove _some_ whitespace. > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: String to Int
I think this server is running ColdFusion 4.5.1, and it's accessing SQL Server 7. I don't have any problem with Attributes variables within ColdFusion, but they seem to be typed as a string when I try to insert them into the database or use them in a WHERE clause in a query. -Original Message- From: Russel Madere [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 6:42 AM To: CF-Talk Subject: RE: String to Int Strange! which version of Cold Fusion are you using? I have been using FormURL2Attributes.cfm for a while without any problems. Russel Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the bear; some days the bear eats you. > -Original Message- > From: Maia, Eric [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 30, 2001 17:07 > To: CF-Talk > Subject: RE: String to Int > > > I have had type errors related to Attributes. variables produced by > CF_FORMURL2ATTRIBUTES custom tag. I now use #Val(string_variable)# when I > know I'll need an integer (e.g. inserting into a numeric DB column). > > -Original Message- > From: Russel Madere [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 30, 2001 2:44 PM > To: CF-Talk > Subject: RE: String to Int > > > Actually, Cold Fusion does this automatically. Or more precisely, Cold > Fusion uses typeless variables. That way, you don't need to cast the type > for the variables. > > Russel > > > Russel Madere, Jr. Senior Web Developer > ICQ: 5446158 http://www.TurboSquid.com > > Some days you eat the bear; some days the bear eats you. > > > > > -Original Message- > > From: Richard Banks [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, January 30, 2001 15:53 > > To: CF-Talk > > Subject: String to Int > > > > > > is there a way [ie. a cf function ]to convert a string to an > > integer. let's > > say a user enters the string '1976' , and i want to process > that string as > > the integer 1976. > > any help would be greatly appreciated. thanks > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Question
Thanks Chris. I tried running the two queries but couldn't get a good read (likely because of the small data set) Duane -Original Message- From: Christopher Olive, CIO [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 2:09 PM To: CF-Talk Subject: RE: SQL Question they are essentially the same statement. the optimizer of your database will translate them the same. IN is "cleaner" operator to use if you have multiple ORs, though. makes it easier to understand your SQL statement. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 1:54 PM To: CF-Talk Subject: SQL Question Which is more efficient? WHERE x = 1 OR x = 2 OR x = 3 OR WHERE x IN (1,2,3) Duane ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re[2]: Performance question - CFINCLUDE versus writing a cus
Thank you for your quick response. Yes, we do know about views, but have not yet created them in IQ... although we have created extensive indexes and and yes, it is newer and different from SQL Advantage in a number of annoying ways. We are using IQ for our datawarehouse needs. Hopefully when we get it all working it will be as speedy as we know it has to be. Thanks again. Carol Carol L. Bluestein Senior Programmer NYS Office of Real Property 518-486-6335 [EMAIL PROTECTED] Reply Separator Subject:Re: Performance question - CFINCLUDE versus writing a cus Author: [EMAIL PROTECTED] Date: 1/31/01 12:09 PM Stored Procedures are a database function. I suggest looking in your database docs. I've done some work with Sybase SQL Anywhere a few years back. If memory serves me, they had something called views, which were akin to stored procedures. Don't hold me to that though. I'm not sure what you mean when you say Sybase IQ. New product? Same Product? I haven't kept up on the Sybase product line. Once you have the stored procedure created, you can reference it through SQL or using the CFSTOREDPROC tag. Carol Bluestein wrote: > We are managing huge SYBASE IQ databases and looking for ways to increase > performance. Your comment on stored procedures (5x quicker) really caught my > attention since our queries are also huge. I check allaire's knowledge base and > my current CF books (incl.Forta's Advanced Cold Fusion 4.0) and can find > nothing extensive. Is this all there is or are there other sources of > information > re: STORED PROCEDURES. Any help with information or pointing me towards > information would be very helpful. > > Thanks, > Carol > > Carol L. Bluestein > Senior Programmer > NYS Office of Real Property > 518-486-6335 > [EMAIL PROTECTED] > > Reply Separator > Subject:Re: Performance question - CFINCLUDE versus writing a custom > Author: [EMAIL PROTECTED] > Date: 1/30/01 5:24 PM > > Converting intensive queries to stored procedures is the single most > performance tweak you can do for a CF site. I've seen SP's perform up to 5 > times as fast as a regular > > jon > - Original Message - > From: "Kevin Gilchrist" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, January 30, 2001 4:00 PM > Subject: Re: Performance question - CFINCLUDE versus writing a custom CF > > > Unfortunately stored procedures aren't an option. > > What would that gain me anyway? Is it just more efficient for the queries > > to be executed by the DB (Oracle in this case)? > > > > Going by Philip's answer, I guess doing CFINCLUDE'a are the way to go. > > > > "Steve Bernard" <[EMAIL PROTECTED]> wrote in message > > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > > Are stored procedures not an option? > > > > > > Steve > > > > > > -Original Message- > > > From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]] > > > Sent: Tuesday, January 30, 2001 12:07 PM > > > To: CF-Talk > > > Subject: Performance question - CFINCLUDE versus writing a custom CF > > > > > > > > > Hi all, > > > > > > I'm writing a web app that acts as a dashboard for an MSP, i.e. a GUI > that > > > shows the status of all sorts of applications, network and host > devices. > > I > > > need to write quite a few select queries for each device/host/app type, > so > > > will end up with ~150 different queries. > > > > > > What I'm wondering about is if anyone has any thoughts on whether it's > > > better to access these queries from the GUI templates using > > > > > > - a series of conditional CFINCLUDE's that would include a smallish > query > > > template. > > > > > > - or write a custom CF tag with all the queries inside and pass three > > > parameters that would give me a unique query name. A three deep CFWITCH > > > statement could home in on the relevant query. > > > > > > Is it correct to assume that it's a bigger hit on CF to call on a > > relatively > > > large templates even though it's doesn't have to process much of it (cf_ > > > tag), as opposed to including whole but small templates? > > > I guess it may be better organizationally to implement the queries as a > > > bunch of small files to include? > > > > > > It seems like a case of six in one, half a dozen in the other but I'll > > never > > > know if I don't ask... > > > > > > Thanks, > > > Kevin > > > > > > P.S. I intend to convert it all to fusebox for version 2. > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Windows 2000 Professional and CF Server 4.0.1
> Thanks. Afraid I'd much rather install any Windows OS clean > rather than upgrading, which is another set of headaches. For > a new server, of course, it's also twice as fast. I wonder > what it would take to get CF 4.0.1 to install directly into > Win2k. It'll install directly in Win2K without any visible problems. In fact, it'll work fine after installation. The problem with CF 4.0.1 on Win2K is that it breaks some MDAC components. You won't notice using ODBC from CF, but will if you try to write ASP code. You can easily fix this by downloading and installing MDAC 2.6. Enjoy! Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Question
they are essentially the same statement. the optimizer of your database will translate them the same. IN is "cleaner" operator to use if you have multiple ORs, though. makes it easier to understand your SQL statement. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 1:54 PM To: CF-Talk Subject: SQL Question Which is more efficient? WHERE x = 1 OR x = 2 OR x = 3 OR WHERE x IN (1,2,3) Duane ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Windows 2000 Professional and CF Server 4.0.1
Zac, Thanks. Afraid I'd much rather install any Windows OS clean rather than upgrading, which is another set of headaches. For a new server, of course, it's also twice as fast. I wonder what it would take to get CF 4.0.1 to install directly into Win2k. Jim - Original Message - From: "Zachary Bedell" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 31, 2001 11:45 AM Subject: RE: Windows 2000 Professional and CF Server 4.0.1 > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > 4.0.1 works great provided it was there before Win2k. If you do NT4, > CF, then upgrade to Win2k, you should be okay. > > Basically 4.0.1 works fine under 2k, but the installer is brain dead. > Rather than patch the installer, Allaire would rather you run out & > spend on their new version. Big surprise... > > I've got a machine running 4.0.1 w/ Win2k Server w/ no problems what > so ever. > > Best regards, > Zac Bedell > > > -Original Message- > > From: Jim McAtee [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, January 31, 2001 12:38 PM > > To: CF-Talk > > Subject: Re: Windows 2000 Professional and CF Server 4.0.1 > > > > > > - Original Message - > > From: "Aidan Whitehall" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Wednesday, January 31, 2001 7:09 AM > > Subject: RE: Windows 2000 Professional and CF Server 4.0.1 > > > > > > > > Allaire does not support anything less than cf4.5 on a WIN2K > > > > box. > > > > > > OK, thanks. > > > > > > I'd still be interested in whether anyone's got a stable > > workaround. In > > general, Allaire support isn't something I use. I'm warming > > up to Windows > > 2000 - Windows 2000 Pro on workstations is great - now we're > > getting ready > > to take the plunge with our servers. CF 4.5, however, is > > something I don't > > need. I've still got it in a shrink-wrapped box from when we had a > > subscription. Way too many issues for me to want to deal with it. > > > > Jim > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL Question
Which is more efficient? WHERE x = 1 OR x = 2 OR x = 3 OR WHERE x IN (1,2,3) Duane ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
cf-talk@houseoffusion.com
I have a copy of CF Pro 4.5 for Windows...anyone want to trade me a copy of CF Pro for Linux? Thanks. [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Windows 2000 Professional and CF Server 4.0.1
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 4.0.1 works great provided it was there before Win2k. If you do NT4, CF, then upgrade to Win2k, you should be okay. Basically 4.0.1 works fine under 2k, but the installer is brain dead. Rather than patch the installer, Allaire would rather you run out & spend on their new version. Big surprise... I've got a machine running 4.0.1 w/ Win2k Server w/ no problems what so ever. Best regards, Zac Bedell > -Original Message- > From: Jim McAtee [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 31, 2001 12:38 PM > To: CF-Talk > Subject: Re: Windows 2000 Professional and CF Server 4.0.1 > > > - Original Message - > From: "Aidan Whitehall" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, January 31, 2001 7:09 AM > Subject: RE: Windows 2000 Professional and CF Server 4.0.1 > > > > > Allaire does not support anything less than cf4.5 on a WIN2K > > > box. > > > > OK, thanks. > > > I'd still be interested in whether anyone's got a stable > workaround. In > general, Allaire support isn't something I use. I'm warming > up to Windows > 2000 - Windows 2000 Pro on workstations is great - now we're > getting ready > to take the plunge with our servers. CF 4.5, however, is > something I don't > need. I've still got it in a shrink-wrapped box from when we had a > subscription. Way too many issues for me to want to deal with it. > > Jim > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Advanced Security in CF 4.5
During the install of ColdFusion Server, you must specify whether or not you would like to install Advanced Security. If you do not see it listed under "Basic Security" in the ColdFusion administrator, then you have not installed it. Advanced Security does come with ColdFusion Professional. However, the Advanced Security in ColdFusion Professional does not give you the ability to create Security Sandboxes. Benjamin S. Rogers Web Developer, c4.net Voice: (508) 240-0051 Fax: (508) 240-0057 -Original Message- From: Gregory Harris [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 1:08 PM To: CF-Talk Subject: Advanced Security in CF 4.5 Hello, I was in the process of moving a development effort using CF 4.0's advanced security to a CF 4.5 server, however I noticed that there is no way to set up Advanced security in the CF 4.5 admin, any ideas ppl, thanks! Gregory Harris Web Developer Stirling Bridge LLC ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
OT:I know NOTHING about Crystal Reports!
Hey all! As is the nature of our business, I had something thrown in my lap yesterday, and I'm just trying to figure out if Crystal Reports will accomplish this or not... Basically, we need a way to allow users to generate reports on the fly via their web browsers (we don't want to install anything on the client machines) based on different criteria. Once the report is generated, we want to dump the report info to Excel so that users can manipulate it as needed. I am looking into Crystal Reports 8 (Developer Ed.), and I THINK it can do this, but I'm not entirely sure. I want to know 100% for sure if Crystal Reports would be the way to do this before we go ahead and hire an outside contractor for Crystal Reports (our skill here aren't strong enough to do this in the timeframe management is asking for)... Any input is greatly appreciated! BTW, we are using CF 4.0, Oracle, and need to design for both NN and IE, 4.X and up. Thanks! Terri ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Reading/Writing HTTP Headers
> Is there a workaround to read this data with v 4.5? > > TIA, > Duane I have a COM called TCPClient. A little hardcore maybe, but the following cf is from one of the examples. It grabs the header info from the default page and breaks it apart for display --min #HTMLCodeFormat(page)# Breaks the headers up into name/value pairs. name value #ListGetAt(line,1,":")# #ListGetAt(line,2,":")# ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Advanced Security in CF 4.5
You must have CF 4.5 Enterprise to get Advanced Security. Steve -Original Message- From: Gregory Harris [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 1:08 PM To: CF-Talk Subject: Advanced Security in CF 4.5 Hello, I was in the process of moving a development effort using CF 4.0's advanced security to a CF 4.5 server, however I noticed that there is no way to set up Advanced security in the CF 4.5 admin, any ideas ppl, thanks! Gregory Harris Web Developer Stirling Bridge LLC ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Advanced Security in CF 4.5
It's there...IF you specify that you want to use advanced security when you install -Original Message- From: Gregory Harris [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 1:08 PM To: CF-Talk Subject: Advanced Security in CF 4.5 Hello, I was in the process of moving a development effort using CF 4.0's advanced security to a CF 4.5 server, however I noticed that there is no way to set up Advanced security in the CF 4.5 admin, any ideas ppl, thanks! Gregory Harris Web Developer Stirling Bridge LLC ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Advanced Security in CF 4.5
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Greg, The version of CF 4.5 you're looking at is the professional version, not Enterprise. You must have enterprise installed in order to use Advanced Security. Aaron Johnson, MCSE, MCP+I Allaire Certified ColdFusion Developer MINDSEYE, Inc. 617.350.0339 617.350.8884 66172567 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Reading/Writing HTTP Headers
Is there a workaround to read this data with v 4.5? TIA, Duane -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 12:51 PM To: CF-Talk Subject: RE: Reading/Writing HTTP Headers And for the ones you cannot get at ... ColdFusion 5 will include a new function called GetHTTPRequestData() that returns a structure containing ALL headers and more. -Original Message- From: Russel Madere [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 12:49 PM To: CF-Talk Subject: RE: Reading/Writing HTTP Headers Many of the HTTP Header Variables are available as CGI variables. Give them a try. Russel Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the bear; some days the bear eats you. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 31, 2001 11:20 > To: CF-Talk > Subject: Reading/Writing HTTP Headers > > > Is there anyway to read the HTTP header using cold fusion. I know you can > write to the header using CFHEADER, but what if you want to read it? > > TIA > Mary > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Advanced Security in CF 4.5
Hello, I was in the process of moving a development effort using CF 4.0's advanced security to a CF 4.5 server, however I noticed that there is no way to set up Advanced security in the CF 4.5 admin, any ideas ppl, thanks! Gregory Harris Web Developer Stirling Bridge LLC ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help needed with ODBC Excel datasource problems...
Ok...the link table didn't work. The values still come up as numbers, and Access won't allow me to change the values. Philip's solution of creating a new field is likely not feasible with my client, as he'll have toi convince all customers who create these spreadsheets to make this change, and input only in the correct field. However...I did an IMPORT in Access, and that imported perfectly. Does anyone know of a script or a custom tag that will automate the importing of an external Excel spreadsheet into an Excel database? -Kev -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 10:13 AM To: CF-Talk Subject: RE: Help needed with ODBC Excel datasource problems... > When creating an ODBC datasource for Excel, you define how many > rows to scan > to allow CF to determine what the datatype of each field is. If you have > column headings in your spreadsheet, then they are automatically used as > field names when imported. I have set the number of rows to scan to 1, > hoping to force the ODBC driver to use the column headings as the > determining factor for data type determinination, and that didn't work. I > figured maybe it was skipping the first row and reading the second, so I > added "Do not alter this text" in every field in row two, again hoping to > force the datatypes to strings. The Excel ODBC driver is notoriously bad - even using a Link table produces the same problem Once it decides on a field type, then it forces it into that mode, and the "other" type (text/numeric) are ignored The only way to force it is to format a row into text, but not used the Cell Format function in Excel as that's only visual Make a cell beside the one with data with =Mid("'"&D2,2,Len(D2)) Where D2 is the cell to the left This will FORCE it into text mode... it's what I had to do to get one of our clients sheets working - they now have to add that every time they upload Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Nesting CFTRANSACTIONs
Explanation: You have used a CFTRANSACTION tag within the scope of another CFTRANSACTION tag (nesting of CFTRANSACTION tags is not permitted). Sorry to point out the obvious but! > -Original Message- > From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] > Sent: 31 January 2001 17:21 > To: CF-Talk > Subject: Nesting CFTRANSACTIONs > > > We have a custom tag that has a CFTRANSACTION in it. That tag is > called from > 3 other templates, all of which call it from within a query-driven CFLOOP. > > Ideally, I'd like to be able to retain the CFTRANSACTION within the custom > tag but also wrap a CFTRANSACTION around the query-driven loop, but I'm > getting this error: > > > CWebException: Error: Invalid use of CFTRANSACTION tag > > Explanation: You have used a CFTRANSACTION tag within the > scope of another CFTRANSACTION tag (nesting of > CFTRANSACTION tags is not permitted). > > This error very likely results from the unintentional omission > of the end tag (/CFTRANSACTION) for your first > CFTRANSACTION. > > > The closing tag is there, BTW. > > Is nesting CFTRANSACTIONS possible at all, perhaps by using certain > attribute parameters? > > > > Thanks > > -- > Aidan Whitehall <[EMAIL PROTECTED]> > Netshopper UK Ltd > Advanced Web Solutions & Services > > http://www.netshopperuk.com/ > Telephone +44 (01744) 648650 > Fax +44 (01744) 648651 > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Reading/Writing HTTP Headers
And for the ones you cannot get at ... ColdFusion 5 will include a new function called GetHTTPRequestData() that returns a structure containing ALL headers and more. -Original Message- From: Russel Madere [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 12:49 PM To: CF-Talk Subject: RE: Reading/Writing HTTP Headers Many of the HTTP Header Variables are available as CGI variables. Give them a try. Russel Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the bear; some days the bear eats you. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 31, 2001 11:20 > To: CF-Talk > Subject: Reading/Writing HTTP Headers > > > Is there anyway to read the HTTP header using cold fusion. I know you can > write to the header using CFHEADER, but what if you want to read it? > > TIA > Mary > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Reading/Writing HTTP Headers
Many of the HTTP Header Variables are available as CGI variables. Give them a try. Russel Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the bear; some days the bear eats you. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 31, 2001 11:20 > To: CF-Talk > Subject: Reading/Writing HTTP Headers > > > Is there anyway to read the HTTP header using cold fusion. I know you can > write to the header using CFHEADER, but what if you want to read it? > > TIA > Mary > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help needed with ODBC Excel datasource problems...
Hmmm...I've never attached with Access before, but I'll give it a try. Thanks. :) -Kev -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 9:57 AM To: CF-Talk Subject: RE: Help needed with ODBC Excel datasource problems... Random untested suggestion: Create an MS Access DB, attach/link the Excel spreadsheet, and see if Access correctly understands the column as character/string. If Access gets it right, create a CF datasource to the Access DB and query the attached table, hoping that Access' field data type will be the one the CF uses. -Original Message- From: Kevin Langevin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 9:35 AM To: CF-Talk Subject: Help needed with ODBC Excel datasource problems... Hi all- Got a tricky one for ya. I have an Excel datasource that I need to import into an Access DB. I've been to www.cfcomet.com (excellent site, by the way...definitely visit for any issues with accessing MS Office Objects through CF) which gave me a start, but I've run into a problem I can't find addressed anywhere. <---snip ---> Didn't work. :( I have one particular field which, in some cases: a) is blank, b) has a number in it, or c) has multiple numbers, separated by spaces (ie. 3 5 2) For whatever reason, CF is importing this field as a number, converting the 3 to 3.0, and dropping the rest of the field. This has me stymied, because ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Windows 2000 Professional and CF Server 4.0.1
- Original Message - From: "Aidan Whitehall" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 31, 2001 7:09 AM Subject: RE: Windows 2000 Professional and CF Server 4.0.1 > > Allaire does not support anything less than cf4.5 on a WIN2K box. > > OK, thanks. I'd still be interested in whether anyone's got a stable workaround. In general, Allaire support isn't something I use. I'm warming up to Windows 2000 - Windows 2000 Pro on workstations is great - now we're getting ready to take the plunge with our servers. CF 4.5, however, is something I don't need. I've still got it in a shrink-wrapped box from when we had a subscription. Way too many issues for me to want to deal with it. Jim ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
UPLOAD on Mac
Hello I'm wondering if anyone has found a workaround to the following situation...we are using CFFILE to upload .gif and .jpg files to our server. The scripts work fine on Netscape and IE on a PC, but only work with Netscape on a Macintosh. The mac OS is 9.0 and we are using IE 5.0. Is there a way to correct this ? Thanks ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Reading/Writing HTTP Headers
Is there anyway to read the HTTP header using cold fusion. I know you can write to the header using CFHEADER, but what if you want to read it? TIA Mary ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Nesting CFTRANSACTIONs
We have a custom tag that has a CFTRANSACTION in it. That tag is called from 3 other templates, all of which call it from within a query-driven CFLOOP. Ideally, I'd like to be able to retain the CFTRANSACTION within the custom tag but also wrap a CFTRANSACTION around the query-driven loop, but I'm getting this error: CWebException: Error: Invalid use of CFTRANSACTION tag Explanation: You have used a CFTRANSACTION tag within the scope of another CFTRANSACTION tag (nesting of CFTRANSACTION tags is not permitted). This error very likely results from the unintentional omission of the end tag (/CFTRANSACTION) for your first CFTRANSACTION. The closing tag is there, BTW. Is nesting CFTRANSACTIONS possible at all, perhaps by using certain attribute parameters? Thanks -- Aidan Whitehall <[EMAIL PROTECTED]> Netshopper UK Ltd Advanced Web Solutions & Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Performance question - CFINCLUDE versus writing a cus
Stored Procedures are a database function. I suggest looking in your database docs. I've done some work with Sybase SQL Anywhere a few years back. If memory serves me, they had something called views, which were akin to stored procedures. Don't hold me to that though. I'm not sure what you mean when you say Sybase IQ. New product? Same Product? I haven't kept up on the Sybase product line. Once you have the stored procedure created, you can reference it through SQL or using the CFSTOREDPROC tag. Carol Bluestein wrote: > We are managing huge SYBASE IQ databases and looking for ways to increase > performance. Your comment on stored procedures (5x quicker) really caught my > attention since our queries are also huge. I check allaire's knowledge base and > my current CF books (incl.Forta's Advanced Cold Fusion 4.0) and can find > nothing extensive. Is this all there is or are there other sources of > information > re: STORED PROCEDURES. Any help with information or pointing me towards > information would be very helpful. > > Thanks, > Carol > > Carol L. Bluestein > Senior Programmer > NYS Office of Real Property > 518-486-6335 > [EMAIL PROTECTED] > > Reply Separator > Subject:Re: Performance question - CFINCLUDE versus writing a custom > Author: [EMAIL PROTECTED] > Date: 1/30/01 5:24 PM > > Converting intensive queries to stored procedures is the single most > performance tweak you can do for a CF site. I've seen SP's perform up to 5 > times as fast as a regular > > jon > - Original Message - > From: "Kevin Gilchrist" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, January 30, 2001 4:00 PM > Subject: Re: Performance question - CFINCLUDE versus writing a custom CF > > > Unfortunately stored procedures aren't an option. > > What would that gain me anyway? Is it just more efficient for the queries > > to be executed by the DB (Oracle in this case)? > > > > Going by Philip's answer, I guess doing CFINCLUDE'a are the way to go. > > > > "Steve Bernard" <[EMAIL PROTECTED]> wrote in message > > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > > Are stored procedures not an option? > > > > > > Steve > > > > > > -Original Message- > > > From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]] > > > Sent: Tuesday, January 30, 2001 12:07 PM > > > To: CF-Talk > > > Subject: Performance question - CFINCLUDE versus writing a custom CF > > > > > > > > > Hi all, > > > > > > I'm writing a web app that acts as a dashboard for an MSP, i.e. a GUI > that > > > shows the status of all sorts of applications, network and host > devices. > > I > > > need to write quite a few select queries for each device/host/app type, > so > > > will end up with ~150 different queries. > > > > > > What I'm wondering about is if anyone has any thoughts on whether it's > > > better to access these queries from the GUI templates using > > > > > > - a series of conditional CFINCLUDE's that would include a smallish > query > > > template. > > > > > > - or write a custom CF tag with all the queries inside and pass three > > > parameters that would give me a unique query name. A three deep CFWITCH > > > statement could home in on the relevant query. > > > > > > Is it correct to assume that it's a bigger hit on CF to call on a > > relatively > > > large templates even though it's doesn't have to process much of it (cf_ > > > tag), as opposed to including whole but small templates? > > > I guess it may be better organizationally to implement the queries as a > > > bunch of small files to include? > > > > > > It seems like a case of six in one, half a dozen in the other but I'll > > never > > > know if I don't ask... > > > > > > Thanks, > > > Kevin > > > > > > P.S. I intend to convert it all to fusebox for version 2. > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re[2]: Performance question - CFINCLUDE versus writing a cus
We are managing huge SYBASE IQ databases and looking for ways to increase performance. Your comment on stored procedures (5x quicker) really caught my attention since our queries are also huge. I check allaire's knowledge base and my current CF books (incl.Forta's Advanced Cold Fusion 4.0) and can find nothing extensive. Is this all there is or are there other sources of information re: STORED PROCEDURES. Any help with information or pointing me towards information would be very helpful. Thanks, Carol Carol L. Bluestein Senior Programmer NYS Office of Real Property 518-486-6335 [EMAIL PROTECTED] Reply Separator Subject:Re: Performance question - CFINCLUDE versus writing a custom Author: [EMAIL PROTECTED] Date: 1/30/01 5:24 PM Converting intensive queries to stored procedures is the single most performance tweak you can do for a CF site. I've seen SP's perform up to 5 times as fast as a regular jon - Original Message - From: "Kevin Gilchrist" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, January 30, 2001 4:00 PM Subject: Re: Performance question - CFINCLUDE versus writing a custom CF > Unfortunately stored procedures aren't an option. > What would that gain me anyway? Is it just more efficient for the queries > to be executed by the DB (Oracle in this case)? > > Going by Philip's answer, I guess doing CFINCLUDE'a are the way to go. > > "Steve Bernard" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Are stored procedures not an option? > > > > Steve > > > > -Original Message- > > From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, January 30, 2001 12:07 PM > > To: CF-Talk > > Subject: Performance question - CFINCLUDE versus writing a custom CF > > > > > > Hi all, > > > > I'm writing a web app that acts as a dashboard for an MSP, i.e. a GUI that > > shows the status of all sorts of applications, network and host devices. > I > > need to write quite a few select queries for each device/host/app type, so > > will end up with ~150 different queries. > > > > What I'm wondering about is if anyone has any thoughts on whether it's > > better to access these queries from the GUI templates using > > > > - a series of conditional CFINCLUDE's that would include a smallish query > > template. > > > > - or write a custom CF tag with all the queries inside and pass three > > parameters that would give me a unique query name. A three deep CFWITCH > > statement could home in on the relevant query. > > > > Is it correct to assume that it's a bigger hit on CF to call on a > relatively > > large templates even though it's doesn't have to process much of it (cf_ > > tag), as opposed to including whole but small templates? > > I guess it may be better organizationally to implement the queries as a > > bunch of small files to include? > > > > It seems like a case of six in one, half a dozen in the other but I'll > never > > know if I don't ask... > > > > Thanks, > > Kevin > > > > P.S. I intend to convert it all to fusebox for version 2. > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
BrowserHawk Extended Properties - ASP and COM?
I've just got the new copy of cyScape's BrowserHawk. I assume there's a few users of it out there since I've seen people recommend it on this list. I want to take advantage of some of the "Extended Properties" (detection of cookies, javascript enabled, plugins, etc.) which are not available through their CF custom tag, but are through ASP pages. Question is, can I call the ASP pages or the functions in them through a COM object? That way, I can avoid having to send to an ASP and redirect to CF, etc. etc. Thanks, Evan -- -=-=-=-=-=-=-=-=-=- Evan Lavidor Circle.com Boston Tel: 617-585-3107 Fax: 617-585-3091 -=-=-=-=-=-=-=-=-=- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Random letter/number value
digits = arrayNew(1) ; passwd = "" ; /* fill passwd i digits long w/ random selection of number, uppercase, or lowercase characters */ for (i=1; i le 8; i=i+1) { digits[1] = chr(randRange(48, 57)) ; digits[2] = chr(randRange(65, 90)) ; digits[3] = chr(randRange(97, 122)) ; passwd = passwd & digits[randRange(1, 3)] ; } If you're not case sensitive feel free to remove digits[3] and change the last randRange() to reflect it. -Original Message- From: Peter Benoit [mailto:[EMAIL PROTECTED]] Sent: January 31, 2001 10:56 To: CF-Talk Subject: Random letter/number value Hi, I'd like to produce a random letter/number value for a password field, could be around 8 characters I suppose. Can I get help with this please? Thanks, Peter ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Random letter/number value
The following should do what you want. Steve > -Original Message- > From: Peter Benoit [mailto:[EMAIL PROTECTED]] > Sent: 31 January 2001 15:56 > To: CF-Talk > Subject: Random letter/number value > > > Hi, > > I'd like to produce a random letter/number value for a password > field, could > be around 8 characters I suppose. Can I get help with this please? > > Thanks, > Peter > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Random letter/number value
there are tags in the developer gallery for this. search for "password". chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Peter Benoit [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 10:56 AM To: CF-Talk Subject: Random letter/number value Hi, I'd like to produce a random letter/number value for a password field, could be around 8 characters I suppose. Can I get help with this please? Thanks, Peter ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Random letter/number value
> I'd like to produce a random letter/number value for a > password field, could > be around 8 characters I suppose. Go to the Gallery on the Allaire site and do a search for a custom tag called RandomPassword. You can configure it to return variables.RandomPassword, formatted however you like. http://devex.allaire.com/developer/gallery/ -- Aidan Whitehall <[EMAIL PROTECTED]> Netshopper UK Ltd Advanced Web Solutions & Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Coldfusion vs. Jsp
It's a "those with stars, and those without stars on thars" thing. ;) Steve -Original Message- From: Michael [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 9:42 AM To: CF-Talk Subject: Re: Coldfusion vs. Jsp So do you mean jsp pages are better then cfm pages? "Rey Bango" <[EMAIL PROTECTED]> wrote in message 007101c08a3d$9e1cce60$0d0b320a@RBango">news:007101c08a3d$9e1cce60$0d0b320a@RBango... > >> who branded Jsp? << > > Sun Microsystems. > > >> and which is better? << > > The one that allows you to provide the best & most comprehensive solution > for your client or employer. Not being sarcastic. Just honest. > > Rey > Team Allaire ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Push alert page to browser?
> Have you considered using a hidden frame. This hidden frame could > automatically reload every so often check for time frame of session > variable. If it is about to expire then the hidden frame > could redirect the > main frame to an alert page (or popup a new window or create > a js alert > window). But what would it ask for that would tell it how long before the session expired? And wouldn't the request itself keep alive the session that it was trying to monitor? -- Aidan Whitehall <[EMAIL PROTECTED]> Netshopper UK Ltd Advanced Web Solutions & Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Push alert page to browser?
In a message dated 1/31/01 9:55:25 AM Eastern Standard Time, [EMAIL PROTECTED] writes: > Possibly use the meta refresh tag to refresh the page every so often. And MS has push technology ... cdf (channel definition format?). Bill ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: DB Query
so you want a list of proucts and both manufacturers? try a double join. (please note. this assumes that there are always values for both ManID and RealManID. if they are not always populated, make the joins OUTER and you'll be good.) SELECT p.pid, p., m1.manname, m2.manname FROM products p, manufacturers m1, manufacturers m2 WHERE p.manid = m1.manid AND p.realmanid = m2.manid chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Duane Boudreau [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 10:24 AM To: CF-Talk Subject: DB Query I have a couple of tables I am working with that do not have very good PK/FKs setup. (Unfortunately this is not my schema and I don't have the luxury of changing it) 1) Manufactures [ManID, ManName, ] 2) Products [PID, ManID, RealManID ] ManID and RealManID map to MID and usually contain differing values. I need (hopefully) in one query to extract both the Real Manufacturer Name and the other Manufacturer Name. Duane ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Random letter/number value
Hi, I'd like to produce a random letter/number value for a password field, could be around 8 characters I suppose. Can I get help with this please? Thanks, Peter ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Query Search results (nextpage) ... WDDX?
I have a search results page that displays a max of 100 records at a shot. Sometimes the total results exceed several thousand records. In an attempt to speed up the 'next page' processing I no longer use the CFSEARCH using startrow with the CFOUTPUT query using maxrows b/c of the processing time to research all the indexes I have created. I now do the CFSEARCH and use the CFOUTPUT query using maxrow and startrow (which is calculated and passed) the first time into the form. I use WDDX to convert the results of the search and pass it. I am calling the same form over again and determine if this is the first call or a call there after. If it is not the first time, I convert the query from WDDX and run CFOUTPUT query. THE PROBLEM: Sometimes, if there are a high number of result records, there is a long processing time on the results page after the first time. Is this common with passing the results using WDDX or is there a better way to do this type of next page processing for search results? Also, when I process 'next page' more than once the BACK button on the browser is disabled and I can not get back to the original 100 results. a bit of code.FORM is SearchResult_test.cfm some processing. No Score File Title Search Category lotsa processing to display the results... .Hidden input fields ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
DB Query
I have a couple of tables I am working with that do not have very good PK/FKs setup. (Unfortunately this is not my schema and I don't have the luxury of changing it) 1) Manufactures [ManID, ManName, ] 2) Products [PID, ManID, RealManID ] ManID and RealManID map to MID and usually contain differing values. I need (hopefully) in one query to extract both the Real Manufacturer Name and the other Manufacturer Name. Duane ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [MySQL and CF]
MyODBC at http://www.mysql.com you need to add a user to the MySQL user table "Kevin Schmidt" <[EMAIL PROTECTED]> wrote: Anyone have any luck hooking up CF to a MySQL database. Can it be done and if so where are the necessary ODBC drivers? Kevin Schmidt, Web Technology Manager Allaire Certified ColdFusion Developer pwb inc. integrated marketing communications 350 S. Main St., Suite 350 Ann Arbor, MI 48104 734.995.5000 (tel) 734.995.5002 (fax) www.pwb.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: MySQL and CF
I have it done with no problems. You can get the necessary ODBC drivers from the mysql website. I'm not sure for Unix based systems but they are there for windows. At 10:10 AM 1/31/2001 -0600, you wrote: >Anyone have any luck hooking up CF to a MySQL database. Can it be done and >if so where are the necessary ODBC drivers? > >Kevin Schmidt, Web Technology Manager >Allaire Certified ColdFusion Developer >pwb inc. >integrated marketing communications >350 S. Main St., Suite 350 >Ann Arbor, MI 48104 >734.995.5000 (tel) >734.995.5002 (fax) >www.pwb.com > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Email app!
there's the Crazy Cab Email client example application that comes with Server. check it out. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Dusty Tinashe Shoko [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 4:24 AM To: CF-Talk Subject: Email app! Hi there I was wondering if there is already a free email (web based like yahoo or hotmail) appl that has been written in CF or any other lang like Java etc Bossess need to access their email when away from the office! *** Dusty Tinashe Shoko Web Applications Developer SARDC http://www.sardc.net 13 Bath Rd Belgravia Phone: 738694/5/6 *** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help needed with ODBC Excel datasource problems...
> When creating an ODBC datasource for Excel, you define how many > rows to scan > to allow CF to determine what the datatype of each field is. If you have > column headings in your spreadsheet, then they are automatically used as > field names when imported. I have set the number of rows to scan to 1, > hoping to force the ODBC driver to use the column headings as the > determining factor for data type determinination, and that didn't work. I > figured maybe it was skipping the first row and reading the second, so I > added "Do not alter this text" in every field in row two, again hoping to > force the datatypes to strings. The Excel ODBC driver is notoriously bad - even using a Link table produces the same problem Once it decides on a field type, then it forces it into that mode, and the "other" type (text/numeric) are ignored The only way to force it is to format a row into text, but not used the Cell Format function in Excel as that's only visual Make a cell beside the one with data with =Mid("'"&D2,2,Len(D2)) Where D2 is the cell to the left This will FORCE it into text mode... it's what I had to do to get one of our clients sheets working - they now have to add that every time they upload Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
MySQL and CF
Anyone have any luck hooking up CF to a MySQL database. Can it be done and if so where are the necessary ODBC drivers? Kevin Schmidt, Web Technology Manager Allaire Certified ColdFusion Developer pwb inc. integrated marketing communications 350 S. Main St., Suite 350 Ann Arbor, MI 48104 734.995.5000 (tel) 734.995.5002 (fax) www.pwb.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Inetinfo.exe crashing
It is a production server so I would rather not reformat, reinstall, etc. It's a pretty vanilla NT box (CF, Oracle client, IIS4, Backup Exec). No databases on it. It is running CF as a restricted user, not system. I was having some scheduler errors that I'm not sure of the problem (a 401 error followed immediately by a successful operation according to the IIS log files (same timestamp)). Thanks for the ideas. dave -- Original Message -- From: "Al Musella, DPM" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Wed, 31 Jan 2001 09:16:37 -0500 > >The first thing I would try is to reformat the drive, reinstall Windows, >the web server and cold fusion.. >Inetinfo shouldn't crash no matter what you do to it. A lot of times there >are .dll version conflicts that cause it. >Do not put anything else on the server. >Al >a1webs.com > >At 10:36 PM 1/30/2001 -0500, dave fauth wrote: >>I have a CF site (CF 4.5.1 sp1 enterprise) on NT 4 sp6a that is crashing >>Inetinfo.exe more and more in the last week or so. Previously, it has been >>running great. Any ideas on where to start looking or debugging to figure >>this out. I'm assuming that proper locking would be one idea. I've had >>bad luck on upgrading the dev server to 4.5.1 sp2 so that's why I'm still >>at sp1. >> >>Any help would be greatly appreciated. >> >>thanks >>dave >>--- > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Anyone on this list supporting J2EE applications at your site as well?
I would like to ask some questions - off the list of course - regarding day to day operational support of J2EE apps. Would someone be willing to discuss this in email with me? -- Larry W. Virden mailto:[EMAIL PROTECTED]> http://www.purl.org/net/lvirden/> Even if explicitly stated to the contrary, nothing in this posting should be construed as representing my employer's opinions. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Push alert page to browser?
> Yes, but HTTP works on request-response pairs, so how can the server > send anything to the browser unless the browser requests it? > > If there *is* a way I'd be very interested to know it. > > I don't think it makes any difference whether you're using CF, JSP > or whatever on the server - you've still got HTTP as the protocol > in the middle. You could always put "There are x minutes left until this session ends" on the top of the page, but ensure they know it's at time of generation, not when they look at it (obv) Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help needed with ODBC Excel datasource problems...
Random untested suggestion: Create an MS Access DB, attach/link the Excel spreadsheet, and see if Access correctly understands the column as character/string. If Access gets it right, create a CF datasource to the Access DB and query the attached table, hoping that Access' field data type will be the one the CF uses. -Original Message- From: Kevin Langevin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 9:35 AM To: CF-Talk Subject: Help needed with ODBC Excel datasource problems... Hi all- Got a tricky one for ya. I have an Excel datasource that I need to import into an Access DB. I've been to www.cfcomet.com (excellent site, by the way...definitely visit for any issues with accessing MS Office Objects through CF) which gave me a start, but I've run into a problem I can't find addressed anywhere. <---snip ---> Didn't work. :( I have one particular field which, in some cases: a) is blank, b) has a number in it, or c) has multiple numbers, separated by spaces (ie. 3 5 2) For whatever reason, CF is importing this field as a number, converting the 3 to 3.0, and dropping the rest of the field. This has me stymied, because ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Push alert page to browser?
Have you considered using a hidden frame. This hidden frame could automatically reload every so often check for time frame of session variable. If it is about to expire then the hidden frame could redirect the main frame to an alert page (or popup a new window or create a js alert window). Chris Sham - Original Message - From: "DeVoil, Nick" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 31, 2001 9:50 AM Subject: RE: Push alert page to browser? > Yes, but HTTP works on request-response pairs, so how can the server > send anything to the browser unless the browser requests it? > > If there *is* a way I'd be very interested to know it. > > I don't think it makes any difference whether you're using CF, JSP > or whatever on the server - you've still got HTTP as the protocol > in the middle. > > Nick > > > -Original Message- > From: Chris Norloff [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 31, 2001 2:37 PM > To: CF-Talk > Subject: RE: Push alert page to browser? > > > ha ha! Well said. Specifically, the client wants to minimize required > client-side functions that aren't in all browsers, and especially functions > that can be turned off (like javascript). > > So, yes, the alert page does need to be visible to the client (unless we > have his phone number, I guess :-) but the timer should be server-side. > > thanks, > Chris Norloff > > -- Original Message -- > From: "Philip Arnold - ASP" <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Fri, 26 Jan 2001 16:34:05 - > > >> We have a need to alert a user if he's near the end of his 15 > >> min. session variable expiration. Unfortunately, they don't want > >> anything client-side [grumble, grumble ...] > >> > >> So - anybody know how to use CF, or maybe JSP or PHP to push an > >> alert window to a user when the session variables are near to expiring? > > > >Sorry, but if it's not client side, then how do they see the warning? > >Isn't a push-page or an alert window client side? > > > >Philip Arnold > >Director > >Certified ColdFusion Developer > >ASP Multimedia Limited > >T: +44 (0)20 8680 1133 > > > >"Websites for the real world" > > > >** > >This email and any files transmitted with it are confidential and > >intended solely for the use of the individual or entity to whom they > >are addressed. If you have received this email in error please notify > >the system manager. > >** > > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Noting Seeing Network Drive Properly
Guys, what you might want to check if you have all the rights, especially the registry ones, set up like described in the Allaire KB. This helped us to get it to work. The KB is: http://www.allaire.com/Handlers/index.cfm?ID=11859&Method=Full Stefan -Original Message- From: JayB [mailto:[EMAIL PROTECTED]] Sent: Monday, January 29, 2001 4:55 PM To: CF-Talk Subject: RE: CF Noting Seeing Network Drive Properly At 11:28 AM 1/29/2001 -0800, you wrote: >Aaron: > >Thanks for the suggestion. > >Right now it's set up to log on as the "local system account" and "allow >service to interact with desktop" is checked. > >For "This Account," If I try to add my account name and password, I get an >error that says I don't exist ... so I'm guessing this is the wrong account >to put here, but if so, I'm not sure what to put here. I asked this question a bunch of times on allaires forums getting vague answers but no real help... This is what I did to get this to get a mapped drive to workstep by step... Here's my set up win2k pro database on peer to peer lan with mapped drive x: CF Server 4.5.1 single user CFStudio 4.5.2 beta On machine where data resides, add a user called data_admin with administrator rights and give it a strong password(you might be able to have a lower permission level...but I couldn;t get it to work) On the machine where Server is running, log on as administrator Create a new user called data_admin with the same properties as that on the ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Push alert page to browser?
Yes, but HTTP works on request-response pairs, so how can the server send anything to the browser unless the browser requests it? If there *is* a way I'd be very interested to know it. I don't think it makes any difference whether you're using CF, JSP or whatever on the server - you've still got HTTP as the protocol in the middle. Nick -Original Message- From: Chris Norloff [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 2:37 PM To: CF-Talk Subject: RE: Push alert page to browser? ha ha! Well said. Specifically, the client wants to minimize required client-side functions that aren't in all browsers, and especially functions that can be turned off (like javascript). So, yes, the alert page does need to be visible to the client (unless we have his phone number, I guess :-) but the timer should be server-side. thanks, Chris Norloff -- Original Message -- From: "Philip Arnold - ASP" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Fri, 26 Jan 2001 16:34:05 - >> We have a need to alert a user if he's near the end of his 15 >> min. session variable expiration. Unfortunately, they don't want >> anything client-side [grumble, grumble ...] >> >> So - anybody know how to use CF, or maybe JSP or PHP to push an >> alert window to a user when the session variables are near to expiring? > >Sorry, but if it's not client side, then how do they see the warning? >Isn't a push-page or an alert window client side? > >Philip Arnold >Director >Certified ColdFusion Developer >ASP Multimedia Limited >T: +44 (0)20 8680 1133 > >"Websites for the real world" > >** >This email and any files transmitted with it are confidential and >intended solely for the use of the individual or entity to whom they >are addressed. If you have received this email in error please notify >the system manager. >** > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Push alert page to browser?
ha ha! Well said. Specifically, the client wants to minimize required client-side functions that aren't in all browsers, and especially functions that can be turned off (like javascript). So, yes, the alert page does need to be visible to the client (unless we have his phone number, I guess :-) but the timer should be server-side. thanks, Chris Norloff -- Original Message -- From: "Philip Arnold - ASP" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Fri, 26 Jan 2001 16:34:05 - >> We have a need to alert a user if he's near the end of his 15 >> min. session variable expiration. Unfortunately, they don't want >> anything client-side [grumble, grumble ...] >> >> So - anybody know how to use CF, or maybe JSP or PHP to push an >> alert window to a user when the session variables are near to expiring? > >Sorry, but if it's not client side, then how do they see the warning? >Isn't a push-page or an alert window client side? > >Philip Arnold >Director >Certified ColdFusion Developer >ASP Multimedia Limited >T: +44 (0)20 8680 1133 > >"Websites for the real world" > >** >This email and any files transmitted with it are confidential and >intended solely for the use of the individual or entity to whom they >are addressed. If you have received this email in error please notify >the system manager. >** > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Help needed with ODBC Excel datasource problems...
Hi all- Got a tricky one for ya. I have an Excel datasource that I need to import into an Access DB. I've been to www.cfcomet.com (excellent site, by the way...definitely visit for any issues with accessing MS Office Objects through CF) which gave me a start, but I've run into a problem I can't find addressed anywhere. When creating an ODBC datasource for Excel, you define how many rows to scan to allow CF to determine what the datatype of each field is. If you have column headings in your spreadsheet, then they are automatically used as field names when imported. I have set the number of rows to scan to 1, hoping to force the ODBC driver to use the column headings as the determining factor for data type determinination, and that didn't work. I figured maybe it was skipping the first row and reading the second, so I added "Do not alter this text" in every field in row two, again hoping to force the datatypes to strings. Didn't work. :( I have one particular field which, in some cases: a) is blank, b) has a number in it, or c) has multiple numbers, separated by spaces (ie. 3 5 2) For whatever reason, CF is importing this field as a number, converting the 3 to 3.0, and dropping the rest of the field. This has me stymied, because if I can't import this spreadsheet properly, then the project is going to die very quickly. Any ideas on how to force the datatype of the fields being imported to strings? Is there some SQL snytax that can define in the SELECT statement something like SELECT {fieldname} AS STRING FROM "Sheet1$"? Any help would be appreciated. Thanks... -Kev ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Push alert page to browser?
Thanks for your comments - it sounds like a good way to do it. I'd like to use javascript, but our client is trying to minimize client-side processes, especially ones that can be turned off. I'm looking at java server pages as a possible solution. thanks, Chris Norloff -- Original Message -- From: "Duane Boudreau" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Fri, 26 Jan 2001 11:31:57 -0500 >Haven't tried this but it might work: > >In you application.cfm write a JS function to the header using CFHTMLHead >that starts a JS timer. When the function reaches specified intervals popup >a window that notifies the user and gives them the option of closing the >window. If you call a CFM page in your popup it should "tickle" the session >alive so you would have to re-set the counter in the calling page. > >Let me know if this works, >Duane > > >-Original Message- >From: Chris Norloff [mailto:[EMAIL PROTECTED]] >Sent: Friday, January 26, 2001 11:21 AM >To: CF-Talk >Subject: Push alert page to browser? > > >We have a need to alert a user if he's near the end of his 15 min. session >variable expiration. Unfortunately, they don't want anything client-side >[grumble, grumble ...] > >So - anybody know how to use CF, or maybe JSP or PHP to push an alert window >to a user when the session variables are near to expiring? > >thx >Chris Norloff > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: String to Int
Strange! which version of Cold Fusion are you using? I have been using FormURL2Attributes.cfm for a while without any problems. Russel Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the bear; some days the bear eats you. > -Original Message- > From: Maia, Eric [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 30, 2001 17:07 > To: CF-Talk > Subject: RE: String to Int > > > I have had type errors related to Attributes. variables produced by > CF_FORMURL2ATTRIBUTES custom tag. I now use #Val(string_variable)# when I > know I'll need an integer (e.g. inserting into a numeric DB column). > > -Original Message- > From: Russel Madere [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 30, 2001 2:44 PM > To: CF-Talk > Subject: RE: String to Int > > > Actually, Cold Fusion does this automatically. Or more precisely, Cold > Fusion uses typeless variables. That way, you don't need to cast the type > for the variables. > > Russel > > > Russel Madere, Jr. Senior Web Developer > ICQ: 5446158 http://www.TurboSquid.com > > Some days you eat the bear; some days the bear eats you. > > > > > -Original Message- > > From: Richard Banks [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, January 30, 2001 15:53 > > To: CF-Talk > > Subject: String to Int > > > > > > is there a way [ie. a cf function ]to convert a string to an > > integer. let's > > say a user enters the string '1976' , and i want to process > that string as > > the integer 1976. > > any help would be greatly appreciated. thanks > > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF Noting Seeing Network Drive Properly
If you want to use a non-Admin user, there is some info here that might help: http://www.defusion.com/articles/index.cfm?ArticleID=89 -Original Message- From: JayB [mailto:[EMAIL PROTECTED]] Sent: Monday, January 29, 2001 4:55 PM To: CF-Talk Subject: RE: CF Noting Seeing Network Drive Properly At 11:28 AM 1/29/2001 -0800, you wrote: >Aaron: > >Thanks for the suggestion. > >Right now it's set up to log on as the "local system account" and "allow >service to interact with desktop" is checked. > >For "This Account," If I try to add my account name and password, I get an >error that says I don't exist ... so I'm guessing this is the wrong account >to put here, but if so, I'm not sure what to put here. I asked this question a bunch of times on allaires forums getting vague answers but no real help... This is what I did to get this to get a mapped drive to workstep by step... Here's my set up win2k pro database on peer to peer lan with mapped drive x: CF Server 4.5.1 single user CFStudio 4.5.2 beta On machine where data resides, add a user called data_admin with administrator rights and give it a strong password(you might be able to have a lower permission level...but I couldn;t get it to work) On the machine where Server is running, log on as administrator Create a new user called data_admin with the same properties as that on the ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: WEB based ad-hoc reporting tool
You can make a "real time" connection to oracle with access. Create a select-only user for the oracle schema, then in access, use file - get external data - type of odbc - set up a connection, and voila! Access front end for Oracle. -d Deanna Schneider Interactive Media Developer UWEX Cooperative Extension Electronic Publishing Group 103 Extension Bldg 432 N. Lake Street Madison, WI 53706 (608) 265-7923 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Inetinfo.exe crashing
The first thing I would try is to reformat the drive, reinstall Windows, the web server and cold fusion.. Inetinfo shouldn't crash no matter what you do to it. A lot of times there are .dll version conflicts that cause it. Do not put anything else on the server. Al a1webs.com At 10:36 PM 1/30/2001 -0500, dave fauth wrote: >I have a CF site (CF 4.5.1 sp1 enterprise) on NT 4 sp6a that is crashing >Inetinfo.exe more and more in the last week or so. Previously, it has been >running great. Any ideas on where to start looking or debugging to figure >this out. I'm assuming that proper locking would be one idea. I've had >bad luck on upgrading the dev server to 4.5.1 sp2 so that's why I'm still >at sp1. > >Any help would be greatly appreciated. > >thanks >dave >--- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Windows 2000 Professional and CF Server 4.0.1
> Allaire does not support anything less than cf4.5 on a WIN2K box. OK, thanks. -- Aidan Whitehall <[EMAIL PROTECTED]> Netshopper UK Ltd Advanced Web Solutions & Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Windows 2000 Professional and CF Server 4.0.1
Allaire does not support anything less than cf4.5 on a WIN2K box. Regards, Howie - Original Message - From: "Aidan Whitehall" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 31, 2001 7:20 AM Subject: Windows 2000 Professional and CF Server 4.0.1 > We're having problems installing CF Server 4.0.1 onto a Windows 2000 > Professional box using IIS5 and FAT. ColdFusion Server seems to install OK, > but it doesn't register as a service. Consequently it won't run. > > If you uninstall CF Server, it says that it's stopping ColdFusion services. > > Has anyone experienced this and is there any workaround to enable you to > install CF 4.0.1? > > > > Thanks > > -- > Aidan Whitehall <[EMAIL PROTECTED]> > Netshopper UK Ltd > Advanced Web Solutions & Services > > http://www.netshopperuk.com/ > Telephone +44 (01744) 648650 > Fax +44 (01744) 648651 > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Windows 2000 Professional and CF Server 4.0.1
Why FAT? Dave Adams CFUG Ottawa - Original Message - From: Aidan Whitehall <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Sent: Wednesday, January 31, 2001 7:20 AM Subject: Windows 2000 Professional and CF Server 4.0.1 > We're having problems installing CF Server 4.0.1 onto a Windows 2000 > Professional box using IIS5 and FAT. ColdFusion Server seems to install OK, > but it doesn't register as a service. Consequently it won't run. > > If you uninstall CF Server, it says that it's stopping ColdFusion services. > > Has anyone experienced this and is there any workaround to enable you to > install CF 4.0.1? > > > > Thanks > > -- > Aidan Whitehall <[EMAIL PROTECTED]> > Netshopper UK Ltd > Advanced Web Solutions & Services > > http://www.netshopperuk.com/ > Telephone +44 (01744) 648650 > Fax +44 (01744) 648651 > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Statistics on Toy R Us
I've never done Perl or Mason, but I can say without a doubt this is not true about PHP and ASP. They do not leave whitespace around at all... I've seen some real bad examples of both, and nope, there just ain't lines after lines of whitespace. >Perl (if badly written), PHP (if badly written), ASP (if badly written), CF >(if badly written), Mason (if badly written), and everything else under the >sun (if it's badly written). CF, however is a bit more interesting... ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFOBJECT and CF Administration
I changed the CF server admin's java setting. Added JVM.DLL to the JVM path, and also added my jar file to the class path. It works fine on my machine. Logged in to a remote host, did the same, but I get the error: Failed to create JavaVM. JNI_CreateJavaVM returned error code JNI_ERR (this may indicate an unrecognized option string) Any help will be greatly appreciated. laszlo ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: PDF with CF newbie question
not if you use UNIX or Linux! These have free tools to convert to pdf, ps, dvi, etc... From: [EMAIL PROTECTED] AT INTERNET on 01/30/2001 10:24 PM To: [EMAIL PROTECTED] AT INTERNET@CCMAIL cc:(bcc: Douglas Knudsen/ATL/ALLTELCORP) Subject: Re: PDF with CF newbie question At least the "shall we say , free one downloadable from " Adobes site "Milks, Jim" <[EMAIL PROTECTED]> wrote in message 0160C6B4BB54D41182AB0001024294B0068318@EXCHANGE">news:0160C6B4BB54D41182AB0001024294B0068318@EXCHANGE... > I can safely assume that the custom tags which generate PDFs still require > the full-blown acrobat, correct? > > Jim > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL Stored Procedure Syntax help
Try something like this: Create Procedure UserCheck @Entry int @Return int AS IF @Entry = 1 Begin Update Users Set 1 = @Return Where ID = 1 End Else IF @Entry = 2 Begin Update Users Set 2 = @Return Where ID = 1 End and then to call the procedure in CF: execute UserCheck @Entry = #entry#,@Return = #return# HTH -- Clint Tredway www.factorxsoftware.com -- ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Coldfusion vs. Jsp
err.. I think he meant neither one is better. Each one has it's strengths and weaknesses. You should pick the one that is weak where don't need functionality, and strong where you do. More often, however, you pick the one someone (probably in management) paid for. Michael wrote: > So do you mean jsp pages are better then cfm pages? > > "Rey Bango" <[EMAIL PROTECTED]> wrote in message > 007101c08a3d$9e1cce60$0d0b320a@RBango">news:007101c08a3d$9e1cce60$0d0b320a@RBango... > > >> who branded Jsp? << > > > > Sun Microsystems. > > > > >> and which is better? << > > > > The one that allows you to provide the best & most comprehensive solution > > for your client or employer. Not being sarcastic. Just honest. > > > > Rey > > Team Allaire > > > > > > > > - Original Message - > > From: "Phoeun Pha" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Monday, January 29, 2001 3:39 PM > > Subject: Coldfusion vs. Jsp > > > > > > > who branded Jsp? and which is better? > > > > > > > > > > > > > > > -Original Message- > > > From: John Stanley [mailto:[EMAIL PROTECTED]] > > > Sent: Monday, January 29, 2001 1:40 PM > > > To: CF-Talk > > > Subject: White Space -- Solution > > > > > > > > > Again, as soon as I send the e-mail out; I figuire it out... > > > > > > I just needed to concatanate a variable with each segment of the output > > and > > > then display the end result as such: > > > > > > 1000129200119 > > > > > > CODE SNIPPET>>> > > > > > > > > > > > > > > > > > > > > > > > > > > len(check_billing.countycode))> > > > > > to="#county_difference#"> > > > > > > > > > > > "#check_billing.countycode#"> > > > > > > > > "#check_billing.countycode#"> > > > > > > > > > > > "#DateFormat(currentsharecaredatetime, 'mmdd')#"> > > > > > > > > > > > len(get_affected_records.recordcount))> > > > > > to="#record_difference#"> > > > > > > > > > > > "#get_affected_records.recordcount#"> > > > > > 6> > > > > > "#get_affected_records.recordcount#"> > > > > > 6> > > > > > > > > > > > > #batch# > > > > > > > > > Thanks anyway guys > > > > > > John Stanley > > > > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: CFID and CFTOKEN, client variables, hidden form fields
Thanks to all those who helped. Allaire's docs do seem a little ambiguous when they say that CFID and CFTOKEN can be passed as hidden form fields - I now see that URLTOKEN can be passed as a URL variable to the action page that your form submits to. Interesting post on this at http://forums.allaire.com/DevConf/Thread.cfm?&&Message_ID=308908&_#Message385663 I also tried the following technique: if (IsDefined("Form.CFID") AND IsDefined("Form.CFTOKEN")) { url.cfid=form.cfid; url.cftoken=form.cftoken; } which I found at http://forums.allaire.com/DevConf/Thread.cfm?&&Message_ID=569454&_#Message569454, with no success. Anyone else tried this technique and succeeded? A similar sort of thing is described at http://forums.allaire.com/DevConf/Thread.cfm?&&Message_ID=336048&_#Message336048. In the end, we have decided to use CFID and CFTOKEN on the URL, together with randomly generated hidden form fields as a further means of identification. Pete > -Original Message- > From: Peter Lutwyche [mailto:[EMAIL PROTECTED]] > Sent: Friday, 26 January 2001 12:27 > To: CF-Talk > Subject: CFID and CFTOKEN, client variables, hidden form fields > > > Apologies if this one has been asked before, but I couldn't find > an answer in the archives. > > I would like to maintain state using Client (or Session) > variables but do not want to use cookies. I know I am therefore > reliant on the CFID and CFTOKEN being passed from page to page. > What I would like to do is pass CFID and CFTOKEN as hidden form > fields, rather than as URL variables. So far I have been able to > create my forms containing a hidden CFID and CFTOKEN, but on > submission of the form I'm unable to access any Client (or > Session) variables using the ID and TOKEN. Has anyone managed to > achieve this, and if so, would you be able to post a snippet of code? > > Cheers > Pete Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts
Windows 2000 Professional and CF Server 4.0.1
We're having problems installing CF Server 4.0.1 onto a Windows 2000 Professional box using IIS5 and FAT. ColdFusion Server seems to install OK, but it doesn't register as a service. Consequently it won't run. If you uninstall CF Server, it says that it's stopping ColdFusion services. Has anyone experienced this and is there any workaround to enable you to install CF 4.0.1? Thanks -- Aidan Whitehall <[EMAIL PROTECTED]> Netshopper UK Ltd Advanced Web Solutions & Services http://www.netshopperuk.com/ Telephone +44 (01744) 648650 Fax +44 (01744) 648651 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: excel - access - sql?
a) Yes b) Yes > -Original Message- > From: Jay Patton [mailto:[EMAIL PROTECTED]] > Sent: 31 January 2001 00:08 > To: CF-Talk > Subject: excel - access - sql? > > > if anyone can help me on this i would appreciate it > i was wondering: > > A. i could convert an excel file to sql > > B. i could convert an excel file to access (if at all) then to sql? > > > Thanks much :) > > Jay Patton > Web Pro USA > 406.549.3337 ext. 203 > 1.888.5WEBPRO > www.webpro-usa.com > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: excel - access - sql?
A. Yes, but only indirectly.. you can create an SQL DB and then import data from the Excel file. Never tried it myself, though. B. Ditto You can create the Access DB, import data from Excel, then use the Access upsizing wizard to upsize it to SQL -Original Message- From: Jay Patton [mailto:[EMAIL PROTECTED]] Sent: 31 January 2001 00:08 To: CF-Talk Subject: excel - access - sql? if anyone can help me on this i would appreciate it i was wondering: A. i could convert an excel file to sql B. i could convert an excel file to access (if at all) then to sql? Thanks much :) Jay Patton Web Pro USA 406.549.3337 ext. 203 1.888.5WEBPRO www.webpro-usa.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Coldfusion vs. Jsp
So do you mean jsp pages are better then cfm pages? "Rey Bango" <[EMAIL PROTECTED]> wrote in message 007101c08a3d$9e1cce60$0d0b320a@RBango">news:007101c08a3d$9e1cce60$0d0b320a@RBango... > >> who branded Jsp? << > > Sun Microsystems. > > >> and which is better? << > > The one that allows you to provide the best & most comprehensive solution > for your client or employer. Not being sarcastic. Just honest. > > Rey > Team Allaire > > > > - Original Message - > From: "Phoeun Pha" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, January 29, 2001 3:39 PM > Subject: Coldfusion vs. Jsp > > > > who branded Jsp? and which is better? > > > > > > > > > > -Original Message- > > From: John Stanley [mailto:[EMAIL PROTECTED]] > > Sent: Monday, January 29, 2001 1:40 PM > > To: CF-Talk > > Subject: White Space -- Solution > > > > > > Again, as soon as I send the e-mail out; I figuire it out... > > > > I just needed to concatanate a variable with each segment of the output > and > > then display the end result as such: > > > > 1000129200119 > > > > CODE SNIPPET>>> > > > > > > > > > > > > > > > > > len(check_billing.countycode))> > > > to="#county_difference#"> > > > > > > > "#check_billing.countycode#"> > > > > > "#check_billing.countycode#"> > > > > > > > "#DateFormat(currentsharecaredatetime, 'mmdd')#"> > > > > > > > len(get_affected_records.recordcount))> > > > to="#record_difference#"> > > > > > > > "#get_affected_records.recordcount#"> > > > 6> > > > "#get_affected_records.recordcount#"> > > > 6> > > > > > > > > #batch# > > > > > > Thanks anyway guys > > > > John Stanley > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Harpoon Beta
As of late yesterday the site was down, but I am sure it will be back up ASAP, its an addon persay for flash, pretty nice I think "Alex Aguilar" <[EMAIL PROTECTED]> wrote in message 008a01c08ad3$fe5f87e0$11c9140a@ALEXANDERA">news:008a01c08ad3$fe5f87e0$11c9140a@ALEXANDERA... > Basically its a set of GUI tools built using Flash5 and CF. They include: > - calculator > - calendar > - menus > - grid > - tree > > I believe there's a couple more but don't remember them. > > I saw a demo of it last week at the Atlanta CFUG by Steve Drucker (CEO, > FigLeaf) and was actually quite impressed. You can't beat the price - FREE! > Anybody, going to CFSouth will probably see a similar presentation. > > - Original Message - > From: "Milks, Jim" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, January 30, 2001 8:49 AM > Subject: RE: Harpoon Beta > > > > What is harpoon anyway? > > > > -Original Message- > > From: Duane Boudreau [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, January 30, 2001 1:10 AM > > To: CF-Talk > > Subject: Harpoon Beta > > > > > > Has anyone here been able to get to the Harpoon beta yet? > > > > Thx, > > Duane Boudreau, CTO > > CFExperts > > 603.620.8797 > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Statistics on Toy R Us
> > Apparently the removewhitespace setting only applies to > > whitespace internal to tags > > e.g. > > > > datasource="dsn" > > dbtype="odbc"> > > I know this is a dumb question, but WHAT F***ING USE IS THAT? The internal CRs do bleed into the generated text so the all new super snazzy removewhitespace does actually remove _some_ whitespace. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
excel - access - sql?
if anyone can help me on this i would appreciate it i was wondering: A. i could convert an excel file to sql B. i could convert an excel file to access (if at all) then to sql? Thanks much :) Jay Patton Web Pro USA 406.549.3337 ext. 203 1.888.5WEBPRO www.webpro-usa.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Strange Administration Error
Hi all! In CF Administrator i tried to delete a client variable storage entry from the Variables menu but i keep getting a CRegistryException error message. Anybody got this error before? Could that have anything to do with the fact that i deleted the CDATA and CGLOBAL tables manually from the datasource itself beforehand? Tia Paco Montes Spain on Line ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Email Mail Out Application
I am trying to purchase mail shot software that allows html mail shots and can be totally managed in house. Does anyone know any good ones? Paul Burgess ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Statistics on Toy R Us
Too true, and that not what the option says on the Server, or at least it gives the impression that it removes all extraneous whitespace from the template. Probably an undisclosed feature Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: 31 January 2001 11:04 To: CF-Talk Subject: RE: Statistics on Toy R Us > Apparently the removewhitespace setting only applies to > whitespace internal to tags > e.g. > > datasource="dsn" > dbtype="odbc"> I know this is a dumb question, but WHAT F***ING USE IS THAT? Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Statistics on Toy R Us
> Apparently the removewhitespace setting only applies to > whitespace internal to tags > e.g. > > datasource="dsn" > dbtype="odbc"> I know this is a dumb question, but WHAT F***ING USE IS THAT? Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Statistics on Toy R Us
Have you got ? -Original Message- From: Steve Martin [mailto:[EMAIL PROTECTED]] Sent: 31 January 2001 10:52 To: CF-Talk Subject: RE: Statistics on Toy R Us Apparently the removewhitespace setting only applies to whitespace internal to tags e.g. datasource="dsn" dbtype="odbc"> > -Original Message- > From: Jason Lees (National Express) > [mailto:[EMAIL PROTECTED]] > Sent: 31 January 2001 10:34 > To: CF-Talk > Subject: RE: Statistics on Toy R Us > > > > I've got the remove whitespace setting applied on CF server and it doesn't > seem to make any difference to the size of the completed template, I still > get pages that are filled with whitespace. > > The only way I found to get rid of some, was to put CF comments in, this > reduces the Tabed indents to a single CRLF, but theres a trade > off, parsing > speed against page size. In testing I've found that it reduces pages by > upto 20% (depending on the page layout). > > Jason Lees > National Express > Email : [EMAIL PROTECTED] > > > -Original Message- > From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] > Sent: 31 January 2001 10:13 > To: CF-Talk > Subject: RE: Statistics on Toy R Us > > > > The point about CF is that it uses the approach of "Anything > written in CF > > changes to whitespace when processed" as a default, instead of > treating CF > > as a programming language and compiling etc (prepare to flame me...). > > That's what produces the whitespace. This can of course be > > turned off, and > > can mean faster page loading. The CFML processor is effectively only a > > parser (a fast one, but still a parser) so any other language > > that is parsed like this will produce similar output. > > Just as a point on this - removing white-space only reduces the > time that it > takes to send the template to the user - using CFSETTING a lot > will actually > slow the server down (slightly) > > It's therefore a payoff as to whether you want the pages to be > built faster > or sent to the user faster - remembering that if you can turn more pages > around on the server, then you can serve more visitors - people > are willing > to wait an extra second or so, but if you've got a busy site, then you've > got to weigh up which one you prefer... > > You get what I mean :-/ > > Philip Arnold > Director > Certified ColdFusion Developer > ASP Multimedia Limited > T: +44 (0)20 8680 1133 > > "Websites for the real world" > > ** > This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they > are addressed. If you have received this email in error please notify > the system manager. > ** > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Statistics on Toy R Us
> I've got the remove whitespace setting applied on CF server and it doesn't > seem to make any difference to the size of the completed template, I still > get pages that are filled with whitespace. > > The only way I found to get rid of some, was to put CF comments in, this > reduces the Tabed indents to a single CRLF, but theres a trade > off, parsing > speed against page size. In testing I've found that it reduces pages by > upto 20% (depending on the page layout). If you want to remove whitespace form non-display areas of the template, either build the code in CFScript or use CFSetting Using CFSetting does add some overhead to the template build time... but not much... You can theoretically build a white-space-less template, but it takes a LOT of work... I'm not that worried if my output has a row of returns every now and again, it only adds slightly to the total page size... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Database site
you mean Adam Churvis' commerce blocks? www.commerceblocks.com or maybe DbArtisan? http://www.embarcadero.com/products/administer/administer.htm - Original Message - From: "Robert Everland III" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, January 30, 2001 6:02 PM Subject: Database site > Someone listed a good database developer site here a little bit ago and I > can't find it in the archives. > > > Bob Everland > > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Statistics on Toy R Us
Apparently the removewhitespace setting only applies to whitespace internal to tags e.g. datasource="dsn" dbtype="odbc"> > -Original Message- > From: Jason Lees (National Express) > [mailto:[EMAIL PROTECTED]] > Sent: 31 January 2001 10:34 > To: CF-Talk > Subject: RE: Statistics on Toy R Us > > > > I've got the remove whitespace setting applied on CF server and it doesn't > seem to make any difference to the size of the completed template, I still > get pages that are filled with whitespace. > > The only way I found to get rid of some, was to put CF comments in, this > reduces the Tabed indents to a single CRLF, but theres a trade > off, parsing > speed against page size. In testing I've found that it reduces pages by > upto 20% (depending on the page layout). > > Jason Lees > National Express > Email : [EMAIL PROTECTED] > > > -Original Message- > From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] > Sent: 31 January 2001 10:13 > To: CF-Talk > Subject: RE: Statistics on Toy R Us > > > > The point about CF is that it uses the approach of "Anything > written in CF > > changes to whitespace when processed" as a default, instead of > treating CF > > as a programming language and compiling etc (prepare to flame me...). > > That's what produces the whitespace. This can of course be > > turned off, and > > can mean faster page loading. The CFML processor is effectively only a > > parser (a fast one, but still a parser) so any other language > > that is parsed like this will produce similar output. > > Just as a point on this - removing white-space only reduces the > time that it > takes to send the template to the user - using CFSETTING a lot > will actually > slow the server down (slightly) > > It's therefore a payoff as to whether you want the pages to be > built faster > or sent to the user faster - remembering that if you can turn more pages > around on the server, then you can serve more visitors - people > are willing > to wait an extra second or so, but if you've got a busy site, then you've > got to weigh up which one you prefer... > > You get what I mean :-/ > > Philip Arnold > Director > Certified ColdFusion Developer > ASP Multimedia Limited > T: +44 (0)20 8680 1133 > > "Websites for the real world" > > ** > This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they > are addressed. If you have received this email in error please notify > the system manager. > ** > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Email app!
Get those bosses to buy it for you. You wont regret it. jon - Original Message - From: "Dusty Tinashe Shoko" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 31, 2001 5:14 AM Subject: RE: Email app! > Is there an online copy of Ben Forta's book? > I dont think I have seen it! > > *** > Dusty Tinashe Shoko > Web Applications Developer > SARDC http://www.sardc.net > 13 Bath Rd Belgravia > Phone: 738694/5/6 > *** > > > * -Original Message- > * From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] > * Sent: Wednesday, January 31, 2001 11:52 AM > * To: CF-Talk > * Subject: RE: Email app! > * > * > * If not, you can write your own in amazingly few lines > * of code using CFPOP and CFMAIL. > * > * There is some example code in Ben Forta's book. > * > * Nick > * > * -Original Message- > * From: Dusty Tinashe Shoko [mailto:[EMAIL PROTECTED]] > * Sent: Wednesday, January 31, 2001 9:24 AM > * To: CF-Talk > * Subject: Email app! > * > * > * Hi there I was wondering if there is already a free email (web based like > * yahoo or hotmail) appl that has been written in CF or any other lang like > * Java etc > * Bossess need to access their email when away from the office! > * > * *** > * Dusty Tinashe Shoko > * Web Applications Developer > * SARDC http://www.sardc.net > * 13 Bath Rd Belgravia > * Phone: 738694/5/6 > * *** > * > * > * ** > * Information in this email is confidential and may be privileged. > * It is intended for the addressee only. If you have received it in error, > * please notify the sender immediately and delete it from your system. > * You should not otherwise copy it, retransmit it or use or disclose its > * contents to anyone. > * Thank you for your co-operation. > * ** > * > * > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Statistics on Toy R Us
I've got the remove whitespace setting applied on CF server and it doesn't seem to make any difference to the size of the completed template, I still get pages that are filled with whitespace. The only way I found to get rid of some, was to put CF comments in, this reduces the Tabed indents to a single CRLF, but theres a trade off, parsing speed against page size. In testing I've found that it reduces pages by upto 20% (depending on the page layout). Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: 31 January 2001 10:13 To: CF-Talk Subject: RE: Statistics on Toy R Us > The point about CF is that it uses the approach of "Anything written in CF > changes to whitespace when processed" as a default, instead of treating CF > as a programming language and compiling etc (prepare to flame me...). > That's what produces the whitespace. This can of course be > turned off, and > can mean faster page loading. The CFML processor is effectively only a > parser (a fast one, but still a parser) so any other language > that is parsed like this will produce similar output. Just as a point on this - removing white-space only reduces the time that it takes to send the template to the user - using CFSETTING a lot will actually slow the server down (slightly) It's therefore a payoff as to whether you want the pages to be built faster or sent to the user faster - remembering that if you can turn more pages around on the server, then you can serve more visitors - people are willing to wait an extra second or so, but if you've got a busy site, then you've got to weigh up which one you prefer... You get what I mean :-/ Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL Stored Procedure Syntax help
I am not a sql guru but check out http://www.4guysfromrolla.com/webtech/010600-1.shtml There is a lot of asp examples, but the sql stuff is great. Below is a code example I grabbed from their site. The if exists() tests to see if a record has been returned. If it has, The sp returns a 1, if not it returns 0. The else could be a query or variable declaration or whatever... CREATE PROCEDURE sp_IsValidLogon @UserName varchar(16), @Password varchar(16) As if exists(Select * From Users Where UserName = @UserName And Password = @Password) return(1) else return(0) Go For anyone interested (I know your out there... ), the above is equivalent to checking a login and password in your cfquery then checking if the recordcount is greater than 0 and logging the user in if so. With this code: SELECT Username, Password FROM Users WHERE Username = '#username#' AND Password = '#password#' User Exists New User So how would one call the SP and why? How first... First I added a table called user into the stock NorthWind database that comes with SQL Server with two columns (username,password) and added one record with the username as "test" and the password as "test". Then I added the SP into sql server with a quick cut & paste. Finally below is the code that does exactly the same thing as the above CF code. User Exists New User Why would one do it with an SP? No code hunting if you change a db field later on, just change the stored procedure and any cf page using it will go on without one change. Keeping your queries in one place is nice too. Who cares though, it's speed that matter right? How about performace? Well this one surprised me. The is quite a bit faster with one record in the db! In very unscientific tests, I looped each bit of code 1000 times and the cfquery came in consistently around 1500 ms and the cfstoredproc came in at around 2000 ms. Ok, I said, there must be a reason. So I decided to add more records. I added 88 more records, which consisted of me alternating between banging on the keyboard and hitting tab 176 times into the table to approximate average internet users ;-) Quite fun... Any way, with 89 records the cfstoredproc barely budged, maybe up a few ms on average. The cfquery however now averages 1750ms! Well more banging ensued. Now I have 463 users. cfstored proc is hanging is there not budging a ms, it's still at 2000 or so, but the cfquery page is now at 2700ms. Aha! Speed... Well, I still wasn't satisfied. So I deleted the user "test" record so that neither query would return any results. Guess what? The cfquery stuck to it's guns going up a little to 2900ms this time, but cfstoredproc skyrocketed to an average 3400ms. I then inserted the test user back into the table as the last record. Nothing changed. Inserting the test user back to the first record and the speed record goes back to cfstoredproc. I suspect the reason behind this is the way I am determining if the record exists. If the sp only returned a recordset it would probably be faster in both cases, but since this post started out with demonstrating an if in SQL (2.5 Mountain Dews ago), I'm not going to verify it now. Perhaps someone in the know could enlighten me? Generally though, the more complex a query and the more records it returns, the larger the performance gain with stored procedures... As pud would say... Rock on jon - Original Message - From: "Robert Everland III" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, January 30, 2001 6:43 PM Subject: OT: SQL Stored Procedure Syntax help > Ok basically what I am doing is passing a variable to a stored procedure. > This variable is a number, based on the number it updates a record. What > field is updated depends on what variable is passed. How would I go about > doing this. I have filled in the variable for testing purposes. > > declare @return int > declare @entry int > exec @return = addaverage > @entry = 1 > > Update Users > Set [@entry] = @return > where id = 1 > > should do this > Update Users > Set [1] = @return > where id = 1 > but of course it doesn't do this. Is there a way to do ifs in there. I am > new at this whole stored procedure thing, but I am expecting a huge traffic > site and want to take away as much as possible with processing on CF. > > > Bob Everland > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Email app!
> Is there an online copy of Ben Forta's book? Don't think so. Check out http://www.forta.com Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Email app!
sure Mike do so! *** Dusty Tinashe Shoko Web Applications Developer SARDC http://www.sardc.net 13 Bath Rd Belgravia Phone: 738694/5/6 *** * -Original Message- * From: Mike Townend [mailto:[EMAIL PROTECTED]] * Sent: Wednesday, January 31, 2001 12:23 PM * To: CF-Talk * Subject: RE: Email app! * * * * * If you are interested... am writing small email app that can send you off * list to have a look at... not finished but should give you the idea * * HTH * * Mike * * -Original Message- * From: Dusty Tinashe Shoko [mailto:[EMAIL PROTECTED]] * Sent: Wednesday, January 31, 2001 10:14 * To: CF-Talk * Subject: RE: Email app! * * * Is there an online copy of Ben Forta's book? * I dont think I have seen it! * * *** * Dusty Tinashe Shoko * Web Applications Developer * SARDC http://www.sardc.net * 13 Bath Rd Belgravia * Phone: 738694/5/6 * *** * * * * -Original Message- * * From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] * * Sent: Wednesday, January 31, 2001 11:52 AM * * To: CF-Talk * * Subject: RE: Email app! * * * * * * If not, you can write your own in amazingly few lines * * of code using CFPOP and CFMAIL. * * * * There is some example code in Ben Forta's book. * * * * Nick * * * * -Original Message- * * From: Dusty Tinashe Shoko [mailto:[EMAIL PROTECTED]] * * Sent: Wednesday, January 31, 2001 9:24 AM * * To: CF-Talk * * Subject: Email app! * * * * * * Hi there I was wondering if there is already a free email (web * based like * * yahoo or hotmail) appl that has been written in CF or any other * lang like * * Java etc * * Bossess need to access their email when away from the office! * * * * *** * * Dusty Tinashe Shoko * * Web Applications Developer * * SARDC http://www.sardc.net * * 13 Bath Rd Belgravia * * Phone: 738694/5/6 * * *** * * * * * * ** * * Information in this email is confidential and may be privileged. * * It is intended for the addressee only. If you have received it in error, * * please notify the sender immediately and delete it from your system. * * You should not otherwise copy it, retransmit it or use or disclose its * * contents to anyone. * * Thank you for your co-operation. * * ** * * * * * ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Email app!
> Is there an online copy of Ben Forta's book? > I dont think I have seen it! http://www.forta.com/books/ They're several inches thick, do I don't think you'd want to download and print, and Ben wouldn't get the profits either CFWACK is a must for most "learning" CFers ACFAD is useful for more advanced tasks Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Email app!
If you are interested... am writing small email app that can send you off list to have a look at... not finished but should give you the idea HTH Mike -Original Message- From: Dusty Tinashe Shoko [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 31, 2001 10:14 To: CF-Talk Subject: RE: Email app! Is there an online copy of Ben Forta's book? I dont think I have seen it! *** Dusty Tinashe Shoko Web Applications Developer SARDC http://www.sardc.net 13 Bath Rd Belgravia Phone: 738694/5/6 *** * -Original Message- * From: DeVoil, Nick [mailto:[EMAIL PROTECTED]] * Sent: Wednesday, January 31, 2001 11:52 AM * To: CF-Talk * Subject: RE: Email app! * * * If not, you can write your own in amazingly few lines * of code using CFPOP and CFMAIL. * * There is some example code in Ben Forta's book. * * Nick * * -Original Message- * From: Dusty Tinashe Shoko [mailto:[EMAIL PROTECTED]] * Sent: Wednesday, January 31, 2001 9:24 AM * To: CF-Talk * Subject: Email app! * * * Hi there I was wondering if there is already a free email (web based like * yahoo or hotmail) appl that has been written in CF or any other lang like * Java etc * Bossess need to access their email when away from the office! * * *** * Dusty Tinashe Shoko * Web Applications Developer * SARDC http://www.sardc.net * 13 Bath Rd Belgravia * Phone: 738694/5/6 * *** * * * ** * Information in this email is confidential and may be privileged. * It is intended for the addressee only. If you have received it in error, * please notify the sender immediately and delete it from your system. * You should not otherwise copy it, retransmit it or use or disclose its * contents to anyone. * Thank you for your co-operation. * ** * * ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists