Re: CFOUTPUT question
Hi Bill, >even with > > > > #ucase(name)# > > > > > >it still screws up half the time You are using the same variable "name" twice over, one is part of the name of the query, which should be fixed, the second is part of the result set, which is not. You should evaluate the query's name first and put scoping in at least so it could look like: 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
FIXED
ok the problem was due to having a Space in the CFOUTPUT query="asdf basd" thats very weird that in a CFQUERY you can name it with a space but now a cfoutput query. Maybe they will fix that error in later versions Thx Bill Wheatley Director of Development Allaire Certified ColdFusion Developer AEPS INC Allaire ColdFusion Consulting Partner www.aeps.com www.aeps2000.com 954-472-6684 X303 ICQ: 417645 - Original Message - From: "William Wheatley" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, April 08, 2001 12:39 AM Subject: Re: CFOUTPUT question > lol i meant it screws up all the time =) even though thats the name of the > query > > > Bill Wheatley > Director of Development > Allaire Certified ColdFusion Developer > AEPS INC > Allaire ColdFusion Consulting Partner > www.aeps.com > www.aeps2000.com > 954-472-6684 X303 > ICQ: 417645 > > > > - Original Message - > From: "William Wheatley" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Sunday, April 08, 2001 12:33 AM > Subject: Re: CFOUTPUT question > > > > even with > > > > > > > > #ucase(name)# > > > > > > > > > > > > it still screws up half the time > > > > > > Bill Wheatley > > Director of Development > > Allaire Certified ColdFusion Developer > > AEPS INC > > Allaire ColdFusion Consulting Partner > > www.aeps.com > > www.aeps2000.com > > 954-472-6684 X303 > > ICQ: 417645 > > > > > > > > - Original Message - > > From: "Clint Tredway" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Sunday, April 08, 2001 12:14 AM > > Subject: Re: CFOUTPUT question > > > > > > > try using the same variable to name the query as you are for naming the > > output. I have done this before where my query name was "lu#table#" and my > > cfoutput was named the same ie: name="lu#table#". > > > > > > HTH > > > > > > -- Original Message -- > > > From: "William Wheatley" <[EMAIL PROTECTED]> > > > Reply-To: [EMAIL PROTECTED] > > > Date: Sun, 08 Apr 2001 00:03:42 -0400 > > > > > > Anyone know a way to use a dynamic variable inside of a CFOUTPUT? > > > > > > > > > > > > > > > #ucase(name)# > > > > > > > > > > > > > > I tried using EVALUate() and playing aroudn with a few different ways > but > > its being a pain. > > > > > > =) > > > > > > Thx > > > > > > > > > Bill Wheatley > > > Director of Development > > > Allaire Certified ColdFusion Developer > > > AEPS INC > > > Allaire ColdFusion Consulting Partner > > > www.aeps.com > > > www.aeps2000.com > > > 954-472-6684 X303 > > > ICQ: 417645 > > > > > > ~~ 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
Another CFOUTPUT questions
Another question this seems ODD you can do a CFQUERY and have the name be cfquery name="flight attendant" with a space but when you go and do a Loop error >The QUERY= attribute of a tag specifies the query 'qgetflight attendant'. A query by this >name is not available at this point in the template. The likely cause of this error is a >misspelling of the query name. So that is odd that you cant have a space in there Bill Wheatley Director of Development Allaire Certified ColdFusion Developer AEPS INC Allaire ColdFusion Consulting Partner www.aeps.com www.aeps2000.com 954-472-6684 X303 ICQ: 417645 - Original Message - From: "William Wheatley" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, April 08, 2001 12:39 AM Subject: Re: CFOUTPUT question > lol i meant it screws up all the time =) even though thats the name of the > query > > > Bill Wheatley > Director of Development > Allaire Certified ColdFusion Developer > AEPS INC > Allaire ColdFusion Consulting Partner > www.aeps.com > www.aeps2000.com > 954-472-6684 X303 > ICQ: 417645 > > > > - Original Message - > From: "William Wheatley" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Sunday, April 08, 2001 12:33 AM > Subject: Re: CFOUTPUT question > > > > even with > > > > > > > > #ucase(name)# > > > > > > > > > > > > it still screws up half the time > > > > > > Bill Wheatley > > Director of Development > > Allaire Certified ColdFusion Developer > > AEPS INC > > Allaire ColdFusion Consulting Partner > > www.aeps.com > > www.aeps2000.com > > 954-472-6684 X303 > > ICQ: 417645 > > > > > > > > - Original Message - > > From: "Clint Tredway" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Sunday, April 08, 2001 12:14 AM > > Subject: Re: CFOUTPUT question > > > > > > > try using the same variable to name the query as you are for naming the > > output. I have done this before where my query name was "lu#table#" and my > > cfoutput was named the same ie: name="lu#table#". > > > > > > HTH > > > > > > -- Original Message -- > > > From: "William Wheatley" <[EMAIL PROTECTED]> > > > Reply-To: [EMAIL PROTECTED] > > > Date: Sun, 08 Apr 2001 00:03:42 -0400 > > > > > > Anyone know a way to use a dynamic variable inside of a CFOUTPUT? > > > > > > > > > > > > > > > #ucase(name)# > > > > > > > > > > > > > > I tried using EVALUate() and playing aroudn with a few different ways > but > > its being a pain. > > > > > > =) > > > > > > Thx > > > > > > > > > Bill Wheatley > > > Director of Development > > > Allaire Certified ColdFusion Developer > > > AEPS INC > > > Allaire ColdFusion Consulting Partner > > > www.aeps.com > > > www.aeps2000.com > > > 954-472-6684 X303 > > > ICQ: 417645 > > > > > > ~~ 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: CFOUTPUT question
lol i meant it screws up all the time =) even though thats the name of the query Bill Wheatley Director of Development Allaire Certified ColdFusion Developer AEPS INC Allaire ColdFusion Consulting Partner www.aeps.com www.aeps2000.com 954-472-6684 X303 ICQ: 417645 - Original Message - From: "William Wheatley" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, April 08, 2001 12:33 AM Subject: Re: CFOUTPUT question > even with > > > > #ucase(name)# > > > > > > it still screws up half the time > > > Bill Wheatley > Director of Development > Allaire Certified ColdFusion Developer > AEPS INC > Allaire ColdFusion Consulting Partner > www.aeps.com > www.aeps2000.com > 954-472-6684 X303 > ICQ: 417645 > > > > - Original Message - > From: "Clint Tredway" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Sunday, April 08, 2001 12:14 AM > Subject: Re: CFOUTPUT question > > > > try using the same variable to name the query as you are for naming the > output. I have done this before where my query name was "lu#table#" and my > cfoutput was named the same ie: name="lu#table#". > > > > HTH > > > > -- Original Message -- > > From: "William Wheatley" <[EMAIL PROTECTED]> > > Reply-To: [EMAIL PROTECTED] > > Date: Sun, 08 Apr 2001 00:03:42 -0400 > > > > Anyone know a way to use a dynamic variable inside of a CFOUTPUT? > > > > > > > > > > #ucase(name)# > > > > > > > > > I tried using EVALUate() and playing aroudn with a few different ways but > its being a pain. > > > > =) > > > > Thx > > > > > > Bill Wheatley > > Director of Development > > Allaire Certified ColdFusion Developer > > AEPS INC > > Allaire ColdFusion Consulting Partner > > www.aeps.com > > www.aeps2000.com > > 954-472-6684 X303 > > ICQ: 417645 > > > ~~ 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: CFOUTPUT question
even with #ucase(name)# it still screws up half the time Bill Wheatley Director of Development Allaire Certified ColdFusion Developer AEPS INC Allaire ColdFusion Consulting Partner www.aeps.com www.aeps2000.com 954-472-6684 X303 ICQ: 417645 - Original Message - From: "Clint Tredway" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, April 08, 2001 12:14 AM Subject: Re: CFOUTPUT question > try using the same variable to name the query as you are for naming the output. I have done this before where my query name was "lu#table#" and my cfoutput was named the same ie: name="lu#table#". > > HTH > > -- Original Message -- > From: "William Wheatley" <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Sun, 08 Apr 2001 00:03:42 -0400 > > Anyone know a way to use a dynamic variable inside of a CFOUTPUT? > > > > > #ucase(name)# > > > > I tried using EVALUate() and playing aroudn with a few different ways but its being a pain. > > =) > > Thx > > > Bill Wheatley > Director of Development > Allaire Certified ColdFusion Developer > AEPS INC > Allaire ColdFusion Consulting Partner > www.aeps.com > www.aeps2000.com > 954-472-6684 X303 > ICQ: 417645 > ~~ 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: CFOUTPUT question
try using the same variable to name the query as you are for naming the output. I have done this before where my query name was "lu#table#" and my cfoutput was named the same ie: name="lu#table#". HTH -- Original Message -- From: "William Wheatley" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Sun, 08 Apr 2001 00:03:42 -0400 Anyone know a way to use a dynamic variable inside of a CFOUTPUT? #ucase(name)# I tried using EVALUate() and playing aroudn with a few different ways but its being a pain. =) Thx Bill Wheatley Director of Development Allaire Certified ColdFusion Developer AEPS INC Allaire ColdFusion Consulting Partner www.aeps.com www.aeps2000.com 954-472-6684 X303 ICQ: 417645 ~~ 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: Bizarre Client Variables problem
TIP: it can help to have two browser sessions open to track your applications. They should be different browsers (ie: one Navigator and the other IE) as CF identifies them is different "clients". Whack a header at the top of your pages (for testing purposes) displaying your applicats client variables and check that they remain what you expect them to be while switching between the browsers and testing your application. If user one suddenly switches to user two you will know you have a problem. ~~ 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: Bizarre Client Variables problem
Try appending the CDIF and CFTOKEN to your transactions (eg: URL's, forms, etc) eg: This should ensure that your application can differentiate which client is making the request. You should use this method throughout your app. -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Saturday, 7 April 2001 22:07 To: CF-Talk Subject: Bizarre Client Variables problem Hi, I wrote a page last night, to allow Members to update their Personal Details that are on the DB. As with all the other pages on my site, I make them a) login, then b) query the DB by their login-email (client.email) and c) display information. Instead though, the query is displaying the last updated record's information, and not the users'. This is a major problem - when Jeff Smith goes to update his records, he's presented with Nancy Bowhearts' instead... The query is about as basic as you can get, but still I can't work out why it isn't pulling the user's information. All other pages work fine using "WHERE email = '#client.email#'" - here's a small chunk of the code: Please login, by entering your email and password on the left SELECT * FROM members WHERE email = '#client.email#' First Name ..etc Can anyone offer a reason why this is happening? Regards Will -- [EMAIL PROTECTED] -=- www.lukrative.com Local-Advertising -=- www.localbounty.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
CFOUTPUT question
Anyone know a way to use a dynamic variable inside of a CFOUTPUT? #ucase(name)# I tried using EVALUate() and playing aroudn with a few different ways but its being a pain. =) Thx Bill Wheatley Director of Development Allaire Certified ColdFusion Developer AEPS INC Allaire ColdFusion Consulting Partner www.aeps.com www.aeps2000.com 954-472-6684 X303 ICQ: 417645 ~~ 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: update numeric SubString?
I would do it this way: UPDATE mytable SET switch = left(switch, 3) + '1' + right(switch , len(switch) -4) WHERE po = 236107 In other words drop the single quotes from everything except the number you're swapping, otherwise, what you'll end up with is a string that literally concatenates your functions into the string (e.g. switch will equal "left(switch, 3)1right(switch , len(switch) -4)"). I'm not sure why it would give you null though -- it really should bomb. -Original Message- From: Adrian Cesana [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 07, 2001 7:12 PM To: CF-Talk Subject: RE: update numeric SubString? hmmm, I think I have the syntax correct , here is what Ive tried: UPDATE mytable SET switch = 'left(switch, 3)' + '1' + 'right(switch , len(switch) -4)' WHERE po = '236107' I also tried this which gives me the same results, . UPDATE mytable SET switch = CAST( left( cast(switch AS varchar(11)) , 3) + '1' + right( cast(switch AS varchar(11)) , len( cast(switch AS varchar(11)) ) -4) AS Numeric) WHERE po = '236107' DB: SQL7 CF: 4.01 Perhaps its ODBC driver related..wierdness -Original Message- From: Michael Caulfield [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 07, 2001 5:27 PM To: CF-Talk Subject: RE: update numeric SubString? Actually I just tried it from CF on a test table, and it's working fine (i'm using CF5 Beta 1, but I don't think that matters). Maybe there was a slight difference in your syntax? Here's the cf query USE pubs UPDATE tbl SET col =left(col,3) + '0' + right(col, len(col) - 4) pubs is the database, tbl is the table, and col is the column. Zero can of course be replaced with any digit. Hope it works --- feel free to post a more complete version of your code if it doesn't. ~~ 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: Weird page timeouts with Oracle
Francisco, We had a similar problem. We were running an NT Server with Oracle 7.3. Our US based users had no trouble with timeouts but our users in Paris were experiencing a timeout like you described. This only occured on very large queries with 8-15 tables and several hundred rows returned. Our solution on that box was simple. Set your CF timeout higher - Like 5 minutes. Since that time we have moved to a new Sun box running Oracle 8.0i with no timeout issues for anyone. Your second and third queries run because Oracle is caching the query and re-using it even though Cold Fusion timed out the first time. Wally Randall Gaithersburg MD USA - Original Message - From: "Francisco Montes; Spain on Line" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, April 04, 2001 12:15 PM Subject: Weird page timeouts with Oracle | Hi, | | We have been getting a series of very weird error messages with CF lately. We have got two servers, one with CF and another with the Oracle database. | | The CF server page request timeout is set to 30 seconds. When we request a page for the first time, it always goes beyond this threshold for some reason (it should not take that long anyway) and we get the CF page timeout error message. However if we request the page again, chances are that everything will go ok. | | Another scenario: | | 1. We request a page for the first time with a browser, and it is starting to take too long to deliver... | 2. If in that time (within the 30 seconds threshold) we request that very same page with another browser (on another machine) the page in browser the first browser gets finally delivered while the one in the second one starts taking a long time to deliver. | | It looks like if Oracle is not passing control back to CF unless this is forced somehow by another request done by someone else. We are trying to work out why are we still getting this erratic behaviour. | | We are using: Solaris 5.8, Apache 1.3.9, Oracle client 8.1.6.3 | | Any ideas or comments about what could be going wrong would be greatly appreciated. | | Francisco 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
RE: update numeric SubString?
hmmm, I think I have the syntax correct , here is what Ive tried: UPDATE mytable SET switch = 'left(switch, 3)' + '1' + 'right(switch , len(switch) -4)' WHERE po = '236107' I also tried this which gives me the same results, . UPDATE mytable SET switch = CAST( left( cast(switch AS varchar(11)) , 3) + '1' + right( cast(switch AS varchar(11)) , len( cast(switch AS varchar(11)) ) -4) AS Numeric) WHERE po = '236107' DB: SQL7 CF: 4.01 Perhaps its ODBC driver related..wierdness -Original Message- From: Michael Caulfield [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 07, 2001 5:27 PM To: CF-Talk Subject: RE: update numeric SubString? Actually I just tried it from CF on a test table, and it's working fine (i'm using CF5 Beta 1, but I don't think that matters). Maybe there was a slight difference in your syntax? Here's the cf query USE pubs UPDATE tbl SET col =left(col,3) + '0' + right(col, len(col) - 4) pubs is the database, tbl is the table, and col is the column. Zero can of course be replaced with any digit. Hope it works --- feel free to post a more complete version of your code if it doesn't. ~~ 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: CFINCLUDE question
This will be on a dedicated server, so we can do whatever we want. Dave - Original Message - From: Bud <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Sent: Saturday, April 07, 2001 7:09 PM Subject: Re: CFINCLUDE question > On 4/7/01, David Hannum penned: > >Here's one for you folks experienced in virtual hosting. If I have virtual > >accounts (dot coms) off of my root directory, can I use CFINCLUDES that are > >located in the root directory? If so, how? > > Just use the path. If the host has Enterprise with Sandbox Security > in place, it may not work though I'm not sure. > > Otherwise: > > C: > Customer1_ftp_root > htdocs > mytemplate.cfm > Customer2_ftp_root > htdocs > myinclude.cfm > > To include myinclude.cfm in mytemplate.cfm: > > > > That's one of the inherent dangers of using dynamically populated > includes. Something like > > > > will let you go right on up into the system directories. > -- > > Bud Schneehagen - Tropical Web Creations > > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ > ColdFusion Solutions / eCommerce Development > [EMAIL PROTECTED] > http://www.twcreations.com/ > 954.721.3452 > > ~~ 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: update numeric SubString?
Actually I just tried it from CF on a test table, and it's working fine (i'm using CF5 Beta 1, but I don't think that matters). Maybe there was a slight difference in your syntax? Here's the cf query USE pubs UPDATE tbl SET col =left(col,3) + '0' + right(col, len(col) - 4) pubs is the database, tbl is the table, and col is the column. Zero can of course be replaced with any digit. Hope it works --- feel free to post a more complete version of your code if it doesn't. -Original Message- From: Adrian Cesana [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 07, 2001 3:38 PM To: CF-Talk Subject: RE: update numeric SubString? This works perfectly in T-SQL but in CF it makes the field , Ive tried a few different formatting options but they all err out. Any ideas on how to make CF happy with this? Thanks! Adrian ~~ 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: CFINCLUDE question
On 4/7/01, David Hannum penned: >Here's one for you folks experienced in virtual hosting. If I have virtual >accounts (dot coms) off of my root directory, can I use CFINCLUDES that are >located in the root directory? If so, how? Just use the path. If the host has Enterprise with Sandbox Security in place, it may not work though I'm not sure. Otherwise: C: Customer1_ftp_root htdocs mytemplate.cfm Customer2_ftp_root htdocs myinclude.cfm To include myinclude.cfm in mytemplate.cfm: That's one of the inherent dangers of using dynamically populated includes. Something like will let you go right on up into the system directories. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ 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 RPC service is unavailable error
I just got this on my NT 4.0 workstation this week when I was trying to map to a network printer and it required my workstation to download the drivers for installation Two factors were related to this problem: 1. Microsoft knowledgebase revealed that there may have been a problem with some dlls from the latest service pack and recommended they be re-installed. (6 or something) This however did not solve the problem for me. 2. We believe thereal problem was that my C: drive was too full! I was out of temp space, cache space, my system log was full,and room to download the printer drivers. I am cleaning up my hard drive but have not yet attempted to download the printer drivers. Wally Randall Gaithersburg MD. .. Our LAN - Original Message - From: "Mark W. Breneman" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, April 04, 2001 1:52 PM Subject: Random RPC service is unavailable error | Has any one seen a "RPC service is unavailable" error from time to time? | This error seems to be very very infrequent. (about once every three | months) After hitting reload the error goes away. | | Mark W. Breneman | -Cold Fusion Developer | -Network Administrator | Vivid Media | [EMAIL PROTECTED] | www.vividmedia.com | 608.270.9770 | | ~~ 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: CFINCLUDE question
You can do it if you're allowed to use CF mappings. best, paul At 05:20 PM 4/7/01 -0400, you wrote: >Here's one for you folks experienced in virtual hosting. If I have virtual >accounts (dot coms) off of my root directory, can I use CFINCLUDES that are >located in the root directory? If so, how? ~~ 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: Oddest Server Error I have seen thus far.
On Fri, 06 Apr 2001 22:12:30 -0400, "Erik Yowell" <[EMAIL PROTECTED]> wrote: >Help! If anyone >has any answers or possible causes, please email me... I doubt I'll be >sleeping until I get it fixed. :) Erik, That's one of CF's "garbage errors"... it can indicate any number of potential problems, and doesn't give you any useful feedback you can use to hunt down the real error. Along with the other suggestions you've received, I'd recommend looking for any use of the Duplicate() function in your code. At one point, I had an app that used Duplicate() to move Session scoped queries-within-nested-structures into the Request scope, and it would consistently bomb with the error you received. The solution was to toss out Duplicate() until CF5 and use WDDX to move between scopes instead. -- Roger ~~ 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
CFINCLUDE question
Here's one for you folks experienced in virtual hosting. If I have virtual accounts (dot coms) off of my root directory, can I use CFINCLUDES that are located in the root directory? If so, how? 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: update numeric SubString?
This works perfectly in T-SQL but in CF it makes the field , Ive tried a few different formatting options but they all err out. Any ideas on how to make CF happy with this? Thanks! Adrian -Original Message- From: Michael Caulfield [mailto:[EMAIL PROTECTED]] assuming all rows are at least 4 places long: update tbl SET col =left(col,3) + '0' + right(col, len(col) - 4) In SQL 2000 I can do this without any explicit conversion of types, I don't know if you'd have to cast it to a string and back to a number in another system or not. If some entries have less than 4 places, just add a WHERE col > 999 to it. HTH, Michael Caulfield -Original Message- From: Adrian Cesana [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 7:27 PM To: CF-Talk Subject: update numeric SubString? If I have a numeric field that is '999', is there any way to just update the forth number, something like this although I know it does not work UPDATE blah SET SubString(Switch, 4,1) = '1' WHERE blah I need to do this to several records and will not know the entire value of the Field prior to updating. I know I can do this thru a loop but it gets really ugly when your dealing with several thousands of records. Thanks,Adrian ~~ 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 Server parsing .js files...
Don't change your .js files to .cfm files or mess with your server extensions or them. That's not how the browser uses the .js files. If you want to include CF variables in your .js files, do this. In a separate WriteJSOutput.cfm file, process the CF variables, and then use CFFILE to write to your .js file. _ Get your FREE download of MSN Explorer at http://explorer.msn.com Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Strategy Question - Site Searches
Eric, Verity can handle this. The cf-wacc has a chapter on how to build a search index against a db query, and this can be combined with searches against flat pages. Also cfhub has a great article on managing your indices programatically (http://cfhub.com/tutorials/verity/index.cfm). Assuming everything works as advertised (I have not yet actually built a search function that will do this), that might be all you need. Good luck! djm > -Original Message- > From: Eric Root [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 06, 2001 1:25 PM > To: CF-Talk > Subject: Strategy Question - Site Searches > > > When you set up a CF website where most of your content is data driven, > how can you provide search options for the users that are of any value? > Since most of your data is hidden in the database (MS SQL Server), how > do you index the data in the database and combine it with the static web > site text? Does Verity or other tools (including third party turnkey > search services) handle this in any way? Interested in hearing > strategies on this subject. Thanks. > > -- > Eric Root > Environmental Management Systems Inc. > Web Site: http://www.mountainmyst.com/emsi/emsi_home.htm > Phone (Voice): (509) 548-0243 > Phone (Fax): (509) 548-0244 > > > ~~ 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
Certified ColdFusion Developer Study Guide
Has anyone picked it up yet? I think I am going to get a copy today. Just wanted to hear your thoughts if you got it. Kelly ~~ 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 Server parsing .js files...
> > That's the way we do it... works like a champ. When your stylesheets get > > big, you really should link to them, rather than include them, so that > > browsers can cache them and speed up all your pages. Works for us in > > Netscape, too, vs. Steve's experience in the next post. > > > It's not a stylesheet. It's a javascript source file that I'm trying to > include with CF variables Sorry, Steve. I meant javscript source file. Got confused because we use the same technique for .js and .css. > This works fine in IE and NS... > > > > This works in IE but not in NS... > > > > I'm thinking I need to find another approach to what I'm trying to do. > Netscape seems to need the .js extension to reference as a valid source > file. Not true. Check out http://www.fuselets.com/cftips/ with Netscape, then take a look at the
Re: Bizarre Client Variables problem
I don't know why it helped - but the server was restarted by my hosters, and everything's working fine again. It suddenly woke up again, and I had no idea the server had been restartedvery weird. Will - Original Message - From: ""Jon Hall"" <[EMAIL PROTECTED]> Newsgroups: dotcom.lists.cftalk Sent: Saturday, April 07, 2001 3:18 PM Subject: Re: Bizarre Client Variables problem > I've never seen anything like this...check your login script to make sure it > is setting the proper client variables. Check your queries too...Use > clientvariablelist() to view what the variables are being set to. Make sure > your users are not logging in from the same computer without closing all > browser windows, I once had 50 Puerto Ricans signing up from the same > computer...scratched my head for awhile on that one. > > jon > - Original Message - > From: "W Luke" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Saturday, April 07, 2001 8:07 AM > Subject: Bizarre Client Variables problem > > > > Hi, > > > > I wrote a page last night, to allow Members to update their Personal > Details > > that are on the DB. As with all the other pages on my site, I make them > a) > > login, then b) query the DB by their login-email (client.email) and c) > > display information. > > > > Instead though, the query is displaying the last updated record's > > information, and not the users'. This is a major problem - when Jeff > Smith > > goes to update his records, he's presented with Nancy Bowhearts' > instead... > > The query is about as basic as you can get, but still I can't work out why > > it isn't pulling the user's information. All other pages work fine using > > "WHERE email = '#client.email#'" - here's a small chunk of the code: > > > > Please login, by entering your email and > > password on the left > > > > > > > > > > SELECT * FROM members > > WHERE email = '#client.email#' > > > > > > > > > > > > > > > > First Name > > > > > > > > .etc > > > > > > Can anyone offer a reason why this is happening? > > > > Regards > > > > Will > > -- > > [EMAIL PROTECTED] -=- www.lukrative.com > > Local-Advertising -=- www.localbounty.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: CF-Talk-list V1 #258
Is there a MIME type associated with .js files? You may need to throw a CFCONTENT tag at the beginning of your CFM file to tell the browser that it is definitely a JS file rather than a text or HTML file (which is default for CFM files I believe). The browser shouldn't care about the extension of the filename... only the MIME type offered at the beginning of the file by your Web server. The PC I'm using here doesn't seem to have a mapping for .js, so I can't tell if it uses a separate MIME type or not. Brian At 07:31 AM 04/07/2001 -0400, you wrote: >Date: Fri, 06 Apr 2001 23:27:55 -0400 >From: "Steve Reich" <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: Re: CF Server parsing .js files... >Message-ID: <[EMAIL PROTECTED]> > > > That's the way we do it... works like a champ. When your stylesheets get > > big, you really should link to them, rather than include them, so that > > browsers can cache them and speed up all your pages. Works for us in > > Netscape, too, vs. Steve's experience in the next post. > > >It's not a stylesheet. It's a javascript source file that I'm trying to >include with CF variables > >This works fine in IE and NS... > > > >This works in IE but not in NS... > > > >I'm thinking I need to find another approach to what I'm trying to do. >Netscape seems to need the .js extension to reference as a valid source >file. > >Steve Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: [HTML Email Detection]
You should use multipart email as mentioned, IMS is good for that, this will work on MOST email clients whether plaintext or html. However, if you want to actually detect who can read HTML emails, you need to include an image in the HTML part of the email, that not only points to script on your server, but also includes the recipient's email address. That way, if when they read the email they view the HTML version you will recieve a 'hit' on your site, and you can record this in the knowledge that they are HTML-capable. Seth Ward www.ifirms.com -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: 07 April 2001 15:09 To: CF-Talk Subject: Re: [HTML Email Detection] Yes, our tag does do that. However, it only sends mail through an iMS server and not the CFMail spool. Regards, Howie - Original Message - From: "Jason" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, April 07, 2001 3:46 AM Subject: RE: [HTML Email Detection] > Check with Howie at Coolfusion.com he has a CFX_ImsMail tag that I believe > will allow you to send both HTML/Plain and let the users mail server or > browser choose on the other end. Haven't tested this myself but I think it > can do it. > ~~ 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: Problem generating a query based on a specific date field
On 4/7/01, Johnny Boursiquot penned: > > SELECT * FROM Clock WHERE (StaffID = #session.StaffID#) AND >(ClockDate = >Now()) > Try ClockDate = #Now()# -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ 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: Oddest Server Error I have seen thus far.
On 4/6/01, Erik Yowell penned: >CFTempOnlyForSetVariableNeverUseThisNameInYourCFMLCode Strangely enough I had this one come up on me several weeks ago and it took me 18 hours to figure it out. This may not be the only situation in which it pops up, but I was told to look for a value with an empty variable name. I'm thinking, how in the heck could that be? LOL This is what I found. I was using the _range validation hidden input tag with only a min=1, which has always worked fine on 4.0x for me. I looked at the debug section and one of the field values submitted was: QUANTITY_RANGE=min=1 Which looked suspiciously to me like it may be resolving to an empty variable name (=1). I removed the quantity_range field and VOILA! So, I suggest looking at the debug section and see if you see anything similar looking. -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ~~ 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: Bizarre Client Variables problem
I've never seen anything like this...check your login script to make sure it is setting the proper client variables. Check your queries too...Use clientvariablelist() to view what the variables are being set to. Make sure your users are not logging in from the same computer without closing all browser windows, I once had 50 Puerto Ricans signing up from the same computer...scratched my head for awhile on that one. jon - Original Message - From: "W Luke" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, April 07, 2001 8:07 AM Subject: Bizarre Client Variables problem > Hi, > > I wrote a page last night, to allow Members to update their Personal Details > that are on the DB. As with all the other pages on my site, I make them a) > login, then b) query the DB by their login-email (client.email) and c) > display information. > > Instead though, the query is displaying the last updated record's > information, and not the users'. This is a major problem - when Jeff Smith > goes to update his records, he's presented with Nancy Bowhearts' instead... > The query is about as basic as you can get, but still I can't work out why > it isn't pulling the user's information. All other pages work fine using > "WHERE email = '#client.email#'" - here's a small chunk of the code: > > Please login, by entering your email and > password on the left > > > > > SELECT * FROM members > WHERE email = '#client.email#' > > > > > > > > First Name > > > > .etc > > > Can anyone offer a reason why this is happening? > > Regards > > Will > -- > [EMAIL PROTECTED] -=- www.lukrative.com > Local-Advertising -=- www.localbounty.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: [HTML Email Detection]
Yes, our tag does do that. However, it only sends mail through an iMS server and not the CFMail spool. Regards, Howie - Original Message - From: "Jason" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, April 07, 2001 3:46 AM Subject: RE: [HTML Email Detection] > Check with Howie at Coolfusion.com he has a CFX_ImsMail tag that I believe > will allow you to send both HTML/Plain and let the users mail server or > browser choose on the other end. Haven't tested this myself but I think it > can do it. > ~~ 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: Oddest Server Error I have seen thus far.
This happens when you have automatic locking turned on in the server settings I believe and some variable or the other isn't locked correctly in the code. I got this when trying to use a custom Calendar control once, and solved the problem by removing the Automatic Locking settings on the server, and the error went away. You can try that and see if it works.. -Gel -Original Message- From: James Milks [mailto:[EMAIL PROTECTED]] That almost sounds like a joke...although I'm sure it isn't. How long can a variable name be? James -Original Message- From: Joseph Thompson [mailto:[EMAIL PROTECTED]] Check for "variables" with names that look like they may be reserved. CFTempOnlyForSetVariableNeverUseThisNameInYourCFMLCode ~~ 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: Oddest Server Error I have seen thus far.
That almost sounds like a joke...although I'm sure it isn't. How long can a variable name be? James -Original Message- From: Joseph Thompson [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 11:02 PM To: CF-Talk Subject: Re: Oddest Server Error I have seen thus far. Check for "variables" with names that look like they may be reserved. CFTempOnlyForSetVariableNeverUseThisNameInYourCFMLCode ~~ 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
Bizarre Client Variables problem
Hi, I wrote a page last night, to allow Members to update their Personal Details that are on the DB. As with all the other pages on my site, I make them a) login, then b) query the DB by their login-email (client.email) and c) display information. Instead though, the query is displaying the last updated record's information, and not the users'. This is a major problem - when Jeff Smith goes to update his records, he's presented with Nancy Bowhearts' instead... The query is about as basic as you can get, but still I can't work out why it isn't pulling the user's information. All other pages work fine using "WHERE email = '#client.email#'" - here's a small chunk of the code: Please login, by entering your email and password on the left SELECT * FROM members WHERE email = '#client.email#' First Name .etc Can anyone offer a reason why this is happening? Regards Will -- [EMAIL PROTECTED] -=- www.lukrative.com Local-Advertising -=- www.localbounty.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: CF Server parsing .js files...
Remember if the js file is included lik this: you have to wrap the include in a:In the preceding instance the src directory is on the root of the site and the site has a coldfusion mapping of dd. Hope that helps. Frederic Dave Hannum wrote: > The only way I can think of would be to wrap it in a CFINCLUDE inside a .cfm > page. > > Dave > > - Original Message - > From: "Steve Reich" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, April 06, 2001 1:16 PM > Subject: CF Server parsing .js files... > > > I have a single javascript file (*.js) that I want to include CF variables > > with. I know how to set IIS up to allow CF Server to process a specific > file > > extension, but I don't neccessarily want it to process all .js files. My > > question is > > > > Is there any command I can use to only process the single file or if I > want > > CF Server to process one, it has to do them all? > > > > > > > > ...js file contents. > > > > > > > > Anything like that? I know I'm reaching here and am pretty positive I > can't > > do this, but I thought I'd ask anyway... > > > > Thanks, > > Steve > > > > > > > > > ~~ 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
