[thelist] ASP Database Problem. Any Ideas?
Scott Dexter
sgd at ti3.com
Mon Sep 25 11:43:27 CDT 2000
> SequelFunction = "INSERT INTO Links (LinkURL, LinkName, LinkBlurb,
> DateAdded) VALUES (LU, LN, LB, LDA)"
On top of that, if this is the exact line, then you're not inserting the
variables, but the literal values "LU", "LN", "LB", and "LDA" --and Access
is puking respectibly.
try
> SequelFunction = "INSERT INTO Links (LinkURL, LinkName, LinkBlurb,
> DateAdded) VALUES ("&LU&", "&LN&", "&LB&", "&LDA&")"
and then you have to add tick marks around your character fields, and #
around your date fields (for Access)
> SequelFunction = "INSERT INTO Links (LinkURL, LinkName, LinkBlurb,
> DateAdded) VALUES ('"&LU&"', '"&LN&"', '"&LB&"', #"&LDA&"#)"
how's that?
sgd
More information about the thelist
mailing list