RE: How to use ExpandPath

2003-06-11 Thread Pascal Peters
Expnadpath takes a relative path, so use images/ Also expandpath calculates a full path from the relative path starting from the base template (the one you requested in the URL). Otherwise this use of Expandpath is correct. -Oorspronkelijk bericht- Van: Paige

RE: How to use ExpandPath

2003-06-11 Thread Josh Trefethen
I would do it like this: cfif fileExists( expandPath('./Images') trim(session.client_ID) trim(session.insured_ID) '1.jpg') !--- yada yada yada --- /cfif HTH, -- Josh Trefethen .:[ Exciteworks, Inc ]::[ http://exciteworks.com ]:. .::[ cf hosting on linux ]::[ consulting ]::[

Creating an Update Form ?

2003-06-11 Thread Ian Vaughan
Hi I am trying to create an update form to update data in the following database tables which are groups table groupid groupname users table userid username password etc... permissions table permid permname The two tables below are what link everything together .. usergroupmembership table

RE: Stepping through months

2003-06-11 Thread Brad Roberts
cfset variables.myDate = 2003-07-12 cfset variables.endDate = 2004-04-23 cfloop condition=dateDiff('m', variables.myDate, variables.endDate) GT 1 !--- REPLACE THE LINES BELOW WITH YOUR CALENDAR SCRIPT, --- !--- USE VARIABLES.MYDATE AS BASIS FOR CALENDAR CREATION ---

RE: Newbyish Question (FORMS)

2003-06-11 Thread David Collie (itndac)
Also, if you're using a database engine that allows TSQL, then put the loop inside the CFQUERY and put a ; at the end of each INSERT This looks like a good tip, can this be done with other Databases as well? i.e. Oracle? Have always coded the loop outside the cfquery tag,

RE: Stepping through months

2003-06-11 Thread Philip Arnold
Say you have a begin date and an end date. For instance 7/12/03 and 2/23/04. I want to create calendars for each month in the date range, so I want to construct a loop to step through each month in the date range. From July 2003 through February 2004 in the above example it should iterate

RE: Newbyish Question (FORMS)

2003-06-11 Thread Philip Arnold
Will be putting it to the test later on this afternoon! You got any performance info on that? This REALLY is something personal on your setup, you might find that your database handles multiple INSERTs really well, especially during light load, while during heavy load it sucks royally You

RE: Newbyish Question (FORMS)

2003-06-11 Thread David Collie (itndac)
Nice one Philip, will be checking it out when I get a bit of time :-) Will be putting it to the test later on this afternoon! You got any performance info on that? This REALLY is something personal on your setup, you might find that your database handles multiple INSERTs really well,

RE: Prevent Refresh

2003-06-11 Thread Shahzad.Butt
Great job! That works fine. Thanks -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: 10 June 2003 22:00 To: CF-Talk Subject: Re: Prevent Refresh Isaac wrote: You could do that -- you'd have to use javascript to submit the form and set the value of the field

RE: Is there SQL equivalent to CF's ListGetAt function??? Please help!

2003-06-11 Thread Bill Grover
The following function will take a list and return you a table with 1 row for each element in the list, along with the row number (i.e. an identity column that begins with 1). I wrote this a while ago because I have several FoxPro programs that needed to pass a comma delimited list of values into

cfftp

2003-06-11 Thread Robert Shaw
Good Morning Everyone, I am trying to use cfftp to put files on my ftp server and it is failing with a very non-descript error: ErrorCode 0 ErrorText An exception occurred when performing the FTP putfile operation In my log I see a permissions error: An exception occurred when performing the

Re: cfftp

2003-06-11 Thread Stephen Moretti
Robert, Check that the user which CF is running under is able to access the file. If its running under the SYSTEM account you may find that CF won't have access to the file. Regards Stephen - Original Message - From: Robert Shaw [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent:

Re: In General: CF vs ActionScript

