Re: Refactoring a query WAS RE: Change a queries orientation.

[Ian Skinner]

> Ian Skinner wrote:
> > Any of you SQL experts/gurus care to try a round of pro bono query 
> optimization.  After a lot of trial and error and tinkering I was able 
> to write this query that gets the results I need, but boy is it 
> convoluted and long.  My gut says there is a better way to do this, 
> but I have no idea where to start.
> 
> Indenting it?
> 
Jochem

Well it is indented in my code base, but you should have seen what the e-mail 
looked like that way.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215388
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CFEclipse 1.2

[Matt Robertson]

Congratulations Rob!

-- 
--mattRobertson--
Janitor, MSB Web Systems
mysecretbase.com 


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215387
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CFEclipse 1.2

[Matt Robertson]

Well, its the template that controls a boatload of editing functionality in 
my cms. Nothing top secret or especially brilliant in it but kinda on the 
proprietary side. You can look if you like after reading the following. 
 I *know* I could shorten it up by separating out the action section at 
template top. I've got 1400 or so lines of the 2100 lines of code in that 
portion (which is loaded with tag and include calls as appropriate). Also, 
when I write code, I write vertically, by that I mean I do not write 
  
 I instead write it
  
  and 
 
 I do put a very few tags on a single line (like cfparam) but not many. Same 
with html form fields (and there are a bunch of them there). That style adds 
a lot of lines to the count. And my SQL is along these lines:
 
UPDATE 
topics_groups
SET 
topics_groups.ParentID=

WHERE 
topics_groups.ParentID=


 (no wisecracks about the use of client vars... gotta do that for backward 
compatibility in this particular app).
 Anyway that could be done in a LOT fewer lines, and as you can imagine an 
update of 20 fields is a couple of screenfuls. But I like writing it this 
way as part of a set of standards I always stick to, which to me are more 
readable.
 I bet if I broke all of the 14 actions into includes -- includes called in 
only one place in the app -- and switched to single-line tag calls I'd be 
within your 500-line limit.
 But I don't wanna :-)

-- 
--mattRobertson--
Janitor, MSB Web Systems
mysecretbase.com 


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215386
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Spell Checker

[Todd Mathews]

Roger,

That looks perfect. I'll check it out and thanks for the info. 

> -Original Message-
> From: Roger B. [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, August 16, 2005 10:04 PM
> To: CF-Talk
> Subject: Re: Spell Checker
> 
> > Does anyone know of an open source or low cost spell checker that 
> > works with CFMX?
> 
> http://admin.mxblogspace.journurl.com/?mode=article&entry=6272
> 
> --
> Roger Benningfield
> JournURL
> http://admin.support.journurl.com/
> http://admin.mxblogspace.journurl.com/
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215385
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CF-Talk: Digest every hour

[Judith Dinowitz]

This is such a great definition that I put it up on Fusion Authority. Isaac, 
you are immortalized! You are article 4500!

http://www.fusionauthority.com/Community/Article.cfm/ArticleID:4500

Judith

>A word that's repeated because other people are repeating it (like
>"AJAX") instead of a word that is repeated because it represents
>something which has intrinsic value (like "XML"). In some cases a
>"buzzword" may be representative of something which has intrinsic
>value (like "XML") if the word is repeated by someone who doesn't
>understand anything about it and they are repeating it because the
>word is being repeated by other people.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215384
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CFX tag installation - problem

[Andrew Grosset]

tried that still no go

thanks anyway,

Andrew.


>I believe it is expecting to see your tag in the
>C:\CFusionMX\CustomTags\ directory, and not under the CFIDE directory.
> I normally create a cfx folder underneath there and drop them in
>there, as in C:\CFusionMX\CustomTags\cfx\CFX_image_mx.dll
>
>Try that and see if it doesn't work better for you.
>
>v/r,
>
>-- 
>Jeff Fleitz
>
>
>On 8/16/05, Andrew Grosset <[EMAIL PROTECTED]> wrote:
>>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215383
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Spell Checker

[Roger B.]

> Does anyone know of an open source or low cost spell checker that works with
> CFMX? 

http://admin.mxblogspace.journurl.com/?mode=article&entry=6272

--
Roger Benningfield
JournURL
http://admin.support.journurl.com/
http://admin.mxblogspace.journurl.com/

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215382
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CFX tag installation - problem

[Jeff Fleitz]

I believe it is expecting to see your tag in the
C:\CFusionMX\CustomTags\ directory, and not under the CFIDE directory.
 I normally create a cfx folder underneath there and drop them in
there, as in C:\CFusionMX\CustomTags\cfx\CFX_image_mx.dll

Try that and see if it doesn't work better for you.

v/r,

-- 
Jeff Fleitz


On 8/16/05, Andrew Grosset <[EMAIL PROTECTED]> wrote:
> I have the developer edition of MX7 on my PC. I have placed 
> "CFX_image_mx.dll" in the CustomTags folder (shown below), I have registered 
> the tag in the ColdFusion Administrator and the tag path has been registered:
> 
> C:\CFusionMX7\wwwroot\CFIDE\**\CustomTags
> 
> The page is being called from here:
> 
> http://127.0.0.1:8500/CFIDE/**/image.cfm.
> 
> I get this error:
>  "Error processing CFX custom tag "CFX_image_mx".
> The CFX custom tag "CFX_image_mx" was not found in the custom tag database. 
> Please be sure to add custom tags to the database before using them. If you 
> have added your tag to the database then you should check the spelling of the 
> tag within your template to insure that it matches the database entry."
> 
> I have restarted my PC etc all to no avail
> 
> Should I enter a "ColdFusion Class Path" in "Server Settings > Java and JVM " 
> of ColdFusion Administrator and if so what?
> 
> any other ideas?
> 
> thanks, Andrew.
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215381
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

CFX tag installation - problem

[Andrew Grosset]

I have the developer edition of MX7 on my PC. I have placed "CFX_image_mx.dll" 
in the CustomTags folder (shown below), I have registered the tag in the 
ColdFusion Administrator and the tag path has been registered:

C:\CFusionMX7\wwwroot\CFIDE\**\CustomTags

The page is being called from here:

http://127.0.0.1:8500/CFIDE/**/image.cfm.

I get this error:
 "Error processing CFX custom tag "CFX_image_mx".
The CFX custom tag "CFX_image_mx" was not found in the custom tag database. 
Please be sure to add custom tags to the database before using them. If you 
have added your tag to the database then you should check the spelling of the 
tag within your template to insure that it matches the database entry."

I have restarted my PC etc all to no avail

Should I enter a "ColdFusion Class Path" in "Server Settings > Java and JVM " 
of ColdFusion Administrator and if so what?

any other ideas?

thanks, Andrew.

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215380
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CFEclipse 1.2

[Tony Weeg]

i typically write a LARGE file that does most if not all functionality.
then ill break that up as i see it fit.  reuse where i can.
cfc where it makes sense, and then move on to the next project.

a lot of times im under the gun to get something turned out, and thats just fast
for me.

i should have that option, or it should state that under a certain
number of lines
i can expect good behaviour, and stay away from too many.

again.

homesite is ok with it.
dreamweaver is ok with it.
cfeclipse is not.

you tell me.

On 8/16/05, S. Isaac Dealey <[EMAIL PROTECTED]> wrote:
> > Out of curiosity I checked my very largest template in my
> > CMS. 68k and 2181
> > lines. I could slice it into smaller pieces but that would
> > introduce
> > managability issues. I prefer to have the actions taken by
> > a template within
> > that same template (at the top in a switch). Not
> > fragmented into (in this
> > case) about 14 sub-templates simply for the sake of
> > keeping the line count
> > down.
> 
> > Sheer size is not an *inherent* detriment to
> > manageability. Disorganization
> > is the problem. A cleanly organized template should have
> > no managability
> > issues even at this size, other than having to hit PgDn a
> > few more times to
> > get to Item A, B or C.
> 
> Hey Matt,
> 
> As an excercise, would you be willing to let me have a look at the
> file?
> 
> Though I could be wrong, I tend to disagree -- I think size is in and
> of itself an inherent detriment.
> 
> 
> s. isaac dealey 954.522.6080
> new epoch : isn't it time for a change?
> 
> add features without fixtures with
> the onTap open source framework
> 
> http://www.fusiontap.com
> http://coldfusion.sys-con.com/author/4806Dealey.htm
> 
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215379
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: BlogCFC 3.9 Released

[Rick Faircloth]

Thanks, Jeff...

-Original Message-
From: Jeff Fleitz [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 16, 2005 9:52 PM
To: CF-Talk
Subject: Re: BlogCFC 3.9 Released


The Studio website says sometime in September.

http://www.macromedia.com/software/studio/productinfo/faq/#item-2-3

--
Jeff Fleitz



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215378
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: BlogCFC 3.9 Released

[Jeff Fleitz]

The Studio website says sometime in September.

http://www.macromedia.com/software/studio/productinfo/faq/#item-2-3

-- 
Jeff Fleitz

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215377
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Language...

[S . Isaac Dealey]

> If you, as another human being, say to me,
> "I find that word offensive." Then I find
> it pretty easy to say, "that's cool - I
> won't use it anymore where you are forced
> to hear it." Seems like a pretty easy
> compromise to me. In fact, I find this
> effort so trifling that I suspect folks
> that rise up in defense of their "right
> to hurl the f-bomb" are probably unwilling
> to give ground in any situation.  This
> smacks of an attitude that puts personal
> freedoms and rights above personal
> responsibility, engaged community and
> civility.

I have no problem with apologizing if I offend someone and making an
effort to avoid offending them again... What I find offensive is
blanket censorship, whether it's legally or socially enforced.


s. isaac dealey 954.522.6080
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215376
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: coldfusion load balancing with NLB

[Russ]

I have found another article that seems to have better detail on how to
setup the NLB portion of it.  

http://www.west-wind.com/presentations/loadbalancing/NetworkLoadBalancingWin
dows2003.asp

It looks like if you setup single or class c affinity, it will forward the
requests from a specific ip (or a class c subnet) always to the same server
(barring any failures).  

However, neither article seems to mention anything about application server
failures.  What happens if ColdFusion fails, but IIS keeps running?  How
would I set up something like that?

Russ

-Original Message-
From: Douglas Knudsen [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 16, 2005 8:57 PM
To: CF-Talk
Subject: Re: coldfusion load balancing with NLB

The article speaks of JRUn clustering and NLB, eh?  If you are talking
about sticky sessions and CF and enterprise versus standard, are you
not talking of JRUn clustering?  CF Standard does nto support this at
all, you have to have enterprise to use JRUn clustering.  ( me thinks
if you own JRun seperately and purchase CF Standard to run under you
can then cluster, seems an odd purchase though)  JRun cluster can use
sticky or non-sticky sessions, depends on your code base though which
you can use.

Now, for NLB, I don't know so much about that. A quick read just
now...yummy.  My guess is CF standard would be fine with it.  NLB
stuff would occur before CF, eh?  In other words, you can use the NLB
clustering, just not a JRun cluster, so no "dual-cluster setup" as the
article calls it.

DK

On 8/16/05, Russ <[EMAIL PROTECTED]> wrote:
> We're looking to add a second CF server, and want to set up a load balance
> solution.  Since crystaltech doesn't support any kind of load balancing,
> we're looking into setting up windows load balancing with them through
NLB.
> I have read the macromedia article about it on
> 
> 
> 
> http://www.macromedia.com/devnet/coldfusion/articles/nlb_failover.html
> 
> 
> 
> In the article they talk about using ColdFusion enterprise to set up
sticky
> sessions, etc.  What would we lose if we went with CF standard instead of
> enterprise?   I'm not very familiar with NLB, but I'm guessing it only
does
> Round Robin load balancing, or can it be set up to support sticky sessions
> as well?  What happens in case of CF failure (but not IIS?).  I believe I
> read on one of the blogs that we should be using something like
ServersAlive
> for this reason.   Is this something that CF enterprise handles
> automatically due to clustering, or did the article just forget to mention
> it?
>

> 
> 
> Russ
> 
> 
> 
> 



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215375
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: BlogCFC 3.9 Released

[Rick Faircloth]

Speaking of DW 8...does anyone have any idea
when it *might* be released for production?

I'm considering starting to use DW, but realized it's
MX 2004 that's the current production version...how
long might I have to wait for DW 8 to be sold?

Rick

-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 16, 2005 8:10 PM
To: CF-Talk
Subject: RE: BlogCFC 3.9 Released


> A bit extra work as fun makes BlogCFC cool! :)

> Here is my latest design for BlogCFC 3.9

> http://demirkapi.net/blogcfc/

> It is really a fun for me to make my designs. I just use
> new DW 8 for CSS
> support etc.

Interesting choice to have the middle column static...

Nice design overall. :)


s. isaac dealey 954.522.6080
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215374
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Offline application

[Jim Davis]

> Kurt Kaptein wrote:
> 
> >
> >
> >I have a customer who would like an application developed that I would
> like
> >to do in coldfusion, but they insist that it be built for their local
> >desktop and then the data transferred via disk so that another individual
> >who has no access to the internet can work on it.  I do not need to worry
> >about syncing the data as it is a mom or daughter team that work on the
> app.
> >
> >Is there something like coldfusion I could use for an offline app.  I was
> >just going to use acess for data storage.  I do not want develop a access
> >front end. This has always been a pain

