Re: CFAS Scheduler

2000-12-19 Thread David Cummins
I had a problem like that yesterday... the page didn't exist, and the Scheduler decided that a 404 error meant it had run fine! David Cummins paul smith wrote: Until now, I've never had problems with CFAS Scheduler. Now I do. The template executes when I do it manually. But not when

Re: Shopping Cart

2000-12-19 Thread Dave Hannum
What kind of code? Do you have an existing catalog? Are you looking for a cart that runs independently of display pages you have - i.e. you simply pass variables to it? Dave = "What we need is a list of specific unknown problems we will encounter" David

RE: JOIN and SUM

2000-12-19 Thread Adrian Cesana
I need to select multiple fields from the master, here would be a better example: SELECT m.pon,m.podate,m.carrier,SUM(d.qty) AS TotalPoQty FROMmaster m, detail d WHERE m.podate BETWEEN 12/15/2000 AND 12/30/2000 AND m.pon = d.pon GROUP BY m.pon This I know doesnt work and I get

Re: Bulk Insert?

2000-12-19 Thread Jon Hall
I am very intrigued also, I think what he means is pass the entire array's data as one string, delimited in some manner. Then use SQL server to parse the string. This is one of those things that goes on my list of things to play with when I get a chance. While this may be looping, or maybe not.

no auto refresh studio

2000-12-19 Thread Seamus Campbell
I've just lost the ability for Studio to automatically refresh every time I change, save, then browse a file. ie I used to change something in a file, save it then hit the browse tag and the file would immediately show my changes. Now I have to hit the refresh button on the toolbar just below

LOCKING revisited...

2000-12-19 Thread Peter Theobald
Ok, given that we all agree: ** Access to shared variables should *ALWAYS* be locked ** Then why on Earth shouldn't I just turn on Automatic Read Locking for Application (and Session et al if I use them) scope and only worry about write locking in my code? Why doesn't everyone do that, with

RE: ThisTag.GeneratedContent

2000-12-19 Thread Dave Watts
This seems like a really dumb question, but I can't seem to find a definitive answer anywhere... Is there an equivalent to a custom tag's "ThisTag.GeneratedContent" variable for the base executing page? I know CF buffers all HTML output until the end of the page execution, and part of

Re: FW: ASP: MP3 Database search. Simple SQL problem.

2000-12-19 Thread Peter Theobald
If you leave either Artist or Song blank the search degenerates to this: Artist like '%%' OR Song like '%%' Which will match ANYTHING. Because they are OR'ed together it can just ignore the other clauses because that one will match everything. At 03:16 PM 12/19/00 -0400, Angél Stewart wrote:

Re: CFAS Scheduler

2000-12-19 Thread paul smith
Yes, I've done that. That's how I know it's not working. best, paul At 12:22 PM 12/19/00 -0500, you wrote: Paul, one of the things I do when setting up a scheduled program, until I am sure it is working is have it email me a notice of completion whenever it is executed as the last thing on

RE: Danger of the +.htr bug

2000-12-19 Thread Eric Dawson
I was poking fun at myself. I develop 100% open source, but my code isn't worth much heh heh. As an aside I realized that I do do some things good. ie most of my programming is not accessible under the web root. ie I make a cfmodule call to a place somewhere not accessible by a browser. half

RE: LOCKING revisited...

2000-12-19 Thread Richard Kern
It was expressed before that turning this on via the server will essentially drop your application to single thread mode, slowing down all responses from the system. Remember that CF is server side so doing this is like knocking on the door and opening it for each request and then closing it

RE: Bulk Insert?

2000-12-19 Thread Dan G. Switzer, II
I'd love to see some write an Extended SP that would in take a WDDX packet, parse the string and convert it to usable data. I'd also love to do the reverse (convert a recordset to WDDX in an Extended SP and just pass back the WDDX packet.) -Dan -Original Message- From: [EMAIL PROTECTED]

RE: interface widgets

