Re: FW: Error Diagnostic Information ?

2002-07-22 Thread Brian Scandale
If I remember correctly... I would get these from time to time when my cfml was causing the CFserver to Restart. Usually associated with a query that was upsetting in some way. And always baffling until I tried the queries by pasting into another query tool or some such... Perhaps cf is throw

RE: CFMX CFM/JSP/Servlets/Beans Compile?

2002-07-22 Thread Joe Eugene
Thanks, but it looks like the code is using CFHTTP to run the pages.. i was looking to run some command line code using a *.bat file or some. something like Joe -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 1:47 AM To: CF-Talk Subject:

Re: CFMX CFM/JSP/Servlets/Beans Compile?

2002-07-22 Thread Brian Scandale
You can find this discussion in a thread responded to by Pete Ruckelshaus: 'CFMX Spidering for cache' on June 18th... I think it is cfml code that spiders some directories and compiles what it finds. It seems like this is something that should be built into the start procedures for CFMX... per

FW: Error Diagnostic Information ?

2002-07-22 Thread Michael Pool
OK. I never ask unless I am stumped. I'm sure somebody has run into this b/c when I do a search on the 'Net for the error, I get links to various other CFM web pages that have thrown the error while being indexed by the search engines. Here goes First the stats: Server: Windows NT 4.0 ~ I

MX Report - DB Client vars

2002-07-22 Thread Michael Dinowitz
Just a heads up for people. I had a reported problem on the HoF server that pointed to a CFAPPLICATION tag. The error message didn't say anything important and the tag was perfect. The only thing special about the tag was that it set client vars and saved it to a DB. I went into the admin to ch

Re: CFMX CFM/JSP/Servlets/Beans Compile?

2002-07-22 Thread Jon Hall
Yes there is, and it was posted to this list a while back. I can not find the message though. Try searching the archives. -- jon mailto:[EMAIL PROTECTED] Monday, July 22, 2002, 8:48:05 PM, you wrote: JE> Sorry for the Re-Post.. but does anybody have any ideas? JE> Hi All, JE> I was won

(Admin) Status

2002-07-22 Thread Michael Dinowitz
I've moved the server over to CFMX again and am hunting down exactly what causes the 500 errors that I get. I'm expecting that it's some chunk of code that's called on a schedule or rarely. Whatever it is, I'll find it. I don't expect any list outage until the error comes up and if/when it does

RE: CFMX CFM/JSP/Servlets/Beans Compile?

2002-07-22 Thread Joe Eugene
Sorry for the Re-Post.. but does anybody have any ideas? Hi All, I was wondering if there is a Command/Utility to compile JSP/CFM pages in CFMX.. like a comand line utility rather than having to RUN the the pages. How are Java Beans/Servlets compiled in CFMX? Do you

RE: SoEditor Pro

2002-07-22 Thread Matt Robertson
Peter Tilbrook Penned: > ActivEdit from http://www.cfdev.com is also a powerful > product. And dirt-simple to set up. You can integrate it into a solution that formerly used a textarea field in 5 minutes. --- Matt Robertson[EMAIL PROTECTED] MSB Designs,

RE: SoEditor Pro

2002-07-22 Thread Tilbrook, Peter
ActivEdit from http://www.cfdev.com is also a powerful product. -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 23 July 2002 4:23 AM To: CF-Talk Subject: SoEditor Pro Hello, We are just about to purchase the SoEditor pro wysiwyg editor form www.siteobj

RE: remove chars from string

2002-07-22 Thread S . Isaac Dealey
> so is this: > > REReplaceNoCase (string, '[^a-z0-9]', '', 'all') > > the same as this: > > REReplaceNoCase(string, '[^[:alnum:]]', '', 'all') Yea, both syntaxes will accomplish the same thing -- actually with the [:alnum:] you can use REReplace() instead of REReplaceNoCase(), or you can use RER

RE: remove chars from string

2002-07-22 Thread S . Isaac Dealey
> so is this: > > REReplaceNoCase (string, '[^a-z0-9]', '', 'all') > > the same as this: > > REReplaceNoCase(string, '[^[:alnum:]]', '', 'all') Yea, both syntaxes will accomplish the same thing -- actually with the [:alnum:] you can use REReplace() instead of REReplaceNoCase(), or you can use RER