There are... but nothing really solid that I know of.

You could install the CF developer's edition on the local machine... it
would definitely work and the IP limitation wouldn't be a bother.  But it's
really overkill for one little app (unless the app isn't so little - but
still, you'd be installed 200 meg or so of stuff plus a handful of services
just for that one app).

If you're comfortable with other web tech (especially JavaScript) you could
build apps in the IE engine using the HTA (hyper text application)
framework.  Essentially it's a "blank" IE frame that has application
privileges (you can access the system registry and file system via COM
objects and pretty much do anything you want).

I think FireFox also has a similar "application" mode but I'm not sure.

Those would be, I think, the best solutions.  You use web tech (HTML, Style
Sheets, JavaScript, DHTML, etc) to make your app, but the app has full
system rights.

Really cool stuff.

Jim Davis





~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215373
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CFEclipse 1.2

[Rob]

Sweet Jesus - fist to cuffs :)

If you open a large file in CFE and it behaves funny we'd like to know
about it. Sending us the file (if possible) will help quite a bit.
Also what OS and specs your system has might help. CFE should (and
does the last time I checked) open large file 2000 lines should work.

Now as to if the file *should* be that large - that's up to you guys
but I am totally digging the fight :-D

Just so everyone knows too, I am getting married this weekend so I am
mostly gone this week and Spike is coming down too so 1/2 of the cfe
crew is not around we are not ignoring you. We'll be sifting though
this stuff when we get fully back online.

Cheers,
Rob

-- 
~Blog~
http://www.robrohan.com
~The cfml plug-in for eclipse~
http://cfeclipse.tigris.org 
~open source xslt IDE~
http://treebeard.sourceforge.net

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215372
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CFEclipse 1.2

[S . Isaac Dealey]

> Out of curiosity I checked my very largest template in my
> CMS. 68k and 2181
> lines. I could slice it into smaller pieces but that would
> introduce
> managability issues. I prefer to have the actions taken by
> a template within
> that same template (at the top in a switch). Not
> fragmented into (in this
> case) about 14 sub-templates simply for the sake of
> keeping the line count
> down.

> Sheer size is not an *inherent* detriment to
> manageability. Disorganization
> is the problem. A cleanly organized template should have
> no managability
> issues even at this size, other than having to hit PgDn a
> few more times to
> get to Item A, B or C.

Hey Matt,

As an excercise, would you be willing to let me have a look at the
file?

Though I could be wrong, I tend to disagree -- I think size is in and
of itself an inherent detriment.


s. isaac dealey 954.522.6080
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215371
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: BlogCFC 3.9 Released

[S . Isaac Dealey]

> A bit extra work as fun makes BlogCFC cool! :)

> Here is my latest design for BlogCFC 3.9

> http://demirkapi.net/blogcfc/

> It is really a fun for me to make my designs. I just use
> new DW 8 for CSS
> support etc.

Interesting choice to have the middle column static...

Nice design overall. :)


s. isaac dealey 954.522.6080
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215370
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: coldfusion load balancing with NLB

[Douglas Knudsen]

The article speaks of JRUn clustering and NLB, eh?  If you are talking
about sticky sessions and CF and enterprise versus standard, are you
not talking of JRUn clustering?  CF Standard does nto support this at
all, you have to have enterprise to use JRUn clustering.  ( me thinks
if you own JRun seperately and purchase CF Standard to run under you
can then cluster, seems an odd purchase though)  JRun cluster can use
sticky or non-sticky sessions, depends on your code base though which
you can use.

Now, for NLB, I don't know so much about that. A quick read just
now...yummy.  My guess is CF standard would be fine with it.  NLB
stuff would occur before CF, eh?  In other words, you can use the NLB
clustering, just not a JRun cluster, so no "dual-cluster setup" as the
article calls it.

DK

On 8/16/05, Russ <[EMAIL PROTECTED]> wrote:
> We're looking to add a second CF server, and want to set up a load balance
> solution.  Since crystaltech doesn't support any kind of load balancing,
> we're looking into setting up windows load balancing with them through NLB.
> I have read the macromedia article about it on
> 
> 
> 
> http://www.macromedia.com/devnet/coldfusion/articles/nlb_failover.html
> 
> 
> 
> In the article they talk about using ColdFusion enterprise to set up sticky
> sessions, etc.  What would we lose if we went with CF standard instead of
> enterprise?   I'm not very familiar with NLB, but I'm guessing it only does
> Round Robin load balancing, or can it be set up to support sticky sessions
> as well?  What happens in case of CF failure (but not IIS?).  I believe I
> read on one of the blogs that we should be using something like ServersAlive
> for this reason.   Is this something that CF enterprise handles
> automatically due to clustering, or did the article just forget to mention
> it?
>

> 
> 
> Russ
> 
> 
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215369
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF-Talk: Digest every hour

[Gabriel Bulfon]

Yes, thanks

Gabriel Bulfon
Email:[EMAIL PROTECTED] 

