jot23 Posted October 21, 2009 Share Posted October 21, 2009 Well... I´m having problems making an Excell Query. I am trying to print on screen the fields but it doesn't works. The problem is that I only can print the numeric fields of the first query´s column (6 fields per row) and when I try to print the alfanumerics fields it doesn´t shows anything.In Excell i have this values:==================440700485800578300585000595100B00400E58700EA37800EA49800EA49900NB00400PA12600594800594900595000But when i display the results it shows this:============================440700485800578300585000595100594800594900595000Can sombody help me please???? Link to comment Share on other sites More sharing options...
justsomeguy Posted October 21, 2009 Share Posted October 21, 2009 You'll need to show your code for anyone to be able to help. Link to comment Share on other sites More sharing options...
jot23 Posted October 22, 2009 Author Share Posted October 22, 2009 You'll need to show your code for anyone to be able to help.Ok sorry, I didnt´t put the code because i thought that wasnt necessary Anyway, here it is:-----------------------------------------------------------------------------------------------------------------set rsXls=ConexionBD.execute("Select * From A1:H725 ")i=1noExisten=""while not rsXls.eof response.Write(rsXls.fields(0)&" "&rsXls.fields(1)&"<br>") rsXls.movenext() wend%><html><body></body></html>-----------------------------------------------------------------------------------------------------------------Excell content:==================440700485800578300585000595100B00400E58700EA37800EA49800EA49900NB00400PA12600594800594900595000Display content:============================440700485800578300585000595100594800594900595000 Link to comment Share on other sites More sharing options...
justsomeguy Posted October 22, 2009 Share Posted October 22, 2009 Try rsXls.fields.item(0).value instead of rsXls.fields(0). Link to comment Share on other sites More sharing options...
jot23 Posted October 26, 2009 Author Share Posted October 26, 2009 Try rsXls.fields.item(0).value instead of rsXls.fields(0).It doesn´t works... :)Anyway thanks for all! Link to comment Share on other sites More sharing options...
justsomeguy Posted October 26, 2009 Share Posted October 26, 2009 If the column contains text values, change the column format to be text. If the column is formatted as a number column it will only return number values. Link to comment Share on other sites More sharing options...
dsonesuk Posted October 27, 2009 Share Posted October 27, 2009 I don't think that will work, it is an issue with mixed data types within a column, which formatting the cells won't correct.when reading data from the column the data type is determined by the majority of data type within it, the minority will return as null, or empty values. if the data type is equal then numeric values will take precedence over text.try with text data making the majority of the column content, it should now show all numeric values as empty while displaying all text values. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.