Mailing List Archive: 49091 messages
  • Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search
 

[REBOL] RE : RE : MSSQL results

From: fmarcia:marcopoly at: 2-Oct-2002 9:40

Hi Scott, I agree with you: it's not specific to MSSQL. I'm using this kind of code, like specified in documentation: order: copy command Then, I'm using clients word. I tried to copy from command port a second time but it doesn't work. In any case, I just can retrieve the first set of data :-( I'm new with Rebol... is there another way to request the data from the port? Franck. -----Message d'origine----- De=A0: G. Scott Jones [mailto:[gscottjones--mchsi--com]] Envoy=E9=A0: mardi 1 octobre 2002 18:39 =C0=A0: [rebol-list--rebol--com] Objet=A0: [REBOL] RE : MSSQL results Hi, Franck, From: "Franck MARCIA"
> I'm trying to retrieve several sets of data from an unique > stored procedure. > > For example, the following stored procedure: > CREATE PROCEDURE getOrder @MY_ID int > AS > SELECT * FROM orders where order_id = @MY_ID > SELECT * FROM orders_details where order_id = @MY_ID > GO > > called by: insert command "getOrder 1234" > > just returns the first set of data. > > Is there a way to retrieve the two sets?
And later ... From: "Franck MARCIA"
> Nobody's got an answer? > > Is there something like the "mydb_next_result" of PHP with Rebol?
I've no specific experience with REBOL in conjunction with MSSQL, especially in regard to stored procedures. However, the answer may be more generic than just REBOL interacting with MSSQL. After you use: insert command "getOrder 1234" how are you requesting the data from the port? --Scott Jones