Thanks to everyone for your help! These work perfectly.
Mark
[This E-mail scanned for viruses by Declude EVA]
~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclic
---
From: Mark Leder [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 13, 2006 8:18 AM
To: CF-Talk
Subject: SQL Concetenation inside CFQuery
I'm using this cfquery to pull records from an MSSQL 2005 db:
SELECT U.userID, U.userFirstName, U.userMiddleName, U.userLastName,
(U.userFirstName + SP
tomer Care
Railo Technologies GmbH
[EMAIL PROTECTED]
www.railo.ch
Join our Mailing List / Treten Sie unserer Mailingliste bei:
deutsch: http://de.groups.yahoo.com/group/railo/
english: http://groups.yahoo.com/group/railo_talk/
Mark Leder schrieb:
> I'm using this cfquery to pull records
Mark Leder wrote:
> I'm using this cfquery to pull records from an MSSQL 2005 db:
>
> SELECT U.userID, U.userFirstName, U.userMiddleName, U.userLastName,
> (U.userFirstName + SPACE(1) + U.userMiddleName + SPACE(1) + U.userLastName)
> AS assignedName
>FROM a_Table
&g
I'm using this cfquery to pull records from an MSSQL 2005 db:
SELECT U.userID, U.userFirstName, U.userMiddleName, U.userLastName,
(U.userFirstName + SPACE(1) + U.userMiddleName + SPACE(1) + U.userLastName)
AS assignedName
FROM a_Table
It works great, with one exception. In some cases
Thanks to both of you now it is outputing what i want and in different
sections.
>1) Refer to the query using array notation:
>
>Title: #NewsUpdates.Title[1]# Content:
>#NewsUpdates.Content[1]#
>
>Title: #NewsUpdates.Title[2]# Content:
>#NewsUpdates.Content[2]#
>
>etc
>
>OR
>
>2) If you don
1) Refer to the query using array notation:
Title: #NewsUpdates.Title[1]# Content:
#NewsUpdates.Content[1]#
Title: #NewsUpdates.Title[2]# Content:
#NewsUpdates.Content[2]#
etc
OR
2) If you don't know which row is which, use QoQ to select the one you
need at each point in the template.
On 11/3
lto:[EMAIL PROTECTED]
Sent: 30 November 2006 08:47
To: CF-Talk
Subject: help on cfquery and cfoutput
help on this please the code is
the above query gives me three records.. the problem is how to display each
record in three different sections of the template... is there a way to
insert a pa
help on this please the code is
the above query gives me three records.. the problem is how to display each
record in three different sections of the template... is there a way to insert
a parameter like pubcontentid=3703 inside the creating each for
every record?
thanks for any help...
~
if recw_assign_month is a date/time field - wouldn't sorting on this
field straight up work fine? Seems like you're jumping through
unnecessary hoops...
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitt
All,
I have a table that contains several items and most of these items are assigned
a month and the current year using #CreateODBCDateTime(CreateDate(Year( Now()
), form.month_assigned, Day( Now() )))#
in my insert or update sql statements. Some items will not be assigned a date.
recw_assign_
ValueList would be the simplest means of doing what you need.
SELECT id
FROM tableName
ORDER BY id
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 29, 2006 8:08 AM
To: CF-Talk
Subject: CFQUERY: comma delimited list of id values
All
coldfusion.developer wrote:
>
> I'm trying to figure out how best to pass a list of comma delimited id
> (numeric) values to another query.
>
>
> select *
> from dbo.tbl_recipe_monthly_winner
> where (month(recw_assign_month )= 01) AND (year(recw_assign_month )=
> 2006)
>
SELECT
*,
R
[EMAIL PROTECTED] wrote:
> All,
>
> I'm trying to figure out how best to pass a list of comma delimited id
> (numeric) values to
> another query. I'm having trouble with getting the list of id values to not
> have a "," (comma)
> after the last value in the output. Any help would be very appre
dbo.tbl_recipe_monthly_winner
where (month(recw_assign_month )= 01) AND (year(recw_assign_month )=
2006)
)
Adrian
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 29 November 2006 14:08
To: CF-Talk
Subject: CFQUERY: comma delimited list of id values
All,
I'm t
: CFQUERY: comma delimited list of id values
All,
I'm trying to figure out how best to pass a list of comma delimited id
(numeric) values to
another query. I'm having trouble with getting the list of id values to not
have a "," (comma)
after the last value in the output. An
Try this:
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 29, 2006 7:38 PM
To: CF-Talk
Subject: CFQUERY: comma delimited list of id values
All,
I'm trying to figure out how best to pass a list of comma delimited id
(numeric) valu
All,
I'm trying to figure out how best to pass a list of comma delimited id
(numeric) values to
another query. I'm having trouble with getting the list of id values to not
have a "," (comma)
after the last value in the output. Any help would be very appreciated.
Should I be using a cfloop ins
or
http://www.sswug.org/
- Original Message -
From: "Kris Jones" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Thursday, November 02, 2006 6:27 AM
Subject: Re: CFQUERY - Aggregate Function
> How about tek-tips.com?
>
>> Can any recommend a free f
How about tek-tips.com?
> Can any recommend a free forum like houseoffusion for SQL coding issues.
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, d
ent: Thursday, November 02, 2006 1:17 AM
Subject: CFQUERY - Aggregate Function
> Can any recommend a free forum like houseoffusion for SQL coding issues.
> I've used sqlmag.com but they forums have little traffic.
>
>>From the 2nd query, I'm trying to extract only record
> From the 2nd query, I'm trying to extract only records from
> 2nd query where the average of avg(ratingvalue) >=4 and I'm
> not sure how do do this.
HAVING AVG(ratingvalue) >= 4
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-
Can any recommend a free forum like houseoffusion for SQL coding issues.
I've used sqlmag.com but they forums have little traffic.
>From the 2nd query, I'm trying to extract only records from 2nd query where
>the average of avg(ratingvalue) >=4 and I'm not sure how do do this.
1st Query
SELECT
thats brilliant, thanks for all your advice
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fus
> Hi, i hope this is a very simple question! but i want to be
> able to call a query but i want the result of the query to be
> stored in a structure format so that i can use in cfscript,
> the only examples i can find is if the result is used in a
>
> could someone possibly provide a simple
You can reference a query in cfscript:
select
col1, col2
from
rownum = 0;
while (row lt qryName.RecordCount)
{
rownum = IncrementValue(rownum);
col1= qryName.col1[rownum];
col2 = qryName.col2[rownum];
}
On 10/19/06, Richard White <[EMAIL PROTECTED]> wrote:
>
> Hi, i hope this i
lk
Subject: cfquery result
Hi, i hope this is a very simple question! but i want to be able to call a
query but i want the result of the query to be stored in a structure format so
that i can use in cfscript, the only examples i can find is if the result is
used in a http://www.fusionauthority.com
Hi, i hope this is a very simple question! but i want to be able to call a
query but i want the result of the query to be stored in a structure format so
that i can use in cfscript, the only examples i can find is if the result is
used in a http://www.fusionauthority.com/quarterly
Archive:
htt
Another rather big difference is that inside CFquery SQL you can use CF and
essentially have a dynamic SQL solution without the drawbacks of dynamic
SQL. For some solutions this makes Ad-hock query faster than stored proc.
TK
-Original Message-
From: Ninad Inamdar [mailto:[EMAIL
The quick difference between the and is you can deal
with multiple recordset returned from the stored procedure which was not
possible using .With you can deal with the return
values from the stored procedures.
The Only drawback I see using is it can not handle the varbinary
data which i
Thank you very much for responding.
Mullai
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fus
Use Ajax. You can call a CF function with it which will perform the DB
Query and return the results. Then call another CF function to populate
form fields.
Mullai Subbiah wrote:
> Can we use Cfquery within Javascript. I am trying to populate a form based on
> what I do within the Java
ith SMTP;
> Thu, 14 Sep 2006 23:06:15 -0400
> Received: from LOCALHOST by LOCALHOST
> with ESMTP id CB61D8F0742DE746B9FB7725E507023A
> Thu, 14 Sep 2006 23:06:27 -0400
> Subject: Cfquery in Javascript
> From: Mullai Subbiah <[EMAIL PROTECTED]>
> Content-Type: text/plain
MTP id CB61D8F0742DE746B9FB7725E507023A
Thu, 14 Sep 2006 23:06:27 -0400
Subject: Cfquery in Javascript
From: Mullai Subbiah <[EMAIL PROTECTED]>
Content-Type: text/plain
Precedence: bulk
Reply-To: cf-talk@houseoffusion.com
To: CF-Talk
Date: Thu, 14 Sep 2006 22:56:38 -0400
Message-ID: <[EMAIL PROTECTED]>
Can we use Cfquery within Javascript. I am trying to populate a form based on
what I do within the Javascript. Once I am done I need to populate the form
fields by querying the database? Any thoughts will be appreciated
OP
1.
Not sure if this works on anything but MS SQL server.
...
Ben Nadel
www.bennadel.com
-Original Message-
From: Everett, Al (NIH/NIGMS) [C] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 23, 2006 12:47 PM
To: CF-Talk
Subject: RE: CFQUERY of non-swequential p
You could query the table and get a list of the available IDs.
Generate a random number between 1 and listlen() and then using
ListGetAt() you can get that random ID and then query the DB again to
pull back that record.
On 8/23/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> All,
>
> I'm doing
/udf.cfm?id=524
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 23, 2006 12:14 PM
To: CF-Talk
Subject: CFQUERY of non-swequential primary key ids
All,
I'm doing a query and randomly displaying images from within each record
but records have
ee_id" ][ RandRange( 1,
get_vids_a.RecordCount ) ]#
...
Ben Nadel
www.bennadel.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 23, 2006 12:14 PM
To: CF-Talk
Subject: CFQUERY of non-swequential primary key ids
All,
I'm doing a query and randomly displaying images from within each record
but records have been removed so I don't have sequential id values.
PROBLEM:
When I run this code sometime I get images, sometimes I get nothing.
Should I be running a different random'izer? 8-) Any ideas?
CODE:
will match part of the database ID in the search form...
>
>
> I have NOT tested this... But maybe It can give you some ideas.
>
>
> .......
> Ben Nadel
> www.bennadel.com
>
>
> -Original Message-
> From: Paul Ihrig [mailto:[EMAIL PROTECTED]
the search field could be a first name, id date, whatever.
i am doing the 0=0 to return all records if nothing is passed.
then will check to see if it numeric, if it is they will be looking up an
ID.
if there is a similar id, return that set..
say our ids have 123456789 charecters.
i just want to
ill match part of the database ID in the search form...
I have NOT tested this... But maybe It can give you some ideas.
...
Ben Nadel
www.bennadel.com
-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]
Sent: Monday, August 21, 2006 4:34 PM
To: CF-Talk
Subj
What is the value of #FORM.search#
It must be at least 1 number, or a comma dleimited list of numbers.
Contains requires full-text search and is for text fields.
Snake
-Original Message-
From: Paul Ihrig [mailto:[EMAIL PROTECTED]
Sent: 21 August 2006 21:34
To: CF-Talk
Subject: cfquery
i cant get the IN/CONTAINS to work on searching a numeric field.
i can can get the result if the passed value is the exact Number.
but if i want the subset of a number or any results with 1300 then i cant
get it to work.
i have googled it, every way i can think
SELECT *
FROM ClientList_Query1
WH
OTECTED]> wrote:
> >
> > I'm trying to automate some of an application's database maintentance
> > tasks via a CF script that will check to see if it's time for a defrag,
> > index rebuild, etc. I know that I can put a DBCC statement in a
> CFQUERY,
> &g
. net <
[EMAIL PROTECTED]> wrote:
>
> I'm trying to automate some of an application's database maintentance
> tasks via a CF script that will check to see if it's time for a defrag,
> index rebuild, etc. I know that I can put a DBCC statement in a CFQUERY,
> bu
I'm trying to automate some of an application's database maintentance tasks via
a CF script that will check to see if it's time for a defrag, index rebuild,
etc. I know that I can put a DBCC statement in a CFQUERY, but what's got me
scrambling is how to retrieve any output
data opens you up
to CFML injection attacks so you'll need to sanitize for those.
Josh
-Original Message-
From: David Carter [mailto:[EMAIL PROTECTED]
Sent: Monday, August 07, 2006 4:34 PM
To: CF-Talk
Subject: Re: cfquery - single quotes become doubled
Thanks all, PreserveSin
Thanks all, PreserveSingleQuotes() solved the problem.
>That's by design. ColdFusion is escaping your single quotes.
>
>You need to either wrap your string in the PreserveSingleQuotes()
>function or, better, use
>
~|
Introduc
That's by design. ColdFusion is escaping your single quotes.
You need to either wrap your string in the PreserveSingleQuotes()
function or, better, use
-Original Message-
From: David Carter
Sent: Monday, August 07, 2006 3:14 PM
To: CF-Talk
Subject: cfquery - single quotes b
#PreserveSingleQuotes(sql_stmt)#
On 8/7/06, David Carter <[EMAIL PROTECTED]> wrote:
>
> Hello all,
>
> I am having a strange problem with a cfquery through SQL Server where I am
> building the SQL statement dynamically from form input. I wonder if anyone
> here has enc
#preserveSingleQuotes(sql_statement)#
On 8/7/06, David Carter <[EMAIL PROTECTED]> wrote:
> Hello all,
>
> I am having a strange problem with a cfquery through SQL Server where I am
> building the SQL statement dynamically from form input. I wonder if anyone
> here has enco
Hello all,
I am having a strange problem with a cfquery through SQL Server where I am
building the SQL statement dynamically from form input. I wonder if anyone here
has encountered and over come a similar error in the past, and could lead me
toward a solution.
When the SQL statement is
>>SQLselect * from app_users where UID = 271
Looks like you've got a http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
~|
Message: http://www.houseof
UID may be reserved but you can try: [UID] = #URL.dupid#
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 15, 2006 11:21 AM
To: CF-Talk
Subject: CFQuery simple but not working, strange
Hey All,
Argh!
I've stared at this error for 10 mi
Some people call me the gangster of
love."
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 15, 2006 11:21 AM
To: CF-Talk
Subject: CFQuery simple but not working, strange
Hey All,
Argh!
I've stared at this error for 10 minutes and i
Hey All,
Argh!
I've stared at this error for 10 minutes and i can't see what' wrong with my
query.
This query is checking to see if a username already exists before adding a new
username
to the app_users table. UID is the primary key in the app_users table and
URL.dupid
is the triggered red
> However, you're probably much better off using the
> CFSTOREDPROC / CFPROCPARAM tag set... it does validation and
> handles procedures quite nicely.
On the other hand, you can use CACHEDWITHIN/CACHEDAFTER with CFQUERY calling
a stored procedure.
Dave Watts, CTO, Fig Leaf
sing MS SQL Server, how do you call a stored
> > procedure using the CFQUERY tag?
>
> Take your normal call from Query Analyzer and paste it into a CFQuery.
>
> EXEC your_procedure_name @Parmeter1 = #Parameter1Value#, @Parameter2 =
> '#Parameter2Value#'
>
>
&g
On 6/5/06, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote:
> Title says it all. Using MS SQL Server, how do you call a stored
> procedure using the CFQUERY tag?
Take your normal call from Query Analyzer and paste it into a CFQuery.
EXEC your_procedure_name @Parmeter1 = #Par
Title says it all. Using MS SQL Server, how do you call a stored
procedure using the CFQUERY tag?
Thanks,
Pete
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242524
Archives: http://www.houseoffusion.com/cf_lists
> This maybe OT but I was wounder if its possible to group
> recordset for Flash remoting the way cf does with cfquery group.
>
>
> #mainGroup.Title#
>
>#subGroup.subTitle#
>
>
No, I don't think so. When you use Flash Remoting, you don't outp
This maybe OT but I was wounder if its possible to group recordset for Flash
remoting the way cf does with cfquery group.
#mainGroup.Title#
#subGroup.subTitle#
~|
Message: http://www.houseoffusion.com/lists.cfm/link
Andy Matthews wrote:
> QFT?
"Quoted For Truth"
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235026
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/
QFT?
-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: Friday, March 10, 2006 8:38 AM
To: CF-Talk
Subject: Re: cfquery and insert help needed
James Holmes wrote:
> Use cfqueryparm as should be done in every query.
QFT.
Get in the habit now before it's
James Holmes wrote:
> Use cfqueryparm as should be done in every query.
QFT.
Get in the habit now before it's too late =)
Rick
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235006
Archives: http://www.houseoffusio
Sorry for abbreviating - "as should be done in every query in which
user input is used"
On 3/10/06, S. Isaac Dealey <[EMAIL PROTECTED]> wrote:
> It's not dangerous if it's a hard-coded value...
>
> Otherwise, yes, use
>
> > Use cfqueryparm as should be done in every query.
--
CFAJAX docs and oth
Nah, I was leaving it off to see if he was paying attention to my
description of the fix and not just copy n pasting my solution.
Ok, you are right, I missed that one.
On 3/9/06, S. Isaac Dealey <[EMAIL PROTECTED]> wrote:
>
> > You need to double up that single quote within your string
> > that
It's not dangerous if it's a hard-coded value...
Otherwise, yes, use
> Use cfqueryparm as should be done in every query.
> On 3/10/06, Charles Heizer <[EMAIL PROTECTED]> wrote:
>> Hello,
>> I'm trying to insert a value in to a column in oracle and
>> I'm getting
>> a missing comma error.
>>
>>
> You need to double up that single quote within your string
> that you are
> inserting. Are you just doing this directly in the DB or
> through CF? If in
> CF, using a cfqueryparam should take care of this for you.
> If directly in
> the DB then change it to:
> insert into RADIA4.ZSERVICE_LIST(
> Hello,
> I'm trying to insert a value in to a column in oracle and
> I'm getting
> a missing comma error.
> I know the problem has to do with value "'WORDPOS(EDMGETV
> (ZMASTER,ZOS),' WIN2K WINXP')=0'" I just don't know what
> to do to fix
> it.
> Thanks,
> - charles
> Here is my sql code...
>
Use cfqueryparm as should be done in every query.
On 3/10/06, Charles Heizer <[EMAIL PROTECTED]> wrote:
> Hello,
> I'm trying to insert a value in to a column in oracle and I'm getting
> a missing comma error.
>
> I know the problem has to do with value "'WORDPOS(EDMGETV
> (ZMASTER,ZOS),' WIN2K WI
You need to double up that single quote within your string that you are
inserting. Are you just doing this directly in the DB or through CF? If in
CF, using a cfqueryparam should take care of this for you. If directly in
the DB then change it to:
insert into RADIA4.ZSERVICE_LIST(REMOVAL,ZSTOP00
Hello,
I'm trying to insert a value in to a column in oracle and I'm getting
a missing comma error.
I know the problem has to do with value "'WORDPOS(EDMGETV
(ZMASTER,ZOS),' WIN2K WINXP')=0'" I just don't know what to do to fix
it.
Thanks,
- charles
Here is my sql code...
insert into RADIA4
Will Tomlinson wrote:
>
> This is the only chat room I've ever seen where you hafta enter your messages
> via your login name. lol!!
>
It's fixed Will! You can get on with life now!
Yay!
~|
Message: http://www.houseoffusion
Will Tomlinson wrote:
> I ain't got all night. lol! It's past my bedtime.
me neither.. it's a javascript error in the cfajax engine.js but I don't
know why it started happening. Oh well, I'll figger it out eventually.
Rick
~|
>I noticed =) I think ther's some kinda of javascript error.. gimme a
>few minutes =)
This is the only chat room I've ever seen where you hafta enter your messages
via your login name. lol!!
I've been using these as logins tonight:
Hey Guys!
Wow, this is a cool chat room!
Rick, when will y
I ain't got all night. lol! It's past my bedtime.
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233490
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.c
I noticed =) I think ther's some kinda of javascript error.. gimme a
few minutes =)
Will Tomlinson wrote:
> And it's definitely rabid tonight. Keeps refreshing whenever I send in some
> text.
>
>
~|
Message: http://www.house
And it's definitely rabid tonight. Keeps refreshing whenever I send in some
text.
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233487
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http
I'm in your RabidAJAXChat...
where are ya dude?
Will
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233486
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/li
Most of the time I use cfoutput, but if I'm concerned about whitespace
output and I'm inside a cfsetting enablecfoutputonly="yes", I'll use
cfloop and then place cfoutput tags only around what I want to output.
Rick
~|
Message:
i ask because I just see some of the "better" coders using loop and of course I
undestand that if you are outputing variables in the middle cfquery is a "doh"
but say if you are using enableoutputonly then sticking page code between
outputs its a null point, unless u w
Erf, I hit send before reading what I typed, last closing tag should be
not
On 2/25/06, Aaron Rouse <[EMAIL PROTECTED]> wrote:
>
> If I need to actually output something from the query and I am not already
> in a cfoutput block then I do cfoutput with the query attribute. I do not
> think there
If I need to actually output something from the query and I am not already
in a cfoutput block then I do cfoutput with the query attribute. I do not
think there is a "better" way, more to what is your preference. I work with
some people who do something like this #somethingfromquery# and to me
th
a ? i have always wondered is which is "better" to you when outputting a query?
For example, is it better to do this
/buck/large/1.jpg
copyright Buck Forester
/buck/thumbs/1.jpg
or this
/buck/large/1.jpg
copyright
-Talk
Subject: cfquery param vs N'#address#',
over this:
Is there a performance gain?
How does CF handle this differently?
Does cfqueryparam behave the same in 5,6 and 7?
Does SQL do anything differently?
Any general points would also be grateful.
I am just trying to understand the dif
> Thanks for the info so far guys, useful links too.
>
> I believe there is some sort of difference if you are using
> Unicode, but I havent been able to put my finger on it - any
> info on that side of things?
Specifying Unicode hints simply tells the database to treat a string as a
Unicode va
Thanks for the info so far guys, useful links too.
I believe there is some sort of difference if you are using Unicode,
but I havent been able to put my finger on it - any info on that side
of things?
On 2/14/06, Dave Watts <[EMAIL PROTECTED]> wrote:
> > What is the difference of doing this:
> >
> What is the difference of doing this:
>
> N'#address#',
>
> over this:
>
>
They're not comparable at all. The CFQUERYPARAM tag builds a prepared
statement and uses a bind parameter for your value.
> Is there a performance gain?
Generally, prepared statements execute faster than plain ol' p
There is a theoretical performance gain, because the DB server can
cache they query plan, and just plug in differing values for different
queries. However, the more important benefit is SQL injection
protection.
To my knowledge the behaviour hasn't changed between 5 and 7, but I
could be wrong.
What is the difference of doing this:
N'#address#',
over this:
Is there a performance gain?
How does CF handle this differently?
Does cfqueryparam behave the same in 5,6 and 7?
Does SQL do anything differently?
Any general points would also be grateful.
I am just trying to understand the dif
Hey guys,
Would those of you that are using my qbrowser on cf 7 check something
out for me?
When you execute a query using the qbrowser on cf 7, it takes the
results attribute and then uses it to display the execution time of
the query when it shows the results. But if you turn on debugging,
the
Thats what I figured.
Thanks for checking for me though.
On 11/30/05, Kerry <[EMAIL PROTECTED]> wrote:
> 6.1 says:
> Attribute validation error for tag CFQUERY.
> The tag does not allow the attribute(s) RESULT
>
> -Original Message-
> From: Ryan Guill [mailto:
6.1 says:
Attribute validation error for tag CFQUERY.
The tag does not allow the attribute(s) RESULT
-Original Message-
From: Ryan Guill [mailto:[EMAIL PROTECTED]
Sent: 30 November 2005 14:11
To: CF-Talk
Subject: cfquery result=""
This is probably a dumb question, but I'
It will fail in 6.1 - it is 7 only AFAIK.
-Original Message-
From: Ryan Guill [mailto:[EMAIL PROTECTED]
Sent: 30 November 2005 14:11
To: CF-Talk
Subject: cfquery result=""
This is probably a dumb question, but I'll ask just to make sure.
Does someone have a 6.1 bo
This is probably a dumb question, but I'll ask just to make sure.
Does someone have a 6.1 box they can test something on for me? I just
want to know if you have a cfquery tag with a result attribute if it
will fail on 6.1? Im sure it will, but it would be awesome if it
didn't...
I do second the "too lazy to write SQL code if I don't have to." I have
recently had the luxury of having in my team a person who is more DB-aware
than I am. So now I just write library CFCs that have functions that call
the SPs. Periodically when I see that there is a one-off query that really
doe
to write...as like most, I am just too damn lazy to code
more than I have to ;-)
-Original Message-
From: Dave Watts
To: CF-Talk
Sent: 31/10/2005 16:50
Subject: RE: Philosophy Q: SP's or CFQUERY?
> This is through experience; try and run some CPU intensive
> processes and see
501 - 600 of 1483 matches
Mail list logo
