Fixer
Posts: 18
|
| Posted: 02/23/2005, 8:28 AM |
|
I'm not sure if this is the best way to go about it but -
I have MySQL as part of my web host package. I created a table there with fields such as serial number, make, model, etc.
I used CodeCharge Studio Personal 2.3 to create a page online showing those records. I want to add a button at the end of each record row that will lauch a form where people enter personal info which then submits in an email to me , however, I want the data from the related record where the button was clicked to be in the reponse form so I know which item they are requesting. Any ideas?
|
 |
 |
Fixer
Posts: 18
|
| Posted: 02/23/2005, 12:53 PM |
|
Fixer, Have you tried using something like a DLookup on click for that button?
|
|
|
|
Fixer
Posts: 18
|
| Posted: 02/23/2005, 1:04 PM |
|
actually I am trying that. I just don't know how to make it retrieve the exact row for the button that was clicked, then tell it to put that record into a form mail- actually I'm not sure what the hell I'm doing- the app is very slick I'm just not familiar with it and a couple of hints or tips usually gets the ball rolling. In design view I see the fields in a row, I added a button to the end of the row, so now that button and it's qualities are in every row, I just can't seem to get to the next step of retaining the specific row for the button clicked, and then what to do with the results even if. Unfortunateley I'm limited to the CodeCharge gui since my code skills are weak and anemic. With Access forms I would use cool macros and nice graphical queries- but here (for now), I'm stuck
|
|
|
|
Fixer
Posts: 18
|
| Posted: 02/23/2005, 1:09 PM |
|
Fixer, I hope someone can help you- I know the people in this forum are very knowledgable and very helpful, but I don't think they appreciate holding peoples hands through what should be a very basic task. Good luck nonetheless and I hope the tyrants you work for give you the time you need to complete this all important time sensitive project., especially considering all the other IT tasks you juggle. 
|
|
|
|
peterr
Posts: 5971
|
| Posted: 02/23/2005, 1:11 PM |
|
I think that you don't need a real button, as it could be more difficult to implement than you want. Just use a standard link (or an image link with an image that looks like a button). Almost every tutorial and example that we have is using such links in grid rows, so that users can click on the link and edit the information. In your case you can point the link to a new page where users will enter their information. In the link's "Href Source" property you can specify which field values from the current row you'd like to pass to the next page. You can then display those values on the new page using several methods. You may try the "Retrieve Value for Control" action.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Fixer
Posts: 18
|
| Posted: 02/24/2005, 3:29 AM |
|
That's good stuff- thanks for the tip- I'll give it a shot
|
|
|
|
Fixer
Posts: 18
|
| Posted: 02/24/2005, 9:19 AM |
|
Quote peterr:
I think that you don't need a real button, as it could be more difficult to implement than you want. Just use a standard link (or an image link with an image that looks like a button). Almost every tutorial and example that we have is using such links in grid rows, so that users can click on the link and edit the information. In your case you can point the link to a new page where users will enter their information. In the link's "Href Source" property you can specify which field values from the current row you'd like to pass to the next page. You can then display those values on the new page using several methods. You may try the "Retrieve Value for Control" action.
I replaced the button with a text link. I tried to set the "Href Source" for the link but am only able to find "Href" (under the format tab) and it has the link info already in it- Is it Data Source under the data tab that I need to set to the specific field? Also, when setting the "Retrieve Value for Control" action on the next page I'm using ".$myformname->myfieldname->GetValue(); under Source Name, Source Type is expression, and Control Name is set to the actual control I want this data put into- I assume all this under page, server, before show, action, but it's not working, I guess because of the previous HrefSource issue.
|
|
|
|
peterr
Posts: 5971
|
| Posted: 02/24/2005, 10:06 AM |
|
I suspect that you created an HTML link, rather than a link component. Make sure that you add the link from the "Forms" section in the Toolbox. Then you should see the "Href Source" property in the Data tab.
Also see http://docs.codecharge.com/studio/html/Components/Prope...HrefSource.html
When using the "Retrieve Value for Control" action, you will need something like this:
Control Name: a field/control that you want to populate on your new form
Source Type: URL
Soutce Name: myfieldname
(you should see myfieldname in your URL after clicking on that link)
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Fixer
Posts: 18
|
| Posted: 02/25/2005, 6:06 AM |
|
this is becoming difficult- even though it's an easy task. I have one page which is a non-editable grid- it reports serial number, make model, etc. First, I add a link (from the forms section) to the end of the existing grid, I then choose href source- For Link Type I choose "page", for destination I type in the full url of the next page (Submission page with just text boxes of name, address, phone, and a text box for serial- no tables behind it just plain text boxes) for Link Parameter I'm trying to choose "serial", but it's not there- every other field in the grid is though. Also, after publishing to the web, the grid with all the data comes up fine- but the spot where I put the link is empty- no link.
|
|
|
|
Fixer
Posts: 18
|
| Posted: 02/25/2005, 7:28 AM |
|
somehow I sort of got a little further- apparently codecharge doesn't consider a text box a control unless it's in a form or something. I'm still not getting the option to carry data from the field I want- I was able to have it take the model number from the specific row and pop it into a box in another page (finally some progress), but not the field I want (Serial)- It won't show "serial" as a choice (in Parameter Source of Link Parameters under Href Source), only the other fields- could it possibly be because serial is a primary key? so what?
|
|
|
|
|
