Thought I was on track, but stumped again... I am now getting a completely different error that I cannot figure out how it is related. I have passed the $td variable into the function and then get it back as a POST variable from a hidden field within the function. Here is the error I am now seeing; Unknown column 'sn4265' in 'field list' This one is really throwing me at the moment as the only place the value sn4265 is stored is in the $sbcuid variable. This $sbcuid variable is not a part of the INSERT that I am performing which I think is generating this error. I am guessing that you guys will need more info to help out with this now. Just let me know what you want. Thanks again. -----Original Message----- From: CPT John W. Holmes [mailto:holmes072000@charter.net] Sent: Thursday, June 05, 2003 10:07 AM To: NIPP, SCOTT V (SBCSI) Subject: Re: Datetime help in an INSERT... Just pass the variable to your function. If you're using a form, then make it a hidden element. ---John Holmes... ----- Original Message ----- From: "NIPP, SCOTT V (SBCSI)" <sn4265@sbc.com> To: "'CPT John W. Holmes'" <holmes072000@charter.net> Sent: Thursday, June 05, 2003 10:53 AM Subject: RE: Datetime help in an INSERT... > Do you think URL propagation is a better option than passing another > variable into the function and then passing it back out through a hidden > form element? Here was another snippet from another suggestion on this. > > a button is being pressed? > so it is processing a form? > if its in a form just pass along the value of $td via hidden input data... > > <input type="hidden" name="td" value="<? echo $td; ?>"> > > jay merritt > jay@advmed.com > jaycell@advmed.com > > -----Original Message----- > From: CPT John W. Holmes [mailto:holmes072000@charter.net] > Sent: Thursday, June 05, 2003 9:53 AM > To: NIPP, SCOTT V (SBCSI) > Subject: Re: Datetime help in an INSERT... > > > Propagating it in the URL is probably the best method. > > ---John Holmes... > > ----- Original Message ----- > From: "NIPP, SCOTT V (SBCSI)" <sn4265@sbc.com> > To: "'CPT John W. Holmes'" <holmes072000@charter.net>; <jay@advmed.com> > Cc: <php-db@lists.php.net> > Sent: Thursday, June 05, 2003 10:44 AM > Subject: RE: Datetime help in an INSERT... > > > > OK. I guess the next question would be what is the best option for > > performance? This portion of the app currently doesn't have any session > > functionality built in. I would be setting up the session for this sole > > purpose. I haven't worked with cookies yet. I suppose the URL method > might > > work, I have just never like it because I think it looks unclean, just > > personal preference there. > > As to the $td question... This is a variable that holds the userid > > of the "Technical Director" who is the account approver. This portion of > > the app is simply an approval mechanism to an account request system that > I > > am developing. The "TD" receives an e-mail with a link back to the > approval > > page to approve the requested accounts. This approval then fires off an > > e-mail to the SA responsible for user accounts to inform him to create the > > newly approved account. > > Well, thanks again for the feedback. Hopefully I can get this going > > pretty quick. We are currently planning on rolling this app out to our > user > > community on Monday. This is the last issue I have that I am aware of. > > > > -----Original Message----- > > From: CPT John W. Holmes [mailto:holmes072000@charter.net] > > Sent: Thursday, June 05, 2003 9:06 AM > > To: NIPP, SCOTT V (SBCSI); jay@advmed.com > > Cc: php-db@lists.php.net > > Subject: Re: Datetime help in an INSERT... > > > > > > > I have actually discovered that the $td value is blank. The reason > > > appears to be that the page is reloading when a button is pushed, and > that > > > is when the $td value is being lost. My question now is, how do I keep > > the > > > $td value after the page is reloaded? I would rather keep the value > from > > > the original query than perform another database query to populate this > > > value yet again. Thanks yet again for the help. > > > > Stick it in the session? cookie? URL? What is $td? > > > > ---John Holmes... > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