2003-06-11 Thread E. Keith Dodd
Thanks Sean, Mike, and John for your thoughts on CF vs ActionScript. Obviously, as with most things, there are tradeoffs. Your comments help me to better understand the tradeoffs and where is best place to do what. Just learning ActionScript, I'm tempted to try more in it to better learn about it;

Re: cfftp

2003-06-11 Thread Critz
oi Stephen!! if he's logging into an ftp server via cf... I wouldn't think that would matter, no? Wednesday, June 11, 2003, 8:34:22 AM, you wrote: SM Robert, SM Check that the user which CF is running under is able to access the file. If SM its running

Re: Weird XMLTransform error (long)

2003-06-11 Thread Howard Fore
On Tuesday, Jun 10, 2003, at 17:02 US/Eastern, Massimo, Tiziana e Federica wrote: javax.xml.transform.TransformerException: with-param attribute is not allowed on the xsl:call-template element! But I'm not doing any with-param call (though I'd like to). Here's the XSL: Yes, you are, the

counting to 5-problem

2003-06-11 Thread cf-talk
We are having an eMailing-List where quite e few people do have eMail-adresses from the same companies. Now we want to send out eMails only to 5 people of the same company but not more. The sixth eMail-adress should be marked (with a checkbox or s.th. else). The fields are eMail and company. How

Re: cfftp

2003-06-11 Thread Robert Shaw
Is that it? Do I need to set additional permissions up for the user CF is running with? That still doesn't make sense to me, if that is the case, because I specify a user in the cfftp code and I would think that user should be the user that needs the appropriate permissions. Any thoughts? oi

Re: cfftp

2003-06-11 Thread Critz
oi Robert!! dunno mate.. i've never been a /big/ fan of Cfftp.. i use this java class: http://www.amoebacode.com/ftp/ btw what does the ftp logs say about what is happening? Crit Wednesday, June 11, 2003, 8:54:32 AM, you wrote: RS Is that it? Do I

Re: cfftp

2003-06-11 Thread Stephen Moretti
oi Stephen!! if he's logging into an ftp server via cf... I wouldn't think that would matter, no? Well the logging in is fine, but looking at the error message he gave it would indicate that CF doesn't have access to the file (c:\cfftptest.txt) that he wants to move. This isn't a function of

RE: cfftp

2003-06-11 Thread Dave Watts
Best practice security says that you should run CF under a specific user which only has access to certain things (things being folders, files, registry entries etc), but even then I believe that SYSTEM has a restricted view on the world anyway. The SYSTEM security context has no local

RE: louisville cfug members

2003-06-11 Thread Stephenie Hamilton
Huh? Since when? Wtf?? I didn't even get an email about the new day.. Is it always going to be on tues now? g ~~ Stephenie Hamilton Macromedia Certified ColdFusion Professional CFXHosting -Original Message- From: Dave Lyons [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003

RE: louisville cfug members

2003-06-11 Thread Dan Phillips
Yeah, I didn't get an email either. Dan Phillips www.CFXHosting.com 1-866-239-4678 [EMAIL PROTECTED] -Original Message- From: Stephenie Hamilton [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 9:53 AM To: CF-Talk Subject: RE: louisville cfug members Huh? Since when? Wtf?? I

RE: louisville cfug members

