[Solved]_ERROR: Nested "With" statements are not allowed

[goldenix]

I have this table structure & Im trying to return all Tags with same Hash

If you know any other UDF pls let me know. this is the UDF i took it from:

http://www.autoitscript.com/forum/index.ph...=20814&st=0

1) get hash ID

2) use hash ID to find out wich tag_IDS have same Hash ID

3) return all Tags with same hash ID

But i get error:

TEMP.au3 (64) : ==> Nested "With" statements are not allowed.:
With $Query2
^ ERROR

$Table = hash_table

==========================

ID_Hash = 1 Hash = Fish

$Table = Tag_table

==========================

ID_Tag = 1 Tag = blue

ID_Tag = 2 Tag = yellow

ID_Tag = 3 Tag = green

ID_Tag = 4 Tag = red

$Table = ids_hash_tag

==========================

ID_Hash = 1 ID_tag = 1

ID_Hash = 1 ID_tag = 2

ID_Hash = 1 ID_tag = 3

ID_Hash = 1 ID_tag = 4

$table  = 'ids_hash_tag'
;~ -
$fields = "ID_Tag"

$Query = _Query($sql,"SELECT * FROM "&$table&" WHERE ID_HAsh = '" &$hash_ID& "'") 
    With $Query
    While NOT .EOF
;~      $hash_ID = .Fields($fields).value
        
         _final_tag("1");===================< Function!  imagine we found ID already & it is 1
         
    .MoveNext
    WEnd
    EndWith
;~ -------------------------------------    
;~ Finally return TAGS
Func _final_tag($hash_ID_2)
    $table  = 'tag_table'
    ;~ -
    $fields = "Tag_Title"

    $Query2 = _Query($sql,"SELECT * FROM "&$table&" WHERE Tag_Title = '" &$hash_ID_2& "'") 

        With $Query2;=====================================< This is where it errors!

        While NOT .EOF
            $hash_ID_2 = .Fields($fields).value          
            ConsoleWrite($hash_ID_2 & @CRLF)
        .MoveNext
        WEnd
        EndWith 
EndFunc

Edited June 5, 2009 by goldenix

[martin]

If nested With statements are not allowed then couldn't you just change the function to

Func _final_tag($hash_ID_2)
    $table  = 'tag_table'
   ;~ -
    $fields = "Tag_Title"

    $Query2 = _Query($sql,"SELECT * FROM "&$table&" WHERE Tag_Title = '" &$hash_ID_2& "'") 

       
        While NOT $Query2.EOF
            $hash_ID_2 = $Query2.Fields($fields).value  
           ConsoleWrite($hash_ID_2 & @CRLF)
        $Query2.MoveNext
        WEnd
       
EndFunc

[goldenix]

this is the first time I see this kind of code, no wonder i dont know what to do with it:

With $Query
    While NOT .EOF

But thanx your solution does work.