Too Many Columns in rowset

[slr22]

I'm not exactly sure where I should be posting this question, but I'll start out posting it here. I'm writing an asp page and it is connected to a database using SQL 2000. There needs to be more then 255 fields on the page, to be exact there are are 320 fields. When I try to run it it give me the error, "Too Many Columns in the rowset". I'm guessing this is because there are more then 255 fields. Is there a way around?

Thanks,
Sandy

 

[palbano]

>> Is there a way around?

You mean a way to make a number that is greater than 255, for instance 260, less than 255? I don't think so.

Now if your columns contain string data you could use SQL concatenation to create less resulting output columns but that would be a major HACK so I don’t recommend it. Instead I recommend redesigning your UI to not have 14 bazillion fields on a single page. What user would want to deal with that anyway. That would make me dizzy then I would probably puke!

“But, that’s just my opinion… I could be wrong.”
-pete

 

[Tarwn]

I would have to agree tht 320 fields seems excessive on a page. You may want to break that down into subpages, perhaps group some of the data by relevance and show only the general fields on one page than have links to see the other groups and pass the information in the querystring of those loops so you can duplicate the query to the db.

-Tarwn _{01010100 01101001 01100101 01110010 01101110 01101111 01101011 00101110 01100011 01101111 01101101}
^{29 3K 10 3D 3L 3J 3K 10 32 35 10 3E 39 33 35 10 3K 3F 10 38 31 3M 35 10 36 3I 35 35 10 3K 39 3D 35 10 1Q 19}
Get better results for your questions: faq333-2924
Frequently Asked ASP Questions: faq333-3048

 

[slr22]

Unfortunitly I need those "14 bizillion" fields on one page. It may seem excessive, but it is a quoting system and there are a lot of different components to a particular quote. The people that I'm doing this for wants it this way....so I have to do it this way. I thought about if there is no way around it I would break up the tables into categories and link the tables to each other by a quote number.

Thanks,
Sandy

 

[Tarwn]

You could do it in two queries, but you would need to name all the fields you want to get back. I am sure if you present them with what the page would look like with 320 fields on it, then present them with an alternative, they will soon realize that there is no way they want to stare at 320 columns of data. No one needs data displayed like that, even if they think they do. I think by showing them how clumsy it would be and how hard it would be to find one piece of data out of the 320 columns, they would readily agree to splitting it into catagories or some other method that would make it more digestible.

-Tarwn _{01010100 01101001 01100101 01110010 01101110 01101111 01101011 00101110 01100011 01101111 01101101}
^{29 3K 10 3D 3L 3J 3K 10 32 35 10 3E 39 33 35 10 3K 3F 10 38 31 3M 35 10 36 3I 35 35 10 3K 39 3D 35 10 1Q 19}
Get better results for your questions: faq333-2924
Frequently Asked ASP Questions: faq333-3048