RSL load failed !!

I have a CFForm which has two select menus retreving the resultset of two queries however when the page is loading, it show RSL load failed !!
anyone can give me some suggestions ? the code is shown below !
Thanks !!
Mike

<CFQUERY NAME="list1" DATASOURCE="clinical_time">
SELECT Distinct hospital FROM testtable1
</CFQUERY>

<CFQUERY NAME="list2" DATASOURCE="clinical_time">
SELECT Distinct specialty FROM testtable2
</CFQUERY>

<cfform name="myform" format="flash" width="400">
<cfformgroup type="hbox">
<cfselect queryposition="below" label="Hospital"
                  name="selectHospital" query="list1" value="hospital" display="Hospital" width="200">
                                <cfoutput query="list1"><option value="#hospital#">#hospital#</option></cfoutput>
  </cfselect>
<cfselect queryposition="below" label="Specialty"
                  name="selectSpecialty"  query="list2" value="specialty" display="Specialty" width="200">
                                <cfoutput query="list2"><option value="#specialty#">#specialty#</option></cfoutput>
</cfselect>
</cfformgroup>  
</cfform>
mmccyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

RCorfmanCommented:
Here is a pretty long post on MacroMedia's Website regarding this.
http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=22&threadid=976035&enterthread=y

In case the link above goes bad, here is a quote from the above link.
Sorry for the delay in reply. Hopefully this will help.

Given the location of your webpage physically in root/inetpub/wwwroot/webpage
Physical File Location root/folder1/folder2/cfide/scripts/cfform.swc


1. Your Operating System must see the folder and files in its location from the root of the drive ( root/folder1/folder2/cfide/scripts/cfform.swc )

2. Your Web Server must see the same folder from within the root of the webpage root/inetpub/wwwroot/webpage/folder1/folder2/cfide/scripts/cfform.swc

So, make a virtual directory within your Web Server setting the physical location of the drive ( root/folder1/folder2/cfide/scripts/cfform.swc ) to a virtual directory of root/inetpub/wwwroot/webpage/folder1/folder2/cfide/scripts/cfform.swc

You should now be able to access the file by looking at http://www.webpage.com/folder1/folder2/cfide/scripts/cfform.swc

Now, by going into your webserver and starting at the root typing /folder1/folder2/cfide/scripts you should be able to access the directory. By the same token within a html file in the webpage folder, a URL /folder1/folder2/cfide/scripts should open the same directory. Now that your Web Server and Operating System are on the same page (so to speak) make sure your permissions allow everyone access and you should be good to go.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Servers

From novice to tech pro — start learning today.