Asp Forum - parajumpers online shop herren Kshienm - microsoft.public.inetserver.asp.general

pcsgdoch

12/27/2013 4:27:00 PM

<a href=http://www.viniplanete.fr/2013/12/06/manteaux-canadian-grove/&g... canadian grove</a> There'll be lots to discuss as the way ahead becomes clear. As part of the deal, UBS customers with less than $1 million in auction-rate securities will get their money back by Oct. <a href=http://www.nilzaboden.se/parajumpers-jacka-herr-c-1/>P... Jacka Herr</a> Nvsyhx <a href=http://www.canadagoosparis.fr/canada-goose-constable-parka-c-22_30/doudoune-canada-goose-constable-parka-noir-homme-pas-cher-online-p-84.html&g... Canada Goose Constable Parka noir homme pas cher online</a>
<a href=http://www.anartisteprod.fr/2013/12/canada-goose-boutique-en-ligne/... goose boutique en ligne</a> Eulqfy The beige and gold color and small size was something missing in my bag collection. <a href=http://www.ateliermosaiquetess.fr/canada-goose-couple-c-57/vente-banff-parka-homme-noire-chilliwack-parka-femme-rouge-en-ligne-paris-p-201.htm... Banff Parka Homme Noire Chilliwack Parka Femme Rouge En Ligne Paris</a>
<a href=http://www.bengansror.se/officiella-parajumpers-gobi-bomber-dunjacka-svarta-kvinnor-webbutik>... Parajumpers Gobi Bomber dunjacka svarta kvinnor webbutik</a> 3265291127

11 Answers

Miha Markic

10/2/2007 9:11:00 AM

"David Thielen" <thielen@nospam.nospam> wrote in message
news:8C6845BE-7A1C-4255-8ADC-F9625CC3D3B5@microsoft.com...
> We are using the MS, not the Oracle connector. Here are the selects that
> are
> failing:
>
> select peerReviewMeetingDurationHrs from reviewcustom
>
> select distinct softwareBuildRevisionOrVersion from reviewcustom
>
> select distinct "Action Items & Disposition" from reviewcustom
>
> The third one causes a prompt which doesn't work as it's an ADO.NET call.

I'd assume quotes are causing problems. Did you try using single quotes or
square brackets instead?

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_...

David Thielen

10/2/2007 4:09:00 PM

Good catch - the [] solved the third one. The first 2 still no go...

--
thanks - dave
david_at_windward_dot_net
http://www.windwardr...

Cubicle Wars - http://www.windwardr.../film.htm

"Miha Markic" wrote:

>
> "David Thielen" <thielen@nospam.nospam> wrote in message
> news:8C6845BE-7A1C-4255-8ADC-F9625CC3D3B5@microsoft.com...
> > We are using the MS, not the Oracle connector. Here are the selects that
> > are
> > failing:
> >
> > select peerReviewMeetingDurationHrs from reviewcustom
> >
> > select distinct softwareBuildRevisionOrVersion from reviewcustom
> >
> > select distinct "Action Items & Disposition" from reviewcustom
> >
> > The third one causes a prompt which doesn't work as it's an ADO.NET call.
>
> I'd assume quotes are causing problems. Did you try using single quotes or
> square brackets instead?
>
> --
> Miha Markic [MVP C#, INETA Country Leader for Slovenia]
> RightHand .NET consulting & development www.rthand.com
> Blog: http://cs.rthand.com/blogs/blog_with_...
>
>

v-wywang

10/3/2007 8:53:00 AM

Hello Dave,

Your first 2 select query string seems fine.
I tried it on my Oracle Express 10g machine.

I created the table as below
create table reviewcustom(
softwareBuildRevisionOrVersion Number(8,2),
peerReviewMeetingDurationHrs Number(8,2)
)

Execute the query in .net application as below
System.Data.OracleClient.OracleConnection oc = new
System.Data.OracleClient.OracleConnection();
System.Data.OracleClient.OracleCommand ocd = new
System.Data.OracleClient.OracleCommand();
ocd.Connection = oc;
ocd.CommandText = @"select peerReviewMeetingDurationHrs from reviewcustom";
// I also tried another query
//ocd.CommandText = @"select distinct softwareBuildRevisionOrVersion from
reviewcustom";
int flg=ocd.ExecuteNonQuery();
Console.WriteLine(flg);
Console.Read();

It works fine. I failed to reproduce the issue. Would you please try the
above method and let me know the result? Does it work fine on your side? I
suspect the column name is not the root accuse of the issue. Is it possible
for you to send me the database files? I will try to repro the issue again.
My alias is v-wywang@microsoft.com

Have a great day,
Best regards,

Wen Yuan
Microsoft Online Community Support
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Miha Markic

10/3/2007 11:51:00 AM

WenYuan,

I suggest you to obfuscate your e-mail address (they have to be readable to
human though). It is enough if you inject some obvious words, such as
NOSPAM, HATESPAM, etc.
Unless you want spam, of course ;-)

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_...