2000-12-19 Thread John Anderson
http://devex.allaire.com/developer/gallery/info.cfm?ID=F774149F-B009-11D4-AA AD00508B94F380method=Full Is a cf tag that you can include in a form. For asp or anything else just view the demo, view source and copy the code. Download the tag if you want something you can use as a custom tag?

Re: OT: Does JavaScript have a Trim function?

2000-12-19 Thread t nelson
try this "Trim(string)" this will remove all white space from the beginning and end of your string. ex. if you have a user form field named "blahblah" you could write #Trim(blahblah)#. hope this answers your questions. good luck. cheers, nelson Original Message Follows From:

Re: Shopping Cart

2000-12-19 Thread WebMaster
I've used Quick-E-Store (http://www.quickestore.com) on a couple of sites. The latest version has an option for order tracking based on a customer login. I believe it comes with a template for CyberCash integration and I've been able to fairly easily modify it for use with other payment

OT: Finding the Class ID for a component

2000-12-19 Thread Todd Ashworth
I'm futzing around with a COM object and I keep getting this error: | Error trying to create object specified in the tag. | COM error 0x800401F3. Invalid class string Now, I assume this is telling me I'm not giving it the CLSID that it needs. If that is the case, does anyone know how I can look

Re: CFAS Scheduler

2000-12-19 Thread Cami Lawson
check your application log file to see if it has a date/time similar to the run of the scheduler log, the you can get an idea of what is not working - Original Message - From: "paul smith" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, December 19, 2000 2:42 PM Subject:

RE: JOIN and SUM

2000-12-19 Thread Christopher Olive, CIO
no, you can group by all those fields. this will give you a list of all ponumbers, their dates, the carrier, and the quantity shipped for each combination of these three. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Adrian

cfloop help (new)

2000-12-19 Thread Jay Patton
Hello all, Im kinda new at the coldfusion stuff ive picked it up really fast but im having a problem. i have over 200 images in two different categories, and i want to display only 8 at a time so if i were to click on photos i would want to see the first 8 photos in the database and then be

RE: Shopping Cart

