question Doubt In Vb And Sql

[sqlhelp]

Vb and sql server  help 

 

oka query undi in vb code like this 

 

" select ID, " + _

"person" + _

 "from" + _

"industry" + _

" where  person IN 

" and cost > 0 "

 

or simply like below .. 

 

select ID,person from industry 

where person IN  " + p_List + " " + _

and cost > 0

 

p_list ni illa define chesi undi 

 

iTypelen = Len(p_TypeIDs)

p_List = sOpenParen & p_TypeIDs.Substring(0, iTypelen - 1) & sCloseParen

 

idhe data nenu sql lo retrieve cheyali ante ela cheyali query 

How to get the value of p_list IN operator use chesthu in sql ? 

 

can someone please help me  I am really a beginner in vb.net

[akkupakshi]

LTT for expert suggestions 

[puli_keka]

LTT

 

nee question lo last ki clarity miss ayyindhi like what you want to achieve

[sqlhelp]

ltt 

[150bryant]

P List values ela unayoo post chey..

if u know one of the plist values tht shd come in ur result..take tht exampl and see what the vb code is doing wit it..

it might be lookin for a particular string or pattern in the plist id

[mtkr]

p_List  information ni fire cheyyi... values chudadaaniki...

 

use

 

Dts.Events.FireInformation(-1, "PListValues", p_List.ToString(), String.Empty, 0, False)

[Tadika]

Hi mtkr mamu

[mtkr]

Hi mtkr mamu

whtsupp maayyaa..
emo full dhandayaatra chestunnatunnavv!!!

[sqlhelp]

p_List  information ni fire cheyyi... values chudadaaniki...

 

use

 

Dts.Events.FireInformation(-1, "PListValues", p_List.ToString(), String.Empty, 0, False)

 

sql lo kavali naku vatti values 

[ipaddress0]

sql lo kavali naku vatti values 

vb script lo aa variable ni ekkad aite declare sestunnaro aa part of code lo aa values kosam vethuku

[Darshwana]

if i am not wrong... u r trying to rewrite a legacy app in .net 

 

asalu reqt cheppu ... dhani bati code suggest cheyochu as in what u r trying to achieve from func point of view... old code mimic cheyatam might not be a good design

[Vankay]

select * from industry where person in ('<value1>','<value2>'......);

[Vankay]

put that plist in with clause..and select from that list..simple..

[mtkr]

n nuv exact P_List condition/clause query kosam searching aithe.. trace back from last  to first...

 

iTypelen = Len(m_TypeIDs)

p_List = sOpenParen & p_TypeIDs.Substring(0, iTypelen - 1) & sCloseParen

 

 

so sOpenParen = (

 sCloseParen = )

 

p_TypeIDs.Substring(0, iTypelen - 1) = paina ekkado p_typeIDs kosam separate query untadi chudu....

so aa p_type ids lo annitini substring chestunndau...

 

substring starting position is 0 and end position is length of m_TypeIDs

 

so m _type ids kuda paina ekkado query chesthunnadu....

 

 

ne entire script post cheyyagalav ante we can try to trace it back

 

 

[sqlhelp]

n nuv exact P_List condition/clause query kosam searching aithe.. trace back from last  to first...

 

iTypelen = Len(m_TypeIDs)

p_List = sOpenParen & p_TypeIDs.Substring(0, iTypelen - 1) & sCloseParen

 

 

so sOpenParen = (

 sCloseParen = )

 

p_TypeIDs.Substring(0, iTypelen - 1) = paina ekkado p_typeIDs kosam separate query untadi chudu....

so aa p_type ids lo annitini substring chestunndau...

 

substring starting position is 0 and end position is length of m_TypeIDs

 

so m _type ids kuda paina ekkado query chesthunnadu....

 

 

ne entire script post cheyyagalav ante we can try to trace it back

 

nenu code wrong post chesanu m_typeIDs kadhu its p_TypeIDs only 

 

so ila undi 

 

iTypelen = Len(p_TypeIDs)

p_List = sOpenParen & p_TypeIDs.Substring(0, iTypelen - 1) & sCloseParen

 

pm cheshtuna