RE: "Harpoon" Release is Final & Available

[Rich Wild]

>From the looks of it (without going into too much detail), the flash movie
uses the loadvariables command on a callback url which calls the variables
from a unique server scoped variable created for that instance of the page
call only.

Put all variables into unique server scoped struct

Call Flash Movie with a callback to:

Seperate template that decides which component is being used and dumps the
server variables in a format Flash can read using its loadVariables command.

Dunno what it does from there cos I haven't got Flash 5 (I'll have to ask
our Macatistas (design bods) here in the office) but basically Flash is
reading the variables from a text file.

That's my basic understanding anyway. Might have got little bits wrong.

---
Rich Wild
Senior Web Designer

---
e-mango.com ltd  Tel: 01202 587 400
Lansdowne Place  Fax: 01202 587 401
17 Holdenhurst Road
Bournemouth   Mailto:[EMAIL PROTECTED]
BH8 8EW, UK  http://www.e-mango.com
---
This message may contain information which is legally
privileged and/or confidential.  If you are not the
intended recipient, you are hereby notified that any
unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such
notification notwithstanding, any comments, opinions,
information or conclusions expressed in this message
are those of the originator, not of e-mango.com ltd,
unless otherwise explicitly and independently indicated
by an authorised representative of e-mango.com ltd.
---




