[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