i have the same problem, its new, never happened before, and is now
happening, same kind of code, almost exact actually.
but same problem.
what gives?
ps. its works in s... (bla**st**) just fine, just not in cfmx 6.1
tw
On Wed, 3 Nov 2004 17:21:40 -0700, Charlie Griefer
<[EMAIL P
Here's two methods, one with pure CFML, and one using Java.
#fileinfo.size#
#createObject("java",
"java.io.File").init(filename).length()#
cheers,
barneyb
On Thu, 4 Nov 2004 14:23:46 +1030, Parker, Kevin <[EMAIL PROTECTED]> wrote:
> Is it possible to determine the size of a file in CFML?
>
I am not sure about cffile or cfdirectory, however using some native
Java classes, I am confident that you can get this information.
On Thu, 4 Nov 2004 14:23:46 +1030, Parker, Kevin <[EMAIL PROTECTED]> wrote:
> Is it possible to determine the size of a file in CFML?
>
> TIA!!
>
> ++
>
Is it possible to determine the size of a file in CFML?
TIA!!
++
Kevin Parker
Web Services Manager
WorkCover Corporation
p: 08 8233 2548
m: 0418 806 166
e: [EMAIL PROTECTED]
w: www.workcover.com
++
This e
o.param is a string that I get out of a CFPROCEDURE it's there and
avaiable. I have focused it down to the setting the request variable.
when I dump and abort the o.param it's there.
Ian
On Wed, 3 Nov 2004 17:02:11 -0800, Sean Corfield <[EMAIL PROTECTED]> wrote:
> On Wed, 3 Nov 2004 18:29:00 -0
Either way, it had to be set or the error he would get would be PARAM not
defined in O.
-Original Message-
From: Sean Corfield [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 03, 2004 8:02 PM
To: CF-Talk
Subject: Re: How to use Request scope?!
On Wed, 3 Nov 2004 18:29:00 -0500, Ian S
On Wed, 3 Nov 2004 18:29:00 -0500, Ian Sheridan <[EMAIL PROTECTED]> wrote:
> oh yeah it works I am getting the expected value in o.param.
Where is o.param set? You didn't show that in your cut-down code...
> > >
> > >
> > >
> > >
> > > #request.actionpasser#
> > >
> > >
> > >
> > >
--
Sean
I have only ever used it as an authentication method, i.e. rather than
checking against say a database I used this to authenticate the user
against the domain, if true set the appropriate session variables and
that was that. So to log out simply cleared the session.
You don't necessarily have to s
OK, tonight the community suite is open till late so come on over. Tomorrow we open at
9 and will be auctioning off a huge amout of cool books at 10. After that we're
raffling off the xbox w/ games. (about 11 or so). If your in the area, come on over.
If your not, we are allowing raffle tickets
what's the exact datatype of the field in the database?
On Wed, 03 Nov 2004 15:31:59 -0800, Brook Davies
<[EMAIL PROTECTED]> wrote:
> Actually, I added the val function AFTER getting the error - it makes no
> difference...
>
>
>
> At 03:09 PM 11/3/2004, you wrote:
> >do you need the val() fu
oops, I meant Sun's j2re1.4.2_06
At 03:38 PM 11/3/2004, you wrote:
>After trying everything under the sun to figure out why our CFMX 6.1
>updater 1 server was crashing every day we decided to try a new JRE.
>We were previously using JavaSoft 1.3.1_09 and changed to
>Java's j2re1.4.2_06 and the
After trying everything under the sun to figure out why our CFMX 6.1
updater 1 server was crashing every day we decided to try a new JRE.
We were previously using JavaSoft 1.3.1_09 and changed to
Java's j2re1.4.2_06 and the server has been stable for over a week with
memory usage MUCH better.
Actually, I added the val function AFTER getting the error - it makes no
difference...
At 03:09 PM 11/3/2004, you wrote:
>do you need the val() function? is the value coming in as a string or
>numeric?
>
>what happens if you simply #val(arguments.case_id)#?
>
>
>On Wed, 03 Nov 2004 14:50:24 -08
oh yeah it works I am getting the expected value in o.param.
On Wed, 3 Nov 2004 15:15:46 -0800, Sean Corfield <[EMAIL PROTECTED]> wrote:
> Have you checked that o.param contains a valid value?
>
>
>
> On Wed, 3 Nov 2004 14:18:49 -0500, Ian Sheridan <[EMAIL PROTECTED]> wrote:
> > I was getting
Have you checked that o.param contains a valid value?
On Wed, 3 Nov 2004 14:18:49 -0500, Ian Sheridan <[EMAIL PROTECTED]> wrote:
> I was getting the "actionpasser" not defined in the Request scope.
>
> This is basicly what I am doing:
>
>
>
>
>
> #request.actionpasser#
>
>
>
>
~
do you need the val() function? is the value coming in as a string or numeric?
what happens if you simply #val(arguments.case_id)#?
On Wed, 03 Nov 2004 14:50:24 -0800, Brook Davies
<[EMAIL PROTECTED]> wrote:
> This query was working fine, with the arguments.case_id variable being
> 30026 (and t
And in Access...
You'll have to run a query that selects the column you want first...
SELECT MyColumn From table
then...
-Original Message-
From: Mark Wimer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 03, 2004 4:42 PM
To: CF-Talk
Subject: Re: Another data type question
This query was working fine, with the arguments.case_id variable being
30026 (and the function it is in is set to receive the case_id as numeric.
Bottom line is it IS numeric.
select payment_mode from expense
where case_id =
Now all of a sudden I get this error unless I remove the and
do
ThatÂ’s pretty strange. I've never seen or heard of it happening before.
Everything seems right to me. What happens when you unscope it? Make it just
actionpasser instead of request.actionpasser.
This would work just the same as it SHOULD when scoped as request. Are you
having nay problems with the
At 01:54 PM 11/3/2004, you wrote:
>James Smith wrote:
> > INSERT INTO barcodes (Barcode, ItemID) VALUES (0008811953928,17870)
> >
> > Could anyone tell me why the number 0004294967295 is causing an error
> > when the SQL statement doesn't even show it being used?
>
> Becau
One thing I forgot to mention -- it only happens if you use SSL. We use 128-bit SSL
encryption for all our stuff. So that might be the distinction...
I didn't extract it from the updater -- the Macromedia rep sent it to me. He says it
isn't the final solution, so once I have the real thing, I
Donna,
Here's an old code snippet from CF4/SQL7 days - may still work - if you're
using MSSQL. Just an example of how to get at datatypes.
Mark
#Column_Name#
#Type_Name#
#Length#
#Nu
I wonder why this would only be happening to some people (myself
included). How did you extract the jrun.dll from the Updater 4?
Brook
At 10:38 AM 11/3/2004, you wrote:
>FYI, after many tests, we have isolated the problem as a memory leak in
>jrun.dll. I've replaced the current jrun.dll with
Okay, so I've got a SELECT menu that allows the user to choose which
DB field they'd like to see results on, then a text box to allow them
to enter the appropriate data for the SELECT choice. Now I'm wondering
if I should add some sort of CFIF to show the appropriate SELECT for
the 2nd portion inst
FYI, after many tests, we have isolated the problem as a memory leak in jrun.dll.
I've replaced the current jrun.dll with the one in JRun 4 Updater 4 (build 84683), and
it has brought down the memory usage, which, mind you, was going over 250MB easy a
day, to a measly 19MB.
It's a workaround,
I was getting the "actionpasser" not defined in the Request scope.
This is basicly what I am doing:
#request.actionpasser#
On Wed, 3 Nov 2004 14:08:51 -0500, Ewok <[EMAIL PROTECTED]> wrote:
> Same here... I set all my request variables in one file then include it via
> Application.cfm.
The File when generated is approx 2 Meg in size. What have I done is
learned the RTF File Format and is 60 Pages long.
At 07:23 AM 11/3/2004, you wrote:
>On Wednesday 03 Nov 2004 12:04 pm, Graham Pearson wrote:
> > Branch target offset too large for short
>
>Is the file very large ?
>Can you test
Cool - thanks.
Ray
At 02:10 PM 11/3/2004, you wrote:
>Try dumping the server variables
>
>
>
>Should get you everything you need to know about the server
>
>-Original Message-
>From: Ray Champagne [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, November 03, 2004 1:35 PM
>To: CF-Talk
>Subject:
It shouldn't matter what version. Request variables worked the way
documented in 5, I know from experience. They should work in 6.0 just fine.
But that raises the question of why you're running 6.0 instead of 6.1
with updaters. Is there are reason? If not, you should definately
update -- th
Try dumping the server variables
Should get you everything you need to know about the server
-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 03, 2004 1:35 PM
To: CF-Talk
Subject: getting CF version, other details
Isn't there a script that one
Same here... I set all my request variables in one file then include it via
Application.cfm. the request vars are available anywhere and everywhere
throughout the entire application this way.
If you have these two files...
#request.testvar#
Index.cfm should just display "request variable"
Does not verify in CF Admin under the Access or Access w/Unicode drivers. SQL Server
DSNs seem to be working fine.
As far as the ports, yes, everything is open that should be open.
Thanks,
Jake
>On Wednesday 03 Nov 2004 16:02 pm, Jake wrote:
>> And when you hit the sites that they are running,
James Smith wrote:
> INSERT INTO barcodes (Barcode, ItemID) VALUES (0008811953928,17870)
>
> Could anyone tell me why the number 0004294967295 is causing an error
> when the SQL statement doesn't even show it being used?
Because it is 2^32. Instead of throwing an error M
if the cfdump doesn't work, you're pre-CF 5 :)
On Wed, 03 Nov 2004 13:34:37 -0500, Ray Champagne <[EMAIL PROTECTED]> wrote:
> Isn't there a script that one can run to find this out when you don't have
> access to the administrator?
>
> I know that you can do this in other languages, but not su
> Looking for LIVE demonstrations
Macromedia Breeze Live is very, very good for this. I think MM just
introduced a pay-per-use option for hosted Breeze.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
~
> I am having trouble running a Visual FoxPro Executable via CFEXECUTE to
> do some DBF maniupations on the Server -- the EXE is loaded as a service
> and then is not released upon execution timeout as specified in the
> CFEXECUTE statement (20 seconds) -- I included reference to an
> "outputfile"
Oh it is passing the right info but maybe it's because I am doing this
on a 6.0 machine
Ian
On Wed, 03 Nov 2004 13:25:35 -0500, Ben Doom <[EMAIL PROTECTED]> wrote:
> Except that I do exactly what you said didn't work all the time. I
> routinely create request or variable scoped vars in one inclu
Isn't there a script that one can run to find this out when you don't have
access to the administrator?
I know that you can do this in other languages, but not sure for CF.
I am working on a potential client, and would like to find this stuff out
without having to ask.
Ray
===
A request scope can be set anywere and is available anywhere during a
request. However its bad coding practice to use it in CFCs and what
not but as far as I can tell it can be done.
Adam
On Wed, 03 Nov 2004 13:25:35 -0500, Ben Doom <[EMAIL PROTECTED]> wrote:
> Except that I do exactly what you
Except that I do exactly what you said didn't work all the time. I
routinely create request or variable scoped vars in one include to be
used in another. The includes are serial, not nested.
So I don't know what your original problem was, but I'd be careful to
check and make sure that the val
I'm attempting to go into Schema view in XML Spy Home 2005 on the
enclosed XML file when it gives the error "Unable to show schema.
Schema has to begin with a schema-element!". Anyone have any ideas what
I'm missing in my files? Thanks.
--
*Damien McKenna* - Web Developer - [EMAIL PROTECTED]
> http://www.rohanclan.com/library/printdirlist.cfm
Very Cool!
~|
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?ba
Well let me be a little bit more descriptive.
I have an "index.cfm" page that includes two files. I was then setting
the REQUEST variable *in* the first include. In the second include I
would then look for it. This did not work.
I now set the REQUEST variable in the "index.cfm" file first. Then
From: Ryan Jones wrote:
>
> With PHP I am basicly open and free to code and make the
> language do just about anything I want it to. With cfml, I
> could find myself at a place where I need to call on java.
> However, if I understand correctly, the free version of
> Bluedragon does not suppo
Thanks. Exactly what I needed.
-Original Message-
From: Rob [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 03, 2004 11:39 AM
To: CF-Talk
Subject: Re: OT: How do I print out a directory listing in XP
http://www.rohanclan.com/library/printdirlist.cfm
On Wed, 3 Nov 2004 11:18:56 -06
It sounds like it wasn't always being set in the first include.
Regardless of what file a request variable is set in, it is available to
all subsequent code. I may be off a bit with regard to CFCs, but that's
how I understand it.
--Ben
Ian Sheridan wrote:
> well that's the thing I am setting
well that's the thing I am setting it in include not the index.cfm file.
so I created it in the index.cfm file NOT the included file and it now works.
Ian
On Wed, 3 Nov 2004 12:41:26 -0500, Ewok <[EMAIL PROTECTED]> wrote:
> Sure, as long as you set it before you call it of course
>
>
>
>
You can do sticky sessions in a cluster, but that means that a given
session always ends up on the same server, not than the session data
is shared across the cluster to whatever machine needs it. That's
done with the load balancing hardware/software. Still RAM-only
session vars, becuase they're
>> c:\cfusionmx\bin\cfencode f:\websites\[path]\*.cfm f:\websites\[path]\*.cfm /r
>
>Path too long, or contains funny chars ?
>
The path uses no spaces or funny chars, just alpha characters. It worked before, but
does not now, which is strange. I've even logged on as administrator and it still doe
He could be talking about a custom session management scheme. I have used rsession
(http://vfive.com/rsession/index.html)in previous (CF5) projects in order to avoid
having to lock session vars and to support non-sticky sessions in clusters.
-Phil
>What Barney said is dead-on. I am a total z
dir /og > dirlist.txt
-Original Message-
From: Andy Ousterhout [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 03, 2004 12:19 PM
To: CF-Talk
Subject: OT: How do I print out a directory listing in XP
I need to print out a directory listing for a disk I am sending to a
printer.
Can som
You can redirect the listing to a text file
C:\DIR C:\MYDIRECTORY > listing.txt
then print the text file
-Original Message-
From: Andy Ousterhout [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 03, 2004 12:19 PM
To: CF-Talk
Subject: OT: How do I print out a directory listing in XP
Sure, as long as you set it before you call it of course
-Original Message-
From: Ian Sheridan [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 03, 2004 12:38 PM
To: CF-Talk
Subject: How to use Request scope?!
can you set a request scope variable in an include?
ex.
-index.cfm
---
Got it working with this code:
SELECT COUNT(*) as ClientCount
FROM Clients
WHERE
Client_IntakeDate >=
AND
Client_IntakeDate <=
AND
#Trim(Form.Param1Select)# =
AND
#Trim(Form.Param2Select)# =
AND
http://www.rohanclan.com/library/printdirlist.cfm
On Wed, 3 Nov 2004 11:18:56 -0600, Andy Ousterhout <[EMAIL PROTECTED]> wrote:
> I need to print out a directory listing for a disk I am sending to a printer.
> Can someone tell me how to do this?
>
> Thanks,
> Andy
>
>
can you set a request scope variable in an include?
ex.
-index.cfm
--include1.cfm --> set request.test
--include2.cfm --> read request.test
can this be done?
--
--
Ian Sheridan
http://www.savagevines.com
--
~~
I need to print out a directory listing for a disk I am sending to a printer.
Can someone tell me how to do this?
Thanks,
Andy
~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF
community.
Okay, I see what you mean but I'm not sure how to define since they
are passed from selects instead of a db field?
Thank you for your help,
~ Donna
On Wed, 03 Nov 2004 01:59:39 +0100, Jochem van Dieten
<[EMAIL PROTECTED]> wrote:
> Donna French wrote:
> > Should this code work if I only pass the
On Wednesday 03 Nov 2004 16:02 pm, Jake wrote:
> And when you hit the sites that they are running, I get the following
> error:
> Error Executing Database Query.
> coldfusion.sql.DatabaseConnectionException: Timed out trying to
> establish connection
Does it verify in the administrator ?
Are the
What Barney said is dead-on. I am a total zero on clusters, but isn't
there a way -- outside of CF -- to handle sessions so they remain
sticky despite the application? i.e. an external application of some
sort. Would that be db-related?
Systems guys at that level usually aren't so ignorant so I
hello there,
at our college, we made it a policy to have the sessions for our portal
appllcation expire after 3 minutes of inactivity. This is to address
security and privacy issues. Portal built using PHP and implemented
Novell's iChain for single signon ability across any applications that
invol
Whether or not the RDBMS caches it CF will still have to go to the dB
server and get it. If you use cachedwithin (or cachedafter) then it
stays in CF's memory, and no trips to the dB are required, so i'd say
cache it.
And don't forget you could put it in a persistent scope (either
"application" or
Hello,
If you log someone in using jrun.security.NTAuth, how do you log them
out?
Sincerely,
Andrew
~|
The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in
the Washington DC Area.
http://w
All,
The server I'm on just recently was upgraded to Windows2003. While
everything else seems to be running fine, the one thing that didn't make
the transition very well as that the Access and Access w/ Unicode
drivers don't seem to be working. I can't get any datasource using those
drivers to
Ryan,
In my past life, working for an ISP that was a CF house, we had several
high subscriber e-newsletter clients. One technique that we employed,
which greatly reduced server load and errors, was to send out these
newsletters in batches of 500. Fairly easy to script, did not drag out
system
On Wed, 3 Nov 2004 03:58:17 -0700, Stephen Cassady <[EMAIL PROTECTED]> wrote:
> Please please let me know the solution!!!
>
> This is bringing my server to it's knees constantly, the JRun locks a
> processor (Dual Xeons, so 1 of the 4 virtual chips and runs 25% of my system
> process) and the VMem
Ryan,
My suggestion is to use a blend of tools. CFML, IMO, will provide you with
faster application turnaround but that doesn't mean that you should abandon
tools that aren't built in it. Use what's best for the specific task at hand
and don't rewrite something for the sake of doing it. If you hav
Some of you might find this a little weird
But I once looped a cfmail to test BlueDragon' 3.x version and my
mail server I can't remember how many emails I was (and had) set
to receive, but I had no problem what so ever
And the loop was several 10s of thousand... probably about 50 00
> >>> INSERT INTO barcodes (Barcode, ItemID) VALUES
> (0008811953928,17870)
> >>>
> >>> Could anyone tell me why the number 0004294967295 is causing an
> >>> error
> when the SQL statement doesn't even show it being used?
> >>
> >> Because it is 2^32. Instead of throwing an error MySQL jus
On Wednesday 03 Nov 2004 13:49 pm, Ryan Jones wrote:
> may be way off base here though... maybe the cfmail tag is capable of
> handling thousands of addresses.
Certainly is, failing that there is the CFML that powers this very list :-)
> Standard, meaning that I am also assuming it does NOT featu
I have a web site that uses CFMX 6.1 and MS SQL for data handling.
This question is probably because I don't know as much about MS SQL as I should, so
bear with me.
Is it efficient to use cachedwithin on a query that only returns a row or two in the
recordset? Keep in mind that this query is ac
Actually, I have another concern: mass mailing.
We run a newsletter with over 3,000 subscribers. With PHP I sent out to this list on
a daily basis using phpmailer class sending via smtp. Works great.
I am afraid of using the cfmail tag for such mailings based on the fact that php's
mail() fun
Well Tom, at this point I guess my primary concern is this:
Say along the way I decide to do something with our site that is not directly handled
by one of the currently available cfml tags...
With PHP I am basicly open and free to code and make the language do just about
anything I want it to.
Well Tom, at this point I guess my primary concern is this:
Say along the way I decide to do something with our site that is not directly handled
by one of the currently available cfml tags...
With PHP I am basicly open and free to code and make the language do just about
anything I want it to.
On Wednesday 03 Nov 2004 13:30 pm, Ryan Jones wrote:
> Will Bluedragon Server really offer me everything PHP does?
Yes.
And more.
Did you have something specific in mind ?
> servers take up huge amounts of memory, and tend to crash often once the
> traffic starts increasing. Are these stories t
Hello there,
You could check here for some comparison info...
http://www.newatlanta.com/products/bluedragon/product_info/cfml_tag_support.cfm
http://www.newatlanta.com/products/bluedragon/product_info/features.cfm#FCMatrix
I believe that the free version does have certain license restrictions...
James Smith wrote:
>>> INSERT INTO barcodes (Barcode, ItemID) VALUES (0008811953928,17870)
>>>
>>> Could anyone tell me why the number 0004294967295 is
>>> causing an error
when the SQL statement doesn't even show it being used?
>>
>> Because it is 2^32. Instead of throwing an error MySQL
That is correct with our current implementation. In our computer labs, we strongly
instruct that students log completely out of the computer, in effect closing the
browser.
In administrative or faculty offices, users lock their computers when they walk away
and, being a small university, we h
Hello,
I posted the following to the Bluedragon mailing list over at New
Atlanta, but would also love to have the insight of the members of this
site.
*We are a small outfit that runs a PHP-based content site. I would
really like to move to cfml, as my job description includes webmaster,
web
On Wednesday 03 Nov 2004 12:23 pm, Thomas Chiverton wrote:
> less evil path ?
or, indeed, string ?
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44 (0)1749 834900
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 83490
> I'm not seeing why it happens, but you could simplify your code:
>
>
> INSERT INTO barcodes (Barcode, ItemID)
> SELECT Barcode, ItemID
> FROM stockitemdetails
>
Thanks, I was doing that originally but modified it so I could output some
values to screen for debug reasons.
--
Jay
~
> > INSERT INTO barcodes (Barcode, ItemID) VALUES (0008811953928,17870)
> >
> > Could anyone tell me why the number 0004294967295 is
> causing an error
> > when the SQL statement doesn't even show it being used?
>
> Because it is 2^32. Instead of throwing an error MySQL just
> rounds your valu
I'm not seeing why it happens, but you could simplify your code:
INSERT INTO barcodes (Barcode, ItemID)
SELECT Barcode, ItemID
FROM stockitemdetails
Pascal
> -Original Message-
> From: James Smith [mailto:[EMAIL PROTECTED]
> Sent: 03 November 2004 14:01
> To: CF-Talk
> Subject: O
James Smith wrote:
>
> However the error box lists the SQL statement in question as...
>
> INSERT INTO barcodes (Barcode, ItemID) VALUES (0008811953928,17870)
>
> Could anyone tell me why the number 0004294967295 is causing an error when
> the SQL statement doesn't even show it being used?
Beca
On Wednesday 03 Nov 2004 12:04 pm, Graham Pearson wrote:
> Branch target offset too large for short
Is the file very large ?
Can you test it with a less evil path ?
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44 (0)1749 834900
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Bus
I am looping over a result set to insert the results into a new table.
Select Query
SELECT Barcode, ItemID, Title
FROM stockitemdetails
ORDER BY Barcode
Insert Query
#Select2.ItemID# - #Select2.Barcode# -
#Select2.Title#
INSERT INTO barcodes (Barcode, Ite
The following will do what you need, although it is a little long-winded.
-- Prepare blank list
declare @list varchar(4000)
set @list = ''
-- Get SOFTWARE list for COMPANY
select @list = @list + ',' + SOFTWARE.SOFTWARE_NAME
fromSOFTWARE
inner join COMPANY
I am getting an error message which states:
Branch target offset too large for short
The first line of the stack trace reads
org.apache.bcel.generic.ClassGenException: Brnach target offset too large
for short
The error message will appear when I include the following line and if I
comment out
I don't think it is possible (but I don't use M$SQL that often, so I may
be mistaken). If it is for CF, use grouped output:
SELECT
C.COMPANY_ID,
C.COMPANY_NAME,
S.SOFTWARE_NAME
FROM
COMPANY C
COMPANY_SOFTWARES COS,
SOFTWARES S
WHERE
S.SOFTWARE_ID = CS.SOFTWARE_ID
Please please let me know the solution!!!
This is bringing my server to it's knees constantly, the JRun locks a
processor (Dual Xeons, so 1 of the 4 virtual chips and runs 25% of my system
process) and the VMem goes out of control. Really need to know what to do!
(can you hear the panic in my
Hi all,
I've 3 tables COMPANY, COMPANY_SOFTWARES, SOFWARES. COMPANY_SOFTWARES table holds the
data of the softwares used in the companies like;
COMPANY TABLE
COMPANY_ID COMPANY_NAME
--
10 My Company
COMPANY SOFTWARES TABLE
COMPANY_ID SOFTWARE_ID
--
This is driving me up the wall now... I have installed the hotfix for
6.1 and Verity/Linux:
http://www.macromedia.com/support/coldfusion/ts/documents/hotfix_verity_linux.htm
This made no difference.
I then installed the 6.1 updater and this has made no difference.
Any other ideas?
Andrew.
On
On Tuesday 02 Nov 2004 20:38 pm, Stan Winchester wrote:
> c:\cfusionmx\bin\cfencode f:\websites\[path]\*.cfm f:\websites\[path]\*.cfm
> /r
Path too long, or contains funny chars ?
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44 (0)1749 834900
email: [EMAIL PROTECTED]
BlueFinger Limited
Allan Cliff - CFUG Spain wrote:
>What if you live in
>Llanfairpwllgwyngyllgogerychwyrndrobwll-llantysiliogogogoch ?
>
>- Original Message -
>From: "dave" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Wednesday, November 03, 2004 10:05 AM
>Subject: Re: Forcing text to wrap
What if you live in
Llanfairpwllgwyngyllgogerychwyrndrobwll-llantysiliogogogoch ?
- Original Message -
From: "dave" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, November 03, 2004 10:05 AM
Subject: Re: Forcing text to wrap in table cell
> and the british have
>
and the british have
supercalifragilisticexpealidous
-- Original Message --
From: Thomas Chiverton <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Wed, 3 Nov 2004 08:46:43 +
>On Tuesday 02 Nov 2004 17:10 pm, [EMAIL PROTECTED] wrote:
>> Well if
On Tuesday 02 Nov 2004 17:10 pm, [EMAIL PROTECTED] wrote:
> Well if the longest word in the English language is 28 chars...
Not by a long shot.
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44 (0)1749 834900
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hol
Damn; I thought I had the best excuse on record with, "the ferret was
pregnant." Oh well.
-Original Message-
From: Mark Drew [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 3 November 2004 3:19
To: CF-Talk
Subject: Re: Where're PLUM
AS far as genuine excuses for lateness in a prokect...
98 matches
Mail list logo