Why do need a stored procedure for see the columns in your table?
<cfquery Name="Get_Columns" Datasource="MyData">
Select * from mytable
</cfquery>
<cfoutput>
#Get_Columns.ColumnList#
</cfoutput>
This will give you all the columns in your table
Cfloop around the list you can get all the data too
------
There is a tab for development mapping in Cf Studio, set that to browse you
applications/pages.
and set your database in Cf administrator, Odbc , where you specify your Sql
server database and the other info.
if you running cf locally, to browse or test your application,
http://127.0.0.1/
and your directory under wwwroot...
-----
your last question, columns in stored procedure is not clear....
you normally write a sp for complex data manipulation and you have "IN" and
"Out" parameters where you get your
values back into CF......
----- Original Message -----
From: "Fl�via Montezuma" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, May 21, 2000 2:24 PM
Subject: En: Values from a stored procedure
>
> -----Mensagem Original-----
> De: Fl�via Montezuma <[EMAIL PROTECTED]>
> Para: <[EMAIL PROTECTED]>
> Enviada em: domingo, 21 de maio de 2000 15:18
> Assunto: Re: Values from a stored procedure
>
>
> > Hello ALL!!
> >
> > My name is Fl�via and I am Bright New With Cold Fusion..
> > I am trying to configure cold fusion but I just tried a lot of times wih
> no
> > sucess..
> > Please, someone help me!!
> >
> > I bought the book Cold Fusion Web Development Construction Kit.
> > The problem I've got is:
> >
> > I open the cold fusion studio, write down an script but I cannot
browse!!
> >
> > What should I have to configure??
> >
> > My data source is A2b .
> >
> > Someone to help me throught????????
> >
> > Please!!
> >
> > Fl�via
> >
> >
> >
> > -----Mensagem Original-----
> > De: Ron Anderson <[EMAIL PROTECTED]>
> > Para: Cf-Talk <[EMAIL PROTECTED]>
> > Enviada em: domingo, 21 de maio de 2000 12:31
> > Assunto: Values from a stored procedure
> >
> >
> > > Maybe this is easier than I think:
> > >
> > > How can I show all the fields in a stored procedure?
> > > I'm running SQL7 and the query is 'sp_columns'.
> > > I'd like to display a multi-select box of all the available columns in
a
> > > table...but how?
> > >
> > >
> > > Thanks
> > >
> > >
> >
>
> --------------------------------------------------------------------------
> > ----
> > > Archives: http://www.eGroups.com/list/cf-talk
> > > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
or
> > send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
> > the body.
> > >
> >
>
> --------------------------------------------------------------------------
> ----
> > Archives: http://www.eGroups.com/list/cf-talk
> > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar
> >
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar
>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
