Hi John - from your last posting, no - I did a fresh install of 2000.
I'm going to try full texting on another clients cluster which is the
same as mine (2xDell PowerEdge 2850 a Dell PowerVault 220S) and let's
see if FT then works. I've a hunch it won't tho!
Will advise
Martin
-Original
On 10/3/05, Jim Davis [EMAIL PROTECTED] wrote:
I've got one... I'm not sure if it's better tho'.
Right now it's sort of embedded in a larger library (the full library does
WDDX, JSON, XML-RPC and YODEL) - I could split it out for you if you like.
It may be faster, it may not but it
Hi
Does anybody on the list know if its it possible to populate a PDF
Document/Form on the fly with Coldfusion variables?
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
On Thursday 29 September 2005 20:03, David Reeves wrote:
This idea will be used for our private company website, alot of the users
are bookmarking pages but we want them to use the main page as the a portal
(rather than lots of portals).
How will encrypting the page name help ?
My browser
On Sunday 02 October 2005 03:15, Bobby Hartsfield wrote:
([[:alnum:]_\.\-]+@([[:alnum:]_\.\-]+\.)+[[:alpha:]]{2,4})
Tsk.
What about the .museum TLD ?
--
Tom Chiverton
Advanced ColdFusion Programmer
~|
Discover CFTicket -
Using cfdocument in CFMX7 you can create your own PDF's on the fly from CF code.
On 10/3/05, Ian Vaughan [EMAIL PROTECTED] wrote:
Hi
Does anybody on the list know if its it possible to populate a PDF
Document/Form on the fly with Coldfusion variables?
I wonder if your same issue would happen on a server-class machine that
is really built for sharing files? Are you sure there is no other
process (editor, etc) that may have had a lock on the file even before
uploading it?
M!ke
-Original Message-
From: Will Tomlinson [mailto:[EMAIL
I keep getting a Nullpoint error when I am using cfqueryparam to insert or
update a timestamp in Oracle and the value that is passed to it is blank. I
have installed this hotfix
http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_19108 , but the
issue persists. The only way I could
Hi Pete
Yeah thanks I know about the CFDocument tag, what I was trying to find
out was if you could populate an already constructed PDF Document with
Coldfusion.
-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]
Sent: 03 October 2005 12:23
To: CF-Talk
Subject: Re:
OK,
We are having an odd problem where we are sending out around 44K emails in
batches of 500 every 40 seconds - when it gets to say around 8000 or so (the
batching loops through and refreshes the page each time) it comes back with
a generic error which I believe, according to the runtime/logs is
Anyone using/used iText with CF6? Can it read a PDF (ideally form fields)
which I can then pre-populate and write a new PDF out?
N
This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant,
Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business,
Registered in England,
I believe this could help you
http://www.google.com/search?sourceid=navclientie=UTF-8rls=GGLG,GGLG:2005-39,GGLG:enq=itext+coldfusion
Bob Everland
~|
Logware (www.logware.us): a new and convenient web-based time tracking
Ive had issues like this in the past. I am a bit less aggressive,
setting a CFSCHEDULEd task to fire off 500 every 3 minutes. How large
is your mail/spool folder growing in the CF install area? I found that
at about 8000-1 cfmail files in the spool folder, things degrade.
-Original
I have a developer that is using the native iText that is part of CFMX
directly as CFDocument doesn't do what he needs.
But he is getting the following error.
Helvetica not found as resource. (The *.afm files must exist as resources in
the package com.lowagie.text.pdf.fonts)
I have checked in
Robertson-Ravo, Neil (RX) wrote:
Anyone using/used iText with CF6? Can it read a PDF (ideally form fields)
which I can then pre-populate and write a new PDF out?
used. i don't recall ever doing that myself (the form field bits) but
bruno has java examples that are usually pretty easy to
Are you using the null queryparam value, so that when the value you're
passing is blank, you pass an explicit null?
On 10/3/05, Robert Everland III [EMAIL PROTECTED] wrote:
I keep getting a Nullpoint error when I am using cfqueryparam to insert or
update a timestamp in Oracle and the value
Russ,
I am probably a bad SQL coder, but almost all the code that I had to do with
searching structured databases had about 3 times the amount of CF code
interspersed with the SQL queries. Most of the time, my customers want a
single search box which can take all kinds of searches. When they enter
What do you mean by null queryparam value? If I do Null=yes in my queryparam
then it always passes a NULL value.
Bob
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and
Do it like this:
cfqueryparam cfsqltype=cf_sql_timestamp value=#mytimevalue#
null=#yesnoformat(NOT isdate(mytimevalue))#
On 10/3/05, Robert Everland III [EMAIL PROTECTED] wrote:
What do you mean by null queryparam value? If I do Null=yes in my
queryparam then it always passes a NULL value.
I always give the options in my form
find all words
find exact phrase
And if this is checked, I loop over the search phrase using SPACE as
delimiter and create a dynamic WHERE clause for each word.
E.G
cfif isdefined('form.allwords')
cfloop list=#form.searchcriteria# delimiter= index=word
AND
My development machine has:
Win XP SP 2
CFMX 7 developer's edition
SQL Server 2000 SP 3a
I was always get the following error while trying to connect to
datasources via cfadmin.
[Macromedia][SQL Server JDBC Driver]Error establishing socket.
Connection refused: connect
After Googling a bit
That's ok, I dont know anyone at a museum ; )
That might be a tough one though h...
(2,6) ?
..:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]
Sent: Monday, October 03, 2005 7:25 AM
To:
Yes, you can populate a PDF with variables. What you need to do is go
into the PDF (will need full Acrobat version) and create the form,
name the fields, etc if you haven't done already. Then you will need
to export the form data (FDF). Taking the format of the FDF file, you
use ColdFusion
Hi,
I usually prefer CFScript over CF TAGs since it's more concise.
However sometimes TAGs seem better at that, e.g.:
TAGs version:
cfinvoke component=#myCFC# method=myMethod
cfinvokeargument name=myRequiredParam value=#form.myRequiredParam#
cfif
When using the date field in a flash form, you can us ethe MASK attribute to
specify the date format, but this is not applied to the initial value.
Can you add some actionscript to the BIND attribute to do this?
E.g.
cfinput type=DateField name=expires
bind={getServer.currentItem.expires}
if you are the one writing the code in the methods, saying what is
optional, just make a cfparam of the optionals with the default set in
the method. Then pass all arguments in.
On 10/3/05, wolf2k5 [EMAIL PROTECTED] wrote:
Hi,
I usually prefer CFScript over CF TAGs since it's more concise.
Don't forget you can use argumentCollection to dynamically pass
attributes to a CFC method or UDF. That would let you use cfscript if
you want to. argumentCollection for CFCs/UDFs works the same as
attributeCollection for custom tags.
On 10/3/05, wolf2k5 [EMAIL PROTECTED] wrote:
Hi,
I usually
Does anyone know where I can find a list of Reserved Words for CFMX 7?
is TOP 1 an issue for CFMX 7?
I am getting the error that a reserved word was used in my select
statement
Thanks!
~|
Find out how CFTicket can increase
make sure the user it runs under does have permissions to access the
file/folder.
Russ
-Original Message-
From: Jolly Green Giant [mailto:[EMAIL PROTECTED]
Sent: 03 October 2005 16:11
To: Snake
Subject: Re: [CF-Dev] Java File I/O problem with MX 6.1
Not exactly sure, but if it's not
OK,
After a few oddities on installation (CFX_PDF does indeed just use iText) -
I am trying to fathom out a way I can read a PDF in (which has form fields)
- any help here mucho appreciato.
Anyone a guru on CF/iText?
TIA
Neil
This e-mail is from Reed Exhibitions (Oriel House, 26 The
I am running it locally and it works fine with using:
SELECT TOP 1 ..blah blah..
But on another server it errors out
For reserved word.
Why the difference?
Both are Windows based OS as well as identical code.
Same setup, same directory structure.
-Original Message-
From: Adkins,
Could it be SQL Server (assuming this is what you're using) as I had a
similar problem in that on one server code worked fine but on another it
didn't (when using a stored proc to update a text field) and the reason
was that one had SQL Server SP4 and the other didn't
-Original Message-
I own dreamweaver MX2004, and have the sleeve with the serial number,
but have misplaced the disk. When I search to download it, all I can
find is the new version, not the old one. I can't find the old version
on the Macromedia site, just patches and updates for it. Can someone
provide me with a
Well the client is using MS Access. So I setup my local for the same
thing.
Mine works, his does not.
-Original Message-
From: Dave Ashworth [mailto:[EMAIL PROTECTED]
Sent: Monday, October 03, 2005 11:28 AM
To: CF-Talk
Subject: RE: CFMX 7 Reserve Words?
Could it be SQL Server
show your code, might be something else...
tw
On 10/3/05, Adkins, Randy [EMAIL PROTECTED] wrote:
I am running it locally and it works fine with using:
SELECT TOP 1 ..blah blah..
But on another server it errors out
For reserved word.
Why the difference?
Both are Windows based OS as well
This is the exact same code on my machines, running CFMX 7 and the ODBC
is
Microsoft Access.
CFQUERY NAME=qSystemSettings DATASOURCE=#REQUEST.DSN#
USERNAME=#REQUEST.DSN_USERNAME# PASSWORD=#REQUEST.DSN_PASSWORD#
SELECT
TOP 1
ApplicationTitle,
On 10/3/05, Raymond Camden [EMAIL PROTECTED] wrote:
Don't forget you can use argumentCollection to dynamically pass
attributes to a CFC method or UDF. That would let you use cfscript if
you want to. argumentCollection for CFCs/UDFs works the same as
attributeCollection for custom tags.
I'm not dumb, I'm not dumb, I'm not dumb.
If I repeat it often enough, it has to be true, right?
Anyway...why won't this query return more than 1 record?
Select FG.Group_ID, FG.Group_Name,
C.Client_ID,
C.Client_First_Name, C.Client_Middle_Name,
Oops! Jim Davis proved me wrong:
However there's a good on-screen keyboard built into Windows
already. It's usually here: %SystemRoot%\system32\osk.exe
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
That's itthe world is over...Dave was wrong!! ;-)
Bryan Stevenson
http://www.school-for-champions.com/coldfusion/cftopdf.htm
--- On Mon 10/03, Ian Vaughan [EMAIL PROTECTED] wrote:
From: Ian Vaughan [mailto: [EMAIL PROTECTED]
To: cf-talk@houseoffusion.com
Date: Mon, 3 Oct 2005 13:25:30 +0100
Subject: RE: Populating a PDF document with CF variables
Is your clientID really of some other type than numeric (you've got it
in quotes) ? You should also be using cfquerypapram. (snicker)
Rick Faircloth wrote:
I'm not dumb, I'm not dumb, I'm not dumb.
If I repeat it often enough, it has to be true, right?
Anyway...why won't this query
how are you determining the # of records returned?
On 10/3/05, Rick Faircloth [EMAIL PROTECTED] wrote:
I'm not dumb, I'm not dumb, I'm not dumb.
If I repeat it often enough, it has to be true, right?
Anyway...why won't this query return more than 1 record?
Select FG.Group_ID,
Yeah thanks I know about the CFDocument tag, what I was trying to find
out was if you could populate an already constructed PDF Document with
Coldfusion.
Look into iText (which is behind CFDOCUMENT) found on SourceForge. I'm
pretty sure you'd be able to do what you want.
Bryan Stevenson
Anyone using/used iText with CF6? Can it read a PDF (ideally form fields)
which I can then pre-populate and write a new PDF out?
N
Yep...should be able toput on your Java hat and get creative ;-)
Bryan Stevenson B.Comm.
VP Director of E-Commerce Development
Electric Edge Systems Group
i have a function that takes a ticket_id as an argument. the function
runs a query and returns it. i have found that
if the query runs like this:
INNER JOIN lkp_Ticket_Types ON tbl_Tickets.Type_ID = lkp_Ticket_Types.Type_ID
INNER JOIN lkp_Ticket_Status ON
Well how many rows do you expect back?
It has to be down to your WHERE clause. Have a look in the tables and see
whether more rows fit the criteria you're using.
Ade
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: 03 October 2005 16:47
To: CF-Talk
Subject: Why
The version of the JET drivers might be an issue.
Russ
-Original Message-
From: Adkins, Randy [mailto:[EMAIL PROTECTED]
Sent: 03 October 2005 16:36
To: CF-Talk
Subject: RE: CFMX 7 Reserve Words?
Well the client is using MS Access. So I setup my local for the same thing.
Mine works,
Snake...
I'm not sure if you have full access to all that iText does (with the
version built-in to CF). You MAY have to install another iText JAR file and
use that version. There are some issues with doing that as CF ignores the
new iText JAR file unless you tweak something (just can't
Are you saying that:
cfqueryparam cfsqltype=cf_sql_integer value=#Ticket_ID# /
is either passing in a blank value or the right value depending on the SQL
statement above it?
Ade
-Original Message-
From: Captain John Michael Permetheis IV [mailto:[EMAIL PROTECTED]
Sent: 03 October 2005
Isn't that only on XP/2K3?
Kevin
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: October 3, 2005 9:48 AM
To: CF-Talk
Subject: Re: CF Web Based Keyboard
Oops! Jim Davis proved me wrong:
However there's a good on-screen keyboard built into Windows
already.
My first instinct is to say... cause thats whats in the table. Try
doing a select FG.*, C.*
That should show the differences between the two rows and possibly
shed some light on the situation.
Which db is this?
~|
Logware
Hey guys,
I have been asked to find a sms webservice (free or pay, doesn't
matter). We just need to be able to send sms messages, not receive.
We need someone that is reliable for sure, and it is only going to be
used here in the united states. Does anyone have any recomendations,
or any
yes. if the joins are in the query the value is empty. if i remove the
joins the value is valid.
On 10/3/05, Adrian Lynch [EMAIL PROTECTED] wrote:
Are you saying that:
cfqueryparam cfsqltype=cf_sql_integer value=#Ticket_ID# /
is either passing in a blank value or the right value depending on
This is the exact same code on my machines, running CFMX 7 and the ODBC
is
Microsoft Access.
CFQUERY NAME=qSystemSettings DATASOURCE=#REQUEST.DSN#
USERNAME=#REQUEST.DSN_USERNAME# PASSWORD=#REQUEST.DSN_PASSWORD#
SELECT
TOP 1
ApplicationTitle,
Just to be clear, when you say 'value', you do mean in the cfqueryparam? Not
the result from the query?
Ade
-Original Message-
From: Captain John Michael Permetheis IV [mailto:[EMAIL PROTECTED]
Sent: 03 October 2005 17:07
To: CF-Talk
Subject: Re: missing argument in a function
yes. if
if i remove the join on the lkp_ticket_types table then the variable
is passed through correctly.
works in cfmx 6.1 dies in cfmx 7.1
On 10/3/05, Adrian Lynch [EMAIL PROTECTED] wrote:
Just to be clear, when you say 'value', you do mean in the cfqueryparam? Not
the result from the query?
Ade
correct.. the value that is passed into the where clause.
On 10/3/05, Adrian Lynch [EMAIL PROTECTED] wrote:
Just to be clear, when you say 'value', you do mean in the cfqueryparam? Not
the result from the query?
Ade
-Original Message-
From: Captain John Michael Permetheis IV
Yep...Client_ID (with the underscore for readability) is an integer...
And...I use cfqueryparam on all my inserts and updates, but what's
the rationale for using them on selects? Because of URL manipulation?
Rick
-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED]
I run the production server here and work on the site straight
on the server and just look at the output...there should be
4 records returned...they're in the database...
Rick
-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: Monday, October 03, 2005 11:51 AM
http://www.forta.com/blog/index.cfm?mode=eentry=1533
--- Ben
-Original Message-
From: Ryan Guill [mailto:[EMAIL PROTECTED]
Sent: Monday, October 03, 2005 12:04 PM
To: CF-Talk
Subject: sms webservice
Hey guys,
I have been asked to find a sms webservice (free or pay, doesn't matter).
Strange! Have you outputted ticket_id before and after to check it's what
you expect it to be?
Ade
-Original Message-
From: Captain John Michael Permetheis IV [mailto:[EMAIL PROTECTED]
Sent: 03 October 2005 17:27
To: CF-Talk
Subject: Re: missing argument in a function
correct.. the
It should return 4 records, which are the only ones in the
database / table that match...it's a database that I'm developing
as I develop the site...
I've been over the data at the db, and over the code multiple
times and must just be missing something...
It's returning only the first record
Tried the FG.*, C.*...no go...same results...
-Original Message-
From: Anthony Prato [mailto:[EMAIL PROTECTED]
Sent: Monday, October 03, 2005 12:02 PM
To: CF-Talk
Subject: Re: Why doesn't this query return more than 1 record?
My first instinct is to say... cause thats whats in
you're looking at records returned thru CF? thru the database itself
(via something like enterprise manager or query analyzer)?
if the former, using queryname.recordcount? cfoutput
query=queryname? cfloop query=queryname?
On 10/3/05, Rick Faircloth [EMAIL PROTECTED] wrote:
I run the
yes. an output before the query and after it returns a valid value.
this is driving me nuts
On 10/3/05, Adrian Lynch [EMAIL PROTECTED] wrote:
Strange! Have you outputted ticket_id before and after to check it's what
you expect it to be?
Ade
-Original Message-
From: Captain John
Now don't get mad when I suggest this, but how do you know it's only
returning 1 row?
Ade
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: 03 October 2005 17:34
To: CF-Talk
Subject: RE: Why doesn't this query return more than 1 record?
It should return 4 records,
Hi guys,
I have 5 questions in my MS-SQL database and when i want to display
them in an online quiz I loop them through like so:
cfform
cfoutput query=blah
cfinput name=#questionID# value=answerID
/cfoutput
/cfform
When these get submitted i look through my DB again to pull the
Hi,
If you script the table and data, and post it, we could all play.
Ian
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: 03 October 2005 17:45
To: CF-Talk
Subject: RE: Why doesn't this query return more than 1 record?
Now don't get mad when I suggest
I'd be suprised if it didn't throw a wobbly if you use numbers for your form
names. Best not to.
To answer the dynamic form names bit. Use array notation.
cfloop from=1 to=10 index=i
#FORM[myForm_ i]#
/cfloop
Ade
-Original Message-
From: Saturday (Stuart Kidd) [mailto:[EMAIL
Could you post the whole funtion and the calling code? Might be something
else.
Ade
-Original Message-
From: Captain John Michael Permetheis IV [mailto:[EMAIL PROTECTED]
Sent: 03 October 2005 17:40
To: CF-Talk
Subject: Re: missing argument in a function
yes. an output before the query
Select FG.Group_ID, FG.Group_Name,
C.Client_ID,
C.Client_First_Name, C.Client_Middle_Name,
C.Client_Last_Name
from Family_Groups FG, Clients C
where FG.Group_ID = C.Client_Family_ID
and C.Client_ID = '#URL.Client_ID#'
It's returning only the first record each time...and that's the
Stuart...
form fields should never be plain numbers. Just tack on the string answer
to your form field and you'll be good:
this: form.answer4
instead of this: form.4
When you're comparing the answers, you could loop over how many questions
there are instead of setting that part manually. A
Thanks ben,
I knew you had something like this, but couldn't find it.
Thanks again,
On 10/3/05, Ben Forta [EMAIL PROTECTED] wrote:
http://www.forta.com/blog/index.cfm?mode=eentry=1533
--- Ben
-Original Message-
From: Ryan Guill [mailto:[EMAIL PROTECTED]
Sent: Monday, October 03,
-Original Message-
From: wolf2k5 [mailto:[EMAIL PROTECTED]
Sent: Monday, October 03, 2005 3:57 AM
To: CF-Talk
Subject: Re: [SOT] Better WDDX JavaScript serializer/deserializer
functions?
On 10/3/05, Jim Davis [EMAIL PROTECTED] wrote:
I've got one... I'm not sure if it's better
How many records are in each table and what do they look like (just the
columns in question). The only way I'd see you getting more than one
record back is if there are several different records in the clients
table with the same client_id. I'm guessing the tables look similar to this:
We've got a website that generates labels with a bar code. Currently
the printing is handled with an activeX control. The user clicks a
print button, javascript uses the object to print based on fields
filled out by the user. I can generate the labels server side with
Async JS and CF then display
Yes, I'm looking at the results returned on the website I'm building...
however, using Navicat for the query, still only 1 record is returned.
My logic must just be wrong in using the C.Client_ID = '#URL.Client_ID#'.
There's only 1 record where that is true...
Maybe not enough caffeine...
Rick
Bryan Stevenson wrote:
I'm not sure if you have full access to all that iText does (with the
version built-in to CF). You MAY have to install another iText JAR file and
no, in this case the iText distributed w/cf does what they want. i
tested the code w/merrimack cf7. it worked fine. maybe
Oh, I'm so mad! ;o)
I'm returning the results to the website and I've also run
the query on Navicat...
Rick
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: Monday, October 03, 2005 12:45 PM
To: CF-Talk
Subject: RE: Why doesn't this query return more than 1
Thought you might be doing something like:
cfoutput
#qYourQuery.SomeRow#
/cfoutput
and only seeing one row, namely the first one.
Have you solved it?
Ade
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: 03 October 2005 18:10
To: CF-Talk
Subject: RE: Why doesn't
Does any one know what is cause of this error CFMX 7 is throwing, null
null The error occurred on line -1? After seeing this error, CF needs
to be restarted in order for CF to function.
I remember have this problem with CFMX 6 first shipped. After a few
tweaks and a few hot fixes the problem
I have reverted to using MAXROWS = 1 because I only want ONE record.
At all times there should never be more than 1 record within the table.
This was added to make sure it only returned 1 record.
As a personal choice, I am against SELECT *
Yes, TOP 1 does do something, by returning only 1
Did you try sending an email to the mobile device? I don't know about
others, but with my Sprint, I can receive email messages and they don't
count as SMS messages.
(They wouldn't count anyway since I have unlimited Sprint PCS Vision.)
M!ke
-Original Message-
From: Ryan Guill
I would rather have the method(s) hanlde the logic than the excution
code pass optional arguments.
myCFC.myMethod(form);
Let the method handle all the checking and call other methods if needed.
Joe
On 10/3/05, wolf2k5 [EMAIL PROTECTED] wrote:
On 10/3/05, Raymond Camden [EMAIL PROTECTED]
Ok...
Clients Table
--
Client_ID
Client_Family_ID (FK for Family_Groups Table)
etc...
Family_Groups Table
--
Group_ID
There are 4 records in the Clients table...all have
the same Client_Family_ID, which is 1...
There is 1 record in the Family_Groups
No...I'm looping the query on the website...
I think I've gone insane...this should be so simple.
Rick
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]
Sent: Monday, October 03, 2005 1:23 PM
To: CF-Talk
Subject: RE: Why doesn't this query return more than 1 record?
Well, you haven't posted any data snapshot out here yet, but I'm betting
you're getting what you should be getting back. Basically, what you're
saying is this:
Select FG.Group_ID, FG.Group_Name, C.Client_ID, C.Client_First_Name,
C.Client_Middle_Name, C.Client_Last_Name
From Clients C inner
There you go now.
Select * from client where client_family_id = (
select client_family_id from client where client_id = #url.clientID#
)
would be one way.
Rick Faircloth wrote:
Ok...
Clients Table
--
Client_ID
Client_Family_ID (FK for Family_Groups Table)
etc...
Depending on your join, missing data can cause a row you expect to see not
be part of the query result set.
Mark
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Monday, October 03, 2005 1:45 PM
To: CF-Talk
Subject: RE: Why doesn't this query return more than 1
Sorry, that last one was bad:
Select c.*, fg.*
From clients c inner join family_groups fg on
c.client_family_id = fg.group_id
Where c.family_group_id = (
select family_group_id from clients where client_id = #url.client_id#
)
Rick Faircloth wrote:
Ok...
Clients Table
If Client_ID is your PK, and you're restricting it in the AND clause, that's
enough to limit it to one.
Ade
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: 03 October 2005 18:44
To: CF-Talk
Subject: RE: Why doesn't this query return more than 1 record?
Ok...
Depending on your join type, missing data can cause a row you expect to see
not
be part of the query result set.
Mark
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and
Our oracle databases are case sensitive, make sure the values are EXACT
matches on case and no trailing spaces, etc. When in doubt you can trim
and upper to ensure exact matches.
Thanks,
CC
x56927
This is
To answer your question about cfqueryparam...from what I heard last year
at MAX, using cfqueryparam not only protects you from url/form
manipulation, but it also increases performance. When the query is first
passed, a query map is laid out so the DB knows what it's going to
have to do. When you
You were on the right track, Ken...just got the variables mixed up,
which was my fault, really...my FK in clients was not named well
according to the PK in the family_groups table.
Anyway...it did require an inner join as you have below (yuck, I hate
joins...), because I'm joining data from two
Interesting...enhanced protection and performance...I shall use it with
all my select variables, henceforth!
Thanks!
Rick
-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: Monday, October 03, 2005 2:31 PM
To: CF-Talk
Subject: SPAM-LOW: RE: Why doesn't this
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
What Version of Coldfusion are you running. I have been sending SMS
Messages to Cell Phones and Alphanumeric Pagers with Coldfusion 5 for
the past 4 years. I can create an API that you could access my SMS
Gateway.
Ryan Guill wrote:
Hey guys,
I
I am using cf 7 and soon to be 7.0.1
On 10/3/05, Graham Pearson [EMAIL PROTECTED] wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
What Version of Coldfusion are you running. I have been sending SMS
Messages to Cell Phones and Alphanumeric Pagers with Coldfusion 5 for
the past 4 years.
I say keep it simple I do something like this for a dating site
where I ask icebreaker questions
Set up a table with questions and answers like this:
QuestionID, QuestionText , QuestionIndex (for sorting, if you want)
AnswerID, QuestionID, AnswerText, isCorrect , AnswerIndex (for sorting,
Yeah, problem is my Java hat is more of a Java headband...Paul Hastings has
helped me decipher the Java side of things - I am no on my way with this...
Quality.
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: 03 October 2005 16:53
To: CF-Talk
Subject: Re:
1 - 100 of 133 matches
Mail list logo
