Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. FranckM

    VB 6 components

    Yep thank you very much. Frank
  2. FranckM

    VB 6 components

    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 =...
  3. FranckM

    ASP VS SQL

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

    Query problem?

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

    Query problem?

    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...
  6. FranckM

    looping problem

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

    looping problem

    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...
  8. FranckM

    looping problem

    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...
  9. FranckM

    string literal too long

    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 <=...
  10. FranckM

    Infininate loop problem? going beyong 254 values for in function

    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)...
  11. FranckM

    Infininate loop problem? going beyong 254 values for in function

    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...
  12. FranckM

    Infininate loop problem? going beyong 254 values for in function

    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) &...
  13. FranckM

    Infininate loop problem? going beyong 254 values for in function

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

    Infininate loop problem? going beyong 254 values for in function

    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...
  15. FranckM

    Cutting a string in 2 when a delimiter has been seen after x times?

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

    Cutting a string in 2 when a delimiter has been seen after x times?

    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 ;)
  17. FranckM

    How do I count nulls?

    Yep that was the problem, thank you very much.
  18. FranckM

    How do I count nulls?

    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...
  19. FranckM

    How do I count nulls?

    Thanks guys!
  20. FranckM

    How do I count nulls?

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

Part and Inventory Search

Back
Top