The UK Home Automation Archive

Archive Home
Group Home
Search Archive


Advanced Search

The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024

Latest message you have seen: RE: Amp/speaker recommendations?


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: barcode scanner and automated shopping



James,

No need to step back at all, for this project to work the most important
thing will be getting people to input data.

Even those without a barcode scanner can take part.

Quite simply all that is needed is a list comprising of the barcode and a
product description, and if applicable the size of the product, for example
volume or weight.

Regards

Stuart


----- Original Message -----
From: "James Brett" <jim@xxxxxxx>
To: <ukha_d@xxxxxxx>
Sent: Thursday, October 09, 2003 11:00 PM
Subject: Re: [ukha_d] barcode scanner and automated shopping


> Good point keith - multiple platforms.
>
> To that note (being an MS Only person) I'll step back as there seems
to be
> plenty of people wanting to get
> involved so there shouldnt be a shortage of coders etc.
>
> Jim
>
>
> ----- Original Message -----
> From: "Keith Doxey" <ukha@xxxxxxx>
> To: <ukha_d@xxxxxxx>
> Sent: Thursday, October 09, 2003 7:36 PM
> Subject: RE: [ukha_d] barcode scanner and automated shopping
>
>
> If I might offer a suggestion...
>
> PHP and mySQL
>
> Apache ( optional )
>
> PHP can run under IIS or Apache so will suit Linux and Windows
platforms.
> mySQL is available for Windows or Linux
> Apache is available for Windows or Linux
>
> My laptop currently runs IIS for my ASP/Access applications and Apache
for
> PHP/mySQL applications.
>
> There is a whole load of ready written code for PHP that simplifies
lots
of
> tasks, for instance, PHP Adodb. An application I have just completed
at
work
> will run on Windows, Linux, Solaris and can use Access, mySQL or
Oracle.
> Apart from a few slightly different SQL statements for the Oracle
> implementation the only change I have to make to the PHP code is to
define
> the Database type. In fact, I chop and change so much during
development
> that I have all three specified and just rem out the two unwanted
ones...
>
> global $engine;
> $engine = "access";
> //$engine = "mysql";
> //$engine = "oci8";
>
> Where Oracle requires different SQL I just use an if statement...
>
> if {$engine=="oci8"){
> <oracle specific stuff>
> } else {
> <generic stuff>
> }
>
> Adodb also takes care of all the quoting of variables in the insert or
> update statements you just tell it to add quotes to the variable and
it
adds
> the correct type for the database in use :-)
>
>
> Developing an implementation that can run on various platforms with
gives
> maximun choice for the end user and will work whether you love or hate
> Windows/Linux.
>
> There is another advantage with Apache/PHP/mySQL ...the price is right
:-)
>
>
> Keith
>
> www.diyha.co.uk
> www.kat5.tv
>
>
> > -----Original Message-----
> > From: jim [mailto:jim@xxxxxxx]
> > Sent: 09 October 2003 10:35
> > To: ukha_d@xxxxxxx
> > Subject: Re: [ukha_d] barcode scanner and automated shopping
> >
> >
> > Stuart,
> >
> > Being a Microsoft Technologies person, (dont hate me :-))
> >
> > I was thinkig along the lines of:
> >
> > SQL Server database
> > Web Front end for uploads and downloads and search etc.
> > WebService interface (SOAP/XML etc) to allow apps to direct
> > query the database
> > and add and remove items.
> >
>
>
>
> UKHA 2004: 15th and 16th May 2004
>
> http://www.automatedhome.co.uk
> Post message: ukha_d@xxxxxxx
> Subscribe:  ukha_d-subscribe@xxxxxxx
> Unsubscribe:  ukha_d-unsubscribe@xxxxxxx
> List owner:  ukha_d-owner@xxxxxxx
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>
> UKHA 2004: 15th and 16th May 2004
>
> http://www.automatedhome.co.uk
> Post message: ukha_d@xxxxxxx
> Subscribe:  ukha_d-subscribe@xxxxxxx
> Unsubscribe:  ukha_d-unsubscribe@xxxxxxx
> List owner:  ukha_d-owner@xxxxxxx
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>




Home | Main Index | Thread Index

Comments to the Webmaster are always welcomed, please use this contact form . Note that as this site is a mailing list archive, the Webmaster has no control over the contents of the messages. Comments about message content should be directed to the relevant mailing list.