happens on col5 search when I search string characters like 'abc'. Are
there any functions in coldfusion that help with this kind of scenarios?
cfquery name=getinfo dbtype=query
SELECT
col1, col2, col3, col4, col5
FROM
getinfo
WHERE
(lower(col2) like lower(cfqueryparam cfsqltype
terms are not
numeric then you want to skip the column all together. You need to check that
it is both numeric and an integer.
cfquery name=getinfo dbtype=query
SELECT
col1, col2, col3, col4, col5
FROM
getinfo
WHERE
(lower(col2) like lower(cfqueryparam cfsqltype=cf_sql_varchar
value
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
I like the Mega mind response...
you were right, I was less right
On Wed, Aug 21, 2013 at 5:28 PM, Ron Thigpen r...@fuzzsonic.com 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
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?
Terry
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 function to wrap single quotes around
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
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... I'm
Dave... I'm surprised. Wouldn't you think that CFQueryParam would be the
better way?
Where stuff in (cfqueryparam value=#form.stuff# cfsqltype=appropriate
type list=yes separator=, /)
Yes, that would absolutely be a better way, of course! I didn't even
pay attention to the fact that this
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 dwa...@figleaf.com wrote:
Dave... I'm surprised. Wouldn't you think that CFQueryParam would be the
better way?
Where stuff in (cfqueryparam
... 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... I'm surprised. Wouldn't you think
: 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 similar feeling regarding
To: cf-talk
Subject: RE: Using IN() within a cfquery statement
Dave... I'm surprised. Wouldn't you think that CFQueryParam would be the
better way?
Where stuff in (cfqueryparam value=#form.stuff# cfsqltype=appropriate
type list=yes separator=, /)
Steve
-Original
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 declining
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
coldfusiondocs.com not working properly either, so seems likely.
On Mon, Aug 19, 2013 at 4:26 PM, Carl Von Stetten
vonner.li...@vonner.netwrote:
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
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
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 ejohn...@directalliance.com wrote:
Really odd issue we've been having.. We have a scheduled task that hits
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
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
Has anyone updated the java version by any chance
Russ Michaels
www.michaels.me.uk
On 9 Jul 2013 23:11, Chris Johnson ejohn...@directalliance.com 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
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
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
wrote:
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
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.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag
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.amazon.com/Adobe-Coldfusion-Anthology/dp
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
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
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 steph...@iu.edu wrote:
A related question: I have a table of towns that has ~20,000 records. The
dataset I need has the
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 on a
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
On Sat, Jan 5, 2013 at 8:25 AM, Russ Michaels r...@michaels.me.uk 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
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 spooled to
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
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
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 then
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
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
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:
-
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
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
: 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 is set to
VARCHAR(MAX). Data is being
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
place every time).
I
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 Update
I have a client who is essentially entering a document
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
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,
Thanks Russ, Scott@fussionapps has been kind enough to give me a nice code..
The little challenge was that the columns were not fixed and query results are
completely dyanmic...
Just posting it here for reference
CFLOOP query=qry_data
CFQUERY name=qry_insert datasource=#request.dsn
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
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.
cfset mydatetime= DateFormat(Now(), '-mm-dd')
cfquery name=data datasource=mydata
SELECT EXPIRATIONDATE
FROM COUPONS
WHERE EXPIRATIONDATE
WHERE EXPIRATIONDATE = cfqueryPARAM value = #mydatetime # CFSQLType =
'CF_SQL_VARCHAR'
Sent from my Samsung Galaxy SII
On Mar 4, 2012 7:54 AM, Barry Mcconaghey bmcconag...@gmail.com wrote:
Hello.
I'm trying to get this cfquery to match a database field
EXPIRATIONDATE(date) 2012-3-04 and do
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 = cfqueryparam value = #now()#
CFSQLType
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
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 for you
Thanks for your assistance
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
Why not just do this:
data = {};
data.query = somequery;
data.whatever = ice cream;
On Wed, Jul 20, 2011 at 7:40 AM, Richard White rich...@j7is.co.uk wrote:
Hi,
is there any way to add custom variables to cfquery metadata.
for example: i know i can add them as follows:
mt
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 just like to call
I'm doing a look up like this:
cfquery datasource=#DSN# name=GetResults
SELECT Formation, Play, BallCarrier, YardsGained, Result
FROM PlaysCalled
WHERE (((PlaysCalled.Formation)=#Form.Formation#) AND
((PlaysCalled.Play)=#Form.Play#) AND
((PlaysCalled.BallCarrier)=#Form.BallCarrier
Yes, and if this is form input, you should be using cfqueryparam anyway.
Please see the news for Sony's latest data hack, which was simple web-based
SQL injection. cfsqltype will need to match column datatype in each case.
cfquery datasource=#DSN# name=GetResults
SELECT Formation, Play
of the BallCarrier column? Would
cfsqltype=CF_SQL_VARCHAR be more appropriate?
HTH,
Carl
On 6/10/2011 6:14 AM, Jim Brundle wrote:
I'm doing a look up like this:
cfquery datasource=#DSN# name=GetResults
SELECT Formation, Play, BallCarrier, YardsGained, Result
FROM PlaysCalled
WHERE
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
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
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
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
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 t3.ID
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 turned
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
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 it's turned off
copied the bit
that I need to show.
Anybody seen this before?
Thanks,
Dan Blickensderfer
cfquery name=lookupcart datasource=#application.datasource#
username=#application.username# password=#application.password#
select rec_id
from order_items
where rec_status = 'T' and session_uuid
the bit
that I need to show.
Anybody seen this before?
Thanks,
Dan Blickensderfer
cfquery name=lookupcart datasource=#application.datasource#
username=#application.username# password=#application.password#
select rec_id
from order_items
where rec_status = 'T' and session_uuid
cfquery 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
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:
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
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
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
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
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 ColdFusion?
cfquery
, the 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 jsk...@wisbar.org wrote:
Thanks for the clarification questions, Mike.
What is the data type
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 assigned the value, or both?
Probably the former
formatting, the 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?
Probably the former - ColdFusion's interpretation of the value from SQL /
the value in the cfquery record set, since the resolution
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 same thing as SQL
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.
On CF 8, we instead get:
0E-8
So, updated CF 8 SQL Driver perhaps? Either way, unless there's
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
will not display in each
cell. Any ideas?
cfquery name=member datasource=ASAGOV
SELECT fname, lname, Starship, Rank
FROM Star_Trek
where rank 'Captain' AND
rank 'Science Officer'
/cfquery
cfloop query=membercfoutput
#fname# #lname#, #starship#
/cfoutput/cfloop
Try leaving out the cfoutput/cfoutput
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
/cfoutput
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 to get information from
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
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
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
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
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
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
-
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 more than just the data itself (system
sqlstring = '#sqlstring#,(#questionIDArray[i]#,
#parentQuestionIDArray[i]#,#parentLevelArray[i]#)'
/cfif
/cfloop
!---run query. manually add first line since we didn't loop over it.
---
cfquery name=insertData datasource=dbname
INSERT INTO parentquestions
VALUES (cfqueryparam value
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, however
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 your insert data originate from
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!
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!
name=sql type=string required=yes
cfquery datasource=#request.selecteddns#
#sql#
/cfquery
/cffunction
Is there a workaround for this?
Thanks,
Nikki
~|
Order the Adobe Coldfusion Anthology now!
http
try and change the following
cfquery datasource=#request.selecteddns#
#PreserveSingleQuotes(sql)#
/cfquery
From: Nkonye Oyewusi noyew...@hotmail.com
To: cf-talk cf-talk@houseoffusion.com
Sent: Wed, November 10, 2010 11:33:27 AM
Subject: Strange issue
/cfloop
!---run query. manually add first line since we didn't loop over it.---
cfquery name=insertData datasource=dbname
INSERT INTO parentquestions
VALUES (cfqueryparam value=#questionIDArray[1]# cfsqltype=cf_sql_bigint
maxlength=20,cfqueryparam value=#parentQuestionIDArray[1]#
cfsqltype
1 - 100 of 1675 matches
Mail list logo