TrulyUnusualdotcom wrote:
> Thanks for the help Jerry. You were dead on, in the book it sure looked
> like a period but after looking again sure enough it's a comma. I figured
> it out by comparing some queries for another script on phpfreaks. Thought I
> already posted that I found my answer. Sorry about that.
>
> Does anyone else find PHP.net and mysql.com hard to find what you need or is
> it just a newbie thing?
>
> Thanks again
> Jaks
> http://www.trulyunusual.com
>
> "Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
> news:wIWdnTUF9_NC2crZnZ2dnUVZ_sydnZ2d@comcast.com. ..
>
>>TrulyUnusualdotcom wrote:
>>
>>>First off I am an extreme newbie and I'm following a book to do this.
>>>This is what to book calls for and I have searched all over for the
>>>proper syntax if this is incorrect with no luck.
>>>
>>>I'm using PHPMyAdmin to create this field in the pet table.
>>>ALTER TABLE `pet` ADD `price` DECIMAL( 9.2 ) NOT NULL
>>>
>>>I'm using MySQL 4.0.25 and phpMyAdmin 2.6.4-pl2
>>>I'm also using PHP 5 if that matters.
>>>
>>>here is what I get.
>>>
>>>SQL query:
>>>ALTER TABLE `pet` ADD `price` DECIMAL( 9.2 ) NOT NULL
>>>MySQL said:
>>>#1064 - 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
>>>'9.2) NOT NULL' at line 1
>>>
>>>Just looking for the reasoning behind the error and what I'm missing.
>>>Maybe a good reference for minor syntax items like this would be good. I
>>>had a hell of a time finding anything related at phpmyadmin or php sites.
>>>
>>>Thanks in advance.
>>>Jaks
>>
>>Jaks,
>>
>>That should be (9,2) not (9.2). Comma separator instead of decimal point.
>>
>>It's hard to tell the difference in the manual.
>>
>>
>>--
>>==================
>>Remove the "x" from my email address
>>Jerry Stuckle
>>JDS Computer Training Corp.
>>jstucklex@attglobal.net
>>==================
>
>
>
>
> Posted Via Usenet.com Premium Usenet Newsgroup Services
> ----------------------------------------------------------
> ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
> ----------------------------------------------------------
> http://www.usenet.com
NP, Jaks,
Several of my students have done that, also. It's quite easy to do, even if the
course materials are in larger type - and therefore the difference between a
comma and a period *should* be easier to spot :-).
I'm sure I had the same problem sometime, but unfortunately Babbage isn't still
around to verify that :-).
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================