Re: Dreamweaver Autocomplete

2004-10-20 Thread dave
i did dl eclipse again to take another look but its kinda a pain in the ass too set up 
and was hoping to use it as a quick fix to dive into code without opening dw. :( looks 
a lot better than before though

as for dw just cause it doesnt act just like cf studio doesnt mean its bad, might just 
be different as u'd expect since it has to handle far more then cf studio did. Its 
always a bit frusterating when using something else, see above with cfeclipse and me 
tonight. But once u realize the power then u dont look back. I think snippets are 
friggin great, plus their portability is wonderful, its the one thing i can count on 
not having to reinstall (except to copy  paste) when reinstalling the piece o shit OS 
(aka winxp).
Now when i go back to hs+, it looks like just what it is, OLD...


-- Original Message --
From: Spike [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:  Tue, 19 Oct 2004 22:58:57 -0700

Dreamweaver is indeed a nice product, but I tend to be biased towards 
cfeclipse. It's got most of the features I need because I put them there ;)

I have used CFStudio, Homesite 5.5 , Homesite+ and DreamWeaver 
extensively. None of them had some of the features I thought were 
important for development with CFMX, so I started working on the 
cfeclipse project. We are slowly creeping towards the point where it's a 
hands down winner over DW and Homesite in some areas, but there's still 
a lot of work to be done.

As with any editor, individual experiences may differ and as I said, I'm 
biased :)

Spike

Mike Kear wrote:
 And with DreamweaverMX too.  For example, I like to use CTRL-ALT-C to
 wrap selected text in a CF Comment.   So I have a snippet that is set
 to put ![   before the selected text, and ] after it,  then
 assigned that snippet to the keyboard shortcut CTRL-ALT-C.   Now, I
 select text,  hit the keyboard shortcut and i have a coldfusion
 comment that I think is neater than the  standard one because it has
 the neat little square brackets around the commented text.
 
 I started out as a very less-than-gruntled studio fan and forced
 myself to learn about Dreamweaver.  Never mind why, I just did ok?   
 And I've become a fan of DWMX.  I have since worked at shops that use
 Studio or Homesite and I can honestly say that while Studio is a good
 product, and I can happily work with it, I know both DWMX and Studio
 very well, and prefer DWMX.   It's easy to say, this feature doesnt
 work exactly as it does in Studio therefore its no good, but get used
 to it and I reckon you'll be a fan of the product too.   Nearly
 everything you wanted to do in Studio can be done in DWMX, and
 sometimes in a slightly different way. But it has scores of additional
 features that arent in the other tools.
 
 Cheers
 Mike Kear
 Windsor, NSW, Australia
 AFP Webworks
 http://afpwebworks.com
 .com,.net,.org domains from AUD$20/Year
 
 
 
 On Tue, 19 Oct 2004 11:03:11 -0700, Spike [EMAIL PROTECTED] wrote:
 
This may or may not be of interest to you, but you can do this in cfeclipse.

You can specify a unique set of trigger characters for each snippet. If
you type those characters followed by ctrl+i (or whatever custom
shortcut you change that to) it will insert the full snippet with your
cursor at the position between the start and end blocks of the snippet.

You can do a lot more than that if you also use snippet variables, but
that's probably getting a bit off topic.

Of course, if you don't want to, or can't use cfelcipse then that's a
moot point, but I thought was worth mentioning.

Spike
 
 
 



~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181966
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: RegEx problem

2004-10-20 Thread Andy Jarrett
There's also CF RegEx at http://www.cfregex.com/ which is donationware

Andy
www.andyjarrett.co.uk



On Tue, 19 Oct 2004 19:23:16 -0400, dave [EMAIL PROTECTED] wrote:
 http://www.regexbuddy.com/
 so thats your secret charlie ;)
 
 

~|
The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in 
the Washington DC Area. 
http://www.houseoffusion.com/banners/view.cfm?bannerid=44

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181967
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: exception handling, kindly help

2004-10-20 Thread cf coder
Can somebody please help? I don't know where to go from here. I'll really appreciate it

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181968
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


UUID as cftoken / createUUID bug

2004-10-20 Thread Andy Allan
This seemed to get lost yesterday, so trying again.

Anyone know how the CFAdmin creates UUIDs for cftoken (see the Server
Settings/Settings page)?

Basically wanting to know if it uses createUUID() and is therefore affected by
the clock speed bug affecting createUUID() on Windows
http://www.macromedia.com/support/coldfusion/ts/documents/createuuid_clock_speed.htm

Cheers,
Andy

-- 
[EMAIL PROTECTED]
www.creative-restraint.co.uk

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181969
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: exception handling, kindly help

2004-10-20 Thread Pascal Peters
I didn't read all the previous posts, but here are some thoughts:

1. cferror and cftry/catch are 2 different things. If you catch an
exception, the exception disappears and doesn't throw an error. 
2. You have a lot of the info that you would have in the error scope in
the cfcatch scope too.
3. the error template will always open in the frame where the error
occurred
4. if you use cferror, any variable set before the error occurred should
still exist. We use fusebox and then it is not to hard to apply the
correct design to the templates, but even without that it should be
possible. You can even place a cferror tag in a page itself and it
should override that of the application.cfm

