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 y
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
Call.Phone=P
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 framewor
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
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)
