Webmaster Forum / ASP / Database Access / January 2005

I found this function on the web
Function GetSubstringCount(strToSearch, strToLookFor, bolCaseSensative)
If bolCaseSensative then
GetSubstringCount = UBound(split(strToSearch, strToLookFor))

I have an ASP that should get data from 2 tables located in 2 mdb files.
Is it possible to create a liked table in one of them so I will need to open
only one connection?
If yes, how?

My web-packaged training pieces (using Authorware) send data to an Access
database via ASP pages.  In the past, I have tested the files using the
version of Microsoft IIS that came with my Win XP Pro.  It worked great.  
Now, I am having trouble.

My web-packaged training piece (in Authorware) sends user data to an Access
database via an ASP page.  I have recently increased the number of variables
sent to the database from 25 to 35.  Each variable can be a string of 10-15
characters or a numberical value of 2 digits.

Hi, I know this is an old question but I don't find the solution on the
'net ...
The user enters his data into a multiline textarea field.
The data is saved in a TEXT field in a database on a SQL Server.

I have a SQL Server 2000 table with the following structure:
CREATE TABLE [Personal] (
    [UserId] [INT] IDENTITY (1, 1) NOT NULL ,
    [Name] [NVARCHAR] (50),

Hi all...
I have a text file line by line example:
test.txt
aaaaaaaa bbbbbbbb ccccccccc

I am a rank amateur at hand coding anything as all I have done to now is
use MS Frontpage.
I need an application to register a new user on a website. The user's
data will be kept in an Acess 2000 db.

How can I do this...
Pretend that this is my SQL statement...
SELECT pageData FROM dataTable WHERE pageData LIKE 'winners'
Pretend that the text below is what gets returned.

I'd like to trigger a VBScript by clicking on a push button, but I always
get errors and the line number and error
description don't make any sense (Line: 29 Char: 6 ';' expected)
Line 29 =

I am connecting to an Access DB but when trying to retrieve search results
from the DB, I am met with the error:
Error Type:
Response object, ASP 0100 (0x8007000E)

I have written most of the easy ASP portion for a MS Access
DB insert.  In the database, I have about 15 checkboxes in it.  Five
of them represent a point total of 1 point, 5 of them at 2 points each
and 5 at 4 points each.  Over time this database will get quite big.

I got this code on a .asp page that retrieves data from an AccessDB and
shows it in a table.
<%
Dim DB

I have a pair of temp columns:
id          name
1            bob
2            ted

how can i get default value field in a db like .mdb , swl server and mysql
with asp programming ??