RE: CFMX JDBC Drivers

2002-07-22 Thread Alexander Sherwood
At 03:01 PM 7/22/2002 -0700, you wrote: >Simon said it: > > > 1) Make sure the RDBMS is running SP2. > >I ran into this problem during Beta 2, and Raymond Camden pointed this out. >If you don't have SP2, you can download it here: > >http://www.microsoft.com/sql/downloads/2000/sp2.asp Thanks! Ins

RE: CF Server Error Msg - unknown exception condition - TagCFX::e xecu te

2002-07-22 Thread Van Vliet, Scott
The problem is a result of an exception in the execute method of the TagCFX C++ class. I have run accross this before, and it turned out to be system incompatibility (the CFX was built and compiled on NT 4, but we were trying to use it on W2K). You might contact the author of CFX_AUTHSMTP and se

RE: CFMX caching...

2002-07-22 Thread Brian Scandale
At 09:52 PM 7/11/02, you wrote: >Sounds like Apache. > >-Original Message- >From: mark brinkworth [mailto:[EMAIL PROTECTED]] >Sent: Friday, 12 July 2002 2:38 PM >To: CF-Talk >Subject: RE: CFMX caching... I wish is was just Apache. I just installed CFMX onto a Win2k box with IIS. The pro

Re: Make CF Server process a new extension ".NAP" like it does ".cfm

2002-07-22 Thread Tyler Clendenin
if you are using iis then you can go to the home directory tab of the web site properties and click configuration. ther you can add a mapping, go ahead and look at the cfm mapping and mimic it, except with your .nap extension. - Original Message - From: "Steven A. del Sol" <[EMAIL PROTEC

Custom tag length in CFMX?

2002-07-22 Thread ksuh
I have a custom tag that's 108kb large. I'm getting an error in CFMX saying that it's over 65kb. Are there any issues with CFMX not handling custom tags larger than 65kb? __ Structure your ColdFusion code with Fusebox. Get th

RE: CFMX JDBC Drivers

2002-07-22 Thread Brian Scandale
Thank Ryan, That was a great idea. It works for me too... but yes I do expect a performance hit. Brian At 02:23 PM 7/22/02, you wrote: >As a temporary fix, you could always try an ODBC Socket connection. Here's >what you do: set the DEN in the Windows ODBC Admin, then go to the admin >panel in

RE: CFMX JDBC Drivers

2002-07-22 Thread Van Vliet, Scott
Simon said it: > 1) Make sure the RDBMS is running SP2. I ran into this problem during Beta 2, and Raymond Camden pointed this out. If you don't have SP2, you can download it here: http://www.microsoft.com/sql/downloads/2000/sp2.asp Also, there is a Microsoft SQL Server 2000 Driver for JDBC av

Re: Elaborate plan...

2002-07-22 Thread Brook Davies
Why not use DHTML to load the external file. You can use an IFRAME on IE and a LAYER with the SRC attribute in Netscape. The template that you load should have a handler which calls back to the main page. It would "tell" calling template that it had finished loading and to "do something". This

RE: CFMX JDBC Drivers

2002-07-22 Thread Alexander Sherwood
At 05:24 PM 7/22/2002 -0400, you wrote: > > I have CFMX installed on a Win2K box that can make JDBC > > connections using the supplied drivers to several > > different SQL Server 2000 boxes. I cannot, however, make > > a connection to an instance of SQL Server 2000 Enterprise > > Edition. > > > >

RE: CFMX JDBC Drivers

2002-07-22 Thread Alexander Sherwood
At 05:26 PM 7/22/2002 -0400, you wrote: >Connecting to an instance you have to do two things: I apologize - maybe instance was the wrong word to use. The SQL Server 2K Enterprise install is only running one instance - on the default port of 1433. I am able to create an ODBC datasource on the CFM

Re: Make CF Server process a new extension ".NAP" like it does ".cfm

2002-07-22 Thread Steven A. del Sol
Does anyone know how to make the CF SERVER process pages with and uncommon extension? A long time ago Ben Forta told me how to do this well now I have an application for it.. __ Get the mailserver that powers this list at http