> -Original Message-
> From: Tony Weeg [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, August 16, 2005 6:44 PM
> To: CF-Talk
> Subject: Re: CF-Talk: Digest every hour
> 
> Gabriel.
> 
> It simply means that its a overused word to describe something.
> If we were talking cars, one of the buzzwords for cars today 
> is "Hybrid".
> If we were talking web communications technologies, a 
> buzzword would be "Webservices, and XML"
> 
> make sense?
> 
> tony
> 
> 
> 
> On 8/16/05, Gabriel Bulfon <[EMAIL PROTECTED]> wrote:
> > Sorry, what is the meaning of buzzword ?
> > 
> > Gabriel Bulfon
> > Email:[EMAIL PROTECTED]
> > 
> > > -Original Message-
> > > From: Damien McKenna [mailto:[EMAIL PROTECTED]
> > > Sent: Tuesday, August 09, 2005 4:18 PM
> > > To: CF-Talk
> > > Subject: RE: CF-Talk: Digest every hour
> > >
> > > > -Original Message-
> > > > From: Dave Watts [mailto:[EMAIL PROTECTED]
> > > >
> > > > Well, "AJAX" is nothing more than a buzzword. People have
> > > been writing
> > > > DHTML interfaces for years that do essentially the same thing.
> > >
> > > 
> > > "DHTML" is a buzzword and is nothing more than JS, CSS and DOM 
> > > wrapped up together.
> > >
> > > --
> > > Damien McKenna - Web Developer -
> > > [EMAIL PROTECTED] The Limu Company - 
> > > http://www.thelimucompany.com/ - 407-804-1014 #include 
> > >
> > >
> > >
> > 
> > 
> 
> 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215368
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Language...

[S . Isaac Dealey]

> Issac,

> If you believe that someone's use of foul language in the
> workplace is
> acceptable because that's the way they behave outside of
> the office,
> you're certainly entitled to your opinion.

> I'd recommend you go and consult with human resource
> professionals and
> attorneys from big firms to get their opinions on that
> especially when
> it makes other workers feel uncomfortable.

I was expressing an opinion RAY. Moreover I find it detestible that
the opinion of lawyers in this matter is even considered important.
That implies that we're not just legislating taste, but that the act
of legislating taste has become an accepted social norm. I find it
really offensive that we have no problem creating laws just because
some group of people "don't like" something or are "uncomfortable"
with it. Why don't we just skip the intervening years and just go
straight to thought police and start arresting people for "conspiracy
to use offensive language"?

There are a hell of a lot of things I don't like -- I don't like
sports or wrestling. In all honesty, much of the time I find them
rather revolting (the advertising and the attitudes and the blatant
lack of priorities our culture exhibits by paying the athletes such
exorbitant salaries -- not the act of playing sports). The difference
is I would never demand or for that matter even ask that my opinion
about it be made law.

I find that many orders-of-magnitude more offensive than "foul
language" that "some people don't like". If you don't like the way
someone talks or acts at your job, then it's your prerogative to do
something about it, whether that's talking to the person or ultimately
finding another job. Nobody puts a gun to your head and tells you to
work at that job. Legislating what a person can or can't say or where
they can or can't say it... that's offensive.

I'm sorry if I'm just not litigious enough for you... that when
someone makes me uncomfortable my first thought isn't
"there aughta ba a law". Life sucks, get a helmit.


s. isaac dealey 954.522.6080
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215367
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFEclipse 1.2

[S . Isaac Dealey]

> Isaac,

> I respect your opinion, but I just don't agree.

> Kevin.

okay

s. isaac dealey 954.522.6080
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215366
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFEclipse 1.2

[Kazmierczak, Kevin]

Isaac,

I respect your opinion, but I just don't agree. 

Kevin.


-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Tue 8/16/2005 6:59 PM
To: CF-Talk
Subject: RE: CFEclipse 1.2
 
> Why do we have any error catching tools?
> If we all wrote perfect code we wouldn't
> need them, but at least cf is flexible
> enough to provide them.  Sure we should
> keep our code small, but the ide should
> be able to handle it regardless.  Just
> because you shouldn't run into a problem
> doesn't mean you avoid it.

Umm... yes, yes it does... If a problem is caused by a poor coding
habbit, then I adopt a better coding habbit. The same way that, if I
discover that I'm spending a lot of money on tires as a result of
frequently driving over broken glass, I will try and reduce the amount
of broken glass I drive over. Can I drive over broken glass? Yes. Does
it always puncture the tire? No. Do I ignore the glass in the road
because it may not puncture the tire? No. And sure, I may buy fixaflat
and tires that are advertised as being more puncture resistant, but
I'm not going to bitch to the tire company because the tires don't
last if I pave my driveway with broken glass.

The example of error handling tools in CF isn't a good one... Errors
often occur during normal operation -- this is analogous to fix-aflat
or more puncture resistant tires. Error handling tools are used in
normal operating conditions. Editing a code template that's the size
of an Oxford English Dictionary should not be a normal operating
condition and therefore does not deserve the kind of attention devoted
to tasks performed under normal operating conditions.

Moreover, it's also not something that occurs accidentally like a bug
or glass in the road... you don't look up one morning and say
"wps! that ColdFusion template just ougrew a CD" -- it's something
you have absolute control over at all times, and can easily avoid. It
takes all of a few seconds to slice it up into a couple includes. I'd
much prefer the couple seconds to do that over continuing to struggle
and argue and bitch about the fact that the IDE has problems with it
for hours or days on end. It's a quick, easy, simple and obvious
solution which at the same time means better code. Why fight doing
something that's an inate improvement, has no drawbacks and requires
almost no time to implement? And if you're not fighting it, then you
have no reason to complain about any given IDE having a problem with
the alternative.


s. isaac dealey   954.522.6080
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm






~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215365
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Refactoring a query WAS RE: Change a queries orientation.

[Jochem van Dieten]

Ian Skinner wrote:
> Any of you SQL experts/gurus care to try a round of pro bono query 
> optimization.  After a lot of trial and error and tinkering I was able to 
> write this query that gets the results I need, but boy is it convoluted and 
> long.  My gut says there is a better way to do this, but I have no idea where 
> to start.

Indenting it?

Jochem

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215364
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: coldfusion load balancing with NLB

[Nathan Strutz]

What you'll lose is the ability to have your J2EE server replicate 
session data (minus CFCs). You can still do it manually, like through a 
database, but as long as your NLB keeps users sticky to each server, you 
shouldn't have any problems.

-nathan strutz


Russ wrote:
> We're looking to add a second CF server, and want to set up a load balance
> solution.  Since crystaltech doesn't support any kind of load balancing,
> we're looking into setting up windows load balancing with them through NLB.
> I have read the macromedia article about it on 
> 
>  
> 
> http://www.macromedia.com/devnet/coldfusion/articles/nlb_failover.html
> 
>  
> 
> In the article they talk about using ColdFusion enterprise to set up sticky
> sessions, etc.  What would we lose if we went with CF standard instead of
> enterprise?   I'm not very familiar with NLB, but I'm guessing it only does
> Round Robin load balancing, or can it be set up to support sticky sessions
> as well?  What happens in case of CF failure (but not IIS?).  I believe I
> read on one of the blogs that we should be using something like ServersAlive
> for this reason.   Is this something that CF enterprise handles
> automatically due to clustering, or did the article just forget to mention
> it? 
> 
>  
> 
> Russ
> 
> 
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215363
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Offline application

[Aaron DC]

Have you checked out http://www.pcaonline.com/coral/?

Aaron

Kurt Kaptein wrote:

> 
>
>I have a customer who would like an application developed that I would like
>to do in coldfusion, but they insist that it be built for their local
>desktop and then the data transferred via disk so that another individual
>who has no access to the internet can work on it.  I do not need to worry
>about syncing the data as it is a mom or daughter team that work on the app.
>
>Is there something like coldfusion I could use for an offline app.  I was
>just going to use acess for data storage.  I do not want develop a access
>front end. This has always been a pain
>
>Any direction is much appreciated
>
>Sincerely,
> 
>Kurt Kaptein
> 
>Kurt Kaptein
>Spectrum Net Designs, Inc
>PO Box 806
>Grandville,  MI  49468
>Toll Free:  866-773-2638
>Fax:  616-538-5691
>Website:   www.spectrumnetdesigns.com
>Email: [EMAIL PROTECTED]
> 
>
>
>
>

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215362
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CFEclipse 1.2

[Matt Robertson]

Out of curiosity I checked my very largest template in my CMS. 68k and 2181 
lines. I could slice it into smaller pieces but that would introduce 
managability issues. I prefer to have the actions taken by a template within 
that same template (at the top in a switch). Not fragmented into (in this 
case) about 14 sub-templates simply for the sake of keeping the line count 
down.

Sheer size is not an *inherent* detriment to manageability. Disorganization 
is the problem. A cleanly organized template should have no managability 
issues even at this size, other than having to hit PgDn a few more times to 
get to Item A, B or C.

I try to only create includes when code re-use is involved. I can't stand 
having a zillion little files laying around that are only used once and that 
someone split off so they could scroll thru their code easier.

Isaac prefers small files. I prefer centralized ones. We both are smart 
enough to keep code re-use in mind so thats not an issue. 

This is all just personal preference. Neither approach is particularly bad.


-- 
--mattRobertson--
Janitor, MSB Web Systems
mysecretbase.com 


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215361
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Spell Checker

[Russ Michaels]

www.spellchecker.net

Works with anything 

-Original Message-
From: Todd Mathews [mailto:[EMAIL PROTECTED] 
Sent: 16 August 2005 23:01
To: CF-Talk
Subject: Spell Checker

Does anyone know of an open source or low cost spell checker that works with
CFMX? The intended usage is to spell check text area contents prior to form
submission.

thx





~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215360
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

coldfusion load balancing with NLB

[Russ]

We're looking to add a second CF server, and want to set up a load balance
solution.  Since crystaltech doesn't support any kind of load balancing,
we're looking into setting up windows load balancing with them through NLB.
I have read the macromedia article about it on 

 

http://www.macromedia.com/devnet/coldfusion/articles/nlb_failover.html

 

In the article they talk about using ColdFusion enterprise to set up sticky
sessions, etc.  What would we lose if we went with CF standard instead of
enterprise?   I'm not very familiar with NLB, but I'm guessing it only does
Round Robin load balancing, or can it be set up to support sticky sessions
as well?  What happens in case of CF failure (but not IIS?).  I believe I
read on one of the blogs that we should be using something like ServersAlive
for this reason.   Is this something that CF enterprise handles
automatically due to clustering, or did the article just forget to mention
it? 

 

Russ



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215359
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF-Talk: Digest every hour

[S . Isaac Dealey]

A word that's repeated because other people are repeating it (like
"AJAX") instead of a word that is repeated because it represents
something which has intrinsic value (like "XML"). In some cases a
"buzzword" may be representative of something which has intrinsic
value (like "XML") if the word is repeated by someone who doesn't
understand anything about it and they are repeating it because the
word is being repeated by other people.

> Sorry, what is the meaning of buzzword ?

> Gabriel Bulfon
> Email:[EMAIL PROTECTED]

>> -Original Message-
>> From: Damien McKenna [mailto:[EMAIL PROTECTED]
>> Sent: Tuesday, August 09, 2005 4:18 PM
>> To: CF-Talk
>> Subject: RE: CF-Talk: Digest every hour
>>
>> > -Original Message-
>> > From: Dave Watts [mailto:[EMAIL PROTECTED]
>> >
>> > Well, "AJAX" is nothing more than a buzzword. People
>> > have
>> been writing
>> > DHTML interfaces for years that do essentially the same
>> > thing.
>>
>> 
>> "DHTML" is a buzzword and is nothing more than JS, CSS
>> and
>> DOM wrapped up together.
>>
>> --
>> Damien McKenna - Web Developer -
>> [EMAIL PROTECTED] The Limu Company -
>> http://www.thelimucompany.com/ - 407-804-1014 #include
>> 


s. isaac dealey   954.522.6080
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm




~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215358
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: determining darkness/lightness of hex colors

[Jim Davis]

> -Original Message-
> From: Scott Weikert [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, August 16, 2005 6:06 PM
> To: CF-Talk
> Subject: SOT: determining darkness/lightness of hex colors
> 
> Hey gang,
> 
> I've done some Googling on this but haven't found anything helpful.
> 
> I'm looking for a way to determine, for lack of better terms, the
> darkness/lightness of a particular hex color, so as to determine whether
> to use light or dark text above it so that the text doesn't get lost in
> the color beneath.
> 
> Any nudges in the right direction (custom tag, algorithm, etc.) would
> simply rock.

I would personally lean more towards complimentary colors than just use
brightness values.

Here's a page that does some of this: they provide hex values of Hue at 10
degrees of separation and some rules for generating complimentary colors
using them:

http://www.december.com/html/spec/colorhslhexuse.html

I'm sure they generated them with some algorithm - figuring it out shouldn't
be too hard once you have all the values.

The page also has a lot of links to other color-related pages and such.
Here's another good meta resource:

http://www.bestwebatlanta.com/resources/colors_colours_atlanta_web_designers
..shtml

Jim Davis






~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215357
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: SOT: determining darkness/lightness of hex colors

[Scott Weikert]

Barney Boisvert wrote:

>Look for an RGB to HSL or HSB converter.  The L and B stand for
>lightness and brightness respectively.  They're not quite the same,
>but both indicate the value you're looking for.  Just split your hex
>into three letter pairs, convert each to binary to get RGB, and run
>through the converter to get HS(B|L), and check out the B/L value to
>see if it's "light" or "dark",
>  
>
Thanks much Barney!
--Scott

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215356
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFEclipse 1.2

[S . Isaac Dealey]

> Why do we have any error catching tools?
> If we all wrote perfect code we wouldn't
> need them, but at least cf is flexible
> enough to provide them.  Sure we should
> keep our code small, but the ide should
> be able to handle it regardless.  Just
> because you shouldn't run into a problem
> doesn't mean you avoid it.

Umm... yes, yes it does... If a problem is caused by a poor coding
habbit, then I adopt a better coding habbit. The same way that, if I
discover that I'm spending a lot of money on tires as a result of
frequently driving over broken glass, I will try and reduce the amount
of broken glass I drive over. Can I drive over broken glass? Yes. Does
it always puncture the tire? No. Do I ignore the glass in the road
because it may not puncture the tire? No. And sure, I may buy fixaflat
and tires that are advertised as being more puncture resistant, but
I'm not going to bitch to the tire company because the tires don't
last if I pave my driveway with broken glass.

The example of error handling tools in CF isn't a good one... Errors
often occur during normal operation -- this is analogous to fix-aflat
or more puncture resistant tires. Error handling tools are used in
normal operating conditions. Editing a code template that's the size
of an Oxford English Dictionary should not be a normal operating
condition and therefore does not deserve the kind of attention devoted
to tasks performed under normal operating conditions.

Moreover, it's also not something that occurs accidentally like a bug
or glass in the road... you don't look up one morning and say
"wps! that ColdFusion template just ougrew a CD" -- it's something
you have absolute control over at all times, and can easily avoid. It
takes all of a few seconds to slice it up into a couple includes. I'd
much prefer the couple seconds to do that over continuing to struggle
and argue and bitch about the fact that the IDE has problems with it
for hours or days on end. It's a quick, easy, simple and obvious
solution which at the same time means better code. Why fight doing
something that's an inate improvement, has no drawbacks and requires
almost no time to implement? And if you're not fighting it, then you
have no reason to complain about any given IDE having a problem with
the alternative.


s. isaac dealey   954.522.6080
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm




~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215355
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Spell Checker

[Chuck Mason]

If your hosting provider runs a java server then JSpellHTML might work out for 
you (have been using it for years now).  Here's the URL for JSpellHTML: 
http://www.thesolutioncafe.com/jspell.html .  The default page of that site 
lists some other options that might work for you too.  
Cost = $170.

Ben Forta wrote CFX_Spell tool a while back, which might also work for you: 
http://www.emteksys.com/products/cfxspell/ .  
Cost = $200

Regarding open source, if your server supports PHP, you might want to check 
out "Speller" at http://spellerpages.sourceforge.net/.  I reviewed & tested 
it on a Win2k server where it worked fine, then had issues with it on Windows 
2003 -- might be worth your review if your budget is limited.

Good luck!
Chuck




On Tuesday 16 August 2005 5:00 pm, Todd Mathews wrote:
> Does anyone know of an open source or low cost spell checker that works
> with CFMX? The intended usage is to spell check text area contents prior to
> form submission.
>
> thx
>
>
>
> 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215353
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: SOT: determining darkness/lightness of hex colors

[Barney Boisvert]

Look for an RGB to HSL or HSB converter.  The L and B stand for
lightness and brightness respectively.  They're not quite the same,
but both indicate the value you're looking for.  Just split your hex
into three letter pairs, convert each to binary to get RGB, and run
through the converter to get HS(B|L), and check out the B/L value to
see if it's "light" or "dark",

cheers,
barneyb

On 8/16/05, Scott Weikert <[EMAIL PROTECTED]> wrote:
> Hey gang,
> 
> I've done some Googling on this but haven't found anything helpful.
> 
> I'm looking for a way to determine, for lack of better terms, the
> darkness/lightness of a particular hex color, so as to determine whether
> to use light or dark text above it so that the text doesn't get lost in
> the color beneath.
> 
> Any nudges in the right direction (custom tag, algorithm, etc.) would
> simply rock.
> 
> Thanks much -
> --Scott
> 
> 

-- 
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 50 invites.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215354
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Reading from another web page

[Brett Barnhart]

Thanks!

As I mentioned.. this is a service that I subscribe to, so I am expected to 
automate this.

>CFHTTP
>
>and beware the legal issues of such screen scraping ;-)
>
>Bryan Stevenson B.Comm.
>VP & Director of E-Commerce Development
>Electric Edge Systems Group Inc.
>phone: 250.480.0642
>fax: 250.480.1264
>cell: 250.920.8830
>e-mail: [EMAIL PROTECTED]
>web: www.electricedgesystems.com

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215352
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: REPOST: webservices and optional numeric arguments

[Bryan Stevenson]

From: "Deanna Schneider"


>I think that you have to allow the cfargument to be of type string or
> type any, and then do additional checks to determine if it is numeric
> or blank (ie null) within your code.

Which is what I'm trying to find a way around as that approach sucks IMHO 
;-)

The problem is the consumer of the web service may pass in a string instead 
of a proper numeric valuethe method returns an empty recordset because 
the query fails to find any records with a numeric ID of "foo" and the 
consumer has no idea why.  To make it even worse the consumer may be reading 
the auto-generated documentation for that web service and see that a 
"string" is the datatype when it's really supposed to be numeric.

That's just bad ;-)

Can anybody tell me why this is how web services behave? or have a solution 
to the issue above?

TIA

Cheers

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com 


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215351
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Refactoring a query WAS RE: Change a queries orientation.

[Ian Skinner]

Any of you SQL experts/gurus care to try a round of pro bono query 
optimization.  After a lot of trial and error and tinkering I was able to write 
this query that gets the results I need, but boy is it convoluted and long.  My 
gut says there is a better way to do this, but I have no idea where to start.  
For reference, this is a CFMX6.1 template working against an Oracle database.


SELECT DISTINCT
aDate,
AREA,
(   SELECT 
SCHED

FROM (SELECT
REC_APPT_DATE AS aDATE,
REC_APPT_AREA AS AREA,
REC_APPT_CNTTYP AS TYPE,
SUM(REC_APPT_SCHED) AS SCHED

FROM
SOSUSR.REC_SCHED_APPT

WHERE
REC_APPT_DATE BETWEEN  
AND 

GROUP BY
REC_APPT_DATE,
REC_APPT_AREA,
REC_APPT_CNTTYP


UNION

SELECT
REC_MOB_DATE AS aDATE,
REC_MOB_AREA AS AREA,
REC_MOB_CNTTYP AS TYPE,
SUM(REC_MOB_PROJDRW) AS SCHED

FROM
SOSUSR.REC_MOB_SCHED

WHERE
REC_MOB_DATE BETWEEN  
AND 

GROUP BY
REC_MOB_DATE,
REC_MOB_AREA,
REC_MOB_CNTTYP

) FOO

WHERE
FOO.AREA = T.AREA AND
FOO.aDATE = T.aDATE AND
TYPE = 'AP'
) AP,

(   SELECT 
SCHED

FROM (SELECT
REC_APPT_DATE AS aDATE,
REC_APPT_AREA AS AREA,
REC_APPT_CNTTYP AS TYPE,
SUM(REC_APPT_SCHED) AS SCHED

FROM
SOSUSR.REC_SCHED_APPT

WHERE
REC_APPT_DATE BETWEEN  
AND 

GROUP BY
REC_APPT_DATE,
REC_APPT_AREA,
REC_APPT_CNTTYP


UNION

SELECT
REC_MOB_DATE AS aDATE,
REC_MOB_AREA AS AREA,
REC_MOB_CNTTYP AS TYPE,
SUM(REC_MOB_PROJDRW) AS SCHED

FROM
SOSUSR.REC_MOB_SCHED

WHERE
REC_MOB_DATE BETWEEN  
AND 

GROUP BY
REC_MOB_DATE,
REC_MOB_AREA,
REC_MOB_CNTTYP

) FOO

WHERE
FOO.AREA = T.AREA AND
FOO.aDATE = T.aDATE AND
TYPE = 'PL'
) PL,

(   SELECT 
SCHED

FROM (SELECT
REC_APPT_DATE AS aDATE,
REC_APPT_AREA AS AREA,
REC_APPT_CNTTYP AS TYPE,
SUM(REC_APPT_SCHED) AS SCHED

FROM
SOSUSR.REC_SCHED_APPT

WHERE
REC_APPT_DATE BETWEEN  
AND 

GROUP BY
REC_APPT_DATE,
REC_APPT_AREA,
REC_APPT_CNTTYP


UNION

SELECT
REC_MOB_DATE AS aDATE,
REC_MOB_AREA AS AREA,
REC_MOB_CNTTYP AS TYPE,
SUM(REC_MOB_PROJDRW) AS SCHED

FROM
SOSUSR.REC_MOB_SCHED

WHERE
REC_MOB_DATE BETWEEN  
AND 

GROUP BY
REC_MOB_DATE,
REC_MOB_AREA,
REC_MOB_CNTTYP

) FOO

WHERE
FOO.AREA = T.AREA AND
FOO.aDATE = T.aDATE AND
TYPE = 'WB'
) WB

FROM (SELECT
REC_APPT_AREA AS AREA,
REC_APPT_CNTTYP AS TYPE,
REC_APPT_SCHED AS SCHED,

REC_APPT_DATE AS aDATE

FROM
SOSUSR.REC_SCHED_APPT

WHERE
REC_APPT_DATE BETWEEN  
AND 

UNION

SELECT
REC_MOB_AREA AS AREA,
REC_MOB_CNTTYP AS TYPE,
REC_MOB_PROJDRW AS SCHED,

REC_MOB_DATE AS aDATE

FROM
SOSUSR.REC_MOB_SCHED

WHERE
REC_MOB_DATE BETWEEN  
AND 
) T

ORDER BY
aDate,
AREA



--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
 
"C code. C code run. Run code run. Please!"
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215350
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Spell Checker

[Barney Boisvert]

We use ASpell and HTMLArea's SpellChecker plug (though modified to
work without HTMLArea) with great success.

cheers,
barneyb

On 8/16/05, Todd Mathews <[EMAIL PROTECTED]> wrote:
> Does anyone know of an open source or low cost spell checker that works with
> CFMX? The intended usage is to spell check text area contents prior to form
> submission.
> 
> thx
> 
> 
-- 
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 50 invites.

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215349
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Change a queries orientation.

[Ian Skinner]

You may have to truncate the date column.  You're looking to group it by dates, 
yes? Oracle automagically stores times in there, too.

Well, not these dates they are not stored as dates; they are stored as integers 
in the format mmdd.  Let me tell how many times I have battled my head 
against that!  Especially the time fields that are also integers in the format 
of hhmm, 24 hour clock; except that it is not padded so midnight is 0 and 1 
minute past midnight is 1.  1am is 100, so until 10am the field will have less 
then 4 digits.  UHG!!!



--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
 
"C code. C code run. Run code run. Please!"
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215348
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CSS Help

[Andy]

Unless someone complains, keep it up.  It helps those of us who might be
considering CSS or have some problems that we've just given up on.

Andy

-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 16, 2005 1:55 PM
To: CF-Talk
Subject: Re: CSS Help

Nope, doesn't work.

I'll stop posting on this thread here... I'm trying to subscribe to a 
css discussion list =)

Rick

Tangorre, Michael wrote:
>>From: Rick Root [mailto:[EMAIL PROTECTED] 
>>where is that space coming from?
> 
> 
> Try something out...
> 
> Make this your first style declaration. Then refresh.
> 
> *{
>padding: 0px;
>margin: 0px;
> }
> 
> Looks like a padding issue...
> 
> 
> 



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215340
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

SOT: determining darkness/lightness of hex colors

[Scott Weikert]

Hey gang,

I've done some Googling on this but haven't found anything helpful.

I'm looking for a way to determine, for lack of better terms, the 
darkness/lightness of a particular hex color, so as to determine whether 
to use light or dark text above it so that the text doesn't get lost in 
the color beneath.

Any nudges in the right direction (custom tag, algorithm, etc.) would 
simply rock.

Thanks much -
--Scott

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215346
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Month and Day Only in Query

[Dawson, Michael]

In our AS400 DB2 table, we have our dates stored in a canonical format
such as MMDD or 20050816.
 
I need to pull a list of birthdays, not actual birthdates, and excluding
years, from this table.  In other words, I need to get all birthdays for
0816 through 0822.  This is easy enough when the dates do not exceed
December 31.
 
But, let's say today is Dec 26, or "1226" and I need to pull the next
few days that may overlap into the next year.  Let's say that the end
date is Jan 03, or "0103".
 
In addition to pulling the correct records, regardless of year, I need
to make sure they sort properly.  In a calendar, if today is Dec 26,
then 1226 comes before 0103.
 
My latest solution to this is to create a list of dates, in the proper
order, and then query on those values.

My list would look like:  1226,1227,1228,1229,1230,1231,0101,0102,0102.
 
My query looks like:

WHERE SUBSTRING(pprdob, 5, 4) IN (#cfquery_param_list_goes_here#)


I can select the correct records this way, however, the sort is not
correct.  I don't want to sort on the list because that would throw off
my order.  I can't add the numeric birthday field to the query because
that would throw off my GROUP BY clause.  (DB2 will not allow sorting on
a column *unless* that column is specified in the SELECT list.)

So, my next idea is to take the same list of dates, which are already in
the correct order, and then loop over the query and somehow find the
right value to display.

Does anyone have any better suggestions?

M!ke

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215339
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Spell Checker

[Todd Mathews]

Does anyone know of an open source or low cost spell checker that works with
CFMX? The intended usage is to spell check text area contents prior to form
submission.

thx



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215345
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFEclipse 1.2

[Russ Michaels]

I once had DWMX totally kill a large CFM file. Every time it saved the file
it saved it as junk, every single time.
I was lucky that I could copy the code out of DWMX and paste into homesite
or I would have lost a lot of work.
So don't trust DWMX with big files either.

Russ


-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED] 
Sent: 16 August 2005 20:53
To: CF-Talk
Subject: Re: CFEclipse 1.2

syntactical waste.
code bloat whatever.

2000 lines of logic isnt CRAZY.

i understand not recommended, but an IDE should have some fuzzy line where
its performance gets dumb, and under that its ok.

thats wrong.

homesite works fine with the file.
dreamweaver works fine with the file.
cfeclipse doesnt.

its the IDE.
tw

On 8/16/05, S. Isaac Dealey <[EMAIL PROTECTED]> wrote:
> > ok.  so that makes a lot of sense. sure.
> > conform your development to the editor...
> > SURE!
> 
> > homesite has no problems.
> 
> > sounds like the editor.
> 
> > tw
> 
> Well no... that's not why I advocate not making files larger than 500 
> lines... I advocate not making these hideously large files because 
> they cause all sorts of other problems, and so... given that being the 
> case, the issue of an IDE having a problem with a file over 500 lines 
> imo should be a moot issue, since you should never run into that 
> problem anyway.
> 
> To put it another way... I don't complain about the fact that I may 
> run into problems sending 10MB+ files via my email client because imo, 
> I shouldn't be trying to use my email client to do that. So by that 
> same token, why would I complain that an IDE has a problem keeping up 
> with a lousy, monolithic, likely improbable to maintain file that I 
> shouldn't be creating in the first place?
> 
> Admittedly, I also write a lot of templates < 10 lines... although 
> these have never caused me any problems.
> 
> I probably do have one or two files that break that rule -- I know I 
> have a few CFC's in the framework that are larger (I don't recall off 
> the top of my head if any are over 500 lines), but by no means are 
> they ever mulitple thousdands of lines. CFC's are a bit of a minor 
> exception in some cases because you can get a lot of reuseable 
> functionality in a single template but barring that, the larger a 
> template becomes, the more problematic it is for one reason or 
> another. If it's not the IDE, then it _will_ be something else. In 
> most cases I see a lot of copy-paste coding, lack of encapsulation (or 
> cohesion if you like), and or simple syntactical waste in larger 
> templates.
> 
> 
> s. isaac dealey   954.522.6080
> new epoch : isn't it time for a change?
> 
> add features without fixtures with
> the onTap open source framework
> 
> http://www.fusiontap.com
> http://coldfusion.sys-con.com/author/4806Dealey.htm
> 
> 
> 
> 
> 



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215341
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFEclipse 1.2

[Russ Michaels]

I once had DWMX totally kill a large CFM file. Every time it saved the file
it saved it as junk, every single time.
I was lucky that I could copy the code out of DWMX and paste into homesite
or I would have lost a lot of work.
So don't trust DWMX with big files either.

Russ


-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED] 
Sent: 16 August 2005 20:53
To: CF-Talk
Subject: Re: CFEclipse 1.2

syntactical waste.
code bloat whatever.

2000 lines of logic isnt CRAZY.

i understand not recommended, but an IDE should have some fuzzy line where
its performance gets dumb, and under that its ok.

thats wrong.

homesite works fine with the file.
dreamweaver works fine with the file.
cfeclipse doesnt.

its the IDE.
tw

On 8/16/05, S. Isaac Dealey <[EMAIL PROTECTED]> wrote:
> > ok.  so that makes a lot of sense. sure.
> > conform your development to the editor...
> > SURE!
> 
> > homesite has no problems.
> 
> > sounds like the editor.
> 
> > tw
> 
> Well no... that's not why I advocate not making files larger than 500 
> lines... I advocate not making these hideously large files because 
> they cause all sorts of other problems, and so... given that being the 
> case, the issue of an IDE having a problem with a file over 500 lines 
> imo should be a moot issue, since you should never run into that 
> problem anyway.
> 
> To put it another way... I don't complain about the fact that I may 
> run into problems sending 10MB+ files via my email client because imo, 
> I shouldn't be trying to use my email client to do that. So by that 
> same token, why would I complain that an IDE has a problem keeping up 
> with a lousy, monolithic, likely improbable to maintain file that I 
> shouldn't be creating in the first place?
> 
> Admittedly, I also write a lot of templates < 10 lines... although 
> these have never caused me any problems.
> 
> I probably do have one or two files that break that rule -- I know I 
> have a few CFC's in the framework that are larger (I don't recall off 
> the top of my head if any are over 500 lines), but by no means are 
> they ever mulitple thousdands of lines. CFC's are a bit of a minor 
> exception in some cases because you can get a lot of reuseable 
> functionality in a single template but barring that, the larger a 
> template becomes, the more problematic it is for one reason or 
> another. If it's not the IDE, then it _will_ be something else. In 
> most cases I see a lot of copy-paste coding, lack of encapsulation (or 
> cohesion if you like), and or simple syntactical waste in larger 
> templates.
> 
> 
> s. isaac dealey   954.522.6080
> new epoch : isn't it time for a change?
> 
> add features without fixtures with
> the onTap open source framework
> 
> http://www.fusiontap.com
> http://coldfusion.sys-con.com/author/4806Dealey.htm
> 
> 
> 
> 
> 



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215342
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Reading from another web page

