| insert query error [message #174601] |
Tue, 21 June 2011 14:43  |
anu
Messages: 2
Registered: October 2010
Karma: 0
|
Junior Member |
|
|
I have a simple insert query in PHP wherein I am trying to write a
record to a MySql database. This is giving me the following Mysql
error. Can you tell me what could be the cause for this error and
how I can rectify it.
Could not successfully run insert query :You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near ''','','','','','','','','','','')'
at line 2
Anu
|
|
|
|
| Re: insert query error [message #174602 is a reply to message #174601] |
Tue, 21 June 2011 14:49  |
Luuk
Messages: 329
Registered: September 2010
Karma: 0
|
Senior Member |
|
|
On 21-06-2011 16:43, anu wrote:
> I have a simple insert query in PHP wherein I am trying to write a
> record to a MySql database. This is giving me the following Mysql
> error. Can you tell me what could be the cause for this error and
> how I can rectify it.
>
> Could not successfully run insert query :You have an error in your SQL
> syntax; check the manual that corresponds to your MySQL server version
> for the right syntax to use near ''','','','','','','','','','','')'
> at line 2
>
> Anu
my crystal ball says:
wrong (too manu, or too few) quotes
But too few info to know for sure.......
--
Luuk
|
|
|
|
| Re: insert query error [message #174603 is a reply to message #174601] |
Tue, 21 June 2011 16:54 |
alvaro.NOSPAMTHANX
Messages: 277
Registered: September 2010
Karma: 0
|
Senior Member |
|
|
El 21/06/2011 16:43, anu escribió/wrote:
> I have a simple insert query in PHP wherein I am trying to write a
> record to a MySql database. This is giving me the following Mysql
> error. Can you tell me what could be the cause for this error and
> how I can rectify it.
>
> Could not successfully run insert query :You have an error in your SQL
> syntax; check the manual that corresponds to your MySQL server version
> for the right syntax to use near ''','','','','','','','','','','')'
> at line 2
The cause of this error message is a syntax error in your SQL code. You
can rectify it by fixing the wrong syntax in your query.
--
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://borrame.com
-- Mi web de humor satinado: http://www.demogracia.com
--
|
|
|
|
| Re: insert query error [message #174604 is a reply to message #174601] |
Tue, 21 June 2011 17:19 |
me
Messages: 192
Registered: September 2010
Karma: 0
|
Senior Member |
|
|
On 6/21/2011 10:43 AM, anu wrote:
> I have a simple insert query in PHP wherein I am trying to write a
> record to a MySql database. This is giving me the following Mysql
> error. Can you tell me what could be the cause for this error and
> how I can rectify it.
>
> Could not successfully run insert query :You have an error in your SQL
> syntax; check the manual that corresponds to your MySQL server version
> for the right syntax to use near ''','','','','','','','','','','')'
> at line 2
>
> Anu
What is the syntax of the actual INSERT query?
|
|
|
|
| Re: insert query error [message #174605 is a reply to message #174601] |
Tue, 21 June 2011 19:48 |
Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma: 0
|
Senior Member |
|
|
On 6/21/2011 10:43 AM, anu wrote:
> I have a simple insert query in PHP wherein I am trying to write a
> record to a MySql database. This is giving me the following Mysql
> error. Can you tell me what could be the cause for this error and
> how I can rectify it.
>
> Could not successfully run insert query :You have an error in your SQL
> syntax; check the manual that corresponds to your MySQL server version
> for the right syntax to use near ''','','','','','','','','','','')'
> at line 2
>
> Anu
You have a MySQL message - ask in a MySQL newsgroup, such as
comp.databases.mysql.
This isn't a PHP problem.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================
|
|
|
|
| Re: insert query error [message #174606 is a reply to message #174605] |
Tue, 21 June 2011 19:58 |
me
Messages: 192
Registered: September 2010
Karma: 0
|
Senior Member |
|
|
On 6/21/2011 3:48 PM, Jerry Stuckle wrote:
> On 6/21/2011 10:43 AM, anu wrote:
>> I have a simple insert query in PHP wherein I am trying to write a
>> record to a MySql database. This is giving me the following Mysql
>> error. Can you tell me what could be the cause for this error and
>> how I can rectify it.
>>
>> Could not successfully run insert query :You have an error in your SQL
>> syntax; check the manual that corresponds to your MySQL server version
>> for the right syntax to use near ''','','','','','','','','','','')'
>> at line 2
>>
>> Anu
>
> You have a MySQL message - ask in a MySQL newsgroup, such as
> comp.databases.mysql.
>
> This isn't a PHP problem.
Even if it shows up in a PHP error log? If I correctly recall, some time
ago you admonished me (correctly I think) to search Google using "PHP
[error message]."
Bill B
|
|
|
|
| Re: insert query error [message #174608 is a reply to message #174606] |
Wed, 22 June 2011 02:15 |
Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma: 0
|
Senior Member |
|
|
On 6/21/2011 3:58 PM, Bill B wrote:
> On 6/21/2011 3:48 PM, Jerry Stuckle wrote:
>> On 6/21/2011 10:43 AM, anu wrote:
>>> I have a simple insert query in PHP wherein I am trying to write a
>>> record to a MySql database. This is giving me the following Mysql
>>> error. Can you tell me what could be the cause for this error and
>>> how I can rectify it.
>>>
>>> Could not successfully run insert query :You have an error in your SQL
>>> syntax; check the manual that corresponds to your MySQL server version
>>> for the right syntax to use near ''','','','','','','','','','','')'
>>> at line 2
>>>
>>> Anu
>>
>> You have a MySQL message - ask in a MySQL newsgroup, such as
>> comp.databases.mysql.
>>
>> This isn't a PHP problem.
>
> Even if it shows up in a PHP error log? If I correctly recall, some time
> ago you admonished me (correctly I think) to search Google using "PHP
> [error message]."
>
> Bill B
It's a MySQL message. PHP knows nothing about SQL.
Just because some application error shows up in the Windows log, should
you ask in a Windows newsgroup?
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================
|
|
|
|
| Re: insert query error [message #174612 is a reply to message #174605] |
Wed, 22 June 2011 10:04 |
Jonathan Stein
Messages: 43
Registered: September 2010
Karma: 0
|
Member |
|
|
Den 21-06-2011 21:48, Jerry Stuckle skrev:
>> Could not successfully run insert query :You have an error in your SQL
>> syntax; check the manual that corresponds to your MySQL server version
>> for the right syntax to use near ''','','','','','','','','','','')'
>> at line 2
>
> You have a MySQL message - ask in a MySQL newsgroup, such as
> comp.databases.mysql.
Why bother a MySQL group? - They won't be able to help from the message.
The solution is to:
1. Add PHP code to print the SQL statement. (PHP task)
2. Realize where the missing or extra ' is. (SQL task - but after step
1, the poster probably won't need help for this step)
3. Fix the PHP code to generate a valid statement. (PHP task)
> This isn't a PHP problem.
We could discuss this, but the solution involves more PHP than SQL, so
this group is fine for the question. The poster should just have
included the code generating the SQL query.
Regards
Jonathan
|
|
|
|
| Re: insert query error [message #174614 is a reply to message #174612] |
Wed, 22 June 2011 10:38 |
Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma: 0
|
Senior Member |
|
|
On 6/22/2011 6:04 AM, Jonathan Stein wrote:
> Den 21-06-2011 21:48, Jerry Stuckle skrev:
>
>>> Could not successfully run insert query :You have an error in your SQL
>>> syntax; check the manual that corresponds to your MySQL server version
>>> for the right syntax to use near ''','','','','','','','','','','')'
>>> at line 2
>>
>> You have a MySQL message - ask in a MySQL newsgroup, such as
>> comp.databases.mysql.
>
> Why bother a MySQL group? - They won't be able to help from the message.
>
Because they will be able to help from the message. And they will give
a GOOD answer.
> The solution is to:
>
> 1. Add PHP code to print the SQL statement. (PHP task)
>
> 2. Realize where the missing or extra ' is. (SQL task - but after step
> 1, the poster probably won't need help for this step)
>
> 3. Fix the PHP code to generate a valid statement. (PHP task)
>
>> This isn't a PHP problem.
>
> We could discuss this, but the solution involves more PHP than SQL, so
> this group is fine for the question. The poster should just have
> included the code generating the SQL query.
>
> Regards
>
> Jonathan
The problem is MySQL. Ask in the correct newsgroup, and you'll get a
good answer. Ask in the wrong newsgroup and you'll get a crap answer -
like the above.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================
|
|
|
|
| Re: insert query error [message #174618 is a reply to message #174614] |
Wed, 22 June 2011 15:03 |
Jonathan Stein
Messages: 43
Registered: September 2010
Karma: 0
|
Member |
|
|
Den 22-06-2011 12:38, Jerry Stuckle skrev:
>> Why bother a MySQL group? - They won't be able to help from the message.
>
> Because they will be able to help from the message.
Do they have better crystal balls than we have?
If you insist, that the question belongs to a MySQL group, at least
guide the user to post the entire SQL statement causing the error. (But
then we are back to a PHP question).
Having the user asking the same question in another group is just a
waste of everybody's time.
Regards
Jonathan
|
|
|
|
| Re: insert query error [message #174619 is a reply to message #174618] |
Wed, 22 June 2011 15:34 |
dougatmilmacdotcom
Messages: 24
Registered: May 2011
Karma: 0
|
Junior Member |
|
|
In article <4e0203bd$0$315$14726298(at)news(dot)sunsite(dot)dk>, jstein(at)image(dot)dk wrote:
> Den 22-06-2011 12:38, Jerry Stuckle skrev:
>
>>> Why bother a MySQL group? - They won't be able to help from the message.
>>
>> Because they will be able to help from the message.
>
> Do they have better crystal balls than we have?
>
> If you insist, that the question belongs to a MySQL group, at least
> guide the user to post the entire SQL statement causing the error. (But
> then we are back to a PHP question).
> Having the user asking the same question in another group is just a
> waste of everybody's time.
It seems to me that the best answer is
"Modify your PHP script so that it displays the entire SQL command. If, after
looking at that, you still don't understand what's wrong with it, ask in
comp.databases.mysql, not here."
|
|
|
|
| Re: insert query error [message #174621 is a reply to message #174618] |
Wed, 22 June 2011 16:08 |
Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma: 0
|
Senior Member |
|
|
On 6/22/2011 11:03 AM, Jonathan Stein wrote:
> Den 22-06-2011 12:38, Jerry Stuckle skrev:
>
>>> Why bother a MySQL group? - They won't be able to help from the message.
>>
>> Because they will be able to help from the message.
>
> Do they have better crystal balls than we have?
>
No, but then they know SQL and will be able to spot the error.
> If you insist, that the question belongs to a MySQL group, at least
> guide the user to post the entire SQL statement causing the error. (But
> then we are back to a PHP question).
> Having the user asking the same question in another group is just a
> waste of everybody's time.
>
> Regards
>
> Jonathan
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================
|
|
|
|
| Re: insert query error [message #174625 is a reply to message #174619] |
Wed, 22 June 2011 19:54 |
Jonathan Stein
Messages: 43
Registered: September 2010
Karma: 0
|
Member |
|
|
Den 22-06-2011 17:34, Doug Miller skrev:
> It seems to me that the best answer is
>
> "Modify your PHP script so that it displays the entire SQL command. If, after
> looking at that, you still don't understand what's wrong with it, ask in
> comp.databases.mysql, not here."
That would be a brilliant answer. I might add: "If your SQL statement
does not look as you expect it to, try posting the code that generates it".
Regards
Jonathan
|
|
|
|
| Re: insert query error [message #174626 is a reply to message #174625] |
Wed, 22 June 2011 21:44 |
dougatmilmacdotcom
Messages: 24
Registered: May 2011
Karma: 0
|
Junior Member |
|
|
In article <4e0247dc$0$305$14726298(at)news(dot)sunsite(dot)dk>, jstein(at)image(dot)dk wrote:
> Den 22-06-2011 17:34, Doug Miller skrev:
>
>> It seems to me that the best answer is
>>
>> "Modify your PHP script so that it displays the entire SQL command. If, after
>> looking at that, you still don't understand what's wrong with it, ask in
>> comp.databases.mysql, not here."
>
> That would be a brilliant answer. I might add: "If your SQL statement
> does not look as you expect it to, try posting the code that generates it".
And: "If you don't know how to modify your PHP script so that it displays the
entire SQL command, *that* question is on-topic here."
|
|
|
|
| Re: insert query error [message #174627 is a reply to message #174621] |
Wed, 22 June 2011 21:46 |
dougatmilmacdotcom
Messages: 24
Registered: May 2011
Karma: 0
|
Junior Member |
|
|
In article <itt42d$pfe$1(at)dont-email(dot)me>, Jerry Stuckle <jstucklex(at)attglobal(dot)net> wrote:
> On 6/22/2011 11:03 AM, Jonathan Stein wrote:
>> Den 22-06-2011 12:38, Jerry Stuckle skrev:
>>
>>>> Why bother a MySQL group? - They won't be able to help from the message.
>>>
>>> Because they will be able to help from the message.
>>
>> Do they have better crystal balls than we have?
>>
>
> No, but then they know SQL and will be able to spot the error.
Not from the fragment of query that the OP posted, they won't.
|
|
|
|
| Re: insert query error [message #174628 is a reply to message #174627] |
Thu, 23 June 2011 03:23 |
Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma: 0
|
Senior Member |
|
|
On 6/22/2011 5:46 PM, Doug Miller wrote:
> In article<itt42d$pfe$1(at)dont-email(dot)me>, Jerry Stuckle<jstucklex(at)attglobal(dot)net> wrote:
>> On 6/22/2011 11:03 AM, Jonathan Stein wrote:
>>> Den 22-06-2011 12:38, Jerry Stuckle skrev:
>>>
>>>> > Why bother a MySQL group? - They won't be able to help from the message.
>>>>
>>>> Because they will be able to help from the message.
>>>
>>> Do they have better crystal balls than we have?
>>>
>>
>> No, but then they know SQL and will be able to spot the error.
>
> Not from the fragment of query that the OP posted, they won't.
You'd be surprised how much a *competent* MySQL programmer knows!
Unlike most of the MySQL hackers in this newsgroup....
Ask in the right place, you get a good answer. Ask in the wrong place
and you get a crap answer, as is shown here (over and over).
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================
|
|
|
|
| Re: insert query error [message #174633 is a reply to message #174628] |
Thu, 23 June 2011 11:38 |
dougatmilmacdotcom
Messages: 24
Registered: May 2011
Karma: 0
|
Junior Member |
|
|
In article <itubj7$rdl$1(at)dont-email(dot)me>, Jerry Stuckle <jstucklex(at)attglobal(dot)net> wrote:
> On 6/22/2011 5:46 PM, Doug Miller wrote:
>> In article<itt42d$pfe$1(at)dont-email(dot)me>, Jerry
> Stuckle<jstucklex(at)attglobal(dot)net> wrote:
>>> On 6/22/2011 11:03 AM, Jonathan Stein wrote:
>>>> Den 22-06-2011 12:38, Jerry Stuckle skrev:
>>>>
>>>> >> Why bother a MySQL group? - They won't be able to help from the message.
>>>> >
>>>> > Because they will be able to help from the message.
>>>>
>>>> Do they have better crystal balls than we have?
>>>>
>>>
>>> No, but then they know SQL and will be able to spot the error.
>>
>> Not from the fragment of query that the OP posted, they won't.
>
> You'd be surprised how much a *competent* MySQL programmer knows!
Enough to pinpoint the cause of the problem, from the small fragment posted by
the OP? Yeah, riiiiiight.
|
|
|
|
| Re: insert query error [message #174634 is a reply to message #174633] |
Thu, 23 June 2011 12:41 |
Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma: 0
|
Senior Member |
|
|
On 6/23/2011 7:38 AM, Doug Miller wrote:
> In article<itubj7$rdl$1(at)dont-email(dot)me>, Jerry Stuckle<jstucklex(at)attglobal(dot)net> wrote:
>> On 6/22/2011 5:46 PM, Doug Miller wrote:
>>> In article<itt42d$pfe$1(at)dont-email(dot)me>, Jerry
>> Stuckle<jstucklex(at)attglobal(dot)net> wrote:
>>>> On 6/22/2011 11:03 AM, Jonathan Stein wrote:
>>>> > Den 22-06-2011 12:38, Jerry Stuckle skrev:
>>>> >
>>>> >>> Why bother a MySQL group? - They won't be able to help from the message.
>>>> >>
>>>> >> Because they will be able to help from the message.
>>>> >
>>>> > Do they have better crystal balls than we have?
>>>> >
>>>>
>>>> No, but then they know SQL and will be able to spot the error.
>>>
>>> Not from the fragment of query that the OP posted, they won't.
>>
>> You'd be surprised how much a *competent* MySQL programmer knows!
>
> Enough to pinpoint the cause of the problem, from the small fragment posted by
> the OP? Yeah, riiiiiight.
Better able to pinpoint the problem than you are, obviously. And if
they know more information, they should ask for what they need.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================
|
|
|
|
| Re: insert query error [message #174636 is a reply to message #174634] |
Thu, 23 June 2011 13:34 |
dougatmilmacdotcom
Messages: 24
Registered: May 2011
Karma: 0
|
Junior Member |
|
|
In article <itvc98$d2b$1(at)dont-email(dot)me>, Jerry Stuckle <jstucklex(at)attglobal(dot)net> wrote:
> On 6/23/2011 7:38 AM, Doug Miller wrote:
>> In article<itubj7$rdl$1(at)dont-email(dot)me>, Jerry
> Stuckle<jstucklex(at)attglobal(dot)net> wrote:
>>> On 6/22/2011 5:46 PM, Doug Miller wrote:
>>>> In article<itt42d$pfe$1(at)dont-email(dot)me>, Jerry
>>> Stuckle<jstucklex(at)attglobal(dot)net> wrote:
>>>> > On 6/22/2011 11:03 AM, Jonathan Stein wrote:
>>>> >> Den 22-06-2011 12:38, Jerry Stuckle skrev:
>>>> >>
>>>> >>>> Why bother a MySQL group? - They won't be able to help from the
> message.
>>>> >>>
>>>> >>> Because they will be able to help from the message.
>>>> >>
>>>> >> Do they have better crystal balls than we have?
>>>> >>
>>>> >
>>>> > No, but then they know SQL and will be able to spot the error.
>>>>
>>>> Not from the fragment of query that the OP posted, they won't.
>>>
>>> You'd be surprised how much a *competent* MySQL programmer knows!
>>
>> Enough to pinpoint the cause of the problem, from the small fragment posted
> by
>> the OP? Yeah, riiiiiight.
>
> Better able to pinpoint the problem than you are, obviously. And if
> they know more information, they should ask for what they need.
>
Since you're so smart, then, why don't you tell us exactly where the problem
is?
|
|
|
|
| Re: insert query error [message #174642 is a reply to message #174636] |
Thu, 23 June 2011 16:45 |
Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma: 0
|
Senior Member |
|
|
On 6/23/2011 9:34 AM, Doug Miller wrote:
> In article<itvc98$d2b$1(at)dont-email(dot)me>, Jerry Stuckle<jstucklex(at)attglobal(dot)net> wrote:
>> On 6/23/2011 7:38 AM, Doug Miller wrote:
>>> In article<itubj7$rdl$1(at)dont-email(dot)me>, Jerry
>> Stuckle<jstucklex(at)attglobal(dot)net> wrote:
>>>> On 6/22/2011 5:46 PM, Doug Miller wrote:
>>>> > In article<itt42d$pfe$1(at)dont-email(dot)me>, Jerry
>>>> Stuckle<jstucklex(at)attglobal(dot)net> wrote:
>>>> >> On 6/22/2011 11:03 AM, Jonathan Stein wrote:
>>>> >>> Den 22-06-2011 12:38, Jerry Stuckle skrev:
>>>> >>>
>>>> >>>>> Why bother a MySQL group? - They won't be able to help from the
>> message.
>>>> >>>>
>>>> >>>> Because they will be able to help from the message.
>>>> >>>
>>>> >>> Do they have better crystal balls than we have?
>>>> >>>
>>>> >>
>>>> >> No, but then they know SQL and will be able to spot the error.
>>>> >
>>>> > Not from the fragment of query that the OP posted, they won't.
>>>>
>>>> You'd be surprised how much a *competent* MySQL programmer knows!
>>>
>>> Enough to pinpoint the cause of the problem, from the small fragment posted
>> by
>>> the OP? Yeah, riiiiiight.
>>
>> Better able to pinpoint the problem than you are, obviously. And if
>> they know more information, they should ask for what they need.
>>
> Since you're so smart, then, why don't you tell us exactly where the problem
> is?
As I've said. It's off-topic in this newsgroup.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================
|
|
|
|
| Re: insert query error [message #174646 is a reply to message #174642] |
Thu, 23 June 2011 17:51 |
dougatmilmacdotcom
Messages: 24
Registered: May 2011
Karma: 0
|
Junior Member |
|
|
In article <itvqig$g16$1(at)dont-email(dot)me>, Jerry Stuckle <jstucklex(at)attglobal(dot)net> wrote:
> On 6/23/2011 9:34 AM, Doug Miller wrote:
>> In article<itvc98$d2b$1(at)dont-email(dot)me>, Jerry
> Stuckle<jstucklex(at)attglobal(dot)net> wrote:
>>> On 6/23/2011 7:38 AM, Doug Miller wrote:
>>>> In article<itubj7$rdl$1(at)dont-email(dot)me>, Jerry
>>> Stuckle<jstucklex(at)attglobal(dot)net> wrote:
>>>> > On 6/22/2011 5:46 PM, Doug Miller wrote:
>>>> >> In article<itt42d$pfe$1(at)dont-email(dot)me>, Jerry
>>>> > Stuckle<jstucklex(at)attglobal(dot)net> wrote:
>>>> >>> On 6/22/2011 11:03 AM, Jonathan Stein wrote:
>>>> >>>> Den 22-06-2011 12:38, Jerry Stuckle skrev:
>>>> >>>>
>>>> >>>>>> Why bother a MySQL group? - They won't be able to help from the
>>> message.
>>>> >>>>>
>>>> >>>>> Because they will be able to help from the message.
>>>> >>>>
>>>> >>>> Do they have better crystal balls than we have?
>>>> >>>>
>>>> >>>
>>>> >>> No, but then they know SQL and will be able to spot the error.
>>>> >>
>>>> >> Not from the fragment of query that the OP posted, they won't.
>>>> >
>>>> > You'd be surprised how much a *competent* MySQL programmer knows!
>>>>
>>>> Enough to pinpoint the cause of the problem, from the small fragment posted
>>> by
>>>> the OP? Yeah, riiiiiight.
>>>
>>> Better able to pinpoint the problem than you are, obviously. And if
>>> they know more information, they should ask for what they need.
>>>
>> Since you're so smart, then, why don't you tell us exactly where the problem
>> is?
>
> As I've said. It's off-topic in this newsgroup.
>
Put up or shut up. If it's so easy to pinpoint the error, do it.
Or admit that you're talking through your hat. Again.
|
|
|
|
| Re: insert query error [message #174648 is a reply to message #174628] |
Thu, 23 June 2011 18:39 |
Luuk
Messages: 329
Registered: September 2010
Karma: 0
|
Senior Member |
|
|
On 23-06-2011 05:23, Jerry Stuckle wrote:
> Unlike most of the MySQL hackers in this newsgroup....
Who is complaining here about 'MySQL hackers' ??/
This was supposed to be a place to discuss some PHP stuff....
;)
>
> Ask in the right place, you get a good answer. Ask in the wrong place
> and you get a crap answer, as is shown here (over and over).
Only ask things when you can give enough info to SOLVE the problem....
i.e. if you ask
"how much is the answer?"
then:
nobody will know
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> JDS Computer Training Corp.
> jstucklex(at)attglobal(dot)net
> ==================
--
Luuk
|
|
|
|
| Re: insert query error [message #174650 is a reply to message #174646] |
Thu, 23 June 2011 19:04 |
Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma: 0
|
Senior Member |
|
|
On 6/23/2011 1:51 PM, Doug Miller wrote:
> In article<itvqig$g16$1(at)dont-email(dot)me>, Jerry Stuckle<jstucklex(at)attglobal(dot)net> wrote:
>> On 6/23/2011 9:34 AM, Doug Miller wrote:
>>> In article<itvc98$d2b$1(at)dont-email(dot)me>, Jerry
>> Stuckle<jstucklex(at)attglobal(dot)net> wrote:
>>>> On 6/23/2011 7:38 AM, Doug Miller wrote:
>>>> > In article<itubj7$rdl$1(at)dont-email(dot)me>, Jerry
>>>> Stuckle<jstucklex(at)attglobal(dot)net> wrote:
>>>> >> On 6/22/2011 5:46 PM, Doug Miller wrote:
>>>> >>> In article<itt42d$pfe$1(at)dont-email(dot)me>, Jerry
>>>> >> Stuckle<jstucklex(at)attglobal(dot)net> wrote:
>>>> >>>> On 6/22/2011 11:03 AM, Jonathan Stein wrote:
>>>> >>>>> Den 22-06-2011 12:38, Jerry Stuckle skrev:
>>>> >>>>>
>>>> >>>>>>> Why bother a MySQL group? - They won't be able to help from the
>>>> message.
>>>> >>>>>>
>>>> >>>>>> Because they will be able to help from the message.
>>>> >>>>>
>>>> >>>>> Do they have better crystal balls than we have?
>>>> >>>>>
>>>> >>>>
>>>> >>>> No, but then they know SQL and will be able to spot the error.
>>>> >>>
>>>> >>> Not from the fragment of query that the OP posted, they won't.
>>>> >>
>>>> >> You'd be surprised how much a *competent* MySQL programmer knows!
>>>> >
>>>> > Enough to pinpoint the cause of the problem, from the small fragment posted
>>>> by
>>>> > the OP? Yeah, riiiiiight.
>>>>
>>>> Better able to pinpoint the problem than you are, obviously. And if
>>>> they know more information, they should ask for what they need.
>>>>
>>> Since you're so smart, then, why don't you tell us exactly where the problem
>>> is?
>>
>> As I've said. It's off-topic in this newsgroup.
>>
> Put up or shut up. If it's so easy to pinpoint the error, do it.
>
> Or admit that you're talking through your hat. Again.
It is off-topic in this newsgroup. And now you've run out of arguments
so you have to get into the personal insults. How like you.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================
|
|
|
|
| Re: insert query error [message #174651 is a reply to message #174650] |
Thu, 23 June 2011 20:32 |
dougatmilmacdotcom
Messages: 24
Registered: May 2011
Karma: 0
|
Junior Member |
|
|
In article <iu02o4$cmv$2(at)dont-email(dot)me>, Jerry Stuckle <jstucklex(at)attglobal(dot)net> wrote:
> On 6/23/2011 1:51 PM, Doug Miller wrote:
>> In article<itvqig$g16$1(at)dont-email(dot)me>, Jerry
> Stuckle<jstucklex(at)attglobal(dot)net> wrote:
>>> On 6/23/2011 9:34 AM, Doug Miller wrote:
>>>> In article<itvc98$d2b$1(at)dont-email(dot)me>, Jerry
>>> Stuckle<jstucklex(at)attglobal(dot)net> wrote:
>>>> > On 6/23/2011 7:38 AM, Doug Miller wrote:
>>>> >> In article<itubj7$rdl$1(at)dont-email(dot)me>, Jerry
>>>> > Stuckle<jstucklex(at)attglobal(dot)net> wrote:
>>>> >>> On 6/22/2011 5:46 PM, Doug Miller wrote:
>>>> >>>> In article<itt42d$pfe$1(at)dont-email(dot)me>, Jerry
>>>> >>> Stuckle<jstucklex(at)attglobal(dot)net> wrote:
>>>> >>>>> On 6/22/2011 11:03 AM, Jonathan Stein wrote:
>>>> >>>>>> Den 22-06-2011 12:38, Jerry Stuckle skrev:
>>>> >>>>>>
>>>> >>>>>>>> Why bother a MySQL group? - They won't be able to help from the
>>>> > message.
>>>> >>>>>>>
>>>> >>>>>>> Because they will be able to help from the message.
>>>> >>>>>>
>>>> >>>>>> Do they have better crystal balls than we have?
>>>> >>>>>>
>>>> >>>>>
>>>> >>>>> No, but then they know SQL and will be able to spot the error.
>>>> >>>>
>>>> >>>> Not from the fragment of query that the OP posted, they won't.
>>>> >>>
>>>> >>> You'd be surprised how much a *competent* MySQL programmer knows!
>>>> >>
>>>> >> Enough to pinpoint the cause of the problem, from the small fragment
> posted
>>>> > by
>>>> >> the OP? Yeah, riiiiiight.
>>>> >
>>>> > Better able to pinpoint the problem than you are, obviously. And if
>>>> > they know more information, they should ask for what they need.
>>>> >
>>>> Since you're so smart, then, why don't you tell us exactly where the
> problem
>>>> is?
>>>
>>> As I've said. It's off-topic in this newsgroup.
>>>
>> Put up or shut up. If it's so easy to pinpoint the error, do it.
>>
>> Or admit that you're talking through your hat. Again.
>
> It is off-topic in this newsgroup.
OK, fine -- post your answer in comp.databases.mysql.
Or admit that you were talking through your hat.
|
|
|
|
| Re: insert query error [message #174653 is a reply to message #174651] |
Thu, 23 June 2011 23:23 |
Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma: 0
|
Senior Member |
|
|
On 6/23/2011 4:32 PM, Doug Miller wrote:
> In article<iu02o4$cmv$2(at)dont-email(dot)me>, Jerry Stuckle<jstucklex(at)attglobal(dot)net> wrote:
>> On 6/23/2011 1:51 PM, Doug Miller wrote:
>>> In article<itvqig$g16$1(at)dont-email(dot)me>, Jerry
>> Stuckle<jstucklex(at)attglobal(dot)net> wrote:
>>>> On 6/23/2011 9:34 AM, Doug Miller wrote:
>>>> > In article<itvc98$d2b$1(at)dont-email(dot)me>, Jerry
>>>> Stuckle<jstucklex(at)attglobal(dot)net> wrote:
>>>> >> On 6/23/2011 7:38 AM, Doug Miller wrote:
>>>> >>> In article<itubj7$rdl$1(at)dont-email(dot)me>, Jerry
>>>> >> Stuckle<jstucklex(at)attglobal(dot)net> wrote:
>>>> >>>> On 6/22/2011 5:46 PM, Doug Miller wrote:
>>>> >>>>> In article<itt42d$pfe$1(at)dont-email(dot)me>, Jerry
>>>> >>>> Stuckle<jstucklex(at)attglobal(dot)net> wrote:
>>>> >>>>>> On 6/22/2011 11:03 AM, Jonathan Stein wrote:
>>>> >>>>>>> Den 22-06-2011 12:38, Jerry Stuckle skrev:
>>>> >>>>>>>
>>>> >>>>>>>>> Why bother a MySQL group? - They won't be able to help from the
>>>> >> message.
>>>> >>>>>>>>
>>>> >>>>>>>> Because they will be able to help from the message.
>>>> >>>>>>>
>>>> >>>>>>> Do they have better crystal balls than we have?
>>>> >>>>>>>
>>>> >>>>>>
>>>> >>>>>> No, but then they know SQL and will be able to spot the error.
>>>> >>>>>
>>>> >>>>> Not from the fragment of query that the OP posted, they won't.
>>>> >>>>
>>>> >>>> You'd be surprised how much a *competent* MySQL programmer knows!
>>>> >>>
>>>> >>> Enough to pinpoint the cause of the problem, from the small fragment
>> posted
>>>> >> by
>>>> >>> the OP? Yeah, riiiiiight.
>>>> >>
>>>> >> Better able to pinpoint the problem than you are, obviously. And if
>>>> >> they know more information, they should ask for what they need.
>>>> >>
>>>> > Since you're so smart, then, why don't you tell us exactly where the
>> problem
>>>> > is?
>>>>
>>>> As I've said. It's off-topic in this newsgroup.
>>>>
>>> Put up or shut up. If it's so easy to pinpoint the error, do it.
>>>
>>> Or admit that you're talking through your hat. Again.
>>
>> It is off-topic in this newsgroup.
>
> OK, fine -- post your answer in comp.databases.mysql.
>
> Or admit that you were talking through your hat.
When the original op posts his question in comp.databases.mysql, someone
will answer it for him.
And once again you run out of valid arguments and have to resort to
personal insults. But we all know that's how you are, Doug.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================
|
|
|
|
| Re: insert query error [message #174654 is a reply to message #174653] |
Thu, 23 June 2011 23:33 |
dougatmilmacdotcom
Messages: 24
Registered: May 2011
Karma: 0
|
Junior Member |
|
|
In article <iu0htd$pve$1(at)dont-email(dot)me>, Jerry Stuckle <jstucklex(at)attglobal(dot)net> wrote:
> On 6/23/2011 4:32 PM, Doug Miller wrote:
>> In article<iu02o4$cmv$2(at)dont-email(dot)me>, Jerry
> Stuckle<jstucklex(at)attglobal(dot)net> wrote:
>>> On 6/23/2011 1:51 PM, Doug Miller wrote:
>>>> In article<itvqig$g16$1(at)dont-email(dot)me>, Jerry
>>> Stuckle<jstucklex(at)attglobal(dot)net> wrote:
>>>> > On 6/23/2011 9:34 AM, Doug Miller wrote:
>>>> >> In article<itvc98$d2b$1(at)dont-email(dot)me>, Jerry
>>>> > Stuckle<jstucklex(at)attglobal(dot)net> wrote:
>>>> >>> On 6/23/2011 7:38 AM, Doug Miller wrote:
>>>> >>>> In article<itubj7$rdl$1(at)dont-email(dot)me>, Jerry
>>>> >>> Stuckle<jstucklex(at)attglobal(dot)net> wrote:
>>>> >>>>> On 6/22/2011 5:46 PM, Doug Miller wrote:
>>>> >>>>>> In article<itt42d$pfe$1(at)dont-email(dot)me>, Jerry
>>>> >>>>> Stuckle<jstucklex(at)attglobal(dot)net> wrote:
>>>> >>>>>>> On 6/22/2011 11:03 AM, Jonathan Stein wrote:
>>>> >>>>>>>> Den 22-06-2011 12:38, Jerry Stuckle skrev:
>>>> >>>>>>>>
>>>> >>>>>>>>>> Why bother a MySQL group? - They won't be able to help from the
>>>> >>> message.
>>>> >>>>>>>>>
>>>> >>>>>>>>> Because they will be able to help from the message.
>>>> >>>>>>>>
>>>> >>>>>>>> Do they have better crystal balls than we have?
>>>> >>>>>>>>
>>>> >>>>>>>
>>>> >>>>>>> No, but then they know SQL and will be able to spot the error.
>>>> >>>>>>
>>>> >>>>>> Not from the fragment of query that the OP posted, they won't.
>>>> >>>>>
>>>> >>>>> You'd be surprised how much a *competent* MySQL programmer knows!
>>>> >>>>
>>>> >>>> Enough to pinpoint the cause of the problem, from the small fragment
>>> posted
>>>> >>> by
>>>> >>>> the OP? Yeah, riiiiiight.
>>>> >>>
>>>> >>> Better able to pinpoint the problem than you are, obviously. And if
>>>> >>> they know more information, they should ask for what they need.
>>>> >>>
>>>> >> Since you're so smart, then, why don't you tell us exactly where the
>>> problem
>>>> >> is?
>>>> >
>>>> > As I've said. It's off-topic in this newsgroup.
>>>> >
>>>> Put up or shut up. If it's so easy to pinpoint the error, do it.
>>>>
>>>> Or admit that you're talking through your hat. Again.
>>>
>>> It is off-topic in this newsgroup.
>>
>> OK, fine -- post your answer in comp.databases.mysql.
>>
>> Or admit that you were talking through your hat.
>
> When the original op posts his question in comp.databases.mysql, someone
> will answer it for him.
Translation from Stuckle-speak to plain English: you can't answer, but you
won't admit it.
>
> And once again you run out of valid arguments and have to resort to
> personal insults. But we all know that's how you are, Doug.
>
That's pretty funny, actually, Jerry -- *you* complaining about someone *else*
being insulting. But we all know that's how you are.
|
|
|
|
| Re: insert query error [message #174655 is a reply to message #174654] |
Fri, 24 June 2011 02:23 |
Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma: 0
|
Senior Member |
|
|
On 6/23/2011 7:33 PM, Doug Miller wrote:
> In article<iu0htd$pve$1(at)dont-email(dot)me>, Jerry Stuckle<jstucklex(at)attglobal(dot)net> wrote:
>> On 6/23/2011 4:32 PM, Doug Miller wrote:
>>> In article<iu02o4$cmv$2(at)dont-email(dot)me>, Jerry
>> Stuckle<jstucklex(at)attglobal(dot)net> wrote:
>>>> On 6/23/2011 1:51 PM, Doug Miller wrote:
>>>> > In article<itvqig$g16$1(at)dont-email(dot)me>, Jerry
>>>> Stuckle<jstucklex(at)attglobal(dot)net> wrote:
>>>> >> On 6/23/2011 9:34 AM, Doug Miller wrote:
>>>> >>> In article<itvc98$d2b$1(at)dont-email(dot)me>, Jerry
>>>> >> Stuckle<jstucklex(at)attglobal(dot)net> wrote:
>>>> >>>> On 6/23/2011 7:38 AM, Doug Miller wrote:
>>>> >>>>> In article<itubj7$rdl$1(at)dont-email(dot)me>, Jerry
>>>> >>>> Stuckle<jstucklex(at)attglobal(dot)net> wrote:
>>>> >>>>>> On 6/22/2011 5:46 PM, Doug Miller wrote:
>>>> >>>>>>> In article<itt42d$pfe$1(at)dont-email(dot)me>, Jerry
>>>> >>>>>> Stuckle<jstucklex(at)attglobal(dot)net> wrote:
>>>> >>>>>>>> On 6/22/2011 11:03 AM, Jonathan Stein wrote:
>>>> >>>>>>>>> Den 22-06-2011 12:38, Jerry Stuckle skrev:
>>>> >>>>>>>>>
>>>> >>>>>>>>>>> Why bother a MySQL group? - They won't be able to help from the
>>>> >>>> message.
>>>> >>>>>>>>>>
>>>> >>>>>>>>>> Because they will be able to help from the message.
>>>> >>>>>>>>>
>>>> >>>>>>>>> Do they have better crystal balls than we have?
>>>> >>>>>>>>>
>>>> >>>>>>>>
>>>> >>>>>>>> No, but then they know SQL and will be able to spot the error.
>>>> >>>>>>>
>>>> >>>>>>> Not from the fragment of query that the OP posted, they won't.
>>>> >>>>>>
>>>> >>>>>> You'd be surprised how much a *competent* MySQL programmer knows!
>>>> >>>>>
>>>> >>>>> Enough to pinpoint the cause of the problem, from the small fragment
>>>> posted
>>>> >>>> by
>>>> >>>>> the OP? Yeah, riiiiiight.
>>>> >>>>
>>>> >>>> Better able to pinpoint the problem than you are, obviously. And if
>>>> >>>> they know more information, they should ask for what they need.
>>>> >>>>
>>>> >>> Since you're so smart, then, why don't you tell us exactly where the
>>>> problem
>>>> >>> is?
>>>> >>
>>>> >> As I've said. It's off-topic in this newsgroup.
>>>> >>
>>>> > Put up or shut up. If it's so easy to pinpoint the error, do it.
>>>> >
>>>> > Or admit that you're talking through your hat. Again.
>>>>
>>>> It is off-topic in this newsgroup.
>>>
>>> OK, fine -- post your answer in comp.databases.mysql.
>>>
>>> Or admit that you were talking through your hat.
>>
>> When the original op posts his question in comp.databases.mysql, someone
>> will answer it for him.
>
> Translation from Stuckle-speak to plain English: you can't answer, but you
> won't admit it.
>>
>> And once again you run out of valid arguments and have to resort to
>> personal insults. But we all know that's how you are, Doug.
>>
> That's pretty funny, actually, Jerry -- *you* complaining about someone *else*
> being insulting. But we all know that's how you are.
And once again you run out of valid arguments and have to resort to
personal insults. But we all know that's how you are, Doug.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]