Hi,
Is there a way to return the @@ERROR messages in (SQL Server 2000) stored procedures to the ASP page?
Essentially, I have a function that allows the user to import data into the SQL Server using BULK INSERT in an ASP Page. Should anything be amiss, (record exists etc.) I'd like to be able...
Hi,
Does anyone know how to use ASP to read data from a csv file and do an INSERT into SQL Server 2000 database? Both my csv file and sql db allows null values in their columns.
I went to this link: (reads from csv file and writes to HTML page ~ I figured would be similar to writing to SQL...
Hello!
Cleaned my Comp. 3 steps:
(1) Enabled firewall in XP.
Network Settings>Right click>Properties>Advanced Tab>Check first box
(2) Run Removal Toolkit from Symantec for Win32.MSBlast.Worm
http://securityresponse.symantec.com/avcenter/venc/data/w32.blaster.worm.
removal.tool.html
(3)...
Hi,
I have a pop-up box with this message everytime I connect to the Internet. It pop-ups about 5 minutes into the connection :
This shutdown is initiated by NT AUTHORITY\SYSTEM Remote Procedure Call (RPC) service terminiated unexpectedly.
Then the system just restarts. The same thing...
Hi!
Thanks for all your help. There were some table layout problems though when the number of columns increased. But I've worked around the problem by adding and specifying one cell at a time. Below is a short abstract of my codes:
I actually need to capture the user input in each row and...
Thanks for the example! I added more columns to each of my rows by multiplying the following line of code--
var newCell=newRow.insertCell();
2 further questions:
(1) Is it possible to have text boxes or select lists for user input in the cells in each column?
(2) How can individual cells in...
Hi,
I have page with a table, and a button to add rows to this table dynamically.
This is a very basic concept I have of this program. It adds a row at a time:
<%
Function addrow()
%>
<tr>
<td>value1</td>
<td>value2</td>
</tr>
<%
End Function
%>
<form>
<input type="Submit"...
Hi!
I would like to know how to export data fields in an Access database into a .txt file to store in a floppy. I don't want to store the .mdb file directly into the floppy because the file would be hugh.
I understand that the tables in my database should be processed individually.
Could...
Hi,
My SQL query from an ASP page:
query = "UPDATE Loan SET DateOut = '"&Date&"', TimeOut = '"&Time&"', CheckedOut = Yes WHERE LID = '"&lid&"'"
resulted in a data type mismatch error.
My column LID is an auto increment field. I set it to be the...
Hi,
I'm running on local web server IIS, and using a remote MS SQL Server 2000 Enterprise Manager which houses my database. I have set my ODBC connection.
I'm trying to retrieve data with my ASP pages, but had this errror: (Connection to SQL Server was successful)
Error Type:
Microsoft...
Thanks! It works now.
|*Oraclec*|
==========================================================
Information alone is not knowledge nor can it grant wisdom or be put to use until it is properly applied.
==========================================================
Hi everyone,
I am using MS Access for my database. I am doing some web based programming. I have an auto increment field in one of my tables. I would like to insert a record using SQL INSERT statement into the table.
What value do I insert for this auto increment field?
I tried ignoring the...
I am using Win XP Pro version. Yes, I managed a successful installation of only the desktop version.
Before this, I tried installing the standard version, but only the client tools could be installed, plus the .rll file could not be loaded.
Thanks for all your help.
|*Oraclec*|
Hi,
I'm new to MS SqlServer7. Need some help on this. I installed the standard version of this RDBMS on my office desktop. However I could not open the Enterprise Manager, so essentially, I can't create any databases using this RDBMS at all. The error message I got...
Hi!
Am trying to work out how to auto delete a row in my table that's displayed on the webpage upon clicking a [delete] button.
The page should refresh automatically without showing the deleted row. I have a [delete] button in each row.
Grateful for any kind advice.
:)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.