[thelist] ASP INSERT INTO problem
L. Floyd
lfloyd at sonic.net
Wed Nov 1 15:24:57 CST 2000
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.
More information about the thelist
mailing list