Dear Berlino, Maybe its true what you say .. but why can you how us how you do it .. and help other pple ? thanks in advice Wan
-----Mensaje original----- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Bernino Lind Enviado el: jueves, 26 de junio de 2003 11:10 Para: [EMAIL PROTECTED]; [EMAIL PROTECTED] Asunto: [JDEV] MORE EXAMPLES! - FW: [jadmin] Complex DTD=2 SQL Dear Sirs, A little criticism... I have been flooded with emails to me directly with people asking for my code in how I do what ever special twists with the Jabber server. That should be a clear indication to the developers and the documentation facilitators that a lot of documentation in examples is necessary when it comes to simple standard manipulation of server side jabber. Here is an example of my point, being that like myself 3 weeks ago, I did not know what the actual iq packets should look like... Names have been foo'ed out. Best regards, Bernino -----Original Message----- From: John Doe [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 5:51 PM To: Bernino Lind Subject: RE: [jadmin] Complex DTD=2 SQL yes i check it out.. what do you send to jabber to make that query ? hope you can explain it a little bit more. Doe -----Mensaje original----- De: Bernino Lind [mailto:[EMAIL PROTECTED] Enviado el: mi�rcoles, 25 de junio de 2003 15:46 Para: 'John Doe' Asunto: RE: [jadmin] Complex DTD=2 SQL Dear Doe, Check out my example in a previous mail in the mail list. Reply me if you cant find it, I shall dig in my sent folder... Best, Bernino -----Original Message----- From: John Doe [mailto:[EMAIL PROTECTED] Sent: Thursday, June 26, 2003 3:32 AM To: [EMAIL PROTECTED] Subject: RE: [jadmin] Complex DTD=2 SQL Importance: High hi bernino ! can i ask you something .. did you have to code something or just you add the querydeff and then u can use it on jabber.. can u guide me on this ? thanks ! Doe -----Mensaje original----- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Bernino Lind Enviado el: mi�rcoles, 25 de junio de 2003 9:29 Para: [EMAIL PROTECTED]; [EMAIL PROTECTED] Asunto: [jadmin] Complex DTD=2 SQL Dear all, I need a bit of adwise. I have a working simple dtd="2" sql set/get pair with my own namespace. I need to make these more sql queries more complex by adding more variables in my select statements. I can do this no problem with my update/insert with bindvar tag=... but with select I hit problems, which I cant resolve...: My select in xdb_sql.xml / queredef: <querydef name="score-get" dtd="2" type="get" namespace="lind:score"> <text>SELECT * FROM score WHERE gameid = '$$gameid$$' AND username = '$$user$$'</text> <user>$$user$$</user> <bindvar tag="gameid">$$gameid$$</bindvar> <top-result> <x xmlns='lind:score'/> </top-result> <tuple-node><item/></tuple-node> <bindcol tag="sid" offset="0"/> <bindcol tag="username" offset="1"/> <bindcol tag="gameid" offset="2"/> <bindcol tag="score" offset="3"/> <bindcol tag="date" offset="4"/> </querydef> </queries> What happens when I fire off my xml is that the type="set" works just fine, but firing off a gives a warning: WARNING: pg_atoi: zero-length string Which I guess means that gameid is null, even though my iq packet is good: <iq type="get"> <query xmlns='lind:score'> <gameid>123</gameid> </query> </iq> And theres something in it: jdb=# SELECT * FROM score WHERE gameid = '123' AND username = '[EMAIL PROTECTED]'; sid | username | gameid | score | date -----+-------------------+--------+--------+---------------------------- 10 | [EMAIL PROTECTED] | 123 | 234234 | 2003-06-17 15:42:41.611469 12 | [EMAIL PROTECTED] | 123 | 234234 | 2003-06-17 16:12:12.182216 13 | [EMAIL PROTECTED] | 123 | 234234 | 2003-06-25 15:31:02.446713 14 | [EMAIL PROTECTED] | 123 | 234234 | 2003-06-25 15:31:11.871944 15 | [EMAIL PROTECTED] | 123 | 234234 | 2003-06-25 16:02:51.309132 (5 rows) When I change the querydef to have just say username - no problem, it selects and outputs the way I want it... Help, Best Regards Bernino Lind _______________________________________________ jadmin mailing list [EMAIL PROTECTED] http://mailman.jabber.org/listinfo/jadmin _______________________________________________ jdev mailing list [EMAIL PROTECTED] http://mailman.jabber.org/listinfo/jdev _______________________________________________ jdev mailing list [EMAIL PROTECTED] http://mailman.jabber.org/listinfo/jdev