Re: cfmx and SQL Server Data Source Configuration

2002-07-22 Thread Patti G. L. Hall
Are you authenticating using Windows trusted or by specifically passing in a sql server username and login? I had a similar problem and this was my savior. I believe the reason was that the JDBC drivers that the datasources are based on do not allow the "trusted" windows authentication option.

RE: cfmx and SQL Server Data Source Configuration

2002-07-22 Thread Brian Scandale
YES, just confirmed connection using username and password via ODBC control panel... then went back to CFAdministrator and tried various ways of making it connect... still a failure. At 02:22 PM 7/22/02, you wrote: >> I have been attempting to get the datasource configuration >> module of the

Re: Elaborate plan...

2002-07-22 Thread Jason Miller
sounds possibly very silly - but the meta refresh tag.. will that work for you? Each time it refreshes it can write and grab a variable that would change a percent or loading bar- which could simply be a table that has more and more columns filled in. other than that - like someone else had sugg

RE: Group by on date/time field

2002-07-22 Thread David DiPietro
The Convert function may do the trick SELECT Title, CONVERT(CHAR(10), BDate, 101) AS formattedDate, ID FROM YOURTABLE GROUP BY CONVERT(CHAR(10), BDate, 101), Title, ID David DiPietro Systems Developer / Engineer OSU College of Medicine & Public Health Voice (614) 292-5960 Fax (614) 2

RE: CFMX JDBC Drivers

2002-07-22 Thread Ryan Kime
As a temporary fix, you could always try an ODBC Socket connection. Here's what you do: set the DEN in the Windows ODBC Admin, then go to the admin panel in MX and select the ODBC Socket driver. Then select your DSN you set up in the ODBC Admin and there you go. Could be a performance hit, but at

RE: Group by on date/time field

2002-07-22 Thread Jeff Beer
Thanks Gregory, I had tried that earlier, and kept getting errors - I was trying to add the DATEPART to the SQL group by as well.. doh! I ended up with SELECT ... DATEPART(dy,orders.orderdate) AS myDate ... then using myDate as the group="" param in the query output - works like a charm.. Than

RE: CF Server Error Msg - unknown exception condition - TagCFX::execu te

2002-07-22 Thread Mike Brunt
Dave, I would suggest you use CFLOCKS if you are not doing so already around the tag where you call it. It could be a memory corruption error, I always lock CFX tag calls. Kind Regards - Mike Brunt, CTO Webapper http://www.webapper.com Downey CA Office 562.243.6255 AIM - webappermb "Webapper -

RE: CFMX JDBC Drivers

2002-07-22 Thread Simon Horwith
Connecting to an instance you have to do two things: 1) Make sure the RDBMS is running SP2. 2) Specify not only the machine name/IP address, BUT ALSO THE PORT of the SQL Server in the CF Admin. Machines running instances of SQL Server have each one running on a port different to the default

RE: CFMX JDBC Drivers

2002-07-22 Thread Dave Watts
> I have CFMX installed on a Win2K box that can make JDBC > connections using the supplied drivers to several > different SQL Server 2000 boxes. I cannot, however, make > a connection to an instance of SQL Server 2000 Enterprise > Edition. > > A thread on the CF Forums had several posts from

RE: cfmx and SQL Server Data Source Configuration

2002-07-22 Thread Dave Watts
> I have been attempting to get the datasource configuration > module of the CFMX Administrator to accept my configuration > settings I made in the SQL Administrator... Not sure what to > try next. I expect I have something bassakwards seeing as how > I'm not really SQL server savvy. Are you

RE: Group by on date/time field

2002-07-22 Thread Gregory Harris
In the select statement of your query you can use the SQL Server DatePart function as I copy and paste from the SQL Server help file, any questions let me know: -Begin Shameless Copying-- Datepart () Returns an integer representing the specified datepart of the specified date.

CFMX JDBC Drivers

2002-07-22 Thread Alexander Sherwood
Man, this is maddening. I have CFMX installed on a Win2K box that can make JDBC connections using the supplied drivers to several different SQL Server 2000 boxes. I cannot, however, make a connection to an instance of SQL Server 2000 Enterprise Edition. A thread on the CF Forums had several p

