I have a SQL interface page in my classic ASP web app that allows admin users to run queries against the app's database (MSDE 2000) - it simply consists of a textarea that the user submits and the app returns the resulting list of records as below Dim oRS Set oRS = Server.CreateObject("ADODB.Recordset") oRS.ActiveConnection = sConnectio...
I'm looking for a static code analysis tool that will determine if I have orphaned functions in my VB6 code. The problem I'm running into is we make calls to the VB6 code from classic asp. Is there a tool that will look at both the classic asp and VB6 and determine if there are any orphaned functions? ...
I am trying to setup IIS on my laptop. I have followed a guide which said to go to: Control Panel > Programs > Turn Windows Features On / Off > Click on IIS. I have done this and my computer now says that IIS is running. However when I visit http://localhost in my browser I get a 'Page Cannot be Displayed' error. I have had it workin...
I have installed both IIS and SQL Server 2005 on my laptop. Both work individualy, however when I try to connect to an DB from an ASP page I keep getting the following error: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "DB1" requested by the lo...
I have two tables in my database. Comments CommentsID MembersID CommentsBy CommentsDesc CommentsActive CommentsDateEntered NewsID News NewsID MembersID CategoriesID ImagesID NewsTitle NewsShortDesc NewsDesc NewsActive I need to take top 5 commented news (active comments and active news) and list their titles using one que...
i have a website in windows server 2008. I'm using aspupload component. the upload works when the file size is small but fails when the size is huge. Is there some settings in iis 7 that limits the upload size? -Vivek ...
I have a code file which I will refer to as "myConstants.res.asp" with a bunch of constants in both English and French... <% const myStr1 = "Bienvenue dans ma maison au moment de cette belle journée de repos et de détente" const myStr2 = "Welcome to my house at this beautiful day of rest and relaxation" ... more constants ... %>...
I created a simple news website. I store both videos and images in IMAGES table. Videos added have videos and images added have images stored in a column called ImagesType. Images and Videos attached to a news is stored in ImagesID column of the NEWS table. My problem occurs when I need to display the first image of a news. i.e. IMAGES...
I have to use classic ASP to build a website. I want to be able to use include files for the header and footer. How do I pass variables to the include files so that I can affect such things as titles etc. Here is some examples of what I want to do: index.asp <% dim title title="TITLE" 'Server.Execute("header.inc") <--- Note I tried t...
I have a real problem with a classic ASP page. The page allows the user to upload a document and save it to the database. The intial page posts to another asp page which saves down to the db. This works on IE and Firefox. However on Safari it fails. I've debugged the problem and it boils down to the fact that of all the controls that the...
Hi, how can I remove specific rows and columns from an excel file using only classic ASP? For example, given the excel file col1 col2 col3 one two three four five six I want to be able to programmatically delete the first row and second column to produce one three four six Thanks! ...
I am receiving the following error message: An error occurred on the server when processing the URL. Please contact the system administrator. If you are the system administrator please click here to find out more about this error. I have my site in the inetpub directory in a subfolder called website. I have also gone to add/re...
Here's my code: if Request.Form("authorize") <> "" and request.form("delete") <> "true" then post_ids = Request.form("authorize") ids = split(post_ids, ",") For i = LBound(ids) to UBound(ids) sql = "update tbl_comments set authorized = 'true' where comment_id = " & ids(i) pageDB.execute(sql) Next m...
PS: My bad, there was not an error. I forgot to upload the latest version to the server... I have multimedias and images table. I save images in multimedias table with their images table id numbers. Then whenever I need image's url, with a simple function I get it from images table. The problem I am having is when I try to display image...
Whoever wrote the navigation for the site I’m currently working on (classic asp) points the navigation links to a folder, then inside to folder has an index.asp file, so the urls will look something like this www.mysite.com/myfolder/mysubfolder Now, when watch the page load using httpfox, I notice that the first entry is a 302 redirect ...
how to attach more then one files and then send mail using ASP Technology.. Not with ASP.NET so please guide me.. and I want to send this mail when page load... so where should I write... Thanks in advance ...
Hi, I have an ASP site(not asp.net, old asp) which executes some lines on the server-side. I want to run an exe in the server side code, but i'm not familiar with asp programming - the site I got was already built, i just need to add this little code and that's all. I think the ASP code is in VB as it's very familiar to VB and has the s...
Hi there, I've got a recordset/paging set up - works fine in IIS6 but when I run the site on an IIS7 server I get the following error: Microsoft OLE DB Provider for SQL Server error '80004005' [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. /orders.asp, line 197 the code looks like this: S...
I am trying to implement a module in either C# or classic ASP, which extracts the XMP data from a EPS file. Is there a framework or component (not necesarilly free) which can help me to create this module? Any advice / direction will be greatly appreciated. ...
hi i am making NewsLetter using the wysiwyg Editor.. it allows me to upload the Image Path and Image Path is stored in the Upload Directory.. Not When i retrieve that Image using it works in website.. the editor's value is stored in database example <br> hi <img src="upload/acb.gif"> <br> Hello i am sending Email and the detail of...