query problem (with date format) in dot net - ASP.NET Discussion Boards

Re: Msgbox in asp.net

Sathesh Sakthivel14-Jun-07 1:53

Sathesh Sakthivel

14-Jun-07 1:53

I hope not.

Regards,

Satips. Rose | [Rose]

Re: Msgbox in asp.net

Sylvester george14-Jun-07 2:01

Sylvester george

14-Jun-07 2:01

Really you cant...but try this way..may be useful for you

http://www.codeproject.com/aspnet/asppopup.asp[^]

Regards,
Sylvester G
sylvester_g_m@yahoo.com

Re: Msgbox in asp.net

shervin jijo14-Jun-07 18:15

shervin jijo

14-Jun-07 18:15

This is pretty good concept of showing MessageBox

Re: Msgbox in asp.net

koolprasad200314-Jun-07 23:19

koolprasad2003

14-Jun-07 23:19

Magh_M wrote:
with out javasctipt?,

it pretty much good que, but without javascript, you can use VBscript,
but without scripting
i don't think we can do.

regards,
koolprasad2003 Smile | :)

Be a good listener...Because Opprtunity knoughts softly...N-Joy

webpages flickers/Blinks during post backs....

dhulipudi14-Jun-07 1:29

dhulipudi

14-Jun-07 1:29

Hi,

My webpages are flickering/Blinks during post backs.... in both IE7.0 and Firefox.

Its working fine in IE6.0....

Plz Help.
~JJ

Re: webpages flickers/Blinks during post backs....

Sylvester george14-Jun-07 2:19

Sylvester george

14-Jun-07 2:19

Page.SmarNavigation = true;

Regards,
Sylvester G
sylvester_g_m@yahoo.com

Re: webpages flickers/Blinks during post backs....

dhulipudi14-Jun-07 3:21

dhulipudi

14-Jun-07 3:21

It's working now... Big Grin | :-D

in IE 6.0, 7.0. Problem remains in Firefox. D'Oh! | :doh:

I kept it in web.config

<system.web>
<pages smartNavigation="true"/>
</system.web>

Thanks U Sylvester,

Regards,
JJ

query problem (with date format) in dot net

deep714-Jun-07 1:25

deep7

14-Jun-07 1:25

this query when exceuted on oracle client does show the data:

select sum(locked_items) as locked_items ,sum(total_item_count) as total_item_count , sum(failed_item_count)as failed_item_count from ita_job_audit where to_date(job_created_on,'dd/MM/yyyy') = to_date('13/06/2007', 'dd/MM/yyyy') group by worker_process_oid

but when exceuted from my asp.net application...donn get any data in the dataset..here the code:
OracleConnection conn = new OracleConnection();
DataSet ds = new DataSet();
OracleDataAdapter adapter= new OracleDataAdapter();

adapter.SelectCommand = new OracleCommand(@"select sum(locked_items) as locked_items ,sum(total_item_count) as total_item_count, sum(failed_item_count)as failed_item_count from ita_job_audit where to_date(job_created_on,'dd/MM/yyyy') = to_date('13/06/2007', 'dd/MM/yyyy') group by worker_process_oid", conn);

adapter.Fill(ds,"Jobs");

My problem is with the date format in the query...if i put some other where condition (which has no date) then it gets the data...but with this particular where condition..it donn wrk...

its something to do with how dot net send data to the oracle client...
could anyone help me out here plz..

Thanks,
Dee

Re: query problem (with date format) in dot net

andyharman14-Jun-07 3:33

andyharman

14-Jun-07 3:33

Try:

select sum(locked_items) as locked_items,
  sum(total_item_count) as total_item_count,
  sum(failed_item_count)as failed_item_count
from ita_job_audit
where to_char(job_created_on, 'dd/MM/yyyy') = '13/06/2007'
group by worker_process_oid

I think your "to_date(job_created_on,'dd/MM/yyyy')" is causing the job_created_on column to be implicitely cast to a string (using the default date format) - before you convert it back into a date.

Note that I have not been able to test this because I don't have access to Oracle at the moment.

Regards
Andy

Re: query problem (with date format) in dot net

deep714-Jun-07 18:47

deep7

14-Jun-07 18:47

Thank you Andy...it worked!
i had tried so many ways but not this way...thanks again Smile | :)

Chat coding

Sathiya Narayanan14-Jun-07 1:22

Sathiya Narayanan

14-Jun-07 1:22

i want one individual chat coding... in Dot Net... may with database or with out database..... like Google....

Sathiya

Re: Chat coding

Sathesh Sakthivel14-Jun-07 1:30

Sathesh Sakthivel

14-Jun-07 1:30

Get it[^]

Regards,

Satips. Rose | [Rose]

Help

Kartik Rathi14-Jun-07 1:16

Kartik Rathi

14-Jun-07 1:16

Can anybody tell me some site that should be converted in asp.net like some shopping site etc.
I want to make shopping site in asp.net.
Can anybody suggest me about this.

Kartik Rathi

Re: Help

Sathesh Sakthivel14-Jun-07 1:19

Sathesh Sakthivel

14-Jun-07 1:19

Hey please name your subject with Suitable topic.

For more details about the Shopping cart Petshoppee[^] download this project and it will clearly give the explanation about all your needs.

Regards,

Satips. Rose | [Rose]

Crystal Reports

teddddddddddd14-Jun-07 1:06

teddddddddddd

14-Jun-07 1:06

Hello,

How can I show picture on crystal reports? Picture insert in table.

Thank you

Re: Crystal Reports

Sathesh Sakthivel14-Jun-07 1:22

Sathesh Sakthivel

14-Jun-07 1:22

Get it[^]

Regards,

Satips. Rose | [Rose]

Data grid Problem :- Very Urgent

Devkranth Kishore Vanja14-Jun-07 0:58

Devkranth Kishore Vanja

14-Jun-07 0:58

hi...

i have a problem in datagrid.... as follows

table1
slno monthlypremium amount recovery type
2090 239908 0 abc
2 0 87534 23434 sfsdfsd
3 0 343 3434 fsdfsd

now the problem is when i diplay in datagrid it displays as follows...
but what i need is in monthlypremium the rows having 0 should have the value of recovery..

please help its very urgent Cry | :((

Re: Data grid Problem :- Very Urgent

nareshss14-Jun-07 1:08

nareshss

14-Jun-07 1:08

Hi
i didnt get ur question...

could u plz make ur question clear

wat do u mean of "value of recovery" ?

bye
naresh.s.s

Re: Data grid Problem :- Very Urgent

Devkranth Kishore Vanja14-Jun-07 3:07

Devkranth Kishore Vanja

14-Jun-07 3:07

value of recovery is nothing but the amount .... in table

Re: Data grid Problem :- Very Urgent

marky77714-Jun-07 1:37

marky777

14-Jun-07 1:37

show us your SQL

Re: Data grid Problem :- Very Urgent

pradeep kumarappagari14-Jun-07 1:43

pradeep kumarappagari

14-Jun-07 1:43

once u verify the bounded colums Data Field, i think u could have interchanged the Data Field text... Blush | :O

Pradeep Reddy

Configure SSL [modified]

Blue_Boy14-Jun-07 0:54

Blue_Boy

14-Jun-07 0:54

Hi , I am trying to configure my SSL connection bazed on
this link [^]
but when I browse my page I only get message "Page can not be displayed".
can anyone tell me how can I configure SSL connection on IIS to be able browsing website sucessfully.

Regards.

I Love SQL

How to play video using asp.net?

Ptiwari314-Jun-07 0:31

Ptiwari3

14-Jun-07 0:31