Display Filed Description, Filed Data Type on ASP Page 
Author Message
 Display Filed Description, Filed Data Type on ASP Page

I am using following code to display Field Name and Field Value from
table.

******************
sqlQuery = "SELECT * FROM tblTableName WHERE ID =" & intRecordID
Set Table = Conn.Execute(sqlQuery)
intFieldCount = Table.Fields.Count - 1

For i = 0 To intFieldCount
        strName = Table(i).Name
        strValue = Table(i).Value

        Response.Write(strName & " : " & strValue & "<br>")
Next
*******************

But beside this I would also like to display Filed Description, Filed
Data Type (Text, Memo, Number) and other Filed Properties (Filed
Size, Default Value, etc)

How can I accomplish this?

Thanks ahead, John.



Mon, 12 Jul 2004 03:15:31 GMT
 Display Filed Description, Filed Data Type on ASP Page

Hi,

Try to use OpenSchema method of ADO connection. It returns
different information about fileds and tables

Val

Quote:
>-----Original Message-----
>I am using following code to display Field Name and Field
Value from
>table.

>******************
>sqlQuery = "SELECT * FROM tblTableName WHERE ID =" &
intRecordID
>Set Table = Conn.Execute(sqlQuery)
>intFieldCount = Table.Fields.Count - 1

>For i = 0 To intFieldCount
>    strName = Table(i).Name
>    strValue = Table(i).Value

>    Response.Write(strName & " : " & strValue & "<br>")
>Next
>*******************

>But beside this I would also like to display Filed
Description, Filed
>Data Type (Text, Memo, Number.) and other Filed
Properties (Filed
>Size, Default Value, etc.)

>How can I accomplish this?

>Thanks ahead, John.
>.



Mon, 12 Jul 2004 03:32:31 GMT
 Display Filed Description, Filed Data Type on ASP Page
Properties, Methods, and Events
http://msdn.microsoft.com/library/

Anything like "Description" might be in the Properties collection but is provider dependent.

--
Michael Harris
Microsoft.MVP.Scripting
--

Quote:

> I am using following code to display Field Name and Field Value from
> table.

> ******************
> sqlQuery = "SELECT * FROM tblTableName WHERE ID =" & intRecordID
> Set Table = Conn.Execute(sqlQuery)
> intFieldCount = Table.Fields.Count - 1

> For i = 0 To intFieldCount
> strName = Table(i).Name
> strValue = Table(i).Value

> Response.Write(strName & " : " & strValue & "<br>")
> Next
> *******************

> But beside this I would also like to display Filed Description, Filed
> Data Type (Text, Memo, Number.) and other Filed Properties (Filed
> Size, Default Value, etc.)

> How can I accomplish this?

> Thanks ahead, John.



Mon, 12 Jul 2004 08:15:34 GMT
 Display Filed Description, Filed Data Type on ASP Page
You will find an very useful tool for OpenSchema at this link,
http://www.adoanywhere.com/download/aaBrowse2_7.zip

--
Michael Collier Bsc (Hons) Comp Sci
ADO Support Tools.
Fully Working 15-Day Trial...
http://www.adoanywhere.com/download/aaBrowse2_7.zip
Home Page
http://www.adoanywhere.com

Quote:
> Hi,

> Try to use OpenSchema method of ADO connection. It returns
> different information about fileds and tables

> Val

> >-----Original Message-----
> >I am using following code to display Field Name and Field
> Value from
> >table.

> >******************
> >sqlQuery = "SELECT * FROM tblTableName WHERE ID =" &
> intRecordID
> >Set Table = Conn.Execute(sqlQuery)
> >intFieldCount = Table.Fields.Count - 1

> >For i = 0 To intFieldCount
> > strName = Table(i).Name
> > strValue = Table(i).Value

> > Response.Write(strName & " : " & strValue & "<br>")
> >Next
> >*******************

> >But beside this I would also like to display Filed
> Description, Filed
> >Data Type (Text, Memo, Number.) and other Filed
> Properties (Filed
> >Size, Default Value, etc.)

> >How can I accomplish this?

> >Thanks ahead, John.
> >.



Mon, 12 Jul 2004 08:42:19 GMT
 Display Filed Description, Filed Data Type on ASP Page
Have you tried the Field properties Description, Type, Size, DefaultValue?

Quote:
> I am using following code to display Field Name and Field Value from
> table.

> ******************
> sqlQuery = "SELECT * FROM tblTableName WHERE ID =" & intRecordID
> Set Table = Conn.Execute(sqlQuery)
> intFieldCount = Table.Fields.Count - 1

> For i = 0 To intFieldCount
> strName = Table(i).Name
> strValue = Table(i).Value

> Response.Write(strName & " : " & strValue & "<br>")
> Next
> *******************

> But beside this I would also like to display Filed Description, Filed
> Data Type (Text, Memo, Number.) and other Filed Properties (Filed
> Size, Default Value, etc.)

> How can I accomplish this?

> Thanks ahead, John.



Thu, 22 Jul 2004 07:52:18 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Access 2000 memo type fields don't display on my ASP pages

2. SQL SERVER data displayed on a ASP Page

3. Problem displaying data from SQL server in an ASP page

4. To retrieve a TIMESTAMP data type field from SQL and display in ASP

5. Text Data Type and ASP Pages

6. How can I import a .txt file in a database with an external file description

7. using IDC and htx files to be displayed on a web page from Access

8. Loading a Text File Through DTS via ASP Page

9. File DSN Connection from ASP page to MS SQL 2000 server

10. find in external file, display in main file

11. NEED: CLIPPER 5 File Chooser that displays first line of files

12. NEED: Clipper 5 file chooser with file tag display


 
Powered by phpBB® Forum Software