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

[Jason F. <jas...@ya...>]

Yes, inserts aren't using a very good style. I'll change it...
sometime. :)

- Jason

--- Rex Jolliff <re...@lv...> wrote:
> 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...
> 
> 
> _______________________________________________________________
> 
> 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


__________________________________________________
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com