CF Wiki

[James Holmes]

I know about SeedWiki and the option to get its source code. Are there
any other installable CF Wiki's I can look at?



~|
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:207624
Archives: http://www.houseoffusion.com/cf_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: Captivate list?

[Brook Davies]

Start one!!

At 07:15 PM 5/24/2005, you wrote:
Is there a captivate list out there or do I have to start one?

I'd like to export a captivate audio clip to wav format. I did a 5 minute 
intro to my consuming web services presentation for CFUNITED and want to 
provide it as a 'podcast' without re-recording it.



~|
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:207625
Archives: http://www.houseoffusion.com/cf_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

Passing query from cf to java with cfobject

[Lee _]

Did you ever find an answer to this question?  I'm going crazy trying to figure 
it out.

 I'm having a problem trying to pass a query from coldfusion as an 
 argument to a Java class invoked through CFOBJECT.
 
 CF is supposed to convert Structures and Queries to java.util.Map when 
 passed in as a parameter to a cfobject call.  But the resulting object 
 in the java world is coldfusion.sql.QueryTable or coldfusion.runtime.
 Struct.  Is there a way to force these to be a map when passed in?
 
 Thanks
-Mark

~|
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:207626
Archives: http://www.houseoffusion.com/cf_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

Wierd file permission issue with cffile

[Rick Root]

Before I contact my hosting provider (smarterlinux/hostmysite), has 
anyone ever seen this before?

Security: The requested template has been denied access to 
/usr/local/smarterlinux/coldfusionmx/runtime/servers/default/SERVER-INF/temp/wwwroot-tmp/neotmp47693.tmp.
 

The following is the internal exception message: access denied 
(java.io.FilePermission 
/usr/local/smarterlinux/coldfusionmx/runtime/servers/default/SERVER-INF/temp/wwwroot-tmp/neotmp47693.tmp
 
read)

It occurred while attempting to upload a file using CFFILE.

  - Rick


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

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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207627
Archives: http://www.houseoffusion.com/cf_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: Passing query from cf to java with cfobject

[S . Isaac Dealey]

CF only converts simple data types with JavaCast() as a means of
informing CF when there are overloaded methods in your Java object
receiving the arguments. There might be a way to return the java
resultset object from a query object using an undocumented method of
the query object. For a java.util.Map (which is the interface for
java.util.Hashtable and subsequently coldfusion.util.Hashtable) you
should be able to create a java hashtable object and insert all the
values from a struct this way:

cfset hashtable = createObject(java,java.util.hashTable)
cfset mystruct.putAll(hashtable)

Then pass the hashtable variable to your java object.

 Did you ever find an answer to this question?  I'm going
 crazy trying to figure it out.

 I'm having a problem trying to pass a query from
 coldfusion as an
 argument to a Java class invoked through CFOBJECT.

 CF is supposed to convert Structures and Queries to
 java.util.Map when
 passed in as a parameter to a cfobject call.  But the
 resulting object
 in the java world is coldfusion.sql.QueryTable or
 coldfusion.runtime.
 Struct.  Is there a way to force these to be a map when
 passed in?

 Thanks
 -Mark


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:207628
Archives: http://www.houseoffusion.com/cf_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:__Structures_vs._Real_Structures

[S . Isaac Dealey]

So their assessment could be correct that the built in scopes don't
have the same indexing and may not be as efficient... I'd bet the CF
engineers used similar indexing code in both the
coldfusion.filter.XScope and in coldfusion.util.FastHashtable. I've
not done any performance tests to compare the two, but I wouldn't
expect much variation between them in that regard.

 Yes, using getClass() on those returns
 coldfusion.filter.FormScope for
 the form scope and coldfusion.runtime.Struct for the
 struct.

 Working through Super classes from there, the form scope
 goes back
 through some CF scope classes to java.util.AbstractMap,
 while the struct
 goes back through coldfusion.util.FastHashtable to
 java.util.Hashtable.


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:207629
Archives: http://www.houseoffusion.com/cf_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: Wierd file permission issue with cffile

[James Holmes]

Yes, they need to open up that dir in your sandbox. This is standard for
a sandboxed server.

-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 25 May 2005 8:49 
To: CF-Talk
Subject: Wierd file permission issue with cffile

Before I contact my hosting provider (smarterlinux/hostmysite), has
anyone ever seen this before?

Security: The requested template has been denied access to
/usr/local/smarterlinux/coldfusionmx/runtime/servers/default/SERVER-INF/
temp/wwwroot-tmp/neotmp47693.tmp. 

The following is the internal exception message: access denied
(java.io.FilePermission
/usr/local/smarterlinux/coldfusionmx/runtime/servers/default/SERVER-INF/
temp/wwwroot-tmp/neotmp47693.tmp
read)

It occurred while attempting to upload a file using CFFILE.

~|
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:207630
Archives: http://www.houseoffusion.com/cf_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

cfmail limiations

[Wurst, Keith D.]

hi everyone. has anyone ever experienced limitations the size of the
email address that can be used with cfmail in the cc attribute? i am
trying to use a rather large address and it seems to be failing. i'm
trying to figure out if it is a limitation of cfmail or if something
else is going wrong. 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:207631
Archives: http://www.houseoffusion.com/cf_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: 3.4 Drivers - Any Early Adopters Care To Comment?

[Damien McKenna]

Has anyone tried it on a production server yet?

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


~|
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:207632
Archives: http://www.houseoffusion.com/cf_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: CFFORM + FLASH

[Stuart Kidd]

Hi Dave,

Thanks for that, that's perfect.

Can I ask why it may come back and bite me in the ass so that maybe I can
fix it?

Cheers,

Saturday


