Wednesday, 24 September 2008
|
| RE: SQL Replace Question John Stanley 03:48:53 |
| | Well, I tested this and it works fine on a 2k db NOT running in
compatability mode, so that is the issue. Now to find a workaround.
-----Original Message-----
From: John Stanley
Sent: Friday, February 04, 2005 11:35 AM
To: CF-Talk
Subject: OT:SQL Replace Question
Anyone have any idea why this code will not strip out the spaces in the
string "N0P 2L0"?
select Replace(postal_code,' ', '') from location where id = 1009637
when I change the last argument to 'X' it throws two X's in like it should.
We are running ms sql 2k in 6.5 compatibility mode, so I dont know if that
is the reason why it wont trim the spaces out.
If this is why, does anyone have a workaround that would work inside a join
clause like
oin zipinfo z on Replace(z.zip,' ','') = Replace(l.postal_code,' ','') when
running in compatibility mode?
TIA
John
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193119
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| |  1 answer | Add comment |
|
| Stopping endlessly looping query on remote server? Les Irvin 03:48:52 |
| | How does one stop an endlessly looping query on a remote server in MX6.1? I
guess the function CFUSION_DBCONNECTIONS_FLUSH is not supported in MX.
Ideas?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193202
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| | 2 answer | Add comment |
|
| RE: (Discount) was : Lets Talks Biz... Neal Bailey 03:48:51 |
| | Ok for those of you that are interested in the candles here is 20% Off
Discount for you... But you need to let me know what you honestly think of
the site and how the checkout process went. It's still new and I'm sure
there are bugs in the system. The site does not store credit card numbers
and I can never see them it goes straight to my merchant. This was
recommended via you guys. Also if you do need any thing is a hurry you may
want to check with me first to make sure I have it in stock. If I don't have
it then it will be a little over a week before I can get it to you.
Here is the Code: CFCANDLE
If you have any questions please let me know.
Neal Bailey
<http://www.blissfulessence.com/> www.blissfulessence.com
<mailto:bliss@blissfulessence.com> bliss@blissfulessence.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35
Message: http://www.houseoffusion.com/lists.cfm/link=i:5:112940
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13124.11887.5
|
| | 5 answers | Add comment |
|
| Relocation in time and space Maureen 03:48:50 |
| | I didn't really disappear. I simply time-traveled to the wilds of
rural Georgia to care for my dad. My step-mother, the queen of
cliches, decided to run off with dad's best friend.
As you may remember, Dad, who is 78, recently had major heart surgery,
so he needs someone with him at all times.
I am selling my house to my son and his SO, and moving to Middle
Georgia to take care of Dad on a permanent basis. So not only have I
relocated geographically, but I've time travelled back to the early
20th Century. No high speed Internet yet, and phone service consists
of tin can and string, so my on-line time is very limited until I can
get satellite Internet installed at some nebulous future date.
On the upside, it's quiet and beautiful here.
On the downside, the man never sleeps, he is addicted to the
telephone, and he has decided I have to help him find a new wife, on
the Internet. <G>
Hopefully, I'll adjust quickly. I'm bringing my furniture down this
weekend so I can recreate my nest. I'll have a lot more space as the
room here is twice the size of my existing bedroom. The only real
issue is moving all my books.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta
http://www.houseoffusion.com/banners/view.cfm?bannerid=40
Message: http://www.houseoffusion.com/lists.cfm/link=i:5:121402
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13124.11887.5
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| | 8 answers | Add comment |
|
| OT: SQL null bit Dave Francis 03:48:49 |
| | Help, I'm going mad. (This is a 2 part question)
SQL 2k, CF5.0
I have a db with a column defined as bit and I'd like to change null values
to 0. But I can't find a way to select just the null values.
SELECT COUNT(*) AS ct2 FROM table
GROUP BY sw
gives me three separate counts. Fine. But to count (and eventaully update)
only where sw = null, I've tried:
SELECT sw FROM table
WHERE sw = <cfqueryparam cfsqltype="cf_sql_bit" null="yes">
WHERE sw != 0 AND sw != 1
WHERE sw < 0
All return 0 records found.
WHERE sw < 1
Returns same as WHERE sw = 0
Second question. When checking directly against a database, date(timestamp)
fields can be compared ok. But if I issue the same code against a Q-o-Q, I
am getting errors. Is there some "trick" to Q-o-Q dates?
Thanks in advance to any and all
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta
http://www.houseoffusion.com/banners/view.cfm?bannerid=40
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:180483
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| | 5 answers | Add comment |
|
| RE: Outlook from CF Michael Dawson 03:48:48 |
| | I was able to do this with Exchange 5.5 and 2000, I think, but it all
broke when moving to Exchange 2003. Now, I use an ASP page that sits on
the Exchange server itself. This ASP page is called using CFHTTP and is
passed certain params such as the mailbox name. Then, the ASP page
performs a query on the Exchange server and returns the results in an
XML format back to the CFHTTP request. It's pretty slick and it lets me
sleep at night. I gave up on getting CF to connect to Exchange
directly.
It may be possible if you write a custom COM object, but I don't have a
reason to do that yet.
BTW, all my ASP page does is a shallow query on a mailbox to determine
the mailbox and folder sizes. It then returns that info back to
ColdFusion. This lets the user know their mailbox size as well as their
send/receive limits that are set in Active Directory.
M!ke
-----Original Message-----
From: Eric Hoffman [mailto:ehoffman-HKVekkKiN6UaFXM+NNs6yfeexA/PrMaR@public.gmane.org]
Sent: Wednesday, November 10, 2004 3:25 PM
To: CF-Talk
Subject: RE: Outlook from CF
You know, you are right. Just looking for examples. Just feel like I
am missing an obvious resource somewhere. 
-----Original Message-----
From: Burns, John D [mailto:john.burns-YB0j1H7FoeTuufBYgWm87A@public.gmane.org]
Sent: Wednesday, November 10, 2004 3:05 PM
To: CF-Talk
Subject: RE: Outlook from CF
You're actually not connecting to outlook, you're connecting to exchange
server. I'd assume this might be able to be done through ldap or
something like that. I'm not sure, I just wanted to clarify that
outlook is just the client and exchange is the server.
John
________________________________
From: Eric Hoffman [mailto:ehoffman-HKVekkKiN6UaFXM+NNs6yfeexA/PrMaR@public.gmane.org]
Sent: Wed 11/10/2004 3:47 PM
To: CF-Talk
Subject: Outlook from CF
I know this may have been done to death; but checked CFComet, and the
old code there for trying to connect to Outlook to display tasks seems
not to work.
Is there a relevant way or example or tags (free or $) to connect to a
users Task List in Outlook 2003? Server is Web Edition 2003 & CFMX 6.1
if that matters.
Thanks.
Eric
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183939
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| | 4 answer | Add comment |
|
| FCC Greenlights BPL (broadband over power lines) Jerry Johnson 03:48:47 |
| | Any comment on this? Any ham operators that have seen the overwhelming interference this creates?
And did anyone notice that SBC announced today 100% coverage for DSL?
Coincidence? I don't think so.
Jerry Johnson
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
http://www.houseoffusion.com/banners/view.cfm?bannerid=11
Message: http://www.houseoffusion.com/lists.cfm/link=i:5:131213
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13124.11887.5
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| | 1 answer | Add comment |
|
| Get file size on UNIX? John D Burns 03:48:46 |
| | I'm not a unix guy so I appologize for the (hopefully) easy question.
What's the easiest way to get the file size of a file that is already
sitting on the server? I need to loop over a list of files and save the
file size and name of each file to a db. Any help that can be offered
would be greatly appreciated. Thanks.
John Burns
Certified Advanced ColdFusion MX Developer
Wyle Laboratories, Inc. | Web Developer
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204930
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| | 11 answers | Add comment |
|
| WDDX Replacement Attempt - Take a Look! Jim Davis 03:48:45 |
| | I've made some decisions and posted some samples. Thanks everybody for all
your help!
I think I've hit upon an appropriate name... get ready... here it comes...
YODEL
It stand for "Yet another Open Data Exchange Language". Also Yodeling began
as a method for passing messaged from mountain peak to mountain peak using
only simple modulations of voice... all told it seems appropriate.
What do you guys think?
I've posted the XSD here:
http://www.depressedpress.com/yodel/yodel.xsd
I changed things around a little bit. I didn't make the metadata create new
types (to do that I would have had to allow the "type" attribute to take any
value). Instead I changed the "label" attribute.
<md> now takes a "name" attribute. <d> now takes a "metadata" attribute to
link it to the name. This is a little more descriptive that what I had.
I've completed the JavaScript serializer. It's included in my
dp_ObjectExtensions library. An early beta of this is here:
http://www.depressedpress.com/DepressedPress/Test/
The serializer in that library converts JavaScript objects to:
+) HTML (for use in a JS dump tag, also in the library).
+) YODEL (because that was really the point).
+) WDDX (because it deserves some love).
+) JSON (because I think its nifty).
The WDDX and JSON parsers are brand new - built from the group up and, if I
do say so myself, a little cleaner. They may also be faster (I'm using
REGEXs instead of per-character string parsing) but I'm not sure.
This is all alpha/beta level now - I'd love any testing you might want to
try (or suggestions for testing). The WDDX and JSON serializers should
always produce packets useable by the SDK parsers. The YODEL serializer
should always produce valid packets according to the XSD.
The code has been tested in FireFox 1 and IE 6.
In any case you're interested take a look. Let me know if you have any
suggestions or find any bugs.
Is anybody interested in contributing to this? The JavaScript deserializers
are going to be a bear, but doable. I'm looking to:
+) Rewrite the WDDX deserializer to take advantage of the DOM (which should
speed things up a lot).
+) Create the YODEL deserializer.
+) Create a new JSON deserializer (just so that it can be part of the object
extensions.)
+) Create a companion ColdFusion CFC that can serialize and deserialize
these three formats (yodel, WDDX and JSON) as well.
(I really think that the transfer mechanism shouldn't dictate software: by
combining all this stuff into single interfaces we're leaving the door open
to use the best enconding mechanism for the job, switching to another with
little work or just being able to provide multiple interfaces.)
If anybody wants to take one of those, or help in the testing it would be
very much appreciated.
Jim Davis
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215737
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| | 4 answer | Add comment |
|
| my new blog Robert Munn 03:48:42 |
| | I appear to have so much to write about these days that I just can't help myself. So I've started a blog to help me get it all out. I have a bunch of posts up already. Like I said, I can't help myself. Like my posts here on the Community list, the subjects tend to wander far afield from ColdFusion and software development. I just have too many hoobbies for my own good.
See it here:
http://www.rkurup.com/rmunn/blog/
BTW, I used Ray Camden's blog.cfc application for the site, thanks Ray.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:5:135836
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13124.11887.5
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| | 1 answer | Add comment |
|
| RE: Hiding a Flash Form Ken Ferguson 03:48:38 |
| | Hatton, why not just use an AS alert for your informational screen? You
could put it in a faked-out onload of the cfform.
I just want to make it perfectly clear that I have cold stolen this idea
from Philippe Maegerman's load movie work here: http://tinyurl.com/87y8o
You can use this to pop up a flash alert box on loading the cfform. I
would think you could work with it and format it so that it meets your
needs and would look quite spiffy to boot!
<!--- LOADMOVIE --->
<cffunction name="onLoad" output="yes">
<cfsaveContent variable="myOnLoad">
alert('what up yo? I think this is a great way to throw up some nice
welcome text...','Welcome');
</cfsavecontent>
<cfreturn myOnLoad>
</cffunction>
<!--- /LOADMOVIE --->
<cfform format="Flash" height="175">
<!--- ONLOAD TRIGGER --->
<cfinput type="text" height="0" width="0" name="test_hidden"
onchange="#onLoad()#">
<cfinput type="Hidden" name="test_trigger" height="0" width="0"
bind="{(test_hidden.text == '') ?
test_hidden.dispatchEvent({type:'change'}) : ''}">
<cfinput type="button" name="test" value="Confirm"
onclick="alert('Confirm please...','WARNING',YES|NO);" />
<!--- /ONLOAD TRIGGER --->
</cfform>
-----Original Message-----
From: C. Hatton Humphrey [mailto:chumphrey-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org]
Sent: Tuesday, April 26, 2005 9:43 AM
To: CF-Talk
Subject: SOT: Hiding a Flash Form
I have a large flash form that is being used to update information for
one of my clients. They have just asked for a "informational screen"
to be added before the form is displayed and I'm wondering if there is
a way to use positioning and layers to do this...
The idea that I had was to have a div (?) that layers over the flash
itself. Then the onclick of the button would make the div invisible.
In doing this, I have two questions - first is whether or not a DIV
can be layered over a flash movie. The second is if it's worth it to
try and do this?
Ideas?
Hatton
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:204461
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| | 2 answer | Add comment |
|
| My cat won't stop peeing... Paul Ihrig 03:48:37 |
| | taking my cat to the vet at 10:15
we left for a day came home last night & he is spraying & dribelling
every where...
he is fixed...
every time he sits he wont sit all the way down, when he moves there
is always a pudle.
looks like his stomache wont stop contracting.
looks swollen...
cant see if he has eaten any thing bad...
sucks. taking off work today...
have had him for 11-12 years was a year & 1/2 old when we got him..
not sure if this has some thing to do with age or what...
just sucks trying to maake him not feel bad.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta
http://www.houseoffusion.com/banners/view.cfm?bannerid=40
Message: http://www.houseoffusion.com/lists.cfm/link=i:5:128512
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13124.11887.5
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| | 39 answers | Add comment |
|
| DC Area Duane Boudreau 03:48:36 |
| | Hi All,
I have a couple of questions about the DC area.
In the past two days I've had phone calls from recruiters inquiring as to my
interest in taking positions in the DC area. Prior to this my wife and I had
already decided that are moving out the New England area, though DC wasn't
in the direction we had intended to move (much further North).
Can some of you from DC tell me a bit about the area? How does the cost of
living rank with New England? I've heard the horror of the traffic problems
but are they worse then Boston? Is it possible to work in the city and
commute from a more rural area? How does the school system rank nationwide?
Thanks,
Duane
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Protect your mail server with built in anti-virus protection. It's not only good for you, it's good for everybody.
http://www.houseoffusion.com/banners/view.cfm?bannerid=39
Message: http://www.houseoffusion.com/lists.cfm/link=i:5:130550
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13124.11887.5
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| | 6 answers | Add comment |
|
| Combining verity results with database query George Abraham 03:48:35 |
| | Hi all,
I have a verity search result (say VerityResults) that has the key as
the primary id of a database table. I know that I can use this primary
id as a parameter for retreiving results from the database like so:
<cfquery datasource ="thisDSN" name="thisQuery">
SELECT *
FROM thisTable
WHERE PrimaryID IN (#ValueList(VerityResults.Key),",")#)
</cfquery>
However I would like to order the results in thisQuery as the same as
thescore of the VerityResults. Is there some elegant way to do this
without resorting to a queryMerge UDF or somthing like that?
TIA,
George
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205230
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| | 10 answers | Add comment |
|
| CF+XPath Kam Figy 03:48:34 |
| | I've been investigating XmlSearch() and thought I'd share a few notes
for anyone interested.
XmlSearch() can behave similarly to Query of Queries - but not in its
original form.
XmlSearch returns an array of matching XML nodes, and that array is not
search-able, however its elements ARE; e.g.
x = XmlSearch( xml, '/foo/bar[1]' );
y = XmlSearch( x[1], 'baz' );
The really interesting thing is that CF's XPath behaves like a cursor in
the XML object - in the example above, you could search x for "/" and
get the whole document again.
Hope thats mildly interesting
Kam
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189035
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| | 2 answer | Add comment |
|
| cfmail sending 1 too many emails Phillip Perry 03:48:33 |
| | I have a cfmail that is "supposed" to send 2 emails to 1 person based on an
ID#. I have confirmed that the output is showing only 2 id numbers but it is
repeating 1 of them. This is what I have for code. I'm surrounding the
cfmail tags with cfloop query="myquery" to get the email address(among other
things). Here's the jist of it.....
<cfquery datasource="#mydbname#" name="GetUsers">
SELECT *
FROM contacts,ImageList
WHERE contacts.contact_id = ImageList.contact_id
</cfquery>
<cfif GetUsers.RecordCount IS NOT 0>
<CFLOOP QUERY="GetUsers" ><BR><cfmail FROM="support-oHC15RC7JGRl57MIdRCFDg@public.gmane.org"
SERVER="mail.applewoodcommunity.com" SUBJECT="The Applewood Community - Your
Monthly Statement" TO="#GetUsers.email_address#" TYPE="HTML"
WRAPTEXT="45">...yadda yadda yadda...</cfmail></cfloop></cfif>
<cfquery datasource="#mydbname#" name="GetUsers2">
SELECT *
FROM contacts,coupons
WHERE contacts.contact_id = coupons.contact_id
</cfquery>
<cfif GetUsers2.RecordCount IS NOT 0>
<CFLOOP QUERY="GetUsers2"><cfmail FROM="support-vQqXedkcMgmJLVpJL2nGXk5Kex9jXQ5X@public.gmane.org"
QUERY="GetUsers" SERVER="mail.applewoodcommunity.com" SUBJECT="The Applewood
Community - Your Monthly Statement" TO="#GetUsers2.email_address#"
TYPE="HTML" WRAPTEXT="45" >...yadda yadda yadda...</cfmail></cfloop></cfif>
Thanks
Phil
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185488
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| | 2 answer | Add comment |
|
| cfmx tailspin.......death follows Tony Weeg 03:48:32 |
| | ok.
in the past two days, and with no conceivable pattern, my cfmx server
has basically tailspun down to a slowwwwww death. it appears that a
query or two, some long ones, that are tuned to the nth degree, but
still require being time intensive, are being used, then slowly the
server dies. no response, restart the cfmx server, and we are good,
HIGHLY responsive, etc...
i can run the same cfm pages, after the restart
and ideas?
im using cfmx 6.1 on win2k adv. server.
i just put the jdbc hotfix on, so we will see if it continues to happen.
but, i guess i have another question...
why dont the pages just time out, and the sql server connection,
reset, and the whole request is just forgotten about? let me handle
the error...you know?
--
tony
Tony Weeg
human.
email: tonyweeg [at] gmail [dot] com
blog: http://www.revolutionwebdesign.com/blog/
Check out http://www.antiwrap.com to send websites to your friends.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:172421
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| | 1 answer | Add comment |
|
| Odd behavior of Dreamweaver Percy Perez 03:48:29 |
| | Hello,
I am having some problems with dreamweaver MX 2004.
Some of the problems I am experiencing are:
Datasources are not being listed ( I get an error about error in
Datasources.htm )
When I do copy and paste between a window application and dreamweaver (
DWShortcuts_HTML_Source_Paste commands in menu.xml, javascript error:
TypeError: MM.event has no property).
Both of the above errors have some javascript error message. I was
originally running Windows XP pro SP1 and updated the system to SP2 without
any problems. This new condition happen before I applied SP2.
The version of Dreamweaver is: 7.0.1
Any ideas/suggestions would be greatly appreciated.
Percy
Systems Administrator
Versa Products Company Inc
22 Spring Valley Road
Paramus NJ 07652
Ph:201.843.2400
Fx: 201.843.2931
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193824
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| | 7 answers | Add comment |
|
| Service Patch2 and ColdFusion? Neal Bailey 03:48:28 |
| | Hey guys...
Has anyone downloaded and installed the New Service patch 2 for Win XP?
Can be found here:
http://v5.windowsupdate.microsoft.com/en/default.asp
<http://v5.windowsupdate.microsoft.com/en/default.asp>
I have installed it on a test system and have found several issues with its
new security features it seems to have strict Active Content filtering now.
I was wondering if there are any issues with ColdFusion or anything else
that you guys may have run into. I'm trying to make sure our Intranet site
stay working when this thing is released.
Does anyone know of a site or list that address all the various issues?
Neal Bailey
Internet Marketing Manager
E-mail: <mailto:nbailey-1E0GY54dCTnQT0dZR+AlfA@public.gmane.org> nbailey-1E0GY54dCTnQT0dZR+AlfA@public.gmane.org
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=37
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:168960
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| | 1 answer | Add comment |
|
| Federal gov't employees attending MAX George Earl 03:48:27 |
| | I'm curious how many of the people on the list who are going to MAX are fed
gov't employees . . .
We get shut out each year because of timing. The conference comes too soon
after the start of the new fiscal year. We can't use funds from the previous
year and funds for the current year haven't been disbursed yet . . .
frustrating . . .
George
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta
http://www.houseoffusion.com/banners/view.cfm?bannerid=40
Message: http://www.houseoffusion.com/lists.cfm/link=i:5:132728
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13124.11887.5
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| | 2 answer | Add comment |
|
| RE: CFEclipse snippets, was JRun Servlet Error Spike 03:48:26 |
| | If you give the extends attribute a default value of
web-inf.cftags.cfcomponent you should be able to get around the problem.
Since every component extends that by default, you'll just be explicitly
declaring that's what it should extend. If you want to have it extend
something else you can.
So your snippet would look something like this:
<cfcomponent name="$${component name}"
extends="$${Extends:web-inf.cftags.cfcomponent}">
etc...
Spike
--------------------------------------------
Stephen Milligan
Code poet for hire
http://www.spike.org.uk
Do you cfeclipse? http://cfeclipse.tigris.org
-----Original Message----->From: listmaster-2K/2x8RPSj9p9z4BATjFtQC/G2K4zDHf@public.gmane.org >[mailto:listmaster-2K/2x8RPSj9p9z4BATjFtQC/G2K4zDHf@public.gmane.org] On Behalf Of Mark Drew>Sent: Monday, August 23, 2004 10:43 AM>To: CF-Talk>Subject: OT: CFEclipse snippets, was JRun Servlet Error> I got caught by the extends="" cfeclipse addition too.> I wonder if you can extend the snippets that you can say "dont add>this attribute if blank"> currently you can add (to cfeclipse) extends="$${extends}" to a>snippet so that if you add it you get a dialog box asking you to enter>extends..> you can then do extends="$${extends:somecomponent}" so that it>defaults to somecomponent, but I wonder if you can extend the snippet>(yet again) to have another variable that is>extends="$${extends:somecomponent:null}" so as to make it nullable..>(or something along those lines)> You could (with some programming added) also extend it the way they>work (super advanced now) so that if you want multiple choice vars you>could put> extends="$${extends:somevar|someothervar|somenicevar:drop}" so you>have a nice drop down>or>extends="$${extends:somevar|someothervar|somenicevar:check}" so that>you have tickboxes.> Just a though> On Mon, 23 Aug 2004 08:53:22 +0100, Andy Allan><andy-DXT9u3ndKiRNtO7EIQIIf61rZFiqucQu@public.gmane.org> wrote:>> I got caught out with that the first time I used CFEclipse >as it puts the>> extends="" attribute in regardless of whether you specify >anything or not.>> Too lazy to see if there is a way to prevent it...>> Quoting Geoff Bowers <modius-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>:>> I thought I might follow on from Spike's email on CFMX errors that>> > drive you insane I was recently building a few components (in>> > FarCry also funnily enough) when I came across this error that just>> > wouldn't go away:>> > "Component names cannot start or end with dots.">> > Turns out I had a rogue extends="" in the CFCOMPONENT tag. > I had text>> > wrap off in the editor so I didn't see it till I started >going through>> > the code line by line.>> > ----- Original Message ----->> > From: Spike <spike-1I2aIwHmymXpIgCt6eIbzw@public.gmane.org>>> > Date: Wed, 11 Aug 2004 14:29:42 -0700>> > Subject: JRun Servlet Error>> > To: CF-Talk <cf-talk-2K/2x8RPSj9p9z4BATjFtQC/G2K4zDHf@public.gmane.org>>> > So I started digging around in the logs to see if there >was anything. All I>> > got was the following in the CFMX exception log:>> > "Error","jrpp-1","08/11/04","13:12:46","locher"," The >specific sequence of>> > files included or processed is: >C:\Farcry\HEAD\farcry_core\admin\index.cfm>> > ">> > java.lang.StackOverflowError>> > Eventually after running around for most of today trying >to figure out what>> > was going on I tracked it down to a <cfproperty> tag that >was missing the>> > end '>' in one of my custom types.>> >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta
http://www.houseoffusion.com/banners/view.cfm?bannerid=40
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:175554
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=13123.11886.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
|
| | 1 answer | Add comment |
|
| Site Check Ian Skinner 03:48:22 |
| | Well, I got my design layed out like I wanted, now I have attempted to
color it. So does this work? Does it envoke a season? If so, what season?
http://www.sierraoutdoorrecreation.com/index2.cfm
~~~~~~~~~~~~~~~~~~~& | |
