RE: Insert ?'s
then you need to fix your filters
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 10:55 AM
To: john
Subject: Re: Insert ?'s
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
sql,query
If you just reply to this message, and include the entire text of it in the
reply, your reply will go through. However, you should
first review the text of the message to make sure it has something to do
with MySQL. Just typing the word MySQL once will be sufficient, for example.
You have written the following:
Insert into Sellers (Logo) values ('images/helilogo.jpg') where Seller_ID =
1;
that is the command that I am attempting to issue, but states the where...
is wrong. What's wrong with that?
John
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Insert ?'s
On Friday 05 April 2002 10:16 am, john wrote:
Insert into Sellers (Logo) values ('images/helilogo.jpg') where Seller_ID =
1;
that is the command that I am attempting to issue, but states the where...
is wrong. What's wrong with that?
It isn't valid SQL. You are, I think, trying to do an update rather than an
insert, though I'm not sure.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Insert ?'s
no, you need to follow the list rules when posting. That's why you see a
lot of posts that have a line at the end that just says
mysql,sql,query
or something similar.
And to answer your question, it appears that you are actually attempting
an UPDATE, not an INSERT? i.e.
UPDATE Sellers
SET Logo = 'images/helilogo.jpg'
WHERE seller_id = 1
-Original Message-
From: john [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 12:17 PM
To: [EMAIL PROTECTED]
Subject: RE: Insert ?'s
then you need to fix your filters
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 10:55 AM
To: john
Subject: Re: Insert ?'s
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
sql,query
If you just reply to this message, and include the entire
text of it in the
reply, your reply will go through. However, you should
first review the text of the message to make sure it has
something to do
with MySQL. Just typing the word MySQL once will be
sufficient, for example.
You have written the following:
Insert into Sellers (Logo) values ('images/helilogo.jpg')
where Seller_ID =
1;
that is the command that I am attempting to issue, but states
the where...
is wrong. What's wrong with that?
John
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Insert ?'s
Then you need to fix your messages so that it will pass thru the filter.
That statement is wrong because INSERT INTO statement inserts a new record
to the table so you can't have a where restriction. If you wanna change the
logo value where seller_ID=1 then use UPDATE TABLE syntax. See:
http://www.mysql.com/doc/U/P/UPDATE.html
Gurhan
-Original Message-
From: john [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 12:17 PM
To: [EMAIL PROTECTED]
Subject: RE: Insert ?'s
then you need to fix your filters
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 10:55 AM
To: john
Subject: Re: Insert ?'s
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
sql,query
If you just reply to this message, and include the entire text of it in the
reply, your reply will go through. However, you should
first review the text of the message to make sure it has something to do
with MySQL. Just typing the word MySQL once will be sufficient, for example.
You have written the following:
Insert into Sellers (Logo) values ('images/helilogo.jpg') where Seller_ID =
1;
that is the command that I am attempting to issue, but states the where...
is wrong. What's wrong with that?
John
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Insert ?'s
do not send me mail
I am not your friend.
Thank you
--- Gregory Junker [EMAIL PROTECTED] a
écrit : no, you need to follow the list rules when
posting.
That's why you see a
lot of posts that have a line at the end that just
says
mysql,sql,query
or something similar.
And to answer your question, it appears that you are
actually attempting
an UPDATE, not an INSERT? i.e.
UPDATE Sellers
SET Logo = 'images/helilogo.jpg'
WHERE seller_id = 1
-Original Message-
From: john [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 12:17 PM
To: [EMAIL PROTECTED]
Subject: RE: Insert ?'s
then you need to fix your filters
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 10:55 AM
To: john
Subject: Re: Insert ?'s
Your message cannot be posted because it appears
to be either spam or
simply off topic to our filter. To bypass the
filter you must include
one of the following words in your message:
sql,query
If you just reply to this message, and include the
entire
text of it in the
reply, your reply will go through. However, you
should
first review the text of the message to make sure
it has
something to do
with MySQL. Just typing the word MySQL once will
be
sufficient, for example.
You have written the following:
Insert into Sellers (Logo) values
('images/helilogo.jpg')
where Seller_ID =
1;
that is the command that I am attempting to issue,
but states
the where...
is wrong. What's wrong with that?
John
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
archive)
To request this thread, e-mail
[EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Insert ?'s
um, I don't know you, I have no idea why you would take such an
attitude, and if you'll look closely, as a rule I send email to the
list, not to individuals. If you don't want emails from me filter me out
or unsubscribe from the list.
-Original Message-
From: de Chateau Thierry Axel [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 1:15 PM
To: Gregory Junker; [EMAIL PROTECTED]
Subject: RE: Insert ?'s
do not send me mail
I am not your friend.
Thank you
--- Gregory Junker [EMAIL PROTECTED] a
écrit : no, you need to follow the list rules when
posting.
That's why you see a
lot of posts that have a line at the end that just
says
mysql,sql,query
or something similar.
And to answer your question, it appears that you are
actually attempting
an UPDATE, not an INSERT? i.e.
UPDATE Sellers
SET Logo = 'images/helilogo.jpg'
WHERE seller_id = 1
-Original Message-
From: john [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 12:17 PM
To: [EMAIL PROTECTED]
Subject: RE: Insert ?'s
then you need to fix your filters
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 10:55 AM
To: john
Subject: Re: Insert ?'s
Your message cannot be posted because it appears
to be either spam or
simply off topic to our filter. To bypass the
filter you must include
one of the following words in your message:
sql,query
If you just reply to this message, and include the
entire
text of it in the
reply, your reply will go through. However, you
should
first review the text of the message to make sure
it has
something to do
with MySQL. Just typing the word MySQL once will
be
sufficient, for example.
You have written the following:
Insert into Sellers (Logo) values
('images/helilogo.jpg')
where Seller_ID =
1;
that is the command that I am attempting to issue,
but states
the where...
is wrong. What's wrong with that?
John
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
archive)
To request this thread, e-mail
[EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Insert ?'s
(and I say again...)
-Original Message-
From: de Chateau Thierry Axel [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 1:15 PM
To: Gregory Junker; [EMAIL PROTECTED]
Subject: RE: Insert ?'s
do not send me mail
I am not your friend.
Thank you
--- Gregory Junker [EMAIL PROTECTED] a
écrit : no, you need to follow the list rules when
posting.
That's why you see a
lot of posts that have a line at the end that just
says
mysql,sql,query
or something similar.
And to answer your question, it appears that you are
actually attempting
an UPDATE, not an INSERT? i.e.
UPDATE Sellers
SET Logo = 'images/helilogo.jpg'
WHERE seller_id = 1
-Original Message-
From: john [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 12:17 PM
To: [EMAIL PROTECTED]
Subject: RE: Insert ?'s
then you need to fix your filters
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Friday, April 05, 2002 10:55 AM
To: john
Subject: Re: Insert ?'s
Your message cannot be posted because it appears
to be either spam or
simply off topic to our filter. To bypass the
filter you must include
one of the following words in your message:
sql,query
If you just reply to this message, and include the
entire
text of it in the
reply, your reply will go through. However, you
should
first review the text of the message to make sure
it has
something to do
with MySQL. Just typing the word MySQL once will
be
sufficient, for example.
You have written the following:
Insert into Sellers (Logo) values
('images/helilogo.jpg')
where Seller_ID =
1;
that is the command that I am attempting to issue,
but states
the where...
is wrong. What's wrong with that?
John
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
archive)
To request this thread, e-mail
[EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
