Re: Setting up Oracle datasource in MX

When I first read your responses I thought you'd misunderstood my question. It turns out it is that simple. Thank you both so much! Bob Bob, Just use the value that you would find in the tnsnames.ora file if you had one on the machine.Make sense? Scott -Original Message- From: Bob

RE: CFMX performance improvements ?

I strongly suggest not using Erik's treeview. It is not stable and contains some serious bugs which cannot be solved because they depend on buggy browser functionality. Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK

RE: Intel HyperThreading

Currently, you get way more bangs for your bucks if you choose the Opteron platform. For desktop usage a Athlon 64 would better fit you. The heat problems AMD is familiar with have been solved along time ago. Intel is the one which suffers from heat problems now, one of the reasons why

RE: Next Dreamweaver release?

Hopefully the bugs which I personally am confronted with on each use, will be fixed. Some time ago I already submitted a huge list to Macromedia. From simple things like failing color coding, to annoying things like a totally screwed up treeview. I click the collapse icon, some other nodes expands

Re: Web/RAD Software Tools Solid CF Code

[EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Anyone here succesfully use any Web/RAD tools to build online applications. I have delved into looking into some UML tools - but most start at $15k + Have you had a look at Synthis' Adalon?http://www.adalon.net/ Stephen [Todays Threads] [This

CF5 vanilla install checklist

Does someone out there have a configuration checklist for a vanilla install of the following please? Win 2003 server CF5 MS SQL server IIS It is the recommended permissions setup I am most interested in. Thanks. -- Regards; Richard Meredith-Hardy

Re: CF5 vanilla install checklist

not security related but there is this technote, http://www.macromedia.com/support/coldfusion/ts/documents/install_cf_win2003.htm for getting cf5 to work on win2003. It's not as simple as a normal install jb. On Thu, 16 Sep 2004 08:31:37 +0100, Richard Meredith-Hardy [EMAIL PROTECTED] wrote:

Coldfusion Exercise

Hi all Does anybody has Coldfusion Exercise for the beginners regards Vishnu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

java class problem

trying to load a java class via cfobject. The initial loading works fine ( ie creating the object instance )... but when I call a method then the server just shuts down. I've compiled and run the class from the command line, so I know it works. It's an odd error really... it's not the usual CF

Re: Next Dreamweaver release?

Theres only two things that really put me off DWMX and keeps me constantly going back to HS+ 5.5 or CFEclipse 1. The file view is HS+/CFS is personally so much better organised. The tree is ok, but when you are 5-6 folders deep (d:\www\wwwroot\sitename\other folder) its takes up a nice chunk of

Re: Next Dreamweaver release?

Please keep sending feedback to the DW's team (yes, they read it all): http://www.macromedia.com/support/email/wishform/ Massimo Foti http://www.massimocorner.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe]

Re: Coldfusion Exercise

I don't know of any one exercise resource for beginners, but one idea would be to look at the sample applications that install with ColdFusion and try building one of them yourself. There are examples that cover everything from simple Hello World to more complex logic with an RIA interface.

Re: CF5 vanilla install checklist

Hmm. It says Please note: Macromedia ClusterCats and the ColdFusion Application Management components are not supported on this platform. What do you suppose ColdFusion Application Management components are? Is this things like the built in way client vars are handled by CFAPPLICATION ? John

Re: java class problem

can you tell us a little more about the class you're trying to load and the server configuration? If JSPs and CFMs both err out when calling the method but the method can be called from the command line, then I'd say it's either something in the code you're using to execute it from JSP or CF or

Re: CF5 vanilla install checklist

i'd guess it's more the SiteMinder stuff that come with cf5, i'm sure cfapplication will be fine On Thu, 16 Sep 2004 11:21:40 +0100, Richard Meredith-Hardy [EMAIL PROTECTED] wrote: Hmm. It says Please note: Macromedia ClusterCats and the ColdFusion Application Management components are not

RE: Problem with passing values to popup

formWin = window.open('http://www.urlname/newsletter/admin/ebomb_pop.cfm?bombsaway=tr uesubject=#form.subject#emailtype=#form.emailtype#whichtable=#form.whicht able#town=#form.town#','ScapeBomb','width=300,height=300,toolbar=no,locatio

RE: Problem with passing values to popup

Also, you’re gonna have to scope those cfparam’s as form. if you’re calling them as form. _ From: Ewok [mailto:[EMAIL PROTECTED] Sent: Thursday, September 16, 2004 6:49 AM To: CF-Talk Subject: RE: Problem with passing values to popup formWin =

Storing CGI vars in text file using HTTP Post

Hi I am trying to use HTTP POST to send the cgi vars to a cfm file which store all the cgi vars in a text file. But the text file has all those % in it. My code is as follows cfhttp method = post url = ""> cfhttpparam name = cgiVar type = CGI value = CGI.AUTH_TYPE:#CGI.AUTH_TYPE# --

RE: Storing CGI vars in text file using HTTP Post

Use type=formfield and then #form.cgiVar# in the other page Pascal -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: 16 September 2004 13:10 To: CF-Talk Subject: Storing CGI vars in text file using HTTP Post Hi I am trying to use HTTP POST to send the

RE: Storing CGI vars in text file using HTTP Post

Great thanks _ From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: 16 September 2004 12:14 To: CF-Talk Subject: RE: Storing CGI vars in text file using HTTP Post Use type=formfield and then #form.cgiVar# in the other page Pascal http://www.houseoffusion.com/banners/view.cfm?bannerid=38

RE: Blackstone Beta

Have a look at wget, it has a resume option. I used it for bigger downloads when I was on dialup. Ade -Original Message- From: vishnu prasad [mailto:[EMAIL PROTECTED] Sent: 16 September 2004 06:48 To: CF-Talk Subject: Re: Blackstone Beta Hi Dave i did't ask in the sense of violation ,i

create table error

I'm trying to create a set of relational tables in Oracle.I'm receiving the error missing right parenthesis. The only other relational work that I've done was in mySQL so I'm sure that it's a syntax or keyword Oracle issue. Here's the two tables and it's the second one that gives me the error:

RE: create table error

Two things I'd guess at, try a semi-colon between statements and the !-- all possible answers for any poll available -- comment is an HTML one not a CF one, add two more hyphens !--- --- Ade -Original Message- From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: 16 September 2004 12:47

Re: create table error

If you mean have a semi-colon between each create table and create sequence, I actually input them seperately, individually.Not as a set of statements.When I get the error, I'm only doing (without the comments field which I only have in my documentation): create table fsnep_pollAnswers ( pA_id

RE: Next Dreamweaver release?

I stopped sending the bugs through this form. I hate it to take 15 minutes time to carefully write out the bug, methods to reproduce, and notes about the bug, and not even get the slightest thank you message whatsoever. I don't even know if the mail has been seen, or if it has been stuck in

Re: create table error

daniel kessler wrote: If you mean have a semi-colon between each create table and create sequence, I actually input them seperately, individually.Not as a set of statements.When I get the error, I'm only doing (without the comments field which I only have in my documentation): create table

Re: create table error

That great and it executed. So I don't have a foreign key anymore?Is it not needed?I think that it's part of the available Oracle syntax, so what do I lose by not having it? btw, anyone know of a good online Oracle reference or list? create table fsnep_pollAnswers ( pA_id NUMBER Primary Key,

Re: create table error

daniel kessler wrote: That great and it executed. So I don't have a foreign key anymore?Is it not needed?I think that it's part of the available Oracle syntax, so what do I lose by not having it? You foreign key is still there, you just don't need the foreign key keyword if you define your

Re: create table error

I appreciate the explanation.It's much simpler to read. For the online reference, I didn't this topic specifically, though that's why I needed it today.I find google only good if I KNOW the keywords that I need.An online reference is a little easier to browse.I have a good CF one. I did find a

RE: CF5 vanilla install checklist

What do you suppose ColdFusion Application Management components are? Is this things like the built in way client vars are handled by CFAPPLICATION ? CF 5 used JRun to keep track of CF server settings and server state, and that's what this refers to, I think. You'd end up with several

RE: CF5 vanilla install checklist

Does someone out there have a configuration checklist for a vanilla install of the following please? Win 2003 server CF5 MS SQL server IIS It is the recommended permissions setup I am most interested in. I don't think that Macromedia provides a recommended configuration for permissions,

RE: CFTRANSACTION

when i run the query like this its working fine cfquery datasource=one name=one insert statment cfquery cfquery datasource=two name=rwo insert statment cfquery but when i put in transcation i got the error CFTRANSACTION cfquery datasource=one name=one insert statment cfquery cfquery

Re: Blackstone Beta

look at the beta newsgroup topics, there is mention in there about this issue. Doug - Original Message - From: Adrian Lynch [EMAIL PROTECTED] Date: Thu, 16 Sep 2004 12:38:24 +0100 Subject: RE: Blackstone Beta To: CF-Talk [EMAIL PROTECTED] Have a look at wget, it has a resume option. I

Re: Next Dreamweaver release?

I stopped sending the bugs through this form. That's your choice I hate it to take 15 minutes time to carefully write out the bug, methods to reproduce, and notes about the bug, and not even get the slightest thank you message whatsoever. For what's worth, you are supposed to get an

RE: CFTRANSACTION

thks for your response,i think its possible in java is it not possible to have implement tow phase commit in Coldfusion To perform distributed transactions with two-phase commits, you need some specific piece of software, a distributed transaction coordinator, that can do this for you. For

RE: OSQL Cannot find my Northwind

I am running an instance MSDE with on my machine called HOMEFRANKMA. One instance is called NETSDK and contains a database called Northwind (of course). I am trying to access it with OSQL but it gives me an error saying that it's not found in sysdatabases. Are you sure that you have

RE: Next Dreamweaver release?

CFStudio can do it only with CF 5, May be another reason so many people are still with CF 5? I doubt it. I've rarely seen anyone use the CF 5 debugger. I never used it in real life, myself; I found it easier to debug problems manually. It was at one time covered in the Macromedia courseware,

Re: Blackstone Beta

Vishnu, pleae take this to the Beta newsgroup.We can help you there. Thanks Hi All i am into blackstone beta participation, i try to download the Software from the mmbeta.macromedia.com ,other than mx 7i download other things ,due to my poor internet connection i am not able to download

Re: Web/RAD Software Tools Solid CF Code

Has Adalon even announce a date? quarter? year? 3.0 will be released? -Adam - Original Message - From: Stephen Moretti (cfmaster) [EMAIL PROTECTED] Date: Thu, 16 Sep 2004 07:48:29 +0100 Subject: Re: Web/RADSoftware Tools Solid CF Code To: CF-Talk [EMAIL PROTECTED] [EMAIL PROTECTED]

RE: Next Dreamweaver release?

Are you surprised by the fact commercial software ships with obvious, well-know bugs? That is complete a complete bullshit statement, .. There are plenty software vendors out there releasing working software in a way a bug could exist but not preventing a user from using the product in a normal

Re: Intel HyperThreading

Micha Schopman wrote: The heat problems AMD is familiar with have been solved along time ago. Intel is the one which suffers from heat problems now, one of the reasons why manufactures go to 0.09 processes instead of 0.13. Intel's 9nm chips suffer from heat just as much as the older ones, you

Help with GetPageContext().Include()!!!

Hello all. Some strange or (so it seems so) behavior with GetPageContext().Include() function. If you set a session variable at the top of a page, execute a GetPageContext().Include() below, and try to access the session variable from the included page, CF cannot find the session variable. If I

Re: Next Dreamweaver release?

Are you surprised by the fact commercial software ships with obvious, well-know bugs? That is complete a complete bullshit statement, .. There are plenty software vendors out there releasing working software in a way a bug could exist but not preventing a user from using the product in a

evaluating variables

I am trying to build variables for query output.I am receiving the error, cannot assign a variable to a function.I am trying to make p_answer1, p_answer2, p_answer3, for as many answers as I have.How might I restructure this code to accomplish it. cfif get_A.recordcount NEQ 0 cfoutput

Re: Web/RAD Software Tools Solid CF Code

Has Adalon even announce a date? quarter? year? 3.0 will be released? -Adam - Original Message - From: Stephen Moretti (cfmaster) [EMAIL PROTECTED] Date: Thu, 16 Sep 2004 07:48:29 +0100 Subject: Re: Web/RADSoftware Tools Solid CF Code To: CF-Talk [EMAIL PROTECTED] [EMAIL PROTECTED]

RE: evaluating variables

cfset p_answer#get_A.currentRow# = p_answer Pascal -Original Message- From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: 16 September 2004 15:49 To: CF-Talk Subject: [Spam?] evaluating variables I am trying to build variables for query output.I am receiving the error, cannot

Using a value from one insert for another insert

I'm in Oracle.I do an insert for a poll question, then I need to get the ID of that question and insert it into each one of the answers that I write to a different table (see code below).Without a separate query, is there any way to get the ID inside the same query to use again for the

Re: evaluating variables

Daniel, Try this: cfif get_A.recordcount cfoutput query=get_A cfset variables[p_answer get_A.currentRow] = p_answer /cfoutput /cfif Also, you could copy things into an array, it'd probably be a slightly better practice: cfset p_answer = arrayNew(1) / cfif get_A.recordcount cfset

RE: CFTRANSACTION

You could do something manually using a try and catch block, then put delete query (essentially undoing the first query) in the catch block... Definitely not a true rollback but would probably suit most cases. Patrick McGeehan Applications Developer DIT CF_DIT#mcg#/CF_DIT -Original

Re: Coldfusion Exercise

I have learned a lot from visiting http://www.easycfm.com.Have fun, I enjoy CF. Russell - Original Message - From: vishnu prasad To: CF-Talk Sent: Thursday, September 16, 2004 3:25 AM Subject: Coldfusion Exercise Hi all Does anybody has Coldfusion Exercise for the beginners regards

Re: evaluating variables

Ah, thanks Pascal and Joe Try this: cfif get_A.recordcount cfoutput query=get_A cfset variables[p_answer get_A.currentRow] = p_answer /cfoutput /cfif Also, you could copy things into an array, it'd probably be a slightly better practice: cfset p_answer = arrayNew(1) / cfif

Re: Using a value from one insert for another insert

Isn't there a CURVAL for the sequence? It's been awhile since I've worked with Oracle (version 8) Greg - Original Message - From: Daniel Kessler [EMAIL PROTECTED] Date: Thu, 16 Sep 2004 09:56:46 -0400 Subject: Using a value from one insert for another insert To: CF-Talk [EMAIL PROTECTED]

Re: Using a value from one insert for another insert

Well you should put it in a procedure rather than inline. Then you could do something like: INSERT INTO fsnep_polls ( p_id,p_date_added,p_question, p_status,p_date_last_used ) VALUES ( unique_poll_Num_s.NEXTVAL,#Now()#,'#Form.p_question#', #Form.p_status#,#p_date_last_used# ) RETURNING p_id INTO

Re: Coldfusion Helpdesk

Brant, plug We make a ColdFusion help desk called CFTicket. You can find out more about it at www.cornfeed.com. This is the second version we have released and should support most features you can think of. There is a demo on there too so you can play with it and see if it suits your needs.

Re: Using a value from one insert for another insert

I'm now receiving an invalid character error.I can do each of the inserts independently, but when I put them together with the RETURNING line, I get the error. INSERT INTO fsnep_polls ( p_id,p_date_added,p_question, p_status,p_date_last_used ) VALUES (

RE: Using a value from one insert for another insert

I don't know the proper way to do this, but I can tell you the hideously unattractive and effective three-query way that I do it.I use various items to create something that I know will be unique.For example, I concatenate user ID and current time.I put that in a local variable.I run the insert

Re: Using a value from one insert for another insert

eww, that is ugly :-) But it shows that I might just be done by now if I had just done multiple queries to accomplish the task.I guess I could do a cflock around them to group'em. I don't know the proper way to do this, but I can tell you the hideously unattractive and effective three-query way

[Repost] Coldfusion form validation Safari

Just posting this again as no one answered my post on the 14th I'm really hoping someone out there has some info! -- using the innate form validation in cfmx (using a regular _expression_ with the pattern of (^[_a-zA-Z0-9-]+(\.[_a-zA-Z0-9-]+)[EMAIL

RE: installing Apache for Windows...

I would like to re-open this question with one change to the parameter. Windows 2003. Rick Eidson Partner CTO ArcRiver Technology, LLC ASP, PHP, PERL, Cold Fusion Hosting Kansas City http://www.arcriver.com/ http://www.arcriver.com/ Kansas City Musicians http://www.kcjukebox.com/

RE: installing Apache for Windows...

BTW, I gave up on this.I found that there was no need to install Apache, since my end goal was to get PHP running, and they make a version for windows.Just wanted to put that in there for archival sake. THX Ray At 11:38 AM 9/16/2004, you wrote: I would like to re-open this question with one

Re: Using a value from one insert for another insert

Like I said before, you can only use RETURNING in a PL/SQL procedure. Not inline. Your only option of keeping it in one query is CURRVAL. -Adam - Original Message - From: daniel kessler [EMAIL PROTECTED] Date: Thu, 16 Sep 2004 10:53:30 -0400 Subject: Re: Using a value from one insert for

RE: installing Apache for Windows...

PHP Nuke requires Apache. Rick Eidson Partner CTO ArcRiver Technology, LLC ASP, PHP, PERL, Cold Fusion Hosting Kansas City http://www.arcriver.com/ http://www.arcriver.com/ Kansas City Musicians http://www.kcjukebox.com/ -Original Message- From: Ray Champagne [mailto:[EMAIL

RE: installing Apache for Windows...

I would like to re-open this question with one change to the parameter. Windows 2003. Apache 2.0.whatever runs fine on my Windows Server 2003 laptop. There wasn't any difference between installing it on Windows Server 2003 and installing it on Windows 2000. Dave Watts, CTO, Fig Leaf

RE: installing Apache for Windows...

CFNuke requires Apache. Rick Eidson Partner CTO ArcRiver Technology, LLC ASP, PHP, PERL, Cold Fusion Hosting Kansas City http://www.arcriver.com/ http://www.arcriver.com/ Kansas City Musicians http://www.kcjukebox.com/ -Original Message- From: Ray Champagne [mailto:[EMAIL

RE: installing Apache for Windows...

Should I not even install IIS? Rick Eidson Partner CTO ArcRiver Technology, LLC ASP, PHP, PERL, Cold Fusion Hosting Kansas City http://www.arcriver.com/ http://www.arcriver.com/ Kansas City Musicians http://www.kcjukebox.com/ -Original Message- From: Dave Watts [mailto:[EMAIL

RE: Using a value from one insert for another insert

But it shows that I might just be done by now if I had just done multiple queries to accomplish the task. I guess I could do a cflock around them to group'em. If you want to ensure that all the queries run as a single transaction, use CFTRANSACTION, not CFLOCK. Dave Watts, CTO, Fig Leaf

RE: OT: Next Dreamweaver release?

Sean, If CF created class files that could be debugged with Java tools, we'd be debugging the generated Java code and not the CF code.Certainly it would work, but even those very familiar with Java would probably rather debug the CFML code directly. Or is there something else I'm

RE: Next Dreamweaver release?

I used it all the time and really miss it. In my other work (Flash, Flex, Java, C#) I use the debugger all the time (very buggy code I guess). Sam -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Thursday, September 16, 2004 9:15 AM To: CF-Talk Subject: RE: Next

Development Team Advice

Hello All, 1) Can anyone recommend an application that will manage a CF Web Dev team and keep internal/external customer/clients informed as to deadline extensions and reshuffling of project priorities? Nothing to overkill an preferabley something written in CF that we could modify. If not,

HTTPS CF Admin

Does anyone recall the fix from MM for the left nav bar in the CFADMIN when accessing it over HTTPS? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Re: HTTPS CF Admin

On Thu, 16 Sep 2004 12:06:52 -0400, Tangorre, Michael [EMAIL PROTECTED] wrote: Does anyone recall the fix from MM for the left nav bar in the CFADMIN when accessing it over HTTPS? http://www.macromedia.com/support/coldfusion/ts/documents/navserver_blank.htm FYI, you can keep track of all

Re: Using a value from one insert for another insert

If you are going to go the multi-query route, why not create a UUID, insert that into a field dedicated for same and then query back for it just after the insert? cfset variables.uid=createuuid() insert goes here select idfield where uidfield=variables.uid No locks or transaction blocks

Re: Development Team Advice

Can't help with 1) because what we use we wrote and can't distribute. For 2), you only need one CF license for your dedicated staging server.I'd recommend having each developer installing the CF developer edition on their local box, then moving their code up to the shared development box. -joe

RE: Development Team Advice

1) Can anyone recommend an application that will manage a CF Web Dev team and keep internal/external customer/clients informed as to deadline extensions and reshuffling of project priorities? We've been using Basecamp for the last couple of months - it's a hosted service but is very easy

Re: Development Team Advice

I can answer some ideas to 2)The simple answer is Yes. with regards to development methodology it tends to be better for developers to develop on their own machines (if possible!) so not to affect others during development.Using versioning (such as CVS or VSS) they check in their code to a

Re: Help with GetPageContext().Include()!!!

I can't confirm whether or not this is the expected behaviour, but I can confirm this behaviour applies to a number of scopes, in fact the only one that worked was the request scope (and though I haven't tested this the application scope should work as well). If you do a : cfdump

Re: CFTRANSACTION

If you are using SQL Server, and the architechture of your application permits it, it is possible to give one account the appropriate permissions to both databases. You can then explicity name the 2nd db you are trying to access (e.g. insert into [db2].dbo.[tablename]...) I think then it should

RE: HTTPS CF Admin

From: Dave Carabetta [mailto:[EMAIL PROTECTED] http://www.macromedia.com/support/coldfusion/ts/documents/navs erver_blank.htm FYI, you can keep track of all hotfixes here: http://www.macromedia.com/support/coldfusion/ts/documents/tn17883.htm Thank you. I thought this might have been

RE: Oracle Stored Procedures

Janet, That makes sense.I was able to get it to run in sql*plus now by doing: VARIABLE rs REFCURSOR execute :rs := test01.testpckg(:rs); print rs Thanks, Scott -Original Message- From: Janet Schmitt [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 15, 2004 9:36 AM To:

RE: Development Team Advice

1. I'm not sure if it will work perfectly, but we use proworkflow (www.proworkflow.com) and it helps with a lot of tasking and interaction with clients.It's written in CF and may suit your needs. 2. I believe you do.The developer version only allows access from a single IP, I think.Others can

Re: [Repost] Coldfusion form validation Safari

I'm not sure if this is the issue, but your parens seem to be unbalanced. Does this regex ever match an email in Safari?That is, you've said that if you enter it wrong, then correct it, it doesn't match.But does it match if you enter one correctly the first time? --Ben Amanda Lappin -

RE: SOT: How to apply a style sheet to a file upload bottom.

Asim, Did you find the code that works or the example URL.I tried your code but I cannot upload the file. CF states that file does not exist. Am I doing something work? Mario -Original Message- From: Sandy Clark [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 15, 2004 10:00

SQL, count

I've got a SQL query which for love or money i cant seem to get my head around. The table: id2 name id1 -- 1 andy 181 2 bob1 3 Jim2 4 helen1 To explain what you are looking at a user with the ID 181 invited Andy Andy with the ID 1 invited bob and helen And

Weird

This is probably very easy, but I think I need a fresh set of eyes: The code below returns: form.ML_3_9 c'mon form.ML_3_32 eileen form.ML_3_31_Date {t '00:00:00'} form.ML_3_10_Date {t '00:00:00'} form.ML_3_53 dfgdfh When it should be showning a date value for form.ml_3_31 and 3_10. I've included

Re: CF5 vanilla install checklist

Dave Pls see below Dave Watts wrote: Does someone out there have a configuration checklist for a vanilla install of the following please? Win 2003 server CF5 MS SQL server IIS It is the recommended permissions setup I am most interested in. I don't think that Macromedia

Re: Coldfusion Helpdesk

We use cfticket for www.terraxsite.com, and I totally love it.. i'd never be able to keep track of tickets w/o it! I 3 cfticket /crit -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-[ Ctz Consulting ]-= =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-[ http://ctzconsulting.com ]-= - Original

Re: SQL, count

perhaps this will get you started? SELECT NAME, id2, COUNT(id1) OVER (PARTITION BY id2) FROM invite NAME ID2 COUNT(ID1)OVER(PARTITIONBYID2) bob 1 2 helen 1 2 Jim 2 1 andy 181 1 On Thu, 16 Sep 2004 17:47:15 +0100, Andy J [EMAIL PROTECTED] wrote: I've got a SQL query which for love or money i

Re: CF5 vanilla install checklist

By the way, is there any checklist for install CFMX on the same system except for Apache as a web server? George [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

RE: CF5 vanilla install checklist

Is that written down somewhere you know of (for CF5)? This was written for CF 4, but I think it'll work for CF 5 as well: http://www.defusion.com/articles/index.cfm?ArticleID=89 Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads]

RE: installing Apache for Windows...

Should I not even install IIS? Not if you plan to use Apache as your web server. Personally, on Windows Server 2003, I prefer IIS for production use, but that's up to you. You may want to install the SMTP component of IIS. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone:

Re: SQL, count

select count(*), id1 from tablename group by id1 ? -joe - Original Message - From: Andy J [EMAIL PROTECTED] Date: Thu, 16 Sep 2004 17:47:15 +0100 Subject: SQL, count To: CF-Talk [EMAIL PROTECTED] I've got a SQL query which for love or money i cant seem to get my head around. The

SOT: Hide/Show page sections and internal anchors

Hey All, I think I have an idea why this is happening, but can't dream up a solution right now.. THE SETUP: -User Account page with 4 sections -Each section is hidden by default and only shows a section header -Each section header has a link to show/hide that section (via DHTML...kinda like

Oracle Stored Procedure - another shot, now with procedure code

Thanks to all who have offered advice thus far.I have since been able to get this running in SQL plus, but still get the same error in CF. (MX, Enterprise edition, using default Oracle driver) Error received: [Macromedia][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 7: PLS-00306: wrong

RE: Oracle Stored Procedure - another shot, now with procedure code

Thanks to all who have offered advice thus far.I have since been able to get this running in SQL plus, but still get the same error in CF. (MX, Enterprise edition, using default Oracle driver) Error received: [Macromedia][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 7: PLS-00306: wrong

RE: Weird

Addendum: Okay this is weird, at the bottom of debugging it shows the form variables as listed at the bottom of the first post, but when I dump the form structure, I get: struct FIELDNAMES ML_3_9,ML_3_32,ML_3_31_DATE_TIME__TIME_REGION,ML_3_10_DATE_TIME__TIME_REGION ,ML_3_53,REQUESTED_INFO

Whole day comparison

In access one way of comparing whole days in a DateTime field is with DateValue() thus: SELECT X,Y,Z WHERE datevalue(UPDATED) = #createOdbcDate(mydate)# unfortunately the dateValue() function doesn't exist in MS SQL so another way to do it is: SELECT X,Y,Z WHERE

Re: CF5 vanilla install checklist

Thanks! Shall try it. Dave Watts wrote: Is that written down somewhere you know of (for CF5)? This was written for CF 4, but I think it'll work for CF 5 as well: http://www.defusion.com/articles/index.cfm?ArticleID=89 Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone:

RE: CF5 vanilla install checklist

By the way, is there any checklist for install CFMX on the same system except for Apache as a web server? I'm not sure what you mean. If you're referring to the ability to run CFMX as a specific user, that's very easy to do. I think there's an MM technote that covers this. Dave Watts, CTO, Fig

RE: SQL, count

What i basically need to do is get a list of ID2 and a count of the people ID1 invited. Andy, How about a self join?(The following assumes that the name of your table is NAMES). query=qNames SELECT INVITERS.ID2 AS InviterID, INVITERS.NAME AS InviterName, INVITEES.ID2 AS InviteeID,

Re: [Repost] Coldfusion form validation Safari

thanks for replying :) i'm not sure what you're referring to as not matching up - i'm not seeing it - i went through section by section deleting just to double check? (i had stuck that whole phrase in parentheses so the regex is only between the quotes in my previous post, in case that may have

  1   2   >