Webmaster Forum / ASP / Database Access / December 2004

I have been used to paging through recordsets but until now have not
come across this problem.
When my sql select statement is based upon a SQL View it always
returns -1 pages and this prevents the 'next page' / 'previous page'

If possible, could you please confirm what the ASP query syntax would be to
add an extra field into an Access table at a particular position, eg after
field4 and before field5.
Thanks

Who are you?

Using a login userid, I am trying to go to a asp page which will display the
values for the particular record. The asp page has quite a few recordsets in
the form of Access stored query. Now for the first recordset, I do not get an
erro while for the second recordset, I am ...

I am using an html file that have a code that reads from an xml file and
displays it in a grid. however the xml file is updated every 5 minutes, and
the code read the data every 5 minutes.the problem is  despite of updating
ehe xml file the old xml file data still displayed, ...

Hello this is Robert, from Italy,
I am trying to learn a little bit asp language,
I am tired to load pages on my web site just for test.
I installed Windows 2000 5.00-2195 Service Pack 4 + IIS 5.

I currently use a pulldown which holds all customer names. When a customer
is selected, it takes the user to a detail page.
Basically using the autonumber ID field.
Select * from myTable where ID = ID

Im trying to transfer  an old asp/SQL server application to asp/MySQL and
have run into a problem with SQL (Or suggest another news group?)
My version of MySQL doesnt seem to support sub queries (and cant upgrade to
the latest that does), so I cant use the existing SQL

I developed an ASP application, now I want to convert it to ASP.NET.
However, I cannot implement it after I completely re-design. Can I develop
new things with ASP.net and keep the original ASP. Is it possible that ASP
page and ASPX page run at same Web Server at the same time?

how could I using ASP to retrieve a blob from Oracle 8i?
For instance:
I have a table
"blobtable"

I've got more than one form on a single ASP page. The top combo box is
populated from an access database with job titles. The field below it, in
its own form, is a text field that one can put a new job title into, press
the submit button and add the new title to the access table ...

Using ActivePDF Toolkit with a website.
The site allows a user to submit information to a database, search, view and
edit it. Now I want to add the option to save in PDF format after a search
has been completed.

schedcheck = "Select Sched_Date,Sched_Start,Sched_End FROM Schedule WHERE
Sched_Date = #"& strSched_Date &"# AND (Sched_Start BETWEEN # "&
strSched_Start &" # AND # "& dateAdd("n",-1,strSched_End) &" # OR Sched_End
BETWEEN # "& dateAdd("n",1,strSched_Start) &"# AND # "& ...

I'm getting a SQL login error.
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E4D)
Login failed for user 'sa'.

Ive got a scheduling application using an Access db. Scheduling works fine
but Im trying to implement a function to prevent scheduling conflicts. Im
not sure if this is the way to go about it but below is what I have so far
and it's not working. It schedules the event no matter ...