On Wed, Dec 12, 2012 at 11:16 AM, Edward Chanter firew...@cc.uk.com wrote:
my first question is whether CF is best for
this or if I should try to do this with SQL queries. If the answer is 2 can
anyone point me in the right direction as to how I would go about doing
this in native SQL? Or is
Thanks for the tip Cameron, I will definitely research SELECT INTO as
suggested, all I was hoping for was a pointer like that. I have a lot of
tables to transfer but not all require any massaging of the data so I might
be able to use CF for some and SQL for the others.
Cheers :)
On 12
you may also want to read up on stored procedures,custom functions cursors,
and bulk inserts which would help in converting cfml to TSQL
On Wed, Dec 12, 2012 at 4:28 PM, Edward Chanter firew...@cc.uk.com wrote:
Thanks for the tip Cameron, I will definitely research SELECT INTO as
No problem. These sorts of data migrations are always a pain, and somewhat
unrewarding tasks...
-Cameron
On Wed, Dec 12, 2012 at 11:28 AM, Edward Chanter firew...@cc.uk.com wrote:
Thanks for the tip Cameron, I will definitely research SELECT INTO as
suggested, all I was hoping for was a
Thanks Russ, stored procedures I know something about the others I've never
had to use before but will check them out.
On 12 December 2012 16:36, Russ Michaels r...@michaels.me.uk wrote:
you may also want to read up on stored procedures,custom functions cursors,
and bulk inserts which would
I think I see what your going for, but would like to have better
requirements.
Try this:
cfset myLen = listCommiteeMembersRet.recordCount
!--- Loop through the records ---
cfoutput query=listCommiteeMembersRet
input type=hidden name=EC_ID
value=#listCommitteeMembersRet.EC_ID# /
Loathe,
That was close. I made a couple of changes and it worked like a champ.
Thanks for getting me on the right track.
~|
Create robust enterprise, web RIAs.
Upgrade integrate Adobe Coldfusion MX7 with Flex 2
On Wednesday 22 February 2006 18:28, Andy Matthews wrote:
dynamically. Loads of different possibilities though and I'm not sure if it
would be worth it.
If you need the component more than once, or it is complicated to set up, it's
worth it.
--
Tom Chiverton
Advanced ColdFusion Programmer
Will, is that a typo? You're outputting from a CFC! BLASPHEMY! :-)
ohhh yeah, and I LOVE it! heeheheee
Rick already gave me a black eye for using cfcontent in a cfc. :)
I asked about it and was given permission from an oo ninja master, whose name
shall go unmentioned. :)
Will
On Wednesday 22 February 2006 04:33, Michael T. Tangorre wrote:
Will, is that a typo? You're outputting from a CFC! BLASPHEMY! :-)
We've got an excellent set of GUI components built in CFCs, it rocks.
--
Tom Chiverton
Advanced ColdFusion Programmer
Subject: Re: Is there a better way to do this?
On Wednesday 22 February 2006 04:33, Michael T. Tangorre wrote:
Will, is that a typo? You're outputting from a CFC! BLASPHEMY! :-)
We've got an excellent set of GUI components built in CFCs, it rocks.
--
Tom Chiverton
Advanced ColdFusion Programmer
I'm with you Will. I've got one of those no-cfc-output-nazis here at my
office and I just drive him crazy with a bunch of components that I use
specifically for output of reports!
--Ferg
Will Tomlinson wrote:
Will, is that a typo? You're outputting from a CFC! BLASPHEMY! :-)
ohhh
On Wednesday 22 February 2006 14:57, Andy Matthews wrote:
Care to share them Thomas?
I'd love to, but
a) they're too tightly tidy to our data base (not enough MVC abstraction, tsk)
b) they're not mine, they're the companies :-)
It's just wrappers around things like a certain popular DHTML
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--//-
-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 22, 2006 11:23 AM
To: CF-Talk
Subject: Re: Is there a better way to do this?
On Wednesday 22 February 2006 14:57, Andy
From: Will Tomlinson [mailto:[EMAIL PROTECTED]
I'm outputting a shipping option form from a cfc.
Will, is that a typo? You're outputting from a CFC! BLASPHEMY! :-)
~|
Message:
I'm not a SQL wizard and am doing this off the top of my head, but I'd try
something along the lines of
select word from dictionary where
(select dream from dreams where dream_id = #dreamid#)
like ('%' + word + '%')
But, again, that's off the top of my head.
--Ben Doom
Programmer
.
Mobile workforce monitoring, mapping reporting
www.navtrak.net
410.548.2337
-Original Message-
From: Ben Doom [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 12:06 PM
To: CF-Talk
Subject: RE: Is there a Better Way to do this?
I'm not a SQL wizard and am doing this off the top
PROTECTED]]
Sent: Thursday, December 19, 2002 12:10 PM
To: CF-Talk
Subject: RE: Is there a Better Way to do this?
select word from dictionary where
(select dream from dreams where dream_id = #dreamid#)
like '%#word#%')
can be done like this, without the () around the %#word#%
part
.tony
Tony
I did this for an FAQ not long ago... something like this worked for me
select dictionary.word
from dictionary
inner join dreams on
dreams.dream like '%' + dictionary.word + '%'
order by dictionary.word
In the case of my faq the user was entering another question and the text of
the question was
: Tony Weeg [mailto:[EMAIL PROTECTED]]
: Sent: Thursday, December 19, 2002 12:10 PM
: To: CF-Talk
: Subject: RE: Is there a Better Way to do this?
:
:
: select word from dictionary where
: (select dream from dreams where dream_id = #dreamid#)
: like '%#word#%')
:
: can be done like this, without
-Talk
: Subject: RE: Is there a Better Way to do this?
:
:
: I did this for an FAQ not long ago... something like this worked for me
:
: select dictionary.word
: from dictionary
: inner join dreams on
: dreams.dream like '%' + dictionary.word + '%'
: order by dictionary.word
:
: In the case of my faq
I'm not a SQL wizard and am doing this off the top of my head, but I'd try
something along the lines of
select word from dictionary where
(select dream from dreams where dream_id = #dreamid#)
like ('%' + word + '%')
But, again, that's off the top of my head.
What you mean is :
SELECT
]]
: Sent: Thursday, December 19, 2002 12:28 PM
: To: CF-Talk
: Subject: RE: Is there a Better Way to do this?
:
:
: I did this for an FAQ not long ago... something like
this worked for me
:
: select dictionary.word
: from dictionary
: inner join dreams on
: dreams.dream like
I'm not a SQL wizard and am doing this off the top of my
head, but I'd try
something along the lines of
select word from dictionary where
(select dream from dreams where dream_id = #dreamid#)
like ('%' + word + '%')
But, again, that's off the top of my head.
What you mean is :
SELECT
Accept that if you left join dream, you'll get every word from the
dictionary -- I was under the impression ( possibly mistaken ) he was
looking for only words appearing in the dream text ...
~sigh~ Right! that does it You are of course correct
Too much darkness outside now...
No you were correct I only want to pull the dictionary words that were found
in the dream. The code you gave me worked great the only issue i see now for
example let's say the word is FEEL then it pulls EEL out of the dictionary.
IS there a way to avoid that?
I'm not a SQL wizard and am
Quick guess, change
like ('%' + word + '%')
to
like (word)
??/
WG
-Original Message-
From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
Sent: 19 December 2002 17:52
To: CF-Talk
Subject: Re: Is there a Better Way to do this?
No you were correct I only want to pull the dictionary
Yea, there's a couple things you can do ...
Make sure that every word in the dream is bounded by spaces
You can do this with a couple regular expressions like this:
cfset dreamtext = REReplace(dreamtext,([[:alpha:]])([^ [:alpha:]]),\1
\2,ALL)
cfset dreamtext = REReplace(dreamtext,([^
awesome thanks :)))
From: S. Isaac Dealey [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re: Is there a Better Way to do this?
Date: Thu, 19 Dec 2002 13:26:40 -0500
Yea, there's a couple things you can do ...
Make sure that every word in the dream
Quick guess, change
like ('%' + word + '%')
to
like (word)
At least in sql server afaik ( not sure about other db's, but I suspect it's
fairly standard ) using like word is the same as using = word because
the db is looking for a wildcard % or _ ( single character wildcard in sql
server
That's what we're here for. :)
awesome thanks :)))
From: S. Isaac Dealey [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re: Is there a Better Way to do this?
Date: Thu, 19 Dec 2002 13:26:40 -0500
Yea, there's a couple things you can do ...
Make sure
ok right now i am doing this
cfset dreamtext = REReplace(dream.dream,([[:alpha:]])([^ [:alpha:]]),\1
\2,ALL)
cfset dreamtext = REReplace(dream.dream,([^ [:alpha:]])([[:alpha:]]),\1
\2,ALL)
CFQUERY datasource=#request.dsn# name=dictionary
SELECT DISTINCT DJ_Dictionary.Word
FROM
ok right now i am doing this
cfset dreamtext = REReplace(dream.dream,([[:alpha:]])([^
[:alpha:]]),\1
\2,ALL)
cfset dreamtext = REReplace(dream.dream,([^
[:alpha:]])([[:alpha:]]),\1
\2,ALL)
CFQUERY datasource=#request.dsn# name=dictionary
SELECT DISTINCT DJ_Dictionary.Word
FROM
for now im not going to do verity BUT it is full text indexed would using
CONTAIN instead of like make any difference?
Well, the easy way is to just add 'bats' to your words table -- this also
will help with plurals for which the trailing s doesn't necessarily apply,
i.e. gooss, octopuss or
I wouldn't expect it to make a difference -- checking for plurals is a
semantic (may not be the right technical term) search criteria -- it's not
something that can be easily defined, even with a regular expression because
the rules are often specific to an individual word, so it requires its own
Thanks! Now that you put it together for me, I did read about relational
databases in Forta's book. Seems obvious now, except were did the other 2
states go?
Jeff Fongemie
"James Sleeman" [EMAIL PROTECTED] wrote in message
E12sO5Q-ik-00@mortimer">news:E12sO5Q-ik-00@mortimer...
On Wed,
36 matches
Mail list logo