Re: CFCs not being processed by IIS or CF

2008-10-08 Thread Wesley Middendorff
Adrian,


I was able to get this to work with no problems. Have you checked the
directory permissions?

Wes


On 10/8/08, adrian lynch [EMAIL PROTECTED] wrote:

 Sorry, access is set to remote. We were playing about with it when I copied
 and pasted :)

  Hey all, set up a new site and I'm trying to invoke a cfc as a
  webservice.
 
  I've put a dump cfc in the webroot to remove any pathing issues. The
  cfc looks like this:
 
  cfcomponent displayname=ws output=true
 
cffunction name=test returntype=numeric access=private
  output=true
cfreturn 123
/cffunction
 
  /cfcomponent
 
  When I browse to any of the following:
 
  http://domain/ws.cfc?wsdl
  http://domain/ws.cfc
  http://domain/ws.cfc?method=test
 
  I get a blank page.
 
  I thought it might have something to do with CFIDE not being a virtual
  dir so we created that. No joy.
 
  From a file in the same dir I run:
 
  cfset x = CreateObject(component, ws)
  cfdump var=#x#
 
  cfset y = x.test()
  cfdump var=#y#
 
  cfinvoke webservice=http://bv2008.internal.thoughtbubble.net/ws.
  cfc?wsdl method=test returnvariable=z
  cfdump var=#z#
 
  Which results in:
 
  A dump of the component showing the test method.
 
  123, the output of the call to the x.test().
 
  And then an error:
 
  Unable to read WSDL from URL: http://domain/ws.cfc?wsdl
 
  Which is fair enough as there is no WSDL being created.
 
  Looking in the IIS logs we see the requests coming in. Are there any
  over places we can look at maybe?
 
  It's on Win 2003, IIS and CF8. URLScan is installed but the logs don't
  report anything as being blocked.
 
  Any ideas on what could be happening?
 
  Thanks.
 
  Adrian


 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313610
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CFMX 7 using zip files

2008-10-08 Thread Wesley Middendorff
I have found the solution. Basically the toString method changed some of the
info and I was unable to write the file in this manner. Instead, I used a
file output stream and the toByteArray method and it works.


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313620
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: How to do this conditional statement.

2007-08-17 Thread Wesley Middendorff
Yes you need the parens, and yes that second statement is correct.

On 8/17/07, Will Tomlinson [EMAIL PROTECTED] wrote:

 Easy question here... just wanna make sure I don't screw this up cause
 it's kinda important.  :)

 Here's my current statement.

 cfif getSection.DeliveryMethod EQ Web-Enhanced AND
 getWebEnhancedAddonQuestions.recordcount
 Show questions blah blah...
 /cfif

 What I need it to say is, if the delivery method is web-enhanced OR
 hybrid.

 Would you just stick it in there? Or use parenthesis around those two
 items?


 cfif (getSection.DeliveryMethod EQ Web-Enhanced OR
 getSection.DeliveryMethod EQ Hybrid) AND
 getWebEnhancedAddonQuestions.recordcount
 Show questions blah blah...
 /cfif

 Or, do I even need the parenthesis.

 It takes quite a bit of time to test this thing, or else I'd be testing
 instead of asking you guys.  :)

 Thanks,
 Will

 

~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286463
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Webwasher, Excel files, and why I hate my life

2007-08-17 Thread Wesley Middendorff
I also have no access to appache, thanks for all your responses no it is
just a matter of convincing these corperate types to let go of webwasher for
this intranet site on which they control the content anyhow.

