Webmaster Forum / ASP / Database Access / February 2005

I am still very new to ASP and am trying to create an ASP page that gets
records randomly from a database. Right not I can successfully get  one
field of
information at a time and randomize it, but I need the whole string.  I've

I'm very, very new to ASP and am trying to run a travel and absence database
for a small company on the internet. It will show as column headings 01 Tue,
02 Wed, 03 Thu..... etc for one month. Row headings will be the employee
names and the cells will contain the locations where ...

I've written an asp form that successfully takes a users firstname, surname,
email address, username and password and then add's those details to an
Access database.
I've been trying to modify the code so that the script checks that the

I'm struggling a bit reading binary data from a database.
Basically, I have a column in our table that has the binary type, and
all I want to do is display that binary data in HEX. basically the table
looks like this:

I use some sp:s in a ms sql, and so far it looks like (this works fine):
-----------------------------------------------------
sql = "sp_NameOfSp @IDno = 1, @Name = 'Mikael'" (and 15 more values...)
cmd.CommandText = sql

I have an asp page where a check box is used. If the check box is checked
then the value goes to an Access database as "on" while if the checkbox is
unchecked before saving the asp page, the value of the checkbox that
goes to the access database is "off". The  datatype in Acess is ...

Is there a better way to write the following statement?
SELECT id, firstname, surname, age
 FROM sometable
WHERE ( (id = 5058)

I'm new to this and am having a lot of trouble. I've been able to work my way
through a couple of other bugs that have come up, but I just don't understand
this one. I'm trying to run a very simple, small database for a project for a
class. I've created my own web server on an XP ...

Hello,
I am testing a simple asp page. Here data is added to a database in People
table.
The primary key is Name (FirstName LastName). The data add part is working

I have posted this to the asp.general group, but the answers given there
have not addressed the problem, so I'll try here.
Set up a W2003 machine at home. IIS is working. I placed an Intranet-based
app that I wrote at work, onto this home machine. I rebuilt the SQL Server

I am using an ASP page to access information in a SQL 2000 database. When I
run the following query:
========================================================
Select Distinct [Judge Name], Caption, Avg ([Total Score] - ([Gross

Hi Gang
I want to create a simple array that could have up to 100 - 200 rows
and that always has 2 columns (and will have some number value in each
column).  I can't seem to figure out how to create the array initially,

I have created a SQL database, a user to be used for communications in my
ASP code, my tables, etc.  Enterprise Manager gives me a way to create
scripts of the structure.  I don't really understand which scripts to create
as their are numerous choices and it will take some more ...

1. With Enterprise Manager what is required to have the script create the
database, the SQL user and
set their password?
2. Now that I have created the scripts, how do I execute them on a different

I am testing a small asp page where addnew method is applied to add record
to a table. However, I am getting the following error:
Unspecified error
/gwisbrandnewready4/test/REPLY.ASP, line 35