This is the error I am getting below even though weather_xml has been
defined in the application.cfm page
i.e. CFSET APPLICATION.weather_xml =XMLParse(cfhttp.FileContent)
ERROR IS
Element WEATHER_XML is undefined in APPLICATION.
My application.cfm page is
cfset
hi thanks very much for these
richard
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
Dealing with time zones was a major PITA a recent project I did.
Eventually I decided to store all dates in UTC and format them as needed
for the current user. This made it much easier to deal with those
dreaded daylight savings time shifts, when local time jumps around and
offsets just don't cut
Hello list,
I've done dynamic ID's before in .net and xml. I can't seem to figure out
how to do it in CF. Here's what I want to do:
- Query the database with the ID's.
- Sort the ID's in proper numerical order
- Grab the last ID (largest number which will be
If someone has a better idea for a unique ID, I'm open to suggestions.
Well, if the id is for records in a table, how about using an auto
counter field?
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please
If you need an absolute unique id that isn't tied to a database, feel free
to use the createUUID() function. Otherwise, what you're asking for can be
done via SQL... so... not sure why this is overcomplicated. Do you have a
unique situation? care to explain?
On Dec 20, 2007 9:23 AM, Rick
What exactly are you trying to do?
Robert B. Harrison
Director of Interactive services
Austin Williams
125 Kennedy Drive, Suite 100 Hauppauge NY 11788
T : 631.231.6600 Ext. 119
F : 631.434.7022
www.austin-williams.com
Great advertising can't be either/or... It must be .
-Original
Your db platform doesn't support autonumber?
Steve Cutter Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
_
http://blog.cutterscrossing.com
Rick Sanders wrote:
Hello list,
I've done dynamic ID's before in .net and xml. I
cfquery
declare @newid int
select @newid = max(id) from Members
if @newid is null
begin
set @newid=1
end
else
begin
set @[EMAIL PROTECTED]
end
INSERT INTO Members ...
/CFQUERY
I know of someone who uses a Sequence table for the ID functions:
Sequence table:
table_name (varchar)
last_sequence (int)
next_sequence (int)
Query the table based on table name get the next_sequence and then
update
The sequence table after the insert
-Original Message-
From: Rick
The database does support autonumber, but this is a legacy app and database.
Also, there are many times where autonumber isn't useful because when you
delete a record, the database re-numbers everything changing the ID which we
didn't want.
Rick Sanders
Webenergy
Canada: 902-401-7689
USA:
I'd let the database create the number. But anyway, you can do it like this:
cfquery name=getnumbers datasource=#variables.dsn#
SELECT max(tableID) as Lastnumber from tablename
/cfquery
cfset newID = getNumbers.Lastnumber + 1 /
I have functions where i do this, but generally you'd be best to
How about an Identity field (in MS SQL)
Or alternatively CreateUUID() ?
On 20/12/2007, Rick Sanders [EMAIL PROTECTED] wrote:
Hello list,
I've done dynamic ID's before in .net and xml. I can't seem to figure out
how to do it in CF. Here's what I want to do:
- Query the
Hey guys,
Yup, this is a unique situation, it's a new application on top of an old
database built in Pervasive SQL. The Primary key holds ID numbers that
aren't auto generated.
The legacy app that sat on top of it was Tango 2000, and the way the ID was
done was by querying the database, sorting
Or, if you really need to do it the way you describe, the SQL could look
like this:
-- SELECT A NEW ID
SELECT Max(idField) + 1 FROM myTable
But yeh, if you can set an auto id in the db I'd go with that.
Dominic
On 20/12/2007, JediHomer [EMAIL PROTECTED] wrote:
How about an Identity field (in
CFFILE reads the entire file into memory before acting on it. Even appending to
the file requires it be read into memory first. That's where your memory usage
is likely coming from -- though not sure why it's not being freed in a timely
manner.
Chris
On Dec 17, 2007, at 7:58 PM, Jonathon
You need to set the sortORD for the remaining values to greater than the
last important item for that query. If you had 3 item that were important,
you would need to set the sortORD to 4 for the rest of the items, that would
allow the secondary sort to actually sort.
-Original Message-
The database does support autonumber,
What database is it?
there are many times where autonumber isn't useful because when you
delete a record, the database re-numbers everything
Really? I've never seen such a database that re-numbers auto numbers.
--
___
CF8 and MS SQL 2000
I would like to implement Google-esque searching on our Intranet against our
database.
To do this I enabled Full-Text on the table I want to search (customers) and
use a query like this:
SELECT * FROM Customer where CONTAINS (*, ' search ')
This works somewhat
Has anyone had problems using cflayout/cfwindow/cfgrid together? Everything
loads fine, but I have a cfgrid in a cfwindow off of a page using cflayout.
When you drag the window up into the browser, the cfgrid in the popup gets
hidden behind the cflayout. It will work if you use html format
I have this trouble with any flash object. The flash object always stays in
front of my CFWINDOW. Are you using a flash grid?
-Original Message-
From: Chad Baloga [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 20, 2007 7:07 AM
To: CF-Talk
Subject: CFGRID in CFWINDOW behind CFLAYOUT
Here is the situation:
There is a conference in March. The customer wants to have an application
where when the registrants come in they can immediately print out their
information, tickets to events (maybe up to 5 events at the most) and their ID
tag (name and logo) First of all we need to
In my case, the flash formatted cfgrid which is in a popup cfwindow, goes
behind the cflayout on the main browser window when dragged around
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Yup, this is a unique situation, it's a new application on top of an old
database built in Pervasive SQL. The Primary key holds ID numbers that
aren't auto generated.
I think I see the situation and you're approach is valid but long winded ;).
You can insert a record with a new ID with one
I think it indexes individual columns only, and treats them as separate
fields... It does not combine column1 with column2, so firstname=john,
lastname=doe will not match john doe, but [EMAIL PROTECTED] will
match. Apparently (with SQL 2000 anyway) you cannot index computed
columns (first name +
True, but willing to take the risk.
I actually just had one of our systems adjusted for timezone differences and
need to see how he went about it. I know he used the Oracle TZ table and
some pointers or data from that table stored in one of the applications
tables so that queries could then
Beware of doing it this way... You will need cftransaction or some other
way of ensuring that the ID is unique. Consider the situation where 2
inserts from 2 different people are happening nearly simultaneously. The
second request for the max(ID) could occur before the first is inserted
-mark
Gaulin, Mark wrote:
dreaded daylight savings time shifts, when local time jumps around and
offsets just don't cut it. (My project was CF and java, and most of the
why would using offsets not work w/DST changes? if your server's tz isn't UTC
then storing datetimes as epoch offsets is probably
Interesting.
Updater 7, huh? Isn't it about time for JRun 5? :)
~Brad
-Original Message-
From: Matthew Williams [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 19, 2007 9:22 PM
To: CF-Talk
Subject: Re: JREE Servers (was Session Management - sticky sessions)
But wait! Adobe just
Rick,
Autonumber doesn't re-number existing ids (does it??) ... Although it does
mean that the numbers are not tightly sequential (there will be gaps).
-mark
-Original Message-
From: Rick Sanders [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 20, 2007 8:47 AM
To: CF-Talk
Subject:
I would like to have a user fill out a form.
So say they start filling it out and decided they want to leave with out
submitting the form.
Is there any way to pop a javascript alert saying something like please fill
out the form or call this phone number??
http://calendar.viviotech.net/
Steve Cutter Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
_
http://blog.cutterscrossing.com
Rob Parkhill wrote:
Richard,
http://www.cfkalendar.com/
or
http://calendarinfusion.riaforge.org/
pop up an alert on the onunload event if the form isn't filled out properly?
http://www.w3schools.com/jsref/jsref_onunload.asp
On Dec 20, 2007 9:19 AM, Chad Gray [EMAIL PROTECTED] wrote:
I would like to have a user fill out a form.
So say they start filling it out and decided they want to
Aaron Rouse wrote:
True, but willing to take the risk.
if cf touches any of your datetimes along the way, then you've fallen into tz
hell. if your servers are in tz that implement DST scan your cf touched UTC
datetimes you won't find *any* on the cusp of DST, they were all rolled into
DST.
Trust me, the JVM issue has had a lot of man hours invested in trying to fix
it and the only solution found was to go to CF8 and that was just more fuel
to the people pushing to trashcan CF completely and go to .NET Actually in
all reality I do not see us needing to worry about it much since I
Beware of doing it this way... You will need cftransaction or some other
way of ensuring that the ID is unique. Consider the situation where 2
inserts from 2 different people are happening nearly simultaneously. The
second request for the max(ID) could occur before the first is
inserted
In a sea of data, I need to pull the first image tag. It looks like this...
img
src=http://images.craigslist.org/01010001150701030720071219cd6f3ea36b5b712d
2f00d0d9.jpg
I am using...
cfset imageLink = REReplaceNoCase(cfhttp.fileContent,
img[^]+([a-z0-9_]\.(?:jpg|jpeg|gif|png))[^]*, , ONE)
But it
listLast(URL,'/') ? You're just complicating something simple with Regex
here in this case.
On Dec 20, 2007 2:55 PM, Che Vilnonis [EMAIL PROTECTED] wrote:
In a sea of data, I need to pull the first image tag. It looks like
this...
img
src=
Todd, not sure that that would work. If you look at my code, I am cfhttp-ing
a page and searching for the first image tag. I simply gave an example of
the format of the img src in the returned HTML. RegEx would be best for
that, right?
-Original Message-
From: Todd [mailto:[EMAIL
The first thing I see is that you are only allowing for single-character
names. You don't have a + or * (+ would be better) after [a-z0-9_].
There may be more, but that's what I see at first glance.
--Ben Doom
Che Vilnonis wrote:
In a sea of data, I need to pull the first image tag. It
Interesting.
Updater 7, huh? Isn't it about time for JRun 5? :)
~Brad
You'd think. However, JRun is dead as an independent platform. From hence
force forward, no new updates unless CF requires it. Not many care, however ;).
Matthew Williams
Geodesic GraFX
www.geodesicgrafx.com/blog
I think you need ReFindNoCase, otherwise it will return empty string.
-- Josh
- Original Message -
From: Todd [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Thursday, December 20, 2007 11:58 AM
Subject: Re: Another RegEx question...
listLast(URL,'/') ? You're just
You'd think. However, JRun is dead as an independent platform. From
hence force forward, no new updates unless CF requires it. Not many
care, however ;).
I see.
There never seems to be an over-abundance of people on the list willing
to answer questions about JRun, let along other J2EE
I am cfhttp-ing a page and searching for the first image tag.
This is a job for CF_REextract :
http://www.contentbox.com/claude/customtags/REextract/testREextract.cfm
You can even test it on line :
1) set INPUTMODE = to http
2) go to
Claude, that brings back the javascript script tag. Neat custom tag, I just
want the RegEx though.
-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 20, 2007 3:36 PM
To: CF-Talk
Subject: Re: Another RegEx question...
I am cfhttp-ing a page
For anyone still reading this thread, I downloaded the java API from
cybersource's site, extracted it and there is a coldfusion folder in there. If
you view the readme file it has a section about configuring coldfusion and what
class paths to add to the java.config file. I couldn't get CF to
For anyone still reading this thread, I downloaded the java API from
cybersource's site, extracted it and there is a coldfusion folder in there. If
you view the readme file it has a section about configuring coldfusion and what
class paths to add to the java.config file. I couldn't get CF to
+1 for Mutli-Instance on JRun
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
Dominic,
Not really... Databases do a lot of things concurrently. The statement below
should be safe, but locking, and other issues on a very busy database
could cause deadlocks if 2 simultaneous processes are trying to update the
same row.
Having said that, I suspect that the identity or
+1 for Mutli-Instance on JRun
Here as well. Also running clustering.
Matthew Williams
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
Claude, that brings back the javascript script tag
Ah ok, then you have to include the img tag in the RE1 expression.
I just want the RegEx though.
I wrote this tag because it is sometimes much easier to find what's
between two very simple expressions
than to describe what you want in only
I got this error when I used the administrator to clear the cache.
This is on the server at work which was a clean install (ver 7.0.2)
The cferror information is as follows:
Diagnostics: The selected method getAdminHash was not found. Either there are
no methods with the specified method name
We use clustered CF servers, most sitting behind F5 switches. We do sticky
sessions with Jboss and WebSphere and have session replication with
WebSphere. Not being an admin I like jboss as websphere is not easy to admin
for a non admin type, its also expensive and heavy. You might note though
that
I'm not a sys admin so I might be off here but couldn't you get around this
with a switch that ensures requests coming off a certain server gets routed
properly?
Adam Haskell
On Dec 19, 2007 6:18 PM, Jochem van Dieten [EMAIL PROTECTED] wrote:
Sean Corfield wrote:
The issue here is that if
cfquery
declare @newid int
select @newid = max(id) from Members
if @newid is null
Oddly enough that's actually more complicated than is necessary if
you're using SQL Server -- i.e.
insert into members (memberid,x,y,z)
values (
(select
The database does support autonumber, but this is a legacy app and
database. Also, there are many times where autonumber isn't useful
because when you delete a record, the database re-numbers everything
changing the ID which we didn't want.
Oh I misread that the first time... I thought you'd
As a rule we do not use CF(or the Java it is running on) for TZ
adjustments. We already have time problems with our CF7 boxes
because the JVM that adjusts for the TZ changes in the past 1-2 years
conflicts with our LDAPS cert which forces us to run on an older JVM.
Boy unless I'm really
Beware of doing it this way... You will need cftransaction or some
other way of ensuring that the ID is unique. Consider the situation
where 2 inserts from 2 different people are happening nearly
simultaneously. The second request for the max(ID) could occur
before the first is
cfset imageLink = REReplaceNoCase(cfhttp.fileContent,
img[^]+([a-z0-9_]\.(?:jpg|jpeg|gif|png))[^]*, , ONE)
In addition to Ben's comment, it doesn't look like you're finding the
beginning of the src attribute, see:
img[^]+ and then straight into the regex for the url ... so there's no
mention
Boy I wish I had any advice to offer... mostly 'cause I've noticed that
it seems like you haven't had any response to this question... I suspect
folks are in general just kinda stumped at what advice to offer, like I
am. I've never done anything for a conference like that -- I can offer
advice
What type of advice are you looking for, software layout (architecture) , UI
layout, Physical layout? I think that would help me understand you question
better.
Adam
On Dec 20, 2007 10:22 AM, Lori Stone [EMAIL PROTECTED] wrote:
Here is the situation:
There is a conference in March. The
Lori,
Here's my thoughts on your problem:
1) Have the static elements of the tickets and ID's printed
professionally by a printer on blanks - it will be much cheaper than
paying for ink outright. It will also take less time to print.
Maybe a perforated blank with the ticket on once
Sure. The switch would do so via sticky sessions, so we're back to
where we started - sticky sessions are necessary for a lot of
functionality.
On Dec 21, 2007 10:56 AM, Adam Haskell [EMAIL PROTECTED] wrote:
I'm not a sys admin so I might be off here but couldn't you get around this
with a
On Dec 20, 2007 10:22 AM, Lori Stone [EMAIL PROTECTED] wrote:
Here is the situation:
There is a conference in March. The customer wants to have an
application
where when the registrants come in they can immediately print out
their
information, tickets to events (maybe up to 5 events
moving this where it belongs.
Jesse - with all due respect, the original poster posted an ad to a
COLDFUSION list, which clearly insinuated that .NET is the better
technology. What sort of response did you expect he'd get?
If that particular company is looking to move to .NET, that's 100%
their
So you think I am a tool, your intitled to that opinion but no where in the
original post does it mention .Net is better. If anything one might gather that
they are assuming a CF developer learning .Net is taking ones career to the
next level. I think it's pretty safe to say that if one only
Charlie Griefer wrote:
moving this where it belongs.
Jesse - with all due respect, the original poster posted an ad to a
COLDFUSION list, which clearly insinuated that .NET is the better
technology. What sort of response did you expect he'd get?
I'd expect he'd get no responses.
But on
the take the next step professionally certainly could be taken at a
promotion of .NET over CF... OR as a reference to the fact that anyone
who's applying to his post is taking the next step, professionally.
That is, after all, what you do anytime you change employers or careers,
isn't it?
Lighten up Greg.
Quote
Take the next step professionally and join an exceptional team.
Software
Engineering Services is a leading IT consulting company seeking
individuals who
want to come on board with a large Omaha, Nebraska client.
End Quote
If this guy is guilty of
to all:
yes, i can see where the take the next step wasn't meant to imply that .NET
was the next step *up* over ColdFusion. But... that's (obviously) how i
originally read it.
for the record, i would never in a million years tell somebody -not- to learn
something new. it's all about being
70 matches
Mail list logo
