Where would that be? I don't see it in my local copy (CFMX).
Is that an MX 7 path?
Yeah, if you are running a single server install try the following three
lines...
cffile action=read
file=C:\CFusionMX7\wwwroot\WEB-INF\cftags\META-INF\taglib.cftld
variable=cftags
cfset cftags =
This is for multi configuration, for a single instance configuration,
you can find it in \wwwroot\WEB-INF\cftags\META-INF\taglib.cftld
Rich Kroll
-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 13, 2006 5:16 PM
To: CF-Talk
Subject: RE: cfquery
Our RAD tool here still uses this attribute in a couple of spots. Guess if
it ain't broke, don't fix it.
On 9/13/06, Claude Schneegans [EMAIL PROTECTED] wrote:
cfquery datasource=dsn sql=insert into ...
This is not spaghetti code, this vintage code ;-)
--
I have never seen that before. Crazy!
-b
...
Ben Nadel
www.bennadel.com
Certified Advanced ColdFusion Developer
Need Help?
www.bennadel.com/ask-ben/
-Original Message-
From: Nathan Strutz [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 13, 2006 4:27 PM
To:
According to CfQuickDocs, that is not currently an attribute:
http://www.techfeed.net/cfQuickDocs/?getDoc=cfquery
I wonder what would be the point of that? It'd sure make it harder to read
your SQL and you couldn't use cfqueryparam.
!//--
andy matthews
web developer
certified
You can have some fun looking for hidden functionality in CF by browsing the
tag defs found in
{jrun.installdir}\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\cftags\META-INF\taglib.cftld
Lists out all of the known tags and available attributes for each...
Might be surprised... CFANT
Hey all,
I just saw a code sample, and verified it on the livedocs, basically:
cfquery datasource=dsn sql=insert into ...
Since when did cfquery have a sql attribute, and is this deprecated or
what?
Maybe i'm just dense, but I've never seen it before.
I actually believe this is a carry over
Garza [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 13, 2006 3:50 PM
To: CF-Talk
Subject: re: cfquery sql= ...
You can have some fun looking for hidden functionality in CF by browsing the
tag defs found in
{jrun.installdir}\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\cftags\MET
A-INF
I just saw a code sample, and verified it on the livedocs, basically:
cfquery datasource=dsn sql=insert into ...
Since when did cfquery have a sql attribute, and is this deprecated or
what?
Sure enough, I just found these docs on CF 1:
http://docs.varda.nl/coldfusion/ch7b.htm#_Toc328065209
I actually believe this is a carry over from ColdFusion v1.x
Confirmed.
And I also remember that by that times, one could not reuse the same
query name twice
in the same template! A new query with the same name wouldn't overwrite
the previous one.
So can you imagine having a query in a loop,
cfquery datasource=dsn sql=insert into ...
This is not spaghetti code, this vintage code ;-)
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
Yeah... it's for CF7 in the multi-server configuration.
--
Jeff
Original Message
From: Andy Matthews [EMAIL PROTECTED]
Sent: Wednesday, September 13, 2006 2:17 PM
To: CF-Talk cf-talk@houseoffusion.com
Subject: RE: cfquery sql= ...
Where would that be? I don't see
MS SQL
CFMX 6.1
How do you limit the score of info returned?
or
The equivalent of MySQL
LIMIT #StartRow#, #NumberRows#
To get the first 5 rows:
SELECT TOP 5 ...
To get the second 5 rows:
SELECT TOP 5 ...
FROM ...
WHERE field NOT IN (SELECT TOP 5 ...)
Dave Watts, CTO, Fig Leaf
cfloop list=#ListLoop# Index=Line Delimiters=#strCR#
/cfloop
~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137484
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription:
14 matches
Mail list logo
