








Make Sure Your Application Doesn’t Use Proprietary SQL Extensions
If you want to try to keep your application standards compliant try this application: Mimer ValidatorIt lets you test any SQL query for SQL-92 and SQL-99 compliance. If you do
If you want to try to keep your application standards compliant try this application: Mimer ValidatorIt lets you test any SQL query for SQL-92 and SQL-99 compliance. If you do
To avoid repeating the following lines of code in every ASP page that needs a database connection: {Dim connObjSet connObj = Server.CreateObject(“ADODB.Connection”)connObj.ConnectionString = Session(“ConnectionString”)connObj.Open} You can use an include file,
You can specify an expiration date, using the setMaxTime(int) method of javax.servlet.http.Cookie. Specifying an expiration time of zero will void the cookie, and delete it from the browser. // Expire
The ProductMaster Table is in MSAccess and the productdescription Table is in SQLServer. Create the Example.mdb in C drive and Create the Below table in MDB(MSAccess). ProductMaster(MSAccess)———————–pid ProductName1 maruthi2 MercedesBenz3
By default, cookies are accessible to every HTTP request for the current directory, and any subdirectories. On most Web servers and servlet engines, servlets are located in a special directory.
There is no “IIF” function in SQLSERVER as of VB and Access.For example, say you had a table like this: StudID Subject Marks—— —— ——1 Maths 801 Physics 751 Chemistry
Open Internet Services Manager from the Administrative Tools group.Right-click on your server and select properties. From Master Properties choose WWW Services and click the “Edit…” button. Select the HomeDirectory, and
Suppose that you have the following code: String strObj; if(strObj != null) if(strObj.equals(“something”)){ // } You can use instead “something”.equals(strObj), so you don’t have to test if strObj is null.