Re: Elaborate plan...

2002-07-22 Thread Cary Gordon
Sounds like a job for Flash (or Java). At 11:37 AM 7/22/2002 -0400, you wrote: >I have an application I am working on... > >I want each portion of the code to send an HTTP request to a page and >respond back to my page, however I want the calling page to refresh. I >really want some sort of a st

CF Server Error Msg - unknown exception condition - TagCFX::execu te

2002-07-22 Thread Bosky, Dave
Anybody know what causes this error and how I can resolve the issue??? Error Diagnostic Information unknown exception condition TagCFX::execute The error occurred while processing an element with a general identifier of (CFX_AUTHSMTP) Thanks, Dave DISCLAIMER: The informatio

Group by on date/time field

2002-07-22 Thread Jeff Beer
I have a query that needs to be output in groups based on a datetime value (SQL Server 7.0/2000). The trouble I'm having is with the time value. I need to group on the date alone. Do I need to store the values seperately, or can SQL parse it in the query as only the date portion so CF can use

Re: tracking payments

2002-07-22 Thread Matt Robertson
Couldn't this ba a 3-table setup as follows: [Client] ClientNum BalanceDue .. other fields go here ... [Transactions] ItemID ClientNum ItemDate ItemAmt ItemType (Inv or Pmt or Credit) [Commissions] CommID PmtID ClientNum CommAmt The main client table would hold the current balance due in a de

RE: SoEditor Pro

2002-07-22 Thread jon roig
Yeah... it's awesome. There are tons of little tweaks in setting it up -- it offers you a whole mess of options, but we use it all over the place, and it totally lives up to the promise. -- jon -Original Message- From: Valerie L. Criswell [mailto:[EMAIL PROTECTED]] Sent: Monday,

RE: IIS Problem - HELP!

2002-07-22 Thread Christopher Olive
I would very much appreciate it if you'd stop reading my mind. :) Seriously, that's exactly it. I'lll await your answer. Good luck. Chris Olive -Original Message- From: Paul Begovich [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 1:59 PM To: CF-Talk Subject: RE: IIS Problem -

RE: cfmx and SQL Server Data Source Configuration

2002-07-22 Thread Brian Scandale
At 01:21 PM 7/22/02, you wrote: >In CF 5, you could use trusted connections via Windows authentication to >talk to SQL Server. In CF MX, you can't do that; your SQL Server will need >to allow "native" SQL logins (usernames and passwords) I have SQL Admin rights. I deleted the DSN that lives in t

Re: Finding a good Session management system.

2002-07-22 Thread Joe Eugene
Didnt think Client/Session scope was used primarily for FORM DATA.. rather... for Application/user specific details. eg Application Global vars/User Session Security etc Joe - Original Message - From: "Matthew R. Small" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday,

Re: remove chars from string

2002-07-22 Thread Michael Dinowitz
Yes. > so is this: > REReplaceNoCase (string, '[^a-z0-9]', '', 'all') > the same as this: > REReplaceNoCase(string, '[^[:alnum:]]', '', 'all') > > --Josh > > -Original Message- > From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 22, 2002 2:04 PM > To: CF-Talk > Sub

RE: cfmx and SQL Server Data Source Configuration

2002-07-22 Thread Dave Watts
> I just upgraded from CF5 to CFMX by Uninstalling CF5 and then > Installing CFMX. > > For the last three hours I have been trying to re-establish > datasource connections to SQL server which is running on the > same box without any luck. > > This is the error: > --- > Connect

Re: remove chars from string

2002-07-22 Thread S . Isaac Dealey
> Punct might miss some characters. When dealing with a set of characters > that includes some unknowns (like a yen sign or the like), it's best to > work with the known set. If you wanted to use the special character sets, > then this would work quite well in getting all of the letters, numbers a

RE: remove chars from string

2002-07-22 Thread Josh Trefethen
so is this: REReplaceNoCase (string, '[^a-z0-9]', '', 'all') the same as this: REReplaceNoCase(string, '[^[:alnum:]]', '', 'all') --Josh -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 2:04 PM To: CF-Talk Subject: Re: remove chars from str

