Search results for query: *

Yep thank you very much. Frank

I'm trying to understand a system I currently working with. This following line calls a function from the component. There are 2 possibikities, but I don't know which one. Can anyone shed some light? Thanks ;) This is the line in asp: *** objGrantee.PartyName =...

A figure of speach, it basicly means "Just my opinion".

Thank you very much, it wasn't former, but forward,but that was the problem. Thanks ;)

I'm trying to get a list of all the numbers for which the parent of that number and the parent of that numbers formers aren't the same. Every number has a parent. A number can also have a forward( a number that was create before the current number was created) number and a former number( a...

The problems are fixed, when nothing seems wrong, stupid problems are often the cause eheh.

The values for icounter and counter are fine. I made so that takes all the values including 253. But I still get the same problem...this is really odd...it's like if it was executing if icounter = ubound(arrwords2) then tempSql = tempSql & strSQL & " AND...

Hi guys, I have a looping problem that I can't find right now. This is the sql query when I execute this code: SELECT iogc_instrument.instrument_number, iogc_instrument.iogc_agreement_number FROM ilrs.iogc_instrument WHERE iogc_instrument.instrument_number IN...

string literal too long is the error I'm getting by using this code. I'm assuming this is because I'm creating a huge SQL statment. Is that the problem? IF so does anyone know how I could fix this? Thanks for taking the time to read, it's really appreciated. do while icounter <=...

ORA-01795: maximum number of expressions in a list is 254 Is the error that keeps haunting me with either the code above or what I wrote: do while icounter <= ubound(arrwords) invalues = invalues & arrwords(icounter) & &quot;,&quot; icounter = icounter + 1 if icounter = ubound(arrwords)...

Here's what I want to do. I want to use the select statment with the in function. All the values I want to use in the in function are stored in the arrwords array. I use invalues to store the first 254 values and add them to the select statment. I empty invalues. Start the whole process...

I tryed to fix some of the problems. This is what I came up with. I still get the same problem though. dim arrWords, iLen, icounter, counter, inValues arrWords = split(strInstruments,&quot;,&quot;) do while icounter <= ubound(arrwords) invalues = invalues & arrwords(icounter) &...

Thank you very much, I'll start fixing those problems ASAP.

Guys, I'm trying to create a statement that will allow me to have more then 254 values in an in statement. I'm trying to do this with the following statment. When I try to use it I get a scripttimeout error, even if I increase the timeout. I'm baffaled, I don't know what the problem could be...

Thank you very much, I don't have time to try it right now, but it's a very good start.

Is there a way to cut a string in 2 once a delimiter has been seen x amount of times? This is what I'd be starting with: string = (bob,june,sally,eric,joel) This is what I would have at the end: string1 = (bob,june) string2 = (sally,eric,joel) Thanks for taking the time to read and write ;)

Yep that was the problem, thank you very much.

Odd, I get a different result with these 2 queries. select distinct i.number, eot.sequence, eot.anotherfield, eot.description /*select distinct count(*) as &quot;Number of rows without EOT&quot;*/ from inst i, inst_player ip, ownership o, electronic_output_title eot where i.number = ip.number...

Thanks guys!

Is it possible to count the number of null values found in one column? Thanks for taking the time to read and answer ;)