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.Expiry

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

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, Listin

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, Retai

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_01B

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 s

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

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 compa

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 goin

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 BO

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

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 Warr

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-

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 wi

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?

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 d

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

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 -

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 th

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, sor

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

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 o

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 po

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: <[

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

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: F

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.

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

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 d

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 coll

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

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/lis

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.m

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

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.for

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

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

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? Actu

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

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

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 'cli

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 M

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

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 Con

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 > >-

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

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

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 n

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

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

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

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.co

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: h

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.

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

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: [EMA

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

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, F

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

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

[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

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 PROTE

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

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,

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

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=l

[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 b

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 -Orig

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 Marti

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 m

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: fi

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

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 C

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.

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 Corporat

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 witho

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 >

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

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 cl

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 Exte

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 S

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] <[EMAI

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 co

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

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

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=list

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]] >

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:

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

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 form

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 reasonabl

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.

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 c

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

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 b

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

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 r

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 upda

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: Dea

  1   2   >