Search results for query: *

Hey all, I'm trying to create a dynamic class to handle user permissions on my site. Right now, if I add a new permission field to the db, I also have to create the GET/SET properties in the class itself. I'm looking to have the class created dynamically based on the fields in a specified...

Hey all, Here's the deal... I've got a page with some clickable icons which are used to 'View' a test and 'Print' a test. The 'View' icon opens a new window and the test is displayed. What I want to do is allow the 'View' page to be printed, when the 'Print' icon is clicked, without...

Hey all, I'm creating forms (one for each record) dynamically using asp. The forms are named and id'd as "attemptForm_{attemptID}". My problem is that the first records (always the first and only the first) returns an error when I try to submit it. If I use...

Hey all, I'm havin a small 'debate' with one of my IT guys over the possible holes created by giving IUSR write access to an directory in IIS 6 (Directory Browsing is off and was not 'default' install). As I perform file Copies, Deletes and Moves with ASP, I require the entire directory to...

Hey all, I wish to disable all buttons on my page. I would like to do this without disabling all my 'INPUT' elements and without referencing their names as some of them change dynamically. I got as far as: els = document.form1.getElementsByTagName("INPUT"); for (i=0; i<els.length; i++){...

Hey all, I'm creating an Excel import utility using ASP/VBScript and I'm running into a wierd problem. Once I'm in the proper record, I'm trying to parse the row and return the cell contents. Here's the (rough) code: 'Conn string Set oConn = Server.CreateObject("ADODB.Connection") strConn =...

Hey all, Is it necessary to run an SQL Injection Prevention routine when adding data to the DB using the RS.AddNew/Update method? I've noticed that even if you write something like: '; drop table xxx; -- ... the text is added, as is, right into the DB. I just wanna make totally sure that...

Hey all, I've found a solution to my problem using a different method but I still don't understand why my method didn't work. I wanted to open a popup window to display a large image (when the thumbnail is clicked) and I wanted the size of the window to be relative to the size of the...

Hey all, I've seen many posts across the Net regarding this issue, though none have been of any help. I'm trying to delete some records using the following simple query (the tables are linked to an MSSQL database): DELETE FROM Prod_Results WHERE AttemptID=51362 It keeps returning a...

Hey all, This may seem like a silly question but here's what I'm tryin to do: I have an App variable to maintain a count of users currently taking an exam/test. Now, there may be some unforseen instances in which a user may quit the exam and the counter won't decrement (closing the...

Hi all, I didn't know if this question should be written in this forum or the SQL one. I decided on this one since the error is being thrown from Access. I am trying to add DATEDIFF to one of my queries as such: "DATEDIFF(Week, '" & Date & "', prod_User.ExemptionDate)<=3" When I run...

Hey all, Here's the deal... I've created a survey system and I am displaying the results in a report. The individual graphs themselves are in a subreport. Some survey questions are multiple selection and the others are single choice. Because of the multiple selections, I need to use a...

Hey all, I'm pretty sure this can't be done, but I thought I'd give you guys a chance to prove me wrong... Is it possible to get the window name in ASP using VBscript? (like an ASP version of the JS window.name) Thx, Dave

Hey all, I am trying to display the results of a complicated query in a report. Three fields should be of the 'Currency' Format. Two of the three fields don't display anything under the 'Format' pull-down in the Properties box. The third field has all the typical choices. The odd thing...

Hey all, I have an 'Excel Export' function in my current project. The only problem is that the last column wants to print on separate pages. In an attempt to automatically fit the columns on to one page, I tried using the following code: oSheet.PageSetup.FitToPagesWide = 1 When I create...

Hey all, I've seen this kind of question posted before but I've not come across any solutions that work. Here's the deal: I have a form (Main) that should open another form in its Onload event. This works. The problem, however, is that the form which is opened displays behind the 'Main'...

Hey all, I'd imagine this is a simple question but I haven't been able to find anything on it. I have a 'remove' button that should be disabled if a certain listbox is empty. The problem is, if the remove button has focus at the time of being disabled (like if I use the button to remove...

Hey all, I'm trying to use a chart to display fiscal data. Everything is working, however, the date, on the bottom axis(formatted as Apr '06 etc..), is being sorted alphabetically. (ie Apr, Aug, Dec etc...). I'm trying to sort this by month (Apr, May, Jun etc...) but every time I try, I get...

Hey all, I'm trying to run some code on the Form_Load() event. However, any code I put there seems to be bypassed (I even added a 'Stop' and nothing happened). I've had to add said code to the Form_Open(Cancel As Integer) event instead. Any ideas why Form_Load would be bypassing code?

Hello, This should be an easy question but I cannot figure it out. I have a Report named "missingReport". The query I want to use for the RecordSource is quite complicated and so I need to set it dynamically. When I click a button in my form, I want to set the RecordSource to mentioned...