Re: Explorer password saving feature

2002-07-22 Thread Jon Hall
autocomplete="off" might work. It's stops the IE autocomplete dropdown from coming up, and it stops Mozilla's form manager from screwing everything up :) Not sure if it stops the password saving though. -- Jon mailto:[EMAIL PROTECTED] Monday, July 22, 2002, 3:48:21 PM, you wrote: >>Hello. In

RE: Explorer password saving feature

2002-07-22 Thread Cornillon, Matthieu
Thanks! This was exactly the thing. Just add autocomplete=off to the form field, and it doesn't get stored by the browser. The really sad thing is this: I use MS Outlook's task list to list all the things I need to do in an application, so that the little things that slip through the cracks of

cfmx and SQL Server Data Source Configuration

2002-07-22 Thread Brian Scandale
I just upgraded from CF5 to CFMX by Uninstalling CF5 and then Installing CFMX. For the last three hours I have been trying to re-establish datasource connections to SQL server which is running on the same box without any luck. This is the error: --- Connection verification faile

Re: Data out of cfloginuser

2002-07-22 Thread Frank Mamone
Is this a bug? According to the docs it should be cflogin.name and cflogin.password. - Original Message - From: "Raymond Camden" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, July 18, 2002 3:45 PM Subject: RE: Data out of cfloginuser > > > > Anyone know if it is p

Re: remove chars from string

2002-07-22 Thread Michael Dinowitz
Punct might miss some characters. When dealing with a set of characters that includes some unknowns (like a yen sign or the like), it's best to work with the known set. If you wanted to use the special character sets, then this would work quite well in getting all of the letters, numbers and sp

RE: remove chars from string

2002-07-22 Thread Josh Trefethen
Thanks Douglas and Isaac! It's about time I learned these regular expressions! --Josh -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 1:07 PM To: CF-Talk Subject: Re: remove chars from string Douglas Brown Email: [EMAIL PROTECTED] ---

Re: Explorer password saving feature

2002-07-22 Thread S . Isaac Dealey
>>Hello. Internet Explorer, when certain settings are set and a user enters >>a >>username and password in a form, asks the user: >> >>"Do you want windows to remember this password, so that you don't have to >>type it again the next time you visit this page?" >> >>I know how to disable this on m

Re: remove chars from string

2002-07-22 Thread S . Isaac Dealey
> REReplaceNoCase (string, '[^a-z0-9]', '', 'all') > This says that your looking in the string for any character that is not a > letter of a-z or a number of 0-9. Because your using REFindNoCase, it'll > take case into account. Anything that is not a letter or number will be > replaced with a blan

Re: remove chars from string

2002-07-22 Thread S . Isaac Dealey
> Replacing [:punct:] with "" won't eliminate white-space ... which is fine assuming you want to leave spaces in. :) Isaac Dealey www.turnkey.to 954-776-0046 __ Your ad could be here. Monies from ads go to support these lists

Re: Explorer password saving feature

2002-07-22 Thread Dave Carabetta
>Hello. Internet Explorer, when certain settings are set and a user enters >a >username and password in a form, asks the user: > >"Do you want windows to remember this password, so that you don't have to >type it again the next time you visit this page?" > >I know how to disable this on my own c

RE: Variable name with special characters

2002-07-22 Thread Dave Watts
> There is probably an easy answer for this, but I can't seem > to solve it... > > I have a structure that comes from an external system. It > was originally XML, but I have converted it to a structure > using CF_SOXML. > > I want to access a value in the structure... > > #calinit.icalen

Re: remove chars from string

2002-07-22 Thread Michael Dinowitz
REReplaceNoCase (string, '[^a-z0-9]', '', 'all') This says that your looking in the string for any character that is not a letter of a-z or a number of 0-9. Because your using REFindNoCase, it'll take case into account. Anything that is not a letter or number will be replaced with a blank ('').

Variable name with special characters

2002-07-22 Thread Michael Sprague
There is probably an easy answer for this, but I can't seem to solve it... I have a structure that comes from an external system. It was originally XML, but I have converted it to a structure using CF_SOXML. I want to access a value in the structure... #calinit.icalendar["ICAL"].X-NSCP-WCA

