RE: cfopenbb

[Bobby Hartsfield]

Look over the bandwidth limitations and unfinished site. It is running on my
local dev server right now but let me know if anything looks useful in my
CF4em. Many of the features in phpbb are there. 

As it stands, I don’t know when Ill ever get the chance to finish it and I
wouldn’t mind seeing some of it go to good use

http://acoderslife.com/msgbrd/


-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED] 
Sent: Friday, August 26, 2005 11:11 PM
To: CF-Talk
Subject: Re: cfopenbb

Same for Galleon as well (ray.camdenfamily.com/forums). I say share
and share alike. As it stands, I'm looking at features from phpBB to
add (most like the next feature in Galleon will be Stickies).

On 8/26/05, Rick Root <[EMAIL PROTECTED]> wrote:
> IMO, more than a few developers can really slow down a project in its
> early stages.
> 
> Feel free though to rape cfmbb (www.cfmbb.org) for any ideas or code.
> 
> Rick
> 
> 
> 



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

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

[Raymond Camden]

Same for Galleon as well (ray.camdenfamily.com/forums). I say share
and share alike. As it stands, I'm looking at features from phpBB to
add (most like the next feature in Galleon will be Stickies).

On 8/26/05, Rick Root <[EMAIL PROTECTED]> wrote:
> IMO, more than a few developers can really slow down a project in its
> early stages.
> 
> Feel free though to rape cfmbb (www.cfmbb.org) for any ideas or code.
> 
> Rick
> 
> 
> 

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

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

[S . Isaac Dealey]

> It will be interesting to see how the project
> moves forward. phpBB is not that complicated
> of an application so my first thought is that
> ~60 developers is overkill but hopefully not...
> The cf community could use some good
> applications like those in the PHP community.

In this vein, if you get a minute (and the server isn't flaking out),
try downloading Blogs onTap from the framework site...
http://www.fusiontap.com/download ... Let me know what you think... I
am of course, not stopping there, although I'm currently working
toward getting the framework site on a more stable server and
hopefully setting up a publicly accessible subversion server as an
alternative means of getting the nightly builds with additional
version info. Once those are done, I'm thinking the next small project
will be a TinyMCE plugin, then I need to rebuild the forum (which I
expect will take me about a week and be a better app -- last version
took a little over 2 weeks iirc), and then will start working on some
other small apps that will be important to my overall plans -- wiki
(probably as another sample app), contacts, calendar, light-weight
CRM.


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

add features without fixtures with
the onTap open source framework

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


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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216579
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: Multiple File Upload

[dave]

You mean not involving muliple FORMS (of course you need multiple form fields) 
or looping, which i gave an example of that till will decided to show us that 
he is planning on dethroning Ben Forta as the King of cfm 
code

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


From: Rick Root <[EMAIL PROTECTED]>
Sent: Friday, August 26, 2005 10:17 PM
To: CF-Talk 
Subject: Re: Multiple File Upload 

I swear the original question had something to do with dealing with 
multiple file uploads in ways not involving multiple form fields and 
looping over them.

Rick



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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216578
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: Multiple File Upload

[Will Tomlinson]

> ok show me where its less code..
  
> so u can add an attribute or set a variable wheres the big discount of 
> code at?

I made an error with your example dave the disruptured. 

It should've been with your #'s:  
> 
 
> You need to not be posting when you are drinking, it turns out kinda 
> like your code lol ;)

I aint drinkin tonight. Maybe I should start though. :)

> 
 
> Hows cart.cfc working? oh yeah you need customers first haha jk


yeah my cart.cfc works just great. It just hasn't tested by that many 
customers. :(


~|
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:216577
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: cfopenbb

[Rick Root]

IMO, more than a few developers can really slow down a project in its 
early stages.

Feel free though to rape cfmbb (www.cfmbb.org) for any ideas or code.

Rick


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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216576
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: Multiple File Upload

[Rick Root]

I swear the original question had something to do with dealing with 
multiple file uploads in ways not involving multiple form fields and 
looping over them.

Rick


~|
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:216575
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: Multiple File Upload

[dave]

thats kinda funny look

 http://www.jamwerx.com/willneedshelp.png

 will, put the long island down and walk away...

 someones not getting a free teen alix membership!!

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


From: Will Tomlinson <[EMAIL PROTECTED]>
Sent: Friday, August 26, 2005 9:47 PM
To: CF-Talk 
Subject: Re: Multiple File Upload 

>> so adding more code to it makes sense to you? well ok, just cause i 
>> know you i can see you thinking that lol

Compare this: result="pic1"

with this: 

Which one is more code? :)



~|
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:216574
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: Multiple File Upload

[dave]

ok show me where its less code..
 and dont use "but its in the new cfwack dude" excuse this time either, get 
your calculator out and count the lines ( hint its the number that comes after 
6 and before 8)
 so u can add an attribute or set a variable wheres the big discount of code at?

 You need to not be posting when you are drinking, it turns out kinda like your 
code lol ;)

 Hows cart.cfc working? oh yeah you need customers first haha jk

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


From: Will Tomlinson <[EMAIL PROTECTED]>
Sent: Friday, August 26, 2005 9:39 PM
To: CF-Talk 
Subject: Re: Multiple File Upload 

> so adding more code to it makes sense to you? well ok, just cause i 
> know you i can see you thinking that lol

This is actually less code dude. Just add an attribute to cffile, done

> and why output it righ there? doesnt it make more sense to set it as a 
> variable so you can do other things with it like insert into a db 
> and/or show back to the submitter?

I just outputed it so you could see it dillweed! lol 
Do whatever you want with the file, I don't care. It's available though. 



~|
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:216573
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: Multiple File Upload

[Will Tomlinson]

>> so adding more code to it makes sense to you? well ok, just cause i 
>> know you i can see you thinking that lol

Compare this:  result="pic1"

with this: 

Which one is more code? :)

~|
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:216572
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: Multiple File Upload

[Will Tomlinson]

> so adding more code to it makes sense to you? well ok, just cause i 
> know you i can see you thinking that lol

This is actually less code dude. Just add an attribute to cffile, done
 
> and why output it righ there? doesnt it make more sense to set it as a 
> variable so you can do other things with it like insert into a db 
> and/or show back to the submitter?

I just outputed it so you could see it dillweed! lol  
Do whatever you want with the file, I don't care. It's available though. 


~|
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:216571
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: cfopenbb

[Michael Tangorre]

> From: Adam Haskell [mailto:[EMAIL PROTECTED] 
> The intial buzz has indeed died but the project has not...its 
> just not moved as fast as some(most) would have liked...the 
> intal buzz was, in my opinion, way too big over 120 
> developers volunteered...I doubt the team is half that size 
> now and development has barely started if at all. Once some 
> of the organization is settled and grup gets trimed down to 
> the core developers/contributors I think the project will 
> move along faster...but thsts just my take :)

It will be interesting to see how the project moves forward. phpBB is not
that complicated of an application so my first thought is that ~60
developers is overkill but hopefully not... The cf community could use some
good applications like those in the PHP community.



~|
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:216570
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: cfopenbb

[Adam Haskell]

The intial buzz has indeed died but the project has not...its just not
moved as fast as some(most) would have liked...the intal buzz was, in
my opinion, way too big over 120 developers volunteered...I doubt the
team is half that size now and development has barely started if at
all. Once some of the organization is settled and grup gets trimed
down to the core developers/contributors I think the project will move
along faster...but thsts just my take :)

Adam H


On 8/26/05, Tangorre, Michael <[EMAIL PROTECTED]> wrote:
> > From: Matt Woodward [mailto:[EMAIL PROTECTED]
> > We're working--if you'd like to see things move faster, feel
> > free to volunteer to help!
> 
> I wasn't criticizing, rather inquiring.
> 
> 

~|
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:216569
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: Multiple File Upload

[dave]

so adding more code to it makes sense to you? well ok, just cause i know you i 
can see you thinking that lol
 and why output it righ there? doesnt it make more sense to set it as a 
variable so you can do other things with it like insert into a db and/or show 
back to the submitter?

 again I don't see where doing more code to do the same thing is a very good 
idea but then again the only good ideas you have are the ones you steal from me!

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


From: Will Tomlinson <[EMAIL PROTECTED]>
Sent: Friday, August 26, 2005 8:51 PM
To: CF-Talk 
Subject: Re: Multiple File Upload 

>(and your post added nothing to the discussion.. of course, neither does 
>this one)

Ok, let me add somethin to the discussion here then. 

As of CFMX7 we can name our own variable for cffile by using the "result" 
attribute. 

 fileField = "FileContents" 
 destination = "#ExpandPath(".")#" 
 nameConflict = "MakeUnique"
 result="filename1">
 #filename1.serverfile#

 #cgi.script_name# 
 name="uploadForm" enctype="multipart/form-data">

:) ???



~|
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:216568
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: Multiple File Upload

[Will Tomlinson]

>(and your post added nothing to the discussion.. of course, neither does 
>this one)

Ok, let me add somethin to the discussion here then. 

As of CFMX7 we can name our own variable for cffile by using the "result" 
attribute. 


   
   
  #filename1.serverfile#

   
   #cgi.script_name# 
  name="uploadForm" enctype="multipart/form-data">
  
  
   
   


:)  ???

~|
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:216567
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: Billing timer application - Was: Tinymce file manager

[Stan Winchester]

Actually we my son wrote a routine for connecting Quickbooks over https to/from 
a CF app. I should talk to him about this.

>Stan, if you could get imports into Quickbooks on that baby, you'd have 
>our business!
>
>Stan Winchester wrote:
>>

~|
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:216566
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: Adobe Version Cue 2 uses MySQL!

[Kevin Aebig]

So Does SQLite and it offers *way* more options. Triggers, stored 
procedures... there's a reason PHP changed over.

Cheers,

Kevin

- Original Message - 
From: "Barney Boisvert" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Friday, August 26, 2005 2:51 PM
Subject: Re: Adobe Version Cue 2 uses MySQL!


