Aaron
Posts: 145
|
| Posted: 06/02/2004, 8:30 AM |
|
I have a search page that will allow the user to search for people by name, zip code, state, etc. The results get listed and the results get linked by the person's name with a link called indID. The individual's ID number (auto-incremented when new people are added) is what ties all the related tables together.
Anyway, the user can click on a persons name and is taken to a page with all their details (address, phone numbers, e-mail, etc). On that page they are able to click another link and go to a page where they can add more information about the person or change that information. On that link, I have the link parameter on the Href Source that says the following:
Source Type: DataSource Column
Parameter source: indID
Parameter name: indID
With these in, I get a page that is
http://www.xxxxxxxx/xxxx.php?indID=
That's it. No ID number is inserted. BUT, if I go in the parameter name and change it to anything, literally, anything at all, the link in the page now becomes:
http://www.xxxxxxxx/xxxx.php?indID=22&anything=
So, the data source is now:
Source Type: DataSource Column
Parameter source: indID
Parameter name: anything
Where 22 is the correct indID number for a parameter that I did not enter as a parameter. What's going on with this? I think this is causing errors in another page, because when you click this link to add an option to that persons profile, the new page will display that the indID is correct, but on an add, the page will put in the database the indID of 0, not 22 as it was displaying.
I'm open to any help/suggestions here on this one... it's driving me up the wall.
Thanks.
Aaron
|
 |
 |
Aaron
Posts: 145
|
| Posted: 06/02/2004, 8:55 AM |
|
Ok, after a bit of experimentation, I've found that if I remove all passed parameters then it will put :
.php?indID=22
there all by itself. Odd, but whatever, right?
But I'm still on a problem with the next page. The linked page will display in a label field, the correct indID and has a dropdown to allow the selection of a value to set the persons status (active status, inactive, no longer there, etc) and a short memo field. On the update, it will add the information to the database, but the indID field (which the entry page displayed as #22) is set to 0 (zero).
Any thoughts?
|
|
|
|
peterr
Posts: 5971
|
| Posted: 06/02/2004, 12:51 PM |
|
Since indID is a label then it cannot be used to update a record. You could probably create another hidden field (indID_hidden) and in Before Update event set to it the value of the indID parameter, for example:
indID_hidden.Value = CCGetFromGet("indID",0)
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Aaron
Posts: 145
|
| Posted: 06/03/2004, 4:47 AM |
|
Many thanks. That was what it was!
Aaron
|
|
|
|
|