Re: remove chars from string

2002-07-22 Thread S . Isaac Dealey
> Hey All, > I want to remove all characters besides letters and numbers from a string. > Any ideas on how to accomplish this? > I was thinking of using an REreplace, but I am not sure of the correct the > syntax. > --Josh Hi Josh, this is a very simple regular expression, and the syntax look

Re: remove chars from string

2002-07-22 Thread Douglas Brown
Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: "Josh Trefethen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, July 22, 2002 11:56 AM Subject: remove chars from string > Hey All, > > I want to remove all characters besides letters and number

RE: Macromedia Store

2002-07-22 Thread Christine Lawson
Hi Brook, FYI, I forwarded this message on to the internal web team Best Regards, Christine Lawson Macromedia -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 2:34 PM To: CF-Talk Subject: Macromedia Store I just bought CFMX through the macrom

Re: tracking payments

2002-07-22 Thread Douglas Brown
I dont see a problem as long as you subtract from the amount owed on your invoice table, each time they pay. Each invoice should have it own number that get inserted into the commisions table. Once the commission is paid, you will need to also set that to paid, so you do not overpay commissions.

remove chars from string

2002-07-22 Thread Josh Trefethen
Hey All, I want to remove all characters besides letters and numbers from a string. Any ideas on how to accomplish this? I was thinking of using an REreplace, but I am not sure of the correct the syntax. --Josh __ Get the ma

RE: tracking payments

2002-07-22 Thread Robert Everland
I don't see how it could, cause no matter how you do it you will need more than one record, so it will be one to many no matter how you slice or dice it. Robert Everland III Web Developer Extraordinaire Dixon Ticonderoga Company http://www.dixonusa.com -Original Message- From: Tony Carc

RE: tracking payments

2002-07-22 Thread Tony Carcieri
Douglas, Yea something like that. I originally thought about normalizing it and then thought better of it. But now, it seems like it makes more sense to do it this way. The only forseeable problem is that this could be a many to one relationship. What I mean is this: Project Cost: 10,000 Project

Re: OT Restore DB In SQL7

2002-07-22 Thread Jon Hall
Here is my snippet...I think I even got it off this list many moons ago. First Step - get database name: restore filelistonly from disk = 'c:\medop.bak' Second Step: restore database medop from disk = 'c:\medop.bak' with move 'medop_Data' to 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\me

cfpop & mx

2002-07-22 Thread Jon Hall
Has anyone had any problems with cfpop on MX? I need to build an email app that reads a mailbox and parses the mail. In the past I wouldn't have used CF to do this, but now we are thinking about it since it's been redone. -- Jon mailto:[EMAIL PROTECTED] __

Re: Macromedia Store

2002-07-22 Thread Douglas Brown
Geeesh well hopefully you dont get 5 different orders on your credit card... Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: "Brook Davies" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, July 22, 2002 11:34 AM Subject: Macromedia Store > I just

Re: SoEditor Pro

2002-07-22 Thread Valerie L. Criswell
We purchased the SoEditor pro about 4 months ago. I have implemented it about 10 times with great success. Once you get it going once, setting up subsequent instances literally take less than 15 minutes. I had about 3 major issues that I was unable to work out and the developer's responded in t

Macromedia Store

2002-07-22 Thread Brook Davies
I just bought CFMX through the macromedia store. But, I got about 4-5 404 error pages through the checkout process. refreshing did not help, going back and resubmitting several times finally worked. This happened between the Credit Card data entry screen and the shipping screen and also in the

Re: tracking payments

2002-07-22 Thread Douglas Brown
hmmm I would say more like... [invoice] id sales_person_id Total Cost Invoice Date Invoice Amount Balance [commissions] id invoice_id sales_person_id commission_amount then do a SP to calculate the difference in the invoice amount and amount paid. Once this is done, then you can calculate the p

RE: SoEditor Pro

2002-07-22 Thread Mark A. Kruger - CFG
I use the lite version for my cfug site and another intranet ap. Works great - no complaints. It is IE specific though - so it's not so hot for a general public site. -mk -Original Message- From: Brook Davies [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 1:23 PM To: CF-Talk Su

