Webmaster Forum / ASP / Database Access / July 2005

I have a web page which receives information from a form (using
request.form) and also attempts to look at an Access query to read in
recoeds to a variable named rsGroup.
When I have the following line commented, so it does not activate, I

After posting a record to SQL Server, is there ever an issue trying to get
the last record posted and it not being there due to an extensive process
during the post?  What is the best way to handle this, in ASP or SQL?
TIA...

I have an ASP application which uses a single SQL Server based in London.
I have two webservers on which the code is hosted one in London and one in
New York both connect to the same SQL server database based in London.
The connection between London Webserver to SQL Server is fast ...

I am a relative beginner with SQL and ASP. With some help after
previous posts I have a page which successfully requests querystrings
from another page and deletes a record from an access table, However, I
get the error message:

I am a relative beginner with ASP and very weak on syntax, basically I
find something that works and modify it - but I have 1 SQL statement
which I cannot get to work.
I am using asp3.0 and VB Script

I'm trying to get my Webserver to talk to my SQL Server and allow Trusted
Connections.
If my SQL server and Web Server are on the same box I can get it to work.
There needs to be a User on the SQL Server that in running the Web

Could someone tell me if this parameter stored query is correct? Its not
throwing up errors BUT also not returning any records...unsure if
concentation is somehow needed to tie it all together?
Are the apostrophe's needed...do i perhaps need '+' symbols?

Could soneone help me extend the following select statement to selet the top
five recently published news stories in descending order but RANDOMIZED. I
already have the NewID() doing the donkey work but I am having trouble using
an ORDER BY after it...is it possible? At the ...

Dose a machine that has an asp application that uses access database have to
have access installed or just the mdb file??

I am very new to ASP. What I want to do is, Show results by each month
from data sent from a input page. The results page now shows all data
from the past year in a table. Is there a way to only show the current
month and past month but maybe archive the other months? Maybe

We are getting the following error in IIS6 on Windows 2003 Server:
Server.CreateObject Failed
From the global.asa, the line is "Server.CreateObject("ADODB.Connection")"
This same code works fine in IIS5 on Windows 2000 Server.

I'm developing an online Payroll/Cash Advance application for a client.  So far, I have a table with the fee structures for both the check cashing and cash advance.  Now I need a "cash register" type table for keeping track of the transactions going in and out for the cashier.  ...

I've got a Windows 2000 server running IIS to host a small intranet for my
company.  This week my server died on me and I've spent all day building a
new one.  Most of the pages use ASP to pull data from FoxPro tables using a
DSN connection.  When it page loads, it seems to lock ...

---- -------------------------------
id |     date1   |   date2   |user_id|priva|
--- -------------------------------
1 |something |something|   1    | 0  |

First off thanks in advance for any assistance.
This is what I'm trying to do.  I have a database with 3 columns,
fMonth, fDay, and fYear.  I'm trying to create an sql statement with
asp/vb to select these values and convert them to a date, and then