[Bryan Stevenson]

CFHTTP

and beware the legal issues of such screen scraping ;-)

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215343
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: SQL help (updated)

[Deanna Schneider]

You realize that this is essentially a db design issue - right? The
table shouldn't be holding lists of numbers - there should be a join
table that does that job. Right?

On 8/16/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Okay, I still need help, but I've resolve part of my problem.  I'm able now 
> to have the list of ID numbers in one field by themselves.  So, my new field 
> value (MyColumn) looks like this:
> 
> '5,2,3,4,45,7'
>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215336
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Change a queries orientation.

[Deanna Schneider]

You may have to truncate the date column.  You're looking to group it
by dates, yes? Oracle automagically stores times in there, too.

So:
SELECT trunc(date)...

GROUP BY trunc(date)

On 8/16/05, Ian Skinner <[EMAIL PROTECTED]> wrote:
> That created the columns but it didn't combine the rows.
> 
> I got results like this:
> > DATE LOC AP  PL  WB
> >  --- --- --- ---
> > 20050706 NS  14  0   0
> > 20050706 NS  0   1   0
> > 20050706 NS  0   0   21
> > 20050706 SM  104 0   0
> > 20050706 SM  0   39  0
> > 20050706 SM  0   0   291
> 
> Not the desired two rows with three values each:
> > DATE LOC AP  PL  WB
> >  --- --- --- ---
> > 20050706 NS  14  1   21
> > 20050706 SM  104 39  291
> 
> --
> Ian Skinner
> Web Programmer
> BloodSource
> www.BloodSource.org
> Sacramento, CA
> 
> "C code. C code run. Run code run. Please!"
> - Cynthia Dunning
> 
> Confidentiality Notice:  This message including any
> attachments is for the sole use of the intended
> recipient(s) and may contain confidential and privileged
> information. Any unauthorized review, use, disclosure or
> distribution is prohibited. If you are not the
> intended recipient, please contact the sender and
> delete any copies of this message.
> 
> 
> 
> 
> 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215338
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFEclipse 1.2

[Kazmierczak, Kevin]

Advocating small files is one thing, but saying " the issue of an IDE
having a problem with a file over 500 lines imo should be a moot issue,
since you should never run into that problem anyway." is ridiculous.  

