Advertisement

06.15.2008 at 08:47PM PDT, ID: 23487048
[x]
Attachment Details

I am returning records from my database, (MySQL) but I am getting a series of "System.__ComObject" instead of the data.  What am I missing?

Asked by juliancaldwellomaha in MySQL, .NET

Tags: .NET, Mozilla Firefox and Internet Exporer, System.__ComObject

I am simply returning data from a SQL table.  I am getting a return; however, I am getting "System.__ComObject" returned instead of the data in the table.  What on earth am I missing?  The values are all text values.Start Free Trial 
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:

<%@ Page aspcompat=true  Language="VB" AutoEventWireup="false" CodeFile="read_db.aspx.vb" Inherits="read_db" %>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    
Results of a Simple Database Query
 
 
<%  Dim Connect, ResultSet, Query%>
 
<% 'Now, create a server object which will be a DNS connection %>
 
<%  Connect = Server.CreateObject("ADODB.Connection")%>
 
<% 'Open the connection to the right DSN %>
 
<%  Connect.Open("bellevue_db")
    
    Query = "SELECT * FROM student626"
    
    ResultSet = Connect.Execute(Query)
    
    %>
 
 
       <table width='80%'>
 
        <% Do Until ResultSet.EOF %>
 
          <tr align='center'>
 
            <% For i = 0 To ResultSet.Fields.Count - 1 %>
 
              <td>
 
                <%=ResultSet.Fields(i)%>
 
              </td>
 
            <% Next %>
 
          </tr>
 
        <%
          ResultSet.MoveNext
          Loop
        %>
 
      </table>
 
 
 
 
 
</body>
 
 
</body>
</html>
 
Keywords: I am returning records from my databa…
Title
1 Connecting to Simply from SQL 2005
2 Recovering MySQL Data
3 MySQL Alter table
4 How to i get this new installed version …
5 mysql join question
6 Using mysql's JOIN
 
Loading Advertisement...
 
[+][-]06.16.2008 at 01:40AM PDT, ID: 21791707

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.16.2008 at 10:04AM PDT, ID: 21795458

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.16.2008 at 11:54AM PDT, ID: 21796328

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: MySQL, .NET
Tags: .NET, Mozilla Firefox and Internet Exporer, System.__ComObject
Sign Up Now!
Solution Provided By: TomasHelgi
Participating Experts: 1
Solution Grade: B
 
 
[+][-]06.16.2008 at 11:58AM PDT, ID: 21796363

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.16.2008 at 03:30PM PDT, ID: 21798106

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628