I have switched a website to employ SQL Server.
Something strange happens to my dataposts in recordsets that i pull out from the database.
Lets say I make the following equiry:
sql = "Select buyerID, admin_rights, companyID, countryID,language,currency,name,address1,address2 ,zip,city from buyers where country_id = 1"
When I print out data using: <%=rs("currency")%> displays data, but let's say <%=rs("name")%> is empty!
At another page, all the post contain data and are shown correctly.
Is there a limit to the maximim lengh of a recordset? Or is the problem that the same page makes to many simultanious database connections?
Anyone who has a explanation to this?