Why do we have any error catching tools?  If we all wrote perfect code
we wouldn't need them, but at least cf is flexible enough to provide
them.  Sure we should keep our code small, but the ide should be able to
handle it regardless.  Just because you shouldn't run into a problem
doesn't mean you avoid it.

I agree that large files are a pain to work with, but they will never be
totally avoided and IDE's should be flexible enough to handle them.

Kevin
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 16, 2005 3:35 PM
To: CF-Talk
Subject: Re: CFEclipse 1.2

> ok.  so that makes a lot of sense. sure.
> conform your development to the editor...
> SURE!

> homesite has no problems.

> sounds like the editor.

> tw

Well no... that's not why I advocate not making files larger than 500
lines... I advocate not making these hideously large files because
they cause all sorts of other problems, and so... given that being the
case, the issue of an IDE having a problem with a file over 500 lines
imo should be a moot issue, since you should never run into that
problem anyway.

To put it another way... I don't complain about the fact that I may
run into problems sending 10MB+ files via my email client because imo,
I shouldn't be trying to use my email client to do that. So by that
same token, why would I complain that an IDE has a problem keeping up
with a lousy, monolithic, likely improbable to maintain file that I
shouldn't be creating in the first place?

Admittedly, I also write a lot of templates < 10 lines... although
these have never caused me any problems.

I probably do have one or two files that break that rule -- I know I
have a few CFC's in the framework that are larger (I don't recall off
the top of my head if any are over 500 lines), but by no means are
they ever mulitple thousdands of lines. CFC's are a bit of a minor
exception in some cases because you can get a lot of reuseable
functionality in a single template but barring that, the larger a
template becomes, the more problematic it is for one reason or
another. If it's not the IDE, then it _will_ be something else. In
most cases I see a lot of copy-paste coding, lack of encapsulation (or
cohesion if you like), and or simple syntactical waste in larger
templates.


s. isaac dealey   954.522.6080
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm






~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215337
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: SQL help (updated)

[Jochem van Dieten]

[EMAIL PROTECTED] wrote:
> Okay, I still need help, but I've resolve part of my problem.  I'm able now 
> to have the list of ID numbers in one field by themselves.  So, my new field 
> value (MyColumn) looks like this:
> 
> '5,2,3,4,45,7'
> 
> I still need a way using Query of Queries to extract only the records that 
> have the 'idnumber' in that list.  I've tried:
> 
>   SELECT *
>   FROM AllResults
>   WHERE #idnumber# in MyColumn

SELECT *
FROM AllResults
WHERE ',' & MyColumn & ',' LIKE '%#idnumber#%'

Jochem

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215335
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Reading from another web page

[Brett Barnhart]

I subscribe to a service that I pass an address and it displays the addresses 
Lat and Long.

Currently, I manually grab these coords and update a table, but I'd really like 
to automate this process.

I know there has got to be a way in CF to grab the contents of a web page and 
then parse it out.

For example...

I'll call www.xyz.com?address=someaddress

it then throws up a web page that has

|lat|long|

How can I automatically read in the values of that web page? (once it is in, I 
know how to parse it out).

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215334
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CFEclipse 1.2

[S . Isaac Dealey]

> syntactical waste.
> code bloat whatever.

> 2000 lines of logic isnt CRAZY.

I really hope I never have to work with any of those files...

I would certainly never do so by choice.

What task is so irreducibly complex that it can't be done in less than
2000 lines?



s. isaac dealey   954.522.6080
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215333
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Offline application

[Larry Lyons]

>I have a customer who would like an application developed that I would like
>to do in coldfusion, but they insist that it be built for their local
>desktop and then the data transferred via disk so that another individual
>who has no access to the internet can work on it.  I do not need to worry
>about syncing the data as it is a mom or daughter team that work on the app.
>
>Is there something like coldfusion I could use for an offline app.  I was
>just going to use acess for data storage.  I do not want develop a access
>front end. This has always been a pain
>
>Any direction is much appreciated
>
>Sincerely,
> 
>Kurt Kaptein
> 

Kurt you may want to look at Dick Applebaum's CFAnywhere project - if its still 
going. He was able to get blue dragon to run off a CD.

http://www.houseoffusion.com/cf_lists/messages.cfm/forumid:4/Threadid:32814#164595

larry
--
Larry C. Lyons
Web Analyst
BEI Resources
American Type Culture Collection
email: llyons(at)atcc(dot)org
tel: 703.365.2700.2678
--

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215332
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: N-Selects Related

[Ewok]

Duh... good point

-Original Message-
From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 16, 2005 5:41 PM
To: CF-Talk
Subject: RE: N-Selects Related

Jason,

Don't set the multiple attribute--just set the "size" attribute to something
like 10. The "multiple" attribute allows multiple items to be selected, the
size attribute controls how big the box is. 

The code is designed w/the expectation that the selectedIndex will have a
non-negative value (which a single select element always does.) A multiple
select box defaults to having a negative selectedIndex.

-Dan

