[vicsireland] i e 8 rollback again

  • From: "paul halligan" <tigerone@xxxxxxxxxx>
  • To: <vicsireland@xxxxxxxxxxxxx>
  • Date: Sat, 12 Sep 2009 16:59:52 +0100


     hi flor and paul j

sorry to repeat this, but due to 2 administrator accounts on this pc and conflict i am back to i e 8 again.

could one of ye send me that run command that fixed the problem last time round.
 best
paul j----- Original Message ----- From: "Flor Lynch" <florlync@xxxxxx>
 To: <vicsireland@xxxxxxxxxxxxx>
 Sent: Saturday, September 12, 2009 4:09 PM
 Subject: [vicsireland] Re: Using sql with jaws 8


 > Hi,
 > Works here, as stated.
 >
 > http://www.threeschools.com
 >
 > - the word three not the digit.
 >
> ----- Original Message ----- > From: "Gerard Ellis" <gerry.ellis@xxxxxxxxxxxxxxxxxx>
 > To: <vicsireland@xxxxxxxxxxxxx>
 > Sent: Saturday, September 12, 2009 9:34 AM
 > Subject: [vicsireland] Re: Using sql with jaws 8
 >
 >
 >> Hi, Flor,
 >>
 >> I tried 3 times (once for each school - ha ha). Each time I got the
 >> message:
 >>      Internet Explorer cannot display the webpage
 >>
 >>
 >>      Any comments welcome.
 >>
 >>
 >>
 >>
 >>
 >>
 >> Take Care,
 >>
 >> Gerry Ellis
 >>
 >> If you don't know where you're going,
 >> How will you know when you get there?
 >>
>> ----- Original Message ----- >>>From: "Flor Lynch" <florlync@xxxxxx>
 >> To: <vicsireland@xxxxxxxxxxxxx>
 >> Sent: Saturday, September 12, 2009 3:00 AM
 >> Subject: [vicsireland] Re: Using sql with jaws 8
 >>
 >>
 >>> Gerry,
 >>>
 >>> it does exist, actually.  Go there.  the reason I checked it out was
 >>> because I was curious and had thought it was a possible error.  .
 >>> And it does offer many tutorials.
 >>>
>>> ----- Original Message ----- >>> From: "Gerard Ellis" <gerry.ellis@xxxxxxxxxxxxxxxxxx>
 >>> To: <vicsireland@xxxxxxxxxxxxx>
 >>> Sent: Friday, September 11, 2009 9:13 PM
 >>> Subject: [vicsireland] Re: Using sql with jaws 8
 >>>
 >>>
 >>>> Hi, Michael
 >>>>
 >>>> I'm afraid that www.threeschools.com does not exist.
 >>>>
 >>>> Did you mean the tutorial section of the Worldwide Web Consortium
 >>>> site?
 >>>> www.w3schools.com
 >>>>
 >>>>
 >>>>
 >>>>
 >>>>
 >>>>
 >>>>
 >>>> Take Care,
 >>>>
 >>>> Gerry Ellis
 >>>>
 >>>> If you don't know where you're going,
 >>>> How will you know when you get there?
 >>>>
