Queries with pretty column names
I have some CFCs that return queries to a flash app for use in a datagrid. The query have to return pretty column names (like 'Case Number') so that flash can display them properly. Now I need to access them same results from elsewhere in CF. How can I get to those fields in the recordset? I can't do "#queryname.'Pretty Field Name'#" Any ideas short of writing new queries? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: and record id
I see. I was leaning away from it anyhoo. Thank you and have a good weekend. >You won't be able to use @@IDENTITY with CFINSERT. I would recommend that >you avoid CFINSERT and CFUPDATE anyway, and just write your own SQL. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How do I perform a radius search based on zip code?
>SELECT ZIP_CODE, (180/Pi() * (ACOS ((SIN(Pi()/180*#OriginLatitude#) * >SIN(Pi()/180*Latitude)) + (COS(Pi()/180*#Attributes.OriginLatitude#) * >COS(Pi()/180*Latitude) * COS(Pi()/180*ABS(#Attributes.OriginLongitude# - >Longitude) * 69.11) AS Distance >FROM ZipCodes >WHERE (180/Pi() * (ACOS ((SIN(Pi()/180*#Attributes.OriginLatitude#) * >SIN(Pi()/180*Latitude)) + (COS(Pi()/180*#Attributes.OriginLatitude#) * >COS(Pi()/180*Latitude) * COS(Pi()/180*ABS(#Attributes.OriginLongitude# - >Longitude) * 69.11) <= #Attributes.Radius# >ORDER BY Distance Hrmmm. THAT probably explains why MapQuest _insists_ that I live at a Fish Hatchery. :) --min [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: and record id
> > If you're using SQL Server, for instance, you can use > > @@IDENTITY (or SCOPE_IDENTITY in newer versions) to refer > > to the new identity column value. > > So, after doing the cfinsert, I tried using @@IDENTITY within > the CF, but I'm not sure how to reference it. I'm using MS > Sequal Server so it should be there. Does it work ok with a > cfinsert or must I do a cfquery? > > I've done some searches in the archives must they always use > it within a query so it's just sql at that point. I saw one > use of it in CF, but it was in a named query and I'm doing a > cfinsert. Should I switch? You won't be able to use @@IDENTITY with CFINSERT. I would recommend that you avoid CFINSERT and CFUPDATE anyway, and just write your own SQL. 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: Adding elements to a structure
Thanks, Pascal. Your assumption was correct, and works great! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MAX 2004 Conference date?
That's Mr. Geek. Paul Kenney WebMaster, CorporateWarriors.com 916-663-1963 -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 3:00 PM To: CF-Talk Subject: RE: MAX 2004 Conference date? as I said GEEKS! tony r e v o l u t i o n w e b d e s i g n [EMAIL PROTECTED] www.revolutionwebdesign.com its only looks good to those who can see bad as well -anonymous -Original Message- From: Paul Kenney [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 5:04 PM To: CF-Talk Subject: RE: MAX 2004 Conference date? What about NULL? Paul Kenney WebMaster, CorporateWarriors.com 916-663-1963 -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 1:57 PM To: CF-Talk Subject: RE: MAX 2004 Conference date? true true its all good ben. we just lack patience. nothing too surprising here. we are geeks. we have no patience. its 1 and 0. nothing in between. have a good weekend all! later tony -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 4:54 PM To: CF-Talk Subject: RE: MAX 2004 Conference date? Last week I think I said "very shortly", not "very, very shortly". :-) Ugh, this is killing me! :-( _ From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 4:49 PM To: CF-Talk Subject: Re: MAX 2004 Conference date? lol. thats what you said last week. are we there yet? -adam > -Original Message- > From: Ben Forta [mailto:[EMAIL PROTECTED] > Sent: Friday, March 19, 2004 07:33 PM > To: 'CF-Talk' > Subject: RE: MAX 2004 Conference date? > > No, but I am expecting an announcement very, very shortly. Stay tuned. > > --- Ben > > > _ > > From: Bosky, Dave [mailto:[EMAIL PROTECTED] > Sent: Friday, March 19, 2004 2:29 PM > To: CF-Talk > Subject: MAX 2004 Conference date? > > > Has Macromedia announced this year's conference date? > > ~Dave > > HTC Disclaimer: The information contained in this message may be privileged > and confidential and protected from disclosure. If the reader of this > message is not the intended recipient, or an employee or agent > responsible for delivering this message to the intended recipient, you > are hereby notified that any dissemination, distribution or copying of > this communication is strictly prohibited. If you have received this > communication in error, please notify us immediately by replying to > the message and deleting it from your computer. Thank you. > _ > > > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MAX 2004 Conference date?
as I said GEEKS! tony r e v o l u t i o n w e b d e s i g n [EMAIL PROTECTED] www.revolutionwebdesign.com its only looks good to those who can see bad as well -anonymous -Original Message- From: Paul Kenney [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 5:04 PM To: CF-Talk Subject: RE: MAX 2004 Conference date? What about NULL? Paul Kenney WebMaster, CorporateWarriors.com 916-663-1963 -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 1:57 PM To: CF-Talk Subject: RE: MAX 2004 Conference date? true true its all good ben. we just lack patience. nothing too surprising here. we are geeks. we have no patience. its 1 and 0. nothing in between. have a good weekend all! later tony -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 4:54 PM To: CF-Talk Subject: RE: MAX 2004 Conference date? Last week I think I said "very shortly", not "very, very shortly". :-) Ugh, this is killing me! :-( _ From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 4:49 PM To: CF-Talk Subject: Re: MAX 2004 Conference date? lol. thats what you said last week. are we there yet? -adam > -Original Message- > From: Ben Forta [mailto:[EMAIL PROTECTED] > Sent: Friday, March 19, 2004 07:33 PM > To: 'CF-Talk' > Subject: RE: MAX 2004 Conference date? > > No, but I am expecting an announcement very, very shortly. Stay tuned. > > --- Ben > > > _ > > From: Bosky, Dave [mailto:[EMAIL PROTECTED] > Sent: Friday, March 19, 2004 2:29 PM > To: CF-Talk > Subject: MAX 2004 Conference date? > > > Has Macromedia announced this year's conference date? > > ~Dave > > HTC Disclaimer: The information contained in this message may be privileged > and confidential and protected from disclosure. If the reader of this > message is not the intended recipient, or an employee or agent > responsible for delivering this message to the intended recipient, you > are hereby notified that any dissemination, distribution or copying of > this communication is strictly prohibited. If you have received this > communication in error, please notify us immediately by replying to > the message and deleting it from your computer. Thank you. > _ > > > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How do I perform a radius search based on zip code?
Using a zipcode table with longitude and latitudes, here's a query to get the zipcodes and distances in a given radius of an origin zip code: SELECT ZIP_CODE, (180/Pi() * (ACOS ((SIN(Pi()/180*#OriginLatitude#) * SIN(Pi()/180*Latitude)) + (COS(Pi()/180*#Attributes.OriginLatitude#) * COS(Pi()/180*Latitude) * COS(Pi()/180*ABS(#Attributes.OriginLongitude# - Longitude) * 69.11) AS Distance FROM ZipCodes WHERE (180/Pi() * (ACOS ((SIN(Pi()/180*#Attributes.OriginLatitude#) * SIN(Pi()/180*Latitude)) + (COS(Pi()/180*#Attributes.OriginLatitude#) * COS(Pi()/180*Latitude) * COS(Pi()/180*ABS(#Attributes.OriginLongitude# - Longitude) * 69.11) <= #Attributes.Radius# ORDER BY Distance Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF 5.0 on Solaris/Oracle 8.1.7/Verity Indexing
Yeah and at .5 FTE, I will be set for life. (cue the evil music) Muahahahahahahahahahahaha! -Bret (thoughtfully stroking the goatee on my chinny-chin-chin) Jerry Johnson wrote: > Repeat after me ... > > "Job Security" > > =) > > Glad you figured it out. > > Jerry Johnson > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Clearing all Cached Queries (Attn: Ray C.)
if I am correct Qasim -Original Message- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 1:43 PM To: CF-Talk Subject: Clearing all Cached Queries (Attn: Ray C.) Ray, You told me once of a way to clear out all cached queries at once, but I'll be darned if I can find the thread. Would you please repeat? Thanks, Jamie _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MAX 2004 Conference date?
What about NULL? Paul Kenney WebMaster, CorporateWarriors.com 916-663-1963 -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 1:57 PM To: CF-Talk Subject: RE: MAX 2004 Conference date? true true its all good ben. we just lack patience. nothing too surprising here. we are geeks. we have no patience. its 1 and 0. nothing in between. have a good weekend all! later tony -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 4:54 PM To: CF-Talk Subject: RE: MAX 2004 Conference date? Last week I think I said "very shortly", not "very, very shortly". :-) Ugh, this is killing me! :-( _ From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 4:49 PM To: CF-Talk Subject: Re: MAX 2004 Conference date? lol. thats what you said last week. are we there yet? -adam > -Original Message- > From: Ben Forta [mailto:[EMAIL PROTECTED] > Sent: Friday, March 19, 2004 07:33 PM > To: 'CF-Talk' > Subject: RE: MAX 2004 Conference date? > > No, but I am expecting an announcement very, very shortly. Stay tuned. > > --- Ben > > > _ > > From: Bosky, Dave [mailto:[EMAIL PROTECTED] > Sent: Friday, March 19, 2004 2:29 PM > To: CF-Talk > Subject: MAX 2004 Conference date? > > > Has Macromedia announced this year's conference date? > > ~Dave > > HTC Disclaimer: The information contained in this message may be privileged > and confidential and protected from disclosure. If the reader of this > message is not the intended recipient, or an employee or agent responsible > for delivering this message to the intended recipient, you are hereby > notified that any dissemination, distribution or copying of this > communication is strictly prohibited. If you have received this > communication in error, please notify us immediately by replying to the > message and deleting it from your computer. Thank you. > _ > > > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MAX 2004 Conference date?
OK, just as long the answer isn't "Yesterday! Ha, you missed it!" :) Paul Kenney WebMaster, CorporateWarriors.com 916-663-1963 -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 1:54 PM To: CF-Talk Subject: RE: MAX 2004 Conference date? Last week I think I said "very shortly", not "very, very shortly". :-) Ugh, this is killing me! :-( _ From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 4:49 PM To: CF-Talk Subject: Re: MAX 2004 Conference date? lol. thats what you said last week. are we there yet? -adam > -Original Message- > From: Ben Forta [mailto:[EMAIL PROTECTED] > Sent: Friday, March 19, 2004 07:33 PM > To: 'CF-Talk' > Subject: RE: MAX 2004 Conference date? > > No, but I am expecting an announcement very, very shortly. Stay tuned. > > --- Ben > > > _ > > From: Bosky, Dave [mailto:[EMAIL PROTECTED] > Sent: Friday, March 19, 2004 2:29 PM > To: CF-Talk > Subject: MAX 2004 Conference date? > > > Has Macromedia announced this year's conference date? > > ~Dave > > HTC Disclaimer: The information contained in this message may be privileged > and confidential and protected from disclosure. If the reader of this > message is not the intended recipient, or an employee or agent responsible > for delivering this message to the intended recipient, you are hereby > notified that any dissemination, distribution or copying of this > communication is strictly prohibited. If you have received this > communication in error, please notify us immediately by replying to the > message and deleting it from your computer. Thank you. > _ > > > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MAX 2004 Conference date?
Just remember there are 10 kinds of people. Those who know binary and those who don't. :) Steve -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 4:57 PM To: CF-Talk Subject: RE: MAX 2004 Conference date? true true its all good ben. we just lack patience. nothing too surprising here. we are geeks. we have no patience. its 1 and 0. nothing in between. have a good weekend all! later tony -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 4:54 PM To: CF-Talk Subject: RE: MAX 2004 Conference date? Last week I think I said "very shortly", not "very, very shortly". :-) Ugh, this is killing me! :-( _ From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 4:49 PM To: CF-Talk Subject: Re: MAX 2004 Conference date? lol. thats what you said last week. are we there yet? -adam > -Original Message- > From: Ben Forta [mailto:[EMAIL PROTECTED] > Sent: Friday, March 19, 2004 07:33 PM > To: 'CF-Talk' > Subject: RE: MAX 2004 Conference date? > > No, but I am expecting an announcement very, very shortly. Stay tuned. > > --- Ben > > > _ > > From: Bosky, Dave [mailto:[EMAIL PROTECTED] > Sent: Friday, March 19, 2004 2:29 PM > To: CF-Talk > Subject: MAX 2004 Conference date? > > > Has Macromedia announced this year's conference date? > > ~Dave > > HTC Disclaimer: The information contained in this message may be privileged > and confidential and protected from disclosure. If the reader of this > message is not the intended recipient, or an employee or agent responsible > for delivering this message to the intended recipient, you are hereby > notified that any dissemination, distribution or copying of this > communication is strictly prohibited. If you have received this > communication in error, please notify us immediately by replying to the > message and deleting it from your computer. Thank you. > _ > > > > _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MAX 2004 Conference date?
> Last week I think I said "very shortly", not "very, very shortly". :-) Does that mean it's time to start an office (list) pool? Let's see.. My guess is Oct 5-8 in New Orleans... -Cameron - Cameron Childress Sumo Consulting Inc --- land: 858.509.3098 cell: 678.637.5072 aim: cameroncf email: [EMAIL PROTECTED] -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 1:54 PM To: CF-Talk Subject: RE: MAX 2004 Conference date? Last week I think I said "very shortly", not "very, very shortly". :-) Ugh, this is killing me! :-( _ From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 4:49 PM To: CF-Talk Subject: Re: MAX 2004 Conference date? lol. thats what you said last week. are we there yet? -adam > -Original Message- > From: Ben Forta [mailto:[EMAIL PROTECTED] > Sent: Friday, March 19, 2004 07:33 PM > To: 'CF-Talk' > Subject: RE: MAX 2004 Conference date? > > No, but I am expecting an announcement very, very shortly. Stay tuned. > > --- Ben > > > _ > > From: Bosky, Dave [mailto:[EMAIL PROTECTED] > Sent: Friday, March 19, 2004 2:29 PM > To: CF-Talk > Subject: MAX 2004 Conference date? > > > Has Macromedia announced this year's conference date? > > ~Dave > > HTC Disclaimer: The information contained in this message may be privileged > and confidential and protected from disclosure. If the reader of this > message is not the intended recipient, or an employee or agent responsible > for delivering this message to the intended recipient, you are hereby > notified that any dissemination, distribution or copying of this > communication is strictly prohibited. If you have received this > communication in error, please notify us immediately by replying to the > message and deleting it from your computer. Thank you. > _ > > > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MAX 2004 Conference date?
true true its all good ben. we just lack patience. nothing too surprising here. we are geeks. we have no patience. its 1 and 0. nothing in between. have a good weekend all! later tony -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 4:54 PM To: CF-Talk Subject: RE: MAX 2004 Conference date? Last week I think I said "very shortly", not "very, very shortly". :-) Ugh, this is killing me! :-( _ From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 4:49 PM To: CF-Talk Subject: Re: MAX 2004 Conference date? lol. thats what you said last week. are we there yet? -adam > -Original Message- > From: Ben Forta [mailto:[EMAIL PROTECTED] > Sent: Friday, March 19, 2004 07:33 PM > To: 'CF-Talk' > Subject: RE: MAX 2004 Conference date? > > No, but I am expecting an announcement very, very shortly. Stay tuned. > > --- Ben > > > _ > > From: Bosky, Dave [mailto:[EMAIL PROTECTED] > Sent: Friday, March 19, 2004 2:29 PM > To: CF-Talk > Subject: MAX 2004 Conference date? > > > Has Macromedia announced this year's conference date? > > ~Dave > > HTC Disclaimer: The information contained in this message may be privileged > and confidential and protected from disclosure. If the reader of this > message is not the intended recipient, or an employee or agent responsible > for delivering this message to the intended recipient, you are hereby > notified that any dissemination, distribution or copying of this > communication is strictly prohibited. If you have received this > communication in error, please notify us immediately by replying to the > message and deleting it from your computer. Thank you. > _ > > > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MAX 2004 Conference date?
Last week I think I said "very shortly", not "very, very shortly". :-) Ugh, this is killing me! :-( _ From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 4:49 PM To: CF-Talk Subject: Re: MAX 2004 Conference date? lol. thats what you said last week. are we there yet? -adam > -Original Message- > From: Ben Forta [mailto:[EMAIL PROTECTED] > Sent: Friday, March 19, 2004 07:33 PM > To: 'CF-Talk' > Subject: RE: MAX 2004 Conference date? > > No, but I am expecting an announcement very, very shortly. Stay tuned. > > --- Ben > > > _ > > From: Bosky, Dave [mailto:[EMAIL PROTECTED] > Sent: Friday, March 19, 2004 2:29 PM > To: CF-Talk > Subject: MAX 2004 Conference date? > > > Has Macromedia announced this year's conference date? > > ~Dave > > HTC Disclaimer: The information contained in this message may be privileged > and confidential and protected from disclosure. If the reader of this > message is not the intended recipient, or an employee or agent responsible > for delivering this message to the intended recipient, you are hereby > notified that any dissemination, distribution or copying of this > communication is strictly prohibited. If you have received this > communication in error, please notify us immediately by replying to the > message and deleting it from your computer. Thank you. > _ > > > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MAX 2004 Conference date?
lol. thats what you said last week. are we there yet? -adam > -Original Message- > From: Ben Forta [mailto:[EMAIL PROTECTED] > Sent: Friday, March 19, 2004 07:33 PM > To: 'CF-Talk' > Subject: RE: MAX 2004 Conference date? > > No, but I am expecting an announcement very, very shortly. Stay tuned. > > --- Ben > > > _ > > From: Bosky, Dave [mailto:[EMAIL PROTECTED] > Sent: Friday, March 19, 2004 2:29 PM > To: CF-Talk > Subject: MAX 2004 Conference date? > > > Has Macromedia announced this year's conference date? > > ~Dave > > HTC Disclaimer: The information contained in this message may be privileged > and confidential and protected from disclosure. If the reader of this > message is not the intended recipient, or an employee or agent responsible > for delivering this message to the intended recipient, you are hereby > notified that any dissemination, distribution or copying of this > communication is strictly prohibited. If you have received this > communication in error, please notify us immediately by replying to the > message and deleting it from your computer. Thank you. > _ > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF 5.0 on Solaris/Oracle 8.1.7/Verity Indexing
Repeat after me ... "Job Security" =) Glad you figured it out. Jerry Johnson [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF 5.0 on Solaris/Oracle 8.1.7/Verity Indexing
I think I may have found the problem. What was supposed to be a Verity index of just the headlines, keywords, and subheads was converted to also index all of the content for each record at some point in time. So it's getting 1200 records, looping through each one, adding a keywords column to the query results using QueryAddColumn() and QuerySetCell(), then writing that to one Verity collection. Then it grabs all of the content (from a large home-brewed CMS) from all 1200 or so records and sends those to another Verity collection. I'm pretty sure it's a memory/disk space thing. The system has outgrown the scheduled tasks. Sigh. Another broken thing to fix here again. -Bret Jerry Johnson wrote: > Bret, > > Is there enough hard disk space to hold 2 copies of the collection? > How many unique records in the index? > > Are you indexing data from the Oracle db, or is a file-type collection? > Are you running the K2 server or vdk collections? > How are you indexing the collection (cfindex?) > > And a general question. Why is CFExec running? Is this how the scheduler > works? > > Up to my elbows in Verity today myself. > Jerry Johnson [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MAX 2004 Conference date?
This fall/winter? :-) _ From: Paul Kenney [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 3:36 PM To: CF-Talk Subject: RE: MAX 2004 Conference date? That's what you said last time. C'mon, be creative... Like "This year." ;) Paul Kenney WebMaster, CorporateWarriors.com 916-663-1963 -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 11:33 AM To: CF-Talk Subject: RE: MAX 2004 Conference date? No, but I am expecting an announcement very, very shortly. Stay tuned. --- Ben _ From: Bosky, Dave [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 2:29 PM To: CF-Talk Subject: MAX 2004 Conference date? Has Macromedia announced this year's conference date? ~Dave HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: CF 5.0 on Solaris/Oracle 8.1.7/Verity Indexing
Bret, Is there enough hard disk space to hold 2 copies of the collection? How many unique records in the index? Are you indexing data from the Oracle db, or is a file-type collection? Are you running the K2 server or vdk collections? How are you indexing the collection (cfindex?) And a general question. Why is CFExec running? Is this how the scheduler works? Up to my elbows in Verity today myself. Jerry Johnson >>> [EMAIL PROTECTED] 03/19/04 03:37PM >>> Hi All- We have a scheduled task that runs every 3 hours, which calls a verity index command. This task has run just fine for the last 2 years, I am told. Suddenly last friday, the task started to bring CFEXEC to its knees and in some cases crash the server. We are running Solaris 9, CF 5.0 hitting Oracle 8.1.7. Any ideas as to what might cause something like this, that has gone untouched, to suddenly go wonky? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: date dropdown
http://dynarch.com/mishoo/calendar.epl coolest one ive seen! tony -Original Message- From: Critter [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 1:29 PM To: CF-Talk Subject: Re: date dropdown Hello Robert, cflib.org Friday, March 19, 2004, 1:16:39 PM, you wrote: RO> Anyone out there know where I can find a CF or _javascript_ date drop RO> down with day, month, year that a user can select from and send to a RO> form? RO> Thanks. RO> Robert O. RO> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF 5.0 on Solaris/Oracle 8.1.7/Verity Indexing
Hi All- We have a scheduled task that runs every 3 hours, which calls a verity index command. This task has run just fine for the last 2 years, I am told. Suddenly last friday, the task started to bring CFEXEC to its knees and in some cases crash the server. We are running Solaris 9, CF 5.0 hitting Oracle 8.1.7. Any ideas as to what might cause something like this, that has gone untouched, to suddenly go wonky? All I can think if is something wrong with the data in the database that was acceptable to the server until we simply started to accumulate too much data. No errors are being written to the logs. I have quickly browsed the code being called by the task and nothing looks too out of the ordinary. I guess I will start testing all of the queries to see how many results are returned. Anyhow, if anyone with more knowledge in this are has any suggestions, it would be much appreciated. -Bret [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: and record id
>If you're using SQL Server, for instance, you can use @@IDENTITY (or >SCOPE_IDENTITY in newer versions) to refer to the new identity column value. So, after doing the cfinsert, I tried using @@IDENTITY within the CF, but I'm not sure how to reference it. I'm using MS Sequal Server so it should be there. Does it work ok with a cfinsert or must I do a cfquery? I've done some searches in the archives must they always use it within a query so it's just sql at that point. I saw one use of it in CF, but it was in a named query and I'm doing a cfinsert. Should I switch? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MAX 2004 Conference date?
That's what you said last time. C'mon, be creative... Like "This year." ;) Paul Kenney WebMaster, CorporateWarriors.com 916-663-1963 -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 11:33 AM To: CF-Talk Subject: RE: MAX 2004 Conference date? No, but I am expecting an announcement very, very shortly. Stay tuned. --- Ben _ From: Bosky, Dave [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 2:29 PM To: CF-Talk Subject: MAX 2004 Conference date? Has Macromedia announced this year's conference date? ~Dave HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Oracle, CLOBs and the Oracle Thin Driver
Does anyone know if it is possible to work with CLOBs using Oracle's Thin Driver? It is my understanding that to work with CLOBs in Oracle you must use bind parameters. However if I attempt to update a CLOB field using cfqueryparam with a cfsqltype of CF_SQL_CLOB, the update does not work. The query does not throw an error, and if the CLOB column contained any data it is cleared. I can update the column using cfqueryparam and a cfsqltype of CF_SQL_LONGVARCHAR, but if the update is larger that 4000 characters it fails with the following error: Data size bigger than max size for this type. I did notice that Oracle has its own CLOB class, oracle.sql.CLOB. Could this class be conflicting with the standard java.sql.CLOB class, and if so, is there any way to work around this? I'm using CFMX 6.1 Standard, Oracle 9i 9.2.0.1 JDBC Drivers (odbc14.jar, ocrs12.zip), and my java version is 1.4.2. Thanks, --Nathan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re[2]: form submission
Hello Steve, you can also just change the submit button to a regular button and have the onclick of the button submit your form. Friday, March 19, 2004, 2:33:46 PM, you wrote: SN> Try the code below. Although I think it only works in IE. SN> Steve Nelson SN> SN> SN>
SN> function testForEnter()
SN> {
SN> if (event.keyCode == 13)
SN> {
SN> event.cancelBubble = true;
SN> event.returnValue = false;
SN> }
SN> }
SN> SN> SN> SN> SN> style="background-color:yellow"> SN> Form1: Does not stop form submission when user presses ENTER key. SN> SN> SN> SN> SN> style="background-color:lightblue"> SN> Form2: Stops form submission when user presses ENTER key. SN> SN> SN> SN> SN> SN> -Original Message- SN> From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] SN> Sent: Friday, March 19, 2004 2:02 PM SN> To: CF-Talk SN> Subject: SOT: form submission SN> How does one keep a form from submitting when a user presses ENTER? SN> (Only want them to submit from the button...) SN> Cutter SN> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: How do I perform a radius search based on zip code?
Go to www.pengoworks.com and head to the JSAPI Gateway section. In there exists an example that makes use of a zipcode database that is pretty up to date. The db has a few queries already built that calculate distance between two locales. HTH, Mike > > How do I perform a radius search based on zip code? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
HomeSite+ Issue w/ Large Files
As reported here: http://tinyurl.com/2k3xl --- A friend reported the following bug with HS+ - Open a largish file in Homesite+ via RDS - Make a change to the file and hit save - Before the first file is finished saving, open a second file via RDS When the above happens, there is a chance that one of the files will overwrite the other. This has been confirmed in HS+ 5.5, HS+ 5.2, and ColdFusion Studio 5.0. I pinged a contact I have on the HS+ 5.5 team who confirmed the issue and opened a bug report for it. --- This is a problem that has cost me *hours* of work in the past. Good to be aware of, and hopefully Macromedia will release a patch soon. -Cameron - Cameron Childress Sumo Consulting Inc --- land: 858.509.3098 cell: 678.637.5072 aim: cameroncf email: [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: form submission
Try the code below. Although I think it only works in IE. Steve Nelson
function testForEnter()
{
if (event.keyCode == 13)
{
event.cancelBubble = true;
event.returnValue = false;
}
}
style="background-color:yellow"> Form1: Does not stop form submission when user presses ENTER key. style="background-color:lightblue"> Form2: Stops form submission when user presses ENTER key. -Original Message- From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 2:02 PM To: CF-Talk Subject: SOT: form submission How does one keep a form from submitting when a user presses ENTER? (Only want them to submit from the button...) Cutter [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How do I perform a radius search based on zip code?
Link for the raw formula: http://www.meridianworlddata.com/Distance-Calculation.asp A UDF for doing the calculation http://cflib.org/udf.cfm?ID=502 -- Howard Fore, [EMAIL PROTECTED] "I hope you believe you understand what you think I said, but I'm not sure you understand that what you've heard is not what I meant." President Richard Nixon On Mar 19, 2004, at 2:00 PM, Scott Weikert wrote: >> How do I perform a radius search based on zip code? >> >> For instance, suppose I have a database of graphic artists. How do >> I >> find all "graphic artists" within a 20 mile radius of the given zip >> code. Is there a service that provides such information? Is >> something >> like that even possible with just zip code? > > There's zip code databases out there that have latitude/longitude > data, and > then there's some algorithm (I don't have it here) that you can feed > it two > lat/long pairs and it will tell you the mileage between, as the crow > flies. > Can't just do it with zip codes by themselves, you need locational > data. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MAX 2004 Conference date?
No, but I am expecting an announcement very, very shortly. Stay tuned. --- Ben _ From: Bosky, Dave [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 2:29 PM To: CF-Talk Subject: MAX 2004 Conference date? Has Macromedia announced this year's conference date? ~Dave HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
MAX 2004 Conference date?
Has Macromedia announced this year's conference date? ~Dave HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: and record id
>This is a perennial subject on this list, so you'll be able to find quite a >few answers in the list archives. I usually do search the archives first, but in this case I wasn't sure what to search on. I'll have to re-read the answer below a few more times. Thanks for the help. I thought there was an @ thing. >However, to summarize, you can select the newly generated identity value in >another query, or you can attach a trigger to the table that returns the >identity when a record is inserted, or you can write a stored procedure that >performs both the insert and the selection of the new identity, or you may >be able to perform both within a single SQL batch depending on your >platform. > >If you're using SQL Server, for instance, you can use @@IDENTITY (or >SCOPE_IDENTITY in newer versions) to refer to the new identity column value. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SunOne w/ CFMX
> I have installed CFMX on a server with SunOne using multple > instances of SunOne (not mx like in j2ee). Is there a way for > me to remove the connectors for all instances and re-add them > like with IIS? Are you talking about the SunONE web server, or the SunONE application server? If the former, you should be able to use the remove_all_connectors batch file/shell script which should be somewhere in \cfusion\bin, I think. 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]
SOT: form submission
How does one keep a form from submitting when a user presses ENTER? (Only want them to submit from the button...) Cutter [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: How do I perform a radius search based on zip code?
> How do I perform a radius search based on zip code? > > For instance, suppose I have a database of graphic artists. How do I >find all "graphic artists" within a 20 mile radius of the given zip >code. Is there a service that provides such information? Is something >like that even possible with just zip code? There's zip code databases out there that have latitude/longitude data, and then there's some algorithm (I don't have it here) that you can feed it two lat/long pairs and it will tell you the mileage between, as the crow flies. Can't just do it with zip codes by themselves, you need locational data. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: and record id
> I just did a and would like to get the record id > from an 'identity' column called 'identifier'. Do I have to > do another query just to get that or is there some short-hand > to get info from the most recent insert. Since it's an > identity column, I don't have the info handy until the record > is made. This is a perennial subject on this list, so you'll be able to find quite a few answers in the list archives. However, to summarize, you can select the newly generated identity value in another query, or you can attach a trigger to the table that returns the identity when a record is inserted, or you can write a stored procedure that performs both the insert and the selection of the new identity, or you may be able to perform both within a single SQL batch depending on your platform. If you're using SQL Server, for instance, you can use @@IDENTITY (or SCOPE_IDENTITY in newer versions) to refer to the new identity column value. If you do use two queries, you'll need to ensure that they're treated as a single transaction in such a way that when one request inserts a record, no other request can do so until the first request has fetched the new identity. You can use the CFTRANSACTION tag for this, although you may have to change the ISOLATION_LEVEL attribute to "SERIALIZABLE" to make this work. 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]
Web application testing
>> I've started using Canoo WebTest http://webtest.canoo.com which is an extension of JUnit. It's for testing at the web application level rather than unit testing. You >> would do this in addition to unit testing but you can do things like define test scenarios to submit a form for user registration I'd love to have some easy XML-based User Interface testing the workflow of a web application (e.g. SignOn -> Browse To Products -> Purchase Product -> Cancel Purchase). Does anyone else have any comments on good Web Application UI workflow testing? I've found the following four apps by looking at http://www.opensourcetesting.org/functional.php . Most of them are XML-based. Is there a best-of-breed solution in this area? Canoo: http://webtest.canoo.com/webtest/manual/WebTestHome.html XML Test Suite: http://xmltestsuite.sourceforge.net Latka: http://jakarta.apache.org/commons/latka/index.html Anteater: http://aft.sourceforge.net/index.html Thanks, Jon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Clearing all Cached Queries (Attn: Ray C.)
> You told me once of a way to clear out all cached queries at > once, but I'll be darned if I can find the thread. I'm not Ray, but: 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 dropdown
Robert, Do a search on popDateTime from the CF Exchange on MM's site. Works great. Cutter Robert Orlini wrote: > Anyone out there know where I can find a CF or _javascript_ date drop down > with day, month, year that a user can select from and send to a form? > > Thanks. > > Robert O. > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SOT?: SES URLs in CF
Thanks for the info. Glad to hear that someone else doing what I am doing is not having these same issues. I'll look into this further. I have a sneaking suspicion there is something else at play here and the problem is not the SES URLs. --Jeff Bert Dawson wrote: > I'm no expert on how search engines work, or how to get them to come in > and have a look around. > However, I use SES urls on all of my sites, and google has indexed > "about 65,800" pages on one of them. > Its a fusebox site, so this is 65,800 different /index.cfm/foo/bar/etc > "pages". > Since there aren't that many links on the home page, and all links on > the home page are SES URLs I can only assume that google is quite happy > following SES URLs from pages with SES URLs. > > Cheers > Bert > > > > > > > -Original Message- > > From: Jeff Langevin [mailto:[EMAIL PROTECTED] > > Sent: 18 March 2004 16:26 > > To: CF-Talk > > Subject: SOT?: SES URLs in CF > > > > > > Hi folks, > > > > What things are folks doing out there to get around issues of search > > engine indexing of dynamic sites? > > > > Recently we launched an application which uses SES URLs (and the > > application is written in Fusebox 3). However, we are still having a > > problem with the search engines not indexing the site (you > > have to dig > > to find even one or two listings). Below is examples of URLs > > from the > > site. Has anyone had this kind of problem before? Does > > anyone know of > > any crawlers having problems with multiple "."s in a URL? > > > > Any thoughts would be really appreciated. Thanks! > > > > --Jeff > > > > Main URL: > > http://appalachia.outdoors.org/reservations/workshops/ > > > > Index of listings: > > http://appalachia.outdoors.org/reservations/workshops/index.cf > m/fuseaction/search.all/ > > Example of URL for single workshop: > http://appalachia.outdoors.org/reservations/workshops/index.cfm/fuseaction/search.description/workshopID/HCOM5/locationID/whc/season/20034 > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
How do I perform a radius search based on zip code?
I think the subject says most of it. How do I perform a radius search based on zip code? For instance, suppose I have a database of graphic artists. How do I find all "graphic artists" within a 20 mile radius of the given zip code. Is there a service that provides such information? Is something like that even possible with just zip code? -- Jeffry Houser, Web Developer Aaron Skye, Guitarist / Songwriter -- AIM: Reboog711 | Phone: 1-203-379-0773 -- My Books: Recording Music: Original Energetic Acoustic Rock: [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Clearing all Cached Queries (Attn: Ray C.)
Ray, You told me once of a way to clear out all cached queries at once, but I'll be darned if I can find the thread. Would you please repeat? Thanks, Jamie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: JUnit with Cold Fusion
From what I could tell from CFUnit, the TestCase or TestSuite class implemented the display code as well as the machinery to implement the test runner. Faithful to the Junit API, these are clearly separated in my framework. There is a base TestRunner class that you can extend, and there is a TestListener class that you can also extend (there are others that you can extend as well). The TestListener class has a simple interface that allows the TestRunner to to give it information about each test as it runs, and it can do anything it wants with that info. At the end, you can get the test info from the TestListener (you have to extend it), and pass it on to your presentation layer. So far, I have two presentation styles: plain text (same as Junit) and a html interface that gives a lot more information about errors and failures. One could also implement a remote interface to support running tests through an IDE of your choice (ala Studio or DW extension). Paul Kenney WebMaster, CorporateWarriors.com 916-663-1963 -Original Message- From: Jon Gunnip [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 9:50 AM To: CF-Talk Subject: Re: JUnit with Cold Fusion I've also made some modifications to CFUnit. It works great for testing my Model layer which is written in CFC's. I've got about 40 Tests running about 10 test functions each. It is nice to open a web page and see whether the recent changes you made have broken your Model! I added support for TestSuites to include other TestSuites as well as individual Tests. I also added some GetTickCount()'s to report the execution time that each test function (as well as Test/TestSuite execution times). I would love to share my code, but because it is *highly* based on code from the code in the DRK03 (which we purchased), I'm not sure if I am prohibited from sharing my code. Does anyone know? By the way, the Mach-II/JUnit implementation for CFC's sounds great! One complaint about cfunit is that the way it is written makes it difficult to configure (and extend) the display of test results. Hence, the display code I've added on is a tad messy. I would like to see an elegant implementation that allows one to easily configure and extend the display of test results. Jon >CFUnit is really handy and works similarly to JUnit. I have been using >it for a while now although I did added some additional assertions for >Query, Structure, Array and Component comparisons. > >Qasim > >-Original Message- >From: Chris Jensen [mailto:[EMAIL PROTECTED] >Sent: Thursday, March 18, 2004 9:31 PM >To: CF-Talk >Subject: JUnit with Cold Fusion > > >Hi, >I've been looking into getting into better testing practices with cold >fusion development. >I was looking into tools to support this, and while not actually a cold >fusion tool - JUnit (and some supporting projects for it) seems to be >the best option by far, so I was thinking of trying to get it working in > >CFMX. > >Has anyone else tried this and found any pitfalls? >Or, does anyone know of some good native Cold Fusion tools that can >provide the same thing? > >-- > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
and record id
I just did a and would like to get the record id from an 'identity' column called 'identifier'. Do I have to do another query just to get that or is there some short-hand to get info from the most recent insert. Since it's an identity column, I don't have the info handy until the record is made. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Better way of inserting lots of data?
Thanks for the reply. I got bogged down and am only now getting back to the db stuff. Yes. I downloaded the historical data from yahoo and organized it in Excel. I also use the built in web queries feature in Excel to grab data from MSN. The stockgrabber custom tag also works well for delayed quotes. The reason I like using CF is for the built in charting. What I am trying to do is create a custom stock index that is updated daily. It is really quite easy with so many datafeeds. Once the historicals are in the database, updating the daily closing prices takes only a few lines of code. The only issue comes in when I want to add a company to the index and have to upload a few years of closing prices, which seems reasonable using the bulk insert. Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: date dropdown
Hello Robert, cflib.org Friday, March 19, 2004, 1:16:39 PM, you wrote: RO> Anyone out there know where I can find a CF or _javascript_ RO> date drop down with day, month, year that a user can select from RO> and send to a form? RO> Thanks. RO> Robert O. RO> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
date dropdown
Anyone out there know where I can find a CF or _javascript_ date drop down with day, month, year that a user can select from and send to a form? Thanks. Robert O. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SunOne w/ CFMX
Hello, I have installed CFMX on a server with SunOne using multple instances of SunOne (not mx like in j2ee). Is there a way for me to remove the connectors for all instances and re-add them like with IIS? TIA, Robbie [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF & Editize: has anyone used this?
> We're looking at this as a possible solution for a client: http://editize.com/ > > Has anyone had any experience integrating this with CF? if so, any caveats to be aware of? > > -- > Kelly Tetterton > Technical Lead | Duo Consulting > Internet Strategy, Design and Development > > 312.529.3000| main > 312.529.3014 | direct > 312.529.3001 | fax > www.duoconsulting.com > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: JUnit with Cold Fusion
How about CF_Breaker? As in Mr. Breaker. - Original Message - From: "Paul Kenney" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, March 19, 2004 12:19 PM Subject: RE: JUnit with Cold Fusion > When I first saw CFUnit, I thought "cool!", but what if... > > > So I looked at Junit and decided that a faithful port to CFML that followed > the JUnit API as closely as possible could be really useful. So I did, and > it works really well (at least for me). The only requirement is that it runs > on CFMX 6.1 (it uses CFCs and 'super') and right now I have a front end that > uses MachII. I'm in the process of putting up a site for it now. Any > suggestions for a name? CFUnit would be great, but someone already has that > name. I looked on SourceForge and CFMUnit is taken, as is ColdUnit, > CFCUnit, CFMLUnit (I think), and just about any other name I could think > of... Any suggestions? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: JUnit with Cold Fusion
I've also made some modifications to CFUnit. It works great for testing my Model layer which is written in CFC's. I've got about 40 Tests running about 10 test functions each. It is nice to open a web page and see whether the recent changes you made have broken your Model! I added support for TestSuites to include other TestSuites as well as individual Tests. I also added some GetTickCount()'s to report the execution time that each test function (as well as Test/TestSuite execution times). I would love to share my code, but because it is *highly* based on code from the code in the DRK03 (which we purchased), I'm not sure if I am prohibited from sharing my code. Does anyone know? By the way, the Mach-II/JUnit implementation for CFC's sounds great! One complaint about cfunit is that the way it is written makes it difficult to configure (and extend) the display of test results. Hence, the display code I've added on is a tad messy. I would like to see an elegant implementation that allows one to easily configure and extend the display of test results. Jon >CFUnit is really handy and works similarly to JUnit. I have been using >it for a while now although I did added some additional assertions for >Query, Structure, Array and Component comparisons. > >Qasim > >-Original Message- >From: Chris Jensen [mailto:[EMAIL PROTECTED] >Sent: Thursday, March 18, 2004 9:31 PM >To: CF-Talk >Subject: JUnit with Cold Fusion > > >Hi, >I've been looking into getting into better testing practices with cold >fusion development. >I was looking into tools to support this, and while not actually a cold >fusion tool - JUnit (and some supporting projects for it) seems to be >the best option by far, so I was thinking of trying to get it working in > >CFMX. > >Has anyone else tried this and found any pitfalls? >Or, does anyone know of some good native Cold Fusion tools that can >provide the same thing? > >-- > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Javascript remoting with cfcs
On Fri, 2004-03-19 at 01:54, Thomas Chiverton wrote: > On Thursday 18 Mar 2004 15:50 pm, Rob wrote: > > Try it again - I just tried it on FireFox linux worked ok > > Err... well, I can type things in the box, but there is nothing to tell me > what to type to see it working :-) > Could you put a few sentances on the site to explain what to do to see it > working, or but the buttons back on ? The floating window and background are > neat, but it's meant to be demonstrating webservice consumation :-) Hehehe, well it's still being worked on - it's not really ready for big time usage, but here you go... After it loads hit enter to get a prompt Neuro created an object called "robject" that has the functions of the web service built in You can type # reflect(robject) to see if that really happend (it might not). then to test it you can just type the function from the web serive for example # robject.getTest() you can also type "help" at the prompt to get a bit of info - not much. It's more of a "hack the web page" at the moment. btw its a _javascript_ shell so if you know _javascript_ you can get around pretty easy. for example type # alert("hi there") Cheers, > OTOH it works :-) -- Rob <[EMAIL PROTECTED]> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: More on Laszlo
Does it provide support for file uploads ? Kola -Original Message- From: Dick Applebaum [mailto:[EMAIL PROTECTED] Sent: 16 March 2004 16:54 To: CF-Talk Subject: More on Laszlo I have been playing around with Laszlo and here is what I found. Laszlo is a Flash competitor and may also be a competitor to MM Flex nee Royale. I am not sure of the latter because I have not seen either Flex or Royale. Laszlo is used, like Flash, to create the client side of RIA apps. Laszlo code is written in XML and _javascript_ as opposed to the Movie/ActionScript construct of Flash. Laszlo code is compiled into a Flash swf file and imbedded into an HTML page just as Flash is. The Laszlo client app can make requests of a server-side app written in almost anything (including CFMX). Server requests are made with a standard URL with optional name/value pairs -- so far, I have not determined if data can be passed as form variables. Data returned to a Laszlo client consists of a single, valid XML packet. The XML packet is trivial to create in CFMX with standard output functions -- you don't need to do any XML parsing, etc -- just create XML tags around your data -- similar to placing HTML tags around your data. One tutorial takes you through creating a simple (and quite nice) data maintenance application -- The RIA client side is 72 lines of XML code. Thish creates a Flash movie that: -- initially displays all the records in the db in tabular form. -- if you click on a record, the space beneath the row of data expands to show a pre-filled update/delete form -- if you click on the heading row, the space below expands to show an Add Record form -- this is all done clientside. -- if you click on the add/up/delet buttons the data entry display disappears and the space for it contracts & the data is passed to the server. Nothing special here, except it is intuitive, pleasant and written in 1 page of readable, maintainable code, I think I like it. It is much more intuitive (to me) than the Flash paradigm. They have a very nice sample shopping cart ala PetStore with a few added goodies -- you can drag and drop items (images) to the cart or wish list. you can expand or collapse the catalog display to show the cart, wishlist, and or checkout form. If these areas are collapsed, there is feedback when addinc items to the cart or wishlist -- the expansion bar briefly changes color Now the negatives: I found a bug in the client side of the data maintenance example (above) that I can't resolve -- their debugger isn;t much help. Performance appears to be a little sluggish The client-side code is 163K (gzipped) which seems high -- I have not used their optimizer I hate typing Laszlo Anyway, this might be a good alternative to Flash for those of us who are uneasy with Flash model. HTH Dick _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: JUnit with Cold Fusion
When I first saw CFUnit, I thought "cool!", but what if... So I looked at Junit and decided that a faithful port to CFML that followed the JUnit API as closely as possible could be really useful. So I did, and it works really well (at least for me). The only requirement is that it runs on CFMX 6.1 (it uses CFCs and 'super') and right now I have a front end that uses MachII. I'm in the process of putting up a site for it now. Any suggestions for a name? CFUnit would be great, but someone already has that name. I looked on SourceForge and CFMUnit is taken, as is ColdUnit, CFCUnit, CFMLUnit (I think), and just about any other name I could think of... Any suggestions? I was going to wait until I had published it first before talking about it, but I guess now is as good as any. Paul Kenney WebMaster, CorporateWarriors.com 916-663-1963 -Original Message- From: Qasim Rasheed [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 6:18 AM To: CF-Talk Subject: RE: JUnit with Cold Fusion CFUnit is really handy and works similarly to JUnit. I have been using it for a while now although I did added some additional assertions for Query, Structure, Array and Component comparisons. Qasim -Original Message- From: Chris Jensen [mailto:[EMAIL PROTECTED] Sent: Thursday, March 18, 2004 9:31 PM To: CF-Talk Subject: JUnit with Cold Fusion Hi, I've been looking into getting into better testing practices with cold fusion development. I was looking into tools to support this, and while not actually a cold fusion tool - JUnit (and some supporting projects for it) seems to be the best option by far, so I was thinking of trying to get it working in CFMX. Has anyone else tried this and found any pitfalls? Or, does anyone know of some good native Cold Fusion tools that can provide the same thing? -- _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFFILE question
I have an excel file that I have written from a query. When clicking on the link to download the file, how do I get it to ask to download it as opposed to opening it in IE? Thanks! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfexecute
Hello Critter, n/m think might have found answer: C:\WINNT\System32\CScript.exe Friday, March 19, 2004, 11:24:50 AM, you wrote: C> Hello cf-talk, C> will it execute a .vbs? I'm getting weird errors C> -- C> Critter G -- Critter G -- [This E-mail scanned for viruses by Declude Virus] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Importing Scheduled Tasks
> Small Glitch.. Found the registry keys OK in 6.1, but the are > missing in MX 6.0 which is what our production server has on > it... I need to get those tasks on 6.0 so I can move them to > the test servers, make sure everything is running right and > then upgrade production to 6.1. Neither CFMX 6.0 or 6.1 use the registry for storing configuration settings. They both use XML files typically found in \cfusionmx\lib. 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: Importing Scheduled Tasks
> Now for the Million Dollar Question > > Can Export from CF5 to MX? You should be able to do this with Archive & Restore. 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]
cfexecute
Hello cf-talk, will it execute a .vbs? I'm getting weird errors -- Critter G -- [This E-mail scanned for viruses by Declude Virus] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Importing Scheduled Tasks
Ok Cool! Now for the Million Dollar Question Can Export from CF5 to MX? Rick -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 7:57 AM To: CF-Talk Subject: RE: Importing Scheduled Tasks You can use archive & deploy if it's available. Otherwise the settings are in the registry: HKEY_LOCAL_MACHINE\SOFTWARE\Allaire\ColdFusion\CurrentVersion\Schedule Pascal > -Original Message- > From: cfhelp [mailto:[EMAIL PROTECTED] > Sent: vrijdag 19 maart 2004 16:56 > To: CF-Talk > Subject: RE: Importing Scheduled Tasks > > What about CF5? > > Rick > > -Original Message- > From: Dan Phillips [mailto:[EMAIL PROTECTED] > Sent: Friday, March 19, 2004 7:11 AM > To: CF-Talk > Subject: RE: Importing Scheduled Tasks > > Are you using CF5 or MX? > > -Original Message- > From: Jeff Waris [mailto:[EMAIL PROTECTED] > Sent: Friday, March 19, 2004 9:50 AM > To: CF-Talk > Subject: Importing Scheduled Tasks > > I have about a dozen tasks on our production server that I > would like to migrate over to our backup servers, any way to > do this without manually entering in each one on each backup server? > > Jeff W. > _ > _ > > > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: unique user query
oh dangit. I knew that, but it's so new that I forgot by the time I typed it. jeez-louise, thanks all! >You need LIKE instead of = with wildcards > >Pascal [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: JUnit with Cold Fusion
I've started using Canoo WebTest http://webtest.canoo.com which is an extension of JUnit. It's for testing at the web application level rather than unit testing. You would do this in addition to unit testing but you can do things like define test scenarios to submit a form for user registration. DBunit http://dbunit.sourceforge.net is helpful as well for setting up the database. I'm starting to look at CFUnit as well. Qasim, care to share the code you added for addition assertions? -Phil >CFUnit is really handy and works similarly to JUnit. I have been using >it for a while now although I did added some additional assertions for >Query, Structure, Array and Component comparisons. > >Qasim > >-Original Message- >From: Chris Jensen [mailto:[EMAIL PROTECTED] >Sent: Thursday, March 18, 2004 9:31 PM >To: CF-Talk >Subject: JUnit with Cold Fusion > > >Hi, >I've been looking into getting into better testing practices with cold >fusion development. >I was looking into tools to support this, and while not actually a cold >fusion tool - JUnit (and some supporting projects for it) seems to be >the best option by far, so I was thinking of trying to get it working in > >CFMX. > >Has anyone else tried this and found any pitfalls? >Or, does anyone know of some good native Cold Fusion tools that can >provide the same thing? > >-- > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Importing Scheduled Tasks
Small Glitch.. Found the registry keys OK in 6.1, but the are missing in MX 6.0 which is what our production server has on it... I need to get those tasks on 6.0 so I can move them to the test servers, make sure everything is running right and then upgrade production to 6.1. Jeff -Original Message- From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 10:57 AM To: CF-Talk Subject: RE: Importing Scheduled Tasks You can use archive & deploy if it's available. Otherwise the settings are in the registry: HKEY_LOCAL_MACHINE\SOFTWARE\Allaire\ColdFusion\CurrentVersion\Schedule Pascal [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Bar code software for ColdFusion
http://www.fusionzone.com/applications/barcode/overview.cfm Generate bar codes as a single image with in your application. barcodeZONE gives you the ability to integrate the following 9 bar codes types into your site: Supported Bar Code Styles (1) Code 128 B (2) 2 of 5 (3) 2 of 5 Interleaved (4) Codabar (5) Postnet (6) UPC-(A) (7) UPC-(E) (8) EAN 13 (9) Code 39. Bar code images are generated as the are requested by the server. Each is usually 1-3k in file size depending on the amount of data you request to be encoded. barcodeZONE is extremely easy to implement into your Web site. Have bar code capability on your web site in less than 5 minutes. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: unique user query
You need LIKE instead of = with wildcards Pascal > -Original Message- > From: Daniel Kessler [mailto:[EMAIL PROTECTED] > Sent: vrijdag 19 maart 2004 16:53 > To: CF-Talk > Subject: unique user query > > I'm doing a registration test. First I test the name and if > it fails, I try to get the total number of userNames that > begin with the name and suggest that as a new name (ie > daniel87697). Then I test to make sure that name is valid. > Unfortunately, the second query where I get the count doesn't > seem to be working. I'm using % in the WHERE, which I > understand to be a wild-card. My code below. > > > > >SELECT * >FROM bodyfun_registry >WHERE userName = '#Form.userName#' > > > > > > > SELECT * > FROM bodyfun_registry > WHERE userName = '#Form.userName#%' > > > > > > SELECT * > FROM bodyfun_registry > WHERE userName = > '#Form.userName##check_total_usernames.recordcount#' > > > > > > > > > > > > > I'm sure there's a better way to suggest a name, but this is > an added feature so I'm doing it as well as I can do quickly. > > thanks. > > -- > Daniel Kessler > > Department of Public and Community Health University of > Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 > 301-405-2545 Phone > www.phi.umd.edu > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: unique user query
Change it to like not = SELECT * FROM bodyfun_registry WHERE userName like '#Form.userName#%' - Original Message - From: "Daniel Kessler" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, March 19, 2004 10:52 AM Subject: unique user query > I'm doing a registration test. First I test the name and if it > fails, I try to get the total number of userNames that begin with the > name and suggest that as a new name (ie daniel87697). Then I test to > make sure that name is valid. Unfortunately, the second query where > I get the count doesn't seem to be working. I'm using % in the > WHERE, which I understand to be a wild-card. My code below. > > > > >SELECT * >FROM bodyfun_registry >WHERE userName = '#Form.userName#' > > > > > > > SELECT * > FROM bodyfun_registry > WHERE userName = '#Form.userName#%' > > > > > > SELECT * > FROM bodyfun_registry > WHERE userName = > '#Form.userName##check_total_usernames.recordcount#' > > > > > > > > > > > > > I'm sure there's a better way to suggest a name, but this is an added > feature so I'm doing it as well as I can do quickly. > > thanks. > > -- > Daniel Kessler > > Department of Public and Community Health > University of Maryland > Suite 2387 Valley Drive > College Park, MD 20742-2611 > 301-405-2545 Phone > www.phi.umd.edu > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Importing Scheduled Tasks
You can use archive & deploy if it's available. Otherwise the settings are in the registry: HKEY_LOCAL_MACHINE\SOFTWARE\Allaire\ColdFusion\CurrentVersion\Schedule Pascal > -Original Message- > From: cfhelp [mailto:[EMAIL PROTECTED] > Sent: vrijdag 19 maart 2004 16:56 > To: CF-Talk > Subject: RE: Importing Scheduled Tasks > > What about CF5? > > Rick > > -Original Message- > From: Dan Phillips [mailto:[EMAIL PROTECTED] > Sent: Friday, March 19, 2004 7:11 AM > To: CF-Talk > Subject: RE: Importing Scheduled Tasks > > Are you using CF5 or MX? > > -Original Message- > From: Jeff Waris [mailto:[EMAIL PROTECTED] > Sent: Friday, March 19, 2004 9:50 AM > To: CF-Talk > Subject: Importing Scheduled Tasks > > I have about a dozen tasks on our production server that I > would like to migrate over to our backup servers, any way to > do this without manually entering in each one on each backup server? > > Jeff W. > _ > _ > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: unique user query
i think you need to use LIKE instead of "=", so WHERE userName like '#Form.userName#%' -Original Message- From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 10:53 AM To: CF-Talk Subject: unique user query I'm doing a registration test. First I test the name and if it fails, I try to get the total number of userNames that begin with the name and suggest that as a new name (ie daniel87697). Then I test to make sure that name is valid. Unfortunately, the second query where I get the count doesn't seem to be working. I'm using % in the WHERE, which I understand to be a wild-card. My code below. SELECT * FROM bodyfun_registry WHERE userName = '#Form.userName#' SELECT * FROM bodyfun_registry WHERE userName = '#Form.userName#%' SELECT * FROM bodyfun_registry WHERE userName = '#Form.userName##check_total_usernames.recordcount#' I'm sure there's a better way to suggest a name, but this is an added feature so I'm doing it as well as I can do quickly. thanks. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: IIF doesn't work correctly
I figured it out, must not put double quotes. Bob > I correct myself, the example works, but what I'm trying to do doesn't > work. Can anyone look at this and see why it isn't working > > #iif(listlen(cgi.query_string, "&") gt 1, > Evaluate(DE("listdeleteat(listdeleteat(cgi.query_string, 1, "&"), 1, > "=")")), DE("test"))# > > The cgi query_string will have either fuseaction=login.login or > fuseaction=login.login&fa=something.else , that way if I am passing > the extra fa I want them to be redirected to that fa after login. > > > Bob > > > > > I was having some issues on IIF and thought I was using it correctly > > > so I reverified it by looking at the examples in the book and if I > > copy an example directly out of the docs, it doesn't work. Try this > in > > CFMX 6.1 #IIf(IsDefined("Form.Deliver"), Evaluate(DE("Form. > Deliver")), > > DE("no"))# > > > > That should output no and not throw an error, but on my box it does. > > > Anyone know a workaround. The livedocs can be viewed here. > > http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/funct117.htm > > > > > > bob Everland [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
unique user query
I'm doing a registration test. First I test the name and if it fails, I try to get the total number of userNames that begin with the name and suggest that as a new name (ie daniel87697). Then I test to make sure that name is valid. Unfortunately, the second query where I get the count doesn't seem to be working. I'm using % in the WHERE, which I understand to be a wild-card. My code below. SELECT * FROM bodyfun_registry WHERE userName = '#Form.userName#' SELECT * FROM bodyfun_registry WHERE userName = '#Form.userName#%' SELECT * FROM bodyfun_registry WHERE userName = '#Form.userName##check_total_usernames.recordcount#' I'm sure there's a better way to suggest a name, but this is an added feature so I'm doing it as well as I can do quickly. thanks. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Importing Scheduled Tasks
The information is held in the Windows registry. Just make a backup of that key and import it into the new server. Dan Phillips CFXHosting.com 866.239.4678 x112 [EMAIL PROTECTED] -Original Message- From: cfhelp [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 10:56 AM To: CF-Talk Subject: RE: Importing Scheduled Tasks What about CF5? Rick -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 7:11 AM To: CF-Talk Subject: RE: Importing Scheduled Tasks Are you using CF5 or MX? -Original Message- From: Jeff Waris [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 9:50 AM To: CF-Talk Subject: Importing Scheduled Tasks I have about a dozen tasks on our production server that I would like to migrate over to our backup servers, any way to do this without manually entering in each one on each backup server? Jeff W. _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: IIF doesn't work correctly
It's a bit overcomplicated (evaluate and de cancel each other AFAIK), but your problem is with quotes Evaluate(DE("listdeleteat(listdeleteat(cgi.query_string, 1, '&'), 1, '=')")) Pascal > -Original Message- > From: Robert Everland III [mailto:[EMAIL PROTECTED] > Sent: vrijdag 19 maart 2004 15:45 > To: CF-Talk > Subject: Re: IIF doesn't work correctly > > I correct myself, the example works, but what I'm trying to > do doesn't work. Can anyone look at this and see why it isn't working > > #iif(listlen(cgi.query_string, "&") gt 1, > Evaluate(DE("listdeleteat(listdeleteat(cgi.query_string, 1, > "&"), 1, "=")")), DE("test"))# > > The cgi query_string will have either fuseaction=login.login > or fuseaction=login.login&fa=something.else , that way if I > am passing the extra fa I want them to be redirected to that > fa after login. > > > Bob > > > > > I was having some issues on IIF and thought I was using it > correctly > > so I reverified it by looking at the examples in the book and if I > > copy an example directly out of the docs, it doesn't work. > Try this in > > CFMX 6.1 #IIf(IsDefined("Form.Deliver"), > Evaluate(DE("Form.Deliver")), > > DE("no"))# > > > > That should output no and not throw an error, but on my box > it does. > > Anyone know a workaround. The livedocs can be viewed here. > > http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/funct117.htm > > > > > > bob > Everland > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Importing Scheduled Tasks
What about CF5? Rick -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 7:11 AM To: CF-Talk Subject: RE: Importing Scheduled Tasks Are you using CF5 or MX? -Original Message- From: Jeff Waris [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 9:50 AM To: CF-Talk Subject: Importing Scheduled Tasks I have about a dozen tasks on our production server that I would like to migrate over to our backup servers, any way to do this without manually entering in each one on each backup server? Jeff W. _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Importing Scheduled Tasks
> I have about a dozen tasks on our production server that I > would like to migrate over to our backup servers, any way to > do this without manually entering in each one on each backup > server? You should be able to do this with the Archive & Restore functionality within the CF Administrator. I believe that's available only in Enterprise, but I'm not absolutely sure about that. 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: Importing Scheduled Tasks
> I believe the task settings are stored in C:\CFusionMX\lib in > an XML file. Sorry, I can't remember which one. If you browse > them you should be able to see the settings. Scheduled tasks are in neo-cron.xml, I think. 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: IIF doesn't work correctly
> I was having some issues on IIF and thought I was using it > correctly so I reverified it by looking at the examples in > the book and if I copy an example directly out of the docs, > it doesn't work. Try this in CFMX 6.1 > #IIf(IsDefined("Form.Deliver"), Evaluate(DE("Form.Deliver")), > DE("no"))# > > That should output no and not throw an error, but on my box > it does. Anyone know a workaround. The livedocs can be viewed > here. > http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/funct117.htm I haven't actually tried running your code, but why would you nest DE within Evaluate? You should be able to simplify the _expression_: #IIf(IsDefined("Form.Deliver"), "Form.Deliver", DE("no"))> 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: IIF doesn't work correctly
I correct myself, the example works, but what I'm trying to do doesn't work. Can anyone look at this and see why it isn't working #iif(listlen(cgi.query_string, "&") gt 1, Evaluate(DE("listdeleteat(listdeleteat(cgi.query_string, 1, "&"), 1, "=")")), DE("test"))# The cgi query_string will have either fuseaction=login.login or fuseaction=login.login&fa=something.else , that way if I am passing the extra fa I want them to be redirected to that fa after login. Bob > I was having some issues on IIF and thought I was using it correctly > so I reverified it by looking at the examples in the book and if I > copy an example directly out of the docs, it doesn't work. Try this in > CFMX 6.1 #IIf(IsDefined("Form.Deliver"), Evaluate(DE("Form.Deliver")), > DE("no"))# > > That should output no and not throw an error, but on my box it does. > Anyone know a workaround. The livedocs can be viewed here. > http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/funct117.htm > > > bob Everland [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
IIF doesn't work correctly
I was having some issues on IIF and thought I was using it correctly so I reverified it by looking at the examples in the book and if I copy an example directly out of the docs, it doesn't work. Try this in CFMX 6.1 #IIf(IsDefined("Form.Deliver"), Evaluate(DE("Form.Deliver")), DE("no"))# That should output no and not throw an error, but on my box it does. Anyone know a workaround. The livedocs can be viewed here. http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/funct117.htm bob Everland [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Importing Scheduled Tasks
I'll look.. Thanks! -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 10:28 AM To: CF-Talk Subject: RE: Importing Scheduled Tasks I believe the task settings are stored in C:\CFusionMX\lib in an XML file. Sorry, I can't remember which one. If you browse them you should be able to see the settings. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Importing Scheduled Tasks
I believe the task settings are stored in C:\CFusionMX\lib in an XML file. Sorry, I can't remember which one. If you browse them you should be able to see the settings. -Original Message- From: Jeff Waris [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 9:55 AM To: CF-Talk Subject: RE: Importing Scheduled Tasks I am using MX -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 10:11 AM To: CF-Talk Subject: RE: Importing Scheduled Tasks Are you using CF5 or MX? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Importing Scheduled Tasks
I am using MX -Original Message- From: Dan Phillips [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 10:11 AM To: CF-Talk Subject: RE: Importing Scheduled Tasks Are you using CF5 or MX? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Good (inexpensive) domain registration
I have heard of similar problems with bulkregister.com == Stop spam on your domain, Anti-spam solutions http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com == If you woke up breathing, congratulations! You have been given another chance! That sounds all too familiar with those people... Ugh. > A friend of mine tried to use BuyDomains for their business. > She did the search to see if the domain was available, > reported to their group that it was and when they went back > to buy it the next day or so, BuyDomains had snapped up the > name and was squatting on it asking for thousands of dollars > to buy it from them. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Syntax for an event loop
You can also do this (assuming foo is a udf): #x()# If you want to dynamically pass attributes, just use argumentCollection. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Importing Scheduled Tasks
Are you using CF5 or MX? -Original Message- From: Jeff Waris [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 9:50 AM To: CF-Talk Subject: Importing Scheduled Tasks I have about a dozen tasks on our production server that I would like to migrate over to our backup servers, any way to do this without manually entering in each one on each backup server? Jeff W. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Importing Scheduled Tasks
I have about a dozen tasks on our production server that I would like to migrate over to our backup servers, any way to do this without manually entering in each one on each backup server? Jeff W. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Syntax for an event loop
I'm doing essentially the same thing in my code - does anybody know how to do this without using the 'despised' Evaluate? Walt -Original Message- From: Tom Kitta [mailto:[EMAIL PROTECTED] Sent: Thursday, March 18, 2004 1:15 PM To: CF-Talk Subject: RE: Syntax for an event loop I know I did dynamic function naming some time ago, it works fine, I think syntax was: For passing arguments: "(#arg1_variable#,arg2_as_number,'arg3_as_text')")> OR ",arg2_as_number,'arg3_as_text')")> TK -Original Message- From: Lee Flier [mailto:[EMAIL PROTECTED] Sent: Thursday, March 18, 2004 12:54 PM To: CF-Talk Subject: Syntax for an event loop Hey all, I'm setting up an event loop for processing a series of functions. Each function will return the name of the next function to run, depending what happens during the function. I'm trying to figure how I would set up the syntax for this. Should the following work or do I need to do something else? current_event = #current_event#() ... and so on... ... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Good (inexpensive) domain registration
That sounds all too familiar with those people... Ugh. > A friend of mine tried to use BuyDomains for their business. > She did the search to see if the domain was available, > reported to their group that it was and when they went back > to buy it the next day or so, BuyDomains had snapped up the > name and was squatting on it asking for thousands of dollars > to buy it from them. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: JRun 4 Updater 3 Now Available
Note: I currently have a bug open regarding JRUN 4 Update 3 bug 54614. If you have a context root of / for cfmx. CFMX will not work... this appears to happen under W2k with IIS and Linux with Apache. - Alex -Original Message- From: Stephen Dupre [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 8:14 AM To: CF-Talk Subject: Re: JRun 4 Updater 3 Now Available Just to clarify. The vast majority of what's in JRun Updater 3 is what was made available to CF customers in CFMX 6.1 Updater 3 gets these fixes to JRun 4 customers. There is a some small number items fixed in Updater 3 that aren't in CFMX 6.1. We're working on a cumulative hotfix due in April to make those available for CFMX 6.1 Server-configuration customers. Some other fixes available ***POST-U3*** (didn't make U3) for JRun and CFMX customers through hotfixes + other random thoughts I'll share: (note: all of these will be in the 6.1 cumulative hotfix due in April) - we expect to release new datadirect drivers soon to fix the oracle and sqlserver issues customers have reported (no more data, arrayindexoutofbounds, hangs) with the 3.2 drivers shipped with JRun 4 Updater 2 and CFMX 6.1. They are still in testing mode. JRun4 Updater 3 got the 3.1+ drivers since they were the most stable. 3.1+ was also made available as a hotfix for CFMX customers with issues. We expect to replace the 3.1+ for JRun and CFMX customers with newer drivers in the next few weeks if testing goes well. Please email me if you'd like to participate in the beta. - some connector enhancements - including failover in clustering working as expected (we will have a hotfix for this soon - please email me). These fixes are long overdue. - connection pooling fixes for "JRun datasources" to match the pooling fixes for ColdFusion datasources (see technote below). http://www.macromedia.com/support/coldfusion/ts/documents/conn_pool_hotf ix.htm (for apps like AbleCommerce that use "JRun datasources" ie entered through the JMC and available to all instances). Users of JRun J2EE CFMX versions would need these if they have connection-limited datasources *AND* the underlying application used JRun datasources. This fix will be made available in a few days. - Client variable purge fixes for SQL and registry datasources (there were 4 bugs fixed). This often showed up when the server hung every hour on the hour for the maintenance task of purging client variables older than [N] days. This hits many customers if they use "registry" and the registry grows to say 50,000 or 100,000+ entries. SQL datasources are recommended but even if users switched, the registry purges still occurred (in addition to SQL purges) and could hang the system. The fix now respects the unchecked "purge" setting for all client datasource types. These are the ones that come to mind that get reported most often hanging systems. ***For Dick AppleBaum***: 1) JRun and, therefore, CF use the JVM 1.3 instead of 1.4 (even with the fix posted Christian Cantrell's blog site) > Part of this is the installer not allowing the selection. There are also issues with using JDK 1.4 (jvm.cfg issues). We've fixed this post-Updater 3 in the launcher. (jrun stub) Please email me and I can get you some code to test. 2) When starting a CF 6.1 JRun server instance, the scheduler does not start (see below). > I've heard of this sporadically but can't reproduce it. Perhaps send me your neo-cron.xml and jrun.xml and I'll see if I can repro it on my machine. 6.1 definitely massaged this .xml file on an existing server. Perhaps the one in your new instance got corrupted somehow. Regards, Stephen Dupre Macromedia QA [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Good (inexpensive) domain registration
A friend of mine tried to use BuyDomains for their business. She did the search to see if the domain was available, reported to their group that it was and when they went back to buy it the next day or so, BuyDomains had snapped up the name and was squatting on it asking for thousands of dollars to buy it from them. -Kevin > Just wondering, does anyone have good/bad stories related to www.dotster.com > or http://www.buydomains.com/ ? > > TK [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: JUnit with Cold Fusion
CFUnit is really handy and works similarly to JUnit. I have been using it for a while now although I did added some additional assertions for Query, Structure, Array and Component comparisons. Qasim -Original Message- From: Chris Jensen [mailto:[EMAIL PROTECTED] Sent: Thursday, March 18, 2004 9:31 PM To: CF-Talk Subject: JUnit with Cold Fusion Hi, I've been looking into getting into better testing practices with cold fusion development. I was looking into tools to support this, and while not actually a cold fusion tool - JUnit (and some supporting projects for it) seems to be the best option by far, so I was thinking of trying to get it working in CFMX. Has anyone else tried this and found any pitfalls? Or, does anyone know of some good native Cold Fusion tools that can provide the same thing? -- _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: JRun 4 Updater 3 Now Available
Just to clarify. The vast majority of whats in JRun Updater 3 is what was made available to CF customers in CFMX 6.1 Updater 3 gets these fixes to JRun 4 customers. There is a some small number items fixed in Updater 3 that arent in CFMX 6.1. We're working on a cumulative hotfix due in April to make those available for CFMX 6.1 Server-configuration customers. Some other fixes available ***POST-U3*** (didn't make U3) for JRun and CFMX customers through hotfixes + other random thoughts I'll share: (note: all of these will be in the 6.1 cumulative hotfix due in April) - we expect to release new datadirect drivers soon to fix the oracle and sqlserver issues customers have reported (no more data, arrayindexoutofbounds, hangs) with the 3.2 drivers shipped with JRun 4 Updater 2 and CFMX 6.1. They are still in testing mode. JRun4 Updater 3 got the 3.1+ drivers since they were the most stable. 3.1+ was also made available as a hotfix for CFMX customers with issues. We expect to replace the 3.1+ for JRun and CFMX customers with newer drivers in the next few weeks if testing goes well. Please email me if you'd like to participate in the beta. - some connector enhancements - including failover in clustering working as expected (we will have a hotfix for this soon - please email me). These fixes are long overdue. - connection pooling fixes for "JRun datasources" to match the pooling fixes for ColdFusion datasources (see technote below). http://www.macromedia.com/support/coldfusion/ts/documents/conn_pool_hotfix.htm (for apps like AbleCommerce that use "JRun datasources" ie entered through the JMC and available to all instances). Users of JRun J2EE CFMX versions would need these if they have connection-limited datasources *AND* the underlying application used JRun datasources. This fix will be made available in a few days. - Client variable purge fixes for SQL and registry datasources (there were 4 bugs fixed). This often showed up when the server hung every hour on the hour for the maintenance task of purging client variables older than [N] days. This hits many customers if they use "registry" and the registry grows to say 50,000 or 100,000+ entries. SQL datasources are recommended but even if users switched, the registry purges still occurred (in addition to SQL purges) and could hang the system. The fix now respects the unchecked "purge" setting for all client datasource types. These are the ones that come to mind that get reported most often hanging systems. ***For Dick AppleBaum***: 1) JRun and, therefore, CF use the JVM 1.3 instead of 1.4 (even with the fix posted Christian Cantrell's blog site) > Part of this is the installer not allowing the selection. There are also issues with using JDK 1.4 (jvm.cfg issues). We've fixed this post-Updater 3 in the launcher. (jrun stub) Please email me and I can get you some code to test. 2) When starting a CF 6.1 JRun server instance, the scheduler does not start (see below). > I've heard of this sporadically but can't reproduce it. Perhaps send me your neo-cron.xml and jrun.xml and I'll see if I can repro it on my machine. 6.1 definitely massaged this .xml file on an existing server. Perhaps the one in your new instance got corrupted somehow. Regards, Stephen Dupre Macromedia QA [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: #url#
Both solutions ended up working. I don't know why the quotes didn't work for me the first time - just burned out I guess. Well after I cleared out that problem, I went home, had a shower, ate, and slept and today's a sun-shiny day. Thanks everyone. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Search Engines & CFID/CFTOKEN
I've thought about that... but, what's the best way to implement it? Maybe... don't append cfid/cftoken append cfid/cftoken Without keeping a massive list of search engine UA's, is there a another way to check for spiders? Or, would you just comprise a list of the top crawlers, and if so, any suggestions on a list of (popular) words to test against? -Brad -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 8:40 AM To: CF-Talk Subject: Re: Search Engines & CFID/CFTOKEN On Friday 19 Mar 2004 13:22 pm, Brad Roberts wrote: > append cfid/cftoken to every url. However, I don't want search engines to > index my sites with a cfid/cftoken. Any way around this? Check the browser string and do something different if it's a spider. -- 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: Search Engines & CFID/CFTOKEN
On Friday 19 Mar 2004 13:22 pm, Brad Roberts wrote: > append cfid/cftoken to every url. However, I don't want search engines to > index my sites with a cfid/cftoken. Any way around this? Check the browser string and do something different if it's a spider. -- 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: web hosting, sql 2000
r0ck on. I'll give that a try. -adam > -Original Message- > From: Kay Smoljak [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 18, 2004 08:24 AM > To: 'CF-Talk' > Subject: Re: web hosting, sql 2000 > > Hey Adam, > > > yeah, if you dot mind crashing enterprise manager when it tries to > > load the 500+ databases they put on each server. > > Turns out that if you apply the SQL Server 2000 Service Packs (even on a machine with only the client tools installed) Enterprise Manager gets a lot more stable and that "timing out while loading databases" bug goes away. I didn't believe the tech who told me that, but it worked. > > Cheers, > K. > > --- > Kay Smoljak > http://kay.smoljak.com > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Search Engines & CFID/CFTOKEN
I use a udf to create all of my links (i.e. createLink(myLink), in order to append cfid/cftoken to every url. However, I don't want search engines to index my sites with a cfid/cftoken. Any way around this? Thanks, Brad [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
ANNOUNCE: Win a free ticket for CFUN-04
Win a ticket for TeraTech's CFUN-04 - the ColdFusion conference in Washington DC 6/26 - 6/27/04. CFUN-04 has 42 topics in five tracks with 33 nationally known speakers including many CFDJ authors such as Charlie Arehart, Hal Helms and Michael Smith. Talks include hot CFMX topics, Fusebox 4, Flash, Flex, debugging, accessibility and more. There will be a CFDJ panel to answer you questions too. To enter the competition for a free ticket (a $269 value) just take the survey at: http://www.cfconf.com/cfun-04/survey.cfm It only takes a minute to complete and we will publish the results on the CFConf site to share with the community. Additionally anyone who completes the survey will be entered to win a free place at CFUN-04. The winner will be chosen based on answering the most questions correctly together with the best answer to the question: "Why should people come to CFUN-04?" The winner will be selected on 26th of March. If you don't win you can you can still register at the early bird price of $199 before 3/31/04. Thanks! -- -- Vote for TeraTech in CFDJ awards http://www.teratech.com/vote.cfm Michael Smith, TeraTech, Inc 405 E Gude Dr Ste 207, Rockville MD 20850 CF , VB, SQL, Math custom programming Voice: +1-301-424-3903 x110, 800-447-9120 Fax:301-762-8185 Web: http://www.teratech.com/sig/ Email: mailto:[EMAIL PROTECTED] ICQ: 66057682 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Emailing Form.FieldNames results via looping?
Sorry but maybe 4.5 and up. If you try it in 4.01 form was not a structure, you had to do the evaluate. Believe me I wanted it to work when we were on that version prior to our upgrade. __ Bill Grover Manager, Information Systems Phone: 301.424.3300 x3324 EU Services, Inc. FAX: 301.424.3696 649 North Horners Lane E-Mail: [EMAIL PROTECTED] Rockville, MD 20850-1299 WWW: http://www.euservices.com __ -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, March 18, 2004 2:02 PM To: CF-Talk Subject: RE: Emailing Form.FieldNames results via looping? > if I remember correctly, #form[thisField]# won't work in > cf5, but I'm not 100% sure of that (It's been so long since > I used CF5). I'm pretty sure that syntax will work in CF 4 and up. 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]