Search results for query: *

Okay ... I am trying to run this magic query from a ColdFusion script and therefore, I am not sure how to setup or run an Access function. A little more details please? Thanks

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...

Okay, if I cannot use className, is there a way I could give all of the 'menuItems' the same name or id and track them that way? Basically, I am just trying to figure out from which <div> the onMouseOver event was fired from. (and yes I will agree, NS4 is a royal pain, but unfortunatly I have...

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...

Okay, to change the question a little bit. Now I have two records with five fields. Field 1, 2, and 3 are the exact same between the two records. Field 4 is numeric, different between the two records, and I don't really care about it. Field 5 is numeric and different between the two records...

Thanks, I was missing the Having clause.

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...

The problem was in the table joins and I played with the database in order to get the fields to be the same. Thanks for the help.

Thanks for the help. What you said almost worked. I had to add in an =1 at the end of the isNumeric statements, but I am also getting an error anytime the query comes across a string in the owner field. It processes fine with the owner field is a number (foreign key to Users), but croaks with...

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...