SoEditor Pro

2002-07-22 Thread Brook Davies
Hello, We are just about to purchase the SoEditor pro wysiwyg editor form www.siteobjects.com. Before we make the purchase, I thought it would be a good idea to check with this list and solicit some feedback from anyone who has used these components. Any comments? FYI, We are building an emai

RE: IIS Problem - HELP!

2002-07-22 Thread Paul Begovich
Hmm... I think I know where your going - What if their staging IS completely different than their live - and when they are testing, it's on a stripped down version of IIS that supports only one site, with subdirectories, and their testing on that subdirectory. "/" would be usesless in referencing

tracking payments

2002-07-22 Thread Tony Carcieri
Hi all, It's Monday, caffeine intake is low and I am having a brainfreeze. I need to keep track of payments made by the client (amount and date), as well as the commissions paid to the sales reps. The reps get paid each time a client makes a payment; ie if the client pays 1000 of his 2000 balanc

Explorer password saving feature

2002-07-22 Thread Cornillon, Matthieu
Hello. Internet Explorer, when certain settings are set and a user enters a username and password in a form, asks the user: "Do you want windows to remember this password, so that you don't have to type it again the next time you visit this page?" I know how to disable this on my own computer

RE: WAY Way OT: Typist Bold Font

2002-07-22 Thread Kris Pilles
THANKS~! -Original Message- From: Erika L. Walker [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 1:28 PM To: CF-Talk Subject: RE: WAY Way OT: Typist Bold Font After a search on Google (http://www.google.com/search?q=Typist+Font&hl=en&lr=&ie=UTF-8&oe=UTF-8) (the supreme ruler o

RE: WAY Way OT: Typist Bold Font

2002-07-22 Thread Erika L. Walker
After a search on Google (http://www.google.com/search?q=Typist+Font&hl=en&lr=&ie=UTF-8&oe=UTF-8) (the supreme ruler of all that is known, second only to Dave Watts ...) I found this link for you in about 60 seconds: http://www.mohaa-ss.freeserve.co.uk/TYPIST.zip Hope that helps ... Erika ** d

Re: OT Restore DB In SQL7

2002-07-22 Thread Bogesdorfer, Dan
Checkout http://www.sqlmag.com instantdoc id number 9808 by Michael D. Reilly "Double Down" <[EMAIL PROTECTED]> wrote in message news:<01c2319b$d3387660$0100a8c0@ipk>... > I have a back up of a db in SQL 7 that I need to restore on my live > server. When I do the transfer and then try to o

List Down?

2002-07-22 Thread Joe Eugene
is the List down? Joe __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com

cfexecute problems

2002-07-22 Thread Chris Edwards
Tried doing this, but there are no output or errors. I've been able to run the command with a PHP script. Any thoughts? __ Your ad could be here. Monies from ads go to support these lists and provide more resources for t

RE: Finding a good Session management system.

2002-07-22 Thread Cornillon, Matthieu
Damn. This is a good idea. I wish I had known about it before I built this massive session-based system. :) Oh, well. I'll know for next time. Matthieu -Original Message- From: Matthew R. Small [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 1:18 PM To: CF-Talk Subject: RE:

RE: Finding a good Session management system.

2002-07-22 Thread Stacy Young
I took the same approach before CFMX. I've now moved back to session variables with CFMX's ability to replicate session data across a cluster...less headache in dealing with stored complex structures. (not like it was a HUGE deal using WDDX but is still extra processing) Let's hope I don't live t

RE: IIS Problem - HELP!

2002-07-22 Thread Christopher Olive
right. are the client's directory structures the same on both machines? i'm looking for something like this... dev box: http://clienturl points to / / - has all root files /images - has all appropriate images staging - http://clienturl points to / /clientname - has all root files /clientname/i

RE: Finding a good Session management system.

2002-07-22 Thread Matthew R. Small
Talking about mulit-page forms... I don't use session or client variables at all when doing multi-page forms. I simply pass the form structure on to the next page in hidden form fields. That way, if somebody chooses to go <-Back, then the variables are there in the preceding page code, not the

RE: Populating a form with query results

2002-07-22 Thread Margaret Fisk
One other thing is you should do isDefined and provide a blank or default if it is not. Otherwise you get errors if the query returns a null for that field. -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 10:05 AM To: CF-Talk Subject: RE: Populati

Re: Populating a form with query results

2002-07-22 Thread Alex
www.google.com On Mon, 22 Jul 2002, Yexley Robert D Contr Det 1 AFRL/WSI wrote: > I have a basic HTML form in a CF document, and I need to be able to populate some of >the fields on the form with the results of a database query. I can't seem to find >anywhere that explains how to go about doi

RE: Populating a form with query results

2002-07-22 Thread Ben Doom
I generally do something like this: select bar from table Hope that helps. Maybe my brain is in gear on this one. :-) --Ben Doom Programmer & General Lackey Moonbow Software : -Original Message- : From: Yexley Robert D Contr Det 1 AFRL/WSI :

RE: Populating a form with query results

2002-07-22 Thread Matthew Friedman
use the form attribute value="#query.colname#" will add the value to the field. If you are using the value you will not need to wrap the call with the if you are using just input do not forget to use the cfoutput tags. matt -Original Message- From: Yexley Robert D Contr Det 1 AFRL/WSI

Re: SMTP Authentication w/CFMAIL tag?

2002-07-22 Thread Howie Hamlin
I'm not sure about CFMX but CF5.0 and earlier do not support SMTP auth. If you can, try to get your postmaster to assign the IP address of your CF server to an allowed list of IPs so that you don't have to authenticate. If that doesn't work, and you are running Windows, then you may want to lo

Re: Studio 5 download

2002-07-22 Thread Michael Dinowitz
Thanks. I had gotten it personally from someone and was able to get a little work done. I'm going to suggest this to Judith as a best of talk thread as it is important information. Either that or have it as a side article in FA and a link in the resources on HoF. > ftp://ftp.allaire.com/outgo

Populating a form with query results

2002-07-22 Thread Yexley Robert D Contr Det 1 AFRL/WSI
I have a basic HTML form in a CF document, and I need to be able to populate some of the fields on the form with the results of a database query. I can't seem to find anywhere that explains how to go about doing this. Could somebody point me in the right direction? Thanks in advance. /* ||

RE: HTTP 500 - Internal Server Error (URGENT)

2002-07-22 Thread Matt Robertson
I've heard the explanation before on this list, but frankly I don't recall it. ;D Just parroting back the advice I got and have seen elsewhere. I, too had a server that worked just fine with everything set to Medium. Then after a reinstall I got 500's everywhere, and learned of the need for Low.

RE: IIS Problem - HELP!

2002-07-22 Thread Paul Begovich
Yes, the source of the image tag is correct. Everything works fine on our development enviroment for referencing from the root (ie "/images/something.gif"), however on their staging server it does not. It only works if it is referenced either "../images/something.gif" or "images/something.gif".

RE: Finding a good Session management system.

2002-07-22 Thread Matt Robertson
I'd like to chime into this thread on the side of client variables. I've pretty much abandoned session vars in favor of client vars and - where needed - using wddx to fake a structure if I need it. It works marvelously. The kicker was when I found Hal Helms' tutorial on this. Using in part a ta

RE: Looping thru recordset

2002-07-22 Thread Andy Ewings
ah yes - I'll try this and see how performance is effected. Currently we are using this: mailto:[EMAIL PROTECTED]] Sent: 22 July 2002 17:29 To: CF-Talk Subject: RE: Looping thru recordset Here's a possible CF solution: #MyField# Chris Lofback Sr

RE: Elaborate plan...

2002-07-22 Thread Shawn Grover
This is off the top of my head (so keep in mind that I could be guessing on some items) Main Page: setInterval(GetProgress, 1000) //run the GetProgress function every second function GetProgres() { document.all.MyIFrameName.src = "myactionpage.cfm";

RE: Looping thru recordset

2002-07-22 Thread Chris Lofback
Here's a possible CF solution: #MyField# Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 12:18 PM To: CF-Talk Subject:

  1   2   >