🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: chile.comp.programacion
Article #217

Re: Donde esta el error

#217
From: Pelao Despistao
Date: Wed, 16 Feb 2011 21:56
40 lines
2530 bytes
No debiese dar problemas salvo que los caracteres " sean comillas dobles y
no dos comillas simples.

Saludos.

"Sting"  escribi� en el mensaje de noticias:ijhaov$vll$1@news.nivel5.cl...

CREATE TABLE `restaurantes` (
`restaurante_ID` mediumint(3) NOT NULL auto_increment,
`restaurante_long` varchar(30) NOT NULL default '0',
`restaurante_lat` varchar(30) NOT NULL default '0',
`restaurante_nombre` varchar(50) NOT NULL default ",
`restaurante_coment` text NOT NULL,
`restaurante_marcador` char(2) NOT NULL default ",
`restaurante_cocina` varchar(50) NOT NULL default ",
`restaurante_direcc` varchar(50) NOT NULL default ",
`restaurante_url` varchar(50) NOT NULL default ",
`restaurante_precio` varchar(10) NOT NULL default ",
`restaurante_ip` varchar(15) NOT NULL default ",
`restaurante_month` smallint(2) NOT NULL default '0',
`restaurante_day` smallint(2) NOT NULL default '0',
`restaurante_year` smallint(2) NOT NULL default '0',
`restaurante_time` varchar(15) NOT NULL default ",
`restaurante_valoracion` char(2) NOT NULL default '0',
PRIMARY KEY (`restaurante_ID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;



me tira este error

#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
'�?


Gracias de antemano


...:::: Sting ::::....
Technical Details
Message-ID: <ijhh4t$j7$1@news.nivel5.cl>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!news2.glorb.com!news.kjsl.com!news.nivel5.cl!not-for-mail
References: <ijhaov$vll$1@news.nivel5.cl>

Show Full Headers
Complete Article Headers
X-Google-Thread: 1593cb,84aa32026b491ac1
X-Google-NewGroupId: yes
X-Google-Attributes: gide499fe1f24,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!news2.glorb.com!news.kjsl.com!news.nivel5.cl!not-for-mail
From: "Pelao Despistao" <pelaodespistao[sacaresto]@hotmail.com>
Newsgroups: chile.comp.programacion
Subject: Re: Donde esta el error
Date: Wed, 16 Feb 2011 18:56:45 -0300
Organization: Varios
Lines: 41
Message-ID: <ijhh4t$j7$1@news.nivel5.cl>
References: <ijhaov$vll$1@news.nivel5.cl>
NNTP-Posting-Host: pc-196-143-164-190.cm.vtr.net
Mime-Version: 1.0
Content-Type: text/plain;
 format=flowed;
 charset="iso-8859-1";
 reply-type=response
Content-Transfer-Encoding: 8bit
X-Trace: news.nivel5.cl 1297893341 615 190.164.143.196 (16 Feb 2011 21:55:41 GMT)
X-Complaints-To: news@news.nivel5.cl
NNTP-Posting-Date: Wed, 16 Feb 2011 21:55:41 +0000 (UTC)
In-Reply-To: <ijhaov$vll$1@news.nivel5.cl>
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 15.4.3508.1109
X-MimeOLE: Produced By Microsoft MimeOLE V15.4.3508.1109