>-Original Message-
>From: Jason Brown [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, August 16, 2005 8:47 AM
>To: CF-Talk
>Subject: N-Selects Related
>
>I went out to PengoWorks.com
>
>http://www.pengoworks.com/workshop/js/gateway/index.cfm#downloads
>
>and downloaded their N-Selects Related code. The code works great and
>my page is functioning perfectly. However, rather than having drop-down
>lists I would like Menu lists (display all objects without needing to
>click a drop-down button). The problem is that when I convert the
>drop-down lists to Menu lists they no longer work. There are four files
>that make this code work:
>
>gateway.js
>nRelatedSelect.htm
>nRelatedSelect_gw.cfm
>zipcodes.mdb
>
>Can anyone tell me how to correct this issue so I can convert the
>drop-down lists to menu lists?
>
>Thanks.
>
>
>**
>Electronic Mail is not secure, may not be read every day, and should not be
>used for urgent or sensitive issues.
>
>



~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215331
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

OT: SQL Error 1064

[Jason Manaigre]

Hi everyone first post and unfortunately it had to be OT... Here's the
scoop...

Real new to SQL, currently reading through CF7 Web application
construction kit and the install script for the MySQL data for this book
is throwing me this error: 

You have an error (1064) in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near '; 
USE ows; 


# 
# Create the tables # 
#' at line 4 



Running MySQL server ver. 4.1.12a-nt via TCP/IP 

I get this error when using the MySQL Query Browser, also tried
installing the script via command line and it throws a few warnings as
well. 

Is there something simple I'm not seeing here, or can someone point me
in the right direction? 

Thanks people. 

The script is pasted bellow (I cut off the population portion), sorry
for the length.

Jay


_ 

### 
# Create and use database # 
### 
CREATE DATABASE ows; 
USE ows; 


# 
# Create the tables # 
# 

# Create Actors table 
CREATE TABLE Actors ( 
ActorID int NOT NULL auto_increment, 
NameFirst char(50) NOT NULL, 
NameLast char(50) NOT NULL, 
Age smallint(6) NOT NULL, 
NameFirstReal char(50) NOT NULL, 
NameLastReal char(50) NOT NULL, 
AgeReal smallint(6) NOT NULL, 
IsEgomaniac bool NOT NULL, 
IsTotalBabe bool NOT NULL, 
Gender char(1) NOT NULL, 
PRIMARY KEY (ActorID) 
) TYPE=MyISAM; 

# Create Contacts table 
CREATE TABLE Contacts ( 
ContactID int NOT NULL auto_increment, 
FirstName char(50) NOT NULL, 
LastName char(50) NOT NULL, 
Address char(100) NULL, 
City char(50) NULL, 
State char(5) NULL, 
Zip char(10) NULL, 
Country char(50) NULL, 
Email char(100) NULL, 
Phone char(50) NULL, 
UserLogin char(50) NULL, 
UserPassword char(50) NULL, 
MailingList bool NOT NULL DEFAULT 0, 
UserRoleID bigint NULL, 
PRIMARY KEY (ContactID) 
) TYPE=MyISAM; 

# Create Directors table 
CREATE TABLE Directors ( 
DirectorID int NOT NULL auto_increment, 
FirstName char(50) NOT NULL, 
LastName char(50) NOT NULL, 
PRIMARY KEY (DirectorID) 
) TYPE=MyISAM; 

# Create Expenses table 
CREATE TABLE Expenses ( 
ExpenseID int NOT NULL auto_increment, 
FilmID int NOT NULL, 
ExpenseAmount real NOT NULL, 
Description char(100) NOT NULL, 
ExpenseDate date NOT NULL, 
PRIMARY KEY (ExpenseID) 
) TYPE=MyISAM; 

# Create Films table 
CREATE TABLE Films ( 
FilmID int NOT NULL auto_increment, 
MovieTitle char(255) NOT NULL, 
PitchText char(100) NOT NULL, 
AmountBudgeted real NULL, 
RatingID int NULL, 
Summary text NULL, 
ImageName char(50) NULL, 
DateInTheaters date NULL, 
PRIMARY KEY (FilmID) 
) TYPE=MyISAM; 

# Create FilmsActors table 
CREATE TABLE FilmsActors ( 
FARecID int NOT NULL auto_increment, 
FilmID int NOT NULL, 
ActorID int NOT NULL, 
IsStarringRole bool NOT NULL, 
Salary real NOT NULL, 
PRIMARY KEY (FARecID) 
) TYPE=MyISAM; 

# Create FilmsDirectors table 
CREATE TABLE FilmsDirectors ( 
FDRecID int NOT NULL auto_increment, 
FilmID int NOT NULL, 
DirectorID int NOT NULL, 
Salary real NOT NULL, 
PRIMARY KEY (FDRecID) 
) TYPE=MyISAM; 

# Create FilmsRatings table 
CREATE TABLE Filmsratings ( 
RatingID int NOT NULL auto_increment, 
Rating char(50) NOT NULL, 
PRIMARY KEY (RatingID) 
) TYPE=MyIsam; 

# Create Merchandise table 
CREATE TABLE Merchandise ( 
MerchID int NOT NULL auto_increment, 
FilmID int NOT NULL, 
MerchName char(50) NOT NULL, 
MerchDescription char(100) NULL, 
MerchPrice real NULL, 
ImageNameSmall char(50) NULL, 
ImageNameLarge char(50) NULL, 
PRIMARY KEY (MerchID) 
) TYPE=MyISAM; 

# Create MerchandiseOrders table 
CREATE TABLE MerchandiseOrders ( 
OrderID int NOT NULL auto_increment, 
ContactID int NOT NULL, 
OrderDate date NOT NULL, 
ShipAddress char(100) NULL, 
ShipCity char(50) NULL, 
ShipState char(5) NULL, 
ShipZip char(10) NULL, 
ShipCountry char(50) NULL, 
ShipDate date NULL, 
PRIMARY KEY (OrderID) 
) TYPE=MyISAM; 

# Create MerchandiseOrdersItems table 
CREATE TABLE MerchandiseOrdersItems ( 
OrderItemID int NOT NULL auto_increment, 
OrderID int NOT NULL, 
ItemID int NOT NULL, 
OrderQty int NOT NULL, 
ItemPrice real NOT NULL, 
PRIMARY KEY (OrderItemID) 
) TYPE=MyISAM; 

# Create UserRoles table 
CREATE TABLE UserRoles ( 
UserRoleID int NOT NULL auto_increment, 
UserRoleName char(20) NULL, 
UserRoleFunction char(75) NULL, 
PRIMARY KEY (UserRoleID) 
) TYPE=MyISAM; 

--SNIP--

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215329
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CF-Talk: Digest every hour

[Tony Weeg]

Gabriel.

It simply means that its a overused word to describe something.
If we were talking cars, one of the buzzwords for cars today is "Hybrid".
If we were talking web communications technologies, a buzzword would
be "Webservices, and XML"

make sense?

tony



On 8/16/05, Gabriel Bulfon <[EMAIL PROTECTED]> wrote:
> Sorry, what is the meaning of buzzword ?
> 
> Gabriel Bulfon
> Email:[EMAIL PROTECTED]
> 
> > -Original Message-
> > From: Damien McKenna [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, August 09, 2005 4:18 PM
> > To: CF-Talk
> > Subject: RE: CF-Talk: Digest every hour
> >
> > > -Original Message-
> > > From: Dave Watts [mailto:[EMAIL PROTECTED]
> > >
> > > Well, "AJAX" is nothing more than a buzzword. People have
> > been writing
> > > DHTML interfaces for years that do essentially the same thing.
> >
> > 
> > "DHTML" is a buzzword and is nothing more than JS, CSS and
> > DOM wrapped up together.
> >
> > --
> > Damien McKenna - Web Developer -
> > [EMAIL PROTECTED] The Limu Company -
> > http://www.thelimucompany.com/ - 407-804-1014 #include 
> >
> >
> >
> 
> 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215330
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: N-Selects Related

[Dan G. Switzer, II]

Jason,

Don't set the multiple attribute--just set the "size" attribute to something
like 10. The "multiple" attribute allows multiple items to be selected, the
size attribute controls how big the box is. 

The code is designed w/the expectation that the selectedIndex will have a
non-negative value (which a single select element always does.) A multiple
select box defaults to having a negative selectedIndex.

-Dan

>-Original Message-
>From: Jason Brown [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, August 16, 2005 8:47 AM
>To: CF-Talk
>Subject: N-Selects Related
>
>I went out to PengoWorks.com
>
>http://www.pengoworks.com/workshop/js/gateway/index.cfm#downloads
>
>and downloaded their N-Selects Related code. The code works great and
>my page is functioning perfectly. However, rather than having drop-down
>lists I would like Menu lists (display all objects without needing to
>click a drop-down button). The problem is that when I convert the
>drop-down lists to Menu lists they no longer work. There are four files
>that make this code work:
>
>gateway.js
>nRelatedSelect.htm
>nRelatedSelect_gw.cfm
>zipcodes.mdb
>
>Can anyone tell me how to correct this issue so I can convert the
>drop-down lists to menu lists?
>
>Thanks.
>
>
>**
>Electronic Mail is not secure, may not be read every day, and should not be
>used for urgent or sensitive issues.
>
>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215328
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CF-Talk: Digest every hour

[Gabriel Bulfon]

Sorry, what is the meaning of buzzword ?

Gabriel Bulfon
Email:[EMAIL PROTECTED] 

> -Original Message-
> From: Damien McKenna [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, August 09, 2005 4:18 PM
> To: CF-Talk
> Subject: RE: CF-Talk: Digest every hour
> 
> > -Original Message-
> > From: Dave Watts [mailto:[EMAIL PROTECTED]
> >
> > Well, "AJAX" is nothing more than a buzzword. People have 
> been writing 
> > DHTML interfaces for years that do essentially the same thing.
> 
> 
> "DHTML" is a buzzword and is nothing more than JS, CSS and 
> DOM wrapped up together.
> 
> --
> Damien McKenna - Web Developer - 
> [EMAIL PROTECTED] The Limu Company - 
> http://www.thelimucompany.com/ - 407-804-1014 #include 
> 
> 
> 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215323
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: OF-Test

[Gabriel Bulfon]

??

Gabriel Bulfon
Email:[EMAIL PROTECTED] 

> -Original Message-
> From: Dan O'Keefe [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, August 09, 2005 6:07 AM
> To: CF-Talk
> Subject: Re: OF-Test
> 
> novato
> 
> On 8/5/05, Rey Bango <[EMAIL PROTECTED]> wrote:
> > Welcome back Gabriel. Que lo difrutas!
> > 
> > Rey...
> > 
> > Gabriel Bulfon wrote:
> > > Hi all guys.  I am back with CF !
> > >
> > > regards
> > >
> > > Gabriel Bulfon
> > > Email:[EMAIL PROTECTED]
> > >
> > >
> > >
> > 
> > 
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215324
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Sorting Struct

[Brett Barnhart]

>In what form are the search results originally - a query?

Yes

I ended up saving the results to a table and then sorting them there.

I tried SortStruct... but it kept giving me an error about a complex variable.

Thanks for the help and I'll check out the book. :)

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215326
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

webservices and numeric arguments

[Bryan Stevenson]

OK...so if the "required" attribute is ignored in CFARGUMENTs in web services, 
how are folks handling this situation:??

Method A has arg1 that is "technically" not required and is numeric.

If the "required" attribute is ignored, then Method A is expecting a numeric 
value for arg1.but if you want arg1 to be optional and someone passes a 
blank the call will fail because  ablank is not numeric!!  I know I could tell 
service consumers to pass a zero if they want to skip that attribute...but that 
is a bit limp...

Am I missing something here or is this a really stupid setup? ;-)

TIA

Cheers

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215325
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CFEclipse 1.2

[Michael Traher]

Hi Ken, Did you pick up on the earlier mention that the tag closing only 
works with eclipse 3.1 and not on earlier versions? 
Mike.

 On 8/16/05, Ken Ferguson <[EMAIL PROTECTED]> wrote: 
> 
> No, but then I avoid even opening a 74 line file in DW. I don't use it,
> EVER, for ANY reason. I have given DW it fair consideration on a couple
> of occasions and have come to the conclusion that I'd rather use crayons
> and tablet paper. Anyway, for me, the 7400 line file worked just fine in
> both CFE and HomeSite+. Another point of interest is that I combined a
> whole bunch of cfc's into one huge 5000+ line cfc and opened it in CFE.
> Not only did it have no trouble with the file, but the way the functions
> are all collapsed by default is very, very cool. My only issue is the
> closing tag problem and if I can get past that, I'll use CFE exclusively.
> 
> --Ferg
> 
> 
> Massimo, Tiziana e Federica wrote:
> 
> >>>Yeah... 7400 is too long I think.. beyond a few hundred I get
> >>>a headache.
> >>>
> >>>
> >>With the new code collapsing in DW8 it won't be a problem anymore ;-)
> >>
> >>
> >
> >Have you ever tried opening a 7400 lines file in DW? I doubt it would be 
> a
> >pleasant experience :-))
> >
> >
> >Massimo Foti
> >Tools for ColdFusion and Dreamweaver developers:
> >http://www.massimocorner.com
> >
> >
> >
> >
> >
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215321
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CFEclipse 1.2

[Tony Weeg]

syntactical waste.
code bloat whatever.

2000 lines of logic isnt CRAZY.

i understand not recommended, but an IDE should have some fuzzy line where
its performance gets dumb, and under that its ok.

thats wrong.

homesite works fine with the file.
dreamweaver works fine with the file.
cfeclipse doesnt.

its the IDE.
tw

On 8/16/05, S. Isaac Dealey <[EMAIL PROTECTED]> wrote:
> > ok.  so that makes a lot of sense. sure.
> > conform your development to the editor...
> > SURE!
> 
> > homesite has no problems.
> 
> > sounds like the editor.
> 
> > tw
> 
> Well no... that's not why I advocate not making files larger than 500
> lines... I advocate not making these hideously large files because
> they cause all sorts of other problems, and so... given that being the
> case, the issue of an IDE having a problem with a file over 500 lines
> imo should be a moot issue, since you should never run into that
> problem anyway.
> 
> To put it another way... I don't complain about the fact that I may
> run into problems sending 10MB+ files via my email client because imo,
> I shouldn't be trying to use my email client to do that. So by that
> same token, why would I complain that an IDE has a problem keeping up
> with a lousy, monolithic, likely improbable to maintain file that I
> shouldn't be creating in the first place?
> 
> Admittedly, I also write a lot of templates < 10 lines... although
> these have never caused me any problems.
> 
> I probably do have one or two files that break that rule -- I know I
> have a few CFC's in the framework that are larger (I don't recall off
> the top of my head if any are over 500 lines), but by no means are
> they ever mulitple thousdands of lines. CFC's are a bit of a minor
> exception in some cases because you can get a lot of reuseable
> functionality in a single template but barring that, the larger a
> template becomes, the more problematic it is for one reason or
> another. If it's not the IDE, then it _will_ be something else. In
> most cases I see a lot of copy-paste coding, lack of encapsulation (or
> cohesion if you like), and or simple syntactical waste in larger
> templates.
> 
> 
> s. isaac dealey   954.522.6080
> new epoch : isn't it time for a change?
> 
> add features without fixtures with
> the onTap open source framework
> 
> http://www.fusiontap.com
> http://coldfusion.sys-con.com/author/4806Dealey.htm
> 
> 
> 
> 
> 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215320
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: REPOST: webservices and optional numeric arguments

[Deanna Schneider]

I think that you have to allow the cfargument to be of type string or
type any, and then do additional checks to determine if it is numeric
or blank (ie null) within your code.

On 8/16/05, Bryan Stevenson <[EMAIL PROTECTED]> wrote:
> Sorry if this post gets doubled up...just not seeing the original post coming 
> through ;-)
> 
> OK...so if the "required" attribute is ignored in CFARGUMENTs in web 
> services, how are folks handling this situation:??
> 
> Method A has arg1 that is "technically" not required and is numeric.
> 
> If the "required" attribute is ignored, then Method A is expecting a numeric 
> value for arg1.but if you want arg1 to be optional and someone passes a 
> blank the call will fail because  ablank is not numeric!!  I know I could 
> tell service consumers to pass a zero if they want to skip that 
> attribute...but that is a bit limp...
> 
> Am I missing something here or is this a really stupid setup? ;-)
> 
> TIA
> 
> Cheers
> 
> Bryan Stevenson B.Comm.
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> phone: 250.480.0642
> fax: 250.480.1264
> cell: 250.920.8830
> e-mail: [EMAIL PROTECTED]
> web: www.electricedgesystems.com
> 
> 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215319
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: bg & myspace

[Charlie Griefer]

On 8/16/05, Calvin Ward <[EMAIL PROTECTED]> wrote:
> I disagree, I think cf-community is too chock full of unrelated stuff to be
> useful to subscribe to for some busy professionals who would have an
> interest in a conversation about technology that is ColdFusion related...

but CF-Talk is supposed to be for technical questions.  A discussion
of specific code differences between ColdFusion and BlueDragon might
be considered on topic.

I don't disagree at all that cf-community has too much unrelated stuff.  

That's why Michael suggested CF-OT ... a happy medium between CF-Talk
(technical) and CF-Community (anything goes) :)

-- 
Charlie Griefer


"...All the world shall be your enemy, Prince with a Thousand Enemies, 
and whenever they catch you, they will kill you. But first they must catch 
you, digger, listener, runner, prince with a swift warning. 
Be cunning and full of tricks and your people shall never be destroyed."

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215318
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CFEclipse 1.2

[S . Isaac Dealey]

> ok.  so that makes a lot of sense. sure.
> conform your development to the editor...
> SURE!

> homesite has no problems.

> sounds like the editor.

> tw

Well no... that's not why I advocate not making files larger than 500
lines... I advocate not making these hideously large files because
they cause all sorts of other problems, and so... given that being the
case, the issue of an IDE having a problem with a file over 500 lines
imo should be a moot issue, since you should never run into that
problem anyway.

To put it another way... I don't complain about the fact that I may
run into problems sending 10MB+ files via my email client because imo,
I shouldn't be trying to use my email client to do that. So by that
same token, why would I complain that an IDE has a problem keeping up
with a lousy, monolithic, likely improbable to maintain file that I
shouldn't be creating in the first place?

Admittedly, I also write a lot of templates < 10 lines... although
these have never caused me any problems.

I probably do have one or two files that break that rule -- I know I
have a few CFC's in the framework that are larger (I don't recall off
the top of my head if any are over 500 lines), but by no means are
they ever mulitple thousdands of lines. CFC's are a bit of a minor
exception in some cases because you can get a lot of reuseable
functionality in a single template but barring that, the larger a
template becomes, the more problematic it is for one reason or
another. If it's not the IDE, then it _will_ be something else. In
most cases I see a lot of copy-paste coding, lack of encapsulation (or
cohesion if you like), and or simple syntactical waste in larger
templates.


s. isaac dealey   954.522.6080
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm




~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215317
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

REPOST: webservices and optional numeric arguments

[Bryan Stevenson]

Sorry if this post gets doubled up...just not seeing the original post coming 
through ;-)

OK...so if the "required" attribute is ignored in CFARGUMENTs in web services, 
how are folks handling this situation:??

Method A has arg1 that is "technically" not required and is numeric.

If the "required" attribute is ignored, then Method A is expecting a numeric 
value for arg1.but if you want arg1 to be optional and someone passes a 
blank the call will fail because  ablank is not numeric!!  I know I could tell 
service consumers to pass a zero if they want to skip that attribute...but that 
is a bit limp...

Am I missing something here or is this a really stupid setup? ;-)

TIA

Cheers

Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215315
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFEclipse 1.2

[Mark A Kruger]

Ken,

I wrote a blog on this very topic last week:

http://mkruger.cfwebtools.com/index.cfm?mode=alias&alias=Dreamweaver%20issue
s

-Original Message-
From: Ken Ferguson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 16, 2005 2:29 PM
To: CF-Talk
Subject: Re: CFEclipse 1.2


No, but then I avoid even opening a 74 line file in DW. I don't use it,
EVER, for ANY reason. I have given DW it fair consideration on a couple
of occasions and have come to the conclusion that I'd rather use crayons
and tablet paper. Anyway, for me, the 7400 line file worked just fine in
both CFE and HomeSite+. Another point of interest is that I combined a
whole bunch of cfc's into one huge 5000+ line cfc and opened it in CFE.
Not only did it have no trouble with the file, but the way the functions
are all collapsed by default is very, very cool. My only issue is the
closing tag problem and if I can get past that, I'll use CFE exclusively.

--Ferg


Massimo, Tiziana e Federica wrote:

>>>Yeah... 7400 is too long I think.. beyond a few hundred I get
>>>a headache.
>>>
>>>
>>With the new code collapsing in DW8 it won't be a problem anymore ;-)
>>
>>
>
>Have you ever tried opening a 7400 lines file in DW? I doubt it would be a
>pleasant experience :-))
>
>
>Massimo Foti
>Tools for ColdFusion and Dreamweaver developers:
>http://www.massimocorner.com
>
>
>
>
>



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215316
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: bg & myspace

[Calvin Ward]

I disagree, I think cf-community is too chock full of unrelated stuff to be
useful to subscribe to for some busy professionals who would have an
interest in a conversation about technology that is ColdFusion related...

/shrug 

-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 16, 2005 3:27 PM
To: CF-Talk
Subject: Re: bg & myspace

