J
Jack
Hi,
I have the following Access DDL statment from which I generated a access
table:
CREATE TABLE TEST1
(ID COUNTER,
NAME TEXT(50),
STORAGESPACEASSIGNED TEXT(50)
)
INSERT INTO test1 ( Name, StorageSpaceAssigned )
VALUES ("John Doe", "Kitchen Cabinet");
INSERT INTO test1 ( Name, StorageSpaceAssigned )
VALUES ("Jane Doe", "Apartment's Attic");
INSERT INTO test1 ( Name, StorageSpaceAssigned )
VALUES ("Sam Hugh", "Bedroom Cabinet");
INSERT INTO test1 ( Name, StorageSpaceAssigned )
VALUES ("Tom Jones", "Dining Room's Closet");
INSERT INTO test1 ( Name, StorageSpaceAssigned )
VALUES ("Erica James", "None");
Now I would like to test a asp page using the above data. Here I would like
to display all the rows containing the fields "name" and
"StorageSpaceAssigned". I would like to display the same table twice but in
different format. The first one is a display only table of the above
specification while the latter table should show each of the cells as text
box (otherwise the display would be same as the first table).
The following is the code to generate the two similar tables in a asp page.
CODE:
<% 'The following is code for connecting to the database
myDSN="Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\test.mdb"
set CN=server.createobject("ADODB.Connection")
set rs=server.createobject("ADODB.Recordset")
set rstemp=server.createobject("ADODB.Recordset")
CN.Open myDSN
rstemp.ActiveConnection = CN
rs.ActiveConnection = CN
%>
<%
i = 0
sql01 = "SELECT * from tblTest "
rstemp.open sql01
Response.Write "<TABLE BORDER=1>"
Do while not rstemp.EOF
Response.Write "<TR><TD>" & rstemp("Name") & " </TD>"
Response.Write "<TD>" & rstemp("StorageSpaceAssigned") &
" </TD></TR>"
rstemp.MoveNext
Loop
Response.Write "</TABLE>"
rstemp.Close
'Response.End
rstemp.Open sql01
Do until rstemp.eof
i = i + 1
response.write "<TR>" & vbCRLF
strLink = "<TD WIDTH=1% ><INPUT TYPE='HIDDEN' NAME='ID_" & i & "'
VALUE=" & rstemp("ID") & "></TD>" & vbCRLF
response.write strLink & vbCRLF
strLink = "<TD WIDTH=10% ALIGN=LEFT><INPUT TYPE='text' SIZE=10
NAME='name_" & i & "' VALUE='" & rstemp("Name") & "'></TD>" & vbCRLF
response.write strLink & vbCRLF
strLink = "<TD WIDTH=10% ALIGN=LEFT><INPUT TYPE='text' SIZE=15
NAME='storagespacesssigned_" & i & "' VALUE='" &
rstemp("StorageSpaceAssigned") & "'></TD>" & vbCRLF
response.write strLink & vbCRLF
response.write strLink & vbCRLF
response.write "</TR>" & vbCRLF
rstemp.movenext
loop
rstemp.close
%>
However, the display of the second table is not coming in the same table
format as the first and rather is screwed up. I would like to get an input as
to why this display is getting screwed up. Thanks for any help.
I have the following Access DDL statment from which I generated a access
table:
CREATE TABLE TEST1
(ID COUNTER,
NAME TEXT(50),
STORAGESPACEASSIGNED TEXT(50)
)
INSERT INTO test1 ( Name, StorageSpaceAssigned )
VALUES ("John Doe", "Kitchen Cabinet");
INSERT INTO test1 ( Name, StorageSpaceAssigned )
VALUES ("Jane Doe", "Apartment's Attic");
INSERT INTO test1 ( Name, StorageSpaceAssigned )
VALUES ("Sam Hugh", "Bedroom Cabinet");
INSERT INTO test1 ( Name, StorageSpaceAssigned )
VALUES ("Tom Jones", "Dining Room's Closet");
INSERT INTO test1 ( Name, StorageSpaceAssigned )
VALUES ("Erica James", "None");
Now I would like to test a asp page using the above data. Here I would like
to display all the rows containing the fields "name" and
"StorageSpaceAssigned". I would like to display the same table twice but in
different format. The first one is a display only table of the above
specification while the latter table should show each of the cells as text
box (otherwise the display would be same as the first table).
The following is the code to generate the two similar tables in a asp page.
CODE:
<% 'The following is code for connecting to the database
myDSN="Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\test.mdb"
set CN=server.createobject("ADODB.Connection")
set rs=server.createobject("ADODB.Recordset")
set rstemp=server.createobject("ADODB.Recordset")
CN.Open myDSN
rstemp.ActiveConnection = CN
rs.ActiveConnection = CN
%>
<%
i = 0
sql01 = "SELECT * from tblTest "
rstemp.open sql01
Response.Write "<TABLE BORDER=1>"
Do while not rstemp.EOF
Response.Write "<TR><TD>" & rstemp("Name") & " </TD>"
Response.Write "<TD>" & rstemp("StorageSpaceAssigned") &
" </TD></TR>"
rstemp.MoveNext
Loop
Response.Write "</TABLE>"
rstemp.Close
'Response.End
rstemp.Open sql01
Do until rstemp.eof
i = i + 1
response.write "<TR>" & vbCRLF
strLink = "<TD WIDTH=1% ><INPUT TYPE='HIDDEN' NAME='ID_" & i & "'
VALUE=" & rstemp("ID") & "></TD>" & vbCRLF
response.write strLink & vbCRLF
strLink = "<TD WIDTH=10% ALIGN=LEFT><INPUT TYPE='text' SIZE=10
NAME='name_" & i & "' VALUE='" & rstemp("Name") & "'></TD>" & vbCRLF
response.write strLink & vbCRLF
strLink = "<TD WIDTH=10% ALIGN=LEFT><INPUT TYPE='text' SIZE=15
NAME='storagespacesssigned_" & i & "' VALUE='" &
rstemp("StorageSpaceAssigned") & "'></TD>" & vbCRLF
response.write strLink & vbCRLF
response.write strLink & vbCRLF
response.write "</TR>" & vbCRLF
rstemp.movenext
loop
rstemp.close
%>
However, the display of the second table is not coming in the same table
format as the first and rather is screwed up. I would like to get an input as
to why this display is getting screwed up. Thanks for any help.