Re: [PHP] RE: [firebird-php] auto increment last insert
John Nichel wrote: Greg Donald wrote: On Thu, 25 Nov 2004 09:33:41 +0600, Raditha Dissanayake <[EMAIL PROTECTED]> wrote: many people in this list believe that people who do not RTFM are lazy and do not deserve help. That's because people who expect free help without RTFM are lazy and do not deserve help. How else do you plan to learn the language without RTFM? The knowledge isn't going to just jump into your head. Great, there goes my theory about sleeping with the PHP manual under my pillow. ;) I was thinking of doing the same but gave up because i couldn't figure out a way of clicking on the links in my printed version of the manual. -- Raditha Dissanayake. -- http://www.radinks.com/print/card-designer/ | Card Designer Applet http://www.radinks.com/upload/ | Drag and Drop Upload -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] RE: [firebird-php] auto increment last insert
On Thu, 25 Nov 2004 11:43:56 +0600, Raditha Dissanayake <[EMAIL PROTECTED]> wrote: > hey greg, don't jump on me, i was trying to say the same thing you are > saying perhaps i should have worded it better :-)) Sorry if I offended you. -- Greg Donald Zend Certified Engineer http://gdconsultants.com/ http://destiney.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] RE: [firebird-php] auto increment last insert
Greg Donald wrote: On Thu, 25 Nov 2004 09:33:41 +0600, Raditha Dissanayake <[EMAIL PROTECTED]> wrote: many people in this list believe that people who do not RTFM are lazy and do not deserve help. That's because people who expect free help without RTFM are lazy and do not deserve help. How else do you plan to learn the language without RTFM? The knowledge isn't going to just jump into your head. Great, there goes my theory about sleeping with the PHP manual under my pillow. ;) -- By-Tor.com ...it's all about the Rush http://www.by-tor.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] RE: [firebird-php] auto increment last insert
Greg Donald wrote: On Thu, 25 Nov 2004 09:33:41 +0600, Raditha Dissanayake <[EMAIL PROTECTED]> wrote: many people in this list believe that people who do not RTFM are lazy and do not deserve help. That's because people who expect free help without RTFM are lazy and do not deserve help. How else do you plan to learn the language without RTFM? The knowledge isn't going to just jump into your head. hey greg, don't jump on me, i was trying to say the same thing you are saying perhaps i should have worded it better :-)) -- Raditha Dissanayake. -- http://www.radinks.com/print/card-designer/ | Card Designer Applet http://www.radinks.com/upload/ | Drag and Drop Upload -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] RE: [firebird-php] auto increment last insert
On Thu, 25 Nov 2004 09:33:41 +0600, Raditha Dissanayake <[EMAIL PROTECTED]> wrote: > many people in this list believe that people who do not RTFM are lazy > and do not deserve help. That's because people who expect free help without RTFM are lazy and do not deserve help. How else do you plan to learn the language without RTFM? The knowledge isn't going to just jump into your head. -- Greg Donald Zend Certified Engineer http://gdconsultants.com/ http://destiney.com/ "RTFM almost daily since 1998.." -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] RE: [firebird-php] auto increment last insert
Johan van Zyl wrote: Hi Thx Helen for another non-hostile, and as usual, very informative response! We newbie's are having a though time, well at least in THIS forum! At least I am! You (me) apparently have to RTFM or FO many people in this list believe that people who do not RTFM are lazy and do not deserve help. -- Raditha Dissanayake. -- http://www.radinks.com/print/card-designer/ | Card Designer Applet http://www.radinks.com/upload/ | Drag and Drop Upload -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] RE: [firebird-php] auto increment last insert
On November 24, 2004 17:47, Johan van Zyl wrote: > It is not easy being a PHP newbie! > If I am supposed to study ALL manuals in great detail before I am allowed > to ask a question here.? > Its not that you have to read all of the manuals and books. You just need to take some time to figure out what you really want to do with your code, then compare that with what php can actually do and adjust your 'to do' list accordingly. I myself and I am sure most of the others on this list visit the manual regularly just to make sure we have the args and returns of functions correct and various other things. We have just learned to look things up before asking for help. -- Regards, David Bevan We could learn a lot from crayons: some are sharp, some are pretty, some are dull, some have weird names, and all are different colorsbut they all exist very nicely in the same box. http://www.getanyideas.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] RE: [firebird-php] auto increment last insert
On Thu, 25 Nov 2004 00:47:10 +0200, Johan van Zyl <[EMAIL PROTECTED]> wrote: > If I am supposed to study ALL manuals in great detail before I am allowed to > ask a question here.? It's not about "allowed" ( your post made it to my inbox without issue) or not, but please do consider the high-traffic nature of the list. Reading the manual goes with learning the language. If the manual doesn't answer your question then the mailing list archives http://marc.theaimsgroup.com/?l=php-general should be searched. Failing there you should try Google. If, after all that, you still have a question, then this is definitely the place to ask. -- Greg Donald Zend Certified Engineer http://gdconsultants.com/ http://destiney.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] RE: [firebird-php] auto increment last insert
Hi Thx Helen for another non-hostile, and as usual, very informative response! We newbie's are having a though time, well at least in THIS forum! At least I am! You (me) apparently have to RTFM or FO And thx to all the other POSITIVE responses I have had! It is REALLY appreciated. It is not easy being a PHP newbie! If I am supposed to study ALL manuals in great detail before I am allowed to ask a question here.? Greetings JVZ -Original Message- From: Helen Borrie [mailto:[EMAIL PROTECTED] Sent: 25 November 2004 00:23 To: [EMAIL PROTECTED] Subject: RE: [firebird-php] auto increment last insert At 09:01 AM 25/11/2004 +1100, you wrote: >I've just arrived in the office - did this thread get completed? >Is the original poster satisfied with the information? > >Basically, a set-by-step approach to replacing MySQL's autoinc, without >procedures, triggers, and trying to get the value after the insert(could be >inaccurate if the generator's been used since the insert...) > >This example will use the following simple table: >CREATE TABLE tbl_test ( > int_ID NUMERIC(18,0) NOT NULL, > str_name VARCHAR(100), >PRIMARY KEY(int_ID) >); >/* This is the generator for the tbl_test table */ >CREATE GENERATOR gen_tbl_test; For safety, you should also create a trigger, in case the database is used by other applications at some point: CREATE TRIGGER BI_tbl_test for tbl_test ACTIVE BEFORE INSERT AS BEGIN IF (new.int_ID IS NULL) THEN new.int_ID = GEN_ID(gen_tbl_test, 1); END ^ Yahoo! Groups Sponsor Get unlimited calls to U.S./Canada -- 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: [EMAIL PROTECTED] c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.799 / Virus Database: 543 - Release Date: 2004/11/19