[thelist] ASP INSERT INTO problem

[L. Floyd]

Bingo!  As it turn out, "name" is ok, but "date" is reserved.  One
solution is to just rename the field.  But the other, which is what I did
cuz I'm lazy, is to do what Tab says:  put the field name in brackets.

Thanks for all the input.  I'm usually a lurker due to some email
difficulties here at work.  Yesterday I was working from home and it was
nice to have real access to thelist.

I'm still puzzled why it took so long for my posting to make it, however.
:-/

- larry

On Wed, 1 Nov 2000, Tab Alleman wrote:

> I'm pretty darn sure that the ##'s is done correctly in his example.
> 
> I also think that another way around those field names is to put them in
> brackets, like:
> 
> 
> > INSERT INTO chatter ([name], [date], comments, files) VALUES
> > ('bob', #10/31/00#,
> > 'just some words', 'files.jpg')
> 
> maybe.