Jeremy - Testing as a web service from a cfm page is still throwing errors. Looks like you are missing the return type on the method. Thats required for making cfcs available as a WebService:
<cfobject webservice="http://flex.homesmartagent.com/wsdl/hs2f.cfc?wsdl"; name="srv"/> <cfset test = srv.qpTest("hi there")> <cfdump var="#test#"> AxisFault faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.generalException faultSubcode: faultString: Error attempting to create Java skeleton for CFC web service; nested exception is: coldfusion.xml.rpc.CFCInvocationException: [coldfusion.xml.rpc.CFCInvocationException : returnType must be defined for remote CFC functions.] faultActor: faultNode: faultDetail: {http://xml.apache.org/axis/}hostname:Webserver1 At 02:01 PM 12/29/2005, you wrote: >I removed the function and added this new function. I can invoke the >cfc correctly with in a cfm page. > ><cffunction name="qpTest" access="remote" output="true"> ><cfargument name="mySearch" type="string" required="no" /> ><cfquery name="qpTest" datasource="#application.dsn#"> >select * from tbl_smartPanel_propInfo_Sale >where fld_fileNum like '%#arguments.mySearch#%' ></cfquery> ><cfreturn qpTest /> ></cffunction> > >--- In [email protected], Jeff Tapper <[EMAIL PROTECTED]> wrote: > > > > Seems to be a problem in the CFC. I tried calling it from a cfm >page and > > got an error, which said > > Error Executing Database Query.][java.sql.SQLException : Table > > 'test.tbl_smartPanel_propInfo' doesn't exist] > > > > My test cfm has only this: > > <cfobject >webservice="<http://flex.homesmartagent.com/wsdl/hs2f.cfc?wsdl>http://flex.homesmartagent.com/wsdl/hs2f.cfc?wsdl"; > > > > name="srv"/> > > <cfset test = srv.qpAdminFiles("hi there")> > > <cfdump var="#test#"> > > > > > > > > At 11:18 AM 12/29/2005, you wrote: > > >Ok I will post this again, I have a simple test flex app that I am > > >using (code below). That connects to a cfc, that accpets the incoming > > >argument mySearch. The cfc compares the argument passed agaist the > > >database and then returns a value. However, everytime I run this code > > >and input a value in the input box and hit submit, it comes back > > >saying Http Request Error. I have the crossdomain in my webroot > > >(/var/www/html/) and I also have it in my site root > > >(/var/www/html/hs2f) and I also have it in my cfc root > > >(/var/www/html/hs2f/wsdl). I have tried having it only in my root, > > >root + site root and so on. > > > > > >Here is my code. > > > > > >Flex: > > > > > ><?xml version="1.0" encoding="utf-8"?> > > ><mx:Application > xmlns:mx="<http://www.macromedia.com/2005/mxml>http://www.macromedia.com/2005/mxml"; >xmlns="*"> > > ><mx:WebService id="srv" > > >wsdl="<http://flex.homesmartagent.com/wsdl/hs2f.cfc?wsdl>http://flex.ho > mesmartagent.com/wsdl/hs2f.cfc?wsdl" > > >showBusyCursor="true" /> > > ><mx:Script> > > ><![CDATA[ > > > > > >function qpAdminFiles(mySearch){ > > > > > >srv.qpAdminFiles(mySearch);} > > >]]> > > ></mx:Script> > > ><mx:states> > > ><mx:State name="results"> > > ><mx:PropertyOverride target="{panel1}" property="width" value="100%"/> > > ><mx:PropertyOverride target="{panel1}" property="height" value="100%"/> > > ><mx:AddChild target="{canvas1}" position="lastChild"> > > ><mx:DataGrid x="1" width="100%" > > >dataProvider="{srv.qpAdminFiles.result}" height="50%" y="85"> > > ><mx:columns> > > ><mx:DataGridColumn headerText="File Number:" > > >columnName="FLD_FILENUM"/> > > ><mx:DataGridColumn headerText="Archived:" columnName="col2"/> > > ><mx:DataGridColumn headerText="Last Update:" columnName="col3"/> > > ></mx:columns> > > ></mx:DataGrid> > > ></mx:AddChild> > > ><mx:PropertyOverride target="{panel1}" property="title" value="File > > >Search"/> > > ></mx:State> > > ></mx:states> > > ><mx:Panel height="101" width="514" id="panel1" title="File Search" > > >resizeEffect="Resize"> > > ><mx:Canvas height="100%" width="100%" id="canvas1"> > > ><mx:Label x="7" y="22" text="File Number:" height="20" id="label1"/> > > ><mx:TextInput x="85" y="20" toolTip="Partial file numbers are ok" > > >id="mySearch"/> > > ><mx:Button x="250" y="20" label="Find" id="button1" > > >click="currentState='results';qpAdminFiles(mySearch.text);"/> > > ><mx:Button label="Reset" x="304" y="20" > > >click="currentState='start'" id="button2"/> > > ></mx:Canvas> > > ></mx:Panel> > > > > > ></mx:Application> > > > > > > > > >CFC: > > > > > ><cffunction name="qpAdminFiles" access="remote" returntype="string" > > >output="true"> > > ><cfargument name="mySearch" type="string" required="yes" /> > > ><cfquery name="qpAdminFiles" datasource="#application.dsn#"> > > >select * from tbl_smartPanel_propInfo > > >where fld_fileNum like '%#arguments.mySearch#%' > > ></cfquery> > > ><cfreturn qpAdminFiles /> > > ></cffunction> > > > > > > > > > > > > > > > > > >-- > > >Flexcoders Mailing List > > >FAQ: > <http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt>http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt > > >Search Archives: ><http://www.mail-archive.com/flexcoders%40yahoogroups.com>http://www.mail-archive.com/flexcoders%40yahoogroups.com > > > > > > > > > > > >SPONSORED LINKS > > >Web site design development Computer software development Software >design > > >and development > > >Macromedia flex Software development best practice > > > > > > > > >YAHOO! GROUPS LINKS > > > > > > Visit your group "flexcoders" on the web. > > > > > > To unsubscribe from this group, send an email to: > > > [EMAIL PROTECTED] > > > > > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > > > > > > > > > > >-- >Flexcoders Mailing List >FAQ: ><http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt>http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt >Search Archives: ><http://www.mail-archive.com/flexcoders%40yahoogroups.com>http://www.mail-archive.com/flexcoders%40yahoogroups.com > > > > > >SPONSORED LINKS ><http://groups.yahoo.com/gads?t=ms&k=Web+site+design+development&w1=Web+site+design+development&w2=Computer+software+development&w3=Software+design+and+development&w4=Macromedia+flex&w5=Software+development+best+practice&c=5&s=166&.sig=L-4QTvxB_quFDtMyhrQaHQ>Web > >site design development ><http://groups.yahoo.com/gads?t=ms&k=Computer+software+development&w1=Web+site+design+development&w2=Computer+software+development&w3=Software+design+and+development&w4=Macromedia+flex&w5=Software+development+best+practice&c=5&s=166&.sig=lvQjSRfQDfWudJSe1lLjHw>Computer > >software development ><http://groups.yahoo.com/gads?t=ms&k=Software+design+and+development&w1=Web+site+design+development&w2=Computer+software+development&w3=Software+design+and+development&w4=Macromedia+flex&w5=Software+development+best+practice&c=5&s=166&.sig=1pMBCdo3DsJbuU9AEmO1oQ>Software > >design and development ><http://groups.yahoo.com/gads?t=ms&k=Macromedia+flex&w1=Web+site+design+development&w2=Computer+software+development&w3=Software+design+and+development&w4=Macromedia+flex&w5=Software+development+best+practice&c=5&s=166&.sig=OO6nPIrz7_EpZI36cYzBjw>Macromedia > >flex ><http://groups.yahoo.com/gads?t=ms&k=Software+development+best+practice&w1=Web+site+design+development&w2=Computer+software+development&w3=Software+design+and+development&w4=Macromedia+flex&w5=Software+development+best+practice&c=5&s=166&.sig=f89quyyulIDsnABLD6IXIw>Software > >development best practice > > >---------- >YAHOO! GROUPS LINKS > > * Visit your group > "<http://groups.yahoo.com/group/flexcoders>flexcoders" on the web. > * > * To unsubscribe from this group, send an email to: > * > <mailto:[EMAIL PROTECTED]>[EMAIL PROTECTED] > > * > * Your use of Yahoo! Groups is subject to the > <http://docs.yahoo.com/info/terms/>Yahoo! Terms of Service. > > >---------- ------------------------ Yahoo! Groups Sponsor --------------------~--> AIDS in India: A "lurking bomb." Click and help stop AIDS now. http://us.click.yahoo.com/9QUssC/lzNLAA/TtwFAA/nhFolB/TM --------------------------------------------------------------------~-> -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/flexcoders/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
