|
| |
|
|
adam2804
Posts: 34
Joined: 6/6/2006
Status: offline
 |
Problem with checkbox and variable - 6/6/2006 11:17:30
Hello,
This is my first post on this site, but have read a large number of posts and they have all helped me out a great deal. For the following problem I couldn't find any help, so some advice would be gratefully recieved.
I have a (FrontPage) page that a checkbox multiplies a number submitted by a certain figure. This figure can change depending on the site that the work takes place. Therefore I need to get the multiplier from the database (The multiplication of the number bit works fine). I can't seem to figure out how to get an integer back from the database.
Here's what I've got so far:
this is the query bit:
<% uploadind = fp_sQry="SELECT TB_Site.UpliftMultiplier FROM TB_Site INNER JOIN Customers ON TB_Site.ID = Customers.SiteID INNER JOIN Jobs ON Customers.CustomerID = Jobs.CustomerID WHERE (Jobs.JobNumber = ::JobNumber::)" %>
then here's my checkbox bit:
<input type="checkbox" name="Uplift" value=<%=uploadind%> checked>
Thank you in advance for your help.
Kind Regards,
Adam
|
|
|
|
adam2804
Posts: 34
Joined: 6/6/2006
Status: offline
|
RE: Problem with checkbox and variable - 6/7/2006 5:57:04
quote:
results part of the DRW you would assign the output to a variable
Thanks Spooky,
I've setup my DRW now and used the query there, which is fine.
But can't seem to see where to assign a variable to the results?
Sorry, but I've not really used frontPage before, but have got to now as it's what the company uses!
Thanks,
Adam
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
k¥ 
