He's wrong. And computers don't start at 0. It's up to the
compiler/interpreter to decide what the first index is. In Cold Fusion, the
first index is always 1.
--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 625-9191
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/
Use a subquery:
CFQUERY Name=GetExceptions datasource=#DSN#
SELECT tblEmployees.EmpName, tblEmployees.DeptID
FROM tblEmployees
WHERE tblEmployees.ID NOT IN (
SELECT tblMaster.empid
use subquery.
either NOT IN or WHERE NOT EXISTS
On Mon, 30 Sep 2002, Angel Stewart wrote:
Hey all,
Is there a simple SQL statement that would allow me to select all the
employees...or all the EmpIds that are NOT in the Master table..
So I have tblEmployees and tblMaster.
Basically I
PROTECTED]]
Sent: Monday, September 30, 2002 11:04 AM
To: CF-Talk
Subject: RE: CFQUERY: All employees who haven't entered data...
Use a subquery:
CFQUERY Name=GetExceptions datasource=#DSN#
SELECT tblEmployees.EmpName, tblEmployees.DeptID
FROM tblEmployees
WHERE tblEmployees.ID
Replace LT with . (LT is a CF operator, not a SQL operator)
CFQUERY Name=UserNum Datasource=Source
SELECT User_Name FROM TableName
WHERE (#Time_Start# - User_Data) #Active#
/CFQUERY
-Matt
-Original Message-
From: Joel Blanchette [mailto:[EMAIL PROTECTED]]
Sent:
you must set the user_data as somethign first in the query.
like this...
CFSET Time_Start = #Now()#
CFQUERY Name=UserNum Datasource=Source
SELECT User_Name, User_Data as thisUserData FROM TableName
WHERE (#Time_Start# - thisUserData) LT #Active#
/CFQUERY
im pretty sure this
you must also change the LT
to since like someone else
has replied LT is a cf thingie :)
tw
-Original Message-
From: Joel Blanchette [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 27, 2002 6:17 PM
To: CF-Talk
Subject: CFQUERY
Hello All,
This might be a stupid question, but
Not deprecated; it was removed.
---
Billy Cravens
-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 14, 2002 10:53 AM
To: CF-Talk
Subject: CFQuery Error - No more ConnectString ???
Attribute validation error for tag query.
The tag does not have an
oi Joshua!!
it is ..has to do with the jdbc or sumfin
--
Best regards,
Critter, MMCP
Certified ColdFusion Developer
Crit[s2k] - CF_ChannelOp Network=EFNet Channel=ColdFusion
Friday, June 14, 2002, 11:52:53 AM, you wrote:
JM Attribute
Straight from the help file:
New in ColdFusion MX: The connectString, dbName, dbServer, provider,
providerDSN, and sql attributes, and all values of the dbtype attribute
except query, are deprecated. Do not use them. They do not work, and might
cause an error, in releases later than
-
From: Cravens, Billy [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 14, 2002 11:57 AM
To: CF-Talk
Subject: RE: CFQuery Error - No more ConnectString ???
Not deprecated; it was removed.
---
Billy Cravens
-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]]
Sent: Friday
Wow, why did they remove that? Something to do with JDBC
or what? Why would they remove that feature?
JDBC doesn't support it, apparently, so they had no choice. This is
described in the release notes, I think, as well as within the regular
documentation. Also, if you're using SQL Server
: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 14, 2002 12:07 PM
To: CF-Talk
Subject: Re: CFQuery Error - No more ConnectString ???
Straight from the help file:
New in ColdFusion MX: The connectString, dbName, dbServer, provider,
providerDSN, and sql attributes, and all values
LLC
www.eaglewd.com
[EMAIL PROTECTED]
(304) 622-5676 (Clarksburg Office)
(304) 456-4942 (Home Office)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 14, 2002 12:07 PM
To: CF-Talk
Subject: Re: CFQuery Error - No more ConnectString
Really odd. The thing is, it's really easy to create dynamic
connections in Java using JDBC. Like, it's so simple it ain't even
funny. I do it all the time.
- Original Message -
From: Dave Watts [EMAIL PROTECTED]
Date: Friday, June 14, 2002 10:31 am
Subject: RE: CFQuery Error
Really odd. The thing is, it's really easy to create dynamic
connections in Java using JDBC. Like, it's so simple it ain't
even funny. I do it all the time.
I guess I'd have been more accurate in saying the versions of the Merant
drivers included with CF MX don't support dynamic
It was probably lazy programmers :)
- Original Message -
From: Dave Watts [EMAIL PROTECTED]
Date: Friday, June 14, 2002 10:47 am
Subject: RE: RE: CFQuery Error - No more ConnectString ???
Really odd. The thing is, it's really easy to create dynamic
connections in Java using JDBC
implement the JDBC API, part
of which is what I explained above.
Someone could easily write a custom tag that allows dynamic query
connections, I suppose.
- Original Message -
From: Dave Watts [EMAIL PROTECTED]
Date: Friday, June 14, 2002 10:47 am
Subject: RE: RE: CFQuery Error - No more
LLC
www.eaglewd.com
[EMAIL PROTECTED]
(304) 622-5676 (Clarksburg Office)
(304) 456-4942 (Home Office)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 14, 2002 12:29 PM
To: CF-Talk
Subject: RE: CFQuery Error - No more ConnectString ???
I downloaded
-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 14, 2002 12:57 PM
To: CF-Talk
Subject: Re: RE: RE: CFQuery Error - No more ConnectString ???
It was probably lazy programmers :)
- Original Message -
From: Dave Watts [EMAIL PROTECTED]
Date: Friday, June 14, 2002 10
Absolutely.
---
Billy Cravens
-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 14, 2002 12:06 PM
To: CF-Talk
Subject: RE: RE: RE: CFQuery Error - No more ConnectString ???
So using a servlet I could basically bypass the CFMX Merant drivers
.
---
Billy Cravens
-Original Message-
From: Joshua Miller [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
]
Sent: Friday, June 14, 2002 12:06 PM
To: CF-Talk
Subject: RE: RE: RE: CFQuery Error - No more ConnectString ???
So using a servlet I could basically bypass the CFMX Merant
on Sunday, I could
mess around with this.
- Original Message -
From: Joshua Miller [EMAIL PROTECTED]
Date: Friday, June 14, 2002 11:05 am
Subject: RE: RE: RE: CFQuery Error - No more ConnectString ???
So using a servlet I could basically bypass the CFMX Merant
drivers and
construct my own
You could use:
SELECT DISTINCT city FROM profiles
Alex
-Original Message-
From: Brian Simpson [mailto:[EMAIL PROTECTED]]
Sent: 29 May 2002 10:32
To: CF-Talk
Subject: CFQUERY Question to populate a drop down for search
CFQUERY Question to populate a drop down for search
You could use:
SELECT DISTINCT city FROM profiles
Not forgetting to ORDER BY the query, otherwise it can appear
pseudo-random
Philip Arnold
Technical Director
Certified ColdFusion Developer
ASP Multimedia Limited
Switchboard: +44 (0)20 8680 8099
Fax: +44 (0)20 8686 7911
www.aspmedia.co.uk
: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 29, 2002 5:57 AM
To: CF-Talk
Subject: RE: CFQUERY Question to populate a drop down for search
You could use:
SELECT DISTINCT city FROM profiles
Not forgetting to ORDER BY the query, otherwise it can appear
pseudo-random
Philip
Subject: Re: CFQUERY
Hi,
This is a continuation from yesterday. I have a file index.cfm with the
below code in it:
table border=0 cellspacing=0 cellpadding=0
tr
cfform action=create-list.cfm name=checkboxform
method=POST
cfquery name=GetFontFamily datasource=fontstyles
is a non numeric field
-Original Message-
From: phumes1 [mailto:[EMAIL PROTECTED]]
Sent: donderdag 7 februari 2002 17:26
To: CF-Talk
Subject: Re: CFQUERY
Hi,
This is a continuation from yesterday. I have a file index.cfm with the
below code in it:
table border=0 cellspacing=0 cellpadding=0
tr
Hi,
This is a continuation from yesterday. I have a file index.cfm with the
below code in it:
table border=0 cellspacing=0 cellpadding=0
tr
cfform action=create-list.cfm name=checkboxform method=POST
cfquery name=GetFontFamily datasource=fontstyles
SELECT sti, ID
While I've not encountered that problem myself, I believe you'll want to go
into the CF Admin under the ODBC settings and enable the Long Text
Retrieval Settings and adjust the Long Text Buffer Size as appropriate.
Ken
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
That did it. I guess when the system has been up for a while, I simply
forget about the admin functions.
Thanks a million.
John
-Original Message-
From: Ken Wilson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 10:38 AM
To: CF-Talk
Subject: RE: CFQUERY NOT RETURNING
, no real experience with this issue. Just a couple of things I've
heard mentioned on the list.
Ken
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 10:44 AM
To: CF-Talk
Subject: RE: CFQUERY NOT RETURNING COMPLETE RESULT
That did it. I
This is not a query of queries. Change the 2nd CFQUERY to
CFQUERY Name=PendingProspect DataSource=#application.DSN#
SELECT intCustomerID from tblprospectdetails
where intCustomerID IN #QuotedValueList(CustomerExist.intCustomerID)#
and
Depending on what you want to do, you can probably do One
: Wednesday, January 30, 2002 4:57 PM
Subject: RE: cfquery from a cfquery
This is not a query of queries. Change the 2nd CFQUERY to
CFQUERY Name=PendingProspect DataSource=#application.DSN#
SELECT intCustomerID from tblprospectdetails
where intCustomerID IN #QuotedValueList(CustomerExist.intCustomerID
-Talk
Subject: Re: cfquery from a cfquery
hihi..
thanks for yr reply.
sorry.. i dont know how to use request.DSN..
so how do i declare it..?
and.. if i use request.DSN...
does it mean i dont need to use CFLOCK..?
cheers
han
- Original Message -
From: Pascal Peters [EMAIL PROTECTED
Han,
To do a query from a query, you'd do something like this:
CFQUERY NAME=Query DATASOURCE=Datasource
SELECT Something
FROM SomeTable
/CFQUERY
THEN
CFQUERY DBTYPE=QUERY NAME=Query2
SELECT Something
FROM Query (The first query name goes here)
/CFQUERY
Does this help?
J.
-Original
Try with OLEDB it is like ODBC but more fast.
Let me now ;-)
Gianluca Pinelli
- Original Message -
From: Rudy Rustam [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, January 09, 2002 10:50 AM
Subject: CFQUERY connect to MSSQL
Is there a way to use cfquery connect to
what is a cascading delete?
In a parent-child data relationship, you can specify that deleting a
parent record deletes all of it's associated child records. It makes
sure your database maintains its referential integrity. It also makes
deleting records from multiple tables a doddle, as you just
Is there a way to do multiple delete queries in one cfquey tag. and I
need to surround it in a transaction. How can I do this?
No, but if you supply a where clause, you can delete everything from one
table in one go (and if you have cascading deletes, just go for the
parent-most records).
what is a cascading delete?
- Original Message -
From: Aidan Whitehall [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, December 17, 2001 12:45 PM
Subject: RE: CFQUERY
Is there a way to do multiple delete queries in one cfquey tag. and I
need to surround
Is there a way to do multiple delete queries in one cfquey tag.
No
Actually, multiple deletes/inserts/updates within one query tag do work
whether it's intended to or not. Just stick the seperate SQL statements
right in there and go for it.
Now, anybody know if this is intended or just an
Message-
From: Ken Wilson [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 17, 2001 2:39 PM
To: CF-Talk
Subject: RE: CFQUERY
Is there a way to do multiple delete queries in one cfquey tag.
No
Actually, multiple deletes/inserts/updates within one query tag do work
whether it's intended
http://webreference.com/authoring/style/sheets/layout/advanced/
check out the links under further reading.
Steven D Dworman
-
Web Consultant
Systems Administrator
ComSpec International - http://www.comspec-intnl.com
-
EMPOWER-XL ***Software for Higher Education***
http://www.empower-xl.com
-Original Message-
From: Steven Dworman [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 19, 2001 9:52 AM
To: CF-Talk
Subject: RE: cfquery and two column output
http
You want to split 30 records into 15 in each column?
If that is what you are saying then, this might help.
Let's say your query is named 'q' and it has columns 'title' and 'body' with
30 records total.
cfset cols=round(q.recordcount/2)
table
tr
td valign=top
cfloop from=1 to=#cols# index=i
Are any of the form values null?..check the versions of the ODBC drivers
(in control panel) on the 2 machines - I bet there is a difference.
--
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
Yes there are null values but the db will accept them, and
I've also set default params.
I'll investigate the ODBC drivers, though. But doesn't the CF install
update these?
Tristram Charnley
~~
Get the mailserver that powers this list at
No its not the ODBC drivers.
Any other ideas?
Tristram Charnley
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives:
select *
from sysobjects
where type = 'u'
order by name
Mark Stewart [EMAIL PROTECTED] on 09/06/2001 02:23:36 PM
Please respond to [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
cc:
Subject: RE: cfquery Question
There is a SqL Server stored procedure that will describe a database
Srocedures section.
Tim
- Original Message -
From: Mark Stewart [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, September 06, 2001 15:23
Subject: RE: cfquery Question
There is a SqL Server stored procedure that will describe a database for
you. Off the top of my head, I can't
What your looking for is:
CFQUERY Name=myTables Datasource=yourDataSource
SELECT *
FROM sysobjects
WHERE xtype = 'U'
/CFQUERY
Type U is user tables and S is system tables. There are others, but I'm not
sure what they are.
Steven Durette
MGR. - Engineering Construction System Support
Database
There is a SqL Server stored procedure that will describe a database for
you. Off the top of my head, I can't remember the name of it but you can
find it in books on line.
If I can remember the name, I'll pass it along.
Mark
-Original Message-
From: Edward Chanter [mailto:[EMAIL
Like what?
What exactly are you looking for? CREATE, ALTER, AND DROP work...
-Original Message-
From: Pooh Bear [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 30, 2001 2:26 PM
To: CF-Talk
Subject: CFQUERY question
hey can i do Full SQL programming inside cfquery tags? or is it
hey can i do Full SQL programming inside cfquery tags? or is
it limited to inserts updates, and such?
No, on most platforms you should be able to write whatever SQL batch you
want within a CFQUERY.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202)
Does it return an error in CF?
Some thoughts:
Make sure that the ID field is a NUMBER field
and the ID # is unique.
-Original Message-
From: JL [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 25, 2001 9:46 AM
To: CF-Talk
Subject: CFQUERY Update..
Hi all,
I am trying to update a
I have seen this behavior before under heavy load without using
transactions, but it did not happen every time like you are seeing.
An update will of course execute but not change the data if the where clause
does not match anything. If you can copy the same query into Query Analyzer
that shows
Any idea what this error means?
CFQuery
Retrieval of cached query failed
At a stab, it means that it failed to get a cached version of the query g
Seriously though, it looks like the cache has gotten corrupted on that
query - re-cache it
Philip Arnold
Director
Certified ColdFusion
Any idea what this error means?
CFQuery
Retrieval of cached query failed
I suspect it means that the CF server has used all available memory, and is
beginning to fail.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
Does it output in order when you just view the cf page? Could it be
something to do with the link into excel. Perhaps it has trouble with some
data types.
-Original Message-
From: Winston Sia [mailto:[EMAIL PROTECTED]]
Sent: 02 March 2001 07:33
To: CF-Talk
Subject: cfquery table data
You could loop round the commma delimted list of column names given by
query_name.ColumnList.
-Original Message-
From: Winston Sia [mailto:[EMAIL PROTECTED]]
Sent: 28 February 2001 08:16
To: CF-Talk
Cc: [EMAIL PROTECTED]
Subject: Fw: CFQuery of database tables
This is a multi-part
Try the CF functions ListContains or ListFind. We dealt with the very same
issue and used one of these two to solve it, but I don't remember which.
This works as long as your database field is exactly a CF list format.
Brian
-Original Message-
From: Joby Bednar [mailto:[EMAIL
cfquery ...
select
whateveryouwanttoselect
from
tablename
where
idnumber = #whatever#
/cfqury
-Original Message-
From: Joby Bednar [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 07, 2001 3:13 PM
To: CF-Talk
Subject: CFQUERY question
I've got a field in a
Hello everyone. I am running into a problem with my cfquery tag and I
was wondering if anyone out there could give me a hand with this.
Basically I am querying a database that has a series of records. But
when I output the information from the database I only want to select
the newest
Thats Sql Server only (access too?) . cfquery maxrows=1 might be better
Justin
cfquery name="OutputUnitContent" datasource="camp" dbtype="ODBC"
Select top 1 *
from UnitPages
where ArticleUnit = '#form.units#'
order by ArticleDate DESC
/cfquery
This will literally
Thats Sql Server only (access too?)
Access too.
**
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender
thy [mailto:[EMAIL PROTECTED]]
Sent: 09 January 2001 12:32
To: CF-Talk
Subject: RE: cfquery
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.co
cfquery name="OutputUnitContent" datasource="camp" dbtype="ODBC"
maxrows="1"
Select *
from UnitPages
where ArticleUnit = '#form.units#'
order by ArticleDate DESC
/cfquery
~Simon
Simon Horwith
Allaire Certified ColdFusion Instructor
Certified ColdFusion Developer
Fig Leaf Software
1400
In the cfoutput tag you can specify the maximum number of rows to show --
also if you use cfoufput without a query attribute, it will only output the
first row.
Lisa Haas
The Kennedy Center
-Original Message-
From: John Cowie [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001
Set maxrows to 1
- Original Message -
From: "John Cowie" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Monday, January 08, 2001 1:59 PM
Subject: cfquery
Hello everyone. I am running into a problem with my cfquery tag and I
was wondering if anyone out there could give me a
BAH, you don't need to specify a date it was entered in the first place
(unless u need it for some other reason). just make sure you have some kind
of AUTO ID or increment for each record (u should anyways). and in your
query, let it select the record with the highest Auto number (which is
1) Set up a server in a development area. Make sure noone else is using it.
2) Restart it to clear out any random memory buggers.
3) Start Perfmon and watch memory usage.
4) Start running your cached queries one at a time.
5) Compare memory usage to what your "big man" thinks is reasonable.
6)
Cache it. Is your boss not willing to step up to the plate and add a little
memory (if the system needs it). It increases performance and reduces the
time needed to load the page. All which would make the user/client happier.
I think that question is a no brainer.
- Original Message -
Seems like something whose practicality can be easily tested. Pick a
commonly run query and set it up to cache. In CF Admin tell CF to cache up
to 10 unique queries. Watch memory usage on the server. If memory usage is
still well within limits, try setting the limit to 20. Repeat as desired.
Store each point (x,y) as one record in the db:
Table Points
x integer
y integer
Retrieve them via a simple CFQUERY select statement:
cfquery name="qPoints"
select x,y from Points where...
/cfquery
Then use the ValueList function to make a list of all of the x values
If I have a form and post a value - say cfinput name="domain"
required="yes" message=" Please enter FQDN" to a receiving
page with a query as:
cfquery name="get_handle" datasource="testds"
select handle, domain, tld
from domains
WHERE domain='#form.domain#'
/cfquery
This works
Yep. You're using an older SQL ODBC driver that released before SQL 7. SQL
6.5 had a 255 character limit in varchar fields. Update the driver.
Jim
- Original Message -
From: "Mike Dorr" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, October 03, 2000 5:18 PM
CF Docs on the Subject are as follows:
"Optional. Specifies the maximum number of rows to fetch at a
time from the server. The range is 1 (default) to 100. This
parameter applies to ORACLE native database drivers and to ODBC
drivers. Certain ODBC drivers may dynamically reduce the block
I get to 100 all the time. For example, I use Verity to get
a list of Record IDs whose data matches my search term, and
then use SQL with CFQUERY and BLOCKFACTOR = 100 to filter
the VERITY result set.
Of course, in this case any savings in having BLOCKFACTOR greater
than 100 is probably in the
Project Manager
Thoughtbubble Ltd
--
-Original Message-
From: Kay Smoljak [mailto:[EMAIL PROTECTED]]
Sent: 27 September 2000 03:01
To: CF-Talk
Subject: Re: CFQUERY/CFSTOREDPROC error
On Tue, 26 Sep 2000 18:01:08 +0100, Andy
take a look at the DC CFUG files for july 2000, on www.figleaf.com. Dave
Watts gave an interesting seminar on WAP and how to utilize it with CF.
Amongst the topics covered and coded, was keeping deck sizes small when
looping through a larger query.
~Simon
-Original Message-
From:
Just a guess, but try a value other than ID, as it is often a reserved word
and may cause problems.
Jim
- Original Message -
From: "Andy Ewings" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Tuesday, September 26, 2000 1:01 PM
Subject: CFQUERY/CFSTOREDPROC error
I have a
On Tue, 26 Sep 2000 18:01:08 +0100, Andy Ewings [EMAIL PROTECTED]
wrote:
I get the following error message:
CMemoryException: unknown cause
PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying
Thank you. These are both SQL Server 7 databases. This is great.
Thanks.
-Original Message-
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 22, 2000 1:48 PM
To: [EMAIL PROTECTED]
Subject: RE: CFQUERY, using two different DBs question - Newbie ;)
cfquery
Is this SQL? If so the datasource is not database dependent (although you
should specify a default database when setting up the odbc datasource). It
is only server dependent.
Therefore, assuming that AClient is the default database for the ODBC DSN
then I think you need the following:
INSERT
cfquery name="Insert" DATASOURCE="AClient" username="sa" password=""
INSERT Customer_Kit
SELECT *
FROM dbo.ProdCenter.Task
WHERE 1 = 1
AND Task.Task_ID IN (#PreserveSingleQuotes(Form.Task_Selected)#);
/cfquery
I am trying to move some data from one DB,table (ProdCenter,Task)
FROM
Claude
The template is parsed, then executed.
The query (and any other) statements are issued as they are encountered.
Any queries within a CFIF are only executed if the CFIF is true.
You can prove this by constructing a syntactically correct (for CF)
query, but one that generates an SQL
Hi,
as far as I know queries are executed, when they are encountered in the
template. so if you put them on the top of the page, first all the
queries are executed. You can verify this by looking at the debug
output.
I would recommend to break the template to small pieces and put each
section
I've never had a problem with cfquery but I have noticed that if I
cflocation directly after I drop a cfcookie, it doesnt set the
cookie.
Jon
Ken Wilson wrote:
I'm getting a few random reports of data loss on an Intranet site and need
to get some input on things I might investigate. I'm
Hubert,
if you are using MS-Sql server "text" is a datatype, so you might run into
problems there
and your code
cfquery Name="Select_vals" Datasource="Jokes"
Select JokeTitle from Jokes_Table (dont use text for a table name, its a
keyword)
/cfquery
Select Name="S_Options"
cfoutput
the "text" is a keyword in access. so the error
-Original Message-
From: Hubert Earl [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 25, 2000 2:06 AM
To: [EMAIL PROTECTED]
Subject: CFQUERY problem
Hi,
I'm trying to build a dynamically filled drop down select box. However, I
keep
--2E9BE6F4AE52820C8132DE58
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Text is a reserved word. You need to change the name of the table.
Annette
Hubert Earl wrote:
Hi,
I'm trying to build a dynamically filled drop down select box. However, I
Best way to do it would be in a Stored Procedure, wrapped in a SQL
transaction.
-J
-Original Message-
From: Jim Taylor [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 07, 2000 7:56 AM
To: Cf-Talk@Houseoffusion. Com
Subject: cfquery vs. cftransaction
Let me try this again please.
Is
On 4/7/00, Jim Taylor penned:
Let me try this again please.
Is this the best way to handle a 2 table insert ?
The main reason to run a cftransaction is if the results from one
query are going effect the entry into another.
For instance:
1. Someone places and order and the order is written to
501 - 593 of 593 matches
Mail list logo