Webmaster Forum / ASP / Database Access / September 2005

Can i call a ASP function (with parameters) inside JavaScript. with
parameters as
JavaScript variables?
Please help in correcting the below code..

I'm new to asp AND sql server, literally had this job thrown at me and
I need some help from you pro's out there. I have 3 tables in a sql
server database.
Table 1 "tblStudentInfo" contains student info and each has a unique

I have an ASP application that retrieves records from a SQL Server DB
table & displays them to the user. The records will be displayed to the
user in a HTML table with the column names as the first row. After this
row, there should be a drop-down list for each & every column. Each ...

I'm new on ASP and Access. I stored several lines of information in a Access
memo field.
I use follow ASP response.write statement to display contain of the memo
field.

The article at http://www.aspfaq.com/show.asp?id=2424 lists some tips
to make ASP pages more efficient. One of the tips under the sub-topic
"General" under the topic "Database-specific" says:
Avoid DISTINCT unless it is absolutely necessary. You can use GROUP BY,

I've got an ASP page which accesses data via Oracle ODBC driver. After
serveral (sometimes, lots of) successful requests, the page returns the
following error to the browser:
Provider error '8000ffff'

I'm getting following error sometimes..Problem is error doesnt come up
everytime so its hard to figure out..
Microsoft Cursor Engine error '80004005'
Data provider or other service returned an E_FAIL status.

I'm picking up an Incorrect Syntax error where the connector AND is used  in
a compound WHERE clause where I am trying to restrict the user to a selected
Status and Date Range.
If the Status parameter comes back empty I will return ALL statuses for the

I am trying to get the IP address of the Client machine and using the code:
Response.Write(Request.ServerVariables("REMOTE_ADDR"))
But I only get 127.0.0.1
It should be giving the IP address of the system or the gateway. How can I

Please could you assist me on this query. i have to
complete this task the earliest time. i am not that
experienced in asp, but i manage more and less to
program basic functionalities....

How do I find out what is the datatype of a particular column in an
Access database file using ASP?
Thanks,
Arpan

I want an ASP application to retrieve records from a SQL Server 7
database table, transfer the records to MS-Word & generate reports
using those records. In other words, the reports in MS-Word should be
generated dynamically based on user input. It should also allow my

Our intranet uses a SQL server.
I was wondering if I could write a view that would return the users data
only?
For example if Joe Blow opens the view, it only returns the records that the

I have an MSAccess database that I have used to create a cross tab querry.
When I try and bind it to a datagrid unsing an OleDbDataAdapter or
OleDbDataReader the data grid only displays two of the many column headers
and none of the data. I am not haveing trouble binding to other ...

I'm completely stumped with an issue of authentication.
I have an ASP.net application which is supposed to retrieve data from a
remote database. It is supposed to access the database using the domain
credential of the user that is accessing the page.