Search results for query: *

I have a hand-me-down Access database which I am trying to get some data out of. I have a table called issues with a field called owner. The owner field may contain a single name, or it may contain a comma-seperated list of names. I have a table called users with a field called name. I am...

How can I get events to fire in Netscape 4 with nested layers? <div id=&quot;frame&quot;> <div id=&quot;sub1&quot; onMouseOver=&quot;doThis();&quot; onClick=&quot;doThat();&quot;>Sub 1</div> <div id=&quot;sub2&quot; onMouseOver=&quot;doThis();&quot; onClick=&quot;doThat();&quot;>Sub 2</div>...

I have a javascript problem that I am needing some help with. I pulled the following code example (slighly modified) from a book and I am having some problems getting it to do what I am looking for. ------------- <div id=&quot;menuFrame&quot; class=&quot;menuFrame&quot;> <table...

I have got a setup where I have a set of nested <div> tags and I need to figure out which <div> tag the user is hovering over when an onMouseOver event fires. I have the following code right now ... <div id=&quot;menuFrame&quot; class=&quot;menuFrame&quot...

I have a query that does a left join between two tables (i.e. there may or may not be records in the second table, but I want all records from the first table). Now I need to apply a certain criteria to the records that come from the second table ... but what if there are no records? How...

For some reason I cannot put this together this morning. I have two rows in a SQL 2000 database that contain exactly the same information with the exeption of one numeric field. I would like to pull one of those records - the one with the larger field value. Help? -- Thanks

How do I do the following HTML tag in CSS? <TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0> --- If I setup my style sheet as follows ... TABLE { border: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right...

Does anybody have a good recommendation on somewhere to learn about setting up SQL Server to be used as a web site back-end? I have always been on the application programming side, dealing with an exisitng SQL Server. Now I am trying to actually set one up and the permissions are being a pain...

I am interested in figuring out how to build an update query for a verity search for a discussion forum app. My situation is that I have a table called threads that has a threadID and threadName. I have a table called messages with a messageID, threadID, and messageText. What I think I want...

How do I go about duplicating the border attribute of the table tag in CSS? I have tried both border-color and border-top (bottom, etc), but they only effect the border around the outside edge of the table. All of the borders in between cells disappear. How do you manipulate all of the...

This would seem fairly basic, but it has been a long day. I two fields in one table called owner and submitter. I have another table called users with a field called ID. Now both the owner and submitter field can (don't have to) contain users.ID values, but they may not be the same users.ID...

I have a standard SELECT SQL statement in which one of the items in the table is a field called Owner. The owner field can either be an id number that points off to another table called users -OR- it coule be a persons name, email address. Now what I need to return in a single query is the...

I have a standard SELECT SQL statement in which one of the items in the table is a field called Owner. The owner field can either be an id number that points off to another table called users -OR- it coule be a persons name, email address. Now what I need to return in a single query is the...

When I was using Access databases, you could have access generate a report on a database that would basically list any tables/queries/forms/etc. and all of their parameters. I used this quite frequently to get a listing of all of my tables and their associated fields/types/etc. One of my...

Is it possible to have a SELECT query insided of an INSERT Query? i.e. - INSERT INTO Table1 (ID, Type, etc ...) VALUES (1, SELECT Type FROM Table2 WHERE ...., etc ...) I thought it sounded reasonable enough, but I am getting errors. Just an attempt to lighten the number of hits on the...

Is it possible to have a SELECT query insided of an INSERT Query? i.e. - INSERT INTO Table1 (ID, Type, etc ...) VALUES (1, SELECT Type FROM Table2 WHERE ...., etc ...) I thought it sounded reasonable enough, but I am getting errors. Just an attempt to lighten the number of hits on the...

Does anybody know how to set the colors of a &quot;light&quot; and an &quot;dark&quot; border on a table with CSS? Another IE versus Netscape, but IE uses the HTML format of <table border=&quot;1&quot; width=&quot;100%&quot; bordercolordark=&quot;#6F0000&quot...

Is it possible with CSS to do a rollover on a table cell like you can with a link? i.e. TD { background-image: image1.gif; } TD:Hover { background-image: image2.gif; } If not - does anybody know how you can change the background image of a table cell with a mouseover event? (that works in...

I have a standard setup of a table with a list of tools, a table with a list of users, and a table that contains the index of tools matched to the index of users (i.e. which user has access to which tool). What I am needing to do is get a list of all of the tools to display, but also be able to...

I have a standard setup of a table with a list of tools, a table with a list of users, and a table that contains the index of tools matched to the index of users (i.e. which user has access to which tool). What I am needing to do is get a list of all of the tools to display, but also be able to...