Search results for query: *

I have two databases "Employees" has names and ids, "Events" lists specific events and has a column that can contain employee ids. I want to select a list of employees from the "Employees" table limited to only those who have been associated with an event. I thought the syntax was "SELECT *...

I have an aggregation workbook, which has a number of worksheets with rows of data like: Name, value1, value2, . . ., globalsort globalsort is calculated on these pages to allow ranking in aggregation. As the values change (thereby changing the globalsort value), the subtotal and grand total...

I have an aggregation workbook, which has a number of worksheets with rows of data like: Name, value1, value2, . . ., globalsort globalsort is calculated on these pages to allow ranking in aggregation. As the values change (thereby changing the globalsort value), the subtotal and grand total...

I have a database with three tables: cases, firms, and manymany. Each case and firm has an autonumber key. manymany allows a many-many relationship by storing a case ID and firm ID in each row. When doing data entry, I want to enter some data about the case, and then associate firms with it...

Hi, I have a site that was initially developed on a Server 2000 box and was recently moved to a Server 2003 environment. While many of my asp pages work fine, one of the more complicated pages does not. The page uses an iframe in a floating div to allow the user to enter additional...

Hi, I am currently attempting to debug a website which was initally developed as an intranet application on a MS 2000 Server and was recently moved to the internet on a MS 2003 box. The new server has a slower connection to the DB server (SQL Server 2000). One of the most complicated pages...

My site uses a dynamic PDF generator which much be run from the command line through ASP. On the old server, IIS 5, everything worked like a charm using ASPExec to run the program. Now that I've moved the site over, ASPExec reports that it has called my program correctly but the program does...

In MetaEdit, there is a visual way to set string properties such as secure and User Type (server, asp app, etc). Does anyone know how to use ASDI to set those properties?

Hi, I've run through the metabase tutorial at www.asp101.com/articles/thomas/metabase/default.asp and as far as I can tell I've done everything right, however when I try to run MetaRead.asp (which accesses the stored values) I get the following output: ERROR Reading data access credentials...

I read somewhere that security conscious ASP sites are better off storing the SQL connection string in the system registry than in the global file. Since all of my previous work has been in intranet programming which is far less security conscious, and the site I'm working on should be as...

I haven't really had to screw around with IE box model hacks before, but I've got a fairly annoying problem (that could perhaps also be solved with cleaner markup -- ideas?) The site is http://pantheon.yale.edu/~fhb5/Rugby/index.shtml and the problem is in the 1 pixel margins between menu...

I am trying to implement a nested menu adapted from http://css.maxdesign.com.au/listamatic2/vertical03.htm but am having problems because setting two nested menus to the same ID means my page no longer validates as HTML 4.01 t. I tried changing id= to class= and changing # to . in my style...

I have a page where the CSS file says: a:hover {border: solid 1px #AF0807;} but I can't seem to remove that border from images within links. (especially annoying as firefox only draws the border around the bottom 12 pixels of the picture) My guesses such as img { border: 0px none; }...

Hi, I've been looking all over google, and I can't seem to find either a yes or no to this question. Basically, I have an admin suite built into an ASP page and would love to do something like: if not IsAdmin(user) then raise HTTP Error 401.5 else display page end if with the idea...

--I posted the following on the perl forum without realizing there was also a CGI forum-- Hi, My cgi-bin and public_html folders are, unfortunately, on seperate servers (both unix). I haven't done much perl recently, but have written a script that generates an html file based on various files...

Hi, My cgi-bin and public_html folders are, unfortunately, on seperate servers (both unix). I haven't done much perl recently, but have written a script that generates an html file based on various files in my cgi-bin, but I would like to upload it to my public_html folder so that I can use it...

Hi, I am working on a website for a group that I participate in under the following constraints: 1: the main server, which hosts the site itself, only allows static HTML/Javascript and static file includes. 2: the secondary server, which hosts the cgi-bin, allows a wider array of languages but...

I am trying to finish the following sql view and make it so that the two columns named sorter and sorter2 can be combined using ISNULL() so that I can sort by the column. SELECT TOP 100 PERCENT COUNT(dbo.tblMetrics.metricID) AS projCount, dbo.tblMetrics.metricID...

I am working with AutoCad Mapguide, and having a huge javascript problem. The problem stems from the fact that the actual Mapguide activeX cannot be manipulated when it is in a "busy" state, and therefore I must wait for it to leave that state before I can further interact with it. (the page...

Hi, I am fairly new to SQL and would like to figure out set based syntax, as I am currently assigned to write the following procedure: Tables used: pipes, nodes, pipe_attributes Each sewer pipe has a unique id of "NODE-NODE" (ex. 123-456) The procedure will insert a new node into the pipe and...