Webmaster Forum / ASP / Database Access / May 2006

I have a Classic ASP application that gives permissions based on the NT user, so I can't allow anonymous. I want to save files off to another server, but the IUSER account can't do that.
If I was anonymous, I could substitute a username and it would work.
How can I require a NT ...

I need to know if who is logged into my Avtive directory (Windows Server
2000) and write them to a SQL server database table called Logged_In_SQL.
Can ASP help me do that ? If not is there a utility that can do it? It would
have to be real time or run on a schedlue or something.

ASP error number 13 - Type mismatch with SELECT...FOR UPDATE statement
I got ASP error number 13 when I use the SELECT...FOR UPDATE statement
as below.
However, if I use SELECT statement without FOR UPDATE, it is fine and

Hey gang. I have searched this, because i thought i was doing it right. what
i read says i am doing it right, but still getting an error. here is the
statement:
set schedule11 = conn.execute("select distinct(team_name) from teams where

Using Access...
I need to "select * from tablename where datefield >= date()"
This throws an error, can you help with syntax?

I have an asp application that uses Sybase ASE as a backend DB.  I have been
noticing ADO errors saying "Out of Memory" or
"Catastrophic Error" and then the web server will just hang up.  I have
checked all my DB connections and they are all being

I am using mssql db and access it via SQL server management studio.
is it possible to move a table from 1 db on my server to another db on my
server?
if it can't be done through that program, can it be done with script?

I need to display some records from an Access database, but there are over
100k records.
Isn't there a way you can use NEXT to display the first 10 records, and then
page through the result set ?

I need to display a url link in a asp.net gridview.  Right now the url data
simply displays as plain text.  How can i format the text to display as a
link ?
thanks.

Trying to do an Update in SQL on an ASP page.
I need to know why these dont work or what to do to make them work:
 sql= "UPDATE EMORDLIN_SQL SET cus_comment = " & NewComment & "' WHERE
Line_ID= '" & LINE_ID & "'"

Hi again,
just a quick question. i've done reading on sql injection attacks after
the issue was raised over my method of deleting records from my access
table. if i use saved parameter queries will this solve this problem or

can an If statement be put inside a query?

I'm trying to randomly select one record from an Access table via ASP. I saw
the article on ASPFAQ, but their Access example didn't work for me. I've got
the following code:
Randomize()

Hi Friends,
Can I have one page "prod.asp" with 2 forms (form1 with ONE Submit Button
and form2 with 2 submit buttons) submiting to same page "prod.asp" again?
Thanks

I have one combobox where I want to display Name of the Products that are
loaded in the collection object. But I am able to send only ID and Name of
the Product where ID is the value of the option tag and products name is the
display text for option tag. I want to send the Product ...