Fetch - checkbox or radio button support?

[Tylor Hagerman]

Fetch - checkbox or radio button support?

Ideally I'd like to perform a fetch and have the resulting query populate radio or checkbox inputs, just like it does for select inputs.  Has anyone had any luck with that?  When a change an existing field with a working fetch from select to checkbox or radio, the fetch still runs but nothing happens in the form -- no checkbox or radio items show up.

[Angelo S. - Dominion Resources Angelo S. - Dominion Resources]

James,

I have finally gotten around to testing this and have successfully connected ServiceDesigner to the external datasource.   I can now execute SQL statements and retrieve table info, but when I refresh the service, nothing displays on the form (just an empty multi select or dropdown).   What else do I need to do to get this to work?   Any additional dictionary configuration?   Please help!!

Thanks, Angelo

[James Fuller]

Hi Angelo,

Have you checked your logs for any database connection feedback?

Try looking in:

<RC_Install_Dir>\logs\jboss_out.log

or

<RC_Install_Dir>\jboss-3.2.3\server\default\log\server.log

or

<RC_Install_Dir>\jboss-3.2.3\server\default\deploy\RequestCenter.ear\RequestCenter.war\WEB-INF\cfusion\logs\exception.log

You may find something there that could help.  Just to be sure, the select list is entirely blank, not d

[Angelo S. - Dominion Resources Angelo S. - Dominion Resources]

James,

Sorry, I should have been more clear on the "refresh"...you are right, it was a browser refresh (F5).   I have done all the above and I am still having issues.   I have walked through both the "SQL statement" and the "database table" SourceType and both seem to yield the same results.   When I enter the SQL statement and click "get columns" the key column and display column both populate with the correct column, but when I check the service form...nothing displays (empty single select). 

[James Fuller]

Hi Angelo,

What do you mean by "refresh the service", like F5 the browser?  If so, it sounds like the user credentials on the select list field definition didn't stick.  I've gotten similar results when this happens.

Go into Designer and to the field that is using the select statement to populate the pick list values.  Ensure that the username, password and query are intact.  Then click "get columns" to populate the "key column" and "display column" lists.  Choose the display column for the v

[Angelo S. - Dominion Resources Angelo S. - Dominion Resources]

Thanks guys for your help!    I was still not able to get the SQL functions to work out of ServiceDesigner using the suggestions listed above.  

Error I am getting in Server.log file: 

javax.naming.NameNotFoundException: All_ITRC_Lookup_Tables not bound
 at org.jnp.server.NamingServer.getBinding(NamingServer.java:495)
 at org.jnp.server.NamingServer.getBinding(NamingServer.java:503)
 at org.jnp.server.NamingServer.getObject(NamingServer.java:509)
 at org.jnp.server.NamingServe

[Mihir Mihir]

Hi Angelo,

Give this one a try - Add your datasource information this way in the file : RequestCenter.war/isfcode/rc-core-queries.xml.

<datasource type="Your Database Type" name="Your Database Name specified as in ColdFusion">
    <description></description>
    <server></server>
    <port/>
    <database/>
    <sid/>
    <username/>
    &am

[Angelo S. - Dominion Resources Angelo S. - Dominion Resources]

Figured out my issue...it was a "case sensitive" issue...the file; jndi-name; and DB name all have to match the ColdFusion datasource name.   In my case...it was the jndi-name that did not match.   Thanks everyone for your help!