RE: Get current row value in CFLOOP

2003-09-12 Thread webmaster
Sorry, yeah, looping over a query.  I did get the right variable pulling
technique going...but I don't even want to speak to the Inetrode style
freakiness in that loop...had one loop that had to loop another due to some
purely funky imports from a terrible database design...and the initial loop
value kept repeating itself rather than advancing...

Well, I appreciate the help.  This list is pure gold.

Eric

-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 12, 2003 9:50 PM
To: CF-Talk

What kind of loop is it? If you are looping over a query, and you want the
value of column X, you can just output #x#. Or if you want to dynamically
select the column, you could do #queryname[columname][currentrow]#

If you doing a simple index loop, then you already know the current index.


===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
(www.mindseye.com)
Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia)

Email: [EMAIL PROTECTED]
Blog : www.camdenfamily.com/morpheus/blog
Yahoo IM : morpheus

"My ally is the Force, and a powerful ally it is." - Yoda 

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 12, 2003 8:32 PM
> To: CF-Talk
> Subject: Get current row value in CFLOOP
> 
> 
> I forgot how to do this..
> 
> Have a loop, want to grab the current value of an item from that row.
> 
> I went with  loopname.currentrow.topic_id
> 
> Error
> 
> Is it loopname.topic_id[currentrow] or something that that instead??
> 
> Thanks!!!
> 
> Regards,
> 
> Eric J. Hoffman
> DataStream Connexion
> www.datastreamconnexion.com
> 
> 
> 
> 
> 

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


Re: No so good news

2003-09-12 Thread Paul Hastings
> 2:26pm.  A frothy Guinness is only 2 hrs 35 mins away...

matt, never knew you lived within 2.58 hours of dublin. i don't believe the
travel distance, even for well maintained guinness, goes much beyond that.
not that it keeps pubs/bars from trying anyway.


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


Accessing global UDF's from within CFC's

2003-09-12 Thread Rich Z
I have a collection of global functions that I'd like to make available
as good'ol functions (w/o invoking/instantiating) to other functions in
CFC's. It's essentially an include file of functions that I include
application.cfm.
 
Is this possible?
 
-Rich

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


RE: No so good news

2003-09-12 Thread Jim Davis
No problem.  It's just that some people are taking this as an "MS
finally gets theirs" situation when the ramifications are
(unfortunately) really much larger than that.

I'm waiting for the definition of "browser" to come up - any hyper-text
system (CD ROM encyclopedias, help systems, computer assisted training,
etc) may be affected by this.

I fully expect it to be thrown out in a higher court, but it does raise
some scary issues.

Jim Davis

> -Original Message-
> From: Dave Carabetta [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 12, 2003 9:40 PM
> To: CF-Talk
> Subject: Re: No so good news
> 
> > > Well, this particular patent only applies to ActiveX plugins to
the
> > > browser,
> > > such as Flash, Excel, and QuickTime, to name a few. Since CF is
simply
> > > HTML
> > > when all is said and done, this case doesn't effect CF in any way
> > other
> > > than
> > > potentially the cfchart tag (if rendering flash images) and flash
> > > interfaces
> > > (i.e., flash remoting).
> >
> > I don't believe that this patent "only applies to ActiveX plugins" -
it
> > applies to ANY automated delivery of executable content: that covers
> > Java and the Netscape Plugin architecture as well.
> >
> > Basically anything called with an "Object", "Embed" or "Applet" tag.
> >
> 
> In my head that's what I meant. I just refer to any external program
that
> gets embedded into the browser as ActiveX objects, if for no other
reason,
> laziness. Sorry for any confusion.
> 
> Regards,
> Dave.
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


RE: Get current row value in CFLOOP

2003-09-12 Thread Jeff Garza
Depends on what you are looping over...

Looping over a list: listgetat(listname, position, delimiter)

Looping over an array:  arrayname[index]

Looping over a query: queryname.columnname[index]

Hope this helps...

Jeff Garza

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 12, 2003 7:32 PM
To: CF-Talk
Subject: Get current row value in CFLOOP


I forgot how to do this..

Have a loop, want to grab the current value of an item from that row.

I went with  loopname.currentrow.topic_id

Error

Is it loopname.topic_id[currentrow] or something that that instead??

Thanks!!!

Regards,

Eric J. Hoffman
DataStream Connexion
www.datastreamconnexion.com





~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


RE: Get current row value in CFLOOP

2003-09-12 Thread Barney Boisvert
Sounds like this is what you want:


  


This will do the same thing, though with this format you can go backwards,
run rows twice, skip rows, and generally do a lot of other crazy stuff:


  


barneyb

---
Barney Boisvert, Senior Development Engineer
AudienceCentral
[EMAIL PROTECTED]
voice : 360.756.8080 x12
fax   : 360.647.5351

www.audiencecentral.com


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 12, 2003 7:32 PM
> To: CF-Talk
> Subject: Get current row value in CFLOOP
>
>
> I forgot how to do this..
>
> Have a loop, want to grab the current value of an item from that row.
>
> I went with  loopname.currentrow.topic_id
>
> Error
>
> Is it loopname.topic_id[currentrow] or something that that instead??
>
> Thanks!!!
>
> Regards,
>
> Eric J. Hoffman
> DataStream Connexion
> www.datastreamconnexion.com
>
>
>
>
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


RE: Get current row value in CFLOOP

2003-09-12 Thread Raymond Camden
What kind of loop is it? If you are looping over a query, and you want
the value of column X, you can just output #x#. Or if you want to
dynamically select the column, you could do
#queryname[columname][currentrow]#

If you doing a simple index loop, then you already know the current
index.


===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
(www.mindseye.com)
Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia)

Email: [EMAIL PROTECTED]
Blog : www.camdenfamily.com/morpheus/blog
Yahoo IM : morpheus

"My ally is the Force, and a powerful ally it is." - Yoda 

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
> Sent: Friday, September 12, 2003 8:32 PM
> To: CF-Talk
> Subject: Get current row value in CFLOOP
> 
> 
> I forgot how to do this..
> 
> Have a loop, want to grab the current value of an item from that row.
> 
> I went with  loopname.currentrow.topic_id
> 
> Error
> 
> Is it loopname.topic_id[currentrow] or something that that instead??
> 
> Thanks!!!
> 
> Regards,
> 
> Eric J. Hoffman
> DataStream Connexion
> www.datastreamconnexion.com
> 
> 
> 
> 
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


Get current row value in CFLOOP

2003-09-12 Thread webmaster
I forgot how to do this..

Have a loop, want to grab the current value of an item from that row.

I went with  loopname.currentrow.topic_id

Error

Is it loopname.topic_id[currentrow] or something that that instead??

Thanks!!!

Regards,

Eric J. Hoffman
DataStream Connexion
www.datastreamconnexion.com




~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


RE: Anyone know of a decent SQL ide?

2003-09-12 Thread Samuel Neff
Chris mentioned Query Analyzer so he's on MSSQL and thus Oracle is
off-thread, but anyways.. :)

We use OraEdit for Oracle.  It's a fraction of the cost of TOAD and has all
the features (as far as I can tell).

Sam

--
Blog:  http://www.rewindlife.com
Chart: http://www.blinex.com/products/charting
--  

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
> Sent: Friday, September 12, 2003 1:25 PM
> To: CF-Talk
> Subject: RE: Anyone know of a decent SQL ide?
> 
> even funnier, I haven't seen the original post yet, but three 
> replies so far!
> 
> What RDBMS are you using Chris?  We use Toad from Quest 
> software as we are an Oracle shop.  It rocks.
> 
> Doug

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


Re: Flash Remoting? wasRE: RE: No so good news

2003-09-12 Thread Dave Carabetta
> It looks like the potential impact is more related to plug-in's so Flash
more than CF would be impacted.  I wonder whether this could make Flash
Remoting of greater relevance, any thoughts or opinions on that?
>

I don't see why FR would have *more* relevance. I mean, when you use FR,
you're connecting a Flash interface to a Java/.NET/MX backend, correct? So
if, in the worst case scenario, plugins like Flash become crippled, wouldn't
FR be just as screwed? What's the good of FR if you can't have the Flash
front end? If I'm missing something, by all means let me know, as that's
entirely possible. ;)

Regards,
Dave.
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Re: No so good news

2003-09-12 Thread Dave Carabetta
> > Well, this particular patent only applies to ActiveX plugins to the
> > browser,
> > such as Flash, Excel, and QuickTime, to name a few. Since CF is simply
> > HTML
> > when all is said and done, this case doesn't effect CF in any way
> other
> > than
> > potentially the cfchart tag (if rendering flash images) and flash
> > interfaces
> > (i.e., flash remoting).
>
> I don't believe that this patent "only applies to ActiveX plugins" - it
> applies to ANY automated delivery of executable content: that covers
> Java and the Netscape Plugin architecture as well.
>
> Basically anything called with an "Object", "Embed" or "Applet" tag.
>

In my head that's what I meant. I just refer to any external program that
gets embedded into the browser as ActiveX objects, if for no other reason,
laziness. Sorry for any confusion.

Regards,
Dave.
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


Re: Nested Function Order Bug?

2003-09-12 Thread Claude Schneegans
>>I'm not sure it's *only* for use inside the cfquery tag,

Anyway, it does not make sense, since it's only role is to prenvent something from 
hapening inside a query.
There is nothing to prevent outside.
I know it is nor your case, since you isolated the code for debugging purpose,
but I've seen how many times in the forum people "preparing" their variable
for the query, calling preserveSinglequotes BEFORE the query.
Hey that would make a good candidate fo "ShittyCode.com" ;-))

>>PreserveSingleQuotes() can only take a variable and
not a string literal as its argument.

Not a string, nor a constant, nor an expression. In that sense it is really an 
exception in the language,
not even strictly speaking a "function". It is just a special and odd "language 
construct".


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


RE: ?id=23

2003-09-12 Thread Jim Davis
> -Original Message-
> From: [EMAIL PROTECTED] [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 12, 2003 5:53 PM
> To: CF-Talk
> Subject: ?id=23
> 
> All,
> 
> I have an application that passes an id value through a hyperlink that
> the user clicks on in an e-mail. The id feeds the page and extracts
> information and populates the form fields with the user's information.
> 
> THE PROBLEM:
> If a user is viewing their customized information with their user
id=23,
> than what would prevent them from view other people's information by
> editing the id value to say, id=24?

Nothing, apparently.  ;^)

> SOLUTIONS: ???
> 1) Should I scramble the value in some long string and extract a value
> from it? For example for id=23 replace it with id=ei38skdh23skdu83 and
> pull 23 out of the string?

This is known as "security through obfuscation" and is never a good
idea.  Sooner or later somebody will figure it out.

> 2) Set a cookie that contains the same id value and if the values
don't
> match kick them out to some other page?

I wouldn't bother as both values are sent in the same page - it wouldn't
be hard to spoof.

Obviously at the front end you're doing something to ensure that the
user can see ID number 23, right?  I would just do that again... before
you display anything run an entitlement check.

If they change the number they'd be hit with a "you can't see this"
message.

Jim Davis


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


Re: ?id=23

2003-09-12 Thread Jason Ross
On Fri, 12 Sep 2003, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
> All,
>
> I have an application that passes an id value through a hyperlink that
> the user clicks on in an e-mail. The id feeds the page and extracts information and 
> populates the form fields with the user's information.
>
> THE PROBLEM:
> If a user is viewing their customized information with their user id=23, than what 
> would prevent them from view other people's information by editing the id value to 
> say, id=24?

Nothing would stop them from altering it. One way to prevent this is to create a 
session and then
set a sesion variable with their user id (this would be accessed via #SESSION.userid# 
for example)
The benefit to this is, while they could alter the URL, it is quite a bit harder to 
forge a session
correctly (since it uses the CFID and CFTOKEN, in addition to the variable stored in 
the SESSION scope).

Jason
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


RE: ?id=23

2003-09-12 Thread cf
wasnt that bad of an answer was it, lol

btw~ I think they found vikki & as far as i know shes alive













> you crack me up dave
>
> tw
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 12, 2003 6:41 PM
> To: CF-Talk
> Subject: Re: ?id=23
>
>
> im sure i will get bashed for this answer but here is something i have
> done before
>



> on the link that that would take you to the detail page you normally
> pass
> the info along via the url.
>
> Well im not sure how correct this is but I have before done the same
> thing
> by setting the link as a session variable and passed it along to the
> detail page then filtered the detail page by that variable, and whalla:)
>
> so you'd get this:
> www.your_site.com/details.cfm
> instead of
> www.your_site.com/details.cfm?id=24
>
> and i dont think they could go into the browser & type it in because the
> detail page is sorted by a session.
>
> but i have no idea what the hell im doing, so we may want to get some
> others input on this first, lol
>
> dave
>
>
>> All,
>>
>> I have an application that passes an id value through a hyperlink that
>> the user clicks on in an e-mail. The id feeds the page and extracts
>> information and populates the form fields with the user's information.
>>
>> THE PROBLEM:
>> If a user is viewing their customized information with their user
> id=23,
>> than what would prevent them from view other people's information by
>> editing the id value to say, id=24?
>>
>> SOLUTIONS: ???
>> 1) Should I scramble the value in some long string and extract a value
>> from it? For example for id=23 replace it with id=ei38skdh23skdu83 and
>> pull 23 out of the string? 2) Set a cookie that contains the same id
>> value and if the values don't match kick them out to some other page?
>>
>> Any suggestions would be great.
>>
>> D-
>>
>
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


RE: ?id=23

2003-09-12 Thread Tony Weeg
you crack me up dave

tw

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 12, 2003 6:41 PM
To: CF-Talk
Subject: Re: ?id=23


im sure i will get bashed for this answer but here is something i have
done before

on the link that that would take you to the detail page you normally
pass
the info along via the url.

Well im not sure how correct this is but I have before done the same
thing
by setting the link as a session variable and passed it along to the
detail page then filtered the detail page by that variable, and whalla:)

so you'd get this:
www.your_site.com/details.cfm
instead of
www.your_site.com/details.cfm?id=24

and i dont think they could go into the browser & type it in because the
detail page is sorted by a session.

but i have no idea what the hell im doing, so we may want to get some
others input on this first, lol

dave


> All,
>
> I have an application that passes an id value through a hyperlink that
> the user clicks on in an e-mail. The id feeds the page and extracts
> information and populates the form fields with the user's information.
>
> THE PROBLEM:
> If a user is viewing their customized information with their user
id=23,
> than what would prevent them from view other people's information by
> editing the id value to say, id=24?
>
> SOLUTIONS: ???
> 1) Should I scramble the value in some long string and extract a value
> from it? For example for id=23 replace it with id=ei38skdh23skdu83 and
> pull 23 out of the string? 2) Set a cookie that contains the same id
> value and if the values don't match kick them out to some other page?
>
> Any suggestions would be great.
>
> D-
> 

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