Pascal

 -Original Message-
 From: cf coder [mailto:[EMAIL PROTECTED]
 Sent: 20 October 2004 10:43
 To: CF-Talk
 Subject: Re: exception handling, kindly help
 
 Can somebody please help? I don't know where to go from here. I'll
really
 appreciate it
 
 

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181970
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: RE: exception handling, kindly help

2004-10-20 Thread simon
you might want to read the whitepaper I've got at: 
http://www.how2cf.com/files/papers/exceptions.pdf (downloadable as a zip from 
http://www.how2cf.com/files/papers/exceptions.zip)

~Simon

 
 I didn't read all the previous posts, but here are some thoughts:
 
 1. cferror and cftry/catch are 2 different things. If you catch an
 exception, the exception disappears and doesn't throw an error. 
 2. You have a lot of the info that you would have in the error scope in
 the cfcatch scope too.
 3. the error template will always open in the frame where the error
 occurred
 4. if you use cferror, any variable set before the error occurred should
 still exist. We use fusebox and then it is not to hard to apply the
 correct design to the templates, but even without that it should be
 possible. You can even place a cferror tag in a page itself and it
 should override that of the application.cfm
 
 Pascal
 
  -Original Message-
  From: cf coder [mailto:[EMAIL PROTECTED]
  Sent: 20 October 2004 10:43
  To: CF-Talk
  Subject: Re: exception handling, kindly help
  
  Can somebody please help? I don't know where to go from here. I'll
 really
  appreciate it
  
  
 
 

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181971
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Got Givex.com code?

2004-10-20 Thread Karl
I'm trying to implement givex.com gift cards (see http://web.givex.com/) in 
ColdFusion, and all I have to go on is some very vague ASP hints and code 
snips to work with.  I'm hoping somebody already has implemented this in 
ColdFusion and will share their code with me . . .

Regards,

Karl Simanonok


~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181972
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Running tasks in a console window?

2004-10-20 Thread James Smith
I have a problem.  I am using cURL to upload a file with https (cfhttp
didn't work before someone suggests that).  When I run cURL from the command
line, it works perfectly in about 3 seconds.  If I run cURL from a batch
file it runs fine in about 3 seconds.

If I use cfexecute to run either cURL or the batch file then the process
fails, cURL hangs, it all goes wrong.  I can even use cffile to write the
batch file and it works from a command line but not from cfexecute.

It even works fine from schtasks.

Is there any way to cause cfm to open a new cmd window and run the batch
file in that instead of running it as a background process?

--
James Smith
[EMAIL PROTECTED]


~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181973
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Running tasks in a console window?

2004-10-20 Thread Hugo Ahlenius
| -Original Message-
| From: James Smith [mailto:[EMAIL PROTECTED]
| Sent: Wednesday, October 20, 2004 12:01
| To: CF-Talk
| Subject: Running tasks in a console window?
|
| I have a problem.  I am using cURL to upload a file with
| https (cfhttp didn't work before someone suggests that).
| When I run cURL from the command line, it works perfectly in
| about 3 seconds.  If I run cURL from a batch file it runs
| fine in about 3 seconds.
|
| If I use cfexecute to run either cURL or the batch file then
| the process fails, cURL hangs, it all goes wrong.  I can even
| use cffile to write the batch file and it works from a
| command line but not from cfexecute.

Have you set a timeout for cfexecute, could that be the case? You could
also try running something else that takes time, to pinpoint if the
problem actually is curl (which I don't think... ?). You can also
capture any stdout/stderr message, for instance by piping it through tee
or just re-directing it to a file (from the batch-file).

/H.
###

This message has been scanned by F-Secure Anti-Virus for Microsoft
Exchange.
For more information, connect to http://www.F-Secure.com/


~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181974
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Running tasks in a console window?

2004-10-20 Thread Craig Dudley
Might be your cfexecute syntax, have you tried passing in any arguments
as an array?

-Original Message-
From: James Smith [mailto:[EMAIL PROTECTED] 
Sent: 20 October 2004 11:01
To: CF-Talk
Subject: Running tasks in a console window?


I have a problem.  I am using cURL to upload a file with https (cfhttp
didn't work before someone suggests that).  When I run cURL from the
command line, it works perfectly in about 3 seconds.  If I run cURL from
a batch file it runs fine in about 3 seconds.

If I use cfexecute to run either cURL or the batch file then the process
fails, cURL hangs, it all goes wrong.  I can even use cffile to write
the batch file and it works from a command line but not from cfexecute.

It even works fine from schtasks.

Is there any way to cause cfm to open a new cmd window and run the batch
file in that instead of running it as a background process?

--
James Smith
[EMAIL PROTECTED]




~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181975
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: exception handling, kindly help

2004-10-20 Thread cf coder
thanks for that... I'll give it a bash
Regards
cfcoder

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181976
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: exception handling, kindly help

2004-10-20 Thread cf coder
thanks Simon

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181977
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Select distinct record - help

2004-10-20 Thread cf coder
Hello everybody,

I was wondering if someone could help me. I am trying to get the distinct record from 
a select statment. Here is the code.

cfquery name=getEmployeeDetails datasource=db
select distinct reference, uniqueID, firstname, lastname
FROM employee
WHERE reference = 'cfcoder'
ORDER BY reference asc
/cfquery

This brings back 2 records, and I want it to only return 1 row. 

select name=custname id=custname 
cfloop query=getEmployeeDetails
option value=#reference##reference#/option
/cfloop
/select

The data in the table looks like this

1   cfcoder cf  coder
2   CFCODEr cf  coder

There are two rows in the table with the same reference. How do I get it to only 
display 1 record. Can somebody please help

Regards
cfcoder

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181978
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Select distinct record - help

2004-10-20 Thread James Holmes
The cASE is killign you - try selecting the UPPER() or LOWER() of the
reference column.

-Original Message-
From: cf coder [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 20 October 2004 8:30 
To: CF-Talk
Subject: Select distinct record - help

Hello everybody,

I was wondering if someone could help me. I am trying to get the distinct
record from a select statment. Here is the code.

cfquery name=getEmployeeDetails datasource=db select distinct
reference, uniqueID, firstname, lastname FROM employee WHERE reference =
'cfcoder'
ORDER BY reference asc
/cfquery

This brings back 2 records, and I want it to only return 1 row. 

select name=custname id=custname
cfloop query=getEmployeeDetails
option value=#reference##reference#/option
/cfloop
/select

The data in the table looks like this

1   cfcoder cf  coder
2   CFCODEr cf  coder

There are two rows in the table with the same reference. How do I get it to
only display 1 record. Can somebody please help


~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181979
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Select distinct record - help

2004-10-20 Thread Peterson, Andrew S.
Hi CFCoder,

Try taking out the unique ID, if that is the 1 and the 2 in your
query result. Or, maxrows=1? Hope this helps.

 Sincerely,
 
Andrew

-Original Message-
From: cf coder [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 20, 2004 7:30 AM
To: CF-Talk
Subject: Select distinct record - help

Hello everybody,

I was wondering if someone could help me. I am trying to get the
distinct record from a select statment. Here is the code.

cfquery name=getEmployeeDetails datasource=db select distinct
reference, uniqueID, firstname, lastname FROM employee WHERE reference =
'cfcoder'
ORDER BY reference asc
/cfquery

This brings back 2 records, and I want it to only return 1 row. 

select name=custname id=custname
cfloop query=getEmployeeDetails
option value=#reference##reference#/option
/cfloop
/select

The data in the table looks like this

1   cfcoder cf  coder
2   CFCODEr cf  coder

There are two rows in the table with the same reference. How do I get it
to only display 1 record. Can somebody please help

Regards
cfcoder



~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181980
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Select distinct record - help

2004-10-20 Thread James Holmes
Yes, of course the unique ID will need to be removed (and I need to learn to
type). 

-Original Message-
From: Peterson, Andrew S. [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 20 October 2004 8:32 
To: CF-Talk
Subject: RE: Select distinct record - help

Hi CFCoder,

Try taking out the unique ID, if that is the 1 and the 2 in your query
result. Or, maxrows=1? Hope this helps.

 Sincerely,
 
Andrew

~|
Protect your mail server with built in anti-virus protection. It's not only good for 
you, it's good for everybody.
http://www.houseoffusion.com/banners/view.cfm?bannerid=39

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181981
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Running tasks in a console window?

2004-10-20 Thread James Smith
 

 Have you set a timeout for cfexecute, could that be the case? 
 You could also try running something else that takes time, to 
 pinpoint if the problem actually is curl (which I don't 
 think... ?). You can also capture any stdout/stderr message, 
 for instance by piping it through tee or just re-directing it 
 to a file (from the batch-file).

Without a timeout the template continues fine but curl hangs and leaves me
100 or so running processes to end each morning.  With a timeout (of any
value, take your pick) the template exits with a timeout error because curl
has crashed and leaves me 100 or so running processes to end each morning.

Pings and tracerts work just fine with cfexecute (tracerts take longer than
the 3 seconds curl is taking), however if I run curl from a batch file it
works fine from a command prompt but not from cfexecute so I am convinced
the problem is the way CF interacts with curl.

There are no stdout or stderr messages, the process just hangs.

--
Jay


~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181982
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Select distinct record - help

2004-10-20 Thread Pascal Peters
If you want to use that query:

cfoutput query=getEmployeeDetails group=reference
option ...
/cfoutput

But why do you need to loop over the query, as you already know the
reference is 'cfcoder' (it's in your query)

You could also make a query to just get distinct refrences.

Pascal

 -Original Message-
 From: cf coder [mailto:[EMAIL PROTECTED]
 Sent: 20 October 2004 14:30
 To: CF-Talk
 Subject: Select distinct record - help
 
 Hello everybody,
 
 I was wondering if someone could help me. I am trying to get the
distinct
 record from a select statment. Here is the code.
 
 cfquery name=getEmployeeDetails datasource=db
 select distinct reference, uniqueID, firstname, lastname
 FROM employee
 WHERE reference = 'cfcoder'
 ORDER BY reference asc
 /cfquery
 
 This brings back 2 records, and I want it to only return 1 row.
 
 select name=custname id=custname
 cfloop query=getEmployeeDetails
 option value=#reference##reference#/option
 /cfloop
 /select
 
 The data in the table looks like this
 
 1 cfcoder cf  coder
 2 CFCODEr cf  coder
 
 There are two rows in the table with the same reference. How do I get
it
 to only display 1 record. Can somebody please help
 
 Regards
 cfcoder
 
 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181983
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Running tasks in a console window?

2004-10-20 Thread Jochem van Dieten
James Smith wrote:
 I have a problem.  I am using cURL to upload a file with https (cfhttp
 didn't work before someone suggests that).  When I run cURL from the command
 line, it works perfectly in about 3 seconds.  If I run cURL from a batch
 file it runs fine in about 3 seconds.
 
 If I use cfexecute to run either cURL or the batch file then the process
 fails, cURL hangs, it all goes wrong.  I can even use cffile to write the
 batch file and it works from a command line but not from cfexecute.

Can you show the code? Have you tried running the batchfile from 
the command line using runas?


 Is there any way to cause cfm to open a new cmd window and run the batch
 file in that instead of running it as a background process?

I would not recommend it, but if you allow CF to interact with 
the desktop and use the runas command it might be theoretically 
possible.

Jochem

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181984
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Running tasks in a console window?

2004-10-20 Thread James Smith
I have tried...
cfexecute name=c:\path\curl.exe --arguments . someurl/
cfexecute name=c:\path\curl.exe arguments=--arguments
.someurl/

Both with and without timeout variables.  I have even tried...
cfexecute name=c:\windows\system32\cmd.exe arguments=/c c:\path\curl.exe
.../

And all produce the same result.

--
Jay

 -Original Message-
 From: Craig Dudley [mailto:[EMAIL PROTECTED] 
 Sent: 20 October 2004 12:01
 To: CF-Talk
 Subject: RE: Running tasks in a console window?
 
 Might be your cfexecute syntax, have you tried passing in any 
 arguments as an array?
 
 -Original Message-
 From: James Smith [mailto:[EMAIL PROTECTED]
 Sent: 20 October 2004 11:01
 To: CF-Talk
 Subject: Running tasks in a console window?
 
 
 I have a problem.  I am using cURL to upload a file with https (cfhttp
 didn't work before someone suggests that).  When I run cURL from the
 command line, it works perfectly in about 3 seconds.  If I 
 run cURL from
 a batch file it runs fine in about 3 seconds.
 
 If I use cfexecute to run either cURL or the batch file then 
 the process
 fails, cURL hangs, it all goes wrong.  I can even use cffile to write
 the batch file and it works from a command line but not from 
 cfexecute.
 
 It even works fine from schtasks.
 
 Is there any way to cause cfm to open a new cmd window and 
 run the batch
 file in that instead of running it as a background process?
 
 --
 James Smith
 [EMAIL PROTECTED]
 
 
 
 
 

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181985
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Dreamweaver Autocomplete

2004-10-20 Thread Ewok
I appreciate your help, but I don’t know how many more times I could say
that the code hints isn't it. Did I not make myself clear on what I was
asking for? Yes, I know you know what you're talking about when it comes to
the subject but I think you misunderstood the goal I TRIED to make clear.

You obviously felt the need to prove code hints to me since you restated
over and over. I sure can’t find what I wanted in there. Prove it That was
my stupid, cocky way of saying, I think you're wrong. If you're not then I'd
love to see how it's done or a descent explanation.

 Yes. I read all the DW APIs docs, from start to finish; a few times
It was a (poor attempt at a) joke, I'm sure you have : )








-Original Message-
From: Massimo, Tiziana e Federica [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 20, 2004 1:10 AM
To: CF-Talk
Subject: Re: Dreamweaver Autocomplete

 No I haven't read the docs on Code Hints, have you?

Yes. I read all the DW APIs docs, from start to finish; a few times


 Like I said, the
 snippets are doing pretty much exactly what I want

Glad to hear that


 although it's a hot key
 and not an autocomplete of partially typed strings. Code Hints WON'T DO
 WHAT I WANT... prove me wrong

I feel no needs to prove you anything. I just tried to be helpful, but I
clearly failed.

Best


Massimo Foti
DW tools: http://www.massimocorner.com
CF tools:  http://www.olimpo.ch/tmt/


~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181986
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Another Is this Homesite feature in DW? question

2004-10-20 Thread Peterson, Andrew S.
Ewok Wrote:

 The closest thing I can get is the snippets with a hotkey.
 Have you looked at those yet Andrew? 

No I haven't. I will let you know if I do.

Sincerely,
Andrew

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181987
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


reports

2004-10-20 Thread Daniel Kessler
I'm looking to do some on-the-fly reports for our Oracle database 
tables.  To begin, I have two questions.

1 - I can query for a list of tables by doing select * from cat, 
though I picked up this code and don't know what cat stands for.  Is 
there a way to eliminate Sequences from the list of tables it returns 
either during the query or at the time that I make my drop-down in CF?
I also tried SELECT TABLE_NAME FROM ALL_TABLES but that returns 
even more tables though I'm not sure why.

2 - Once I retrieve a list of field names, is there a way to check 
the type of each one?

-- 
Daniel Kessler

Department of Public and Community Health
University of Maryland
Suite 2387 Valley Drive
College Park, MD  20742-2611
301-405-2545 Phone
www.phi.umd.edu

~|
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.houseoffusion.com/banners/view.cfm?bannerid=11

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181988
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: reports

2004-10-20 Thread James Holmes
This will give you just the tables:

select  tabs.table_name
from sys.user_All_tables tabs

and this will give you more than you want to know about a table, if you
replace :TABNAME with the name of your table:

Select cols.column_id, cols.column_name as Name, nullable,
 data_type as Type,
 decode(data_type, 'CHAR', char_length,
   'VARCHAR', char_length,
   'VARCHAR2', char_length,
   'NCHAR', char_length,
   'NVARCHAR', char_length,
   'NVARCHAR2', char_length,
   null) nchar_length,
 Decode( data_type, 'NUMBER', data_precision + data_scale, data_length )
Length,
 data_precision Precision, data_scale Scale, data_length dlength,
data_default  
, ' ' comments 
, DATA_TYPE_MOD 
 FROM 
 sys.user_tab_columns cols
 where 
 cols.table_name = :TABNAME
 order by column_id 

-Original Message-
From: Daniel Kessler [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 20 October 2004 9:03 
To: CF-Talk
Subject: reports

I'm looking to do some on-the-fly reports for our Oracle database tables.
To begin, I have two questions.

1 - I can query for a list of tables by doing select * from cat, though I
picked up this code and don't know what cat stands for.  Is there a way to
eliminate Sequences from the list of tables it returns either during the
query or at the time that I make my drop-down in CF?
I also tried SELECT TABLE_NAME FROM ALL_TABLES but that returns even more
tables though I'm not sure why.

2 - Once I retrieve a list of field names, is there a way to check the type
of each one?

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181989
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Oracle stored procedure returning a cursor

2004-10-20 Thread Tom Kitta
I am running into problems when trying to use Oracle 10g stored procedure that returns 
a cursor. I have done a bit of research on the topic and so far non of the methods 
that where shown work. I am sure many of you use Oracle and CF 6.1 without any 
problems, thus I am sure someone will catch the mistake I have in my code.

Oracle Stored procedure: (I just changed table names and the query a bit – it works 
fine from SQL Plus so there is no problem with the data the stored procedure returns, 
it compiles and runs fine):

CREATE OR REPLACE PACKAGE pkg_userservice
IS TYPE RC_GENERIC IS REF CURSOR;
PROCEDURE p_gettabs ( ag_id_in  INT,
  getTabRefCurIN OUT RC_GENERIC );

END pkg_userservice;
/

CREATE OR REPLACE PACKAGE BODY pkg_userservice
IS

PROCEDURE p_gettabs ( ag_id_in  INT,
  getTabRefCurIN OUT RC_GENERIC )
IS 
BEGIN
OPEN getTabRefCur FOR
  ' SELECT d.agf_id, '
||'g.agf_id p_id, '
||' FROM bbb.acc_grp c '
||' INNER JOIN bbb.acc_grp_func d ON (c.ag_id = :ag_id_in) '
||' ORDER BY d.P_AGF_ID desc
USING ag_id_in;

EXCEPTION
  WHEN others THEN
NULL;
END p_gettabs;  
END pkg_userservice;

Here is my CF code that calls above stored procedure:

cfset ag_id_in = 100
CFSTOREDPROC PROCEDURE=jmelnick.pkg_userservice.p_gettabs DATASOURCE=umap
   cfprocparam type=In cfsqltype=CF_SQL_DECIMAL dbvarname=ag_id_in 
value=#ag_id_in#
  !---  cfprocparam type=Out cfsqltype=cf_sql_refcursor 
variable=searchResults ---
  CFPROCRESULT NAME=getTabRefCur
/CFSTOREDPROC

CFDUMP VAR=#getTabRefCur#

If I run above as it is now I get:
ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 
'P_GETTABS' ORA-06550: line 1, column 7: PL/SQL: Statement ignored

If I include ‘out’ parameter but no result or ‘out’ and result I get this error:
Parameter Type Conflict: sqlType=2006

I am using type definitions from http://www.blinex.com/~sam/CF_SQL_TYPES.cfm
Through I played around and changed them a bit just in case.

I am using :
jdbc:oracle:thin:@(description=(address=(protocol=tcp)(host=dbdev)(port=1521))(connect_data=(sid=dbdev)))
To connect to the db server
Stored procedure execution is enabled on the server and user executing the stored 
procedure has full right to it (grant all).

Any ideas what I am doing wrong? Anyone has a working example for ColdFusion MX 6.1?

Thank you for your help,

TK

~|
Get the mailserver that powers this list at 
http://www.houseoffusion.com/banners/view.cfm?bannerid=17

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181990
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Running tasks in a console window?

2004-10-20 Thread Craig Dudley
So you haven't tried an arguments array then. Try this..

cfscript
args = arraynew(1);
args[1] = file;
args[2] = url;
args[3] = etc;
/cfscript

cfexecute name=c:\path\curl.exe arguments=#args#
timeout=30/cfexecute

Might not make a difference, but its worth a try.


-Original Message-
From: James Smith [mailto:[EMAIL PROTECTED] 
Sent: 20 October 2004 13:42
To: CF-Talk
Subject: RE: Running tasks in a console window?


I have tried...
cfexecute name=c:\path\curl.exe --arguments . someurl/
cfexecute name=c:\path\curl.exe arguments=--arguments
.someurl/

Both with and without timeout variables.  I have even tried...
cfexecute name=c:\windows\system32\cmd.exe arguments=/c
c:\path\curl.exe .../

And all produce the same result.

--
Jay

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181991
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Select distinct record - help

2004-10-20 Thread cf coder
Pascal, I was just trying to illustrate to you if it makes sense

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181992
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CF developer numbers

2004-10-20 Thread Rey Bango
The biggest gripe that I hear about ColdFusion from *sssooo* many people is
product cost. At $1,299 for standard and $5,999 for the enterprise, its a
steep barrier to entry compared to PHP and ASP/ASP.Net (as free
alternatives). And yes, I've read all of the posts and counterpoints to the
*free* software vs.ColdFusion debate (including Ben Forta's analysis) so
it's not even worth mentioning. Perception is what's hurting ColdFusion, not
functionality.

I went through this same process when I developed in PowerBuilder. It came
out and revolutionized the way Windows-based client/server apps were built.
It had a strong run of about 5 years until MS brought Visual Basic up to par
and offerred VB at cut rate prices, essentially cutting off PowerBuilder at
the knees. I'm seeing many similarities with this and the ColdFusion product
line.

I think BlueDragon is a good alternative and luckily, their standard version
is free but I'm wondering if it may be too little, too late.

Rey.


~|
The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in 
the Washington DC Area. 
http://www.houseoffusion.com/banners/view.cfm?bannerid=44

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181993
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


CF-DWMX 2004 Design

2004-10-20 Thread coldfusion . developer
All,

I have one question.  Any direction would be great.

1) Once I use layers to create the structure of a page, I would like to export the
details of the layer to a css file and reference an ID in the page.  However when
I try to export the layer information, it doesn't write to the css file like other css 
data.
Do I have to manually copy and paste this layer data into a css file?  Is there a 
better way?


D

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181994
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: 6.1 updater breaks cfdumping cfcatch, but this may help

2004-10-20 Thread Dan O'Keefe
Sean,

Any ETA on this hot fix?

Dan


  I spoke to the CF product team and this is what they said (my
 paraphrasing):
  
  A fix is currently in the works and will be posted as a hotfix in the
  near future on the ColdFusion Support site.
  
  The updater included a fix for duplicate() to make deep copies of
  objects. However, exceptions are problematic because they can be
  self-referencing so duplicate() only makes shallow copies of Throwable
  objects (native Java exceptions). Unfortunately, cfdump relies on
  duplicate() to convert Throwable objects into CF exception objects
  which means that it now fails to report certain types of exceptions
  correctly.
  -- 
  Sean A Corfield -- http://www.corfield.org/blog/


Dan O'Keefe

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181995
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CSS and Debugging

2004-10-20 Thread Simeon Bateman
I have found a quick fix for this is to add a div to the bottom of
your site, while debugging.

Give this div a style with clear:both;.  It will force anything above
it in code to be above and anything below to be below. This could be
on your normal footer which I do sometimes, but if you layout doesnt
allow for that then a temporary div can do the trick.

Hope that helps.

simeon


On Wed, 20 Oct 2004 00:57:57 -0400, Umer Farooq [EMAIL PROTECTED] wrote:
 It depends on what kind of data you need to present. If you need to do
 lot of columns then stick with tables .. as column layout is in CSS3 and
 heck even doing a three column layout in the current browsers CSS2.0- is
 a pain.. not all browser support CSS2 fully..
 
 Good place to look for nice css sites.. and comments on how they over
 came challenges..
 
 www.cssvault.com
 www.stylegala.com
 www.weeklystandards.com  (note to take full advantage of css.. you need
 to learn the css hacks.. this site will list out all the hacks
 implemented for each site..  )
 
 nice resources..
 
 www.mezblue.com
 www.htmldog.com (very nice quick reference for XHTML and CSS )
 
 
 Mike Kear wrote:
  Andy it's a whole 'nother discipline in web development.  Happily it
  is something you can ease into, and dont have to learn all at once.
  And every step you take learning how CSS can work, will make your life
  coding pages in ColdFusion easier.
 
  The best thing I can suggest is togo look at the web standards
  group site, and perhaps join their mailing list.  Very knowledgeable
  and friendly folks.  The list isnt quite as high volume as CF-TALK so
  it's not too much traffic to handle.   The site has lots of helpful
  stuff, including beginners stuff.   Plenty of how-tos on almost
  everything you'd want to do, or if not directly there, there are links
  to somewhere else that does show you how to do what you're wanting to
  do.
 
  It's at www.webstandardsgroup.org.   Tell 'em Mike Kear said to come by.
 
 
  Cheers
  Mike Kear
  Windsor, NSW, Australia
  AFP Webworks
  http://afpwebworks.com
  .com,.net,.org domains from AUD$20/Year
 
 
  On Tue, 19 Oct 2004 17:46:46 -0500, Andy Ousterhout
  [EMAIL PROTECTED] wrote:
 
 Shannon:
 I'd like to start using CSS for tables, but don't know how.  Can you provide
 a sample table?
 
 Andy
 
 
 
 
 
 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181996
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Oracle stored procedure returning a cursor

2004-10-20 Thread Janet Schmitt
TK -

I think this is a problem with the jdbc thinclient driver.Look at live 
docs on Macromedia's site 
(http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-b17.htm).



IAt 09:27 AM 10/20/2004 -0400, you wrote:
I am running into problems when trying to use Oracle 10g stored procedure 
that returns a cursor. I have done a bit of research on the topic and so 
far non of the methods that where shown work. I am sure many of you use 
Oracle and CF 6.1 without any problems, thus I am sure someone will catch 
the mistake I have in my code.

Oracle Stored procedure: (I just changed table names and the query a bit ­ 
it works fine from SQL Plus so there is no problem with the data the 
stored procedure returns, it compiles and runs fine):

CREATE OR REPLACE PACKAGE pkg_userservice
IS TYPE RC_GENERIC IS REF CURSOR;
PROCEDURE p_gettabs ( ag_id_in  INT,
   getTabRefCurIN OUT RC_GENERIC );

END pkg_userservice;
/

CREATE OR REPLACE PACKAGE BODY pkg_userservice
IS

PROCEDURE p_gettabs ( ag_id_in  INT,
   getTabRefCurIN OUT RC_GENERIC )
IS
BEGIN
OPEN getTabRefCur FOR
   ' SELECT d.agf_id, '
||'g.agf_id p_id, '
||' FROM bbb.acc_grp c '
||' INNER JOIN bbb.acc_grp_func d ON (c.ag_id = :ag_id_in) '
||' ORDER BY d.P_AGF_ID desc
USING ag_id_in;

EXCEPTION
   WHEN others THEN
 NULL;
END p_gettabs;
END pkg_userservice;

Here is my CF code that calls above stored procedure:

cfset ag_id_in = 100
CFSTOREDPROC PROCEDURE=jmelnick.pkg_userservice.p_gettabs 
DATASOURCE=umap
cfprocparam type=In cfsqltype=CF_SQL_DECIMAL dbvarname=ag_id_in 
 value=#ag_id_in#
   !---  cfprocparam type=Out cfsqltype=cf_sql_refcursor 
 variable=searchResults ---
   CFPROCRESULT NAME=getTabRefCur
/CFSTOREDPROC

CFDUMP VAR=#getTabRefCur#

If I run above as it is now I get:
ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments 
in call to 'P_GETTABS' ORA-06550: line 1, column 7: PL/SQL: Statement ignored

If I include ‘out’ parameter but no result or ‘out’ and result I get this 
error:
Parameter Type Conflict: sqlType=2006

I am using type definitions from http://www.blinex.com/~sam/CF_SQL_TYPES.cfm
Through I played around and changed them a bit just in case.

I am using :
jdbc:oracle:thin:@(description=(address=(protocol=tcp)(host=dbdev)(port=1521))(connect_data=(sid=dbdev)))
To connect to the db server
Stored procedure execution is enabled on the server and user executing the 
stored procedure has full right to it (grant all).


~|
The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in 
the Washington DC Area. 
http://www.houseoffusion.com/banners/view.cfm?bannerid=44

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181997
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: reports

2004-10-20 Thread Gruss Gott
I do exactly this except with Sybase - it works great.


On Wed, 20 Oct 2004 21:19:46 +0800, James Holmes
[EMAIL PROTECTED] wrote:
 This will give you just the tables:
 
 select  tabs.table_name
 from sys.user_All_tables tabs
 
 and this will give you more than you want to know about a table, if you
 replace :TABNAME with the name of your table:
 
 Select cols.column_id, cols.column_name as Name, nullable,
  data_type as Type,
  decode(data_type, 'CHAR', char_length,
'VARCHAR', char_length,
'VARCHAR2', char_length,
'NCHAR', char_length,
'NVARCHAR', char_length,
'NVARCHAR2', char_length,
null) nchar_length,
  Decode( data_type, 'NUMBER', data_precision + data_scale, data_length )
 Length,
  data_precision Precision, data_scale Scale, data_length dlength,
 data_default
 , ' ' comments
 , DATA_TYPE_MOD
  FROM
  sys.user_tab_columns cols
  where
  cols.table_name = :TABNAME
  order by column_id
 
 -Original Message-
 From: Daniel Kessler [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, 20 October 2004 9:03
 To: CF-Talk
 Subject: reports
 
 I'm looking to do some on-the-fly reports for our Oracle database tables.
 To begin, I have two questions.
 
 1 - I can query for a list of tables by doing select * from cat, though I
 picked up this code and don't know what cat stands for.  Is there a way to
 eliminate Sequences from the list of tables it returns either during the
 query or at the time that I make my drop-down in CF?
 I also tried SELECT TABLE_NAME FROM ALL_TABLES but that returns even more
 tables though I'm not sure why.
 
 2 - Once I retrieve a list of field names, is there a way to check the type
 of each one?
 
 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181998
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CF developer numbers

2004-10-20 Thread Dick Applebaum
On Oct 19, 2004, at 6:47 PM, James Holmes wrote:

 Yes, I see CF as being targeted at the end user rather than 
 contract-based
 developers.

I agree.  This is happening -- but i don't think it has been targeted 
-- just the process of natural selection -- a case of the users 
defining the market rather than (or maybe in spite of) the 
manufacturers.

 CF gets installed into a lot of Gov and Edu sites and they often
 form their own teams to develop and maintain the apps (like in our 
 case,
 where many of the full-time CF developers are in permanent positions 
 and the
 more casual users are still able to do some of the work). The industry 
 sees
 CF as a niche product (ref: Gartner Research) and I think this is 
 probably
 that niche.

If CF is relegated to a niche product, then the IT  web development 
professionals are doing themselves a tremendous disservice.

The fact that that CF is easy to learn for a lay person (or incidental 
developer) does not detract from its power, or applicability to more 
sophisticated applications.

I think that the end user interest in CF will benefit the 
professional developer, in the long term.

Dick


 -Original Message-
 From: Dick Applebaum [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, 20 October 2004 9:27
 To: CF-Talk
 Subject: Re: CF developer numbers

 Yes,  Times, they are a'changing.

 When I first discovered CF (circa 1998) I could earn  $10,000 for a 
 typical
 1-month project (the same project for the same $ took 3 months in 
 Perl)/

 There was lots of business around and I was able to get all the jobs I
 wanted.

 But, one of the problems with a system like CF is that it makes 
 developing
 web sites so much easier and so, appeals to many developers of all 
 levels of
 expertise.

 Of course this increases competition.

 I don't have a solution, but I think the life of a contract CF 
 programmer
 has moved on ...

 ...to survive, we must adapt!


~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181999
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CF-DWMX 2004 Design

2004-10-20 Thread Massimo Foti
 1) Once I use layers to create the structure of a page, I would like to
export the
 details of the layer to a css file and reference an ID in the page.
However when
 I try to export the layer information, it doesn't write to the css file
like other css data.
 Do I have to manually copy and paste this layer data into a css file?  Is
there a better way?

It has been a while since the last time I used this extension, so I am not
even sure if it works on DW 2004. But I guess it's worth a try:

http://www.yaromat.com/dw/?t=Commandr=layersGo=Go


Massimo Foti
DW tools: http://www.massimocorner.com
CF tools:  http://www.olimpo.ch/tmt/




~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182000
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


More IIS/J2EE configuration installation issues

2004-10-20 Thread Chris Peters
For those of you who have installed ColdFusion 6.1 J2EE instances and hooked them to 
IIS:

When we store our files in the IIS web site's root, they work fine.  But when we try 
to store the files in the {jrun root}\servers\cfusion\cfusion-ear\cfusion-war folder, 
the server returns a 404.

It would seem to me that it would make more sense to store the files in the ear-war.  
(Why have EAR server instances if you can't store everything under the EAR?)  Where do 
you guys store your web site files when using this configuration?  If it is under the 
JRun server root instead of the IIS root, do you have any tips on how to get this to 
work?

~|
The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in 
the Washington DC Area. 
http://www.houseoffusion.com/banners/view.cfm?bannerid=44

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182001
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Web Service error

2004-10-20 Thread Chris Gottshall
Hello all,
 
I have an ASP.NET web service that I am trying to invoke from a CF page.  The method 
appears in the components section of DW if I add the web service, and I can test it ok 
using aspx, but I keep getting the error 
Web service operation registerParticipant with parameters 
{eventId={test},lastName={doo},status={paid},registration={registered},firstName={scooby},}
 could not be found.  when I try to consume it via ColdFusion.
The method is:
registerParticipant(eventId, firstName, lastName, status, registration) with all 
String type arguments, and that's all I'm passing it
 
Anyone have any leads as to what to examine?  All the other WebMethod's in this asmx 
file are invocable without problem.  Any thoughts are appreciated!
 
-Chris

~|
Get the mailserver that powers this list at 
http://www.houseoffusion.com/banners/view.cfm?bannerid=17

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182002
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


/WEB-INF/cfclasses location

2004-10-20 Thread Nathan Mische
Before applying the 6.1 updater my CF classes were all stored in the
Jrun directory (ie.
C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\cfclasses).
After applying the updater my classes are now being placed under the IIS
webroot (ie. C:\Inetpub\wwwroot\WEB-INF\cfclasses). Is there anyway to
have my classes saved in the Jrun directory like they were before I
applied the updater? 

I see there is coldfusion.compiler.outputDir context parameter in both
the j2ee-web.xml and web.xml files. The description states This is the
directory where we will place compiled pages. It must be relative to the
webapp root. and the value is currently /WEB-INF/cfclasses, but I'm
not sure what the value should be to have the classes compiled to the
Jrun directory.

Any help would be greatly appreciated.

Thanks,

--Nathan

 

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182003
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Dreamweaver Autocomplete

2004-10-20 Thread Spike
Hi Dave,

What parts of the setup are you finding cumbersome?

Anything we can do to make it better for new users is of interest. We 
tend to find that although people have an initial inertia in moving from 
DW, Homesite, Textpad or whatever, by the time they get round to telling 
us what they would like to see they've already got over that and are 
asking for features in the IDE.

Spike

dave wrote:
 i did dl eclipse again to take another look but its kinda a pain in the ass too set 
 up and was hoping to use it as a quick fix to dive into code without opening dw. :( 
 looks a lot better than before though
 
 as for dw just cause it doesnt act just like cf studio doesnt mean its bad, might 
 just be different as u'd expect since it has to handle far more then cf studio did. 
 Its always a bit frusterating when using something else, see above with cfeclipse 
 and me tonight. But once u realize the power then u dont look back. I think snippets 
 are friggin great, plus their portability is wonderful, its the one thing i can 
 count on not having to reinstall (except to copy  paste) when reinstalling the 
 piece o shit OS (aka winxp).
 Now when i go back to hs+, it looks like just what it is, OLD...
 
 
 -- Original Message --
 From: Spike [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 Date:  Tue, 19 Oct 2004 22:58:57 -0700
 
 
Dreamweaver is indeed a nice product, but I tend to be biased towards 
cfeclipse. It's got most of the features I need because I put them there ;)

I have used CFStudio, Homesite 5.5 , Homesite+ and DreamWeaver 
extensively. None of them had some of the features I thought were 
important for development with CFMX, so I started working on the 
cfeclipse project. We are slowly creeping towards the point where it's a 
hands down winner over DW and Homesite in some areas, but there's still 
a lot of work to be done.

As with any editor, individual experiences may differ and as I said, I'm 
biased :)

Spike

Mike Kear wrote:

And with DreamweaverMX too.  For example, I like to use CTRL-ALT-C to
wrap selected text in a CF Comment.   So I have a snippet that is set
to put ![   before the selected text, and ] after it,  then
assigned that snippet to the keyboard shortcut CTRL-ALT-C.   Now, I
select text,  hit the keyboard shortcut and i have a coldfusion
comment that I think is neater than the  standard one because it has
the neat little square brackets around the commented text.

I started out as a very less-than-gruntled studio fan and forced
myself to learn about Dreamweaver.  Never mind why, I just did ok?   
And I've become a fan of DWMX.  I have since worked at shops that use
Studio or Homesite and I can honestly say that while Studio is a good
product, and I can happily work with it, I know both DWMX and Studio
very well, and prefer DWMX.   It's easy to say, this feature doesnt
work exactly as it does in Studio therefore its no good, but get used
to it and I reckon you'll be a fan of the product too.   Nearly
everything you wanted to do in Studio can be done in DWMX, and
sometimes in a slightly different way. But it has scores of additional
features that arent in the other tools.

Cheers
Mike Kear
Windsor, NSW, Australia
AFP Webworks
http://afpwebworks.com
.com,.net,.org domains from AUD$20/Year



On Tue, 19 Oct 2004 11:03:11 -0700, Spike [EMAIL PROTECTED] wrote:


This may or may not be of interest to you, but you can do this in cfeclipse.

You can specify a unique set of trigger characters for each snippet. If
you type those characters followed by ctrl+i (or whatever custom
shortcut you change that to) it will insert the full snippet with your
cursor at the position between the start and end blocks of the snippet.

You can do a lot more than that if you also use snippet variables, but
that's probably getting a bit off topic.

Of course, if you don't want to, or can't use cfelcipse then that's a
moot point, but I thought was worth mentioning.

Spike




 
 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182004
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Russel is Back on the Air

2004-10-20 Thread Russel Madere
After a 2 ½ year hiatus I am back in the Cold Fusion fold and will soon be causing 
ulcers in the CF Community list.  :)

 

BTW, I will be at Macromedia MAX, in my home town.  Anyone who is going, feel free to 
email me for tourist information.

 

Russel Madere

Webmaster/Internet Coordinator

504.832.9835 x3509

SunShine Pages by EATEL

www.sunshinepages.com

 

 



~|
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.houseoffusion.com/banners/view.cfm?bannerid=11

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182005
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: [cf-talk] Digest Number 935

2004-10-20 Thread Karl
This should work for you too:

cfquery name=getEmployeeDetails datasource=db
select TOP 1 reference, uniqueID, firstname, lastname
FROM employee
WHERE reference = 'cfcoder'
ORDER BY reference asc
/cfquery


At 05:46 AM 10/20/04, cf coder wrote:
cfquery name=getEmployeeDetails datasource=db select distinct
reference, uniqueID, firstname, lastname FROM employee WHERE reference =
'cfcoder'
ORDER BY reference asc
/cfquery


~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182006
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Oracle stored procedure returning a cursor

2004-10-20 Thread James Holmes
You need to use the CFMX Enterprise driver and the CF_SQL_REFCURSOR type is
deprecated in MX. 

-Original Message-
From: Janet Schmitt [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 20 October 2004 10:23 
To: CF-Talk
Subject: Re: Oracle stored procedure returning a cursor

TK -

I think this is a problem with the jdbc thinclient driver.Look at live 
docs on Macromedia's site
(http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-b17.htm).



~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182007
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Oracle stored procedure returning a cursor

2004-10-20 Thread Tom Kitta
Yes, switching to native Oracle driver fixed the problem, looks like the Java driver 
doesn't support cursors yet. The original reason for us using Java JDBC driver instead 
of the native driver was due to native driver having problems with shared mode of the 
Oracle server (it was dropping connections often or something like that). The last 
time native driver was tested was about 1-1.5 years ago, I think with CF 6.0. Does 
anyone know whatever native Oracle driver for CF 6.1 was improved? Does it work fine 
with the shared mode of the Oracle server? This would save me a lot of testing. Thanks 
for your help Janet,

TK


I think this is a problem with the jdbc thinclient driver.Look at live 
docs on Macromedia's site 
(http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-b17.htm).



IAt 09:27 AM 10/20/2004 -0400, you wrote:

~|
Get the mailserver that powers this list at 
http://www.houseoffusion.com/banners/view.cfm?bannerid=17

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182008
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


SQL Deadlock

2004-10-20 Thread Ryan Duckworth
Does anyone have any ideas on how to prevent/handle database deadlock?

Error Executing Database Query. [Macromedia][SQLServer JDBC
Driver][SQLServer]Transaction (Process ID 132) was deadlocked on lock
resources with another process and has been chosen as the deadlock
victim. Rerun the transaction.

We get a message similar to the one above about once a week.

My guess is that the deadlock occurred b/c the same row was attempting
to be read and written to at the same time.


Ryan Duckworth 
Macromedia ColdFusion Certified Professional
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211
(913) 754-4272


~|
Get the mailserver that powers this list at 
http://www.houseoffusion.com/banners/view.cfm?bannerid=17

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182009
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Oracle stored procedure returning a cursor

2004-10-20 Thread Scott Mulholland
Make sure your driver is DataDirect 3.3...I was using 3.1 and it would
not work, upgraded them and everything was fine.

-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 20, 2004 10:58 AM
To: CF-Talk
Subject: RE: Oracle stored procedure returning a cursor


You need to use the CFMX Enterprise driver and the CF_SQL_REFCURSOR type
is deprecated in MX. 

-Original Message-
From: Janet Schmitt [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 20 October 2004 10:23 
To: CF-Talk
Subject: Re: Oracle stored procedure returning a cursor

TK -

I think this is a problem with the jdbc thinclient driver.Look at
live 
docs on Macromedia's site
(http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-b17.htm).





~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182010
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Oracle stored procedure returning a cursor

2004-10-20 Thread James Holmes
We use shared mode and we had to turn off the maintain connections setting
(i.e. JDBC pooling) in the CF datasource as we were getting non-sql errors
for no good reason. With shared mode the connection setup is quite fast so
it doesn't impact us much at all.

-Original Message-
From: Tom Kitta [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 21 October 2004 12:00 
To: CF-Talk
Subject: Re: Oracle stored procedure returning a cursor

Yes, switching to native Oracle driver fixed the problem, looks like the
Java driver doesn't support cursors yet. The original reason for us using
Java JDBC driver instead of the native driver was due to native driver
having problems with shared mode of the Oracle server (it was dropping
connections often or something like that). The last time native driver was
tested was about 1-1.5 years ago, I think with CF 6.0. Does anyone know
whatever native Oracle driver for CF 6.1 was improved? Does it work fine
with the shared mode of the Oracle server? This would save me a lot of
testing. Thanks for your help Janet,

TK

~|
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.houseoffusion.com/banners/view.cfm?bannerid=11

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182011
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: SQL Deadlock

2004-10-20 Thread Lawrence Ng
how are u writing the queries? via stored procedures? or cfquery? I'm
assuming you're already cflock correct?

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182012
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: SQL Deadlock

2004-10-20 Thread Robertson-Ravo, Neil (RX)
Use transactions and better the DB design (which is easier said than done!).

Have you tied it down to one particular SQL Block?  Maybe a report or an SP
running a cursor?

N



-Original Message-
From: Ryan Duckworth [mailto:[EMAIL PROTECTED] 
Sent: 20 October 2004 17:02
To: CF-Talk
Subject: SQL Deadlock

Does anyone have any ideas on how to prevent/handle database deadlock?

Error Executing Database Query. [Macromedia][SQLServer JDBC
Driver][SQLServer]Transaction (Process ID 132) was deadlocked on lock
resources with another process and has been chosen as the deadlock
victim. Rerun the transaction.

We get a message similar to the one above about once a week.

My guess is that the deadlock occurred b/c the same row was attempting
to be read and written to at the same time.


Ryan Duckworth 
Macromedia ColdFusion Certified Professional
Uhlig Communications 
10983 Granada Lane 
Overland Park, KS 66211
(913) 754-4272




~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182013
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


OT: CSS Class vs ID?

2004-10-20 Thread Damien McKenna
Which is the more correct method for calling CSS styles, to use the id 
attribute or the class attribute?  Can IDs be nested, e.g. #box #inside 
#field {...}, like classes can be, e.g. table.box th.inside td.field {...}.
-- 
*Damien McKenna* - Web Developer - [EMAIL PROTECTED] 
mailto:[EMAIL PROTECTED]
The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
Nothing endures but change. - Heraclitus

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182014
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: CF developer numbers

2004-10-20 Thread James Holmes
I agree completely, but there's no telling this to the Java snobs who insist
that we must use Java exclusively, because they do and CF is just for
beginners.

All of this leads to Gartner recommending that we all migrate from CF to
Java or ASP (because CF is a niche product) and the managers of the
businesses that hire contractors read Gartner's research.

-Original Message-
From: Dick Applebaum [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 20 October 2004 10:36 
To: CF-Talk
Subject: Re: CF developer numbers

On Oct 19, 2004, at 6:47 PM, James Holmes wrote:

[snip]

If CF is relegated to a niche product, then the IT  web development
professionals are doing themselves a tremendous disservice.

The fact that that CF is easy to learn for a lay person (or incidental
developer) does not detract from its power, or applicability to more
sophisticated applications.

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182015
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: css ?

2004-10-20 Thread Dave Francis
 body style=background-image:none; background-color:white


 -Original Message-
From: dave [mailto:[EMAIL PROTECTED]
Sent: Monday, October 11, 2004 6:26 PM
To: CF-Talk
Subject: ot: css ?


  is there a way to override a body tag?

  what the problem is that i have 1 page that i want a white bg on but in my
css i have an image bg in my body tag and i need the css file in there and
dont really want to add another for validation purposes.

  so again, is there a way to be able to over ride the css files settings?
  thank ya


~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182016
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Dreamweaver Autocomplete

2004-10-20 Thread Mark Drew
I would think the initial inertia is getting the large download of
Eclipse (since most web devs here wont be doing java)

Then the cfeclipse plugin (knowing how to rather that the actual
download) are the easier bits.

After that its a walk in the park... 
maybe  we need a little 
 I little guidebook? or one of those bat files that says 
you wanna get eclipse? good... get it
then when you have got it ant installed it (errr.. unzip)
it prompts eclipse to get the plugin?

I dont know but it is pretty painless all the same... and there are
not many but definately good sources of information from:

the project homepage: http://cfeclipse.tigris.org/
Nathans Cfeclipse resource page: http://www.dopefly.com/pages/cfeclipse.cfm
The CFeclipse Wiki : http://www.spike.org.uk/cfeclipse/space/start

And some asorted blatherings I spew onto my blog

Quality not quantity I say.

-- 
Mark Drew

coldfusion and cfeclipse blogged:
http://cybersonic.blogspot.com/
39° 31' 58 , 0° 25' 53
39.533 , -0.4316


On Wed, 20 Oct 2004 08:43:38 -0700, Spike [EMAIL PROTECTED] wrote:
 Hi Dave,
 
 What parts of the setup are you finding cumbersome?
 
 Anything we can do to make it better for new users is of interest. We
 tend to find that although people have an initial inertia in moving from
 DW, Homesite, Textpad or whatever, by the time they get round to telling
 us what they would like to see they've already got over that and are
 asking for features in the IDE.
 
 Spike
 
 
 
 dave wrote:
  i did dl eclipse again to take another look but its kinda a pain in the ass too 
  set up and was hoping to use it as a quick fix to dive into code without opening 
  dw. :( looks a lot better than before though
 
  as for dw just cause it doesnt act just like cf studio doesnt mean its bad, might 
  just be different as u'd expect since it has to handle far more then cf studio 
  did. Its always a bit frusterating when using something else, see above with 
  cfeclipse and me tonight. But once u realize the power then u dont look back. I 
  think snippets are friggin great, plus their portability is wonderful, its the one 
  thing i can count on not having to reinstall (except to copy  paste) when 
  reinstalling the piece o shit OS (aka winxp).
  Now when i go back to hs+, it looks like just what it is, OLD...
 
 
  -- Original Message --
  From: Spike [EMAIL PROTECTED]
  Reply-To: [EMAIL PROTECTED]
  Date:  Tue, 19 Oct 2004 22:58:57 -0700
 
 
 Dreamweaver is indeed a nice product, but I tend to be biased towards
 cfeclipse. It's got most of the features I need because I put them there ;)
 
 I have used CFStudio, Homesite 5.5 , Homesite+ and DreamWeaver
 extensively. None of them had some of the features I thought were
 important for development with CFMX, so I started working on the
 cfeclipse project. We are slowly creeping towards the point where it's a
 hands down winner over DW and Homesite in some areas, but there's still
 a lot of work to be done.
 
 As with any editor, individual experiences may differ and as I said, I'm
 biased :)
 
 Spike
 
 Mike Kear wrote:
 
 And with DreamweaverMX too.  For example, I like to use CTRL-ALT-C to
 wrap selected text in a CF Comment.   So I have a snippet that is set
 to put ![   before the selected text, and ] after it,  then
 assigned that snippet to the keyboard shortcut CTRL-ALT-C.   Now, I
 select text,  hit the keyboard shortcut and i have a coldfusion
 comment that I think is neater than the  standard one because it has
 the neat little square brackets around the commented text.
 
 I started out as a very less-than-gruntled studio fan and forced
 myself to learn about Dreamweaver.  Never mind why, I just did ok?
 And I've become a fan of DWMX.  I have since worked at shops that use
 Studio or Homesite and I can honestly say that while Studio is a good
 product, and I can happily work with it, I know both DWMX and Studio
 very well, and prefer DWMX.   It's easy to say, this feature doesnt
 work exactly as it does in Studio therefore its no good, but get used
 to it and I reckon you'll be a fan of the product too.   Nearly
 everything you wanted to do in Studio can be done in DWMX, and
 sometimes in a slightly different way. But it has scores of additional
 features that arent in the other tools.
 
 Cheers
 Mike Kear
 Windsor, NSW, Australia
 AFP Webworks
 http://afpwebworks.com
 .com,.net,.org domains from AUD$20/Year
 
 
 
 On Tue, 19 Oct 2004 11:03:11 -0700, Spike [EMAIL PROTECTED] wrote:
 
 
 This may or may not be of interest to you, but you can do this in cfeclipse.
 
 You can specify a unique set of trigger characters for each snippet. If
 you type those characters followed by ctrl+i (or whatever custom
 shortcut you change that to) it will insert the full snippet with your
 cursor at the position between the start and end blocks of the snippet.
 
 You can do a lot more than that if you also use snippet variables, but
 that's probably getting a 

Re: OT: CSS Class vs ID?

2004-10-20 Thread Andy Allan
The ID attribute is unique. It should apply to one and only one div.

Use the class attribute for general styles.

Andy


On Wed, 20 Oct 2004 12:06:20 -0400, Damien McKenna
[EMAIL PROTECTED] wrote:
 Which is the more correct method for calling CSS styles, to use the id
 attribute or the class attribute?  Can IDs be nested, e.g. #box #inside
 #field {...}, like classes can be, e.g. table.box th.inside td.field {...}.
 --
 *Damien McKenna* - Web Developer - [EMAIL PROTECTED]
 mailto:[EMAIL PROTECTED]
 The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
 Nothing endures but change. - Heraclitus
 
 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182018
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: OT: CSS Class vs ID?

2004-10-20 Thread Barney Boisvert
Yes, you can nest IDs.  There isn't a right one for referencing a
certain element.  If the element is unique in a document, use ID, but
if it's one of many, use class.  Classes are more general, so I tend
to use those when I can, reserving ids mostly for page layout tasks
(rather than formatting and such), but that's nothing more than a
really loose guideline I use.

cheers,
barneyb

On Wed, 20 Oct 2004 12:06:20 -0400, Damien McKenna
[EMAIL PROTECTED] wrote:
 Which is the more correct method for calling CSS styles, to use the id
 attribute or the class attribute?  Can IDs be nested, e.g. #box #inside
 #field {...}, like classes can be, e.g. table.box th.inside td.field {...}.
 --
 *Damien McKenna* - Web Developer - [EMAIL PROTECTED]
 mailto:[EMAIL PROTECTED]
 The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
 Nothing endures but change. - Heraclitus
 
-- 
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/blog/

I currently have 2 GMail invites for the taking

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182019
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Is form.evaluation_required some sort of reserved name?

2004-10-20 Thread Cassidy Symons
I'm have a really weird problem here...I've got a form, and one of the 
fields is called 'evaluation_required' - it's a Yes/No field with values 
of 1/0. The column in the database has the same name, and is a BIT field 
(technically TINYINT(1) since MySQL has no real BIT, but...).

When I submit the form including that field, I receive this error message:


Form Entries Incomplete or Invalid
One or more problems exist with the data you have entered.

 * 0

Use the Back button on your web browser to return to the previous page 
and correct the listed problems.



Obviously the 0 can either be 0 or 1, and I checked, it bombs on both 
values (and any other value for that matter). It also bombs regardless 
of what type of form field I use (select, text, radio, hidden, etc.), 
but when I change the field name to evaluation_required2, it goes 
through just fine.

I did a quick search on Google for 'form.evaluation_required' and 
'evaluation_required' and turned up nothing related to ColdFusion. Has 
anyone ever run into this before? I've never known 
form.evaluation_required to be an illegal field name...is it?

Thanks.

Cassidy

-- 
Really, I'm not out to destroy Microsoft. That will just be a 
completely unintentional side effect. - Linus Torvalds

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182020
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Is form.evaluation_required some sort of reserved name?

2004-10-20 Thread Tangorre, Michael
ColdFusion server side processing is kicking in due to the  _required
on the field name.
Rename your field to something else would be the easiest solution...
Until MM ensures that only hidden form fields are considered for server
side form validation.

Michael T. Tangorre  

 -Original Message-
 From: Cassidy Symons [mailto:[EMAIL PROTECTED] 
 Sent: Wednesday, October 20, 2004 12:41 PM
 To: CF-Talk
 Subject: Is form.evaluation_required some sort of reserved name?
 
 I'm have a really weird problem here...I've got a form, and 
 one of the fields is called 'evaluation_required' - it's a 
 Yes/No field with values of 1/0. The column in the database 
 has the same name, and is a BIT field (technically TINYINT(1) 
 since MySQL has no real BIT, but...).
 
 When I submit the form including that field, I receive this 
 error message:
 
 
 Form Entries Incomplete or Invalid
 One or more problems exist with the data you have entered.
 
  * 0
 
 Use the Back button on your web browser to return to the 
 previous page and correct the listed problems.
 
 
 
 Obviously the 0 can either be 0 or 1, and I checked, it bombs on both 
 values (and any other value for that matter). It also bombs 
 regardless 
 of what type of form field I use (select, text, radio, hidden, etc.), 
 but when I change the field name to evaluation_required2, it goes 
 through just fine.
 
 I did a quick search on Google for 'form.evaluation_required' and 
 'evaluation_required' and turned up nothing related to 
 ColdFusion. Has 
 anyone ever run into this before? I've never known 
 form.evaluation_required to be an illegal field name...is it?
 
 Thanks.
 
 Cassidy
 
 -- 
 Really, I'm not out to destroy Microsoft. That will just be a 
 completely unintentional side effect. - Linus Torvalds
 
 

~|
Get the mailserver that powers this list at 
http://www.houseoffusion.com/banners/view.cfm?bannerid=17

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182021
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Is form.evaluation_required some sort of reserved name?

2004-10-20 Thread Barney Boisvert
Yes, anything that ends with _required is processed as a server-side
validation instruction by CF when the form is submitted, regarding the
field named the same as the part before that string.  So in your case,
CF is doing validation to ensure that the evaluation form field is
present.

Unfortunately, there's no way to turn off that behaviour.  To avoid
it, I usually camelCase my variable names; no underscores means no
hijacking.

cheers,
barneyb

On Wed, 20 Oct 2004 09:40:47 -0700, Cassidy Symons [EMAIL PROTECTED] wrote:
 I'm have a really weird problem here...I've got a form, and one of the
 fields is called 'evaluation_required' - it's a Yes/No field with values
 of 1/0. The column in the database has the same name, and is a BIT field
 (technically TINYINT(1) since MySQL has no real BIT, but...).
 
 When I submit the form including that field, I receive this error message:
 
 Form Entries Incomplete or Invalid
 One or more problems exist with the data you have entered.
 
 * 0
 
 Use the Back button on your web browser to return to the previous page
 and correct the listed problems.
 
 Obviously the 0 can either be 0 or 1, and I checked, it bombs on both
 values (and any other value for that matter). It also bombs regardless
 of what type of form field I use (select, text, radio, hidden, etc.),
 but when I change the field name to evaluation_required2, it goes
 through just fine.
 
 I did a quick search on Google for 'form.evaluation_required' and
 'evaluation_required' and turned up nothing related to ColdFusion. Has
 anyone ever run into this before? I've never known
 form.evaluation_required to be an illegal field name...is it?
 
 Thanks.
 
 Cassidy
 
-- 
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/blog/

I currently have 2 GMail invites for the taking

~|
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.houseoffusion.com/banners/view.cfm?bannerid=11

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182022
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Is form.evaluation_required some sort of reserved name?

2004-10-20 Thread Dave Francis
In CF5, fieldname_required in a form checks that form.fieldname exists and
has a value.




-Original Message-
From: Cassidy Symons [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 20, 2004 12:41 PM
To: CF-Talk
Subject: Is form.evaluation_required some sort of reserved name?


I'm have a really weird problem here...I've got a form, and one of the
fields is called 'evaluation_required' - it's a Yes/No field with values
of 1/0. The column in the database has the same name, and is a BIT field
(technically TINYINT(1) since MySQL has no real BIT, but...).

When I submit the form including that field, I receive this error message:


Form Entries Incomplete or Invalid
One or more problems exist with the data you have entered.

 * 0

Use the Back button on your web browser to return to the previous page
and correct the listed problems.



Obviously the 0 can either be 0 or 1, and I checked, it bombs on both
values (and any other value for that matter). It also bombs regardless
of what type of form field I use (select, text, radio, hidden, etc.),
but when I change the field name to evaluation_required2, it goes
through just fine.

I did a quick search on Google for 'form.evaluation_required' and
'evaluation_required' and turned up nothing related to ColdFusion. Has
anyone ever run into this before? I've never known
form.evaluation_required to be an illegal field name...is it?

Thanks.

Cassidy

--
Really, I'm not out to destroy Microsoft. That will just be a
completely unintentional side effect. - Linus Torvalds



~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182023
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Is form.evaluation_required some sort of reserved name?

2004-10-20 Thread Barney Boisvert
 Until MM ensures that only hidden form fields are considered for server
 side form validation.

Which would be impossible, since the hiddenness of a form variable
is only client-side, not server-side, so there's no way for CF to know
whether a field was hidden or not, unless it somehow preprocessed the
form before it was sent to the client and remembered for the
submission, and even that would be dependant on the form being served
from the same session as the submission is sent to.

Now that is a run-on sentance.  ; )

cheers,
barneyb

On Wed, 20 Oct 2004 12:49:17 -0400, Tangorre, Michael
[EMAIL PROTECTED] wrote:
 ColdFusion server side processing is kicking in due to the  _required
 on the field name.
 Rename your field to something else would be the easiest solution...
 Until MM ensures that only hidden form fields are considered for server
 side form validation.
 
 Michael T. Tangorre
 

-- 
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/blog/

I currently have 2 GMail invites for the taking

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182024
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: OT: CSS Class vs ID?

2004-10-20 Thread Mark Drew
On a similar note, as I have been doing this *right now* I wonder if
the fllowing is possible:
(excuse the pseudocode.

style
   .mystyle1 { // some styles here }
   .mystyle2 { //a different stule here }

//now change mystyle1 to mystyle 2

   .mystyle1 {  //overwrite with  mystyle2 }



/style

Basically I want to replace the styles in mystyle1 with those in mystyle2

any ideas?

MD


On Wed, 20 Oct 2004 09:33:07 -0700, Barney Boisvert [EMAIL PROTECTED] wrote:
 Yes, you can nest IDs.  There isn't a right one for referencing a
 certain element.  If the element is unique in a document, use ID, but
 if it's one of many, use class.  Classes are more general, so I tend
 to use those when I can, reserving ids mostly for page layout tasks
 (rather than formatting and such), but that's nothing more than a
 really loose guideline I use.
 
 cheers,
 barneyb
 
 On Wed, 20 Oct 2004 12:06:20 -0400, Damien McKenna
 [EMAIL PROTECTED] wrote:
  Which is the more correct method for calling CSS styles, to use the id
  attribute or the class attribute?  Can IDs be nested, e.g. #box #inside
  #field {...}, like classes can be, e.g. table.box th.inside td.field {...}.
  --
  *Damien McKenna* - Web Developer - [EMAIL PROTECTED]
  mailto:[EMAIL PROTECTED]
  The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
  Nothing endures but change. - Heraclitus
  
 --
 Barney Boisvert
 [EMAIL PROTECTED]
 360.319.6145
 http://www.barneyb.com/blog/
 
 I currently have 2 GMail invites for the taking
 
 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182025
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Is form.evaluation_required some sort of reserved name?

2004-10-20 Thread Tangorre, Michael
 From: Barney Boisvert [mailto:[EMAIL PROTECTED] 
 Which would be impossible, since the hiddenness of a form 
 variable is only client-side, not server-side, so there's no 
 way for CF to know whether a field was hidden or not, unless 
 it somehow preprocessed the form before it was sent to the 
 client and remembered for the submission, and even that would 
 be dependant on the form being served from the same session 
 as the submission is sent to.
 
 Now that is a run-on sentance.  ; )

Good point.

Michael T. Tangorre  

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182026
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: More IIS/J2EE configuration installation issues

2004-10-20 Thread Joe Eugene
 When we store our files in the IIS web site's root, they work fine.  But
when we try to store the files in the {jrun
root}\servers\cfusion\cfusion-ear\cfusion-war folder, the server returns a
404.


You specified a WebRoot when you installed your J2EE ColdFusion Instance,
this is where you need put your files.
The *.ear and *.war are Enterprise Java Packages (just like CFMX under
JRun), this has nothing to your WebRoot.

Joe Eugene

- Original Message - 
From: Chris Peters [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, October 20, 2004 10:38 AM
Subject: More IIS/J2EE configuration installation issues


 For those of you who have installed ColdFusion 6.1 J2EE instances and
hooked them to IIS:

 When we store our files in the IIS web site's root, they work fine.  But
when we try to store the files in the {jrun
root}\servers\cfusion\cfusion-ear\cfusion-war folder, the server returns a
404.

 It would seem to me that it would make more sense to store the files in
the ear-war.  (Why have EAR server instances if you can't store everything
under the EAR?)  Where do you guys store your web site files when using this
configuration?  If it is under the JRun server root instead of the IIS root,
do you have any tips on how to get this to work?

 

~|
The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in 
the Washington DC Area. 
http://www.houseoffusion.com/banners/view.cfm?bannerid=44

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182027
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CF developer numbers

2004-10-20 Thread Calvin Ward
Beta was a superior format to VHS


Amiga was a superior multimedia PC compared to PC-Clones or even Macs


Apple's OS is more user friendly than Windows.


Being better functionality wise doesn't guarantee market penetration or even survival.


Just something to think about...

-Original Message-
From:  Rey Bango
Date:  10/20/04 9:37 am
To:  CF-Talk 
Subj:  Re: CF developer numbers

The biggest gripe that I hear about ColdFusion from *sssooo* many people is
product cost. At $1,299 for standard and $5,999 for the enterprise, its a
steep barrier to entry compared to PHP and ASP/ASP.Net (as free
alternatives). And yes, I've read all of the posts and counterpoints to the
*free* software vs.ColdFusion debate (including Ben Forta's analysis) so
it's not even worth mentioning. Perception is what's hurting ColdFusion, not
functionality.

I went through this same process when I developed in PowerBuilder. It came
out and revolutionized the way Windows-based client/server apps were  built.
It had a strong run of about 5 years until MS brought Visual Basic up to par
and offerred VB at cut rate prices, essentially cutting off PowerBuilder at
the knees. I'm seeing many similarities with this and the ColdFusion product
line.

I think BlueDragon is a good alternative and luckily, their standard version
is free but I'm wondering if it may be too little, too late.

Rey.




~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182028
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: OT: CSS Class vs ID?

2004-10-20 Thread Dave Francis
Latest style wins.

-Original Message-
From: Mark Drew [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 20, 2004 12:53 PM
To: CF-Talk
Subject: Re: OT: CSS Class vs ID?


On a similar note, as I have been doing this *right now* I wonder if
the fllowing is possible:
(excuse the pseudocode.

style
   .mystyle1 { // some styles here }
   .mystyle2 { //a different stule here }

//now change mystyle1 to mystyle 2

   .mystyle1 {  //overwrite with  mystyle2 }



/style

Basically I want to replace the styles in mystyle1 with those in mystyle2

any ideas?

MD


On Wed, 20 Oct 2004 09:33:07 -0700, Barney Boisvert [EMAIL PROTECTED]
wrote:
 Yes, you can nest IDs.  There isn't a right one for referencing a
 certain element.  If the element is unique in a document, use ID, but
 if it's one of many, use class.  Classes are more general, so I tend
 to use those when I can, reserving ids mostly for page layout tasks
 (rather than formatting and such), but that's nothing more than a
 really loose guideline I use.

 cheers,
 barneyb

 On Wed, 20 Oct 2004 12:06:20 -0400, Damien McKenna
 [EMAIL PROTECTED] wrote:
  Which is the more correct method for calling CSS styles, to use the id
  attribute or the class attribute?  Can IDs be nested, e.g. #box #inside
  #field {...}, like classes can be, e.g. table.box th.inside td.field
{...}.
  --
  *Damien McKenna* - Web Developer - [EMAIL PROTECTED]
  mailto:[EMAIL PROTECTED]
  The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
  Nothing endures but change. - Heraclitus
 
 --
 Barney Boisvert
 [EMAIL PROTECTED]
 360.319.6145
 http://www.barneyb.com/blog/

 I currently have 2 GMail invites for the taking





~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182029
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: OT: CSS Class vs ID?

2004-10-20 Thread Barney Boisvert
You can do it with javascript, as the entire content of a stylesheet
is accessible as a variety of data structures, but you can't do it
with CSS itself.

cheers,
barneyb

On Wed, 20 Oct 2004 18:52:47 +0200, Mark Drew [EMAIL PROTECTED] wrote:
 On a similar note, as I have been doing this *right now* I wonder if
 the fllowing is possible:
 (excuse the pseudocode.
 
 style
   .mystyle1 { // some styles here }
   .mystyle2 { //a different stule here }
 
 //now change mystyle1 to mystyle 2
 
   .mystyle1 {  //overwrite with  mystyle2 }
 
 /style
 
 Basically I want to replace the styles in mystyle1 with those in mystyle2
 
 any ideas?
 
 MD
 
 
 
 
 On Wed, 20 Oct 2004 09:33:07 -0700, Barney Boisvert [EMAIL PROTECTED] wrote:
  Yes, you can nest IDs.  There isn't a right one for referencing a
  certain element.  If the element is unique in a document, use ID, but
  if it's one of many, use class.  Classes are more general, so I tend
  to use those when I can, reserving ids mostly for page layout tasks
  (rather than formatting and such), but that's nothing more than a
  really loose guideline I use.
 
  cheers,
  barneyb
 
  On Wed, 20 Oct 2004 12:06:20 -0400, Damien McKenna
  [EMAIL PROTECTED] wrote:
   Which is the more correct method for calling CSS styles, to use the id
   attribute or the class attribute?  Can IDs be nested, e.g. #box #inside
   #field {...}, like classes can be, e.g. table.box th.inside td.field {...}.
   --
   *Damien McKenna* - Web Developer - [EMAIL PROTECTED]
   mailto:[EMAIL PROTECTED]
   The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
   Nothing endures but change. - Heraclitus
  
  --
  Barney Boisvert
  [EMAIL PROTECTED]
  360.319.6145
  http://www.barneyb.com/blog/
 
  I currently have 2 GMail invites for the taking
 
 
 
 

~|
Protect your mail server with built in anti-virus protection. It's not only good for 
you, it's good for everybody.
http://www.houseoffusion.com/banners/view.cfm?bannerid=39

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182030
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


OT: Browser-Based HTML Editor

2004-10-20 Thread Adrocknaphobia
I'm looking to replace our current HTML editor, and was wondering what
recommendations everyone has.

My core requirement is when pasting content from Word, the crappy Word
HTML isn't pasted. I've only found one that has this feature,
r.a.d.editor from telerik. But their tag line is The high-end WYSIWGY
editor for ASP.NET. Nuff said.

I've found a bunch of editors that have functions that will clean word
html, but I can't trust a user to be responsible enough to do that.
SOEditor from SiteObjects has some great HTML cleaning functions but I
want them to be applied automatically when pasted.

My other requirement is that is supports CSS.

Any ideas? recommendations?

Thanks is advance.

-Adam

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182031
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CSS Class vs ID?

2004-10-20 Thread Massimo, Tiziana e Federica
 Which is the more correct method for calling CSS styles, to use the id 
 attribute or the class attribute? 

I think this cover the topic pretty well:

http://css-discuss.incutio.com/?page=ClassesVsIds


Massimo Foti
DW tools: http://www.massimocorner.com
CF tools:  http://www.olimpo.ch/tmt/





~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182032
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


java.lang.IllegalArgumentException: Unparseable date

2004-10-20 Thread Rich Tretola
java.lang.IllegalArgumentException: Unparseable date

Anyone know what this error is about?  It has been appearing in my
default-out.log file.

Rich

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182033
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: java.lang.IllegalArgumentException: Unparseable date

2004-10-20 Thread Rich Tretola
Here is the full error:

warning Couldn't parse date header.
java.lang.IllegalArgumentException: Unparseable date: Monday,
09-Feb-04 20:50:20 GMT;

The date range changes in some instances, but for the most part these
days/events are past events that, for some reason, are causing the
server to initiate a shutdown.

Rich


On Wed, 20 Oct 2004 12:21:04 -0500, Rich Tretola [EMAIL PROTECTED] wrote:
 java.lang.IllegalArgumentException: Unparseable date
 
 Anyone know what this error is about?  It has been appearing in my
 default-out.log file.
 
 Rich


~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182035
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: OT: CSS Class vs ID?

2004-10-20 Thread Jochem van Dieten
Mark Drew wrote:
 On a similar note, as I have been doing this *right now* I wonder if
 the fllowing is possible:
 (excuse the pseudocode.
 
 style
.mystyle1 { // some styles here }
.mystyle2 { //a different stule here }
 
 //now change mystyle1 to mystyle 2
 
.mystyle1 {  //overwrite with  mystyle2 }
 
 
 
 /style
 
 Basically I want to replace the styles in mystyle1 with those in mystyle2
 
 any ideas?

Not in the stylesheet. You can do it through javascript, but 
usually I prefer just to change the class of the element instead 
of editing the stylesheet. I.e., to add a class to an element if 
it doesn't exist and remove it if it does exist I use:

function swapClass(theElement, theClass) {
var classArray = theElement.className.split(/\s+/);
for (var i = 0; i  classArray.length; i++) {
if (classArray[i] == theClass) {
classArray.splice(i, 1);
theElement.className = classArray.join(' ');
return;
}
}
classArray.push(theClass);
theElement.className = classArray.join(' ');
}

Jochem

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182034
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Browser-Based HTML Editor

2004-10-20 Thread Massimo Foti
Adrocknaphobia [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
 My core requirement is when pasting content from Word, the crappy Word
 HTML isn't pasted.

This isn't the best editor you will find, but it keeps Word's garbage out:

http://www.olimpo.ch/tmt/tag/tmt_xhtmleditorPro/

Give it a try and see if it fits your needs


Massimo Foti
DW tools: http://www.massimocorner.com
CF tools:  http://www.olimpo.ch/tmt/





~|
The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in 
the Washington DC Area. 
http://www.houseoffusion.com/banners/view.cfm?bannerid=44

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182036
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


CFMX6.1, Windows 2003, and verification failure

2004-10-20 Thread Dick Tuengel
We're installing CFMX 6.1 (with the latest Updater) on a set of new Windows 2003 Web 
Edition Servers, fresh out of the box.  CF is not finding our remote mail server 
(Connection Verification Failed!), and it does not find data on mapped drives on our 
LAN.  We've changed the Logon privileges to ./Administrator, to no avail. It does find 
the ODBC data sources, which are also on a remote server.   We run similar 
configurations - CFMX 6.1 and CF 5.0 - on Windows 2000 Server machines with no 
problems.  We know that there are significant differences between the default 
services/permissions in Windows 2003 versus Windows 2000, but can't find anything 
which should cause this problem.  Has anyone else experienced this difficulty?
   
Webguy

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182037
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: OT: Browser-Based HTML Editor

2004-10-20 Thread Barney Boisvert
HTMLArea.  It can be configured to do wordsweeping on paste, and does
CSS very well.

cheers,
barneyb

On Wed, 20 Oct 2004 13:12:44 -0400, Adrocknaphobia
[EMAIL PROTECTED] wrote:
 I'm looking to replace our current HTML editor, and was wondering what
 recommendations everyone has.
 
 My core requirement is when pasting content from Word, the crappy Word
 HTML isn't pasted. I've only found one that has this feature,
 r.a.d.editor from telerik. But their tag line is The high-end WYSIWGY
 editor for ASP.NET. Nuff said.
 
 I've found a bunch of editors that have functions that will clean word
 html, but I can't trust a user to be responsible enough to do that.
 SOEditor from SiteObjects has some great HTML cleaning functions but I
 want them to be applied automatically when pasted.
 
 My other requirement is that is supports CSS.
 
 Any ideas? recommendations?
 
 Thanks is advance.
 
 -Adam
-- 
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/blog/

I currently have 2 GMail invites for the taking

~|
Protect your mail server with built in anti-virus protection. It's not only good for 
you, it's good for everybody.
http://www.houseoffusion.com/banners/view.cfm?bannerid=39

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182038
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: OT: CSS Class vs ID?

2004-10-20 Thread Dick Applebaum
What if you want to change the attributes of some related items?

Say you have table cells:

tr
   td id=col1row 1 column 1/td
   td id=col2row 1 column 2/td
/tr
tr
   td id=col1row 2 column 1/td
   td id=col2row 2 column 2/td
/tr
*
*
*

You can change the column width for all cells in the column with:

   document.getElementById(col1).style.width = 100;

This works with Safari, Mozilla, Firefox -- Haven't tested in IE yet.

You can't accomplish this with class because there is no 
getElementByClass method


Dick

On Oct 20, 2004, at 9:30 AM, Andy Allan wrote:

 The ID attribute is unique. It should apply to one and only one div.

 Use the class attribute for general styles.

 Andy


 On Wed, 20 Oct 2004 12:06:20 -0400, Damien McKenna
 [EMAIL PROTECTED] wrote:
 Which is the more correct method for calling CSS styles, to use the id
 attribute or the class attribute?  Can IDs be nested, e.g. #box 
 #inside
 #field {...}, like classes can be, e.g. table.box th.inside td.field 
 {...}.
 --
 *Damien McKenna* - Web Developer - [EMAIL PROTECTED]
 mailto:[EMAIL PROTECTED]
 The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
 Nothing endures but change. - Heraclitus



 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182039
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


CF to make Dynamic CSS

2004-10-20 Thread coldfusion . developer
I'm trying to think of a way to change values in a css file using CF.  How can I write
to a css file?  Any thoughts?

D

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182040
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: OT: CSS Class vs ID?

2004-10-20 Thread Jochem van Dieten
Dick Applebaum wrote:
 What if you want to change the attributes of some related items?
 
 Say you have table cells:
 
 tr
td id=col1row 1 column 1/td
td id=col2row 1 column 2/td
 /tr
 tr
td id=col1row 2 column 1/td
td id=col2row 2 column 2/td
 /tr
 *
 *
 *
 
 You can change the column width for all cells in the column with:
 
document.getElementById(col1).style.width = 100;

Maybe you can, but it is illegal to have multiple elements with 
the same id.


 You can't accomplish this with class because there is no 
 getElementByClass method

whatever = document.getElementByTagName(tr);
for (var i = 0; i  whatever.length; i++) {
whatever[i].firstChild.style.width = 100;
}

Or if you insist on using a class:

whatever = document.getElementByTagName(tr);
for (var i = 0; i  whatever.length; i++) {
swapClass(whatever[i].firstChild, some_100px_class);
}

Jochem

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182041
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: OT: CSS Class vs ID?

2004-10-20 Thread Michael Wilson
Hi,

Either method is correct but id's must be unique per document. Classes 
may be applied to multiple elements and instances in a single document, 
so in some instances a class offers more flexibility. I use id's as 
often as possible because I find them to be more human readable and 
because they produce, in my opinion, cleaner markup and a more logically 
structured stylesheet. Other benefits of using id's include easy 
identification of document sections, the ability to easily combine or 
override properties and values for an element using both an id and a 
class, higher specificity in the cascade, and finner control when 
working with JavaScript.

You can see an example of what I mean when I say cleaner and more 
readable code here: http://www.961media.com/temp/usingids.htm

Damien McKenna wrote:
 Which is the more correct method for calling CSS styles, to use the id 
 attribute or the class attribute?  Can IDs be nested, e.g. #box #inside 
 #field {...}, like classes can be, e.g. table.box th.inside td.field {...}.

Best regards,
Michael Wilson

~|
Protect your mail server with built in anti-virus protection. It's not only good for 
you, it's good for everybody.
http://www.houseoffusion.com/banners/view.cfm?bannerid=39

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182042
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CF to make Dynamic CSS

2004-10-20 Thread Barney Boisvert
with your LINK tag, rather than referencing a CSS file, reference a
CFM file that just happens to generate valid CSS.

Or, an easier solution is to just emebed the CSS directly in the page.
 You're not going to lose anything by doing it this way if you're
already using a dynamic CSS file.

cheers,
barneyb

On Wed, 20 Oct 2004 17:32:45 +, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
 I'm trying to think of a way to change values in a css file using CF.  How can I 
 write
 to a css file?  Any thoughts?
 
 D
 
-- 
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/blog/

I currently have 2 GMail invites for the taking

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182043
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CF to make Dynamic CSS

2004-10-20 Thread Massimo, Tiziana e Federica
 I'm trying to think of a way to change values in a css file using CF.  How
can I write
 to a css file?  Any thoughts?

You can serve a .cfm as CSS, just add the proper mime-type:

cfcontent type=text/css; charset=ISO-8859-1
body{
font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;
font-size: cfoutput#url.size#/cfoutputpx;
}

Be aware that browsers try to cache the css files and this may conflict with
what you are trying to do.
Of course, you may set the HTTP headers for the CSS file to avoid letting
the browser cache it, but that may be not so good as well...

Finally, you may split the CSS into two files:

1) A static CSS file, with the bulk of the rules; the browser is welcome to
cache it

2) A .cfm file served as CSS, containg only the dynamic rules. Here you
may prevent the browser to cache the file

Hope it will help


Massimo Foti
DW tools: http://www.massimocorner.com
CF tools:  http://www.olimpo.ch/tmt/





~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182044
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: CF to make Dynamic CSS

2004-10-20 Thread Paul Vernon
We do this.

Firstly we created a file mapping called cssx which maps to CF server in IIS
then we save out our css with the cssx file extension and the cf code we
want in there... Then in the HTML the link to the stylesheet is style.cssx
or whatever you call it

That way CF handles all the requests for files with the cssx extension and
allows you to have dynamic css.

Paul


~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182045
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: CF developer numbers

2004-10-20 Thread April Fleming
Funny I have been waiting for this conversation for a while now.  I've been
developing ColdFusion apps since 1998 as well, and every year it seems
harder to justify the costs, there are a lot alternative technologies now.
For me personally it has been a motivation to move some of my eggs into
another basket.  I just can't be a die hard, I know too many die-hard COBOL
programmers, trying real hard to find those jobs.  

I'm certainly not an expert on any of this, just something I've been
thinking about myself for a while, very happy to see it being discussed by
others.

April

-Original Message-
From: Calvin Ward [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 20, 2004 1:04 PM
To: CF-Talk
Subject: Re: CF developer numbers


Beta was a superior format to VHS


Amiga was a superior multimedia PC compared to PC-Clones or even Macs


Apple's OS is more user friendly than Windows.


Being better functionality wise doesn't guarantee market penetration or even
survival.


Just something to think about...

-Original Message-
From:  Rey Bango
Date:  10/20/04 9:37 am
To:  CF-Talk 
Subj:  Re: CF developer numbers

The biggest gripe that I hear about ColdFusion from *sssooo* many people is
product cost. At $1,299 for standard and $5,999 for the enterprise, its a
steep barrier to entry compared to PHP and ASP/ASP.Net (as free
alternatives). And yes, I've read all of the posts and counterpoints to the
*free* software vs.ColdFusion debate (including Ben Forta's analysis) so
it's not even worth mentioning. Perception is what's hurting ColdFusion, not
functionality.

I went through this same process when I developed in PowerBuilder. It came
out and revolutionized the way Windows-based client/server apps were  built.
It had a strong run of about 5 years until MS brought Visual Basic up to par
and offerred VB at cut rate prices, essentially cutting off PowerBuilder at
the knees. I'm seeing many similarities with this and the ColdFusion product
line.

I think BlueDragon is a good alternative and luckily, their standard version
is free but I'm wondering if it may be too little, too late.

Rey.






~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182046
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CF developer numbers

2004-10-20 Thread Douglas Knudsen
interestingly enough, CF is spreading inside my company.  other app
dev teams are being modeled after the one I am on due to our great
success.  Of course we are a phone company, always a little behind the
world, LOL!

Doug


On Wed, 20 Oct 2004 13:46:41 -0400, April Fleming [EMAIL PROTECTED] wrote:
 Funny I have been waiting for this conversation for a while now.  I've been
 developing ColdFusion apps since 1998 as well, and every year it seems
 harder to justify the costs, there are a lot alternative technologies now.
 For me personally it has been a motivation to move some of my eggs into
 another basket.  I just can't be a die hard, I know too many die-hard COBOL
 programmers, trying real hard to find those jobs.
 
 I'm certainly not an expert on any of this, just something I've been
 thinking about myself for a while, very happy to see it being discussed by
 others.
 
 April
 
 -Original Message-
 From: Calvin Ward [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, October 20, 2004 1:04 PM
 To: CF-Talk
 Subject: Re: CF developer numbers
 
 Beta was a superior format to VHS
 
 Amiga was a superior multimedia PC compared to PC-Clones or even Macs
 
 Apple's OS is more user friendly than Windows.
 
 Being better functionality wise doesn't guarantee market penetration or even
 survival.
 
 Just something to think about...
 
 -Original Message-
 From:  Rey Bango
 Date:  10/20/04 9:37 am
 To:  CF-Talk
 Subj:  Re: CF developer numbers
 
 The biggest gripe that I hear about ColdFusion from *sssooo* many people is
 product cost. At $1,299 for standard and $5,999 for the enterprise, its a
 steep barrier to entry compared to PHP and ASP/ASP.Net (as free
 alternatives). And yes, I've read all of the posts and counterpoints to the
 *free* software vs.ColdFusion debate (including Ben Forta's analysis) so
 it's not even worth mentioning. Perception is what's hurting ColdFusion, not
 functionality.
 
 I went through this same process when I developed in PowerBuilder. It came
 out and revolutionized the way Windows-based client/server apps were  built.
 It had a strong run of about 5 years until MS brought Visual Basic up to par
 and offerred VB at cut rate prices, essentially cutting off PowerBuilder at
 the knees. I'm seeing many similarities with this and the ColdFusion product
 line.
 
 I think BlueDragon is a good alternative and luckily, their standard version
 is free but I'm wondering if it may be too little, too late.
 
 Rey.
 
 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182047
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


BannerMan custom tag from cfhub..

2004-10-20 Thread Phillip Perry
Has anyone used this custom tag and if so could I ask some questions about
it?

Thanks

Phil




~|
The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in 
the Washington DC Area. 
http://www.houseoffusion.com/banners/view.cfm?bannerid=44

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182048
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: CF developer numbers

2004-10-20 Thread Ian Skinner
I think there are two worlds here.  The price of CF server is a bit steep for many 
smaller companies, but to larger one's it is actually looked at as too cheap!  I have 
had to sell that is was a fully functional product, not some IT toy.

Working at a company that pays both for Enterprise Oracle and Crystal report licenses, 
my CF budget doesn't even get an eye blink.  Being a non-profit does help on all 
fronts though!

--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

C code. C code run. Run code run. Please!
- Cynthia Dunning



Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 



~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182049
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: CF developer numbers

2004-10-20 Thread April Fleming
When I worked at Kennedy Space center it was a very interesting setup, we
had a dev group for CF, one for ASP, one for JAVA, and one using PL/SQL in
Oracle.  All of the teams were developing web-based applications, although
the CF group was using it more for Dynamic websites, than for actual web
apps, until we started using it to integrate with the ESRI GIS software for
web-based mapping apps.  

My point though (if there is one) was it really showed me how the same
objective can be achieved with many different technologies and the success
of the project really depended on how well the dev team knew what they were
doing. 

CF was definitely the best choice for the dynamic websites, fast dev time
and cheaper labor than the java or oracle guys, but for the apps each team
really seemed to have their stuff together, no group really stood out in
terms of efficiency or organization of project.

Boy you wanna talk about holy wars, when the groups got together to discuss
technologies, all heck broke loose ;)

-Original Message-
From: Douglas Knudsen [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 20, 2004 2:04 PM
To: CF-Talk
Subject: Re: CF developer numbers


interestingly enough, CF is spreading inside my company.  other app dev
teams are being modeled after the one I am on due to our great success.  Of
course we are a phone company, always a little behind the world, LOL!

Doug


On Wed, 20 Oct 2004 13:46:41 -0400, April Fleming [EMAIL PROTECTED]
wrote:
 Funny I have been waiting for this conversation for a while now.  I've 
 been developing ColdFusion apps since 1998 as well, and every year it 
 seems harder to justify the costs, there are a lot alternative 
 technologies now. For me personally it has been a motivation to move 
 some of my eggs into another basket.  I just can't be a die hard, I 
 know too many die-hard COBOL programmers, trying real hard to find 
 those jobs.
 
 I'm certainly not an expert on any of this, just something I've been 
 thinking about myself for a while, very happy to see it being 
 discussed by others.
 
 April
 
 -Original Message-
 From: Calvin Ward [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, October 20, 2004 1:04 PM
 To: CF-Talk
 Subject: Re: CF developer numbers
 
 Beta was a superior format to VHS
 
 Amiga was a superior multimedia PC compared to PC-Clones or even Macs
 
 Apple's OS is more user friendly than Windows.
 
 Being better functionality wise doesn't guarantee market penetration 
 or even survival.
 
 Just something to think about...
 
 -Original Message-
 From:  Rey Bango
 Date:  10/20/04 9:37 am
 To:  CF-Talk
 Subj:  Re: CF developer numbers
 
 The biggest gripe that I hear about ColdFusion from *sssooo* many 
 people is product cost. At $1,299 for standard and $5,999 for the 
 enterprise, its a steep barrier to entry compared to PHP and 
 ASP/ASP.Net (as free alternatives). And yes, I've read all of the 
 posts and counterpoints to the
 *free* software vs.ColdFusion debate (including Ben Forta's analysis) so
 it's not even worth mentioning. Perception is what's hurting ColdFusion,
not
 functionality.
 
 I went through this same process when I developed in PowerBuilder. It 
 came out and revolutionized the way Windows-based client/server apps 
 were  built. It had a strong run of about 5 years until MS brought 
 Visual Basic up to par and offerred VB at cut rate prices, essentially 
 cutting off PowerBuilder at the knees. I'm seeing many similarities 
 with this and the ColdFusion product line.
 
 I think BlueDragon is a good alternative and luckily, their standard 
 version is free but I'm wondering if it may be too little, too late.
 
 Rey.
 
 



~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=36

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182050
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: css ?

2004-10-20 Thread Michael Wilson
Hi,

You could also place this in your stylesheet:

#altBackground {
 background-image: none;
 background-color: white;
}

Then use body id=altBackground on the pages you wish to override. 
The only advantages this offers are that it keeps your CSS in your 
stylesheet rather than having inline markup you'll have to maintain 
later and allows you to easily reuse the same style for other pages if 
the need arises.

Dave Francis wrote:
 body style=background-image:none; background-color:white

 is there a way to override a body tag?

Best regards,
Michael Wilson

~|
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.houseoffusion.com/banners/view.cfm?bannerid=11

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182051
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: CFMX6.1, Windows 2003, and verification failure

2004-10-20 Thread Dave Watts
 We're installing CFMX 6.1 (with the latest Updater) on a set of new
 Windows 2003 Web Edition Servers, fresh out of the box.  CF is not
 finding our remote mail server (Connection Verification Failed!), and 
 it does not find data on mapped drives on our LAN.  We've changed the 
 Logon privileges to ./Administrator, to no avail. It does find the 
 ODBC data sources, which are also on a remote server.   We run similar
 configurations - CFMX 6.1 and CF 5.0 - on Windows 2000 Server machines
 with no problems.  We know that there are significant differences
 between the default services/permissions in Windows 2003 versus Windows
 2000, but can't find anything which should cause this problem.  Has
 anyone else experienced this difficulty?

Can you access your mail server using the MS telnet client from that
server's console?

As for the mapped drives, drive mappings generally belong to specific users.
If you're running CF with a user account that has persistent drive mappings,
it should be able to use them. If not, you can just use UNC paths if you're
running CF as a user with rights to the appropriate UNC shares.
   
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444


~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182052
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Cffile issue...

2004-10-20 Thread Jeff Waris
An error occurred when performing a file operation Append on file.

Using CFMX 6.1, all I am doing is taking a query and writing it out to a
file, line by line for each record. It writes about 70K and it errors out
with that message at the top. Once errored, Coldfusion still has the file.
The only way for Coldfusion to release it is to restart services.

Anyone have anything similar happen to them? Ideas?

Thanks,
Jeff


~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182053
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Query string in db field

2004-10-20 Thread Ben Densmore
I'm trying to find the best way to take a query string that would look
something like name=somenameid=12address=123email=yes   and pull
out the values. These query strings are stored in a field in a
database. I just can't seem to think of a way to do this.

Anyone have any ideas?

Thanks,
Ben

~|
Get the mailserver that powers this list at 
http://www.houseoffusion.com/banners/view.cfm?bannerid=17

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182054
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: SQL Deadlock

2004-10-20 Thread G
Unfortunately there is no silver bullet for the problem of
deadlocking...they are a fact of life in multi-user, real-time applications.
However, you can do some things to severely limit the chances of them
occurring, and for properly handling them when they do.

Deadlocks occurr when Process A locks up a resource while executing, at the
same time, Process B fires up and locks another resource. In the course of
operating, Process A suddenly needs the resource that Process B has locked,
so it waits. Before Process B can finish, it requires a resource locked by
Process A. The resulting deadlock means neither process will ever end. The
database manager resolves the situation by selectively killing one of the
processes. Things you can do to help:

- Break up large processes into smaller, compartmentalized chunks. The
longer a process is running, and the greater number of resources it locks
while executing, the better the chances of a deadlock.
- Always use cftransaction in conjunction with your compartments to ensure
proper rollback in case of an error.
- Trap deadlock errors using try...catch, display a user friendly error to
the user (perhaps give them another chance to fire off the process).
- Depending on the database, you may be able to do some tweeks with how the
DB sets its locks (ie row locking vs. table locking). I'm not an expert at
this stuff, but i think it can be something to look into.

Hope that helps a little,

Brian

- Original Message - 
From: Ryan Duckworth [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, October 20, 2004 11:01 AM
Subject: SQL Deadlock


 Does anyone have any ideas on how to prevent/handle database deadlock?

 Error Executing Database Query. [Macromedia][SQLServer JDBC
 Driver][SQLServer]Transaction (Process ID 132) was deadlocked on lock
 resources with another process and has been chosen as the deadlock
 victim. Rerun the transaction.

 We get a message similar to the one above about once a week.

 My guess is that the deadlock occurred b/c the same row was attempting
 to be read and written to at the same time.


 Ryan Duckworth
 Macromedia ColdFusion Certified Professional
 Uhlig Communications
 10983 Granada Lane
 Overland Park, KS 66211
 (913) 754-4272


 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182055
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Query string in db field

2004-10-20 Thread Dawson, Michael
You can use a regular expression.  I remember seeing a regex that pulls values from a 
URL, but I can't remember where.  Google regular expression and either URL|Query 
String|etc.

  _  

From: Ben Densmore [mailto:[EMAIL PROTECTED]
Sent: Wed 10/20/2004 2:27 PM
To: CF-Talk
Subject: Query string in db field



I'm trying to find the best way to take a query string that would look
something like name=somenameid=12address=123email=yes   and pull
out the values. These query strings are stored in a field in a
database. I just can't seem to think of a way to do this.

Anyone have any ideas?

Thanks,
Ben



~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182056
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Add the results of one query to another

2004-10-20 Thread David Mineer
What is the best way to add the results of 2 queries into one.

I want to check 2 different databases for login information.  A union
query does work but I would like to use Cold Fusion to do it if
possible.

TIA,

-- 
David Mineer Jr

-
Don't wish it was easier; wish you were better.
Don't wish for less problems; wish for more skills.
Don't wish for less challenges; wish for more wisdom.

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182057
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Query string in db field

2004-10-20 Thread Qasim Rasheed
How about using 

cfset myarray = listtoarray( yourquerystring, '')


On Wed, 20 Oct 2004 13:27:10 -0500, Ben Densmore [EMAIL PROTECTED] wrote:
 I'm trying to find the best way to take a query string that would look
 something like name=somenameid=12address=123email=yes   and pull
 out the values. These query strings are stored in a field in a
 database. I just can't seem to think of a way to do this.
 
 Anyone have any ideas?
 
 Thanks,
 Ben
 
 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182058
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Query string in db field

2004-10-20 Thread Umer Farooq
Sample code-- no error checking.. bunch of other ways to do it also..


cfset eachString = arrayNew(1)
cfset pairedValue= arrayNew(1)
cfset queryString = name=somenameid=12address=123email=yes
cfset eachString = listToArray(queryString , )
cfloop from=1 to=#arrayLen(eachString)# index=i
 cfset pairedValue=listToArray(eachString[i], =)
cfoutput
  Variable: #pairedValue[1]#br
 Value: #pairedValue[2]#br
 /cfoutput
/cfloop


Ben Densmore wrote:
 I'm trying to find the best way to take a query string that would look
 something like name=somenameid=12address=123email=yes   and pull
 out the values. These query strings are stored in a field in a
 database. I just can't seem to think of a way to do this.
 
 Anyone have any ideas?
 
 Thanks,
 Ben
 
 

~|
The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in 
the Washington DC Area. 
http://www.houseoffusion.com/banners/view.cfm?bannerid=44

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182059
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Add the results of one query to another

2004-10-20 Thread G
Mind if i ask why? Seems to me a one-query union would be faster than
anything CF could do that would require TWO queries, on top of the extra CF
processing.

- Original Message - 
From: David Mineer [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, October 20, 2004 1:34 PM
Subject: Add the results of one query to another


 What is the best way to add the results of 2 queries into one.

 I want to check 2 different databases for login information.  A union
 query does work but I would like to use Cold Fusion to do it if
 possible.

 TIA,

 -- 
 David Mineer Jr

 -
 Don't wish it was easier; wish you were better.
 Don't wish for less problems; wish for more skills.
 Don't wish for less challenges; wish for more wisdom.

 

~|
Protect your mail server with built in anti-virus protection. It's not only good for 
you, it's good for everybody.
http://www.houseoffusion.com/banners/view.cfm?bannerid=39

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182060
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Add the results of one query to another

2004-10-20 Thread Douglas Knudsen
look up query of query.  If you have a query result named foo and
one named goo, you can use

cfquery name=foogoo  dbtype=query
  SELECT  foo.username, goo.somecolumn
   FROM foo, goo
WHERE foo.id = goo.id
/cfquery


Doug



On Wed, 20 Oct 2004 12:34:46 -0600, David Mineer [EMAIL PROTECTED] wrote:
 What is the best way to add the results of 2 queries into one.
 
 I want to check 2 different databases for login information.  A union
 query does work but I would like to use Cold Fusion to do it if
 possible.
 
 TIA,
 
 --
 David Mineer Jr
 
 -
 Don't wish it was easier; wish you were better.
 Don't wish for less problems; wish for more skills.
 Don't wish for less challenges; wish for more wisdom.
 
 

~|
Get the mailserver that powers this list at 
http://www.houseoffusion.com/banners/view.cfm?bannerid=17

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182061
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CF developer numbers

2004-10-20 Thread Robert Munn
I come across this stance occasionally and I am always careful to point out to 
management in my company that by using ColdFusion we are using Java. I have CF 
Enterprise running in J2EE configuration and I am in the process of installing it on 
servers that will also host other Java-based non-CF apps. 

Essentially, my stance is that CFMX is just another Java application in our 
infrastructure, one that has the specific purpose of making it faster and easier for 
us to develop custom applications. In this respect I distinguish it from PHP and ASP 
(both of which we have running one or two small legacy things internally) because CFMX 
fits in our Java infrastructure and the others do not. If I have two servers setup 
with J2EE, I can install all of my apps on those servers, including CFMX, and 
load-balance the individual apps as needed. If I need more capacity, I just scale 
horizontally by adding additional servers, and any or all of the apps can be added to 
the new server.

In terms of the industry, I go back to something I posted about several years ago on 
the forums when the migration of CF to Java was first announced. Basically the 
industry has boiled down to the Java world and the Microsoft world. 

I haven't seen any really recent market data, but I get the sense that PHP is still a 
third wheel with a broad base but relatively shallow depth of use overall. Maybe I'm 
wrong there are the world has become a three-way battle- Microsoft, Java, and 
open-source, I would be interested to know if anyone has seen up to date research on 
that topic.

From an individual career standpoint, we all need to learn more to stay competitive. 
Java is a good additional skillset for CF developers to have. 



I agree completely, but there's no telling this to the Java snobs who insist
that we must use Java exclusively, because they do and CF is just for
beginners.

All of this leads to Gartner recommending that we all migrate from CF to
Java or ASP (because CF is a niche product) and the managers of the
businesses that hire contractors read Gartner's research.

-Original Message-
From: Dick Applebaum [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 20 October 2004 10:36 
To: CF-Talk
Subject: Re: CF developer numbers

On Oct 19, 2004, at 6:47 PM, James Holmes wrote:

[snip]

If CF is relegated to a niche product, then the IT  web development
professionals are doing themselves a tremendous disservice.

The fact that that CF is easy to learn for a lay person (or incidental
developer) does not detract from its power, or applicability to more
sophisticated applications.

~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta 
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182062
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CFMX6.1, Windows 2003, and verification failure

2004-10-20 Thread Dick Tuengel
David - We cannot telenet from any of the Windows 2003 servers to the mail server:  we 
can telenet from all of the Windows 2000 servers.  What is the significance of that?  

Webguy

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182063
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Query string in db field

2004-10-20 Thread Scott Brady
On Wed, 20 Oct 2004 13:27:10 -0500, Ben Densmore  wrote:
 I'm trying to find the best way to take a query string that would look
 something like name=somenameid=12address=123email=yes   and pull
 out the values. These query strings are stored in a field in a
 database. I just can't seem to think of a way to do this.

You can treat the string as a list with  as the delimiter. Each
element in that list can then also be treated as a list with = as
the delimiter.

Knowing that, there are several avenues you can take. You can create
an array out of the main list (as Oasim suggested), which will give
you an array of just the name/value pairs. You can then extract each
value treating each element in that array as a list with 2 items
(delimited by =).

Or, you can loop over the main list (string), and similarly extract
the names and values.

Scott
-- 
-
Scott Brady
http://www.scottbrady.net/

~|
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.houseoffusion.com/banners/view.cfm?bannerid=11

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182064
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: SQL Deadlock

2004-10-20 Thread Umer Farooq
Deadlocks are hard to trouble shoot..

don't overly use cftransaction with select... i.e espcially.. when 
doing Select MAX(ID) instead use..  following in the insert..

   SELECT @@IDENTITY AS whateverFiledName;
   set nocount off

   cfset newId = insertNewId.whateverFiledName

also for updates and deletes.. try... WITH(ROWLOCK)

Ryan Duckworth wrote:
 Does anyone have any ideas on how to prevent/handle database deadlock?
 
 Error Executing Database Query. [Macromedia][SQLServer JDBC
 Driver][SQLServer]Transaction (Process ID 132) was deadlocked on lock
 resources with another process and has been chosen as the deadlock
 victim. Rerun the transaction.
 
 We get a message similar to the one above about once a week.
 
 My guess is that the deadlock occurred b/c the same row was attempting
 to be read and written to at the same time.
 
 
 Ryan Duckworth 
 Macromedia ColdFusion Certified Professional
 Uhlig Communications 
 10983 Granada Lane 
 Overland Park, KS 66211
 (913) 754-4272
 
 
 

~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF 
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182065
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


  1   2   >