"WenYuan Wang [MSFT]" <v-wywang@online.microsoft.com> wrote in message
news:71xWHrZBIHA.6080@TK2MSFTNGHUB02.phx.gbl...
> Hello Dave,
>
> Your first 2 select query string seems fine.
> I tried it on my Oracle Express 10g machine.
>
> I created the table as below
> create table reviewcustom(
> softwareBuildRevisionOrVersion Number(8,2),
> peerReviewMeetingDurationHrs Number(8,2)
> )
>
> Execute the query in .net application as below
> System.Data.OracleClient.OracleConnection oc = new
> System.Data.OracleClient.OracleConnection();
> System.Data.OracleClient.OracleCommand ocd = new
> System.Data.OracleClient.OracleCommand();
> ocd.Connection = oc;
> ocd.CommandText = @"select peerReviewMeetingDurationHrs from
> reviewcustom";
> // I also tried another query
> //ocd.CommandText = @"select distinct softwareBuildRevisionOrVersion from
> reviewcustom";
> int flg=ocd.ExecuteNonQuery();
> Console.WriteLine(flg);
> Console.Read();
>
> It works fine. I failed to reproduce the issue. Would you please try the
> above method and let me know the result? Does it work fine on your side? I
> suspect the column name is not the root accuse of the issue. Is it
> possible
> for you to send me the database files? I will try to repro the issue
> again.
> My alias is v-wywang@microsoft.com
>
> Have a great day,
> Best regards,
>
> Wen Yuan
> Microsoft Online Community Support
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>

David Thielen

10/3/2007 3:46:00 PM

Miha - totally off-topic question for you. Do you know of a website where I
can buy Slovenian pop music CDs for delivery to the US? And if possible pop
music from other countries in the Balkans?

I'm a big Eurovision fan and you cannot find non-American artists here in
the US.

--
thanks - dave
david_at_windward_dot_net
http://www.windwardr...

Cubicle Wars - http://www.windwardr.../film.htm

"Miha Markic" wrote:

> WenYuan,
>
> I suggest you to obfuscate your e-mail address (they have to be readable to
> human though). It is enough if you inject some obvious words, such as
> NOSPAM, HATESPAM, etc.
> Unless you want spam, of course ;-)
>
> --
> Miha Markic [MVP C#, INETA Country Leader for Slovenia]
> RightHand .NET consulting & development www.rthand.com
> Blog: http://cs.rthand.com/blogs/blog_with_...
>
> "WenYuan Wang [MSFT]" <v-wywang@online.microsoft.com> wrote in message
> news:71xWHrZBIHA.6080@TK2MSFTNGHUB02.phx.gbl...
> > Hello Dave,
> >
> > Your first 2 select query string seems fine.
> > I tried it on my Oracle Express 10g machine.
> >
> > I created the table as below
> > create table reviewcustom(
> > softwareBuildRevisionOrVersion Number(8,2),
> > peerReviewMeetingDurationHrs Number(8,2)
> > )
> >
> > Execute the query in .net application as below
> > System.Data.OracleClient.OracleConnection oc = new
> > System.Data.OracleClient.OracleConnection();
> > System.Data.OracleClient.OracleCommand ocd = new
> > System.Data.OracleClient.OracleCommand();
> > ocd.Connection = oc;
> > ocd.CommandText = @"select peerReviewMeetingDurationHrs from
> > reviewcustom";
> > // I also tried another query
> > //ocd.CommandText = @"select distinct softwareBuildRevisionOrVersion from
> > reviewcustom";
> > int flg=ocd.ExecuteNonQuery();
> > Console.WriteLine(flg);
> > Console.Read();
> >
> > It works fine. I failed to reproduce the issue. Would you please try the
> > above method and let me know the result? Does it work fine on your side? I
> > suspect the column name is not the root accuse of the issue. Is it
> > possible
> > for you to send me the database files? I will try to repro the issue
> > again.
> > My alias is v-wywang@microsoft.com
> >
> > Have a great day,
> > Best regards,
> >
> > Wen Yuan
> > Microsoft Online Community Support
> > ==================================================
> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >
>
>

David Thielen

10/3/2007 3:47:00 PM

I copied and tried this (sorry, I should have done this first) and it works.
Ok, we'll dive into our DB and figure out what is going on. Oracle is
definitely NOT my favorite...

--
thanks - dave
david_at_windward_dot_net
http://www.windwardr...

Cubicle Wars - http://www.windwardr.../film.htm

"WenYuan Wang [MSFT]" wrote:

> Hello Dave,
>
> Your first 2 select query string seems fine.
> I tried it on my Oracle Express 10g machine.
>
> I created the table as below
> create table reviewcustom(
> softwareBuildRevisionOrVersion Number(8,2),
> peerReviewMeetingDurationHrs Number(8,2)
> )
>
> Execute the query in .net application as below
> System.Data.OracleClient.OracleConnection oc = new
> System.Data.OracleClient.OracleConnection();
> System.Data.OracleClient.OracleCommand ocd = new
> System.Data.OracleClient.OracleCommand();
> ocd.Connection = oc;
> ocd.CommandText = @"select peerReviewMeetingDurationHrs from reviewcustom";
> // I also tried another query
> //ocd.CommandText = @"select distinct softwareBuildRevisionOrVersion from
> reviewcustom";
> int flg=ocd.ExecuteNonQuery();
> Console.WriteLine(flg);
> Console.Read();
>
> It works fine. I failed to reproduce the issue. Would you please try the
> above method and let me know the result? Does it work fine on your side? I
> suspect the column name is not the root accuse of the issue. Is it possible
> for you to send me the database files? I will try to repro the issue again.
> My alias is v-wywang@microsoft.com
>
> Have a great day,
> Best regards,
>
> Wen Yuan
> Microsoft Online Community Support
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>

Miha Markic

10/3/2007 6:26:00 PM

You might have permission problems...

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_...

"David Thielen" <thielen@nospam.nospam> wrote in message
news:3324DAD6-1D29-4D46-8911-DA2D404315F7@microsoft.com...
>I copied and tried this (sorry, I should have done this first) and it
>works.
> Ok, we'll dive into our DB and figure out what is going on. Oracle is
> definitely NOT my favorite...

v-wywang

10/4/2007 6:48:00 AM

Thanks for your advice, Miha.
I will obfuscate it next time. :)

Have a great day,
Best regards,

Wen Yuan
Microsoft Online Community Support
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

v-wywang

10/4/2007 8:40:00 AM

Hello Dave,
Thanks for your reply.

I'm standing by. If there is anything we can help with, please feel free to
let me know.
We are glad to assist you.

Have a great day,
Best regards,

Wen Yuan
Microsoft Online Community Support
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

David Thielen

10/4/2007 3:29:00 PM

The DBA did something and now it's fixed.

--
thanks - dave
david_at_windward_dot_net
http://www.windwardr...

Cubicle Wars - http://www.windwardr.../film.htm

"WenYuan Wang [MSFT]" wrote:

> Hello Dave,
> Thanks for your reply.
>
> I'm standing by. If there is anything we can help with, please feel free to
> let me know.
> We are glad to assist you.
>
> Have a great day,
> Best regards,
>
> Wen Yuan
> Microsoft Online Community Support
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>

microsoft.public.inetserver.asp.general

parajumpers online shop herren Kshienm

pcsgdoch

Miha Markic

David Thielen

v-wywang

Miha Markic

David Thielen

David Thielen

Miha Markic

v-wywang

v-wywang

David Thielen

x Login to ForumsZone