> MySQL is acutally used for a lot of embedded stuff.  It's really
> modular, so it can be a very good choice, because you can get exactly
> the pieces you need.  And it doesn't just run on windows, which both
> MSDE and Access are limited to.
>
> cheers,
> barneyb
>
> On 8/26/05, Damien McKenna <[EMAIL PROTECTED]> wrote:
>> I'm used to any time an application needing to install a database layer
>> it either being a custom thing, MSDE or MDB files.  Discovering that
>> MySQL is used was funny because a) it isn't one of the above, b) Adobe
>> have a document management system so I kinda thought they were using a
>> trimmed down version of it, c) MySQL isn't atomic therefore an odd
>> choice.
>>
>
> -- 
> Barney Boisvert
> [EMAIL PROTECTED]
> 360.319.6145
> http://www.barneyb.com/
>
> Got Gmail? I have 50 invites.
>
> 

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

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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216565
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: Billing timer application - Was: Tinymce file manager

[Stan Winchester]

What I do in Quickbook is very simple. Under "Item" is usually select 
"Programming" or "Consulting". In "Description" I reference the billable hours 
pdf file generated by the billing timer application. Enter the qty and rate as 
shown on the pdf and I'm done. My cpa has never complained, and it making 
billings fast and easy.

Stan

>Stan, if you could get imports into Quickbooks on that baby, you'd have 
>our business!
>
>Stan Winchester wrote:
>>

~|
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:216564
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: Billing timer application - Was: Tinymce file manager

[Stan Winchester]

The URL broke, try this instead: 
http://www.aftershockweb.net/forums/conferences.cfm
click on "Aftershock Billable Hours" then "Feature Requests"

> Rick, Thank you and you're very Welcome!!!
> 
> I am hoping to be to soon offer free software too. I've just released 
> another beta version of the Aftershock Forum (see: http://www.
> aftershockweb.net/forums/) and hopefully it will and a couple of other 
> projects I'm working on help pay the bills.
> 
> The project I am thinking of rewriting and making free is an 
> application I wrote years ago as a time tracker using Dreamweaver 
> UltraDev (gag, cough, argh). Needless to say, the code is very ugly 
> and buggy (I've been too lazy to fix it), but it tracks billing hours, 
> creates a pdf billable hours report, stores project settings such as 
> URLs, data source info, user name/passwords, and more. It has helped 
> my billing process a TON! I was wondering if this would be an 
> application others would be interested in, and if so what features 
> would you want? I was going to post the current features, but the list 
> it too long. You can view the list at: http://www.aftershockweb.
> net/forums/messages.cfm/ThreadId/47
> 
> Stan
> 
> >Stan Winchester wrote:
> >> Thanks, that is exactly what I was looking for. It works VERY 
> nicely!
> >
> >
> >Thanks ;)
> >
> >- Rick 
Root

~|
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:216563
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: Billing timer application - Was: Tinymce file manager

[Ray Champagne]

Stan, if you could get imports into Quickbooks on that baby, you'd have 
our business!

Stan Winchester wrote:
> Rick, Thank you and you're very Welcome!!!
> 
> I am hoping to be to soon offer free software too. I've just released another 
> beta version of the Aftershock Forum (see: 
> http://www.aftershockweb.net/forums/) and hopefully it will and a couple of 
> other projects I'm working on help pay the bills.
> 
> The project I am thinking of rewriting and making free is an application I 
> wrote years ago as a time tracker using Dreamweaver UltraDev (gag, cough, 
> argh). Needless to say, the code is very ugly and buggy (I've been too lazy 
> to fix it), but it tracks billing hours, creates a pdf billable hours report, 
> stores project settings such as URLs, data source info, user name/passwords, 
> and more. It has helped my billing process a TON! I was wondering if this 
> would be an application others would be interested in, and if so what 
> features would you want? I was going to post the current features, but the 
> list it too long. You can view the list at: 
> http://www.aftershockweb.net/forums/messages.cfm/ThreadId/47
> 
> Stan
> 
> 
>>Stan Winchester wrote:
>>
>>>Thanks, that is exactly what I was looking for. It works VERY nicely!
>>
>>
>>Thanks ;)
>>
>>- Rick Root
> 
> 
> 

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

Billing timer application - Was: Tinymce file manager

[Stan Winchester]

Rick, Thank you and you're very Welcome!!!

I am hoping to be to soon offer free software too. I've just released another 
beta version of the Aftershock Forum (see: 
http://www.aftershockweb.net/forums/) and hopefully it will and a couple of 
other projects I'm working on help pay the bills.

The project I am thinking of rewriting and making free is an application I 
wrote years ago as a time tracker using Dreamweaver UltraDev (gag, cough, 
argh). Needless to say, the code is very ugly and buggy (I've been too lazy to 
fix it), but it tracks billing hours, creates a pdf billable hours report, 
stores project settings such as URLs, data source info, user name/passwords, 
and more. It has helped my billing process a TON! I was wondering if this would 
be an application others would be interested in, and if so what features would 
you want? I was going to post the current features, but the list it too long. 
You can view the list at: 
http://www.aftershockweb.net/forums/messages.cfm/ThreadId/47

Stan

>Stan Winchester wrote:
>> Thanks, that is exactly what I was looking for. It works VERY nicely!
>
>
>Thanks ;)
>
>- Rick Root

~|
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:216561
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: JDBC nightmare

[Matt Robertson]

Are you doing this to add a dsn programmatically to extend your CFX? Cuz you 
can do it a lot easier in the CF Administrator with just a couple of points 
and clicks. Probably a stupid question for me to ask but I thought I'd do it 
just in case. Sounds like you're trying to edit the xml file manually.

-- 
--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:216560
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 API Question: Writing a Script for ""Clear Template Cache Now""

[Michael Dinowitz]

This method will do it for you:
ClearTrustedCache()

http://www.houseoffusion.com/tiny.cfm/122 

>Hello all,
>
>I'm looking for a way to programmatically perform the same action that 
>the "Clear Template Cache Now" button does.
>
>The "Clear Template Cache Now" button is located in the CF 
>Administrator under Server Settings->Caching and is situated at the 
>bottom of the screen. I'd like to write a script that does the same 
>action but I'm not sure what method to call and what .cfc I should be 
>getting it from. Here's the frame I've tried to put together so far. 
>It's taken pretty much directly from the Macromedia documentation.
>
>
>   // Login is always required. This example uses two lines of code.
>   adminObj = createObject("component","cfide.adminapi.administrator");
>   adminObj.login("admin");
>
>   // Instantiate the data source object.
>   myObj = createObject("component","cfide.adminapi.serverinstance");
>
>
>After this I pretty much don't know where to go from here. Any help 
>would be greatly appreciated.
>
>Thanks,
>CS

~|
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:216559
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: ODBC nightmare

[Matt Robertson]

Its not a bug Claude, its a feature :-)

Figure JDBC has nothing to do with ODBC. So its only natural that a JDBC 
connection doesn't show in the Windows ODBC applet, and anything in the ODBC 
applet is not shown in CF's JDBC dsn list.

If you want to make an odbc data source visible to CF, you set up a dsn as 
type 'ODBC Bridge' ... or something like that.

It doesn't happen under CF5 and prior because, back in the day, CF's DSN 
list was just a different way of looking at the Windows system ODBC DSN 
list. As a user of mySQL I got used to setting up datasources in Windows to 
back-door CF support for that unsupported db. No longer necessary.

Under CF6+, unless you really need to use the slower, more overhead-laden 
ODBC connection its not something you want to play with, and you can and 
should shut off the ColdFusion MX ODBC Agent and ColdFusion MX ODBC Server 
services as they otherwise do absolutely nothing.

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


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

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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216558
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: OT: Backup solution for small business?

[Matt Robertson]

Thats OK. I have personally injected deer and bear with lead. Stand right 
there while I reload...
 :D

-- 
--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:216557
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: OT: Backup solution for small business?

[Rick Root]

I pushed the third button!

Matt Robertson wrote:
> It turns out John Cleese has put together an informative and timely Flash 
> video on this subject. Stumbled across this today while eating lunch. 
>  I just barely avoided spitting my tuna sandwich all over the screen at one 
> point.
>  http://www.backuptrauma.com/video/default2.aspx
>  -- 
> --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:216556
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: Multiple File Upload

[Rick Root]

Seth Bienek wrote:
> The Stickman blog has a cool, cross-browser, single-form implementation that 
> uses DHTML that I have not tried out yet.  But there's a demo on the site 
> and an explanation of how it works:
> http://the-stickman.com/web-development/javascript/upload-multiple-files-with-a-single-file-element

Someone suggested implementing this in CFFM, which I may consider, it's 
"pretty" and much more user friendly.

Of course, it still uses multiple form fields, technically.

Rick



~|
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:216555
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: Multiple File Upload

[Rick Root]

Will,

You made a typo.  You typed "should" when I'm sure you meant "could" 
(and your post added nothing to the discussion.. of course, neither does 
this one)

Rick

Will Tomlinson wrote:
>>
> 
> 
> This doesn't need the #'s. 
> It should be: 
> 
> Same here:
> 
> 
> Should be: 



~|
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:216554
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: NLB and truncated responses from CF7

[Russ]

Well you can try switching to IIS and seeing if the problem goes away...
could it be mod_deflate?  Perhaps the something is getting confused by the
compression of the content and cuts off the page.  I would try turning
mod_deflate off and seeing if that fixes the problem.  If not, try switching
to IIS and see if that fixes it.. 

-Original Message-
From: Brandt, Chris M. [mailto:[EMAIL PROTECTED] 
Sent: Friday, August 26, 2005 3:15 PM
To: CF-Talk
Subject: RE: NLB and truncated responses from CF7

Is anyone using Win2K3 NLB with Apache and Coldfusion? Should I try
switching to IIS?

Chris

___
Chris Brandt, DVM, MS
Instructional Media Development Specialist
http://vetpda.ucdavis.edu
(530) 754-4452
> -Original Message-
> From: Brandt, Chris M.
> Sent: Thursday, August 25, 2005 5:12 PM
> To: CF-Talk
> Subject: NLB and truncated responses from CF7
> 
> If this post appears in multiple locations, I apologize - it wasn't
> showing up in the list after a 'reasonable' amount of time when I
tried
> to use the web posting feature. J
> 
> 
> 
> --
> 
> 
> 
> I've got a single server running Win2K3 and set up using NLB. (I have
> another server ready to attach to the cluster, but figured I would get
> it going with the first node before going for both.)
> 
> 
> 
> I'm running apache 2.0.54 and CF7 (updater 3)
> 
> 
> 
> From my development machine:
> 
> * When I attempt to access any pages from the server directly,
> everything works fine.
> 
> * When I try to access NON-CF pages through the cluster address,
> everything works fine.
> 
> * When I try to access CF pages through the cluster address, I get
> intermittent truncated results and an occasional "The document
contains
> no data" from Firefox and "Cannot find server" pages from IE (despite
> the fact that it loaded part of the page, displayed it, and then
> displayed the error...
> 
> 
> 
> As a test, I copied the generated html source (from a representative
CF
> page) into a htm file and I can access that without any difficulty
from
> the cluster address.
> 
> 
> 
>  Thanks for any insight.
> 
> Chris
> 
> ___
> Chris Brandt, DVM, MS
> Instructional Media Development Specialist
> http://vetpda.ucdavis.edu
> (530) 754-4452
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 



