But a page in PHP is, by default, one transaction. If you don't specifically
start another transaction, you should be OK to do wht you're suggesting.
-----Original Message-----
From: Nigel Weeks [mailto:nweeks@...]
Sent: Wednesday, November 17, 2004 2:47 PM
To: firebird-php@yahoogroups.com
Subject: RE: [firebird-php] SPs Docs


You've hit the nail on the head right there! Well done!

You might come to a point (in your application) where you need two
transactions open, you've used a selectable procedure to do both an
insert,
and a return of a dataset, and until you commit, the new record is
invisible
to all other transactions.

If you then use your new value in another transaction context, the sky
will
fall on your head...

Apparently there's a better way to get new inserted ID's from am insert
via
PHP...

Nige.

> -----Original Message-----
> From: Alan McDonald [mailto:alan@...]
> Sent: Wednesday, 17 November 2004 2:38 PM
> To: firebird-php@yahoogroups.com
> Subject: RE: [firebird-php] SPs Docs
>
>
>
> I don't do it this way by default but I don't see what the
> problem might
> be... It's all happening in the same transaction
> Alan
> -----Original Message-----
> From: Nigel Weeks [mailto:nweeks@...]
> Sent: Wednesday, November 17, 2004 2:31 PM
> To: firebird-php@yahoogroups.com
> Subject: RE: [firebird-php] SPs Docs
>
>
> It's just been revealed that my posts for this thread could cause
> problems,
> and aren't the
> best way of using Stored Procedures from PHP.
>
> Specifically, there are issues regarding DML operations,
> and returning
> rows
> in the same stored procedure.
>
> I'm going to do some learning...and might have to do some
> re-writing...
>
> Nige.
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
>
> --------------------------------------------------------------
> --------------
> --
> Yahoo! Groups Links
>
> a.. To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-php/
>
> b.. To unsubscribe from this group, send an email to:
> firebird-php-unsubscribe@yahoogroups.com
>
> c.. Your use of Yahoo! Groups is subject to the Yahoo!
> Terms of Service.
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~-->
> $9.95 domain names from Yahoo!. Register anything.
> http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/PhFolB/TM
> --------------------------------------------------------------
> ------~->
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>

Yahoo! Groups Sponsor
ADVERTISEMENT





----------------------------------------------------------------------------
--
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-php/

b.. To unsubscribe from this group, send an email to:
firebird-php-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]