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:[EMAIL PROTECTED]
Sent: Thursday, June 05, 2003 10:07 AM
To: NIPP, SCOTT V (SBCSI)
Subject: Re: [PHP-DB] 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)" <[EMAIL PROTECTED]>
To: "'CPT John W. Holmes'" <[EMAIL PROTECTED]>
Sent: Thursday, June 05, 2003 10:53 AM
Subject: RE: [PHP-DB] 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
> [EMAIL PROTECTED]
> [EMAIL PROTECTED]
>
> -----Original Message-----
> From: CPT John W. Holmes [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 05, 2003 9:53 AM
> To: NIPP, SCOTT V (SBCSI)
> Subject: Re: [PHP-DB] Datetime help in an INSERT...
>
>
> Propagating it in the URL is probably the best method.
>
> ---John Holmes...
>
> ----- Original Message -----
> From: "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]>
> To: "'CPT John W. Holmes'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Thursday, June 05, 2003 10:44 AM
> Subject: RE: [PHP-DB] 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:[EMAIL PROTECTED]
> > Sent: Thursday, June 05, 2003 9:06 AM
> > To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
> > Cc: [EMAIL PROTECTED]
> > Subject: Re: [PHP-DB] 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
