Webmaster Forum / ASP / Database Access / December 2003

   I don't know if this is the right group or not to discuss this issue with, but I am hoping so.  I have an SQL database and am trying to use frontpage as my interface.  I am able to query the database fine and present the data on a webpage; however, I want a way to modify- add ...

Hi,
I am writing a jsp page to get data from db.
<%@ Language=VBScript %>
<!-- #include file="ConnString.asp" -->

I'm trying to connect to a SQL Server using dsn-less
connection string such as "PROVIDER=SQLOLEDB;DATA
SOURCE=SQLSERVER;UID=DOMAIN\username;PWD=password;DATABASE
=myDB"  I know it works with Standard SQL Server

All,
I will be eternally greatful if someone can provide snippet of code,
URL or reference material that shows how to display data in a "n
colums * n rows" format.

I have a search page with some criterias. SQL query created in separate
include file (SearchCriteria.asp) based upon choosed criteria. I choose
criteria and go to result page. For instance, "SELECT * FROM Table1 WHERE
x=5". Paging works fine only for first page. When I click NEXT, ...

I have a asp-build grid with some records.
The name of a record is a {Link}. I want to be able to click
on the link and open a new asp-form that has an editable grid.
That form must only show the record which was clicked.

How can I make certain that decimal values print out 2
places to the right all the time when displaying them on
a website coming from an Access database.  Its defined in
the database as a Number, Single, Auto, should I make it

I have an Access db which has a LoginCheck table.
I use this table to login with name and password.
But there is also in the table a field right which can be
"read" or "write".

I have a asp-page that shows all data from one record in my database.
Every record also has a memo-field but since there's so much text in
it I wanted to have a button on my form that will open a seperate form
containing the memo-field. So a user can always decide if he wants to

hi..i am trying to make a login page and i am using access
table..
when the user enters his userid and password i want to
check the password from the table..

I'm following the below example in order to create a connection to my Access
database.  My question is, is it possible to include the username and
password as part of the connection string?  I've tried appending
"UID=username;PWD=passsord" to the cst connection string, but I get a ...

OK, here's the scenerio.  
One department here uses the same Access database (on a
network) for various reasons, all different, but with the
same data.  Now, I've created a separate SQL Server db to

I'm in trouble with reporting data on web with crystal reports.
for me it's not easy to find some sample codes(ASP).
does anyone have some example asp codes?
I use Windows 2k server and SQL server 2k.

I'm trying to get the last part of a string.
In VB there's a function called lastinstr() who does the work.
But it doesn't seem to work in ASP.
The string I have is for example:

I am trying to connect to our corporate Oracle database to
query some data in an ASP page. My experience with ASP has
always been with SQL Server and Access databases, but I
figured I could get a connection string to work. I tried