Burns, John D wrote:
> 
> If people are discussing New Atlanta and BD, could we keep it on the 
> CF-Talk list. I'd be anxious to hear impressions on the company since 
> it is CF related and could influence the decision to use New Atlanta 
> products.

Actually, I would thing that's exactly the kind of discussion that SHOULD
occur on cf-community, not cf-talk.




~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215314
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFEclipse 1.2

[Mark A Kruger]

and I would agree with you theremore or less - with a few exceptions.

-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 16, 2005 1:59 PM
To: CF-Talk
Subject: RE: CFEclipse 1.2


>> -Original Message-
>> From: Mark A Kruger [mailto:[EMAIL PROTECTED]
>>
>> Yeah... 7400 is too long I think.. beyond a few
>> hundred I get a headache.

> With the new code collapsing in DW8 it won't be a
> problem anymore ;-)

Code collapsing or otherwise ... I generally think of a 500+ line
template as being something wrong with the code. Ime even if the code
works perfectly, the fact that it is 500+ lines typically causes
developmental problems in the application that go beyond difficulties
editing it in an IDE.


s. isaac dealey   954.522.6080
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm






~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215313
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFEclipse 1.2

[SStewart]

Cute pup tho..

sas

Scott A. Stewart, 
Web Application Developer
 
Engineering Consulting Services, Ltd. (ECS)
14026 Thunderbolt Place, Suite 300
Chantilly, VA 20151
Phone: (703) 995-1737
Fax: (703) 834-5527
 
"Many thousands of years ago, a blue faced Pict stepped on a bloated sheep 
carcass... and thus the Pipes were born" 
 
 the Scottish Rogues


-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 16, 2005 02:53 pm
To: CF-Talk
Subject: RE: CFEclipse 1.2
Importance: Low

sorry guys.. meant to send that offlist. Ugh.
 

> -Original Message-
> From: Tangorre, Michael [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, August 16, 2005 2:46 PM
> To: CF-Talk
> Subject: RE: CFEclipse 1.2
> 
> > From: Ray Champagne [mailto:[EMAIL PROTECTED] MT, you have 
> links for more 
> > pics?  send 'em offline to me!
> > Ray
> 
> Sorry Ray, meant to send this to ya over the weekend!
> http://www.cfreloaded.com/herbie/new%20baby/index.html
> 
> Now, if I could get some sleep :-)
> 
> Mike
> 
> 



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215312
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CFEclipse 1.2

[Ken Ferguson]

No, but then I avoid even opening a 74 line file in DW. I don't use it, 
EVER, for ANY reason. I have given DW it fair consideration on a couple 
of occasions and have come to the conclusion that I'd rather use crayons 
and tablet paper. Anyway, for me, the 7400 line file worked just fine in 
both CFE and HomeSite+. Another point of interest is that I combined a 
whole bunch of cfc's into one huge 5000+ line cfc and opened it in CFE. 
Not only did it have no trouble with the file, but the way the functions 
are all collapsed by default is very, very cool. My only issue is the 
closing tag problem and if I can get past that, I'll use CFE exclusively.

--Ferg


Massimo, Tiziana e Federica wrote:

>>>Yeah... 7400 is too long I think.. beyond a few hundred I get
>>>a headache.
>>>  
>>>
>>With the new code collapsing in DW8 it won't be a problem anymore ;-)
>>
>>
>
>Have you ever tried opening a 7400 lines file in DW? I doubt it would be a
>pleasant experience :-))
>
>
>Massimo Foti
>Tools for ColdFusion and Dreamweaver developers:
>http://www.massimocorner.com
>
>
>
>
>

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215311
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: bg & myspace

[Rick Root]

Burns, John D wrote:
> 
> If people are discussing New Atlanta and BD, could we keep it on the
> CF-Talk list. I'd be anxious to hear impressions on the company since it
> is CF related and could influence the decision to use New Atlanta
> products.

Actually, I would thing that's exactly the kind of discussion that 
SHOULD occur on cf-community, not cf-talk.


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215310
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: bg & myspace

[Yves Arsenault]

Here here

(thump thump thump)...

Yves

On 8/16/05, Rick Root <[EMAIL PROTECTED]> wrote:
> This seems like kind of a silly discussion.
> 
> Consider the following two statements:
> 
> #1 - MySpace.com is powered by New Atlanta's Bluedragon.NET.
> #2 - MySpace.com is powered by Macromedia Coldfusion.
> 
> It would appear that both statements are 100% true.
> 
> Now consider the following statement, which is far more important as far
>   as I'm concerned:
> 
> "MySpace.com is powered by CFML"
> 
> Rick

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215309
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: bg & myspace

[Burns, John D]

Mike,

If people are discussing New Atlanta and BD, could we keep it on the
CF-Talk list. I'd be anxious to hear impressions on the company since it
is CF related and could influence the decision to use New Atlanta
products.  Obviously, if we're just arguing about what technology
MySpace uses then I don't mind it moving, but the responses about
perceptions from CFUnited would be nice to hear. Just my $0.02.


John Burns
Certified Advanced ColdFusion MX Developer
Wyle Laboratories, Inc. | Web Developer
 

-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, August 16, 2005 1:59 PM
To: CF-Talk
Subject: Re: bg & myspace

My response to this has been posted to CF-OT and I'd appreciate people
posting there. Thank you.


> This seems like kind of a silly discussion.
>
> Consider the following two statements:
>
> #1 - MySpace.com is powered by New Atlanta's Bluedragon.NET.
> #2 - MySpace.com is powered by Macromedia Coldfusion.
>
> It would appear that both statements are 100% true.
>
> Now consider the following statement, which is far more important as
far
>  as I'm concerned:
>
> "MySpace.com is powered by CFML"
>
> Rick
>
>
> 



~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215308
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CFEclipse 1.2

[Tony Weeg]

ok.  so that makes a lot of sense. sure.  conform your development to
the editor...
SURE!

homesite has no problems.

sounds like the editor.

tw

On 8/16/05, S. Isaac Dealey <[EMAIL PROTECTED]> wrote:
> My answer would be that the editor is fine and the code needs to be
> written in smaller chunks.
> 
> > Hmmm,  any file for me over 500 lines gets slow.  I type
> > for a bit, then
> > the editor catches up.  If I put a newline in, I get an
> > echo of the line
> > while it moves down the editor.  It would scroll fine, but
> > text edits
> > killed it.
> 
> > I am on a very fast machine, I can't imagine what it does
> > on slower
> > ones.
> 
> > I bet they'll get it fixed up soon.
> 
> > Kevin.
> 
> 
> 
> s. isaac dealey   954.522.6080
> new epoch : isn't it time for a change?
> 
> add features without fixtures with
> the onTap open source framework
> 
> http://www.fusiontap.com
> http://coldfusion.sys-con.com/author/4806Dealey.htm
> 
> 
> 
> 
> 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215306
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: SQL help (updated)

[Ian Skinner]

SELECT *
FROM AllResults
WHERE #idnumber# in MyColumn

That probably needs to be
WHERE #idnumber# IN (MyColumn)

The values of an IN clause are supposed to be in parenthesis I believe.  You 
may also need to do something about the quotes if they are part of the value 
list. 


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
 
"C code. C code run. Run code run. Please!"
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215305
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFEclipse 1.2

[S . Isaac Dealey]

>> -Original Message-
>> From: Mark A Kruger [mailto:[EMAIL PROTECTED]
>>
>> Yeah... 7400 is too long I think.. beyond a few
>> hundred I get a headache.

> With the new code collapsing in DW8 it won't be a
> problem anymore ;-)

Code collapsing or otherwise ... I generally think of a 500+ line
template as being something wrong with the code. Ime even if the code
works perfectly, the fact that it is 500+ lines typically causes
developmental problems in the application that go beyond difficulties
editing it in an IDE.


s. isaac dealey   954.522.6080
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm




~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215304
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: myeclipse WAS:Re: CFEclipse 1.2

[Douglas Knudsen]

I thought all that was in the WTP eclipse project though, eh?  well,
not the DB browser.

congrats by the wayhad my first kid 4 months back...what was sleep again?

DK

On 8/16/05, Barney Boisvert <[EMAIL PROTECTED]> wrote:
> I use it.  It's got some nice features, including some XML tools (the
> main reason I bought it).  It's also got a pretty decend DB interface
> for running ad-hoc queries and maintenance.  And then it's got a range
> of other stuff as well, of course.  Most notably, JS and CSS editors,
> and a slew of J2EE stuff.
> 
> cheers,
> barneyb
> 
> On 8/15/05, dave <[EMAIL PROTECTED]> wrote:
> > anyone using myeclipse?
> >  is it worth buying?
> >
> > ~Dave the disruptor~
> > "Some people just don't appreciate how difficult it is to dispense wisdom 
> > and abuse at the same time."
> 
> --
> Barney Boisvert
> [EMAIL PROTECTED]
> 360.319.6145
> http://www.barneyb.com/
> 
> Got Gmail? I have 50 invites.
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215307
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CSS Help

[Rick Root]

Nope, doesn't work.

I'll stop posting on this thread here... I'm trying to subscribe to a 
css discussion list =)

Rick

Tangorre, Michael wrote:
>>From: Rick Root [mailto:[EMAIL PROTECTED] 
>>where is that space coming from?
> 
> 
> Try something out...
> 
> Make this your first style declaration. Then refresh.
> 
> *{
>padding: 0px;
>margin: 0px;
> }
> 
> Looks like a padding issue...
> 
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215301
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFEclipse 1.2

[Mark A Kruger]

no no... after it refreshed the cache and put and then got... then created
some notes and stuff I bet it would open right up (lol)

-Original Message-
From: Massimo, Tiziana e Federica [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 16, 2005 1:43 PM
To: CF-Talk
Subject: Re: CFEclipse 1.2


> > Yeah... 7400 is too long I think.. beyond a few hundred I get
> > a headache.
>
> With the new code collapsing in DW8 it won't be a problem anymore ;-)

Have you ever tried opening a 7400 lines file in DW? I doubt it would be a
pleasant experience :-))


Massimo Foti
Tools for ColdFusion and Dreamweaver developers:
http://www.massimocorner.com






~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215303
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: SQL help (updated)

[Dave.Phillips]

Okay, I still need help, but I've resolve part of my problem.  I'm able now to 
have the list of ID numbers in one field by themselves.  So, my new field value 
(MyColumn) looks like this:

'5,2,3,4,45,7'

I still need a way using Query of Queries to extract only the records that have 
the 'idnumber' in that list.  I've tried:

SELECT *
FROM AllResults
WHERE #idnumber# in MyColumn

I get an error:  
Query Of Queries syntax error.
Encountered "3 in custom2" at line 0, column 0. Incorrect conditional 
expression, Expected one of [like|null|between|in|comparison] condition

TIA,

Dave


-Original Message-
From: Phillips, Dave 
Sent: Tuesday, August 16, 2005 2:16 PM
To: CF-Talk
Subject: SQL help


Hi,

I'm on Oracle 9i.  I have a query (call it AllResults) that is returning a 
column (call it MyColumn) that's value looks like this:

'identifier|5,2,3,4,45,7' 

Each row may have a different 'identifier' and a different quantity of numbers.

Basically, there are two values in this column.  identifier & numberlist 
separated by a pipe

Now, I need to build a query of queries that queries this existing recordset 
and only returns the records which has a number that I'm comparing against.  I 
know I can do this in CF by looping over the recordset, but I'm trying to avoid 
that (for processing time sake).  

Here's the pseudo code of what I'm trying to do:

(idnumber is a variable in my code and will be ONE of the numbers listed in the 
numberlist)

select * from AllResults WHERE
idnumber is found in the list of numbers located in the MyColumn field

I only want the records that have 'idnumber' IN the list of numbers

I'm sure this can be done with some SQL code and since I'm not a SQL guru, let 
alone Oracle, any help or suggestions would be appreciated.

Thanks!

Dave
**
The information contained in this message, including attachments, may contain 
privileged or confidential information that is intended to be delivered only to 
the 
person identified above. If you are not the intended recipient, or the person 
responsible for delivering this message to the intended recipient, ALLTEL 
requests 
that you immediately notify the sender and asks that you do not read the 
message or its 
attachments, and that you delete them without copying or sending them to anyone 
else. 


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215299
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: myeclipse WAS:Re: CFEclipse 1.2

[Barney Boisvert]

I use it.  It's got some nice features, including some XML tools (the
main reason I bought it).  It's also got a pretty decend DB interface
for running ad-hoc queries and maintenance.  And then it's got a range
of other stuff as well, of course.  Most notably, JS and CSS editors,
and a slew of J2EE stuff.

cheers,
barneyb

On 8/15/05, dave <[EMAIL PROTECTED]> wrote:
> anyone using myeclipse?
>  is it worth buying?
> 
> ~Dave the disruptor~
> "Some people just don't appreciate how difficult it is to dispense wisdom and 
> abuse at the same time."

-- 
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/

Got Gmail? I have 50 invites.

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215302
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFEclipse 1.2

[Tangorre, Michael]

sorry guys.. meant to send that offlist. Ugh.
 

