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.

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

Network Issues at Outdoor Swimming Pool

Situtation: Two computers Networked together for purposes of printing and tending of money through Centaman Systems.


Problem 1: Computers were not talking.

Solution: Not sure what had happened before I had got there but just made sure they were both plugged in and that the network connections were enabled. All worked then.


Problem 2: Centaman was not loading on slave machine, bringing up an error about "Could not find Computer Destination Address".

Solution: Again, not sure what had happened before me but the computer name had been changed and centaman can not change the computer name it looks for. To fix this, I had changed server computer back to what it was looking for and then it worked.

Payment was a Tim Tam Cornetto. Should try it.

Google and Frames Issue

Problem: The ACOHS Risk Strategies website that I am currently working on has dropped positions on Google as well as there is no link on Google to the home page. The site is based on frames and because the link is not directly to the home page, the site looks incomplete.

Solution: I have researched a lot to find a temporary solution for the time being. I have come across this site:

http://searchenginewatch.com/showPage.html?page=2167901

Which gives a guide to implementing a solution. It first speaks about "noFrame" browsers and how to control that. Also speaks about search engines having great difficulty in reading the site. What I have done that has been spoken about in this article is used the line of JavaScript in each page:

< SCRIPT LANGUAGE="JavaScript" >
< !-- if (top == self) self.location.href = "index.html"; // -- >
< / SCRIPT > 

What this does is ensures that if the page is loaded and has no frames around it, it will link back to the page with links in it.

Not a complete solution but for now, it will do.

Websystems 2: PHP CGI error

Problem: An CGI error kept occuring when inserting data to the database and could not find the problem

Solution: Missed some simple code

oci_free_statement($stmt);

The statement was not closed which created errors. Fairly simple error but may happen again

Websystems 2: PHP and database occuring problem

I had thought that it maybe a good idea to blog what I am doing over and over incorrectly.


When retrieving attributes from the database:

while ($row = oci_fetch_array ($stmt))
{
? >
Breed: < value = "">
< ? echo $row["BREED_NAME"]; ? >
< /option >

Attributes have to be in capitals or else errors occur. My problem is that I write what the attribute of the database case is for which is in lower case.

Problem solved

Websystems 2: PHP Session problem

Problem: I wanted to use sessions for an login so it remembers username and password. i had used the code:

< ? ob_start(); session_start(); ? >

but kept getting errors about already defined header.

Solution: The code was put in the incorrect position. This code needs to be above the html header as I found out after 20mins of pulling my hair out.

Ipod Nano Freeze Alert

Problem- Ipod Nano had frozen with the screen lit up and no ways in communicating or controlling the IPod.

Solution - The way to restart the Ipod is by select the menu and middle button and holding both down for 10 seconds which then fixed the problem

-- Only a small issue but I need something for my blog.

Getting Started

Hello World

Getting started on this blog to help me record all my issues that I have found in my IT career, hopefully helping me out if issues occur again in which I can refer to it. Hopefully you can make sense of my work and it may help you out in solving your issues.

Initially this blog is going to hold issues in my assignment at University. The headings will specify the subject that the problem will occur.

Visit my profile page on http://lukejpocock.googlepages.com

Happy blogging world