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 --------------------~--> Most low income homes are not online. Make a difference this holiday season! http://us.click.yahoo.com/5UeCyC/BWHMAA/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/