> -Original Message-
> From: Tangorre, Michael [mailto:[EMAIL PROTECTED] 
> Sent: Tuesday, August 16, 2005 2:46 PM
> To: CF-Talk
> Subject: RE: CFEclipse 1.2
> 
> > From: Ray Champagne [mailto:[EMAIL PROTECTED] MT, you have 
> links for more 
> > pics?  send 'em offline to me!
> > Ray
> 
> Sorry Ray, meant to send this to ya over the weekend!
> http://www.cfreloaded.com/herbie/new%20baby/index.html
> 
> Now, if I could get some sleep :-)
> 
> Mike
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215300
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFEclipse 1.2

[Tangorre, Michael]

> From: Ray Champagne [mailto:[EMAIL PROTECTED] 
> MT, you have links for more pics?  send 'em offline to me!
> Ray

Sorry Ray, meant to send this to ya over the weekend!
http://www.cfreloaded.com/herbie/new%20baby/index.html

Now, if I could get some sleep :-)

Mike

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215296
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: bg & myspace

[Rey Bango]

Best post yet!

Rey..

Rick Root wrote:
> This seems like kind of a silly discussion.
> 
> Consider the following two statements:
> 
> #1 - MySpace.com is powered by New Atlanta's Bluedragon.NET.
> #2 - MySpace.com is powered by Macromedia Coldfusion.
> 
> It would appear that both statements are 100% true.
> 
> Now consider the following statement, which is far more important as far 
>   as I'm concerned:
> 
> "MySpace.com is powered by CFML"
> 
> Rick
> 
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215297
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CFEclipse 1.2

[Massimo, Tiziana e Federica]

> > Yeah... 7400 is too long I think.. beyond a few hundred I get
> > a headache.
>
> With the new code collapsing in DW8 it won't be a problem anymore ;-)

Have you ever tried opening a 7400 lines file in DW? I doubt it would be a
pleasant experience :-))


Massimo Foti
Tools for ColdFusion and Dreamweaver developers:
http://www.massimocorner.com




~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215298
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFEclipse 1.2

[S . Isaac Dealey]

My answer would be that the editor is fine and the code needs to be
written in smaller chunks.

> Hmmm,  any file for me over 500 lines gets slow.  I type
> for a bit, then
> the editor catches up.  If I put a newline in, I get an
> echo of the line
> while it moves down the editor.  It would scroll fine, but
> text edits
> killed it.

> I am on a very fast machine, I can't imagine what it does
> on slower
> ones.

> I bet they'll get it fixed up soon.

> Kevin.



s. isaac dealey   954.522.6080
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215295
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: bg & myspace

[Rey Bango]

Adrocknaphobia wrote:
> However, I will say that I got a very negative impression of NA in
> general at CFUnited. I think they have gone from being a company who
> has provided a ColdFusion alternative, to a company whose sole purpose
> is to bash Macromedia and publicy criticise all thier products.

I'm sure there are things behind the scenes between MM and NA that we 
don't see and I know that in conversations that my friends have had with 
MM recently, MM has been very dismissive of New Atlanta. I have to 
assume the MM seeing a viable alternative to CFMX is not something 
they're fond of and would assume that any level of coorperation is next 
to none. Put that all together and the jabs will definitely begin 
between both camps.

As for the negative impression of NA, thats a shame because they are 
great to work with. Seriously. Have a sit down with Vince, Charlie, 
Brian or Dan one day, and I think you'd come out with a good feeling.

Rey...

-- 
http://www.ReyBango.com


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215294
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CSS Help

[Tangorre, Michael]

> From: Rick Root [mailto:[EMAIL PROTECTED] 
> where is that space coming from?

Try something out...

Make this your first style declaration. Then refresh.

*{
   padding: 0px;
   margin: 0px;
}

Looks like a padding issue...


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215293
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CFEclipse 1.2

[Ray Champagne]

he has more pics?  i'd seen the ones that he had before he picked him 
up, but no more...

MT, you have links for more pics?  send 'em offline to me!

Ray

Tony Weeg wrote:
> same thing here man.
> 
> hopefully those guys read this...
> 
> im back to my dreamweaver force feeding... trying to start using it
> instead of hs+
> but im about to go back to that... im having a hard to using anything else.
> 
> seen tango's pup?
> 
> WOW. great lookin dog.
> 
> On 8/16/05, Kazmierczak, Kevin <[EMAIL PROTECTED]> wrote:
> 
>>Hmmm,  any file for me over 500 lines gets slow.  I type for a bit, then
>>the editor catches up.  If I put a newline in, I get an echo of the line
>>while it moves down the editor.  It would scroll fine, but text edits
>>killed it.
>>
>>I am on a very fast machine, I can't imagine what it does on slower
>>ones.
>>
>>I bet they'll get it fixed up soon.
>>
>>Kevin.
>>
>>
>>-Original Message-
>>From: Ken Ferguson [mailto:[EMAIL PROTECTED]
>>Sent: Tuesday, August 16, 2005 12:59 PM
>>To: CF-Talk
>>Subject: Re: CFEclipse 1.2
>>
>>Man, my only trouble is the failure to insert closing tags. I've got a
>>7400 line file open with no performance problems (even when scrolling
>>wildly), but I'm about to go back to HS+ if I can't get this tag thing
>>fixed. I'm too used to the convenience factor.
>>
>>--Ferg
>>
>>Kazmierczak, Kevin wrote:
>>
>>
>>>It seems the tag autoclose works on eclipse 3.1 but not previous
>>>versions.
>>>
>>>Regardless, we rolled back to cfeclipse 1.1.17.2 because of the
>>>performance issues.  Any large files were near unworkable with
>>
>>cfeclipse
>>
>>>1.2.  But I did like the sql highlighting.
>>>
>>>We have tried JVM versions: 1.5.0_04, 1.4.2_03
>>>
>>>Kevin.
>>>
>>>-Original Message-
>>>From: Matt Osbun [mailto:[EMAIL PROTECTED]
>>>Sent: Tuesday, August 16, 2005 10:27 AM
>>>To: CF-Talk
>>>Subject: RE: CFEclipse 1.2
>>>
>>>Same deal here.  Doesn't auto close tags, #'s, quotes, or insert close
>>>tags.
>>>
>>>Hope that's something easily fixable.  I'm so used to having the
>>>auto-close on, that I'm forgetting to do it myself.
>>>
>>>Matt Osbun
>>>Web Developer
>>>Health Systems, International
>>>
>>>
>>
>>
>>
>>
>>
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215292
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: CSS Help

[Rick Root]

Sandy Clark wrote:
> Yes, but you designed it in quirks mode. Best bet is to start commenting out
> css and playing with it one bit at a time until you find the culprit.  

I didn't design it in any mode other than text mode =)

Okay, I removed all the unrelated crap and have this:

http://www.it.dev.duke.edu/template2.html

All I have are two divs - the left sidebar with a fixed width of 150px 
set to float left, and the content area with a left margin of 150px 
(which allows the nav to float into the left side)

If you look at it, it appears that the left nav area has a margin of 
several pixels outside of its border.  See header 3 is aligned properly, 
but header 2 is not.

where is that space coming from?

Rick



~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215289
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Offline application

[Kevin Aebig]

Sorry, I just saw that the data didn't need to be synced. Though I'm not
sure how it's not needed...

That said I'm sure they could save quite a bit of development money by
simply getting an internet connection for the one without.

Cheers,

Kevin

-Original Message-
From: Kurt Kaptein [mailto:[EMAIL PROTECTED] 
Sent: August 16, 2005 12:01 PM
To: CF-Talk
Subject: Offline application

 

I have a customer who would like an application developed that I would like
to do in coldfusion, but they insist that it be built for their local
desktop and then the data transferred via disk so that another individual
who has no access to the internet can work on it.  I do not need to worry
about syncing the data as it is a mom or daughter team that work on the app.

Is there something like coldfusion I could use for an offline app.  I was
just going to use acess for data storage.  I do not want develop a access
front end. This has always been a pain

Any direction is much appreciated

Sincerely,
 
Kurt Kaptein
 
Kurt Kaptein
Spectrum Net Designs, Inc
PO Box 806
Grandville,  MI  49468
Toll Free:  866-773-2638
Fax:  616-538-5691
Website:   www.spectrumnetdesigns.com
Email: [EMAIL PROTECTED]
 





~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215291
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Offline application

[Kevin Aebig]

Hey Kurt,

What you're talking about is actually a common situation, but unfortunately,
what you're trying to do would be a bad method of accomplishing this.

If you're looking to build an offline application, there's many things to
keep in mind and questions you should ask before you decide how you'd like
to build it.

1 - How often will the data be changing? Will it need to be synced so that
everyone is using the same data? How often should you synchronize it? How
will similar changes be handled?

2 - What kinds of front ends are you comfortable building? Will this need to
be web enabled or will it mostly be used offline? Is there a possibility
that this could be run on a Linux machine? Will there be multiple UI's such
as a desktop and a server application?

3 - Depending on the UI, is Access the right choice? Could SQLite or another
portable DB be used instead? Would it be better if the user couldn't
directly edit the DB? Would it be worse?

4 - Does your client understand the added costs of having this type of
application built? How much support are you able to provide after the fact
as these applications have more failure points than the average DB
application?

I hope this helps...

Cheers,

Kevin

http://www.keslabs.com 
http://crd.keslabs.com 

-Original Message-
From: Kurt Kaptein [mailto:[EMAIL PROTECTED] 
Sent: August 16, 2005 12:01 PM
To: CF-Talk
Subject: Offline application

 

I have a customer who would like an application developed that I would like
to do in coldfusion, but they insist that it be built for their local
desktop and then the data transferred via disk so that another individual
who has no access to the internet can work on it.  I do not need to worry
about syncing the data as it is a mom or daughter team that work on the app.

Is there something like coldfusion I could use for an offline app.  I was
just going to use acess for data storage.  I do not want develop a access
front end. This has always been a pain

Any direction is much appreciated

Sincerely,
 
Kurt Kaptein
 
Kurt Kaptein
Spectrum Net Designs, Inc
PO Box 806
Grandville,  MI  49468
Toll Free:  866-773-2638
Fax:  616-538-5691
Website:   www.spectrumnetdesigns.com
Email: [EMAIL PROTECTED]
 





~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215290
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: User's Browser: gibberish

[Jochem van Dieten]

Jason Lemahieu wrote:
> I have gotten a couple error reports today which identified the user's 
> browser as very odd strings.  Any ideas on either what this means or what's 
> going wrong?
> 
> User's Browser:   ƒƒ
> User's Browser: h j‹X¾‹
> User's Browser: e‹ ‰
> User's Browser: t

Does your error handler understand Unicode?

Jochem

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215288
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Offline application

[S . Isaac Dealey]

BlueDragon on a CD... of course that doesn't resolve the issue of
storing their data, since I've not had good luck with multi-session
CD's...

> I have a customer who would like an application developed
> that I would like
> to do in coldfusion, but they insist that it be built for
> their local
> desktop and then the data transferred via disk so that
> another individual
> who has no access to the internet can work on it.  I do
> not need to worry
> about syncing the data as it is a mom or daughter team
> that work on the app.

> Is there something like coldfusion I could use for an
> offline app.  I was
> just going to use acess for data storage.  I do not want
> develop a access
> front end. This has always been a pain

> Any direction is much appreciated


s. isaac dealey   954.522.6080
new epoch : isn't it time for a change?

add features without fixtures with
the onTap open source framework

http://www.fusiontap.com
http://coldfusion.sys-con.com/author/4806Dealey.htm




~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215283
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: CFEclipse 1.2

[Damien McKenna]

> -Original Message-
> From: Mark A Kruger [mailto:[EMAIL PROTECTED] 
>
> Yeah... 7400 is too long I think.. beyond a few hundred I get 
> a headache.

With the new code collapsing in DW8 it won't be a problem anymore ;-)

-- 
Damien McKenna - Web Developer - [EMAIL PROTECTED]
The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
#include 


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215287
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

SQL help

[Dave.Phillips]

Hi,

I'm on Oracle 9i.  I have a query (call it AllResults) that is returning a 
column (call it MyColumn) that's value looks like this:

'identifier|5,2,3,4,45,7' 

Each row may have a different 'identifier' and a different quantity of numbers.

Basically, there are two values in this column.  identifier & numberlist 
separated by a pipe

Now, I need to build a query of queries that queries this existing recordset 
and only returns the records which has a number that I'm comparing against.  I 
know I can do this in CF by looping over the recordset, but I'm trying to avoid 
that (for processing time sake).  

Here's the pseudo code of what I'm trying to do:

(idnumber is a variable in my code and will be ONE of the numbers listed in the 
numberlist)

select * from AllResults WHERE
idnumber is found in the list of numbers located in the MyColumn field

I only want the records that have 'idnumber' IN the list of numbers

I'm sure this can be done with some SQL code and since I'm not a SQL guru, let 
alone Oracle, any help or suggestions would be appreciated.

Thanks!

Dave
**
The information contained in this message, including attachments, may contain 
privileged or confidential information that is intended to be delivered only to 
the 
person identified above. If you are not the intended recipient, or the person 
responsible for delivering this message to the intended recipient, ALLTEL 
requests 
that you immediately notify the sender and asks that you do not read the 
message or its 
attachments, and that you delete them without copying or sending them to anyone 
else. 


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215286
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54