hi flor and paul jsorry 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.
bestpaul 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@xxxxxxxxxxxxxwith 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