~|
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:216553
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 questions

[Rick Root]

I am working on a modified version of my file manager that stores 
metadata about files and directories.

My client wants to make the files searchable, and I'd like to search 
both the metadata (in a database) and the file contents themselves (txt, 
word, pdf, etc).

I'm not entirely sure how to do this in a single verity collection though.

Can I index the database content with the file content in a single 
collection and link the two?

Rick


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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216552
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: OT: Backup solution for small business?

[Ray Champagne]

You eat Tuna?  Don't you know George Bush personally has injected 
Mercury into every Tuna Fish in the sea?

Matt Robertson wrote:
> It turns out John Cleese has put together an informative and timely Flash 
> video on this subject. Stumbled across this today while eating lunch. 
>  I just barely avoided spitting my tuna sandwich all over the screen at one 
> point.
>  http://www.backuptrauma.com/video/default2.aspx
>  -- 
> --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:216551
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: OT: Backup solution for small business?

[Matt Robertson]

It turns out John Cleese has put together an informative and timely Flash 
video on this subject. Stumbled across this today while eating lunch. 
 I just barely avoided spitting my tuna sandwich all over the screen at one 
point.
 http://www.backuptrauma.com/video/default2.aspx
 -- 
--mattRobertson--
Janitor, MSB Web Systems
mysecretbase.com 


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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216550
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: Tinymce file manager

[Rick Root]

Stan Winchester wrote:
> Thanks, that is exactly what I was looking for. It works VERY nicely!


Thanks ;)

- Rick Root


~|
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:216549
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: Form Post From ASP.NET to CF not working

[Caroline Wise]

I tried that and it didn't make a difference. I also tried instead of
sending an email to write a test file to the same directory and that
worked with our forms but not the remote form. I asked our
administrator to check exception logs, the mail server, etc. and there
are no errors or problems as far as he can see.

Thanks,
Caroline

On 8/26/05, Matthew Small <[EMAIL PROTECTED]> wrote:
> Is your mail server having issues? Try explicitly stating the mail server.
> 
> Matthew Small
> 
> 
> -Original Message-
> From: Caroline Wise [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 26, 2005 4:35 PM
> To: CF-Talk
> Subject: Re: Form Post From ASP.NET to CF not working
> 
> Actually, the success is not that random - because the remote ASP.NET
> form stopped working some time after 5.45 AM today. It was working
> consistently yesterday when I was trying it. And right now, if I use
> the test forms we created both within our network and outside, it also
> works every time.
> 
> I'm not sure which code you want to see - but because I don't have
> access to the remote form I can only give you the code I am using to
> send myself the test mail. The only code before this is in my
> Application.cfm.
> 
> 
>  subject="test form" type="HTML">
> 
> 
> 
> Thanks,
> Caroline
> 
> On 8/26/05, Adrian Lynch <[EMAIL PROTECTED]> wrote:
> > This doesn't explain the random success of the process, but could the
> action
> > attribute of the form be causing some issues?
> >
> > Can we see some code?
> >
> > Ade
> >
> > -Original Message-
> > From: Caroline Wise [mailto:[EMAIL PROTECTED]
> > Sent: 26 August 2005 20:59
> > To: CF-Talk
> > Subject: Form Post From ASP.NET to CF not working
> >
> >
> > Group,
> >
> > I have an application that is fed data from a form located on another
> > server by way of doing the equivalent of a cfhttp post. The problem is
> > that while there is a server log entry that the post occurred, my
> > application does not get "hit". For testing purposes I put a cfmail
> > tag in the top of the page to send me a dump of all form fields
> > received and when I submit the form I am not getting a message.
> >
> > But when I set up a test HTML form to submit form fields to my
> > application, it worked and I got the message.
> >
> > The odd thing is - the vendor for the submitting form was updating
> > some form fields last night and early this morning and when they were
> > testing it then I received email messages with their test values. But,
> > when I tried their form after I came to the office, no test emails
> > were generated. I called them and asked them to try the form and they
> > did -  no test email. They insist they didn't make any changes to
> > their end since the last time that I received successful test mails.
> >
> > I agree that it looks like the problem is on our end considering we
> > have a server log entry, but the problem is - we did not change
> > anything either, so why did it work this morning and not now?
> >
> > We have implemented this kind of process several times before with
> > another vendor in CF and there was no problem whatsoever to connect...
> >
> > Any light shed on this conundrum would be appreciated
> >
> > Thanks,
> > Caroline Wise
> >
> >
> >
> 
> 
> 
> 

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

JDBC nightmare

[Claude Schneegans]

Hi,

I'm trying to install a JDBC DS under CFMX 6.1
It's really a mess! :-(
I succeeded to define the compassTravel example as described in the
docs, but cannot manage
to install any other DS on any other Access database, even scupuleously
copiing the path name
with same upper and lower case.

Apparently one need to give this line in JDBC URL:
jdbc:pointbase:compasstravel,database.home=C:/inetsrv/wwwroot/cfdocs/getting_started/db
just to tell where the Acces
C:/inetsrv/wwwroot/cfdocs/getting_started/db/compasstravel.mbd is.
Why doesn't the Administrator just take
C:/inetsrv/wwwroot/cfdocs/getting_started/db/compasstravel.mbd
and does whatever needs to be done with it?

Another thing is the "driver class" which need to be
"com.pointbase.jdbc.jdbcUniversalDriver"

How can I guess what are the other classes, and I suspect the other
drivers available?

My question, is this mess any better under CFMX 7, and is it worth
upgrading?

-- 
___
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:216547
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

ODBC nightmare

[Claude Schneegans]

Hi,

Is it really a problem with CFMX 6 ?
When I define a DSN with the Windows ODBC manager, the CF Administrator 
does not list it,
and when I define it through the Administrator, othe ODBC applications 
do not see it :-(

This problem does not occur under CF 5.
Is it fixed in CFMX 7?

Thanks

-- 
___
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:216546
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: Adobe Version Cue 2 uses MySQL!

[Barney Boisvert]

MySQL is acutally used for a lot of embedded stuff.  It's really
modular, so it can be a very good choice, because you can get exactly
the pieces you need.  And it doesn't just run on windows, which both
MSDE and Access are limited to.

cheers,
barneyb

On 8/26/05, Damien McKenna <[EMAIL PROTECTED]> wrote:
> I'm used to any time an application needing to install a database layer
> it either being a custom thing, MSDE or MDB files.  Discovering that
> MySQL is used was funny because a) it isn't one of the above, b) Adobe
> have a document management system so I kinda thought they were using a
> trimmed down version of it, c) MySQL isn't atomic therefore an odd
> choice.
> 

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

Got Gmail? I have 50 invites.

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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216545
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: Adobe Version Cue 2 uses MySQL!

[Damien McKenna]

I'm used to any time an application needing to install a database layer
it either being a custom thing, MSDE or MDB files.  Discovering that
MySQL is used was funny because a) it isn't one of the above, b) Adobe
have a document management system so I kinda thought they were using a
trimmed down version of it, c) MySQL isn't atomic therefore an odd
choice.

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