Re: ?id=23

2003-09-12 Thread cf
im sure i will get bashed for this answer but here is something i have
done before

on the link that that would take you to the detail page you normally pass
the info along via the url.

Well im not sure how correct this is but I have before done the same thing
by setting the link as a session variable and passed it along to the
detail page then filtered the detail page by that variable, and whalla:)

so you'd get this:
www.your_site.com/details.cfm
instead of
www.your_site.com/details.cfm?id=24

and i dont think they could go into the browser & type it in because the
detail page is sorted by a session.

but i have no idea what the hell im doing, so we may want to get some
others input on this first, lol

dave


> All,
>
> I have an application that passes an id value through a hyperlink that
> the user clicks on in an e-mail. The id feeds the page and extracts
> information and populates the form fields with the user's information.
>
> THE PROBLEM:
> If a user is viewing their customized information with their user id=23,
> than what would prevent them from view other people's information by
> editing the id value to say, id=24?
>
> SOLUTIONS: ???
> 1) Should I scramble the value in some long string and extract a value
> from it? For example for id=23 replace it with id=ei38skdh23skdu83 and
> pull 23 out of the string? 2) Set a cookie that contains the same id
> value and if the values don't match kick them out to some other page?
>
> Any suggestions would be great.
>
> D-
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Re:?id=23

2003-09-12 Thread coldfusion . developer
Thanks to all for your replies.  The encrypt is just what i was looking for.

D-

>encrypt on the way up and decrypt it when you use it on your form page to
>pull back the record's data
>
>Bryan Stevenson B.Comm.
>VP & Director of E-Commerce Development
>Electric Edge Systems Group Inc.
>t. 250.920.8830
>e. [EMAIL PROTECTED]
>
>-
>Macromedia Associate Partner
>www.macromedia.com
>-
>Vancouver Island ColdFusion Users Group
>Founder & Director
>www.cfug-vancouverisland.com
>- Original Message -
>From: <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Friday, September 12, 2003 2:52 PM
>Subject: ?id=23
>
>
>> All,
>>
>> I have an application that passes an id value through a hyperlink that
>> the user clicks on in an e-mail. The id feeds the page and extracts
>information and populates the form fields with the user's information.
>>
>> THE PROBLEM:
>> If a user is viewing their customized information with their user id=23,
>than what would prevent them from view other people's information by editing
>the id value to say, id=24?
>>
>> SOLUTIONS: ???
>> 1) Should I scramble the value in some long string and extract a value
>from it? For example for id=23 replace it with id=ei38skdh23skdu83 and pull
>23 out of the string?
>> 2) Set a cookie that contains the same id value and if the values don't
>match kick them out to some other page?
>>
>> Any suggestions would be great.
>>
>> D-
>> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Re: Any way to get Homesite+ 5.5 without Dreamweaver?

2003-09-12 Thread Calvin Ward
I think they should bring 2004 up to par and ditch CFS. Then we wouldn't
have these weekly discussions :P

- Calvin

- Original Message - 
From: "Michael Traher" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, September 12, 2003 6:11 PM
Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver?


> Thanks Dave. So to stick with what is largely the same product i.e HS+ I
> need to spend $199. Or I could just stick with CF5 and some cobbled
> together help files.
>
> Or we could use HS+ updated to 5.2, from the DWMX CD thats lying around.
>
> Or we could all invest time and effort and get to grips with DWMX2004,
> but we don't really need the extra features.
>
> I feel that for holders of a CFS5 licence, there should be a cheap or
> free upgrade to CFS6.1 - (you can call it HS+ 5.5 if that makes you
> happy ;-)
> -Original Message-
> From: Dave Watts <[EMAIL PROTECTED]>
> To: CF-Talk <[EMAIL PROTECTED]>
> Date: Fri, 12 Sep 2003 14:01:00 -0400
> Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver?
>
> > > If you have already paid for CF Studio 5 - what are your
> > > upgrade options and what will they cost?
> >
> > It's $199 to upgrade from CF Studio 5 to Dreamweaver MX 2004 with
> > Homesite+
> > 5.5.
> >
> > > I really want to know 'cos, I'm getting quite confused. My
> > > developers only want to use a lean mean code editor -i.e.
> > > CFStudio/HS+
> >
> > Everything you could possibly want to know is right on the Macromedia
> > site.
> >
> > Dave Watts, CTO, Fig Leaf Software
> > http://www.figleaf.com/
> > voice: (202) 797-5496
> > fax: (202) 797-5444
> >
> >
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


Session Variable

2003-09-12 Thread lee
Before a user can get to any personal info, they should have to log in. If 
authenticated, set a session variable (session_id = 23) and use that instead of URL 
variable.

Clear the structure when user logs out.

>All,
>
>I have an application that passes an id value through a hyperlink 
>that
>the user clicks on in an e-mail. The id feeds the page and extracts 
>information and populates the form fields with the user's information.  
>
>
>THE PROBLEM:
>If a user is viewing their customized information with their user 
>id=23, than what would prevent them from view other people's 
>information by editing the id value to say, id=24?
>
>SOLUTIONS: ???
>1) Should I scramble the value in some long string and extract a value 
>from it? For example for id=23 replace it with id=ei38skdh23skdu83 and 
>pull 23 out of the string?
>2) Set a cookie that contains the same id value and if the values 
>don't match kick them out to some other page?
>
>Any suggestions would be great.
>
D-
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


Re: CF MX *right* book.

2003-09-12 Thread Calvin Ward
I'm starting to buy less and less large books, in fact. I've almost made it
a mission to avoid the big ones.

I've got Hal Helm's CFC book, and that's just about right for size and
content. Dreamweaver MX Extensions, fairly focused and concise. UML
Distilled, also focused. Javascript Cookbook from O'Reilly also really
exactly what I need.

I'm not forking over 50+ dollars for a book that contains material that
doesn't belong, it's simply not worth it, my money is better spent
elsewhere.

As a general rule, I now consider the larger tomes, lesser works.

- Calvin


- Original Message - 
From: "Hal Helms" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, September 12, 2003 5:10 PM
Subject: RE: CF MX *right* book.


> Thanks for the kind words. I agree with you about having small,
> well-focused books but the big publishers (and a depressingly large
> number of developers) seem to judge books on a dollar per pound basis.
> That causes authors to HAVE to fluff up the books to hit a minimum
> contractual page count.
>
> Hal Helms
> See halhelms.com for classes in...
> Java for ColdFusion Programmers
> Fusebox 4
> Mach-II
> OO Applications with CFCs
>
> -Original Message-
> From: Kevin Graeme [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 12, 2003 3:28 PM
> To: CF-Talk
> Subject: Re: CF MX *right* book.
>
>
> Buy them all, you know you want to.
>
> Really though, we bought several that on the face would cover the same
> material. But when you actually peruse them, they each have different
> strengths. But I agree that many of them cover material that is often
> unneeded.
>
> To the authors:
> I'd love separate, focused books instead of the monster tome. The Hal
> Helms book on CFCs is a great example. It's small but dense with
> information. Now if I could just buy books like that on CF/SQL
> interaction, cfscript, cf design frameworks, blah blah. And I've seen
> authors here complain about not being able to get everything in. I know
> some of them exist, but they seem the exception rather than the norm.
> Other developers I've talked to would love a light and tight set of
> books.
>
> -Kevin
>
> - Original Message - 
> From: "Alexandr Timchur" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, September 12, 2003 10:30 AM
> Subject: CF MX *right* book.
>
>
> > Hi All,
> >
> > Can you recommend me a right book discovering new features of
> > ColdFusion MX, especially CFC, without long speech about SQL &
> > Coldfusion basics?
> >
> >
> > Thank you!
> > Alex Timchur
> >
> >
> >
>
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


RE: Any way to get Homesite+ 5.5 without Dreamweaver?

2003-09-12 Thread Michael Traher
Thanks Dave. So to stick with what is largely the same product i.e HS+ I 
need to spend $199. Or I could just stick with CF5 and some cobbled 
together help files.

Or we could use HS+ updated to 5.2, from the DWMX CD thats lying around.

Or we could all invest time and effort and get to grips with DWMX2004, 
but we don't really need the extra features.

I feel that for holders of a CFS5 licence, there should be a cheap or 
free upgrade to CFS6.1 - (you can call it HS+ 5.5 if that makes you 
happy ;-)
-Original Message-
From: Dave Watts <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Date: Fri, 12 Sep 2003 14:01:00 -0400
Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver?

> > If you have already paid for CF Studio 5 - what are your 
> > upgrade options and what will they cost?
> 
> It's $199 to upgrade from CF Studio 5 to Dreamweaver MX 2004 with
> Homesite+
> 5.5.
>  
> > I really want to know 'cos, I'm getting quite confused. My 
> > developers only want to use a lean mean code editor -i.e. 
> > CFStudio/HS+
> 
> Everything you could possibly want to know is right on the Macromedia
> site.
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
> 
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


Re: ?id=23

2003-09-12 Thread Bryan Stevenson
encrypt on the way up and decrypt it when you use it on your form page to
pull back the record's data

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, September 12, 2003 2:52 PM
Subject: ?id=23


> All,
>
> I have an application that passes an id value through a hyperlink that
> the user clicks on in an e-mail. The id feeds the page and extracts
information and populates the form fields with the user's information.
>
> THE PROBLEM:
> If a user is viewing their customized information with their user id=23,
than what would prevent them from view other people's information by editing
the id value to say, id=24?
>
> SOLUTIONS: ???
> 1) Should I scramble the value in some long string and extract a value
from it? For example for id=23 replace it with id=ei38skdh23skdu83 and pull
23 out of the string?
> 2) Set a cookie that contains the same id value and if the values don't
match kick them out to some other page?
>
> Any suggestions would be great.
>
> D-
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


RE: ?id=23

2003-09-12 Thread Andy Ousterhout
I use a class called User that is instantiated as a system variable when a
User logs in and out.  In User I have methods to authenticate User for login
and another authorize access to pages and data within a page.

Andy

-Original Message-
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Friday, September 12, 2003 4:53 PM
To: CF-Talk
Subject: ?id=23


All,

I have an application that passes an id value through a hyperlink that
the user clicks on in an e-mail. The id feeds the page and extracts
information and populates the form fields with the user's information.

THE PROBLEM:
If a user is viewing their customized information with their user id=23,
than what would prevent them from view other people's information by editing
the id value to say, id=24?

SOLUTIONS: ???
1) Should I scramble the value in some long string and extract a value from
it? For example for id=23 replace it with id=ei38skdh23skdu83 and pull 23
out of the string?
2) Set a cookie that contains the same id value and if the values don't
match kick them out to some other page?

Any suggestions would be great.

D-

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Courseware for Coldfusion

2003-09-12 Thread Trey Rouse
Hey folks,

 

I've been asked to do some internal training for some CF wannabe's in our
department.  I've seen the materials that came with FasTrak to Coldfusion
MX, but can't seem to find a way of purchasing a few copies for our internal
use.

 

Is anyone aware of where something like this might be had?  I ask, as
putting all that together ones self is no small undertaking.

 

Thanks,

 

Trey Rouse

Data Applications Architect

Rice University


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


?id=23

2003-09-12 Thread coldfusion . developer
All,

I have an application that passes an id value through a hyperlink that
the user clicks on in an e-mail. The id feeds the page and extracts information and 
populates the form fields with the user's information.  

THE PROBLEM:
If a user is viewing their customized information with their user id=23, than what 
would prevent them from view other people's information by editing the id value to 
say, id=24?

SOLUTIONS: ???
1) Should I scramble the value in some long string and extract a value from it? For 
example for id=23 replace it with id=ei38skdh23skdu83 and pull 23 out of the string?
2) Set a cookie that contains the same id value and if the values don't match kick 
them out to some other page?

Any suggestions would be great.

D-
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


RE: No so good news

2003-09-12 Thread Jim Davis
Of course we can play conspiracy... but do you really think that MS
would be so interested in killing Flash that it would also kill media
player integration, office integration, COM and .NET?

I don't think so.

Jim Davis

> -Original Message-
> From: David Keevil [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 12, 2003 4:42 PM
> To: CF-Talk
> Subject: Re: No so good news
> 
> 
> Well if you were MS and you wanted to kill Flash, losing this case
just
> might be a good way to do it. Granted, they may have underestimated
the
> damages but I don't think they would mind seeing Flash go away.
> 
> 
> --David K
> 
> - Original Message -
> From: "Jeremy" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, September 12, 2003 12:06 PM
> Subject: No so good news
> 
> 
> > Off topic but it is Friday after all.
> >
> > Bad News :(
> >
> > http://news.com.com/2104-1032_3-5074799.html
> >
> > http://www.zeldman.com
> >
> >
> >
> >
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


RE: No so good news

2003-09-12 Thread Jim Davis
> -Original Message-
> From: Dave Carabetta [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 12, 2003 4:39 PM
> To: CF-Talk
> Subject: RE: No so good news
> 
> >I have some faith in M$'s ability to appeal things into oblivion. The
> >Net needs to be free to work, and that applies to IE as well. This
> >patent does seem overly broad in that other technologies use
> >sub-programs, why should browsers be so special?
> >
> >What I wonder about is the impact on CF. What changes would CFMX have
to
> >make in order to avoid infringement? Would we have to click a button
in
> >order to get file dialogs to pop up, or what?
> >
> 
> Well, this particular patent only applies to ActiveX plugins to the
> browser,
> such as Flash, Excel, and QuickTime, to name a few. Since CF is simply
> HTML
> when all is said and done, this case doesn't effect CF in any way
other
> than
> potentially the cfchart tag (if rendering flash images) and flash
> interfaces
> (i.e., flash remoting).

I don't believe that this patent "only applies to ActiveX plugins" - it
applies to ANY automated delivery of executable content: that covers
Java and the Netscape Plugin architecture as well.

Basically anything called with an "Object", "Embed" or "Applet" tag.

Jim Davis 


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Re: No so good news

2003-09-12 Thread Bryan Stevenson
oo...someone out there know's of Swan'sdo tell ;-)

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
- Original Message -
From: "David Keevil" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, September 12, 2003 2:19 PM
Subject: Re: No so good news


> > What would happen if the sky were pink?
> >
> > What if aliens landed?
> >
> > What if I put my pants on backwards?
>
> Sounds like you've already started with the Tequilla, Brian...   ;-)
> Don't forget the beer chaser over at Swan's...
>
> Happy Friday!
>
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


Re:Odd ReReplace issue

2003-09-12 Thread lee
If you're using FuseBox and REReplace blah blah, you're using CF functions. Yes?

So use CFIF instead of the REReplace to parse/suppress the issue. Make this a core 
function. It's SO much cleaner.

>At 05:11 PM 9/12/2003 -0400, you wrote:
>>Static or not, are they ".cfm" or ".html/.htm" pages?
>>
>>If the former, can use CF operators
>
>.html. What I do is read in values out of the URL, and then go fetch the 
>appropriate HTML file, using , and then monkey with the content and 
>just output the one string to the browser.
>
>I basically have every link going to an index.cfm file (using fusebox), so 
>I have a core set of functions that I run on the HTML file's content each 
>time a page gets called, before tossing it out to the user's browser. That 
>ReReplace was just one of'em. 
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


RE: CF MX *right* book.

2003-09-12 Thread Bryan F. Hogan
Not technical enough for me.

-Original Message-
From: Jim Campbell [mailto:[EMAIL PROTECTED]
Sent: Friday, September 12, 2003 5:17 PM
To: CF-Talk
Subject: Re: CF MX *right* book.


The "Reality" books fall into this category - FlashMX integration, J2EE
integration, etc.

- Jim

Bryan F. Hogan wrote:

>If one can develop a well-focused book I would be more than willing to
>donate some money to help the author self-publish.
>
>-Original Message-
>From: Hal Helms [mailto:[EMAIL PROTECTED]
>Sent: Friday, September 12, 2003 5:11 PM
>To: CF-Talk
>Subject: RE: CF MX *right* book.
>
>
>Thanks for the kind words. I agree with you about having small,
>well-focused books but the big publishers (and a depressingly large
>number of developers) seem to judge books on a dollar per pound basis.
>That causes authors to HAVE to fluff up the books to hit a minimum
>contractual page count.
>
>Hal Helms
>See halhelms.com for classes in...
>Java for ColdFusion Programmers
>Fusebox 4
>Mach-II
>OO Applications with CFCs
>
>

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


RE: No so good news

2003-09-12 Thread Matt Robertson
What about the fiendish brain-sucking aliens?  Remember, they live among us.

(ominous theme music begins... )

2:26pm.  A frothy Guinness is only 2 hrs 35 mins away...



--
---
 Matt Robertson, [EMAIL PROTECTED]
 MSB Designs, Inc. http://mysecretbase.com
---

--
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


Re: CF MX *right* book.

2003-09-12 Thread Jim Campbell
The "Reality" books fall into this category - FlashMX integration, J2EE 
integration, etc.

- Jim

Bryan F. Hogan wrote:

>If one can develop a well-focused book I would be more than willing to
>donate some money to help the author self-publish.
>
>-Original Message-
>From: Hal Helms [mailto:[EMAIL PROTECTED]
>Sent: Friday, September 12, 2003 5:11 PM
>To: CF-Talk
>Subject: RE: CF MX *right* book.
>
>
>Thanks for the kind words. I agree with you about having small,
>well-focused books but the big publishers (and a depressingly large
>number of developers) seem to judge books on a dollar per pound basis.
>That causes authors to HAVE to fluff up the books to hit a minimum
>contractual page count.
>
>Hal Helms
>See halhelms.com for classes in...
>Java for ColdFusion Programmers
>Fusebox 4
>Mach-II
>OO Applications with CFCs
>
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Re: No so good news

2003-09-12 Thread David Keevil
> What would happen if the sky were pink?
> 
> What if aliens landed?
> 
> What if I put my pants on backwards?

Sounds like you've already started with the Tequilla, Brian...   ;-)
Don't forget the beer chaser over at Swan's...

Happy Friday!

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


COM problem in CFMX 6.1

2003-09-12 Thread Marlon Moyer
I have a COM object that has a method that has an optional "variant" 
type argument.  When I try to call this method like so:

obj.Export(false);

CF throws an error saying that it cannot find a method under that name, 
or the arguments supplied don't match the method.  If I cfdump the 
object, I can see this:


Export([in,optional]VARIANT, [out, retval]VOID)


Any ideas on what to do?  I have tried the javacast function, but 
there's not really a variant type

Marlon



~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


Re:Odd ReReplace issue

2003-09-12 Thread Scott Weikert
At 05:11 PM 9/12/2003 -0400, you wrote:
>Static or not, are they ".cfm" or ".html/.htm" pages?
>
>If the former, can use CF operators

.html. What I do is read in values out of the URL, and then go fetch the 
appropriate HTML file, using , and then monkey with the content and 
just output the one string to the browser.

I basically have every link going to an index.cfm file (using fusebox), so 
I have a core set of functions that I run on the HTML file's content each 
time a page gets called, before tossing it out to the user's browser. That 
ReReplace was just one of'em. 

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Re: CF MX *right* book.

2003-09-12 Thread Jim Campbell
Heh, I have an excellent example of that - "Inside XML" from New 
Riders.  The thing is nearly the size of the OED, and is hilariously 
padded.  For instance, there's an entire section of the book devoted to 
programming Javascript - and not just parsing XML, either, I mean like 
"This is a function; this is how you instantiate variables".  The same 
for Java.  Not just XML parsing, but an introduction to the language.  
All the examples are printed over and over again - completely, with new 
lines added for each step in the example.  If the author was paid by the 
word, he's likely bought an island fortress by this point.

That said, it's a very comprehensive book, and I learned a lot about 
writing schemas and using fun stuff like XPath (which doesn't work right 
in MX - rr).  It is, however, freakishly huge, and really puts off 
an aura of geeky competence when someone sees it on your bookshelf.  
"Ooooh, that's a LOT of XML - you must be an expert!"

- Jim

Hal Helms wrote:

>Thanks for the kind words. I agree with you about having small,
>well-focused books but the big publishers (and a depressingly large
>number of developers) seem to judge books on a dollar per pound basis.
>That causes authors to HAVE to fluff up the books to hit a minimum
>contractual page count. 
>
>Hal Helms
>See halhelms.com for classes in...
>Java for ColdFusion Programmers
>Fusebox 4
>Mach-II
>OO Applications with CFCs
>
>-Original Message-
>From: Kevin Graeme [mailto:[EMAIL PROTECTED] 
>Sent: Friday, September 12, 2003 3:28 PM
>To: CF-Talk
>Subject: Re: CF MX *right* book.
>
>
>Buy them all, you know you want to.
>
>Really though, we bought several that on the face would cover the same
>material. But when you actually peruse them, they each have different
>strengths. But I agree that many of them cover material that is often
>unneeded.
>
>To the authors:
>I'd love separate, focused books instead of the monster tome. The Hal
>Helms book on CFCs is a great example. It's small but dense with
>information. Now if I could just buy books like that on CF/SQL
>interaction, cfscript, cf design frameworks, blah blah. And I've seen
>authors here complain about not being able to get everything in. I know
>some of them exist, but they seem the exception rather than the norm.
>Other developers I've talked to would love a light and tight set of
>books.
>
>-Kevin
>
>- Original Message - 
>From: "Alexandr Timchur" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Friday, September 12, 2003 10:30 AM
>Subject: CF MX *right* book.
>
>
>  
>
>>Hi All,
>>
>>Can you recommend me a right book discovering new features of 
>>ColdFusion MX, especially CFC, without long speech about SQL & 
>>Coldfusion basics?
>>
>>
>>Thank you!
>>Alex Timchur
>>
>>
>>
>>
>>
>
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


RE: No so good news

2003-09-12 Thread Stacy Young
Since it's Friday here's a REAL conspiracy theory...

M$ is actually indirectly behind the lawsuit...timing it to explode
about the same time they plan on launching their own rich client
solution which operates outside the browser domain. (Hence the last
version of IE)

The cost of the lawsuit is probably less than other venues to meet the
same end considering the drastic effect this patent issuee will have on
M$ competitors. (MM,Adobe etc..)

Muahahahah! LoL

Stace

-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED] 
Sent: September 12, 2003 5:02 PM
To: CF-Talk
Subject: RE: No so good news

Stacy wrote:
>I'm curious to know how it would affect Netscape and others...

It'll affect them the same way, exactly.  The patent covers the
automatic launching of an external program (in current parlance, an
applet or a plugin); which everyone does.

http://www.eolas.com/technology.html

Everybody but the patent holder loses big...

Except maybe Microsoft or a 3rd party as yet unknown.  The courts turn a
98% installed base of Flash plugins into 0% by making them illegal until
Something Happens to fix the problem.  Thats a window of opportunity for
a competing solution; maybe big, maybe small (real small, I hope).

--
---
 Matt Robertson, [EMAIL PROTECTED]
 MSB Designs, Inc. http://mysecretbase.com
---

--

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


Re:Odd ReReplace issue

2003-09-12 Thread lee
Static or not, are they ".cfm" or ".html/.htm" pages?

If the former, can use CF operators

>At 04:33 PM 9/12/2003 -0400, you wrote:
>>Just out of curiousity, why don't you just suppress the form with CFIF? 
>>Seems to be much more efficient.
>>
>>Since you somehow "know" a subscriber - let's say the 
>>session.subscriber_id is set and is not NULL:
>>
>>
>>(insert form)
>>
>
>I used to, but then we switched to generating static HTML pages and doing 
>little replaces on the contents before displaying, instead of our old way 
>which was doing a ton of DB queries and building the page on-the-fly. Since 
>I'm reading in my content from a static file, I can't just surround that 
>with a  statement.
>
>What's really odd, now that I think about it, though... other note I 
>mentioned figuring out a way around my problem - break the file into two 
>bits, do the replace on one part, and put'em back together - works fine. 
>But I also do other replaces on these pages, every time - some IDs that I 
>pass in the URLs that *have* to be dynamic - so I generate my static pages 
>with some unique strings in place of these values, like "[[SubID]]", then 
>replace that string with the value passed along with the previous page. But 
>now that I ponder that, I'm just doing Replace() and not ReReplace()... 
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


RE: CF MX *right* book.

2003-09-12 Thread Bryan F. Hogan
If one can develop a well-focused book I would be more than willing to
donate some money to help the author self-publish.

-Original Message-
From: Hal Helms [mailto:[EMAIL PROTECTED]
Sent: Friday, September 12, 2003 5:11 PM
To: CF-Talk
Subject: RE: CF MX *right* book.


Thanks for the kind words. I agree with you about having small,
well-focused books but the big publishers (and a depressingly large
number of developers) seem to judge books on a dollar per pound basis.
That causes authors to HAVE to fluff up the books to hit a minimum
contractual page count.

Hal Helms
See halhelms.com for classes in...
Java for ColdFusion Programmers
Fusebox 4
Mach-II
OO Applications with CFCs

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


RE: CF MX *right* book.

2003-09-12 Thread Hal Helms
Thanks for the kind words. I agree with you about having small,
well-focused books but the big publishers (and a depressingly large
number of developers) seem to judge books on a dollar per pound basis.
That causes authors to HAVE to fluff up the books to hit a minimum
contractual page count. 

Hal Helms
See halhelms.com for classes in...
Java for ColdFusion Programmers
Fusebox 4
Mach-II
OO Applications with CFCs

-Original Message-
From: Kevin Graeme [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 12, 2003 3:28 PM
To: CF-Talk
Subject: Re: CF MX *right* book.


Buy them all, you know you want to.

Really though, we bought several that on the face would cover the same
material. But when you actually peruse them, they each have different
strengths. But I agree that many of them cover material that is often
unneeded.

To the authors:
I'd love separate, focused books instead of the monster tome. The Hal
Helms book on CFCs is a great example. It's small but dense with
information. Now if I could just buy books like that on CF/SQL
interaction, cfscript, cf design frameworks, blah blah. And I've seen
authors here complain about not being able to get everything in. I know
some of them exist, but they seem the exception rather than the norm.
Other developers I've talked to would love a light and tight set of
books.

-Kevin

- Original Message - 
From: "Alexandr Timchur" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, September 12, 2003 10:30 AM
Subject: CF MX *right* book.


> Hi All,
>
> Can you recommend me a right book discovering new features of 
> ColdFusion MX, especially CFC, without long speech about SQL & 
> Coldfusion basics?
>
>
> Thank you!
> Alex Timchur
>
>
> 

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


RE: No so good news

2003-09-12 Thread Matt Robertson
Stacy wrote:
>I'm curious to know how it would affect Netscape and others...

It'll affect them the same way, exactly.  The patent covers the automatic launching of 
an external program (in current parlance, an applet or a plugin); which everyone does.

http://www.eolas.com/technology.html

Everybody but the patent holder loses big...

Except maybe Microsoft or a 3rd party as yet unknown.  The courts turn a 98% installed 
base of Flash plugins into 0% by making them illegal until Something Happens to fix 
the problem.  Thats a window of opportunity for a competing solution; maybe big, maybe 
small (real small, I hope).

--
---
 Matt Robertson, [EMAIL PROTECTED]
 MSB Designs, Inc. http://mysecretbase.com
---

--
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


Re:Odd ReReplace issue

2003-09-12 Thread Scott Weikert
At 04:33 PM 9/12/2003 -0400, you wrote:
>Just out of curiousity, why don't you just suppress the form with CFIF? 
>Seems to be much more efficient.
>
>Since you somehow "know" a subscriber - let's say the 
>session.subscriber_id is set and is not NULL:
>
>
>(insert form)
>

I used to, but then we switched to generating static HTML pages and doing 
little replaces on the contents before displaying, instead of our old way 
which was doing a ton of DB queries and building the page on-the-fly. Since 
I'm reading in my content from a static file, I can't just surround that 
with a  statement.

What's really odd, now that I think about it, though... other note I 
mentioned figuring out a way around my problem - break the file into two 
bits, do the replace on one part, and put'em back together - works fine. 
But I also do other replaces on these pages, every time - some IDs that I 
pass in the URLs that *have* to be dynamic - so I generate my static pages 
with some unique strings in place of these values, like "[[SubID]]", then 
replace that string with the value passed along with the previous page. But 
now that I ponder that, I'm just doing Replace() and not ReReplace()... 

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


Re: No so good news

2003-09-12 Thread Rafael Bleiweiss
no way...

It's about how you call the stuff.  Change how you call it and you can 
still show it in a web browser.

At 04:42 PM 9/12/2003, you wrote:
>
>Well if you were MS and you wanted to kill Flash, losing this case just
>might be a good way to do it. Granted, they may have underestimated the
>damages but I don't think they would mind seeing Flash go away.
>
>
>--David K
>
>- Original Message -
>From: "Jeremy" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Friday, September 12, 2003 12:06 PM
>Subject: No so good news
>
>
> > Off topic but it is Friday after all.
> >
> > Bad News :(
> >
> > http://news.com.com/2104-1032_3-5074799.html
> >
> > http://www.zeldman.com
> >
> >
> >
> >
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Re: No so good news

2003-09-12 Thread Jim Campbell
MS has no real competitor to Flash.  ASP.NET pages are probably in the 
same general orbit, with their kinda-not-really "active" feel, but Flash 
is unique.  Now, taking into account .NET framework internet 
applications - that's probably what MS would call the closest competitor 
to Flash, but that's still a ways off (from how I understand how they'd 
work) from major adoption, if at all.

- Jim

David Keevil wrote:

>
>Well if you were MS and you wanted to kill Flash, losing this case just
>might be a good way to do it. Granted, they may have underestimated the
>damages but I don't think they would mind seeing Flash go away.
>
>
>--David K
>
>- Original Message - 
>From: "Jeremy" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Friday, September 12, 2003 12:06 PM
>Subject: No so good news
>
>
>  
>
>>Off topic but it is Friday after all.
>>
>>Bad News :(
>>
>>http://news.com.com/2104-1032_3-5074799.html
>>
>>http://www.zeldman.com
>>
>>
>>
>>
>>
>>
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Re: No so good news

2003-09-12 Thread Bryan Stevenson
Let's play the speculation game

What would happen if the sky were pink?

What if aliens landed?

What if I put my pants on backwards?

What if What if What if What if

We can all stress now or stress if something actually comes of thisIMHO
there ain't no point in worrying until there's something to worry about ;-)

Happy Friday...tonight is Tequilla night Yee Haw!!

Cheers

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
- Original Message -
From: "David Keevil" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, September 12, 2003 1:42 PM
Subject: Re: No so good news


> 
> Well if you were MS and you wanted to kill Flash, losing this case just
> might be a good way to do it. Granted, they may have underestimated the
> damages but I don't think they would mind seeing Flash go away.
> 
>
> --David K
>
> - Original Message -
> From: "Jeremy" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, September 12, 2003 12:06 PM
> Subject: No so good news
>
>
> > Off topic but it is Friday after all.
> >
> > Bad News :(
> >
> > http://news.com.com/2104-1032_3-5074799.html
> >
> > http://www.zeldman.com
> >
> >
> >
> >
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


Re: No so good news

2003-09-12 Thread David Keevil

Well if you were MS and you wanted to kill Flash, losing this case just
might be a good way to do it. Granted, they may have underestimated the
damages but I don't think they would mind seeing Flash go away.


--David K

- Original Message - 
From: "Jeremy" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, September 12, 2003 12:06 PM
Subject: No so good news


> Off topic but it is Friday after all.
>
> Bad News :(
>
> http://news.com.com/2104-1032_3-5074799.html
>
> http://www.zeldman.com
>
>
>
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


RE: No so good news

2003-09-12 Thread Dave Carabetta
>I have some faith in M$'s ability to appeal things into oblivion. The
>Net needs to be free to work, and that applies to IE as well. This
>patent does seem overly broad in that other technologies use
>sub-programs, why should browsers be so special?
>
>What I wonder about is the impact on CF. What changes would CFMX have to
>make in order to avoid infringement? Would we have to click a button in
>order to get file dialogs to pop up, or what?
>

Well, this particular patent only applies to ActiveX plugins to the browser, 
such as Flash, Excel, and QuickTime, to name a few. Since CF is simply HTML 
when all is said and done, this case doesn't effect CF in any way other than 
potentially the cfchart tag (if rendering flash images) and flash interfaces 
(i.e., flash remoting).

Regards,
Dave.

_
Try MSN Messenger 6.0 with integrated webcam functionality! 
http://www.msnmessenger-download.com/tracking/reach_webcam

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


Re: Nested Function Order Bug?

2003-09-12 Thread Dave Carabetta
>I know it is not clear in the docs, but my understanding of 
>preserveSingleQuotes function is that it cannot be used outside a tag, or for the least, it will be inoperant outside.
>
>The role of the preserveSingleQuotes function is only to set a flag 
>somewhere to prevent single quotes escaping when outputing the content of a 
>variable inside a 
>The docs also make it clear, although it do not explain why, that the 
>"function" only accept a variable.
>
>Then calling the function on a variable outside a nothing,
>calling it on something else than a variable apparently even causes an 
>error.
>

My code snippet came from the context of a cfquery. I was receiving the 
error when the expression was inside of a cfqueryparam tag. When I switched 
the order of the functions, the error went away. So I extracted the 
expression from the query and made it a simple cfset/cfoutput to isolate the 
bug/quirk.

Also, I'm not sure it's *only* for use inside the cfquery tag, though I'll 
admit it doesn't have a whole lot of utility for the most part when not 
dealing with queries. The only tag I know of that's *only* for use inside of 
cfquery (in so far as an error message is actually thrown) is the 
cfqueryparam tag.

Thanks to everybody for testing it out. Scott, I actually agree with your 
assessment of it being more of a quirk than a bug. I didn't realize until 
you pointed it out that PreserveSingleQuotes() can only take a variable and 
not a string literal as its argument. That being the case, it would make 
sense that I received the error because the LCase() function will run first, 
resulting in a string literal being passed to the PreserveSingleQuotes() 
function, as you surmised, hence the error.

Regards,
Dave.

_
Get 10MB of e-mail storage! Sign up for Hotmail Extra Storage.  
http://join.msn.com/?PAGE=features/es

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


Re:Odd ReReplace issue

2003-09-12 Thread lee
Just out of curiousity, why don't you just suppress the form with CFIF? Seems to be 
much more efficient.

Since you somehow "know" a subscriber - let's say the session.subscriber_id is set and 
is not NULL:


(insert form)


Hmm? Seems better than doing a replace on a big file.


>At 03:13 PM 9/12/2003 -0400, you wrote:
>>Wait -- what breaks?  The quiz or the rereplace?
>
>The ReReplace breaks. It only breaks on this one page that has this quiz 
>form code on it. Other pages that are built off the same base work peachy. 
>It's really freaking bizarre.
>
>What I'm doing is reading in previously-generated static HTML pages, 
>fiddling with the content, and outputting fiddled content to the browser 
>(not re-saving the HTML pages themselves). And for some reason on this one 
>page, a ReReplace to replace a chunk of code in one spot in the HTML code 
>read in *breaks* because of code *farther down* in said HTML code - code 
>that has zip to do with the bit I'm trying to replace.
>
>I've been monkeying with a test script - I'll read in this particular HTML 
>page, and then cut it off with a Left() at a certain point, and try the 
>ReReplace. It works fine up to a point, as I'm incrementing my cutoff point 
>up, and then it will break - and the code between the last cutoff point and 
>the current cutoff point looks completely irrelevant. I can't see *any* 
>reason why the presence of that code - in a big honkin' string - would 
>cause the problem.
>
>Unless, of course, it's the length of the big honkin' string (the HTML code 
>read in from the file). Would CF hiccup on doing a ReReplace on a string 
>that's over 16k or so? I wouldn't think that would tax CF in the least, but 
>who knows...
>
>--Scott 
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


RE: Odd ReReplace issue

2003-09-12 Thread Scott Weikert
>Unless, of course, it's the length of the big honkin' string (the HTML code
>read in from the file). Would CF hiccup on doing a ReReplace on a string
>that's over 16k or so? I wouldn't think that would tax CF in the least, but
>who knows...

Well, I answered my own question there. It *was* the length of the string 
in question. I added in some code to find the end of the bit I wanted to do 
a ReReplace on - went 100 chars past - and split the big string into two 
parts at that cutoff point - did the ReReplace on the front part (which is 
now significantly smaller) - and then put the two parts back together and 
kept on going. Worked like a champ.

VERY bizarre.

--Scott 

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


RE: Odd ReReplace issue

2003-09-12 Thread Ben Doom
ReReplace() pukes it up at about 22k (in my experience).  Basically, it
doesn't return an error, it just stops working.  This is in CF5, right?  If
so, I'd guess your problem is length.  I've run into this before.

If you want help figuring out how to deal with this, I'd be happy to tell
you what options I figured out.

HTH.


--  Ben Doom
Programmer & General Lackey
Moonbow Software, Inc

: -Original Message-
: From: Scott Weikert [mailto:[EMAIL PROTECTED]
: Sent: Friday, September 12, 2003 4:23 PM
: To: CF-Talk
: Subject: RE: Odd ReReplace issue
:
:
: At 03:13 PM 9/12/2003 -0400, you wrote:
: >Wait -- what breaks?  The quiz or the rereplace?
:
: The ReReplace breaks. It only breaks on this one page that has this quiz
: form code on it. Other pages that are built off the same base
: work peachy.
: It's really freaking bizarre.
:
: What I'm doing is reading in previously-generated static HTML pages,
: fiddling with the content, and outputting fiddled content to the browser
: (not re-saving the HTML pages themselves). And for some reason on
: this one
: page, a ReReplace to replace a chunk of code in one spot in the HTML code
: read in *breaks* because of code *farther down* in said HTML code - code
: that has zip to do with the bit I'm trying to replace.
:
: I've been monkeying with a test script - I'll read in this
: particular HTML
: page, and then cut it off with a Left() at a certain point, and try the
: ReReplace. It works fine up to a point, as I'm incrementing my
: cutoff point
: up, and then it will break - and the code between the last cutoff
: point and
: the current cutoff point looks completely irrelevant. I can't see *any*
: reason why the presence of that code - in a big honkin' string - would
: cause the problem.
:
: Unless, of course, it's the length of the big honkin' string (the
: HTML code
: read in from the file). Would CF hiccup on doing a ReReplace on a string
: that's over 16k or so? I wouldn't think that would tax CF in the
: least, but
: who knows...
:
: --Scott
:
: 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Re: Nested Function Order Bug?

2003-09-12 Thread Claude Schneegans
I know it is not clear in the docs, but my understanding of preserveSingleQuotes 
function is that it cannot be used outside a http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


RE: Odd ReReplace issue

2003-09-12 Thread Scott Weikert
At 03:13 PM 9/12/2003 -0400, you wrote:
>Wait -- what breaks?  The quiz or the rereplace?

The ReReplace breaks. It only breaks on this one page that has this quiz 
form code on it. Other pages that are built off the same base work peachy. 
It's really freaking bizarre.

What I'm doing is reading in previously-generated static HTML pages, 
fiddling with the content, and outputting fiddled content to the browser 
(not re-saving the HTML pages themselves). And for some reason on this one 
page, a ReReplace to replace a chunk of code in one spot in the HTML code 
read in *breaks* because of code *farther down* in said HTML code - code 
that has zip to do with the bit I'm trying to replace.

I've been monkeying with a test script - I'll read in this particular HTML 
page, and then cut it off with a Left() at a certain point, and try the 
ReReplace. It works fine up to a point, as I'm incrementing my cutoff point 
up, and then it will break - and the code between the last cutoff point and 
the current cutoff point looks completely irrelevant. I can't see *any* 
reason why the presence of that code - in a big honkin' string - would 
cause the problem.

Unless, of course, it's the length of the big honkin' string (the HTML code 
read in from the file). Would CF hiccup on doing a ReReplace on a string 
that's over 16k or so? I wouldn't think that would tax CF in the least, but 
who knows...

--Scott 

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Dreamweaver upgrade pricing ( was somthing else )

2003-09-12 Thread Guy Walker
Yes, that is what the problem was. I was looking at Studio MX 2004.

Both products look like a good value to me

Thanks for straightening me out.

Guy


> Your link didn't work for me, but I think you're looking at Studio MX 2004
and not DWMX 2004.  (Since the full price of DWMX 2004 is only $399, I'd be
very surprised if the upgrade price is $499. :)
>
> Scott
>
> ---
> Scott Brady
> http://www.scottbrady.net/


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


RE: No so good news

2003-09-12 Thread Stacy Young
I believe it only relates to the mechanism used to launch external
applications. (i.e. plugins like flash, applet, quicktime etc)

Since CF renders pages in HTML...and is nowhere near the client browser
it's all good.

The Flash part sucks though...but I'm curious to know how it would
affect Netscape and others...

Stace

-Original Message-
From: Haggerty, Mike [mailto:[EMAIL PROTECTED] 
Sent: September 12, 2003 3:48 PM
To: CF-Talk
Subject: RE: No so good news

I have some faith in M$'s ability to appeal things into oblivion. The
Net needs to be free to work, and that applies to IE as well. This
patent does seem overly broad in that other technologies use
sub-programs, why should browsers be so special?

What I wonder about is the impact on CF. What changes would CFMX have to
make in order to avoid infringement? Would we have to click a button in
order to get file dialogs to pop up, or what?

M

> -Original Message-
> From: jon hall [mailto:[EMAIL PROTECTED] 
> Sent: Friday, September 12, 2003 3:43 PM
> To: CF-Talk
> Subject: Re: No so good news
> 
> 
> This is the first time they have made public the workarounds 
> they are discussing. That's what is new.
> 
> Since they have already lost in court, and the judge has not 
> ruled on a punishment yet, he could potentially order 
> Microsoft to stop shipping all versions of IE that infringe 
> on the patent within a month or so from now. If it's any 
> longer than that, it wont be by much. Of course, the judge 
> could do that, and then suspend his decision pending the 
> appeals court decision as well.
> 
> Bottom line is, Microsoft will have to change IE unless Eolas 
> licenses their patent (not likely) to MS. We will have to 
> change a bunch of web sites if the judge does not stay his 
> ruling pending the appeal. At this point, it's all in the 
> judges hands. Microsoft really can't delay much at this 
> point...they already delayed this one for years.
> 
> -- 
>  jon
>  mailto:[EMAIL PROTECTED]
> 
> Friday, September 12, 2003, 3:20:24 PM, you wrote:
> BS> Old news now...and it ain't over till the fat lady sings ;-)
> 
> BS> Just think about the GIF format case...of that guy in the UK 
> BS> claiming the patent on links...where are they now ;-)
> 
> BS> I'm waiting until there is something "official"...and if 
> MS has it's 
> BS> way as usual...that could take years
> 
> 

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


re: Nested Function Order Bug?

2003-09-12 Thread Scott Brady
Original Message:
> From: "Dave Carabetta" <[EMAIL PROTECTED]>

> Basically, the order in which I nest the LCase() and PreserveSingleQuotes() 
> function seems to matter. In scenario 1, with the LCase() as the outer 
> function, all's well. But if I switch the nesting such that the 
> PreserveSingleQuotes() function is the outer funtion, I get the ColdFusion 
> error message displayed after the test cases.

> Test Case 1 (Successful):
> 
> #lCase(preserveSingleQuotes(Variables.textString))#
> 
> Test Case 2 (Fails):
> 
> #preserveSingleQuotes(lCase(Variables.textString))#
> 
> Test Case 2 results in this error (ignore the line number, as my test 
> template has a little more in :
> Invalid CFML construct found on line 2 at column 38.
> ColdFusion was looking at the following text:
> (

I don't know if it's a bug, as much as a "quirk".  The docs for PreserveSingleQuotes() 
say that it takes a "variable" as an argument.

Because lcase() returns a string, you're not technically passing it a variable 
anymore. You're passing an actual string. 

While I don't think it's actually a "bug" (like I said), it seems like it SHOULD allow 
you to pass any string to PreserveSingleQuotes(), whether it's a variable or an actual 
string.

Scott


---
Scott Brady
http://www.scottbrady.net/


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


Re: No so good news

2003-09-12 Thread Jim Campbell
That's what you think.  After being found guilty of anticompetitive 
practices by the federal government, they paid billions in restitution 
and were broken up into three... I mean... oh, wait, nevermind.

- Jim

Bryan Stevenson wrote:

>MS has moneywhich = power...they can and will delay/sidestep/bribe ;-)
>
>Bryan Stevenson B.Comm.
>VP & Director of E-Commerce Development
>Electric Edge Systems Group Inc.
>t. 250.920.8830
>e. [EMAIL PROTECTED]
>
>-
>Macromedia Associate Partner
>www.macromedia.com
>-
>Vancouver Island ColdFusion Users Group
>Founder & Director
>www.cfug-vancouverisland.com
>- Original Message -
>From: "jon hall" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Friday, September 12, 2003 12:43 PM
>Subject: Re: No so good news
>
>
>  
>
>>This is the first time they have made public the workarounds they are
>>discussing. That's what is new.
>>
>>Since they have already lost in court, and the judge has not ruled on
>>a punishment yet, he could potentially order Microsoft to stop
>>shipping all versions of IE that infringe on the patent within a month
>>or so from now. If it's any longer than that, it wont be by much. Of
>>course, the judge could do that, and then suspend his decision pending
>>the appeals court decision as well.
>>
>>Bottom line is, Microsoft will have to change IE unless Eolas licenses
>>their patent (not likely) to MS. We will have to change a bunch of
>>web sites if the judge does not stay his ruling pending the appeal. At
>>this point, it's all in the judges hands. Microsoft really can't
>>delay much at this point...they already delayed this one for years.
>>
>>--
>> jon
>> mailto:[EMAIL PROTECTED]
>>
>>Friday, September 12, 2003, 3:20:24 PM, you wrote:
>>BS> Old news now...and it ain't over till the fat lady sings ;-)
>>
>>BS> Just think about the GIF format case...of that guy in the UK claiming
>>
>>
>the
>  
>
>>BS> patent on links...where are they now ;-)
>>
>>BS> I'm waiting until there is something "official"...and if MS has it's
>>
>>
>way as
>  
>
>>BS> usual...that could take years
>>
>>
>>
>>
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


Flash Remoting? wasRE: RE: No so good news

2003-09-12 Thread Mike Brunt
It looks like the potential impact is more related to plug-in's so Flash more than CF 
would be impacted.  I wonder whether this could make Flash Remoting of greater 
relevance, any thoughts or opinions on that?

Kind Regards - Mike Brunt

Original Message ---
I have some faith in M$'s ability to appeal things into oblivion. The
Net needs to be free to work, and that applies to IE as well. This
patent does seem overly broad in that other technologies use
sub-programs, why should browsers be so special?

What I wonder about is the impact on CF. What changes would CFMX have to
make in order to avoid infringement? Would we have to click a button in
order to get file dialogs to pop up, or what?

M

> -Original Message-
> From: jon hall [mailto:[EMAIL PROTECTED] 
> Sent: Friday, September 12, 2003 3:43 PM
> To: CF-Talk
> Subject: Re: No so good news
> 
> 
> This is the first time they have made public the workarounds 
> they are discussing. That's what is new.
> 
> Since they have already lost in court, and the judge has not 
> ruled on a punishment yet, he could potentially order 
> Microsoft to stop shipping all versions of IE that infringe 
> on the patent within a month or so from now. If it's any 
> longer than that, it wont be by much. Of course, the judge 
> could do that, and then suspend his decision pending the 
> appeals court decision as well.
> 
> Bottom line is, Microsoft will have to change IE unless Eolas 
> licenses their patent (not likely) to MS. We will have to 
> change a bunch of web sites if the judge does not stay his 
> ruling pending the appeal. At this point, it's all in the 
> judges hands. Microsoft really can't delay much at this 
> point...they already delayed this one for years.
> 
> -- 
>  jon
>  mailto:[EMAIL PROTECTED]
> 
> Friday, September 12, 2003, 3:20:24 PM, you wrote:
> BS> Old news now...and it ain't over till the fat lady sings ;-)
> 
> BS> Just think about the GIF format case...of that guy in the UK 
> BS> claiming the patent on links...where are they now ;-)
> 
> BS> I'm waiting until there is something "official"...and if 
> MS has it's 
> BS> way as usual...that could take years
> 
> 

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


WAS: Count and Strip Words from String

2003-09-12 Thread lee
Sorry all - something got weird in by browser or this forum and it posted to a new 
thread, instead of adding.

>I can't figure this post out either (what the original post was, what
>the ambiguous subject means...), but is someone looking for something
>that makes SQL out of search terms? I've got a copy of a custom tag
>(called boolsearch) that understands quoted phrases, NOTs, ANDs, ORs,
>etc., and makes a SQL filter out of it. AFAIK, this custom tag is
>generally unavailable, since I went looking for updates recently.
>
>LMK if that's what you (or someone) needs.
>
>Jamie
>
>On Fri, 12 Sep 2003 14:45:54 -0400, in cf-talk you wrote:
>
>>thanks lee...looks like a good ideai couldn't figure out what this
>>post was about...but now I see :)
>>
>>tony weeg
>>sr. web applications architect
>>navtrak, inc.
>>[EMAIL PROTECTED]
>>www.navtrak.net
>>office 410.548.2337
>>fax 410.860.2337
>>
>>
>>-Original Message-
>>From: [EMAIL PROTECTED] [EMAIL PROTECTED]
>>[mailto:[EMAIL PROTECTED] 
>>Sent: Friday, September 12, 2003 2:22 PM
>>To: CF-Talk
>>Subject: Another way
>>
>>
>>Treat the phrase/list of keywords coming in as a list: 
>>
>> 
>> 
>> 
>> 
>>>"ALL")#> 
>>
>> 
>> 
>>  AND columnName LIKE '%#listGetAt(searchPhrase,counter)#%' 
>> 
>>
>>This code will produce the following code: 
>>
>>AND columnName LIKE '%help%' 
>>AND columnName LIKE '%me%' 
>>AND columnName LIKE '%now%' 
>>
>>Use the listLen function to get number of keywords if you still need
>>that. 
>>
>>Obviously, adjust the code for "OR" instead of "AND" etc, but you get
>>the idea.
>>
>>
>>>lets say, a user enters "skateboarding atlanta half-pipe"
>>>and you wanted to break that up into separate words, and know that 
>>>there should be 3 "...or searchTerm like '%wordHere%'" sections in a 
>>>query  (one for each word) so that the user can search for 
>>>"skateboarding or atlanta or
>>>half-pipe" through a sql statement.
>>>
>>>is this feasible, i know it has to be, just cant think past my keyboard
>>
>>>right now.
>>>
>>>thanks for any ideas
>>>
>>>tony
>>>
>>>tony weeg
>>>[EMAIL PROTECTED]
>>>www.revolutionwebdesign.com
>>>rEvOlUtIoN wEb DeSiGn
>>>410.334.6331
>>>
>>
>>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


Re: No so good news (is: Eolas patent) [OT]

2003-09-12 Thread John Dowdell
At 12:06 PM 9/12/3, Jeremy wrote:
> Off topic but it is Friday after all.
> Bad News :(
> http://news.com.com/2104-1032_3-5074799.html
> http://www.zeldman.com

Hold horses until Microsoft and W3C actually say something... there are
some questions about the Festa article.

More in my blog.



Jon Hall wrote:
> This is the first time they have made public the workarounds
> they are discussing.

I'm not sure of that myself... see:
http://lists.w3.org/Archives/Public/public-web-plugins/2003Sep/0124.html

jd




John Dowdell, Macromedia Developer Support, San Francisco
(Best to reply on-list, to avoid my mighty spam filters!)
Technotes: http://www.macromedia.com/support/search/
Column: http://www.macromedia.com/desdev/jd_forum/
Technical daily diary: http://www.macromedia.com/go/blog_jd


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


Re: No so good news

2003-09-12 Thread Bryan Stevenson
MS has moneywhich = power...they can and will delay/sidestep/bribe ;-)

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
- Original Message -
From: "jon hall" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, September 12, 2003 12:43 PM
Subject: Re: No so good news


> This is the first time they have made public the workarounds they are
> discussing. That's what is new.
>
> Since they have already lost in court, and the judge has not ruled on
> a punishment yet, he could potentially order Microsoft to stop
> shipping all versions of IE that infringe on the patent within a month
> or so from now. If it's any longer than that, it wont be by much. Of
> course, the judge could do that, and then suspend his decision pending
> the appeals court decision as well.
>
> Bottom line is, Microsoft will have to change IE unless Eolas licenses
> their patent (not likely) to MS. We will have to change a bunch of
> web sites if the judge does not stay his ruling pending the appeal. At
> this point, it's all in the judges hands. Microsoft really can't
> delay much at this point...they already delayed this one for years.
>
> --
>  jon
>  mailto:[EMAIL PROTECTED]
>
> Friday, September 12, 2003, 3:20:24 PM, you wrote:
> BS> Old news now...and it ain't over till the fat lady sings ;-)
>
> BS> Just think about the GIF format case...of that guy in the UK claiming
the
> BS> patent on links...where are they now ;-)
>
> BS> I'm waiting until there is something "official"...and if MS has it's
way as
> BS> usual...that could take years
>
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Re: Nested Function Order Bug?

2003-09-12 Thread Patricia G. L. Hall
> Test Case 1 (Successful):
> 
> #lCase(preserveSingleQuotes(Variables.textString))#
>
> Test Case 2 (Fails):
> 
> #preserveSingleQuotes(lCase(Variables.textString))#

> Invalid CFML construct found on line 2 at column 38.
> ColdFusion was looking at the following text:
> (

Same here.

>
> This happens using MX for J2EE for JRun, both versions 6 (with Updater 3)
> and 6.1, on Solaris and Linux.

CF 5 on Windows

CF 6.1 for J2EE on Windows

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Re: Another way

2003-09-12 Thread Jamie Jackson
I can't figure this post out either (what the original post was, what
the ambiguous subject means...), but is someone looking for something
that makes SQL out of search terms? I've got a copy of a custom tag
(called boolsearch) that understands quoted phrases, NOTs, ANDs, ORs,
etc., and makes a SQL filter out of it. AFAIK, this custom tag is
generally unavailable, since I went looking for updates recently.

LMK if that's what you (or someone) needs.

Jamie

On Fri, 12 Sep 2003 14:45:54 -0400, in cf-talk you wrote:

>thanks lee...looks like a good ideai couldn't figure out what this
>post was about...but now I see :)
>
>tony weeg
>sr. web applications architect
>navtrak, inc.
>[EMAIL PROTECTED]
>www.navtrak.net
>office 410.548.2337
>fax 410.860.2337
>
>
>-Original Message-
>From: [EMAIL PROTECTED] [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED] 
>Sent: Friday, September 12, 2003 2:22 PM
>To: CF-Talk
>Subject: Another way
>
>
>Treat the phrase/list of keywords coming in as a list: 
>
> 
> 
> 
> 
>"ALL")#> 
>
> 
> 
>  AND columnName LIKE '%#listGetAt(searchPhrase,counter)#%' 
> 
>
>This code will produce the following code: 
>
>AND columnName LIKE '%help%' 
>AND columnName LIKE '%me%' 
>AND columnName LIKE '%now%' 
>
>Use the listLen function to get number of keywords if you still need
>that. 
>
>Obviously, adjust the code for "OR" instead of "AND" etc, but you get
>the idea.
>
>
>>lets say, a user enters "skateboarding atlanta half-pipe"
>>and you wanted to break that up into separate words, and know that 
>>there should be 3 "...or searchTerm like '%wordHere%'" sections in a 
>>query  (one for each word) so that the user can search for 
>>"skateboarding or atlanta or
>>half-pipe" through a sql statement.
>>
>>is this feasible, i know it has to be, just cant think past my keyboard
>
>>right now.
>>
>>thanks for any ideas
>>
>>tony
>>
>>tony weeg
>>[EMAIL PROTECTED]
>>www.revolutionwebdesign.com
>>rEvOlUtIoN wEb DeSiGn
>>410.334.6331
>>
>
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


RE: No so good news

2003-09-12 Thread Haggerty, Mike
I have some faith in M$'s ability to appeal things into oblivion. The
Net needs to be free to work, and that applies to IE as well. This
patent does seem overly broad in that other technologies use
sub-programs, why should browsers be so special?

What I wonder about is the impact on CF. What changes would CFMX have to
make in order to avoid infringement? Would we have to click a button in
order to get file dialogs to pop up, or what?

M

> -Original Message-
> From: jon hall [mailto:[EMAIL PROTECTED] 
> Sent: Friday, September 12, 2003 3:43 PM
> To: CF-Talk
> Subject: Re: No so good news
> 
> 
> This is the first time they have made public the workarounds 
> they are discussing. That's what is new.
> 
> Since they have already lost in court, and the judge has not 
> ruled on a punishment yet, he could potentially order 
> Microsoft to stop shipping all versions of IE that infringe 
> on the patent within a month or so from now. If it's any 
> longer than that, it wont be by much. Of course, the judge 
> could do that, and then suspend his decision pending the 
> appeals court decision as well.
> 
> Bottom line is, Microsoft will have to change IE unless Eolas 
> licenses their patent (not likely) to MS. We will have to 
> change a bunch of web sites if the judge does not stay his 
> ruling pending the appeal. At this point, it's all in the 
> judges hands. Microsoft really can't delay much at this 
> point...they already delayed this one for years.
> 
> -- 
>  jon
>  mailto:[EMAIL PROTECTED]
> 
> Friday, September 12, 2003, 3:20:24 PM, you wrote:
> BS> Old news now...and it ain't over till the fat lady sings ;-)
> 
> BS> Just think about the GIF format case...of that guy in the UK 
> BS> claiming the patent on links...where are they now ;-)
> 
> BS> I'm waiting until there is something "official"...and if 
> MS has it's 
> BS> way as usual...that could take years
> 
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


RE: Re: No so good news

2003-09-12 Thread Mike Brunt
Yes, it looks pretty serious to me also.  As one person commented, "it is not very 
often that so many people would like to see Microsoft prevail". 

Kind Regards - Mike Brunt

Original Message ---
This is the first time they have made public the workarounds they are
discussing. That's what is new.

Since they have already lost in court, and the judge has not ruled on
a punishment yet, he could potentially order Microsoft to stop
shipping all versions of IE that infringe on the patent within a month
or so from now. If it's any longer than that, it wont be by much. Of
course, the judge could do that, and then suspend his decision pending
the appeals court decision as well.

Bottom line is, Microsoft will have to change IE unless Eolas licenses
their patent (not likely) to MS. We will have to change a bunch of
web sites if the judge does not stay his ruling pending the appeal. At
this point, it's all in the judges hands. Microsoft really can't
delay much at this point...they already delayed this one for years.

-- 
 jon
 mailto:[EMAIL PROTECTED]

Friday, September 12, 2003, 3:20:24 PM, you wrote:
BS> Old news now...and it ain't over till the fat lady sings ;-)

BS> Just think about the GIF format case...of that guy in the UK claiming the
BS> patent on links...where are they now ;-)

BS> I'm waiting until there is something "official"...and if MS has it's way as
BS> usual...that could take years


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Nested Function Order Bug?

2003-09-12 Thread Dave Carabetta
I've come across a stange sort of bug, and I was wondering if some of you 
could test out this extremely basic bit of code below before I go submitting 
it to the bug tracker.

Basically, the order in which I nest the LCase() and PreserveSingleQuotes() 
function seems to matter. In scenario 1, with the LCase() as the outer 
function, all's well. But if I switch the nesting such that the 
PreserveSingleQuotes() function is the outer funtion, I get the ColdFusion 
error message displayed after the test cases.

Test Case 1 (Successful):

#lCase(preserveSingleQuotes(Variables.textString))#

Test Case 2 (Fails):

#preserveSingleQuotes(lCase(Variables.textString))#

Test Case 2 results in this error (ignore the line number, as my test 
template has a little more in :
Invalid CFML construct found on line 2 at column 38.
ColdFusion was looking at the following text:
(

This happens using MX for J2EE for JRun, both versions 6 (with Updater 3) 
and 6.1, on Solaris and Linux.

1. Is this some sort of expected behavior I'm not thinking of?
2. For those of you who have a Windows installation, does this happen on 
your setup as well?

Regards,
Dave.

_
Get 10MB of e-mail storage! Sign up for Hotmail Extra Storage.  
http://join.msn.com/?PAGE=features/es

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


Re: No so good news

2003-09-12 Thread jon hall
This is the first time they have made public the workarounds they are
discussing. That's what is new.

Since they have already lost in court, and the judge has not ruled on
a punishment yet, he could potentially order Microsoft to stop
shipping all versions of IE that infringe on the patent within a month
or so from now. If it's any longer than that, it wont be by much. Of
course, the judge could do that, and then suspend his decision pending
the appeals court decision as well.

Bottom line is, Microsoft will have to change IE unless Eolas licenses
their patent (not likely) to MS. We will have to change a bunch of
web sites if the judge does not stay his ruling pending the appeal. At
this point, it's all in the judges hands. Microsoft really can't
delay much at this point...they already delayed this one for years.

-- 
 jon
 mailto:[EMAIL PROTECTED]

Friday, September 12, 2003, 3:20:24 PM, you wrote:
BS> Old news now...and it ain't over till the fat lady sings ;-)

BS> Just think about the GIF format case...of that guy in the UK claiming the
BS> patent on links...where are they now ;-)

BS> I'm waiting until there is something "official"...and if MS has it's way as
BS> usual...that could take years

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


Re: How to test for existence of XML element?

2003-09-12 Thread Jamie Jackson
...hoping this ghastly workaround will inspire pity:


  
  

   

  
   
  
  
  


Thanks,
Jamie

On Fri, 12 Sep 2003 12:50:12 -0400, in cf-talk you wrote:

>I'm trying to convert an XML document object to a query, but I'm
>getting stuck when I'm doing my QuerySetCell()s. If the element
>doesn't exist in that node, it bombs. However, I don't know how to
>test for the existence of the element, since isDefined() doesn't work
>on them (e.g. isDefined("MyNotes.Notes.Page[i].XmlAttributes['name']"
>bombs).
>
>Code sample follows.
>
>Thanks,
>Jamie
>
>
>  // set notesAry to array of "page" elements (which are basically
>notes elements).
>  notesAry = MyNotes.Notes.XmlChildren;
>  // number of notes found in the file
>  numOfNotes = ArrayLen(notesAry);
>  // initialize notesQuery, which will contain notes data from xml
>file
>  notesQuery = QueryNew("name, pageName, queryString, timeStamp,
>note");
>  // add as many records to the notesQuery as there are notes in the
>xml file
>  QueryAddRow(notesQuery, #numOfNotes#);
>  
>
>  
>   QuerySetCell(notesQuery, "name", 
>  #MyNotes.Notes.Page[i].XmlAttributes['name']#, #i#);
>   QuerySetCell(notesQuery, "pageName", 
>  #MyNotes.Notes.Page[i].XmlAttributes['pageName']#, #i#);   
>   QuerySetCell(notesQuery, 'queryString', 
>  #MyNotes.Notes.Page[i].XmlAttributes["queryString"]#, #i#); 
>   QuerySetCell(notesQuery, 'time_Stamp', 
>  #MyNotes.Notes.Page[i].XmlAttributes['time_Stamp']#, #i#);
>   QuerySetCell(notesQuery, "note", 
>  #MyNotes.Notes.Page[i].note.XmlText#, #i#);
>
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Re: CF MX *right* book.

2003-09-12 Thread Kevin Graeme
Buy them all, you know you want to.

Really though, we bought several that on the face would cover the same
material. But when you actually peruse them, they each have different
strengths. But I agree that many of them cover material that is often
unneeded.

To the authors:
I'd love separate, focused books instead of the monster tome. The Hal Helms
book on CFCs is a great example. It's small but dense with information. Now
if I could just buy books like that on CF/SQL interaction, cfscript, cf
design frameworks, blah blah. And I've seen authors here complain about not
being able to get everything in. I know some of them exist, but they seem
the exception rather than the norm. Other developers I've talked to would
love a light and tight set of books.

-Kevin

- Original Message - 
From: "Alexandr Timchur" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, September 12, 2003 10:30 AM
Subject: CF MX *right* book.


> Hi All,
>
> Can you recommend me a right book discovering new features of
> ColdFusion MX, especially CFC, without long speech about
> SQL & Coldfusion basics?
>
>
> Thank you!
> Alex Timchur
>
>
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


RE: No so good news

2003-09-12 Thread Ryan Kime
>and if MS has it's way as usual...that could take years

This is the one time where I appreciate Microsoft's ability to drag out
courtroom battles. 


-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 12, 2003 2:20 PM
To: CF-Talk
Subject: Re: No so good news


Old news now...and it ain't over till the fat lady sings ;-)

Just think about the GIF format case...of that guy in the UK claiming the
patent on links...where are they now ;-)

I'm waiting until there is something "official"...and if MS has it's way as
usual...that could take years

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
- Original Message -
From: "Jeremy" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, September 12, 2003 12:06 PM
Subject: No so good news


> Off topic but it is Friday after all.
>
> Bad News :(
>
> http://news.com.com/2104-1032_3-5074799.html
>
> http://www.zeldman.com
>
>
>
> 

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


RE: Any way to get Homesite+ 5.5 without Dreamweaver?

2003-09-12 Thread Dave Watts
> Could you post a URL or point me in the right direction to 
> this upgrade price?
> 
> When I look on MM's site the price I see for an upgrade of CF 
> Studio 5 to Dreamweaver MX 2004 with Homesite+ 5.5 is $499.00.
> 
> This is where I am getting the $499.00 price.

http://www.macromedia.com/go/upgradetodw

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


Re: Any way to get Homesite+ 5.5 without Dreamweaver?

2003-09-12 Thread Scott Brady
Original Message:
> From: "Guy Walker" <[EMAIL PROTECTED]>
> When I look on MM's site the price I see for an upgrade of CF Studio 5 to
> Dreamweaver MX 2004 with Homesite+ 5.5 is $499.00.

Your link didn't work for me, but I think you're looking at Studio MX 2004 and not 
DWMX 2004.  (Since the full price of DWMX 2004 is only $399, I'd be very surprised if 
the upgrade price is $499. :)

Scott

---
Scott Brady
http://www.scottbrady.net/


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


Re: No so good news

2003-09-12 Thread Bryan Stevenson
Old news now...and it ain't over till the fat lady sings ;-)

Just think about the GIF format case...of that guy in the UK claiming the
patent on links...where are they now ;-)

I'm waiting until there is something "official"...and if MS has it's way as
usual...that could take years

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
- Original Message -
From: "Jeremy" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, September 12, 2003 12:06 PM
Subject: No so good news


> Off topic but it is Friday after all.
>
> Bad News :(
>
> http://news.com.com/2104-1032_3-5074799.html
>
> http://www.zeldman.com
>
>
>
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


Re: Anyone know of a decent SQL ide?

2003-09-12 Thread Jim Campbell
I don't know if the Swing API in 1.3/1.4x has mouse-wheel support or if 
it's an external library (or if they use their own windowing toolkit, a 
la Eclipse), but the mouse wheel works great in Aqua Data.

- Jim

Chris wrote:

>Thanks for all of the suggestions.  So far AquaData Studio seems to be the
>favorite.  I had a look at the site and it looks perfect.
>Only thing I'm not gonna like is that it's in Java, and my mouse wheel
>doesn't work in Java apps. ;) 
>
>Thanks!
>Chris
>--
>Original Message
>From: "Jim Campbell"<[EMAIL PROTECTED]>
>Subject: Re: Anyone know of a decent SQL ide?
>Date: Fri, 12 Sep 2003 11:58:37 -0500
>
>  
>
>>This was suggested yesterday, but try out AquaData Studio from 
>>www.aquafold.com
>>
>>- Jim
>>
>>Chris wrote:
>>
>>
>>
>>>Hi everyone,
>>>
>>>I am searching for a good SQL IDE.  I currently use Query Analyzer, but
>>>would really like to find something a bit more robust.  Since most of you
>>>guys also write SQL, I figured this would be the best place to ask.  
>>>
>>>Anyone have any suggestions?
>>>
>>>Thanks in advance,
>>>Chris
>>>
>>>
>>>  
>>>
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


RE: CF MX *right* book.

2003-09-12 Thread Jillian Carroll
I have been very pleased with "Mastering ColdFusion MX' by 'Danesh, Camden,
Bainum and Rish' published by Sybex.

It's a mighty heavy book to lug around... but for a 'keep it nearby complete
reference', it can't be beat.

The examples are clear and simple... and the book is very well edited.

--
Jillian


> - Original Message - 
> From: "Alexandr Timchur" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, September 12, 2003 8:30 AM
> Subject: CF MX *right* book.
> 
> 
> > Hi All,
> >
> > Can you recommend me a right book discovering new features of 
> > ColdFusion MX, especially CFC, without long speech about SQL & 
> > Coldfusion basics?
> >
> >
> > Thank you!
> > Alex Timchur


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


RE: Odd ReReplace issue

2003-09-12 Thread Ben Doom
Wait -- what breaks?  The quiz or the rereplace?


--  Ben Doom
Programmer & General Lackey
Moonbow Software, Inc

: -Original Message-
: From: Scott Weikert [mailto:[EMAIL PROTECTED]
: Sent: Friday, September 12, 2003 2:42 PM
: To: CF-Talk
: Subject: Odd ReReplace issue
:
:
: This one's been stumping me for the past little while.
:
: On my main project, users have the ability to add in a little subscriber
: form. I surround the code for this subscriber form with a pair of HTML
: comments, with the text "StartSubForm" and "EndSubForm" in these
: comments.
: If an existing subscriber is viewing the page, then I don't want
: to display
: the subscriber form - it's redundant - so I sniff out if the two above
: comments are in the code, and do a ReReplace to remove the form:
:
: ", "", "ALL")>
:
: This has worked great until today - one client has, on a page within his
: area, a quiz form. Whenever the above code snippet runs, on this page and
: this page *only*, as far as I can tell, it breaks.
:
: The code the snippet is trying to replace is *identical* on all of said
: client's pages - it's just the one page, with the quiz form (the code for
: which comes along a ways later in the page than the subscriber form I'm
: trying to replace), that hoses up.
:
: Nowhere in the quiz code do those "SubStartForm" or "EndSubForm" strings
: show up, either.
:
: Any thoughts?
: --Scott
:
: 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Re:Re: Anyone know of a decent SQL ide?

2003-09-12 Thread Chris
Thanks for all of the suggestions.  So far AquaData Studio seems to be the
favorite.  I had a look at the site and it looks perfect.
Only thing I'm not gonna like is that it's in Java, and my mouse wheel
doesn't work in Java apps. ;) 

Thanks!
Chris
--
Original Message
From: "Jim Campbell"<[EMAIL PROTECTED]>
Subject: Re: Anyone know of a decent SQL ide?
Date: Fri, 12 Sep 2003 11:58:37 -0500

>This was suggested yesterday, but try out AquaData Studio from 
>www.aquafold.com
>
>- Jim
>
>Chris wrote:
>
>>Hi everyone,
>>
>>I am searching for a good SQL IDE.  I currently use Query Analyzer, but
>>would really like to find something a bit more robust.  Since most of you
>>guys also write SQL, I figured this would be the best place to ask.  
>>
>>Anyone have any suggestions?
>>
>>Thanks in advance,
>>Chris
>>
>>
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Re: Any way to get Homesite+ 5.5 without Dreamweaver?

2003-09-12 Thread Guy Walker
Dave,

Could you post a URL or point me in the right direction to this upgrade
price?

When I look on MM's site the price I see for an upgrade of CF Studio 5 to
Dreamweaver MX 2004 with Homesite+ 5.5 is $499.00.

This is where I am getting the $499.00 price.

http://shop.macromedia.com/dr/v2/ec_MAIN.Entry17cCID=0&PN=5&SP=10007&SID=46165&PID=590897&DSP=&CUR=840&PGRP=0&CACHE_ID=0

Guy Walker


>
> It's $199 to upgrade from CF Studio 5 to Dreamweaver MX 2004 with
Homesite+
> 5.5.
>


~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


No so good news

2003-09-12 Thread Jeremy
Off topic but it is Friday after all.

Bad News :(

http://news.com.com/2104-1032_3-5074799.html

http://www.zeldman.com



~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


RE: stored procedure doesn't return anything

2003-09-12 Thread Smith, Matthew P -CONT(CSC)
Alternatively, set the procresult to the second record set



Here's the SP with the NOCOUNT mod; use one or the other solution:




CREATE PROCEDURE sp_doctorsearch (@zipcode INTEGER, @radius INTEGER) 
AS
SET NOCOUNT ON

SELECT d.originalID, 
3959 * ACOS(
( SIN(startZip.Lat_degree / 57.3) *
SIN(endZip.Lat_degree / 57.3))
+(COS(startZip.Lat_degree / 57.3)) * COS
(endZip.Lat_degree / 57.3)
* COS((startZip.Lon_degree - endZip.Lon_degree) /
57.3)
)
AS exactDistance
INTO #tempZips
FROM 
zips startZip
INNER JOIN
AESDocs.dbo.addresses d
ON d.Zip = startZip.zip,
zips endZip
WHERE endZip.zip = @zipcode

SET NOCOUNT OFF

SELECT  t.exactDistance, m.*, 
a.institution1, a.institution2, a.address1,
a.address2, a.address3, 
a.address4, a.city, a.state, a.zip, a.phone
FROM #tempZips t INNER JOIN aesdocs.dbo.members m ON t.originalID = 
m.originalID
INNER JOIN aesdocs.dbo.addresses a ON t.originalID = a.originalID
WHERE t.exactDistance <= @radius
GO

-Original Message-
From: Reece, Cynthia [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 12, 2003 1:51 PM
To: CF-Talk
Subject: RE: stored procedure doesn't return anything

Hello,

I am trying to run a stored procedure from coldfusion and return the
results.  When i run the query in the query analyzer giving it the expected
data is works fine, but my coldfusion page says that there were no results.
I am attatching the procedure and the coldfusion code.  Any suggestions as
to what is wrong or even how I could try to debug this would be great.


CREATE PROCEDURE sp_doctorsearch (@zipcode INTEGER, @radius INTEGER) 
AS
SELECT d.originalID, 
3959 * ACOS(
( SIN(startZip.Lat_degree / 57.3) *
SIN(endZip.Lat_degree / 57.3))
+(COS(startZip.Lat_degree / 57.3)) * COS
(endZip.Lat_degree / 57.3)
* COS((startZip.Lon_degree - endZip.Lon_degree) /
57.3)
)
AS exactDistance
INTO #tempZips
FROM 
zips startZip
INNER JOIN
AESDocs.dbo.addresses d
ON d.Zip = startZip.zip,
zips endZip
WHERE endZip.zip = @zipcode

SELECT  t.exactDistance, m.*, 
a.institution1, a.institution2, a.address1,
a.address2, a.address3, 
a.address4, a.city, a.state, a.zip, a.phone
FROM #tempZips t INNER JOIN aesdocs.dbo.members m ON t.originalID =
m.originalID
INNER JOIN aesdocs.dbo.addresses a ON t.originalID =
a.originalID
WHERE t.exactDistance <= @radius
GO


 





#dr_select.recordcount#

Thanks so much
Cynthia

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


RE: stored procedure doesn't return anything

2003-09-12 Thread Smith, Matthew P -CONT(CSC)
SET NOCOUNT ON for the first select?



-Original Message-
From: Reece, Cynthia [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 12, 2003 1:51 PM
To: CF-Talk
Subject: RE: stored procedure doesn't return anything

Hello,

I am trying to run a stored procedure from coldfusion and return the
results.  When i run the query in the query analyzer giving it the expected
data is works fine, but my coldfusion page says that there were no results.
I am attatching the procedure and the coldfusion code.  Any suggestions as
to what is wrong or even how I could try to debug this would be great.


CREATE PROCEDURE sp_doctorsearch (@zipcode INTEGER, @radius INTEGER) 
AS
SELECT d.originalID, 
3959 * ACOS(
( SIN(startZip.Lat_degree / 57.3) *
SIN(endZip.Lat_degree / 57.3))
+(COS(startZip.Lat_degree / 57.3)) * COS
(endZip.Lat_degree / 57.3)
* COS((startZip.Lon_degree - endZip.Lon_degree) /
57.3)
)
AS exactDistance
INTO #tempZips
FROM 
zips startZip
INNER JOIN
AESDocs.dbo.addresses d
ON d.Zip = startZip.zip,
zips endZip
WHERE endZip.zip = @zipcode

SELECT  t.exactDistance, m.*, 
a.institution1, a.institution2, a.address1,
a.address2, a.address3, 
a.address4, a.city, a.state, a.zip, a.phone
FROM #tempZips t INNER JOIN aesdocs.dbo.members m ON t.originalID =
m.originalID
INNER JOIN aesdocs.dbo.addresses a ON t.originalID =
a.originalID
WHERE t.exactDistance <= @radius
GO


 





#dr_select.recordcount#

Thanks so much
Cynthia

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


RE: stored procedure doesn't return anything

2003-09-12 Thread Reece, Cynthia
Hello,

I am trying to run a stored procedure from coldfusion and return the
results.  When i run the query in the query analyzer giving it the expected
data is works fine, but my coldfusion page says that there were no results.
I am attatching the procedure and the coldfusion code.  Any suggestions as
to what is wrong or even how I could try to debug this would be great.


CREATE PROCEDURE sp_doctorsearch (@zipcode INTEGER, @radius INTEGER) 
AS
SELECT d.originalID, 
3959 * ACOS(
( SIN(startZip.Lat_degree / 57.3) *
SIN(endZip.Lat_degree / 57.3))
+(COS(startZip.Lat_degree / 57.3)) * COS
(endZip.Lat_degree / 57.3)
* COS((startZip.Lon_degree - endZip.Lon_degree) /
57.3)
)
AS exactDistance
INTO #tempZips
FROM 
zips startZip
INNER JOIN
AESDocs.dbo.addresses d
ON d.Zip = startZip.zip,
zips endZip
WHERE endZip.zip = @zipcode

SELECT  t.exactDistance, m.*, 
a.institution1, a.institution2, a.address1,
a.address2, a.address3, 
a.address4, a.city, a.state, a.zip, a.phone
FROM #tempZips t INNER JOIN aesdocs.dbo.members m ON t.originalID =
m.originalID
INNER JOIN aesdocs.dbo.addresses a ON t.originalID =
a.originalID
WHERE t.exactDistance <= @radius
GO


 





#dr_select.recordcount#

Thanks so much
Cynthia
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


Re: CF MX *right* book.

2003-09-12 Thread Charlie Griefer
Alex:

You're going to get a slew of different answers here, so by the time
everybody chimes in, just about every mx book will have been mentioned :)
but i'll throw in a ringing endorsement for the MX Bible by Churvis,
Churvis, Arehart, and Helms.

charlie

- Original Message - 
From: "Alexandr Timchur" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, September 12, 2003 8:30 AM
Subject: CF MX *right* book.


> Hi All,
>
> Can you recommend me a right book discovering new features of
> ColdFusion MX, especially CFC, without long speech about
> SQL & Coldfusion basics?
>
>
> Thank you!
> Alex Timchur
>
>
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


RE: RE: Anyone know of a decent SQL ide?

2003-09-12 Thread Douglas.Knudsen
yeah...wierd.

This http://www.aquadatastudio.com/index.html  is quite cool actually.  Its not for a 
Jedi Master DBA type, but for basic SQL writing, table browsing, and the like it works 
nice.  Doesn't look like it can connect to Access though.  JDBC is used with a generic 
ODBC connection, perhaps that can connect to Access.

Doug

>-Original Message-
>From: Chris [mailto:[EMAIL PROTECTED]
>Sent: Friday, September 12, 2003 2:26 PM
>To: CF-Talk
>Subject: Re:RE: Anyone know of a decent SQL ide?
>
>
>I use MS SQL 7 primarily, but it would nice to have an IDE 
>that can connect
>to other db's too via ODBC.  We also have a bit of Access and even some
>dBase (stop laughing).  
>
>I am also seeing replies before I see the original messages.   Weird.
>
>Thanks,
>Chris
>--
>Original Message
>From: ""<[EMAIL PROTECTED]>
>Subject: RE: Anyone know of a decent SQL ide?
>Date: Fri, 12 Sep 2003 12:24:52 -0500
>
>>even funnier, I haven't seen the original post yet, but three 
>replies so
>far!
>>
>>What RDBMS are you using Chris?  We use Toad from Quest 
>software as we are
>an Oracle shop. 
>> It rocks.
>>
>>Doug
>>
>>>-Original Message-
>>>From: Stacy Young [mailto:[EMAIL PROTECTED]
>>>Sent: Friday, September 12, 2003 1:16 PM
>>>To: CF-Talk
>>>Subject: RE: Anyone know of a decent SQL ide?
>>>
>>>
>>>That's funny I just started using that today! It's not too shabby...
>>>
>>>
>>>-Original Message-
>>>From: Mike Brunt [mailto:[EMAIL PROTECTED] 
>>>Sent: September 12, 2003 1:24 PM
>>>To: CF-Talk
>>>Subject: RE: Anyone know of a decent SQL ide?
>>>
>>>Chris, check out Aqua Data Studio, we have a link to it here.
>>>
>>>http://www.webapper.net/index.cfm?fuseaction=Fuseblog.ShowComme
>>>nts&Artic
>>>leID=20030904071557
>>>
>>>Kind Regards - Mike Brunt
>>>
>>>Original Message ---
>>>Hi everyone,
>>>
>>>I am searching for a good SQL IDE.  I currently use Query 
>Analyzer, but
>>>would really like to find something a bit more robust.  Since most of
>>>you
>>>guys also write SQL, I figured this would be the best place to ask.  
>>>
>>>Anyone have any suggestions?
>>>
>>>Thanks in advance,
>>>Chris
>>>
>>>
>>>
>>>
>>
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Re: Anyone know of a decent SQL ide?

2003-09-12 Thread Claude Schneegans
>>but it would nice to have an IDE that can connect
to other db's too via ODBC.

Stay tune! I'm working on something like that: 100% pure HTML-CF-Javascript.
You'll be able to drag'n drop full queries and forms with all table names, column 
names with correct types
without having to press any key on the keybord, directly from an IE window to 
CF-Studio, WordPad, ... or even DW! ;-)

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


RE: Another way

2003-09-12 Thread Tony Weeg
thanks lee...looks like a good ideai couldn't figure out what this
post was about...but now I see :)

tony weeg
sr. web applications architect
navtrak, inc.
[EMAIL PROTECTED]
www.navtrak.net
office 410.548.2337
fax 410.860.2337


-Original Message-
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] 
Sent: Friday, September 12, 2003 2:22 PM
To: CF-Talk
Subject: Another way


Treat the phrase/list of keywords coming in as a list: 

 
 
 
 
 

 
 
  AND columnName LIKE '%#listGetAt(searchPhrase,counter)#%' 
 

This code will produce the following code: 

AND columnName LIKE '%help%' 
AND columnName LIKE '%me%' 
AND columnName LIKE '%now%' 

Use the listLen function to get number of keywords if you still need
that. 

Obviously, adjust the code for "OR" instead of "AND" etc, but you get
the idea.


>lets say, a user enters "skateboarding atlanta half-pipe"
>and you wanted to break that up into separate words, and know that 
>there should be 3 "...or searchTerm like '%wordHere%'" sections in a 
>query  (one for each word) so that the user can search for 
>"skateboarding or atlanta or
>half-pipe" through a sql statement.
>
>is this feasible, i know it has to be, just cant think past my keyboard

>right now.
>
>thanks for any ideas
>
>tony
>
>tony weeg
>[EMAIL PROTECTED]
>www.revolutionwebdesign.com
>rEvOlUtIoN wEb DeSiGn
>410.334.6331
>

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


Re: Strange problem

2003-09-12 Thread Charlie Griefer
Hi Kris:

dunno if you've gotten everything working 100% (i know i'm behind here...had
mail server issues :P)...

but this info might also come in handy for your situation:
http://blog.daemon.com.au/archives/47.html

charlie

- Original Message - 
From: "Kris Pilles" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, September 12, 2003 6:51 AM
Subject: RE: Strange problem


> Thanks for all your help.
>
> Since our IE had a defined proxy server it could get out to the web.  I
> had to add the proxy server info and login to my cfinvoke and now I am
> all set.
>
> Thanks again
>
> KP
>
> -Original Message-
> From: Sean A Corfield [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 11, 2003 8:44 PM
> To: CF-Talk
> Subject: Re: Strange problem
>
>
> Sounds like your client (desktop) machine can hit port 80 on that
> system but your CF server (which is a different machine?) cannot?
>
> On Thursday, Sep 11, 2003, at 12:53 US/Pacific, Kris Pilles wrote:
>
> > Its weird because I can resolve the URL in the vrowser but it seems
> > like
> > Coldfusion can not... Any ideas how to fix on the firewall side?
> >
> > -Original Message-
> > From: Raymond Camden [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, September 11, 2003 3:46 PM
> > To: CF-Talk
> > Subject: RE: Strange problem
> >
> >
> > What happens if you switch to CFHTTP and just dump out the results?
> >
> > ==
> > =
> > =
> > ===
> > Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
> > (www.mindseye.com)
> > Member of Team Macromedia
> (http://www.macromedia.com/go/teammacromedia)
> >
> > Email: [EMAIL PROTECTED]
> > Blog : www.camdenfamily.com/morpheus/blog
> > Yahoo IM : morpheus
> >
> > "My ally is the Force, and a powerful ally it is." - Yoda
> >
> >> -Original Message-
> >> From: Kris Pilles [mailto:[EMAIL PROTECTED]
> >> Sent: Thursday, September 11, 2003 1:44 PM
> >> To: CF-Talk
> >> Subject: RE: Strange problem
> >>
> >>
> >> Still erroriing out, has been doing so since yesturday...
> >>
> >> -Original Message-
> >> From: Raymond Camden [mailto:[EMAIL PROTECTED]
> >> Sent: Thursday, September 11, 2003 3:42 PM
> >> To: CF-Talk
> >> Subject: RE: Strange problem
> >>
> >>
> >> Could it have been a temporary network problem? Can you try again?
> >>
> >> ==
> >> ==
> >> ===
> >> Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
> >> (www.mindseye.com)
> >> Member of Team Macromedia
> >> (http://www.macromedia.com/go/teammacromedia)
> >>
> >> Email:
> >> [EMAIL PROTECTED]
> >> Blog : www.camdenfamily.com/morpheus/blog
> >> Yahoo IM : morpheus
> >>
> >> "My ally is the Force, and a powerful ally it is." - Yoda
> >>
> >>> -Original Message-
> >>> From: Kris Pilles [mailto:[EMAIL PROTECTED]
> >>> Sent: Thursday, September 11, 2003 1:10 PM
> >>> To: CF-Talk
> >>> Subject: RE: Strange problem
> >>>
> >>>
> >>> I did also notice that it was not putting an entry in the
> >> webservices
> >>> in the admin..
> >>>
> >>> -Original Message-
> >>> From: Raymond Camden [mailto:[EMAIL PROTECTED]
> >>> Sent: Thursday, September 11, 2003 3:01 PM
> >>> To: CF-Talk
> >>> Subject: RE: Strange problem
> >>>
> >>>
> >>> If you go to that machine, open a browser and enter the
> >> URL, does it
> >>> work?
> >>>
>
>
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


Odd ReReplace issue

2003-09-12 Thread Scott Weikert
This one's been stumping me for the past little while.

On my main project, users have the ability to add in a little subscriber 
form. I surround the code for this subscriber form with a pair of HTML 
comments, with the text "StartSubForm" and "EndSubForm" in these comments. 
If an existing subscriber is viewing the page, then I don't want to display 
the subscriber form - it's redundant - so I sniff out if the two above 
comments are in the code, and do a ReReplace to remove the form:

", "", "ALL")>

This has worked great until today - one client has, on a page within his 
area, a quiz form. Whenever the above code snippet runs, on this page and 
this page *only*, as far as I can tell, it breaks.

The code the snippet is trying to replace is *identical* on all of said 
client's pages - it's just the one page, with the quiz form (the code for 
which comes along a ways later in the page than the subscriber form I'm 
trying to replace), that hoses up.

Nowhere in the quiz code do those "SubStartForm" or "EndSubForm" strings 
show up, either.

Any thoughts?
--Scott

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


Re:RE: Anyone know of a decent SQL ide?

2003-09-12 Thread Chris
I use MS SQL 7 primarily, but it would nice to have an IDE that can connect
to other db's too via ODBC.  We also have a bit of Access and even some
dBase (stop laughing).  

I am also seeing replies before I see the original messages.   Weird.

Thanks,
Chris
--
Original Message
From: ""<[EMAIL PROTECTED]>
Subject: RE: Anyone know of a decent SQL ide?
Date: Fri, 12 Sep 2003 12:24:52 -0500

>even funnier, I haven't seen the original post yet, but three replies so
far!
>
>What RDBMS are you using Chris?  We use Toad from Quest software as we are
an Oracle shop. 
> It rocks.
>
>Doug
>
>>-Original Message-
>>From: Stacy Young [mailto:[EMAIL PROTECTED]
>>Sent: Friday, September 12, 2003 1:16 PM
>>To: CF-Talk
>>Subject: RE: Anyone know of a decent SQL ide?
>>
>>
>>That's funny I just started using that today! It's not too shabby...
>>
>>
>>-Original Message-
>>From: Mike Brunt [mailto:[EMAIL PROTECTED] 
>>Sent: September 12, 2003 1:24 PM
>>To: CF-Talk
>>Subject: RE: Anyone know of a decent SQL ide?
>>
>>Chris, check out Aqua Data Studio, we have a link to it here.
>>
>>http://www.webapper.net/index.cfm?fuseaction=Fuseblog.ShowComme
>>nts&Artic
>>leID=20030904071557
>>
>>Kind Regards - Mike Brunt
>>
>>Original Message ---
>>Hi everyone,
>>
>>I am searching for a good SQL IDE.  I currently use Query Analyzer, but
>>would really like to find something a bit more robust.  Since most of
>>you
>>guys also write SQL, I figured this would be the best place to ask.  
>>
>>Anyone have any suggestions?
>>
>>Thanks in advance,
>>Chris
>>
>>
>>
>>
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


RE: Free Zip-latitude/longitude db

2003-09-12 Thread Andy Ousterhout
Thanks.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, September 12, 2003 1:24 PM
To: CF-Talk
Subject: Re: Free Zip-latitude/longitude db


You could use mine...

http://www.cfdynamics.com/zipbase

-Novak

- Original Message -
From: "Andy Ousterhout" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, September 12, 2003 8:13 AM
Subject: Free Zip-latitude/longitude db


> Does anyone know where I can find a free zip code - latitude longitude DB?
> Don't need anything fancy, just zip code, longitude, latitude.  Using for
a
> basic store look-up function.
>
> Andy
>
>
>

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


Re: Free Zip-latitude/longitude db

2003-09-12 Thread cf-talk
You could use mine...

http://www.cfdynamics.com/zipbase

-Novak

- Original Message - 
From: "Andy Ousterhout" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, September 12, 2003 8:13 AM
Subject: Free Zip-latitude/longitude db


> Does anyone know where I can find a free zip code - latitude longitude DB?
> Don't need anything fancy, just zip code, longitude, latitude.  Using for
a
> basic store look-up function.
>
> Andy
>
>
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


Another way

2003-09-12 Thread lee
Treat the phrase/list of keywords coming in as a list: 

 
 
 
 
 

 
 
  AND columnName LIKE '%#listGetAt(searchPhrase,counter)#%' 
 

This code will produce the following code: 

AND columnName LIKE '%help%' 
AND columnName LIKE '%me%' 
AND columnName LIKE '%now%' 

Use the listLen function to get number of keywords if you still need that. 

Obviously, adjust the code for "OR" instead of "AND" etc, but you get the idea.


>lets say, a user enters "skateboarding atlanta half-pipe"
>and you wanted to break that up into separate words, and know that
>there should be 3 "...or searchTerm like '%wordHere%'" sections in a
>query
> (one for each word) so that the user can search for "skateboarding or
>atlanta or
>half-pipe" through a sql statement.
>
>is this feasible, i know it has to be, just cant think past my keyboard
>right now.
>
>thanks for any ideas
>
>tony
>
>tony weeg
>[EMAIL PROTECTED]
>www.revolutionwebdesign.com
>rEvOlUtIoN wEb DeSiGn
>410.334.6331 
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


Another way to do it

2003-09-12 Thread lee
Whoops. Posted this by itself.


Treat the phrase/list of keywords coming in as a list: 

 
 
 
 
 

 
 
  AND columnName LIKE '%#listGetAt(searchPhrase,counter)#%' 
 

This code will produce the following code: 

AND columnName LIKE '%help%' 
AND columnName LIKE '%me%' 
AND columnName LIKE '%now%' 

Use the listLen function to get number of keywords if you still need that. 

Obviously, adjust the code for "OR" instead of "AND" etc, but you get the idea.



>lets say, a user enters "skateboarding atlanta half-pipe"
>and you wanted to break that up into separate words, and know that
>there should be 3 "...or searchTerm like '%wordHere%'" sections in a
>query
> (one for each word) so that the user can search for "skateboarding or
>atlanta or
>half-pipe" through a sql statement.
>
>is this feasible, i know it has to be, just cant think past my keyboard
>right now.
>
>thanks for any ideas
>
>tony
>
>tony weeg
>[EMAIL PROTECTED]
>www.revolutionwebdesign.com
>rEvOlUtIoN wEb DeSiGn
>410.334.6331 
>
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com


Another way to do it

2003-09-12 Thread lee
Treat the phrase/list of keywords coming in as a list:









AND columnName LIKE '%#listGetAt(searchPhrase,counter)#%' 


This code will produce the following code:

AND columnName LIKE '%help%'
AND columnName LIKE '%me%'
AND columnName LIKE '%now%'

Use the listLen function to get number of keywords if you still need that.

Obviously, adjust the code for "OR" instead of "AND" etc, but you get the idea.
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


Re: Repost: SQL Help

2003-09-12 Thread Patricia G. L. Hall
> For arguments sake, say you have 1 record for a patient, and 3
> X-ray records for that patient because there are 3 X-ray photo's.
> Which X-ray record do you want to send to the third party? A
> random one, the last one? Or do you just want to send a boolean
> indicating there is a number of X-ray records?

Whenever possible I prefer to compact into a boolean, because in many
cases that is what the spec wants in the end.  However I think there will
be some cases where boolean be an option (otherwise it would be too
consistent and we can't have that).  If and when that happens, I'll have
to choose one of the available values to report.  In those cases there are
no guidelines for me to follow, re: first, last or random.  I prefer to
stay away from random... there's no need for that.  Had I the choice, I'd
choose the first record.  Just because.

I haven't yet figured out how to deal with these when they happen.

>  From your code I get the impression you just want to send the
> boolean, so I will give an example of that based on your original
> post:
>
> SELECT
>   et.caseid,
>   SUM(
>   CASE etp.protocolid
>   WHEN 12 THEN 1
>   ELSE 0
>   END
>   )
> FROM
>   etprocedure et LEFT JOIN eTransferProtocolLink etp ON
> etp.etProcedureid = et.etProcedureid
> GROUP BY
>   et.caseid
>
> (This will not really return a boolean, it will return the number
> of records but CF will be able to interpret it as a boolean. Use
> another CASE statement if you really want a boolean.)
>
> Jochem

Excellent.  I modified it a bit because I need to select against a
specific number of ids... and when there are no recrds in etprocedure that
match, I still need to return a row for that id.  I also changed SUM to
MAX as that fits better.  So this is what seems to be working for me so
far:

SELECT
et.caseid,
MAX(
CASE etp.protocolid
WHEN 12 THEN 1
ELSE 0
END
)
FROM
etprocedure et LEFT JOIN eTransferProtocolLink etp ON
etp.etProcedureid = et.etProcedureid
Where
et.caseid IN (76,77,78,80)
GROUP BY
   et.caseid

Union

Select
ci.caseID,
'0'
>From caseInfo ci
Where ci.caseID IN (76,77,78,80) AND
ci.caseID NOT IN  (
Select Distinct caseID
From etProcedure
)

Thanks so much for your help.  I'm not done yet, but I have hopes that
this will get me further than before.

-Patti
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


RE: Any way to get Homesite+ 5.5 without Dreamweaver?

2003-09-12 Thread Dave Watts
> If you have already paid for CF Studio 5 - what are your 
> upgrade options and what will they cost?

It's $199 to upgrade from CF Studio 5 to Dreamweaver MX 2004 with Homesite+
5.5.
 
> I really want to know 'cos, I'm getting quite confused. My 
> developers only want to use a lean mean code editor -i.e. 
> CFStudio/HS+

Everything you could possibly want to know is right on the Macromedia site.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


RE: Any way to get Homesite+ 5.5 without Dreamweaver?

2003-09-12 Thread Ben Forta
Actually, there is an interface (I use it for www.forta.com/cf/tags),
but it was never exposed publicly. I'll do some digging to see if we can
get it exposed.

--- Ben


-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 12, 2003 12:51 PM
To: CF-Talk
Subject: RE: Any way to get Homesite+ 5.5 without Dreamweaver?


> Speaking of the tag gallery
> 
> If they aren't going to change the tag gallery, they should
> document and expose the web services that power it. Then we 
> could put up our best efforts. Bet we could put those MM guys 
> to shame!
> 


That's been requested for ages. Heck, I think I even offered to write
one a while back. MACR, is there _any_ update on exposing the tag
gallery to outsiders? Please? Pretty please? Etc? :) I'm almost tempted
to replicate cflib.org for customtags. ;)


===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
(www.mindseye.com)
Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia)

Email: [EMAIL PROTECTED]
Blog : www.camdenfamily.com/morpheus/blog
Yahoo IM : morpheus

"My ally is the Force, and a powerful ally it is." - Yoda 



~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Get the mailserver that powers this list at 
http://www.coolfusion.com


RE: RE: Anyone know of a decent SQL ide?

2003-09-12 Thread Joshua Miller
MacSQL is pretty good too, but Aqua Data Studio is by far my favorite!

Joshua Miller
Head Programmer / IT Manager
Garrison Enterprises Inc.
www.garrisonenterprises.net
[EMAIL PROTECTED]
(704) 569-0801 ext. 254
 

*
Any views expressed in this message are those of the individual sender,
except where the sender states them to be the views of 
Garrison Enterprises Inc.
 
This e-mail is intended only for the individual or entity to which it is
addressed and contains information that is private and confidential. If
you are not the intended recipient you are hereby notified that any
dissemination, distribution or copying is strictly prohibited. If you 
have received this e-mail in error please delete it immediately and
advise us by return e-mail to [EMAIL PROTECTED]

*


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 12, 2003 1:38 PM
To: CF-Talk
Subject: Re: RE: Anyone know of a decent SQL ide?


Thank you! Thank you! Thank you!

You have just made my month!

- Original Message -
From: Mike Brunt <[EMAIL PROTECTED]>
Date: Friday, September 12, 2003 11:24 am
Subject: RE: Anyone know of a decent SQL ide?

> Chris, check out Aqua Data Studio, we have a link to it here.
> 
>
http://www.webapper.net/index.cfm?fuseaction=Fuseblog.ShowComments&Artic
leID=20030904071557
> 
> Kind Regards - Mike Brunt
> 
> Original Message ---
> Hi everyone,
> 
> I am searching for a good SQL IDE.  I currently use Query 
> Analyzer, but
> would really like to find something a bit more robust.  Since most 
> of you
> guys also write SQL, I figured this would be the best place to 
> ask.  
> 
> Anyone have any suggestions?
> 
> Thanks in advance,
> Chris
> 
> 
> 

~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. 
http://www.fusionauthority.com/signup.cfm


Re: RE: Anyone know of a decent SQL ide?

2003-09-12 Thread ksuh
Thank you! Thank you! Thank you!

You have just made my month!

- Original Message -
From: Mike Brunt <[EMAIL PROTECTED]>
Date: Friday, September 12, 2003 11:24 am
Subject: RE: Anyone know of a decent SQL ide?

> Chris, check out Aqua Data Studio, we have a link to it here.
> 
> http://www.webapper.net/index.cfm?fuseaction=Fuseblog.ShowComments&ArticleID=20030904071557
> 
> Kind Regards - Mike Brunt
> 
> Original Message ---
> Hi everyone,
> 
> I am searching for a good SQL IDE.  I currently use Query 
> Analyzer, but
> would really like to find something a bit more robust.  Since most 
> of you
> guys also write SQL, I figured this would be the best place to 
> ask.  
> 
> Anyone have any suggestions?
> 
> Thanks in advance,
> Chris
> 
> 
> 
~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. 
http://www.fusionauthority.com/ads.cfm


  1   2   3   >