Aidan,
I wonder why you tried the ugly version first. Forget the ampersands, forget
SetVariable. Maybe forget the vairables scoping as well. Just do this:
CFSET "variables.abc#Evaluate(somevalue + 1)#" = "whatever"
Now doesn't that look much MUCH nicer than this:
CFSET variables.Result =
Hi CV,
Sure it supports them, but I seem to recall it has its own SQL syntax. Best
to use MSAccess' query builder, and then take a peek at the SQL that it
creates. It should give you the idea.
Let is know what you find,
Lee Bjork Borkman
Bjork.Net - ColdFusion Tags by Bjork
Hi Norman,
You could always try my SourceBrowser. It shows the source, and a whole lot
more, including parsing/displaying comments, and performing various software
metrics.
Much nicer than messing with HTTP headers ;-)
Bye now,
Lee Bjork Borkman
Bjork.Net - ColdFusion Tags by Bjork
Hi Kev,
When I want expiry control finer than one day, I use TWO cookies, one to store
the value and one to store the expiry date OF THE VALUE (not the cookie). In
other words:
Cookie1: Name="UserName" Value"bjork" Expiry="never"
Cookie2: Name="UserExpiry" Value=#dateadd(15, 'n', now())#
Hi Kev,
As far as I know, there is no universal way to do this in SQL.
In CF you can do this:
CFQUERY NAME="testquery" DATASOURCE="workflow"
SELECT * FROM Staff
/CFQUERY
CFOUTPUT QUERY="testquery" STARTROW="#randrange(1,testquery.recordcount)#"
MAXROWS="1"
#FirstName#
Guys,
this will only work if the IDs start at 1, and there are no missing IDs.
Also, the #s are unnecessary in your CFSET.
Have fun,
Lee.
Bjork.Net
[EMAIL PROTECTED] (Brian bouldernet) wrote:
x = total available records
cfset RandomCount =
Kev,
Don't look right past my previous answer. It works like a charm. It doesn't
care what your IDs are called, or how they are sequenced. For best results,
cache the query.
As I said before, there's no way to do this is SQL alone.
So do this:
CFQUERY NAME="quotes" DATASOURCE="workflow"
Hi Will,
There are two real possibilities:
1) stick with autonumbering. Wrap your insert and a SELECT Max(ID) inside a
single CFTRANSACTION. Vaguely ugly.
2) Create your own Primary Key.
2a) Create your own incremental ID from a separate table. Needs
CFTANSACTION.
2b) Create an incremental
Yes. Why do you ask?
-
"Sree@bigbuzz" [EMAIL PROTECTED] wrote:
This is a multi-part message in MIME format.
--=_NextPart_000_0011_01C024B4.0006E920
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
HI,
Is
in the CommentType, so this should probably also be an array of strings.
You can test drive this approach by grabbing my SourceBrowser from
http://bjork.net.
Thanks all,
Lee Borkman
3rd World
Get free ema
Hey Guys!!
I was born, raised, and now currently live and work in one of those 3rd World
countries you are making light of. Kindly recall that this is an
international mailing list.
Lee Borkman
Sydney, Australia
ps, there was a discussion going on about CF documentation standards, but I
seem
7. World domination.
What do you all reckon???
Lee Borkman ([EMAIL PROTECTED])
http://bjork.net, ColdFusion Tags by Bjork
Get free email and a permanent address at http://www.netaddres
f my fuses:
!---@ Description: Retrieves directory information into a query ---
!---@ Designer: Lee Borkman ([EMAIL PROTECTED]) ---
!---@ Programmer: Lee Borkman ([EMAIL PROTECTED]) ---
!---@ Thanks: Uses Nate Weiss' QuerySort tag if available. Thanks Nate ---
!---@ Attributes:-- [directory]: A
.
Be good.
Lee Borkman ([EMAIL PROTECTED])
http://bjork.net ColdFusion Tags by Bjork
---
Date: Fri, 25 Aug 2000 01:13:48 -0400
From: "Fred T. Sanders" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: SourceBrowser, FusionDoc, SoftwareMetrics !!!
the first hurdle before worrying about which browser we
prefer?
Any thoughts?
Lee Borkman ([EMAIL PROTECTED])
http://bjork.net, ColdFusion Tags by Bjork
"Hal Helms" [EMAIL PROTECTED] wrote:
But i LIKE to squat! And I do it so well. OK, I'm giving a talk on Fus
for your interest,
Lee Borkman
Get free email and a permanent address at http://www.netaddress.com/?N=1
--
Archives: http://www.mail-archive.com/cf-talk
Hi John,
My intention here is to devise a documentation syntax that will be applicable
to ALL ColdFusion development, not just FuseBox. I personally love FuseBox,
but it has its detractors.
My feeling was that the original FuseDoc header used by Hal was too
inflexible. I wanted to add other
Hi PC,
This is probably to do with the MIME-types config of your webserver. The
web-server is probably trying to RUN the exe on the server. Yuck!!
Take a look in your mime.types file, or in your server admin. Look for which
file extensions are associated with CGI (probably EXE, BAT and CGI).
18 matches
Mail list logo