brianlange

If you do a header(Location: your-html-page.php) you should be able to avoid the duplicate insert on refresh. Or if you have unique values being inserted you could do a select statement before you do the insert.

Our company recently changed servers. There is php code to download a file via ssh using the ssh2_scp_recv function. This no longer works since we migrated servers. The scp function does work. Is there a config setting that can fix this issue. I saw a work around mentioned on php.net but I would rather just to have ssh2_scp_recv working. Thanks.

will the php function ftp_connect encrypt the handshake when provided with a ftps url or will only the data transfer be encrypted?

I am new to Toad and relatively new to Oracle. I have recently received access to use Session Browser in Toad. Can someone point me in the right direction on how to effectively use this tool. For instance, how to find long running queries, find bad explain plans etc.

Thanks for the great responses. The form accepts html and then parses the links that are entered into a new form. There are multiple individual checkboxes (not arrays) associated with each link so if there are a couple hundred links this leads to 1k+ plus form elements.

Thanks. So it sounds like increasing the limit to 5k or so is probably ok. Yes, the form should be redesigned but this is not an option at the moment.

By default max_input_vars is set to 1000 (5.3). This can cause issues if a form has more than a thousand input values or a post array has more than 1k elements. Increasing the limit is said to be a security risk. Is the risk minimal? Can you raise the limit with minimal risk involved?

Should PHP warnings cause http 500 errors? I was under the impression that only a fatal error would cause a 500 error? I am troubleshooting a max_input_vars warning that may be the cause of a 500 error.

I'm also aware that I can write update table set col1 = val, col2 = val where id = :id I was just curious if I can avoid repeating the value.

In Oracle, how do I update several columns to one value? This will work, but I am guessing there is a better way. Update table set (col1, col2, col3) = (select val, val, val from dual) where record_id = :record: id

Does it matter if you pass in more bind variables than are present in the sql statement? Does it depend on the version of oracle or how it is configured?

I have a complicated php page with javascript. It was having issue loading. I moved the body onload to window.onload and the page is working better. My boss seems to think this should be irrelevant but after 20 tests it appears to make a difference. Has anyone had a similar issue? I know I am being vague and I cannot post code, I was just looking for comments on issues with using the onload body property.

I don't think that is going to work. I only want the records where the min(start_time) for records grouped by message_id has a status value of 'PC' I was able to get a result with the following. Is there a better way to do this? select message_id from table where start_time in (select min(start_time) from table group by message_id) and status = 'PC'

My Oracle table columns are: message_id, status, start_time There is no primary key. There are multiple rows for each message_id. I would like to be able to select records where the record that has the mininum start_time value for records grouped by message_id has a status value of 'PC' Thanks!

Thanks!