RE: Cfchart hanging

[Snake]

Yes sandboxing is in use, but we use it on all servers, and cfchart works on
those.

Russ 

-Original Message-
From: James Holmes [mailto:[EMAIL PROTECTED] 
Sent: 04 November 2005 00:18
To: CF-Talk
Subject: Re: Cfchart hanging

Do you use sandboxing? If so, allow the sandbox access to the the chart
cache directory.

On 11/3/05, Snake <[EMAIL PROTECTED]> wrote:
> Got this very basic code on a page, but cfchart just hangs, and 
> nothing happens, the page just seems to endlessly load forever.
> Anyone got an idea why?
> I do have the CFIDE and JrunScripts vDIR's in palce.
>
> 
> 
>   item="Used car sales" value="25000">  value="3">  
>  



~|
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:223158
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: js pop up prob

[dave]

nm, it seems to work fine on pc and i think i got a corrupt java file on mac 
arg

~Dave the disruptor~
"Some people just don't appreciate how difficult it is to dispense wisdom and 
abuse at the same time." 


From: "dave" <[EMAIL PROTECTED]>
Sent: Friday, November 04, 2005 12:55 AM
To: CF-Talk 
Subject: js pop up prob 

lets see...

using tinymce and ricks cffm uploader to load images into tinymce.
heres the problem when you click on the insert image button it makes the find 
image popup and then you click the browse button and ricks popup comes up and 
you upload or select a photo, all that works fine but when you select the 2nd 
popup (the photo uploader selector) and choose your photo the popup goes away 
and loads the image in the tinymce window but it pushes the lil popup behind 
the parent window, which is a prob. I went through the js code and I have no 
idea where to put the window: focus at.
anyone have a solution 4 this?

example is here: http://65.36.226.10/admin/news/addNews.cfm
yeah yeah i know its plain right now!!

~Dave the disruptor~
"Some people just don't appreciate how difficult it is to dispense wisdom and 
abuse at the same time." 



~|
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:223157
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

js pop up prob

[dave]

lets see...

using tinymce and ricks cffm uploader to load images into tinymce.
heres the problem when you click on the insert image button it makes the find 
image popup and then you click the browse button and ricks popup comes up and 
you upload or select a photo, all that works fine but when you select the 2nd 
popup (the photo uploader selector) and choose your photo the popup goes away 
and loads the image in the tinymce window but it pushes the lil popup behind 
the parent window, which is a prob. I went through the js code and I have no 
idea where to put the window: focus at.
anyone have a solution 4 this?

example is here: http://65.36.226.10/admin/news/addNews.cfm
yeah yeah i know its plain right now!!

~Dave the disruptor~
"Some people just don't appreciate how difficult it is to dispense wisdom and 
abuse at the same time." 



~|
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:223156
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: XOR

[Aaron Rouse]

One of those all in the coding style situations. After all there are like a
million ways to skin a cat. I have always wondered about XOR or the idea
behind it because I have wondered on it in other languages and when/if
people ever use it.

On 11/3/05, Claude Schneegans <[EMAIL PROTECTED] > wrote:
>
> >>XOR coerces it's operands to boolean, while NEQ doesn't.
>
> Exact.
> But what I mean is that if someone has to use an XOR operator, the
> situation is actually a NEQ issue,
> he will think of NEQ first, and do what must be done to make sure both
> operands are boolean.
>
> --
> ___
> REUSE CODE! Use custom tags;
> See http://www.contentbox.com/claude/customtags/tagstore.cfm
> (Please send any spam to this address: [EMAIL PROTECTED])
> Thanks.
>
>
> 

~|
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:223155
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: Verity, am missing something?

[Dave Watts]

> I just installed the 30 day trial for cf 7 one a new box and 
> there is no "ColdFusion MX 7 Search Server" listed in my list 
> of services.
> 
> I looked through the log and i don't see any errors, and i 
> know i checked it off. I've even gone so far as to reinstall 
> the entire server again but still nothing.
> 
> anyone know why i wouldn't have the search services? Without 
> this i'm not able to create my verity collections

Sometimes, for some wacky reason or other, services don't get registered
properly. However, as long as you have the files on your disk, you can
create a service entry within the registry. You can do this using the
Registry Editor, or with a Resource Kit tool like srvinstw.exe or
instsrv.exe (depending on which version of Windows you're running).

On my laptop, running CFMX 7.0.1 in Multiserver configuration, the path to
my service executable is:
"C:\JRun4\verity\k2\_nti40\bin\k2admin.exe" -cfg
"C:\JRun4\verity\k2\common\verity.cfg" -ntstart 1

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized 
instruction at our training centers in Washington DC, Atlanta, 
Chicago, Baltimore, Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information!


~|
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:223154
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: Force PDF Download

[Dave Watts]

> > You may want to try :
> > 
> 
> That would tell the browser that the incoming file is an 
> 'undefined executable' via HTTP. That MIME type is for SMTP, 
> yes?

I'm not sure what you mean by that MIME type being for SMTP. All MIME types
are for SMTP - "MIME" stands for Multipurpose Internet Mail Extensions, if I
recall correctly - but they can also be used and understood by HTTP clients
and servers.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Software provides the highest caliber vendor-authorized 
instruction at our training centers in Washington DC, Atlanta, 
Chicago, Baltimore, Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information!


~|
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:223153
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

Passing null dates via WDDX

[Chris Velevitch]

How do you pass null dates via wddx?

When I try passing:-


 


as part of my wddx data, cfwddx action='wddx2cfml' generates an
invalid WDDX packet error.

This data will be inserted in a database where this column will access nulls.

Any ideas?


Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
www.flashdev.org.au

~|
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:223152
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: Cfchart hanging

[Douglas Knudsen]

this can also happen if the account the CF process is running under
has security issues, on win2k at least.  We had this happen once,
something to do with the account not being a domain account or
something

DK

On 11/3/05, Matthew Walker <[EMAIL PROTECTED]> wrote:
>
> We had this happening when we were using a server monitoring too
> (IISTracer) but the problem went away with CF 7.0.1.
>
> > Got this very basic code on a page, but cfchart just hangs, and
> > nothing happens, the page just seems to endlessly load forever.
> > Anyone got an idea why?
> > I do have the CFIDE and JrunScripts vDIR's in palce.
> >
>
> 

~|
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:223151
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: [SPAM : 8.1] Re: Rumors from Max..

[Terry Troxel]

If you are basically a scripter why would you think a move
to java is
A good thing, especially with all the problems it seems come
up with
The java odbc conectivity issues and the ms breaking my java
setup.
I love CF5 and just am reluctant to go to 6.1 or 7. C'mon
guys convince me.

Terry 

-Original Message-
From: Jeff Small [mailto:[EMAIL PROTECTED] 
Sent: Thursday, November 03, 2005 9:13 AM
To: CF-Talk
Subject: Re: [SPAM : 8.1] Re: Rumors from Max..

> Why exactly was CFMX6 needed to save the product from CF5,
if that's 
> what you meant?
> Just curious as I am still in love with 5.0
> 
> Terry Troxel

I think he's referring to the move to Java.





~|
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:223150
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_twoselectsrelated

[Duncan]

I was just looking at how to solve this, especially for me to get around the
issues when you use the emptytext items. Because we use the drop downs on
the search page and the results page we need to preselect the items the user
selected.

After knocking up some js to fix the issue it works like a dream now.

http://www.sixfive.co.uk/news/?nid=174

you can also see it in action at
jobs.stratumconsulting.co.nz

Duncan

On 9/15/05, Mike Klostermeyer <[EMAIL PROTECTED]> wrote:
>
> Does anyone have a version of cf_twoselectsrelated (or something similar)
> that accepts a parameter to 'preselect' records in the second select
> depending upon what is selected in the first? Thanks.
>
> 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:223149
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: Need query help please

[Will Tomlinson]

I just needed help making my query work. Matthieu is helping me with a self 
join. 

Thanks,
Will

~|
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:223148
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: what do you use instead of cfx_openimage?

[James Holmes]

Alagad Imaging Component

On 11/4/05, Sebastian Mork <[EMAIL PROTECTED]> wrote:
> is nobody using cfx_openimage? is there another similar good tool (for
> easy setup&use in shared hosting environment)
>
> I wanna resize images and read image dimensions..
>
> what are you using?

~|
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:223147
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: Cfchart hanging

[Matthew Walker]

 
We had this happening when we were using a server monitoring too
(IISTracer) but the problem went away with CF 7.0.1.

> Got this very basic code on a page, but cfchart just hangs, and 
> nothing happens, the page just seems to endlessly load forever.
> Anyone got an idea why?
> I do have the CFIDE and JrunScripts vDIR's in palce.
>

~|
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:223146
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: [SPAM : 8.1] Re: Rumors from Max...

[Jerry Johnson]

No, wasn't Heaven's Gate the last decent movie Warren Beatty ever made?

On 11/3/05, Robert Munn <[EMAIL PROTECTED]> wrote:
> That was Heaven's Gate. And they lived in Rancho Santa Fe.
>
> http://www.slate.com/id/2583/

~|
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:223145
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: what do you use instead of cfx_openimage?

[Sebastian Mork]

:) hmm thx, I'll have a look at it
--
Sebastian Mork
[EMAIL PROTECTED]
--

On Thu, 03 Nov 2005 19:48:46 -0500
Claude Schneegans <[EMAIL PROTECTED]> wrote:

>  >>what are you using?
> 
> CFX_image
> 
> -- 
> ___
> REUSE CODE! Use custom tags;
> See http://www.contentbox.com/claude/customtags/tagstore.cfm
> (Please send any spam to this address: [EMAIL PROTECTED])
> Thanks.
> 
> 
> 

~|
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:223144
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: Force PDF Download

[Matt Robertson]

On 11/3/05, Beru <[EMAIL PROTECTED]> wrote:
> You may want to try :
> 

That would tell the browser that the incoming file is an 'undefined
executable' via HTTP.  That MIME type is for SMTP, yes?

Regardless, its far better to genuinely match the MIME type to what
the file really is.  Back in the day, if you wanted to force a save
dialog you used 'application/unknown' and sent the thing as an
attachment.  Unfortunately a Windows security update killed that
pretty much dead, IIRC.  It was convenient, but sloppy coding.

--
--mattRobertson--
Janitor, MSB Web Systems
mysecretbase.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:223143
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: what do you use instead of cfx_openimage?

[Claude Schneegans]

 >>what are you using?

CFX_image

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
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:223142
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

what do you use instead of cfx_openimage?

[Sebastian Mork]

is nobody using cfx_openimage? is there another similar good tool (for
easy setup&use in shared hosting environment)

I wanna resize images and read image dimensions..

what are you using?

--
Sebastian Mork
[EMAIL PROTECTED]
--

On Thu, 03 Nov 2005 17:32:55 +0100
Sebastian Mork <[EMAIL PROTECTED]> wrote:

> Hi,
> 
> in my app I use cfx_openimage  (in a shared hosting environment running
> win(nt?), cfmx7.0).
> I used the tag for months for reading images to get infos about the
> dimension without poblems.
> suddenly, two days ago a user told me he gets an error viewing some
> other user profiles.
> hmm, thats strange, from one day to another the cfx_tag produces an
> error, the html-title says 'jrun servlet error' and '500 null' is shown.
> 
> the hosting-comp. said thay didn't change anything. and I did not change
> anything in the code, too.
> they restarted cfmx and the whole server without success.
> and, I read cfx_openimage needs a temp-dir (c:\temp), but they didn't
> delete that dir and the installation of that tag is made in the
> default-directory..
> so what??
> I've created a test-page with the following code, its just an example,
> that code worked fine in my app:
> 
> #filename# is: 
> D:\friendcom.de\wwwroot\MachII\summComm\views\images\index10.jpg
> code: 
>ACTION="IML" 
>   FILE="#filename#" 
>   COMMANDS="getsize">
> heres the test-page: http://friendcom.de/sc/views/test.cfm
> 
> any ideas?
> 
> thx
> 
> -- 
> Sebastian Mork <[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:223141
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

binding in flash forms... I could swear I saw this here already but...

[Anthony Prato]

none of my searches are returning what I want.

I have no problem binding inputs to a selected datagrid column; labels
are also easy to bind too. My problem now is binding inside formatted
text. I've got a grid with a bunch of different items in it. When an
item is selected I want a panel to the right to show the name, size,
description and item number. I want this text to be centered with the
first line being larger than the rest with the name (bold) and size.
On the next line I want item number; next description. I can't get
this to work at all. The only thing I have working is the bold tag and
the line breaks. If I use the {} notation it just prints that out. Is
there some way to create a preview/detail panel like this? If not
binding is there some equivalent to innerHTML? What about the
formatting? The cfdocs say to see the flash docs... still looking
through that now.

Anthony

~|
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:223140
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: [SPAM : 8.1] Re: Rumors from Max...

[Robert Munn]

That was Heaven's Gate. And they lived in Rancho Santa Fe. 

http://www.slate.com/id/2583/

>I think that was the littleendians...
>
>On 11/3/05, Jeff Small <[EMAIL PROTECTED]> wrote:
>> > what exactly are we talking about here?
>>
>> Not really sure...weren't the "Macromedians" those people in San Diego that
>> had the website and all wore Nikes when they committed mass suicide?

~|
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:223139
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: possibly OT: barcode scanning...

[Dick Applebaum]

Andy

2) You can export to a TSV (Tab seperator) that is compatible with  
Excel-- below is a short sample;

you can use any compatible VideoCam, not just an iSight

1)  Might be good justification to buy a $499 Mac mini  :)

Dick

Here's the file:

Header line & 3 lines of CDs  (I put in the - lines  
to show the separation)


medium  associatedURL   boxHeightInInches   boxLengthInInches
boxWeightInPounds   boxWidthInInchesscannednumber   upc asin
country  
title   fullTitle   series  numberInSeries  edition aspect  mediacount  
genre
price   currentValuelanguagenetrating   description owner   
publisher
published   rarepurchaseDaterating  usedsigned  hasExperienced  
notes
locationpaidcondition   notownedartist  conductor   
tracks  tracklisting 
minutes

music   0075992414821   
B65M05  uk  Appetite for destruction  
(1987)  Appetite for destruction (1987) Audio CD
£5.83 
£2.39
03-11-2005  


music   0074646729328   
B02B9T  uk  Day Day Audio CD/ 
Import 
£12.99   £5.004.5 Kenneth "Babyface" Edmonds is 
pop's  
best melodic writer since the heyday of Stevie Wonder and Paul  
McCartney. On The Day, Babyface makes that connection explicit by co- 
writing "How Come, How Long" with Wonder, who also contributes a duet  
vocal, a harmonica solo, and long-time bassist Nathan East to the  
session. Even more impressive is the fact that the eight songs  
Babyface wrote for The Day without his hero's help also boast  
yearning melodies and ear-opening chord changes that are absolutely  
Wonder-ful. --Geoffrey Himes ENDSony29-10-1996  
 
20-08-2005  
BabyfaceEverytime I Close My Eyes/ Talk To Me/  
I Said I Love You/ When Your Body Gets Weak/ Simple Days/ All Day  
Thinkin'/ Seven Seas/ The Day (That You Gave Me A Son)/ How Come, How  
Long/ This Is For The Lover In You  

music   0074643556323   
B025E6  us  Some Enchanted Evening  Some  
Enchanted Evening   Audio CD
Album-Oriented Rock (AOR)/ Arena Rock
$9.98   $3.93   4.5 Sony1990-10-25 12:00:00 
+   2005-11-03  
15:59:01 -0800  
Blue Öyster Cult R.U. Ready 2 Rock/  
E.T.I. (Extra Terrestrial Intelligence)/ Astronomy/ Kick Out The  
Jams/ Godzilla/ (Don't Fear) The Reaper/ We Gotta Get Out Of This Place 



On Nov 3, 2005, at 1:56 PM, Andy Matthews wrote:

> Dick...
>
> That software was actually my first thought. But:
> 1) I don't have a mac.
> 2) I don't know if that software would be able to export  
> information to an
> Excel or CSV file.
>
> i wrote to the programmer (email addy found on their website) to  
> ask him
> about the export option. We'll see what he says. If that's the case  
> then
> I've got a friend with an iBook and an iSight. I'd be happy to  
> purchase the
> software and borrow his computer for a while.
>
>  andy matthews
> web developer
> ICGLink, Inc.
> [EMAIL PROTECTED]
> 615.370.1530 x737
> --//->
>
> -Original Message-
> From: Dick Applebaum [mailto:[EMAIL PROTECTED]
> Sent: Thursday, November 03, 2005 3:03 PM
> To: CF-Talk
> Subject: Re: possibly OT: barcode scanning...
>
>
> Have a look at Delicious Library:
>
> http://www.delicious-monster.com/
>
> It uses a videcam to scan barcodes (Books, CDs, DVDs, Games) then
> retrieves the appropriate descriptive info from the web
>
> HTH
>
> Dick
>
>
> 

~|
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:223138
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: Cfchart hanging

[James Holmes]

Do you use sandboxing? If so, allow the sandbox access to the the
chart cache directory.

On 11/3/05, Snake <[EMAIL PROTECTED]> wrote:
> Got this very basic code on a page, but cfchart just hangs, and nothing
> happens, the page just seems to endlessly load forever.
> Anyone got an idea why?
> I do have the CFIDE and JrunScripts vDIR's in palce.
>
> 
> 
> 
> 
> 
> 
> 
> 

~|
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:223136
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: XOR

[Michael Dinowitz]

I already have examples of MOD in use. It's some of the rairer ones that I'd 
like different examples of and if they happen to be real examples, all the 
better. Anyone can make up an example such as the smoker/blue hair but showing 
a code snippet where it's actually in use brings the concept home a lot better. 

>And here I was hoping MOD would be next on the list.  I find that to be
>fairly useful in regular coding for all sorts of things.
>
>-Justin 
>
>
>>

~|
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:223137
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: XOR

[C. Hatton Humphrey]

> 
> Winner!
> 

> 
> Winner!
> 

These two are not logically eqivalent.  An Exclusive OR (XOR) follows
a logic pattern like this:

A | B |  A XOR B
0 | 0 |   0
1 | 0 |   1
0 | 1 |   1
1 | 1 |   0

Hatton

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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223135
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: XOR

[Claude Schneegans]

 >>XOR coerces it's operands to boolean, while NEQ doesn't.

Exact.
But what I mean is that if someone has to use an XOR operator, the 
situation is actually a NEQ issue,
he will think of NEQ first, and do what must be done to make sure both 
operands are boolean.

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
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:223134
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: XOR

[Justin D. Scott]

And here I was hoping MOD would be next on the list.  I find that to be
fairly useful in regular coding for all sorts of things.

-Justin 


> -Original Message-
> From: Michael Dinowitz [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, November 03, 2005 5:32 PM
> To: CF-Talk
> Subject: Re: XOR
> 
> That will be the next question. :)
> 
> 
> > I've never had a need for it, but I've found imp to be 
> useful sometimes.
> >
> > -Original Message-
> > From: Michael Dinowitz [mailto:[EMAIL PROTECTED]
> > Sent: Friday, 4 November 2005 11:00 a.m.
> > To: CF-Talk
> > Subject: XOR
> >
> > ColdFusion comparison statements (CFIF, etc.) support the XOR joiner
> > between clauses. This is used as such:
> > clause1 XOR clause2
> > This says that either clause1 or clause2 has to be true for the
> > statement to be true. If both are true or both are false, then the
> > entire statement is false. My question is: can anyone think 
> of a real
> > world example where you would need a statement like this?
> >
> >
> >
> >
> >
> > 
> 
> 

~|
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:223133
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: [QUARRANTINE] XOR

[Ben Doom]

If it's actually a bit-level operation, rather than a pure boolean, then 
it can be used for bitmasking, which is used a lot in things like 
cryptography.

On a pure boolean level, I've used the equivalent in PHP for checking 
certain bizzare bits of logic in an online implementation of some 
red-tape infested bureaucratic regulations.

--Ben

Michael Dinowitz wrote:
> ColdFusion comparison statements (CFIF, etc.) support the XOR joiner between 
> clauses. This is used as such:
> clause1 XOR clause2
> This says that either clause1 or clause2 has to be true for the statement to 
> be true. If both are true or both are false, then the entire statement is 
> false. My question is: can anyone think of a real world example where you 
> would need a statement like this?
> 
> 
> 
> 

~|
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:223126
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: Caching, caching what is doing all this caching?!

[jonese]

there is a known issue with DW that if you use it to upload files to the
server that the date timestamp doesn't get updated.

the fix is to turn off (uncheck) maintain synchronization information within
each site definition

jonese

On 11/3/05, Kay Smoljak <[EMAIL PROTECTED]> wrote:
>
> On 11/4/05, Beru <[EMAIL PROTECTED]> wrote:
> > I had the same kind of probs, a few times already... nothing to do with
> DW
> > though (I use notepad ;-))). I also noticed it depends on the file size,
> so
> > I just went on adding lots of CR/LF at the end of the file to force a
> > refresh (dirty, but hey...), I also used this script (don't remember its
> > name) to re-generate the compiled code, this works too...
> >
> > But I'd really like to have a solution (CF MX6.1)... Upgrade?
>
> I've had that too but only on CFMX 7 :(
>
> Dave Watts suggested it could be a time difference between my
> workstation and the server, but turns out they're the same.
>
> --
> Kay Smoljak
> http://kay.smoljak.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:223129
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

Verity, am missing something?

[jonese]

I just installed the 30 day trial for cf 7 one a new box and there is no
"ColdFusion MX 7 Search Server" listed in my list of services.

I looked through the log and i don't see any errors, and i know i checked it
off. I've even gone so far as to reinstall the entire server again but still
nothing.

anyone know why i wouldn't have the search services? Without this i'm not
able to create my verity collections

thoughts, ideas...

jonese


~|
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:223124
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: XOR

[Barney Boisvert]

What about "no" XOR 0?  That's a false statement, while "no" NEQ 0 is
true.  If CF were a strongly typed language and you could enforce the
"boolean-ness" of the operands, then it'd be true, but that's not the
case.  XOR coerces it's operands to boolean, while NEQ doesn't.

cheers,
barneyb

On 11/3/05, Claude Schneegans <[EMAIL PROTECTED]> wrote:
>  >>real world example where you would need a statement like this?
>
> Not really, actually, because (a XOR b) is equivalent to (a NEQ b) which
> is much more intuitive.
>


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

Got Gmail? I have 100 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:223132
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: XOR

[Matthew Walker]

I've never had a need for it, but I've found imp to be useful sometimes.

-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED] 
Sent: Friday, 4 November 2005 11:00 a.m.
To: CF-Talk
Subject: XOR

ColdFusion comparison statements (CFIF, etc.) support the XOR joiner
between clauses. This is used as such:
clause1 XOR clause2
This says that either clause1 or clause2 has to be true for the
statement to be true. If both are true or both are false, then the
entire statement is false. My question is: can anyone think of a real
world example where you would need a statement like this?





~|
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:223120
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 join a table to a set of values not in a table.

[Sam]

SELECT aDATE, DATEcol, VALUEcol
FROM aTABLE,
 (


SELECT TO_DATE('#myMonth#/#i#/2005', 'mm/dd/') aDATE FROM 
DUAL 
 
 UNION SELECT TO_DATE('#myMonth#/#i#/2005', 'mm/dd/') aDATE 
FROM
DUAL 
 

)
WHERE aDATE = DATEcol (+)
ORDER BY aDATE


On 11/3/05, Ian Skinner wrote:
> So, if I was passing in date values from CF, is there a way to simplify the 
> to_date stuff?  Do I need to?
>
>
> --
> 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:223128
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: XOR

[Claude Schneegans]

 >>real world example where you would need a statement like this?

Not really, actually, because (a XOR b) is equivalent to (a NEQ b) which 
is much more intuitive.

-- 
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.


~|
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:223127
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: XOR

[Matthew Walker]

But in this example you couldn't tolerate somebody who had neither blue
hair nor smoke. You just killed off your ideal matches ;-)

Perhaps:


Winner!




I suppose in dating there could only be so much tolerance.  I could
tolerate a smoker, or blue hair, but not both because that would be too
much.


Winner!



~|
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:223125
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: Caching, caching what is doing all this caching?!

[Kay Smoljak]

On 11/4/05, Beru <[EMAIL PROTECTED]> wrote:
> I had the same kind of probs, a few times already... nothing to do with DW
> though (I use notepad ;-))). I also noticed it depends on the file size, so
> I just went on adding lots of CR/LF at the end of the file to force a
> refresh (dirty, but hey...), I also used this script (don't remember its
> name) to re-generate the compiled code, this works too...
>
> But I'd really like to have a solution (CF MX6.1)... Upgrade?

I've had that too but only on CFMX 7 :(

Dave Watts suggested it could be a time difference between my
workstation and the server, but turns out they're the same.

--
Kay Smoljak
http://kay.smoljak.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:223122
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: XOR

[Michael Dinowitz]

That will be the next question. :)


