Re: Store Query in APPLICATION variable
You should look into the CACHEDAFTER and CACHEDWITHIN attributes of the CFQUERY tag. This will allow you to keep queries in memory for a period of time that you indicate using the CreateTimeSpan(days, hours, minutes, seconds) function. Every time the query is run with exactly the same parameters it will be served from memory not requiring an additional trip to the database. Bryan LaPlante 816-347-8220 [EMAIL PROTECTED] http://www.netwebapps.com Web Development - Original Message - From: "Hamid Hossain" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, June 02, 2001 12:39 AM Subject: Store Query in APPLICATION variable | Hi folks, | | I want to store a query results in an APPLICATION | variable. So, it will be available for all users with | making the call through ODBC every time. | | for examble: | | the query may be for Countries like: | | | SELECT * FROM Countries | | | then, I will use it with a loop to make HTML drop-down | menu with | | Is there a way to do that ? please tell me if it is | important to use with the previous code. | | Thanks | Hamid Hossain | ~~ 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
Store Query in APPLICATION variable
Hi folks, I want to store a query results in an APPLICATION variable. So, it will be available for all users with making the call through ODBC every time. for examble: the query may be for Countries like: SELECT * FROM Countries then, I will use it with a loop to make HTML drop-down menu with Is there a way to do that ? please tell me if it is important to use with the previous code. Thanks Hamid Hossain ~~ 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: Dynamic Table Height
Guy, Create a 2 cell table consisting of a right and left cell. Assign one cell the dynamic contents, and the other the static contents. Set VALIGN = TOP. As the dynamic cell grows in height, the adjacent static cell will also grow in height. As the dynamic cell shrinks in height it will stop shrinking once it equals the minimum static cell height. This is because the two cells are in the same "ROW" - - - - Hope this helps. Example: Static Cell Dynamic Cell Regards, Tom Forbes At 09:23 AM 6/1/01, you wrote: >Hmmm... > >Situation: Two tables beside each other. One contains >dynamic content, the other is static. >Goal: To have both tables the same height at all times >regardless of how much content is in the dynamic table. >However, the dynamic table should also never be shorter >than the static table. >Resources: A novice understanding of JavaScript, info >brought in via from an Access DB >My Priority on this: Pretty low, but it would be really >cool to be able to do. > >Yours In Conservation, > >Guy J. McDowell >Webmaster >Ontario Federation of Anglers & Hunters >(705) 748-6324 ext. 262 >www.OFAH.org > > >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists *** MedMatrix Used Medical Equipment Web Portal http://www.medmatrix.com V:(407) 772-3427 F:(407) 772-3428 Tom Forbes, Forbes Web Consulting, Inc. 178 S. Monterey Isle Blvd., Longwood, FL - 32779 *** ~~ 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
Dynamic Table Height
Hmmm... Situation: Two tables beside each other. One contains dynamic content, the other is static. Goal: To have both tables the same height at all times regardless of how much content is in the dynamic table. However, the dynamic table should also never be shorter than the static table. Resources: A novice understanding of JavaScript, info brought in via from an Access DB My Priority on this: Pretty low, but it would be really cool to be able to do. Yours In Conservation, Guy J. McDowell Webmaster Ontario Federation of Anglers & Hunters (705) 748-6324 ext. 262 www.OFAH.org Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFX_REPLACE_CHARS
Does anybody have the cfx_replace_chars custom tag they could send me? I'm playing around with the old Forums, and it's calling for it. It's not available in the tag gallery. 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: IIS or Apache? (WAS RE: can anyone help?)
Oh, this reminds me. At my last setup, we had a cluster (hwlb) of servers for cf and a separate cluster for serving images. The reason for this is similar to below. For the image server, we stripped apache of all unnecessary modules and tweaked the threads/size parameters to optimize for normal image sizes. We kept all image paths in a separate application variable and could change it all will (useful for SSL when the image server doesn't have a certificate) - also setup up the image server to mount the web root (like the clustered cf servers do), but only to the images subdirectory. Kept that machine nice and basic and secure... > 1. Run 2 instances of apache on each web server. One handles all CF > requests and one handles all static requests (images mostly). We have found > that apache can serve over 500 14K files per second on a dual PIII 600 (we > were actually bottlenecked by the 100mb network. With 1K files we hit about > 750/sec). Running 2 instances of apache allows us to have cold fusion under > load and not slow down the delivery of all the images required to complete > the page. Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange ~~ 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: IIS or Apache? (WAS RE: can anyone help?)
You go dude! > We have been running Apache with CF 4.5 on NT 4 for the last 2 year under > very heavy load and have found no stability problems that were related to > Apache. Additionally, because of the open API of apache we have been able > to do some very interesting things for scale and reliability: > > 1. Run 2 instances of apache on each web server. One handles all CF > requests and one handles all static requests (images mostly). We have found > that apache can serve over 500 14K files per second on a dual PIII 600 (we > were actually bottlenecked by the 100mb network. With 1K files we hit about > 750/sec). Running 2 instances of apache allows us to have cold fusion under > load and not slow down the delivery of all the images required to complete > the page. > > 2. Create modules to handle high load. We build pages in CF, then if the > page is seeing more load than CF can handle, we write an apache module in > C++ to handle that one function and use the Apache handler to intercept the > ..cfm request, check if we have a custom handler for the page, handle it if > we do, and pass it on to CF if we do not. This is, BTW how we are able to > set cookies during a server side redirect. > > 3. Bind different virtual hosts to different ports (I do not use IIS so I do > not know if yuo can do this or not). Our webserver has a single IP and each > host is a different high port (8080, 8081,8082, etc). We handle the > redirection from different external IP's to a single Internal IP, different > port either in the firewall or the load balancer. This allows the > adding/removing of hosts without re-ip'ing the web server and limits the > number of IP addresses which is important for some firewall licensing > schemes. > > We are firm believers in the KISS principle (keep it simple stupid). Apache > is pretty simple, we upgrade when we want to, and it does not try to hook > into too many OS functions that may cause issues. > > The down side is that it requires a programmer to make the most of it and > the interface is config file based, which not everyone is comfortable with. > > My $.02 > > Justin > > Justin Greene > Co-CEO > ClicVU, Inc. > 216 West 18th St., Floor 12 - NYC 10011 > P: 212-629-8900 - F: 212-629-9860 > http://www.clicvu.com > > - > Sign up for your free Spamex account: > http://www.spamex.com > Protect your real email address forever > - > > > > -Original Message- > From: Zac [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 31, 2001 11:21 PM > To: CF-Talk > Subject: RE: IIS or Apache? (WAS RE: can anyone help?) > > > I would recomment sticking with IIS on an NT box. With CF > > and Apache, there > > were (at least for me) a bunch of bugs. > > Well I think this is one of those YMMV moments. I ran Apache, CF 4.5 and > mySQL on an NT4 server for months with no problems at all. And it was, YMMV > again, more stable than when I was running IIS. > ~~ 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: [RE: IIS or Apache? (WAS RE: can anyone help?)]
> > 1. Run 2 instances of apache on each web server. One handles all CF > requests and one handles all static requests (images mostly). We > have found > that apache can serve over 500 14K files per second on a dual PIII 600 (we > were actually bottlenecked by the 100mb network. With 1K files > we hit about > 750/sec). Running 2 instances of apache allows us to have cold > fusion under > load and not slow down the delivery of all the images required to complete > the page. How did you configure this? Did the different instances have different ports? ALSO how did you get CF to run with all the instances? ~~ 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: Apache and trailing back slash
Yep -- I got the same thing -- To make things work on both Apache and IIS, I ended up adding a check for it within an statement and stripping it off if there was a "/\" at the end -- see following code -- go figure... ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 -Original Message- From: sebastian palmigiani [SMTP:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 1:27 PM To: CF-Talk Subject:Apache and trailing back slash I do not understand why you get trailing back slash when using GetDirectoryFromPath with Apache web server #GetDirectoryFromPath(CGI.CF_TEMPLATE_Path)# In other words I get c:/program files/apache group/apache/htdocs/members/om/archive/adu/\ Why is there a trailing back slash? How do I get rid of it? Sebastian ~~ 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: IIS or Apache? (WAS RE: can anyone help?)
My understanding was that Apache for NT used the POSIX subsystem, and took somewhat of a performance hit because of it. Is this not the case? Kevin >>> [EMAIL PROTECTED] 06/01/01 01:52PM >>> > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 01, 2001 13:37 > To: CF-Talk > Subject: RE: IIS or Apache? (WAS RE: can anyone help?) > > > We have been running Apache with CF 4.5 on NT 4 for the last 2 year under > very heavy load and have found no stability problems that were related to > Apache. Additionally, because of the open API of apache we have been able > to do some very interesting things for scale and reliability: I was running Apache on my development machine for local testing. It was rather under-horsepowered for running as a CF server. But it ran better than PWS on NT 4.0 Workstation. > > 1. Run 2 instances of apache on each web server. One handles all CF > requests and one handles all static requests (images mostly). We > have found > that apache can serve over 500 14K files per second on a dual PIII 600 (we > were actually bottlenecked by the 100mb network. With 1K files > we hit about > 750/sec). Running 2 instances of apache allows us to have cold > fusion under > load and not slow down the delivery of all the images required to complete > the page. How did you configure this? Did the different instances have different ports? > > 2. Create modules to handle high load. We build pages in CF, then if the > page is seeing more load than CF can handle, we write an apache module in > C++ to handle that one function and use the Apache handler to > intercept the > ..cfm request, check if we have a custom handler for the page, > handle it if > we do, and pass it on to CF if we do not. This is, BTW how we are able to > set cookies during a server side redirect. Nice idea. I'm hoping the CFFLUSH tag will allow this to happen under IIS. If not, I am going to suggest that we switch to Apache and try something similar. I guess the module set the cookie and then let the CF server process the cfm page. > > 3. Bind different virtual hosts to different ports (I do not use > IIS so I do > not know if yuo can do this or not). Our webserver has a single > IP and each > host is a different high port (8080, 8081,8082, etc). We handle the > redirection from different external IP's to a single Internal IP, > different > port either in the firewall or the load balancer. This allows the > adding/removing of hosts without re-ip'ing the web server and limits the > number of IP addresses which is important for some firewall licensing > schemes. IIS has a variety of tools. You can set it either to answer on a specific IP address on multi-homed systems. When you set the IP address, you also can set the port that the web site (Virtual Server) answers. Though I have never tried it, I am told that you can even have IIS differentiate to different Virtual Servers answering on the same IP address and port based upon the domain name in the header. I don't think that is particularly efficient when it is pretty easy to either multi-home a NIC or have multiple NICs depending on bandwidth requirements. > > We are firm believers in the KISS principle (keep it simple > stupid). Apache > is pretty simple, we upgrade when we want to, and it does not try to hook > into too many OS functions that may cause issues. True, but we chose to use IIS since we all (the CF developers) knew how to administer it. Only I knew how to administer Apache. > > The down side is that it requires a programmer to make the most of it and > the interface is config file based, which not everyone is > comfortable with. Being on old SunOS (NOT Solaris) gearhead I can appreciate it. I still prefer to tweak my Win 2K box by editing the Win.ini file. > > My $.02 Thanks for sharing it. It gave me a few ideas to file away and suprise the CTO with. ;) > > Justin > > Justin Greene > Co-CEO > ClicVU, Inc. > 216 West 18th St., Floor 12 - NYC 10011 > P: 212-629-8900 - F: 212-629-9860 > http://www.clicvu.com > [snip] > ~~ 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: IIS or Apache? (WAS RE: can anyone help?)
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 01, 2001 13:37 > To: CF-Talk > Subject: RE: IIS or Apache? (WAS RE: can anyone help?) > > > We have been running Apache with CF 4.5 on NT 4 for the last 2 year under > very heavy load and have found no stability problems that were related to > Apache. Additionally, because of the open API of apache we have been able > to do some very interesting things for scale and reliability: I was running Apache on my development machine for local testing. It was rather under-horsepowered for running as a CF server. But it ran better than PWS on NT 4.0 Workstation. > > 1. Run 2 instances of apache on each web server. One handles all CF > requests and one handles all static requests (images mostly). We > have found > that apache can serve over 500 14K files per second on a dual PIII 600 (we > were actually bottlenecked by the 100mb network. With 1K files > we hit about > 750/sec). Running 2 instances of apache allows us to have cold > fusion under > load and not slow down the delivery of all the images required to complete > the page. How did you configure this? Did the different instances have different ports? > > 2. Create modules to handle high load. We build pages in CF, then if the > page is seeing more load than CF can handle, we write an apache module in > C++ to handle that one function and use the Apache handler to > intercept the > ..cfm request, check if we have a custom handler for the page, > handle it if > we do, and pass it on to CF if we do not. This is, BTW how we are able to > set cookies during a server side redirect. Nice idea. I'm hoping the CFFLUSH tag will allow this to happen under IIS. If not, I am going to suggest that we switch to Apache and try something similar. I guess the module set the cookie and then let the CF server process the cfm page. > > 3. Bind different virtual hosts to different ports (I do not use > IIS so I do > not know if yuo can do this or not). Our webserver has a single > IP and each > host is a different high port (8080, 8081,8082, etc). We handle the > redirection from different external IP's to a single Internal IP, > different > port either in the firewall or the load balancer. This allows the > adding/removing of hosts without re-ip'ing the web server and limits the > number of IP addresses which is important for some firewall licensing > schemes. IIS has a variety of tools. You can set it either to answer on a specific IP address on multi-homed systems. When you set the IP address, you also can set the port that the web site (Virtual Server) answers. Though I have never tried it, I am told that you can even have IIS differentiate to different Virtual Servers answering on the same IP address and port based upon the domain name in the header. I don't think that is particularly efficient when it is pretty easy to either multi-home a NIC or have multiple NICs depending on bandwidth requirements. > > We are firm believers in the KISS principle (keep it simple > stupid). Apache > is pretty simple, we upgrade when we want to, and it does not try to hook > into too many OS functions that may cause issues. True, but we chose to use IIS since we all (the CF developers) knew how to administer it. Only I knew how to administer Apache. > > The down side is that it requires a programmer to make the most of it and > the interface is config file based, which not everyone is > comfortable with. Being on old SunOS (NOT Solaris) gearhead I can appreciate it. I still prefer to tweak my Win 2K box by editing the Win.ini file. > > My $.02 Thanks for sharing it. It gave me a few ideas to file away and suprise the CTO with. ;) > > Justin > > Justin Greene > Co-CEO > ClicVU, Inc. > 216 West 18th St., Floor 12 - NYC 10011 > P: 212-629-8900 - F: 212-629-9860 > http://www.clicvu.com > [snip] > ~~ 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: Best way to clear Cached Queries?
Yeah, a URL parameter! (Why didn't I think of that?)
I've already got my cache spans in variables (e.g. request.cacheSpan), so
this is a piece of cake.
mydomain.com/myPage.cfm?clearCache=1
___ application.cfm _
// snip
if (isdefined("url.clearCache")) {
request.cache_span = createtimespan(0,0,0,0);
}
// snip
So I can refresh the whole site, if need be, or piecemeal, as you explained.
Thanks, everyone, for the good solutions.
Jamie
On Fri, 01 Jun 2001 13:50:11 -0400, in cf-talk you wrote:
>Jamie,
>
>You could set a variable for the cachetime in Application.cfm or on the
page
>itself use that in query. Then use a flag variable passed along URL to
>indicate whether cached query needs to be cleared. If flag exists, then
>change cachetime to zero.
>
>Here's an example.
>
><-- set in app.cfm -->
>
>
><-- page with query>
>
>
>
>
>cachedwithin="#Variables.cachetimelimit#">
>
>
>Chris
>--
>Chris Lomvardias
>[EMAIL PROTECTED]
>Syscom, Inc.
>400 E. Pratt Street, Suite 300
>Baltimore, MD 21202
>(410)539-3737 x1722 voice
>(410)539-7302 fax
>[EMAIL PROTECTED] (pager via email)
>http://www.syscom.com/
>--
>
>
>-Original Message-
>From: Jamie Jackson [mailto:[EMAIL PROTECTED]]
>Sent: Friday, June 01, 2001 12:03 PM
>To: CF-Talk
>Subject: Best way to clear Cached Queries?
>
>
>What's the best way to clear out a cached query, so that your
>production site will use the most current database information? I want
>to retain my long cache spans on a production box, but I want to be
>able to "update" or "refresh" the queries at will.
>
>Here is my current process:
>1. Break the connection (give the datasource a faulty path/name) in
>the administrator.
>2. Hit the template in a browser.
>3. Repair the broken connection in the CF administrator.
>4. Hit the page again. The query is updated/re-cached.
>
>I don't like this method, because it is awkward, and it momentarily
>affects the production site. Is there a better way?
>
>Thanks,
>Jamie
>
~~
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: CFSET / UPDATE SQL
What happens if you use this code in query number 2? If it works, you might
have to explicitly call classID in a scoped variable ("variables.classID").
Maybe there's a conflict with classID in another scope?
>
> UPDATE ClassRegistration
> SET
> ClassSchedID=#getWaitingStudent.WaitList#,
> WaitList=NULL,
> ModifiedDate=#Now()#
> WHERE RegistrationID='#RegID#'
>
Also, be sure to look at the source code of the CF error, just to be sure
there are no meta characters that the browser is hiding (in the SQL
statement).
Good luck,
Jamie
-Original Message-
From: David Clay [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 01, 2001 4:28 PM
To: Jamie Jackson
Subject: Re: CFSET / UPDATE SQL
I get he correct answer. It, for some reason, is not putting the value in
the UPDATE query.
Dave Clay
Internet Facilitator
Trus Joist, A Weyerhaeuser Business
5995 Greenwood Plaza Blvd, Suite 100
Greenwood Village, CO 80111
303.770.8506
>>> [EMAIL PROTECTED] 06/01/01 10:21AM >>>
See below:
On Thu, 31 May 2001 16:12:03 -0600, "David Clay" <[EMAIL PROTECTED]>
wrote:
>Can anyone tell me why the #ClassID# in the UPDATE Query is always coming
up as a blank space, thus producing an error.
>
>Code below:
>
>
> SELECT ClassSchedID, InputDate, WaitList, RegistrationID
> FROM ClassRegistration
> WHERE InputDate (SELECT MIN(InputDate)
> FROM ClassRegistration
> WHERE ClassSchedID=9)
>
getWaitingStudent.WaitList='#getWaitingStudent.WaitList#'
>
>
>
>
> UPDATE ClassRegistration
> SET
> ClassSchedID=#ClassID#,
> WaitList=NULL,
> ModifiedDate=#Now()#
> WHERE RegistrationID='#RegID#'
>
>
>Dave Clay
>Internet Facilitator
>Trus Joist, A Weyerhaeuser Business
>5995 Greenwood Plaza Blvd, Suite 100
>Greenwood Village, CO 80111
>303.770.8506
>
>
>
>
~~
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
IsDate() with NULL's inside a loop!!
Got another good one. I'm doing an IsDate() function for a cfif statement, inside a cfloop-query. The problem is that the cfif's will not function properly if there are NULL's in the data. Any suggestins would be nice... Here is the code: #IsDate(qTMPPull.OpenDate)#-#OpenDate#-a#qTMPPull.OpenDate#- #IsDate(qTMPPull.LastBilled)#-#LastBilled#-b #IsDate(qTMPPull.CloseDate)#-#CloseDate#-here ... THIS is what it returns: NO--a- NO--b NO--here Any ideas Sincerely, Matthew M. Eschenbaum Allaire Certified Professional DevTech Inc. [EMAIL PROTECTED] 206.956.0888 www.dev-tech.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
CFFTP Exist Problem
I have code to check for the existence of a file which work fine in CF 4.0 but only always returns a 'NO' in CF 4.5. Has anyone else encountered this problem and/or could offer some advise? Thanks Jan ~~ 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: Removing items from the shopping basket?
Michel, If you are going to use queries than there is no clean way to remove rows - best bet would be to have another column with an "active" flag. To delete you just set it to 0 and then ignore it in further processing. The only way to actually remove a row is to copy the query except for that row (which would not be efficient). If you use arrays or structures (for example) then you could remove rows easily. --- Ben -Original Message- From: Michel Gagnon [mailto:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 2:03 PM To: CF-Talk Subject: Removing items from the shopping basket? Hi! I've got a shopping basket going: But I can't find the instructions on how to delete items from the basket. ~~ 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: [Apache and trailing back slash]
left(length_of_the_string - 1) sebastian palmigiani <[EMAIL PROTECTED]> wrote: I do not understand why you get trailing back slash when using GetDirectoryFromPath with Apache web server #GetDirectoryFromPath(CGI.CF_TEMPLATE_Path)# In other words I get c:/program files/apache group/apache/htdocs/members/om/archive/adu/\ Why is there a trailing back slash? How do I get rid of it? Sebastian ~~ 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: Updating multiple rows!
Try using PART_ID =751 OR PART_ID =752 instead of PART_ID =751 AND PART_ID =752 or try
PART_ID IN ('751,752')
not sure if that is correct syntax off the top of my head.
Mark Smyth wrote:
>
> Ben
>
> your code there is trying to update a product which has a productId of 751
> AND 752
>
> it won't find it
> HTH
> Mark
>
> -Original Message-
> From: Ben Densmore [mailto:[EMAIL PROTECTED]]
> Sent: 01 June 2001 16:25
> To: CF-Talk
> Subject: Updating multiple rows!
>
> I am trying to update multiple rows at once and I don't seem to get any
> errors but when I try to get the info I just updated nothing is there. Can
> someone tell me if this Query should work?
>
>
> Update BiosPart
> SET VGA_Rom = 'PCI'
> WHERE
> Part_ID = 751
> AND
> PART_ID = 752 etc...
>
> Thanks,
> Ben
>
>
>
~~
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: CFLOCK syntax with CF4.0
I always though it was NAME="#Session.SessionID#" and NAME="#Application.ApplicationName#". Notice the pounds. === Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] ICQ UIN : 3679482 "My ally is the Force, and a powerful ally it is." - Yoda > -Original Message- > From: Chris Norloff [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 01, 2001 1:20 PM > To: CF-Talk > Subject: Re: CFLOCK syntax with CF4.0 > > > For 4.0 use Name="session.sessionId" for session variables and > Name="Application.ApplicationName" for application variables. > This works in both 4.0 & 4.5, though you can't use Full Checking > in 4.5 because it's not compatible with the Name scope (you can > still use Auto Read Locking if you want to). > > 4.0 vs. 4.5 is covered in "Changes to CFLOCK in CF server 4.5", > knowledgebase article 14165 > > > 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: Brain isn't working yet...
I use: Allow action Quite a bit easier I think. - BILL - -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 10:00 AM To: CF-Talk Subject: Re: Brain isn't working yet... or the numerous ways you could do it: or or and I can't be bothered to think of more as it's getting very silly! Enjoy Paul ;-) -Original Message- From: Paul Johnston <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Date: 01 June 2001 16:54 Subject: Re: Brain isn't working yet... >how about a regular expression? > > > > >or something like that! > >Paul >-Original Message- >From: Marcus <[EMAIL PROTECTED]> >To: CF-Talk <[EMAIL PROTECTED]> >Date: 01 June 2001 16:14 >Subject: Brain isn't working yet... > > >>I'm trying to provide functionality to a select group of people on a >>specific subnet. What I'd like to do is something along the lines of.. >> >> >> Allow action >> >> >>The thing being they use dhcp to allocate IP's and the address could >>actually be any of the block. Is there a wild card I can use? or some other >>way to not specify the last number? >> >>Marcus >> >> >> > ~~ 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
Unknown Parser Error
On a shared hosting service, we're getting a lot of (intermittent) errors like this: Just in time compilation error unknown parser error The error then points to the very first character of the first line of the template, so that seems spurious. CF-Talk archives show numerous similar reports, but very little in the way of possible causes. The same code runs fine on our development server. Any suggestions appreciated! Gene Kraybill ~~ 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: IIS or Apache? (WAS RE: can anyone help?)
We have been running Apache with CF 4.5 on NT 4 for the last 2 year under very heavy load and have found no stability problems that were related to Apache. Additionally, because of the open API of apache we have been able to do some very interesting things for scale and reliability: 1. Run 2 instances of apache on each web server. One handles all CF requests and one handles all static requests (images mostly). We have found that apache can serve over 500 14K files per second on a dual PIII 600 (we were actually bottlenecked by the 100mb network. With 1K files we hit about 750/sec). Running 2 instances of apache allows us to have cold fusion under load and not slow down the delivery of all the images required to complete the page. 2. Create modules to handle high load. We build pages in CF, then if the page is seeing more load than CF can handle, we write an apache module in C++ to handle that one function and use the Apache handler to intercept the ..cfm request, check if we have a custom handler for the page, handle it if we do, and pass it on to CF if we do not. This is, BTW how we are able to set cookies during a server side redirect. 3. Bind different virtual hosts to different ports (I do not use IIS so I do not know if yuo can do this or not). Our webserver has a single IP and each host is a different high port (8080, 8081,8082, etc). We handle the redirection from different external IP's to a single Internal IP, different port either in the firewall or the load balancer. This allows the adding/removing of hosts without re-ip'ing the web server and limits the number of IP addresses which is important for some firewall licensing schemes. We are firm believers in the KISS principle (keep it simple stupid). Apache is pretty simple, we upgrade when we want to, and it does not try to hook into too many OS functions that may cause issues. The down side is that it requires a programmer to make the most of it and the interface is config file based, which not everyone is comfortable with. My $.02 Justin Justin Greene Co-CEO ClicVU, Inc. 216 West 18th St., Floor 12 - NYC 10011 P: 212-629-8900 - F: 212-629-9860 http://www.clicvu.com - Sign up for your free Spamex account: http://www.spamex.com Protect your real email address forever - -Original Message- From: Zac [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 11:21 PM To: CF-Talk Subject: RE: IIS or Apache? (WAS RE: can anyone help?) > I would recomment sticking with IIS on an NT box. With CF > and Apache, there > were (at least for me) a bunch of bugs. Well I think this is one of those YMMV moments. I ran Apache, CF 4.5 and mySQL on an NT4 server for months with no problems at all. And it was, YMMV again, more stable than when I was running IIS. ~~ 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: Updating multiple rows!
Why not do: Update BiosPart SET VGA_Rom = 'PCI' WHERE Part_ID > 751 Update BiosPart SET VGA_Rom = 'PCI' WHERE Part_ID BETWEEN 751 AND whatever That's assuming you are updating them all within a range. -Original Message- From: Jann VanOver [mailto:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 12:37 PM To: CF-Talk Subject: RE: Updating multiple rows! Logic error -- do you have any records where the part_id is 751 AND 752? Change "Part_ID = 751 AND PART_ID = 752" to "Part_ID IN (751,752...)" -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 8:25 AM To: CF-Talk Subject: Updating multiple rows! I am trying to update multiple rows at once and I don't seem to get any errors but when I try to get the info I just updated nothing is there. Can someone tell me if this Query should work? Update BiosPart SET VGA_Rom = 'PCI' WHERE Part_ID = 751 AND PART_ID = 752 etc... Thanks, Ben ~~ 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: IIS or Apache? (WAS RE: can anyone help?)
That is true. Hopefully by the time it gets out of beta. :) Even the mod_php and mod_ssl don't work yet (as far as I know). Another nice thing I saw was that the new module API allows you to add protocols. Maybe someone can add FTP and SMTP modules and give Apache the functionality that IIS has. 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: Dave Watts [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 01, 2001 11:04 > To: CF-Talk > Subject: RE: IIS or Apache? (WAS RE: can anyone help?) > > > > I haven't had any problems myself, but I did see the > > performance degrade while Apache was under a load. I > > have read that this is because Apache 1.3 for NT is not > > multithreaded. Apparently this is fixed in Apache 2.0. I'm > > going to download the alpha version and test it out. I just > > need to figure out how to compile the bugger. I haven't > > worked with gcc for so long, I've fogotten how to use it. :) > > I don't know for sure, but I don't think the CF module for Apache > 1.3.x will > work with Apache 2. I don't know if and/or when Macromedia plans on > providing an Apache 2 compatible module. > > 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
Removing items from the shopping basket?
Hi! I've got a shopping basket going: But I can't find the instructions on how to delete items from the basket. ~~ 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: Best way to clear Cached Queries?
Jamie, You could set a variable for the cachetime in Application.cfm or on the page itself use that in query. Then use a flag variable passed along URL to indicate whether cached query needs to be cleared. If flag exists, then change cachetime to zero. Here's an example. <-- set in app.cfm --> <-- page with query> Chris -- Chris Lomvardias [EMAIL PROTECTED] Syscom, Inc. 400 E. Pratt Street, Suite 300 Baltimore, MD 21202 (410)539-3737 x1722 voice (410)539-7302 fax [EMAIL PROTECTED] (pager via email) http://www.syscom.com/ -- -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 12:03 PM To: CF-Talk Subject: Best way to clear Cached Queries? What's the best way to clear out a cached query, so that your production site will use the most current database information? I want to retain my long cache spans on a production box, but I want to be able to "update" or "refresh" the queries at will. Here is my current process: 1. Break the connection (give the datasource a faulty path/name) in the administrator. 2. Hit the template in a browser. 3. Repair the broken connection in the CF administrator. 4. Hit the page again. The query is updated/re-cached. I don't like this method, because it is awkward, and it momentarily affects the production site. Is there a better way? Thanks, Jamie ~~ 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: Best way to clear Cached Queries?
Just run your query again with cachedwithin="#CreateTimeSpan(0,0,0,0)#" I take the lazy way out. When building an app I set a request.QueryCacheTime value to whatever desired and then simply reference that in my queries where appropriate. When data is updated I reset request.QueryCacheTime to zero and call the query again to flush it. Next time someone runs that query it gets cached with the new data. Of course, having your query files seperated in good FuseBox fashion (hint, hint, http://www.fusebox.org) makes the whole process much simpler since the query needs to be exactly identical each time called...no extra spaces anywhere. Ken -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 12:03 PM To: CF-Talk Subject: Best way to clear Cached Queries? What's the best way to clear out a cached query, so that your production site will use the most current database information? I want to retain my long cache spans on a production box, but I want to be able to "update" or "refresh" the queries at will. Here is my current process: 1. Break the connection (give the datasource a faulty path/name) in the administrator. 2. Hit the template in a browser. 3. Repair the broken connection in the CF administrator. 4. Hit the page again. The query is updated/re-cached. I don't like this method, because it is awkward, and it momentarily affects the production site. Is there a better way? Thanks, Jamie ~~ 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: Updating multiple rows!
Use the IN keyword. Update BiosPart SET VGA_Rom = 'PCI' WHERE Part_ID IN (751,752) I cant remember off the top of my head if there needs to be single quotes around the values in the parentheses. jon - Original Message - From: "Ben Densmore" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 01, 2001 11:24 AM Subject: Updating multiple rows! > I am trying to update multiple rows at once and I don't seem to get any errors but when I try to get the info I just updated nothing is there. Can someone tell me if this Query should work? > > > Update BiosPart > SET VGA_Rom = 'PCI' > WHERE > Part_ID = 751 > AND > PART_ID = 752 etc... > > Thanks, > Ben > > > > > > > ~~ 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: Best way to clear Cached Queries?
I've used two methods. 1) Use a variable in the CreateTimeSpan which holds the number of minutes or hours that you want the cache to last. To force the query to execute, change this variable to 0, hit the page, and then restore the variable back to the proper value. 2) Add the following code to application.cfm: Change your queries to add this to the WHERE clause: #request.cacheKiller# = #request.cacheKiller# Create a page which will assign a new value to application.cacheKiller. Hit this page and then hit any page with a cached query. They will then be reloaded until you change the cacheKiller variable. The reason they reload is that the SQL has changed (but the result set will not change). Craig > -Original Message- > From: Jamie Jackson [SMTP:[EMAIL PROTECTED]] > Sent: Friday, June 01, 2001 12:03 PM > To: CF-Talk > Subject: Best way to clear Cached Queries? > > What's the best way to clear out a cached query, so that your > production site will use the most current database information? I want > to retain my long cache spans on a production box, but I want to be > able to "update" or "refresh" the queries at will. > > Here is my current process: > 1. Break the connection (give the datasource a faulty path/name) in > the administrator. > 2. Hit the template in a browser. > 3. Repair the broken connection in the CF administrator. > 4. Hit the page again. The query is updated/re-cached. > > I don't like this method, because it is awkward, and it momentarily > affects the production site. Is there a better way? > > Thanks, > Jamie > > > > > > ~~ 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
Apache and trailing back slash
I do not understand why you get trailing back slash when using GetDirectoryFromPath with Apache web server #GetDirectoryFromPath(CGI.CF_TEMPLATE_Path)# In other words I get c:/program files/apache group/apache/htdocs/members/om/archive/adu/\ Why is there a trailing back slash? How do I get rid of it? Sebastian ~~ 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
LDAP and binary files
Hello everybody: I have been going through the archives but with no success I need to query a LDAP directory for a user and show their picture. I execute the LDAP query but I am not able to show the picture information (JPEG file). Then, if I try to output the JPEGPHOTO all I see on the screen is 'ÿØÿà ' which, if I try to TOBINARY() I get the first 5 characters of the image file. The problem and the question is - why I am getting only the first 5 characters (in TOBASE64 format) of the JPEG image. Am I missing something? Thanks for the help. ~~ 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: Updating multiple rows!
Ben your code there is trying to update a product which has a productId of 751 AND 752 it won't find it HTH Mark -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED]] Sent: 01 June 2001 16:25 To: CF-Talk Subject: Updating multiple rows! I am trying to update multiple rows at once and I don't seem to get any errors but when I try to get the info I just updated nothing is there. Can someone tell me if this Query should work? Update BiosPart SET VGA_Rom = 'PCI' WHERE Part_ID = 751 AND PART_ID = 752 etc... Thanks, Ben ~~ 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: CFLOCK syntax with CF4.0
For 4.0 use Name="session.sessionId" for session variables and Name="Application.ApplicationName" for application variables. This works in both 4.0 & 4.5, though you can't use Full Checking in 4.5 because it's not compatible with the Name scope (you can still use Auto Read Locking if you want to). 4.0 vs. 4.5 is covered in "Changes to CFLOCK in CF server 4.5", knowledgebase article 14165 Chris Norloff -- Original Message -- From: "JoshMEagle" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Wed, 30 May 2001 15:27:12 -0400 >HELP! > >I've been developing sites on a 4.5 server for a while, and now I have to >alter some code to run on 4.0 server I'm using CFLOCK extensively to >lock SESSION variables using SCOPE="SESSION" but 4.0 chokes and says SCOPE >is not allowed, only NAME, THROWONTIMEOUT, TIMEOUT & TYPE what syntax >do I use for 4.0? Do I replace SCOPE with NAME??? >THANKS! > >Joshua Miller >Web Development >Eagle Technologies Group >Technology Solutions for the Next Generation >www.eagletgi.com >[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: session and client variables
Paul, When a cookie is created with no expiration it is destroyed when the browser is closed. This is referred to as a 'session cookie'. -- Tim Bahlke > -Original Message- > From: Paul Johnston [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 01, 2001 11:38 AM > To: CF-Talk > Subject: Re: session and client variables > > > All you appear to be doing is reading and writing the cookies. > > Exactly how does this stop the user closing the browser and > not having the > cookie's destroyed? > > When the user re-starts the browser and goes to that page, > the cookies still > exist (as far as I can tell). > > Paul ~~ 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: session and client variables
Hi paul since the expires attribute of cfcookie is left out, it defaults to never, this means that as soon as the browser is closed and the cookies will be deleted HTH Mark -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: 01 June 2001 16:38 To: CF-Talk Subject: Re: session and client variables All you appear to be doing is reading and writing the cookies. Exactly how does this stop the user closing the browser and not having the cookie's destroyed? When the user re-starts the browser and goes to that page, the cookies still exist (as far as I can tell). Paul -Original Message- From: Andy Ewings <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Date: 01 June 2001 16:47 Subject: RE: session and client variables >Paul > >Put this in your application.cfm: > > > > > > > > >This will ensure that whenever they close the broswer the session is killed >(or rather their link to the set of client vars is broken). The client vars >weill then get destroyed when the timeout is reached. > >-Original Message- >From: Paul Johnston [mailto:[EMAIL PROTECTED]] >Sent: 01 June 2001 16:02 >To: CF-Talk >Subject: session and client variables > > >Anyone, > >I have come up with a slight issue in the past, and it is this: > >If you are using client variables for a secure section of a website and they >have a timeout (say 10 minutes). The users closes the browser thinking that >they have logged out (when they haven't) and the cookies (let's assume >cookies here) get destroyed by an onunload="" event. The logout script >destroys the cookies when the user leaves the secure section, so we don't >worry about that. > >Bearing in mind that an onunload event doesn't work consistently in all >browsers (it's a known bug in Netscape) does anyone have a solution (barring >recoding of the site to use the urltoken), for destroying the cookies in the >users browser that works cross-browser (ie Netscape 4+, IE 4+ and Netscape >6)? > >The problem is that it is entirely possible (and sensible) that the cookie >should stay on the user machine if they come back to the site so that they >are logged in (assuming the ten minutes isn't up), but what if they are in >an internet cafe and the ten minutes aren't up? > >(Let's assume we're using a clustered server here so session variables >become virtually pointless... or do they?) > >Any replies welcome (ie sensible ones). > >Paul > ~~ 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: How many dimensions in a given array?
IsArray(variable) tells you if a given variable is an array... Since a 2D array is simply an array of an array, then IsArray(variable[1]) will tell you if the given variable has a second dimension (or at least one in the first element). Likewise, IsArray(variable[1][1]) would tell you if it was a 3D array. Hope this helps Norman Elton -Original Message- From: JoshMEagle [mailto:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 11:24 AM To: CF-Talk Subject: How many dimensions in a given array? How do I test to see how many dimensions a given array posseses? This method gives me all the values of a 2 dimensional array, but I need to know if it's a 2D array BEFORE I try this ... unless someone knows a craftier way... ??? #array[a][aD]# Any help appreciated! Joshua Miller Web Development Eagle Technologies Group Technology Solutions for the Next Generation www.eagletgi.com [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: Updating multiple rows!
You need to use OR instead of AND...you are asking it to find a row where Part_ID is both 751 AND 752... You could also say WHERE part_ID IN (751,752) D * Diana Nichols Webmistress http://www.lavenderthreads.com 770.434.7374 "One man's magic is another man's engineering." ---Lazarus Long -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 11:25 AM To: CF-Talk Subject: Updating multiple rows! I am trying to update multiple rows at once and I don't seem to get any errors but when I try to get the info I just updated nothing is there. Can someone tell me if this Query should work? Update BiosPart SET VGA_Rom = 'PCI' WHERE Part_ID = 751 AND PART_ID = 752 etc... Thanks, Ben ~~ 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: Updating multiple rows!
Hey Ben, If you're updating one field in multiple rows with the same constant value, then you'll want to use OR in your WHERE statement, right? If you're updating multiple rows with values from a form, then you'll have to have unique form field names for each row and loop through the query on your action page. Here's an example updating multiple rows in an inventory: UPDATE Inventory SET sln='#thissln#', product='#thisproduct#', nsn='#thisnsn#', manufacturer='#thismanufacturer#', containersize='#thiscontainersize#', quantity='#thisquantity#', RO='#thisro#', ROP='#thisrop#', date_updated=#createodbcdate(thisdate_updated)# WHERE id=#thisid# HOpe this helps - probably overkill, but when I find a question I can answer I get all giddy and happy :-) Erika - Original Message - From: "Ben Densmore" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 01, 2001 9:24 AM Subject: Updating multiple rows! : I am trying to update multiple rows at once and I don't seem to get any errors but when I try to get the info I just updated nothing is there. Can someone tell me if this Query should work? : : : Update BiosPart : SET VGA_Rom = 'PCI' : WHERE : Part_ID = 751 : AND : PART_ID = 752 etc... : : Thanks, : Ben : : : : : : : ~~ 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: Updating multiple rows!
Logic error -- do you have any records where the part_id is 751 AND 752? Change "Part_ID = 751 AND PART_ID = 752" to "Part_ID IN (751,752...)" -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 8:25 AM To: CF-Talk Subject: Updating multiple rows! I am trying to update multiple rows at once and I don't seem to get any errors but when I try to get the info I just updated nothing is there. Can someone tell me if this Query should work? Update BiosPart SET VGA_Rom = 'PCI' WHERE Part_ID = 751 AND PART_ID = 752 etc... Thanks, Ben ~~ 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 records
Lets say I have 12 records but I want to display only 3 so I use maxrows 3 in the cfoutput. Is there a way to get 3 random records from the query? Like order by random or something? Rich ~~ 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: session and client variables
Just to combine my last post and Dave's - Dave is right - you need to set the cookie with no expire time. The only problem is that if you switch on Clientmanagement and leave the rest to CF it writes the cookies CFID and CFTOKEN to the users browser with an expiry time equal to that of the CF Server setting or that in your application cfm. However if you overwrite this with the code I posted it sets 2 custom cookies of the same names with no expiry specified - this way the cookies get killed when the browser is closed. A -Original Message- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: 01 June 2001 16:25 To: CF-Talk Subject: Re: session and client variables If you set the cookie with no expire time, the cookie is destroyed when the browser closes, in both IE and NN. Now, the security for the app should be that both session on server and cookie on client must be present for there to be a logged in condition. If either is missing, a login must occur. As for walking away from a terminal in an internet cafe, leaving it up and not logging out, you cannot control that. If it's within the timeout of the session/client vars, then shame on the user. You cannot write a web application that will protect folks from their own ignorance. That's no different that someone walking away from a dumb terminal leaving an application up and running. Dave - Original Message - From: "Paul Johnston" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 01, 2001 11:01 AM Subject: session and client variables Anyone, I have come up with a slight issue in the past, and it is this: If you are using client variables for a secure section of a website and they have a timeout (say 10 minutes). The users closes the browser thinking that they have logged out (when they haven't) and the cookies (let's assume cookies here) get destroyed by an onunload="" event. The logout script destroys the cookies when the user leaves the secure section, so we don't worry about that. Bearing in mind that an onunload event doesn't work consistently in all browsers (it's a known bug in Netscape) does anyone have a solution (barring recoding of the site to use the urltoken), for destroying the cookies in the users browser that works cross-browser (ie Netscape 4+, IE 4+ and Netscape 6)? The problem is that it is entirely possible (and sensible) that the cookie should stay on the user machine if they come back to the site so that they are logged in (assuming the ten minutes isn't up), but what if they are in an internet cafe and the ten minutes aren't up? (Let's assume we're using a clustered server here so session variables become virtually pointless... or do they?) Any replies welcome (ie sensible ones). Paul ~~ 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: Updating multiple rows!
Shouldn't it be WHERE Part_ID = 751 OR PART_ID = 752 (Im assuming that each part can only have one Part_id) -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 11:25 AM To: CF-Talk Subject: Updating multiple rows! I am trying to update multiple rows at once and I don't seem to get any errors but when I try to get the info I just updated nothing is there. Can someone tell me if this Query should work? Update BiosPart SET VGA_Rom = 'PCI' WHERE Part_ID = 751 AND PART_ID = 752 etc... Thanks, Ben ~~ 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 executing stored procedures?
I have come across an interesting occurrence where CF mysteriously started to fail on a Stored procedure. The storedProc was working fine for a while and now it doesn't. The storedProc is executed in a cfquery (there seems to be an issue with the cfstoredproc tag and paraming timestamps), anyways it executes in SQL QUERY ANALYZER just fine. The SQL statement is good and generates no errors. Sometimes CF will leave an open pipe to the db server and lock up the database for 45 minutes. Anyone have any suggestions? Environment: NT 4.0 sp5 CF 4.5.2 MDAC 2.5.13 DataSource is setup as OLEDB NT4.0 sp5 SQL7.0 Located on same network. Sincerely, Matthew M. Eschenbaum Allaire Certified Professional DevTech Inc. [EMAIL PROTECTED] 206.956.0888 www.dev-tech.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
Best way to clear Cached Queries?
(Please pardon the doubled post, newsgroup users) What's the best way to clear out a cached query, so that your production site will use the most current database information? I want to retain my long cache spans on a production box, but I want to be able to "update" or "refresh" the queries at will. Here is my current process: 1. Break the connection (give the datasource a faulty path/name) in the administrator. 2. Hit the template in a browser. 3. Repair the broken connection in the CF administrator. 4. Hit the page again. The query is updated/re-cached. I don't like this method, because it is awkward, and it momentarily affects the production site. Is there a better way? Thanks, Jamie ~~ 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
CFHTTP post to a post
I have a template which executes a cfhttp post to a cgi script that then post to another cgi script. I want to get the results from this 2nd cgi script. When I read the cfhttp.filecontent I am seeing the results of the first cgi script. Does anyone know of a way where I can use a cfhttp post and read the results from that second cgi script? Thanks, Tim Bahlke ~~ 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: CFSET / UPDATE SQL
See below: On Thu, 31 May 2001 16:12:03 -0600, "David Clay" <[EMAIL PROTECTED]> wrote: >Can anyone tell me why the #ClassID# in the UPDATE Query is always coming up as a >blank space, thus producing an error. > >Code below: > > > SELECT ClassSchedID, InputDate, WaitList, RegistrationID > FROM ClassRegistration > WHERE InputDate (SELECT MIN(InputDate) > FROM ClassRegistration > WHERE ClassSchedID=9) > getWaitingStudent.WaitList='#getWaitingStudent.WaitList#' > > > > > UPDATE ClassRegistration > SET > ClassSchedID=#ClassID#, > WaitList=NULL, > ModifiedDate=#Now()# > WHERE RegistrationID='#RegID#' > > >Dave Clay >Internet Facilitator >Trus Joist, A Weyerhaeuser Business >5995 Greenwood Plaza Blvd, Suite 100 >Greenwood Village, CO 80111 >303.770.8506 > > > > ~~ 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: CFSET / UPDATE SQL
See below: On Thu, 31 May 2001 16:12:03 -0600, "David Clay" <[EMAIL PROTECTED]> wrote: >Can anyone tell me why the #ClassID# in the UPDATE Query is always coming up as a >blank space, thus producing an error. > >Code below: > > > SELECT ClassSchedID, InputDate, WaitList, RegistrationID > FROM ClassRegistration > WHERE InputDate (SELECT MIN(InputDate) > FROM ClassRegistration > WHERE ClassSchedID=9) > getWaitingStudent.WaitList='#getWaitingStudent.WaitList#' > > > > > UPDATE ClassRegistration > SET > ClassSchedID=#ClassID#, > WaitList=NULL, > ModifiedDate=#Now()# > WHERE RegistrationID='#RegID#' > > >Dave Clay >Internet Facilitator >Trus Joist, A Weyerhaeuser Business >5995 Greenwood Plaza Blvd, Suite 100 >Greenwood Village, CO 80111 >303.770.8506 > > > > ~~ 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: Updating multiple rows!
Change your AND(s) to OR(s). Steven Semrau SRA International, Inc. Senior Member, Professional Staff [EMAIL PROTECTED] [EMAIL PROTECTED] Com: (703) 805-1095 DSN: (703) 655-1095 -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 11:25 AM To: CF-Talk Subject: Updating multiple rows! I am trying to update multiple rows at once and I don't seem to get any errors but when I try to get the info I just updated nothing is there. Can someone tell me if this Query should work? Update BiosPart SET VGA_Rom = 'PCI' WHERE Part_ID = 751 AND PART_ID = 752 etc... Thanks, Ben ~~ 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 with cf_uicalender
I've posted a modified version of the .fla file for the calender up on the Forum - works very well now in non-popup mode. Also has some usability tweaks that could be backported into the normal .fla if your feeling brave. ~~ 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
Best way to clear Cached Queries?
What's the best way to clear out a cached query, so that your production site will use the most current database information? I want to retain my long cache spans on a production box, but I want to be able to "update" or "refresh" the queries at will. Here is my current process: 1. Break the connection (give the datasource a faulty path/name) in the administrator. 2. Hit the template in a browser. 3. Repair the broken connection in the CF administrator. 4. Hit the page again. The query is updated/re-cached. I don't like this method, because it is awkward, and it momentarily affects the production site. Is there a better way? Thanks, Jamie ~~ 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: Brain isn't working yet...
or the numerous ways you could do it: or or and I can't be bothered to think of more as it's getting very silly! Enjoy Paul ;-) -Original Message- From: Paul Johnston <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Date: 01 June 2001 16:54 Subject: Re: Brain isn't working yet... >how about a regular expression? > > > > >or something like that! > >Paul >-Original Message- >From: Marcus <[EMAIL PROTECTED]> >To: CF-Talk <[EMAIL PROTECTED]> >Date: 01 June 2001 16:14 >Subject: Brain isn't working yet... > > >>I'm trying to provide functionality to a select group of people on a >>specific subnet. What I'd like to do is something along the lines of.. >> >> >> Allow action >> >> >>The thing being they use dhcp to allocate IP's and the address could >>actually be any of the block. Is there a wild card I can use? or some other >>way to not specify the last number? >> >>Marcus >> >> >> > ~~ 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: IIS or Apache? (WAS RE: can anyone help?)
> I haven't had any problems myself, but I did see the > performance degrade while Apache was under a load. I > have read that this is because Apache 1.3 for NT is not > multithreaded. Apparently this is fixed in Apache 2.0. I'm > going to download the alpha version and test it out. I just > need to figure out how to compile the bugger. I haven't > worked with gcc for so long, I've fogotten how to use it. :) I don't know for sure, but I don't think the CF module for Apache 1.3.x will work with Apache 2. I don't know if and/or when Macromedia plans on providing an Apache 2 compatible module. 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: FireWorks and Graphics
Or use something like DreamWeaver which intergrates well with (for instance) FireWorks (and I assume Freehand) and really doesnt care. ~~ 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: Brain isn't working yet...
I tried refind, and it didn't want to work at all. Contains works great! Marcus > > Will do the trick, but you really need to use REfind and anchor the string > to the start. ~~ 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
Stopping malicious file uploads
Hi I have an app which lets users upload a file, is there anyway to stop a malicious user uploading say a 2gig file before it gets to my server? Also if i wanted the upload to have a maximum time out how would i do it? Would I need to use cflock? Thanks in advance Kola ~~ 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: Crazy Dynamic Update/FORM Structure question
You can use this code to examine your form field string. Change "myString" to your variable. IndexCharacterASCII #iChar##Mid(myString,iChar,1)##Asc( Mid(myString,iChar,1))# And here's an ASCII chart: http://www.jimprice.com/jim-asc.htm -David On Friday, June 01, 2001 8:12 AM, Willy Ray [SMTP:[EMAIL PROTECTED]] wrote: > Good questions. The data type of the field is (MS Access) Memo. The string > is about 1400 characters. But I've been doodling around this morning with > it, and I've gotten it to take strings up to 2500 characters. The problem > seems to be that I'm passing some sort of carriage return that's mucking up > my statement. If I could just find and replace it, but I can't even figure > out what the character is... > > > > >>> [EMAIL PROTECTED] 6/1/01 8:51:54 AM >>> > what's the data type of the field objectcontent and exactly how long is your > string? > > -Original Message- > From: Willy Ray [mailto:[EMAIL PROTECTED]] > Sent: 01 June 2001 15:40 > To: CF-Talk > Subject: Re: Crazy Dynamic Update/FORM Structure question > > > Ok, I tried plugging the content into a test update statement that I knew > was working. Bombed out. Same error. There's either something in my text > string that's causing a failure, or access/ODBC won't accept that big of a > string. Any thoughts on making it do this? > > Willy > > >>> [EMAIL PROTECTED] 5/31/01 2:10:41 PM >>> > > Ok, I'm having some trouble here. I don't know what the form looks like, as > it's being generated dynamically. So, I figure, I'll have to loop through > the FORM structure, and run a seperate update for each form element. > > Here's what I'm doing: > > > > > UPDATE contentitems > SET objectcontent='#form["#i#"]#' > WHERE objectname='#i#' > AND page='#FORM.page#' > > > > > Now the first element of the loop it will hit will be a field from the form > called "Body." It's the first possibility, alphabetically. And value is > going to be a really long string of text. I've set "page" on the form > earlier on. > > It should come out like this: > > UPDATE contentitems > SET objectcontent = 'great big long string of text...' > WHERE objectname = 'BODY' > AND page = '1' > > And it does, but I get an error: > > ODBC Error Code = 37000 (Syntax error or access violation) > > > [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in > query expression "great big long string of text running out to a point at > which it gets truncat' > > Then it shows my sql, and it really does look like I had hope it would...Am > I just missing something in my update statement? > > Willy > ~~ 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: session and client variables
All you appear to be doing is reading and writing the cookies. Exactly how does this stop the user closing the browser and not having the cookie's destroyed? When the user re-starts the browser and goes to that page, the cookies still exist (as far as I can tell). Paul -Original Message- From: Andy Ewings <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Date: 01 June 2001 16:47 Subject: RE: session and client variables >Paul > >Put this in your application.cfm: > > > > > > > > >This will ensure that whenever they close the broswer the session is killed >(or rather their link to the set of client vars is broken). The client vars >weill then get destroyed when the timeout is reached. > >-Original Message- >From: Paul Johnston [mailto:[EMAIL PROTECTED]] >Sent: 01 June 2001 16:02 >To: CF-Talk >Subject: session and client variables > > >Anyone, > >I have come up with a slight issue in the past, and it is this: > >If you are using client variables for a secure section of a website and they >have a timeout (say 10 minutes). The users closes the browser thinking that >they have logged out (when they haven't) and the cookies (let's assume >cookies here) get destroyed by an onunload="" event. The logout script >destroys the cookies when the user leaves the secure section, so we don't >worry about that. > >Bearing in mind that an onunload event doesn't work consistently in all >browsers (it's a known bug in Netscape) does anyone have a solution (barring >recoding of the site to use the urltoken), for destroying the cookies in the >users browser that works cross-browser (ie Netscape 4+, IE 4+ and Netscape >6)? > >The problem is that it is entirely possible (and sensible) that the cookie >should stay on the user machine if they come back to the site so that they >are logged in (assuming the ten minutes isn't up), but what if they are in >an internet cafe and the ten minutes aren't up? > >(Let's assume we're using a clustered server here so session variables >become virtually pointless... or do they?) > >Any replies welcome (ie sensible ones). > >Paul > ~~ 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: Brain isn't working yet...
Allow action -Original Message- From: Marcus [mailto:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 10:56 AM To: CF-Talk Subject: Brain isn't working yet... I'm trying to provide functionality to a select group of people on a specific subnet. What I'd like to do is something along the lines of.. Allow action The thing being they use dhcp to allocate IP's and the address could actually be any of the block. Is there a wild card I can use? or some other way to not specify the last number? Marcus ~~ 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: Brain isn't working yet...
Take cgi.remote_addr as list with delimiter as '.', then it is easy. Chris [EMAIL PROTECTED] - Original Message - From: "Paul Johnston" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 01, 2001 4:09 PM Subject: Re: Brain isn't working yet... > how about a regular expression? > > > > > or something like that! > > Paul > -Original Message- > From: Marcus <[EMAIL PROTECTED]> > To: CF-Talk <[EMAIL PROTECTED]> > Date: 01 June 2001 16:14 > Subject: Brain isn't working yet... > > > >I'm trying to provide functionality to a select group of people on a > >specific subnet. What I'd like to do is something along the lines of.. > > > > > > Allow action > > > > > >The thing being they use dhcp to allocate IP's and the address could > >actually be any of the block. Is there a wild card I can use? or some other > >way to not specify the last number? > > > >Marcus > > > > > > > ~~ 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: Brain isn't working yet...
*This message was transferred with a trial version of CommuniGate(tm) Pro* You could parse the last octet of the IP address off and just use the first three to match the entire subnet. That is if their subnet is 255.255.255.0 . I didn't test this code but it would probaly go something like this. Allow action Hope that helps. Dave Livingston 512.694.1669 [EMAIL PROTECTED] -Original Message- From: Marcus [mailto:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 9:56 AM To: CF-Talk Subject: Brain isn't working yet... *This message was transferred with a trial version of CommuniGate(tm) Pro* I'm trying to provide functionality to a select group of people on a specific subnet. What I'd like to do is something along the lines of.. Allow action The thing being they use dhcp to allocate IP's and the address could actually be any of the block. Is there a wild card I can use? or some other way to not specify the last number? Marcus ~~ 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: Crazy Dynamic Update/FORM Structure question
Wait, I think I got it. There's a apostrophe (A.K.A. single quote) in my text string. That would do it, eh? What's the function I use to fix that? PreserveSingleQuote? Willy >>> [EMAIL PROTECTED] 6/1/01 8:51:54 AM >>> what's the data type of the field objectcontent and exactly how long is your string? -Original Message- From: Willy Ray [mailto:[EMAIL PROTECTED]] Sent: 01 June 2001 15:40 To: CF-Talk Subject: Re: Crazy Dynamic Update/FORM Structure question Ok, I tried plugging the content into a test update statement that I knew was working. Bombed out. Same error. There's either something in my text string that's causing a failure, or access/ODBC won't accept that big of a string. Any thoughts on making it do this? Willy >>> [EMAIL PROTECTED] 5/31/01 2:10:41 PM >>> Ok, I'm having some trouble here. I don't know what the form looks like, as it's being generated dynamically. So, I figure, I'll have to loop through the FORM structure, and run a seperate update for each form element. Here's what I'm doing: UPDATE contentitems SET objectcontent='#form["#i#"]#' WHERE objectname='#i#' AND page='#FORM.page#' Now the first element of the loop it will hit will be a field from the form called "Body." It's the first possibility, alphabetically. And value is going to be a really long string of text. I've set "page" on the form earlier on. It should come out like this: UPDATE contentitems SET objectcontent = 'great big long string of text...' WHERE objectname = 'BODY' AND page = '1' And it does, but I get an error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression "great big long string of text running out to a point at which it gets truncat' Then it shows my sql, and it really does look like I had hope it would...Am I just missing something in my update statement? Willy ~~ 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: session and client variables
If you set the cookie with no expire time, the cookie is destroyed when the browser closes, in both IE and NN. Now, the security for the app should be that both session on server and cookie on client must be present for there to be a logged in condition. If either is missing, a login must occur. As for walking away from a terminal in an internet cafe, leaving it up and not logging out, you cannot control that. If it's within the timeout of the session/client vars, then shame on the user. You cannot write a web application that will protect folks from their own ignorance. That's no different that someone walking away from a dumb terminal leaving an application up and running. Dave - Original Message - From: "Paul Johnston" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 01, 2001 11:01 AM Subject: session and client variables Anyone, I have come up with a slight issue in the past, and it is this: If you are using client variables for a secure section of a website and they have a timeout (say 10 minutes). The users closes the browser thinking that they have logged out (when they haven't) and the cookies (let's assume cookies here) get destroyed by an onunload="" event. The logout script destroys the cookies when the user leaves the secure section, so we don't worry about that. Bearing in mind that an onunload event doesn't work consistently in all browsers (it's a known bug in Netscape) does anyone have a solution (barring recoding of the site to use the urltoken), for destroying the cookies in the users browser that works cross-browser (ie Netscape 4+, IE 4+ and Netscape 6)? The problem is that it is entirely possible (and sensible) that the cookie should stay on the user machine if they come back to the site so that they are logged in (assuming the ten minutes isn't up), but what if they are in an internet cafe and the ten minutes aren't up? (Let's assume we're using a clustered server here so session variables become virtually pointless... or do they?) Any replies welcome (ie sensible ones). Paul ~~ 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
Updating multiple rows!
I am trying to update multiple rows at once and I don't seem to get any errors but when I try to get the info I just updated nothing is there. Can someone tell me if this Query should work? Update BiosPart SET VGA_Rom = 'PCI' WHERE Part_ID = 751 AND PART_ID = 752 etc... Thanks, Ben ~~ 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
How many dimensions in a given array?
How do I test to see how many dimensions a given array posseses? This method gives me all the values of a 2 dimensional array, but I need to know if it's a 2D array BEFORE I try this ... unless someone knows a craftier way... ??? #array[a][aD]# Any help appreciated! Joshua Miller Web Development Eagle Technologies Group Technology Solutions for the Next Generation www.eagletgi.com [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
login problems: proxy server the cause?
Hello all: A user has reported that when he logs in, he is immediately redirected to a session failed page. I am using an authorization routine that sets a user access level (like admin or user). The authorization/authentication routine has been tested on multiple browser/machine configurations at multiple locations and works for all but this user. I have also confirmed that the user has cookies enabled in IE 5.5. The user is at a company but doesn't know about their net configuration or access. My best guess is that he's behind a proxy server that screens for cookies. Any better ideas before I pursue this? Thanks, Marc Garrett ~~ 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:how to NOT get a cross join
the problme is in the where clause. the condition on the right side of the OR statemnet will always test true.. or .. i should say is potentially testing true. which is giving you your cartisian product. i suggest you use either a left join or an inner join (depending on wether you want nulls) in the from clause then put your other conditions in the where clause. ideally, it should look something like this: select * from categories left join emailAlerts on categories.categoryID=emailAlerts.categoryID where condition=value On Fri, 1 Jun 2001, Kola Oyedeji wrote: > > hi hope someone here can give me a hand with this:(sorry for the cross post) > > I have a table called categories, the key bieng an int, with a field for the > category name. > Another table called adverts, an advert has a category feild which is a > foreign key which links to the category table. > > I realised i could create a view which would join the two tables so i would > have a virtual table which would have the category name field. BUT using > this: > > SELECT [emailAlerts].[emailAlert_ID], [CATEGORIES].[Category_id], > [CATEGORIES].[Category_name], [emailAlerts].[email], > [emailAlerts].[Category_id], [emailAlerts].[ADVERT_TYPE], > [emailAlerts].[Name] > FROM CATEGORIES, emailAlerts > WHERE ((([CATEGORIES].[Category_id])=[emailAlerts].[Category_id])) > OR emailAlerts.Category_id = 0; > > I find i get duplicates with say all the records with all the categories > like a cartesian product kind of thing because there is no category with the > ID of 0 the query returns records with this value with every value in the > category table. > > many thanks in advance > > > > ~~ 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: Brain isn't working yet...
Allow action -Original Message- From: Marcus [mailto:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 9:56 AM To: CF-Talk Subject: Brain isn't working yet... I'm trying to provide functionality to a select group of people on a specific subnet. What I'd like to do is something along the lines of.. Allow action The thing being they use dhcp to allocate IP's and the address could actually be any of the block. Is there a wild card I can use? or some other way to not specify the last number? Marcus ~~ 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: Brain isn't working yet...
Allow action -Original Message- From: Marcus [mailto:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 9:56 AM To: CF-Talk Subject: Brain isn't working yet... I'm trying to provide functionality to a select group of people on a specific subnet. What I'd like to do is something along the lines of.. Allow action The thing being they use dhcp to allocate IP's and the address could actually be any of the block. Is there a wild card I can use? or some other way to not specify the last number? Marcus ~~ 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: What's with this?
Thanks for the help... I was playing around with it after I sent the email and found that I needed to pass a complete date to daysinmonth(). Steven D Dworman --- Cold Fusion Programmer Web Applications Developer ComSpec International phone: 248.647.8841 cell: 734.972.9676 --- http://www.comspec-intnl.com -Original Message- From: Stephen Moretti [SMTP:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 9:24 AM To: CF-Talk Subject:RE: What's with this? Steven, The function daysinmonth takes a full date and not just the month,so really all you need is : daysinmonth(now()) regards Stephen > -Original Message- > From: Steven Dworman [mailto:[EMAIL PROTECTED]] > Sent: 01 June 2001 14:11 > To: CF-Talk > Subject: What's with this? > > > I have this bit of code... > > date1=dateformat(createdate(year(now()),month(now()),daysinmonth(month(n > ow(,"mm/dd/")> > date2=dateformat(createdate(year(now()),month(now()),1),"mm/dd/")> > > and I'm getting this error on date1 > > > In the function CreateDate(year, month, day) the combination of the > arguments, which are 2001- 6-31, have resulted in an invalid date value. > The valid range of dates approximately covers the period between > 100 AD and > AD > > > WHY? > > > Steven D Dworman > --- > Cold Fusion Programmer > Web Applications Developer > > ComSpec International > > phone: 248.647.8841 > cell: 734.972.9676 > --- > http://www.comspec-intnl.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
Thanks Re: SQL Server 2000
Thanks for all the info. I think I am going to try using Access first since I have that installed allready. If that doesn't work then I going for the SQL 2000 client tools. Art "Never put your finger where you wouldn't put your nose." ~~ 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: Brain isn't working yet...
use or use the contains version should work fine, but the reFind has less potential for error -chris On Fri, 1 Jun 2001, Marcus wrote: > I'm trying to provide functionality to a select group of people on a > specific subnet. What I'd like to do is something along the lines of.. > > > Allow action > > > The thing being they use dhcp to allocate IP's and the address could > actually be any of the block. Is there a wild card I can use? or some other > way to not specify the last number? > > Marcus > > > ~~ 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: Crazy Dynamic Update/FORM Structure question
Good questions. The data type of the field is (MS Access) Memo. The string is about 1400 characters. But I've been doodling around this morning with it, and I've gotten it to take strings up to 2500 characters. The problem seems to be that I'm passing some sort of carriage return that's mucking up my statement. If I could just find and replace it, but I can't even figure out what the character is... >>> [EMAIL PROTECTED] 6/1/01 8:51:54 AM >>> what's the data type of the field objectcontent and exactly how long is your string? -Original Message- From: Willy Ray [mailto:[EMAIL PROTECTED]] Sent: 01 June 2001 15:40 To: CF-Talk Subject: Re: Crazy Dynamic Update/FORM Structure question Ok, I tried plugging the content into a test update statement that I knew was working. Bombed out. Same error. There's either something in my text string that's causing a failure, or access/ODBC won't accept that big of a string. Any thoughts on making it do this? Willy >>> [EMAIL PROTECTED] 5/31/01 2:10:41 PM >>> Ok, I'm having some trouble here. I don't know what the form looks like, as it's being generated dynamically. So, I figure, I'll have to loop through the FORM structure, and run a seperate update for each form element. Here's what I'm doing: UPDATE contentitems SET objectcontent='#form["#i#"]#' WHERE objectname='#i#' AND page='#FORM.page#' Now the first element of the loop it will hit will be a field from the form called "Body." It's the first possibility, alphabetically. And value is going to be a really long string of text. I've set "page" on the form earlier on. It should come out like this: UPDATE contentitems SET objectcontent = 'great big long string of text...' WHERE objectname = 'BODY' AND page = '1' And it does, but I get an error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression "great big long string of text running out to a point at which it gets truncat' Then it shows my sql, and it really does look like I had hope it would...Am I just missing something in my update statement? Willy ~~ 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: Brain isn't working yet...
how about a regular expression? or something like that! Paul -Original Message- From: Marcus <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Date: 01 June 2001 16:14 Subject: Brain isn't working yet... >I'm trying to provide functionality to a select group of people on a >specific subnet. What I'd like to do is something along the lines of.. > > > Allow action > > >The thing being they use dhcp to allocate IP's and the address could >actually be any of the block. Is there a wild card I can use? or some other >way to not specify the last number? > >Marcus > > > ~~ 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: session and client variables
Paul Put this in your application.cfm: This will ensure that whenever they close the broswer the session is killed (or rather their link to the set of client vars is broken). The client vars weill then get destroyed when the timeout is reached. -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: 01 June 2001 16:02 To: CF-Talk Subject: session and client variables Anyone, I have come up with a slight issue in the past, and it is this: If you are using client variables for a secure section of a website and they have a timeout (say 10 minutes). The users closes the browser thinking that they have logged out (when they haven't) and the cookies (let's assume cookies here) get destroyed by an onunload="" event. The logout script destroys the cookies when the user leaves the secure section, so we don't worry about that. Bearing in mind that an onunload event doesn't work consistently in all browsers (it's a known bug in Netscape) does anyone have a solution (barring recoding of the site to use the urltoken), for destroying the cookies in the users browser that works cross-browser (ie Netscape 4+, IE 4+ and Netscape 6)? The problem is that it is entirely possible (and sensible) that the cookie should stay on the user machine if they come back to the site so that they are logged in (assuming the ten minutes isn't up), but what if they are in an internet cafe and the ten minutes aren't up? (Let's assume we're using a clustered server here so session variables become virtually pointless... or do they?) Any replies welcome (ie sensible ones). Paul ~~ 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: Brain isn't working yet...
Will do the trick, but you really need to use REfind and anchor the string to the start. ~~ 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: Brain isn't working yet...
You're most of the way there... or > -Original Message- > From: Marcus [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 01, 2001 7:56 AM > To: CF-Talk > Subject: Brain isn't working yet... > > > I'm trying to provide functionality to a select group of people on a > specific subnet. What I'd like to do is something along the lines of.. > > > Allow action > > > The thing being they use dhcp to allocate IP's and the address could > actually be any of the block. Is there a wild card I can use? > or some other > way to not specify the last number? > > Marcus > > > ~~ 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: Brain isn't working yet...
You will probably need to do a test and then set the result to a variable and then do a CFIF based on that variable result. Robert - Original Message - From: "Marcus" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 01, 2001 10:55 AM Subject: Brain isn't working yet... > I'm trying to provide functionality to a select group of people on a > specific subnet. What I'd like to do is something along the lines of.. > > > Allow action > > > The thing being they use dhcp to allocate IP's and the address could > actually be any of the block. Is there a wild card I can use? or some other > way to not specify the last number? > > Marcus > > > ~~ 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: Brain isn't working yet...
I would presume this in on an Intranet because on an Internet site you will not see that range. Thanks, Robert - Original Message - From: "Marcus" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 01, 2001 10:55 AM Subject: Brain isn't working yet... > I'm trying to provide functionality to a select group of people on a > specific subnet. What I'd like to do is something along the lines of.. > > > Allow action > > > The thing being they use dhcp to allocate IP's and the address could > actually be any of the block. Is there a wild card I can use? or some other > way to not specify the last number? > > Marcus > > > ~~ 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
FireWorks and Graphics
Heidi, If you understand a little about what FireWorks (and other graphics/HTML) programs are doing to create the tables and graphics, it might make more sense of what you have, what you need to do, and how you might approach it in another way. Normally, we like to use a controlled environment to program our graphics, text, tables, layout. We create a table with known rows and columns, place and size the graphics as needed, manipulate the table as needed. FireWorks and other graphics/HTML programs take another approach. Remember, they are tools for GRAPHICS designers. FireWorks used a hardcopy, brochure type of approach, one the graphics persons are familiar with. Graphics designers see some white space and want to fill it up. The heck with HTML. They just design and graphic and let FireWorks do the dirty work and making it work on an HTML page. So, FireWorks says a) do your graphic and b) we'll automatically chop it up and create tables and placemarker images with small footprints. We'll make it transparent to you and others that we chopped it all up. The chopping is done using a formula to try and keep the load times as small as possible. Hot spots are mapped where needed to create links. So, you will always get a new set of tables and graphics (including placemarker images) whenever the new graphic is processed by FireWorks and handed off to you (because FireWorks does that automatically undre no control of the graphics designer, unless post processed). The solution is a) set up your own tables and restrict the graphic designers to stay within mutually agreed upon parameters; control where the graphics are placed and how they are placed with HTML and or CF parameters or b) use FireWorks, BUT restrict the extent of the entire set of tables and graphics that come to you by placing them in a cell of a table you control. The graphics will move within that cell, but you will always know where the entire graphic will be placed. You can work with links using passed parameters or naming conventions in the links. Hope this helps. -- Eric Root Environmental Management Systems Inc. ~~ 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
session and client variables
Anyone, I have come up with a slight issue in the past, and it is this: If you are using client variables for a secure section of a website and they have a timeout (say 10 minutes). The users closes the browser thinking that they have logged out (when they haven't) and the cookies (let's assume cookies here) get destroyed by an onunload="" event. The logout script destroys the cookies when the user leaves the secure section, so we don't worry about that. Bearing in mind that an onunload event doesn't work consistently in all browsers (it's a known bug in Netscape) does anyone have a solution (barring recoding of the site to use the urltoken), for destroying the cookies in the users browser that works cross-browser (ie Netscape 4+, IE 4+ and Netscape 6)? The problem is that it is entirely possible (and sensible) that the cookie should stay on the user machine if they come back to the site so that they are logged in (assuming the ten minutes isn't up), but what if they are in an internet cafe and the ten minutes aren't up? (Let's assume we're using a clustered server here so session variables become virtually pointless... or do they?) Any replies welcome (ie sensible ones). Paul ~~ 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:how to NOT get a cross join
hi hope someone here can give me a hand with this:(sorry for the cross post) I have a table called categories, the key bieng an int, with a field for the category name. Another table called adverts, an advert has a category feild which is a foreign key which links to the category table. I realised i could create a view which would join the two tables so i would have a virtual table which would have the category name field. BUT using this: SELECT [emailAlerts].[emailAlert_ID], [CATEGORIES].[Category_id], [CATEGORIES].[Category_name], [emailAlerts].[email], [emailAlerts].[Category_id], [emailAlerts].[ADVERT_TYPE], [emailAlerts].[Name] FROM CATEGORIES, emailAlerts WHERE ((([CATEGORIES].[Category_id])=[emailAlerts].[Category_id])) OR emailAlerts.Category_id = 0; I find i get duplicates with say all the records with all the categories like a cartesian product kind of thing because there is no category with the ID of 0 the query returns records with this value with every value in the category table. many thanks in advance ~~ 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
Brain isn't working yet...
I'm trying to provide functionality to a select group of people on a specific subnet. What I'd like to do is something along the lines of.. Allow action The thing being they use dhcp to allocate IP's and the address could actually be any of the block. Is there a wild card I can use? or some other way to not specify the last number? Marcus ~~ 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: Crazy Dynamic Update/FORM Structure question
what's the data type of the field objectcontent and exactly how long is your string? -Original Message- From: Willy Ray [mailto:[EMAIL PROTECTED]] Sent: 01 June 2001 15:40 To: CF-Talk Subject: Re: Crazy Dynamic Update/FORM Structure question Ok, I tried plugging the content into a test update statement that I knew was working. Bombed out. Same error. There's either something in my text string that's causing a failure, or access/ODBC won't accept that big of a string. Any thoughts on making it do this? Willy >>> [EMAIL PROTECTED] 5/31/01 2:10:41 PM >>> Ok, I'm having some trouble here. I don't know what the form looks like, as it's being generated dynamically. So, I figure, I'll have to loop through the FORM structure, and run a seperate update for each form element. Here's what I'm doing: UPDATE contentitems SET objectcontent='#form["#i#"]#' WHERE objectname='#i#' AND page='#FORM.page#' Now the first element of the loop it will hit will be a field from the form called "Body." It's the first possibility, alphabetically. And value is going to be a really long string of text. I've set "page" on the form earlier on. It should come out like this: UPDATE contentitems SET objectcontent = 'great big long string of text...' WHERE objectname = 'BODY' AND page = '1' And it does, but I get an error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression "great big long string of text running out to a point at which it gets truncat' Then it shows my sql, and it really does look like I had hope it would...Am I just missing something in my update statement? Willy ~~ 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: Crazy Dynamic Update/FORM Structure question
Ok, I tried plugging the content into a test update statement that I knew was working. Bombed out. Same error. There's either something in my text string that's causing a failure, or access/ODBC won't accept that big of a string. Any thoughts on making it do this? Willy >>> [EMAIL PROTECTED] 5/31/01 2:10:41 PM >>> Ok, I'm having some trouble here. I don't know what the form looks like, as it's being generated dynamically. So, I figure, I'll have to loop through the FORM structure, and run a seperate update for each form element. Here's what I'm doing: UPDATE contentitems SET objectcontent='#form["#i#"]#' WHERE objectname='#i#' AND page='#FORM.page#' Now the first element of the loop it will hit will be a field from the form called "Body." It's the first possibility, alphabetically. And value is going to be a really long string of text. I've set "page" on the form earlier on. It should come out like this: UPDATE contentitems SET objectcontent = 'great big long string of text...' WHERE objectname = 'BODY' AND page = '1' And it does, but I get an error: ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression "great big long string of text running out to a point at which it gets truncat' Then it shows my sql, and it really does look like I had hope it would...Am I just missing something in my update statement? Willy ~~ 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 NLB
want to make sure i worded my previous response more correctly; session variables are stored in memory only. client variables however, can be stored in a database (or the registry) as specified in the CF admin. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 7:12 AM To: CF-Talk Subject: Re: Windows 2000 NLB Store session info in a database instead of in CF memory. Robert - Original Message - From: "Michael Ross" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 01, 2001 9:57 AM Subject: RE: Windows 2000 NLB > To anyone that cares I have found that using a Layer 3 switch requires some extra fiddling with nlb. I have substitued the switch for a 100m hub and and runs perfectly. > > Here is a question though. Regardless of if you use nlb, cc or a hardware solution. What do you guys do if the server that someone is using (sticky session) dies and they get moved over to another one. If they are in a secured area they have to log back in and may lose somethings that they were doing. What can you do to avoide that? > > thanks > > >>> [EMAIL PROTECTED] 05/31/01 02:16PM >>> > NLB is free and worth every penny. > In your configuration, all traffic is still coming into the first machine > and then half of that is sent to the other. So one has twice as many > connections as the second. Where is the real benefit? > > You are much better off using ClusterCATS with or without a hardware load > balancer. > Set it up with DNS round robin if you can't get a load balancer. There is a > bunch of KB articles on this subject at the Allaire site. KB# 18931 is a > good start. > > Regards, > > Rob Rusher > > Spectra Architect, Certified ColdFusion Instructor + Developer, Certified > Java Programmer > > (303) 885-7044 Cell > (970) 472-1775 Fax > [EMAIL PROTECTED] > > [EMAIL PROTECTED] > http://www.flarenetworks.com > > > plan, build and integrate interactive applications and e-business services > to enhance knowledge sharing, e-commerce and business communications > initiatives > > > -Original Message- > From: Michael Ross [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 30, 2001 12:41 PM > To: CF-Talk > Subject: Windows 2000 NLB > > > I am trying to set up a windows 2000 network load balancing cluster. I have > two servers that I am using. At this point in time I have configured > everything on the two servers. If I get it going it starts to work and then > I pull the plug on the #1 priority and #2 takes over. But as soon as I plug > # 1 back in the hole things bombIts like they are not talking > Also in both the event viewer's Its says the "priority number" has joined as > default with host(s) "priority number"..blah blah. In both event > viewers it doesn't see the other one and they both are acting like defaults. > > I have looked and looked at the settings and everythings seems okay.I > just put in a new extreme switch and configured the vlan for multicasting. > I am thinking that maybe it has something to do with the vlan not letting > them talk? > > Any idea's would be great!! > > 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: IIS or Apache? (WAS RE: can anyone help?)
> -Original Message- > From: Dave Watts [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 01, 2001 09:10 > To: CF-Talk > Subject: RE: IIS or Apache? (WAS RE: can anyone help?) > > > > Actually, I found CF made Apache a bit unstable... After I > > installed CF over Apache, I couldn't start Apache as a service > > any more - I had to run the command line version. Not good if > > you don't want the server to remain logged in. > > > > I would recomment sticking with IIS on an NT box. With CF > > and Apache, there were (at least for me) a bunch of bugs. > > You shouldn't be having these problems. To diagnose them, you can use the > same command line used by the service, and read the error message. > > I never had any bugs using Apache on NT, although I did see performance > problems under heavy load testing. I haven't had any problems myself, but I did see the performance degrade while Apache was under a load. I have read that this is because Apache 1.3 for NT is not multithreaded. Aparently this is fixed in Apache 2.0. I'm going to download the alpha version and test it out. I just need to figure out how to compile the bugger. I haven't worked with gcc for so long, I've fogotten how to use it. :) Russel ~~ 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: CFSET
Does the first query return any results? i noticed that you dont have a =, IN, !=, OR having before the subquery in getWaitingStudent, im no sql expert but does this still work like this? KOla -Original Message- From: David Clay [mailto:[EMAIL PROTECTED]] Sent: 01 June 2001 14:58 To: CF-Talk Subject: CFSET Can anyone tell me why the #ClassID# in the UPDATE Query is always coming up as a blank space, thus producing an error. Code below: SELECT ClassSchedID, InputDate, WaitList, RegistrationID FROM ClassRegistration WHERE InputDate (SELECT MIN(InputDate) FROM ClassRegistration WHERE ClassSchedID=9) UPDATE ClassRegistration SET ClassSchedID=#ClassID#, WaitList=NULL, ModifiedDate=#Now()# WHERE RegistrationID='#RegID#' Dave Clay Internet Facilitator Trus Joist, A Weyerhaeuser Business 5995 Greenwood Plaza Blvd, Suite 100 Greenwood Village, CO 80111 303.770.8506 ~~ 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 NLB
client variables can be stored in a database, not sessions. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 7:12 AM To: CF-Talk Subject: Re: Windows 2000 NLB Store session info in a database instead of in CF memory. Robert - Original Message - From: "Michael Ross" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 01, 2001 9:57 AM Subject: RE: Windows 2000 NLB > To anyone that cares I have found that using a Layer 3 switch requires some extra fiddling with nlb. I have substitued the switch for a 100m hub and and runs perfectly. > > Here is a question though. Regardless of if you use nlb, cc or a hardware solution. What do you guys do if the server that someone is using (sticky session) dies and they get moved over to another one. If they are in a secured area they have to log back in and may lose somethings that they were doing. What can you do to avoide that? > > thanks > > >>> [EMAIL PROTECTED] 05/31/01 02:16PM >>> > NLB is free and worth every penny. > In your configuration, all traffic is still coming into the first machine > and then half of that is sent to the other. So one has twice as many > connections as the second. Where is the real benefit? > > You are much better off using ClusterCATS with or without a hardware load > balancer. > Set it up with DNS round robin if you can't get a load balancer. There is a > bunch of KB articles on this subject at the Allaire site. KB# 18931 is a > good start. > > Regards, > > Rob Rusher > > Spectra Architect, Certified ColdFusion Instructor + Developer, Certified > Java Programmer > > (303) 885-7044 Cell > (970) 472-1775 Fax > [EMAIL PROTECTED] > > [EMAIL PROTECTED] > http://www.flarenetworks.com > > > plan, build and integrate interactive applications and e-business services > to enhance knowledge sharing, e-commerce and business communications > initiatives > > > -Original Message- > From: Michael Ross [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 30, 2001 12:41 PM > To: CF-Talk > Subject: Windows 2000 NLB > > > I am trying to set up a windows 2000 network load balancing cluster. I have > two servers that I am using. At this point in time I have configured > everything on the two servers. If I get it going it starts to work and then > I pull the plug on the #1 priority and #2 takes over. But as soon as I plug > # 1 back in the hole things bombIts like they are not talking > Also in both the event viewer's Its says the "priority number" has joined as > default with host(s) "priority number"..blah blah. In both event > viewers it doesn't see the other one and they both are acting like defaults. > > I have looked and looked at the settings and everythings seems okay.I > just put in a new extreme switch and configured the vlan for multicasting. > I am thinking that maybe it has something to do with the vlan not letting > them talk? > > Any idea's would be great!! > > 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: highlighting search terms
Sebastion,
The code below should do it. Note that this method (both your version and
mine) will choke if the keyword list contains "pan" or "coldfusion,fusion"
because of interference between the replacement of a string and the added
text, or between the replacement of one string and the replacement of
another.
Completely unrelated note (I just didn't want to send out a separate message to
deal with this):
If you post a question to multiple lists, please indicate that you've done so.
-David
...highlight { background-color: yellow }
#String#
On Wednesday, May 30, 2001 5:13 PM, sebastian palmigiani [SMTP:[EMAIL PROTECTED]]
wrote:
>
> I want to develop a highlight function of search terms. The following works
> well except that it changes the case of the keyword in the output. For
> example, 'Cold' in the original becomes 'cold' in the output.
>
> What can I include in the code to keep the original case of the String? If I
> use REReplace() then I omit the keywords because of case sensitivity.
>
> Sebastian
>
> -
>
>
>
>
>
>
> ..highlight { background-color: yellow }
>
>
>
>
>
>
>
>
>
>
>
> HighlightedWord, "ALL")>
>
>
>
> #String#
~~
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: CFSET
Check to make sure that the GetWaitingStudent query is actually returning a row. DC - Original Message - From: "David Clay" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 01, 2001 09:58 Subject: CFSET > Can anyone tell me why the #ClassID# in the UPDATE Query is always coming up as a blank space, thus producing an error. > > Code below: > > > SELECT ClassSchedID, InputDate, WaitList, RegistrationID > FROM ClassRegistration > WHERE InputDate (SELECT MIN(InputDate) > FROM ClassRegistration > WHERE ClassSchedID=9) > > > > > > > UPDATE ClassRegistration > SET >ClassSchedID=#ClassID#, >WaitList=NULL, >ModifiedDate=#Now()# > WHERE RegistrationID='#RegID#' > > > > Dave Clay > Internet Facilitator > Trus Joist, A Weyerhaeuser Business > 5995 Greenwood Plaza Blvd, Suite 100 > Greenwood Village, CO 80111 > 303.770.8506 > > > > ~~ 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 NLB
Store session info in a database instead of in CF memory. Robert - Original Message - From: "Michael Ross" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, June 01, 2001 9:57 AM Subject: RE: Windows 2000 NLB > To anyone that cares I have found that using a Layer 3 switch requires some extra fiddling with nlb. I have substitued the switch for a 100m hub and and runs perfectly. > > Here is a question though. Regardless of if you use nlb, cc or a hardware solution. What do you guys do if the server that someone is using (sticky session) dies and they get moved over to another one. If they are in a secured area they have to log back in and may lose somethings that they were doing. What can you do to avoide that? > > thanks > > >>> [EMAIL PROTECTED] 05/31/01 02:16PM >>> > NLB is free and worth every penny. > In your configuration, all traffic is still coming into the first machine > and then half of that is sent to the other. So one has twice as many > connections as the second. Where is the real benefit? > > You are much better off using ClusterCATS with or without a hardware load > balancer. > Set it up with DNS round robin if you can't get a load balancer. There is a > bunch of KB articles on this subject at the Allaire site. KB# 18931 is a > good start. > > Regards, > > Rob Rusher > > Spectra Architect, Certified ColdFusion Instructor + Developer, Certified > Java Programmer > > (303) 885-7044 Cell > (970) 472-1775 Fax > [EMAIL PROTECTED] > > [EMAIL PROTECTED] > http://www.flarenetworks.com > > > plan, build and integrate interactive applications and e-business services > to enhance knowledge sharing, e-commerce and business communications > initiatives > > > -Original Message- > From: Michael Ross [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, May 30, 2001 12:41 PM > To: CF-Talk > Subject: Windows 2000 NLB > > > I am trying to set up a windows 2000 network load balancing cluster. I have > two servers that I am using. At this point in time I have configured > everything on the two servers. If I get it going it starts to work and then > I pull the plug on the #1 priority and #2 takes over. But as soon as I plug > # 1 back in the hole things bombIts like they are not talking > Also in both the event viewer's Its says the "priority number" has joined as > default with host(s) "priority number"..blah blah. In both event > viewers it doesn't see the other one and they both are acting like defaults. > > I have looked and looked at the settings and everythings seems okay.I > just put in a new extreme switch and configured the vlan for multicasting. > I am thinking that maybe it has something to do with the vlan not letting > them talk? > > Any idea's would be great!! > > 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: IIS or Apache? (WAS RE: can anyone help?)
> Actually, I found CF made Apache a bit unstable... After I > installed CF over Apache, I couldn't start Apache as a service > any more - I had to run the command line version. Not good if > you don't want the server to remain logged in. > > I would recomment sticking with IIS on an NT box. With CF > and Apache, there were (at least for me) a bunch of bugs. You shouldn't be having these problems. To diagnose them, you can use the same command line used by the service, and read the error message. I never had any bugs using Apache on NT, although I did see performance problems under heavy load testing. 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: Windows 2000 NLB
To anyone that cares I have found that using a Layer 3 switch requires some extra fiddling with nlb. I have substitued the switch for a 100m hub and and runs perfectly. Here is a question though. Regardless of if you use nlb, cc or a hardware solution. What do you guys do if the server that someone is using (sticky session) dies and they get moved over to another one. If they are in a secured area they have to log back in and may lose somethings that they were doing. What can you do to avoide that? thanks >>> [EMAIL PROTECTED] 05/31/01 02:16PM >>> NLB is free and worth every penny. In your configuration, all traffic is still coming into the first machine and then half of that is sent to the other. So one has twice as many connections as the second. Where is the real benefit? You are much better off using ClusterCATS with or without a hardware load balancer. Set it up with DNS round robin if you can't get a load balancer. There is a bunch of KB articles on this subject at the Allaire site. KB# 18931 is a good start. Regards, Rob Rusher Spectra Architect, Certified ColdFusion Instructor + Developer, Certified Java Programmer (303) 885-7044 Cell (970) 472-1775 Fax [EMAIL PROTECTED] [EMAIL PROTECTED] http://www.flarenetworks.com plan, build and integrate interactive applications and e-business services to enhance knowledge sharing, e-commerce and business communications initiatives -Original Message- From: Michael Ross [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 30, 2001 12:41 PM To: CF-Talk Subject: Windows 2000 NLB I am trying to set up a windows 2000 network load balancing cluster. I have two servers that I am using. At this point in time I have configured everything on the two servers. If I get it going it starts to work and then I pull the plug on the #1 priority and #2 takes over. But as soon as I plug # 1 back in the hole things bombIts like they are not talking Also in both the event viewer's Its says the "priority number" has joined as default with host(s) "priority number"..blah blah. In both event viewers it doesn't see the other one and they both are acting like defaults. I have looked and looked at the settings and everythings seems okay.I just put in a new extreme switch and configured the vlan for multicasting. I am thinking that maybe it has something to do with the vlan not letting them talk? Any idea's would be great!! 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
CFSET
Can anyone tell me why the #ClassID# in the UPDATE Query is always coming up as a blank space, thus producing an error. Code below: SELECT ClassSchedID, InputDate, WaitList, RegistrationID FROM ClassRegistration WHERE InputDate (SELECT MIN(InputDate) FROM ClassRegistration WHERE ClassSchedID=9) UPDATE ClassRegistration SET ClassSchedID=#ClassID#, WaitList=NULL, ModifiedDate=#Now()# WHERE RegistrationID='#RegID#' Dave Clay Internet Facilitator Trus Joist, A Weyerhaeuser Business 5995 Greenwood Plaza Blvd, Suite 100 Greenwood Village, CO 80111 303.770.8506 ~~ 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: What's with this?
Steven, The function daysinmonth takes a full date and not just the month,so really all you need is : daysinmonth(now()) regards Stephen > -Original Message- > From: Steven Dworman [mailto:[EMAIL PROTECTED]] > Sent: 01 June 2001 14:11 > To: CF-Talk > Subject: What's with this? > > > I have this bit of code... > > date1=dateformat(createdate(year(now()),month(now()),daysinmonth(month(n > ow(,"mm/dd/")> > date2=dateformat(createdate(year(now()),month(now()),1),"mm/dd/")> > > and I'm getting this error on date1 > > > In the function CreateDate(year, month, day) the combination of the > arguments, which are 2001- 6-31, have resulted in an invalid date value. > The valid range of dates approximately covers the period between > 100 AD and > AD > > > WHY? > > > Steven D Dworman > --- > Cold Fusion Programmer > Web Applications Developer > > ComSpec International > > phone: 248.647.8841 > cell: 734.972.9676 > --- > http://www.comspec-intnl.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: What's with this?
Because June only has 30 days??? Tim Claremont -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 9:11 AM To: CF-Talk Subject: What's with this? I have this bit of code... and I'm getting this error on date1 In the function CreateDate(year, month, day) the combination of the arguments, which are 2001- 6-31, have resulted in an invalid date value. The valid range of dates approximately covers the period between 100 AD and AD WHY? Steven D Dworman --- Cold Fusion Programmer Web Applications Developer ComSpec International phone: 248.647.8841 cell: 734.972.9676 --- http://www.comspec-intnl.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: What's with this?
No bug. daysInMonth() takes a full date as a parameter -- not the month. If you say daysInMonth(now()), it will work as expected. Craig > -Original Message- > From: Norman Elton [SMTP:[EMAIL PROTECTED]] > Sent: Friday, June 01, 2001 9:33 AM > To: CF-Talk > Subject: RE: What's with this? > > Whoa... Definite bug there! I was able to replicate it without much problem > at all :) > > Last check of the calendar verified that yes, there are only 30 days in > June. > > Norman > > -Original Message- > From: Jason Lees (National Express) > [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 01, 2001 9:14 AM > To: CF-Talk > Subject: RE: What's with this? > > > > Doesn't June only have 30 days! > > > Jason Lees > National Express > Email : [EMAIL PROTECTED] > > > -Original Message- > From: Steven Dworman [mailto:[EMAIL PROTECTED]] > Sent: 01 June 2001 14:11 > To: CF-Talk > Subject: What's with this? > > > I have this bit of code... > > date1=dateformat(createdate(year(now()),month(now()),daysinmonth(month(n > ow(,"mm/dd/")> > date2=dateformat(createdate(year(now()),month(now()),1),"mm/dd/")> > > and I'm getting this error on date1 > > > In the function CreateDate(year, month, day) the combination of the > arguments, which are 2001- 6-31, have resulted in an invalid date value. > The valid range of dates approximately covers the period between 100 AD and > AD > > > WHY? > > > Steven D Dworman > --- > Cold Fusion Programmer > Web Applications Developer > > ComSpec International > > phone: 248.647.8841 > cell: 734.972.9676 > --- > http://www.comspec-intnl.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: What's with this? -- Not a BUG!
CORRECTION! Check out the documentation for DaysInMonth()... You have to supply a DATE object, not a numeric month I fell for that one too! Norman -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 9:14 AM To: CF-Talk Subject: RE: What's with this? Doesn't June only have 30 days! Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: 01 June 2001 14:11 To: CF-Talk Subject: What's with this? I have this bit of code... and I'm getting this error on date1 In the function CreateDate(year, month, day) the combination of the arguments, which are 2001- 6-31, have resulted in an invalid date value. The valid range of dates approximately covers the period between 100 AD and AD WHY? Steven D Dworman --- Cold Fusion Programmer Web Applications Developer ComSpec International phone: 248.647.8841 cell: 734.972.9676 --- http://www.comspec-intnl.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: What's with this?
Yep - your problem is that you need to pass in a date object into the function daysinmonth. So you need: -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: 01 June 2001 14:11 To: CF-Talk Subject: What's with this? I have this bit of code... and I'm getting this error on date1 In the function CreateDate(year, month, day) the combination of the arguments, which are 2001- 6-31, have resulted in an invalid date value. The valid range of dates approximately covers the period between 100 AD and AD WHY? Steven D Dworman --- Cold Fusion Programmer Web Applications Developer ComSpec International phone: 248.647.8841 cell: 734.972.9676 --- http://www.comspec-intnl.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: What's with this?
Whoa... Definite bug there! I was able to replicate it without much problem at all :) Last check of the calendar verified that yes, there are only 30 days in June. Norman -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 9:14 AM To: CF-Talk Subject: RE: What's with this? Doesn't June only have 30 days! Jason Lees National Express Email : [EMAIL PROTECTED] -Original Message- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: 01 June 2001 14:11 To: CF-Talk Subject: What's with this? I have this bit of code... and I'm getting this error on date1 In the function CreateDate(year, month, day) the combination of the arguments, which are 2001- 6-31, have resulted in an invalid date value. The valid range of dates approximately covers the period between 100 AD and AD WHY? Steven D Dworman --- Cold Fusion Programmer Web Applications Developer ComSpec International phone: 248.647.8841 cell: 734.972.9676 --- http://www.comspec-intnl.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
