aspdev
asked on
Call to SQL-database from ASP
What is the diffrence in th order I type my filed names when calling the SQL database?
f.i. "SELECT name,ename,phone,text FROM ..."
and "SELECT phone,text,ename,name FROM ..."
and calling them one by one...
Since that is the only way for me to get to the binary field s. All other i can get in the same string...
f.i. "SELECT name,ename,phone,text FROM ..."
and "SELECT phone,text,ename,name FROM ..."
and calling them one by one...
Since that is the only way for me to get to the binary field s. All other i can get in the same string...
ASP/ODBC has a problem with retrieving the content from SQL text (and binary ?) fields. All fields in the select statement that are mentioned after the "text" field won't be retrieved.
ASKER
Ic. Is there any other workaround for this except calling the textfields by them selves?
On another ASP page, I call the same database, some other field but also the text field. And I don't have it place in the end of my call. The thing is that on that cal, I DONT get anny error calls...
Will it help to install IIS4 and SQL server 6.5?
On another ASP page, I call the same database, some other field but also the text field. And I don't have it place in the end of my call. The thing is that on that cal, I DONT get anny error calls...
Will it help to install IIS4 and SQL server 6.5?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Oh, yes, that works ok with IIS3 and SQL 6.5. An upgrade to IIS4 is not needed, but I don't know about upgrading to DQL 6.5, because I have never tried it with a lower version.
Upgrading to IIS4 will upgrade to ASP2.0, and give ASP some more power/possibilities.
Upgrading to IIS4 will upgrade to ASP2.0, and give ASP some more power/possibilities.
ASKER
With your suggestion "SELECT * FROM.." it worked fine. I don't really understand what you mean about how I call the database since I get t to work (though, I have made a connection in global.asa) anyway, I got it to work now. and I guess we'll just have to wait for a new version of ASP or SQL before evrything will work smoothly.
Thanx for answering!
Thanx for answering!