> I've never had a need for it, but I've found imp to be useful sometimes.
>
> -Original Message-
> From: Michael Dinowitz [mailto:[EMAIL PROTECTED]
> Sent: Friday, 4 November 2005 11:00 a.m.
> To: CF-Talk
> Subject: XOR
>
> ColdFusion comparison statements (CFIF, etc.) support the XOR joiner
> between clauses. This is used as such:
> clause1 XOR clause2
> This says that either clause1 or clause2 has to be true for the
> statement to be true. If both are true or both are false, then the
> entire statement is false. My question is: can anyone think of a real
> world example where you would need a statement like this?
>
>
>
>
>
> 

~|
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:223130
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: XOR

[Michael Dinowitz]

> That is an odd one, it doesn't seem like it would be used a whole lot.
I'm doing a complete review of comparisons statements in CF and it's one of 
the joiners allowed. Even if they're never used, I have to cover them. :)

As for the bitwise xor, I'll deal with that later. 


~|
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:223131
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: new next primary key value in Oracle

[Nick Han]

Use DUAL.

Step 1
Select WIDGETS_PKSEQ.NEXTVAL from dual

Step 2
Insert into WIDGETS using WIDGETS_PKSEQ.NEXTVAL

Step 3
Insert into child table of WIDGETS using value from step 1.



-Original Message-
From: Cornillon, Matthieu (Consultant)
[mailto:[EMAIL PROTECTED] 
Sent: Thursday, November 03, 2005 10:52 AM
To: CF-Talk
Subject: OT: new next primary key value in Oracle

Hi, everyone.  I have been doing something for years that works, but
feels darned silly.  I have a table called WIDGETS.  I have a sequence
set to increment by 1 up to some ridiculous number called WIDGETS_PKSEQ.
When I add a new row to WIDGETS, I put WIDGETS_PKSEQ.NEXTVAL into
WIDGETS.pkWIDG, the primary key for the table.  Often, immediately after
creating a new row in WIDGETS, I want to create a row in another table
that references that new row in WIDGETS: for example,
ORDERS.fkORD_pkWIDG refers to WIDGETS.pkWIDG.  But to do that, I need to
get that new WIDGETS.pkWIDG value, which has never actually appeared on
the ColdFusion side of the transaction; it's all in Oracle.  So, I do
this ridiculous thing where I generate a random (and safely unique
value), write it to some row in WIDGETS on the new row creation, look it
up to get the new pk, then overwrite that row with the appropriate value
it should have had in the first place, and then continue, now that
ColdFusion has the new pk value known.  There's got to be a better way!
I know I am missing something easy.

Any thoughts?

Matthieu



~|
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:223116
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 if template is isn a specific folder

[dave]

however if i do something like this (below) it doesnt work
I can put it on indiv pages with a message instead of header and it works
but as it is it just shows the non admin header

examples
http://65.36.226.10/content/contact.cfm
http://65.36.226.10/admin/news/addNews.cfm

in application.cfc











 

~Dave the disruptor~
"Some people just don't appreciate how difficult it is to dispense wisdom and 
abuse at the same time." 


From: "Bobby Hartsfield" <[EMAIL PROTECTED]>
Sent: Thursday, November 03, 2005 8:02 AM
To: CF-Talk 
Subject: RE: determining if template is isn a specific folder 

You should be able to get what you need from this
#GetDirectoryFromPath(GetCurrentTemplatePath())#

...:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: dave [mailto:[EMAIL PROTECTED] 
Sent: Thursday, November 03, 2005 1:30 AM
To: CF-Talk
Subject: determining if template is isn a specific folder

i want to check to see if the page is sitting with a certain folder and then
run some code (in Application.cfc) I know how to do it with a specific file
like index.cfm but what about a folder?

say if the folder is "stuff" and there is a folder tree like so

root
 stuff
 admin
 stlesheets
 images
 cfcs

and im i want to look and see if the template being called is from the
"stuff" folder, how would i pick that out?

can I use "contains", i tried it but no luck

~Dave the disruptor~
"Some people just don't appreciate how difficult it is to dispense wisdom
and abuse at the same time." 



~|
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:223123
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: Caching, caching what is doing all this caching?!

[Sean Corfield]

On 11/2/05, Ian Skinner <[EMAIL PROTECTED]> wrote:
> Now that I got most of my crunch out of the way, I did some experimenting.  I 
> noticed that DW8 had not replaced my DW7, even though it did copy all my 
> settings.  Rather nice of Eight I think.  So, I loaded up Seven and did a 
> handful of trials.  I had no problems.  So it does seem to be some artifice 
> of DW8, but then why does bouncing the CF Application service, solve the 
> clear the caching behavior?

I suspect that DW8 handles file timestamps differently to DW7. How
closely synchronized are the clocks on your workstation (where you
edit the file) and your server? You might try turning OFF the
"Maintain synchronization information" option in the "Remote Info"
panel of your site definition and see if that makes a difference.
--
Sean A Corfield -- http://corfield.org/
Got frameworks?

"If you're not annoying somebody, you're not really alive."
-- Margaret Atwood

~|
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:223118
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: determining if template is isn a specific folder

[dave]

well what i am trying todo on this one is put everything into 1 Application.cfc 
instead of 2

so in this perticular case I am using xhtml strict and no tables, i make a 
template and cut the code in half for a header and footer and the admin sction 
is the same but it gets a diff pic on banner so I want to check and see if the 
user is in the admin section and if so use a diff header and footer.

and then of course to do things such as check for logins and add code to only 
pages that need it like js files and to switch css files too.

So on those pages I put the simple script to see if it would pick out if you 
are in the admin or not and it works fine
then i move the script to application.cfc and replace the words with includes 
to the diff headers and footers and it doesnt work.
But yeah i put them on the pages to make sure that "contains" would work and it 
does.

And yes I outputed the  # GetDirectoryFromPath(GetCurrentTemplatePath())#

I have no idea either why the headers and footers arent being switched 
either

it will end up being "user error" u can bet on that though! ;)~

~Dave the disruptor~
"Some people just don't appreciate how difficult it is to dispense wisdom and 
abuse at the same time." 


From: "Bobby Hartsfield" <[EMAIL PROTECTED]>
Sent: Thursday, November 03, 2005 4:58 PM
To: CF-Talk 
Subject: RE: determining if template is isn a specific folder 

I'm not sure what you're saying. I see (what appear to be the correct)
messages on those pages.

"this page IS NOT nested in the admin structure"
on the admin page

"this page IS nested in the admin structure"
on the other page

I haven't used "contains" so I don't know if that might be causing a problem
or not.

You're not new to this so I'm sure you've output 
# GetDirectoryFromPath(GetCurrentTemplatePath())# to see what it actual has
in it. 

Since you are displaying the conditional messages, I don't see why your
header variable would be any different.

...:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com

-Original Message-
From: dave [mailto:[EMAIL PROTECTED] 
Sent: Thursday, November 03, 2005 2:10 PM
To: CF-Talk
Subject: RE: determining if template is isn a specific folder

however if i do something like this (below) it doesnt work
I can put it on indiv pages with a message instead of header and it works
but as it is it just shows the non admin header

examples
http://65.36.226.10/content/contact.cfm
http://65.36.226.10/admin/news/addNews.cfm

in application.cfc

~Dave the disruptor~
"Some people just don't appreciate how difficult it is to dispense wisdom
and abuse at the same time." 


From: "dave" 
Sent: Thursday, November 03, 2005 1:36 PM
To: CF-Talk 
Subject: RE: determining if template is isn a specific folder 

yup that works :)
I was doing the same thing with cgi scope but wouldnt work, didnt even think
bout this one.
Thanks

~Dave the disruptor~
"Some people just don't appreciate how difficult it is to dispense wisdom
and abuse at the same time." 


From: "Bobby Hartsfield" 
Sent: Thursday, November 03, 2005 8:02 AM
To: CF-Talk 
Subject: RE: determining if template is isn a specific folder 

You should be able to get what you need from this
#GetDirectoryFromPath(GetCurrentTemplatePath())#

..:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: dave [mailto:[EMAIL PROTECTED] 
Sent: Thursday, November 03, 2005 1:30 AM
To: CF-Talk
Subject: determining if template is isn a specific folder

i want to check to see if the page is sitting with a certain folder and then
run some code (in Application.cfc) I know how to do it with a specific file
like index.cfm but what about a folder?

say if the folder is "stuff" and there is a folder tree like so

root
 stuff
 admin
 stlesheets
 images
 cfcs

and im i want to look and see if the template being called is from the
"stuff" folder, how would i pick that out?

can I use "contains", i tried it but no luck

~Dave the disruptor~
"Some people just don't appreciate how difficult it is to dispense wisdom
and abuse at the same time." 



~|
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:223121
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: XOR

[Jerry Johnson]

I used it constantly back in the old days setting bit flags in registers.

You can use it for setting parity bit for checksums.
You can use it to swap the values of two variables without the need
for a third temp variable.


On 11/3/05, Justin D. Scott <[EMAIL PROTECTED]> wrote:
> > clause1 XOR clause2
>
> I suppose in dating there could only be so much tolerance.  I could tolerate
> a smoker, or blue hair, but not both because that would be too much.
>
> 
> Winner!
> 
>
> Not practical really.  I don't think I've ever actually seen anyone use XOR
> in my 6+ years of CF coding.  I'm sure someone has, but nobody I've worked
> with.
>
>
> -Justin 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:223119
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: "Limit" or "Top" and mySQL Question

[Lewis Sellers]

>> A. "SELECT TOP 50" doesn't work in mySQL. "Top" is
>> only SQL
>>  Server, correct?
>> B. "From Shows Limit 50" returns an error as well.
>>

To further elaborate on your question...

Question: Is it "Shows" or "shows"? Case makes a difference (between  
platforms). As a general rule it's best to have all MySQL table names  
be lowercase.

--min
http://www.intrafoundation.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:223117
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: XOR

[Barney Boisvert]

That's a binary XOR, not a boolean XOR.  I actually just wrote a
binaryXOR function last week (it's on my blog: barneyb.com) while I
was   bum-ba-da-bum ... doing some encryption stuff.  Specifically
reverse engineering cfusion_encrypt and cfusion_decrypt into CFML UDFs
(also available on my blog).

cheers,
barneyb

On 11/3/05, Steve Brownlee <[EMAIL PROTECTED]> wrote:
> The only widespread use I've seen for XOR is in basic encryption algorithms.
> Never seen it used outside that.
>
> > -Original Message-
> > From: Michael Dinowitz [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, November 03, 2005 4:46 PM
> > To: CF-Talk
> > Subject: XOR
> >
> > ColdFusion comparison statements (CFIF, etc.) support the XOR
> > joiner between clauses. This is used as such:
> > clause1 XOR clause2
> > This says that either clause1 or clause2 has to be true for
> > the statement to be true. If both are true or both are false,
> > then the entire statement is false. My question is: can
> > anyone think of a real world example where you would need a
> > statement like this?
> >

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

Got Gmail? I have 100 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:223114
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: XOR

[Jerry Johnson]

We've got an argument

Everyone agrees


Remember that "true" is not just a boolean, it means zero or not zero
Remember that you can group these together with NOT, AND, OR, etc.


On 11/3/05, Michael Dinowitz <[EMAIL PROTECTED]> wrote:
> ColdFusion comparison statements (CFIF, etc.) support the XOR joiner between 
> clauses. This is used as such:
> clause1 XOR clause2
> This says that either clause1 or clause2 has to be true for the statement to 
> be true. If both are true or both are false, then the entire statement is 
> false. My question is: can anyone think of a real world example where you 
> would need a statement like this?
>
>
>
> 

~|
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:223115
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

CF webservice consumed via .NET

[Bryan Stevenson]

Hey All,

I've read lots of old posts saying the WDSL datatype of "QueryBean" (which is 
what CF queries get passed as from CF web services).  I can't find anything 
recent..

One old post says nothing but CF can convert that datatype back into a query

So...can .NET consume CF web service that returns a query?  If so...please shed 
some light ;-)

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:223110
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: Call for speakers CFUNITED-06 due 11/18/05 and CCS interview with Sandra Clark

[Steve Brownlee]

I'll 2nd that.  Seven months is a huge amount of time when it comes to most
technical fields.  Who knows what new technology or idea will arise in that
time?  Heck, Flex 2 Alpha just got released but since it won't be official
for a few more months, then I guess it won't be a session.

> -Original Message-
> From: Sean Corfield [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, November 03, 2005 4:04 PM
> To: CF-Talk
> Subject: Re: Call for speakers CFUNITED-06 due 11/18/05 and 
> CCS interview with Sandra Clark
> 
> On 11/2/05, Michael Smith <[EMAIL PROTECTED]> wrote:
> > Check out the CFUNITED-06 ColdFusion conference news below.
> 
> > * CFUNITED-06 is announced for 6/28/06 - 7/1/06 in the
> >   Washington DC area.
> >
> > * If you want to speak or want to suggest a topic for
> >   someone else to speak please complete the form at CFUNITED
> > http://.cfunited.com/
> >   by Friday 11/18/05.  We are looking forward to making CFUNITED-06
> >   even better than last year!
> 
> That seems like a really early deadline! Seven months ahead of the
> conference... a lot can happen in seven months in the web world. How
> can people know what they'd like to hear talks on that far in advance?
> How can folks know what they might want to speak about that far in
> advance?
> 
> Am I the only one that thinks seven months is a little unrealistic?
> (quite possibly :)
> --
> Sean A Corfield -- http://corfield.org/
> Got frameworks?
> 
> "If you're not annoying somebody, you're not really alive."
> -- Margaret Atwood

~|
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:223113
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: XOR

[Raster, Tim]

Elect Kerry

Re-elect Bush

Move to France



-Original Message-
From: Michael Dinowitz [mailto:[EMAIL PROTECTED] 
Sent: Thursday, November 03, 2005 15:46
To: CF-Talk
Subject: XOR

ColdFusion comparison statements (CFIF, etc.) support the XOR joiner
between clauses. This is used as such:
clause1 XOR clause2
This says that either clause1 or clause2 has to be true for the
statement to be true. If both are true or both are false, then the
entire statement is false. My question is: can anyone think of a real
world example where you would need a statement like this?





~|
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:223111
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: XOR

[Justin D. Scott]

> clause1 XOR clause2

I suppose in dating there could only be so much tolerance.  I could tolerate
a smoker, or blue hair, but not both because that would be too much.


Winner!


Not practical really.  I don't think I've ever actually seen anyone use XOR
in my 6+ years of CF coding.  I'm sure someone has, but nobody I've worked
with.


-Justin 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:223112
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: possibly OT: barcode scanning...

[Andy Matthews]

Dick...

That software was actually my first thought. But:
1) I don't have a mac.
2) I don't know if that software would be able to export information to an
Excel or CSV file.

i wrote to the programmer (email addy found on their website) to ask him
about the export option. We'll see what he says. If that's the case then
I've got a friend with an iBook and an iSight. I'd be happy to purchase the
software and borrow his computer for a while.



-Original Message-
From: Dick Applebaum [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 03, 2005 3:03 PM
To: CF-Talk
Subject: Re: possibly OT: barcode scanning...


Have a look at Delicious Library:

http://www.delicious-monster.com/

It uses a videcam to scan barcodes (Books, CDs, DVDs, Games) then
retrieves the appropriate descriptive info from the web

HTH

Dick


~|
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:223108
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: determining if template is isn a specific folder

[Bobby Hartsfield]

I'm not sure what you're saying. I see (what appear to be the correct)
messages on those pages.

"this page IS NOT nested in the admin structure"
on the admin page

"this page IS nested in the admin structure"
on the other page

I haven’t used "contains" so I don’t know if that might be causing a problem
or not.



You're not new to this so I'm sure you've output 
# GetDirectoryFromPath(GetCurrentTemplatePath())# to see what it actual has
in it. 

Since you are displaying the conditional messages, I don’t see why your
header variable would be any different.
 
..:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com

-Original Message-
From: dave [mailto:[EMAIL PROTECTED] 
Sent: Thursday, November 03, 2005 2:10 PM
To: CF-Talk
Subject: RE: determining if template is isn a specific folder

however if i do something like this (below) it doesnt work
I can put it on indiv pages with a message instead of header and it works
but as it is it just shows the non admin header

examples
http://65.36.226.10/content/contact.cfm
http://65.36.226.10/admin/news/addNews.cfm

in application.cfc













~Dave the disruptor~
"Some people just don't appreciate how difficult it is to dispense wisdom
and abuse at the same time." 


From: "dave" <[EMAIL PROTECTED]>
Sent: Thursday, November 03, 2005 1:36 PM
To: CF-Talk 
Subject: RE: determining if template is isn a specific folder 

yup that works :)
I was doing the same thing with cgi scope but wouldnt work, didnt even think
bout this one.
Thanks

~Dave the disruptor~
"Some people just don't appreciate how difficult it is to dispense wisdom
and abuse at the same time." 


From: "Bobby Hartsfield" 
Sent: Thursday, November 03, 2005 8:02 AM
To: CF-Talk 
Subject: RE: determining if template is isn a specific folder 

You should be able to get what you need from this
#GetDirectoryFromPath(GetCurrentTemplatePath())#

.:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: dave [mailto:[EMAIL PROTECTED] 
Sent: Thursday, November 03, 2005 1:30 AM
To: CF-Talk
Subject: determining if template is isn a specific folder

i want to check to see if the page is sitting with a certain folder and then
run some code (in Application.cfc) I know how to do it with a specific file
like index.cfm but what about a folder?

say if the folder is "stuff" and there is a folder tree like so

root
 stuff
 admin
 stlesheets
 images
 cfcs

and im i want to look and see if the template being called is from the
"stuff" folder, how would i pick that out?

can I use "contains", i tried it but no luck

~Dave the disruptor~
"Some people just don't appreciate how difficult it is to dispense wisdom
and abuse at the same time." 





~|
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:223107
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: XOR

[Steve Brownlee]

The only widespread use I've seen for XOR is in basic encryption algorithms.
Never seen it used outside that.

> -Original Message-
> From: Michael Dinowitz [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, November 03, 2005 4:46 PM
> To: CF-Talk
> Subject: XOR
> 
> ColdFusion comparison statements (CFIF, etc.) support the XOR 
> joiner between clauses. This is used as such:
> clause1 XOR clause2
> This says that either clause1 or clause2 has to be true for 
> the statement to be true. If both are true or both are false, 
> then the entire statement is false. My question is: can 
> anyone think of a real world example where you would need a 
> statement like this?
> 
> 
> 
\
> 

~|
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:223109
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: XOR

[Munson, Jacob]

Maybe for data integrity checks?  A record has to be dated in 2005 or
2004, but not both, and not before 2004?  Of course then a data range
would work just as well...

That is an odd one, it doesn't seem like it would be used a whole lot.

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, November 03, 2005 2:46 PM
> To: CF-Talk
> Subject: XOR
> 
> ColdFusion comparison statements (CFIF, etc.) support the XOR 
> joiner between clauses. This is used as such:
> clause1 XOR clause2
> This says that either clause1 or clause2 has to be true for 
> the statement to be true. If both are true or both are false, 
> then the entire statement is false. My question is: can 
> anyone think of a real world example where you would need a 
> statement like this?


[INFO] -- Access Manager:
This transmission may contain information that is privileged, confidential 
and/or exempt from disclosure under applicable law.  If you are not the 
intended recipient, you are hereby notified that any disclosure, copying, 
distribution, or use of the information contained herein (including any 
reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in 
error, please immediately contact the sender and destroy the material in its 
entirety, whether in electronic or hard copy format.  Thank you.   A2



~|
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:223106
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

XOR

[Michael Dinowitz]

ColdFusion comparison statements (CFIF, etc.) support the XOR joiner between 
clauses. This is used as such:
clause1 XOR clause2
This says that either clause1 or clause2 has to be true for the statement to be 
true. If both are true or both are false, then the entire statement is false. 
My question is: can anyone think of a real world example where you would need a 
statement like this?



~|
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:223105
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 join a table to a set of values not in a table.

[Ian Skinner]

So, if I was passing in date values from CF, is there a way to simplify the 
to_date stuff?  Do I need to?


--
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:223104
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: Call for speakers CFUNITED-06 due 11/18/05 and CCS interview with Sandra Clark

[Dave Carabetta]

On 11/3/05, Sean Corfield <[EMAIL PROTECTED]> wrote:
> On 11/2/05, Michael Smith <[EMAIL PROTECTED]> wrote:
> > Check out the CFUNITED-06 ColdFusion conference news below.
> 
> > * CFUNITED-06 is announced for 6/28/06 - 7/1/06 in the
> >   Washington DC area.
> >
> > * If you want to speak or want to suggest a topic for
> >   someone else to speak please complete the form at CFUNITED
> > http://.cfunited.com/
> >   by Friday 11/18/05.  We are looking forward to making CFUNITED-06
> >   even better than last year!
>
> That seems like a really early deadline! Seven months ahead of the
> conference... a lot can happen in seven months in the web world. How
> can people know what they'd like to hear talks on that far in advance?
> How can folks know what they might want to speak about that far in
> advance?
>
> Am I the only one that thinks seven months is a little unrealistic?
> (quite possibly :)

That was my thought exactly. Let's be blunt with an example: Flex 2
and ColdFusion integration is going to be an extremely hot topic, but
won't be out until at least Q1 2006. Based on the deadline, there will
be nothing Flex 2-related at CFUNITED, which would be a shame. Was the
deadline a mis-print perhaps (hopefully)?

Regards,
Dave.

~|
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:223103
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 join a table to a set of values not in a table.

[Ian Skinner]

SELECT aDATE, DATEcol, VALUEcol
FROM aTABLE,
 (SELECT TO_DATE('09/01/2005', 'mm/dd/') aDATE FROM DUAL UNION  SELECT 
TO_DATE('09/02/2005', 'mm/dd/') aDATE FROM DUAL UNION  SELECT 
TO_DATE('09/03/2005', 'mm/dd/') aDATE FROM DUAL UNION  SELECT 
TO_DATE('09/04/2005', 'mm/dd/') aDATE  FROM DUAL UNION  SELECT 
TO_DATE('09/05/2005', 'mm/dd/') aDATE  FROM DUAL) WHERE aDATE = DATEcol (+) 
ORDER BY aDATE

Sam

Ok, I think that might be what I was looking for.  A bit clunky, but not nearly 
as clunky as all the other solutions I have attempted today. 

I will be replacing this with a Stored Procedure, but this allows me more time 
to learn how to do that, and not have to figure out SP's and then right a 
fairly advanced one, all in one day.  Yeah!!!

--
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:223102
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 join a table to a set of values not in a table.

[Cornillon, Matthieu \(Consultant\)]

Ian Skinner wrote:
We are also using Oracle here as well.  Your idea would probably work,
except Queries of Queries only supports inner joins.  A limitation I
have butted heads with on several occasions.


Bummer.  I can't think of a query-returning option, then.  I would pull
all the Oracle data into queries or maybe one query, then loop over my
date range and check against the pulled query results as I went.  Not
neat, I'm afraid.

Good luck.

~|
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:223087
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: First ever SP, on Oracle even.

[Aaron Rouse]

I do not have a link handy but there is a little tutorial on MACRs site that
shows you the basics in building one. Might be worth searching for.

On 11/3/05, Ian Skinner <[EMAIL PROTECTED]> wrote:
>
> I am beginning an attempt to write my very first stored procedure. This
> will be on an Oracle 8i system and will be used to return data to a CFMX7
> application. But I am having trouble finding a good straight forward how to
> information on doing just this. Also I am finding lots of information on why
> SP's are good for you and your database, and interesting treatises on
> specific aspects of Oracle SP.
>
> But I would really like is a simple, step by step, hello world level guide
> on creating the SP, collecting some data, maybe a loop and/or a branch, and
> return a result to a CF page. Any pointers anybody?
>
>
> --
> 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:223085
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: First ever SP, on Oracle even.

[Steve Brownlee]

http://www.talkingtree.com/blog/index.cfm?mode=entry&entry=B37A824E-50DA-0559
-A08F2CDFB58A8248 

> -Original Message-
> From: Ian Skinner [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, November 03, 2005 3:21 PM
> To: CF-Talk
> Subject: First ever SP, on Oracle even.
> 
> I am beginning an attempt to write my very first stored 
> procedure.  This will be on an Oracle 8i system and will be 
> used to return data to a CFMX7 application.  But I am having 
> trouble finding a good straight forward how to information on 
> doing just this.  Also I am finding lots of information on 
> why SP's are good for you and your database, and interesting 
> treatises on specific aspects of Oracle SP.   
> 
> But I would really like is a simple, step by step, hello 
> world level guide on creating the SP, collecting some data, 
> maybe a loop and/or a branch, and return a result to a CF 
> page.  Any pointers anybody?
> 
> 
> --
> Ian Skinner
> Web Programmer
> BloodSource
> www.BloodSource.org
> Sacramento, CA
> 

~|
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:223086
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 join a table to a set of values not in a table.

[Sam]

SELECT aDATE, DATEcol, VALUEcol
FROM aTABLE,
 (SELECT TO_DATE('09/01/2005', 'mm/dd/') aDATE FROM DUAL UNION
 SELECT TO_DATE('09/02/2005', 'mm/dd/') aDATE FROM DUAL UNION
 SELECT TO_DATE('09/03/2005', 'mm/dd/') aDATE FROM DUAL UNION
 SELECT TO_DATE('09/04/2005', 'mm/dd/') aDATE  FROM DUAL UNION
 SELECT TO_DATE('09/05/2005', 'mm/dd/') aDATE  FROM DUAL)
WHERE aDATE = DATEcol (+)
ORDER BY aDATE



On 11/3/05, Ian Skinner wrote:
> Say one has a table something like this (much simpler then the table I am 
> working with, but should suffice for an example).
>
> aTABLE
> DATEcol VALUEcol
> --- 
> 9/1/05  Red
> 9/3/05  Blue
> 9/5/05  Green
>
> I would like to create a result set that looks like this.
>
> aResult
> aDATE  DATEcol VALUEcol
> -- --- 
> 9/1/05 9/1/05  Red
> 9/2/05 NULLNULL
> 9/3/05 9/3/05  Blue
> 9/4/05 NULLNULL
> 9/5/05 9/5/05  Green
>
> I imagine that I would create some kind of inline select or from table, but I 
> can't visulize how I would do this.  Is it possible?
>
> The date range will be dynamic so I don't really want to create some table 
> that has all possible dates for all of time, it would be a bit large I 
> believe.
>

~|
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:223101
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

First ever SP, on Oracle even.

[Ian Skinner]

I am beginning an attempt to write my very first stored procedure.  This will 
be on an Oracle 8i system and will be used to return data to a CFMX7 
application.  But I am having trouble finding a good straight forward how to 
information on doing just this.  Also I am finding lots of information on why 
SP's are good for you and your database, and interesting treatises on specific 
aspects of Oracle SP.   

But I would really like is a simple, step by step, hello world level guide on 
creating the SP, collecting some data, maybe a loop and/or a branch, and return 
a result to a CF page.  Any pointers anybody?


--
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:223084
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: First ever SP, on Oracle even.

[Aaron Rouse]

We have had 10g since it came out, a few months after we got it we upgraded
to 9i, we are still on 9i. So our definition of soon here would be "too damn
long"

On 11/3/05, Ian Skinner <[EMAIL PROTECTED]> wrote:
>
>
> Define "soon". I know we have 9i installation disks around here. I here
> DBA's talking about "upgrading". But I have know idea when it will happen.
> But, boy am I looking forward to that day. I can use "INNER JOIN" and "OUTER
> JOIN" and all that goodness, instead of WHERE Afield = Bfield(+) stuff.
>
>
> --
> 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.
>
>
>
>
> 

~|
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:223100
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: "Limit" or "Top" and mySQL Question (hes alive!)

[Emmet McGovern]

I thought you were dead!!!  ;)

-Original Message-
From: Lewis Sellers [mailto:[EMAIL PROTECTED] 
Sent: Thursday, November 03, 2005 3:13 PM
To: CF-Talk
Subject: Re: "Limit" or "Top" and mySQL Question

I believe you've answered yourself in your subject. It's called LIMIT  
in mysql, and it's slightly more flexible than using TOP.


SELECT Airdates.ShowID FROM shows LIMIT 30;

shows only the first 30 records returned from the query.


SELECT Airdates.ShowID FROM shows LIMIT 10,30;

shows records 10 through 40.


--min
http://www.intrafoundation.com


 > Using a mySQL Database with thousands of records.
 > For the query below,
 > to optimize performance, I'd like to be able to
 > return on the TOP N records.
 >
 > A. "SELECT TOP 50" doesn't work in mySQL. "Top" is
 > only SQL
 >  Server, correct?
 > B. "From Shows Limit 50" returns an error as well.
 >
 > 1. What's the equal of "TOP" in mySQL?
 > 2. At what point in the query is that actually
 > evaluated?
 > I don't want the first 50 records, I want the
 > first
 > TOP records out of all of them according to the
 > sort.




~|
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:223083
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: "Limit" or "Top" and mySQL Question

[Lewis Sellers]

I believe you've answered yourself in your subject. It's called LIMIT  
in mysql, and it's slightly more flexible than using TOP.


SELECT Airdates.ShowID FROM shows LIMIT 30;

shows only the first 30 records returned from the query.


SELECT Airdates.ShowID FROM shows LIMIT 10,30;

shows records 10 through 40.


--min
http://www.intrafoundation.com


 > Using a mySQL Database with thousands of records.
 > For the query below,
 > to optimize performance, I'd like to be able to
 > return on the TOP N records.
 >
 > A. "SELECT TOP 50" doesn't work in mySQL. "Top" is
 > only SQL
 >  Server, correct?
 > B. "From Shows Limit 50" returns an error as well.
 >
 > 1. What's the equal of "TOP" in mySQL?
 > 2. At what point in the query is that actually
 > evaluated?
 > I don't want the first 50 records, I want the
 > first
 > TOP records out of all of them according to the
 > sort.


~|
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:223082
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: First ever SP, on Oracle even.

[Ian Skinner]

Well I was assuming he'll migrate to 9i soon (since 8i support is going away). 
Plus the 9i book will note every feature that is new to 9i. Most of the 
differences are ANSI though, no major difference in PL/SQL itself.

-Adam

Define "soon".  I know we have 9i installation disks around here.  I here DBA's 
talking about "upgrading".  But I have know idea when it will happen.  But, boy 
am I looking forward to that day.  I can use "INNER JOIN" and "OUTER JOIN" and 
all that goodness, instead of WHERE Afield = Bfield(+) stuff.


--
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:223099
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: new next primary key value in Oracle

[Aaron Rouse]

That has never worked for me within a cfquery. I have seen some on here say
it worked for them so guessing it is some sort of driver issue between
versions.

On 11/3/05, Adrocknaphobia <[EMAIL PROTECTED]> wrote:
>
> What about:
>
> INSERT INTO Widgets()
> RETURNING key AS newID
>
> I've never tried to use it within a , but it works fine in
> storedProcs. (Which, btw, I recommend you use over inline queries)
>
> -Adam
>
>


~|
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:223081
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: Call for speakers CFUNITED-06 due 11/18/05 and CCS interview with Sandra Clark

[Ryan Guill]

I can agree...

On 11/3/05, Sean Corfield <[EMAIL PROTECTED]> wrote:
>
> That seems like a really early deadline! Seven months ahead of the
> conference... a lot can happen in seven months in the web world. How
> can people know what they'd like to hear talks on that far in advance?
> How can folks know what they might want to speak about that far in
> advance?
>
> Am I the only one that thinks seven months is a little unrealistic?
> (quite possibly :)
> --
> Sean A Corfield -- http://corfield.org/
> Got frameworks?
>
> "If you're not annoying somebody, you're not really alive."
> -- Margaret Atwood
>

--
Ryan Guill
BlueEyesDevelopment
[EMAIL PROTECTED]
www.ryanguill.com
(270) 217.2399
got google talk?  Chat me at [EMAIL PROTECTED]

The Coldfusion Open Application Library - COAL - http://coal.ryanguill.com

www.ryanguill.com/
The Roman Empire: www.ryanguill.com/blog/

~|
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:223098
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: determining if template is isn a specific folder

[dave]

however if i do something like this (below) it doesnt work
I can put it on indiv pages with a message instead of header and it works
but as it is it just shows the non admin header

examples
http://65.36.226.10/content/contact.cfm
http://65.36.226.10/admin/news/addNews.cfm

in application.cfc













~Dave the disruptor~
"Some people just don't appreciate how difficult it is to dispense wisdom and 
abuse at the same time." 


From: "dave" <[EMAIL PROTECTED]>
Sent: Thursday, November 03, 2005 1:36 PM
To: CF-Talk 
Subject: RE: determining if template is isn a specific folder 

yup that works :)
I was doing the same thing with cgi scope but wouldnt work, didnt even think 
bout this one.
Thanks

~Dave the disruptor~
"Some people just don't appreciate how difficult it is to dispense wisdom and 
abuse at the same time." 


From: "Bobby Hartsfield" 
Sent: Thursday, November 03, 2005 8:02 AM
To: CF-Talk 
Subject: RE: determining if template is isn a specific folder 

You should be able to get what you need from this
#GetDirectoryFromPath(GetCurrentTemplatePath())#

:.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
-Original Message-
From: dave [mailto:[EMAIL PROTECTED] 
Sent: Thursday, November 03, 2005 1:30 AM
To: CF-Talk
Subject: determining if template is isn a specific folder

i want to check to see if the page is sitting with a certain folder and then
run some code (in Application.cfc) I know how to do it with a specific file
like index.cfm but what about a folder?

say if the folder is "stuff" and there is a folder tree like so

root
 stuff
 admin
 stlesheets
 images
 cfcs

and im i want to look and see if the template being called is from the
"stuff" folder, how would i pick that out?

can I use "contains", i tried it but no luck

~Dave the disruptor~
"Some people just don't appreciate how difficult it is to dispense wisdom
and abuse at the same time." 



~|
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:223097
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: First ever SP, on Oracle even.

[Ian Skinner]

Ian,

Have you ever written any stored procedures for any other RDBM?

Bob Everland

Nope, I've used them but other people had created the ones I used.  Creating 
one is a first for me.

--
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:223096
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: First ever SP, on Oracle even.

[Adrocknaphobia]

Well I was assuming he'll migrate to 9i soon (since 8i support is
going away). Plus the 9i book wil note every feature that is new to
9i. Most of the differences are ANSI though, no major difference in
PL/SQL itself.

-Adam

On 11/3/05, Aaron Rouse <[EMAIL PROTECTED]> wrote:
> Wouldn't he be better tracking down a 8i PL\SQL book? Probably could find it
> used for next to nothing.
>
> On 11/3/05, Adrocknaphobia <[EMAIL PROTECTED]> wrote:
> >
> > Make sure to organize your procedures in packages. Keeps everything
> > nice and tidy in the database.
> >
> > Pick up the PL\SQL book from Oracle Press
> >
> > http://www.amazon.com/gp/product/0072191473/104-9480893-1129539?v=glance&n=283155&n=507846&s=books&v=glance
> >
> > -Adam
> >
> >
>
>
> 

~|
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:223095
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: Call for speakers CFUNITED-06 due 11/18/05 and CCS interview with Sandra Clark

[Sean Corfield]

On 11/2/05, Michael Smith <[EMAIL PROTECTED]> wrote:
> Check out the CFUNITED-06 ColdFusion conference news below.

> * CFUNITED-06 is announced for 6/28/06 - 7/1/06 in the
>   Washington DC area.
>
> * If you want to speak or want to suggest a topic for
>   someone else to speak please complete the form at CFUNITED
> http://.cfunited.com/
>   by Friday 11/18/05.  We are looking forward to making CFUNITED-06
>   even better than last year!

That seems like a really early deadline! Seven months ahead of the
conference... a lot can happen in seven months in the web world. How
can people know what they'd like to hear talks on that far in advance?
How can folks know what they might want to speak about that far in
advance?

Am I the only one that thinks seven months is a little unrealistic?
(quite possibly :)
--
Sean A Corfield -- http://corfield.org/
Got frameworks?

"If you're not annoying somebody, you're not really alive."
-- Margaret Atwood

~|
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:223094
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: possibly OT: barcode scanning...

[Dick Applebaum]

Have a look at Delicious Library:

http://www.delicious-monster.com/

It uses a videcam to scan barcodes (Books, CDs, DVDs, Games) then  
retrieves the appropriate descriptive info from the web

HTH

Dick


On Nov 3, 2005, at 3:31 AM, Andy wrote:

> -Original Message-
> From: Andy Matthews [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 02, 2005 9:22 AM
> To: CF-Talk
> Subject: possibly OT: barcode scanning...
>
> This isnt' a CF question directly, but there might be a CF related  
> answer so
> I'll ask it here anyway.
>
> My wife is getting ready to start a business selling CDs for on  
> half.com.
> A friend who is planning on taking Jaime up on the offer, has over  
> 1000 CDs
> which would take QUITE a long time to catalog. My thought is to get a
> barcode scanner and whip them all out.
>
> I wonder if anyone has done this before for their own collection  
> and would
> care to share their method.
>
>
> andy

~|
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:223093
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: Finding top ranked articles

[Brian Peddle]

Then Alans will work. 

-Original Message-
From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED] 
Sent: Thursday, November 03, 2005 10:02 AM
To: CF-Talk
Subject: Re: Finding top ranked articles

Brian,

The main problem with that however is that i have no way of knowing  
when somebody visited the site so I can pick out the top ranked  
articles from the previous 12 hours.

Thanks,

Saturday


On 3 Nov 2005, at 14:39, Brian Peddle wrote:

> Why does it matter if someone already viewed the article?  If you  
> are going
> to remove historical data anyway, after 14 hours, what does it  
> matter if the
> person visited 2 hours later or 15 hours later.  What about people  
> using
> proxy servers, you may be blocking out unique views.
>
> I think I would axe that, add a column to the article table called  
> views.
> Create a stored proc or query that selects the article and then  
> does an
> update.  Update article_table set views = views + 1.  Or something  
> like
> that.
>
> Then no need to worry about space and scheduling a delete.
>
> -Original Message-
> From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED]
> Sent: Thursday, November 03, 2005 8:48 AM
> To: CF-Talk
> Subject: Finding top ranked articles
>
> Hi guys,
>
> Late last night in a matter of moments I found myself creating a
> table called tbl_020articleTopRanked .  The idea was to do something
> similar to news stories where they display their 5 top-viewed
> articles (like at SMH: http://www.smh.com.au - at the bottom end of
> the page).
>
> So in my creation I created this table and put 4 fields there,
> topRankedID (PK - incrementing), articleID (ID of the article which
> has just been viewed), dateViewed (when it was viewed) and lastly
> ipAddress (client's IP address).
>
> Each time the page gets viewed a check is made to see whether this IP
> has already viewed the page in the last few hours.  If they have then
> an insert doesn't happen but if they haven't then a record is  
> inserted.
>
> It all works fine and I'm very happy, but i'm just trying to work out
> the best way to work out what are the top viewed pages in the last 12
> hours.  I also will create a script to delete, say, all inserts over
> 14 hours old so that i'm not using too much MS-SQL space (this i'll
> do as a CFSCHEDULE or get the hosting company to set up a schedule to
> run that script.
>
> Any advice or help would be greatly appreciated.
>
> Thanks,
>
> Saturday
>
>
>
>
>
> 



~|
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:223080
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: Finding top ranked articles

[Justin D. Scott]

> Why does it matter if someone already viewed
> the article?

I actually think that tracking page views and having time limits on counters
is a good approach if you have the time.  I run a link database that tracks
clicks on the links.  If someone clicks the same link more than once within
six hours, it only counts once.  In my situation links are marked as
"popular" of they are within the top 5% by clicks, so this helps prevent
people from clicking, hitting back, and clicking again multiple times to
inflate their rankings.  Clicks are tracked by IP, but I don't worry much
about proxy servers for this purpose.

Here's the code if the original poster can use it.  Watch for line wrapping.

-Justin





DELETE FROM click WHERE cliDateStamp <= DATEADD(hh, -6, getdate())




SELECT cliID FROM click
WHERE linID = 
AND cliIP = 






UPDATE link SET
linHitCountCurrent = linHitCountCurrent + 1,
linHitCountTotal = linHitCountTotal + 1
WHERE linID = 




INSERT INTO click VALUES (
,
getdate(),

)


 



~|
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:223079
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: First ever SP, on Oracle even.

[Aaron Rouse]

Wouldn't he be better tracking down a 8i PL\SQL book? Probably could find it
used for next to nothing.

On 11/3/05, Adrocknaphobia <[EMAIL PROTECTED]> wrote:
>
> Make sure to organize your procedures in packages. Keeps everything
> nice and tidy in the database.
>
> Pick up the PL\SQL book from Oracle Press
>
> http://www.amazon.com/gp/product/0072191473/104-9480893-1129539?v=glance&n=283155&n=507846&s=books&v=glance
>
> -Adam
>
>


~|
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:223092
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: "Limit" or "Top" and mySQL Question (hes alive!)

[Lewis Sellers]

On Nov 3, 2005, at 3:22 PM, Emmet McGovern wrote:

> I thought you were dead!!!  ;)

Um... That was an unexpected response.

No. Not dead. Just away... fighting evil in another dimension. Etc. :)


More seriously, true, I have been out of the scene for a while. About  
a year. However about a month or so ago my (new) wife (and I) decided  
it would be nice to be able to work together at home ... Etc. So... 

Among other things, I've been rebuilding the old intrafoundation.com  
website this last week. Just uploaded the very newest, freshly  
packed, viri-scanned versions of several old CFXs and COMs (i.e.  
tcpclient, IHK, etc.) All available, as per usual, free of charge.  
[True side-note: with I think it was 3 hours or so after I put  
intrafoundation I get 2 unsolicited pleas for copies of tcpclient.  
Now the site hasn't been up in months remember. Jeez.]

Anyway, if your next statement to me was to try to hit me up for a  
spare copy of tcpclient or something :-P

--min

>
> -Original Message-
> From: Lewis Sellers [mailto:[EMAIL PROTECTED]
> Sent: Thursday, November 03, 2005 3:13 PM
> To: CF-Talk
> Subject: Re: "Limit" or "Top" and mySQL Question
>
> I believe you've answered yourself in your subject. It's called LIMIT
> in mysql, and it's slightly more flexible than using TOP.
>
>
> SELECT Airdates.ShowID FROM shows LIMIT 30;
>
> shows only the first 30 records returned from the query.
>
>
> SELECT Airdates.ShowID FROM shows LIMIT 10,30;
>
> shows records 10 through 40.
>
>
> --min
> http://www.intrafoundation.com
>
>
>> Using a mySQL Database with thousands of records.
>> For the query below,
>> to optimize performance, I'd like to be able to
>> return on the TOP N records.
>>
>> A. "SELECT TOP 50" doesn't work in mySQL. "Top" is
>> only SQL
>>  Server, correct?
>> B. "From Shows Limit 50" returns an error as well.
>>
>> 1. What's the equal of "TOP" in mySQL?
>> 2. At what point in the query is that actually
>> evaluated?
>> I don't want the first 50 records, I want the
>> first
>> TOP records out of all of them according to the
>> sort.
>
>
>
>
> 

~|
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:223091
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: First ever SP, on Oracle even.

[Adrocknaphobia]

Make sure to organize your procedures in packages. Keeps everything
nice and tidy in the database.

Pick up the PL\SQL book from Oracle Press
http://www.amazon.com/gp/product/0072191473/104-9480893-1129539?v=glance&n=283155&n=507846&s=books&v=glance

-Adam

On 11/3/05, Robert Everland III <[EMAIL PROTECTED]> wrote:
> Ian,
>
>
> Have you ever written any stored procedures for any other RDBM?
>
>
>
>
> Bob Everland
>
> 

~|
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:223090
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: possibly OT: barcode scanning...

[Andy]

Not sure how this will help.  The bar code contained on a record will give
you an item number for the recording label.  You will need access to a
database that can take that number and return the album info. 

-Original Message-
From: Andy Matthews [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, November 02, 2005 9:22 AM
To: CF-Talk
Subject: possibly OT: barcode scanning...

This isnt' a CF question directly, but there might be a CF related answer so
I'll ask it here anyway.

My wife is getting ready to start a business selling CDs for on half.com.
A friend who is planning on taking Jaime up on the offer, has over 1000 CDs
which would take QUITE a long time to catalog. My thought is to get a
barcode scanner and whip them all out.

I wonder if anyone has done this before for their own collection and would
care to share their method.


andy







~|
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:223078
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: new next primary key value in Oracle

[Adrocknaphobia]

What about:

INSERT INTO Widgets()
RETURNING key AS newID

I've never tried to use it within a , but it works fine in
storedProcs. (Which, btw, I recommend you use over inline queries)

-Adam

On 11/3/05, Cornillon, Matthieu (Consultant)
<[EMAIL PROTECTED]> wrote:
> I LOVE DUAL!
>
> Thanks!  I'll be doing more research on this.
>
> Matthieu
>
> Deanna Schneider wrote:
>
> You're new to dual? Dual is just a wonderful little "widget" that acts
> like a one row "table," but the column is arbitrary. You can do all
> sorts of stuff with it:
>
> select sysdate from dual;
>
> select 1 + 1 from dual;
>
> select 'I am not a crook' from dual;
>
> select ucase('malkjdflajldjflajdlfj') from dual;
>
> You get the idea.
>
> 

~|
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:223076
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: First ever SP, on Oracle even.

[Robert Everland III]

Ian,


Have you ever written any stored procedures for any other RDBM?




Bob Everland

~|
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:223089
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 Administrator bug in CFMX 7.0.1

[Adrocknaphobia]

lol. I remember this bug with the JRun Admin. How did it find it's way into CF?

-Adam

On 11/3/05, wolf2k5 <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I  think I found a bug in ColdFusion Administrator's "Java and JVM"
> settings for CFMX 7.0.1 on Linux (server install).
>
> I changed the "Maximum JVM Heap Size (MB)" from 512 to 768 and I
> restarted the CF service to have the changes take effect.
>
> It didn't come back!
>
> I checked the 'cfserver.log' file and there were a bunch of error messages:
>
> /opt/coldfusionmx7/runtime/lib/updates: directory does not exist,
> hotfixes cannot be applied
> no such classpath element: /opt/coldfusionmx7/runtime/gateway/lib/
> no such classpath element:
> /opt/coldfusionmx7/runtime/wwwroot/WEB-INF/cfform/jars
> java.lang.ClassNotFoundException
>at 
> coldfusion.bootstrap.BootstrapClassLoader.loadClass(BootstrapClassLoader.java:229)
>at java.lang.ClassLoader.loadClass(Unknown Source)
>at 
> coldfusion.bootstrap.ClassloaderHelper.initFilterClass(ClassloaderHelper.java:125)
>at coldfusion.bootstrap.BootstrapFilter.init(BootstrapFilter.java:34)
>at jrun.servlet.FilterObject.init(FilterObject.java:63)
>at jrun.servlet.FilterManager.loadFilter(FilterManager.java:195)
>at jrun.servlet.FilterManager.init(FilterManager.java:155)
>at jrun.servlet.FilterManager.create(FilterManager.java:74)
>at 
> jrun.servlet.WebApplicationService.start(WebApplicationService.java:223)
>at jrun.ea.EnterpriseApplication.start(EnterpriseApplication.java:194)
>at 
> jrun.deployment.DeployerService.initModules(DeployerService.java:710)
>   at 
> jrun.deployment.DeployerService.createWatchedDeployment(DeployerService.java:242)
>at jrun.deployment.DeployerService.deploy(DeployerService.java:430)
>at 
> jrun.deployment.DeployerService.handleEvent(DeployerService.java:381)
>   at 
> jrunx.kernel.JRunServiceDeployer.fireEvent(JRunServiceDeployer.java:710)
>at 
> jrunx.kernel.JRunServiceDeployer.deployServices(JRunServiceDeployer.java:111)
>at 
> jrunx.kernel.DeploymentService.loadServices(DeploymentService.java:46)
>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
>at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
>at java.lang.reflect.Method.invoke(Unknown Source)
>at 
> com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
>at 
> com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
>at jrunx.kernel.JRun.startServer(JRun.java:575)
>at jrunx.kernel.JRun.(JRun.java:493)
>at jrunx.kernel.JRun$1.run(JRun.java:346)
>at java.security.AccessController.doPrivileged(Native Method)
>at jrunx.kernel.JRun.start(JRun.java:343)
>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
>at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
>at java.lang.reflect.Method.invoke(Unknown Source)
>at jrunx.kernel.JRun.invoke(JRun.java:180)
>at jrunx.kernel.JRun.main(JRun.java:168)
>
> I finally tracked down the issue to the 'jvm.config' file (updated by
> the CF Administrator) having incorrect paths for the classPath setting
> ..
>
> The original version of the file had the following setting:
>
> -Dcoldfusion.classPath={application.home}/../lib/updates,{application.home}/../lib,{application.home}/../gateway/lib/,{application.home}/../wwwroot/WEB-INF/cfform/jars
>
> The new version had the following setting:
>
> -Dcoldfusion.classPath={application.home}/lib/updates,{application.home}/lib,{application.home}/gateway/lib/,{application.home}/wwwroot/WEB-INF/cfform/jars
>
> Notice that the paths are missing the "../" part, that caused the CF
> service start failure.
>
> How do I report this bug to Macromedia?
>
> Thanks.
>
> 

~|
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:223075
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: new next primary key value in Oracle

[Cornillon, Matthieu \(Consultant\)]

I LOVE DUAL!

Thanks!  I'll be doing more research on this.

Matthieu

Deanna Schneider wrote:

You're new to dual? Dual is just a wonderful little "widget" that acts
like a one row "table," but the column is arbitrary. You can do all
sorts of stuff with it:

select sysdate from dual;

select 1 + 1 from dual;

select 'I am not a crook' from dual;

select ucase('malkjdflajldjflajdlfj') from dual;

You get the idea.

~|
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:223074
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 MX 7 : New Features Survey

[Adrocknaphobia]

It's not that they are new, it's that they need much improvement.

-Adam


On 11/3/05, Andrew Scott <[EMAIL PROTECTED]> wrote:
> Even though I have just come across this thread, I find it funny that the
> following
>
> Reporting
> Verity Search
> Clustering
> CFChart
>
> Are actually considered new features.
>
> Reporting via cfreport has been there for a long time so this is actually
> enhanced, Verity Search Enhanced, Clustering been not sure if this has been
> enhanced but been around in enterprise versions for a long time, and cfchart
> has been around for a number of versions as well.
>
>
> Regards,
> Andrew Scott
>
> Quote of the Day:
> Pleasure and joy are deceptive
> -Original Message-
> From: Mike Klostermeyer [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, 27 September 2005 3:47 AM
> To: CF-Talk
> Subject: RE: ColdFusion MX 7 : New Features Survey
>
> Yet the one question that I wanted .NET to appear in (what languages do you
> want CF to interoperate with) the only choices were PHP and Python!  At
> least they provided an 'other' text box for write in votes.
>
> Mike
>
> -Original Message-
> From: Adam Haskell [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 26, 2005 12:38 PM
> To: CF-Talk
> Subject: Re: ColdFusion MX 7 : New Features Survey
>
>
> Anyone esle find it interesting Macromedia ia asking about the .NET
> stuff...heh just found it funny
>
>
> Adam H
>
> On 9/26/05, Calvin Ward <[EMAIL PROTECTED]> wrote:
> >
> > A more work safe analogy couldn't have been used?
> >
> > I mean really.
> >
> > -Original Message-
> > From: Claude Schneegans [mailto:[EMAIL PROTECTED]
> > Sent: Friday, September 23, 2005 1:57 PM
> > To: CF-Talk
> > Subject: Re: ColdFusion MX 7 : New Features Survey
> >
> > >>I agree its written in such a way as to provide skewed results.
> >
> > This is going OT (please CF_comunity paranoids abstain...;-), but I
> > remember
> > a survey I had to compile when I was working in the Computer Center at
> > university.
> > 
> >
> >
> >
>
>
>
>
>
> 

~|
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:223073
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: [CAUTION]Re: [SOT] avg hourly rate for mid and adv cf programmer

[Steve Brownlee]

It depends on the scope and length of contract.  As a solo contrator I've
done work for as low as $60/hr and as high as $180/hr.  Back when I worked
for a consulting firm, I was contracted out at $225/hr.  Obviously *I* didn't
get that money.  I saw only a small fraction of that go into my salary and
the rest went to the accountants.

> -Original Message-
> From: John Lucania [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, November 03, 2005 1:09 PM
> To: CF-Talk
> Subject: [CAUTION]Re: [SOT] avg hourly rate for mid and adv 
> cf programmer
> 
> Holly.  who is getting $200 or more?
> The salary is almost ~ $.5 mil then.
> 
> jl
> 
> On 11/3/05, Lee <[EMAIL PROTECTED]> wrote:
> > I've heard of rates anywhere from $30 to $200 or more for
> > established firms. I've also heard of much less for over
> > seas contractors. Congress is looking at adding another
> > 210,000 or so HB1 Visas which could trend those numbers
> > lower.
> >
> > Lee
> >
> > On Thu, 3 Nov 2005 09:55:15 -0600
> >  "Kevin Aebig" <[EMAIL PROTECTED]> wrote:
> > > Not sure about the DC area, but up here I go with
> > >$35/hour CDN which comes
> > > out to about 4 cents US...
> > >
> > > Kevin
> > >
> > > -Original Message-
> > >From: John Lucania [mailto:[EMAIL PROTECTED]
> > > Sent: November 3, 2005 9:39 AM
> > > To: CF-Talk
> > > Subject: [SOT] avg hourly rate for mid and adv cf
> > >programmer
> > >
> > > Morning, Gurus!
> > >
> > > What is the avg hourly rate for mid and adv cf
> > >programmer for
> > > gov/non-for-profit contract work in Wash DC area and
> > >surburb?The
> > > hourly rate won't include any benefits or whatsoever.
> > >
> > > jl
> > >
> > >
> > >
> > >
> >
> > 
> 
> 

~|
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:223088
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 join a table to a set of values not in a table.

[Ian Skinner]

Ian,

Shouldn't the same technique work, where you do separate outer joins against 
each of those other tables?  I only know Oracle SQL, so I never know how it 
would work in a query of queries (if outer joins are even an option), but I 
would do this in pseudocode:

Matthieu
We are also using Oracle here as well.  Your idea would probably work, except 
Queries of Queries only supports inner joins.  A limitation I have butted heads 
with on several occasions.


--
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:223077
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 MX 7 : New Features Survey

[Andrew Scott]

Even though I have just come across this thread, I find it funny that the
following

Reporting
Verity Search
Clustering
CFChart

Are actually considered new features.

Reporting via cfreport has been there for a long time so this is actually
enhanced, Verity Search Enhanced, Clustering been not sure if this has been
enhanced but been around in enterprise versions for a long time, and cfchart
has been around for a number of versions as well.


Regards,
Andrew Scott
 
Quote of the Day:
Pleasure and joy are deceptive
-Original Message-
From: Mike Klostermeyer [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, 27 September 2005 3:47 AM
To: CF-Talk
Subject: RE: ColdFusion MX 7 : New Features Survey

Yet the one question that I wanted .NET to appear in (what languages do you
want CF to interoperate with) the only choices were PHP and Python!  At
least they provided an 'other' text box for write in votes.

Mike

-Original Message-
From: Adam Haskell [mailto:[EMAIL PROTECTED]
Sent: Monday, September 26, 2005 12:38 PM
To: CF-Talk
Subject: Re: ColdFusion MX 7 : New Features Survey


Anyone esle find it interesting Macromedia ia asking about the .NET
stuff...heh just found it funny


Adam H

On 9/26/05, Calvin Ward <[EMAIL PROTECTED]> wrote:
>
> A more work safe analogy couldn't have been used?
>
> I mean really.
>
> -Original Message-
> From: Claude Schneegans [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 23, 2005 1:57 PM
> To: CF-Talk
> Subject: Re: ColdFusion MX 7 : New Features Survey
>
> >>I agree its written in such a way as to provide skewed results.
>
> This is going OT (please CF_comunity paranoids abstain...;-), but I
> remember
> a survey I had to compile when I was working in the Computer Center at
> university.
> 
>
>
>





~|
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:223072
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: Force PDF Download

[Beru]

You may want to try :



Regards,
Albert


On 02/11/05, Aldon Moore <[EMAIL PROTECTED]> wrote:
>
> Thanks Matt..
>
> Iwill test this method...
>
> Al
>
> -Original Message-
> From: Matt Robertson [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, November 02, 2005 5:19 PM
> To: CF-Talk
> Subject: Re: Force PDF Download
>
>
> Aldon,
>
> I have a tutorial on my site on how to do this, but just to be sure I
> ran it again in FF and IE to make sure it really works.
>
> Here's the base code:
>
> 
> 
> 
> 
> 
>  name="content-disposition"
> value="#DisplayType#; filename=#FileName#">
>  type="#MIMEType#"
> file="#FileToPush#">
>
> The intent of the above is to get a file to display inside of the
> browser, via the Acrobat browser plugin we (probably) all have
> installed. On IE 6 it worked great. On FF 1.0.4 the Acrobat plugin
> splash screen fired up but no display. Same failure across multiple
> attempts.
>
> Next, I changed the value of DisplayType to Attachment.
>
> 
>
> The idea being you want the item to open not inside of the browser,
> but instead you want the actual Acrobat program to open up separately
> and display the file
>
>
> In FF this gave me the open-or-save dialog. Perfect. Same in IE6,
> where I chose Open and the Acrobat plugin loaded separately and
> brought up my file.
>
> It seemed in the beginning you were doing all the stuff I'm doing
> here. If so and you're getting an error I would look to file path
> problems, or naming the thing wrong. Also you have no space before
> your filename= parameter and I use one. Maybe thats it.
>
> --
> --mattRobertson--
> Janitor, MSB Web Systems
> mysecretbase.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:223071
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 Administrator bug in CFMX 7.0.1

[wolf2k5]

Hi,

I  think I found a bug in ColdFusion Administrator's "Java and JVM"
settings for CFMX 7.0.1 on Linux (server install).

I changed the "Maximum JVM Heap Size (MB)" from 512 to 768 and I
restarted the CF service to have the changes take effect.

It didn't come back!

I checked the 'cfserver.log' file and there were a bunch of error messages:

/opt/coldfusionmx7/runtime/lib/updates: directory does not exist,
hotfixes cannot be applied
no such classpath element: /opt/coldfusionmx7/runtime/gateway/lib/
no such classpath element:
/opt/coldfusionmx7/runtime/wwwroot/WEB-INF/cfform/jars
java.lang.ClassNotFoundException
at 
coldfusion.bootstrap.BootstrapClassLoader.loadClass(BootstrapClassLoader.java:229)
at java.lang.ClassLoader.loadClass(Unknown Source)
at 
coldfusion.bootstrap.ClassloaderHelper.initFilterClass(ClassloaderHelper.java:125)
at coldfusion.bootstrap.BootstrapFilter.init(BootstrapFilter.java:34)
at jrun.servlet.FilterObject.init(FilterObject.java:63)
at jrun.servlet.FilterManager.loadFilter(FilterManager.java:195)
at jrun.servlet.FilterManager.init(FilterManager.java:155)
at jrun.servlet.FilterManager.create(FilterManager.java:74)
at 
jrun.servlet.WebApplicationService.start(WebApplicationService.java:223)
at jrun.ea.EnterpriseApplication.start(EnterpriseApplication.java:194)
at jrun.deployment.DeployerService.initModules(DeployerService.java:710)
   at 
jrun.deployment.DeployerService.createWatchedDeployment(DeployerService.java:242)
at jrun.deployment.DeployerService.deploy(DeployerService.java:430)
at jrun.deployment.DeployerService.handleEvent(DeployerService.java:381)
   at 
jrunx.kernel.JRunServiceDeployer.fireEvent(JRunServiceDeployer.java:710)
at 
jrunx.kernel.JRunServiceDeployer.deployServices(JRunServiceDeployer.java:111)
at 
jrunx.kernel.DeploymentService.loadServices(DeploymentService.java:46)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at 
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
at 
com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
at jrunx.kernel.JRun.startServer(JRun.java:575)
at jrunx.kernel.JRun.(JRun.java:493)
at jrunx.kernel.JRun$1.run(JRun.java:346)
at java.security.AccessController.doPrivileged(Native Method)
at jrunx.kernel.JRun.start(JRun.java:343)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at jrunx.kernel.JRun.invoke(JRun.java:180)
at jrunx.kernel.JRun.main(JRun.java:168)

I finally tracked down the issue to the 'jvm.config' file (updated by
the CF Administrator) having incorrect paths for the classPath setting
..

The original version of the file had the following setting:

-Dcoldfusion.classPath={application.home}/../lib/updates,{application.home}/../lib,{application.home}/../gateway/lib/,{application.home}/../wwwroot/WEB-INF/cfform/jars

The new version had the following setting:

-Dcoldfusion.classPath={application.home}/lib/updates,{application.home}/lib,{application.home}/gateway/lib/,{application.home}/wwwroot/WEB-INF/cfform/jars

Notice that the paths are missing the "../" part, that caused the CF
service start failure.

How do I report this bug to Macromedia?

Thanks.

~|
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:223070
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: Rumors from Max...

[Snake]

If I didn't do CF, I would probably do ASP. There isn't anything wrong with
it really.
I have to say, we very rarely have ASP falling over on our servers.

Russ 

-Original Message-
From: dave [mailto:[EMAIL PROTECTED] 
Sent: 03 November 2005 07:36
To: CF-Talk
Subject: Re: Rumors from Max...

swett HAHAHAHAHAHA

and dont forget that classic asp is still a jem lol

~Dave the disruptor~
"Some people just don't appreciate how difficult it is to dispense wisdom
and abuse at the same time." 


From: Rob <[EMAIL PROTECTED]>
Sent: Thursday, November 03, 2005 2:21 AM
To: CF-Talk 
Subject: Re: Rumors from Max... 

Ok, I've had a few vodka tonics so you'll have to excuse me if I don't make
much sense...

"Rumor is, Adobe might release CF to the open source community..."

>From what I have seen that's just nuts - at one of birds of a feather
sessions at MAX, a guy happened to mention that he decompile coldfusion much
to the dismay of some of the cf engineers. One of the comments from the
engineers was something to the effect "if you have to look at the source
code, then we are not doing our job". Yes you can get PHP or .net free, but
you know what - those suck. They don't totally blow, and they have their
place for sure, but the power you get with CF ... which becomes a J2EE
application ... it's RAD. Nothing has touched it yet.

Net sucks, let's be honest - it's lame for desktop programmers and it's
lame for web developers for different reasons. It totally misses the mark
from both sides. PHP is like perl but weirder. Sure it's free, and if you
need it it'll do the job, but what frame of reference are new coders coming
from? All that perl or C code they've been writing?

All that babble aside, when I was in newton a while ago, I had the fortune
of hanging out with Forta - from our conversation I can tell you CF is
pretty popular in a lot of areas that never make the headlines - it provides
a good revenue stream for MM. Why would they just let that go? The product
is strong and in a lot of places you might not even consider.

If anything I hope they open source fireworks... please don't let that one
die in the shadow of photoshop send me the code I'll keep it up :)

apologies for my drunken ramblings...

On 11/1/05, Jeff Small  wrote:
>
> Okay, I'll go first...
>
> "Rumor is, Adobe might release CF to the open source community..."
>
> That was the best one I heard...any others have any wild ones to report?
>
>
> 





~|
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:223069
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: new next primary key value in Oracle

[Aaron Rouse]

It was more of a quick solution, I'd probably do the SP route and not like
that would be a long and dirty solution or anything.

On 11/3/05, Cornillon, Matthieu (Consultant) <[EMAIL PROTECTED]>
wrote:
>
> Aaron,
>
> This is another good solution.
>
> Thanks,
> Matthieu
>
>


~|
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:223068
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: new next primary key value in Oracle

[Cornillon, Matthieu \(Consultant\)]

Yet another good answer.  Thanks, gang, for sending these in.  At least
one will do the trick.

Matthieu

Matt Small wrote:
One idea, if it's possible - pass all of this information at once into a
stored procedure, which would know the newly created row id know what
number to use.

~|
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:223067
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 join a table to a set of values not in a table.

[Cornillon, Matthieu \(Consultant\)]

Ian,

Shouldn't the same technique work, where you do separate outer joins
against each of those other tables?  I only know Oracle SQL, so I never
know how it would work in a query of queries (if outer joins are even an
option), but I would do this in pseudocode:

qTable1
SELECT Letters FROM Table1 WHERE KEY >= Variables.MinValue AND KEY <=
Variables.MaxValue

qTable2
SELECT Colors FROM Table2 WHERE KEY >= Variables.MinValue AND KEY <=
Variables.MaxValue

qTable3
SELECT Names FROM Table3 WHERE KEY >= Variables.MinValue AND KEY <=
Variables.MaxValue

qRange
(This is the dynamically generated one that has qRange.KEY from
Variables.MinValue to Variables.MaxValue)

qJoin
SELECT qRange.KEY, qTable1.Letters, qTable2.Colors, qTable3.Names
FROM qRange, qTable1, qTable2, qTable3
WHERE qRange.KEY = qTable1.KEY (+)
AND qRange.KEY = qTable2.KEY (+)
AND qRange.KEY = qTable3.KEY (+)
ORDER BY qRange.KEY

You should get NULLs everywhere where there is no match, but the rest
should work out.  Again, though, I can't remember if this is allowed in
Q of Qs.

Matthieu

That would probably work to solve the problem as I presented it.  But
the problem I was trying to solve is that I join several tables against
the key value and I need them to show up whether the first value exists
or not.  Trouble is that I can not guarantee any table in the set will
have a complete range of values to join against.

A more complete example:

Table1
Key Letters
--- -
1   A
3   B
5   C

Table2
Key Colors
--- --
1   Blue
2   Green
3   Red

Table3
Key Names
--- -
3   Joe
5   Sam

The result set I'm looking for with a range between 1 and 5 should look
something like this:

Key Letters Colors Names
--- --- -- -
1   A   Blue   NULL
2   NULLGreen  NULL
3   B   RedJoe
4   NULLNULL   NULL
5   C   NULL   Sam

~|
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:223066
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: new next primary key value in Oracle

[Deanna Schneider]

You're new to dual? Dual is just a wonderful little "widget" that acts like
a one row "table," but the column is arbitrary. You can do all sorts of
stuff with it:

select sysdate from dual;

select 1 + 1 from dual;

select 'I am not a crook' from dual;

select ucase('malkjdflajldjflajdlfj') from dual;

You get the idea.


On 11/3/05, Cornillon, Matthieu (Consultant) <[EMAIL PROTECTED]>
wrote:
>
> DUAL?!?!!? That works, and is magic, but, again: ?!?!? I'll have to
> research this. I am sure there is a good reason for it being called
> DUAL. If not, and if this is truly arbitrary, then I am disappointed
> that the folks at Oracle didn't come up with some more colorful name,
> like SPAGHETTIFLASHLIGHT or ARNOLD.
>
> Thanks! This works wonderfully.
>
> Matthieu
>
> Ian Skinner wrote:
>
> When I have run into this, having to put a incremental key value into
> several tables, what I have done is select the WIDGETS_PKSEQ.NEXTVAL and
> then use that value in all my inserts. Somewhat like this off the top
> of my head example.
>
> 
> SELECT
> WIDGETS_PKSEQ.NEXTVAL AS KEY
> FROM dual /*I believe this is the proper 'table'*/
> 
>
> Then I can refer to nextKeyVal.Key in all my inserts. I wrap this all
> up in a  block so that if a problem occurs I hopefully
> don't end up with 1/2 the data saved.
>
> 

~|
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:223065
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: rds remote view shows nothing

[Father Vito Cornelius]

anyone?

On 11/2/05, Father Vito Cornelius <[EMAIL PROTECTED]> wrote:
> i am attempting to connect do a dev machine i have in the basement via
> rds.. when i set it up in dwmx.. i get no error when connecting.. but
> the remote view shows only the folder path i entered when i setup the
> connection... no files.. nothing else..
>
> has anyone else seen this.. or know what the deal is?
>
>
> Crit
>

~|
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:223064
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: new next primary key value in Oracle

[Cornillon, Matthieu \(Consultant\)]

Aaron,

This is another good solution.  

Thanks,
Matthieu

-Original Message-
From: Aaron Rouse [mailto:[EMAIL PROTECTED] 
Sent: Thursday, November 03, 2005 2:08 PM
To: CF-Talk
Subject: Re: new next primary key value in Oracle


You could just run the insert on one table, then select out that new ID
then use it for the other inserts. Something like:  
 INSERT INTO BLAH (COLA) VALUES ('YES')  SELECT MAX(ID) AS NEWID FROM BLAH   INSERT
INTO BLAH2 (COLA, COLB) VALUES ('NO', #QueryName.NewID#)
  With that I assume a trigger is done to get the new
value out of the sequence and it puts it into Blah.ID during the insert.
On 11/3/05, Ian Skinner <[EMAIL PROTECTED]> wrote:
>
> Hi, everyone. I have been doing something for years that works, but 
> feels darned silly. I have a table called WIDGETS. I have a sequence 
> set to increment by 1 up to some ridiculous number called 
> WIDGETS_PKSEQ. When I add a new row to WIDGETS, I put 
> WIDGETS_PKSEQ.NEXTVAL into WIDGETS.pkWIDG, the primary key for the 
> table. Often, immediately after creating a new row in WIDGETS, I want 
> to create a row in another table that references that new row in 
> WIDGETS: for example, ORDERS.fkORD_pkWIDG refers to WIDGETS.pkWIDG. 
> But to do that, I need to get that new WIDGETS.pkWIDG value, which has

> never actually appeared on the ColdFusion side of the transaction; 
> it's all in Oracle. So, I do this ridiculous thing where I generate a 
> random (and safely unique value), write it to some row in WIDGETS on 
> the new row creation, look it up to get the new pk, then overwrite 
> that row with the appropriate value it should have had in the first 
> place, and then continue, now that ColdFusion has the new pk value 
> known. There's got to be a better way! I know I am missing something 
> easy.
>
> Any thoughts?
>
> Matthieu
>
> When I have run into this, having to put a incremental key value into 
> several tables, what I have done is select the WIDGETS_PKSEQ.NEXTVAL 
> and then use that value in all my inserts. Somewhat like this off the 
> top of my head example.
>
> 
> SELECT
> WIDGETS_PKSEQ.NEXTVAL AS KEY
> FROM dual /*I believe this is the proper 'table'*/
> 
>
> Then I can refer to nextKeyVal.Key in all my inserts. I wrap this all 
> up in a  block so that if a problem occurs I hopefully 
> don't end up with 1/2 the data saved.
>
> --
> 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.
>
>
>
>
> 



~|
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:223063
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: error Requested resource 'null' (null) not found with ColdFusion MX 7.0.1

[wolf2k5]

On 11/2/05, wolf2k5 <[EMAIL PROTECTED]> wrote:
> The new ColdFusion MX 7.0.1 installation seems to work fine, but there
> are a bunch of errors in the 'cfserver.log' file:
>
> 11/02 07:39:34 info report
> 11/02 07:39:34 error Requested resource 'null' (null) not found
> 11/02 07:39:46 error Requested resource 'null' (null) not found
> 11/02 07:41:20 error Requested resource 'null' (null) not found
> 11/02 07:41:25 info report
> 11/02 07:41:25 error Requested resource 'null' (null) not found
> 11/02 07:41:32 info report
> 11/02 07:41:32 error Requested resource 'null' (null) not found
> 11/02 07:41:42 error Requested resource 'null' (null) not found
> 11/02 07:43:39 error Requested resource 'null' (null) not found
> 11/02 07:46:05 error Requested resource 'null' (null) not found

Hi,

FYI: I disabled ColdFusion servlet support and the error messages seem gone now.
Tomcat is now handling my servlets.

Thanks.

~|
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:223062
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: new next primary key value in Oracle

[Matthew Small]

One idea, if it's possible - pass all of this information at once into a
stored procedure, which would know the newly created row id know what number
to use.

- Matt Small

-Original Message-
From: Cornillon, Matthieu (Consultant)
[mailto:[EMAIL PROTECTED] 
Sent: Thursday, November 03, 2005 1:52 PM
To: CF-Talk
Subject: OT: new next primary key value in Oracle

Hi, everyone.  I have been doing something for years that works, but
feels darned silly.  I have a table called WIDGETS.  I have a sequence
set to increment by 1 up to some ridiculous number called WIDGETS_PKSEQ.
When I add a new row to WIDGETS, I put WIDGETS_PKSEQ.NEXTVAL into
WIDGETS.pkWIDG, the primary key for the table.  Often, immediately after
creating a new row in WIDGETS, I want to create a row in another table
that references that new row in WIDGETS: for example,
ORDERS.fkORD_pkWIDG refers to WIDGETS.pkWIDG.  But to do that, I need to
get that new WIDGETS.pkWIDG value, which has never actually appeared on
the ColdFusion side of the transaction; it's all in Oracle.  So, I do
this ridiculous thing where I generate a random (and safely unique
value), write it to some row in WIDGETS on the new row creation, look it
up to get the new pk, then overwrite that row with the appropriate value
it should have had in the first place, and then continue, now that
ColdFusion has the new pk value known.  There's got to be a better way!
I know I am missing something easy.

Any thoughts?

Matthieu



~|
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:223061
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 join a table to a set of values not in a table.

[Ian Skinner]

You could do a query of queries.  You dynamically create a query result set 
that has your aDate values (cfloop over the range, and add a new row and value 
on each iteration).  Run a query of your actual db table limited to the dates 
in question.  Then run a query of queries where you do a join (I never remember 
my terms...left outer?) where it's all rows from the generated aDate query set 
and matching values from aTable.  I can't remember if you can do outer joins in 
queries of queries, but I think this would work.

HTH,
Matthieu

That would probably work to solve the problem as I presented it.  But the 
problem I was trying to solve is that I join several tables against the key 
value and I need them to show up whether the first value exists or not.  
Trouble is that I can not guarantee any table in the set will have a complete 
range of values to join against.

A more complete example:

Table1
Key Letters
--- -
1   A
3   B
5   C

Table2
Key Colors
--- --
1   Blue
2   Green
3   Red

Table3
Key Names
--- -
3   Joe
5   Sam

The result set I'm looking for with a range between 1 and 5 should look 
something like this:

Key Letters Colors Names
--- --- -- -
1   A   Blue   NULL
2   NULLGreen  NULL
3   B   RedJoe
4   NULLNULL   NULL
5   C   NULL   Sam



--
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:223060
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: new next primary key value in Oracle

[Cornillon, Matthieu \(Consultant\)]

DUAL?!?!!?  That works, and is magic, but, again: ?!?!?  I'll have to
research this.  I am sure there is a good reason for it being called
DUAL.  If not, and if this is truly arbitrary, then I am disappointed
that the folks at Oracle didn't come up with some more colorful name,
like SPAGHETTIFLASHLIGHT or ARNOLD.

Thanks!  This works wonderfully.

Matthieu

Ian Skinner wrote:

When I have run into this, having to put a incremental key value into
several tables, what I have done is select the WIDGETS_PKSEQ.NEXTVAL and
then use that value in all my inserts.  Somewhat like this off the top
of my head example.


  SELECT
WIDGETS_PKSEQ.NEXTVAL AS KEY
  FROM dual /*I believe this is the proper 'table'*/


Then I can refer to nextKeyVal.Key in all my inserts.  I wrap this all
up in a  block so that if a problem occurs I hopefully
don't end up with 1/2 the data saved.

~|
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:223059
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