Webmaster Forum / ASP / Database Access / May 2008

I'm a novice in visual studio and access database.I need to connect my
access database, but i keep getting the following  error:
Script error detected at line 44.
Source line: con.Execute sql_insert

I need to join 2 csv files with SQL left join. I keep getting the following
error:
Microsoft JET Database Engine (0x80040E14)
Syntax error in JOIN operation.

I have been working since 10am this morning (now after 1am in UK) on this. I
can't see what the problem is.
I have a classic ASP application with a development database in MS SQL
Express (All SPs applied). I have one occassasion where I would like to run

Using MS SQL server version 8 sp 3, and I need help with converting my
dynamic queries into parameterized queries and/or injection proof
stored procedures.
Here is an example of what I currently do:

I am new to ASP and would like to know whether this is the right forum
to post to. If not please advise what would the best group to post to.
My problem is a mailing asp file when it loads up in the browser the
page is blank. There are no error messages.

SQL = "SELECT FROM tblX WHERE Z not in ('a11','b22','c33','d44')"
Is there a maximum length of this
litteral array ('a11','b22','c33','d44') ?
Or of the SQL string as such?

First let me apologize if this isn't the right forum.  I couldn't find an
exact fit, but I'm desperate so...if you know where this should go please let
me know.
Ok, I have a query in Access that runs fine if you enter empty parameters,

I have a strange problem.    ASP pages that have worked for years are
suddenly giving me errors.   Here's the scenario.
Server:  Win2k Server running IIS
Opening ADODB recordsets.   First recordset on page opens fine, but

I have a SQL Server 2000 record with a bit field that I've verified with
Enterprise Manager to be = 1 but no matter what I do Classic ASP thinks it's
zero.
"field = <%=rs.fields("myfield")%><br>" results in nothing