I have a CF8 app which gets updates from an ancient ODBC datasource at
15 min intervals. Generally it works fine, but once or twice a week it
gets the error:
Error Type: Database
Message: Error Executing Database Query.
Detail: [Macromedia][SequeLink JDBC Driver][ODBC
Richard Meredith-Hardy wrote:
I have a CF8 app which gets updates from an ancient ODBC datasource at
15 min intervals. Generally it works fine, but once or twice a week it
gets the error:
Error Type: Database
Message: Error Executing Database Query.
Detail: [Macromedia][SequeLink JDBC
Not quite. I was looking for a CFML version of something similar to
www.kbpublisher.com
Thanks!
I also experienced a bit of slowness when the search was Loading
However, the reason for this reply is I did see Context-based Help
tag on RiaForge. Does this do what you want?
Cheers,
Sounds like it's time to move to another editor.
-Original Message-
From: Dave Long [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2008 5:02 PM
To: CF-Talk
Subject: CF Studio 5
I've had to reformat my computer after 5years of faithful service.
After re-installing Macromedia
Hi
we have various string values like the following:
qu_45_tb_45_split_0_split_q_67
we need to break this string down into 3 array elements and split it based on
the string '_split_'
if the listtoarray function used this actual sequence to break the string up
then we would be given an array:
cfset myList = Replace('qu_45_tb_45_split_0_split_q_67', '_split', ',')
cfset aMyList = ListToArray(myList)
On Thu, Jun 5, 2008 at 5:01 PM, Richard White [EMAIL PROTECTED] wrote:
Hi
we have various string values like the following:
qu_45_tb_45_split_0_split_q_67
we need to break this
Sorry, should be
cfset myList = Replace('qu_45_tb_45_split_0_split_q_67', '_split_', ',')
(forgot an underscore after split)
On Thu, Jun 5, 2008 at 5:08 PM, Didgiman [EMAIL PROTECTED] wrote:
cfset myList = Replace('qu_45_tb_45_split_0_split_q_67', '_split', ',')
cfset aMyList =
Sorry, one more mistake...
cfset myList = Replace('qu_45_tb_45_split_0_split_q_67', '_split_', ',',
'ALL')
On Thu, Jun 5, 2008 at 5:09 PM, Didgiman [EMAIL PROTECTED] wrote:
Sorry, should be
cfset myList = Replace('qu_45_tb_45_split_0_split_q_67', '_split_', ',')
(forgot an underscore after
So let me get this right.
You looked at the manuals / cfdocs, and you couldn't work out this:
cfset myArray = listToArray(myList, '_split_') /
Seems to me that what you have described, is the way to go... Is it not?
On Fri, Jun 6, 2008 at 1:01 AM, Richard White [EMAIL PROTECTED] wrote:
Hi
cfset myList = Replace('qu_45_tb_45_split_0_split_q_67', '_split', ',')
cfset aMyList = ListToArray(myList)
On Thu, Jun 5, 2008 at 5:01 PM, Richard White [EMAIL PROTECTED] wrote:
excellent thanks very much :)
~|
Adobe®
Easy now... list delimiters are only a single character. When you
specify a delimiter of multiple characters is uses ANY of them to split
the list. Your example below would yield the following array:
array
1 qu
2 45
3 b
4 45
5 0
6 q
7 67
Not quite what the original poster was
The delimiter' parameter is not used as a literal string, but as a group of
individual delimiters. Run this sample code, and you'll clearly see that is
does not do what you might expext of it.
cfset variables.TestList = qu_45_tb_45_split_0_split_q_67
cfset variables.SplitTest =
Why not just use a Wiki?
!k
-Original Message-
From: Alex Sherwood [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2008 8:53 PM
To: CF-Talk
Subject: Recommendations for a Knowledgebase written in CFML?
Greetings,
I've searched high and low and have yet to find a knowledgebase
Then here is what I would do, it doesn't solve your problem. But it is a bug
with Coldfusion.
Report this as a bug, it allows for a string. That should mean any amount of
chars, and not just one.
On Fri, Jun 6, 2008 at 1:24 AM, Brad Wood [EMAIL PROTECTED]
wrote:
Easy now... list delimiters are
no need for the scope variables if not in a function.
Point taken, but it is a bug as far as I am concerned.
On Fri, Jun 6, 2008 at 1:33 AM, morgan l [EMAIL PROTECTED] wrote:
The delimiter' parameter is not used as a literal string, but as a group
of
individual delimiters. Run this sample
It's always been like this. Since CF 4.5 or earlier afaik.
What makes you think it's a bug?
On Thu, Jun 5, 2008 at 5:35 PM, Andrew Scott [EMAIL PROTECTED]
wrote:
no need for the scope variables if not in a function.
Point taken, but it is a bug as far as I am concerned.
On Fri, Jun 6, 2008
(Simplified version... MySQL 5)
cfloop query='get_hmls_commercial_data'
cfquery name='insert_data' datasource='x'
insert into properties
(mls_number)
values (cfqueryparam cfsqltype='cf_sql_varchar'
value='#get_hmls_commercial_data.mls_number#_h' null='#not
This is from ColdFusion 8's documentation:
delimiters A string or a variable that contains one. ColdFusion treats
each character in the string as a delimiter. The default value is
comma.
Emphasis: *ColdFusion treats each character in the string as a
delimiter.*
Tricky I know, but not a bug.
You got to this before me. I think by simple definition, a list is a
single character delimited string. If something delimited by _split_
is more complex and a simple replace as suggested would be in order. Or
you could write a nifty UDF using other String functions such as Find
and REFind.
Yeah I realise that it is or has been that way for a long time.
Just because it has, does it mean it is not a bug?
The thing is that we live in a world of comma deliminated files. The point
is who says that this has to be one character?
Allaire/Macromedia/Adobe?
This is the first time I have
Kind of a dumb thing I'm trying to do...trying to combine
an insert statement with a where clause.
I think I need another approach.
Back to the drawing board...
Rick
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 05, 2008 11:40 AM
To:
Wow. Sure, it could be done differently as in the java/javascript
split() methods but:
a) it was done this way for a reason, it has its use - it was
*deliberate* (not a bug)
b) changing it could/would have serious backward compatibility implications
c) creating a custom UDF to handle this is
:-) it sounds like version of mysql doesn't support
where '#get_hmls_commercial_data.mls_number#_h' not in
(select mls_number from properties)
On Fri, Jun 6, 2008 at 1:56 AM, Rick Faircloth [EMAIL PROTECTED]
wrote:
Kind of a dumb thing I'm trying to do...trying to combine
an
Just a quick glance but could you do something like:
Insert into properties(mls_number)
Values(select mls_number from table where whatever)
I think that's the syntac but you may not need the values piece. I can't
remember off hand but I've done combined insert/select statements like
that before
What are you trying to do. I may be able to suggest an idea.
On Thu, Jun 5, 2008 at 8:56 AM, Rick Faircloth [EMAIL PROTECTED] wrote:
Kind of a dumb thing I'm trying to do...trying to combine
an insert statement with a where clause.
I think I need another approach.
Back to the drawing
I have run into a big problem setting and searching dynamic groups and was told
static groups are the most supported and most understood. I created a static
group and added some members; now I am trying to search for members of this
group and am facing difficulties.
This is the code I am using
Not sure about MySQL but this would work in MSSql
IF (NOT EXISTS ( select * from properties where mls_number =
cfqueryparam cfsqltype='cf_sql_varchar'
value='#get_hmls_commercial_data.mls_number#_h' )
BEGIN
insert into properties (mls_number)
values (cfqueryparam
Just because a company tells us that it should work this way, doesn't mean
it is the way it should be:-)
Look at all the enhancements, and bug fixes since the days of Allaire. It is
upto us, the community to decide whether we belive it is a bug or not.
I belive it is, and I would petiton for it
What if I wanted to do it on a chr(10) chr(13) I can't and that is a valid
2 character delimination. We need to adopt, not stay behind.
Try it, it works. Consider the string: this is chr(10) chr(13)
my string. Delimiting the string by either chr(10) or chr(13) will
create two items (as will
If used as a delimiter, how should CF interpret the following:
_split_
Should it be _split_ as a complete sequence of characters or should it
allow any of the characters to be an individual delimiter?
How would you choose with method that CF should interpret the delimiter?
We do not have the
It is upto us, the community to decide whether we
belive it is a bug or not.
No, it isn't. The word bug has a pretty specific meaning as a term of art.
Whether Adobe should change the current behavior is an open question, but
either way this isn't a bug.
And let me say this, if Adobe /
Just because it has, does it mean it is not a bug?
No. What makes it not a bug is that it conforms to what the documentation
says it does.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training
Ok maybe bug is strong.
Not that it is more than right as far as I am concerned. Sure backward
compatability has to be the foremost and utmost.
But let me say this. Who is right the developer who said whe only need to
deliminate one one characater. Or the develepors 12 years later saying we
need
It should be the entire sequence.
One has to remember that this function is now nearly 12 years since it was
introduced this way. Does it still make it the right decision by Allaire?
No it doesn't, I would like to do one / two or even three or more characters
for seperation. Does that mean that
You can't have multi-character delimiters...thanks for trying.
-Original Message-
From: Andrew Scott [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 05, 2008 10:16 AM
To: CF-Talk
Subject: Re: listtoarray?
So let me get this right.
You looked at the manuals / cfdocs, and you couldn't
I agree that you should be able to pass in a single string and not have it
treated as multiple characters, but it's NOT a bug if the method behaves as
stated in the docs.
-Original Message-
From: Andrew Scott [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 05, 2008 10:48 AM
To: CF-Talk
That would be a cool feature if they added that to SQL so you could do that.
You could test to see if the mls number already exists, if not, then insert
it...I am not a DBA, but I am sure there is also a SQL solution to doing
this as well. I would just check using CF personally.
Eric
Ok maybe bug is strong.
Not that it is more than right as far as I am concerned. Sure
backward compatability has to be the foremost and utmost.
But let me say this. Who is right the developer who said whe
only need to deliminate one one characater. Or the develepors
12 years later
I gave that syntax a try, but MySQL didn't like even the if
at the beginning.
Thanks anyway...
Rick
-Original Message-
From: Dominic Watson [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 05, 2008 12:05 PM
To: CF-Talk
Subject: Re: Anything wrong with this code?
Not sure about
I'm wanting to take the CF 7 Certification exam. I wasn't able to find
any reference to the CF 7 exam on Adobe's website, only CF 8. However,
when I log in to the VUE website to see what exams are available, they
have both the CF 7 and CF 8 exams listed. Whenever I try to schedule
the CF 7
Isn't it supposed to be
WHERE [COLUMN] not in (select mls_number from properties)...
Joe Velez
Rick Faircloth wrote:
(Simplified version... MySQL 5)
cfloop query='get_hmls_commercial_data'
cfquery name='insert_data' datasource='x'
insert into properties
Yep, you should be able to use any string as a delimiter.
I thought I read someone say do a replace. Since you know the delimiter
is _split_ why not do something like:
cfset original_var = 'qu_45_tb_45_split_0_split_q_67'
cfset new_var=replace(original_var, '_split_', '|', 'ALL')
cfset
The word bug, as already mentioned elsewhere is thrown around too greatly to
describe too many problems. I have heard all levels of users utilize the word
to describe anything that isn't the way they want it right now. Everything
from query sorting to simple static text changes.
As a
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
~|
Adobe® ColdFusion® 8
Just because it has, does it mean it is not a bug?
No, it doesn't.
But in this case, it is just the way Allaire has defined it:
look at all list functions, the parameter is delimiters, not delimiter,
and the description says Set of delimiters used in list, not string
used as delimiter
The
Well said, Claude.
I'll throw in that in my opinion, most definitely not a bug. It may
not work the way some of us want, but it's documented to work a
certain way, and it works that way.
Can I say that if I prefer arrays to start at zero then CF arrays are
inherently filled with bugs?
Now,
One has to remember that this function is now nearly 12 years since
it was
introduced this way. Does it still make it the right decision by Allaire?
No it doesn't, but it is definitely not a bug. One could see it as a
flaw in design, at a pinch,
but not a bug.
A bug is when something does not
You did not specify what your exact difficulties are, so I will just
respond with a general message regarding LDAP and groups.
I am more experienced with Active Directory, but it appears that you are
using Sun's LDAP server. (I assumed this by your example's LDAP
attributes and your password.)
Here's what I'm trying to accomplish...it's relatively simple,
or so I thought.
Got a temp table of data (hmls_commercial_temp).
I want to transfer that data to the table, hmls_commercial.
Before I transfer the records, I want to check and make sure
a record for each row in hmls_commercial_temp
Rick Faircloth wrote:
(Simplified version... MySQL 5)
cfloop query='get_hmls_commercial_data'
cfquery name='insert_data' datasource='x'
Do get_hmls_commercial_data and insert_data query the same database? In
that case you should do:
INSERT INTO properties (mls_number)
SELECT ...
FROM
[ADVERT]
Or, simply purchase a ready to go MLS search solution from the company
I work for. We have the MLS data for over 200 MLS markets.
http://www.wolfnet.com
http://www.mlsfinder.com
[/ADVERT]
Wil Genovese
Sr. Web Application Developer
One man with courage makes a majority.
-Andrew
Railo announced today that they are joining JBoss.org and going Open Source.
The license will be LGPL2. More information is available on jboss.org
:)
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic
Thanks Michael,
I am using Sun Directory Server 6.0 on Windows 2003. I created a static group
and Added users from different Organizational Units (Group Member
(uniqueMember)
Now I want to Query the group to find all Members of this group: i.e.
cn=New Group,ou=Groups,dc=example,dc=comin
Now with cfvideo and cfvideoplayer
No really. http://www.railo-technologies.com/en/index.cfm?treeID=354
On Thu, Jun 5, 2008 at 2:09 PM, Peter Boughton [EMAIL PROTECTED] wrote:
Railo announced today that they are joining JBoss.org and going Open
Source.
The license will be LGPL2. More
Ok, that's working (using a different table for the insert,
'hmls_commercial' rather than the 'properties' table for testing)
with this code
insert
into hmls_commercial
( mls_number )
select mls_number
from hmls_commercial_temp
where mls_number
not in ( select
Railo announced today that they are joining JBoss.org and going Open Source.
The license will be LGPL2. More information is available on jboss.org
:)
Very interesting, especially with the integration with messaging and JBoss
caching. I wonder if this has any anything to do with open
I'm working with some java classes provided by a third party. The class
requires an HTTP servlet request object be sent. Within that request, the
class looks for url parameters via the HTTP Servlet Request. The following
code is what I'm using currently...
cfscript
SearchLogic =
You cannot set paramters on a request, the parameters are immutable.
So you'll have to synthesize your own request if you want do do it
that way. However, a better approach would probably be to split the
search engine into it's own tier and access it that way.
cheers,
barneyb
On Thu, Jun 5,
I'd say that's a strong certainty. Maybe they think that if BD has to go
open source, Railo won't have a chance? I'm pretty sure that the lead
developer for Railo is on this list...Gert I think is his name?
-Original Message-
From: Larry Lyons [mailto:[EMAIL PROTECTED]
Sent: Thursday,
You only need half of your filter.
You are requesting LDAP to return objects of class = groupOfUniqueNames
that is also a member of that group.
The only way this will return any records is if you have a group nested
within that other group.
Get rid of the first part of the filter and only
Ok... it works like this:
insert
into hmls_commercial
( mls_number, listing_office )
select mls_number, 'hmls' as listing_office
from hmls_commercial_temp
where mls_number
not in ( select substring_index(mls_number, '_', 1 )
as mls_num
from hmls_commercial )
Adam Lehman (Adobe) has a great blog entry
http://www.adrocknaphobia.com/post.cfm/breaking-railo-partners-with-jbossorg-to-open-source-cfml
On Fri, Jun 6, 2008 at 4:24 AM, Andy Matthews [EMAIL PROTECTED]
wrote:
I'd say that's a strong certainty. Maybe they think that if BD has to go
open
I think (and know) you are wrong.
Do you think it takes a week for a company like Railo to turn open
source with someone like Red Hat? Two weeks? ok.. a month?
Its a big business decision, that was taken before BD even announced
their intentions.
Gert Franz is the guy that runs Railo.
MD
I'd like to subscribe to a service (free would be great, but I'm more then
happy to pay for it) where my clients can post bugs, request features, submit
new tasks, etc.
What are other small time developers using? Is basecamp a good choice for this?
I love lighthouse. Love it, love it, love it.
We also use basecamp, but more for project knowledge sharing.
If you need a hosted solution, find a small cf hosting shop, and see if they
will install it for you, and charge you a monthly fee.
On Thu, Jun 5, 2008 at 7:52 PM, Jeff Gladnick [EMAIL
The LGPL2 license is much more attractive than a straight GPL license. I am
really not up on the nuances of OS licenses but from what I understand you
can package an app with the Railo runtime and not have to release the code
of your app as OS. The GPL license for Open BD was a deal breaker for
Hi gang,
I'm creating a cfwindow through a JS function. I can declare the
width, height, whether it's modal or not, etc through the function.
However when i try to define refreshOnShow:true The cfwindow doesn't
actually refresh. Here's the JS I'm using:
function
Hey Steve,
What do you mean by 'refresh'?
My understanding is that if you 'close' the window and then 'reopen' it,
that is when it would 'refresh'.
Also, After you run the function, does the window automatically show up, or
do you need to navigate to it first?
I mean that each time the window is opened the content is loaded fresh
rather than using the cached page. One of the attributes of the
cfwindow tag is refreshOnShow. It forces the window's content to be
loaded fresh each time to window is opened. However, since I am not
using the tag
On Fri, Jun 6, 2008 at 11:42 AM, Steve Good [EMAIL PROTECTED] wrote:
I mean that each time the window is opened the content is loaded fresh
rather than using the cached page. One of the attributes of the
cfwindow tag is refreshOnShow. It forces the window's content to be
loaded fresh each
OK, so here's an interesting behavior. I'm not saying it's a bug -- that's
fightin' words on this list. :)
The cfhttp tag has the resolveurl attribute which will attempt to fully qualify
image paths etc in the HTML you are getting.
cfhttp also has the redirect attribute that will follow 301
Ahh ok, that's the problem. We haven't upgraded yet.
Thanks!
Steve Good
http://lanctr.com
On Jun 5, 2008, at 11:03 PM, Kay Smoljak wrote:
On Fri, Jun 6, 2008 at 11:42 AM, Steve Good [EMAIL PROTECTED] wrote:
I mean that each time the window is opened the content is loaded
fresh
rather
72 matches
Mail list logo