>>>> ----- Original Message ----- >>>>>From: "Michael Lavin" <michael.lavin@xxxxxxxxxxxxxxx>
 >>>> To: <vicsireland@xxxxxxxxxxxxx>
 >>>> Sent: Thursday, September 10, 2009 11:50 AM
 >>>> Subject: [vicsireland] Re: Using sql with jaws 8
 >>>>
 >>>>
 >>>>> Hello Mairead
 >>>>>
 >>>>> To add to Tony's very good advice, have a look at the SQL tutorial
 >>>>> on http://www.threeschools.com
 >>>>>
 >>>>> In fact anyone out there interested in skilling up on computer
 >>>>> languages would be well advised to have a look at this website -
 >>>>> it's full of brilliant tutorials.
 >>>>>
 >>>>> Regards and good luck.
 >>>>>
 >>>>> Michael
 >>>>> -----Original message-----
 >>>>> From: Tony.G.Murray@xxxxxx
 >>>>> Date: Thu, 10 Sep 2009 09:55:01 +0100
 >>>>> To: vicsireland@xxxxxxxxxxxxx
 >>>>> Subject: [vicsireland] Re: Using sql with jaws 8
 >>>>>
 >>>>>> Hi Mairead,
 >>>>>>
 >>>>>> Microsoft Access is a nice place to start.  It is a friendly self
 >>>>>> contained little Relational Database Management System.
 >>>>>>
 >>>>>> Microsoft Access (and most other Relational DBMS') are made up of
 >>>>>> similar
 >>>>>> concepts.  In my original mail, when I discussed Microsoft SQL
 >>>>>> Server I
 >>>>>> described the two main ways of manipulating the Database and it's
 >>>>>> contents; through SQL, and with the visual tools.  Well, with
 >>>>>> Microsoft
 >>>>>> Access the same rules apply.  The tools just have different names!
 >>>>>> In
 >>>>>> addition, there are all manner of friendly little Wizards which
 >>>>>> help you
 >>>>>> to create Queries, just like that.
 >>>>>>
 >>>>>> The following is from memory... and a pretty sozzled one at that.
 >>>>>> Things
 >>>>>> have a habit of changing names down the years and the versions,
 >>>>>> but I
 >>>>>> reckon the concepts are largely the same.
 >>>>>>
 >>>>>> As far as I know in Microsoft Access you can type SQL Code in to
 >>>>>> the
 >>>>>> 'Query View'.  This is equivalent to the 'Query Analyser' I
 >>>>>> described in
 >>>>>> Microsoft SQL Server.  It is basically a text editor so it is easy
 >>>>>> to use
 >>>>>> with Jaws.  There'll be a run button somewhere, and maybe even a
 >>>>>> 'Parse'
 >>>>>> button which will check your SQL Code for errors... Always handy!
 >>>>>>
 >>>>>> The equivalent Visual Tool in Microsoft Access is called something
 >>>>>> like
 >>>>>> the 'Query Design Grid'.  This could produce a challenge or two
 >>>>>> with Jaws,
 >>>>>> I am not sure.  It's been many years since I've even seen an
 >>>>>> Access
 >>>>>> Database.  I guess things like your Jaws Version and the version
 >>>>>> of Access
 >>>>>> you're using will play a part here.  In the good old days when I
 >>>>>> used
 >>>>>> Access I had no problem with the Query Design View.
 >>>>>> Unfortunately, that
 >>>>>> is all I remember, aside from the fact that there were many
 >>>>>> helpful
 >>>>>> Wizards available to speed things up.  In addition, there are
 >>>>>> bound to be
 >>>>>> Jaws Scripts out there to further simplify the Query Design View
 >>>>>> in
 >>>>>> Access, maybe these were the ones you spoke about originally?
 >>>>>>
 >>>>>> However, the brilliant news is, that if you are good with SQL
 >>>>>> Programming,
 >>>>>> you probably won't have to use the Visual Tools; everything you
 >>>>>> can do by
 >>>>>> dragging and dropping etc can be achieved through good old
 >>>>>> fashioned raw
 >>>>>> SQL Code typed in to the Query View as described above.
 >>>>>>
 >>>>>> There are lots of different sources online to learn basic SQL
 >>>>>> Programming,
 >>>>>> so it might be an idea for you to get a step ahead of the game
 >>>>>> before
 >>>>>> starting the module.
 >>>>>>
 >>>>>> Best wishes,
 >>>>>>
 >>>>>> Tony Murray
 >>>>>>
 >>>>>> Internet Solutions,
 >>>>>> AIB Enterprise Systems & Technology,
 >>>>>> Block B0,
 >>>>>> AIB Bankcentre,
 >>>>>> Ballsbridge,
 >>>>>> Dublin 4.
 >>>>>>
 >>>>>> T: +353 (0) 164 13801
 >>>>>> E: tony.g.murray@xxxxxx
 >>>>>>
 >>>>>>
 >>>>>>
 >>>>>>
 >>>>>>
 >>>>>> Mairead O Mahony <maireadomahony@xxxxxxxxx>
 >>>>>> Sent by: vicsireland-bounce@xxxxxxxxxxxxx
 >>>>>> 09/09/2009 20:01
 >>>>>> Please respond to vicsireland
 >>>>>>
 >>>>>>         To:     vicsireland@xxxxxxxxxxxxx
 >>>>>>         cc:
 >>>>>>         Subject:        [vicsireland] Re: Using sql with jaws 8
 >>>>>>
 >>>>>>
 >>>>>>
 >>>>>>
 >>>>>> Hi all
 >>>>>> Thanks to everyone who replied to my email about using sql with
 >>>>>> jaws.
 >>>>>> At the moment I am checking out what Gui we will be using.  As far
 >>>>>> as
 >>>>>> I am aware we will be using Sql with Microsoft access but I need
 >>>>>> to
 >>>>>> get that confirmed.  Any other suggestions are greatly
 >>>>>> appreciated.
 >>>>>>
 >>>>>> Thanks in advance
 >>>>>> Mairead
 >>>>>>
 >>>>>> On 9/9/09, Tony.G.Murray@xxxxxx <Tony.G.Murray@xxxxxx> wrote:
 >>>>>> > Hi Mairead,
 >>>>>> >
 >>>>>> > "I am using jaws 8 and would appreciate it if anyone could let
 >>>>>> > me know
 >>>>>> for
 >>>>>> > definit if sql works with jaws.  "
 >>>>>> >
 >>>>>> > SQL (Structured Query Language) is a computer language used for
 >>>>>> > manipulating relational Databases and their contents.  Like a
 >>>>>> > lot of
 >>>>>> > computer programming languages, it is simply text which is
 >>>>>> > interpreted
 >>>>>> by
 >>>>>> > the machine.  So in that sense, yes SQL definitely works with
 >>>>>> > Jaws.
 >>>>>> >
 >>>>>> > Now then, SQL is often used in conjunction with a relational
 >>>>>> > DBMS
 >>>>>> > (Database Management System), which is basically an environment
 >>>>>> > in which
 >>>>>> > your relational database and the tools you use to manage/access
 >>>>>> > it are
 >>>>>> > living.  There are lots of very widely used DBMS', like Oracle,
 >>>>>> > SQL
 >>>>>> > Server, MySQL, the list goes on and on and on.  A lesser DBMS is
 >>>>>> > Microsoft's Access, but this wouldn't be considered an
 >>>>>> > enterprise DBMS;
 >>>>>> it
 >>>>>> > is limited in the data it can store.  It's a nice way to learn
 >>>>>> Relational
 >>>>>> > Database methodologies etc, and is probably used behind some
 >>>>>> > smaller web
 >>>>>> > applications or in small office environments, but that's about
 >>>>>> > it.
 >>>>>> >
 >>>>>> > When you say 'SQL' could you possibly be referring to SQL
 >>>>>> > Server? This
 >>>>>> is
 >>>>>> > Microsoft's bigger DBMS, which is often just called 'SQL'.  This
 >>>>>> > is a
 >>>>>> > pretty crazy way to refer to something like SQL Server, but
 >>>>>> > that's
 >>>>>> > unfortunately computing... init! For the rest of this mail, when
 >>>>>> > I say
 >>>>>> SQL
 >>>>>> > I mean the computer language, and when I say SQL Server, I
 >>>>>> > mean...
 >>>>>> you've
 >>>>>> > guessed it, SQL Server the Relational Database Management
 >>>>>> > System!
 >>>>>> >
 >>>>>> > If you are indeed talking about Microsoft SQL Server, the news
 >>>>>> > is good.
 >>>>>> > I've used SQL Server 97/2000/2005 in my time.  The SQL Server
 >>>>>> > Tools
 >>>>>> (which
 >>>>>> > are part of the DBMS) allow you to do everything you could
 >>>>>> > possibly want
 >>>>>> > to do with a Database, or the data stored within one.
 >>>>>> >
 >>>>>> > There are two major ways of accessing the Microsoft SQL Server
 >>>>>> > Database.
 >>>>>> > One is through SQL (and I mean the computer language remember),
 >>>>>> > and the
 >>>>>> > other is through a visual interface.
 >>>>>> >
 >>>>>> > SQL can be typed out in an editor provided as part of SQL
 >>>>>> > Server, and
 >>>>>> > executed against your database.  This is very very accessible
 >>>>>> > and easy
 >>>>>> to
 >>>>>> > use... AS easy as Notepad! The editor contained within SQL
 >>>>>> > Server to do
 >>>>>> > this is called 'Query Analyser', or something similar depending
 >>>>>> > on the
 >>>>>> > version of SQL Server you're using.
 >>>>>> >
 >>>>>> > The other way is through the visual tool, called 'Enterprise
 >>>>>> > Manager' or
 >>>>>> > 'Management Studio', again depending on the version of SQL
 >>>>>> > Server you're
 >>>>>> > working with.  This allows you to do everything you can do
 >>>>>> > through SQL
 >>>>>> and
 >>>>>> > more, without having to actually know the language.  It too is
 >>>>>> > pretty
 >>>>>> > accessible, when you get to know the environment.  It's mainly
 >>>>>> > tree
 >>>>>> views,
 >>>>>> > lists, menus... All the normal stuff Microsoft has got us all so
 >>>>>> > used
 >>>>>> to.
 >>>>>> >
 >>>>>> > "I would also appreciate it if someone could
 >>>>>> > let me know if I need to download scripts to increase the
 >>>>>> > functionality
 >>>>>> of
 >>>>>> > Sql."
 >>>>>> >
 >>>>>> > To be honest, I didn't know there were scripts available... but
 >>>>>> > that's
 >>>>>> no
 >>>>>> > surprise! I'm not so well up on Jaws, even though I use it every
 >>>>>> > day. If
 >>>>>> > there are scripts available, and you are talking about SQL
 >>>>>> > Server, I'm
 >>>>>> > sure someone on here can help you to install them.
 >>>>>> >
 >>>>>> > All the above assumes that when you say 'SQL', you mean
 >>>>>> > Microsoft's SQL
 >>>>>> > Server.  However, if you're not talking about SQL Server, I
 >>>>>> > think you'll
 >>>>>> > be safe enough when it comes to programming in SQL (the
 >>>>>> > language). Once
 >>>>>> > you know how to write SQL, you'll be able to access and use most
 >>>>>> > Relational DBMS', like Oracle, Microsoft SQL Server, MySQL, all
 >>>>>> > those.
 >>>>>> SQL
 >>>>>> > is simply a language used to access all sorts of relational
 >>>>>> > databases...
 >>>>>> > Kind of like a skeleton key! You can get in to any relational
 >>>>>> > database
 >>>>>> if
 >>>>>> > you've a bit of SQL knowledge.  Beautiful huh?
 >>>>>> >
 >>>>>> > To finish, I'll say that SQL is a nice language to learn.  It
 >>>>>> > looks very
 >>>>>> > much like English; it is based on a bunch of keywords, some
 >>>>>> > logical
 >>>>>> > operators, and that's about it.
 >>>>>> >
 >>>>>> > For example, let's say you have a table in your database called
 >>>>>> > UserInformationTable containing names and addresses.... The SQL
 >>>>>> > to show
 >>>>>> > you all the names in that table might look something like:
 >>>>>> > SELECT FirstName, LastName FROM UserInformationTable;
 >>>>>> >
 >>>>>> > Not bad eh?
 >>>>>> >
 >>>>>> > Best wishes,
 >>>>>> >
 >>>>>> > Tony Murray
 >>>>>> >
 >>>>>> > Internet Solutions,
 >>>>>> > AIB Enterprise Systems & Technology,
 >>>>>> > Block B0,
 >>>>>> > AIB Bankcentre,
 >>>>>> > Ballsbridge,
 >>>>>> > Dublin 4.
 >>>>>> >
 >>>>>> > T: +353 (0) 164 13801
 >>>>>> > E: tony.g.murray@xxxxxx
 >>>>>> >
 >>>>>> > ===========================================================
 >>>>>> > The vicsireland mailing list
 >>>>>> >
 >>>>>> > To unsubscribe at any time send a mail to:
 >>>>>> >
 >>>>>> > vicsireland-request@xxxxxxxxxxxxx
 >>>>>> >
 >>>>>> > with the word "unsubscribe", without the quotes in the subject
 >>>>>> > of the
 >>>>>> > message.
 >>>>>> >
 >>>>>> > To contact the moderator send mail to:
 >>>>>> >
 >>>>>> > tim.j.culhane@xxxxxxxxx
 >>>>>> >
 >>>>>> > For mor information on the Visually Impaired Computer Society
 >>>>>> > visit:
 >>>>>> >
 >>>>>> > http://www.vicsireland.org
 >>>>>> >
 >>>>>> >
 >>>>>> ===========================================================
 >>>>>> The vicsireland mailing list
 >>>>>>
 >>>>>> To unsubscribe at any time send a mail to:
 >>>>>>
 >>>>>> vicsireland-request@xxxxxxxxxxxxx
 >>>>>>
 >>>>>> with the word "unsubscribe", without the quotes in the subject of
 >>>>>> the
 >>>>>> message.
 >>>>>>
 >>>>>> To contact the moderator send mail to:
 >>>>>>
 >>>>>> tim.j.culhane@xxxxxxxxx
 >>>>>>
 >>>>>> For mor information on the Visually Impaired Computer Society
 >>>>>> visit:
 >>>>>>
 >>>>>> http://www.vicsireland.org
 >>>>>>
 >>>>>>
 >>>>>>
 >>>>>>
 >>>>>> ******************************************************
 >>>>>> This document is strictly confidential and is intended for use by
 >>>>>> the addressee unless otherwise indicated.
 >>>>>>
 >>>>>> This email has been scanned by an external email security system.
 >>>>>>
 >>>>>> Allied Irish Banks
 >>>>>>
 >>>>>> AIB and AIB Group are registered business names of Allied Irish
 >>>>>> Banks p.l.c. Allied Irish Banks, p.l.c. is regulated by the
 >>>>>> Financial Regulator.  Registered Office: Bankcentre, Ballsbridge,
 >>>>>> Dublin 4. Tel: + 353 1 6600311; Registered in Ireland: Registered
 >>>>>> No. 24173
 >>>>>>
 >>>>>> Please consider the environment before printing this e-mail.
 >>>>>> ******************************************************
 >>>>>>
 >>>>>> ===========================================================
 >>>>>> The vicsireland mailing list
 >>>>>>
 >>>>>> To unsubscribe at any time send a mail to:
 >>>>>>
 >>>>>> vicsireland-request@xxxxxxxxxxxxx
 >>>>>>
 >>>>>> with the word "unsubscribe", without the quotes in the subject of
 >>>>>> the message.
 >>>>>>
 >>>>>> To contact the moderator send mail to:
 >>>>>>
 >>>>>> tim.j.culhane@xxxxxxxxx
 >>>>>>
 >>>>>> For mor information on the Visually Impaired Computer Society
 >>>>>> visit:
 >>>>>>
 >>>>>> http://www.vicsireland.org
 >>>>>>
 >>>>> ===========================================================
 >>>>> The vicsireland mailing list
 >>>>>
 >>>>> To unsubscribe at any time send a mail to:
 >>>>>
 >>>>> vicsireland-request@xxxxxxxxxxxxx
 >>>>>
 >>>>> with the word "unsubscribe", without the quotes in the subject of
 >>>>> the message.
 >>>>>
 >>>>> To contact the moderator send mail to:
 >>>>>
 >>>>> tim.j.culhane@xxxxxxxxx
 >>>>>
 >>>>> For mor information on the Visually Impaired Computer Society
 >>>>> visit:
 >>>>>
 >>>>> http://www.vicsireland.org
 >>>>>
 >>>>>
 >>>>
 >>>>
>>>> -- >>>> I am using the free version of SPAMfighter.
 >>>> We are a community of 6 million users fighting spam.
 >>>> SPAMfighter has removed 898 of my spam emails to date.
 >>>> Get the free SPAMfighter here: http://www.spamfighter.com/len
 >>>>
 >>>> The Professional version does not have this message
 >>>>
 >>>>
 >>>> ===========================================================
 >>>> The vicsireland mailing list
 >>>>
 >>>> To unsubscribe at any time send a mail to:
 >>>>
 >>>> vicsireland-request@xxxxxxxxxxxxx
 >>>>
 >>>> with the word "unsubscribe", without the quotes in the subject of
 >>>> the message.
 >>>> To contact the moderator send mail to:
 >>>>
 >>>> tim.j.culhane@xxxxxxxxx
 >>>>
 >>>> For mor information on the Visually Impaired Computer Society visit:
 >>>>
 >>>> http://www.vicsireland.org
 >>>>
 >>>>
 >>>
 >>> ===========================================================
 >>> The vicsireland mailing list
 >>>
 >>> To unsubscribe at any time send a mail to:
 >>>
 >>> vicsireland-request@xxxxxxxxxxxxx
 >>>
 >>> with the word "unsubscribe", without the quotes in the subject of the
 >>> message.
 >>> To contact the moderator send mail to:
 >>>
 >>> tim.j.culhane@xxxxxxxxx
 >>>
 >>> For mor information on the Visually Impaired Computer Society visit:
 >>>
 >>> http://www.vicsireland.org
 >>>
 >>>
 >>
 >>
>> -- >> I am using the free version of SPAMfighter.
 >> We are a community of 6 million users fighting spam.
 >> SPAMfighter has removed 905 of my spam emails to date.
 >> Get the free SPAMfighter here: http://www.spamfighter.com/len
 >>
 >> The Professional version does not have this message
 >>
 >>
 >> ===========================================================
 >> The vicsireland mailing list
 >>
 >> To unsubscribe at any time send a mail to:
 >>
 >> vicsireland-request@xxxxxxxxxxxxx
 >>
 >> with the word "unsubscribe", without the quotes in the subject of the
 >> message.
 >> To contact the moderator send mail to:
 >>
 >> tim.j.culhane@xxxxxxxxx
 >>
 >> For mor information on the Visually Impaired Computer Society visit:
 >>
 >> http://www.vicsireland.org
 >>
 >>
 >
 > ===========================================================
 > The vicsireland mailing list
 >
 > To unsubscribe at any time send a mail to:
 >
 > vicsireland-request@xxxxxxxxxxxxx
 >
> with the word "unsubscribe", without the quotes in the subject of the message.
 >
 > To contact the moderator send mail to:
 >
 > tim.j.culhane@xxxxxxxxx
 >
 > For mor information on the Visually Impaired Computer Society visit:
 >
 > http://www.vicsireland.org
 >
 >

===========================================================
The vicsireland mailing list

To unsubscribe at any time send a mail to:

vicsireland-request@xxxxxxxxxxxxx

with the word "unsubscribe", without the quotes in the subject of the message.
To contact the moderator send mail to:

tim.j.culhane@xxxxxxxxx

For mor information on the Visually Impaired Computer Society visit:

http://www.vicsireland.org

Other related posts: