[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [cobalt-users] ASP database connectivity
- Subject: Re: [cobalt-users] ASP database connectivity
- From: "Brian Feliciano" <brian@xxxxxxxxxxxxxxxxx>
- Date: Thu Nov 1 23:46:02 2001
- List-id: Mailing list for users to share thoughts on Cobalt products. <cobalt-users.list.cobalt.com>
> sql = "SELECT voornaam FROM adressen ORDER BY voornaam"
> Set rs = db.Execute("sql")
this is not right.
it should be..
----------------
sql = "SELECT voornaam FROM adressen ORDER BY voornaam"
Set rs = db.Execute(sql) 'without the quotes.
------------------
the quotes means it is a string and NOT a variable.
your script is telling that it should execute the sql statement "sql" and of
course since it is an invalid sql statement it will produce an error.