On 25/5/05 01:45, dave [EMAIL PROTECTED] wrote:

 for one you are trying to be sneaky with the password variable which of course
 can/will/shall come back to bite you in the ass.
 
  but, since this is what you are doing why not  add some .as script to the
 filed just like you did with pw filed?
  onsubmit=if( numberOfReplies.text != '---' )
  alert('please select an email option'); return false;²
 
 ~Dave the disruptor~
 
 
 From: Stuart Kidd [EMAIL PROTECTED]
 Sent: Tuesday, May 24, 2005 4:57 PM
 To: CF-Talk cf-talk@houseoffusion.com
 Subject: CFFORM + FLASH
 
 Hi guys,
 
 I¹m using the CFFORM tag and wanted to add some extra validation.
 
 My tag is like so:
 
  action = /?kissMyDate=yes
  format = Flash
  skin = haloBlue
  width = 400 height=420
  name=Part1
  onsubmit=if( password.text != '#GetUser.password#' ) {
 alert('Password is incorrect'); return false;}²
 
 I added the password validation and that worked no problem, but now I¹d like
 to make sure that a user always makes a selection from a combo box and NOT
 choose the value which is ³² (
 value=---).
 
 value=#GetAdvert.numberOfReplies# selectedCurrently:
 #GetAdvert.numberOfReplies#
  ---
  5
  10
  25
  Unlimited
  No more, I've had enough!
 
 As it stands if the user chooses
 value=--- the form doesn¹t have an error pop up.
 
 I thought of either doing some javascript in the cfselect or possibly adding
 something to the  tag similar to the onsubmit.
 
  action = /?kissMyDate=yes
  format = Flash
  skin = haloBlue
  width = 400 height=420
  name=Part1
  onsubmit=if( password.text != '#GetUser.password#' ) {
 alert('Password is incorrect'); return false;}
  onsubmit=if( numberOfReplies.text != '' ) { alert('Please choose
 max emails to receive'); return false;}²
 
 Unfortunately the above comes up with an error.
 
 If anyone could help it would be greatly appreciated.
 
 Thanks,
 
 Saturday
 
 
 
 

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

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

CFSET construct

[Stuart Kidd]

Hi guys,

I¹m trying to put together a CFSET construct but am having probs:

cfset client.KissMyDate_DisplayMessage = 'Unfortunately this user has
decided not to receive anymore responses to this advert.'  cfif
FindMatches.gender eq 'male''He'cfelse'She'/cfif  'may change this in
the near future however.'

Could somebody please point out what I am doing wrong, is it not okay to
have ampersands in constructs?

Thanks,

Saturday




~|
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:207634
Archives: http://www.houseoffusion.com/cf_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: CFSET construct

[Allan Cliff]

cfif FindMatches.gender eq 'male'CFSET newgender = 'He'cfelseCFSET 
newgender = 'She'/cfif

cfset client.KissMyDate_DisplayMessage = 'Unfortunately this user has decided 
not to receive anymore responses to this advert.'  newgender  ' may change 
this in the near future however.'

-Original Message-
From: Stuart Kidd [mailto:[EMAIL PROTECTED] 
Sent: 25 May 2005 16:03
To: CF-Talk
Subject: CFSET construct


Hi guys,

I¹m trying to put together a CFSET construct but am having probs:

cfset client.KissMyDate_DisplayMessage = 'Unfortunately this user has decided 
not to receive anymore responses to this advert.'  cfif FindMatches.gender eq 
'male''He'cfelse'She'/cfif  'may change this in the near future however.'

Could somebody please point out what I am doing wrong, is it not okay to have 
ampersands in constructs?

Thanks,

Saturday






~|
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:207635
Archives: http://www.houseoffusion.com/cf_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: CFSET construct

[Ian Skinner]

NO, it's not ok to have nested tags inside a cfset tag, or any other tag for 
that matter.

cfset client.KissMyDate_DisplayMessage = 'Unfortunately this user has decided 
not to receive anymore responses to this advert.'  #iif( FindMatches.gender eq 
'male',DE('He'),DE('She'))#  'may change this in the near future however.'

You could use the IIF function here, but I'm sure there are better ways to do 
this all around.

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

-Original Message-
From: Stuart Kidd [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 25, 2005 7:03 AM
To: CF-Talk
Subject: CFSET construct

Hi guys,

I¹m trying to put together a CFSET construct but am having probs:

cfset client.KissMyDate_DisplayMessage = 'Unfortunately this user has
decided not to receive anymore responses to this advert.'  cfif
FindMatches.gender eq 'male''He'cfelse'She'/cfif  'may change this
in
the near future however.'

Could somebody please point out what I am doing wrong, is it not okay to
have ampersands in constructs?

Thanks,

Saturday






~|
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:207636
Archives: http://www.houseoffusion.com/cf_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: CFSET construct

[Steven Brownlee]

It's not ok to have other ColdFusion tags inside a CFSET.  You'll have 
to put the condition outside.

cfif findMatches.gender eq male
cfset gender = He
cfelse
cfset gender = She
/cfif

cfset client.KissMyDate_DisplayMessage = gender  rest of message

Stuart Kidd wrote:
 Hi guys,
 
 I¹m trying to put together a CFSET construct but am having probs:
 
 cfset client.KissMyDate_DisplayMessage = 'Unfortunately this user has
 decided not to receive anymore responses to this advert.'  cfif
 FindMatches.gender eq 'male''He'cfelse'She'/cfif  'may change this in
 the near future however.'
 
 Could somebody please point out what I am doing wrong, is it not okay to
 have ampersands in constructs?
 
 Thanks,
 
 Saturday
 
 
 
 
 

~|
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:207637
Archives: http://www.houseoffusion.com/cf_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: CFSET construct

[Dawson, Michael]

Or use cfsavecontent.

M!ke

-Original Message-
From: Steven Brownlee [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, May 25, 2005 9:10 AM
To: CF-Talk
Subject: Re: CFSET construct

It's not ok to have other ColdFusion tags inside a CFSET.  You'll have
to put the condition outside.

cfif findMatches.gender eq male
cfset gender = He
cfelse
cfset gender = She
/cfif

cfset client.KissMyDate_DisplayMessage = gender  rest of message

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

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

Slightly OT: Dreamweaver Error

[Smith, Daron [PA]]

When loading dreamweaver I get the following error:

While executing onLoad in RestoreDebugButton.htm, the following
JavaScript error ( s)
occurred   : In file RestoreDebugButton: ReferenceError:
restoreLiveDebugButton is not defined

When saving a file a get the following error:

While executing onLoad in tempURL_afterSavehtm, the following JavaScript
error(s) 
occurred: In file tempURL_afterSave: ReferenceError: afterSave is
not defined

Any ideas?  Just reinstall Dreamweaver?

Thanks,
Daron Smith

~|
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:207640
Archives: http://www.houseoffusion.com/cf_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: Running MS Access macro in Coldfusion

[Claude Schneegans]

 Is there any setting I need to change so that I can run the macro in CF?

TMK, no way! Access is Access, CF is CF. You can query Access Queries 
from CF, which are like views,
but macros are VBasic programs that would need Access to be installed on 
the server, which is rarely the case.

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


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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207640
Archives: http://www.houseoffusion.com/cf_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: Migrate Settings from 6.1 to 7

[Qasim Rasheed]

I second the suggestion for CAR files. 

Qasim

On 5/23/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
 One other option is to see if the hosting company will create a .car archive
 for you although to deploy it you may need CF enterprise.
 
 Kola
 
  -Original Message-
  From: jonese [mailto:[EMAIL PROTECTED]
  Sent: 23 May 2005 20:16
  To: CF-Talk
  Subject: Re: Migrate Settings from 6.1 to 7
 
  J,
  We are moving hosting companies so we don't have this ability.
   jonese
 
   On 5/23/05, Jared Rypka-Hauer - CMG, LLC [EMAIL PROTECTED] wrote:
  
   You'd be better off to copy the CFusionMX folder to the new server and
   install 7 to let it handle its own upgrade process than to try migrating
   settings after the fact. If you do that, 7 will self-integrate all the
   settings from 6.1 the first time you run CFAdmin.
  
   Laterz,
   J
  
   On 5/23/05, jonese [EMAIL PROTECTED] wrote:
   
Is there any easy way to migrate mappings and datasources from CF6.1
  to
   CF
7
when they are on two differant servers?
Can i just copy the .xml files from one to the other?
jonese
   
  
  
  
   --
   ---
   -
   Buy SQLSurveyor!
   http://www.web-relevant.com/sqlsurveyor
   Never make your developers open Enterprise Manager again.
  
  
  
 
 
 
 

~|
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:207641
Archives: http://www.houseoffusion.com/cf_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: CFSET construct

[Stuart Kidd]

Thanks to everyone with their help on that, it's all now solved. :)




~|
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:207642
Archives: http://www.houseoffusion.com/cf_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: Slightly OT: Dreamweaver Error

[Massimo Foti]

 Any ideas?

If you have any extension installed (maybe the CF 7 package?), just unistall
them first.

Before going to install the app from scratch, you could first try deleting
your local configuration folder. To locate the folder follow this technote:
http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_16420

Apart from this, I have no suggestions, sorry.


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





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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207643
Archives: http://www.houseoffusion.com/cf_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: 3.4 Drivers - Any Early Adopters Care To Comment?

[Adrocknaphobia]

I'm deploying it to production on Tuesday. I've been hitting it pretty
constantly on dev, CFMX6.1Updater --- Oracle9i without problem.
Although we only run storedProcs.

-Adam

On 5/25/05, Damien McKenna [EMAIL PROTECTED] wrote:
 Has anyone tried it on a production server yet?
 
 --
 Damien McKenna - Web Developer - [EMAIL PROTECTED]
 The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
 #include stdjoke.h
 
 
 

~|
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:207644
Archives: http://www.houseoffusion.com/cf_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: Running MS Access macro in Coldfusion

[Matthew Small]

You can do it, you do need Access installed on the server and you need
instantiate an Access COM object.  It's not worth it unless you really,
really need the macro.

- Matt Small

-Original Message-
From: Claude Schneegans [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, May 25, 2005 10:21 AM
To: CF-Talk
Subject: Re: Running MS Access macro in Coldfusion

 Is there any setting I need to change so that I can run the macro in CF?

TMK, no way! Access is Access, CF is CF. You can query Access Queries 
from CF, which are like views,
but macros are VBasic programs that would need Access to be installed on 
the server, which is rarely the case.

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




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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207645
Archives: http://www.houseoffusion.com/cf_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: Viewing files in another server/directory outside CF server

[Michel Deloux]

Thanks Deanna

but displaying all files in Mozilla works fine. But with IE that same
code, same link, same properties don't. IE displays a Unknown file -
Do you want to save, open, cancel, bla bla bla... What's happening?

Thanx for your time.

2005/5/24, Deanna Schneider [EMAIL PROTECTED]:
 That's the proper behavior. If you want them to display in the browser,
 you'll ned to change your value=attachment;  to value=inline;
 
 - Original Message -
 From: Michel Deloux [EMAIL PROTECTED]
 To: CF-Talk cf-talk@houseoffusion.com
 Sent: Tuesday, May 24, 2005 2:49 PM
 Subject: Re: Viewing files in another server/directory outside CF server
 
  Using CFCONTENT and CFHEADER with MS Word files show me a
  Save/Download screen in IE. Please look my simple code:
 
  view_files.cfm?fileX=file://CA_LA_Fresno/systems/Fresno2004_12.doc
 
  in view_files I remove file: and change / bar to \ bar and after::
 
  cfheader name=Content-Disposition value=attachment;
  filename=#URL.fileX#
 
  cfcontent type=application/msword file=#URL.fileX# deletefile=No
 
  Whta's happened?
 
  Thanx
 
 
 
 

~|
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:207646
Archives: http://www.houseoffusion.com/cf_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: Viewing files in another server/directory outside CF server

[Dave Watts]

 but displaying all files in Mozilla works fine. But with IE that same
 code, same link, same properties don't. IE displays a Unknown file -
 Do you want to save, open, cancel, bla bla bla... What's happening?

You might find these code snippets helpful:
http://www.figleaf.com/demo/mimetest/

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:207647
Archives: http://www.houseoffusion.com/cf_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: CFFORM + FLASH

[Joe Rinehart]

Stuart,

You're passing the user's correct password to the clientside - someone
will figure out how to sniff it, it's not hard to open up Flash...

-Joe

On 5/25/05, Stuart Kidd [EMAIL PROTECTED] wrote:
 Hi Dave,
 
 Thanks for that, that's perfect.
 
 Can I ask why it may come back and bite me in the ass so that maybe I can
 fix it?
 
 Cheers,
 
 Saturday
 
 
 On 25/5/05 01:45, dave [EMAIL PROTECTED] wrote:
 
  for one you are trying to be sneaky with the password variable which of 
  course
  can/will/shall come back to bite you in the ass.
 
   but, since this is what you are doing why not add some .as script to the
  filed just like you did with pw filed?
   onsubmit=if( numberOfReplies.text != '---' )
   alert('please select an email option'); return false;²
 
  ~Dave the disruptor~
 
  
  From: Stuart Kidd [EMAIL PROTECTED]
  Sent: Tuesday, May 24, 2005 4:57 PM
  To: CF-Talk cf-talk@houseoffusion.com
  Subject: CFFORM + FLASH
 
  Hi guys,
 
  I¹m using the CFFORM tag and wanted to add some extra validation.
 
  My tag is like so:
 
   action = /?kissMyDate=yes
   format = Flash
   skin = haloBlue
   width = 400 height=420
   name=Part1
   onsubmit=if( password.text != '#GetUser.password#' ) {
  alert('Password is incorrect'); return false;}²
 
  I added the password validation and that worked no problem, but now I¹d like
  to make sure that a user always makes a selection from a combo box and NOT
  choose the value which is ³² (
  value=---).
 
  value=#GetAdvert.numberOfReplies# selectedCurrently:
  #GetAdvert.numberOfReplies#
   ---
   5
   10
   25
   Unlimited
   No more, I've had enough!
 
  As it stands if the user chooses
  value=--- the form doesn¹t have an error pop up.
 
  I thought of either doing some javascript in the cfselect or possibly adding
  something to the  tag similar to the onsubmit.
 
   action = /?kissMyDate=yes
   format = Flash
   skin = haloBlue
   width = 400 height=420
   name=Part1
   onsubmit=if( password.text != '#GetUser.password#' ) {
  alert('Password is incorrect'); return false;}
   onsubmit=if( numberOfReplies.text != '' ) { alert('Please choose
  max emails to receive'); return false;}²
 
  Unfortunately the above comes up with an error.
 
  If anyone could help it would be greatly appreciated.
 
  Thanks,
 
  Saturday
 
 
 
 
 
 

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

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

Nest query inside structure in CFMX web service?

[Ben Mueller]

I found a solution, though I admit I'm not totally happy with it.  I can 
serialize a query into WDDX, then add it to my structure that is returned by 
the web service.  On the other side, I can pick up that WDDX object, and 
de-serialize it back into a CF query object.  That seems to work, but I worry 
about performance issues, and I don't really like the fact that the 
de-serializing step is required on the other end.  It makes my data a little 
harder to understand out of the box.



 I would like to nest a query object inside of a structure that is 
 returned by a web service I'm building.  The web service is to be 
 consumed by CFMX.  I thought I had it working at one point, but now I 
 get an ugly error that says the QueryBean cannot be deserialized.  
 
 So, now I'm wondering if I imagined my initial success.  Is what I 
 want to do legal?
 
 Thanks in advance,
 Ben 
Mueller

~|
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:207649
Archives: http://www.houseoffusion.com/cf_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: Viewing files in another server/directory outside CF server

[Pascal Peters]

cfheader name=Content-Disposition value=inline;
filename=#GetFileFromPath(URL.fileX)#
cfcontent type=application/msword file=#URL.fileX#
deletefile=No

Does this work the way you intended??

Pascal

 -Original Message-
 From: Michel Deloux [mailto:[EMAIL PROTECTED]
 Sent: 25 May 2005 16:55
 To: CF-Talk
 Subject: Re: Viewing files in another server/directory outside CF
server
 
 Thanks Deanna
 
 but displaying all files in Mozilla works fine. But with IE that same
 code, same link, same properties don't. IE displays a Unknown file -
 Do you want to save, open, cancel, bla bla bla... What's happening?
 
 Thanx for your time.
 
 2005/5/24, Deanna Schneider [EMAIL PROTECTED]:
  That's the proper behavior. If you want them to display in the
browser,
  you'll ned to change your value=attachment;  to value=inline;
 
  - Original Message -
  From: Michel Deloux [EMAIL PROTECTED]
  To: CF-Talk cf-talk@houseoffusion.com
  Sent: Tuesday, May 24, 2005 2:49 PM
  Subject: Re: Viewing files in another server/directory outside CF
server
 
   Using CFCONTENT and CFHEADER with MS Word files show me a
   Save/Download screen in IE. Please look my simple code:
  
   view_files.cfm?fileX=file://CA_LA_Fresno/systems/Fresno2004_12.doc
  
   in view_files I remove file: and change / bar to \ bar and after::
  
   cfheader name=Content-Disposition value=attachment;
   filename=#URL.fileX#
  
   cfcontent type=application/msword file=#URL.fileX#
 deletefile=No
  
   Whta's happened?
  
   Thanx
  
  
 
 
 
 

~|
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:207650
Archives: http://www.houseoffusion.com/cf_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: Viewing files in another server/directory outside CF server

[Jim Davis]

As I'm reading it this is normal.  The file format may be known but the file
itself is unknown - it could pose a security risk.

The user is always given the option to ignore the download, open it
immediately or save it for later (or for virus checking).

What behavior are you seeing in the other browsers?  Are they opening the
file directly (which seems reckless to me)?

Jim Davis




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

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

cfif with AND and OR statements

[Cameron Johnson]

I've got the following cfif statement in one of my header pages:

cfif (isDefined(URL.ItemNumber) AND URL.ItemNumber NEQ 12345) OR 
(CGI.SCRIPT_NAME NEQ '/page.cfm') 
show table 1
cfelse
show table 2
/cfif

Here are my scenarios:

- when the cfif is combined into one statement, it works correctly (meaning I 
see table 2) when browsing to /page.cfm. But it doesn't work when browsing to 
index.cfm?ItemNumber=12345

- if I split the statement into two cfif statements, I see table 2 on both 
/page.cfm and index.cfm?ItemNumber=12345

Any ideas why it's not working on index.cfm?ItemNumber=12345 when the statement 
is combined? Is something wrong with the cfif that I'm not seeing?

Appreciate the help.

- Cameron

~|
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:207652
Archives: http://www.houseoffusion.com/cf_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: CFUNITED interview 11 - Web services, CF and Pocket PC

[Connie DeCinko]

Dave!

I really really need a copy of this presentation or a copy of your app or to
pick your brain.  I've got a PPC app that dumps to MySQL that then displays
with CFMX7.  I'd love to tighten this up and rewrite it.
 

-Original Message-
Subject: CFUNITED interview 11 - Web services, CF and Pocket PC

Developing Pocket PC Applications using .NET Compact Framework and CFMX 
Web Services interview with Dave Watts
*
Michael Smith: This time we are talking with Dave Watts about his
CFUNITED-05 
talk Developing Pocket PC Applications using .NET Compact Framework and
CFMX 
Web Services. So why should a developer come to your session Dave?




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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207653
Archives: http://www.houseoffusion.com/cf_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: Slightly OT: Dreamweaver Error

[dsmith]

Before going to install the app from scratch, you could first try deleting
your local configuration folder. To locate the folder follow this technote:
http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_16420


This worked, thank you!

~|
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:207654
Archives: http://www.houseoffusion.com/cf_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: Viewing files in another server/directory outside CF server

[Kevin Aebig]

Unless the users internet options have been changed, There would be a
prompt. Or if the link was using a custom protocal such as the myapp://, I
suppose this could get around the prompts as well.

Kevin

-Original Message-
From: Jim Davis [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 25, 2005 9:10 AM
To: CF-Talk
Subject: RE: Viewing files in another server/directory outside CF server


As I'm reading it this is normal.  The file format may be known but the file
itself is unknown - it could pose a security risk.

The user is always given the option to ignore the download, open it
immediately or save it for later (or for virus checking).

What behavior are you seeing in the other browsers?  Are they opening the
file directly (which seems reckless to me)?

Jim Davis






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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207655
Archives: http://www.houseoffusion.com/cf_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: cfif with AND and OR statements

[Pascal Peters]

What are you trying to achieve?? You should see table 1 on page.cfm and
if there is a url parameter named ItemNumber that isn't 12345. At least,
that is what you wrote.

Pascal

 -Original Message-
 From: Cameron Johnson [mailto:[EMAIL PROTECTED]
 Sent: 25 May 2005 17:23
 To: CF-Talk
 Subject: cfif with AND and OR statements
 
 I've got the following cfif statement in one of my header pages:
 
 cfif (isDefined(URL.ItemNumber) AND URL.ItemNumber NEQ 12345) OR
 (CGI.SCRIPT_NAME NEQ '/page.cfm')
 show table 1
 cfelse
 show table 2
 /cfif
 
 Here are my scenarios:
 
 - when the cfif is combined into one statement, it works correctly
 (meaning I see table 2) when browsing to /page.cfm. But it doesn't
work
 when browsing to index.cfm?ItemNumber=12345
 
 - if I split the statement into two cfif statements, I see table 2 on
both
 /page.cfm and index.cfm?ItemNumber=12345
 
 Any ideas why it's not working on index.cfm?ItemNumber=12345 when the
 statement is combined? Is something wrong with the cfif that I'm not
 seeing?
 
 Appreciate the help.
 
 - Cameron
 
 

~|
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:207656
Archives: http://www.houseoffusion.com/cf_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: String to SHA1 to Base 64 Encryption Help!

[Aldon]

Original=12345678910111213141516171819202122
Converted=iR2kmtngiYH/aVQdkkid5O4/mn0=

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 24, 2005 5:04 AM
To: CF-Talk
Subject: Re: String to SHA1 to Base 64 Encryption Help!


Aldon wrote:

 Imports System.Security.Cryptography
 Private Function ComputeHash(ByVal Key As String) As String
 Dim objSHA1 As New SHA1CryptoServiceProvider
 objSHA1.ComputeHash(System.Text.Encoding.UTF8.GetBytes(Key.ToCharArray))
 Dim buffer() As Byte = objSHA1.Hash
 Dim HashValue As String = System.Convert.ToBase64String(buffer)

This is Base64 encoded.


 http://www.cflib.org/udf.cfm?ID=34

It looks like this is Hex.

How do the strings look?

Jochem



~|
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:207657
Archives: http://www.houseoffusion.com/cf_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: cfif with AND and OR statements

[Ian Skinner]

A = isDefined(url.ItemNumber)
B = URL.ItemNumber NEQ 12345
C = CGI.SCRIPT_NAME NEQ '/page.cfm'

CASE 1
url.itemNumber UNDEFINED
CGI.ScriptName = 'page.cfm'

IF (A AND B) OR C
IF (F AND F) OR F
IF F OR F
FALSE Clause Run

CASE 2
url.itemNumber = 12345
cgi.ScriptName = 'index.cfm'

IF (A ND B) OR C
IF (T AND F) OR F
IF F OR F
FALSE Clause Run

Is this not the result you are getting?  Is this not the result you are 
expecting?

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

-Original Message-
From: Cameron Johnson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 25, 2005 8:23 AM
To: CF-Talk
Subject: cfif with AND and OR statements

I've got the following cfif statement in one of my header pages:

cfif (isDefined(URL.ItemNumber) AND URL.ItemNumber NEQ 12345) OR
(CGI.SCRIPT_NAME NEQ '/page.cfm')
show table 1
cfelse
show table 2
/cfif

Here are my scenarios:

- when the cfif is combined into one statement, it works correctly
(meaning I see table 2) when browsing to /page.cfm. But it doesn't work
when browsing to index.cfm?ItemNumber=12345

- if I split the statement into two cfif statements, I see table 2 on
both /page.cfm and index.cfm?ItemNumber=12345

Any ideas why it's not working on index.cfm?ItemNumber=12345 when the
statement is combined? Is something wrong with the cfif that I'm not
seeing?

Appreciate the help.

- Cameron



~|
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:207658
Archives: http://www.houseoffusion.com/cf_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: String to SHA1 to Base 64 Encryption Help!

[Jochem van Dieten]

Aldon wrote:
 Original=12345678910111213141516171819202122
 Converted=iR2kmtngiYH/aVQdkkid5O4/mn0=

I presume that is the converted output as generated by .NET? In 
that case, download http://www.cflib.org/udf.cfm?ID=1016 and try:

CFSET message=This is a test
CFOUTPUT
Given message=#message#
The Base64 encoded SHA-1 message digest is: 
#ToBase64(hexToString(sha1(message)))#
/CFOUTPUT

Jochem

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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207659
Archives: http://www.houseoffusion.com/cf_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: cfif with AND and OR statements

[Dave Francis]

Isn't CASE 2, condition C True? ie. index.cfm NEQ page.cfm

-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 25, 2005 11:41 AM
To: CF-Talk
Subject: RE: cfif with AND and OR statements


A = isDefined(url.ItemNumber)
B = URL.ItemNumber NEQ 12345
C = CGI.SCRIPT_NAME NEQ '/page.cfm'

CASE 1
url.itemNumber UNDEFINED
CGI.ScriptName = 'page.cfm'

IF (A AND B) OR C
IF (F AND F) OR F
IF F OR F
FALSE Clause Run

CASE 2
url.itemNumber = 12345
cgi.ScriptName = 'index.cfm'

IF (A ND B) OR C
IF (T AND F) OR F
IF F OR F
FALSE Clause Run

Is this not the result you are getting?  Is this not the result you are
expecting?

--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

C code. C code run. Run code run. Please!
- Cynthia Dunning

.-Original Message-
.From: Cameron Johnson [mailto:[EMAIL PROTECTED]
.Sent: Wednesday, May 25, 2005 8:23 AM
.To: CF-Talk
.Subject: cfif with AND and OR statements
.
.I've got the following cfif statement in one of my header pages:
.
.cfif (isDefined(URL.ItemNumber) AND URL.ItemNumber NEQ 12345) OR
.(CGI.SCRIPT_NAME NEQ '/page.cfm')
.show table 1
.cfelse
.show table 2
./cfif
.
.Here are my scenarios:
.
.- when the cfif is combined into one statement, it works correctly
.(meaning I see table 2) when browsing to /page.cfm. But it doesn't work
.when browsing to index.cfm?ItemNumber=12345
.
.- if I split the statement into two cfif statements, I see table 2 on
.both /page.cfm and index.cfm?ItemNumber=12345
.
.Any ideas why it's not working on index.cfm?ItemNumber=12345 when the
.statement is combined? Is something wrong with the cfif that I'm not
.seeing?
.
.Appreciate the help.
.
.- Cameron
.
.



~|
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:207660
Archives: http://www.houseoffusion.com/cf_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: cfif with AND and OR statements

[Ian Skinner]

Your right it is and thus the true clause would run.  Apparently it was too 
early in the morning for me to be doing Boolean logic.  Corrected results below.

IF (A AND B) OR C
IF (F AND F) OR F
IF F OR F
FALSE Clause Run

CASE 2
url.itemNumber = 12345
cgi.ScriptName = 'index.cfm'

IF (A ND B) OR C
IF (T AND F) OR T
IF F OR T
TRUE Clause Run

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

-Original Message-
From: Dave Francis [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 25, 2005 8:57 AM
To: CF-Talk
Subject: RE: cfif with AND and OR statements

Isn't CASE 2, condition C True? ie. index.cfm NEQ page.cfm

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:207661
Archives: http://www.houseoffusion.com/cf_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: js popup resizing ?

[Bryan Stevenson]

I forgot to mention there is a seperate page with more js in it that does 
the resizing
 oopsy on me, sorry bout that

 ~Dave the disruptor~

Uh huhthat might help Dave ;-)

I do beleive the disruptor is only set on stun today ;-)

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


~|
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:207662
Archives: http://www.houseoffusion.com/cf_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: CFFORM + FLASH

[Stuart Kidd]

Didn't think of that!  Okay, I will take that out and just check password on
the server side only.

On a different topic (sort of), is that the case for client variables also,
can users work a way of getting those?

Thanks,

Stuart


On 25/5/05 16:06, Joe Rinehart [EMAIL PROTECTED] wrote:

 Stuart,
 
 You're passing the user's correct password to the clientside - someone
 will figure out how to sniff it, it's not hard to open up Flash...
 
 -Joe
 
 On 5/25/05, Stuart Kidd [EMAIL PROTECTED] wrote:
 Hi Dave,
 
 Thanks for that, that's perfect.
 
 Can I ask why it may come back and bite me in the ass so that maybe I can
 fix it?
 
 Cheers,
 
 Saturday
 
 
 On 25/5/05 01:45, dave [EMAIL PROTECTED] wrote:
 
 for one you are trying to be sneaky with the password variable which of
 course
 can/will/shall come back to bite you in the ass.
 
  but, since this is what you are doing why not add some .as script to the
 filed just like you did with pw filed?
  onsubmit=if( numberOfReplies.text != '---' )
  alert('please select an email option'); return false;²
 
 ~Dave the disruptor~
 
 
 From: Stuart Kidd [EMAIL PROTECTED]
 Sent: Tuesday, May 24, 2005 4:57 PM
 To: CF-Talk cf-talk@houseoffusion.com
 Subject: CFFORM + FLASH
 
 Hi guys,
 
 I¹m using the CFFORM tag and wanted to add some extra validation.
 
 My tag is like so:
 
  action = /?kissMyDate=yes
  format = Flash
  skin = haloBlue
  width = 400 height=420
  name=Part1
  onsubmit=if( password.text != '#GetUser.password#' ) {
 alert('Password is incorrect'); return false;}²
 
 I added the password validation and that worked no problem, but now I¹d like
 to make sure that a user always makes a selection from a combo box and NOT
 choose the value which is ³² (
 value=---).
 
 value=#GetAdvert.numberOfReplies# selectedCurrently:
 #GetAdvert.numberOfReplies#
  ---
  5
  10
  25
  Unlimited
  No more, I've had enough!
 
 As it stands if the user chooses
 value=--- the form doesn¹t have an error pop up.
 
 I thought of either doing some javascript in the cfselect or possibly adding
 something to the  tag similar to the onsubmit.
 
  action = /?kissMyDate=yes
  format = Flash
  skin = haloBlue
  width = 400 height=420
  name=Part1
  onsubmit=if( password.text != '#GetUser.password#' ) {
 alert('Password is incorrect'); return false;}
  onsubmit=if( numberOfReplies.text != '' ) { alert('Please choose
 max emails to receive'); return false;}²
 
 Unfortunately the above comes up with an error.
 
 If anyone could help it would be greatly appreciated.
 
 Thanks,
 
 Saturday
 
 
 
 
 
 
 
 

~|
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:207663
Archives: http://www.houseoffusion.com/cf_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: cfif with AND and OR statements

[Joe Kelly]

Not sure if this is what your asking for after deciphering your question

cfif (isDefined(URL.ItemNumber) AND (URL.ItemNumber IS 12345) OR
(CGI.SCRIPT_NAME IS '/page.cfm'))
!--- if ItemNumber is 12345,  also if page.cfm, but the item number
has to be present in both cases ---
show table 2
cfelse
!--- everything else ---
show table 1
/cfif

-- 
Thanks,
Joe Kelly

~|
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:207664
Archives: http://www.houseoffusion.com/cf_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 Coding

[Troy Jones]

I'm looking for Lewis' TCPClient object as well.  If anyone could send it to me 
it would save me a LOT of work, as it definitely seems to have disappeared form 
the net...

Thanks!

-Troy-

The IHTK does just that...I can mail you it offlist as I think Lewis Sellars
(the author) has disappeared from the list and the net...



-Original Message-
From: Chad McCue [mailto:[EMAIL PROTECTED] 
Sent: 06 May 2005 15:37
To: CF-Talk
Subject: IIS Coding

Does anyone know of any cf applications that can dynamically write to IIS?
If someone knows of a VB or ASP program that would be fine also.

~|
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:207665
Archives: http://www.houseoffusion.com/cf_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: Passing query from cf to java with cfobject

[Lee _]

Thanks for the reply.  I was able to retrieve a resultset object using the 
undocumented methods, but since it is not a supported feature I cannot use it.  

From Macromedia's documentation: 
...The following table lists how ColdFusion converts ColdFusion data values to 
Java data types when passing arguments. The left column represents the 
underlying ColdFusion representation of its data. The right column indicates 
the Java data types into which ColdFusion can automatically convert the data:
Query object   |  java.util.Map ...

Unfortunately, I'm beginning to suspect it does not work in the version I'm 
using. 

Originally, I was hoping I did not have to convert the query to a java object 
manually, but your example works fine and is less painful then I thought :)  
Thanks for all the great suggestions.


CF only converts simple data types with JavaCast() as a means of
informing CF when there are overloaded methods in your Java object
receiving the arguments. There might be a way to return the java
resultset object from a query object using an undocumented method of
the query object. For a java.util.Map (which is the interface for
java.util.Hashtable and subsequently coldfusion.util.Hashtable) you
should be able to create a java hashtable object and insert all the
values from a struct this way:

cfset hashtable = createObject(java,java.util.hashTable)
cfset mystruct.putAll(hashtable)

Then pass the hashtable variable to your java object.


~|
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:207666
Archives: http://www.houseoffusion.com/cf_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: Running MS Access macro in Coldfusion

[Claude Schneegans]

 It's not worth it unless you really, really need the macro.

This is what I meant. Any macro could be emulated more efficiently in CF.

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


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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207667
Archives: http://www.houseoffusion.com/cf_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: Java and JVM page in CF Administrator

[B G]

Right, I had forgotten about jvm.config.  That's not a problem.  I'm not too 
familiar with J2EE, but I'm pretty sure my setup is not.  Would it be 
reported in the complete SETTINGS list?  Or license?  Also, if not J2EE, do 
I have a corrupt installation?

Thanks.

From: Douglas Knudsen [EMAIL PROTECTED]
Reply-To: cf-talk@houseoffusion.com
To: CF-Talk cf-talk@houseoffusion.com
Subject: Re: Java and JVM page in CF Administrator
Date: Tue, 24 May 2005 17:31:53 -0400

sounds like you have the J2EE version with full Jrun. In this case the
CFAdmin tool doesn't have this. You can use the JMC, I think its fixed now,
used to have a bug that messedup your JVM settings. Personally, I mod these
directly. See JRun/bin for your jvm.config. Note by default, this file
applies to all JRun instances.

DK

On 5/24/05, B G [EMAIL PROTECTED] wrote:
 
  This question is in regards to CFMX 6.1 Enterprise.
 
  I am working on a box I inherited and in the admin there is no link to 
the
  Java and JVM settings. I have never seen this before and I have no idea
  where to even look to correct this. Could the installation be corrupt? 
All
  CF pages seem to behave correctly but I cannot edit the Class Path for a
  new
  app I am trying to install.
 
  Any ideas? Thanks in advance!
 
  BG
 
 
 
 



~|
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:207668
Archives: http://www.houseoffusion.com/cf_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: cfif with AND and OR statements

[Cameron Johnson]

Mapping out the givens and the cases like that made me see the hole in the 
logic. I flipped the statement and it works in both cases: 

cfif CGI.SCRIPT_NAME EQ '/page.cfm' OR (isDefined(url.ItemNumber) AND 
url.ItemNumber EQ 12345)
show table 2
cfelse
show table 1
/cfif

Issue resolved. Thanks for the help and for the new mode of thinking.

- Cameron



 Your right it is and thus the true clause would run.  Apparently it 
 was too early in the morning for me to be doing Boolean logic.  
 Corrected results below.
 
.
 IF (A AND B) OR C
.
 IF (F AND F) OR F
.
 IF F OR F
.
 FALSE Clause Run
.
 
.
 CASE 2
.
 url.itemNumber = 12345
.
 cgi.ScriptName = 'index.cfm'
.
 
.
 IF (A ND B) OR C
.
 IF (T AND F) OR T
.
 IF F OR T
.
 TRUE Clause Run
 
 --
 Ian Skinner
 Web Programmer
 BloodSource
 www.BloodSource.org
 Sacramento, CA
 
 
 C code. C code run. Run code run. Please!
 - Cynthia Dunning
 
.
 -Original Message-
.
 From: Dave Francis [mailto:[EMAIL PROTECTED]
.
 Sent: Wednesday, May 25, 2005 8:57 AM
.
 To: CF-Talk
.
 Subject: RE: cfif with AND and OR statements
.
 
.
 Isn't CASE 2, condition C True? ie. index.cfm NEQ page.cfm
 
 Confidentiality Notice:  This message including any
 attachments is for the sole use of the intended
 recipient(s) and may contain confidential and privileged
 information. Any unauthorized review, use, disclosure or
 distribution is prohibited. If you are not the
 intended recipient, please contact the sender and
 delete any copies of this message. 
 

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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207669
Archives: http://www.houseoffusion.com/cf_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: Viewing files in another server/directory outside CF server

[Michel Deloux]

Thanx Jim

Using attachment or inline options IE don't show Open option only
Save and Cancel. And IE recognize original MS Word doc like unknown.
If user clicks Save needs to select a directory, name and so on...
Using Mozilla works fine: I click in Open File and MS Word shows
that... very crazy

Thanx all.


2005/5/25, Jim Davis [EMAIL PROTECTED]:
 As I'm reading it this is normal.  The file format may be known but the file
 itself is unknown - it could pose a security risk.
 
 The user is always given the option to ignore the download, open it
 immediately or save it for later (or for virus checking).
 
 What behavior are you seeing in the other browsers?  Are they opening the
 file directly (which seems reckless to me)?
 
 Jim Davis
 
 
 

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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207670
Archives: http://www.houseoffusion.com/cf_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: Viewing files in another server/directory outside CF server

[Dave Watts]

 Using attachment or inline options IE don't show Open option only
 Save and Cancel. And IE recognize original MS Word doc like unknown.
 If user clicks Save needs to select a directory, name and so on...
 Using Mozilla works fine: I click in Open File and MS Word shows
 that... very crazy

Are you setting the appropriate MIME type? Are you specifying a filename
with the appropriate extension?

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:207671
Archives: http://www.houseoffusion.com/cf_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

OT: Database Schema Options

[Dawson, Michael]

I am toying with a few different methods of creating a database schema
that will hold information about some rental properties the university
owns.

My first method was to create a schema that consisted of many tables,
one for each attribute, and then relate them to the properties table
with FKs.

This is my diagram:
http://acelinkdev.evansville.edu/Temp/Method1.gif
(This leads to many tables, but easy to control referential integrity.)

My second method was to create a single 'attributes' table that
contained, basically, all the other tables that stored attributes about
a house.

This is my diagram:
http://acelinkdev.evansville.edu/Temp/Method2.gif
(Note: Not all attributes were added to the Property table for lack of
time.)
(This leads to fewer tables, but harder to control referential
integrity.)

My third method was to add a many-to-many relation between Property and
Attributes.
(No diagram for this method.)

With the third method, would I put *only* the options in join table or
*all* of them?  For example, street is not an optional attribute,
however, porch may be.

Can anyone give some suggestions on how best to design this schema?
Eventually, we may add the capability to search and filter items based
on select boxes or check boxes.

Thanks
M!ke

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

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

cfform / cfform.js issues

[Tim Blankenship]

About 2 weeks ago the issue started. Only thing that we know has changed it the 
webserver has been joined to a new domain.

I have 2 cfm pages. 
1. Form
2. Action page

Here is the form
CFQUERY NAME=GETIDETEAM DATASOURCE=#datasource#
  SELECT DISTINCT USERNAME
  FROM SITEUSERS
  WHERE GROUPNAME = 'Desktop Engineering'
/CFQUERY
  cfform action=test_engine_teammember.cfm?CSR=#URL.CSR#
cfselect name=TEAMMEMBER 
size=1
query=GETIDETEAM
value=USERNAME
Display=USERNAME
required=YES 
/cfselect
input type=submit name=Submit value=Update class=srbutton
  /cfform

action page is one line
cfdump var=#FORM#

Problem: I and a few others can run this fine but for some they get an empty 
struct.

Other info:
CFMX 6.1 standard on top of IIS 5 /W2K Server

IIS log errors:
Good (me)
2005-05-25 16:52:17 10.160.14.178 ITSDO\TB6859 150.233.68.45 80 POST 
/softfusion/test_engine_teammember.cfm CSR=2976 200 
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+(R1+1.5);+.NET+CLR+1.1.4322)
Bad (not me)
2005-05-25 16:54:13 10.160.14.221 ITSDO\SB3643 150.233.68.45 80 GET 
/softfusion/test_edit_teammember.cfm CSR=2976 200 
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
2005-05-25 16:54:13 10.160.14.221 - 150.233.68.45 80 GET 
/CFIDE/scripts/cfform.js - 304 
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)

Things tried
moved to unsecure directory
added scriptSrc argument to cfform, copied cfform.js to same directory as page, 
made a directory in my project cfide/scripts and copied it there.

We are supposed to have all the same browser setting so that should not be an 
issue. 
Security is controlled by IIS and it is set to Intergrated WIndows 
Authentication. In the error above the script, cfform.js does not have a user 
defined but does have the IP so I would think that might be the problem but am 
not sure.

Any suggestions are appreciated, Tim
[EMAIL PROTECTED]

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

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

open link in new tab in FF?

[Ray Champagne]

I think this has been asked before, but...

Is there a target-type attribute to allow a link to be opened in a new 
tab in FireFox?  This is for an intranet app, so I am not worried about 
usability for IE users.

Thanks,

Ray
-- 
=
Ray Champagne - Senior Application Developer
CrystalVision Web Site Design and Internet Services
603.433.9559
www.crystalvision.org
=

The information contained in this transmission (including any
attached files) is CONFIDENTIAL and is intended only for the
person(s) named above. If you received this transmission in
error, please delete it from your system and notify us
immediately. If you are not an intended recipient, please note
that any use or dissemination of the information contained in this
transmission (including any attached files) and the copying,
printing, or retransmission of that information is strictly
prohibited. You can notify us by return email or by phone at
603.433.9559.

Thank you.


~|
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:207674
Archives: http://www.houseoffusion.com/cf_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: open link in new tab in FF?

[Joe Rinehart]

Nope, sorry.

FF users have the option of stating that _blank target'd links open in
new tabs, though.

-Joe

On 5/25/05, Ray Champagne [EMAIL PROTECTED] wrote:
 I think this has been asked before, but...
 
 Is there a target-type attribute to allow a link to be opened in a new
 tab in FireFox?  This is for an intranet app, so I am not worried about
 usability for IE users.
 
 Thanks,
 
 Ray
 --
 =
 Ray Champagne - Senior Application Developer
 CrystalVision Web Site Design and Internet Services
 603.433.9559
 www.crystalvision.org
 =
 
 The information contained in this transmission (including any
 attached files) is CONFIDENTIAL and is intended only for the
 person(s) named above. If you received this transmission in
 error, please delete it from your system and notify us
 immediately. If you are not an intended recipient, please note
 that any use or dissemination of the information contained in this
 transmission (including any attached files) and the copying,
 printing, or retransmission of that information is strictly
 prohibited. You can notify us by return email or by phone at
 603.433.9559.
 
 Thank you.
 
 
 

~|
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:207675
Archives: http://www.houseoffusion.com/cf_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: Database Schema Options

[Kerry]

Personally, I would go for a generic attributes table, Ive seen it done in
some massive enterprise databases, and it does provide flexibility for when:
you realise you need another 10 attribute types, oops, now some properties
dont have some attributes but they have another 10 different attributes,
doh, now the marketing department wants to use it and they need 10 more
attributes...

For example, street is not an optional attribute

This might be out of the scope of what you're doing, but I remember from my
uni days that some properties spanned more than one street. Perhaps some
properties need more than one street attribute... theres that flexibility
coming in handy again...


-Original Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED]
Sent: 25 May 2005 17:57
To: CF-Talk
Subject: OT: Database Schema Options


I am toying with a few different methods of creating a database schema
that will hold information about some rental properties the university
owns.

My first method was to create a schema that consisted of many tables,
one for each attribute, and then relate them to the properties table
with FKs.

This is my diagram:
http://acelinkdev.evansville.edu/Temp/Method1.gif
(This leads to many tables, but easy to control referential integrity.)

My second method was to create a single 'attributes' table that
contained, basically, all the other tables that stored attributes about
a house.

This is my diagram:
http://acelinkdev.evansville.edu/Temp/Method2.gif
(Note: Not all attributes were added to the Property table for lack of
time.)
(This leads to fewer tables, but harder to control referential
integrity.)

My third method was to add a many-to-many relation between Property and
Attributes.
(No diagram for this method.)

With the third method, would I put *only* the options in join table or
*all* of them?  For example, street is not an optional attribute,
however, porch may be.

Can anyone give some suggestions on how best to design this schema?
Eventually, we may add the capability to search and filter items based
on select boxes or check boxes.

Thanks
M!ke



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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207676
Archives: http://www.houseoffusion.com/cf_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: Running MS Access macro in Coldfusion

[Hugo Ahlenius]

You can set up the MS Access database so that it understands parameters
(some VBA coding), and then you can start the macro by cfexecuting the
database (you need Access installed on the server for this).

But why would you want to do this... ?

--
Hugo Ahlenius

-
Hugo Ahlenius  E-Mail: [EMAIL PROTECTED]
Project OfficerPhone:+46 8 230460
UNEP GRID-Arendal  Fax:  +46 8 230441
Stockholm Office   Mobile: +46 733 467111
   WWW:   http://www.grida.no
- 

  

|-Original Message-
|From: Claude Schneegans [mailto:[EMAIL PROTECTED]
|Sent: Wednesday, May 25, 2005 16:21
|To: CF-Talk
|Subject: Re: Running MS Access macro in Coldfusion
|
| Is there any setting I need to change so that I can run the
|macro in CF?
|
|TMK, no way! Access is Access, CF is CF. You can query Access Queries 
|from CF, which are like views, but macros are VBasic programs that 
|would need Access to be installed on the server, which is rarely the 
|case.
|
|--
|___
|REUSE CODE! Use custom tags;
|See http://www.contentbox.com/claude/customtags/tagstore.cfm
|(Please send any spam to this address: 
|[EMAIL PROTECTED]) Thanks.
|
|
|

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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207677
Archives: http://www.houseoffusion.com/cf_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: open link in new tab in FF?

[Ray Champagne]

Oh, okay that'll work!  I will do that at the workstations, then 
everything should be fine.

Thanks,

Ray

Joe Rinehart wrote:
 Nope, sorry.
 
 FF users have the option of stating that _blank target'd links open in
 new tabs, though.
 
 -Joe
 
 On 5/25/05, Ray Champagne [EMAIL PROTECTED] wrote:
 
I think this has been asked before, but...

Is there a target-type attribute to allow a link to be opened in a new
tab in FireFox?  This is for an intranet app, so I am not worried about
usability for IE users.

Thanks,

Ray
--
=
Ray Champagne - Senior Application Developer
CrystalVision Web Site Design and Internet Services
603.433.9559
www.crystalvision.org
=

The information contained in this transmission (including any
attached files) is CONFIDENTIAL and is intended only for the
person(s) named above. If you received this transmission in
error, please delete it from your system and notify us
immediately. If you are not an intended recipient, please note
that any use or dissemination of the information contained in this
transmission (including any attached files) and the copying,
printing, or retransmission of that information is strictly
prohibited. You can notify us by return email or by phone at
603.433.9559.

Thank you.



 
 
 

~|
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:207678
Archives: http://www.houseoffusion.com/cf_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: Database Schema Options

[Tony Weeg]

i cannot give any REAL reason why i would do it with diagram 1, other
than thats basically how i like to make systems...

fully normalized... 

:) tw-to-the-third-normal-form

On 5/25/05, Dawson, Michael [EMAIL PROTECTED] wrote:
 I am toying with a few different methods of creating a database schema
 that will hold information about some rental properties the university
 owns.
 
 My first method was to create a schema that consisted of many tables,
 one for each attribute, and then relate them to the properties table
 with FKs.
 
 This is my diagram:
 http://acelinkdev.evansville.edu/Temp/Method1.gif
 (This leads to many tables, but easy to control referential integrity.)
 
 My second method was to create a single 'attributes' table that
 contained, basically, all the other tables that stored attributes about
 a house.
 
 This is my diagram:
 http://acelinkdev.evansville.edu/Temp/Method2.gif
 (Note: Not all attributes were added to the Property table for lack of
 time.)
 (This leads to fewer tables, but harder to control referential
 integrity.)
 
 My third method was to add a many-to-many relation between Property and
 Attributes.
 (No diagram for this method.)
 
 With the third method, would I put *only* the options in join table or
 *all* of them?  For example, street is not an optional attribute,
 however, porch may be.
 
 Can anyone give some suggestions on how best to design this schema?
 Eventually, we may add the capability to search and filter items based
 on select boxes or check boxes.
 
 Thanks
 M!ke
 
 

~|
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:207679
Archives: http://www.houseoffusion.com/cf_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: open link in new tab in FF?

[Joe Rinehart]

Cool deal...isn't intranet work great?  :)



On 5/25/05, Ray Champagne [EMAIL PROTECTED] wrote:
 Oh, okay that'll work!  I will do that at the workstations, then
 everything should be fine.
 
 Thanks,
 
 Ray
 
 Joe Rinehart wrote:
  Nope, sorry.
 
  FF users have the option of stating that _blank target'd links open in
  new tabs, though.
 
  -Joe
 
  On 5/25/05, Ray Champagne [EMAIL PROTECTED] wrote:
 
 I think this has been asked before, but...
 
 Is there a target-type attribute to allow a link to be opened in a new
 tab in FireFox?  This is for an intranet app, so I am not worried about
 usability for IE users.
 
 Thanks,
 
 Ray
 --
 =
 Ray Champagne - Senior Application Developer
 CrystalVision Web Site Design and Internet Services
 603.433.9559
 www.crystalvision.org
 =
 
 The information contained in this transmission (including any
 attached files) is CONFIDENTIAL and is intended only for the
 person(s) named above. If you received this transmission in
 error, please delete it from your system and notify us
 immediately. If you are not an intended recipient, please note
 that any use or dissemination of the information contained in this
 transmission (including any attached files) and the copying,
 printing, or retransmission of that information is strictly
 prohibited. You can notify us by return email or by phone at
 603.433.9559.
 
 Thank you.
 
 
 
 
 
 
 
 

~|
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:207680
Archives: http://www.houseoffusion.com/cf_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: open link in new tab in FF?

[Ray Champagne]

LOL...I wish I could do them exclusively.  I hate trying to account for 
every setting/setup/configuration/browser under the sun.  And I *really* 
hate having to dumb down applications for the village idiot. 
Intranets rock!

Joe Rinehart wrote:
 Cool deal...isn't intranet work great?  :)
 
 
 
 On 5/25/05, Ray Champagne [EMAIL PROTECTED] wrote:
 
Oh, okay that'll work!  I will do that at the workstations, then
everything should be fine.

Thanks,

Ray

Joe Rinehart wrote:

Nope, sorry.

FF users have the option of stating that _blank target'd links open in
new tabs, though.

-Joe

On 5/25/05, Ray Champagne [EMAIL PROTECTED] wrote:


I think this has been asked before, but...

Is there a target-type attribute to allow a link to be opened in a new
tab in FireFox?  This is for an intranet app, so I am not worried about
usability for IE users.

Thanks,

Ray
--
=
Ray Champagne - Senior Application Developer
CrystalVision Web Site Design and Internet Services
603.433.9559
www.crystalvision.org
=

The information contained in this transmission (including any
attached files) is CONFIDENTIAL and is intended only for the
person(s) named above. If you received this transmission in
error, please delete it from your system and notify us
immediately. If you are not an intended recipient, please note
that any use or dissemination of the information contained in this
transmission (including any attached files) and the copying,
printing, or retransmission of that information is strictly
prohibited. You can notify us by return email or by phone at
603.433.9559.

Thank you.







 
 

~|
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:207681
Archives: http://www.houseoffusion.com/cf_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

cfexecute problem...

[Joe Joe]

Hello..

I cant see what im doing wrong with this code, so any help would be much 
apreciated.

I have an upload page, that allows people to upload an image. I then try to 
convert the image using an exe file to another format.. I have to use the exe 
because of the formats im changing to.

if i run this from the command line the converter works.

C:\converter.exe -i Niamh1.jpg trynum2.gif

however when i use this cfml code, using serverFile as the name of the uploaded 
file, it wont work...

cfexecute
  name = C:\converter.exe
  arguments = -i cfoutput#serverFile#/cfoutput trynum2.gif
/cfexecute

Is it something to do with permissions or whatnot? or if anyone can see what im 
doing wrong??

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

OT : sql server roles help

[DRE]

Hi,
I'm not that familiar with sql server but I've got a database that I
can connect to.  However, cf cant see a table.  I know this has to do
with roles and permissions and stuff like that but I just cant seem to
get it right.  Anybody got any tips?  Thanks.

-- 
DRE
www.webmachineinc.com
www.theanticool.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:207683
Archives: http://www.houseoffusion.com/cf_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 : sql server roles help

[DRE]

actually, if in the query. I give the table owners name before the
table. I can see it.  So somehow the login doesnt know enough to look
at the tables owner.  Hmm.  Anybody?

On 5/25/05, DRE [EMAIL PROTECTED] wrote:
 Hi,
 I'm not that familiar with sql server but I've got a database that I
 can connect to.  However, cf cant see a table.  I know this has to do
 with roles and permissions and stuff like that but I just cant seem to
 get it right.  Anybody got any tips?  Thanks.
 
 --
 DRE
 www.webmachineinc.com
 www.theanticool.com
 


-- 
DRE
www.webmachineinc.com
www.theanticool.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:207684
Archives: http://www.houseoffusion.com/cf_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: cfexecute problem...

[Ian Skinner]

My first suspect would be actual file paths.  Where is the exe, where is 
serverfile?  I bet they are not in places where they can talk to each other 
without more complete information.  You may need to convert serverfile to 
something more like C:\the\directory\cf\uploaded\to\serverfile.  Or make sure 
the directory is the same as the exe file so it can find it.

Just a first guess.

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

-Original Message-
From: Joe Joe [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 25, 2005 11:05 AM
To: CF-Talk
Subject: cfexecute problem...

Hello..

I cant see what im doing wrong with this code, so any help would be much
apreciated.

I have an upload page, that allows people to upload an image. I then try
to convert the image using an exe file to another format.. I have to use
the exe because of the formats im changing to.

if i run this from the command line the converter works.

C:\converter.exe -i Niamh1.jpg trynum2.gif

however when i use this cfml code, using serverFile as the name of the
uploaded file, it wont work...

cfexecute
  name = C:\converter.exe
  arguments = -i cfoutput#serverFile#/cfoutput trynum2.gif
/cfexecute

Is it something to do with permissions or whatnot? or if anyone can see
what im doing wrong??



~|
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:207685
Archives: http://www.houseoffusion.com/cf_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: cfexecute problem...

[Joseph Brien]

I have been trying different directories, I have them on C:\ - but i also 
have them in C:\mydocuments\uploads.. which is the
http://localhost/upload/folder, Im going to try direct refrencing all
the files now...

cfexecute 
name = C:\My Documents\uploads\converter.exe
arguments = -i 'C:\My Documents\uploads\Niamh1.jpg' 'C:\My 
Documents\uploads\trydsdsd.gif'
/cfexecute

i tried the the command line equivalent and it worked however the above code 
doesnt. Do i have to give folders permission to run exe files? because it 
doesnt seem to be doing anything at all...

On 5/25/05, Ian Skinner [EMAIL PROTECTED] wrote:
 
 My first suspect would be actual file paths. Where is the exe, where is 
 serverfile? I bet they are not in places where they can talk to each other 
 without more complete information. You may need to convert serverfile to 
 something more like C:\the\directory\cf\uploaded\to\serverfile. Or make sure 
 the directory is the same as the exe file so it can find it.
 
 Just a first guess.
 
 --
 Ian Skinner
 Web Programmer
 BloodSource
 www.BloodSource.org http://www.BloodSource.org
 Sacramento, CA
 
 C code. C code run. Run code run. Please!
 - Cynthia Dunning
 


-- 
Sincerely
Akira Tsukasa -san


~|
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:207686
Archives: http://www.houseoffusion.com/cf_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: cfexecute problem...

[Joe Rinehart]

Joe,

You've  got a tag nested inside your cfexecute tag.  While this is valid:

CftagCfchildtag/cftag

This isn't:

cftag cfchildtag

This should help:

cfexecute
  name = C:\converter.exe
  arguments = -i #serverFile# trynum2.gif
/cfexecute

-joe
On 5/25/05, Joe Joe [EMAIL PROTECTED] wrote:
 Hello..
 
 I cant see what im doing wrong with this code, so any help would be much 
 apreciated.
 
 I have an upload page, that allows people to upload an image. I then try to 
 convert the image using an exe file to another format.. I have to use the exe 
 because of the formats im changing to.
 
 if i run this from the command line the converter works.
 
 C:\converter.exe -i Niamh1.jpg trynum2.gif
 
 however when i use this cfml code, using serverFile as the name of the 
 uploaded file, it wont work...
 
 cfexecute
   name = C:\converter.exe
   arguments = -i cfoutput#serverFile#/cfoutput trynum2.gif
 /cfexecute
 
 Is it something to do with permissions or whatnot? or if anyone can see what 
 im doing wrong??
 
 

~|
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:207687
Archives: http://www.houseoffusion.com/cf_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 server roles help

[Dave Watts]

 I'm not that familiar with sql server but I've got a database that I
 can connect to.  However, cf cant see a table.  I know this has to do
 with roles and permissions and stuff like that but I just cant seem to
 get it right.  Anybody got any tips?  Thanks.

Have you tried referencing the table using dbo role directly?
(dbo.tablename)

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

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


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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207688
Archives: http://www.houseoffusion.com/cf_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 : sql server roles help

[Dave Watts]

 actually, if in the query. I give the table owners name before the
 table. I can see it.  So somehow the login doesnt know enough to look
 at the tables owner.  Hmm.  Anybody?

If the login is different from the actual table owner, you will have to
specify the table owner within the table name reference.

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

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


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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207689
Archives: http://www.houseoffusion.com/cf_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: open link in new tab in FF?

[Scott Stroz]

I have worked on projects where I had to 'dumb-down' Intranet applications 
more than public facing applications.

Intranet user = more smarter isn't necessarily true. 

On 5/25/05, Ray Champagne [EMAIL PROTECTED] wrote:
 
 LOL...I wish I could do them exclusively. I hate trying to account for
 every setting/setup/configuration/browser under the sun. And I *really*
 hate having to dumb down applications for the village idiot.
 Intranets rock!
 
 Joe Rinehart wrote:
  Cool deal...isn't intranet work great? :)
 
 
 
  On 5/25/05, Ray Champagne [EMAIL PROTECTED] wrote:
 
 Oh, okay that'll work! I will do that at the workstations, then
 everything should be fine.
 
 Thanks,
 
 Ray
 
 Joe Rinehart wrote:
 
 Nope, sorry.
 
 FF users have the option of stating that _blank target'd links open in
 new tabs, though.
 
 -Joe
 
 On 5/25/05, Ray Champagne [EMAIL PROTECTED] wrote:
 
 
 I think this has been asked before, but...
 
 Is there a target-type attribute to allow a link to be opened in a 
 new
 tab in FireFox? This is for an intranet app, so I am not worried about
 usability for IE users.
 
 Thanks,
 
 Ray
 --
 =
 Ray Champagne - Senior Application Developer
 CrystalVision Web Site Design and Internet Services
 603.433.9559
 www.crystalvision.org http://www.crystalvision.org
 =
 
 The information contained in this transmission (including any
 attached files) is CONFIDENTIAL and is intended only for the
 person(s) named above. If you received this transmission in
 error, please delete it from your system and notify us
 immediately. If you are not an intended recipient, please note
 that any use or dissemination of the information contained in this
 transmission (including any attached files) and the copying,
 printing, or retransmission of that information is strictly
 prohibited. You can notify us by return email or by phone at
 603.433.9559.
 
 Thank you.
 
 
 
 
 
 
 
 
 
 
 

~|
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:207690
Archives: http://www.houseoffusion.com/cf_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

CFCs within a web service

[Peters, Chris]

I have a CFC web service that tries to access another CFC for its
business logic.  The problem is that I get this error message if I try
to access the web services directly from my browser
(http://localhost:8500/pr/PRService.cfc?wsdl):

AXIS error
Sorry, something seems to have gone wrong... here are the details:

Fault -
[coldfusion.xml.rpc.SkeletonClassLoader$UnresolvedCFCDataTypeException :
Could not resolve CFC datatype: business.pr.Gateway][; nested exception
is: 
coldfusion.xml.rpc.CFCInvocationException:
[coldfusion.xml.rpc.SkeletonClassLoader$UnresolvedCFCDataTypeException :
Could not resolve CFC datatype: business.pr.Gateway][
AxisFault
 faultCode:
{http://schemas.xmlsoap.org/soap/envelope/}Server.generalException
 faultSubcode: 
 faultString:
[coldfusion.xml.rpc.SkeletonClassLoader$UnresolvedCFCDataTypeException :
Could not resolve CFC datatype: business.pr.Gateway][; nested exception
is: 
coldfusion.xml.rpc.CFCInvocationException:
[coldfusion.xml.rpc.SkeletonClassLoader$UnresolvedCFCDataTypeException :
Could not resolve CFC datatype: business.pr.Gateway][
 faultActor: 
 faultNode: 
 faultDetail: 


I have the following web service call which also generates an error:

cfset prService = CreateObject('webservice',
'http://127.0.0.1:8500/pr/PRService.cfc?wsdl')
cfset stories = prService.getStories()

cfloop index=i from=1 to=#ListLen(stories)#
  cfset storyID = ListGetAt(stories, i, ,)
  cfoutput
cfset headline = prService.getHeadline(#storyID#)
cfset dateReleased = prService.getDateReleased(#storyID#)
cfset body = prService.getBody(#storyID#)
   #DateFormat(dateReleased, mm/dd/)# - 
a href=#headline#/abr /
#ListGetAt(body, 1, '.')#br /br /
  /cfoutput
/cfloop

Here is the code for the web service:

cfcomponent

!-

cfset variables.dsn = ''
cfset variables.prComponent = CreateObject('component',
'business.pr.Gateway').init('PublicRelations')

!-  

cffunction name=init access=remote returntype=prComponent
output=true
cfargument name=datasource type=string required=yes

  cfset variables.dsn = arguments.datasource
  cfreturn this

/cffunction

!-  

cffunction name=getStories returntype=string access=remote
output=true

  !--- Array of stories ---
  cfset var stories = ArrayNew(1)
  cfset stories = variables.prComponent.getAllStories()
  cfset storiesList = 

  cfloop index=i from=1 to=#ArrayLen(stories)#
cfset storiesList = ListAppend(storiesList, stories[i].getID(),
,)
  /cfloop

  cfreturn storiesList

/cffunction

/cfcomponent

I am CERTAIN that I have the correct mapping set up for /business (which
is being referenced in the CreateObject() function call).

Can you not have other CFC calls in your Web services?  Is this a bug?

My Configuration: ColdFusion MX 6.1 J2EE server instance on Windows XP.

 
Chris Peters
New Media Production Specialist
614-508-7241
[EMAIL PROTECTED]


-Original Message-
From: CF-Talk [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, May 25, 2005 3:01 PM
To: CF-Talk
Subject: CF-Talk: Digest every hour

CF-Talk  25-May-05 Issue:17412
In this issue:
 cfform / cfform.js issues
 Database Schema Options
 open link in new tab in FF?
 open link in new tab in FF?
 open link in new tab in FF?
 open link in new tab in FF?
 open link in new tab in FF?
 OT: Database Schema Options
 Running MS Access macro in Coldfusion



~|
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:207691
Archives: http://www.houseoffusion.com/cf_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: Inserting data by email

[Bram Plessers]

Thanks Phillip and Humphrey !  I'll take your tips into account.



On 5/22/05, C. Hatton Humphrey [EMAIL PROTECTED] wrote:
  I was wondering how you could insert/update data
  in a mysql db using email ? How can you let the
  server read out new mail ( once per 5 minutes ) or so,
  so that the new data is inserted imediately ?
 
  PS: functionality like in Flickr: send an image in an email by
  mobile phone - the image is uploaded into your personal space.
 
 Use a scheduled task to run a page that checks the POP account and
 then processes the emails as needed.
 
 There is the CFPOP tag built in but there are also external tags -
 CFX_POP3 has been mentioned, I don't know if there are others.
 
 Hatton
 
 

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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207692
Archives: http://www.houseoffusion.com/cf_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: CFCs within a web service

[Kevin Aebig]

Well I've done quite a few calls from one CFC to another. Based on the
error, the custom datatype you're attempting to use is what's choking. If
you're sure that the path is correct, maybe you should check to make sure
that there isn't an error within the datatype file itself.

Cheers,

Kevin

-Original Message-
From: Peters, Chris [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 25, 2005 1:46 PM
To: CF-Talk
Subject: CFCs within a web service


I have a CFC web service that tries to access another CFC for its
business logic.  The problem is that I get this error message if I try
to access the web services directly from my browser
(http://localhost:8500/pr/PRService.cfc?wsdl):

AXIS error
Sorry, something seems to have gone wrong... here are the details:

Fault -
[coldfusion.xml.rpc.SkeletonClassLoader$UnresolvedCFCDataTypeException :
Could not resolve CFC datatype: business.pr.Gateway][; nested exception
is:
coldfusion.xml.rpc.CFCInvocationException:
[coldfusion.xml.rpc.SkeletonClassLoader$UnresolvedCFCDataTypeException :
Could not resolve CFC datatype: business.pr.Gateway][
AxisFault
 faultCode:
{http://schemas.xmlsoap.org/soap/envelope/}Server.generalException
 faultSubcode:
 faultString:
[coldfusion.xml.rpc.SkeletonClassLoader$UnresolvedCFCDataTypeException :
Could not resolve CFC datatype: business.pr.Gateway][; nested exception
is:
coldfusion.xml.rpc.CFCInvocationException:
[coldfusion.xml.rpc.SkeletonClassLoader$UnresolvedCFCDataTypeException :
Could not resolve CFC datatype: business.pr.Gateway][
 faultActor:
 faultNode:
 faultDetail:


I have the following web service call which also generates an error:

cfset prService = CreateObject('webservice',
'http://127.0.0.1:8500/pr/PRService.cfc?wsdl')
cfset stories = prService.getStories()

cfloop index=i from=1 to=#ListLen(stories)#
  cfset storyID = ListGetAt(stories, i, ,)
  cfoutput
cfset headline = prService.getHeadline(#storyID#)
cfset dateReleased = prService.getDateReleased(#storyID#)
cfset body = prService.getBody(#storyID#)
   #DateFormat(dateReleased, mm/dd/)# -
a href=#headline#/abr /
#ListGetAt(body, 1, '.')#br /br /
  /cfoutput
/cfloop

Here is the code for the web service:

cfcomponent

!-

cfset variables.dsn = ''
cfset variables.prComponent = CreateObject('component',
'business.pr.Gateway').init('PublicRelations')

!-

cffunction name=init access=remote returntype=prComponent
output=true
cfargument name=datasource type=string required=yes

  cfset variables.dsn = arguments.datasource
  cfreturn this

/cffunction

!-

cffunction name=getStories returntype=string access=remote
output=true

  !--- Array of stories ---
  cfset var stories = ArrayNew(1)
  cfset stories = variables.prComponent.getAllStories()
  cfset storiesList = 

  cfloop index=i from=1 to=#ArrayLen(stories)#
cfset storiesList = ListAppend(storiesList, stories[i].getID(),
,)
  /cfloop

  cfreturn storiesList

/cffunction

/cfcomponent

I am CERTAIN that I have the correct mapping set up for /business (which
is being referenced in the CreateObject() function call).

Can you not have other CFC calls in your Web services?  Is this a bug?

My Configuration: ColdFusion MX 6.1 J2EE server instance on Windows XP.


Chris Peters
New Media Production Specialist
614-508-7241
[EMAIL PROTECTED]


-Original Message-
From: CF-Talk [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 25, 2005 3:01 PM
To: CF-Talk
Subject: CF-Talk: Digest every hour

CF-Talk  25-May-05 Issue:17412
In this issue:
 cfform / cfform.js issues
 Database Schema Options
 open link in new tab in FF?
 open link in new tab in FF?
 open link in new tab in FF?
 open link in new tab in FF?
 open link in new tab in FF?
 OT: Database Schema Options
 Running MS Access macro in Coldfusion





~|
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:207693
Archives: http://www.houseoffusion.com/cf_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 : sql server roles help

[DRE]

Hmm, so how do I create a login thats the same as the table owner?

I tried the login wizard and used the same name as the table owner and
now have two users with the same name. Both seem to be the table
owners but neither seems to be a login!

I'm sure I'm close!  Thanks for any help in advance.

DRE


On 5/25/05, Dave Watts [EMAIL PROTECTED] wrote:
  actually, if in the query. I give the table owners name before the
  table. I can see it.  So somehow the login doesnt know enough to look
  at the tables owner.  Hmm.  Anybody?
 
 If the login is different from the actual table owner, you will have to
 specify the table owner within the table name reference.
 
 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 
 Fig Leaf Software provides the highest caliber vendor-authorized
 instruction at our training centers in Washington DC, Atlanta,
 Chicago, Baltimore, Northern Virginia, or on-site at your location.
 Visit http://training.figleaf.com/ for more information!
 
 
 

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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207694
Archives: http://www.houseoffusion.com/cf_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: CFCs within a web service

[Mike Nicholls]

Any calls within the CFC to other webservices should be irrelevant if it
can't serve up the WSDL, from my (limited) understanding the WSDL really
just lists details of the available remote methods.  Try putting a very
simple webservice that just returns a hardcoded string or something in the
same directory as your existing one and see if you get the same error. 

If you do, I think you're experiencing the same bug as in
http://www.houseoffusion.com/cf_lists/messages.cfm/forumid:4/threadid:39728.
It's been around since CFMX6.1 Updater 1, but Macromedia haven't fixed it
yet.  There are a couple of workarounds mentioned at
http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=7th
readid=881689forumid=1, but they can be a pain to implement.

-Original Message-
From: Kevin Aebig [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 26 May 2005 8:20 a.m.
To: CF-Talk
Subject: RE: CFCs within a web service

Well I've done quite a few calls from one CFC to another. Based on the
error, the custom datatype you're attempting to use is what's choking. If
you're sure that the path is correct, maybe you should check to make sure
that there isn't an error within the datatype file itself.

Cheers,

Kevin

-Original Message-
From: Peters, Chris [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 25, 2005 1:46 PM
To: CF-Talk
Subject: CFCs within a web service


I have a CFC web service that tries to access another CFC for its
business logic.  The problem is that I get this error message if I try
to access the web services directly from my browser
(http://localhost:8500/pr/PRService.cfc?wsdl):

AXIS error
Sorry, something seems to have gone wrong... here are the details:

Fault -
[coldfusion.xml.rpc.SkeletonClassLoader$UnresolvedCFCDataTypeException :
Could not resolve CFC datatype: business.pr.Gateway][; nested exception
is:
coldfusion.xml.rpc.CFCInvocationException:
[coldfusion.xml.rpc.SkeletonClassLoader$UnresolvedCFCDataTypeException :
Could not resolve CFC datatype: business.pr.Gateway][
AxisFault
 faultCode:
{http://schemas.xmlsoap.org/soap/envelope/}Server.generalException
 faultSubcode:
 faultString:
[coldfusion.xml.rpc.SkeletonClassLoader$UnresolvedCFCDataTypeException :
Could not resolve CFC datatype: business.pr.Gateway][; nested exception
is:
coldfusion.xml.rpc.CFCInvocationException:
[coldfusion.xml.rpc.SkeletonClassLoader$UnresolvedCFCDataTypeException :
Could not resolve CFC datatype: business.pr.Gateway][
 faultActor:
 faultNode:
 faultDetail:


I have the following web service call which also generates an error:

cfset prService = CreateObject('webservice',
'http://127.0.0.1:8500/pr/PRService.cfc?wsdl')
cfset stories = prService.getStories()

cfloop index=i from=1 to=#ListLen(stories)#
  cfset storyID = ListGetAt(stories, i, ,)
  cfoutput
cfset headline = prService.getHeadline(#storyID#)
cfset dateReleased = prService.getDateReleased(#storyID#)
cfset body = prService.getBody(#storyID#)
   #DateFormat(dateReleased, mm/dd/)# -
a href=#headline#/abr /
#ListGetAt(body, 1, '.')#br /br /
  /cfoutput
/cfloop

Here is the code for the web service:

cfcomponent

!-

cfset variables.dsn = ''
cfset variables.prComponent = CreateObject('component',
'business.pr.Gateway').init('PublicRelations')

!-

cffunction name=init access=remote returntype=prComponent
output=true
cfargument name=datasource type=string required=yes

  cfset variables.dsn = arguments.datasource
  cfreturn this

/cffunction

!-

cffunction name=getStories returntype=string access=remote
output=true

  !--- Array of stories ---
  cfset var stories = ArrayNew(1)
  cfset stories = variables.prComponent.getAllStories()
  cfset storiesList = 

  cfloop index=i from=1 to=#ArrayLen(stories)#
cfset storiesList = ListAppend(storiesList, stories[i].getID(),
,)
  /cfloop

  cfreturn storiesList

/cffunction

/cfcomponent

I am CERTAIN that I have the correct mapping set up for /business (which
is being referenced in the CreateObject() function call).

Can you not have other CFC calls in your Web services?  Is this a bug?

My Configuration: ColdFusion MX 6.1 J2EE server instance on Windows XP.


Chris Peters
New Media Production Specialist
614-508-7241
[EMAIL PROTECTED]


-Original Message-
From: CF-Talk [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 25, 2005 3:01 PM
To: CF-Talk
Subject: CF-Talk: Digest every hour

CF-Talk  25-May-05 Issue:17412
In this issue:
 cfform / cfform.js issues
 Database Schema Options
 open link in new tab in FF?
 open link in new tab in FF?
 open link in new tab in FF?
 open link in new tab in FF?
 open link in new tab in FF?
 OT: Database Schema Options
 Running MS Access macro in Coldfusion

Query question

[Eric J. Hoffman]

I am doing probably the simplest query, but am on little sleep, can
someone tell me where I am goofing?

Select  
COUNT (customer_orders.id) as totqty,
SUM (customer_orders.subtotal) as subtot,
SUM (customer_orders.shipcost) as cstship,
SUM (customer_orders.shipquote) as qteship,
AVG (customer_orders.subtotal) as avgsub,
AVG (customer_orders.shipcost) as avgship
FROM customer_orders
WHERE customer_orders.orderdate BETWEEN #start1a# AND
#DateAdd('D', 1, end1a)#
AND subtotal  50

Just want all orders for a date period to give me sums and averages that
was under 50 dollars.  But it seems to be getting from all time.  What
did I miss?

Thanks!

Eric

~|
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:207696
Archives: http://www.houseoffusion.com/cf_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

cfexecute and wget

[Tim Oommen]

I running into a problem with cfexecute I am using it to run the following code

cfexecute
arguments=http://webtest.lawbulletin.com/testasp/callconversion.asp?conversion_id=31;
 name=d:\wwwmx\wget\wget.exe
  timeout=0
/cfexecute

It seems to work fine and returns back to the page immediately because of the 
timeout=0 parameter. All this is fine and good, but after some examination I 
found wget process sitting in the task manager doing nothing. They processed  
the script they are calling, but just seem to sit there. Has anyone else run  
into this problem and if so if there fix to it. Because currently the only way 
to kill the idle wget process is to restart the cf server.

thanks in advance

Tim  

~|
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:207697
Archives: http://www.houseoffusion.com/cf_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 : sql server roles help

[Dave Watts]

 Hmm, so how do I create a login thats the same as the table owner?
 
 I tried the login wizard and used the same name as the table owner and
 now have two users with the same name. Both seem to be the table
 owners but neither seems to be a login!
 
 I'm sure I'm close!  Thanks for any help in advance.

Logins are server-wide. Once you have a login, you can assign it to a user
or role within a specific database. I've never used the create login wizard,
so I can't help you there, but once you have a login you can go to the
specific database within Enterprise Manager, go to Users, and assign the
user to the login.

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:207698
Archives: http://www.houseoffusion.com/cf_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: CFFORM + FLASH

[dave]

right, and it's not a good idea to have it that way, that's like i see these 
people use a set un  pw in flash and all you have to do is download the swf 
and decompile it and there it is.

 While it might be hard for someone to figure out, I wouldn't concider it 
proper coding practice, on somethings its ok but not on a login feature.
 Not that I am one to preach about proper coding practices.

~Dave the disruptor~ 


From: Joe Rinehart [EMAIL PROTECTED]
Sent: Wednesday, May 25, 2005 11:07 AM
To: CF-Talk cf-talk@houseoffusion.com
Subject: Re: CFFORM + FLASH 

Stuart,

You're passing the user's correct password to the clientside - someone
will figure out how to sniff it, it's not hard to open up Flash...

-Joe

On 5/25/05, Stuart Kidd  wrote:
 Hi Dave,
 
 Thanks for that, that's perfect.
 
 Can I ask why it may come back and bite me in the ass so that maybe I can
 fix it?
 
 Cheers,
 
 Saturday
 
 
 On 25/5/05 01:45, dave  wrote:
 
  for one you are trying to be sneaky with the password variable which of 
  course
  can/will/shall come back to bite you in the ass.
 
  but, since this is what you are doing why not add some .as script to the
  filed just like you did with pw filed?
  onsubmit=if( numberOfReplies.text != '---' )
  alert('please select an email option'); return false;²
 
  ~Dave the disruptor~
 
  
  From: Stuart Kidd 
  Sent: Tuesday, May 24, 2005 4:57 PM
  To: CF-Talk 
  Subject: CFFORM + FLASH
 
  Hi guys,
 
  I¹m using the CFFORM tag and wanted to add some extra validation.
 
  My tag is like so:
 
  action = /?kissMyDate=yes
  format = Flash
  skin = haloBlue
  width = 400 height=420
  name=Part1
  onsubmit=if( password.text != '#GetUser.password#' ) {
  alert('Password is incorrect'); return false;}²
 
  I added the password validation and that worked no problem, but now I¹d like
  to make sure that a user always makes a selection from a combo box and NOT
  choose the value which is ³² (
  value=---).
 
  value=#GetAdvert.numberOfReplies# selectedCurrently:
  #GetAdvert.numberOfReplies#
  ---
  5
  10
  25
  Unlimited
  No more, I've had enough!
 
  As it stands if the user chooses
  value=--- the form doesn¹t have an error pop up.
 
  I thought of either doing some javascript in the cfselect or possibly adding
  something to the tag similar to the onsubmit.
 
  action = /?kissMyDate=yes
  format = Flash
  skin = haloBlue
  width = 400 height=420
  name=Part1
  onsubmit=if( password.text != '#GetUser.password#' ) {
  alert('Password is incorrect'); return false;}
  onsubmit=if( numberOfReplies.text != '' ) { alert('Please choose
  max emails to receive'); return false;}²
 
  Unfortunately the above comes up with an error.
 
  If anyone could help it would be greatly appreciated.
 
  Thanks,
 
  Saturday
 
 
 
 
 
 



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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207699
Archives: http://www.houseoffusion.com/cf_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: js popup resizing ?

[dave]

been a long few days.
 Wasn't even set to stun more like trickle. 

 So are you saying you miss the disruptor?

~Dave the disruptor~ 


From: Bryan Stevenson [EMAIL PROTECTED]
Sent: Wednesday, May 25, 2005 12:07 PM
To: CF-Talk cf-talk@houseoffusion.com
Subject: Re: js popup resizing ? 

I forgot to mention there is a seperate page with more js in it that does 
the resizing
 oopsy on me, sorry bout that

 ~Dave the disruptor~

Uh huhthat might help Dave ;-)

I do beleive the disruptor is only set on stun today ;-)

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



~|
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:207700
Archives: http://www.houseoffusion.com/cf_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: CFFORM + FLASH

[dave]

Just think of it this way, there will always be ppl out there who are smarter 
then us and can figure about anything out.

 My point was that you can do what you were doing with most anything you want, 
I just wouldn't do it with passwords, even if they are hashed or you just don't 
care cause you just smoked to much hash.

~Dave the disruptor~ 


From: Stuart Kidd [EMAIL PROTECTED]
Sent: Wednesday, May 25, 2005 12:07 PM
To: CF-Talk cf-talk@houseoffusion.com
Subject: Re: CFFORM + FLASH 

Didn't think of that! Okay, I will take that out and just check password on
the server side only.

On a different topic (sort of), is that the case for client variables also,
can users work a way of getting those?

Thanks,

Stuart

On 25/5/05 16:06, Joe Rinehart  wrote:

 Stuart,
 
 You're passing the user's correct password to the clientside - someone
 will figure out how to sniff it, it's not hard to open up Flash...
 
 -Joe
 
 On 5/25/05, Stuart Kidd  wrote:
 Hi Dave,
 
 Thanks for that, that's perfect.
 
 Can I ask why it may come back and bite me in the ass so that maybe I can
 fix it?
 
 Cheers,
 
 Saturday
 
 
 On 25/5/05 01:45, dave  wrote:
 
 for one you are trying to be sneaky with the password variable which of
 course
 can/will/shall come back to bite you in the ass.
 
 but, since this is what you are doing why not add some .as script to the
 filed just like you did with pw filed?
 onsubmit=if( numberOfReplies.text != '---' )
 alert('please select an email option'); return false;²
 
 ~Dave the disruptor~
 
 
 From: Stuart Kidd 
 Sent: Tuesday, May 24, 2005 4:57 PM
 To: CF-Talk 
 Subject: CFFORM + FLASH
 
 Hi guys,
 
 I¹m using the CFFORM tag and wanted to add some extra validation.
 
 My tag is like so:
 
 action = /?kissMyDate=yes
 format = Flash
 skin = haloBlue
 width = 400 height=420
 name=Part1
 onsubmit=if( password.text != '#GetUser.password#' ) {
 alert('Password is incorrect'); return false;}²
 
 I added the password validation and that worked no problem, but now I¹d like
 to make sure that a user always makes a selection from a combo box and NOT
 choose the value which is ³² (
 value=---).
 
 value=#GetAdvert.numberOfReplies# selectedCurrently:
 #GetAdvert.numberOfReplies#
 ---
 5
 10
 25
 Unlimited
 No more, I've had enough!
 
 As it stands if the user chooses
 value=--- the form doesn¹t have an error pop up.
 
 I thought of either doing some javascript in the cfselect or possibly adding
 something to the tag similar to the onsubmit.
 
 action = /?kissMyDate=yes
 format = Flash
 skin = haloBlue
 width = 400 height=420
 name=Part1
 onsubmit=if( password.text != '#GetUser.password#' ) {
 alert('Password is incorrect'); return false;}
 onsubmit=if( numberOfReplies.text != '' ) { alert('Please choose
 max emails to receive'); return false;}²
 
 Unfortunately the above comes up with an error.
 
 If anyone could help it would be greatly appreciated.
 
 Thanks,
 
 Saturday
 
 
 
 
 
 
 
 



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

Re: js popup resizing ?

[dave]

hey Brian, have you ever noticed that your web addy is jacked?
  www.electricedgesystems.com.cfm/54 

~Dave the disruptor~ 


From: Bryan Stevenson [EMAIL PROTECTED]
Sent: Wednesday, May 25, 2005 12:07 PM
To: CF-Talk cf-talk@houseoffusion.com
Subject: Re: js popup resizing ? 

I forgot to mention there is a seperate page with more js in it that does 
the resizing
 oopsy on me, sorry bout that

 ~Dave the disruptor~

Uh huhthat might help Dave ;-)

I do beleive the disruptor is only set on stun today ;-)

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



~|
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:207702
Archives: http://www.houseoffusion.com/cf_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: IIS Coding

[Kym Kovan]

Troy Jones wrote:
 I'm looking for Lewis' TCPClient object as well.  If anyone could send it to 
 me it would save me a LOT of work, as it definitely seems to have disappeared 
 form the net...

Done.

Kym K

~|
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:207703
Archives: http://www.houseoffusion.com/cf_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

tightening up my cart code

[Will Tomlinson]

On my shopping cart app, I've gotten through the payment processing part and 
now I'm entering the data into two tables. I'm using Nate's example from WACK. 
Does anyone have any suggestions on improving this code? It works but I want to 
improve it, and I've never used cftransaction before. 
In this example, ListFirst(cfhttp.filecontent)is the value returned from 
authorize.net. 1 - approved, 2- declined, 3- error

Thanks much,
...cf Will

!--- Enter order into tblorders ---

cftransaction action=begin
cfquery datasource=#APPLICATION.DSN# name=insertorder
INSERT INTO tblorders 
(orderID, orderdate, contactFname, contactLname, shipaddress1, shipaddress2,
shipcity, shipstate, shipzip, shipcountry, shipphone, shipemail, billingfname,
billinglname, billingaddress1, billingaddress2, billingcity, billingstate,
billingzip, billingcountry, billingphone, billingemail, shopperID, notes)
VALUES ('#VARIABLES.invoicenumber#', '#VARIABLES.invoicedate#', 
'#shopperinfo.s_fname#', '#shopperinfo.s_lname#',
'#shopperinfo.s_address1#','#shopperinfo.s_address2#', '#shopperinfo.s_city#', 
'#shopperinfo.s_state#',
 '#shopperinfo.s_zip#', '#shopperinfo.s_country#', '#shopperinfo.s_phone#', 
'#shopperinfo.s_email#',
'#shopperinfo.b_fname#', '#shopperinfo.b_lname#', '#shopperinfo.b_address1#', 
'#shopperinfo.b_address2#',
'#shopperinfo.b_city#', '#shopperinfo.b_state#', '#shopperinfo.b_zip#', 
'#shopperinfo.b_country#', 
'#shopperinfo.b_phone#', '#shopperinfo.b_email#', #shopperinfo.custID#, 
'#ATTRIBUTES.comments#')
/cfquery
cfloop collection=#sc# item=i
cfquery datasource=#APPLICATION.DSN# name=insertorderitem
INSERT INTO tblorderitems 
(orderID, prodID, prodqty, prodsellprice)
VALUES ('#VARIABLES.invoicenumber#', '#i#', #sc[i].qty#, #sc[i].price#)
/cfquery
/cfloop
cfif ListFirst(cfhttp.filecontent) EQ 1
cftransaction action=commit /
cfelse
cftransaction action=rollback /
/cfif
!--- End transaction ---
/cftransaction
!--- Send confirmation email about this order ---
Working on this part now

!--- Gotta empty their cart ---
cfinvoke component=#SESSION.myshoppingcart# method=Empty 


~|
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:207704
Archives: http://www.houseoffusion.com/cf_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: tightening up my cart code

[Dave Watts]

 On my shopping cart app, I've gotten through the payment 
 processing part and now I'm entering the data into two 
 tables. I'm using Nate's example from WACK. Does anyone have 
 any suggestions on improving this code? It works but I want 
 to improve it, and I've never used cftransaction before. 
 In this example, ListFirst(cfhttp.filecontent)is the value 
 returned from authorize.net. 1 - approved, 2- declined, 3- error

 !--- Enter order into tblorders ---
 
 cftransaction action=begin
 ...
 cfif ListFirst(cfhttp.filecontent) EQ 1
 cftransaction action=commit /
 cfelse
 cftransaction action=rollback /
 /cfif

Since the CFHTTP tag isn't shown here, I presume you're executing it before
the CFTRANSACTION even starts. In that case, why not just skip the
transaction if you get a declined or error response?

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:207705
Archives: http://www.houseoffusion.com/cf_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: tightening up my cart code

[dave]

cfqueryparam would be a good place to start

~Dave the disruptor~ 


From: Will Tomlinson [EMAIL PROTECTED]
Sent: Wednesday, May 25, 2005 8:00 PM
To: CF-Talk cf-talk@houseoffusion.com
Subject: tightening up my cart code 

On my shopping cart app, I've gotten through the payment processing part and 
now I'm entering the data into two tables. I'm using Nate's example from WACK. 
Does anyone have any suggestions on improving this code? It works but I want to 
improve it, and I've never used cftransaction before. 
In this example, ListFirst(cfhttp.filecontent)is the value returned from 
authorize.net. 1 - approved, 2- declined, 3- error

Thanks much,
cf Will

INSERT INTO tblorders 
(orderID, orderdate, contactFname, contactLname, shipaddress1, shipaddress2,
shipcity, shipstate, shipzip, shipcountry, shipphone, shipemail, billingfname,
billinglname, billingaddress1, billingaddress2, billingcity, billingstate,
billingzip, billingcountry, billingphone, billingemail, shopperID, notes)
VALUES ('#VARIABLES.invoicenumber#', '#VARIABLES.invoicedate#', 
'#shopperinfo.s_fname#', '#shopperinfo.s_lname#',
'#shopperinfo.s_address1#','#shopperinfo.s_address2#', '#shopperinfo.s_city#', 
'#shopperinfo.s_state#',
 '#shopperinfo.s_zip#', '#shopperinfo.s_country#', '#shopperinfo.s_phone#', 
'#shopperinfo.s_email#',
'#shopperinfo.b_fname#', '#shopperinfo.b_lname#', '#shopperinfo.b_address1#', 
'#shopperinfo.b_address2#',
'#shopperinfo.b_city#', '#shopperinfo.b_state#', '#shopperinfo.b_zip#', 
'#shopperinfo.b_country#', 
'#shopperinfo.b_phone#', '#shopperinfo.b_email#', #shopperinfo.custID#, 
'#ATTRIBUTES.comments#')

INSERT INTO tblorderitems 
(orderID, prodID, prodqty, prodsellprice)
VALUES ('#VARIABLES.invoicenumber#', '#i#', #sc[i].qty#, #sc[i].price#)

Working on this part now



~|
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:207706
Archives: http://www.houseoffusion.com/cf_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: tightening up my cart code

[Will Tomlinson]

 On my shopping cart app, I've gotten through the payment 

Since the CFHTTP tag isn't shown here, I presume you're executing it before
the CFTRANSACTION even starts. In that case, why not just skip the
transaction if you get a declined or error response?


Correct dave, and that's what I was wondering! I didn't understand why his 
example works like this when you could avoid the trans altogether. But being 
the rookie that I am, I didn't know if I'm just missing something. 

thanks much!

...cf Will

~|
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:207707
Archives: http://www.houseoffusion.com/cf_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

CFUNITED interview 11 - Web services, CF and Pocket PC

[Michael Smith]

In this issue of ColdFusion conference and training news:

1. CFUNITED News - ColdFusion 10th birthday, CFUNITED-05 now larger than final
CFUN-04!
2. ColdFusion Live! Every Thursday 12:30pm
3. Why come to CF BootCamp at CFUNITED
4. Leveraging Web Services with ColdFusion interview with Glenda Vigoreaux
5. Developing Pocket PC Applications using .NET Compact Framework and CFMX
Web Services interview with Dave Watts

Happy coding
- Michael Smith,
   TeraTech, Inc  http://www.teratech.com/
   Creating excellent custom software since 1989

   Due to TeraTech's growth we are seeking developers and sales people
   http://www.teratech.com/index.cfm?go=About.Jobs


CFUNITED-05 is a great opportunity to launch your career into the next
level, allowing developers to learn new tips, tricks and techniques, all
while bonding with fellow ColdFusion users many of us only know by name.
- Constanty DeCinko


1. CFUNITED News

* Only 6 weeks until CFUNITED-05. Regular price $649 expires in 3 weeks 6/10/05

* 583 people have already registered for CFUNITED-05. That is more than CFUN-04
total
  - and we have 6 weeks left for more registrations!

* Did you know ColdFusion is 10 years old? CFUNITED attendees can join in
the fun and festivities to celebrate ColdFusion's 10th anniversary at
8:00pm Thursday evening on the Bethesda North Marriott hotel terrace!
The Thursday evening event along with free drinks, games, and fun is
sponsored by HostMySite and TeraTech.

* See CFUNITED presenters at previous ColdFusion Live! meetings at
   http://coldfusion.meetup.com/17/events/?action=pastlist

* New session What’s Coming Next on the Microsoft Platform? Geoff Snowman
http://www.cfunited.com/topics.cfm#198

* Attendee message board coming soon - to share rides, rooms and interests.

* Upcoming classes:

FB101 - Intro to FuseboxMay 24 2005
FB201 - Intermediate FuseboxJun 7 2005
FB301H -Hal Helms FastTrack to Fusebox 4.1  Jun 20 2005
CU201 - Hal Helms - Designing and Developing OO Applications with CFCs  Jun 27 
2005
CU202 - Simon Horwith - Roll Your Own API - Maximizing Code ReUse with CFCs and
Custom Tags Jun 27 2005
CU203 - Geoff Snowman - Intro to .NET for CFers Jun 27 2005
CU204 - Nate Nelson - Beyond Basic SQL for CF   Jun 27 2005
CU205 - Charlie Arehart - CFML Leveraging .NET StrengthsJun 28 2005
CU206 - Sandra Clark - Advanced Cascading Stylesheets   Jun 28 2005
CU208 - Jeff Peters - FLiP and Fusebox walkthrough  Jun 28 2005

For more info http://www.teratech.com/training/

* MiniMAX 2! Join Adam Bell, Simon Horwith and four additional speakers for the
prelude to the CF
United conference on Tuesday Night, June 28th at 7PM ET.
http://www.minimaxconference.com/
It is FREE! (but must register online)

* Missed an interview? All previous interviews are now posted at
   http://www.cfunited.com/interviews.cfm

2. ColdFusion Live! Every Thursday  12:30pm

ColdFusion Live! A CFUNITED preview every Thursday

Two 15 minute preview talks from CFUNITED speakers.  They
will provide an brief introduction to their topic during these
sessions. Plus you can ask questions via Breeze chat.
This week's speakers:
  Geoff Snowman - SQL Server 2005
  Robi Sen - Advanced Scaling and Tuning

12:30 - 1:00 US/Eastern Time

Meeting: http://macromedia.breezecentra l.com/cfliveno5/  (Breeze v.5)
RSVP: http://coldfusion.meetup.com/17/events/4709836/

Future speakers are:

5/26 Glenda Vigoreaux - Leveraging Web Services with ColdFusion
  Sean  Corfield - Enterprise Integration with ColdFusion
6/2  Michael  Dinowitz - Consuming popular web services
  Steve  Rittler - Farcry: A Free ColdFusion-based CMS
6/9  Charlie Arehart - Integrating CFML and ASP.NET Server Controls
  Lou  Honick - How to Build, Refresh or Rebuild Your Datacenter on Time and
Under Budget
6/16 Jeffry Houser - Creating Sound for  Flash Movies
  David Epler - LAMBDA Boxes: ColdFusion Apps on the Cheap

2. Come to CF Bootcamp at CFUNITED
**
At CFUNITED this year we have the BootCamp - this is one of seven
tracks we have - the others are Advanced CF, MX Integration,
Deployment, CFML Platform Integration, Accessibility and
Empowered Programming. CF BootCamp is a 3 day introduction
to ColdFusion that will get you programming in ColdFusion fast!

If you are new to ColdFusion, or if you have a friend who is learning
it, please come to CF BootCamp and get ahead in your career.
The $649 price for CFUNITED is a bargin compare to other intro
CF classes that cost $1200! ($649 price is valid only until 6/10/05)

CF BootCamp Topics include:

  * A CFML Developers’ Guide to .NET
  * CF Studio
  * Content Management: Why It Matters, and How ColdFusion Helps
  * Database Design Fundamentals
  * Designing and Coding for Search Engines
  * Dreamweaver for ColdFusion Developers
  * LAMBDA Boxes: ColdFusion Apps on the Cheap
  * Managing Stress and 

Re: cfexecute and wget

[Jochem van Dieten]

Tim Oommen wrote:
 I running into a problem with cfexecute I am using it to run the following 
 code
 
 cfexecute
 arguments=http://webtest.lawbulletin.com/testasp/callconversion.asp?conversion_id=31;
  name=d:\wwwmx\wget\wget.exe
   timeout=0
 /cfexecute  

Try
cfexecute arguments=/c d:\wwwmx\wget\wget.exe 
http://webtest.lawbulletin.com/testasp/callconversion.asp?conversion_id=31;
  name=c:\winnt\system32\cmd.exe
   timeout=0
/cfexecute

Jochem

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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207709
Archives: http://www.houseoffusion.com/cf_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: cfexecute problem...

[Joseph Brien]

I tried to direct refernce them and took out all variable and used 
filenames, but now im getting a download box that opens up, It asks me to 
save document filetype document

thats when its in the folder C:\My Documents\uploads, when its in the folder 
both the command prompt and thecfexecute bring up the download box.

but when i run it on C:\ through the command prompt i can change the files 
in C:\my documents\upload

Is there some setting with IS or Coldfusion that i have to change? cause i 
cant see whats wrong with it at all..

this is my code now


cfexecute 
name = C:\My Documents\upload\ffmpeg.exe
arguments = -i 'C:\My Documents\upload\Niamh1.jpg' 'C:\My 
Documents\upload\mad.gif'
/cfexecute

any ideas?


On 5/25/05, Joe Rinehart [EMAIL PROTECTED] wrote:
 
 Joe,
 
 You've got a tag nested inside your cfexecute tag. While this is valid:
 
 CftagCfchildtag/cftag
 
 This isn't:
 
 cftag cfchildtag
 
 This should help:
 
 cfexecute
 name = C:\converter.exe
 arguments = -i #serverFile# trynum2.gif
 /cfexecute
 
 -joe
 

-- 
Sincerely
Akira Tsukasa -san


~|
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:207710
Archives: http://www.houseoffusion.com/cf_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: js popup resizing ?

[Bryan Stevenson]

 hey Brian, have you ever noticed that your web addy is jacked?
  www.electricedgesystems.com.cfm/54 
 
 ~Dave the disruptor~ 

musta been a bit of a previous post I stripped..see below..all is well ;-)

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

~|
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:207711
Archives: http://www.houseoffusion.com/cf_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 subtotals - SOLVED

[mayo]

Sorry to take so long to respond. 
I didn't even explain myself well the solution was:

SELECT 
orderedItems.orderID, 
sum(items.itemPrice * orderedItems.itemQty) as
theSubTotal
FROM orderedItems, items
WHERE
orderedItems.orderID=#orderID# AND
orderedItems.itemID=items.itemID
GROUP BY orderedItems.orderID

Thanks all. There is a point were walking away from the laptop is better
ROI than spinning your wheels.

Gil



-Original Message-
From: Joe Rinehart [mailto:[EMAIL PROTECTED] 
Sent: Monday, May 23, 2005 10:26 AM
To: CF-Talk
Subject: Re: adding subtotals

Thanks, Dave - I barely use Oracle, but knowing that is bound to save
me some research next time I do!

-Joe

On 5/23/05, Dave Carabetta [EMAIL PROTECTED] wrote:
 On 5/23/05, Joe Rinehart [EMAIL PROTECTED] wrote:
  Also, if you're using MS SQL server, try doing ewok's query using
the
  WITH ROLLUP option...by using it with proper grouping, you can have
  the server get the by-purchaser and overall totals in the query
  itself.  May have to add a column or two to control ordering of NULL
  values, but, hey, it's MS...
 
 
  SELECT purchaserid, itemid, sum(itemPrice) as TheTotal
  FROM itemsPurchased
  GROUP BY purchaserid, itemid
  WITH ROLLUP
 
 
 And Oracle has the equivalent analytical functions (which have saved
 me tons of coding/hacking).
 
 SELECT purchaserid, itemid, sum(itemPrice) as TheTotal
 FROM itemsPurchased
 GROUP BY ROLLUP ( purchaserid, itemid )
 
 Regards,
 Dave.
 
 



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

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207712
Archives: http://www.houseoffusion.com/cf_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: cfexecute problem...

[Joseph Brien]

I fixed it, when i added timeout = 0 it started to work, I spent a whole 
day trying to get that to work... I really really cant believe it lol

i think im going to go to bed and cry myself to sleep..

On 5/26/05, Joseph Brien [EMAIL PROTECTED] wrote:
 
 I tried to direct refernce them and took out all variable and used 
 filenames, but now im getting a download box that opens up, It asks me to 
 save document filetype document
 
 thats when its in the folder C:\My Documents\uploads, when its in the 
 folder both the command prompt and thecfexecute bring up the download box.
 
 but when i run it on C:\ through the command prompt i can change the files 
 in C:\my documents\upload
 
 Is there some setting with IS or Coldfusion that i have to change? cause i 
 cant see whats wrong with it at all..
 
 this is my code now
 
 
 cfexecute 
 name = C:\My Documents\upload\ffmpeg.exe
 arguments = -i 'C:\My Documents\upload\Niamh1.jpg' 'C:\My 
 Documents\upload\mad.gif'
 /cfexecute
 
 any ideas?
 
 
 On 5/25/05, Joe Rinehart [EMAIL PROTECTED] wrote:
  
  Joe,
  
  You've got a tag nested inside your cfexecute tag. While this is 
  valid:
  
  CftagCfchildtag/cftag
  
  This isn't:
  
  cftag cfchildtag
  
  This should help: 
  
  cfexecute
  name = C:\converter.exe
  arguments = -i #serverFile# trynum2.gif
  /cfexecute
  
  -joe
  
 
 -- 
 Sincerely
 Akira Tsukasa -san 




-- 
Sincerely
Akira Tsukasa -san


~|
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:207713
Archives: http://www.houseoffusion.com/cf_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

cfform / cfform.js issues

[Tim Blankenship]

Additional info
Works on Windows 2000 machines but intermitent on XP.
Co-worker goes to the form and submits and the dump of the form is empty.
I log in to the machine and the dump shows the forms value correctly.
Co-worker is an Admin on his box and a domain Admin so that rules out 
permissions.

 About 2 weeks ago the issue started. Only thing that we know has 
 changed it the webserver has been joined to a new domain.
 
 I have 2 cfm pages. 
 1. Form
 2. Action page
 
 Here is the form
 CFQUERY NAME=GETIDETEAM DATASOURCE=#datasource#
  
 SELECT DISTINCT USERNAME
  
 FROM SITEUSERS
  
 WHERE GROUPNAME = 'Desktop Engineering'
 /CFQUERY
  
 cfform action=test_engine_teammember.cfm?CSR=#URL.CSR#

 cfselect name=TEAMMEMBER 
   size=1
   query=GETIDETEAM
   value=USERNAME
   Display=USERNAME
   required=YES 
   /cfselect

 input type=submit name=Submit value=Update class=srbutton
  
 /cfform
 
 action page is one line
 cfdump var=#FORM#
 
 Problem: I and a few others can run this fine but for some they get an 
 empty struct.
 
 Other info:
 CFMX 6.1 standard on top of IIS 5 /W2K Server
 
 IIS log errors:
 Good (me)
 2005-05-25 16:52:17 10.160.14.178 ITSDO\TB6859 150.233.68.45 80 POST 
 /softfusion/test_engine_teammember.cfm CSR=2976 200 Mozilla/4.
 0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+(R1+1.5);+.NET+CLR+1.1.
 4322)
 Bad (not me)
 2005-05-25 16:54:13 10.160.14.221 ITSDO\SB3643 150.233.68.45 80 GET 
 /softfusion/test_edit_teammember.cfm CSR=2976 200 Mozilla/4.
 0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
 2005-05-25 16:54:13 10.160.14.221 - 150.233.68.45 80 GET 
 /CFIDE/scripts/cfform.js - 304 Mozilla/4.0+(compatible;+MSIE+6.
 0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
 
 Things tried
 moved to unsecure directory
 added scriptSrc argument to cfform, copied cfform.js to same directory 
 as page, made a directory in my project cfide/scripts and copied it 
 there.
 
 We are supposed to have all the same browser setting so that should 
 not be an issue. 
 Security is controlled by IIS and it is set to Intergrated WIndows 
 Authentication. In the error above the script, cfform.js does not have 
 a user defined but does have the IP so I would think that might be the 
 problem but am not sure.
 
 Any suggestions are appreciated, Tim
 [EMAIL PROTECTED]
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:207714
Archives: http://www.houseoffusion.com/cf_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: js popup resizing ?

[dave]

well ain't that a beautifully white page

~Dave the disruptor~ 


From: Bryan Stevenson [EMAIL PROTECTED]
Sent: Wednesday, May 25, 2005 8:58 PM
To: CF-Talk cf-talk@houseoffusion.com
Subject: Re: js popup resizing ? 

 hey Brian, have you ever noticed that your web addy is jacked?
 www.electricedgesystems.com.cfm/54 
 
 ~Dave the disruptor~ 

musta been a bit of a previous post I stripped..see below..all is well ;-)

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



~|
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:207715
Archives: http://www.houseoffusion.com/cf_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: cfform / cfform.js issues

[dave]

look at source code when u submit also is there a chance norton is running on 
any of these machines its not working on?

~Dave the disruptor~ 


From: Tim Blankenship [EMAIL PROTECTED]
Sent: Wednesday, May 25, 2005 9:48 PM
To: CF-Talk cf-talk@houseoffusion.com
Subject: cfform / cfform.js issues 

Additional info
Works on Windows 2000 machines but intermitent on XP.
Co-worker goes to the form and submits and the dump of the form is empty.
I log in to the machine and the dump shows the forms value correctly.
Co-worker is an Admin on his box and a domain Admin so that rules out 
permissions.

 About 2 weeks ago the issue started. Only thing that we know has 
 changed it the webserver has been joined to a new domain.
 
 I have 2 cfm pages. 
 1. Form
 2. Action page
 
 Here is the form
 

 SELECT DISTINCT USERNAME

 FROM SITEUSERS

 WHERE GROUPNAME = 'Desktop Engineering'
 

  

 
 size=1
 query=GETIDETEAM
 value=USERNAME
 Display=USERNAME
 required=YES 
 

 

 
 
 action page is one line
 
 
 Problem: I and a few others can run this fine but for some they get an 
 empty struct.
 
 Other info:
 CFMX 6.1 standard on top of IIS 5 /W2K Server
 
 IIS log errors:
 Good (me)
 2005-05-25 16:52:17 10.160.14.178 ITSDO\TB6859 150.233.68.45 80 POST 
 /softfusion/test_engine_teammember.cfm CSR=2976 200 Mozilla/4.
 0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+(R1+1.5);+.NET+CLR+1.1.
 4322)
 Bad (not me)
 2005-05-25 16:54:13 10.160.14.221 ITSDO\SB3643 150.233.68.45 80 GET 
 /softfusion/test_edit_teammember.cfm CSR=2976 200 Mozilla/4.
 0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
 2005-05-25 16:54:13 10.160.14.221 - 150.233.68.45 80 GET 
 /CFIDE/scripts/cfform.js - 304 Mozilla/4.0+(compatible;+MSIE+6.
 0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322)
 
 Things tried
 moved to unsecure directory
 added scriptSrc argument to cfform, copied cfform.js to same directory 
 as page, made a directory in my project cfide/scripts and copied it 
 there.
 
 We are supposed to have all the same browser setting so that should 
 not be an issue. 
 Security is controlled by IIS and it is set to Intergrated WIndows 
 Authentication. In the error above the script, cfform.js does not have 
 a user defined but does have the IP so I would think that might be the 
 problem but am not sure.
 
 Any suggestions are appreciated, Tim
 [EMAIL PROTECTED]
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:207716
Archives: http://www.houseoffusion.com/cf_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: Query question

[Eric J. Hoffman]

Do I need to do subselects with date ranges in each or will that not help 
either.if anyone can quickly help that would be great!!  Thanks!



From: Eric J. Hoffman [mailto:[EMAIL PROTECTED]
Sent: Wed 5/25/2005 4:49 PM
To: CF-Talk
Subject: Query question



I am doing probably the simplest query, but am on little sleep, can
someone tell me where I am goofing?

Select 
COUNT (customer_orders.id) as totqty,
SUM (customer_orders.subtotal) as subtot,
SUM (customer_orders.shipcost) as cstship,
SUM (customer_orders.shipquote) as qteship,
AVG (customer_orders.subtotal) as avgsub,
AVG (customer_orders.shipcost) as avgship
FROM customer_orders
WHERE customer_orders.orderdate BETWEEN #start1a# AND
#DateAdd('D', 1, end1a)#
AND subtotal  50

Just want all orders for a date period to give me sums and averages that
was under 50 dollars.  But it seems to be getting from all time.  What
did I miss?

Thanks!

Eric



~|
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:207717
Archives: http://www.houseoffusion.com/cf_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