[thelist] ASP INSERT INTO problem

Chris Evans chris at fuseware.com
Wed Nov 1 12:31:33 CST 2000


Also, date is a reserved word, which may cause problems.  If possible, I
would use a more descriptive word for this table.


Chris Evans
chris at fuseware.com
http://www.fuseware.com


-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of Tab Alleman
Sent: Wednesday, November 01, 2000 1:07 PM
To: thelist at lists.evolt.org
Subject: RE: [thelist] ASP INSERT INTO problem


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.

-----Original Message-----

>
> Try changing the names of your "name" and "date" fields in
> your database.. I
> think one or both of those might be reserved words.
>
> INSERT INTO chatter (name, date, comments, files) VALUES
> ('bob', #10/31/00#,
> 'just some words', 'files.jpg')

Also try putting the date in single quotes: '#10/31/00#' though my Access
knowledge is limited (we're 100% SQL Server here)

sgd


---------------------------------------
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !






More information about the thelist mailing list