update dbo.tbl_contest_2007
SET cb_vote1 = 1
WHERE cbcont_id IN ('#Replace(FORM.vote,',',"','",'all)#')
Basically, each item in the list needs to be wrapped in single quotes.
Dominic
On 06/07/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]>
wrote:
>
> All, Within a CFQUERY Valuelist
Use () instead of the '' and the query should work fine.
-Aaron
update dbo.tbl_contest_2007
SET cb_vote1 = 1
WHERE cbcont_id IN (#FORM.vote#)>
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, July 06, 2007 11:09 AM
To: CF-Talk
Subject: CFQUERY where i
That worked, thanks for clearing that up for me.
-Original Message-
From: Tom King [mailto:[EMAIL PROTECTED]
Sent: Monday, July 02, 2007 8:40 AM
To: CF-Talk
Subject: Re: CFQuery and MySQL
This may help with the set up (but I'm assuming as it verifies it probably ok):
This may help with the set up (but I'm assuming as it verifies it
probably ok):
http://www.oxalto.co.uk/index.cfm/2007/7/2/Setting-up-a-MySQL-
database-with-Unicode--properly-in-Coldfusion-7
T
On 2 Jul 2007, at 13:18, Mark Leder wrote:
> I have a new MySQL connection set up in CF7 - verifies
t; Visit our website at http://www.reedexpo.com
>
> -Original Message-
> From: Ryan, Terrence
> To: CF-Talk
> Sent: Fri Mar 23 02:13:36 2007
> Subject: RE: CFQUERY vs SQL Server Stored Procedures
>
> There are two reasons my organization encourages/forces all SQL to be
l
our switchboard on +44 (0) 20 89107910. The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions."
Visit our website at http://www.reedexpo.com
-Original Message-
From: Ryan, Terrence
To: CF-Talk
Sent: Fri Mar 23 02:13:36 2007
S
There are two reasons my organization encourages/forces all SQL to be in stored
procedures. And they don't directly touch on performance.
1. A belief that keeping SQL code in the database is of itself a good thing. By
keeping the database interaction in the database you make it easier for DBA's
At 11:17 AM 3/20/2007, D wrote:
Are cached queries as good as stored procedures?
Technically which are better?
Is it a significant difference?
Cached queries hold data in RAM so no call to the DB is necessary, so
they are always much faster than stored procedures (except for the
first call to
Thanks guys. I ijust found this article on Adobe.com that helped if anyone had
similar questions to my original questions.
http://www.adobe.com/devnet/coldfusion/articles/beg_storedproc.html
D
>Opinions?
>
>Are cached queries as good as stored procedures?
>Technically which are better?
>Is it
Opinions?
Are cached queries as good as stored procedures?
Technically which are better?
Is it a significant difference?
Thanks
If you are just using stored procedures to cache the data, it is
probably a relatively even trade off.
But, of course a stored procedure can do a lot more then just
It all depends on what you want to do. For startersCached Queries are
good but you cannot use cfqueryparam, SPs can return multiple recordsets
which cfquery cannot.
In some cases it may be better to use cfquery and in some an SP.
-Original Message-
From: [EMAIL PROTECTED] [ma
ECTED]
Sent: Thursday, February 22, 2007 12:52 PM
To: CF-Talk
Subject: RE: Cfquery timeout parameter.
I guess it means the execution of a single:
UPDATE
SELECT
DELETE
Would this also apply to sub-selects and other more comlex SQL syntax?
Say:
SELECT aField
FROM (SELECT bField FROM bTable) a
I guess it means the execution of a single:
UPDATE
SELECT
DELETE
Would this also apply to sub-selects and other more comlex SQL syntax?
Say:
SELECT aField
FROM (SELECT bField FROM bTable) aTable
Would that be two actions? Each one allowed to run for the timeout period, or
if the inner select
I guess it means the execution of a single:
UPDATE
SELECT
DELETE
Statement.
Like, these would be TWO actions:
UPDATE [table] set name = 'ben';
SELECT * FROM [table]
..
Ben Nadel
Certified Advanced ColdFusion MX7 Developer
www.bennadel.com
Need ColdFusion Help?
www.benn
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
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
A few ways depending on what you need.
Look at ValueList(). A very useful function. Or combine the first query in
the second:
SELECT *, dbo.recipeingredients.ingredients, dbo.addresses.firstname,
dbo.addresses.lastname,
dbo.recipes.recipeID, dbo.recipes.recipename, dbo.recipes.recipedesc,
You could try a couple different ways... First you could use
#valuelist(get_rec_4month.recipeID)# as the list
Or you could just put the query that gets the recipeIDs in the IN () section
of the final query like so...
WHERE dbo.recipes.recipeID IN
(
select recipeid from dbo.tbl_recipe_monthly
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) values to
ano
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
I'm not sure what SQL Platform you're using or what your schema exactly like...
i can only infer based on your queries. If you're doing a Query of Query i
don't think CF supports advanced functionality like HAVING... but in SQL it
would be something like this:
SELECT RecipeID,
> 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-
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
Don't need to do that...as it's already a structure. Just loop through it, ie:
for (x=1; x LTE queryName.recordcount; x=x+1)
queryName.columnName[x]
-Original Message-
From: Richard White [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 19, 2006 4:50 PM
To: CF-Talk
Subject: cf
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 Javascript.
AJAX
or, if the amount of data is minimal and not subject to change between
requests, you could create javascript objects or arrays to hold the
query data. Then when the form changes, the javascript changes the
form fields.
It's the same idea as two related select boxes, just expanding it to
more
AJAX
Return-Path: <[EMAIL PROTECTED]> Thu Sep 14 23:06:15 2006
Received: from houseoffusion.com [64.118.74.249] by mail.clickculture.com with
SMTP;
Thu, 14 Sep 2006 23:06:15 -0400
Received: from LOCALHOST by LOCALHOST
with ESMTP id CB61D8F0742DE746B9FB77
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
How very inefficient. How about something like this:
SELECT vidwee_id
FROM vidweek
select vow_up_lgnail_file,vidwee_id,vow_title
from vidweek
where vidwee_id = #VAL_ID#
There is also a function on CFLIB to randomly select rows from a
database table:
http://www.cflib.org/udf
I am not sure why you are doing the second query... Why make the
*randomization* more complicated than it has to be???
Simplify:
select
vidwee_id
from
vidweek
select vow_up_lgnail_file,vidwee_id,vow_title
from vidweek
where vidwee_id = #get_vids_a[ "vidwee_id" ][
thanks Ben
will try those examples in the mornning.
On 8/21/06, Ben Nadel <[EMAIL PROTECTED]> wrote:
>
> Paul,
>
> I am not sure if you want to get the subset to match in the DB or in the
> CF
> variable???
>
> You could always loop over the WHERE items.
>
> SELECT
> *
> FROM
> [ta
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
Paul,
I am not sure if you want to get the subset to match in the DB or in the CF
variable???
You could always loop over the WHERE items.
SELECT
*
FROM
[table]
WHERE
1 = 0
OR
CAST( ClientID AS VARCHAR(12)) LIKE '%i%'
The above will match PART
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:
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 become double
#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 encountered and over come a simi
#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 encountered and over come a
>>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 minutes a
Maybe try this:
500 : select *
501 : from app_users
502 : where [UID] =
503 :
...
Ben Nadel
Web Developer
Nylon Technology
350 7th Avenue
Floor 10
New York, NY 10001
212.691.1134 x 14
212.691.3477 fax
www.nylontechnology.com
"Some people call me the space cowboy. Some p
> 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 output anything
directly from CF, I don't thin
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
With cfparam, you have built-in type checking. It also can help to avoid
loads of cfif statements because you KNOW the variable is there, you just
need to check it's value.
-Original Message-
From: Duncan [mailto:[EMAIL PROTECTED]
Sent: Monday, February 13, 2006 4:25 PM
To: CF-Talk
Subje
> 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.
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:[EMAIL PROTECTED]
> Sent: 30
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'll ask just to ma
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 box they can test som
en than not you will of course know what columns you are getting
back - its normally your own database! And if you don't know it by
now.;-)
-Original Message-
From: Al Everett [mailto:[EMAIL PROTECTED]
Sent: 20 July 2005 16:41
To: CF-Talk
Subject: Re: CFQuery and SQLBase -
It's still sloppy. For one thing, there's no way to tell what columns
you're getting back unless you look at the table as well. I find it
very rare that I need all columns from any table.
Any best practice document I've seen on SQL says to avoid SELECT *.
On 7/20/05, Claude Schneegans <[EMAIL PRO
Yeah..maybe a little m ore clarification would have helped...but certainly
to not use it all would be a tad harsh ;-)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 20 July 2005 16:23
To: CF-Talk
Subject: RE: CFQuery and SQLBase - alternative to using
>>You shouldn't ever use SELECT *. Name the columns you want.
Well, ... except if you do need all columns, and SELECT * is standard in
SQL, especially for that purpose.
~|
Find out how CFTicket can increase your company's cust
esignate your fields in the SELECT
statement for ease of code reading and maximum efficiency.
*Whew*
Dave
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 20, 2005 11:04 AM
To: CF-Talk
Subject: RE: CFQuery and SQLBase - alternative to usin
That is a fairly loose statement... "your shouldn't ever" what if there
is a need? There is not founding in you stating you shouldn't ever use it.
-Original Message-
From: Al Everett [mailto:[EMAIL PROTECTED]
Sent: 20 July 2005 15:50
To: CF-Talk
Subject: Re:
The database server is "SQLBase" by Gupta.
I tried PHONE## and it works. Thanks,
Percy
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 20, 2005 10:50 AM
To: CF-Talk
Subject: RE: CFQuery and SQLBase - alternative to using aste
You shouldn't ever use SELECT *. Name the columns you want.
For the other, try PHONE##.
On 7/20/05, Perez, Percy <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I am having problems doing a simple SQL select.
>
> When I enter: SELECT * from TABLE1, I get an error message that the
> asterisk is an inval
What database are you using (Access, SQL, Oracle, etc.).
Also, can you SELECT PHONE# FROM TABLE1 ???
If so, then that's not your issue.
If you can't SELECT PHONE#, try this:
SELECT PHONE## FROM TABLE1
See if that works.
Dave
-Original Message-
From: Perez, Percy [mailto:[EMAIL PR
> Someone using my blog has reported that posting a comment crashes his
> MySQL server.
You might suggest they update their JDBC drivers to the ones designed
for MySQL 4. http://www.mysql.com/ has the gory.
--
Damien McKenna - Web Developer - [EMAIL PROTECTED]
The Limu Company - http://www.the
link to a display page?
#theCount#
and in DisplayPage.cfm
SELECT * from Intake
WHERE datepart(blah blah) = #URL.mm#
- Original Message -
From: "Daniel Kang" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Saturday, March 19, 2005 12:43 PM
Subject: Re: cfq
Mike,
Yes, that is what I am trying to do, but here is the issue.
Let's say #TheCount# (from the cfoutput below) returns 15 (meaning 15
cfquery results).
NumofIntake.TheMonth eq 2>
#TheCount#
I want to see the details of 15 cfquery results when #TheCount# (in
this case, "15") is clicked. How
Hi Daniel, Not sure I fully understand. You have a form which the
user can change, which, when submitted causes CF to run your query and
generate some results in 'NumofIntake'.
You are then displaying these.
You can certainly use the 'onclick' attribute of some html tag to run
some javascript to
ah, didn't think of that test. I just checked the debugging from CF on
the query
getdata (Datasource=aop_prod, Time=1671ms, Records=200)
So CF is reporting only 200 rows also.
I am convinced maxrows now actually dictates the maximum rows to the
RDBMS. At least for Oracle and CFMX use. Others w
On Thu, 10 Mar 2005 10:57:09 -0500, Douglas Knudsen
<[EMAIL PROTECTED]> wrote:
> check this SQL below out. We use it on Oracle 9i. Assuming you have
> the proper privs and all, you can see all the SQL running within the
> past few minutes. Add "AND username = 'FOO' " to see this for a
> single
check this SQL below out. We use it on Oracle 9i. Assuming you have
the proper privs and all, you can see all the SQL running within the
past few minutes. Add "AND username = 'FOO' " to see this for a
single user. Using this SQL run a large cfquery using maxrows. You
will see that maxrows is
On Thu, 10 Mar 2005 09:50:37 -0500, Douglas Knudsen
<[EMAIL PROTECTED]> wrote:
> ok, maybe I'm on some bad crack today, but I recall that the maxrows
> attribute of cfquery works AFTER the resultset is returned to CF from
> the DB. Is this the case for all RDBMs? I'm noticing that this is
> not t
I might also add that if you are on a MX 7 Ent box this is a great
example of how asynchronous cfm calls can really speed up an app. You
can make an async call to a cfc which would do the remote update, no
delays in your actual page rendering time and no try catch needed
around the call. These asyn
I have a couple of applications where I want to update two database
servers simultaneously. I have just set up a datasource for each
server on my CFserver, and run the update query twice - once with each
datasource name. No need for connect strings.
It breaks if the remote server isnt available
Might I add that in CF 7 the complete ColdFusion Admin has an API so
you could make datasources dyhnmically that way...I would guess with a
little investigation you could figure out how to do simular in MX 6...
Adam H
On Sun, 6 Mar 2005 12:35:19 -0600, Jared Rypka-Hauer - CMG, LLC
<[EMAIL PROTEC
Oi... having an internet connection is a security risk.
I locked my keys in the car the other night. I had to make a simple
tool and slid it down between the body of the car and the top of the
door, to hit the electric lock button. It took less than 30 seconds to
steal my own car. But it was lock
what you pay for". I'm not saying your wrong -- I'm just
saying, it's not necessarily as black and white as it might seem.
> Unless they are using sandboxing on CF Enterprise, like ay
> decent ISP should.
> -Original Message-
> From: S. Isaac Dealey [mailto
>>it is trivial to write a CF template to get the
>>raw code of everyone else's CF templates to get their usernames and
>>passwords;
It is at least as trivial (at least in CF 5) to write a CF template to get the
CF administrator password,
so storing the datasource password in it is not safe eit
't sandbox, don't expect any security at
all.
-Original Message-
From: James Holmes
Sent: Sunday, 6 March 2005 3:19
To: CF-Talk
Subject: RE: CFQUERY accessing MS SQL DB on another CF server
Unless they are using sandboxing on CF Enterprise, like ay decent ISP
should.
-Origin
: Sunday, March 06, 2005 2:05 AM
To: CF-Talk
Subject: RE: CFQUERY accessing MS SQL DB on another CF server
In fact, without sandboxing, it is trivial to write a CF template to get the
raw code of everyone else's CF templates to get their usernames and
passwords; since in this case the datasource i
Unless they are using sandboxing on CF Enterprise, like ay decent ISP
should.
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Sunday, 6 March 2005 3:23
To: CF-Talk
Subject: RE: CFQUERY accessing MS SQL DB on another CF server
[snip]
Many shared hosting
Well, you can't do it in the cfquery tag, so it's no way.
-Original Message-
From: Nick Baker [mailto:[EMAIL PROTECTED]
Sent: Sunday, 6 March 2005 3:13
To: CF-Talk
Subject: RE: CFQUERY accessing MS SQL DB on another CF server
CFAdmin's instructions are to provid
IMO hard-coding a database username/password in your app is only a
security risk if the wrong people already have access to your file
system, in which case you likely have bigger issues than the database
username in your application code.
Many shared hosting providers don't include the username /
CFAdmin's instructions are to provide the following ConnectionString. It is
that way
or no way.
ConnectionString = "DRIVER=SQL Server;SERVER={ipaddress};UID={username};
PWD={password};APP=;DATABASE={database}"
I can't figure out where to put it?
Security is not an issue in this case. Some publi
Well, hard coding your SQL username & password is a security risk and IMHO
bad practice.
You should let the CFAdmin handle that for you.
Warmest Regards,
Phillip B. Holmes
-Original Message-
From: Nick Baker [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 06, 2005 12:46 AM
To: CF-Talk
Add the server as a datasource.
-Original Message-
From: Nick Baker [mailto:[EMAIL PROTECTED]
Sent: Sunday, 6 March 2005 2:46
To: CF-Talk
Subject: CFQUERY accessing MS SQL DB on another CF server
MX 6.1
In some of the earlier versions you could query a db on other servers around
the I
>>the only changes CF will make is to add a semicolon to the
end of the query,
Plus eventually escape single quotes in strings.
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this add
201 - 300 of 492 matches
Mail list logo