ok, i just returned all the data in 1 string and split it on the client side to get the data i needed "return var1 + "/" + var2 + "/" + var3;"
the echoservice.java was a big help. thanks for the help donald Ruben Waitz wrote: > I agree with Storm to call a client method from the server. > > > > For example you can build a list or an array of objects of your mysql > resultset and return that to the client. > > Great examples are in the red5 distro. Find it in EchoService.java > > > > Regards, > > Ruben > > > > > > -----Oorspronkelijk bericht----- > Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens Storm > Verzonden: donderdag 15 maart 2007 0:09 > Aan: [email protected] > Onderwerp: Re: [Red5] mysql results > > > > not quite sure but i suppose you can set data in a Shared object from server > so if clients are connected to it they'll be notified and could access to > that. > However you can always call a client method (method that should be in your > netconnection class) from server and pass the result as an argument in an > array or something. > > good luck > > On 3/14/07, Donald <[EMAIL PROTECTED]> wrote: > > I finally got java talking to my DB server and working correctly. > Inserting data is no problem. however i can find anything on how to > loop through the results of a select query and send the results back to > the client side > i have the following code looping through the results and printing it > back to the system but i need > it to go to the client side > > queryresult = stmt.executeQuery("SELECT * " + > "from test123 ORDER BY id"); > System.out.println("results are "); > while(queryresult.next()){ > int idnum= queryresult.getInt("id"); > System.out.println ( idnum); > } > > any ideas? > > Donald > > > > _______________________________________________ > Red5 mailing list > [email protected] > http://osflash.org/mailman/listinfo/red5_osflash.org > > > > > _______________________________________________ Red5 mailing list [email protected] http://osflash.org/mailman/listinfo/red5_osflash.org
