Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mikejohnson
Posting Yak Master
153 Posts |
 Posted - 2004-12-14 : 09:51:34
|
| i have a simple query i'm running from asp to return records in sql. in query analyzer, my query returns the results fine. but when trying to show 2 numeric values on my page, the values don't show up. i don't receive an error, and i know my code and field names are correct. any help? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-12-14 : 09:54:02
|
show us the code and the query otherwise jeff might take a look at his crystal ball again and nobody wants that  Go with the flow & have fun! Else fight the flow  |
 |
|
|
mikejohnson
Posting Yak Master
153 Posts |
Posted - 2004-12-14 : 09:57:23
|
| <%rs.open "select * from tblachfiles order by dtcreated",con do while not rs.eof%> <tr> <td align=center><%=rs("intACHFileID")%></td> <td align=center><%=rs("dtcreated")%></td> <td align=center><%=rs("inttransactiontotal")%></td> <td align=center><%=rs("intDebitTransCount")%></td> <td align=center><%=rs("numDebitTotal")%></td> <td align=center><%=rs("intCreditTransCount")%></td> <td align=center><%=rs("numCreditTotal")%></td> </tr> <%rs.movenext loop%> |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-12-14 : 10:04:37
|
| Oh spirits....please show us the way...."OK, don't use SELECT *, and create a stored procedure"Brett8-) |
|
|
|
mikejohnson
Posting Yak Master
153 Posts |
Posted - 2004-12-14 : 10:10:51
|
| I didn't ask you to give me your opinion on my code, i asked you to help with what i have so far. the problem isn't becuase it's not in a sp...... obviously that would be a better solution but it's not the problem. |
|
|
|
mikejohnson
Posting Yak Master
153 Posts |
Posted - 2004-12-14 : 10:11:48
|
| unless that is that numeric values have to be passed through using a sp. but as far as i know, they don't. |
|
|
|
petem
Starting Member
44 Posts |
Posted - 2004-12-14 : 11:38:32
|
| hey,Im sure I read this on a forum the other day - guy ended up removing some brackets from his SQL statement and it worked.Try a full sql statement rather than * |
|
|
|
mikejohnson
Posting Yak Master
153 Posts |
Posted - 2004-12-14 : 11:57:49
|
| that worked........ how weird |
|
|
|
petem
Starting Member
44 Posts |
Posted - 2004-12-14 : 12:09:07
|
| cool :) |
|
|
|
|
|
|
numeric values