> -Original Message-
> From: Jon Hall [mailto:[EMAIL PROTECTED]]
> Sent: 14 May 2001 18:47
> To: CF-Talk
> Subject: Re: "Harpoon" Release is Final & Available
> 
> 
> Out of curiosity, how is data transferred now? Is it still xml?
> 
> jon
> - Original Message -
> From: "Steve Drucker" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, May 14, 2001 1:06 PM
> Subject: RE: "Harpoon" Release is Final & Available
> 
> 
> > It's gone...the Harpoon documentation details various best 
> practices for
> > transferring information from ColdFusion to Flash.
> >
> > Using WDDX at this time, regrettably, is NOT a best practice.
> >
> > Regards,
> > Steve Drucker
> > CEO
> > Fig Leaf Software
> >
> >
> > -Original Message-
> > From: Evan Lavidor [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, May 14, 2001 12:30 PM
> > To: CF-Talk
> > Subject: RE: "Harpoon" Release is Final & Available
> >
> >
> > I seem to remember that in some of the early betas for 
> "Harpoon" there was
> > an actionscript file for reading WDDX packets in Flash.  Did this
> disappear?
> > Or did it simply become subsumed into some of the FLA's.  
> If the latter is
> > true, could someone point me to the right place to find it? 
>  If it's gone,
> > is there a reason?
> >
> > Thanks,
> >
> > Evan
> >
> > > -Original Message-
> > > From: Sam Coe [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, May 14, 2001 10:29 AM
> > > To: CF-Talk
> > > Subject: "Harpoon" Release is Final & Available
> > >
> > >
> > > We are happy to announce the availability of The Macromedia Flash
> > > Component
> > > Kit for ColdFusion.  The kit, first announced in November 
> 2000 under the
> > > code name 'Harpoon', is now available for download from 
> the ColdFusion
> > > Developers Exchange.
> > >
> > > The Macromedia Flash Component Kit for ColdFusion is a 
> resource for
> > > ColdFusion developers to quickly and easily add Macromedia Flash
> > > elements to
> > > their Web applications.  ColdFusion developers can 
> immediately take
> > > advantage of the design and delivery benefits of 
> Macromedia Flash and
> > > Macromedia Flash Player without learning a new authoring 
> product. For
> more
> > > advanced developers, the Component Kit provides guidelines and
> > > documentation
> > > for creating and customizing new Macromedia Flash components for
> > > ColdFusion
> > > that can be shared with other developers.
> > >
> > > The Component Kit includes 4 prebuilt Macromedia Flash sample
> components,
> > > guidelines detailing how to use and customize components 
> and ColdFusion
> > > custom tags that control the behavior of those components.
> > >
> > > The four Macromedia Flash sample components included with 
> the kit are:
> > >
> > > *Calendar
> > > *Calculator
> > > *Horizontal Menu
> > > *Cascading Menu (for Microsoft Internet Explorer)
> > >
> > > The Component Kit is available for free download from the Allaire
> > > Developers
> > > Exchange for the Windows and UNIX platforms.  To access the
> > > components, type
> > > "Macromedia Flash" into the Developers Exchange Search window
> > > (http://devex.allaire.com/developer/gallery/index.cfm) or 
> visit the
> > > following

Re: IE4 and Required Fields w/ CFINPUT

[Bryan LaPlante]

If the radio buttons are the only difficulty you are having in IE4, it would
be easier to just make one of them checked and not use cfinput for that
element, that way you are sure to get a value.

Bryan

- Original Message -
From: "Ray Bujarski" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, May 14, 2001 2:45 PM
Subject: Re: IE4 and Required Fields w/ CFINPUT


> Make sure your cfform tag has a name AND the cfinput type has a name
specified
>
> At 03:27 PM 5/14/2001 -0400, you wrote:
> >Ok, My form works like a champ in Netscape and I run
> >into no problems in IE5 but I get a javascript error
> >in IE4. Since I have no javascript on the page I can
> >only assume it is the javascript that is auto-generated
> >by my 
> >Anyone else run into problems using required=yes under IE4?
> >Is there any way around it?
> >
> >Matt Hood
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: "Harpoon" Release is Final & Available

[Dave Watts]

> > Using WDDX at this time, regrettably, is NOT a best practice.
> 
> Is this because of some problem with Flash?

Yes. The current version of Flash doesn't handle XML as efficiently as raw
string data.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: [Session Variables - I don't get it]

[Bill King]

It appears that you are spitting out the variable before you change it to
blue.

- Bill -
- Original Message -
From: "Alex" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 11, 2001 7:47 AM
Subject: Re: [Session Variables - I don't get it]


> because you are setting it to black on the application.cfm page.
> change the application.cfm  cfset to cfparam
>
> "Kronenberger, Douglas" <[EMAIL PROTECTED]> wrote:
> Greetings,
>
> I'm not getting how to implement session variables. I'm just trying to set
> the session variable "Session.Dog" from black to Blue and have it show up
as
> Blue on the test.cfm. It keep show'n up black. I do have Session Variables
> enabled via the CF Administrator page.
>
> What am I miss'n here.
>
> 
>
> 
>
> 
> 
> 
>
>
> 
> 
>
> 
> 
>  #Session.Dog# 
> 
> 
>
>
> 
>  Goto
> 
>
> 
> 
>
> 
> 
>
> 
> 
>  #Session.Dog# 
> 
> 
>
> 
> 
> -
>
>
> Can someone get me started here.
>
> Thanks
>
> > Doug Kronenberger
> > OI National Training and Education Office
> > 440-526-3030 x7776
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: cookie form & url -less sessions

[Bill King]

Seems to me that you should roll your own persistent variables using a scope
called "GovtVariables" say and maintain these each in their own WDDX packet
in a database table.  You will then key off this set of data by the
information you are able to verify through your challenge response logic.

Signed,

Bill King
Developer
HostWorks, Inc.

- Original Message -
From: "Christopher Porter" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, May 14, 2001 10:17 AM
Subject: cookie form & url -less sessions


> hey hey everyone.. here's a dilemma for you.
>
> i've been task with createing an application model for a very large
> application that is being gutted and rebuilt. now i've decided that we
> need both application and session variables. however the govt doesnt allow
> cookies on thier machines.. even for intranets. we have way too much code
> to go through and add cfid and cftoken to the url or to form vars.. so i'm
> kinda stuck.
>
> the only thing i have going for me is that the users must log in using
> challange response, so i know who is who in the application. and with
> that, i could add a structure to the application class which bears the
> name of the user.. then add variables to the structure from there...
> thereby creating a session that lasts untill the server is rebooted.. but
> i'd much rather create a session taht times out and expunges the data etc
> etc. so my thought would be to create 2 variables in the
> application.#username# class that are cfid and CFtoken then use those to
> refrence the session... i'm not sure if that'll work tho..
>
> any other thoughts on how this could be done?
> -chris
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: cookie form & url -less sessions

[Craig Bowes]

I'm not quite sure what it is you are trying to store, but here is how we
did it.  We used an application (actually it's an ISAPI filter) called
Authentix (www.flicks.com)   It does something similar to NT
Challenge/response.  You reference the Authentix object using  in
your application.cfm, and that tracks what user is connected without
cookies.  Then we ran a query against that user in the database for each
request.  Of course, all the users info was stored in the Database so I'm
not sure that's what you want, but it worked for us.  I would think you
could use CF to retrieve the NT username in a similar manner, and just
database the users' session info.

-Craig

-Original Message-
From: Christopher Porter [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 12:18 PM
To: CF-Talk
Subject: cookie form & url -less sessions

hey hey everyone.. here's a dilemma for you.

i've been task with createing an application model for a very large
application that is being gutted and rebuilt. now i've decided that we
need both application and session variables. however the govt doesnt allow
cookies on thier machines.. even for intranets. we have way too much code
to go through and add cfid and cftoken to the url or to form vars.. so i'm
kinda stuck.

the only thing i have going for me is that the users must log in using
challange response, so i know who is who in the application. and with
that, i could add a structure to the application class which bears the
name of the user.. then add variables to the structure from there...
thereby creating a session that lasts untill the server is rebooted.. but
i'd much rather create a session taht times out and expunges the data etc
etc. so my thought would be to create 2 variables in the
application.#username# class that are cfid and CFtoken then use those to
refrence the session... i'm not sure if that'll work tho..

any other thoughts on how this could be done?
-chris
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Code Snippet:Random Password Generator(repost)

[Tony Schreiber]

You could always run the output through a bad word filter and regen a
password if there's a match (against the bad word list).

> Seems unlikely, but it does generate some great words like "teethuku" and "taafduno" 
>and the unforgettable "fuoflyru".  Fun script.
> 
> > -Original Message-
> > From:   Erika L Walker [SMTP:[EMAIL PROTECTED]]
> > Sent:   Thursday, May 10, 2001 12:19 PM
> > To: CF-Talk
> > Subject:RE: Code Snippet:Random Password Generator(repost)
> > 
> > What if it randomly generates a bad word?
> > 
> > Erika
> > (with a *K*)
> > 
> > -Original Message-
> > From: Daniel Kemp [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, May 10, 2001 11:42 AM
> > To: CF-Talk
> > Subject: RE: Code Snippet:Random Password Generator(repost)
> > Seems un
> > 
> > > > Why define the alphabet? Just use decimal values for the
> > > asci char set.
> > 
> > Ok here's another code snippet, this is a password gen that I use now
> > and then.  The slight advantage of this one is
> > it creates a word which hopefully more rememberable than just random
> > letters and numbers.  There's more than one occurrence of some letters
> > to tip the odds towards those.
> > 
> > ---
> > 
> > "cdddffgggjjklmmnnrrsstttvwwwxyz">
> > 
> > 
> > 
> > Mid(constList,RandRange('1',len(constList)),'1')>
> > 
> > Mid(vowelList,RandRange('1',len(vowelList)),'1')>
> > 
> > 
> > 
> > #password#
> > -
> > 
> > 
> > Hope this helps someone.
> > 
> > Dan.
> > 
> > 
> > 
> > This message is intended only for the use of the person(s) ("the intended
> > recipient(s)") to whom it is addressed.
> > 
> > It may contain information which is privileged and confidential within the
> > meaning of the applicable law.
> > If you are not the intended recipient, please contact the sender as soon as
> > possible.
> > The views expressed in this communication may not necessarily be the views
> > held by Live Information Systems Limited.
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: "Harpoon" Release is Final & Available

[Jon Hall]

Out of curiosity, how is data transferred now? Is it still xml?

jon
- Original Message -
From: "Steve Drucker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, May 14, 2001 1:06 PM
Subject: RE: "Harpoon" Release is Final & Available


> It's gone...the Harpoon documentation details various best practices for
> transferring information from ColdFusion to Flash.
>
> Using WDDX at this time, regrettably, is NOT a best practice.
>
> Regards,
> Steve Drucker
> CEO
> Fig Leaf Software
>
>
> -Original Message-
> From: Evan Lavidor [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 14, 2001 12:30 PM
> To: CF-Talk
> Subject: RE: "Harpoon" Release is Final & Available
>
>
> I seem to remember that in some of the early betas for "Harpoon" there was
> an actionscript file for reading WDDX packets in Flash.  Did this
disappear?
> Or did it simply become subsumed into some of the FLA's.  If the latter is
> true, could someone point me to the right place to find it?  If it's gone,
> is there a reason?
>
> Thanks,
>
> Evan
>
> > -Original Message-
> > From: Sam Coe [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, May 14, 2001 10:29 AM
> > To: CF-Talk
> > Subject: "Harpoon" Release is Final & Available
> >
> >
> > We are happy to announce the availability of The Macromedia Flash
> > Component
> > Kit for ColdFusion.  The kit, first announced in November 2000 under the
> > code name 'Harpoon', is now available for download from the ColdFusion
> > Developers Exchange.
> >
> > The Macromedia Flash Component Kit for ColdFusion is a resource for
> > ColdFusion developers to quickly and easily add Macromedia Flash
> > elements to
> > their Web applications.  ColdFusion developers can immediately take
> > advantage of the design and delivery benefits of Macromedia Flash and
> > Macromedia Flash Player without learning a new authoring product. For
more
> > advanced developers, the Component Kit provides guidelines and
> > documentation
> > for creating and customizing new Macromedia Flash components for
> > ColdFusion
> > that can be shared with other developers.
> >
> > The Component Kit includes 4 prebuilt Macromedia Flash sample
components,
> > guidelines detailing how to use and customize components and ColdFusion
> > custom tags that control the behavior of those components.
> >
> > The four Macromedia Flash sample components included with the kit are:
> >
> > *Calendar
> > *Calculator
> > *Horizontal Menu
> > *Cascading Menu (for Microsoft Internet Explorer)
> >
> > The Component Kit is available for free download from the Allaire
> > Developers
> > Exchange for the Windows and UNIX platforms.  To access the
> > components, type
> > "Macromedia Flash" into the Developers Exchange Search window
> > (http://devex.allaire.com/developer/gallery/index.cfm) or visit the
> > following page to link directly to the kit:
> >
> > http://www.allaire.com/handlers/index.cfm?ID=20983
> >
> > The FAQ and license agreements are also available on this page.
> >
> > Best,
> > -Sam
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: "Harpoon" Release is Final & Available

[stas]

I've trying to configure Harpoon for the last 2 hours... I just can't figure
out the settings for paths... even tried using absolute mappings. Still
getting 404s after a page half-loads. Help!!!

Thanks


- Original Message -
From: "Steve Drucker" <[EMAIL PROTECTED]>


It's gone...the Harpoon documentation details various best practices for
transferring information from ColdFusion to Flash.

Using WDDX at this time, regrettably, is NOT a best practice.



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: using WDDX for next 'n' style browsing

[Dick Applebaum]

I waited a while before weighing in on this, but here goes...



I hate to see this type of design, where large amounts of data (most 
of it, probably, unneeded) are schlepped back and forth along the 
highway we call the internet.  It clogs the net with [largely] 
unnecessary traffic.

Further, the verbosity of WDDX packets only exacerbates the problem 
by increasing the amount of the data sent (over and over and over...)

Look at a WDDX Packet and you will see it's size is many times larger 
than the actual data content.

Don't get me wrong, I use WDDX every day, and used properly it is a 
valuable tool...


But, WDDX is not meant to be an extension of the client/server system bus.




Use CF to cache your queries at the server

in your CF program select only the required rows, and send them to the client

If you want to improve this more, write a Flash front end for the 
client so that only the field names and data need to be sent to the 
client (eliminates retransmitting the entire HTML document)

I think you will experience an overall performance improvement and 
better use of the server, internet connection, and the client...

 kind of an *environmentally-friendly* program design!


And, the user experience will be much improved too.


Dick


At 11:52 AM +0100 5/8/01, Kola Oyedeji wrote:
>I am passing a query object which consists of 1000 records in a hidden form
>field between pages as a
>WDDX packet, are there any reasons why this is a bad idea, such as limits to
>the amount of data which can be held in a form field or passed in a form?
>
>The reason for this is to save a trip to the server for each page of result.
>Are there any better solutions, would cacheing the query and executing it
>again for every page be more efficient than trying to offload the processing
>onto the client's machine?
>
>Thanks
>
>Kola

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Restarting CF from Web

[Tim Painter]

Hello!  In CF 4.0 there was a nifty java app that allowed me to stop and restart CF 
from a web page, however it is no more in 4.5.  I no longer have a copy of 4.0 and 
really need to get a copy of this.  Does anyone have a resource to get this or an 
alternative that will do the same thing?

Thanks!
Tim Painter


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Download Software From The CF Server

[Larry C. Lyons]

Better yet use CFContent and point it to a mapped folder (in the CF
Administrator app) off the server. Much more control that way.
larry

-- 
Larry C. Lyons
ColdFusion/Web Developer
EBStor.com
8870 Rixlew Lane, Suite 201
Manassas, Virginia 20109-3795
tel: (703) 393-7930 x253
fax: (703) 393-2659
http://www.ebstor.com
http://www.pacel.com
email: [EMAIL PROTECTED]

Chaos, panic, and disorder - my work here is done.
--


Billy Cravens wrote:
> 
> If you want direct download, point to the exe.  If you want control over who can get 
>to it, use CFLocation.
> 
> --
> Billy Cravens
> HR Web Development, Sabre
> [EMAIL PROTECTED]
>

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Anybody Williams Sonoma folks on this list working on the Pottery Barn Kids site?

[Dave Livingston]

*This message was transferred with a trial version of CommuniGate(tm) Pro*
http://www.planettribes.com/allyourbase/AYB2.swf

-Original Message-
From: Shawnea Carter [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 7:34 PM
To: CF-Talk
Subject: Re: Anybody Williams Sonoma folks on this list working on the
Pottery Barn Kids site?


*This message was transferred with a trial version of CommuniGate(tm) Pro*
ok - obviously I am missing something.  Seemed like a rather straight
forward question.

Shawnea
- Original Message -
From: "Michael Wilson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, May 14, 2001 8:41 PM
Subject: RE: Anybody Williams Sonoma folks on this list working on the
Pottery Barn Kids site?


> Somebody set up us the bomb
>
> ha ha ha ha
> 
> Michael Wilson - CTO/Secretary
> http://www.xionmedia.com
> 
> Xion Media, Inc. Web Development
> P: 704-398-2454  F: 704-398-2063
> 
> "In the middle of difficulty lies opportunity." --Albert Einstein
>
> > All your base are belong to us.
> >
> > - Original Message -
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Anybody Williams Sonoma folks on this list working on the Pottery Barn Kids site?

[Dylan Bromby]

you're kidding, right? the sentence in your subject doesn't even make sense.

-Original Message-
From: Shawnea Carter [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 5:34 PM
To: CF-Talk
Subject: Re: Anybody Williams Sonoma folks on this list working on the
Pottery Barn Kids site?


ok - obviously I am missing something.  Seemed like a rather straight
forward question.

Shawnea
- Original Message -
From: "Michael Wilson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, May 14, 2001 8:41 PM
Subject: RE: Anybody Williams Sonoma folks on this list working on the
Pottery Barn Kids site?


> Somebody set up us the bomb
>
> ha ha ha ha
> 
> Michael Wilson - CTO/Secretary
> http://www.xionmedia.com
> 
> Xion Media, Inc. Web Development
> P: 704-398-2454  F: 704-398-2063
> 
> "In the middle of difficulty lies opportunity." --Albert Einstein
>
> > All your base are belong to us.
> >
> > - Original Message -
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Anybody Williams Sonoma folks on this list working on the Pottery Barn Kids site?

[Zac]

> Somebody set up us the bomb

Any chance you folks could take this someplace appropriate?

Like personal  email? 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Anybody Williams Sonoma folks on this list working on the Pottery Barn Kids site?

[Jeffry Houser]

   Well, your message body was empty.
   The question was in the subject, not the body of the message.

   I saw an empty message come across and deleted it.
   It wasn't until the first response or two that I caught the question.




At 08:33 PM 05/14/2001 -0400, you wrote:
>ok - obviously I am missing something.  Seemed like a rather straight
>forward question.
>
>Shawnea
>- Original Message -
>From: "Michael Wilson" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Monday, May 14, 2001 8:41 PM
>Subject: RE: Anybody Williams Sonoma folks on this list working on the
>Pottery Barn Kids site?
>
>
> > Somebody set up us the bomb
> >
> > ha ha ha ha
> > 
> > Michael Wilson - CTO/Secretary
> > http://www.xionmedia.com
> > 
> > Xion Media, Inc. Web Development
> > P: 704-398-2454  F: 704-398-2063
> > 
> > "In the middle of difficulty lies opportunity." --Albert Einstein
> >
> > > All your base are belong to us.
> > >
> > > - Original Message -
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Anybody Williams Sonoma folks on this list working on the Pottery Barn Kids site?

[Shawnea Carter]

ok - obviously I am missing something.  Seemed like a rather straight
forward question.

Shawnea
- Original Message -
From: "Michael Wilson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, May 14, 2001 8:41 PM
Subject: RE: Anybody Williams Sonoma folks on this list working on the
Pottery Barn Kids site?


> Somebody set up us the bomb
>
> ha ha ha ha
> 
> Michael Wilson - CTO/Secretary
> http://www.xionmedia.com
> 
> Xion Media, Inc. Web Development
> P: 704-398-2454  F: 704-398-2063
> 
> "In the middle of difficulty lies opportunity." --Albert Einstein
>
> > All your base are belong to us.
> >
> > - Original Message -
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Anybody Williams Sonoma folks on this list working on the Pottery Barn Kids site?

[Michael Wilson]

Somebody set up us the bomb

ha ha ha ha

Michael Wilson - CTO/Secretary
http://www.xionmedia.com

Xion Media, Inc. Web Development
P: 704-398-2454  F: 704-398-2063

"In the middle of difficulty lies opportunity." --Albert Einstein 

> All your base are belong to us.
> 
> - Original Message -


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: "Harpoon" Release is Final & Available

[John Dowdell]

At 9:29 AM 5/14/1, Evan Lavidor wrote:
> I seem to remember that in some of the early betas for "Harpoon"
> there was an actionscript file for reading WDDX packets in Flash.
> Did this disappear?

Although the actual release version of the Macromedia Flash Component Kit
for ColdFusion may not rely on WDDX-style data transfer, you can still pick
up the serialization/deserialization ActionScript functions here:
http://www.macromedia.com/exchange/flash/  (search term "wddx")

jd





John Dowdell, Macromedia Tech Support, San Francisco CA US
Search technotes: http://www.macromedia.com/support/search/
Offlist email risks capture by the spam filters. I may not see your
email if it's not on the list. Private one-on-one email options are
available via Priority Access: http://www.macromedia.com/support/



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Anybody Williams Sonoma folks on this list working on the Pottery Barn Kids site?

[G. Scott Wood]

Kids pottery barn doesn't confirm digits alphanumerically.

-Original Message-
From: Shawnea Carter [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 4:16 PM
To: CF-Talk
Subject: Anybody Williams Sonoma folks on this list working on the
Pottery Barn Kids site?


Shawnea Carter
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Evaluating strung together variables

[Diana Nichols]

If it's always going to be only two variables, use
ListFirst(cookie.chocolate) and ListLast(cookie.chocolate)and, if you
use a separator other than a comma, be sure to define the delimiter.

HTH
D
*
Diana Nichols
Webmistress
http://www.lavenderthreads.com
770.434.7374

"One man's magic is another man's engineering." ---Lazarus Long

-Original Message-
From: Josh R [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 10:24 PM
To: CF-Talk
Subject: Evaluating strung together variables


I have a situation where two variables are needed in only one location. A
cookie for example. I was thinking of placing the variables together like:

(cfset cookie.chocolate="#ping#seperator#pong#") I.E. ping=1 & pong=2 so
cookie.chocolate=1seperator2. Pretty simple.

But the question I'm faced with is how can I comfortably seperate them a few
pages on so that I know from cookie.chocolate that ping=1 and pong=2?
I figure I have to use the evaluate string, but I'm not having any luck
getting the right argument. Ping and Pong won't always be the same length.
Ping may be 4-6 characters, and Pong may be 3-7 characters long.

I really don't want to use two seperate cookies and form, URL and session
variables are not an option for this.

Any suggestions here?
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Anybody Williams Sonoma folks on this list working on the Pottery Barn Kids site?

[Bill Simpson]

Yep!

-Original Message-
From: Shawnea Carter [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 4:16 PM
To: CF-Talk
Subject: Anybody Williams Sonoma folks on this list working on the
Pottery Barn Kids site?


Shawnea Carter
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Anybody Williams Sonoma folks on this list working on the Pottery Barn Kids site?

[Jason Lotz]

All your base are belong to us.

- Original Message -
From: "Shawnea Carter" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, May 14, 2001 4:15 PM
Subject: Anybody Williams Sonoma folks on this list working on the Pottery
Barn Kids site?


Shawnea Carter
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Anybody Williams Sonoma folks on this list working on the Pottery Barn Kids site?

[Shawnea Carter]

Shawnea Carter


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL 2000 Database List.

[Bill Davidson]

For most purposes we use Access (with all the appropriate 2000 patches) to
talk to our SQL 2000 datasources, and it's much faster than the enterprise
manager, as you connect to a single datasource, no taking forever to load
all the datasources.

I've always been tempted to go your route, Dave, as I typically like command
prompts (call me crazy), but haven't tried it yet.
-Bill
www.brainbox.tv
- Original Message -
From: "Dave Watts" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, May 14, 2001 7:10 PM
Subject: RE: SQL 2000 Database List.


> > I didn't have the earlier version loaded at home, but 2000 is
> > very slow when listing databases.  I think they should provide a
> > "search-type" feature so that users don't have to drill-down when
> > they know what they want. Maybe more like a comand line that allows:
> >
> > "use server.dbo.database"
> >
> > I think this would save me about 15 minute a day.
> > (significant enough)
>
> You know, there is a command line interface to SQL Server, which allows
you
> to do anything that's possible with T-SQL. You can use isql or osql, which
> are true command-line clients, as well as isql/w, which is a windowed
> interface. If you find yourself performing the same sorts of tasks in
> Enterprise Manager over and over again, you might take a look at these.
You
> can't do quite everything through them, but they might suit your needs.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL Server 2000

[Bill Davidson]

Be sure to double check your stored procedures.  SQL Server 7 was tolerant
of  the create procedure name being different from the actual stored
procedure name, but 2000 isn't.  Or at least the import routine isn't.  It
will just fail, but if it does, then that's probably the problem.

When we ported our largest database over, I ended up doing one bit at a time
with the Enterprise Manager.  Trying to do it all at once was an exercise it
futility ... It would get 70% done, and then fail on a view or a stored
proc.  Do your data last, that way the time consuming stuff, which should be
fine, won't cause you long delays to find these stupid little problems.

As far as CF goes - I didn't think we've had to do anything different at all
in our code, and it's humming along quite nicely for us.

-Bill
www.brainbox.tv

- Original Message -
From: "Derek Hamilton" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, May 14, 2001 5:23 PM
Subject: SQL Server 2000


> Hello!
>
> I am in the process of planning my upgrade to SQL Server 2000 from SQL
Server 7.0.  I was wondering if anyone has noticed anything odd or difficult
in respect to ColdFusion (4.5 and 5.0RC)?
>
> Any advice or even things you've noticed would be extremely helpful.
>
> Thanks,
>
> Derek Hamilton
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Resolution CM at www.NCompass.com

[Paul Smith]

Anyone know anything about the subject Content Manager?

A good CF client of mine, that I continue to develop websites for, had it 
imposed on him and it apparently is doing some strange things.

best,  paul


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Evaluating strung together variables

[Dave]

GetToken(... ) or ListGetAt(...)

- Original Message -
From: "Josh R" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, May 14, 2001 10:23 PM
Subject: Evaluating strung together variables


> I have a situation where two variables are needed in only one location. A
> cookie for example. I was thinking of placing the variables together like:
>
> (cfset cookie.chocolate="#ping#seperator#pong#") I.E. ping=1 & pong=2 so
> cookie.chocolate=1seperator2. Pretty simple.
>
> But the question I'm faced with is how can I comfortably seperate them a
few
> pages on so that I know from cookie.chocolate that ping=1 and pong=2?
> I figure I have to use the evaluate string, but I'm not having any luck
> getting the right argument. Ping and Pong won't always be the same length.
> Ping may be 4-6 characters, and Pong may be 3-7 characters long.
>
> I really don't want to use two seperate cookies and form, URL and session
> variables are not an option for this.
>
> Any suggestions here?
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL 2000 Database List.

[Dave Watts]

> I didn't have the earlier version loaded at home, but 2000 is 
> very slow when listing databases.  I think they should provide a 
> "search-type" feature so that users don't have to drill-down when 
> they know what they want. Maybe more like a comand line that allows:
> 
> "use server.dbo.database"
> 
> I think this would save me about 15 minute a day.  
> (significant enough)

You know, there is a command line interface to SQL Server, which allows you
to do anything that's possible with T-SQL. You can use isql or osql, which
are true command-line clients, as well as isql/w, which is a windowed
interface. If you find yourself performing the same sorts of tasks in
Enterprise Manager over and over again, you might take a look at these. You
can't do quite everything through them, but they might suit your needs.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL 2000 Database List.

[John]

Yes, they do even longer on dial-up connections.

John

-Original Message-
From: Neil H. [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 4:59 PM
To: CF-Talk
Subject: SQL 2000 Database List.


Just trying to get a feel from the community but do people notice on SQL
servers with 75 or so databases that the Enterprise Manager takes an
extremely long time to populate the list?  It most noticeable on a dial up
connection and just slower on faster connections.

Thanks,

Neil
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: ftp to novell

[Joshua Tipton]

I can login and pull the current directory of SYS:  but when I try to show a
directory listing of /crsapps I get 0 records returned.

Joshua Tipton

> -Original Message-
> From: Lanny R. Udey [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 14, 2001 3:51 PM
> To: CF-Talk
> Subject: RE: ftp to novell
>
>
> Does the server that your Ftp server is running on have
> contextless login? If not you would have to use a fully qualified
> login name , e.g.,   .userid.ou.o.us
>
> Lanny Udey
> Hofstra University
>
> >>> [EMAIL PROTECTED] Monday, May 14, 2001 >>>
> I have tried multiple users and I can FTP through NT just fine.
> It just seems
> to be a problem when I use the cfftp through Novell.
>
>
>
> > *This message was transferred with a trial version of
> CommuniGate(tm) Pro*
> > Try setting up a new user just to login to ftp and set its home
> directory to
> > crsapps. Make sure this account has the appropriate rights to get to the
> > files. I think all you should need is read and file scan.
> > Hope that helps.
> >
> > Dave Livingston
> > [EMAIL PROTECTED]
> >
> > -Original Message-
> > From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, May 14, 2001 10:41 AM
> > To: CF-Talk
> > Subject: ftp to novell
> >
> >
> > *This message was transferred with a trial version of
> CommuniGate(tm) Pro*
> > I am trying to ftp to a novell server and am not having the
> best of luck.  I
> > can get the currect directroy to return sys: which is right.
> When I try to
> > listdir of a direcotyr called crsapps I get nothing.  I have
> tried /crsapps,
> > crsapps. crsapps/*.* and get nothing.  Is there a trick to novell?
> >
> > Joshua Tipton
> >
> >
> >  > username="crsser"
> > password="crsser"
> > server="10.66.64.52"
> > action="open"
> > stoponerror="yes">
> >
> >  >stoponerror="Yes"
> >connection="ftp">
> >
> >
> > #cfftp.returnvalue#
> >
> >  > action="listdir"
> > directory="/crsapps"
> > name="q"
> > stoponerror="yes">
> >
> > 
> > 
> >
> > 
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Evaluating strung together variables

[Dylan Bromby]

i don't know if fully get what you're trying to do, but it seems you could
use some LIST functions with your separator as a delimiter. then it wouldn't
matter how long each element of the list is.

-Original Message-
From: Josh R [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 10:24 PM
To: CF-Talk
Subject: Evaluating strung together variables


I have a situation where two variables are needed in only one location. A
cookie for example. I was thinking of placing the variables together like:

(cfset cookie.chocolate="#ping#seperator#pong#") I.E. ping=1 & pong=2 so
cookie.chocolate=1seperator2. Pretty simple.

But the question I'm faced with is how can I comfortably seperate them a few
pages on so that I know from cookie.chocolate that ping=1 and pong=2?
I figure I have to use the evaluate string, but I'm not having any luck
getting the right argument. Ping and Pong won't always be the same length.
Ping may be 4-6 characters, and Pong may be 3-7 characters long.

I really don't want to use two seperate cookies and form, URL and session
variables are not an option for this.

Any suggestions here?
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL 2000 Database List.

[John Wilker]

yeah I get hit every time I try to access the DB from my web hosting,
they've got a good hundred or two and it takes forever to load the list.

You don't know how much I rant when I click on that server by accident LOL

J.

John Wilker
Web Applications Consultant
Macromedia Certified ColdFusion Developer

www.red-omega.com 

"Losing - If at first you don't succeed, failure may be your style."
~despair.com


-Original Message-
From: Bill King [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 4:22 PM
To: CF-Talk
Subject: Re: SQL 2000 Database List.


I didn't have the earlier version loaded at home, but 2000 is very slow when
listing databases.  I think they should provide a "search-type" feature so
that users don't have to drill-down when they know what they want.  Maybe
more like a comand line that allows:

"use server.dbo.database"

I think this would save me about 15 minute a day.  (significant enough)

Signed,

Bill King
Developer
HostWorks, Inc.


- Original Message -
From: "Neil H." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, May 14, 2001 2:59 PM
Subject: SQL 2000 Database List.


> Just trying to get a feel from the community but do people notice on SQL
> servers with 75 or so databases that the Enterprise Manager takes an
> extremely long time to populate the list?  It most noticeable on a dial up
> connection and just slower on faster connections.
>
> Thanks,
>
> Neil
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL 2000 Database List.

[Bill King]

I didn't have the earlier version loaded at home, but 2000 is very slow when
listing databases.  I think they should provide a "search-type" feature so
that users don't have to drill-down when they know what they want.  Maybe
more like a comand line that allows:

"use server.dbo.database"

I think this would save me about 15 minute a day.  (significant enough)

Signed,

Bill King
Developer
HostWorks, Inc.


- Original Message -
From: "Neil H." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, May 14, 2001 2:59 PM
Subject: SQL 2000 Database List.


> Just trying to get a feel from the community but do people notice on SQL
> servers with 75 or so databases that the Enterprise Manager takes an
> extremely long time to populate the list?  It most noticeable on a dial up
> connection and just slower on faster connections.
>
> Thanks,
>
> Neil
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Evaluating strung together variables

[Josh R]

I have a situation where two variables are needed in only one location. A 
cookie for example. I was thinking of placing the variables together like:

(cfset cookie.chocolate="#ping#seperator#pong#") I.E. ping=1 & pong=2 so 
cookie.chocolate=1seperator2. Pretty simple.

But the question I'm faced with is how can I comfortably seperate them a few 
pages on so that I know from cookie.chocolate that ping=1 and pong=2?
I figure I have to use the evaluate string, but I'm not having any luck 
getting the right argument. Ping and Pong won't always be the same length. 
Ping may be 4-6 characters, and Pong may be 3-7 characters long.

I really don't want to use two seperate cookies and form, URL and session 
variables are not an option for this.

Any suggestions here?
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL Server 2000

[Gregory Harris]

Even though I haven't tried it simply because I've found no hugely
compelling reason to upgrade, I've heard nothing bad about it.  It's the
same engine (slightly tweaked) as SQL Server 7 so I can't forsee much
happening.

-Original Message-
From: Adrian Cooper [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 2:56 PM
To: CF-Talk
Subject: Re: SQL Server 2000



- Original Message -
From: "Derek Hamilton" <[EMAIL PROTECTED]>
Sent: Monday, May 14, 2001 10:23 PM


>
> I am in the process of planning my upgrade to SQL Server 2000 from SQL
Server
7.0.  I was >wondering if anyone has noticed anything odd or difficult in
respect to ColdFusion (4.5 and

No - it was totally seamless for me. The databases are automatically
upgraded,
and the existing DSN's work fine.

Adrian Cooper.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

SQL 2000 Database List.

[Neil H.]

Just trying to get a feel from the community but do people notice on SQL
servers with 75 or so databases that the Enterprise Manager takes an
extremely long time to populate the list?  It most noticeable on a dial up
connection and just slower on faster connections.

Thanks,

Neil


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: SQL Server 2000

[Adrian Cooper]

- Original Message -
From: "Derek Hamilton" <[EMAIL PROTECTED]>
Sent: Monday, May 14, 2001 10:23 PM


>
> I am in the process of planning my upgrade to SQL Server 2000 from SQL Server
7.0.  I was >wondering if anyone has noticed anything odd or difficult in
respect to ColdFusion (4.5 and

No - it was totally seamless for me. The databases are automatically upgraded,
and the existing DSN's work fine.

Adrian Cooper.



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

DHTML Menu - Ben Forta's

[David Clay]

How does one represent a URL for the "Caption" headings under the cf_dhtmlmenu tag?

Any help would be appreciated.  Thank you

Dave Clay
Internet Facilitator
Trus Joist, A Weyerhaeuser Business
5995 Greenwood Plaza Blvd, Suite 100
Greenwood Village, CO 80111
303.770.8506
   
   
   
   
   
   
   
   
   


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

SQL Server 2000

[Derek Hamilton]

Hello!

I am in the process of planning my upgrade to SQL Server 2000 from SQL Server 7.0.  I 
was wondering if anyone has noticed anything odd or difficult in respect to ColdFusion 
(4.5 and 5.0RC)?

Any advice or even things you've noticed would be extremely helpful.

Thanks,

Derek Hamilton


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Locking Question

[Benjamin S. Rogers]

The scope attribute was added in ColdFusion 4.5. In ColdFusion 4, you can
approximate this behavior by using the name attribute. For Session
variables, use the name #Session.SessionID#. For Application variables, use
the name #Application.ApplicationName#.

Benjamin S. Rogers
Web Developer, c4.net
Voice: (508) 240-0051
Fax: (508) 240-0057

-Original Message-
From: David Baskin [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 5:10 PM
To: CF-Talk
Subject: Locking Question


Hello, i'm setting a session variable in a template so i'm using cflock, but
i'm getting an error on the scope attribute. i've checked the documentation
and it doesn't list scope as valid, but it shows up in Studio and well, it
just makes sense that you would use scope. Below is the code i was trying to
use. Also, what is the "proper" timeout that should be used for locking
session variables. Thanks for any help.

d














~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Locking Question

[David Baskin]

Hello, i'm setting a session variable in a template so i'm using cflock, but
i'm getting an error on the scope attribute. i've checked the documentation
and it doesn't list scope as valid, but it shows up in Studio and well, it
just makes sense that you would use scope. Below is the code i was trying to
use. Also, what is the "proper" timeout that should be used for locking
session variables. Thanks for any help.

d

















~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Does application tag need to be executed every time?

[Bryan Love]

Yes.  It sets the environment for the current request.  The name attribute
of the CFAPPLICATION tag determines which application variables can be seen
by the current request.


Bryan Love ACP
Internet Application Developer
[EMAIL PROTECTED]



-Original Message-
From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 7:15 AM
To: CF-Talk
Subject: Does application tag need to be executed every time?



I have this code in my application tag:








All the session/application vars seem to be fine
Does the application tag have to be executed on every page request? If so
why?

Thanks

KOla
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL - Count Function Error

[Bob Silverberg]

You have a comma out of place.  try changing:

ISNull(count(go.dMonthlyEventDate, 0)) as EventCount,
to
ISNull(count(go.dMonthlyEventDate),0) as EventCount,

It also looks like you have an extra comma on your FROM line, but the above
is what's causing your count error message.

Bob

-Original Message-
From: Julie Clegg [mailto:[EMAIL PROTECTED]]
Sent: May 14, 2001 4:36 PM
To: CF-Talk
Subject: SQL - Count Function Error



Hello,

I am trying to run this MS SQL query and I keep getting the following error:
"The count function requires 1 arguments"...

her is my query:


Select  cd1.vCodeDecodeDesc as EventTypeDesc,
ISNull(count(go.dMonthlyEventDate, 0)) as EventCount,
IsNull(count(go2.dMonthlyEventDate, 0)) as EventCount2

>From   CMGoal go, , CMgoal go2, CodeDecode cd1
where   (go.cEventTypeID = cd1.icodedecodeid
AND go.dMonthlyEventDate = #variables.dMonthYear#
AND (go.dStartDate > 0)
OR  (go2.cEventTypeID = cd1.icodedecodeid
AND go2.dMonthlyEventDate = #variables.dMonthYear#
AND go2.dAchieveDate > 0)
Group by EventTypeDesc


Does anyone know what it doesnt like?

TIA

Julie
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

finding special characters in a list

[Stephenie Hamilton]

i am trying to parse through a list and pull out a block of text, the text i
need ends with the paragraph symbol (when viewing special characters in
CFStudio) anyone know how i can get cf list functions to recognize it?
pardon the possibly stupid question, but is this the same as carriage
return/line feed?


--
Stephenie


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL - Count Function Error

[Jann VanOver]

Count doesn't need the ISNull check.  I believe that "Count" will count all
non-null fields so you just need:
  count(go.dMonthlyEventDate)


-Original Message-
From: Julie Clegg [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 1:36 PM
To: CF-Talk
Subject: SQL - Count Function Error



Hello,

I am trying to run this MS SQL query and I keep getting the following error:

"The count function requires 1 arguments"...

her is my query:


Select  cd1.vCodeDecodeDesc as EventTypeDesc,
ISNull(count(go.dMonthlyEventDate, 0)) as EventCount,
IsNull(count(go2.dMonthlyEventDate, 0)) as EventCount2

>From   CMGoal go, , CMgoal go2, CodeDecode cd1
where   (go.cEventTypeID = cd1.icodedecodeid
AND go.dMonthlyEventDate = #variables.dMonthYear#
AND (go.dStartDate > 0)
OR  (go2.cEventTypeID = cd1.icodedecodeid
AND go2.dMonthlyEventDate = #variables.dMonthYear#
AND go2.dAchieveDate > 0)
Group by EventTypeDesc


Does anyone know what it doesnt like?

TIA

Julie
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: [RE: Database/CF easy problem for someone.]

[Corrine Clark]

I tried the Group By in both the SQL statement, and the Output.
It now gives me one Franchise # and one Name, but it does not fill in the
rest of the responsibilities!
FSC # Franchise Controller Analyst Revenue AP Payroll Processor 
1 PAC PIZZA Bob 

3 IQ Investments (3) Erin 

4 IQ Investments (4) Darla

5 WKRP  Charlie

7 IQ Investments (7) Erin 

8 IQ Investments (8) Erin 

9 IQ Investments (9) Erin 

12 Sky Ventures LLC Randy 

13 Sky Ventures (2 in 1)Randy 

-Original Message-
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 3:05 PM
To: CF-Talk
Subject: Re: [RE: Database/CF easy problem for someone.]


try the group attribute in 

Corrine Clark <[EMAIL PROTECTED]> wrote:
Actually I have no problem with my IFs, they do what I want, which is
display the firstname of the person associated with the Dept.
I want one table row for each Company number and Name on a line with the
Responsibility, like so:
FSC #   Franchise   Controller  Analyst Revenue AP
PayrollProcessor
95  2JR TonySheryl  Vickie  Tim Virginia

Not each on its own line. And not all in one line.



Message-id: <850102F6DB16D4119D5C0090272895E21F08CF@FSCSERVER2>

I am pulling info from my database and trying to display in a table.
Here is my code


SELECT company.cono, company.coname, fsc_personnel.FirstName,
fsc_personnel.employeeid, fsc_personnel.email,
  company_responsibility.cono, company_responsibility.roleid,
company_responsibility.employeeid
FROM company RIGHT JOIN (company_responsibility RIGHT JOIN FSC_personnel
ON [company_responsibility].[employeeid]=[FSC_personnel].[employeeid])
ON [company].[CONO]=[company_responsibility].[CONO]
Where company.cono > 0
Order By Coname ASC




 FSC #
 Franchise
 Controller
 Analyst
 Revenue
 AP
 Payroll Processor


 
 #NumberFormat(getDeptR.cono,'___')#
 #getDeptR.Coname#
#getDeptR.Firstname#
 #getDeptR.Firstname#
 #getDeptR.Firstname#
 #getDeptR.Firstname#
 #getDeptR.Firstname#
 




Here is what displays

Department Responsibilities
  <<...>>
FSC #   Franchise   Controller  Analyst Revenue AP  Payroll
Processor
95  2JR Sheryl

95  2JR Vickie

95  2JR Crystal

95  2JR Tim

95  2JR Tony

69  AG HospitalitiesVirginia


69  AG HospitalitiesCharlie

69  AG HospitalitiesJoanne

98  ALTES   Darla

98  ALTES   Vickie

98  ALTES   Erin

98  ALTES   Shannon

98  ALTES   Chris


And I want it on one line.  Can anyone help?






-- 
NOTICE OF CONFIDENTIALITY 
~~
This message and all attachments are confidential.  It is intended only for
the use of the person to whom it is addressed.  If the message is not
addressed to you, then you should immediately notify the sender and delete
this message.  Any use or retransmission of this message by a person other
than the intended recipient is strictly prohibited and may violate state or
federal law. 

Franchise Services Company, LLC, its subsidiaries, affiliates, and
employees, do not accept liability for any errors, omissions, corruption or
virus in the contents of this message or any attachments that arise as a
result of e-mail transmission. 
~~ 



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

SQL - Count Function Error

[Julie Clegg]

Hello,

I am trying to run this MS SQL query and I keep getting the following error: 
"The count function requires 1 arguments"...

her is my query:


Select  cd1.vCodeDecodeDesc as EventTypeDesc,
ISNull(count(go.dMonthlyEventDate, 0)) as EventCount,
IsNull(count(go2.dMonthlyEventDate, 0)) as EventCount2

>From   CMGoal go, , CMgoal go2, CodeDecode cd1
where   (go.cEventTypeID = cd1.icodedecodeid
AND go.dMonthlyEventDate = #variables.dMonthYear#
AND (go.dStartDate > 0)
OR  (go2.cEventTypeID = cd1.icodedecodeid
AND go2.dMonthlyEventDate = #variables.dMonthYear#
AND go2.dAchieveDate > 0)
Group by EventTypeDesc


Does anyone know what it doesnt like?

TIA

Julie
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: cookie form & url -less sessions

[Bill Davidson]

There's a custom tag on Allaire's site that will automatically add the ID &
Token to all URL's between it's open and closing tags.   Which, if you are
using fusebox, is super-easily implemented.

You might look into that and see if that solves this for you.

-Bill
brainbox

- Original Message -
From: "Christopher Porter" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, May 14, 2001 1:17 PM
Subject: cookie form & url -less sessions


> hey hey everyone.. here's a dilemma for you.
>
> i've been task with createing an application model for a very large
> application that is being gutted and rebuilt. now i've decided that we
> need both application and session variables. however the govt doesnt allow
> cookies on thier machines.. even for intranets. we have way too much code
> to go through and add cfid and cftoken to the url or to form vars.. so i'm
> kinda stuck.
>
> the only thing i have going for me is that the users must log in using
> challange response, so i know who is who in the application. and with
> that, i could add a structure to the application class which bears the
> name of the user.. then add variables to the structure from there...
> thereby creating a session that lasts untill the server is rebooted.. but
> i'd much rather create a session taht times out and expunges the data etc
> etc. so my thought would be to create 2 variables in the
> application.#username# class that are cfid and CFtoken then use those to
> refrence the session... i'm not sure if that'll work tho..
>
> any other thoughts on how this could be done?
> -chris
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Database/CF easy problem for someone.

[Janine Jakim]

You need to do a select distinct statement in your query.
SELECT DISTINCT FSA #, Franchise

Or use the Group By statement in your query (this is probably the better
answer)


SELECT company.cono, company.coname, fsc_personnel.FirstName,
fsc_personnel.employeeid, fsc_personnel.email,
  company_responsibility.cono, company_responsibility.roleid,
company_responsibility.employeeid
FROM company RIGHT JOIN (company_responsibility RIGHT JOIN FSC_personnel
ON [company_responsibility].[employeeid]=[FSC_personnel].[employeeid])
ON [company].[CONO]=[company_responsibility].[CONO]
Where company.cono > 0
Group by FSA# or Franchise or whateverit must be located before the
order by clause.
Order By Coname ASC




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: [RE: Database/CF easy problem for someone.]

[Alex]

try the group attribute in 

Corrine Clark <[EMAIL PROTECTED]> wrote:
Actually I have no problem with my IFs, they do what I want, which is
display the firstname of the person associated with the Dept.
I want one table row for each Company number and Name on a line with the
Responsibility, like so:
FSC #   Franchise   Controller  Analyst Revenue AP
PayrollProcessor
95  2JR TonySheryl  Vickie  Tim Virginia

Not each on its own line. And not all in one line.

-Original Message-
From: j p [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 2:42 PM
To: CF-Talk
Subject: Re: Database/CF easy problem for someone.



I assume "I want it on one line" means the output...???(correct?)

Try this...(putting the output loop inside the  tags)


 #NumberFormat(getDeptR.cono,'___')#
 #getDeptR.Coname#
#getDeptR.Firstname#
 #getDeptR.Firstname#
 #getDeptR.Firstname#
 #getDeptR.Firstname#
 #getDeptR.Firstname#




. of course the will give you numerous table datas ...


What are you trying to do with these IFs???
since you are outputing #getDeptR.Firstname# in every instance...
they seem spufluous...


HTH

JP




Original Message Follows
From: Corrine Clark <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Subject: Database/CF easy problem for someone.
Date: Mon, 14 May 2001 14:11:47 -0500
Received: from [207.31.122.140] by hotmail.com (3.2) with ESMTP id 
MHotMailBCC97A42003140043125CF1F7A8C2E7C0; Mon May 14 12:17:30 2001
Received: from houseoffusion.com ([207.31.122.140])  by 
www.houseoffusion.com (Post.Office MTA v3.5.3 release 223  ID# 
0-54969U100L100S0V35) with ESMTP id com  for 
<[EMAIL PROTECTED]>;  Mon, 14 May 2001 15:20:46 -0400
>From [EMAIL PROTECTED] Mon May 14 12:19:19 2001
Message-id: <850102F6DB16D4119D5C0090272895E21F08CF@FSCSERVER2>

I am pulling info from my database and trying to display in a table.
Here is my code


SELECT company.cono, company.coname, fsc_personnel.FirstName,
fsc_personnel.employeeid, fsc_personnel.email,
  company_responsibility.cono, company_responsibility.roleid,
company_responsibility.employeeid
FROM company RIGHT JOIN (company_responsibility RIGHT JOIN FSC_personnel
ON [company_responsibility].[employeeid]=[FSC_personnel].[employeeid])
ON [company].[CONO]=[company_responsibility].[CONO]
Where company.cono > 0
Order By Coname ASC




 FSC #
 Franchise
 Controller
 Analyst
 Revenue
 AP
 Payroll Processor


 
 #NumberFormat(getDeptR.cono,'___')#
 #getDeptR.Coname#
#getDeptR.Firstname#
 #getDeptR.Firstname#
 #getDeptR.Firstname#
 #getDeptR.Firstname#
 #getDeptR.Firstname#
 




Here is what displays

Department Responsibilities
  <<...>>
FSC #   Franchise   Controller  Analyst Revenue AP  Payroll
Processor
95  2JR Sheryl

95  2JR Vickie

95  2JR Crystal

95  2JR Tim

95  2JR Tony

69  AG HospitalitiesVirginia


69  AG HospitalitiesCharlie

69  AG HospitalitiesJoanne

98  ALTES   Darla

98  ALTES   Vickie

98  ALTES   Erin

98  ALTES   Shannon

98  ALTES   Chris


And I want it on one line.  Can anyone help?




Corrine Clark


316-689-0049 x 383



--
NOTICE OF CONFIDENTIALITY
~~
This message and all attachments are confidential.  It is intended only for
the use of the person to whom it is addressed.  If the message is not
addressed to you, then you should immediately notify the sender and delete
this message.  Any use or retransmission of this message by a person other
than the intended recipient is strictly prohibited and may violate state or
federal law.

Franchise Services Company, LLC, its subsidiaries, affiliates, and
employees, do not accept liability for any errors, omissions, corruption or
virus in the contents of this message or any attachments that arise as a
result of e-mail transmission.
~~
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

OT: catalog.wci filling up hard drive space?

[Rick Lamb]

We have a server that is filling up hard disk space very quickly and most of
the growth is happening in this "catalog.wci" folder. Is this the logging
folder for index server? If not what is it used for and how can I control
it's growth?

Thanks,

Rick


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Database/CF easy problem for someone.

[Corrine Clark]

Actually I have no problem with my IFs, they do what I want, which is
display the firstname of the person associated with the Dept.
I want one table row for each Company number and Name on a line with the
Responsibility, like so:
FSC #   Franchise   Controller  Analyst Revenue AP
PayrollProcessor
95  2JR TonySheryl  Vickie  Tim Virginia

Not each on its own line. And not all in one line.

-Original Message-
From: j p [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 2:42 PM
To: CF-Talk
Subject: Re: Database/CF easy problem for someone.



I assume "I want it on one line" means the output...???(correct?)

Try this...(putting the output loop inside the  tags)


 #NumberFormat(getDeptR.cono,'___')#
 #getDeptR.Coname#
#getDeptR.Firstname#
 #getDeptR.Firstname#
 #getDeptR.Firstname#
 #getDeptR.Firstname#
 #getDeptR.Firstname#




. of course the will give you numerous table datas ...


What are you trying to do with these IFs???
since you are outputing #getDeptR.Firstname# in every instance...
they seem spufluous...


HTH

JP




Original Message Follows
From: Corrine Clark <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Subject: Database/CF easy problem for someone.
Date: Mon, 14 May 2001 14:11:47 -0500
Received: from [207.31.122.140] by hotmail.com (3.2) with ESMTP id 
MHotMailBCC97A42003140043125CF1F7A8C2E7C0; Mon May 14 12:17:30 2001
Received: from houseoffusion.com ([207.31.122.140])  by 
www.houseoffusion.com (Post.Office MTA v3.5.3 release 223  ID# 
0-54969U100L100S0V35) with ESMTP id com  for 
<[EMAIL PROTECTED]>;  Mon, 14 May 2001 15:20:46 -0400
>From [EMAIL PROTECTED] Mon May 14 12:19:19 2001
Message-id: <850102F6DB16D4119D5C0090272895E21F08CF@FSCSERVER2>

I am pulling info from my database and trying to display in a table.
Here is my code


SELECT company.cono, company.coname, fsc_personnel.FirstName,
fsc_personnel.employeeid, fsc_personnel.email,
  company_responsibility.cono, company_responsibility.roleid,
company_responsibility.employeeid
FROM company RIGHT JOIN (company_responsibility RIGHT JOIN FSC_personnel
ON [company_responsibility].[employeeid]=[FSC_personnel].[employeeid])
ON [company].[CONO]=[company_responsibility].[CONO]
Where company.cono > 0
Order By Coname ASC




 FSC #
 Franchise
 Controller
 Analyst
 Revenue
 AP
 Payroll Processor


 
 #NumberFormat(getDeptR.cono,'___')#
 #getDeptR.Coname#
#getDeptR.Firstname#
 #getDeptR.Firstname#
 #getDeptR.Firstname#
 #getDeptR.Firstname#
 #getDeptR.Firstname#
 




Here is what displays

Department Responsibilities
  <<...>>
FSC #   Franchise   Controller  Analyst Revenue AP  Payroll
Processor
95  2JR Sheryl

95  2JR Vickie

95  2JR Crystal

95  2JR Tim

95  2JR Tony

69  AG HospitalitiesVirginia


69  AG HospitalitiesCharlie

69  AG HospitalitiesJoanne

98  ALTES   Darla

98  ALTES   Vickie

98  ALTES   Erin

98  ALTES   Shannon

98  ALTES   Chris


And I want it on one line.  Can anyone help?




Corrine Clark


316-689-0049 x 383



--
NOTICE OF CONFIDENTIALITY
~~
This message and all attachments are confidential.  It is intended only for
the use of the person to whom it is addressed.  If the message is not
addressed to you, then you should immediately notify the sender and delete
this message.  Any use or retransmission of this message by a person other
than the intended recipient is strictly prohibited and may violate state or
federal law.

Franchise Services Company, LLC, its subsidiaries, affiliates, and
employees, do not accept liability for any errors, omissions, corruption or
virus in the contents of this message or any attachments that arise as a
result of e-mail transmission.
~~
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: ftp to novell

[Lanny R. Udey]

Does the server that your Ftp server is running on have contextless login? If not you 
would have to use a fully qualified login name , e.g.,   .userid.ou.o.us

Lanny Udey
Hofstra University

>>> [EMAIL PROTECTED] Monday, May 14, 2001 >>>
I have tried multiple users and I can FTP through NT just fine.  It just seems 
to be a problem when I use the cfftp through Novell.  



> *This message was transferred with a trial version of CommuniGate(tm) Pro*
> Try setting up a new user just to login to ftp and set its home directory to
> crsapps. Make sure this account has the appropriate rights to get to the
> files. I think all you should need is read and file scan.
> Hope that helps.
> 
> Dave Livingston
> [EMAIL PROTECTED] 
> 
> -Original Message-
> From: Joshua Tipton [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, May 14, 2001 10:41 AM
> To: CF-Talk
> Subject: ftp to novell
> 
> 
> *This message was transferred with a trial version of CommuniGate(tm) Pro*
> I am trying to ftp to a novell server and am not having the best of luck.  I
> can get the currect directroy to return sys: which is right.  When I try to
> listdir of a direcotyr called crsapps I get nothing.  I have tried /crsapps,
> crsapps. crsapps/*.* and get nothing.  Is there a trick to novell?
> 
> Joshua Tipton
> 
> 
>  username="crsser"
> password="crsser"
> server="10.66.64.52"
> action="open"
> stoponerror="yes">
> 
> stoponerror="Yes"
>connection="ftp">
> 
> 
> #cfftp.returnvalue#
> 
>  action="listdir"
> directory="/crsapps"
> name="q"
> stoponerror="yes">
> 
> 
> 
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: IE4 and Required Fields w/ CFINPUT

[Billy Cravens]

Manually code your JavaScript validation routines.

--
Billy Cravens
HR Web Development, Sabre
[EMAIL PROTECTED]

Matthew Hood wrote:

> Ok, My form works like a champ in Netscape and I run
> into no problems in IE5 but I get a javascript error
> in IE4. Since I have no javascript on the page I can
> only assume it is the javascript that is auto-generated
> by my 
> Anyone else run into problems using required=yes under IE4?
> Is there any way around it?
>
> Matt Hood
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: IE4 and Required Fields w/ CFINPUT

[Ray Bujarski]

Make sure your cfform tag has a name AND the cfinput type has a name specified

At 03:27 PM 5/14/2001 -0400, you wrote:
>Ok, My form works like a champ in Netscape and I run
>into no problems in IE5 but I get a javascript error
>in IE4. Since I have no javascript on the page I can
>only assume it is the javascript that is auto-generated
>by my 
>Anyone else run into problems using required=yes under IE4?
>Is there any way around it?
>
>Matt Hood
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: IE4 and Required Fields w/ CFINPUT

[Matthew Hood]

Matthew Hood wrote:

> Ok, My form works like a champ in Netscape and I run
> into no problems in IE5 but I get a javascript error
> in IE4. Since I have no javascript on the page I can
> only assume it is the javascript that is auto-generated
> by my 
> Anyone else run into problems using required=yes under IE4?
> Is there any way around it?
>
> Matt Hood

What's more, after clicking either yes or no, the form
will continue onto the next page. If there is no way
to make it compatible with IE4, is there a way to
simply supress the error message?
I am about done with this project and this is the only hurdle
remaining and I feel as if I am gonna trip and fall
flat on my face over a damn javascript error!

Matt Hood

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Database/CF easy problem for someone.

[j p]

I assume "I want it on one line" means the output...???(correct?)

Try this...(putting the output loop inside the  tags)


 #NumberFormat(getDeptR.cono,'___')#
 #getDeptR.Coname#
#getDeptR.Firstname#
 #getDeptR.Firstname#
 #getDeptR.Firstname#
 #getDeptR.Firstname#
 #getDeptR.Firstname#




 of course the will give you numerous table datas ...


What are you trying to do with these IFs???
since you are outputing #getDeptR.Firstname# in every instance...
they seem spufluous...


HTH

JP




Original Message Follows
From: Corrine Clark <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Subject: Database/CF easy problem for someone.
Date: Mon, 14 May 2001 14:11:47 -0500
Received: from [207.31.122.140] by hotmail.com (3.2) with ESMTP id 
MHotMailBCC97A42003140043125CF1F7A8C2E7C0; Mon May 14 12:17:30 2001
Received: from houseoffusion.com ([207.31.122.140])  by 
www.houseoffusion.com (Post.Office MTA v3.5.3 release 223  ID# 
0-54969U100L100S0V35) with ESMTP id com  for 
<[EMAIL PROTECTED]>;  Mon, 14 May 2001 15:20:46 -0400
>From [EMAIL PROTECTED] Mon May 14 12:19:19 2001
Message-id: <850102F6DB16D4119D5C0090272895E21F08CF@FSCSERVER2>

I am pulling info from my database and trying to display in a table.
Here is my code


SELECT company.cono, company.coname, fsc_personnel.FirstName,
fsc_personnel.employeeid, fsc_personnel.email,
  company_responsibility.cono, company_responsibility.roleid,
company_responsibility.employeeid
FROM company RIGHT JOIN (company_responsibility RIGHT JOIN FSC_personnel
ON [company_responsibility].[employeeid]=[FSC_personnel].[employeeid])
ON [company].[CONO]=[company_responsibility].[CONO]
Where company.cono > 0
Order By Coname ASC




 FSC #
 Franchise
 Controller
 Analyst
 Revenue
 AP
 Payroll Processor


 
 #NumberFormat(getDeptR.cono,'___')#
 #getDeptR.Coname#
#getDeptR.Firstname#
 #getDeptR.Firstname#
 #getDeptR.Firstname#
 #getDeptR.Firstname#
 #getDeptR.Firstname#
 




Here is what displays

Department Responsibilities
  <<...>>
FSC #   Franchise   Controller  Analyst Revenue AP  Payroll
Processor
95  2JR Sheryl

95  2JR Vickie

95  2JR Crystal

95  2JR Tim

95  2JR Tony

69  AG HospitalitiesVirginia


69  AG HospitalitiesCharlie

69  AG HospitalitiesJoanne

98  ALTES   Darla

98  ALTES   Vickie

98  ALTES   Erin

98  ALTES   Shannon

98  ALTES   Chris


And I want it on one line.  Can anyone help?




Corrine Clark


316-689-0049 x 383



--
NOTICE OF CONFIDENTIALITY
~~
This message and all attachments are confidential.  It is intended only for
the use of the person to whom it is addressed.  If the message is not
addressed to you, then you should immediately notify the sender and delete
this message.  Any use or retransmission of this message by a person other
than the intended recipient is strictly prohibited and may violate state or
federal law.

Franchise Services Company, LLC, its subsidiaries, affiliates, and
employees, do not accept liability for any errors, omissions, corruption or
virus in the contents of this message or any attachments that arise as a
result of e-mail transmission.
~~
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: ftp to novell

[jtipton1]

I have tried multiple users and I can FTP through NT just fine.  It just seems 
to be a problem when I use the cfftp through Novell.  



> *This message was transferred with a trial version of CommuniGate(tm) Pro*
> Try setting up a new user just to login to ftp and set its home directory to
> crsapps. Make sure this account has the appropriate rights to get to the
> files. I think all you should need is read and file scan.
> Hope that helps.
> 
> Dave Livingston
> [EMAIL PROTECTED]
> 
> -Original Message-
> From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 14, 2001 10:41 AM
> To: CF-Talk
> Subject: ftp to novell
> 
> 
> *This message was transferred with a trial version of CommuniGate(tm) Pro*
> I am trying to ftp to a novell server and am not having the best of luck.  I
> can get the currect directroy to return sys: which is right.  When I try to
> listdir of a direcotyr called crsapps I get nothing.  I have tried /crsapps,
> crsapps. crsapps/*.* and get nothing.  Is there a trick to novell?
> 
> Joshua Tipton
> 
> 
>  username="crsser"
> password="crsser"
> server="10.66.64.52"
> action="open"
> stoponerror="yes">
> 
> stoponerror="Yes"
>connection="ftp">
> 
> 
> #cfftp.returnvalue#
> 
>  action="listdir"
> directory="/crsapps"
> name="q"
> stoponerror="yes">
> 
> 
> 
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: [Database/CF easy problem for someone.]

[Alex]

take out your 2nd  from inside the loop




#NumberFormat(getDeptR.cono,'___')#
#getDeptR.Coname#
#getDeptR.Firstname#
#getDeptR.Firstname#
#getDeptR.Firstname#
#getDeptR.Firstname#
#getDeptR.Firstname#




Corrine Clark <[EMAIL PROTECTED]> wrote:

I am pulling info from my database and trying to display in a table.
Here is my code


SELECT company.cono, company.coname, fsc_personnel.FirstName,
fsc_personnel.employeeid, fsc_personnel.email,
 company_responsibility.cono, company_responsibility.roleid,
company_responsibility.employeeid
FROM company RIGHT JOIN (company_responsibility RIGHT JOIN FSC_personnel 
ON [company_responsibility].[employeeid]=[FSC_personnel].[employeeid]) 
ON [company].[CONO]=[company_responsibility].[CONO]
Where company.cono > 0
Order By Coname ASC




FSC #
Franchise
Controller
Analyst
Revenue
AP
Payroll Processor


 
#NumberFormat(getDeptR.cono,'___')#
#getDeptR.Coname#
#getDeptR.Firstname#
#getDeptR.Firstname#
#getDeptR.Firstname#
#getDeptR.Firstname#
#getDeptR.Firstname#
 




Here is what displays

Department Responsibilities 
 <<...>> 
FSC #   Franchise   Controller  Analyst Revenue AP  Payroll
Processor   
95  2JR Sheryl  

95  2JR Vickie  

95  2JR Crystal 

95  2JR Tim 

95  2JR Tony

69  AG HospitalitiesVirginia


69  AG HospitalitiesCharlie 

69  AG HospitalitiesJoanne  

98  ALTES   Darla   

98  ALTES   Vickie  

98  ALTES   Erin

98  ALTES   Shannon 

98  ALTES   Chris   


And I want it on one line.  Can anyone help?




Corrine Clark


316-689-0049 x 383



-- 
NOTICE OF CONFIDENTIALITY 
~~
This message and all attachments are confidential.  It is intended only for
the use of the person to whom it is addressed.  If the message is not
addressed to you, then you should immediately notify the sender and delete
this message.  Any use or retransmission of this message by a person other
than the intended recipient is strictly prohibited and may violate state or
federal law. 

Franchise Services Company, LLC, its subsidiaries, affiliates, and
employees, do not accept liability for any errors, omissions, corruption or
virus in the contents of this message or any attachments that arise as a
result of e-mail transmission. 
~~
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

IE4 and Required Fields w/ CFINPUT

[Matthew Hood]

Ok, My form works like a champ in Netscape and I run
into no problems in IE5 but I get a javascript error
in IE4. Since I have no javascript on the page I can
only assume it is the javascript that is auto-generated
by my 
Anyone else run into problems using required=yes under IE4?
Is there any way around it?

Matt Hood

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Database/CF easy problem for someone.

[Corrine Clark]

I am pulling info from my database and trying to display in a table.
Here is my code


SELECT company.cono, company.coname, fsc_personnel.FirstName,
fsc_personnel.employeeid, fsc_personnel.email,
 company_responsibility.cono, company_responsibility.roleid,
company_responsibility.employeeid
FROM company RIGHT JOIN (company_responsibility RIGHT JOIN FSC_personnel 
ON [company_responsibility].[employeeid]=[FSC_personnel].[employeeid]) 
ON [company].[CONO]=[company_responsibility].[CONO]
Where company.cono > 0
Order By Coname ASC




FSC #
Franchise
Controller
Analyst
Revenue
AP
Payroll Processor


 
#NumberFormat(getDeptR.cono,'___')#
#getDeptR.Coname#
#getDeptR.Firstname#
#getDeptR.Firstname#
#getDeptR.Firstname#
#getDeptR.Firstname#
#getDeptR.Firstname#
 




Here is what displays

Department Responsibilities 
 <<...>> 
FSC #   Franchise   Controller  Analyst Revenue AP  Payroll
Processor   
95  2JR Sheryl  

95  2JR Vickie  

95  2JR Crystal 

95  2JR Tim 

95  2JR Tony

69  AG HospitalitiesVirginia


69  AG HospitalitiesCharlie 

69  AG HospitalitiesJoanne  

98  ALTES   Darla   

98  ALTES   Vickie  

98  ALTES   Erin

98  ALTES   Shannon 

98  ALTES   Chris   


And I want it on one line.  Can anyone help?




Corrine Clark


316-689-0049 x 383



-- 
NOTICE OF CONFIDENTIALITY 
~~
This message and all attachments are confidential.  It is intended only for
the use of the person to whom it is addressed.  If the message is not
addressed to you, then you should immediately notify the sender and delete
this message.  Any use or retransmission of this message by a person other
than the intended recipient is strictly prohibited and may violate state or
federal law. 

Franchise Services Company, LLC, its subsidiaries, affiliates, and
employees, do not accept liability for any errors, omissions, corruption or
virus in the contents of this message or any attachments that arise as a
result of e-mail transmission. 
~~ 



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: cfm-resources?

[Jennifer Knoblock]

They went down over the weekend to install a wireless t1 connection for the
freebie sites.

>From an email I got last week from cfm-resources.com...
 We'd like to let you know that we have just ordered a Wireless T1
connection strictly for the free sites, therefore we will be turning
them off for two days.  Starting May 11th, 2001 until May 13th, 2001.  This
is a necessary action, to provide better service and much more
reliability.

A dedicated T1 connection will be in place only for the free server,
therefore giving our free customers faster access and more uptime!  We
do however appologize for the downtime, but it is necessary for the
system to be installed on that machine.  After May 13th, 2001 you will no
longer  experience downtime.  All paying sites (Bronze and higher, will remain
up with no changes to the sites, whatsoever).

HTH!
Jennifer


Kay Smoljak wrote:

> Hi all,
>
> I was wondering if anyone else was having problems with free accounts at
> cfm-resources.com? First my password stopped working, and when I got no
> response to repeated emails, I gave up and signed up for another account.
> (Incidently, after a number of errors were thrown in the registration
> scripts, I ended up with three accounts but that's a different story.)
>
> Attempts to FTP in are successful after on average three or four timeouts.
> Everytime I do actually manage to connect, it timeouts before I can upload
> any files. The site itself takes ages to load and then I get server errors.
> The cfm-resources control panel is not even up.
>
> Now, before you tell me that you get what you pay for, I totally agree. I'm
> developing a site for a non-profit organisation with next to zero funding,
> which promotes science and technology career paths for high school students,
> girls in particular. The aim is to create a site that they can update and
> maintain themselves, thereby requiring no more funding for web work. My plan
> being, if I can get the site running on the free hosting service, and they
> see how great and easy it is and maybe interest some benefactors, I will get
> them to move to one of the low cost hosting services. Hell, I was even
> planning to pay for some of it myself. I'm not expecting great reliability
> or speed out of a free service. But at the moment *I* can't even view the
> site, and it's been like that all week.
>
> What I would like to know is, what is the reliability like on their paid
> accounts? I'd be reluctant to risk them after my experiences with the free
> service. What are the other low cost hosting services out there like?
>
> Sorry to bitch but this is driving me insane!
>
> Kay.
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Access web reference

[Chris Montgomery]

Here's a couple bookmarks to get you started:
http://www.accesswatch.co.uk/
http://msdn.microsoft.com/library/techart/acacclinks.htm

Chris Montgomery [EMAIL PROTECTED]  

Web Development & Consulting http://www.astutia.com
Allaire Sales & Consulting Partner  
210-490-3249/888-745-7603Fax 210-490-4692
Instant Messaging:
AIM: astutiaweb; ICQ: 7381282; MSN: [EMAIL PROTECTED]

> -Original Message-
> From: Jeremy [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 14, 2001 11:39 AM
> To: CF-Talk
> Subject: OT: Access web reference
> 
> 
> Anyone know of a good web-based reference for Access SQL syntax?
> 
> Thanks,
> 
> Jeremy

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: the dbl devil

[Dylan Bromby]

if using CF 4.5.x, why not use:



to release the DSN, and:



to re-enable it.

just replace DSN with your actual DSN.


-Original Message-
From: Stephen Moretti [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 11, 2001 7:45 AM
To: CF-Talk
Subject: RE: the dbl devil


Just as an aside...
Its not actually your application that's holding your database open.  By
default, ODBC is set to "maintain connections".  This is a good and a bad
thing.  Good because it is more efficient to maintain a connection to the
database than to re-make the connection each time you query, insert or
update any of your database tables.  Bad because it means that its difficult
to update your database, but, as Chris says, as long as you are using CF
4.5.x then you can use the cfusion_dbconnections_flush()function.

One thing to say about that function - Use it sparingly  The function
will flush _all_ database connections. This means that not only will
connections to your database, but everyone else's connections too.  So
potentially you could upset all the other people hosted on the same server
as you, if you use it too often and affect the performance of their
applications.

If you're on a dedicated server and have access to the CF Administrator,
then you can also flush DB connections from the "Verify Data Source" menu
item.

Regards

Stephen
PS. Does anyone know if you can specify a datasource name as an attribute of
cfusion_dbconnections_flush(), so that it will release only the named
datasource?


> -Original Message-
> From: Chris Maloney [mailto:[EMAIL PROTECTED]]
> Sent: 11 May 2001 14:48
> To: CF-Talk
> Subject: RE: the dbl devil
>
>
> Megan,
> Provided you are using CF4.5.x you should be able to use the
> cfusion_dbconnections_flush() function to release the database.
> You do need
> to make sure that from the time you release the connection to the time you
> delete the database or replace it that no database accesses are done,
> otherwise the database will again be locked.
>
> The use of 'date' as a field name is a pretty common mistake, it would be
> nice if Access provided warnings about this when you create a database but
> it does not.
>
> Chris
>
> -Original Message-
> From: megan sherman [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 11, 2001 8:27 AM
> To: CF-Talk
> Subject: the dbl devil
>
>
> Hi all,
> I'm using Access for my database. Sometimes when I need to make changes
> to the database on the server there is a .dbl file in the directory. I
> can't delete it, and it won't let me upload the database. A couple days
> ago someone on this list said to create a query calling a table that
> doesn't exist. I did that. Got the error on the screen, but the devilish
> dbl was still there. I talked to my cf host and he said, "Your code is
> holding your database too long..put in your code a time to release the
> database after so many minutes." Does anyone know what he was talking
> about?
>  Also, thanks for your assistance on my syntax error when inserting
> date. I was thrown off because cfinsert and cfupdate worked fine. But
> all went awry when I tried to use insert in a query in a cfloop. So
> changing the field name from "date" to "classdate" did the trick.
> Thanks!
> Megan
>
>
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: ftp to novell

[Dave Livingston]

*This message was transferred with a trial version of CommuniGate(tm) Pro*
Try setting up a new user just to login to ftp and set its home directory to
crsapps. Make sure this account has the appropriate rights to get to the
files. I think all you should need is read and file scan.
Hope that helps.

Dave Livingston
[EMAIL PROTECTED]

-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 10:41 AM
To: CF-Talk
Subject: ftp to novell


*This message was transferred with a trial version of CommuniGate(tm) Pro*
I am trying to ftp to a novell server and am not having the best of luck.  I
can get the currect directroy to return sys: which is right.  When I try to
listdir of a direcotyr called crsapps I get nothing.  I have tried /crsapps,
crsapps. crsapps/*.* and get nothing.  Is there a trick to novell?

Joshua Tipton







#cfftp.returnvalue#







~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: "Harpoon" Release is Final & Available

[Zac]

Steve Drucker wrote:

> Using WDDX at this time, regrettably, is NOT a best practice.

Is this because of some problem with Flash?



-- 

Every cloud has its silver lining, and lightning kills hundreds of
people each year who are trying to find it.



email: [EMAIL PROTECTED]
web: http://www.pixelgeek.com/


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: best search

[Dave Watts]

> Does anyone know if verity works on searching a data type of 
> LONG or CLOB for an oracle database? I am building a search 
> engine for an oracle db and am new to the Oracle world, where 
> I was recently struck by the fact you can't do a search on a 
> LONG Data type?!? Has anyone built a search engine on a oracle 
> database that can offer some help on this topic?

As long as you can retrieve the field in a SELECT statement, and it's a
string, you should have no problems using it with Verity.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

cookie form & url -less sessions

[Christopher Porter]

hey hey everyone.. here's a dilemma for you.

i've been task with createing an application model for a very large
application that is being gutted and rebuilt. now i've decided that we
need both application and session variables. however the govt doesnt allow
cookies on thier machines.. even for intranets. we have way too much code
to go through and add cfid and cftoken to the url or to form vars.. so i'm
kinda stuck.

the only thing i have going for me is that the users must log in using
challange response, so i know who is who in the application. and with
that, i could add a structure to the application class which bears the
name of the user.. then add variables to the structure from there...
thereby creating a session that lasts untill the server is rebooted.. but
i'd much rather create a session taht times out and expunges the data etc
etc. so my thought would be to create 2 variables in the
application.#username# class that are cfid and CFtoken then use those to
refrence the session... i'm not sure if that'll work tho..

any other thoughts on how this could be done?
-chris


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: disable user on LDAP server

[Michael Ross]

Maybe this might help, in ldap using Novell DS there is a field called LOGINDISABLED 
if this is set to true its disabled if not, its not.  See if there is a similar field 
in Netscape.

Thanks

>>> [EMAIL PROTECTED] 05/11/01 10:34PM >>>
hi,

is there a way where i can temporary disable an user on Netscape LDAP
server? sort of disable that user account which in future allow me to enable
it again, for temporary suspension on that user account. I did not see any
function for me to disable user account in Netscape LDAP server, any advise?
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: [Session Variables - I don't get it]

[Alex]

because you are setting it to black on the application.cfm page.
change the application.cfm  cfset to cfparam

"Kronenberger, Douglas" <[EMAIL PROTECTED]> wrote:
Greetings,

I'm not getting how to implement session variables. I'm just trying to set
the session variable "Session.Dog" from black to Blue and have it show up as
Blue on the test.cfm. It keep show'n up black. I do have Session Variables
enabled via the CF Administrator page.

What am I miss'n here.















 #Session.Dog# 





 Goto










 #Session.Dog#  





-


Can someone get me started here. 

Thanks

> Doug Kronenberger
> OI National Training and Education Office
> 440-526-3030 x7776
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: "Harpoon" Release is Final & Available

[Steve Drucker]

It's gone...the Harpoon documentation details various best practices for
transferring information from ColdFusion to Flash.

Using WDDX at this time, regrettably, is NOT a best practice.  

Regards,
Steve Drucker
CEO
Fig Leaf Software


-Original Message-
From: Evan Lavidor [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 12:30 PM
To: CF-Talk
Subject: RE: "Harpoon" Release is Final & Available


I seem to remember that in some of the early betas for "Harpoon" there was
an actionscript file for reading WDDX packets in Flash.  Did this disappear?
Or did it simply become subsumed into some of the FLA's.  If the latter is
true, could someone point me to the right place to find it?  If it's gone,
is there a reason?

Thanks,

Evan

> -Original Message-
> From: Sam Coe [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 14, 2001 10:29 AM
> To: CF-Talk
> Subject: "Harpoon" Release is Final & Available
>
>
> We are happy to announce the availability of The Macromedia Flash
> Component
> Kit for ColdFusion.  The kit, first announced in November 2000 under the
> code name 'Harpoon', is now available for download from the ColdFusion
> Developers Exchange.
>
> The Macromedia Flash Component Kit for ColdFusion is a resource for
> ColdFusion developers to quickly and easily add Macromedia Flash
> elements to
> their Web applications.  ColdFusion developers can immediately take
> advantage of the design and delivery benefits of Macromedia Flash and
> Macromedia Flash Player without learning a new authoring product. For more
> advanced developers, the Component Kit provides guidelines and
> documentation
> for creating and customizing new Macromedia Flash components for
> ColdFusion
> that can be shared with other developers.
>
> The Component Kit includes 4 prebuilt Macromedia Flash sample components,
> guidelines detailing how to use and customize components and ColdFusion
> custom tags that control the behavior of those components.
>
> The four Macromedia Flash sample components included with the kit are:
>
> *Calendar
> *Calculator
> *Horizontal Menu
> *Cascading Menu (for Microsoft Internet Explorer)
>
> The Component Kit is available for free download from the Allaire
> Developers
> Exchange for the Windows and UNIX platforms.  To access the
> components, type
> "Macromedia Flash" into the Developers Exchange Search window
> (http://devex.allaire.com/developer/gallery/index.cfm) or visit the
> following page to link directly to the kit:
>
> http://www.allaire.com/handlers/index.cfm?ID=20983
>
> The FAQ and license agreements are also available on this page.
>
> Best,
> -Sam
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Access database question: how to structure a link between tw o tables

[stas]

Also, don't confuse a "safe type" - such as a model designation, with a safe
"serial number." You would use a safe's serial number as a primary key in
the safe table, as well as a foreign key in the intersection table Dave
described below. To figure out what type of safe it is, you would need
another table which will contain that model's description, and an additional
field in the safe table which we be a foreign key to the safe type table.


- Original Message -
From: "Dave Watts" <[EMAIL PROTECTED]>


> i've created a database to handle an insurance form which
> deals with the insurance of money.  it has a number of
> different tables such as 'cust', which lists details of
> customers, 'prem', which lists details of where the money is
> stored, and 'safe' which lists details of the safes in which
> the money is stored.
>
> the tables 'safe' and 'prem' relate to each other, in that a
> premises may have one or more safes, and one type of safe may
> be used in more than one premises.  another way of putting it
> is that each safe could have 1 or more premises that match to
> it & each premises could have 1 or more safes that match to
> it, with a maximum number of 3 safes or premises.  what
> structure should i use for the link between the two tables?

You have what is called a "many-to-many" relationship. There's no way to
directly represent a many-to-many relationship in a relational database, so
you'll need to create a table for this purpose. This table, called a linking
table or an intersection table, should contain the primary key columns from
each of the other two tables, and should be related to each of those tables
using a one-to-many relationship; one record from each table can have many
matches within the linking table. As a primary key, the linking table should
use the two foreign keys together - a composite primary key.

In Access, you can create these relationships using the Relationship window,
once you've created the linking table.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Going bonkers with an Update in table

[Stephen Jaeb]

I'm assuming the update query goes after the form is sbumitted?
Look at the values of your hidden fields in the form processing page -- since
you don't change or update the hidden field variable names for each field, it
just appends it to what the previous values was.  So, it should put the list in
the first field you have it update, since there is only one variable (ie
Form.GradesID, Form.PERNUM, etc).

See if that helps...
-S-

--- Dave f <[EMAIL PROTECTED]> wrote:
> 
> Had to guess at some of this:
> 
> From the  loop, it looks as if you are
> expecting to retrieve more  than 1 row with your query and store the
> retrieved elements in FORMname lists.
> 
> But the update query *isn't* in a loop, and you aren't doing anything like
> GetToken or ListGetAt,  so updates the row with the entire list. ??
> 
> 
> - Original Message -
> From: "Janine Jakim" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, May 14, 2001 9:58 AM
> Subject: Going bonkers with an Update in table
> 
> 
> > This is beginning to drive me bananas.  This is a repost that I'm hoping
> > someone can help with. I am trying to do an update query on a table-it
> keeps
> > updating only the first column of the table- with all the data updating in
> > just that one field!  Although the table seems set up correctly (ie: the
> Id
> > number that I want updated shows up correctly- until you run the update
> > query.  For example my table displays like so:
> > #Skill# #ID# #Semester##Grade# #ID#
> > #Semester##Grade#
> >
> > Reads 1A 4
> > B
> > Writes 2A 5   A
> > Spells 3B 6  B
> >
> > If I run the update query it'll put everything into ID 1 field (A, A, B,
> B,
> > A, B)
> > My code is as follows:
> >
> > 
> > 
> > SELECT  tbl_StudentGrade.GradesID, tbl_StudentGrade.SkillID,
> > tbl_CourseSkill.Skill, tbl_StudentGrade.GradeForSubject,
> > tbl_StudentGrade.SchoolDates, tbl_StudentGrade.Advisor,
> > tbl_StudentGrade.GradingPeriod, tbl_StudentGrade.PERMNUM
> > FROM tbl_CourseSkill, tbl_StudentGrade
> > WHERE   tbl_CourseSkill.SkillID = tbl_StudentGrade.SkillID and
> > PERMNUM='#PERMNUM#' And CourseID=1 OR
> > tbl_CourseSkill.SkillID = tbl_StudentGrade.SkillID and
> > PERMNUM='#PERMNUM#' And CourseID=2
> > Order BY tbl_StudentGrade.SkillID, GradingPeriod
> > 
> >
> > 
> > 
> > 
> > 
> > #Skill#
> > 
> >
> > 
> > #GetSubjects.GradeForSubject#
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> >
> >
> > 
> >  
> >   UPDATE tbl_StudentGrade
> >   SET GradeForSubject='#trim(GradeForSubject)#'
> > WHERE GradesID=#Val(GradesID)#
> >
> >   
> >
> > Are there any ideas about what I need to do differently?
> > Thanks in advance for the help.
> > j
> >
> > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> >
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: [CF-Talk Archiver]

[Michael Dinowitz]

* Team Allaire *
House of Fusion (yes, that's me) is looking into doing a weekly thread
compilation of the lists. I have in my hand an 18 page test compilation that
was done by an editor. Once it's been reviewed and polished I'll hand it out
to a few 'test' subjects to see how they like it. Once we have a solid
format we'll be compiling list archives on a regular basis.
The basic format I'd like to see is one of:
1. Question
2. Answer
3. Additional answers (if exist)
4. Clarification (if exist)
5. Answers on clarification (if exist)
This will allow someone to see the whole flow of logic from question to
possible answer. That's the good news. The bad is that we have to pay for
the editor to go through all the posts, compile them and write them up.
We're looking to MM and others for sponsorships and would like to keep from
charging people for it. We'll have to see how it goes.

> On Mon, 14 May 2001 08:43:28 CDT, Alex <[EMAIL PROTECTED]> wrote:
>
> >Doesn't CF-Talk already archive the emails?
>
> Yes, but unfortunately some of us occasionally have to go offline. Yes, I
> know, it sucks, but a sad fact of life :)
>
> I think a client side app would be great - searching would be much faster
> than loading up the online archive. I currently read CF-Talk through Agent
> (the icky newsreader) from the fuseware NNTP mirror. I am working on a
> little program to parse the Agent file format and dump the messages into a
> database. If someone can make available their archives in a format Peter's
> application can read, I may not have to bother finishing it. Anyone?
Peter,
> I would love to send you a postcard... but good ole Perth is not too
> exciting :)
>
> K.
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: best search

[Michael Lugassy]

"As a rule of thumb "use the right tool for the job", don't just use a tool
because it is there."

This is probarbly the best sentence I've heard this week! (come to think of
it, it's only monday.. :)
I asked for help and got it, but actually more questions arises, I'll try to
describe them:

1. the content would be txt and pure ASCII text only! actually I just
finished the mechanisem
which takes the html files from all of the sites I want to search in and
then remove
all html tags/javascript codes and stuff.

2. how much is considered BIG in the "lite" version of verity? 100mb, 200mb
of content?
that's about the amount I have.

3. verity would be great for me to display the data more efficient along
with CF tags. I know
CF, I know verity is easy to use, but I know they MUST be slower then
Microsoft Solutions.
(BTW: IS THERE ANY DIFFRENCE?, MS Search =SQL Full text?)

what will be the best way to go if:
I want the search to be as fast as possible YET:
1. I need an easy way to get the results to good-looking HTML format.
2. and maybe an easy way to still incorporate CF tags.

my database design is as follows:
uID = url ID
uLINK = full url location (i.e http://www.cftalk.com/whatis/cf.html)
uCONTENT = txt content I fetched from the site earlier?

do I actually need to save this data in tables or can I just search directly
on the txt files?

And final note: you mentioned Altavista engine - do they offer server search
engines too?

Thanks alot guys!! you'll be the first to run the search queries on my
engine :)

Michael.


- Original Message -
From: "James Maltby" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, May 14, 2001 6:15 PM
Subject: RE: best search


> It really depends on how your content is being displayed - if it's
flat-file
> then Verity is OK - if it's a combination of SQL and Verity then pass your
> query through both database and verity, if it's all sql held then rely on
> sql/verity collections (faster than plain sql requests), however database
> searches will depend on how often the data is to be updated.  A quick rule
> we use for template based sites is verity index the flat file content,
then
> build a "link" database with file names and page titles in which is used
to
> display the url links to the content (your option 2).
>
> However, saying the above the main downfall of Verity is that it takes a
> f*** load of time to index large amount of pages and the collections can
> become corrupt - so it may be worthwhile using something else completely
> different (AltaVista supply a free search engine as do Lycos and Atomz).
> What you have to remember is Verity with CF is a "lite" version and as
such
> is not too hot on larger sites.
>
> As a rule of thumb "use the right tool for the job", don't just use a tool
> because it is there.
>
> J
>
> "The Force is strong in this one..."
> - Darth Vader
>
>
>
>
> -Original Message-
> From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
> Sent: 14 May 2001 17:45
> To: CF-Talk
> Subject: best search
>
>
> what will be the best option for searching on text based content:
>
> 1. insert content into database, search using SQL statments
> 2. insert content into database, search using VERITY queried collections
> 3. VERITY search, collections will search directly on 1000s of txt files
> 4. Microsoft TextSearch Engine
> 5. SQL Full Text Search
>
> Any help, please..
>
>
> -Michael.
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

OT: Access web reference

[Jeremy]

Anyone know of a good web-based reference for Access SQL syntax?

Thanks,

Jeremy


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF function to manipulate a date

[Adkins, Randy]

You can use the actual  functions built
into CF:

Month(myDate)
Year(myDate)

If you need a 4-digit Year:
DateFormat(myDate,"")

HTH


-Original Message-
From: Julie Clegg [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 11:54 AM
To: CF-Talk
Subject: CF function to manipulate a date





Hello,

I have a date field(myDate) in mm format.  I want to compare it to a 
another year field and to another month field.  How do I "string" out myDate

inorder to seperate the mm and  section of it so I can compare each 
"section to a seperate month and year.

Thanks,

Julie
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: best search

[Ray Bujarski]

Does anyone know if verity works on searching a data type of LONG or CLOB 
for an oracle database?  I am building a search engine for an oracle db and 
am new to the Oracle world, where I was recently struck by the fact you 
can't do a search on a LONG Data type?!?  Has anyone built a search engine 
on a oracle database that can offer some help on this topic?

At 12:08 PM 5/14/2001 -0400, you wrote:
>Michael,
>
>In my experience, I have played with Verity and Full Text searching.  It
>really depends on what you are wanting to search and how much flexibility
>you are wanting to provide.
>
>Verity is very good when it comes to things like searching .txt, .htm, .cfm,
>..doc and .pdf files.  I think CF 5's version of verity throws in .ppt (Power
>Point Presentation) and some other file types.  The downside of verity is
>the fact that you have to update the collection any time you modify one file
>or database entry.  When I built a search recently, I incorporated CFX_Spell
>and Verity along with some massaging of the search field.
>
>HTH
>Hatton Humphrey
>
> > -Original Message-
> > From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, May 14, 2001 12:45 PM
> > To: CF-Talk
> > Subject: best search
> >
> >
> > what will be the best option for searching on text based content:
> >
> > 1. insert content into database, search using SQL statements
> > 2. insert content into database, search using VERITY queried collections
> > 3. VERITY search, collections will search directly on 1000s of txt files
> > 4. Microsoft Text Search Engine
> > 5. SQL Full Text Search
> >
> > Any help, please..
> >
> >
> > -Michael.
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: "Harpoon" Release is Final & Available

[Evan Lavidor]

I seem to remember that in some of the early betas for "Harpoon" there was
an actionscript file for reading WDDX packets in Flash.  Did this disappear?
Or did it simply become subsumed into some of the FLA's.  If the latter is
true, could someone point me to the right place to find it?  If it's gone,
is there a reason?

Thanks,

Evan

> -Original Message-
> From: Sam Coe [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 14, 2001 10:29 AM
> To: CF-Talk
> Subject: "Harpoon" Release is Final & Available
>
>
> We are happy to announce the availability of The Macromedia Flash
> Component
> Kit for ColdFusion.  The kit, first announced in November 2000 under the
> code name 'Harpoon', is now available for download from the ColdFusion
> Developers Exchange.
>
> The Macromedia Flash Component Kit for ColdFusion is a resource for
> ColdFusion developers to quickly and easily add Macromedia Flash
> elements to
> their Web applications.  ColdFusion developers can immediately take
> advantage of the design and delivery benefits of Macromedia Flash and
> Macromedia Flash Player without learning a new authoring product. For more
> advanced developers, the Component Kit provides guidelines and
> documentation
> for creating and customizing new Macromedia Flash components for
> ColdFusion
> that can be shared with other developers.
>
> The Component Kit includes 4 prebuilt Macromedia Flash sample components,
> guidelines detailing how to use and customize components and ColdFusion
> custom tags that control the behavior of those components.
>
> The four Macromedia Flash sample components included with the kit are:
>
> *Calendar
> *Calculator
> *Horizontal Menu
> *Cascading Menu (for Microsoft Internet Explorer)
>
> The Component Kit is available for free download from the Allaire
> Developers
> Exchange for the Windows and UNIX platforms.  To access the
> components, type
> "Macromedia Flash" into the Developers Exchange Search window
> (http://devex.allaire.com/developer/gallery/index.cfm) or visit the
> following page to link directly to the kit:
>
> http://www.allaire.com/handlers/index.cfm?ID=20983
>
> The FAQ and license agreements are also available on this page.
>
> Best,
> -Sam
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Access database question: how to structure a link between tw o tables

[Braver, Ben]

Hi Hubert,

If I understand you correctly, you have a many-to-many relationship.

Another example of this is college classes and students --
a student may be enrolled in a number of classes
a class has a number of students enrolled
so you have many-to-many, unlike say an invoice which is one-to-many: one
invoice, many line items.

Access (and other databases) handle many-to-many by having a linking table
in between.
The linking table contains pairs of keys (pointers) to the main data tables.
An example in the college metaphor:
You have a student named Fred, id 123456.
You have a class named Chemistry 101, id CHEM101.
You have a record in the link table where Student_ID = 123456 and Class_ID =
"CHEM101".

HTH.

BTW, look up "many-to-many relationships in Access help.

Ben

-Original Message-
From: Hubert Earl [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 7:56 AM
To: CF-Talk
Subject: Access database question: how to structure a link between two
tables


hi, 

i've created a database to handle an insurance form which deals with the
insurance of money.  it has a number of different tables such as 'cust',
which lists details of customers, 'prem', which lists details of where the
money is stored, and 'safe' which lists details of the safes in which the
money is stored.  

the tables 'safe' and 'prem' relate to each other, in that a premises may
have one or more safes, and one type of safe may be used in more than one
premises.  another way of putting it is that each safe could have 1 or more
premises that match to it & each premises could have 1 or more safes that
match to it, with a maximum number of 3 safes or premises.  what structure
should i use for the link between the two tables?

sincerely,
---
Hubert Earl

ICQ#: 16199853
AIM: hubertfme

My Jamaican Art, Craft & More Online Store:
http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF function to manipulate a date

[John Wilker]

In CF you could use the DateFormat() function and put a mask of just mm or
 for each of the compares. In SQL you could use the Month() and Year()
functions for the respective compares.

Hope that helps

J.

John Wilker
Web Applications Consultant
Macromedia Certified ColdFusion Developer

www.red-omega.com 

"Losing - If at first you don't succeed, failure may be your style."
~despair.com


-Original Message-
From: Julie Clegg [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 8:54 AM
To: CF-Talk
Subject: CF function to manipulate a date





Hello,

I have a date field(myDate) in mm format.  I want to compare it to a
another year field and to another month field.  How do I "string" out myDate
inorder to seperate the mm and  section of it so I can compare each
"section to a seperate month and year.

Thanks,

Julie
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF function to manipulate a date

[James Maltby]

Use something like:




Then use the two vars myMonth and myYear to compare.

I guess

James

-Original Message-
From: Julie Clegg [mailto:[EMAIL PROTECTED]]
Sent: 14 May 2001 16:54
To: CF-Talk
Subject: CF function to manipulate a date





Hello,

I have a date field(myDate) in mm format.  I want to compare it to a 
another year field and to another month field.  How do I "string" out myDate

inorder to seperate the mm and  section of it so I can compare each 
"section to a seperate month and year.

Thanks,

Julie
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: best search

[James Maltby]

It really depends on how your content is being displayed - if it's flat-file
then Verity is OK - if it's a combination of SQL and Verity then pass your
query through both database and verity, if it's all sql held then rely on
sql/verity collections (faster than plain sql requests), however database
searches will depend on how often the data is to be updated.  A quick rule
we use for template based sites is verity index the flat file content, then
build a "link" database with file names and page titles in which is used to
display the url links to the content (your option 2).  

However, saying the above the main downfall of Verity is that it takes a
f*** load of time to index large amount of pages and the collections can
become corrupt - so it may be worthwhile using something else completely
different (AltaVista supply a free search engine as do Lycos and Atomz).
What you have to remember is Verity with CF is a "lite" version and as such
is not too hot on larger sites.

As a rule of thumb "use the right tool for the job", don't just use a tool
because it is there.

J

"The Force is strong in this one..."  
- Darth Vader




-Original Message-
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: 14 May 2001 17:45
To: CF-Talk
Subject: best search


what will be the best option for searching on text based content:

1. insert content into database, search using SQL statments
2. insert content into database, search using VERITY queried collections
3. VERITY search, collections will search directly on 1000s of txt files
4. Microsoft TextSearch Engine
5. SQL Full Text Search

Any help, please..


-Michael.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Access database question: how to structure a link between tw o tables

[Dave Watts]

> i've created a database to handle an insurance form which 
> deals with the insurance of money.  it has a number of 
> different tables such as 'cust', which lists details of 
> customers, 'prem', which lists details of where the money is 
> stored, and 'safe' which lists details of the safes in which 
> the money is stored.  
> 
> the tables 'safe' and 'prem' relate to each other, in that a 
> premises may have one or more safes, and one type of safe may 
> be used in more than one premises.  another way of putting it 
> is that each safe could have 1 or more premises that match to 
> it & each premises could have 1 or more safes that match to 
> it, with a maximum number of 3 safes or premises.  what 
> structure should i use for the link between the two tables?

You have what is called a "many-to-many" relationship. There's no way to
directly represent a many-to-many relationship in a relational database, so
you'll need to create a table for this purpose. This table, called a linking
table or an intersection table, should contain the primary key columns from
each of the other two tables, and should be related to each of those tables
using a one-to-many relationship; one record from each table can have many
matches within the linking table. As a primary key, the linking table should
use the two foreign keys together - a composite primary key.

In Access, you can create these relationships using the Relationship window,
once you've created the linking table.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF function to manipulate a date

[Larry Juncker]

YOu could use




Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.


-Original Message-
From: Julie Clegg [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 10:54 AM
To: CF-Talk
Subject: CF function to manipulate a date





Hello,

I have a date field(myDate) in mm format.  I want to compare it to a
another year field and to another month field.  How do I "string" out myDate
inorder to seperate the mm and  section of it so I can compare each
"section to a seperate month and year.

Thanks,

Julie
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: best search

[Paul Hastings]

* Team Allaire *
> 5. SQL Full Text Search

buys you off cf processing, cached queries, more languages than
verity, ORDER BYs, JOINs, and beer when you need it ;-).


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: best search

[C. Hatton Humphrey]

Michael,

In my experience, I have played with Verity and Full Text searching.  It
really depends on what you are wanting to search and how much flexibility
you are wanting to provide.

Verity is very good when it comes to things like searching .txt, .htm, .cfm,
..doc and .pdf files.  I think CF 5's version of verity throws in .ppt (Power
Point Presentation) and some other file types.  The downside of verity is
the fact that you have to update the collection any time you modify one file
or database entry.  When I built a search recently, I incorporated CFX_Spell
and Verity along with some massaging of the search field.

HTH
Hatton Humphrey

> -Original Message-
> From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 14, 2001 12:45 PM
> To: CF-Talk
> Subject: best search
>
>
> what will be the best option for searching on text based content:
>
> 1. insert content into database, search using SQL statements
> 2. insert content into database, search using VERITY queried collections
> 3. VERITY search, collections will search directly on 1000s of txt files
> 4. Microsoft Text Search Engine
> 5. SQL Full Text Search
>
> Any help, please..
>
>
> -Michael.
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Access database question: how to structure a link between two tables

[Hubert Earl]

hi, 

i've created a database to handle an insurance form which deals with the insurance of 
money.  it has a number of different tables such as 'cust', which lists details of 
customers, 'prem', which lists details of where the money is stored, and 'safe' which 
lists details of the safes in which the money is stored.  

the tables 'safe' and 'prem' relate to each other, in that a premises may have one or 
more safes, and one type of safe may be used in more than one premises.  another way 
of putting it is that each safe could have 1 or more premises that match to it & each 
premises could have 1 or more safes that match to it, with a maximum number of 3 safes 
or premises.  what structure should i use for the link between the two tables?

sincerely,
---
Hubert Earl

ICQ#: 16199853
AIM: hubertfme

My Jamaican Art, Craft & More Online Store: 
http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CF function to manipulate a date

[Julie Clegg]

Hello,

I have a date field(myDate) in mm format.  I want to compare it to a 
another year field and to another month field.  How do I "string" out myDate 
inorder to seperate the mm and  section of it so I can compare each 
"section to a seperate month and year.

Thanks,

Julie
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

[Re:] RE: ] RE: oracle LOB query problem

[FARRAH NG]

dave,
thank you. I have enable the long text retrieval setting but i am
still getting the SQL error " Data Access Error Unknown Data Access 
Error. " from the CF server when it runs the CF query in my action 
page.

My query is very simple, as follow"
select Cust_Info from company where Cust_id = 10;

Cust_info is defined as a CLOB in the oracle table Company.


thanks


On Mon, 14 May 2001 10:12:02 -0400
Dave Watts wrote:

>> I read this article and it is talking about CF settings button in 
>> the DSN setting screen. I logged onto my CF server administrator 
and
>> could not find the DSN setting screen.  Anyone knows where and how
>> to do the setting ?
>
>The "DSN setting" screen is what you see when you edit any 
one of your data
>sources in the CF Administrator. For example, if it's an ODBC 
data source,
>you select "ODBC" from the left menu bar, then you click on 
the appropriate
>data source. You'll then see the "DSN setting" screen for that 
data source.
>At the bottom, you'll see a button labeled "CF Settings".
>
>Dave Watts, CTO, Fig Leaf Software
>http://www.figleaf.com/
>voice: (202) 797-5496
>fax: (202) 797-5444
>
>



--
Global Internet phone calls, voicemail, fax, e-mail and instant messaging.
Sign-up today at http://www.hotvoice.com

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

best search

[Michael Lugassy]

what will be the best option for searching on text based content:

1. insert content into database, search using SQL statments
2. insert content into database, search using VERITY queried collections
3. VERITY search, collections will search directly on 1000s of txt files
4. Microsoft TextSearch Engine
5. SQL Full Text Search

Any help, please..


-Michael.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

ftp to novell

[Joshua Tipton]

I am trying to ftp to a novell server and am not having the best of luck.  I
can get the currect directroy to return sys: which is right.  When I try to
listdir of a direcotyr called crsapps I get nothing.  I have tried /crsapps,
crsapps. crsapps/*.* and get nothing.  Is there a trick to novell?

Joshua Tipton







#cfftp.returnvalue#









~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF_DOWNLOAD -- need fix ASAP

[Dave Watts]

> > force a download with the header info. maybe dave can post 
> > the URL again or you can email him and ask.
> 
> Really ? IE has a bug in its header reading bits :-)
> 
> http://support.microsoft.com/support/kb/articles/Q279/6/67.ASP
> ?LN=EN-US&SD=gn&FR=0&qry=force%20download&rnk=8&src=DHCS_MSPSS
> _gn_SRCH&SPR=IEP
> 
> Dave, if you could post the URL to your code, that would be great!

I think the problem you mention is limited to IE 5.5. In any case, my code
uses "inline" vs "attachment", which seems to work with IE 5.5, and still
forces a download for file types for which there isn't a registered MIME
handler. The URL is:

http://www.figleaf.com/demo/mimetest/

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CF on unix restarts

[Alex]

I have CF4.5 with updates running on solaris and it restarts about every 10
minutes. 
I have read this problem before but have not seen a resolution. Anyone here
know how to fix this?
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Verify Address

[Kevin Mansel]

USPS Validator in the DEV Exchange

kev

~
Kevin Mansel
Web Developer
Fox Communications
[EMAIL PROTECTED]
DL : 425-649-1321
C : 425-346-7221



-Original Message-
From: Nick McClure [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 7:53 AM
To: CF-Talk
Subject: Verify Address


Does anybody have a good block of code in CF, SQL, or even ASP that will 
verify an address against the post office data?

I have the Post Office Data.

Any help would be greatly appreciated. I am open to commercial products as
well
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: [Re: [CF-Talk Archiver]]

[Alex]

Oh. I never noticed the stuff on the bottom of these emails before.
Thanks.

"Todd Ashworth" <[EMAIL PROTECTED]> wrote:
Yes .. observe the bottom of every E-mail ;)

| Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/

I don't like the format all that much; maybe this new one is better?  :)

Todd

- Original Message -
From: "Alex" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, May 14, 2001 9:43 AM
Subject: Re: [CF-Talk Archiver]


| Doesn't CF-Talk already archive the emails?
|
| Peter Tilbrook <[EMAIL PROTECTED]> wrote:
| I am currently putting the finishing touches on a small CF application
| that reads in email messages, in this case CF-Talk email, stores them in a
| database and makes the database searchable (via Verity).
|
| The final application will be able to do the same with any email address
| but hey CF-Talk deserves posterity so I wrote it for that purpose.
|
| The finished version will be "postcardware", ie: send me a postcard and I
| will send you the full code via email.
|
| Cheers!
|
| PT
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Verify Address

[Nick McClure]

Does anybody have a good block of code in CF, SQL, or even ASP that will 
verify an address against the post office data?

I have the Post Office Data.

Any help would be greatly appreciated. I am open to commercial products as well


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF_DOWNLOAD -- need fix ASAP

[Thomas Chiverton]

> force a download with the header info. maybe dave can post 
> the URL again or
> you can email him and ask.

Really ? IE has a bug in its header reading bits :-)

http://support.microsoft.com/support/kb/articles/Q279/6/67.ASP?LN=EN-US&SD=g
n&FR=0&qry=force%20download&rnk=8&src=DHCS_MSPSS_gn_SRCH&SPR=IEP

Dave, if you could post the URL to your code, that would be great !

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Forced logout

[Bill King]

I bet you could spawn a new window that calls template to log them out and
closes onload.

- BILL -
- Original Message -
From: "Jim McAtee" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, May 13, 2001 3:48 PM
Subject: Re: Forced logout


> You can't.  Well, maybe you could be annoying to the point that they'd
want
> to log out, but in reality you cannot MAKE them log out.  The way to log
> somebody out is to use a inactivity timeout for their session and when
> they've been inactive for longer than this time, you consider them logged
> out.  If you use CF session management to handle the login, then this is
> pretty much taken care of.  Just set the specific time period in your
> CFAPPLICATION tag's SESSIONTIMEOUT attribute, or else use the default time
> period set at the CF server level.
>
> Jim
>
>
> - Original Message -
> From: "sebastian palmigiani" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Sunday, May 13, 2001 6:31 AM
> Subject: Forced logout
>
>
> >
> > How can I use javascript to make a member logout if they go to a
different
> > web site? Is this possible to do with javascript.
> >
> > Sebastian
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists