Re: Listing Items That Expire Today? Help!

2000-05-26 Thread Jim McAtee

Why are you testing the date against two different date/time values in the
where clause?  Try it with just a single test, with < instead of <= and
use the function CreateODBCDate() instead of CreateODBCDateTime().  This
should find all records with an ExpiryDate before today.

WHERE Coupons.ExpiryDate < #CreateODBCDate(Now())# AND
  ...

Jim


-Original Message-
From: Marco Gil <[EMAIL PROTECTED]>
To: ColdFusion <[EMAIL PROTECTED]>
Date: Friday, May 26, 2000 10:33 PM
Subject: Listing Items That Expire Today? Help!


>I'm trying to get it so that one of my web pages lists only items that
are
>going to expire today.  Here's my query:
>
>
>
>SELECT EntryDate, Items.RetailerID, Items.CategoryID, Items.ListingID,
>CouponText, CouponURL, CouponDesc, Retailer, RetailerIMG, Category,
Listing,
>Items.ItemID
>
>FROM Items, Retailers, Categories, Listings, Coupons
>WHERE Coupons.ExpiryDate <= #CreateODBCDateTime(Now())# AND
>  Coupons.ExpiryDate >= #CreateODBCDateTime(Now())# - 1 AND
>Items.RetailerID = Retailers.RetailerID AND
>Items.CategoryID = Categories.CategoryID AND
>Items.ListingID = Listings.ListingID
> ORDER BY Retailer
>
>
>
>However, it lists every single item.  Can anyone please help me with
this?
>Thanks so much!
>
>Marco

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Listing Items That Expire Today? Help!

2000-05-26 Thread Shane Witbeck

I believe there is a datecompare cf tag that may help also

Sincerely,

Shane Witbeck
Webmaster
[EMAIL PROTECTED]
www.digitalsanctum.com




-Original Message-
From: Marco Gil [mailto:[EMAIL PROTECTED]]
Sent: Saturday, May 27, 2000 12:29 AM
To: ColdFusion
Subject: Listing Items That Expire Today? Help!


I'm trying to get it so that one of my web pages lists only items that are
going to expire today.  Here's my query:



SELECT EntryDate, Items.RetailerID, Items.CategoryID, Items.ListingID,
CouponText, CouponURL, CouponDesc, Retailer, RetailerIMG, Category, Listing,
Items.ItemID

FROM Items, Retailers, Categories, Listings, Coupons
WHERE Coupons.ExpiryDate <= #CreateODBCDateTime(Now())# AND
  Coupons.ExpiryDate >= #CreateODBCDateTime(Now())# - 1 AND
Items.RetailerID = Retailers.RetailerID AND
Items.CategoryID = Categories.CategoryID AND
Items.ListingID = Listings.ListingID
 ORDER BY Retailer



However, it lists every single item.  Can anyone please help me with this?
Thanks so much!

Marco



--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Listing Items That Expire Today? Help!

2000-05-26 Thread Jennifer Larkin

Marco Gil wrote:
> 
> I'm trying to get it so that one of my web pages lists only items that are
> going to expire today.  Here's my query:
> 
> 
> 
> SELECT EntryDate, Items.RetailerID, Items.CategoryID, Items.ListingID,
> CouponText, CouponURL, CouponDesc, Retailer, RetailerIMG, Category, Listing,
> Items.ItemID
> 
> FROM Items, Retailers, Categories, Listings, Coupons
> WHERE Coupons.ExpiryDate <= #CreateODBCDateTime(Now())# AND
>   Coupons.ExpiryDate >= #CreateODBCDateTime(Now())# - 1 AND
> Items.RetailerID = Retailers.RetailerID AND
> Items.CategoryID = Categories.CategoryID AND
> Items.ListingID = Listings.ListingID
>  ORDER BY Retailer
> 
> 
> 
> However, it lists every single item.  Can anyone please help me with this?
> Thanks so much!

This is what's causing your problem:

Coupons.ExpiryDate >= #CreateODBCDateTime(Now())# - 1

I think that what you want to do is subtract one day from Now(). Set up
a variable before the SQL statement. Set it equal to Now(), then use the
DateAdd function to subtract a day from it. Then put
#CreateODBCDateTime(yourvariable)# in the SQL statement. You may be able
to do this more efficiently by using Evaluate within your SQL statement.
I'm not sure how to do this because I don't have a language reference
with me here.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Listing Items That Expire Today? Help!

2000-05-26 Thread Marco Gil

I'm trying to get it so that one of my web pages lists only items that are
going to expire today.  Here's my query:



SELECT EntryDate, Items.RetailerID, Items.CategoryID, Items.ListingID,
CouponText, CouponURL, CouponDesc, Retailer, RetailerIMG, Category, Listing,
Items.ItemID

FROM Items, Retailers, Categories, Listings, Coupons
WHERE Coupons.ExpiryDate <= #CreateODBCDateTime(Now())# AND
  Coupons.ExpiryDate >= #CreateODBCDateTime(Now())# - 1 AND
Items.RetailerID = Retailers.RetailerID AND
Items.CategoryID = Categories.CategoryID AND
Items.ListingID = Listings.ListingID
 ORDER BY Retailer



However, it lists every single item.  Can anyone please help me with this?
Thanks so much!

Marco


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Replacing crlf with

2000-05-26 Thread Jason Egan




Or something like that


Jason Egan
Konnections, INC.

-Original Message-
From: Jay Sudowski [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 26, 2000 5:36 PM
To: [EMAIL PROTECTED]
Subject: Replacing crlf with 

This is a multi-part message in MIME format.

--=_NextPart_000_01E6_01BFC738.EB595720
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi -

I need to replace the crlf characters with the  tag so that line =
breaks people enter while editing database content show up when they are =
displayed.  I found a custom tag that will do this, but I'd like to =
avoid calling it multiple times on the same page?

Doing this should be possible with the replace function (or so I think), =
but I'm not sure how to go about it.  Any ideas?

Thanks,

Jay

--=_NextPart_000_01E6_01BFC738.EB595720
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








Hi -
 
I need to replace the crlf characters =
with the=20

tag so that line breaks people enter while editing database = content=20 show up when they are displayed.  I found a custom tag that will do = this,=20 but I'd like to avoid calling it multiple times on the same = page?   Doing this should be possible with the = replace=20 function (or so I think), but I'm not sure how to go about it.  Any = ideas?   Thanks,   Jay --=_NextPart_000_01E6_01BFC738.EB595720-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Source Control

2000-05-26 Thread Nick Slay

--=_428728268==_.ALT
Content-Type: text/plain; charset="us-ascii"; format=flowed

I use SourceSafe all the time with CF Studio 4.1.   Everything seems to 
work very well, I haven't come across any problems.. UNTIL... I 
installed Studio 4.5.  It had terrible problems with source control... you 
could check files out, and back in again, but Studio wasn't showing you 
that you'd checked files back in... I ended up rolling back to 4.1, and 
everythings been fine.



At 11:36 26/05/00 -0700, you wrote:
>This is a multi-part message in MIME format.
>
>--=_NextPart_000_001F_01BFC706.9A44E200
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: 7bit
>
>Hello Everyone,
>
>I recently posted a question about Microsoft sourcesafe and did not get an
>answer.  I am taking this to mean not many people use MS SourceSafe.  What
>kind of source control (networked) does everyone with CF use?
>
>Please any ideas and suggestions are greatly appreciated.
>
>Thanks
>Elizabeth
>
>--=_NextPart_000_001F_01BFC706.9A44E200
>Content-Type: text/html;
> charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
>xmlns:w=3D"urn:schemas-microsoft-com:office:word" = 
>xmlns=3D"http://www.w3.org/TR/REC-html40">
>
>Hello Everyone,
>
>
>
>I recently posted a question about Microsoft sourcesafe and did = not get 
>an answer.  I am taking = this to mean not many people use MS 
>SourceSafe.What kind of source control (networked) does everyone with CF = 
>use?  =
>
>
>
>Please any ideas and suggestions are greatly = appreciated.
>
>
>
>Thanks
>
>Elizabeth
>
>--=_NextPart_000_001F_01BFC706.9A44E200--
>
>--
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or 
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in 
>the body.

--=_428728268==_.ALT
Content-Type: text/html; charset="us-ascii"


I use SourceSafe all the time with CF Studio 4.1.   Everything
seems to work very well, I haven't come across any problems..
UNTIL... I installed Studio 4.5.  It had terrible problems with
source control... you could check files out, and back in again, but
Studio wasn't showing you that you'd checked files back in... I ended up
rolling back to 4.1, and everythings been fine.



At 11:36 26/05/00 -0700, you wrote:
This is a multi-part message in MIME
format.

--=_NextPart_000_001F_01BFC706.9A44E200
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hello Everyone,

I recently posted a question about Microsoft sourcesafe and did not get
an
answer.  I am taking this to mean not many people use MS
SourceSafe.  What
kind of source control (networked) does everyone with CF use?

Please any ideas and suggestions are greatly appreciated.

Thanks
Elizabeth

--=_NextPart_000_001F_01BFC706.9A44E200
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40" 
eudora="autourl">http://www.w3.org/TR/REC-html40">


Hello Everyone,

 

I recently posted a question about Microsoft sourcesafe and did = not get
an answer.  I am taking = this to mean not many people use MS
SourceSafe.What kind of source control (networked) does everyone with CF
= use?  = 

 

Please any ideas and suggestions are greatly = appreciated.

 

Thanks

Elizabeth

--=_NextPart_000_001F_01BFC706.9A44E200--

--
Archives:
http://www.egroups.com/list/cf-talk" 
eudora="autourl">http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk" 
eudora="autourl">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. 


--=_428728268==_.ALT--

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: RE: verity search problem

2000-05-26 Thread [EMAIL PROTECTED]

Thank you very much Eron,

I will look at these articles tonight and try to figure out the
problem. If I coudn't I will send the original code to you for help
tomorrow. (Sorry I don't mean asking your help during the holiday
weekend.You can get back to me nextweek)

Sima






At Fri, 26 May 2000 16:59:45 -0400, you wrote:
>Sima,
>
>What happens when you manually type in a search word that you know
must
>exist in your collection?
>
>Can you post the rest of the code you're using?
>
>Eron
>
>PS-  There have been alot of helpful posts regarding verity
recently.  I
>don't have any of others handy, but here's some information I posted
a few
>weeks ago that may help you:
>
>
>1)  The verity search engine built into CF is somewhat stripped down
from
>the full version.  Although, as I have learned from posts on this
forum, the
>version that comes with Cold Fusion is full of "undocumented
features" that
>coincidently turn out to be features in the full version :-O
>
>2)  To say the least, Verity can be weird.
>
>I've definitely had my share of problems with Verity.  Probably the
worst
>one of all is that it doesn't tell you when there's an error...it
just
>doesn't work.  Here are a couple of other points from my
presentation that
>may help (If you do go looking for the entire presentation, its
under PAST
>MEETINGS > February > Eron Cohen):
>
>
>--Verity searches can be CaSe sensitive.  I typically force keyword
searches
>into lower case.
>
>--When using CFINDEX you must be sure that all the fields you
include in the
>BODY= parameters are valid fields from your query.  Often you won’t
get an
>error message and your index won’t work!
>
>And possibly the biggest GOTCHA:
>
>--**ALWAYS make sure your KEY= field is unique for EVERY
record.  If
>you don’t do this, as soon as verity encounters a duplicate key it
will stop
>indexing there (and it won’t give you any error
messages!)***
>
>
>3) I have done quite a bit of indexing of large amounts of data.  I
am not
>exactly sure what the limit is, but in fact, there IS a limit to the
size of
>your collections!  This is documented in Allaire’s KB (article
#11934).
>
>This is something you can get around because in CFSEARCH you can
name more
>than 1 collection to search at the same time, so you can always
break down
>what you want to search into separate collections.
>
>I recently gave a presentation about Verity searches at the Maryland
Cold
>Fusion user's group.  You can download my PowerPoint slides there:
>
>http://www.cfug-md.org/meetings.cfm (February 8th 2000)
>
>-Original Message-
>From: Sima Lee [mailto:[EMAIL PROTECTED]]
>Sent: Friday, May 26, 2000 4:48 PM
>To: [EMAIL PROTECTED]
>Subject: Re: verity search problem
>
>
>Thank you for such a quick response. But I tried everything like the
>following and it doesn't work:
>
>CFSEARCH COLLECTION="test"
>NAME="GetItems"
>CRITERIA="#Form.criteria#">
>
>or
>NAME="GetItems"
>CRITERIA=Form.criteria>
>or
>
>NAME="GetItems"
>CRITERIA="Form.criteria">
>They all return "0" record.
>
>Sima
>
>
>
>
>- Original Message -
>From: Eron Cohen <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Friday, May 26, 2000 3:30 PM
>Subject: RE: verity search problem
>
>
>> One thing that could be wrong: I believe you actually NEED # signs
for
>your
>> Criteria= statement...
>> What happens if you use:
>>
>> >   NAME="GetItems"
>>   CRITERIA="#Form.criteria#">
>>
>> HTH,
>>
>> Eron
>>
>> -Original Message-
>> From: Sima Lee [mailto:[EMAIL PROTECTED]]
>> Sent: Friday, May 26, 2000 4:10 PM
>> To: [EMAIL PROTECTED]
>> Subject: verity search problem
>>
>>
>> This is a multi-part message in MIME format.
>>
>> --=_NextPart_000_0041_01BFC724.71016490
>> Content-Type: text/plain;
>> charset="iso-8859-1"
>> Content-Transfer-Encoding: quoted-printable
>>
>> Hi All,
>>
>> I am new to ColdFusion and try to use verity search . This is the =
>> problem I got:
>> I created a collection and indexed it . It says there is 8 records
in it =
>> , which is true. But when I use the cfsearch tag to search , it
always =
>> gives me zero records no matter what I type in as a criteria. But
if I =
>> change   Criteria=3D"" in the search tag it gives me all the 8
records. =
>> For example:
>>
>> >   NAME=3D"GetItems"=20
>>   CRITERIA=3D"Form.criteria">
>> Will return 0 record.
>>
>> but
>> >   NAME=3D"GetItems"=20
>>   CRITERIA=3D"">
>>
>> will return all the 8 records.
>>
>> Could anybody tell me why the criteria does not work? Thanks in
advance.
>>
>>
>> --=_NextPart_000_0041_01BFC724.71016490
>> Content-Type: text/html;
>> charset="iso-8859-1"
>> Content-Transfer-Encoding: quoted-printable
>>
>> 
>> 
>> > http-equiv=3DContent-Type>
>> 
>> 
>> 
>> 
>> Hi All,
>>  
>> I am new to ColdFusion and try to
use =
>> verity search=20
>> . This is the problem I got:
>> I created a collection and
indexed it . =
>> It says=20
>> there is 8 records in it , which is true. But when I use

RE: Help

2000-05-26 Thread Philip J. Kaplan

http://www.houseoffusion.com/hof/body/asp.cfm

-Original Message-
From: Bridget Corkery [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 26, 2000 5:20 PM
To: [EMAIL PROTECTED]
Subject: Help

I am writing to the cf supporters forum because I need your help and your
wisdom in convincing my company that cold fusion is the leading application
developer and has more functionality than ASP.
Some of the people who work at my company are complete advocates of
Microsoft products and believe that ASP has the same capabilities that Cold
Fusion has.  I have never worked with ASP before and need some backup to
make my case for Cold Fusion.
For all of you supporters, please help me make my case and send me
information to convince my company that Cold Fusion is the answer to our
website
Thanks and have a great weekend,
Bridget

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Site Design Question

2000-05-26 Thread Eric Dawson

I did notice the cfswitch and thought it was a good idea. and,  unbeknownst 
to me ... a performace gain too! :)

From: "Sean Renet" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: <[EMAIL PROTECTED]>
Subject: Re: Site Design Question
Date: Fri, 26 May 2000 12:04:17 -0700

IF's are always going to be slower than switch's (or so I have been told).
And the docs use a switch so I figure I should as well :-P



Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Wierd error

2000-05-26 Thread James Sleeman

Replying to myself here,
  the error appears to be completly re-producable here, but it is fixable, it seems (I 
found through experimentation) the problem is with haveing the thrown type and the 
catched type (both BORKY in the example) the same - CF bawlks at this, if I catch 
BORKY and throw BORKY.GOOPY it will catch & work fine, if I then try catching 
BORKY.GOOPY instead it will fail again.  I can only think that this must be some bug 
in CF.  Can I assume that not many people use custom exception types ?

On Mon, 22 May 2000 17:15:07 +1200, "James Sleeman" <[EMAIL PROTECTED]> wrote:
>
> The following code is producing a CF error, and some very strange output
> (not what I would expect AT ALL, where the hell does "Hello .. 11" come from
> ?!?!?! ), any ideas why anyone ?
>
> The code
> -- CUT HERE --
> 
>
> 
> 
>  Untitled
> 
>
> 
> 
>  Hello .. #x#
> 
>
> 
>  Hoopy .. #x#
> 
>
>  Hoopy !
> 
> 
>
> 
>   Hey error boy, what's the error today ?
>   #CFCATCH.Message##CFCATCH.Detail#
> 
> 
>  La De Da
> 
> 
> --
>
> The output
> - CUT HERE ---
> Hello .. 1
> Hello .. 2
> Hello .. 3
> Hello .. 4
> Hello .. 5
> Hello .. 6
> Hoopy .. 1
> Hoopy .. 2
> Hoopy .. 3
> Hoopy .. 4
> Hoopy .. 5
> Hoopy .. 6
> Hoopy .. 7
> Hoopy .. 8
> Hoopy .. 9
> Hoopy .. 10
> Hoopy !
> Hello .. 11
> ---
>
>
> The error
> -
> Error Diagnostic Information
> unknown exception condition
>
> unknown error while executing a tag.
>
>
> Date/Time: 05/22/00 16:52:02
> Browser: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)
> Remote Address: 10.10.10.105
> -
>
>
> ---
> James Sleeman,
>   E-Commerce, Database, Programmer
>   Innovative Media Ltd
>
>
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Here is the NAVIGATION code I use that I mentioned in my response to Re: Site Dedsign Question (Try 2)

2000-05-26 Thread Sean Renet

I  use tags for my navigation.  These tags have nested tags that use
CFASSOCIATE to build a structure for navigation.  I completely hate to type
and can't stand having web designers
(or whatever the pc title for them is these days) in my code.  So I give
them a browser interface to add images with links and such to a table in the
databse.  You could also add a couple more tables and to catagorize the
navigation for subnav, but for this example I left it fairly simple.  This
also helps if you have some navigation that is global and some that is local
and individual navigation can be "shut off" without dealing with the HTML.

For example: (BTW I am completely aware that the query should be on its own
page and included in the local index.cfm, but give me a break this is a 5
minute response)

<---dsp_Nav.cfm--->

SELECT  url_link, image, text, textcolor
FROM dbo.NAVIGATION
WHERE ARCHIVE_BOL = 0




  
   

   

   
  



<---act_navbar.cfm--->



 
 
 

 

 
  
 
  






 
  
   
  
   #thistag.navattributes[
i].text#
  
 







<---act_NavItem.cfm--->













--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: OT - COM object -- create a windows file shortcut

2000-05-26 Thread Mark Warrick

I'd like to point out the fact that the specs were not clear on this offer.

The first question that comes to my mind is "on whose desktop should this
shortcut end up?  the server or the client"

The solution differs greatly depending upon the answer.

---mark


-
Mark Warrick
(714) 939-6431
The Sistonia Corporation
[EMAIL PROTECTED]
http://www.sistonia.com

> -Original Message-
> From: Cary Gordon [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 26, 2000 2:44 PM
> To: Russel Madere
> Cc: [EMAIL PROTECTED]
> Subject: Re: OT - COM object -- create a windows file shortcut
>
>
> You can do this in about five minutes using Windows Scripting Host.  Just
> call the script with cfexecute.  Since I don't have five minutes, I'll
> settle for $250.
>
> Cary
>
> At 04:13 PM 5/26/00 -0500, you wrote:
> >I'm sorry for spamming all of the lists if you get more than one.
> >
> >Hello,
> >
> >We are willing to pay up to $500 to anyone who will create a cfm
> custom tag
> >and/or COM object to make a windows shortcut to a specified
> filename. This
> >is possible in VB, but I don't have the technical expertise to
> pull it off.
> >Our current leads are:
> >
> >http://msdn.microsoft.com/library/psdk/shellcc/shell/Shortcut.htm
> >
> >Please email me directly.
> >
> >Thanks,
> >Russel
>
>
> Cary Gordon
> The Cherry Hill Company
>
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
> _talk or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Replacing crlf with

2000-05-26 Thread David Gassner

", "all")>

David

> -Original Message-
> From: Jay Sudowski [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 26, 2000 2:36 PM
> To: [EMAIL PROTECTED]
> Subject: Replacing crlf with 
>
>
> This is a multi-part message in MIME format.
>
> --=_NextPart_000_01E6_01BFC738.EB595720
> Content-Type: text/plain;
>   charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> Hi -
>
> I need to replace the crlf characters with the  tag so that line =
> breaks people enter while editing database content show up when they are =
> displayed.  I found a custom tag that will do this, but I'd like to =
> avoid calling it multiple times on the same page?
>
> Doing this should be possible with the replace function (or so I think), =
> but I'm not sure how to go about it.  Any ideas?
>
> Thanks,
>
> Jay
>
> --=_NextPart_000_01E6_01BFC738.EB595720
> Content-Type: text/html;
>   charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> 
> 
>  http-equiv=3DContent-Type>
> 
> 
> 
> 
> Hi -
>  
> I need to replace the crlf characters =
> with the=20
> 
tag so that line breaks people enter while editing database = > content=20 > show up when they are displayed.  I found a custom tag that will do = > this,=20 > but I'd like to avoid calling it multiple times on the same = > page? >   > Doing this should be possible with the = > replace=20 > function (or so I think), but I'm not sure how to go about it.  Any = > > ideas? >   > Thanks, >   > Jay > > --=_NextPart_000_01E6_01BFC738.EB595720-- > > -- > > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: OT - COM object -- create a windows file shortcut

2000-05-26 Thread Cary Gordon

You can do this in about five minutes using Windows Scripting Host.  Just 
call the script with cfexecute.  Since I don't have five minutes, I'll 
settle for $250.

Cary

At 04:13 PM 5/26/00 -0500, you wrote:
>I'm sorry for spamming all of the lists if you get more than one.
>
>Hello,
>
>We are willing to pay up to $500 to anyone who will create a cfm custom tag
>and/or COM object to make a windows shortcut to a specified filename. This
>is possible in VB, but I don't have the technical expertise to pull it off.
>Our current leads are:
>
>http://msdn.microsoft.com/library/psdk/shellcc/shell/Shortcut.htm
>
>Please email me directly.
>
>Thanks,
>Russel


Cary Gordon
The Cherry Hill Company

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: benefits of Enterprise without ClusterCats?

2000-05-26 Thread Ryan Hill

Since I've been down this road recently, I thought I would throw this out
here.  Just some notes from the field, IMHO:

1.) Don't even attempt to use Cluster Cats in a production environment.
a.) Poor performance under all load conditions.
b.) Advanced documentation or reference?  What?  Where?
c.) Poor support from Allaire - they don't even reccomend using it.

We were going to try to run it for a new client but load testing in our
staging environment completely destroyed any benefits we might have
obtained.  If you really need this functionality, invest in a hardware
solution - yeah they're expensive, I know - but they are DEFINATELY worth
it.

Don't even get me started on Advanced Security and Spectra
whooe!

Regards,

Ryan Hill, MCSE
Director, Systems Integration
Market Matrix, Inc. - http://www.marketmatrix.com 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 25, 2000 3:29 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: benefits of Enterprise without ClusterCats?


> I'm moving to a clustered server using NT/IIS/SQL, but I plan on using
> Local Director, and NOT ClusterCats.  In this case, is there
> any benefit to running Enterprise over Professional?
>
> I'm assume that the following features of Enterprise are tied to using
> ClusterCats, but I couldn't really tell:
>
> * Service-Level Failover
> * Dynamic Load Balancing
> * Automatic Server Failover

You're correct. All of those features are provided by ClusterCats. You may
find it useful to use ClusterCats in conjunction with LocalDirector, though.

In addition, Enterprise provides native database drivers - worth it if
you're using Oracle - and the Advanced Security engine, which is powerful
(although very obtuse) and required for Spectra.

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


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Replacing crlf with

2000-05-26 Thread Jay Sudowski

This is a multi-part message in MIME format.

--=_NextPart_000_01E6_01BFC738.EB595720
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi -

I need to replace the crlf characters with the  tag so that line =
breaks people enter while editing database content show up when they are =
displayed.  I found a custom tag that will do this, but I'd like to =
avoid calling it multiple times on the same page?

Doing this should be possible with the replace function (or so I think), =
but I'm not sure how to go about it.  Any ideas?

Thanks,

Jay

--=_NextPart_000_01E6_01BFC738.EB595720
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








Hi -
 
I need to replace the crlf characters =
with the=20

tag so that line breaks people enter while editing database = content=20 show up when they are displayed.  I found a custom tag that will do = this,=20 but I'd like to avoid calling it multiple times on the same = page?   Doing this should be possible with the = replace=20 function (or so I think), but I'm not sure how to go about it.  Any = ideas?   Thanks,   Jay --=_NextPart_000_01E6_01BFC738.EB595720-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

SQL query problem

2000-05-26 Thread John Fix 3rd

I'm trying to do a query where I have data in two different formats...

SELECT Customer, TransNumber, Date
FROM test.Header
Where Customer = "#session.customer#"

The problem I have is that the value of #session.customer# contains the
customer number (260) with no leading characters while the test.header
Customer field comes back with leading 000 characters (000260). If I hard
code it as "WHERE Customer = "000260" it works. My guess is that I need to
do something to pad session.customer with leading zeros up the the length of
the Customer field (which is 6 characters).  I can't find a manipulation
function that does this... any ideas?

Thanks!

John

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Bug report update 5/25/2000

2000-05-26 Thread KChapman

Is this possible?

--K


Katrina Chapman
Consultant
Ameriquest Mortgage
- Forwarded by Katrina Chapman/CORP/AMQ on 05/26/00 02:19 PM -
   
  
Tamara Kaplan  
  
 To: Katrina Chapman/CORP/AMQ@AMQ  
  
05/26/00 01:17   cc:   
  
PM   Subject: Re: Bug report update 
5/25/2000(Document link: Katrina Chapman)
   
  
   
  



Although I have never done this myself, this seems to work:

You specify the timeout like normal with something like this:



And then you specifically set cookie values.  By specifically naming these
variables, they will die when the browser is closed.




Please give it a try and see if it works.  Otherwise, I agree with you that
they are in opposition with each other, and no, we wouldn't want to rely on
JavaScript to do this.

Thanks.
Tamara



   
  
Katrina
  
Chapman  To: Tamara Kaplan/CORP/AMQ@AMQ
  
 cc:   
  
05/26/00 11:53   Subject: Re: Bug report update 
5/25/2000(Document link: Tamara Kaplan)  
AM 
  
   
  
   
  



#488 "Return to Broker Login results in lost data" has to do with the
session timeout.  I remember Kimberly saying that we would address this
issue when we have the users test the site.  My 2 cents: it's too short.  I
would suggest 30 minutes and then see if we need it bumped up during the
pilot.

New/Re-open: User info is not logged out upon closing the browser.  Tested
v.4.4.

These two are in direct opposition to each other.  You can't have a timeout
of 30 minutes and then be logged out as soon as the browser closes.  At
least not the way that we are currently maintianing state.  We're using
cookies.

The only way you could do it would be with a javascript:onClose event, but
that's unreliable.

--K


Katrina Chapman
Consultant
Ameriquest Mortgage





--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Help

2000-05-26 Thread Bridget Corkery

I am writing to the cf supporters forum because I need your help and your
wisdom in convincing my company that cold fusion is the leading application
developer and has more functionality than ASP.
Some of the people who work at my company are complete advocates of
Microsoft products and believe that ASP has the same capabilities that Cold
Fusion has.  I have never worked with ASP before and need some backup to
make my case for Cold Fusion.  
For all of you supporters, please help me make my case and send me
information to convince my company that Cold Fusion is the answer to our
website
Thanks and have a great weekend,
Bridget
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Self join?

2000-05-26 Thread John Allred

Hi all,

I have a CFFORM where the field values are populated with variables I
set at the top of the page. variable1="" if a new record, or
variable1="#field1#" from a query if an update.

For one of the fields in the form, I have to query another one-column
table for values. I got it working, sort of, but I have two problems.
First, some of the values in the second table are multiple words, like
"Civil Rights Leader", but when the first table is updated, I only get
the first word... anything after the first space is not passed. Any
thoughts?

Second, for maintenance purposes, I would rather not maintain two tables
for this information. Would you recommend using a self join on this
field, so that I can get a drop down list of all the available values
and enter an new value while I'm updating the main record? I suppose
another alternative is to create a linking table in which I would store
only keys. Given the number of tables I have already and the complexity
of the application, I'd rather not, but I would follow the advice of the
more experienced among you.

What I'm looking for here is what I always called (prior to using CF and
SQL) a lookup on previously entered values.

TIA,
John Allred
-- 
John Allred / Jackson, Mississippi
Mississippi Counties
http://www.mscounties.com/
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



timecard applications

2000-05-26 Thread Shawn Regan

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--_=_NextPart_001_01BFC757.A0A19200
Content-Type: text/plain;
charset="iso-8859-1"

Does anyone know of any timecard like applications?

Shawn Regan

--_=_NextPart_001_01BFC757.A0A19200
Content-Type: text/html;
charset="iso-8859-1"






timecard applications



Does anyone know of any timecard like applications?


Shawn Regan




--_=_NextPart_001_01BFC757.A0A19200--
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



OT - COM object -- create a windows file shortcut

2000-05-26 Thread Russel Madere

I'm sorry for spamming all of the lists if you get more than one.

Hello,

We are willing to pay up to $500 to anyone who will create a cfm custom tag
and/or COM object to make a windows shortcut to a specified filename. This
is possible in VB, but I don't have the technical expertise to pull it off.
Our current leads are:

http://msdn.microsoft.com/library/psdk/shellcc/shell/Shortcut.htm

Please email me directly.

Thanks,
Russel
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: verity search problem

2000-05-26 Thread Eron Cohen

Sima,

What happens when you manually type in a search word that you know must
exist in your collection?

Can you post the rest of the code you're using?

Eron

PS-  There have been alot of helpful posts regarding verity recently.  I
don't have any of others handy, but here's some information I posted a few
weeks ago that may help you:


1)  The verity search engine built into CF is somewhat stripped down from
the full version.  Although, as I have learned from posts on this forum, the
version that comes with Cold Fusion is full of "undocumented features" that
coincidently turn out to be features in the full version :-O

2)  To say the least, Verity can be weird.

I've definitely had my share of problems with Verity.  Probably the worst
one of all is that it doesn't tell you when there's an error...it just
doesn't work.  Here are a couple of other points from my presentation that
may help (If you do go looking for the entire presentation, its under PAST
MEETINGS > February > Eron Cohen):


--Verity searches can be CaSe sensitive.  I typically force keyword searches
into lower case.

--When using CFINDEX you must be sure that all the fields you include in the
BODY= parameters are valid fields from your query.  Often you won’t get an
error message and your index won’t work!

And possibly the biggest GOTCHA:

--**ALWAYS make sure your KEY= field is unique for EVERY record.  If
you don’t do this, as soon as verity encounters a duplicate key it will stop
indexing there (and it won’t give you any error messages!)***


3) I have done quite a bit of indexing of large amounts of data.  I am not
exactly sure what the limit is, but in fact, there IS a limit to the size of
your collections!  This is documented in Allaire’s KB (article #11934).

This is something you can get around because in CFSEARCH you can name more
than 1 collection to search at the same time, so you can always break down
what you want to search into separate collections.

I recently gave a presentation about Verity searches at the Maryland Cold
Fusion user's group.  You can download my PowerPoint slides there:

http://www.cfug-md.org/meetings.cfm (February 8th 2000)

-Original Message-
From: Sima Lee [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 26, 2000 4:48 PM
To: [EMAIL PROTECTED]
Subject: Re: verity search problem


Thank you for such a quick response. But I tried everything like the
following and it doesn't work:

CFSEARCH COLLECTION="test"
   NAME="GetItems"
   CRITERIA="#Form.criteria#">

or
   
or


They all return "0" record.

Sima




- Original Message -
From: Eron Cohen <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 26, 2000 3:30 PM
Subject: RE: verity search problem


> One thing that could be wrong: I believe you actually NEED # signs for
your
> Criteria= statement...
> What happens if you use:
>
>NAME="GetItems"
>   CRITERIA="#Form.criteria#">
>
> HTH,
>
> Eron
>
> -Original Message-
> From: Sima Lee [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 26, 2000 4:10 PM
> To: [EMAIL PROTECTED]
> Subject: verity search problem
>
>
> This is a multi-part message in MIME format.
>
> --=_NextPart_000_0041_01BFC724.71016490
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> Hi All,
>
> I am new to ColdFusion and try to use verity search . This is the =
> problem I got:
> I created a collection and indexed it . It says there is 8 records in it =
> , which is true. But when I use the cfsearch tag to search , it always =
> gives me zero records no matter what I type in as a criteria. But if I =
> change   Criteria=3D"" in the search tag it gives me all the 8 records. =
> For example:
>
>NAME=3D"GetItems"=20
>   CRITERIA=3D"Form.criteria">
> Will return 0 record.
>
> but
>NAME=3D"GetItems"=20
>   CRITERIA=3D"">
>
> will return all the 8 records.
>
> Could anybody tell me why the criteria does not work? Thanks in advance.
>
>
> --=_NextPart_000_0041_01BFC724.71016490
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> 
> 
>  http-equiv=3DContent-Type>
> 
> 
> 
> 
> Hi All,
>  
> I am new to ColdFusion and try to use =
> verity search=20
> . This is the problem I got:
> I created a collection and indexed it . =
> It says=20
> there is 8 records in it , which is true. But when I use the =
> cfsearch tag=20
> to search , it always gives me zero records no matter what I type in as =
> a=20
> criteria. But if I change   Criteria=3D"" in the search tag it =
> gives me=20
> all the 8 records. For example:
>  
>  COLLECTION=3D"test"&n=
> bsp; =20
> NAME=3D"GetItems" =
>  =20
> CRITERIA=3D"Form.criteria">
> Will return 0 record.
>  
> but
>  COLLECTION=3D"test"&n=
> bsp; =20
> NAME=3D"GetItems" =
>  =20
> CRITERIA=3D"">
>  
> will return all the 8 records.
>  
> 

RE: RE: Parsing text in memo field to recognize web addresses

2000-05-26 Thread Curt Makepeace

Would this solution work if there is more than one web address in the memo
field?

<-C

_

Date: Fri, 26 May 2000 12:52:58 -0600
From: "Shane Pitts" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: RE: Parsing text in memo field to recognize web addresses
Message-ID: <[EMAIL PROTECTED]>

This one will do it, if it is like a paragraph, and the URL is in the middle
of it.










#left(string, "#thestart#" - 1)# #theurl#
#mid(string, "#theend#", "#remainder#")#



#string#






-Original Message-
From: Curt Makepeace [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 26, 2000 11:57 AM
To: '[EMAIL PROTECTED]'
Subject: Parsing text in memo field to recognize web addresses


Is there some way to get your coldfusion app to recognize a web address?

i.e., this is what I would like to do in the app:
The text goes into a memo field in the access database normally. When the
message is displayed through the app, and if it finds the text 'http:\\'
anywhere in the field, it will add the 'a href' syntax to that string to
make the link 'clickable' within the text.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: verity search problem

2000-05-26 Thread Sima Lee

Thank you for such a quick response. But I tried everything like the
following and it doesn't work:

CFSEARCH COLLECTION="test"
   NAME="GetItems"
   CRITERIA="#Form.criteria#">

or
   
or


They all return "0" record.

Sima




- Original Message -
From: Eron Cohen <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 26, 2000 3:30 PM
Subject: RE: verity search problem


> One thing that could be wrong: I believe you actually NEED # signs for
your
> Criteria= statement...
> What happens if you use:
>
>NAME="GetItems"
>   CRITERIA="#Form.criteria#">
>
> HTH,
>
> Eron
>
> -Original Message-
> From: Sima Lee [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 26, 2000 4:10 PM
> To: [EMAIL PROTECTED]
> Subject: verity search problem
>
>
> This is a multi-part message in MIME format.
>
> --=_NextPart_000_0041_01BFC724.71016490
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> Hi All,
>
> I am new to ColdFusion and try to use verity search . This is the =
> problem I got:
> I created a collection and indexed it . It says there is 8 records in it =
> , which is true. But when I use the cfsearch tag to search , it always =
> gives me zero records no matter what I type in as a criteria. But if I =
> change   Criteria=3D"" in the search tag it gives me all the 8 records. =
> For example:
>
>NAME=3D"GetItems"=20
>   CRITERIA=3D"Form.criteria">
> Will return 0 record.
>
> but
>NAME=3D"GetItems"=20
>   CRITERIA=3D"">
>
> will return all the 8 records.
>
> Could anybody tell me why the criteria does not work? Thanks in advance.
>
>
> --=_NextPart_000_0041_01BFC724.71016490
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> 
> 
>  http-equiv=3DContent-Type>
> 
> 
> 
> 
> Hi All,
>  
> I am new to ColdFusion and try to use =
> verity search=20
> . This is the problem I got:
> I created a collection and indexed it . =
> It says=20
> there is 8 records in it , which is true. But when I use the =
> cfsearch tag=20
> to search , it always gives me zero records no matter what I type in as =
> a=20
> criteria. But if I change   Criteria=3D"" in the search tag it =
> gives me=20
> all the 8 records. For example:
>  
>  COLLECTION=3D"test"&n=
> bsp; =20
> NAME=3D"GetItems" =
>  =20
> CRITERIA=3D"Form.criteria">
> Will return 0 record.
>  
> but
>  COLLECTION=3D"test"&n=
> bsp; =20
> NAME=3D"GetItems" =
>  =20
> CRITERIA=3D"">
>  
> will return all the 8 records.
>  
> Could anybody tell me why the criteria does not work? Thanks in=20
> advance.
>  
>
> --=_NextPart_000_0041_01BFC724.71016490--
>
> --
--
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Tell a friend

2000-05-26 Thread John Westerlund

The link should go to a self-posting form with CFMAIL, body =
#cgi.http_referrer# (or whichever that property is)...
Form attributes= From, From email, To, To email, Title, comments and
cgi.http_referrer.


- Original Message -
From: Smad <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 26, 2000 1:29 PM
Subject: Tell a friend


>
> How do I create a "Tell a friend" feature? I want to be able to submit the
> page link automaticaly, based on the page where the user is, and the
person
> who sent it, with a certain message. Is there perhaps a tag for this?
> Thanks.
>
> Smad
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Tell a friend

2000-05-26 Thread Smad


How do I create a "Tell a friend" feature? I want to be able to submit the
page link automaticaly, based on the page where the user is, and the person
who sent it, with a certain message. Is there perhaps a tag for this?
Thanks.

   
 Smad

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: verity search problem

2000-05-26 Thread Eron Cohen

One thing that could be wrong: I believe you actually NEED # signs for your
Criteria= statement...
What happens if you use:



HTH,

Eron

-Original Message-
From: Sima Lee [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 26, 2000 4:10 PM
To: [EMAIL PROTECTED]
Subject: verity search problem


This is a multi-part message in MIME format.

--=_NextPart_000_0041_01BFC724.71016490
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi All,

I am new to ColdFusion and try to use verity search . This is the =
problem I got:
I created a collection and indexed it . It says there is 8 records in it =
, which is true. But when I use the cfsearch tag to search , it always =
gives me zero records no matter what I type in as a criteria. But if I =
change   Criteria=3D"" in the search tag it gives me all the 8 records. =
For example:


Will return 0 record.

but


will return all the 8 records.

Could anybody tell me why the criteria does not work? Thanks in advance.


--=_NextPart_000_0041_01BFC724.71016490
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








Hi All,
 
I am new to ColdFusion and try to use =
verity search=20
. This is the problem I got:
I created a collection and indexed it . =
It says=20
there is 8 records in it , which is true. But when I use the =
cfsearch tag=20
to search , it always gives me zero records no matter what I type in as =
a=20
criteria. But if I change   Criteria=3D"" in the search tag it =
gives me=20
all the 8 records. For example:
 

Will return 0 record.
 
but

 
will return all the 8 records.
 
Could anybody tell me why the criteria does not work? Thanks in=20
advance.
 

--=_NextPart_000_0041_01BFC724.71016490--


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Cold Fusion and Julian Dates

2000-05-26 Thread Jeff Honken

Jim,  Thanks that worked.  I used:



-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 26, 2000 12:01 PM
To: [EMAIL PROTECTED]
Cc: Jeff Honken
Subject: Re: Cold Fusion and Julian Dates


Try using #Int(Now()# to get a numeric value for the current date.  I
don't think it's the actual "Julian" date, but the number of days elapsed
since Dec 30, 1899.

Jim


-Original Message-
From: Jeff Honken <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Friday, May 26, 2000 12:25 PM
Subject: RE: Cold Fusion and Julian Dates


>I need to insert the system date into a flat file.  It needs to be
Julian.
>I'm using the  for the extraction of the file.  Is there any
simple
>ways of getting this date to Julian format?


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



verity search problem

2000-05-26 Thread Sima Lee

This is a multi-part message in MIME format.

--=_NextPart_000_0041_01BFC724.71016490
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi All,

I am new to ColdFusion and try to use verity search . This is the =
problem I got:
I created a collection and indexed it . It says there is 8 records in it =
, which is true. But when I use the cfsearch tag to search , it always =
gives me zero records no matter what I type in as a criteria. But if I =
change   Criteria=3D"" in the search tag it gives me all the 8 records. =
For example:


Will return 0 record.

but


will return all the 8 records.

Could anybody tell me why the criteria does not work? Thanks in advance.


--=_NextPart_000_0041_01BFC724.71016490
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








Hi All,
 
I am new to ColdFusion and try to use =
verity search=20
. This is the problem I got:
I created a collection and indexed it . =
It says=20
there is 8 records in it , which is true. But when I use the =
cfsearch tag=20
to search , it always gives me zero records no matter what I type in as =
a=20
criteria. But if I change   Criteria=3D"" in the search tag it =
gives me=20
all the 8 records. For example:
 

Will return 0 record.
 
but

 
will return all the 8 records.
 
Could anybody tell me why the criteria does not work? Thanks in=20
advance.
 

--=_NextPart_000_0041_01BFC724.71016490--

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: CFFILE replace text

2000-05-26 Thread john rice

Here is a start (I am assuming a few things here)









http://sahdsvr1.alltel.com/outages/
Last Network Outage at 05/26/00 11:22:38 AM CST

http://sahdsvr1.alltel.com/
Homepage Link
">












#newoutage#

-JR


--- Original ---

I have a plain text file that has a link listed on one line and title on the
next.  I want to replace a certain section with a variable using CFFILE.  Here
is what I have.  I am not sure how to find the string and replace it.

Here is an example of the text file ticker.txt:

http://sahdsvr1.alltel.com/outages/
Last Network Outage at 05/26/00 11:22:38 AM CST

http://sahdsvr1.alltel.com/
Homepage Link

I want to find the http://sahdsvr1.alltel.com/outages/ and next line and replace
it with the newoutage variable.




How do I parse outages to find and replace the lines I want with newoutage?





Please let me know if this is possible.

Thanks,

Grady Milhon
[EMAIL PROTECTED] 
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
---
FREE! The World's Best Email Address @email.com
Reserve your name now at http://www.email.com


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: [cfmail]

2000-05-26 Thread Bob Smith

CFMAIL restriction of 40 email address is there if you use it as follows:

 wrote:
Does CFMAIL still restrict you to 40 email address?  If so, what's the work
around.

Thanks,

Katie
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.


Thanks,
Bob


Get free email and a permanent address at http://www.amexmail.com/?A=1
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Slightly OT: Dev. for multiple browser versions

2000-05-26 Thread Ryan Hill

Just thought I would mention that we have a G4 for our graphics development
and have been unable to get 4.x anything to run on VPC... always crashes
when you open it.  At least its consistent I guess ;)

Regards,

Ryan Hill, MCSE
Director, Systems Integration
Market Matrix, Inc. - http://www.marketmatrix.com 

-Original Message-
From: Nick Slay [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 25, 2000 3:19 PM
To: [EMAIL PROTECTED]
Subject: Re: Slightly OT: Dev. for multiple browser versions


:^(

Ahh, but I could always resort to NoteTab Pro or, in real desperation, 
Notepad!   I guess for that matter I could always use BBEdit!!

But, at the end of the day, I'll be able to code on a Mac!!!  Yeeha...





At 10:47 25/05/00 -0400, you wrote:
>Nick,
>
>While I can sympathize with your feelings, VPC will run quite slow. On
>your powerbook it will be similar to running CFStudio on a Pentium 166
>or 200.
>
>larry
>
>--
>Larry C. Lyons
>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.
>--
>
>Nick Slay wrote:
> >
> > DOH!!!   What am I talking about. I've ordered VirtualPC for this
> > Powerbook too CF Studio will run there. HAHAHA... (sound of
opening
> > window, the whistling as the base unit hurtles towards the ground and
then
> > the smashing PC!!!  'Take that you piece of useless, unreliable junk
> > mwahhahahah'!!)
>---
---
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or 
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in 
>the body.


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



CFFILE replace text

2000-05-26 Thread Grady Milhon

I have a plain text file that has a link listed on one line and title on the
next.  I want to replace a certain section with a variable using CFFILE.  Here
is what I have.  I am not sure how to find the string and replace it.

Here is an example of the text file ticker.txt:

http://sahdsvr1.alltel.com/outages/
Last Network Outage at 05/26/00 11:22:38 AM CST

http://sahdsvr1.alltel.com/
Homepage Link

I want to find the http://sahdsvr1.alltel.com/outages/ and next line and replace
it with the newoutage variable.




How do I parse outages to find and replace the lines I want with newoutage?





Please let me know if this is possible.

Thanks,

Grady Milhon
[EMAIL PROTECTED] 
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: How do you make the Cursor Default to the First Input Field : A general script.

2000-05-26 Thread john rice

Being general;

Save this text by itself into a cold fusion file.  Then cfinclude the file at the 
bottom of any page you want focus to be set to.  It will find the first input and set 
focus to it.

window.focus();if(document.forms[0]!=null){if(document.forms[0].elements[0]!=null){if(document.forms[0].elements[0].type!='hidden')document.forms[0].elements[0].focus();}}


-JR


--- Original ---

Hi CF_friends,

How do I make the Cursor Default to the First Input Field as soon as a form
is requested.  I used the tabindex='1' attribute but it still defaults to
the browser URL Address box.

Thanks
sam
---
FREE! The World's Best Email Address @email.com
Reserve your name now at http://www.email.com


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Developer Conference: Hotel Accomodations

2000-05-26 Thread Sean Renet

There is a conference?
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 26, 2000 4:34 AM
Subject: Developer Conference: Hotel Accomodations


> I am attending the Conference in November and am looking for
recommendations for accomodations.  Is $210 a reasonable rate?  Are there
other hotels I should consider?
>
> John
>
> Visit www.cfworkshop.com
> ___
>
> Why pay when you don't have to? Get AltaVista Free Internet Access now!
> http://jump.altavista.com/freeaccess4.go
>
> ___
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: RDS & Usernames It's OK?

2000-05-26 Thread GE

Hello,

Thanks anyways but I have figured it out, so please disregard.

Nelson

GE wrote:

> Hello,
>
> I was wondering about the following:
>
> I use CF Studio 4.5 to remotely develop pages on a CF Server on a
> Solaris machine.
>
> When I create a file locally using CF Studio and save it to the server
> (through RDS) the owner/group of the file is nobody/nobody. This is
> obviously not an acceptable situation. When saving the file via FTP all
> file persmissions and owner/group are, of course, correct.
>
> Anybody else encounter this ? Maybe a possible solution?
>
> thanks for any help offered,
> Nelson
>
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit 
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Insert into two tables

2000-05-26 Thread Elizabeth Marcotte KJ

Ben,

I do not know about the @@identity thing.  But - both tables should contain
at least partially the same key structure.  You can do 2 inserts if you have
the key structure for both or you insert the first table, select on it do a
loop and insert the second table?  Does that sound right?  Actually, now
that I am writing this - you can also set it up in your database to insert
into your second table automatically, whenever you insert into your first
table.

Hope that helps
Elizabeth

-Original Message-
From: Ben Densmore [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 26, 2000 11:41 AM
To: [EMAIL PROTECTED]
Subject: Insert into two tables

This is a multi-part message in MIME format.

--=_NextPart_000_0033_01BFC720.5DDB5780
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

I have a small 2 table relational DB that I need to insert values into, =
the main table has some customer info and the second table just has the =
type of product a customer downloaded, I am drawing a blank on how to =
insert into 2 tables, I all ready have my insert statement written for =
the larger table but now I can't remember if I need to Select the ID =
that was created for the first table and insert that value into the =
second table or if I need to use the @@identity thing.
Any help would be appreciated.

Thanks,
Ben Densmore
Webmaster
eSupport.com, Inc
TouchStone Software Corp.


--=_NextPart_000_0033_01BFC720.5DDB5780
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable








I have a small 2 table relational DB =
that I need to=20
insert values into, the main table has some customer info and the second =
table=20
just has the type of product a customer downloaded, I am drawing a blank =
on how=20
to insert into 2 tables, I all ready have my insert statement written =
for the=20
larger table but now I can't remember if I need to Select the ID that =
was=20
created for the first table and insert that value into the second table =
or if I=20
need to use the @@identity thing.
Any help would be =
appreciated.
 
Thanks,
Ben =
DensmoreWebmastereSupport.com,=20
IncTouchStone Software Corp.

--=_NextPart_000_0033_01BFC720.5DDB5780--


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Cold Fusion and Julian Dates

2000-05-26 Thread Jim McAtee

Try using #Int(Now()# to get a numeric value for the current date.  I
don't think it's the actual "Julian" date, but the number of days elapsed
since Dec 30, 1899.

Jim


-Original Message-
From: Jeff Honken <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Friday, May 26, 2000 12:25 PM
Subject: RE: Cold Fusion and Julian Dates


>I need to insert the system date into a flat file.  It needs to be
Julian.
>I'm using the  for the extraction of the file.  Is there any
simple
>ways of getting this date to Julian format?

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Site Design Question

2000-05-26 Thread Sean Renet

IF's are always going to be slower than switch's (or so I have been told).
And the docs use a switch so I figure I should as well :-P
- Original Message -
From: "Eric Dawson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 26, 2000 5:34 AM
Subject: Re: Site Design Question


> Well the same thing can be done as:
>
> 
>   
> 
>
> === _template.cfm ===
> 
>   
> 
>   
> 
> =
>
> 
> 
> 
> 
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Parsing text in memo field to recognize web addresses

2000-05-26 Thread Sean Daniels

> i.e., this is what I would like to do in the app:
> The text goes into a memo field in the access database normally. When the
> message is displayed through the app, and if it finds the text 'http:\\'
> anywhere in the field, it will add the 'a href' syntax to that string to
> make the link 'clickable' within the text.
>
> Is this too far out there?

Curt,

I have a custom tag that will do this. Contact me off list if you are
interested.


- Sean


Sean Daniels
Manager, Engineering
Marketplace Technologies
[EMAIL PROTECTED]
http://www.dealstream.com
http://www.mergernetwork.com

tel: 207.439.6030
cel: 978.764.0779



--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Parsing text in memo field to recognize web addresses

2000-05-26 Thread Shane Pitts

This one will do it, if it is like a paragraph, and the URL is in the middle
of it.










#left(string, "#thestart#" - 1)# #theurl#
#mid(string, "#theend#", "#remainder#")#



#string#






-Original Message-
From: Curt Makepeace [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 26, 2000 11:57 AM
To: '[EMAIL PROTECTED]'
Subject: Parsing text in memo field to recognize web addresses


Is there some way to get your coldfusion app to recognize a web address?

i.e., this is what I would like to do in the app:
The text goes into a memo field in the access database normally. When the
message is displayed through the app, and if it finds the text 'http:\\'
anywhere in the field, it will add the 'a href' syntax to that string to
make the link 'clickable' within the text.

Is this too far out there?

Any help is appreciated!

<-C


Curt W. Makepeace, B.Mngt
Regional Webmaster
Applications Support & Roll-out
GTIS - PWGSC Western Region

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Source Control

2000-05-26 Thread john rice

Elizabeth,

If you want good source control and deployment follow this link:

http://www.interwoven.com/products/teamsite/

VSS is good but TeamSite is very good.

-JR

Hello Everyone,

I recently posted a question about Microsoft sourcesafe and did not get an
answer.  I am taking this to mean not many people use MS SourceSafe.  What
kind of source control (networked) does everyone with CF use?

Please any ideas and suggestions are greatly appreciated.

Thanks
Elizabeth
---
FREE! The World's Best Email Address @email.com
Reserve your name now at http://www.email.com


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Source Control

2000-05-26 Thread Steve Pierce

Allaire was using Sourcesafe.

-Original Message-
From: Elizabeth Marcotte KJ [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 26, 2000 2:36 PM
To: cf-talk@houseoffusion. com
Subject: Source Control


This is a multi-part message in MIME format.

--=_NextPart_000_001F_01BFC706.9A44E200
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hello Everyone,

I recently posted a question about Microsoft sourcesafe and did not get an
answer.  I am taking this to mean not many people use MS SourceSafe.  What
kind of source control (networked) does everyone with CF use?

Please any ideas and suggestions are greatly appreciated.

Thanks
Elizabeth

--=_NextPart_000_001F_01BFC706.9A44E200
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

http://www.w3.org/TR/REC-html40">






cid:[EMAIL PROTECTED]">










Hello Everyone,

 

I recently posted a question about Microsoft sourcesafe and did =
not get
an answer.  I am taking =
this to
mean not many people use MS SourceSafe. 
What kind of source control (networked) does everyone with CF =
use?  =


 

Please any ideas and suggestions are greatly =
appreciated.

 

Thanks

Elizabeth







--=_NextPart_000_001F_01BFC706.9A44E200--


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: How do you make the Cursor Default to the First Input Field

2000-05-26 Thread Timothy C. Hill

On Fri, 26 May 2000 11:19:11 -0500, [EMAIL PROTECTED] wrote:
>Hi CF_friends,
>
>How do I make the Cursor Default to the First Input Field as soon as
>a form
>is requested.  I used the tabindex='1' attribute but it still
>defaults to
>the browser URL Address box.
>
>Thanks
>sam
>
>-

>-
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_ta

>lk or send a message to [EMAIL PROTECTED] with
>'unsubscribe' in the body.

OnLoad="document.form_name.input_name.focus();"

Put this in the body field.
-- Timothy C. Hill, [EMAIL PROTECTED] on 05/26/2000

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Insert into two tables

2000-05-26 Thread Ben Densmore

This is a multi-part message in MIME format.

--=_NextPart_000_0033_01BFC720.5DDB5780
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

I have a small 2 table relational DB that I need to insert values into, =
the main table has some customer info and the second table just has the =
type of product a customer downloaded, I am drawing a blank on how to =
insert into 2 tables, I all ready have my insert statement written for =
the larger table but now I can't remember if I need to Select the ID =
that was created for the first table and insert that value into the =
second table or if I need to use the @@identity thing.
Any help would be appreciated.

Thanks,
Ben Densmore
Webmaster
eSupport.com, Inc
TouchStone Software Corp.


--=_NextPart_000_0033_01BFC720.5DDB5780
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable








I have a small 2 table relational DB =
that I need to=20
insert values into, the main table has some customer info and the second =
table=20
just has the type of product a customer downloaded, I am drawing a blank =
on how=20
to insert into 2 tables, I all ready have my insert statement written =
for the=20
larger table but now I can't remember if I need to Select the ID that =
was=20
created for the first table and insert that value into the second table =
or if I=20
need to use the @@identity thing.
Any help would be =
appreciated.
 
Thanks,
Ben =
DensmoreWebmastereSupport.com,=20
IncTouchStone Software Corp.

--=_NextPart_000_0033_01BFC720.5DDB5780--

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Source Control

2000-05-26 Thread Elizabeth Marcotte KJ

This is a multi-part message in MIME format.

--=_NextPart_000_001F_01BFC706.9A44E200
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hello Everyone,

I recently posted a question about Microsoft sourcesafe and did not get an
answer.  I am taking this to mean not many people use MS SourceSafe.  What
kind of source control (networked) does everyone with CF use?

Please any ideas and suggestions are greatly appreciated.

Thanks
Elizabeth

--=_NextPart_000_001F_01BFC706.9A44E200
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

http://www.w3.org/TR/REC-html40">






cid:[EMAIL PROTECTED]">










Hello Everyone,

 

I recently posted a question about Microsoft sourcesafe and did =
not get
an answer.  I am taking =
this to
mean not many people use MS SourceSafe. 
What kind of source control (networked) does everyone with CF =
use?  =


 

Please any ideas and suggestions are greatly =
appreciated.

 

Thanks

Elizabeth







--=_NextPart_000_001F_01BFC706.9A44E200--

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Killing Session & Back Button

2000-05-26 Thread Raymond K. Camden

You should _never_ use this code. It may work to log you out, but if your
using CF 4.5, the server will throw an error next time you try to set a
session var. Before 4.5, StructClear would not touch the 'special' Session
vars that CF uses to identify you. With CF 4.5 and higher, StructClear will
nuke them.

You can do one of two things:

1) Keep all your stuff in a substruct, like Session.MyApp, then do
StructClear on that.

2) Use StructDelete to nuke individual keys.


3 hours till vacation.

===
Raymond Camden, Cold Fusion Jedi Master for Syntegra (www.syntegra.com)
Allaire Certified Instructor and Member of Team Allaire

Email   : [EMAIL PROTECTED]
ICQ UIN : 3679482

"My ally is the Force, and a powerful ally it is." - Yoda


> -Original Message-
> From: Mark Warrick [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 26, 2000 12:15 PM
> To: [EMAIL PROTECTED]
> Subject: RE: Killing Session & Back Button
>
>
> I use the following code to kill session variables.
>
> 
> #StructClear(session)#
> 
>
> If, by chance, a user tries to backup, all they are going to see
> is the same
> thing that they saw before the hit the logout button.  If they try to do
> anything else, my security logic kicks them back to the login page.
>
> ---mark
>
>
>
> -
> Mark Warrick
> (714) 939-6431
> The Sistonia Corporation
> [EMAIL PROTECTED]
> http://www.sistonia.com
>
> > -Original Message-
> > From: Steve Reich [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, May 25, 2000 11:48 AM
> > To: CF Talk
> > Subject: Killing Session & Back Button
> >
> >
> > I have a link on my site for users to log out. This takes them to a page
> > that kills all session variables and then directs them back to the login
> > page. However, if they hit the back button, they can get back to
> > where they
> > were when they logged out, refresh the page, and their variables
> > are reset.
> > How can I kill the variables so the page isn't available with the back
> > button without them?
> >
> > TIA
> >
> >
> > ~~
> > Steve Reich
> > Backsoft Corporation
> > 6960 Professional Parkway East
> > Suite 100
> > Sarasota, Florida 34240
> > Toll Free: (888) 222-6047
> > Phone: (941) 907-6655 - Ext.1038
> > Fax: (941) 907-6643
> >
> > email: [EMAIL PROTECTED]
> > web: http://www.backsoft.com
> >
> > "Any sufficiently advanced technology
> >  is indistinguishable from magic."
> >
> >   - Arthur C. Clarke
> > ~~
> >
> > --
> > 
> > Archives: http://www.eGroups.com/list/cf-talk
> > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
> > _talk or send a message to [EMAIL PROTECTED] with
> > 'unsubscribe' in the body.
> >
>
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: How do you make the Cursor Default to the First Input Field

2000-05-26 Thread Eva Holtsmark

Hi,

I remember when I learned this one at a Figleaf CFUG from a very enthusiastic Dave 
Watts  -


  


where 'realname' is the name of your input field, i.e.
 

Thanks, Dave.

> How do I make the Cursor Default to the First Input Field as soon as a form
> is requested.  I used the tabindex='1' attribute but it still defaults to
> the browser URL Address box.

___

Eva
Senior Web Developer__

e:  [EMAIL PROTECTED]
v:  (202) 737-1030 x24
http://www.hskids-tmsc.org
Head Start Publications Management Center
__


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: How do you make the Cursor Default to the First Input Field

2000-05-26 Thread Justin MacCarthy

document.forms[0].elements[0].focus()
will do it first for first form ,first field

~Justin MacCarthy

- Original Message -
From: sam komolafe <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 26, 2000 5:19 PM
Subject: How do you make the Cursor Default to the First Input Field


> Hi CF_friends,
>
> How do I make the Cursor Default to the First Input Field as soon as a
form
> is requested.  I used the tabindex='1' attribute but it still defaults to
> the browser URL Address box.
>
> Thanks
> sam
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Parsing text in memo field to recognize web addresses

2000-05-26 Thread Shane Pitts


#string#

#string#


-Original Message-
From: Curt Makepeace [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 26, 2000 11:57 AM
To: '[EMAIL PROTECTED]'
Subject: Parsing text in memo field to recognize web addresses


Is there some way to get your coldfusion app to recognize a web address?

i.e., this is what I would like to do in the app:
The text goes into a memo field in the access database normally. When the
message is displayed through the app, and if it finds the text 'http:\\'
anywhere in the field, it will add the 'a href' syntax to that string to
make the link 'clickable' within the text.

Is this too far out there?

Any help is appreciated!

<-C


Curt W. Makepeace, B.Mngt
Regional Webmaster
Applications Support & Roll-out
GTIS - PWGSC Western Region

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Cold Fusion and Julian Dates

2000-05-26 Thread Jeff Honken

I need to insert the system date into a flat file.  It needs to be Julian.
I'm using the  for the extraction of the file.  Is there any simple
ways of getting this date to Julian format?

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



How do you make the Cursor Default to the First Input Field

2000-05-26 Thread sam komolafe

Hi CF_friends,

How do I make the Cursor Default to the First Input Field as soon as a form
is requested.  I used the tabindex='1' attribute but it still defaults to
the browser URL Address box.

Thanks
sam

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: IIS,Virtual Directorys and CF?

2000-05-26 Thread malcolm mcatee

i SHOULD PROBABLY CREATE A CF_USER ACCOUNT
THAT HAS READ ONLY RIGHTS?
-Original Message-
From: Olive, Christopher M Mr USACHPPM
[mailto:[EMAIL PROTECTED]]
Sent: Friday, May 26, 2000 1:49 PM
To: '[EMAIL PROTECTED]'
Subject: RE: IIS,Virtual Directorys and CF?


fantatic.  glad you fixed it.

one problem.

that's a BIG security hole.  with CF running as the admin account, if
someone compromises an app, they have COMPLETE access to your system.

Chris Olive,
DOEHRS Website Administrator

-Original Message-
From: malcolm mcatee [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 26, 2000 1:32 PM
To: [EMAIL PROTECTED]
Subject: RE: IIS,Virtual Directorys and CF?


Thanks for your help, but I have resolved this.
My virtual directory worked fine I just could not get CF server to
process .cfm files located on the other machine.
My fix:
Under services in the NT control Panel,
I selected Cold fusion application server
in the "Log In As" portion of the dialog box
I changed from the default system user to (in my case)
Administrator--stopped and restarted the service--
and everything worked!


-Original Message-
From: Olive, Christopher M Mr USACHPPM
[mailto:[EMAIL PROTECTED]]
Sent: Friday, May 26, 2000 12:49 PM
To: '[EMAIL PROTECTED]'
Subject: RE: IIS,Virtual Directorys and CF?


create a virtual directory in IIS, point it to a "different machine" (an
option in  the create VD screen), and use a UNC to tell it where to look.
mapping a drive will only work if you map is as the service in whose context
the CF server runs.

Chris Olive,
DOEHRS Website Administrator

-Original Message-
From: malcolm mcatee [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 25, 2000 2:38 PM
To: [EMAIL PROTECTED]
Subject: RE: IIS,Virtual Directorys and CF?


Can I host .cfm files on a different server than my cold fusion server?
I am currently hosting all my .cfm files on an NT server running coldfusion.
For security reasons I would like to be able  host my .cfm intranet files on
our novell server. I have been succesful setting up a virtual directory that
allows
the nt server to view directorys and files that are located on the novell
box ,
but when i call a .cfm page I get a 404 error.
Do I need to change my root development
mapping on the cold fusion server? I have tried to browse to the novell
machine
but cf only sees local drives.

Help please!
Malcolm

-Original Message-
From: malcolm mcatee [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 24, 2000 10:57 AM
To: [EMAIL PROTECTED]
Subject: RE: IIS,Virtual Directorys and CF?


Thanks for your response---
I have not had any trouble w/ users editing the cf_includes
They are invisible when the document is viewed in word unless you choose
view html source---Most of my users are not advanced enough to know what
view html source even means. I did not really understand the rest of your
explanation.

I have never created a macro before---Can I attach this to the template?
Why do you not like this idea?


-Original Message-
From: Justin MacCarthy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 24, 2000 10:41 AM
To: [EMAIL PROTECTED]
Subject: Re: IIS,Virtual Directorys and CF?


Hi Malcolm,

I' m a little confused by the first part of the question - however I have
some suggestions of the no2.

a) Don't include the cfinlcude etc in your Word Template , instead create a
handler which includes the middle bit (the HTML created by your users) in
between the cfincludes . this will get around the .cfm problem & also stop
users from removing the cfincludes from the template.

b) write a AutoClose macro for word that saves the file as .cfm (I don't
really like this idea...)


> 2.Although the templates work really well--word insists on using.htm as
the
> default extension.
> Is there a way to change this default? If Not can I set up cf server to
> parse for all .htm extensions--
> convert to .cfm and upload to the live directory? can i schedule this
using
> the shcheduled events in cf server?
>



--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-tal

Re: Cold Fusion and NT Passwords

2000-05-26 Thread Cold Fusion Newsgroup

Mark,

Adding the "SYSTEM" user in NT worked!!!  Thank you VERY much.

I've only been on this mailing list 3 days, and it's great :)

Laura

- Original Message -
From: Mark Warrick <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 26, 2000 12:07 PM
Subject: RE: Cold Fusion and NT Passwords


> Make sure that your CF Server service is running with the correct security
> permissions to access those files.
>
> For example, if you installed it with all defaults and were logged in as
the
> Administrator at the time, you can let "SYSTEM" have full control to all
> those files without affecting your clients access rights.
>
> ---mark
>
>
> -
> Mark Warrick
> (714) 939-6431
> The Sistonia Corporation
> [EMAIL PROTECTED]
> http://www.sistonia.com
>
> > -Original Message-
> > From: Cold Fusion Newsgroup [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, May 26, 2000 6:32 AM
> > To: [EMAIL PROTECTED]
> > Subject: Cold Fusion and NT Passwords
> >
> >
> > This is a multi-part message in MIME format.
> >
> > --=_NextPart_000_001F_01BFC6F5.4E6FCC20
> > Content-Type: text/plain;
> > charset="iso-8859-1"
> > Content-Transfer-Encoding: quoted-printable
> >
> > Hi,
> >
> > I am having a problem using Cold Fusion with directories using NT's =
> > basic authentication.  We have approvals directories set up for our =
> > clients using NT passwords.  Once the client accesses an html page =
> > inside the password protected directory, they can't seem to access any =
> > cfm pages to run queries, etc.  the cold fusion server resides at an =
> > upper level directory outside of the password protected area and must =
> > remain there.
> >
> > Has anyone experienced a similar problem, and if so, what can be done to
=
> > get CF to work in those directories. =20
> >
> > Thanks,
> >
> > Laura
> >
> > --=_NextPart_000_001F_01BFC6F5.4E6FCC20
> > Content-Type: text/html;
> > charset="iso-8859-1"
> > Content-Transfer-Encoding: quoted-printable
> >
> > 
> > 
> >  > http-equiv=3DContent-Type>
> > 
> > 
> > 
> > 
> > 
> > Hi,
> >  
> > I am having a problem using Cold Fusion with =
> > directories using=20
> > NT's basic authentication.  We have approvals directories set up =
> > for our=20
> > clients using NT passwords.  Once the client accesses an html page
=
> > inside=20
> > the password protected directory, they can't seem to access any cfm =
> > pages to run=20
> > queries, etc.  the cold fusion server resides at an upper level =
> > directory=20
> > outside of the password protected area and must remain =
> > there.
> >  
> > Has anyone experienced a similar problem, and if so,
=
> > what can=20
> > be done to get CF to work in those directories.  
> >  
> > Thanks,
> >  
> > Laura
> >
> > --=_NextPart_000_001F_01BFC6F5.4E6FCC20--
> >
> > --
> > 
> > Archives: http://www.eGroups.com/list/cf-talk
> > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
> > _talk or send a message to [EMAIL PROTECTED] with
> > 'unsubscribe' in the body.
> >
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: CF and WAP ????

2000-05-26 Thread Ron Anderson

Give http://www.wapuseek.com/ a try, they've got some sample code too.
There's also a CF-WAP list...although it's been kinda slow lately:
[EMAIL PROTECTED]

-Original Message-
From: AustralianAccommodation.com Pty. Ltd.
[mailto:[EMAIL PROTECTED]]
Sent: Friday, May 26, 2000 4:24 AM
To: [EMAIL PROTECTED]
Subject: CF and WAP 


This is a multi-part message in MIME format.

--=_NextPart_000_0033_01BFC758.B1F77FA0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Does anyone no of any good reference material to assist in developing a =
cf based wap enabled web application


Kind Regards

Claude Raiola (Director)
AustralianAccommodation.com Pty. Ltd.
Website: www.AustralianAccommodation.com
Email: [EMAIL PROTECTED]

--=_NextPart_000_0033_01BFC758.B1F77FA0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








Does anyone no of any good reference =
material to=20
assist in developing a cf based wap enabled web application
 
 
Kind Regards
 
Claude Raiola=20
(Director)AustralianAccommodation.com Pty. Ltd.Website: http://www.AustralianAccommodation.com">www.AustralianAccommodati=
on.comEmail:=20
mailto:[EMAIL PROTECTED]">Director@AustralianA=
ccommodation.com

--=_NextPart_000_0033_01BFC758.B1F77FA0--


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Parsing text in memo field to recognize web addresses

2000-05-26 Thread Curt Makepeace

Is there some way to get your coldfusion app to recognize a web address? 

i.e., this is what I would like to do in the app:
The text goes into a memo field in the access database normally. When the
message is displayed through the app, and if it finds the text 'http:\\'
anywhere in the field, it will add the 'a href' syntax to that string to
make the link 'clickable' within the text.

Is this too far out there?

Any help is appreciated!

<-C


Curt W. Makepeace, B.Mngt
Regional Webmaster
Applications Support & Roll-out
GTIS - PWGSC Western Region
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Windows Auto ShutDown

2000-05-26 Thread Dave Watts

> Sorry to ask this, but does anyone know how you can automatically
> shutdown in Win98 and Win2000 without having to go thru' that
> radio button selection panel?

In NT/2K, you can do this from the command line using SHUTDOWN.EXE, which
comes with the NT and 2K resource kits.

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

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: [french] tres court : emploi

2000-05-26 Thread KChapman


Ce ne pas une intrusion.

Si vous êtes disposé à relocate (Comment dis donc relocate en Français?)
qq'n a Paris Nord.  J'irai.

--K


Katrina Chapman
Consultant
Ameriquest Mortgage


   
  
"Yannick Simon"
  
  
  
mmerce.fr>cc:  
  
  Subject: [french] tres court : 
emploi  
05/26/00 10:04 AM  
  
Please respond to  
  
cf-talk
  
   
  
   
  



RE: Cold Fusion and NT PasswordsNous avons de gros projets en cours pour
faire une v2 du site Rue Du Commerce. Je ne souhaite pas polluer cette
liste
géniale, mais si vous etes interessé, je cherche un tres bon developpeur,
sur Paris Nord, un an d'experience cold fusion pour des projets dans une
boite super ... vous etes interessé, envoyez moi votre cv ... vous me
trouvez qq'un pour le poste ? je vous promets une prime de cooptation.

pardon de cette intrusion.

Yannick Simon


--

Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.




--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: whitespace in cfloop

2000-05-26 Thread Philip Arnold - ASP

> I'm running a loop over a query . I don't have 
> anything to
> output in the loop and I can't get the whitespace out of the 
> final output. I
> have enlosed the entire page in cfenablecfoutputonly but it seems 
> like cold
> fusion treats the loop like .
> 
> Any help would be appreciated (as a slightly faster page).

try;

before the code, and 

after the code

Only things within  and  are sent to the browser.

HTH


Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and 
intended solely for the use of the individual or entity to whom they 
are addressed. If you have received this email in error please notify 
the system manager.
**


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



[french] tres court : emploi

2000-05-26 Thread Yannick Simon

Cold Fusion and NT PasswordsNous avons de gros projets en cours pour
faire une v2 du site Rue Du Commerce. Je ne souhaite pas polluer cette liste
géniale, mais si vous etes interessé, je cherche un tres bon developpeur,
sur Paris Nord, un an d'experience cold fusion pour des projets dans une
boite super ... vous etes interessé, envoyez moi votre cv ... vous me
trouvez qq'un pour le poste ? je vous promets une prime de cooptation.

 pardon de cette intrusion.

 Yannick Simon



--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: IIS,Virtual Directorys and CF?

2000-05-26 Thread Olive, Christopher M Mr USACHPPM

fantatic.  glad you fixed it.

one problem.

that's a BIG security hole.  with CF running as the admin account, if
someone compromises an app, they have COMPLETE access to your system.

Chris Olive,
DOEHRS Website Administrator 

-Original Message-
From: malcolm mcatee [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 26, 2000 1:32 PM
To: [EMAIL PROTECTED]
Subject: RE: IIS,Virtual Directorys and CF?


Thanks for your help, but I have resolved this.
My virtual directory worked fine I just could not get CF server to
process .cfm files located on the other machine.
My fix:
Under services in the NT control Panel,
I selected Cold fusion application server
in the "Log In As" portion of the dialog box
I changed from the default system user to (in my case)
Administrator--stopped and restarted the service--
and everything worked!


-Original Message-
From: Olive, Christopher M Mr USACHPPM
[mailto:[EMAIL PROTECTED]]
Sent: Friday, May 26, 2000 12:49 PM
To: '[EMAIL PROTECTED]'
Subject: RE: IIS,Virtual Directorys and CF?


create a virtual directory in IIS, point it to a "different machine" (an
option in  the create VD screen), and use a UNC to tell it where to look.
mapping a drive will only work if you map is as the service in whose context
the CF server runs.

Chris Olive,
DOEHRS Website Administrator

-Original Message-
From: malcolm mcatee [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 25, 2000 2:38 PM
To: [EMAIL PROTECTED]
Subject: RE: IIS,Virtual Directorys and CF?


Can I host .cfm files on a different server than my cold fusion server?
I am currently hosting all my .cfm files on an NT server running coldfusion.
For security reasons I would like to be able  host my .cfm intranet files on
our novell server. I have been succesful setting up a virtual directory that
allows
the nt server to view directorys and files that are located on the novell
box ,
but when i call a .cfm page I get a 404 error.
Do I need to change my root development
mapping on the cold fusion server? I have tried to browse to the novell
machine
but cf only sees local drives.

Help please!
Malcolm

-Original Message-
From: malcolm mcatee [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 24, 2000 10:57 AM
To: [EMAIL PROTECTED]
Subject: RE: IIS,Virtual Directorys and CF?


Thanks for your response---
I have not had any trouble w/ users editing the cf_includes
They are invisible when the document is viewed in word unless you choose
view html source---Most of my users are not advanced enough to know what
view html source even means. I did not really understand the rest of your
explanation.

I have never created a macro before---Can I attach this to the template?
Why do you not like this idea?


-Original Message-
From: Justin MacCarthy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 24, 2000 10:41 AM
To: [EMAIL PROTECTED]
Subject: Re: IIS,Virtual Directorys and CF?


Hi Malcolm,

I' m a little confused by the first part of the question - however I have
some suggestions of the no2.

a) Don't include the cfinlcude etc in your Word Template , instead create a
handler which includes the middle bit (the HTML created by your users) in
between the cfincludes . this will get around the .cfm problem & also stop
users from removing the cfincludes from the template.

b) write a AutoClose macro for word that saves the file as .cfm (I don't
really like this idea...)


> 2.Although the templates work really well--word insists on using.htm as
the
> default extension.
> Is there a way to change this default? If Not can I set up cf server to
> parse for all .htm extensions--
> convert to .cfm and upload to the live directory? can i schedule this
using
> the shcheduled events in cf server?
>



--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www

RE: JS CFM & SQL

2000-05-26 Thread B. Cravens

Keep in mind that CF is executed on the server, and JavaScript doesn't get
executed until the page is sent to the browser.  So JavaScript variables
aren't available to CF at run time.  The best way (though there are more
elegant solutions) would be to grab the JavaScript variables, then pass them
(via JavaScript) to the cfm page where the sql will take place.


h = screen.height;
location.href = "sqlpage.cfm?h=" + h;



-Original Message-
From: vinicius [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 01, 2000 2:30 AM
To: cftalk
Subject: JS CFM & SQL


Hi there, I'm trying to write in a database, a value passed by a JS

like:


h = screen.height;


Then I want to put it in SQL statement in a cfquery, how do I do it, I
tried:


INSERT Into table(height)
VALUES(h)


don't work.
Then I tried:

document.write(h);

don't work either, what else can I do?
thanks
Vinicius


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Site Dedsign Question (Try 2)

2000-05-26 Thread Sean Renet

I was presuming there would be more than one base template in different
cfcases and wanted to show him how it would look, but yes if there was only
one template it would not need a cfswitch.
- Original Message -
From: "Eric Dawson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 26, 2000 5:47 AM
Subject: (DA): Site Dedsign Question (Try 2)


> Couldn't this be shortened to:
> <---app_globals.cfm--->
> 
> 
>
> <---index.cfm--->
> 
>
> 
>
> 
> ==
>
> Note: you would need to use the cfswitch if you were calling different
> customtags based on the attributes.somesttribute value.
>
> ??
> E
>
> From: "Sean Renet" <[EMAIL PROTECTED]>
> Date: Thu, 25 May 2000 23:40:03 -0700
>
> Make 4 templates and cut and paste the appropriate code in
> each
> <---app_globals.cfm--->
> 
> 
>
> <---index.cfm--->
> 
> 
>   
>
> 
>
>   
>   
>
>
>
>   
>   
>
>
>
>   
> 
>
>
> 
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: IIS,Virtual Directorys and CF?

2000-05-26 Thread malcolm mcatee

Thanks for your help, but I have resolved this.
My virtual directory worked fine I just could not get CF server to
process .cfm files located on the other machine.
My fix:
Under services in the NT control Panel,
I selected Cold fusion application server
in the "Log In As" portion of the dialog box
I changed from the default system user to (in my case)
Administrator--stopped and restarted the service--
and everything worked!


-Original Message-
From: Olive, Christopher M Mr USACHPPM
[mailto:[EMAIL PROTECTED]]
Sent: Friday, May 26, 2000 12:49 PM
To: '[EMAIL PROTECTED]'
Subject: RE: IIS,Virtual Directorys and CF?


create a virtual directory in IIS, point it to a "different machine" (an
option in  the create VD screen), and use a UNC to tell it where to look.
mapping a drive will only work if you map is as the service in whose context
the CF server runs.

Chris Olive,
DOEHRS Website Administrator

-Original Message-
From: malcolm mcatee [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 25, 2000 2:38 PM
To: [EMAIL PROTECTED]
Subject: RE: IIS,Virtual Directorys and CF?


Can I host .cfm files on a different server than my cold fusion server?
I am currently hosting all my .cfm files on an NT server running coldfusion.
For security reasons I would like to be able  host my .cfm intranet files on
our novell server. I have been succesful setting up a virtual directory that
allows
the nt server to view directorys and files that are located on the novell
box ,
but when i call a .cfm page I get a 404 error.
Do I need to change my root development
mapping on the cold fusion server? I have tried to browse to the novell
machine
but cf only sees local drives.

Help please!
Malcolm

-Original Message-
From: malcolm mcatee [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 24, 2000 10:57 AM
To: [EMAIL PROTECTED]
Subject: RE: IIS,Virtual Directorys and CF?


Thanks for your response---
I have not had any trouble w/ users editing the cf_includes
They are invisible when the document is viewed in word unless you choose
view html source---Most of my users are not advanced enough to know what
view html source even means. I did not really understand the rest of your
explanation.

I have never created a macro before---Can I attach this to the template?
Why do you not like this idea?


-Original Message-
From: Justin MacCarthy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 24, 2000 10:41 AM
To: [EMAIL PROTECTED]
Subject: Re: IIS,Virtual Directorys and CF?


Hi Malcolm,

I' m a little confused by the first part of the question - however I have
some suggestions of the no2.

a) Don't include the cfinlcude etc in your Word Template , instead create a
handler which includes the middle bit (the HTML created by your users) in
between the cfincludes . this will get around the .cfm problem & also stop
users from removing the cfincludes from the template.

b) write a AutoClose macro for word that saves the file as .cfm (I don't
really like this idea...)


> 2.Although the templates work really well--word insists on using.htm as
the
> default extension.
> Is there a way to change this default? If Not can I set up cf server to
> parse for all .htm extensions--
> convert to .cfm and upload to the live directory? can i schedule this
using
> the shcheduled events in cf server?
>



--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Avoiding using the MAX function

2000-05-26 Thread Paul Hastings

> MS made sure that @@IDENTITY is maintain per table & per connection. 

um thats per connection.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



[french] tres court : emploi

2000-05-26 Thread Yannick Simon

RE: Cold Fusion and NT PasswordsNous avons de gros projets en cours pour
faire une v2 du site Rue Du Commerce. Je ne souhaite pas polluer cette liste
géniale, mais si vous etes interessé, je cherche un tres bon developpeur,
sur Paris Nord, un an d'experience cold fusion pour des projets dans une
boite super ... vous etes interessé, envoyez moi votre cv ... vous me
trouvez qq'un pour le poste ? je vous promets une prime de cooptation.

pardon de cette intrusion.

Yannick Simon


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: IIS,Virtual Directorys and CF?

2000-05-26 Thread Olive, Christopher M Mr USACHPPM

create a virtual directory in IIS, point it to a "different machine" (an
option in  the create VD screen), and use a UNC to tell it where to look.
mapping a drive will only work if you map is as the service in whose context
the CF server runs.

Chris Olive,
DOEHRS Website Administrator 

-Original Message-
From: malcolm mcatee [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 25, 2000 2:38 PM
To: [EMAIL PROTECTED]
Subject: RE: IIS,Virtual Directorys and CF?


Can I host .cfm files on a different server than my cold fusion server?
I am currently hosting all my .cfm files on an NT server running coldfusion.
For security reasons I would like to be able  host my .cfm intranet files on
our novell server. I have been succesful setting up a virtual directory that
allows
the nt server to view directorys and files that are located on the novell
box ,
but when i call a .cfm page I get a 404 error.
Do I need to change my root development
mapping on the cold fusion server? I have tried to browse to the novell
machine
but cf only sees local drives.

Help please!
Malcolm

-Original Message-
From: malcolm mcatee [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 24, 2000 10:57 AM
To: [EMAIL PROTECTED]
Subject: RE: IIS,Virtual Directorys and CF?


Thanks for your response---
I have not had any trouble w/ users editing the cf_includes
They are invisible when the document is viewed in word unless you choose
view html source---Most of my users are not advanced enough to know what
view html source even means. I did not really understand the rest of your
explanation.

I have never created a macro before---Can I attach this to the template?
Why do you not like this idea?


-Original Message-
From: Justin MacCarthy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 24, 2000 10:41 AM
To: [EMAIL PROTECTED]
Subject: Re: IIS,Virtual Directorys and CF?


Hi Malcolm,

I' m a little confused by the first part of the question - however I have
some suggestions of the no2.

a) Don't include the cfinlcude etc in your Word Template , instead create a
handler which includes the middle bit (the HTML created by your users) in
between the cfincludes . this will get around the .cfm problem & also stop
users from removing the cfincludes from the template.

b) write a AutoClose macro for word that saves the file as .cfm (I don't
really like this idea...)


> 2.Although the templates work really well--word insists on using.htm as
the
> default extension.
> Is there a way to change this default? If Not can I set up cf server to
> parse for all .htm extensions--
> convert to .cfm and upload to the live directory? can i schedule this
using
> the shcheduled events in cf server?
>



--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: cfmail

2000-05-26 Thread Howell, Katie

Thanks Steve, that's exactly what I wanted to do, my email addresses are
stored in a table, and I was going to base the cfmail on the results of the
query.

Answers my question.  Now I can start the holiday weekend early with a clear
conscience!

Katie

-Original Message-
From: Steve Martin [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 26, 2000 12:18 PM
To: [EMAIL PROTECTED]
Subject: RE: cfmail


I think there's a little confusion here. There may be some restriction to
the number of email addresses allowed in the to: field, but that's of no
consequence as you can use cfmail in conjunction with a query to iterate
over many email addresses and send one email, with one recipient in the to:
field to as many email addresses as you want.
e.g.

SELECT email
FROM sometable


Body of email


Steve

> -Original Message-
> From: Howell, Katie [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 26, 2000 17:03
> To: [EMAIL PROTECTED]
> Subject: cfmail
>
>
> Does CFMAIL still restrict you to 40 email address?  If so,
> what's the work
> around.
>
> Thanks,
>
> Katie
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
> _talk or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
>


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: CFFILE question

2000-05-26 Thread Jim McAtee

You're pretty much on your own.  CFFILE provides just simple means of
modifying and working with files within the file system.  For fixed width
columns, I usually use the LeftJustify() function, something like:





  
  
  
  
  





If the file is relatively small, construct the whole file in memoroy
whithin a variable, as shown above.  If you're writing a multi-megabyte
file, you can use  and append one or ten or fifty
(or whatever) lines at a time, so that the memory requirements of the
template are less.

Jim



-Original Message-
From: Marlene Buffa <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Friday, May 26, 2000 10:06 AM
Subject: CFFILE question


How do we do the following:
Create a fixed ASCII text file with .

How do you specify  the picture or format length for a given
column?

marlene

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: cfmail

2000-05-26 Thread Steve Martin

I think there's a little confusion here. There may be some restriction to
the number of email addresses allowed in the to: field, but that's of no
consequence as you can use cfmail in conjunction with a query to iterate
over many email addresses and send one email, with one recipient in the to:
field to as many email addresses as you want.
e.g.

SELECT email
FROM sometable


Body of email


Steve

> -Original Message-
> From: Howell, Katie [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 26, 2000 17:03
> To: [EMAIL PROTECTED]
> Subject: cfmail
>
>
> Does CFMAIL still restrict you to 40 email address?  If so,
> what's the work
> around.
>
> Thanks,
>
> Katie
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
> _talk or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: cfmail

2000-05-26 Thread Eron Cohen

Katie,

I think that restriction still stands, however, I don't find it to be a
problem at all.  The actual restriction is just that you can't have 40 email
addresses AT THE SAME TIME in TO="" field.  The restriction doesn't apply if
you use QUERY= and just output the email addresses from a query one at a
time.  Therefore, as long as you don't actually want all of the email
addresses listed in the TO: area of the message at the same time, you could
just do a "fake" query and then CFMAIL based on that.

By fake query, I mean that you can use QueryNew(), QueryAddRow() and
QuerySetCell() to create a query that contains the email addresses.  (Or
better yet, actually put your email addresses into a database and actually
DO a query.)

I hope I've understood your issue correctly and that this is helpful.


Eron


-Original Message-
From: Howell, Katie [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 26, 2000 12:03 PM
To: [EMAIL PROTECTED]
Subject: cfmail


Does CFMAIL still restrict you to 40 email address?  If so, what's the work
around.

Thanks,

Katie

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Cold Fusion and NT Passwords

2000-05-26 Thread Cold Fusion Newsgroup

Mark,

Unfortunately, I inherited this installation so am not sure if it was
installed with all defaults but I assume so.  I do know that it had to be
installed as Administrator.

Am I setting the security within CF Server or NT?  If it's CF, I'll need
some specific info as I'm relatively new to CF (I come from a VB/ASP
background).

Thanks,

Laura


- Original Message -
From: Mark Warrick <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 26, 2000 12:07 PM
Subject: RE: Cold Fusion and NT Passwords


> Make sure that your CF Server service is running with the correct security
> permissions to access those files.
>
> For example, if you installed it with all defaults and were logged in as
the
> Administrator at the time, you can let "SYSTEM" have full control to all
> those files without affecting your clients access rights.
>
> ---mark
>
>
> -
> Mark Warrick
> (714) 939-6431
> The Sistonia Corporation
> [EMAIL PROTECTED]
> http://www.sistonia.com
>
> > -Original Message-
> > From: Cold Fusion Newsgroup [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, May 26, 2000 6:32 AM
> > To: [EMAIL PROTECTED]
> > Subject: Cold Fusion and NT Passwords
> >
> >
> > This is a multi-part message in MIME format.
> >
> > --=_NextPart_000_001F_01BFC6F5.4E6FCC20
> > Content-Type: text/plain;
> > charset="iso-8859-1"
> > Content-Transfer-Encoding: quoted-printable
> >
> > Hi,
> >
> > I am having a problem using Cold Fusion with directories using NT's =
> > basic authentication.  We have approvals directories set up for our =
> > clients using NT passwords.  Once the client accesses an html page =
> > inside the password protected directory, they can't seem to access any =
> > cfm pages to run queries, etc.  the cold fusion server resides at an =
> > upper level directory outside of the password protected area and must =
> > remain there.
> >
> > Has anyone experienced a similar problem, and if so, what can be done to
=
> > get CF to work in those directories. =20
> >
> > Thanks,
> >
> > Laura
> >
> > --=_NextPart_000_001F_01BFC6F5.4E6FCC20
> > Content-Type: text/html;
> > charset="iso-8859-1"
> > Content-Transfer-Encoding: quoted-printable
> >
> > 
> > 
> >  > http-equiv=3DContent-Type>
> > 
> > 
> > 
> > 
> > 
> > Hi,
> >  
> > I am having a problem using Cold Fusion with =
> > directories using=20
> > NT's basic authentication.  We have approvals directories set up =
> > for our=20
> > clients using NT passwords.  Once the client accesses an html page
=
> > inside=20
> > the password protected directory, they can't seem to access any cfm =
> > pages to run=20
> > queries, etc.  the cold fusion server resides at an upper level =
> > directory=20
> > outside of the password protected area and must remain =
> > there.
> >  
> > Has anyone experienced a similar problem, and if so,
=
> > what can=20
> > be done to get CF to work in those directories.  
> >  
> > Thanks,
> >  
> > Laura
> >
> > --=_NextPart_000_001F_01BFC6F5.4E6FCC20--
> >
> > --
> > 
> > Archives: http://www.eGroups.com/list/cf-talk
> > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
> > _talk or send a message to [EMAIL PROTECTED] with
> > 'unsubscribe' in the body.
> >
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Killing Session & Back Button

2000-05-26 Thread Mark Warrick

I use the following code to kill session variables.


#StructClear(session)#


If, by chance, a user tries to backup, all they are going to see is the same
thing that they saw before the hit the logout button.  If they try to do
anything else, my security logic kicks them back to the login page.

---mark



-
Mark Warrick
(714) 939-6431
The Sistonia Corporation
[EMAIL PROTECTED]
http://www.sistonia.com

> -Original Message-
> From: Steve Reich [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 25, 2000 11:48 AM
> To: CF Talk
> Subject: Killing Session & Back Button
>
>
> I have a link on my site for users to log out. This takes them to a page
> that kills all session variables and then directs them back to the login
> page. However, if they hit the back button, they can get back to
> where they
> were when they logged out, refresh the page, and their variables
> are reset.
> How can I kill the variables so the page isn't available with the back
> button without them?
>
> TIA
>
>
> ~~
> Steve Reich
> Backsoft Corporation
> 6960 Professional Parkway East
> Suite 100
> Sarasota, Florida 34240
> Toll Free: (888) 222-6047
> Phone: (941) 907-6655 - Ext.1038
> Fax: (941) 907-6643
>
> email: [EMAIL PROTECTED]
> web: http://www.backsoft.com
>
> "Any sufficiently advanced technology
>  is indistinguishable from magic."
>
>   - Arthur C. Clarke
> ~~
>
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
> _talk or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Installing CF 4.5 Professional over 4.5 Enterprise Evaluation

2000-05-26 Thread Mark Warrick

DOCUMENT all your settings.  Remove CF 4.5 Enterprise, load the Pro edition.
You might or might not have to setup all those settings again, but so long
as you have documentation, you have nothing to worry about.

---mark


-
Mark Warrick
(714) 939-6431
The Sistonia Corporation
[EMAIL PROTECTED]
http://www.sistonia.com

> -Original Message-
> From: Angél Stewart [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 25, 2000 10:22 AM
> To: [EMAIL PROTECTED]
> Subject: Installing CF 4.5 Professional over 4.5 Enterprise Evaluation
>
>
> Well..the subject says it all.
> What do you folks suggest I do?
>
> I have Ablecommerce hooked into the 4.5 Evaluation server, and
> the system is
> set up the way I want it now.
> The company, however, decided to buy the PROFESSIONAL version, instead of
> the evaluation
> *ahem*
>
> I have a few websites that we remade with coldfusion, with OLE DB
> Datasources set up and all that as well over the thirty day period..and it
> all works fine..
>
> I don't want to have to set everthing up again..sooo..can I just
> install the
> CF4.5 Professional in the same CF directory?
>
> Or would I have to uninstall and lose all settings?
>
> -Gel
>
>
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
> _talk or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



OT: Windows Auto ShutDown

2000-05-26 Thread spadea ho

This is a multi-part message in MIME format.

--=_NextPart_000_0050_01BFC770.E00742A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi!

Sorry to ask this, but does anyone know how you can automatically =
shutdown
in Win98 and Win2000 without having to go thru' that radio buttion =
selection panel?

Thanks!
>spadea...

--=_NextPart_000_0050_01BFC770.E00742A0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable








Hi!
 
Sorry to ask this, but does anyone know =
how you can=20
automatically shutdown
in Win98 and Win2000 without having to =
go thru'=20
that radio buttion selection panel?
 
Thanks!
>spadea...

--=_NextPart_000_0050_01BFC770.E00742A0--

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: IIS,Virtual Directorys and CF?

2000-05-26 Thread Mark Warrick

Map a network drive to the remote server.  Then, setup a mapping in the CF
Server Administrator to that mapped network drive.  It should work fine from
there.

---mark


-
Mark Warrick
(714) 939-6431
The Sistonia Corporation
[EMAIL PROTECTED]
http://www.sistonia.com

> -Original Message-
> From: malcolm mcatee [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, May 25, 2000 11:38 AM
> To: [EMAIL PROTECTED]
> Subject: RE: IIS,Virtual Directorys and CF?
>
>
> Can I host .cfm files on a different server than my cold fusion server?
> I am currently hosting all my .cfm files on an NT server running
> coldfusion.
> For security reasons I would like to be able  host my .cfm
> intranet files on
> our novell server. I have been succesful setting up a virtual
> directory that
> allows
> the nt server to view directorys and files that are located on the novell
> box ,
> but when i call a .cfm page I get a 404 error.
> Do I need to change my root development
> mapping on the cold fusion server? I have tried to browse to the novell
> machine
> but cf only sees local drives.
>
> Help please!
> Malcolm
>
> -Original Message-
> From: malcolm mcatee [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 24, 2000 10:57 AM
> To: [EMAIL PROTECTED]
> Subject: RE: IIS,Virtual Directorys and CF?
>
>
> Thanks for your response---
> I have not had any trouble w/ users editing the cf_includes
> They are invisible when the document is viewed in word unless you choose
> view html source---Most of my users are not advanced enough to know what
> view html source even means. I did not really understand the rest of your
> explanation.
>
> I have never created a macro before---Can I attach this to the template?
> Why do you not like this idea?
>
>
> -Original Message-
> From: Justin MacCarthy [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 24, 2000 10:41 AM
> To: [EMAIL PROTECTED]
> Subject: Re: IIS,Virtual Directorys and CF?
>
>
> Hi Malcolm,
>
> I' m a little confused by the first part of the question - however I have
> some suggestions of the no2.
>
> a) Don't include the cfinlcude etc in your Word Template ,
> instead create a
> handler which includes the middle bit (the HTML created by your users) in
> between the cfincludes . this will get around the .cfm problem & also stop
> users from removing the cfincludes from the template.
>
> b) write a AutoClose macro for word that saves the file as .cfm (I don't
> really like this idea...)
>
>
> > 2.Although the templates work really well--word insists on using.htm as
> the
> > default extension.
> > Is there a way to change this default? If Not can I set up cf server to
> > parse for all .htm extensions--
> > convert to .cfm and upload to the live directory? can i schedule this
> using
> > the shcheduled events in cf server?
> >
>
>
> --
> --
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> --
> --
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
> _talk or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Oracle Stored Procedures

2000-05-26 Thread mylists



   Hi,

   I'm having a heck of a time getting one particular Stored
   Procedure to work with CF and Oracle. I keep getting a
   "ORA-01036 Illegal Variable Name/Number" error. This
works
   just fine from SQL*Plus, but from CF all I get is the
error.
   Here's the code I'm using to invoke the SP:

   
   
   
   
   
   
   
   
   

   And here's the SP code:

   function
   set_unicenter_flag (v_dir in varchar, v_file in
varchar,
   v_slsfc in varchar)

   RETURN NUMBER
   IS
   fptr utl_file.file_type;
   BEGIN

   fptr := utl_file.fopen(v_dir,v_file,'a');

   if utl_file.Is_open(fptr)
   then
   utl_file.putf(fptr,'SLSFC:%s Execution time: %s
   Oracle ID: %s',v_slsfc, to_char(sysdate,'mm-dd-
   hh24:mi:ss'), user);

   utl_file.fclose(fptr);
   return 0;
   else
   return -1;
   end if;

   EXCEPTION
 WHEN UTL_FILE.INVALID_PATH THEN
   DBMS_OUTPUT.PUT_LINE('Invalid Path');
   RETURN 1;

 WHEN UTL_FILE.INVALID_OPERATION THEN
   DBMS_OUTPUT.PUT_LINE('Invalid Operation');
   RETURN 2;

 WHEN UTL_FILE.INVALID_MODE THEN
   DBMS_OUTPUT.PUT_LINE('Invalid Mode');
   RETURN 3;

 WHEN UTL_FILE.READ_ERROR THEN
   DBMS_OUTPUT.PUT_LINE('Read Error');
   RETURN 4;

 WHEN UTL_FILE.WRITE_ERROR THEN
   DBMS_OUTPUT.PUT_LINE('Write Error');
   RETURN 5;

 WHEN OTHERS THEN
   DBMS_OUTPUT.PUT_LINE('Other Error');
   RETURN -1;
   END;


   Any ideas?

   Howard
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: Cold Fusion and NT Passwords

2000-05-26 Thread Mark Warrick

Make sure that your CF Server service is running with the correct security
permissions to access those files.

For example, if you installed it with all defaults and were logged in as the
Administrator at the time, you can let "SYSTEM" have full control to all
those files without affecting your clients access rights.

---mark


-
Mark Warrick
(714) 939-6431
The Sistonia Corporation
[EMAIL PROTECTED]
http://www.sistonia.com

> -Original Message-
> From: Cold Fusion Newsgroup [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 26, 2000 6:32 AM
> To: [EMAIL PROTECTED]
> Subject: Cold Fusion and NT Passwords
>
>
> This is a multi-part message in MIME format.
>
> --=_NextPart_000_001F_01BFC6F5.4E6FCC20
> Content-Type: text/plain;
>   charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> Hi,
>
> I am having a problem using Cold Fusion with directories using NT's =
> basic authentication.  We have approvals directories set up for our =
> clients using NT passwords.  Once the client accesses an html page =
> inside the password protected directory, they can't seem to access any =
> cfm pages to run queries, etc.  the cold fusion server resides at an =
> upper level directory outside of the password protected area and must =
> remain there.
>
> Has anyone experienced a similar problem, and if so, what can be done to =
> get CF to work in those directories. =20
>
> Thanks,
>
> Laura
>
> --=_NextPart_000_001F_01BFC6F5.4E6FCC20
> Content-Type: text/html;
>   charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> 
> 
>  http-equiv=3DContent-Type>
> 
> 
> 
> 
> 
> Hi,
>  
> I am having a problem using Cold Fusion with =
> directories using=20
> NT's basic authentication.  We have approvals directories set up =
> for our=20
> clients using NT passwords.  Once the client accesses an html page =
> inside=20
> the password protected directory, they can't seem to access any cfm =
> pages to run=20
> queries, etc.  the cold fusion server resides at an upper level =
> directory=20
> outside of the password protected area and must remain =
> there.
>  
> Has anyone experienced a similar problem, and if so, =
> what can=20
> be done to get CF to work in those directories.  
>  
> Thanks,
>  
> Laura
>
> --=_NextPart_000_001F_01BFC6F5.4E6FCC20--
>
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
> _talk or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: grouping with math functions

2000-05-26 Thread Deanna L. Schneider

Oh yea! I'm glad to hear that what I'm trying to do is actually complex, and
it's not just my work-fried brain. ;)

Thanks for the help. I'll see where it gets me.

-d




Deanna Schneider
Interactive Media Developer
UWEX Cooperative Extension Electronic Publishing Group
103 Extension Bldg
432 N. Lake Street
Madison, WI 53706
(608) 265-7923



--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: cfmail

2000-05-26 Thread Mark Warrick

I'm not sure that there is a limit per say on how many can go out at once,
however I do know that CFMAIL is known to be fairly flaky.

How many emails do you need to send out at once?

Do you have access to your own mail server?

---mark

-
Mark Warrick
(714) 939-6431
The Sistonia Corporation
[EMAIL PROTECTED]
http://www.sistonia.com

> -Original Message-
> From: Howell, Katie [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 26, 2000 9:03 AM
> To: [EMAIL PROTECTED]
> Subject: cfmail
>
>
> Does CFMAIL still restrict you to 40 email address?  If so,
> what's the work
> around.
>
> Thanks,
>
> Katie
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
> _talk or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Replacement for CFHTTP

2000-05-26 Thread Jim McAtee

Does Express support custom tags?  If so, there are a couple
(cfx_delimtoquery is one) that do this from a local file.
Cfx_delimtoquery can't pull files from remote servers via http, however.

Jim


-Original Message-
From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Thursday, May 25, 2000 1:32 PM
Subject: Replacement for CFHTTP


I'm trying to set up a laptop so a client can view his site locally using
CFExpress...

Short of going to another CFServer license, can anyone suggest a
workaround for some
code where I use the (CFExpress-unsupported) CFHTTP tag to read a
tab-delimited text file
and create a query object from it?

Gene Kraybill
LPW & Associates

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Running ClusterCats through proxy - Solution

2000-05-26 Thread Dave Wilson

Hi all,

I posted this problem to the list several days ago but got no response.
Turns, out I've found a workaround to the problem - see transcript between
myself and colleague who had the problem below. Might be useful for some of
you working on clustered intranet/extranet scenarios with sites connecting
via proxies, not wishing to utilise DNS for whatever reasons.

*
The proxy servers/hosts file was the key!!!

Problem: To connect to our web servers we are going through a proxy server.
We were connecting to the server from the client using IP addresses.
Everything works fine. However if the server dies and clustercats kicks in,
the secondary server will take control. However the browser will be told to
request information from the secondary server but instead of using its IP it
uses its machine name instead which cannot be resolved. The problem lies in
that the browser routes all requests to the proxy server which tries to
resolve address. Because we are using an IP address for the primary server
this is not a problem, but for the secondary we are using a machine name
which cannot be resolved so it fails.

Solution: stick the ip/machine name into the hosts file for the proxy
server.

We are trying this out on the customers site next week, so hopefully all
will go well.

Simple when you know how. Thanks for the help, bang on the nose..

Gary.


-Original Message-
From: Dave Wilson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 25, 2000 12:35 PM
To: Gary Campbell
Subject: Re:

Gary,

Does the system have a fully qualified internet domain name
associated with
it? If so, then what you will need to do is use static IP's
for each of the
web servers, then have host entries in (Internet) DNS for
each machine.

e.g. you have two webservers in a cluster called
ww1.dartuk.com and
ww2.dartuk.com
When the client connects to ww1.dartuk.com and it fails,
they will be
redirected to ww2.dartuk.com. You cluster would be known as
dartuk.com. The
internet DNS zone file will handle the IP resolution (Use
Round Robin DNS to
add a second tier to your load balancing solution). As a
safeguard, you
could also, perhaps edit the hosts files found in
winnt/system32/drivers/etc/ folder on each of the proxy
servers at client
locations to include records pointing to each host of the
system similar to
this:

123.45.67.8 ww1.dartuk.com
123.45.67.9 ww2.dartuk.com

This helps because NT queries it's local hosts file before
carrying out DNS
queries.

Hope some of these ideas help you out, I'm just thinking out
loud and some
may be inapplicable to your specific setup.


Dave Wilson
Internet Technology Manager,
BizNet Solutions


Co-Founder CFUG Ireland
http://www.cfug.ie

224, Lisburn Road
Belfast BT9 6GE

Tel: 02890 225 776
Fax: 02890 223 223
web: http://www.biznet-solutions.com

email: [EMAIL PROTECTED]
- Original Message -
From: Dave Wilson <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 24, 2000 3:09 PM
Subject: ClusterCats through proxy


> Hi all,
>
> I have a colleague who is looking advice for implementing ClusterCats
whilst
> behind a proxy server. They have no problems getting the failover to work,
> but what happens is that the failover resolves to an internal IP which is
> (obviously) inaccessible to the public users.
>
> Quote from colleague
> ***
> As described previously we are using two Enterprise servers, in a standard
> primary/secondary configuration. If the primary fails then the secondary
> will take over processing.
>
> Can you give me an indication if you help us with the following
>
> 1) I want to be able to connect a client to the server through a proxy
> server.
> 2) Then I want to "crash" the primary so that the secondary will take
> over processing
> 3) The secondary will proceed to server live pages as normal
>
> We have tried it over here, but we run into problems of DNS names. The
live
> customers site is worldwide so we were going to use IP address to connect
to
> the system. I know this is not the best solution but I'm open to another
> other ideas, which do not entail a re-configuration of the network. When
we
> connect to the primary with an IP - no problems, however on failure, we do
> get rolled over to the secondary but because the client is given a DNS
name
> it can't resolve it so it fails.
> ***
> MY colleague is also running SQL server database, so I have suggested that
> he simply move the two web servers to the public side of the proxy and
> maintain the db connection through the proxy via dedicated switch, hence
> protecting the data, which in essence is pretty much all that needs
> protecting.
>
>
> Does anyone have any better ideas for this?
>
> TIA
>
> Dave
>
> Dave Wilson
> Internet Technology Manager,
> BizNet Solutions
>
> 
> Co-Founder CFUG Ireland
> http://www.cfug.ie
>
> 224, Lisburn Road
> Belfast BT9 6GE
>
> Tel: 02890 225 776

CFFILE question

2000-05-26 Thread Marlene Buffa

How do we do the following:
Create a fixed ASCII text file with .

How do you specify  the picture or format length for a given 
column?

marlene

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Developer Conference: Hotel Accommodations

2000-05-26 Thread Larry C. Lyons

Also you may want to look at some of the hotels in Maryland or Virgina.
With the DC Metro System relatively close to the hotel, it may be an
advantage to stay somewhat further away.

larry

-- 
Larry C. Lyons
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.
--

"Hales, John M" wrote:
> 
> John,
> 
> I'm sure you can find better deals. The conference hotel is right on the
> Metro, so you can stay almost anywhere in DC. Heck, for  $200 I'll rent you
> my apartment which is only 6 blocks from the conference.
> 
> Mike
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



cfmail

2000-05-26 Thread Howell, Katie

Does CFMAIL still restrict you to 40 email address?  If so, what's the work
around.

Thanks,

Katie
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: best way to display picture after cffile

2000-05-26 Thread Larry C. Lyons

Jeff,

You need some way of checking to see if the file exists, such as this:




 
 

RE: (DA): Site Dedsign Question (Try 2)

2000-05-26 Thread Mark Warrick

Sure, it can be shortened.  However, Sean was giving you an example of
Fusebox style programming.

-
Mark Warrick
(714) 939-6431
The Sistonia Corporation
[EMAIL PROTECTED]
http://www.sistonia.com

> -Original Message-
> From: Eric Dawson [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 26, 2000 5:47 AM
> To: [EMAIL PROTECTED]
> Subject: (DA): Site Dedsign Question (Try 2)
>
>
> Couldn't this be shortened to:
> <---app_globals.cfm--->
> 
> 
>
> <---index.cfm--->
> 
>
> 
>
> 
> ==
>
> Note: you would need to use the cfswitch if you were calling different
> customtags based on the attributes.somesttribute value.
>
> ??
> E
>
> From: "Sean Renet" <[EMAIL PROTECTED]>
> Date: Thu, 25 May 2000 23:40:03 -0700
>
> Make 4 templates and cut and paste the appropriate code in
> each
> <---app_globals.cfm--->
> 
> 
>
> <---index.cfm--->
> 
> 
>   
>
> 
>
>   
>   
>
>
>
>   
>   
>
>
>
>   
> 
>
>
> 
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> --
> 
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf
> _talk or send a message to [EMAIL PROTECTED] with
> 'unsubscribe' in the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Oracle Stored Procedures

2000-05-26 Thread mylists

Hi,

I'm having a heck of a time getting one particular Stored
Procedure to work with CF and Oracle. I keep getting a
"ORA-01036 Illegal Variable Name/Number" error. This works
just fine from SQL*Plus, but from CF all I get is the error.
Here's the code I'm using to invoke the SP:











And here's the SP code:

function
set_unicenter_flag (v_dir in varchar, v_file in varchar,
v_slsfc in varchar)

RETURN NUMBER
IS
fptr utl_file.file_type;
BEGIN

fptr := utl_file.fopen(v_dir,v_file,'a');

if utl_file.Is_open(fptr)
then
utl_file.putf(fptr,'SLSFC:%s   Execution time: %s
Oracle ID: %s',v_slsfc, to_char(sysdate,'mm-dd-
hh24:mi:ss'), user);

utl_file.fclose(fptr);
return 0;
else
return -1;
end if;

EXCEPTION
  WHEN UTL_FILE.INVALID_PATH THEN
DBMS_OUTPUT.PUT_LINE('Invalid Path');
RETURN 1;

  WHEN UTL_FILE.INVALID_OPERATION THEN
DBMS_OUTPUT.PUT_LINE('Invalid Operation');
RETURN 2;

  WHEN UTL_FILE.INVALID_MODE THEN
DBMS_OUTPUT.PUT_LINE('Invalid Mode');
RETURN 3;

  WHEN UTL_FILE.READ_ERROR THEN
DBMS_OUTPUT.PUT_LINE('Read Error');
RETURN 4;

  WHEN UTL_FILE.WRITE_ERROR THEN
DBMS_OUTPUT.PUT_LINE('Write Error');
RETURN 5;

  WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('Other Error');
RETURN -1;
END;


Any ideas?

Howard
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: grouping with math functions

2000-05-26 Thread John Westerlund

BTW i think if you put an INDEX in the CFOUTPUT then it will tell you which
number of the loop you are on... See a reference for more info...

- Original Message -
From: Deanna L. Schneider <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 26, 2000 7:48 AM
Subject: Re: grouping with math functions


> What I want is the to get all the trials that have BOTH variety 1 and
> variety 2 (chosen by the user) and that also meet the state and year
> criteria (also chosen by the user). Then, I need to determine the average
> yield by variety, and figure out the percent of variety one, by variety
two
> for each "stand age". I'm getting the "raw" data that I need with my
> plethora of queries - i.e. I'm limiting the data to only those trials that
> involve both varieties and meet state and year criteria, and I'm getting
the
> avg yield for each variety by stand age. What I can't figure out how to do
> is to get the results set to variables that I can then divide by each
other.
>
> For example, I'd like to be able to say:
>
> 
>  <---How do I tell it "which"
> yieldage?
> 
> 
> 
>
> But, I can't figure out how to set the variables correctly while using the
> implicit loop. (i.e. is there a counter to tell me which variety is being
> outputted at a specific time?)
>
> By the way, John: thanks, but variety is just the name of the variety, not
> the yield.
>
> Make sense?
>
> I know there's probably an easier way to do the sql, but I got my head
stuck
> in this trap, and I haven't been able to figure out the sql. This isn't a
> site where they're worried about speedy performance, so it's not a huge
> issue.
>
> thanks,
> d
>
>
>
>
> 
> Deanna Schneider
> Interactive Media Developer
> UWEX Cooperative Extension Electronic Publishing Group
> 103 Extension Bldg
> 432 N. Lake Street
> Madison, WI 53706
> (608) 265-7923
>
>
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: grouping with math functions

2000-05-26 Thread John Westerlund

You should use the SQL to grab the variable
SELECT SUM(fieldname) WHERE variety = 'parameter' AS variabletouse

which is much easier than building a lot of constructs to loop and total the
data. hmm which makes me wonder can you do:
SELECT AVERAGE(fieldname) WHERE var = 'param' AS soandso

If former then do 
and numberformat it.

Sorry if that didnt get you any further. The formula you need is complex and
a little bit hard to visualize..

Where is Dave Watts when you need him?


- Original Message -
From: Deanna L. Schneider <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 26, 2000 7:48 AM
Subject: Re: grouping with math functions


> What I want is the to get all the trials that have BOTH variety 1 and
> variety 2 (chosen by the user) and that also meet the state and year
> criteria (also chosen by the user). Then, I need to determine the average
> yield by variety, and figure out the percent of variety one, by variety
two
> for each "stand age". I'm getting the "raw" data that I need with my
> plethora of queries - i.e. I'm limiting the data to only those trials that
> involve both varieties and meet state and year criteria, and I'm getting
the
> avg yield for each variety by stand age. What I can't figure out how to do
> is to get the results set to variables that I can then divide by each
other.
>
> For example, I'd like to be able to say:
>
> 
>  <---How do I tell it "which"
> yieldage?
> 
> 
> 
>
> But, I can't figure out how to set the variables correctly while using the
> implicit loop. (i.e. is there a counter to tell me which variety is being
> outputted at a specific time?)
>
> By the way, John: thanks, but variety is just the name of the variety, not
> the yield.
>
> Make sense?
>
> I know there's probably an easier way to do the sql, but I got my head
stuck
> in this trap, and I haven't been able to figure out the sql. This isn't a
> site where they're worried about speedy performance, so it's not a huge
> issue.
>
> thanks,
> d
>
>
>
>
> 
> Deanna Schneider
> Interactive Media Developer
> UWEX Cooperative Extension Electronic Publishing Group
> 103 Extension Bldg
> 432 N. Lake Street
> Madison, WI 53706
> (608) 265-7923
>
>
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Developer Conference: Hotel Accomodations

2000-05-26 Thread Eva Holtsmark

Hi,
I love DC.  Try the Official Tourism Website of DC -
  search accomodations by price, and by location (DC, MD, VA)
  http://www.washington.org/planning/stay_search.html

> I am attending the Conference in November and am looking for recommendations for 
>accomodations.  Is $210 a reasonable rate?  Are there other hotels I should consider?

___
Eva
Senior Web Developer__

e:  [EMAIL PROTECTED]
v:  (202) 737-1030 x24
http://www.hskids-tmsc.org
Head Start Publications Management Center
__


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: Scoring Searches etc.

2000-05-26 Thread paul smith

At 10:28 AM 5/26/00 -0400, you wrote:
>ok question 2:
>Is there a decent way to allow a user to search on the search results?

I don't know if this is decent, but use Verity to
get a list of record IDs.
Then use the DB to scan those records (or use
M$ SQL7 full text search), and display results.


>question 3:  Is there an easy way to limit a page to 50 results at a time?
>(I know you can output 50 rows or the search query, I'm just curious how to
>get the 50 more)

Use Verity to get a list of record IDs.
Then display results 50 at a time.

best,  paul


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: POP

2000-05-26 Thread Grady Milhon

I might add that I was having problems with 4.5.1.  The new .dll was newer then
4.5.1.


I was using CFPOP on a mailbox to download over 1000 messages a day to an Access
Database.  It was running as a sch. task every 15 mins., and half the time it
would get an unknown error, unknown exception. I contacted Allaire support and
worked with them for over a week.  Then they sent me an updated libmime.dll and
I haven't had a problem since.  I suggest contacting them, they won't charge you
because it is a bug with CFPOP.

Grady Milhon
[EMAIL PROTECTED] 


Jason Clark wrote:
>
> Has anyone found a stable and fast alternative to CFPOP, its evident that
> CFPOP isn't ready for high volume use. Thanks
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: POP

2000-05-26 Thread Greg Saunders

At 08:31 AM 5/26/00 -0400, Jason Clark wrote:
>Has anyone found a stable and fast alternative to CFPOP, its evident that 
>CFPOP isn't ready for high volume use. Thanks

Can you provide some more details on your CFPOP problems?  How is it
failing?  What version of CF are you running, and on which OS?  Are others
experiencing problems also?

Gregory M. Saunders, Ph.D.
Senior Design Architect
Cognitive Arts Corporation (http://www.cognitivearts.com)
120 S. Riverside Plaza, Suite 1520
Chicago, IL 60606
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: [RE: Directory Structure Permissions]

2000-05-26 Thread Bob Smith

 Thanks Dave. Is there any default setting in CF Administrator we should be
aware of which may compromise security?
Bob Smith

[EMAIL PROTECTED] (Dave Watts) wrote:
> Is anyone aware of the minimum permissions to be granted to
> the directories housing cfm files(ie read,script,execute etc.)
> at both NT and IIS Levels.

You'll have to allow read-execute (RX) rights to the accounts used by the CF
Server and the web server (or web user, if you're using IIS and its
authentication; that user is typically IUSR_MACHINENAME). If you're running
NT 4 SP 4 or higher (or maybe SP 5, I forget) or Win2K, you can specify more
granular permissions; you might be able to allow the web user only read
rights, without execute.

In IIS, you'll need to allow script permissions, if you set the CF DLL to be
a script engine in the ISAPI configuration screen (I don't think it's a
script engine by default). If not, you'll need to allow execute permissions.

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



Get free email and a permanent address at http://www.amexmail.com/?A=1
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: grouping with math functions

2000-05-26 Thread Deanna L. Schneider

What I want is the to get all the trials that have BOTH variety 1 and
variety 2 (chosen by the user) and that also meet the state and year
criteria (also chosen by the user). Then, I need to determine the average
yield by variety, and figure out the percent of variety one, by variety two
for each "stand age". I'm getting the "raw" data that I need with my
plethora of queries - i.e. I'm limiting the data to only those trials that
involve both varieties and meet state and year criteria, and I'm getting the
avg yield for each variety by stand age. What I can't figure out how to do
is to get the results set to variables that I can then divide by each other.

For example, I'd like to be able to say:


 <---How do I tell it "which"
yieldage?




But, I can't figure out how to set the variables correctly while using the
implicit loop. (i.e. is there a counter to tell me which variety is being
outputted at a specific time?)

By the way, John: thanks, but variety is just the name of the variety, not
the yield.

Make sense?

I know there's probably an easier way to do the sql, but I got my head stuck
in this trap, and I haven't been able to figure out the sql. This isn't a
site where they're worried about speedy performance, so it's not a huge
issue.

thanks,
d





Deanna Schneider
Interactive Media Developer
UWEX Cooperative Extension Electronic Publishing Group
103 Extension Bldg
432 N. Lake Street
Madison, WI 53706
(608) 265-7923



--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: POP

2000-05-26 Thread Eron Cohen

Hi Jason,

I have definitely had my share of problems with CFPOP.  Allaire has made
some improvements to it in ColdFusion 4.5 and 4.51 though.

I also use CFX_iiPOP3, which was a $99 custom tag which I found on the
Allaire developers exchange.  It isn't perfect either, but it was definitely
more reliable than the CFPOP that was included with Cold Fusion 4.0x.

I currently use Post.Office 3.51 and I find I am still having trouble with
CFPOP that nobody else is reporting.  Some of the problems I have could be
on my mail-server's end of things.


HTH,

Eron

-Original Message-
From: Jason Clark [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 26, 2000 8:31 AM
To: [EMAIL PROTECTED]
Subject: POP

Has anyone found a stable and fast alternative to CFPOP, its evident that
CFPOP isn't ready for high volume use. Thanks



--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



RE: POP

2000-05-26 Thread Grady Milhon

I was using CFPOP on a mailbox to download over 1000 messages a day to an Access
Database.  It was running as a sch. task every 15 mins., and half the time it
would get an unknown error, unknown exception. I contacted Allaire support and
worked with them for over a week.  Then they sent me an updated libmime.dll and
I haven't had a problem since.  I suggest contacting them, they won't charge you
because it is a bug with CFPOP.

Grady Milhon
[EMAIL PROTECTED] 


Jason Clark wrote:
>
> Has anyone found a stable and fast alternative to CFPOP, its evident that
> CFPOP isn't ready for high volume use. Thanks
>
> --
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body
=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsu
bscribe' in the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=l
ists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubs
cribe' in the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



Re: grouping with math functions

2000-05-26 Thread John Westerlund

Try something like this.
> 

> 
> #totaltrials#
> #variety#
> #avgyield#

#trialpercent# %
> 

Is that what you are trying to do?
You can also use the NumberFormat(trialpercent, arg). You will want to look
it up to see how to set it to 1 or 2 decimal places.

- Original Message -
From: Deanna L. Schneider <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 26, 2000 6:53 AM
Subject: grouping with math functions


> Okay, let me re-state my question of yesterday.
>
> I have the results of a query printing out like so:
> Side By Side Results
> 
> Stand Age: #standage# Year
> 
> 
> Total Trials
> Variety
> Yield
> 
> 
>
> 
> #totaltrials#
> #variety#
> #avgyield#
> 
> 
> 
>
> Notice that I'm using the implicit loops that occur with .
>
> The problem is, what I really want to do is divide the first outputted avg
> yield by the second outputted avg yield and multiply by 100 to get a
> percentage. I'm thinking I might need to output into a structure or
> something, but I've never worked with structures, and I'm not even
positive
> this would be the best approach.
>
> Suggestions?
>
> Url is http://dev.cf.uwex.edu/ces/ag/alfalfa
>
> Thanks,
> Deanna
>
>
>
> 
> Deanna Schneider
> Interactive Media Developer
> UWEX Cooperative Extension Electronic Publishing Group
> 103 Extension Bldg
> 432 N. Lake Street
> Madison, WI 53706
> (608) 265-7923
>
>
>
> --

> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.



  1   2   >