Search:

If you can't get it work any other way, you could always do it using a temporary table.

Thus:


CREATE TEMPORARY TABLE tempint ( id INT );

INSERT INTO tempint(id)
SELECT F.event_id
...

That code from SQL Guru was for SQL Server.

MySQL has restrictions in it that SQL Server doesn't have. Including the fact that you can't do some calculations on the table you are deleting from.
...

To me, your code seems ridiculously complex.
And I don't see how it keeps someone from answering "NO" to all three.
But if you like it...

If you really can't tolerate naming the radio buttons "reason1", "reason2", "reason3",
then we *CAN* leave their names alone with just a little more coding work.

You HTML is very illegal. You use the same ID more than once. For example:
<div id="reason1">
<input type="radio" ... id="reason1">

IDs *MUST* be UNIQUE on the entire HTML page.

But in any...

Don't confuse sliding timeout with sliding cache expiration, which is very very useful. Normal timeout means that each time the user hits the server the timeout starts over. I doubt seriously that...

You can only do that with JavaScript. You can't do it with server-side code because the HTTP protocol, used to communicate from browser to server, is strictly a "pull" protocol from the browser's...

First of all, you were using SUM() completely incorrectly. SUM() is an aggregate function and cannot be used without a GROUP BY. There was no reason at all for that function to be there, at all.
...

Ummm...so what? If you pop up the alert, it will stay on the screen until they return, even if that is the next day.

Also, alerts are obsolete. Some browsers now allow users to turn them off. ...

I am truly confused.
I don't know why you would *NEED* to parse that, given the message from Flash:
That says to me that Flash is *ALREADY* trying to parse your value,
and it is expecting...

No, it would *NOT*. Because you can't embed JavaScript code into the response.

The response *MUST* be read as just a text string by the receiver (Flash code).

I don't think I can help you...

You know, you could have easily found that if you would learn to use the JavaScript debugger.

My favorite is the debugger in Chrome. But even the one in MSIE 8 and above is pretty good.

To...

I think I found the goof:

This line:


markit = "this.change_" & id & ".value='YES'"

should have been

markit = "this.form.change_" & id & ".value='YES'"

Why would you use CONVERT()???? That is used to, as you would think, convert a string to a number, for example.

You completely missed what I wrote

Try this:

SELECT C2.*
FROM category AS...

JavaScript, and I assume AS3, has a few ways to specify a date.

The most accurate is

var dt = new Date( yearnumber, monthnumber, daynumber );
where, as you said, months are numbered 0 to 11...

Can you show it live? Give us a URL to look at.

Have you used your JavaScript debugger and/or error console?

But you are sending that to Flash as D1, *NOT* as DateOut.

Is that what you intended?

And you need to tell us what date format AS3 is expecting.
As you coded it, Flash will see something...

Won't make enough difference to matter. Wouldn't worry about it.

And then a simple change to the submittal page:


Set connect = Server.CreateObject ("ADODB.Connection")
Connect.Open "test"
For Each name in request.Form
value = request.Form(name)
If...

I have to do it. Your code is just too ugly to live.<grin/>



<%
' get all the city <option>s into a single string before doing anything else:
SET conn =...

Okay, so add a hidden field for each record:


<input type="hidden" name="changed_<%=RS("idclient")%>" value="no"/>

And then for each field in that same row/record add an onchange (onclick for...

Why would you store the date into the array element? Just generate it *again* when you go to display the calendar. Presto. Problem solved.



numDays = Request("numberOfDaysToDisplay")
Dim...

You want to do this client-side, using JavaScript, or server-side? Either can work, unless the user turns off JavaScript in his/her browser.

The problem with that system is that it isn't very complete.

For example, it is very rare in the business world to have an even that occurs on the same day every month. An event that occurs on...

I'd start with http://www.asp.net

That's MS's own site, and it has more info than you'll be able to read.