|
| |
|
|
Joe Kauffman
Posts: 204
Joined: 6/9/2004
Status: offline
 |
RE: ASP page not displaying all the data - 10/5/2007 14:31:56
I've looked at using getrows, but since I'm not very proficient with arrays, wouldn't it be a bit cumbersome to try and create an array that would display this many records?
_____________________________
Regards,
Joe Kauffman
|
|
|
|
Joe Kauffman
Posts: 204
Joined: 6/9/2004
Status: offline
|
RE: ASP page not displaying all the data - 10/9/2007 10:23:37
Something is definately out of whack...I created a new database yesterday, and created a simple insert page and can insert to the 5 varchar fields in the table just fine. But I then created a simple page with a recordset and <%= the 5 fields and none of them display.
So it almost seems like it's a problem with SQL?
_____________________________
Regards,
Joe Kauffman
| |
|
|
|
Joe Kauffman
Posts: 204
Joined: 6/9/2004
Status: offline
|
RE: ASP page not displaying all the data - 10/9/2007 11:58:39
Spooky, I think I learned my lesson on the mucky DW crap. I stopped and restared IIS and it seems to have taken care of this latest problem. But I'm still sweating bullets over the original issue. I've spent days working on trying to figure out where the problem is with no luck. It's just strange that I can single out a bunch of the fields and try to just display them by theirselves and the value still won't show.
Thanks fo the help.
_____________________________
Regards,
Joe Kauffman
| |
|
|
|
Joe Kauffman
Posts: 204
Joined: 6/9/2004
Status: offline
|
RE: ASP page not displaying all the data - 10/9/2007 14:15:57
Alright, I'm going to start from scratch again. I have an insert page that inserts into all the rows in the table and works wonderful. It's just displaying their values that isn't working.
Do you think with that many fields that there is a benefit or drawback of doing a select * or doing a select field1, field2 etc?
_____________________________
Regards,
Joe Kauffman
| |
|
|
|
Joe Kauffman
Posts: 204
Joined: 6/9/2004
Status: offline
|
RE: ASP page not displaying all the data - 10/9/2007 16:46:41
I don't want to speak to soon but I think I finally got to the problem. All the comment fields in the page are TEXT type in the db so I removed them from the select clause and removed them from the page. Now the values of the fields are showing! I do need to be able to display them so can I just call them in a seperate recordset?
Thanks again for your help.
_____________________________
Regards,
Joe Kauffman
| |
|
|
|
Joe Kauffman
Posts: 204
Joined: 6/9/2004
Status: offline
|
RE: ASP page not displaying all the data - 10/10/2007 11:21:00
Spooky,
I'm assigning them to variables now but I want to make sure I'm doing this correctly. Does the naming convention matter really? After I call them in the recordset, I'm placing code similar to this after the <head>:
<% usedoilcomm=truckcomm("UsdOilComm")%>
Then <%=usedoilcomm%> in place where it needs to be displayed. Is this the most efficient way to do it?
Thanks again.
_____________________________
Regards,
Joe Kauffman
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
)
k¥ 