mysql insert rut roh
having some troubles inserting, lol problem is that if i copy and paste(which i have to do) the # maybe like this 06618300 but when its inserted it strips the zero off the front to this 6618300. its mysql the field is a varchar cause it could also have letters. its really not a big deal except that i have a check in place to stop dups which that reall messes it up tia [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Val function seems buggy
REReplace(myvar,"\D","","all") > -Original Message- > From: Chunshen (Don) Li [mailto:[EMAIL PROTECTED] > Sent: 09 August 2004 04:24 > To: CF-Talk > Subject: Re: Val function seems buggy > > OK, I expected a bit too much from Val :), needed to get all the digits > portion of a VAR. Thanks for everyone's input and time. > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Tuning CF response speeds
Does anyone have experience in fine tuning CFMX responses? I often have the feeling the CFMX server, is going into hibernation between requests. One moment a request pops up at a reasonable response, and sometimes I just have to wait for 2 a 3 seconds for the same template which actually does nothing but outputting Hello world. For a user interface made up with multiple iframes, or files dependent on the cfm extension like _javascript_ files with embedded cfml, I try to get the best response speed as I can get. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: server-side forwarding in CFMS
Just out of curiosity is it possible to a re-direct to a new domain/url? something like: getPageContext().forward("http://www.somedomain.com/"); I know this doesn't work, but is there an equivalent (idealy using cfscript) without having to do a client side re-driect? Cheers G On Fri, 6 Aug 2004 15:47:25 -0400, S. Isaac Dealey <[EMAIL PROTECTED]> wrote: > > > > getPageContext().forward("page.cfm"); > > > > I said .include() didn't I? > > D'oh! > > > s. isaac dealey 954.927.5117 > new epoch : isn't it time for a change? > > add features without fixtures with > the onTap open source framework > > http://www.sys-con.com/story/?storyid=44477&DE=1 > http://www.sys-con.com/story/?storyid=45569&DE=1 > http://www.fusiontap.com > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: server-side forwarding in CFMS
but I wonder, have you even checked the cfml reference? :-) Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Downloading image
Thank you all for your replies [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
MySQL on Linux
Anyone can tell me how to setup/start MySQL on Linux Enterprise. I can't seem to find where to begin. Thanks. Robert O. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: MySQL on Linux (OT)
Robert Orlini wrote: > Anyone can tell me how to setup/start MySQL on Linux Enterprise. First of all Robert, I only know you're referring to REDHAT because you've posted previously. You need to specify REDHAT, otherwise people won't know for sure what you're talking about... I think Suse also makes an "Enterprise" Linux. The startup script for mysql by default in RedHat (all versions) is /etc/rc.d/init.d/mysql Just do this from the linux shell prompt: /etc/rc.d/init.d/mysql start I suggest you get a good book about Linux that focuses on Redhat, and read it. And you might consider posting your questions to a mysql or linux specific mailing list, since this question has nothing to do with CF. - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: MySQL on Linux
Robert Orlini wrote: > Anyone can tell me how to setup/start MySQL on Linux Enterprise. There is no Linux Enterprise, Linux is the kernel and the only qualifier is the version number. You are probably refering to the Enterprise version of some distribution. Anyway, if MySQL is properly installed "man -k mysql" will give you all the manual pages for MySQL or else you would have to check the manual of your distribution for instructions on how to install MySQL. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: MySQL on Linux (OT)
Thanks Rick, Jochem, Sorry for the OT subject on this. Will check other references as well. Robert O. -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: Monday, August 09, 2004 8:18 AM To: CF-Talk Subject: Re: MySQL on Linux (OT) Robert Orlini wrote: > Anyone can tell me how to setup/start MySQL on Linux Enterprise. First of all Robert, I only know you're referring to REDHAT because you've posted previously. You need to specify REDHAT, otherwise people won't know for sure what you're talking about... I think Suse also makes an "Enterprise" Linux. The startup script for mysql by default in RedHat (all versions) is /etc/rc.d/init.d/mysql Just do this from the linux shell prompt: /etc/rc.d/init.d/mysql start I suggest you get a good book about Linux that focuses on Redhat, and read it. And you might consider posting your questions to a mysql or linux specific mailing list, since this question has nothing to do with CF. - Rick _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
cfchartseries y-axis problem
Hi list, we are having some problems concerning y-scaling on the y-axes under cfchart/CFCHARTSERIES. (CFMX 6.1/Windows) The values which are shown are representing a value exact 10 times higher what it should be. We doublechecked the values with a normal cfoutput with no errors at all. Any clues on this topic ? Thanks for feedback ! Uwe [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: MySQL on Linux (OT)
Robert, May I suggest you google for "Getting started with MySQL" - the first result is an excellent how-to for getting up and running in minutes. Dave [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Count logged in user sessions
There are a few different ways to do this. There is a ServiceFactory method that will help. This article, http://www.findarticles.com/p/articles/mi_m0MLU/is_10_5/ai_109039749, written by myself, shows code that Sam Neff wrote. You can also do tracking in application.cfm by doing (pseudo-code) param application.sessions application.sessions[session.urltoken] = now(); What this does is create one record per session in an application struct. It uses the current time as the value. When you count the sessions, you simply remove any session who has a value more then your timeout, normally 20 minutes. This will give you the current number of sessions. On Sat, 7 Aug 2004 18:52:50 -0400, Ewok <[EMAIL PROTECTED]> wrote: > Doesn't look like this came through the first time... if its double posted you can hang me by my ... ummm...parts > > This has got to be possible. Seems like I remember the question being asked before but can't seem to word it right in the archives to get any results. Anyone know a link or a solution? > > I am using sessions to log people in and keep them logged in. There must be a way to count active sessions right? I just need a number, I don't plan to pull specific data about users who are logged in.. although it would be nice to know that too : ) > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: server-side forwarding in CFMS
> Just out of curiosity is it possible to a re-direct to a > new > domain/url? something like: > > getPageContext().forward("http://www.somedomain.com/"); > > I know this doesn't work, but is there an equivalent > (idealy using > cfscript) without having to do a client side re-driect? Nope... There wouldn't be any way to implement a method of moving to another server without going back tot he client, and while it's possible to have multiple domains on the same server, the CF server doesn't have any native means of knowing about what domains are on the current machine, so there's a lack of information that prevents a tool like that from being possible... at least with the current state of tech. s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477&DE=1 http://www.sys-con.com/story/?storyid=45569&DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: server-side forwarding in CFMS
> but I wonder, have you even checked the cfml > reference? :-) Nope, cflocation is a client-side redirection tool as well... It uses an http header to indicate "document moved" with information about where it's been moved to which is what the browser uses to go to the next page. I believe it's "temporarily moved" - there's a separate header for a "permanently" moved document. s. isaac dealey 954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477&DE=1 http://www.sys-con.com/story/?storyid=45569&DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: server-side forwarding in CFMS
Cheers Micha, but I was looking for a sever side re-direct! ;) On Mon, 9 Aug 2004 13:58:07 +0200, Micha Schopman <[EMAIL PROTECTED]> wrote: > but I wonder, have you even checked the cfml reference? :-) > > Micha Schopman > Software Engineer > Modern Media, Databankweg 12 M, 3821 AL Amersfoort > Tel 033-4535377, Fax 033-4535388 > KvK Amersfoort 39081679, Rabo 39.48.05.380 > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: server-side forwarding in CFMS
Ah well, thanks Isaac. G On Mon, 9 Aug 2004 08:40:19 -0400, S. Isaac Dealey <[EMAIL PROTECTED]> wrote: > > Just out of curiosity is it possible to a re-direct to a > > new > > domain/url? something like: > > > > getPageContext().forward("http://www.somedomain.com/"); > > > > > I know this doesn't work, but is there an equivalent > > (idealy using > > cfscript) without having to do a client side re-driect? > > Nope... There wouldn't be any way to implement a method of moving to > another server without going back tot he client, and while it's > possible to have multiple domains on the same server, the CF server > doesn't have any native means of knowing about what domains are on the > current machine, so there's a lack of information that prevents a tool > like that from being possible... at least with the current state of > tech. > > s. isaac dealey 954.927.5117 > new epoch : isn't it time for a change? > > add features without fixtures with > the onTap open source framework > > http://www.sys-con.com/story/?storyid=44477&DE=1 > http://www.sys-con.com/story/?storyid=45569&DE=1 > http://www.fusiontap.com > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Count logged in user sessions
Does anyone know the performance cost of things like the SessionTracker code? Without sessionTracker, I wanted to do something similar, but in my case, I wanted to make a struct for each session, put it in the session, and in the application, and then access it from both, for some realtime updates. I have a site which gets 400K-500K page views a day, and I am looking to minimize the impact of advanced session management. Example pseudocode: ( Application.cfm - extra code to support being logged in multiple times ) param application.allUsers default=structnew() IF I am logged in update my username struct (which allows me to have multiple sessions per username ) ( application.allUsers [session.myUserName].[session.urlToken].lastAccess=now() ) END IF ( in post-login success code ) myStruct=new CF struct(); myStruct.lastAccess=now(); IF (session.MyUsername is NOT a key in application.allUsers) application.allUsers[session.myUsername]=new cfstruct(); END IF application.allUsers[session.myUsername] [ session.urlToken]=myStruct; // this struct holds other realtime info, but since its not a direct session var, it will get orphaned when a session dies, and cleaned up by my cleanup loop run periodically... session.myStructRef=myStruct; Now I can loop through Application.allUsers, and loop through all child structures, to clean it out, and count user instances, etc... _ From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Monday, August 09, 2004 8:44 AM To: CF-Talk Subject: Re: Count logged in user sessions There are a few different ways to do this. There is a ServiceFactory method that will help. This article, http://www.findarticles.com/p/articles/mi_m0MLU/is_10_5/ai_109039749, written by myself, shows code that Sam Neff wrote. You can also do tracking in application.cfm by doing (pseudo-code) param application.sessions application.sessions[session.urltoken] = now(); What this does is create one record per session in an application struct. It uses the current time as the value. When you count the sessions, you simply remove any session who has a value more then your timeout, normally 20 minutes. This will give you the current number of sessions. On Sat, 7 Aug 2004 18:52:50 -0400, Ewok <[EMAIL PROTECTED]> wrote: > Doesn't look like this came through the first time... if its double posted you can hang me by my ... ummm...parts > > This has got to be possible. Seems like I remember the question being asked before but can't seem to word it right in the archives to get any results. Anyone know a link or a solution? > > I am using sessions to log people in and keep them logged in. There must be a way to count active sessions right? I just need a number, I don't plan to pull specific data about users who are logged in.. although it would be nice to know that too : ) > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
New custom tag
Hi, I have just release a new custom tag that for thos who want get color information about an image by clicking on it. See CFX_mapClick at the address below. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm?p=hf (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: server-side forwarding in CFMS
Welcome... wish I had better news for you. > Ah well, thanks Isaac. > G > On Mon, 9 Aug 2004 08:40:19 -0400, S. Isaac Dealey > <[EMAIL PROTECTED]> wrote: >> > Just out of curiosity is it possible to a re-direct to >> > a >> > new >> > domain/url? something like: >> > >> > getPageContext().forward("http://www.somedomain.com/") >> > ; >> > >> >> > I know this doesn't work, but is there an equivalent >> > (idealy using >> > cfscript) without having to do a client side re-driect? >> >> Nope... There wouldn't be any way to implement a method >> of moving to >> another server without going back tot he client, and >> while it's >> possible to have multiple domains on the same server, the >> CF server >> doesn't have any native means of knowing about what >> domains are on the >> current machine, so there's a lack of information that >> prevents a tool >> like that from being possible... at least with the >> current state of >> tech. >> >> s. isaac dealey 954.927.5117 >> new epoch : isn't it time for a change? >> >> add features without fixtures with >> the onTap open source framework >> >> http://www.sys-con.com/story/?storyid=44477&DE=1 >> http://www.sys-con.com/story/?storyid=45569&DE=1 >> http://www.fusiontap.com >> >> > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Count logged in user sessions
You don't need to keep track of sessions, CF does it for you: Access session vars from outside the session http://www.rewindlife.com/archives/46.cfm HTH, Sam Blog http://www.rewindlife.com TeamMM http://www.macromedia.com/go/team > -Original Message- > From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED] > Sent: Monday, August 09, 2004 9:23 AM > To: CF-Talk > Subject: RE: Count logged in user sessions > > Does anyone know the performance cost of things like the > SessionTracker > code? > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Output in 2 columns
Hi all how to output my 10 news in 2 columns(CSS div style)? Thanx [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Count logged in user sessions
Thanks. This is what I ended up using... function getSessions(appName) { var tracker = createObject("java","coldfusion.runtime.SessionTracker"); return tracker.getSessionCollection(appName); } the nSessions holds a count of ALL sessions and nLoggedIn holds a count of all users logged in. This works well enough. The nLoggedIn value is always accurate if users actually use the logout buttons, else it has to time out when they leave. The nSessions is usually NOT accurate since it has to time out for everyone. I've tried a couple different things for killing the session or dereferencing it when the browser is closed but no luck. In the MM forums I read this would do it if i dropped it in the application.cfm but it seems to clear the session on evry page load or refresh I also tried this in the application.cfm as the livedocs suggested but this was even worse, not only did the session not die when the browser was closed, it started a completley NEW session when the browser came back (weird) - Original Message - From: Raymond Camden To: CF-Talk Sent: Monday, August 09, 2004 8:44 AM Subject: Re: Count logged in user sessions There are a few different ways to do this. There is a ServiceFactory method that will help. This article, http://www.findarticles.com/p/articles/mi_m0MLU/is_10_5/ai_109039749, written by myself, shows code that Sam Neff wrote. You can also do tracking in application.cfm by doing (pseudo-code) param application.sessions application.sessions[session.urltoken] = now(); What this does is create one record per session in an application struct. It uses the current time as the value. When you count the sessions, you simply remove any session who has a value more then your timeout, normally 20 minutes. This will give you the current number of sessions. On Sat, 7 Aug 2004 18:52:50 -0400, Ewok <[EMAIL PROTECTED]> wrote: > Doesn't look like this came through the first time... if its double posted you can hang me by my ... ummm...parts > > This has got to be possible. Seems like I remember the question being asked before but can't seem to word it right in the archives to get any results. Anyone know a link or a solution? > > I am using sessions to log people in and keep them logged in. There must be a way to count active sessions right? I just need a number, I don't plan to pull specific data about users who are logged in.. although it would be nice to know that too : ) > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Output in 2 columns
>> how to output my 10 news in 2 columns(CSS div style)? If I'm understanding you right the basics are:
#news-left { float: left; }
#news-right {float: right; }
News 1 News 2 News 3 News 4 News 5 News 6 News 7 News 8 Cheers -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Count logged in user sessions
I know it keeps track of sessions. The problem with using that is (1) we have no guarantee from MACR that it's going to always be there (its like using the "com.sun" classes in java) (2) I still have no useful metrics on how accessing sessions from that factory/tracker might affect performance. (3) you cannot access inactive sessions to potentially remove stale data. The tracker suddenly has no reference to them, and that's all you get. Do you know of any of these? I'd love not to reinvent the wheel. -dov _ From: Samuel R. Neff [mailto:[EMAIL PROTECTED] Sent: Monday, August 09, 2004 9:43 AM To: CF-Talk Subject: RE: Count logged in user sessions You don't need to keep track of sessions, CF does it for you: Access session vars from outside the session http://www.rewindlife.com/archives/46.cfm HTH, Sam Blog http://www.rewindlife.com TeamMM http://www.macromedia.com/go/team > -Original Message- > From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED] > Sent: Monday, August 09, 2004 9:23 AM > To: CF-Talk > Subject: RE: Count logged in user sessions > > Does anyone know the performance cost of things like the > SessionTracker > code? > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
looping over dates?
I'm having a monday morning (afternoon) brain melt down... I want to programmatically create a consecutive list of months/dates starting from a certain month, eg March 2003 April 2003 May 2003 June 2003 .. .. .. July 2004 August 2004 up to the current month...I can't think for the life of me where to start... thanks, jb. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Calendar data structure
I'm looking for some advice on what sort of structure I should use for making a calendar app. My main question is about storing the dates. To accommodate multi-day events, is it better to do a startDate column and an endDate column or is it better to do a single eventDate column and insert multiple events multiple times? I will need to output this data as "today's events", "this week's events", and a monthly calendar view. Along the same lines, any suggestions for a CFC or custom tag that can organize into a calendar view (or tips for writing my own) would be helpful. Thanks to all in advance. John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Downloading image
> > method="GET" getasbinary="yes"> > It's worth pointing out that you can just use the FILE attribute of CFHTTP, rather than having a separate CFFILE tag. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: looping over dates?
You should check cflib.org first, there are plenty of date-related UDFs: http://www.cflib.org/library.cfm?ID=13 Massimo Foti http://www.massimocorner.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: looping over dates?
Not sure exactly what you are doing, but might spark some ideas... #MonthAsString(x)# Michael T. Tangorre > I'm having a monday morning (afternoon) brain melt down... > I want to programmatically create a consecutive list of > months/dates starting from a certain month, eg > > March 2003 > April 2003 > May 2003 > June 2003 > .. > .. > .. > July 2004 > August 2004 > > up to the current month...I can't think for the life of me > where to start... > > thanks, > > jb. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Calendar data structure
Read up on the iCal / vCal formats - they're attempted / de-facto standards for transfer of calendar data between applications, and they handle repeating events in a fairly straightforward manner. Last year I had to completely re-write a massive international calendar app from scratch, and the iCal / vCal formats were a very helpful starting point _ From: Burns, John D [mailto:[EMAIL PROTECTED] Sent: 09 August 2004 15:05 To: CF-Talk Subject: Calendar data structure I'm looking for some advice on what sort of structure I should use for making a calendar app. My main question is about storing the dates. To accommodate multi-day events, is it better to do a startDate column and an endDate column or is it better to do a single eventDate column and insert multiple events multiple times? I will need to output this data as "today's events", "this week's events", and a monthly calendar view. Along the same lines, any suggestions for a CFC or custom tag that can organize into a calendar view (or tips for writing my own) would be helpful. Thanks to all in advance. John Burns _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: looping over dates?
yeah, i sort of got going with something similar; #dateformat('#i#/1/#y#'," ")# On Mon, 9 Aug 2004 10:14:28 -0400, Tangorre, Michael <[EMAIL PROTECTED]> wrote: > Not sure exactly what you are doing, but might spark some ideas... > > > #MonthAsString(x)# > > > Michael T. Tangorre > > > > > I'm having a monday morning (afternoon) brain melt down... > > I want to programmatically create a consecutive list of > > months/dates starting from a certain month, eg > > > > March 2003 > > April 2003 > > May 2003 > > June 2003 > > .. > > .. > > .. > > July 2004 > > August 2004 > > > > up to the current month...I can't think for the life of me > > where to start... > > > > thanks, > > > > jb. > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: looping over dates?
Hey John, Here ya go: "12", "datePart('m', now())")#" index="currentMonth"> #monthAsString(currentMonth)# #currentYear# [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: looping over dates?
>> I want to programmatically create a consecutive list of months/dates >> starting from a certain month, eg Set your intial date, set your max date, loop round incrementing the month by one using dateAdd startDate = createDate(2003, 03, 01); endDate = now(); thisDate = startDate; while (dateCompare(thisDate, endDate, "m") lt 1) { writeoutput(MonthAsString(Month(thisDate)) & " " & Year(thisDate) & ""); thisDate = dateAdd("m", 1, thisDate); //Increment month } [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: looping over dates?
Oops, forgot startMonth: to="#iif(currentYear neq datePart("", now()), "12", "datePart('m', now())")#" index="currentMonth"> #monthAsString(currentMonth)# #currentYear# On Mon, 9 Aug 2004 10:19:07 -0400, Joe Rinehart <[EMAIL PROTECTED]> wrote: > Hey John, > > Here ya go: > > > > > > > > "12", "datePart('m', now())")#" index="currentMonth"> > #monthAsString(currentMonth)# #currentYear# > > > > -- For Tabs, Trees, and more, use the jComponents: http://clearsoftware.net/clear/?template=downloads.jComponents [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Transaction Log Size
They get cleared, not removed, but the problem is they are not shrunk, which is why they tend to get blown out of size. Dan - Original Message - From: Samuel R. Neff <[EMAIL PROTECTED]> Date: Fri, 6 Aug 2004 16:36:38 -0400 Subject: RE: Transaction Log Size To: CF-Talk <[EMAIL PROTECTED]> The transaction logs get removed when you do a backup ('cause they're no longer needed). Sam > -Original Message- > From: David Koehler [mailto:[EMAIL PROTECTED] > Sent: Friday, August 06, 2004 4:33 PM > To: CF-Talk > Subject: Transaction Log Size > > Some of our transaction logs are getting very large. I know I > can set the database recovery model to simple and not have > any logging, but is there a way to actually reduce the > already massive log file size? > > Thanks in advance, > > dave [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Output in 2 columns
Thanx dc, but our CSS style works fine... our problem is how to output using CF that news... How to "divide" that news in 2 columns, like this: Column 1Column 2 news 1 news 4 news 2 news 5 news 3 news 6 Thanx On Mon, 9 Aug 2004 15:05:16 +0100, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > >> how to output my 10 news in 2 columns(CSS div style)? > > If I'm understanding you right the basics are: > >
> #news-left { float: left; }
> #news-right {float: right; }
> > > > >News 1 >News 2 >News 3 >News 4 > > > >News 5 >News 6 >News 7 >News 8 > > > > Cheers > > -- > dc > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: looping over dates?
i just got to: #dateformat('#i#/1/#y#'," ")# which is pretty similar to what's being suggested. I'll use a mixture of all - thanks all! jb. On Mon, 9 Aug 2004 15:26:22 +0100, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > >> I want to programmatically create a consecutive list of months/dates > >> starting from a certain month, eg > > Set your intial date, set your max date, loop round incrementing the > month by one using dateAdd > > > startDate = createDate(2003, 03, 01); > endDate = now(); > thisDate = startDate; > > while (dateCompare(thisDate, endDate, "m") lt 1) { > writeoutput(MonthAsString(Month(thisDate)) & " " & > Year(thisDate) & ""); > thisDate = dateAdd("m", 1, thisDate); //Increment month > } > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
dump query before execution
Hi group, Does anyone have an idea of how to dump the contents of a query before it executes? Say I have a query named getThisUser. All I want is the contents of the select statement before it actually is passed to the database. I am having a problem with a long query (with lots of cfifs and cfqueryparams) and I want to see why it is hanging up/timing out on me. I know I can just remove the cfquery tag and have it output out on the screen, but I was looking for a more elegant (?) way of doing it on a consistent basis for other queries as well. TIA, George [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: dump query before execution
I'd just take a copy of the query code and replace the CFQUERY tags with CFOUTPUT and then CFABORT afterwards to display the post-CF code processing SQL. On Mon, 9 Aug 2004 10:25:27 -0400, George Abraham <[EMAIL PROTECTED]> wrote: > Hi group, > Does anyone have an idea of how to dump the contents of a query before > it executes? Say I have a query named getThisUser. All I want is the > contents of the select statement before it actually is passed to the > database. I am having a problem with a long query (with lots of cfifs > and cfqueryparams) and I want to see why it is hanging up/timing out > on me. I know I can just remove the cfquery tag and have it output out > on the screen, but I was looking for a more elegant (?) way of doing > it on a consistent basis for other queries as well. > > TIA, > George > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: looping over dates?
John, Re-reading your post I realized my solution was all wrong, it's definitely Monday around here... Just use the dateAdd() , adding a month each time, until you get where you need to go. It'll handle the year etc. for you. -joe - Original Message - From: John Beynon <[EMAIL PROTECTED]> Date: Mon, 9 Aug 2004 15:23:18 +0100 Subject: Re: looping over dates? To: CF-Talk <[EMAIL PROTECTED]> i just got to: #dateformat('#i#/1/#y#'," ")# which is pretty similar to what's being suggested. I'll use a mixture of all - thanks all! jb. On Mon, 9 Aug 2004 15:26:22 +0100, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > >> I want to programmatically create a consecutive list of months/dates > >> starting from a certain month, eg > > Set your intial date, set your max date, loop round incrementing the > month by one using dateAdd > > > startDate = createDate(2003, 03, 01); > endDate = now(); > thisDate = startDate; > > while (dateCompare(thisDate, endDate, "m") lt 1) { > writeoutput(MonthAsString(Month(thisDate)) & " " & > Year(thisDate) & ""); > thisDate = dateAdd("m", 1, thisDate); //Increment month > } > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Output in 2 columns
>> How to "divide" that news in 2 columns, like this: Again, if I understanding you right (not tested this code but it's thereabouts) #news.item# -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: dump query before execution
George, If you enable CF debugging through the cf administrator site, you'll be able to view the SQL passed to the DB in the debugging information. -joe - Original Message - From: Ubqtous <[EMAIL PROTECTED]> Date: Mon, 9 Aug 2004 10:32:23 -0400 Subject: Re: dump query before execution To: CF-Talk <[EMAIL PROTECTED]> I'd just take a copy of the query code and replace the CFQUERY tags with CFOUTPUT and then CFABORT afterwards to display the post-CF code processing SQL. On Mon, 9 Aug 2004 10:25:27 -0400, George Abraham <[EMAIL PROTECTED]> wrote: > Hi group, > Does anyone have an idea of how to dump the contents of a query before > it executes? Say I have a query named getThisUser. All I want is the > contents of the select statement before it actually is passed to the > database. I am having a problem with a long query (with lots of cfifs > and cfqueryparams) and I want to see why it is hanging up/timing out > on me. I know I can just remove the cfquery tag and have it output out > on the screen, but I was looking for a more elegant (?) way of doing > it on a consistent basis for other queries as well. > > TIA, > George > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: dump query before execution
That's what I do ultimately. I was just wondering if someone had a less time-consuming way of doing this. Thanks though, George On Mon, 9 Aug 2004 10:32:23 -0400, Ubqtous <[EMAIL PROTECTED]> wrote: > I'd just take a copy of the query code and replace the CFQUERY tags > with CFOUTPUT and then CFABORT afterwards to display the post-CF code > processing SQL. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: dump query before execution
Joe, I tried that and the problem is the query just times out and CFMX pops out a Stack Overflow error. I guess you'll get to see SQL in the debug information, only if it is passed to the DB successfully. George On Mon, 9 Aug 2004 10:36:11 -0400, Joe Rinehart <[EMAIL PROTECTED]> wrote: > George, > > If you enable CF debugging through the cf administrator site, you'll > be able to view the SQL passed to the DB in the debugging information. > > -joe > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: BLACKSTONE Sneak Preview Posted
> Question, for the "Sourceless Deployment", > is it possible to have "mixed mode",that is, say, > 99% code are compiled while leaving one or two > templates like application.cfm source code editable? TIA. Yes, you can use cfcompile to compile any cfm/cfc file you want. -- Tom Jordahl Macromedia Server Development [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Output in 2 columns
I use the following for our website. Column1 Results Column2 Results Thanks, Dan - Original Message - From: [EMAIL PROTECTED] To: CF-Talk Sent: Monday, August 09, 2004 10:40 AM Subject: RE: Output in 2 columns >> How to "divide" that news in 2 columns, like this: Again, if I understanding you right (not tested this code but it's thereabouts) #news.item# -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Getting an image.. before display
Imagine the situation.. you have thousands of records in a databse that refer to some images, you loop through these trying do display them I get a lot of broken images and some not. How would I go about checking that the image is there first and if so displaying otherwise... just go along my merry way? How would you go about it? -- Mark Drew mailto:[EMAIL PROTECTED] blog:http://cybersonic.blogspot.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
ANN: C# & ASP.NET for ColdFusion Developers
Presentation and sample code We just finished giving our ".NET Eye For the CF Guy" presentation to the Atlanta ColdFusion User Group, and now have the presentation online. We built two identical apps -- one in CF and one in ASP.NET -- that run side-by-side in frames so you can play with both at the same time, and the code is available for download. Both presentation and code are on http://www.ProductivityEnhancement.com. Intensive training Also, we finally have our new C# & ASP.NET for ColdFusion Developers training course scheduled. It's a 5-day, 8AM-7PM intensive course designed specifically for ColdFusion developers to segue into developing ASP.NET applications using C#. If ColdFusion is your only web development language (or close to it), you really should consider adding ASP.NET to your repertoire-- it's a great way to create more opportunities for you. We're pricing this course lower than our others, plus there's an early registration discount. The details are posted on http://www.ColdFusionTraining.com. Seminar There's also a one-day seminar that covers the same material in a more compact and superficial format that serves as an introduction to the topic. If you like the seminar and then decide to take the intensive training course too, we'll apply your seminar fee toward your training tuition. If you have any questions then contact me offlist and I'll be happy to reply. Respectfully, Adam Phillip Churvis Member of Team Macromedia Advanced Intensive ColdFusion MX Training: * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 http://www.ColdFusionTraining.com Download CommerceBlocks V2.1 and LoRCAT from http://www.ProductivityEnhancement.com The ColdFusion MX Bible is in bookstores now! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: BLACKSTONE Sneak Preview Posted
>> Question, for the "Sourceless Deployment", >> is it possible to have "mixed mode",that is, say, >> 99% code are compiled while leaving one or two >> templates like application.cfm source code editable? TIA. > >Yes, you can use cfcompile to compile any cfm/cfc file you want. >Tom Jordahl >Macromedia Server Development Great, good to know. Another one, is it possible to set expiration date a given custom tag or cfc or a group of them with Blackstone? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Getting an image.. before display
I hope this helps Paul Giesenhagen QuillDesign - Original Message - From: Mark Drew To: CF-Talk Sent: Monday, August 09, 2004 9:53 AM Subject: Getting an image.. before display Imagine the situation.. you have thousands of records in a databse that refer to some images, you loop through these trying do display them I get a lot of broken images and some not. How would I go about checking that the image is there first and if so displaying otherwise... just go along my merry way? How would you go about it? -- Mark Drew mailto:[EMAIL PROTECTED] blog:http://cybersonic.blogspot.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Getting an image.. before display
> -Original Message- > From: Mark Drew [mailto:[EMAIL PROTECTED] > Sent: 09 August 2004 16:54 > To: CF-Talk > Subject: Getting an image.. before display > > Imagine the situation.. you have thousands of records in a databse > that refer to some images, you loop through these trying do display > them > > > > > > > I get a lot of broken images and some not. How would I go about > checking that the image is there first and if so displaying > otherwise... just go along my merry way? > > > > > > How would you go about it? > > > -- > Mark Drew > mailto:[EMAIL PROTECTED] > blog:http://cybersonic.blogspot.com/ > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Getting an image.. before display
>> I get a lot of broken images and some not. How would I go about >> checking that the image is there first and if so displaying >> otherwise... just go along my merry way? fileExists? convert the URL to the path and use file exists... only work for local tho -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Output in 2 columns
Simplified: #qTest.field[i]# #qTest.field[i]# Pascal > -Original Message- > From: Marco Antonio C. Santos [mailto:[EMAIL PROTECTED] > Sent: 09 August 2004 16:22 > To: CF-Talk > Subject: Re: Output in 2 columns > > Thanx dc, but our CSS style works fine... our problem is how to output > using CF that news... > > How to "divide" that news in 2 columns, like this: > > > Column 1Column 2 > news 1 news 4 > news 2 news 5 > news 3 news 6 > > > Thanx > > On Mon, 9 Aug 2004 15:05:16 +0100, [EMAIL PROTECTED] > <[EMAIL PROTECTED]> wrote: > > >> how to output my 10 news in 2 columns(CSS div style)? > > > > If I'm understanding you right the basics are: > > > >
> > #news-left { float: left; }
> > #news-right {float: right; }
> > > > > > > > > >News 1 > >News 2 > >News 3 > >News 4 > > > > > > > >News 5 > >News 6 > >News 7 > >News 8 > > > > > > > > Cheers > > > > -- > > dc > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Getting an image.. before display
I dont know the phisical path.. was looking for a url and a relative one at that! On Mon, 9 Aug 2004 10:00:42 -0500, Paul Giesenhagen <[EMAIL PROTECTED]> wrote: > > > > > > > I hope this helps > Paul Giesenhagen > QuillDesign > > > > - Original Message - > From: Mark Drew > To: CF-Talk > Sent: Monday, August 09, 2004 9:53 AM > Subject: Getting an image.. before display > > Imagine the situation.. you have thousands of records in a databse > that refer to some images, you loop through these trying do display > them > > > > > > I get a lot of broken images and some not. How would I go about > checking that the image is there first and if so displaying > otherwise... just go along my merry way? > > > > > > How would you go about it? > > -- > Mark Drew > mailto:[EMAIL PROTECTED] > blog:http://cybersonic.blogspot.com/ > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Range in SQL
Hello All, I was wondering if someone could help me with an SQL statement for Sybase. I need to do an update using on SQL not CF. What I would like to do is the opposite of TOP sort of. I have a query that returns lets "x" records and I would like to not update 125 records and have my statement update the rest what ever that is. Sort of like leave the TOP 125 alone and do the update. How do you do this in SQL? Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: BLACKSTONE Sneak Preview Posted
Chunshen (Don) Li wrote: > > Great, good to know. Another one, is it possible to set expiration date a given custom tag or cfc or a group of them with Blackstone? You can do that in CFML: Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Getting an image.. before display
would be your next best bet ... but that will be a performance hit ... but it would work.. Paul Giesenhagen QuillDesign - Original Message - From: Mark Drew To: CF-Talk Sent: Monday, August 09, 2004 10:05 AM Subject: Re: Getting an image.. before display I dont know the phisical path.. was looking for a url and a relative one at that! On Mon, 9 Aug 2004 10:00:42 -0500, Paul Giesenhagen <[EMAIL PROTECTED]> wrote: > > > > > > > I hope this helps > Paul Giesenhagen > QuillDesign > > > > - Original Message - > From: Mark Drew > To: CF-Talk > Sent: Monday, August 09, 2004 9:53 AM > Subject: Getting an image.. before display > > Imagine the situation.. you have thousands of records in a databse > that refer to some images, you loop through these trying do display > them > > > > > > I get a lot of broken images and some not. How would I go about > checking that the image is there first and if so displaying > otherwise... just go along my merry way? > > > > > > How would you go about it? > > -- > Mark Drew > mailto:[EMAIL PROTECTED] > blog:http://cybersonic.blogspot.com/ > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Getting an image.. before display
isnt there some FILEEXIST function? ehehe - Original Message - From: Mark Drew To: CF-Talk Sent: Monday, August 09, 2004 9:53 AM Subject: Getting an image.. before display Imagine the situation.. you have thousands of records in a databse that refer to some images, you loop through these trying do display them I get a lot of broken images and some not. How would I go about checking that the image is there first and if so displaying otherwise... just go along my merry way? How would you go about it? -- Mark Drew mailto:[EMAIL PROTECTED] blog:http://cybersonic.blogspot.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: C# & ASP.NET for ColdFusion Developers
Adam, Thanks for sharing that presentation. I found it to be very informative! > -Original Message- > From: Adam Churvis [mailto:[EMAIL PROTECTED] > Sent: Monday, August 09, 2004 9:56 AM > To: CF-Talk > Subject: ANN: C# & ASP.NET for ColdFusion Developers > > Presentation and sample code > > We just finished giving our ".NET Eye For the CF Guy" presentation to the > Atlanta ColdFusion User Group, and now have the presentation online. > We > built two identical apps -- one in CF and one in ASP.NET -- that run > side-by-side in frames so you can play with both at the same time, and > the > code is available for download. Both presentation and code are on > http://www.ProductivityEnhancement.com. > > Intensive training > > Also, we finally have our new C# & ASP.NET for ColdFusion Developers > training course scheduled. It's a 5-day, 8AM-7PM intensive course > designed > specifically for ColdFusion developers to segue into developing ASP.NET > applications using C#. > > If ColdFusion is your only web development language (or close to it), you > really should consider adding ASP.NET to your repertoire-- it's a great way > to create more opportunities for you. > > We're pricing this course lower than our others, plus there's an early > registration discount. The details are posted on > http://www.ColdFusionTraining.com. > > Seminar > > There's also a one-day seminar that covers the same material in a more > compact and superficial format that serves as an introduction to the > topic. > If you like the seminar and then decide to take the intensive training > course too, we'll apply your seminar fee toward your training tuition. > > If you have any questions then contact me offlist and I'll be happy to > reply. > > Respectfully, > > Adam Phillip Churvis > Member of Team Macromedia > > Advanced Intensive ColdFusion MX Training: > * ColdFusion MX Master Class > * Advanced Development with CFMX and SQL Server 2000 > http://www.ColdFusionTraining.com > > Download CommerceBlocks V2.1 and LoRCAT from > http://www.ProductivityEnhancement.com > > The ColdFusion MX Bible is in bookstores now! > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Output in 2 columns
>> Simplified: nicely refined Pascal... got the -verbose switch on all the time on my command line ;) -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT - CSS Talk and Class Announcment
Just an FYI for those out there, I will be speaking at the NYCFUG tomorrow night (Tuesday) on CSS. Hope to see many of you there. I am also offering a class in CSS in October, this will be a 4 days, hands on class. It is appropriate both for beginners and those who really want to delve more into what CSS has to offer. When: October 11 - 14th Where: Teratech, Rockville, MD Cost: $1399 Have you been hearing all the hype about Cascading Style Sheets and just don't get it? You know you should be using them more, and you just know you could be doing better? Learning CSS properties isn't enough, knowing when to apply them, how to select for them and the underlying rules which govern their behavior is critical to being able to pull yourself into the web standards age. In this 4 day, hands on class, Sandra Clark, will unlock the mysteries of CSS. This class is not a design class, rather it goes into the hows and whys of how selectors, properties and browsers interact. You will learn what to do, but also why you do it. Hands on labs help you to explore your creativity, as well as how to design HTML and Style sheets that are easy to read and maintain. This class is limited to 12 participants. Sign up early to guarantee yourself space. For more information, including a syllabus see http://www.teratech.com/training/oc_classes.cfm#css Sandy Clark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Calendar data structure
I have done this a couple of times and from experience I'd suggest this... one table to hold the event information, what where who etc... anopther table that holds dates with an EventID to tie it back to a particular event Also, in The Date table, I'd try something like DateID, SingleDate, StartDate, EndDate single dates would hold a onetime date , start and end dates would hold ranges. or even just StartDate and EndDate.. if it is a single date, put that date in BOTH fields I had a compnay tell me it was absolutley going to be 4 day events so all they needed were date ranges... Once it was written to do just that... they needed to exclude days in that range making it just 3 single dates (or a 2 day range and a single day) and it was a pain to change! If I had just done it this way to start with, it would have been fine. I'd suggest doing it this way just to save you the headaches for when it happens... and it will as for a calendar app, I have no suggestions for thridparty apps since I havent used any but if you decide to write your own, here is a VERY basic tutorial to get started with that I wrote way back when but dont tell anyone : ) http://tutorial180.easycfm.com/ - Original Message - From: Burns, John D To: CF-Talk Sent: Monday, August 09, 2004 10:04 AM Subject: Calendar data structure I'm looking for some advice on what sort of structure I should use for making a calendar app. My main question is about storing the dates. To accommodate multi-day events, is it better to do a startDate column and an endDate column or is it better to do a single eventDate column and insert multiple events multiple times? I will need to output this data as "today's events", "this week's events", and a monthly calendar view. Along the same lines, any suggestions for a CFC or custom tag that can organize into a calendar view (or tips for writing my own) would be helpful. Thanks to all in advance. John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Output in 2 columns
Actually, I reread my post and it doesn't do what he wants (yours does): My code News1 News2 News3 News4 News5 News6 Yours (this is what he asked for) News1 News4 News2 News5 News3 News6 Pascal > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: 09 August 2004 17:27 > To: CF-Talk > Subject: RE: Output in 2 columns > > >> Simplified: > > nicely refined Pascal... > > got the -verbose switch on all the time on my command line ;) > > -- > dc > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: BLACKSTONE Sneak Preview Posted
> You can do that in CFML: > > > > > Jochem I know that, and thought about "planting" this sort of code in multiple templates and have them compiled, however, it's not an elegant solution, because when you want to remove them, it becomes messy. And you don't want to do it at application.cfm because you leave it editable to the customer. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Output in 2 columns
I wouldn't argue with you over it tho Pascal... principal is the same and can be modded to make it do what was required :) -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Range in SQL
On Monday 09 Aug 2004 16:08 pm, Mickael wrote: > How do you do this in SQL? If your table has a primary key, just look yourself to see what the PK of the cut-off is, and use that in your where clause. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Getting an image.. before display
>> I have the url not the path Is the url phisically on the same server? If not, then CFHTTP is you only (and time consuming) solution. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Problem of cfmx6.1 for windows eval installer (Urgent)
The installer of the eval copy of cfmx6.1 for windows failed to install (it kept on asking for installation location) on a win2k machine. The same problem also happened to a client of mine. MM, please place a usable version or advise alternative. TIA. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Getting an image.. before display
The URL IS on the same server... I shall look at converting the location... the problem is that from the database I would get something like "../somthing/somthin/image.jpg" and it would be converting that to a path MD On Mon, 09 Aug 2004 11:31:32 -0400, Claude Schneegans <[EMAIL PROTECTED]> wrote: > >> I have the url not the path > > Is the url phisically on the same server? > If not, then CFHTTP is you only (and time consuming) solution. > > -- > ___ > REUSE CODE! Use custom tags; > See http://www.contentbox.com/claude/customtags/tagstore.cfm > (Please send any spam to this address: [EMAIL PROTECTED]) > Thanks. > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Calling CFCs with wget or curl -- What am I missing?
I can successfully call a remote (ws) cfc method with curl or wget, but I am unable to pass parameter data to the cfc. What's the secret? TIA Dick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Transaction Log Size
So, they should be "shrunked"? Dave >They get cleared, not removed, but the problem is they are not shrunk, >which is why they tend to get blown out of size. > >Dan > > >- Original Message - >From: Samuel R. Neff <[EMAIL PROTECTED]> >Date: Fri, 6 Aug 2004 16:36:38 -0400 >Subject: RE: Transaction Log Size >To: CF-Talk <[EMAIL PROTECTED]> > >The transaction logs get removed when you do a backup ('cause they're no > longer needed). > > Sam > > > > > -Original Message- > > From: David Koehler [mailto:[EMAIL PROTECTED] > > Sent: Friday, August 06, 2004 4:33 PM > > To: CF-Talk > > Subject: Transaction Log Size > > > > Some of our transaction logs are getting very large. I know I > > can set the database recovery model to simple and not have > > any logging, but is there a way to actually reduce the > > already massive log file size? > > > > Thanks in advance, > > > > dave [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Output in 2 columns
Just to get really into the semantics of markup ;)... I'd suggest using a list, here's DC's modified code for that... #news.item# On Mon, 9 Aug 2004 16:36:45 +0100, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > I wouldn't argue with you over it tho Pascal... principal is the same > and can be modded to make it do what was required :) > > -- > dc > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
pathname, HELP :(
Hello everyone, I'm trying to create a tree structure, i'm using coldfusion 5 on a unix box. I'm forbidden to use CFTREE and parent child relationships. all i have is a pathname column that i have to parse out to create a hierarchical visual representation of a directory structure. I'm having a really difficult time trying to figure out how i'm going to accomplish this. Also in this table there is no concept of folder, meaning a folder exist only if a document exist :( the records can look like this doc_id path_namefile_name 1 test1/test1.1 file1.pdf 2 test1/test1.2 file2.pdf 3 test2/ file3.pdf 4 test2/test2.1 file4.pdf 5 test2/test2.1/test2.1.1/ file5.pdf ps. i've found several wonderful examples on alternatives to cftree. but nothing so far that parses a pathname. Thank you, Metzy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Output in 2 columns
Thanx Pascal... great job... works nice for me... On Mon, 9 Aug 2004 16:36:45 +0100, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > I wouldn't argue with you over it tho Pascal... principal is the same > and can be modded to make it do what was required :) > > -- > dc > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
i don't want cookie.jsessionid...
On my local machine CF sets the cookie.jsessionid, but it doesn't on the test or live boxes. The first time i request a page the cookie doesn't show up in the debug output, but i can read it using _javascript_. On subsequent requests it does appear in cf debug output. I have the "Use J2EE session variables" checkbox unchecked. Is there anything else i need to do? Version: 6,1,0,63958 Edition Enterprise (DevNet) Operating System: Windows XP OS Version: 5.1 Cheers Bert [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFMail
I need to send an email to our customer base - currently about 2800 and our hosting company will only allow sending 250 at a time, and they must be at least 30 seconds between each mailing. I was trying to use a Perl script but it's timing out and they aren't willing to change their server settings. Has anyone built a mailout app in CF that would send out the 250 at a time, and at different intervals? Or do you know of a solution in another language? Thank you, Donna French [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Output in 2 columns
nice one greg... :D I like that :) -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Calling CFCs with wget or curl -- What am I missing?
> I can successfully call a remote (ws) cfc method with curl or > wget, but I am unable to pass parameter data to the cfc. > > What's the secret? You should be able to pass parameters within the URL of the CFC request: http://yourserver/your.cfc?param=value For obvious reasons, this will only work with simple values. Honestly, I've never tried this approach, since my use of CFCs has been limited to more traditional components and SOAP web services. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMail
Matt Robertson has a great script for doing this on the following link! http://mysecretbase.com/Slowing_Down_CFMAIL.cfm Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFMail
Donna, Matt Robertson's link should help. You could also use a table to store queued recipients, and a scheduled task that would pull the next 250 in queue then remove them. Cheers, Joe - Original Message - From: Donna French <[EMAIL PROTECTED]> Date: Mon, 9 Aug 2004 11:00:17 -0500 Subject: CFMail To: CF-Talk <[EMAIL PROTECTED]> I need to send an email to our customer base - currently about 2800 and our hosting company will only allow sending 250 at a time, and they must be at least 30 seconds between each mailing. I was trying to use a Perl script but it's timing out and they aren't willing to change their server settings. Has anyone built a mailout app in CF that would send out the 250 at a time, and at different intervals? Or do you know of a solution in another language? Thank you, Donna French [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Count logged in user sessions
I do this with a custom framework. In there I create CFCs to supplement CF's native application framework: there's an Application.cfc, Session.cfc and Request.cfc. The application.cfc has, as a property, a collection of session.cfcs and the session cfcs are linked to the user's session and to the collection. The session cfc stores things like the pages visited, user agent information, resolution information and whatever else I'd like to dump in there. When the user's session (the CF session) times out the session is (of course) unlinked from there. However it still exists in the application-based collection. I can use that collection to determine the number of logged in users, see the pages that the users have been visiting and control the users experience (if I want to). Since I know the user keys I can easily add "personal messages" on a whim (although I've never done this) that they would see on their page request and so forth. Since the session information persists longer than the session itself this also allows me to work with the data before it's destroyed: in other words it makes end-of-session processing simple. The collection has an expire() method that's run on a schedule. Session that have timed out are dissected and their information stored in the database then destroyed. This definitely means a performance hit on the page, but not at all an extreme one. You can see session counts and page times (as returned from getTickCount() in light grey text at the bottom of DepressedPress.com (hosted at CrystalTech. I'm not sure of the exact hardware anymore, but it's decent, mid-range hardware). Those pages are doing a lot more than just session management (the navigation is all dynamic, the clickstream is dynamic, the layout is all dynamic, security permissions are being checked and so forth). A general, content-only page takes between 100 and 200 ms to run. But if I display a "blank page" that's only running the basic framework elements page times head down to 40ms or so. I'd still like to improve that, but it's definitely not too slow for a lightly hit site like depressedpress.com If you'd like to see the code let me know. I still consider it "beta", but so far it's working okay (although I've still some bugs track down). Jim Davis From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED] Sent: Monday, August 09, 2004 9:23 AM To: CF-Talk Subject: RE: Count logged in user sessions Does anyone know the performance cost of things like the SessionTracker code? Without sessionTracker, I wanted to do something similar, but in my case, I wanted to make a struct for each session, put it in the session, and in the application, and then access it from both, for some realtime updates. I have a site which gets 400K-500K page views a day, and I am looking to minimize the impact of advanced session management. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: dump query before execution
You could just write your query in a block and then you sql would be saved as a variable that you could put in a block or block and do what you'd like with it. Maybe put conditions around the block to output it only at certain times. John -Original Message- From: George Abraham [mailto:[EMAIL PROTECTED] Sent: Monday, August 09, 2004 10:40 AM To: CF-Talk Subject: Re: dump query before execution That's what I do ultimately. I was just wondering if someone had a less time-consuming way of doing this. Thanks though, George On Mon, 9 Aug 2004 10:32:23 -0400, Ubqtous <[EMAIL PROTECTED]> wrote: > I'd just take a copy of the query code and replace the CFQUERY tags > with CFOUTPUT and then CFABORT afterwards to display the post-CF code > processing SQL. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Transaction Log Size
In my experience, here is what happens. start: log is 2 MB daily activity increase it to 3MB backup, log remains at 3MB but is empty daily activity increase it to 45MB* backup, log remains at 45MB but is empty daily activity = 3MB* backup, log remains at 45MB but is empty * typically a lrage update or insert of data causes this So the log size is 45 MB, and it will always use that space for the fist 45 MB of logged transactions, and increase if it has to, but nothing ever shrinks it. There may be a better way, but a qucick scheduled template to check the size after the backup and alert you via email when it is larger than XMB, can be an alert for you to shrink it. Dan - Original Message - From: David Koehler <[EMAIL PROTECTED]> Date: Mon, 09 Aug 2004 11:49:32 -0400 Subject: Re: Transaction Log Size To: CF-Talk <[EMAIL PROTECTED]> So, they should be "shrunked"? Dave >They get cleared, not removed, but the problem is they are not shrunk, >which is why they tend to get blown out of size. > >Dan > > >- Original Message - >From: Samuel R. Neff <[EMAIL PROTECTED]> >Date: Fri, 6 Aug 2004 16:36:38 -0400 >Subject: RE: Transaction Log Size >To: CF-Talk <[EMAIL PROTECTED]> > >The transaction logs get removed when you do a backup ('cause they're no > longer needed). > > Sam > > > > > -Original Message- > > From: David Koehler [mailto:[EMAIL PROTECTED] > > Sent: Friday, August 06, 2004 4:33 PM > > To: CF-Talk > > Subject: Transaction Log Size > > > > Some of our transaction logs are getting very large. I know I > > can set the database recovery model to simple and not have > > any logging, but is there a way to actually reduce the > > already massive log file size? > > > > Thanks in advance, > > > > dave [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
eWeek BLACKSTONE Article
Macromedia ColdFusion to Get Feature-Rich Upgrade http://www.eweek.com/article2/0,1759,1633484,00.asp Regards Damon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: BLACKSTONE Sneak Preview Posted
Yes. > Question, for the "Sourceless Deployment", is it possible to have > "mixed mode", that is, say, 99% code are compiled while leaving one or > two templates like application.cfm source code editable? TIA. > > > http://www.macromedia.com/software/coldfusion/ > > > > A few of the new ColdFusion "Blackstone" release features are > > discussed in some detail. > > > > Enjoy! > > > > Damon Cooper > > Dir of Eng, ColdFusion > > Macromedia > > [EMAIL PROTECTED] > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: Why is Flash so slow on OSX?
Does anyone (Macromedia folk particularly) know why Flash is so slow on OSX versus Windows? I've got a 1GHz G4 and it is usually slower than a co-worker's 266MHz PII Thinkpad. That just doesn't make sense. Is it a conspiracy or are Macromedia just using extremely sub-par compilers for OSX? -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 "Nothing endures but change." - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: dump query before execution
That sounds workable, other than the problem with using cfqueryparam outside of a cfquery block. George On Mon, 9 Aug 2004 12:22:54 -0400, Burns, John D <[EMAIL PROTECTED]> wrote: > You could just write your query in a block and then you > sql would be saved as a variable that you could put in a block > or block and do what you'd like with it. Maybe put > conditions around the block to output it only at certain > times. > > John > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Getting an image.. before display
>>The URL IS on the same server... Then you should be able to get the full path name. Have a look at CF_getNames at the address below (free tag) It can help you for this. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Calling CFCs with wget or curl -- What am I missing?
On Aug 9, 2004, at 9:09 AM, Dave Watts wrote: > > I can successfully call a remote (ws) cfc method with curl or > > wget, but I am unable to pass parameter data to the cfc. > > > > What's the secret? > > You should be able to pass parameters within the URL of the CFC > request: > > http://yourserver/your.cfc?param=value > That's just the point: http://localhost/cfusion/mycfmxapps/myWS.cfc? method=echoString&input=Hello works from a browser but, wget http://localhost/cfusion/mycfmxapps/myWS.cfc? method=echoString&input=Hello does not work from the command line: Here's the cfc: access="remote" > "hh:mm:ss:lll")/> TIA Dick > For obvious reasons, this will only work with simple values. > Honestly, I've > never tried this approach, since my use of CFCs has been limited to > more > traditional components and SOAP web services. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFX Tag help
Hi All, I am using CFX_google on one of the application I am working on. I have downloaded the tag from CFDEV website http://www.cfdev.com/xml/soap/google/ It comes in open source so you can pretty much change it. I want to know if any body can help me to change the max results in the class file and the generate the JAR file for me. I have no knowledge at all of JAVA so any help is appreciated. I want to retrieve up to 1000 results instead of 10 which come standard with the downloaded version. Thanks in advance. Ketan Patel [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Calling CFCs with wget or curl -- What am I missing?
> That's just the point: > > http://localhost/cfusion/mycfmxapps/myWS.cfc? > method=echoString&input=Hello > > works from a browser > > but, > > wget > http://localhost/cfusion/mycfmxapps/myWS.cfc? > method=echoString&input=Hello > > does not work from the command line If it can be done from a browser, it can be done using wget. Perhaps your server is configured to require host headers, or something like that? When you say it doesn't work, what exactly happens? Are you unable to capture output? If you're running wget on Windows, you'd have to use the -O parameter to specify an output file, since "myWS.cfc?method=echoString&input=Hello" isn't a valid file name, I suspect, but you shouldn't have that problem on Unix systems. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Transaction Log Size
Thanks Dan. I read that as long as I have a good backup I can detach the database and then delete the transaction log and then reattach the database. The new transaction log then begins at a small size. I tried this on a dummy database and all seems ok. Any inherent problems with doing this? Dave >In my experience, here is what happens. > >start: >log is 2 MB >daily activity increase it to 3MB >backup, log remains at 3MB but is empty > >daily activity increase it to 45MB* >backup, log remains at 45MB but is empty > >daily activity = 3MB* >backup, log remains at 45MB but is empty > >* typically a lrage update or insert of data causes this > >So the log size is 45 MB, and it will always use that space for the >fist 45 MB of logged transactions, and increase if it has to, but >nothing ever shrinks it. > >There may be a better way, but a qucick scheduled template to check >the size after the backup and alert you via email when it is larger >than XMB, can be an alert for you to shrink it. > >Dan > > > > > > >- Original Message - >From: David Koehler <[EMAIL PROTECTED]> >Date: Mon, 09 Aug 2004 11:49:32 -0400 >Subject: Re: Transaction Log Size >To: CF-Talk <[EMAIL PROTECTED]> > >So, they should be "shrunked"? > > Dave > > > > >They get cleared, not removed, but the problem is they are not shrunk, > >which is why they tend to get blown out of size. > > > >Dan > > > > > >- Original Message - > >From: Samuel R. Neff <[EMAIL PROTECTED]> > >Date: Fri, 6 Aug 2004 16:36:38 -0400 > >Subject: RE: Transaction Log Size > >To: CF-Talk <[EMAIL PROTECTED]> > > > >The transaction logs get removed when you do a backup ('cause they're no > > longer needed). > > > > Sam > > > > > > > > > -Original Message- > > > From: David Koehler [mailto:[EMAIL PROTECTED] > > > Sent: Friday, August 06, 2004 4:33 PM > > > To: CF-Talk > > > Subject: Transaction Log Size > > > > > > Some of our transaction logs are getting very large. I know I > > > can set the database recovery model to simple and not have > > > any logging, but is there a way to actually reduce the > > > already massive log file size? > > > > > > Thanks in advance, > > > > > > dave [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: MySQL 4.1 reliability?
How reliable is MySQL 4.1? I know its flagged as beta but would it be safe to use for a small task, e.g. a bug tracker? -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 "Nothing endures but change." - Heraclitus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMail
Got it and testing it out right now. Thanks Paul! Anyone else using this script? If so, how do you like it? Thank you, Donna French -Original Message- From: Paul Vernon [mailto:[EMAIL PROTECTED] Sent: Monday, August 09, 2004 11:12 AM To: CF-Talk Subject: RE: CFMail Matt Robertson has a great script for doing this on the following link! http://mysecretbase.com/Slowing_Down_CFMAIL.cfm Paul _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT: Why is Flash so slow on OSX?
Mmmm Maybe that explains it!. I have been quite vocal about Flash performance and resource consumption (mainly CPU cycles). It is especially noticeable when you have several browser windows open to pages containing Flash swfs. But, others seem unconcerned or do not notice the performance hit. At one point, I commented that the Flash RIA was Rich, Reach and Retch! I have Macs only -- and Flash performance was so bad that I never bothered to try it under VirtualPC emulation. Could it be that the Flash plugin implementation on OS X is at fault. One simple test it to fire up the OS X Activity Monitor. Then open a browser with only one window. After the browser's home page is loaded, CPU % will stabilize at 1-3%. Now go to http://www.macromedia.com/, cpu will stabilize at 8-15% now go to http://www.macromedia.com/software/flex/?promoid=home_prod_flex_111703# and select the Flex Code Explorer -- a window will popup -- In the menu tree open up a bunch of subfolders so the menu scrolls Then close the top folder -- it shudders and stutters as it closes the folder hierarchy. while doing this browser CPU % spikes to about 50% Now open another browser window and o=point it to www,macromedia.com CPU % goes to 35-50%, then stabilizes at 20-35% Conclusion: 2 Flash browser windows and 1 Flash popup are consuming 1/4 to 1/3 of my CPU (when they aren't doing anything (and aren't even topmost on the desktop). This really detracts from other Desktop applications. I agonize, whenever I need to go to the MM site (dloads, livedocs, blakstone info, etc), because it really is a performance hog. BTW, 1 GHz, 1Gig RAM, G4 with fast DSL connection. It would be really REALLY nice if this can be resolved by optimizing the OS X Flash plugin (and the player, too). Dick On Aug 9, 2004, at 9:48 AM, Damien McKenna wrote: > Does anyone (Macromedia folk particularly) know why Flash is so slow on > OSX versus Windows? I've got a 1GHz G4 and it is usually slower than > a > co-worker's 266MHz PII Thinkpad. That just doesn't make sense. Is it > a conspiracy or are Macromedia just using extremely sub-par compilers > for OSX? > -- > Damien McKenna - Web Developer - [EMAIL PROTECTED] > The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 > "Nothing endures but change." - Heraclitus > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Transaction Log Size
no. no problems with that. i have done/do that all the time ;) its ok. im really not sure why, but i think transaction logs are good as a LAST MEASURE to recover data. tw On Mon, 09 Aug 2004 13:45:37 -0400, David Koehler <[EMAIL PROTECTED]> wrote: > Thanks Dan. I read that as long as I have a good backup I can detach the database and then delete the transaction log and then reattach the database. The new transaction log then begins at a small size. I tried this on a dummy database and all seems ok. Any inherent problems with doing this? > > Dave > > >In my experience, here is what happens. > > > >start: > >log is 2 MB > >daily activity increase it to 3MB > >backup, log remains at 3MB but is empty > > > >daily activity increase it to 45MB* > >backup, log remains at 45MB but is empty > > > >daily activity = 3MB* > >backup, log remains at 45MB but is empty > > > >* typically a lrage update or insert of data causes this > > > >So the log size is 45 MB, and it will always use that space for the > >fist 45 MB of logged transactions, and increase if it has to, but > >nothing ever shrinks it. > > > >There may be a better way, but a qucick scheduled template to check > >the size after the backup and alert you via email when it is larger > >than XMB, can be an alert for you to shrink it. > > > >Dan > > > > > > > > > > > > > >- Original Message - > >From: David Koehler <[EMAIL PROTECTED]> > >Date: Mon, 09 Aug 2004 11:49:32 -0400 > >Subject: Re: Transaction Log Size > >To: CF-Talk <[EMAIL PROTECTED]> > > > >So, they should be "shrunked"? > > > > Dave > > > > > > > > >They get cleared, not removed, but the problem is they are not shrunk, > > >which is why they tend to get blown out of size. > > > > > >Dan > > > > > > > > >- Original Message - > > >From: Samuel R. Neff <[EMAIL PROTECTED]> > > >Date: Fri, 6 Aug 2004 16:36:38 -0400 > > >Subject: RE: Transaction Log Size > > >To: CF-Talk <[EMAIL PROTECTED]> > > > > > >The transaction logs get removed when you do a backup ('cause they're no > > > longer needed). > > > > > > Sam > > > > > > > > > > > > > -Original Message- > > > > From: David Koehler [mailto:[EMAIL PROTECTED] > > > > Sent: Friday, August 06, 2004 4:33 PM > > > > To: CF-Talk > > > > Subject: Transaction Log Size > > > > > > > > Some of our transaction logs are getting very large. I know I > > > > can set the database recovery model to simple and not have > > > > any logging, but is there a way to actually reduce the > > > > already massive log file size? > > > > > > > > Thanks in advance, > > > > > > > > dave [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: mysql insert rut roh
Are you putting the value in quotes when you insert? If you're not, then you're telling MySQL to insert a number, and number don't have leading zeros. Behind the scenes, MySQL is then coercing the number to a string to put in the field, but it starts as a number. If you wrap it in quotes, then MySQL will never interpret it as a number, so it'll retain it's leading zeros. cheers, barneyb On Mon, 9 Aug 2004 03:03:19 -0400, dave <[EMAIL PROTECTED]> wrote: > having some troubles inserting, lol > problem is that if i copy and paste(which i have to do) the # maybe like this 06618300 but when its inserted it strips the zero off the front to this 6618300. > its mysql the field is a varchar cause it could also have letters. > its really not a big deal except that i have a check in place to stop dups which that reall messes it up > tia > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Getting an image.. before display
Could you perhaps use FileExists() ? Kola -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: 09 August 2004 16:44 To: CF-Talk Subject: Re: Getting an image.. before display The URL IS on the same server... I shall look at converting the location... the problem is that from the database I would get something like "../somthing/somthin/image.jpg" and it would be converting that to a path MD On Mon, 09 Aug 2004 11:31:32 -0400, Claude Schneegans <[EMAIL PROTECTED]> wrote: > >> I have the url not the path > > Is the url phisically on the same server? > If not, then CFHTTP is you only (and time consuming) solution. > > -- > ___ > REUSE CODE! Use custom tags; > See http://www.contentbox.com/claude/customtags/tagstore.cfm > (Please send any spam to this address: [EMAIL PROTECTED]) > Thanks. > > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT: Why is Flash so slow on OSX?
Hey Dick, That's nothingtry loading a Flash animation that uses alpha transitions for fading effects and moving gradients. That eats about 90% of my CPU ;-) Guess why we ditched Flash for one of our recenty client's home page ;-) Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]