Re: new version of cfeclipse (1.1.3) the eclipse plug-in

2004-03-09 Thread Oliver Tupman
Hello to all you CF users, If you're using CFEclipse then perhaps you might be interested in signing up at Tigris? Signing up as an observer sticks you on the CFEclipse users mailing list to join any discussion that takes place with relevance to CFEclipse. Another added benefit is that you

Getting hold of CF 4.5

2004-03-09 Thread Adam Reynolds
Anybody know how I can get hold of CF 4.5? MM are not being helpful :) Adam [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Getting hold of CF 4.5

2004-03-09 Thread John Beynon
If in doubt, Ebay! :) http://search.ebay.com/search/search.dll?cgiurl=http%3A%2F%2Fcgi.ebay.com%2F ws%2Fkrd=1from=R8MfcISAPICommand=GetResultht=1SortProperty=MetaEndSort query=cold+fusion+4.5 not listed on the UK eBay though :( Maybe a call to Highlander in the UK, they might have some old

RE: Getting hold of CF 4.5

2004-03-09 Thread Adam Reynolds
just found an old 4.5.1 server disk. Panic over :) -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED] Sent: 09 March 2004 11:48 To: CF-Talk Subject: RE: Getting hold of CF 4.5 If in doubt, Ebay! :) http://search.ebay.com/search/search.dll?cgiurl=http%3A%2F%2Fcgi.ebay.com%2F

RE: Getting hold of CF 4.5