2003-06-11 Thread Ben Doom
Dang it. I was even going up to Louisville for a business trip today. Probably going to be there Thurs. night. Was going to try to talk my boss (who is also going on the trip) into us attending. :-( -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original

conversion of Access datatypes in the query

2003-06-11 Thread Matthew Small
Hi everyone - I need to be able to convert both a datetime field and an integer field to strings in a query (for concatenation with a string field) but I can't remember how to do it. Select datetimefield + stringfield + integerfield as stringtype from table Any help? Matthew Small IT

Re: i will sell domain cftop.com

2003-06-11 Thread Thomas Chiverton
On Friday 06 Jun 2003 21:55 pm, Ian Skinner wrote: across the pond reverse the comma and period in numbers US 100,000.00 equals European 100.000,00. Err... no. -- Tom C Land of the free, home of the brave... you have to be brave to live there and enjoy the freedoms

RE: conversion of Access datatypes in the query

2003-06-11 Thread Mike Townend
Havnt tried this, but it might be possible to use CStr()... i.e. CStr(integerfield) as sFoo Or maybe the Cast(integerfield as varchar) altho Im not sure that will work HTH -Original Message- From: Matthew Small [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 15:12 To:

Re: conversion of Access datatypes in the query

2003-06-11 Thread Marius Milosav
use the convert function select convert (varchar (11), datetimefield) + stringfield + convert (varchar (10) ,integerfield ) Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Company (VICO) Application Demo www.scorpiosoft.com/vicodemo/login.cfm -

Re: conversion of Access datatypes in the query

2003-06-11 Thread Marius Milosav
Opps, I didn't see the Access requirement. The convert function is working in SQL, I don't know about Access - Original Message - From: Matthew Small [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 10:11 AM Subject: conversion of Access datatypes in the

Re: conversion of Access datatypes in the query

2003-06-11 Thread CF Dude
This is from the tSql BOL, so I don't know if this will work w/Access or not. CAST ( expression AS data_type ) E - Original Message - From: Matthew Small [EMAIL PROTECTED] Hi everyone - I need to be able to convert both a datetime field and an integer field to strings in a query

RE: conversion of Access datatypes in the query

2003-06-11 Thread Matthew Small
Thanks, Mike, you jarred my memory. STR() works just fine in Access. CAST does not. Matthew Small IT Director Showstopper American Dance Championships [EMAIL PROTECTED] 843-357-1847 -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 10:19

ServerInfo v3.4 Utility

2003-06-11 Thread Andrew Penhorwood
I have created a free CF Server Utility which can be downloaded at http://www.kaleo.biz/Kaleo_Download.cfm It displays information in the following areas: CF Server, Web Server, OS platform, Java platform and CF Server Locale Support (sorted and grouped alphabetically) On the CF Server MX the

Re: Weird XMLTransform error (long)

2003-06-11 Thread Massimo Foti
Unless you provide default value for them, it throws an error. Correct. As I read the XSL spec, there's no difference between xsl:param name=foobar/xsl:param and xsl:param name=foo select='bar' / Have you tried both and only the second one works? I am definitely not an XSLT expert, but

Re: cfftp

2003-06-11 Thread Critz
oi Stephen!! but I gathered from his message(could be wrong... not first time) that cf was the client logging INTO an ftp server, right? so rights has nothing to do with CF... it has something to do with permissions on the server. I don't see how which account CFServer is setup as

How to use ExpandPath

2003-06-11 Thread Mike Mertsock
Yes, the fact that it's relative to the *base* template caused me untold frustration before I found that out. What is the strategy behind it working that way, instead of being relative from the current template? It does not make for easy-to-read code. Mike Mertsock Alfred University Web Team

RE: How to use ExpandPath

2003-06-11 Thread Mike Townend
If you want relative to the current template you can use GetCurrentTemplatePath() I usually use that with GetDirectoryFromPath() wrapped around it in my Application.cfm page for things like image upload paths ExpandPath() is for converting the URL script name into an absolute path HTH

RE: How to use ExpandPath

2003-06-11 Thread webguy
BTW you should add the contextroot to URLS too . Check out Seans blog for details, www.corfield.org -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED] Sent: 11 June 2003 16:11 To: CF-Talk Subject: RE: How to use ExpandPath If you want relative to the current template you

One search for Spidered Pages, Oracle Basis DBs

2003-06-11 Thread Jamie Jackson
Looking for ideas regarding the creation of a single search interface that (at once) searches pages, Oracle Basis DBs. Is anybody doing this? Thanks, Jamie ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4

RE: How to use ExpandPath

2003-06-11 Thread Angel Stewart
This helped much! Thanks! :) I didn't even know I needed help but I just made a little file upload routine I was writing a lot more efficient than hardcoding an Application variable called imagepath. -Gel -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED] If you want

Re: cfftp

2003-06-11 Thread Stephen Moretti
oi Stephen!! but I gathered from his message(could be wrong... not first time) that cf was the client logging INTO an ftp server, right? so rights has nothing to do with CF... it has something to do with permissions on the server. I don't see how which account CFServer is setup as

Coldfusion server not installing jrun.dll

2003-06-11 Thread Petr Kysela
Has any of you had problem installing CF server on IIS/Win 2000? When I install it, it doesn't put jrun.dll in this folder at all: C:\CFusionMX\runtime\lib\wsconfig\1 Any idea why it wouldn't basically install itself, and then upon completion it majestically opens cf administrator with an

Regarding ExpandPath

2003-06-11 Thread Paige Chandler
Hello All, Many thanks. I finally got it working. Matthew Walker's suggestion to debug was a great help: !cfoutput#ExpandPath(Images\#Trim(Session.Client_ID)##Trim(Session.Insure d_ID)#1.jpg)#/cfoutput! I finally determined that I had to put the Images subdirectory under my main subCVS. I had

RE: Consuming CFMX Web Services in ASP.NET

2003-06-11 Thread Murat Demirci
Any response? -Original Message- From: Murat Demirci [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 10:21 AM To: CF-Talk Subject: Consuming CFMX Web Services in ASP.NET My friend has a problem when calling a web service method which returns CFMX query object. When I return

OT but urgent - Killing Process/service

2003-06-11 Thread Michael Tangorre
We have a small program running on one of our remote servers and we can not seem to kill/stop the process. It was written by a previous emplyee in C++. Is there anyway to stop it? When trying to stop it from the services area in NT just hangs... we would like to not have to reboot this server

RE: counting to 5-problem

2003-06-11 Thread DURETTE, STEVEN J (AIT)
My question would be how do you determine which 5? If you had a list of 10 people, would only the first 5 get the e-mail? Why would you want to prevent the others from getting the e-mail if they signed up for it? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]

Re: counting to 5-problem

2003-06-11 Thread Michael Tangorre
they want them all to go, just 5 at a time I imagine. I am assuming this is to prevent alerting the network guys of a SPAM attack :-) - Original Message - From: DURETTE, STEVEN J (AIT) [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 12:19 PM Subject: RE:

RE: OT but urgent - Killing Process/service

2003-06-11 Thread Mark A. Kruger - CFG
The resource kit has a utility called Kill that can force kill a process. If you do a google search you can probably come up with a download (it's a tiny command line program). -mk -Original Message- From: Michael Tangorre [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 11:19 AM

RE: OT but urgent - Killing Process/service

2003-06-11 Thread Matthew Small
PSKill will do the trick, I'm sure. http://www.sysinternals.com/ntw2k/freeware/pskill.shtml Matthew Small IT Director Showstopper American Dance Championships [EMAIL PROTECTED] 843-357-1847 -Original Message- From: Michael Tangorre [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11,

RE: OT but urgent - Killing Process/service

2003-06-11 Thread Dave Watts
We have a small program running on one of our remote servers and we can not seem to kill/stop the process. It was written by a previous emplyee in C++. Is there anyway to stop it? When trying to stop it from the services area in NT just hangs... we would like to not have to reboot this

Re: OT but urgent - Killing Process/service

2003-06-11 Thread Critz
oi Michael!! use cfexecute to run a batch file that net stop service name Wednesday, June 11, 2003, 12:18:57 PM, you wrote: MT We have a small program running on one of our remote servers and we can not seem to kill/stop the process. It was written by a

RE: OT but urgent - Killing Process/service

2003-06-11 Thread Lomvardias Christopher
Use PsKill http://www.sysinternals.com/ntw2k/freeware/pskill.shtml -Original Message- From: Michael Tangorre [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 12:19 PM To: CF-Talk Subject: OT but urgent - Killing Process/service We have a small program running on one of our

RE: OT but urgent - Killing Process/service

2003-06-11 Thread webguy
Check out ps tools http://www.sysinternals.com/ntw2k/freeware/pstools.shtml You should try to do net stop service namme (as listed by net start) WG -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] Sent: 11 June 2003 17:33 To: CF-Talk Subject: RE: OT but urgent

RE: Consuming CFMX Web Services in ASP.NET

2003-06-11 Thread Matthew Small
I don't imagine that the .NET datatable and the CFMX recordset are compatible by nature, but I've never tried so I don't know for sure. I think that the data is passable, but that your friend will have to explicitly loop through the XML object and find his data manually, or write a small object

Re: Consuming CFMX Web Services in ASP.NET

2003-06-11 Thread Michael Tangorre
just a thought... what about wddx? - Original Message - From: Matthew Small [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 12:19 PM Subject: RE: Consuming CFMX Web Services in ASP.NET I don't imagine that the .NET datatable and the CFMX recordset are

RE: ArrayDeleteAt for a 2d array?

2003-06-11 Thread Bryan Love
If you are going to have many values stored for each item in the array then you may also be better off using an array of structs instead of an array of arrays A struct can store unlimited key value pairs so you'd end up with code like this instead... cfset x = arrayNew(1) cfloop from=1

Re: One search for Spidered Pages, Oracle Basis DBs

2003-06-11 Thread Jamie Jackson
Nevermind, this should be pretty straightforward. I think I'll just do three search routines on the results page, which will return three different blocks of results. Also, maybe I'll cfflush to give 'em something to look at while it takes forever. ;-) Thanks, Jamie On Wed, 11 Jun 2003 11:16:29

Image Scroller....

2003-06-11 Thread Che Vilnonis
Does anyone know of a custom tag that can query a db for pictures and then display thumbnails of them that automatically 'scroll' to the left/right. (Much like a javascript/java news scroller.) When a thumbnail is clicked, a pop-up window display a larger image. Thanks... Ché

cfdump raw data

2003-06-11 Thread Scott Mulholland
Is there a way to access the data cfdump uses as a variable of some sort? Thanks, Scott ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription:

Re: cfdump raw data

2003-06-11 Thread Critz
oi Scott!! well you are inputing(sp?) a variable into cfdump, no? Wednesday, June 11, 2003, 12:56:10 PM, you wrote: SM Is there a way to access the data cfdump uses as a variable of some SM sort? SM Thanks, SM Scott SM

Re: One search for Spidered Pages, Oracle Basis DBs

2003-06-11 Thread Stephen Moretti
Jamie, Why not use one Verity collection which is populated by data from your multiple datasources. Use one of the custom field to specify which datasource the record came from. That way you use CFSearch to get your a result set with title, summary and all the good stuff. When the user wants

PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag

2003-06-11 Thread Buddy
Okay so I have been handed a problem resulting from code that someone else wrote, I'm sure some of you can sympathize. Hopefully some of you might also have some advice. We run a report every month, this month it is much bigger then usual. Normally it takes a while to do, but never has any

RE: Consuming CFMX Web Services in ASP.NET

2003-06-11 Thread Matthew Small
Well, I don't of any WDDX objects for ASP.NET but there could be one, I don't know for sure. I don't think that there would be one because ASP.NET has web services by default and WDDX is kind of a pre-web service technology. I still think that consuming the CFMX service in ASP.NET is going to be

Re[2]: counting to 5-problem

2003-06-11 Thread cf-talk
It is an announcement the customer wants to send out. All eMail-adresses are double-opt-in adresses. It is more the wish of the customer, not to send more than 5 to the same company. It doesn't matter which 5. There shouldn't be a special rule to detect them. Uwe Hello STEVEN, Wednesday, June

Re: Weird XMLTransform error (long)

2003-06-11 Thread Massimo, Tiziana e Federica
Correct. As I read the XSL spec, there's no difference between xsl:param name=foobar/xsl:param and xsl:param name=foo select='bar' / I am just wild guessing here, have you tried this?: xsl:param name=fooxsl:textbar/xsl:text/xsl:param Massimo Foti

RE: cfdump raw data

2003-06-11 Thread Scott Mulholland
Correct. I don't think I explained it well. I am trying to get an answer to this for someone else, here was their explanation to me: Yes, it is an XML package. But you know how CFDUMP will render the ENTIRE CONTENTS of an xml package regardless of the unpredictable number of levels or nested

Re: One search for Spidered Pages, Oracle Basis DBs

2003-06-11 Thread Jamie Jackson
Okay, can you give me a hint as to how to populate a collection with more than one datasource? I thought that you had to feed cfindex a (single) query object. If you can indeed only feed it a single query object, do you propose I unify two queries from separate datasources? If so, do you know a

RE: cfdump raw data

2003-06-11 Thread webguy
Look at Rays dump tag http://www.cflib.org/udf.cfm?ID=619 code included WG -Original Message- From: Scott Mulholland [mailto:[EMAIL PROTECTED] Sent: 11 June 2003 18:41 To: CF-Talk Subject: RE: cfdump raw data Correct. I don't think I explained it well. I am trying to get an answer

Re: louisville cfug members

2003-06-11 Thread Dave Lyons
I guess several people asked if it could be moved because Thursdays were bad. Anyway, there wont be another meeting until around September. I didn't get an email either but I wasn't supposed to be here so I just checked the website. Rick will be sending out an email about when the next meeting

RE: cfdump raw data

2003-06-11 Thread Jim Davis
Well - if you want to store it or something you could use CFSAVECONTENT to grab it all. Jim Davis President, http://www.depressedpress.com Webmaster, http://www.firstnight.org Webmaster, http://www.cfAdvocacy.org Senior Consultant, http://www.metlife.com -Original Message- From: Scott

Displaying PDFs

2003-06-11 Thread Paige Chandler
Hello All, When displaying a .pdf file can that be accomplished by calling it from a button or does it have to be called from a image - .jpg for instance? The below is page 13 of my web sit. As you can see it calls page 14 or page 15 CFIF

RE: cfdump raw data

2003-06-11 Thread Raymond Camden
Just an FYI, I released a newer version of the code, although in custom tag format. It allows you to filter out or show only particular struct/columns. Useful when dumping a large number of fat structures/queries. You can download it from my blog.

RE: Displaying PDFs

2003-06-11 Thread Douglas.Knudsen
-Original Message- From: Paige Chandler [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 2:12 PM To: CF-Talk Subject: Displaying PDFs Hello All, When displaying a .pdf file can that be accomplished by calling it from a button or does it have to be called from a image - .jpg

SOT: SQL Question - Could CF make this easier?

2003-06-11 Thread Jillian Carroll
I am creating a drop-down list of items, but I want to keep several items from appearing in the drop-down. Is there a more efficient way to accomplish this (there will be several more exclusions): cfquery name=qCrop datasource=common_as SELECT DISTINCT Description FROMVCT ORDER BY

populate the damn array

2003-06-11 Thread Owens, Howard
OK, this probably something real stupid, but I'm not seeing it ... This code takes a tabbed file and is supposed to parse it into an array of structures. The problem is, the array is populating with 36 elements of the same data. Whatever the last item in the file is, that because the repeated

RE: SQL Question - Could CF make this easier?

2003-06-11 Thread Bryan Love
sure, the IN and NOT IN clauses are much faster than using multiple ANDs, but don't transfer the load to CF - allow the DB to do what it's best at... cfquery name=qCrop datasource=common_as SELECT DISTINCT Description FROMVCT WHERE description NOT IN

Re: SQL Question - Could CF make this easier?

2003-06-11 Thread CF Dude
You could create a SPROC to do it like this. SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE PROCEDURE getDescriptions() AS SET NOCOUNT ON SELECT DISTINCT description FROM vct WHERE description NOT IN ( 'ANISE', 'APPLES', 'ASPARAGUS', 'BEETS', 'BROCCOLI' ) ORDER BY

RE: One search for Spidered Pages, Oracle Basis DBs

2003-06-11 Thread Ryan Kime
I've done something like this. I've got a page-based collection and some varying DB-based collections. Depending on the parameters passed, it will add the collections to a list and then use the collection param of cfsearch to display the list. Then you get a nice unified result set with the custom

RE: populate the damn array

2003-06-11 Thread Bryan Love
just move ad = StructNew(); inside the for loop and problem solved. The reason it's doing that is because you only declared structNew once. When you declare structNew it causes the variable (ad) to point to a memory address (let's use 0x1234 for this example). You then add this memory address to

RE: populate the damn array

2003-06-11 Thread Ian Skinner
Just a quick guess from what I remember when I've done stuff like this, try putting your temp struct in the loop. cfscript Manifest=Replace(manifest, chr(09), ;, ALL); ListFileLen=ListLen(Manifest, #chr(10)##chr(13)#); container = ArrayNew(1);

CFMX on Cobalt RaQ550

2003-06-11 Thread Costas Piliotis
I have a client of mine who has colocated his server, and the colo facility is having trouble installing cfmx onto that box running the Linux 2.4 Multitasking operating systen as Sun calls it. They've apparantly installed it on other Cobalt servers, but are having major troubles with this one...

RE: SQL Question - Could CF make this easier?

2003-06-11 Thread Chris Kief
Jillian, Another thing you may run across is the situation where you don't know what's going to be in that list because it's being generated by another query. In that case, the trick is to use a sub-query like so: SELECT DISTINCT Description FROMVCT WHERE description NOT IN (SELECT

DTS to update SQL Server database?

2003-06-11 Thread Dina Hess
Hi all, Can someone explain? Is it better to use DTS, replication, or FTP to update SQL Server 2K database files on a shared host? (The database is small; there will only be about 50 new records each week.) TIA, ~Dina ~|

How to use ExpandPath

2003-06-11 Thread Mike Mertsock
If you want relative to the current template you can use GetCurrentTemplatePath() I usually use that with GetDirectoryFromPath() wrapped around it in my Application.cfm page for things like image upload paths ExpandPath() is for converting the URL script name into an absolute path HTH Oh i

RE: active edit alternatives

2003-06-11 Thread Trey Rouse
We've had some problems using realObjects in a test rollout on campus. Everybody has failed to mention what is hands down the best product... http://www.ephox.com/ Take a look at EditLive! For Java. Hands down the cleanest TTW WYSWYG I've worked with. Our current solution is from Ektron using

RE: How to use ExpandPath

2003-06-11 Thread Mike Townend
What you can do is set them in the Application.cfm and assign them to a variable, then at any point you have a reference to the root... Ie Application.cfm CFSET sRoot = GetDirectoryFromPath(GetCurrentTemplatePath()) Upload.cfm CFFILE ACTION=Upload FILEFIELD=foo DIRECTORY=#sRoot# Etc

Re: DTS to update SQL Server database?

2003-06-11 Thread jon hall
I've found out the best way is usually determined by the circumstances. How much does a client want to pay...how technical is the other side, do you want realtime, pseudo-realtime, or batched updates, firewalls, etc. In my perfect world though, in a batch situation, with a small update, the

RE: CFFILE upload max. file size?

2003-06-11 Thread Trey Rouse
There is a bug in IIS that limits the file upload size. Its tricky to put a number on it, but anything over 4 megs on a 100mbit line will likely send your server running never to return. It has nothing to do with memory allocation, it's a fricken bug in IIS. Microsoft acknowledges it to their

RE: populate the damn array

2003-06-11 Thread Owens, Howard
Great explanation, Bryan. Thanks. And it worked. H. -Original Message- From: Bryan Love [SMTP:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 11:50 AM To: CF-Talk Subject: RE: populate the damn array just move ad = StructNew(); inside the for loop and problem solved.

Re: DTS to update SQL Server database?

2003-06-11 Thread Dina Hess
In my perfect world though, in a batch situation, with a small update, the publishing side would fire a DTS that connected to the remote side and updated the data. This one takes very little time to setup, and doesn't place the constraints that replication does on the schema. It also can be done

RE: SQL Question - Could CF make this easier?

2003-06-11 Thread Tony Walker
Or, if possible, add a field to the vct file for include/exclude... ô¿ô Tony -Original Message- From: Jillian Carroll [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 11:37 AM To: CF-Talk Subject: SOT: SQL Question - Could CF make this easier? I am creating a drop-down list of

Re: Consuming CFMX Web Services in ASP.NET

2003-06-11 Thread Frank Mamone
IMO, if ASP.NET cannot consume a Web Service built in CFMX, it greatly reduces the benefit of writing it in CFMX. I think the touted benefit of Web Services is that they can be consumed by the most common platforms, no? Can anyone confirm that they are incompatible? -Frank Mamone -

RE: Consuming CFMX Web Services in ASP.NET

2003-06-11 Thread Matthew Small
You're right, but I thought webservices that were meant to be consumed cross-platform should use basic datatypes like string pairs and not have complex proprietary structures. I don't know enough about either type of webservice to say how they interact. Matthew Small IT Director Showstopper

RE: Consuming CFMX Web Services in ASP.NET

2003-06-11 Thread Dave Watts
IMO, if ASP.NET cannot consume a Web Service built in CFMX, it greatly reduces the benefit of writing it in CFMX. I think the touted benefit of Web Services is that they can be consumed by the most common platforms, no? Can anyone confirm that they are incompatible? They aren't

db2 cftransaction best practices

2003-06-11 Thread s r
I am trying to convince my Manager and DBAs here to change the way they manage Database transactions in here. The environment is ColdFusion 5.0, DB2 version 6, DB2 connect The current setup is as follows. - 1. All access to the database is through Stored

Re: DTS to update SQL Server database?

2003-06-11 Thread jon hall
Wednesday, June 11, 2003, 3:59:51 PM, you wrote: In my perfect world though, in a batch situation, with a small update, the publishing side would fire a DTS that connected to the remote side and updated the data. This one takes very little time to setup, and doesn't place the constraints that

The DBMS returned an unspecified error

2003-06-11 Thread Tim Do
Hello all, I'm seeing this error once in a while on our live sites but then I would do a refresh.. and it would be fine. Any ideas? Thanks, ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4

Re: active edit alternatives

2003-06-11 Thread Dave Lyons
I don't know, this one you suggested took an awfully long time to load up (over 90 seconds on a cable line) I'd still recommend HTMLAREA, its free, configurable and you can implement it in about 2 minutes. The only thing it doesn't have is a spell checker, big whoopy:) Dave - Original

Re: active edit alternatives

2003-06-11 Thread Charlie Griefer
Dude...if there's anybody who shouldn't take a spell checker for granted, it's you : ) c'mon...big hugs...just kidding :) - Original Message - From: Dave Lyons [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 3:56 PM Subject: Re: active edit alternatives

Re: active edit alternatives

2003-06-11 Thread Dave Lyons
LOL! tell me about it! I can spell pretty good, I just cant type for sh*t And then the stupid spell check screws everything up anyway! Have you ever tried to spell check an email with code in it? You know how they say that your family got its name from what they did? Does Griefer = Grief giver?

Re: DTS to update SQL Server database?

2003-06-11 Thread Dina Hess
Other than importing a flat file, the other two have downsides as well. Like the phantom user issue... Phantom user issue? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription:

query question

2003-06-11 Thread Robert Shaw
Hi All, It appears a certain query of mine is causing our CPU to spike. We're working on the query but what is strange is that it will hose CF. It was my uderstanding that CF passes the connection off so I would think it would be normal for the database server's CPU to spike but not for CF to

  1   2   >