> -Original Message-
> From: Mark A Kruger [mailto:[EMAIL PROTECTED] 
> Sent: Friday, August 26, 2005 4:34 PM
> To: CF-Talk
> Subject: RE: Adobe Version Cue 2 uses MySQL!
> 
> why is  it funny?
> 
> -Original Message-
> From: Damien McKenna [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 26, 2005 3:28 PM
> To: CF-Talk
> Subject: OT: Adobe Version Cue 2 uses MySQL!
> 
> 
> Small thing I noticed.  Adobe Version Cue v2 uses MySQL as the storage
> mechanism!  Pretty funny if you ask me.
> 
> --
> Damien McKenna - Web Developer - [EMAIL PROTECTED]
> The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
> #include 
> 
> 
> 
> 
> 

~|
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:216544
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: Request.dsn and flash remoting

[Brandt, Chris M.]

You were right! I had an extra application.cfm in my components
directory (testing something else) that was being called instead and so
my request.dsn wasn't being defined!

Thanks Adrian!

Chris

___
Chris Brandt, DVM, MS
Instructional Media Development Specialist
http://vetpda.ucdavis.edu
(530) 754-4452

> -Original Message-
> From: Adrian Lynch [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 26, 2005 1:09 PM
> To: CF-Talk
> Subject: RE: Request.dsn and flash remoting
> 
> Where are you setting request.dsn? If it's in App.cfm then make sure
that
> page is being called when you call the cfc.
> 
> Do you run any logic that only works as expected when a browser
requests
> pages? This might be hampering you attempts.
> 
> Ade
> 
> -Original Message-
> From: Brandt, Chris M. [mailto:[EMAIL PROTECTED]
> Sent: 26 August 2005 20:11
> To: CF-Talk
> Subject: Request.dsn and flash remoting
> 
> 
> I've got several CFC functions that are utilized by flash... When I
have
> the datasource explicitly set FR works just fine. When I change the
> datasource to "request.dsn", it stops working.
> 
> 
> 
> Is there a best practices method for dealing with single location
> datasource updating when using flash?
> 
> 
> 
> Thanks,
> 
> Chris
> 
> 
> 
> ___
> Chris Brandt, DVM, MS
> Instructional Media Development Specialist
> http://vetpda.ucdavis.edu
> (530) 754-4452
> 
> 
> 

~|
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:216543
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: Form Post From ASP.NET to CF not working

[Matthew Small]

Is your mail server having issues? Try explicitly stating the mail server.
 
Matthew Small


-Original Message-
From: Caroline Wise [mailto:[EMAIL PROTECTED] 
Sent: Friday, August 26, 2005 4:35 PM
To: CF-Talk
Subject: Re: Form Post From ASP.NET to CF not working

Actually, the success is not that random - because the remote ASP.NET
form stopped working some time after 5.45 AM today. It was working
consistently yesterday when I was trying it. And right now, if I use
the test forms we created both within our network and outside, it also
works every time.

I'm not sure which code you want to see - but because I don't have
access to the remote form I can only give you the code I am using to
send myself the test mail. The only code before this is in my
Application.cfm.




 

Thanks,
Caroline

On 8/26/05, Adrian Lynch <[EMAIL PROTECTED]> wrote:
> This doesn't explain the random success of the process, but could the
action
> attribute of the form be causing some issues?
> 
> Can we see some code?
> 
> Ade
> 
> -Original Message-
> From: Caroline Wise [mailto:[EMAIL PROTECTED]
> Sent: 26 August 2005 20:59
> To: CF-Talk
> Subject: Form Post From ASP.NET to CF not working
> 
> 
> Group,
> 
> I have an application that is fed data from a form located on another
> server by way of doing the equivalent of a cfhttp post. The problem is
> that while there is a server log entry that the post occurred, my
> application does not get "hit". For testing purposes I put a cfmail
> tag in the top of the page to send me a dump of all form fields
> received and when I submit the form I am not getting a message.
> 
> But when I set up a test HTML form to submit form fields to my
> application, it worked and I got the message.
> 
> The odd thing is - the vendor for the submitting form was updating
> some form fields last night and early this morning and when they were
> testing it then I received email messages with their test values. But,
> when I tried their form after I came to the office, no test emails
> were generated. I called them and asked them to try the form and they
> did -  no test email. They insist they didn't make any changes to
> their end since the last time that I received successful test mails.
> 
> I agree that it looks like the problem is on our end considering we
> have a server log entry, but the problem is - we did not change
> anything either, so why did it work this morning and not now?
> 
> We have implemented this kind of process several times before with
> another vendor in CF and there was no problem whatsoever to connect...
> 
> Any light shed on this conundrum would be appreciated
> 
> Thanks,
> Caroline Wise
> 
> 
> 



~|
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:216542
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: Form Post From ASP.NET to CF not working

[Caroline Wise]

Actually, the success is not that random - because the remote ASP.NET
form stopped working some time after 5.45 AM today. It was working
consistently yesterday when I was trying it. And right now, if I use
the test forms we created both within our network and outside, it also
works every time.

I'm not sure which code you want to see - but because I don't have
access to the remote form I can only give you the code I am using to
send myself the test mail. The only code before this is in my
Application.cfm.




 

Thanks,
Caroline

On 8/26/05, Adrian Lynch <[EMAIL PROTECTED]> wrote:
> This doesn't explain the random success of the process, but could the action
> attribute of the form be causing some issues?
> 
> Can we see some code?
> 
> Ade
> 
> -Original Message-
> From: Caroline Wise [mailto:[EMAIL PROTECTED]
> Sent: 26 August 2005 20:59
> To: CF-Talk
> Subject: Form Post From ASP.NET to CF not working
> 
> 
> Group,
> 
> I have an application that is fed data from a form located on another
> server by way of doing the equivalent of a cfhttp post. The problem is
> that while there is a server log entry that the post occurred, my
> application does not get "hit". For testing purposes I put a cfmail
> tag in the top of the page to send me a dump of all form fields
> received and when I submit the form I am not getting a message.
> 
> But when I set up a test HTML form to submit form fields to my
> application, it worked and I got the message.
> 
> The odd thing is - the vendor for the submitting form was updating
> some form fields last night and early this morning and when they were
> testing it then I received email messages with their test values. But,
> when I tried their form after I came to the office, no test emails
> were generated. I called them and asked them to try the form and they
> did -  no test email. They insist they didn't make any changes to
> their end since the last time that I received successful test mails.
> 
> I agree that it looks like the problem is on our end considering we
> have a server log entry, but the problem is - we did not change
> anything either, so why did it work this morning and not now?
> 
> We have implemented this kind of process several times before with
> another vendor in CF and there was no problem whatsoever to connect...
> 
> Any light shed on this conundrum would be appreciated
> 
> Thanks,
> Caroline Wise
> 
> 
> 

~|
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:216541
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: Adobe Version Cue 2 uses MySQL!

[Mark A Kruger]

why is  it funny?

-Original Message-
From: Damien McKenna [mailto:[EMAIL PROTECTED]
Sent: Friday, August 26, 2005 3:28 PM
To: CF-Talk
Subject: OT: Adobe Version Cue 2 uses MySQL!


Small thing I noticed.  Adobe Version Cue v2 uses MySQL as the storage
mechanism!  Pretty funny if you ask me.

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




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

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

OT: Adobe Version Cue 2 uses MySQL!

[Damien McKenna]

Small thing I noticed.  Adobe Version Cue v2 uses MySQL as the storage
mechanism!  Pretty funny if you ask me.
 
-- 
Damien McKenna - Web Developer - [EMAIL PROTECTED]
The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
#include 


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

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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216539
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: Form Post From ASP.NET to CF not working

[Adrian Lynch]

This doesn't explain the random success of the process, but could the action
attribute of the form be causing some issues?

Can we see some code?

Ade

-Original Message-
From: Caroline Wise [mailto:[EMAIL PROTECTED]
Sent: 26 August 2005 20:59
To: CF-Talk
Subject: Form Post From ASP.NET to CF not working


Group,

I have an application that is fed data from a form located on another
server by way of doing the equivalent of a cfhttp post. The problem is
that while there is a server log entry that the post occurred, my
application does not get "hit". For testing purposes I put a cfmail
tag in the top of the page to send me a dump of all form fields
received and when I submit the form I am not getting a message.

But when I set up a test HTML form to submit form fields to my
application, it worked and I got the message.

The odd thing is - the vendor for the submitting form was updating
some form fields last night and early this morning and when they were
testing it then I received email messages with their test values. But,
when I tried their form after I came to the office, no test emails
were generated. I called them and asked them to try the form and they
did -  no test email. They insist they didn't make any changes to
their end since the last time that I received successful test mails.

I agree that it looks like the problem is on our end considering we
have a server log entry, but the problem is - we did not change
anything either, so why did it work this morning and not now?

We have implemented this kind of process several times before with
another vendor in CF and there was no problem whatsoever to connect...

Any light shed on this conundrum would be appreciated

Thanks,
Caroline Wise


~|
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:216538
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: Request.dsn and flash remoting

[Adrian Lynch]

Where are you setting request.dsn? If it's in App.cfm then make sure that
page is being called when you call the cfc.

Do you run any logic that only works as expected when a browser requests
pages? This might be hampering you attempts.

Ade

-Original Message-
From: Brandt, Chris M. [mailto:[EMAIL PROTECTED]
Sent: 26 August 2005 20:11
To: CF-Talk
Subject: Request.dsn and flash remoting


I've got several CFC functions that are utilized by flash... When I have
the datasource explicitly set FR works just fine. When I change the
datasource to "request.dsn", it stops working.



Is there a best practices method for dealing with single location
datasource updating when using flash?



Thanks,

Chris



___
Chris Brandt, DVM, MS
Instructional Media Development Specialist
http://vetpda.ucdavis.edu
(530) 754-4452


~|
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:216537
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: Form Post From ASP.NET to CF not working

[Matthew Small]

Connectivity issues?

Perhaps you're hitting an error before the email is sent, due to the form
fields not validating correctly?


Matthew Small


-Original Message-
From: Caroline Wise [mailto:[EMAIL PROTECTED] 
Sent: Friday, August 26, 2005 3:59 PM
To: CF-Talk
Subject: Form Post From ASP.NET to CF not working

Group,

I have an application that is fed data from a form located on another
server by way of doing the equivalent of a cfhttp post. The problem is
that while there is a server log entry that the post occurred, my
application does not get "hit". For testing purposes I put a cfmail
tag in the top of the page to send me a dump of all form fields
received and when I submit the form I am not getting a message.

But when I set up a test HTML form to submit form fields to my
application, it worked and I got the message.

The odd thing is - the vendor for the submitting form was updating
some form fields last night and early this morning and when they were
testing it then I received email messages with their test values. But,
when I tried their form after I came to the office, no test emails
were generated. I called them and asked them to try the form and they
did -  no test email. They insist they didn't make any changes to
their end since the last time that I received successful test mails.

I agree that it looks like the problem is on our end considering we
have a server log entry, but the problem is - we did not change
anything either, so why did it work this morning and not now?

We have implemented this kind of process several times before with
another vendor in CF and there was no problem whatsoever to connect...

Any light shed on this conundrum would be appreciated

Thanks,
Caroline Wise



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

Form Post From ASP.NET to CF not working

[Caroline Wise]

Group,

I have an application that is fed data from a form located on another
server by way of doing the equivalent of a cfhttp post. The problem is
that while there is a server log entry that the post occurred, my
application does not get "hit". For testing purposes I put a cfmail
tag in the top of the page to send me a dump of all form fields
received and when I submit the form I am not getting a message.

But when I set up a test HTML form to submit form fields to my
application, it worked and I got the message.

The odd thing is - the vendor for the submitting form was updating
some form fields last night and early this morning and when they were
testing it then I received email messages with their test values. But,
when I tried their form after I came to the office, no test emails
were generated. I called them and asked them to try the form and they
did -  no test email. They insist they didn't make any changes to
their end since the last time that I received successful test mails.

I agree that it looks like the problem is on our end considering we
have a server log entry, but the problem is - we did not change
anything either, so why did it work this morning and not now?

We have implemented this kind of process several times before with
another vendor in CF and there was no problem whatsoever to connect...

Any light shed on this conundrum would be appreciated

Thanks,
Caroline Wise

~|
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:216535
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: Multiple File Upload

[dave]

ok code meister!

 shouldnt u be trying to catch scam artists or something? hehe

 actually, (an believe me will you should do this as well with your spagetti 
code haha) I leave the pounds signs in so i can quickly find my variables and 
such, were as i don't it just takes longer and I dont have extra time on my 
hands like the wilbergini does ;)~

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


From: Will Tomlinson <[EMAIL PROTECTED]>
Sent: Friday, August 26, 2005 3:43 PM
To: CF-Talk 
Subject: Re: Multiple File Upload 

> 

This doesn't need the #'s. 
It should be: 

Same here:

Should be: 

Will



~|
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:216534
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 Server Instances and CF 7

[Snake]

You can set a DSN to use any instance you have installed, you simply name it
in the DSN. 

-Original Message-
From: Chad McCue [mailto:[EMAIL PROTECTED] 
Sent: 26 August 2005 12:20
To: CF-Talk
Subject: SQL Server Instances and CF 7

I have a database that multiple sites are going to use and contains a
substantial amount of data. Is there any way in SQL server  you can make an
instance of the database and allow different sites to hit the different
instances keeping the sqlserver.exe from taking up too much cpu and memory?





~|
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:216533
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: Adding a database driver

[Tom McNeer]

Thanks very much to everyone for their suggestions. Unfortunately, the
replies add to my mystery.

Dave,

Thanks. That's what I figured. The file, jconn2.jar, is in the
\cfusionmx7\lib directory, but I'm still getting the "no suitable
driver" message.

Alisa, 

> I added my jConnect driver (jconn2.jar) to coldfusion/runtime/servers/lib and 
> it works fine.

I tried placing the .jar in this directory, too, but it didn't help.

I'm using the following connection information, as provided by Sybase:

URL: jdbc:sybase:Tds:localhost:2638
Driver Class: com.sybase.jdbc.SybDriver

Although the final environment involves a Sybase Adaptive Server
running on a separate machine, I'm trying to test locally using a
Sybase Adaptive Server Anywhere test database. I have confirmed that
the database server is running and the test database is accessible
through Sybase's Sybase Central management utility.

Alisa, is this the connection information you're using? Does any of
this other information suggest a solution for anyone?

-- 
Thanks,

Tom

Tom McNeer
MediumCool
http://www.mediumcool.com
530 Means St NW, Suite 110
Atlanta, GA 30318
404.589.0560

~|
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:216532
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: Multiple File Upload

[Will Tomlinson]

> 

This doesn't need the #'s. 
It should be: 

Same here:


Should be: 
 
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:216531
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: NLB and truncated responses from CF7

[Brandt, Chris M.]

Is anyone using Win2K3 NLB with Apache and Coldfusion? Should I try
switching to IIS?

Chris

___
Chris Brandt, DVM, MS
Instructional Media Development Specialist
http://vetpda.ucdavis.edu
(530) 754-4452
> -Original Message-
> From: Brandt, Chris M.
> Sent: Thursday, August 25, 2005 5:12 PM
> To: CF-Talk
> Subject: NLB and truncated responses from CF7
> 
> If this post appears in multiple locations, I apologize - it wasn't
> showing up in the list after a 'reasonable' amount of time when I
tried
> to use the web posting feature. J
> 
> 
> 
> --
> 
> 
> 
> I've got a single server running Win2K3 and set up using NLB. (I have
> another server ready to attach to the cluster, but figured I would get
> it going with the first node before going for both.)
> 
> 
> 
> I'm running apache 2.0.54 and CF7 (updater 3)
> 
> 
> 
> From my development machine:
> 
> * When I attempt to access any pages from the server directly,
> everything works fine.
> 
> * When I try to access NON-CF pages through the cluster address,
> everything works fine.
> 
> * When I try to access CF pages through the cluster address, I get
> intermittent truncated results and an occasional "The document
contains
> no data" from Firefox and "Cannot find server" pages from IE (despite
> the fact that it loaded part of the page, displayed it, and then
> displayed the error...
> 
> 
> 
> As a test, I copied the generated html source (from a representative
CF
> page) into a htm file and I can access that without any difficulty
from
> the cluster address.
> 
> 
> 
>  Thanks for any insight.
> 
> Chris
> 
> ___
> Chris Brandt, DVM, MS
> Instructional Media Development Specialist
> http://vetpda.ucdavis.edu
> (530) 754-4452
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 

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

Request.dsn and flash remoting

[Brandt, Chris M.]

I've got several CFC functions that are utilized by flash... When I have
the datasource explicitly set FR works just fine. When I change the
datasource to "request.dsn", it stops working. 

 

Is there a best practices method for dealing with single location
datasource updating when using flash?

 

Thanks,

Chris

 

___
Chris Brandt, DVM, MS
Instructional Media Development Specialist
http://vetpda.ucdavis.edu
(530) 754-4452

 



~|
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:216529
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: .rtf/.html/.doc to .pdf under cf 5

[Jay R]

check out HTMLDOC www.easysw.com/htmldoc

Jay

On 8/26/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Hi, is there any inexpensive
> way to convert a .rtf/.html/.doc-file
> under CF 5 to a .pdf-file ?
> ActivePDF is a bit too pricy.
> Uwe
> 
> 
> 
> 

~|
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:216528
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: .rtf/.html/.doc to .pdf under cf 5

[Paul Hastings]

[EMAIL PROTECTED] wrote:
> Hi, is there any inexpensive
> way to convert a .rtf/.html/.doc-file
> under CF 5 to a .pdf-file ?
> ActivePDF is a bit too pricy.

you might try iText (free) but you know cf5 & java ;-)

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

.rtf/.html/.doc to .pdf under cf 5

[cf-talk]

Hi, is there any inexpensive
way to convert a .rtf/.html/.doc-file
under CF 5 to a .pdf-file ?
ActivePDF is a bit too pricy.
Uwe



~|
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:216526
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: Adding a database driver

[Alisa Thomson]

I added my jConnect driver (jconn2.jar) to coldfusion/runtime/servers/lib and 
it works fine.

Hope this helps.

>Hi,
>
>A client of mine has an installation of CFMX7 Standard which needs to
>communicate with a Sybase database on another server on the network.
>The Standard version of CFMX disables the use of the included Sybase
>driver. So I have downloaded JConnect, Sybase's JDBC driver, and
>installed it.
>
>I have attempted to follow both Sybase's installation and connection
>information carefully, but when I enter the URL and driver information
>into the CF Administrator, I get "a suitable database driver cannot be
>found." While this sounds like a path problem, I haven't been able to
>discover what's wrong.
>
>Has anyone needed to install and use a separate JDBC driver in this
>manner, and do you have any insight? Any help at all would be greatly
>appreciated.
>
>-- 
>Thanks,
>
>Tom
>
>Tom McNeer
>MediumCool
>http://www.mediumcool.com
>530 Means St NW, Suite 110
>Atlanta, GA 30318
>404.589.0560

~|
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:216525
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: cfopenbb

[Tangorre, Michael]

> From: Matt Woodward [mailto:[EMAIL PROTECTED] 
> We're working--if you'd like to see things move faster, feel 
> free to volunteer to help!

I wasn't criticizing, rather inquiring. 

~|
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:216524
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: Multiple File Upload

[Seth Bienek]

The Stickman blog has a cool, cross-browser, single-form implementation that 
uses DHTML that I have not tried out yet.  But there's a demo on the site 
and an explanation of how it works:
http://the-stickman.com/web-development/javascript/upload-multiple-files-with-a-single-file-element

Take Care,

Seth 


~|
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:216523
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: cfopenbb

[Matt Woodward]

>Any updates on this effort? The initial buzz seems to have died down.

We're working--if you'd like to see things move faster, feel free to volunteer 
to help!

~|
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:216522
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: Multiple File Upload

[dave]

hopefully this will go thru since all my recent posts are empty
 the problem is that you technically can only have 1 file.serverfile, so heres 
what i do in that case.
 make sure the file field isnt empty, do the upload give it a variable.

 
 
     
     
 

 
 
     
     
 

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


From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]>
Sent: Friday, August 26, 2005 1:37 PM
To: CF-Talk 
Subject: Multiple File Upload 

All,

Apart from looping through and outputting multiple forms (and via zip file)
how are people handling multiple file uploads to a server? 

Any ideas/code/examples?

N

This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant,
Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business,
Registered in England, Number 678540. It contains information which is
confidential and may also be privileged. It is for the exclusive use of the
intended recipient(s). If you are not the intended recipient(s) please note
that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful. If you have
received this communication in error please return it to the sender or call
our switchboard on +44 (0) 20 89107910. The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions.
Visit our website at http://www.reedexpo.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:216521
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: Adding a database driver

[Dave Watts]

> But if the file is enclosed within the same directory as the
> macromedia_drivers.jar, wouldn't it be within the class path?

If you add JAR files to \cfusionmx\lib (or \cfusionmx7\lib with CFMX 7
Standard), they should automatically be added to the classpath. Typically,
JAR files must be manually added to the classpath otherwise, since a JAR
file is essentially a directory (although a zipped one).

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!


~|
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:216520
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

OT: PhotoshopCS2 monitor profile messed up

[Damien McKenna]

Photoshop CS2 on Windows XP SP2...

I've got two Samsung Syncmaster 151s monitors connected up and when I
installed Photoshop CS2 it started complaining about the monitor profile
being invalid.  For a few days I clicked through the requestor when
loading PS but today was tired of it so selected "don't ask me this
again".  Then it seems I clicked the wrong button as now PS is
incorrectly displaying colors, specifically everything seems to have a
cyan-ish tone with "white" looking very strongly cyan.  Any ideas on how
to reset it?  Thanks.

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


~|
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:216517
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: Adding a database driver

[Ian Skinner]

I couldn't tell you.  I just followed the instructions I found on 
Macromedia.com for installing the Oracle JDBC driver, and it said add such and 
such string to the classpath.  And the driver worked as advertised.


--
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:216519
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: Multiple File Upload

[Ian Skinner]

Does multiple form fields count as multiple forms?  That is what I do.  Create 
an upload field, and a control that allows the user to add more fields as 
necessary.

I understand there are tools out there that my allow more "true" multi-file 
upload, but I've never needed to hunt them down and figure them out.


--
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:216518
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: Adding a database driver

[Dave Watts]

> A client of mine has an installation of CFMX7 Standard which needs to
> communicate with a Sybase database on another server on the network.
> The Standard version of CFMX disables the use of the included Sybase
> driver. So I have downloaded JConnect, Sybase's JDBC driver, and
> installed it.
> 
> I have attempted to follow both Sybase's installation and connection
> information carefully, but when I enter the URL and driver information
> into the CF Administrator, I get "a suitable database driver cannot be
> found." While this sounds like a path problem, I haven't been able to
> discover what's wrong.
> 
> Has anyone needed to install and use a separate JDBC driver in this
> manner, and do you have any insight? Any help at all would be greatly
> appreciated.

I haven't worked with Sybase drivers, but installing various drivers for MS
SQL Server on CFMX Standard has simply involved putting the JAR file in
\cfusionmx\lib, and putting the correct information in the "Other"
datasource configuration screen within CF Administrator.

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!


~|
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:216516
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: cfopenbb

[Charlie Griefer]

I was on vacation when the intial emails went out and was unable to
reply.  I had assumed the fact that I hadn't heard anything further
was due to my lack of response to the initial batch.

I take it that's not the case?

On 8/26/05, Tangorre, Michael <[EMAIL PROTECTED]> wrote:
> Any updates on this effort? The initial buzz seems to have died down.
> 
> 
> 
> 
> 

~|
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:216515
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: Multiple File Upload

[Neculai Macarie]

> Apart from looping through and outputting multiple forms (and via zip
file)
> how are people handling multiple file uploads to a server?

I'm using the jupload java applet: www.jupload.biz/. I'm showing a first
page allowing the user to select common attributes of the images and on the
second page have the java applet which uploads the files.

-- 



~|
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:216514
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: Adding a database driver

[Tom McNeer]

On 8/26/05, Ian Skinner <[EMAIL PROTECTED]> wrote:
> Even in standard version, jrun is involved, just not a full independent jrun. 
>  When I installed the >Oracle jdbc driver on a MX6.1 standard I had to add 
> the file the class path.

But if the file is enclosed within the same directory as the
macromedia_drivers.jar, wouldn't it be within the class path?



-- 
Thanks,

Tom

Tom McNeer
MediumCool
http://www.mediumcool.com
530 Means St NW, Suite 110
Atlanta, GA 30318
404.589.0560

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

cfopenbb

[Tangorre, Michael]

Any updates on this effort? The initial buzz seems to have died down.
 
 


~|
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:216512
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 Count Question...

[Dave.Phillips]

sorry, typo.  I didn't look back to see who wrote what, just remembered it.

Dave

-Original Message-
From: Deanna Schneider [mailto:[EMAIL PROTECTED]
Sent: Friday, August 26, 2005 1:14 PM
To: CF-Talk
Subject: Re: SQL Count Question...


Who you talking about "he." I'm a "she." ;) But, I am glad to see you
agreeing. I thought for a minute there that I must have been confused
if he got it to work with those statements in there.
**
The information contained in this message, including attachments, may contain 
privileged or confidential information that is intended to be delivered only to 
the 
person identified above. If you are not the intended recipient, or the person 
responsible for delivering this message to the intended recipient, ALLTEL 
requests 
that you immediately notify the sender and asks that you do not read the 
message or its 
attachments, and that you delete them without copying or sending them to anyone 
else. 


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

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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216511
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: Adding a database driver

[Ian Skinner]

Even in standard version, jrun is involved, just not a full independent jrun.  
When I installed the Oracle jdbc driver on a MX6.1 standard I had to add the 
file the class path.


--
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:216510
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

Multiple File Upload

[Robertson-Ravo, Neil (RX)]

All,

Apart from looping through and outputting multiple forms (and via zip file)
how are people handling multiple file uploads to a server? 

Any ideas/code/examples?

N

This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant,
Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business,
Registered in England, Number 678540.  It contains information which is
confidential and may also be privileged.  It is for the exclusive use of the
intended recipient(s).  If you are not the intended recipient(s) please note
that any form of distribution, copying or use of this communication or the
information in it is strictly prohibited and may be unlawful.  If you have
received this communication in error please return it to the sender or call
our switchboard on +44 (0) 20 89107910.  The opinions expressed within this
communication are not necessarily those expressed by Reed Exhibitions.
Visit our website at http://www.reedexpo.com

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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216509
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: Adding a database driver

[Ryan Guill]

I thought about how i said jrun afterwards and I knew that wasnt
right.  I meant the classpath, although thats what your lib should be.

sorry, I dont guess I can really help much more than that.

On 8/26/05, Tom McNeer <[EMAIL PROTECTED]> wrote:
> Hi Ryan,
> 
> On 8/26/05, Ryan Guill <[EMAIL PROTECTED]> wrote:
> > You have to add the driver to the jrun path.  I dont know about
> > sybase, but for instructions on how this went for mysql 4.1, check
> > this link:
> 
> Thanks, but jrun isn't involved. This is an installation of Standard
> on a Win2003 server, using IIS. The technote suggests that the driver
> needs to be in the WEB-INF directory. I have placed a copy there, as
> well as in the main "lib" directory where the macromedia-drivers.jar
> resides. But still no luck.
> 
> Thoughts?
> 
> 
> --
> Thanks,
> 
> Tom
> 
> Tom McNeer
> MediumCool
> http://www.mediumcool.com
> 530 Means St NW, Suite 110
> Atlanta, GA 30318
> 404.589.0560
> 
> 

~|
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:216508
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: Adding a database driver

[Tom McNeer]

Hi Ryan,

On 8/26/05, Ryan Guill <[EMAIL PROTECTED]> wrote:
> You have to add the driver to the jrun path.  I dont know about
> sybase, but for instructions on how this went for mysql 4.1, check
> this link: 

Thanks, but jrun isn't involved. This is an installation of Standard
on a Win2003 server, using IIS. The technote suggests that the driver
needs to be in the WEB-INF directory. I have placed a copy there, as
well as in the main "lib" directory where the macromedia-drivers.jar
resides. But still no luck.

Thoughts?


-- 
Thanks,

Tom

Tom McNeer
MediumCool
http://www.mediumcool.com
530 Means St NW, Suite 110
Atlanta, GA 30318
404.589.0560

~|
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:216507
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: Quick Query Question...[hopefully]

[Greg Morphis]

Actually what Mark Kruger said would probably work best in this situation

Che,

try this, create a table 1 row and the numbers 0 through 23 in them, then do
a left join to your group by query :)

-Mark


What he's saying is create a table called Hours with column row called hour
add 23 rows (0-23) and then left join your query to that query.

select * from foo, goo
where foo.hour = goo.hour(+)

That will return all the hours from the hour table. Not complex at all.




On 8/26/05, Che Vilnonis <[EMAIL PROTECTED]> wrote:
> works well. thanks so much.
> 
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 26, 2005 10:07 AM
> To: CF-Talk
> Subject: RE: Quick Query Question...[hopefully]
> 
> 
> There's probably a number of ways to do it.  Mine may or may not be the most
> efficient, but it gets the job done.
> 
> . do your query here...query name="query" (or whatever)
> 
> 
> 
> 
> Hour
> Order Qty
> 
> 
> 
> 
> 
> #thishour#
>  >#query.TotalOrderPerHour[hit]#0
> 
> 
> 
> 
> -Original Message-
> From: Che Vilnonis [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 26, 2005 9:16 AM
> To: CF-Talk
> Subject: RE: Quick Query Question...[hopefully]
> 
> 
> Yeah... I could use the help. I have an idea... but its probably NOT the
> best or most efficient way to do it in CF. Enlighten me, por favor!
> ~Che
> 
> 
> **
> The information contained in this message, including attachments, may
> contain
> privileged or confidential information that is intended to be delivered only
> to the
> person identified above. If you are not the intended recipient, or the
> person
> responsible for delivering this message to the intended recipient, ALLTEL
> requests
> that you immediately notify the sender and asks that you do not read the
> message or its
> attachments, and that you delete them without copying or sending them to
> anyone else.
> 
> 
> 
> 
> 

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

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

[Deanna Schneider]

Who you talking about "he." I'm a "she." ;) But, I am glad to see you
agreeing. I thought for a minute there that I must have been confused
if he got it to work with those statements in there.

On 8/26/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> FYI - he's write about the 0 = 0, it's useless to have that with your 
> or's...the or's aren't even being evaluated and ultimately, it's going to 
> keep you from getting the right data.
> 
> Glad you got the count to work though. :)
> 
> Dave

~|
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:216505
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: Adding a database driver

[Ryan Guill]

You have to add the driver to the jrun path.  I dont know about
sybase, but for instructions on how this went for mysql 4.1, check
this link: 
http://www.ryanguill.com/blog/index.cfm?mode=entry&entry=C7BE3545-40CA-6D1C-8A6FDADE72B840CC

It may offer some clues.

On 8/26/05, Tom McNeer <[EMAIL PROTECTED]> wrote:
> Hi,
> 
> A client of mine has an installation of CFMX7 Standard which needs to
> communicate with a Sybase database on another server on the network.
> The Standard version of CFMX disables the use of the included Sybase
> driver. So I have downloaded JConnect, Sybase's JDBC driver, and
> installed it.
> 
> I have attempted to follow both Sybase's installation and connection
> information carefully, but when I enter the URL and driver information
> into the CF Administrator, I get "a suitable database driver cannot be
> found." While this sounds like a path problem, I haven't been able to
> discover what's wrong.
> 
> Has anyone needed to install and use a separate JDBC driver in this
> manner, and do you have any insight? Any help at all would be greatly
> appreciated.
> 
> --
> Thanks,
> 
> Tom
> 
> Tom McNeer
> MediumCool
> http://www.mediumcool.com
> 530 Means St NW, Suite 110
> Atlanta, GA 30318
> 404.589.0560
> 
> 

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

Adding a database driver

[Tom McNeer]

Hi,

A client of mine has an installation of CFMX7 Standard which needs to
communicate with a Sybase database on another server on the network.
The Standard version of CFMX disables the use of the included Sybase
driver. So I have downloaded JConnect, Sybase's JDBC driver, and
installed it.

I have attempted to follow both Sybase's installation and connection
information carefully, but when I enter the URL and driver information
into the CF Administrator, I get "a suitable database driver cannot be
found." While this sounds like a path problem, I haven't been able to
discover what's wrong.

Has anyone needed to install and use a separate JDBC driver in this
manner, and do you have any insight? Any help at all would be greatly
appreciated.

-- 
Thanks,

Tom

Tom McNeer
MediumCool
http://www.mediumcool.com
530 Means St NW, Suite 110
Atlanta, GA 30318
404.589.0560

~|
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:216503
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: Event Gatways: session scope?

[Ryan Guill]

Just what I was looking for, Thanks Damon!

On 8/26/05, dcooper @ macromedia. com dcooper @ macromedia. com
<[EMAIL PROTECTED]> wrote:
> Check out this area of the Developer's Guide for how ID's are created for 
> session and client variables (and a discussion of how scopes work in general 
> with Event Gateway apps):
> 
> http://livedocs.macromedia.com/coldfusion/7/htmldocs/1642.htm
> 
> Also check out the example Event Gateway app we ship with for example code:
> {cfusion}\gateway\cfc\examples\menu
> 
> HTH
> 
> Damon
> 
> >Thanks for the reply Damon.
> >
> >That is what I had assumed, but I have made an application.cfm page
> >with the  >doesnt seem to hold any session values.  Anything I should look for?
> >Also, since it isnt a request over the internet, and there is no way
> >to pass and get cfid and cftokens, how does it/would it keep track of
> >the sessions?  based on username?
> >
> >On 8/26/05, dcooper @ macromedia. com dcooper @ macromedia. com
> ><[EMAIL PROTECTED]> wrote:
> >>
> 
> 

~|
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:216502
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: Event Gatways: session scope?

[dcooper]

Check out this area of the Developer's Guide for how ID's are created for 
session and client variables (and a discussion of how scopes work in general 
with Event Gateway apps):

http://livedocs.macromedia.com/coldfusion/7/htmldocs/1642.htm 

Also check out the example Event Gateway app we ship with for example code:
{cfusion}\gateway\cfc\examples\menu

HTH

Damon

>Thanks for the reply Damon.
>
>That is what I had assumed, but I have made an application.cfm page
>with the doesnt seem to hold any session values.  Anything I should look for? 
>Also, since it isnt a request over the internet, and there is no way
>to pass and get cfid and cftokens, how does it/would it keep track of
>the sessions?  based on username?
>
>On 8/26/05, dcooper @ macromedia. com dcooper @ macromedia. com
><[EMAIL PROTECTED]> wrote:
>>

~|
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:216501
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 Count Question...

[Dave.Phillips]

FYI - he's write about the 0 = 0, it's useless to have that with your 
or's...the or's aren't even being evaluated and ultimately, it's going to keep 
you from getting the right data.

Glad you got the count to work though. :)

Dave

-Original Message-
From: Protoculture [mailto:[EMAIL PROTECTED]
Sent: Friday, August 26, 2005 11:39 AM
To: CF-Talk
Subject: Re: SQL Count Question...


thanks RADEMAKERS, that did it... here is the working code..

SELECT COUNT(DISTINCT(opportunity.id))

FROMopportunity,
advertiser,
location

WHERE   opportunity.deleted 
=   'N' 
AND
opportunity.authorised  
=   'Y' 
AND
opportunity.active  
=   'Y' 
AND
opportunity.activate
<=  getdate()   
AND
opportunity.deactivate  
>=  getdate()   
AND
opportunity.advertiser_id   
=   advertiser.id   
AND
advertiser.deleted  
=   'N' 
AND
advertiser.suspended
=   'N' 
AND

( 
(0 = 0  OR levels   LIKE '%' + ',' + 
CONVERT(VARCHAR,0) + ',' + '%') OR
(0 = 0  OR levels   LIKE '%' + ',' + 
CONVERT(VARCHAR,0) + ',' + '%')
) AND
 
(0  = 0 OR sectors  LIKE '%' + ',' + 
CONVERT(VARCHAR,0) + ',' + '%')AND
(0  = 0 OR work_types   LIKE '%' + ',' + 
CONVERT(VARCHAR,0) + ',' + '%')

  AND
 
 (
0   = 0 OR 
(0  LIKE '%' + ',' + CONVERT(VARCHAR,0) + ',' + '%' 
AND
0   LIKE'%' + ',' + CONVERT(VARCHAR,0) 
+ ',' + '%')
  )



~|
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:216500
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: OT: CSS: image overflow in IE vs Firefox

[Damien McKenna]

Thanks for the offer of help Sandy.  I ended up finding this page:
http://www.evolt.org/article/Ten_CSS_tricks_you_may_not_know/17/60369/?f
ormat=print
Tip #4 worked beautifully for what I needed to do.

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


~|
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:216499
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: Get fields in an Access table

[Matt Robertson]

On 8/25/05, Claude Schneegans <[EMAIL PROTECTED]> wrote: 
> 
> Any recomandation?

 Sorry. On this subject I am just a consumer. Clueless and loving it :-)

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


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

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

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

[Protoculture]

thanks RADEMAKERS, that did it... here is the working code..

SELECT COUNT(DISTINCT(opportunity.id))

FROMopportunity,
advertiser,
location

WHERE   opportunity.deleted 
=   'N' 
AND
opportunity.authorised  
=   'Y' 
AND
opportunity.active  
=   'Y' 
AND
opportunity.activate
<=  getdate()   
AND
opportunity.deactivate  
>=  getdate()   
AND
opportunity.advertiser_id   
=   advertiser.id   
AND
advertiser.deleted  
=   'N' 
AND
advertiser.suspended
=   'N' 
AND

( 
(0 = 0  OR levels   LIKE '%' + ',' + 
CONVERT(VARCHAR,0) + ',' + '%') OR
(0 = 0  OR levels   LIKE '%' + ',' + 
CONVERT(VARCHAR,0) + ',' + '%')
) AND
 
(0  = 0 OR sectors  LIKE '%' + ',' + 
CONVERT(VARCHAR,0) + ',' + '%')AND
(0  = 0 OR work_types   LIKE '%' + ',' + 
CONVERT(VARCHAR,0) + ',' + '%')

  AND
 
 (
0   = 0 OR 
(0  LIKE '%' + ',' + CONVERT(VARCHAR,0) + ',' + '%' 
AND
0   LIKE'%' + ',' + CONVERT(VARCHAR,0) 
+ ',' + '%')
  )

~|
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:216497
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 Count Question...

[Dave.Phillips]

Actually, if you're using SQL server, this might work:

select count(*) from (put all your SQL in here without the count(), just the 
select distinct)

that might do it.

-Original Message-
From: RADEMAKERS Tanguy [mailto:[EMAIL PROTECTED]
Sent: Friday, August 26, 2005 11:02 AM
To: CF-Talk
Subject: RE: SQL Count Question...


I don't know about sql server specifically, but you could try syntax
like

select count(distinct(mycolumn)) from mytable

or else you should be able to do

select count(*) from (select distinct(mycolumn) from mytable)

/t

>-Original Message-
>Subject: SQL Count Question...
>From: <[EMAIL PROTECTED]>
>Date: Fri, 26 Aug 2005 07:16:33 -0500
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=41929&forumid=4#216470
>
>I don't think you can use DISTINCT with an aggregate function 
>like count().  Also, you didn't indicate anywhere in this 
>e-mail which database server you're using.  
>
>Are you doing the query just to get the count, or is it for 
>some other purpose as well.  There's nothing wrong with using 
>#queryname.recordcount#.  You could do the count() without the 
>DISTINCT, but that may give you more than you are looking for.  
>
>Maybe you could tell us the goal you're trying to accomplish 
>and there might be another way to approach it.  Be sure to 
>include your SQL database type and version.  Also, providing 
>your error message is very helpful.
>
>Dave
>



~|
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:216496
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: Quick Query Question...[hopefully]

[Che Vilnonis]

works well. thanks so much.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, August 26, 2005 10:07 AM
To: CF-Talk
Subject: RE: Quick Query Question...[hopefully]


There's probably a number of ways to do it.  Mine may or may not be the most
efficient, but it gets the job done.

. do your query here...query name="query" (or whatever)




Hour
Order Qty





#thishour#
#query.TotalOrderPerHour[hit]#0




-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]
Sent: Friday, August 26, 2005 9:16 AM
To: CF-Talk
Subject: RE: Quick Query Question...[hopefully]


Yeah... I could use the help. I have an idea... but its probably NOT the
best or most efficient way to do it in CF. Enlighten me, por favor!
~Che


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




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

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

[Deanna Schneider]

Well, I've never seen that behavior then. But, I also don't understand
what the heck you're trying to do with your query. You realize that
0=0 will always be true, right?

So, when you have a where statement like
 0=0 OR   (0  LIKE '%' + ',' + CONVERT(VARCHAR,0) + ',' + '%' AND
   0   LIKE'%' + ',' +
CONVERT(VARCHAR,0) + ',' + '%')

You might as well just leave off the second half of it. The DB is
going to say, "oh, yah, 0=0...I don't even have to check that other
half of the "or" clause."

~|
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:216495
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 Count Question...

[RADEMAKERS Tanguy]

I don't know about sql server specifically, but you could try syntax
like

select count(distinct(mycolumn)) from mytable

or else you should be able to do

select count(*) from (select distinct(mycolumn) from mytable)

/t

>-Original Message-
>Subject: SQL Count Question...
>From: <[EMAIL PROTECTED]>
>Date: Fri, 26 Aug 2005 07:16:33 -0500
>Thread: 
>http://www.houseoffusion.com/cf_lists/index.cfm/method=messages
>&threadid=41929&forumid=4#216470
>
>I don't think you can use DISTINCT with an aggregate function 
>like count().  Also, you didn't indicate anywhere in this 
>e-mail which database server you're using.  
>
>Are you doing the query just to get the count, or is it for 
>some other purpose as well.  There's nothing wrong with using 
>#queryname.recordcount#.  You could do the count() without the 
>DISTINCT, but that may give you more than you are looking for.  
>
>Maybe you could tell us the goal you're trying to accomplish 
>and there might be another way to approach it.  Be sure to 
>include your SQL database type and version.  Also, providing 
>your error message is very helpful.
>
>Dave
>

~|
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:216494
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: Indexing question

[Dave.Phillips]

Yes, sorry, Verity, and using CFMX 6.1

Dave

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: Friday, August 26, 2005 10:32 AM
To: CF-Talk
Subject: RE: Indexing question


Hmmm, this is a verity index yeah? 



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: 26 August 2005 15:24
To: CF-Talk
Subject: Indexing question

Hey folks,

Okay, I have a table with fields that I want index, AND one fo the fields is
a URL, except I don't want to index the URL itself, I want to index the
CONTENTS of the url.

So, I thought I could just do a CFHTTP and pull the contents and add them to
the cfindex.  However, it's not that simple since when I do a cfindex of
custom type I have to include the query name and the index only indexes the
query fields, but not additional content.

Is there any way I can accomplish this?  The only thing I have thought of is
to build a new Query from the results of the DB query and CFHTTP and then
index on that query.  That seems like a lot of work for this, so I wanted to
see if anyone had any ideas on how to do it?

Thanks,

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


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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216493
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 API Question: Writing a Script for "Clear Template Cache Now"

[Christopher Sabanty]

Hello all,

I'm looking for a way to programmatically perform the same action that 
the "Clear Template Cache Now" button does.

The "Clear Template Cache Now" button is located in the CF 
Administrator under Server Settings->Caching and is situated at the 
bottom of the screen. I'd like to write a script that does the same 
action but I'm not sure what method to call and what .cfc I should be 
getting it from. Here's the frame I've tried to put together so far. 
It's taken pretty much directly from the Macromedia documentation.


   // Login is always required. This example uses two lines of code.
   adminObj = createObject("component","cfide.adminapi.administrator");
   adminObj.login("admin");

   // Instantiate the data source object.
   myObj = createObject("component","cfide.adminapi.serverinstance");


After this I pretty much don't know where to go from here. Any help 
would be greatly appreciated.

Thanks,
CS

~|
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:216492
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: Indexing question

[Dave.Phillips]

This worked by building a query, but I'm still curious if anyone else had any 
other ideas.

Dave

-Original Message-
From: Phillips, Dave 
Sent: Friday, August 26, 2005 10:24 AM
To: CF-Talk
Subject: Indexing question


Hey folks,

Okay, I have a table with fields that I want index, AND one fo the fields is a 
URL, except I don't want to index the URL itself, I want to index the CONTENTS 
of the url.

So, I thought I could just do a CFHTTP and pull the contents and add them to 
the cfindex.  However, it's not that simple since when I do a cfindex of custom 
type I have to include the query name and the index only indexes the query 
fields, but not additional content.

Is there any way I can accomplish this?  The only thing I have thought of is to 
build a new Query from the results of the DB query and CFHTTP and then index on 
that query.  That seems like a lot of work for this, so I wanted to see if 
anyone had any ideas on how to do it?

Thanks,

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




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

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

[Robertson-Ravo, Neil (RX)]

Hmmm, this is a verity index yeah? 



-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: 26 August 2005 15:24
To: CF-Talk
Subject: Indexing question

Hey folks,

Okay, I have a table with fields that I want index, AND one fo the fields is
a URL, except I don't want to index the URL itself, I want to index the
CONTENTS of the url.

So, I thought I could just do a CFHTTP and pull the contents and add them to
the cfindex.  However, it's not that simple since when I do a cfindex of
custom type I have to include the query name and the index only indexes the
query fields, but not additional content.

Is there any way I can accomplish this?  The only thing I have thought of is
to build a new Query from the results of the DB query and CFHTTP and then
index on that query.  That seems like a lot of work for this, so I wanted to
see if anyone had any ideas on how to do it?

Thanks,

Dave

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




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

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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216490
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: IIS 6 VS Apache

[Marlon Moyer]

By default IIS 6 won't serve an svn mime type as far as I know.  I
know I've had to explicity tell it to serve different mime types on
setup.


On 8/25/05, Dave Watts <[EMAIL PROTECTED]> wrote:
> > Well acl's won't work well here, because .svn folders are
> > created in every folder of your application by the subversion
> > client.
> 
> I don't know enough about Subversion to comment, but if that's the case
> you're probably better off with a general rule somewhere rather than using
> ACLs, yes.
> 
> > You can expect me to go through hundreds of folders and set
> > the acl on every .svn subfolder.
> 
> No, that would probably be an impractical approach. However, you could
> easily do exactly that with a batch file and cacls.exe. The problem with
> that approach would be that you may add new .svn folders in the future, and
> you'd have to rerun the batch file.
> 
> > The reason I suspect it's easier with Apache is because apache
> > has a lot of different options for the config file, and I bet
> > one of those directives will do just what I want... disallow
> > access to .svn folders.
> 
> To the best of my knowledge, there's no Apache directive that specifically
> allows you to block access to directories whose names match part of a URL
> pattern. However, you could rewrite URLs to get the result you desire, with
> Apache or IIS.
> 
> Again, I don't know much about Subversion, but I think that it has a lot of
> Apache-specific functionality that you can enable, so you might want to use
> Apache just to get at that functionality anyway.
> 
> > IIS just has the GUI, which isn't very rich, and I don't remember
> > any options anywhere for disallowing access to specifically named
> > folders.
> 
> I'm not sure what you mean by "very rich" - it provides all the
> functionality to manage IIS, and IIS has quite a few switches. However, you
> can manage IIS without the GUI, using either the Metabase Editor (IIS 5) or
> any text editor (IIS 6). All of the IIS configuration information is stored
> in the Metabase, which is just a big, ugly XML document with IIS 6.
> 
> 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!
> 
> 
> 

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

Indexing question

[Dave.Phillips]

Hey folks,

Okay, I have a table with fields that I want index, AND one fo the fields is a 
URL, except I don't want to index the URL itself, I want to index the CONTENTS 
of the url.

So, I thought I could just do a CFHTTP and pull the contents and add them to 
the cfindex.  However, it's not that simple since when I do a cfindex of custom 
type I have to include the query name and the index only indexes the query 
fields, but not additional content.

Is there any way I can accomplish this?  The only thing I have thought of is to 
build a new Query from the results of the DB query and CFHTTP and then index on 
that query.  That seems like a lot of work for this, so I wanted to see if 
anyone had any ideas on how to do it?

Thanks,

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


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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216487
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: Quick Query Question...[hopefully]

[Dave.Phillips]

There's probably a number of ways to do it.  Mine may or may not be the most 
efficient, but it gets the job done.

 do your query here...query name="query" (or whatever)




Hour
Order Qty





#thishour#
#query.TotalOrderPerHour[hit]#0




-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]
Sent: Friday, August 26, 2005 9:16 AM
To: CF-Talk
Subject: RE: Quick Query Question...[hopefully]


Yeah... I could use the help. I have an idea... but its probably NOT the
best or most efficient way to do it in CF. Enlighten me, por favor!
~Che

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


~|
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:216486
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: Tinymce file manager

[Stan Winchester]

Thanks, that is exactly what I was looking for. It works VERY nicely!

>http://www.webworksllc.com/cffm/ integrates with TinyMCE.
>
>On 8/26/05, Stan Winchester <[EMAIL PROTECTED]> wrote:
>> Has anyone made a image/file manager for Tinymce?

~|
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:216478
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: IIS 6 VS Apache

[Russ]

Does svn export allow for updates?  I don't want to check out the whole
application everytime I update a file... 

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Friday, August 26, 2005 7:57 AM
To: CF-Talk
Subject: RE: IIS 6 VS Apache

Russ

Any reason why you cannot do  svn export to deploy the application without
the subversion system files? 

Kola

> -Original Message-
> From: Russ [mailto:[EMAIL PROTECTED]
> Sent: 25 August 2005 21:23
> To: CF-Talk
> Subject: RE: IIS 6 VS Apache
> 
> Well acl's won't work well here, because .svn folders are created in every
> folder of your application by the subversion client.  You can expect me to
> go through hundreds of folders and set the acl on every .svn subfolder.
The
> reason I suspect it's easier with Apache is because apache has a lot of
> different options for the config file, and I bet one of those directives
> will do just what I want... disallow access to .svn folders.  IIS just has
> the GUI, which isn't very rich, and I don't remember any options anywhere
> for disallowing access to specifically named folders.
> 
> 
> 
> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]
> Sent: Thursday, August 25, 2005 4:09 PM
> To: CF-Talk
> Subject: RE: IIS 6 VS Apache
> 
> > What about doing things such as blocking certain directories...
> > like for example I want to block the .svn directory from being
> > accessible from the web. I haven't figured out how to do it in
> > either Apache or IIS, but I have a feeling it's much easier in
> > apache...
> 
> That strikes me as a silly thing to say. If you don't know how to do it
with
> either one, what is the basis for your feeling?
> 
> If you have a specific directory that you want to manage with regard to
IIS,
> you set ACLs on it appropriately. Just like you'd set ACLs on files in a
SMB
> share. So, for people who have that experience - practically every Windows
> server administrator in the world - I suspect IIS is easier. If you don't
> know how to set ACLs, I imagine it's a toss-up.
> 
> But honestly, you're putting way too much thought into this, I suspect.
> Either IIS 6 or Apache will do what you need them to do.
> 
> 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!
> 
> 
> 
> 
> ~
> 



~|
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:216485
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: Quick Query Question...[hopefully]

[Che Vilnonis]

Huh? Ya got me with that one Mark. Care to explain in detail? Also, would it
be easier to use CF to insert the missing hours of the day and values of
zero (if yes, what would be the easist)? I hate to use CF when I might be
able to use the db... but were only talking about 24 rows of data.

~Che

-Original Message-
Che, try this, create a table 1 row and the numbers 0 through 23 in them,
then do
a left join to your group by query :)

-Mark

-Original Message-
SELECT Datepart(hh,OrderDate) AS Hour, Count(OrderDate) AS
TotalOrdersPerHour
FROMOrders
WHERE   Status = 'SHIPPED' AND (OrderDate BETWEEN '8/1/2005' AND '8/31/2005
23:59:59')
GROUP BY Datepart(hh,OrderDate), Datepart(hh,OrderDate)
ORDER BY Datepart(hh,OrderDate) ASC


~|
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:216477
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 Count Question...

[Protoculture]

yes I've also tried 

'id' AS opportunity.id

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