Sunday, December 23, 2007

SQL Confusion

Problem: I have learnt SQL using an Oracle database at university and tried to use the keyword sequence when developing SQL for MSSQL.

Solution: MSSQL does not support Sequence and after some research I found a solution from this article:

http://www.pcbuyersguide.co.za/showthread.php?t=4104

The solution is to use this code

CREATE TABLE [dbo].[Customers] (
[pk_ID] [int] IDENTITY (1, 1) NOT NULL ,
[sValue] [char] (10) NULL ,
[sDesc] [char] (10) NULL ,
[iOrd] [numeric](18, 0) NULL
) ON [PRIMARY]
GO
using Identity will allow a start point and to increment each record that is added to the databse.

Monday, December 17, 2007

Icon not appearing in HTML pages using Inernet Explorer

Problem: Icon not appearing when linking an icon to a HTML page in Internet Explorer but appearing in Firefox

Solution: The code below shows what I had used on the a HTML page:

< rel="icon" href="images/intefaces/riskStrategies40x40.ico" type="image/x-icon">


***Note "link" should appear before "rel"***

After some research, this was the code I ended up using:


< rel="icon" href="riskStrategies40x40.ico">

***Note "link" should appear before "rel"***

The icon must be in the root directory and an absolute address. Also the type was deleted. Not sure of the reasoning why it did not work in the first place but does now in both Internet Explorer and Firefox