On Tue, 2004-03-02 at 16:55, Andrew Piskorski wrote: > I did not work right when I tried it (strange errors; ...
For me, nsodbc didn't even compile. > :) Well, I still have it in my local CVS. Looks like I just copied > 480 lines of bind variable emulation code from postgres.c rev. 1.31 > 2001/08/24 and dropped it into the nsodbc_v1 code. So I guess it > really was easy. I think it worked the first time even. I'll look into the code for adding the command. I remember looking at it and wondering if it was used in OpenACS? > Of course, maybe it would really be better to have a "nsbindvaremu.so" > module for use by nspostgres, nsodbc, etc. Hmm, maybe a great idea here. > Hm, maybe that should actually be movded into the standard ns_db API? > I never looked closely but there's other stuff like that too, LOBs, > etc. It would be kind of nice if there was one standard ns_db > interface to such extended features, brainstorm time, anyone else have ideas? > Dunno, I never looked much at how the bind variable emulation actually > worked, I just figured the OpenACS guys who wrote it must have known > what they were doing and slapped it in. :) Umm, I think I was definitely confused by the idea of stored procedures. Initially I thought they were just named procedure calls already in the database. Somewhere along the way I read the scant AOLserver description of how to use the store procedure calls. They had a "create procedure..." in there, so I thought you could write whatever you wanted. I think it turns out I was right in my first thought, so I doubt you could do what I was thinking. _But_ the example shows that you can return rows from the database besides the out variables. If stored procedures can return rows, that would be a nice alternative to sending a copy of the select statement every time you need data. Does anyone (probably AOL) have examples of how stored procedures are used via ns_db? tom jackson -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.
