Advertisement
Advertisement
- 1. angelIII 570,430
- 2. hielo 346,742
- 3. ee_rlee 214,994
- 4. hernst42 206,049
- 5. routinet 202,175
- 6. mankowitz 125,072
- 7. virmaior 117,794
- 8. cedlinx 108,640
- 9. yodercm 94,799
- 10. fibo 89,786
- 11. Ray_Pas... 84,639
- 12. adrpo 80,750
- 13. leannonn 67,530
- 14. logudotcom 66,927
- 15. nplib 62,300
- 16. Nellios 60,570
- 17. paulop1... 59,650
- 18. rowejd 57,089
- 19. teraplane 56,888
- 20. mattaob 55,300
- 21. TomasHelgi 54,810
- 22. Thomasian 54,160
- 23. arnold 53,430
- 24. asvforce 52,850
- 25. psadac 52,690
- 1. angelIII 1,926,269
- 2. todd_far... 1,720,337
- 3. snoyes_jw 765,508
- 4. Raynard7 699,112
- 5. hernst42 564,749
- 6. Squeebee 555,077
- 7. leannonn 446,466
- 8. NovaDeni... 361,834
- 9. hielo 351,342
- 10. akshah123 324,132
- 11. virmaior 310,060
- 12. psadac 307,681
- 13. AdrianSRU 304,702
- 14. routinet 300,380
- 15. yodercm 252,668
- 16. fibo 233,919
- 17. mankowitz 217,294
- 18. ee_rlee 214,994
- 19. ushastry 205,702
- 20. teraplane 184,874
- 21. ldbkutty 184,558
- 22. racek 181,131
- 23. steelseth12 176,495
- 24. VGR 168,741
- 25. gamebits 165,040
| 06.15.2008 at 08:29PM PDT, ID: 23487031 |
|
[x]
Attachment Details
|
||
Having trouble returning query results to an HTML page.
Asked by juliancaldwellomaha in MySQL, .NET
Tags: ASP VP .NET MySQL, Mozilla Firefox and Internet Exporer, {"Operator '&' is not defined for string "" and type 'Field'."}
I am attempting to simply connect to a MySQL database, query it, return the data, and display it on a webpage. Simple enough.
Well, not so lucky so far. I am getting "{"Operator '&' is not defined for string "<tr><td>" and type 'Field'."}" as an error message with my code, which is attached below.
I am new to .NET, so I am sure this is probably a very simple problem, but so far, I have been unable to figure it out. 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:
<%@ 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, Addresses, 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")%>
<% 'Form a SQL query (in this case, get everything from the mytable table) %>
<% Addresses = Connect.Execute("SELECT * From MyTable") %>
If Addresses.EOF Then _
<%Response.Write("<tr><td>No results to display.</td></tr>")%>
Do While Not Addresses.EOF
<%Response.Write("<tr><td>" & Addresses.Fields("Name") & "</td>")%>
<%Response.Write("<td>" & Addresses.Fields("age_Range") & "</td>")%>
<%Response.Write("<td>" & Addresses.Fields("salary_range") & "</td></tr>")%>
Addresses.MoveNext
Loop
%>
</table></body>
</body>
</html>
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628
I am attempting to simply connect to a MySQL database, query it, return the data, and display it on a webpage. Simple enough.
Well, not so lucky so far. I am getting "{"Operator '&' is not defined for string "<tr><td>" and type 'Field'."}" as an error message with my code, which is attached below.
I am new to .NET, so I am sure this is probably a very simple problem, but so far, I have been unable to figure it out. Start Free Trial
Well, not so lucky so far. I am getting "{"Operator '&' is not defined for string "<tr><td>" and type 'Field'."}" as an error message with my code, which is attached below.
I am new to .NET, so I am sure this is probably a very simple problem, but so far, I have been unable to figure it out. 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: |
<%@ 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, Addresses, 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")%>
<% 'Form a SQL query (in this case, get everything from the mytable table) %>
<% Addresses = Connect.Execute("SELECT * From MyTable") %>
If Addresses.EOF Then _
<%Response.Write("<tr><td>No results to display.</td></tr>")%>
Do While Not Addresses.EOF
<%Response.Write("<tr><td>" & Addresses.Fields("Name") & "</td>")%>
<%Response.Write("<td>" & Addresses.Fields("age_Range") & "</td>")%>
<%Response.Write("<td>" & Addresses.Fields("salary_range") & "</td></tr>")%>
Addresses.MoveNext
Loop
%>
</table></body>
</body>
</html>
|
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628