[Table (rows 1 columns compid, Companyname, sdate, officename,
officelocation, global1): [compid: [47]] [Companyname: [So]] [sdate:
[2001-07-09 00:00:00.0]] [officename: [ Bert]] [officelocation: [Nyc]]
[global1: [yes]] ]
this example is working but it is printing out all this to the browser when
I only want the name,location and city etc code is below.
<%@page import="java.sql.*,javax.sql.*,allaire.taglib.*"%>
<%@taglib uri="jruntags" prefix="jrun" %>
<!doctype html public"-//w3c/Dtd Html 4.0 Transitional//EN">
<html><head><title>Stroe proc Example</title></head><body>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
Connection con = DriverManager.getConnection("jdbc:odbc:company","sa","");
%>
<jrun:storedproc datasrc="company" id="result">
{call showalloffices}
</jrun:storedproc>
<%=pageContext.getAttribute("result")%>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
