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"; > 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"; xmlns="*"> > ><mx:WebService id="srv" > >wsdl="http://flex.homesmartagent.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 > >Search Archives: 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. > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/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/
