Recent content by canadatct

I'm currently in the process of building a prototype, and I felt this was the easiest method to get things working for now. I'm fully aware that this is not the BEST method of working with a db, and I know enough about SQL Injections to properly plan for that. And George, I can assure you that...

Here is the code that updates the db. if request.querystring("type") = "new" then rsSave.open "Table", objConn,2,2,2 else strSQL = "Select * from Table where FieldID=" & cint(request.querystring("fID")) rsSave.open strSQL, objConn,2,2,1 end if with rsSave if request.querystring("type") =...

I am trying to update a SQL 2005 (express) table using an ADO recordset. I can't seem to nail down the exact problem here, and the error message is not overly helpful. It's the first time I've ever seen this error. "Microsoft OLE DB Provider for SQL Server (0x80004005) There are no rows in...

Clicking on the link produces a window that says "Page Cannot be Found". I might have resolved my issue though. I've added some "odd" mime types to IIS, and those files can now be downloaded.

I have a website application that is being used to transfer files, where users can upload files for others to download them. My problem is that any file type that cannot be opened within the IE browser fails when trying to download/save the file. Any help would be appreciated.

I think that will work great. I'm going to run some testing on the query to ensure that it's generating the correct results, but so far, it seems to be bang on. The query will be dynamically generated, therefore if someone was selecting 20 different training classes, and wanted to see who was...

Thanks for the help so far. Much appreciated. I'm basically trying to retrieve all records that have either a value of "1" and a value of "2" for Field2. I think I was missing something from that query, so the logic probably doesn't make much sense (which I realize now). I have been...

I seem to be having some difficulty with a fairly easy select statement, and I'm hoping that some other pairs of eyes might be able to help spot what I'm doing wrong. Here is my select statement: Select Field1 from Table1 where Field2 = 1 and Field2 = 2 If I was to remove one of the where...

I've been trying to figure this thing out too......and I think I'm quite close actually. I have installed and registered the ASPEXEC server component on our webserver (which allows you to run Windows/DOS applications through ASP). With this component, I'm able to use the iFTPAddU.exe file...

I'm looking for some insight on a problem I'm having with an ASP ADO Recordset. I'm trying to delete various records from an Access Database table, but I am getting some very strange results. I know the code I've written to delete the records from the database is functioning as it should...

Thanks vongrunt........that did it. It's funny how you can stare at something so long and miss the most obvious things!

I have been trying to use recordset.movefirst (which is actually included in this code), but it doesn't make any difference to my results. rs.open strSQL, objConn,3,2,1 if rs.eof = true then response.Write("<td class='cssError'>There are no results from your search. Please try again.") else...

I am having a strange problem with a fairly simple query I am running on an Access DB. After running the query, I am populating a drop down list with the results. For some strange reason, when I loop through the results and insert each record into the <option> tags, it is skipping the very...

If you have a copy of IIS, you will need to install that to enable ASP on your system. IIS comes with Win2K, and XP Pro, but you could use a personal web server with Win98 to accomplish this as well. If you do have IIS or PWS, ASP is free. The only cost involved (as far as I know) is the cost...

I see you are trying to trap any potential errors that could occur (On Error Resume Next), but I don't see any error handling code. I could be wrong, but at first glance that's what I see....