also ich spiele grade in Plone mit ein paar Tabellen rum.
Da gibts ja den SQL Befehl:
Code: Alles auswählen
create table name(
id integer,
title varchar,
member varchar,
briefDescription varchar,
projectContext varchar
)
mfg carsten
Code: Alles auswählen
create table name(
id integer,
title varchar,
member varchar,
briefDescription varchar,
projectContext varchar
)
Code: Alles auswählen
id INTEGER NOT NULL
PRIMARY KEY (id)
Code: Alles auswählen
SyntaxError: unexpected token sequence.near :: 't(\n id INTEGER'*' NOT NULL,\n PR' ******************************* current state = 163 expects: ')', ',', ('nomatch1',) current token = ((-6, 'NOT'), 'NOT') (Also, the following error occurred while attempting to render the standard error message, please see the event log for full details: '@@plone')
Code: Alles auswählen
CREATE TABLE name (
id INT NOT NULL AUTO_INCREMENT ,
title VARCHAR( 5 ) NOT NULL ,
PRIMARY KEY (id)
);
Code: Alles auswählen
Site Error
An error was encountered while publishing this resource.
SyntaxError
Sorry, a site error occurred.
Traceback (innermost last):
Module ZPublisher.Publish, line 194, in publish_module_standard
Module Products.PlacelessTranslationService.PatchStringIO, line 34, in new_publish
Module ZPublisher.Publish, line 146, in publish
Module Zope2.App.startup, line 222, in zpublisher_exception_hook
Module ZPublisher.Publish, line 115, in publish
Module ZPublisher.mapply, line 88, in mapply
Module ZPublisher.Publish, line 41, in call_object
Module Shared.DC.ZRDB.DA, line 341, in manage_test
Module Shared.DC.ZRDB.DA, line 318, in manage_test
Module Shared.DC.ZRDB.DA, line 455, in __call__
<SQL at /Plone/portal_skins/custom/newDB/create>
Module Products.ZGadflyDA.db, line 108, in query
Module Products.ZGadflyDA.gadfly.gadfly, line 322, in execute
Module Products.ZGadflyDA.gadfly.kjParser, line 1185, in DoParse1
Module Products.ZGadflyDA.gadfly.kjParser, line 1177, in DoParse
Module Products.ZGadflyDA.gadfly.kjParser, line 842, in GO
Module Products.ZGadflyDA.gadfly.kjParser, line 770, in DoOneReduction
Module Products.ZGadflyDA.gadfly.kjParser, line 826, in ParseError
SyntaxError: unexpected token sequence.near :: 'LE name ( \n id'*' INT NOT NULL A' ******************************* current state = 79 expects: '/', 'AND', 'ORDER', 'INTERSECT', '=', 'DESC', '*', 'FROM', 'ASC', '*', 'INTEGER', 'EXCEPT', 'BETWEEN', '<', 'WHERE', ')', 'GROUP', '-', 'NOT', ';', 'UNION', 'FLOAT', 'VARCHAR', ',', 'HAVING', '>', 'IN', '+', 'OR', 'AS', ('nomatch1',) current token = ((-8, 'user_defined_name'), 'INT') (Also, the following error occurred while attempting to render the standard error message, please see the event log for full details: '@@plone')
--------------------------------------------------------------------------------
Troubleshooting Suggestions
The URL may be incorrect.
The parameters passed to this resource may be incorrect.
A resource that this resource relies on may be encountering an error.
For more detailed information about the error, please refer to error log.
If the error persists please contact the site maintainer. Thank you for your patience.
Hi carsten!mitch hat geschrieben:gibts hier eine möglichkeit die ID als Primary Key und auto increment zu machen?
lgAdditional data sources may be created by making additional directories in the var/gadfly subdirectory of your Zope installation.
Hi XtraNine!XtraNine hat geschrieben:Code: Alles auswählen
id INTEGER NOT NULL PRIMARY KEY (id)
Code: Alles auswählen
select * from project where id=nummer
Hi mitch!mitch hat geschrieben:Code: Alles auswählen
select * from project where id=nummer
Hi mitch!mitch hat geschrieben:Da hab ich ZMySQLDA mal runter geladen und es in den Product Ordner entpackt. Aber da ist ja nix dabei, weder Anleitung noch eine Installations Datei!
...wie gesagt -- so geschehen.gerold hat geschrieben:Im Laufe des Vormittags probiere ich ZSQLiteDA mal aus und schreibe dann wie man es installiert.