devxlogo

Tip Bank

Checking Browser Locale

Similar to GzipServlet, this tip uses header information for tuningoutput of our servlets; this one allows you to check the header ‘Accept-Language’. If your user has set some language preferences

Hiding SQL Server DE System Tables

Question: The Enterprise Manager (or whatever it’s called now) shows all the systems tables when you navigate down to the tables in a database. How do you hide the system

SQL Application Security

Question: Is there a “best” way to design VB/ASP apps to deal with SQL (7.0) security? For example, in a WAN environment and a Web application where the app needs

Efficiency of SQL Searches

Question: I can’t remember the reason for the efficiency of the SQL query. I thought that the results of the query are sent to a “client,” as opposed to the

Table Query

Question: I have a table below: Name idJohn 40Mary 50Peter 15John 40Peter 15John 40 How can I query to get who appeared most of the times in the table? (In

SQL Right for Visual Basic App?

Question: I am writing a Visual Basic app that is all about a database created in Access 97 with about 500 records. I want to be able to filter things,