RE: Timeout and internal server errors
> I am encountering some sporadic errors when trying to connect > to a cf server. > > Scenario 1 > > Error Occurred While Processing Request > Error Executing Database Query. > Timed out trying to establish connection > > Scenario 2 > > Server Error > The server encountered an internal error and was unable to > complete your > request. > JRun closed connection. > > I am using Sparkplug CMS and this is happening on the login page > in a very sporadic manner. I had HostMySite verify the DSN and > they said it was ok. He also did a stack trace and said it times > out when trying to establish a connection. I would guess that this is being caused by your database drivers. You don't mention what database you're using, but it's worth pointing out that there are hotfixes available for database access if you're using CFMX 6.1: http://www.macromedia.com/v1/handlers/index.cfm?ID=20371&Method=Full 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]
RE: CF Live Chat application
the one i was thinking of wasnt the shout box but a dbless chat good luck finding a full fledge one like that 4 free i been looking at http://www.123flashchat.com/ for the price, its sweet > yes easycfm.com (my favorite tutorial site) does have a tutorial called > shout box live. I was just hoping that this one might be a lil more to > do Such as pvt chat windows and friend lists and the like... > > Rino > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF Live Chat application
yes easycfm.com (my favorite tutorial site) does have a tutorial called shout box live. I was just hoping that this one might be a lil more to do Such as pvt chat windows and friend lists and the like... Rino >From: <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: RE: CF Live Chat application >Date: Mon, 19 Jan 2004 18:50:50 -0700 (MST) > >if im not mistaken the tutorial is on easycfm.com > > > > > > > Same here, sounds like a wonderful tool! > > > > Hatton > > > >> -Original Message- > >> From: NANCY SKAGER [mailto:[EMAIL PROTECTED] > >> Sent: Monday, January 19, 2004 8:24 PM > >> To: CF-Talk > >> Subject: Re:CF Live Chat application > >> > >> hey Eric; > >> > >> I would love a peek at the code myself if you dont mindPlease > >> > >> Thanks; > >> Rino > >> > >> >From: Eric Creese <[EMAIL PROTECTED]> > >> >Reply-To: [EMAIL PROTECTED] > >> >To: CF-Talk <[EMAIL PROTECTED]> > >> >Subject: Re:CF Live Chat application > >> >Date: Mon, 19 Jan 2004 17:25:23 -0400 > >> > > >> >I am using an open source CF chat app that does not require > >> a database > >> >whatsoever. I modified it for my purposes to get the names of users > >> from the database for the site I am running so they could log in > >> easier. Really simple to use though. I found it on a developer site. > >> can not remember which one but I could send you my code either way. > >> > > >> > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Can CF do this?
yep bummer... thanks Matt. I did not realize this was happening, and of course it would have to be another aol issue.. Sorry to those that don't, but god I hate that company! Rino >From: "Matt Robertson" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: Re: Can CF do this? >Date: Mon, 19 Jan 2004 17:41:13 -0800 > >To add to the reasons given why this isn't particularly reliable, many ISPs >now use rotating IPs during the same connection. AOL is the most often >cited offender, with oftentimes each page request in a single session >coming from a different IP, but they by no means are the only ones doing >it. > >Then there's the dynamic IP I have on my home DSL connection, which are the >rule if you are on SBC (although you can buy a static one). That IP gets >assigned every time I disconnect/reconnect. > >Bummer, huh? > >-- >--- > Matt Robertson, [EMAIL PROTECTED] > MSB Designs, Inc. http://mysecretbase.com >--- > >-- > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF Live Chat application
if im not mistaken the tutorial is on easycfm.com > Same here, sounds like a wonderful tool! > > Hatton > >> -Original Message- >> From: NANCY SKAGER [mailto:[EMAIL PROTECTED] >> Sent: Monday, January 19, 2004 8:24 PM >> To: CF-Talk >> Subject: Re:CF Live Chat application >> >> hey Eric; >> >> I would love a peek at the code myself if you dont mindPlease >> >> Thanks; >> Rino >> >> >From: Eric Creese <[EMAIL PROTECTED]> >> >Reply-To: [EMAIL PROTECTED] >> >To: CF-Talk <[EMAIL PROTECTED]> >> >Subject: Re:CF Live Chat application >> >Date: Mon, 19 Jan 2004 17:25:23 -0400 >> > >> >I am using an open source CF chat app that does not require >> a database >> >whatsoever. I modified it for my purposes to get the names of users >> from the database for the site I am running so they could log in >> easier. Really simple to use though. I found it on a developer site. >> can not remember which one but I could send you my code either way. >> > >> > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF Live Chat application
Same here, sounds like a wonderful tool! Hatton > -Original Message- > From: NANCY SKAGER [mailto:[EMAIL PROTECTED] > Sent: Monday, January 19, 2004 8:24 PM > To: CF-Talk > Subject: Re:CF Live Chat application > > hey Eric; > > I would love a peek at the code myself if you dont mindPlease > > Thanks; > Rino > > >From: Eric Creese <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: CF-Talk <[EMAIL PROTECTED]> > >Subject: Re:CF Live Chat application > >Date: Mon, 19 Jan 2004 17:25:23 -0400 > > > >I am using an open source CF chat app that does not require > a database > >whatsoever. I modified it for my purposes to get the names of users > >from the database for the site I am running so they could log in > >easier. Really simple to use though. I found it on a developer site. > >can not remember which one but I could send you my code either way. > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Can CF do this?
To add to the reasons given why this isn't particularly reliable, many ISPs now use rotating IPs during the same connection. AOL is the most often cited offender, with oftentimes each page request in a single session coming from a different IP, but they by no means are the only ones doing it. Then there's the dynamic IP I have on my home DSL connection, which are the rule if you are on SBC (although you can buy a static one). That IP gets assigned every time I disconnect/reconnect. Bummer, huh? -- --- Matt Robertson, [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com --- -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Can CF do this?
CGI.REMOTE_ADDRESS (I think - I'd have to look it up to be absolutely sure). However, do not expect this to be 100% reliable. The reported IP address can be a proxy server's address, or may not be reported at all (depending on the browser). Shawn -Original Message- From: NANCY SKAGER [mailto:[EMAIL PROTECTED] Sent: Monday, January 19, 2004 6:18 PM To: CF-Talk Subject: Can CF do this? Again for security reasons, and maybe I don't need to do this... Can cold fusion capture a users ip adress and store it in a database on a given even like user login? If so, what code would I use? I'm sure I could find the answer myself, but a little help would be a big time saver! Thanks; Rino _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:CF Live Chat application
hey Eric; I would love a peek at the code myself if you dont mindPlease Thanks; Rino >From: Eric Creese <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: Re:CF Live Chat application >Date: Mon, 19 Jan 2004 17:25:23 -0400 > >I am using an open source CF chat app that does not require a database >whatsoever. I modified it for my purposes to get the names of users from >the database for the site I am running so they could log in easier. Really >simple to use though. I found it on a developer site. can not remember >which one but I could send you my code either way. > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Can CF do this?
> Again for security reasons, and maybe I don't need to do this... Can cold > fusion capture a users ip adress and store it in a database on a given even > like user login? If so, what code would I use? > > I'm sure I could find the answer myself, but a little help would be a big > time saver! > Not 100% reliably, as it's easy to spoof, but just check the CGI.remote_addr for the user's IP. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: session management help please
I see what you mean... Thanks for the insite Jim Thanks; Rino >From: "Jim McAtee" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: Re: session management help please >Date: Mon, 19 Jan 2004 01:52:18 -0700 > >- Original Message - >From: "NANCY SKAGER" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Sunday, January 18, 2004 8:15 PM >Subject: RE: session management help please > > > > Finally it comes to this > > > > As an old time chatter myself, I know from experiance, that when you log > > into a chatroom you can be there anywhere from 5 minutes to a couple of > > hours. This is the only thing messing with my session management. As I > > states earlier, I would like to add a who's online link to this site. It > > would upset me if I logged in a site and it said a friend of mine was >online > > and come to find out they left an hour ago but it still says they ar >logged > > in. > >Is this your biggest concern - doing an accurate "Who's On" list? > >I'm not certain you can use CF to get any kind of an active-session list >for >a given application, so you'll need to maintain the list yourself anyway. > >How you manage that list needn't be related to your login-session >managment. >You'll need to maintain this list in a persistent data store such as CF's >application scope, or in a database. You keep the list current by adding >new >users to the list when they enter the room, then you keep updating their >"last visited" date/time whenever they retrieve a page. Drop users from >the >list by setting some timeout value of 'X' minutes and deleting those that >have expired. This timeout value needn't be related in any way to the >timeout of the user's login session. You could, for instance, have a >session >timeout of one hour, but could use a "Who's On" timeout of 10 minutes. >Keep >in mind, though, that with a very short who's on timeout, you might see >what >looks like odd user behavior. Most likely it will look like you have users >who come in and leave and keep coming back again and again during what is >actually a single visit. > > > So I would need to set my timeout session to about 15 or 20 minutes, as > > there would be no reason to spend anymore time than that on any given >page > > other than the chatroom page. > > > > Again the chatroom page is the only one that is messing with my session > > management. And yes, I want my chat page on the secured section of my >site. > > Why you ask? Easy, you ever been to a chatroom where no matter what you >do > > somebody has got to be a jerk? I want to be able to suspend account >login >if > > needed. > > > > DUH! I just had a thought, tell me if this would work. It >sounds > > so simple that it wont work. What if on the chatroom window only I add a > > extra, very small frame, nothing in it but a little code. I refresh that > > frame, and that frame only, say every 2 minutes. In that case it should >keep > > the session active, yet should not offer a big bog down in the chat >applet. > > If someone surfs out of the chatroom page, it could load a new page >either > > with out that frame or swap that frame to a page not coded for refresh. >In > > this way useing cookies I could end the session if the browser closes, >or >by > > setting my time out the session would end shortly after the user leaves >my > > domain. Will this work? I think it will, tell me what you think. > >Doing this would most likely have exactly the opposite desired effect. >Someone goes to your chatroom page, and this bit of code keeps refreshing >the >page and keeping the user's session alive indefinitely. With absolutely no >interaction on their part. They cold have left the computer and gone on >vacation for all you know, but they'll appear to remain logged in. Same >thing if they (like I do) have 20 browser windows open, forget about the >chat >window, and go off and visit another site in a different browser window, or >start doing something else on the computer for a few hours. > > > One last quick question for the more expericenced. As you can tell this >site > > will be a online community. It will also offer a e-store. Is it better >to > > write two seperate applications (one for the store and the other to run >the > > site) or, run them under one application? > >If you have very short session timeouts (15 or 20 minutes qualifies), then >it's going to be an inconvenience for shoppers unless you keep their >shopping >carts intact between sessions. Someone puts a dozen items in a shopping >cart, gets a phone call, their session times out, and now they have to >start >shopping again - or not. An inconvenience for them, but ultimately the >seller's loss. > >With reasonable timeouts, a single application is probably best. Probably >easier for you to keep track of when coding and easier for your users. >It's >annoying to be forced to login repeately on different areas of the sa
Can CF do this?
Again for security reasons, and maybe I don't need to do this... Can cold fusion capture a users ip adress and store it in a database on a given even like user login? If so, what code would I use? I'm sure I could find the answer myself, but a little help would be a big time saver! Thanks; Rino [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SOT: DB Design Question
I Concur... Good Solution !! --Milan >From: "Jochem van Dieten" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: CF-Talk <[EMAIL PROTECTED]> >Subject: Re: SOT: DB Design Question >Date: Mon, 19 Jan 2004 22:17:53 +0100 (CET) > >Ben Densmore said: > > > > Top Level Header > > Sub Heading > > Title of Article > > > > I built 3 separate tables: > > One has just an ID and a Header field > > The second has an ID and the Sub Heading > > The third table has an ID, the Header Foreign Key and the > > SubHeading > > Foreign key and then the title and where the file is stored. > > > > The problem I'm having is when I do my query: > > > > Select appNotesHeaders.*,AppHeadings.*,appNotes.* > > from appNotesHeaders,AppHeadings,appNotes > > where > > AppNotes.HeaderFK = appNotesHeaders.appNotesHeadersID > > And > > AppNotes.HeadingFK = AppHeadings.App_Heading_ID > > > > > > It displays my Headers and Sub Headings more than once if there is > > more than one article in a given Header. > > > Am I totally losing it and not designing the DB right? > >You could put the top level and sub level headings in one table, but >for the current design your DB schema is fine. > >What you should do is group your output: > > Heading > > Subheading > > Article > > > > >Jochem > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Timeout and internal server errors
Ok, I just confirmed another detail: when I reboot it works fine. Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] >>> [EMAIL PROTECTED] 01/19/04 18:20 PM >>> Good evening cf-talk!! I am encountering some sporadic errors when trying to connect to a cf server. Scenario 1 Error Occurred While Processing Request Error Executing Database Query. Timed out trying to establish connection Scenario 2 Server Error The server encountered an internal error and was unable to complete your request. JRun closed connection. I am using Sparkplug CMS and this is happening on the login page in a very sporadic manner. I had HostMySite verify the DSN and they said it was ok. He also did a stack trace and said it times out when trying to establish a connection. Anyone seen this issue?? Thanks in advance!! Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Timeout and internal server errors
Good evening cf-talk!! I am encountering some sporadic errors when trying to connect to a cf server. Scenario 1 Error Occurred While Processing Request Error Executing Database Query. Timed out trying to establish connection Scenario 2 Server Error The server encountered an internal error and was unable to complete your request. JRun closed connection. I am using Sparkplug CMS and this is happening on the login page in a very sporadic manner. I had HostMySite verify the DSN and they said it was ok. He also did a stack trace and said it times out when trying to establish a connection. Anyone seen this issue?? Thanks in advance!! Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:OT-Server question
What do I need to do to reset the TTL? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX errors
I appreciate any pointers! I don't think any part of the site is using cfcontent.. -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Monday, January 19, 2004 5:22 PM To: CF-Talk Subject: RE: CFMX errors Ok, I've seen it another place. Unrelated to SQL. If your using cfcontent to download a file and the user clicks cancel, you will get that error. This and the SQL problem I mentioned where the only two times I have seen this. It was worth a shot. :-) -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED] Sent: Monday, January 19, 2004 5:12 PM To: CF-Talk Subject: RE: CFMX errors Well, there's only one or two DB related errors for the past week in the application.log, where the default-err.log file has 6 entries (like before) in the last 20 minutes alone. But, another server connecting to the same DB, also running CFMX, is having no problems. Odd.. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Cached Query Help
Why use that confusion Q of Q to cache the query. You've process the query once already, just store this in a permanent scope (session, application, server) and user to your hearts content? -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA -Original Message- From: Nikhil Madani [mailto:[EMAIL PROTECTED] Sent: Monday, January 19, 2004 1:18 PM To: CF-Talk Subject: Cached Query Help CFMX 6.1 Cached Query Problem: I have an XML file that I'm reading into a query object (to facilitate faster search) using the QueryNew(), QueryAddRow() and QuerySetCell() functions. Now, I need to hit this query often and I decided that caching it would be a good idea. Hence I did a query of query on it like so Select * from myQuery where myQuery is generated from the XML file using the functions above. As can be seen, this was a self-defeating exercise, because even before control flowed to the cfquery tag, generating the "myQuery" query from the XML file would've already taken place. To get around the same, the first time I read the XML file into the query, I set a server variable with the LastDTModified of the XML file, and would compare the server variable and the current LastDTModified to effectively create 2 code blocks Use cached query Create cached query Now the problem is, to use the cached query, I have to the same sql statement and tag signature. I tried this in the "Use Cached Query" block- select * from myQuery This actually worked! But without notice, every so often, it simply says "Query of queries error: No table myQuery found in Memory". I tried using cachedafter on both queries with the xml document's lastdtmodified to keep the queries same, but to no avail. The only way I've been able to make it run properly once it throws that error, was try flushing the cache more than once. Any suggestions, ideas why this works but fails every so often. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF Live Chat application
I was going to mention that one also, but I think it is more than a simple live support chat app. It is a nice app though, if you have enough memory. -Original Message- From: Eric Creese [mailto:[EMAIL PROTECTED] Sent: Monday, January 19, 2004 4:25 PM To: CF-Talk Subject: Re:CF Live Chat application I am using an open source CF chat app that does not require a database whatsoever. I modified it for my purposes to get the names of users from the database for the site I am running so they could log in easier. Really simple to use though. I found it on a developer site. can not remember which one but I could send you my code either way. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:CF Live Chat application
I am using an open source CF chat app that does not require a database whatsoever. I modified it for my purposes to get the names of users from the database for the site I am running so they could log in easier. Really simple to use though. I found it on a developer site. can not remember which one but I could send you my code either way. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX errors
Ok, I've seen it another place. Unrelated to SQL. If your using cfcontent to download a file and the user clicks cancel, you will get that error. This and the SQL problem I mentioned where the only two times I have seen this. It was worth a shot. :-) -Original Message- From: Jeff Beer [mailto:[EMAIL PROTECTED] Sent: Monday, January 19, 2004 5:12 PM To: CF-Talk Subject: RE: CFMX errors Well, there's only one or two DB related errors for the past week in the application.log, where the default-err.log file has 6 entries (like before) in the last 20 minutes alone. But, another server connecting to the same DB, also running CFMX, is having no problems. Odd.. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
(Admin) List changes
I'm proposing a number of new anti-spam features for the list and archives. I'm posting them to the HoF-Features list for discussion. You can join the list to get the mails in your box (and post) or just read it in the archive. It's sure to be interesting. :) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Cached Query Help
CFMX 6.1 Cached Query Problem: I have an XML file that I'm reading into a query object (to facilitate faster search) using the QueryNew(), QueryAddRow() and QuerySetCell() functions. Now, I need to hit this query often and I decided that caching it would be a good idea. Hence I did a query of query on it like so Select * from myQuery where myQuery is generated from the XML file using the functions above. As can be seen, this was a self-defeating exercise, because even before control flowed to the cfquery tag, generating the "myQuery" query from the XML file would've already taken place. To get around the same, the first time I read the XML file into the query, I set a server variable with the LastDTModified of the XML file, and would compare the server variable and the current LastDTModified to effectively create 2 code blocks Use cached query Create cached query Now the problem is, to use the cached query, I have to the same sql statement and tag signature. I tried this in the "Use Cached Query" block- select * from myQuery This actually worked! But without notice, every so often, it simply says "Query of queries error: No table myQuery found in Memory". I tried using cachedafter on both queries with the xml document's lastdtmodified to keep the queries same, but to no avail. The only way I've been able to make it run properly once it throws that error, was try flushing the cache more than once. Any suggestions, ideas why this works but fails every so often. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX errors
Well, there's only one or two DB related errors for the past week in the application.log, where the default-err.log file has 6 entries (like before) in the last 20 minutes alone. But, another server connecting to the same DB, also running CFMX, is having no problems. Odd.. -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Monday, January 19, 2004 3:25 PM To: CF-Talk Subject: RE: CFMX errors When we reboot the SQL machines and users are connected we receive this error. Most likely it is SQL and not CFMX. I would check the application log in the event viewer. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SOT: DB Design Question
Ben Densmore said: > > Top Level Header > Sub Heading > Title of Article > > I built 3 separate tables: > One has just an ID and a Header field > The second has an ID and the Sub Heading > The third table has an ID, the Header Foreign Key and the > SubHeading > Foreign key and then the title and where the file is stored. > > The problem I'm having is when I do my query: > > Select appNotesHeaders.*,AppHeadings.*,appNotes.* > from appNotesHeaders,AppHeadings,appNotes > where > AppNotes.HeaderFK = appNotesHeaders.appNotesHeadersID > And > AppNotes.HeadingFK = AppHeadings.App_Heading_ID > > > It displays my Headers and Sub Headings more than once if there is > more than one article in a given Header. > Am I totally losing it and not designing the DB right? You could put the top level and sub level headings in one table, but for the current design your DB schema is fine. What you should do is group your output: Heading Subheading Article Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SOT: DB Design Question
I am building a few new tables to store some articles and notes on our website. I want it structured so that it displays: Top Level Header Sub Heading Title of Article I built 3 separate tables: One has just an ID and a Header field The second has an ID and the Sub Heading The third table has an ID, the Header Foreign Key and the SubHeading Foreign key and then the title and where the file is stored. The problem I'm having is when I do my query: Select appNotesHeaders.*,AppHeadings.*,appNotes.* from appNotesHeaders,AppHeadings,appNotes where AppNotes.HeaderFK = appNotesHeaders.appNotesHeadersID And AppNotes.HeadingFK = AppHeadings.App_Heading_ID It displays my Headers and Sub Headings more than once if there is more than one article in a given Header. So right now I have a total of 3 Headers, I have multiple Sub Headings that can be under one header and multiple titles under each heading. So the output should look like: Application Notes General Application Notes Title 1 Title 2 Title 3 Amplifier Application Notes Title 1 Title 2 Title 3 Articles Featured Articles Title 1 Title 2 Title 3 But right now I am getting: Application Notes General Application Notes Title 1 Application Notes Title 2 Am I totally losing it and not designing the DB right? I have built way more complex databases than this but yet I'm struggling to see my mistake here. Thanks, Ben [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Fusebox Site is back up
I just noticed that the Fusebox.org site is back up and working again. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Vbscript and Coldfusion
thank you!!! this site http://www.ldapbrowser.com/ helped alot. thanks for the reference
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, January 19, 2004 12:51 PM
To: CF-Talk
Subject: RE: Vbscript and Coldfusion
nope, it was just a thought. Perhpas someone around here has done this. If its in the AD, and teh LDAP stuff is 'on' of course, you should be able to query it. Here is an example of query user data
name="empl"
attributes="
employeeID,
mail,
memberOf,
st,
name,
sn,
initials,
mobile,
givenName,
displayName,
userPrincipalName,
department,
streetAddress,
facsimileTelephoneNumber,
countryCode,
mailNickname,
l,
distinguishedName,
manager,
sAMAccountName,
extensionAttribute1"
start=" dc=fooey, dc=gooey
sort="sn ASC"
server="foo.goo.com"
port="389"
filter="sn=johnson"
>
Check out the LDAP browser from
http://www.ldapbrowser.com/
it rawks and should help you build your query. For example, in our AD I see CN=Computers listing all teh computers participating in the AD.
Note, if your AD admin has not turned on anonymous reads, you will need a UID/PWD.
HTH
Doug
-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]
Sent: Monday, January 19, 2004 12:35 PM
To: CF-Talk
Subject: RE: Vbscript and Coldfusion
do u have an example?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, January 19, 2004 12:29 PM
To: CF-Talk
Subject: RE: Vbscript and Coldfusion
why not use CFLDAP against your AD?
Doug
-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]
Sent: Monday, January 19, 2004 11:58 AM
To: CF-Talk
Subject: Vbscript and Coldfusion
i have this vbscript that gets me all the computer names in active directory.
is there a way i can incorporate this in cf and output the results to a select drop down box??
thanks for your help!
bec.
sDomain = "ms"
Set oDomain = GetObject("WinNT://" & sDomain)
oDomain.Filter = Array("Computer")
For Each oADobject In oDomain
WScript.Echo oADobject.Name
Next
*
This e-mail, including any attachments, is intended for the
receipt and use by the intended addressee(s), and may contain
confidential and privileged information. If you are not an intended
recipient of this e-mail, you are hereby notified that any unauthorized
use or distribution of this e-mail is strictly prohibited.
_
_
_
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Re: html to image
Cheers Peter - that did the trick - Original Message - From: Peter Tilbrook To: CF-Talk Sent: Monday, January 19, 2004 12:26 AM Subject: RE: html to image Perhaps http://www.pixel-technology.com/freeware/url2bmp/ Peter Tilbrook ColdFusion Applications Developer ColdGen Internet Solutions Manager, ACT and Region ColdFusion Users Group - http://www.actcfug.com 4/73 Tharwa Road Queanbeyan, NSW, 2620 AUSTRALIA Telephone: +61-2-6284-2727 Mobile: +61-0439-401-823 My wife says I never listen to her... At least I think that's what she said! \¯\/¯/ |¯|)¯) /¯/\¯\ \¯\/¯/ /_/\_\ |_|)_) \_\/_/ /_/\_\ RULES -Original Message- From: admin [mailto:[EMAIL PROTECTED] Sent: Monday, 19 January 2004 5:14 PM To: CF-Talk Subject: Re: html to image doesn't really do it I'm afraid - Original Message - From: brobborb To: CF-Talk Sent: Sunday, January 18, 2004 3:33 PM Subject: Re: html to image http://freedownloadswindows.com/windows/Capture/655846/CAP.html This is screen capture command line utility. awesome eh? :-D It'll save your pictures somewhere as JPGs or GIFs or whatever,. Figure u can use CFEXECUTE with it - Original Message - From: admin To: CF-Talk Sent: Saturday, January 17, 2004 4:04 PM Subject: html to image Apologies if this has been covered before, but I couldn't find anything in the archives. My problem is that I need to convert a webpage, it's a coldfusion generated stats page on a server, into an image (jpg, gif etc). This is so that I can view the server status from my TV via tivo. I've managed to do something crude using the cfx image tag but if I could capture the whole page and convert the html to an image I would be really happy. Any thoughts ? Cheers Richard [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX errors
When we reboot the SQL machines and users are connected we receive this error. Most likely it is SQL and not CFMX. I would check the application log in the event viewer. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX errors
One of my clients has tons of these entries in the C:\CFusionMX\runtime\logs\default-err.log. Does anyone have any tips on what might cause this? The server runs stable most of the time, but once in a while it seems to develop problems connecting to the database (SQL Server 2000). 01/19 09:56:11 error Connection reset java.net.SocketException: Connection reset at java.net.SocketInputStream.read(SocketInputStream.java:168) at java.io.BufferedInputStream.fill(BufferedInputStream.java:183) at java.io.BufferedInputStream.read1(BufferedInputStream.java:222) at java.io.BufferedInputStream.read(BufferedInputStream.java:277) at jrun.servlet.jrpp.ProxyEndpoint.readFully(ProxyEndpoint.java:530) at jrun.servlet.jrpp.ProxyEndpoint.readFully(ProxyEndpoint.java:522) at jrun.servlet.jrpp.ProxyEndpoint.readInt(ProxyEndpoint.java:540) at jrun.servlet.jrpp.ProxyEndpoint.readRequest(ProxyEndpoint.java:229) at jrun.servlet.jrpp.JRunProxyService.swapRunnable(JRunProxyService.java:14 4) at jrunx.scheduler.ThreadPool$DownstreamMetrics.swapRunnable(ThreadPool.jav a:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.swapRunnable(ThreadPool.java:4 33) at jrunx.scheduler.ThreadPool$UpstreamMetrics.swapRunnable(ThreadPool.java: 280) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:76) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFC problems - portability workaround
Wow, I wish I can fully explain my thoughts as well as you did. I agree with everything you said. >I'm not sure what you mean by that last one? Are you talking about making >CFCs persistent in some way other than the shared scopes? You said it best "ability to abstract complex stuff". Bryan -Original Message- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Monday, January 19, 2004 3:09 PM To: CF-Talk Subject: RE: CFC problems - portability workaround Personally I'd rather not see multiple inheritance in CFCs - it just complicates things up to much in my opinion. I personally would LOVE to be able to create packages with more complex directory structures... but I'm not sure how you'd do it (I assume you're talking about "real" packages with package-level roles and such - not just accessing things relatively). Still it would be nice - but I'd rather CFCs stay simpler than try to go "full-OO" on us. CF's biggest strength has always been its ability to abstract complex stuff. CFCs (for the most part) continue nicely in that tradition. adding lots of other OO stuff could cause them to be become much less accessible. Then again, maybe not - but I think that care needs to be taken to keep them as simple as possible while keeping them useful for the vast majority of application challenges. I'm not sure what you mean by that last one? Are you talking about making CFCs persistent in some way other than the shared scopes? Jim Davis [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFC problems - portability workaround
Personally I'd rather not see multiple inheritance in CFCs - it just complicates things up to much in my opinion. I personally would LOVE to be able to create packages with more complex directory structures... but I'm not sure how you'd do it (I assume you're talking about "real" packages with package-level roles and such - not just accessing things relatively). Still it would be nice - but I'd rather CFCs stay simpler than try to go "full-OO" on us. CF's biggest strength has always been its ability to abstract complex stuff. CFCs (for the most part) continue nicely in that tradition. adding lots of other OO stuff could cause them to be become much less accessible. Then again, maybe not - but I think that care needs to be taken to keep them as simple as possible while keeping them useful for the vast majority of application challenges. I'm not sure what you mean by that last one? Are you talking about making CFCs persistent in some way other than the shared scopes? Jim Davis _ From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Monday, January 19, 2004 1:53 AM To: CF-Talk Subject: RE: CFC problems - portability workaround Add to that the ability to extend more than one component. Built in ability to check where a CFC is being called from. i.e. tagcontext. Ability to have cfc in sub-directories under a package directory, so we can organize cfc packages. A easier way to initialize a cfc only once. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Could someone notify the proper people...
I spoke with my friend that hosts the site. He knows and is looking into it. Shawn Regan -Original Message- From: Mike Brunt [mailto:[EMAIL PROTECTED] Sent: Monday, January 19, 2004 12:09 PM To: CF-Talk Subject: RE: Could someone notify the proper people... I have done that. Kind Regards - Mike Brunt Original Message --- Could someone notify the proper people... that the fusebox.org site is throwing an error? Thanks...Che _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Could someone notify the proper people...
great...thanks Mike -Original Message- From: Mike Brunt [mailto:[EMAIL PROTECTED] Sent: Monday, January 19, 2004 3:09 PM To: CF-Talk Subject: RE: Could someone notify the proper people... I have done that. Kind Regards - Mike Brunt Original Message --- Could someone notify the proper people... that the fusebox.org site is throwing an error? Thanks...Che [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Could someone notify the proper people...
I have done that. Kind Regards - Mike Brunt Original Message --- Could someone notify the proper people... that the fusebox.org site is throwing an error? Thanks...Che [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Cold Fusion Oracle DSNs
Can any of you very experienced Oracle types give me a quick overview of the many different ways to create an Oracle DSN? As I understand it: 1) I can set up a ODBC driver through the MS ODBC manager, then set up a CF ODBC socket DSN. A) Oracle ODBC B) Microsoft Oracle ODBC 2) I can use the Oracle JDBC Thin Client and then set up a CF Other DSN. 3) Finally I can use the CF Oracle driver and set up a CF Oracle DSN. Which one of these is best? What might be the trade offs between one and the others? This is just plain confusing. Too many choices and not enough information on which choice may work best for me. -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA PS. I have experienced some trouble with the Oracle ODBC through the CF ODBC socket DSN. It apparently does not like a null date value in the first record of the returned record set. Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Running PHP code inside CF page
Cfhttp Spectrum WebDesign wrote: > Hi > > we're developing a support area for our site. I'm thinking about insert > a php live support code inside support.cfm page. How to? > > Thanks > -- > ___ > Get your free email from http://www.mail.com > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Could someone notify the proper people...
Could someone notify the proper people... that the fusebox.org site is throwing an error? Thanks...Che [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Running PHP code inside CF page
Hi we're developing a support area for our site. I'm thinking about insert a php live support code inside support.cfm page. How to? Thanks -- ___ Get your free email from http://www.mail.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Vbscript and Coldfusion
nope, it was just a thought. Perhpas someone around here has done this. If its in the AD, and teh LDAP stuff is 'on' of course, you should be able to query it. Here is an example of query user data
name="empl"
attributes="
employeeID,
mail,
memberOf,
st,
name,
sn,
initials,
mobile,
givenName,
displayName,
userPrincipalName,
department,
streetAddress,
facsimileTelephoneNumber,
countryCode,
mailNickname,
l,
distinguishedName,
manager,
sAMAccountName,
extensionAttribute1"
start=" dc=fooey, dc=gooey
sort="sn ASC"
server="foo.goo.com"
port="389"
filter="sn=johnson"
>
Check out the LDAP browser from
http://www.ldapbrowser.com/
it rawks and should help you build your query. For example, in our AD I see CN=Computers listing all teh computers participating in the AD.
Note, if your AD admin has not turned on anonymous reads, you will need a UID/PWD.
HTH
Doug
-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]
Sent: Monday, January 19, 2004 12:35 PM
To: CF-Talk
Subject: RE: Vbscript and Coldfusion
do u have an example?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, January 19, 2004 12:29 PM
To: CF-Talk
Subject: RE: Vbscript and Coldfusion
why not use CFLDAP against your AD?
Doug
-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]
Sent: Monday, January 19, 2004 11:58 AM
To: CF-Talk
Subject: Vbscript and Coldfusion
i have this vbscript that gets me all the computer names in active directory.
is there a way i can incorporate this in cf and output the results to a select drop down box??
thanks for your help!
bec.
sDomain = "ms"
Set oDomain = GetObject("WinNT://" & sDomain)
oDomain.Filter = Array("Computer")
For Each oADobject In oDomain
WScript.Echo oADobject.Name
Next
*
This e-mail, including any attachments, is intended for the
receipt and use by the intended addressee(s), and may contain
confidential and privileged information. If you are not an intended
recipient of this e-mail, you are hereby notified that any unauthorized
use or distribution of this e-mail is strictly prohibited.
_
_
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Vbscript and Coldfusion
do u have an example?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, January 19, 2004 12:29 PM
To: CF-Talk
Subject: RE: Vbscript and Coldfusion
why not use CFLDAP against your AD?
Doug
-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]
Sent: Monday, January 19, 2004 11:58 AM
To: CF-Talk
Subject: Vbscript and Coldfusion
i have this vbscript that gets me all the computer names in active directory.
is there a way i can incorporate this in cf and output the results to a select drop down box??
thanks for your help!
bec.
sDomain = "ms"
Set oDomain = GetObject("WinNT://" & sDomain)
oDomain.Filter = Array("Computer")
For Each oADobject In oDomain
WScript.Echo oADobject.Name
Next
*
This e-mail, including any attachments, is intended for the
receipt and use by the intended addressee(s), and may contain
confidential and privileged information. If you are not an intended
recipient of this e-mail, you are hereby notified that any unauthorized
use or distribution of this e-mail is strictly prohibited.
_
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Vbscript and Coldfusion
why not use CFLDAP against your AD?
Doug
-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]
Sent: Monday, January 19, 2004 11:58 AM
To: CF-Talk
Subject: Vbscript and Coldfusion
i have this vbscript that gets me all the computer names in active directory.
is there a way i can incorporate this in cf and output the results to a select drop down box??
thanks for your help!
bec.
sDomain = "ms"
Set oDomain = GetObject("WinNT://" & sDomain)
oDomain.Filter = Array("Computer")
For Each oADobject In oDomain
WScript.Echo oADobject.Name
Next
*
This e-mail, including any attachments, is intended for the
receipt and use by the intended addressee(s), and may contain
confidential and privileged information. If you are not an intended
recipient of this e-mail, you are hereby notified that any unauthorized
use or distribution of this e-mail is strictly prohibited.
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Vbscript and Coldfusion
The easiest way would be to write a VB COM object that does the talking to
the Active Directory and get CF to talk to a Method that returns a list or
something like...
HTH
-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]
Sent: Monday, January 19, 2004 16:58
To: CF-Talk
Subject: Vbscript and Coldfusion
i have this vbscript that gets me all the computer names in active
directory.
is there a way i can incorporate this in cf and output the results to a
select drop down box??
thanks for your help!
bec.
sDomain = "ms"
Set oDomain = GetObject("WinNT://" & sDomain)
oDomain.Filter = Array("Computer")
For Each oADobject In oDomain
WScript.Echo oADobject.Name
Next
*
This e-mail, including any attachments, is intended for the
receipt and use by the intended addressee(s), and may contain
confidential and privileged information. If you are not an intended
recipient of this e-mail, you are hereby notified that any unauthorized
use or distribution of this e-mail is strictly prohibited.
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Vbscript and Coldfusion
Try CFEXECUTE.
John Burns
-Original Message-
From: Jones, Becky [mailto:[EMAIL PROTECTED]
Sent: Monday, January 19, 2004 11:58 AM
To: CF-Talk
Subject: Vbscript and Coldfusion
i have this vbscript that gets me all the computer names in active
directory.
is there a way i can incorporate this in cf and output the results to a
select drop down box??
thanks for your help!
bec.
sDomain = "ms"
Set oDomain = GetObject("WinNT://" & sDomain) oDomain.Filter =
Array("Computer") For Each oADobject In oDomain WScript.Echo
oADobject.Name Next
*
This e-mail, including any attachments, is intended for the receipt and
use by the intended addressee(s), and may contain confidential and
privileged information. If you are not an intended recipient of this
e-mail, you are hereby notified that any unauthorized use or
distribution of this e-mail is strictly prohibited.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Vbscript and Coldfusion
i have this vbscript that gets me all the computer names in active directory.
is there a way i can incorporate this in cf and output the results to a select drop down box??
thanks for your help!
bec.
sDomain = "ms"
Set oDomain = GetObject("WinNT://" & sDomain)
oDomain.Filter = Array("Computer")
For Each oADobject In oDomain
WScript.Echo oADobject.Name
Next
*
This e-mail, including any attachments, is intended for the
receipt and use by the intended addressee(s), and may contain
confidential and privileged information. If you are not an intended
recipient of this e-mail, you are hereby notified that any unauthorized
use or distribution of this e-mail is strictly prohibited.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Browser WYSIWYG editors
This is the best one I've found. http://www.fredck.com/FCKeditor/ I haven't tested it on a lot of different clients, but it's very nice on IE. John Burns -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Monday, January 19, 2004 11:32 AM To: CF-Talk Subject: Browser WYSIWYG editors Hi All, Are there any WYSIWYG HTML editors that work with on Apple/Mac OS client machines? What browser(s) would they be able to run it on? Thanks, Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Browser WYSIWYG editors
Mozilla Composer. -- marlon "And Bobby you are right, I am being selfish, but the last time I checked, we don't have a whole lot of songs that feature the cowbell!" > -Original Message- > From: Mark Leder [mailto:[EMAIL PROTECTED] > Sent: Monday, January 19, 2004 10:32 AM > To: CF-Talk > Subject: Browser WYSIWYG editors > > Hi All, > > Are there any WYSIWYG HTML editors that work with on Apple/Mac OS client > machines? What browser(s) would they be able to run it on? > > Thanks, Mark > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Browser WYSIWYG editors
http://dynarch.com/mishoo/htmlarea.epl try that -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Monday, January 19, 2004 11:32 AM To: CF-Talk Subject: Browser WYSIWYG editors Hi All, Are there any WYSIWYG HTML editors that work with on Apple/Mac OS client machines? What browser(s) would they be able to run it on? Thanks, Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Browser WYSIWYG editors
Hi All, Are there any WYSIWYG HTML editors that work with on Apple/Mac OS client machines? What browser(s) would they be able to run it on? Thanks, Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: DateDiff Fixed!
the "" around the n worked -Original Message- From: JT [mailto:[EMAIL PROTECTED] Sent: Monday, January 19, 2004 9:04 AM To: CF-Talk Subject: DateDiff why does this not work? #Abs(DateDiff(n, date1, date2))# [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: DateDiff
thx mike
JT
-Original Message-
From: Mike Townend [mailto:[EMAIL PROTECTED]
Sent: Monday, January 19, 2004 9:08 AM
To: CF-Talk
Subject: RE: DateDiff
add quotes around the n
#Abs(DateDiff("n", date1, date2))#
-Original Message-
From: JT [mailto:[EMAIL PROTECTED]
Sent: Monday, January 19, 2004 16:04
To: CF-Talk
Subject: DateDiff
why does this not work?
#Abs(DateDiff(n, date1, date2))#
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: Cfc inheritance and best practices
Thanks David, Your feedback is appreciated. It was a long time I touched OO, and perhaps I need to brush up my OO knowledge :) /H. - Hugo Ahlenius E-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-Arendal Fax: +46 8 230441 Stockholm Office Mobile: +46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: Dave Carabetta [mailto:[EMAIL PROTECTED] | Sent: Monday, January 19, 2004 16:26 | To: CF-Talk | Subject: RE: Cfc inheritance and best practices | | >Hi, | > | >I'm a fairly new to CFCs (which seems cool). I have a little issue: | > | >I have two CFCs, let's call them CFCmain and CFCdao. CFCmain extends | >CFCdao, the former supplies the main interfaces, while the latter | >provides the data access (SQL) functions. | > | >I designed these to be unaware of any shared scopes. I set | the dsn to | >use using a property on CFCmain (it sets a default value when first | >instatiated). | > | >But, the property value on CFCmain (THIS.dsn), is not | accessible at all | >to CFCdao -- right? And there is no way to have this property on | >CFCdao, and it is then inherited to CFCmain (since you are | not allowed | >to use the this scope on a "base" object, right?). | > | >This means, in practice -- that the dsn string needs to be passed to | >any of my CFCdao functions (where the dsn is needed). | > | >Please let me know if my logic is correct, and if there is any | >preferred/alternative way to design this! | > | | Well, in my mind, you're not using inheritance correctly. The | "rule" I strictly go by for using inheritance is that you | should be able to use the two objects in the following sentence: | | [child class] is a [parent class] | car is a vehicle | | In your case CFCmain is *not* a CFCdao. You should be using | the notion of "composition," which is to say that CFCmain | *has* a CFCdao. To use composition in your case, I'd probably | just make a createObject() call either in the | quasi-constructor area or in my init() function (of which all | of my CFCs have) of the CFCmain class and pass in the name of | the dsn to the CFCdao's init() function. | | All that being said, you are correct that the parent class | does not have access to THIS.dsn in the child class. The | child class has access to the paren't variables, but not the | reverse (that I'm aware of). | | Regards, | Dave. | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: DateDiff
that worked thanks John. I guess the syntax in cf help is wrong JT -Original Message- From: John Stanley [mailto:[EMAIL PROTECTED] Sent: Monday, January 19, 2004 9:07 AM To: CF-Talk Subject: RE: DateDiff You have to put the n in quotes, othewise it thinks the n is a variable and not an argument. -Original Message- From: JT [mailto:[EMAIL PROTECTED] Sent: Monday, January 19, 2004 11:04 AM To: CF-Talk Subject: DateDiff why does this not work? #Abs(DateDiff(n, date1, date2))# _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: DateDiff
add quotes around the n
#Abs(DateDiff("n", date1, date2))#
-Original Message-
From: JT [mailto:[EMAIL PROTECTED]
Sent: Monday, January 19, 2004 16:04
To: CF-Talk
Subject: DateDiff
why does this not work?
#Abs(DateDiff(n, date1, date2))#
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: DateDiff
You have to put the n in quotes, othewise it thinks the n is a variable and not an argument. -Original Message- From: JT [mailto:[EMAIL PROTECTED] Sent: Monday, January 19, 2004 11:04 AM To: CF-Talk Subject: DateDiff why does this not work? #Abs(DateDiff(n, date1, date2))# _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Remember Me
yep...that's exactly what I do Jim...you nailed it (I shoulda mentioned that part) ;-) I've just always done custom session management...then I know it works ;-) Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: Jim McAtee To: CF-Talk Sent: Saturday, January 17, 2004 3:07 PM Subject: Re: Remember Me - Original Message - From: "Bryan Stevenson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, January 17, 2004 3:51 PM Subject: Re: Remember Me > A persistent cookie (set with CFCOOKIE with an expiry) will handle your > "remember" folks. So if they check the box then you set their session > cookie with an expiry. If they don't check the box then set the cookie > (non-persistent...in memory only and destroyed when browser closed) > without the expiry (don't even use the expiry attribute in CFCOOKIE). > > That's the brute force of it. There is some fine tuning ...for example > handling the cookie if someone changes their mind and no longer wants > to be remebered you'll have to toast the persistent cookie and then set > a non-persistent one. Beware of setting a cookie and then using > CFLOCATION (cookie won't get set...will need a cfcontent/cfheader > workaround). Thanks. So it sounds like my thinking that this couldn't be accomplished only through CF client managment is correct. Why not just use the cookie in conjunction with a CF-managed session? Use the cookie to note who the returning visitor is, then look up their user record in a database and establish a new CF session, same as if they'd gone through a login form? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
DateDiff
why does this not work? #Abs(DateDiff(n, date1, date2))# [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Flash for Developers/Programmers WAS: Flash Remoting with Blue Dragon
On Thursday 15 Jan 2004 15:54 pm, Christian Cantrell wrote: > On Thursday, January 15, 2004, at 10:14 AM, Thomas Chiverton wrote: > > A version of Central that allowed you to specify your own application > > 'store' > > would be great ! > > We've actually heard this a lot I thought you might have. In theory I can't see it being too hard*. The meta-shell looks at a start-up parameter (ini file, registry, whatever) to find the URL of somewhere to download all the shell set-up stuff from - I would be thinking XML based descriptions of where the list of applications is, for instance, and then initilises the Central shell itself with those params. -- 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]
RE: BlueDragon 6.1B2 issues
To get the number of active sessions in BlueDragon, use the following:
AppMgr=CreateObject("java","com.naryx.tagfusion.cfm.application.cfAPPLICATIO
N")>
Note that this gives the total number of sessions, and not the number of
sessions for a particular application (I'm not familiar with the CFMX
implementation, but the code snippet you gave implies that it's giving you
the number of sessions per application).
Vince Bonfanti
New Atlanta Communications, LLC
http://www.newatlanta.com
-Original Message-
From: Peter Tilbrook [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 17, 2004 6:33 PM
To: CF-Talk
Subject: RE: BlueDragon 6.1B2 issues
For the first one, if you remove the closing tag it will remove
the error (the closing tag is unnecessary; if you remove it your
code is still compatible with CF5/MX). This issue is documented in the
BlueDragon CFML Compatibility Guide:
"BlueDragon does not support closing tags for tags that do not
normally have a tag body. For this reason, BlueDragon does not support the
optional use of a closing when using METHOD='Get'. BlueDragon
does, however, support the use of a closing when using
METHOD='POST'."
>>
Bingo! That worked!
<<
For the second one, you're trying to create an instance of a class,
"coldfusion.runtime.SessionTracker" that is proprietary to CFMX and
therefore doesn't exist in BlueDragon. If you can tell me what you're trying
to accomplish, we'll see if we can figure out an equivalent way to do it in
BlueDragon.
>>
Just trying to keep track of the number of sessions the application is
maintaining (eg: 5 users are currently logged on).
Thanks for the help.
Peter Tilbrook
ColdFusion Applications Developer
ColdGen Internet Solutions
Manager, ACT and Region ColdFusion Users Group - http://www.actcfug.com
4/73 Tharwa Road
Queanbeyan, NSW, 2620
AUSTRALIA
Telephone: +61-2-6284-2727
Mobile: +61-0439-401-823
My wife says I never listen to her... At least I think that's what she said!
\¯\/¯/ |¯|)¯) /¯/\¯\ \¯\/¯/
/_/\_\ |_|)_) \_\/_/ /_/\_\ RULES
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: CFC problems - portability workaround
> This is similar to another post today. It's not a good practice to "extend" >a component if you can't say that > >[child class] is a [parent class] >car is a vehicle >What you should be using is composition (has-a relationship). To do this, >simply make some createObject() calls in the quasi-constructor area or in >your CFCs init() function. Which is the method I think is a pain in the butt. That's what I have been doing, but I don't like it. It should be more simple to write and manage. >I now see what your saying. However (and I guess this is just a stylistic >difference between you and I), it doesn't make sense in my mind to have a >factory object in a parent directory and then the objects that the factory >can create in children directories. Using your example, I'd do something >like >DAOFactory.cfc >and then in the same directory have CFCs for >Oracle.cfc >SQLServer.cfc >MySQL.cfc Your example is a package. And your right about being stylistic, it just looks weird to me. DOs are not the only thing that my factory does, maybe that's why I put it a directory above. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFC problems - portability workaround
I understand what your saying, but it just so simple to just extend the udf cfc. I like it because it simple. -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Monday, January 19, 2004 10:34 AM To: CF-Talk Subject: RE: CFC problems - portability workaround Why would you want to exend a UDF CFC? I don't grok OOP very well myself, but it is my understanding you only use extends/inheritance when you have a "IS A" relationship. Obviously your CFC is just using the UDF CFC for support functions and the like, and it would seem like a better idea to simply make an instance of the CFC inside the CFC itself. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFC problems - portability workaround
> > I disagree with this one (and don't think it's even possible anyway). >The > > ability to extend more than one class does not exist in JAVA either, >and I > > think it's a good thing. If you've ever worked with multiple >inheritance, it > > becomes very confusing very quickly. I love that JAVA got rid of it, >however > > they were also smart enough to give interfaces, which, in my mind is a >huge > > missing feature from the CFC implementation. > >I don't know anything about OOP. All I know is that I would like to >extend say a UDF CFC and >maybe a CFC that holds variables. This is similar to another post today. It's not a good practice to "extend" a component if you can't say that [child class] is a [parent class] car is a vehicle What you should be using is composition (has-a relationship). To do this, simply make some createObject() calls in the quasi-constructor area or in your CFCs init() function. > > > Am I misinterpreting what you're asking for? Are you suggesting that >you > > currently can't have com.foo.myCFCs or something? I'm able to put my >CFCs in > > sub-directories. > >What I'm looking for is the ability to place a factory cfc in a folder >and have a sub-folder under that directory that has a dataobjects folder >that holds db specific CFCs. Now I want to be able to add >access="package" to the functions in the db CFC where they can't be >called by any other place but from the factory.cfc. I know it possible >to write code to enforce this, but I want a easy built in way to do so. > >Right now AFAIK that functions with the access="package" attribute must >all be in the same directory. So the factory CFC would have to be in the >directory and not a directory above. I don't like this method because it >is unorganized. I now see what your saying. However (and I guess this is just a stylistic difference between you and I), it doesn't make sense in my mind to have a factory object in a parent directory and then the objects that the factory can create in children directories. Using your example, I'd do something like DAOFactory.cfc and then in the same directory have CFCs for Oracle.cfc SQLServer.cfc MySQL.cfc Again, that's purely stylistic and I'm not saying in any way that you're wrong for organizing your application the way you do. But that is just in response to your DAO factory example. In general, I agree with wanting the ability to use access="package" with CFCs in sub-directoriesa sometimes very frustrating limitation for me. > > > Not sure about what you mean here either. What's wrong with the > > createObject() function or cfobject tag? > >Code can be written to have a CFC initialize only once, but often times >it's a pain. I would like to see some built in way to initialize a >component only once. OK, I see what you're saying. However that functionality, in my experience at least, is not common enough to warrant an enhancement in the CFC implementation itself. I would say that at least 97% of my CFCs (if not higher) rely on the ability to create as many child objects as necessary. Again, in no way am I saying that you're "wrong," but I just think that this functionality *should* be left up to the developer. Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFC problems - portability workaround
> I don't know anything about OOP. All I know is that I would > like to extend say a UDF CFC and maybe a CFC that holds variables. > Why would you want to exend a UDF CFC? I don't grok OOP very well myself, but it is my understanding you only use extends/inheritance when you have a "IS A" relationship. Obviously your CFC is just using the UDF CFC for support functions and the like, and it would seem like a better idea to simply make an instance of the CFC inside the CFC itself. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Cfc inheritance and best practices
>Hi, > >I'm a fairly new to CFCs (which seems cool). I have a little issue: > >I have two CFCs, let's call them CFCmain and CFCdao. CFCmain extends >CFCdao, the former supplies the main interfaces, while the latter >provides the data access (SQL) functions. > >I designed these to be unaware of any shared scopes. I set the dsn to >use using a property on CFCmain (it sets a default value when first >instatiated). > >But, the property value on CFCmain (THIS.dsn), is not accessible at all >to CFCdao -- right? And there is no way to have this property on CFCdao, >and it is then inherited to CFCmain (since you are not allowed to use >the this scope on a "base" object, right?). > >This means, in practice -- that the dsn string needs to be passed to any >of my CFCdao functions (where the dsn is needed). > >Please let me know if my logic is correct, and if there is any >preferred/alternative way to design this! > Well, in my mind, you're not using inheritance correctly. The "rule" I strictly go by for using inheritance is that you should be able to use the two objects in the following sentence: [child class] is a [parent class] car is a vehicle In your case CFCmain is *not* a CFCdao. You should be using the notion of "composition," which is to say that CFCmain *has* a CFCdao. To use composition in your case, I'd probably just make a createObject() call either in the quasi-constructor area or in my init() function (of which all of my CFCs have) of the CFCmain class and pass in the name of the dsn to the CFCdao's init() function. All that being said, you are correct that the parent class does not have access to THIS.dsn in the child class. The child class has access to the paren't variables, but not the reverse (that I'm aware of). Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFC problems - portability workaround
> I disagree with this one (and don't think it's even possible anyway). The > ability to extend more than one class does not exist in JAVA either, and I > think it's a good thing. If you've ever worked with multiple inheritance, it > becomes very confusing very quickly. I love that JAVA got rid of it, however > they were also smart enough to give interfaces, which, in my mind is a huge > missing feature from the CFC implementation. I don't know anything about OOP. All I know is that I would like to extend say a UDF CFC and maybe a CFC that holds variables. > Am I misinterpreting what you're asking for? Are you suggesting that you > currently can't have com.foo.myCFCs or something? I'm able to put my CFCs in > sub-directories. What I'm looking for is the ability to place a factory cfc in a folder and have a sub-folder under that directory that has a dataobjects folder that holds db specific CFCs. Now I want to be able to add access="package" to the functions in the db CFC where they can't be called by any other place but from the factory.cfc. I know it possible to write code to enforce this, but I want a easy built in way to do so. Right now AFAIK that functions with the access="package" attribute must all be in the same directory. So the factory CFC would have to be in the directory and not a directory above. I don't like this method because it is unorganized. > Not sure about what you mean here either. What's wrong with the > createObject() function or cfobject tag? Code can be written to have a CFC initialize only once, but often times it's a pain. I would like to see some built in way to initialize a component only once. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFC problems - portability workaround
>Add to that the ability to extend more than one component. > I disagree with this one (and don't think it's even possible anyway). The ability to extend more than one class does not exist in JAVA either, and I think it's a good thing. If you've ever worked with multiple inheritance, it becomes very confusing very quickly. I love that JAVA got rid of it, however they were also smart enough to give interfaces, which, in my mind is a huge missing feature from the CFC implementation. >Built in ability to check where a CFC is being called from. i.e. >tagcontext. OK. I personally don't have a need for that, but I could see where others might (I think this just came up on the CFCDev mailing list as well). >Ability to have cfc in sub-directories under a package directory, so we >can organize cfc packages. Am I misinterpreting what you're asking for? Are you suggesting that you currently can't have com.foo.myCFCs or something? I'm able to put my CFCs in sub-directories. >A easier way to initialize a cfc only once. Not sure about what you mean here either. What's wrong with the createObject() function or cfobject tag? Regards, Dave. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Write to html file
Nevermind... I figured it out. Apparently it needed some config info changed and a reboot... Josen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Persistent Login issue
Ok, I'll try the question again... I have a few different areas of my site that I only want registered users to have access to. 1) I set up a session.allowed variable in my Application.cfm (defaulted to 0) if the variable isn't already present. Code: 2) I set up switches in the necessary pages to show a login include if the session.allowed var equalled 0. Code: What's Here? 3) I set up my check so that, if login was successful, the session.allowed var is set to 1. Code: After a user logs in I see, using debugging, that the var is now set to 1. But, when I go to another page (within the site), I see that the var is reset to 0. This shouldn't happen as the code in the App only sets to 0 if the var doesn't exist in the first place (see item 1 above for code). Anyone have any ideas? Cutter [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MX 6.1 Internationalization
briefly looking at the zip file... my first thoughts are that the Application.cfm file included in the root of that zip file is incorrect as it looks to be the CFIDE Application.cfm file rather than what I would assume to be a blank Application.cfm file Try removing the Application.cfm file and see if that helps HTH -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Monday, January 19, 2004 14:07 To: CF-Talk Subject: MX 6.1 Internationalization I need to get up to speed on Internationalization in CF MX. Went to http://www.macromedia.com/support/coldfusion/internationalization/internatio nalization_cfmx/ and downloaded the .zip file. Instructions on that page say "When the file decompresses, a folder named internationalization_example_pages is created on your system", so I assumed that it's coded intelligently enough to find what it needs Unzipped and put in a directory on my machine that's under locahost (http://localhost/tmp/i18ndocs/, to be specific. Now I'm getting a "Can't find include/udflibrary.cfm" error message, and there is no such directory or file in the .zip file that I downloaded. Where am I supposed to put this unzipped directory so that it will actually work? Are there any other I18n guides for MX 6.1 out there? Thanks Pete _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: strange cfc recursion issue...
Not that it helps much, but I took your same code and had no issues when I the result of getMetaData on an instance of it. You running MX 6.1? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
MX 6.1 Internationalization
I need to get up to speed on Internationalization in CF MX. Went to http://www.macromedia.com/support/coldfusion/internationalization/internationalization_cfmx/ and downloaded the .zip file. Instructions on that page say "When the file decompresses, a folder named internationalization_example_pages is created on your system", so I assumed that it's coded intelligently enough to find what it needs Unzipped and put in a directory on my machine that's under locahost (http://localhost/tmp/i18ndocs/, to be specific. Now I'm getting a "Can't find include/udflibrary.cfm" error message, and there is no such directory or file in the .zip file that I downloaded. Where am I supposed to put this unzipped directory so that it will actually work? Are there any other I18n guides for MX 6.1 out there? Thanks Pete [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: strange cfc recursion issue...
As just an FYI, when calling methods inside a CFC, you should NOT use this.METHOD() instead, you should use METHOD() Why? When you use this.METHOD(), it acts as if you were calling the method from the outside. That means you will be prevented from calling private methods. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Write to html file
did you make the change to the xml file? there is an xml file that needs to be altered a bit... its not tough... Open the C:\CFusionMX\wwwroot\WEB-INF\web.xml . You can modify the extension mappings by adding these lines: CfmServlet *.html and replace *.html with whatever you need to extend the cf functionality too! hth tony -Original Message- From: Josen Ruiseco [mailto:[EMAIL PROTECTED] Sent: Monday, January 19, 2004 8:03 AM To: CF-Talk Subject: Re:Write to html file How do you do this? I went into application extensions and added .htm to be run as a .cfm page. I restarted the CF service and now I get an error message stating: SERVER ERROR: Either the Macromedia application server is unreachable or it does not have a mapping to process this request. Is there more that needs to be done? I am running MX 6.1... Thanks, Josen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re:Write to html file
How do you do this? I went into application extensions and added .htm to be run as a .cfm page. I restarted the CF service and now I get an error message stating: SERVER ERROR: Either the Macromedia application server is unreachable or it does not have a mapping to process this request. Is there more that needs to be done? I am running MX 6.1... Thanks, Josen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF Live Chat application
On Monday 19 Jan 2004 13:07 pm, Spectrum WebDesign wrote: > I'm looking for (maybe free, open source) CF Live Chat application for use > in our support area. Java is a good choice? [side: funny thread to reply to that...] Java is a programing language. Not a 'live chat' application. I usualy suggest a Java applet hooked into a IRC server at this point. -- 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]
Re: Unresponsive threads
That's the "Timeout requests after (seconds) [blank]" setting in CF Admin Chris Norloff -- Original Message -- From: "Marlon Moyer" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Fri, 16 Jan 2004 12:28:32 -0600 >I've been researching my logs and I'm finding a lot of lines like such: > > > >A request exceeded the timeout. The unresponsive thread count is up to 1 > > > >My question is how long is the timeout for a thread to be considered >unresponsive? > > > >-- > >marlon > > > >"And Bobby you are right, I am being selfish, but the last time I checked, >we don't have a whole lot of songs that feature the cowbell!" > > > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF Live Chat application
I'm looking for (maybe free, open source) CF Live Chat application for use in our support area. Java is a good choice? - Original Message - From: "Michael T. Tangorre" <[EMAIL PROTECTED]> Date: Mon, 19 Jan 2004 07:44:01 -0500 To: CF-Talk <[EMAIL PROTECTED]> Subject: RE: OT: Zipcode transfer woes continue.. An example of a zipcode ending in a zero would be Boston, MA 02210. When importing it into sql server it becomes 221. I can try your suggestion of inserting them into a properly padded string, but how would you determine which zips have leading or trailing zeros? There are 43,000 records, which to confirm one at time would be a chore in and of itself. Mike _ From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, January 19, 2004 5:28 AM To: CF-Talk Subject: Re: OT: Zipcode transfer woes continue.. Michael T. Tangorre wrote: > > Sorry to keep beating a dead horse but I can not for the life of me get this > zipcode table I have in access imported into SQL server without losing the > zeros (initial and/or trailing). You are not losing the initial zeros. You can't be, because they are not there. What you are storing is just simple numbers without initial zeros, and you have set up a display filter (the Access equivalent of an automagic NumberFormat()) to make it look like they have initial zeros. Add an extra field in the Access table and insert them as properly padded strings in there. Then convert from there to MS SQL Server. As for the trailing zeros, do you have an example? Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT: Zipcode transfer woes continue.. (SOLVED)
Thanks to everyone who gave me some input on this... I woulnd up copying the data into excel, changing the column type in excel to special-zipcode, saving the excel file as a CSV file and then importing it into SQL Server. All transfered great. Thanks for everyones input. Mike _ From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, January 19, 2004 8:01 AM To: CF-Talk Subject: Re: OT: Zipcode transfer woes continue.. Michael T. Tangorre wrote: > An example of a zipcode ending in a zero would be Boston, MA 02210. > When importing it into sql server it becomes 221. > I can try your suggestion of inserting them into a properly padded string, > but how would you determine which zips have leading or trailing zeros? There > are 43,000 records, which to confirm one at time would be a chore in and of > itself. In a copy of your Access database run the following: ALTER TABLE table ADD COLUMN zipstring char(5); UPDATE TABLE table SET zipstring = zipnumber; UPDATE TABLE table SET zipstring = '0' & zipstring WHERE Len(zipstring) = 4; UPDATE TABLE table SET zipstring = '0' & zipstring WHERE Len(zipstring) = 4; UPDATE TABLE table SET zipstring = '0' & zipstring WHERE Len(zipstring) = 4; UPDATE TABLE table SET zipstring = '0' & zipstring WHERE Len(zipstring) = 4; Then try importing the table with the new zipstring field in MS SQL Server. Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: Zipcode transfer woes continue..
Michael T. Tangorre wrote: > An example of a zipcode ending in a zero would be Boston, MA 02210. > When importing it into sql server it becomes 221. > I can try your suggestion of inserting them into a properly padded string, > but how would you determine which zips have leading or trailing zeros? There > are 43,000 records, which to confirm one at time would be a chore in and of > itself. In a copy of your Access database run the following: ALTER TABLE table ADD COLUMN zipstring char(5); UPDATE TABLE table SET zipstring = zipnumber; UPDATE TABLE table SET zipstring = '0' & zipstring WHERE Len(zipstring) = 4; UPDATE TABLE table SET zipstring = '0' & zipstring WHERE Len(zipstring) = 4; UPDATE TABLE table SET zipstring = '0' & zipstring WHERE Len(zipstring) = 4; UPDATE TABLE table SET zipstring = '0' & zipstring WHERE Len(zipstring) = 4; Then try importing the table with the new zipstring field in MS SQL Server. Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT: Zipcode transfer woes continue..
An example of a zipcode ending in a zero would be Boston, MA 02210. When importing it into sql server it becomes 221. I can try your suggestion of inserting them into a properly padded string, but how would you determine which zips have leading or trailing zeros? There are 43,000 records, which to confirm one at time would be a chore in and of itself. Mike _ From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, January 19, 2004 5:28 AM To: CF-Talk Subject: Re: OT: Zipcode transfer woes continue.. Michael T. Tangorre wrote: > > Sorry to keep beating a dead horse but I can not for the life of me get this > zipcode table I have in access imported into SQL server without losing the > zeros (initial and/or trailing). You are not losing the initial zeros. You can't be, because they are not there. What you are storing is just simple numbers without initial zeros, and you have set up a display filter (the Access equivalent of an automagic NumberFormat()) to make it look like they have initial zeros. Add an extra field in the Access table and insert them as properly padded strings in there. Then convert from there to MS SQL Server. As for the trailing zeros, do you have an example? Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Encrypted Tags not working on MX?
Thanks, Dave, that solved the issue. (*pounds head*) Hatton > -Original Message- > From: Dave Watts [mailto:[EMAIL PROTECTED] > Sent: Saturday, January 17, 2004 3:56 PM > To: CF-Talk > Subject: RE: Encrypted Tags not working on MX? > > > Okay, I'm confused. I'm using an encrypted custom tag for a > calendar > > popup and it runs fine on my development environment > version of CFMX > > 6.1, however I just moved it to the hosting server and rather than > > processing the encrypted CF file, it's just outputting the > contents of > > the encrypted file. > > If you're using FTP, try recopying the file in binary mode. > What happens if you request the custom tag directly via the browser? > > 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]
Re: date function help for calendar
On Friday 16 Jan 2004 16:29 pm, Smith, Matthew P -CONT(CSC) wrote: > view to default to the current week. So using the now() function, I need > to find the, say, Sunday before and the Saturday after the current day. If dayToday is not dayToLookFor while dayToday is not dayTolookfor( add one day to dateToday dayToday = dayofweek(dateToday) wend return dateToday else return dateToday fi -- 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]
Re: OT: Zipcode transfer woes continue..
Michael T. Tangorre wrote: > > Sorry to keep beating a dead horse but I can not for the life of me get this > zipcode table I have in access imported into SQL server without losing the > zeros (initial and/or trailing). You are not losing the initial zeros. You can't be, because they are not there. What you are storing is just simple numbers without initial zeros, and you have set up a display filter (the Access equivalent of an automagic NumberFormat()) to make it look like they have initial zeros. Add an extra field in the Access table and insert them as properly padded strings in there. Then convert from there to MS SQL Server. As for the trailing zeros, do you have an example? Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
strange cfc recursion issue...
I've got this issue with a component I've been working on... it's trully bizarre... a description of the issue is on my blog here: http://www.turnkey.to/ontap/blog/?20040119 Any suggestions greatly appreciated. The cfc code is here (sorry for the line breaks): email="[EMAIL PROTECTED]" hint="this is the core CFC for the onTap framework. All other CFC's in the ontap framework should ultimately extend this cfc for introspection and other core architectural functionality"> hint="initializes the CFC with required properties, etc."> tepath()))> output="true" access="private" hint="appends default values to the meta data of a function"> output="true" access="private" hint="appends default values to the meta data of a cfc property"> access="private" hint="returns a structure containing all methods (including inherited) from the current component with keys matching method names"> hint="function|property = name of array to convert to structure with ancestor information"> default="#getMetaData(this)#" hint="a CFC metadata structure to search -- defaults to the current CFC"> and isstruct(myobject.extends) and structkeyexists(myobject.extends,"displayname")> structappend(mymeta,getMetaStruct(metatype,myobject.extends),false)> access="public"> default="false" hint="toggles the returned string between html and SPEC formatted xml content"> and structkeyexists(ancestor,"extends")> default="#structnew()#"> language="ColdFusion 6.0" structkeyexists(mydata.extends,"displayname")> extends="#htmleditformat(mydata.extends.displayname)#" author="#htmleditformat(mydata.author)#" email="#htmleditformat(mydata.email)#"> #htmleditformat(mydata.hint)# #htmleditformat(mydata.example)# list="#listsort(structkeylist(library),'textnocase')#"> return="#htmleditformat(mymethod.returntype)#" output="#yesnoformat(mymethod.output)#" roles="#htmleditformat(mymethod.roles)#"> #htmleditformat(mymethod.hint)# #htmleditformat(mymethod.example)# default="false"> required="#yesnoformat(arg.required)#" type="#htmleditformat(lcase(arg.type))#" default="#htmleditformat(arg.default)#"> #htmleditformat(arg.hint)# list="#listsort(structkeylist(properties),'textnocase')#"> purpose="#htmleditformat(property.hint)#" required="#yesnoformat(property.required)#" type="#htmleditformat(property.type)#" default="#htmleditformat(property.default)#"> style="font-family:verdana; font-size: 9pt; margin-top: 20px;"> nowrap>#htmleditformat(mydata.displayname)# extends condition="structkeyexists(ancestor,'displayname')"> => ancestor.library & '&cfc=' & ancestor.displayname,'docs')#">#ancestor.displayname# #ancestor.displayname# ancestor.extends> Usage: #htmleditformat(mydata.hint)# Example: #htmleditformat(mydata.example)# mydata.email> #htmleditformat(mydata.author)# Author: #authorxref# PropertiesRequiredTypeDefault CFCPurpose list="#listsort(structkeylist(properties),'textnocase')#"> #property.name# #yesnoformat(property.required)# #property.type# #htmleditformat(property.default)# [#request.tapi.typeof(proeprty.default)#] #property.cfcname# #htmleditformat(property.hint)# Methods list="#listsort(structkeylist(methods),'textnocase')#"> mymethod.cfclibrary & '&cfc=' & mymethod.cfcname,'docs')#"> #htmle
Cf template gives 404
[I'll resend this, in case it got stuck in the server problems at hof...] Hi, I have mystical problem, to amuse you on a Friday afternoon. After upgrading from CF4.51 to CFMX there is one template that returns a 404. This is Solaris machine, running CFMX and Apache. * It seems to be Apache returing the error, not CFMX * If I rename the template, it works * If I move the template to a different directory, it works * If I rename the directory, it works * Moving Application.cfm away doesn't change anything. * It doesn't matter what is in the template (the code) * A directory with the same name works at other places in the file-system * I can't find anything in the Apache docs that indicate that we are using any reserved words The template is called sendpass.cfm and is under a folder called "administration" (it is used to send out the password to users that have forgotten it). Any clues/suggestions are welcome!!! /Hugo - Hugo Ahlenius E-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-Arendal Fax: +46 8 230441 Stockholm Office Mobile: +46 733 467111 WWW: http://www.grida.no - ### This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. For more information, connect to http://www.F-Secure.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: session management help please
- Original Message - From: "NANCY SKAGER" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, January 18, 2004 8:15 PM Subject: RE: session management help please > Finally it comes to this > > As an old time chatter myself, I know from experiance, that when you log > into a chatroom you can be there anywhere from 5 minutes to a couple of > hours. This is the only thing messing with my session management. As I > states earlier, I would like to add a who's online link to this site. It > would upset me if I logged in a site and it said a friend of mine was online > and come to find out they left an hour ago but it still says they ar logged > in. Is this your biggest concern - doing an accurate "Who's On" list? I'm not certain you can use CF to get any kind of an active-session list for a given application, so you'll need to maintain the list yourself anyway. How you manage that list needn't be related to your login-session managment. You'll need to maintain this list in a persistent data store such as CF's application scope, or in a database. You keep the list current by adding new users to the list when they enter the room, then you keep updating their "last visited" date/time whenever they retrieve a page. Drop users from the list by setting some timeout value of 'X' minutes and deleting those that have expired. This timeout value needn't be related in any way to the timeout of the user's login session. You could, for instance, have a session timeout of one hour, but could use a "Who's On" timeout of 10 minutes. Keep in mind, though, that with a very short who's on timeout, you might see what looks like odd user behavior. Most likely it will look like you have users who come in and leave and keep coming back again and again during what is actually a single visit. > So I would need to set my timeout session to about 15 or 20 minutes, as > there would be no reason to spend anymore time than that on any given page > other than the chatroom page. > > Again the chatroom page is the only one that is messing with my session > management. And yes, I want my chat page on the secured section of my site. > Why you ask? Easy, you ever been to a chatroom where no matter what you do > somebody has got to be a jerk? I want to be able to suspend account login if > needed. > > DUH! I just had a thought, tell me if this would work. It sounds > so simple that it wont work. What if on the chatroom window only I add a > extra, very small frame, nothing in it but a little code. I refresh that > frame, and that frame only, say every 2 minutes. In that case it should keep > the session active, yet should not offer a big bog down in the chat applet. > If someone surfs out of the chatroom page, it could load a new page either > with out that frame or swap that frame to a page not coded for refresh. In > this way useing cookies I could end the session if the browser closes, or by > setting my time out the session would end shortly after the user leaves my > domain. Will this work? I think it will, tell me what you think. Doing this would most likely have exactly the opposite desired effect. Someone goes to your chatroom page, and this bit of code keeps refreshing the page and keeping the user's session alive indefinitely. With absolutely no interaction on their part. They cold have left the computer and gone on vacation for all you know, but they'll appear to remain logged in. Same thing if they (like I do) have 20 browser windows open, forget about the chat window, and go off and visit another site in a different browser window, or start doing something else on the computer for a few hours. > One last quick question for the more expericenced. As you can tell this site > will be a online community. It will also offer a e-store. Is it better to > write two seperate applications (one for the store and the other to run the > site) or, run them under one application? If you have very short session timeouts (15 or 20 minutes qualifies), then it's going to be an inconvenience for shoppers unless you keep their shopping carts intact between sessions. Someone puts a dozen items in a shopping cart, gets a phone call, their session times out, and now they have to start shopping again - or not. An inconvenience for them, but ultimately the seller's loss. With reasonable timeouts, a single application is probably best. Probably easier for you to keep track of when coding and easier for your users. It's annoying to be forced to login repeately on different areas of the same web site. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Cfc inheritance and best practices
Hi, I'm a fairly new to CFCs (which seems cool). I have a little issue: I have two CFCs, let's call them CFCmain and CFCdao. CFCmain extends CFCdao, the former supplies the main interfaces, while the latter provides the data access (SQL) functions. I designed these to be unaware of any shared scopes. I set the dsn to use using a property on CFCmain (it sets a default value when first instatiated). But, the property value on CFCmain (THIS.dsn), is not accessible at all to CFCdao -- right? And there is no way to have this property on CFCdao, and it is then inherited to CFCmain (since you are not allowed to use the this scope on a "base" object, right?). This means, in practice -- that the dsn string needs to be passed to any of my CFCdao functions (where the dsn is needed). Please let me know if my logic is correct, and if there is any preferred/alternative way to design this! Thanks, Hugo - Hugo Ahlenius E-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-Arendal Fax: +46 8 230441 Stockholm Office Mobile: +46 733 467111 WWW: http://www.grida.no - ### This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. For more information, connect to http://www.F-Secure.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: html to image
Perhaps http://www.pixel-technology.com/freeware/url2bmp/ Peter Tilbrook ColdFusion Applications Developer ColdGen Internet Solutions Manager, ACT and Region ColdFusion Users Group - http://www.actcfug.com 4/73 Tharwa Road Queanbeyan, NSW, 2620 AUSTRALIA Telephone: +61-2-6284-2727 Mobile: +61-0439-401-823 My wife says I never listen to her... At least I think that's what she said! \¯\/¯/ |¯|)¯) /¯/\¯\ \¯\/¯/ /_/\_\ |_|)_) \_\/_/ /_/\_\ RULES -Original Message- From: admin [mailto:[EMAIL PROTECTED] Sent: Monday, 19 January 2004 5:14 PM To: CF-Talk Subject: Re: html to image doesn't really do it I'm afraid - Original Message - From: brobborb To: CF-Talk Sent: Sunday, January 18, 2004 3:33 PM Subject: Re: html to image http://freedownloadswindows.com/windows/Capture/655846/CAP.html This is screen capture command line utility. awesome eh? :-D It'll save your pictures somewhere as JPGs or GIFs or whatever,. Figure u can use CFEXECUTE with it - Original Message - From: admin To: CF-Talk Sent: Saturday, January 17, 2004 4:04 PM Subject: html to image Apologies if this has been covered before, but I couldn't find anything in the archives. My problem is that I need to convert a webpage, it's a coldfusion generated stats page on a server, into an image (jpg, gif etc). This is so that I can view the server status from my TV via tivo. I've managed to do something crude using the cfx image tag but if I could capture the whole page and convert the html to an image I would be really happy. Any thoughts ? Cheers Richard [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
txt file which lines don't have the same length
Hi,
How can I make a request by using a txt file which lines don't have the same length ?
This txt file is generated by a compiled program that make lines of this type with ";" as delimeter.
example lines...
date;code;lib;value1;value2;value3;Name;First name;value;
13/01/2004 11:36;345;London;0025;0415;0012;SMITH;Deborah;0085;
13/01/2004 11:36;202;Paris;0144;0002;0711;CLIFTON;Jack;0055;COLLINS;Jenifer;0033;
13/01/2004 11:36;711;TOKYO;0125;0075;0102;PAUL;Sean;0077;BOSTON;Mickael;0114;CHRIS;Helen;0072;
On line #2 you read Clifton and Collins attached to {13/01/2004 11:36;202;Paris;0144;0002;0711;}
but on line#3 there are Paul,Boston and Chris attached to {13/01/2004 11:36;202;Paris;0144;0002;0711;} and I can't duplicate my columns' name
I just can have one Name column, one Surname column and one value Column and yet, this txt files contains 2 or 3 or 4 persons for one record...
I've tried to use
Error processing CFFILE Error attempting to read 'C:\Documents and Settings\myName\R54T01.txt.'
and I typed this code :
#file.message#
the option box CFFILE is properly ticked in the CF administrator settings... but I can't read anything and I need to create a requested table no matter how many people by line
Can someone help me ?
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