On 8/17/07, Tom Chiverton [EMAIL PROTECTED] wrote:

 On Friday 17 Aug 2007, [EMAIL PROTECTED] wrote:
  You will avoid that problem if you use Apache POI to generate the
  Excel file instead of using HTML tables.

 He said he had the same problem with 'real' Excel XML files, as per the MS
 spec.
 So MailWasher is broken. Who knows that else is wrong with it ?

 --
 Tom Chiverton
 Helping to widespreadedly synthesize scalable solutions
 on: http://thefalken.livejournal.com

 

 This email is sent for and on behalf of Halliwells LLP.

 Halliwells LLP is a limited liability partnership registered in England
 and Wales under registered number OC307980 whose registered office address
 is at St James's Court Brown Street Manchester M2 2JF.  A list of members is
 available for inspection at the registered office. Any reference to a
 partner in relation to Halliwells LLP means a member of Halliwells LLP.
 Regulated by the Law Society.

 CONFIDENTIALITY

 This email is intended only for the use of the addressee named above and
 may be confidential or legally privileged.  If you are not the addressee you
 must not read it and must not use any information contained in nor copy it
 nor inform any person other than Halliwells LLP or the addressee of its
 existence or contents.  If you have received this email in error please
 delete it and notify Halliwells LLP IT Department on 0870 365 8008.

 For more information about Halliwells LLP visit www.halliwells.com.


 

~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286464
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CFHTTP, SSL v3, and MX7

2007-08-16 Thread Wesley Middendorff
I had this problem in the past with a different website, but the issue is
still the same. I ended up creating a seperate java keystore with the
information for the SSL in it. Then I created a java class to use that
keystore and make the connection. HTTPConnection does support SSL v3, but I
found that I could not do it using the default JRUN keystore. If you want
the java class source code, I could probably get it from someone who still
works there.


On 8/16/07, Joseph Frank [EMAIL PROTECTED] wrote:

 eBay has indicated that all calls to their secure API must use SSL 
 3.0starting in a few days. Looking around the Net a bit, it seems that CFHTTP
 in MX7 does not support SSL 3.0, however, I cannot absolutely confirm it.

 Can anyone confirm whether SSL 3.0 is not supported when using CFHTTP to
 post to a secure URL?

 If this is in fact true, does anyone have an idea, other than upgrading to
 MX8 (not in the cards right now), what I can use to replace, or otherwise
 enhance CFHTTP to support SSL v3?

 Thanks,

 Joe

 

~|
Check out the new features and enhancements in the
latest product release - download the What's New PDF now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286363
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: cfgrid

2007-06-04 Thread Wesley Middendorff
Good tip and helpful, but alas not the solution. The applet will load when
accessing the site through localhost, but not when accessed through the IP
address. Also, other cfform elements do work correctly. I have been trying
to track someone down who has admin priviledges in IIS thinking that it
might the problem. Still taking any suggestions.

