It seems that you have two entries in the products table for the same
fg_number, one with the values:
'SPKR,CM8HD', 'FG00914', '8,HIGH DEFINITION,CEILING MNT LOUDSPEAKER'
And a second one with the same fg_number but in this case with a
lowercase F.
'', 'fg00914', ''
Is this rigth?
Please, if
Hello everybody,
I have a next problem to get a query working.
I have some tables. A User has Phone numbers and Calls associated with
each phone.
# Example: All the calls of the user number 1
SELECT
Call.*
FROM
User, Phone, Call
WHERE
Phone.User=1 AND
Hello,
I am developing an aplication where I need format the date for inserting
into mySQL.
With DATE_FORMAT I can format the mySQL date to my date, but I haven't
found a good way to format my date to the mySQL date.
My format is 'dd-mm-' and to convert it to '-mm-dd' I'm using
the
Hello,
I am developing an aplication where I need format the date for
inserting into mySQL.
=what language is your application written in?
=dn
The application is written in Java, but the problem is that the module
where the dates for the DB are managed is an open source framework and
Hi,
I have a similar problem (with phones calls) but I would like to select
only those elements that have less than a number.
Using the previous example, is like selecting only those interest elements
that have less that 5 members associated.
Something like this (obviously this doesn't work)