Search:

mdjo · 01-04-2008, 02:11 PM

I don't know if it's needed without seeing what queries are being used, but it's certainly not redundant. The order of fields in a key makes a difference. If we have an index of...

mdjo · 01-04-2008, 02:01 PM

The short answer is "union":

select * from template
union
select * from custom

A more fundamental question is why you have two tables with identical layouts. It would probably be easier to...

mdjo · 01-04-2008, 10:04 AM

I've never heard of "Top Style Pro", so I can't comment on that directly. But in general, if you want to be able to view pages on your local computer or a test server:

1. Use relative links. Okay,...

mdjo · 12-20-2007, 05:39 PM

Oops, there should have been a "from" in there somewhere.

mdjo · 12-20-2007, 05:38 PM

Perhaps you should show us the exact query you're trying to use.

I would think this should work if you said

select personid,min(time)
group by personid

Does the time field really say...

mdjo · 12-20-2007, 05:33 PM

I'm at the office where we don't have mySQL, but the following works in Postgres:

update mytable set mydate=mydate+365
where somecondition=true

Assuming that the previous poster is...

mdjo · 12-18-2007, 08:23 AM

I believe you're right, my senile old brain was jumbling together two numbers. Now I'm trying to remember ... did our ASR-33s have a switch to let them operate at 110 or 300, or was it that the Dec...

mdjo · 12-17-2007, 10:58 AM

Hey, you may even be before my time. I started with Fortran IV. Did you ever use SNOBOL? Perhaps the most concise language ever.

I have fond memories of the day we replaced our 310-baud ASR 33...

mdjo · 12-17-2007, 10:39 AM

The direct answer is: I don't know, but it's easy enough to work around.

Whether or not Google will be able to chase your redirect may depend on just where and how you're initiating it. In...

mdjo · 12-10-2007, 04:05 PM

The key problem is that you never set "next" on the last entry in newlist.

You need something like:

Link leftOfMiddle=getLeftOfMiddle();
Link rightOfMiddle=leftOfMiddle.next;...

mdjo · 12-10-2007, 03:30 PM

Hmm, the literal "Enter name" is never going to equal the literal "Stop", so the loop will always promptly exit.

Perhaps what you have in mind is something like:

while (true)
{
String...

mdjo · 12-10-2007, 03:22 PM

I was thinking that perhaps the reason why the original poster did not use multiple columns to start with was that he had some more complex formatting requirements, in which case he might need to use...

mdjo · 12-10-2007, 03:12 PM

In any case, the "correct" answer is surely KDLA's first suggestion: putting each heading in a separate column, i.e. <td>. This has the big advantage over other methods that it actually works, and...

mdjo · 12-05-2007, 12:20 PM

I'm typing this code of the top of my head, so it may have syntax errors, etc, but the principle would be something like this:

void findSubFiles(File dir)
{
File[] files=dir.listFiles();
...

mdjo · 11-05-2007, 08:50 AM

Ah, so it's not really a "menu", it's a node tree of some sort.

But hmm, if you're trying to make your code generic, then I think you're pushed to a solution that involves storing table name and...

mdjo · 10-31-2007, 02:09 PM

Hmm, are you saying that a menu entry will link to a specific record in one of many tables? This sounds like a very strange design. Why would a menu entry link to a specific record? Maybe I just...

mdjo · 10-31-2007, 01:56 PM

Including description in the group-by means it will find the max id for any given description, which is probably not what you want.

Side note: substr(id,1,11) looks to me like it would be no...

mdjo · 10-31-2007, 01:43 PM

Why join on A at all? Why not just:

select p1,s1 from b
union all
select p2,s2 from b

But then, I'm sure the example was contrived, maybe in real life your table A really had other data...

mdjo · 10-31-2007, 01:21 PM

Oh, sorry, I completely misunderstood what you were asking. You just want to know how to have two functions run at <body onload> time? Easy.

Suppose the two functions are called "stuff" and...

mdjo · 10-31-2007, 01:17 PM

I typically create a class I call "Db", and in that class I create a static function that gets a connection. Like:

public Connection getConnection()
{
Class.forName("...driver...");
......

mdjo · 10-31-2007, 12:58 PM

My first question would be what you're doing to get the checkbox checked on the return. I presume you're using PHP or ASP or JSP or something. Why not just use the same flag to turn on the textbox?...

mdjo · 10-30-2007, 08:23 AM

I recently did some preliminary work on an application for hand-held devices, where the screen was, I forget the exact size, something like 300 x 250. Now THAT starts to get challenging. In a few...

mdjo · 10-29-2007, 04:58 PM

Ah, you're laboring under the naive delusion that JSP/servlets support file uploads. They don't. You have to write your own code to parse the file out of the request stream, or beg, borrow or steal...

mdjo · 10-29-2007, 04:54 PM

It depends on your servlet engine. In Tomcat, by default it's in "work/Catalina" followed by the name of the server, then under that are directories for each context. Let's see, I don't have any...

mdjo · 10-29-2007, 04:49 PM

Your syntax is correct. Well, is that EXACTLY what you put. Because that would give an empty cell. If you're trying to just make a box of a certain color, put an " " inside the cell. If you...

Search:

Search: Search took 0.01 seconds.

Thread: Weird Key Variable

Thread: Get Data From 2 Tables (not Join... I dont think)

Thread: Please help? Newby questions about root directories.

Thread: orderby and groupby issue :(

Thread: orderby and groupby issue :(

Thread: mysql dates

Thread: TWO questions: terminology and a software recommendation

Thread: TWO questions: terminology and a software recommendation

Thread: Google Crawling if index.asp is redirect to another directory..

Thread: Link List

Thread: While loop for Java

Thread: seperation of text in a table data tag

Thread: seperation of text in a table data tag

Thread: find files in subdirectories....

Thread: Are blank foreign key columns bad?

Thread: Are blank foreign key columns bad?

Thread: select string column with max id

Thread: SQL / Subquery Question (I think)

Thread: check the checkbox status when page loads up

Thread: want to create separate connection file for Servlets

Thread: check the checkbox status when page loads up

Thread: Who cares about Firefox?

Thread: Where's my uploaded file?

Thread: java source file of JSP

Thread: color of a cell in the table....dynamically