Webmaster Forum / ASP / Database Access / June 2005

I need some help with a dynamic SQL query in Access.  I want to insert
records if they are not duplicates.  I thought the following would work as
it does prevent duplicates but it inserts a record for each record found
that is not a duplicate.  I'm having trouble getting it to ...

I am trying to update records in an access db using asp (IIS5). I think this
should work but ti isn't. I am wondering if when nesting functions you have
to have them in some sort of order. Here's a sample of the code -- and I am
basically trying to replace the use of an apostrophe ...

We have a website www.mitre.net
Within it we have a Company Search facility which accesses a MySql database.
In the Company Name box users have to enter a minimum of three characters
and then select a location.

I need help with this prob.
every time I update a memo filed that contains an enter key I get an error. Normal text without the enter key fork fine.
Microsoft OLE DB Provider for Visual FoxPro error ''80040e14''
Command contains unrecognized phrase/keyword.

Problem:
in a form a user inputs a date in the danish format (ddmmyy)
After requesting the field I convert into format: #mm-dd-yy" and insert the
field together with other fields into an Access table.

Posting a subfunction I'm using right now.....I keep getting the
following error;
_______________________________________________
Microsoft JET Database Engine error '80004005' |

I have an ASP page that prints out search results from a product
catalog (in a HTML table) - the resultset is returned from a SQL Server
stored procedure. The customer wants to be able to select multiple
items using checkboxes and maybe an Editbox for quantity. There is an

This has probably been asked 100's of times, but I couldn't find anything on
it.
Is there a small script of some sort, that would disable the ability to
double click a submit button>?

I use ASP to get to an oracle database using ADO. I am trying to dissplay a
record which has mixed characters - Asian, spanish, English etc.
I have set the session.codepage to 65001 and the meta tag to uf-8 as well.
Yet I am not seeing the mixed characters. I see inverted question ...

I am getting started on a prototype site and have set up one of my home
machines with IIS and MS SQL Server.  Based on several on the posts to this
group, I have been reviewing the ADO connection strings.  However, what
really puzzles me is that it appears you need to use an ...

Having problems with security settings! I have an ASP application using
an ACCESS database with ADO. I want to run it on a local server and
access it from my two clients.
I gather Microsoft do not like you to use Access Applications such as

I've been creating a number of admin systems now for my classic ASP sites
and although they seem to keep the wolves from the door, I just wanted to
ask if you have any additional security pointers that I should watch out
for.

some questions about setting up a web scripting test platform at home -
I am in the lucky position of being able to do most of my development
work from my home office (so far having done projects in Visual C, VB,
Access, SQL Server) now  i am working on an ASP project (website with

Visual Interdev 6.0 has a handy function of autofilling  parameters
(e.g. Command.CreatParameter(sTxt, adVarChar  <= etc. ))
The IIServer does not seem to understand these, I need to replace them
with numberals or define them myself like

I am using IIS on Windows XP and getting the following error:
Microsoft VBScript runtime (0x800A01A8)
Object required: 'getElementsByTagName(...).item(...)'
/sds-test/courierXML3.asp, line 161