Word game geek here is guessing Dallas/Fort Worth.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 09, 2006 3:05 PM
To: CF-Jobs-Talk
Subject: RE: ColdFusion sightings in D/FW Area...
Where is D/FW? I assume it isn't around where I am because
Hi, there. I am creating my first Java CFX tag, and I am getting the
following error:
PullNTID (Unsupported major.minor version 49.0) null
The error occurred on line 1.
(PullNTID is the name of the class.)
Any thoughts?
TIA,
Matthieu
I think that there are three things here:
1) Talent for seeing problems and their solutions in user interfaces.
2) Experience with designing/fixing user interfaces.
3) Knowledge of theories/abstract concepts related to user interfaces.
Number 1 may be overrated; I think that Number 2 tends to be
All,
I run a site using ColdFusion MX7 on a Unix box. It is an intranet
site, accessible only to people within the company who have logged on to
the network using their NT ID. Some coworkers of mine (who run
ColdFusion sites on NT boxes) are able to have their CF apps pull that
NT ID for use
Mark,
I'd try this:
SELECT TOP 1 (controlID, memberID, memberSubmitDate)
FROM tblList
ORDER BY memberSubmitDate DESC
HTH,
Matthieu
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234884
Archives:
Aaron,
I Googled MySQL concatenation operator and eventually came to the
CONCAT function, pasted below. I think searching for
DB_SOFTWARE concatenation operator should help others find their
db-specific answers as well.
HTH,
Matthieu
CONCAT(str1,str2,...)
Returns the string that results
Depends on what you mean by this. If you are looking for a test of
whether it is an integer versus a real number with non-zero digits after
the decimal point, then you can use this:
CFIF Variables.MyVar = Int (Variables.MyVar
!--- Variables.MyVar is an integer. ---
CFELSE
!---
Well, you have a bigger problem than that. Let's take your example,
where--after someone selects a start time of 11:45 AM and a finish time
of 12:45 PM--you change your start time list to:
11:30AM
01:00PM
What if the person selects 11:30 AM (completely valid), and then selects
an end
I just learned about eclipse recently, and I love it. I am curious,
though, as to whether there is a plug-in that allows the sort of visual
HTML layout editing that Dreamweaver does. You see, I am too cheap to
buy Dreamweaver at home. Is there an eclipse plug-in (I've looked
through and not
Mark,
In the ColdFusion documentation, take a look at the key parameter for
the CFINDEX tag. Here is some of the info:
The value specified for key depends on the type attribute:
If type = file, the directory path and filename for the file,
If type = path, the directory path for the location
Russ,
All right. Let me take a shot. First off, I don't think I really
understand the ins and outs of your data, but the formatting issues
remind me of a problem that I had outputting data, so I'll punt:
Generally stated, you have data that is grouped by some geographic area.
Within each
Cameron,
I use the autocomplete=off approach with much success. I am curious
though: is it true that you can override this setting from within the
client?
Matthieu
-Original Message-
From: Cameron Childress [mailto:[EMAIL PROTECTED]
Sent: Monday, January 09, 2006 7:57 PM
To: CF-Talk
Brian,
If you do text, you of course will want to do lots of validation on the
way in to get rid of any parentheses, periods, spaces, dashes, etc. that
the user puts in, so that you can then standardize it.
Without advocating the original plan for number fields, I can at least
tell you how to do
Ray,
This does sound like a great idea. I can't claim to be expert enough to
be writing any chef entries, but I am a PITA proofreader (folks never
like me because I actually find all the errors--grin), and as a
medium-level CFer, I know enough to be a sample user of the thing. So,
I'd love to
Hi, all. I've been just an observer on this very interesting thread,
with little to contribute in favor of either idea. However, in reading
through the 73 (!) posts I had not yet seen when I came in today,
something striking occurred to me.
I saw the two camps as Keep display code separate
Well, I would say that you can add contact info without adding a user
(multiple contacts, right?) but you can't add a user without adding
contact info. So, it seems to me that you first instantiate the user
and then instantiate the contact info entry, not the other way around
(i.e., AddUser()
All,
I don't have much more to add, except for some reinforcement of already
stated ideas. My mother and step-father have been running very
successful engineering consulting firms out of their house for years,
and their advice to me has echoed what the folks on this list have said:
1) Never
Neal,
How about this:
CFIF Right(cgi.HTTP_REFERER,1) IS ?
!--- URL ends with ? ---
/CFIF
If this is true, then the URL ends with a ?. I don't know whether
having multiple ? in the URL will be necessary. If so, and if this will
even work (I can't remember whether it causes browser
.
It looks like its adding ? to the url when I want to remove it if
there is not a query string available.
Hope all this makes sense.
I have been starring at it so long I'm not sure if I can explain it well
enough.
Neal Bailey
-Original Message-
From: Cornillon, Matthieu (Consultant
All,
I am in the process of moving a CF site from one server to another. The
new site is in CFMX7. I do not have access to the administrator
settings, as I have to work through someone in another department on
this. The problem is that I have ~8.5 seconds (+/- 0.2 seconds) delay
on each page
All,
Thanks for your input on the client variable problem I mentioned. Turns
out that the problem was that the client variable store table (in an
ODBC datasource) was not indexed properly. Never would have tracked
that down if you all hadn't given me the hints that you did. Major
problem
I, too, have had experience with this sort of thing. The approach I
used has a bunch of dummy index pages that spill out db content in a
way that will be interesting from a content perspective to people
searching Google, but with nothing else on them. These index pages
are then set with
Molly,
Hi, there. I think that using a database alias will do the trick. If
you use this syntax:
CFQUERY name=getindiv datasource=sotl
SELECT #i# AS ProposalName
FROMgrades06
WHERE readerid = #session.readerid#
/CFQUERY
then you can refer to that column as
Andy,
Sorry. That's what I meant to say. The idea is that page 2 dynamically
builds the URL with the named anchor using information passed it by page
1. So, for example, page 1 might link to:
page2.cfm?pageToLoad=nameOfPageToLoadanchorToLoad=nameOfAnchorToLoad
Then, page 2 loads
CFSHEEPISHOops. Should have known better than to make suggestions on
something I had never really done myself./CFSHEEPISH
:)
Now that I see it, Tanguy's suggestion is obviously the way to go. The
temporary table thing that my friend here suggested was for something a
little more complicated.
Ken,
I ran this query on a table called USERS through Toad to an Oracle
database:
SELECT 404 FROM USERS
and I got exactly what you described as a result: one column (named
404) with one row per row in USERS, each row equal to 404.
I have contacted Molly off-list and am helping her with
Thanks for that, but is there a way to copy a whole row...
This is a snippet of code that a friend here at work sent me for
creating a whole new row from a whole old row all within SQL. It is
Oracle-based, and I have never used it myself, but I am pretty sure that
it does what you want.
Say
This seems too easy an answer, so I probably missed something, but I'll
give it a try anyway. You have page 1 currently sending variables to
page 2, which dynamically loads page 3 in an interior iframe. Can you
not send the name of a named anchor along with it and have page 2 load
I think that the delimiter attribute of ListGetAt looks at each
character specified on its own. In other words, it's looking for three
possible delimiters: %, 2, and 0. Maybe if you used the URLDecode
function first, then used a space as delimiter? Otherwise, I'd replace
%20 with some uncommon
Hi, everyone. Is it possible for Client.CFID and Client.CFTOKEN to not
exist? With the exception of a read immediately following a StructClear
or StructDelete statement, it seems to me that this gets set during the
transfer of information between the server and the client before any
ColdFusion
Mark,
If I understand you correctly, all you need to do is a join in your
query. Rather than having two queries, just have one:
cfquery name=getInfo datasource=#request.dsn#
SELECTdistrict_plan_documents.COLUMNNAME,
district_plan_section_headings.DP_Heading
FROM
Hello, all. I am preparing for some hypothetical scenarios. Under one,
my web host stops supporting ColdFusion, and I have to keep hosting my
site there. Obviously, there is no way around the fact that some of the
functionality cannot be preserved without serious work. However, I am
looking at
Barney,
Thanks! This looks perfect.
Matthieu
Barney Boisvert wrote:
wget. Or any other web scraper/spider. We do exactly that for our
sales guys when they're going somewhere and know they won't have an
internet connection, so they can still have our website available.
Hi, everyone. I am looking at converting a ColdFusion site to Java J2EE
(sniff, sniff). I have found a product called eKnowlogie. Their site
(eknowlogie.com) claims to do it all and do it all nicely. I am still
researching this, but I was wondering if anyone knew anything at all
about this
Russ,
I get somewhat similar behavior depending on how I add the data in
question. I access the database in two ways: through ColdFusion code
and through TOAD (a SQL client on my desktop). If I go through TOAD and
I issue a regular INSERT statement and ask it to execute, I will
immediately see
Hi, everyone. I have been doing something for years that works, but
feels darned silly. I have a table called WIDGETS. I have a sequence
set to increment by 1 up to some ridiculous number called WIDGETS_PKSEQ.
When I add a new row to WIDGETS, I put WIDGETS_PKSEQ.NEXTVAL into
WIDGETS.pkWIDG, the
You could do a query of queries. You dynamically create a query result
set that has your aDate values (cfloop over the range, and add a new row
and value on each iteration). Run a query of your actual db table
limited to the dates in question. Then run a query of queries where you
do a join (I
DUAL?!?!!? That works, and is magic, but, again: ?!?!? I'll have to
research this. I am sure there is a good reason for it being called
DUAL. If not, and if this is truly arbitrary, then I am disappointed
that the folks at Oracle didn't come up with some more colorful name,
like
Aaron,
This is another good solution.
Thanks,
Matthieu
-Original Message-
From: Aaron Rouse [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 03, 2005 2:08 PM
To: CF-Talk
Subject: Re: new next primary key value in Oracle
You could just run the insert on one table, then select out
Ian,
Shouldn't the same technique work, where you do separate outer joins
against each of those other tables? I only know Oracle SQL, so I never
know how it would work in a query of queries (if outer joins are even an
option), but I would do this in pseudocode:
qTable1
SELECT Letters FROM
Yet another good answer. Thanks, gang, for sending these in. At least
one will do the trick.
Matthieu
Matt Small wrote:
One idea, if it's possible - pass all of this information at once into a
stored procedure, which would know the newly created row id know what
number to use.
I LOVE DUAL!
Thanks! I'll be doing more research on this.
Matthieu
Deanna Schneider wrote:
You're new to dual? Dual is just a wonderful little widget that acts
like a one row table, but the column is arbitrary. You can do all
sorts of stuff with it:
select sysdate from dual;
select 1 + 1
Ian Skinner wrote:
We are also using Oracle here as well. Your idea would probably work,
except Queries of Queries only supports inner joins. A limitation I
have butted heads with on several occasions.
Bummer. I can't think of a query-returning option, then. I would pull
all the Oracle data
Yesterday, my workstation started
experiencing some maddening kind
of intermittent caching.
Ian,
I had a similarly maddening experience just as I switched
(simultaneously) from ColdFusion Server 5 to MX7 and from Dreamweaver
Ultradev 4 to Dreamweaver 8. Don't know what caused it, but
I get this JavaScript error
on the mouseover below: Expected ')'
tr onMouseover=HighLightTR('##f0f0e1');
ondblclick=self.location=('getinventory4.cfm?id=#id#lname=#lname#fnam
e=#fname#serialnumber=#serialnumber#');
When I just use the ?id=#id# after getinventory4.cfm
I do not get an
The site that I maintain uses a client variable store that sits in
Oracle. At some point in the near future, the entire site (web and
database servers) is being migrated to new equipment. The people
handling the migration will shut off all web connections to the old
site, take a snapshot of all
Hi, everyone. A client of mine is telling me that their hardware
providers may have force them to switch their site (written in
ColdFusion) to WebLogic. To be honest, I hardly know what that means.
I have seen that ColdFusion can be made to run in WebLogic, but the
client may not have that
I'm using MySQL (4.0) version, which doesn't support subqueries, so I need
to rewrite this as a join query...how would I do that?
Well, here's a clumsy idea that gets the job done. Do an outer join (don't
know the exact syntax for MySQL) that gets you two columns in each row:
email address
All,
Hi, there. Have a bit of a tricky one. Before starting, let me say that I
know the real solution is to use CLOBs, but I need to make this work in the
meantime. I have to put huge amounts of text into tables whose columns are
already defined and whose setup may not be changed. Luckily, I
Hi. I have a really weird problem here that is hard to summarize, so I am
just going to ask anyone if they've had anything even vaguely like this,
since that might help me know where to look.
I have a sign-in and registration system on my intranet site. Here is the
system: a user registers,
From Michael:
What version of CF are you running.
I am running CF5.0.
From Bryan:
If you're running clustered servers,
there could be some session confusion
between servers.
Assuming this is the case, is there anything I can do about it?
Thanks!
Matthieu
Bryan,
Thanks for this information. I have more or less stopped using session
variables in general (can't stand all that pesky locking business), but that
has only happened since I released the sign-in/registration system. I agree
about the security hole inherent in the cookie system. I am
My two cents:
I (sinfully) use the plurals in the table names. Can be confusing, yes, but
if you are consistent one way or the other, you should be able to remember
what you are doing.
My rules:
1) Each table name has a related table abbreviation (e.g., CLIENTS has CLI,
PHONENUMBERS has PHONE).
The are so many options on which styles to follow, the approach I
recommend
is to pick a something, document it and follow your document.
This is indeed the most important thing. The system I just laid out (that I
use) in another e-mail is only useful to me insofar as I am consistent in
Anders,
DISCLAIMER: All of the rambling you are about to read is based on my own
experience designing user interfaces, and none of it is based on industry
standards.In other words, get your grains of salt ready.
I think that it depends what page is loading, and how it all fits into the
user
The theory in that is a very very good answer... finally a pretty
balanced point... altho you may want to cache that 43 second query
somehow so that it isn't that long the next time round :)
Indeed.I was mainly using such a big number for contrast.In general, a
43-second process had darn well
Can anybody lend a hand and help me out on this one?All it does is
return
1 row no matter how many rows are in the sizeLine table..
Blaine,
I'm not exactly sure why this is happening, but here are some ideas of what
to check:
1) Forgive me for suggesting the obvious, but since it's
2.) Can someone please suggest a good book on SQL syntax that will clear
thing up for me.
Other beginner resources:
1) http://www.sqlcourse.com/ http://www.sqlcourse.com/
2) http://sqlcourse2.com/ http://sqlcourse2.com/
3) http://www.freeprogrammingresources.com/sql.html
Wow, do I ever feel stupid.It was the output stage that I had my problem
with.It's fixed, that join query runs fine.
I'm glad it worked out.No need to feel stupid: getting a second (third,
fourth,...,nth) pair of eyes to look at the issue freshly is one of the
great things about this list.
If you want to do this in SQL, you can use the DECODE function.Let's say
you have a table called TASKS, and you want to prioritize TASK_Name by
TASK_Priority, High to Low:
SELECT TASK_Name, DECODE(TASK_Priority,'High',1,'Normal',2,'Low',3) AS
PriorityOrder
FROM TASKS
ORDER BY PriorityOrder
Phillip,
In the CFQUERY tag, you define the name of the query as display.So the
later CFIF statement should read CFIF Display.CurrentRow... instead.When
you took out the error_table part, CF looked through the available
variable scopes and found the data somewhere, but it may have been looking
Adam,
I think that it is just bad coding.I have seen a fair amount of confusion
on the point of getting values out of a query (e.g., people often seem refer
to MyQuery.ColName without looping, unintentionally getting nothing but the
first value).Also, I think people often don't know array
Is there an easy way to go about handling table rows/columns colors as
I am doing my page design/layout?
Donna,
I'm not sure if this is what you're going for, but here's a stab: between
CFOUTPUT tags, use ## instead of #.
HTH,
Matthieu
[Todays Threads]
[This Message]
[Subscription]
Hello, all.
I have to submit some values to a form action page.I have no choice on the
far end: it is expecting POSTed form variables.On my end, though, this is
kind of a pain, because I need to do an intermediate, non-user step before
the submission.So my situation is:
UserForm - page on which
have you tried cfhttp?
Lawrence,
I have never used CFHTTP before, but I don't think it will do it.I have
just tried setting it up, and it doesn't go anywhere.In other words, it
seems that the data is posting to the other server, but the client never
goes there.I want this to be exactly the
Chris,
Thanks for this message.Unfortunately, I am getting a connection error.I
am guessing that something about the set-up I am using doesn't allow this
approach?I am going from one company to another, across at least one
firewall.I probably have another solution, but in the interest of
is your network behind a firewall? do u find it takes forever for it to
process? you may need to add your proxy's address, port, username and
password... may not be allowing you to post.
Yes, it is.I have been playing with this with no luck.This should be my
proxy address, port, username,
This is a long shot, but if you are pulling your from Oracle or another DB
that allows the LPAD/RPAD functions, you could pad it on the query instead
of having to loop through it.In fact, I often, when putting values like
this together in select statements, do all of the concatenation in the
Anybody know of a script that replicates type-ahead select lists (like
in Gmail or offline VB applications)?
George,
I built this using _javascript_.It's not too pretty, but it works just fine.
The idea is that a global variable is the buffer in the list, to which
keystrokes are added.The
If the end user just enters e
in the search box, I am not so
sure that I want every name that
contains an 'e' to be returned
Or do I???
What is the consensus on how to
make something like this work best?
I personally like the anywhere in the string approach, but I have found
that
Im trapping a few errors per day which means probably 1-1000 users (or
more) is experiencing this problem, and not sure what could be causing it.
AAARGH!That foul beast dares rear its head again!?!!(read with pirate
voice and one eye squinted shut)
I had/have this exact same problem.The site
Vishnu,
I think that having the field names all the same will be a mistake, as it
will complicate the issue on your form page, if not outright causing errors.
In any case, you do not need to have the field names be exactly the same as
your database field names.I have done this sort of form
I don't know the proper way to do this, but I can tell you the hideously
unattractive and effective three-query way that I do it.I use various
items to create something that I know will be unique.For example, I
concatenate user ID and current time.I put that in a local variable.I
run the insert
What i basically need to do is get a list of ID2 and a count of the
people ID1 invited.
Andy,
How about a self join?(The following assumes that the name of your table
is NAMES).
query=qNames
SELECT INVITERS.ID2 AS InviterID, INVITERS.NAME AS InviterName, INVITEES.ID2
AS InviteeID,
SELECT MyNumber, TO_CHAR(MyNumber,'000')
FROM NUMBERS
returns:
1, 001
552,552
1234567,1234567
HTH,
Matthieu
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 15, 2004 11:33 AM
To: CF-Talk
Subject: OT- SQL PADDING QUESTION
I
All,
I am being forced to develop a small module application on my site outside
of my normal environment, meaning that I cannot use ColdFusion.(shudder)
I am interacting with a plug-in on this other server that includes certain
information that I need in the header variables.If I use
cfset timeCallPlacedOnHold = queryTmp.HoldDateTime
cfset timeOnHoldReleased = queryTmp.ReleasedDateTime
For some reason the dates retuned are in this format:
Ex: 2004-09-08 12:28:56.0
I can't understand why it adds the .0 after the time when the value
stored in the database is 2004-09-08
Another option is to do a self-join.
This works, though I am not getting all rows returned and I haven't quite
figured why yet.I hate to rely on the titles being exactly the same.I
have data where one title contains the words DVD while the VHS version
doesn't.
Unfortunately, you are
Still struggling with this drag and drop issue.
Guy,
I would like to help, but as Micha said, we'll need to see a little more of
what you are talking about.Can you post it?
Matthieu
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations
Another option is to do a self-join.I'll make some assumptions here that
may not be true, but which you can modify to fit the truth.Key among those
is that you have column called VID_MediaFormat holding either DVD or VHS.
(I know you don't have this, but you seem to have some way of determining
Guy,
One tip on debugging _javascript_: I am sure there is some smart way to do it.
I don't know this smart way.I find the errors when they come up in IE.
Since the line numbers in the _javascript_ error that comes up (you can get it
by double-clicking the little yellow icon in the lower,
Keith,
Perhaps I am not understanding correctly, but it sounds like a query within
which you group the results is the way to go.
You can handle the grouping in a couple of different ways.I would start by
reading the help on the CFOUTPUT tag, looking at the group parameter.
HTH,
Matthieu
However, I can't seem to get it to work
with text unless I select the text
not 100% surebut the text could be
in a div and the div could have somehting
along the lines of
John,
I'm not sure about the DIV tag that Bryan suggested.It may indeed work.
The other way to do it is
cfoutput query=research group=publication_title maxrows=10
#publication_title#
cfoutput
#author_name#
/cfoutput
/cfoutput
But the maxrows attribute goes by the query record count, rather than the
count of unique publication_titles. So instead of seeing 10 records per
page, I may get 6 or 9 or
I'm not a DHTML guy by any means. Could someone point me in the right
direction to figuring out how to use DHTML to take a record from within a
record set, drag it to a higher or lower position, and have it change its
position within the record set?
Guy,
I recently set up a drag-and-drop
Guy,
Thanks for the kind words.The truth is that I learned by reading some
tutorial somewhere myself.If I could have remembered where it was, I would
have just sent you the link, because it was quite good.
That said, my application of what I learned was more specifically geared
toward
I'm experiencing some kind of redirect/cflocation endless loop.Is there
some easy way to trap the iterations of this loop so that I can see what is
trying to redirect to where?
Ian,
I don't know if this applies, but when I have confusing and unplanned
page-to-page routing, I add a dummy URL
Hi.I want to set up a page to cycle through a list of about 25,000 users
and send a personalized e-mail to each of them.I have no need for fancy
subscription, opt-out, or other such management features.Also, I am only
doing this two or three of times.As such, my plan was to loop over a
query,
Joe,
Have you looked at LSCurrencyFormat and LSEuroCurrencyFormat?I haven't
used them, but I think they might handle your needs.
HTH,
Matthieu
-Original Message-
From: joe velez [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 02, 2004 1:35 PM
To: CF-Talk
Subject: currency
Mark,
The problem is that your loop index (memberID) is changing, but nothing
about the query is.You are repeatedly referring to getRecords.memberID,
which, without a CFOUTPUT or CFLOOP tag, will always just give you the first
record.In fact, I am surprised that you are doing anything other
.
In the getRecords query, I can filter by using WHERE directoryPhone IS NOT
NULL.
But is there a way to filter out records that have an empty value ()?
Mark
_
From: Cornillon, Matthieu (Consultant)
[mailto:[EMAIL PROTECTED]
Sent: Thursday, September 02, 2004 1:58 PM
To: CF-Talk
Subject: RE: Looping
The big thing you need to look out for is invalid
email addresses and such because that will kill
the cfmail loop and thus kill all of the emails
going out.
John,
Does invalid e-mail addresses mean e-mail addresses that simply are not
e-mail addresses, or e-mail addresses that are valid
All,
I appreciate your answers on this thread.After doing some testing, it
looks like I will be able to use CFMAIL with the query attribute set to
cycle through messages.To avoid driving the mail server admins to kill me,
I will set a scheduler to leak these out in small batches.
The regular
93 matches
Mail list logo