I have a database with 3 tables, one for nominees, one for voters and one
for votes.
I used the following syntax
SELECT
`tblnominees`.`fldNominee`,
Count(`tblvotes`.`fldVote`) AS `COUNT_OF_VOTES`
FROM
`tblnominees`
Left Join `tblvotes` ON `tblvotes`.`fldVote` = `tblnominees`.`nomineeID`
GROUP BY
`tblnominees`.`fldNominee`
ORDER BY
`COUNT_OF_VOTES` DESC
and this worked well to give a list of all candidates, whether they had
votes or not (it returned '0' for those with no votes, which was perfect).
But now I have a need to use the voters table as well so I can use an ignore
field to exclude voters we don't want to count for whatever reason. I can't
work out how to do the joins so i still get the full list of nominees with
their vote count, whether thay have votes or not.
Could anyone shed some light please?
Appreciate the help.
7  2311 
On Mar 26, 10:16 am, "Dave" <d...@nospam.co.ukwrote:
I have a database with 3 tables, one for nominees, one for voters and one
for votes.
I used the following syntax
SELECT
`tblnominees`.`fldNominee`,
Count(`tblvotes`.`fldVote`) AS `COUNT_OF_VOTES`
FROM
`tblnominees`
Left Join `tblvotes` ON `tblvotes`.`fldVote` = `tblnominees`.`nomineeID`
GROUP BY
`tblnominees`.`fldNominee`
ORDER BY
`COUNT_OF_VOTES` DESC
and this worked well to give a list of all candidates, whether they had
votes or not (it returned '0' for those with no votes, which was perfect).
But now I have a need to use the voters table as well so I can use an ignore
field to exclude voters we don't want to count for whatever reason. I can't
work out how to do the joins so i still get the full list of nominees with
their vote count, whether thay have votes or not.
Could anyone shed some light please?
Appreciate the help.
At a guess:
SELECT nominees.nominee,count(votes.vote) as total FROM voters
LEFT JOIN votes ON votes.voter_id = voters.voter_id
LEFT JOIN nominees ON nominees.nominee_id = votes.nominee_id
WHERE voters.ignore = 0
GROUP BY votes.nominee
ORDER BY total DESC,nominees.nominee
Thanks for the reply, but couldn't get this to work, with no votes present
there were no records from the query, and I was hoping to get all of the
nominees with '0' votes against each name.
"strawberry" <za*******@gmail.comwrote in message
news:11**********************@e65g2000hsc.googlegr oups.com...
On Mar 26, 10:16 am, "Dave" <d...@nospam.co.ukwrote:
>I have a database with 3 tables, one for nominees, one for voters and one
for votes.
I used the following syntax
SELECT
`tblnominees`.`fldNominee`,
Count(`tblvotes`.`fldVote`) AS `COUNT_OF_VOTES`
FROM
`tblnominees`
Left Join `tblvotes` ON `tblvotes`.`fldVote` = `tblnominees`.`nomineeID`
GROUP BY
`tblnominees`.`fldNominee`
ORDER BY
`COUNT_OF_VOTES` DESC
and this worked well to give a list of all candidates, whether they had
votes or not (it returned '0' for those with no votes, which was
perfect).
But now I have a need to use the voters table as well so I can use an
ignore
field to exclude voters we don't want to count for whatever reason. I
can't
work out how to do the joins so i still get the full list of nominees
with
their vote count, whether thay have votes or not.
Could anyone shed some light please?
Appreciate the help.
At a guess:
SELECT nominees.nominee,count(votes.vote) as total FROM voters
LEFT JOIN votes ON votes.voter_id = voters.voter_id
LEFT JOIN nominees ON nominees.nominee_id = votes.nominee_id
WHERE voters.ignore = 0
GROUP BY votes.nominee
ORDER BY total DESC,nominees.nominee
On Mar 27, 10:58 am, "Dave" <d...@nospam.co.ukwrote:
Thanks for the reply, but couldn't get this to work, with no votes present
there were no records from the query, and I was hoping to get all of the
nominees with '0' votes against each name.
"strawberry" <zac.ca...@gmail.comwrote in message
news:11**********************@e65g2000hsc.googlegr oups.com...
On Mar 26, 10:16 am, "Dave" <d...@nospam.co.ukwrote:
I have a database with 3 tables, one for nominees, one for voters and one
for votes.
I used the following syntax
SELECT
`tblnominees`.`fldNominee`,
Count(`tblvotes`.`fldVote`) AS `COUNT_OF_VOTES`
FROM
`tblnominees`
Left Join `tblvotes` ON `tblvotes`.`fldVote` = `tblnominees`.`nomineeID`
GROUP BY
`tblnominees`.`fldNominee`
ORDER BY
`COUNT_OF_VOTES` DESC
and this worked well to give a list of all candidates, whether they had
votes or not (it returned '0' for those with no votes, which was
perfect).
But now I have a need to use the voters table as well so I can use an
ignore
field to exclude voters we don't want to count for whatever reason. I
can't
work out how to do the joins so i still get the full list of nominees
with
their vote count, whether thay have votes or not.
Could anyone shed some light please?
Appreciate the help.
At a guess:
SELECT nominees.nominee,count(votes.vote) as total FROM voters
LEFT JOIN votes ON votes.voter_id = voters.voter_id
LEFT JOIN nominees ON nominees.nominee_id = votes.nominee_id
WHERE voters.ignore = 0
GROUP BY votes.nominee
ORDER BY total DESC,nominees.nominee
Well I was close:
SELECT nominees.nominee, count( votes.nominee_id ) AS total
FROM voters
LEFT JOIN votes ON votes.voter_id = voters.voter_id
LEFT JOIN nominees ON nominees.nominee_id = votes.nominee_id
WHERE voters.ignore =0
GROUP BY votes.nominee_id
ORDER BY total DESC , nominees.nominee
Unfortunately still no go!
"strawberry" <za*******@gmail.comwrote in message
news:11**********************@n76g2000hsh.googlegr oups.com...
On Mar 27, 10:58 am, "Dave" <d...@nospam.co.ukwrote:
>Thanks for the reply, but couldn't get this to work, with no votes
present
there were no records from the query, and I was hoping to get all of the
nominees with '0' votes against each name.
"strawberry" <zac.ca...@gmail.comwrote in message
news:11**********************@e65g2000hsc.googleg roups.com...
On Mar 26, 10:16 am, "Dave" <d...@nospam.co.ukwrote:
I have a database with 3 tables, one for nominees, one for voters and
one
for votes.
>I used the following syntax
>SELECT
`tblnominees`.`fldNominee`,
Count(`tblvotes`.`fldVote`) AS `COUNT_OF_VOTES`
FROM
`tblnominees`
Left Join `tblvotes` ON `tblvotes`.`fldVote` =
`tblnominees`.`nomineeID`
GROUP BY
`tblnominees`.`fldNominee`
ORDER BY
`COUNT_OF_VOTES` DESC
>and this worked well to give a list of all candidates, whether they
had
votes or not (it returned '0' for those with no votes, which was
perfect).
>But now I have a need to use the voters table as well so I can use an
ignore
field to exclude voters we don't want to count for whatever reason. I
can't
work out how to do the joins so i still get the full list of nominees
with
their vote count, whether thay have votes or not.
>Could anyone shed some light please?
>Appreciate the help.
At a guess:
SELECT nominees.nominee,count(votes.vote) as total FROM voters
LEFT JOIN votes ON votes.voter_id = voters.voter_id
LEFT JOIN nominees ON nominees.nominee_id = votes.nominee_id
WHERE voters.ignore = 0
GROUP BY votes.nominee
ORDER BY total DESC,nominees.nominee
Well I was close:
SELECT nominees.nominee, count( votes.nominee_id ) AS total
FROM voters
LEFT JOIN votes ON votes.voter_id = voters.voter_id
LEFT JOIN nominees ON nominees.nominee_id = votes.nominee_id
WHERE voters.ignore =0
GROUP BY votes.nominee_id
ORDER BY total DESC , nominees.nominee
On Mar 28, 12:52 pm, "Dave" <d...@nospam.co.ukwrote:
Unfortunately still no go!
"strawberry" <zac.ca...@gmail.comwrote in message
news:11**********************@n76g2000hsh.googlegr oups.com...
On Mar 27, 10:58 am, "Dave" <d...@nospam.co.ukwrote:
Thanks for the reply, but couldn't get this to work, with no votes
present
there were no records from the query, and I was hoping to get all of the
nominees with '0' votes against each name.
"strawberry" <zac.ca...@gmail.comwrote in message
>news:11**********************@e65g2000hsc.googleg roups.com...
On Mar 26, 10:16 am, "Dave" <d...@nospam.co.ukwrote:
I have a database with 3 tables, one for nominees, one for voters and
one
for votes.
I used the following syntax
SELECT
`tblnominees`.`fldNominee`,
Count(`tblvotes`.`fldVote`) AS `COUNT_OF_VOTES`
FROM
`tblnominees`
Left Join `tblvotes` ON `tblvotes`.`fldVote` =
`tblnominees`.`nomineeID`
GROUP BY
`tblnominees`.`fldNominee`
ORDER BY
`COUNT_OF_VOTES` DESC
and this worked well to give a list of all candidates, whether they
had
votes or not (it returned '0' for those with no votes, which was
perfect).
But now I have a need to use the voters table as well so I can use an
ignore
field to exclude voters we don't want to count for whatever reason. I
can't
work out how to do the joins so i still get the full list of nominees
with
their vote count, whether thay have votes or not.
Could anyone shed some light please?
Appreciate the help.
At a guess:
SELECT nominees.nominee,count(votes.vote) as total FROM voters
LEFT JOIN votes ON votes.voter_id = voters.voter_id
LEFT JOIN nominees ON nominees.nominee_id = votes.nominee_id
WHERE voters.ignore = 0
GROUP BY votes.nominee
ORDER BY total DESC,nominees.nominee
Well I was close:
SELECT nominees.nominee, count( votes.nominee_id ) AS total
FROM voters
LEFT JOIN votes ON votes.voter_id = voters.voter_id
LEFT JOIN nominees ON nominees.nominee_id = votes.nominee_id
WHERE voters.ignore =0
GROUP BY votes.nominee_id
ORDER BY total DESC , nominees.nominee
Given a schema like the one below, the query provided should work fine
(although you might have to retype the
line beginning 'WHERE...'. My machine doesn't like it when I copy and
paste that line for some reason:
CREATE TABLE `nominees` (
`nominee_id` int(11) NOT NULL auto_increment,
`nominee` varchar(25) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`nominee_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci
AUTO_INCREMENT=5 ;
INSERT INTO `nominees` VALUES (1, 'John');
INSERT INTO `nominees` VALUES (2, 'Paul');
INSERT INTO `nominees` VALUES (3, 'George');
INSERT INTO `nominees` VALUES (4, 'Ringo');
CREATE TABLE `voters` (
`voter_id` int(11) NOT NULL auto_increment,
`ignore` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`voter_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci
AUTO_INCREMENT=8 ;
INSERT INTO `voters` VALUES (1, 0);
INSERT INTO `voters` VALUES (2, 0);
INSERT INTO `voters` VALUES (3, 0);
INSERT INTO `voters` VALUES (4, 1);
INSERT INTO `voters` VALUES (5, 1);
INSERT INTO `voters` VALUES (6, 0);
INSERT INTO `voters` VALUES (7, 0);
CREATE TABLE `votes` (
`voter_id` int(11) NOT NULL,
`nominee_id` int(11) NOT NULL,
PRIMARY KEY (`voter_id`,`nominee_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
INSERT INTO `votes` VALUES (1, 1);
INSERT INTO `votes` VALUES (2, 1);
INSERT INTO `votes` VALUES (3, 1);
INSERT INTO `votes` VALUES (4, 2);
INSERT INTO `votes` VALUES (5, 2);
INSERT INTO `votes` VALUES (6, 3);
INSERT INTO `votes` VALUES (7, 4);
That query again:
SELECT nominees.nominee, count( votes.nominee_id ) AS total
FROM voters
LEFT JOIN votes ON votes.voter_id = voters.voter_id
LEFT JOIN nominees ON nominees.nominee_id = votes.nominee_id
WHERE voters.ignore =0
GROUP BY votes.nominee_id
ORDER BY total DESC , nominees.nominee;
Thanks for this, i've just tried it and the result I was expecting (and we
may have crossed wires here) would be John has 3, george has 1, ringo has 1,
and poor old Paul has 0, but Paul doesn't appear in the query result.
Is this possible?
Thanks for your time on this.
"strawberry" <za*******@gmail.comwrote in message
news:11**********************@p15g2000hsd.googlegr oups.com...
On Mar 28, 12:52 pm, "Dave" <d...@nospam.co.ukwrote:
>Unfortunately still no go!
"strawberry" <zac.ca...@gmail.comwrote in message
news:11**********************@n76g2000hsh.googleg roups.com...
On Mar 27, 10:58 am, "Dave" <d...@nospam.co.ukwrote:
Thanks for the reply, but couldn't get this to work, with no votes
present
there were no records from the query, and I was hoping to get all of
the
nominees with '0' votes against each name.
>"strawberry" <zac.ca...@gmail.comwrote in message
>>news:11**********************@e65g2000hsc.google groups.com...
On Mar 26, 10:16 am, "Dave" <d...@nospam.co.ukwrote:
I have a database with 3 tables, one for nominees, one for voters
and
one
for votes.
>I used the following syntax
>SELECT
`tblnominees`.`fldNominee`,
Count(`tblvotes`.`fldVote`) AS `COUNT_OF_VOTES`
FROM
`tblnominees`
Left Join `tblvotes` ON `tblvotes`.`fldVote` =
`tblnominees`.`nomineeID`
GROUP BY
`tblnominees`.`fldNominee`
ORDER BY
`COUNT_OF_VOTES` DESC
>and this worked well to give a list of all candidates, whether they
had
votes or not (it returned '0' for those with no votes, which was
perfect).
>But now I have a need to use the voters table as well so I can use
an
ignore
field to exclude voters we don't want to count for whatever reason.
I
can't
work out how to do the joins so i still get the full list of
nominees
with
their vote count, whether thay have votes or not.
>Could anyone shed some light please?
>Appreciate the help.
At a guess:
SELECT nominees.nominee,count(votes.vote) as total FROM voters
LEFT JOIN votes ON votes.voter_id = voters.voter_id
LEFT JOIN nominees ON nominees.nominee_id = votes.nominee_id
WHERE voters.ignore = 0
GROUP BY votes.nominee
ORDER BY total DESC,nominees.nominee
Well I was close:
SELECT nominees.nominee, count( votes.nominee_id ) AS total
FROM voters
LEFT JOIN votes ON votes.voter_id = voters.voter_id
LEFT JOIN nominees ON nominees.nominee_id = votes.nominee_id
WHERE voters.ignore =0
GROUP BY votes.nominee_id
ORDER BY total DESC , nominees.nominee
Given a schema like the one below, the query provided should work fine
(although you might have to retype the
line beginning 'WHERE...'. My machine doesn't like it when I copy and
paste that line for some reason:
CREATE TABLE `nominees` (
`nominee_id` int(11) NOT NULL auto_increment,
`nominee` varchar(25) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`nominee_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci
AUTO_INCREMENT=5 ;
INSERT INTO `nominees` VALUES (1, 'John');
INSERT INTO `nominees` VALUES (2, 'Paul');
INSERT INTO `nominees` VALUES (3, 'George');
INSERT INTO `nominees` VALUES (4, 'Ringo');
CREATE TABLE `voters` (
`voter_id` int(11) NOT NULL auto_increment,
`ignore` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`voter_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci
AUTO_INCREMENT=8 ;
INSERT INTO `voters` VALUES (1, 0);
INSERT INTO `voters` VALUES (2, 0);
INSERT INTO `voters` VALUES (3, 0);
INSERT INTO `voters` VALUES (4, 1);
INSERT INTO `voters` VALUES (5, 1);
INSERT INTO `voters` VALUES (6, 0);
INSERT INTO `voters` VALUES (7, 0);
CREATE TABLE `votes` (
`voter_id` int(11) NOT NULL,
`nominee_id` int(11) NOT NULL,
PRIMARY KEY (`voter_id`,`nominee_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
INSERT INTO `votes` VALUES (1, 1);
INSERT INTO `votes` VALUES (2, 1);
INSERT INTO `votes` VALUES (3, 1);
INSERT INTO `votes` VALUES (4, 2);
INSERT INTO `votes` VALUES (5, 2);
INSERT INTO `votes` VALUES (6, 3);
INSERT INTO `votes` VALUES (7, 4);
That query again:
SELECT nominees.nominee, count( votes.nominee_id ) AS total
FROM voters
LEFT JOIN votes ON votes.voter_id = voters.voter_id
LEFT JOIN nominees ON nominees.nominee_id = votes.nominee_id
WHERE voters.ignore =0
GROUP BY votes.nominee_id
ORDER BY total DESC , nominees.nominee;
On Mar 28, 1:39 pm, "Dave" <d...@nospam.co.ukwrote:
Thanks for this, i've just tried it and the result I was expecting (and we
may have crossed wires here) would be John has 3, george has 1, ringo has 1,
and poor old Paul has 0, but Paul doesn't appear in the query result.
Is this possible?
Thanks for your time on this.
"strawberry" <zac.ca...@gmail.comwrote in message
news:11**********************@p15g2000hsd.googlegr oups.com...
On Mar 28, 12:52 pm, "Dave" <d...@nospam.co.ukwrote:
Unfortunately still no go!
"strawberry" <zac.ca...@gmail.comwrote in message
>news:11**********************@n76g2000hsh.googleg roups.com...
On Mar 27, 10:58 am, "Dave" <d...@nospam.co.ukwrote:
Thanks for the reply, but couldn't get this to work, with no votes
present
there were no records from the query, and I was hoping to get all of
the
nominees with '0' votes against each name.
"strawberry" <zac.ca...@gmail.comwrote in message
>news:11**********************@e65g2000hsc.googleg roups.com...
On Mar 26, 10:16 am, "Dave" <d...@nospam.co.ukwrote:
I have a database with 3 tables, one for nominees, one for voters
and
one
for votes.
I used the following syntax
SELECT
`tblnominees`.`fldNominee`,
Count(`tblvotes`.`fldVote`) AS `COUNT_OF_VOTES`
FROM
`tblnominees`
Left Join `tblvotes` ON `tblvotes`.`fldVote` =
`tblnominees`.`nomineeID`
GROUP BY
`tblnominees`.`fldNominee`
ORDER BY
`COUNT_OF_VOTES` DESC
and this worked well to give a list of all candidates, whether they
had
votes or not (it returned '0' for those with no votes, which was
perfect).
But now I have a need to use the voters table as well so I can use
an
ignore
field to exclude voters we don't want to count for whatever reason.
I
can't
work out how to do the joins so i still get the full list of
nominees
with
their vote count, whether thay have votes or not.
Could anyone shed some light please?
Appreciate the help.
At a guess:
SELECT nominees.nominee,count(votes.vote) as total FROM voters
LEFT JOIN votes ON votes.voter_id = voters.voter_id
LEFT JOIN nominees ON nominees.nominee_id = votes.nominee_id
WHERE voters.ignore = 0
GROUP BY votes.nominee
ORDER BY total DESC,nominees.nominee
Well I was close:
SELECT nominees.nominee, count( votes.nominee_id ) AS total
FROM voters
LEFT JOIN votes ON votes.voter_id = voters.voter_id
LEFT JOIN nominees ON nominees.nominee_id = votes.nominee_id
WHERE voters.ignore =0
GROUP BY votes.nominee_id
ORDER BY total DESC , nominees.nominee
Given a schema like the one below, the query provided should work fine
(although you might have to retype the
line beginning 'WHERE...'. My machine doesn't like it when I copy and
paste that line for some reason:
CREATE TABLE `nominees` (
`nominee_id` int(11) NOT NULL auto_increment,
`nominee` varchar(25) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`nominee_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci
AUTO_INCREMENT=5 ;
INSERT INTO `nominees` VALUES (1, 'John');
INSERT INTO `nominees` VALUES (2, 'Paul');
INSERT INTO `nominees` VALUES (3, 'George');
INSERT INTO `nominees` VALUES (4, 'Ringo');
CREATE TABLE `voters` (
`voter_id` int(11) NOT NULL auto_increment,
`ignore` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`voter_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci
AUTO_INCREMENT=8 ;
INSERT INTO `voters` VALUES (1, 0);
INSERT INTO `voters` VALUES (2, 0);
INSERT INTO `voters` VALUES (3, 0);
INSERT INTO `voters` VALUES (4, 1);
INSERT INTO `voters` VALUES (5, 1);
INSERT INTO `voters` VALUES (6, 0);
INSERT INTO `voters` VALUES (7, 0);
CREATE TABLE `votes` (
`voter_id` int(11) NOT NULL,
`nominee_id` int(11) NOT NULL,
PRIMARY KEY (`voter_id`,`nominee_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
INSERT INTO `votes` VALUES (1, 1);
INSERT INTO `votes` VALUES (2, 1);
INSERT INTO `votes` VALUES (3, 1);
INSERT INTO `votes` VALUES (4, 2);
INSERT INTO `votes` VALUES (5, 2);
INSERT INTO `votes` VALUES (6, 3);
INSERT INTO `votes` VALUES (7, 4);
That query again:
SELECT nominees.nominee, count( votes.nominee_id ) AS total
FROM voters
LEFT JOIN votes ON votes.voter_id = voters.voter_id
LEFT JOIN nominees ON nominees.nominee_id = votes.nominee_id
WHERE voters.ignore =0
GROUP BY votes.nominee_id
ORDER BY total DESC , nominees.nominee;
Oh yeah, missed that. Also, I just realised that 'ignore' is probably
a reserved word. Enclosing it in back-ticks will sort that out.
Anyway, someone can probably think of a more efficient solution, but
here's a crude way:
SELECT a.nominee_id, a.nominee, IFNULL( b.total, 0 ) total
FROM (
SELECT `nominee_id` , nominees.`nominee`
FROM nominees
)a
LEFT JOIN (
SELECT nominees.`nominee_id` , nominees.`nominee` ,
count( votes.nominee_id ) AS total
FROM voters
LEFT JOIN votes ON votes.`voter_id` = voters.`voter_id`
LEFT JOIN nominees ON nominees.nominee_id = votes.nominee_id
WHERE voters.`ignore` =0
GROUP BY votes.nominee_id
ORDER BY total DESC , nominees.nominee
)b ON a.nominee_id = b.nominee_id; This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Mark |
last post by:
O, woe is me, to have seen what I have seen, see what I see!
(That's Shakespeare for those who were wondering what I'm on about)
I am "having fun" with cookies.
And I wonder if I have...
|
by: Cedric |
last post by:
This is a 3 weeks old problem, but having found a solution (and having
looked for one here, finding only this message), I'm replying now.
From: Jive (someone@microsoft.com)
Subject: Upgrade...
|
by: Angel Cat |
last post by:
Trying to get my jobs to send mail when job fails. Should be easy but
it's giving me headache
Had a whole slew of issues. Outlook is installed with a n outlook
mail profile set up that can...
|
by: Andrew Thompson |
last post by:
- NN 4.78 rendering woes, links at far left -
I am trying to rework an old site, make it valid html
and css, improving the x-browser and 'older browser'
compatibility. My efforts so far, have...
|
by: Arun Bhalla |
last post by:
I'm having some inconsistency problems with my deployment project ("Setup")
and its custom actions ("Installer"). I'm using Visual Studio .NET 2003
(.NET 1.1, no service pack) on Windows XPSP1.
...
|
by: Mark Rae |
last post by:
Hi,
This time, I'm looking for a regular expression which says "the string must
contain exactly seven or exactly eight digits" e.g.
123456 fails
1234567 passes
12345678 passes
123456789...
|
by: Christian Muenscher |
last post by:
Dear group!
The following statement gives me a resultset containing two columns
containing a PersonID:
SELECT *
FROM A
LEFT JOIN B ON A.PersonID=B.PersonID
UNION SELECT *
FROM A
|
by: hdogg |
last post by:
Scope Woes - IF statement nested in WHILE statement -PHP
I have an array $actuals_sum.
<?php
while(conditions)
{
if($i == '24)
{
|
by: bearophileHUGS |
last post by:
Empty Python lists don't know the type of the items it will
contain, so this sounds strange:
0
Because that may be an empty sequence of someobject:
0
In a statically typed language in...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
| |
