Queries with pretty column names

2004-03-19 Thread Craig Earls
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'

Re: and record id

2004-03-19 Thread daniel kessler
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]

Re: How do I perform a radius search based on zip code?

2004-03-19 Thread Lewis Sellers
>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 ((

RE: and record id

2004-03-19 Thread Dave Watts
> > 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 > Sequa

Re: Adding elements to a structure

2004-03-19 Thread Keith Levenson
Thanks, Pascal.  Your assumption was correct, and works great! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: MAX 2004 Conference date?

2004-03-19 Thread Paul Kenney
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

RE: MAX 2004 Conference date?

2004-03-19 Thread Tony Weeg
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

Re: How do I perform a radius search based on zip code?

2004-03-19 Thread muzl hed
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*

Re: CF 5.0 on Solaris/Oracle 8.1.7/Verity Indexing

2004-03-19 Thread bret
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

RE: Clearing all Cached Queries (Attn: Ray C.)

2004-03-19 Thread Qasim Rasheed
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

RE: MAX 2004 Conference date?

2004-03-19 Thread Paul Kenney
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 t

RE: MAX 2004 Conference date?

2004-03-19 Thread Paul Kenney
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

RE: MAX 2004 Conference date?

2004-03-19 Thread DURETTE, STEVEN J (AIT)
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 j

RE: MAX 2004 Conference date?

2004-03-19 Thread Cameron Childress
> 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:  

RE: MAX 2004 Conference date?

2004-03-19 Thread Tony Weeg
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 P

RE: MAX 2004 Conference date?

2004-03-19 Thread Ben Forta
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 w

Re: MAX 2004 Conference date?

2004-03-19 Thread Adrocknaphobia
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

Re: CF 5.0 on Solaris/Oracle 8.1.7/Verity Indexing

2004-03-19 Thread Jerry Johnson
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

2004-03-19 Thread bret
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 th

RE: MAX 2004 Conference date?

2004-03-19 Thread Ben Forta
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-19

Re: CF 5.0 on Solaris/Oracle 8.1.7/Verity Indexing

2004-03-19 Thread Jerry Johnson
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 q

RE: date dropdown

2004-03-19 Thread Tony Weeg
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

CF 5.0 on Solaris/Oracle 8.1.7/Verity Indexing

2004-03-19 Thread bret
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 hi

Re: and record id

2004-03-19 Thread daniel kessler
>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

RE: MAX 2004 Conference date?

2004-03-19 Thread Paul Kenney
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,

Oracle, CLOBs and the Oracle Thin Driver

2004-03-19 Thread Nathan Mische
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 qu

Re[2]: form submission

2004-03-19 Thread Critter
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

RE: How do I perform a radius search based on zip code?

2004-03-19 Thread Tangorre, Michael
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

HomeSite+ Issue w/ Large Files

2004-03-19 Thread Cameron Childress
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 on

RE: form submission

2004-03-19 Thread Steve Nelson
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 f

Re: How do I perform a radius search based on zip code?

2004-03-19 Thread Howard Fore
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

RE: MAX 2004 Conference date?

2004-03-19 Thread Ben Forta
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 Disclaim

MAX 2004 Conference date?

2004-03-19 Thread Bosky, Dave
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

Re: and record id

2004-03-19 Thread daniel kessler
>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 w

RE: SunOne w/ CFMX

2004-03-19 Thread Dave Watts
> 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 fo

SOT: form submission

2004-03-19 Thread Cutter (CF-Talk)
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?

2004-03-19 Thread Scott Weikert
>   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

RE: and record id

2004-03-19 Thread Dave Watts
> 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 r

Web application testing

2004-03-19 Thread Jon Gunnip
>> 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 registrat

RE: Clearing all Cached Queries (Attn: Ray C.)

2004-03-19 Thread Dave Watts
> 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 Uns

Re: date dropdown

2004-03-19 Thread Cutter (CF-Talk)
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. > [Tod

Re: SOT?: SES URLs in CF

2004-03-19 Thread Jeff Langevin
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 sea

How do I perform a radius search based on zip code?

2004-03-19 Thread Jeffry Houser
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 so

Clearing all Cached Queries (Attn: Ray C.)

2004-03-19 Thread Jamie Jackson
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

2004-03-19 Thread Paul Kenney
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 Test

and record id

2004-03-19 Thread Daniel Kessler
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 m

Re: Better way of inserting lots of data?

2004-03-19 Thread Paul St . Amant
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 q

Re: date dropdown

2004-03-19 Thread Critter
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]

date dropdown

2004-03-19 Thread Robert Orlini
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

2004-03-19 Thread Robert Shaw
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] [Us

CF & Editize: has anyone used this?

2004-03-19 Thread Kelly Tetterton
> 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.300

Re: JUnit with Cold Fusion

2004-03-19 Thread stas
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

Re: JUnit with Cold Fusion

2004-03-19 Thread Jon Gunnip
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 T

Re: Javascript remoting with cfcs

2004-03-19 Thread Rob
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 f

RE: More on Laszlo

2004-03-19 Thread Kola Oyedeji
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 al

RE: JUnit with Cold Fusion

2004-03-19 Thread Paul Kenney
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

CFFILE question

2004-03-19 Thread kelly
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

2004-03-19 Thread Critter
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] [

RE: Importing Scheduled Tasks

2004-03-19 Thread Dave Watts
> 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

RE: Importing Scheduled Tasks

2004-03-19 Thread Dave Watts
> 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]

cfexecute

2004-03-19 Thread Critter
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

2004-03-19 Thread cfhelp
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 availab

Re: unique user query

2004-03-19 Thread daniel kessler
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

2004-03-19 Thread Phil Cruz
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.  

RE: Importing Scheduled Tasks

2004-03-19 Thread Jeff Waris
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

Bar code software for ColdFusion

2004-03-19 Thread Kevin Maloy
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)

RE: unique user query

2004-03-19 Thread Pascal Peters
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 g

Re: unique user query

2004-03-19 Thread jonhall
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 Subjec

RE: Importing Scheduled Tasks

2004-03-19 Thread Pascal Peters
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 > Sub

RE: unique user query

2004-03-19 Thread John Stanley
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 i

Re: IIF doesn't work correctly

2004-03-19 Thread Robert Everland III
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, "&

unique user query

2004-03-19 Thread Daniel Kessler
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'

RE: Importing Scheduled Tasks

2004-03-19 Thread Dan Phillips
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-Tal

RE: IIF doesn't work correctly

2004-03-19 Thread Pascal Peters
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 20

RE: Importing Scheduled Tasks

2004-03-19 Thread cfhelp
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: Frid

RE: Importing Scheduled Tasks

2004-03-19 Thread Dave Watts
> 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

RE: Importing Scheduled Tasks

2004-03-19 Thread Dave Watts
> 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-

RE: IIF doesn't work correctly

2004-03-19 Thread Dave Watts
> 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("

Re: IIF doesn't work correctly

2004-03-19 Thread Robert Everland III
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 eit

IIF doesn't work correctly

2004-03-19 Thread Robert Everland III
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 shou

RE: Importing Scheduled Tasks

2004-03-19 Thread Jeff Waris
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 yo

RE: Importing Scheduled Tasks

2004-03-19 Thread Dan Phillips
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

2004-03-19 Thread Jeff Waris
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

2004-03-19 Thread Doug White
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, congra

RE: Syntax for an event loop

2004-03-19 Thread Raymond Camden
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

2004-03-19 Thread Dan Phillips
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

Importing Scheduled Tasks

2004-03-19 Thread Jeff Waris
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

2004-03-19 Thread Sparrow-Hood, Walter
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

RE: Good (inexpensive) domain registration

2004-03-19 Thread Tangorre, Michael
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

RE: JRun 4 Updater 3 Now Available

2004-03-19 Thread DeMarco, Alex
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: Frida

Re: Good (inexpensive) domain registration

2004-03-19 Thread Kevin Graeme
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

RE: JUnit with Cold Fusion

2004-03-19 Thread Qasim Rasheed
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 1

Re: JRun 4 Updater 3 Now Available

2004-03-19 Thread Stephen Dupre
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

Re: #url#

2004-03-19 Thread daniel kessler
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] [Subscrip

RE: Search Engines & CFID/CFTOKEN

2004-03-19 Thread Brad Roberts
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,

Re: Search Engines & CFID/CFTOKEN

2004-03-19 Thread Thomas Chiverton
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

Re: web hosting, sql 2000

2004-03-19 Thread Adrocknaphobia
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 >

Search Engines & CFID/CFTOKEN

2004-03-19 Thread Brad Roberts
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]

ANNOUNCE: Win a free ticket for CFUN-04

2004-03-19 Thread Michael Smith
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

RE: Emailing Form.FieldNames results via looping?

2004-03-19 Thread Bill Grover
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:

  1   2   >