2004-03-09 Thread Robertson-Ravo, Neil (RX)
I can provide you with a copy.gimme FTP details and I will upload it (CF 4.5 Enterprise + Service Packs) _ From: Adam Reynolds [mailto:[EMAIL PROTECTED] Sent: 09 March 2004 11:35 To: CF-Talk Subject: Getting hold of CF 4.5 Anybody know how I can get hold of CF 4.5? MM are not being

Re: Cold Fusion and Oracle

2004-03-09 Thread Adrocknaphobia
Janet's scripts here are dead on for how it should be done. I've missed the earliest part of this thread, so I'm not sure if this is what you originally had, but this is what it should be. What happens when you run this script and call it from CF? -Adam -Original Message- From: Janet

Re: Why use Cold Fusion vs. other languages?

2004-03-09 Thread Jeremy Brodie
I think the better analogy would be to compare Cold Fusion to Java Struts and the .Net framework, instead of the underlying language. Before this turns into a lengthy dicussion, I'll explain my reasoning. All three apporaches were meant to solve a problem within web devolpment: how to incresse a

RE: Credit Cards - Best Practices

2004-03-09 Thread Bailey, Neal
Thanks Matt, My response is mixed in below... *Assuming* you are shipping product immediately, or you are selling something intangible like memberships that needs no shipping delay, then you can settle immediately as well.Otherwise I'm pretty sure you are bound ethically -- and probably

Missing structure keys?

2004-03-09 Thread Ian Skinner
This one is quite bizarre.I have a structure that contains four keys.Just to paint the picture, the value of each key is a query.Anyway, when I dump the structure I see all four keys and their values.But when I try and loop over the structure keys with a cfloop collection it only iterates over

RE: Workstation name ?

2004-03-09 Thread Deva, Ramesh X [ECCO Select]
Hi Dave, Thanks for your email. Yes, workstation means my desktop machine name.. thanks ramesh -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, March 08, 2004 7:01 PM To: CF-Talk Subject: RE: Workstation name ? How do i know my workstation name

RE: Credit Cards - Best Practices

2004-03-09 Thread Bailey, Neal
Thanks Mary Jo, Yeah I am still trying to figure out all that can be done through my merchants API and Online system. Looks like I can do all of what you mentioned. Yeah I have some clients that insist on storing there credit card info on the web server and it really scares me. I have

RE: Missing structure keys?

2004-03-09 Thread Raymond Camden
Can you show the code? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Workstation name ?

2004-03-09 Thread Dave Watts
Yes, workstation means my desktop machine name.. That isn't exposed to your web server, typically. I suppose you could get that information through an ActiveX control. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This

webcam et coldfusion

2004-03-09 Thread Steff
Bonjour si je relie une webcam mon serveur, puis-je utiliser coldfusion pour visualiser le contenu de ma webcam? Merci Stphane [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: webcam et coldfusion

2004-03-09 Thread Bruce Sorge
D'abord, pardonnez mon franais. Il suce. Je ne suis pas sr comment vous feriez ceci avec ColdFusion, mais vous pouvez faire ceci avec le flash. Avez-vous examin cette option ? - Original Message - From: Steff To: CF-Talk Sent: Tuesday, March 09, 2004 9:03 AM Subject: webcam et

RE: webcam et coldfusion

2004-03-09 Thread Marlon Moyer
Babelfish can be comedy in and of itself: Initially, forgive my French. He sucks. I am not sure how you would do this with ColdFusion, but you can do this with the flash. Did you examine this option? -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED] Sent: Tuesday, March

RE: webcam et coldfusion

2004-03-09 Thread Steff
Sorry Here the message I want to use on my site a webcam. How should I do? Can coldfusion help me? Thanks [Steff] -Message d'origine- De : Bruce Sorge [mailto:[EMAIL PROTECTED] Envoy : Tuesday, March 09, 2004 4:11 PM : CF-Talk Objet : Re: webcam et coldfusion D'abord, pardonnez mon

Re: Workstation name ?

2004-03-09 Thread Thomas Chiverton
On Tuesday 09 Mar 2004 15:03 pm, Dave Watts wrote: That isn't exposed to your web server, typically. I suppose you could get that information through an ActiveX control. Wasn't there a post recently ? :hunts Look for the subject Getting computer name via variables? in the archives, which

RE: webcam et coldfusion

2004-03-09 Thread Won Lee
At 09:16 3/9/2004 -0600, you wrote: Babelfish can be comedy in and of itself: Initially, forgive my French. He sucks. I am not sure how you would do this with ColdFusion, but you can do this with the flash. Did you examine this option? And here I was thinking that he was farting in my general

Re: webcam et coldfusion

2004-03-09 Thread Cutter (CF-Talk)
Steff, I have several webcams hooked up on our site (though they are down for maintenance now). Everything depends on the type of webserver streaming the content. Currently I have video coming from two low end Axis video servers, and I reference those server's streams in the object tag on the

SOLVED RE: Missing structure keys?

2004-03-09 Thread Ian Skinner
OK, Ok, it must be a two Monday week.In the process of copying the code to this e-mail, I finally saw the errant cfabort tag in the middle of my loop that had overlooked all late afternoon yesterday and all morning till now. Thanks for all the help. :-0 -- Ian Skinner Web Programmer

Re: Why use Cold Fusion vs. other languages?

2004-03-09 Thread Don
Good point, however, only developers would be able to undertand this. Dick Applebaum wrote: Don't forget to add dynamic query caching with cachedwithin=#createtimespan(0,0,0,30)# or whatever.No other language in the web space offers a similar solution with a single attribute. -- geoff

RE: webcam et coldfusion

2004-03-09 Thread Gabriel Robichaud
do you want to do video or just still images? If all you want to do is play around with still images, just use your web cam software to capture images in a directory accessible by coldfusion, then use coldfusion to display these images on your website for video.. its a bit more complex...

RE: webcam et coldfusion

2004-03-09 Thread Steff
I wan't to install a webcam when I click on the link, I see what camera sees steff -Message d'origine- De : Gabriel Robichaud [mailto:[EMAIL PROTECTED] Envoy : Tuesday, March 09, 2004 4:32 PM : CF-Talk Objet : RE: webcam et coldfusion do you want to do video or just still images? If all

RE: Workstation name ?

2004-03-09 Thread Deva, Ramesh X [ECCO Select]
Thanks Dave and Tom.. here i found cfx_systeminfo.zip from following link.. it works me fine.. http://www.intrafoundation.com/cfx_systeminfo.asp http://www.intrafoundation.com/coldfusion.html Thanks ramesh -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]

RE: Workstation name ?

2004-03-09 Thread John Beynon
odd, first line on that site information about the machine it's installed on It'll be installed on the server, therefore will only be able to access the local server. You're not testing it on your local machine with CF installed are you? cos that will be reporting about itself... -Original

RE: Workstation name ?

2004-03-09 Thread Dave Watts
That isn't exposed to your web server, typically. I suppose you couldget that information through an ActiveX control. Wasn't there a post recently ? :hunts Look for the subject Getting computer name via variables? in the archives, which refs:

RE: Workstation name ?

2004-03-09 Thread Dave Watts
Thanks Dave and Tom.. here i found cfx_systeminfo.zip from following link.. it works me fine.. I thought you said you wanted to know the workstation name? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message]

Tortoise CVS

2004-03-09 Thread Broner, Mark, CON, OASD(HA)/TMA
Has anyone gotten tortoise CVS integrated with Homesite +?I thought that it would be a choice with projects and source control but I can't seem to get Homesite to recognize Tortoise as a valid source control source. TIA Mark [Todays Threads] [This Message] [Subscription] [Fast

Writing Files without CFFILE

2004-03-09 Thread Sean Daniels
Hey all, I have a CF script that is used to generate about 14,000 static HTML files from dynamic content (don't ask). I am looping over a query using cfsavecontent to save the HTML code for each page and then writing to a file with CFFILE. As this process runs, I sit here and watch the CF

RE: Workstation name ?

2004-03-09 Thread John Beynon
What about using the IP address of the workstation and then doing a DNS lookup for it's information, or a WINS lookup if in a private Windows network. -Original Message- From: Deva, Ramesh X [ECCO Select] [mailto:[EMAIL PROTECTED] Sent: 08 March 2004 23:23 To: CF-Talk Subject:

Query Result to a comma list

2004-03-09 Thread Paul Giesenhagen
How do you convert a query result column to a comma delimited list without building it with a loop? Thanks Paul Giesenhagen QuillDesign [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Re: Query Result to a comma list

2004-03-09 Thread Ubqtous
Paul, On 3/9/2004 at 11:21, you wrote: PG How do you convert a query result column to a comma delimited PG list without building it with a loop? valuelist(queryname.querycolumn,,) ~ Ubqtous ~ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Query Result to a comma list

2004-03-09 Thread John Beynon
Valuelist() Jb. -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED] Sent: 09 March 2004 16:21 To: CF-Talk Subject: Query Result to a comma list How do you convert a query result column to a comma delimited list without building it with a loop? Thanks Paul Giesenhagen

RE: Tortoise CVS

2004-03-09 Thread Raymond Camden
Homesite+ doesn't support CVS natively. You need a third party tool like the Igloo thing I mentioned yesterday. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

RE: Query Result to a comma list

2004-03-09 Thread Lofback, Chris
ValueList(query.column) Chris -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 09, 2004 11:21 AM To: CF-Talk Subject: Query Result to a comma list How do you convert a query result column to a comma delimited list without building it with a loop?

Moneris Verified by Visa

2004-03-09 Thread Bryan Stevenson
Hey All, Has anybody handled Verified by Visa payments through Moneris using their JavaAPI? We're trying to sort through their documentation, but let's just say it's a tad lacking in commenting and is inconsistent across various documents from them. A code example would be stellar ;-) Thanks

Re: webcam et coldfusion

2004-03-09 Thread Bruce Sorge
How did someone answer this in my behalf? This is the first I saw this. I do not even know French. I got a freaking D in that class. The only other language I slightly know is German, and I would not even attempt to use that in public. - Original Message - From: Marlon Moyer To: CF-Talk

RE: Workstation name ?

2004-03-09 Thread Whittingham, P
Hi, We created a vb (dll) to get that informationand used _javascript_ to retrieve that information. WSH might work also, but we turned that off since it can be used by hackers. TIA, Patrick Whittingham United Space Alliance -Original Message- From: John Beynon [mailto:[EMAIL

SQL Help

2004-03-09 Thread Bruce, Rodney S HQISEC/Veridian IT Services
Hi all I need some help with a query that supplies a report. The issue for me is one of the tables: (simplified) Table UIDNameDescriptionParentProject_id This table contains different information in the same field (name),like the projects status (Initializing, Engineering, etc) , the

RE: Tortoise CVS

2004-03-09 Thread Tony Weeg
cant find igloo. want to use with smartcvs -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 09, 2004 11:34 AM To: CF-Talk Subject: RE: Tortoise CVS Homesite+ doesn't support CVS natively. You need a third party tool like Homesite+ the Igloo thing

Re: Tortoise CVS

2004-03-09 Thread Oliver Tupman
Broner, Mark, CON, OASD(HA)/TMA wrote: Has anyone gotten tortoise CVS integrated with Homesite +?I thought that it would be a choice with projects and source control but I can't seem to get Homesite to recognize Tortoise as a valid source control source. Hmm, AFAIK Tortoise CVS only

Re: SQL Help

2004-03-09 Thread Jeff Small
Hi Rodney, I'm not really able to help all that much, but what I suggest is trying the SQL mailing list. I replied and forwarded this to that list in an effort to get it over to the SQL people. They're really great at this sort of stuff, and you might get a faster, better response from it. Have

RE: Tortoise CVS

2004-03-09 Thread Tony Weeg
that install is not there. the files are there, but I didn't see install instrucs. tony -Original Message- From: Oliver Tupman [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 09, 2004 11:44 AM To: CF-Talk Subject: Re: Tortoise CVS Broner, Mark, CON, OASD(HA)/TMA wrote: Has anyone

RE: Writing Files without CFFILE

2004-03-09 Thread Adam Reynolds
Your issue is the number of chunks you are trying to do it in. Try doing it in 2 parts. cffile is probably ok but your cfsavecontent may be what is causing you issues as it may not be clearing down the content. You are still creating 14000 pages inside memory space even though you are not

RE: SQL Help

2004-03-09 Thread Mark A. Kruger - CFG
How about: WHERE(name LIKE '%Open%'or name LIKE '%Engineering%') AND name NOT LIKE ('%closed%') Personally, this is probably not the best way to handle status.I always have a status field - either an int or a small character field and use a constraint ('open','closed','pending') and always be

RE: SQL Help

2004-03-09 Thread Ian Skinner
My first suggestion would be an embed sub-query. SELECT fields FROM Table. ( SELECT fields FROM TABLE WHERE Name LIKE %Engineering% ) AS FooBar WHERE FooBar.ID = Table.ID AND Name LIKE %Open% Of course this assumes you are using a DBMS that allows sub-queries.I

Single quotes, CF5, and MS Access

2004-03-09 Thread Thane Sherrington
To deal with single quotes entered in a comment field, I've been replacing them with double quotes, but after doing some reading in the archives, it appears that I could avoid this by using CFQueryParam and PreserveSingleQuotes.Unforunately, I don't understand exactly how this works.If someone

RE: Tortoise CVS

2004-03-09 Thread Nathan Strutz
This is correct. TortoiseCVS integrates with the windows shell. To access Tortoise's functionality, try right-clicking on folders in the resource tab. That should give you pretty much full access to Tortoise from within the HS interface. -nathan strutz -Original Message- From: Oliver

RE: SQL Help

2004-03-09 Thread Ciliotta, Mario
Rodney, I am not SQL expert but maybe you could create a view that would be a cross-tab of your table so that the view contains only on record for each project based on the project id. So that the view would contain: Project ID, Status, Type, Condition, ... and then

Re: Why use Cold Fusion vs. other languages?

2004-03-09 Thread Dick Applebaum
Not necessarily... In our ad hoc demo scenario, I try to make the initial demo simple: - easy to type - easy to understand - easy to get running Normally: cfquery name=getPhone datasource=cfsnippets SELECT LastName, FirstName, Phone FROMEmployees WHEREDepartment='Sales' ORDER BYLastName,

Re: Writing Files without CFFILE

2004-03-09 Thread Sean Daniels
On Mar 9, 2004, at 11:50 AM, Adam Reynolds wrote: Your issue is the number of chunks you are trying to do it in. Try doing it in 2 parts. I thought about doing that, but it seems inherently non-scalable. Like, if I break it into two parts, what happens when the database returns 24,000

Re: Single quotes, CF5, and MS Access

2004-03-09 Thread Charlie Griefer
actually you wouldn't even need the preserveSingleQuotes() (in most cases) if you're using cfqueryparam http://www.macromedia.com/devnet/mx/coldfusion/articles/cfqueryparam.html - Original Message - From: Thane Sherrington [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday,

An exception occurred when establishing a FTP connection

2004-03-09 Thread Tim Do
Hello All, I have a schedule job that fuses cfftp that has been working for months and for the last few days has not been.I asked them if they had made any changes and they replied that they moved servers but should be transparent to us.We are using the url and not ip.I can get in via

RE: Workstation name ?

2004-03-09 Thread Ciliotta, Mario
Hi, We used WSH (Windows Scripting Host) to get that information (only on intranet pages only - security rule and also if the request is from an internal page vs an external page - the external pages script is not allowed to run (so I have been told)). Here is a sample of what we used - might

RE: Why use Cold Fusion vs. other languages?

2004-03-09 Thread Burns, John
I'm curious if the whole easier route is really the right argument.Of course each language can pull out a little example and show how in that particular language it's easier, but how many times are your applications really going to look like that?I think I'd explain that CF does make some tasks

RE: SQL Help

2004-03-09 Thread Bruce, Rodney S HQISEC/Veridian IT Services
Jeff thanks for info and the forward -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 09, 2004 9:47 AM To: CF-Talk Subject: Re: SQL Help Hi Rodney, I'm not really able to help all that much, but what I suggest is trying the SQL mailing list. I replied

RE: Single quotes, CF5, and MS Access

2004-03-09 Thread Ian Skinner
Untested pseudo code: cfset ID = 1 cfset test=Hi, this line has a single quote [ ' ] in it.Didn't I tell you it did. cfset updateValue = perserveSingleQuotes(test) cfquery UPDATE table SET field = cfqueryParam value=#updateValue# cfsqltype=cf_sql_varchar WHERE ID = cfqueryParam

RE: Writing Files without CFFILE

2004-03-09 Thread Craig Dudley
Are you using the same variable name for the cfsavecontent? -Original Message- From: Sean Daniels [mailto:[EMAIL PROTECTED] Sent: 09 March 2004 17:18 To: CF-Talk Subject: Re: Writing Files without CFFILE On Mar 9, 2004, at 11:50 AM, Adam Reynolds wrote: Your issue is the

Re: Cold Fusion and Oracle

2004-03-09 Thread sampath nellutla
i am just wondering why my Package.procedure works fine on my local machine which uses ODBC SOCKET connection and fails when i use JDBC connection on (oracle thin client) development server and throws following error. any help would be appreciated. thanks, -sampath here is my procedure and cf code

Re: Cold Fusion and Oracle

2004-03-09 Thread Richard Crawford
Nick Han wrote: You need the ref cursor.types.cursorType---don't take this out. studentInfo types.cursorType; did you declare types.cursorType in the package spec?, and it has to be a ref cursor type! example: TYPE cursorType IS REF CURSOR; =you need this line in the package spec

Re: Writing Files without CFFILE

2004-03-09 Thread Sean Daniels
On Mar 9, 2004, at 12:26 PM, Craig Dudley wrote: Are you using the same variable name for the cfsavecontent? Yes. On each iteration the savecontent overwrites the previous content var. That being said, I believe I solved the problem. I should have mentioned I wasn't calling CFFILE directly

Re: Cold Fusion and Oracle

2004-03-09 Thread Richard Crawford
Janet, Thanks for the suggestion.I tried it, but continue to receive the unsupported data conversion error. This is getting mighty frustrating. Janet Schmitt wrote: I would try something like this for the Oracle portion: CREATE OR REPLACE PACKAGE schemaname.studentpackage IS TYPE

Re: Cold Fusion and Oracle

2004-03-09 Thread Richard Crawford
Stacy Young wrote: Perhaps I spoke too soon...I just remembered an unsolved mystery with our CF servers relating to an occasional JDBC error involving CF_SQL_NUMBER and a numeric field in oracle. Thanks for the tip! Stace Stace, How did you resolve the issue?I think I'm having

RE: Writing Files without CFFILE

2004-03-09 Thread Craig Dudley
I can only assume you were getting 14000 instances of the cfc object, not sure why. You could try creating one instance and storing it in say, the Application scope, and use that, might help. But since it's working now anyway, might be a waste of time. -Original Message- From: Sean

Re: Cold Fusion and Oracle

2004-03-09 Thread sampath nellutla
connection on (oracle thin client) development server and throws following error. ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'SPL_PROC_SUMMARY' ORA-06550: line 1, column 7: PL/SQL: Statement ignored -sampath [Todays Threads] [This Message]

RE: SQL Help

2004-03-09 Thread Bruce, Rodney S HQISEC/Veridian IT Services
Need to play around with this for awhile and see what I get. For some reason thought I tried NOT LIKE, but dont remember now ;o\ Agreed this is not a very good way to handle this. I did not designed the DB nor can I change it. Have to work with what they gave me. -Original Message-

RE: SQL Help

2004-03-09 Thread Bruce, Rodney S HQISEC/Veridian IT Services
Using MS SQL 2000, and have used subqueries with it before. But think the best option so far might be the NOT LIKE suggtion by Mark. Thanks for this option also,need to play with all of them and see what I get. This DB is just sooo screwed up, that its turning my brain to mush. Thanks

RE: SQL Help

2004-03-09 Thread Mark A. Kruger - CFG
Don't you hate having to deal with someone elses bad design g.Actually it beats dealing with your own bad design - at least you can point a finger (ha). -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 09, 2004 12:07 PM To:

RE: Single quotes, CF5, and MS Access

2004-03-09 Thread Thane Sherrington
At 09:33 AM 3/09/04 -0800, Ian Skinner wrote: cfset ID = 1 cfset test=Hi, this line has a single quote [ ' ] in it.Didn't I tell you it did. cfset updateValue = perserveSingleQuotes(test) cfquery UPDATE table SET field = cfqueryParam value=#updateValue# cfsqltype=cf_sql_varchar WHERE ID =

OT: Website hijacking

2004-03-09 Thread Eric Creese
Got a question. I just noticed that when I bring up a browser and type. www.houseoffusion.com in the address bar and submit. It first goes to http://list2004.com/p/www.houseoffusion.com before going to http://www.houseoffusion.com Does anyone know how to get rid of this? I can not find it on my PC

SQL custom Order by

2004-03-09 Thread Mark W. Breneman
I doubt this is possible, but is there a way to do a custom order by based on the order I provide?I need the SQL results to be in a specific order based on the catID, but not in ascending or descending order. The order that I want them in is 10,3,5,1,7,4,9,2,6,8. Example Select * >From table

Re: Writing Files without CFFILE

2004-03-09 Thread Sean Daniels
On Mar 9, 2004, at 12:38 PM, Craig Dudley wrote: I can only assume you were getting 14000 instances of the cfc object, not sure why. You could try creating one instance and storing it in say, the Application scope, and use that, might help. But since it's working now anyway, might be a waste

RE: SQL Help

2004-03-09 Thread Jochem van Dieten
Ian Skinner said: My first suggestion would be an embed sub-query. That would work if you add another level for the Govt condition. SELECT fields FROM Table. ( SELECT fields FROM TABLE WHERE Name LIKE %Engineering% ) AS FooBar WHERE FooBar.ID = Table.ID AND Name LIKE %Open% Of

RE: Single quotes, CF5, and MS Access

2004-03-09 Thread Ian Skinner
Well, I'm not sure, but you can try the cfqueryparam's with out the cfsqltype parameter, it is optional IIRC if highly useful.I would try it without the type to just get the code to work, then try and figure out how to get it back in. Confidentiality Notice:This message including any attachments

Re: Why use Cold Fusion vs. other languages?

2004-03-09 Thread Dick Applebaum
Good points, John Of course you have to bring the real world into the discussion. Some important advantages of CF are its power, simplicity and self-documenting ability. CF's OO capabilities and extensibility are important strengths for real-world apps and large, complex projects. Many of

Re: Writing Files without CFFILE

2004-03-09 Thread Jon Gunnip
And that seems to be gobbling as much RAM as before. In any event, as you said, it's working great when I bypass the CFC so no sense beating it to death. Do you have debugging on by any chance?That can really slow down a CFC-intensive request. Jon [EMAIL PROTECTED] 03/09/04 11:29AM On

Re: Website hijacking

2004-03-09 Thread Doug White
Sounds like DNS server problems == Stop spam on your domain, Anti-spam solutions http://www.clickdoug.com/mailfilter.cfm For hosting solutions http://www.clickdoug.com == If you woke up breathing, congratulations! You have

RE: SQL custom Order by

2004-03-09 Thread Plunkett, Matt
-Original Message- From: Mark W. Breneman Sent: Tuesday, March 09, 2004 1:24 PM To: CF-Talk Subject: SQL custom Order by I doubt this is possible, but is there a way to do a custom order by based on the order I provide?I need the SQL results to be in a specific order based on the

Re: SQL custom Order by

2004-03-09 Thread Jochem van Dieten
Mark W. Breneman said: I doubt this is possible, but is there a way to do a custom order by based on the order I provide?I need the SQL results to be in a specific order based on the catID, but not in ascending or descending order. The order that I want them in is 10,3,5,1,7,4,9,2,6,8.

Re: Cold Fusion and Oracle

2004-03-09 Thread Janet Schmitt
Richard - What is the format of the table tblStudentInfo?What are the datatypes specified for sFirst, sLast, sOrient and studentId? What is the CFSTOREDPROC code that was used to call this procedure? Janet. At 09:45 AM 3/9/2004 -0800, you wrote: Janet, Thanks for the suggestion.I tried it,

Frameworks

2004-03-09 Thread bret
Hi All- I know this was discussed a bit a couple weeks ago, but I would like to rehash it a little. I'm working for a local government agency here and to this point, there really has not been any sort of framework or coding standards present in the Web department. One of my first tasks is to

Re: OT: Website hijacking

2004-03-09 Thread Jochem van Dieten
Eric Creese said: Got a question. I just noticed that when I bring up a browser and type. www.houseoffusion.com in the address bar and submit. It first goes to http://list2004.com/p/www.houseoffusion.com before going to http://www.houseoffusion.com Looks like spyware. Does anyone know how

RE: Frameworks

2004-03-09 Thread Tony Weeg
OH NO I CAN HEAR IT NOW Framework World War 451 here it comes -Original Message- From: bret [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 09, 2004 1:49 PM To: CF-Talk Subject: Frameworks Hi All- I know this was discussed a bit a couple weeks ago, but I would like to rehash

RE: Website hijacking

2004-03-09 Thread Rob
btw this is an excellent (free) product. I put it on anyones windows 'puter that I like. http://www.safer-networking.org/ On Tue, 2004-03-09 at 10:51, Mark W. Breneman wrote: You can go to Internet Properties in your control Panel and click on the Connections tab then click the Setup. Button

Re: Cold Fusion and Oracle

2004-03-09 Thread Richard Crawford
Janet Schmitt wrote: Richard - What is the format of the table tblStudentInfo?What are the datatypes specified for sFirst, sLast, sOrient and studentId? What is the CFSTOREDPROC code that was used to call this procedure? Janet. Janet, Here is the table definition:

CFMX with Oracle 9 or 10G?

2004-03-09 Thread bret
Me again- The org I work for is currently running Oracle 8.1.7 and is looking to upgrade. The question now is how does the new 10G Oracle version run with CFMX, and does it require custom JDBC drivers. Anyone have experience with this? I'm assuming Oracle 9 runs jim dandy on CFMX. So given

Re: Cold Fusion and Oracle

2004-03-09 Thread Richard Crawford
sampath nellutla wrote: CFSTOREDPROC procedure= mySchema.myPackage.spl_proc_summary datasource=#request.datasource# Based on my own understanding, this line: cfprocparam cfsqltype=CF_SQL_REFCURSOR type=OUT is unnecessary in CFMX+. CFPROCRESULT NAME=rs1 /CFSTOREDPROC Now if only I could

Re: Frameworks

2004-03-09 Thread Jerry Johnson
A couple of questions spring to mind. What version of CF (I think the answer is CFMX, but not sure if that is true system wide, as in do you have a mix of versions) Percentage of public facing vs intranet administration Level of experience of other developers. How often do you turnover

Re: Frameworks

2004-03-09 Thread bret
Tony Weeg wrote: OH NO I CAN HEAR IT NOW Framework World War 451 here it comes I know! I had a feeling this might spawn some heated discussions, but I honestly tried to search the HOF archives and text search is down. Time to don the flak jacket and take shelter. :-) -Bret

Re: Frameworks

2004-03-09 Thread Adam Churvis
If you want me to add you to the Plum (Practical Lightweight Universal Methodology) Beta testers list then email me offlist. Plum stands for Practical Lightweight Universal Methodology, and it's a combination of a powerful code generator, a comprehensive application framework, online project

RE: Frameworks

2004-03-09 Thread Barney Boisvert
- Fusebox FB3 was great, FB4 is fantastic.Couple either of these (FB4's preferable) with a CFC backend and I don't know that you can get a much better framework. - MachII Also very good, although has a steeper learning curve and reduced ability to easily throw an shoot from the hip app together

CF based real-time support

2004-03-09 Thread Bryan Stevenson
Hey All, I'm starting my research into various live support apps...wondering what may already exist for CF...or that might integrate easily into any site? TIA Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL

Re: Frameworks

2004-03-09 Thread bret
Excellent questions. Responses are below: Jerry Johnson wrote: A couple of questions spring to mind. What version of CF (I think the answer is CFMX, but not sure if that is true system wide, as in do you have a mix of versions) Currently, CF 5 on our external web server, CFMX 6.1 on

Re: Query Result to a comma list

2004-03-09 Thread Paul Giesenhagen
That was the ticket ... thanks Paul Giesenhagen QuillDesign - Original Message - From: Ubqtous To: CF-Talk Sent: Tuesday, March 09, 2004 10:32 AM Subject: Re: Query Result to a comma list Paul, On 3/9/2004 at 11:21, you wrote: PG How do you convert a query result column to a comma

RE: Website hijacking

2004-03-09 Thread Bailey, Neal
Yeah that sounds like spy-ware to me... Try Ad-aware I found that it's pretty good and free. http://lavasoft.element5.com/default.shtml.en http://lavasoft.element5.com/default.shtml.en Neal Bailey Internet Marketing Manager E-mail:mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] _ [Todays

Re: Tortoise CVS

2004-03-09 Thread Tero Pikala
Hi I wrote some time ago small script that also adds history to fusedoc before commiting file to CVS from Studio/HomeSite.This works for me quite well - when commiting files I don't have to leave Studio, other work can be done with WinCVS or Tortoise. It's just calling cvs.exe which should be

Limiting User to Select 2 Checkboxes per Group

2004-03-09 Thread Jillian Carroll
Hey! I've got a project where I've got 5 groups of golfers... and I need folks to be able to choose up to 2 golfers per group... no more, no less. Anybody have any advice on how best to do this? This is what I have so far: form name=team_info action="" method=post !--- Select all

RE: Limiting User to Select 2 Checkboxes per Group

2004-03-09 Thread Barney Boisvert
Just use some _javascript_ to loop over each checkbox group (name all checkboxes in a group the same thing), and count how many are checked.If it's two, great, otherwise show an error message and don't let the form submit. Cheers, barneyb -Original Message- From: Jillian Carroll

Re: CF based real-time support

2004-03-09 Thread Terri Hodgson
I'm involved with a company that is using FlashComm Server chat with CF as a way of real time support. Haven't seen any others out there that use CF.Only PHP or Java. Terri Terri Hodgson WildBlue Web Solutions http://www.wildblueweb.ca --- Bryan Stevenson [EMAIL PROTECTED] wrote: Hey All,

  1   2   >