On 6/2/07, Dave Watts [EMAIL PROTECTED] wrote:

  I am having trouble with the cfgrid tag. My situation is such
  that on my developement server I am able to access the cfgrid
  applet everything works great when accessed through
  http://localhost/..., but when accessing from the machines IP
  address (http://255.255.255.255/...) from the server or
  anywhere else it does not load and I get the nasty box with
  the red X.

 Make sure that the path to CFIDE exists on your server.

 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!

 This email has been processed by SmoothZap - www.smoothwall.net


 

~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade  see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279985
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: cfgrid

2007-06-04 Thread Wesley Middendorff
Didn't think of it that way, once I find the administrator for IIS on this
server I will check that. I did try dumping the CFIDE directory directly
into the webroot though, but I think this gives me a very good starting
point


Thanks
Wes


On 6/4/07, Dave Watts [EMAIL PROTECTED] wrote:

  Good tip and helpful, but alas not the solution. The applet
  will load when accessing the site through localhost, but
  not when accessed through the IP address. Also, other cfform
  elements do work correctly. I have been trying to track
  someone down who has admin priviledges in IIS thinking that
  it might the problem. Still taking any suggestions.

 If the applet loads through localhost, but doesn't load through your
 virtual
 server, you may well have a misconfigured virtual server - that is, the
 URL
 path to /CFIDE doesn't exist on that server.

 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!

 This email has been processed by SmoothZap - www.smoothwall.net


 

~|
Create robust enterprise, web RIAs.
Upgrade  integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279990
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Dealing with Large queries and csv files

2007-05-16 Thread Wesley Middendorff
If you database server has access to a file system that your CF server also
has access to, you could try using the export functions built into your DB
server. I usually try to keep data processing in the DB server since it is
way more efficient at it.

Wes


On 5/16/07, Tony [EMAIL PROTECTED] wrote:

 hi there.

 when dealing with record sets in the 10,000 records plus arena
 how do you, in the fastest way possible, get that record set into
 comma delimited format, and subsequently write that out to a file?

 i have a nice little test bed setup, that i can see very the bottlenecks
 in doing this.

 getting the data takes less than 2 seconds
 taking the data from a query object to a csv formatted object takes too
 long
 writing it to a file takes no time at all maybe a second or two

 and the rest is willy nilly... its just the process of query object to
 csv formatted
 object, that is the problem...

 how/what do you all do?

 btw, im currently using the UDF (QueryToCsvSpecificRows())

 thanks!
 tony

 --
 'Never have anything in your life that you can't walk out on in thirty
 seconds flat, if you spot the heat coming around the corner'

 robert deniro - heat (1995)

 

~|
Macromedia ColdFusion MX7
Upgrade to MX7  experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278336
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Dealing with Large queries and csv files

2007-05-16 Thread Wesley Middendorff
whoops, didn't see the other posts. You could create a SQL server
integration services package. This could then be executed from a stored
procedure that your CF code could call. (supposing that CF needs to do
something with the file afterwards).

On 5/16/07, Wesley Middendorff [EMAIL PROTECTED] wrote:

 If you database server has access to a file system that your CF server
 also has access to, you could try using the export functions built into your
 DB server. I usually try to keep data processing in the DB server since it
 is way more efficient at it.

 Wes


 On 5/16/07, Tony [EMAIL PROTECTED] wrote:
 
  hi there.
 
  when dealing with record sets in the 10,000 records plus arena
  how do you, in the fastest way possible, get that record set into
  comma delimited format, and subsequently write that out to a file?
 
  i have a nice little test bed setup, that i can see very the bottlenecks
  in doing this.
 
  getting the data takes less than 2 seconds
  taking the data from a query object to a csv formatted object takes too
  long
  writing it to a file takes no time at all maybe a second or two
 
  and the rest is willy nilly... its just the process of query object to
  csv formatted
  object, that is the problem...
 
  how/what do you all do?
 
  btw, im currently using the UDF (QueryToCsvSpecificRows())
 
  thanks!
  tony
 
  --
  'Never have anything in your life that you can't walk out on in thirty
  seconds flat, if you spot the heat coming around the corner'
 
  robert deniro - heat (1995)
 
  

~|
Macromedia ColdFusion MX7
Upgrade to MX7  experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278337
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Strange concactination problem

2007-05-16 Thread Wesley Middendorff
Use this function. You are trying to directly update the rows of a query.

*QuerySetCell*(*query*, *column_name*, *value* [, *row_number *])


Wes


On 5/16/07, Ian Skinner [EMAIL PROTECTED] wrote:

 Can anybody see an issue with the following CFScript?  I have confirmed
 that the if clauses turn true at the appropriate times, but for some
 reason the strings are not being modified when they are.



 cfoutput query=Shipped

cfscript

line = ;//init

if (left(UnitNo,5) EQ W0358)

{

UnitNo = =  UnitNo  00;

}

line = line  UnitNo  , ;//BloodID



if (left(Component,1) EQ E)

{

Component = =  Component  00;

}

else

{

Component = 0  Component;

}

line = line  Component  , ;//ProductCode

 

 /cfscript

 /cfoutput


 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.



 

~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278341
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CreateObject() with java

2007-04-18 Thread Wesley Middendorff
That helps a little, I am now getting some other error that is not so
helpfull...



   Object Instantiation Exception.  An exception occurred when instantiating
a java object. The cause of this exception was that: YP_Unzip (wrong name:
YP_UnZip).


This shouldn't be so difficult.



On 4/18/07, Gaulin, Mark [EMAIL PROTECTED] wrote:

 Java classpaths sound not actually contain .class files (although
 .jar files are included in classpaths).

 Assuming your java class in not in a package (which is a Bad idea, but
 looks to be the case from your java code), then you need to include in
 the classpath the directory containing your .class file.  A sort of
 best practice would be to create a directory somewhere called
 classes and then to put your .class files in there, and add that dir
 to the classpath.  If your java classes are in a package (again, a good
 idea, like maybe com.wmiddeendorf), then your .class files go unto
 appropriate subdirs under classes (like classes/com/wmiddeendorf).

 Hope that helps.

Mark

 -Original Message-
 From: Wes Middendorff [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, April 18, 2007 4:32 PM
 To: CF-Talk
 Subject: CreateObject() with java

 I have a totally newb problem. I have a written a java class to unzip
 files (which works JRUN's jre), but I am trying to use it with
 coldfusion and am unable to get coldfusion to even recognize that it is
 there. I have set up the classpath in administrator and ensured several
 times that the path is correct. The contents of the classpath field in
 CFAdmin is:
 C:\CFusionMX7\runtime\jre\lib\YP_Unzip.class

 I am sure I have to have something configured incorrectly.

 here is my code (though I am not sure that this is the problem):

 COLDFUSION:

 cfset temp = createObject(java, YP_Unzip)

 JAVA:

 import java.io.*;
 import java.util.zip.*;


 class YP_UnZip {
public void Unzip (String Args[]){

int BUFFER = 2048;
   int i;
BufferedOutputStream dest = null;
FileInputStream inputfile;
ZipInputStream  zipfile;


if (Args.length != 0){

//loop over files to be unzipped
for(i=0; i Args.length; i++){
System.out.print(Unzipping : );
System.out.print(Args[i]);
System.out.println();

try{

inputfile = new FileInputStream(Args[i]);
zipfile = new ZipInputStream(new
 BufferedInputStream(inputfile));
ZipEntry entry;

while ((entry = zipfile.getNextEntry()) !=
 null){
System.out.println(Extracting : +entry);

int count;
byte data[] = new byte[BUFFER];

//write the back to disk
FileOutputStream outputfile = new
 FileOutputStream(entry.getName());

dest = new BufferedOutputStream(outputfile,
 BUFFER);
while ((count = zipfile.read(data, 0, BUFFER))
 != -1) {
  dest.write(data, 0, count);
 }

dest.flush();
dest.close();


}
 }
catch(Exception e){
  e.printStackTrace();
 }//end try-catch block

}   //end for loop

 }//end if (Args.length != 0)
 else{
   //code for error handling goes here - error missing file
 }

 }//main

 }



 Any help would be greatly appreciated.

 Thanks,
 Wes



 

~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ 

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275768
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: CreateObject() with java

2007-04-18 Thread Wesley Middendorff
Thanks for your help everyone. I think I will be okay now.

On 4/18/07, Russ [EMAIL PROTECTED] wrote:

 Might want to make it public class instead of class... It could also use a
 constructor (or make the method static).

 Russ



  -Original Message-
  From: Wesley Middendorff [mailto:[EMAIL PROTECTED]
  Sent: Wednesday, April 18, 2007 5:08 PM
  To: CF-Talk
  Subject: Re: CreateObject() with java
 
  That helps a little, I am now getting some other error that is not so
  helpfull...
 
 
  
 Object Instantiation Exception.  An exception occurred when
  instantiating
  a java object. The cause of this exception was that: YP_Unzip (wrong
 name:
  YP_UnZip).
 
 
  This shouldn't be so difficult.
 
 
 
  On 4/18/07, Gaulin, Mark [EMAIL PROTECTED] wrote:
  
   Java classpaths sound not actually contain .class files (although
   .jar files are included in classpaths).
  
   Assuming your java class in not in a package (which is a Bad idea,
 but
   looks to be the case from your java code), then you need to include in
   the classpath the directory containing your .class file.  A sort of
   best practice would be to create a directory somewhere called
   classes and then to put your .class files in there, and add that dir
   to the classpath.  If your java classes are in a package (again, a
 good
   idea, like maybe com.wmiddeendorf), then your .class files go unto
   appropriate subdirs under classes (like classes/com/wmiddeendorf).
  
   Hope that helps.
  
  Mark
  
   -Original Message-
   From: Wes Middendorff [mailto:[EMAIL PROTECTED]
   Sent: Wednesday, April 18, 2007 4:32 PM
   To: CF-Talk
   Subject: CreateObject() with java
  
   I have a totally newb problem. I have a written a java class to unzip
   files (which works JRUN's jre), but I am trying to use it with
   coldfusion and am unable to get coldfusion to even recognize that it
 is
   there. I have set up the classpath in administrator and ensured
 several
   times that the path is correct. The contents of the classpath field in
   CFAdmin is:
   C:\CFusionMX7\runtime\jre\lib\YP_Unzip.class
  
   I am sure I have to have something configured incorrectly.
  
   here is my code (though I am not sure that this is the problem):
  
   COLDFUSION:
  
   cfset temp = createObject(java, YP_Unzip)
  
   JAVA:
  
   import java.io.*;
   import java.util.zip.*;
  
  
   class YP_UnZip {
  public void Unzip (String Args[]){
  
  int BUFFER = 2048;
 int i;
  BufferedOutputStream dest = null;
  FileInputStream inputfile;
  ZipInputStream  zipfile;
  
  
  if (Args.length != 0){
  
  //loop over files to be unzipped
  for(i=0; i Args.length; i++){
  System.out.print(Unzipping : );
  System.out.print(Args[i]);
  System.out.println();
  
  try{
  
  inputfile = new FileInputStream(Args[i]);
  zipfile = new ZipInputStream(new
   BufferedInputStream(inputfile));
  ZipEntry entry;
  
  while ((entry = zipfile.getNextEntry()) !=
   null){
  System.out.println(Extracting : +entry);
  
  int count;
  byte data[] = new byte[BUFFER];
  
  //write the back to disk
  FileOutputStream outputfile = new
   FileOutputStream(entry.getName());
  
  dest = new BufferedOutputStream(outputfile,
   BUFFER);
  while ((count = zipfile.read(data, 0, BUFFER))
   != -1) {
dest.write(data, 0, count);
   }
  
  dest.flush();
  dest.close();
  
  
  }
   }
  catch(Exception e){
e.printStackTrace();
   }//end try-catch block
  
  }   //end for loop
  
   }//end if (Args.length != 0)
   else{
 //code for error handling goes here - error missing file
   }
  
   }//main
  
   }
  
  
  
   Any help would be greatly appreciated.
  
   Thanks,
   Wes
  
  
  
  
 
 

 

~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275791
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Not Sure What is Wrong

2007-04-18 Thread Wesley Middendorff
You may wish to use cfqueryparam for your date/time fields.

On 4/18/07, Steve LaBadie [EMAIL PROTECTED] wrote:

 I have added a date field to an admin panel and am having trouble getting
 it to work properly.  In the error message it does show that the text and
 date are passing, but am recieving an error with the CFIF.  Any thoughts
 would be appreciated.

 Error says: Error Executing Database Query and Syntax error in INSERT
 INTO

 cfset CurrentPage=GetFileFromPath(GetTemplatePath())
 cfif IsDefined(FORM.MM_InsertRecord) AND FORM.MM_InsertRecord EQ
 frmAddEvents
 cfquery datasource=member_login
 INSERT INTO Events (Events, Date)
 VALUES (
 cfif IsDefined(FORM.Events) AND #FORM.Date# NEQ 
 '#FORM.Events#', #FORM.Date#
 cfelse
 NULL
 /cfif
 )
 /cfquery
 form action=cfoutput#CurrentPage#/cfoutput method=post
 name=frmEvents id=frmAddEvents
 input type=text name=date id=date size=15 maxlength=10
 class=formveld /
 textarea name=events cols=70 rows=10 id=events
 class=formveld/textarea
 input name=Reset type=reset id=Reset value= Reset 
 class=formveld
 input name=Submit type=submit id=Submit value= Submit 
 class=formveld
 input type=hidden name=MM_InsertRecord value=frmAddEvents
 /form

 Steve

 

~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7  
Flex 2
Free Trial 
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275792
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Not Sure What is Wrong

2007-04-18 Thread Wesley Middendorff
Keyword date, didnt even dawn on me, but that is the more likely answer.

On 4/18/07, Charlie Griefer [EMAIL PROTECTED] wrote:

 1) Date is a reserved word.  If you can't change it, enclose it in
 square brackets.
 2) you have 2 columns specified (Events, Date) but in your cfelse
 condition you're only inserting a single value.  You should have NULL,
 NULL.

 On 4/18/07, Steve LaBadie [EMAIL PROTECTED] wrote:
  I have added a date field to an admin panel and am having trouble
 getting it to work properly.  In the error message it does show that the
 text and date are passing, but am recieving an error with the CFIF.  Any
 thoughts would be appreciated.
 
  Error says: Error Executing Database Query and Syntax error in INSERT
 INTO
 
  cfset CurrentPage=GetFileFromPath(GetTemplatePath())
  cfif IsDefined(FORM.MM_InsertRecord) AND FORM.MM_InsertRecord EQ
 frmAddEvents
  cfquery datasource=member_login
  INSERT INTO Events (Events, Date)
  VALUES (
  cfif IsDefined(FORM.Events) AND #FORM.Date# NEQ 
  '#FORM.Events#', #FORM.Date#
  cfelse
  NULL
  /cfif
  )
  /cfquery
  form action=cfoutput#CurrentPage#/cfoutput method=post
 name=frmEvents id=frmAddEvents
  input type=text name=date id=date size=15 maxlength=10
 class=formveld /
  textarea name=events cols=70 rows=10 id=events
 class=formveld/textarea
  input name=Reset type=reset id=Reset value= Reset 
 class=formveld
  input name=Submit type=submit id=Submit value= Submit 
 class=formveld
  input type=hidden name=MM_InsertRecord value=frmAddEvents
  /form
 
  Steve
 
 

 

~|
ColdFusion MX7 and Flex 2 
Build sales  marketing dashboard RIA’s for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275793
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Java classes in coldfusion

2007-02-14 Thread Wesley Middendorff
Joseph gets the final hurrah on this one. After exposing the constructors
everything is a ok.

On 2/14/07, Joseph Lamoree [EMAIL PROTECTED] wrote:

 On 14 Feb 2007, at 10:50, Wes Middendorff wrote:

   Unable to find a constructor for class javaHTTPSconnection that
  accepts parameters of type ( ).
 
  public class javaHTTPSconnection {
 
 
javaHTTPSconnection(){
 }
 
javaHTTPSconnection(String a, String b, String c){
 }
 
  }

 You need to expose your constructors to ColdFusion with the public
 access modifier. You won't be able to create an instance of this
 class from ColdFusion directly until you do. The constructor with
 three string arguments will probably not need clarification, but be
 aware to use the javaCast() function in the case of numbers.


 --
 Joseph Lamoree

 

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269855
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Java classes in coldfusion

2007-02-14 Thread Wesley Middendorff
Sorry for all the newb questions here, but now i am getting Error casting
an object of type **to an incompatible type.
Which occurs when calling the HTTPcon method. Is there a problem with trying
to pass an array of strings back to coldfusion?


~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269858
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Java classes in coldfusion

2007-02-14 Thread Wesley Middendorff
Well the issue doesn't occur until I call method HTTPScon (see code). This
method has no parameters being passed to it, but does return an array of
strings. If it were the parameters being passed from coldfusion wouldn't I
see a problem upon instantiating the object?

Wes


On 2/14/07, Eric Roberts [EMAIL PROTECTED] wrote:

 If I am understanding what you are asking, you probably need to use
 javacast
 to cast the variable of the appropriate java type.

 Eric

 -Original Message-
 From: Wesley Middendorff [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, February 14, 2007 3:18 PM
 To: CF-Talk
 Subject: Re: Java classes in coldfusion

 Sorry for all the newb questions here, but now i am getting Error casting
 an object of type **to an incompatible type.
 Which occurs when calling the HTTPcon method. Is there a problem with
 trying
 to pass an array of strings back to coldfusion?




 

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2  MX7 integration  create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269860
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4