Luke's IT Issues and Solutions

XML minInclusive and maxInclusive

2008-03-29T17:41:00.005+11:00

Problem: I originally built a xsd Schema for a xml file. The element I was designing was a "cpostcode" that has a restriction of 2000-7999. This was my code and then the error.

Original Code

<xsd:element name = "cpostcode">
   <xsd:simpletype>
           <xsd:mininclusive value = "2000">
           <xsd:maxinclusive value = "7999">
   </xsd:simpleType>
</xsd:element>

Error was complaining about minInclusive tag.

Solution: A restriction tag is needed for minInclusive and needs a attribute type.

Solution code is as follows

<xsd:element name = "cpostcode">
    <xsd:simpletype>
        <xsd:restriction base="xsd:integer">
            <xsd:mininclusive value = "2000">
            <xsd:maxinclusive value = "7999">
        </xsd:restriction>
    </xsd:simpleType>
</xsd:element>

I added a restriction type with a base of xsd:integer around the minInclusive and maxInclusive tags.

ASP Retrieving Login Name

2008-01-22T19:10:00.000+11:00

Issue: I wanted to retrieve the user name that is currently logged in using Visual Basics in the ASP.NET Environment. I had used the built in logging in system

Solution: Using the following code retrieves the text need.

HttpContext.current.user.identity.name

Note: Thought was important to Blog due to always referring to it.

SQL Confusion

2007-12-23T17:45:00.000+11:00

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

2007-12-17T11:47:00.000+11:00

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

2007-11-13T17:08:00.000+11:00

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

2007-11-13T16:49:00.000+11:00

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

2007-09-24T23:10:00.000+10:00

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

2007-09-24T17:44:00.000+10:00

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

2007-09-24T14:08:00.000+10:00

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

2007-09-18T13:54:00.000+10:00

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

2007-09-04T12:00:00.000+10:00

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