lthit.com
www.emerginghealthit.com
www.montefiore.org
-Original Message-
From: fun and learning [mailto:funandlrnn...@gmail.com]
Sent: Monday, February 10, 2014 10:04 AM
To: cf-talk
Subject: cfquery multiple column search
All -
I am working on a search functionality for multiple columns of data. I u
All -
I am working on a search functionality for multiple columns of data. I using
'OR' condition for searching on a single search input. For example on front end
i have a search input box, and I can enter either numeric or alphabets or
alphanumeric characters. How can I handle this using cfqu
I like the Mega mind response...
you were right, I was less right
On Wed, Aug 21, 2013 at 5:28 PM, Ron Thigpen wrote:
>
> Dave wasn't wrong, he was differently right.
>
> --rt
>
> On 8/19/13 10:08 AM, Raymond Camden wrote:
> >
> > I'm going to go print this email out right now. For the next t
Dave wasn't wrong, he was differently right.
--rt
On 8/19/13 10:08 AM, Raymond Camden wrote:
>
> I'm going to go print this email out right now. For the next time Dave is
> wrong. Sometime in 2019.
~|
Order the Adobe Coldfusion
coldfusiondocs.com not working properly either, so seems likely.
On Mon, Aug 19, 2013 at 4:26 PM, Carl Von Stetten
wrote:
>
> I wonder if the problems with cfquickdocs and cfgloss are related to the
> switchover of the ColdFusion docs to the new wiki format? Or is that
> only for CF10 docs?
>
I wonder if the problems with cfquickdocs and cfgloss are related to the
switchover of the ColdFusion docs to the new wiki format? Or is that
only for CF10 docs?
-Carl V.
On 8/19/2013 7:15 AM, DURETTE, STEVEN J wrote:
> I know from trying to look something up last week that I couldn't get to
> I take an entirely different viewpoint on Dave's answer. I read the
> original post and declined to answer because it seemed pretty obvious that
> ZERO effort was put in place by the questioner to find an answer. My bet is
> Dave had a similar feeling regarding the effort, but instead of declini
-
> > From: DURETTE, STEVEN J [mailto:sd1...@att.com]
> > Sent: Monday, August 19, 2013 8:46 AM
> > To: cf-talk
> > Subject: RE: Using IN() within a cfquery statement
> >
> >
> > Dave... I'm surprised. Wouldn't you think that CFQueryParam wou
cf-talk
Subject: Re: Using IN() within a cfquery statement
I take an entirely different viewpoint on Dave's answer. I read the
original post and declined to answer because it seemed pretty obvious that
ZERO effort was put in place by the questioner to find an answer. My bet is
Dave had a simi
x27;s waited til August so I say
> we give him a break :)
>
> -Mark
>
> -Original Message-
> From: DURETTE, STEVEN J [mailto:sd1...@att.com]
> Sent: Monday, August 19, 2013 8:46 AM
> To: cf-talk
> Subject: RE: Using IN() within a cfquery statement
>
>
> Dave...
I'm going to go print this email out right now. For the next time Dave is
wrong. Sometime in 2019.
On Mon, Aug 19, 2013 at 8:53 AM, Dave Watts wrote:
>
> > Dave... I'm surprised. Wouldn't you think that CFQueryParam would be the
> better way?
> >
> > Where stuff in ( cfsqltype="appropriate typ
> Dave... I'm surprised. Wouldn't you think that CFQueryParam would be the
> better way?
>
> Where stuff in ()
Yes, that would absolutely be a better way, of course! I didn't even
pay attention to the fact that this was in the form scope.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.co
Dave is allowed one weak answer per year... he's waited til August so I say
we give him a break :)
-Mark
-Original Message-
From: DURETTE, STEVEN J [mailto:sd1...@att.com]
Sent: Monday, August 19, 2013 8:46 AM
To: cf-talk
Subject: RE: Using IN() within a cfquery statement
Dave..
Dave... I'm surprised. Wouldn't you think that CFQueryParam would be the better
way?
Where stuff in ()
Steve
-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com]
Sent: Monday, August 19, 2013 9:42 AM
To: cf-talk
Subject: Re: Using IN() within a cfquery statement
> I have a select name="stuff" multiple in a form filled with results from a
> query.
> I get the form field value: stuff=selection1,selection5,selection12.
>
> How do I then build a cfquery using the stuff variable in the IN() statement?
Use the quotedValueList funct
I have a select name="stuff" multiple in a form filled with results from a
query.
I get the form field value: stuff=selection1,selection5,selection12.
How do I then build a cfquery using the stuff variable in the IN() statemen
you should ask whoever manages the server, as updating to new java versions
can have bizzare results like this where everything seems to work except
one random thing.
you can also see the java version being used on the info page in cfadmin.
you should also try rebuilding your conenctors, as they
Do any other CF requests work on that server?
Sounds like a web connector issue perhaps.
Byron Mann
Lead Engineer & Architect
HostMySite.com
On Jul 9, 2013 6:11 PM, "Chris Johnson" wrote:
>
> Really odd issue we've been having.. We have a scheduled task that hits
> another database server to g
Not sure.. we don't handle much of the system software/hardware on the box. Do
you know what that may affect or how to check when it was updated?
>Has anyone updated the java version by any chance
>
>Russ Michaels
>www.michaels.me.uk
> On 9 Jul 2013 23:11, "Chris Johnson" wrote:
>
>>
Has anyone updated the java version by any chance
Russ Michaels
www.michaels.me.uk
On 9 Jul 2013 23:11, "Chris Johnson" wrote:
>
> Really odd issue we've been having.. We have a scheduled task that hits
> another database server to get a full list of employees. It then runs
> through the user
Really odd issue we've been having.. We have a scheduled task that hits another
database server to get a full list of employees. It then runs through the user
accounts for this specific app and adds or updates accounts as needed.
We weren't aware that it had been broken, so we don't know exac
Thanks Russ, ill take a look into this
>You don't, afaik ypu simply need the client cert in the java keystore.
>See this
>http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-using-ssl.html
>
>There is a handu cfadmin extension on riaforge.org for managing your
>keystore.
>
>Regards
>Russ
s,
> Richard
>
>
>
>
> > Hi,
> >
> > We have a windows server for our CF application and a Linux server for
> > our database. We are setting up a self-signed SSL between the two
> > servers.
> >
> > Our hosting company have said we need to ref
gt;
> Our hosting company have said we need to reference the SSL in the
> connection string but how can I do this in a cfquery?
>
> Many thanks
> Richard
~|
Order the Adobe Coldfusion Anthology now!
http://www.amaz
on and a Linux server
> for our
> > database. We are setting up a self-signed SSL between the two
> servers.
> >
> > Our hosting company have said we need to reference the SSL in the
> > connection string but how can I do this in a cfquery?
> >
> > Many t
>
> Hi,
>
> We have a windows server for our CF application and a Linux server for our
> database. We are setting up a self-signed SSL between the two servers.
>
> Our hosting company have said we need to reference the SSL in the
> connection string but how can I do thi
Hi,
We have a windows server for our CF application and a Linux server for our
database. We are setting up a self-signed SSL between the two servers.
Our hosting company have said we need to reference the SSL in the connection
string but how can I do this in a cfquery?
Many thanks
Richard
list of towns is not really a huge query, just do it once and cache and
then do a query of query for your auto complete.
On Mon, Jan 7, 2013 at 2:06 PM, Stephens, Larry V wrote:
>
> A related question: I have a table of towns that has ~20,000 records. The
> dataset I need has the record ID, to
A related question: I have a table of towns that has ~20,000 records. The
dataset I need has the record ID, town name, a memo field (usually empty), and
fields holding an index into other tables (township, county, state, country).
In my form I have a select field to pick the town. I don't want
On Sat, Jan 5, 2013 at 8:25 AM, Russ Michaels wrote:
> 2 simple solutions are.
>
> 1. Dont query all the data at all, instead provide a search form to get at
> specific records, which is usually much simpler thsn paging through
> hundreds or thousands of records.
> 2. Only query the primary keys
Another method, assuming you're using MS SQL Server (not sure how far
this goes back compatibility-wise) is to toss in the criteria for the
full search, but then to only pull back X rows:
WITH Results_Full AS (
SELECT Field1, Field2, Field3, ROW_NUMBER()
OVER (ORDER BY Field1)
Very slick. Thanks guys!
--Ben
On 1/5/2013 3:39 PM, =?ISO-8859-1?Q?Claude_Schn=E9egans wrote:
> >>2. Only query the primary keys, and then loop over that list grabbing x
> records at a time and doing a new query to get all rows for those keys.
>
> This is a pretty good method.
> I tested it o
Glad it helped. Also dont forget u.can cache the original primary key query
too.
Regards
Russ Michaels
www.michaels.me.uk
www.cfmldeveloper.com - Free CFML hosting for developers
www.cfsearch.com - CF search engine
On Jan 5, 2013 10:39 PM, <> wrote:
>
> >>2. Only query the primary keys, and the
>>2. Only query the primary keys, and then loop over that list grabbing x
records at a time and doing a new query to get all rows for those keys.
This is a pretty good method.
I tested it on a database containing about 45 records with a seach template.
I give a very loose criterion on purpos
Actually there are ways to step through a result set using database
functions so that you do bot store huge resultsets in memory, if you google
it then you will find some examples.
2 simple solutions are.
1. Dont query all the data at all, instead provide a search form to get at
specific records
That's what I suspected. Much appreciated.
--Ben
On 1/4/2013 6:40 AM, Dave Watts wrote:
>> A question came up recently with one of my client developers who is
>> potentially
>> returning a large # of rows from a query. The question was whether the
>> result
>> set is stored in memory or spoo
> A question came up recently with one of my client developers who is
> potentially
> returning a large # of rows from a query. The question was whether the result
> set is stored in memory or spooled to disk somewhere. I didn't know but
> assumed
> it was memory resident.
>
> Anyone know the
Hi,
A question came up recently with one of my client developers who is potentially
returning a large # of rows from a query. The question was whether the result
set is stored in memory or spooled to disk somewhere. I didn't know but
assumed
it was memory resident.
Anyone know the answer t
> i have a table that has two date fields (dateinx and dateoutx) and i
> need to find all the results for todays date that both fall between
> and on that date for a given customer: cID.
This should be fairly simple to add to your existing query...
AND GETDATE() BETWEEN dateinx AND dateoutx
> d
i have a table that has two date fields (dateinx and dateoutx) and i need to
find all the results for todays date that both fall between and on that date
for a given customer: cID.
database is msSQL2005
cfserver is 7
if todays date is 12/2/2012examples of vialable entries:
- dateinx=12/2/2012
Thanks Rob Parkhill.
It was the Max data length in cf admin.It was set to 64,000 characters by
default. Adjusting that solved the problem.
Robert Harrison
Director of Interactive Services
Austin & Williams
Advertising I Branding I Digital I Direct
125 Kennedy Drive, Suite 100 I H
at your post is so huge you might want to see if increasing that setting
> helps.
>
> > -Original Message-
> > From: Robert Harrison [mailto:rob...@austin-williams.com]
> > Sent: 13 June 2012 17:17
> > To: cf-talk
> > Subject: Date Truncation on CFquery U
ntially entering a document of 50+ pages into a
> text area field (tiny MCE). The data is being saved to a data base via
> CFquery Update. The data base is MS SQL server and the field length is set
> to VARCHAR(MAX). Data is being truncated on update to data base (same
> place every t
> To: cf-talk
> Subject: Date Truncation on CFquery Update
>
>
> I have a client who is essentially entering a document of 50+ pages into a
text
> area field (tiny MCE). The data is being saved to a data base via CFquery
> Update. The data base is MS SQL server and the field length
I have a client who is essentially entering a document of 50+ pages into a text
area field (tiny MCE). The data is being saved to a data base via CFquery
Update. The data base is MS SQL server and the field length is set to
VARCHAR(MAX). Data is being truncated on update to data base (same
o: cf-talk
Subject: Re: CFQuery to Database
if its just a few records then use query of query to get your subset of results
and then insert the results into database B
if this is a regular occurrence and happens often then then you may want to
look at creating a DTS script on your SQL server and
if its just a few records then use query of query to get your subset of
results and then insert the results into database B
if this is a regular occurrence and happens often then then you may want to
look at creating a DTS script on your SQL server and scheduling that to do
the job.
On Sat, Mar
I have couple of records which are filtered from data source x which is oracle
based and require to insert it into datasource y which is MS SQL server.
The number of rows, columns is not fixed, however I have the records in a Query
object, what would be the best way to insert get this data into
> CFSQLType ='CF_SQL_VARCHAR'>
Also for date columns use a date/time type instead of varchar. If the column
contains dates (only) you can use cf_sql_date, which truncates the time portion.
WHERE EXPIRATIONDATE = http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
WHERE EXPIRATIONDATE =
Sent from my Samsung Galaxy SII
On Mar 4, 2012 7:54 AM, "Barry Mcconaghey" wrote:
>
> Hello.
>
> I'm trying to get this cfquery to match a database field
> EXPIRATIONDATE(date) 2012-3-04 and do a recordcount but it is not working.
>
Hello.
I'm trying to get this cfquery to match a database field EXPIRATIONDATE(date)
2012-3-04 and do a recordcount but it is not working.
SELECT EXPIRATIONDATE
FROM COUPONS
WHERE EXPIRATIONDATE =
#data.RecordCount#
Thanks,
Thanks for your assistance
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messagei
Start here and let us know if you have any trouble:
http://www.cfscreencast.com/2007/12/6/retrieving-data-from-mysql-using-cfquery/
http://www.coldfusion-ria.com/Blog/index.cfm/2009/12/14/ExtJS-30-Editor-Grid-with-ColdFusion
(I
didn't see an ExtJS 4 example on Google. Perhaps 3 will work fo
Hi I am new to coldfusion 9 and extjs 4 and like to know how to pass a cfquery
to a mysql table, and then covert the data to json to populate a grid..
Would appreciate some help on this matter also if there are any tutorials for
newbies.
Thanks
Why not just do this:
data = {};
data.query = somequery;
data.whatever = "ice cream";
On Wed, Jul 20, 2011 at 7:40 AM, Richard White wrote:
>
> Hi,
>
> is there any way to add custom variables to cfquery metadata.
>
> for example: i know i can add them as follows
Hi,
is there any way to add custom variables to cfquery metadata.
for example: i know i can add them as follows:
mt = getMetaData(query)
mt[1].newVar = "value";
however, this query gets passed through various functions so instead of also
passing the metadata through, i would ju
What DBMS are you using? MSSQL, MYSQL, Access (bleeackk!), other?
MSSQL uses single quotes in the WHERE clause. However, if you use
cfqueryparam for all of your where clause pieces, single quotes in your
strings should pass through in the database request just fine.
What is the data type of t
FROM PlaysCalled
WHERE PlaysCalled.Formation =
AND PlaysCalled.Play =
AND PlaysCalled.BallCarrier =
From: "Jim Brundle"
Sent: Friday, June 10, 2011 9:15 AM
To: "cf-talk"
Subject: CFQuery Select and single quotes in st
I'm doing a look up like this:
SELECT Formation, Play, BallCarrier, YardsGained, Result
FROM PlaysCalled
WHERE (((PlaysCalled.Formation)="#Form.Formation#") AND
((PlaysCalled.Play)="#Form.Play#") AND
((PlaysCalled.BallCarrier)="#Form.BallCarrier#"));
In some cases, the Ball Carrier's
Mark, there is an excellent SQL tutorial here: http://www.w3schools.com/sql/
If you figure out exactly how joins work, it will make writing SQL so
much easier for you.
Sub-selects like Greg used are also very useful.
A few hours spent on this site will save you hours of struggle later.
On Thu,
it to produce the same results, which I will
do.
Thanks again,
Mark
-Original Message-
From: Greg Morphis [mailto:gmorp...@gmail.com]
Sent: Thursday, May 26, 2011 11:48 AM
To: cf-talk
Subject: Re: cfquery select question
If they all return 1 row use this..
select * from table3 t3
where
If they all return 1 row use this..
select * from table3 t3
where t3.ID = (
select t2.ID
from table2 t2
where t2.productcode = (
select t1.productcode
from table1 t1
where t1.ordernumber = [whatever]
)
)
If they retu
SELECT DISTINCT table3.ID, table3.Company
FROM table3 INNER JOIN
table2 ON table3.ID = table2.t2_ID INNER JOIN
table1 ON table2.ordernumber = table1.ordernumber
WHERE (table1.productcode LIKE '%a certain string%')
On Thu, May 26, 2011 at 11:
Hallo all,
Forgive my SQL "injection" into this list - perhaps an answer to my question
might also prove useful to others.
I'm using three tables. There is no relationship between table1 and table3.
I first query table1 for ordernumber and productcode, based on the productcode
containing a ce
s not referring to a url
it reloads the same page.
This was driving me crazy.
Dan
-Original Message-
From: Kym Kovan
Sent: Tuesday, April 19, 2011 7:23 AM
To: cf-talk
Subject: Re: CFQUERY update Firefox wierdness
On 19/04/2011 8:46 PM, Dan Blickensderfer wrote:
>
> I checked and
On 19/04/2011 8:46 PM, Dan Blickensderfer wrote:
>
> I checked and it's turned off. This is happening from multiple computers
> with Firefox.
>
> Any other thoughts?
in that case turn it on and look at what the browser is sending...
--
Yours,
Kym Kovan
mbcomms.net.au
I checked and it's turned off. This is happening from multiple computers
with Firefox.
Any other thoughts?
-Original Message-
From: Matt Quackenbush
Sent: Tuesday, April 19, 2011 12:20 AM
To: cf-talk
Subject: Re: CFQUERY update Firefox wierdness
Wild guess: Firebug is turn
Wild guess: Firebug is turned on and is adding a second "click" to the flow.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.hou
tag has absolutely nothing to do with any browser - it is
executed by cf on the server side.
i would check your page's html and javascript instead - that's where
browser differences can come into play.
how do you submit your form to add item to cart - ajax or regular form
submit?
how do you
Hi
I never seen that.. but the first thing I would look at is to set
up a way to see how many times that action page is run. Perhaps insert a
GetTickCount counter into a log file when the action page is
run.. First look to see how it works in IE, then try firefox.
At 06:55 PM 4/18/2011, y
Hi Everyone,
I have a really strange issue that I can not figure out how to fix it. I
have a simple shopping cart and everything works exactly the way it should
in ie7 & ie8 but firefox not so much.
This is the issue. When customer clicks on the item to add to cart it first
checks to see if
I am running ColdFusion 8 and Oracle 10g.
I am running three stored procedures to insert data into three separate
temporary tables. From there, I run a union statement to against the three
temporary tables and output out the results. However, I am running into an
unexpected error:
Stored Pr
The behavior change might be due to updated drivers, which is the most
common source of modified database behavior. You can probably fix this
either in CF, using something like NumberFormat, or cfqueryparam, or using
casting in SQL Server. If this is a lot of work for you, it might be worth
it to
>Looks like you might need to revise the procedure to CAST the calculated
>value back to Numeric(10,2) before returning it?
>Carl
Yeah, which is what we're doing for this one to resolve the issue.
But since this is a legacy, third-party, application ... it worries me the
number of places this
ce*((100-qp.memberdiscountpercent)/100)
> else qp.MemberPrice
> end
> end)
>
> Running this query on ColdFusion 7.('current') against MS SQL returns (again,
> cfdump of the cfquery, and the same thing as SQL Studio returns):
>
> 0.
>
else
case when qp.MemberPrice is null then
p.MemberPrice*((100-qp.memberdiscountpercent)/100)
else qp.MemberPrice
end
end)
Running this query on ColdFusion 7.('current') against MS SQL returns (again,
cfdump of the cfquery, and the sa
in
> CF8/we haven't flipped the appropriate 'switch.'
>
>
> >For clarification, which number has the unexpected formatting, the value
> >pulled directly out of a database table and placed in the cfquery record
> >set, the variable that is being assigned the
uming this is expected behavior in CF8/we haven't
flipped the appropriate 'switch.'
>For clarification, which number has the unexpected formatting, the value
>pulled directly out of a database table and placed in the cfquery record
>set, the variable that is being ass
value
pulled directly out of a database table and placed in the cfquery record
set, the variable that is being assigned the value, or both?
-Mike Chabot
On Wed, Feb 16, 2011 at 12:29 PM, James Skemp wrote:
>
> Thanks for the clarification questions, Mike.
>
> >What is the data ty
or it was displayed in the stack trace and a cfdump of the
returned information from the initial cfquery call against the sp showed it
there as well. When it works, it's stored to a variable before being passed to
SQL via another query.
> What tag are you using to call the stored procedure in Col
What is the data type of the field in SQL Server? If you run the query in
Management Studio, what do you see for that value? How are you outputting
the value in CF to see the 0E-8 number? What tag are you using to call the
stored procedure in ColdFusion? Which version of MS SQL Server are you
usin
Greetings.
In one of our systems we're upgrading from ColdFusion 7 to CF 8.
While testing a piece of functionality we were getting 0 returned as 0E-8 for a
query using a stored procedure. If the value is greater than 0, there's no
issue.
Updating the procedure to cast the returned value as a
mailto:mdup...@gmail.com]
> Sent: Tuesday, February 08, 2011 12:24 PM
> To: cf-talk
> Subject: Getting information from a cfquery/cfloop to display in a table or
> div
>
>
> Hello,
>
> I'm trying to get information from our database to display in horizontal
>
Try leaving out the
in the your cfloop.
Rick
-Original Message-
From: Michelle Dupray [mailto:mdup...@gmail.com]
Sent: Tuesday, February 08, 2011 12:24 PM
To: cf-talk
Subject: Getting information from a cfquery/cfloop to display in a table or
div
Hello,
I'm trying t
Hello,
I'm trying to get information from our database to display in horizontal form
(table or div). I'm able to pull information from our database with the
following code. Everytime I try to incorporate a table the same information
will display in on each row; different information will not d
hi,
we have a table that has 15000 rows. When we insert data into it, each row is
taking approx 300ms to insert by using the cfquery tag. If we paste the insert
code directly into mysql its taking only 0.09 ms.
We thought this may be due to cfquery having to connect to mysql, or possibly
due
Rick Eidson wrote:
> It's political and we's IT people don't not
> know what were talkin bout...
Oh. One of those deals. (How familiar ;-) Well it looks like Mark has you on
the right path.
Mark wrote:
> While I agree with you about a CSV file in many cases, Leigh,
> sometimes this is useful
Thanks! Looks like I am kind of on the right track... I will read up on this
link...
Rick
-Original Message-
From: Mark A. Kruger [mailto:mkru...@cfwebtools.com]
Sent: Wednesday, January 05, 2011 9:23 PM
To: cf-talk
Subject: RE: CFQuery to mdb
You can seed a database with the schema
> But why does it need to be a full Access database? Providing a delimited
file users could import is simpler and more flexible. As it could be
imported into both Excel and Access.
I asked the same question... It's political and we's IT people don't not
know what were talkin bout...
One of the
-Original Message-
From: Leigh [mailto:cfsearch...@yahoo.com]
Sent: Wednesday, January 05, 2011 7:17 PM
To: cf-talk
Subject: Re: CFQuery to mdb
> just seems like more than I need to do.
I do not think so. It is not like exporting html/excel. An Access database
consists of mo
> just seems like more than I need to do.
I do not think so. It is not like exporting html/excel. An Access database
consists of more than just the data itself (system tables, etcetera). So I am
not sure there is a simpler way. Maybe using ms sql's export tools ..
But why does it need to be a
I want to output the results to a MSAccess database file. I can output the
results to a xls file pretty easily but I need to create a database and save
the results to a table.
I thought about creating a temp blank database and then creating the table,
writing the data to it then copy the database
nice link, thanks will!
>>transferring data from one app to another
>>
>
>
>I'd just use Navicat to transfer the data. No CF needed. Quick and easy.
>
>Will
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Ad
>transferring data from one app to another
>
I'd just use Navicat to transfer the data. No CF needed. Quick and easy.
Will
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430
transferring data from one app to another
>> Hi,
>>
>> I am running the following cfquery which inserts a large amount of
>> rows into a table (approx 2200)
>
>Just out of curiosity, where does y
thanks for providing the details as to what is happening behind the scenes
> On Wed, Nov 10, 2010 at 12:40 AM, Richard White wrote:
> > [query with 6600 cfqueryparams taking 9 seconds vs. 1 for plain
> SQL]
>
> > In understand that adding the cfqueryparam is adding approx 6600
> validations, h
thanks, this solution worked great and is now processing at a steady 2 seconds
> Hey, maybe try something like this? I haven't tested this, but it
> should theoretically be faster
>
>
>
>
>
>
> parentQuestionIDArray[i] & parentLevelArray[i])>
>
>
>
>
>
>
> INSERT INTO
On Wed, Nov 10, 2010 at 12:40 AM, Richard White wrote:
> [query with 6600 cfqueryparams taking 9 seconds vs. 1 for plain SQL]
> In understand that adding the cfqueryparam is adding approx 6600 validations,
> however would it really be the cause of slowing this query down so much?
cfqueryparam i
> Hi,
>
> I am running the following cfquery which inserts a large amount of
> rows into a table (approx 2200)
Just out of curiosity, where does your insert data originate from?
~|
Order the Adobe Coldfusion A
Hey, maybe try something like this? I haven't tested this, but it should
theoretically be faster
INSERT INTO parentquestions
VALUES (,,)
#sqlstring#
~|
Order the Adobe Coldfusion Anthology now!
http://www.
1 - 100 of 1483 matches
Mail list logo
