There's not a function, but you can add them up as you loop over the query:
SUM of Assonum is #sumAssonum#
>
> select a.Dept, c.Assonum
> .
> group by a.Dept, c.Assonum
>
>
> I need to get the SUM of c.Assonum, but I can't do sum(c.Assonum ) in
>
select a.Dept, c.Assonum
.
group by a.Dept, c.Assonum
I need to get the SUM of c.Assonum, but I can't do sum(c.Assonum ) in
the sql (cfquery).
What is the way to get the SUM of c.Assonum with cf function?
Please advise.
Than
day, September 07, 2008 8:14 PM
> To: CF-Talk
> Subject: Problem with Empty Fields when using cfquery and load data infile
>
> Hi, all...
>
> Hope everyone's having a nice weekend.
>
> Can anyone tell me how to modify this query so that
> I don't get an erro
Hi, all...
Hope everyone's having a nice weekend.
Can anyone tell me how to modify this query so that
I don't get an error when a row doesn't contain data
for all columns?
Here's the query, using MySQL 5 load data infile syntax:
load data infile 'e:/active_photos.txt'
into table hml
>> Actually, I'm gonna pick on you again Dave and challenge
>> this. (I'm hoping to add to my wall)
>>
>> If a someone is using MySQL ...
>
> Well, the original poster was asking about the current attack, which
> specifically targets MS SQL Server.
>
That might be true, but he didn't say that. He
> Do you mind if I blog about that part where you said "Yeah,
> your right about that " That's got to be good for my
> cf_streetCred (ha).
I don't mind, no.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruct
> Actually, I'm gonna pick on you again Dave and challenge
> this. (I'm hoping to add to my wall)
>
> If a someone is using MySQL ...
Well, the original poster was asking about the current attack, which
specifically targets MS SQL Server.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.co
> As Mark pointed out, if you did have numeric inputs in your CFQUERY tag,
> those would still be vulnerable. If not, though, the rest of my statement
> still stands.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
Actually, I'm gonna pick on you again
Sent: Tuesday, July 22, 2008 8:58 PM
Subject: RE: cfquery and cfstoredproc
> Dave,
>
> Do you mind if I blog about that part where you said "Yeah, your right
> about
> that " That's got to be good for my cf_streetCred (ha).
>
> -mk
>
Dave,
Do you mind if I blog about that part where you said "Yeah, your right about
that " That's got to be good for my cf_streetCred (ha).
-mk
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 22, 2008 7:14 PM
To: CF-Talk
Subject:
ized query that is being called by the attack.
>
> I recommend you examine your codebase to find unparameterized
> queries. I found this tool, mentioned here by others, to be
> very helpful for this:
> http://qpscanner.riaforge.org/
As Mark pointed out, if you did have numeric inp
> I never disagree with you (usually a fools errand)
Ha! I wish.
> but I want a clarification. I think you might mean that this
> particular use is safe because CF will escape the single quotes.
> But the code below is vulnerable in exactly the same as a CFQUERY.
>
> As a te
Dave,
I never disagree with you (usually a fools errand) but I want a
clarification. I think you might mean that this particular use is safe
because CF will escape the single quotes. But the code below is vulnerable
in exactly the same as a CFQUERY.
As a test I created an SP
> So I'm hearing that it should be fine??
>
> Somehow their database columns values were appended the
> following string
> : ">http://1.verynx.cn/w.js";>
> What else could have caused this? Like you said the
> parameters are in single quotes and the data type is varchar
> so it must have a
So I'm hearing that it should be fine??
Somehow their database columns values were appended the following string
: ">http://1.verynx.cn/w.js";>
> What about a semi-colon?
>
> Storedproc '#var1#','#var2#' ; *other code*
>
> Would the CFQUERY not allow this additional code to run?
It wouldn't allow any of the values after the stored procedure call
"storedproc" to run as code, because t
Dave,
What about a semi-colon?
Storedproc '#var1#','#var2#' ; *other code*
Would the CFQUERY not allow this additional code to run?
-Mark
Mark A. Kruger, CFG, MCSE
(402) 408-3733 ext 105
www.cfwebtools.com
www.coldfusionmuse.com
www.necfug.com
-Original Message--
> > i have been asked to look at a possible sql injection attack.
> > as I look through the code I see stored procs being called
> > by using cfquery like:
> >
> > cfquery name="asdf" datasource="asdf"
> >
> > storedproc &#x
ssage -
From: "Gaulin, Mark" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Tuesday, July 22, 2008 4:34 PM
Subject: RE: cfquery and cfstoredproc
> Hi Brad
> Thanks for the links, those are interesting articles.
>
~~~
Thanks Adrian. That's cool. however, it is not useful DURING the execution
of the SQL though correct?
~Brad
- Original Message -
From: "Adrian Lynch" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Tuesday, July 22, 2008 3:51 PM
Subject: RE: cfquery and
makes a ton of web sites vulnerable. (And yes, this
does provide an example of when back ticks are insufficient, so now I
know.)
Thanks for the info.
Mark
-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 22, 2008 4:46 PM
To: CF-Talk
Subject: Re
place.
" & LOCAL.sqlString & "">
SELECT *
FROM myTable
WHERE myColumn =
AND myOtherColumn =
#executedSQL(r)#
Adrian
www.adrianlynch.co.uk
-Original Message-
From: Brad Wood [mailto:[EMAIL PROTECTED]
Sent: 22 July 2008 21:46
To: C
]
Sent: Tuesday, July 22, 2008 3:46 PM
To: CF-Talk
Subject: Re: cfquery and cfstoredproc
(Depending
> on the version of CF, cfqueryparam disables cachedwithin caching.
This is true, but it doesn't prevent you from baking your own caching
mechanism as many have done.
In
> all ver
(Depending
> on the version of CF, cfqueryparam disables cachedwithin caching.
This is true, but it doesn't prevent you from baking your own caching
mechanism as many have done.
In
> all versions of CF, cfqueryparam effectively makes Sql Profiling with
> SQL Server useless and there is no worka
As you have heard, cfquery is vulnerable to sql injection attacks, so
you have to do something.
You will hear that cfqueryparam is the best practice for protecting
against sql injection attacks, and there is certainly truth to that.
However, there are also costs associated with cfqueryparam
: cfquery and cfstoredproc
i have been asked to look at a possible sql injection attack. as I look
through the code I see stored procs being called by using cfquery like:
cfquery name="asdf" datasource="asdf"
storedproc '#var1#', '#var2#'
cf
i have been asked to look at a possible sql injection attack. as I look
through the code I see stored procs being called by using cfquery like:
cfquery name="asdf" datasource="asdf"
storedproc '#var1#', '#var2#'
cfquery
I've
lol, yes it would be if this was a format in the database, in fact i would need
to be sacked as well :)
- its something built up through coldfusion and i'm storing all the data in a
query so i can run various query of query select statements to filter out
various information - which is much qui
is normalizing the database an option? :)
On Fri, Jun 20, 2008 at 11:52 AM, Richard White <[EMAIL PROTECTED]> wrote:
> hi matt this is a good idea, shame about the leading and trailing commas
> though this would prove to be a pain, until i can find another solution i
> will do the loop and use t
hi matt this is a good idea, shame about the leading and trailing commas though
this would prove to be a pain, until i can find another solution i will do the
loop and use the list find though thanks for your help
>I had something like this once upon a time. I think I had to
>manipulate the da
I had something like this once upon a time. I think I had to
manipulate the data so that I had leading and trailing commas in the
list in table. This was so I wouldn't get false matches, such as 6
being found in this list: 1,16,8. If you can do that, this might work.
select col1, col2
from mytabl
Hi
i have a query in coldfusion and one of the columns has a list of data: for
example
col1 col2
-
1 0,1,2,3
2 1,6,7
i want to run a query where i pass it a list and it returns any row that has
any item in that list
for example i want to run a query that s
On Thursday 19 Jun 2008, Randy Johnson - CFConcepts wrote:
> Would putting result="qryResults" in my tags cause any
> performance hits
Yes, because CF will check the result type at runtime every single request.
This is almost certainly such a small hit you'll not care though.
> Any thoughts?
Hello,
Would putting result="qryResults" in my tags cause any
performance hits or excess memory usage?
I was thinking of creating a script that could be used on our production
server to show some debugging information since we do not have debugging
turned on.
I was thinking it would work so
oh i see, i didnt think they had fixed it yet, ok thanks ill look into the
config - thanks azadi
>iirc, this is not a cfquery doing, but rather the mysql jdbc driver's.
>there is some setting for the connector-j and/or in mysql server config
>file that changes this behaviour, but
iirc, this is not a cfquery doing, but rather the mysql jdbc driver's.
there is some setting for the connector-j and/or in mysql server config
file that changes this behaviour, but you will have to look it up in the
mysql reference manual - i do not remember the details of this setting...
hi dave. yeah we just found that it is a previously submitted bug for mysql
jconnector which we use in dreamweaver.
to get around it we just changed those columns to smallint(1)
thanks
>> after lots of problematic select statements we have realised
>
>I don't know if this is a problem specifi
> after lots of problematic select statements we have realised
> that if a db column has a type of tinyint(1) and that column
> in the mysql db has '2' stored in it, then running a cfquery
> will only return 0 or 1
>
> so we realise that cfquery must convert t
hi,
after lots of problematic select statements we have realised that if a db
column has a type of tinyint(1) and that column in the mysql db has '2' stored
in it, then running a cfquery will only return 0 or 1
so we realise that cfquery must convert tinyint(1) columns to boolean
w
If you don't care about the case where first and last names differ, I'm not
sure why you're including them in the query, but you can try this:
SELECT atty_id,
MAX(first_name) AS first_name,
MAX(last_name) AS last_name,
MIN(COALESCE(atty_rank, )) AS atty_rank
FROM get_attypa
> > DISTINCT works across all the columns, so if first names
> > are different you'll get two rows back for a given atty_id.
>
> OK - how to force only *one* unique ID per returned results?
You can't. How would it show the additional results?
You can, however, use the GROUP attribute of the CFO
If you're trying to avoid doing a group (loop) from the cfoutput tag
to create that atty_rank, in your view, you could create a table
variable (with SQL Server), and populate with unique atty info and
rank list (your coalesce column), then return from that table
variable. Probably faster on the SQL
Adrian Lynch wrote:
> DISTINCT works across all the columns, so if first names are different
> you'll get two rows back for a given atty_id.
OK - how to force only *one* unique ID per returned results?
~|
Adobe® ColdFusion® 8 so
DISTINCT works across all the columns, so if first names are different
you'll get two rows back for a given atty_id.
Adrian
-Original Message-
From: Les Mizzell [mailto:[EMAIL PROTECTED]
Sent: 14 May 2008 18:57
To: CF-Talk
Subject: Distinct on just ONE column in a CFQUERY
The bel
name
>
> RANK
> --
> rank.atty_id (tied to atty.atty_id, but marked NOT to display)
> rank.atty_rank
>
>
>
> Ideas?
>
> Is there a way to define this in the VIEW instead of in the CFQUERY tag?
~~
'y'
ORDER BY atty_rank, last_name, first_name
ATTY - (Main Table)
--
atty.atty_id
atty.first_name
atty.last_name
RANK
--
rank.atty_id (tied to atty.atty_id, but marked NOT to display)
rank.atty_rank
Ideas?
Is there a way to define this in the VIEW instead o
processed separately from the rest of the batch.
CREATE PROCEDURE x...
GO
GRANT EXECUTE ON x
GO
I couldn't get "GO" to work in a cfquery on MX 7.0.2 SQL Server 2005. I
think it may be because it is a Microsoft thing...
Apparently using a semi-colon ";" after
ueries
> using application variables.
>
> If the user/pass is defined externally, can connections in the same
> pool be
> re-used?
> If the user/pass is added to the DSN, the user/pass removed from the
> external text file and the cfquery strings still contain the
> Appli
Yeah sorry about that... forgot the ( and )
..:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com
-Original Message-
From: Richard White [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 22, 2008 10:48 AM
To: CF-Talk
Subject: Re: cfquery with array
ah i
Glad you got it sorted. Gmail delivered your message saying you'd fixed it
as I hit send.
On Tue, Apr 22, 2008 at 10:03 AM, Richard White <[EMAIL PROTECTED]> wrote:
> yes thanks morgan :)
>
> >Does the IN clause need to be enclosed in parens?:
> >
> >SELECT subjectID, firstName, lastName from sub
yes thanks morgan :)
>Does the IN clause need to be enclosed in parens?:
>
>SELECT subjectID, firstName, lastName from subjects where subjectID
>in (cfsqltype="cf_sql_integer">)
~|
Adobe® ColdFusion® 8 software 8 is the most im
Only if you want it to work ;)
He fixed that himself.. congrats.
On Tue, Apr 22, 2008 at 9:55 AM, morgan l <[EMAIL PROTECTED]> wrote:
> Does the IN clause need to be enclosed in parens?:
>
>
> SELECT subjectID, firstName, lastName from subjects where subjectID
> in ( cfsqltype="cf_sql_integer"
Does the IN clause need to be enclosed in parens?:
SELECT subjectID, firstName, lastName from subjects where subjectID
in ()
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Tr
ah i managed to fix it by putting brackets around the cfqueryparam then it
works fine :)
thanks again for all your help, this is really useful
richard
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic relea
Hi Dominic
fantastic link
thanks, i really need to learn more sql!!!
thanks again
richard
>Hi Richard,
>
>This should help:
>
>http://dev.mysql.com/doc/refman/5.0/en/any-in-some-subqueries.html
>
>Basically, you can do like:
>
>SELECT * FROM tableX
>WHERE tableXId IN (#listOfIds#)
>
>With cfqu
hi
i have tried using the example specified but it is throwing an error, this is
the example i am trying to use:
SELECT subjectID, firstName, lastName from subjects where subjectID in
;
and the error i am getting is:
You have an error in your SQL syntax; check the manual that corr
thanks for all your replies, there is so many places i could use this. i have
always been doing a lot of processing with cf (loops, formatting, etc...) and
after recently looking into why the performance issues are not so great i am
starting to see that mysql and cfquery can
be used for most
You could use the ArrayToList function..
That will convert your array to a list and then just select from table
where id in
something like that
On Tue, Apr 22, 2008 at 8:24 AM, Richard White <[EMAIL PROTECTED]> wrote:
> hi
>
> i have an array of subjectId's. i have a table in my database
http://cf4em.com
-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 22, 2008 9:27 AM
To: CF-Talk
Subject: RE: cfquery with array
Richard, try using listtoarray to create a new variable and then a SQL "IN"
statement on the newly created
Hi Richard,
This should help:
http://dev.mysql.com/doc/refman/5.0/en/any-in-some-subqueries.html
Basically, you can do like:
SELECT * FROM tableX
WHERE tableXId IN (#listOfIds#)
With cfqueryparam that looks like
You'll also need ArrayToList().
HTH
Dominic
On 22/04/2008, Richard White <[
Sorry, I meant arraytolist. ;)
-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 22, 2008 9:27 AM
To: CF-Talk
Subject: RE: cfquery with array
Richard, try using listtoarray to create a new variable and then a SQL "IN"
statement on the new
Richard, try using listtoarray to create a new variable and then a SQL "IN"
statement on the newly created list.
~Che
-Original Message-
From: Richard White [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 22, 2008 9:24 AM
To: CF-Talk
Subject: cfquery with array
hi
i have a
hi
i have an array of subjectId's. i have a table in my database called subjects
with the primary key set as subjectID
i have 2 other columns called first name and last name.
i want to be able to get the first names and last names only for the subjects
ids stored in my array
is there a way in
e and lastName
> >
> > then i want to query the database to ensure that each firstName and
>
> > lastName combination exists in the database, if not then i want it
> to
> > return me a list of those that dont.
> >
> > i have achieved this through a loop but
return me a list of those that dont.
>
> i have achieved this through a loop but i am thinking there must be a
> quicker way of doing this directly in a cfquery, as it is taking too
> long when there are thousand
variables.
> >
> > If the user/pass is defined externally, can connections in
> > the same pool be re-used?
>
> Yes.
>
> > If the user/pass is added to the DSN, the user/pass removed
> > from the external text file and the cfquery strings still
> > contain the
d are passed to cfqueries
> using application variables.
>
> If the user/pass is defined externally, can connections in
> the same pool be re-used?
Yes.
> If the user/pass is added to the DSN, the user/pass removed
> from the external text file and the cfquery strings
using application variables.
If the user/pass is defined externally, can connections in the same pool be
re-used?
If the user/pass is added to the DSN, the user/pass removed from the
external text file and the cfquery strings still contain the Application
variables for them, what happens to the
be a quicker
way of doing this directly in a cfquery, as it is taking too long when there
are thousands of names it has to check
thanks
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get
Do you have the query?
-Original Message-
From: Richard White [mailto:[EMAIL PROTECTED]
Sent: Monday, April 21, 2008 10:53 AM
To: CF-Talk
Subject: cfquery and mysql help
Hi,
im sure there must be a better way of doing the following code, and much
quicker.
i have a query which is
Hi,
im sure there must be a better way of doing the following code, and much
quicker.
i have a query which is built up from data in excel - so i used a excel2query
function on it
i want to check through the database to see if any of the items within my query
exist in the database. so i am loo
> > would work. Of course, it doesn't. I think I'm running up against that
> > whole set vs. literal string issue again, but if any of you could take
> > a look and point me in the right direction, I'd greatly appreciate it.
> >
> > In eclipse, I'm doin
running up against that
> whole set vs. literal string issue again, but if any of you could take
> a look and point me in the right direction, I'd greatly appreciate it.
>
> In eclipse, I'm doing a search using a regex pattern across my entire
> codebase. I want to retu
reciate it.
In eclipse, I'm doing a search using a regex pattern across my entire
codebase. I want to return any instances of inline CFQUERY where there
is a CF variables referenced that is NOT contained in a CFQUERYPARAM.
I'm willing to run a couple of searches if necessary.
]*>[^=]*=\s*#[^
Q) to merge multiple recordsets after querying
>each one, individually.
>
>* Query one datasource, then loop over each record and update another
>datasource.
>
>m!ke
>
>-Original Message-
>From: Ben Conner [mailto:[EMAIL PROTECTED]
>Sent: Saturday, March 08, 2008
then loop over each record and update another
datasource.
m!ke
-Original Message-
From: Ben Conner [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 08, 2008 6:09 PM
To: CF-Talk
Subject: using CFQuery across multiple DSNs
Hi,
Is it possible to get a query (select/update/delete) to work wh
Hi,
Is it possible to get a query (select/update/delete) to work when
pulling data from more than one dsn? What would the syntax be? I have
one database/dsn I need to update records from another one. Never done
that before.
Thanks...!
--Ben
+---+
+ Ben
//
You want it to match what? everything from the opening < on the opening
cfquery tag to the closing > on the closing cfquery tag?
I'd probably go with:
/]*>.*?/gi
--
s. isaac dealey ^ new epoch
isn't it time for a change?
ph: 503.236.3691
http://onTa
is to write a regex for everything between
and
I had what i though would work, but I don't think the fckeditor config
file can use the full without causing an error on the
parent CFM page. This is what I tried:
FCKConfig.ProtectedSource.Add( // ) ; //
Everything between C
Does anybody know how to prevent FCKEDITOR from surrounding CFQUERY
code from a loaded cfm page with tags. This apparently is
exposing the code to the WYSIWYG edito and not treating it as source
code.
I need to be able to use FCKEditor with CFM pages that have CF code.
Any suggestions
> ENTERED AN EARLIER POST ON THIS SAME QUERY PROBLEM. ORIGINALLY IT WAS
> A SYNTAX PROBLEM. HOWEVER, NOW I AM GETTING THE FOLLOWING ERROR. THIS
> IS A SIMPLE LOGIN APPLICATION.
>
>
> Error Executing Database Query. [Macromedia][SequeLink JDBC
> Driver][ODBC Socket][Microsoft][ODBC Microsoft A
On Jan 23, 2008 10:42 AM, Nick Ross <[EMAIL PROTECTED]> wrote:
> ENTERED AN EARLIER POST ON THIS SAME QUERY PROBLEM. ORIGINALLY IT WAS A
> SYNTAX PROBLEM. HOWEVER, NOW I AM GETTING THE FOLLOWING ERROR. THIS IS A
> SIMPLE LOGIN APPLICATION.
really? 3 times now? and still with the caps lock?
--
ENTERED AN EARLIER POST ON THIS SAME QUERY PROBLEM. ORIGINALLY IT WAS A SYNTAX
PROBLEM. HOWEVER, NOW I AM GETTING THE FOLLOWING ERROR. THIS IS A SIMPLE LOGIN
APPLICATION.
Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC
Socket][Microsoft][ODBC Microsoft Access Driver]
On 1/23/08, Nick Ross <[EMAIL PROTECTED]> wrote:
> ENTERED AN EARLIER POST ON THIS SAME QUERY PROBLEM. ORIGINALLY IT WAS A
> SYNTAX PROBLEM. HOWEVER, NOW I AM GETTING THE FOLLOWING ERROR. THIS IS A
> SIMPLE LOGIN APPLICATION.
>
> Error Executing Database Query. [Macromedia][SequeLink JDBC Driver]
age-
> From: Les Mizzell [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, December 19, 2007 12:44 PM
> To: CF-Talk
> Subject: cfquery "order by" question
>
> i have an adin form that allows a client to specify the sort
> order of a returned collection of results. E
Coalesce kicks hiney. It's so useful.
-Original Message-
From: Les Mizzell [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 19, 2007 12:15 PM
To: CF-Talk
Subject: Re: cfquery "order by" question
> Use something like
> ORDER BY COALESCE(sortORD,) ASC, #g
Coalesce simply returns the first non-null value. Like MS SQL's isnull,
but it can take more arguments.
~Brad
-Original Message-
From: Les Mizzell [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 19, 2007 12:15 PM
To: CF-Talk
Subject: Re: cfquery "order by" question
> Use something like
> ORDER BY COALESCE(sortORD,) ASC, #getPAGE.sortMETH#
Ooo - that works.
Actually, I'll admit to having never seen "coalesce" before.
Thanks very much! That eliminates something far more convoluted!
Les
~~~
> I *think* I understand what you are asking.
> What is the sortORD column value for the other 12 records you want to
> come after the first three?
Currently null, though I could set it to default to something else.
I suppose "" might be a good idea actually, then there would be
a valu
> How do I get my numberic sort fields to take priority and come up first
> without maybe having TWO queries defined and two output blocks?
Use something like
ORDER BY COALESCE(sortORD,) ASC, #getPAGE.sortMETH#
~|
Adobe® Cold
like above should work.
~Brad
-Original Message-
From: Les Mizzell [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 19, 2007 11:44 AM
To: CF-Talk
Subject: cfquery "order by" question
i have an adin form that allows a client to specify the sort order of a
returned collec
i have an adin form that allows a client to specify the sort order of a
returned collection of results. Easy enough, but I've run into a slight
snag...
Here's the basic query...
Select name, amount, date
FROM COLLECTIONS
WHERE collection_id = '#url.colID#'
ORDER BY sortORD ASC
: Tuesday, October 23, 2007 4:01 PM
To: CF-Talk
Subject: Re: get the value of the drop down and pass it to the cfquery
> What do you have the submit button doing? Does it actually submit to
>
> the server, or just forward to the next tab?
>
> For CF to process information, you have t
t; tab
>> erik tom wrote:
>>> I need to be able get the value from the drop down and pass ethis
>> value to cfquery function which located on the second tab of the form.
>> Once i selected the drop
information
> passed, what are you naming your dropdown, and how are you referencing
>
> it in the query?
>
> --Ben Doom
>
The button supposed to submit so I can set the session variable to the next tab
> erik tom wrote:
> > I need to be able get the value from the
dropdown, and how are you referencing
it in the query?
--Ben Doom
erik tom wrote:
> I need to be able get the value from the drop down and pass ethis value to
> cfquery function which located on the second tab of the form. Once i selected
> the drop down item i clicked on the submit b
I need to be able get the value from the drop down and pass ethis value to
cfquery function which located on the second tab of the form. Once i selected
the drop down item i clicked on the submit button and going to the second tab
but nothing getting passed to the query. Help
If you look at the CF8 docs on CFQUERY you'll see a full description of what
the result structure contains. It doesn't break any existing code, but it
does add several useful bits of information that you can use.
On 10/15/07, Chris Long <[EMAIL PROTECTED]> wrote:
>
> Has a
I am pretty sure that this is a thing that CFDump does directly. You
do not have to now do #queryname.resultset.columnname#"...
J.J.
On 10/15/07, Chris Long <[EMAIL PROTECTED]> wrote:
> Has anyone else encountered this? We switched to CF8 this week and I noticed
> that when I do a dump of the
Chris Long wrote:
> that when I do a dump of the query variable, it now displays a struct with
> the query results as a member of the struct named resultset.
it's actually documented.
> old code still works. But I'm a little concerned and I want to make sure
> there aren't any potential code iss
301 - 400 of 1483 matches
Mail list logo
