I have an application where the user selects a record via a key
lookup, and then that record is displayed individually. From there I
want to be able to click a '' button to go to the previous record in
the sequence, or a '' to go to the next record, and continue to
select records via this
I don't really want to be notified about all the news from Macromedia
bloggers,
Well, seeing as that is all the extension does, I can see why you
un-installed it.
Yeah, I can see that too...I do more than CF (Flash and Dreamweaver) so the
extension is butter for me. I love it. I sometimes
experiences?
Jeff
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187100
Archives: http://www.houseoffusion.com/cf_lists
Okay, this is a PERFECT time to jump in here and pimp this thing...
http://www.markme.com/macromedianews/
Dude, if you're using Firefox, you HAVE to load this extension. It's frickin
unbelievable. It's single-handedly the coolest extension I've ever used. It
blinks when there's updated
google for CFX_JSpellCheck
-Jeff
[EMAIL PROTECTED] wrote:
I have an application where I need to spell check the contents of a text
box any cheap (or free) widgets out there?
sas
Scott A. Stewart,
Web Application Developer
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt
:
cfset queryPurchaseDate = #theMonth#/1/#theYear#
WHERE tblItemPurchase.itemPurchaseDate = '#queryPurchaseDate#'
OR
WHERE tblItemPurchase.itemPurchaseDate =
#createODBCDate(queryPurchaseDate)#
Good luck
-Jeff
Jason Smith wrote:
While I have been rebuilding a cold fusion application
on the columns available in each table. It would then run the query and
display the results.
I don't want to reinvent the wheel if one already exists.
Thanks!
Jeff
~|
Special thanks to the CF Community Suite Gold Sponsor
:
00123
01234
12345
000123456
Thanks,
Jeff
~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186332
Archives: http
column start and finsh in
the text file...
Hope I was more clear this time.. :)
Jeff
-Original Message-
From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED]
Sent: Monday, December 06, 2004 1:54 PM
To: CF-Talk
Subject: RE: Fixed Width variable question.
I think #numberFormat(num
That did the trick... Thanks!
Jeff
-Original Message-
From: Marlon Moyer [mailto:[EMAIL PROTECTED]
Sent: Monday, December 06, 2004 2:26 PM
To: CF-Talk
Subject: RE: Fixed Width variable question.
RJustify(string, length)
-Original Message-
From: Jeff Waris
it as a
number not a text field. Is there any way to preserve those leading 0's
inside a CFoutput??
Thanks..
Jeff
~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com
Message: http
Would a cfset giving the variable a more friendly name be considered
arithmatic and trim the 0's?
i.e.
cfset textnum = myquery.textnumber
Jeff
-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Friday, December 03, 2004 4:54 PM
To: CF-Talk
Subject: Re
I tried varchar, nvarchar and char in MS SQL. The DB all shows the 0's. The
cfoutput removes the 0's. I even tried the SET like below as well. Still
trims the 0's... I'm pulling my hair out...
Jeff
-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Friday
)#
Martin Parry
http://www.beetrootstreet.co.uk
-Original Message-
From: Jeff Waris [mailto:[EMAIL PROTECTED]
Sent: 03 December 2004 21:50
To: CF-Talk
Subject: Preserve Leading 0's question in cfoutput.
Here's an interesting one...
I have a text field in a database that contains
Looks like you deployed your WAR to the wrong directory.
The directory tree should be:
/Applications
/JRun4
/servers
/default
/SERVER-INF
/cfusion -- expand cfusion.war into here
/META-INF
/WEB-INF
If you can't successfully run the jar command chances are you're probably
not in the right directory, and if you aren't giving it path information
to the file the jar command probably just can't find the file you're
trying to unjar.
Okay, so if I'm in, say,
Just remember that to start at the root you have to have a / at the
beginning of your path, otherwise it'll start drilling down from your
current directory. So if your war file is in /Powerbook/Applications
(remember Unix is case-sensitive as well, so /PowerBook/Applications and
From what people on here say about CrystalTech, at least recently, they
don't seem to be all that great. Although, that argument may be more
against SQL server and some other services they offer, but regardless,
I've seen a lot of complaints on here lately about crystaltech.
John
Well,
On Dec 2, 2004, at 5:58 PM, Sean Corfield wrote:
By default you would have to manually start it, yes.
It's easy enough to create a Mac application using Apple Script that
will start CFMX for you and then you could add that to your Startup
Items if you wanted...
Links? Examples? I *totally*
On Dec 2, 2004, at 6:40 PM, Dave Watts wrote:
All you have to do is start the JRun server instance within which
you've
installed CFMX. CFMX isn't run as a separate process.
Awesome. Thanks Dave and Sean. I'm going thru that CFMX install process
right now and re-reading that install page on
On Dec 2, 2004, at 7:01 PM, Sean Corfield wrote:
On Thu, 2 Dec 2004 14:58:41 -0800, Sean Corfield
[EMAIL PROTECTED] wrote:
It's easy enough to create a Mac application using Apple Script that
will start CFMX for you and then you could add that to your Startup
Items if you wanted...
See my
I am running CF MX developer edition on my laptop. The problem I have is
that when I try to start CF without a network connection, CF will not
start.
Not a problem at home, but when I am on a plane, or a hotel, hard to do
some work... ;-)
Any way I can get CF MX to run without a network
Yeah, that one threw me too...2k server on a laptop? That's pretty awesome.
I have to say I'm running XP, not server.
-Original Message-
From: Jacob [mailto:[EMAIL PROTECTED]
Windows 2003 server under IIS 6.0. Running it as a service.
I've got Jrun up and running, and I've got the CFMX jar file, and I can
double click the jar file fine, it starts up the installer perfectly,
but I step thru three steps or so, and it says I can't install it
because I'm not root user.
Now, I'm an admin on this machine (my new powerbook) but
On Dec 1, 2004, at 7:14 PM, Matt Woodward wrote:
I've got Jrun up and running, and I've got the CFMX jar file, and I
can
double click the jar file fine, it starts up the installer perfectly,
but I step thru three steps or so, and it says I can't install it
because I'm not root user.
As
Well, this is what I'm reading:
http://www.macromedia.com/support/coldfusion/j2ee/cfmx-mac-
onjrunandtomcat.html
I'm on step 8, which is:
---
If you haven't done so already, open a Terminal window
(Applications/Utilities/Terminal), navigate to the cfusion directory,
and use the jar
On Dec 1, 2004, at 10:02 PM, Sean Corfield wrote:
First off, don't use the double-click approach - you really need to
use the command-line install.
Boy was I hoping I'd see you jump in here...I think this all boils down
to me not really understanding how the whole .jar/unix/command
standards.
--Jeff
On 11/18/2004 8:55 AM, Ryan Emerle wrote:
Has anyone had any success outsourcing large projects, or portions of
large projects, overseas or to temporary/freelance employees? Any
pros/cons to either? Any resources you can offer to someone exploring
his options?
Basically
Okay, so in my root, I want to set up the navigation include so the path is
cfinclude template=/includes/navigation.htm and on lower pages, the path
can be identical. Then, IN the navigation I'd like to be able to use img
src=/images/navigation/button1.jpg and have it work on pages both in the
help is greatly appreciated...
Thanks,
Jeff
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184471
Archives: http
Thanks Ben...
Quick and dirty did the trick
Jeff
-Original Message-
From: Ben Forta [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 16, 2004 4:23 PM
To: CF-Talk
Subject: RE: Oddball Query question...
Quick and dirty could be:
SELECT zip
FROM table1
WHERE NOT zip
We have a development database running on a little windowsXP Pro machine
that's hummed along quite nicely. Then today, we ran SP2 because we did a
monthly reboot and it reminded us. We didn't change any settings and when it
came back up we just cut off the Windows Firewall, the Virus checker,
This should help I think.
http://www.winnetmag.com/SQLServer/Article/ArticleID/42854/SQLServer_42854.html
Stephen
Boy howdythanks ever so much.
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
Do you have the Google toolbar installed? Or have you enabled the automagic
form fill-in for IE? These are two typical culprits.
Jeff Garza
[EMAIL PROTECTED]
Certified Macromedia ColdFusion Developer
-Original Message-
From: Gabriel Robichaud [mailto:[EMAIL PROTECTED]
Sent: Monday
Am I understanding MM's description of Blackstone correctly,
especially the new, Rich Forms?
Will Blackstone provide built-in Flash-Remoting type capability
without having to actually use Flash / Flash Remoting / ActionScript?
I'm still still using CF 4.5.2, because I haven't found any
as far as I know, you can discuss anything you saw at MAX if you didn't
have to
sign an NDA to see it. That said:
1. you might want to ask Macromedia for clarification
2. either way you should exercise good judgement and common sense before
discussing anything that you feel may be under
offer any pointers?
Thanks
-- Jeff Chastain
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183764
Archives: http
Heh, except the ON in the subquery should be a WHERE, as pointed out by DRE
SELECT A.item, A.date, (select MIN(date) FROM yourTable B WHERE b.itemID =
A.itemID) AS orderDate
FROM yourTable A
ORDER BY orderDate, A.item, A.date
-Jeff
DRE wrote:
Thanks to Jeff, the issue is resolved
If you can wait until early 2005, then ColdFusion will be able to do this
natively...
http://www.macromedia.com/software/coldfusion/blackstone/features/reporting/
Jeff Garza
-Original Message-
From: Duncan Loxton [mailto:[EMAIL PROTECTED]
Sent: Monday, November 08, 2004 6:33 PM
To: CF
Tom,
The lock didn't work. Still gave me the append error.
Mosh,
Your way worked well doing smaller queries but when doing a real large query
where the output file would be like 30+ megs it hung, what I may do is write
the file out in smaller more manageable chunks...
Jeff
-Original
, 03295
etc.
Can my query be modified to allow me to change my fieldtype to text?
Any suggestions would be most welcome!
-Jeff
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
:24 -0400, Jeff Fongemie
[EMAIL PROTECTED] wrote:
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183557
Archives: http
the file not allowing to be
appended to. Has anyone else run across this. Is there a timeout setting
anywhere that I might be able to set... This is frustrating because this
code worked just fine on CF5? Anyone with any ideas?
Thanks...
Jeff
make your query like this:
SELECT item, date, MIN(date) AS orderDate
FROM yourtable
WHERE itemID = date_itemID
GROUP BY item, date
ORDER BY orderDate DESC, item, date
-jc
DRE wrote:
Nobody has any thoughts?
On Thu, 4 Nov 2004 08:14:30 -0800, DRE [EMAIL PROTECTED] wrote:
Hi,
I have a
sorry that should probably be ASC, not DESC, if you want it to go low-high
-jc
Jeff Congdon wrote:
make your query like this:
SELECT item, date, MIN(date) AS orderDate
FROM yourtable
WHERE itemID = date_itemID
GROUP BY item, date
ORDER BY orderDate DESC, item, date
-jc
DRE wrote:
Nobody
then would it not, within the request, always define request.thisDSN
exactly the same way?
Any ideas? TIA,
-Jeff
~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http
have they fixed the problem where if you write a cookie, and then
cflocate, the cookie never gets written? If not, that's probably your
problem. Try using a meta-refresh instead of a cflocation.
-jc
Phillip Perry wrote:
Hi,
I'm using the cflogout tag but I don't think the session was
they could direct me to? I have been
browsing Macromedia's site, but any specifics would be appreciated.
Thanks
-- Jeff Chastain
~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF
community
=#attributes.DataSource# name=Dest
SELECT *
FROM mytable
WHERE '(zip
cfqueryparam cfsqltype=CF_SQL_DECIMAL
value=#variables.LatN# ) '
/cfquery
Anyone see a problem??
Jeff
~|
Purchase from House of Fusion, a Macromedia
=en
Jeff Garza
-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 26, 2004 5:34 AM
To: CF-Talk
Subject: RE: OT: Local MS SQL Server
From: Rodger [mailto:[EMAIL PROTECTED]
This brings up another question:
Is there a way to install my copy of MS
It's actually a compliance issue for an audit. Annoying for users I would
wholeheartedly agree. I've actually seen something like what I am asking
working on another website, although whatever the technique being used ONLY
works with IE. I can easily go back using firefox..
Jeff
-Original
No one with any ideas?? I'm still pretty much stumped over this one.
-Original Message-
From: Jeff Waris [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 20, 2004 2:17 PM
To: CF-Talk
Subject: Cffile issue...
An error occurred when performing a file operation Append on file
to the problem?
-Thanks
Jeff
~|
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
Verify that the query works without using CFQUERYPARAM
It does work without the CFQUERYPARAM. Why is that???
-Jeff
~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF
community.
http
of
zipcodes from my list.
I must be missing something simple!
-Jeff
~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=34
Message
Further,
It's the or in my loop. It always ends up at the end of my SQL statement with
nothing after it so I get an error.
?
~|
The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in
the
the back button. Am I on
the right track looking at the CGI referrer variable...
Thanks.
Jeff
~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF
community.
http://www.houseoffusion.com/banners
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
You don't need one in the current directory, you just need to make sure
the one in the previous directory has that cfapplication tag. If
there's no app.cfm in the current diretory, CF will automatically look
in ../, ../.../, etc until it finds one. Generally you want 1 app.cfm,
and it should
to the originally requested page.
HTH,
Jeff Garza
Manager, Phoenix ColdFusion User Group
[EMAIL PROTECTED]
_
From: Phillip Perry [mailto:[EMAIL PROTECTED]
Sent: Sunday, October 17, 2004 3:11 PM
To: CF-Talk
Subject: HTTP_REFERER
Thanks for answering my last question. Too many issues kept coming up so
Worked like a charm. The only issue was leading 0's for dates/times like
01/09/2004 and I was able to get around that.. Oh, I did comment that the
code was only viable til the year and that some other means of checking
will be needed for Y10K.. :)
Jeff
-Original Message-
From
in the right direction from any _javascript_ gurus would be
appreciated...
Thanks.
Jeff
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
this or
am I missing something? Is there some technique that allows me to use both
CFform error checking and my own, or is this just a Monday brain lag while
most people have off??
Thanks,
Jeff
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations
use the onsubmit()
_javascript_ function...
Thanks,
Jeff
-Original Message-
From: Jeff Waris [mailto:[EMAIL PROTECTED]
Sent: Monday, October 11, 2004 10:36 AM
To: CF-Talk
Subject: IS this an MX issue???
I just started having this problem, and I am not sure why. Normally we do
I convert that to a stored procedure? I am about to give up!
Thanks for you help, Jeff
Notice.This message is intended only for use by the person or
entity to which it is addressed.Because it may contain confidential
information intended solely for the addressee, you are notified that
any
CFMX 6.0 did not have variables scope in CFCs so all CFCs tended to
use this scope to store data. Which is bad because that's a public
scope (so all your data is exposed).
CFMX 6.1 introduced variables scope - which behaves much like
protected data in Java - and the best practice these days
Pointers were the single most problematic aspect of C and C++ for many
developers and were the primary source of application unreliability
(memory leaks, reusing freed memory etc). Implementing a safe virtual
machine that supports unmanaged pointers is extremely hard - they're
just not worth
I do not think a bunch of students is competent to judge if something can
be good or not.
Haha, well we'll certainly have to disagree one that point. I'm of the
opinion that people *learning* the language from the ground up in college
are *especially* competent to judge if something can be
Discovering CFCs by Hal Helms (bear in mind it was written for CFMX
6.0 so it uses this scope)
Okay, you got me. I gotta ask. What's with the this scope and CFMX 6.0?
Can you explain further this caveat you added?
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User
There already is a listserv for components called cfcdev and can be found at
www.cfczone.org.
Jeff Garza
_
From: Chunshen (Don) Li [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 06, 2004 8:32 PM
To: CF-Talk
Subject: OT: request to add a new forum - cfc
Chief,
Strangly, I got the cfc
JSpellCheck works on MX, i've used it on 6 and 6.1.It looks like all
my files are in c:\CFX_JSpellCheck, and then the cfx is pointed to that.
-Jeff
Mike Kear wrote:
We updgraded one of our dev servers this week, and everything seems to
have gone smoothly, nary an issue.Nice.
Except one CFX
)
VALUES (@TeamNumber, @DistrictID, @TeamDesc)
SET @newTeamID = (SELECT Scope_Identity())
SET NOCOUNT OFF
HTH,
Jeff Garza
_
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: Saturday, October 02, 2004 5:23 PM
To: CF-Talk
Subject: cfstored proc returning value
Anyone see whats wrong
...
Anyone have any luck with this?
WSDL URL:
http://www.nws.noaa.gov/forecasts/xml/DWMLgen/wsdl/ndfdXML.wsdl
NWS Information Page:
http://nws.noaa.gov/forecasts/xml/
Thanks,
Jeff Garza
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
I definately agree with Jim here... take a look at Blue Dragon.I've used it with several smaller clients that were hosting some internal sites and didn't want to pay for a full version of CF.Works very well.
Cheers,
Jeff Garza
- Original Message -
From: Jim Davis
To: CF-Talk
Sent
of credit I highly suggest that you not go this route.
--Jeff
On 9/23/2004 11:31 AM, Kristopher Pilles wrote:
Call up and get a new CC # then Paypal can't charge you.
KP
-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 23, 2004 11:28
randomly for quite some time now.The box has
been restarted several times and nothing appears to effect this error.I
have several other Windows 2003 boxes, loaded and configured exactly the
same that are not having this issue.
Any suggestions?
-- Jeff
[Todays Threads]
[This Message
into effect.
Thanks,
-- Jeff
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Sorry, this is a really off topic .NET box, no CFMX.The ISAPI filters
installed are Netegrity's SiteMinder Web Agent and ASP.NET_1.1.4322.947.
I was just hoping somebody familiar with server support might have some
clue.
Thanks
-- Jeff
_
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent
... each running the same software and versions.
Thanks for the help.
-- Jeff
_
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 23, 2004 3:46 PM
To: CF-Talk
Subject: RE: Windows 2003 Error
Sorry, this is a really off topic .NET box, no CFMX.The
ISAPI filters
? I've found some free code and a few cheap or free custom tags out there. Looks like none work with Access database.
Can anyone recommend from experience one of the available custom tags available?
Thanks for any info on this.
-Jeff
[Todays Threads]
[This Message]
[Subscription]
[Fast
?
Thanks
-- Jeff
-
This mail sent through IMP: http://horde.org/imp/
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Thanks guys.I was trying to make this a lot more complicated.
Thanks again,
-- Jeff
Quoting Jochem van Dieten [EMAIL PROTECTED]:
Jeff Chastain wrote:
I have a case where I need to be able to programmatically create a new
Windows
folder (cfdirectory), but then be able to alter
-- Jeff
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
?
Thanks for your help.
-- Jeff
_
From: Samuel Neff [mailto:[EMAIL PROTECTED]
Sent: Friday, September 17, 2004 8:13 AM
To: CF-Talk
Subject: RE: Java Import - CF
Import in Java doesn't instatiate anything, all it does is make a reference
used by the compiler to use shorthand access to packages so
this class, I am just not sure that
is the best answer.
Thanks
-- Jeff
Quoting Jeff Chastain [EMAIL PROTECTED]:
Okay, maybe with some more context, you can help me out with this then.I
have the following JSP code that I am attempting to convert to CF.
% page language=java import
-- Jeff
Quoting Kola Oyedeji [EMAIL PROTECTED]:
If you have the package available as a jar you should be able to
reference it in the administrator under the classpath settings.
Kola
-Original Message-
From: Jeff Chastain [mailto:[EMAIL PROTECTED]
Sent: 17 September 2004 16:07
I'm getting the following error:
Error Occurred While Processing Request
The system has attempted to use an undefined value, which usually indicates
a programming error, either in your code or some system code.
Null Pointers are another name for undefined values.
And I have NO IDEA where it's
y to do this?It would be ideal, as it is in JSP, to
have all of the objects already created and ready to use without having to
perform N cfobject calls at the top of a template.
Thanks
- Jeff
Quoting Kola Oyedeji [EMAIL PROTECTED]:
If you have the package available as a jar yo
That is what I was afraid of, but it was worth asking.Thanks for your help.
-- Jeff
Quoting Kola Oyedeji [EMAIL PROTECTED]:
Jeff AFAIK there is no way to do this in CF, you're stuck with using
create object.
KOla
-Original Message-
From: Jeff Chastain [mailto:[EMAIL PROTECTED
I've narrowed it down to a cfloginuser tag.
I'm querying a table to return * (fname, lname, ID, email, Type_ID_fk) after
passing in form variables.
This is working. I can dump the query and see it all. (Jeff, Small, 1,
[EMAIL PROTECTED], 1)
Type_ID_fk is a foreign key to a table. I only
I suspect that you may have some name mismatch, and that the value of
Login.OwnerTypeID_fk is not one, because of the mismatch. In the first
paragraph, you say that the fields are named fname, lname, id, email, and
Type_ID_fk.
Sorry, I was trimming the names for email. They're named the EXACT
- Original Message -
From: Jeff Small [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, September 17, 2004 3:22 PM
Subject: Re: Okay, here's EXACTLY what's going on...Re: Completely baffled
...
I suspect that you may have some name mismatch, and that the value
That's odd. What is the datatype of the field within the database?
It's an int. regular ol' foreign key, nothing fancy.
Honestly, I've never used anything but strings for the ROLES attribute,
although I can see why you might want to do that.
Oh, I know! I know! I mean, I figured it would
Well, I would strongly recommend that you put roles into a separate table.
However, within your code, you might want to use the role name rather than
some surrogate key value solely for documentation purposes. For example,
it's clear to the reader of the code what this does:
cfif
I think this would do it, though I didn't test it.
SELECT a.id2,
a.name,
(
SELECT COUNT(b.id)
FROM tablename b
WHERE b.id1 = a.id2
) as idCount
FROM tablename a
ORDER BY a.id2
HTH.
--Jeff
On 9/16/2004 12:47 PM, Andy J wrote:
I've got a SQL query which for love or money i cant seem
Woops...I had a typo I think.The where clause should have been...
WHERE b.id1 = a.id1
On 9/16/2004 4:40 PM, Jeff Langevin wrote:
I think this would do it, though I didn't test it.
SELECT a.id2,
a.name,
(
SELECT COUNT(b.id)
FROM tablename b
WHERE b.id1 = a.id2
) as idCount
FROM
Ack, id1 and id2 was screwing me up.This works.
SELECT a.id2,
a.name,
(
SELECT COUNT(b.id1)
FROM tablename b
WHERE a.id2 = b.id1
) as idCount
FROM tablename a
ORDER BY a.id2
On 9/16/2004 4:44 PM, Jeff Langevin wrote:
Woops...I had a typo I think.The where clause should have been...
WHERE
parameters
being passed?Is this a Java thing and if so, how is this handled within
CF?
I am really lost here and my Java knowledge is so limited that I may really
be missing something very simple here.Anybody have any suggestions?
Thanks
-- Jeff
[Todays Threads]
[This Message]
[Subscriptio
' variable is, which is not all that unexpected.So,
are there any Java types out there that could help with this aspect of
translation?
Thanks
-- Jeff
_
From: Jeff Chastain [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 16, 2004 7:20 PM
To: CF-Talk
Subject: OT: CFMX Java API
I have
Okay, ignore this whole thread ... I have it figured out.
Thanks
-- Jeff
_
From: Jeff Chastain [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 16, 2004 7:54 PM
To: CF-Talk
Subject: RE: CFMX Java API
Okay, I have answered my first question.The first error message was being
generated
901 - 1000 of 2945 matches
Mail list logo