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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-04 : 22:25:51
|
| learner68 writes "I went through your FAQs before submitting my question.Recently I created an IIS5.0 asp site using SQL2000 as the backend database. All the SELECT * statements worked fine on the development setup. However, when the site was installed at the client location on a similar setup (where it is being hosted), the SELECT * statements failed to get any results. Replacing the* with an ALL seems to work, but I am confused as to why the query will work on one setup and failon a similar second setup.I will appreciate any kind of help on this.Thanking you,learnerHONEST SUGGESTION: I like your site. But including the "WRAP=VIRTUAL" in the "Your Question"textarea will help users greatly. Lines will automatically wrap down to new ones. Right now, a user has to hit <Enter> to go to a new line. Replace this line:<TEXTAREA cols=65 name=Abstract rows=25></TEXTAREA>with this<TEXTAREA cols=65 name=Abstract rows=25 WRAP=VIRTUAL></TEXTAREA>" |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2002-03-04 : 22:25:51
|
| Sorry I can't help with the SQL part. I'm pretty suprised by that also. As for your suggestion, will that put carriage returns in as it wraps the line? |
 |
|
|
|
|
|
Online SELECT * fails on SQL 2000