|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
|
|||
|
|||
|
Problem with printing out contents of DB to table
I have created an online database for a school project, and everything WAS going fine until today. Whenever i try to output the contents of the DB to a table, it skips a column for some reason and prints it in the next column. I have checked the ASP coding and the HTML coding and i can't seem to find the problem. I have left the code right under this message. If anyone could help it would be greatly appreciated. Thanks.
<% Dim objRS Set objRS = server.CreateObject ("ADODB.Recordset") objRS.Open "Branches", objConn, , , adCmdTable %> <Table width="1209" height="27" border=1> <tr> <td><b>Number</b></td> <td width="77"><B>Branch ID</b></td> <td width="149"><b>Address</b></td> <td width="168"><b>Country</b></td> <td width="77"><b>State</b></td> <td width="117"><b>Suburb/Town</b></td> <td width="76"><b>Post Code/Zip Code</b></td> <td width="134"><b>Head of branch</b></td> <td width="106"><b>Contact number</b></td> <td width="75"><b>Number of employee's</b></td> <td width="102"><b>Items currently stocked</b></td> </tr> <% Do While Not objRS.EOF Response.Write"<tr><td>" & objRS("Number") & "</td>" Response.Write "<td>" & objRS("Branch ID") & "</td>" Response.Write "<td>" & objRS("Address") & "</td>" Response.Write "<td>" & objRS("Country") & "<td>" Response.Write "<td>" & objRS("State") & "</td>" Response.Write "<td>" & objRS("Suburb/Town") & "</td>" Response.Write "<td>" & objRS("Post Code/Zip Code") & "</td>" Response.Write "<td>" & objRS("Head of branch") & "</td>" Response.Write "<td>" & objRS("Contact number") & "</td>" Response.Write "<td>" & objRS("Number of employee's") &"</td>" Response.Write "<td>" & objRS("Items currently stocked") & "</td></tr>" objRS.MoveNext Loop objRS.Close Set objRS = Nothing objConn.Close Set objConn = Nothing %> </table> |
|
#2
|
||||
|
||||
|
I would love to see a screen shot of what it does. Can't see anything wrong. (And can't exactly test it
) |
![]() |
| Viewing: Dev Shed Forums > Programming Languages - More > ASP Programming > Problem with printing out contents of DB to table |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|