Hello Guys; I have a table which contains duplicate entries (almost all) but with a differentiating PK & another 1 column. Below is the sample of what I have ID Narration RenewalCount Renewed 1 ABC 1 0 2 ABC 1 0 3 ABC 0 0 4 PQR 1 0 5 PQR 0 0 Now, I need to get distinct entries from this table as given below ID Narration RenewalCount Renewed 3 ABC 0 0 5 PQR 0 0 The idea is for me to set Renewed column = 1 for the rest of the records in the table.

Simon_Whale wrote:

https://forums.oracle.com/forums/thread.jspa?threadID=258409[^]

Thank you for the reference. But I tried it and still didn't get it working.

Simon_Whale wrote:

Just a suggestion what if you give the "text" column name an alias?

Thank you for the suggestion but I have already done that and it didn't work.

Hello guys; The code below returns an empty records but gave records from SQL+.

DbProviderFactory factory = DbProviderFactories.GetFactory("Oracle.DataAccess.Client");
DbConnection connection = factory.CreateConnection();

connection.ConnectionString = "Data Source=(DESCRIPTION=(ADDRESS\_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=Simplex-IT-02)(PORT=1521)))
                     (CONNECT\_DATA=(SERVER=DEDICATED)(SERVICE\_NAME=Simplex))); User Id=User\_Test;Password=password;";

DataTable table = new DataTable();

DbCommand command = connection.CreateCommand();
command.Connection = connection;
command.CommandText = "SELECT text FROM user\_views WHERE (view\_name='ACCOUNT\_BALANCES\_BY\_PERIOD');";

DbDataReader dataReader = command.ExecuteReader();

table.Load(dataReader);
dataReader.Close();

Meanwhile, when I replaced the command.CommandText with "SELECT DISTINCT view_name FROM user_views" it gave me list of all available views for the given schema. Why can't I get the sql text of a given view? Thank you in anticipation.

Thank you for the response. It helped me.

Hello guys; I just deployed ASP.NET web app on my office local server and is accessible via all workstations but can't access it via my mobile phone and andriod tablet. This app is meant to be run on tablets/phones. What do I need to do to browse this app. Thank you in anticipation.

Hello guys; I pop a dialog which contains two select (dropdownlist) controls. I use the first one to filter the second select. My challenge is, whenever the second select width increases as a result of the data it contains, an horizontal scrollbar appears on the dialog which I don't want because, it disorganizes my form's appearance. What do I need to do to auto-size the dialog's width as the width of the second select increases and shrinks as the case may be? Thanking you guys in advance for the prompt response.

Thank you for the response.

Hello guys; In .NET environment, you could deploy you web app to your local server with compilation (which hides all code-behind files, i.e, your server-scripts). How can I achieve the same in my WAMP/PHP environment. The essence of this is to protect my application from being modified by anyone else behind me. Thank you in anticipation of your prompt response.

"Success at anything will always come down to this: focus & effort."

I truly appreciate your response.

Thank u Peter.

Hello guys; I am from .NET background where I write data access code to any database platform using the DbFactory and the like. I need a sample code that can connect to any database that all i need to supply is the database provider name, database name, user name, password, etc. Thank you for your understanding and support.

Thanks a million. I will do what you said!

Hello guys, I want to be able to send mail in html format like the one below but I get the raw html in my mail.

include_once "Mail.php";

function isMailSent($from, $to, $subject, $body) {

$host = "mail.domain.com";
$username = "email@domain.com";
$password = "password";

$headers = array ('From' => $from,
'To' => $to,
'Subject' => $subject);

$smtp = Mail::factory('smtp',
array ('host' => $host,
'auth' => true,
'username' => $username,
'password' => $password));
try {

// add to the body
$body = '

' . $body . '

Thank you!

';

// dispathc mail
$mail = $smtp->send($to, $headers, $body);

// check if mail was sent successfully
if (PEAR::isError($mail)) {
return "

" . $mail->getMessage() . "

";
} else {
return "

Message successfully sent!

";
}

} catch (Exception $e) {
return $e->getMessage();
}
}

Please help.

hi everyone,

how do I make emails deliver to inbox not junk box.

i am using a pickup directory.

please help!

hi everyone,

how do I make emails deliver to inbox not junk box.

i am using a pickup directory.

please help!

Okay, I will try your suggestion. Thanks.

No. It only works once and after postback, it stops working

Hello,

I am having a challenge of using jQueryAutoComplete in my webforms. The problem is when I have selected an item from the suggested items in the textbox, fill other form fields as required, then submits the form, every is fine. But I cannot get the autocomplete working anylonger to process a new entry. What could have been the course of this? See how I did it

<link rel="stylesheet" type="text/css" href="../../Styles/jquery.autocomplete.css" />
<script src="../../Scripts/jquery.min.js" type="text/javascript"></script>
<script type="text/javascript" src="../../Scripts/jquery-1.4.1.min.js"></script>
<script src="../../Scripts/jquery.autocomplete.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function () {
$("#<%=staffNameTextBox.ClientID%>").autocomplete('../../AutoSuggest/SuggestStaffName.ashx');
});
</script>

Hi, In ASP.NET, the best way to manage http errors e.g: Error 400.x, 500.x is to specify this in the web.config or globax.asax file. How do I accomplish the same in php, because I was to get a nicely formatted error page displayed to my users instead of the anoying apache error page. Please help!