Search:

I would like to get opinions on what AJAX framework I should use to automatically populate the options in several select boxes.

Problem to solve
- User must select 8 options (from 8 dropdown...

OK, but another problem I didnt explain before is that the value of each box depends on the previous one.

example:

ABC
- 025mm
-- black
- 050mm
-- black
-- pink

I have a product select page that is really slow to use because 6 dropdowns must be populated and the page reloads after selecting each box, to get the options for the next box.

I want to speed...

I have a result set like this:


REQ_CO time USER_NA_FULL MSG
00000007 21/02/2003 13:40:59 Mr X Please return the failed product for the investiga...
00000007 08/04/2003 13:11:49...

I found actually it does work OK with "quotes"

I just had to remove the backslashes to get it to work.

Interestingly, using + character has no effect though :)

I have a simple HTML form.

In IE6, when the user enters some text and clicks enter, amazingly the page RELOADS instead of submitting the form.

Is this a bug with IE6? In Firefox there is no...

This confuses me.

I've never seen a decent search function that doesn't allow use of quotes to group phrases.

Do you have to do something like check for quotes in the query, if exist then use a...

In MySQL I have a query using MATCH and SCORE.

There is one problem. When I use quotes in the query, it doesnt affect the results at all. Is there some problem with MATCH so that it ignores...

fixed. the problem was I had a ";" character at the end of the select query :(

Strange, variable arguments seem to work when I test the following query on my localhost MySQL:

UPDATE country SET name = CONCAT( name, '(', (
SELECT country
FROM contact
WHERE contact_id =1...

Is there some way to do it by combining two queries (UNION?) instead?

Sorry, I'll repost the exact query I am trying to use:



I get a syntax error on 'line 2' which has the CONCAT bit.

If I replace the SELECT query with a text string it works fine.

I now need to make it more complex as follows:

UPDATE issue
SET SUMMARY=(SUMMARY, ' (', (SELECT STRINGVALUE FROM customfieldvalue c WHERE ISSUE=72012), ')')
WHERE (key = '21109');

Basically...

thats the one - thanks.

I want use a MySQL command to append the value of colA to colB:

Original Data:

colA | colB
-------------
a11 | john
b32 | bob
c44 | sally
d89 | mike

I wish to simply copy all the data from columnA to columnB - what would be the command to do that?

Something like this...?

INSERT INTO (colB) SELECT(*) FROM (colB)

I want to send some emails from my Win2003 server with IIS6.

I have turned on the SMTP server, but I dont know how to connect to it or set it up. How do I find out the connection details (e.g....

I got some code that makes a clock that shows the time. if you choose a region it shows the time in that region. I am using PHP to get the server time to use as the base time. It works fine for me...

I have some URLs that are generated automatically in PHP and are used to send some data to my website. e.g.

www.dom.com/auto-update?e=1&b=3&r=99
www.dom.com/auto-update?e=15&b=23&r=9
...

How do I convert dates of this format:
2007/09/20

into a timestamp?

I will then convert it to my prefered format with:
$mydate = date("d/M/y",$timestamp);

Thanks!

I ended up doing this PHP instead.

I created an RSS feed using PHP module I found:
http://www.thenewfreedom.net/RSSWriter/RSSWriter.htm

Everything works fine, BUT the feed is accessible from:

www.domain.com/myrss.php

I want...

My company has a website for various countries.

The URLs are like this:

www.dom.com/jp/ (Japan)
www.dom.com/global/us/ (US)
www.dom.com/global/uk/ (UK)
www.dom.com/global/eu/ (EU)...

I want to select all data where the description field is not empty.

I tried like this:


SELECT *
FROM table
WHERE LENGTH('description') > 1

but I think my use of LENGTH is wrong and it...

it works great now, thanks a lot!