2000-12-19 Thread Phoeun Pha
i think it should be pretty easy. the hardest part of it is categorizing the products. -Original Message- From: Bud [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 19, 2000 1:29 PM To: CF-Talk Subject: RE: Shopping Cart On 12/19/00, Phoeun Pha penned: might as well start your

RE: Finding the Class ID for a component

2000-12-19 Thread cftalk
The error looks to me like you have got the class string wrong and not the clsid... Instead of using CFOBJECT you could use CFSCRIPT foo = CreateObject("COM", "Word.Application"); /CFSCRIPT What might help you is OLEView. THis is installed as part of

RE: Multiple submits

2000-12-19 Thread Warrick, Mark
Yes. You can use a combination of JavaScript and DHTML. This works with IE, not sure about Netscape. Try the following example: !--- snip file 1 --- form action=wait.cfm method=post name=SearchForm SCRIPT language=JavaScript !-- function resetQuickButtons() {

cfmail

2000-12-19 Thread sebastian palmigiani
cfmail allows you to have a query attribute. Is there a way of having an additional 2nd query output within cfmail? Sebastian ~~ Structure your ColdFusion code with Fusebox. Get the official book at

CFFILE write and processing speed Question

2000-12-19 Thread Kinnikinnick Foods Inc. Info Desk
Hi all...new to list. Have been messing about with CF for a couple of months now. Currently we have a web store running on an old cgi based unix system. It works well and I'm not changing it until I have a much better handle on CF but I am using CF to generate all of our static HTML for the

Re: CFAS Scheduler

2000-12-19 Thread Lawrence B. Afrin, M.D.
Paul -- FYI, I've seen the same thing happen enough times (4.0, 4.1, 4.5, haven't tried any of the 4.5 SP's yet) to know it's a real bug -- you're not imagining it. :-) Don't have the foggiest idea what makes the scheduler "stick". Cycling (stopping, starting) the App Server and the

RE: cfloop help (new)

2000-12-19 Thread cftalk
as you are using a database try something like CFPARAM NAME="URL.StartRow" DEFAULT="1" CFOUTPUT QUERY="query_name" STARTROW="#URL.StartRow#" MAXROWS="8" #query_name.pic# /CFOUTPUT CFOUTPUT A

RE: Shopping Cart

2000-12-19 Thread Warrick, Mark
AbleCommerce is a nice out-of-the-box solution. (http://www.ablecommerce.com) - It requires no ColdFusion knowledge to maintain. I haven't tried this one, but it's cheaper than AbleCommerce: http://www.cartease.com/ If you want to "roll your own" you might try this tutorial:

Re: CF 4.51sp2 Memory Usage Plateau

2000-12-19 Thread WBB
Try going to the beta site and reading the forum...there are specifics about at what point the warnings kick in and about registry keys that you can set that will change this. At what point is memory usage excessive: When memory usage exceeds physical memory? When memory is x% of swap?

Re: cfloop help (new)

2000-12-19 Thread WebMaster
Get Ben Forta's Book "Cold Fusion Web Application Construction Kit". It details EXACTLY how to do what you want (as well as tons of other things with CF). You'll find it an invaluable reference. Mike At 02:53 PM 12/19/2000 -0700, you wrote: Hello all, Im kinda new at the coldfusion stuff

Re: CFAS Scheduler

2000-12-19 Thread Cami Lawson
FYI, the system I'm working on has the same things happen to it and if you can't find a code problem then CFAS just quit. Usually I can delete the previous schedule and create a new one to start the next day at 00:01:00 till 23:59:00 for an indefinite number of days and it will start back up

Re: CFFILE write and processing speed Question

2000-12-19 Thread David E. Crawford
Well I can tell you right off the bat that this: cfloop query ="ProdCatDESC" cfoutput query="ProdCatDESC" #ProductCategoryDescShort#, #ProductCategoryID# /cfoutput snip /cfloop Is not helping. You are asking it to loop over the query and then for every single iteration of the loop,

RE: CFFILE write and processing speed Question

2000-12-19 Thread cftalk
You could probably put all the code withing the CFOUTPUT QUERY.. There shouldnt need to be the CFLOOP As far as i know.. The slow bit will most definately be the CFHTTP calls rather than the CFFILE HTH Mike -Original Message- From: Kinnikinnick Foods Inc. Info Desk [mailto:[EMAIL

Re: cfmail

2000-12-19 Thread Bjorn Ostman
You could do a cfloop query="query2" inside the cfoutput query="query1".. |Bjørn Østman |Web Developer |Web Marketing Associates ~~ Structure your ColdFusion code with Fusebox. Get the official book at

Re: no auto refresh studio

2000-12-19 Thread WebMaster
I believe the setting for which you are looking is under "Options | Settings | General". There is a checkbox for "Dynamically Refresh Current Directory"season to taste. Mike At 04:01 PM 12/19/2000 -0500, you wrote: How did you get it to not refresh? That is exactly what I want to do!

RE: CFFILE write and processing speed Question

2000-12-19 Thread cftalk
Try something like... !---Begin file generator--- cfquery name="ProdCatDESC" datasource="MyData" dbtype="ODBC" SELECT ProductCategoryDescShort, ProductCategoryID, MarketID FROM [QRY

RE: Reading Table Info

2000-12-19 Thread Warrick, Mark
Not sure about the attributes (I would like to know as well), but you can get the column list by doing the following: cfquery name="get_columns" datasource="dsn" SELECT * FROM tablename /cfquery cfoutput #get_columns.columnlist# /cfoutput

RE: JOIN and SUM

2000-12-19 Thread Adrian Cesana
Ok, this is working. I thought that if I GROUPed on all those fields I would end up NOT getting ALL the master records but after testing it appears to be working ok. In my summary report I will be dumping out about 15 fields from the master table, it seems like alot of fields to be GROUPing on,

Re: no auto refresh studio

2000-12-19 Thread Seamus Campbell
I've checked that but still no autorefresh - weird and annoying At 09:50 AM 12/20/00 , you wrote: I believe the setting for which you are looking is under "Options | Settings | General". There is a checkbox for "Dynamically Refresh Current Directory"season to taste. Mike At 04:01 PM

RE: cfloop help (new)

2000-12-19 Thread Warrick, Mark
Actually, I think what you need to read up on is how to "Browse Next N records". In Ben Forta's ColdFusion Web Application Construction Kit (version 4.0) it takes Ben about 8 pages of text to describe how this works. Does your book have that same tutorial? Does anyone have a tutorial on the

floating heading

2000-12-19 Thread Adrian Cesana
I have several pages that dump out summary reports in a table, I place the headings on top and every x amount of rows based on what the user selects..This seems to work well when your scrolling thru a few hundred records. One of our larger customers does not like this and wants "floating

Re: CFFILE write and processing speed Question

2000-12-19 Thread JayB
At 05:44 PM 12/19/2000 -0500, you wrote: Well I can tell you right off the bat that this: cfloop query ="ProdCatDESC" cfoutput query="ProdCatDESC" #ProductCategoryDescShort#, #ProductCategoryID# /cfoutput snip /cfloop Is not helping. You are asking it to loop over the query and then

Re: no auto refresh studio

2000-12-19 Thread JayB
At 10:20 AM 12/20/2000 +1100, you wrote: I've checked that but still no autorefresh - weird and annoying Not sure what version of Studio you are using but I was having a problem with beta 4.5.2 rc1 not being able to browse without saving first. HTML's would but cfm wouldn't. Not sure if your

RE: JOIN and SUM

2000-12-19 Thread Christopher Olive, CIO
it doesn't have an inherent "goodness" or "badness". it depends on if you want that count for every combination of those fields. chris olive, cio cresco technologies [EMAIL PROTECTED] http://www.crescotech.com -Original Message- From: Adrian Cesana [mailto:[EMAIL PROTECTED]] Sent:

RE: no auto refresh studio

2000-12-19 Thread Ben Forta
CFM files cannot be browsed unless they are saved, that is not a bug, it's by design. To browse a CFM a round-trip must be made to the web server and CF, it cannot be processed within the client. And for the paths to work properly the file must be saved. --- Ben -Original Message-

Re: floating heading

2000-12-19 Thread Jennifer
At 03:26 PM 12/19/00 -0800, you wrote: I have several pages that dump out summary reports in a table, I place the headings on top and every x amount of rows based on what the user selects..This seems to work well when your scrolling thru a few hundred records. One of our larger customers does

Re: Finding the Class ID for a component

2000-12-19 Thread Todd Ashworth
I'm not using CFObject .. Here's what I have. I'm using Windows Media Encoder 7 cfscript Encoder1 = CreateObject("COM", "ASF.RealTimeEncoder"); Encoder2 = CreateObject("COM", "ASF.RealTimeEncoder"); Encoder1.LoadASD("C:\LowFiConfig.wme"); Encoder2.LoadASD("C:\HiFiConfig.wme");

Re: Avg AS/400 Query time

2000-12-19 Thread Mak Wing Lok
i'm really interested on this, mind to share how you integrate CF and AS/400? mak wl - Original Message - From: Robert Everland [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, December 19, 2000 10:00 PM Subject: Avg AS/400 Query time I am doing a lot of AS/400

RE: no auto refresh studio

2000-12-19 Thread Seamus Campbell
Thanks everyone for your help - I'm not sure what happened but I fiddled with the RDS server thing in files tab and it started working again. many thanks seamus At 10:45 AM 12/20/00 , you wrote: CFM files cannot be browsed unless they are saved, that is not a bug, it's by design. To browse a

(SQL) Date column x year column

2000-12-19 Thread Owens, Howard
I hope somebody can help me out with something that is looking like it's a SQL problem more advanced than I can handle. I have two table -- Primary and DuesAdmin. I need to select data from each table. The WHERE clause needs to be based on the combination of two columns compared to today's

RE: (SQL) Date column x year column

2000-12-19 Thread Warrick, Mark
I'm not certain whether this can even be done with SQL. What I would do is use ColdFusion for the calculations and based upon your logic below, either display or not display the records. ---mark -- Mark Warrick Phone: (714) 547-5386

RE: no auto refresh studio

2000-12-19 Thread JayB
At 06:45 PM 12/19/2000 -0500, you wrote: CFM files cannot be browsed unless they are saved, that is not a bug, it's by design. To browse a CFM a round-trip must be made to the web server and CF, it cannot be processed within the client. And for the paths to work properly the file must be saved.

ssl the RSA patent

2000-12-19 Thread lsellers
Was just wanting to verify this... the alg behind SSL is now public domain is it not? Yes? (Was considering adding some SSL support to a cf tag.) --min ~~ Structure your ColdFusion code with Fusebox. Get the official book at

RE: (SQL) Date column x year column

2000-12-19 Thread Bob Silverberg
The following solution is for SQL Server, I imagine most other DBMSs have a similar function, so if you aren't using SQL Server it should still lead you in the right direction. Assuming that the value stored in YearsPaid is always a number of years (as opposed to a number of months) and that

RE: (SQL) Date column x year column

2000-12-19 Thread Braver, Ben:
Howard, I don't think you want to "multiply" date x years-paid -- wouldn't you want to use DateAdd to calculate an expiration date based on the amount paid? Also, how are you joining the primary and dues admin tables? Ben -Original Message- From: Warrick, Mark [SMTP:[EMAIL

Re: Avg AS/400 Query time

2000-12-19 Thread Jeff Stevens
I did with IBM's client access DB2 ODBC driver. However it was not reliable and would initiate an ODBC login on the server after bootup. I also did not put into production. --- Mak Wing Lok [EMAIL PROTECTED] wrote: i'm really interested on this, mind to share how you integrate CF and AS/400?

Re: CFFTP -- INVALID PORT COMMAND

2000-12-19 Thread Sean Renet
nope thought that might have been it, but I took the firewall down and tried and still got the error - Original Message - From: "JustinMacCarthy" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, December 18, 2000 6:42 AM Subject: RE: CFFTP -- INVALID PORT COMMAND

RE: (SQL) Date column x year column

2000-12-19 Thread Owens, Howard
Ben: Amount paid varies based on a number of factors. Years paid is the number to determine paid length of membership -- all numbers are stored as years/integers. I'm joining with WHERE DuesAdmin.membersID = Primary.MembersID H. -Original Message- From: Braver, Ben: [SMTP:[EMAIL

How to setup native drivers for DB2 on Linux?

2000-12-19 Thread Gena
Any suggestions? Regards ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe:

RE: Avg AS/400 Query time

2000-12-19 Thread Robert Everland III
You can save the password on the server. There is a utility that you can start as a service if you're interested. Granted technically it's insecure, but it's residing on the server, so either way they would have access to just about anything anyway. Bob -Original Message- From: Jeff

Re: How to setup native drivers for DB2 on Linux?

2000-12-19 Thread Mak Wing Lok
I've been thinking this all the while but i want to have it on a Solaris. anyone any idea? - Original Message - From: Gena [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, December 11, 2000 10:00 AM Subject: How to setup native drivers for DB2 on Linux? Any suggestions?

How can I find the date of the monday of the week containing a given date?

2000-12-19 Thread Brent Goldman
Hello, I am currently writing an online scheduling application with ColdFusion. At one part of the program, I output the next four weeks in case the user wants to quickly jump ahead in time. Rather than outputting weeks starting from the current day, such as from a Tuesday like today, I

How can I find the date of the monday of the week containing a given date?

2000-12-19 Thread Brent Goldman
Hello, I am currently writing an online scheduling application with ColdFusion. At one part of the program, I output the next four weeks in case the user wants to quickly jump ahead in time. Rather than outputting weeks starting from the current day, such as from a Tuesday like today, I

Re: clientVar storage/multiple CFAS/single storage db

2000-12-19 Thread Xing Li
This is a pretty old post but given its importance as related to client variables I want to revist this. I have a system setup where two cf machines are tied together via dns round-robin and share the same database for client storage. As the number of simultaneous users increasesd, the number of

RE: How can I find the date of the monday of the week containing a given date?

2000-12-19 Thread Allan Pichler
this should do the trick CFSET monday = dateadd("d", ( evaluate( - (dayofweek(date) - 2))), now()) Sets monday to the last based on todays date! Allan -Original Message- From: Brent Goldman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 19, 2000 6:29 PM To: CF-Talk Subject: How

RE: How can I find the date of the monday of the week containing a given date?

2000-12-19 Thread Warrick, Mark
Here one way to do it: !-- begin -- pre Subject: How can I find the date of the monday of the week containing a given date? cfoutput !--- set the current date --- cfset today = DateFormat(now(), "mm-dd-") Current Date: #today# !--- figure out which day of the week the current date is

RE: Undo Delete

2000-12-19 Thread Dave Watts
Here's another use for flagging records: Our db tables which contain scientific data contain an "approved" field, whose default value is "false". After data is inserted into the database, an analyst checks it out, and then we toggle the flag to "true". Of course, our non-admin

Allaire Developer Conference CD?

2000-12-19 Thread David Shadovitz
Anyone receive the Allaire Developer Conference CD yet? -David ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives:

RE: ssl the RSA patent

2000-12-19 Thread Dave Watts
Was just wanting to verify this... the alg behind SSL is now public domain is it not? Yes? (Was considering adding some SSL support to a cf tag.) The RSA algorithm is now public domain. There's also a free SSL toolkit: http://www.openssl.org/ Dave Watts, CTO, Fig Leaf Software

RE: ssl the RSA patent

2000-12-19 Thread lsellers
Was just wanting to verify this... the alg behind SSL is now public domain is it not? Yes? (Was considering adding some SSL support to a cf tag.) The RSA algorithm is now public domain. There's also a free SSL toolkit: http://www.openssl.org/ Cool. But I think that's under the

RE: [Compress HTML output]

2000-12-19 Thread Peter Stolz
I guess that would be CGI.HTTP_ACCEPT_ENCODING. P. -Original Message- From: Peter Stolz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 19, 2000 10:30 PM To: [EMAIL PROTECTED] Subject: RE: [Compress HTML output] This is great! One question though: The servlet version checks for the

RE: ssl the RSA patent

2000-12-19 Thread Dave Watts
... There's also a free SSL toolkit: http://www.openssl.org/ Cool. But I think that's under the pesky BSD license. According to the site, OpenSSL's licensing is very similar to Apache's, which is pretty minimal: http://www.apache.org/LICENSE.txt Dave Watts, CTO, Fig Leaf Software

WAY OT: C++

2000-12-19 Thread Robert Everland III
Well I have been messing with cf for a year now and figure it's time to seriously broaden my horizon and try to learn the granddaddy of all languages (excluding B and all those ones which aren't highly used). Does anyone know of a good website that has some good learning examples. Thanks

RE: ThisTag.GeneratedContent

2000-12-19 Thread Eric Dawson
I am unclear of what you want to do. But how about using cfhttp to request the page? HTH Eric From: "Peter Stolz" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: RE: ThisTag.GeneratedContent Date: Tue, 19 Dec 2000 22:10:08 -0500 There is one inelegant and

RE: WAY OT: C++

2000-12-19 Thread lsellers
Well I have been messing with cf for a year now and figure it's time to seriously broaden my horizon and try to learn the granddaddy of all languages (excluding B and all those ones which aren't highly used). Does anyone know of a good website that has some good learning examples.

RE: CFFTP -- INVALID PORT COMMAND

2000-12-19 Thread James McCullough
The only time I got this was when connecting to a Linux box and FTP had terminated. Restarting the FTP on the Linux box fixed it. -Original Message- From: Sean Renet [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 19, 2000 5:12 PM To: CF-Talk Subject: Re: CFFTP -- INVALID PORT COMMAND

Re: clientVar storage/multiple CFAS/single storage db

2000-12-19 Thread paul smith
Xing: Since I was storing client variables in a database anyway, for this but mainly other reasons I went to a scheme where I create CFI/CFT pairs (analogous to CFID/CFTOKEN pairs) using my own algorithm. Since CFI is incremented by 1 in a single table for each new user no matter how many

<    1   2