RE: [ros-kernel] rosproj on reactos.dhs.org

[Rex J. <re...@lv...>]

At 09:39 PM 5/12/02 -0400, you wrote:

> > Well, mysql (3.23.41) does not accept this (I just checked).
> > Try putting NULL there (it is the project_id field).
>
>Put a NULL where? I looked in the initial_data.php and classes.inc but
>couldn't find where I would need the NULL statement for project_id

You either need to specify data for all columns in the order they appear in 
the table,
or you need to specify the columns explicitly, for example (I don't know 
column names,
so ill make some up):

INSERT INTO modules
   (module_id, insert_date, insert_user, module_name, module_description)
   VALUES
   (0, NULL, NULL, 'ReactOS', 'ReactOS');

Using this form, if you have nullable or defaultable columns, you dont need to
specify them.  Also, you can add columns to a table without breaking all the
code if explicit columns are used in inserts.


>Thanks
>Steven
>
>
>_______________________________________________________________
>
>Have big pipes? SourceForge.net is looking for download mirrors. We supply
>the hardware. You get the recognition. Email Us: ban...@so...
>_______________________________________________
>reactos-kernel mailing list
>rea...@li...
>https://lists.sourceforge.net/lists/listinfo/reactos-kernel

Rex Jolliff
re...@lv...