Re: query of queries or something else

2008-08-24 Thread Andrew Whone
How about something like this: cfquery name=qryGetOtherProperties datasource=#appDSN# SELECT f.AssetID, f.name, i.text, i.amount FROM FixedAssets f INNER JOIN InvoicesWork i ON i.AssetID = f.AssetID WHERE f.JobID = #qryGetInvoice.JobID# AND f.AssetID IN (select AssetID FROM InvoiceWork WHERE

Re: query of queries or something else

2008-08-24 Thread Andrew Whone
How about something like this: cfquery name=qryGetOtherProperties datasource=#appDSN# SELECT f.AssetID, f.name, i.text, i.amount FROM FixedAssets f INNER JOIN InvoicesWork i ON i.AssetID = f.AssetID WHERE f.JobID = #qryGetInvoice.JobID# AND f.AssetID IN (select AssetID FROM InvoiceWork WHERE

Re: Time Tracking software for multiple users

2008-08-24 Thread Jeff Gladnick
Hmmm... That might be a bit overkill for what I need, but I would be happy to take a look at it. If we can use it, I'd be more then happy to give you some great feedback or fill out some microsoft surveys. Does it require a MS SQL database or can I use MySQL? We have a desktop application

RE: Time Tracking software for multiple users

2008-08-24 Thread Kevin Aebig
I'm nearly complete a more robust AIR / PHP application that has all that and a few other handy features. If you want, I can email you when it's ready to go to Beta. I might even make a port to CF. ;) !k -Original Message- From: Jeff Gladnick [mailto:[EMAIL PROTECTED] Sent: Saturday,

Re: Time Tracking software for multiple users

2008-08-24 Thread Jeff Gladnick
I would be very interested! shoot me an email at jeffglad a t ^^ gmail I'm nearly complete a more robust AIR / PHP application that has all that and a few other handy features. If you want, I can email you when it's ready to go to Beta. I might even make a port to CF. ;) !k I am

Bind Syntax question...

2008-08-24 Thread Tom Jones
Hello, I've been reading through the CFML docs and I cant seem to find he answer to this. If I use and the bind property in a tag does the cfc have to be in the same parent directory as the cfm file? I usually like to pt all of my cfc files in a separate directory. Thanks, tom

RE: Bind Syntax question...

2008-08-24 Thread MariusMilosav
No, you can put it in another directory and then specify the full path when calling it: bind=cfc:fullpath.toyour.cfcs.cfcName.functionName()... so the directory structure will be like this: fullpath/toyour/cfcs/cfcName.cfc Regards Marius Milosav ScorpioSoft Corp. www.scorpiosoft.com

Re: Bind Syntax question...

2008-08-24 Thread Tom Jones
Thanks! tom On Aug 24, 2008, at 3:26 PM, MariusMilosav wrote: No, you can put it in another directory and then specify the full path when calling it: bind=cfc:fullpath.toyour.cfcs.cfcName.functionName()... so the directory structure will be like this: fullpath/toyour/cfcs/cfcName.cfc

Coldfusion 8 on Linux Installation ( Linus ver. ie. Aspire One laptop )

2008-08-24 Thread Don
Has anyone successfully installed Coldfusion 8 ( server ) for development purposes on said laptop? http://www.acer.com/aspireone/ I am thinking about getting one for Java work... I'm pretty sure Java will not be a problem with it... But am not sure that I could install CF8 on it.

Re: cfhttp and Google Search Appliance

2008-08-24 Thread Kevin Stone
Hey Dave, I have finished the first version of my CF script that will talk with the Google mini Admin console but I am having trouble. Just briefly, I first cfhttp the google and I get a response with a cookie. In the data it sends back I can see it is on the page that requests that you make

Re: Coldfusion 8 on Linux Installation ( Linus ver. ie. Aspire One laptop )

2008-08-24 Thread Sherif Abdou
I looked at it and it seems to come with 512MB, now about a week ago I tried to Install ColdFusion on one of my old desktops and it would not start till i put 1.5GB of ram. The Jrun just gives memory errors so..., I know on Adobe it says Minimum of 512MB but I never was able to install. It was

RE: cfhttp and Google Search Appliance

2008-08-24 Thread Dave Watts
I have finished the first version of my CF script that will talk with the Google mini Admin console but I am having trouble. Just briefly, I first cfhttp the google and I get a response with a cookie. In the data it sends back I can see it is on the page that requests that you make sure

ANN: Open source ColdFusion CRM solution

2008-08-24 Thread Marius Milosav
Hello Everybody, I'm on cf-talk for a lng time and since I remember there were discussions (and complaints) about the lack of cf based open source applications. After some soul searching I have decided to release VICO solution as an open source application under the GPL3 license. VICO is a

Re: ANN: Open source ColdFusion CRM solution

2008-08-24 Thread Michael Dinowitz
Please clear any systems for sale, classes for pay, etc. with me before sending to the list. I'd like to prevent the list from becoming a free-for-all where each hosting company and product advertises. Thank you. On Mon, Aug 25, 2008 at 12:03 AM, Marius Milosav [EMAIL PROTECTED]wrote: Hello